eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSTPACWF dependencies on CSTPACWF

Line 1: PACKAGE BODY CSTPACWF AS

1: PACKAGE BODY CSTPACWF AS
2: /* $Header: CSTACWFB.pls 120.1 2006/09/11 08:44:18 arathee noship $ */
3:
4: -- FUNCTION
5: -- START_AVG_WF Calls the appropriate Average Costing Workflow process

Line 250: X_ERR_MSG := 'Error in CSTPACWF.START_AVG_WF' || substrb(SQLERRM,1,150);

246: EXCEPTION
247: WHEN OTHERS THEN
248: X_ERR_NUM := -1;
249: X_ERR_CODE := TO_CHAR(SQLCODE);
250: X_ERR_MSG := 'Error in CSTPACWF.START_AVG_WF' || substrb(SQLERRM,1,150);
251: return 0;
252: RAISE;
253: END; /* START_AVG_WF */
254:

Line 299: wf_core.context('CSTPACWF','GET_AVG_CE',itemtype,itemkey,TO_CHAR(actid),funcmode);

295: END IF;
296:
297: EXCEPTION
298: WHEN OTHERS THEN
299: wf_core.context('CSTPACWF','GET_AVG_CE',itemtype,itemkey,TO_CHAR(actid),funcmode);
300: wf_engine.SetItemAttrNumber(itemtype,itemkey,'ACCT',0);
301: wf_engine.SetItemAttrNumber(itemtype,itemkey,'ERR_NUM',-1);
302: wf_engine.SetItemAttrText(itemtype,itemkey,'ERR_CODE',TO_CHAR(SQLCODE));
303: wf_engine.SetItemAttrText(itemtype,itemkey,'ERR_MSG','Error in CSTPACWF.GET_AVG_CE' || substrb(SQLERRM,1,150));

Line 303: wf_engine.SetItemAttrText(itemtype,itemkey,'ERR_MSG','Error in CSTPACWF.GET_AVG_CE' || substrb(SQLERRM,1,150));

299: wf_core.context('CSTPACWF','GET_AVG_CE',itemtype,itemkey,TO_CHAR(actid),funcmode);
300: wf_engine.SetItemAttrNumber(itemtype,itemkey,'ACCT',0);
301: wf_engine.SetItemAttrNumber(itemtype,itemkey,'ERR_NUM',-1);
302: wf_engine.SetItemAttrText(itemtype,itemkey,'ERR_CODE',TO_CHAR(SQLCODE));
303: wf_engine.SetItemAttrText(itemtype,itemkey,'ERR_MSG','Error in CSTPACWF.GET_AVG_CE' || substrb(SQLERRM,1,150));
304: result := 'COMPLETE:FAILURE';
305: RAISE;
306: END; /* GET_AVG_CE */
307:

Line 341: wf_core.context('CSTPACWF','GET_DEF_ACC',itemtype,itemkey,TO_CHAR(actid),funcmode);

337: RETURN;
338: END IF;
339: EXCEPTION
340: WHEN OTHERS THEN
341: wf_core.context('CSTPACWF','GET_DEF_ACC',itemtype,itemkey,TO_CHAR(actid),funcmode);
342: wf_engine.SetItemAttrNumber(itemtype,itemkey,'ACCT',0);
343: wf_engine.SetItemAttrNumber(itemtype,itemkey,'ERR_NUM',-1);
344: wf_engine.SetItemAttrText(itemtype,itemkey,'ERR_CODE',TO_CHAR(SQLCODE));
345: wf_engine.SetItemAttrText(itemtype,itemkey,'ERR_MSG','Error in CSTPACWF.GET_DEF_ACC' || substrb(SQLERRM,1,150));

Line 345: wf_engine.SetItemAttrText(itemtype,itemkey,'ERR_MSG','Error in CSTPACWF.GET_DEF_ACC' || substrb(SQLERRM,1,150));

341: wf_core.context('CSTPACWF','GET_DEF_ACC',itemtype,itemkey,TO_CHAR(actid),funcmode);
342: wf_engine.SetItemAttrNumber(itemtype,itemkey,'ACCT',0);
343: wf_engine.SetItemAttrNumber(itemtype,itemkey,'ERR_NUM',-1);
344: wf_engine.SetItemAttrText(itemtype,itemkey,'ERR_CODE',TO_CHAR(SQLCODE));
345: wf_engine.SetItemAttrText(itemtype,itemkey,'ERR_MSG','Error in CSTPACWF.GET_DEF_ACC' || substrb(SQLERRM,1,150));
346: result := 'COMPLETE:FAILURE';
347: RAISE;
348: END; /* GET_DEF_ACC */
349:

Line 418: wf_core.context('CSTPACWF','GET_AVG_MTL_PLA',itemtype,itemkey,TO_CHAR(actid),funcmode);

