insert Page In OAF

Insert Page Creation:

1- Create a new Workspace
     named =TestInsertWS

2- Create a new project 
    named =TestInsertPR
    Package   =xxaj.TestInsert.oracle.apps.po.webui

3- Create a new AM
    named =TestInsertAM
    Package   =xxaj.TestInsert.oracle.apps.po.server

4- Enable Passivation for the Root UI Application Module (AM)

5- Right Click on InsertAM > Edit InsertAM > Custom Properties >
   
   Name – RETENTION_LEVEL
   Value – MANAGE_STATE

   Click add > Apply > OK

6- Create Test Table in which we will insert data (For Testing Purpose)
   
    CREATE TABLE xx_insert_demo
(        -- ---------------------
         -- Data Columns
         -- ---------------------
         column1                           VARCHAR2(100),
         column2                           VARCHAR2(100),
         -- ---------------------           
         -- Who Columns           
         -- ---------------------         
         last_update_date          DATE            NOT NULL,
         last_updated_by           NUMBER     NOT NULL,
         creation_date                 DATE            NOT NULL,
         created_by                      NUMBER     NOT NULL,
         last_update_login        NUMBER
);

7- Create a new EO named =TestInsertEO
       package=xxaj.TestInsert.oracle.apps.po.schema.server

8- Create a new VO named =TestInsertVO
     package=xxaj.TestInsert.oracle.apps.po.server
    In Java page deselect Generate Java file for View Object Class: AdnanVOImpl
     and Select Generate Java File for View Row Class: AdnanVORowImpl

9- Add Your View Object to Root UI Application Module
    Right click on TestInsertAM > Edit TestInsertAM > Data Model >
    Select TestInsertVO in Available View Objects list and shuttle to Data Model list

10- Create a new Page named TestInsertPG
     Package= xxaj.oracle.apps.po.webui

11- Select region1 and set the following properties:
 ID -- PageLayoutRN
 Region Style -- PageLayout
 AM Definition -- xxaj.TestInsert.oracle.apps.po.server.TestInsertAM
 Window Title -- Date Entry Form Window
 Title -- Data Entry Form
 Auto Footer -- True

12. Right click PageLayoutRN > New > Region
ID -- MainRN
Region Style -- defaultSingleColumn

13. Create Text Input Items
=================================
Right click on MainRN > New > Item

Set following properties for New Item

ID -- COLUMN1
Item Style -- messageTextInput
Maximum Length -- 100
Length -- 20
Prompt -- Column1
View Instance -- AdnanVO1
View Attribute -- Column1

Again Right click on MainRN > New > Item

Set following properties for New Item

ID -- COLUMN2
Item Style -- messageTextInput
Maximum Length -- 100
Length -- 20
Prompt -- Column2
View Instance -- AdnanVO1
View Attribute – Column2

14. Add Apply and Cancel Buttons

Right click on PageLayoutRN > New > Region

         ID -- PageButtons
         Region Style -- pageButtonBar

Right click on PageButtons > New > Item

ID -- Cancel
Item Style -- submitButton
Attribute Set -- /oracle/apps/fnd/attributesets/Buttons/Cancel
Disable Server Side Validation -- True
Prompt -- Cancel
Warm About Changes -- False
Additional Text – Select to cancel this transaction.

Right click on PageButtons > New > Item

ID -- Apply
Item Style -- submitButton
Attribute Set -- /oracle/apps/fnd/attributesets/Buttons/Apply

Prompt -- Apply

Additional Text – Select to save this transaction.


15. Implement Row Initialization (Create a View Object Row)

Add createRecord method to your TestInsertAMImpl class

import oracle.jbo.Row;
import oracle.apps.fnd.framework.OAViewObject;
...

    public void createRecord()
    {
      OAViewObject vo = (OAViewObject)getTestInsertVO1();
   
      if (!vo.isPreparedForExecution())
      {
            vo.executeQuery();
      }
   
      Row row = vo.createRow();
      vo.insertRow(row);
      row.setNewRowState(Row.STATUS_INITIALIZED);
    }

16. Create Controller for Page

PageLayoutRN > Set New Controller >

Package Name: xxaj.TestInsert.oracle.apps.po.webui
Class Name: InsertCO


17. Add Create Page Initialization to your Controller

Add following code to your processRequest()

import oracle.apps.fnd.framework.OAApplicationModule;
...

public void processRequest(OAPageContext pageContext,OAWebBean webBean)
{
  super.processRequest(pageContext, webBean);

  if (!pageContext.isFormSubmission())
  {
   OAApplicationModule am = pageContext.getApplicationModule(webBean);
   am.invokeMethod("createRecord", null);
  }
}


18. Add below method in TestInsertAMImpl Class to handle Apply Button action

import oracle.jbo.Transaction;
...

    public void Apply()
    {
      getTransaction().commit();
    }


19. Add below Logic in InsertCO to handle Apply Button

Add following code to your processFormRequest()
import oracle.jbo.domain.Number;
import oracle.apps.fnd.common.MessageToken;
import oracle.apps.fnd.framework.OAException;
import oracle.apps.fnd.framework.OAViewObject;
import oracle.apps.fnd.framework.webui.OAWebBeanConstants;
...
public void processFormRequest(OAPageContext pageContext, OAWebBean webBean)
{super.processFormRequest(pageContext, webBean);
       OAApplicationModule am = pageContext.getApplicationModule(webBean);
       // Pressing the "Apply" button means the transaction should be
       // validated and committed.
                 
       if (pageContext.getParameter("Apply") != null)
       {
        OAViewObject vo = (OAViewObject)am.findViewObject("TestInsertVO1");
        String column1 = (String)vo.getCurrentRow().getAttribute("Column1");
        String column2 = (String)vo.getCurrentRow().getAttribute("Column2");
                         
        am.invokeMethod("Apply");
                         
        // Create a FND Message with name "TEST_CREATE_CONFIRM" with two
        // tokens               
        MessageToken[] tokens = { new MessageToken("COLUMN1", column1),
                                  new MessageToken("COLUMN2", column2)
                                };
     
        OAException confirmMessage = new OAException( "FND",
                                       "TEST_CREATE_CONFIRM", tokens,
                                       OAException.CONFIRMATION, null);
       
        pageContext.putDialogMessage(confirmMessage);
        pageContext.forwardImmediately(
         "OA.jsp?page=/xxaj/TestInsert/oracle/apps/po/webui/TestInsertPG",
          null, OAWebBeanConstants.KEEP_MENU_CONTEXT,
          null,
          null,
          true, // retain AM
          OAWebBeanConstants.ADD_BREAD_CRUMB_NO);
 }
}