APPS.OE_FLEX_COGS_PUB dependencies on FND_MESSAGE

Line 122: FND_MESSAGE.SET_NAME('ONT','OE_COGS_LINE_ID_MISSING');

118:
119: IF p_line_id IS NULL OR
120: p_line_id = FND_API.G_MISS_NUM THEN
121:
122: FND_MESSAGE.SET_NAME('ONT','OE_COGS_LINE_ID_MISSING');
123: OE_MSG_PUB.ADD;
124: RAISE FND_API.G_EXC_ERROR;
125:
126: END IF;

Line 143: FND_MESSAGE.SET_NAME('ONT','OE_COGS_INVALID_LINE_ID');

139:
140: EXCEPTION
141:
142: WHEN NO_DATA_FOUND THEN
143: FND_MESSAGE.SET_NAME('ONT','OE_COGS_INVALID_LINE_ID');
144: FND_MESSAGE.SET_TOKEN('LINE_ID',l_line_id);
145: OE_MSG_PUB.ADD;
146: RAISE FND_API.G_EXC_ERROR;
147:

Line 144: FND_MESSAGE.SET_TOKEN('LINE_ID',l_line_id);

140: EXCEPTION
141:
142: WHEN NO_DATA_FOUND THEN
143: FND_MESSAGE.SET_NAME('ONT','OE_COGS_INVALID_LINE_ID');
144: FND_MESSAGE.SET_TOKEN('LINE_ID',l_line_id);
145: OE_MSG_PUB.ADD;
146: RAISE FND_API.G_EXC_ERROR;
147:
148: END;

Line 233: FND_MESSAGE.SET_NAME('ONT','OE_COGS_INVALID_LINE_ID');

229: ,p_entity_id => l_line_id
230: ,p_line_id => l_line_id
231: );
232:
233: FND_MESSAGE.SET_NAME('ONT','OE_COGS_INVALID_LINE_ID');
234: FND_MESSAGE.SET_TOKEN('LINE_ID',l_line_id);
235: OE_MSG_PUB.ADD;
236: RAISE FND_API.G_EXC_ERROR;
237: END;

Line 234: FND_MESSAGE.SET_TOKEN('LINE_ID',l_line_id);

230: ,p_line_id => l_line_id
231: );
232:
233: FND_MESSAGE.SET_NAME('ONT','OE_COGS_INVALID_LINE_ID');
234: FND_MESSAGE.SET_TOKEN('LINE_ID',l_line_id);
235: OE_MSG_PUB.ADD;
236: RAISE FND_API.G_EXC_ERROR;
237: END;
238:

Line 250: FND_MESSAGE.SET_NAME('ONT','OE_COGS_WAREHOUSE_MISSING');

246: WHERE HEADER_ID = l_header_id;
247:
248: IF l_ship_from_org_id IS NULL THEN
249:
250: FND_MESSAGE.SET_NAME('ONT','OE_COGS_WAREHOUSE_MISSING');
251: FND_MESSAGE.SET_TOKEN('LINE_ID',l_line_id);
252: OE_MSG_PUB.ADD;
253: RAISE FND_API.G_EXC_ERROR;
254:

Line 251: FND_MESSAGE.SET_TOKEN('LINE_ID',l_line_id);

247:
248: IF l_ship_from_org_id IS NULL THEN
249:
250: FND_MESSAGE.SET_NAME('ONT','OE_COGS_WAREHOUSE_MISSING');
251: FND_MESSAGE.SET_TOKEN('LINE_ID',l_line_id);
252: OE_MSG_PUB.ADD;
253: RAISE FND_API.G_EXC_ERROR;
254:
255: END IF;

Line 406: fnd_message.set_encoded(l_errmsg);

402: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
403: End;
404:
405: IF INSTR(l_errmsg, CHR(0)) > 0 THEN -- 2352606
406: fnd_message.set_encoded(l_errmsg);
407: l_errmsg := fnd_message.get;
408: END IF;
409:
410: g_stmt:='80';

Line 407: l_errmsg := fnd_message.get;

403: End;
404:
405: IF INSTR(l_errmsg, CHR(0)) > 0 THEN -- 2352606
406: fnd_message.set_encoded(l_errmsg);
407: l_errmsg := fnd_message.get;
408: END IF;
409:
410: g_stmt:='80';
411:

Line 425: FND_MESSAGE.SET_NAME('ONT','OE_COGS_ACC_GEN_FAILED');

421: ELSE
422: IF l_debug_level > 0 THEN
423: oe_debug_pub.add('Error Message : '|| l_errmsg,2);
424: END IF;
425: FND_MESSAGE.SET_NAME('ONT','OE_COGS_ACC_GEN_FAILED');
426: FND_MESSAGE.SET_TOKEN('ERROR_MESSAGE',l_errmsg);
427: OE_MSG_PUB.ADD;
428: RAISE FND_API.G_EXC_ERROR;
429: END IF;

Line 426: FND_MESSAGE.SET_TOKEN('ERROR_MESSAGE',l_errmsg);

422: IF l_debug_level > 0 THEN
423: oe_debug_pub.add('Error Message : '|| l_errmsg,2);
424: END IF;
425: FND_MESSAGE.SET_NAME('ONT','OE_COGS_ACC_GEN_FAILED');
426: FND_MESSAGE.SET_TOKEN('ERROR_MESSAGE',l_errmsg);
427: OE_MSG_PUB.ADD;
428: RAISE FND_API.G_EXC_ERROR;
429: END IF;
430: oe_debug_pub.add('Exiting OE_Flex_Cogs_Pub.Start_process : '|| l_return_status, 1); -- 2352606

Line 435: FND_MESSAGE.SET_NAME('ONT','OE_COGS_COA_ID_NOT_FOUND');

431: RETURN l_return_status;
432: EXCEPTION
433:
434: WHEN NO_DATA_FOUND THEN
435: FND_MESSAGE.SET_NAME('ONT','OE_COGS_COA_ID_NOT_FOUND');
436: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID',l_ship_from_org_id);
437: OE_MSG_PUB.ADD;
438:
439: x_msg_count := OE_MSG_PUB.Count_Msg; -- 2352606 start

Line 436: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID',l_ship_from_org_id);

432: EXCEPTION
433:
434: WHEN NO_DATA_FOUND THEN
435: FND_MESSAGE.SET_NAME('ONT','OE_COGS_COA_ID_NOT_FOUND');
436: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID',l_ship_from_org_id);
437: OE_MSG_PUB.ADD;
438:
439: x_msg_count := OE_MSG_PUB.Count_Msg; -- 2352606 start
440: IF x_msg_count > 0 THEN

Line 573: FND_MESSAGE.SET_NAME('ONT','OE_COGS_CCID_GEN_FAILED');

569: WHEN NO_DATA_FOUND THEN
570:
571: IF l_item_type_code <> OE_GLOBALS.G_ITEM_CONFIG THEN
572:
573: FND_MESSAGE.SET_NAME('ONT','OE_COGS_CCID_GEN_FAILED');
574: FND_MESSAGE.SET_TOKEN('PARAM1','Inventory Item id');
575: FND_MESSAGE.SET_TOKEN('PARAM2','/Warehouse ');
576: FND_MESSAGE.SET_TOKEN('VALUE1',l_inventory_item_id);
577: FND_MESSAGE.SET_TOKEN('VALUE2',l_organization_id);

Line 574: FND_MESSAGE.SET_TOKEN('PARAM1','Inventory Item id');

570:
571: IF l_item_type_code <> OE_GLOBALS.G_ITEM_CONFIG THEN
572:
573: FND_MESSAGE.SET_NAME('ONT','OE_COGS_CCID_GEN_FAILED');
574: FND_MESSAGE.SET_TOKEN('PARAM1','Inventory Item id');
575: FND_MESSAGE.SET_TOKEN('PARAM2','/Warehouse ');
576: FND_MESSAGE.SET_TOKEN('VALUE1',l_inventory_item_id);
577: FND_MESSAGE.SET_TOKEN('VALUE2',l_organization_id);
578: FB_ERROR_MSG := FND_MESSAGE.GET_ENCODED;

Line 575: FND_MESSAGE.SET_TOKEN('PARAM2','/Warehouse ');

571: IF l_item_type_code <> OE_GLOBALS.G_ITEM_CONFIG THEN
572:
573: FND_MESSAGE.SET_NAME('ONT','OE_COGS_CCID_GEN_FAILED');
574: FND_MESSAGE.SET_TOKEN('PARAM1','Inventory Item id');
575: FND_MESSAGE.SET_TOKEN('PARAM2','/Warehouse ');
576: FND_MESSAGE.SET_TOKEN('VALUE1',l_inventory_item_id);
577: FND_MESSAGE.SET_TOKEN('VALUE2',l_organization_id);
578: FB_ERROR_MSG := FND_MESSAGE.GET_ENCODED;
579: FND_MESSAGE.SET_ENCODED(fb_error_msg);

Line 576: FND_MESSAGE.SET_TOKEN('VALUE1',l_inventory_item_id);

572:
573: FND_MESSAGE.SET_NAME('ONT','OE_COGS_CCID_GEN_FAILED');
574: FND_MESSAGE.SET_TOKEN('PARAM1','Inventory Item id');
575: FND_MESSAGE.SET_TOKEN('PARAM2','/Warehouse ');
576: FND_MESSAGE.SET_TOKEN('VALUE1',l_inventory_item_id);
577: FND_MESSAGE.SET_TOKEN('VALUE2',l_organization_id);
578: FB_ERROR_MSG := FND_MESSAGE.GET_ENCODED;
579: FND_MESSAGE.SET_ENCODED(fb_error_msg);
580: l_error_msg := FND_MESSAGE.GET;

Line 577: FND_MESSAGE.SET_TOKEN('VALUE2',l_organization_id);

