[Home] [Help]
275: EXCEPTION
276:
277: WHEN NO_DATA_FOUND THEN
278:
279: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
280: THEN
281:
282: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
283: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','accounting_rule');
280: THEN
281:
282: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
283: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','accounting_rule');
284: OE_MSG_PUB.Add;
285:
286: END IF;
287:
288: RETURN NULL;
288: RETURN NULL;
289:
290: WHEN OTHERS THEN
291:
292: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
293: THEN
294: OE_MSG_PUB.Add_Exc_Msg
295: ( G_PKG_NAME
296: , 'Accounting_Rule'
290: WHEN OTHERS THEN
291:
292: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
293: THEN
294: OE_MSG_PUB.Add_Exc_Msg
295: ( G_PKG_NAME
296: , 'Accounting_Rule'
297: );
298: END IF;
335: EXCEPTION
336:
337: WHEN NO_DATA_FOUND THEN
338:
339: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
340: THEN
341:
342: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
343: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','calculate_price_flag');
340: THEN
341:
342: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
343: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','calculate_price_flag');
344: OE_MSG_PUB.Add;
345:
346: END IF;
347:
348: RETURN NULL;
348: RETURN NULL;
349:
350: WHEN OTHERS THEN
351:
352: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
353: THEN
354: OE_MSG_PUB.Add_Exc_Msg
355: ( G_PKG_NAME
356: , 'calculate_price_flag'
350: WHEN OTHERS THEN
351:
352: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
353: THEN
354: OE_MSG_PUB.Add_Exc_Msg
355: ( G_PKG_NAME
356: , 'calculate_price_flag'
357: );
358: END IF;
393: EXCEPTION
394:
395: WHEN NO_DATA_FOUND THEN
396:
397: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
398: THEN
399:
400: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
401: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','agreement');
398: THEN
399:
400: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
401: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','agreement');
402: OE_MSG_PUB.Add;
403:
404: END IF;
405:
406: RETURN NULL;
406: RETURN NULL;
407:
408: WHEN OTHERS THEN
409:
410: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
411: THEN
412: OE_MSG_PUB.Add_Exc_Msg
413: ( G_PKG_NAME
414: , 'Agreement'
408: WHEN OTHERS THEN
409:
410: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
411: THEN
412: OE_MSG_PUB.Add_Exc_Msg
413: ( G_PKG_NAME
414: , 'Agreement'
415: );
416: END IF;
443: EXCEPTION
444:
445: WHEN NO_DATA_FOUND THEN
446:
447: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
448: THEN
449:
450: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
451: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','conversion_type');
448: THEN
449:
450: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
451: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','conversion_type');
452: OE_MSG_PUB.Add;
453:
454: END IF;
455:
456: RETURN NULL;
456: RETURN NULL;
457:
458: WHEN OTHERS THEN
459:
460: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
461: THEN
462: OE_MSG_PUB.Add_Exc_Msg
463: ( G_PKG_NAME
464: , 'Conversion_Type'
458: WHEN OTHERS THEN
459:
460: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
461: THEN
462: OE_MSG_PUB.Add_Exc_Msg
463: ( G_PKG_NAME
464: , 'Conversion_Type'
465: );
466: END IF;
493: EXCEPTION
494:
495: WHEN NO_DATA_FOUND THEN
496:
497: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
498: THEN
499:
500: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
501: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','deliver_to_contact');
498: THEN
499:
500: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
501: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','deliver_to_contact');
502: OE_MSG_PUB.Add;
503:
504: END IF;
505:
506: RETURN NULL;
506: RETURN NULL;
507:
508: WHEN OTHERS THEN
509:
510: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
511: THEN
512: OE_MSG_PUB.Add_Exc_Msg
513: ( G_PKG_NAME
514: , 'Deliver_To_Contact'
508: WHEN OTHERS THEN
509:
510: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
511: THEN
512: OE_MSG_PUB.Add_Exc_Msg
513: ( G_PKG_NAME
514: , 'Deliver_To_Contact'
515: );
516: END IF;
543: EXCEPTION
544:
545: WHEN NO_DATA_FOUND THEN
546:
547: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
548: THEN
549:
550: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
551: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','inventory_org');
548: THEN
549:
550: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
551: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','inventory_org');
552: OE_MSG_PUB.Add;
553:
554: END IF;
555:
556: RETURN NULL;
556: RETURN NULL;
557:
558: WHEN OTHERS THEN
559:
560: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
561: THEN
562: OE_MSG_PUB.Add_Exc_Msg
563: ( G_PKG_NAME
564: , 'inventory_org'
558: WHEN OTHERS THEN
559:
560: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
561: THEN
562: OE_MSG_PUB.Add_Exc_Msg
563: ( G_PKG_NAME
564: , 'inventory_org'
565: );
566: END IF;
642: EXCEPTION
643:
644: WHEN NO_DATA_FOUND THEN
645:
646: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
647: THEN
648:
649: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
650: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','deliver_to_org');
647: THEN
648:
649: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
650: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','deliver_to_org');
651: OE_MSG_PUB.Add;
652:
653: END IF;
654:
655:
654:
655:
656: WHEN OTHERS THEN
657:
658: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
659: THEN
660: OE_MSG_PUB.Add_Exc_Msg
661: ( G_PKG_NAME
662: , 'Deliver_To_Org'
656: WHEN OTHERS THEN
657:
658: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
659: THEN
660: OE_MSG_PUB.Add_Exc_Msg
661: ( G_PKG_NAME
662: , 'Deliver_To_Org'
663: );
664: END IF;
693: EXCEPTION
694:
695: WHEN NO_DATA_FOUND THEN
696:
697: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
698: THEN
699:
700: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
701: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','fob_point');
698: THEN
699:
700: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
701: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','fob_point');
702: OE_MSG_PUB.Add;
703:
704: END IF;
705:
706: RETURN NULL;
706: RETURN NULL;
707:
708: WHEN OTHERS THEN
709:
710: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
711: THEN
712: OE_MSG_PUB.Add_Exc_Msg
713: ( G_PKG_NAME
714: , 'Fob_Point'
708: WHEN OTHERS THEN
709:
710: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
711: THEN
712: OE_MSG_PUB.Add_Exc_Msg
713: ( G_PKG_NAME
714: , 'Fob_Point'
715: );
716: END IF;
745: EXCEPTION
746:
747: WHEN NO_DATA_FOUND THEN
748:
749: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
750: THEN
751:
752: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
753: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','freight_terms');
750: THEN
751:
752: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
753: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','freight_terms');
754: OE_MSG_PUB.Add;
755:
756: END IF;
757:
758: RETURN NULL;
758: RETURN NULL;
759:
760: WHEN OTHERS THEN
761:
762: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
763: THEN
764: OE_MSG_PUB.Add_Exc_Msg
765: ( G_PKG_NAME
766: , 'Freight_Terms'
760: WHEN OTHERS THEN
761:
762: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
763: THEN
764: OE_MSG_PUB.Add_Exc_Msg
765: ( G_PKG_NAME
766: , 'Freight_Terms'
767: );
768: END IF;
797: EXCEPTION
798:
799: WHEN NO_DATA_FOUND THEN
800:
801: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
802: THEN
803:
804: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
805: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','intermed_ship_to_contact');
802: THEN
803:
804: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
805: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','intermed_ship_to_contact');
806: OE_MSG_PUB.Add;
807:
808: END IF;
809:
810: WHEN OTHERS THEN
808: END IF;
809:
810: WHEN OTHERS THEN
811:
812: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
813: THEN
814: OE_MSG_PUB.Add_Exc_Msg
815: ( G_PKG_NAME
816: , 'Intermed_Ship_To_Contact'
810: WHEN OTHERS THEN
811:
812: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
813: THEN
814: OE_MSG_PUB.Add_Exc_Msg
815: ( G_PKG_NAME
816: , 'Intermed_Ship_To_Contact'
817: );
818: END IF;
894: EXCEPTION
895:
896: WHEN NO_DATA_FOUND THEN
897:
898: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
899: THEN
900:
901: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
902: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','intermed_ship_to_org');
899: THEN
900:
901: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
902: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','intermed_ship_to_org');
903: OE_MSG_PUB.Add;
904:
905: END IF;
906:
907:
906:
907:
908: WHEN OTHERS THEN
909:
910: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
911: THEN
912: OE_MSG_PUB.Add_Exc_Msg
913: ( G_PKG_NAME
914: , 'Intermed_Ship_To_Org'
908: WHEN OTHERS THEN
909:
910: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
911: THEN
912: OE_MSG_PUB.Add_Exc_Msg
913: ( G_PKG_NAME
914: , 'Intermed_Ship_To_Org'
915: );
916: END IF;
943: EXCEPTION
944:
945: WHEN NO_DATA_FOUND THEN
946:
947: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
948: THEN
949:
950: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
951: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','invoice_to_contact');
948: THEN
949:
950: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
951: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','invoice_to_contact');
952: OE_MSG_PUB.Add;
953:
954: END IF;
955:
956: RETURN NULL;
956: RETURN NULL;
957:
958: WHEN OTHERS THEN
959:
960: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
961: THEN
962: OE_MSG_PUB.Add_Exc_Msg
963: ( G_PKG_NAME
964: , 'Invoice_To_Contact'
958: WHEN OTHERS THEN
959:
960: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
961: THEN
962: OE_MSG_PUB.Add_Exc_Msg
963: ( G_PKG_NAME
964: , 'Invoice_To_Contact'
965: );
966: END IF;
1042: EXCEPTION
1043:
1044: WHEN NO_DATA_FOUND THEN
1045:
1046: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1047: THEN
1048:
1049: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
1050: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','invoice_to_org');
1047: THEN
1048:
1049: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
1050: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','invoice_to_org');
1051: OE_MSG_PUB.Add;
1052:
1053: END IF;
1054:
1055:
1054:
1055:
1056: WHEN OTHERS THEN
1057:
1058: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1059: THEN
1060: OE_MSG_PUB.Add_Exc_Msg
1061: ( G_PKG_NAME
1062: , 'Invoice_To_Org'
1056: WHEN OTHERS THEN
1057:
1058: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1059: THEN
1060: OE_MSG_PUB.Add_Exc_Msg
1061: ( G_PKG_NAME
1062: , 'Invoice_To_Org'
1063: );
1064: END IF;
1091: EXCEPTION
1092:
1093: WHEN NO_DATA_FOUND THEN
1094:
1095: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1096: THEN
1097:
1098: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
1099: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','invoicing_rule');
1096: THEN
1097:
1098: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
1099: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','invoicing_rule');
1100: OE_MSG_PUB.Add;
1101:
1102: END IF;
1103:
1104: RETURN NULL;
1104: RETURN NULL;
1105:
1106: WHEN OTHERS THEN
1107:
1108: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1109: THEN
1110: OE_MSG_PUB.Add_Exc_Msg
1111: ( G_PKG_NAME
1112: , 'Invoicing_Rule'
1106: WHEN OTHERS THEN
1107:
1108: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1109: THEN
1110: OE_MSG_PUB.Add_Exc_Msg
1111: ( G_PKG_NAME
1112: , 'Invoicing_Rule'
1113: );
1114: END IF;
1141: EXCEPTION
1142:
1143: WHEN NO_DATA_FOUND THEN
1144:
1145: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1146: THEN
1147:
1148: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
1149: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','order_source');
1146: THEN
1147:
1148: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
1149: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','order_source');
1150: OE_MSG_PUB.Add;
1151:
1152: END IF;
1153:
1154: RETURN NULL;
1154: RETURN NULL;
1155:
1156: WHEN OTHERS THEN
1157:
1158: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1159: THEN
1160: OE_MSG_PUB.Add_Exc_Msg
1161: ( G_PKG_NAME
1162: , 'Order_Source'
1156: WHEN OTHERS THEN
1157:
1158: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1159: THEN
1160: OE_MSG_PUB.Add_Exc_Msg
1161: ( G_PKG_NAME
1162: , 'Order_Source'
1163: );
1164: END IF;
1191: EXCEPTION
1192:
1193: WHEN NO_DATA_FOUND THEN
1194:
1195: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1196: THEN
1197:
1198: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
1199: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','order_type');
1196: THEN
1197:
1198: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
1199: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','order_type');
1200: OE_MSG_PUB.Add;
1201:
1202: END IF;
1203:
1204: RETURN NULL;
1204: RETURN NULL;
1205:
1206: WHEN OTHERS THEN
1207:
1208: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1209: THEN
1210: OE_MSG_PUB.Add_Exc_Msg
1211: ( G_PKG_NAME
1212: , 'Order_Type'
1206: WHEN OTHERS THEN
1207:
1208: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1209: THEN
1210: OE_MSG_PUB.Add_Exc_Msg
1211: ( G_PKG_NAME
1212: , 'Order_Type'
1213: );
1214: END IF;
1241: EXCEPTION
1242:
1243: WHEN NO_DATA_FOUND THEN
1244:
1245: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1246: THEN
1247:
1248: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
1249: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','payment_term');
1246: THEN
1247:
1248: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
1249: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','payment_term');
1250: OE_MSG_PUB.Add;
1251:
1252: END IF;
1253:
1254: RETURN NULL;
1254: RETURN NULL;
1255:
1256: WHEN OTHERS THEN
1257:
1258: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1259: THEN
1260: OE_MSG_PUB.Add_Exc_Msg
1261: ( G_PKG_NAME
1262: , 'Payment_Term'
1256: WHEN OTHERS THEN
1257:
1258: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1259: THEN
1260: OE_MSG_PUB.Add_Exc_Msg
1261: ( G_PKG_NAME
1262: , 'Payment_Term'
1263: );
1264: END IF;
1292: EXCEPTION
1293:
1294: WHEN NO_DATA_FOUND THEN
1295:
1296: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1297: THEN
1298:
1299: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
1300: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','price_list');
1297: THEN
1298:
1299: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
1300: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','price_list');
1301: OE_MSG_PUB.Add;
1302:
1303: END IF;
1304:
1305: RETURN NULL;
1305: RETURN NULL;
1306:
1307: WHEN OTHERS THEN
1308:
1309: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1310: THEN
1311: OE_MSG_PUB.Add_Exc_Msg
1312: ( G_PKG_NAME
1313: , 'Price_List'
1307: WHEN OTHERS THEN
1308:
1309: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1310: THEN
1311: OE_MSG_PUB.Add_Exc_Msg
1312: ( G_PKG_NAME
1313: , 'Price_List'
1314: );
1315: END IF;
1342: EXCEPTION
1343:
1344: WHEN NO_DATA_FOUND THEN
1345:
1346: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1347: THEN
1348:
1349: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
1350: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','New_Modifier_list');
1347: THEN
1348:
1349: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
1350: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','New_Modifier_list');
1351: OE_MSG_PUB.Add;
1352:
1353: END IF;
1354:
1355: RETURN NULL;
1355: RETURN NULL;
1356:
1357: WHEN OTHERS THEN
1358:
1359: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1360: THEN
1361: OE_MSG_PUB.Add_Exc_Msg
1362: ( G_PKG_NAME
1363: , 'New_Modifier_List'
1357: WHEN OTHERS THEN
1358:
1359: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1360: THEN
1361: OE_MSG_PUB.Add_Exc_Msg
1362: ( G_PKG_NAME
1363: , 'New_Modifier_List'
1364: );
1365: END IF;
1393: EXCEPTION
1394:
1395: WHEN NO_DATA_FOUND THEN
1396:
1397: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1398: THEN
1399:
1400: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
1401: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','demand_class');
1398: THEN
1399:
1400: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
1401: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','demand_class');
1402: OE_MSG_PUB.Add;
1403:
1404: END IF;
1405:
1406: RETURN NULL;
1406: RETURN NULL;
1407:
1408: WHEN OTHERS THEN
1409:
1410: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1411: THEN
1412: OE_MSG_PUB.Add_Exc_Msg
1413: ( G_PKG_NAME
1414: , 'demand_class'
1408: WHEN OTHERS THEN
1409:
1410: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1411: THEN
1412: OE_MSG_PUB.Add_Exc_Msg
1413: ( G_PKG_NAME
1414: , 'demand_class'
1415: );
1416: END IF;
1445: EXCEPTION
1446:
1447: WHEN NO_DATA_FOUND THEN
1448:
1449: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1450: THEN
1451:
1452: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
1453: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','shipment_priority');
1450: THEN
1451:
1452: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
1453: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','shipment_priority');
1454: OE_MSG_PUB.Add;
1455:
1456: END IF;
1457:
1458: RETURN NULL;
1458: RETURN NULL;
1459:
1460: WHEN OTHERS THEN
1461:
1462: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1463: THEN
1464: OE_MSG_PUB.Add_Exc_Msg
1465: ( G_PKG_NAME
1466: , 'Shipment_Priority'
1460: WHEN OTHERS THEN
1461:
1462: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1463: THEN
1464: OE_MSG_PUB.Add_Exc_Msg
1465: ( G_PKG_NAME
1466: , 'Shipment_Priority'
1467: );
1468: END IF;
1528: EXCEPTION
1529:
1530: WHEN NO_DATA_FOUND THEN
1531:
1532: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1533: THEN
1534:
1535: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
1536: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ship_from_org');
1533: THEN
1534:
1535: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
1536: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ship_from_org');
1537: OE_MSG_PUB.Add;
1538:
1539: END IF;
1540:
1541:
1540:
1541:
1542: WHEN OTHERS THEN
1543:
1544: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1545: THEN
1546: OE_MSG_PUB.Add_Exc_Msg
1547: ( G_PKG_NAME
1548: , 'Ship_From_Org'
1542: WHEN OTHERS THEN
1543:
1544: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1545: THEN
1546: OE_MSG_PUB.Add_Exc_Msg
1547: ( G_PKG_NAME
1548: , 'Ship_From_Org'
1549: );
1550: END IF;
1577: EXCEPTION
1578:
1579: WHEN NO_DATA_FOUND THEN
1580:
1581: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1582: THEN
1583:
1584: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
1585: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ship_to_contact');
1582: THEN
1583:
1584: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
1585: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ship_to_contact');
1586: OE_MSG_PUB.Add;
1587:
1588: END IF;
1589:
1590: RETURN NULL;
1590: RETURN NULL;
1591:
1592: WHEN OTHERS THEN
1593:
1594: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1595: THEN
1596: OE_MSG_PUB.Add_Exc_Msg
1597: ( G_PKG_NAME
1598: , 'Ship_To_Contact'
1592: WHEN OTHERS THEN
1593:
1594: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1595: THEN
1596: OE_MSG_PUB.Add_Exc_Msg
1597: ( G_PKG_NAME
1598: , 'Ship_To_Contact'
1599: );
1600: END IF;
1675: EXCEPTION
1676:
1677: WHEN NO_DATA_FOUND THEN
1678:
1679: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1680: THEN
1681:
1682: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
1683: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ship_to_org');
1680: THEN
1681:
1682: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
1683: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ship_to_org');
1684: OE_MSG_PUB.Add;
1685:
1686: END IF;
1687:
1688:
1687:
1688:
1689: WHEN OTHERS THEN
1690:
1691: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1692: THEN
1693: OE_MSG_PUB.Add_Exc_Msg
1694: ( G_PKG_NAME
1695: , 'Ship_To_Org'
1689: WHEN OTHERS THEN
1690:
1691: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1692: THEN
1693: OE_MSG_PUB.Add_Exc_Msg
1694: ( G_PKG_NAME
1695: , 'Ship_To_Org'
1696: );
1697: END IF;
1724: EXCEPTION
1725:
1726: WHEN NO_DATA_FOUND THEN
1727:
1728: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1729: THEN
1730:
1731: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
1732: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','sold_to_contact');
1729: THEN
1730:
1731: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
1732: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','sold_to_contact');
1733: OE_MSG_PUB.Add;
1734:
1735: END IF;
1736:
1737: RETURN NULL;
1737: RETURN NULL;
1738:
1739: WHEN OTHERS THEN
1740:
1741: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1742: THEN
1743: OE_MSG_PUB.Add_Exc_Msg
1744: ( G_PKG_NAME
1745: , 'Sold_To_Contact'
1739: WHEN OTHERS THEN
1740:
1741: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1742: THEN
1743: OE_MSG_PUB.Add_Exc_Msg
1744: ( G_PKG_NAME
1745: , 'Sold_To_Contact'
1746: );
1747: END IF;
1786: EXCEPTION
1787:
1788: WHEN NO_DATA_FOUND THEN
1789:
1790: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1791: THEN
1792:
1793: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
1794: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','sold_to_org');
1791: THEN
1792:
1793: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
1794: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','sold_to_org');
1795: OE_MSG_PUB.Add;
1796:
1797: END IF;
1798:
1799:
1798:
1799:
1800: WHEN OTHERS THEN
1801:
1802: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1803: THEN
1804: OE_MSG_PUB.Add_Exc_Msg
1805: ( G_PKG_NAME
1806: , 'Sold_To_Org'
1800: WHEN OTHERS THEN
1801:
1802: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1803: THEN
1804: OE_MSG_PUB.Add_Exc_Msg
1805: ( G_PKG_NAME
1806: , 'Sold_To_Org'
1807: );
1808: END IF;
1859: EXCEPTION
1860:
1861: WHEN NO_DATA_FOUND THEN
1862:
1863: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1864: THEN
1865:
1866: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
1867: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','sold_to_org');
1864: THEN
1865:
1866: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
1867: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','sold_to_org');
1868: OE_MSG_PUB.Add;
1869:
1870: END IF;
1871:
1872:
1871:
1872:
1873: WHEN OTHERS THEN
1874:
1875: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1876: THEN
1877: OE_MSG_PUB.Add_Exc_Msg
1878: ( G_PKG_NAME
1879: , 'Sold_To_Org'
1873: WHEN OTHERS THEN
1874:
1875: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1876: THEN
1877: OE_MSG_PUB.Add_Exc_Msg
1878: ( G_PKG_NAME
1879: , 'Sold_To_Org'
1880: );
1881: END IF;
1913: EXCEPTION
1914:
1915: WHEN NO_DATA_FOUND THEN
1916:
1917: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1918: THEN
1919:
1920: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
1921: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','tax_exempt');
1918: THEN
1919:
1920: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
1921: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','tax_exempt');
1922: OE_MSG_PUB.Add;
1923:
1924: END IF;
1925:
1926: RETURN NULL;
1926: RETURN NULL;
1927:
1928: WHEN OTHERS THEN
1929:
1930: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1931: THEN
1932: OE_MSG_PUB.Add_Exc_Msg
1933: ( G_PKG_NAME
1934: , 'Tax_Exempt'
1928: WHEN OTHERS THEN
1929:
1930: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1931: THEN
1932: OE_MSG_PUB.Add_Exc_Msg
1933: ( G_PKG_NAME
1934: , 'Tax_Exempt'
1935: );
1936: END IF;
1966: EXCEPTION
1967:
1968: WHEN NO_DATA_FOUND THEN
1969:
1970: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1971: THEN
1972:
1973: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
1974: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','tax_exempt_reason');
1971: THEN
1972:
1973: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
1974: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','tax_exempt_reason');
1975: OE_MSG_PUB.Add;
1976:
1977: END IF;
1978:
1979: RETURN NULL;
1979: RETURN NULL;
1980:
1981: WHEN OTHERS THEN
1982:
1983: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1984: THEN
1985: OE_MSG_PUB.Add_Exc_Msg
1986: ( G_PKG_NAME
1987: , 'Tax_Exempt_Reason'
1981: WHEN OTHERS THEN
1982:
1983: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1984: THEN
1985: OE_MSG_PUB.Add_Exc_Msg
1986: ( G_PKG_NAME
1987: , 'Tax_Exempt_Reason'
1988: );
1989: END IF;
2018: EXCEPTION
2019:
2020: WHEN NO_DATA_FOUND THEN
2021:
2022: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2023: THEN
2024:
2025: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
2026: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','tax_point');
2023: THEN
2024:
2025: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
2026: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','tax_point');
2027: OE_MSG_PUB.Add;
2028:
2029: END IF;
2030:
2031: RETURN NULL;
2031: RETURN NULL;
2032:
2033: WHEN OTHERS THEN
2034:
2035: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2036: THEN
2037: OE_MSG_PUB.Add_Exc_Msg
2038: ( G_PKG_NAME
2039: , 'Tax_Point'
2033: WHEN OTHERS THEN
2034:
2035: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2036: THEN
2037: OE_MSG_PUB.Add_Exc_Msg
2038: ( G_PKG_NAME
2039: , 'Tax_Point'
2040: );
2041: END IF;
2070: EXCEPTION
2071:
2072: WHEN NO_DATA_FOUND THEN
2073:
2074: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2075: THEN
2076:
2077: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
2078: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','discount');
2075: THEN
2076:
2077: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
2078: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','discount');
2079: OE_MSG_PUB.Add;
2080:
2081: END IF;
2082:
2083: RETURN NULL;
2083: RETURN NULL;
2084:
2085: WHEN OTHERS THEN
2086:
2087: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2088: THEN
2089: OE_MSG_PUB.Add_Exc_Msg
2090: ( G_PKG_NAME
2091: , 'Discount'
2085: WHEN OTHERS THEN
2086:
2087: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2088: THEN
2089: OE_MSG_PUB.Add_Exc_Msg
2090: ( G_PKG_NAME
2091: , 'Discount'
2092: );
2093: END IF;
2121: EXCEPTION
2122:
2123: WHEN NO_DATA_FOUND THEN
2124:
2125: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2126: THEN
2127:
2128: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
2129: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','sales_credit_type');
2126: THEN
2127:
2128: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
2129: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','sales_credit_type');
2130: OE_MSG_PUB.Add;
2131:
2132: END IF;
2133:
2134: RETURN NULL;
2134: RETURN NULL;
2135:
2136: WHEN OTHERS THEN
2137:
2138: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2139: THEN
2140: OE_MSG_PUB.Add_Exc_Msg
2141: ( G_PKG_NAME
2142: , 'sales_credit_type'
2136: WHEN OTHERS THEN
2137:
2138: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2139: THEN
2140: OE_MSG_PUB.Add_Exc_Msg
2141: ( G_PKG_NAME
2142: , 'sales_credit_type'
2143: );
2144: END IF;
2172: EXCEPTION
2173:
2174: WHEN NO_DATA_FOUND THEN
2175:
2176: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2177: THEN
2178:
2179: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
2180: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','salesrep');
2177: THEN
2178:
2179: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
2180: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','salesrep');
2181: OE_MSG_PUB.Add;
2182:
2183: END IF;
2184:
2185: RETURN NULL;
2185: RETURN NULL;
2186:
2187: WHEN OTHERS THEN
2188:
2189: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2190: THEN
2191: OE_MSG_PUB.Add_Exc_Msg
2192: ( G_PKG_NAME
2193: , 'Salesrep'
2187: WHEN OTHERS THEN
2188:
2189: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2190: THEN
2191: OE_MSG_PUB.Add_Exc_Msg
2192: ( G_PKG_NAME
2193: , 'Salesrep'
2194: );
2195: END IF;
2224: EXCEPTION
2225:
2226: WHEN NO_DATA_FOUND THEN
2227:
2228: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2229: THEN
2230:
2231: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
2232: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','customer_item');
2229: THEN
2230:
2231: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
2232: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','customer_item');
2233: OE_MSG_PUB.Add;
2234:
2235: END IF;
2236:
2237: RETURN NULL;
2237: RETURN NULL;
2238:
2239: WHEN OTHERS THEN
2240:
2241: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2242: THEN
2243: OE_MSG_PUB.Add_Exc_Msg
2244: ( G_PKG_NAME
2245: , 'Customer_Item'
2239: WHEN OTHERS THEN
2240:
2241: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2242: THEN
2243: OE_MSG_PUB.Add_Exc_Msg
2244: ( G_PKG_NAME
2245: , 'Customer_Item'
2246: );
2247: END IF;
2276: EXCEPTION
2277:
2278: WHEN NO_DATA_FOUND THEN
2279:
2280: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2281: THEN
2282:
2283: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
2284: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','demand_bucket_type');
2281: THEN
2282:
2283: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
2284: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','demand_bucket_type');
2285: OE_MSG_PUB.Add;
2286:
2287: END IF;
2288:
2289: RETURN NULL;
2289: RETURN NULL;
2290:
2291: WHEN OTHERS THEN
2292:
2293: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2294: THEN
2295: OE_MSG_PUB.Add_Exc_Msg
2296: ( G_PKG_NAME
2297: , 'Demand_Bucket_Type'
2291: WHEN OTHERS THEN
2292:
2293: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2294: THEN
2295: OE_MSG_PUB.Add_Exc_Msg
2296: ( G_PKG_NAME
2297: , 'Demand_Bucket_Type'
2298: );
2299: END IF;
2334: EXCEPTION
2335:
2336: WHEN NO_DATA_FOUND THEN
2337:
2338: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2339: THEN
2340:
2341: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
2342: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','inventory_item');
2339: THEN
2340:
2341: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
2342: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','inventory_item');
2343: OE_MSG_PUB.Add;
2344:
2345: END IF;
2346:
2347: RETURN NULL;
2347: RETURN NULL;
2348:
2349: WHEN OTHERS THEN
2350:
2351: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2352: THEN
2353: OE_MSG_PUB.Add_Exc_Msg
2354: ( G_PKG_NAME
2355: , 'Inventory_Item'
2349: WHEN OTHERS THEN
2350:
2351: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2352: THEN
2353: OE_MSG_PUB.Add_Exc_Msg
2354: ( G_PKG_NAME
2355: , 'Inventory_Item'
2356: );
2357: END IF;
2386: EXCEPTION
2387:
2388: WHEN NO_DATA_FOUND THEN
2389:
2390: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2391: THEN
2392:
2393: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
2394: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','item_type');
2391: THEN
2392:
2393: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
2394: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','item_type');
2395: OE_MSG_PUB.Add;
2396:
2397: END IF;
2398:
2399: RETURN NULL;
2399: RETURN NULL;
2400:
2401: WHEN OTHERS THEN
2402:
2403: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2404: THEN
2405: OE_MSG_PUB.Add_Exc_Msg
2406: ( G_PKG_NAME
2407: , 'Item_Type'
2401: WHEN OTHERS THEN
2402:
2403: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2404: THEN
2405: OE_MSG_PUB.Add_Exc_Msg
2406: ( G_PKG_NAME
2407: , 'Item_Type'
2408: );
2409: END IF;
2436: EXCEPTION
2437:
2438: WHEN NO_DATA_FOUND THEN
2439:
2440: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2441: THEN
2442:
2443: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
2444: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','line_type');
2441: THEN
2442:
2443: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
2444: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','line_type');
2445: OE_MSG_PUB.Add;
2446:
2447: END IF;
2448:
2449: RETURN NULL;
2449: RETURN NULL;
2450:
2451: WHEN OTHERS THEN
2452:
2453: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2454: THEN
2455: OE_MSG_PUB.Add_Exc_Msg
2456: ( G_PKG_NAME
2457: , 'Line_Type'
2451: WHEN OTHERS THEN
2452:
2453: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2454: THEN
2455: OE_MSG_PUB.Add_Exc_Msg
2456: ( G_PKG_NAME
2457: , 'Line_Type'
2458: );
2459: END IF;
2483: EXCEPTION
2484:
2485: WHEN NO_DATA_FOUND THEN
2486:
2487: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2488: THEN
2489:
2490: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
2491: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','project');
2488: THEN
2489:
2490: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
2491: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','project');
2492: OE_MSG_PUB.Add;
2493:
2494: END IF;
2495:
2496: RETURN NULL;
2496: RETURN NULL;
2497:
2498: WHEN OTHERS THEN
2499:
2500: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2501: THEN
2502: OE_MSG_PUB.Add_Exc_Msg
2503: ( G_PKG_NAME
2504: , 'Project'
2498: WHEN OTHERS THEN
2499:
2500: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2501: THEN
2502: OE_MSG_PUB.Add_Exc_Msg
2503: ( G_PKG_NAME
2504: , 'Project'
2505: );
2506: END IF;
2535: EXCEPTION
2536:
2537: WHEN NO_DATA_FOUND THEN
2538:
2539: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2540: THEN
2541:
2542: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
2543: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','rla_schedule_type');
2540: THEN
2541:
2542: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
2543: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','rla_schedule_type');
2544: OE_MSG_PUB.Add;
2545:
2546: END IF;
2547:
2548: RETURN NULL;
2548: RETURN NULL;
2549:
2550: WHEN OTHERS THEN
2551:
2552: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2553: THEN
2554: OE_MSG_PUB.Add_Exc_Msg
2555: ( G_PKG_NAME
2556: , 'Rla_Schedule_Type'
2550: WHEN OTHERS THEN
2551:
2552: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2553: THEN
2554: OE_MSG_PUB.Add_Exc_Msg
2555: ( G_PKG_NAME
2556: , 'Rla_Schedule_Type'
2557: );
2558: END IF;
2582: EXCEPTION
2583:
2584: WHEN NO_DATA_FOUND THEN
2585:
2586: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2587: THEN
2588:
2589: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
2590: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','task');
2587: THEN
2588:
2589: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
2590: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','task');
2591: OE_MSG_PUB.Add;
2592:
2593: END IF;
2594:
2595: RETURN NULL;
2595: RETURN NULL;
2596:
2597: WHEN OTHERS THEN
2598:
2599: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2600: THEN
2601: OE_MSG_PUB.Add_Exc_Msg
2602: ( G_PKG_NAME
2603: , 'Task'
2597: WHEN OTHERS THEN
2598:
2599: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2600: THEN
2601: OE_MSG_PUB.Add_Exc_Msg
2602: ( G_PKG_NAME
2603: , 'Task'
2604: );
2605: END IF;
2635: EXCEPTION
2636:
2637: WHEN NO_DATA_FOUND THEN
2638:
2639: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2640: THEN
2641:
2642: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
2643: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','over_ship_reason');
2640: THEN
2641:
2642: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
2643: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','over_ship_reason');
2644: OE_MSG_PUB.Add;
2645:
2646: END IF;
2647:
2648: RETURN NULL;
2648: RETURN NULL;
2649:
2650: WHEN OTHERS THEN
2651:
2652: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2653: THEN
2654: OE_MSG_PUB.Add_Exc_Msg
2655: ( G_PKG_NAME
2656: , 'Over_Ship_Reason'
2650: WHEN OTHERS THEN
2651:
2652: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2653: THEN
2654: OE_MSG_PUB.Add_Exc_Msg
2655: ( G_PKG_NAME
2656: , 'Over_Ship_Reason'
2657: );
2658: END IF;
2687: EXCEPTION
2688:
2689: WHEN NO_DATA_FOUND THEN
2690:
2691: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2692: THEN
2693:
2694: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
2695: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','source_type');
2692: THEN
2693:
2694: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
2695: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','source_type');
2696: OE_MSG_PUB.Add;
2697:
2698: END IF;
2699:
2700: RETURN NULL;
2700: RETURN NULL;
2701:
2702: WHEN OTHERS THEN
2703:
2704: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2705: THEN
2706: OE_MSG_PUB.Add_Exc_Msg
2707: ( G_PKG_NAME
2708: , 'Source_Type'
2702: WHEN OTHERS THEN
2703:
2704: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2705: THEN
2706: OE_MSG_PUB.Add_Exc_Msg
2707: ( G_PKG_NAME
2708: , 'Source_Type'
2709: );
2710: END IF;
2739: EXCEPTION
2740:
2741: WHEN NO_DATA_FOUND THEN
2742:
2743: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2744: THEN
2745:
2746: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
2747: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','order_date_type');
2744: THEN
2745:
2746: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
2747: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','order_date_type');
2748: OE_MSG_PUB.Add;
2749:
2750: END IF;
2751:
2752: RETURN NULL;
2752: RETURN NULL;
2753:
2754: WHEN OTHERS THEN
2755:
2756: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2757: THEN
2758: OE_MSG_PUB.Add_Exc_Msg
2759: ( G_PKG_NAME
2760: , 'order_date_type'
2754: WHEN OTHERS THEN
2755:
2756: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2757: THEN
2758: OE_MSG_PUB.Add_Exc_Msg
2759: ( G_PKG_NAME
2760: , 'order_date_type'
2761: );
2762: END IF;
2791: EXCEPTION
2792:
2793: WHEN NO_DATA_FOUND THEN
2794:
2795: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2796: THEN
2797:
2798: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
2799: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','return_reason');
2796: THEN
2797:
2798: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
2799: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','return_reason');
2800: OE_MSG_PUB.Add;
2801:
2802: END IF;
2803:
2804: RETURN NULL;
2804: RETURN NULL;
2805:
2806: WHEN OTHERS THEN
2807:
2808: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2809: THEN
2810: OE_MSG_PUB.Add_Exc_Msg
2811: ( G_PKG_NAME
2812: , 'Return_Reason'
2806: WHEN OTHERS THEN
2807:
2808: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2809: THEN
2810: OE_MSG_PUB.Add_Exc_Msg
2811: ( G_PKG_NAME
2812: , 'Return_Reason'
2813: );
2814: END IF;
2862: EXCEPTION
2863:
2864: WHEN NO_DATA_FOUND THEN
2865:
2866: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2867: THEN
2868:
2869: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
2870: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','reference_line');
2867: THEN
2868:
2869: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
2870: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','reference_line');
2871: OE_MSG_PUB.Add;
2872:
2873: END IF;
2874:
2875: WHEN OTHERS THEN
2873: END IF;
2874:
2875: WHEN OTHERS THEN
2876:
2877: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2878: THEN
2879: OE_MSG_PUB.Add_Exc_Msg
2880: ( G_PKG_NAME
2881: , 'Reference_line'
2875: WHEN OTHERS THEN
2876:
2877: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2878: THEN
2879: OE_MSG_PUB.Add_Exc_Msg
2880: ( G_PKG_NAME
2881: , 'Reference_line'
2882: );
2883: END IF;
2920: EXCEPTION
2921:
2922: WHEN NO_DATA_FOUND THEN
2923:
2924: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2925: THEN
2926:
2927: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
2928: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Reference_Customer_Trx_Line');
2925: THEN
2926:
2927: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
2928: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Reference_Customer_Trx_Line');
2929: OE_MSG_PUB.Add;
2930:
2931: END IF;
2932:
2933: WHEN OTHERS THEN
2931: END IF;
2932:
2933: WHEN OTHERS THEN
2934:
2935: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2936: THEN
2937: OE_MSG_PUB.Add_Exc_Msg
2938: ( G_PKG_NAME
2939: , 'Reference_Customer_Trx_Line'
2933: WHEN OTHERS THEN
2934:
2935: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2936: THEN
2937: OE_MSG_PUB.Add_Exc_Msg
2938: ( G_PKG_NAME
2939: , 'Reference_Customer_Trx_Line'
2940: );
2941: END IF;
2970: EXCEPTION
2971:
2972: WHEN NO_DATA_FOUND THEN
2973:
2974: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2975: THEN
2976:
2977: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
2978: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','credit_invoice_line');
2975: THEN
2976:
2977: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
2978: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','credit_invoice_line');
2979: OE_MSG_PUB.Add;
2980:
2981: END IF;
2982:
2983: RETURN NULL;
2983: RETURN NULL;
2984:
2985: WHEN OTHERS THEN
2986:
2987: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2988: THEN
2989: OE_MSG_PUB.Add_Exc_Msg
2990: ( G_PKG_NAME
2991: , 'credit_invoice_line'
2985: WHEN OTHERS THEN
2986:
2987: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2988: THEN
2989: OE_MSG_PUB.Add_Exc_Msg
2990: ( G_PKG_NAME
2991: , 'credit_invoice_line'
2992: );
2993: END IF;
3022: EXCEPTION
3023:
3024: WHEN NO_DATA_FOUND THEN
3025:
3026: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
3027: THEN
3028:
3029: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
3030: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','veh_cus_item_cum_key');
3027: THEN
3028:
3029: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
3030: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','veh_cus_item_cum_key');
3031: OE_MSG_PUB.Add;
3032:
3033: END IF;
3034:
3035: RETURN NULL;
3035: RETURN NULL;
3036:
3037: WHEN OTHERS THEN
3038:
3039: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3040: THEN
3041: OE_MSG_PUB.Add_Exc_Msg
3042: ( G_PKG_NAME
3043: , 'Veh_Cus_Item_cum_key'
3037: WHEN OTHERS THEN
3038:
3039: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3040: THEN
3041: OE_MSG_PUB.Add_Exc_Msg
3042: ( G_PKG_NAME
3043: , 'Veh_Cus_Item_cum_key'
3044: );
3045: END IF;
3091: EXCEPTION
3092:
3093: WHEN NO_DATA_FOUND THEN
3094:
3095: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
3096: THEN
3097:
3098: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
3099: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','payment_type');
3096: THEN
3097:
3098: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
3099: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','payment_type');
3100: OE_MSG_PUB.Add;
3101:
3102: END IF;
3103:
3104: RETURN NULL;
3104: RETURN NULL;
3105:
3106: WHEN OTHERS THEN
3107:
3108: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3109: THEN
3110: OE_MSG_PUB.Add_Exc_Msg
3111: ( G_PKG_NAME
3112: , 'Payment_Type'
3106: WHEN OTHERS THEN
3107:
3108: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3109: THEN
3110: OE_MSG_PUB.Add_Exc_Msg
3111: ( G_PKG_NAME
3112: , 'Payment_Type'
3113: );
3114: END IF;
3141: EXCEPTION
3142:
3143: WHEN NO_DATA_FOUND THEN
3144:
3145: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
3146: THEN
3147:
3148: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
3149: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','credit_card');
3146: THEN
3147:
3148: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
3149: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','credit_card');
3150: OE_MSG_PUB.Add;
3151:
3152: END IF;
3153:
3154: RETURN NULL;
3154: RETURN NULL;
3155:
3156: WHEN OTHERS THEN
3157:
3158: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3159: THEN
3160: OE_MSG_PUB.Add_Exc_Msg
3161: ( G_PKG_NAME
3162: , 'Credit_Card'
3156: WHEN OTHERS THEN
3157:
3158: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3159: THEN
3160: OE_MSG_PUB.Add_Exc_Msg
3161: ( G_PKG_NAME
3162: , 'Credit_Card'
3163: );
3164: END IF;
3192: EXCEPTION
3193:
3194: WHEN NO_DATA_FOUND THEN
3195:
3196: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
3197: THEN
3198:
3199: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
3200: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','commitment');
3197: THEN
3198:
3199: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
3200: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','commitment');
3201: OE_MSG_PUB.Add;
3202:
3203: END IF;
3204:
3205: RETURN NULL;
3205: RETURN NULL;
3206:
3207: WHEN OTHERS THEN
3208:
3209: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3210: THEN
3211: OE_MSG_PUB.Add_Exc_Msg
3212: ( G_PKG_NAME
3213: , 'Commitment'
3207: WHEN OTHERS THEN
3208:
3209: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3210: THEN
3211: OE_MSG_PUB.Add_Exc_Msg
3212: ( G_PKG_NAME
3213: , 'Commitment'
3214: );
3215: END IF;
3248: EXCEPTION
3249:
3250: WHEN NO_DATA_FOUND THEN
3251:
3252: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
3253: THEN
3254:
3255: fnd_message.set_name('ONT','OE_ID_TO__VALUE_ERROR');
3256: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','agreement_contact');
3253: THEN
3254:
3255: fnd_message.set_name('ONT','OE_ID_TO__VALUE_ERROR');
3256: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','agreement_contact');
3257: OE_MSG_PUB.Add;
3258:
3259: END IF;
3260:
3261: RETURN NULL;
3261: RETURN NULL;
3262:
3263: WHEN OTHERS THEN
3264:
3265: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3266: THEN
3267: OE_MSG_PUB.Add_Exc_Msg
3268: ( G_PKG_NAME
3269: , 'Agreement_Contact'
3263: WHEN OTHERS THEN
3264:
3265: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3266: THEN
3267: OE_MSG_PUB.Add_Exc_Msg
3268: ( G_PKG_NAME
3269: , 'Agreement_Contact'
3270: );
3271: END IF;
3300: EXCEPTION
3301:
3302: WHEN NO_DATA_FOUND THEN
3303:
3304: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
3305: THEN
3306:
3307: fnd_message.set_name('ONT','OE_ID_TO__VALUE_ERROR');
3308: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','agreement_type');
3305: THEN
3306:
3307: fnd_message.set_name('ONT','OE_ID_TO__VALUE_ERROR');
3308: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','agreement_type');
3309: OE_MSG_PUB.Add;
3310:
3311: END IF;
3312:
3313: RETURN NULL;
3313: RETURN NULL;
3314:
3315: WHEN OTHERS THEN
3316:
3317: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3318: THEN
3319: OE_MSG_PUB.Add_Exc_Msg
3320: ( G_PKG_NAME
3321: , 'Agreement_Type'
3315: WHEN OTHERS THEN
3316:
3317: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3318: THEN
3319: OE_MSG_PUB.Add_Exc_Msg
3320: ( G_PKG_NAME
3321: , 'Agreement_Type'
3322: );
3323: END IF;
3352: EXCEPTION
3353:
3354: WHEN NO_DATA_FOUND THEN
3355:
3356: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
3357: THEN
3358:
3359: fnd_message.set_name('ONT','OE_ID_TO__VALUE_ERROR');
3360: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','customer');
3357: THEN
3358:
3359: fnd_message.set_name('ONT','OE_ID_TO__VALUE_ERROR');
3360: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','customer');
3361: OE_MSG_PUB.Add;
3362:
3363: END IF;
3364:
3365: RETURN NULL;
3365: RETURN NULL;
3366:
3367: WHEN OTHERS THEN
3368:
3369: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3370: THEN
3371: OE_MSG_PUB.Add_Exc_Msg
3372: ( G_PKG_NAME
3373: , 'Customer'
3367: WHEN OTHERS THEN
3368:
3369: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3370: THEN
3371: OE_MSG_PUB.Add_Exc_Msg
3372: ( G_PKG_NAME
3373: , 'Customer'
3374: );
3375: END IF;
3404: EXCEPTION
3405:
3406: WHEN NO_DATA_FOUND THEN
3407:
3408: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
3409: THEN
3410:
3411: fnd_message.set_name('ONT','OE_ID_TO__VALUE_ERROR');
3412: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','invoice_contact');
3409: THEN
3410:
3411: fnd_message.set_name('ONT','OE_ID_TO__VALUE_ERROR');
3412: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','invoice_contact');
3413: OE_MSG_PUB.Add;
3414:
3415: END IF;
3416:
3417: RETURN NULL;
3417: RETURN NULL;
3418:
3419: WHEN OTHERS THEN
3420:
3421: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3422: THEN
3423: OE_MSG_PUB.Add_Exc_Msg
3424: ( G_PKG_NAME
3425: , 'Invoice_Contact'
3419: WHEN OTHERS THEN
3420:
3421: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3422: THEN
3423: OE_MSG_PUB.Add_Exc_Msg
3424: ( G_PKG_NAME
3425: , 'Invoice_Contact'
3426: );
3427: END IF;
3456: EXCEPTION
3457:
3458: WHEN NO_DATA_FOUND THEN
3459:
3460: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
3461: THEN
3462:
3463: fnd_message.set_name('ONT','OE_ID_TO__VALUE_ERROR');
3464: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','invoice_to_site_use');
3461: THEN
3462:
3463: fnd_message.set_name('ONT','OE_ID_TO__VALUE_ERROR');
3464: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','invoice_to_site_use');
3465: OE_MSG_PUB.Add;
3466:
3467: END IF;
3468:
3469: RETURN NULL;
3469: RETURN NULL;
3470:
3471: WHEN OTHERS THEN
3472:
3473: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3474: THEN
3475: OE_MSG_PUB.Add_Exc_Msg
3476: ( G_PKG_NAME
3477: , 'Invoice_To_Site_Use'
3471: WHEN OTHERS THEN
3472:
3473: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3474: THEN
3475: OE_MSG_PUB.Add_Exc_Msg
3476: ( G_PKG_NAME
3477: , 'Invoice_To_Site_Use'
3478: );
3479: END IF;
3508: EXCEPTION
3509:
3510: WHEN NO_DATA_FOUND THEN
3511:
3512: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
3513: THEN
3514:
3515: fnd_message.set_name('ONT','OE_ID_TO__VALUE_ERROR');
3516: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','override_arule');
3513: THEN
3514:
3515: fnd_message.set_name('ONT','OE_ID_TO__VALUE_ERROR');
3516: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','override_arule');
3517: OE_MSG_PUB.Add;
3518:
3519: END IF;
3520:
3521: RETURN NULL;
3521: RETURN NULL;
3522:
3523: WHEN OTHERS THEN
3524:
3525: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3526: THEN
3527: OE_MSG_PUB.Add_Exc_Msg
3528: ( G_PKG_NAME
3529: , 'Override_Arule'
3523: WHEN OTHERS THEN
3524:
3525: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3526: THEN
3527: OE_MSG_PUB.Add_Exc_Msg
3528: ( G_PKG_NAME
3529: , 'Override_Arule'
3530: );
3531: END IF;
3560: EXCEPTION
3561:
3562: WHEN NO_DATA_FOUND THEN
3563:
3564: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
3565: THEN
3566:
3567: fnd_message.set_name('ONT','OE_ID_TO__VALUE_ERROR');
3568: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','override_irule');
3565: THEN
3566:
3567: fnd_message.set_name('ONT','OE_ID_TO__VALUE_ERROR');
3568: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','override_irule');
3569: OE_MSG_PUB.Add;
3570:
3571: END IF;
3572:
3573: RETURN NULL;
3573: RETURN NULL;
3574:
3575: WHEN OTHERS THEN
3576:
3577: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3578: THEN
3579: OE_MSG_PUB.Add_Exc_Msg
3580: ( G_PKG_NAME
3581: , 'Override_Irule'
3575: WHEN OTHERS THEN
3576:
3577: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3578: THEN
3579: OE_MSG_PUB.Add_Exc_Msg
3580: ( G_PKG_NAME
3581: , 'Override_Irule'
3582: );
3583: END IF;
3612: EXCEPTION
3613:
3614: WHEN NO_DATA_FOUND THEN
3615:
3616: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
3617: THEN
3618:
3619: fnd_message.set_name('ONT','OE_ID_TO__VALUE_ERROR');
3620: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','revision_reason');
3617: THEN
3618:
3619: fnd_message.set_name('ONT','OE_ID_TO__VALUE_ERROR');
3620: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','revision_reason');
3621: OE_MSG_PUB.Add;
3622:
3623: END IF;
3624:
3625: RETURN NULL;
3625: RETURN NULL;
3626:
3627: WHEN OTHERS THEN
3628:
3629: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3630: THEN
3631: OE_MSG_PUB.Add_Exc_Msg
3632: ( G_PKG_NAME
3633: , 'Revision_Reason'
3627: WHEN OTHERS THEN
3628:
3629: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3630: THEN
3631: OE_MSG_PUB.Add_Exc_Msg
3632: ( G_PKG_NAME
3633: , 'Revision_Reason'
3634: );
3635: END IF;
3664: EXCEPTION
3665:
3666: WHEN NO_DATA_FOUND THEN
3667:
3668: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
3669: THEN
3670:
3671: fnd_message.set_name('ONT','OE_ID_TO__VALUE_ERROR');
3672: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ship_method');
3669: THEN
3670:
3671: fnd_message.set_name('ONT','OE_ID_TO__VALUE_ERROR');
3672: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ship_method');
3673: OE_MSG_PUB.Add;
3674:
3675: END IF;
3676:
3677: RETURN NULL;
3677: RETURN NULL;
3678:
3679: WHEN OTHERS THEN
3680:
3681: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3682: THEN
3683: OE_MSG_PUB.Add_Exc_Msg
3684: ( G_PKG_NAME
3685: , 'Ship_Method'
3679: WHEN OTHERS THEN
3680:
3681: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3682: THEN
3683: OE_MSG_PUB.Add_Exc_Msg
3684: ( G_PKG_NAME
3685: , 'Ship_Method'
3686: );
3687: END IF;
3716: EXCEPTION
3717:
3718: WHEN NO_DATA_FOUND THEN
3719:
3720: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
3721: THEN
3722:
3723: fnd_message.set_name('ONT','OE_ID_TO__VALUE_ERROR');
3724: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','term');
3721: THEN
3722:
3723: fnd_message.set_name('ONT','OE_ID_TO__VALUE_ERROR');
3724: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','term');
3725: OE_MSG_PUB.Add;
3726:
3727: END IF;
3728:
3729: RETURN NULL;
3729: RETURN NULL;
3730:
3731: WHEN OTHERS THEN
3732:
3733: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3734: THEN
3735: OE_MSG_PUB.Add_Exc_Msg
3736: ( G_PKG_NAME
3737: , 'Term'
3731: WHEN OTHERS THEN
3732:
3733: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3734: THEN
3735: OE_MSG_PUB.Add_Exc_Msg
3736: ( G_PKG_NAME
3737: , 'Term'
3738: );
3739: END IF;
3768: EXCEPTION
3769:
3770: WHEN NO_DATA_FOUND THEN
3771:
3772: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
3773: THEN
3774:
3775: fnd_message.set_name('ONT','OE_ID_TO__VALUE_ERROR');
3776: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','currency');
3773: THEN
3774:
3775: fnd_message.set_name('ONT','OE_ID_TO__VALUE_ERROR');
3776: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','currency');
3777: OE_MSG_PUB.Add;
3778:
3779: END IF;
3780:
3781: RETURN NULL;
3781: RETURN NULL;
3782:
3783: WHEN OTHERS THEN
3784:
3785: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3786: THEN
3787: OE_MSG_PUB.Add_Exc_Msg
3788: ( G_PKG_NAME
3789: , 'Currency'
3783: WHEN OTHERS THEN
3784:
3785: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3786: THEN
3787: OE_MSG_PUB.Add_Exc_Msg
3788: ( G_PKG_NAME
3789: , 'Currency'
3790: );
3791: END IF;
3820: EXCEPTION
3821:
3822: WHEN NO_DATA_FOUND THEN
3823:
3824: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
3825: THEN
3826:
3827: fnd_message.set_name('ONT','OE_ID_TO__VALUE_ERROR');
3828: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','secondary_price_list');
3825: THEN
3826:
3827: fnd_message.set_name('ONT','OE_ID_TO__VALUE_ERROR');
3828: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','secondary_price_list');
3829: OE_MSG_PUB.Add;
3830:
3831: END IF;
3832:
3833: RETURN NULL;
3833: RETURN NULL;
3834:
3835: WHEN OTHERS THEN
3836:
3837: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3838: THEN
3839: OE_MSG_PUB.Add_Exc_Msg
3840: ( G_PKG_NAME
3841: , 'Secondary_Price_List'
3835: WHEN OTHERS THEN
3836:
3837: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3838: THEN
3839: OE_MSG_PUB.Add_Exc_Msg
3840: ( G_PKG_NAME
3841: , 'Secondary_Price_List'
3842: );
3843: END IF;
3872: EXCEPTION
3873:
3874: WHEN NO_DATA_FOUND THEN
3875:
3876: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
3877: THEN
3878:
3879: fnd_message.set_name('ONT','OE_ID_TO__VALUE_ERROR');
3880: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','terms');
3877: THEN
3878:
3879: fnd_message.set_name('ONT','OE_ID_TO__VALUE_ERROR');
3880: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','terms');
3881: OE_MSG_PUB.Add;
3882:
3883: END IF;
3884:
3885: RETURN NULL;
3885: RETURN NULL;
3886:
3887: WHEN OTHERS THEN
3888:
3889: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3890: THEN
3891: OE_MSG_PUB.Add_Exc_Msg
3892: ( G_PKG_NAME
3893: , 'Terms'
3887: WHEN OTHERS THEN
3888:
3889: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3890: THEN
3891: OE_MSG_PUB.Add_Exc_Msg
3892: ( G_PKG_NAME
3893: , 'Terms'
3894: );
3895: END IF;
3924: EXCEPTION
3925:
3926: WHEN NO_DATA_FOUND THEN
3927:
3928: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
3929: THEN
3930:
3931: fnd_message.set_name('ONT','OE_ID_TO__VALUE_ERROR');
3932: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','automatic_discount');
3929: THEN
3930:
3931: fnd_message.set_name('ONT','OE_ID_TO__VALUE_ERROR');
3932: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','automatic_discount');
3933: OE_MSG_PUB.Add;
3934:
3935: END IF;
3936:
3937: RETURN NULL;
3937: RETURN NULL;
3938:
3939: WHEN OTHERS THEN
3940:
3941: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3942: THEN
3943: OE_MSG_PUB.Add_Exc_Msg
3944: ( G_PKG_NAME
3945: , 'Automatic_Discount'
3939: WHEN OTHERS THEN
3940:
3941: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3942: THEN
3943: OE_MSG_PUB.Add_Exc_Msg
3944: ( G_PKG_NAME
3945: , 'Automatic_Discount'
3946: );
3947: END IF;
3976: EXCEPTION
3977:
3978: WHEN NO_DATA_FOUND THEN
3979:
3980: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
3981: THEN
3982:
3983: fnd_message.set_name('ONT','OE_ID_TO__VALUE_ERROR');
3984: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','discount_lines');
3981: THEN
3982:
3983: fnd_message.set_name('ONT','OE_ID_TO__VALUE_ERROR');
3984: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','discount_lines');
3985: OE_MSG_PUB.Add;
3986:
3987: END IF;
3988:
3989: RETURN NULL;
3989: RETURN NULL;
3990:
3991: WHEN OTHERS THEN
3992:
3993: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3994: THEN
3995: OE_MSG_PUB.Add_Exc_Msg
3996: ( G_PKG_NAME
3997: , 'Discount_Lines'
3991: WHEN OTHERS THEN
3992:
3993: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3994: THEN
3995: OE_MSG_PUB.Add_Exc_Msg
3996: ( G_PKG_NAME
3997: , 'Discount_Lines'
3998: );
3999: END IF;
4028: EXCEPTION
4029:
4030: WHEN NO_DATA_FOUND THEN
4031:
4032: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
4033: THEN
4034:
4035: fnd_message.set_name('ONT','OE_ID_TO__VALUE_ERROR');
4036: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','discount_type');
4033: THEN
4034:
4035: fnd_message.set_name('ONT','OE_ID_TO__VALUE_ERROR');
4036: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','discount_type');
4037: OE_MSG_PUB.Add;
4038:
4039: END IF;
4040:
4041: RETURN NULL;
4041: RETURN NULL;
4042:
4043: WHEN OTHERS THEN
4044:
4045: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4046: THEN
4047: OE_MSG_PUB.Add_Exc_Msg
4048: ( G_PKG_NAME
4049: , 'Discount_Type'
4043: WHEN OTHERS THEN
4044:
4045: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4046: THEN
4047: OE_MSG_PUB.Add_Exc_Msg
4048: ( G_PKG_NAME
4049: , 'Discount_Type'
4050: );
4051: END IF;
4080: EXCEPTION
4081:
4082: WHEN NO_DATA_FOUND THEN
4083:
4084: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
4085: THEN
4086:
4087: fnd_message.set_name('ONT','OE_ID_TO__VALUE_ERROR');
4088: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','manual_discount');
4085: THEN
4086:
4087: fnd_message.set_name('ONT','OE_ID_TO__VALUE_ERROR');
4088: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','manual_discount');
4089: OE_MSG_PUB.Add;
4090:
4091: END IF;
4092:
4093: RETURN NULL;
4093: RETURN NULL;
4094:
4095: WHEN OTHERS THEN
4096:
4097: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4098: THEN
4099: OE_MSG_PUB.Add_Exc_Msg
4100: ( G_PKG_NAME
4101: , 'Manual_Discount'
4095: WHEN OTHERS THEN
4096:
4097: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4098: THEN
4099: OE_MSG_PUB.Add_Exc_Msg
4100: ( G_PKG_NAME
4101: , 'Manual_Discount'
4102: );
4103: END IF;
4132: EXCEPTION
4133:
4134: WHEN NO_DATA_FOUND THEN
4135:
4136: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
4137: THEN
4138:
4139: fnd_message.set_name('ONT','OE_ID_TO__VALUE_ERROR');
4140: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','override_allowed');
4137: THEN
4138:
4139: fnd_message.set_name('ONT','OE_ID_TO__VALUE_ERROR');
4140: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','override_allowed');
4141: OE_MSG_PUB.Add;
4142:
4143: END IF;
4144:
4145: RETURN NULL;
4145: RETURN NULL;
4146:
4147: WHEN OTHERS THEN
4148:
4149: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4150: THEN
4151: OE_MSG_PUB.Add_Exc_Msg
4152: ( G_PKG_NAME
4153: , 'Override_Allowed'
4147: WHEN OTHERS THEN
4148:
4149: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4150: THEN
4151: OE_MSG_PUB.Add_Exc_Msg
4152: ( G_PKG_NAME
4153: , 'Override_Allowed'
4154: );
4155: END IF;
4184: EXCEPTION
4185:
4186: WHEN NO_DATA_FOUND THEN
4187:
4188: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
4189: THEN
4190:
4191: fnd_message.set_name('ONT','OE_ID_TO__VALUE_ERROR');
4192: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','prorate');
4189: THEN
4190:
4191: fnd_message.set_name('ONT','OE_ID_TO__VALUE_ERROR');
4192: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','prorate');
4193: OE_MSG_PUB.Add;
4194:
4195: END IF;
4196:
4197: RETURN NULL;
4197: RETURN NULL;
4198:
4199: WHEN OTHERS THEN
4200:
4201: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4202: THEN
4203: OE_MSG_PUB.Add_Exc_Msg
4204: ( G_PKG_NAME
4205: , 'Prorate'
4199: WHEN OTHERS THEN
4200:
4201: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4202: THEN
4203: OE_MSG_PUB.Add_Exc_Msg
4204: ( G_PKG_NAME
4205: , 'Prorate'
4206: );
4207: END IF;
4236: EXCEPTION
4237:
4238: WHEN NO_DATA_FOUND THEN
4239:
4240: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
4241: THEN
4242:
4243: fnd_message.set_name('ONT','OE_ID_TO__VALUE_ERROR');
4244: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','method');
4241: THEN
4242:
4243: fnd_message.set_name('ONT','OE_ID_TO__VALUE_ERROR');
4244: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','method');
4245: OE_MSG_PUB.Add;
4246:
4247: END IF;
4248:
4249: RETURN NULL;
4249: RETURN NULL;
4250:
4251: WHEN OTHERS THEN
4252:
4253: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4254: THEN
4255: OE_MSG_PUB.Add_Exc_Msg
4256: ( G_PKG_NAME
4257: , 'Method'
4251: WHEN OTHERS THEN
4252:
4253: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4254: THEN
4255: OE_MSG_PUB.Add_Exc_Msg
4256: ( G_PKG_NAME
4257: , 'Method'
4258: );
4259: END IF;
4288: EXCEPTION
4289:
4290: WHEN NO_DATA_FOUND THEN
4291:
4292: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
4293: THEN
4294:
4295: fnd_message.set_name('ONT','OE_ID_TO__VALUE_ERROR');
4296: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','price_list_line');
4293: THEN
4294:
4295: fnd_message.set_name('ONT','OE_ID_TO__VALUE_ERROR');
4296: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','price_list_line');
4297: OE_MSG_PUB.Add;
4298:
4299: END IF;
4300:
4301: RETURN NULL;
4301: RETURN NULL;
4302:
4303: WHEN OTHERS THEN
4304:
4305: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4306: THEN
4307: OE_MSG_PUB.Add_Exc_Msg
4308: ( G_PKG_NAME
4309: , 'Price_List_Line'
4303: WHEN OTHERS THEN
4304:
4305: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4306: THEN
4307: OE_MSG_PUB.Add_Exc_Msg
4308: ( G_PKG_NAME
4309: , 'Price_List_Line'
4310: );
4311: END IF;
4340: EXCEPTION
4341:
4342: WHEN NO_DATA_FOUND THEN
4343:
4344: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
4345: THEN
4346:
4347: fnd_message.set_name('ONT','OE_ID_TO__VALUE_ERROR');
4348: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','pricing_rule');
4345: THEN
4346:
4347: fnd_message.set_name('ONT','OE_ID_TO__VALUE_ERROR');
4348: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','pricing_rule');
4349: OE_MSG_PUB.Add;
4350:
4351: END IF;
4352:
4353: RETURN NULL;
4353: RETURN NULL;
4354:
4355: WHEN OTHERS THEN
4356:
4357: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4358: THEN
4359: OE_MSG_PUB.Add_Exc_Msg
4360: ( G_PKG_NAME
4361: , 'Pricing_Rule'
4355: WHEN OTHERS THEN
4356:
4357: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4358: THEN
4359: OE_MSG_PUB.Add_Exc_Msg
4360: ( G_PKG_NAME
4361: , 'Pricing_Rule'
4362: );
4363: END IF;
4392: EXCEPTION
4393:
4394: WHEN NO_DATA_FOUND THEN
4395:
4396: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
4397: THEN
4398:
4399: fnd_message.set_name('ONT','OE_ID_TO__VALUE_ERROR');
4400: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','reprice');
4397: THEN
4398:
4399: fnd_message.set_name('ONT','OE_ID_TO__VALUE_ERROR');
4400: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','reprice');
4401: OE_MSG_PUB.Add;
4402:
4403: END IF;
4404:
4405: RETURN NULL;
4405: RETURN NULL;
4406:
4407: WHEN OTHERS THEN
4408:
4409: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4410: THEN
4411: OE_MSG_PUB.Add_Exc_Msg
4412: ( G_PKG_NAME
4413: , 'Reprice'
4407: WHEN OTHERS THEN
4408:
4409: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4410: THEN
4411: OE_MSG_PUB.Add_Exc_Msg
4412: ( G_PKG_NAME
4413: , 'Reprice'
4414: );
4415: END IF;
4444: EXCEPTION
4445:
4446: WHEN NO_DATA_FOUND THEN
4447:
4448: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
4449: THEN
4450:
4451: fnd_message.set_name('ONT','OE_ID_TO__VALUE_ERROR');
4452: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','unit');
4449: THEN
4450:
4451: fnd_message.set_name('ONT','OE_ID_TO__VALUE_ERROR');
4452: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','unit');
4453: OE_MSG_PUB.Add;
4454:
4455: END IF;
4456:
4457: RETURN NULL;
4457: RETURN NULL;
4458:
4459: WHEN OTHERS THEN
4460:
4461: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4462: THEN
4463: OE_MSG_PUB.Add_Exc_Msg
4464: ( G_PKG_NAME
4465: , 'Unit'
4459: WHEN OTHERS THEN
4460:
4461: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4462: THEN
4463: OE_MSG_PUB.Add_Exc_Msg
4464: ( G_PKG_NAME
4465: , 'Unit'
4466: );
4467: END IF;
4496: EXCEPTION
4497:
4498: WHEN NO_DATA_FOUND THEN
4499:
4500: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
4501: THEN
4502:
4503: fnd_message.set_name('ONT','OE_ID_TO__VALUE_ERROR');
4504: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','customer_class');
4501: THEN
4502:
4503: fnd_message.set_name('ONT','OE_ID_TO__VALUE_ERROR');
4504: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','customer_class');
4505: OE_MSG_PUB.Add;
4506:
4507: END IF;
4508:
4509: RETURN NULL;
4509: RETURN NULL;
4510:
4511: WHEN OTHERS THEN
4512:
4513: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4514: THEN
4515: OE_MSG_PUB.Add_Exc_Msg
4516: ( G_PKG_NAME
4517: , 'Customer_Class'
4511: WHEN OTHERS THEN
4512:
4513: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4514: THEN
4515: OE_MSG_PUB.Add_Exc_Msg
4516: ( G_PKG_NAME
4517: , 'Customer_Class'
4518: );
4519: END IF;
4548: EXCEPTION
4549:
4550: WHEN NO_DATA_FOUND THEN
4551:
4552: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
4553: THEN
4554:
4555: fnd_message.set_name('ONT','OE_ID_TO__VALUE_ERROR');
4556: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','discount_customer');
4553: THEN
4554:
4555: fnd_message.set_name('ONT','OE_ID_TO__VALUE_ERROR');
4556: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','discount_customer');
4557: OE_MSG_PUB.Add;
4558:
4559: END IF;
4560:
4561: RETURN NULL;
4561: RETURN NULL;
4562:
4563: WHEN OTHERS THEN
4564:
4565: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4566: THEN
4567: OE_MSG_PUB.Add_Exc_Msg
4568: ( G_PKG_NAME
4569: , 'Discount_Customer'
4563: WHEN OTHERS THEN
4564:
4565: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4566: THEN
4567: OE_MSG_PUB.Add_Exc_Msg
4568: ( G_PKG_NAME
4569: , 'Discount_Customer'
4570: );
4571: END IF;
4600: EXCEPTION
4601:
4602: WHEN NO_DATA_FOUND THEN
4603:
4604: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
4605: THEN
4606:
4607: fnd_message.set_name('ONT','OE_ID_TO__VALUE_ERROR');
4608: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','site_use');
4605: THEN
4606:
4607: fnd_message.set_name('ONT','OE_ID_TO__VALUE_ERROR');
4608: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','site_use');
4609: OE_MSG_PUB.Add;
4610:
4611: END IF;
4612:
4613: RETURN NULL;
4613: RETURN NULL;
4614:
4615: WHEN OTHERS THEN
4616:
4617: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4618: THEN
4619: OE_MSG_PUB.Add_Exc_Msg
4620: ( G_PKG_NAME
4621: , 'Site_Use'
4615: WHEN OTHERS THEN
4616:
4617: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4618: THEN
4619: OE_MSG_PUB.Add_Exc_Msg
4620: ( G_PKG_NAME
4621: , 'Site_Use'
4622: );
4623: END IF;
4652: EXCEPTION
4653:
4654: WHEN NO_DATA_FOUND THEN
4655:
4656: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
4657: THEN
4658:
4659: fnd_message.set_name('ONT','OE_ID_TO__VALUE_ERROR');
4660: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','entity');
4657: THEN
4658:
4659: fnd_message.set_name('ONT','OE_ID_TO__VALUE_ERROR');
4660: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','entity');
4661: OE_MSG_PUB.Add;
4662:
4663: END IF;
4664:
4665: RETURN NULL;
4665: RETURN NULL;
4666:
4667: WHEN OTHERS THEN
4668:
4669: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4670: THEN
4671: OE_MSG_PUB.Add_Exc_Msg
4672: ( G_PKG_NAME
4673: , 'Entity'
4667: WHEN OTHERS THEN
4668:
4669: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4670: THEN
4671: OE_MSG_PUB.Add_Exc_Msg
4672: ( G_PKG_NAME
4673: , 'Entity'
4674: );
4675: END IF;
4704: EXCEPTION
4705:
4706: WHEN NO_DATA_FOUND THEN
4707:
4708: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
4709: THEN
4710:
4711: fnd_message.set_name('ONT','OE_ID_TO__VALUE_ERROR');
4712: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','method_type');
4709: THEN
4710:
4711: fnd_message.set_name('ONT','OE_ID_TO__VALUE_ERROR');
4712: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','method_type');
4713: OE_MSG_PUB.Add;
4714:
4715: END IF;
4716:
4717: RETURN NULL;
4717: RETURN NULL;
4718:
4719: WHEN OTHERS THEN
4720:
4721: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4722: THEN
4723: OE_MSG_PUB.Add_Exc_Msg
4724: ( G_PKG_NAME
4725: , 'Method_Type'
4719: WHEN OTHERS THEN
4720:
4721: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4722: THEN
4723: OE_MSG_PUB.Add_Exc_Msg
4724: ( G_PKG_NAME
4725: , 'Method_Type'
4726: );
4727: END IF;
4756: EXCEPTION
4757:
4758: WHEN NO_DATA_FOUND THEN
4759:
4760: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
4761: THEN
4762:
4763: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
4764: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','lot_serial');
4761: THEN
4762:
4763: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
4764: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','lot_serial');
4765: OE_MSG_PUB.Add;
4766:
4767: END IF;
4768:
4769: RETURN NULL;
4769: RETURN NULL;
4770:
4771: WHEN OTHERS THEN
4772:
4773: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4774: THEN
4775: OE_MSG_PUB.Add_Exc_Msg
4776: ( G_PKG_NAME
4777: , 'Lot_Serial'
4771: WHEN OTHERS THEN
4772:
4773: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4774: THEN
4775: OE_MSG_PUB.Add_Exc_Msg
4776: ( G_PKG_NAME
4777: , 'Lot_Serial'
4778: );
4779: END IF;
4808: EXCEPTION
4809:
4810: WHEN NO_DATA_FOUND THEN
4811:
4812: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
4813: THEN
4814:
4815: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
4816: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','appear_on_ack');
4813: THEN
4814:
4815: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
4816: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','appear_on_ack');
4817: OE_MSG_PUB.Add;
4818:
4819: END IF;
4820:
4821: RETURN NULL;
4821: RETURN NULL;
4822:
4823: WHEN OTHERS THEN
4824:
4825: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4826: THEN
4827: OE_MSG_PUB.Add_Exc_Msg
4828: ( G_PKG_NAME
4829: , 'Appear_On_Ack'
4823: WHEN OTHERS THEN
4824:
4825: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4826: THEN
4827: OE_MSG_PUB.Add_Exc_Msg
4828: ( G_PKG_NAME
4829: , 'Appear_On_Ack'
4830: );
4831: END IF;
4860: EXCEPTION
4861:
4862: WHEN NO_DATA_FOUND THEN
4863:
4864: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
4865: THEN
4866:
4867: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
4868: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','appear_on_invoice');
4865: THEN
4866:
4867: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
4868: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','appear_on_invoice');
4869: OE_MSG_PUB.Add;
4870:
4871: END IF;
4872:
4873: RETURN NULL;
4873: RETURN NULL;
4874:
4875: WHEN OTHERS THEN
4876:
4877: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4878: THEN
4879: OE_MSG_PUB.Add_Exc_Msg
4880: ( G_PKG_NAME
4881: , 'Appear_On_Invoice'
4875: WHEN OTHERS THEN
4876:
4877: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4878: THEN
4879: OE_MSG_PUB.Add_Exc_Msg
4880: ( G_PKG_NAME
4881: , 'Appear_On_Invoice'
4882: );
4883: END IF;
4912: EXCEPTION
4913:
4914: WHEN NO_DATA_FOUND THEN
4915:
4916: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
4917: THEN
4918:
4919: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
4920: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','charge');
4917: THEN
4918:
4919: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
4920: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','charge');
4921: OE_MSG_PUB.Add;
4922:
4923: END IF;
4924:
4925: RETURN NULL;
4925: RETURN NULL;
4926:
4927: WHEN OTHERS THEN
4928:
4929: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4930: THEN
4931: OE_MSG_PUB.Add_Exc_Msg
4932: ( G_PKG_NAME
4933: , 'Charge'
4927: WHEN OTHERS THEN
4928:
4929: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4930: THEN
4931: OE_MSG_PUB.Add_Exc_Msg
4932: ( G_PKG_NAME
4933: , 'Charge'
4934: );
4935: END IF;
4964: EXCEPTION
4965:
4966: WHEN NO_DATA_FOUND THEN
4967:
4968: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
4969: THEN
4970:
4971: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
4972: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','charge_type');
4969: THEN
4970:
4971: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
4972: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','charge_type');
4973: OE_MSG_PUB.Add;
4974:
4975: END IF;
4976:
4977: RETURN NULL;
4977: RETURN NULL;
4978:
4979: WHEN OTHERS THEN
4980:
4981: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4982: THEN
4983: OE_MSG_PUB.Add_Exc_Msg
4984: ( G_PKG_NAME
4985: , 'Charge_Type'
4979: WHEN OTHERS THEN
4980:
4981: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4982: THEN
4983: OE_MSG_PUB.Add_Exc_Msg
4984: ( G_PKG_NAME
4985: , 'Charge_Type'
4986: );
4987: END IF;
5016: EXCEPTION
5017:
5018: WHEN NO_DATA_FOUND THEN
5019:
5020: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
5021: THEN
5022:
5023: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
5024: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','cost_or_charge');
5021: THEN
5022:
5023: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
5024: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','cost_or_charge');
5025: OE_MSG_PUB.Add;
5026:
5027: END IF;
5028:
5029: RETURN NULL;
5029: RETURN NULL;
5030:
5031: WHEN OTHERS THEN
5032:
5033: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5034: THEN
5035: OE_MSG_PUB.Add_Exc_Msg
5036: ( G_PKG_NAME
5037: , 'Cost_Or_Charge'
5031: WHEN OTHERS THEN
5032:
5033: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5034: THEN
5035: OE_MSG_PUB.Add_Exc_Msg
5036: ( G_PKG_NAME
5037: , 'Cost_Or_Charge'
5038: );
5039: END IF;
5068: EXCEPTION
5069:
5070: WHEN NO_DATA_FOUND THEN
5071:
5072: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
5073: THEN
5074:
5075: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
5076: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','delivery');
5073: THEN
5074:
5075: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
5076: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','delivery');
5077: OE_MSG_PUB.Add;
5078:
5079: END IF;
5080:
5081: RETURN NULL;
5081: RETURN NULL;
5082:
5083: WHEN OTHERS THEN
5084:
5085: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5086: THEN
5087: OE_MSG_PUB.Add_Exc_Msg
5088: ( G_PKG_NAME
5089: , 'Delivery'
5083: WHEN OTHERS THEN
5084:
5085: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5086: THEN
5087: OE_MSG_PUB.Add_Exc_Msg
5088: ( G_PKG_NAME
5089: , 'Delivery'
5090: );
5091: END IF;
5120: EXCEPTION
5121:
5122: WHEN NO_DATA_FOUND THEN
5123:
5124: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
5125: THEN
5126:
5127: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
5128: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','departure');
5125: THEN
5126:
5127: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
5128: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','departure');
5129: OE_MSG_PUB.Add;
5130:
5131: END IF;
5132:
5133: RETURN NULL;
5133: RETURN NULL;
5134:
5135: WHEN OTHERS THEN
5136:
5137: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5138: THEN
5139: OE_MSG_PUB.Add_Exc_Msg
5140: ( G_PKG_NAME
5141: , 'Departure'
5135: WHEN OTHERS THEN
5136:
5137: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5138: THEN
5139: OE_MSG_PUB.Add_Exc_Msg
5140: ( G_PKG_NAME
5141: , 'Departure'
5142: );
5143: END IF;
5172: EXCEPTION
5173:
5174: WHEN NO_DATA_FOUND THEN
5175:
5176: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
5177: THEN
5178:
5179: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
5180: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','estimated');
5177: THEN
5178:
5179: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
5180: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','estimated');
5181: OE_MSG_PUB.Add;
5182:
5183: END IF;
5184:
5185: RETURN NULL;
5185: RETURN NULL;
5186:
5187: WHEN OTHERS THEN
5188:
5189: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5190: THEN
5191: OE_MSG_PUB.Add_Exc_Msg
5192: ( G_PKG_NAME
5193: , 'Estimated'
5187: WHEN OTHERS THEN
5188:
5189: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5190: THEN
5191: OE_MSG_PUB.Add_Exc_Msg
5192: ( G_PKG_NAME
5193: , 'Estimated'
5194: );
5195: END IF;
5224: EXCEPTION
5225:
5226: WHEN NO_DATA_FOUND THEN
5227:
5228: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
5229: THEN
5230:
5231: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
5232: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','invoiced');
5229: THEN
5230:
5231: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
5232: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','invoiced');
5233: OE_MSG_PUB.Add;
5234:
5235: END IF;
5236:
5237: RETURN NULL;
5237: RETURN NULL;
5238:
5239: WHEN OTHERS THEN
5240:
5241: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5242: THEN
5243: OE_MSG_PUB.Add_Exc_Msg
5244: ( G_PKG_NAME
5245: , 'Invoiced'
5239: WHEN OTHERS THEN
5240:
5241: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5242: THEN
5243: OE_MSG_PUB.Add_Exc_Msg
5244: ( G_PKG_NAME
5245: , 'Invoiced'
5246: );
5247: END IF;
5276: EXCEPTION
5277:
5278: WHEN NO_DATA_FOUND THEN
5279:
5280: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
5281: THEN
5282:
5283: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
5284: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','parent_charge');
5281: THEN
5282:
5283: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
5284: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','parent_charge');
5285: OE_MSG_PUB.Add;
5286:
5287: END IF;
5288:
5289: RETURN NULL;
5289: RETURN NULL;
5290:
5291: WHEN OTHERS THEN
5292:
5293: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5294: THEN
5295: OE_MSG_PUB.Add_Exc_Msg
5296: ( G_PKG_NAME
5297: , 'Parent_Charge'
5291: WHEN OTHERS THEN
5292:
5293: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5294: THEN
5295: OE_MSG_PUB.Add_Exc_Msg
5296: ( G_PKG_NAME
5297: , 'Parent_Charge'
5298: );
5299: END IF;
5328: EXCEPTION
5329:
5330: WHEN NO_DATA_FOUND THEN
5331:
5332: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
5333: THEN
5334:
5335: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
5336: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','returnable');
5333: THEN
5334:
5335: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
5336: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','returnable');
5337: OE_MSG_PUB.Add;
5338:
5339: END IF;
5340:
5341: RETURN NULL;
5341: RETURN NULL;
5342:
5343: WHEN OTHERS THEN
5344:
5345: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5346: THEN
5347: OE_MSG_PUB.Add_Exc_Msg
5348: ( G_PKG_NAME
5349: , 'Returnable'
5343: WHEN OTHERS THEN
5344:
5345: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5346: THEN
5347: OE_MSG_PUB.Add_Exc_Msg
5348: ( G_PKG_NAME
5349: , 'Returnable'
5350: );
5351: END IF;
5379: EXCEPTION
5380:
5381: WHEN NO_DATA_FOUND THEN
5382:
5383: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
5384: THEN
5385:
5386: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
5387: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','tax_group');
5384: THEN
5385:
5386: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
5387: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','tax_group');
5388: OE_MSG_PUB.Add;
5389:
5390: END IF;
5391:
5392: RETURN NULL;
5392: RETURN NULL;
5393:
5394: WHEN OTHERS THEN
5395:
5396: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5397: THEN
5398: OE_MSG_PUB.Add_Exc_Msg
5399: ( G_PKG_NAME
5400: , 'Tax_Group'
5394: WHEN OTHERS THEN
5395:
5396: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5397: THEN
5398: OE_MSG_PUB.Add_Exc_Msg
5399: ( G_PKG_NAME
5400: , 'Tax_Group'
5401: );
5402: END IF;
5434: EXCEPTION
5435:
5436: WHEN NO_DATA_FOUND THEN
5437:
5438: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
5439: THEN
5440:
5441: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
5442: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','flow_status');
5439: THEN
5440:
5441: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
5442: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','flow_status');
5443: OE_MSG_PUB.Add;
5444:
5445: END IF;
5446:
5447: RETURN NULL;
5447: RETURN NULL;
5448:
5449: WHEN OTHERS THEN
5450:
5451: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5452: THEN
5453: OE_MSG_PUB.Add_Exc_Msg
5454: ( G_PKG_NAME
5455: , 'Flow_Status'
5449: WHEN OTHERS THEN
5450:
5451: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5452: THEN
5453: OE_MSG_PUB.Add_Exc_Msg
5454: ( G_PKG_NAME
5455: , 'Flow_Status'
5456: );
5457: END IF;
5497: RETURN NULL; -- Added for the bug 3554864
5498:
5499: WHEN NO_DATA_FOUND THEN
5500:
5501: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
5502: THEN
5503:
5504: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
5505: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','freight_carrier');
5502: THEN
5503:
5504: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
5505: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','freight_carrier');
5506: OE_MSG_PUB.Add;
5507:
5508: END IF;
5509:
5510: RETURN NULL;
5510: RETURN NULL;
5511:
5512: WHEN OTHERS THEN
5513:
5514: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5515: THEN
5516: OE_MSG_PUB.Add_Exc_Msg
5517: ( G_PKG_NAME
5518: , 'Freight_Carrier'
5512: WHEN OTHERS THEN
5513:
5514: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5515: THEN
5516: OE_MSG_PUB.Add_Exc_Msg
5517: ( G_PKG_NAME
5518: , 'Freight_Carrier'
5519: );
5520: END IF;
5549: EXCEPTION
5550:
5551: WHEN NO_DATA_FOUND THEN
5552:
5553: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
5554: THEN
5555:
5556: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
5557: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','sales_channel');
5554: THEN
5555:
5556: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
5557: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','sales_channel');
5558: OE_MSG_PUB.Add;
5559:
5560: END IF;
5561:
5562: RETURN NULL;
5562: RETURN NULL;
5563:
5564: WHEN OTHERS THEN
5565:
5566: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5567: THEN
5568: OE_MSG_PUB.Add_Exc_Msg
5569: ( G_PKG_NAME
5570: , 'Sales_Channel'
5564: WHEN OTHERS THEN
5565:
5566: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5567: THEN
5568: OE_MSG_PUB.Add_Exc_Msg
5569: ( G_PKG_NAME
5570: , 'Sales_Channel'
5571: );
5572: END IF;
5613: EXCEPTION
5614:
5615: WHEN NO_DATA_FOUND THEN
5616:
5617: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
5618: THEN
5619:
5620: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
5621: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ship_to_customer_name');
5618: THEN
5619:
5620: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
5621: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ship_to_customer_name');
5622: OE_MSG_PUB.Add;
5623:
5624: END IF;
5625:
5626:
5625:
5626:
5627: WHEN OTHERS THEN
5628:
5629: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5630: THEN
5631: OE_MSG_PUB.Add_Exc_Msg
5632: ( G_PKG_NAME
5633: , 'Ship_To_customer_name'
5627: WHEN OTHERS THEN
5628:
5629: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5630: THEN
5631: OE_MSG_PUB.Add_Exc_Msg
5632: ( G_PKG_NAME
5633: , 'Ship_To_customer_name'
5634: );
5635: END IF;
5676: EXCEPTION
5677:
5678: WHEN NO_DATA_FOUND THEN
5679:
5680: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
5681: THEN
5682:
5683: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
5684: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','invoice_to_customer_name');
5681: THEN
5682:
5683: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
5684: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','invoice_to_customer_name');
5685: OE_MSG_PUB.Add;
5686:
5687: END IF;
5688:
5689:
5688:
5689:
5690: WHEN OTHERS THEN
5691:
5692: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5693: THEN
5694: OE_MSG_PUB.Add_Exc_Msg
5695: ( G_PKG_NAME
5696: , 'Invoice_To_customer_name'
5690: WHEN OTHERS THEN
5691:
5692: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5693: THEN
5694: OE_MSG_PUB.Add_Exc_Msg
5695: ( G_PKG_NAME
5696: , 'Invoice_To_customer_name'
5697: );
5698: END IF;
5811: EXCEPTION
5812:
5813: WHEN NO_DATA_FOUND THEN
5814:
5815: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
5816: THEN
5817:
5818: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
5819: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Ordered_Item');
5816: THEN
5817:
5818: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
5819: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Ordered_Item');
5820: OE_MSG_PUB.Add;
5821:
5822: END IF;
5823:
5824:
5823:
5824:
5825: WHEN OTHERS THEN
5826:
5827: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5828: THEN
5829: OE_MSG_PUB.Add_Exc_Msg
5830: ( G_PKG_NAME
5831: , 'Ordered_Item'
5825: WHEN OTHERS THEN
5826:
5827: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5828: THEN
5829: OE_MSG_PUB.Add_Exc_Msg
5830: ( G_PKG_NAME
5831: , 'Ordered_Item'
5832: );
5833: END IF;
5866: EXCEPTION
5867:
5868: WHEN NO_DATA_FOUND THEN
5869:
5870: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
5871: THEN
5872:
5873: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
5874: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Item_Identifier');
5871: THEN
5872:
5873: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
5874: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Item_Identifier');
5875: OE_MSG_PUB.Add;
5876:
5877: END IF;
5878:
5879:
5878:
5879:
5880: WHEN OTHERS THEN
5881:
5882: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5883: THEN
5884: OE_MSG_PUB.Add_Exc_Msg
5885: ( G_PKG_NAME
5886: , 'Item_Identifier'
5880: WHEN OTHERS THEN
5881:
5882: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5883: THEN
5884: OE_MSG_PUB.Add_Exc_Msg
5885: ( G_PKG_NAME
5886: , 'Item_Identifier'
5887: );
5888: END IF;
5923: EXCEPTION
5924:
5925: WHEN NO_DATA_FOUND THEN
5926:
5927: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
5928: THEN
5929:
5930: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
5931: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Item_Relationship_Type');
5928: THEN
5929:
5930: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
5931: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Item_Relationship_Type');
5932: OE_MSG_PUB.Add;
5933:
5934: END IF;
5935:
5936:
5935:
5936:
5937: WHEN OTHERS THEN
5938:
5939: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5940: THEN
5941: OE_MSG_PUB.Add_Exc_Msg
5942: ( G_PKG_NAME
5943: , 'Item_Relationship_Type'
5937: WHEN OTHERS THEN
5938:
5939: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5940: THEN
5941: OE_MSG_PUB.Add_Exc_Msg
5942: ( G_PKG_NAME
5943: , 'Item_Relationship_Type'
5944: );
5945: END IF;
5981: EXCEPTION
5982:
5983: WHEN NO_DATA_FOUND THEN
5984:
5985: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
5986: THEN
5987:
5988: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
5989: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','user_status');
5986: THEN
5987:
5988: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
5989: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','user_status');
5990: OE_MSG_PUB.Add;
5991:
5992: END IF;
5993:
5994: RETURN NULL;
5994: RETURN NULL;
5995:
5996: WHEN OTHERS THEN
5997:
5998: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5999: THEN
6000: OE_MSG_PUB.Add_Exc_Msg
6001: ( G_PKG_NAME
6002: , 'user_status'
5996: WHEN OTHERS THEN
5997:
5998: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5999: THEN
6000: OE_MSG_PUB.Add_Exc_Msg
6001: ( G_PKG_NAME
6002: , 'user_status'
6003: );
6004: END IF;
6041: EXCEPTION
6042:
6043: WHEN NO_DATA_FOUND THEN
6044:
6045: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6046: THEN
6047:
6048: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
6049: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','transaction_phase');
6046: THEN
6047:
6048: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
6049: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','transaction_phase');
6050: OE_MSG_PUB.Add;
6051:
6052: END IF;
6053:
6054: RETURN NULL;
6054: RETURN NULL;
6055:
6056: WHEN OTHERS THEN
6057:
6058: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6059: THEN
6060: OE_MSG_PUB.Add_Exc_Msg
6061: ( G_PKG_NAME
6062: , 'transaction_phase'
6056: WHEN OTHERS THEN
6057:
6058: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6059: THEN
6060: OE_MSG_PUB.Add_Exc_Msg
6061: ( G_PKG_NAME
6062: , 'transaction_phase'
6063: );
6064: END IF;
6137: EXCEPTION
6138:
6139: WHEN NO_DATA_FOUND THEN
6140:
6141: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6142: THEN
6143:
6144: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
6145: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Customer_Location');
6142: THEN
6143:
6144: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
6145: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Customer_Location');
6146: OE_MSG_PUB.Add;
6147:
6148: END IF;
6149:
6150:
6149:
6150:
6151: WHEN OTHERS THEN
6152:
6153: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6154: THEN
6155: OE_MSG_PUB.Add_Exc_Msg
6156: ( G_PKG_NAME
6157: , 'Customer_Location'
6151: WHEN OTHERS THEN
6152:
6153: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6154: THEN
6155: OE_MSG_PUB.Add_Exc_Msg
6156: ( G_PKG_NAME
6157: , 'Customer_Location'
6158: );
6159: END IF;
6238: EXCEPTION
6239:
6240: WHEN NO_DATA_FOUND THEN
6241:
6242: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6243: THEN
6244:
6245: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
6246: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','payment_collection_event_name');
6243: THEN
6244:
6245: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
6246: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','payment_collection_event_name');
6247: OE_MSG_PUB.Add;
6248:
6249: END IF;
6250:
6251:
6250:
6251:
6252: WHEN OTHERS THEN
6253:
6254: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6255: THEN
6256: OE_MSG_PUB.Add_Exc_Msg
6257: ( G_PKG_NAME
6258: , 'payment_collection_event_name'
6252: WHEN OTHERS THEN
6253:
6254: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6255: THEN
6256: OE_MSG_PUB.Add_Exc_Msg
6257: ( G_PKG_NAME
6258: , 'payment_collection_event_name'
6259: );
6260: END IF;
6290: IF l_debug_level > 0 THEN
6291: oe_debug_pub.add('Inside else part....');
6292: END IF;
6293: fnd_message.set_name('ONT','OE_VPM_NO_PAY_METHOD');
6294: OE_MSG_PUB.Add;
6295: RAISE FND_API.G_EXC_ERROR;
6296: END IF;
6297:
6298: RETURN l_receipt_method;
6300: EXCEPTION
6301:
6302: WHEN NO_DATA_FOUND THEN
6303:
6304: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6305: THEN
6306:
6307: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
6308: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Receipt_Method');
6305: THEN
6306:
6307: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
6308: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Receipt_Method');
6309: OE_MSG_PUB.Add;
6310:
6311: END IF;
6312:
6313: WHEN FND_API.G_EXC_ERROR THEN
6320: RAISE FND_API.G_EXC_ERROR;
6321:
6322: WHEN OTHERS THEN
6323:
6324: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6325: THEN
6326: OE_MSG_PUB.Add_Exc_Msg
6327: ( G_PKG_NAME
6328: , 'Receipt_Method'
6322: WHEN OTHERS THEN
6323:
6324: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6325: THEN
6326: OE_MSG_PUB.Add_Exc_Msg
6327: ( G_PKG_NAME
6328: , 'Receipt_Method'
6329: );
6330: END IF;
6354: EXCEPTION
6355:
6356: WHEN NO_DATA_FOUND THEN
6357: IF p_sales_group_id <> -1 THEN
6358: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6359: THEN
6360:
6361: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
6362: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','sales_group_name');
6359: THEN
6360:
6361: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
6362: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','sales_group_name');
6363: OE_MSG_PUB.Add;
6364:
6365: END IF;
6366: ELSE
6367: oe_debug_pub.add('Sales Group, -1 sales group id');
6369:
6370:
6371: WHEN OTHERS THEN
6372:
6373: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6374: THEN
6375: OE_MSG_PUB.Add_Exc_Msg
6376: ( G_PKG_NAME
6377: , 'sales_group_name'
6371: WHEN OTHERS THEN
6372:
6373: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6374: THEN
6375: OE_MSG_PUB.Add_Exc_Msg
6376: ( G_PKG_NAME
6377: , 'sales_group_name'
6378: );
6379: END IF;
6406: EXCEPTION
6407:
6408: WHEN NO_DATA_FOUND THEN
6409:
6410: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6411: THEN
6412:
6413: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
6414: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','end_customer_contact');
6411: THEN
6412:
6413: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
6414: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','end_customer_contact');
6415: OE_MSG_PUB.Add;
6416:
6417: END IF;
6418:
6419: RETURN NULL;
6419: RETURN NULL;
6420:
6421: WHEN OTHERS THEN
6422:
6423: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6424: THEN
6425: OE_MSG_PUB.Add_Exc_Msg
6426: ( G_PKG_NAME
6427: , 'End_Customer_Contact'
6421: WHEN OTHERS THEN
6422:
6423: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6424: THEN
6425: OE_MSG_PUB.Add_Exc_Msg
6426: ( G_PKG_NAME
6427: , 'End_Customer_Contact'
6428: );
6429: END IF;
6468: EXCEPTION
6469:
6470: WHEN NO_DATA_FOUND THEN
6471:
6472: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6473: THEN
6474:
6475: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
6476: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','end_customer');
6473: THEN
6474:
6475: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
6476: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','end_customer');
6477: OE_MSG_PUB.Add;
6478:
6479: END IF;
6480:
6481:
6480:
6481:
6482: WHEN OTHERS THEN
6483:
6484: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6485: THEN
6486: OE_MSG_PUB.Add_Exc_Msg
6487: ( G_PKG_NAME
6488: , 'end_customer'
6482: WHEN OTHERS THEN
6483:
6484: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6485: THEN
6486: OE_MSG_PUB.Add_Exc_Msg
6487: ( G_PKG_NAME
6488: , 'end_customer'
6489: );
6490: END IF;
6559: EXCEPTION
6560:
6561: WHEN NO_DATA_FOUND THEN
6562:
6563: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6564: THEN
6565:
6566: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
6567: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','end_customer_site');
6564: THEN
6565:
6566: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
6567: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','end_customer_site');
6568: OE_MSG_PUB.Add;
6569:
6570: END IF;
6571:
6572:
6571:
6572:
6573: WHEN OTHERS THEN
6574:
6575: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6576: THEN
6577: OE_MSG_PUB.Add_Exc_Msg
6578: ( G_PKG_NAME
6579: , 'end_customer_site_use'
6573: WHEN OTHERS THEN
6574:
6575: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6576: THEN
6577: OE_MSG_PUB.Add_Exc_Msg
6578: ( G_PKG_NAME
6579: , 'end_customer_site_use'
6580: );
6581: END IF;
6613: EXCEPTION
6614:
6615: WHEN NO_DATA_FOUND THEN
6616:
6617: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6618: THEN
6619:
6620: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
6621: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','IB_OWNER');
6618: THEN
6619:
6620: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
6621: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','IB_OWNER');
6622: OE_MSG_PUB.Add;
6623:
6624: END IF;
6625:
6626: RETURN NULL;
6626: RETURN NULL;
6627:
6628: WHEN OTHERS THEN
6629:
6630: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6631: THEN
6632: OE_MSG_PUB.Add_Exc_Msg
6633: ( G_PKG_NAME
6634: , 'IB_OWNER'
6628: WHEN OTHERS THEN
6629:
6630: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6631: THEN
6632: OE_MSG_PUB.Add_Exc_Msg
6633: ( G_PKG_NAME
6634: , 'IB_OWNER'
6635: );
6636: END IF;
6666: EXCEPTION
6667:
6668: WHEN NO_DATA_FOUND THEN
6669:
6670: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6671: THEN
6672:
6673: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
6674: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','IB_CURRENT_LOCATION');
6671: THEN
6672:
6673: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
6674: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','IB_CURRENT_LOCATION');
6675: OE_MSG_PUB.Add;
6676:
6677: END IF;
6678:
6679: RETURN NULL;
6679: RETURN NULL;
6680:
6681: WHEN OTHERS THEN
6682:
6683: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6684: THEN
6685: OE_MSG_PUB.Add_Exc_Msg
6686: ( G_PKG_NAME
6687: , 'IB_CURRENT_LOCATION'
6681: WHEN OTHERS THEN
6682:
6683: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6684: THEN
6685: OE_MSG_PUB.Add_Exc_Msg
6686: ( G_PKG_NAME
6687: , 'IB_CURRENT_LOCATION'
6688: );
6689: END IF;
6719: EXCEPTION
6720:
6721: WHEN NO_DATA_FOUND THEN
6722:
6723: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6724: THEN
6725:
6726: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
6727: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','IB_INSTALLED_AT_LOCATION');
6724: THEN
6725:
6726: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
6727: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','IB_INSTALLED_AT_LOCATION');
6728: OE_MSG_PUB.Add;
6729:
6730: END IF;
6731:
6732: RETURN NULL;
6732: RETURN NULL;
6733:
6734: WHEN OTHERS THEN
6735:
6736: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6737: THEN
6738: OE_MSG_PUB.Add_Exc_Msg
6739: ( G_PKG_NAME
6740: , 'IB_INSTALLED_AT_LOCATION'
6734: WHEN OTHERS THEN
6735:
6736: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6737: THEN
6738: OE_MSG_PUB.Add_Exc_Msg
6739: ( G_PKG_NAME
6740: , 'IB_INSTALLED_AT_LOCATION'
6741: );
6742: END IF;
6774: EXCEPTION
6775:
6776: WHEN NO_DATA_FOUND THEN
6777:
6778: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6779: THEN
6780:
6781: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
6782: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','CHARGE_PERIODICITY_CODE');
6779: THEN
6780:
6781: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
6782: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','CHARGE_PERIODICITY_CODE');
6783: OE_MSG_PUB.Add;
6784:
6785: END IF;
6786:
6787: RETURN NULL;
6787: RETURN NULL;
6788:
6789: WHEN OTHERS THEN
6790:
6791: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6792: THEN
6793: OE_MSG_PUB.Add_Exc_Msg
6794: ( G_PKG_NAME
6795: , 'CHARGE_PERIODICITY'
6789: WHEN OTHERS THEN
6790:
6791: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6792: THEN
6793: OE_MSG_PUB.Add_Exc_Msg
6794: ( G_PKG_NAME
6795: , 'CHARGE_PERIODICITY'
6796: );
6797: END IF;
6821: FROM MTL_SYSTEM_ITEMS_B
6822: WHERE inventory_item_id = p_inventory_item_id
6823: AND organization_id = OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
6824:
6825: --OE_MSG_PUB.ADD_TEXT('l_temp' || l_temp);
6826: IF l_temp = 'Y' THEN
6827: --webroot bug 6826344 end
6828:
6829: Select description
6833: and inventory_item_id = p_inventory_item_id
6834: and organization_id = OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
6835: END IF;
6836:
6837: --OE_MSG_PUB.ADD_TEXT('l_service_period_dsp'|| l_service_period_dsp);
6838: END IF;
6839:
6840: RETURN l_service_period_dsp;
6841:
6842: EXCEPTION
6843:
6844: WHEN NO_DATA_FOUND THEN
6845:
6846: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6847: THEN
6848:
6849: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
6850: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','SERVICE_PERIOD');
6847: THEN
6848:
6849: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
6850: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','SERVICE_PERIOD');
6851: OE_MSG_PUB.Add;
6852:
6853: END IF;
6854:
6855: RETURN NULL;
6855: RETURN NULL;
6856:
6857: WHEN OTHERS THEN
6858:
6859: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6860: THEN
6861: OE_MSG_PUB.Add_Exc_Msg
6862: ( G_PKG_NAME
6863: , 'SERVICE_PERIOD'
6857: WHEN OTHERS THEN
6858:
6859: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6860: THEN
6861: OE_MSG_PUB.Add_Exc_Msg
6862: ( G_PKG_NAME
6863: , 'SERVICE_PERIOD'
6864: );
6865: END IF;
6893: EXCEPTION
6894:
6895: WHEN NO_DATA_FOUND THEN
6896:
6897: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6898: THEN
6899:
6900: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
6901: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','SERVICE_REFERENCE_TYPE');
6898: THEN
6899:
6900: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
6901: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','SERVICE_REFERENCE_TYPE');
6902: OE_MSG_PUB.Add;
6903:
6904: END IF;
6905:
6906: RETURN NULL;
6906: RETURN NULL;
6907:
6908: WHEN OTHERS THEN
6909:
6910: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6911: THEN
6912: OE_MSG_PUB.Add_Exc_Msg
6913: ( G_PKG_NAME
6914: , 'SERVICE_REFERENCE_TYPE'
6908: WHEN OTHERS THEN
6909:
6910: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6911: THEN
6912: OE_MSG_PUB.Add_Exc_Msg
6913: ( G_PKG_NAME
6914: , 'SERVICE_REFERENCE_TYPE'
6915: );
6916: END IF;
6950: EXCEPTION
6951:
6952: WHEN NO_DATA_FOUND THEN
6953:
6954: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6955: THEN
6956:
6957: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
6958: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','CHANGE_CODE');
6955: THEN
6956:
6957: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
6958: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','CHANGE_CODE');
6959: OE_MSG_PUB.Add;
6960:
6961: END IF;
6962:
6963: RETURN NULL;
6963: RETURN NULL;
6964:
6965: WHEN OTHERS THEN
6966:
6967: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6968: THEN
6969: OE_MSG_PUB.Add_Exc_Msg
6970: ( G_PKG_NAME
6971: , 'CHANGE_CODE'
6965: WHEN OTHERS THEN
6966:
6967: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6968: THEN
6969: OE_MSG_PUB.Add_Exc_Msg
6970: ( G_PKG_NAME
6971: , 'CHANGE_CODE'
6972: );
6973: END IF;
7019: EXCEPTION
7020:
7021: WHEN NO_DATA_FOUND THEN
7022:
7023: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
7024: THEN
7025:
7026: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
7027: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','CONTINGENCY_ID');
7024: THEN
7025:
7026: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
7027: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','CONTINGENCY_ID');
7028: OE_MSG_PUB.Add;
7029:
7030: END IF;
7031:
7032: WHEN OTHERS THEN
7030: END IF;
7031:
7032: WHEN OTHERS THEN
7033:
7034: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7035: THEN
7036: OE_MSG_PUB.Add_Exc_Msg
7037: ( G_PKG_NAME
7038: , 'Get_Contingency_Attributes'
7032: WHEN OTHERS THEN
7033:
7034: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7035: THEN
7036: OE_MSG_PUB.Add_Exc_Msg
7037: ( G_PKG_NAME
7038: , 'Get_Contingency_Attributes'
7039: );
7040: END IF;
7066: EXCEPTION
7067:
7068: WHEN NO_DATA_FOUND THEN
7069:
7070: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
7071: THEN
7072:
7073: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
7074: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','REVREC_EVENT_CODE');
7071: THEN
7072:
7073: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
7074: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','REVREC_EVENT_CODE');
7075: OE_MSG_PUB.Add;
7076:
7077: END IF;
7078:
7079: RETURN NULL;
7079: RETURN NULL;
7080:
7081: WHEN OTHERS THEN
7082:
7083: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7084: THEN
7085: OE_MSG_PUB.Add_Exc_Msg
7086: ( G_PKG_NAME
7087: , 'Revrec_Event'
7081: WHEN OTHERS THEN
7082:
7083: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7084: THEN
7085: OE_MSG_PUB.Add_Exc_Msg
7086: ( G_PKG_NAME
7087: , 'Revrec_Event'
7088: );
7089: END IF;
7114: EXCEPTION
7115:
7116: WHEN NO_DATA_FOUND THEN
7117:
7118: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
7119: THEN
7120:
7121: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
7122: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ACCEPTED_BY');
7119: THEN
7120:
7121: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
7122: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ACCEPTED_BY');
7123: OE_MSG_PUB.Add;
7124:
7125: END IF;
7126:
7127: RETURN NULL;
7127: RETURN NULL;
7128:
7129: WHEN OTHERS THEN
7130:
7131: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7132: THEN
7133: OE_MSG_PUB.Add_Exc_Msg
7134: ( G_PKG_NAME
7135: , 'Accepted_By'
7129: WHEN OTHERS THEN
7130:
7131: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7132: THEN
7133: OE_MSG_PUB.Add_Exc_Msg
7134: ( G_PKG_NAME
7135: , 'Accepted_By'
7136: );
7137: END IF;