Sponsored Links
Oracle Apps Tutorials
- Oracle Reports 6i
- Oracle Apps 11i : Asset Management - Journal Entries
- Oracle Apps 11i : Asset Management - Retirements
- Oracle Apps 11i : Asset Management - Depreciation
- Oracle Apps 11i : Asset Management - Mass Transfers
- Oracle Apps 11i : Asset Management - Asset Adjustments
- Oracle Apps 11i : Asset Management - Mass Additions
- Oracle Apps 11i : Asset Management - Manual and Quick Additions
- Oracle Apps 11i : Asset Management - Asset Books Regions
- Oracle Apps 11i : Asset Management - Asset Book Positioning
- Oracle Apps 11i : Suppliers
- Oracle Apps 11i : Creating Journals through Oracle GL
- Oracle Apps Sys Admin - Users and Responsibilities
- Oracle Apps 11i: Setting up Chart Of Accounts (COA)
- Registering New Forms in Oracle Apps 11i
- Creation of Master Detail Block in Oracle Apps 11i
- Creating New Forms in Oracle Apps 11i
- Special Triggers in the Template Form in Oracle Apps 11i
- Oracle Apps Template Form
- Oracle Apps Implementing Key Flex field and Descriptive Flex field
Tutorials
Oracle AppsSpecial Triggers in the Template Form in Oracle Apps 11i
Table of Contents
Special Triggers in the Template Form in Oracle Apps 11i
Special Triggers in the Template Form in Oracle Apps 11i - Page 2Special Triggers in the Template Form in Oracle Apps 11i
Oracle Apps 11i : 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.
Next Page: Special Triggers in the Template Form in Oracle Apps 11i - Page 2
Comments
furkanalam said:
| Good one |
Nguyen Duc Hai said:
|
That tutor is great!! Thanks in advance!!! |
SUNIL said:
| Tutor is great!!!! |
ganesh said:
| great |
venkatesh said:
| we can learn every thing without a tutor by looking all these.woww its great |
Sponsored Links