573: FND_MESSAGE.SET_NAME('ONT','OE_COGS_CCID_GEN_FAILED');
574: FND_MESSAGE.SET_TOKEN('PARAM1','Inventory Item id');
575: FND_MESSAGE.SET_TOKEN('PARAM2','/Warehouse ');
576: FND_MESSAGE.SET_TOKEN('VALUE1',l_inventory_item_id);
577: FND_MESSAGE.SET_TOKEN('VALUE2',l_organization_id);
578: FB_ERROR_MSG := FND_MESSAGE.GET_ENCODED;
579: FND_MESSAGE.SET_ENCODED(fb_error_msg);
580: l_error_msg := FND_MESSAGE.GET;
581: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',l_error_msg);

Line 578: FB_ERROR_MSG := FND_MESSAGE.GET_ENCODED;

574: FND_MESSAGE.SET_TOKEN('PARAM1','Inventory Item id');
575: FND_MESSAGE.SET_TOKEN('PARAM2','/Warehouse ');
576: FND_MESSAGE.SET_TOKEN('VALUE1',l_inventory_item_id);
577: FND_MESSAGE.SET_TOKEN('VALUE2',l_organization_id);
578: FB_ERROR_MSG := FND_MESSAGE.GET_ENCODED;
579: FND_MESSAGE.SET_ENCODED(fb_error_msg);
580: l_error_msg := FND_MESSAGE.GET;
581: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',l_error_msg);
582: result := 'COMPLETE:FAILURE';

Line 579: FND_MESSAGE.SET_ENCODED(fb_error_msg);

575: FND_MESSAGE.SET_TOKEN('PARAM2','/Warehouse ');
576: FND_MESSAGE.SET_TOKEN('VALUE1',l_inventory_item_id);
577: FND_MESSAGE.SET_TOKEN('VALUE2',l_organization_id);
578: FB_ERROR_MSG := FND_MESSAGE.GET_ENCODED;
579: FND_MESSAGE.SET_ENCODED(fb_error_msg);
580: l_error_msg := FND_MESSAGE.GET;
581: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',l_error_msg);
582: result := 'COMPLETE:FAILURE';
583: RETURN;

Line 580: l_error_msg := FND_MESSAGE.GET;

576: FND_MESSAGE.SET_TOKEN('VALUE1',l_inventory_item_id);
577: FND_MESSAGE.SET_TOKEN('VALUE2',l_organization_id);
578: FB_ERROR_MSG := FND_MESSAGE.GET_ENCODED;
579: FND_MESSAGE.SET_ENCODED(fb_error_msg);
580: l_error_msg := FND_MESSAGE.GET;
581: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',l_error_msg);
582: result := 'COMPLETE:FAILURE';
583: RETURN;
584: END IF;

Line 605: FND_MESSAGE.SET_NAME('ONT','OE_COGS_CCID_GEN_FAILED');

601: AND M.ORGANIZATION_ID = OL.SHIP_FROM_ORG_ID
602: AND M.INVENTORY_ITEM_ID = OL.INVENTORY_ITEM_ID;
603: EXCEPTION
604: WHEN NO_DATA_FOUND THEN
605: FND_MESSAGE.SET_NAME('ONT','OE_COGS_CCID_GEN_FAILED');
606: FND_MESSAGE.SET_TOKEN('PARAM1','Inventory Item id');
607: FND_MESSAGE.SET_TOKEN('PARAM2','/Warehouse ');
608: FND_MESSAGE.SET_TOKEN('VALUE1',l_inventory_item_id);
609: FND_MESSAGE.SET_TOKEN('VALUE2',l_organization_id);

Line 606: FND_MESSAGE.SET_TOKEN('PARAM1','Inventory Item id');

602: AND M.INVENTORY_ITEM_ID = OL.INVENTORY_ITEM_ID;
603: EXCEPTION
604: WHEN NO_DATA_FOUND THEN
605: FND_MESSAGE.SET_NAME('ONT','OE_COGS_CCID_GEN_FAILED');
606: FND_MESSAGE.SET_TOKEN('PARAM1','Inventory Item id');
607: FND_MESSAGE.SET_TOKEN('PARAM2','/Warehouse ');
608: FND_MESSAGE.SET_TOKEN('VALUE1',l_inventory_item_id);
609: FND_MESSAGE.SET_TOKEN('VALUE2',l_organization_id);
610: FB_ERROR_MSG := FND_MESSAGE.GET_ENCODED;

Line 607: FND_MESSAGE.SET_TOKEN('PARAM2','/Warehouse ');

603: EXCEPTION
604: WHEN NO_DATA_FOUND THEN
605: FND_MESSAGE.SET_NAME('ONT','OE_COGS_CCID_GEN_FAILED');
606: FND_MESSAGE.SET_TOKEN('PARAM1','Inventory Item id');
607: FND_MESSAGE.SET_TOKEN('PARAM2','/Warehouse ');
608: FND_MESSAGE.SET_TOKEN('VALUE1',l_inventory_item_id);
609: FND_MESSAGE.SET_TOKEN('VALUE2',l_organization_id);
610: FB_ERROR_MSG := FND_MESSAGE.GET_ENCODED;
611: FND_MESSAGE.SET_ENCODED(fb_error_msg);

Line 608: FND_MESSAGE.SET_TOKEN('VALUE1',l_inventory_item_id);

604: WHEN NO_DATA_FOUND THEN
605: FND_MESSAGE.SET_NAME('ONT','OE_COGS_CCID_GEN_FAILED');
606: FND_MESSAGE.SET_TOKEN('PARAM1','Inventory Item id');
607: FND_MESSAGE.SET_TOKEN('PARAM2','/Warehouse ');
608: FND_MESSAGE.SET_TOKEN('VALUE1',l_inventory_item_id);
609: FND_MESSAGE.SET_TOKEN('VALUE2',l_organization_id);
610: FB_ERROR_MSG := FND_MESSAGE.GET_ENCODED;
611: FND_MESSAGE.SET_ENCODED(fb_error_msg);
612: l_error_msg := FND_MESSAGE.GET;

Line 609: FND_MESSAGE.SET_TOKEN('VALUE2',l_organization_id);

605: FND_MESSAGE.SET_NAME('ONT','OE_COGS_CCID_GEN_FAILED');
606: FND_MESSAGE.SET_TOKEN('PARAM1','Inventory Item id');
607: FND_MESSAGE.SET_TOKEN('PARAM2','/Warehouse ');
608: FND_MESSAGE.SET_TOKEN('VALUE1',l_inventory_item_id);
609: FND_MESSAGE.SET_TOKEN('VALUE2',l_organization_id);
610: FB_ERROR_MSG := FND_MESSAGE.GET_ENCODED;
611: FND_MESSAGE.SET_ENCODED(fb_error_msg);
612: l_error_msg := FND_MESSAGE.GET;
613: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',l_error_msg);

Line 610: FB_ERROR_MSG := FND_MESSAGE.GET_ENCODED;

606: FND_MESSAGE.SET_TOKEN('PARAM1','Inventory Item id');
607: FND_MESSAGE.SET_TOKEN('PARAM2','/Warehouse ');
608: FND_MESSAGE.SET_TOKEN('VALUE1',l_inventory_item_id);
609: FND_MESSAGE.SET_TOKEN('VALUE2',l_organization_id);
610: FB_ERROR_MSG := FND_MESSAGE.GET_ENCODED;
611: FND_MESSAGE.SET_ENCODED(fb_error_msg);
612: l_error_msg := FND_MESSAGE.GET;
613: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',l_error_msg);
614: result := 'COMPLETE:FAILURE';

Line 611: FND_MESSAGE.SET_ENCODED(fb_error_msg);

607: FND_MESSAGE.SET_TOKEN('PARAM2','/Warehouse ');
608: FND_MESSAGE.SET_TOKEN('VALUE1',l_inventory_item_id);
609: FND_MESSAGE.SET_TOKEN('VALUE2',l_organization_id);
610: FB_ERROR_MSG := FND_MESSAGE.GET_ENCODED;
611: FND_MESSAGE.SET_ENCODED(fb_error_msg);
612: l_error_msg := FND_MESSAGE.GET;
613: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',l_error_msg);
614: result := 'COMPLETE:FAILURE';
615: RETURN;

Line 612: l_error_msg := FND_MESSAGE.GET;

608: FND_MESSAGE.SET_TOKEN('VALUE1',l_inventory_item_id);
609: FND_MESSAGE.SET_TOKEN('VALUE2',l_organization_id);
610: FB_ERROR_MSG := FND_MESSAGE.GET_ENCODED;
611: FND_MESSAGE.SET_ENCODED(fb_error_msg);
612: l_error_msg := FND_MESSAGE.GET;
613: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',l_error_msg);
614: result := 'COMPLETE:FAILURE';
615: RETURN;
616: END;

Line 623: FND_MESSAGE.SET_NAME('ONT','OE_COGS_CCID_GEN_FAILED');

619: END IF;
620:
621: IF l_cost_sale_item_derived = 0 THEN
622:
623: FND_MESSAGE.SET_NAME('ONT','OE_COGS_CCID_GEN_FAILED');
624: FND_MESSAGE.SET_TOKEN('PARAM1','Inventory Item id');
625: FND_MESSAGE.SET_TOKEN('PARAM2','/Warehouse ');
626: FND_MESSAGE.SET_TOKEN('VALUE1',l_inventory_item_id);
627: FND_MESSAGE.SET_TOKEN('VALUE2',l_organization_id);

Line 624: FND_MESSAGE.SET_TOKEN('PARAM1','Inventory Item id');

620:
621: IF l_cost_sale_item_derived = 0 THEN
622:
623: FND_MESSAGE.SET_NAME('ONT','OE_COGS_CCID_GEN_FAILED');
624: FND_MESSAGE.SET_TOKEN('PARAM1','Inventory Item id');
625: FND_MESSAGE.SET_TOKEN('PARAM2','/Warehouse ');
626: FND_MESSAGE.SET_TOKEN('VALUE1',l_inventory_item_id);
627: FND_MESSAGE.SET_TOKEN('VALUE2',l_organization_id);
628:

