8 Replies Latest reply: May 27, 2013 1:59 AM by Sandeep M. RSS

    How to display advance table based on parameter pls give me solution urgent

    1005875
      Co code:
      public class PosASEBacklogCO extends OAControllerImpl
      {

      public void processRequest(OAPageContext pageContext, OAWebBean webBean)
      {
      super.processRequest(pageContext, webBean);
      // PosASEBackShipAMImpl am = (PosASEBackShipAMImpl)pageContext.getApplicationModule(webBean);
      //am.showPrintNShip();
      // System.out.println("i am in Pfreq ");
      }

      public void processFormRequest(OAPageContext pageContext, OAWebBean webBean)
      {
      super.processFormRequest(pageContext, webBean);
      PosASEBackShipAMImpl am = (PosASEBackShipAMImpl)pageContext.getApplicationModule(webBean);
      OAViewObjectImpl ASEBacklogVO = (OAViewObjectImpl)am.findViewObject("ASEBacklogVO");
      String CSDTxt = pageContext.getParameter("CSDTxt");
      String Csdto = pageContext.getParameter("CSDTo");
      String partnumberTxt = pageContext.getParameter("partnumberTxt");
      String CustomerTxt = pageContext.getParameter("CustomerTxt");
      String salesorderlineTxt = pageContext.getParameter("salesorderlineTxt");
      String ASE = pageContext.getParameter("ASE");

      if( "Submit".equals(pageContext.getParameter(EVENT_PARAM)) )
      {
      if(CSDTxt !=null && CSDTxt!="") {
      am.getASEBacklogVO1().setWhereClauseParam(0,CSDTxt);
      }
      else {
      am.getASEBacklogVO1().setWhereClauseParam(0,null);
      }
      if(Csdto !=null && Csdto!="") {
      am.getASEBacklogVO1().setWhereClauseParam(1, Csdto);
      }
      else {
      am.getASEBacklogVO1().setWhereClauseParam(1,null);
      }
      if(partnumberTxt !=null && partnumberTxt!="") {
      am.getASEBacklogVO1().setWhereClauseParam(2, partnumberTxt);
      }
      else {
      am.getASEBacklogVO1().setWhereClauseParam(2,null);
      }
      if(CustomerTxt !=null && CustomerTxt!="") {
      am.getASEBacklogVO1().setWhereClauseParam(3, CustomerTxt);
      }
      else {
      am.getASEBacklogVO1().setWhereClauseParam(3,null);
      }
      if(salesorderlineTxt !=null && salesorderlineTxt!="") {
      am.getASEBacklogVO1().setWhereClauseParam(4, salesorderlineTxt);
      }
      else {
      am.getASEBacklogVO1().setWhereClauseParam(4, null);
      }
      if(CSDTxt == "" && Csdto == "" && partnumberTxt == "" && CustomerTxt == "" && salesorderlineTxt == "")
      {
      am.getASEBacklogVO1().setWhereClauseParam(0, null);
      am.getASEBacklogVO1().setWhereClauseParam(1, null);
      am.getASEBacklogVO1().setWhereClauseParam(2, null);
      am.getASEBacklogVO1().setWhereClauseParam(3, null);
      am.getASEBacklogVO1().setWhereClauseParam(4, null);
      am.getASEBacklogVO1().executeQuery();
      // am.showPrintNShip();
      }

      System.out.println("Execute Query:- "+ASEBacklogVO.getQuery());
      }
      if(pageContext.getParameter("event").equals("ShippingDetailsAction"))
      pageContext.setForwardURL("OA.jsp?page=/oracle/apps/pos/salesorder/webui/PosASEShippingDetailsPG", null, (byte)0, null, null, true, null, (byte)99);
      else
      if(pageContext.getParameter("event").equals("printCS"))
      {
      String salesOrderLineShippement = pageContext.getParameter("SalesOrderLineShippement");
      am.printCS(salesOrderLineShippement);
      } else
      if(pageContext.getParameter("event").equals("ShipConfirmAction"))
      {
      String OperatingUnitform = pageContext.getParameter("OperatingUnitform");
      am.shipConfirmAction(OperatingUnitform);
      } else
      if(pageContext.getParameter("event").equals("SelectRowAction"))
      am.showPrintNShip();
      }--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
      Vo:
      SELECT
      'N' selectRow
      ,customer_name
      ,so_line_shipment
      ,part_number
      ,customer_item_number
      ,cust_po_number
      ,ordered_date
      ,promise_date
      ,schedule_ship_date
      ,shipping_terms
      ,shipping_method
      ,ordered_quantity
      ,shipping_instructions
      ,ship_to_address
      ,ship_to_contact
      ,ship_to_phone
      ,"Hold Name"
      ,"Hold Release Flag"
      ,order_number
      ,OPERATING_UNIT
      FROM APPS.XXSY_SYNA_ASE_BACKLOG
      where (to_date(promise_date,'dd-mm-rrrr')
      between nvl(:1,to_date(promise_date,'dd-mm-rrrr')) and nvl(:2,to_date(promise_date,'dd-mm-rrrr')))
      and part_number = NVL(:3, NVL(part_number,1))
      AND customer_name = NVL(:4, NVL(customer_name,1))
      and so_line_shipment = NVL(:5, NVL(so_line_shipment,1))
      ---------------------------------------------------------------------------------------------------------------------------------------------------------------------
      AM:
      public class PosASEBackShipAMImpl extends OAApplicationModuleImpl {
      /**This is the default constructor (do not remove)
      */
      public PosASEBackShipAMImpl() {
      }

      /**Sample main for debugging Business Components code using the tester.
      */
      public static void main(String[] args) {
      launchTester("xxsy.oracle.apps.pos.salesorder.server", /* package name */
      "PosASEBackShipAMLocal" /* Configuration Name */);
      }


      public void executegetASEShippingInfoVO(String salesOrderLineShippement) {
      this.getASEShippingInfoVO1().getDetails(salesOrderLineShippement);
      }


      public void printCS(String salesOrderLineShippement)
      {
      OADBTransaction dbtrans = getOADBTransaction();
      String sql = "BEGIN xxsy_call_wrapper_pkg.Invoice_wrapper(?,?,?); END;";
      OracleCallableStatement callablestatement = (OracleCallableStatement)dbtrans.createCallableStatement(sql,1);
      try{   
      callablestatement.setString(1,salesOrderLineShippement);
      callablestatement.registerOutParameter(2,Types.VARCHAR);
      callablestatement.registerOutParameter(3,Types.VARCHAR);
      callablestatement.executeUpdate();
      String Returncode = callablestatement.getString(3);
      String ReturnMsg = callablestatement.getString(2);
      callablestatement.close();
      if(Returncode != null && (!Returncode.equalsIgnoreCase("2")) )
      {
      throw new OAException(ReturnMsg,OAException.ERROR);
      }
      if(Returncode != null && (!Returncode.equalsIgnoreCase("0")) )
      {
      throw new OAException(ReturnMsg,OAException.INFORMATION);
      }
      }catch(SQLException _sqle)
      {
      try{
      callablestatement.close();
      }catch (Exception e) {e.printStackTrace();}
      throw OAException.wrapperException(_sqle);
      }
      String sql1 = "BEGIN xxsy_call_wrapper_pkg.Ship_wrapper(?,?,?); END;";
      callablestatement = (OracleCallableStatement)dbtrans.createCallableStatement(sql1,1);
      try{
      callablestatement.setString(1,salesOrderLineShippement);
      callablestatement.registerOutParameter(2,Types.VARCHAR);
      callablestatement.registerOutParameter(3,Types.VARCHAR);
      callablestatement.executeUpdate();
      String Returncode = callablestatement.getString(3);
      String ReturnMsg = callablestatement.getString(2);
      callablestatement.close();
      if(Returncode != null && (!Returncode.equalsIgnoreCase("2")) )
      {
      throw new OAException(ReturnMsg,OAException.ERROR);
      }
      if(Returncode != null && (!Returncode.equalsIgnoreCase("0")) )
      {
      throw new OAException(ReturnMsg,OAException.INFORMATION);
      }
      }catch(SQLException _sqle)
      {
      try{
      callablestatement.close();
      }catch (Exception e) {e.printStackTrace();}
      throw OAException.wrapperException(_sqle);
      }
      }

      public void shipConfirmAction(String OperatingUnitform)
      {
      OADBTransaction dbtrans = getOADBTransaction();
      String sql = "BEGIN xxsy_call_wrapper_pkg.One_Touch_wrapper(?,?,?); END;";
      OracleCallableStatement callablestatement = (OracleCallableStatement)dbtrans.createCallableStatement(sql,1);
      try{
      callablestatement.setString(1,OperatingUnitform);
      callablestatement.registerOutParameter(2,Types.VARCHAR);
      callablestatement.registerOutParameter(3,Types.VARCHAR);
      callablestatement.executeUpdate();
      String Returncode = callablestatement.getString(3);
      String ReturnMsg = callablestatement.getString(2);
      callablestatement.close();
      if(Returncode != null && (!Returncode.equalsIgnoreCase("2")) )
      {
      throw new OAException(ReturnMsg,OAException.ERROR);
      }
      if(Returncode != null && (!Returncode.equalsIgnoreCase("0")) )
      {
      throw new OAException(ReturnMsg,OAException.INFORMATION);
      }
      }catch(SQLException _sqle)
      {
      try{
      callablestatement.close();
      }catch (Exception e) {e.printStackTrace();}
      throw OAException.wrapperException(_sqle);
      }
      }
      public void showPrintNShip() {
      System.out.println("i am show Print Method1 ");
      ASEBacklogVOImpl aseBacklogVOImpl = getASEBacklogVO1();
      for(int i=0; i < aseBacklogVOImpl.getRowCount(); i++){
      ASEBacklogVORowImpl aseBacklogVORowImpl = (ASEBacklogVORowImpl) aseBacklogVOImpl.getRowAtRangeIndex(i);
      System.out.println("i am show Print Method2 ");
      if(aseBacklogVORowImpl != null){
      String selectRow = aseBacklogVORowImpl.getSelectrow();
      System.out.println("i am show Print Method3 ");
      if(selectRow != null && selectRow.equalsIgnoreCase("Y")) {
      System.out.println("i am show Print Method4 ");
      aseBacklogVORowImpl.setShowPrintReport(new Boolean(true));
      aseBacklogVORowImpl.setShowShipConfirm(new Boolean(true));
      aseBacklogVORowImpl.setShowShippingDetails(new Boolean(true));
      }else {
      System.out.println("i am show Print Method5 ");
      aseBacklogVORowImpl.setShowPrintReport(new Boolean(false));
      aseBacklogVORowImpl.setShowShipConfirm(new Boolean(false));
      aseBacklogVORowImpl.setShowShippingDetails(new Boolean(false));
      }
      }
      }
      }

      public void enableToUpdate() {
      ASEShippingInfoVOImpl aseShippingInfoVOImpl = this.getASEShippingInfoVO1();
      Row row = aseShippingInfoVOImpl.getRowAtRangeIndex(0);
      if(row != null)
      row.setAttribute("EditFlag", new Boolean(false));
      }

      public void setDefaultReadonly() {

      }

      /**Container's getter for ASEShippingInfoVO1
      */
      public ASEShippingInfoVOImpl getASEShippingInfoVO1() {
      return (ASEShippingInfoVOImpl)findViewObject("ASEShippingInfoVO1");
      }

      /**Container's getter for ASEShiplogVO1
      */
      public ASEShiplogVOImpl getASEShiplogVO1() {
      return (ASEShiplogVOImpl)findViewObject("ASEShiplogVO1");
      }

      /**Container's getter for ASEBacklogVO1
      */
      public ASEBacklogVOImpl getASEBacklogVO1() {
      return (ASEBacklogVOImpl)findViewObject("ASEBacklogVO1");
      }
      }
      ------------------------------------------------------------------------------------------------

      it is showing null pointer exception pls help me asap
        • 1. Re: How to display advance table based on parameter pls give me solution urgent
          keerthioaf
          Hey hi there ,

          Can you tell us where exactly you 're getting the null pointer exception and if possible explain us
          what exactly you 're trying to do ??

          --Keethi                                                                                                                                                                                                                                                                                                                                                                               
          • 2. Re: How to display advance table based on parameter pls give me solution urgent
            Sandeep M.
            Please post complete error stack so that exact line of error in code can be identified.
            • 3. Re: How to display advance table based on parameter pls give me solution urgent
              1005875
              Exception Details.
              oracle.apps.fnd.framework.OAException: java.lang.NullPointerException
                   at oracle.apps.fnd.framework.OAException.wrapperException(Unknown Source)
                   at oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(Unknown Source)
                   at oracle.apps.fnd.framework.webui.OAPageErrorHandler.processErrors(Unknown Source)
                   at oracle.apps.fnd.framework.webui.OAPageBean.processFormRequest(Unknown Source)
                   at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(Unknown Source)
                   at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(Unknown Source)
                   at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(Unknown Source)
                   at OA.jspService(_OA.java:71)
                   at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
                   at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:462)
                   at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:594)
                   at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:518)
                   at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
                   at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:713)
                   at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:370)
                   at com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:871)
                   at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:453)
                   at com.evermind.server.http.HttpRequestHandler.serveOneRequest(HttpRequestHandler.java:221)
                   at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:122)
                   at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:111)
                   at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
                   at oracle.oc4j.network.ServerSocketAcceptHandler.procClientSocket(ServerSocketAcceptHandler.java:239)
                   at oracle.oc4j.network.ServerSocketAcceptHandler.access$700(ServerSocketAcceptHandler.java:34)
                   at oracle.oc4j.network.ServerSocketAcceptHandler$AcceptHandlerHorse.run(ServerSocketAcceptHandler.java:880)
                   at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
                   at java.lang.Thread.run(Thread.java:595)
              ## Detail 0 ##
              java.lang.NullPointerException
                   at oracle.apps.pos.salesorder.webui.PosASEBacklogCO.processFormRequest(PosASEBacklogCO.java:107)
                   at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(Unknown Source)
                   at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(Unknown Source)
                   at oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processFormRequest(Unknown Source)
                   at oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processFormRequest(Unknown Source)
                   at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(Unknown Source)
                   at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(Unknown Source)
                   at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(Unknown Source)
                   at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(Unknown Source)
                   at oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processFormRequest(Unknown Source)
                   at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(Unknown Source)
                   at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(Unknown Source)
                   at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(Unknown Source)
                   at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(Unknown Source)
                   at oracle.apps.fnd.framework.webui.beans.OABodyBean.processFormRequest(Unknown Source)
                   at oracle.apps.fnd.framework.webui.OAPageBean.processFormRequest(Unknown Source)
                   at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(Unknown Source)
                   at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(Unknown Source)
                   at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(Unknown Source)
                   at OA.jspService(_OA.java:71)
                   at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
                   at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:462)
                   at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:594)
                   at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:518)
                   at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
                   at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:713)
                   at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:370)
                   at com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:871)
                   at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:453)
                   at com.evermind.server.http.HttpRequestHandler.serveOneRequest(HttpRequestHandler.java:221)
                   at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:122)
                   at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:111)
                   at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
                   at oracle.oc4j.network.ServerSocketAcceptHandler.procClientSocket(ServerSocketAcceptHandler.java:239)
                   at oracle.oc4j.network.ServerSocketAcceptHandler.access$700(ServerSocketAcceptHandler.java:34)
                   at oracle.oc4j.network.ServerSocketAcceptHandler$AcceptHandlerHorse.run(ServerSocketAcceptHandler.java:880)
                   at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
                   at java.lang.Thread.run(Thread.java:595)
              java.lang.NullPointerException
                   at oracle.apps.pos.salesorder.webui.PosASEBacklogCO.processFormRequest(PosASEBacklogCO.java:107)
                   at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(Unknown Source)
                   at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(Unknown Source)
                   at oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processFormRequest(Unknown Source)
                   at oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processFormRequest(Unknown Source)
                   at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(Unknown Source)
                   at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(Unknown Source)
                   at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(Unknown Source)
                   at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(Unknown Source)
                   at oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processFormRequest(Unknown Source)
                   at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(Unknown Source)
                   at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(Unknown Source)
                   at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(Unknown Source)
                   at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(Unknown Source)
                   at oracle.apps.fnd.framework.webui.beans.OABodyBean.processFormRequest(Unknown Source)
                   at oracle.apps.fnd.framework.webui.OAPageBean.processFormRequest(Unknown Source)
                   at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(Unknown Source)
                   at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(Unknown Source)
                   at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(Unknown Source)
                   at OA.jspService(_OA.java:71)
                   at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
                   at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:462)
                   at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:594)
                   at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:518)
                   at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
                   at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:713)
                   at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:370)
                   at com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:871)
                   at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:453)
                   at com.evermind.server.http.HttpRequestHandler.serveOneRequest(HttpRequestHandler.java:221)
                   at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:122)
                   at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:111)
                   at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
                   at oracle.oc4j.network.ServerSocketAcceptHandler.procClientSocket(ServerSocketAcceptHandler.java:239)
                   at oracle.oc4j.network.ServerSocketAcceptHandler.access$700(ServerSocketAcceptHandler.java:34)
                   at oracle.oc4j.network.ServerSocketAcceptHandler$AcceptHandlerHorse.run(ServerSocketAcceptHandler.java:880)
                   at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
                   at java.lang.Thread.run(Thread.java:595)


              jest i change code in co so i am getting this type of error the query executing i given sop in evety block
              CO:
              // if(CSDTxt == "" && Csdto == "" && partnumberTxt == "" && CustomerTxt == "" && salesorderlineTxt == "")


              thanks.
              • 4. Re: How to display advance table based on parameter pls give me solution urgent
                1005875
                I tryed this.query executing but getting same nullpointer exception pls give me reply asap thanks.

                13/05/24 10:23:51 i am in paramete1 CSDTxt= 21-Dec-2011
                13/05/24 10:23:51 i am in paramete2 null Csdto=
                13/05/24 10:23:51 i am in paramete3 partnumberTxt= 324-000020-01
                13/05/24 10:23:51 i am in paramete4 CustomerTxt= MEKTEC CORPORATION
                13/05/24 10:23:51 i am in paramete5 salesorderlineTxt= 538867-8-1
                13/05/24 10:24:08 i am executeQuery successfully Getting Query== SELECT * FROM (SELECT
                'N' selectRow
                ,customer_name
                ,so_line_shipment
                ,part_number
                ,customer_item_number
                ,cust_po_number
                ,ordered_date
                ,promise_date
                ,schedule_ship_date
                ,shipping_terms
                ,shipping_method
                ,ordered_quantity
                ,shipping_instructions
                ,ship_to_address
                ,ship_to_contact
                ,ship_to_phone
                ,"Hold Name"
                ,"Hold Release Flag"
                ,order_number
                ,OPERATING_UNIT
                FROM APPS.XXSY_SYNA_ASE_BACKLOG
                where (to_date(promise_date,'dd-mm-rrrr')
                between nvl(:1,to_date(promise_date,'dd-mm-rrrr')) and nvl(:2,to_date(promise_date,'dd-mm-rrrr')))
                and part_number = NVL(:3, NVL(part_number,1))
                AND customer_name = NVL(:4, NVL(customer_name,1))
                and so_line_shipment = NVL(:5, NVL(so_line_shipment,1))) QRSLT ORDER BY schedule_ship_date,customer_name,so_line_shipment
                • 5. Re: How to display advance table based on parameter pls give me solution urgent
                  Sandeep M.
                  PosASEBacklogCO.java:107

                  This is the place where you are getting null pointer error.

                  Check the line number 107 in PosASEBacklogCO.java.
                  Post that line here and let us know what exactly you want to achieve by modifying the code.

                  By the way are you modifying standard controller directly?
                  if yes then it's not the right way and you should be extending the standard controller and place your logic there.
                  • 6. Re: How to display advance table based on parameter pls give me solution urgent
                    1005875
                    HI

                    The line number of 107 is

                    System.out.println("Execute Query:- "+ASEBacklogVO.getQuery());

                    and this is not a standard controller and we are doing Custom OAF Page and Custom Controller also.

                    Just tell me where i am going wrong because the code and everything is correct i guess because even i am showing you the query if run the query in the backend also we are able to get records even if it is null.

                    Thanks in advance

                    Edited by: 1002872 on May 24, 2013 6:46 AM
                    • 7. Re: How to display advance table based on parameter pls give me solution urgent
                      1005875
                      any one Pls give me any idea asap.

                      wr should i change the code?
                      • 8. Re: How to display advance table based on parameter pls give me solution urgent
                        Sandeep M.
                        That line cannot raise null pointer error because you are getting the query successfully.

                        Could you please post the complete controller code here also if you have made the changes to CO please run again and paste the complete error stack again so that we can map the correct line number in error.