Events That Can Be Captured Using CUSTOM.pll

All the forms in Oracle Applications send the following triggering events to CUSTOM.pll:

·         SPECIAL1-45

·         WHEN-NEW-FORM-INSTANCE

·         WHEN-NEW-BLOCK-INSTANCE

·         WHEN-NEW-RECORD-INSTANCE

·         WHEN-NEW-ITEM-INSTANCE

·         WHEN-VALIDATE-RECORD [Most forms]

Working on CUSTOM.pll with an example

Requirement: change the Executable field into uppercase within the Concurrent Program Executable screen

Follow these steps to make the Executable field uppercase using CUSTOM.pll:

1.    Enable show custom events: Log in to the Application Developer responsibility and enable Show Custom Events. Check the blog post for enabling custom events: http://oracleapps4u.blogspot.in/2012/03/how-to-enable-custom-events-for-oracle.html

How to enable custom events for an oracle form

Custom events can be enabled through the below navigation:

Once you enable show custom events, oracle will display the name of each and every event that can be trapped using CUSTOM.pll. Using this technique, you can identify the custom event that you need to trap to achieve the desired result.