Line 625: FND_MESSAGE.SET_TOKEN('PARAM2','/Warehouse ');

621: IF l_cost_sale_item_derived = 0 THEN
622:
623: FND_MESSAGE.SET_NAME('ONT','OE_COGS_CCID_GEN_FAILED');
624: FND_MESSAGE.SET_TOKEN('PARAM1','Inventory Item id');
625: FND_MESSAGE.SET_TOKEN('PARAM2','/Warehouse ');
626: FND_MESSAGE.SET_TOKEN('VALUE1',l_inventory_item_id);
627: FND_MESSAGE.SET_TOKEN('VALUE2',l_organization_id);
628:
629: fb_error_msg := FND_MESSAGE.GET_ENCODED;

Line 626: FND_MESSAGE.SET_TOKEN('VALUE1',l_inventory_item_id);

622:
623: FND_MESSAGE.SET_NAME('ONT','OE_COGS_CCID_GEN_FAILED');
624: FND_MESSAGE.SET_TOKEN('PARAM1','Inventory Item id');
625: FND_MESSAGE.SET_TOKEN('PARAM2','/Warehouse ');
626: FND_MESSAGE.SET_TOKEN('VALUE1',l_inventory_item_id);
627: FND_MESSAGE.SET_TOKEN('VALUE2',l_organization_id);
628:
629: fb_error_msg := FND_MESSAGE.GET_ENCODED;
630: FND_MESSAGE.SET_ENCODED(fb_error_msg);

Line 627: FND_MESSAGE.SET_TOKEN('VALUE2',l_organization_id);

623: FND_MESSAGE.SET_NAME('ONT','OE_COGS_CCID_GEN_FAILED');
624: FND_MESSAGE.SET_TOKEN('PARAM1','Inventory Item id');
625: FND_MESSAGE.SET_TOKEN('PARAM2','/Warehouse ');
626: FND_MESSAGE.SET_TOKEN('VALUE1',l_inventory_item_id);
627: FND_MESSAGE.SET_TOKEN('VALUE2',l_organization_id);
628:
629: fb_error_msg := FND_MESSAGE.GET_ENCODED;
630: FND_MESSAGE.SET_ENCODED(fb_error_msg);
631: l_error_msg := FND_MESSAGE.GET;

Line 629: fb_error_msg := FND_MESSAGE.GET_ENCODED;

625: FND_MESSAGE.SET_TOKEN('PARAM2','/Warehouse ');
626: FND_MESSAGE.SET_TOKEN('VALUE1',l_inventory_item_id);
627: FND_MESSAGE.SET_TOKEN('VALUE2',l_organization_id);
628:
629: fb_error_msg := FND_MESSAGE.GET_ENCODED;
630: FND_MESSAGE.SET_ENCODED(fb_error_msg);
631: l_error_msg := FND_MESSAGE.GET;
632:
633: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',l_error_msg);

Line 630: FND_MESSAGE.SET_ENCODED(fb_error_msg);

626: FND_MESSAGE.SET_TOKEN('VALUE1',l_inventory_item_id);
627: FND_MESSAGE.SET_TOKEN('VALUE2',l_organization_id);
628:
629: fb_error_msg := FND_MESSAGE.GET_ENCODED;
630: FND_MESSAGE.SET_ENCODED(fb_error_msg);
631: l_error_msg := FND_MESSAGE.GET;
632:
633: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',l_error_msg);
634: result := 'COMPLETE:FAILURE';

Line 631: l_error_msg := FND_MESSAGE.GET;

627: FND_MESSAGE.SET_TOKEN('VALUE2',l_organization_id);
628:
629: fb_error_msg := FND_MESSAGE.GET_ENCODED;
630: FND_MESSAGE.SET_ENCODED(fb_error_msg);
631: l_error_msg := FND_MESSAGE.GET;
632:
633: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',l_error_msg);
634: result := 'COMPLETE:FAILURE';
635: RETURN;

Line 741: FND_MESSAGE.SET_NAME('ONT','OE_COGS_CCID_GEN_FAILED');

737: AND M.ORGANIZATION_ID = OL.SHIP_FROM_ORG_ID
738: AND M.INVENTORY_ITEM_ID = OL.INVENTORY_ITEM_ID;
739: EXCEPTION
740: WHEN NO_DATA_FOUND THEN
741: FND_MESSAGE.SET_NAME('ONT','OE_COGS_CCID_GEN_FAILED');
742: FND_MESSAGE.SET_TOKEN('PARAM1','Inventory Item id');
743: FND_MESSAGE.SET_TOKEN('PARAM2','/Warehouse ');
744: FND_MESSAGE.SET_TOKEN('VALUE1',l_inventory_item_id);
745: FND_MESSAGE.SET_TOKEN('VALUE2',l_organization_id);

Line 742: FND_MESSAGE.SET_TOKEN('PARAM1','Inventory Item id');

738: AND M.INVENTORY_ITEM_ID = OL.INVENTORY_ITEM_ID;
739: EXCEPTION
740: WHEN NO_DATA_FOUND THEN
741: FND_MESSAGE.SET_NAME('ONT','OE_COGS_CCID_GEN_FAILED');
742: FND_MESSAGE.SET_TOKEN('PARAM1','Inventory Item id');
743: FND_MESSAGE.SET_TOKEN('PARAM2','/Warehouse ');
744: FND_MESSAGE.SET_TOKEN('VALUE1',l_inventory_item_id);
745: FND_MESSAGE.SET_TOKEN('VALUE2',l_organization_id);
746: fb_error_msg := FND_MESSAGE.GET_ENCODED;

Line 743: FND_MESSAGE.SET_TOKEN('PARAM2','/Warehouse ');

739: EXCEPTION
740: WHEN NO_DATA_FOUND THEN
741: FND_MESSAGE.SET_NAME('ONT','OE_COGS_CCID_GEN_FAILED');
742: FND_MESSAGE.SET_TOKEN('PARAM1','Inventory Item id');
743: FND_MESSAGE.SET_TOKEN('PARAM2','/Warehouse ');
744: FND_MESSAGE.SET_TOKEN('VALUE1',l_inventory_item_id);
745: FND_MESSAGE.SET_TOKEN('VALUE2',l_organization_id);
746: fb_error_msg := FND_MESSAGE.GET_ENCODED;
747: FND_MESSAGE.SET_ENCODED(fb_error_msg);

Line 744: FND_MESSAGE.SET_TOKEN('VALUE1',l_inventory_item_id);

740: WHEN NO_DATA_FOUND THEN
741: FND_MESSAGE.SET_NAME('ONT','OE_COGS_CCID_GEN_FAILED');
742: FND_MESSAGE.SET_TOKEN('PARAM1','Inventory Item id');
743: FND_MESSAGE.SET_TOKEN('PARAM2','/Warehouse ');
744: FND_MESSAGE.SET_TOKEN('VALUE1',l_inventory_item_id);
745: FND_MESSAGE.SET_TOKEN('VALUE2',l_organization_id);
746: fb_error_msg := FND_MESSAGE.GET_ENCODED;
747: FND_MESSAGE.SET_ENCODED(fb_error_msg);
748: l_error_msg := FND_MESSAGE.GET;

Line 745: FND_MESSAGE.SET_TOKEN('VALUE2',l_organization_id);

741: FND_MESSAGE.SET_NAME('ONT','OE_COGS_CCID_GEN_FAILED');
742: FND_MESSAGE.SET_TOKEN('PARAM1','Inventory Item id');
743: FND_MESSAGE.SET_TOKEN('PARAM2','/Warehouse ');
744: FND_MESSAGE.SET_TOKEN('VALUE1',l_inventory_item_id);
745: FND_MESSAGE.SET_TOKEN('VALUE2',l_organization_id);
746: fb_error_msg := FND_MESSAGE.GET_ENCODED;
747: FND_MESSAGE.SET_ENCODED(fb_error_msg);
748: l_error_msg := FND_MESSAGE.GET;
749: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',l_error_msg);

Line 746: fb_error_msg := FND_MESSAGE.GET_ENCODED;

742: FND_MESSAGE.SET_TOKEN('PARAM1','Inventory Item id');
743: FND_MESSAGE.SET_TOKEN('PARAM2','/Warehouse ');
744: FND_MESSAGE.SET_TOKEN('VALUE1',l_inventory_item_id);
745: FND_MESSAGE.SET_TOKEN('VALUE2',l_organization_id);
746: fb_error_msg := FND_MESSAGE.GET_ENCODED;
747: FND_MESSAGE.SET_ENCODED(fb_error_msg);
748: l_error_msg := FND_MESSAGE.GET;
749: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',l_error_msg);
750: result := 'COMPLETE:FAILURE';

Line 747: FND_MESSAGE.SET_ENCODED(fb_error_msg);

743: FND_MESSAGE.SET_TOKEN('PARAM2','/Warehouse ');
744: FND_MESSAGE.SET_TOKEN('VALUE1',l_inventory_item_id);
745: FND_MESSAGE.SET_TOKEN('VALUE2',l_organization_id);
746: fb_error_msg := FND_MESSAGE.GET_ENCODED;
747: FND_MESSAGE.SET_ENCODED(fb_error_msg);
748: l_error_msg := FND_MESSAGE.GET;
749: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',l_error_msg);
750: result := 'COMPLETE:FAILURE';
751: RETURN;

Line 748: l_error_msg := FND_MESSAGE.GET;

744: FND_MESSAGE.SET_TOKEN('VALUE1',l_inventory_item_id);
745: FND_MESSAGE.SET_TOKEN('VALUE2',l_organization_id);
746: fb_error_msg := FND_MESSAGE.GET_ENCODED;
747: FND_MESSAGE.SET_ENCODED(fb_error_msg);
748: l_error_msg := FND_MESSAGE.GET;
749: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',l_error_msg);
750: result := 'COMPLETE:FAILURE';
751: RETURN;
752: END;

