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 WF_ENGINE

Line 123: wf_engine.SetItemAttrNumber(itemtype => L_ITEMTYPE,

119: /* Initialize the workflow item attributes */
120: IF (DEBUG_COGS) THEN
121: PRINTLN('Initilizing Workflow Item Attributes');
122: END IF;
123: wf_engine.SetItemAttrNumber(itemtype => L_ITEMTYPE,
124: itemkey => L_ITEMKEY,
125: aname =>'COMMITMENT_ID',
126: avalue => L_commitment_id);
127:

Line 128: wf_engine.SetItemAttrNumber(itemtype => L_ITEMTYPE,

124: itemkey => L_ITEMKEY,
125: aname =>'COMMITMENT_ID',
126: avalue => L_commitment_id);
127:
128: wf_engine.SetItemAttrNumber(itemtype => L_ITEMTYPE,
129: itemkey => L_ITEMKEY,
130: aname =>'CUSTOMER_ID',
131: avalue =>X_CUSTOMER_ID);
132:

Line 133: wf_engine.SetItemAttrText(itemtype => L_ITEMTYPE,

129: itemkey => L_ITEMKEY,
130: aname =>'CUSTOMER_ID',
131: avalue =>X_CUSTOMER_ID);
132:
133: wf_engine.SetItemAttrText(itemtype => L_ITEMTYPE,
134: itemkey => L_ITEMKEY,
135: aname => 'OPTION_FLAG',
136: avalue => X_OPTION_FLAG);
137:

Line 138: wf_engine.SetItemAttrText(itemtype => L_ITEMTYPE,

134: itemkey => L_ITEMKEY,
135: aname => 'OPTION_FLAG',
136: avalue => X_OPTION_FLAG);
137:
138: wf_engine.SetItemAttrText(itemtype => L_ITEMTYPE,
139: itemkey => L_ITEMKEY,
140: aname => 'ORDER_CATEGORY',
141: avalue => X_ORDER_CATEGORY);
142:

Line 143: wf_engine.SetItemAttrNumber(itemtype => L_ITEMTYPE,

139: itemkey => L_ITEMKEY,
140: aname => 'ORDER_CATEGORY',
141: avalue => X_ORDER_CATEGORY);
142:
143: wf_engine.SetItemAttrNumber(itemtype => L_ITEMTYPE,
144: itemkey => L_ITEMKEY,
145: aname => 'LINE_DETAIL_ID',
146: avalue => L_line_detail_id);
147:

Line 148: wf_engine.SetItemAttrNumber(itemtype => L_ITEMTYPE,

144: itemkey => L_ITEMKEY,
145: aname => 'LINE_DETAIL_ID',
146: avalue => L_line_detail_id);
147:
148: wf_engine.SetItemAttrNumber(itemtype => L_ITEMTYPE,
149: itemkey => L_ITEMKEY,
150: aname => 'ORDER_LINE_HEADER_ID',
151: avalue => X_ORDER_LINE_HEADER_ID);
152:

Line 153: wf_engine.SetItemAttrNumber(itemtype => L_ITEMTYPE,

149: itemkey => L_ITEMKEY,
150: aname => 'ORDER_LINE_HEADER_ID',
151: avalue => X_ORDER_LINE_HEADER_ID);
152:
153: wf_engine.SetItemAttrNumber(itemtype => L_ITEMTYPE,
154: itemkey => L_ITEMKEY,
155: aname => 'ORDER_LINE_ID',
156: avalue => X_ORDER_LINE_ID);
157:

Line 158: wf_engine.SetItemAttrNumber(itemtype => L_ITEMTYPE,

154: itemkey => L_ITEMKEY,
155: aname => 'ORDER_LINE_ID',
156: avalue => X_ORDER_LINE_ID);
157:
158: wf_engine.SetItemAttrNumber(itemtype => L_ITEMTYPE,
159: itemkey => L_ITEMKEY,
160: aname => 'PICKING_LINE_DETAIL_ID',
161: avalue => L_pick_line_detail_id);
162:

Line 163: wf_engine.SetItemAttrNumber(itemtype => L_ITEMTYPE,

159: itemkey => L_ITEMKEY,
160: aname => 'PICKING_LINE_DETAIL_ID',
161: avalue => L_pick_line_detail_id);
162:
163: wf_engine.SetItemAttrNumber(itemtype => L_ITEMTYPE,
164: itemkey => L_ITEMKEY,
165: aname => 'ORDER_TYPE_ID',
166: avalue => X_ORDER_TYPE_ID);
167:

Line 168: wf_engine.SetItemAttrNumber(itemtype => L_ITEMTYPE,

164: itemkey => L_ITEMKEY,
165: aname => 'ORDER_TYPE_ID',
166: avalue => X_ORDER_TYPE_ID);
167:
168: wf_engine.SetItemAttrNumber(itemtype => L_ITEMTYPE,
169: itemkey => L_ITEMKEY,
170: aname => 'ORGANIZATION_ID',
171: avalue => L_organization_id);
172:

Line 173: wf_engine.SetItemAttrNumber(itemtype => L_ITEMTYPE,

169: itemkey => L_ITEMKEY,
170: aname => 'ORGANIZATION_ID',
171: avalue => L_organization_id);
172:
173: wf_engine.SetItemAttrNumber(itemtype => L_ITEMTYPE,
174: itemkey => L_ITEMKEY,
175: aname =>'CHART_OF_ACCOUNTS_ID',
176: avalue =>X_FLEX_NUMBER);
177:

Line 227: L_LINE_DETAIL_ID:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'LINE_DETAIL_ID');

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');
228: L_ORDER_LINE_ID:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORDER_LINE_ID');
229: L_PICK_LINE_DETAIL_ID:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'PICKING_LINE_DETAIL_ID');
230: L_ORGANIZATION_ID:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORGANIZATION_ID');
231: L_COST_SALE_ITEM_DERIVED := NULL;

