Join the OracleApps88 Telegram group @OracleApps88to get more information on Oracle EBS R12/Oracle Fusion applications.

If you are facing any issues while copying the Code/Script or any issues with Posts, Please send a mail to OracleApp88@Yahoo.com or message me at @apps88 or +91 905 957 4321 in telegram.

Sunday, March 20, 2016

Calling DataBase Package After Process Form Request in OAF

/*Code Written After Process Form Request*/
public void DemandCompilationProcess(OAPageContext pageContext, OAWebBean webBean, String p_docno)
 {
    try {   OAApplicationModule am = pageContext.getApplicationModule(webBean);
       // OAViewObject vh = (OAViewObject)am.findViewObject("bgtCompProcessVO1");
                  
          OADBTransaction txn = am.getOADBTransaction();
          CallableStatement cs = null;
          cs = txn.createCallableStatement("begin XXAA_PROCESS_PKG.XXAA_BGT_COMP_COMPILE (:1,:2); END;", 0);
          cs.setString(1, p_docno);
          cs.registerOutParameter(2, Types.VARCHAR);
          cs.execute();
         String  p_docno1 = cs.getString(2);
         System.out.println("Flag: " + p_docno1);
        // vh.executeQuery();
         am.invokeMethod("disablePVOtrue");
          throw new OAException("Document " + p_docno + " has been created.", (byte)3);
       
      } catch (SQLException sqle) {
          sqle.printStackTrace();
      } //End Catch
   
  }

No comments:

Post a Comment

If you are facing any issues while copying the Code/Script or any issues with Posts, Please send a mail to OracleApp88@Yahoo.com or message me at @apps88 or +91 905 957 4321 in telegram.
Best Blogger TipsGet Flower Effect