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_CONFIG_SCHEDULE_PVT dependencies on OE_SCHEDULE_UTIL

Line 184: oe_schedule_util.process_request itself.

180: other attrib changes ex: ordered_quantity along with
181: reserved quantity, the p_sch_action will be RESCHEDULE.
182: Thus, on a pre scheduled line whe action RESERVE comes,
183: we just process the change and not log a request in
184: oe_schedule_util.process_request itself.
185: any other attrib change is sending all the lines to mrp.
186:
187: 2) unschedule, unreserve can not come at the same time
188: of re/schedule. Only reschedule and schedule can come

Line 225: ,p_caller IN VARCHAR2 := OE_SCHEDULE_UTIL.SCH_INTERNAL

221: PROCEDURE Log_Config_Sch_Request
222: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type
223: ,p_old_line_rec IN OE_Order_PUB.Line_Rec_Type
224: ,p_sch_action IN VARCHAR2
225: ,p_caller IN VARCHAR2 := OE_SCHEDULE_UTIL.SCH_INTERNAL
226: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
227: IS
228: l_sch_action VARCHAR2(30);
229: l_unreserve_flag VARCHAR2(1);

Line 282: IF p_sch_action = OE_Schedule_Util.OESCH_ACT_SCHEDULE AND

278:
279:
280: l_sch_action := p_sch_action;
281:
282: IF p_sch_action = OE_Schedule_Util.OESCH_ACT_SCHEDULE AND
283: (p_line_rec.ato_line_id is not null OR
284: p_line_rec.ship_model_complete_flag = 'Y')
285: THEN
286: -- we do not want to query for nonsmc

Line 298: l_sch_action := OE_Schedule_Util.OESCH_ACT_RESCHEDULE;

294: FROM oe_order_lines
295: WHERE line_id = p_line_rec.top_model_line_id;
296:
297: IF l_model_sch_status_code is NOT NULL THEN
298: l_sch_action := OE_Schedule_Util.OESCH_ACT_RESCHEDULE;
299: END IF;
300:
301: END IF;
302: --------- done l_sch_action and return part -----------------

Line 306: IF (p_sch_action = OE_SCHEDULE_UTIL.OESCH_ACT_RESCHEDULE OR

302: --------- done l_sch_action and return part -----------------
303:
304:
305: -- log Reservation / ord qty changes
306: IF (p_sch_action = OE_SCHEDULE_UTIL.OESCH_ACT_RESCHEDULE OR
307: NOT OE_GLOBALS.EQUAL(p_line_rec.reserved_quantity,
308: p_old_line_rec.reserved_quantity)) AND
309: p_line_rec.top_model_line_id <> nvl(p_line_rec.ato_line_id, -1)
310:

Line 467: IF p_caller = OE_SCHEDULE_UTIL.SCH_EXTERNAL THEN

463:
464: END IF;
465:
466:
467: IF p_caller = OE_SCHEDULE_UTIL.SCH_EXTERNAL THEN
468:
469: IF l_debug_level > 0 THEN
470: oe_debug_pub.add( 'CALLER IS EXTERNAL' , 1 ) ;
471: END IF;

Line 789: IF p_request_rec.param1 = Oe_Schedule_Util.OESCH_ACT_SCHEDULE

785: Print_Time('entering Schedule_SMC ' || p_request_rec.entity_id);
786:
787: x_return_status := FND_API.G_RET_STS_SUCCESS;
788: -- 2882255
789: IF p_request_rec.param1 = Oe_Schedule_Util.OESCH_ACT_SCHEDULE
790: OR p_request_rec.param1 = Oe_Schedule_Util.OESCH_ACT_DEMAND THEN
791: l_send_cancel_lines := 'N';
792: ELSE
793: l_send_cancel_lines := 'Y';

Line 790: OR p_request_rec.param1 = Oe_Schedule_Util.OESCH_ACT_DEMAND THEN

786:
787: x_return_status := FND_API.G_RET_STS_SUCCESS;
788: -- 2882255
789: IF p_request_rec.param1 = Oe_Schedule_Util.OESCH_ACT_SCHEDULE
790: OR p_request_rec.param1 = Oe_Schedule_Util.OESCH_ACT_DEMAND THEN
791: l_send_cancel_lines := 'N';
792: ELSE
793: l_send_cancel_lines := 'Y';
794: END IF;

Line 937: IF p_request_rec.param1 = Oe_Schedule_Util.OESCH_ACT_SCHEDULE

933:
934: Print_Time('Entering Schedule_ATO ' || p_request_rec.entity_id);
935: x_return_status := FND_API.G_RET_STS_SUCCESS;
936: -- 2882255
937: IF p_request_rec.param1 = Oe_Schedule_Util.OESCH_ACT_SCHEDULE
938: OR p_request_rec.param1 = Oe_Schedule_Util.OESCH_ACT_DEMAND THEN
939: l_send_cancel_lines := 'N';
940: ELSE
941: l_send_cancel_lines := 'Y';

Line 938: OR p_request_rec.param1 = Oe_Schedule_Util.OESCH_ACT_DEMAND THEN

934: Print_Time('Entering Schedule_ATO ' || p_request_rec.entity_id);
935: x_return_status := FND_API.G_RET_STS_SUCCESS;
936: -- 2882255
937: IF p_request_rec.param1 = Oe_Schedule_Util.OESCH_ACT_SCHEDULE
938: OR p_request_rec.param1 = Oe_Schedule_Util.OESCH_ACT_DEMAND THEN
939: l_send_cancel_lines := 'N';
940: ELSE
941: l_send_cancel_lines := 'Y';
942: END IF;

Line 1134: l_sales_order_id := OE_SCHEDULE_UTIL.Get_mtl_sales_order_id

1130: IF l_line_tbl(J).schedule_status_code is not null AND
1131: l_line_tbl(J).shippable_flag = 'Y' THEN
1132:
1133: IF l_sales_order_id is NULL THEN
1134: l_sales_order_id := OE_SCHEDULE_UTIL.Get_mtl_sales_order_id
1135: (l_line_tbl(J).header_id);
1136: END IF;
1137:
1138: l_line_tbl(J).reserved_quantity :=

Line 1267: IF p_request_tbl(p_req_index).param1 = Oe_Schedule_Util.OESCH_ACT_SCHEDULE

1263: oe_debug_pub.add( 'ENTERING GET_INCLUDED_ITEMS_TO_SCH' , 3 ) ;
1264: END IF;
1265:
1266: -- 2882255
1267: IF p_request_tbl(p_req_index).param1 = Oe_Schedule_Util.OESCH_ACT_SCHEDULE
1268: OR p_request_tbl(p_req_index).param1 = Oe_Schedule_Util.OESCH_ACT_DEMAND THEN
1269: l_send_cancel_lines := 'N';
1270: ELSE
1271: l_send_cancel_lines := 'Y';

Line 1268: OR p_request_tbl(p_req_index).param1 = Oe_Schedule_Util.OESCH_ACT_DEMAND THEN

1264: END IF;
1265:
1266: -- 2882255
1267: IF p_request_tbl(p_req_index).param1 = Oe_Schedule_Util.OESCH_ACT_SCHEDULE
1268: OR p_request_tbl(p_req_index).param1 = Oe_Schedule_Util.OESCH_ACT_DEMAND THEN
1269: l_send_cancel_lines := 'N';
1270: ELSE
1271: l_send_cancel_lines := 'Y';
1272: END IF;

Line 1339: OE_SCHEDULE_UTIL.OESCH_ACT_RESCHEDULE THEN

1335: ,p_x_line_rec => p_x_line_tbl(p_in_index)
1336: ,p_x_old_line_rec => p_x_old_line_tbl(p_in_index));
1337:
1338: IF p_request_tbl(p_req_index).param1 =
1339: OE_SCHEDULE_UTIL.OESCH_ACT_RESCHEDULE THEN
1340: Log_Attribute_Changes
1341: (p_line_rec => p_x_line_tbl(p_in_index)
1342: ,p_old_line_rec => p_x_old_line_tbl(p_in_index)
1343: ,x_unreserve_flag => l_unreserve_flag);

