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.WSH_FLEX_PKG_COGS dependencies on WSH_FLEX_PKG_COGS

Line 1: PACKAGE BODY WSH_FLEX_PKG_COGS AS

1: PACKAGE BODY WSH_FLEX_PKG_COGS AS
2: /* $Header: WSHWFDFB.pls 115.6 99/07/16 08:24:40 porting ship $ */
3:
4: /*
5: * Global Variables

Line 199: wf_core.context('WSH_FLEX_PKG_COGS','START_PROCESS',X_COMMITMENT_ID,X_CUSTOMER_ID,X_ORDER_TYPE_ID ,X_ORG_ID);

195: WHEN OTHERS THEN
196: IF (DEBUG_COGS) THEN
197: PRINTLN('ERROR: other excpn of START_PROCESS :'||sqlerrm);
198: END IF;
199: wf_core.context('WSH_FLEX_PKG_COGS','START_PROCESS',X_COMMITMENT_ID,X_CUSTOMER_ID,X_ORDER_TYPE_ID ,X_ORG_ID);
200: raise;
201: END; /* START_PROCESS */
202:
203: /*===========================================================================+

Line 223: PRINTLN('Calling WSH_FLEX_PKG_COGS.GET_COST_SALE_ITEM_DERIVED');

219: FB_ERROR_MSG VARCHAR2(240) DEFAULT NULL;
220: BEGIN <>
221: IF (DEBUG_COGS) THEN
222: DBMS_OUTPUT.ENABLE(1000000);
223: PRINTLN('Calling WSH_FLEX_PKG_COGS.GET_COST_SALE_ITEM_DERIVED');
224: PRINTLN('FUNCMODE = '||FUNCMODE);
225: END IF;
226: IF (FUNCMODE = 'RUN') THEN
227: L_LINE_DETAIL_ID:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'LINE_DETAIL_ID');

Line 360: wf_core.context('WSH_FLEX_PKG_COGS','GET_COST_SALE_ITEM_DERIVED',

356: WHEN OTHERS THEN
357: IF (DEBUG_COGS) THEN
358: PRINTLN('ERROR: other excpn of GET_COST_SALE_ITEM_DERIVED : '||sqlerrm);
359: END IF;
360: wf_core.context('WSH_FLEX_PKG_COGS','GET_COST_SALE_ITEM_DERIVED',
361: itemtype,itemkey,TO_CHAR(actid),funcmode);
362: result := 'COMPLETE:FAILURE';
363: RAISE;
364: END; /* GET_COST_SALE_ITEM_DERIVED */

Line 386: PRINTLN('Calling WSH_FLEX_PKG_COGS.GET_COST_SALE_MODEL_DERIVED');

382: FB_ERROR_MSG VARCHAR2(240) DEFAULT NULL;
383: BEGIN <>
384: IF (DEBUG_COGS) THEN
385: DBMS_OUTPUT.ENABLE(1000000);
386: PRINTLN('Calling WSH_FLEX_PKG_COGS.GET_COST_SALE_MODEL_DERIVED');
387: PRINTLN('FUNCMODE = '||FUNCMODE);
388: END IF;
389: IF (FUNCMODE = 'RUN') THEN
390: L_LINE_DETAIL_ID:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'LINE_DETAIL_ID');