Line 757: FND_MESSAGE.SET_NAME('ONT','OE_COGS_CCID_GEN_FAILED');

753: END IF;
754:
755: IF l_cost_sale_model_derived = 0 THEN
756:
757: FND_MESSAGE.SET_NAME('ONT','OE_COGS_CCID_GEN_FAILED');
758: FND_MESSAGE.SET_TOKEN('PARAM1','Inventory Item id');
759: FND_MESSAGE.SET_TOKEN('PARAM2','/Warehouse ');
760: FND_MESSAGE.SET_TOKEN('VALUE1',l_inventory_item_id);
761: FND_MESSAGE.SET_TOKEN('VALUE2',l_organization_id);

Line 758: FND_MESSAGE.SET_TOKEN('PARAM1','Inventory Item id');

754:
755: IF l_cost_sale_model_derived = 0 THEN
756:
757: FND_MESSAGE.SET_NAME('ONT','OE_COGS_CCID_GEN_FAILED');
758: FND_MESSAGE.SET_TOKEN('PARAM1','Inventory Item id');
759: FND_MESSAGE.SET_TOKEN('PARAM2','/Warehouse ');
760: FND_MESSAGE.SET_TOKEN('VALUE1',l_inventory_item_id);
761: FND_MESSAGE.SET_TOKEN('VALUE2',l_organization_id);
762:

Line 759: FND_MESSAGE.SET_TOKEN('PARAM2','/Warehouse ');

755: IF l_cost_sale_model_derived = 0 THEN
756:
757: FND_MESSAGE.SET_NAME('ONT','OE_COGS_CCID_GEN_FAILED');
758: FND_MESSAGE.SET_TOKEN('PARAM1','Inventory Item id');
759: FND_MESSAGE.SET_TOKEN('PARAM2','/Warehouse ');
760: FND_MESSAGE.SET_TOKEN('VALUE1',l_inventory_item_id);
761: FND_MESSAGE.SET_TOKEN('VALUE2',l_organization_id);
762:
763: fb_error_msg := FND_MESSAGE.GET_ENCODED;

Line 760: FND_MESSAGE.SET_TOKEN('VALUE1',l_inventory_item_id);

756:
757: FND_MESSAGE.SET_NAME('ONT','OE_COGS_CCID_GEN_FAILED');
758: FND_MESSAGE.SET_TOKEN('PARAM1','Inventory Item id');
759: FND_MESSAGE.SET_TOKEN('PARAM2','/Warehouse ');
760: FND_MESSAGE.SET_TOKEN('VALUE1',l_inventory_item_id);
761: FND_MESSAGE.SET_TOKEN('VALUE2',l_organization_id);
762:
763: fb_error_msg := FND_MESSAGE.GET_ENCODED;
764: FND_MESSAGE.SET_ENCODED(fb_error_msg);

Line 761: FND_MESSAGE.SET_TOKEN('VALUE2',l_organization_id);

757: FND_MESSAGE.SET_NAME('ONT','OE_COGS_CCID_GEN_FAILED');
758: FND_MESSAGE.SET_TOKEN('PARAM1','Inventory Item id');
759: FND_MESSAGE.SET_TOKEN('PARAM2','/Warehouse ');
760: FND_MESSAGE.SET_TOKEN('VALUE1',l_inventory_item_id);
761: FND_MESSAGE.SET_TOKEN('VALUE2',l_organization_id);
762:
763: fb_error_msg := FND_MESSAGE.GET_ENCODED;
764: FND_MESSAGE.SET_ENCODED(fb_error_msg);
765: l_error_msg := FND_MESSAGE.GET;

Line 763: fb_error_msg := FND_MESSAGE.GET_ENCODED;

759: FND_MESSAGE.SET_TOKEN('PARAM2','/Warehouse ');
760: FND_MESSAGE.SET_TOKEN('VALUE1',l_inventory_item_id);
761: FND_MESSAGE.SET_TOKEN('VALUE2',l_organization_id);
762:
763: fb_error_msg := FND_MESSAGE.GET_ENCODED;
764: FND_MESSAGE.SET_ENCODED(fb_error_msg);
765: l_error_msg := FND_MESSAGE.GET;
766:
767: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',l_error_msg);

Line 764: FND_MESSAGE.SET_ENCODED(fb_error_msg);

760: FND_MESSAGE.SET_TOKEN('VALUE1',l_inventory_item_id);
761: FND_MESSAGE.SET_TOKEN('VALUE2',l_organization_id);
762:
763: fb_error_msg := FND_MESSAGE.GET_ENCODED;
764: FND_MESSAGE.SET_ENCODED(fb_error_msg);
765: l_error_msg := FND_MESSAGE.GET;
766:
767: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',l_error_msg);
768: result := 'COMPLETE:FAILURE';

Line 765: l_error_msg := FND_MESSAGE.GET;

761: FND_MESSAGE.SET_TOKEN('VALUE2',l_organization_id);
762:
763: fb_error_msg := FND_MESSAGE.GET_ENCODED;
764: FND_MESSAGE.SET_ENCODED(fb_error_msg);
765: l_error_msg := FND_MESSAGE.GET;
766:
767: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',l_error_msg);
768: result := 'COMPLETE:FAILURE';
769: RETURN;

Line 849: FND_MESSAGE.SET_NAME('ONT','OE_COGS_CCID_GEN_FAILED');

845: FROM OE_TRANSACTION_TYPES_ALL
846: WHERE TRANSACTION_TYPE_ID = l_order_type_id;
847: EXCEPTION
848: WHEN NO_DATA_FOUND THEN
849: FND_MESSAGE.SET_NAME('ONT','OE_COGS_CCID_GEN_FAILED');
850: FND_MESSAGE.SET_TOKEN('PARAM1','Order Type Id');
851: FND_MESSAGE.SET_TOKEN('PARAM2','');
852: FND_MESSAGE.SET_TOKEN('VALUE1',l_order_type_id);
853: FND_MESSAGE.SET_TOKEN('VALUE2','');

Line 850: FND_MESSAGE.SET_TOKEN('PARAM1','Order Type Id');

846: WHERE TRANSACTION_TYPE_ID = l_order_type_id;
847: EXCEPTION
848: WHEN NO_DATA_FOUND THEN
849: FND_MESSAGE.SET_NAME('ONT','OE_COGS_CCID_GEN_FAILED');
850: FND_MESSAGE.SET_TOKEN('PARAM1','Order Type Id');
851: FND_MESSAGE.SET_TOKEN('PARAM2','');
852: FND_MESSAGE.SET_TOKEN('VALUE1',l_order_type_id);
853: FND_MESSAGE.SET_TOKEN('VALUE2','');
854: fb_error_msg := FND_MESSAGE.GET_ENCODED;

Line 851: FND_MESSAGE.SET_TOKEN('PARAM2','');

847: EXCEPTION
848: WHEN NO_DATA_FOUND THEN
849: FND_MESSAGE.SET_NAME('ONT','OE_COGS_CCID_GEN_FAILED');
850: FND_MESSAGE.SET_TOKEN('PARAM1','Order Type Id');
851: FND_MESSAGE.SET_TOKEN('PARAM2','');
852: FND_MESSAGE.SET_TOKEN('VALUE1',l_order_type_id);
853: FND_MESSAGE.SET_TOKEN('VALUE2','');
854: fb_error_msg := FND_MESSAGE.GET_ENCODED;
855: FND_MESSAGE.SET_ENCODED(fb_error_msg);

Line 852: FND_MESSAGE.SET_TOKEN('VALUE1',l_order_type_id);

848: WHEN NO_DATA_FOUND THEN
849: FND_MESSAGE.SET_NAME('ONT','OE_COGS_CCID_GEN_FAILED');
850: FND_MESSAGE.SET_TOKEN('PARAM1','Order Type Id');
851: FND_MESSAGE.SET_TOKEN('PARAM2','');
852: FND_MESSAGE.SET_TOKEN('VALUE1',l_order_type_id);
853: FND_MESSAGE.SET_TOKEN('VALUE2','');
854: fb_error_msg := FND_MESSAGE.GET_ENCODED;
855: FND_MESSAGE.SET_ENCODED(fb_error_msg);
856: l_error_msg := FND_MESSAGE.GET;

Line 853: FND_MESSAGE.SET_TOKEN('VALUE2','');

849: FND_MESSAGE.SET_NAME('ONT','OE_COGS_CCID_GEN_FAILED');
850: FND_MESSAGE.SET_TOKEN('PARAM1','Order Type Id');
851: FND_MESSAGE.SET_TOKEN('PARAM2','');
852: FND_MESSAGE.SET_TOKEN('VALUE1',l_order_type_id);
853: FND_MESSAGE.SET_TOKEN('VALUE2','');
854: fb_error_msg := FND_MESSAGE.GET_ENCODED;
855: FND_MESSAGE.SET_ENCODED(fb_error_msg);
856: l_error_msg := FND_MESSAGE.GET;
857: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',l_error_msg);

Line 854: fb_error_msg := FND_MESSAGE.GET_ENCODED;

850: FND_MESSAGE.SET_TOKEN('PARAM1','Order Type Id');
851: FND_MESSAGE.SET_TOKEN('PARAM2','');
852: FND_MESSAGE.SET_TOKEN('VALUE1',l_order_type_id);
853: FND_MESSAGE.SET_TOKEN('VALUE2','');
854: fb_error_msg := FND_MESSAGE.GET_ENCODED;
855: FND_MESSAGE.SET_ENCODED(fb_error_msg);
856: l_error_msg := FND_MESSAGE.GET;
857: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',l_error_msg);
858: result := 'COMPLETE:FAILURE';

Line 855: FND_MESSAGE.SET_ENCODED(fb_error_msg);

