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 91: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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

Line 93: OE_MSG_PUB.Add_Exc_Msg

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

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

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

Line 137: OE_MSG_PUB.Add_Exc_Msg

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

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

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

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

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

Line 487: OE_MSG_PUB.Add_Exc_Msg

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

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

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

Line 559: OE_MSG_PUB.Add;

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

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

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

Line 587: OE_MSG_PUB.Add;

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

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

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

Line 614: OE_MSG_PUB.Add_Exc_Msg

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

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

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

Line 705: OE_MSG_PUB.Add;

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

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

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

Line 734: OE_MSG_PUB.Add;

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

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

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

Line 771: OE_MSG_PUB.Add;

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

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

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

Line 802: OE_MSG_PUB.Add_Exc_Msg

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

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

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

Line 905: OE_MSG_PUB.Add;

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

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

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

Line 944: OE_MSG_PUB.Add;

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

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

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

Line 1021: OE_MSG_PUB.Add_Exc_Msg

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

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

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

Line 1145: OE_MSG_PUB.Add_Exc_Msg

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

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

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

Line 1216: OE_MSG_PUB.Add_Exc_Msg

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

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

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

Line 1426: OE_MSG_PUB.Add_Exc_Msg

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

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

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

Line 1733: OE_MSG_PUB.Add_Exc_Msg

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

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

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

Line 1800: OE_MSG_PUB.Add_Exc_Msg

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

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

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

Line 1872: OE_MSG_PUB.Add_Exc_Msg

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

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

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

Line 2025: OE_MSG_PUB.Add_Exc_Msg

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

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

