[Home] [Help]
245: -- Error getting combination id.
246: -- Function has already pushed a message on the stack. Add to
247: -- the API message list.
248:
249: OE_MSG_PUB.Add;
250: l_id := FND_API.G_MISS_NUM;
251:
252: END IF;
253:
256: EXCEPTION
257:
258: WHEN OTHERS THEN
259:
260: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
261: THEN
262: OE_MSG_PUB.Add_Exc_Msg
263: ( G_PKG_NAME
264: , 'Key_Flex'
258: WHEN OTHERS THEN
259:
260: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
261: THEN
262: OE_MSG_PUB.Add_Exc_Msg
263: ( G_PKG_NAME
264: , 'Key_Flex'
265: );
266: END IF;
299: EXCEPTION
300:
301: WHEN NO_DATA_FOUND THEN
302:
303: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
304: THEN
305:
306: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
307: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','accounting_rule_id');
304: THEN
305:
306: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
307: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','accounting_rule_id');
308: OE_MSG_PUB.Add;
309:
310: END IF;
311:
312: RETURN FND_API.G_MISS_NUM;
312: RETURN FND_API.G_MISS_NUM;
313:
314: WHEN OTHERS THEN
315:
316: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
317: THEN
318: OE_MSG_PUB.Add_Exc_Msg
319: ( G_PKG_NAME
320: , 'Accounting_Rule'
314: WHEN OTHERS THEN
315:
316: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
317: THEN
318: OE_MSG_PUB.Add_Exc_Msg
319: ( G_PKG_NAME
320: , 'Accounting_Rule'
321: );
322: END IF;
353: EXCEPTION
354:
355: WHEN NO_DATA_FOUND THEN
356:
357: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
358: THEN
359:
360: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
361: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','agreement_id');
358: THEN
359:
360: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
361: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','agreement_id');
362: OE_MSG_PUB.Add;
363:
364: END IF;
365:
366: RETURN FND_API.G_MISS_NUM;
366: RETURN FND_API.G_MISS_NUM;
367:
368: WHEN OTHERS THEN
369:
370: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
371: THEN
372: OE_MSG_PUB.Add_Exc_Msg
373: ( G_PKG_NAME
374: , 'Agreement'
368: WHEN OTHERS THEN
369:
370: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
371: THEN
372: OE_MSG_PUB.Add_Exc_Msg
373: ( G_PKG_NAME
374: , 'Agreement'
375: );
376: END IF;
406: EXCEPTION
407:
408: WHEN NO_DATA_FOUND THEN
409:
410: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
411: THEN
412:
413: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
414: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','conversion_type_code');
411: THEN
412:
413: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
414: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','conversion_type_code');
415: OE_MSG_PUB.Add;
416:
417: END IF;
418:
419: RETURN FND_API.G_MISS_CHAR;
419: RETURN FND_API.G_MISS_CHAR;
420:
421: WHEN OTHERS THEN
422:
423: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
424: THEN
425: OE_MSG_PUB.Add_Exc_Msg
426: ( G_PKG_NAME
427: , 'Conversion_Type'
421: WHEN OTHERS THEN
422:
423: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
424: THEN
425: OE_MSG_PUB.Add_Exc_Msg
426: ( G_PKG_NAME
427: , 'Conversion_Type'
428: );
429: END IF;
467: EXCEPTION
468:
469: WHEN NO_DATA_FOUND THEN
470:
471: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
472: THEN
473:
474: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
475: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','deliver_to_contact_id');
472: THEN
473:
474: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
475: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','deliver_to_contact_id');
476: OE_MSG_PUB.Add;
477:
478: END IF;
479:
480: RETURN FND_API.G_MISS_NUM;
480: RETURN FND_API.G_MISS_NUM;
481:
482: WHEN OTHERS THEN
483:
484: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
485: THEN
486: OE_MSG_PUB.Add_Exc_Msg
487: ( G_PKG_NAME
488: , 'Deliver_To_Contact'
482: WHEN OTHERS THEN
483:
484: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
485: THEN
486: OE_MSG_PUB.Add_Exc_Msg
487: ( G_PKG_NAME
488: , 'Deliver_To_Contact'
489: );
490: END IF;
631:
632: IF l_debug_level > 0 THEN
633: oe_debug_pub.add( 'CUSTOMER RELATION IS NOT ON , BUT THE SOLD_TO_ORG '|| 'AND DELIVER_TO_CUSTOMER ARE NOT SAME' ) ;
634: END IF;
635: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN
636:
637: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
638: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','deliver_to_org_id');
639: OE_MSG_PUB.Add;
635: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN
636:
637: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
638: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','deliver_to_org_id');
639: OE_MSG_PUB.Add;
640:
641: END IF;
642:
643: RETURN FND_API.G_MISS_NUM;
660: and ship_to_flag = 'Y' and status='A';
661: EXCEPTION
662:
663: WHEN NO_DATA_FOUND THEN
664: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN
665:
666: IF l_debug_level > 0 THEN
667: oe_debug_pub.add( 'CUSTOMER RELATION IS ON , BUT THE '|| 'SOLD_TO_ORG AND DELIVER_TO_CUSTOMER ARE NOT RELATED' ) ;
668: END IF;
667: oe_debug_pub.add( 'CUSTOMER RELATION IS ON , BUT THE '|| 'SOLD_TO_ORG AND DELIVER_TO_CUSTOMER ARE NOT RELATED' ) ;
668: END IF;
669: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
670: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','deliver_to_org_id');
671: OE_MSG_PUB.Add;
672:
673: END IF;
674:
675: RETURN FND_API.G_MISS_NUM;
836: IF C2%ISOPEN then
837: CLOSE C2;
838: END IF;
839:
840: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
841: THEN
842:
843: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
844: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','deliver_to_org_id');
841: THEN
842:
843: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
844: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','deliver_to_org_id');
845: OE_MSG_PUB.Add;
846:
847: END IF;
848:
849: RETURN FND_API.G_MISS_NUM;
862: CLOSE C2;
863: END IF;
864:
865:
866: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
867: THEN
868: OE_MSG_PUB.Add_Exc_Msg
869: ( G_PKG_NAME
870: , 'Deliver_To_Org'
864:
865:
866: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
867: THEN
868: OE_MSG_PUB.Add_Exc_Msg
869: ( G_PKG_NAME
870: , 'Deliver_To_Org'
871: );
872: END IF;
904: EXCEPTION
905:
906: WHEN NO_DATA_FOUND THEN
907:
908: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
909: THEN
910:
911: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
912: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','fob_point_code');
909: THEN
910:
911: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
912: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','fob_point_code');
913: OE_MSG_PUB.Add;
914:
915: END IF;
916:
917: RETURN FND_API.G_MISS_CHAR;
917: RETURN FND_API.G_MISS_CHAR;
918:
919: WHEN OTHERS THEN
920:
921: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
922: THEN
923: OE_MSG_PUB.Add_Exc_Msg
924: ( G_PKG_NAME
925: , 'Fob_Point'
919: WHEN OTHERS THEN
920:
921: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
922: THEN
923: OE_MSG_PUB.Add_Exc_Msg
924: ( G_PKG_NAME
925: , 'Fob_Point'
926: );
927: END IF;
959: EXCEPTION
960:
961: WHEN NO_DATA_FOUND THEN
962:
963: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
964: THEN
965:
966: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
967: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','freight_terms_code');
964: THEN
965:
966: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
967: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','freight_terms_code');
968: OE_MSG_PUB.Add;
969:
970: END IF;
971:
972: RETURN FND_API.G_MISS_CHAR;
972: RETURN FND_API.G_MISS_CHAR;
973:
974: WHEN OTHERS THEN
975:
976: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
977: THEN
978: OE_MSG_PUB.Add_Exc_Msg
979: ( G_PKG_NAME
980: , 'Freight_Terms'
974: WHEN OTHERS THEN
975:
976: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
977: THEN
978: OE_MSG_PUB.Add_Exc_Msg
979: ( G_PKG_NAME
980: , 'Freight_Terms'
981: );
982: END IF;
1013: EXCEPTION
1014:
1015: WHEN NO_DATA_FOUND THEN
1016:
1017: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1018: THEN
1019:
1020: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
1021: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','intermed_ship_to_contact_id');
1018: THEN
1019:
1020: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
1021: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','intermed_ship_to_contact_id');
1022: OE_MSG_PUB.Add;
1023:
1024: END IF;
1025:
1026: RETURN FND_API.G_MISS_NUM;
1027:
1028:
1029: WHEN OTHERS THEN
1030:
1031: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1032: THEN
1033: OE_MSG_PUB.Add_Exc_Msg
1034: ( G_PKG_NAME
1035: , 'Intermed_Ship_To_Contact'
1029: WHEN OTHERS THEN
1030:
1031: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1032: THEN
1033: OE_MSG_PUB.Add_Exc_Msg
1034: ( G_PKG_NAME
1035: , 'Intermed_Ship_To_Contact'
1036: );
1037: END IF;
1079: EXCEPTION
1080:
1081: WHEN NO_DATA_FOUND THEN
1082:
1083: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1084: THEN
1085:
1086: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
1087: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','intermed_ship_to_org_id');
1084: THEN
1085:
1086: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
1087: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','intermed_ship_to_org_id');
1088: OE_MSG_PUB.Add;
1089:
1090: END IF;
1091:
1092: RETURN FND_API.G_MISS_NUM;
1092: RETURN FND_API.G_MISS_NUM;
1093:
1094: WHEN OTHERS THEN
1095:
1096: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1097: THEN
1098: OE_MSG_PUB.Add_Exc_Msg
1099: ( G_PKG_NAME
1100: , 'Intermed_Ship_To_Org'
1094: WHEN OTHERS THEN
1095:
1096: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1097: THEN
1098: OE_MSG_PUB.Add_Exc_Msg
1099: ( G_PKG_NAME
1100: , 'Intermed_Ship_To_Org'
1101: );
1102: END IF;
1144: EXCEPTION
1145:
1146: WHEN NO_DATA_FOUND THEN
1147:
1148: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1149: THEN
1150:
1151: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
1152: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','invoice_to_contact_id');
1149: THEN
1150:
1151: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
1152: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','invoice_to_contact_id');
1153: OE_MSG_PUB.Add;
1154:
1155: END IF;
1156:
1157: RETURN FND_API.G_MISS_NUM;
1157: RETURN FND_API.G_MISS_NUM;
1158:
1159: WHEN OTHERS THEN
1160:
1161: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1162: THEN
1163: OE_MSG_PUB.Add_Exc_Msg
1164: ( G_PKG_NAME
1165: , 'Invoice_To_Contact'
1159: WHEN OTHERS THEN
1160:
1161: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1162: THEN
1163: OE_MSG_PUB.Add_Exc_Msg
1164: ( G_PKG_NAME
1165: , 'Invoice_To_Contact'
1166: );
1167: END IF;
1309:
1310: IF l_debug_level > 0 THEN
1311: oe_debug_pub.add( 'CUSTOMER RELATION IS NOT ON , BUT THE SOLD_TO_ORG '|| 'AND INVOICE_TO_CUSTOMER ARE NOT SAME' ) ;
1312: END IF;
1313: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN
1314:
1315: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
1316: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','invoice_to_org_id');
1317: OE_MSG_PUB.Add;
1313: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN
1314:
1315: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
1316: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','invoice_to_org_id');
1317: OE_MSG_PUB.Add;
1318:
1319: END IF;
1320:
1321: RETURN FND_API.G_MISS_NUM;
1339:
1340: EXCEPTION
1341:
1342: WHEN NO_DATA_FOUND THEN
1343: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN
1344:
1345: IF l_debug_level > 0 THEN
1346: oe_debug_pub.add( 'CUSTOMER RELATION IS ON , BUT THE '|| 'SOLD_TO_ORG AND INVOICE_TO_CUSTOMER ARE NOT RELATED' ) ;
1347: END IF;
1346: oe_debug_pub.add( 'CUSTOMER RELATION IS ON , BUT THE '|| 'SOLD_TO_ORG AND INVOICE_TO_CUSTOMER ARE NOT RELATED' ) ;
1347: END IF;
1348: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
1349: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','invoice_to_org_id');
1350: OE_MSG_PUB.Add;
1351:
1352: END IF;
1353:
1354: RETURN FND_API.G_MISS_NUM;
1519: IF C2%ISOPEN then
1520: CLOSE C2;
1521: END IF;
1522:
1523: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1524: THEN
1525:
1526: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
1527: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','invoice_to_org_id');
1524: THEN
1525:
1526: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
1527: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','invoice_to_org_id');
1528: OE_MSG_PUB.Add;
1529:
1530: END IF;
1531:
1532: RETURN FND_API.G_MISS_NUM;
1544: IF C2%ISOPEN then
1545: CLOSE C2;
1546: END IF;
1547:
1548: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1549: THEN
1550: OE_MSG_PUB.Add_Exc_Msg
1551: ( G_PKG_NAME
1552: , 'Invoice_To_Org'
1546: END IF;
1547:
1548: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1549: THEN
1550: OE_MSG_PUB.Add_Exc_Msg
1551: ( G_PKG_NAME
1552: , 'Invoice_To_Org'
1553: );
1554: END IF;
1584: EXCEPTION
1585:
1586: WHEN NO_DATA_FOUND THEN
1587:
1588: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1589: THEN
1590:
1591: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
1592: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','invoicing_rule_id');
1589: THEN
1590:
1591: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
1592: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','invoicing_rule_id');
1593: OE_MSG_PUB.Add;
1594:
1595: END IF;
1596:
1597: RETURN FND_API.G_MISS_NUM;
1597: RETURN FND_API.G_MISS_NUM;
1598:
1599: WHEN OTHERS THEN
1600:
1601: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1602: THEN
1603: OE_MSG_PUB.Add_Exc_Msg
1604: ( G_PKG_NAME
1605: , 'Invoicing_Rule'
1599: WHEN OTHERS THEN
1600:
1601: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1602: THEN
1603: OE_MSG_PUB.Add_Exc_Msg
1604: ( G_PKG_NAME
1605: , 'Invoicing_Rule'
1606: );
1607: END IF;
1642: EXCEPTION
1643:
1644: WHEN NO_DATA_FOUND THEN
1645:
1646: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1647: THEN
1648:
1649: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
1650: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','order_source_id');
1647: THEN
1648:
1649: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
1650: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','order_source_id');
1651: OE_MSG_PUB.Add;
1652:
1653: END IF;
1654:
1655: RETURN FND_API.G_MISS_NUM;
1655: RETURN FND_API.G_MISS_NUM;
1656:
1657: WHEN OTHERS THEN
1658:
1659: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1660: THEN
1661: OE_MSG_PUB.Add_Exc_Msg
1662: ( G_PKG_NAME
1663: , 'Order_Source'
1657: WHEN OTHERS THEN
1658:
1659: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1660: THEN
1661: OE_MSG_PUB.Add_Exc_Msg
1662: ( G_PKG_NAME
1663: , 'Order_Source'
1664: );
1665: END IF;
1695: EXCEPTION
1696:
1697: WHEN NO_DATA_FOUND THEN
1698:
1699: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1700: THEN
1701:
1702: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
1703: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','order_type_id');
1700: THEN
1701:
1702: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
1703: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','order_type_id');
1704: OE_MSG_PUB.Add;
1705:
1706: END IF;
1707:
1708: RETURN FND_API.G_MISS_NUM;
1708: RETURN FND_API.G_MISS_NUM;
1709:
1710: WHEN OTHERS THEN
1711:
1712: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1713: THEN
1714: OE_MSG_PUB.Add_Exc_Msg
1715: ( G_PKG_NAME
1716: , 'Order_Type'
1710: WHEN OTHERS THEN
1711:
1712: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1713: THEN
1714: OE_MSG_PUB.Add_Exc_Msg
1715: ( G_PKG_NAME
1716: , 'Order_Type'
1717: );
1718: END IF;
1748: EXCEPTION
1749:
1750: WHEN NO_DATA_FOUND THEN
1751:
1752: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1753: THEN
1754:
1755: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
1756: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','payment_term_id');
1753: THEN
1754:
1755: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
1756: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','payment_term_id');
1757: OE_MSG_PUB.Add;
1758:
1759: END IF;
1760:
1761: RETURN FND_API.G_MISS_NUM;
1761: RETURN FND_API.G_MISS_NUM;
1762:
1763: WHEN OTHERS THEN
1764:
1765: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1766: THEN
1767: OE_MSG_PUB.Add_Exc_Msg
1768: ( G_PKG_NAME
1769: , 'Payment_Term'
1763: WHEN OTHERS THEN
1764:
1765: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1766: THEN
1767: OE_MSG_PUB.Add_Exc_Msg
1768: ( G_PKG_NAME
1769: , 'Payment_Term'
1770: );
1771: END IF;
1802: EXCEPTION
1803:
1804: WHEN NO_DATA_FOUND THEN
1805:
1806: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1807: THEN
1808:
1809: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
1810: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','price_list_id');
1807: THEN
1808:
1809: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
1810: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','price_list_id');
1811: OE_MSG_PUB.Add;
1812:
1813: END IF;
1814:
1815: RETURN FND_API.G_MISS_NUM;
1815: RETURN FND_API.G_MISS_NUM;
1816:
1817: WHEN OTHERS THEN
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: , 'Price_List'
1817: WHEN OTHERS THEN
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: , 'Price_List'
1824: );
1825: END IF;
1857: EXCEPTION
1858:
1859: WHEN NO_DATA_FOUND THEN
1860:
1861: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1862: THEN
1863:
1864: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
1865: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','shipment_priority_code');
1862: THEN
1863:
1864: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
1865: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','shipment_priority_code');
1866: OE_MSG_PUB.Add;
1867:
1868: END IF;
1869:
1870: RETURN FND_API.G_MISS_CHAR;
1870: RETURN FND_API.G_MISS_CHAR;
1871:
1872: WHEN OTHERS THEN
1873:
1874: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1875: THEN
1876: OE_MSG_PUB.Add_Exc_Msg
1877: ( G_PKG_NAME
1878: , 'Shipment_Priority'
1872: WHEN OTHERS THEN
1873:
1874: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1875: THEN
1876: OE_MSG_PUB.Add_Exc_Msg
1877: ( G_PKG_NAME
1878: , 'Shipment_Priority'
1879: );
1880: END IF;
1937: EXCEPTION
1938:
1939: WHEN NO_DATA_FOUND THEN
1940:
1941: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1942: THEN
1943:
1944: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
1945: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ship_from_org_id');
1942: THEN
1943:
1944: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
1945: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ship_from_org_id');
1946: OE_MSG_PUB.Add;
1947:
1948: END IF;
1949:
1950: RETURN FND_API.G_MISS_NUM;
1950: RETURN FND_API.G_MISS_NUM;
1951:
1952: WHEN OTHERS THEN
1953:
1954: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1955: THEN
1956: OE_MSG_PUB.Add_Exc_Msg
1957: ( G_PKG_NAME
1958: , 'Ship_From_Org'
1952: WHEN OTHERS THEN
1953:
1954: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1955: THEN
1956: OE_MSG_PUB.Add_Exc_Msg
1957: ( G_PKG_NAME
1958: , 'Ship_From_Org'
1959: );
1960: END IF;
2002: EXCEPTION
2003:
2004: WHEN NO_DATA_FOUND THEN
2005:
2006: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2007: THEN
2008:
2009: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
2010: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ship_to_contact_id');
2007: THEN
2008:
2009: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
2010: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ship_to_contact_id');
2011: OE_MSG_PUB.Add;
2012:
2013: END IF;
2014:
2015: RETURN FND_API.G_MISS_NUM;
2015: RETURN FND_API.G_MISS_NUM;
2016:
2017: WHEN OTHERS THEN
2018:
2019: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2020: THEN
2021: OE_MSG_PUB.Add_Exc_Msg
2022: ( G_PKG_NAME
2023: , 'Ship_To_Contact'
2017: WHEN OTHERS THEN
2018:
2019: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2020: THEN
2021: OE_MSG_PUB.Add_Exc_Msg
2022: ( G_PKG_NAME
2023: , 'Ship_To_Contact'
2024: );
2025: END IF;
2053: EXCEPTION
2054:
2055: WHEN NO_DATA_FOUND THEN
2056:
2057: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2058: THEN
2059:
2060: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
2061: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','inventory_org_id');
2058: THEN
2059:
2060: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
2061: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','inventory_org_id');
2062: OE_MSG_PUB.Add;
2063:
2064: END IF;
2065:
2066: RETURN FND_API.G_MISS_NUM;
2066: RETURN FND_API.G_MISS_NUM;
2067:
2068: WHEN OTHERS THEN
2069:
2070: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2071: THEN
2072: OE_MSG_PUB.Add_Exc_Msg
2073: ( G_PKG_NAME
2074: , 'inventory_org'
2068: WHEN OTHERS THEN
2069:
2070: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2071: THEN
2072: OE_MSG_PUB.Add_Exc_Msg
2073: ( G_PKG_NAME
2074: , 'inventory_org'
2075: );
2076: END IF;
2220:
2221: IF l_debug_level > 0 THEN
2222: oe_debug_pub.add( 'CUSTOMER RELATION IS NOT ON , BUT THE SOLD_TO_ORG '|| 'AND SHIP_TO_CUSTOMER ARE NOT SAME' ) ;
2223: END IF;
2224: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN
2225:
2226: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
2227: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ship_to_org_id');
2228: OE_MSG_PUB.Add;
2224: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN
2225:
2226: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
2227: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ship_to_org_id');
2228: OE_MSG_PUB.Add;
2229:
2230: END IF;
2231:
2232: RETURN FND_API.G_MISS_NUM;
2249: and ship_to_flag='Y' and status='A';
2250: EXCEPTION
2251:
2252: WHEN NO_DATA_FOUND THEN
2253: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN
2254:
2255: IF l_debug_level > 0 THEN
2256: oe_debug_pub.add( 'CUSTOMER RELATION IS ON , BUT THE '|| 'SOLD_TO_ORG AND SHIP_TO_CUSTOMER ARE NOT RELATED' ) ;
2257: END IF;
2256: oe_debug_pub.add( 'CUSTOMER RELATION IS ON , BUT THE '|| 'SOLD_TO_ORG AND SHIP_TO_CUSTOMER ARE NOT RELATED' ) ;
2257: END IF;
2258: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
2259: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ship_to_org_id');
2260: OE_MSG_PUB.Add;
2261:
2262: END IF;
2263:
2264: RETURN FND_API.G_MISS_NUM;
2408: IF C2%ISOPEN then
2409: CLOSE C2;
2410: END IF;
2411:
2412: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2413: THEN
2414:
2415: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
2416: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ship_to_org_id');
2413: THEN
2414:
2415: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
2416: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ship_to_org_id');
2417: OE_MSG_PUB.Add;
2418:
2419: END IF;
2420:
2421: RETURN FND_API.G_MISS_NUM;
2433: IF C2%ISOPEN then
2434: CLOSE C2;
2435: END IF;
2436:
2437: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2438: THEN
2439: OE_MSG_PUB.Add_Exc_Msg
2440: ( G_PKG_NAME
2441: , 'Ship_To_Org'
2435: END IF;
2436:
2437: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2438: THEN
2439: OE_MSG_PUB.Add_Exc_Msg
2440: ( G_PKG_NAME
2441: , 'Ship_To_Org'
2442: );
2443: END IF;
2477: EXCEPTION
2478:
2479: WHEN NO_DATA_FOUND THEN
2480:
2481: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2482: THEN
2483:
2484: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
2485: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','sold_to_contact_id');
2482: THEN
2483:
2484: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
2485: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','sold_to_contact_id');
2486: OE_MSG_PUB.Add;
2487:
2488: END IF;
2489:
2490: RETURN FND_API.G_MISS_NUM;
2490: RETURN FND_API.G_MISS_NUM;
2491:
2492: WHEN OTHERS THEN
2493:
2494: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2495: THEN
2496: OE_MSG_PUB.Add_Exc_Msg
2497: ( G_PKG_NAME
2498: , 'Sold_To_Contact'
2492: WHEN OTHERS THEN
2493:
2494: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2495: THEN
2496: OE_MSG_PUB.Add_Exc_Msg
2497: ( G_PKG_NAME
2498: , 'Sold_To_Contact'
2499: );
2500: END IF;
2577: EXCEPTION
2578:
2579: WHEN NO_DATA_FOUND THEN
2580:
2581: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2582: THEN
2583:
2584: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
2585: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Site_customer'||p_type);
2582: THEN
2583:
2584: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
2585: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Site_customer'||p_type);
2586: OE_MSG_PUB.Add;
2587:
2588: END IF;
2589:
2590: RETURN FND_API.G_MISS_NUM;
2590: RETURN FND_API.G_MISS_NUM;
2591:
2592: WHEN OTHERS THEN
2593:
2594: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2595: THEN
2596: OE_MSG_PUB.Add_Exc_Msg
2597: ( G_PKG_NAME
2598: , 'Site_customer'||p_type
2592: WHEN OTHERS THEN
2593:
2594: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2595: THEN
2596: OE_MSG_PUB.Add_Exc_Msg
2597: ( G_PKG_NAME
2598: , 'Site_customer'||p_type
2599: );
2600: END IF;
2649: EXCEPTION
2650:
2651: WHEN NO_DATA_FOUND THEN
2652:
2653: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2654: THEN
2655:
2656: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
2657: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','sold_to_org_id');
2654: THEN
2655:
2656: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
2657: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','sold_to_org_id');
2658: OE_MSG_PUB.Add;
2659:
2660: END IF;
2661:
2662: RETURN FND_API.G_MISS_NUM;
2661:
2662: RETURN FND_API.G_MISS_NUM;
2663:
2664: WHEN TOO_MANY_ROWS THEN
2665: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2666: THEN
2667:
2668: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
2669: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','sold_to_org_id');
2666: THEN
2667:
2668: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
2669: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','sold_to_org_id');
2670: OE_MSG_PUB.Add;
2671:
2672: END IF;
2673:
2674: RETURN FND_API.G_MISS_NUM;
2673:
2674: RETURN FND_API.G_MISS_NUM;
2675: WHEN OTHERS THEN
2676:
2677: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2678: THEN
2679: OE_MSG_PUB.Add_Exc_Msg
2680: ( G_PKG_NAME
2681: , 'Sold_To_Org'
2675: WHEN OTHERS THEN
2676:
2677: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2678: THEN
2679: OE_MSG_PUB.Add_Exc_Msg
2680: ( G_PKG_NAME
2681: , 'Sold_To_Org'
2682: );
2683: END IF;
2716: EXCEPTION
2717:
2718: WHEN NO_DATA_FOUND THEN
2719:
2720: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2721: THEN
2722:
2723: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
2724: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','tax_exempt_flag');
2721: THEN
2722:
2723: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
2724: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','tax_exempt_flag');
2725: OE_MSG_PUB.Add;
2726:
2727: END IF;
2728:
2729: RETURN FND_API.G_MISS_CHAR;
2729: RETURN FND_API.G_MISS_CHAR;
2730:
2731: WHEN OTHERS THEN
2732:
2733: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2734: THEN
2735: OE_MSG_PUB.Add_Exc_Msg
2736: ( G_PKG_NAME
2737: , 'Tax_Exempt'
2731: WHEN OTHERS THEN
2732:
2733: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2734: THEN
2735: OE_MSG_PUB.Add_Exc_Msg
2736: ( G_PKG_NAME
2737: , 'Tax_Exempt'
2738: );
2739: END IF;
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','tax_exempt_reason_code');
2777: THEN
2778:
2779: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
2780: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','tax_exempt_reason_code');
2781: OE_MSG_PUB.Add;
2782:
2783: END IF;
2784:
2785: RETURN FND_API.G_MISS_CHAR;
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: , 'Tax_Exempt_Reason'
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: , 'Tax_Exempt_Reason'
2794: );
2795: END IF;
2827: EXCEPTION
2828:
2829: WHEN NO_DATA_FOUND THEN
2830:
2831: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2832: THEN
2833:
2834: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
2835: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','tax_point_code');
2832: THEN
2833:
2834: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
2835: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','tax_point_code');
2836: OE_MSG_PUB.Add;
2837:
2838: END IF;
2839:
2840: RETURN FND_API.G_MISS_CHAR;
2840: RETURN FND_API.G_MISS_CHAR;
2841:
2842: WHEN OTHERS THEN
2843:
2844: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2845: THEN
2846: OE_MSG_PUB.Add_Exc_Msg
2847: ( G_PKG_NAME
2848: , 'Tax_Point'
2842: WHEN OTHERS THEN
2843:
2844: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2845: THEN
2846: OE_MSG_PUB.Add_Exc_Msg
2847: ( G_PKG_NAME
2848: , 'Tax_Point'
2849: );
2850: END IF;
2880: EXCEPTION
2881:
2882: WHEN NO_DATA_FOUND THEN
2883:
2884: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2885: THEN
2886:
2887: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
2888: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','discount_id');
2885: THEN
2886:
2887: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
2888: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','discount_id');
2889: OE_MSG_PUB.Add;
2890:
2891: END IF;
2892:
2893: RETURN FND_API.G_MISS_NUM;
2893: RETURN FND_API.G_MISS_NUM;
2894:
2895: WHEN OTHERS THEN
2896:
2897: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2898: THEN
2899: OE_MSG_PUB.Add_Exc_Msg
2900: ( G_PKG_NAME
2901: , 'Discount'
2895: WHEN OTHERS THEN
2896:
2897: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2898: THEN
2899: OE_MSG_PUB.Add_Exc_Msg
2900: ( G_PKG_NAME
2901: , 'Discount'
2902: );
2903: END IF;
2931: EXCEPTION
2932:
2933: WHEN NO_DATA_FOUND THEN
2934:
2935: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2936: THEN
2937:
2938: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
2939: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','sales_credit_type');
2936: THEN
2937:
2938: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
2939: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','sales_credit_type');
2940: OE_MSG_PUB.Add;
2941:
2942: END IF;
2943:
2944: RETURN FND_API.G_MISS_NUM;
2944: RETURN FND_API.G_MISS_NUM;
2945:
2946: WHEN OTHERS THEN
2947:
2948: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2949: THEN
2950: OE_MSG_PUB.Add_Exc_Msg
2951: ( G_PKG_NAME
2952: , 'sales_credit_type'
2946: WHEN OTHERS THEN
2947:
2948: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2949: THEN
2950: OE_MSG_PUB.Add_Exc_Msg
2951: ( G_PKG_NAME
2952: , 'sales_credit_type'
2953: );
2954: END IF;
2997: EXCEPTION
2998: WHEN TOO_MANY_ROWS THEN
2999: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
3000: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','salesrep_id');
3001: OE_MSG_PUB.Add;
3002: oe_debug_pub.add('Multiple active salesrep with same name');
3003: RETURN FND_API.G_MISS_NUM;
3004:
3005: END;
3005: END;
3006:
3007: WHEN NO_DATA_FOUND THEN
3008:
3009: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
3010: THEN
3011:
3012: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
3013: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','salesrep_id');
3010: THEN
3011:
3012: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
3013: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','salesrep_id');
3014: OE_MSG_PUB.Add;
3015: oe_debug_pub.add(' Value to ID conversion no data found on salesrep_id');
3016:
3017: END IF;
3018:
3019: RETURN FND_API.G_MISS_NUM;
3020:
3021: WHEN OTHERS THEN
3022:
3023: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3024: THEN
3025: OE_MSG_PUB.Add_Exc_Msg
3026: ( G_PKG_NAME
3027: , 'Salesrep'
3021: WHEN OTHERS THEN
3022:
3023: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3024: THEN
3025: OE_MSG_PUB.Add_Exc_Msg
3026: ( G_PKG_NAME
3027: , 'Salesrep'
3028: );
3029: END IF;
3061: EXCEPTION
3062:
3063: WHEN NO_DATA_FOUND THEN
3064:
3065: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
3066: THEN
3067:
3068: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
3069: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','demand_bucket_type_code');
3066: THEN
3067:
3068: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
3069: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','demand_bucket_type_code');
3070: OE_MSG_PUB.Add;
3071:
3072: END IF;
3073:
3074: RETURN FND_API.G_MISS_CHAR;
3074: RETURN FND_API.G_MISS_CHAR;
3075:
3076: WHEN OTHERS THEN
3077:
3078: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3079: THEN
3080: OE_MSG_PUB.Add_Exc_Msg
3081: ( G_PKG_NAME
3082: , 'Demand_Bucket_Type'
3076: WHEN OTHERS THEN
3077:
3078: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3079: THEN
3080: OE_MSG_PUB.Add_Exc_Msg
3081: ( G_PKG_NAME
3082: , 'Demand_Bucket_Type'
3083: );
3084: END IF;
3114: EXCEPTION
3115:
3116: WHEN NO_DATA_FOUND THEN
3117:
3118: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
3119: THEN
3120:
3121: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
3122: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','inventory_item_id');
3119: THEN
3120:
3121: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
3122: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','inventory_item_id');
3123: OE_MSG_PUB.Add;
3124:
3125: END IF;
3126:
3127: RETURN FND_API.G_MISS_NUM;
3127: RETURN FND_API.G_MISS_NUM;
3128:
3129: WHEN OTHERS THEN
3130:
3131: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3132: THEN
3133: OE_MSG_PUB.Add_Exc_Msg
3134: ( G_PKG_NAME
3135: , 'Inventory_Item'
3129: WHEN OTHERS THEN
3130:
3131: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3132: THEN
3133: OE_MSG_PUB.Add_Exc_Msg
3134: ( G_PKG_NAME
3135: , 'Inventory_Item'
3136: );
3137: END IF;
3167: EXCEPTION
3168:
3169: WHEN NO_DATA_FOUND THEN
3170:
3171: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
3172: THEN
3173:
3174: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
3175: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','item_type_code');
3172: THEN
3173:
3174: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
3175: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','item_type_code');
3176: OE_MSG_PUB.Add;
3177:
3178: END IF;
3179:
3180: RETURN FND_API.G_MISS_CHAR;
3180: RETURN FND_API.G_MISS_CHAR;
3181:
3182: WHEN OTHERS THEN
3183:
3184: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3185: THEN
3186: OE_MSG_PUB.Add_Exc_Msg
3187: ( G_PKG_NAME
3188: , 'Item_Type'
3182: WHEN OTHERS THEN
3183:
3184: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3185: THEN
3186: OE_MSG_PUB.Add_Exc_Msg
3187: ( G_PKG_NAME
3188: , 'Item_Type'
3189: );
3190: END IF;
3220: EXCEPTION
3221:
3222: WHEN NO_DATA_FOUND THEN
3223:
3224: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
3225: THEN
3226:
3227: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
3228: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','line_type_id');
3225: THEN
3226:
3227: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
3228: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','line_type_id');
3229: OE_MSG_PUB.Add;
3230:
3231: END IF;
3232:
3233: RETURN FND_API.G_MISS_NUM;
3233: RETURN FND_API.G_MISS_NUM;
3234:
3235: WHEN OTHERS THEN
3236:
3237: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3238: THEN
3239: OE_MSG_PUB.Add_Exc_Msg
3240: ( G_PKG_NAME
3241: , 'Line_Type'
3235: WHEN OTHERS THEN
3236:
3237: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3238: THEN
3239: OE_MSG_PUB.Add_Exc_Msg
3240: ( G_PKG_NAME
3241: , 'Line_Type'
3242: );
3243: END IF;
3273: EXCEPTION
3274:
3275: WHEN NO_DATA_FOUND THEN
3276:
3277: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
3278: THEN
3279:
3280: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
3281: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','project_id');
3278: THEN
3279:
3280: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
3281: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','project_id');
3282: OE_MSG_PUB.Add;
3283:
3284: END IF;
3285:
3286: RETURN FND_API.G_MISS_NUM;
3286: RETURN FND_API.G_MISS_NUM;
3287:
3288: WHEN OTHERS THEN
3289:
3290: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3291: THEN
3292: OE_MSG_PUB.Add_Exc_Msg
3293: ( G_PKG_NAME
3294: , 'Project'
3288: WHEN OTHERS THEN
3289:
3290: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3291: THEN
3292: OE_MSG_PUB.Add_Exc_Msg
3293: ( G_PKG_NAME
3294: , 'Project'
3295: );
3296: END IF;
3326: EXCEPTION
3327:
3328: WHEN NO_DATA_FOUND THEN
3329:
3330: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
3331: THEN
3332:
3333: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
3334: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','rla_schedule_type_code');
3331: THEN
3332:
3333: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
3334: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','rla_schedule_type_code');
3335: OE_MSG_PUB.Add;
3336:
3337: END IF;
3338:
3339: RETURN FND_API.G_MISS_CHAR;
3339: RETURN FND_API.G_MISS_CHAR;
3340:
3341: WHEN OTHERS THEN
3342:
3343: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3344: THEN
3345: OE_MSG_PUB.Add_Exc_Msg
3346: ( G_PKG_NAME
3347: , 'Rla_Schedule_Type'
3341: WHEN OTHERS THEN
3342:
3343: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3344: THEN
3345: OE_MSG_PUB.Add_Exc_Msg
3346: ( G_PKG_NAME
3347: , 'Rla_Schedule_Type'
3348: );
3349: END IF;
3379: EXCEPTION
3380:
3381: WHEN NO_DATA_FOUND THEN
3382:
3383: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
3384: THEN
3385:
3386: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
3387: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','task_id');
3384: THEN
3385:
3386: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
3387: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','task_id');
3388: OE_MSG_PUB.Add;
3389:
3390: END IF;
3391:
3392: RETURN FND_API.G_MISS_NUM;
3392: RETURN FND_API.G_MISS_NUM;
3393:
3394: WHEN OTHERS THEN
3395:
3396: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3397: THEN
3398: OE_MSG_PUB.Add_Exc_Msg
3399: ( G_PKG_NAME
3400: , 'Task'
3394: WHEN OTHERS THEN
3395:
3396: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3397: THEN
3398: OE_MSG_PUB.Add_Exc_Msg
3399: ( G_PKG_NAME
3400: , 'Task'
3401: );
3402: END IF;
3430: EXCEPTION
3431:
3432: WHEN NO_DATA_FOUND THEN
3433:
3434: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
3435: THEN
3436:
3437: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
3438: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','over_ship_reason_code');
3435: THEN
3436:
3437: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
3438: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','over_ship_reason_code');
3439: OE_MSG_PUB.Add;
3440:
3441: END IF;
3442:
3443: RETURN FND_API.G_MISS_CHAR;
3443: RETURN FND_API.G_MISS_CHAR;
3444:
3445: WHEN OTHERS THEN
3446:
3447: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3448: THEN
3449: OE_MSG_PUB.Add_Exc_Msg
3450: ( G_PKG_NAME
3451: , 'Over_Ship_reason'
3445: WHEN OTHERS THEN
3446:
3447: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3448: THEN
3449: OE_MSG_PUB.Add_Exc_Msg
3450: ( G_PKG_NAME
3451: , 'Over_Ship_reason'
3452: );
3453: END IF;
3483: EXCEPTION
3484:
3485: WHEN NO_DATA_FOUND THEN
3486:
3487: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
3488: THEN
3489:
3490: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
3491: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','return_reason_code');
3488: THEN
3489:
3490: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
3491: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','return_reason_code');
3492: OE_MSG_PUB.Add;
3493:
3494: END IF;
3495:
3496: RETURN FND_API.G_MISS_CHAR;
3496: RETURN FND_API.G_MISS_CHAR;
3497:
3498: WHEN OTHERS THEN
3499:
3500: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3501: THEN
3502: OE_MSG_PUB.Add_Exc_Msg
3503: ( G_PKG_NAME
3504: , 'Return_Reason'
3498: WHEN OTHERS THEN
3499:
3500: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3501: THEN
3502: OE_MSG_PUB.Add_Exc_Msg
3503: ( G_PKG_NAME
3504: , 'Return_Reason'
3505: );
3506: END IF;
3534: EXCEPTION
3535:
3536: WHEN NO_DATA_FOUND THEN
3537:
3538: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
3539: THEN
3540:
3541: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
3542: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','veh_cus_item_cum_Key_id');
3539: THEN
3540:
3541: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
3542: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','veh_cus_item_cum_Key_id');
3543: OE_MSG_PUB.Add;
3544:
3545: END IF;
3546:
3547: RETURN FND_API.G_MISS_NUM;
3547: RETURN FND_API.G_MISS_NUM;
3548:
3549: WHEN OTHERS THEN
3550:
3551: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3552: THEN
3553: OE_MSG_PUB.Add_Exc_Msg
3554: ( G_PKG_NAME
3555: , 'Veh_Cus_Item_cum_Key'
3549: WHEN OTHERS THEN
3550:
3551: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3552: THEN
3553: OE_MSG_PUB.Add_Exc_Msg
3554: ( G_PKG_NAME
3555: , 'Veh_Cus_Item_cum_Key'
3556: );
3557: END IF;
3624: EXCEPTION
3625:
3626: WHEN NO_DATA_FOUND THEN
3627:
3628: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
3629: THEN
3630:
3631: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
3632: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','payment_type_code');
3629: THEN
3630:
3631: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
3632: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','payment_type_code');
3633: OE_MSG_PUB.Add;
3634:
3635: END IF;
3636:
3637: RETURN FND_API.G_MISS_CHAR;
3637: RETURN FND_API.G_MISS_CHAR;
3638:
3639: WHEN OTHERS THEN
3640:
3641: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3642: THEN
3643: OE_MSG_PUB.Add_Exc_Msg
3644: ( G_PKG_NAME
3645: , 'Payment_Type'
3639: WHEN OTHERS THEN
3640:
3641: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3642: THEN
3643: OE_MSG_PUB.Add_Exc_Msg
3644: ( G_PKG_NAME
3645: , 'Payment_Type'
3646: );
3647: END IF;
3678: EXCEPTION
3679:
3680: WHEN NO_DATA_FOUND THEN
3681:
3682: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
3683: THEN
3684:
3685: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
3686: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','credit_card_code');
3683: THEN
3684:
3685: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
3686: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','credit_card_code');
3687: OE_MSG_PUB.Add;
3688:
3689: END IF;
3690:
3691: RETURN FND_API.G_MISS_CHAR;
3691: RETURN FND_API.G_MISS_CHAR;
3692:
3693: WHEN OTHERS THEN
3694:
3695: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3696: THEN
3697: OE_MSG_PUB.Add_Exc_Msg
3698: ( G_PKG_NAME
3699: , 'Credit_Card'
3693: WHEN OTHERS THEN
3694:
3695: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3696: THEN
3697: OE_MSG_PUB.Add_Exc_Msg
3698: ( G_PKG_NAME
3699: , 'Credit_Card'
3700: );
3701: END IF;
3733: EXCEPTION
3734:
3735: WHEN NO_DATA_FOUND THEN
3736:
3737: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
3738: THEN
3739:
3740: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
3741: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','commitment_id');
3738: THEN
3739:
3740: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
3741: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','commitment_id');
3742: OE_MSG_PUB.Add;
3743:
3744: END IF;
3745:
3746: RETURN FND_API.G_MISS_NUM;
3746: RETURN FND_API.G_MISS_NUM;
3747:
3748: WHEN OTHERS THEN
3749:
3750: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3751: THEN
3752: OE_MSG_PUB.Add_Exc_Msg
3753: ( G_PKG_NAME
3754: , 'Veh_Cus_Item_cum_Key'
3748: WHEN OTHERS THEN
3749:
3750: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3751: THEN
3752: OE_MSG_PUB.Add_Exc_Msg
3753: ( G_PKG_NAME
3754: , 'Veh_Cus_Item_cum_Key'
3755: );
3756: END IF;
3787: EXCEPTION
3788:
3789: WHEN NO_DATA_FOUND THEN
3790:
3791: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
3792: THEN
3793:
3794: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
3795: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','currency_code');
3792: THEN
3793:
3794: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
3795: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','currency_code');
3796: OE_MSG_PUB.Add;
3797:
3798: END IF;
3799:
3800: RETURN FND_API.G_MISS_CHAR;
3800: RETURN FND_API.G_MISS_CHAR;
3801:
3802: WHEN OTHERS THEN
3803:
3804: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3805: THEN
3806: OE_MSG_PUB.Add_Exc_Msg
3807: ( G_PKG_NAME
3808: , 'Currency'
3802: WHEN OTHERS THEN
3803:
3804: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3805: THEN
3806: OE_MSG_PUB.Add_Exc_Msg
3807: ( G_PKG_NAME
3808: , 'Currency'
3809: );
3810: END IF;
3841: EXCEPTION
3842:
3843: WHEN NO_DATA_FOUND THEN
3844:
3845: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
3846: THEN
3847:
3848: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
3849: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Agreement_Contact_Id');
3846: THEN
3847:
3848: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
3849: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Agreement_Contact_Id');
3850: OE_MSG_PUB.Add;
3851:
3852: END IF;
3853:
3854: RETURN FND_API.G_MISS_CHAR;
3854: RETURN FND_API.G_MISS_CHAR;
3855:
3856: WHEN OTHERS THEN
3857:
3858: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3859: THEN
3860: OE_MSG_PUB.Add_Exc_Msg
3861: ( G_PKG_NAME
3862: , 'Agreement_Contact'
3856: WHEN OTHERS THEN
3857:
3858: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3859: THEN
3860: OE_MSG_PUB.Add_Exc_Msg
3861: ( G_PKG_NAME
3862: , 'Agreement_Contact'
3863: );
3864: END IF;
3894: EXCEPTION
3895:
3896: WHEN NO_DATA_FOUND THEN
3897:
3898: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
3899: THEN
3900:
3901: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
3902: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Agreement_Type_Code');
3899: THEN
3900:
3901: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
3902: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Agreement_Type_Code');
3903: OE_MSG_PUB.Add;
3904:
3905: END IF;
3906:
3907: RETURN FND_API.G_MISS_CHAR;
3907: RETURN FND_API.G_MISS_CHAR;
3908:
3909: WHEN OTHERS THEN
3910:
3911: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3912: THEN
3913: OE_MSG_PUB.Add_Exc_Msg
3914: ( G_PKG_NAME
3915: , 'Agreement_Type'
3909: WHEN OTHERS THEN
3910:
3911: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3912: THEN
3913: OE_MSG_PUB.Add_Exc_Msg
3914: ( G_PKG_NAME
3915: , 'Agreement_Type'
3916: );
3917: END IF;
3947: EXCEPTION
3948:
3949: WHEN NO_DATA_FOUND THEN
3950:
3951: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
3952: THEN
3953:
3954: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
3955: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Customer_Id');
3952: THEN
3953:
3954: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
3955: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Customer_Id');
3956: OE_MSG_PUB.Add;
3957:
3958: END IF;
3959:
3960: RETURN FND_API.G_MISS_CHAR;
3960: RETURN FND_API.G_MISS_CHAR;
3961:
3962: WHEN OTHERS THEN
3963:
3964: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3965: THEN
3966: OE_MSG_PUB.Add_Exc_Msg
3967: ( G_PKG_NAME
3968: , 'Customer'
3962: WHEN OTHERS THEN
3963:
3964: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3965: THEN
3966: OE_MSG_PUB.Add_Exc_Msg
3967: ( G_PKG_NAME
3968: , 'Customer'
3969: );
3970: END IF;
4000: EXCEPTION
4001:
4002: WHEN NO_DATA_FOUND THEN
4003:
4004: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4005: THEN
4006:
4007: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
4008: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Invoice_Contact_Id');
4005: THEN
4006:
4007: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
4008: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Invoice_Contact_Id');
4009: OE_MSG_PUB.Add;
4010:
4011: END IF;
4012:
4013: RETURN FND_API.G_MISS_CHAR;
4013: RETURN FND_API.G_MISS_CHAR;
4014:
4015: WHEN OTHERS THEN
4016:
4017: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4018: THEN
4019: OE_MSG_PUB.Add_Exc_Msg
4020: ( G_PKG_NAME
4021: , 'Invoice_Contact'
4015: WHEN OTHERS THEN
4016:
4017: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4018: THEN
4019: OE_MSG_PUB.Add_Exc_Msg
4020: ( G_PKG_NAME
4021: , 'Invoice_Contact'
4022: );
4023: END IF;
4053: EXCEPTION
4054:
4055: WHEN NO_DATA_FOUND THEN
4056:
4057: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4058: THEN
4059:
4060: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
4061: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Invoice_To_Site_Use_Id');
4058: THEN
4059:
4060: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
4061: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Invoice_To_Site_Use_Id');
4062: OE_MSG_PUB.Add;
4063:
4064: END IF;
4065:
4066: RETURN FND_API.G_MISS_CHAR;
4066: RETURN FND_API.G_MISS_CHAR;
4067:
4068: WHEN OTHERS THEN
4069:
4070: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4071: THEN
4072: OE_MSG_PUB.Add_Exc_Msg
4073: ( G_PKG_NAME
4074: , 'Invoice_To_Site_Use'
4068: WHEN OTHERS THEN
4069:
4070: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4071: THEN
4072: OE_MSG_PUB.Add_Exc_Msg
4073: ( G_PKG_NAME
4074: , 'Invoice_To_Site_Use'
4075: );
4076: END IF;
4106: EXCEPTION
4107:
4108: WHEN NO_DATA_FOUND THEN
4109:
4110: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4111: THEN
4112:
4113: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
4114: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Override_Arule_Flag');
4111: THEN
4112:
4113: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
4114: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Override_Arule_Flag');
4115: OE_MSG_PUB.Add;
4116:
4117: END IF;
4118:
4119: RETURN FND_API.G_MISS_CHAR;
4119: RETURN FND_API.G_MISS_CHAR;
4120:
4121: WHEN OTHERS THEN
4122:
4123: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4124: THEN
4125: OE_MSG_PUB.Add_Exc_Msg
4126: ( G_PKG_NAME
4127: , 'Override_Arule'
4121: WHEN OTHERS THEN
4122:
4123: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4124: THEN
4125: OE_MSG_PUB.Add_Exc_Msg
4126: ( G_PKG_NAME
4127: , 'Override_Arule'
4128: );
4129: END IF;
4159: EXCEPTION
4160:
4161: WHEN NO_DATA_FOUND THEN
4162:
4163: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4164: THEN
4165:
4166: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
4167: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Override_Irule_Flag');
4164: THEN
4165:
4166: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
4167: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Override_Irule_Flag');
4168: OE_MSG_PUB.Add;
4169:
4170: END IF;
4171:
4172: RETURN FND_API.G_MISS_CHAR;
4172: RETURN FND_API.G_MISS_CHAR;
4173:
4174: WHEN OTHERS THEN
4175:
4176: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4177: THEN
4178: OE_MSG_PUB.Add_Exc_Msg
4179: ( G_PKG_NAME
4180: , 'Override_Irule'
4174: WHEN OTHERS THEN
4175:
4176: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4177: THEN
4178: OE_MSG_PUB.Add_Exc_Msg
4179: ( G_PKG_NAME
4180: , 'Override_Irule'
4181: );
4182: END IF;
4212: EXCEPTION
4213:
4214: WHEN NO_DATA_FOUND THEN
4215:
4216: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4217: THEN
4218:
4219: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
4220: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Revision_Reason_Code');
4217: THEN
4218:
4219: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
4220: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Revision_Reason_Code');
4221: OE_MSG_PUB.Add;
4222:
4223: END IF;
4224:
4225: RETURN FND_API.G_MISS_CHAR;
4225: RETURN FND_API.G_MISS_CHAR;
4226:
4227: WHEN OTHERS THEN
4228:
4229: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4230: THEN
4231: OE_MSG_PUB.Add_Exc_Msg
4232: ( G_PKG_NAME
4233: , 'Revision_Reason'
4227: WHEN OTHERS THEN
4228:
4229: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4230: THEN
4231: OE_MSG_PUB.Add_Exc_Msg
4232: ( G_PKG_NAME
4233: , 'Revision_Reason'
4234: );
4235: END IF;
4267: EXCEPTION
4268:
4269: WHEN NO_DATA_FOUND THEN
4270:
4271: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4272: THEN
4273:
4274: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
4275: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Ship_Method_Code');
4272: THEN
4273:
4274: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
4275: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Ship_Method_Code');
4276: OE_MSG_PUB.Add;
4277:
4278: END IF;
4279:
4280: RETURN FND_API.G_MISS_CHAR;
4280: RETURN FND_API.G_MISS_CHAR;
4281:
4282: WHEN OTHERS THEN
4283:
4284: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4285: THEN
4286: OE_MSG_PUB.Add_Exc_Msg
4287: ( G_PKG_NAME
4288: , 'Ship_Method'
4282: WHEN OTHERS THEN
4283:
4284: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4285: THEN
4286: OE_MSG_PUB.Add_Exc_Msg
4287: ( G_PKG_NAME
4288: , 'Ship_Method'
4289: );
4290: END IF;
4320: EXCEPTION
4321:
4322: WHEN NO_DATA_FOUND THEN
4323:
4324: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4325: THEN
4326:
4327: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
4328: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Term_Id');
4325: THEN
4326:
4327: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
4328: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Term_Id');
4329: OE_MSG_PUB.Add;
4330:
4331: END IF;
4332:
4333: RETURN FND_API.G_MISS_CHAR;
4333: RETURN FND_API.G_MISS_CHAR;
4334:
4335: WHEN OTHERS THEN
4336:
4337: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4338: THEN
4339: OE_MSG_PUB.Add_Exc_Msg
4340: ( G_PKG_NAME
4341: , 'Term'
4335: WHEN OTHERS THEN
4336:
4337: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4338: THEN
4339: OE_MSG_PUB.Add_Exc_Msg
4340: ( G_PKG_NAME
4341: , 'Term'
4342: );
4343: END IF;
4373: EXCEPTION
4374:
4375: WHEN NO_DATA_FOUND THEN
4376:
4377: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4378: THEN
4379:
4380: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
4381: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','secondary_price_list_id');
4378: THEN
4379:
4380: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
4381: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','secondary_price_list_id');
4382: OE_MSG_PUB.Add;
4383:
4384: END IF;
4385:
4386: RETURN FND_API.G_MISS_NUM;
4386: RETURN FND_API.G_MISS_NUM;
4387:
4388: WHEN OTHERS THEN
4389:
4390: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4391: THEN
4392: OE_MSG_PUB.Add_Exc_Msg
4393: ( G_PKG_NAME
4394: , 'Secondary_Price_List'
4388: WHEN OTHERS THEN
4389:
4390: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4391: THEN
4392: OE_MSG_PUB.Add_Exc_Msg
4393: ( G_PKG_NAME
4394: , 'Secondary_Price_List'
4395: );
4396: END IF;
4426: EXCEPTION
4427:
4428: WHEN NO_DATA_FOUND THEN
4429:
4430: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4431: THEN
4432:
4433: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
4434: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','terms_id');
4431: THEN
4432:
4433: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
4434: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','terms_id');
4435: OE_MSG_PUB.Add;
4436:
4437: END IF;
4438:
4439: RETURN FND_API.G_MISS_NUM;
4439: RETURN FND_API.G_MISS_NUM;
4440:
4441: WHEN OTHERS THEN
4442:
4443: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4444: THEN
4445: OE_MSG_PUB.Add_Exc_Msg
4446: ( G_PKG_NAME
4447: , 'Terms'
4441: WHEN OTHERS THEN
4442:
4443: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4444: THEN
4445: OE_MSG_PUB.Add_Exc_Msg
4446: ( G_PKG_NAME
4447: , 'Terms'
4448: );
4449: END IF;
4479: EXCEPTION
4480:
4481: WHEN NO_DATA_FOUND THEN
4482:
4483: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4484: THEN
4485:
4486: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
4487: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','automatic_discount_flag');
4484: THEN
4485:
4486: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
4487: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','automatic_discount_flag');
4488: OE_MSG_PUB.Add;
4489:
4490: END IF;
4491:
4492: RETURN FND_API.G_MISS_CHAR;
4492: RETURN FND_API.G_MISS_CHAR;
4493:
4494: WHEN OTHERS THEN
4495:
4496: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4497: THEN
4498: OE_MSG_PUB.Add_Exc_Msg
4499: ( G_PKG_NAME
4500: , 'Automatic_Discount'
4494: WHEN OTHERS THEN
4495:
4496: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4497: THEN
4498: OE_MSG_PUB.Add_Exc_Msg
4499: ( G_PKG_NAME
4500: , 'Automatic_Discount'
4501: );
4502: END IF;
4532: EXCEPTION
4533:
4534: WHEN NO_DATA_FOUND THEN
4535:
4536: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4537: THEN
4538:
4539: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
4540: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','discount_lines_flag');
4537: THEN
4538:
4539: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
4540: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','discount_lines_flag');
4541: OE_MSG_PUB.Add;
4542:
4543: END IF;
4544:
4545: RETURN FND_API.G_MISS_CHAR;
4545: RETURN FND_API.G_MISS_CHAR;
4546:
4547: WHEN OTHERS THEN
4548:
4549: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4550: THEN
4551: OE_MSG_PUB.Add_Exc_Msg
4552: ( G_PKG_NAME
4553: , 'Discount_Lines'
4547: WHEN OTHERS THEN
4548:
4549: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4550: THEN
4551: OE_MSG_PUB.Add_Exc_Msg
4552: ( G_PKG_NAME
4553: , 'Discount_Lines'
4554: );
4555: END IF;
4585: EXCEPTION
4586:
4587: WHEN NO_DATA_FOUND THEN
4588:
4589: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4590: THEN
4591:
4592: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
4593: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','discount_type_code');
4590: THEN
4591:
4592: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
4593: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','discount_type_code');
4594: OE_MSG_PUB.Add;
4595:
4596: END IF;
4597:
4598: RETURN FND_API.G_MISS_CHAR;
4598: RETURN FND_API.G_MISS_CHAR;
4599:
4600: WHEN OTHERS THEN
4601:
4602: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4603: THEN
4604: OE_MSG_PUB.Add_Exc_Msg
4605: ( G_PKG_NAME
4606: , 'Discount_Type'
4600: WHEN OTHERS THEN
4601:
4602: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4603: THEN
4604: OE_MSG_PUB.Add_Exc_Msg
4605: ( G_PKG_NAME
4606: , 'Discount_Type'
4607: );
4608: END IF;
4638: EXCEPTION
4639:
4640: WHEN NO_DATA_FOUND THEN
4641:
4642: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4643: THEN
4644:
4645: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
4646: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','manual_discount_flag');
4643: THEN
4644:
4645: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
4646: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','manual_discount_flag');
4647: OE_MSG_PUB.Add;
4648:
4649: END IF;
4650:
4651: RETURN FND_API.G_MISS_CHAR;
4651: RETURN FND_API.G_MISS_CHAR;
4652:
4653: WHEN OTHERS THEN
4654:
4655: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4656: THEN
4657: OE_MSG_PUB.Add_Exc_Msg
4658: ( G_PKG_NAME
4659: , 'Manual_Discount'
4653: WHEN OTHERS THEN
4654:
4655: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4656: THEN
4657: OE_MSG_PUB.Add_Exc_Msg
4658: ( G_PKG_NAME
4659: , 'Manual_Discount'
4660: );
4661: END IF;
4691: EXCEPTION
4692:
4693: WHEN NO_DATA_FOUND THEN
4694:
4695: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4696: THEN
4697:
4698: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
4699: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','override_allowed_flag');
4696: THEN
4697:
4698: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
4699: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','override_allowed_flag');
4700: OE_MSG_PUB.Add;
4701:
4702: END IF;
4703:
4704: RETURN FND_API.G_MISS_CHAR;
4704: RETURN FND_API.G_MISS_CHAR;
4705:
4706: WHEN OTHERS THEN
4707:
4708: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4709: THEN
4710: OE_MSG_PUB.Add_Exc_Msg
4711: ( G_PKG_NAME
4712: , 'Override_Allowed'
4706: WHEN OTHERS THEN
4707:
4708: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4709: THEN
4710: OE_MSG_PUB.Add_Exc_Msg
4711: ( G_PKG_NAME
4712: , 'Override_Allowed'
4713: );
4714: END IF;
4744: EXCEPTION
4745:
4746: WHEN NO_DATA_FOUND THEN
4747:
4748: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4749: THEN
4750:
4751: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
4752: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','prorate_flag');
4749: THEN
4750:
4751: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
4752: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','prorate_flag');
4753: OE_MSG_PUB.Add;
4754:
4755: END IF;
4756:
4757: RETURN FND_API.G_MISS_CHAR;
4757: RETURN FND_API.G_MISS_CHAR;
4758:
4759: WHEN OTHERS THEN
4760:
4761: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4762: THEN
4763: OE_MSG_PUB.Add_Exc_Msg
4764: ( G_PKG_NAME
4765: , 'Prorate'
4759: WHEN OTHERS THEN
4760:
4761: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4762: THEN
4763: OE_MSG_PUB.Add_Exc_Msg
4764: ( G_PKG_NAME
4765: , 'Prorate'
4766: );
4767: END IF;
4798: EXCEPTION
4799:
4800: WHEN NO_DATA_FOUND THEN
4801:
4802: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4803: THEN
4804:
4805: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
4806: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','method_code');
4803: THEN
4804:
4805: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
4806: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','method_code');
4807: OE_MSG_PUB.Add;
4808:
4809: END IF;
4810:
4811: RETURN FND_API.G_MISS_CHAR;
4811: RETURN FND_API.G_MISS_CHAR;
4812:
4813: WHEN OTHERS THEN
4814:
4815: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4816: THEN
4817: OE_MSG_PUB.Add_Exc_Msg
4818: ( G_PKG_NAME
4819: , 'Method'
4813: WHEN OTHERS THEN
4814:
4815: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4816: THEN
4817: OE_MSG_PUB.Add_Exc_Msg
4818: ( G_PKG_NAME
4819: , 'Method'
4820: );
4821: END IF;
4851: EXCEPTION
4852:
4853: WHEN NO_DATA_FOUND THEN
4854:
4855: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4856: THEN
4857:
4858: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
4859: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','price_list_line_id');
4856: THEN
4857:
4858: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
4859: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','price_list_line_id');
4860: OE_MSG_PUB.Add;
4861:
4862: END IF;
4863:
4864: RETURN FND_API.G_MISS_NUM;
4864: RETURN FND_API.G_MISS_NUM;
4865:
4866: WHEN OTHERS THEN
4867:
4868: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4869: THEN
4870: OE_MSG_PUB.Add_Exc_Msg
4871: ( G_PKG_NAME
4872: , 'Price_List_Line'
4866: WHEN OTHERS THEN
4867:
4868: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4869: THEN
4870: OE_MSG_PUB.Add_Exc_Msg
4871: ( G_PKG_NAME
4872: , 'Price_List_Line'
4873: );
4874: END IF;
4904: EXCEPTION
4905:
4906: WHEN NO_DATA_FOUND THEN
4907:
4908: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4909: THEN
4910:
4911: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
4912: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','pricing_rule_id');
4909: THEN
4910:
4911: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
4912: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','pricing_rule_id');
4913: OE_MSG_PUB.Add;
4914:
4915: END IF;
4916:
4917: RETURN FND_API.G_MISS_NUM;
4917: RETURN FND_API.G_MISS_NUM;
4918:
4919: WHEN OTHERS THEN
4920:
4921: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4922: THEN
4923: OE_MSG_PUB.Add_Exc_Msg
4924: ( G_PKG_NAME
4925: , 'Pricing_Rule'
4919: WHEN OTHERS THEN
4920:
4921: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4922: THEN
4923: OE_MSG_PUB.Add_Exc_Msg
4924: ( G_PKG_NAME
4925: , 'Pricing_Rule'
4926: );
4927: END IF;
4957: EXCEPTION
4958:
4959: WHEN NO_DATA_FOUND THEN
4960:
4961: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4962: THEN
4963:
4964: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
4965: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','reprice_flag');
4962: THEN
4963:
4964: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
4965: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','reprice_flag');
4966: OE_MSG_PUB.Add;
4967:
4968: END IF;
4969:
4970: RETURN FND_API.G_MISS_CHAR;
4970: RETURN FND_API.G_MISS_CHAR;
4971:
4972: WHEN OTHERS THEN
4973:
4974: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4975: THEN
4976: OE_MSG_PUB.Add_Exc_Msg
4977: ( G_PKG_NAME
4978: , 'Reprice'
4972: WHEN OTHERS THEN
4973:
4974: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4975: THEN
4976: OE_MSG_PUB.Add_Exc_Msg
4977: ( G_PKG_NAME
4978: , 'Reprice'
4979: );
4980: END IF;
5010: EXCEPTION
5011:
5012: WHEN NO_DATA_FOUND THEN
5013:
5014: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
5015: THEN
5016:
5017: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
5018: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','unit_code');
5015: THEN
5016:
5017: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
5018: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','unit_code');
5019: OE_MSG_PUB.Add;
5020:
5021: END IF;
5022:
5023: RETURN FND_API.G_MISS_CHAR;
5023: RETURN FND_API.G_MISS_CHAR;
5024:
5025: WHEN OTHERS THEN
5026:
5027: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5028: THEN
5029: OE_MSG_PUB.Add_Exc_Msg
5030: ( G_PKG_NAME
5031: , 'Unit'
5025: WHEN OTHERS THEN
5026:
5027: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5028: THEN
5029: OE_MSG_PUB.Add_Exc_Msg
5030: ( G_PKG_NAME
5031: , 'Unit'
5032: );
5033: END IF;
5063: EXCEPTION
5064:
5065: WHEN NO_DATA_FOUND THEN
5066:
5067: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
5068: THEN
5069:
5070: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
5071: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','customer_class_code');
5068: THEN
5069:
5070: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
5071: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','customer_class_code');
5072: OE_MSG_PUB.Add;
5073:
5074: END IF;
5075:
5076: RETURN FND_API.G_MISS_CHAR;
5076: RETURN FND_API.G_MISS_CHAR;
5077:
5078: WHEN OTHERS THEN
5079:
5080: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5081: THEN
5082: OE_MSG_PUB.Add_Exc_Msg
5083: ( G_PKG_NAME
5084: , 'Customer_Class'
5078: WHEN OTHERS THEN
5079:
5080: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5081: THEN
5082: OE_MSG_PUB.Add_Exc_Msg
5083: ( G_PKG_NAME
5084: , 'Customer_Class'
5085: );
5086: END IF;
5116: EXCEPTION
5117:
5118: WHEN NO_DATA_FOUND THEN
5119:
5120: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
5121: THEN
5122:
5123: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
5124: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','discount_customer_id');
5121: THEN
5122:
5123: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
5124: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','discount_customer_id');
5125: OE_MSG_PUB.Add;
5126:
5127: END IF;
5128:
5129: RETURN FND_API.G_MISS_NUM;
5129: RETURN FND_API.G_MISS_NUM;
5130:
5131: WHEN OTHERS THEN
5132:
5133: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5134: THEN
5135: OE_MSG_PUB.Add_Exc_Msg
5136: ( G_PKG_NAME
5137: , 'Discount_Customer'
5131: WHEN OTHERS THEN
5132:
5133: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5134: THEN
5135: OE_MSG_PUB.Add_Exc_Msg
5136: ( G_PKG_NAME
5137: , 'Discount_Customer'
5138: );
5139: END IF;
5169: EXCEPTION
5170:
5171: WHEN NO_DATA_FOUND THEN
5172:
5173: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
5174: THEN
5175:
5176: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
5177: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','site_use_id');
5174: THEN
5175:
5176: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
5177: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','site_use_id');
5178: OE_MSG_PUB.Add;
5179:
5180: END IF;
5181:
5182: RETURN FND_API.G_MISS_NUM;
5182: RETURN FND_API.G_MISS_NUM;
5183:
5184: WHEN OTHERS THEN
5185:
5186: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5187: THEN
5188: OE_MSG_PUB.Add_Exc_Msg
5189: ( G_PKG_NAME
5190: , 'Site_Use'
5184: WHEN OTHERS THEN
5185:
5186: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5187: THEN
5188: OE_MSG_PUB.Add_Exc_Msg
5189: ( G_PKG_NAME
5190: , 'Site_Use'
5191: );
5192: END IF;
5222: EXCEPTION
5223:
5224: WHEN NO_DATA_FOUND THEN
5225:
5226: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
5227: THEN
5228:
5229: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
5230: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','entity_id');
5227: THEN
5228:
5229: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
5230: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','entity_id');
5231: OE_MSG_PUB.Add;
5232:
5233: END IF;
5234:
5235: RETURN FND_API.G_MISS_NUM;
5235: RETURN FND_API.G_MISS_NUM;
5236:
5237: WHEN OTHERS THEN
5238:
5239: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5240: THEN
5241: OE_MSG_PUB.Add_Exc_Msg
5242: ( G_PKG_NAME
5243: , 'Entity'
5237: WHEN OTHERS THEN
5238:
5239: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5240: THEN
5241: OE_MSG_PUB.Add_Exc_Msg
5242: ( G_PKG_NAME
5243: , 'Entity'
5244: );
5245: END IF;
5275: EXCEPTION
5276:
5277: WHEN NO_DATA_FOUND THEN
5278:
5279: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
5280: THEN
5281:
5282: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
5283: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','method_type_code');
5280: THEN
5281:
5282: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
5283: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','method_type_code');
5284: OE_MSG_PUB.Add;
5285:
5286: END IF;
5287:
5288: RETURN FND_API.G_MISS_CHAR;
5288: RETURN FND_API.G_MISS_CHAR;
5289:
5290: WHEN OTHERS THEN
5291:
5292: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5293: THEN
5294: OE_MSG_PUB.Add_Exc_Msg
5295: ( G_PKG_NAME
5296: , 'Method_Type'
5290: WHEN OTHERS THEN
5291:
5292: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5293: THEN
5294: OE_MSG_PUB.Add_Exc_Msg
5295: ( G_PKG_NAME
5296: , 'Method_Type'
5297: );
5298: END IF;
5330: EXCEPTION
5331:
5332: WHEN NO_DATA_FOUND THEN
5333:
5334: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
5335: THEN
5336:
5337: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
5338: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','lot_serial_id');
5335: THEN
5336:
5337: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
5338: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','lot_serial_id');
5339: OE_MSG_PUB.Add;
5340:
5341: END IF;
5342:
5343: RETURN FND_API.G_MISS_NUM;
5343: RETURN FND_API.G_MISS_NUM;
5344:
5345: WHEN OTHERS THEN
5346:
5347: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5348: THEN
5349: OE_MSG_PUB.Add_Exc_Msg
5350: ( G_PKG_NAME
5351: , 'Lot_Serial'
5345: WHEN OTHERS THEN
5346:
5347: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5348: THEN
5349: OE_MSG_PUB.Add_Exc_Msg
5350: ( G_PKG_NAME
5351: , 'Lot_Serial'
5352: );
5353: END IF;
5383: EXCEPTION
5384:
5385: WHEN NO_DATA_FOUND THEN
5386:
5387: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
5388: THEN
5389:
5390: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
5391: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','appear_on_ack_flag');
5388: THEN
5389:
5390: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
5391: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','appear_on_ack_flag');
5392: OE_MSG_PUB.Add;
5393:
5394: END IF;
5395:
5396: RETURN FND_API.G_MISS_CHAR;
5396: RETURN FND_API.G_MISS_CHAR;
5397:
5398: WHEN OTHERS THEN
5399:
5400: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5401: THEN
5402: OE_MSG_PUB.Add_Exc_Msg
5403: ( G_PKG_NAME
5404: , 'Appear_On_Ack'
5398: WHEN OTHERS THEN
5399:
5400: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5401: THEN
5402: OE_MSG_PUB.Add_Exc_Msg
5403: ( G_PKG_NAME
5404: , 'Appear_On_Ack'
5405: );
5406: END IF;
5436: EXCEPTION
5437:
5438: WHEN NO_DATA_FOUND THEN
5439:
5440: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
5441: THEN
5442:
5443: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
5444: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','appear_on_invoice_flag');
5441: THEN
5442:
5443: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
5444: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','appear_on_invoice_flag');
5445: OE_MSG_PUB.Add;
5446:
5447: END IF;
5448:
5449: RETURN FND_API.G_MISS_CHAR;
5449: RETURN FND_API.G_MISS_CHAR;
5450:
5451: WHEN OTHERS THEN
5452:
5453: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5454: THEN
5455: OE_MSG_PUB.Add_Exc_Msg
5456: ( G_PKG_NAME
5457: , 'Appear_On_Invoice'
5451: WHEN OTHERS THEN
5452:
5453: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5454: THEN
5455: OE_MSG_PUB.Add_Exc_Msg
5456: ( G_PKG_NAME
5457: , 'Appear_On_Invoice'
5458: );
5459: END IF;
5489: EXCEPTION
5490:
5491: WHEN NO_DATA_FOUND THEN
5492:
5493: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
5494: THEN
5495:
5496: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
5497: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','charge_id');
5494: THEN
5495:
5496: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
5497: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','charge_id');
5498: OE_MSG_PUB.Add;
5499:
5500: END IF;
5501:
5502: RETURN FND_API.G_MISS_NUM;
5502: RETURN FND_API.G_MISS_NUM;
5503:
5504: WHEN OTHERS THEN
5505:
5506: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5507: THEN
5508: OE_MSG_PUB.Add_Exc_Msg
5509: ( G_PKG_NAME
5510: , 'Charge'
5504: WHEN OTHERS THEN
5505:
5506: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5507: THEN
5508: OE_MSG_PUB.Add_Exc_Msg
5509: ( G_PKG_NAME
5510: , 'Charge'
5511: );
5512: END IF;
5542: EXCEPTION
5543:
5544: WHEN NO_DATA_FOUND THEN
5545:
5546: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
5547: THEN
5548:
5549: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
5550: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','charge_type_id');
5547: THEN
5548:
5549: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
5550: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','charge_type_id');
5551: OE_MSG_PUB.Add;
5552:
5553: END IF;
5554:
5555: RETURN FND_API.G_MISS_NUM;
5555: RETURN FND_API.G_MISS_NUM;
5556:
5557: WHEN OTHERS THEN
5558:
5559: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5560: THEN
5561: OE_MSG_PUB.Add_Exc_Msg
5562: ( G_PKG_NAME
5563: , 'Charge_Type'
5557: WHEN OTHERS THEN
5558:
5559: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5560: THEN
5561: OE_MSG_PUB.Add_Exc_Msg
5562: ( G_PKG_NAME
5563: , 'Charge_Type'
5564: );
5565: END IF;
5595: EXCEPTION
5596:
5597: WHEN NO_DATA_FOUND THEN
5598:
5599: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
5600: THEN
5601:
5602: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
5603: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','cost_or_charge_flag');
5600: THEN
5601:
5602: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
5603: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','cost_or_charge_flag');
5604: OE_MSG_PUB.Add;
5605:
5606: END IF;
5607:
5608: RETURN FND_API.G_MISS_CHAR;
5608: RETURN FND_API.G_MISS_CHAR;
5609:
5610: WHEN OTHERS THEN
5611:
5612: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5613: THEN
5614: OE_MSG_PUB.Add_Exc_Msg
5615: ( G_PKG_NAME
5616: , 'Cost_Or_Charge'
5610: WHEN OTHERS THEN
5611:
5612: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5613: THEN
5614: OE_MSG_PUB.Add_Exc_Msg
5615: ( G_PKG_NAME
5616: , 'Cost_Or_Charge'
5617: );
5618: END IF;
5648: EXCEPTION
5649:
5650: WHEN NO_DATA_FOUND THEN
5651:
5652: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
5653: THEN
5654:
5655: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
5656: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','departure_id');
5653: THEN
5654:
5655: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
5656: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','departure_id');
5657: OE_MSG_PUB.Add;
5658:
5659: END IF;
5660:
5661: RETURN FND_API.G_MISS_NUM;
5661: RETURN FND_API.G_MISS_NUM;
5662:
5663: WHEN OTHERS THEN
5664:
5665: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5666: THEN
5667: OE_MSG_PUB.Add_Exc_Msg
5668: ( G_PKG_NAME
5669: , 'Departure'
5663: WHEN OTHERS THEN
5664:
5665: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5666: THEN
5667: OE_MSG_PUB.Add_Exc_Msg
5668: ( G_PKG_NAME
5669: , 'Departure'
5670: );
5671: END IF;
5701: EXCEPTION
5702:
5703: WHEN NO_DATA_FOUND THEN
5704:
5705: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
5706: THEN
5707:
5708: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
5709: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','estimated_flag');
5706: THEN
5707:
5708: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
5709: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','estimated_flag');
5710: OE_MSG_PUB.Add;
5711:
5712: END IF;
5713:
5714: RETURN FND_API.G_MISS_CHAR;
5714: RETURN FND_API.G_MISS_CHAR;
5715:
5716: WHEN OTHERS THEN
5717:
5718: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5719: THEN
5720: OE_MSG_PUB.Add_Exc_Msg
5721: ( G_PKG_NAME
5722: , 'Estimated'
5716: WHEN OTHERS THEN
5717:
5718: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5719: THEN
5720: OE_MSG_PUB.Add_Exc_Msg
5721: ( G_PKG_NAME
5722: , 'Estimated'
5723: );
5724: END IF;
5754: EXCEPTION
5755:
5756: WHEN NO_DATA_FOUND THEN
5757:
5758: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
5759: THEN
5760:
5761: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
5762: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','invoiced_flag');
5759: THEN
5760:
5761: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
5762: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','invoiced_flag');
5763: OE_MSG_PUB.Add;
5764:
5765: END IF;
5766:
5767: RETURN FND_API.G_MISS_CHAR;
5767: RETURN FND_API.G_MISS_CHAR;
5768:
5769: WHEN OTHERS THEN
5770:
5771: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5772: THEN
5773: OE_MSG_PUB.Add_Exc_Msg
5774: ( G_PKG_NAME
5775: , 'Invoiced'
5769: WHEN OTHERS THEN
5770:
5771: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5772: THEN
5773: OE_MSG_PUB.Add_Exc_Msg
5774: ( G_PKG_NAME
5775: , 'Invoiced'
5776: );
5777: END IF;
5807: EXCEPTION
5808:
5809: WHEN NO_DATA_FOUND THEN
5810:
5811: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
5812: THEN
5813:
5814: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
5815: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','parent_charge_id');
5812: THEN
5813:
5814: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
5815: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','parent_charge_id');
5816: OE_MSG_PUB.Add;
5817:
5818: END IF;
5819:
5820: RETURN FND_API.G_MISS_NUM;
5820: RETURN FND_API.G_MISS_NUM;
5821:
5822: WHEN OTHERS THEN
5823:
5824: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5825: THEN
5826: OE_MSG_PUB.Add_Exc_Msg
5827: ( G_PKG_NAME
5828: , 'Parent_Charge'
5822: WHEN OTHERS THEN
5823:
5824: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5825: THEN
5826: OE_MSG_PUB.Add_Exc_Msg
5827: ( G_PKG_NAME
5828: , 'Parent_Charge'
5829: );
5830: END IF;
5860: EXCEPTION
5861:
5862: WHEN NO_DATA_FOUND THEN
5863:
5864: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
5865: THEN
5866:
5867: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
5868: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','returnable_flag');
5865: THEN
5866:
5867: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
5868: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','returnable_flag');
5869: OE_MSG_PUB.Add;
5870:
5871: END IF;
5872:
5873: RETURN FND_API.G_MISS_CHAR;
5873: RETURN FND_API.G_MISS_CHAR;
5874:
5875: WHEN OTHERS THEN
5876:
5877: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5878: THEN
5879: OE_MSG_PUB.Add_Exc_Msg
5880: ( G_PKG_NAME
5881: , 'Returnable'
5875: WHEN OTHERS THEN
5876:
5877: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5878: THEN
5879: OE_MSG_PUB.Add_Exc_Msg
5880: ( G_PKG_NAME
5881: , 'Returnable'
5882: );
5883: END IF;
5913: EXCEPTION
5914:
5915: WHEN NO_DATA_FOUND THEN
5916:
5917: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
5918: THEN
5919:
5920: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
5921: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','tax_group_code');
5918: THEN
5919:
5920: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
5921: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','tax_group_code');
5922: OE_MSG_PUB.Add;
5923:
5924: END IF;
5925:
5926: RETURN FND_API.G_MISS_CHAR;
5926: RETURN FND_API.G_MISS_CHAR;
5927:
5928: WHEN OTHERS THEN
5929:
5930: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5931: THEN
5932: OE_MSG_PUB.Add_Exc_Msg
5933: ( G_PKG_NAME
5934: , 'Tax_Group'
5928: WHEN OTHERS THEN
5929:
5930: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5931: THEN
5932: OE_MSG_PUB.Add_Exc_Msg
5933: ( G_PKG_NAME
5934: , 'Tax_Group'
5935: );
5936: END IF;
5967: EXCEPTION
5968:
5969: WHEN NO_DATA_FOUND THEN
5970:
5971: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
5972: THEN
5973:
5974: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
5975: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','flow_status_code');
5972: THEN
5973:
5974: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
5975: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','flow_status_code');
5976: OE_MSG_PUB.Add;
5977:
5978: END IF;
5979:
5980: RETURN FND_API.G_MISS_CHAR;
5980: RETURN FND_API.G_MISS_CHAR;
5981:
5982: WHEN OTHERS THEN
5983:
5984: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5985: THEN
5986: OE_MSG_PUB.Add_Exc_Msg
5987: ( G_PKG_NAME
5988: , 'Flow_Status'
5982: WHEN OTHERS THEN
5983:
5984: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5985: THEN
5986: OE_MSG_PUB.Add_Exc_Msg
5987: ( G_PKG_NAME
5988: , 'Flow_Status'
5989: );
5990: END IF;
6010: EXCEPTION
6011:
6012: WHEN NO_DATA_FOUND THEN
6013:
6014: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
6015: THEN
6016:
6017: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
6018: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','freight_carrier_code');
6015: THEN
6016:
6017: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
6018: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','freight_carrier_code');
6019: OE_MSG_PUB.Add;
6020:
6021: END IF;
6022:
6023: RETURN FND_API.G_MISS_CHAR;
6025: WHEN TOO_MANY_ROWS THEN
6026:
6027: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
6028: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','freight_carrier_code');
6029: OE_MSG_PUB.Add;
6030: RETURN FND_API.G_MISS_CHAR;
6031:
6032: WHEN OTHERS THEN
6033:
6030: RETURN FND_API.G_MISS_CHAR;
6031:
6032: WHEN OTHERS THEN
6033:
6034: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6035: THEN
6036: OE_MSG_PUB.Add_Exc_Msg
6037: ( G_PKG_NAME
6038: , 'Freight_Carrier'
6032: WHEN OTHERS THEN
6033:
6034: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6035: THEN
6036: OE_MSG_PUB.Add_Exc_Msg
6037: ( G_PKG_NAME
6038: , 'Freight_Carrier'
6039: );
6040: END IF;
6070: EXCEPTION
6071:
6072: WHEN NO_DATA_FOUND THEN
6073:
6074: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
6075: THEN
6076:
6077: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
6078: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','sales_channel_code');
6075: THEN
6076:
6077: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
6078: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','sales_channel_code');
6079: OE_MSG_PUB.Add;
6080:
6081: END IF;
6082:
6083: RETURN FND_API.G_MISS_CHAR;
6083: RETURN FND_API.G_MISS_CHAR;
6084:
6085: WHEN OTHERS THEN
6086:
6087: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6088: THEN
6089: OE_MSG_PUB.Add_Exc_Msg
6090: ( G_PKG_NAME
6091: , 'Sales_Channel'
6085: WHEN OTHERS THEN
6086:
6087: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6088: THEN
6089: OE_MSG_PUB.Add_Exc_Msg
6090: ( G_PKG_NAME
6091: , 'Sales_Channel'
6092: );
6093: END IF;
6172: EXCEPTION
6173:
6174: WHEN NO_DATA_FOUND THEN
6175:
6176: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
6177: THEN
6178:
6179: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
6180: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','sold_to_site_use_id');
6177: THEN
6178:
6179: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
6180: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','sold_to_site_use_id');
6181: OE_MSG_PUB.Add;
6182:
6183: END IF;
6184:
6185: RETURN FND_API.G_MISS_NUM;
6185: RETURN FND_API.G_MISS_NUM;
6186:
6187: WHEN OTHERS THEN
6188:
6189: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6190: THEN
6191: OE_MSG_PUB.Add_Exc_Msg
6192: ( G_PKG_NAME
6193: , 'Customer_Location'
6187: WHEN OTHERS THEN
6188:
6189: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6190: THEN
6191: OE_MSG_PUB.Add_Exc_Msg
6192: ( G_PKG_NAME
6193: , 'Customer_Location'
6194: );
6195: END IF;
6222: EXCEPTION
6223:
6224: WHEN NO_DATA_FOUND THEN
6225:
6226: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
6227: THEN
6228:
6229: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
6230: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Payment_Collection_Event');
6227: THEN
6228:
6229: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
6230: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Payment_Collection_Event');
6231: OE_MSG_PUB.Add;
6232:
6233: END IF;
6234:
6235: RETURN FND_API.G_MISS_CHAR;
6235: RETURN FND_API.G_MISS_CHAR;
6236:
6237: WHEN OTHERS THEN
6238:
6239: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6240: THEN
6241: OE_MSG_PUB.Add_Exc_Msg
6242: ( G_PKG_NAME
6243: , 'Payment_Collection_Event_Name'
6237: WHEN OTHERS THEN
6238:
6239: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6240: THEN
6241: OE_MSG_PUB.Add_Exc_Msg
6242: ( G_PKG_NAME
6243: , 'Payment_Collection_Event_Name'
6244: );
6245: END IF;
6268: EXCEPTION
6269:
6270: WHEN NO_DATA_FOUND THEN
6271:
6272: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
6273: THEN
6274:
6275: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
6276: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','receipt_method_id');
6273: THEN
6274:
6275: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
6276: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','receipt_method_id');
6277: OE_MSG_PUB.Add;
6278:
6279: END IF;
6280:
6281: RETURN FND_API.G_MISS_CHAR;
6281: RETURN FND_API.G_MISS_CHAR;
6282:
6283: WHEN OTHERS THEN
6284:
6285: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6286: THEN
6287: OE_MSG_PUB.Add_Exc_Msg
6288: ( G_PKG_NAME
6289: , 'Receipt_Method'
6283: WHEN OTHERS THEN
6284:
6285: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6286: THEN
6287: OE_MSG_PUB.Add_Exc_Msg
6288: ( G_PKG_NAME
6289: , 'Receipt_Method'
6290: );
6291: END IF;
6337: EXCEPTION
6338:
6339: WHEN NO_DATA_FOUND THEN
6340:
6341: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
6342: THEN
6343:
6344: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
6345: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','end_customer_id');
6342: THEN
6343:
6344: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
6345: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','end_customer_id');
6346: OE_MSG_PUB.Add;
6347:
6348: END IF;
6349:
6350: RETURN FND_API.G_MISS_NUM;
6350: RETURN FND_API.G_MISS_NUM;
6351:
6352: WHEN OTHERS THEN
6353:
6354: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6355: THEN
6356: OE_MSG_PUB.Add_Exc_Msg
6357: ( G_PKG_NAME
6358: , 'End_customer'
6352: WHEN OTHERS THEN
6353:
6354: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6355: THEN
6356: OE_MSG_PUB.Add_Exc_Msg
6357: ( G_PKG_NAME
6358: , 'End_customer'
6359: );
6360: END IF;
6389: EXCEPTION
6390:
6391: WHEN NO_DATA_FOUND THEN
6392:
6393: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
6394: THEN
6395:
6396: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
6397: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','end_customer_contact_id');
6394: THEN
6395:
6396: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
6397: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','end_customer_contact_id');
6398: OE_MSG_PUB.Add;
6399:
6400: END IF;
6401:
6402: RETURN FND_API.G_MISS_NUM;
6402: RETURN FND_API.G_MISS_NUM;
6403:
6404: WHEN OTHERS THEN
6405:
6406: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6407: THEN
6408: OE_MSG_PUB.Add_Exc_Msg
6409: ( G_PKG_NAME
6410: , 'End_customer_contact'
6404: WHEN OTHERS THEN
6405:
6406: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6407: THEN
6408: OE_MSG_PUB.Add_Exc_Msg
6409: ( G_PKG_NAME
6410: , 'End_customer_contact'
6411: );
6412: END IF;
6637: IF c_site_use_id2%ISOPEN then
6638: CLOSE c_site_use_id2;
6639: END IF;
6640:
6641: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
6642: THEN
6643:
6644: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
6645: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','end_customer_site_id');
6642: THEN
6643:
6644: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
6645: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','end_customer_site_id');
6646: OE_MSG_PUB.Add;
6647:
6648: END IF;
6649: RETURN FND_API.G_MISS_NUM;
6650:
6657: IF c_site_use_id2%ISOPEN then
6658: CLOSE c_site_use_id2;
6659: END IF;
6660:
6661: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6662: THEN
6663: OE_MSG_PUB.Add_Exc_Msg
6664: ( G_PKG_NAME
6665: , 'end_cstomer_site_id'
6659: END IF;
6660:
6661: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6662: THEN
6663: OE_MSG_PUB.Add_Exc_Msg
6664: ( G_PKG_NAME
6665: , 'end_cstomer_site_id'
6666: );
6667: END IF;
6699: EXCEPTION
6700:
6701: WHEN NO_DATA_FOUND THEN
6702:
6703: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
6704: THEN
6705:
6706: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
6707: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ib_owner');
6704: THEN
6705:
6706: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
6707: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ib_owner');
6708: OE_MSG_PUB.Add;
6709:
6710: END IF;
6711:
6712: RETURN FND_API.G_MISS_CHAR;
6712: RETURN FND_API.G_MISS_CHAR;
6713:
6714: WHEN OTHERS THEN
6715:
6716: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6717: THEN
6718: OE_MSG_PUB.Add_Exc_Msg
6719: ( G_PKG_NAME
6720: , 'IB_Owner'
6714: WHEN OTHERS THEN
6715:
6716: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6717: THEN
6718: OE_MSG_PUB.Add_Exc_Msg
6719: ( G_PKG_NAME
6720: , 'IB_Owner'
6721: );
6722: END IF;
6754: EXCEPTION
6755:
6756: WHEN NO_DATA_FOUND THEN
6757:
6758: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
6759: THEN
6760:
6761: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
6762: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ib_installed_at_location');
6759: THEN
6760:
6761: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
6762: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ib_installed_at_location');
6763: OE_MSG_PUB.Add;
6764:
6765: END IF;
6766:
6767: RETURN FND_API.G_MISS_CHAR;
6767: RETURN FND_API.G_MISS_CHAR;
6768:
6769: WHEN OTHERS THEN
6770:
6771: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6772: THEN
6773: OE_MSG_PUB.Add_Exc_Msg
6774: ( G_PKG_NAME
6775: , 'ib_installed_at_location'
6769: WHEN OTHERS THEN
6770:
6771: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6772: THEN
6773: OE_MSG_PUB.Add_Exc_Msg
6774: ( G_PKG_NAME
6775: , 'ib_installed_at_location'
6776: );
6777: END IF;
6809: EXCEPTION
6810:
6811: WHEN NO_DATA_FOUND THEN
6812:
6813: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
6814: THEN
6815:
6816: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
6817: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ib_current_location');
6814: THEN
6815:
6816: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
6817: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ib_current_location');
6818: OE_MSG_PUB.Add;
6819:
6820: END IF;
6821:
6822: RETURN FND_API.G_MISS_CHAR;
6822: RETURN FND_API.G_MISS_CHAR;
6823:
6824: WHEN OTHERS THEN
6825:
6826: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6827: THEN
6828: OE_MSG_PUB.Add_Exc_Msg
6829: ( G_PKG_NAME
6830: , 'ib_current_location'
6824: WHEN OTHERS THEN
6825:
6826: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6827: THEN
6828: OE_MSG_PUB.Add_Exc_Msg
6829: ( G_PKG_NAME
6830: , 'ib_current_location'
6831: );
6832: END IF;
6871: EXCEPTION
6872:
6873: WHEN NO_DATA_FOUND THEN
6874:
6875: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
6876: THEN
6877:
6878: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
6879: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','org_id');
6876: THEN
6877:
6878: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
6879: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','org_id');
6880: OE_MSG_PUB.Add;
6881:
6882: END IF;
6883:
6884: RETURN FND_API.G_MISS_NUM;
6884: RETURN FND_API.G_MISS_NUM;
6885:
6886: WHEN OTHERS THEN
6887:
6888: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6889: THEN
6890: OE_MSG_PUB.Add_Exc_Msg
6891: ( G_PKG_NAME
6892: , 'Operating_Unit'
6886: WHEN OTHERS THEN
6887:
6888: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6889: THEN
6890: OE_MSG_PUB.Add_Exc_Msg
6891: ( G_PKG_NAME
6892: , 'Operating_Unit'
6893: );
6894: END IF;
6914: where Profile_number = p_service_bill_profile;
6915: RETURN l_bill_profile_id;
6916: EXCEPTION
6917: WHEN NO_DATA_FOUND THEN
6918: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
6919: THEN
6920: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
6921: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','SERVICE_BILL_PROFILE_ID');
6922: OE_MSG_PUB.Add;
6918: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
6919: THEN
6920: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
6921: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','SERVICE_BILL_PROFILE_ID');
6922: OE_MSG_PUB.Add;
6923: END IF;
6924: RETURN FND_API.G_MISS_NUM;
6925: WHEN OTHERS THEN
6926: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6922: OE_MSG_PUB.Add;
6923: END IF;
6924: RETURN FND_API.G_MISS_NUM;
6925: WHEN OTHERS THEN
6926: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6927: THEN
6928: OE_MSG_PUB.Add_Exc_Msg
6929: ( G_PKG_NAME
6930: , 'Billing_Profile'
6924: RETURN FND_API.G_MISS_NUM;
6925: WHEN OTHERS THEN
6926: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6927: THEN
6928: OE_MSG_PUB.Add_Exc_Msg
6929: ( G_PKG_NAME
6930: , 'Billing_Profile'
6931: );
6932: END IF;
6951: and MEANING = p_service_bill_option;
6952: RETURN l_bill_option_code;
6953: EXCEPTION
6954: WHEN NO_DATA_FOUND THEN
6955: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
6956: THEN
6957: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
6958: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','SERVICE_BILL_OPTION_CODE');
6959: OE_MSG_PUB.Add;
6955: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
6956: THEN
6957: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
6958: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','SERVICE_BILL_OPTION_CODE');
6959: OE_MSG_PUB.Add;
6960: END IF;
6961: RETURN FND_API.G_MISS_NUM;
6962: WHEN OTHERS THEN
6963: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6959: OE_MSG_PUB.Add;
6960: END IF;
6961: RETURN FND_API.G_MISS_NUM;
6962: WHEN OTHERS THEN
6963: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6964: THEN
6965: OE_MSG_PUB.Add_Exc_Msg
6966: ( G_PKG_NAME
6967: , 'Billing_Option'
6961: RETURN FND_API.G_MISS_NUM;
6962: WHEN OTHERS THEN
6963: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6964: THEN
6965: OE_MSG_PUB.Add_Exc_Msg
6966: ( G_PKG_NAME
6967: , 'Billing_Option'
6968: );
6969: END IF;
6988: and (sysdate between nvl(start_date, sysdate) and nvl(end_date, sysdate)) ;
6989: RETURN l_subs_template_id;
6990: EXCEPTION
6991: WHEN NO_DATA_FOUND THEN
6992: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
6993: THEN
6994: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
6995: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','SERVICE_SUBS_TEMPLATE_ID');
6996: OE_MSG_PUB.Add;
6992: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
6993: THEN
6994: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
6995: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','SERVICE_SUBS_TEMPLATE_ID');
6996: OE_MSG_PUB.Add;
6997: END IF;
6998: RETURN FND_API.G_MISS_NUM;
6999: WHEN OTHERS THEN
7000: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6996: OE_MSG_PUB.Add;
6997: END IF;
6998: RETURN FND_API.G_MISS_NUM;
6999: WHEN OTHERS THEN
7000: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7001: THEN
7002: OE_MSG_PUB.Add_Exc_Msg
7003: ( G_PKG_NAME
7004: , 'Subscription_Template'
6998: RETURN FND_API.G_MISS_NUM;
6999: WHEN OTHERS THEN
7000: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7001: THEN
7002: OE_MSG_PUB.Add_Exc_Msg
7003: ( G_PKG_NAME
7004: , 'Subscription_Template'
7005: );
7006: END IF;
7025: and (sysdate between nvl(start_date, sysdate) and nvl(end_date, sysdate)) ;
7026: RETURN l_cov_template_id;
7027: EXCEPTION
7028: WHEN NO_DATA_FOUND THEN
7029: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
7030: THEN
7031: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
7032: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','SERVICE_COV_TEMPLATE_ID');
7033: OE_MSG_PUB.Add;
7029: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
7030: THEN
7031: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
7032: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','SERVICE_COV_TEMPLATE_ID');
7033: OE_MSG_PUB.Add;
7034: END IF;
7035: RETURN FND_API.G_MISS_NUM;
7036: WHEN OTHERS THEN
7037: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7033: OE_MSG_PUB.Add;
7034: END IF;
7035: RETURN FND_API.G_MISS_NUM;
7036: WHEN OTHERS THEN
7037: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7038: THEN
7039: OE_MSG_PUB.Add_Exc_Msg
7040: ( G_PKG_NAME
7041: , 'Coverage_Template'
7035: RETURN FND_API.G_MISS_NUM;
7036: WHEN OTHERS THEN
7037: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7038: THEN
7039: OE_MSG_PUB.Add_Exc_Msg
7040: ( G_PKG_NAME
7041: , 'Coverage_Template'
7042: );
7043: END IF;