Line 228: L_ORDER_LINE_ID:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORDER_LINE_ID');

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');
228: L_ORDER_LINE_ID:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORDER_LINE_ID');
229: L_PICK_LINE_DETAIL_ID:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'PICKING_LINE_DETAIL_ID');
230: L_ORGANIZATION_ID:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORGANIZATION_ID');
231: L_COST_SALE_ITEM_DERIVED := NULL;
232:

Line 229: L_PICK_LINE_DETAIL_ID:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'PICKING_LINE_DETAIL_ID');

225: END IF;
226: IF (FUNCMODE = 'RUN') THEN
227: L_LINE_DETAIL_ID:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'LINE_DETAIL_ID');
228: L_ORDER_LINE_ID:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORDER_LINE_ID');
229: L_PICK_LINE_DETAIL_ID:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'PICKING_LINE_DETAIL_ID');
230: L_ORGANIZATION_ID:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORGANIZATION_ID');
231: L_COST_SALE_ITEM_DERIVED := NULL;
232:
233: IF (L_LINE_DETAIL_ID IS NOT NULL) THEN

Line 230: L_ORGANIZATION_ID:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORGANIZATION_ID');

226: IF (FUNCMODE = 'RUN') THEN
227: L_LINE_DETAIL_ID:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'LINE_DETAIL_ID');
228: L_ORDER_LINE_ID:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORDER_LINE_ID');
229: L_PICK_LINE_DETAIL_ID:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'PICKING_LINE_DETAIL_ID');
230: L_ORGANIZATION_ID:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORGANIZATION_ID');
231: L_COST_SALE_ITEM_DERIVED := NULL;
232:
233: IF (L_LINE_DETAIL_ID IS NOT NULL) THEN
234: IF (DEBUG_COGS) THEN

Line 254: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',FB_ERROR_MSG);

250: FND_MESSAGE.SET_NAME('FND', 'FLEX-BUILD INVALID VALUE');
251: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(L_LINE_DETAIL_ID));
252: FND_MESSAGE.SET_TOKEN('VSET_ID', '102319');
253: FB_ERROR_MSG := FND_MESSAGE.GET_ENCODED;
254: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',FB_ERROR_MSG);
255: result := 'COMPLETE:FAILURE';
256: RETURN;
257: WHEN OTHERS THEN
258: IF (DEBUG_COGS) THEN

