183:
184: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
185: THEN
186:
187: FND_MESSAGE.SET_NAME('INV','INV_VALUE_TO_ID_ERROR');
188: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','header_id');
189: FND_MSG_PUB.Add;
190:
191: END IF;
184: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
185: THEN
186:
187: FND_MESSAGE.SET_NAME('INV','INV_VALUE_TO_ID_ERROR');
188: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','header_id');
189: FND_MSG_PUB.Add;
190:
191: END IF;
192:
235:
236: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
237: THEN
238:
239: FND_MESSAGE.SET_NAME('INV','INV_VALUE_TO_ID_ERROR');
240: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','organization_id');
241: FND_MSG_PUB.Add;
242:
243: END IF;
236: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
237: THEN
238:
239: FND_MESSAGE.SET_NAME('INV','INV_VALUE_TO_ID_ERROR');
240: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','organization_id');
241: FND_MSG_PUB.Add;
242:
243: END IF;
244:
285:
286: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
287: THEN
288:
289: FND_MESSAGE.SET_NAME('INV','INV_VALUE_TO_ID_ERROR');
290: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','to_organization_id');
291: FND_MSG_PUB.Add;
292:
293: END IF;
286: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
287: THEN
288:
289: FND_MESSAGE.SET_NAME('INV','INV_VALUE_TO_ID_ERROR');
290: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','to_organization_id');
291: FND_MSG_PUB.Add;
292:
293: END IF;
294:
350: EXCEPTION
351: WHEN NO_DATA_FOUND THEN
352: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
353: THEN
354: FND_MESSAGE.SET_NAME('INV','INV_VALUE_TO_ID_ERROR');
355: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','to_account_id'|| p_to_account);
356: FND_MSG_PUB.Add;
357: END IF;
358: RETURN FND_API.G_MISS_NUM;
351: WHEN NO_DATA_FOUND THEN
352: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
353: THEN
354: FND_MESSAGE.SET_NAME('INV','INV_VALUE_TO_ID_ERROR');
355: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','to_account_id'|| p_to_account);
356: FND_MSG_PUB.Add;
357: END IF;
358: RETURN FND_API.G_MISS_NUM;
359: WHEN fnd_api.g_exc_error THEN
358: RETURN FND_API.G_MISS_NUM;
359: WHEN fnd_api.g_exc_error THEN
360: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
361: THEN
362: FND_MESSAGE.SET_NAME('INV','INV_VALUE_TO_ID_ERROR');
363: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','to_account_id'|| p_to_account);
364: FND_MSG_PUB.Add;
365: END IF;
366: RETURN FND_API.G_MISS_NUM;
359: WHEN fnd_api.g_exc_error THEN
360: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
361: THEN
362: FND_MESSAGE.SET_NAME('INV','INV_VALUE_TO_ID_ERROR');
363: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','to_account_id'|| p_to_account);
364: FND_MSG_PUB.Add;
365: END IF;
366: RETURN FND_API.G_MISS_NUM;
367: WHEN OTHERS THEN
419:
420: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
421: THEN
422:
423: FND_MESSAGE.SET_NAME('INV','INV_VALUE_TO_ID_ERROR');
424: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','transaction_type_id');
425: FND_MSG_PUB.Add;
426:
427: END IF;
420: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
421: THEN
422:
423: FND_MESSAGE.SET_NAME('INV','INV_VALUE_TO_ID_ERROR');
424: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','transaction_type_id');
425: FND_MSG_PUB.Add;
426:
427: END IF;
428:
470:
471: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
472: THEN
473:
474: FND_MESSAGE.SET_NAME('INV','INV_VALUE_TO_ID_ERROR');
475: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','move_order_type');
476: FND_MSG_PUB.Add;
477:
478: END IF;
471: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
472: THEN
473:
474: FND_MESSAGE.SET_NAME('INV','INV_VALUE_TO_ID_ERROR');
475: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','move_order_type');
476: FND_MSG_PUB.Add;
477:
478: END IF;
479:
524:
525: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
526: THEN
527:
528: FND_MESSAGE.SET_NAME('INV','INV_VALUE_TO_ID_ERROR');
529: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','from_locator_id');
530: FND_MSG_PUB.Add;
531:
532: END IF;
525: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
526: THEN
527:
528: FND_MESSAGE.SET_NAME('INV','INV_VALUE_TO_ID_ERROR');
529: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','from_locator_id');
530: FND_MSG_PUB.Add;
531:
532: END IF;
533:
577:
578: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
579: THEN
580:
581: FND_MESSAGE.SET_NAME('INV','INV_VALUE_TO_ID_ERROR');
582: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','inventory_item_id');
583: FND_MSG_PUB.Add;
584:
585: END IF;
578: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
579: THEN
580:
581: FND_MESSAGE.SET_NAME('INV','INV_VALUE_TO_ID_ERROR');
582: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','inventory_item_id');
583: FND_MSG_PUB.Add;
584:
585: END IF;
586:
628:
629: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
630: THEN
631:
632: FND_MESSAGE.SET_NAME('INV','INV_VALUE_TO_ID_ERROR');
633: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','line_id');
634: FND_MSG_PUB.Add;
635:
636: END IF;
629: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
630: THEN
631:
632: FND_MESSAGE.SET_NAME('INV','INV_VALUE_TO_ID_ERROR');
633: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','line_id');
634: FND_MSG_PUB.Add;
635:
636: END IF;
637:
679:
680: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
681: THEN
682:
683: FND_MESSAGE.SET_NAME('INV','INV_VALUE_TO_ID_ERROR');
684: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','project_id');
685: FND_MSG_PUB.Add;
686:
687: END IF;
680: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
681: THEN
682:
683: FND_MESSAGE.SET_NAME('INV','INV_VALUE_TO_ID_ERROR');
684: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','project_id');
685: FND_MSG_PUB.Add;
686:
687: END IF;
688:
730:
731: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
732: THEN
733:
734: FND_MESSAGE.SET_NAME('INV','INV_VALUE_TO_ID_ERROR');
735: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','reason_id');
736: FND_MSG_PUB.Add;
737:
738: END IF;
731: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
732: THEN
733:
734: FND_MESSAGE.SET_NAME('INV','INV_VALUE_TO_ID_ERROR');
735: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','reason_id');
736: FND_MSG_PUB.Add;
737:
738: END IF;
739:
781:
782: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
783: THEN
784:
785: FND_MESSAGE.SET_NAME('INV','INV_VALUE_TO_ID_ERROR');
786: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','reference_id');
787: FND_MSG_PUB.Add;
788:
789: END IF;
782: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
783: THEN
784:
785: FND_MESSAGE.SET_NAME('INV','INV_VALUE_TO_ID_ERROR');
786: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','reference_id');
787: FND_MSG_PUB.Add;
788:
789: END IF;
790:
832:
833: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
834: THEN
835:
836: FND_MESSAGE.SET_NAME('INV','INV_VALUE_TO_ID_ERROR');
837: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','reference_type_code');
838: FND_MSG_PUB.Add;
839:
840: END IF;
833: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
834: THEN
835:
836: FND_MESSAGE.SET_NAME('INV','INV_VALUE_TO_ID_ERROR');
837: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','reference_type_code');
838: FND_MSG_PUB.Add;
839:
840: END IF;
841:
883:
884: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
885: THEN
886:
887: FND_MESSAGE.SET_NAME('INV','INV_VALUE_TO_ID_ERROR');
888: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','task_id');
889: FND_MSG_PUB.Add;
890:
891: END IF;
884: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
885: THEN
886:
887: FND_MESSAGE.SET_NAME('INV','INV_VALUE_TO_ID_ERROR');
888: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','task_id');
889: FND_MSG_PUB.Add;
890:
891: END IF;
892:
936:
937: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
938: THEN
939:
940: FND_MESSAGE.SET_NAME('INV','INV_VALUE_TO_ID_ERROR');
941: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','to_locator_id');
942: FND_MSG_PUB.Add;
943:
944: END IF;
937: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
938: THEN
939:
940: FND_MESSAGE.SET_NAME('INV','INV_VALUE_TO_ID_ERROR');
941: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','to_locator_id');
942: FND_MSG_PUB.Add;
943:
944: END IF;
945:
987:
988: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
989: THEN
990:
991: FND_MESSAGE.SET_NAME('INV','INV_VALUE_TO_ID_ERROR');
992: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','transaction_header_id');
993: FND_MSG_PUB.Add;
994:
995: END IF;
988: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
989: THEN
990:
991: FND_MESSAGE.SET_NAME('INV','INV_VALUE_TO_ID_ERROR');
992: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','transaction_header_id');
993: FND_MSG_PUB.Add;
994:
995: END IF;
996:
1038:
1039: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1040: THEN
1041:
1042: FND_MESSAGE.SET_NAME('INV','INV_VALUE_TO_ID_ERROR');
1043: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','uom_code');
1044: FND_MSG_PUB.Add;
1045:
1046: END IF;
1039: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1040: THEN
1041:
1042: FND_MESSAGE.SET_NAME('INV','INV_VALUE_TO_ID_ERROR');
1043: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','uom_code');
1044: FND_MSG_PUB.Add;
1045:
1046: END IF;
1047: