Oracle
Forms trigger execution order
Form Trigger priority
item, to block, to the form level, If another to set Execution HIERARCH
property (override, before, after), in accordance with the order set. If the
override is executed to finish this level triggers do not perform up before is
executed after this trigger level, if the upper level of this flip-flop also
continue to perform, is to go after perform on a level trigger, then come back
and perform. Feeling trigger more difficult to understand or each of the
trigger to fire, and in the development of how to use. Current understanding of
the flip-flop is pre-..., when-new-...-instance, when-...-validate, post-query
and several on-...
Action Trigger Firing Order Level
------ -------------------- -----
Runform 1. Pre-Logon Form
2. On-Logon Form
3. Post-Logon Form
4. Pre-Form Form
5. When-Create-Record Block
6. Pre-Block Block
7. Pre-Record Block
8. Pre-Text-Item Item
9. When-New-Form-Instance Form
10. When-New-Block-Instance Block
11. When-New-Record-Instance Block
12. When-New-Item-Instance Item
***********
Enter Query 1. Post-Text-Item Item
2. Post-Record Block
3. When-Clear-Block Block
4. When-New-Record-Instance Block
5. When-New-Item-Instance Item
Note: If you define the Key-ENTQRY trigger, this is the only trigger
which fires in an Enter Query situation.
*****************
Execute Query
After Enter Query 1. Pre-Query Block
2. Pre-Select Block
3. On-Select Block
4. When-Clear-Block Block
5. Post-Select Block
6. On-Fetch Block
7. On-Close Form
8. When-Clear-Block Block
Note: If you define the Key-EXEQRY trigger, this is the only trigger
which fires in an Execute Query situation.
*************
Execute Query
Without Enter
Query 1. Post-Text-Item Block
2. Pre-Query Block
3. Pre-Select Block
4. On-Select Block
5. Post-Select Block
6. On-Fetch Block
7. On-Close Form
8. When_Create_Record Block
9. Pre-Record Block
10. Pre-Text-Item Item
11. When-New-Record-Instance Block
12. When-New-Item-Instance Item
****
Exit 1. Post-Text-Item Item
2. Post-Record Block
3. Post-Block Block
4. Post-Form Form
5. On-Rollback Form
6. Pre-Logout Form
7. On-Logout Form
8. Post-Logout Form
**************
Next Field and
Previous field 1. When-New-Item-Instance Item
***************
Next Record and
Previous Record 1. When-New-Record-Instance Block
2. When-New-Item-Instance Item
**************
Next Block and
Previous Block 1. Post-Text-Item Item
2. Post-Record Block
3. Post-Block Block
4. When-Create-Record Block
5. Pre-Block Block
6. Pre-Record Block
7. Pre-Text-Item Block
8. When-New-Block-Instance Block
9. When-New-Record-Instance Block
10. When-New-Item-Instance Form
*******************
Records Are Queried 1. Post-Query Block
2. Post-Change Block
3. Post-Change Item
4. Post-Change Block
5. Post-Change Block
Go back to Post-Query
NOTE: This cycle is repeated for each record retrieved.
**********************
No Records Are Queried 1. When-New-Record-Instance Block
2. When-New-Item-Instance Item
NOTE: To observe this Trigger Firing Order:
a. Enter a query.
b. Enter a nonexistent record.
c. Execute the query.
The two triggers listed above, the Enter Query triggers, and
the Execute Query triggers fire.
*************
Create Record 1. Post-Change Block
2. When-Validate-Item Block
3. Post-Text-Item Block
4. When-Validate-Record Block
5. Post-Record Block
6. Post-Block Block
7. On-Savepoint Form
8. Pre-Commit Form
9. Pre-Insert Block
10. On-Insert Form
11. Post-Insert Block
12. Post-Forms-Commit Form
13. On-Commit Form
14. Post-Database-Commit Form
15. Pre-Block Block
16. Pre-Record Block
17. Pre-Text-Item Block
18. When-New-Item-Instance Form
*************
Update Record 1. When-Database-Record Block
2. Post-Change Block
3. When-Validate-Item Block
4. Post-Text-Item Block
5. When-Validate-Record Block
6. Post-Record Block
7. Post-Block Block
8. On-Savepoint Form
9. Pre-Commit Form
10. Pre-Update Block
11. On-Update Block
12. Post-Update Block
13. Post-Forms-Commit Form
14. On-Commit Form
Here the transaction is complete and one record added.
15. Post-Database-Commit Form
16. Pre-Text-Item Block
17. When-New-Item-Instance Form
NOTE: To observe this Trigger Firing Order:
a. Execute a query.
b. Change a value.
c. Choose Action->Save from the menu.
d. Record the triggers from that point.
*************
Delete Record 1. On-Lock Block
2. When-Remove-Record Block
3. Post-Change Block
4. Post-Change Block
5. Post-Change Block
6. Post-Change Block
7. Post-Change Block
8. Post-Change Block
9. Post-Change Item
10. Post-Query Block
11. Post-Text-Item Block
12. Post-Record Block
13. Pre-Record Block
14. Pre-Text-Item Block
15. When-New-Record-Instance Block
16. When-New-Item-Instance Form
------ -------------------- -----
Runform 1. Pre-Logon Form
2. On-Logon Form
3. Post-Logon Form
4. Pre-Form Form
5. When-Create-Record Block
6. Pre-Block Block
7. Pre-Record Block
8. Pre-Text-Item Item
9. When-New-Form-Instance Form
10. When-New-Block-Instance Block
11. When-New-Record-Instance Block
12. When-New-Item-Instance Item
***********
Enter Query 1. Post-Text-Item Item
2. Post-Record Block
3. When-Clear-Block Block
4. When-New-Record-Instance Block
5. When-New-Item-Instance Item
Note: If you define the Key-ENTQRY trigger, this is the only trigger
which fires in an Enter Query situation.
*****************
Execute Query
After Enter Query 1. Pre-Query Block
2. Pre-Select Block
3. On-Select Block
4. When-Clear-Block Block
5. Post-Select Block
6. On-Fetch Block
7. On-Close Form
8. When-Clear-Block Block
Note: If you define the Key-EXEQRY trigger, this is the only trigger
which fires in an Execute Query situation.
*************
Execute Query
Without Enter
Query 1. Post-Text-Item Block
2. Pre-Query Block
3. Pre-Select Block
4. On-Select Block
5. Post-Select Block
6. On-Fetch Block
7. On-Close Form
8. When_Create_Record Block
9. Pre-Record Block
10. Pre-Text-Item Item
11. When-New-Record-Instance Block
12. When-New-Item-Instance Item
****
Exit 1. Post-Text-Item Item
2. Post-Record Block
3. Post-Block Block
4. Post-Form Form
5. On-Rollback Form
6. Pre-Logout Form
7. On-Logout Form
8. Post-Logout Form
**************
Next Field and
Previous field 1. When-New-Item-Instance Item
***************
Next Record and
Previous Record 1. When-New-Record-Instance Block
2. When-New-Item-Instance Item
**************
Next Block and
Previous Block 1. Post-Text-Item Item
2. Post-Record Block
3. Post-Block Block
4. When-Create-Record Block
5. Pre-Block Block
6. Pre-Record Block
7. Pre-Text-Item Block
8. When-New-Block-Instance Block
9. When-New-Record-Instance Block
10. When-New-Item-Instance Form
*******************
Records Are Queried 1. Post-Query Block
2. Post-Change Block
3. Post-Change Item
4. Post-Change Block
5. Post-Change Block
Go back to Post-Query
NOTE: This cycle is repeated for each record retrieved.
**********************
No Records Are Queried 1. When-New-Record-Instance Block
2. When-New-Item-Instance Item
NOTE: To observe this Trigger Firing Order:
a. Enter a query.
b. Enter a nonexistent record.
c. Execute the query.
The two triggers listed above, the Enter Query triggers, and
the Execute Query triggers fire.
*************
Create Record 1. Post-Change Block
2. When-Validate-Item Block
3. Post-Text-Item Block
4. When-Validate-Record Block
5. Post-Record Block
6. Post-Block Block
7. On-Savepoint Form
8. Pre-Commit Form
9. Pre-Insert Block
10. On-Insert Form
11. Post-Insert Block
12. Post-Forms-Commit Form
13. On-Commit Form
14. Post-Database-Commit Form
15. Pre-Block Block
16. Pre-Record Block
17. Pre-Text-Item Block
18. When-New-Item-Instance Form
*************
Update Record 1. When-Database-Record Block
2. Post-Change Block
3. When-Validate-Item Block
4. Post-Text-Item Block
5. When-Validate-Record Block
6. Post-Record Block
7. Post-Block Block
8. On-Savepoint Form
9. Pre-Commit Form
10. Pre-Update Block
11. On-Update Block
12. Post-Update Block
13. Post-Forms-Commit Form
14. On-Commit Form
Here the transaction is complete and one record added.
15. Post-Database-Commit Form
16. Pre-Text-Item Block
17. When-New-Item-Instance Form
NOTE: To observe this Trigger Firing Order:
a. Execute a query.
b. Change a value.
c. Choose Action->Save from the menu.
d. Record the triggers from that point.
*************
Delete Record 1. On-Lock Block
2. When-Remove-Record Block
3. Post-Change Block
4. Post-Change Block
5. Post-Change Block
6. Post-Change Block
7. Post-Change Block
8. Post-Change Block
9. Post-Change Item
10. Post-Query Block
11. Post-Text-Item Block
12. Post-Record Block
13. Pre-Record Block
14. Pre-Text-Item Block
15. When-New-Record-Instance Block
16. When-New-Item-Instance Form
------------------More detailed explanation --------------------------
Trigger execution
order:
1. When you open the FORM:
(1) Pre-form
(2) PRE-block
(BLOCK-level)
(3) WHEN-NEW-FORM-INSTANCE
(4)
WHEN-NEW-BLOCK-INSTANCE
(5)
WHEN-NEW-RECORD-INSTANCE
(6)
WHEN-NEW-ITEM-INSTANCE
2. When the the
fill line recording is completed, the cursor moves to the next record when:
(1)
WHEN-VALIDATE-RECORD
(Only fill out the records in the database record for verification only, if only the data on the page repetitive and not in the database and its duplicate values ??will not complain.)
(Only fill out the records in the database record for verification only, if only the data on the page repetitive and not in the database and its duplicate values ??will not complain.)
(2)
WHEN-NEW-RECORD-INSTANCE
(3)
WHEN-NEW-ITEM-INSTANCE
3. When click
"Save"
(1)
WHEN-VALIDATE-RECORD
(All data on the page is submitted to the database, the page duplicate data, shall be submitted to the first successful but only the data written to the database in a similar place of temporary table, in the submission of the second duplicate records time error, perform the transaction is rolled back, the original successful implementation of the directive will be undone)
(All data on the page is submitted to the database, the page duplicate data, shall be submitted to the first successful but only the data written to the database in a similar place of temporary table, in the submission of the second duplicate records time error, perform the transaction is rolled back, the original successful implementation of the directive will be undone)
(2) PRE-INSERT
(3) ON-INSERT
(4) POST-INSERT
(5) POST-FORMS-COMMIT
(6) PRE-block
(BLOCK-level)
(7) KEY-COMMIT
(8)
WHEN-NEW-ITEM-INSTANCE
4. When the
cursor moves to the already displayed in the current data block on the line:
(1) WHEN-REMOVE-RECORD
(2)
WHEN-NEW-RECORD-INSTANCE
(3)
WHEN-NEW-ITEM-INSTANCE
When the movement of
the line ITEM:
(4)
WHEN-NEW-ITEM-INSTANCE
5. When to be
modified (modified) on an item in the record:
(1) ON-LOCK
6. Save the
modification is complete:
(1)
WHEN-VALIDATE-RECORD
(2) PRE-UPDATE
(3) ON-UPDATE
(4) POST-FORMS-COMMIT
(5) PRE-block
(BLOCK-level)
(6) KEY-COMMIT
(7)
WHEN-NEW-ITEM-INSTANCE
7. Delete a
record:
(1) ON-LOCK
(2) WHEN-REMOVE-RECORD
(3) Key-DELREC
(4)
WHEN-NEW-RECORD-INSTANCE
(5)
WHEN-NEW-ITEM-INSTANCE
8. Process of F11
inquiries:
(1) WHEN-CLEAR-BLOCK
(2)
WHEN-NEW-RECORD-INSTANCE
(3)
WHEN-NEW-ITEM-INSTANCE
Point in the input
query conditions CTRL + F11:
(4) Pre-QUERY
(5) WHEN-CLEAR-BLOCK
(6) POST-QUERY
(7)
WHEN-NEW-RECORD-INSTANCE
(8)
WHEN-NEW-ITEM-INSTANCE
9. CRRL + F11:
(1) WHEN-CLEAR-BLOCK
(2) PRE-QUERY
(3) WHEN-CLEAR-BLOCK
(4) POST-QUERY (each
check a record, trigger time)
(5)
WHEN-NEW-RECORD-INSTANCE
(6)
WHEN-NEW-ITEM-INSTANCE
10. From the
query status (F11) to the input state (F4):
(1) WHEN-CLEAR-BLOCK
(2) Key-EXIT
(3)
WHEN-NEW-RECORD-INSTANCE
(4)
WHEN-NEW-ITEM-INSTANCE
11. Process
flashlight query:
(1) QUERY_FIND
(block-level)
The query is entered, click
"Search" button:
(2) WHEN-CLEAR-BLOCK
(3) PRE-QUERY
(4) WHEN-CLEAR-BLOCK
(5) POST-QUERY
(6)
WHEN-NEW-RECORD-INSTANCE
(7)
WHEN-NEW-ITEM-INSTANCE
12. Click the
"New" when:
(1)
WHEN-NEW-RECORD-INSTANCE
(2)
WHEN-NEW-ITEM-INSTANCE
13. Time click
"EditField":
(1) KEY-EDIT
14. Click the
WindowHelp:
(1) Key-HELP
15. Time click
"ClearRecord":
(1) WHEN-REMOVE-RECORD
(2) POST-QUERY
(3)
WHEN-NEW-RECORD-INSTANCE
(4)
WHEN-NEW-ITEM-INSTANCE
16. Click F4 off:
(1) Key-EXIT
(2) POST-form
17. Click "closeForm"
button is turned off:
(1) Key-EXIT
(2) POST-form
18. Click on the
"Translations" button:
(1) Translations
19. Click on the
small cross off:
(1) WHEN-WINDOW-CLOSED
(2) CLOSE-WINDOW
(3) Key-EXIT
(4) POST-form
20. Select the
LOV list:
(1) Key-LISTVAL
(2)
WHEN-NEW-ITEM-INSTANCE
21. Select the
record in front of the strip:
(1)
WHEN-NEW-RECORD-INSTANCE
(2)
WHEN-NEW-ITEM-INSTANCE (data item level)
(3)
WHEN-NEW-ITEM-INSTANCE
22. Cursor moves
up and down:
(1)
WHEN-NEW-RECORD-INSTANCE
(2) WHEN-NEW-ITEM-INSTANCE
The Tag label:
Triggers in Oracle Forms
Triggers are blocks of
PL / SQL code that are written to perform tasks when a specific event occurs
within an application. In effect, an Oracle Forms trigger is an event-handler
written in PL / SQL to augment (or occasionally replace) the default processing
behavior. Every trigger has a name, and contains one or more PL / SQL
statements. A trigger encapsulates PL / SQL code so that it can be associated
with an event and executed and maintained as a distinct object.
Block Processing Triggers:
Block processing
triggers fire in response to events related to record management in a block.
·
When-Create-Record Perform an action whenever Oracle Forms
attempts to create a new record in a block.
·
When-Clear-Block Perform an action whenever Oracle Forms
flushes the current block; that is, removes all records from the block.
·
When-Database-Record Perform an action whenever Oracle Forms
changes a record's status to Insert or Update, thus indicating that the record
should be processed by the next COMMIT_FORM operation.
Interface Event Triggers:
Interface event
triggers fire in response to events that occur in the form interface. Some of
these triggers, such as When-Button-Pressed, fire only in response to operator
input or manipulation. Others, like When-Window-Activated, can fire in response
to both operator input and programmatic control.
·
When-Button-Pressed Initiate an action when an operator
selects a button, either with the mouse or through keyboard selection.
·
When-Checkbox-Changed Initiate an action when the operator
toggles the state of a check box, either with the mouse or through keyboard
selection.
·
When-Image-Activated Initiate an action whenever the
operator double-clicks an image item.
·
When-Image-Pressed Initiate an action whenever an operator
clicks on an image item.
·
When-Radio-Changed Initiate an action when an operator
changes the current radio button selected in a radio group item.
·
When-Window-Activated Initiate an action whenever an operator
or the application activates a window.
·
When-Window-Closed Initiate an action whenever an operator
closes a window with the window manager's Close command.
·
When-Window-Deactivated Initiate an action whenever a
window is deactivated as a result of another window becoming the active window.
Master / Detail Triggers:
Oracle Forms generates
master / detail triggers automatically when a master / detail relation is
defined between blocks. The default master / detail triggers enforce
coordination between records in a detail block and the master record in a
master block. Unless developing custom block-coordination schemes, you do not
need to define these triggers.
·
On-Check-Delete-Master Fires when Oracle Forms attempts to
delete a record in a block that is a master block in a master / detail
relation.
·
On-Clear-Details Fires when Oracle Forms needs to clear
records in a block that is a detail block in a master / detail relation because
those records no longer correspond to the current record in
the master block.
·
On-Populate-Details Fires when Oracle Forms needs to fetch
records into a block that is the detail block in a master / detail relation so
that detail records are synchronized with the current record in the master
block.
Message-Handling Triggers:
Oracle Forms
automatically issues appropriate error and informational messages in response
to runtime events. Message handling triggers fire in response to these default messaging
events.
·
On-Error Replace a default error message with a
custom error message, or to trap and recover from an error.
·
On-Message To trap and respond to a message; for
example, to replace a default message issued by Oracle Forms with a custom
message.
Validation Triggers:
Validation triggers
fire when Oracle Forms validates data in an item or record. Oracle Forms
performs validation checks during navigation that occurs in response to
operator input, programmatic control, or default processing, such as a Commit
operation.
·
When-Validate-Item
·
When-Validate-Record
Navigational Triggers:
Navigational triggers
fire in response to navigational events. Navigational triggers can be further
sub-divided into two categories: Pre-and Post-triggers, and When-New-Instance
triggers. Pre-and Post-Triggers fire as Oracle Forms navigates internally
through different levels of the object hierarchy. When-New-Instance-Triggers
fire at the end of a navigational sequence that places the input focus on a
different item.
·
Pre-Form Perform an action just before Oracle
Forms navigates to the form from "outside" the form,
such as at form startup.
·
Pre-Block Perform an action before Oracle Forms navigates to
the block level from the form level.
·
Pre-Record Perform an action before Oracle Forms navigates to
the record level from the block level.
·
Pre-Text-Item Perform an action before Oracle Forms navigates to
a text item from the record level.
·
Post-Text-Item Manipulate an item when Oracle Forms
leaves a text item and navigates to the record level.
·
Post-Record Manipulate a record when Oracle Forms
leaves a record and navigates to the block level.
·
Post-Block Manipulate the current record when
Oracle Forms leaves a block and navigates to the form level.
·
Post-Form Perform an action before Oracle Forms
navigates to "outside" the form, such as when exiting the
form.
·
When-New-Form-Instance Perform an action at form start-up. (Occurs
after the Pre-Form trigger fires).
·
When-New-Block-Instance Perform an action immediately after the
input focus moves to an item in a block other than the block that previously
had input focus.
·
When-New-Record-Instance Perform an action immediately after the
input focus moves to an item in a different record.
·
When-New-Item-Instance Perform an action immediately after the
input focus moves to a different item.
Transactional Triggers:
Transactional triggers
fire in response to a wide variety of events that occur as a form interacts
with the data source.
·
On-Delete
·
On-Insert
·
On-Update
·
On-Logon
·
On-Logout
·
Post-Database-Commit
·
Post-Delete
·
Post-Insert
·
Post-Update
·
Pre-Commit
·
Pre-Delete
·
Pre-Insert
·
Pre-Update
Query-Time Triggers:
Query-time triggers
fire just before and just after the operator or the application executes a
query in a block.
·
Pre-Query Validate the current query criteria or
provide additional query criteria programmatically, just before sending the
SELECT statement to the database.
·
Post-Query Perform an action after fetching a
record, such as looking up values ??in other tables based on a value in the
current record. Fires once for each record fetched into the block.
Open, close, create,
update records trigger order
PRE-......
Into a form, or navigate to a new block trigger PRE-...... series of flip-flops are generally in the WHEN-NEW-......-instance before the series, if they fail, then it can not successfully navigate to the next an object, and can only stay in the current location. These triggers can be set to determine conditions to restrict whether you can navigate to the new location.
PRE-......
Into a form, or navigate to a new block trigger PRE-...... series of flip-flops are generally in the WHEN-NEW-......-instance before the series, if they fail, then it can not successfully navigate to the next an object, and can only stay in the current location. These triggers can be set to determine conditions to restrict whether you can navigate to the new location.
WHEN-NEW-......-instance
This type of trigger is when the mouse cursor each time fell to a new block, record, item on the trigger, and even if it fails, it will not happen error. But when-new-form-instance, only when the form starts, navigate the cursor to the first navigation block a navigation item triggered if an application has more than one Form, when the cursor conversion between the various form, does not trigger it.
This type of trigger is when the mouse cursor each time fell to a new block, record, item on the trigger, and even if it fails, it will not happen error. But when-new-form-instance, only when the form starts, navigate the cursor to the first navigation block a navigation item triggered if an application has more than one Form, when the cursor conversion between the various form, does not trigger it.
POST-TEXT-ITEM and WHEN-VALIDATE-ITEM
Post-text-item trigger point: When the input cursor from a Text-Item to other ITEM can use it to change the value of the item, when-Validate-item before leaving the trigger, but in a different role, Post -Text-Item itself is not verified, when-Validate-item can be used to add some authentication (in addition to verification form itself), but when the form validation is successful, the item flag will be 'valid', and will not go verified, when we go to modify its value, then there is likely to put an invalid value imported into the . Create and update a record, the first trigger When-Validate-Item trigger Post-Text-Item, then is the when-Validate-Record.
POST-...... series are to leave the current block, record, item triggered
WHEN-WINDOW-ACTIVATED
Do modify the attributes of raw materials platform, the first time you use this trigger to return from another window, refresh the current window, the code written on the flip-flop. Before use fnd_message.debug test, open the window pop Message. As long as the window during the event will not stop the implementation of the code of the trigger from the inside, so the implementation of the code should be used if conditions limit.
Do modify the attributes of raw materials platform, the first time you use this trigger to return from another window, refresh the current window, the code written on the flip-flop. Before use fnd_message.debug test, open the window pop Message. As long as the window during the event will not stop the implementation of the code of the trigger from the inside, so the implementation of the code should be used if conditions limit.
Form Trigger priority
item, to block, to the form level, If another to set Execution HIERARCH
property (override, before, after), in accordance with the order set. If the
override is executed to finish this level triggers do not perform up before is
executed after this trigger level, if the upper level of this flip-flop also
continue to perform, is to go after perform on a level trigger, then come back
and perform. Feeling trigger more difficult to understand or each of the
trigger to fire, and in the development of how to use. Current understanding of
the flip-flop is pre-..., when-new-...-instance, when-...-validate, post-query
and several on-...
Verification code
written in the WHEN-VALIDATE-RECORD PRE-INSERT different validation code
written in the WHEN-VALIDATE-RECORD and PRE-insert different
1, written in the WHEN-VALIDATE-RECORD, error, If the validation associated and the back-end database, then write in PRE-INSERT, because PRE-INSERT, ON-INSERT one by one records This batch entry, validation of each record can be taken to the latest database records.
Batch entry, a PRE-INSERT unsuccessful, all the records are not saved successfully
1, written in the WHEN-VALIDATE-RECORD, error, If the validation associated and the back-end database, then write in PRE-INSERT, because PRE-INSERT, ON-INSERT one by one records This batch entry, validation of each record can be taken to the latest database records.
Batch entry, a PRE-INSERT unsuccessful, all the records are not saved successfully
Post-Query and
when-New-Record-Instance relations
Post-Query and When-New-Record-Instance
Assumes that the database 100 block display the number of rows is set to 10, then when the cursor to move between the records you display only trigger When-New-Record-Instance, does not trigger the Post-query. When the cursor to the record of Article 11, triggering the Post-query
Post-Query and When-New-Record-Instance
Assumes that the database 100 block display the number of rows is set to 10, then when the cursor to move between the records you display only trigger When-New-Record-Instance, does not trigger the Post-query. When the cursor to the record of Article 11, triggering the Post-query
Not visible item when-validate-item question: If an item is not visible, then change its value, but also trigger when-validate-item?
Results: trigger, but not change its value after the trigger, but when the cursor is moved to another block. Close the window when triggered.
Test: Let block1 item1 is not visible in item2 when-validate-item the Tem1 assignment runtime, change the value of item2, in the block1 the item to move cursor did not trigger item1 WHEN-validate-item until the cursor to leave the block, or close the window when triggered.
The ACCEPT Trigger
explain
ACCEPT APP_STANDARD.EVENT ('Accept'); processed by the trigger menu or toolbar to call the Save and Proceed (save and continue) action. It performs the save and move to the block designated as the first navigation block. Replace the code in this trigger, or create block-level trigger and the implementation type is specified as 'Override'
ACCEPT APP_STANDARD.EVENT ('Accept'); processed by the trigger menu or toolbar to call the Save and Proceed (save and continue) action. It performs the save and move to the block designated as the first navigation block. Replace the code in this trigger, or create block-level trigger and the implementation type is specified as 'Override'
FOLDER_RETURN_ACTION
FOLDER_RETURN_ACTION
This trigger allows you to specify the customer Hua folder events
Replace the code required processing file folder action
FOLDER_RETURN_ACTION
This trigger allows you to specify the customer Hua folder events
Replace the code required processing file folder action
KEY_DUPREC
APP_STANDARD.EVENT ('KEY-DUPREC');
This trigger is disabled Oracle Forms default duplicate records
KEY-CLRFRM
KEY-CLRFRM
APP_STANDARD.EVENT ('KEY-CLRFRM');
Verify that the record before this trigger in an attempt to empty the form
Usually you should be added GO_BLOCK If there are a plurality of regions, in the form the use GO_BLOCK call emptied from operation repopulate control menu in the original code to add additional code
KEY-CLRFRM
APP_STANDARD.EVENT ('KEY-CLRFRM');
Verify that the record before this trigger in an attempt to empty the form
Usually you should be added GO_BLOCK If there are a plurality of regions, in the form the use GO_BLOCK call emptied from operation repopulate control menu in the original code to add additional code
KEY_MENU
KEY_MENU
APP_STANDARD.EVENT ('KEY-MENU');
This flip-flop is disabled Oracle froms Block Menu command
To enable alternative block from a specific block through the keyboard, writing block-level KEY_MENU and executive type set to 'Override' this trigger will open a pop-up menu LOV
KEY_MENU
APP_STANDARD.EVENT ('KEY-MENU');
This flip-flop is disabled Oracle froms Block Menu command
To enable alternative block from a specific block through the keyboard, writing block-level KEY_MENU and executive type set to 'Override' this trigger will open a pop-up menu LOV
KEY_LISTVAL
KEY_LISTVAL
APP_STANDARD.EVENT ('KEY-LISTVAL');
This trigger execution the flexfield operation or reference LOV
Create a block or item level trigger and set the execution type 'Override', you can use the calendar or dynamic execution flexfield
ON-ERROR
ON-ERROR
APP_STANDARD.EVENT ('ON-ERROR');
This trigger or client error message dictionary calls.
In order to capture the handle specified error in calling APP_STANDARD before check specified error declare
ON-ERROR
APP_STANDARD.EVENT ('ON-ERROR');
This trigger or client error message dictionary calls.
In order to capture the handle specified error in calling APP_STANDARD before check specified error declare
original_mess varchar2
(80);
begin
IF MESSAGE_CODE =
<your message number> THEN
original_mess: =
MESSAGE_TYPE | | '-' | |
to_char (MESSAGE_CODE)
| | ':' | | MESSAGE_TEXT;
--- Your code handling
the error goes here
message
(original_mess);
ELSE
APP_STANDARD.EVENT
('ON_ERROR');
END IF
end;
POST-FORM
POST-FORM.
APP_STANDARD.EVENT ('POST-FORM');
This flip-flop is reserved for future use to add additional code after the original code.
PRE-FORM
PRE-FORM
FND_STANDARD.FORM_INFO ('$ Revision: <Number> $',
'<Form. Name>'
'<Application Shortname>',
'$ Date: <YY/MM/DD HH24:MI:SS> $',
'$ Author: <developer name> $');
APP_STANDARD.EVENT ('PRE-FORM');
APP_WINDOW.SET_WINDOW_POSITION ('BLOCKNAME',
'FIRST_WINDOW');
The internal value of this trigger to initialize the Oracle Application menu. The value entered here will be seen in the Oracle applications menu 'Help About Oracle Applications'.
You must edit the short name of the application, the application referred to control which application online help documentation will be called when the user select the 'help' button. If you will be application referred to is set to FND, your users will not see any help because Oracle applications will not be available to help target.
Form name is the user form (form title).
Oracle Corporation to use the source control system, which can automatically update the value of the "$" at the beginning, if you do not use the source control system, you can press your development information editing these values.
You must edit APP_WINDOW BLOCKNAME for your own the block. Do not edit FIRST_WINDOW
PRE-FORM
FND_STANDARD.FORM_INFO ('$ Revision: <Number> $',
'<Form. Name>'
'<Application Shortname>',
'$ Date: <YY/MM/DD HH24:MI:SS> $',
'$ Author: <developer name> $');
APP_STANDARD.EVENT ('PRE-FORM');
APP_WINDOW.SET_WINDOW_POSITION ('BLOCKNAME',
'FIRST_WINDOW');
The internal value of this trigger to initialize the Oracle Application menu. The value entered here will be seen in the Oracle applications menu 'Help About Oracle Applications'.
You must edit the short name of the application, the application referred to control which application online help documentation will be called when the user select the 'help' button. If you will be application referred to is set to FND, your users will not see any help because Oracle applications will not be available to help target.
Form name is the user form (form title).
Oracle Corporation to use the source control system, which can automatically update the value of the "$" at the beginning, if you do not use the source control system, you can press your development information editing these values.
You must edit APP_WINDOW BLOCKNAME for your own the block. Do not edit FIRST_WINDOW
QUERY_FIND
QUERY_FIND
APP_STANDARD.EVENT ('QUERY_FIND);
This trigger will set the display string 'Query Find is not available'
Alternative code, in this triggers created when you create window or Row_LOV in your form block-level trigger and execute type set to 'Override'
QUERY_FIND
APP_STANDARD.EVENT ('QUERY_FIND);
This trigger will set the display string 'Query Find is not available'
Alternative code, in this triggers created when you create window or Row_LOV in your form block-level trigger and execute type set to 'Override'
WHEN-NEW-FORM-INSTANCE
WHEN-NEW-FORM-INSTANCE
FDRCSID ('$ Header: ... $');
APP_STANDARD.EVENT ('WHEN-NEW-FORM-INSTANCE');
- App_folder.define_folder_block ('template test',
'Folder_block', 'prompt_block', 'stacked_canvas',
'Window', 'disabled functions');
- App_folder event ('verify');
The call APP_STANDARD.EVENT to query-only mode to call FND_FUNCTION.EXECUTE call FNDRCSID to Oracle application source control system (source control the system). APP_FOLDER internal calls only for Oracle applications. The customized form does not require the FDRCSID or APP_FOLDER call, but if they are left in the trigger has no effect.
Add additional code before the existing code.
WHEN-NEW-FORM-INSTANCE
FDRCSID ('$ Header: ... $');
APP_STANDARD.EVENT ('WHEN-NEW-FORM-INSTANCE');
- App_folder.define_folder_block ('template test',
'Folder_block', 'prompt_block', 'stacked_canvas',
'Window', 'disabled functions');
- App_folder event ('verify');
The call APP_STANDARD.EVENT to query-only mode to call FND_FUNCTION.EXECUTE call FNDRCSID to Oracle application source control system (source control the system). APP_FOLDER internal calls only for Oracle applications. The customized form does not require the FDRCSID or APP_FOLDER call, but if they are left in the trigger has no effect.
Add additional code before the existing code.
WHEN-NEW-RECORD-INSTANCE
WHEN-NEW-RECORD-INSTANCE
APP_STANDARD.EVENT ('WHEN-NEW-RECORD-INSTANCE');
Trigger Manager Oracle Applications menu and toolbar to create a block-level trigger and set the execution type for 'Before'
WHEN-NEW-RECORD-INSTANCE
APP_STANDARD.EVENT ('WHEN-NEW-RECORD-INSTANCE');
Trigger Manager Oracle Applications menu and toolbar to create a block-level trigger and set the execution type for 'Before'
WHEN-NEW-ITEM-INSTANCE
WHEN-NEW-ITEM-INSTANCE
APP_STANDARD.EVENT ('WHEN-NEW-ITEM-INSTANCE');
Trigger Manager Oracle application menus and toolbars if you add flexfield method calls, you should add it before APP_STANDARD.EVENT call call, usually, you should not add any code in the trigger, this code will speed will affect your form and affect each
WHEN-NEW-ITEM-INSTANCE
APP_STANDARD.EVENT ('WHEN-NEW-ITEM-INSTANCE');
Trigger Manager Oracle application menus and toolbars if you add flexfield method calls, you should add it before APP_STANDARD.EVENT call call, usually, you should not add any code in the trigger, this code will speed will affect your form and affect each
Can not be modified
Trigger Oracle EBS Form.
Oracle applications do not support modifying the form level triggers
CLOSE_THIS_WINDOW
From menu Action-> Close call trigger APP_CUSTOM.CLOSE_WINDOW.
CLOSE_WINDOW
APP_CUSTOM.CLOSE_WINDOW (: SYSTEM.EVENT_WINDOW);
The departure of its handling of the Close event. The write event processing Close Window must be written in the APP_CUSTOM.CLOSE_WINDOW package
EXPORT
App_standard.event ('export');
This flip-flop is "Action, Export" menu choice.
FOLDER_ACTION
App_folder.event (: global.folder_action);
KEY-COMMIT
App_standard.event ('Key-commit');
This trigger handle the normal submission or form call
KEY-EDIT
App_standard.event ('KEY-EDIT');
This flip-flop Flexfield or calendar editor operation.
KEY-EXIT
App_standard.event ('KEY-EXIT');
Processed by the trigger off events and to exit the enter-query state
KEY-HELP
App_standard.event ('KEY-HELP');
This trigger calls windows help system.
LASTRECORD
APP_STANDARD.EVENT ('LASTRECORD');
Processed by the trigger menu events (Go -> LAST RECORD)
MENU_TO_APPCORE
App_standard.event (: global.menu_to_appcore);
This triggers support Special menu
STANDARD_ATTACHMENTS
Atchmt_api.invoke;
This trigger processing accessories menu or toolbar button calls
WHEN-WINDOW-CLOSE
Execute_trigger ('CLOSE_WINDOW');
The this trigger centralized form's Close event
WHEN-FORM-NAVIGATE
You can not modify the trigger, which contains the standard behavior when minimized form navigate to the normalization of this form.
ZOOM
Appcore_custom.event ('Zoom');
Processed by the trigger menu or toolbar button 'Action, Zoom' event,.
Oracle applications do not support modifying the form level triggers
CLOSE_THIS_WINDOW
From menu Action-> Close call trigger APP_CUSTOM.CLOSE_WINDOW.
CLOSE_WINDOW
APP_CUSTOM.CLOSE_WINDOW (: SYSTEM.EVENT_WINDOW);
The departure of its handling of the Close event. The write event processing Close Window must be written in the APP_CUSTOM.CLOSE_WINDOW package
EXPORT
App_standard.event ('export');
This flip-flop is "Action, Export" menu choice.
FOLDER_ACTION
App_folder.event (: global.folder_action);
KEY-COMMIT
App_standard.event ('Key-commit');
This trigger handle the normal submission or form call
KEY-EDIT
App_standard.event ('KEY-EDIT');
This flip-flop Flexfield or calendar editor operation.
KEY-EXIT
App_standard.event ('KEY-EXIT');
Processed by the trigger off events and to exit the enter-query state
KEY-HELP
App_standard.event ('KEY-HELP');
This trigger calls windows help system.
LASTRECORD
APP_STANDARD.EVENT ('LASTRECORD');
Processed by the trigger menu events (Go -> LAST RECORD)
MENU_TO_APPCORE
App_standard.event (: global.menu_to_appcore);
This triggers support Special menu
STANDARD_ATTACHMENTS
Atchmt_api.invoke;
This trigger processing accessories menu or toolbar button calls
WHEN-WINDOW-CLOSE
Execute_trigger ('CLOSE_WINDOW');
The this trigger centralized form's Close event
WHEN-FORM-NAVIGATE
You can not modify the trigger, which contains the standard behavior when minimized form navigate to the normalization of this form.
ZOOM
Appcore_custom.event ('Zoom');
Processed by the trigger menu or toolbar button 'Action, Zoom' event,.
No comments:
Post a Comment