Line 290: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',FB_ERROR_MSG);

286: FND_MESSAGE.SET_NAME('FND', 'FLEX-BUILD INVALID VALUE');
287: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(L_PICK_LINE_DETAIL_ID));
288: FND_MESSAGE.SET_TOKEN('VSET_ID', '102320');
289: FB_ERROR_MSG := FND_MESSAGE.GET_ENCODED;
290: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',FB_ERROR_MSG);
291: result := 'COMPLETE:FAILURE';
292: RETURN;
293: WHEN OTHERS THEN
294: IF (DEBUG_COGS) THEN

Line 324: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',FB_ERROR_MSG);

320: FND_MESSAGE.SET_NAME('FND', 'FLEX-BUILD INVALID VALUE');
321: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(L_ORDER_LINE_ID));
322: FND_MESSAGE.SET_TOKEN('VSET_ID', '102318');
323: FB_ERROR_MSG := FND_MESSAGE.GET_ENCODED;
324: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',FB_ERROR_MSG);
325: result := 'COMPLETE:FAILURE';
326: RETURN;
327: WHEN OTHERS THEN
328: IF (DEBUG_COGS) THEN

Line 336: wf_engine.setItemAttrNumber(itemtype,itemkey,'GENERATED_CCID',TO_NUMBER(L_COST_SALE_ITEM_DERIVED));

332: RAISE;
333: END;
334: END IF;
335: END IF;
336: wf_engine.setItemAttrNumber(itemtype,itemkey,'GENERATED_CCID',TO_NUMBER(L_COST_SALE_ITEM_DERIVED));
337: result := 'COMPLETE:SUCCESS';
338: IF (DEBUG_COGS) THEN
339: PRINTLN('Input Paramerers : ');
340: PRINTLN('Line detail id :'||to_char(l_line_detail_id));

Line 349: result := wf_engine.eng_completed;

345: PRINTLN('Generated CCID :'||l_cost_sale_item_derived);
346: END IF;
347: RETURN;
348: ELSIF (funcmode = 'CANCEL') THEN
349: result := wf_engine.eng_completed;
350: RETURN;
351: ELSE
352: result := '';
353: RETURN;

Line 390: L_LINE_DETAIL_ID:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'LINE_DETAIL_ID');

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');
391: L_ORDER_LINE_ID:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORDER_LINE_ID');
392: L_PICK_LINE_DETAIL_ID:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'PICKING_LINE_DETAIL_ID');
393: L_ORGANIZATION_ID:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORGANIZATION_ID');
394: L_COST_SALE_MODEL_DERIVED := NULL;

Line 391: L_ORDER_LINE_ID:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORDER_LINE_ID');

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');
391: L_ORDER_LINE_ID:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORDER_LINE_ID');
392: L_PICK_LINE_DETAIL_ID:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'PICKING_LINE_DETAIL_ID');
393: L_ORGANIZATION_ID:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORGANIZATION_ID');
394: L_COST_SALE_MODEL_DERIVED := NULL;
395: IF (L_LINE_DETAIL_ID IS NOT NULL) THEN

Line 392: L_PICK_LINE_DETAIL_ID:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'PICKING_LINE_DETAIL_ID');

388: END IF;
389: IF (FUNCMODE = 'RUN') THEN
390: L_LINE_DETAIL_ID:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'LINE_DETAIL_ID');
391: L_ORDER_LINE_ID:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORDER_LINE_ID');
392: L_PICK_LINE_DETAIL_ID:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'PICKING_LINE_DETAIL_ID');
393: L_ORGANIZATION_ID:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORGANIZATION_ID');
394: L_COST_SALE_MODEL_DERIVED := NULL;
395: IF (L_LINE_DETAIL_ID IS NOT NULL) THEN
396: BEGIN

Line 393: L_ORGANIZATION_ID:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORGANIZATION_ID');

