[Home] [Help]
236: -- dictionary stack. Then, add it to the API message list.
237:
238: FND_MESSAGE.Set_Encoded(FND_FLEX_DESCVAL.Encoded_Error_Message);
239:
240: OE_MSG_PUB.Add;
241:
242: -- Derive return status.
243:
244: IF FND_FLEX_DESCVAL.value_error OR
286: EXCEPTION
287:
288: WHEN NO_DATA_FOUND THEN
289:
290: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
291: THEN
292:
293: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
294: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','agreement');
291: THEN
292:
293: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
294: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','agreement');
295: OE_MSG_PUB.Add;
296:
297: END IF;
298:
299: RETURN FALSE;
299: RETURN FALSE;
300:
301: WHEN OTHERS THEN
302:
303: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
304: THEN
305: OE_MSG_PUB.Add_Exc_Msg
306: ( G_PKG_NAME
307: , 'Agreement'
301: WHEN OTHERS THEN
302:
303: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
304: THEN
305: OE_MSG_PUB.Add_Exc_Msg
306: ( G_PKG_NAME
307: , 'Agreement'
308: );
309: END IF;
334: EXCEPTION
335:
336: WHEN NO_DATA_FOUND THEN
337:
338: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
339: THEN
340:
341: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
342: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','created_by');
339: THEN
340:
341: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
342: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','created_by');
343: OE_MSG_PUB.Add;
344:
345: END IF;
346:
347: RETURN FALSE;
347: RETURN FALSE;
348:
349: WHEN OTHERS THEN
350:
351: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
352: THEN
353: OE_MSG_PUB.Add_Exc_Msg
354: ( G_PKG_NAME
355: , 'Created_By'
349: WHEN OTHERS THEN
350:
351: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
352: THEN
353: OE_MSG_PUB.Add_Exc_Msg
354: ( G_PKG_NAME
355: , 'Created_By'
356: );
357: END IF;
382: EXCEPTION
383:
384: WHEN NO_DATA_FOUND THEN
385:
386: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
387: THEN
388:
389: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
390: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','creation_date');
387: THEN
388:
389: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
390: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','creation_date');
391: OE_MSG_PUB.Add;
392:
393: END IF;
394:
395: RETURN FALSE;
395: RETURN FALSE;
396:
397: WHEN OTHERS THEN
398:
399: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
400: THEN
401: OE_MSG_PUB.Add_Exc_Msg
402: ( G_PKG_NAME
403: , 'Creation_Date'
397: WHEN OTHERS THEN
398:
399: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
400: THEN
401: OE_MSG_PUB.Add_Exc_Msg
402: ( G_PKG_NAME
403: , 'Creation_Date'
404: );
405: END IF;
430: EXCEPTION
431:
432: WHEN NO_DATA_FOUND THEN
433:
434: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
435: THEN
436:
437: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
438: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','discount');
435: THEN
436:
437: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
438: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','discount');
439: OE_MSG_PUB.Add;
440:
441: END IF;
442:
443: RETURN FALSE;
443: RETURN FALSE;
444:
445: WHEN OTHERS THEN
446:
447: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
448: THEN
449: OE_MSG_PUB.Add_Exc_Msg
450: ( G_PKG_NAME
451: , 'Discount'
445: WHEN OTHERS THEN
446:
447: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
448: THEN
449: OE_MSG_PUB.Add_Exc_Msg
450: ( G_PKG_NAME
451: , 'Discount'
452: );
453: END IF;
478: EXCEPTION
479:
480: WHEN NO_DATA_FOUND THEN
481:
482: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
483: THEN
484:
485: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
486: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','last_updated_by');
483: THEN
484:
485: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
486: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','last_updated_by');
487: OE_MSG_PUB.Add;
488:
489: END IF;
490:
491: RETURN FALSE;
491: RETURN FALSE;
492:
493: WHEN OTHERS THEN
494:
495: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
496: THEN
497: OE_MSG_PUB.Add_Exc_Msg
498: ( G_PKG_NAME
499: , 'Last_Updated_By'
493: WHEN OTHERS THEN
494:
495: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
496: THEN
497: OE_MSG_PUB.Add_Exc_Msg
498: ( G_PKG_NAME
499: , 'Last_Updated_By'
500: );
501: END IF;
526: EXCEPTION
527:
528: WHEN NO_DATA_FOUND THEN
529:
530: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
531: THEN
532:
533: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
534: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','last_update_date');
531: THEN
532:
533: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
534: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','last_update_date');
535: OE_MSG_PUB.Add;
536:
537: END IF;
538:
539: RETURN FALSE;
539: RETURN FALSE;
540:
541: WHEN OTHERS THEN
542:
543: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
544: THEN
545: OE_MSG_PUB.Add_Exc_Msg
546: ( G_PKG_NAME
547: , 'Last_Update_Date'
541: WHEN OTHERS THEN
542:
543: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
544: THEN
545: OE_MSG_PUB.Add_Exc_Msg
546: ( G_PKG_NAME
547: , 'Last_Update_Date'
548: );
549: END IF;
574: EXCEPTION
575:
576: WHEN NO_DATA_FOUND THEN
577:
578: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
579: THEN
580:
581: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
582: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','last_update_login');
579: THEN
580:
581: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
582: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','last_update_login');
583: OE_MSG_PUB.Add;
584:
585: END IF;
586:
587: RETURN FALSE;
587: RETURN FALSE;
588:
589: WHEN OTHERS THEN
590:
591: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
592: THEN
593: OE_MSG_PUB.Add_Exc_Msg
594: ( G_PKG_NAME
595: , 'Last_Update_Login'
589: WHEN OTHERS THEN
590:
591: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
592: THEN
593: OE_MSG_PUB.Add_Exc_Msg
594: ( G_PKG_NAME
595: , 'Last_Update_Login'
596: );
597: END IF;
622: EXCEPTION
623:
624: WHEN NO_DATA_FOUND THEN
625:
626: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
627: THEN
628:
629: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
630: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','price_list');
627: THEN
628:
629: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
630: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','price_list');
631: OE_MSG_PUB.Add;
632:
633: END IF;
634:
635: RETURN FALSE;
635: RETURN FALSE;
636:
637: WHEN OTHERS THEN
638:
639: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
640: THEN
641: OE_MSG_PUB.Add_Exc_Msg
642: ( G_PKG_NAME
643: , 'Price_List'
637: WHEN OTHERS THEN
638:
639: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
640: THEN
641: OE_MSG_PUB.Add_Exc_Msg
642: ( G_PKG_NAME
643: , 'Price_List'
644: );
645: END IF;
670: EXCEPTION
671:
672: WHEN NO_DATA_FOUND THEN
673:
674: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
675: THEN
676:
677: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
678: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','pricing_contract');
675: THEN
676:
677: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
678: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','pricing_contract');
679: OE_MSG_PUB.Add;
680:
681: END IF;
682:
683: RETURN FALSE;
683: RETURN FALSE;
684:
685: WHEN OTHERS THEN
686:
687: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
688: THEN
689: OE_MSG_PUB.Add_Exc_Msg
690: ( G_PKG_NAME
691: , 'Pricing_Contract'
685: WHEN OTHERS THEN
686:
687: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
688: THEN
689: OE_MSG_PUB.Add_Exc_Msg
690: ( G_PKG_NAME
691: , 'Pricing_Contract'
692: );
693: END IF;
719: EXCEPTION
720:
721: WHEN NO_DATA_FOUND THEN
722:
723: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
724: THEN
725:
726: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
727: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','accounting_rule');
724: THEN
725:
726: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
727: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','accounting_rule');
728: OE_MSG_PUB.Add;
729:
730: END IF;
731:
732: RETURN FALSE;
732: RETURN FALSE;
733:
734: WHEN OTHERS THEN
735:
736: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
737: THEN
738: OE_MSG_PUB.Add_Exc_Msg
739: ( G_PKG_NAME
740: , 'Accounting_Rule'
734: WHEN OTHERS THEN
735:
736: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
737: THEN
738: OE_MSG_PUB.Add_Exc_Msg
739: ( G_PKG_NAME
740: , 'Accounting_Rule'
741: );
742: END IF;
767: EXCEPTION
768:
769: WHEN NO_DATA_FOUND THEN
770:
771: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
772: THEN
773:
774: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
775: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','agreement_contact');
772: THEN
773:
774: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
775: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','agreement_contact');
776: OE_MSG_PUB.Add;
777:
778: END IF;
779:
780: RETURN FALSE;
780: RETURN FALSE;
781:
782: WHEN OTHERS THEN
783:
784: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
785: THEN
786: OE_MSG_PUB.Add_Exc_Msg
787: ( G_PKG_NAME
788: , 'Agreement_Contact'
782: WHEN OTHERS THEN
783:
784: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
785: THEN
786: OE_MSG_PUB.Add_Exc_Msg
787: ( G_PKG_NAME
788: , 'Agreement_Contact'
789: );
790: END IF;
815: EXCEPTION
816:
817: WHEN NO_DATA_FOUND THEN
818:
819: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
820: THEN
821:
822: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
823: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','agreement_num');
820: THEN
821:
822: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
823: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','agreement_num');
824: OE_MSG_PUB.Add;
825:
826: END IF;
827:
828: RETURN FALSE;
828: RETURN FALSE;
829:
830: WHEN OTHERS THEN
831:
832: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
833: THEN
834: OE_MSG_PUB.Add_Exc_Msg
835: ( G_PKG_NAME
836: , 'Agreement_Num'
830: WHEN OTHERS THEN
831:
832: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
833: THEN
834: OE_MSG_PUB.Add_Exc_Msg
835: ( G_PKG_NAME
836: , 'Agreement_Num'
837: );
838: END IF;
863: EXCEPTION
864:
865: WHEN NO_DATA_FOUND THEN
866:
867: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
868: THEN
869:
870: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
871: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','agreement_type');
868: THEN
869:
870: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
871: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','agreement_type');
872: OE_MSG_PUB.Add;
873:
874: END IF;
875:
876: RETURN FALSE;
876: RETURN FALSE;
877:
878: WHEN OTHERS THEN
879:
880: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
881: THEN
882: OE_MSG_PUB.Add_Exc_Msg
883: ( G_PKG_NAME
884: , 'Agreement_Type'
878: WHEN OTHERS THEN
879:
880: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
881: THEN
882: OE_MSG_PUB.Add_Exc_Msg
883: ( G_PKG_NAME
884: , 'Agreement_Type'
885: );
886: END IF;
918: EXCEPTION
919:
920: WHEN NO_DATA_FOUND THEN
921:
922: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
923: THEN
924:
925: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
926: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','customer');
923: THEN
924:
925: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
926: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','customer');
927: OE_MSG_PUB.Add;
928:
929: END IF;
930:
931: RETURN FALSE;
931: RETURN FALSE;
932:
933: WHEN OTHERS THEN
934:
935: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
936: THEN
937: OE_MSG_PUB.Add_Exc_Msg
938: ( G_PKG_NAME
939: , 'Customer'
933: WHEN OTHERS THEN
934:
935: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
936: THEN
937: OE_MSG_PUB.Add_Exc_Msg
938: ( G_PKG_NAME
939: , 'Customer'
940: );
941: END IF;
966: EXCEPTION
967:
968: WHEN NO_DATA_FOUND THEN
969:
970: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
971: THEN
972:
973: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
974: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','end_date_active');
971: THEN
972:
973: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
974: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','end_date_active');
975: OE_MSG_PUB.Add;
976:
977: END IF;
978:
979: RETURN FALSE;
979: RETURN FALSE;
980:
981: WHEN OTHERS THEN
982:
983: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
984: THEN
985: OE_MSG_PUB.Add_Exc_Msg
986: ( G_PKG_NAME
987: , 'End_Date_Active'
981: WHEN OTHERS THEN
982:
983: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
984: THEN
985: OE_MSG_PUB.Add_Exc_Msg
986: ( G_PKG_NAME
987: , 'End_Date_Active'
988: );
989: END IF;
1006: THEN
1007: RETURN TRUE;
1008: ELSIF (p_start_date_active > p_end_date_active ) THEN
1009: FND_MESSAGE.SET_NAME('OE', 'SO_OTHER_INVALID_DATE_RANGE');
1010: OE_MSG_PUB.Add;
1011: RETURN FALSE;
1012: END IF;
1013:
1014:
1026: -- function
1027:
1028: WHEN NO_DATA_FOUND THEN
1029:
1030: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1031: THEN
1032: NULL;
1033: END IF;
1034:
1035: RETURN FALSE;
1036:
1037: WHEN OTHERS THEN
1038:
1039: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1040: THEN
1041: OE_MSG_PUB.Add_Exc_Msg
1042: ( G_PKG_NAME
1043: , 'Start_Date_End_Date_Active'
1037: WHEN OTHERS THEN
1038:
1039: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1040: THEN
1041: OE_MSG_PUB.Add_Exc_Msg
1042: ( G_PKG_NAME
1043: , 'Start_Date_End_Date_Active'
1044: );
1045: END IF;
1063: ELSIF (p_line_date_active not between
1064: nvl(p_header_start_date_active, p_line_date_active - 1 ) and
1065: nvl(p_header_end_date_active, p_line_date_active + 1 )) THEN
1066: FND_MESSAGE.SET_NAME('OE', 'SO_OTHER_INVALID_DATE_RANGE');
1067: OE_MSG_PUB.Add;
1068: RETURN FALSE;
1069: END IF;
1070:
1071:
1083: -- function
1084:
1085: WHEN NO_DATA_FOUND THEN
1086:
1087: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1088: THEN
1089: NULL;
1090: END IF;
1091:
1092: RETURN FALSE;
1093:
1094: WHEN OTHERS THEN
1095:
1096: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1097: THEN
1098: OE_MSG_PUB.Add_Exc_Msg
1099: ( G_PKG_NAME
1100: , 'Check_Date_Range'
1094: WHEN OTHERS THEN
1095:
1096: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1097: THEN
1098: OE_MSG_PUB.Add_Exc_Msg
1099: ( G_PKG_NAME
1100: , 'Check_Date_Range'
1101: );
1102: END IF;
1127: EXCEPTION
1128:
1129: WHEN NO_DATA_FOUND THEN
1130:
1131: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1132: THEN
1133:
1134: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
1135: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','freight_terms');
1132: THEN
1133:
1134: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
1135: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','freight_terms');
1136: OE_MSG_PUB.Add;
1137:
1138: END IF;
1139:
1140: RETURN FALSE;
1140: RETURN FALSE;
1141:
1142: WHEN OTHERS THEN
1143:
1144: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1145: THEN
1146: OE_MSG_PUB.Add_Exc_Msg
1147: ( G_PKG_NAME
1148: , 'Freight_Terms'
1142: WHEN OTHERS THEN
1143:
1144: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1145: THEN
1146: OE_MSG_PUB.Add_Exc_Msg
1147: ( G_PKG_NAME
1148: , 'Freight_Terms'
1149: );
1150: END IF;
1175: EXCEPTION
1176:
1177: WHEN NO_DATA_FOUND THEN
1178:
1179: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1180: THEN
1181:
1182: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
1183: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','invoice_contact');
1180: THEN
1181:
1182: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
1183: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','invoice_contact');
1184: OE_MSG_PUB.Add;
1185:
1186: END IF;
1187:
1188: RETURN FALSE;
1188: RETURN FALSE;
1189:
1190: WHEN OTHERS THEN
1191:
1192: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1193: THEN
1194: OE_MSG_PUB.Add_Exc_Msg
1195: ( G_PKG_NAME
1196: , 'Invoice_Contact'
1190: WHEN OTHERS THEN
1191:
1192: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1193: THEN
1194: OE_MSG_PUB.Add_Exc_Msg
1195: ( G_PKG_NAME
1196: , 'Invoice_Contact'
1197: );
1198: END IF;
1230: EXCEPTION
1231:
1232: WHEN NO_DATA_FOUND THEN
1233:
1234: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1235: THEN
1236:
1237: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
1238: /* FND_MESSAGE.SET_TOKEN('ATTRIBUTE','invoice_to_site_use'); */
1236:
1237: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
1238: /* FND_MESSAGE.SET_TOKEN('ATTRIBUTE','invoice_to_site_use'); */
1239: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','invoice_to_org');
1240: OE_MSG_PUB.Add;
1241:
1242: END IF;
1243:
1244: RETURN FALSE;
1244: RETURN FALSE;
1245:
1246: WHEN OTHERS THEN
1247:
1248: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1249: THEN
1250: OE_MSG_PUB.Add_Exc_Msg
1251: ( G_PKG_NAME
1252: /* , 'Invoice_To_Site_Use' */
1246: WHEN OTHERS THEN
1247:
1248: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1249: THEN
1250: OE_MSG_PUB.Add_Exc_Msg
1251: ( G_PKG_NAME
1252: /* , 'Invoice_To_Site_Use' */
1253: , 'Invoice_To_Org'
1254: );
1280: EXCEPTION
1281:
1282: WHEN NO_DATA_FOUND THEN
1283:
1284: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1285: THEN
1286:
1287: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
1288: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','invoicing_rule');
1285: THEN
1286:
1287: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
1288: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','invoicing_rule');
1289: OE_MSG_PUB.Add;
1290:
1291: END IF;
1292:
1293: RETURN FALSE;
1293: RETURN FALSE;
1294:
1295: WHEN OTHERS THEN
1296:
1297: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1298: THEN
1299: OE_MSG_PUB.Add_Exc_Msg
1300: ( G_PKG_NAME
1301: , 'Invoicing_Rule'
1295: WHEN OTHERS THEN
1296:
1297: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1298: THEN
1299: OE_MSG_PUB.Add_Exc_Msg
1300: ( G_PKG_NAME
1301: , 'Invoicing_Rule'
1302: );
1303: END IF;
1328: EXCEPTION
1329:
1330: WHEN NO_DATA_FOUND THEN
1331:
1332: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1333: THEN
1334:
1335: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
1336: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','name');
1333: THEN
1334:
1335: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
1336: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','name');
1337: OE_MSG_PUB.Add;
1338:
1339: END IF;
1340:
1341: RETURN FALSE;
1341: RETURN FALSE;
1342:
1343: WHEN OTHERS THEN
1344:
1345: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1346: THEN
1347: OE_MSG_PUB.Add_Exc_Msg
1348: ( G_PKG_NAME
1349: , 'Name'
1343: WHEN OTHERS THEN
1344:
1345: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1346: THEN
1347: OE_MSG_PUB.Add_Exc_Msg
1348: ( G_PKG_NAME
1349: , 'Name'
1350: );
1351: END IF;
1376: EXCEPTION
1377:
1378: WHEN NO_DATA_FOUND THEN
1379:
1380: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1381: THEN
1382:
1383: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
1384: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','override_arule');
1381: THEN
1382:
1383: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
1384: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','override_arule');
1385: OE_MSG_PUB.Add;
1386:
1387: END IF;
1388:
1389: RETURN FALSE;
1389: RETURN FALSE;
1390:
1391: WHEN OTHERS THEN
1392:
1393: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1394: THEN
1395: OE_MSG_PUB.Add_Exc_Msg
1396: ( G_PKG_NAME
1397: , 'Override_Arule'
1391: WHEN OTHERS THEN
1392:
1393: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1394: THEN
1395: OE_MSG_PUB.Add_Exc_Msg
1396: ( G_PKG_NAME
1397: , 'Override_Arule'
1398: );
1399: END IF;
1424: EXCEPTION
1425:
1426: WHEN NO_DATA_FOUND THEN
1427:
1428: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1429: THEN
1430:
1431: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
1432: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','override_irule');
1429: THEN
1430:
1431: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
1432: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','override_irule');
1433: OE_MSG_PUB.Add;
1434:
1435: END IF;
1436:
1437: RETURN FALSE;
1437: RETURN FALSE;
1438:
1439: WHEN OTHERS THEN
1440:
1441: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1442: THEN
1443: OE_MSG_PUB.Add_Exc_Msg
1444: ( G_PKG_NAME
1445: , 'Override_Irule'
1439: WHEN OTHERS THEN
1440:
1441: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1442: THEN
1443: OE_MSG_PUB.Add_Exc_Msg
1444: ( G_PKG_NAME
1445: , 'Override_Irule'
1446: );
1447: END IF;
1472: EXCEPTION
1473:
1474: WHEN NO_DATA_FOUND THEN
1475:
1476: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1477: THEN
1478:
1479: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
1480: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','purchase_order_num');
1477: THEN
1478:
1479: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
1480: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','purchase_order_num');
1481: OE_MSG_PUB.Add;
1482:
1483: END IF;
1484:
1485: RETURN FALSE;
1485: RETURN FALSE;
1486:
1487: WHEN OTHERS THEN
1488:
1489: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1490: THEN
1491: OE_MSG_PUB.Add_Exc_Msg
1492: ( G_PKG_NAME
1493: , 'Purchase_Order_Num'
1487: WHEN OTHERS THEN
1488:
1489: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1490: THEN
1491: OE_MSG_PUB.Add_Exc_Msg
1492: ( G_PKG_NAME
1493: , 'Purchase_Order_Num'
1494: );
1495: END IF;
1520: EXCEPTION
1521:
1522: WHEN NO_DATA_FOUND THEN
1523:
1524: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1525: THEN
1526:
1527: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
1528: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','revision');
1525: THEN
1526:
1527: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
1528: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','revision');
1529: OE_MSG_PUB.Add;
1530:
1531: END IF;
1532:
1533: RETURN FALSE;
1533: RETURN FALSE;
1534:
1535: WHEN OTHERS THEN
1536:
1537: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1538: THEN
1539: OE_MSG_PUB.Add_Exc_Msg
1540: ( G_PKG_NAME
1541: , 'Revision'
1535: WHEN OTHERS THEN
1536:
1537: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1538: THEN
1539: OE_MSG_PUB.Add_Exc_Msg
1540: ( G_PKG_NAME
1541: , 'Revision'
1542: );
1543: END IF;
1568: EXCEPTION
1569:
1570: WHEN NO_DATA_FOUND THEN
1571:
1572: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1573: THEN
1574:
1575: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
1576: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','revision_date');
1573: THEN
1574:
1575: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
1576: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','revision_date');
1577: OE_MSG_PUB.Add;
1578:
1579: END IF;
1580:
1581: RETURN FALSE;
1581: RETURN FALSE;
1582:
1583: WHEN OTHERS THEN
1584:
1585: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1586: THEN
1587: OE_MSG_PUB.Add_Exc_Msg
1588: ( G_PKG_NAME
1589: , 'Revision_Date'
1583: WHEN OTHERS THEN
1584:
1585: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1586: THEN
1587: OE_MSG_PUB.Add_Exc_Msg
1588: ( G_PKG_NAME
1589: , 'Revision_Date'
1590: );
1591: END IF;
1616: EXCEPTION
1617:
1618: WHEN NO_DATA_FOUND THEN
1619:
1620: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1621: THEN
1622:
1623: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
1624: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','revision_reason');
1621: THEN
1622:
1623: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
1624: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','revision_reason');
1625: OE_MSG_PUB.Add;
1626:
1627: END IF;
1628:
1629: RETURN FALSE;
1629: RETURN FALSE;
1630:
1631: WHEN OTHERS THEN
1632:
1633: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1634: THEN
1635: OE_MSG_PUB.Add_Exc_Msg
1636: ( G_PKG_NAME
1637: , 'Revision_Reason'
1631: WHEN OTHERS THEN
1632:
1633: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1634: THEN
1635: OE_MSG_PUB.Add_Exc_Msg
1636: ( G_PKG_NAME
1637: , 'Revision_Reason'
1638: );
1639: END IF;
1664: EXCEPTION
1665:
1666: WHEN NO_DATA_FOUND THEN
1667:
1668: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1669: THEN
1670:
1671: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
1672: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','salesrep');
1669: THEN
1670:
1671: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
1672: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','salesrep');
1673: OE_MSG_PUB.Add;
1674:
1675: END IF;
1676:
1677: RETURN FALSE;
1677: RETURN FALSE;
1678:
1679: WHEN OTHERS THEN
1680:
1681: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1682: THEN
1683: OE_MSG_PUB.Add_Exc_Msg
1684: ( G_PKG_NAME
1685: , 'Salesrep'
1679: WHEN OTHERS THEN
1680:
1681: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1682: THEN
1683: OE_MSG_PUB.Add_Exc_Msg
1684: ( G_PKG_NAME
1685: , 'Salesrep'
1686: );
1687: END IF;
1712: EXCEPTION
1713:
1714: WHEN NO_DATA_FOUND THEN
1715:
1716: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1717: THEN
1718:
1719: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
1720: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ship_method');
1717: THEN
1718:
1719: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
1720: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ship_method');
1721: OE_MSG_PUB.Add;
1722:
1723: END IF;
1724:
1725: RETURN FALSE;
1725: RETURN FALSE;
1726:
1727: WHEN OTHERS THEN
1728:
1729: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1730: THEN
1731: OE_MSG_PUB.Add_Exc_Msg
1732: ( G_PKG_NAME
1733: , 'Ship_Method'
1727: WHEN OTHERS THEN
1728:
1729: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1730: THEN
1731: OE_MSG_PUB.Add_Exc_Msg
1732: ( G_PKG_NAME
1733: , 'Ship_Method'
1734: );
1735: END IF;
1760: EXCEPTION
1761:
1762: WHEN NO_DATA_FOUND THEN
1763:
1764: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1765: THEN
1766:
1767: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
1768: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','signature_date');
1765: THEN
1766:
1767: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
1768: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','signature_date');
1769: OE_MSG_PUB.Add;
1770:
1771: END IF;
1772:
1773: RETURN FALSE;
1773: RETURN FALSE;
1774:
1775: WHEN OTHERS THEN
1776:
1777: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1778: THEN
1779: OE_MSG_PUB.Add_Exc_Msg
1780: ( G_PKG_NAME
1781: , 'Signature_Date'
1775: WHEN OTHERS THEN
1776:
1777: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1778: THEN
1779: OE_MSG_PUB.Add_Exc_Msg
1780: ( G_PKG_NAME
1781: , 'Signature_Date'
1782: );
1783: END IF;
1808: EXCEPTION
1809:
1810: WHEN NO_DATA_FOUND THEN
1811:
1812: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1813: THEN
1814:
1815: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
1816: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','start_date_active');
1813: THEN
1814:
1815: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
1816: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','start_date_active');
1817: OE_MSG_PUB.Add;
1818:
1819: END IF;
1820:
1821: RETURN FALSE;
1821: RETURN FALSE;
1822:
1823: WHEN OTHERS THEN
1824:
1825: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1826: THEN
1827: OE_MSG_PUB.Add_Exc_Msg
1828: ( G_PKG_NAME
1829: , 'Start_Date_Active'
1823: WHEN OTHERS THEN
1824:
1825: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1826: THEN
1827: OE_MSG_PUB.Add_Exc_Msg
1828: ( G_PKG_NAME
1829: , 'Start_Date_Active'
1830: );
1831: END IF;
1856: EXCEPTION
1857:
1858: WHEN NO_DATA_FOUND THEN
1859:
1860: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1861: THEN
1862:
1863: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
1864: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','term');
1861: THEN
1862:
1863: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
1864: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','term');
1865: OE_MSG_PUB.Add;
1866:
1867: END IF;
1868:
1869: RETURN FALSE;
1869: RETURN FALSE;
1870:
1871: WHEN OTHERS THEN
1872:
1873: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1874: THEN
1875: OE_MSG_PUB.Add_Exc_Msg
1876: ( G_PKG_NAME
1877: , 'Term'
1871: WHEN OTHERS THEN
1872:
1873: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1874: THEN
1875: OE_MSG_PUB.Add_Exc_Msg
1876: ( G_PKG_NAME
1877: , 'Term'
1878: );
1879: END IF;
1906: EXCEPTION
1907:
1908: WHEN NO_DATA_FOUND THEN
1909:
1910: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1911: THEN
1912:
1913: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
1914: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','agreement_source');
1911: THEN
1912:
1913: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
1914: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','agreement_source');
1915: OE_MSG_PUB.Add;
1916:
1917: END IF;
1918:
1919: RETURN FALSE;
1919: RETURN FALSE;
1920:
1921: WHEN OTHERS THEN
1922:
1923: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1924: THEN
1925: OE_MSG_PUB.Add_Exc_Msg
1926: ( G_PKG_NAME
1927: , 'Agreement_Source'
1921: WHEN OTHERS THEN
1922:
1923: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1924: THEN
1925: OE_MSG_PUB.Add_Exc_Msg
1926: ( G_PKG_NAME
1927: , 'Agreement_Source'
1928: );
1929: END IF;
1954: EXCEPTION
1955:
1956: WHEN NO_DATA_FOUND THEN
1957:
1958: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1959: THEN
1960:
1961: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
1962: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','orig_system_agr');
1959: THEN
1960:
1961: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
1962: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','orig_system_agr');
1963: OE_MSG_PUB.Add;
1964:
1965: END IF;
1966:
1967: RETURN FALSE;
1967: RETURN FALSE;
1968:
1969: WHEN OTHERS THEN
1970:
1971: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1972: THEN
1973: OE_MSG_PUB.Add_Exc_Msg
1974: ( G_PKG_NAME
1975: , 'Orig_System_Agr'
1969: WHEN OTHERS THEN
1970:
1971: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1972: THEN
1973: OE_MSG_PUB.Add_Exc_Msg
1974: ( G_PKG_NAME
1975: , 'Orig_System_Agr'
1976: );
1977: END IF;
2004: EXCEPTION
2005:
2006: WHEN NO_DATA_FOUND THEN
2007:
2008: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2009: THEN
2010:
2011: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
2012: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','invoice_to_customer_id');
2009: THEN
2010:
2011: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
2012: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','invoice_to_customer_id');
2013: OE_MSG_PUB.Add;
2014:
2015: END IF;
2016:
2017: RETURN FALSE;
2017: RETURN FALSE;
2018:
2019: WHEN OTHERS THEN
2020:
2021: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2022: THEN
2023: OE_MSG_PUB.Add_Exc_Msg
2024: ( G_PKG_NAME
2025: , 'Invoice_To_Customer_Id'
2019: WHEN OTHERS THEN
2020:
2021: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2022: THEN
2023: OE_MSG_PUB.Add_Exc_Msg
2024: ( G_PKG_NAME
2025: , 'Invoice_To_Customer_Id'
2026: );
2027: END IF;
2052: EXCEPTION
2053:
2054: WHEN NO_DATA_FOUND THEN
2055:
2056: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2057: THEN
2058:
2059: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
2060: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','comments');
2057: THEN
2058:
2059: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
2060: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','comments');
2061: OE_MSG_PUB.Add;
2062:
2063: END IF;
2064:
2065: RETURN FALSE;
2065: RETURN FALSE;
2066:
2067: WHEN OTHERS THEN
2068:
2069: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2070: THEN
2071: OE_MSG_PUB.Add_Exc_Msg
2072: ( G_PKG_NAME
2073: , 'Comments'
2067: WHEN OTHERS THEN
2068:
2069: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2070: THEN
2071: OE_MSG_PUB.Add_Exc_Msg
2072: ( G_PKG_NAME
2073: , 'Comments'
2074: );
2075: END IF;
2100: EXCEPTION
2101:
2102: WHEN NO_DATA_FOUND THEN
2103:
2104: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2105: THEN
2106:
2107: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
2108: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','currency');
2105: THEN
2106:
2107: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
2108: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','currency');
2109: OE_MSG_PUB.Add;
2110:
2111: END IF;
2112:
2113: RETURN FALSE;
2113: RETURN FALSE;
2114:
2115: WHEN OTHERS THEN
2116:
2117: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2118: THEN
2119: OE_MSG_PUB.Add_Exc_Msg
2120: ( G_PKG_NAME
2121: , 'Currency'
2115: WHEN OTHERS THEN
2116:
2117: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2118: THEN
2119: OE_MSG_PUB.Add_Exc_Msg
2120: ( G_PKG_NAME
2121: , 'Currency'
2122: );
2123: END IF;
2165: EXCEPTION
2166:
2167: WHEN NO_DATA_FOUND THEN
2168:
2169: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2170: THEN
2171:
2172: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
2173: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','currency');
2170: THEN
2171:
2172: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
2173: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','currency');
2174: OE_MSG_PUB.Add;
2175:
2176: END IF;
2177:
2178: RETURN FALSE;
2178: RETURN FALSE;
2179:
2180: WHEN OTHERS THEN
2181:
2182: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2183: THEN
2184: OE_MSG_PUB.Add_Exc_Msg
2185: ( G_PKG_NAME
2186: , 'Currency'
2180: WHEN OTHERS THEN
2181:
2182: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2183: THEN
2184: OE_MSG_PUB.Add_Exc_Msg
2185: ( G_PKG_NAME
2186: , 'Currency'
2187: );
2188: END IF;
2213: EXCEPTION
2214:
2215: WHEN NO_DATA_FOUND THEN
2216:
2217: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2218: THEN
2219:
2220: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
2221: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','description');
2218: THEN
2219:
2220: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
2221: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','description');
2222: OE_MSG_PUB.Add;
2223:
2224: END IF;
2225:
2226: RETURN FALSE;
2226: RETURN FALSE;
2227:
2228: WHEN OTHERS THEN
2229:
2230: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2231: THEN
2232: OE_MSG_PUB.Add_Exc_Msg
2233: ( G_PKG_NAME
2234: , 'Description'
2228: WHEN OTHERS THEN
2229:
2230: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2231: THEN
2232: OE_MSG_PUB.Add_Exc_Msg
2233: ( G_PKG_NAME
2234: , 'Description'
2235: );
2236: END IF;
2261: EXCEPTION
2262:
2263: WHEN NO_DATA_FOUND THEN
2264:
2265: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2266: THEN
2267:
2268: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
2269: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','program_application');
2266: THEN
2267:
2268: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
2269: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','program_application');
2270: OE_MSG_PUB.Add;
2271:
2272: END IF;
2273:
2274: RETURN FALSE;
2274: RETURN FALSE;
2275:
2276: WHEN OTHERS THEN
2277:
2278: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2279: THEN
2280: OE_MSG_PUB.Add_Exc_Msg
2281: ( G_PKG_NAME
2282: , 'Program_Application'
2276: WHEN OTHERS THEN
2277:
2278: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2279: THEN
2280: OE_MSG_PUB.Add_Exc_Msg
2281: ( G_PKG_NAME
2282: , 'Program_Application'
2283: );
2284: END IF;
2309: EXCEPTION
2310:
2311: WHEN NO_DATA_FOUND THEN
2312:
2313: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2314: THEN
2315:
2316: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
2317: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','program');
2314: THEN
2315:
2316: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
2317: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','program');
2318: OE_MSG_PUB.Add;
2319:
2320: END IF;
2321:
2322: RETURN FALSE;
2322: RETURN FALSE;
2323:
2324: WHEN OTHERS THEN
2325:
2326: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2327: THEN
2328: OE_MSG_PUB.Add_Exc_Msg
2329: ( G_PKG_NAME
2330: , 'Program'
2324: WHEN OTHERS THEN
2325:
2326: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2327: THEN
2328: OE_MSG_PUB.Add_Exc_Msg
2329: ( G_PKG_NAME
2330: , 'Program'
2331: );
2332: END IF;
2357: EXCEPTION
2358:
2359: WHEN NO_DATA_FOUND THEN
2360:
2361: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2362: THEN
2363:
2364: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
2365: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','program_update_date');
2362: THEN
2363:
2364: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
2365: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','program_update_date');
2366: OE_MSG_PUB.Add;
2367:
2368: END IF;
2369:
2370: RETURN FALSE;
2370: RETURN FALSE;
2371:
2372: WHEN OTHERS THEN
2373:
2374: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2375: THEN
2376: OE_MSG_PUB.Add_Exc_Msg
2377: ( G_PKG_NAME
2378: , 'Program_Update_Date'
2372: WHEN OTHERS THEN
2373:
2374: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2375: THEN
2376: OE_MSG_PUB.Add_Exc_Msg
2377: ( G_PKG_NAME
2378: , 'Program_Update_Date'
2379: );
2380: END IF;
2405: EXCEPTION
2406:
2407: WHEN NO_DATA_FOUND THEN
2408:
2409: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2410: THEN
2411:
2412: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
2413: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','request');
2410: THEN
2411:
2412: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
2413: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','request');
2414: OE_MSG_PUB.Add;
2415:
2416: END IF;
2417:
2418: RETURN FALSE;
2418: RETURN FALSE;
2419:
2420: WHEN OTHERS THEN
2421:
2422: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2423: THEN
2424: OE_MSG_PUB.Add_Exc_Msg
2425: ( G_PKG_NAME
2426: , 'Request'
2420: WHEN OTHERS THEN
2421:
2422: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2423: THEN
2424: OE_MSG_PUB.Add_Exc_Msg
2425: ( G_PKG_NAME
2426: , 'Request'
2427: );
2428: END IF;
2453: EXCEPTION
2454:
2455: WHEN NO_DATA_FOUND THEN
2456:
2457: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2458: THEN
2459:
2460: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
2461: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','rounding_factor');
2458: THEN
2459:
2460: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
2461: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','rounding_factor');
2462: OE_MSG_PUB.Add;
2463:
2464: END IF;
2465:
2466: RETURN FALSE;
2466: RETURN FALSE;
2467:
2468: WHEN OTHERS THEN
2469:
2470: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2471: THEN
2472: OE_MSG_PUB.Add_Exc_Msg
2473: ( G_PKG_NAME
2474: , 'Rounding_Factor'
2468: WHEN OTHERS THEN
2469:
2470: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2471: THEN
2472: OE_MSG_PUB.Add_Exc_Msg
2473: ( G_PKG_NAME
2474: , 'Rounding_Factor'
2475: );
2476: END IF;
2501: EXCEPTION
2502:
2503: WHEN NO_DATA_FOUND THEN
2504:
2505: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2506: THEN
2507:
2508: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
2509: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','secondary_price_list');
2506: THEN
2507:
2508: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
2509: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','secondary_price_list');
2510: OE_MSG_PUB.Add;
2511:
2512: END IF;
2513:
2514: RETURN FALSE;
2514: RETURN FALSE;
2515:
2516: WHEN OTHERS THEN
2517:
2518: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2519: THEN
2520: OE_MSG_PUB.Add_Exc_Msg
2521: ( G_PKG_NAME
2522: , 'Secondary_Price_List'
2516: WHEN OTHERS THEN
2517:
2518: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2519: THEN
2520: OE_MSG_PUB.Add_Exc_Msg
2521: ( G_PKG_NAME
2522: , 'Secondary_Price_List'
2523: );
2524: END IF;
2549: EXCEPTION
2550:
2551: WHEN NO_DATA_FOUND THEN
2552:
2553: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2554: THEN
2555:
2556: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
2557: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','terms');
2554: THEN
2555:
2556: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
2557: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','terms');
2558: OE_MSG_PUB.Add;
2559:
2560: END IF;
2561:
2562: RETURN FALSE;
2562: RETURN FALSE;
2563:
2564: WHEN OTHERS THEN
2565:
2566: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2567: THEN
2568: OE_MSG_PUB.Add_Exc_Msg
2569: ( G_PKG_NAME
2570: , 'Terms'
2564: WHEN OTHERS THEN
2565:
2566: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2567: THEN
2568: OE_MSG_PUB.Add_Exc_Msg
2569: ( G_PKG_NAME
2570: , 'Terms'
2571: );
2572: END IF;
2598: EXCEPTION
2599:
2600: WHEN NO_DATA_FOUND THEN
2601:
2602: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2603: THEN
2604:
2605: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
2606: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','amount');
2603: THEN
2604:
2605: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
2606: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','amount');
2607: OE_MSG_PUB.Add;
2608:
2609: END IF;
2610:
2611: RETURN FALSE;
2611: RETURN FALSE;
2612:
2613: WHEN OTHERS THEN
2614:
2615: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2616: THEN
2617: OE_MSG_PUB.Add_Exc_Msg
2618: ( G_PKG_NAME
2619: , 'Amount'
2613: WHEN OTHERS THEN
2614:
2615: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2616: THEN
2617: OE_MSG_PUB.Add_Exc_Msg
2618: ( G_PKG_NAME
2619: , 'Amount'
2620: );
2621: END IF;
2646: EXCEPTION
2647:
2648: WHEN NO_DATA_FOUND THEN
2649:
2650: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2651: THEN
2652:
2653: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
2654: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','automatic_discount');
2651: THEN
2652:
2653: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
2654: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','automatic_discount');
2655: OE_MSG_PUB.Add;
2656:
2657: END IF;
2658:
2659: RETURN FALSE;
2659: RETURN FALSE;
2660:
2661: WHEN OTHERS THEN
2662:
2663: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2664: THEN
2665: OE_MSG_PUB.Add_Exc_Msg
2666: ( G_PKG_NAME
2667: , 'Automatic_Discount'
2661: WHEN OTHERS THEN
2662:
2663: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2664: THEN
2665: OE_MSG_PUB.Add_Exc_Msg
2666: ( G_PKG_NAME
2667: , 'Automatic_Discount'
2668: );
2669: END IF;
2694: EXCEPTION
2695:
2696: WHEN NO_DATA_FOUND THEN
2697:
2698: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2699: THEN
2700:
2701: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
2702: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','discount_lines');
2699: THEN
2700:
2701: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
2702: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','discount_lines');
2703: OE_MSG_PUB.Add;
2704:
2705: END IF;
2706:
2707: RETURN FALSE;
2707: RETURN FALSE;
2708:
2709: WHEN OTHERS THEN
2710:
2711: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2712: THEN
2713: OE_MSG_PUB.Add_Exc_Msg
2714: ( G_PKG_NAME
2715: , 'Discount_Lines'
2709: WHEN OTHERS THEN
2710:
2711: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2712: THEN
2713: OE_MSG_PUB.Add_Exc_Msg
2714: ( G_PKG_NAME
2715: , 'Discount_Lines'
2716: );
2717: END IF;
2742: EXCEPTION
2743:
2744: WHEN NO_DATA_FOUND THEN
2745:
2746: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2747: THEN
2748:
2749: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
2750: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','discount_type');
2747: THEN
2748:
2749: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
2750: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','discount_type');
2751: OE_MSG_PUB.Add;
2752:
2753: END IF;
2754:
2755: RETURN FALSE;
2755: RETURN FALSE;
2756:
2757: WHEN OTHERS THEN
2758:
2759: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2760: THEN
2761: OE_MSG_PUB.Add_Exc_Msg
2762: ( G_PKG_NAME
2763: , 'Discount_Type'
2757: WHEN OTHERS THEN
2758:
2759: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2760: THEN
2761: OE_MSG_PUB.Add_Exc_Msg
2762: ( G_PKG_NAME
2763: , 'Discount_Type'
2764: );
2765: END IF;
2790: EXCEPTION
2791:
2792: WHEN NO_DATA_FOUND THEN
2793:
2794: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2795: THEN
2796:
2797: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
2798: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','gsa_indicator');
2795: THEN
2796:
2797: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
2798: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','gsa_indicator');
2799: OE_MSG_PUB.Add;
2800:
2801: END IF;
2802:
2803: RETURN FALSE;
2803: RETURN FALSE;
2804:
2805: WHEN OTHERS THEN
2806:
2807: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2808: THEN
2809: OE_MSG_PUB.Add_Exc_Msg
2810: ( G_PKG_NAME
2811: , 'Gsa_Indicator'
2805: WHEN OTHERS THEN
2806:
2807: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2808: THEN
2809: OE_MSG_PUB.Add_Exc_Msg
2810: ( G_PKG_NAME
2811: , 'Gsa_Indicator'
2812: );
2813: END IF;
2838: EXCEPTION
2839:
2840: WHEN NO_DATA_FOUND THEN
2841:
2842: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2843: THEN
2844:
2845: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
2846: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','manual_discount');
2843: THEN
2844:
2845: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
2846: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','manual_discount');
2847: OE_MSG_PUB.Add;
2848:
2849: END IF;
2850:
2851: RETURN FALSE;
2851: RETURN FALSE;
2852:
2853: WHEN OTHERS THEN
2854:
2855: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2856: THEN
2857: OE_MSG_PUB.Add_Exc_Msg
2858: ( G_PKG_NAME
2859: , 'Manual_Discount'
2853: WHEN OTHERS THEN
2854:
2855: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2856: THEN
2857: OE_MSG_PUB.Add_Exc_Msg
2858: ( G_PKG_NAME
2859: , 'Manual_Discount'
2860: );
2861: END IF;
2886: EXCEPTION
2887:
2888: WHEN NO_DATA_FOUND THEN
2889:
2890: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2891: THEN
2892:
2893: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
2894: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','override_allowed');
2891: THEN
2892:
2893: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
2894: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','override_allowed');
2895: OE_MSG_PUB.Add;
2896:
2897: END IF;
2898:
2899: RETURN FALSE;
2899: RETURN FALSE;
2900:
2901: WHEN OTHERS THEN
2902:
2903: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2904: THEN
2905: OE_MSG_PUB.Add_Exc_Msg
2906: ( G_PKG_NAME
2907: , 'Override_Allowed'
2901: WHEN OTHERS THEN
2902:
2903: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2904: THEN
2905: OE_MSG_PUB.Add_Exc_Msg
2906: ( G_PKG_NAME
2907: , 'Override_Allowed'
2908: );
2909: END IF;
2934: EXCEPTION
2935:
2936: WHEN NO_DATA_FOUND THEN
2937:
2938: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2939: THEN
2940:
2941: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
2942: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','percent');
2939: THEN
2940:
2941: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
2942: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','percent');
2943: OE_MSG_PUB.Add;
2944:
2945: END IF;
2946:
2947: RETURN FALSE;
2947: RETURN FALSE;
2948:
2949: WHEN OTHERS THEN
2950:
2951: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2952: THEN
2953: OE_MSG_PUB.Add_Exc_Msg
2954: ( G_PKG_NAME
2955: , 'Percent'
2949: WHEN OTHERS THEN
2950:
2951: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2952: THEN
2953: OE_MSG_PUB.Add_Exc_Msg
2954: ( G_PKG_NAME
2955: , 'Percent'
2956: );
2957: END IF;
2982: EXCEPTION
2983:
2984: WHEN NO_DATA_FOUND THEN
2985:
2986: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2987: THEN
2988:
2989: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
2990: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','prorate');
2987: THEN
2988:
2989: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
2990: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','prorate');
2991: OE_MSG_PUB.Add;
2992:
2993: END IF;
2994:
2995: RETURN FALSE;
2995: RETURN FALSE;
2996:
2997: WHEN OTHERS THEN
2998:
2999: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3000: THEN
3001: OE_MSG_PUB.Add_Exc_Msg
3002: ( G_PKG_NAME
3003: , 'Prorate'
2997: WHEN OTHERS THEN
2998:
2999: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3000: THEN
3001: OE_MSG_PUB.Add_Exc_Msg
3002: ( G_PKG_NAME
3003: , 'Prorate'
3004: );
3005: END IF;
3031: EXCEPTION
3032:
3033: WHEN NO_DATA_FOUND THEN
3034:
3035: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
3036: THEN
3037:
3038: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
3039: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','customer_item');
3036: THEN
3037:
3038: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
3039: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','customer_item');
3040: OE_MSG_PUB.Add;
3041:
3042: END IF;
3043:
3044: RETURN FALSE;
3044: RETURN FALSE;
3045:
3046: WHEN OTHERS THEN
3047:
3048: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3049: THEN
3050: OE_MSG_PUB.Add_Exc_Msg
3051: ( G_PKG_NAME
3052: , 'Customer_Item'
3046: WHEN OTHERS THEN
3047:
3048: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3049: THEN
3050: OE_MSG_PUB.Add_Exc_Msg
3051: ( G_PKG_NAME
3052: , 'Customer_Item'
3053: );
3054: END IF;
3092: EXCEPTION
3093:
3094: WHEN NO_DATA_FOUND THEN
3095:
3096: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
3097: THEN
3098:
3099: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
3100: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','inventory_item');
3097: THEN
3098:
3099: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
3100: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','inventory_item');
3101: OE_MSG_PUB.Add;
3102:
3103: END IF;
3104:
3105: RETURN FALSE;
3105: RETURN FALSE;
3106:
3107: WHEN OTHERS THEN
3108:
3109: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3110: THEN
3111: OE_MSG_PUB.Add_Exc_Msg
3112: ( G_PKG_NAME
3113: , 'Inventory_Item'
3107: WHEN OTHERS THEN
3108:
3109: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3110: THEN
3111: OE_MSG_PUB.Add_Exc_Msg
3112: ( G_PKG_NAME
3113: , 'Inventory_Item'
3114: );
3115: END IF;
3140: EXCEPTION
3141:
3142: WHEN NO_DATA_FOUND THEN
3143:
3144: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
3145: THEN
3146:
3147: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
3148: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','list_price');
3145: THEN
3146:
3147: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
3148: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','list_price');
3149: OE_MSG_PUB.Add;
3150:
3151: END IF;
3152:
3153: RETURN FALSE;
3153: RETURN FALSE;
3154:
3155: WHEN OTHERS THEN
3156:
3157: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3158: THEN
3159: OE_MSG_PUB.Add_Exc_Msg
3160: ( G_PKG_NAME
3161: , 'List_Price'
3155: WHEN OTHERS THEN
3156:
3157: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3158: THEN
3159: OE_MSG_PUB.Add_Exc_Msg
3160: ( G_PKG_NAME
3161: , 'List_Price'
3162: );
3163: END IF;
3188: EXCEPTION
3189:
3190: WHEN NO_DATA_FOUND THEN
3191:
3192: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
3193: THEN
3194:
3195: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
3196: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','method');
3193: THEN
3194:
3195: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
3196: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','method');
3197: OE_MSG_PUB.Add;
3198:
3199: END IF;
3200:
3201: RETURN FALSE;
3201: RETURN FALSE;
3202:
3203: WHEN OTHERS THEN
3204:
3205: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3206: THEN
3207: OE_MSG_PUB.Add_Exc_Msg
3208: ( G_PKG_NAME
3209: , 'Method'
3203: WHEN OTHERS THEN
3204:
3205: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3206: THEN
3207: OE_MSG_PUB.Add_Exc_Msg
3208: ( G_PKG_NAME
3209: , 'Method'
3210: );
3211: END IF;
3236: EXCEPTION
3237:
3238: WHEN NO_DATA_FOUND THEN
3239:
3240: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
3241: THEN
3242:
3243: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
3244: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','price_list_line');
3241: THEN
3242:
3243: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
3244: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','price_list_line');
3245: OE_MSG_PUB.Add;
3246:
3247: END IF;
3248:
3249: RETURN FALSE;
3249: RETURN FALSE;
3250:
3251: WHEN OTHERS THEN
3252:
3253: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3254: THEN
3255: OE_MSG_PUB.Add_Exc_Msg
3256: ( G_PKG_NAME
3257: , 'Price_List_Line'
3251: WHEN OTHERS THEN
3252:
3253: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3254: THEN
3255: OE_MSG_PUB.Add_Exc_Msg
3256: ( G_PKG_NAME
3257: , 'Price_List_Line'
3258: );
3259: END IF;
3284: EXCEPTION
3285:
3286: WHEN NO_DATA_FOUND THEN
3287:
3288: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
3289: THEN
3290:
3291: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
3292: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','pricing_attribute1');
3289: THEN
3290:
3291: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
3292: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','pricing_attribute1');
3293: OE_MSG_PUB.Add;
3294:
3295: END IF;
3296:
3297: RETURN FALSE;
3297: RETURN FALSE;
3298:
3299: WHEN OTHERS THEN
3300:
3301: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3302: THEN
3303: OE_MSG_PUB.Add_Exc_Msg
3304: ( G_PKG_NAME
3305: , 'Pricing_Attribute1'
3299: WHEN OTHERS THEN
3300:
3301: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3302: THEN
3303: OE_MSG_PUB.Add_Exc_Msg
3304: ( G_PKG_NAME
3305: , 'Pricing_Attribute1'
3306: );
3307: END IF;
3332: EXCEPTION
3333:
3334: WHEN NO_DATA_FOUND THEN
3335:
3336: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
3337: THEN
3338:
3339: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
3340: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','pricing_attribute10');
3337: THEN
3338:
3339: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
3340: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','pricing_attribute10');
3341: OE_MSG_PUB.Add;
3342:
3343: END IF;
3344:
3345: RETURN FALSE;
3345: RETURN FALSE;
3346:
3347: WHEN OTHERS THEN
3348:
3349: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3350: THEN
3351: OE_MSG_PUB.Add_Exc_Msg
3352: ( G_PKG_NAME
3353: , 'Pricing_Attribute10'
3347: WHEN OTHERS THEN
3348:
3349: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3350: THEN
3351: OE_MSG_PUB.Add_Exc_Msg
3352: ( G_PKG_NAME
3353: , 'Pricing_Attribute10'
3354: );
3355: END IF;
3380: EXCEPTION
3381:
3382: WHEN NO_DATA_FOUND THEN
3383:
3384: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
3385: THEN
3386:
3387: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
3388: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','pricing_attribute11');
3385: THEN
3386:
3387: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
3388: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','pricing_attribute11');
3389: OE_MSG_PUB.Add;
3390:
3391: END IF;
3392:
3393: RETURN FALSE;
3393: RETURN FALSE;
3394:
3395: WHEN OTHERS THEN
3396:
3397: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3398: THEN
3399: OE_MSG_PUB.Add_Exc_Msg
3400: ( G_PKG_NAME
3401: , 'Pricing_Attribute11'
3395: WHEN OTHERS THEN
3396:
3397: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3398: THEN
3399: OE_MSG_PUB.Add_Exc_Msg
3400: ( G_PKG_NAME
3401: , 'Pricing_Attribute11'
3402: );
3403: END IF;
3428: EXCEPTION
3429:
3430: WHEN NO_DATA_FOUND THEN
3431:
3432: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
3433: THEN
3434:
3435: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
3436: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','pricing_attribute12');
3433: THEN
3434:
3435: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
3436: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','pricing_attribute12');
3437: OE_MSG_PUB.Add;
3438:
3439: END IF;
3440:
3441: RETURN FALSE;
3441: RETURN FALSE;
3442:
3443: WHEN OTHERS THEN
3444:
3445: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3446: THEN
3447: OE_MSG_PUB.Add_Exc_Msg
3448: ( G_PKG_NAME
3449: , 'Pricing_Attribute12'
3443: WHEN OTHERS THEN
3444:
3445: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3446: THEN
3447: OE_MSG_PUB.Add_Exc_Msg
3448: ( G_PKG_NAME
3449: , 'Pricing_Attribute12'
3450: );
3451: END IF;
3476: EXCEPTION
3477:
3478: WHEN NO_DATA_FOUND THEN
3479:
3480: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
3481: THEN
3482:
3483: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
3484: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','pricing_attribute13');
3481: THEN
3482:
3483: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
3484: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','pricing_attribute13');
3485: OE_MSG_PUB.Add;
3486:
3487: END IF;
3488:
3489: RETURN FALSE;
3489: RETURN FALSE;
3490:
3491: WHEN OTHERS THEN
3492:
3493: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3494: THEN
3495: OE_MSG_PUB.Add_Exc_Msg
3496: ( G_PKG_NAME
3497: , 'Pricing_Attribute13'
3491: WHEN OTHERS THEN
3492:
3493: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3494: THEN
3495: OE_MSG_PUB.Add_Exc_Msg
3496: ( G_PKG_NAME
3497: , 'Pricing_Attribute13'
3498: );
3499: END IF;
3524: EXCEPTION
3525:
3526: WHEN NO_DATA_FOUND THEN
3527:
3528: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
3529: THEN
3530:
3531: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
3532: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','pricing_attribute14');
3529: THEN
3530:
3531: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
3532: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','pricing_attribute14');
3533: OE_MSG_PUB.Add;
3534:
3535: END IF;
3536:
3537: RETURN FALSE;
3537: RETURN FALSE;
3538:
3539: WHEN OTHERS THEN
3540:
3541: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3542: THEN
3543: OE_MSG_PUB.Add_Exc_Msg
3544: ( G_PKG_NAME
3545: , 'Pricing_Attribute14'
3539: WHEN OTHERS THEN
3540:
3541: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3542: THEN
3543: OE_MSG_PUB.Add_Exc_Msg
3544: ( G_PKG_NAME
3545: , 'Pricing_Attribute14'
3546: );
3547: END IF;
3572: EXCEPTION
3573:
3574: WHEN NO_DATA_FOUND THEN
3575:
3576: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
3577: THEN
3578:
3579: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
3580: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','pricing_attribute15');
3577: THEN
3578:
3579: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
3580: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','pricing_attribute15');
3581: OE_MSG_PUB.Add;
3582:
3583: END IF;
3584:
3585: RETURN FALSE;
3585: RETURN FALSE;
3586:
3587: WHEN OTHERS THEN
3588:
3589: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3590: THEN
3591: OE_MSG_PUB.Add_Exc_Msg
3592: ( G_PKG_NAME
3593: , 'Pricing_Attribute15'
3587: WHEN OTHERS THEN
3588:
3589: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3590: THEN
3591: OE_MSG_PUB.Add_Exc_Msg
3592: ( G_PKG_NAME
3593: , 'Pricing_Attribute15'
3594: );
3595: END IF;
3620: EXCEPTION
3621:
3622: WHEN NO_DATA_FOUND THEN
3623:
3624: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
3625: THEN
3626:
3627: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
3628: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','pricing_attribute2');
3625: THEN
3626:
3627: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
3628: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','pricing_attribute2');
3629: OE_MSG_PUB.Add;
3630:
3631: END IF;
3632:
3633: RETURN FALSE;
3633: RETURN FALSE;
3634:
3635: WHEN OTHERS THEN
3636:
3637: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3638: THEN
3639: OE_MSG_PUB.Add_Exc_Msg
3640: ( G_PKG_NAME
3641: , 'Pricing_Attribute2'
3635: WHEN OTHERS THEN
3636:
3637: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3638: THEN
3639: OE_MSG_PUB.Add_Exc_Msg
3640: ( G_PKG_NAME
3641: , 'Pricing_Attribute2'
3642: );
3643: END IF;
3668: EXCEPTION
3669:
3670: WHEN NO_DATA_FOUND THEN
3671:
3672: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
3673: THEN
3674:
3675: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
3676: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','pricing_attribute3');
3673: THEN
3674:
3675: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
3676: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','pricing_attribute3');
3677: OE_MSG_PUB.Add;
3678:
3679: END IF;
3680:
3681: RETURN FALSE;
3681: RETURN FALSE;
3682:
3683: WHEN OTHERS THEN
3684:
3685: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3686: THEN
3687: OE_MSG_PUB.Add_Exc_Msg
3688: ( G_PKG_NAME
3689: , 'Pricing_Attribute3'
3683: WHEN OTHERS THEN
3684:
3685: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3686: THEN
3687: OE_MSG_PUB.Add_Exc_Msg
3688: ( G_PKG_NAME
3689: , 'Pricing_Attribute3'
3690: );
3691: 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_ERROR)
3721: THEN
3722:
3723: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
3724: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','pricing_attribute4');
3721: THEN
3722:
3723: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
3724: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','pricing_attribute4');
3725: OE_MSG_PUB.Add;
3726:
3727: END IF;
3728:
3729: RETURN FALSE;
3729: RETURN FALSE;
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: , 'Pricing_Attribute4'
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: , 'Pricing_Attribute4'
3738: );
3739: END IF;
3764: EXCEPTION
3765:
3766: WHEN NO_DATA_FOUND THEN
3767:
3768: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
3769: THEN
3770:
3771: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
3772: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','pricing_attribute5');
3769: THEN
3770:
3771: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
3772: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','pricing_attribute5');
3773: OE_MSG_PUB.Add;
3774:
3775: END IF;
3776:
3777: RETURN FALSE;
3777: RETURN FALSE;
3778:
3779: WHEN OTHERS THEN
3780:
3781: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3782: THEN
3783: OE_MSG_PUB.Add_Exc_Msg
3784: ( G_PKG_NAME
3785: , 'Pricing_Attribute5'
3779: WHEN OTHERS THEN
3780:
3781: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3782: THEN
3783: OE_MSG_PUB.Add_Exc_Msg
3784: ( G_PKG_NAME
3785: , 'Pricing_Attribute5'
3786: );
3787: END IF;
3812: EXCEPTION
3813:
3814: WHEN NO_DATA_FOUND THEN
3815:
3816: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
3817: THEN
3818:
3819: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
3820: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','pricing_attribute6');
3817: THEN
3818:
3819: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
3820: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','pricing_attribute6');
3821: OE_MSG_PUB.Add;
3822:
3823: END IF;
3824:
3825: RETURN FALSE;
3825: RETURN FALSE;
3826:
3827: WHEN OTHERS THEN
3828:
3829: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3830: THEN
3831: OE_MSG_PUB.Add_Exc_Msg
3832: ( G_PKG_NAME
3833: , 'Pricing_Attribute6'
3827: WHEN OTHERS THEN
3828:
3829: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3830: THEN
3831: OE_MSG_PUB.Add_Exc_Msg
3832: ( G_PKG_NAME
3833: , 'Pricing_Attribute6'
3834: );
3835: END IF;
3860: EXCEPTION
3861:
3862: WHEN NO_DATA_FOUND THEN
3863:
3864: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
3865: THEN
3866:
3867: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
3868: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','pricing_attribute7');
3865: THEN
3866:
3867: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
3868: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','pricing_attribute7');
3869: OE_MSG_PUB.Add;
3870:
3871: END IF;
3872:
3873: RETURN FALSE;
3873: RETURN FALSE;
3874:
3875: WHEN OTHERS THEN
3876:
3877: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3878: THEN
3879: OE_MSG_PUB.Add_Exc_Msg
3880: ( G_PKG_NAME
3881: , 'Pricing_Attribute7'
3875: WHEN OTHERS THEN
3876:
3877: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3878: THEN
3879: OE_MSG_PUB.Add_Exc_Msg
3880: ( G_PKG_NAME
3881: , 'Pricing_Attribute7'
3882: );
3883: END IF;
3908: EXCEPTION
3909:
3910: WHEN NO_DATA_FOUND THEN
3911:
3912: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
3913: THEN
3914:
3915: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
3916: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','pricing_attribute8');
3913: THEN
3914:
3915: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
3916: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','pricing_attribute8');
3917: OE_MSG_PUB.Add;
3918:
3919: END IF;
3920:
3921: RETURN FALSE;
3921: RETURN FALSE;
3922:
3923: WHEN OTHERS THEN
3924:
3925: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3926: THEN
3927: OE_MSG_PUB.Add_Exc_Msg
3928: ( G_PKG_NAME
3929: , 'Pricing_Attribute8'
3923: WHEN OTHERS THEN
3924:
3925: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3926: THEN
3927: OE_MSG_PUB.Add_Exc_Msg
3928: ( G_PKG_NAME
3929: , 'Pricing_Attribute8'
3930: );
3931: END IF;
3956: EXCEPTION
3957:
3958: WHEN NO_DATA_FOUND THEN
3959:
3960: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
3961: THEN
3962:
3963: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
3964: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','pricing_attribute9');
3961: THEN
3962:
3963: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
3964: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','pricing_attribute9');
3965: OE_MSG_PUB.Add;
3966:
3967: END IF;
3968:
3969: RETURN FALSE;
3969: RETURN FALSE;
3970:
3971: WHEN OTHERS THEN
3972:
3973: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3974: THEN
3975: OE_MSG_PUB.Add_Exc_Msg
3976: ( G_PKG_NAME
3977: , 'Pricing_Attribute9'
3971: WHEN OTHERS THEN
3972:
3973: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3974: THEN
3975: OE_MSG_PUB.Add_Exc_Msg
3976: ( G_PKG_NAME
3977: , 'Pricing_Attribute9'
3978: );
3979: END IF;
4004: EXCEPTION
4005:
4006: WHEN NO_DATA_FOUND THEN
4007:
4008: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4009: THEN
4010:
4011: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
4012: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','pricing_context');
4009: THEN
4010:
4011: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
4012: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','pricing_context');
4013: OE_MSG_PUB.Add;
4014:
4015: END IF;
4016:
4017: RETURN FALSE;
4017: RETURN FALSE;
4018:
4019: WHEN OTHERS THEN
4020:
4021: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4022: THEN
4023: OE_MSG_PUB.Add_Exc_Msg
4024: ( G_PKG_NAME
4025: , 'Pricing_Context'
4019: WHEN OTHERS THEN
4020:
4021: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4022: THEN
4023: OE_MSG_PUB.Add_Exc_Msg
4024: ( G_PKG_NAME
4025: , 'Pricing_Context'
4026: );
4027: END IF;
4052: EXCEPTION
4053:
4054: WHEN NO_DATA_FOUND THEN
4055:
4056: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4057: THEN
4058:
4059: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
4060: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','pricing_rule');
4057: THEN
4058:
4059: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
4060: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','pricing_rule');
4061: OE_MSG_PUB.Add;
4062:
4063: END IF;
4064:
4065: RETURN FALSE;
4065: RETURN FALSE;
4066:
4067: WHEN OTHERS THEN
4068:
4069: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4070: THEN
4071: OE_MSG_PUB.Add_Exc_Msg
4072: ( G_PKG_NAME
4073: , 'Pricing_Rule'
4067: WHEN OTHERS THEN
4068:
4069: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4070: THEN
4071: OE_MSG_PUB.Add_Exc_Msg
4072: ( G_PKG_NAME
4073: , 'Pricing_Rule'
4074: );
4075: END IF;
4100: EXCEPTION
4101:
4102: WHEN NO_DATA_FOUND THEN
4103:
4104: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4105: THEN
4106:
4107: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
4108: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','reprice');
4105: THEN
4106:
4107: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
4108: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','reprice');
4109: OE_MSG_PUB.Add;
4110:
4111: END IF;
4112:
4113: RETURN FALSE;
4113: RETURN FALSE;
4114:
4115: WHEN OTHERS THEN
4116:
4117: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4118: THEN
4119: OE_MSG_PUB.Add_Exc_Msg
4120: ( G_PKG_NAME
4121: , 'Reprice'
4115: WHEN OTHERS THEN
4116:
4117: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4118: THEN
4119: OE_MSG_PUB.Add_Exc_Msg
4120: ( G_PKG_NAME
4121: , 'Reprice'
4122: );
4123: END IF;
4148: EXCEPTION
4149:
4150: WHEN NO_DATA_FOUND THEN
4151:
4152: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4153: THEN
4154:
4155: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
4156: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','unit');
4153: THEN
4154:
4155: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
4156: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','unit');
4157: OE_MSG_PUB.Add;
4158:
4159: END IF;
4160:
4161: RETURN FALSE;
4161: RETURN FALSE;
4162:
4163: WHEN OTHERS THEN
4164:
4165: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4166: THEN
4167: OE_MSG_PUB.Add_Exc_Msg
4168: ( G_PKG_NAME
4169: , 'Unit'
4163: WHEN OTHERS THEN
4164:
4165: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4166: THEN
4167: OE_MSG_PUB.Add_Exc_Msg
4168: ( G_PKG_NAME
4169: , 'Unit'
4170: );
4171: END IF;
4197: EXCEPTION
4198:
4199: WHEN NO_DATA_FOUND THEN
4200:
4201: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4202: THEN
4203:
4204: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
4205: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','customer_class');
4202: THEN
4203:
4204: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
4205: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','customer_class');
4206: OE_MSG_PUB.Add;
4207:
4208: END IF;
4209:
4210: RETURN FALSE;
4210: RETURN FALSE;
4211:
4212: WHEN OTHERS THEN
4213:
4214: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4215: THEN
4216: OE_MSG_PUB.Add_Exc_Msg
4217: ( G_PKG_NAME
4218: , 'Customer_Class'
4212: WHEN OTHERS THEN
4213:
4214: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4215: THEN
4216: OE_MSG_PUB.Add_Exc_Msg
4217: ( G_PKG_NAME
4218: , 'Customer_Class'
4219: );
4220: END IF;
4245: EXCEPTION
4246:
4247: WHEN NO_DATA_FOUND THEN
4248:
4249: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4250: THEN
4251:
4252: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
4253: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','discount_customer');
4250: THEN
4251:
4252: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
4253: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','discount_customer');
4254: OE_MSG_PUB.Add;
4255:
4256: END IF;
4257:
4258: RETURN FALSE;
4258: RETURN FALSE;
4259:
4260: WHEN OTHERS THEN
4261:
4262: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4263: THEN
4264: OE_MSG_PUB.Add_Exc_Msg
4265: ( G_PKG_NAME
4266: , 'Discount_Customer'
4260: WHEN OTHERS THEN
4261:
4262: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4263: THEN
4264: OE_MSG_PUB.Add_Exc_Msg
4265: ( G_PKG_NAME
4266: , 'Discount_Customer'
4267: );
4268: END IF;
4300: EXCEPTION
4301:
4302: WHEN NO_DATA_FOUND THEN
4303:
4304: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4305: THEN
4306:
4307: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
4308: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','site_use');
4305: THEN
4306:
4307: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
4308: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','site_use');
4309: OE_MSG_PUB.Add;
4310:
4311: END IF;
4312:
4313: RETURN FALSE;
4313: RETURN FALSE;
4314:
4315: WHEN OTHERS THEN
4316:
4317: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4318: THEN
4319: OE_MSG_PUB.Add_Exc_Msg
4320: ( G_PKG_NAME
4321: , 'Site_Use'
4315: WHEN OTHERS THEN
4316:
4317: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4318: THEN
4319: OE_MSG_PUB.Add_Exc_Msg
4320: ( G_PKG_NAME
4321: , 'Site_Use'
4322: );
4323: END IF;
4349: EXCEPTION
4350:
4351: WHEN NO_DATA_FOUND THEN
4352:
4353: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4354: THEN
4355:
4356: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
4357: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','discount_line');
4354: THEN
4355:
4356: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
4357: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','discount_line');
4358: OE_MSG_PUB.Add;
4359:
4360: END IF;
4361:
4362: RETURN FALSE;
4362: RETURN FALSE;
4363:
4364: WHEN OTHERS THEN
4365:
4366: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4367: THEN
4368: OE_MSG_PUB.Add_Exc_Msg
4369: ( G_PKG_NAME
4370: , 'Discount_Line'
4364: WHEN OTHERS THEN
4365:
4366: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4367: THEN
4368: OE_MSG_PUB.Add_Exc_Msg
4369: ( G_PKG_NAME
4370: , 'Discount_Line'
4371: );
4372: END IF;
4397: EXCEPTION
4398:
4399: WHEN NO_DATA_FOUND THEN
4400:
4401: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4402: THEN
4403:
4404: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
4405: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','entity');
4402: THEN
4403:
4404: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
4405: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','entity');
4406: OE_MSG_PUB.Add;
4407:
4408: END IF;
4409:
4410: RETURN FALSE;
4410: RETURN FALSE;
4411:
4412: WHEN OTHERS THEN
4413:
4414: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4415: THEN
4416: OE_MSG_PUB.Add_Exc_Msg
4417: ( G_PKG_NAME
4418: , 'Entity'
4412: WHEN OTHERS THEN
4413:
4414: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4415: THEN
4416: OE_MSG_PUB.Add_Exc_Msg
4417: ( G_PKG_NAME
4418: , 'Entity'
4419: );
4420: END IF;
4445: EXCEPTION
4446:
4447: WHEN NO_DATA_FOUND THEN
4448:
4449: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4450: THEN
4451:
4452: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
4453: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','entity_value');
4450: THEN
4451:
4452: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
4453: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','entity_value');
4454: OE_MSG_PUB.Add;
4455:
4456: END IF;
4457:
4458: RETURN FALSE;
4458: RETURN FALSE;
4459:
4460: WHEN OTHERS THEN
4461:
4462: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4463: THEN
4464: OE_MSG_PUB.Add_Exc_Msg
4465: ( G_PKG_NAME
4466: , 'Entity_Value'
4460: WHEN OTHERS THEN
4461:
4462: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4463: THEN
4464: OE_MSG_PUB.Add_Exc_Msg
4465: ( G_PKG_NAME
4466: , 'Entity_Value'
4467: );
4468: END IF;
4493: EXCEPTION
4494:
4495: WHEN NO_DATA_FOUND THEN
4496:
4497: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4498: THEN
4499:
4500: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
4501: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','price');
4498: THEN
4499:
4500: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
4501: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','price');
4502: OE_MSG_PUB.Add;
4503:
4504: END IF;
4505:
4506: RETURN FALSE;
4506: RETURN FALSE;
4507:
4508: WHEN OTHERS THEN
4509:
4510: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4511: THEN
4512: OE_MSG_PUB.Add_Exc_Msg
4513: ( G_PKG_NAME
4514: , 'Price'
4508: WHEN OTHERS THEN
4509:
4510: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4511: THEN
4512: OE_MSG_PUB.Add_Exc_Msg
4513: ( G_PKG_NAME
4514: , 'Price'
4515: );
4516: END IF;
4542: EXCEPTION
4543:
4544: WHEN NO_DATA_FOUND THEN
4545:
4546: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4547: THEN
4548:
4549: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
4550: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','method_type');
4547: THEN
4548:
4549: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
4550: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','method_type');
4551: OE_MSG_PUB.Add;
4552:
4553: END IF;
4554:
4555: RETURN FALSE;
4555: RETURN FALSE;
4556:
4557: WHEN OTHERS THEN
4558:
4559: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4560: THEN
4561: OE_MSG_PUB.Add_Exc_Msg
4562: ( G_PKG_NAME
4563: , 'Method_Type'
4557: WHEN OTHERS THEN
4558:
4559: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4560: THEN
4561: OE_MSG_PUB.Add_Exc_Msg
4562: ( G_PKG_NAME
4563: , 'Method_Type'
4564: );
4565: END IF;
4590: EXCEPTION
4591:
4592: WHEN NO_DATA_FOUND THEN
4593:
4594: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4595: THEN
4596:
4597: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
4598: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','price_break_high');
4595: THEN
4596:
4597: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
4598: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','price_break_high');
4599: OE_MSG_PUB.Add;
4600:
4601: END IF;
4602:
4603: RETURN FALSE;
4603: RETURN FALSE;
4604:
4605: WHEN OTHERS THEN
4606:
4607: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4608: THEN
4609: OE_MSG_PUB.Add_Exc_Msg
4610: ( G_PKG_NAME
4611: , 'Price_Break_High'
4605: WHEN OTHERS THEN
4606:
4607: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4608: THEN
4609: OE_MSG_PUB.Add_Exc_Msg
4610: ( G_PKG_NAME
4611: , 'Price_Break_High'
4612: );
4613: END IF;
4638: EXCEPTION
4639:
4640: WHEN NO_DATA_FOUND THEN
4641:
4642: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4643: THEN
4644:
4645: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
4646: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','price_break_low');
4643: THEN
4644:
4645: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
4646: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','price_break_low');
4647: OE_MSG_PUB.Add;
4648:
4649: END IF;
4650:
4651: RETURN FALSE;
4651: RETURN FALSE;
4652:
4653: WHEN OTHERS THEN
4654:
4655: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4656: THEN
4657: OE_MSG_PUB.Add_Exc_Msg
4658: ( G_PKG_NAME
4659: , 'Price_Break_Low'
4653: WHEN OTHERS THEN
4654:
4655: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4656: THEN
4657: OE_MSG_PUB.Add_Exc_Msg
4658: ( G_PKG_NAME
4659: , 'Price_Break_Low'
4660: );
4661: END IF;
4742: (p_end_date_active between
4743: start_date_active and end_date_active ));
4744:
4745:
4746: /* IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4747: THEN
4748: FND_MESSAGE.SET_NAME('OE','XXXX' || l_row_count );
4749: FND_MESSAGE.SET_TOKEN('REVISION','revision');
4750: OE_MSG_PUB.Add;
4746: /* IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4747: THEN
4748: FND_MESSAGE.SET_NAME('OE','XXXX' || l_row_count );
4749: FND_MESSAGE.SET_TOKEN('REVISION','revision');
4750: OE_MSG_PUB.Add;
4751: END IF;
4752: */
4753:
4754: --------------
4763: EXCEPTION
4764:
4765: WHEN OTHERS THEN
4766:
4767: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4768: THEN
4769: OE_MSG_PUB.Add_Exc_Msg
4770: ( G_PKG_NAME
4771: , 'PRIMARY_EXISTS'
4765: WHEN OTHERS THEN
4766:
4767: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4768: THEN
4769: OE_MSG_PUB.Add_Exc_Msg
4770: ( G_PKG_NAME
4771: , 'PRIMARY_EXISTS'
4772: );
4773: END IF;
4797: EXCEPTION
4798:
4799: WHEN NO_DATA_FOUND THEN
4800:
4801: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4802: THEN
4803:
4804: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
4805: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','PRIMARY');
4802: THEN
4803:
4804: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
4805: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','PRIMARY');
4806: OE_MSG_PUB.Add;
4807:
4808: END IF;
4809:
4810: RETURN FALSE;
4810: RETURN FALSE;
4811:
4812: WHEN OTHERS THEN
4813:
4814: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4815: THEN
4816: OE_MSG_PUB.Add_Exc_Msg
4817: ( G_PKG_NAME
4818: , 'PRIMARY'
4812: WHEN OTHERS THEN
4813:
4814: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4815: THEN
4816: OE_MSG_PUB.Add_Exc_Msg
4817: ( G_PKG_NAME
4818: , 'PRIMARY'
4819: );
4820: END IF;
4845: EXCEPTION
4846:
4847: WHEN NO_DATA_FOUND THEN
4848:
4849: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4850: THEN
4851:
4852: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
4853: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','List_Line_Type');
4850: THEN
4851:
4852: FND_MESSAGE.SET_NAME('OE','OE_INVALID_ATTRIBUTE');
4853: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','List_Line_Type');
4854: OE_MSG_PUB.Add;
4855:
4856: END IF;
4857:
4858: RETURN FALSE;
4858: RETURN FALSE;
4859:
4860: WHEN OTHERS THEN
4861:
4862: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4863: THEN
4864: OE_MSG_PUB.Add_Exc_Msg
4865: ( G_PKG_NAME
4866: , 'List Line Type'
4860: WHEN OTHERS THEN
4861:
4862: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4863: THEN
4864: OE_MSG_PUB.Add_Exc_Msg
4865: ( G_PKG_NAME
4866: , 'List Line Type'
4867: );
4868: END IF;