APPS.OE_FLEX_COGS_PUB dependencies on FND_MESSAGE

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

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

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

135:
136: EXCEPTION
137:
138: WHEN NO_DATA_FOUND THEN
139: FND_MESSAGE.SET_NAME('ONT','OE_COGS_INVALID_LINE_ID');
140: FND_MESSAGE.SET_TOKEN('LINE_ID',l_line_id);
141: OE_MSG_PUB.ADD;
142: RAISE FND_API.G_EXC_ERROR;
143:

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

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

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

215: ,p_entity_id => l_line_id
216: ,p_line_id => l_line_id
217: );
218:
219: FND_MESSAGE.SET_NAME('ONT','OE_COGS_INVALID_LINE_ID');
220: FND_MESSAGE.SET_TOKEN('LINE_ID',l_line_id);
221: OE_MSG_PUB.ADD;
222: RAISE FND_API.G_EXC_ERROR;
223: END;

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

216: ,p_line_id => l_line_id
217: );
218:
219: FND_MESSAGE.SET_NAME('ONT','OE_COGS_INVALID_LINE_ID');
220: FND_MESSAGE.SET_TOKEN('LINE_ID',l_line_id);
221: OE_MSG_PUB.ADD;
222: RAISE FND_API.G_EXC_ERROR;
223: END;
224:

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

232: WHERE HEADER_ID = l_header_id;
233:
234: IF l_ship_from_org_id IS NULL THEN
235:
236: FND_MESSAGE.SET_NAME('ONT','OE_COGS_WAREHOUSE_MISSING');
237: FND_MESSAGE.SET_TOKEN('LINE_ID',l_line_id);
238: OE_MSG_PUB.ADD;
239: RAISE FND_API.G_EXC_ERROR;
240:

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

233:
234: IF l_ship_from_org_id IS NULL THEN
235:
236: FND_MESSAGE.SET_NAME('ONT','OE_COGS_WAREHOUSE_MISSING');
237: FND_MESSAGE.SET_TOKEN('LINE_ID',l_line_id);
238: OE_MSG_PUB.ADD;
239: RAISE FND_API.G_EXC_ERROR;
240:
241: END IF;

Line 392: fnd_message.set_encoded(l_errmsg);

388: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
389: End;
390:
391: IF INSTR(l_errmsg, CHR(0)) > 0 THEN -- 2352606
392: fnd_message.set_encoded(l_errmsg);
393: l_errmsg := fnd_message.get;
394: END IF;
395:
396: g_stmt:='80';

Line 393: l_errmsg := fnd_message.get;

389: End;
390:
391: IF INSTR(l_errmsg, CHR(0)) > 0 THEN -- 2352606
392: fnd_message.set_encoded(l_errmsg);
393: l_errmsg := fnd_message.get;
394: END IF;
395:
396: g_stmt:='80';
397:

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

407: ELSE
408: IF l_debug_level > 0 THEN
409: oe_debug_pub.add('Error Message : '|| l_errmsg,2);
410: END IF;
411: FND_MESSAGE.SET_NAME('ONT','OE_COGS_ACC_GEN_FAILED');
412: FND_MESSAGE.SET_TOKEN('ERROR_MESSAGE',l_errmsg);
413: OE_MSG_PUB.ADD;
414: RAISE FND_API.G_EXC_ERROR;
415: END IF;

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

408: IF l_debug_level > 0 THEN
409: oe_debug_pub.add('Error Message : '|| l_errmsg,2);
410: END IF;
411: FND_MESSAGE.SET_NAME('ONT','OE_COGS_ACC_GEN_FAILED');
412: FND_MESSAGE.SET_TOKEN('ERROR_MESSAGE',l_errmsg);
413: OE_MSG_PUB.ADD;
414: RAISE FND_API.G_EXC_ERROR;
415: END IF;
416: oe_debug_pub.add('Exiting OE_Flex_Cogs_Pub.Start_process : '|| l_return_status, 1); -- 2352606

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

417: RETURN l_return_status;
418: EXCEPTION
419:
420: WHEN NO_DATA_FOUND THEN
421: FND_MESSAGE.SET_NAME('ONT','OE_COGS_COA_ID_NOT_FOUND');
422: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID',l_ship_from_org_id);
423: OE_MSG_PUB.ADD;
424:
425: x_msg_count := OE_MSG_PUB.Count_Msg; -- 2352606 start

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

418: EXCEPTION
419:
420: WHEN NO_DATA_FOUND THEN
421: FND_MESSAGE.SET_NAME('ONT','OE_COGS_COA_ID_NOT_FOUND');
422: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID',l_ship_from_org_id);
423: OE_MSG_PUB.ADD;
424:
425: x_msg_count := OE_MSG_PUB.Count_Msg; -- 2352606 start
426: IF x_msg_count > 0 THEN

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

555: WHEN NO_DATA_FOUND THEN
556:
557: IF l_item_type_code <> OE_GLOBALS.G_ITEM_CONFIG THEN
558:
559: FND_MESSAGE.SET_NAME('ONT','OE_COGS_CCID_GEN_FAILED');
560: FND_MESSAGE.SET_TOKEN('PARAM1','Inventory Item id');
561: FND_MESSAGE.SET_TOKEN('PARAM2','/Warehouse ');
562: FND_MESSAGE.SET_TOKEN('VALUE1',l_inventory_item_id);
563: FND_MESSAGE.SET_TOKEN('VALUE2',l_organization_id);

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

556:
557: IF l_item_type_code <> OE_GLOBALS.G_ITEM_CONFIG THEN
558:
559: FND_MESSAGE.SET_NAME('ONT','OE_COGS_CCID_GEN_FAILED');
560: FND_MESSAGE.SET_TOKEN('PARAM1','Inventory Item id');
561: FND_MESSAGE.SET_TOKEN('PARAM2','/Warehouse ');
562: FND_MESSAGE.SET_TOKEN('VALUE1',l_inventory_item_id);
563: FND_MESSAGE.SET_TOKEN('VALUE2',l_organization_id);
564: FB_ERROR_MSG := FND_MESSAGE.GET_ENCODED;

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

557: IF l_item_type_code <> OE_GLOBALS.G_ITEM_CONFIG THEN
558:
559: FND_MESSAGE.SET_NAME('ONT','OE_COGS_CCID_GEN_FAILED');
560: FND_MESSAGE.SET_TOKEN('PARAM1','Inventory Item id');
561: FND_MESSAGE.SET_TOKEN('PARAM2','/Warehouse ');
562: FND_MESSAGE.SET_TOKEN('VALUE1',l_inventory_item_id);
563: FND_MESSAGE.SET_TOKEN('VALUE2',l_organization_id);
564: FB_ERROR_MSG := FND_MESSAGE.GET_ENCODED;
565: FND_MESSAGE.SET_ENCODED(fb_error_msg);

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

558:
559: FND_MESSAGE.SET_NAME('ONT','OE_COGS_CCID_GEN_FAILED');
560: FND_MESSAGE.SET_TOKEN('PARAM1','Inventory Item id');
561: FND_MESSAGE.SET_TOKEN('PARAM2','/Warehouse ');
562: FND_MESSAGE.SET_TOKEN('VALUE1',l_inventory_item_id);
563: FND_MESSAGE.SET_TOKEN('VALUE2',l_organization_id);
564: FB_ERROR_MSG := FND_MESSAGE.GET_ENCODED;
565: FND_MESSAGE.SET_ENCODED(fb_error_msg);
566: l_error_msg := FND_MESSAGE.GET;

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

559: FND_MESSAGE.SET_NAME('ONT','OE_COGS_CCID_GEN_FAILED');
560: FND_MESSAGE.SET_TOKEN('PARAM1','Inventory Item id');
561: FND_MESSAGE.SET_TOKEN('PARAM2','/Warehouse ');
562: FND_MESSAGE.SET_TOKEN('VALUE1',l_inventory_item_id);
563: FND_MESSAGE.SET_TOKEN('VALUE2',l_organization_id);
564: FB_ERROR_MSG := FND_MESSAGE.GET_ENCODED;
565: FND_MESSAGE.SET_ENCODED(fb_error_msg);
566: l_error_msg := FND_MESSAGE.GET;
567: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',l_error_msg);

Line 564: FB_ERROR_MSG := FND_MESSAGE.GET_ENCODED;

560: FND_MESSAGE.SET_TOKEN('PARAM1','Inventory Item id');
561: FND_MESSAGE.SET_TOKEN('PARAM2','/Warehouse ');
562: FND_MESSAGE.SET_TOKEN('VALUE1',l_inventory_item_id);
563: FND_MESSAGE.SET_TOKEN('VALUE2',l_organization_id);
564: FB_ERROR_MSG := FND_MESSAGE.GET_ENCODED;
565: FND_MESSAGE.SET_ENCODED(fb_error_msg);
566: l_error_msg := FND_MESSAGE.GET;
567: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',l_error_msg);
568: result := 'COMPLETE:FAILURE';

Line 565: FND_MESSAGE.SET_ENCODED(fb_error_msg);

561: FND_MESSAGE.SET_TOKEN('PARAM2','/Warehouse ');
562: FND_MESSAGE.SET_TOKEN('VALUE1',l_inventory_item_id);
563: FND_MESSAGE.SET_TOKEN('VALUE2',l_organization_id);
564: FB_ERROR_MSG := FND_MESSAGE.GET_ENCODED;
565: FND_MESSAGE.SET_ENCODED(fb_error_msg);
566: l_error_msg := FND_MESSAGE.GET;
567: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',l_error_msg);
568: result := 'COMPLETE:FAILURE';
569: RETURN;

Line 566: l_error_msg := FND_MESSAGE.GET;

562: FND_MESSAGE.SET_TOKEN('VALUE1',l_inventory_item_id);
563: FND_MESSAGE.SET_TOKEN('VALUE2',l_organization_id);
564: FB_ERROR_MSG := FND_MESSAGE.GET_ENCODED;
565: FND_MESSAGE.SET_ENCODED(fb_error_msg);
566: l_error_msg := FND_MESSAGE.GET;
567: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',l_error_msg);
568: result := 'COMPLETE:FAILURE';
569: RETURN;
570: END IF;

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

587: AND M.ORGANIZATION_ID = OL.SHIP_FROM_ORG_ID
588: AND M.INVENTORY_ITEM_ID = OL.INVENTORY_ITEM_ID;
589: EXCEPTION
590: WHEN NO_DATA_FOUND THEN
591: FND_MESSAGE.SET_NAME('ONT','OE_COGS_CCID_GEN_FAILED');
592: FND_MESSAGE.SET_TOKEN('PARAM1','Inventory Item id');
593: FND_MESSAGE.SET_TOKEN('PARAM2','/Warehouse ');
594: FND_MESSAGE.SET_TOKEN('VALUE1',l_inventory_item_id);
595: FND_MESSAGE.SET_TOKEN('VALUE2',l_organization_id);

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

588: AND M.INVENTORY_ITEM_ID = OL.INVENTORY_ITEM_ID;
589: EXCEPTION
590: WHEN NO_DATA_FOUND THEN
591: FND_MESSAGE.SET_NAME('ONT','OE_COGS_CCID_GEN_FAILED');
592: FND_MESSAGE.SET_TOKEN('PARAM1','Inventory Item id');
593: FND_MESSAGE.SET_TOKEN('PARAM2','/Warehouse ');
594: FND_MESSAGE.SET_TOKEN('VALUE1',l_inventory_item_id);
595: FND_MESSAGE.SET_TOKEN('VALUE2',l_organization_id);
596: FB_ERROR_MSG := FND_MESSAGE.GET_ENCODED;

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

589: EXCEPTION
590: WHEN NO_DATA_FOUND THEN
591: FND_MESSAGE.SET_NAME('ONT','OE_COGS_CCID_GEN_FAILED');
592: FND_MESSAGE.SET_TOKEN('PARAM1','Inventory Item id');
593: FND_MESSAGE.SET_TOKEN('PARAM2','/Warehouse ');
594: FND_MESSAGE.SET_TOKEN('VALUE1',l_inventory_item_id);
595: FND_MESSAGE.SET_TOKEN('VALUE2',l_organization_id);
596: FB_ERROR_MSG := FND_MESSAGE.GET_ENCODED;
597: FND_MESSAGE.SET_ENCODED(fb_error_msg);

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

590: WHEN NO_DATA_FOUND THEN
591: FND_MESSAGE.SET_NAME('ONT','OE_COGS_CCID_GEN_FAILED');
592: FND_MESSAGE.SET_TOKEN('PARAM1','Inventory Item id');
593: FND_MESSAGE.SET_TOKEN('PARAM2','/Warehouse ');
594: FND_MESSAGE.SET_TOKEN('VALUE1',l_inventory_item_id);
595: FND_MESSAGE.SET_TOKEN('VALUE2',l_organization_id);
596: FB_ERROR_MSG := FND_MESSAGE.GET_ENCODED;
597: FND_MESSAGE.SET_ENCODED(fb_error_msg);
598: l_error_msg := FND_MESSAGE.GET;

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

591: FND_MESSAGE.SET_NAME('ONT','OE_COGS_CCID_GEN_FAILED');
592: FND_MESSAGE.SET_TOKEN('PARAM1','Inventory Item id');
593: FND_MESSAGE.SET_TOKEN('PARAM2','/Warehouse ');
594: FND_MESSAGE.SET_TOKEN('VALUE1',l_inventory_item_id);
595: FND_MESSAGE.SET_TOKEN('VALUE2',l_organization_id);
596: FB_ERROR_MSG := FND_MESSAGE.GET_ENCODED;
597: FND_MESSAGE.SET_ENCODED(fb_error_msg);
598: l_error_msg := FND_MESSAGE.GET;
599: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',l_error_msg);

Line 596: FB_ERROR_MSG := FND_MESSAGE.GET_ENCODED;

592: FND_MESSAGE.SET_TOKEN('PARAM1','Inventory Item id');
593: FND_MESSAGE.SET_TOKEN('PARAM2','/Warehouse ');
594: FND_MESSAGE.SET_TOKEN('VALUE1',l_inventory_item_id);
595: FND_MESSAGE.SET_TOKEN('VALUE2',l_organization_id);
596: FB_ERROR_MSG := FND_MESSAGE.GET_ENCODED;
597: FND_MESSAGE.SET_ENCODED(fb_error_msg);
598: l_error_msg := FND_MESSAGE.GET;
599: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',l_error_msg);
600: result := 'COMPLETE:FAILURE';

Line 597: FND_MESSAGE.SET_ENCODED(fb_error_msg);

593: FND_MESSAGE.SET_TOKEN('PARAM2','/Warehouse ');
594: FND_MESSAGE.SET_TOKEN('VALUE1',l_inventory_item_id);
595: FND_MESSAGE.SET_TOKEN('VALUE2',l_organization_id);
596: FB_ERROR_MSG := FND_MESSAGE.GET_ENCODED;
597: FND_MESSAGE.SET_ENCODED(fb_error_msg);
598: l_error_msg := FND_MESSAGE.GET;
599: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',l_error_msg);
600: result := 'COMPLETE:FAILURE';
601: RETURN;

Line 598: l_error_msg := FND_MESSAGE.GET;

594: FND_MESSAGE.SET_TOKEN('VALUE1',l_inventory_item_id);
595: FND_MESSAGE.SET_TOKEN('VALUE2',l_organization_id);
596: FB_ERROR_MSG := FND_MESSAGE.GET_ENCODED;
597: FND_MESSAGE.SET_ENCODED(fb_error_msg);
598: l_error_msg := FND_MESSAGE.GET;
599: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',l_error_msg);
600: result := 'COMPLETE:FAILURE';
601: RETURN;
602: END;

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

