This discussion is archived
8 Replies Latest reply: May 26, 2013 11:59 PM by SandeepM. RSS

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

1005875 Newbie
Currently Being Moderated
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 Expert
    Currently Being Moderated
    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
    SandeepM. Journeyer
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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
    SandeepM. Journeyer
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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
    SandeepM. Journeyer
    Currently Being Moderated
    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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points