1. Create 4 parameters in your custom form .
ORG_ID
ORG_NAME
ORG_CODE
CHART_OF_ACCOUNTS_ID
Description of each parameters:
Step 2 : PRE-FORM Trigger change
Write the following statement in Pre-Form Trigger for invoking the Standard Choose Organization form from your custom form.
FND_ORG.CHOOSE_ORG;
Then We create the Another Two Parameter for Store the
Inventory Organization ID and Name
Description of each parameters:
Then Go to the Form Level Trigger in
WHEN-NEW-FORM-INSTANCE
And Write the
Query to fetch the Inventory Organization ID and Name and Show to the Window
Title Bar.
Begin
Begin
:Parameter.INV_ORGANIZATION_ID:=fnd_profile.value('MFG_ORGANIZATION_ID');
End;
--##Default
Inventory Organization Code Name##--
select ORGANIZATION_CODE
INTO :Parameter.INV_ORG_NAME
from org_organization_definitions
where ORGANIZATION_ID =
:Parameter.INV_ORGANIZATION_ID;
Begin --##Setting Window
Title##--
Set_Window_Property('NEW_WINDOW',TITLE,'Critical
Path (T & A) Activity Selection( '||:Parameter.INV_ORG_NAME||' )');
End;
End;
When I open the Form Its want to select the Inventory
Organization First the go to the Custom Form
And when we select the Inventory Organization Name then it’s
SHOWN in the Custom Form Window Title.
Like that.
Thank you for the great post, it helped me during the development process of my custom form
ReplyDeleteThanks for sharing the post.. parents are worlds best person in each lives of individual..they need or must succeed to sustain needs of the family. phone tracker
ReplyDeleteI read that Post and got it fine and informative. spy phone
ReplyDelete