389: IF (FUNCMODE = 'RUN') THEN
390: L_LINE_DETAIL_ID:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'LINE_DETAIL_ID');
391: L_ORDER_LINE_ID:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORDER_LINE_ID');
392: L_PICK_LINE_DETAIL_ID:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'PICKING_LINE_DETAIL_ID');
393: L_ORGANIZATION_ID:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORGANIZATION_ID');
394: L_COST_SALE_MODEL_DERIVED := NULL;
395: IF (L_LINE_DETAIL_ID IS NOT NULL) THEN
396: BEGIN
397: IF (DEBUG_COGS) THEN

Line 416: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',FB_ERROR_MSG);

412: FND_MESSAGE.SET_NAME('FND', 'FLEX-BUILD INVALID VALUE');
413: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(L_LINE_DETAIL_ID));
414: FND_MESSAGE.SET_TOKEN('VSET_ID', '102319');
415: FB_ERROR_MSG := FND_MESSAGE.GET_ENCODED;
416: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',FB_ERROR_MSG);
417: result := 'COMPLETE:FAILURE';
418: RETURN;
419: WHEN OTHERS THEN
420: IF (DEBUG_COGS) THEN

Line 451: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',FB_ERROR_MSG);

447: FND_MESSAGE.SET_NAME('FND', 'FLEX-BUILD INVALID VALUE');
448: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(L_PICK_LINE_DETAIL_ID));
449: FND_MESSAGE.SET_TOKEN('VSET_ID', '102320');
450: FB_ERROR_MSG := FND_MESSAGE.GET_ENCODED;
451: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',FB_ERROR_MSG);
452: result := 'COMPLETE:FAILURE';
453: RETURN;
454: WHEN OTHERS THEN
455: IF (DEBUG_COGS) THEN

Line 485: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',FB_ERROR_MSG);

481: FND_MESSAGE.SET_NAME('FND', 'FLEX-BUILD INVALID VALUE');
482: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(L_ORDER_LINE_ID));
483: FND_MESSAGE.SET_TOKEN('VSET_ID', '102318');
484: FB_ERROR_MSG := FND_MESSAGE.GET_ENCODED;
485: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',FB_ERROR_MSG);
486: result := 'COMPLETE:FAILURE';
487: RETURN;
488: WHEN OTHERS THEN
489: IF (DEBUG_COGS) THEN

Line 516: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',FB_ERROR_MSG);

512: FND_MESSAGE.SET_NAME('FND', 'FLEX-BUILD INVALID VALUE');
513: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(L_ORDER_LINE_ID));
514: FND_MESSAGE.SET_TOKEN('VSET_ID', '102321');
515: FB_ERROR_MSG := FND_MESSAGE.GET_ENCODED;
516: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',FB_ERROR_MSG);
517: result := 'COMPLETE:FAILURE';
518: RETURN;
519: WHEN OTHERS THEN
520: IF (DEBUG_COGS) THEN

Line 528: wf_engine.setItemAttrNumber(itemtype,itemkey,'GENERATED_CCID',TO_NUMBER(L_COST_SALE_MODEL_DERIVED));

524: RAISE;
525: END;
526: END IF;
527: END IF;
528: wf_engine.setItemAttrNumber(itemtype,itemkey,'GENERATED_CCID',TO_NUMBER(L_COST_SALE_MODEL_DERIVED));
529: result := 'COMPLETE:SUCCESS';
530: IF (DEBUG_COGS) THEN
531: PRINTLN('Input Paramerers : ');
532: PRINTLN('Line detail id :'||to_char(l_line_detail_id));

Line 541: result := wf_engine.eng_completed;

537: PRINTLN('Generated CCID :'||l_cost_sale_model_derived);
538: END IF;
539: RETURN;
540: ELSIF (funcmode = 'CANCEL') THEN
541: result := wf_engine.eng_completed;
542: RETURN;
543: ELSE
544: result := '';
545: RETURN;