605: END IF;
606:
607: IF l_cost_sale_item_derived = 0 THEN
608:
609: FND_MESSAGE.SET_NAME('ONT','OE_COGS_CCID_GEN_FAILED');
610: FND_MESSAGE.SET_TOKEN('PARAM1','Inventory Item id');
611: FND_MESSAGE.SET_TOKEN('PARAM2','/Warehouse ');
612: FND_MESSAGE.SET_TOKEN('VALUE1',l_inventory_item_id);
613: FND_MESSAGE.SET_TOKEN('VALUE2',l_organization_id);

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

606:
607: IF l_cost_sale_item_derived = 0 THEN
608:
609: FND_MESSAGE.SET_NAME('ONT','OE_COGS_CCID_GEN_FAILED');
610: FND_MESSAGE.SET_TOKEN('PARAM1','Inventory Item id');
611: FND_MESSAGE.SET_TOKEN('PARAM2','/Warehouse ');
612: FND_MESSAGE.SET_TOKEN('VALUE1',l_inventory_item_id);
613: FND_MESSAGE.SET_TOKEN('VALUE2',l_organization_id);
614:

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

607: IF l_cost_sale_item_derived = 0 THEN
608:
609: FND_MESSAGE.SET_NAME('ONT','OE_COGS_CCID_GEN_FAILED');
610: FND_MESSAGE.SET_TOKEN('PARAM1','Inventory Item id');
611: FND_MESSAGE.SET_TOKEN('PARAM2','/Warehouse ');
612: FND_MESSAGE.SET_TOKEN('VALUE1',l_inventory_item_id);
613: FND_MESSAGE.SET_TOKEN('VALUE2',l_organization_id);
614:
615: fb_error_msg := FND_MESSAGE.GET_ENCODED;

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

608:
609: FND_MESSAGE.SET_NAME('ONT','OE_COGS_CCID_GEN_FAILED');
610: FND_MESSAGE.SET_TOKEN('PARAM1','Inventory Item id');
611: FND_MESSAGE.SET_TOKEN('PARAM2','/Warehouse ');
612: FND_MESSAGE.SET_TOKEN('VALUE1',l_inventory_item_id);
613: FND_MESSAGE.SET_TOKEN('VALUE2',l_organization_id);
614:
615: fb_error_msg := FND_MESSAGE.GET_ENCODED;
616: FND_MESSAGE.SET_ENCODED(fb_error_msg);

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

609: FND_MESSAGE.SET_NAME('ONT','OE_COGS_CCID_GEN_FAILED');
610: FND_MESSAGE.SET_TOKEN('PARAM1','Inventory Item id');
611: FND_MESSAGE.SET_TOKEN('PARAM2','/Warehouse ');
612: FND_MESSAGE.SET_TOKEN('VALUE1',l_inventory_item_id);
613: FND_MESSAGE.SET_TOKEN('VALUE2',l_organization_id);
614:
615: fb_error_msg := FND_MESSAGE.GET_ENCODED;
616: FND_MESSAGE.SET_ENCODED(fb_error_msg);
617: l_error_msg := FND_MESSAGE.GET;

Line 615: fb_error_msg := FND_MESSAGE.GET_ENCODED;

611: FND_MESSAGE.SET_TOKEN('PARAM2','/Warehouse ');
612: FND_MESSAGE.SET_TOKEN('VALUE1',l_inventory_item_id);
613: FND_MESSAGE.SET_TOKEN('VALUE2',l_organization_id);
614:
615: fb_error_msg := FND_MESSAGE.GET_ENCODED;
616: FND_MESSAGE.SET_ENCODED(fb_error_msg);
617: l_error_msg := FND_MESSAGE.GET;
618:
619: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',l_error_msg);

Line 616: FND_MESSAGE.SET_ENCODED(fb_error_msg);

612: FND_MESSAGE.SET_TOKEN('VALUE1',l_inventory_item_id);
613: FND_MESSAGE.SET_TOKEN('VALUE2',l_organization_id);
614:
615: fb_error_msg := FND_MESSAGE.GET_ENCODED;
616: FND_MESSAGE.SET_ENCODED(fb_error_msg);
617: l_error_msg := FND_MESSAGE.GET;
618:
619: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',l_error_msg);
620: result := 'COMPLETE:FAILURE';

Line 617: l_error_msg := FND_MESSAGE.GET;

613: FND_MESSAGE.SET_TOKEN('VALUE2',l_organization_id);
614:
615: fb_error_msg := FND_MESSAGE.GET_ENCODED;
616: FND_MESSAGE.SET_ENCODED(fb_error_msg);
617: l_error_msg := FND_MESSAGE.GET;
618:
619: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',l_error_msg);
620: result := 'COMPLETE:FAILURE';
621: RETURN;

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

723: AND M.ORGANIZATION_ID = OL.SHIP_FROM_ORG_ID
724: AND M.INVENTORY_ITEM_ID = OL.INVENTORY_ITEM_ID;
725: EXCEPTION
726: WHEN NO_DATA_FOUND THEN
727: FND_MESSAGE.SET_NAME('ONT','OE_COGS_CCID_GEN_FAILED');
728: FND_MESSAGE.SET_TOKEN('PARAM1','Inventory Item id');
729: FND_MESSAGE.SET_TOKEN('PARAM2','/Warehouse ');
730: FND_MESSAGE.SET_TOKEN('VALUE1',l_inventory_item_id);
731: FND_MESSAGE.SET_TOKEN('VALUE2',l_organization_id);

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

724: AND M.INVENTORY_ITEM_ID = OL.INVENTORY_ITEM_ID;
725: EXCEPTION
726: WHEN NO_DATA_FOUND THEN
727: FND_MESSAGE.SET_NAME('ONT','OE_COGS_CCID_GEN_FAILED');
728: FND_MESSAGE.SET_TOKEN('PARAM1','Inventory Item id');
729: FND_MESSAGE.SET_TOKEN('PARAM2','/Warehouse ');
730: FND_MESSAGE.SET_TOKEN('VALUE1',l_inventory_item_id);
731: FND_MESSAGE.SET_TOKEN('VALUE2',l_organization_id);
732: fb_error_msg := FND_MESSAGE.GET_ENCODED;

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

725: EXCEPTION
726: WHEN NO_DATA_FOUND THEN
727: FND_MESSAGE.SET_NAME('ONT','OE_COGS_CCID_GEN_FAILED');
728: FND_MESSAGE.SET_TOKEN('PARAM1','Inventory Item id');
729: FND_MESSAGE.SET_TOKEN('PARAM2','/Warehouse ');
730: FND_MESSAGE.SET_TOKEN('VALUE1',l_inventory_item_id);
731: FND_MESSAGE.SET_TOKEN('VALUE2',l_organization_id);
732: fb_error_msg := FND_MESSAGE.GET_ENCODED;
733: FND_MESSAGE.SET_ENCODED(fb_error_msg);

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

726: WHEN NO_DATA_FOUND THEN
727: FND_MESSAGE.SET_NAME('ONT','OE_COGS_CCID_GEN_FAILED');
728: FND_MESSAGE.SET_TOKEN('PARAM1','Inventory Item id');
729: FND_MESSAGE.SET_TOKEN('PARAM2','/Warehouse ');
730: FND_MESSAGE.SET_TOKEN('VALUE1',l_inventory_item_id);
731: FND_MESSAGE.SET_TOKEN('VALUE2',l_organization_id);
732: fb_error_msg := FND_MESSAGE.GET_ENCODED;
733: FND_MESSAGE.SET_ENCODED(fb_error_msg);
734: l_error_msg := FND_MESSAGE.GET;

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

727: FND_MESSAGE.SET_NAME('ONT','OE_COGS_CCID_GEN_FAILED');
728: FND_MESSAGE.SET_TOKEN('PARAM1','Inventory Item id');
729: FND_MESSAGE.SET_TOKEN('PARAM2','/Warehouse ');
730: FND_MESSAGE.SET_TOKEN('VALUE1',l_inventory_item_id);
731: FND_MESSAGE.SET_TOKEN('VALUE2',l_organization_id);
732: fb_error_msg := FND_MESSAGE.GET_ENCODED;
733: FND_MESSAGE.SET_ENCODED(fb_error_msg);
734: l_error_msg := FND_MESSAGE.GET;
735: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',l_error_msg);