Line 552: wf_core.context('WSH_FLEX_PKG_COGS','GET_COST_SALE_MODEL_DERIVED',

548: WHEN OTHERS THEN
549: IF (DEBUG_COGS) THEN
550: PRINTLN('ERROR: other excpn of GET_COST_SALE_MODEL_DERIVED : '||sqlerrm);
551: END IF;
552: wf_core.context('WSH_FLEX_PKG_COGS','GET_COST_SALE_MODEL_DERIVED',
553: itemtype,itemkey,TO_CHAR(actid),funcmode);
554: result := 'COMPLETE:FAILURE';
555: RAISE;
556: END; /* GET_COST_SALE_MODEL_DERIVED */

Line 576: PRINTLN('Calling WSH_FLEX_PKG_COGS.GET_ORDER_TYPE_DERIVED');

572: FB_ERROR_MSG VARCHAR2(240) DEFAULT NULL;
573: BEGIN <>
574: IF (DEBUG_COGS) THEN
575: DBMS_OUTPUT.ENABLE(1000000);
576: PRINTLN('Calling WSH_FLEX_PKG_COGS.GET_ORDER_TYPE_DERIVED');
577: PRINTLN('FUNCMODE = '||FUNCMODE);
578: END IF;
579: IF (FUNCMODE = 'RUN') THEN
580: L_ORDER_TYPE_ID := wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORDER_TYPE_ID');

Line 632: wf_core.context('WSH_FLEX_PKG_COGS','GET_ORDER_TYPE_DERIVED',

628: WHEN OTHERS THEN
629: IF (DEBUG_COGS) THEN
630: PRINTLN('ERROR: other excpn of GET_ORDER_TYPE_DERIVED : '||sqlerrm);
631: END IF;
632: wf_core.context('WSH_FLEX_PKG_COGS','GET_ORDER_TYPE_DERIVED',
633: itemtype,itemkey,TO_CHAR(actid),funcmode);
634: result := 'COMPLETE:FAILURE';
635: RAISE;
636: END; /* GET_ORDER_TYPE_DERIVED */

Line 655: PRINTLN('Calling WSH_FLEX_PKG_COGS.GET_SALESREP_REV_DERIVED');

651: FB_ERROR_MSG VARCHAR2(240) DEFAULT NULL;
652: BEGIN <>
653: IF (DEBUG_COGS) THEN
654: DBMS_OUTPUT.ENABLE(1000000);
655: PRINTLN('Calling WSH_FLEX_PKG_COGS.GET_SALESREP_REV_DERIVED');
656: PRINTLN('FUNCMODE = '||FUNCMODE);
657: END IF;
658: IF (FUNCMODE = 'RUN') THEN
659: L_SALESREP_ID := wf_engine.GetActivityAttrNumber(itemtype,itemkey,actid,'SALESREPID');

Line 711: wf_core.context('WSH_FLEX_PKG_COGS','GET_SALESREP_REV_DERIVED',

707: WHEN OTHERS THEN
708: IF (DEBUG_COGS) THEN
709: PRINTLN('ERROR: other excpn of GET_SALESREP_REV_DERIVED : '||sqlerrm);
710: END IF;
711: wf_core.context('WSH_FLEX_PKG_COGS','GET_SALESREP_REV_DERIVED',
712: itemtype,itemkey,TO_CHAR(actid),funcmode);
713: result := 'COMPLETE:FAILURE';
714: RAISE;
715: END; /* GET_SALESREP_REV_DERIVED */

Line 734: PRINTLN('Calling WSH_FLEX_PKG_COGS.GET_SALESREP_ID');

730: FB_ERROR_MSG VARCHAR2(240) DEFAULT NULL;
731: BEGIN <>
732: IF (DEBUG_COGS) THEN
733: DBMS_OUTPUT.ENABLE(1000000);
734: PRINTLN('Calling WSH_FLEX_PKG_COGS.GET_SALESREP_ID');
735: PRINTLN('FUNCMODE = '||FUNCMODE);
736: END IF;
737: IF (FUNCMODE = 'RUN') THEN
738: L_ORDER_LINE_ID:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORDER_LINE_ID');

Line 815: wf_core.context('WSH_FLEX_PKG_COGS','GET_SALESREP_ID',

811: WHEN OTHERS THEN
812: IF (DEBUG_COGS) THEN
813: PRINTLN('ERROR: other excpn of GET_SALESREP_ID : '||sqlerrm);
814: END IF;
815: wf_core.context('WSH_FLEX_PKG_COGS','GET_SALESREP_ID',
816: itemtype,itemkey,TO_CHAR(actid),funcmode);
817: result := 'COMPLETE:FAILURE';
818: RAISE;
819: END; /* GET_SALESREP_ID */

Line 840: PRINTLN('Calling WSH_FLEX_PKG_COGS.GET_COST_SALE');

836: FB_ERROR_MSG VARCHAR2(240) DEFAULT NULL;
837: BEGIN <>
838: IF (DEBUG_COGS) THEN
839: DBMS_OUTPUT.ENABLE(1000000);
840: PRINTLN('Calling WSH_FLEX_PKG_COGS.GET_COST_SALE');
841: PRINTLN('FUNCMODE = '||FUNCMODE);
842: END IF;
843: IF (FUNCMODE = 'RUN') THEN
844: L_INV_ITEM_ID := wf_engine.GetActivityAttrNumber(itemtype,itemkey,actid,'INVITEMID');

Line 904: wf_core.context('WSH_FLEX_PKG_COGS','GET_SALESREP_REV_DERIVED',

900: WHEN OTHERS THEN
901: IF (DEBUG_COGS) THEN
902: PRINTLN('ERROR: other excpn of GET_COST_SALE : '||sqlerrm);
903: END IF;
904: wf_core.context('WSH_FLEX_PKG_COGS','GET_SALESREP_REV_DERIVED',
905: itemtype,itemkey,TO_CHAR(actid),funcmode);
906: result := 'COMPLETE:FAILURE';
907: RAISE;
908: END; /* GET_COST_SALE */

Line 927: PRINTLN('Calling WSH_FLEX_PKG_COGS.GET_INV_ITEM_ID');

923: FB_ERROR_MSG VARCHAR2(240) DEFAULT NULL;
924: BEGIN <>
925: IF (DEBUG_COGS) THEN
926: DBMS_OUTPUT.ENABLE(1000000);
927: PRINTLN('Calling WSH_FLEX_PKG_COGS.GET_INV_ITEM_ID');
928: PRINTLN('FUNCMODE = '||FUNCMODE);
929: END IF;
930: IF (FUNCMODE = 'RUN') THEN
931: L_ORDER_LINE_ID:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORDER_LINE_ID');

Line 986: wf_core.context('WSH_FLEX_PKG_COGS','GET_INV_ITEM_ID',

982: WHEN OTHERS THEN
983: IF (DEBUG_COGS) THEN
984: PRINTLN('ERROR: other excpn of GET_INV_ITEM_ID : '||sqlerrm);
985: END IF;
986: wf_core.context('WSH_FLEX_PKG_COGS','GET_INV_ITEM_ID',
987: itemtype,itemkey,TO_CHAR(actid),funcmode);
988: result := 'COMPLETE:FAILURE';
989: RAISE;
990: END; /* GET_INV_ITEM_ID */

Line 1009: PRINTLN('Calling WSH_FLEX_PKG_COGS.GET_TRX_TYPE');

1005: FB_ERROR_MSG VARCHAR2(240) DEFAULT NULL;
1006: BEGIN <>
1007: IF (DEBUG_COGS) THEN
1008: DBMS_OUTPUT.ENABLE(1000000);
1009: PRINTLN('Calling WSH_FLEX_PKG_COGS.GET_TRX_TYPE');
1010: END IF;
1011: IF (FUNCMODE = 'RUN') THEN
1012: L_COMMITMENT_ID:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'COMMITMENT_ID');
1013: IF (DEBUG_COGS) THEN

Line 1071: wf_core.context('WSH_FLEX_PKG_COGS','GET_TRX_TYPE',

1067: WHEN OTHERS THEN
1068: IF (DEBUG_COGS) THEN
1069: PRINTLN('ERROR: other excpn of GET_TRX_TYPE : '||sqlerrm);
1070: END IF;
1071: wf_core.context('WSH_FLEX_PKG_COGS','GET_TRX_TYPE',
1072: itemtype,itemkey,TO_CHAR(actid),funcmode);
1073: result := 'COMPLETE:FAILURE';
1074: RAISE;
1075: END; /* GET_TRX_TYPE */

Line 1094: PRINTLN('Calling WSH_FLEX_PKG_COGS.GET_OPERATING_UNIT');

1090: FB_ERROR_MSG VARCHAR2(240) DEFAULT NULL;
1091: BEGIN <>
1092: IF (DEBUG_COGS) THEN
1093: DBMS_OUTPUT.ENABLE(1000000);
1094: PRINTLN('Calling WSH_FLEX_PKG_COGS.GET_OPERATING_UNIT');
1095: PRINTLN('FUNCMODE = '||FUNCMODE);
1096: END IF;
1097: IF (FUNCMODE = 'RUN') THEN
1098: L_ORDER_LINE_ID:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORDER_LINE_ID');

Line 1155: wf_core.context('WSH_FLEX_PKG_COGS','GET_OPERATING_UNIT',

1151: WHEN OTHERS THEN
1152: IF (DEBUG_COGS) THEN
1153: PRINTLN('ERROR: other excpn of GET_OPERATING_UNIT : '||sqlerrm);
1154: END IF;
1155: wf_core.context('WSH_FLEX_PKG_COGS','GET_OPERATING_UNIT',
1156: itemtype,itemkey,TO_CHAR(actid),funcmode);
1157: result := 'COMPLETE:FAILURE';
1158: RAISE;
1159: END; /* GET_OPERATING_UNIT */

Line 1178: PRINTLN('Calling WSH_FLEX_PKG_COGS.GET_PARENT_LINE');

1174: FB_ERROR_MSG VARCHAR2(240) DEFAULT NULL;
1175: BEGIN <>
1176: IF (DEBUG_COGS) THEN
1177: DBMS_OUTPUT.ENABLE(1000000);
1178: PRINTLN('Calling WSH_FLEX_PKG_COGS.GET_PARENT_LINE');
1179: PRINTLN('FUNCMODE = '||FUNCMODE);
1180: END IF;
1181: IF (FUNCMODE = 'RUN') THEN
1182: L_ORDER_LINE_ID:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORDER_LINE_ID');

Line 1234: wf_core.context('WSH_FLEX_PKG_COGS','GET_PARENT_LINE',

1230: WHEN OTHERS THEN
1231: IF (DEBUG_COGS) THEN
1232: PRINTLN('ERROR: other excpn of GET_PARENT_LINE : '||sqlerrm);
1233: END IF;
1234: wf_core.context('WSH_FLEX_PKG_COGS','GET_PARENT_LINE',
1235: itemtype,itemkey,TO_CHAR(actid),funcmode);
1236: result := 'COMPLETE:FAILURE';
1237: RAISE;
1238: END; /* GET_PARENT_LINE */

Line 1240: END WSH_FLEX_PKG_COGS;

1236: result := 'COMPLETE:FAILURE';
1237: RAISE;
1238: END; /* GET_PARENT_LINE */
1239:
1240: END WSH_FLEX_PKG_COGS;