Line 580: L_ORDER_TYPE_ID := wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORDER_TYPE_ID');

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');
581: L_ORDER_TYPE_CCID := NULL;
582: IF (L_ORDER_TYPE_ID IS NOT NULL) THEN
583: IF (DEBUG_COGS) THEN
584: PRINTLN('L_ORDER_TYPE_ID is not null');

Line 600: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',FB_ERROR_MSG);

596: FND_MESSAGE.SET_NAME('FND', 'FLEX-BUILD INVALID VALUE');
597: FND_MESSAGE.SET_TOKEN('VALUE',TO_CHAR(L_ORDER_TYPE_ID));
598: FND_MESSAGE.SET_TOKEN('VSET_ID', '101643');
599: FB_ERROR_MSG := FND_MESSAGE.GET_ENCODED;
600: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',FB_ERROR_MSG);
601: result := 'COMPLETE:FAILURE';
602: RETURN;
603: WHEN OTHERS THEN
604: IF (DEBUG_COGS) THEN

Line 611: wf_engine.setItemAttrNumber(itemtype,itemkey,'GENERATED_CCID',TO_NUMBER(L_ORDER_TYPE_CCID));

607: result := 'COMPLETE:FAILURE';
608: RAISE;
609: END;
610: END IF;
611: wf_engine.setItemAttrNumber(itemtype,itemkey,'GENERATED_CCID',TO_NUMBER(L_ORDER_TYPE_CCID));
612: result := 'COMPLETE:SUCCESS';
613: IF (DEBUG_COGS) THEN
614: PRINTLN('Input Paramerers : ');
615: PRINTLN('Order Type ID :'||to_char(l_order_type_id));

Line 621: result := wf_engine.eng_completed;

617: PRINTLN('Generated CCID :'||l_order_type_ccid);
618: END IF;
619: RETURN;
620: ELSIF (funcmode = 'CANCEL') THEN
621: result := wf_engine.eng_completed;
622: RETURN;
623: ELSE
624: result := '';
625: RETURN;

Line 659: L_SALESREP_ID := wf_engine.GetActivityAttrNumber(itemtype,itemkey,actid,'SALESREPID');

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');
660: L_SALESREP_REV_DERIVED := NULL;
661: IF (L_SALESREP_ID IS NOT NULL) THEN
662: IF (DEBUG_COGS) THEN
663: PRINTLN('L_SALESREP_ID is not null');

Line 679: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',FB_ERROR_MSG);

675: FND_MESSAGE.SET_NAME('FND', 'FLEX-BUILD INVALID VALUE');
676: FND_MESSAGE.SET_TOKEN('VALUE',TO_CHAR(L_SALESREP_ID));
677: FND_MESSAGE.SET_TOKEN('VSET_ID', '101645');
678: FB_ERROR_MSG := FND_MESSAGE.GET_ENCODED;
679: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',FB_ERROR_MSG);
680: result := 'COMPLETE:FAILURE';
681: RETURN;
682: WHEN OTHERS THEN
683: IF (DEBUG_COGS) THEN

Line 690: wf_engine.setItemAttrNumber(itemtype,itemkey,'GENERATED_CCID',TO_NUMBER(L_SALESREP_REV_DERIVED));

686: result := 'COMPLETE:FAILURE';
687: RAISE;
688: END;
689: END IF;
690: wf_engine.setItemAttrNumber(itemtype,itemkey,'GENERATED_CCID',TO_NUMBER(L_SALESREP_REV_DERIVED));
691: result := 'COMPLETE:SUCCESS';
692: IF (DEBUG_COGS) THEN
693: PRINTLN('Input Paramerers : ');
694: PRINTLN('Salesrep ID :' || to_char(l_salesrep_id));

Line 700: result := wf_engine.eng_completed;

696: PRINTLN('Generated CCID :'||l_salesrep_rev_derived);
697: END IF;
698: RETURN;
699: ELSIF (funcmode = 'CANCEL') THEN
700: result := wf_engine.eng_completed;
701: RETURN;
702: ELSE
703: result := '';
704: RETURN;

