Issue while creating Org specific WMS screen

[Siddhi Dwivedi]

Hi Senthil,

mOrgCodeFld is a text field and I am trying to redirect to the next page on entering mOrgCodeFld value.Not sure whether this approach is correct ar not.

Regarding second query,

public void initLayout(Session session)
{
log(" Initializing page layout", "initLayout");
UtilFns.log("Siddhi getting org*** "+(String)session.getValue("ORGCODE"));
// session.putObject("ORGID",session.getObject("ORGCODE"));
mDockDoorFld = new DockDoorLOV();
mDockDoorFld.setName("LoadTruck.DockDoor");
mDockDoorFld.setValidateFromLOV(true);
mDockDoorFld.setRequired(true);
String as[] = {
" ", " ", "ORGID", "oracle.apps.inv.wshtxn.server.XX2LoadTruckPage.LoadTruck.DockDoor"
};
mDockDoorFld.setInputParameters(as);


Above piece of code is my class file 'XX2LoadTruckPage.class' which I am trying to load after entering org code.
I am not able to figure out what should be passed at "ORGID" in below command

String as[] = {
" ", " ", "ORGID", "oracle.apps.inv.wshtxn.server.XX2LoadTruckPage.LoadTruck.DockDoor"
};

I tried with hardcoded value also but didn't get any success.By the time I am trying to upload my files at your forum.Below is the error piece:
[Thu Jul 02 02:19:46 EDT 2009] (Thread-12) MWA_PM_UNEXPECTED_ERROR_MESG: Unexpected error occurred, Please check the log.
java.lang.NullPointerException
at oracle.apps.inv.wshtxn.server.XX2LoadTruckPage.pageEntered(XX2LoadTruckPage.java:210)
at oracle.apps.mwa.container.StateMachine.callListeners(StateMachine.java:1590)
at oracle.apps.mwa.container.StateMachine.handleEvent(StateMachine.java:991)
at oracle.apps.mwa.container.StateMachine.handleEvent(StateMachine.java:822)
at oracle.apps.mwa.presentation.telnet.PresentationManager.handle(PresentationManager.java:690)
at oracle.apps.mwa.presentation.telnet.ProtocolHandler.run(ProtocolHandler.java:818)
[Thu Jul 02 02:19:48 EDT 2009] (Thread-12) (C9975232) purgePageStack: purging at pageIx = 6
[Thu Jul 02 02:19:48 EDT 2009] (Thread-12) (C9975232) handleEvent: entering LOVRuntimePageBean
[Thu Jul 02 02:19:48 EDT 2009] (Thread-12) (C9975232) loadPage: trying to load 'oracle.apps.mwa.beans.LOVRuntimePageBean'; customization :null
[Thu Jul 02 02:19:48 EDT 2009] (Thread-12) (C9975232) loadPage: trying to load 'oracle.apps.mwa.beans.LOVRuntimePageBean'
[Thu Jul 02 02:19:48 EDT 2009] (Thread-12) (C9975232) purgePageStack: purging at pageIx = 6
[Thu Jul 02 02:19:48 EDT 2009] (Thread-12) addPage: old current page = 6
[Thu Jul 02 02:19:48 EDT 2009] (Thread-12) addPage: new current page = 7
[Thu Jul 02 02:19:48 EDT 2009] (Thread-12) addPage: adding 0 fields to hashtable
[Thu Jul 02 02:19:48 EDT 2009] (Thread-12) (C9975232) loadPage: done loading 'oracle.apps.mwa.beans.LOVRuntimePageBean' (pageIx = 7, fieldIx = 0)
[Thu Jul 02 02:19:48 EDT 2009] (Thread-12) (C9975232) handleEvent: entering new page (pageIx = 7)
[Thu Jul 02 02:19:48 EDT 2009] (Thread-12) (C9975232) callListeners: executing 1 listeners, action = 0
[Thu Jul 02 02:19:48 EDT 2009] (Thread-12) (C9975232) callListeners: PageBean
[Thu Jul 02 02:19:48 EDT 2009] (Thread-12) Entering pageEntered of LOVRuntimePageHandler
[Thu Jul 02 02:19:48 EDT 2009] (Thread-12) lov stmt :WMS_SHIPPING_TRANSACTION_PUB.GET_DOCK_DOORS
[Thu Jul 02 02:19:48 EDT 2009] (Thread-12) inputParams[0] :
[Thu Jul 02 02:19:48 EDT 2009] (Thread-12) inputParamsType[0] :C
[Thu Jul 02 02:19:48 EDT 2009] (Thread-12) value of inputParams[0] :null
[Thu Jul 02 02:19:48 EDT 2009] (Thread-12) inputParams[1] :
[Thu Jul 02 02:19:48 EDT 2009] (Thread-12) inputParamsType[1] :S
[Thu Jul 02 02:19:48 EDT 2009] (Thread-12) value of inputParams[1] :null
[Thu Jul 02 02:19:48 EDT 2009] (Thread-12) inputParams[2] :ORGID
[Thu Jul 02 02:19:48 EDT 2009] (Thread-12) inputParamsType[2] :N
[Thu Jul 02 02:19:48 EDT 2009] (Thread-12) value of inputParams[2] :null
[Thu Jul 02 02:19:48 EDT 2009] (Thread-12) inputParams[3] racle.apps.inv.wshtxn.server.XX2LoadTruckPage.LoadTruck.DockDoor
[Thu Jul 02 02:19:48 EDT 2009] (Thread-12) inputParamsType[3] :S
[Thu Jul 02 02:19:48 EDT 2009] (Thread-12) value of inputParams[3] :1<T32 >
[Thu Jul 02 02:19:48 EDT 2009] (Thread-12) No result is found
[Thu Jul 02 02:19:48 EDT 2009] (Thread-12) Exiting pageEntered of LOVRuntimePageHandler

Appreciate your prompt response.
Thanks & Regards,
Siddhi[code][/code]

[Siddhi Dwivedi]

uploading code...

[kthomas]

I would not worry about the ORGID, that is taken from the session context value.

As for redirecting the user to another mobile page you need to handle this in the LISTENER.

Ex:

Code: Select all

     public void fieldExited ()
     {
        if (flag && s.equals("XX.YOURCUSTOMFIELD")) {
            execContinue(mwaevent); 
            return;
        } 
     }

    public void execContinue(MWAEvent mwaevent) throws AbortHandlerException
    {
        Session ses = mwaevent.getSession();
        mYOURCUSTOMFIELD.setNextPageName("xxx.oracle.apps.xxcust.xxYOURCUSTOMPAGE");
        ses.setRefreshScreen(true);       
    } 


[kthomas]

Your issue is that your LOV is not returning any values:

Code: Select all

[Thu Jul 02 02:19:48 EDT 2009] (Thread-12) No result is found


If you wanted you could create your own LOV by just using a callableStatement to return the cursor. I do this on all my custom LOVs. You could put it into a Utils file if you need to use it in other forms.

My suggestion is to start small and debug step by step.

Good Luck!

[Siddhi Dwivedi]

Hello,

Thanks to all...
My issue is fixed...

Regards,
Siddhi

[kthomas]

Hello,

Thanks to all...
My issue is fixed...

Regards,
Siddhi

Siddhi,

It would be beneficial if you would post the resolution in this thread so that if others come across they can view your code source and see the problem/solution. We're all developers here and any help that you can contribute back to the site would be greatful.

[Siddhi Dwivedi]

Hi,
Below is the code piece to fetch ORGID LOV

public XXValidOrgLOV()
{
try{
mLOVType = "OrgInfo.ORGID";
setName("OrgInfo.ORGID");
setRequired(false);
setValidateFromLOV(true);
setHidden(true);
setlovStatement("XX_VALIDATE_ORG.XXVALID_ORG");
String as[] = {"C"};
boolean aflag[] = {true , false};
setInputParameterTypes(as);
String as1[] = {"a" , "a"};
setSubfieldPrompts(as1);
setSubfieldDisplays(aflag);
addListener(this);
}catch(Exception e){

UtilFns.error("Error in calling Valid Org LOV" + e);
}
}

I passed ORGID to different pages by putting ORGID value in session:

session.putObject("ORGID",session.getObject("ORGID"));

And the culprit code piece was
OrgParameters orgparameters = (OrgParameters)session.getObject("ORG_PARAMETERS");
s = orgparameters.getDirectShipEnabled();

which I was not able to fix so i commented this part and wrote a query to fetch DirectShipEnabled flag for given ORGID to let me perform Direct Ship function.

String q = "{ call XX_VALIDATE_ORG.CHK_DIRECT_SHIP_ENABLED(?,?,?) }";
CallableStatement = mConn.prepareCall(q);
callablestatement.setLong(1, l);
callablestatement.registerOutParameter(2, Types.VARCHAR);
callablestatement.registerOutParameter(3, Types.INTEGER);

========
PROCEDURE CHK_DIRECT_SHIP_ENABLED(v_org_id IN NUMBER
,p_ship_flag OUT VARCHAR
,p_retcode OUT NOCOPY NUMBER)IS


v_organization_id NUMBER:=0;
v_direct_ship_flag VARCHAR2(10);

BEGIN

v_direct_ship_flag := 'N';

SELECT organization_id,
nvl(direct_shipping_allowed, 'N') direct_ship_enabled
INTO v_organization_id
,v_direct_ship_flag
FROM apps.mtl_parameters
WHERE organization_id = v_org_id;

p_ship_flag := v_direct_ship_flag;
p_retcode := 1;

Thnaks & Regards,
Siddhi