2170: WHEN OTHERS THEN
2171:
2172: l_request_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2173: x_request_rec := l_request_rec;
2174: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2175: THEN
2176: OE_MSG_PUB.Add_Exc_Msg
2177: ( G_PKG_NAME
2178: , 'Release_Hold'

Line 2176: OE_MSG_PUB.Add_Exc_Msg

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

Line 2219: OE_MSG_PUB.Count_And_Get

2215: x_return_status := FND_API.G_RET_STS_ERROR;
2216:
2217: -- Get message count and data
2218:
2219: OE_MSG_PUB.Count_And_Get
2220: ( p_count => x_msg_count
2221: , p_data => x_msg_data
2222: );
2223:

Line 2229: OE_MSG_PUB.Count_And_Get

2225:
2226: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2227: -- Get message count and data
2228:
2229: OE_MSG_PUB.Count_And_Get
2230: ( p_count => x_msg_count
2231: , p_data => x_msg_data
2232: );
2233:

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

2234: WHEN OTHERS THEN
2235:
2236: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2237:
2238: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2239: THEN
2240: OE_MSG_PUB.Add_Exc_Msg
2241: ( G_PKG_NAME
2242: , 'Split_Set'

Line 2240: OE_MSG_PUB.Add_Exc_Msg

2236: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2237:
2238: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2239: THEN
2240: OE_MSG_PUB.Add_Exc_Msg
2241: ( G_PKG_NAME
2242: , 'Split_Set'
2243: );
2244: END IF;

Line 2248: OE_MSG_PUB.Count_And_Get

2244: END IF;
2245:
2246: -- Get message count and data
2247:
2248: OE_MSG_PUB.Count_And_Get
2249: ( p_count => x_msg_count
2250: , p_data => x_msg_data
2251: );
2252:

Line 2288: OE_MSG_PUB.Count_And_Get

2284: x_return_status := FND_API.G_RET_STS_ERROR;
2285:
2286: -- Get message count and data
2287:
2288: OE_MSG_PUB.Count_And_Get
2289: ( p_count => x_msg_count
2290: , p_data => x_msg_data
2291: );
2292:

Line 2298: OE_MSG_PUB.Count_And_Get

2294:
2295: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2296: -- Get message count and data
2297:
2298: OE_MSG_PUB.Count_And_Get
2299: ( p_count => x_msg_count
2300: , p_data => x_msg_data
2301: );
2302:

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

2303: WHEN OTHERS THEN
2304:
2305: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2306:
2307: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2308: THEN
2309: OE_MSG_PUB.Add_Exc_Msg
2310: ( G_PKG_NAME
2311: , 'Insert_Set'

Line 2309: OE_MSG_PUB.Add_Exc_Msg

2305: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2306:
2307: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2308: THEN
2309: OE_MSG_PUB.Add_Exc_Msg
2310: ( G_PKG_NAME
2311: , 'Insert_Set'
2312: );
2313: END IF;

Line 2316: OE_MSG_PUB.Count_And_Get

2312: );
2313: END IF;
2314: -- Get message count and data
2315:
2316: OE_MSG_PUB.Count_And_Get
2317: ( p_count => x_msg_count
2318: , p_data => x_msg_data
2319: );
2320:

Line 2349: IF OE_MSG_PUB.Check_Msg_Level

2345:
2346: EXCEPTION
2347: WHEN OTHERS THEN
2348: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2349: IF OE_MSG_PUB.Check_Msg_Level
2350: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2351: THEN
2352: OE_MSG_PUB.Add_Exc_Msg
2353: ( G_PKG_NAME

Line 2350: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2346: EXCEPTION
2347: WHEN OTHERS THEN
2348: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2349: IF OE_MSG_PUB.Check_Msg_Level
2350: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2351: THEN
2352: OE_MSG_PUB.Add_Exc_Msg
2353: ( G_PKG_NAME
2354: , 'Book_Order'

Line 2352: OE_MSG_PUB.Add_Exc_Msg

2348: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2349: IF OE_MSG_PUB.Check_Msg_Level
2350: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2351: THEN
2352: OE_MSG_PUB.Add_Exc_Msg
2353: ( G_PKG_NAME
2354: , 'Book_Order'
2355: );
2356: END IF;

Line 2424: OE_MSG_PUB.Add;

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

Line 2435: IF OE_MSG_PUB.Check_Msg_Level

2431:
2432: EXCEPTION
2433: WHEN OTHERS THEN
2434: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2435: IF OE_MSG_PUB.Check_Msg_Level
2436: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2437: THEN
2438: OE_MSG_PUB.Add_Exc_Msg
2439: ( G_PKG_NAME

Line 2436: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2432: EXCEPTION
2433: WHEN OTHERS THEN
2434: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2435: IF OE_MSG_PUB.Check_Msg_Level
2436: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2437: THEN
2438: OE_MSG_PUB.Add_Exc_Msg
2439: ( G_PKG_NAME
2440: , 'Get_Ship_Method'

Line 2438: OE_MSG_PUB.Add_Exc_Msg

2434: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2435: IF OE_MSG_PUB.Check_Msg_Level
2436: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2437: THEN
2438: OE_MSG_PUB.Add_Exc_Msg
2439: ( G_PKG_NAME
2440: , 'Get_Ship_Method'
2441: );
2442: END IF;

Line 2510: IF OE_MSG_PUB.Check_Msg_Level

2506:
2507: EXCEPTION
2508: WHEN OTHERS THEN
2509: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2510: IF OE_MSG_PUB.Check_Msg_Level
2511: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2512: THEN
2513: OE_MSG_PUB.Add_Exc_Msg
2514: ( G_PKG_NAME

Line 2511: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2507: EXCEPTION
2508: WHEN OTHERS THEN
2509: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2510: IF OE_MSG_PUB.Check_Msg_Level
2511: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2512: THEN
2513: OE_MSG_PUB.Add_Exc_Msg
2514: ( G_PKG_NAME
2515: ,'Fulfillment_Sets'

Line 2513: OE_MSG_PUB.Add_Exc_Msg

2509: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2510: IF OE_MSG_PUB.Check_Msg_Level
2511: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2512: THEN
2513: OE_MSG_PUB.Add_Exc_Msg
2514: ( G_PKG_NAME
2515: ,'Fulfillment_Sets'
2516: );
2517: END IF;

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

2536: BEGIN
2537:
2538: oe_debug_pub.add('Entering UTIL.Update_Shipping'||p_line_id, 1);
2539: -- bug 4741573
2540: OE_MSG_PUB.set_msg_context ( p_entity_code => 'LINE'
2541: ,p_entity_id => p_line_id
2542: ,p_line_id => p_line_id );
2543:
2544: l_update_shipping_index := p_update_shipping_tbl.FIRST;

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

2600: END LOOP;
2601: END IF;
2602:
2603: -- bug 4741573
2604: OE_MSG_PUB.reset_msg_context('LINE');
2605:
2606: OE_Debug_PUB.Add('Exiting OE_Delayed_Requests_Util.Update_Shipping',1);
2607: EXCEPTION
2608: WHEN OTHERS THEN

Line 2611: IF OE_MSG_PUB.Check_Msg_Level

2607: EXCEPTION
2608: WHEN OTHERS THEN
2609: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2610:
2611: IF OE_MSG_PUB.Check_Msg_Level
2612: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2613: THEN
2614: OE_MSG_PUB.Add_Exc_Msg
2615: ( G_PKG_NAME

Line 2612: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2608: WHEN OTHERS THEN
2609: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2610:
2611: IF OE_MSG_PUB.Check_Msg_Level
2612: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2613: THEN
2614: OE_MSG_PUB.Add_Exc_Msg
2615: ( G_PKG_NAME
2616: , 'Update_Shipping'

Line 2614: OE_MSG_PUB.Add_Exc_Msg

2610:
2611: IF OE_MSG_PUB.Check_Msg_Level
2612: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2613: THEN
2614: OE_MSG_PUB.Add_Exc_Msg
2615: ( G_PKG_NAME
2616: , 'Update_Shipping'
2617: );
2618: END IF;

Line 2679: IF OE_MSG_PUB.Check_Msg_Level

2675:
2676: EXCEPTION
2677: WHEN OTHERS THEN
2678: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2679: IF OE_MSG_PUB.Check_Msg_Level
2680: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2681: THEN
2682: OE_MSG_PUB.Add_Exc_Msg
2683: ( G_PKG_NAME

Line 2680: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2676: EXCEPTION
2677: WHEN OTHERS THEN
2678: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2679: IF OE_MSG_PUB.Check_Msg_Level
2680: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2681: THEN
2682: OE_MSG_PUB.Add_Exc_Msg
2683: ( G_PKG_NAME
2684: , 'Ship_Confirmation'

Line 2682: OE_MSG_PUB.Add_Exc_Msg

2678: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2679: IF OE_MSG_PUB.Check_Msg_Level
2680: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2681: THEN
2682: OE_MSG_PUB.Add_Exc_Msg
2683: ( G_PKG_NAME
2684: , 'Ship_Confirmation'
2685: );
2686: END IF;

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

2930: x_return_status := FND_API.G_RET_STS_ERROR;
2931:
2932: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2933:
2934: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2935: THEN
2936: OE_MSG_PUB.Add_Exc_Msg
2937: ( G_PKG_NAME
2938: , 'Group_Schedule'

Line 2936: OE_MSG_PUB.Add_Exc_Msg

2932: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2933:
2934: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2935: THEN
2936: OE_MSG_PUB.Add_Exc_Msg
2937: ( G_PKG_NAME
2938: , 'Group_Schedule'
2939: );
2940: END IF;

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

2942:
2943: WHEN OTHERS THEN
2944:
2945:
2946: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2947: THEN
2948: OE_MSG_PUB.Add_Exc_Msg
2949: ( G_PKG_NAME
2950: , 'Group_Schedule'

Line 2948: OE_MSG_PUB.Add_Exc_Msg

2944:
2945:
2946: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2947: THEN
2948: OE_MSG_PUB.Add_Exc_Msg
2949: ( G_PKG_NAME
2950: , 'Group_Schedule'
2951: );
2952: END IF;

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

3235: WHEN OTHERS THEN
3236:
3237: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3238:
3239: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3240: THEN
3241: OE_MSG_PUB.Add_Exc_Msg
3242: ( G_PKG_NAME
3243: , 'INSERT_RMA_OPTIONS_INCLUDED'

Line 3241: OE_MSG_PUB.Add_Exc_Msg

3237: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3238:
3239: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3240: THEN
3241: OE_MSG_PUB.Add_Exc_Msg
3242: ( G_PKG_NAME
3243: , 'INSERT_RMA_OPTIONS_INCLUDED'
3244: );
3245: END IF;

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

3607: WHEN OTHERS THEN
3608:
3609: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3610:
3611: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3612: THEN
3613: OE_MSG_PUB.Add_Exc_Msg
3614: ( G_PKG_NAME
3615: , 'INSERT_RMA_LOT_SERIAL'

Line 3613: OE_MSG_PUB.Add_Exc_Msg

3609: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3610:
3611: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3612: THEN
3613: OE_MSG_PUB.Add_Exc_Msg
3614: ( G_PKG_NAME
3615: , 'INSERT_RMA_LOT_SERIAL'
3616: );
3617: END IF;

Line 3689: OE_MSG_PUB.ADD;

3685: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',
3686: to_char(l_line_tbl(I).shipment_number));
3687: FND_MESSAGE.SET_TOKEN('PARENT_LINE_NUMBER',
3688: to_char(l_line_tbl(I).line_number));
3689: OE_MSG_PUB.ADD;
3690: RAISE FND_API.G_EXC_ERROR;
3691: ELSIF (l_line_tbl(I).order_quantity_uom <>
3692: l_order_qty_uom ) THEN
3693: FND_MESSAGE.SET_NAME('ONT','OE_VAL_LINE_SET_ATTR');

Line 3699: OE_MSG_PUB.ADD;

3695: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',
3696: to_char(l_line_tbl(I).shipment_number));
3697: FND_MESSAGE.SET_TOKEN('PARENT_LINE_NUMBER',
3698: to_char(l_line_tbl(I).line_number));
3699: OE_MSG_PUB.ADD;
3700: RAISE FND_API.G_EXC_ERROR;
3701: ELSIF (l_line_tbl(I).line_type_id <>
3702: l_line_type_id ) THEN
3703: FND_MESSAGE.SET_NAME('ONT','OE_VAL_LINE_SET_ATTR');

Line 3709: OE_MSG_PUB.ADD;

3705: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',
3706: to_char(l_line_tbl(I).shipment_number));
3707: FND_MESSAGE.SET_TOKEN('PARENT_LINE_NUMBER',
3708: to_char(l_line_tbl(I).line_number));
3709: OE_MSG_PUB.ADD;
3710: RAISE FND_API.G_EXC_ERROR;
3711: ELSIF (l_line_tbl(I).ship_tolerance_above <>
3712: l_ship_tolerance_above ) THEN
3713: FND_MESSAGE.SET_NAME('ONT','OE_VAL_LINE_SET_ATTR');

Line 3719: OE_MSG_PUB.ADD;

3715: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',
3716: to_char(l_line_tbl(I).shipment_number));
3717: FND_MESSAGE.SET_TOKEN('PARENT_LINE_NUMBER',
3718: to_char(l_line_tbl(I).line_number));
3719: OE_MSG_PUB.ADD;
3720: RAISE FND_API.G_EXC_ERROR;
3721: ELSIF (l_line_tbl(I).ship_tolerance_below <>
3722: l_ship_tolerance_below ) THEN
3723: FND_MESSAGE.SET_NAME('ONT','OE_VAL_LINE_SET_ATTR');

Line 3729: OE_MSG_PUB.ADD;

3725: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',
3726: to_char(l_line_tbl(I).shipment_number));
3727: FND_MESSAGE.SET_TOKEN('PARENT_LINE_NUMBER',
3728: to_char(l_line_tbl(I).line_number));
3729: OE_MSG_PUB.ADD;
3730: RAISE FND_API.G_EXC_ERROR;
3731: ELSIF (l_line_tbl(I).project_id <>
3732: l_project_id ) THEN
3733: FND_MESSAGE.SET_NAME('ONT','OE_VAL_LINE_SET_ATTR');

Line 3739: OE_MSG_PUB.ADD;

3735: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',
3736: to_char(l_line_tbl(I).shipment_number));
3737: FND_MESSAGE.SET_TOKEN('PARENT_LINE_NUMBER',
3738: to_char(l_line_tbl(I).line_number));
3739: OE_MSG_PUB.ADD;
3740: RAISE FND_API.G_EXC_ERROR;
3741: ELSIF (l_line_tbl(I).Task_id <>
3742: l_Task_id ) THEN
3743: FND_MESSAGE.SET_NAME('ONT','OE_VAL_LINE_SET_ATTR');

Line 3749: OE_MSG_PUB.ADD;

3745: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',
3746: to_char(l_line_tbl(I).shipment_number));
3747: FND_MESSAGE.SET_TOKEN('PARENT_LINE_NUMBER',
3748: to_char(l_line_tbl(I).line_number));
3749: OE_MSG_PUB.ADD;
3750: RAISE FND_API.G_EXC_ERROR;
3751: END IF;
3752: END IF; -- For Bug 5754554
3753: END LOOP;

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

3755: oe_debug_pub.add('Exiting oe_delayed_requests_util.Validate_Line_Set',1);
3756: EXCEPTION
3757: WHEN FND_API.G_EXC_ERROR THEN
3758:
3759: OE_MSG_PUB.reset_msg_context('SPLIT');
3760: RAISE;
3761:
3762: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3763:

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

3760: RAISE;
3761:
3762: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3763:
3764: OE_MSG_PUB.reset_msg_context('SPLIT');
3765: RAISE;
3766:
3767:
3768: WHEN OTHERS THEN

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

3765: RAISE;
3766:
3767:
3768: WHEN OTHERS THEN
3769: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3770: THEN
3771: OE_MSG_PUB.Add_Exc_Msg
3772: ( G_PKG_NAME ,
3773: 'Validate Line Set'

Line 3771: OE_MSG_PUB.Add_Exc_Msg

3767:
3768: WHEN OTHERS THEN
3769: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3770: THEN
3771: OE_MSG_PUB.Add_Exc_Msg
3772: ( G_PKG_NAME ,
3773: 'Validate Line Set'
3774: );
3775: END IF;

Line 3909: OE_MSG_PUB.Count_And_Get

3905: x_return_status := FND_API.G_RET_STS_ERROR;
3906:
3907: -- Get message count and data
3908:
3909: OE_MSG_PUB.Count_And_Get
3910: ( p_count => x_msg_count
3911: , p_data => x_msg_data
3912: );
3913:

Line 3919: OE_MSG_PUB.Count_And_Get

3915:
3916: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3917: -- Get message count and data
3918:
3919: OE_MSG_PUB.Count_And_Get
3920: ( p_count => x_msg_count
3921: , p_data => x_msg_data
3922: );
3923:

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

3924: WHEN OTHERS THEN
3925:
3926: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3927:
3928: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3929: THEN
3930: OE_MSG_PUB.Add_Exc_Msg
3931: ( G_PKG_NAME
3932: , 'Process_Adjustments'

Line 3930: OE_MSG_PUB.Add_Exc_Msg

3926: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3927:
3928: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3929: THEN
3930: OE_MSG_PUB.Add_Exc_Msg
3931: ( G_PKG_NAME
3932: , 'Process_Adjustments'
3933: );
3934: END IF;

Line 3937: OE_MSG_PUB.Count_And_Get

3933: );
3934: END IF;
3935: -- Get message count and data
3936:
3937: OE_MSG_PUB.Count_And_Get
3938: ( p_count => x_msg_count
3939: , p_data => x_msg_data
3940: );
3941:

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

4261:
4262: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4263: oe_debug_pub.add('Inside exception other error ',1);
4264:
4265: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4266: THEN
4267: OE_MSG_PUB.Add_Exc_Msg
4268: ( G_PKG_NAME
4269: , 'INSERT_SERVICE_FOR_OPTIONS'

Line 4267: OE_MSG_PUB.Add_Exc_Msg

4263: oe_debug_pub.add('Inside exception other error ',1);
4264:
4265: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4266: THEN
4267: OE_MSG_PUB.Add_Exc_Msg
4268: ( G_PKG_NAME
4269: , 'INSERT_SERVICE_FOR_OPTIONS'
4270: );
4271: END IF;

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

4478:
4479: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4480: oe_debug_pub.add('Inside exception other error ',1);
4481:
4482: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4483: THEN
4484: OE_MSG_PUB.Add_Exc_Msg
4485: ( G_PKG_NAME
4486: , 'CASCADE_SERVICE_FOR_OPTIONS'

Line 4484: OE_MSG_PUB.Add_Exc_Msg

4480: oe_debug_pub.add('Inside exception other error ',1);
4481:
4482: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4483: THEN
4484: OE_MSG_PUB.Add_Exc_Msg
4485: ( G_PKG_NAME
4486: , 'CASCADE_SERVICE_FOR_OPTIONS'
4487: );
4488: END IF;

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

4530: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4531: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4532: WHEN OTHERS THEN
4533: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4534: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4535: THEN
4536: OE_MSG_PUB.Add_Exc_Msg
4537: ( G_PKG_NAME
4538: , 'Apply_Automatic_Attachments'

Line 4536: OE_MSG_PUB.Add_Exc_Msg

4532: WHEN OTHERS THEN
4533: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4534: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4535: THEN
4536: OE_MSG_PUB.Add_Exc_Msg
4537: ( G_PKG_NAME
4538: , 'Apply_Automatic_Attachments'
4539: );
4540: END IF;

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

4577: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4578: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4579: WHEN OTHERS THEN
4580: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4581: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4582: THEN
4583: OE_MSG_PUB.Add_Exc_Msg
4584: ( G_PKG_NAME
4585: , 'Copy_Attachments'

Line 4583: OE_MSG_PUB.Add_Exc_Msg

4579: WHEN OTHERS THEN
4580: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4581: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4582: THEN
4583: OE_MSG_PUB.Add_Exc_Msg
4584: ( G_PKG_NAME
4585: , 'Copy_Attachments'
4586: );
4587: END IF;

Line 4878: OE_MSG_PUB.Add;

4874:
4875: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
4876:
4877: fnd_message.set_name('ONT','OE_SCH_SET_INS_FAILED');
4878: OE_MSG_PUB.Add;
4879:
4880: IF p_sch_set_tbl(I).request_type = OE_GLOBALS.G_SCHEDULE_LINE
4881: THEN
4882:

Line 4924: OE_MSG_PUB.Add;

4920:
4921: -- Bug 2185769
4922: oe_debug_pub.add('Before failing the line',1);
4923: fnd_message.set_name('ONT','OE_SCH_SET_INS_FAILED');
4924: OE_MSG_PUB.Add;
4925:
4926: END IF;
4927:
4928: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 4939: OE_MSG_PUB.Add;

4935: -- to a scheduled ATO or SMC PTO if it cannot be scheduled on
4936: -- the same date as that of the model.
4937:
4938: fnd_message.set_name('ONT','OE_SCH_SET_INS_FAILED');
4939: OE_MSG_PUB.Add;
4940:
4941: RAISE FND_API.G_EXC_ERROR;
4942:
4943:

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

4954: x_return_status := FND_API.G_RET_STS_ERROR;
4955:
4956: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4957:
4958: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4959: THEN
4960: OE_MSG_PUB.Add_Exc_Msg
4961: ( G_PKG_NAME
4962: , 'Schedule_Line'

Line 4960: OE_MSG_PUB.Add_Exc_Msg

4956: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4957:
4958: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4959: THEN
4960: OE_MSG_PUB.Add_Exc_Msg
4961: ( G_PKG_NAME
4962: , 'Schedule_Line'
4963: );
4964: END IF;

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

4966:
4967: WHEN OTHERS THEN
4968:
4969:
4970: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4971: THEN
4972: OE_MSG_PUB.Add_Exc_Msg
4973: ( G_PKG_NAME
4974: , 'Schedule_Line'

Line 4972: OE_MSG_PUB.Add_Exc_Msg

4968:
4969:
4970: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4971: THEN
4972: OE_MSG_PUB.Add_Exc_Msg
4973: ( G_PKG_NAME
4974: , 'Schedule_Line'
4975: );
4976: END IF;

Line 5164: OE_MSG_PUB.set_msg_context

5160: AND l.LINE_ID = l_line_id;
5161: -- incl. 3 parameters l_orig_sys_doc_ref,l_orig_sys_line_ref,l_order_src_id
5162: -- below to fix bug 2610630 and 2508851
5163:
5164: OE_MSG_PUB.set_msg_context
5165: ( p_entity_code => 'LINE'
5166: ,p_entity_id => l_line_id
5167: ,p_header_id => l_header_id
5168: ,p_line_id => l_line_id

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

5582: END IF;
5583: l_tax_rec_out_tbl.delete;
5584: l_l_line_adj_tbl.delete;
5585:
5586: OE_MSG_PUB.reset_msg_context('LINE');
5587:
5588: IF l_debug_level > 0 THEN
5589: oe_debug_pub.add('Exiting Process_Tax ',1);
5590: END IF;

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

5608: x_return_status := FND_API.G_RET_STS_SUCCESS;
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: 'Tax Header'

Line 5614: OE_MSG_PUB.Add_Exc_Msg

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: 'Tax Header'
5617: );
5618: END IF;

Line 5735: OE_MSG_PUB.Add;

5731: LOOP
5732: j := j+1;
5733: IF cur_ord_line.item_type_code <> OE_GLOBALS.G_ITEM_STANDARD THEN
5734: fnd_message.set_name('ONT','ONT_ISO_ITEM_TYPE_NOT_STD');
5735: OE_MSG_PUB.Add;
5736: x_return_status := FND_API.G_RET_STS_ERROR;
5737: RAISE FND_API.G_EXC_ERROR;
5738: END IF;
5739: --get the destination organization id and deliver to location id for this order line

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

5832: --oe_debug_pub.add('auto_create_internal_req: In No DATA Found',2);
5833:
5834: WHEN OTHERS THEN
5835: oe_debug_pub.add('auto_create_internal_req: In Other error',2);
5836: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5837: THEN
5838: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,'auto_create_internal_req');
5839: END IF;
5840: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

5834: WHEN OTHERS THEN
5835: oe_debug_pub.add('auto_create_internal_req: In Other error',2);
5836: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5837: THEN
5838: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,'auto_create_internal_req');
5839: END IF;
5840: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5841:
5842: END auto_create_internal_req;

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

6000:
6001: WHEN OTHERS THEN
6002:
6003: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6004: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6005: THEN
6006: OE_MSG_PUB.Add_Exc_Msg
6007: ( G_PKG_NAME
6008: , 'Reverse_Limits'

Line 6006: OE_MSG_PUB.Add_Exc_Msg

6002:
6003: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6004: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6005: THEN
6006: OE_MSG_PUB.Add_Exc_Msg
6007: ( G_PKG_NAME
6008: , 'Reverse_Limits'
6009: );
6010: END IF;

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

6610: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6611: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6612: WHEN OTHERS THEN
6613: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6614: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6615: OE_MSG_PUB.Add_Exc_Msg
6616: ( G_PKG_NAME
6617: , 'Update_Requisition_Info'
6618: );

Line 6615: OE_MSG_PUB.Add_Exc_Msg

6611: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6612: WHEN OTHERS THEN
6613: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6614: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6615: OE_MSG_PUB.Add_Exc_Msg
6616: ( G_PKG_NAME
6617: , 'Update_Requisition_Info'
6618: );
6619: END IF;