Line 738: L_ORDER_LINE_ID:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORDER_LINE_ID');

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');
739: IF (DEBUG_COGS) THEN
740: PRINTLN('Input Paramerers : ');
741: PRINTLN('Order Limne ID :'|| to_char(l_order_line_id));
742: END IF;

Line 782: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',FB_ERROR_MSG);

778: FND_MESSAGE.SET_NAME('FND', 'FLEX-BUILD INVALID VALUE');
779: FND_MESSAGE.SET_TOKEN('VALUE',TO_CHAR(L_ORDER_LINE_ID));
780: FND_MESSAGE.SET_TOKEN('VSET_ID', '101646');
781: FB_ERROR_MSG := FND_MESSAGE.GET_ENCODED;
782: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',FB_ERROR_MSG);
783: result := 'COMPLETE:FAILURE';
784: RETURN;
785: WHEN OTHERS THEN
786: IF (DEBUG_COGS) THEN

Line 792: wf_engine.setItemAttrNumber(itemtype,itemkey,'SALESREP_ID',TO_NUMBER(L_SALESREP_ID));

788: END IF;
789: result := 'COMPLETE:FAILURE';
790: RAISE;
791: END;
792: wf_engine.setItemAttrNumber(itemtype,itemkey,'SALESREP_ID',TO_NUMBER(L_SALESREP_ID));
793: result := 'COMPLETE:SUCCESS';
794: ELSE
795: result := 'COMPLETE:FAILURE';
796: RETURN;

Line 804: result := wf_engine.eng_completed;

800: PRINTLN('Salesrep ID :'|| l_salesrep_id);
801: END IF;
802: RETURN;
803: ELSIF (funcmode = 'CANCEL') THEN
804: result := wf_engine.eng_completed;
805: RETURN;
806: ELSE
807: result := '';
808: RETURN;

Line 844: L_INV_ITEM_ID := wf_engine.GetActivityAttrNumber(itemtype,itemkey,actid,'INVITEMID');

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');
845: L_ORGANIZATION_ID:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORGANIZATION_ID');
846: IF (DEBUG_COGS) THEN
847: PRINTLN('Input Paramerers : ');
848: PRINTLN('Inventory Item ID :'|| to_char(l_inv_item_id));

Line 845: L_ORGANIZATION_ID:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORGANIZATION_ID');

841: PRINTLN('FUNCMODE = '||FUNCMODE);
842: END IF;
843: IF (FUNCMODE = 'RUN') THEN
844: L_INV_ITEM_ID := wf_engine.GetActivityAttrNumber(itemtype,itemkey,actid,'INVITEMID');
845: L_ORGANIZATION_ID:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORGANIZATION_ID');
846: IF (DEBUG_COGS) THEN
847: PRINTLN('Input Paramerers : ');
848: PRINTLN('Inventory Item ID :'|| to_char(l_inv_item_id));
849: PRINTLN('Organization ID :'|| to_char(l_organization_id));

Line 871: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',FB_ERROR_MSG);

867: FND_MESSAGE.SET_NAME('FND', 'FLEX-BUILD INVALID VALUE');
868: FND_MESSAGE.SET_TOKEN('VALUE',TO_CHAR(L_INV_ITEM_ID));
869: FND_MESSAGE.SET_TOKEN('VSET_ID', '101640');
870: FB_ERROR_MSG := FND_MESSAGE.GET_ENCODED;
871: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',FB_ERROR_MSG);
872: result := 'COMPLETE:FAILURE';
873: RETURN;
874: WHEN OTHERS THEN
875: IF (DEBUG_COGS) THEN

Line 881: wf_engine.setItemAttrNumber(itemtype,itemkey,'GENERATED_CCID',TO_NUMBER(L_ACCOUNT_DERIVED));

877: END IF;
878: result := 'COMPLETE:FAILURE';
879: RAISE;
880: END;
881: wf_engine.setItemAttrNumber(itemtype,itemkey,'GENERATED_CCID',TO_NUMBER(L_ACCOUNT_DERIVED));
882: result := 'COMPLETE:SUCCESS';
883: ELSE
884: result := 'COMPLETE:FAILURE';
885: RETURN;

