How to call or invoke in ASCP module in Standard Choose Inventory Organization_Code and Organization_Name Form From any Customized form in ASCP module in Oracle Apps.

How to call or invoke in ASCP module in Standard Choose Inventory Organization_Code and Organization_Name  Form From any Customized form in ASCP module in Oracle Apps.

How to automatically select organizations dialog R12 FORM ASCP.

In the R12 system development FORM automatically pop up a dialog box to select the organization.

First Download the MSCCHORG.fmb from the server with the help of winscp

AU_TOP/12.0.0/forms/US

Then open in form builder with your custom form.

Additional copies of the standard library MACCORE from the MSCCHORG.fmb .

Add the Attached Libraries MSCCORE to the Custom form.

1. Create 4 parameters in your custom form .

ORG_ID

ORG_NAME

ORG_CODE

INSTANCE_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.

MSC_ORG.CHOOSE_ORG;

COPY the LOV MSC_CHOOSE_ORG from the MSCCHORG.fmb to the custom form.

   

 Then Copy records set

MSC_CHOOSE_ORG1，

MSC_CHOOSE_ORG2,

MSC_CHOOSE_ORG3

the the MSCCHORG.fmb to the custom form.

 

Then We create the Another Two Parameter for Store the Inventory Organization ID and Name

 

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

---------- BY DEFAULT FETCH THE INVENTORY ORGANIZATION ID WHEN WE CHOOSE THE LOV -----------

BEGIN

       :PARAMETER.P_INV_ORGANIZATION_ID :=FND_PROFILE.VALUE('MFG_ORGANIZATION_ID');

END;

  

      -----## Default Inventory Organization Name ##----------

   SELECT pt.organization_code INTO :PARAMETER.P_INV_ORGANIZATION_NAME

   FROM   msc_trading_partners pt

   WHERE  pt.sr_tp_id = :PARAMETER.P_INV_ORGANIZATION_ID;

    

EXCEPTION WHEN NO_DATA_FOUND THEN

    NULL;

END;

  

BEGIN --##Setting Window Title##--With Inventory Organization Name------------

Set_Window_Property('WINDOW_MAIN',TITLE,'Production Schedule for Finished Goods & WIP Items ( '||:PARAMETER.P_INV_ORGANIZATION_NAME||' )');

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.