[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;
5836: EXCEPTION
5837:
5838: WHEN NO_DATA_FOUND THEN
5839:
5840: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
5841: THEN
5842:
5843: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
5844: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Ordered_Item');
5841: THEN
5842:
5843: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
5844: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Ordered_Item');
5845: OE_MSG_PUB.Add;
5846:
5847: END IF;
5848:
5849:
5848:
5849:
5850: WHEN OTHERS THEN
5851:
5852: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5853: THEN
5854: OE_MSG_PUB.Add_Exc_Msg
5855: ( G_PKG_NAME
5856: , 'Ordered_Item'
5850: WHEN OTHERS THEN
5851:
5852: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5853: THEN
5854: OE_MSG_PUB.Add_Exc_Msg
5855: ( G_PKG_NAME
5856: , 'Ordered_Item'
5857: );
5858: END IF;
5892: EXCEPTION
5893:
5894: WHEN NO_DATA_FOUND THEN
5895:
5896: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
5897: THEN
5898:
5899: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
5900: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Item_Identifier');
5897: THEN
5898:
5899: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
5900: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Item_Identifier');
5901: OE_MSG_PUB.Add;
5902:
5903: END IF;
5904:
5905:
5904:
5905:
5906: WHEN OTHERS THEN
5907:
5908: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5909: THEN
5910: OE_MSG_PUB.Add_Exc_Msg
5911: ( G_PKG_NAME
5912: , 'Item_Identifier'
5906: WHEN OTHERS THEN
5907:
5908: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5909: THEN
5910: OE_MSG_PUB.Add_Exc_Msg
5911: ( G_PKG_NAME
5912: , 'Item_Identifier'
5913: );
5914: END IF;
5949: EXCEPTION
5950:
5951: WHEN NO_DATA_FOUND THEN
5952:
5953: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
5954: THEN
5955:
5956: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
5957: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Item_Relationship_Type');
5954: THEN
5955:
5956: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
5957: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Item_Relationship_Type');
5958: OE_MSG_PUB.Add;
5959:
5960: END IF;
5961:
5962:
5961:
5962:
5963: WHEN OTHERS THEN
5964:
5965: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5966: THEN
5967: OE_MSG_PUB.Add_Exc_Msg
5968: ( G_PKG_NAME
5969: , 'Item_Relationship_Type'
5963: WHEN OTHERS THEN
5964:
5965: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5966: THEN
5967: OE_MSG_PUB.Add_Exc_Msg
5968: ( G_PKG_NAME
5969: , 'Item_Relationship_Type'
5970: );
5971: END IF;
6007: EXCEPTION
6008:
6009: WHEN NO_DATA_FOUND THEN
6010:
6011: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6012: THEN
6013:
6014: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
6015: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','user_status');
6012: THEN
6013:
6014: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
6015: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','user_status');
6016: OE_MSG_PUB.Add;
6017:
6018: END IF;
6019:
6020: RETURN NULL;
6020: RETURN NULL;
6021:
6022: WHEN OTHERS THEN
6023:
6024: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6025: THEN
6026: OE_MSG_PUB.Add_Exc_Msg
6027: ( G_PKG_NAME
6028: , 'user_status'
6022: WHEN OTHERS THEN
6023:
6024: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6025: THEN
6026: OE_MSG_PUB.Add_Exc_Msg
6027: ( G_PKG_NAME
6028: , 'user_status'
6029: );
6030: END IF;
6067: EXCEPTION
6068:
6069: WHEN NO_DATA_FOUND THEN
6070:
6071: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6072: THEN
6073:
6074: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
6075: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','transaction_phase');
6072: THEN
6073:
6074: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
6075: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','transaction_phase');
6076: OE_MSG_PUB.Add;
6077:
6078: END IF;
6079:
6080: RETURN NULL;
6080: RETURN NULL;
6081:
6082: WHEN OTHERS THEN
6083:
6084: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6085: THEN
6086: OE_MSG_PUB.Add_Exc_Msg
6087: ( G_PKG_NAME
6088: , 'transaction_phase'
6082: WHEN OTHERS THEN
6083:
6084: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6085: THEN
6086: OE_MSG_PUB.Add_Exc_Msg
6087: ( G_PKG_NAME
6088: , 'transaction_phase'
6089: );
6090: END IF;
6163: EXCEPTION
6164:
6165: WHEN NO_DATA_FOUND THEN
6166:
6167: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6168: THEN
6169:
6170: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
6171: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Customer_Location');
6168: THEN
6169:
6170: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
6171: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Customer_Location');
6172: OE_MSG_PUB.Add;
6173:
6174: END IF;
6175:
6176:
6175:
6176:
6177: WHEN OTHERS THEN
6178:
6179: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6180: THEN
6181: OE_MSG_PUB.Add_Exc_Msg
6182: ( G_PKG_NAME
6183: , 'Customer_Location'
6177: WHEN OTHERS THEN
6178:
6179: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6180: THEN
6181: OE_MSG_PUB.Add_Exc_Msg
6182: ( G_PKG_NAME
6183: , 'Customer_Location'
6184: );
6185: END IF;
6264: EXCEPTION
6265:
6266: WHEN NO_DATA_FOUND THEN
6267:
6268: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6269: THEN
6270:
6271: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
6272: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','payment_collection_event_name');
6269: THEN
6270:
6271: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
6272: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','payment_collection_event_name');
6273: OE_MSG_PUB.Add;
6274:
6275: END IF;
6276:
6277:
6276:
6277:
6278: WHEN OTHERS THEN
6279:
6280: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6281: THEN
6282: OE_MSG_PUB.Add_Exc_Msg
6283: ( G_PKG_NAME
6284: , 'payment_collection_event_name'
6278: WHEN OTHERS THEN
6279:
6280: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6281: THEN
6282: OE_MSG_PUB.Add_Exc_Msg
6283: ( G_PKG_NAME
6284: , 'payment_collection_event_name'
6285: );
6286: END IF;
6316: IF l_debug_level > 0 THEN
6317: oe_debug_pub.add('Inside else part....');
6318: END IF;
6319: fnd_message.set_name('ONT','OE_VPM_NO_PAY_METHOD');
6320: OE_MSG_PUB.Add;
6321: RAISE FND_API.G_EXC_ERROR;
6322: END IF;
6323:
6324: RETURN l_receipt_method;
6326: EXCEPTION
6327:
6328: WHEN NO_DATA_FOUND THEN
6329:
6330: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6331: THEN
6332:
6333: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
6334: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Receipt_Method');
6331: THEN
6332:
6333: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
6334: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Receipt_Method');
6335: OE_MSG_PUB.Add;
6336:
6337: END IF;
6338:
6339: WHEN FND_API.G_EXC_ERROR THEN
6346: RAISE FND_API.G_EXC_ERROR;
6347:
6348: WHEN OTHERS THEN
6349:
6350: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6351: THEN
6352: OE_MSG_PUB.Add_Exc_Msg
6353: ( G_PKG_NAME
6354: , 'Receipt_Method'
6348: WHEN OTHERS THEN
6349:
6350: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6351: THEN
6352: OE_MSG_PUB.Add_Exc_Msg
6353: ( G_PKG_NAME
6354: , 'Receipt_Method'
6355: );
6356: END IF;
6380: EXCEPTION
6381:
6382: WHEN NO_DATA_FOUND THEN
6383: IF p_sales_group_id <> -1 THEN
6384: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6385: THEN
6386:
6387: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
6388: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','sales_group_name');
6385: THEN
6386:
6387: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
6388: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','sales_group_name');
6389: OE_MSG_PUB.Add;
6390:
6391: END IF;
6392: ELSE
6393: oe_debug_pub.add('Sales Group, -1 sales group id');
6395:
6396:
6397: WHEN OTHERS THEN
6398:
6399: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6400: THEN
6401: OE_MSG_PUB.Add_Exc_Msg
6402: ( G_PKG_NAME
6403: , 'sales_group_name'
6397: WHEN OTHERS THEN
6398:
6399: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6400: THEN
6401: OE_MSG_PUB.Add_Exc_Msg
6402: ( G_PKG_NAME
6403: , 'sales_group_name'
6404: );
6405: END IF;
6432: EXCEPTION
6433:
6434: WHEN NO_DATA_FOUND THEN
6435:
6436: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6437: THEN
6438:
6439: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
6440: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','end_customer_contact');
6437: THEN
6438:
6439: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
6440: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','end_customer_contact');
6441: OE_MSG_PUB.Add;
6442:
6443: END IF;
6444:
6445: RETURN NULL;
6445: RETURN NULL;
6446:
6447: WHEN OTHERS THEN
6448:
6449: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6450: THEN
6451: OE_MSG_PUB.Add_Exc_Msg
6452: ( G_PKG_NAME
6453: , 'End_Customer_Contact'
6447: WHEN OTHERS THEN
6448:
6449: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6450: THEN
6451: OE_MSG_PUB.Add_Exc_Msg
6452: ( G_PKG_NAME
6453: , 'End_Customer_Contact'
6454: );
6455: END IF;
6494: EXCEPTION
6495:
6496: WHEN NO_DATA_FOUND THEN
6497:
6498: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6499: THEN
6500:
6501: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
6502: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','end_customer');
6499: THEN
6500:
6501: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
6502: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','end_customer');
6503: OE_MSG_PUB.Add;
6504:
6505: END IF;
6506:
6507:
6506:
6507:
6508: WHEN OTHERS THEN
6509:
6510: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6511: THEN
6512: OE_MSG_PUB.Add_Exc_Msg
6513: ( G_PKG_NAME
6514: , 'end_customer'
6508: WHEN OTHERS THEN
6509:
6510: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6511: THEN
6512: OE_MSG_PUB.Add_Exc_Msg
6513: ( G_PKG_NAME
6514: , 'end_customer'
6515: );
6516: END IF;
6585: EXCEPTION
6586:
6587: WHEN NO_DATA_FOUND THEN
6588:
6589: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6590: THEN
6591:
6592: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
6593: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','end_customer_site');
6590: THEN
6591:
6592: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
6593: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','end_customer_site');
6594: OE_MSG_PUB.Add;
6595:
6596: END IF;
6597:
6598:
6597:
6598:
6599: WHEN OTHERS THEN
6600:
6601: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6602: THEN
6603: OE_MSG_PUB.Add_Exc_Msg
6604: ( G_PKG_NAME
6605: , 'end_customer_site_use'
6599: WHEN OTHERS THEN
6600:
6601: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6602: THEN
6603: OE_MSG_PUB.Add_Exc_Msg
6604: ( G_PKG_NAME
6605: , 'end_customer_site_use'
6606: );
6607: END IF;
6639: EXCEPTION
6640:
6641: WHEN NO_DATA_FOUND THEN
6642:
6643: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6644: THEN
6645:
6646: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
6647: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','IB_OWNER');
6644: THEN
6645:
6646: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
6647: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','IB_OWNER');
6648: OE_MSG_PUB.Add;
6649:
6650: END IF;
6651:
6652: RETURN NULL;
6652: RETURN NULL;
6653:
6654: WHEN OTHERS THEN
6655:
6656: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6657: THEN
6658: OE_MSG_PUB.Add_Exc_Msg
6659: ( G_PKG_NAME
6660: , 'IB_OWNER'
6654: WHEN OTHERS THEN
6655:
6656: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6657: THEN
6658: OE_MSG_PUB.Add_Exc_Msg
6659: ( G_PKG_NAME
6660: , 'IB_OWNER'
6661: );
6662: END IF;
6692: EXCEPTION
6693:
6694: WHEN NO_DATA_FOUND THEN
6695:
6696: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6697: THEN
6698:
6699: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
6700: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','IB_CURRENT_LOCATION');
6697: THEN
6698:
6699: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
6700: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','IB_CURRENT_LOCATION');
6701: OE_MSG_PUB.Add;
6702:
6703: END IF;
6704:
6705: RETURN NULL;
6705: RETURN NULL;
6706:
6707: WHEN OTHERS THEN
6708:
6709: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6710: THEN
6711: OE_MSG_PUB.Add_Exc_Msg
6712: ( G_PKG_NAME
6713: , 'IB_CURRENT_LOCATION'
6707: WHEN OTHERS THEN
6708:
6709: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6710: THEN
6711: OE_MSG_PUB.Add_Exc_Msg
6712: ( G_PKG_NAME
6713: , 'IB_CURRENT_LOCATION'
6714: );
6715: END IF;
6745: EXCEPTION
6746:
6747: WHEN NO_DATA_FOUND THEN
6748:
6749: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6750: THEN
6751:
6752: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
6753: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','IB_INSTALLED_AT_LOCATION');
6750: THEN
6751:
6752: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
6753: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','IB_INSTALLED_AT_LOCATION');
6754: OE_MSG_PUB.Add;
6755:
6756: END IF;
6757:
6758: RETURN NULL;
6758: RETURN NULL;
6759:
6760: WHEN OTHERS THEN
6761:
6762: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6763: THEN
6764: OE_MSG_PUB.Add_Exc_Msg
6765: ( G_PKG_NAME
6766: , 'IB_INSTALLED_AT_LOCATION'
6760: WHEN OTHERS THEN
6761:
6762: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6763: THEN
6764: OE_MSG_PUB.Add_Exc_Msg
6765: ( G_PKG_NAME
6766: , 'IB_INSTALLED_AT_LOCATION'
6767: );
6768: END IF;
6800: EXCEPTION
6801:
6802: WHEN NO_DATA_FOUND THEN
6803:
6804: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6805: THEN
6806:
6807: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
6808: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','CHARGE_PERIODICITY_CODE');
6805: THEN
6806:
6807: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
6808: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','CHARGE_PERIODICITY_CODE');
6809: OE_MSG_PUB.Add;
6810:
6811: END IF;
6812:
6813: RETURN NULL;
6813: RETURN NULL;
6814:
6815: WHEN OTHERS THEN
6816:
6817: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6818: THEN
6819: OE_MSG_PUB.Add_Exc_Msg
6820: ( G_PKG_NAME
6821: , 'CHARGE_PERIODICITY'
6815: WHEN OTHERS THEN
6816:
6817: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6818: THEN
6819: OE_MSG_PUB.Add_Exc_Msg
6820: ( G_PKG_NAME
6821: , 'CHARGE_PERIODICITY'
6822: );
6823: END IF;
6847: FROM MTL_SYSTEM_ITEMS_B
6848: WHERE inventory_item_id = p_inventory_item_id
6849: AND organization_id = OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
6850:
6851: --OE_MSG_PUB.ADD_TEXT('l_temp' || l_temp);
6852: IF l_temp = 'Y' THEN
6853: --webroot bug 6826344 end
6854:
6855: Select description
6859: and inventory_item_id = p_inventory_item_id
6860: and organization_id = OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
6861: END IF;
6862:
6863: --OE_MSG_PUB.ADD_TEXT('l_service_period_dsp'|| l_service_period_dsp);
6864: END IF;
6865:
6866: RETURN l_service_period_dsp;
6867:
6868: EXCEPTION
6869:
6870: WHEN NO_DATA_FOUND THEN
6871:
6872: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6873: THEN
6874:
6875: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
6876: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','SERVICE_PERIOD');
6873: THEN
6874:
6875: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
6876: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','SERVICE_PERIOD');
6877: OE_MSG_PUB.Add;
6878:
6879: END IF;
6880:
6881: RETURN NULL;
6881: RETURN NULL;
6882:
6883: WHEN OTHERS THEN
6884:
6885: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6886: THEN
6887: OE_MSG_PUB.Add_Exc_Msg
6888: ( G_PKG_NAME
6889: , 'SERVICE_PERIOD'
6883: WHEN OTHERS THEN
6884:
6885: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6886: THEN
6887: OE_MSG_PUB.Add_Exc_Msg
6888: ( G_PKG_NAME
6889: , 'SERVICE_PERIOD'
6890: );
6891: END IF;
6919: EXCEPTION
6920:
6921: WHEN NO_DATA_FOUND THEN
6922:
6923: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6924: THEN
6925:
6926: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
6927: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','SERVICE_REFERENCE_TYPE');
6924: THEN
6925:
6926: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
6927: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','SERVICE_REFERENCE_TYPE');
6928: OE_MSG_PUB.Add;
6929:
6930: END IF;
6931:
6932: RETURN NULL;
6932: RETURN NULL;
6933:
6934: WHEN OTHERS THEN
6935:
6936: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6937: THEN
6938: OE_MSG_PUB.Add_Exc_Msg
6939: ( G_PKG_NAME
6940: , 'SERVICE_REFERENCE_TYPE'
6934: WHEN OTHERS THEN
6935:
6936: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6937: THEN
6938: OE_MSG_PUB.Add_Exc_Msg
6939: ( G_PKG_NAME
6940: , 'SERVICE_REFERENCE_TYPE'
6941: );
6942: END IF;
6976: EXCEPTION
6977:
6978: WHEN NO_DATA_FOUND THEN
6979:
6980: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6981: THEN
6982:
6983: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
6984: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','CHANGE_CODE');
6981: THEN
6982:
6983: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
6984: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','CHANGE_CODE');
6985: OE_MSG_PUB.Add;
6986:
6987: END IF;
6988:
6989: RETURN NULL;
6989: RETURN NULL;
6990:
6991: WHEN OTHERS THEN
6992:
6993: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6994: THEN
6995: OE_MSG_PUB.Add_Exc_Msg
6996: ( G_PKG_NAME
6997: , 'CHANGE_CODE'
6991: WHEN OTHERS THEN
6992:
6993: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6994: THEN
6995: OE_MSG_PUB.Add_Exc_Msg
6996: ( G_PKG_NAME
6997: , 'CHANGE_CODE'
6998: );
6999: END IF;
7045: EXCEPTION
7046:
7047: WHEN NO_DATA_FOUND THEN
7048:
7049: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
7050: THEN
7051:
7052: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
7053: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','CONTINGENCY_ID');
7050: THEN
7051:
7052: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
7053: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','CONTINGENCY_ID');
7054: OE_MSG_PUB.Add;
7055:
7056: END IF;
7057:
7058: WHEN OTHERS THEN
7056: END IF;
7057:
7058: WHEN OTHERS THEN
7059:
7060: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7061: THEN
7062: OE_MSG_PUB.Add_Exc_Msg
7063: ( G_PKG_NAME
7064: , 'Get_Contingency_Attributes'
7058: WHEN OTHERS THEN
7059:
7060: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7061: THEN
7062: OE_MSG_PUB.Add_Exc_Msg
7063: ( G_PKG_NAME
7064: , 'Get_Contingency_Attributes'
7065: );
7066: END IF;
7092: EXCEPTION
7093:
7094: WHEN NO_DATA_FOUND THEN
7095:
7096: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
7097: THEN
7098:
7099: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
7100: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','REVREC_EVENT_CODE');
7097: THEN
7098:
7099: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
7100: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','REVREC_EVENT_CODE');
7101: OE_MSG_PUB.Add;
7102:
7103: END IF;
7104:
7105: RETURN NULL;
7105: RETURN NULL;
7106:
7107: WHEN OTHERS THEN
7108:
7109: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7110: THEN
7111: OE_MSG_PUB.Add_Exc_Msg
7112: ( G_PKG_NAME
7113: , 'Revrec_Event'
7107: WHEN OTHERS THEN
7108:
7109: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7110: THEN
7111: OE_MSG_PUB.Add_Exc_Msg
7112: ( G_PKG_NAME
7113: , 'Revrec_Event'
7114: );
7115: END IF;
7140: EXCEPTION
7141:
7142: WHEN NO_DATA_FOUND THEN
7143:
7144: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
7145: THEN
7146:
7147: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
7148: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ACCEPTED_BY');
7145: THEN
7146:
7147: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
7148: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ACCEPTED_BY');
7149: OE_MSG_PUB.Add;
7150:
7151: END IF;
7152:
7153: RETURN NULL;
7153: RETURN NULL;
7154:
7155: WHEN OTHERS THEN
7156:
7157: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7158: THEN
7159: OE_MSG_PUB.Add_Exc_Msg
7160: ( G_PKG_NAME
7161: , 'Accepted_By'
7155: WHEN OTHERS THEN
7156:
7157: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7158: THEN
7159: OE_MSG_PUB.Add_Exc_Msg
7160: ( G_PKG_NAME
7161: , 'Accepted_By'
7162: );
7163: END IF;
7184: END IF;
7185: RETURN l_billing_profile;
7186: EXCEPTION
7187: WHEN NO_DATA_FOUND THEN
7188: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
7189: THEN
7190: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
7191: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','BILLING_PROFILE');
7192: OE_MSG_PUB.Add;
7188: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
7189: THEN
7190: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
7191: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','BILLING_PROFILE');
7192: OE_MSG_PUB.Add;
7193: END IF;
7194: RETURN NULL;
7195: WHEN OTHERS THEN
7196: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7192: OE_MSG_PUB.Add;
7193: END IF;
7194: RETURN NULL;
7195: WHEN OTHERS THEN
7196: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7197: THEN
7198: OE_MSG_PUB.Add_Exc_Msg
7199: ( G_PKG_NAME
7200: , 'BILLING_PROFILE'
7194: RETURN NULL;
7195: WHEN OTHERS THEN
7196: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7197: THEN
7198: OE_MSG_PUB.Add_Exc_Msg
7199: ( G_PKG_NAME
7200: , 'BILLING_PROFILE'
7201: );
7202: END IF;
7219: END IF;
7220: RETURN l_Billing_Option;
7221: EXCEPTION
7222: WHEN NO_DATA_FOUND THEN
7223: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
7224: THEN
7225: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
7226: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Billing_Option');
7227: OE_MSG_PUB.Add;
7223: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
7224: THEN
7225: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
7226: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Billing_Option');
7227: OE_MSG_PUB.Add;
7228: END IF;
7229: RETURN NULL;
7230: WHEN OTHERS THEN
7231: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7227: OE_MSG_PUB.Add;
7228: END IF;
7229: RETURN NULL;
7230: WHEN OTHERS THEN
7231: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7232: THEN
7233: OE_MSG_PUB.Add_Exc_Msg
7234: ( G_PKG_NAME
7235: , 'Billing_Option'
7229: RETURN NULL;
7230: WHEN OTHERS THEN
7231: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7232: THEN
7233: OE_MSG_PUB.Add_Exc_Msg
7234: ( G_PKG_NAME
7235: , 'Billing_Option'
7236: );
7237: END IF;
7255: END IF;
7256: RETURN l_Subscription_Template;
7257: EXCEPTION
7258: WHEN NO_DATA_FOUND THEN
7259: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
7260: THEN
7261: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
7262: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Subscription_Template');
7263: OE_MSG_PUB.Add;
7259: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
7260: THEN
7261: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
7262: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Subscription_Template');
7263: OE_MSG_PUB.Add;
7264: END IF;
7265: RETURN NULL;
7266: WHEN OTHERS THEN
7267: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7263: OE_MSG_PUB.Add;
7264: END IF;
7265: RETURN NULL;
7266: WHEN OTHERS THEN
7267: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7268: THEN
7269: OE_MSG_PUB.Add_Exc_Msg
7270: ( G_PKG_NAME
7271: , 'Subscription_Template'
7265: RETURN NULL;
7266: WHEN OTHERS THEN
7267: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7268: THEN
7269: OE_MSG_PUB.Add_Exc_Msg
7270: ( G_PKG_NAME
7271: , 'Subscription_Template'
7272: );
7273: END IF;
7291: END IF;
7292: RETURN l_Coverage_Template;
7293: EXCEPTION
7294: WHEN NO_DATA_FOUND THEN
7295: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
7296: THEN
7297: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
7298: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Coverage_Template');
7299: OE_MSG_PUB.Add;
7295: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
7296: THEN
7297: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
7298: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Coverage_Template');
7299: OE_MSG_PUB.Add;
7300: END IF;
7301: RETURN NULL;
7302: WHEN OTHERS THEN
7303: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7299: OE_MSG_PUB.Add;
7300: END IF;
7301: RETURN NULL;
7302: WHEN OTHERS THEN
7303: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7304: THEN
7305: OE_MSG_PUB.Add_Exc_Msg
7306: ( G_PKG_NAME
7307: , 'Coverage_Template'
7301: RETURN NULL;
7302: WHEN OTHERS THEN
7303: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7304: THEN
7305: OE_MSG_PUB.Add_Exc_Msg
7306: ( G_PKG_NAME
7307: , 'Coverage_Template'
7308: );
7309: END IF;
7326: END IF;
7327: RETURN l_service_period;
7328: EXCEPTION
7329: WHEN NO_DATA_FOUND THEN
7330: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
7331: THEN
7332: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
7333: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Service_Period');
7334: OE_MSG_PUB.Add;
7330: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
7331: THEN
7332: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
7333: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Service_Period');
7334: OE_MSG_PUB.Add;
7335: END IF;
7336: RETURN NULL;
7337: WHEN OTHERS THEN
7338: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7334: OE_MSG_PUB.Add;
7335: END IF;
7336: RETURN NULL;
7337: WHEN OTHERS THEN
7338: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7339: THEN
7340: OE_MSG_PUB.Add_Exc_Msg
7341: ( G_PKG_NAME
7342: , 'Service_Period'
7336: RETURN NULL;
7337: WHEN OTHERS THEN
7338: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7339: THEN
7340: OE_MSG_PUB.Add_Exc_Msg
7341: ( G_PKG_NAME
7342: , 'Service_Period'
7343: );
7344: END IF;