851: FND_MESSAGE.SET_TOKEN('PARAM2','');
852: FND_MESSAGE.SET_TOKEN('VALUE1',l_order_type_id);
853: FND_MESSAGE.SET_TOKEN('VALUE2','');
854: fb_error_msg := FND_MESSAGE.GET_ENCODED;
855: FND_MESSAGE.SET_ENCODED(fb_error_msg);
856: l_error_msg := FND_MESSAGE.GET;
857: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',l_error_msg);
858: result := 'COMPLETE:FAILURE';
859: RETURN;

Line 856: l_error_msg := FND_MESSAGE.GET;

852: FND_MESSAGE.SET_TOKEN('VALUE1',l_order_type_id);
853: FND_MESSAGE.SET_TOKEN('VALUE2','');
854: fb_error_msg := FND_MESSAGE.GET_ENCODED;
855: FND_MESSAGE.SET_ENCODED(fb_error_msg);
856: l_error_msg := FND_MESSAGE.GET;
857: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',l_error_msg);
858: result := 'COMPLETE:FAILURE';
859: RETURN;
860: END;

Line 865: FND_MESSAGE.SET_NAME('ONT','OE_COGS_CCID_GEN_FAILED');

861: END IF;
862:
863: IF l_order_type_ccid = 0 THEN
864:
865: FND_MESSAGE.SET_NAME('ONT','OE_COGS_CCID_GEN_FAILED');
866: FND_MESSAGE.SET_TOKEN('PARAM1','Order Type Id');
867: FND_MESSAGE.SET_TOKEN('PARAM2','');
868: FND_MESSAGE.SET_TOKEN('VALUE1',l_order_type_id);
869: FND_MESSAGE.SET_TOKEN('VALUE2','');

Line 866: FND_MESSAGE.SET_TOKEN('PARAM1','Order Type Id');

862:
863: IF l_order_type_ccid = 0 THEN
864:
865: FND_MESSAGE.SET_NAME('ONT','OE_COGS_CCID_GEN_FAILED');
866: FND_MESSAGE.SET_TOKEN('PARAM1','Order Type Id');
867: FND_MESSAGE.SET_TOKEN('PARAM2','');
868: FND_MESSAGE.SET_TOKEN('VALUE1',l_order_type_id);
869: FND_MESSAGE.SET_TOKEN('VALUE2','');
870:

Line 867: FND_MESSAGE.SET_TOKEN('PARAM2','');

863: IF l_order_type_ccid = 0 THEN
864:
865: FND_MESSAGE.SET_NAME('ONT','OE_COGS_CCID_GEN_FAILED');
866: FND_MESSAGE.SET_TOKEN('PARAM1','Order Type Id');
867: FND_MESSAGE.SET_TOKEN('PARAM2','');
868: FND_MESSAGE.SET_TOKEN('VALUE1',l_order_type_id);
869: FND_MESSAGE.SET_TOKEN('VALUE2','');
870:
871: fb_error_msg := FND_MESSAGE.GET_ENCODED;

Line 868: FND_MESSAGE.SET_TOKEN('VALUE1',l_order_type_id);

864:
865: FND_MESSAGE.SET_NAME('ONT','OE_COGS_CCID_GEN_FAILED');
866: FND_MESSAGE.SET_TOKEN('PARAM1','Order Type Id');
867: FND_MESSAGE.SET_TOKEN('PARAM2','');
868: FND_MESSAGE.SET_TOKEN('VALUE1',l_order_type_id);
869: FND_MESSAGE.SET_TOKEN('VALUE2','');
870:
871: fb_error_msg := FND_MESSAGE.GET_ENCODED;
872: FND_MESSAGE.SET_ENCODED(fb_error_msg);

Line 869: FND_MESSAGE.SET_TOKEN('VALUE2','');

865: FND_MESSAGE.SET_NAME('ONT','OE_COGS_CCID_GEN_FAILED');
866: FND_MESSAGE.SET_TOKEN('PARAM1','Order Type Id');
867: FND_MESSAGE.SET_TOKEN('PARAM2','');
868: FND_MESSAGE.SET_TOKEN('VALUE1',l_order_type_id);
869: FND_MESSAGE.SET_TOKEN('VALUE2','');
870:
871: fb_error_msg := FND_MESSAGE.GET_ENCODED;
872: FND_MESSAGE.SET_ENCODED(fb_error_msg);
873: l_error_msg := FND_MESSAGE.GET;

Line 871: fb_error_msg := FND_MESSAGE.GET_ENCODED;

867: FND_MESSAGE.SET_TOKEN('PARAM2','');
868: FND_MESSAGE.SET_TOKEN('VALUE1',l_order_type_id);
869: FND_MESSAGE.SET_TOKEN('VALUE2','');
870:
871: fb_error_msg := FND_MESSAGE.GET_ENCODED;
872: FND_MESSAGE.SET_ENCODED(fb_error_msg);
873: l_error_msg := FND_MESSAGE.GET;
874:
875: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',l_error_msg);

Line 872: FND_MESSAGE.SET_ENCODED(fb_error_msg);

868: FND_MESSAGE.SET_TOKEN('VALUE1',l_order_type_id);
869: FND_MESSAGE.SET_TOKEN('VALUE2','');
870:
871: fb_error_msg := FND_MESSAGE.GET_ENCODED;
872: FND_MESSAGE.SET_ENCODED(fb_error_msg);
873: l_error_msg := FND_MESSAGE.GET;
874:
875: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',l_error_msg);
876: result := 'COMPLETE:FAILURE';

Line 873: l_error_msg := FND_MESSAGE.GET;

869: FND_MESSAGE.SET_TOKEN('VALUE2','');
870:
871: fb_error_msg := FND_MESSAGE.GET_ENCODED;
872: FND_MESSAGE.SET_ENCODED(fb_error_msg);
873: l_error_msg := FND_MESSAGE.GET;
874:
875: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',l_error_msg);
876: result := 'COMPLETE:FAILURE';
877: RETURN;

Line 958: FND_MESSAGE.SET_NAME('ONT','OE_COGS_CCID_GEN_FAILED');

954:
955: EXCEPTION
956: WHEN NO_DATA_FOUND THEN
957:
958: FND_MESSAGE.SET_NAME('ONT','OE_COGS_CCID_GEN_FAILED');
959: FND_MESSAGE.SET_TOKEN('PARAM1','Sales rep id');
960: FND_MESSAGE.SET_TOKEN('PARAM2','');
961: FND_MESSAGE.SET_TOKEN('VALUE1',l_salesrep_id);
962: FND_MESSAGE.SET_TOKEN('VALUE2','');

Line 959: FND_MESSAGE.SET_TOKEN('PARAM1','Sales rep id');

955: EXCEPTION
956: WHEN NO_DATA_FOUND THEN
957:
958: FND_MESSAGE.SET_NAME('ONT','OE_COGS_CCID_GEN_FAILED');
959: FND_MESSAGE.SET_TOKEN('PARAM1','Sales rep id');
960: FND_MESSAGE.SET_TOKEN('PARAM2','');
961: FND_MESSAGE.SET_TOKEN('VALUE1',l_salesrep_id);
962: FND_MESSAGE.SET_TOKEN('VALUE2','');
963: fb_error_msg := FND_MESSAGE.GET_ENCODED;

Line 960: FND_MESSAGE.SET_TOKEN('PARAM2','');

956: WHEN NO_DATA_FOUND THEN
957:
958: FND_MESSAGE.SET_NAME('ONT','OE_COGS_CCID_GEN_FAILED');
959: FND_MESSAGE.SET_TOKEN('PARAM1','Sales rep id');
960: FND_MESSAGE.SET_TOKEN('PARAM2','');
961: FND_MESSAGE.SET_TOKEN('VALUE1',l_salesrep_id);
962: FND_MESSAGE.SET_TOKEN('VALUE2','');
963: fb_error_msg := FND_MESSAGE.GET_ENCODED;
964: FND_MESSAGE.SET_ENCODED(fb_error_msg);

Line 961: FND_MESSAGE.SET_TOKEN('VALUE1',l_salesrep_id);

957:
958: FND_MESSAGE.SET_NAME('ONT','OE_COGS_CCID_GEN_FAILED');
959: FND_MESSAGE.SET_TOKEN('PARAM1','Sales rep id');
960: FND_MESSAGE.SET_TOKEN('PARAM2','');
961: FND_MESSAGE.SET_TOKEN('VALUE1',l_salesrep_id);
962: FND_MESSAGE.SET_TOKEN('VALUE2','');
963: fb_error_msg := FND_MESSAGE.GET_ENCODED;
964: FND_MESSAGE.SET_ENCODED(fb_error_msg);
965: l_error_msg := FND_MESSAGE.GET;

Line 962: FND_MESSAGE.SET_TOKEN('VALUE2','');

958: FND_MESSAGE.SET_NAME('ONT','OE_COGS_CCID_GEN_FAILED');
959: FND_MESSAGE.SET_TOKEN('PARAM1','Sales rep id');
960: FND_MESSAGE.SET_TOKEN('PARAM2','');
961: FND_MESSAGE.SET_TOKEN('VALUE1',l_salesrep_id);
962: FND_MESSAGE.SET_TOKEN('VALUE2','');
963: fb_error_msg := FND_MESSAGE.GET_ENCODED;
964: FND_MESSAGE.SET_ENCODED(fb_error_msg);
965: l_error_msg := FND_MESSAGE.GET;
966: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',l_error_msg);

Line 963: fb_error_msg := FND_MESSAGE.GET_ENCODED;

959: FND_MESSAGE.SET_TOKEN('PARAM1','Sales rep id');
960: FND_MESSAGE.SET_TOKEN('PARAM2','');
961: FND_MESSAGE.SET_TOKEN('VALUE1',l_salesrep_id);
962: FND_MESSAGE.SET_TOKEN('VALUE2','');
963: fb_error_msg := FND_MESSAGE.GET_ENCODED;
964: FND_MESSAGE.SET_ENCODED(fb_error_msg);
965: l_error_msg := FND_MESSAGE.GET;
966: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',l_error_msg);
967: result := 'COMPLETE:FAILURE';

