Project Wizard includes an extension package (M4APS_PW_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 when uploading, see the example code below.
Note: We can use extension package to validate Tasks only.
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 pw_install.zip file are the files M4APS_PW_EXTENSION.pkb and M4APS_PW_EXTENSION.pks. Make the necessary changes to the VALIDATE_TASK procedure. Compile the package into a test instance and test your code updates thoroughly before compiling it into your production instance.
Examples for Extension Package
/* Example 1 - Error. */
if p_attribute1 = 'Wrong' then
p_status := 'E';
p_message := 'Attribute1 has the wrong value. This Task is rejected';
end if;
/* Example 2 - Warning. */
if p_attribute1 = 'Dodgy' then
p_status := 'W';
p_message := 'Attribute1 is a bit dodgy but will be accepted unless you abort the upload now';
end if;
Note: The use of the extension package is controlled by the profile option ‘More4Apps: PW Call Validation Extension’. This profile is turned off by default. When set to ‘Yes’ it allows the customer to utilize the extension package.
