[Home] [Help]
44: IF l_debug_level > 0 THEN
45: oe_debug_pub.add('INVALID ITEM WAREHOUSE COMBINATION',3);
46: END IF;
47: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ITEM_WHSE');
48: OE_MSG_PUB.Add;
49: x_return_status := FND_API.G_RET_STS_ERROR;
50: END Validate_Item_Warehouse;
51:
52: /*---------------------------------------------------------------------
84: -- The line is cancelled. Cannot perform scheduling
85: -- on it.
86:
87: FND_MESSAGE.SET_NAME('ONT','OE_SCH_LINE_SHIPPED');
88: OE_MSG_PUB.Add;
89:
90: IF l_debug_level > 0 THEN
91: oe_debug_pub.add( ' SHIPPED LINE.' , 4 ) ;
92: END IF;
107: IF (p_line_rec.request_date is null OR
108: p_line_rec.request_date = FND_API.G_MISS_DATE) THEN
109:
110: FND_MESSAGE.SET_NAME('ONT','OE_SCH_MISSING_REQUEST_DATE');
111: OE_MSG_PUB.Add;
112: IF l_debug_level > 0 THEN
113: oe_debug_pub.add( 'REQUEST DATE IS MISSING' , 4 ) ;
114: END IF;
115: x_return_status := FND_API.G_RET_STS_ERROR;
161: END IF;
162:
163: IF (l_result = FND_API.G_TRUE) THEN
164: FND_MESSAGE.SET_NAME('ONT','OE_SCH_LINE_ON_HOLD');
165: OE_MSG_PUB.Add;
166: x_return_status := FND_API.G_RET_STS_ERROR;
167: IF l_debug_level > 0 THEN
168: oe_debug_pub.add( 'LINE IS ON HOLD' , 4 ) ;
169: END IF;
194: FND_MESSAGE.SET_TOKEN('ACTION', p_line_rec.schedule_action_code);
195: FND_MESSAGE.SET_TOKEN('ORDER_TYPE',
196: nvl(OE_SCHEDULE_UTIL.sch_cached_line_type,
197: OE_SCHEDULE_UTIL.sch_cached_order_type));
198: OE_MSG_PUB.Add;
199: x_return_status := FND_API.G_RET_STS_ERROR;
200: IF l_debug_level > 0 THEN
201: oe_debug_pub.add( 'LINE TYPE IS ATP ONLY' , 4 ) ;
202: END IF;
212: OE_SCHEDULE_UTIL.OESCH_ACT_RESERVE));
213: FND_MESSAGE.SET_TOKEN('ORDER_TYPE',
214: nvl(OE_SCHEDULE_UTIL.sch_cached_line_type,
215: OE_SCHEDULE_UTIL.sch_cached_order_type));
216: OE_MSG_PUB.Add;
217: x_return_status := FND_API.G_RET_STS_ERROR;
218: IF l_debug_level > 0 THEN
219: oe_debug_pub.add( 'LINE TYPE IS NOT ELIGIBLE FOR RESERVATION ' , 4 ) ;
220: END IF;
234: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
235:
236: WHEN OTHERS THEN
237:
238: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
239: THEN
240: OE_MSG_PUB.Add_Exc_Msg
241: ( G_PKG_NAME
242: , 'Validate_Group_Line'
236: WHEN OTHERS THEN
237:
238: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
239: THEN
240: OE_MSG_PUB.Add_Exc_Msg
241: ( G_PKG_NAME
242: , 'Validate_Group_Line'
243: );
244: END IF;
270: END IF;
271: x_return_status := FND_API.G_RET_STS_SUCCESS;
272: FOR I IN 1..p_x_line_tbl.count LOOP
273:
274: OE_MSG_PUB.set_msg_context
275: ( p_entity_code => 'LINE'
276: ,p_entity_id => p_x_line_tbl(I).line_id
277: ,p_header_id => p_x_line_tbl(I).header_id
278: ,p_line_id => p_x_line_tbl(I).line_id
363: EXCEPTION
364:
365: WHEN OTHERS THEN
366: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
367: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
368: THEN
369: OE_MSG_PUB.Add_Exc_Msg
370: ( G_PKG_NAME
371: , 'Validate_Group');
365: WHEN OTHERS THEN
366: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
367: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
368: THEN
369: OE_MSG_PUB.Add_Exc_Msg
370: ( G_PKG_NAME
371: , 'Validate_Group');
372: END IF;
373:
658: p_x_line_rec => l_line_rec,
659: x_return_status => l_return_status);
660:
661:
662: OE_MSG_PUB.set_msg_context
663: ( p_entity_code => 'LINE'
664: ,p_entity_id => l_line_rec.line_id
665: ,p_header_id => l_line_rec.header_id
666: ,p_line_id => l_line_rec.line_id
748: p_x_line_rec => l_line_rec,
749: x_return_status => l_return_status);
750:
751:
752: OE_MSG_PUB.set_msg_context
753: ( p_entity_code => 'LINE'
754: ,p_entity_id => l_line_rec.line_id
755: ,p_header_id => l_line_rec.header_id
756: ,p_line_id => l_line_rec.line_id
889: END IF;
890: ELSE -- reservation exists
891:
892: FND_MESSAGE.SET_NAME('ONT','OE_SCH_NO_ACTION_DONE_NO_EXP');
893: OE_MSG_PUB.Add;
894: IF l_debug_level > 0 THEN
895: oe_debug_pub.add( 'LINE IS ALREADY RESERVED , DO NOT NEED RESERVATION :' || L_LINE_REC.RESERVED_QUANTITY ) ;
896: END IF;
897:
914: ELSE
915: FND_MESSAGE.SET_NAME('ONT','ONT_SCH_NOT_RESERVABLE');
916: END IF;
917: -- code fix for 3300528
918: OE_MSG_PUB.Add;
919:
920: END IF;
921: ELSE -- Line is not scheduled yet.
922:
980: OE_Line_Util.Query_Row( p_line_id => c1.line_id
981: ,x_line_rec => l_line_rec);
982:
983:
984: OE_MSG_PUB.set_msg_context
985: ( p_entity_code => 'LINE'
986: ,p_entity_id => l_line_rec.line_id
987: ,p_header_id => l_line_rec.header_id
988: ,p_line_id => l_line_rec.line_id
1080:
1081: FOR c2 IN l_line_inc_csr LOOP
1082:
1083:
1084: OE_MSG_PUB.set_msg_context
1085: ( p_entity_code => 'LINE'
1086: ,p_entity_id => C2.line_id
1087: ,p_header_id => p_header_id
1088: ,p_line_id => C2.line_id
1103: AND oe_schedule_util.Get_Pick_Status(c2.line_id)) THEN -- 2595661
1104:
1105:
1106: FND_MESSAGE.SET_NAME('ONT','OE_SCH_UNRSV_NOT_ALLOWED');
1107: OE_MSG_PUB.Add;
1108: IF l_debug_level > 0 THEN
1109: oe_debug_pub.add( 'LINE IS SHIPPING INTERFACED ' || C2.LINE_ID , 1 ) ;
1110: END IF;
1111:
1119: OE_Line_Util.Lock_Row(p_line_id => c2.line_id,
1120: p_x_line_rec => l_line_rec,
1121: x_return_status => l_return_status);
1122:
1123: OE_MSG_PUB.set_msg_context
1124: ( p_entity_code => 'LINE'
1125: ,p_entity_id => l_line_rec.line_id
1126: ,p_header_id => l_line_rec.header_id
1127: ,p_line_id => l_line_rec.line_id
1229: FOR c2 IN l_line_inc_csr LOOP
1230: -- If the line belong to set, and action is unschedule,
1231: -- ignore the line.
1232:
1233: OE_MSG_PUB.set_msg_context
1234: ( p_entity_code => 'LINE'
1235: ,p_entity_id => C2.line_id
1236: ,p_header_id => p_header_id
1237: ,p_line_id => C2.line_id
1269: OE_Line_Util.Lock_Row(p_line_id => c2.line_id,
1270: p_x_line_rec => l_line_rec,
1271: x_return_status => l_return_status);
1272:
1273: OE_MSG_PUB.set_msg_context
1274: ( p_entity_code => 'LINE'
1275: ,p_entity_id => l_line_rec.line_id
1276: ,p_header_id => l_line_rec.header_id
1277: ,p_line_id => l_line_rec.line_id
1347:
1348: END IF; -- Success.
1349: ELSE -- part of set
1350: FND_MESSAGE.SET_NAME('ONT','OE_SCH_CANNOT_UNSCH_SET');
1351: OE_MSG_PUB.Add;
1352: IF l_debug_level > 0 THEN
1353: oe_debug_pub.add( 'LINE IS PART OF SET ' , 1 ) ;
1354: END IF;
1355:
1390: oe_debug_pub.add( 'WHEN OTHERS ERROR IN QUERY LINES ' , 1 ) ;
1391: END IF;
1392: OE_ORDER_SCH_UTIL.OESCH_PERFORM_SCHEDULING := 'Y';
1393: OE_SCHEDULE_UTIL.OESCH_PERFORM_SCHEDULING := 'Y';
1394: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1395: THEN
1396: OE_MSG_PUB.Add_Exc_Msg
1397: ( G_PKG_NAME
1398: , 'Query_lines'
1392: OE_ORDER_SCH_UTIL.OESCH_PERFORM_SCHEDULING := 'Y';
1393: OE_SCHEDULE_UTIL.OESCH_PERFORM_SCHEDULING := 'Y';
1394: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1395: THEN
1396: OE_MSG_PUB.Add_Exc_Msg
1397: ( G_PKG_NAME
1398: , 'Query_lines'
1399: );
1400: END IF;
1491: WHEN OTHERS THEN
1492: Null;
1493: END;
1494:
1495: OE_MSG_PUB.set_msg_context
1496: ( p_entity_code => 'LINE'
1497: ,p_entity_id => l_line_id
1498: ,p_header_id => l_header_id
1499: ,p_line_id => l_line_id
1524: -- Schedule action is not required for the line.
1525: -- Populate the message on the stack.
1526:
1527: FND_MESSAGE.SET_NAME('ONT','OE_SCH_NO_ACTION_DONE_NO_EXP');
1528: OE_MSG_PUB.Add;
1529: IF l_debug_level > 0 THEN
1530: oe_debug_pub.add( 'LINE IS A SCHEDULED LINE' || L_LINE_ID , 2 ) ;
1531: END IF;
1532:
1760: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1761: -- Start 2742982 --
1762: WHEN NO_DATA_FOUND THEN
1763: FND_MESSAGE.SET_NAME('ONT','OE_SCH_NO_ACTION_DONE_NO_EXP');
1764: OE_MSG_PUB.Add;
1765: RAISE FND_API.G_EXC_ERROR;
1766: -- End 2742982 --
1767:
1768: WHEN OTHERS THEN
1766: -- End 2742982 --
1767:
1768: WHEN OTHERS THEN
1769:
1770: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1771: THEN
1772: OE_MSG_PUB.Add_Exc_Msg
1773: ( G_PKG_NAME
1774: , 'Query_Schedule_Lines'
1768: WHEN OTHERS THEN
1769:
1770: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1771: THEN
1772: OE_MSG_PUB.Add_Exc_Msg
1773: ( G_PKG_NAME
1774: , 'Query_Schedule_Lines'
1775: );
1776: END IF;
1863: l_source_document_line_id, l_order_source_id
1864: From oe_order_lines_all
1865: Where line_id = l_line_id;
1866:
1867: OE_MSG_PUB.set_msg_context
1868: ( p_entity_code => 'LINE'
1869: ,p_entity_id => l_line_id
1870: ,p_header_id => l_header_id
1871: ,p_line_id => l_line_id
1888: IF l_debug_level > 0 THEN
1889: oe_debug_pub.add( 'LINE CANNOT BE UNSCHEDULED IF IT IS PART OF SET' , 1 ) ;
1890: END IF;
1891: FND_MESSAGE.SET_NAME('ONT','OE_SCH_CANNOT_UNSCH_SET');
1892: OE_MSG_PUB.Add;
1893: ELSIF (l_schedule_status_code IS NULL AND
1894: (l_smc_flag = 'Y' OR
1895: l_ato_line_id is not null OR
1896: l_item_type_code = OE_GLOBALS.G_ITEM_INCLUDED OR
1902: THEN
1903: -- line is part of ATO/SMC Model or an ato item which is
1904: -- not scheduled. Bipass these lines.
1905: FND_MESSAGE.SET_NAME('ONT','OE_SCH_NO_ACTION_DONE_NO_EXP');
1906: OE_MSG_PUB.Add;
1907: IF l_debug_level > 0 THEN
1908: oe_debug_pub.add( 'NOT A VALID LINE' || L_LINE_ID , 2 ) ;
1909: END IF;
1910: ELSE -- line not scheduled, please select the line to schedule.
2161:
2162: -- Start 2742982 --
2163: WHEN NO_DATA_FOUND THEN
2164: FND_MESSAGE.SET_NAME('ONT','OE_SCH_NO_ACTION_DONE_NO_EXP');
2165: OE_MSG_PUB.Add;
2166: RAISE FND_API.G_EXC_ERROR;
2167: -- End 2742982 --
2168:
2169: WHEN OTHERS THEN
2170:
2171: IF l_debug_level > 0 THEN
2172: oe_debug_pub.add( ' WHEN OTHERS ERROR IN QUERY_UNSCHEDULE_LINES ' , 1 ) ;
2173: END IF;
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: , 'Query_Unschedule_Lines'
2172: oe_debug_pub.add( ' WHEN OTHERS ERROR IN QUERY_UNSCHEDULE_LINES ' , 1 ) ;
2173: END IF;
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: , 'Query_Unschedule_Lines'
2179: );
2180: END IF;
2263: l_source_document_line_id, l_order_source_id
2264: From oe_order_lines_all
2265: Where line_id = l_line_id;
2266:
2267: OE_MSG_PUB.set_msg_context
2268: ( p_entity_code => 'LINE'
2269: ,p_entity_id => l_line_id
2270: ,p_header_id => l_header_id
2271: ,p_line_id => l_line_id
2290: -- and not part of set.
2291: IF l_shipping_interfaced_flag = 'Y' THEN
2292:
2293: FND_MESSAGE.SET_NAME('ONT','OE_SCH_UNRSV_NOT_ALLOWED');
2294: OE_MSG_PUB.Add;
2295: IF l_debug_level > 0 THEN
2296: oe_debug_pub.add( 'LINE IS SHIPPING INTERFACED' || L_LINE_ID , 1 ) ;
2297: END IF;
2298:
2485:
2486: -- Start 2742982 --
2487: WHEN NO_DATA_FOUND THEN
2488: FND_MESSAGE.SET_NAME('ONT','OE_SCH_NO_ACTION_DONE_NO_EXP');
2489: OE_MSG_PUB.Add;
2490: RAISE FND_API.G_EXC_ERROR;
2491: -- End 2742982 --
2492:
2493: WHEN OTHERS THEN
2494:
2495: IF l_debug_level > 0 THEN
2496: oe_debug_pub.add( ' WHEN OTHERS ERROR IN QUERY_UNRESERVE_LINES ' , 1 ) ;
2497: END IF;
2498: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2499: THEN
2500: OE_MSG_PUB.Add_Exc_Msg
2501: ( G_PKG_NAME
2502: , 'Query_Unreserve_Lines'
2496: oe_debug_pub.add( ' WHEN OTHERS ERROR IN QUERY_UNRESERVE_LINES ' , 1 ) ;
2497: END IF;
2498: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2499: THEN
2500: OE_MSG_PUB.Add_Exc_Msg
2501: ( G_PKG_NAME
2502: , 'Query_Unreserve_Lines'
2503: );
2504: END IF;
2596: l_source_document_line_id, l_order_source_id
2597: From oe_order_lines_all
2598: Where line_id = l_line_id;
2599:
2600: OE_MSG_PUB.set_msg_context
2601: ( p_entity_code => 'LINE'
2602: ,p_entity_id => l_line_id
2603: ,p_header_id => l_header_id
2604: ,p_line_id => l_line_id
2618: OR nvl(l_open_flag,'Y') = 'N' THEN
2619:
2620: -- populate the error message and skip the line.
2621: FND_MESSAGE.SET_NAME('ONT','OE_SCH_NO_ACTION_DONE_NO_EXP');
2622: OE_MSG_PUB.Add;
2623: IF l_debug_level > 0 THEN
2624: oe_debug_pub.add( 'NOT A VALIDE LINE' || L_LINE_ID , 2 ) ;
2625: END IF;
2626:
2927: x_line_tbl.delete;
2928: J := 0;
2929: FOR I IN 1..l_line_tbl.count LOOP
2930:
2931: OE_MSG_PUB.set_msg_context
2932: ( p_entity_code => 'LINE'
2933: ,p_entity_id => l_line_tbl(I).line_id
2934: ,p_header_id => l_line_tbl(I).header_id
2935: ,p_line_id => l_line_tbl(I).line_id
3040: IF l_debug_level > 0 THEN
3041: oe_debug_pub.add( 'ALREADY RESERVED' , 2 ) ;
3042: END IF;
3043: END IF; -- shippable flag
3044: OE_MSG_PUB.Add;
3045: -- code fix for 3300528
3046: END IF; -- shippable flag and reserved quantity
3047: ELSE
3048:
3075:
3076: -- Start 2742982 --
3077: WHEN NO_DATA_FOUND THEN
3078: FND_MESSAGE.SET_NAME('ONT','OE_SCH_NO_ACTION_DONE_NO_EXP');
3079: OE_MSG_PUB.Add;
3080: RAISE FND_API.G_EXC_ERROR;
3081: -- End 2742982 --
3082:
3083: WHEN OTHERS THEN
3084:
3085: IF l_debug_level > 0 THEN
3086: oe_debug_pub.add( 'WHEN OTHERS ERROR IN QUERY_RESERVE_LINES ' , 1 ) ;
3087: END IF;
3088: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3089: THEN
3090: OE_MSG_PUB.Add_Exc_Msg
3091: ( G_PKG_NAME
3092: , 'Validate_Group_Line'
3086: oe_debug_pub.add( 'WHEN OTHERS ERROR IN QUERY_RESERVE_LINES ' , 1 ) ;
3087: END IF;
3088: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3089: THEN
3090: OE_MSG_PUB.Add_Exc_Msg
3091: ( G_PKG_NAME
3092: , 'Validate_Group_Line'
3093: );
3094: END IF;
3174: l_source_document_line_id, l_order_source_id
3175: From oe_order_lines_all
3176: Where line_id = l_line_id;
3177:
3178: OE_MSG_PUB.set_msg_context
3179: ( p_entity_code => 'LINE'
3180: ,p_entity_id => l_line_id
3181: ,p_header_id => l_header_id
3182: ,p_line_id => l_line_id
3195: OR nvl(l_open_flag,'Y') = 'N' THEN
3196:
3197: -- populate the error message and skip the line.
3198: FND_MESSAGE.SET_NAME('ONT','OE_SCH_NO_ACTION_DONE_NO_EXP');
3199: OE_MSG_PUB.Add;
3200: ELSE
3201:
3202:
3203: -- If the line is part of set then avoid selecting them ,
3438:
3439: -- Start 2742982 --
3440: WHEN NO_DATA_FOUND THEN
3441: FND_MESSAGE.SET_NAME('ONT','OE_SCH_NO_ACTION_DONE_NO_EXP');
3442: OE_MSG_PUB.Add;
3443: -- End 2742982 --
3444:
3445: WHEN OTHERS THEN
3446:
3446:
3447: IF l_debug_level > 0 THEN
3448: oe_debug_pub.add( 'WHEN OTHERS ERROR IN QUERY_ATP_CHECK_LINES ' , 1 ) ;
3449: END IF;
3450: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3451: THEN
3452: OE_MSG_PUB.Add_Exc_Msg
3453: ( G_PKG_NAME
3454: , 'Query_ATP_CHECK_Lines'
3448: oe_debug_pub.add( 'WHEN OTHERS ERROR IN QUERY_ATP_CHECK_LINES ' , 1 ) ;
3449: END IF;
3450: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3451: THEN
3452: OE_MSG_PUB.Add_Exc_Msg
3453: ( G_PKG_NAME
3454: , 'Query_ATP_CHECK_Lines'
3455: );
3456: END IF;
3534:
3535: ELSE
3536:
3537: FND_MESSAGE.SET_NAME('ONT','OE_SCH_NO_ACTION_DONE_NO_EXP');
3538: OE_MSG_PUB.Add;
3539: END IF;
3540:
3541: ELSE
3542:
3565: ELSE
3566:
3567: IF p_sch_action <> OE_SCHEDULE_UTIL.OESCH_ACT_RESERVE THEN
3568: FND_MESSAGE.SET_NAME('ONT','OE_SCH_NO_ACTION_DONE_NO_EXP');
3569: OE_MSG_PUB.Add;
3570: END IF;
3571: END IF;
3572:
3573: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3577: END IF;
3578:
3579: END IF;
3580:
3581: oe_msg_pub.count_and_get
3582: (p_count => x_msg_count
3583: ,p_data => x_msg_data);
3584:
3585: IF l_debug_level > 0 THEN
3595: WHEN FND_API.G_EXC_ERROR THEN
3596:
3597: x_return_status := FND_API.G_RET_STS_ERROR;
3598:
3599: oe_msg_pub.count_and_get
3600: ( p_count => x_msg_count
3601: ,p_data => x_msg_data
3602: );
3603:
3604: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3605:
3606: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3607:
3608: oe_msg_pub.count_and_get
3609: ( p_count => x_msg_count
3610: ,p_data => x_msg_data
3611: );
3612:
3613: WHEN OTHERS THEN
3614:
3615: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3616:
3617: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3618: THEN
3619: OE_MSG_PUB.Add_Exc_Msg
3620: ( G_PKG_NAME
3621: , 'Schedule_Order'
3615: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3616:
3617: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3618: THEN
3619: OE_MSG_PUB.Add_Exc_Msg
3620: ( G_PKG_NAME
3621: , 'Schedule_Order'
3622: );
3623: END IF;
3621: , 'Schedule_Order'
3622: );
3623: END IF;
3624:
3625: oe_msg_pub.count_and_get
3626: ( p_count => x_msg_count
3627: ,p_data => x_msg_data
3628: );
3629: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3842: IF p_sch_action <> OE_SCHEDULE_UTIL.OESCH_ACT_RESERVE
3843: AND p_sch_action <> OE_SCHEDULE_UTIL.OESCH_ACT_ATP_CHECK
3844: THEN
3845: FND_MESSAGE.SET_NAME('ONT','OE_SCH_NO_ACTION_DONE_NO_EXP');
3846: OE_MSG_PUB.Add;
3847: END IF;
3848: END IF;
3849:
3850: IF l_debug_level > 0 THEN
3855:
3856: END IF;
3857: END IF; -- 3990887
3858:
3859: oe_msg_pub.count_and_get
3860: ( p_count => x_msg_count
3861: , p_data => x_msg_data);
3862:
3863: IF l_debug_level > 0 THEN
3878: x_return_status := FND_API.G_RET_STS_SUCCESS;
3879:
3880: /* -- Get message count and data
3881:
3882: oe_msg_pub.count_and_get
3883: ( p_count => x_msg_count
3884: , p_data => x_msg_data
3885: );
3886:
3896: x_return_status := FND_API.G_RET_STS_ERROR;
3897:
3898: -- Get message count and data
3899:
3900: oe_msg_pub.count_and_get
3901: ( p_count => x_msg_count
3902: , p_data => x_msg_data
3903: );
3904:
3907: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3908:
3909: -- Get message count and data
3910:
3911: oe_msg_pub.count_and_get
3912: ( p_count => x_msg_count
3913: , p_data => x_msg_data
3914: );
3915:
3916: WHEN OTHERS THEN
3917:
3918: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3919:
3920: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
3921: THEN
3922: oe_msg_pub.Add_Exc_Msg
3923: ( G_PKG_NAME,
3924: 'Schedule_Multi_lines'
3918: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3919:
3920: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
3921: THEN
3922: oe_msg_pub.Add_Exc_Msg
3923: ( G_PKG_NAME,
3924: 'Schedule_Multi_lines'
3925: );
3926: END IF;
3926: END IF;
3927:
3928: -- Get message count and data
3929:
3930: oe_msg_pub.count_and_get
3931: ( p_count => x_msg_count
3932: , p_data => x_msg_data
3933: );
3934:
4459: END LOOP;
4460:
4461: IF l_log_error THEN
4462: FND_MESSAGE.SET_NAME('ONT','OE_SCH_OVER_ATP_SET_NO_MATCH');
4463: OE_MSG_PUB.Add;
4464: x_return_status := FND_API.G_RET_STS_ERROR;
4465: RAISE FND_API.G_EXC_ERROR;
4466: END IF;
4467:
4666: oe_debug_pub.add('Before setting message for group failure',2);
4667: END IF;
4668:
4669: FND_MESSAGE.SET_NAME('ONT','OE_SCH_GROUP_MEMBER_FAILED');
4670: OE_MSG_PUB.Add;
4671:
4672: END IF; -- If Auto Push Group Date is Yes
4673:
4674: -- Scheduling Failed. If the line belongs to a Ship Set or Arrival
4698: IF l_debug_level > 0 THEN
4699: oe_debug_pub.add('Line belong to model');
4700: END IF;
4701: fnd_message.set_name('ONT','OE_SCH_SET_INS_FAILED');
4702: OE_MSG_PUB.Add;
4703: RAISE FND_API.G_EXC_ERROR;
4704:
4705: ELSE
4706: -- If the line is being added to set is a standard line
4708: IF l_debug_level > 0 THEN
4709: oe_debug_pub.add('Standard line is failed');
4710: END IF;
4711: fnd_message.set_name('ONT','OE_SCH_SET_INS_FAILED');
4712: OE_MSG_PUB.Add;
4713:
4714: IF l_line_tbl(I).schedule_status_code IS NULL
4715: THEN
4716:
4790: RAISE FND_API.G_EXC_ERROR;
4791:
4792: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4793:
4794: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4795: THEN
4796: OE_MSG_PUB.Add_Exc_Msg
4797: ( G_PKG_NAME
4798: , 'Schedule_set_lines'
4792: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4793:
4794: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4795: THEN
4796: OE_MSG_PUB.Add_Exc_Msg
4797: ( G_PKG_NAME
4798: , 'Schedule_set_lines'
4799: );
4800: END IF;
4807:
4808: WHEN OTHERS THEN
4809:
4810:
4811: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4812: THEN
4813: OE_MSG_PUB.Add_Exc_Msg
4814: ( G_PKG_NAME
4815: , 'Schedule_set_lines'
4809:
4810:
4811: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4812: THEN
4813: OE_MSG_PUB.Add_Exc_Msg
4814: ( G_PKG_NAME
4815: , 'Schedule_set_lines'
4816: );
4817: END IF;
5074: END LOOP;
5075:
5076: IF l_log_error THEN
5077: FND_MESSAGE.SET_NAME('ONT','OE_SCH_OVER_ATP_SET_NO_MATCH');
5078: OE_MSG_PUB.Add;
5079: x_return_status := FND_API.G_RET_STS_ERROR;
5080: goto END_OF_PROCESS;
5081: END IF;
5082: END IF; -- code level.
5720: END IF;
5721:
5722: x_return_status := FND_API.G_RET_STS_ERROR;
5723: FND_MESSAGE.SET_NAME('ONT','OE_SCH_GROUP_MEMBER_FAILED');
5724: OE_MSG_PUB.Add;
5725: RAISE FND_API.G_EXC_ERROR;
5726:
5727: END IF;
5728:
5817: IF l_debug_level > 0 THEN
5818: oe_debug_pub.add('It is a create operation ' ,2);
5819: END IF;
5820: fnd_message.set_name('ONT','OE_SCH_SET_INS_FAILED');
5821: OE_MSG_PUB.Add;
5822: x_return_status := FND_API.G_RET_STS_SUCCESS;
5823: IF l_debug_level > 0 THEN
5824: oe_debug_pub.add('x_return_status ' || x_return_status,2);
5825: END IF;
5907: OE_SCHEDULE_UTIL.OESCH_ENTITY_ARRIVAL_SET
5908: AND NOT OE_GLOBALS.equal(l_arrival_set_id,l_old_arrival_set_id)))
5909: THEN
5910: fnd_message.set_name('ONT','OE_SCH_SET_INS_FAILED');
5911: OE_MSG_PUB.Add;
5912: END IF;
5913: G_TOP_MODEL_LINE_ID := Null;
5914: G_PART_OF_SET := Null;
5915: x_return_status := FND_API.G_RET_STS_ERROR;
5925: G_TOP_MODEL_LINE_ID := Null;
5926: G_PART_OF_SET := Null;
5927: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5928:
5929: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5930: THEN
5931: OE_MSG_PUB.Add_Exc_Msg
5932: ( G_PKG_NAME
5933: , 'Schedule_Set'
5927: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5928:
5929: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5930: THEN
5931: OE_MSG_PUB.Add_Exc_Msg
5932: ( G_PKG_NAME
5933: , 'Schedule_Set'
5934: );
5935: END IF;
6315: END LOOP;
6316:
6317: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
6318: fnd_message.set_name('ONT','OE_SCH_SET_INS_FAILED');
6319: OE_MSG_PUB.Add;
6320: x_return_status := FND_API.G_RET_STS_SUCCESS;
6321: IF l_debug_level > 0 THEN
6322: oe_debug_pub.add('x_return_status ' || x_return_status,2);
6323: END IF;
6338: RAISE FND_API.G_EXC_ERROR;
6339:
6340: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6341:
6342: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6343: THEN
6344: OE_MSG_PUB.Add_Exc_Msg
6345: ( G_PKG_NAME
6346: , 'Group_Schedule_sets'
6340: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6341:
6342: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6343: THEN
6344: OE_MSG_PUB.Add_Exc_Msg
6345: ( G_PKG_NAME
6346: , 'Group_Schedule_sets'
6347: );
6348: END IF;
6354:
6355: WHEN OTHERS THEN
6356:
6357:
6358: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6359: THEN
6360: OE_MSG_PUB.Add_Exc_Msg
6361: ( G_PKG_NAME
6362: , 'Group_Schedule_sets'
6356:
6357:
6358: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6359: THEN
6360: OE_MSG_PUB.Add_Exc_Msg
6361: ( G_PKG_NAME
6362: , 'Group_Schedule_sets'
6363: );
6364: END IF;