Personalization to add Menu in Oracle Apps

Adding a Menu Option in Oracle Apps using Form Personalization:

1.       Open the Form where you want the menu to show the new Option.  Below example shows Menu Option in Purchase Order Form.

2.       Help à Diagnostics à Custom Codeà Personalize

3.       Add new sequence and insert Condition as

Trigger Event:  WHEN NEW FORM INSTANCE

Condition:

Processing Mode: Not in Enter-Query Mode

4.       Click on Actions Tab:

Type: Menu

Description: PO Approve Submenu

Language: All

Menu Entry: MENU1

Menu Label: PO Approve

Check Render line before menu

SAVE the Personalization.

5.       Menu will start showing in the Tools à PO Approve

6.       Call a concurrent program or procedure on PO Approve Menu Button using below personalization:

Add New Seq and Description : Launch Functionality on PO Approve Menu

Trigger Event : MENU1

Condition:

:PO_HEADERS.STATUS in ( 'Incomplete','Requires Reapproval') and :PO_HEADERS.PO_TOTAL_DSP <1 and :PO_HEADERS.DOC_TYPE_NAME = 'Standard Purchase Order'

Processing Mode: Both

7.       In Actions Tab Call a Stored Procedure as below:

Type: BUILTIN

Language: All

Builtin Type: Execute a Procedure

Argument:

 = 'declare

begin

xxcustom_po_approve_p ('''||${item.PO_HEADERS.PO_HEADER_ID.value}||''');

end'

SAVE the Personalization.

Now you can use the Menu option to call the stored procedure xxcustom_po_approve.