Line 732: fb_error_msg := FND_MESSAGE.GET_ENCODED;

728: FND_MESSAGE.SET_TOKEN('PARAM1','Inventory Item id');
729: FND_MESSAGE.SET_TOKEN('PARAM2','/Warehouse ');
730: FND_MESSAGE.SET_TOKEN('VALUE1',l_inventory_item_id);
731: FND_MESSAGE.SET_TOKEN('VALUE2',l_organization_id);
732: fb_error_msg := FND_MESSAGE.GET_ENCODED;
733: FND_MESSAGE.SET_ENCODED(fb_error_msg);
734: l_error_msg := FND_MESSAGE.GET;
735: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',l_error_msg);
736: result := 'COMPLETE:FAILURE';

Line 733: FND_MESSAGE.SET_ENCODED(fb_error_msg);

729: FND_MESSAGE.SET_TOKEN('PARAM2','/Warehouse ');
730: FND_MESSAGE.SET_TOKEN('VALUE1',l_inventory_item_id);
731: FND_MESSAGE.SET_TOKEN('VALUE2',l_organization_id);
732: fb_error_msg := FND_MESSAGE.GET_ENCODED;
733: FND_MESSAGE.SET_ENCODED(fb_error_msg);
734: l_error_msg := FND_MESSAGE.GET;
735: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',l_error_msg);
736: result := 'COMPLETE:FAILURE';
737: RETURN;

Line 734: l_error_msg := FND_MESSAGE.GET;

730: FND_MESSAGE.SET_TOKEN('VALUE1',l_inventory_item_id);
731: FND_MESSAGE.SET_TOKEN('VALUE2',l_organization_id);
732: fb_error_msg := FND_MESSAGE.GET_ENCODED;
733: FND_MESSAGE.SET_ENCODED(fb_error_msg);
734: l_error_msg := FND_MESSAGE.GET;
735: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',l_error_msg);
736: result := 'COMPLETE:FAILURE';
737: RETURN;
738: END;

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

739: END IF;
740:
741: IF l_cost_sale_model_derived = 0 THEN
742:
743: FND_MESSAGE.SET_NAME('ONT','OE_COGS_CCID_GEN_FAILED');
744: FND_MESSAGE.SET_TOKEN('PARAM1','Inventory Item id');
745: FND_MESSAGE.SET_TOKEN('PARAM2','/Warehouse ');
746: FND_MESSAGE.SET_TOKEN('VALUE1',l_inventory_item_id);
747: FND_MESSAGE.SET_TOKEN('VALUE2',l_organization_id);

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

740:
741: IF l_cost_sale_model_derived = 0 THEN
742:
743: FND_MESSAGE.SET_NAME('ONT','OE_COGS_CCID_GEN_FAILED');
744: FND_MESSAGE.SET_TOKEN('PARAM1','Inventory Item id');
745: FND_MESSAGE.SET_TOKEN('PARAM2','/Warehouse ');
746: FND_MESSAGE.SET_TOKEN('VALUE1',l_inventory_item_id);
747: FND_MESSAGE.SET_TOKEN('VALUE2',l_organization_id);
748:

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

741: IF l_cost_sale_model_derived = 0 THEN
742:
743: FND_MESSAGE.SET_NAME('ONT','OE_COGS_CCID_GEN_FAILED');
744: FND_MESSAGE.SET_TOKEN('PARAM1','Inventory Item id');
745: FND_MESSAGE.SET_TOKEN('PARAM2','/Warehouse ');
746: FND_MESSAGE.SET_TOKEN('VALUE1',l_inventory_item_id);
747: FND_MESSAGE.SET_TOKEN('VALUE2',l_organization_id);
748:
749: fb_error_msg := FND_MESSAGE.GET_ENCODED;

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

742:
743: FND_MESSAGE.SET_NAME('ONT','OE_COGS_CCID_GEN_FAILED');
744: FND_MESSAGE.SET_TOKEN('PARAM1','Inventory Item id');
745: FND_MESSAGE.SET_TOKEN('PARAM2','/Warehouse ');
746: FND_MESSAGE.SET_TOKEN('VALUE1',l_inventory_item_id);
747: FND_MESSAGE.SET_TOKEN('VALUE2',l_organization_id);
748:
749: fb_error_msg := FND_MESSAGE.GET_ENCODED;
750: FND_MESSAGE.SET_ENCODED(fb_error_msg);

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

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

Line 749: fb_error_msg := FND_MESSAGE.GET_ENCODED;

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

Line 750: FND_MESSAGE.SET_ENCODED(fb_error_msg);

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

Line 751: l_error_msg := FND_MESSAGE.GET;

747: FND_MESSAGE.SET_TOKEN('VALUE2',l_organization_id);
748:
749: fb_error_msg := FND_MESSAGE.GET_ENCODED;
750: FND_MESSAGE.SET_ENCODED(fb_error_msg);
751: l_error_msg := FND_MESSAGE.GET;
752:
753: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',l_error_msg);
754: result := 'COMPLETE:FAILURE';
755: RETURN;

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

831: FROM OE_TRANSACTION_TYPES_ALL
832: WHERE TRANSACTION_TYPE_ID = l_order_type_id;
833: EXCEPTION
834: WHEN NO_DATA_FOUND THEN
835: FND_MESSAGE.SET_NAME('ONT','OE_COGS_CCID_GEN_FAILED');
836: FND_MESSAGE.SET_TOKEN('PARAM1','Order Type Id');
837: FND_MESSAGE.SET_TOKEN('PARAM2','');
838: FND_MESSAGE.SET_TOKEN('VALUE1',l_order_type_id);
839: FND_MESSAGE.SET_TOKEN('VALUE2','');

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

832: WHERE TRANSACTION_TYPE_ID = l_order_type_id;
833: EXCEPTION
834: WHEN NO_DATA_FOUND THEN
835: FND_MESSAGE.SET_NAME('ONT','OE_COGS_CCID_GEN_FAILED');
836: FND_MESSAGE.SET_TOKEN('PARAM1','Order Type Id');
837: FND_MESSAGE.SET_TOKEN('PARAM2','');
838: FND_MESSAGE.SET_TOKEN('VALUE1',l_order_type_id);
839: FND_MESSAGE.SET_TOKEN('VALUE2','');
840: fb_error_msg := FND_MESSAGE.GET_ENCODED;

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

833: EXCEPTION
834: WHEN NO_DATA_FOUND THEN
835: FND_MESSAGE.SET_NAME('ONT','OE_COGS_CCID_GEN_FAILED');
836: FND_MESSAGE.SET_TOKEN('PARAM1','Order Type Id');
837: FND_MESSAGE.SET_TOKEN('PARAM2','');
838: FND_MESSAGE.SET_TOKEN('VALUE1',l_order_type_id);
839: FND_MESSAGE.SET_TOKEN('VALUE2','');
840: fb_error_msg := FND_MESSAGE.GET_ENCODED;
841: FND_MESSAGE.SET_ENCODED(fb_error_msg);

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

834: WHEN NO_DATA_FOUND THEN
835: FND_MESSAGE.SET_NAME('ONT','OE_COGS_CCID_GEN_FAILED');
836: FND_MESSAGE.SET_TOKEN('PARAM1','Order Type Id');
837: FND_MESSAGE.SET_TOKEN('PARAM2','');
838: FND_MESSAGE.SET_TOKEN('VALUE1',l_order_type_id);
839: FND_MESSAGE.SET_TOKEN('VALUE2','');
840: fb_error_msg := FND_MESSAGE.GET_ENCODED;
841: FND_MESSAGE.SET_ENCODED(fb_error_msg);
842: l_error_msg := FND_MESSAGE.GET;

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