414: RETURN;
415:
416:
417: WHEN OTHERS THEN
418: wf_core.context('CSTPACWF','GET_AVG_MTL_PLA',itemtype,itemkey,TO_CHAR(actid),funcmode);
419: wf_engine.SetItemAttrNumber(itemtype,itemkey,'ACCT',0);
420: wf_engine.SetItemAttrNumber(itemtype,itemkey,'ERR_NUM',-1);
421: wf_engine.SetItemAttrText(itemtype,itemkey,'ERR_CODE',TO_CHAR(SQLCODE));
422: wf_engine.SetItemAttrText(itemtype,itemkey,'ERR_MSG','Error in CSTPACWF.GET_AVG_MTL_PLA' || substrb(SQLERRM,1,150));

Line 422: wf_engine.SetItemAttrText(itemtype,itemkey,'ERR_MSG','Error in CSTPACWF.GET_AVG_MTL_PLA' || substrb(SQLERRM,1,150));

418: wf_core.context('CSTPACWF','GET_AVG_MTL_PLA',itemtype,itemkey,TO_CHAR(actid),funcmode);
419: wf_engine.SetItemAttrNumber(itemtype,itemkey,'ACCT',0);
420: wf_engine.SetItemAttrNumber(itemtype,itemkey,'ERR_NUM',-1);
421: wf_engine.SetItemAttrText(itemtype,itemkey,'ERR_CODE',TO_CHAR(SQLCODE));
422: wf_engine.SetItemAttrText(itemtype,itemkey,'ERR_MSG','Error in CSTPACWF.GET_AVG_MTL_PLA' || substrb(SQLERRM,1,150));
423: result := 'COMPLETE:FAILURE';
424: RAISE;
425: END; /* GET_AVG_MTL_PLA */
426:

Line 495: wf_core.context('CSTPACWF','GET_AVG_MO_PLA',itemtype,itemkey,TO_CHAR(actid),funcmode);

491: RETURN;
492:
493:
494: WHEN OTHERS THEN
495: wf_core.context('CSTPACWF','GET_AVG_MO_PLA',itemtype,itemkey,TO_CHAR(actid),funcmode);
496: wf_engine.SetItemAttrNumber(itemtype,itemkey,'ACCT',0);
497: wf_engine.SetItemAttrNumber(itemtype,itemkey,'ERR_NUM',-1);
498: wf_engine.SetItemAttrText(itemtype,itemkey,'ERR_CODE',TO_CHAR(SQLCODE));
499: wf_engine.SetItemAttrText(itemtype,itemkey,'ERR_MSG','Error in CSTPACWF.GET_AVG_MO_PLA' || substrb(SQLERRM,1,150));

Line 499: wf_engine.SetItemAttrText(itemtype,itemkey,'ERR_MSG','Error in CSTPACWF.GET_AVG_MO_PLA' || substrb(SQLERRM,1,150));

495: wf_core.context('CSTPACWF','GET_AVG_MO_PLA',itemtype,itemkey,TO_CHAR(actid),funcmode);
496: wf_engine.SetItemAttrNumber(itemtype,itemkey,'ACCT',0);
497: wf_engine.SetItemAttrNumber(itemtype,itemkey,'ERR_NUM',-1);
498: wf_engine.SetItemAttrText(itemtype,itemkey,'ERR_CODE',TO_CHAR(SQLCODE));
499: wf_engine.SetItemAttrText(itemtype,itemkey,'ERR_MSG','Error in CSTPACWF.GET_AVG_MO_PLA' || substrb(SQLERRM,1,150));
500: result := 'COMPLETE:FAILURE';
501: RAISE;
502: END; /* GET_AVG_MO_PLA */
503:

Line 572: wf_core.context('CSTPACWF','GET_AVG_RES_PLA',itemtype,itemkey,TO_CHAR(actid),funcmode);

568: RETURN;
569:
570:
571: WHEN OTHERS THEN
572: wf_core.context('CSTPACWF','GET_AVG_RES_PLA',itemtype,itemkey,TO_CHAR(actid),funcmode);
573: wf_engine.SetItemAttrNumber(itemtype,itemkey,'ACCT',0);
574: wf_engine.SetItemAttrNumber(itemtype,itemkey,'ERR_NUM',-1);
575: wf_engine.SetItemAttrText(itemtype,itemkey,'ERR_CODE',TO_CHAR(SQLCODE));
576: wf_engine.SetItemAttrText(itemtype,itemkey,'ERR_MSG','Error in CSTPACWF.GET_AVG_RES_PLA' || substrb(SQLERRM,1,150));

Line 576: wf_engine.SetItemAttrText(itemtype,itemkey,'ERR_MSG','Error in CSTPACWF.GET_AVG_RES_PLA' || substrb(SQLERRM,1,150));

572: wf_core.context('CSTPACWF','GET_AVG_RES_PLA',itemtype,itemkey,TO_CHAR(actid),funcmode);
573: wf_engine.SetItemAttrNumber(itemtype,itemkey,'ACCT',0);
574: wf_engine.SetItemAttrNumber(itemtype,itemkey,'ERR_NUM',-1);
575: wf_engine.SetItemAttrText(itemtype,itemkey,'ERR_CODE',TO_CHAR(SQLCODE));
576: wf_engine.SetItemAttrText(itemtype,itemkey,'ERR_MSG','Error in CSTPACWF.GET_AVG_RES_PLA' || substrb(SQLERRM,1,150));
577: result := 'COMPLETE:FAILURE';
578: RAISE;
579: END; /* GET_AVG_RES_PLA */
580:

Line 648: wf_core.context('CSTPACWF','GET_AVG_OSP_PLA',itemtype,itemkey,TO_CHAR(actid),funcmode);

644: RETURN;
645:
646:
647: WHEN OTHERS THEN
648: wf_core.context('CSTPACWF','GET_AVG_OSP_PLA',itemtype,itemkey,TO_CHAR(actid),funcmode);
649: wf_engine.SetItemAttrNumber(itemtype,itemkey,'ACCT',0);
650: wf_engine.SetItemAttrNumber(itemtype,itemkey,'ERR_NUM',-1);
651: wf_engine.SetItemAttrText(itemtype,itemkey,'ERR_CODE',TO_CHAR(SQLCODE));
652: wf_engine.SetItemAttrText(itemtype,itemkey,'ERR_MSG','Error in CSTPACWF.GET_AVG_OSP_PLA' || substrb(SQLERRM,1,150));

Line 652: wf_engine.SetItemAttrText(itemtype,itemkey,'ERR_MSG','Error in CSTPACWF.GET_AVG_OSP_PLA' || substrb(SQLERRM,1,150));

648: wf_core.context('CSTPACWF','GET_AVG_OSP_PLA',itemtype,itemkey,TO_CHAR(actid),funcmode);
649: wf_engine.SetItemAttrNumber(itemtype,itemkey,'ACCT',0);
650: wf_engine.SetItemAttrNumber(itemtype,itemkey,'ERR_NUM',-1);
651: wf_engine.SetItemAttrText(itemtype,itemkey,'ERR_CODE',TO_CHAR(SQLCODE));
652: wf_engine.SetItemAttrText(itemtype,itemkey,'ERR_MSG','Error in CSTPACWF.GET_AVG_OSP_PLA' || substrb(SQLERRM,1,150));
653: result := 'COMPLETE:FAILURE';
654: RAISE;
655: END; /* GET_AVG_OSP_PLA */
656:

Line 725: wf_core.context('CSTPACWF','GET_AVG_OVH_PLA',itemtype,itemkey,TO_CHAR(actid),funcmode);

721: RETURN;
722:
723:
724: WHEN OTHERS THEN
725: wf_core.context('CSTPACWF','GET_AVG_OVH_PLA',itemtype,itemkey,TO_CHAR(actid),funcmode);
726: wf_engine.SetItemAttrNumber(itemtype,itemkey,'ACCT',0);
727: wf_engine.SetItemAttrNumber(itemtype,itemkey,'ERR_NUM',-1);
728: wf_engine.SetItemAttrText(itemtype,itemkey,'ERR_CODE',TO_CHAR(SQLCODE));
729: wf_engine.SetItemAttrText(itemtype,itemkey,'ERR_MSG','Error in CSTPACWF.GET_AVG_OVH_PLA' || substrb(SQLERRM,1,150));

Line 729: wf_engine.SetItemAttrText(itemtype,itemkey,'ERR_MSG','Error in CSTPACWF.GET_AVG_OVH_PLA' || substrb(SQLERRM,1,150));

725: wf_core.context('CSTPACWF','GET_AVG_OVH_PLA',itemtype,itemkey,TO_CHAR(actid),funcmode);
726: wf_engine.SetItemAttrNumber(itemtype,itemkey,'ACCT',0);
727: wf_engine.SetItemAttrNumber(itemtype,itemkey,'ERR_NUM',-1);
728: wf_engine.SetItemAttrText(itemtype,itemkey,'ERR_CODE',TO_CHAR(SQLCODE));
729: wf_engine.SetItemAttrText(itemtype,itemkey,'ERR_MSG','Error in CSTPACWF.GET_AVG_OVH_PLA' || substrb(SQLERRM,1,150));
730: result := 'COMPLETE:FAILURE';
731: RAISE;
732: END; /* GET_AVG_OVH_PLA */
733:

Line 734: END CSTPACWF;

730: result := 'COMPLETE:FAILURE';
731: RAISE;
732: END; /* GET_AVG_OVH_PLA */
733:
734: END CSTPACWF;