Line 964: FND_MESSAGE.SET_ENCODED(fb_error_msg);

960: FND_MESSAGE.SET_TOKEN('PARAM2','');
961: FND_MESSAGE.SET_TOKEN('VALUE1',l_salesrep_id);
962: FND_MESSAGE.SET_TOKEN('VALUE2','');
963: fb_error_msg := FND_MESSAGE.GET_ENCODED;
964: FND_MESSAGE.SET_ENCODED(fb_error_msg);
965: l_error_msg := FND_MESSAGE.GET;
966: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',l_error_msg);
967: result := 'COMPLETE:FAILURE';
968: RETURN;

Line 965: l_error_msg := FND_MESSAGE.GET;

961: FND_MESSAGE.SET_TOKEN('VALUE1',l_salesrep_id);
962: FND_MESSAGE.SET_TOKEN('VALUE2','');
963: fb_error_msg := FND_MESSAGE.GET_ENCODED;
964: FND_MESSAGE.SET_ENCODED(fb_error_msg);
965: l_error_msg := FND_MESSAGE.GET;
966: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',l_error_msg);
967: result := 'COMPLETE:FAILURE';
968: RETURN;
969: END;

Line 974: FND_MESSAGE.SET_NAME('ONT','OE_COGS_CCID_GEN_FAILED');

970: END IF;
971:
972: IF l_salesrep_rev_derived = 0 THEN
973:
974: FND_MESSAGE.SET_NAME('ONT','OE_COGS_CCID_GEN_FAILED');
975: FND_MESSAGE.SET_TOKEN('PARAM1','Sales rep id');
976: FND_MESSAGE.SET_TOKEN('PARAM2','');
977: FND_MESSAGE.SET_TOKEN('VALUE1',l_salesrep_id);
978: FND_MESSAGE.SET_TOKEN('VALUE2','');

Line 975: FND_MESSAGE.SET_TOKEN('PARAM1','Sales rep id');

971:
972: IF l_salesrep_rev_derived = 0 THEN
973:
974: FND_MESSAGE.SET_NAME('ONT','OE_COGS_CCID_GEN_FAILED');
975: FND_MESSAGE.SET_TOKEN('PARAM1','Sales rep id');
976: FND_MESSAGE.SET_TOKEN('PARAM2','');
977: FND_MESSAGE.SET_TOKEN('VALUE1',l_salesrep_id);
978: FND_MESSAGE.SET_TOKEN('VALUE2','');
979:

Line 976: FND_MESSAGE.SET_TOKEN('PARAM2','');

972: IF l_salesrep_rev_derived = 0 THEN
973:
974: FND_MESSAGE.SET_NAME('ONT','OE_COGS_CCID_GEN_FAILED');
975: FND_MESSAGE.SET_TOKEN('PARAM1','Sales rep id');
976: FND_MESSAGE.SET_TOKEN('PARAM2','');
977: FND_MESSAGE.SET_TOKEN('VALUE1',l_salesrep_id);
978: FND_MESSAGE.SET_TOKEN('VALUE2','');
979:
980: fb_error_msg := FND_MESSAGE.GET_ENCODED;

Line 977: FND_MESSAGE.SET_TOKEN('VALUE1',l_salesrep_id);

973:
974: FND_MESSAGE.SET_NAME('ONT','OE_COGS_CCID_GEN_FAILED');
975: FND_MESSAGE.SET_TOKEN('PARAM1','Sales rep id');
976: FND_MESSAGE.SET_TOKEN('PARAM2','');
977: FND_MESSAGE.SET_TOKEN('VALUE1',l_salesrep_id);
978: FND_MESSAGE.SET_TOKEN('VALUE2','');
979:
980: fb_error_msg := FND_MESSAGE.GET_ENCODED;
981: FND_MESSAGE.SET_ENCODED(fb_error_msg);

Line 978: FND_MESSAGE.SET_TOKEN('VALUE2','');

974: FND_MESSAGE.SET_NAME('ONT','OE_COGS_CCID_GEN_FAILED');
975: FND_MESSAGE.SET_TOKEN('PARAM1','Sales rep id');
976: FND_MESSAGE.SET_TOKEN('PARAM2','');
977: FND_MESSAGE.SET_TOKEN('VALUE1',l_salesrep_id);
978: FND_MESSAGE.SET_TOKEN('VALUE2','');
979:
980: fb_error_msg := FND_MESSAGE.GET_ENCODED;
981: FND_MESSAGE.SET_ENCODED(fb_error_msg);
982: l_error_msg := FND_MESSAGE.GET;

Line 980: fb_error_msg := FND_MESSAGE.GET_ENCODED;

976: FND_MESSAGE.SET_TOKEN('PARAM2','');
977: FND_MESSAGE.SET_TOKEN('VALUE1',l_salesrep_id);
978: FND_MESSAGE.SET_TOKEN('VALUE2','');
979:
980: fb_error_msg := FND_MESSAGE.GET_ENCODED;
981: FND_MESSAGE.SET_ENCODED(fb_error_msg);
982: l_error_msg := FND_MESSAGE.GET;
983:
984: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',l_error_msg);

Line 981: FND_MESSAGE.SET_ENCODED(fb_error_msg);

977: FND_MESSAGE.SET_TOKEN('VALUE1',l_salesrep_id);
978: FND_MESSAGE.SET_TOKEN('VALUE2','');
979:
980: fb_error_msg := FND_MESSAGE.GET_ENCODED;
981: FND_MESSAGE.SET_ENCODED(fb_error_msg);
982: l_error_msg := FND_MESSAGE.GET;
983:
984: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',l_error_msg);
985: result := 'COMPLETE:FAILURE';

Line 982: l_error_msg := FND_MESSAGE.GET;

978: FND_MESSAGE.SET_TOKEN('VALUE2','');
979:
980: fb_error_msg := FND_MESSAGE.GET_ENCODED;
981: FND_MESSAGE.SET_ENCODED(fb_error_msg);
982: l_error_msg := FND_MESSAGE.GET;
983:
984: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',l_error_msg);
985: result := 'COMPLETE:FAILURE';
986: RETURN;

Line 1066: --FND_MESSAGE.SET_NAME('ONT','OE_COGS_SALESREP_NOT_FOUND');

1062: Where line_id = l_order_line_id;
1063:
1064: EXCEPTION
1065: WHEN NO_DATA_FOUND THEN
1066: --FND_MESSAGE.SET_NAME('ONT','OE_COGS_SALESREP_NOT_FOUND');
1067: --FND_MESSAGE.SET_TOKEN('LINEID',l_order_line_id);
1068: --fb_error_msg := FND_MESSAGE.GET_ENCODED;
1069: --FND_MESSAGE.SET_ENCODED(fb_error_msg);
1070: --l_error_msg := FND_MESSAGE.GET;

Line 1067: --FND_MESSAGE.SET_TOKEN('LINEID',l_order_line_id);

1063:
1064: EXCEPTION
1065: WHEN NO_DATA_FOUND THEN
1066: --FND_MESSAGE.SET_NAME('ONT','OE_COGS_SALESREP_NOT_FOUND');
1067: --FND_MESSAGE.SET_TOKEN('LINEID',l_order_line_id);
1068: --fb_error_msg := FND_MESSAGE.GET_ENCODED;
1069: --FND_MESSAGE.SET_ENCODED(fb_error_msg);
1070: --l_error_msg := FND_MESSAGE.GET;
1071: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE','No line type id found in oe_order_lines_all');

Line 1068: --fb_error_msg := FND_MESSAGE.GET_ENCODED;

1064: EXCEPTION
1065: WHEN NO_DATA_FOUND THEN
1066: --FND_MESSAGE.SET_NAME('ONT','OE_COGS_SALESREP_NOT_FOUND');
1067: --FND_MESSAGE.SET_TOKEN('LINEID',l_order_line_id);
1068: --fb_error_msg := FND_MESSAGE.GET_ENCODED;
1069: --FND_MESSAGE.SET_ENCODED(fb_error_msg);
1070: --l_error_msg := FND_MESSAGE.GET;
1071: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE','No line type id found in oe_order_lines_all');
1072: result := 'COMPLETE:FAILURE';

Line 1069: --FND_MESSAGE.SET_ENCODED(fb_error_msg);

1065: WHEN NO_DATA_FOUND THEN
1066: --FND_MESSAGE.SET_NAME('ONT','OE_COGS_SALESREP_NOT_FOUND');
1067: --FND_MESSAGE.SET_TOKEN('LINEID',l_order_line_id);
1068: --fb_error_msg := FND_MESSAGE.GET_ENCODED;
1069: --FND_MESSAGE.SET_ENCODED(fb_error_msg);
1070: --l_error_msg := FND_MESSAGE.GET;
1071: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE','No line type id found in oe_order_lines_all');
1072: result := 'COMPLETE:FAILURE';
1073: RETURN;

Line 1070: --l_error_msg := FND_MESSAGE.GET;

1066: --FND_MESSAGE.SET_NAME('ONT','OE_COGS_SALESREP_NOT_FOUND');
1067: --FND_MESSAGE.SET_TOKEN('LINEID',l_order_line_id);
1068: --fb_error_msg := FND_MESSAGE.GET_ENCODED;
1069: --FND_MESSAGE.SET_ENCODED(fb_error_msg);
1070: --l_error_msg := FND_MESSAGE.GET;
1071: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE','No line type id found in oe_order_lines_all');
1072: result := 'COMPLETE:FAILURE';
1073: RETURN;
1074:

Line 1206: FND_MESSAGE.SET_NAME('ONT','OE_COGS_SALESREP_NOT_FOUND');

