Purpose of the Extension Package
Pricing Modifier Wizard includes an extension package (M4APS_PMW_EXTENSION) that you can modify to meet your unique validation requirements.
This extension package is included in the release pmw_Install.zip file. You only install this package if you need customization in Pricing Modifiers Wizard.
The Wizard will always callout to this package, however modifying the extension package is optional.
This extension package procedure does nothing by default. Modify it as required.
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.
Examples for Extension Package
Example 1 - Post insert processing showing exclusion due to org id.
API will NOT be called as x_status has been set to E.
IF p_org_id = 204 THEN
x_status := 'E';
x_message := 'You are NOT allowed to load invoices';
END IF;
Example 2 - Modify a header parameter showing a forced price list for a specific order type. API will be called with the new price list when specific order type is supplied. Note that the spreadsheet will NOT reflect the new data, however the x_message may be used to notify the user.
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 3 - Looping through line records.
DECLARE
l_index NUMBER;
BEGIN
IF l_xref_tbl.count > 0 THEN
FOR l_index IN 1..l_xref_tbl.COUNT
LOOP
IF SUBSTR(l_xref_tbl(l_index).cross_reference,1,5) <> SUBSTR(l_inventory_item_number,1,5) THEN
x_status := 'E';
x_message := 'Cross reference format is invalid: ' || l_xref_tbl(l_index).cross_reference;
END IF;
END LOOP;
END IF;
END;
Example 4 - Return modifier number.
SELECT DECODE(fnd_global.org_id,1245,'USA',18603,'KOR',15703,'AUS',25942,'GTS',51662,'GKK',28882,'GFEC',99682,'WK',2049, 'CPNA',NULL)
||xxqp_get_modifier_num.nextval INTO P_MODIFIER_LIST_rec.name
FROM dual;
/*==========================================
NB: Do NOT modify any code below this line!
==========================================*/
RETURN;
Note: The use of the extension package is controlled by the profile option ‘More4Apps: PMW Enable Extension Pkg’. This profile is turned off by default. When set to ‘Yes’ it allows the customer to utilize the extension package.
