0 Replies Latest reply: Aug 26, 2012 5:32 PM by Rich V RSS

    Building a brand new form using Form 6i on Oracle 11i

    Rich V
      Hello,

      We are developing a new Oracle EBS form from scratch. This is on 11.5.10.2 with Forms 6i

      This is a single .FMB file with multiple windows and canvases.

      In one of the master detail block, I have a need to call another window by clicking a button "Details" which is located on the master window.

      Oracle AOL does not support the usage of OPEN_FORM, CALL_FORM builtins. Hence I tried to implemented above functionality through following code.

      I litterally followd the AOL manual to achieve this. But no luck in success. Everytime I click the "Details" button, nothing happens, the form does not open at all.


      Please advise what am I missing here.

      Here is what my code
      -- MASTER BLOCK is "ORDER"
      -- Detail Block in a new window is "Detail"
      -- The button located on ORDER block is "DETAIL"
      -- The name of relation between ORDER and DETAIL block is "MD_REL"
      -- The name of control block is CONTROL.
      -- The name of coordination check box is SETCORD
      
      Step 1:
      
      
      Create a coordination check box in a control block in the detail window
      to specify the user’s preference of immediate or deferred coordination
      when the window is open. The check box should have the
      CHECKBOX_COORDINATION property class, which provides a value
      of ”IMMEDIATE” when checked and ”DEFERRED” when unchecked.
      The check box value should default to checked (IMMEDIATE).
      
      
      Step 2:
      
      Created Item Handler as below
      
      PACKAGE BODY control IS
          PROCEDURE lines(EVENT VARCHAR2) IS
              BEGIN
                 IF (EVENT = ’WHEN–BUTTON–PRESSED’) THEN
                      app_custom.open_window(’DETAILS’);
              END IF;
              END lines;
      
      
          PROCEDURE orders_lines(EVENT VARCHAR2) IS
          BEGIN
             IF (EVENT = ’WHEN–CHECKBOX–CHANGED’) THEN
              APP_WINDOW.SET_COORDINATION(EVENT,:control.setcord, ’MDREL’);
          END IF;
      END orders_lines;
      END control;
      
      
      Step 3:
      
      Customized the APP_CUSTOM package
      
      OPEN_wINDOW Procedure
      
      IF (WND = ’LINES’) THEN
      APP_WINDOW.SET_COORDINATION(’OPEN–WINDOW’,:control.setcord,’MDREL’);
      GO_BLOCK(’DETAILS’);
      END IF;
      
      
      CLOSE_WINDOW Procedure
      
      IF (WND = ’LINES’) THEN
      APP_WINDOW.SET_COORDINATION(’WHEN–WINDOW–CLOSED’,
      :control.setcord,
      ’MD_REL’);
      END IF;
      
      
      Step 4
      
      Modified following trigger
      
      Trigger: WHEN–BUTTON–PRESSED on control.details:
      
      control.details(’WHEN–BUTTON–PRESSED’);
      
      
      Trigger: KEY–NXTBLK on ORDER:
      control.details(’WHEN–BUTTON–PRESSED’);
      
      Trigger: WHEN–CHECKBOX–CHANGED on
      control.setcord:
      control.setcord(’WHEN–CHECKBOX–CHANGED’);
      Please advise, I have run out of option to see where exactly is the problem.

      Thanks,