APPS.OE_ORDER_CACHE dependencies on OE_MSG_PUB

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

69: g_Enforce_list_price_rec.enforce_line_prices_flag :='N';
70:
71: WHEN OTHERS THEN
72:
73: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
74: THEN
75: OE_MSG_PUB.Add_Exc_Msg
76: ( G_PKG_NAME ,
77: 'Enforce_List_price'

Line 75: OE_MSG_PUB.Add_Exc_Msg

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

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

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

Line 180: OE_MSG_PUB.Add_Exc_Msg

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

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

309: RAISE NO_DATA_FOUND ;
310:
311: WHEN OTHERS THEN
312:
313: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
314: THEN
315: OE_MSG_PUB.Add_Exc_Msg
316: ( G_PKG_NAME ,
317: 'Load_Line_Type'

Line 315: OE_MSG_PUB.Add_Exc_Msg

311: WHEN OTHERS THEN
312:
313: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
314: THEN
315: OE_MSG_PUB.Add_Exc_Msg
316: ( G_PKG_NAME ,
317: 'Load_Line_Type'
318: );
319: END IF;

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

375: EXCEPTION
376:
377: WHEN OTHERS THEN
378:
379: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
380: THEN
381: OE_MSG_PUB.Add_Exc_Msg
382: ( G_PKG_NAME ,
383: 'Load_Agreement'

Line 381: OE_MSG_PUB.Add_Exc_Msg

377: WHEN OTHERS THEN
378:
379: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
380: THEN
381: OE_MSG_PUB.Add_Exc_Msg
382: ( G_PKG_NAME ,
383: 'Load_Agreement'
384: );
385: END IF;

Line 450: IF OE_MSG_PUB.Check_Msg_Level

446: g_ship_to_rec.invoice_to_org_id := NULL;
447:
448: WHEN OTHERS THEN
449:
450: IF OE_MSG_PUB.Check_Msg_Level
451: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
452: THEN
453: OE_MSG_PUB.Add_Exc_Msg
454: ( G_PKG_NAME

Line 451: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

447:
448: WHEN OTHERS THEN
449:
450: IF OE_MSG_PUB.Check_Msg_Level
451: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
452: THEN
453: OE_MSG_PUB.Add_Exc_Msg
454: ( G_PKG_NAME
455: , 'Load_Ship_To_Org - Fetch Bill to Site'

Line 453: OE_MSG_PUB.Add_Exc_Msg

449:
450: IF OE_MSG_PUB.Check_Msg_Level
451: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
452: THEN
453: OE_MSG_PUB.Add_Exc_Msg
454: ( G_PKG_NAME
455: , 'Load_Ship_To_Org - Fetch Bill to Site'
456: );
457: END IF;

Line 482: IF OE_MSG_PUB.Check_Msg_Level

478: g_ship_to_rec.payment_term_id := NULL;
479:
480: WHEN OTHERS THEN
481:
482: IF OE_MSG_PUB.Check_Msg_Level
483: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
484: THEN
485: OE_MSG_PUB.Add_Exc_Msg
486: ( G_PKG_NAME

Line 483: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

479:
480: WHEN OTHERS THEN
481:
482: IF OE_MSG_PUB.Check_Msg_Level
483: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
484: THEN
485: OE_MSG_PUB.Add_Exc_Msg
486: ( G_PKG_NAME
487: , 'Load_Ship_To_Org - Fetch Payment Terms'

Line 485: OE_MSG_PUB.Add_Exc_Msg

481:
482: IF OE_MSG_PUB.Check_Msg_Level
483: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
484: THEN
485: OE_MSG_PUB.Add_Exc_Msg
486: ( G_PKG_NAME
487: , 'Load_Ship_To_Org - Fetch Payment Terms'
488: );
489: END IF;

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

509: RAISE;
510:
511: WHEN OTHERS THEN
512:
513: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
514: THEN
515: OE_MSG_PUB.Add_Exc_Msg
516: ( G_PKG_NAME ,
517: 'Load_Ship_To_Org'

Line 515: OE_MSG_PUB.Add_Exc_Msg

511: WHEN OTHERS THEN
512:
513: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
514: THEN
515: OE_MSG_PUB.Add_Exc_Msg
516: ( G_PKG_NAME ,
517: 'Load_Ship_To_Org'
518: );
519: END IF;

Line 586: IF OE_MSG_PUB.Check_Msg_Level

582: g_invoice_to_rec.payment_term_id := NULL;
583:
584: WHEN OTHERS THEN
585:
586: IF OE_MSG_PUB.Check_Msg_Level
587: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
588: THEN
589: OE_MSG_PUB.Add_Exc_Msg
590: ( G_PKG_NAME

Line 587: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

583:
584: WHEN OTHERS THEN
585:
586: IF OE_MSG_PUB.Check_Msg_Level
587: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
588: THEN
589: OE_MSG_PUB.Add_Exc_Msg
590: ( G_PKG_NAME
591: , 'Load_Invoice_To_Org - Fetch Payment Terms'

Line 589: OE_MSG_PUB.Add_Exc_Msg

585:
586: IF OE_MSG_PUB.Check_Msg_Level
587: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
588: THEN
589: OE_MSG_PUB.Add_Exc_Msg
590: ( G_PKG_NAME
591: , 'Load_Invoice_To_Org - Fetch Payment Terms'
592: );
593: END IF;

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

617: RAISE;
618:
619: WHEN OTHERS THEN
620:
621: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
622: THEN
623: OE_MSG_PUB.Add_Exc_Msg
624: ( G_PKG_NAME ,
625: 'Load_Invoice_To_Org'

Line 623: OE_MSG_PUB.Add_Exc_Msg

619: WHEN OTHERS THEN
620:
621: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
622: THEN
623: OE_MSG_PUB.Add_Exc_Msg
624: ( G_PKG_NAME ,
625: 'Load_Invoice_To_Org'
626: );
627: END IF;

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

694: EXCEPTION
695:
696: WHEN OTHERS THEN
697:
698: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
699: THEN
700: OE_MSG_PUB.Add_Exc_Msg
701: ( G_PKG_NAME ,
702: 'Load_Deliver_To_Org'

Line 700: OE_MSG_PUB.Add_Exc_Msg

696: WHEN OTHERS THEN
697:
698: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
699: THEN
700: OE_MSG_PUB.Add_Exc_Msg
701: ( G_PKG_NAME ,
702: 'Load_Deliver_To_Org'
703: );
704: END IF;

Line 778: IF OE_MSG_PUB.Check_Msg_Level

774: g_sold_to_rec.invoice_to_org_id := NULL;
775:
776: WHEN OTHERS THEN
777:
778: IF OE_MSG_PUB.Check_Msg_Level
779: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
780: THEN
781: OE_MSG_PUB.Add_Exc_Msg
782: ( G_PKG_NAME

Line 779: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

775:
776: WHEN OTHERS THEN
777:
778: IF OE_MSG_PUB.Check_Msg_Level
779: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
780: THEN
781: OE_MSG_PUB.Add_Exc_Msg
782: ( G_PKG_NAME
783: , 'Load_Sold_To_Org - Fetch Invoice To'

Line 781: OE_MSG_PUB.Add_Exc_Msg

777:
778: IF OE_MSG_PUB.Check_Msg_Level
779: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
780: THEN
781: OE_MSG_PUB.Add_Exc_Msg
782: ( G_PKG_NAME
783: , 'Load_Sold_To_Org - Fetch Invoice To'
784: );
785: END IF;

Line 815: IF OE_MSG_PUB.Check_Msg_Level

811: g_sold_to_rec.ship_to_org_id := NULL;
812:
813: WHEN OTHERS THEN
814:
815: IF OE_MSG_PUB.Check_Msg_Level
816: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
817: THEN
818: OE_MSG_PUB.Add_Exc_Msg
819: ( G_PKG_NAME

Line 816: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

812:
813: WHEN OTHERS THEN
814:
815: IF OE_MSG_PUB.Check_Msg_Level
816: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
817: THEN
818: OE_MSG_PUB.Add_Exc_Msg
819: ( G_PKG_NAME
820: , 'Load_Sold_To_Org - Fetch Ship To'

Line 818: OE_MSG_PUB.Add_Exc_Msg

814:
815: IF OE_MSG_PUB.Check_Msg_Level
816: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
817: THEN
818: OE_MSG_PUB.Add_Exc_Msg
819: ( G_PKG_NAME
820: , 'Load_Sold_To_Org - Fetch Ship To'
821: );
822: END IF;

Line 852: IF OE_MSG_PUB.Check_Msg_Level

848: g_sold_to_rec.deliver_to_org_id := NULL;
849:
850: WHEN OTHERS THEN
851:
852: IF OE_MSG_PUB.Check_Msg_Level
853: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
854: THEN
855: OE_MSG_PUB.Add_Exc_Msg
856: ( G_PKG_NAME

Line 853: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

849:
850: WHEN OTHERS THEN
851:
852: IF OE_MSG_PUB.Check_Msg_Level
853: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
854: THEN
855: OE_MSG_PUB.Add_Exc_Msg
856: ( G_PKG_NAME
857: , 'Load_Sold_To_Org - Fetch Deliver To'

Line 855: OE_MSG_PUB.Add_Exc_Msg

851:
852: IF OE_MSG_PUB.Check_Msg_Level
853: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
854: THEN
855: OE_MSG_PUB.Add_Exc_Msg
856: ( G_PKG_NAME
857: , 'Load_Sold_To_Org - Fetch Deliver To'
858: );
859: END IF;

Line 883: IF OE_MSG_PUB.Check_Msg_Level

879: g_sold_to_rec.payment_term_id := NULL;
880:
881: WHEN OTHERS THEN
882:
883: IF OE_MSG_PUB.Check_Msg_Level
884: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
885: THEN
886: OE_MSG_PUB.Add_Exc_Msg
887: ( G_PKG_NAME

Line 884: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

880:
881: WHEN OTHERS THEN
882:
883: IF OE_MSG_PUB.Check_Msg_Level
884: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
885: THEN
886: OE_MSG_PUB.Add_Exc_Msg
887: ( G_PKG_NAME
888: , 'Load_Sold_To_Org - Fetch Payment Term'

Line 886: OE_MSG_PUB.Add_Exc_Msg

882:
883: IF OE_MSG_PUB.Check_Msg_Level
884: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
885: THEN
886: OE_MSG_PUB.Add_Exc_Msg
887: ( G_PKG_NAME
888: , 'Load_Sold_To_Org - Fetch Payment Term'
889: );
890: END IF;

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

910: RAISE;
911:
912: WHEN OTHERS THEN
913:
914: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
915: THEN
916: OE_MSG_PUB.Add_Exc_Msg
917: ( G_PKG_NAME ,
918: 'Load_Sold_To_Org'

Line 916: OE_MSG_PUB.Add_Exc_Msg

912: WHEN OTHERS THEN
913:
914: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
915: THEN
916: OE_MSG_PUB.Add_Exc_Msg
917: ( G_PKG_NAME ,
918: 'Load_Sold_To_Org'
919: );
920: END IF;

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

982: RAISE NO_DATA_FOUND ;
983:
984: WHEN OTHERS THEN
985:
986: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
987: THEN
988: OE_MSG_PUB.Add_Exc_Msg
989: ( G_PKG_NAME ,
990: 'Load_Price_List'

Line 988: OE_MSG_PUB.Add_Exc_Msg

984: WHEN OTHERS THEN
985:
986: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
987: THEN
988: OE_MSG_PUB.Add_Exc_Msg
989: ( G_PKG_NAME ,
990: 'Load_Price_List'
991: );
992: END IF;

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

1041: EXCEPTION
1042:
1043: WHEN OTHERS THEN
1044:
1045: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1046: THEN
1047: OE_MSG_PUB.Add_Exc_Msg
1048: ( G_PKG_NAME ,
1049: 'Load_Set_Of_Books'

Line 1047: OE_MSG_PUB.Add_Exc_Msg

1043: WHEN OTHERS THEN
1044:
1045: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1046: THEN
1047: OE_MSG_PUB.Add_Exc_Msg
1048: ( G_PKG_NAME ,
1049: 'Load_Set_Of_Books'
1050: );
1051: END IF;

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

1106: RETURN g_item_cost_rec;
1107:
1108: WHEN OTHERS THEN
1109:
1110: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1111: THEN
1112: OE_MSG_PUB.Add_Exc_Msg
1113: ( G_PKG_NAME ,
1114: 'Load_Item_Cost'

Line 1112: OE_MSG_PUB.Add_Exc_Msg

1108: WHEN OTHERS THEN
1109:
1110: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1111: THEN
1112: OE_MSG_PUB.Add_Exc_Msg
1113: ( G_PKG_NAME ,
1114: 'Load_Item_Cost'
1115: );
1116: END IF;

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

1170: RAISE NO_DATA_FOUND;
1171:
1172: WHEN OTHERS THEN
1173:
1174: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1175: THEN
1176: OE_MSG_PUB.Add_Exc_Msg
1177: ( G_PKG_NAME
1178: , 'Load_Order_Header'

Line 1176: OE_MSG_PUB.Add_Exc_Msg

1172: WHEN OTHERS THEN
1173:
1174: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1175: THEN
1176: OE_MSG_PUB.Add_Exc_Msg
1177: ( G_PKG_NAME
1178: , 'Load_Order_Header'
1179: );
1180: END IF;

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

1266: EXCEPTION
1267:
1268: WHEN OTHERS THEN
1269:
1270: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1271: THEN
1272: OE_MSG_PUB.Add_Exc_Msg
1273: ( G_PKG_NAME ,
1274: 'Load_header_discount'

Line 1272: OE_MSG_PUB.Add_Exc_Msg

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

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

1392: EXCEPTION
1393:
1394: WHEN OTHERS THEN
1395:
1396: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1397: THEN
1398: OE_MSG_PUB.Add_Exc_Msg
1399: ( G_PKG_NAME ,
1400: 'Load_Line_Discount'

Line 1398: OE_MSG_PUB.Add_Exc_Msg

1394: WHEN OTHERS THEN
1395:
1396: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1397: THEN
1398: OE_MSG_PUB.Add_Exc_Msg
1399: ( G_PKG_NAME ,
1400: 'Load_Line_Discount'
1401: );
1402: END IF;

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

1463: RAISE NO_DATA_FOUND;
1464:
1465: WHEN OTHERS THEN
1466:
1467: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1468: THEN
1469: OE_MSG_PUB.Add_Exc_Msg
1470: ( G_PKG_NAME
1471: , 'Load_Top_Model_Line'

Line 1469: OE_MSG_PUB.Add_Exc_Msg

1465: WHEN OTHERS THEN
1466:
1467: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1468: THEN
1469: OE_MSG_PUB.Add_Exc_Msg
1470: ( G_PKG_NAME
1471: , 'Load_Top_Model_Line'
1472: );
1473: END IF;

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

1799:
1800: if l_debug_level > 0 then
1801: oe_debug_pub.add('exception in load item', 1);
1802: end if;
1803: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1804: THEN
1805: OE_MSG_PUB.Add_Exc_Msg
1806: ( G_PKG_NAME ,
1807: 'Load_Item'

Line 1805: OE_MSG_PUB.Add_Exc_Msg

1801: oe_debug_pub.add('exception in load item', 1);
1802: end if;
1803: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1804: THEN
1805: OE_MSG_PUB.Add_Exc_Msg
1806: ( G_PKG_NAME ,
1807: 'Load_Item'
1808: );
1809: END IF;

Line 1878: IF OE_MSG_PUB.Check_Msg_Level

1874: g_set_rec.Set_Status := NULL;
1875:
1876: WHEN OTHERS THEN
1877:
1878: IF OE_MSG_PUB.Check_Msg_Level
1879: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1880: THEN
1881: OE_MSG_PUB.Add_Exc_Msg
1882: ( G_PKG_NAME

Line 1879: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1875:
1876: WHEN OTHERS THEN
1877:
1878: IF OE_MSG_PUB.Check_Msg_Level
1879: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1880: THEN
1881: OE_MSG_PUB.Add_Exc_Msg
1882: ( G_PKG_NAME
1883: , 'Load_set '

Line 1881: OE_MSG_PUB.Add_Exc_Msg

1877:
1878: IF OE_MSG_PUB.Check_Msg_Level
1879: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1880: THEN
1881: OE_MSG_PUB.Add_Exc_Msg
1882: ( G_PKG_NAME
1883: , 'Load_set '
1884: );
1885: END IF;

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

1905: EXCEPTION
1906:
1907: WHEN OTHERS THEN
1908:
1909: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1910: THEN
1911: OE_MSG_PUB.Add_Exc_Msg
1912: ( G_PKG_NAME ,
1913: 'Load_Delivery_Set'

Line 1911: OE_MSG_PUB.Add_Exc_Msg

1907: WHEN OTHERS THEN
1908:
1909: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1910: THEN
1911: OE_MSG_PUB.Add_Exc_Msg
1912: ( G_PKG_NAME ,
1913: 'Load_Delivery_Set'
1914: );
1915: END IF;

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

1964:
1965: --return g_payment_term_rec ;
1966: WHEN OTHERS THEN
1967:
1968: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1969: THEN
1970: OE_MSG_PUB.Add_Exc_Msg
1971: ( G_PKG_NAME ,
1972: 'Load_Payment_Term'

Line 1970: OE_MSG_PUB.Add_Exc_Msg

1966: WHEN OTHERS THEN
1967:
1968: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1969: THEN
1970: OE_MSG_PUB.Add_Exc_Msg
1971: ( G_PKG_NAME ,
1972: 'Load_Payment_Term'
1973: );
1974: END IF;

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

2021:
2022: -- return g_salesrep_rec ;
2023: WHEN OTHERS THEN
2024:
2025: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2026: THEN
2027: OE_MSG_PUB.Add_Exc_Msg
2028: ( G_PKG_NAME ,
2029: 'Load_Salesrep_rec'

Line 2027: OE_MSG_PUB.Add_Exc_Msg

2023: WHEN OTHERS THEN
2024:
2025: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2026: THEN
2027: OE_MSG_PUB.Add_Exc_Msg
2028: ( G_PKG_NAME ,
2029: 'Load_Salesrep_rec'
2030: );
2031: END IF;

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

2426: EXCEPTION
2427:
2428: WHEN OTHERS THEN
2429:
2430: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2431: THEN
2432: OE_MSG_PUB.Add_Exc_Msg
2433: ( G_PKG_NAME ,
2434: 'Load_list_lines'||sqlerrm

Line 2432: OE_MSG_PUB.Add_Exc_Msg

2428: WHEN OTHERS THEN
2429:
2430: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2431: THEN
2432: OE_MSG_PUB.Add_Exc_Msg
2433: ( G_PKG_NAME ,
2434: 'Load_list_lines'||sqlerrm
2435: );
2436: END IF;

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

2507: EXCEPTION
2508:
2509: WHEN OTHERS THEN
2510:
2511: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2512: THEN
2513: OE_MSG_PUB.Add_Exc_Msg
2514: ( G_PKG_NAME ,
2515: 'Load_Cust_Trx_Type'

Line 2513: OE_MSG_PUB.Add_Exc_Msg

2509: WHEN OTHERS THEN
2510:
2511: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2512: THEN
2513: OE_MSG_PUB.Add_Exc_Msg
2514: ( G_PKG_NAME ,
2515: 'Load_Cust_Trx_Type'
2516: );
2517: END IF;

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

2610: EXCEPTION
2611:
2612: WHEN OTHERS THEN
2613:
2614: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2615: THEN
2616: OE_MSG_PUB.Add_Exc_Msg
2617: ( G_PKG_NAME ,
2618: 'get_tax_calculation_flag'

Line 2616: OE_MSG_PUB.Add_Exc_Msg

2612: WHEN OTHERS THEN
2613:
2614: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2615: THEN
2616: OE_MSG_PUB.Add_Exc_Msg
2617: ( G_PKG_NAME ,
2618: 'get_tax_calculation_flag'
2619: );
2620: END IF;