Line 893: result := wf_engine.eng_completed;

889: PRINTLN('Generated CCID :'|| l_account_derived);
890: END IF;
891: RETURN;
892: ELSIF (funcmode = 'CANCEL') THEN
893: result := wf_engine.eng_completed;
894: RETURN;
895: ELSE
896: result := '';
897: RETURN;

Line 931: L_ORDER_LINE_ID:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORDER_LINE_ID');

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');
932: L_INV_ITEM_ID := NULL;
933: IF (L_ORDER_LINE_ID IS NOT NULL) THEN
934: IF (DEBUG_COGS) THEN
935: PRINTLN('L_ACCOUNT_DERIVED is not null');

Line 951: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',FB_ERROR_MSG);

947: FND_MESSAGE.SET_NAME('FND', 'FLEX-BUILD INVALID VALUE');
948: FND_MESSAGE.SET_TOKEN('VALUE',TO_CHAR(L_ORDER_LINE_ID));
949: FND_MESSAGE.SET_TOKEN('VSET_ID', '101641');
950: FB_ERROR_MSG := FND_MESSAGE.GET_ENCODED;
951: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',FB_ERROR_MSG);
952: result := 'COMPLETE:FAILURE';
953: RETURN;
954: WHEN OTHERS THEN
955: IF (DEBUG_COGS) THEN

Line 961: wf_engine.setItemAttrNumber(itemtype,itemkey,'INV_ITEM_ID',TO_NUMBER(L_INV_ITEM_ID));

957: END IF;
958: result := 'COMPLETE:FAILURE';
959: RAISE;
960: END;
961: wf_engine.setItemAttrNumber(itemtype,itemkey,'INV_ITEM_ID',TO_NUMBER(L_INV_ITEM_ID));
962: result := 'COMPLETE:SUCCESS';
963: ELSE
964: result := 'COMPLETE:FAILURE';
965: RETURN;

Line 975: result := wf_engine.eng_completed;

971: PRINTLN('Inventory Item ID :'||l_inv_item_id);
972: END IF;
973: RETURN;
974: ELSIF (funcmode = 'CANCEL') THEN
975: result := wf_engine.eng_completed;
976: RETURN;
977: ELSE
978: result := '';
979: RETURN;

Line 1012: L_COMMITMENT_ID:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'COMMITMENT_ID');

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
1014: PRINTLN('Input Paramerers : ');
1015: PRINTLN('Commitment ID :'|| to_char(l_commitment_id));
1016: PRINTLN('FUNCMODE = '||FUNCMODE);

Line 1038: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',FB_ERROR_MSG);

1034: FND_MESSAGE.SET_NAME('FND', 'FLEX-BUILD INVALID VALUE');
1035: FND_MESSAGE.SET_TOKEN('VALUE',TO_CHAR(L_COMMITMENT_ID));
1036: FND_MESSAGE.SET_TOKEN('VSET_ID', '101647');
1037: FB_ERROR_MSG := FND_MESSAGE.GET_ENCODED;
1038: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',FB_ERROR_MSG);
1039: result := 'COMPLETE:FAILURE';
1040: RETURN;
1041: WHEN OTHERS THEN
1042: IF (DEBUG_COGS) THEN

Line 1048: wf_engine.setItemAttrText(itemtype,itemkey,'TRX_TYPE_DERIVED',L_TRX_TYPE);

1044: END IF;
1045: result := 'COMPLETE:FAILURE';
1046: RAISE;
1047: END;
1048: wf_engine.setItemAttrText(itemtype,itemkey,'TRX_TYPE_DERIVED',L_TRX_TYPE);
1049: result := 'COMPLETE:SUCCESS';
1050: ELSE
1051: result := 'COMPLETE:FAILURE';
1052: RETURN;

Line 1060: result := wf_engine.eng_completed;

1056: PRINTLN('Transaction Type'||l_trx_type);
1057: END IF;
1058: RETURN;
1059: ELSIF (funcmode = 'CANCEL') THEN
1060: result := wf_engine.eng_completed;
1061: RETURN;
1062: ELSE
1063: result := '';
1064: RETURN;