1202:
1203: EXCEPTION
1204:
1205: WHEN NO_DATA_FOUND THEN
1206: FND_MESSAGE.SET_NAME('ONT','OE_COGS_SALESREP_NOT_FOUND');
1207: FND_MESSAGE.SET_TOKEN('LINEID',l_order_line_id);
1208: fb_error_msg := FND_MESSAGE.GET_ENCODED;
1209: FND_MESSAGE.SET_ENCODED(fb_error_msg);
1210: l_error_msg := FND_MESSAGE.GET;

Line 1207: FND_MESSAGE.SET_TOKEN('LINEID',l_order_line_id);

1203: EXCEPTION
1204:
1205: WHEN NO_DATA_FOUND THEN
1206: FND_MESSAGE.SET_NAME('ONT','OE_COGS_SALESREP_NOT_FOUND');
1207: FND_MESSAGE.SET_TOKEN('LINEID',l_order_line_id);
1208: fb_error_msg := FND_MESSAGE.GET_ENCODED;
1209: FND_MESSAGE.SET_ENCODED(fb_error_msg);
1210: l_error_msg := FND_MESSAGE.GET;
1211: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',l_error_msg);

Line 1208: fb_error_msg := FND_MESSAGE.GET_ENCODED;

1204:
1205: WHEN NO_DATA_FOUND THEN
1206: FND_MESSAGE.SET_NAME('ONT','OE_COGS_SALESREP_NOT_FOUND');
1207: FND_MESSAGE.SET_TOKEN('LINEID',l_order_line_id);
1208: fb_error_msg := FND_MESSAGE.GET_ENCODED;
1209: FND_MESSAGE.SET_ENCODED(fb_error_msg);
1210: l_error_msg := FND_MESSAGE.GET;
1211: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',l_error_msg);
1212: result := 'COMPLETE:FAILURE';

Line 1209: FND_MESSAGE.SET_ENCODED(fb_error_msg);

1205: WHEN NO_DATA_FOUND THEN
1206: FND_MESSAGE.SET_NAME('ONT','OE_COGS_SALESREP_NOT_FOUND');
1207: FND_MESSAGE.SET_TOKEN('LINEID',l_order_line_id);
1208: fb_error_msg := FND_MESSAGE.GET_ENCODED;
1209: FND_MESSAGE.SET_ENCODED(fb_error_msg);
1210: l_error_msg := FND_MESSAGE.GET;
1211: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',l_error_msg);
1212: result := 'COMPLETE:FAILURE';
1213: RETURN;

Line 1210: l_error_msg := FND_MESSAGE.GET;

1206: FND_MESSAGE.SET_NAME('ONT','OE_COGS_SALESREP_NOT_FOUND');
1207: FND_MESSAGE.SET_TOKEN('LINEID',l_order_line_id);
1208: fb_error_msg := FND_MESSAGE.GET_ENCODED;
1209: FND_MESSAGE.SET_ENCODED(fb_error_msg);
1210: l_error_msg := FND_MESSAGE.GET;
1211: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',l_error_msg);
1212: result := 'COMPLETE:FAILURE';
1213: RETURN;
1214: END;

Line 1295: FND_MESSAGE.SET_NAME('ONT','OE_COGS_CCID_GEN_FAILED');

1291: WHERE INVENTORY_ITEM_ID = l_inv_item_id
1292: AND ORGANIZATION_ID = l_ship_from_org_id;
1293: EXCEPTION
1294: WHEN NO_DATA_FOUND THEN
1295: FND_MESSAGE.SET_NAME('ONT','OE_COGS_CCID_GEN_FAILED');
1296: FND_MESSAGE.SET_TOKEN('PARAM1','Inventory Item id');
1297: FND_MESSAGE.SET_TOKEN('PARAM2','/Warehouse ');
1298: FND_MESSAGE.SET_TOKEN('VALUE1',l_inv_item_id);
1299: FND_MESSAGE.SET_TOKEN('VALUE2',l_ship_from_org_id);

Line 1296: FND_MESSAGE.SET_TOKEN('PARAM1','Inventory Item id');

1292: AND ORGANIZATION_ID = l_ship_from_org_id;
1293: EXCEPTION
1294: WHEN NO_DATA_FOUND THEN
1295: FND_MESSAGE.SET_NAME('ONT','OE_COGS_CCID_GEN_FAILED');
1296: FND_MESSAGE.SET_TOKEN('PARAM1','Inventory Item id');
1297: FND_MESSAGE.SET_TOKEN('PARAM2','/Warehouse ');
1298: FND_MESSAGE.SET_TOKEN('VALUE1',l_inv_item_id);
1299: FND_MESSAGE.SET_TOKEN('VALUE2',l_ship_from_org_id);
1300: fb_error_msg := FND_MESSAGE.GET_ENCODED;

Line 1297: FND_MESSAGE.SET_TOKEN('PARAM2','/Warehouse ');

1293: EXCEPTION
1294: WHEN NO_DATA_FOUND THEN
1295: FND_MESSAGE.SET_NAME('ONT','OE_COGS_CCID_GEN_FAILED');
1296: FND_MESSAGE.SET_TOKEN('PARAM1','Inventory Item id');
1297: FND_MESSAGE.SET_TOKEN('PARAM2','/Warehouse ');
1298: FND_MESSAGE.SET_TOKEN('VALUE1',l_inv_item_id);
1299: FND_MESSAGE.SET_TOKEN('VALUE2',l_ship_from_org_id);
1300: fb_error_msg := FND_MESSAGE.GET_ENCODED;
1301: FND_MESSAGE.SET_ENCODED(fb_error_msg);

Line 1298: FND_MESSAGE.SET_TOKEN('VALUE1',l_inv_item_id);

1294: WHEN NO_DATA_FOUND THEN
1295: FND_MESSAGE.SET_NAME('ONT','OE_COGS_CCID_GEN_FAILED');
1296: FND_MESSAGE.SET_TOKEN('PARAM1','Inventory Item id');
1297: FND_MESSAGE.SET_TOKEN('PARAM2','/Warehouse ');
1298: FND_MESSAGE.SET_TOKEN('VALUE1',l_inv_item_id);
1299: FND_MESSAGE.SET_TOKEN('VALUE2',l_ship_from_org_id);
1300: fb_error_msg := FND_MESSAGE.GET_ENCODED;
1301: FND_MESSAGE.SET_ENCODED(fb_error_msg);
1302: l_error_msg := FND_MESSAGE.GET;

Line 1299: FND_MESSAGE.SET_TOKEN('VALUE2',l_ship_from_org_id);

1295: FND_MESSAGE.SET_NAME('ONT','OE_COGS_CCID_GEN_FAILED');
1296: FND_MESSAGE.SET_TOKEN('PARAM1','Inventory Item id');
1297: FND_MESSAGE.SET_TOKEN('PARAM2','/Warehouse ');
1298: FND_MESSAGE.SET_TOKEN('VALUE1',l_inv_item_id);
1299: FND_MESSAGE.SET_TOKEN('VALUE2',l_ship_from_org_id);
1300: fb_error_msg := FND_MESSAGE.GET_ENCODED;
1301: FND_MESSAGE.SET_ENCODED(fb_error_msg);
1302: l_error_msg := FND_MESSAGE.GET;
1303: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',l_error_msg);

Line 1300: fb_error_msg := FND_MESSAGE.GET_ENCODED;

1296: FND_MESSAGE.SET_TOKEN('PARAM1','Inventory Item id');
1297: FND_MESSAGE.SET_TOKEN('PARAM2','/Warehouse ');
1298: FND_MESSAGE.SET_TOKEN('VALUE1',l_inv_item_id);
1299: FND_MESSAGE.SET_TOKEN('VALUE2',l_ship_from_org_id);
1300: fb_error_msg := FND_MESSAGE.GET_ENCODED;
1301: FND_MESSAGE.SET_ENCODED(fb_error_msg);
1302: l_error_msg := FND_MESSAGE.GET;
1303: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',l_error_msg);
1304: result := 'COMPLETE:FAILURE';

Line 1301: FND_MESSAGE.SET_ENCODED(fb_error_msg);

1297: FND_MESSAGE.SET_TOKEN('PARAM2','/Warehouse ');
1298: FND_MESSAGE.SET_TOKEN('VALUE1',l_inv_item_id);
1299: FND_MESSAGE.SET_TOKEN('VALUE2',l_ship_from_org_id);
1300: fb_error_msg := FND_MESSAGE.GET_ENCODED;
1301: FND_MESSAGE.SET_ENCODED(fb_error_msg);
1302: l_error_msg := FND_MESSAGE.GET;
1303: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',l_error_msg);
1304: result := 'COMPLETE:FAILURE';
1305: RETURN;

Line 1302: l_error_msg := FND_MESSAGE.GET;

1298: FND_MESSAGE.SET_TOKEN('VALUE1',l_inv_item_id);
1299: FND_MESSAGE.SET_TOKEN('VALUE2',l_ship_from_org_id);
1300: fb_error_msg := FND_MESSAGE.GET_ENCODED;
1301: FND_MESSAGE.SET_ENCODED(fb_error_msg);
1302: l_error_msg := FND_MESSAGE.GET;
1303: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',l_error_msg);
1304: result := 'COMPLETE:FAILURE';
1305: RETURN;
1306: END;

Line 1310: FND_MESSAGE.SET_NAME('ONT','OE_COGS_CCID_GEN_FAILED');

1306: END;
1307:
1308: IF l_account_derived = 0 THEN
1309:
1310: FND_MESSAGE.SET_NAME('ONT','OE_COGS_CCID_GEN_FAILED');
1311: FND_MESSAGE.SET_TOKEN('PARAM1','Inventory Item id');
1312: FND_MESSAGE.SET_TOKEN('PARAM2','/Warehouse ');
1313: FND_MESSAGE.SET_TOKEN('VALUE1',l_inv_item_id);
1314: FND_MESSAGE.SET_TOKEN('VALUE2',l_ship_from_org_id);

Line 1311: FND_MESSAGE.SET_TOKEN('PARAM1','Inventory Item id');

