APPS.OE_CNCL_VALUE_TO_ID dependencies on OE_MSG_PUB

Line 62: OE_MSG_PUB.Add;

58: -- Error getting combination id.
59: -- Function has already pushed a message on the stack. Add to
60: -- the API message list.
61:
62: OE_MSG_PUB.Add;
63: l_id := FND_API.G_MISS_NUM;
64:
65: END IF;
66:

Line 73: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

69: EXCEPTION
70:
71: WHEN OTHERS THEN
72:
73: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
74: THEN
75: OE_MSG_PUB.Add_Exc_Msg
76: ( G_PKG_NAME
77: , 'Key_Flex'

Line 75: OE_MSG_PUB.Add_Exc_Msg

71: WHEN OTHERS THEN
72:
73: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
74: THEN
75: OE_MSG_PUB.Add_Exc_Msg
76: ( G_PKG_NAME
77: , 'Key_Flex'
78: );
79: END IF;

Line 113: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

109: EXCEPTION
110:
111: WHEN NO_DATA_FOUND THEN
112:
113: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
114: THEN
115:
116: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
117: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','accounting_rule_id');

Line 118: OE_MSG_PUB.Add;

114: THEN
115:
116: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
117: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','accounting_rule_id');
118: OE_MSG_PUB.Add;
119:
120: END IF;
121:
122: RETURN FND_API.G_MISS_NUM;

Line 126: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

122: RETURN FND_API.G_MISS_NUM;
123:
124: WHEN OTHERS THEN
125:
126: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
127: THEN
128: OE_MSG_PUB.Add_Exc_Msg
129: ( G_PKG_NAME
130: , 'Accounting_Rule'

Line 128: OE_MSG_PUB.Add_Exc_Msg

124: WHEN OTHERS THEN
125:
126: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
127: THEN
128: OE_MSG_PUB.Add_Exc_Msg
129: ( G_PKG_NAME
130: , 'Accounting_Rule'
131: );
132: END IF;

Line 163: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

159: EXCEPTION
160:
161: WHEN NO_DATA_FOUND THEN
162:
163: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
164: THEN
165:
166: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
167: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','agreement_id');

Line 168: OE_MSG_PUB.Add;

164: THEN
165:
166: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
167: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','agreement_id');
168: OE_MSG_PUB.Add;
169:
170: END IF;
171:
172: RETURN FND_API.G_MISS_NUM;

Line 176: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

172: RETURN FND_API.G_MISS_NUM;
173:
174: WHEN OTHERS THEN
175:
176: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
177: THEN
178: OE_MSG_PUB.Add_Exc_Msg
179: ( G_PKG_NAME
180: , 'Agreement'

Line 178: OE_MSG_PUB.Add_Exc_Msg

174: WHEN OTHERS THEN
175:
176: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
177: THEN
178: OE_MSG_PUB.Add_Exc_Msg
179: ( G_PKG_NAME
180: , 'Agreement'
181: );
182: END IF;

Line 213: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

209: EXCEPTION
210:
211: WHEN NO_DATA_FOUND THEN
212:
213: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
214: THEN
215:
216: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
217: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','conversion_type_code');

Line 218: OE_MSG_PUB.Add;

214: THEN
215:
216: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
217: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','conversion_type_code');
218: OE_MSG_PUB.Add;
219:
220: END IF;
221:
222: RETURN FND_API.G_MISS_CHAR;

Line 226: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

222: RETURN FND_API.G_MISS_CHAR;
223:
224: WHEN OTHERS THEN
225:
226: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
227: THEN
228: OE_MSG_PUB.Add_Exc_Msg
229: ( G_PKG_NAME
230: , 'Conversion_Type'

Line 228: OE_MSG_PUB.Add_Exc_Msg

224: WHEN OTHERS THEN
225:
226: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
227: THEN
228: OE_MSG_PUB.Add_Exc_Msg
229: ( G_PKG_NAME
230: , 'Conversion_Type'
231: );
232: END IF;

Line 271: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

267: EXCEPTION
268:
269: WHEN NO_DATA_FOUND THEN
270:
271: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
272: THEN
273:
274: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
275: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','deliver_to_contact_id');

Line 276: OE_MSG_PUB.Add;

272: THEN
273:
274: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
275: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','deliver_to_contact_id');
276: OE_MSG_PUB.Add;
277:
278: END IF;
279:
280: RETURN FND_API.G_MISS_NUM;

Line 284: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

280: RETURN FND_API.G_MISS_NUM;
281:
282: WHEN OTHERS THEN
283:
284: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
285: THEN
286: OE_MSG_PUB.Add_Exc_Msg
287: ( G_PKG_NAME
288: , 'Deliver_To_Contact'

Line 286: OE_MSG_PUB.Add_Exc_Msg

282: WHEN OTHERS THEN
283:
284: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
285: THEN
286: OE_MSG_PUB.Add_Exc_Msg
287: ( G_PKG_NAME
288: , 'Deliver_To_Contact'
289: );
290: END IF;

Line 539: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

535: CLOSE C2;
536: END IF;
537:
538:
539: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
540: THEN
541:
542: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
543: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','deliver_to_org_id');

Line 544: OE_MSG_PUB.Add;

540: THEN
541:
542: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
543: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','deliver_to_org_id');
544: OE_MSG_PUB.Add;
545:
546: END IF;
547:
548: RETURN FND_API.G_MISS_NUM;

Line 565: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

561: CLOSE C2;
562: END IF;
563:
564:
565: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
566: THEN
567: OE_MSG_PUB.Add_Exc_Msg
568: ( G_PKG_NAME
569: , 'Deliver_To_Org'

Line 567: OE_MSG_PUB.Add_Exc_Msg

563:
564:
565: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
566: THEN
567: OE_MSG_PUB.Add_Exc_Msg
568: ( G_PKG_NAME
569: , 'Deliver_To_Org'
570: );
571: END IF;

Line 604: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

600: EXCEPTION
601:
602: WHEN NO_DATA_FOUND THEN
603:
604: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
605: THEN
606:
607: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
608: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','fob_point_code');

Line 609: OE_MSG_PUB.Add;

605: THEN
606:
607: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
608: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','fob_point_code');
609: OE_MSG_PUB.Add;
610:
611: END IF;
612:
613: RETURN FND_API.G_MISS_CHAR;

Line 617: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

613: RETURN FND_API.G_MISS_CHAR;
614:
615: WHEN OTHERS THEN
616:
617: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
618: THEN
619: OE_MSG_PUB.Add_Exc_Msg
620: ( G_PKG_NAME
621: , 'Fob_Point'

Line 619: OE_MSG_PUB.Add_Exc_Msg

615: WHEN OTHERS THEN
616:
617: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
618: THEN
619: OE_MSG_PUB.Add_Exc_Msg
620: ( G_PKG_NAME
621: , 'Fob_Point'
622: );
623: END IF;

Line 656: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

652: EXCEPTION
653:
654: WHEN NO_DATA_FOUND THEN
655:
656: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
657: THEN
658:
659: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
660: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','freight_terms_code');

Line 661: OE_MSG_PUB.Add;

657: THEN
658:
659: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
660: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','freight_terms_code');
661: OE_MSG_PUB.Add;
662:
663: END IF;
664:
665: RETURN FND_API.G_MISS_CHAR;

Line 669: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

665: RETURN FND_API.G_MISS_CHAR;
666:
667: WHEN OTHERS THEN
668:
669: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
670: THEN
671: OE_MSG_PUB.Add_Exc_Msg
672: ( G_PKG_NAME
673: , 'Freight_Terms'

Line 671: OE_MSG_PUB.Add_Exc_Msg

667: WHEN OTHERS THEN
668:
669: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
670: THEN
671: OE_MSG_PUB.Add_Exc_Msg
672: ( G_PKG_NAME
673: , 'Freight_Terms'
674: );
675: END IF;

Line 707: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

703: EXCEPTION
704:
705: WHEN NO_DATA_FOUND THEN
706:
707: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
708: THEN
709:
710: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
711: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','intermed_ship_to_contact_id');

Line 712: OE_MSG_PUB.Add;

708: THEN
709:
710: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
711: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','intermed_ship_to_contact_id');
712: OE_MSG_PUB.Add;
713:
714: END IF;
715:
716: RETURN FND_API.G_MISS_NUM;

Line 721: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

717:
718:
719: WHEN OTHERS THEN
720:
721: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
722: THEN
723: OE_MSG_PUB.Add_Exc_Msg
724: ( G_PKG_NAME
725: , 'Intermed_Ship_To_Contact'

Line 723: OE_MSG_PUB.Add_Exc_Msg

719: WHEN OTHERS THEN
720:
721: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
722: THEN
723: OE_MSG_PUB.Add_Exc_Msg
724: ( G_PKG_NAME
725: , 'Intermed_Ship_To_Contact'
726: );
727: END IF;

Line 772: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

768: EXCEPTION
769:
770: WHEN NO_DATA_FOUND THEN
771:
772: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
773: THEN
774:
775: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
776: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','intermed_ship_to_org_id');

Line 777: OE_MSG_PUB.Add;

773: THEN
774:
775: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
776: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','intermed_ship_to_org_id');
777: OE_MSG_PUB.Add;
778:
779: END IF;
780:
781: RETURN FND_API.G_MISS_NUM;

Line 785: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

781: RETURN FND_API.G_MISS_NUM;
782:
783: WHEN OTHERS THEN
784:
785: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
786: THEN
787: OE_MSG_PUB.Add_Exc_Msg
788: ( G_PKG_NAME
789: , 'Intermed_Ship_To_Org'

Line 787: OE_MSG_PUB.Add_Exc_Msg

783: WHEN OTHERS THEN
784:
785: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
786: THEN
787: OE_MSG_PUB.Add_Exc_Msg
788: ( G_PKG_NAME
789: , 'Intermed_Ship_To_Org'
790: );
791: END IF;

Line 830: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

826: EXCEPTION
827:
828: WHEN NO_DATA_FOUND THEN
829:
830: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
831: THEN
832:
833: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
834: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','invoice_to_contact_id');

Line 835: OE_MSG_PUB.Add;

831: THEN
832:
833: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
834: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','invoice_to_contact_id');
835: OE_MSG_PUB.Add;
836:
837: END IF;
838:
839: RETURN FND_API.G_MISS_NUM;

Line 843: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

839: RETURN FND_API.G_MISS_NUM;
840:
841: WHEN OTHERS THEN
842:
843: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
844: THEN
845: OE_MSG_PUB.Add_Exc_Msg
846: ( G_PKG_NAME
847: , 'Invoice_To_Contact'

Line 845: OE_MSG_PUB.Add_Exc_Msg

841: WHEN OTHERS THEN
842:
843: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
844: THEN
845: OE_MSG_PUB.Add_Exc_Msg
846: ( G_PKG_NAME
847: , 'Invoice_To_Contact'
848: );
849: END IF;

Line 946: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

942: IF c_invoice_to_org_id%ISOPEN then
943: CLOSE c_invoice_to_org_id;
944: END IF;
945:
946: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
947: THEN
948:
949: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
950: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','invoice_to_org_id');

Line 951: OE_MSG_PUB.Add;

947: THEN
948:
949: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
950: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','invoice_to_org_id');
951: OE_MSG_PUB.Add;
952:
953: END IF;
954:
955: RETURN FND_API.G_MISS_NUM;

Line 963: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

959: IF c_invoice_to_org_id%ISOPEN then
960: CLOSE c_invoice_to_org_id;
961: END IF;
962:
963: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
964: THEN
965: OE_MSG_PUB.Add_Exc_Msg
966: ( G_PKG_NAME
967: , 'Invoice_To_Org'

Line 965: OE_MSG_PUB.Add_Exc_Msg

961: END IF;
962:
963: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
964: THEN
965: OE_MSG_PUB.Add_Exc_Msg
966: ( G_PKG_NAME
967: , 'Invoice_To_Org'
968: );
969: END IF;

Line 1195: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

1191: IF C2%ISOPEN then
1192: CLOSE C2;
1193: END IF;
1194:
1195: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1196: THEN
1197:
1198: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
1199: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','invoice_to_org_id');

Line 1200: OE_MSG_PUB.Add;

1196: THEN
1197:
1198: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
1199: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','invoice_to_org_id');
1200: OE_MSG_PUB.Add;
1201:
1202: END IF;
1203:
1204: RETURN FND_API.G_MISS_NUM;

Line 1220: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1216: IF C2%ISOPEN then
1217: CLOSE C2;
1218: END IF;
1219:
1220: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1221: THEN
1222: OE_MSG_PUB.Add_Exc_Msg
1223: ( G_PKG_NAME
1224: , 'Invoice_To_Org'

Line 1222: OE_MSG_PUB.Add_Exc_Msg

1218: END IF;
1219:
1220: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1221: THEN
1222: OE_MSG_PUB.Add_Exc_Msg
1223: ( G_PKG_NAME
1224: , 'Invoice_To_Org'
1225: );
1226: END IF;

Line 1257: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

1253: EXCEPTION
1254:
1255: WHEN NO_DATA_FOUND THEN
1256:
1257: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1258: THEN
1259:
1260: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
1261: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','invoicing_rule_id');

Line 1262: OE_MSG_PUB.Add;

1258: THEN
1259:
1260: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
1261: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','invoicing_rule_id');
1262: OE_MSG_PUB.Add;
1263:
1264: END IF;
1265:
1266: RETURN FND_API.G_MISS_NUM;

Line 1270: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1266: RETURN FND_API.G_MISS_NUM;
1267:
1268: WHEN OTHERS THEN
1269:
1270: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1271: THEN
1272: OE_MSG_PUB.Add_Exc_Msg
1273: ( G_PKG_NAME
1274: , 'Invoicing_Rule'

Line 1272: OE_MSG_PUB.Add_Exc_Msg

1268: WHEN OTHERS THEN
1269:
1270: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1271: THEN
1272: OE_MSG_PUB.Add_Exc_Msg
1273: ( G_PKG_NAME
1274: , 'Invoicing_Rule'
1275: );
1276: END IF;

Line 1312: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

1308: EXCEPTION
1309:
1310: WHEN NO_DATA_FOUND THEN
1311:
1312: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1313: THEN
1314:
1315: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
1316: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','order_source_id');

Line 1317: OE_MSG_PUB.Add;

1313: THEN
1314:
1315: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
1316: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','order_source_id');
1317: OE_MSG_PUB.Add;
1318:
1319: END IF;
1320:
1321: RETURN FND_API.G_MISS_NUM;

Line 1325: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1321: RETURN FND_API.G_MISS_NUM;
1322:
1323: WHEN OTHERS THEN
1324:
1325: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1326: THEN
1327: OE_MSG_PUB.Add_Exc_Msg
1328: ( G_PKG_NAME
1329: , 'Order_Source'

Line 1327: OE_MSG_PUB.Add_Exc_Msg

1323: WHEN OTHERS THEN
1324:
1325: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1326: THEN
1327: OE_MSG_PUB.Add_Exc_Msg
1328: ( G_PKG_NAME
1329: , 'Order_Source'
1330: );
1331: END IF;

Line 1362: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

1358: EXCEPTION
1359:
1360: WHEN NO_DATA_FOUND THEN
1361:
1362: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1363: THEN
1364:
1365: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
1366: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','order_type_id');

Line 1367: OE_MSG_PUB.Add;

1363: THEN
1364:
1365: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
1366: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','order_type_id');
1367: OE_MSG_PUB.Add;
1368:
1369: END IF;
1370:
1371: RETURN FND_API.G_MISS_NUM;

Line 1375: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1371: RETURN FND_API.G_MISS_NUM;
1372:
1373: WHEN OTHERS THEN
1374:
1375: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1376: THEN
1377: OE_MSG_PUB.Add_Exc_Msg
1378: ( G_PKG_NAME
1379: , 'Order_Type'

Line 1377: OE_MSG_PUB.Add_Exc_Msg

1373: WHEN OTHERS THEN
1374:
1375: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1376: THEN
1377: OE_MSG_PUB.Add_Exc_Msg
1378: ( G_PKG_NAME
1379: , 'Order_Type'
1380: );
1381: END IF;

Line 1412: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

1408: EXCEPTION
1409:
1410: WHEN NO_DATA_FOUND THEN
1411:
1412: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1413: THEN
1414:
1415: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
1416: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','payment_term_id');

Line 1417: OE_MSG_PUB.Add;

1413: THEN
1414:
1415: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
1416: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','payment_term_id');
1417: OE_MSG_PUB.Add;
1418:
1419: END IF;
1420:
1421: RETURN FND_API.G_MISS_NUM;

Line 1425: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1421: RETURN FND_API.G_MISS_NUM;
1422:
1423: WHEN OTHERS THEN
1424:
1425: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1426: THEN
1427: OE_MSG_PUB.Add_Exc_Msg
1428: ( G_PKG_NAME
1429: , 'Payment_Term'

Line 1427: OE_MSG_PUB.Add_Exc_Msg

1423: WHEN OTHERS THEN
1424:
1425: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1426: THEN
1427: OE_MSG_PUB.Add_Exc_Msg
1428: ( G_PKG_NAME
1429: , 'Payment_Term'
1430: );
1431: END IF;

Line 1463: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

1459: EXCEPTION
1460:
1461: WHEN NO_DATA_FOUND THEN
1462:
1463: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1464: THEN
1465:
1466: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
1467: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','price_list_id');

Line 1468: OE_MSG_PUB.Add;

1464: THEN
1465:
1466: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
1467: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','price_list_id');
1468: OE_MSG_PUB.Add;
1469:
1470: END IF;
1471:
1472: RETURN FND_API.G_MISS_NUM;

Line 1476: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1472: RETURN FND_API.G_MISS_NUM;
1473:
1474: WHEN OTHERS THEN
1475:
1476: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1477: THEN
1478: OE_MSG_PUB.Add_Exc_Msg
1479: ( G_PKG_NAME
1480: , 'Price_List'

Line 1478: OE_MSG_PUB.Add_Exc_Msg

1474: WHEN OTHERS THEN
1475:
1476: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1477: THEN
1478: OE_MSG_PUB.Add_Exc_Msg
1479: ( G_PKG_NAME
1480: , 'Price_List'
1481: );
1482: END IF;

Line 1515: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

1511: EXCEPTION
1512:
1513: WHEN NO_DATA_FOUND THEN
1514:
1515: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1516: THEN
1517:
1518: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
1519: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','shipment_priority_code');

Line 1520: OE_MSG_PUB.Add;

1516: THEN
1517:
1518: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
1519: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','shipment_priority_code');
1520: OE_MSG_PUB.Add;
1521:
1522: END IF;
1523:
1524: RETURN FND_API.G_MISS_CHAR;

Line 1528: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1524: RETURN FND_API.G_MISS_CHAR;
1525:
1526: WHEN OTHERS THEN
1527:
1528: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1529: THEN
1530: OE_MSG_PUB.Add_Exc_Msg
1531: ( G_PKG_NAME
1532: , 'Shipment_Priority'

Line 1530: OE_MSG_PUB.Add_Exc_Msg

1526: WHEN OTHERS THEN
1527:
1528: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1529: THEN
1530: OE_MSG_PUB.Add_Exc_Msg
1531: ( G_PKG_NAME
1532: , 'Shipment_Priority'
1533: );
1534: END IF;

Line 1580: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

1576: EXCEPTION
1577:
1578: WHEN NO_DATA_FOUND THEN
1579:
1580: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1581: THEN
1582:
1583: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
1584: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ship_from_org_id');

Line 1585: OE_MSG_PUB.Add;

1581: THEN
1582:
1583: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
1584: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ship_from_org_id');
1585: OE_MSG_PUB.Add;
1586:
1587: END IF;
1588:
1589: RETURN FND_API.G_MISS_NUM;

Line 1593: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1589: RETURN FND_API.G_MISS_NUM;
1590:
1591: WHEN OTHERS THEN
1592:
1593: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1594: THEN
1595: OE_MSG_PUB.Add_Exc_Msg
1596: ( G_PKG_NAME
1597: , 'Ship_From_Org'

Line 1595: OE_MSG_PUB.Add_Exc_Msg

1591: WHEN OTHERS THEN
1592:
1593: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1594: THEN
1595: OE_MSG_PUB.Add_Exc_Msg
1596: ( G_PKG_NAME
1597: , 'Ship_From_Org'
1598: );
1599: END IF;

Line 1639: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

1635: EXCEPTION
1636:
1637: WHEN NO_DATA_FOUND THEN
1638:
1639: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1640: THEN
1641:
1642: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
1643: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ship_to_contact_id');

Line 1644: OE_MSG_PUB.Add;

1640: THEN
1641:
1642: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
1643: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ship_to_contact_id');
1644: OE_MSG_PUB.Add;
1645:
1646: END IF;
1647:
1648: RETURN FND_API.G_MISS_NUM;

Line 1652: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1648: RETURN FND_API.G_MISS_NUM;
1649:
1650: WHEN OTHERS THEN
1651:
1652: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1653: THEN
1654: OE_MSG_PUB.Add_Exc_Msg
1655: ( G_PKG_NAME
1656: , 'Ship_To_Contact'

Line 1654: OE_MSG_PUB.Add_Exc_Msg

1650: WHEN OTHERS THEN
1651:
1652: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1653: THEN
1654: OE_MSG_PUB.Add_Exc_Msg
1655: ( G_PKG_NAME
1656: , 'Ship_To_Contact'
1657: );
1658: END IF;

Line 1687: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

1683: EXCEPTION
1684:
1685: WHEN NO_DATA_FOUND THEN
1686:
1687: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1688: THEN
1689:
1690: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
1691: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','inventory_org_id');

Line 1692: OE_MSG_PUB.Add;

1688: THEN
1689:
1690: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
1691: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','inventory_org_id');
1692: OE_MSG_PUB.Add;
1693:
1694: END IF;
1695:
1696: RETURN FND_API.G_MISS_NUM;

Line 1700: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1696: RETURN FND_API.G_MISS_NUM;
1697:
1698: WHEN OTHERS THEN
1699:
1700: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1701: THEN
1702: OE_MSG_PUB.Add_Exc_Msg
1703: ( G_PKG_NAME
1704: , 'inventory_org'

Line 1702: OE_MSG_PUB.Add_Exc_Msg

1698: WHEN OTHERS THEN
1699:
1700: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1701: THEN
1702: OE_MSG_PUB.Add_Exc_Msg
1703: ( G_PKG_NAME
1704: , 'inventory_org'
1705: );
1706: END IF;

Line 1802: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

1798: IF c_ship_to_org_id%ISOPEN then
1799: CLOSE c_ship_to_org_id;
1800: END IF;
1801:
1802: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1803: THEN
1804:
1805: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
1806: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ship_to_org_id');

Line 1807: OE_MSG_PUB.Add;

1803: THEN
1804:
1805: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
1806: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ship_to_org_id');
1807: OE_MSG_PUB.Add;
1808:
1809: END IF;
1810:
1811: RETURN FND_API.G_MISS_NUM;

Line 1819: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1815: IF c_ship_to_org_id%ISOPEN then
1816: CLOSE c_ship_to_org_id;
1817: END IF;
1818:
1819: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1820: THEN
1821: OE_MSG_PUB.Add_Exc_Msg
1822: ( G_PKG_NAME
1823: , 'Ship_To_Org'

Line 1821: OE_MSG_PUB.Add_Exc_Msg

1817: END IF;
1818:
1819: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1820: THEN
1821: OE_MSG_PUB.Add_Exc_Msg
1822: ( G_PKG_NAME
1823: , 'Ship_To_Org'
1824: );
1825: END IF;

Line 2034: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

2030:
2031: IF c_ship_to_org_id%ISOPEN then
2032: CLOSE c_ship_to_org_id;
2033: END IF;
2034: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2035: THEN
2036:
2037: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
2038: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ship_to_org_id');

Line 2039: OE_MSG_PUB.Add;

2035: THEN
2036:
2037: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
2038: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ship_to_org_id');
2039: OE_MSG_PUB.Add;
2040:
2041: END IF;
2042:
2043: RETURN FND_API.G_MISS_NUM;

Line 2051: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2047: IF c_ship_to_org_id%ISOPEN then
2048: CLOSE c_ship_to_org_id;
2049: END IF;
2050:
2051: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2052: THEN
2053: OE_MSG_PUB.Add_Exc_Msg
2054: ( G_PKG_NAME
2055: , 'Ship_To_Org'

Line 2053: OE_MSG_PUB.Add_Exc_Msg

2049: END IF;
2050:
2051: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2052: THEN
2053: OE_MSG_PUB.Add_Exc_Msg
2054: ( G_PKG_NAME
2055: , 'Ship_To_Org'
2056: );
2057: END IF;

Line 2097: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

2093: EXCEPTION
2094:
2095: WHEN NO_DATA_FOUND THEN
2096:
2097: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2098: THEN
2099:
2100: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
2101: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','sold_to_contact_id');

Line 2102: OE_MSG_PUB.Add;

2098: THEN
2099:
2100: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
2101: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','sold_to_contact_id');
2102: OE_MSG_PUB.Add;
2103:
2104: END IF;
2105:
2106: RETURN FND_API.G_MISS_NUM;

Line 2110: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2106: RETURN FND_API.G_MISS_NUM;
2107:
2108: WHEN OTHERS THEN
2109:
2110: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2111: THEN
2112: OE_MSG_PUB.Add_Exc_Msg
2113: ( G_PKG_NAME
2114: , 'Sold_To_Contact'

Line 2112: OE_MSG_PUB.Add_Exc_Msg

2108: WHEN OTHERS THEN
2109:
2110: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2111: THEN
2112: OE_MSG_PUB.Add_Exc_Msg
2113: ( G_PKG_NAME
2114: , 'Sold_To_Contact'
2115: );
2116: END IF;

Line 2165: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

2161: EXCEPTION
2162:
2163: WHEN NO_DATA_FOUND THEN
2164:
2165: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2166: THEN
2167:
2168: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
2169: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','sold_to_org_id');

Line 2170: OE_MSG_PUB.Add;

2166: THEN
2167:
2168: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
2169: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','sold_to_org_id');
2170: OE_MSG_PUB.Add;
2171:
2172: END IF;
2173:
2174: RETURN FND_API.G_MISS_NUM;

Line 2178: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2174: RETURN FND_API.G_MISS_NUM;
2175:
2176: WHEN OTHERS THEN
2177:
2178: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2179: THEN
2180: OE_MSG_PUB.Add_Exc_Msg
2181: ( G_PKG_NAME
2182: , 'Sold_To_Org'

Line 2180: OE_MSG_PUB.Add_Exc_Msg

2176: WHEN OTHERS THEN
2177:
2178: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2179: THEN
2180: OE_MSG_PUB.Add_Exc_Msg
2181: ( G_PKG_NAME
2182: , 'Sold_To_Org'
2183: );
2184: END IF;

Line 2218: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

2214: EXCEPTION
2215:
2216: WHEN NO_DATA_FOUND THEN
2217:
2218: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2219: THEN
2220:
2221: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
2222: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','tax_exempt_flag');

Line 2223: OE_MSG_PUB.Add;

2219: THEN
2220:
2221: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
2222: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','tax_exempt_flag');
2223: OE_MSG_PUB.Add;
2224:
2225: END IF;
2226:
2227: RETURN FND_API.G_MISS_CHAR;

Line 2231: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2227: RETURN FND_API.G_MISS_CHAR;
2228:
2229: WHEN OTHERS THEN
2230:
2231: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2232: THEN
2233: OE_MSG_PUB.Add_Exc_Msg
2234: ( G_PKG_NAME
2235: , 'Tax_Exempt'

Line 2233: OE_MSG_PUB.Add_Exc_Msg

2229: WHEN OTHERS THEN
2230:
2231: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2232: THEN
2233: OE_MSG_PUB.Add_Exc_Msg
2234: ( G_PKG_NAME
2235: , 'Tax_Exempt'
2236: );
2237: END IF;

Line 2271: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

2267: EXCEPTION
2268:
2269: WHEN NO_DATA_FOUND THEN
2270:
2271: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2272: THEN
2273:
2274: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
2275: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','tax_exempt_reason_code');

Line 2276: OE_MSG_PUB.Add;

2272: THEN
2273:
2274: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
2275: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','tax_exempt_reason_code');
2276: OE_MSG_PUB.Add;
2277:
2278: END IF;
2279:
2280: RETURN FND_API.G_MISS_CHAR;

Line 2284: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2280: RETURN FND_API.G_MISS_CHAR;
2281:
2282: WHEN OTHERS THEN
2283:
2284: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2285: THEN
2286: OE_MSG_PUB.Add_Exc_Msg
2287: ( G_PKG_NAME
2288: , 'Tax_Exempt_Reason'

Line 2286: OE_MSG_PUB.Add_Exc_Msg

2282: WHEN OTHERS THEN
2283:
2284: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2285: THEN
2286: OE_MSG_PUB.Add_Exc_Msg
2287: ( G_PKG_NAME
2288: , 'Tax_Exempt_Reason'
2289: );
2290: END IF;

Line 2323: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

2319: EXCEPTION
2320:
2321: WHEN NO_DATA_FOUND THEN
2322:
2323: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2324: THEN
2325:
2326: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
2327: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','tax_point_code');

Line 2328: OE_MSG_PUB.Add;

2324: THEN
2325:
2326: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
2327: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','tax_point_code');
2328: OE_MSG_PUB.Add;
2329:
2330: END IF;
2331:
2332: RETURN FND_API.G_MISS_CHAR;

Line 2336: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2332: RETURN FND_API.G_MISS_CHAR;
2333:
2334: WHEN OTHERS THEN
2335:
2336: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2337: THEN
2338: OE_MSG_PUB.Add_Exc_Msg
2339: ( G_PKG_NAME
2340: , 'Tax_Point'

Line 2338: OE_MSG_PUB.Add_Exc_Msg

2334: WHEN OTHERS THEN
2335:
2336: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2337: THEN
2338: OE_MSG_PUB.Add_Exc_Msg
2339: ( G_PKG_NAME
2340: , 'Tax_Point'
2341: );
2342: END IF;

Line 2373: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

2369: EXCEPTION
2370:
2371: WHEN NO_DATA_FOUND THEN
2372:
2373: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2374: THEN
2375:
2376: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
2377: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','discount_id');

Line 2378: OE_MSG_PUB.Add;

2374: THEN
2375:
2376: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
2377: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','discount_id');
2378: OE_MSG_PUB.Add;
2379:
2380: END IF;
2381:
2382: RETURN FND_API.G_MISS_NUM;

Line 2386: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2382: RETURN FND_API.G_MISS_NUM;
2383:
2384: WHEN OTHERS THEN
2385:
2386: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2387: THEN
2388: OE_MSG_PUB.Add_Exc_Msg
2389: ( G_PKG_NAME
2390: , 'Discount'

Line 2388: OE_MSG_PUB.Add_Exc_Msg

2384: WHEN OTHERS THEN
2385:
2386: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2387: THEN
2388: OE_MSG_PUB.Add_Exc_Msg
2389: ( G_PKG_NAME
2390: , 'Discount'
2391: );
2392: END IF;

Line 2422: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

2418: EXCEPTION
2419:
2420: WHEN NO_DATA_FOUND THEN
2421:
2422: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2423: THEN
2424:
2425: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
2426: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','sales_credit_type');

Line 2427: OE_MSG_PUB.Add;

2423: THEN
2424:
2425: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
2426: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','sales_credit_type');
2427: OE_MSG_PUB.Add;
2428:
2429: END IF;
2430:
2431: RETURN FND_API.G_MISS_NUM;

Line 2435: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2431: RETURN FND_API.G_MISS_NUM;
2432:
2433: WHEN OTHERS THEN
2434:
2435: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2436: THEN
2437: OE_MSG_PUB.Add_Exc_Msg
2438: ( G_PKG_NAME
2439: , 'sales_credit_type'

Line 2437: OE_MSG_PUB.Add_Exc_Msg

2433: WHEN OTHERS THEN
2434:
2435: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2436: THEN
2437: OE_MSG_PUB.Add_Exc_Msg
2438: ( G_PKG_NAME
2439: , 'sales_credit_type'
2440: );
2441: END IF;

Line 2472: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

2468: EXCEPTION
2469:
2470: WHEN NO_DATA_FOUND THEN
2471:
2472: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2473: THEN
2474:
2475: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
2476: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','salesrep_id');

Line 2477: OE_MSG_PUB.Add;

2473: THEN
2474:
2475: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
2476: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','salesrep_id');
2477: OE_MSG_PUB.Add;
2478:
2479: END IF;
2480:
2481: RETURN FND_API.G_MISS_NUM;

Line 2485: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2481: RETURN FND_API.G_MISS_NUM;
2482:
2483: WHEN OTHERS THEN
2484:
2485: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2486: THEN
2487: OE_MSG_PUB.Add_Exc_Msg
2488: ( G_PKG_NAME
2489: , 'Salesrep'

Line 2487: OE_MSG_PUB.Add_Exc_Msg

2483: WHEN OTHERS THEN
2484:
2485: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2486: THEN
2487: OE_MSG_PUB.Add_Exc_Msg
2488: ( G_PKG_NAME
2489: , 'Salesrep'
2490: );
2491: END IF;

Line 2522: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

2518: EXCEPTION
2519:
2520: WHEN NO_DATA_FOUND THEN
2521:
2522: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2523: THEN
2524:
2525: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
2526: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','demand_bucket_type_code');

Line 2527: OE_MSG_PUB.Add;

2523: THEN
2524:
2525: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
2526: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','demand_bucket_type_code');
2527: OE_MSG_PUB.Add;
2528:
2529: END IF;
2530:
2531: RETURN FND_API.G_MISS_CHAR;

Line 2535: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2531: RETURN FND_API.G_MISS_CHAR;
2532:
2533: WHEN OTHERS THEN
2534:
2535: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2536: THEN
2537: OE_MSG_PUB.Add_Exc_Msg
2538: ( G_PKG_NAME
2539: , 'Demand_Bucket_Type'

Line 2537: OE_MSG_PUB.Add_Exc_Msg

2533: WHEN OTHERS THEN
2534:
2535: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2536: THEN
2537: OE_MSG_PUB.Add_Exc_Msg
2538: ( G_PKG_NAME
2539: , 'Demand_Bucket_Type'
2540: );
2541: END IF;

Line 2576: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

2572: EXCEPTION
2573:
2574: WHEN NO_DATA_FOUND THEN
2575:
2576: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2577: THEN
2578:
2579: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
2580: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','inventory_item_id');

Line 2581: OE_MSG_PUB.Add;

2577: THEN
2578:
2579: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
2580: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','inventory_item_id');
2581: OE_MSG_PUB.Add;
2582:
2583: END IF;
2584:
2585: RETURN FND_API.G_MISS_NUM;

Line 2589: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2585: RETURN FND_API.G_MISS_NUM;
2586:
2587: WHEN OTHERS THEN
2588:
2589: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2590: THEN
2591: OE_MSG_PUB.Add_Exc_Msg
2592: ( G_PKG_NAME
2593: , 'Inventory_Item'

Line 2591: OE_MSG_PUB.Add_Exc_Msg

2587: WHEN OTHERS THEN
2588:
2589: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2590: THEN
2591: OE_MSG_PUB.Add_Exc_Msg
2592: ( G_PKG_NAME
2593: , 'Inventory_Item'
2594: );
2595: END IF;

Line 2626: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

2622: EXCEPTION
2623:
2624: WHEN NO_DATA_FOUND THEN
2625:
2626: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2627: THEN
2628:
2629: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
2630: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','item_type_code');

Line 2631: OE_MSG_PUB.Add;

2627: THEN
2628:
2629: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
2630: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','item_type_code');
2631: OE_MSG_PUB.Add;
2632:
2633: END IF;
2634:
2635: RETURN FND_API.G_MISS_CHAR;

Line 2639: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2635: RETURN FND_API.G_MISS_CHAR;
2636:
2637: WHEN OTHERS THEN
2638:
2639: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2640: THEN
2641: OE_MSG_PUB.Add_Exc_Msg
2642: ( G_PKG_NAME
2643: , 'Item_Type'

Line 2641: OE_MSG_PUB.Add_Exc_Msg

2637: WHEN OTHERS THEN
2638:
2639: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2640: THEN
2641: OE_MSG_PUB.Add_Exc_Msg
2642: ( G_PKG_NAME
2643: , 'Item_Type'
2644: );
2645: END IF;

Line 2676: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

2672: EXCEPTION
2673:
2674: WHEN NO_DATA_FOUND THEN
2675:
2676: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2677: THEN
2678:
2679: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
2680: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','line_type_id');

Line 2681: OE_MSG_PUB.Add;

2677: THEN
2678:
2679: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
2680: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','line_type_id');
2681: OE_MSG_PUB.Add;
2682:
2683: END IF;
2684:
2685: RETURN FND_API.G_MISS_NUM;

Line 2689: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2685: RETURN FND_API.G_MISS_NUM;
2686:
2687: WHEN OTHERS THEN
2688:
2689: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2690: THEN
2691: OE_MSG_PUB.Add_Exc_Msg
2692: ( G_PKG_NAME
2693: , 'Line_Type'

Line 2691: OE_MSG_PUB.Add_Exc_Msg

2687: WHEN OTHERS THEN
2688:
2689: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2690: THEN
2691: OE_MSG_PUB.Add_Exc_Msg
2692: ( G_PKG_NAME
2693: , 'Line_Type'
2694: );
2695: END IF;

Line 2726: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

2722: EXCEPTION
2723:
2724: WHEN NO_DATA_FOUND THEN
2725:
2726: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2727: THEN
2728:
2729: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
2730: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','project_id');

Line 2731: OE_MSG_PUB.Add;

2727: THEN
2728:
2729: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
2730: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','project_id');
2731: OE_MSG_PUB.Add;
2732:
2733: END IF;
2734:
2735: RETURN FND_API.G_MISS_NUM;

Line 2739: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2735: RETURN FND_API.G_MISS_NUM;
2736:
2737: WHEN OTHERS THEN
2738:
2739: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2740: THEN
2741: OE_MSG_PUB.Add_Exc_Msg
2742: ( G_PKG_NAME
2743: , 'Project'

Line 2741: OE_MSG_PUB.Add_Exc_Msg

2737: WHEN OTHERS THEN
2738:
2739: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2740: THEN
2741: OE_MSG_PUB.Add_Exc_Msg
2742: ( G_PKG_NAME
2743: , 'Project'
2744: );
2745: END IF;

Line 2776: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

2772: EXCEPTION
2773:
2774: WHEN NO_DATA_FOUND THEN
2775:
2776: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2777: THEN
2778:
2779: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
2780: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','rla_schedule_type_code');

Line 2781: OE_MSG_PUB.Add;

2777: THEN
2778:
2779: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
2780: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','rla_schedule_type_code');
2781: OE_MSG_PUB.Add;
2782:
2783: END IF;
2784:
2785: RETURN FND_API.G_MISS_CHAR;

Line 2789: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2785: RETURN FND_API.G_MISS_CHAR;
2786:
2787: WHEN OTHERS THEN
2788:
2789: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2790: THEN
2791: OE_MSG_PUB.Add_Exc_Msg
2792: ( G_PKG_NAME
2793: , 'Rla_Schedule_Type'

Line 2791: OE_MSG_PUB.Add_Exc_Msg

2787: WHEN OTHERS THEN
2788:
2789: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2790: THEN
2791: OE_MSG_PUB.Add_Exc_Msg
2792: ( G_PKG_NAME
2793: , 'Rla_Schedule_Type'
2794: );
2795: END IF;

Line 2826: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

2822: EXCEPTION
2823:
2824: WHEN NO_DATA_FOUND THEN
2825:
2826: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2827: THEN
2828:
2829: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
2830: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','task_id');

Line 2831: OE_MSG_PUB.Add;

2827: THEN
2828:
2829: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
2830: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','task_id');
2831: OE_MSG_PUB.Add;
2832:
2833: END IF;
2834:
2835: RETURN FND_API.G_MISS_NUM;

Line 2839: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2835: RETURN FND_API.G_MISS_NUM;
2836:
2837: WHEN OTHERS THEN
2838:
2839: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2840: THEN
2841: OE_MSG_PUB.Add_Exc_Msg
2842: ( G_PKG_NAME
2843: , 'Task'

Line 2841: OE_MSG_PUB.Add_Exc_Msg

2837: WHEN OTHERS THEN
2838:
2839: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2840: THEN
2841: OE_MSG_PUB.Add_Exc_Msg
2842: ( G_PKG_NAME
2843: , 'Task'
2844: );
2845: END IF;

Line 2875: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

2871: EXCEPTION
2872:
2873: WHEN NO_DATA_FOUND THEN
2874:
2875: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2876: THEN
2877:
2878: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
2879: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','over_ship_reason_code');

Line 2880: OE_MSG_PUB.Add;

2876: THEN
2877:
2878: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
2879: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','over_ship_reason_code');
2880: OE_MSG_PUB.Add;
2881:
2882: END IF;
2883:
2884: RETURN FND_API.G_MISS_CHAR;

Line 2888: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2884: RETURN FND_API.G_MISS_CHAR;
2885:
2886: WHEN OTHERS THEN
2887:
2888: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2889: THEN
2890: OE_MSG_PUB.Add_Exc_Msg
2891: ( G_PKG_NAME
2892: , 'Over_Ship_reason'

Line 2890: OE_MSG_PUB.Add_Exc_Msg

2886: WHEN OTHERS THEN
2887:
2888: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2889: THEN
2890: OE_MSG_PUB.Add_Exc_Msg
2891: ( G_PKG_NAME
2892: , 'Over_Ship_reason'
2893: );
2894: END IF;

Line 2926: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

2922: EXCEPTION
2923:
2924: WHEN NO_DATA_FOUND THEN
2925:
2926: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2927: THEN
2928:
2929: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
2930: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','return_reason_code');

Line 2931: OE_MSG_PUB.Add;

2927: THEN
2928:
2929: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
2930: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','return_reason_code');
2931: OE_MSG_PUB.Add;
2932:
2933: END IF;
2934:
2935: RETURN FND_API.G_MISS_CHAR;

Line 2939: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2935: RETURN FND_API.G_MISS_CHAR;
2936:
2937: WHEN OTHERS THEN
2938:
2939: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2940: THEN
2941: OE_MSG_PUB.Add_Exc_Msg
2942: ( G_PKG_NAME
2943: , 'Return_Reason'

Line 2941: OE_MSG_PUB.Add_Exc_Msg

2937: WHEN OTHERS THEN
2938:
2939: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2940: THEN
2941: OE_MSG_PUB.Add_Exc_Msg
2942: ( G_PKG_NAME
2943: , 'Return_Reason'
2944: );
2945: END IF;

Line 2975: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

2971: EXCEPTION
2972:
2973: WHEN NO_DATA_FOUND THEN
2974:
2975: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2976: THEN
2977:
2978: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
2979: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','veh_cus_item_cum_Key_id');

Line 2980: OE_MSG_PUB.Add;

2976: THEN
2977:
2978: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
2979: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','veh_cus_item_cum_Key_id');
2980: OE_MSG_PUB.Add;
2981:
2982: END IF;
2983:
2984: RETURN FND_API.G_MISS_NUM;

Line 2988: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2984: RETURN FND_API.G_MISS_NUM;
2985:
2986: WHEN OTHERS THEN
2987:
2988: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2989: THEN
2990: OE_MSG_PUB.Add_Exc_Msg
2991: ( G_PKG_NAME
2992: , 'Veh_Cus_Item_cum_Key'

Line 2990: OE_MSG_PUB.Add_Exc_Msg

2986: WHEN OTHERS THEN
2987:
2988: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2989: THEN
2990: OE_MSG_PUB.Add_Exc_Msg
2991: ( G_PKG_NAME
2992: , 'Veh_Cus_Item_cum_Key'
2993: );
2994: END IF;

Line 3027: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

3023: EXCEPTION
3024:
3025: WHEN NO_DATA_FOUND THEN
3026:
3027: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
3028: THEN
3029:
3030: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
3031: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','payment_type_code');

Line 3032: OE_MSG_PUB.Add;

3028: THEN
3029:
3030: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
3031: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','payment_type_code');
3032: OE_MSG_PUB.Add;
3033:
3034: END IF;
3035:
3036: RETURN FND_API.G_MISS_CHAR;

Line 3040: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3036: RETURN FND_API.G_MISS_CHAR;
3037:
3038: WHEN OTHERS THEN
3039:
3040: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3041: THEN
3042: OE_MSG_PUB.Add_Exc_Msg
3043: ( G_PKG_NAME
3044: , 'Payment_Type'

Line 3042: OE_MSG_PUB.Add_Exc_Msg

3038: WHEN OTHERS THEN
3039:
3040: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3041: THEN
3042: OE_MSG_PUB.Add_Exc_Msg
3043: ( G_PKG_NAME
3044: , 'Payment_Type'
3045: );
3046: END IF;

Line 3079: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

3075: EXCEPTION
3076:
3077: WHEN NO_DATA_FOUND THEN
3078:
3079: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
3080: THEN
3081:
3082: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
3083: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','credit_card_code');

Line 3084: OE_MSG_PUB.Add;

3080: THEN
3081:
3082: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
3083: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','credit_card_code');
3084: OE_MSG_PUB.Add;
3085:
3086: END IF;
3087:
3088: RETURN FND_API.G_MISS_CHAR;

Line 3092: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3088: RETURN FND_API.G_MISS_CHAR;
3089:
3090: WHEN OTHERS THEN
3091:
3092: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3093: THEN
3094: OE_MSG_PUB.Add_Exc_Msg
3095: ( G_PKG_NAME
3096: , 'Credit_Card'

Line 3094: OE_MSG_PUB.Add_Exc_Msg

3090: WHEN OTHERS THEN
3091:
3092: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3093: THEN
3094: OE_MSG_PUB.Add_Exc_Msg
3095: ( G_PKG_NAME
3096: , 'Credit_Card'
3097: );
3098: END IF;

Line 3142: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

3138: EXCEPTION
3139:
3140: WHEN NO_DATA_FOUND THEN
3141:
3142: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
3143: THEN
3144:
3145: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
3146: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','currency_code');

Line 3147: OE_MSG_PUB.Add;

3143: THEN
3144:
3145: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
3146: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','currency_code');
3147: OE_MSG_PUB.Add;
3148:
3149: END IF;
3150:
3151: RETURN FND_API.G_MISS_CHAR;

Line 3155: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3151: RETURN FND_API.G_MISS_CHAR;
3152:
3153: WHEN OTHERS THEN
3154:
3155: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3156: THEN
3157: OE_MSG_PUB.Add_Exc_Msg
3158: ( G_PKG_NAME
3159: , 'Currency'

Line 3157: OE_MSG_PUB.Add_Exc_Msg

3153: WHEN OTHERS THEN
3154:
3155: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3156: THEN
3157: OE_MSG_PUB.Add_Exc_Msg
3158: ( G_PKG_NAME
3159: , 'Currency'
3160: );
3161: END IF;

Line 3193: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

3189: EXCEPTION
3190:
3191: WHEN NO_DATA_FOUND THEN
3192:
3193: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
3194: THEN
3195:
3196: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
3197: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Agreement_Contact_Id');

Line 3198: OE_MSG_PUB.Add;

3194: THEN
3195:
3196: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
3197: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Agreement_Contact_Id');
3198: OE_MSG_PUB.Add;
3199:
3200: END IF;
3201:
3202: RETURN FND_API.G_MISS_CHAR;

Line 3206: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3202: RETURN FND_API.G_MISS_CHAR;
3203:
3204: WHEN OTHERS THEN
3205:
3206: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3207: THEN
3208: OE_MSG_PUB.Add_Exc_Msg
3209: ( G_PKG_NAME
3210: , 'Agreement_Contact'

Line 3208: OE_MSG_PUB.Add_Exc_Msg

3204: WHEN OTHERS THEN
3205:
3206: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3207: THEN
3208: OE_MSG_PUB.Add_Exc_Msg
3209: ( G_PKG_NAME
3210: , 'Agreement_Contact'
3211: );
3212: END IF;

Line 3243: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

3239: EXCEPTION
3240:
3241: WHEN NO_DATA_FOUND THEN
3242:
3243: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
3244: THEN
3245:
3246: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
3247: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Agreement_Type_Code');

Line 3248: OE_MSG_PUB.Add;

3244: THEN
3245:
3246: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
3247: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Agreement_Type_Code');
3248: OE_MSG_PUB.Add;
3249:
3250: END IF;
3251:
3252: RETURN FND_API.G_MISS_CHAR;

Line 3256: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3252: RETURN FND_API.G_MISS_CHAR;
3253:
3254: WHEN OTHERS THEN
3255:
3256: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3257: THEN
3258: OE_MSG_PUB.Add_Exc_Msg
3259: ( G_PKG_NAME
3260: , 'Agreement_Type'

Line 3258: OE_MSG_PUB.Add_Exc_Msg

3254: WHEN OTHERS THEN
3255:
3256: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3257: THEN
3258: OE_MSG_PUB.Add_Exc_Msg
3259: ( G_PKG_NAME
3260: , 'Agreement_Type'
3261: );
3262: END IF;

Line 3293: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

3289: EXCEPTION
3290:
3291: WHEN NO_DATA_FOUND THEN
3292:
3293: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
3294: THEN
3295:
3296: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
3297: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Customer_Id');

Line 3298: OE_MSG_PUB.Add;

3294: THEN
3295:
3296: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
3297: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Customer_Id');
3298: OE_MSG_PUB.Add;
3299:
3300: END IF;
3301:
3302: RETURN FND_API.G_MISS_CHAR;

Line 3306: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3302: RETURN FND_API.G_MISS_CHAR;
3303:
3304: WHEN OTHERS THEN
3305:
3306: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3307: THEN
3308: OE_MSG_PUB.Add_Exc_Msg
3309: ( G_PKG_NAME
3310: , 'Customer'

Line 3308: OE_MSG_PUB.Add_Exc_Msg

3304: WHEN OTHERS THEN
3305:
3306: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3307: THEN
3308: OE_MSG_PUB.Add_Exc_Msg
3309: ( G_PKG_NAME
3310: , 'Customer'
3311: );
3312: END IF;

Line 3343: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

3339: EXCEPTION
3340:
3341: WHEN NO_DATA_FOUND THEN
3342:
3343: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
3344: THEN
3345:
3346: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
3347: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Invoice_Contact_Id');

Line 3348: OE_MSG_PUB.Add;

3344: THEN
3345:
3346: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
3347: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Invoice_Contact_Id');
3348: OE_MSG_PUB.Add;
3349:
3350: END IF;
3351:
3352: RETURN FND_API.G_MISS_CHAR;

Line 3356: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3352: RETURN FND_API.G_MISS_CHAR;
3353:
3354: WHEN OTHERS THEN
3355:
3356: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3357: THEN
3358: OE_MSG_PUB.Add_Exc_Msg
3359: ( G_PKG_NAME
3360: , 'Invoice_Contact'

Line 3358: OE_MSG_PUB.Add_Exc_Msg

3354: WHEN OTHERS THEN
3355:
3356: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3357: THEN
3358: OE_MSG_PUB.Add_Exc_Msg
3359: ( G_PKG_NAME
3360: , 'Invoice_Contact'
3361: );
3362: END IF;

Line 3393: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

3389: EXCEPTION
3390:
3391: WHEN NO_DATA_FOUND THEN
3392:
3393: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
3394: THEN
3395:
3396: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
3397: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Invoice_To_Site_Use_Id');

Line 3398: OE_MSG_PUB.Add;

3394: THEN
3395:
3396: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
3397: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Invoice_To_Site_Use_Id');
3398: OE_MSG_PUB.Add;
3399:
3400: END IF;
3401:
3402: RETURN FND_API.G_MISS_CHAR;

Line 3406: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3402: RETURN FND_API.G_MISS_CHAR;
3403:
3404: WHEN OTHERS THEN
3405:
3406: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3407: THEN
3408: OE_MSG_PUB.Add_Exc_Msg
3409: ( G_PKG_NAME
3410: , 'Invoice_To_Site_Use'

Line 3408: OE_MSG_PUB.Add_Exc_Msg

3404: WHEN OTHERS THEN
3405:
3406: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3407: THEN
3408: OE_MSG_PUB.Add_Exc_Msg
3409: ( G_PKG_NAME
3410: , 'Invoice_To_Site_Use'
3411: );
3412: END IF;

Line 3443: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

3439: EXCEPTION
3440:
3441: WHEN NO_DATA_FOUND THEN
3442:
3443: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
3444: THEN
3445:
3446: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
3447: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Override_Arule_Flag');

Line 3448: OE_MSG_PUB.Add;

3444: THEN
3445:
3446: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
3447: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Override_Arule_Flag');
3448: OE_MSG_PUB.Add;
3449:
3450: END IF;
3451:
3452: RETURN FND_API.G_MISS_CHAR;

Line 3456: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3452: RETURN FND_API.G_MISS_CHAR;
3453:
3454: WHEN OTHERS THEN
3455:
3456: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3457: THEN
3458: OE_MSG_PUB.Add_Exc_Msg
3459: ( G_PKG_NAME
3460: , 'Override_Arule'

Line 3458: OE_MSG_PUB.Add_Exc_Msg

3454: WHEN OTHERS THEN
3455:
3456: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3457: THEN
3458: OE_MSG_PUB.Add_Exc_Msg
3459: ( G_PKG_NAME
3460: , 'Override_Arule'
3461: );
3462: END IF;

Line 3493: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

3489: EXCEPTION
3490:
3491: WHEN NO_DATA_FOUND THEN
3492:
3493: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
3494: THEN
3495:
3496: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
3497: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Override_Irule_Flag');

Line 3498: OE_MSG_PUB.Add;

3494: THEN
3495:
3496: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
3497: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Override_Irule_Flag');
3498: OE_MSG_PUB.Add;
3499:
3500: END IF;
3501:
3502: RETURN FND_API.G_MISS_CHAR;

Line 3506: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3502: RETURN FND_API.G_MISS_CHAR;
3503:
3504: WHEN OTHERS THEN
3505:
3506: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3507: THEN
3508: OE_MSG_PUB.Add_Exc_Msg
3509: ( G_PKG_NAME
3510: , 'Override_Irule'

Line 3508: OE_MSG_PUB.Add_Exc_Msg

3504: WHEN OTHERS THEN
3505:
3506: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3507: THEN
3508: OE_MSG_PUB.Add_Exc_Msg
3509: ( G_PKG_NAME
3510: , 'Override_Irule'
3511: );
3512: END IF;

Line 3543: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

3539: EXCEPTION
3540:
3541: WHEN NO_DATA_FOUND THEN
3542:
3543: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
3544: THEN
3545:
3546: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
3547: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Revision_Reason_Code');

Line 3548: OE_MSG_PUB.Add;

3544: THEN
3545:
3546: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
3547: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Revision_Reason_Code');
3548: OE_MSG_PUB.Add;
3549:
3550: END IF;
3551:
3552: RETURN FND_API.G_MISS_CHAR;

Line 3556: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3552: RETURN FND_API.G_MISS_CHAR;
3553:
3554: WHEN OTHERS THEN
3555:
3556: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3557: THEN
3558: OE_MSG_PUB.Add_Exc_Msg
3559: ( G_PKG_NAME
3560: , 'Revision_Reason'

Line 3558: OE_MSG_PUB.Add_Exc_Msg

3554: WHEN OTHERS THEN
3555:
3556: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3557: THEN
3558: OE_MSG_PUB.Add_Exc_Msg
3559: ( G_PKG_NAME
3560: , 'Revision_Reason'
3561: );
3562: END IF;

Line 3594: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

3590: EXCEPTION
3591:
3592: WHEN NO_DATA_FOUND THEN
3593:
3594: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
3595: THEN
3596:
3597: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
3598: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Ship_Method_Code');

Line 3599: OE_MSG_PUB.Add;

3595: THEN
3596:
3597: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
3598: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Ship_Method_Code');
3599: OE_MSG_PUB.Add;
3600:
3601: END IF;
3602:
3603: RETURN FND_API.G_MISS_CHAR;

Line 3607: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3603: RETURN FND_API.G_MISS_CHAR;
3604:
3605: WHEN OTHERS THEN
3606:
3607: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3608: THEN
3609: OE_MSG_PUB.Add_Exc_Msg
3610: ( G_PKG_NAME
3611: , 'Ship_Method'

Line 3609: OE_MSG_PUB.Add_Exc_Msg

3605: WHEN OTHERS THEN
3606:
3607: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3608: THEN
3609: OE_MSG_PUB.Add_Exc_Msg
3610: ( G_PKG_NAME
3611: , 'Ship_Method'
3612: );
3613: END IF;

Line 3644: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

3640: EXCEPTION
3641:
3642: WHEN NO_DATA_FOUND THEN
3643:
3644: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
3645: THEN
3646:
3647: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
3648: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Term_Id');

Line 3649: OE_MSG_PUB.Add;

3645: THEN
3646:
3647: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
3648: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Term_Id');
3649: OE_MSG_PUB.Add;
3650:
3651: END IF;
3652:
3653: RETURN FND_API.G_MISS_CHAR;

Line 3657: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3653: RETURN FND_API.G_MISS_CHAR;
3654:
3655: WHEN OTHERS THEN
3656:
3657: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3658: THEN
3659: OE_MSG_PUB.Add_Exc_Msg
3660: ( G_PKG_NAME
3661: , 'Term'

Line 3659: OE_MSG_PUB.Add_Exc_Msg

3655: WHEN OTHERS THEN
3656:
3657: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3658: THEN
3659: OE_MSG_PUB.Add_Exc_Msg
3660: ( G_PKG_NAME
3661: , 'Term'
3662: );
3663: END IF;

Line 3694: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

3690: EXCEPTION
3691:
3692: WHEN NO_DATA_FOUND THEN
3693:
3694: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
3695: THEN
3696:
3697: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
3698: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','secondary_price_list_id');

Line 3699: OE_MSG_PUB.Add;

3695: THEN
3696:
3697: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
3698: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','secondary_price_list_id');
3699: OE_MSG_PUB.Add;
3700:
3701: END IF;
3702:
3703: RETURN FND_API.G_MISS_NUM;

Line 3707: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3703: RETURN FND_API.G_MISS_NUM;
3704:
3705: WHEN OTHERS THEN
3706:
3707: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3708: THEN
3709: OE_MSG_PUB.Add_Exc_Msg
3710: ( G_PKG_NAME
3711: , 'Secondary_Price_List'

Line 3709: OE_MSG_PUB.Add_Exc_Msg

3705: WHEN OTHERS THEN
3706:
3707: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3708: THEN
3709: OE_MSG_PUB.Add_Exc_Msg
3710: ( G_PKG_NAME
3711: , 'Secondary_Price_List'
3712: );
3713: END IF;

Line 3744: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

3740: EXCEPTION
3741:
3742: WHEN NO_DATA_FOUND THEN
3743:
3744: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
3745: THEN
3746:
3747: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
3748: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','terms_id');

Line 3749: OE_MSG_PUB.Add;

3745: THEN
3746:
3747: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
3748: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','terms_id');
3749: OE_MSG_PUB.Add;
3750:
3751: END IF;
3752:
3753: RETURN FND_API.G_MISS_NUM;

Line 3757: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3753: RETURN FND_API.G_MISS_NUM;
3754:
3755: WHEN OTHERS THEN
3756:
3757: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3758: THEN
3759: OE_MSG_PUB.Add_Exc_Msg
3760: ( G_PKG_NAME
3761: , 'Terms'

Line 3759: OE_MSG_PUB.Add_Exc_Msg

3755: WHEN OTHERS THEN
3756:
3757: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3758: THEN
3759: OE_MSG_PUB.Add_Exc_Msg
3760: ( G_PKG_NAME
3761: , 'Terms'
3762: );
3763: END IF;

Line 3794: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

3790: EXCEPTION
3791:
3792: WHEN NO_DATA_FOUND THEN
3793:
3794: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
3795: THEN
3796:
3797: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
3798: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','automatic_discount_flag');

Line 3799: OE_MSG_PUB.Add;

3795: THEN
3796:
3797: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
3798: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','automatic_discount_flag');
3799: OE_MSG_PUB.Add;
3800:
3801: END IF;
3802:
3803: RETURN FND_API.G_MISS_CHAR;

Line 3807: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3803: RETURN FND_API.G_MISS_CHAR;
3804:
3805: WHEN OTHERS THEN
3806:
3807: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3808: THEN
3809: OE_MSG_PUB.Add_Exc_Msg
3810: ( G_PKG_NAME
3811: , 'Automatic_Discount'

Line 3809: OE_MSG_PUB.Add_Exc_Msg

3805: WHEN OTHERS THEN
3806:
3807: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3808: THEN
3809: OE_MSG_PUB.Add_Exc_Msg
3810: ( G_PKG_NAME
3811: , 'Automatic_Discount'
3812: );
3813: END IF;

Line 3844: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

3840: EXCEPTION
3841:
3842: WHEN NO_DATA_FOUND THEN
3843:
3844: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
3845: THEN
3846:
3847: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
3848: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','discount_lines_flag');

Line 3849: OE_MSG_PUB.Add;

3845: THEN
3846:
3847: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
3848: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','discount_lines_flag');
3849: OE_MSG_PUB.Add;
3850:
3851: END IF;
3852:
3853: RETURN FND_API.G_MISS_CHAR;

Line 3857: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3853: RETURN FND_API.G_MISS_CHAR;
3854:
3855: WHEN OTHERS THEN
3856:
3857: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3858: THEN
3859: OE_MSG_PUB.Add_Exc_Msg
3860: ( G_PKG_NAME
3861: , 'Discount_Lines'

Line 3859: OE_MSG_PUB.Add_Exc_Msg

3855: WHEN OTHERS THEN
3856:
3857: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3858: THEN
3859: OE_MSG_PUB.Add_Exc_Msg
3860: ( G_PKG_NAME
3861: , 'Discount_Lines'
3862: );
3863: END IF;

Line 3894: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

3890: EXCEPTION
3891:
3892: WHEN NO_DATA_FOUND THEN
3893:
3894: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
3895: THEN
3896:
3897: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
3898: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','discount_type_code');

Line 3899: OE_MSG_PUB.Add;

3895: THEN
3896:
3897: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
3898: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','discount_type_code');
3899: OE_MSG_PUB.Add;
3900:
3901: END IF;
3902:
3903: RETURN FND_API.G_MISS_CHAR;

Line 3907: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3903: RETURN FND_API.G_MISS_CHAR;
3904:
3905: WHEN OTHERS THEN
3906:
3907: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3908: THEN
3909: OE_MSG_PUB.Add_Exc_Msg
3910: ( G_PKG_NAME
3911: , 'Discount_Type'

Line 3909: OE_MSG_PUB.Add_Exc_Msg

3905: WHEN OTHERS THEN
3906:
3907: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3908: THEN
3909: OE_MSG_PUB.Add_Exc_Msg
3910: ( G_PKG_NAME
3911: , 'Discount_Type'
3912: );
3913: END IF;

Line 3944: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

3940: EXCEPTION
3941:
3942: WHEN NO_DATA_FOUND THEN
3943:
3944: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
3945: THEN
3946:
3947: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
3948: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','manual_discount_flag');

Line 3949: OE_MSG_PUB.Add;

3945: THEN
3946:
3947: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
3948: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','manual_discount_flag');
3949: OE_MSG_PUB.Add;
3950:
3951: END IF;
3952:
3953: RETURN FND_API.G_MISS_CHAR;

Line 3957: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3953: RETURN FND_API.G_MISS_CHAR;
3954:
3955: WHEN OTHERS THEN
3956:
3957: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3958: THEN
3959: OE_MSG_PUB.Add_Exc_Msg
3960: ( G_PKG_NAME
3961: , 'Manual_Discount'

Line 3959: OE_MSG_PUB.Add_Exc_Msg

3955: WHEN OTHERS THEN
3956:
3957: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3958: THEN
3959: OE_MSG_PUB.Add_Exc_Msg
3960: ( G_PKG_NAME
3961: , 'Manual_Discount'
3962: );
3963: END IF;

Line 3994: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

3990: EXCEPTION
3991:
3992: WHEN NO_DATA_FOUND THEN
3993:
3994: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
3995: THEN
3996:
3997: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
3998: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','override_allowed_flag');

Line 3999: OE_MSG_PUB.Add;

3995: THEN
3996:
3997: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
3998: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','override_allowed_flag');
3999: OE_MSG_PUB.Add;
4000:
4001: END IF;
4002:
4003: RETURN FND_API.G_MISS_CHAR;

Line 4007: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

4003: RETURN FND_API.G_MISS_CHAR;
4004:
4005: WHEN OTHERS THEN
4006:
4007: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4008: THEN
4009: OE_MSG_PUB.Add_Exc_Msg
4010: ( G_PKG_NAME
4011: , 'Override_Allowed'

Line 4009: OE_MSG_PUB.Add_Exc_Msg

4005: WHEN OTHERS THEN
4006:
4007: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4008: THEN
4009: OE_MSG_PUB.Add_Exc_Msg
4010: ( G_PKG_NAME
4011: , 'Override_Allowed'
4012: );
4013: END IF;

Line 4044: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

4040: EXCEPTION
4041:
4042: WHEN NO_DATA_FOUND THEN
4043:
4044: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4045: THEN
4046:
4047: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
4048: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','prorate_flag');

Line 4049: OE_MSG_PUB.Add;

4045: THEN
4046:
4047: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
4048: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','prorate_flag');
4049: OE_MSG_PUB.Add;
4050:
4051: END IF;
4052:
4053: RETURN FND_API.G_MISS_CHAR;

Line 4057: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

4053: RETURN FND_API.G_MISS_CHAR;
4054:
4055: WHEN OTHERS THEN
4056:
4057: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4058: THEN
4059: OE_MSG_PUB.Add_Exc_Msg
4060: ( G_PKG_NAME
4061: , 'Prorate'

Line 4059: OE_MSG_PUB.Add_Exc_Msg

4055: WHEN OTHERS THEN
4056:
4057: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4058: THEN
4059: OE_MSG_PUB.Add_Exc_Msg
4060: ( G_PKG_NAME
4061: , 'Prorate'
4062: );
4063: END IF;

Line 4095: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

4091: EXCEPTION
4092:
4093: WHEN NO_DATA_FOUND THEN
4094:
4095: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4096: THEN
4097:
4098: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
4099: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','method_code');

Line 4100: OE_MSG_PUB.Add;

4096: THEN
4097:
4098: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
4099: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','method_code');
4100: OE_MSG_PUB.Add;
4101:
4102: END IF;
4103:
4104: RETURN FND_API.G_MISS_CHAR;

Line 4108: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

4104: RETURN FND_API.G_MISS_CHAR;
4105:
4106: WHEN OTHERS THEN
4107:
4108: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4109: THEN
4110: OE_MSG_PUB.Add_Exc_Msg
4111: ( G_PKG_NAME
4112: , 'Method'

Line 4110: OE_MSG_PUB.Add_Exc_Msg

4106: WHEN OTHERS THEN
4107:
4108: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4109: THEN
4110: OE_MSG_PUB.Add_Exc_Msg
4111: ( G_PKG_NAME
4112: , 'Method'
4113: );
4114: END IF;

Line 4145: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

4141: EXCEPTION
4142:
4143: WHEN NO_DATA_FOUND THEN
4144:
4145: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4146: THEN
4147:
4148: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
4149: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','price_list_line_id');

Line 4150: OE_MSG_PUB.Add;

4146: THEN
4147:
4148: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
4149: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','price_list_line_id');
4150: OE_MSG_PUB.Add;
4151:
4152: END IF;
4153:
4154: RETURN FND_API.G_MISS_NUM;

Line 4158: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

4154: RETURN FND_API.G_MISS_NUM;
4155:
4156: WHEN OTHERS THEN
4157:
4158: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4159: THEN
4160: OE_MSG_PUB.Add_Exc_Msg
4161: ( G_PKG_NAME
4162: , 'Price_List_Line'

Line 4160: OE_MSG_PUB.Add_Exc_Msg

4156: WHEN OTHERS THEN
4157:
4158: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4159: THEN
4160: OE_MSG_PUB.Add_Exc_Msg
4161: ( G_PKG_NAME
4162: , 'Price_List_Line'
4163: );
4164: END IF;

Line 4195: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

4191: EXCEPTION
4192:
4193: WHEN NO_DATA_FOUND THEN
4194:
4195: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4196: THEN
4197:
4198: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
4199: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','pricing_rule_id');

Line 4200: OE_MSG_PUB.Add;

4196: THEN
4197:
4198: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
4199: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','pricing_rule_id');
4200: OE_MSG_PUB.Add;
4201:
4202: END IF;
4203:
4204: RETURN FND_API.G_MISS_NUM;

Line 4208: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

4204: RETURN FND_API.G_MISS_NUM;
4205:
4206: WHEN OTHERS THEN
4207:
4208: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4209: THEN
4210: OE_MSG_PUB.Add_Exc_Msg
4211: ( G_PKG_NAME
4212: , 'Pricing_Rule'

Line 4210: OE_MSG_PUB.Add_Exc_Msg

4206: WHEN OTHERS THEN
4207:
4208: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4209: THEN
4210: OE_MSG_PUB.Add_Exc_Msg
4211: ( G_PKG_NAME
4212: , 'Pricing_Rule'
4213: );
4214: END IF;

Line 4245: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

4241: EXCEPTION
4242:
4243: WHEN NO_DATA_FOUND THEN
4244:
4245: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4246: THEN
4247:
4248: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
4249: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','reprice_flag');

Line 4250: OE_MSG_PUB.Add;

4246: THEN
4247:
4248: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
4249: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','reprice_flag');
4250: OE_MSG_PUB.Add;
4251:
4252: END IF;
4253:
4254: RETURN FND_API.G_MISS_CHAR;

Line 4258: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

4254: RETURN FND_API.G_MISS_CHAR;
4255:
4256: WHEN OTHERS THEN
4257:
4258: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4259: THEN
4260: OE_MSG_PUB.Add_Exc_Msg
4261: ( G_PKG_NAME
4262: , 'Reprice'

Line 4260: OE_MSG_PUB.Add_Exc_Msg

4256: WHEN OTHERS THEN
4257:
4258: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4259: THEN
4260: OE_MSG_PUB.Add_Exc_Msg
4261: ( G_PKG_NAME
4262: , 'Reprice'
4263: );
4264: END IF;

Line 4295: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

4291: EXCEPTION
4292:
4293: WHEN NO_DATA_FOUND THEN
4294:
4295: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4296: THEN
4297:
4298: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
4299: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','unit_code');

Line 4300: OE_MSG_PUB.Add;

4296: THEN
4297:
4298: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
4299: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','unit_code');
4300: OE_MSG_PUB.Add;
4301:
4302: END IF;
4303:
4304: RETURN FND_API.G_MISS_CHAR;

Line 4308: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

4304: RETURN FND_API.G_MISS_CHAR;
4305:
4306: WHEN OTHERS THEN
4307:
4308: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4309: THEN
4310: OE_MSG_PUB.Add_Exc_Msg
4311: ( G_PKG_NAME
4312: , 'Unit'

Line 4310: OE_MSG_PUB.Add_Exc_Msg

4306: WHEN OTHERS THEN
4307:
4308: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4309: THEN
4310: OE_MSG_PUB.Add_Exc_Msg
4311: ( G_PKG_NAME
4312: , 'Unit'
4313: );
4314: END IF;

Line 4345: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

4341: EXCEPTION
4342:
4343: WHEN NO_DATA_FOUND THEN
4344:
4345: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4346: THEN
4347:
4348: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
4349: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','customer_class_code');

Line 4350: OE_MSG_PUB.Add;

4346: THEN
4347:
4348: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
4349: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','customer_class_code');
4350: OE_MSG_PUB.Add;
4351:
4352: END IF;
4353:
4354: RETURN FND_API.G_MISS_CHAR;

Line 4358: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

4354: RETURN FND_API.G_MISS_CHAR;
4355:
4356: WHEN OTHERS THEN
4357:
4358: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4359: THEN
4360: OE_MSG_PUB.Add_Exc_Msg
4361: ( G_PKG_NAME
4362: , 'Customer_Class'

Line 4360: OE_MSG_PUB.Add_Exc_Msg

4356: WHEN OTHERS THEN
4357:
4358: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4359: THEN
4360: OE_MSG_PUB.Add_Exc_Msg
4361: ( G_PKG_NAME
4362: , 'Customer_Class'
4363: );
4364: END IF;

Line 4395: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

4391: EXCEPTION
4392:
4393: WHEN NO_DATA_FOUND THEN
4394:
4395: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4396: THEN
4397:
4398: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
4399: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','discount_customer_id');

Line 4400: OE_MSG_PUB.Add;

4396: THEN
4397:
4398: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
4399: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','discount_customer_id');
4400: OE_MSG_PUB.Add;
4401:
4402: END IF;
4403:
4404: RETURN FND_API.G_MISS_NUM;

Line 4408: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

4404: RETURN FND_API.G_MISS_NUM;
4405:
4406: WHEN OTHERS THEN
4407:
4408: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4409: THEN
4410: OE_MSG_PUB.Add_Exc_Msg
4411: ( G_PKG_NAME
4412: , 'Discount_Customer'

Line 4410: OE_MSG_PUB.Add_Exc_Msg

4406: WHEN OTHERS THEN
4407:
4408: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4409: THEN
4410: OE_MSG_PUB.Add_Exc_Msg
4411: ( G_PKG_NAME
4412: , 'Discount_Customer'
4413: );
4414: END IF;

Line 4445: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

4441: EXCEPTION
4442:
4443: WHEN NO_DATA_FOUND THEN
4444:
4445: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4446: THEN
4447:
4448: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
4449: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','site_use_id');

Line 4450: OE_MSG_PUB.Add;

4446: THEN
4447:
4448: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
4449: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','site_use_id');
4450: OE_MSG_PUB.Add;
4451:
4452: END IF;
4453:
4454: RETURN FND_API.G_MISS_NUM;

Line 4458: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

4454: RETURN FND_API.G_MISS_NUM;
4455:
4456: WHEN OTHERS THEN
4457:
4458: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4459: THEN
4460: OE_MSG_PUB.Add_Exc_Msg
4461: ( G_PKG_NAME
4462: , 'Site_Use'

Line 4460: OE_MSG_PUB.Add_Exc_Msg

4456: WHEN OTHERS THEN
4457:
4458: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4459: THEN
4460: OE_MSG_PUB.Add_Exc_Msg
4461: ( G_PKG_NAME
4462: , 'Site_Use'
4463: );
4464: END IF;

Line 4495: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

4491: EXCEPTION
4492:
4493: WHEN NO_DATA_FOUND THEN
4494:
4495: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4496: THEN
4497:
4498: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
4499: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','entity_id');

Line 4500: OE_MSG_PUB.Add;

4496: THEN
4497:
4498: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
4499: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','entity_id');
4500: OE_MSG_PUB.Add;
4501:
4502: END IF;
4503:
4504: RETURN FND_API.G_MISS_NUM;

Line 4508: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

4504: RETURN FND_API.G_MISS_NUM;
4505:
4506: WHEN OTHERS THEN
4507:
4508: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4509: THEN
4510: OE_MSG_PUB.Add_Exc_Msg
4511: ( G_PKG_NAME
4512: , 'Entity'

Line 4510: OE_MSG_PUB.Add_Exc_Msg

4506: WHEN OTHERS THEN
4507:
4508: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4509: THEN
4510: OE_MSG_PUB.Add_Exc_Msg
4511: ( G_PKG_NAME
4512: , 'Entity'
4513: );
4514: END IF;

Line 4545: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

4541: EXCEPTION
4542:
4543: WHEN NO_DATA_FOUND THEN
4544:
4545: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4546: THEN
4547:
4548: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
4549: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','method_type_code');

Line 4550: OE_MSG_PUB.Add;

4546: THEN
4547:
4548: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
4549: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','method_type_code');
4550: OE_MSG_PUB.Add;
4551:
4552: END IF;
4553:
4554: RETURN FND_API.G_MISS_CHAR;

Line 4558: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

4554: RETURN FND_API.G_MISS_CHAR;
4555:
4556: WHEN OTHERS THEN
4557:
4558: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4559: THEN
4560: OE_MSG_PUB.Add_Exc_Msg
4561: ( G_PKG_NAME
4562: , 'Method_Type'

Line 4560: OE_MSG_PUB.Add_Exc_Msg

4556: WHEN OTHERS THEN
4557:
4558: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4559: THEN
4560: OE_MSG_PUB.Add_Exc_Msg
4561: ( G_PKG_NAME
4562: , 'Method_Type'
4563: );
4564: END IF;

Line 4597: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

4593: EXCEPTION
4594:
4595: WHEN NO_DATA_FOUND THEN
4596:
4597: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4598: THEN
4599:
4600: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
4601: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','lot_serial_id');

Line 4602: OE_MSG_PUB.Add;

4598: THEN
4599:
4600: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
4601: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','lot_serial_id');
4602: OE_MSG_PUB.Add;
4603:
4604: END IF;
4605:
4606: RETURN FND_API.G_MISS_NUM;

Line 4610: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

4606: RETURN FND_API.G_MISS_NUM;
4607:
4608: WHEN OTHERS THEN
4609:
4610: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4611: THEN
4612: OE_MSG_PUB.Add_Exc_Msg
4613: ( G_PKG_NAME
4614: , 'Lot_Serial'

Line 4612: OE_MSG_PUB.Add_Exc_Msg

4608: WHEN OTHERS THEN
4609:
4610: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4611: THEN
4612: OE_MSG_PUB.Add_Exc_Msg
4613: ( G_PKG_NAME
4614: , 'Lot_Serial'
4615: );
4616: END IF;

Line 4647: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

4643: EXCEPTION
4644:
4645: WHEN NO_DATA_FOUND THEN
4646:
4647: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4648: THEN
4649:
4650: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
4651: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','appear_on_ack_flag');

Line 4652: OE_MSG_PUB.Add;

4648: THEN
4649:
4650: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
4651: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','appear_on_ack_flag');
4652: OE_MSG_PUB.Add;
4653:
4654: END IF;
4655:
4656: RETURN FND_API.G_MISS_CHAR;

Line 4660: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

4656: RETURN FND_API.G_MISS_CHAR;
4657:
4658: WHEN OTHERS THEN
4659:
4660: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4661: THEN
4662: OE_MSG_PUB.Add_Exc_Msg
4663: ( G_PKG_NAME
4664: , 'Appear_On_Ack'

Line 4662: OE_MSG_PUB.Add_Exc_Msg

4658: WHEN OTHERS THEN
4659:
4660: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4661: THEN
4662: OE_MSG_PUB.Add_Exc_Msg
4663: ( G_PKG_NAME
4664: , 'Appear_On_Ack'
4665: );
4666: END IF;

Line 4697: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

4693: EXCEPTION
4694:
4695: WHEN NO_DATA_FOUND THEN
4696:
4697: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4698: THEN
4699:
4700: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
4701: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','appear_on_invoice_flag');

Line 4702: OE_MSG_PUB.Add;

4698: THEN
4699:
4700: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
4701: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','appear_on_invoice_flag');
4702: OE_MSG_PUB.Add;
4703:
4704: END IF;
4705:
4706: RETURN FND_API.G_MISS_CHAR;

Line 4710: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

4706: RETURN FND_API.G_MISS_CHAR;
4707:
4708: WHEN OTHERS THEN
4709:
4710: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4711: THEN
4712: OE_MSG_PUB.Add_Exc_Msg
4713: ( G_PKG_NAME
4714: , 'Appear_On_Invoice'

Line 4712: OE_MSG_PUB.Add_Exc_Msg

4708: WHEN OTHERS THEN
4709:
4710: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4711: THEN
4712: OE_MSG_PUB.Add_Exc_Msg
4713: ( G_PKG_NAME
4714: , 'Appear_On_Invoice'
4715: );
4716: END IF;

Line 4747: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

4743: EXCEPTION
4744:
4745: WHEN NO_DATA_FOUND THEN
4746:
4747: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4748: THEN
4749:
4750: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
4751: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','charge_id');

Line 4752: OE_MSG_PUB.Add;

4748: THEN
4749:
4750: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
4751: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','charge_id');
4752: OE_MSG_PUB.Add;
4753:
4754: END IF;
4755:
4756: RETURN FND_API.G_MISS_NUM;

Line 4760: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

4756: RETURN FND_API.G_MISS_NUM;
4757:
4758: WHEN OTHERS THEN
4759:
4760: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4761: THEN
4762: OE_MSG_PUB.Add_Exc_Msg
4763: ( G_PKG_NAME
4764: , 'Charge'

Line 4762: OE_MSG_PUB.Add_Exc_Msg

4758: WHEN OTHERS THEN
4759:
4760: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4761: THEN
4762: OE_MSG_PUB.Add_Exc_Msg
4763: ( G_PKG_NAME
4764: , 'Charge'
4765: );
4766: END IF;

Line 4797: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

4793: EXCEPTION
4794:
4795: WHEN NO_DATA_FOUND THEN
4796:
4797: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4798: THEN
4799:
4800: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
4801: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','charge_type_id');

Line 4802: OE_MSG_PUB.Add;

4798: THEN
4799:
4800: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
4801: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','charge_type_id');
4802: OE_MSG_PUB.Add;
4803:
4804: END IF;
4805:
4806: RETURN FND_API.G_MISS_NUM;

Line 4810: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

4806: RETURN FND_API.G_MISS_NUM;
4807:
4808: WHEN OTHERS THEN
4809:
4810: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4811: THEN
4812: OE_MSG_PUB.Add_Exc_Msg
4813: ( G_PKG_NAME
4814: , 'Charge_Type'

Line 4812: OE_MSG_PUB.Add_Exc_Msg

4808: WHEN OTHERS THEN
4809:
4810: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4811: THEN
4812: OE_MSG_PUB.Add_Exc_Msg
4813: ( G_PKG_NAME
4814: , 'Charge_Type'
4815: );
4816: END IF;

Line 4847: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

4843: EXCEPTION
4844:
4845: WHEN NO_DATA_FOUND THEN
4846:
4847: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4848: THEN
4849:
4850: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
4851: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','cost_or_charge_flag');

Line 4852: OE_MSG_PUB.Add;

4848: THEN
4849:
4850: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
4851: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','cost_or_charge_flag');
4852: OE_MSG_PUB.Add;
4853:
4854: END IF;
4855:
4856: RETURN FND_API.G_MISS_CHAR;

Line 4860: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

4856: RETURN FND_API.G_MISS_CHAR;
4857:
4858: WHEN OTHERS THEN
4859:
4860: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4861: THEN
4862: OE_MSG_PUB.Add_Exc_Msg
4863: ( G_PKG_NAME
4864: , 'Cost_Or_Charge'

Line 4862: OE_MSG_PUB.Add_Exc_Msg

4858: WHEN OTHERS THEN
4859:
4860: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4861: THEN
4862: OE_MSG_PUB.Add_Exc_Msg
4863: ( G_PKG_NAME
4864: , 'Cost_Or_Charge'
4865: );
4866: END IF;

Line 4897: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

4893: EXCEPTION
4894:
4895: WHEN NO_DATA_FOUND THEN
4896:
4897: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4898: THEN
4899:
4900: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
4901: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','departure_id');

Line 4902: OE_MSG_PUB.Add;

4898: THEN
4899:
4900: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
4901: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','departure_id');
4902: OE_MSG_PUB.Add;
4903:
4904: END IF;
4905:
4906: RETURN FND_API.G_MISS_NUM;

Line 4910: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

4906: RETURN FND_API.G_MISS_NUM;
4907:
4908: WHEN OTHERS THEN
4909:
4910: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4911: THEN
4912: OE_MSG_PUB.Add_Exc_Msg
4913: ( G_PKG_NAME
4914: , 'Departure'

Line 4912: OE_MSG_PUB.Add_Exc_Msg

4908: WHEN OTHERS THEN
4909:
4910: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4911: THEN
4912: OE_MSG_PUB.Add_Exc_Msg
4913: ( G_PKG_NAME
4914: , 'Departure'
4915: );
4916: END IF;

Line 4947: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

4943: EXCEPTION
4944:
4945: WHEN NO_DATA_FOUND THEN
4946:
4947: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4948: THEN
4949:
4950: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
4951: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','estimated_flag');

Line 4952: OE_MSG_PUB.Add;

4948: THEN
4949:
4950: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
4951: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','estimated_flag');
4952: OE_MSG_PUB.Add;
4953:
4954: END IF;
4955:
4956: RETURN FND_API.G_MISS_CHAR;

Line 4960: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

4956: RETURN FND_API.G_MISS_CHAR;
4957:
4958: WHEN OTHERS THEN
4959:
4960: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4961: THEN
4962: OE_MSG_PUB.Add_Exc_Msg
4963: ( G_PKG_NAME
4964: , 'Estimated'

Line 4962: OE_MSG_PUB.Add_Exc_Msg

4958: WHEN OTHERS THEN
4959:
4960: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4961: THEN
4962: OE_MSG_PUB.Add_Exc_Msg
4963: ( G_PKG_NAME
4964: , 'Estimated'
4965: );
4966: END IF;

Line 4997: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

4993: EXCEPTION
4994:
4995: WHEN NO_DATA_FOUND THEN
4996:
4997: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4998: THEN
4999:
5000: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
5001: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','invoiced_flag');

Line 5002: OE_MSG_PUB.Add;

4998: THEN
4999:
5000: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
5001: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','invoiced_flag');
5002: OE_MSG_PUB.Add;
5003:
5004: END IF;
5005:
5006: RETURN FND_API.G_MISS_CHAR;

Line 5010: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

5006: RETURN FND_API.G_MISS_CHAR;
5007:
5008: WHEN OTHERS THEN
5009:
5010: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5011: THEN
5012: OE_MSG_PUB.Add_Exc_Msg
5013: ( G_PKG_NAME
5014: , 'Invoiced'

Line 5012: OE_MSG_PUB.Add_Exc_Msg

5008: WHEN OTHERS THEN
5009:
5010: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5011: THEN
5012: OE_MSG_PUB.Add_Exc_Msg
5013: ( G_PKG_NAME
5014: , 'Invoiced'
5015: );
5016: END IF;

Line 5047: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

5043: EXCEPTION
5044:
5045: WHEN NO_DATA_FOUND THEN
5046:
5047: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
5048: THEN
5049:
5050: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
5051: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','parent_charge_id');

Line 5052: OE_MSG_PUB.Add;

5048: THEN
5049:
5050: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
5051: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','parent_charge_id');
5052: OE_MSG_PUB.Add;
5053:
5054: END IF;
5055:
5056: RETURN FND_API.G_MISS_NUM;

Line 5060: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

5056: RETURN FND_API.G_MISS_NUM;
5057:
5058: WHEN OTHERS THEN
5059:
5060: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5061: THEN
5062: OE_MSG_PUB.Add_Exc_Msg
5063: ( G_PKG_NAME
5064: , 'Parent_Charge'

Line 5062: OE_MSG_PUB.Add_Exc_Msg

5058: WHEN OTHERS THEN
5059:
5060: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5061: THEN
5062: OE_MSG_PUB.Add_Exc_Msg
5063: ( G_PKG_NAME
5064: , 'Parent_Charge'
5065: );
5066: END IF;

Line 5097: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

5093: EXCEPTION
5094:
5095: WHEN NO_DATA_FOUND THEN
5096:
5097: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
5098: THEN
5099:
5100: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
5101: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','returnable_flag');

Line 5102: OE_MSG_PUB.Add;

5098: THEN
5099:
5100: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
5101: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','returnable_flag');
5102: OE_MSG_PUB.Add;
5103:
5104: END IF;
5105:
5106: RETURN FND_API.G_MISS_CHAR;

Line 5110: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

5106: RETURN FND_API.G_MISS_CHAR;
5107:
5108: WHEN OTHERS THEN
5109:
5110: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5111: THEN
5112: OE_MSG_PUB.Add_Exc_Msg
5113: ( G_PKG_NAME
5114: , 'Returnable'

Line 5112: OE_MSG_PUB.Add_Exc_Msg

5108: WHEN OTHERS THEN
5109:
5110: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5111: THEN
5112: OE_MSG_PUB.Add_Exc_Msg
5113: ( G_PKG_NAME
5114: , 'Returnable'
5115: );
5116: END IF;

Line 5147: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

5143: EXCEPTION
5144:
5145: WHEN NO_DATA_FOUND THEN
5146:
5147: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
5148: THEN
5149:
5150: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
5151: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','tax_group_code');

Line 5152: OE_MSG_PUB.Add;

5148: THEN
5149:
5150: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
5151: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','tax_group_code');
5152: OE_MSG_PUB.Add;
5153:
5154: END IF;
5155:
5156: RETURN FND_API.G_MISS_CHAR;

Line 5160: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

5156: RETURN FND_API.G_MISS_CHAR;
5157:
5158: WHEN OTHERS THEN
5159:
5160: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5161: THEN
5162: OE_MSG_PUB.Add_Exc_Msg
5163: ( G_PKG_NAME
5164: , 'Tax_Group'

Line 5162: OE_MSG_PUB.Add_Exc_Msg

5158: WHEN OTHERS THEN
5159:
5160: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5161: THEN
5162: OE_MSG_PUB.Add_Exc_Msg
5163: ( G_PKG_NAME
5164: , 'Tax_Group'
5165: );
5166: END IF;

Line 5198: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

5194: EXCEPTION
5195:
5196: WHEN NO_DATA_FOUND THEN
5197:
5198: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
5199: THEN
5200:
5201: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
5202: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','flow_status_code');

Line 5203: OE_MSG_PUB.Add;

5199: THEN
5200:
5201: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
5202: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','flow_status_code');
5203: OE_MSG_PUB.Add;
5204:
5205: END IF;
5206:
5207: RETURN FND_API.G_MISS_CHAR;

Line 5211: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

5207: RETURN FND_API.G_MISS_CHAR;
5208:
5209: WHEN OTHERS THEN
5210:
5211: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5212: THEN
5213: OE_MSG_PUB.Add_Exc_Msg
5214: ( G_PKG_NAME
5215: , 'Flow_Status'

Line 5213: OE_MSG_PUB.Add_Exc_Msg

5209: WHEN OTHERS THEN
5210:
5211: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5212: THEN
5213: OE_MSG_PUB.Add_Exc_Msg
5214: ( G_PKG_NAME
5215: , 'Flow_Status'
5216: );
5217: END IF;

Line 5257: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

5253: EXCEPTION
5254:
5255: WHEN NO_DATA_FOUND THEN
5256:
5257: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
5258: THEN
5259:
5260: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
5261: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','freight_carrier_code');

Line 5262: OE_MSG_PUB.Add;

5258: THEN
5259:
5260: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
5261: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','freight_carrier_code');
5262: OE_MSG_PUB.Add;
5263:
5264: END IF;
5265:
5266: RETURN FND_API.G_MISS_CHAR;

Line 5270: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

5266: RETURN FND_API.G_MISS_CHAR;
5267:
5268: WHEN OTHERS THEN
5269:
5270: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5271: THEN
5272: OE_MSG_PUB.Add_Exc_Msg
5273: ( G_PKG_NAME
5274: , 'Freight_Carrier'

Line 5272: OE_MSG_PUB.Add_Exc_Msg

5268: WHEN OTHERS THEN
5269:
5270: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5271: THEN
5272: OE_MSG_PUB.Add_Exc_Msg
5273: ( G_PKG_NAME
5274: , 'Freight_Carrier'
5275: );
5276: END IF;

Line 5308: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

5304: EXCEPTION
5305:
5306: WHEN NO_DATA_FOUND THEN
5307:
5308: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
5309: THEN
5310:
5311: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
5312: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','sales_channel_code');

Line 5313: OE_MSG_PUB.Add;

5309: THEN
5310:
5311: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
5312: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','sales_channel_code');
5313: OE_MSG_PUB.Add;
5314:
5315: END IF;
5316:
5317: RETURN FND_API.G_MISS_CHAR;

Line 5321: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

5317: RETURN FND_API.G_MISS_CHAR;
5318:
5319: WHEN OTHERS THEN
5320:
5321: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5322: THEN
5323: OE_MSG_PUB.Add_Exc_Msg
5324: ( G_PKG_NAME
5325: , 'Sales_Channel'

Line 5323: OE_MSG_PUB.Add_Exc_Msg

5319: WHEN OTHERS THEN
5320:
5321: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5322: THEN
5323: OE_MSG_PUB.Add_Exc_Msg
5324: ( G_PKG_NAME
5325: , 'Sales_Channel'
5326: );
5327: END IF;

Line 5402: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

5398: EXCEPTION
5399:
5400: WHEN NO_DATA_FOUND THEN
5401:
5402: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
5403: THEN
5404:
5405: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
5406: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','sold_to_site_use_id');

Line 5407: OE_MSG_PUB.Add;

5403: THEN
5404:
5405: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
5406: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','sold_to_site_use_id');
5407: OE_MSG_PUB.Add;
5408:
5409: END IF;
5410:
5411: RETURN FND_API.G_MISS_NUM;

Line 5415: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

5411: RETURN FND_API.G_MISS_NUM;
5412:
5413: WHEN OTHERS THEN
5414:
5415: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5416: THEN
5417: OE_MSG_PUB.Add_Exc_Msg
5418: ( G_PKG_NAME
5419: , 'Customer_Location'

Line 5417: OE_MSG_PUB.Add_Exc_Msg

5413: WHEN OTHERS THEN
5414:
5415: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5416: THEN
5417: OE_MSG_PUB.Add_Exc_Msg
5418: ( G_PKG_NAME
5419: , 'Customer_Location'
5420: );
5421: END IF;

Line 5467: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

5463: EXCEPTION
5464:
5465: WHEN NO_DATA_FOUND THEN
5466:
5467: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
5468: THEN
5469:
5470: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
5471: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','end_customer_id');

Line 5472: OE_MSG_PUB.Add;

5468: THEN
5469:
5470: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
5471: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','end_customer_id');
5472: OE_MSG_PUB.Add;
5473:
5474: END IF;
5475:
5476: RETURN FND_API.G_MISS_NUM;

Line 5480: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

5476: RETURN FND_API.G_MISS_NUM;
5477:
5478: WHEN OTHERS THEN
5479:
5480: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5481: THEN
5482: OE_MSG_PUB.Add_Exc_Msg
5483: ( G_PKG_NAME
5484: , 'End_customer'

Line 5482: OE_MSG_PUB.Add_Exc_Msg

5478: WHEN OTHERS THEN
5479:
5480: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5481: THEN
5482: OE_MSG_PUB.Add_Exc_Msg
5483: ( G_PKG_NAME
5484: , 'End_customer'
5485: );
5486: END IF;

Line 5519: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

5515: EXCEPTION
5516:
5517: WHEN NO_DATA_FOUND THEN
5518:
5519: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
5520: THEN
5521:
5522: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
5523: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','end_customer_contact_id');

Line 5524: OE_MSG_PUB.Add;

5520: THEN
5521:
5522: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
5523: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','end_customer_contact_id');
5524: OE_MSG_PUB.Add;
5525:
5526: END IF;
5527:
5528: RETURN FND_API.G_MISS_NUM;

Line 5532: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

5528: RETURN FND_API.G_MISS_NUM;
5529:
5530: WHEN OTHERS THEN
5531:
5532: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5533: THEN
5534: OE_MSG_PUB.Add_Exc_Msg
5535: ( G_PKG_NAME
5536: , 'End_customer_contact'

Line 5534: OE_MSG_PUB.Add_Exc_Msg

5530: WHEN OTHERS THEN
5531:
5532: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5533: THEN
5534: OE_MSG_PUB.Add_Exc_Msg
5535: ( G_PKG_NAME
5536: , 'End_customer_contact'
5537: );
5538: END IF;

Line 5765: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

5761: IF c_site_use_id2%ISOPEN then
5762: CLOSE c_site_use_id2;
5763: END IF;
5764:
5765: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
5766: THEN
5767:
5768: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
5769: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','end_customer_site_id');

Line 5770: OE_MSG_PUB.Add;

5766: THEN
5767:
5768: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
5769: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','end_customer_site_id');
5770: OE_MSG_PUB.Add;
5771:
5772: END IF;
5773: RETURN FND_API.G_MISS_NUM;
5774:

Line 5785: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

5781: IF c_site_use_id2%ISOPEN then
5782: CLOSE c_site_use_id2;
5783: END IF;
5784:
5785: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5786: THEN
5787: OE_MSG_PUB.Add_Exc_Msg
5788: ( G_PKG_NAME
5789: , 'end_cstomer_site_id'

Line 5787: OE_MSG_PUB.Add_Exc_Msg

5783: END IF;
5784:
5785: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5786: THEN
5787: OE_MSG_PUB.Add_Exc_Msg
5788: ( G_PKG_NAME
5789: , 'end_cstomer_site_id'
5790: );
5791: END IF;

Line 5827: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

5823: EXCEPTION
5824:
5825: WHEN NO_DATA_FOUND THEN
5826:
5827: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
5828: THEN
5829:
5830: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
5831: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ib_owner');

Line 5832: OE_MSG_PUB.Add;

5828: THEN
5829:
5830: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
5831: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ib_owner');
5832: OE_MSG_PUB.Add;
5833:
5834: END IF;
5835:
5836: RETURN FND_API.G_MISS_CHAR;

Line 5840: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

5836: RETURN FND_API.G_MISS_CHAR;
5837:
5838: WHEN OTHERS THEN
5839:
5840: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5841: THEN
5842: OE_MSG_PUB.Add_Exc_Msg
5843: ( G_PKG_NAME
5844: , 'IB_Owner'

Line 5842: OE_MSG_PUB.Add_Exc_Msg

5838: WHEN OTHERS THEN
5839:
5840: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5841: THEN
5842: OE_MSG_PUB.Add_Exc_Msg
5843: ( G_PKG_NAME
5844: , 'IB_Owner'
5845: );
5846: END IF;

Line 5882: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

5878: EXCEPTION
5879:
5880: WHEN NO_DATA_FOUND THEN
5881:
5882: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
5883: THEN
5884:
5885: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
5886: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ib_installed_at_location');

Line 5887: OE_MSG_PUB.Add;

5883: THEN
5884:
5885: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
5886: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ib_installed_at_location');
5887: OE_MSG_PUB.Add;
5888:
5889: END IF;
5890:
5891: RETURN FND_API.G_MISS_CHAR;

Line 5895: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

5891: RETURN FND_API.G_MISS_CHAR;
5892:
5893: WHEN OTHERS THEN
5894:
5895: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5896: THEN
5897: OE_MSG_PUB.Add_Exc_Msg
5898: ( G_PKG_NAME
5899: , 'ib_installed_at_location'

Line 5897: OE_MSG_PUB.Add_Exc_Msg

5893: WHEN OTHERS THEN
5894:
5895: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5896: THEN
5897: OE_MSG_PUB.Add_Exc_Msg
5898: ( G_PKG_NAME
5899: , 'ib_installed_at_location'
5900: );
5901: END IF;

Line 5937: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

5933: EXCEPTION
5934:
5935: WHEN NO_DATA_FOUND THEN
5936:
5937: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
5938: THEN
5939:
5940: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
5941: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ib_current_location');

Line 5942: OE_MSG_PUB.Add;

5938: THEN
5939:
5940: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
5941: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ib_current_location');
5942: OE_MSG_PUB.Add;
5943:
5944: END IF;
5945:
5946: RETURN FND_API.G_MISS_CHAR;

Line 5950: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

5946: RETURN FND_API.G_MISS_CHAR;
5947:
5948: WHEN OTHERS THEN
5949:
5950: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5951: THEN
5952: OE_MSG_PUB.Add_Exc_Msg
5953: ( G_PKG_NAME
5954: , 'ib_current_location'

Line 5952: OE_MSG_PUB.Add_Exc_Msg

5948: WHEN OTHERS THEN
5949:
5950: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5951: THEN
5952: OE_MSG_PUB.Add_Exc_Msg
5953: ( G_PKG_NAME
5954: , 'ib_current_location'
5955: );
5956: END IF;