Extension Package
Purpose of the Extension Package
Sales Order Wizard includes an extension package (M4APS_SOW_EXTENSION) that you can modify to meet your unique validation requirements.
It is automatically installed by the Wizard if it doesn’t already exist in your instance and will contain no additional code at this point in time.
The Wizard will always callout to this package, however modifying the extension package is optional.
You can choose to have the extension package return an Error, either when validating or uploading, see the example code below.
Modify the Extension Package
Modifying the extension package will require technical knowledge of PL/SQL (i.e. a developer or DBA resource) as well as functional knowledge to determine the logic.
Included in the sow_install.zip file are the files (M4APS_SOW_EXTENSION.pkb and M4APS_SOW_EXTENSION.pks). Make the necessary changes to the procedure. Compile the package into a test instance and test your code updates thoroughly before compiling it into your production instance.
Note: The use of the extension package is controlled by the profile option More4Apps: SOW Enable Extension Pkg. This profile is turned off by default. When set to ‘Yes’ it allows the customer to utilize the extension package.
Example Code to return a Warning message to the Wizard
IF h_rec.order_type_id = 1000 THEN
h_rec.price_list_id = 123;
x_message := 'Price List determined by Order Type';
END IF;
Example:
