Special Triggers in the Template Form in Oracle Apps 11i

This document provides an overview of the Special Triggers in the Template Form. The template form contains many form level triggers. These triggers are required for the proper operation of other routines. They are also aid in making the form respond to and behave properly in case of standard events. These triggers must not be deleted or to ensure the proper functioning of the form. Also, code can be added to these triggers but, the existing text must not be deleted.

Figure: 3 Template Form triggers

These triggers are listed below:

• KEY–CLRFRM
• KEY–COMMIT
• KEY–DUPREC
• KEY–EDIT
• KEY–EXIT
• KEY–HELP
• KEY–LISTVAL
• KEY–MENU
• ON–ERROR
• POST–FORM
• PRE–FORM
• WHEN–FORM–NAVIGATE (reference)
• WHEN–NEW–BLOCK–INSTANCE
• WHEN–NEW–FORM–INSTANCE
• WHEN–NEW–ITEM–INSTANCE
• WHEN–NEW–RECORD–INSTANCE
• WHEN–WINDOW–CLOSED
• WHEN–WINDOW–RESIZED

User–Named Triggers:

• ACCEPT
• CLOSE_THIS_WINDOW (reference)
• CLOSE_WINDOW
• EXPORT (referenced)
• FOLDER_ACTION
• FOLDER_RETURN_ACTION
• LASTRECORD (reference)
• MENU_TO_APPCORE (reference)
• QUERY_FIND
• STANDARD_ATTACHMENTS (reference)
• ZOOM (reference)

You cannot change triggers that are referenced into the form.

Triggers That Often Require Some Modification

ACCEPT: This trigger is executed when ‘Action, Save and Proceed’ menu choice is invoked. It saves and moves to the next record of the block specified as the First Navigation Block.

KEY–DUPREC: This trigger disables the default duplicate record functionality of Oracle Forms.

KEY–CLRFRM: This trigger validates the record before attempting to clear the form.

KEY–LISTVAL: This trigger is invoked when the LOV is invoked / in case of flexfield operations.

ON–ERROR: This trigger is executed when an error occurs and it processes all errors, server or client side, using Message Dictionary calls.

WHEN–NEW–FORM–INSTANCE: This trigger as executed when a new form is opened.

WHEN–NEW–RECORD–INSTANCE: This trigger is executed when the cursor navigates to a new record.

WHEN–NEW–BLOCK–INSTANCE: This trigger is executed when the cursor navigates to a new block.

WHEN–NEW–ITEM–INSTANCE: This trigger is executed when the cursor navigates to a new field.

Triggers That Cannot Be Modified

Oracle Applications does not support the modification of the following form–level triggers in any way.

CLOSE_THIS_WINDOW: This trigger invokes APP_CUSTOM.CLOSE_WINDOW from the menu Action–>Close Window.

CLOSE_WINDOW: This trigger processes all window close events. Code that processes the close window events must reside in the APP_CUSTOM.CLOSE_WINDOW package

EXPORT: This trigger processes invocation of the”Action, Export” menu choice.

FOLDER_ACTION: This trigger processes invocation of entries on the Folder menu.

EXPORT: This trigger processes invocation of the”Action, Export” menu choice.

FOLDER_ACTION: This trigger processes invocation of entries on the Folder menu.

KEY–COMMIT: This trigger processes commits in normal or called forms.

KEY–EDIT: This trigger performs flexfield operations, or Calendar or Editor Invocation.

KEY–EXIT: This trigger processes Close events, and leaves enter–query mode.

KEY–HELP: This trigger invokes the Window Help system.

LASTRECORD: This trigger processes the menu event Go–>Last Record.

MENU_TO_APPCORE: This trigger supports the Special menu.

STANDARD_ATTACHMENTS: This trigger processes invocation of the Attachments menu entry or toolbar button.

WHEN–WINDOW–CLOSED: This trigger centralizes window close events from the Oracle Applications or Window Manager menu.