{"id":1309,"date":"2011-04-17T11:35:22","date_gmt":"2011-04-17T11:35:22","guid":{"rendered":"http:\/\/sendyoursmiles.com\/articles\/using-call_form-to-invoke-another-form-in-oracle-applicatons"},"modified":"2014-12-09T06:28:34","modified_gmt":"2014-12-09T06:28:34","slug":"using-call_form-to-invoke-another-form-in-oracle-applications","status":"publish","type":"post","link":"https:\/\/erpschools.com\/erps\/forms\/using-call_form-to-invoke-another-form-in-oracle-applications","title":{"rendered":"Using CALL_FORM to invoke another form in Oracle Applications"},"content":{"rendered":"

 <\/p>\n

The following topics will be discussed in this article:<\/p>\n

    \n
  1. Overview of CALL_FORM.(Instead of call_form, we use fnd_function.execute in oracle apps)<\/li>\n
  2. Steps for Development of Calling Form(XXPO_VENDORS.fmb).<\/li>\n
  3. Steps for Development of Called Form(XXPO_VENDOR_SITES.fmb).<\/li>\n
  4. Called Form Registration in Oracle Applications 11i (XXPO_VENDOR_SITES.fmb).<\/li>\n
  5. Calling Form Registration in Oracle Applications 11i(XXPO_VENDORS.fmb).<\/li>\n<\/ol>\n

    1.\u00a0Overview of CALL_FORM:<\/span> (In Oracle Applications, we use fnd_function.execute instead of call_form)<\/p>\n

    CALL_FORM, OPEN_FORM, NEW_FORM are the Built-ins that will help us in creating “Multiple Form Applications”.<\/p>\n

    This built-in is used to invoke more than one form in a single session.<\/p>\n

    If one form is invoking other form, then invoking form is called as “Calling Form”.<\/p>\n

    The invoked form is called as “Called Form”.<\/p>\n

    This built\u2013in is incompatible with OPEN_FORM, which is used by Oracle Applications routines. So you should use FND_FUNCTION.EXECUTE instead of either CALL_FORM or OPEN_FORM whenever you need to invoke a form programmatically. FND_FUNCTION.EXECUTE allows you to open forms without bypassing Oracle Applications security, and also takes care of finding the correct directory path for the form.<\/p>\n

    Syntax:-<\/span><\/p>\n

    FND_FUNCTION.EXECUTE<\/p>\n

    (function_name IN varchar2,<\/p>\n

    open_flag IN varchar2 default ‘Y’,<\/p>\n

    session_flag IN varchar2 default ‘SESSION’,<\/p>\n

    other_params IN varchar2 default NULL,<\/p>\n

    activate IN varchar2 default ‘ACTIVATE’,<\/p>\n

    browser_target IN varchar2 default NULL);<\/p>\n

     <\/p>\n

    Description:<\/span> \u00a0Executes the specified form function. Only executes functions that have a form attached. Displays a message to the end user if the function is not accessible.<\/p>\n

    Arguments:-<\/p>\n

    Function_Name:<\/p>\n

    The developer name of the form function to execute.<\/p>\n

    Open_flag:
    \n‘Y’ indicates that OPEN_FORM should be used; ‘N’ indicates that NEW_FORM should be used.<\/p>\n

    You should always pass ‘Y’ for open_flag, which means to execute the function using the Oracle Forms OPEN_FORM built\u2013in rather than the NEW_FORM built\u2013in.<\/p>\n

    Session_flag: Passing ‘NO_SESSION’ or ‘N’ opens the form in the same session as the existing form; passing anything else opens your form in a new database session (including ‘SESSION’, the default).<\/p>\n

    Other_params:
    \nAn additional parameter string that is appended to any parameters defined for the function in the Parameters field of the Form Functions form. You\u00a0can use other_params to set some parameters dynamically. It can take any number of\u00a0parameters.<\/p>\n

     <\/p>\n

    Example:<\/span> From Vendor Details Form (XXPO_VENDORS.fmb) call the Vendor Site Details Form (XXPO_VENDOR_SITES.fmb) when I click on the Button Called “Sites”<\/p>\n

    2.Steps for Development of Calling Form(XXPO_VENDORS.fmb).:-<\/p>\n

    Step1:- Open Template.fmb with form builder save it with another name(XXPO_VENDORS.fmb).<\/p>\n

    Step2:- Delete “BLOCKNAME” from Window,Canvas and Data Block and delete “DETAILBLOCK” from Data Block.<\/p>\n

    \"\"<\/p>\n

    Step 3:-
    \nCreate Window (XXPOWINDOW) apply subclass information as “WINDOW” and give the title.<\/p>\n

    \"\"<\/p>\n

    Step 4:-
    \nGive this window name in PRE-FORM trigger (Form Level) and give this window name in APP_CUSTOM body Program_Unit (in place of window name).<\/p>\n

    \"\"<\/p>\n

    Compile and Close the window.<\/p>\n

    Next go to Program Units(APP_CUSTOM body) give the window name in 2 places as shown in below and Compile the Program Unit.<\/p>\n

    \"\"<\/p>\n

     <\/p>\n

    \"\"<\/p>\n

    Step 5:- Create Canvas(DEPT_CANVAS) apply subclass information as Canvas.<\/p>\n

    \"\"<\/p>\n

    Here Window is attached automatically.<\/p>\n

    \"\"<\/p>\n

    Step 6:<\/span>
    \nNow Create Data block (PO_VENDORS)\u00a0with Wizard or Manual, apply subclass information to the block as “BLOCK”\u00a0\u00a0 and also apply subclass information to the items as “TEXT_ITEM”.<\/p>\n

    \"\"<\/p>\n

    \"\"<\/p>\n

    Click on Next<\/p>\n

    \"\"<\/p>\n

    Click on Next. Next\u2026Finish.<\/p>\n

    \"\"<\/p>\n

    Move Available Items to Display Items.(So, These items will be display on the “XXPOVENDORS” Canvas.<\/p>\n

    \"\"<\/p>\n

    Click on Next.<\/p>\n

    Here give the Form title.<\/p>\n

    \"\"<\/p>\n

    \"\"<\/p>\n

    Go to Object Navigator(F3) Place cursor on the data block(PO_VENDOERS) apply sub class information as “BLOCK”<\/p>\n

    \"\"<\/p>\n

    And apply subclass information to all items (as “TEXT_ITEM”) which exists in the block (PO_VENDORS).<\/p>\n

    \"\"<\/p>\n

    Step 7:-Now create one button in the Canvas and give the name as “Sites”.<\/p>\n

    \"\"<\/p>\n

    \"\"<\/p>\n

    Now my Requirement is ,When I Click on the Sites button a new form(XX_PO_VENDOR_SITES) will be displayed with data based on vendor_id.<\/p>\n

    So we have to write code in the “WHEN-BUTTON-PRESSED” trigger of “Sites ”<\/p>\n

    Button.<\/p>\n

    :Global.vendor:=:po_vendors.vendor_id;<\/p>\n

    fnd_function.execute(FUNCTION_NAME=>’XXPO_VENDOR_SITES’,<\/p>\n

    OPEN_FLAG=>’Y’,<\/p>\n

    SESSION_FLAG=>’N’,other_params=>:Global.vendor);<\/p>\n

    Here we need to give called form function name so we have to develop a form(XXPO_VENDOR_SITES.fmb) and register this form in apps with function” ‘XXPO_VENDOR_SITES”.<\/p>\n

    other_params => here it is used to pass vendor_id from vendor details form to vendor site details form.<\/p>\n

    Compile and Close the window, and save the changes.<\/p>\n

    Step 8:<\/span> Move this form from Local Machine to the Custom TOP(xxmz) using WINSCP Tool<\/p>\n

    \"\"<\/p>\n

    Step 9:<\/span> Compile the Form using f60gen in Unix Environment.(Putty or WINSCP Console)<\/p>\n

    $f60gen XXPO_VENDORS.fmb apps\/apps<\/p>\n

    \"\"<\/p>\n

    3.Steps for Development of Called Form(XXPO_VENDOR_SITES.fmb):-<\/span><\/p>\n

    Step1 : Open Template.fmb with form builder save it with another name(XXPO_VENDOR_SITES.fmb).<\/p>\n

    \"\"<\/p>\n

    Step 2: Delete the block name from window, canvas ,data block and delete the detail block from data block.<\/p>\n

    Step 3: Now create a window and apply subclass information as “WINDOW”.<\/p>\n

    \"\"<\/p>\n

    Step 4 : Give this window name in PRE-FORM trigger (Form Level) and give this window name in APP_CUSTOM body Program_Unit (in place of window name).<\/p>\n

    \"\"<\/p>\n

    Compile and Close the window.<\/p>\n

    \"\"<\/p>\n

    Compile and Close the Window.<\/p>\n

    Step 5 : Now create a canvas and apply subclass information as “CANVAS”.<\/p>\n

    \"\"<\/p>\n

    Step 6 : Now create a data block for vendor sites.<\/p>\n

    \"\"<\/p>\n

    \"\"<\/p>\n

    Click on Next..finish<\/p>\n

    \"\"<\/p>\n

    \"\"<\/p>\n

    Click on Finish button<\/p>\n

    \"\"<\/p>\n

    Now go to Object Navigator(f3) Click on the block apply subclass information as “BLOCK” and apply sub class information as”TEXT_ITM” for all items that exists in the block.<\/p>\n

    \"\"<\/p>\n

    \"\"<\/p>\n

    In “WHEN-NEW-FORM-INSTANCE” trigger give<\/p>\n

    Execute_query;<\/p>\n

    \"\"<\/p>\n

    And go to Property Palette of “PO_VENDOR_SITES_ALL” data block<\/p>\n

    Give vendor_id=: Global.Vendor in the “WHERE Clause” Property.<\/p>\n

    Close and Save the changes.<\/p>\n

    \"\"<\/p>\n

    Step 7 : Move the form(XXPO_VENDOR_DETAILS.fmb) from local machine to the custom top<\/p>\n

    Step 8 : Compile the form Using f60gen<\/p>\n

    $f60gen XXPO_VENDOR_SITES.fmb apps\/apps<\/p>\n

    4.Called Form Registration in Oracle Applications 11i XXPO_VENDOR_SITES.fmb).<\/p>\n

    I . Create a Form.(Navigation:-Application Developer->Application-> Form)<\/p>\n

    Here give the Following Details:-<\/p>\n

    Form:-XXPO_VENDOR_SITES<\/p>\n

    Application: Custom Top Application Name(xxmz Custom)<\/p>\n

    User Form Name: any name(Vendor Site Details Form)<\/p>\n

    Description:any(Vendor Site Details Form)<\/p>\n

    Save and Close the form<\/p>\n

    \"\"<\/p>\n

    II. Create a function (Navigation: Application->function)<\/p>\n

    Here give the following Details<\/p>\n

    Function:-any (XXPO_VENDOR_SITES)<\/p>\n

    Note:-“XXPO_VENDOR_SITES” is called form function name. So you have to give this function name in Calling Form (XXPO_VENDORS.fmb) “WHEN-BUTTON-PRESSED” trigger FND_FUCTION.EXECUTE(function=> XXPO_VENDOR_SITES)<\/p>\n

    User Function Name: any name(Vendor Site Details form Function)<\/p>\n

    Description: Any (Vendor Site Details form Function)<\/p>\n

    \"\"<\/p>\n

    Go to “Properties” tab give the type as “Form”<\/p>\n

    Next Go to “Form” tab attach our user function form name here (i.e Vendor Site Details form).<\/p>\n

    \"\"<\/p>\n

    Save and Close the form.<\/p>\n

    III . Attach that function to the Custom TOP menu<\/p>\n

    (Navigation: Application->Menu)<\/p>\n

    We can get Menu name from “Responsibility” Window of System Administrator.<\/p>\n

    (System Administrator->Security->Responsibility->Define)<\/p>\n

    Query with particular application name and responsibility name you will get “MENU NAME”<\/p>\n

    Copy that menu name, Query with that name in Application Developer Menu Window.<\/p>\n

    Here give the following Details:<\/p>\n

    Seq: Any Unique Number<\/p>\n

    Prompt: any (Vendor Site Details)<\/p>\n

    Function: Attach the User function Name (Vendor Site Details Form Function)<\/p>\n

    \"\"<\/p>\n

    5.Calling Form Registration in Oracle Applications 11i(XXPO_VENDORS.fmb):-<\/p>\n

    I.Create a Form.(Navigation:-Application Developer->Application-> Form)<\/p>\n

    Here give the Following Details:-<\/p>\n

    Form:-XXPO_VENDORS<\/p>\n

    Application: Custom Top Application Name(xxmz Custom)<\/p>\n

    User Form Name: any name(Vendor Details Form)<\/p>\n

    Description:any(Vendor Details Form)<\/p>\n

    Save and Close the form<\/p>\n

    \"\"<\/p>\n

    II. Create a function (Navigation: Application->function)<\/p>\n

    Here give the following Details<\/p>\n

    Function:-any (XXPO_VENDORS)<\/p>\n

    User Function Name: any name(Vendor Details Form Function)<\/p>\n

    Description: Any (Vendor Details form Function)<\/p>\n

    \"\"<\/p>\n

    Go to “Properties” tab give the type as “Form”<\/p>\n

    Next Go to “Form” tab attach our user function form name here (i.e Vendor Details form).<\/p>\n

    \"\"<\/p>\n

    Save and Close the form.<\/p>\n

    III.Attach that function to the Custom TOP menu<\/p>\n

    (Navigation: Application->Menu)<\/p>\n

    We can get Menu name from “Responsibility” Window of System Administrator.<\/p>\n

    (System Administrator->Security->Responsibility->Define)<\/p>\n

    Query with particular application name and responsibility name you will get “MENU NAME”<\/p>\n

    Copy that menu name, Query with that name in Application Developer Menu Window.<\/p>\n

    Here give the following Details:<\/p>\n

    Seq: Any Unique Number<\/p>\n

    Prompt: any (Vendor sub Form)<\/p>\n

    Function: Attach the User function Name (Vendor Details Form Function)<\/p>\n

    \"\"<\/p>\n