Line 1098: L_ORDER_LINE_ID:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORDER_LINE_ID');

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');
1099: IF (DEBUG_COGS) THEN
1100: PRINTLN('Input Paramerers : ');
1101: PRINTLN('Line ID :'||to_char(l_order_line_id));
1102: END IF;

Line 1122: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',FB_ERROR_MSG);

1118: FND_MESSAGE.SET_NAME('FND', 'FLEX-BUILD INVALID VALUE');
1119: FND_MESSAGE.SET_TOKEN('VALUE',TO_CHAR(L_ORDER_LINE_ID));
1120: FND_MESSAGE.SET_TOKEN('VSET_ID','103098');
1121: FB_ERROR_MSG := FND_MESSAGE.GET_ENCODED;
1122: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',FB_ERROR_MSG);
1123: result := 'COMPLETE:FAILURE';
1124: RETURN;
1125: WHEN OTHERS THEN
1126: IF (DEBUG_COGS) THEN

Line 1132: wf_engine.setItemAttrNumber(itemtype,itemkey,'ORG_ID',TO_NUMBER(L_OPERATING_UNIT));

1128: END IF;
1129: result := 'COMPLETE:FAILURE';
1130: RAISE;
1131: END;
1132: wf_engine.setItemAttrNumber(itemtype,itemkey,'ORG_ID',TO_NUMBER(L_OPERATING_UNIT));
1133: result := 'COMPLETE:SUCCESS';
1134: ELSE
1135: result := 'COMPLETE:FAILURE';
1136: RETURN;

Line 1144: result := wf_engine.eng_completed;

1140: PRINTLN('Operating Unit :'||l_operating_unit);
1141: END IF;
1142: RETURN;
1143: ELSIF (funcmode = 'CANCEL') THEN
1144: result := wf_engine.eng_completed;
1145: RETURN;
1146: ELSE
1147: result := '';
1148: RETURN;

Line 1182: L_ORDER_LINE_ID:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORDER_LINE_ID');

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');
1183: L_PARENT_LINE_ID := NULL;
1184: IF (L_ORDER_LINE_ID IS NOT NULL) THEN
1185: IF (DEBUG_COGS) THEN
1186: PRINTLN('L_ORDER_LINE_ID is not null.');

Line 1202: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',FB_ERROR_MSG);

1198: FND_MESSAGE.SET_NAME('FND', 'FLEX-BUILD INVALID VALUE');
1199: FND_MESSAGE.SET_TOKEN('VALUE',TO_CHAR(L_ORDER_LINE_ID));
1200: FND_MESSAGE.SET_TOKEN('VSET_ID','101644');
1201: FB_ERROR_MSG := FND_MESSAGE.GET_ENCODED;
1202: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',FB_ERROR_MSG);
1203: result := 'COMPLETE:FAILURE';
1204: RETURN;
1205: WHEN OTHERS THEN
1206: IF (DEBUG_COGS) THEN

Line 1213: wf_engine.setItemAttrNumber(itemtype,itemkey,'PARENT_LINE_ID_DERIVED',L_PARENT_LINE_ID);

1209: result := 'COMPLETE:FAILURE';
1210: RAISE;
1211: END;
1212: END IF;
1213: wf_engine.setItemAttrNumber(itemtype,itemkey,'PARENT_LINE_ID_DERIVED',L_PARENT_LINE_ID);
1214: result := 'COMPLETE:SUCCESS';
1215: IF (DEBUG_COGS) THEN
1216: PRINTLN('Input Paramerers : ');
1217: PRINTLN('Line ID :'||to_char(l_order_line_id));

Line 1223: result := wf_engine.eng_completed;

1219: PRINTLN('Parent Line ID :'|| l_parent_line_id);
1220: END IF;
1221: RETURN;
1222: ELSIF (funcmode = 'CANCEL') THEN
1223: result := wf_engine.eng_completed;
1224: RETURN;
1225: ELSE
1226: result := '';
1227: RETURN;