Custom.pll – Customizing Oracle Application

 CUSTOM.pll is used to add extensions to Oracle Application's form Functionality and can be used for ...

1. Enabling/Disabling the fields
2. Changing the List of Values in a LOV field at runtime
3. Defaulting values
4. Additional record level validations
5. Navigation to other screens
6. Enabling Special Menu

7. Validations

Where is this located?

Custom.pll is located in $AU_TOP/resource Directory.

How to add code ?

Open this pll using the Form builder and make changes to the program units.

How to compile ?

 Once you make changes you need to compile the pll. Use the F60gen to compile it

f60gen module=custom.pll userid=APPS/ output_file=$AU_TOP/resource/custom.plx module_type=library batch=no compile_all=special

Restriction
CUSTOM.pll is a single file/entity, hence only one developer can make changes to CUSTOM.pll at any given point in time

Events that calls custom.pll
WHEN–FORM–NAVIGATE
WHEN–NEW–FORM–INSTANCE
WHEN–NEW–BLOCK–INSTANCE
WHEN–NEW–RECORD–INSTANCE
WHEN–NEW–ITEM–INSTANCE
WHEN–VALIDATE–RECORD

Sample Code 
Modify the code CUSTOM package body as follows in the appropriate sections

procedure event(event_name varchar2) is

form_name varchar2(30) := name_in(‘system.current_form’);

block_name varchar2(30) := name_in(‘system.cursor_block’);

item_name varchar2(30) := name_in(‘system.cursor_item’); 

Begin

if (form_name = ‘OEXOEORD’and block_name = ‘ORDER’) then

   if LENGTH(name_in(‘ORDER.CUST_PO_NUMBER’)) > 3 then

     fnd_message.set_name(‘FND’,’Cust PO Number should be less than 4 digits’);

     fnd_message.Error;

     RAISE FORM_TRIGGER_FAILURE;

   End if;

End if;

End Event;