Line 1422: IF p_sch_action = OE_SCHEDULE_UTIL.OESCH_ACT_UNSCHEDULE OR

1418: Print_Time('entering Process_Group');
1419:
1420: x_return_status := FND_API.G_RET_STS_SUCCESS;
1421:
1422: IF p_sch_action = OE_SCHEDULE_UTIL.OESCH_ACT_UNSCHEDULE OR
1423: p_sch_action = OE_SCHEDULE_UTIL.OESCH_ACT_UNRESERVE
1424: THEN
1425: IF l_debug_level > 0 THEN
1426: oe_debug_pub.add( 'UNRESERVING...' , 3 ) ;

Line 1423: p_sch_action = OE_SCHEDULE_UTIL.OESCH_ACT_UNRESERVE

1419:
1420: x_return_status := FND_API.G_RET_STS_SUCCESS;
1421:
1422: IF p_sch_action = OE_SCHEDULE_UTIL.OESCH_ACT_UNSCHEDULE OR
1423: p_sch_action = OE_SCHEDULE_UTIL.OESCH_ACT_UNRESERVE
1424: THEN
1425: IF l_debug_level > 0 THEN
1426: oe_debug_pub.add( 'UNRESERVING...' , 3 ) ;
1427: END IF;

Line 1432: IF p_sch_action = OE_Schedule_Util.OESCH_ACT_UNSCHEDULE

1428:
1429: Unreserve_group(p_line_tbl => p_x_line_tbl
1430: ,p_sch_action => p_sch_action); -- 2595661
1431:
1432: IF p_sch_action = OE_Schedule_Util.OESCH_ACT_UNSCHEDULE
1433: THEN
1434: IF l_debug_level > 0 THEN
1435: oe_debug_pub.add( 'NOW UNSCHEDULING...' , 3 ) ;
1436: END IF;

Line 1451: IF p_sch_action = OE_Schedule_Util.OESCH_ACT_RESERVE THEN

1447: IF l_debug_level > 0 THEN
1448: oe_debug_pub.add( 'SCH ACTION IS '|| P_SCH_ACTION , 3 ) ;
1449: END IF;
1450:
1451: IF p_sch_action = OE_Schedule_Util.OESCH_ACT_RESERVE THEN
1452: l_sch_action := OE_Schedule_Util.OESCH_ACT_SCHEDULE;
1453: ELSE
1454: l_sch_action := p_sch_action;
1455: END IF;

Line 1452: l_sch_action := OE_Schedule_Util.OESCH_ACT_SCHEDULE;

1448: oe_debug_pub.add( 'SCH ACTION IS '|| P_SCH_ACTION , 3 ) ;
1449: END IF;
1450:
1451: IF p_sch_action = OE_Schedule_Util.OESCH_ACT_RESERVE THEN
1452: l_sch_action := OE_Schedule_Util.OESCH_ACT_SCHEDULE;
1453: ELSE
1454: l_sch_action := p_sch_action;
1455: END IF;
1456:

Line 1457: IF p_sch_action = OE_Schedule_Util.OESCH_ACT_RESCHEDULE AND

1453: ELSE
1454: l_sch_action := p_sch_action;
1455: END IF;
1456:
1457: IF p_sch_action = OE_Schedule_Util.OESCH_ACT_RESCHEDULE AND
1458: (p_handle_unreserve = 'Y' OR
1459: p_caller = 'SET')
1460: THEN
1461: IF l_debug_level > 0 THEN

Line 1486: IF p_sch_action = OE_Schedule_Util.OESCH_ACT_RESCHEDULE AND

