eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_DELAYED_REQUESTS_UTIL dependencies on OE_MSG_PUB

Line 41: OE_MSG_PUB.Add;

37: IF (l_percent_total <> 100 AND
38: l_percent_total <> 0)THEN
39: fnd_message.set_name('ONT','OE_VAL_TTL_LINE_CREDIT');
40: FND_MESSAGE.SET_TOKEN('TOTAL',to_char(l_percent_total));
41: OE_MSG_PUB.Add;
42: x_return_status := FND_API.G_RET_STS_ERROR;
43: END IF;
44:
45: oe_debug_pub.add('Exiting OE_DELAYED_REQUESTS_UTIL.VALIDATE_LSC_QUOTA_TOTAL', 1);

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

57: WHEN OTHERS THEN
58:
59: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
60:
61: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
62: THEN
63: OE_MSG_PUB.Add_Exc_Msg
64: ( G_PKG_NAME
65: , 'Validate_LSC_QUOTA_TOTAL'

Line 63: OE_MSG_PUB.Add_Exc_Msg

59: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
60:
61: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
62: THEN
63: OE_MSG_PUB.Add_Exc_Msg
64: ( G_PKG_NAME
65: , 'Validate_LSC_QUOTA_TOTAL'
66: );
67: END IF;

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

88: WHEN OTHERS THEN
89:
90: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
91:
92: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
93: THEN
94: OE_MSG_PUB.Add_Exc_Msg
95: ( G_PKG_NAME
96: , 'Validate_HSC_QUOTA_TOTAL:'||SQLERRM

Line 94: OE_MSG_PUB.Add_Exc_Msg

90: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
91:
92: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
93: THEN
94: OE_MSG_PUB.Add_Exc_Msg
95: ( G_PKG_NAME
96: , 'Validate_HSC_QUOTA_TOTAL:'||SQLERRM
97: );
98: END IF;

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

132: WHEN OTHERS THEN
133:
134: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
135:
136: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
137: THEN
138: OE_MSG_PUB.Add_Exc_Msg
139: ( G_PKG_NAME
140: , 'DFLT_Hscredit_Primary_Srep:'||SQLERRM

Line 138: OE_MSG_PUB.Add_Exc_Msg

134: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
135:
136: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
137: THEN
138: OE_MSG_PUB.Add_Exc_Msg
139: ( G_PKG_NAME
140: , 'DFLT_Hscredit_Primary_Srep:'||SQLERRM
141: );
142: END IF;

Line 361: oe_msg_pub.add('In Update');

357: --Sales credir record exists for the child service line.
358:
359: IF l_operation = OE_GLOBALS.G_OPR_UPDATE THEN
360:
361: oe_msg_pub.add('In Update');
362:
363: IF l_new_quota_flag = 'Y' THEN
364:
365: Select nvl(sum(Percent),0) Per_total

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

482: WHEN OTHERS THEN
483:
484: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
485:
486: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
487: THEN
488: OE_MSG_PUB.Add_Exc_Msg
489: ( G_PKG_NAME
490: , 'CASCADE_SERVICE_SCREDIT'

Line 488: OE_MSG_PUB.Add_Exc_Msg

484: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
485:
486: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
487: THEN
488: OE_MSG_PUB.Add_Exc_Msg
489: ( G_PKG_NAME
490: , 'CASCADE_SERVICE_SCREDIT'
491: );
492: END IF;

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

552: IF SQL%rowcount <> 0
553: THEN
554: l_return_status := FND_API.G_RET_STS_ERROR;
555:
556: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
557: THEN
558:
559: fnd_message.set_name('ONT', 'OE_DIS_DUPLICATE_ORD_DISC');
560: OE_MSG_PUB.Add;

Line 560: OE_MSG_PUB.Add;

556: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
557: THEN
558:
559: fnd_message.set_name('ONT', 'OE_DIS_DUPLICATE_ORD_DISC');
560: OE_MSG_PUB.Add;
561:
562: END IF;
563:
564: RAISE DUPLICATE_DISCOUNT;

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

580:
581: IF SQL%rowcount <> 0 THEN
582: l_return_status := FND_API.G_RET_STS_ERROR;
583:
584: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
585: THEN
586:
587: fnd_message.set_name('ONT', 'OE_DIS_DUPLICATE_LIN_DISC');
588: OE_MSG_PUB.Add;

Line 588: OE_MSG_PUB.Add;

584: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
585: THEN
586:
587: fnd_message.set_name('ONT', 'OE_DIS_DUPLICATE_LIN_DISC');
588: OE_MSG_PUB.Add;
589:
590: END IF;
591:
592: RAISE DUPLICATE_DISCOUNT;

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

609: WHEN OTHERS
610: THEN
611: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
612:
613: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
614: THEN
615: OE_MSG_PUB.Add_Exc_Msg
616: ( G_PKG_NAME
617: , 'CHECK_DUPLICATE'

Line 615: OE_MSG_PUB.Add_Exc_Msg

611: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
612:
613: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
614: THEN
615: OE_MSG_PUB.Add_Exc_Msg
616: ( G_PKG_NAME
617: , 'CHECK_DUPLICATE'
618: );
619: END IF;

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

697: AND l_discount_count = 1 THEN
698: oe_debug_pub.ADD('OEXSRLNB2: Check Fixed Price. '||
699: ' entity_code = ' || l_entity_code, 2);
700: l_return_status := FND_API.G_RET_STS_ERROR;
701: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
702: THEN
703:
704: FND_MESSAGE.SET_NAME('ONT', 'OE_DIS_FIXED_PRICE_HEADER');
705: FND_MESSAGE.SET_TOKEN('NUMBER', to_char(l_number));

Line 706: OE_MSG_PUB.Add;

702: THEN
703:
704: FND_MESSAGE.SET_NAME('ONT', 'OE_DIS_FIXED_PRICE_HEADER');
705: FND_MESSAGE.SET_TOKEN('NUMBER', to_char(l_number));
706: OE_MSG_PUB.Add;
707:
708:
709: END IF;
710: RAISE FIXED_PRICE_VIOLATE;

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

727: AND ROWNUM = 1;
728:
729: IF l_count <> 0 THEN
730:
731: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
732: THEN
733:
734: FND_MESSAGE.SET_NAME('ONT', 'OE_DIS_FIXED_PRICE');
735: OE_MSG_PUB.Add;

Line 735: OE_MSG_PUB.Add;

731: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
732: THEN
733:
734: FND_MESSAGE.SET_NAME('ONT', 'OE_DIS_FIXED_PRICE');
735: OE_MSG_PUB.Add;
736:
737: END IF;
738:
739: RAISE FIXED_PRICE;

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

763: AND l_discount_count = 1 THEN
764: oe_debug_pub.ADD('OEXSRLNB2: Check Fixed Price. '||
765: ' entity_code = ' || l_entity_code, 2);
766: l_return_status := FND_API.G_RET_STS_ERROR;
767: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
768: THEN
769:
770: FND_MESSAGE.SET_NAME('ONT', 'OE_DIS_FIXED_PRICE_VIOL');
771: FND_MESSAGE.SET_TOKEN('NAME', l_fixed_price);

Line 772: OE_MSG_PUB.Add;

768: THEN
769:
770: FND_MESSAGE.SET_NAME('ONT', 'OE_DIS_FIXED_PRICE_VIOL');
771: FND_MESSAGE.SET_TOKEN('NAME', l_fixed_price);
772: OE_MSG_PUB.Add;
773:
774: END IF;
775:
776: RAISE FIXED_PRICE_VIOLATE;

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

797: WHEN OTHERS
798: THEN
799: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
800:
801: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
802: THEN
803: OE_MSG_PUB.Add_Exc_Msg
804: ( G_PKG_NAME
805: , 'CHECK_FIXED_PRICE'

Line 803: OE_MSG_PUB.Add_Exc_Msg

799: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
800:
801: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
802: THEN
803: OE_MSG_PUB.Add_Exc_Msg
804: ( G_PKG_NAME
805: , 'CHECK_FIXED_PRICE'
806: );
807: END IF;

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

897: IF ( l_percent_total > 100 ) THEN
898:
899: l_return_status := FND_API.G_RET_STS_ERROR;
900:
901: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
902: THEN
903:
904: FND_MESSAGE.SET_NAME('ONT','OE_DIS_ADJUSTMENT_TOTAL');
905: FND_MESSAGE.SET_TOKEN('TOTAL', To_char(l_percent_total));

Line 906: OE_MSG_PUB.Add;

902: THEN
903:
904: FND_MESSAGE.SET_NAME('ONT','OE_DIS_ADJUSTMENT_TOTAL');
905: FND_MESSAGE.SET_TOKEN('TOTAL', To_char(l_percent_total));
906: OE_MSG_PUB.Add;
907:
908: END IF;
909:
910: RAISE percentage_exceeded;

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

936: IF ( l_percent_total > 100 ) THEN
937:
938: l_return_status := FND_API.G_RET_STS_ERROR;
939:
940: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
941: THEN
942:
943: FND_MESSAGE.SET_NAME('ONT','OE_DIS_ADJUSTMENT_TOTAL');
944: FND_MESSAGE.SET_TOKEN('TOTAL', To_char(l_percent_total));

Line 945: OE_MSG_PUB.Add;

941: THEN
942:
943: FND_MESSAGE.SET_NAME('ONT','OE_DIS_ADJUSTMENT_TOTAL');
944: FND_MESSAGE.SET_TOKEN('TOTAL', To_char(l_percent_total));
945: OE_MSG_PUB.Add;
946:
947: END IF;
948:
949: RAISE percentage_exceeded;

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

1016: IF max_line_adj_total%isopen THEN
1017: CLOSE max_line_adj_total;
1018: END IF;
1019:
1020: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1021: THEN
1022: OE_MSG_PUB.Add_Exc_Msg
1023: ( G_PKG_NAME
1024: , 'CHECK_PERCENTAGE'

Line 1022: OE_MSG_PUB.Add_Exc_Msg

1018: END IF;
1019:
1020: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1021: THEN
1022: OE_MSG_PUB.Add_Exc_Msg
1023: ( G_PKG_NAME
1024: , 'CHECK_PERCENTAGE'
1025: );
1026: END IF;

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

1140: WHEN OTHERS THEN
1141:
1142: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1143:
1144: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1145: THEN
1146: OE_MSG_PUB.Add_Exc_Msg
1147: ( G_PKG_NAME
1148: , 'Validate_LSC_QUOTA_TOTAL'

Line 1146: OE_MSG_PUB.Add_Exc_Msg

1142: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1143:
1144: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1145: THEN
1146: OE_MSG_PUB.Add_Exc_Msg
1147: ( G_PKG_NAME
1148: , 'Validate_LSC_QUOTA_TOTAL'
1149: );
1150: END IF;

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

1211: WHEN OTHERS THEN
1212:
1213: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1214:
1215: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1216: THEN
1217: OE_MSG_PUB.Add_Exc_Msg
1218: ( G_PKG_NAME
1219: , 'Verify_Payment'

Line 1217: OE_MSG_PUB.Add_Exc_Msg

1213: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1214:
1215: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1216: THEN
1217: OE_MSG_PUB.Add_Exc_Msg
1218: ( G_PKG_NAME
1219: , 'Verify_Payment'
1220: );
1221: END IF;

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

1422: WHEN OTHERS THEN
1423:
1424: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1425:
1426: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1427: THEN
1428: OE_MSG_PUB.Add_Exc_Msg
1429: ( G_PKG_NAME
1430: , 'INSERT_RMA_SCREDIT_ADJUSTMENT'

Line 1428: OE_MSG_PUB.Add_Exc_Msg

1424: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1425:
1426: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1427: THEN
1428: OE_MSG_PUB.Add_Exc_Msg
1429: ( G_PKG_NAME
1430: , 'INSERT_RMA_SCREDIT_ADJUSTMENT'
1431: );
1432: END IF;

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

1729: x_return_status := FND_API.G_RET_STS_SUCCESS;
1730:
1731: WHEN OTHERS THEN
1732:
1733: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1734: THEN
1735: OE_MSG_PUB.Add_Exc_Msg
1736: ( G_PKG_NAME ,
1737: 'Tax Line'

Line 1735: OE_MSG_PUB.Add_Exc_Msg

1731: WHEN OTHERS THEN
1732:
1733: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1734: THEN
1735: OE_MSG_PUB.Add_Exc_Msg
1736: ( G_PKG_NAME ,
1737: 'Tax Line'
1738: );
1739: END IF;

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

1796:
1797: WHEN OTHERS THEN
1798:
1799: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1800: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1801: THEN
1802: OE_MSG_PUB.Add_Exc_Msg
1803: ( G_PKG_NAME
1804: , 'Split_Hold'

Line 1802: OE_MSG_PUB.Add_Exc_Msg

1798:
1799: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1800: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1801: THEN
1802: OE_MSG_PUB.Add_Exc_Msg
1803: ( G_PKG_NAME
1804: , 'Split_Hold'
1805: );
1806: END IF;

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

1868:
1869: WHEN OTHERS THEN
1870:
1871: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1872: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1873: THEN
1874: OE_MSG_PUB.Add_Exc_Msg
1875: ( G_PKG_NAME
1876: , 'Eval_Hold_Source'

Line 1874: OE_MSG_PUB.Add_Exc_Msg

1870:
1871: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1872: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1873: THEN
1874: OE_MSG_PUB.Add_Exc_Msg
1875: ( G_PKG_NAME
1876: , 'Eval_Hold_Source'
1877: );
1878: END IF;

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

2022: WHEN OTHERS THEN
2023:
2024: l_request_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2025: x_request_rec := l_request_rec;
2026: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2027: THEN
2028: OE_MSG_PUB.Add_Exc_Msg
2029: ( G_PKG_NAME
2030: , 'Apply_Hold'

Line 2028: OE_MSG_PUB.Add_Exc_Msg

2024: l_request_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2025: x_request_rec := l_request_rec;
2026: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2027: THEN
2028: OE_MSG_PUB.Add_Exc_Msg
2029: ( G_PKG_NAME
2030: , 'Apply_Hold'
2031: );
2032: END IF;

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

2174: WHEN OTHERS THEN
2175:
2176: l_request_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2177: x_request_rec := l_request_rec;
2178: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2179: THEN
2180: OE_MSG_PUB.Add_Exc_Msg
2181: ( G_PKG_NAME
2182: , 'Release_Hold'

Line 2180: OE_MSG_PUB.Add_Exc_Msg

2176: l_request_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2177: x_request_rec := l_request_rec;
2178: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2179: THEN
2180: OE_MSG_PUB.Add_Exc_Msg
2181: ( G_PKG_NAME
2182: , 'Release_Hold'
2183: );
2184: END IF;

Line 2223: OE_MSG_PUB.Count_And_Get

2219: x_return_status := FND_API.G_RET_STS_ERROR;
2220:
2221: -- Get message count and data
2222:
2223: OE_MSG_PUB.Count_And_Get
2224: ( p_count => x_msg_count
2225: , p_data => x_msg_data
2226: );
2227:

Line 2233: OE_MSG_PUB.Count_And_Get

2229:
2230: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2231: -- Get message count and data
2232:
2233: OE_MSG_PUB.Count_And_Get
2234: ( p_count => x_msg_count
2235: , p_data => x_msg_data
2236: );
2237:

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

2238: WHEN OTHERS THEN
2239:
2240: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2241:
2242: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2243: THEN
2244: OE_MSG_PUB.Add_Exc_Msg
2245: ( G_PKG_NAME
2246: , 'Split_Set'

Line 2244: OE_MSG_PUB.Add_Exc_Msg

2240: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2241:
2242: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2243: THEN
2244: OE_MSG_PUB.Add_Exc_Msg
2245: ( G_PKG_NAME
2246: , 'Split_Set'
2247: );
2248: END IF;

Line 2252: OE_MSG_PUB.Count_And_Get

2248: END IF;
2249:
2250: -- Get message count and data
2251:
2252: OE_MSG_PUB.Count_And_Get
2253: ( p_count => x_msg_count
2254: , p_data => x_msg_data
2255: );
2256:

Line 2292: OE_MSG_PUB.Count_And_Get

2288: x_return_status := FND_API.G_RET_STS_ERROR;
2289:
2290: -- Get message count and data
2291:
2292: OE_MSG_PUB.Count_And_Get
2293: ( p_count => x_msg_count
2294: , p_data => x_msg_data
2295: );
2296:

Line 2302: OE_MSG_PUB.Count_And_Get

2298:
2299: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2300: -- Get message count and data
2301:
2302: OE_MSG_PUB.Count_And_Get
2303: ( p_count => x_msg_count
2304: , p_data => x_msg_data
2305: );
2306:

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

2307: WHEN OTHERS THEN
2308:
2309: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2310:
2311: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2312: THEN
2313: OE_MSG_PUB.Add_Exc_Msg
2314: ( G_PKG_NAME
2315: , 'Insert_Set'

Line 2313: OE_MSG_PUB.Add_Exc_Msg

2309: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2310:
2311: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2312: THEN
2313: OE_MSG_PUB.Add_Exc_Msg
2314: ( G_PKG_NAME
2315: , 'Insert_Set'
2316: );
2317: END IF;

Line 2320: OE_MSG_PUB.Count_And_Get

2316: );
2317: END IF;
2318: -- Get message count and data
2319:
2320: OE_MSG_PUB.Count_And_Get
2321: ( p_count => x_msg_count
2322: , p_data => x_msg_data
2323: );
2324:

Line 2353: IF OE_MSG_PUB.Check_Msg_Level

2349:
2350: EXCEPTION
2351: WHEN OTHERS THEN
2352: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2353: IF OE_MSG_PUB.Check_Msg_Level
2354: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2355: THEN
2356: OE_MSG_PUB.Add_Exc_Msg
2357: ( G_PKG_NAME

Line 2354: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2350: EXCEPTION
2351: WHEN OTHERS THEN
2352: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2353: IF OE_MSG_PUB.Check_Msg_Level
2354: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2355: THEN
2356: OE_MSG_PUB.Add_Exc_Msg
2357: ( G_PKG_NAME
2358: , 'Book_Order'

Line 2356: OE_MSG_PUB.Add_Exc_Msg

2352: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2353: IF OE_MSG_PUB.Check_Msg_Level
2354: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2355: THEN
2356: OE_MSG_PUB.Add_Exc_Msg
2357: ( G_PKG_NAME
2358: , 'Book_Order'
2359: );
2360: END IF;

Line 2428: OE_MSG_PUB.Add;

2424: ,x_msg_count => l_msg_count
2425: ,x_msg_data => l_msg_data);
2426: ELSE
2427: fnd_message.set_name('ONT','OE_FTE_NOT_ENABLED');
2428: OE_MSG_PUB.Add;
2429: oe_debug_pub.add('Unable to process FTE integration either due to
2430: FTE is not enabled or action code is invalid.', 3);
2431: x_return_status := FND_API.G_RET_STS_ERROR;
2432: END IF;

Line 2439: IF OE_MSG_PUB.Check_Msg_Level

2435:
2436: EXCEPTION
2437: WHEN OTHERS THEN
2438: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2439: IF OE_MSG_PUB.Check_Msg_Level
2440: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2441: THEN
2442: OE_MSG_PUB.Add_Exc_Msg
2443: ( G_PKG_NAME

Line 2440: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2436: EXCEPTION
2437: WHEN OTHERS THEN
2438: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2439: IF OE_MSG_PUB.Check_Msg_Level
2440: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2441: THEN
2442: OE_MSG_PUB.Add_Exc_Msg
2443: ( G_PKG_NAME
2444: , 'Get_Ship_Method'

Line 2442: OE_MSG_PUB.Add_Exc_Msg

2438: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2439: IF OE_MSG_PUB.Check_Msg_Level
2440: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2441: THEN
2442: OE_MSG_PUB.Add_Exc_Msg
2443: ( G_PKG_NAME
2444: , 'Get_Ship_Method'
2445: );
2446: END IF;

Line 2514: IF OE_MSG_PUB.Check_Msg_Level

2510:
2511: EXCEPTION
2512: WHEN OTHERS THEN
2513: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2514: IF OE_MSG_PUB.Check_Msg_Level
2515: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2516: THEN
2517: OE_MSG_PUB.Add_Exc_Msg
2518: ( G_PKG_NAME

Line 2515: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2511: EXCEPTION
2512: WHEN OTHERS THEN
2513: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2514: IF OE_MSG_PUB.Check_Msg_Level
2515: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2516: THEN
2517: OE_MSG_PUB.Add_Exc_Msg
2518: ( G_PKG_NAME
2519: ,'Fulfillment_Sets'

Line 2517: OE_MSG_PUB.Add_Exc_Msg

2513: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2514: IF OE_MSG_PUB.Check_Msg_Level
2515: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2516: THEN
2517: OE_MSG_PUB.Add_Exc_Msg
2518: ( G_PKG_NAME
2519: ,'Fulfillment_Sets'
2520: );
2521: END IF;

Line 2736: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

2732: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2733: WHEN FND_API.G_EXC_ERROR THEN
2734: x_return_status := FND_API.G_RET_STS_ERROR;
2735: WHEN OTHERS THEN
2736: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2737: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME , 'FIRST_PERIOD_BILL_AMT' );
2738: END IF;
2739: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2740: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2737: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME , 'FIRST_PERIOD_BILL_AMT' );

2733: WHEN FND_API.G_EXC_ERROR THEN
2734: x_return_status := FND_API.G_RET_STS_ERROR;
2735: WHEN OTHERS THEN
2736: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2737: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME , 'FIRST_PERIOD_BILL_AMT' );
2738: END IF;
2739: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2740: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2741: END first_period_bill_amt;

Line 2761: OE_MSG_PUB.set_msg_context ( p_entity_code => 'LINE'

2757: BEGIN
2758:
2759: oe_debug_pub.add('Entering UTIL.Update_Shipping'||p_line_id, 1);
2760: -- bug 4741573
2761: OE_MSG_PUB.set_msg_context ( p_entity_code => 'LINE'
2762: ,p_entity_id => p_line_id
2763: ,p_line_id => p_line_id );
2764:
2765: l_update_shipping_index := p_update_shipping_tbl.FIRST;

Line 2825: OE_MSG_PUB.reset_msg_context('LINE');

2821: END LOOP;
2822: END IF;
2823:
2824: -- bug 4741573
2825: OE_MSG_PUB.reset_msg_context('LINE');
2826:
2827: OE_Debug_PUB.Add('Exiting OE_Delayed_Requests_Util.Update_Shipping',1);
2828: EXCEPTION
2829: WHEN OTHERS THEN

Line 2832: IF OE_MSG_PUB.Check_Msg_Level

2828: EXCEPTION
2829: WHEN OTHERS THEN
2830: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2831:
2832: IF OE_MSG_PUB.Check_Msg_Level
2833: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2834: THEN
2835: OE_MSG_PUB.Add_Exc_Msg
2836: ( G_PKG_NAME

Line 2833: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2829: WHEN OTHERS THEN
2830: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2831:
2832: IF OE_MSG_PUB.Check_Msg_Level
2833: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2834: THEN
2835: OE_MSG_PUB.Add_Exc_Msg
2836: ( G_PKG_NAME
2837: , 'Update_Shipping'

Line 2835: OE_MSG_PUB.Add_Exc_Msg

2831:
2832: IF OE_MSG_PUB.Check_Msg_Level
2833: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2834: THEN
2835: OE_MSG_PUB.Add_Exc_Msg
2836: ( G_PKG_NAME
2837: , 'Update_Shipping'
2838: );
2839: END IF;

Line 2900: IF OE_MSG_PUB.Check_Msg_Level

2896:
2897: EXCEPTION
2898: WHEN OTHERS THEN
2899: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2900: IF OE_MSG_PUB.Check_Msg_Level
2901: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2902: THEN
2903: OE_MSG_PUB.Add_Exc_Msg
2904: ( G_PKG_NAME

Line 2901: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2897: EXCEPTION
2898: WHEN OTHERS THEN
2899: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2900: IF OE_MSG_PUB.Check_Msg_Level
2901: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2902: THEN
2903: OE_MSG_PUB.Add_Exc_Msg
2904: ( G_PKG_NAME
2905: , 'Ship_Confirmation'

Line 2903: OE_MSG_PUB.Add_Exc_Msg

2899: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2900: IF OE_MSG_PUB.Check_Msg_Level
2901: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2902: THEN
2903: OE_MSG_PUB.Add_Exc_Msg
2904: ( G_PKG_NAME
2905: , 'Ship_Confirmation'
2906: );
2907: END IF;

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

3151: x_return_status := FND_API.G_RET_STS_ERROR;
3152:
3153: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3154:
3155: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3156: THEN
3157: OE_MSG_PUB.Add_Exc_Msg
3158: ( G_PKG_NAME
3159: , 'Group_Schedule'

Line 3157: OE_MSG_PUB.Add_Exc_Msg

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

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

3163:
3164: WHEN OTHERS THEN
3165:
3166:
3167: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3168: THEN
3169: OE_MSG_PUB.Add_Exc_Msg
3170: ( G_PKG_NAME
3171: , 'Group_Schedule'

Line 3169: OE_MSG_PUB.Add_Exc_Msg

3165:
3166:
3167: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3168: THEN
3169: OE_MSG_PUB.Add_Exc_Msg
3170: ( G_PKG_NAME
3171: , 'Group_Schedule'
3172: );
3173: END IF;

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

3464: WHEN OTHERS THEN
3465:
3466: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3467:
3468: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3469: THEN
3470: OE_MSG_PUB.Add_Exc_Msg
3471: ( G_PKG_NAME
3472: , 'INSERT_RMA_OPTIONS_INCLUDED'

Line 3470: OE_MSG_PUB.Add_Exc_Msg

3466: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3467:
3468: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3469: THEN
3470: OE_MSG_PUB.Add_Exc_Msg
3471: ( G_PKG_NAME
3472: , 'INSERT_RMA_OPTIONS_INCLUDED'
3473: );
3474: END IF;

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

3872: WHEN OTHERS THEN
3873:
3874: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3875:
3876: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3877: THEN
3878: OE_MSG_PUB.Add_Exc_Msg
3879: ( G_PKG_NAME
3880: , 'INSERT_RMA_LOT_SERIAL'

Line 3878: OE_MSG_PUB.Add_Exc_Msg

3874: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3875:
3876: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3877: THEN
3878: OE_MSG_PUB.Add_Exc_Msg
3879: ( G_PKG_NAME
3880: , 'INSERT_RMA_LOT_SERIAL'
3881: );
3882: END IF;

Line 3956: OE_MSG_PUB.ADD;

3952: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',
3953: to_char(l_line_tbl(I).shipment_number));
3954: FND_MESSAGE.SET_TOKEN('PARENT_LINE_NUMBER',
3955: to_char(l_line_tbl(I).line_number));
3956: OE_MSG_PUB.ADD;
3957: RAISE FND_API.G_EXC_ERROR;
3958: ELSIF (l_line_tbl(I).order_quantity_uom <>
3959: l_order_qty_uom ) THEN
3960: FND_MESSAGE.SET_NAME('ONT','OE_VAL_LINE_SET_ATTR');

Line 3966: OE_MSG_PUB.ADD;

3962: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',
3963: to_char(l_line_tbl(I).shipment_number));
3964: FND_MESSAGE.SET_TOKEN('PARENT_LINE_NUMBER',
3965: to_char(l_line_tbl(I).line_number));
3966: OE_MSG_PUB.ADD;
3967: RAISE FND_API.G_EXC_ERROR;
3968: ELSIF (l_line_tbl(I).line_type_id <>
3969: l_line_type_id ) THEN
3970: FND_MESSAGE.SET_NAME('ONT','OE_VAL_LINE_SET_ATTR');

Line 3976: OE_MSG_PUB.ADD;

3972: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',
3973: to_char(l_line_tbl(I).shipment_number));
3974: FND_MESSAGE.SET_TOKEN('PARENT_LINE_NUMBER',
3975: to_char(l_line_tbl(I).line_number));
3976: OE_MSG_PUB.ADD;
3977: RAISE FND_API.G_EXC_ERROR;
3978: ELSIF (l_line_tbl(I).ship_tolerance_above <>
3979: l_ship_tolerance_above ) THEN
3980: FND_MESSAGE.SET_NAME('ONT','OE_VAL_LINE_SET_ATTR');

Line 3986: OE_MSG_PUB.ADD;

3982: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',
3983: to_char(l_line_tbl(I).shipment_number));
3984: FND_MESSAGE.SET_TOKEN('PARENT_LINE_NUMBER',
3985: to_char(l_line_tbl(I).line_number));
3986: OE_MSG_PUB.ADD;
3987: RAISE FND_API.G_EXC_ERROR;
3988: ELSIF (l_line_tbl(I).ship_tolerance_below <>
3989: l_ship_tolerance_below ) THEN
3990: FND_MESSAGE.SET_NAME('ONT','OE_VAL_LINE_SET_ATTR');

Line 3996: OE_MSG_PUB.ADD;

3992: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',
3993: to_char(l_line_tbl(I).shipment_number));
3994: FND_MESSAGE.SET_TOKEN('PARENT_LINE_NUMBER',
3995: to_char(l_line_tbl(I).line_number));
3996: OE_MSG_PUB.ADD;
3997: RAISE FND_API.G_EXC_ERROR;
3998: ELSIF (l_line_tbl(I).project_id <>
3999: l_project_id ) THEN
4000: FND_MESSAGE.SET_NAME('ONT','OE_VAL_LINE_SET_ATTR');

Line 4006: OE_MSG_PUB.ADD;

4002: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',
4003: to_char(l_line_tbl(I).shipment_number));
4004: FND_MESSAGE.SET_TOKEN('PARENT_LINE_NUMBER',
4005: to_char(l_line_tbl(I).line_number));
4006: OE_MSG_PUB.ADD;
4007: RAISE FND_API.G_EXC_ERROR;
4008: ELSIF (l_line_tbl(I).Task_id <>
4009: l_Task_id ) THEN
4010: FND_MESSAGE.SET_NAME('ONT','OE_VAL_LINE_SET_ATTR');

Line 4016: OE_MSG_PUB.ADD;

4012: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',
4013: to_char(l_line_tbl(I).shipment_number));
4014: FND_MESSAGE.SET_TOKEN('PARENT_LINE_NUMBER',
4015: to_char(l_line_tbl(I).line_number));
4016: OE_MSG_PUB.ADD;
4017: RAISE FND_API.G_EXC_ERROR;
4018: ----ER#14763609
4019: ELSIF (Nvl(l_line_tbl(I).fulfillment_base,'P') <> l_fulfillment_base) THEN
4020: FND_MESSAGE.SET_NAME('ONT','OE_VAL_LINE_SET_ATTR');

Line 4026: OE_MSG_PUB.ADD;

4022: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',
4023: to_char(l_line_tbl(I).shipment_number));
4024: FND_MESSAGE.SET_TOKEN('PARENT_LINE_NUMBER',
4025: to_char(l_line_tbl(I).line_number));
4026: OE_MSG_PUB.ADD;
4027: RAISE FND_API.G_EXC_ERROR;
4028: --END ER#14763609
4029: END IF;
4030: END IF; -- For Bug 5754554

Line 4037: OE_MSG_PUB.reset_msg_context('SPLIT');

4033: oe_debug_pub.add('Exiting oe_delayed_requests_util.Validate_Line_Set',1);
4034: EXCEPTION
4035: WHEN FND_API.G_EXC_ERROR THEN
4036:
4037: OE_MSG_PUB.reset_msg_context('SPLIT');
4038: RAISE;
4039:
4040: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4041:

Line 4042: OE_MSG_PUB.reset_msg_context('SPLIT');

4038: RAISE;
4039:
4040: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4041:
4042: OE_MSG_PUB.reset_msg_context('SPLIT');
4043: RAISE;
4044:
4045:
4046: WHEN OTHERS THEN

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

4043: RAISE;
4044:
4045:
4046: WHEN OTHERS THEN
4047: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4048: THEN
4049: OE_MSG_PUB.Add_Exc_Msg
4050: ( G_PKG_NAME ,
4051: 'Validate Line Set'

Line 4049: OE_MSG_PUB.Add_Exc_Msg

4045:
4046: WHEN OTHERS THEN
4047: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4048: THEN
4049: OE_MSG_PUB.Add_Exc_Msg
4050: ( G_PKG_NAME ,
4051: 'Validate Line Set'
4052: );
4053: END IF;

Line 4187: OE_MSG_PUB.Count_And_Get

4183: x_return_status := FND_API.G_RET_STS_ERROR;
4184:
4185: -- Get message count and data
4186:
4187: OE_MSG_PUB.Count_And_Get
4188: ( p_count => x_msg_count
4189: , p_data => x_msg_data
4190: );
4191:

Line 4197: OE_MSG_PUB.Count_And_Get

4193:
4194: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4195: -- Get message count and data
4196:
4197: OE_MSG_PUB.Count_And_Get
4198: ( p_count => x_msg_count
4199: , p_data => x_msg_data
4200: );
4201:

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

4202: WHEN OTHERS THEN
4203:
4204: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4205:
4206: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4207: THEN
4208: OE_MSG_PUB.Add_Exc_Msg
4209: ( G_PKG_NAME
4210: , 'Process_Adjustments'

Line 4208: OE_MSG_PUB.Add_Exc_Msg

4204: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4205:
4206: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4207: THEN
4208: OE_MSG_PUB.Add_Exc_Msg
4209: ( G_PKG_NAME
4210: , 'Process_Adjustments'
4211: );
4212: END IF;

Line 4215: OE_MSG_PUB.Count_And_Get

4211: );
4212: END IF;
4213: -- Get message count and data
4214:
4215: OE_MSG_PUB.Count_And_Get
4216: ( p_count => x_msg_count
4217: , p_data => x_msg_data
4218: );
4219:

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

4606:
4607: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4608: oe_debug_pub.add('Inside exception other error ',1);
4609:
4610: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4611: THEN
4612: OE_MSG_PUB.Add_Exc_Msg
4613: ( G_PKG_NAME
4614: , 'INSERT_SERVICE_FOR_OPTIONS'

Line 4612: OE_MSG_PUB.Add_Exc_Msg

4608: oe_debug_pub.add('Inside exception other error ',1);
4609:
4610: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4611: THEN
4612: OE_MSG_PUB.Add_Exc_Msg
4613: ( G_PKG_NAME
4614: , 'INSERT_SERVICE_FOR_OPTIONS'
4615: );
4616: END IF;

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

4853:
4854: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4855: oe_debug_pub.add('Inside exception other error ',1);
4856:
4857: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4858: THEN
4859: OE_MSG_PUB.Add_Exc_Msg
4860: ( G_PKG_NAME
4861: , 'CASCADE_SERVICE_FOR_OPTIONS'

Line 4859: OE_MSG_PUB.Add_Exc_Msg

4855: oe_debug_pub.add('Inside exception other error ',1);
4856:
4857: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4858: THEN
4859: OE_MSG_PUB.Add_Exc_Msg
4860: ( G_PKG_NAME
4861: , 'CASCADE_SERVICE_FOR_OPTIONS'
4862: );
4863: END IF;

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

4905: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4906: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4907: WHEN OTHERS THEN
4908: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4909: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4910: THEN
4911: OE_MSG_PUB.Add_Exc_Msg
4912: ( G_PKG_NAME
4913: , 'Apply_Automatic_Attachments'

Line 4911: OE_MSG_PUB.Add_Exc_Msg

4907: WHEN OTHERS THEN
4908: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4909: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4910: THEN
4911: OE_MSG_PUB.Add_Exc_Msg
4912: ( G_PKG_NAME
4913: , 'Apply_Automatic_Attachments'
4914: );
4915: END IF;

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

4952: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4953: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4954: WHEN OTHERS THEN
4955: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4956: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4957: THEN
4958: OE_MSG_PUB.Add_Exc_Msg
4959: ( G_PKG_NAME
4960: , 'Copy_Attachments'

Line 4958: OE_MSG_PUB.Add_Exc_Msg

4954: WHEN OTHERS THEN
4955: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4956: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4957: THEN
4958: OE_MSG_PUB.Add_Exc_Msg
4959: ( G_PKG_NAME
4960: , 'Copy_Attachments'
4961: );
4962: END IF;

Line 5255: OE_MSG_PUB.Add;

5251:
5252: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
5253:
5254: fnd_message.set_name('ONT','OE_SCH_SET_INS_FAILED');
5255: OE_MSG_PUB.Add;
5256:
5257: IF p_sch_set_tbl(I).request_type = OE_GLOBALS.G_SCHEDULE_LINE
5258: THEN
5259:

Line 5302: OE_MSG_PUB.Add;

5298:
5299: -- Bug 2185769
5300: oe_debug_pub.add('Before failing the line',1);
5301: fnd_message.set_name('ONT','OE_SCH_SET_INS_FAILED');
5302: OE_MSG_PUB.Add;
5303:
5304: END IF;
5305:
5306: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 5317: OE_MSG_PUB.Add;

5313: -- to a scheduled ATO or SMC PTO if it cannot be scheduled on
5314: -- the same date as that of the model.
5315:
5316: fnd_message.set_name('ONT','OE_SCH_SET_INS_FAILED');
5317: OE_MSG_PUB.Add;
5318:
5319: RAISE FND_API.G_EXC_ERROR;
5320:
5321:

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

5332: x_return_status := FND_API.G_RET_STS_ERROR;
5333:
5334: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5335:
5336: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5337: THEN
5338: OE_MSG_PUB.Add_Exc_Msg
5339: ( G_PKG_NAME
5340: , 'Schedule_Line'

Line 5338: OE_MSG_PUB.Add_Exc_Msg

5334: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5335:
5336: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5337: THEN
5338: OE_MSG_PUB.Add_Exc_Msg
5339: ( G_PKG_NAME
5340: , 'Schedule_Line'
5341: );
5342: END IF;

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

5344:
5345: WHEN OTHERS THEN
5346:
5347:
5348: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5349: THEN
5350: OE_MSG_PUB.Add_Exc_Msg
5351: ( G_PKG_NAME
5352: , 'Schedule_Line'

Line 5350: OE_MSG_PUB.Add_Exc_Msg

5346:
5347:
5348: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5349: THEN
5350: OE_MSG_PUB.Add_Exc_Msg
5351: ( G_PKG_NAME
5352: , 'Schedule_Line'
5353: );
5354: END IF;

Line 5971: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

5967: oe_debug_pub.add('Tax_Order: In No DATA Found',2);
5968: END IF;
5969: x_return_status := FND_API.G_RET_STS_SUCCESS;
5970: WHEN OTHERS THEN
5971: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5972: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME , 'Tax Header' );
5973: END IF;
5974: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5975: l_tax_rec_out_tbl.delete;

Line 5972: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME , 'Tax Header' );

5968: END IF;
5969: x_return_status := FND_API.G_RET_STS_SUCCESS;
5970: WHEN OTHERS THEN
5971: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5972: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME , 'Tax Header' );
5973: END IF;
5974: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5975: l_tax_rec_out_tbl.delete;
5976: l_l_line_adj_tbl.delete;

Line 6092: OE_MSG_PUB.Add;

6088: LOOP
6089: j := j+1;
6090: IF cur_ord_line.item_type_code <> OE_GLOBALS.G_ITEM_STANDARD THEN
6091: fnd_message.set_name('ONT','ONT_ISO_ITEM_TYPE_NOT_STD');
6092: OE_MSG_PUB.Add;
6093: x_return_status := FND_API.G_RET_STS_ERROR;
6094: RAISE FND_API.G_EXC_ERROR;
6095: END IF;
6096: --get the destination organization id and deliver to location id for this order line

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

6189: --oe_debug_pub.add('auto_create_internal_req: In No DATA Found',2);
6190:
6191: WHEN OTHERS THEN
6192: oe_debug_pub.add('auto_create_internal_req: In Other error',2);
6193: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6194: THEN
6195: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,'auto_create_internal_req');
6196: END IF;
6197: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 6195: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,'auto_create_internal_req');

6191: WHEN OTHERS THEN
6192: oe_debug_pub.add('auto_create_internal_req: In Other error',2);
6193: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6194: THEN
6195: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,'auto_create_internal_req');
6196: END IF;
6197: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6198:
6199: END auto_create_internal_req;

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

6357:
6358: WHEN OTHERS THEN
6359:
6360: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6361: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6362: THEN
6363: OE_MSG_PUB.Add_Exc_Msg
6364: ( G_PKG_NAME
6365: , 'Reverse_Limits'

Line 6363: OE_MSG_PUB.Add_Exc_Msg

6359:
6360: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6361: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6362: THEN
6363: OE_MSG_PUB.Add_Exc_Msg
6364: ( G_PKG_NAME
6365: , 'Reverse_Limits'
6366: );
6367: END IF;

Line 6980: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

6976: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6977: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6978: WHEN OTHERS THEN
6979: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6980: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6981: OE_MSG_PUB.Add_Exc_Msg
6982: ( G_PKG_NAME
6983: , 'Update_Requisition_Info'
6984: );

Line 6981: OE_MSG_PUB.Add_Exc_Msg

6977: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6978: WHEN OTHERS THEN
6979: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6980: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6981: OE_MSG_PUB.Add_Exc_Msg
6982: ( G_PKG_NAME
6983: , 'Update_Requisition_Info'
6984: );
6985: END IF;

Line 7035: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

7031: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7032: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7033: WHEN OTHERS THEN
7034: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7035: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
7036: OE_MSG_PUB.Add_Exc_Msg
7037: ( G_PKG_NAME
7038: , 'Process_Pre_Exploded_Kits'
7039: );

Line 7036: OE_MSG_PUB.Add_Exc_Msg

7032: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7033: WHEN OTHERS THEN
7034: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7035: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
7036: OE_MSG_PUB.Add_Exc_Msg
7037: ( G_PKG_NAME
7038: , 'Process_Pre_Exploded_Kits'
7039: );
7040: END IF;