246: PRINTLN('L_COST_SALE_ITEM_DERIVED = '||L_COST_SALE_ITEM_DERIVED);
247: END IF;
248: EXCEPTION
249: WHEN NO_DATA_FOUND THEN
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);
247: END IF;
248: EXCEPTION
249: WHEN NO_DATA_FOUND THEN
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';
248: EXCEPTION
249: WHEN NO_DATA_FOUND THEN
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;
249: WHEN NO_DATA_FOUND THEN
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
282: PRINTLN('L_COST_SALE_ITEM_DERIVED = '||L_COST_SALE_ITEM_DERIVED);
283: END IF;
284: EXCEPTION
285: WHEN NO_DATA_FOUND THEN
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);
283: END IF;
284: EXCEPTION
285: WHEN NO_DATA_FOUND THEN
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';
284: EXCEPTION
285: WHEN NO_DATA_FOUND THEN
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;
285: WHEN NO_DATA_FOUND THEN
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
316: PRINTLN('L_COST_SALE_ITEM_DERIVED = '||L_COST_SALE_ITEM_DERIVED);
317: END IF;
318: EXCEPTION
319: WHEN NO_DATA_FOUND THEN
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);
317: END IF;
318: EXCEPTION
319: WHEN NO_DATA_FOUND THEN
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';
318: EXCEPTION
319: WHEN NO_DATA_FOUND THEN
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;
319: WHEN NO_DATA_FOUND THEN
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
408: PRINTLN('L_COST_SALE_MODEL_DERIVED = '||L_COST_SALE_MODEL_DERIVED);
409: END IF;
410: EXCEPTION
411: WHEN NO_DATA_FOUND THEN
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);
409: END IF;
410: EXCEPTION
411: WHEN NO_DATA_FOUND THEN
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';
410: EXCEPTION
411: WHEN NO_DATA_FOUND THEN
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;
411: WHEN NO_DATA_FOUND THEN
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
443: PRINTLN('L_COST_SALE_MODEL_DERIVED = '||L_COST_SALE_MODEL_DERIVED);
444: END IF;
445: EXCEPTION
446: WHEN NO_DATA_FOUND THEN
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);
444: END IF;
445: EXCEPTION
446: WHEN NO_DATA_FOUND THEN
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';
445: EXCEPTION
446: WHEN NO_DATA_FOUND THEN
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;
446: WHEN NO_DATA_FOUND THEN
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
477: PRINTLN('L_COST_SALE_MODEL_DERIVED = '||L_COST_SALE_MODEL_DERIVED);
478: END IF;
479: EXCEPTION
480: WHEN NO_DATA_FOUND THEN
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);
478: END IF;
479: EXCEPTION
480: WHEN NO_DATA_FOUND THEN
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';
479: EXCEPTION
480: WHEN NO_DATA_FOUND THEN
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;
480: WHEN NO_DATA_FOUND THEN
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
508: PRINTLN('L_COST_SALE_MODEL_DERIVED = '||L_COST_SALE_MODEL_DERIVED);
509: END IF;
510: EXCEPTION
511: WHEN NO_DATA_FOUND THEN
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);
509: END IF;
510: EXCEPTION
511: WHEN NO_DATA_FOUND THEN
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';
510: EXCEPTION
511: WHEN NO_DATA_FOUND THEN
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;
511: WHEN NO_DATA_FOUND THEN
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
592: PRINTLN('L_ORDER_TYPE_CCID = '||L_ORDER_TYPE_CCID);
593: END IF;
594: EXCEPTION
595: WHEN NO_DATA_FOUND THEN
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);
593: END IF;
594: EXCEPTION
595: WHEN NO_DATA_FOUND THEN
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';
594: EXCEPTION
595: WHEN NO_DATA_FOUND THEN
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;
595: WHEN NO_DATA_FOUND THEN
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
671: PRINTLN('L_SALESREP_REV_DERIVED = '||L_SALESREP_REV_DERIVED);
672: END IF;
673: EXCEPTION
674: WHEN NO_DATA_FOUND THEN
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);
672: END IF;
673: EXCEPTION
674: WHEN NO_DATA_FOUND THEN
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';
673: EXCEPTION
674: WHEN NO_DATA_FOUND THEN
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;
674: WHEN NO_DATA_FOUND THEN
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
774: PRINTLN('L_SALESREP_ID = '||L_SALESREP_ID);
775: END IF;
776: EXCEPTION
777: WHEN NO_DATA_FOUND THEN
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);
775: END IF;
776: EXCEPTION
777: WHEN NO_DATA_FOUND THEN
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';
776: EXCEPTION
777: WHEN NO_DATA_FOUND THEN
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;
777: WHEN NO_DATA_FOUND THEN
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
863: PRINTLN('L_ACCOUNT_DERIVED = '||L_ACCOUNT_DERIVED);
864: END IF;
865: EXCEPTION
866: WHEN NO_DATA_FOUND THEN
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);
864: END IF;
865: EXCEPTION
866: WHEN NO_DATA_FOUND THEN
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';
865: EXCEPTION
866: WHEN NO_DATA_FOUND THEN
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;
866: WHEN NO_DATA_FOUND THEN
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
943: PRINTLN('L_INV_ITEM_ID = '||L_INV_ITEM_ID);
944: END IF;
945: EXCEPTION
946: WHEN NO_DATA_FOUND THEN
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);
944: END IF;
945: EXCEPTION
946: WHEN NO_DATA_FOUND THEN
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';
945: EXCEPTION
946: WHEN NO_DATA_FOUND THEN
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;
946: WHEN NO_DATA_FOUND THEN
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
1030: PRINTLN('L_TRX_TYPE = '||L_TRX_TYPE);
1031: END IF;
1032: EXCEPTION
1033: WHEN NO_DATA_FOUND THEN
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);
1031: END IF;
1032: EXCEPTION
1033: WHEN NO_DATA_FOUND THEN
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';
1032: EXCEPTION
1033: WHEN NO_DATA_FOUND THEN
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;
1033: WHEN NO_DATA_FOUND THEN
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
1114: PRINTLN('L_OPERATING_UNIT = '||L_OPERATING_UNIT);
1115: END IF;
1116: EXCEPTION
1117: WHEN NO_DATA_FOUND THEN
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);
1115: END IF;
1116: EXCEPTION
1117: WHEN NO_DATA_FOUND THEN
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';
1116: EXCEPTION
1117: WHEN NO_DATA_FOUND THEN
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;
1117: WHEN NO_DATA_FOUND THEN
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
1194: PRINTLN('L_PARENT_LINE_ID = '||L_PARENT_LINE_ID);
1195: END IF;
1196: EXCEPTION
1197: WHEN NO_DATA_FOUND THEN
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);
1195: END IF;
1196: EXCEPTION
1197: WHEN NO_DATA_FOUND THEN
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';
1196: EXCEPTION
1197: WHEN NO_DATA_FOUND THEN
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;
1197: WHEN NO_DATA_FOUND THEN
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