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_GROUP_SCH_UTIL dependencies on OE_MSG_PUB

Line 49: OE_MSG_PUB.Add;

45: IF l_debug_level > 0 THEN
46: oe_debug_pub.add('INVALID ITEM WAREHOUSE COMBINATION',3);
47: END IF;
48: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ITEM_WHSE');
49: OE_MSG_PUB.Add;
50: x_return_status := FND_API.G_RET_STS_ERROR;
51: END Validate_Item_Warehouse;
52:
53: /*---------------------------------------------------------------------

Line 89: OE_MSG_PUB.Add;

85: -- The line is cancelled. Cannot perform scheduling
86: -- on it.
87:
88: FND_MESSAGE.SET_NAME('ONT','OE_SCH_LINE_SHIPPED');
89: OE_MSG_PUB.Add;
90:
91: IF l_debug_level > 0 THEN
92: oe_debug_pub.add( ' SHIPPED LINE.' , 4 ) ;
93: END IF;

Line 112: OE_MSG_PUB.Add;

108: IF (p_line_rec.request_date is null OR
109: p_line_rec.request_date = FND_API.G_MISS_DATE) THEN
110:
111: FND_MESSAGE.SET_NAME('ONT','OE_SCH_MISSING_REQUEST_DATE');
112: OE_MSG_PUB.Add;
113: IF l_debug_level > 0 THEN
114: oe_debug_pub.add( 'REQUEST DATE IS MISSING' , 4 ) ;
115: END IF;
116: x_return_status := FND_API.G_RET_STS_ERROR;

Line 166: OE_MSG_PUB.Add;

162: END IF;
163:
164: IF (l_result = FND_API.G_TRUE) THEN
165: FND_MESSAGE.SET_NAME('ONT','OE_SCH_LINE_ON_HOLD');
166: OE_MSG_PUB.Add;
167: x_return_status := FND_API.G_RET_STS_ERROR;
168: IF l_debug_level > 0 THEN
169: oe_debug_pub.add( 'LINE IS ON HOLD' , 4 ) ;
170: END IF;

Line 199: OE_MSG_PUB.Add;

195: FND_MESSAGE.SET_TOKEN('ACTION', p_line_rec.schedule_action_code);
196: FND_MESSAGE.SET_TOKEN('ORDER_TYPE',
197: nvl(OE_SCHEDULE_UTIL.sch_cached_line_type,
198: OE_SCHEDULE_UTIL.sch_cached_order_type));
199: OE_MSG_PUB.Add;
200: x_return_status := FND_API.G_RET_STS_ERROR;
201: IF l_debug_level > 0 THEN
202: oe_debug_pub.add( 'LINE TYPE IS ATP ONLY' , 4 ) ;
203: END IF;

Line 217: OE_MSG_PUB.Add;

213: OE_SCHEDULE_UTIL.OESCH_ACT_RESERVE));
214: FND_MESSAGE.SET_TOKEN('ORDER_TYPE',
215: nvl(OE_SCHEDULE_UTIL.sch_cached_line_type,
216: OE_SCHEDULE_UTIL.sch_cached_order_type));
217: OE_MSG_PUB.Add;
218: x_return_status := FND_API.G_RET_STS_ERROR;
219: IF l_debug_level > 0 THEN
220: oe_debug_pub.add( 'LINE TYPE IS NOT ELIGIBLE FOR RESERVATION ' , 4 ) ;
221: END IF;

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

235: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
236:
237: WHEN OTHERS THEN
238:
239: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
240: THEN
241: OE_MSG_PUB.Add_Exc_Msg
242: ( G_PKG_NAME
243: , 'Validate_Group_Line'

Line 241: OE_MSG_PUB.Add_Exc_Msg

237: WHEN OTHERS THEN
238:
239: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
240: THEN
241: OE_MSG_PUB.Add_Exc_Msg
242: ( G_PKG_NAME
243: , 'Validate_Group_Line'
244: );
245: END IF;

Line 275: OE_MSG_PUB.set_msg_context

271: END IF;
272: x_return_status := FND_API.G_RET_STS_SUCCESS;
273: FOR I IN 1..p_x_line_tbl.count LOOP
274:
275: OE_MSG_PUB.set_msg_context
276: ( p_entity_code => 'LINE'
277: ,p_entity_id => p_x_line_tbl(I).line_id
278: ,p_header_id => p_x_line_tbl(I).header_id
279: ,p_line_id => p_x_line_tbl(I).line_id

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

364: EXCEPTION
365:
366: WHEN OTHERS THEN
367: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
368: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
369: THEN
370: OE_MSG_PUB.Add_Exc_Msg
371: ( G_PKG_NAME
372: , 'Validate_Group');

Line 370: OE_MSG_PUB.Add_Exc_Msg

366: WHEN OTHERS THEN
367: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
368: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
369: THEN
370: OE_MSG_PUB.Add_Exc_Msg
371: ( G_PKG_NAME
372: , 'Validate_Group');
373: END IF;
374:

Line 669: OE_MSG_PUB.set_msg_context

665: p_x_line_rec => l_line_rec,
666: x_return_status => l_return_status);
667:
668:
669: OE_MSG_PUB.set_msg_context
670: ( p_entity_code => 'LINE'
671: ,p_entity_id => l_line_rec.line_id
672: ,p_header_id => l_line_rec.header_id
673: ,p_line_id => l_line_rec.line_id

Line 759: OE_MSG_PUB.set_msg_context

755: p_x_line_rec => l_line_rec,
756: x_return_status => l_return_status);
757:
758:
759: OE_MSG_PUB.set_msg_context
760: ( p_entity_code => 'LINE'
761: ,p_entity_id => l_line_rec.line_id
762: ,p_header_id => l_line_rec.header_id
763: ,p_line_id => l_line_rec.line_id

Line 900: OE_MSG_PUB.Add;

896: END IF;
897: ELSE -- reservation exists
898:
899: FND_MESSAGE.SET_NAME('ONT','OE_SCH_NO_ACTION_DONE_NO_EXP');
900: OE_MSG_PUB.Add;
901: IF l_debug_level > 0 THEN
902: oe_debug_pub.add( 'LINE IS ALREADY RESERVED , DO NOT NEED RESERVATION :' || L_LINE_REC.RESERVED_QUANTITY ) ;
903: END IF;
904:

Line 925: OE_MSG_PUB.Add;

921: ELSE
922: FND_MESSAGE.SET_NAME('ONT','ONT_SCH_NOT_RESERVABLE');
923: END IF;
924: -- code fix for 3300528
925: OE_MSG_PUB.Add;
926:
927: END IF;
928: ELSE -- Line is not scheduled yet.
929:

Line 991: OE_MSG_PUB.set_msg_context

987: OE_Line_Util.Query_Row( p_line_id => c1.line_id
988: ,x_line_rec => l_line_rec);
989:
990:
991: OE_MSG_PUB.set_msg_context
992: ( p_entity_code => 'LINE'
993: ,p_entity_id => l_line_rec.line_id
994: ,p_header_id => l_line_rec.header_id
995: ,p_line_id => l_line_rec.line_id

Line 1091: OE_MSG_PUB.set_msg_context

1087:
1088: FOR c2 IN l_line_inc_csr LOOP
1089:
1090:
1091: OE_MSG_PUB.set_msg_context
1092: ( p_entity_code => 'LINE'
1093: ,p_entity_id => C2.line_id
1094: ,p_header_id => p_header_id
1095: ,p_line_id => C2.line_id

Line 1114: OE_MSG_PUB.Add;

1110: AND oe_schedule_util.Get_Pick_Status(c2.line_id)) THEN -- 2595661
1111:
1112:
1113: FND_MESSAGE.SET_NAME('ONT','OE_SCH_UNRSV_NOT_ALLOWED');
1114: OE_MSG_PUB.Add;
1115: IF l_debug_level > 0 THEN
1116: oe_debug_pub.add( 'LINE IS SHIPPING INTERFACED ' || C2.LINE_ID , 1 ) ;
1117: END IF;
1118:

Line 1130: OE_MSG_PUB.set_msg_context

1126: OE_Line_Util.Lock_Row(p_line_id => c2.line_id,
1127: p_x_line_rec => l_line_rec,
1128: x_return_status => l_return_status);
1129:
1130: OE_MSG_PUB.set_msg_context
1131: ( p_entity_code => 'LINE'
1132: ,p_entity_id => l_line_rec.line_id
1133: ,p_header_id => l_line_rec.header_id
1134: ,p_line_id => l_line_rec.line_id

Line 1240: OE_MSG_PUB.set_msg_context

1236: FOR c2 IN l_line_inc_csr LOOP
1237: -- If the line belong to set, and action is unschedule,
1238: -- ignore the line.
1239:
1240: OE_MSG_PUB.set_msg_context
1241: ( p_entity_code => 'LINE'
1242: ,p_entity_id => C2.line_id
1243: ,p_header_id => p_header_id
1244: ,p_line_id => C2.line_id

Line 1280: OE_MSG_PUB.set_msg_context

1276: OE_Line_Util.Lock_Row(p_line_id => c2.line_id,
1277: p_x_line_rec => l_line_rec,
1278: x_return_status => l_return_status);
1279:
1280: OE_MSG_PUB.set_msg_context
1281: ( p_entity_code => 'LINE'
1282: ,p_entity_id => l_line_rec.line_id
1283: ,p_header_id => l_line_rec.header_id
1284: ,p_line_id => l_line_rec.line_id

Line 1358: OE_MSG_PUB.Add;

1354:
1355: END IF; -- Success.
1356: ELSE -- part of set
1357: FND_MESSAGE.SET_NAME('ONT','OE_SCH_CANNOT_UNSCH_SET');
1358: OE_MSG_PUB.Add;
1359: IF l_debug_level > 0 THEN
1360: oe_debug_pub.add( 'LINE IS PART OF SET ' , 1 ) ;
1361: END IF;
1362:

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

1397: oe_debug_pub.add( 'WHEN OTHERS ERROR IN QUERY LINES ' , 1 ) ;
1398: END IF;
1399: OE_ORDER_SCH_UTIL.OESCH_PERFORM_SCHEDULING := 'Y';
1400: OE_SCHEDULE_UTIL.OESCH_PERFORM_SCHEDULING := 'Y';
1401: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1402: THEN
1403: OE_MSG_PUB.Add_Exc_Msg
1404: ( G_PKG_NAME
1405: , 'Query_lines'

Line 1403: OE_MSG_PUB.Add_Exc_Msg

1399: OE_ORDER_SCH_UTIL.OESCH_PERFORM_SCHEDULING := 'Y';
1400: OE_SCHEDULE_UTIL.OESCH_PERFORM_SCHEDULING := 'Y';
1401: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1402: THEN
1403: OE_MSG_PUB.Add_Exc_Msg
1404: ( G_PKG_NAME
1405: , 'Query_lines'
1406: );
1407: END IF;

Line 1507: OE_MSG_PUB.set_msg_context

1503: WHEN OTHERS THEN
1504: Null;
1505: END;
1506:
1507: OE_MSG_PUB.set_msg_context
1508: ( p_entity_code => 'LINE'
1509: ,p_entity_id => l_line_id
1510: ,p_header_id => l_header_id
1511: ,p_line_id => l_line_id

Line 1541: OE_MSG_PUB.Add;

1537: -- Schedule action is not required for the line.
1538: -- Populate the message on the stack.
1539:
1540: FND_MESSAGE.SET_NAME('ONT','OE_SCH_NO_ACTION_DONE_NO_EXP');
1541: OE_MSG_PUB.Add;
1542: IF l_debug_level > 0 THEN
1543: oe_debug_pub.add( 'LINE IS A SCHEDULED LINE' || L_LINE_ID , 2 ) ;
1544: END IF;
1545:

Line 1807: OE_MSG_PUB.Add;

1803: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1804: -- Start 2742982 --
1805: WHEN NO_DATA_FOUND THEN
1806: FND_MESSAGE.SET_NAME('ONT','OE_SCH_NO_ACTION_DONE_NO_EXP');
1807: OE_MSG_PUB.Add;
1808: RAISE FND_API.G_EXC_ERROR;
1809: -- End 2742982 --
1810:
1811: WHEN OTHERS THEN

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

1809: -- End 2742982 --
1810:
1811: WHEN OTHERS THEN
1812:
1813: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1814: THEN
1815: OE_MSG_PUB.Add_Exc_Msg
1816: ( G_PKG_NAME
1817: , 'Query_Schedule_Lines'

Line 1815: OE_MSG_PUB.Add_Exc_Msg

1811: WHEN OTHERS THEN
1812:
1813: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1814: THEN
1815: OE_MSG_PUB.Add_Exc_Msg
1816: ( G_PKG_NAME
1817: , 'Query_Schedule_Lines'
1818: );
1819: END IF;

Line 1913: OE_MSG_PUB.set_msg_context

1909: l_subscription_enable_flag --sol_ord_er #16014165
1910: From oe_order_lines_all
1911: Where line_id = l_line_id;
1912:
1913: OE_MSG_PUB.set_msg_context
1914: ( p_entity_code => 'LINE'
1915: ,p_entity_id => l_line_id
1916: ,p_header_id => l_header_id
1917: ,p_line_id => l_line_id

Line 1938: OE_MSG_PUB.Add;

1934: IF l_debug_level > 0 THEN
1935: oe_debug_pub.add( 'LINE CANNOT BE UNSCHEDULED IF IT IS PART OF SET' , 1 ) ;
1936: END IF;
1937: FND_MESSAGE.SET_NAME('ONT','OE_SCH_CANNOT_UNSCH_SET');
1938: OE_MSG_PUB.Add;
1939: ELSIF (l_schedule_status_code IS NULL AND
1940: (l_smc_flag = 'Y' OR
1941: l_ato_line_id is not null OR
1942: l_item_type_code = OE_GLOBALS.G_ITEM_INCLUDED OR

Line 1953: OE_MSG_PUB.Add;

1949: THEN
1950: -- line is part of ATO/SMC Model or an ato item which is
1951: -- not scheduled. Bipass these lines.
1952: FND_MESSAGE.SET_NAME('ONT','OE_SCH_NO_ACTION_DONE_NO_EXP');
1953: OE_MSG_PUB.Add;
1954: IF l_debug_level > 0 THEN
1955: oe_debug_pub.add( 'NOT A VALID LINE' || L_LINE_ID , 2 ) ;
1956: END IF;
1957: ELSE -- line not scheduled, please select the line to schedule.

Line 2213: OE_MSG_PUB.Add;

2209:
2210: -- Start 2742982 --
2211: WHEN NO_DATA_FOUND THEN
2212: FND_MESSAGE.SET_NAME('ONT','OE_SCH_NO_ACTION_DONE_NO_EXP');
2213: OE_MSG_PUB.Add;
2214: RAISE FND_API.G_EXC_ERROR;
2215: -- End 2742982 --
2216:
2217: WHEN OTHERS THEN

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

2218:
2219: IF l_debug_level > 0 THEN
2220: oe_debug_pub.add( ' WHEN OTHERS ERROR IN QUERY_UNSCHEDULE_LINES ' , 1 ) ;
2221: END IF;
2222: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2223: THEN
2224: OE_MSG_PUB.Add_Exc_Msg
2225: ( G_PKG_NAME
2226: , 'Query_Unschedule_Lines'

Line 2224: OE_MSG_PUB.Add_Exc_Msg

2220: oe_debug_pub.add( ' WHEN OTHERS ERROR IN QUERY_UNSCHEDULE_LINES ' , 1 ) ;
2221: END IF;
2222: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2223: THEN
2224: OE_MSG_PUB.Add_Exc_Msg
2225: ( G_PKG_NAME
2226: , 'Query_Unschedule_Lines'
2227: );
2228: END IF;

Line 2315: OE_MSG_PUB.set_msg_context

2311: l_source_document_line_id, l_order_source_id
2312: From oe_order_lines_all
2313: Where line_id = l_line_id;
2314:
2315: OE_MSG_PUB.set_msg_context
2316: ( p_entity_code => 'LINE'
2317: ,p_entity_id => l_line_id
2318: ,p_header_id => l_header_id
2319: ,p_line_id => l_line_id

Line 2342: OE_MSG_PUB.Add;

2338: -- and not part of set.
2339: IF l_shipping_interfaced_flag = 'Y' THEN
2340:
2341: FND_MESSAGE.SET_NAME('ONT','OE_SCH_UNRSV_NOT_ALLOWED');
2342: OE_MSG_PUB.Add;
2343: IF l_debug_level > 0 THEN
2344: oe_debug_pub.add( 'LINE IS SHIPPING INTERFACED' || L_LINE_ID , 1 ) ;
2345: END IF;
2346:

Line 2537: OE_MSG_PUB.Add;

2533:
2534: -- Start 2742982 --
2535: WHEN NO_DATA_FOUND THEN
2536: FND_MESSAGE.SET_NAME('ONT','OE_SCH_NO_ACTION_DONE_NO_EXP');
2537: OE_MSG_PUB.Add;
2538: RAISE FND_API.G_EXC_ERROR;
2539: -- End 2742982 --
2540:
2541: WHEN OTHERS THEN

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

2542:
2543: IF l_debug_level > 0 THEN
2544: oe_debug_pub.add( ' WHEN OTHERS ERROR IN QUERY_UNRESERVE_LINES ' , 1 ) ;
2545: END IF;
2546: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2547: THEN
2548: OE_MSG_PUB.Add_Exc_Msg
2549: ( G_PKG_NAME
2550: , 'Query_Unreserve_Lines'

Line 2548: OE_MSG_PUB.Add_Exc_Msg

2544: oe_debug_pub.add( ' WHEN OTHERS ERROR IN QUERY_UNRESERVE_LINES ' , 1 ) ;
2545: END IF;
2546: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2547: THEN
2548: OE_MSG_PUB.Add_Exc_Msg
2549: ( G_PKG_NAME
2550: , 'Query_Unreserve_Lines'
2551: );
2552: END IF;

Line 2652: OE_MSG_PUB.set_msg_context

2648: l_subscription_enable_flag --sol_ord_er #16014165
2649: From oe_order_lines_all
2650: Where line_id = l_line_id;
2651:
2652: OE_MSG_PUB.set_msg_context
2653: ( p_entity_code => 'LINE'
2654: ,p_entity_id => l_line_id
2655: ,p_header_id => l_header_id
2656: ,p_line_id => l_line_id

Line 2675: OE_MSG_PUB.Add;

2671: OR nvl(l_open_flag,'Y') = 'N' THEN
2672:
2673: -- populate the error message and skip the line.
2674: FND_MESSAGE.SET_NAME('ONT','OE_SCH_NO_ACTION_DONE_NO_EXP');
2675: OE_MSG_PUB.Add;
2676: IF l_debug_level > 0 THEN
2677: oe_debug_pub.add( 'NOT A VALIDE LINE' || L_LINE_ID , 2 ) ;
2678: END IF;
2679:

Line 3010: OE_MSG_PUB.set_msg_context

3006: x_line_tbl.delete;
3007: J := 0;
3008: FOR I IN 1..l_line_tbl.count LOOP
3009:
3010: OE_MSG_PUB.set_msg_context
3011: ( p_entity_code => 'LINE'
3012: ,p_entity_id => l_line_tbl(I).line_id
3013: ,p_header_id => l_line_tbl(I).header_id
3014: ,p_line_id => l_line_tbl(I).line_id

Line 3123: OE_MSG_PUB.Add;

3119: IF l_debug_level > 0 THEN
3120: oe_debug_pub.add( 'ALREADY RESERVED' , 2 ) ;
3121: END IF;
3122: END IF; -- shippable flag
3123: OE_MSG_PUB.Add;
3124: -- code fix for 3300528
3125: END IF; -- shippable flag and reserved quantity
3126: ELSE
3127:

Line 3158: OE_MSG_PUB.Add;

3154:
3155: -- Start 2742982 --
3156: WHEN NO_DATA_FOUND THEN
3157: FND_MESSAGE.SET_NAME('ONT','OE_SCH_NO_ACTION_DONE_NO_EXP');
3158: OE_MSG_PUB.Add;
3159: RAISE FND_API.G_EXC_ERROR;
3160: -- End 2742982 --
3161:
3162: WHEN OTHERS THEN

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

3163:
3164: IF l_debug_level > 0 THEN
3165: oe_debug_pub.add( 'WHEN OTHERS ERROR IN QUERY_RESERVE_LINES ' , 1 ) ;
3166: END IF;
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: , 'Validate_Group_Line'

Line 3169: OE_MSG_PUB.Add_Exc_Msg

3165: oe_debug_pub.add( 'WHEN OTHERS ERROR IN QUERY_RESERVE_LINES ' , 1 ) ;
3166: END IF;
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: , 'Validate_Group_Line'
3172: );
3173: END IF;

Line 3260: OE_MSG_PUB.set_msg_context

3256: l_subscription_enable_flag --sol_ord_er #16014165
3257: From oe_order_lines_all
3258: Where line_id = l_line_id;
3259:
3260: OE_MSG_PUB.set_msg_context
3261: ( p_entity_code => 'LINE'
3262: ,p_entity_id => l_line_id
3263: ,p_header_id => l_header_id
3264: ,p_line_id => l_line_id

Line 3282: OE_MSG_PUB.Add;

3278: OR nvl(l_open_flag,'Y') = 'N' THEN
3279:
3280: -- populate the error message and skip the line.
3281: FND_MESSAGE.SET_NAME('ONT','OE_SCH_NO_ACTION_DONE_NO_EXP');
3282: OE_MSG_PUB.Add;
3283: ELSE
3284:
3285:
3286: -- If the line is part of set then avoid selecting them ,

Line 3526: OE_MSG_PUB.Add;

3522:
3523: -- Start 2742982 --
3524: WHEN NO_DATA_FOUND THEN
3525: FND_MESSAGE.SET_NAME('ONT','OE_SCH_NO_ACTION_DONE_NO_EXP');
3526: OE_MSG_PUB.Add;
3527: -- End 2742982 --
3528:
3529: WHEN OTHERS THEN
3530:

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

3530:
3531: IF l_debug_level > 0 THEN
3532: oe_debug_pub.add( 'WHEN OTHERS ERROR IN QUERY_ATP_CHECK_LINES ' , 1 ) ;
3533: END IF;
3534: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3535: THEN
3536: OE_MSG_PUB.Add_Exc_Msg
3537: ( G_PKG_NAME
3538: , 'Query_ATP_CHECK_Lines'

Line 3536: OE_MSG_PUB.Add_Exc_Msg

3532: oe_debug_pub.add( 'WHEN OTHERS ERROR IN QUERY_ATP_CHECK_LINES ' , 1 ) ;
3533: END IF;
3534: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3535: THEN
3536: OE_MSG_PUB.Add_Exc_Msg
3537: ( G_PKG_NAME
3538: , 'Query_ATP_CHECK_Lines'
3539: );
3540: END IF;

Line 3622: OE_MSG_PUB.Add;

3618:
3619: ELSE
3620:
3621: FND_MESSAGE.SET_NAME('ONT','OE_SCH_NO_ACTION_DONE_NO_EXP');
3622: OE_MSG_PUB.Add;
3623: END IF;
3624:
3625: ELSE
3626:

Line 3653: OE_MSG_PUB.Add;

3649: ELSE
3650:
3651: IF p_sch_action <> OE_SCHEDULE_UTIL.OESCH_ACT_RESERVE THEN
3652: FND_MESSAGE.SET_NAME('ONT','OE_SCH_NO_ACTION_DONE_NO_EXP');
3653: OE_MSG_PUB.Add;
3654: END IF;
3655: END IF;
3656:
3657: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 3665: oe_msg_pub.count_and_get

3661: END IF;
3662:
3663: END IF;
3664:
3665: oe_msg_pub.count_and_get
3666: (p_count => x_msg_count
3667: ,p_data => x_msg_data);
3668:
3669: IF l_debug_level > 0 THEN

Line 3683: oe_msg_pub.count_and_get

3679: WHEN FND_API.G_EXC_ERROR THEN
3680:
3681: x_return_status := FND_API.G_RET_STS_ERROR;
3682:
3683: oe_msg_pub.count_and_get
3684: ( p_count => x_msg_count
3685: ,p_data => x_msg_data
3686: );
3687:

Line 3692: oe_msg_pub.count_and_get

3688: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3689:
3690: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3691:
3692: oe_msg_pub.count_and_get
3693: ( p_count => x_msg_count
3694: ,p_data => x_msg_data
3695: );
3696:

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

3697: WHEN OTHERS THEN
3698:
3699: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3700:
3701: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3702: THEN
3703: OE_MSG_PUB.Add_Exc_Msg
3704: ( G_PKG_NAME
3705: , 'Schedule_Order'

Line 3703: OE_MSG_PUB.Add_Exc_Msg

3699: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3700:
3701: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3702: THEN
3703: OE_MSG_PUB.Add_Exc_Msg
3704: ( G_PKG_NAME
3705: , 'Schedule_Order'
3706: );
3707: END IF;

Line 3709: oe_msg_pub.count_and_get

3705: , 'Schedule_Order'
3706: );
3707: END IF;
3708:
3709: oe_msg_pub.count_and_get
3710: ( p_count => x_msg_count
3711: ,p_data => x_msg_data
3712: );
3713: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3930: OE_MSG_PUB.Add;

3926: IF p_sch_action <> OE_SCHEDULE_UTIL.OESCH_ACT_RESERVE
3927: AND p_sch_action <> OE_SCHEDULE_UTIL.OESCH_ACT_ATP_CHECK
3928: THEN
3929: FND_MESSAGE.SET_NAME('ONT','OE_SCH_NO_ACTION_DONE_NO_EXP');
3930: OE_MSG_PUB.Add;
3931: END IF;
3932: END IF;
3933:
3934: IF l_debug_level > 0 THEN

Line 3943: oe_msg_pub.count_and_get

3939:
3940: END IF;
3941: END IF; -- 3990887
3942:
3943: oe_msg_pub.count_and_get
3944: ( p_count => x_msg_count
3945: , p_data => x_msg_data);
3946:
3947: IF l_debug_level > 0 THEN

Line 3966: oe_msg_pub.count_and_get

3962: x_return_status := FND_API.G_RET_STS_SUCCESS;
3963:
3964: /* -- Get message count and data
3965:
3966: oe_msg_pub.count_and_get
3967: ( p_count => x_msg_count
3968: , p_data => x_msg_data
3969: );
3970:

Line 3984: oe_msg_pub.count_and_get

3980: x_return_status := FND_API.G_RET_STS_ERROR;
3981:
3982: -- Get message count and data
3983:
3984: oe_msg_pub.count_and_get
3985: ( p_count => x_msg_count
3986: , p_data => x_msg_data
3987: );
3988:

Line 3995: oe_msg_pub.count_and_get

3991: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3992:
3993: -- Get message count and data
3994:
3995: oe_msg_pub.count_and_get
3996: ( p_count => x_msg_count
3997: , p_data => x_msg_data
3998: );
3999:

Line 4004: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)

4000: WHEN OTHERS THEN
4001:
4002: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4003:
4004: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
4005: THEN
4006: oe_msg_pub.Add_Exc_Msg
4007: ( G_PKG_NAME,
4008: 'Schedule_Multi_lines'

Line 4006: oe_msg_pub.Add_Exc_Msg

4002: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4003:
4004: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
4005: THEN
4006: oe_msg_pub.Add_Exc_Msg
4007: ( G_PKG_NAME,
4008: 'Schedule_Multi_lines'
4009: );
4010: END IF;

Line 4014: oe_msg_pub.count_and_get

4010: END IF;
4011:
4012: -- Get message count and data
4013:
4014: oe_msg_pub.count_and_get
4015: ( p_count => x_msg_count
4016: , p_data => x_msg_data
4017: );
4018:

Line 4548: OE_MSG_PUB.Add;

4544: END LOOP;
4545:
4546: IF l_log_error THEN
4547: FND_MESSAGE.SET_NAME('ONT','OE_SCH_OVER_ATP_SET_NO_MATCH');
4548: OE_MSG_PUB.Add;
4549: x_return_status := FND_API.G_RET_STS_ERROR;
4550: RAISE FND_API.G_EXC_ERROR;
4551: END IF;
4552:

Line 4755: OE_MSG_PUB.Add;

4751: oe_debug_pub.add('Before setting message for group failure',2);
4752: END IF;
4753:
4754: FND_MESSAGE.SET_NAME('ONT','OE_SCH_GROUP_MEMBER_FAILED');
4755: OE_MSG_PUB.Add;
4756:
4757: END IF; -- If Auto Push Group Date is Yes
4758:
4759: -- Scheduling Failed. If the line belongs to a Ship Set or Arrival

Line 4787: OE_MSG_PUB.Add;

4783: IF l_debug_level > 0 THEN
4784: oe_debug_pub.add('Line belong to model');
4785: END IF;
4786: fnd_message.set_name('ONT','OE_SCH_SET_INS_FAILED');
4787: OE_MSG_PUB.Add;
4788: RAISE FND_API.G_EXC_ERROR;
4789:
4790: ELSE
4791: -- If the line is being added to set is a standard line

Line 4797: OE_MSG_PUB.Add;

4793: IF l_debug_level > 0 THEN
4794: oe_debug_pub.add('Standard line is failed');
4795: END IF;
4796: fnd_message.set_name('ONT','OE_SCH_SET_INS_FAILED');
4797: OE_MSG_PUB.Add;
4798:
4799: IF l_line_tbl(I).schedule_status_code IS NULL
4800: THEN
4801:

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

4875: RAISE FND_API.G_EXC_ERROR;
4876:
4877: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4878:
4879: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4880: THEN
4881: OE_MSG_PUB.Add_Exc_Msg
4882: ( G_PKG_NAME
4883: , 'Schedule_set_lines'

Line 4881: OE_MSG_PUB.Add_Exc_Msg

4877: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4878:
4879: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4880: THEN
4881: OE_MSG_PUB.Add_Exc_Msg
4882: ( G_PKG_NAME
4883: , 'Schedule_set_lines'
4884: );
4885: END IF;

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

4892:
4893: WHEN OTHERS THEN
4894:
4895:
4896: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4897: THEN
4898: OE_MSG_PUB.Add_Exc_Msg
4899: ( G_PKG_NAME
4900: , 'Schedule_set_lines'

Line 4898: OE_MSG_PUB.Add_Exc_Msg

4894:
4895:
4896: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4897: THEN
4898: OE_MSG_PUB.Add_Exc_Msg
4899: ( G_PKG_NAME
4900: , 'Schedule_set_lines'
4901: );
4902: END IF;

Line 5166: OE_MSG_PUB.Add;

5162: END LOOP;
5163:
5164: IF l_log_error THEN
5165: FND_MESSAGE.SET_NAME('ONT','OE_SCH_OVER_ATP_SET_NO_MATCH');
5166: OE_MSG_PUB.Add;
5167: x_return_status := FND_API.G_RET_STS_ERROR;
5168: goto END_OF_PROCESS;
5169: END IF;
5170: END IF; -- code level.

Line 5785: OE_MSG_PUB.Add;

5781: END IF;
5782:
5783: x_return_status := FND_API.G_RET_STS_ERROR;
5784: FND_MESSAGE.SET_NAME('ONT','OE_SCH_GROUP_MEMBER_FAILED');
5785: OE_MSG_PUB.Add;
5786: RAISE FND_API.G_EXC_ERROR;
5787:
5788: END IF;
5789:

Line 5887: OE_MSG_PUB.Add;

5883: IF l_debug_level > 0 THEN
5884: oe_debug_pub.add('It is a create operation ' ,2);
5885: END IF;
5886: fnd_message.set_name('ONT','OE_SCH_SET_INS_FAILED');
5887: OE_MSG_PUB.Add;
5888: x_return_status := FND_API.G_RET_STS_SUCCESS;
5889: IF l_debug_level > 0 THEN
5890: oe_debug_pub.add('x_return_status ' || x_return_status,2);
5891: END IF;

Line 5977: OE_MSG_PUB.Add;

5973: OE_SCHEDULE_UTIL.OESCH_ENTITY_ARRIVAL_SET
5974: AND NOT OE_GLOBALS.equal(l_arrival_set_id,l_old_arrival_set_id)))
5975: THEN
5976: fnd_message.set_name('ONT','OE_SCH_SET_INS_FAILED');
5977: OE_MSG_PUB.Add;
5978: END IF;
5979: G_TOP_MODEL_LINE_ID := Null;
5980: G_PART_OF_SET := Null;
5981: x_return_status := FND_API.G_RET_STS_ERROR;

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

5991: G_TOP_MODEL_LINE_ID := Null;
5992: G_PART_OF_SET := Null;
5993: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5994:
5995: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5996: THEN
5997: OE_MSG_PUB.Add_Exc_Msg
5998: ( G_PKG_NAME
5999: , 'Schedule_Set'

Line 5997: OE_MSG_PUB.Add_Exc_Msg

5993: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5994:
5995: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5996: THEN
5997: OE_MSG_PUB.Add_Exc_Msg
5998: ( G_PKG_NAME
5999: , 'Schedule_Set'
6000: );
6001: END IF;

Line 6386: OE_MSG_PUB.Add;

6382: END LOOP;
6383:
6384: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
6385: fnd_message.set_name('ONT','OE_SCH_SET_INS_FAILED');
6386: OE_MSG_PUB.Add;
6387: x_return_status := FND_API.G_RET_STS_SUCCESS;
6388: IF l_debug_level > 0 THEN
6389: oe_debug_pub.add('x_return_status ' || x_return_status,2);
6390: END IF;

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

6405: RAISE FND_API.G_EXC_ERROR;
6406:
6407: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6408:
6409: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6410: THEN
6411: OE_MSG_PUB.Add_Exc_Msg
6412: ( G_PKG_NAME
6413: , 'Group_Schedule_sets'

Line 6411: OE_MSG_PUB.Add_Exc_Msg

6407: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6408:
6409: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6410: THEN
6411: OE_MSG_PUB.Add_Exc_Msg
6412: ( G_PKG_NAME
6413: , 'Group_Schedule_sets'
6414: );
6415: END IF;

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

6421:
6422: WHEN OTHERS THEN
6423:
6424:
6425: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6426: THEN
6427: OE_MSG_PUB.Add_Exc_Msg
6428: ( G_PKG_NAME
6429: , 'Group_Schedule_sets'

Line 6427: OE_MSG_PUB.Add_Exc_Msg

6423:
6424:
6425: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6426: THEN
6427: OE_MSG_PUB.Add_Exc_Msg
6428: ( G_PKG_NAME
6429: , 'Group_Schedule_sets'
6430: );
6431: END IF;