1482: -- Additing additional Unreserve call as part of item substitution
1483: -- Project. If the item has been replaced by MRP during re-scheduling
1484: -- process then unreserve the reservation on old item.
1485:
1486: IF p_sch_action = OE_Schedule_Util.OESCH_ACT_RESCHEDULE AND
1487: p_caller = 'SET'
1488: THEN
1489: IF l_debug_level > 0 THEN
1490: oe_debug_pub.add( '2 CALLING HANDLE_UNRESERVE' , 4 ) ;

Line 1504: IF p_sch_action <> OE_SCHEDULE_UTIL.OESCH_ACT_UNRESERVE THEN

1500:
1501: END IF; ------- end if action = unsch or unres -----
1502:
1503:
1504: IF p_sch_action <> OE_SCHEDULE_UTIL.OESCH_ACT_UNRESERVE THEN
1505:
1506: Save_Sch_Attributes
1507: ( p_x_line_tbl => p_x_line_tbl
1508: ,p_old_line_tbl => p_old_line_tbl

Line 1510: ,p_caller => OE_SCHEDULE_UTIL.SCH_EXTERNAL

1506: Save_Sch_Attributes
1507: ( p_x_line_tbl => p_x_line_tbl
1508: ,p_old_line_tbl => p_old_line_tbl
1509: ,p_sch_action => p_sch_action
1510: ,p_caller => OE_SCHEDULE_UTIL.SCH_EXTERNAL
1511: ,x_return_status => x_return_status);
1512:
1513: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1514: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1526: p_sch_action <> OE_Schedule_Util.OESCH_ACT_UNSCHEDULE AND

1522: END IF;
1523:
1524:
1525: IF p_caller <> 'SCHEDULE_ATO' AND
1526: p_sch_action <> OE_Schedule_Util.OESCH_ACT_UNSCHEDULE AND
1527: p_sch_action <> OE_Schedule_Util.OESCH_ACT_UNRESERVE
1528: THEN
1529: IF l_debug_level > 0 THEN
1530: oe_debug_pub.add( 'CALLING RESERVE_GROUP NOW ' , 3 ) ;

Line 1527: p_sch_action <> OE_Schedule_Util.OESCH_ACT_UNRESERVE

1523:
1524:
1525: IF p_caller <> 'SCHEDULE_ATO' AND
1526: p_sch_action <> OE_Schedule_Util.OESCH_ACT_UNSCHEDULE AND
1527: p_sch_action <> OE_Schedule_Util.OESCH_ACT_UNRESERVE
1528: THEN
1529: IF l_debug_level > 0 THEN
1530: oe_debug_pub.add( 'CALLING RESERVE_GROUP NOW ' , 3 ) ;
1531: END IF;

Line 1620: OE_Schedule_Util.Load_MRP_request_from_tbl

1616: Print_Time('entering Call_Mrp');
1617:
1618: x_return_status := FND_API.G_RET_STS_SUCCESS;
1619:
1620: OE_Schedule_Util.Load_MRP_request_from_tbl
1621: ( p_line_tbl => p_x_line_tbl
1622: ,p_old_line_tbl => p_old_line_tbl
1623: ,p_sch_action => p_sch_action
1624: ,p_partial_set => p_partial_set

Line 1637: l_session_id := OE_SCHEDULE_UTIL.Get_Session_Id;

1633: oe_debug_pub.add( 'NEED TO CALL MRP , > 0 COUNT' , 1 ) ;
1634: END IF;
1635:
1636:
1637: l_session_id := OE_SCHEDULE_UTIL.Get_Session_Id;
1638:
1639: IF l_debug_level > 0 THEN
1640: oe_debug_pub.add( 'SESSION ID IN CALL_MRP ' || L_SESSION_ID , 2 ) ;
1641: END IF;

Line 1662: OE_SCHEDULE_UTIL.Display_sch_errors

1658: Print_Time('After MRPs ATP API: ' || x_return_status);
1659:
1660: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1661:
1662: OE_SCHEDULE_UTIL.Display_sch_errors
1663: (p_atp_rec => l_out_mtp_atp_rec,
1664: p_line_tbl => p_x_line_tbl);
1665:
1666: END IF;

Line 1677: OE_Schedule_Util.Load_Results_from_tbl

1673: IF l_debug_level > 0 THEN
1674: oe_debug_pub.add( 'CALLING LOAD_RESULTS' , 1 ) ;
1675: END IF;
1676:
1677: OE_Schedule_Util.Load_Results_from_tbl
1678: ( p_atp_rec => l_out_mtp_atp_rec
1679: , p_old_line_tbl => p_old_line_tbl -- 1955004
1680: , p_x_line_tbl => p_x_line_tbl
1681: , p_sch_action => p_sch_action

Line 1705: IF OE_SCHEDULE_UTIL.OE_inactive_demand_tbl.count > 0 THEN

1701:
1702: END IF;
1703:
1704: -- New Code for 1955004
1705: IF OE_SCHEDULE_UTIL.OE_inactive_demand_tbl.count > 0 THEN
1706: -- even though MRP did not have anything, we have some
1707: -- Inactive Demand Rows to process
1708:
1709: FOR I in 1.. p_x_line_tbl.count LOOP

Line 1711: IF OE_SCHEDULE_UTIL.OE_inactive_demand_tbl.EXISTS

1707: -- Inactive Demand Rows to process
1708:
1709: FOR I in 1.. p_x_line_tbl.count LOOP
1710:
1711: IF OE_SCHEDULE_UTIL.OE_inactive_demand_tbl.EXISTS
1712: (p_x_line_tbl(I).line_id) THEN
1713: -- we know this line has an inactive demand scheduling level
1714:
1715: IF l_debug_level > 0 THEN

Line 1719: OE_SCHEDULE_UTIL.Inactive_demand_scheduling

1715: IF l_debug_level > 0 THEN
1716: oe_debug_pub.add( 'CALLING INACTIVE_DEMAND_SCHEDULING FROM ELSE IN CALL_MRP' , 1 ) ;
1717: END IF;
1718:
1719: OE_SCHEDULE_UTIL.Inactive_demand_scheduling
1720: (p_x_old_line_rec => p_old_line_tbl(I)
1721: ,p_x_line_rec => p_x_line_tbl(I)
1722: ,x_return_status => x_return_status);
1723:

Line 1724: OE_SCHEDULE_UTIL.OE_inactive_demand_tbl.DELETE

1720: (p_x_old_line_rec => p_old_line_tbl(I)
1721: ,p_x_line_rec => p_x_line_tbl(I)
1722: ,x_return_status => x_return_status);
1723:
1724: OE_SCHEDULE_UTIL.OE_inactive_demand_tbl.DELETE
1725: (p_x_line_tbl(I).line_id);
1726:
1727: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1728: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1800: IF ( (p_sch_action = OE_Schedule_Util.OESCH_ACT_UNRESERVE

1796: oe_debug_pub.add( P_LINE_TBL ( I ) .LINE_ID||'UNRESERVE ' ||P_LINE_TBL ( I ) .RESERVED_QUANTITY , 3 ) ;
1797: END IF;
1798: -- Start 2595661
1799: IF nvl(p_line_tbl(I).shipping_interfaced_flag,'N') = 'Y' THEN
1800: IF ( (p_sch_action = OE_Schedule_Util.OESCH_ACT_UNRESERVE
1801: OR p_sch_action = OE_Schedule_Util.OESCH_ACT_RESCHEDULE) -- 6628134
1802: AND NOT oe_schedule_util.Get_Pick_Status(p_line_tbl(I).line_id) ) THEN
1803:
1804: OE_SCHEDULE_UTIL.Do_Unreserve

Line 1801: OR p_sch_action = OE_Schedule_Util.OESCH_ACT_RESCHEDULE) -- 6628134

1797: END IF;
1798: -- Start 2595661
1799: IF nvl(p_line_tbl(I).shipping_interfaced_flag,'N') = 'Y' THEN
1800: IF ( (p_sch_action = OE_Schedule_Util.OESCH_ACT_UNRESERVE
1801: OR p_sch_action = OE_Schedule_Util.OESCH_ACT_RESCHEDULE) -- 6628134
1802: AND NOT oe_schedule_util.Get_Pick_Status(p_line_tbl(I).line_id) ) THEN
1803:
1804: OE_SCHEDULE_UTIL.Do_Unreserve
1805: ( p_line_rec => p_line_tbl(I)

Line 1802: AND NOT oe_schedule_util.Get_Pick_Status(p_line_tbl(I).line_id) ) THEN

1798: -- Start 2595661
1799: IF nvl(p_line_tbl(I).shipping_interfaced_flag,'N') = 'Y' THEN
1800: IF ( (p_sch_action = OE_Schedule_Util.OESCH_ACT_UNRESERVE
1801: OR p_sch_action = OE_Schedule_Util.OESCH_ACT_RESCHEDULE) -- 6628134
1802: AND NOT oe_schedule_util.Get_Pick_Status(p_line_tbl(I).line_id) ) THEN
1803:
1804: OE_SCHEDULE_UTIL.Do_Unreserve
1805: ( p_line_rec => p_line_tbl(I)
1806: , p_quantity_to_unreserve => p_line_tbl(I).reserved_quantity

Line 1804: OE_SCHEDULE_UTIL.Do_Unreserve

1800: IF ( (p_sch_action = OE_Schedule_Util.OESCH_ACT_UNRESERVE
1801: OR p_sch_action = OE_Schedule_Util.OESCH_ACT_RESCHEDULE) -- 6628134
1802: AND NOT oe_schedule_util.Get_Pick_Status(p_line_tbl(I).line_id) ) THEN
1803:
1804: OE_SCHEDULE_UTIL.Do_Unreserve
1805: ( p_line_rec => p_line_tbl(I)
1806: , p_quantity_to_unreserve => p_line_tbl(I).reserved_quantity
1807: , p_quantity2_to_unreserve => NVL(p_line_tbl(I).reserved_quantity2, 0) -- INVCONV
1808: , x_return_status => l_return_status);

Line 1813: OE_SCHEDULE_UTIL.Unreserve_Line

1809: END IF;
1810: ELSE
1811: -- End 2595661
1812:
1813: OE_SCHEDULE_UTIL.Unreserve_Line
1814: ( p_line_rec => p_line_tbl(I)
1815: ,p_quantity_to_unreserve => p_line_tbl(I).reserved_quantity
1816: ,p_quantity2_to_unreserve => nvl(p_line_tbl(I).reserved_quantity2, 0) -- INVCONV
1817: ,x_return_status => l_return_status);

Line 1826: IF p_sch_action = OE_Schedule_Util.OESCH_ACT_RESCHEDULE THEN

1822: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1823: RAISE FND_API.G_EXC_ERROR;
1824: END IF;
1825:
1826: IF p_sch_action = OE_Schedule_Util.OESCH_ACT_RESCHEDULE THEN
1827:
1828: IF NOT OE_Reservations_Tbl.EXISTS(p_line_tbl(I).line_id) OR
1829: OE_Reservations_Tbl(p_line_tbl(I).line_id).qty_to_reserve
1830: is NULL

Line 1962: OE_SCHEDULE_UTIL.OESCH_STATUS_SCHEDULED

1958: IF nvl(p_x_line_tbl(I).shippable_flag, 'N') = 'Y' AND
1959: p_x_line_tbl(I).ordered_quantity > 0 AND
1960: p_x_line_tbl(I).Item_type_code <> 'CONFIG' AND
1961: nvl(p_x_line_tbl(I).schedule_status_code, 'X') =
1962: OE_SCHEDULE_UTIL.OESCH_STATUS_SCHEDULED
1963: THEN
1964: IF l_debug_level > 0 THEN
1965: oe_debug_pub.add( 'WORKING ON LINE '|| P_X_LINE_TBL ( I ) .LINE_ID , 3 ) ;
1966: END IF;

Line 1968: l_sch_level := OE_SCHEDULE_UTIL.Get_Scheduling_Level

1964: IF l_debug_level > 0 THEN
1965: oe_debug_pub.add( 'WORKING ON LINE '|| P_X_LINE_TBL ( I ) .LINE_ID , 3 ) ;
1966: END IF;
1967:
1968: l_sch_level := OE_SCHEDULE_UTIL.Get_Scheduling_Level
1969: (p_x_line_tbl(I).header_id,
1970: p_x_line_tbl(I).line_type_id);
1971:
1972:

Line 1973: IF nvl(l_sch_level, OE_Schedule_Util.SCH_LEVEL_THREE) =

1969: (p_x_line_tbl(I).header_id,
1970: p_x_line_tbl(I).line_type_id);
1971:
1972:
1973: IF nvl(l_sch_level, OE_Schedule_Util.SCH_LEVEL_THREE) =
1974: OE_Schedule_Util.SCH_LEVEL_THREE
1975: OR l_sch_level = OE_Schedule_Util.SCH_LEVEL_FOUR
1976: THEN
1977: IF l_debug_level > 0 THEN

Line 1974: OE_Schedule_Util.SCH_LEVEL_THREE

1970: p_x_line_tbl(I).line_type_id);
1971:
1972:
1973: IF nvl(l_sch_level, OE_Schedule_Util.SCH_LEVEL_THREE) =
1974: OE_Schedule_Util.SCH_LEVEL_THREE
1975: OR l_sch_level = OE_Schedule_Util.SCH_LEVEL_FOUR
1976: THEN
1977: IF l_debug_level > 0 THEN
1978: oe_debug_pub.add( 'SCH LEVEL ALLOWS FOR RESERVATION' , 3 ) ;

Line 1975: OR l_sch_level = OE_Schedule_Util.SCH_LEVEL_FOUR

1971:
1972:
1973: IF nvl(l_sch_level, OE_Schedule_Util.SCH_LEVEL_THREE) =
1974: OE_Schedule_Util.SCH_LEVEL_THREE
1975: OR l_sch_level = OE_Schedule_Util.SCH_LEVEL_FOUR
1976: THEN
1977: IF l_debug_level > 0 THEN
1978: oe_debug_pub.add( 'SCH LEVEL ALLOWS FOR RESERVATION' , 3 ) ;
1979: END IF;

Line 1991: IF p_sch_action = OE_Schedule_Util.OESCH_ACT_RESERVE OR

1987: -- no user change
1988:
1989: IF p_x_line_tbl(I).reserved_quantity = 0 THEN
1990:
1991: IF p_sch_action = OE_Schedule_Util.OESCH_ACT_RESERVE OR
1992: OE_SCHEDULE_UTIL.Within_Rsv_Time_Fence
1993: (p_x_line_tbl(I).schedule_ship_date, p_x_line_tbl(I).org_id) THEN --4689197
1994:
1995: IF l_debug_level > 0 THEN

Line 1992: OE_SCHEDULE_UTIL.Within_Rsv_Time_Fence

1988:
1989: IF p_x_line_tbl(I).reserved_quantity = 0 THEN
1990:
1991: IF p_sch_action = OE_Schedule_Util.OESCH_ACT_RESERVE OR
1992: OE_SCHEDULE_UTIL.Within_Rsv_Time_Fence
1993: (p_x_line_tbl(I).schedule_ship_date, p_x_line_tbl(I).org_id) THEN --4689197
1994:
1995: IF l_debug_level > 0 THEN
1996: oe_debug_pub.add( 'RESERVE '||P_X_LINE_TBL ( I ) .ORDERED_QUANTITY , 3 ) ;

Line 2008: ELSIF oe_schedule_util.Within_Rsv_Time_Fence(p_x_line_tbl(I).schedule_ship_date, p_x_line_tbl(I).org_id) THEN --4689197

2004: --Post Pack J
2005: -- If partial reservation falg is Yes and line have some reservation
2006: -- Reserve the remaining quantity.
2007: --ELSIF Oe_Sys_Parameters.Value('PARTIAL_RESERVATION_FLAG') = 'Y'
2008: ELSIF oe_schedule_util.Within_Rsv_Time_Fence(p_x_line_tbl(I).schedule_ship_date, p_x_line_tbl(I).org_id) THEN --4689197
2009: IF nvl(p_x_line_tbl(I).ordered_quantity,0) > nvl(p_x_line_tbl(I).reserved_quantity,0) THEN -- INVCONV
2010: l_reservation_qty := nvl(p_x_line_tbl(I).ordered_quantity,0) - nvl(p_x_line_tbl(I).reserved_quantity,0);
2011: END IF;
2012: IF nvl(p_x_line_tbl(I).ordered_quantity2,0) > nvl(p_x_line_tbl(I).reserved_quantity2,0) THEN -- INVCONV

Line 2039: AND oe_schedule_util.Within_Rsv_Time_Fence(p_x_line_tbl(I).schedule_ship_date, p_x_line_tbl(I).org_id) THEN --4689197

2035: -- Post Pack J
2036: -- Send the full order quantity for reservation if partial reservation flag is 'Yes'.
2037: ELSIF l_reservation_qty > 0
2038: --AND Oe_Sys_Parameters.Value('PARTIAL_RESERVATION_FLAG') = 'Y'
2039: AND oe_schedule_util.Within_Rsv_Time_Fence(p_x_line_tbl(I).schedule_ship_date, p_x_line_tbl(I).org_id) THEN --4689197
2040: l_reservation_qty := p_x_line_tbl(I).ordered_quantity;
2041: l_reservation_qty2 := p_x_line_tbl(I).ordered_quantity2; -- INVCONV
2042: END IF; -- reservation_aty = 0
2043:

Line 2054: OE_SCHEDULE_UTIL.Reserve_Line

2050: IF l_reservation_qty > 0 THEN
2051: p_x_line_tbl(I).reserved_quantity := l_reservation_qty;
2052: p_x_line_tbl(I).reserved_quantity2 := l_reservation_qty2; -- INVCONV
2053:
2054: OE_SCHEDULE_UTIL.Reserve_Line
2055: ( p_line_rec => p_x_line_tbl(I)
2056: ,p_quantity_to_Reserve => p_x_line_tbl(I).reserved_quantity
2057: ,p_quantity2_to_Reserve => p_x_line_tbl(I).reserved_quantity2 -- INVCONV
2058: ,p_rsv_update => l_rsv_update

Line 2218: OE_SCHEDULE_UTIL.Unreserve_Line

2214: AND NOT OE_GLOBALS.Equal(p_x_line_tbl(I).inventory_item_id,
2215: p_old_line_tbl(I).inventory_item_id)
2216: AND p_old_line_tbl(I).reserved_quantity > 0 THEN
2217:
2218: OE_SCHEDULE_UTIL.Unreserve_Line
2219: (p_line_rec => p_old_line_tbl(I),
2220: p_quantity_to_unreserve => p_old_line_tbl(I).reserved_quantity,
2221: p_quantity2_to_unreserve => p_old_line_tbl(I).reserved_quantity2, -- INVCONV
2222: x_return_status => x_return_status);

Line 2242: ,p_sch_action => OE_Schedule_Util.OESCH_ACT_RESCHEDULE);

2238: oe_debug_pub.add( 'UNRESERVING...' , 3 ) ;
2239: END IF;
2240: Unreserve_group
2241: ( p_line_tbl => p_old_line_tbl
2242: ,p_sch_action => OE_Schedule_Util.OESCH_ACT_RESCHEDULE);
2243:
2244: RETURN;
2245: END IF;
2246:

Line 2289: OE_SCHEDULE_UTIL.Unreserve_Line

2285: oe_debug_pub.add( L_QTY2||' UNRESERVE 2'||P_X_LINE_TBL ( I ) .LINE_ID , 3 ) ;
2286: END IF;
2287:
2288: IF l_qty > 0 THEN
2289: OE_SCHEDULE_UTIL.Unreserve_Line
2290: ( p_line_rec => p_x_line_tbl(I)
2291: ,p_old_ship_from_org_id => p_old_line_tbl(I).ship_from_org_id --6628134
2292: ,p_quantity_to_unreserve => l_qty
2293: ,p_quantity2_to_unreserve => l_qty2 -- INVCONV

Line 2335: OE_Schedule_Util.Validate_Line

2331: oe_debug_pub.add( '--------ENTERING VALIDATE_AND_ASSIGN' , 1 ) ;
2332: END IF;
2333:
2334: /* 3533565 Validation will be done after cascading
2335: OE_Schedule_Util.Validate_Line
2336: ( p_line_rec => p_x_line_rec
2337: ,p_old_line_rec => p_x_old_line_rec
2338: ,p_sch_action => p_request_rec.param1
2339: ,x_return_status => l_return_status);

Line 2376: OE_Schedule_Util.Validate_Line

2372: p_x_line_rec.schedule_ship_date := p_request_rec.date_param2;
2373: p_x_line_rec.schedule_arrival_date := p_request_rec.date_param3;
2374:
2375: -- 3533565
2376: OE_Schedule_Util.Validate_Line
2377: ( p_line_rec => p_x_line_rec
2378: ,p_old_line_rec => p_x_old_line_rec
2379: ,p_sch_action => p_request_rec.param1
2380: ,x_return_status => l_return_status);

Line 2399: IF p_request_rec.param1 = OE_SCHEDULE_UTIL.OESCH_ACT_RESCHEDULE

2395: p_x_line_rec.ship_set := p_request_rec.entity_id;
2396: END IF;
2397:
2398: -- 4052648: Assign old values for ato model for unschedule action
2399: IF p_request_rec.param1 = OE_SCHEDULE_UTIL.OESCH_ACT_RESCHEDULE
2400: OR (p_request_rec.param1 = OE_SCHEDULE_UTIL.OESCH_ACT_UNSCHEDULE
2401: AND p_x_line_rec.ato_line_id IS NOT NULL)
2402: -- bug 2427280 AND p_x_old_line_rec.schedule_status_code is NOT NULL
2403: THEN

Line 2400: OR (p_request_rec.param1 = OE_SCHEDULE_UTIL.OESCH_ACT_UNSCHEDULE

2396: END IF;
2397:
2398: -- 4052648: Assign old values for ato model for unschedule action
2399: IF p_request_rec.param1 = OE_SCHEDULE_UTIL.OESCH_ACT_RESCHEDULE
2400: OR (p_request_rec.param1 = OE_SCHEDULE_UTIL.OESCH_ACT_UNSCHEDULE
2401: AND p_x_line_rec.ato_line_id IS NOT NULL)
2402: -- bug 2427280 AND p_x_old_line_rec.schedule_status_code is NOT NULL
2403: THEN
2404: IF l_debug_level > 0 THEN

Line 2592: IF p_sch_action <> OE_SCHEDULE_UTIL.OESCH_ACT_UNSCHEDULE THEN

2588:
2589: /*Uncommented the sql for Bug 3144917 */
2590:
2591: -- 4052648 : Do not query for action - UNSCHEDULE
2592: IF p_sch_action <> OE_SCHEDULE_UTIL.OESCH_ACT_UNSCHEDULE THEN
2593:
2594: SELECT request_date, schedule_ship_date,
2595: schedule_arrival_date,
2596: ship_from_org_id, ship_to_org_id,

Line 2679: IF p_sch_action = OE_Schedule_Util.OESCH_ACT_RESCHEDULE THEN

2675: oe_debug_pub.add(P_X_LINE_TBL( I ).Firm_Demand_Flag , 3 ) ;
2676: END IF;
2677:
2678:
2679: IF p_sch_action = OE_Schedule_Util.OESCH_ACT_RESCHEDULE THEN
2680: IF NOT OE_GLOBALS.Equal(p_x_line_tbl(I).request_date,
2681: p_old_line_tbl(I).request_date) OR
2682:
2683: NOT OE_GLOBALS.Equal(p_x_line_tbl(I).schedule_ship_date,

Line 2764: IF p_sch_action = OE_Schedule_Util.OESCH_ACT_RESCHEDULE THEN

2760: l_call_po := 'Y';
2761: END IF;
2762:
2763:
2764: IF p_sch_action = OE_Schedule_Util.OESCH_ACT_RESCHEDULE THEN
2765:
2766: IF l_debug_level > 0 THEN
2767: oe_debug_pub.add( 'MAY UPDATE RESERN '|| P_X_LINE_TBL ( I ) .LINE_ID , 3 ) ;
2768: END IF;

Line 2800: OE_SCHEDULE_UTIL.Update_PO(p_x_line_tbl(I).schedule_arrival_date,

2796: -- a new delayed request of type OE_Globals.G_UPDATE_REQUISITION, which
2797: -- is added as part of this project
2798: --
2799: /*
2800: OE_SCHEDULE_UTIL.Update_PO(p_x_line_tbl(I).schedule_arrival_date,
2801: p_x_line_tbl(I).source_document_id,
2802: p_x_line_tbl(I).source_document_line_id);
2803: */
2804: --

Line 2925: OE_SCHEDULE_UTIL.Update_PO(p_x_line_tbl(I).schedule_arrival_date,

2921: IF l_debug_level > 0 THEN
2922: oe_debug_pub.add(' Need By Date is not allowed to update. Updating MTL_Supply only',5);
2923: END IF;
2924:
2925: OE_SCHEDULE_UTIL.Update_PO(p_x_line_tbl(I).schedule_arrival_date,
2926: p_x_line_tbl(I).source_document_id,
2927: p_x_line_tbl(I).source_document_line_id);
2928: END IF;
2929:

Line 2972: OE_Schedule_Util.Call_Process_Order

2968:
2969: l_control_rec.clear_api_cache := FALSE;
2970: l_control_rec.clear_api_requests := FALSE;
2971:
2972: OE_Schedule_Util.Call_Process_Order
2973: ( p_x_old_line_tbl => p_old_line_tbl
2974: ,p_x_line_tbl => p_x_line_tbl
2975: ,p_control_rec => l_control_rec
2976: ,p_caller => p_caller

Line 2985: IF p_caller = OE_Schedule_Util.SCH_INTERNAL THEN

2981: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2982: RAISE FND_API.G_EXC_ERROR;
2983: END IF;
2984:
2985: IF p_caller = OE_Schedule_Util.SCH_INTERNAL THEN
2986: l_process_requests := FALSE;
2987: ELSE
2988: l_process_requests := TRUE;
2989: END IF;

Line 3190: IF NOT OE_SCHEDULE_UTIL.validate_ship_method

3186: IF l_debug_level > 0 THEN
3187: oe_debug_pub.add( 'BEFORE DOING DIRECT UPDATE' , 1 ) ;
3188: END IF;
3189:
3190: IF NOT OE_SCHEDULE_UTIL.validate_ship_method
3191: (p_x_line_rec.shipping_method_code,
3192: p_old_line_rec.shipping_method_code,
3193: p_x_line_rec.ship_from_org_id) THEN
3194:

Line 3252: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FROM OE_SCHEDULE_UTIL.PROCESS_LINE IS: ' || L_RETURN_STATUS ) ;

3248: p_line_id => p_x_line_rec.line_id,
3249: x_index => l_index,
3250: x_return_status => l_return_status);
3251: IF l_debug_level > 0 THEN
3252: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FROM OE_SCHEDULE_UTIL.PROCESS_LINE IS: ' || L_RETURN_STATUS ) ;
3253: oe_debug_pub.add( 'GLOBAL PICTURE INDEX IS: ' || L_INDEX , 1 ) ;
3254: END IF;
3255:
3256: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 3346: l_sales_order_id := OE_SCHEDULE_UTIL.Get_mtl_sales_order_id

3342: END IF;
3343:
3344: l_rsv_rec.reservation_id := fnd_api.g_miss_num;
3345:
3346: l_sales_order_id := OE_SCHEDULE_UTIL.Get_mtl_sales_order_id
3347: (p_line_rec.header_id);
3348:
3349: l_rsv_rec.demand_source_header_id := l_sales_order_id;
3350: l_rsv_rec.demand_source_line_id := p_line_rec.line_id;

Line 3523: IF nvl(p_sch_action, 'A' ) <> OE_Schedule_Util.OESCH_ACT_UNSCHEDULE

3519: RAISE FND_API.G_EXC_ERROR;
3520: END IF;
3521:
3522:
3523: IF nvl(p_sch_action, 'A' ) <> OE_Schedule_Util.OESCH_ACT_UNSCHEDULE
3524: AND
3525: nvl(p_sch_action, 'A' ) <> OE_Schedule_Util.OESCH_ACT_UNRESERVE
3526: THEN
3527:

Line 3525: nvl(p_sch_action, 'A' ) <> OE_Schedule_Util.OESCH_ACT_UNRESERVE

3521:
3522:
3523: IF nvl(p_sch_action, 'A' ) <> OE_Schedule_Util.OESCH_ACT_UNSCHEDULE
3524: AND
3525: nvl(p_sch_action, 'A' ) <> OE_Schedule_Util.OESCH_ACT_UNRESERVE
3526: THEN
3527:
3528: l_sch_gloabl_value := OE_SCHEDULE_UTIL.OESCH_PERFORM_SCHEDULING;
3529: OE_SCHEDULE_UTIL.OESCH_PERFORM_SCHEDULING := 'N';

Line 3528: l_sch_gloabl_value := OE_SCHEDULE_UTIL.OESCH_PERFORM_SCHEDULING;

3524: AND
3525: nvl(p_sch_action, 'A' ) <> OE_Schedule_Util.OESCH_ACT_UNRESERVE
3526: THEN
3527:
3528: l_sch_gloabl_value := OE_SCHEDULE_UTIL.OESCH_PERFORM_SCHEDULING;
3529: OE_SCHEDULE_UTIL.OESCH_PERFORM_SCHEDULING := 'N';
3530: OE_ORDER_SCH_UTIL.OESCH_PERFORM_SCHEDULING := 'N';
3531:
3532: IF l_debug_level > 0 THEN

Line 3529: OE_SCHEDULE_UTIL.OESCH_PERFORM_SCHEDULING := 'N';

3525: nvl(p_sch_action, 'A' ) <> OE_Schedule_Util.OESCH_ACT_UNRESERVE
3526: THEN
3527:
3528: l_sch_gloabl_value := OE_SCHEDULE_UTIL.OESCH_PERFORM_SCHEDULING;
3529: OE_SCHEDULE_UTIL.OESCH_PERFORM_SCHEDULING := 'N';
3530: OE_ORDER_SCH_UTIL.OESCH_PERFORM_SCHEDULING := 'N';
3531:
3532: IF l_debug_level > 0 THEN
3533: oe_debug_pub.add( 'CHECK IF II ITEMS REQ.' , 3 ) ;

Line 3553: OE_SCHEDULE_UTIL.OESCH_PERFORM_SCHEDULING := l_sch_gloabl_value;

3549: RAISE FND_API.G_EXC_ERROR;
3550: END IF;
3551: END LOOP;
3552:
3553: OE_SCHEDULE_UTIL.OESCH_PERFORM_SCHEDULING := l_sch_gloabl_value;
3554: OE_ORDER_SCH_UTIL.OESCH_PERFORM_SCHEDULING := 'Y';
3555: END IF;
3556:
3557:

Line 3604: l_sales_order_id := OE_SCHEDULE_UTIL.Get_mtl_sales_order_id

3600: IF x_line_tbl.count > 0 THEN
3601: IF l_debug_level > 0 THEN
3602: oe_debug_pub.add( 'NO. OF LINES '|| X_LINE_TBL.COUNT , 3 ) ;
3603: END IF;
3604: l_sales_order_id := OE_SCHEDULE_UTIL.Get_mtl_sales_order_id
3605: (p_header_id);
3606: END IF;
3607:
3608: I := x_line_tbl.FIRST;

Line 3670: OE_SCHEDULE_UTIL.OESCH_PERFORM_SCHEDULING := 'Y';

3666:
3667: EXCEPTION
3668:
3669: WHEN FND_API.G_EXC_ERROR THEN
3670: OE_SCHEDULE_UTIL.OESCH_PERFORM_SCHEDULING := 'Y';
3671: OE_ORDER_SCH_UTIL.OESCH_PERFORM_SCHEDULING := 'Y';
3672: IF l_debug_level > 0 THEN
3673: oe_debug_pub.add( 'EXC ERROR IN Query_Set_Lines' , 1 ) ;
3674: END IF;

Line 3679: OE_SCHEDULE_UTIL.OESCH_PERFORM_SCHEDULING := 'Y';

3675: x_return_status := FND_API.G_RET_STS_ERROR;
3676:
3677: WHEN OTHERS THEN
3678:
3679: OE_SCHEDULE_UTIL.OESCH_PERFORM_SCHEDULING := 'Y';
3680: OE_ORDER_SCH_UTIL.OESCH_PERFORM_SCHEDULING := 'Y';
3681:
3682: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3683: THEN

Line 3839: p_sch_action = OE_SCHEDULE_UTIL.OESCH_ACT_SCHEDULE

3835: FROM oe_order_lines
3836: WHERE line_id = p_line_rec.ato_line_id;
3837:
3838: IF l_num_id is NULL AND
3839: p_sch_action = OE_SCHEDULE_UTIL.OESCH_ACT_SCHEDULE
3840: THEN
3841:
3842: FND_MESSAGE.SET_NAME('ONT','OE_SCH_ATO_WHSE_REQD');
3843: OE_MSG_PUB.Add;

Line 3851: IF (p_sch_action = OE_SCHEDULE_UTIL.OESCH_ACT_RESERVE) OR

3847:
3848: END IF;
3849:
3850:
3851: IF (p_sch_action = OE_SCHEDULE_UTIL.OESCH_ACT_RESERVE) OR
3852: (p_sch_action = OE_SCHEDULE_UTIL.OESCH_ACT_UNRESERVE)
3853: THEN
3854:
3855: FND_MESSAGE.SET_NAME('ONT','OE_SCH_RES_NO_CONFIG');

Line 3852: (p_sch_action = OE_SCHEDULE_UTIL.OESCH_ACT_UNRESERVE)

3848: END IF;
3849:
3850:
3851: IF (p_sch_action = OE_SCHEDULE_UTIL.OESCH_ACT_RESERVE) OR
3852: (p_sch_action = OE_SCHEDULE_UTIL.OESCH_ACT_UNRESERVE)
3853: THEN
3854:
3855: FND_MESSAGE.SET_NAME('ONT','OE_SCH_RES_NO_CONFIG');
3856: OE_MSG_PUB.Add;