1307:
1308: IF l_account_derived = 0 THEN
1309:
1310: FND_MESSAGE.SET_NAME('ONT','OE_COGS_CCID_GEN_FAILED');
1311: FND_MESSAGE.SET_TOKEN('PARAM1','Inventory Item id');
1312: FND_MESSAGE.SET_TOKEN('PARAM2','/Warehouse ');
1313: FND_MESSAGE.SET_TOKEN('VALUE1',l_inv_item_id);
1314: FND_MESSAGE.SET_TOKEN('VALUE2',l_ship_from_org_id);
1315:

Line 1312: FND_MESSAGE.SET_TOKEN('PARAM2','/Warehouse ');

1308: IF l_account_derived = 0 THEN
1309:
1310: FND_MESSAGE.SET_NAME('ONT','OE_COGS_CCID_GEN_FAILED');
1311: FND_MESSAGE.SET_TOKEN('PARAM1','Inventory Item id');
1312: FND_MESSAGE.SET_TOKEN('PARAM2','/Warehouse ');
1313: FND_MESSAGE.SET_TOKEN('VALUE1',l_inv_item_id);
1314: FND_MESSAGE.SET_TOKEN('VALUE2',l_ship_from_org_id);
1315:
1316: fb_error_msg := FND_MESSAGE.GET_ENCODED;

Line 1313: FND_MESSAGE.SET_TOKEN('VALUE1',l_inv_item_id);

1309:
1310: FND_MESSAGE.SET_NAME('ONT','OE_COGS_CCID_GEN_FAILED');
1311: FND_MESSAGE.SET_TOKEN('PARAM1','Inventory Item id');
1312: FND_MESSAGE.SET_TOKEN('PARAM2','/Warehouse ');
1313: FND_MESSAGE.SET_TOKEN('VALUE1',l_inv_item_id);
1314: FND_MESSAGE.SET_TOKEN('VALUE2',l_ship_from_org_id);
1315:
1316: fb_error_msg := FND_MESSAGE.GET_ENCODED;
1317: FND_MESSAGE.SET_ENCODED(fb_error_msg);

Line 1314: FND_MESSAGE.SET_TOKEN('VALUE2',l_ship_from_org_id);

1310: FND_MESSAGE.SET_NAME('ONT','OE_COGS_CCID_GEN_FAILED');
1311: FND_MESSAGE.SET_TOKEN('PARAM1','Inventory Item id');
1312: FND_MESSAGE.SET_TOKEN('PARAM2','/Warehouse ');
1313: FND_MESSAGE.SET_TOKEN('VALUE1',l_inv_item_id);
1314: FND_MESSAGE.SET_TOKEN('VALUE2',l_ship_from_org_id);
1315:
1316: fb_error_msg := FND_MESSAGE.GET_ENCODED;
1317: FND_MESSAGE.SET_ENCODED(fb_error_msg);
1318: l_error_msg := FND_MESSAGE.GET;

Line 1316: fb_error_msg := FND_MESSAGE.GET_ENCODED;

1312: FND_MESSAGE.SET_TOKEN('PARAM2','/Warehouse ');
1313: FND_MESSAGE.SET_TOKEN('VALUE1',l_inv_item_id);
1314: FND_MESSAGE.SET_TOKEN('VALUE2',l_ship_from_org_id);
1315:
1316: fb_error_msg := FND_MESSAGE.GET_ENCODED;
1317: FND_MESSAGE.SET_ENCODED(fb_error_msg);
1318: l_error_msg := FND_MESSAGE.GET;
1319:
1320: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',l_error_msg);

Line 1317: FND_MESSAGE.SET_ENCODED(fb_error_msg);

1313: FND_MESSAGE.SET_TOKEN('VALUE1',l_inv_item_id);
1314: FND_MESSAGE.SET_TOKEN('VALUE2',l_ship_from_org_id);
1315:
1316: fb_error_msg := FND_MESSAGE.GET_ENCODED;
1317: FND_MESSAGE.SET_ENCODED(fb_error_msg);
1318: l_error_msg := FND_MESSAGE.GET;
1319:
1320: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',l_error_msg);
1321: result := 'COMPLETE:FAILURE';

Line 1318: l_error_msg := FND_MESSAGE.GET;

1314: FND_MESSAGE.SET_TOKEN('VALUE2',l_ship_from_org_id);
1315:
1316: fb_error_msg := FND_MESSAGE.GET_ENCODED;
1317: FND_MESSAGE.SET_ENCODED(fb_error_msg);
1318: l_error_msg := FND_MESSAGE.GET;
1319:
1320: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',l_error_msg);
1321: result := 'COMPLETE:FAILURE';
1322: RETURN;

Line 1459: FND_MESSAGE.SET_NAME('ONT','OE_COGS_TRX_TYPE_NOT_FOUND');

1455: AND TRX.ORG_ID = TYPE.ORG_ID
1456: AND TRX.CUST_TRX_TYPE_ID = TYPE.CUST_TRX_TYPE_ID;
1457: EXCEPTION
1458: WHEN NO_DATA_FOUND THEN
1459: FND_MESSAGE.SET_NAME('ONT','OE_COGS_TRX_TYPE_NOT_FOUND');
1460: FND_MESSAGE.SET_TOKEN('COMMITMENTID',l_commitment_id);
1461: fb_error_msg := FND_MESSAGE.GET_ENCODED;
1462: FND_MESSAGE.SET_ENCODED(fb_error_msg);
1463: l_error_msg := FND_MESSAGE.GET;

Line 1460: FND_MESSAGE.SET_TOKEN('COMMITMENTID',l_commitment_id);

1456: AND TRX.CUST_TRX_TYPE_ID = TYPE.CUST_TRX_TYPE_ID;
1457: EXCEPTION
1458: WHEN NO_DATA_FOUND THEN
1459: FND_MESSAGE.SET_NAME('ONT','OE_COGS_TRX_TYPE_NOT_FOUND');
1460: FND_MESSAGE.SET_TOKEN('COMMITMENTID',l_commitment_id);
1461: fb_error_msg := FND_MESSAGE.GET_ENCODED;
1462: FND_MESSAGE.SET_ENCODED(fb_error_msg);
1463: l_error_msg := FND_MESSAGE.GET;
1464: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',l_error_msg);

Line 1461: fb_error_msg := FND_MESSAGE.GET_ENCODED;

1457: EXCEPTION
1458: WHEN NO_DATA_FOUND THEN
1459: FND_MESSAGE.SET_NAME('ONT','OE_COGS_TRX_TYPE_NOT_FOUND');
1460: FND_MESSAGE.SET_TOKEN('COMMITMENTID',l_commitment_id);
1461: fb_error_msg := FND_MESSAGE.GET_ENCODED;
1462: FND_MESSAGE.SET_ENCODED(fb_error_msg);
1463: l_error_msg := FND_MESSAGE.GET;
1464: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',l_error_msg);
1465: result := 'COMPLETE:FAILURE';

Line 1462: FND_MESSAGE.SET_ENCODED(fb_error_msg);

1458: WHEN NO_DATA_FOUND THEN
1459: FND_MESSAGE.SET_NAME('ONT','OE_COGS_TRX_TYPE_NOT_FOUND');
1460: FND_MESSAGE.SET_TOKEN('COMMITMENTID',l_commitment_id);
1461: fb_error_msg := FND_MESSAGE.GET_ENCODED;
1462: FND_MESSAGE.SET_ENCODED(fb_error_msg);
1463: l_error_msg := FND_MESSAGE.GET;
1464: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',l_error_msg);
1465: result := 'COMPLETE:FAILURE';
1466: RETURN;

Line 1463: l_error_msg := FND_MESSAGE.GET;

1459: FND_MESSAGE.SET_NAME('ONT','OE_COGS_TRX_TYPE_NOT_FOUND');
1460: FND_MESSAGE.SET_TOKEN('COMMITMENTID',l_commitment_id);
1461: fb_error_msg := FND_MESSAGE.GET_ENCODED;
1462: FND_MESSAGE.SET_ENCODED(fb_error_msg);
1463: l_error_msg := FND_MESSAGE.GET;
1464: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',l_error_msg);
1465: result := 'COMPLETE:FAILURE';
1466: RETURN;
1467: END;

Line 1533: FND_MESSAGE.SET_NAME('FND', 'FLEXWK-UPGRADE FUNC MISSING');

1529: oe_debug_pub.add('Entering OE_FLEX_COGS_PUB.BUILD',2);
1530: END IF;
1531: fb_flex_seg := NULL;
1532:
1533: FND_MESSAGE.SET_NAME('FND', 'FLEXWK-UPGRADE FUNC MISSING');
1534: FND_MESSAGE.SET_TOKEN('FUNC','OE_INVENTORY_INTERFACE');
1535: FB_ERROR_MSG := FND_MESSAGE.GET_ENCODED;
1536: RETURN FALSE;
1537: END Build;

Line 1534: FND_MESSAGE.SET_TOKEN('FUNC','OE_INVENTORY_INTERFACE');

1530: END IF;
1531: fb_flex_seg := NULL;
1532:
1533: FND_MESSAGE.SET_NAME('FND', 'FLEXWK-UPGRADE FUNC MISSING');
1534: FND_MESSAGE.SET_TOKEN('FUNC','OE_INVENTORY_INTERFACE');
1535: FB_ERROR_MSG := FND_MESSAGE.GET_ENCODED;
1536: RETURN FALSE;
1537: END Build;
1538:

Line 1535: FB_ERROR_MSG := FND_MESSAGE.GET_ENCODED;

1531: fb_flex_seg := NULL;
1532:
1533: FND_MESSAGE.SET_NAME('FND', 'FLEXWK-UPGRADE FUNC MISSING');
1534: FND_MESSAGE.SET_TOKEN('FUNC','OE_INVENTORY_INTERFACE');
1535: FB_ERROR_MSG := FND_MESSAGE.GET_ENCODED;
1536: RETURN FALSE;
1537: END Build;
1538:
1539: