112: -- Error getting combination id.
113: -- Function has already pushed a message on the stack. Add to
114: -- the API message list.
115:
116: FND_MSG_PUB.Add;
117: l_id := FND_API.G_MISS_NUM;
118:
119: END IF;
120:
123: EXCEPTION
124:
125: WHEN OTHERS THEN
126:
127: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
128: THEN
129: FND_MSG_PUB.Add_Exc_Msg
130: ( G_PKG_NAME
131: , 'Key_Flex'
125: WHEN OTHERS THEN
126:
127: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
128: THEN
129: FND_MSG_PUB.Add_Exc_Msg
130: ( G_PKG_NAME
131: , 'Key_Flex'
132: );
133: END IF;
180: EXCEPTION
181:
182: WHEN NO_DATA_FOUND THEN
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');
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:
193: RETURN FND_API.G_MISS_NUM;
193: RETURN FND_API.G_MISS_NUM;
194:
195: WHEN OTHERS THEN
196:
197: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
198: THEN
199: FND_MSG_PUB.Add_Exc_Msg
200: ( G_PKG_NAME
201: , 'Header'
195: WHEN OTHERS THEN
196:
197: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
198: THEN
199: FND_MSG_PUB.Add_Exc_Msg
200: ( G_PKG_NAME
201: , 'Header'
202: );
203: END IF;
232: EXCEPTION
233:
234: WHEN NO_DATA_FOUND THEN
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');
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:
245: RETURN FND_API.G_MISS_NUM;
245: RETURN FND_API.G_MISS_NUM;
246:
247: WHEN OTHERS THEN
248:
249: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
250: THEN
251: FND_MSG_PUB.Add_Exc_Msg
252: ( G_PKG_NAME
253: , 'Organization'
247: WHEN OTHERS THEN
248:
249: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
250: THEN
251: FND_MSG_PUB.Add_Exc_Msg
252: ( G_PKG_NAME
253: , 'Organization'
254: );
255: END IF;
282: EXCEPTION
283:
284: WHEN NO_DATA_FOUND THEN
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');
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:
295: RETURN FND_API.G_MISS_NUM;
295: RETURN FND_API.G_MISS_NUM;
296:
297: WHEN OTHERS THEN
298:
299: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
300: THEN
301: FND_MSG_PUB.Add_Exc_Msg
302: ( G_PKG_NAME
303: , 'TO_Organization'
297: WHEN OTHERS THEN
298:
299: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
300: THEN
301: FND_MSG_PUB.Add_Exc_Msg
302: ( G_PKG_NAME
303: , 'TO_Organization'
304: );
305: END IF;
348: RETURN l_id;
349:
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;
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
360: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
356: FND_MSG_PUB.Add;
357: END IF;
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;
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
368: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
364: FND_MSG_PUB.Add;
365: END IF;
366: RETURN FND_API.G_MISS_NUM;
367: WHEN OTHERS THEN
368: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
369: THEN
370: FND_MSG_PUB.Add_Exc_Msg
371: ( G_PKG_NAME
372: , 'To_Account'
366: RETURN FND_API.G_MISS_NUM;
367: WHEN OTHERS THEN
368: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
369: THEN
370: FND_MSG_PUB.Add_Exc_Msg
371: ( G_PKG_NAME
372: , 'To_Account'
373: );
374: END IF;
416: EXCEPTION
417:
418: WHEN NO_DATA_FOUND 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');
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:
429: RETURN FND_API.G_MISS_NUM;
429: RETURN FND_API.G_MISS_NUM;
430:
431: WHEN OTHERS THEN
432:
433: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
434: THEN
435: FND_MSG_PUB.Add_Exc_Msg
436: ( G_PKG_NAME
437: , 'Transaction_Type'
431: WHEN OTHERS THEN
432:
433: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
434: THEN
435: FND_MSG_PUB.Add_Exc_Msg
436: ( G_PKG_NAME
437: , 'Transaction_Type'
438: );
439: END IF;
467: EXCEPTION
468:
469: WHEN NO_DATA_FOUND THEN
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');
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:
480: RETURN FND_API.G_MISS_NUM;
480: RETURN FND_API.G_MISS_NUM;
481:
482: WHEN OTHERS THEN
483:
484: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
485: THEN
486: FND_MSG_PUB.Add_Exc_Msg
487: ( G_PKG_NAME
488: , 'Move_Order_Type'
482: WHEN OTHERS THEN
483:
484: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
485: THEN
486: FND_MSG_PUB.Add_Exc_Msg
487: ( G_PKG_NAME
488: , 'Move_Order_Type'
489: );
490: END IF;
521: EXCEPTION
522:
523: WHEN NO_DATA_FOUND THEN
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');
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:
534: RETURN FND_API.G_MISS_NUM;
534: RETURN FND_API.G_MISS_NUM;
535:
536: WHEN OTHERS THEN
537:
538: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
539: THEN
540: FND_MSG_PUB.Add_Exc_Msg
541: ( G_PKG_NAME
542: , 'From_Locator'
536: WHEN OTHERS THEN
537:
538: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
539: THEN
540: FND_MSG_PUB.Add_Exc_Msg
541: ( G_PKG_NAME
542: , 'From_Locator'
543: );
544: END IF;
574: EXCEPTION
575:
576: WHEN NO_DATA_FOUND THEN
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');
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:
587: RETURN FND_API.G_MISS_NUM;
587: RETURN FND_API.G_MISS_NUM;
588:
589: WHEN OTHERS THEN
590:
591: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
592: THEN
593: FND_MSG_PUB.Add_Exc_Msg
594: ( G_PKG_NAME
595: , 'Inventory_Item'
589: WHEN OTHERS THEN
590:
591: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
592: THEN
593: FND_MSG_PUB.Add_Exc_Msg
594: ( G_PKG_NAME
595: , 'Inventory_Item'
596: );
597: END IF;
625: EXCEPTION
626:
627: WHEN NO_DATA_FOUND THEN
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');
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:
638: RETURN FND_API.G_MISS_NUM;
638: RETURN FND_API.G_MISS_NUM;
639:
640: WHEN OTHERS THEN
641:
642: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
643: THEN
644: FND_MSG_PUB.Add_Exc_Msg
645: ( G_PKG_NAME
646: , 'Line'
640: WHEN OTHERS THEN
641:
642: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
643: THEN
644: FND_MSG_PUB.Add_Exc_Msg
645: ( G_PKG_NAME
646: , 'Line'
647: );
648: END IF;
676: EXCEPTION
677:
678: WHEN NO_DATA_FOUND THEN
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');
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:
689: RETURN FND_API.G_MISS_NUM;
689: RETURN FND_API.G_MISS_NUM;
690:
691: WHEN OTHERS THEN
692:
693: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
694: THEN
695: FND_MSG_PUB.Add_Exc_Msg
696: ( G_PKG_NAME
697: , 'Project'
691: WHEN OTHERS THEN
692:
693: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
694: THEN
695: FND_MSG_PUB.Add_Exc_Msg
696: ( G_PKG_NAME
697: , 'Project'
698: );
699: END IF;
727: EXCEPTION
728:
729: WHEN NO_DATA_FOUND THEN
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');
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:
740: RETURN FND_API.G_MISS_NUM;
740: RETURN FND_API.G_MISS_NUM;
741:
742: WHEN OTHERS THEN
743:
744: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
745: THEN
746: FND_MSG_PUB.Add_Exc_Msg
747: ( G_PKG_NAME
748: , 'Reason'
742: WHEN OTHERS THEN
743:
744: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
745: THEN
746: FND_MSG_PUB.Add_Exc_Msg
747: ( G_PKG_NAME
748: , 'Reason'
749: );
750: END IF;
778: EXCEPTION
779:
780: WHEN NO_DATA_FOUND THEN
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');
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:
791: RETURN FND_API.G_MISS_NUM;
791: RETURN FND_API.G_MISS_NUM;
792:
793: WHEN OTHERS THEN
794:
795: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
796: THEN
797: FND_MSG_PUB.Add_Exc_Msg
798: ( G_PKG_NAME
799: , 'Reference'
793: WHEN OTHERS THEN
794:
795: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
796: THEN
797: FND_MSG_PUB.Add_Exc_Msg
798: ( G_PKG_NAME
799: , 'Reference'
800: );
801: END IF;
829: EXCEPTION
830:
831: WHEN NO_DATA_FOUND THEN
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');
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:
842: RETURN FND_API.G_MISS_NUM;
842: RETURN FND_API.G_MISS_NUM;
843:
844: WHEN OTHERS THEN
845:
846: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
847: THEN
848: FND_MSG_PUB.Add_Exc_Msg
849: ( G_PKG_NAME
850: , 'Reference_Type'
844: WHEN OTHERS THEN
845:
846: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
847: THEN
848: FND_MSG_PUB.Add_Exc_Msg
849: ( G_PKG_NAME
850: , 'Reference_Type'
851: );
852: END IF;
880: EXCEPTION
881:
882: WHEN NO_DATA_FOUND THEN
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');
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:
893: RETURN FND_API.G_MISS_NUM;
893: RETURN FND_API.G_MISS_NUM;
894:
895: WHEN OTHERS THEN
896:
897: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
898: THEN
899: FND_MSG_PUB.Add_Exc_Msg
900: ( G_PKG_NAME
901: , 'Task'
895: WHEN OTHERS THEN
896:
897: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
898: THEN
899: FND_MSG_PUB.Add_Exc_Msg
900: ( G_PKG_NAME
901: , 'Task'
902: );
903: END IF;
933: EXCEPTION
934:
935: WHEN NO_DATA_FOUND THEN
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');
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:
946: RETURN FND_API.G_MISS_NUM;
946: RETURN FND_API.G_MISS_NUM;
947:
948: WHEN OTHERS THEN
949:
950: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
951: THEN
952: FND_MSG_PUB.Add_Exc_Msg
953: ( G_PKG_NAME
954: , 'To_Locator'
948: WHEN OTHERS THEN
949:
950: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
951: THEN
952: FND_MSG_PUB.Add_Exc_Msg
953: ( G_PKG_NAME
954: , 'To_Locator'
955: );
956: END IF;
984: EXCEPTION
985:
986: WHEN NO_DATA_FOUND THEN
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');
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:
997: RETURN FND_API.G_MISS_NUM;
997: RETURN FND_API.G_MISS_NUM;
998:
999: WHEN OTHERS THEN
1000:
1001: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1002: THEN
1003: FND_MSG_PUB.Add_Exc_Msg
1004: ( G_PKG_NAME
1005: , 'Transaction_Header'
999: WHEN OTHERS THEN
1000:
1001: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1002: THEN
1003: FND_MSG_PUB.Add_Exc_Msg
1004: ( G_PKG_NAME
1005: , 'Transaction_Header'
1006: );
1007: END IF;
1035: EXCEPTION
1036:
1037: WHEN NO_DATA_FOUND THEN
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');
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:
1048: RETURN FND_API.G_MISS_CHAR;
1048: RETURN FND_API.G_MISS_CHAR;
1049:
1050: WHEN OTHERS THEN
1051:
1052: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1053: THEN
1054: FND_MSG_PUB.Add_Exc_Msg
1055: ( G_PKG_NAME
1056: , 'Uom'
1050: WHEN OTHERS THEN
1051:
1052: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1053: THEN
1054: FND_MSG_PUB.Add_Exc_Msg
1055: ( G_PKG_NAME
1056: , 'Uom'
1057: );
1058: END IF;