835: FND_MESSAGE.SET_NAME('ONT','OE_COGS_CCID_GEN_FAILED');
836: FND_MESSAGE.SET_TOKEN('PARAM1','Order Type Id');
837: FND_MESSAGE.SET_TOKEN('PARAM2','');
838: FND_MESSAGE.SET_TOKEN('VALUE1',l_order_type_id);
839: FND_MESSAGE.SET_TOKEN('VALUE2','');
840: fb_error_msg := FND_MESSAGE.GET_ENCODED;
841: FND_MESSAGE.SET_ENCODED(fb_error_msg);
842: l_error_msg := FND_MESSAGE.GET;
843: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',l_error_msg);

Line 840: fb_error_msg := FND_MESSAGE.GET_ENCODED;

836: FND_MESSAGE.SET_TOKEN('PARAM1','Order Type Id');
837: FND_MESSAGE.SET_TOKEN('PARAM2','');
838: FND_MESSAGE.SET_TOKEN('VALUE1',l_order_type_id);
839: FND_MESSAGE.SET_TOKEN('VALUE2','');
840: fb_error_msg := FND_MESSAGE.GET_ENCODED;
841: FND_MESSAGE.SET_ENCODED(fb_error_msg);
842: l_error_msg := FND_MESSAGE.GET;
843: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',l_error_msg);
844: result := 'COMPLETE:FAILURE';

Line 841: FND_MESSAGE.SET_ENCODED(fb_error_msg);

837: FND_MESSAGE.SET_TOKEN('PARAM2','');
838: FND_MESSAGE.SET_TOKEN('VALUE1',l_order_type_id);
839: FND_MESSAGE.SET_TOKEN('VALUE2','');
840: fb_error_msg := FND_MESSAGE.GET_ENCODED;
841: FND_MESSAGE.SET_ENCODED(fb_error_msg);
842: l_error_msg := FND_MESSAGE.GET;
843: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',l_error_msg);
844: result := 'COMPLETE:FAILURE';
845: RETURN;

Line 842: l_error_msg := FND_MESSAGE.GET;

838: FND_MESSAGE.SET_TOKEN('VALUE1',l_order_type_id);
839: FND_MESSAGE.SET_TOKEN('VALUE2','');
840: fb_error_msg := FND_MESSAGE.GET_ENCODED;
841: FND_MESSAGE.SET_ENCODED(fb_error_msg);
842: l_error_msg := FND_MESSAGE.GET;
843: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',l_error_msg);
844: result := 'COMPLETE:FAILURE';
845: RETURN;
846: END;

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

847: END IF;
848:
849: IF l_order_type_ccid = 0 THEN
850:
851: FND_MESSAGE.SET_NAME('ONT','OE_COGS_CCID_GEN_FAILED');
852: FND_MESSAGE.SET_TOKEN('PARAM1','Order Type Id');
853: FND_MESSAGE.SET_TOKEN('PARAM2','');
854: FND_MESSAGE.SET_TOKEN('VALUE1',l_order_type_id);
855: FND_MESSAGE.SET_TOKEN('VALUE2','');

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

848:
849: IF l_order_type_ccid = 0 THEN
850:
851: FND_MESSAGE.SET_NAME('ONT','OE_COGS_CCID_GEN_FAILED');
852: FND_MESSAGE.SET_TOKEN('PARAM1','Order Type Id');
853: FND_MESSAGE.SET_TOKEN('PARAM2','');
854: FND_MESSAGE.SET_TOKEN('VALUE1',l_order_type_id);
855: FND_MESSAGE.SET_TOKEN('VALUE2','');
856:

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

849: IF l_order_type_ccid = 0 THEN
850:
851: FND_MESSAGE.SET_NAME('ONT','OE_COGS_CCID_GEN_FAILED');
852: FND_MESSAGE.SET_TOKEN('PARAM1','Order Type Id');
853: FND_MESSAGE.SET_TOKEN('PARAM2','');
854: FND_MESSAGE.SET_TOKEN('VALUE1',l_order_type_id);
855: FND_MESSAGE.SET_TOKEN('VALUE2','');
856:
857: fb_error_msg := FND_MESSAGE.GET_ENCODED;

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

850:
851: FND_MESSAGE.SET_NAME('ONT','OE_COGS_CCID_GEN_FAILED');
852: FND_MESSAGE.SET_TOKEN('PARAM1','Order Type Id');
853: FND_MESSAGE.SET_TOKEN('PARAM2','');
854: FND_MESSAGE.SET_TOKEN('VALUE1',l_order_type_id);
855: FND_MESSAGE.SET_TOKEN('VALUE2','');
856:
857: fb_error_msg := FND_MESSAGE.GET_ENCODED;
858: FND_MESSAGE.SET_ENCODED(fb_error_msg);

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

851: FND_MESSAGE.SET_NAME('ONT','OE_COGS_CCID_GEN_FAILED');
852: FND_MESSAGE.SET_TOKEN('PARAM1','Order Type Id');
853: FND_MESSAGE.SET_TOKEN('PARAM2','');
854: FND_MESSAGE.SET_TOKEN('VALUE1',l_order_type_id);
855: FND_MESSAGE.SET_TOKEN('VALUE2','');
856:
857: fb_error_msg := FND_MESSAGE.GET_ENCODED;
858: FND_MESSAGE.SET_ENCODED(fb_error_msg);
859: l_error_msg := FND_MESSAGE.GET;

Line 857: fb_error_msg := FND_MESSAGE.GET_ENCODED;

853: FND_MESSAGE.SET_TOKEN('PARAM2','');
854: FND_MESSAGE.SET_TOKEN('VALUE1',l_order_type_id);
855: FND_MESSAGE.SET_TOKEN('VALUE2','');
856:
857: fb_error_msg := FND_MESSAGE.GET_ENCODED;
858: FND_MESSAGE.SET_ENCODED(fb_error_msg);
859: l_error_msg := FND_MESSAGE.GET;
860:
861: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',l_error_msg);

Line 858: FND_MESSAGE.SET_ENCODED(fb_error_msg);

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

Line 859: l_error_msg := FND_MESSAGE.GET;

855: FND_MESSAGE.SET_TOKEN('VALUE2','');
856:
857: fb_error_msg := FND_MESSAGE.GET_ENCODED;
858: FND_MESSAGE.SET_ENCODED(fb_error_msg);
859: l_error_msg := FND_MESSAGE.GET;
860:
861: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',l_error_msg);
862: result := 'COMPLETE:FAILURE';
863: RETURN;

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

940:
941: EXCEPTION
942: WHEN NO_DATA_FOUND THEN
943:
944: FND_MESSAGE.SET_NAME('ONT','OE_COGS_CCID_GEN_FAILED');
945: FND_MESSAGE.SET_TOKEN('PARAM1','Sales rep id');
946: FND_MESSAGE.SET_TOKEN('PARAM2','');
947: FND_MESSAGE.SET_TOKEN('VALUE1',l_salesrep_id);
948: FND_MESSAGE.SET_TOKEN('VALUE2','');

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

941: EXCEPTION
942: WHEN NO_DATA_FOUND THEN
943:
944: FND_MESSAGE.SET_NAME('ONT','OE_COGS_CCID_GEN_FAILED');
945: FND_MESSAGE.SET_TOKEN('PARAM1','Sales rep id');
946: FND_MESSAGE.SET_TOKEN('PARAM2','');
947: FND_MESSAGE.SET_TOKEN('VALUE1',l_salesrep_id);
948: FND_MESSAGE.SET_TOKEN('VALUE2','');
949: fb_error_msg := FND_MESSAGE.GET_ENCODED;

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

942: WHEN NO_DATA_FOUND THEN
943:
944: FND_MESSAGE.SET_NAME('ONT','OE_COGS_CCID_GEN_FAILED');
945: FND_MESSAGE.SET_TOKEN('PARAM1','Sales rep id');
946: FND_MESSAGE.SET_TOKEN('PARAM2','');
947: FND_MESSAGE.SET_TOKEN('VALUE1',l_salesrep_id);
948: FND_MESSAGE.SET_TOKEN('VALUE2','');
949: fb_error_msg := FND_MESSAGE.GET_ENCODED;
950: FND_MESSAGE.SET_ENCODED(fb_error_msg);

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

943:
944: FND_MESSAGE.SET_NAME('ONT','OE_COGS_CCID_GEN_FAILED');
945: FND_MESSAGE.SET_TOKEN('PARAM1','Sales rep id');
946: FND_MESSAGE.SET_TOKEN('PARAM2','');
947: FND_MESSAGE.SET_TOKEN('VALUE1',l_salesrep_id);
948: FND_MESSAGE.SET_TOKEN('VALUE2','');
949: fb_error_msg := FND_MESSAGE.GET_ENCODED;
950: FND_MESSAGE.SET_ENCODED(fb_error_msg);
951: l_error_msg := FND_MESSAGE.GET;

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

944: FND_MESSAGE.SET_NAME('ONT','OE_COGS_CCID_GEN_FAILED');
945: FND_MESSAGE.SET_TOKEN('PARAM1','Sales rep id');
946: FND_MESSAGE.SET_TOKEN('PARAM2','');
947: FND_MESSAGE.SET_TOKEN('VALUE1',l_salesrep_id);
948: FND_MESSAGE.SET_TOKEN('VALUE2','');
949: fb_error_msg := FND_MESSAGE.GET_ENCODED;
950: FND_MESSAGE.SET_ENCODED(fb_error_msg);
951: l_error_msg := FND_MESSAGE.GET;
952: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',l_error_msg);

Line 949: fb_error_msg := FND_MESSAGE.GET_ENCODED;

945: FND_MESSAGE.SET_TOKEN('PARAM1','Sales rep id');
946: FND_MESSAGE.SET_TOKEN('PARAM2','');
947: FND_MESSAGE.SET_TOKEN('VALUE1',l_salesrep_id);
948: FND_MESSAGE.SET_TOKEN('VALUE2','');
949: fb_error_msg := FND_MESSAGE.GET_ENCODED;
950: FND_MESSAGE.SET_ENCODED(fb_error_msg);
951: l_error_msg := FND_MESSAGE.GET;
952: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',l_error_msg);
953: result := 'COMPLETE:FAILURE';

Line 950: FND_MESSAGE.SET_ENCODED(fb_error_msg);

946: FND_MESSAGE.SET_TOKEN('PARAM2','');
947: FND_MESSAGE.SET_TOKEN('VALUE1',l_salesrep_id);
948: FND_MESSAGE.SET_TOKEN('VALUE2','');
949: fb_error_msg := FND_MESSAGE.GET_ENCODED;
950: FND_MESSAGE.SET_ENCODED(fb_error_msg);
951: l_error_msg := FND_MESSAGE.GET;
952: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',l_error_msg);
953: result := 'COMPLETE:FAILURE';
954: RETURN;

Line 951: l_error_msg := FND_MESSAGE.GET;

947: FND_MESSAGE.SET_TOKEN('VALUE1',l_salesrep_id);
948: FND_MESSAGE.SET_TOKEN('VALUE2','');
949: fb_error_msg := FND_MESSAGE.GET_ENCODED;
950: FND_MESSAGE.SET_ENCODED(fb_error_msg);
951: l_error_msg := FND_MESSAGE.GET;
952: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',l_error_msg);
953: result := 'COMPLETE:FAILURE';
954: RETURN;
955: END;

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

956: END IF;
957:
958: IF l_salesrep_rev_derived = 0 THEN
959:
960: FND_MESSAGE.SET_NAME('ONT','OE_COGS_CCID_GEN_FAILED');
961: FND_MESSAGE.SET_TOKEN('PARAM1','Sales rep id');
962: FND_MESSAGE.SET_TOKEN('PARAM2','');
963: FND_MESSAGE.SET_TOKEN('VALUE1',l_salesrep_id);
964: FND_MESSAGE.SET_TOKEN('VALUE2','');

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

957:
958: IF l_salesrep_rev_derived = 0 THEN
959:
960: FND_MESSAGE.SET_NAME('ONT','OE_COGS_CCID_GEN_FAILED');
961: FND_MESSAGE.SET_TOKEN('PARAM1','Sales rep id');
962: FND_MESSAGE.SET_TOKEN('PARAM2','');
963: FND_MESSAGE.SET_TOKEN('VALUE1',l_salesrep_id);
964: FND_MESSAGE.SET_TOKEN('VALUE2','');
965:

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

958: IF l_salesrep_rev_derived = 0 THEN
959:
960: FND_MESSAGE.SET_NAME('ONT','OE_COGS_CCID_GEN_FAILED');
961: FND_MESSAGE.SET_TOKEN('PARAM1','Sales rep id');
962: FND_MESSAGE.SET_TOKEN('PARAM2','');
963: FND_MESSAGE.SET_TOKEN('VALUE1',l_salesrep_id);
964: FND_MESSAGE.SET_TOKEN('VALUE2','');
965:
966: fb_error_msg := FND_MESSAGE.GET_ENCODED;

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

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

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

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

Line 966: fb_error_msg := FND_MESSAGE.GET_ENCODED;

962: FND_MESSAGE.SET_TOKEN('PARAM2','');
963: FND_MESSAGE.SET_TOKEN('VALUE1',l_salesrep_id);
964: FND_MESSAGE.SET_TOKEN('VALUE2','');
965:
966: fb_error_msg := FND_MESSAGE.GET_ENCODED;
967: FND_MESSAGE.SET_ENCODED(fb_error_msg);
968: l_error_msg := FND_MESSAGE.GET;
969:
970: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',l_error_msg);

Line 967: FND_MESSAGE.SET_ENCODED(fb_error_msg);

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

Line 968: l_error_msg := FND_MESSAGE.GET;

964: FND_MESSAGE.SET_TOKEN('VALUE2','');
965:
966: fb_error_msg := FND_MESSAGE.GET_ENCODED;
967: FND_MESSAGE.SET_ENCODED(fb_error_msg);
968: l_error_msg := FND_MESSAGE.GET;
969:
970: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',l_error_msg);
971: result := 'COMPLETE:FAILURE';
972: RETURN;

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

1048: Where line_id = l_order_line_id;
1049:
1050: EXCEPTION
1051: WHEN NO_DATA_FOUND THEN
1052: --FND_MESSAGE.SET_NAME('ONT','OE_COGS_SALESREP_NOT_FOUND');
1053: --FND_MESSAGE.SET_TOKEN('LINEID',l_order_line_id);
1054: --fb_error_msg := FND_MESSAGE.GET_ENCODED;
1055: --FND_MESSAGE.SET_ENCODED(fb_error_msg);
1056: --l_error_msg := FND_MESSAGE.GET;

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

1049:
1050: EXCEPTION
1051: WHEN NO_DATA_FOUND THEN
1052: --FND_MESSAGE.SET_NAME('ONT','OE_COGS_SALESREP_NOT_FOUND');
1053: --FND_MESSAGE.SET_TOKEN('LINEID',l_order_line_id);
1054: --fb_error_msg := FND_MESSAGE.GET_ENCODED;
1055: --FND_MESSAGE.SET_ENCODED(fb_error_msg);
1056: --l_error_msg := FND_MESSAGE.GET;
1057: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE','No line type id found in oe_order_lines_all');

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

1050: EXCEPTION
1051: WHEN NO_DATA_FOUND THEN
1052: --FND_MESSAGE.SET_NAME('ONT','OE_COGS_SALESREP_NOT_FOUND');
1053: --FND_MESSAGE.SET_TOKEN('LINEID',l_order_line_id);
1054: --fb_error_msg := FND_MESSAGE.GET_ENCODED;
1055: --FND_MESSAGE.SET_ENCODED(fb_error_msg);
1056: --l_error_msg := FND_MESSAGE.GET;
1057: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE','No line type id found in oe_order_lines_all');
1058: result := 'COMPLETE:FAILURE';

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

1051: WHEN NO_DATA_FOUND THEN
1052: --FND_MESSAGE.SET_NAME('ONT','OE_COGS_SALESREP_NOT_FOUND');
1053: --FND_MESSAGE.SET_TOKEN('LINEID',l_order_line_id);
1054: --fb_error_msg := FND_MESSAGE.GET_ENCODED;
1055: --FND_MESSAGE.SET_ENCODED(fb_error_msg);
1056: --l_error_msg := FND_MESSAGE.GET;
1057: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE','No line type id found in oe_order_lines_all');
1058: result := 'COMPLETE:FAILURE';
1059: RETURN;

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

1052: --FND_MESSAGE.SET_NAME('ONT','OE_COGS_SALESREP_NOT_FOUND');
1053: --FND_MESSAGE.SET_TOKEN('LINEID',l_order_line_id);
1054: --fb_error_msg := FND_MESSAGE.GET_ENCODED;
1055: --FND_MESSAGE.SET_ENCODED(fb_error_msg);
1056: --l_error_msg := FND_MESSAGE.GET;
1057: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE','No line type id found in oe_order_lines_all');
1058: result := 'COMPLETE:FAILURE';
1059: RETURN;
1060:

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

1188:
1189: EXCEPTION
1190:
1191: WHEN NO_DATA_FOUND THEN
1192: FND_MESSAGE.SET_NAME('ONT','OE_COGS_SALESREP_NOT_FOUND');
1193: FND_MESSAGE.SET_TOKEN('LINEID',l_order_line_id);
1194: fb_error_msg := FND_MESSAGE.GET_ENCODED;
1195: FND_MESSAGE.SET_ENCODED(fb_error_msg);
1196: l_error_msg := FND_MESSAGE.GET;

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

1189: EXCEPTION
1190:
1191: WHEN NO_DATA_FOUND THEN
1192: FND_MESSAGE.SET_NAME('ONT','OE_COGS_SALESREP_NOT_FOUND');
1193: FND_MESSAGE.SET_TOKEN('LINEID',l_order_line_id);
1194: fb_error_msg := FND_MESSAGE.GET_ENCODED;
1195: FND_MESSAGE.SET_ENCODED(fb_error_msg);
1196: l_error_msg := FND_MESSAGE.GET;
1197: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',l_error_msg);

Line 1194: fb_error_msg := FND_MESSAGE.GET_ENCODED;

1190:
1191: WHEN NO_DATA_FOUND THEN
1192: FND_MESSAGE.SET_NAME('ONT','OE_COGS_SALESREP_NOT_FOUND');
1193: FND_MESSAGE.SET_TOKEN('LINEID',l_order_line_id);
1194: fb_error_msg := FND_MESSAGE.GET_ENCODED;
1195: FND_MESSAGE.SET_ENCODED(fb_error_msg);
1196: l_error_msg := FND_MESSAGE.GET;
1197: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',l_error_msg);
1198: result := 'COMPLETE:FAILURE';

Line 1195: FND_MESSAGE.SET_ENCODED(fb_error_msg);

1191: WHEN NO_DATA_FOUND THEN
1192: FND_MESSAGE.SET_NAME('ONT','OE_COGS_SALESREP_NOT_FOUND');
1193: FND_MESSAGE.SET_TOKEN('LINEID',l_order_line_id);
1194: fb_error_msg := FND_MESSAGE.GET_ENCODED;
1195: FND_MESSAGE.SET_ENCODED(fb_error_msg);
1196: l_error_msg := FND_MESSAGE.GET;
1197: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',l_error_msg);
1198: result := 'COMPLETE:FAILURE';
1199: RETURN;

Line 1196: l_error_msg := FND_MESSAGE.GET;

1192: FND_MESSAGE.SET_NAME('ONT','OE_COGS_SALESREP_NOT_FOUND');
1193: FND_MESSAGE.SET_TOKEN('LINEID',l_order_line_id);
1194: fb_error_msg := FND_MESSAGE.GET_ENCODED;
1195: FND_MESSAGE.SET_ENCODED(fb_error_msg);
1196: l_error_msg := FND_MESSAGE.GET;
1197: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',l_error_msg);
1198: result := 'COMPLETE:FAILURE';
1199: RETURN;
1200: END;

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

1277: WHERE INVENTORY_ITEM_ID = l_inv_item_id
1278: AND ORGANIZATION_ID = l_ship_from_org_id;
1279: EXCEPTION
1280: WHEN NO_DATA_FOUND THEN
1281: FND_MESSAGE.SET_NAME('ONT','OE_COGS_CCID_GEN_FAILED');
1282: FND_MESSAGE.SET_TOKEN('PARAM1','Inventory Item id');
1283: FND_MESSAGE.SET_TOKEN('PARAM2','/Warehouse ');
1284: FND_MESSAGE.SET_TOKEN('VALUE1',l_inv_item_id);
1285: FND_MESSAGE.SET_TOKEN('VALUE2',l_ship_from_org_id);

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

1278: AND ORGANIZATION_ID = l_ship_from_org_id;
1279: EXCEPTION
1280: WHEN NO_DATA_FOUND THEN
1281: FND_MESSAGE.SET_NAME('ONT','OE_COGS_CCID_GEN_FAILED');
1282: FND_MESSAGE.SET_TOKEN('PARAM1','Inventory Item id');
1283: FND_MESSAGE.SET_TOKEN('PARAM2','/Warehouse ');
1284: FND_MESSAGE.SET_TOKEN('VALUE1',l_inv_item_id);
1285: FND_MESSAGE.SET_TOKEN('VALUE2',l_ship_from_org_id);
1286: fb_error_msg := FND_MESSAGE.GET_ENCODED;

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

1279: EXCEPTION
1280: WHEN NO_DATA_FOUND THEN
1281: FND_MESSAGE.SET_NAME('ONT','OE_COGS_CCID_GEN_FAILED');
1282: FND_MESSAGE.SET_TOKEN('PARAM1','Inventory Item id');
1283: FND_MESSAGE.SET_TOKEN('PARAM2','/Warehouse ');
1284: FND_MESSAGE.SET_TOKEN('VALUE1',l_inv_item_id);
1285: FND_MESSAGE.SET_TOKEN('VALUE2',l_ship_from_org_id);
1286: fb_error_msg := FND_MESSAGE.GET_ENCODED;
1287: FND_MESSAGE.SET_ENCODED(fb_error_msg);

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

1280: WHEN NO_DATA_FOUND THEN
1281: FND_MESSAGE.SET_NAME('ONT','OE_COGS_CCID_GEN_FAILED');
1282: FND_MESSAGE.SET_TOKEN('PARAM1','Inventory Item id');
1283: FND_MESSAGE.SET_TOKEN('PARAM2','/Warehouse ');
1284: FND_MESSAGE.SET_TOKEN('VALUE1',l_inv_item_id);
1285: FND_MESSAGE.SET_TOKEN('VALUE2',l_ship_from_org_id);
1286: fb_error_msg := FND_MESSAGE.GET_ENCODED;
1287: FND_MESSAGE.SET_ENCODED(fb_error_msg);
1288: l_error_msg := FND_MESSAGE.GET;

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

1281: FND_MESSAGE.SET_NAME('ONT','OE_COGS_CCID_GEN_FAILED');
1282: FND_MESSAGE.SET_TOKEN('PARAM1','Inventory Item id');
1283: FND_MESSAGE.SET_TOKEN('PARAM2','/Warehouse ');
1284: FND_MESSAGE.SET_TOKEN('VALUE1',l_inv_item_id);
1285: FND_MESSAGE.SET_TOKEN('VALUE2',l_ship_from_org_id);
1286: fb_error_msg := FND_MESSAGE.GET_ENCODED;
1287: FND_MESSAGE.SET_ENCODED(fb_error_msg);
1288: l_error_msg := FND_MESSAGE.GET;
1289: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',l_error_msg);

Line 1286: fb_error_msg := FND_MESSAGE.GET_ENCODED;

1282: FND_MESSAGE.SET_TOKEN('PARAM1','Inventory Item id');
1283: FND_MESSAGE.SET_TOKEN('PARAM2','/Warehouse ');
1284: FND_MESSAGE.SET_TOKEN('VALUE1',l_inv_item_id);
1285: FND_MESSAGE.SET_TOKEN('VALUE2',l_ship_from_org_id);
1286: fb_error_msg := FND_MESSAGE.GET_ENCODED;
1287: FND_MESSAGE.SET_ENCODED(fb_error_msg);
1288: l_error_msg := FND_MESSAGE.GET;
1289: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',l_error_msg);
1290: result := 'COMPLETE:FAILURE';

Line 1287: FND_MESSAGE.SET_ENCODED(fb_error_msg);

1283: FND_MESSAGE.SET_TOKEN('PARAM2','/Warehouse ');
1284: FND_MESSAGE.SET_TOKEN('VALUE1',l_inv_item_id);
1285: FND_MESSAGE.SET_TOKEN('VALUE2',l_ship_from_org_id);
1286: fb_error_msg := FND_MESSAGE.GET_ENCODED;
1287: FND_MESSAGE.SET_ENCODED(fb_error_msg);
1288: l_error_msg := FND_MESSAGE.GET;
1289: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',l_error_msg);
1290: result := 'COMPLETE:FAILURE';
1291: RETURN;

Line 1288: l_error_msg := FND_MESSAGE.GET;

1284: FND_MESSAGE.SET_TOKEN('VALUE1',l_inv_item_id);
1285: FND_MESSAGE.SET_TOKEN('VALUE2',l_ship_from_org_id);
1286: fb_error_msg := FND_MESSAGE.GET_ENCODED;
1287: FND_MESSAGE.SET_ENCODED(fb_error_msg);
1288: l_error_msg := FND_MESSAGE.GET;
1289: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',l_error_msg);
1290: result := 'COMPLETE:FAILURE';
1291: RETURN;
1292: END;

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

1292: END;
1293:
1294: IF l_account_derived = 0 THEN
1295:
1296: FND_MESSAGE.SET_NAME('ONT','OE_COGS_CCID_GEN_FAILED');
1297: FND_MESSAGE.SET_TOKEN('PARAM1','Inventory Item id');
1298: FND_MESSAGE.SET_TOKEN('PARAM2','/Warehouse ');
1299: FND_MESSAGE.SET_TOKEN('VALUE1',l_inv_item_id);
1300: FND_MESSAGE.SET_TOKEN('VALUE2',l_ship_from_org_id);

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

1293:
1294: IF l_account_derived = 0 THEN
1295:
1296: FND_MESSAGE.SET_NAME('ONT','OE_COGS_CCID_GEN_FAILED');
1297: FND_MESSAGE.SET_TOKEN('PARAM1','Inventory Item id');
1298: FND_MESSAGE.SET_TOKEN('PARAM2','/Warehouse ');
1299: FND_MESSAGE.SET_TOKEN('VALUE1',l_inv_item_id);
1300: FND_MESSAGE.SET_TOKEN('VALUE2',l_ship_from_org_id);
1301:

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

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

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

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

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

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

Line 1302: fb_error_msg := FND_MESSAGE.GET_ENCODED;

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

Line 1303: FND_MESSAGE.SET_ENCODED(fb_error_msg);

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

Line 1304: l_error_msg := FND_MESSAGE.GET;

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

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

1441: AND TRX.ORG_ID = TYPE.ORG_ID
1442: AND TRX.CUST_TRX_TYPE_ID = TYPE.CUST_TRX_TYPE_ID;
1443: EXCEPTION
1444: WHEN NO_DATA_FOUND THEN
1445: FND_MESSAGE.SET_NAME('ONT','OE_COGS_TRX_TYPE_NOT_FOUND');
1446: FND_MESSAGE.SET_TOKEN('COMMITMENTID',l_commitment_id);
1447: fb_error_msg := FND_MESSAGE.GET_ENCODED;
1448: FND_MESSAGE.SET_ENCODED(fb_error_msg);
1449: l_error_msg := FND_MESSAGE.GET;

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

1442: AND TRX.CUST_TRX_TYPE_ID = TYPE.CUST_TRX_TYPE_ID;
1443: EXCEPTION
1444: WHEN NO_DATA_FOUND THEN
1445: FND_MESSAGE.SET_NAME('ONT','OE_COGS_TRX_TYPE_NOT_FOUND');
1446: FND_MESSAGE.SET_TOKEN('COMMITMENTID',l_commitment_id);
1447: fb_error_msg := FND_MESSAGE.GET_ENCODED;
1448: FND_MESSAGE.SET_ENCODED(fb_error_msg);
1449: l_error_msg := FND_MESSAGE.GET;
1450: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',l_error_msg);

Line 1447: fb_error_msg := FND_MESSAGE.GET_ENCODED;

1443: EXCEPTION
1444: WHEN NO_DATA_FOUND THEN
1445: FND_MESSAGE.SET_NAME('ONT','OE_COGS_TRX_TYPE_NOT_FOUND');
1446: FND_MESSAGE.SET_TOKEN('COMMITMENTID',l_commitment_id);
1447: fb_error_msg := FND_MESSAGE.GET_ENCODED;
1448: FND_MESSAGE.SET_ENCODED(fb_error_msg);
1449: l_error_msg := FND_MESSAGE.GET;
1450: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',l_error_msg);
1451: result := 'COMPLETE:FAILURE';

Line 1448: FND_MESSAGE.SET_ENCODED(fb_error_msg);

1444: WHEN NO_DATA_FOUND THEN
1445: FND_MESSAGE.SET_NAME('ONT','OE_COGS_TRX_TYPE_NOT_FOUND');
1446: FND_MESSAGE.SET_TOKEN('COMMITMENTID',l_commitment_id);
1447: fb_error_msg := FND_MESSAGE.GET_ENCODED;
1448: FND_MESSAGE.SET_ENCODED(fb_error_msg);
1449: l_error_msg := FND_MESSAGE.GET;
1450: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',l_error_msg);
1451: result := 'COMPLETE:FAILURE';
1452: RETURN;

Line 1449: l_error_msg := FND_MESSAGE.GET;

1445: FND_MESSAGE.SET_NAME('ONT','OE_COGS_TRX_TYPE_NOT_FOUND');
1446: FND_MESSAGE.SET_TOKEN('COMMITMENTID',l_commitment_id);
1447: fb_error_msg := FND_MESSAGE.GET_ENCODED;
1448: FND_MESSAGE.SET_ENCODED(fb_error_msg);
1449: l_error_msg := FND_MESSAGE.GET;
1450: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',l_error_msg);
1451: result := 'COMPLETE:FAILURE';
1452: RETURN;
1453: END;

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

1515: oe_debug_pub.add('Entering OE_FLEX_COGS_PUB.BUILD',2);
1516: END IF;
1517: fb_flex_seg := NULL;
1518:
1519: FND_MESSAGE.SET_NAME('FND', 'FLEXWK-UPGRADE FUNC MISSING');
1520: FND_MESSAGE.SET_TOKEN('FUNC','OE_INVENTORY_INTERFACE');
1521: FB_ERROR_MSG := FND_MESSAGE.GET_ENCODED;
1522: RETURN FALSE;
1523: END Build;

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

1516: END IF;
1517: fb_flex_seg := NULL;
1518:
1519: FND_MESSAGE.SET_NAME('FND', 'FLEXWK-UPGRADE FUNC MISSING');
1520: FND_MESSAGE.SET_TOKEN('FUNC','OE_INVENTORY_INTERFACE');
1521: FB_ERROR_MSG := FND_MESSAGE.GET_ENCODED;
1522: RETURN FALSE;
1523: END Build;
1524:

Line 1521: FB_ERROR_MSG := FND_MESSAGE.GET_ENCODED;

1517: fb_flex_seg := NULL;
1518:
1519: FND_MESSAGE.SET_NAME('FND', 'FLEXWK-UPGRADE FUNC MISSING');
1520: FND_MESSAGE.SET_TOKEN('FUNC','OE_INVENTORY_INTERFACE');
1521: FB_ERROR_MSG := FND_MESSAGE.GET_ENCODED;
1522: RETURN FALSE;
1523: END Build;
1524:
1525: