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 469: IF p_caller = OE_SCHEDULE_UTIL.SCH_EXTERNAL THEN

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

Line 791: IF p_request_rec.param1 = Oe_Schedule_Util.OESCH_ACT_SCHEDULE

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

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

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

Line 939: IF p_request_rec.param1 = Oe_Schedule_Util.OESCH_ACT_SCHEDULE

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

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

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

Line 1136: l_sales_order_id := OE_SCHEDULE_UTIL.Get_mtl_sales_order_id

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

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

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

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

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

Line 1341: OE_SCHEDULE_UTIL.OESCH_ACT_RESCHEDULE THEN

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

Line 1424: IF p_sch_action = OE_SCHEDULE_UTIL.OESCH_ACT_UNSCHEDULE OR

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

Line 1425: p_sch_action = OE_SCHEDULE_UTIL.OESCH_ACT_UNRESERVE

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

Line 1434: IF p_sch_action = OE_Schedule_Util.OESCH_ACT_UNSCHEDULE

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

Line 1453: IF p_sch_action = OE_Schedule_Util.OESCH_ACT_RESERVE THEN

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

Line 1454: l_sch_action := OE_Schedule_Util.OESCH_ACT_SCHEDULE;

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

Line 1459: IF p_sch_action = OE_Schedule_Util.OESCH_ACT_RESCHEDULE AND

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

Line 1488: IF p_sch_action = OE_Schedule_Util.OESCH_ACT_RESCHEDULE AND

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

Line 1506: IF p_sch_action <> OE_SCHEDULE_UTIL.OESCH_ACT_UNRESERVE THEN

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

Line 1512: ,p_caller => OE_SCHEDULE_UTIL.SCH_EXTERNAL

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

Line 1528: p_sch_action <> OE_Schedule_Util.OESCH_ACT_UNSCHEDULE AND

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

Line 1529: p_sch_action <> OE_Schedule_Util.OESCH_ACT_UNRESERVE

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

Line 1622: OE_Schedule_Util.Load_MRP_request_from_tbl

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

Line 1639: l_session_id := OE_SCHEDULE_UTIL.Get_Session_Id;

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

Line 1664: OE_SCHEDULE_UTIL.Display_sch_errors

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

Line 1679: OE_Schedule_Util.Load_Results_from_tbl

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

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

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

Line 1715: IF OE_SCHEDULE_UTIL.OE_inactive_demand_tbl.EXISTS

1711: FOR I in 1.. p_x_line_tbl.count LOOP
1712:
1713: l_line_id_mod := MOD(p_x_line_tbl(I).line_id,G_BINARY_LIMIT); --7827737
1714:
1715: IF OE_SCHEDULE_UTIL.OE_inactive_demand_tbl.EXISTS
1716: (l_line_id_mod) THEN --7827737
1717: --(p_x_line_tbl(I).line_id) THEN
1718: -- we know this line has an inactive demand scheduling level
1719:

Line 1724: OE_SCHEDULE_UTIL.Inactive_demand_scheduling

1720: IF l_debug_level > 0 THEN
1721: oe_debug_pub.add( 'CALLING INACTIVE_DEMAND_SCHEDULING FROM ELSE IN CALL_MRP' , 1 ) ;
1722: END IF;
1723:
1724: OE_SCHEDULE_UTIL.Inactive_demand_scheduling
1725: (p_x_old_line_rec => p_old_line_tbl(I)
1726: ,p_x_line_rec => p_x_line_tbl(I)
1727: ,x_return_status => x_return_status);
1728:

Line 1729: OE_SCHEDULE_UTIL.OE_inactive_demand_tbl.DELETE

1725: (p_x_old_line_rec => p_old_line_tbl(I)
1726: ,p_x_line_rec => p_x_line_tbl(I)
1727: ,x_return_status => x_return_status);
1728:
1729: OE_SCHEDULE_UTIL.OE_inactive_demand_tbl.DELETE
1730: (l_line_id_mod) ; --7827737
1731: --(p_x_line_tbl(I).line_id);
1732:
1733: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1807: IF ( (p_sch_action = OE_Schedule_Util.OESCH_ACT_UNRESERVE

1803: oe_debug_pub.add( P_LINE_TBL ( I ) .LINE_ID||'UNRESERVE ' ||P_LINE_TBL ( I ) .RESERVED_QUANTITY , 3 ) ;
1804: END IF;
1805: -- Start 2595661
1806: IF nvl(p_line_tbl(I).shipping_interfaced_flag,'N') = 'Y' THEN
1807: IF ( (p_sch_action = OE_Schedule_Util.OESCH_ACT_UNRESERVE
1808: OR p_sch_action = OE_Schedule_Util.OESCH_ACT_RESCHEDULE) -- 6628134
1809: AND NOT oe_schedule_util.Get_Pick_Status(p_line_tbl(I).line_id) ) THEN
1810:
1811: OE_SCHEDULE_UTIL.Do_Unreserve

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

1804: END IF;
1805: -- Start 2595661
1806: IF nvl(p_line_tbl(I).shipping_interfaced_flag,'N') = 'Y' THEN
1807: IF ( (p_sch_action = OE_Schedule_Util.OESCH_ACT_UNRESERVE
1808: OR p_sch_action = OE_Schedule_Util.OESCH_ACT_RESCHEDULE) -- 6628134
1809: AND NOT oe_schedule_util.Get_Pick_Status(p_line_tbl(I).line_id) ) THEN
1810:
1811: OE_SCHEDULE_UTIL.Do_Unreserve
1812: ( p_line_rec => p_line_tbl(I)

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

1805: -- Start 2595661
1806: IF nvl(p_line_tbl(I).shipping_interfaced_flag,'N') = 'Y' THEN
1807: IF ( (p_sch_action = OE_Schedule_Util.OESCH_ACT_UNRESERVE
1808: OR p_sch_action = OE_Schedule_Util.OESCH_ACT_RESCHEDULE) -- 6628134
1809: AND NOT oe_schedule_util.Get_Pick_Status(p_line_tbl(I).line_id) ) THEN
1810:
1811: OE_SCHEDULE_UTIL.Do_Unreserve
1812: ( p_line_rec => p_line_tbl(I)
1813: , p_quantity_to_unreserve => p_line_tbl(I).reserved_quantity

Line 1811: OE_SCHEDULE_UTIL.Do_Unreserve

1807: IF ( (p_sch_action = OE_Schedule_Util.OESCH_ACT_UNRESERVE
1808: OR p_sch_action = OE_Schedule_Util.OESCH_ACT_RESCHEDULE) -- 6628134
1809: AND NOT oe_schedule_util.Get_Pick_Status(p_line_tbl(I).line_id) ) THEN
1810:
1811: OE_SCHEDULE_UTIL.Do_Unreserve
1812: ( p_line_rec => p_line_tbl(I)
1813: , p_quantity_to_unreserve => p_line_tbl(I).reserved_quantity
1814: , p_quantity2_to_unreserve => NVL(p_line_tbl(I).reserved_quantity2, 0) -- INVCONV
1815: , x_return_status => l_return_status);

Line 1820: OE_SCHEDULE_UTIL.Unreserve_Line

1816: END IF;
1817: ELSE
1818: -- End 2595661
1819:
1820: OE_SCHEDULE_UTIL.Unreserve_Line
1821: ( p_line_rec => p_line_tbl(I)
1822: ,p_quantity_to_unreserve => p_line_tbl(I).reserved_quantity
1823: ,p_quantity2_to_unreserve => nvl(p_line_tbl(I).reserved_quantity2, 0) -- INVCONV
1824: ,x_return_status => l_return_status);

Line 1833: IF p_sch_action = OE_Schedule_Util.OESCH_ACT_RESCHEDULE THEN

1829: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1830: RAISE FND_API.G_EXC_ERROR;
1831: END IF;
1832:
1833: IF p_sch_action = OE_Schedule_Util.OESCH_ACT_RESCHEDULE THEN
1834:
1835: -- IF NOT OE_Reservations_Tbl.EXISTS(p_line_tbl(I).line_id) OR
1836: -- OE_Reservations_Tbl(p_line_tbl(I).line_id).qty_to_reserve
1837: -- is NULL

Line 1979: OE_SCHEDULE_UTIL.OESCH_STATUS_SCHEDULED

1975: IF nvl(p_x_line_tbl(I).shippable_flag, 'N') = 'Y' AND
1976: p_x_line_tbl(I).ordered_quantity > 0 AND
1977: p_x_line_tbl(I).Item_type_code <> 'CONFIG' AND
1978: nvl(p_x_line_tbl(I).schedule_status_code, 'X') =
1979: OE_SCHEDULE_UTIL.OESCH_STATUS_SCHEDULED
1980: THEN
1981: IF l_debug_level > 0 THEN
1982: oe_debug_pub.add( 'WORKING ON LINE '|| P_X_LINE_TBL ( I ) .LINE_ID , 3 ) ;
1983: END IF;

Line 1985: l_sch_level := OE_SCHEDULE_UTIL.Get_Scheduling_Level

1981: IF l_debug_level > 0 THEN
1982: oe_debug_pub.add( 'WORKING ON LINE '|| P_X_LINE_TBL ( I ) .LINE_ID , 3 ) ;
1983: END IF;
1984:
1985: l_sch_level := OE_SCHEDULE_UTIL.Get_Scheduling_Level
1986: (p_x_line_tbl(I).header_id,
1987: p_x_line_tbl(I).line_type_id);
1988:
1989:

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

1986: (p_x_line_tbl(I).header_id,
1987: p_x_line_tbl(I).line_type_id);
1988:
1989:
1990: IF nvl(l_sch_level, OE_Schedule_Util.SCH_LEVEL_THREE) =
1991: OE_Schedule_Util.SCH_LEVEL_THREE
1992: OR l_sch_level = OE_Schedule_Util.SCH_LEVEL_FOUR
1993: THEN
1994: IF l_debug_level > 0 THEN

Line 1991: OE_Schedule_Util.SCH_LEVEL_THREE

1987: p_x_line_tbl(I).line_type_id);
1988:
1989:
1990: IF nvl(l_sch_level, OE_Schedule_Util.SCH_LEVEL_THREE) =
1991: OE_Schedule_Util.SCH_LEVEL_THREE
1992: OR l_sch_level = OE_Schedule_Util.SCH_LEVEL_FOUR
1993: THEN
1994: IF l_debug_level > 0 THEN
1995: oe_debug_pub.add( 'SCH LEVEL ALLOWS FOR RESERVATION' , 3 ) ;

Line 1992: OR l_sch_level = OE_Schedule_Util.SCH_LEVEL_FOUR

1988:
1989:
1990: IF nvl(l_sch_level, OE_Schedule_Util.SCH_LEVEL_THREE) =
1991: OE_Schedule_Util.SCH_LEVEL_THREE
1992: OR l_sch_level = OE_Schedule_Util.SCH_LEVEL_FOUR
1993: THEN
1994: IF l_debug_level > 0 THEN
1995: oe_debug_pub.add( 'SCH LEVEL ALLOWS FOR RESERVATION' , 3 ) ;
1996: END IF;

Line 2014: IF p_sch_action = OE_Schedule_Util.OESCH_ACT_RESERVE OR

2010: END IF;
2011:
2012: IF p_x_line_tbl(I).reserved_quantity = 0 THEN
2013:
2014: IF p_sch_action = OE_Schedule_Util.OESCH_ACT_RESERVE OR
2015: OE_SCHEDULE_UTIL.Within_Rsv_Time_Fence
2016: (p_x_line_tbl(I).schedule_ship_date, p_x_line_tbl(I).org_id) THEN --4689197
2017:
2018: IF l_debug_level > 0 THEN

Line 2015: OE_SCHEDULE_UTIL.Within_Rsv_Time_Fence

2011:
2012: IF p_x_line_tbl(I).reserved_quantity = 0 THEN
2013:
2014: IF p_sch_action = OE_Schedule_Util.OESCH_ACT_RESERVE OR
2015: OE_SCHEDULE_UTIL.Within_Rsv_Time_Fence
2016: (p_x_line_tbl(I).schedule_ship_date, p_x_line_tbl(I).org_id) THEN --4689197
2017:
2018: IF l_debug_level > 0 THEN
2019: oe_debug_pub.add( 'RESERVE '||P_X_LINE_TBL ( I ) .ORDERED_QUANTITY , 3 ) ;

Line 2031: 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

2027: --Post Pack J
2028: -- If partial reservation falg is Yes and line have some reservation
2029: -- Reserve the remaining quantity.
2030: --ELSIF Oe_Sys_Parameters.Value('PARTIAL_RESERVATION_FLAG') = 'Y'
2031: 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
2032: IF nvl(p_x_line_tbl(I).ordered_quantity,0) > nvl(p_x_line_tbl(I).reserved_quantity,0) THEN -- INVCONV
2033: l_reservation_qty := nvl(p_x_line_tbl(I).ordered_quantity,0) - nvl(p_x_line_tbl(I).reserved_quantity,0);
2034: END IF;
2035: IF nvl(p_x_line_tbl(I).ordered_quantity2,0) > nvl(p_x_line_tbl(I).reserved_quantity2,0) THEN -- INVCONV

Line 2065: 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

2061: --AND Oe_Sys_Parameters.Value('PARTIAL_RESERVATION_FLAG') = 'Y'
2062: ELSIF ( ( l_reservation_qty > 0 AND Nvl(P_X_LINE_TBL ( I ).fulfillment_base ,'P') ='P')
2063: OR (l_reservation_qty2 > 0 AND Nvl(P_X_LINE_TBL ( I ).fulfillment_base ,'P') ='S')
2064: )--bug 16782621
2065: 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
2066: l_reservation_qty := p_x_line_tbl(I).ordered_quantity;
2067: l_reservation_qty2 := p_x_line_tbl(I).ordered_quantity2; -- INVCONV
2068: END IF; -- reservation_aty = 0
2069:

Line 2084: OE_SCHEDULE_UTIL.Reserve_Line

2080: THEN
2081: p_x_line_tbl(I).reserved_quantity := l_reservation_qty;
2082: p_x_line_tbl(I).reserved_quantity2 := l_reservation_qty2; -- INVCONV
2083:
2084: OE_SCHEDULE_UTIL.Reserve_Line
2085: ( p_line_rec => p_x_line_tbl(I)
2086: ,p_quantity_to_Reserve => p_x_line_tbl(I).reserved_quantity
2087: ,p_quantity2_to_Reserve => p_x_line_tbl(I).reserved_quantity2 -- INVCONV
2088: ,p_rsv_update => l_rsv_update

Line 2255: OE_SCHEDULE_UTIL.Unreserve_Line

2251: AND NOT OE_GLOBALS.Equal(p_x_line_tbl(I).inventory_item_id,
2252: p_old_line_tbl(I).inventory_item_id)
2253: AND p_old_line_tbl(I).reserved_quantity > 0 THEN
2254:
2255: OE_SCHEDULE_UTIL.Unreserve_Line
2256: (p_line_rec => p_old_line_tbl(I),
2257: p_quantity_to_unreserve => p_old_line_tbl(I).reserved_quantity,
2258: p_quantity2_to_unreserve => p_old_line_tbl(I).reserved_quantity2, -- INVCONV
2259: x_return_status => x_return_status);

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

2275: oe_debug_pub.add( 'UNRESERVING...' , 3 ) ;
2276: END IF;
2277: Unreserve_group
2278: ( p_line_tbl => p_old_line_tbl
2279: ,p_sch_action => OE_Schedule_Util.OESCH_ACT_RESCHEDULE);
2280:
2281: RETURN;
2282: END IF;
2283:

Line 2340: OE_SCHEDULE_UTIL.Unreserve_Line

2336: -- IF l_qty > 0 THEN -- bug 16782621
2337: IF ( l_qty > 0 AND Nvl(P_X_LINE_TBL ( I ).fulfillment_base ,'P') ='P')
2338: OR( l_qty2 >0 AND Nvl(P_X_LINE_TBL ( I ).fulfillment_base ,'P') ='S')
2339: THEN -- bug 16782621
2340: OE_SCHEDULE_UTIL.Unreserve_Line
2341: ( p_line_rec => p_x_line_tbl(I)
2342: ,p_old_ship_from_org_id => p_old_line_tbl(I).ship_from_org_id --6628134
2343: ,p_quantity_to_unreserve => l_qty
2344: ,p_quantity2_to_unreserve => l_qty2 -- INVCONV

Line 2386: OE_Schedule_Util.Validate_Line

2382: oe_debug_pub.add( '--------ENTERING VALIDATE_AND_ASSIGN' , 1 ) ;
2383: END IF;
2384:
2385: /* 3533565 Validation will be done after cascading
2386: OE_Schedule_Util.Validate_Line
2387: ( p_line_rec => p_x_line_rec
2388: ,p_old_line_rec => p_x_old_line_rec
2389: ,p_sch_action => p_request_rec.param1
2390: ,x_return_status => l_return_status);

Line 2434: OE_Schedule_Util.Validate_Line

2430: p_x_line_rec.schedule_ship_date := p_request_rec.date_param2;
2431: p_x_line_rec.schedule_arrival_date := p_request_rec.date_param3;
2432:
2433: -- 3533565
2434: OE_Schedule_Util.Validate_Line
2435: ( p_line_rec => p_x_line_rec
2436: ,p_old_line_rec => p_x_old_line_rec
2437: ,p_sch_action => p_request_rec.param1
2438: ,x_return_status => l_return_status);

Line 2457: IF p_request_rec.param1 = OE_SCHEDULE_UTIL.OESCH_ACT_RESCHEDULE

2453: p_x_line_rec.ship_set := p_request_rec.entity_id;
2454: END IF;
2455:
2456: -- 4052648: Assign old values for ato model for unschedule action
2457: IF p_request_rec.param1 = OE_SCHEDULE_UTIL.OESCH_ACT_RESCHEDULE
2458: OR (p_request_rec.param1 = OE_SCHEDULE_UTIL.OESCH_ACT_UNSCHEDULE
2459: AND p_x_line_rec.ato_line_id IS NOT NULL)
2460: -- bug 2427280 AND p_x_old_line_rec.schedule_status_code is NOT NULL
2461: THEN

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

2454: END IF;
2455:
2456: -- 4052648: Assign old values for ato model for unschedule action
2457: IF p_request_rec.param1 = OE_SCHEDULE_UTIL.OESCH_ACT_RESCHEDULE
2458: OR (p_request_rec.param1 = OE_SCHEDULE_UTIL.OESCH_ACT_UNSCHEDULE
2459: AND p_x_line_rec.ato_line_id IS NOT NULL)
2460: -- bug 2427280 AND p_x_old_line_rec.schedule_status_code is NOT NULL
2461: THEN
2462: IF l_debug_level > 0 THEN

Line 2652: IF p_sch_action <> OE_SCHEDULE_UTIL.OESCH_ACT_UNSCHEDULE THEN

2648:
2649: /*Uncommented the sql for Bug 3144917 */
2650:
2651: -- 4052648 : Do not query for action - UNSCHEDULE
2652: IF p_sch_action <> OE_SCHEDULE_UTIL.OESCH_ACT_UNSCHEDULE THEN
2653:
2654: SELECT request_date, schedule_ship_date,
2655: schedule_arrival_date,
2656: ship_from_org_id, ship_to_org_id,

Line 2739: IF p_sch_action = OE_Schedule_Util.OESCH_ACT_RESCHEDULE THEN

2735: oe_debug_pub.add(P_X_LINE_TBL( I ).Firm_Demand_Flag , 3 ) ;
2736: END IF;
2737:
2738:
2739: IF p_sch_action = OE_Schedule_Util.OESCH_ACT_RESCHEDULE THEN
2740: IF NOT OE_GLOBALS.Equal(p_x_line_tbl(I).request_date,
2741: p_old_line_tbl(I).request_date) OR
2742:
2743: NOT OE_GLOBALS.Equal(p_x_line_tbl(I).schedule_ship_date,

Line 2851: IF p_sch_action = OE_Schedule_Util.OESCH_ACT_RESCHEDULE THEN

2847: l_call_po := 'Y';
2848: END IF;
2849:
2850:
2851: IF p_sch_action = OE_Schedule_Util.OESCH_ACT_RESCHEDULE THEN
2852:
2853: IF l_debug_level > 0 THEN
2854: oe_debug_pub.add( 'MAY UPDATE RESERN '|| P_X_LINE_TBL ( I ) .LINE_ID , 3 ) ;
2855: END IF;

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

2883: -- a new delayed request of type OE_Globals.G_UPDATE_REQUISITION, which
2884: -- is added as part of this project
2885: --
2886: /*
2887: OE_SCHEDULE_UTIL.Update_PO(p_x_line_tbl(I).schedule_arrival_date,
2888: p_x_line_tbl(I).source_document_id,
2889: p_x_line_tbl(I).source_document_line_id);
2890: */
2891: --

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

3008: IF l_debug_level > 0 THEN
3009: oe_debug_pub.add(' Need By Date is not allowed to update. Updating MTL_Supply only',5);
3010: END IF;
3011:
3012: OE_SCHEDULE_UTIL.Update_PO(p_x_line_tbl(I).schedule_arrival_date,
3013: p_x_line_tbl(I).source_document_id,
3014: p_x_line_tbl(I).source_document_line_id);
3015: END IF;
3016:

Line 3059: OE_Schedule_Util.Call_Process_Order

3055:
3056: l_control_rec.clear_api_cache := FALSE;
3057: l_control_rec.clear_api_requests := FALSE;
3058:
3059: OE_Schedule_Util.Call_Process_Order
3060: ( p_x_old_line_tbl => p_old_line_tbl
3061: ,p_x_line_tbl => p_x_line_tbl
3062: ,p_control_rec => l_control_rec
3063: ,p_caller => p_caller

Line 3072: IF p_caller = OE_Schedule_Util.SCH_INTERNAL THEN

3068: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
3069: RAISE FND_API.G_EXC_ERROR;
3070: END IF;
3071:
3072: IF p_caller = OE_Schedule_Util.SCH_INTERNAL THEN
3073: l_process_requests := FALSE;
3074: ELSE
3075: l_process_requests := TRUE;
3076: END IF;

Line 3280: IF NOT OE_SCHEDULE_UTIL.validate_ship_method

3276: IF l_debug_level > 0 THEN
3277: oe_debug_pub.add( 'BEFORE DOING DIRECT UPDATE' , 1 ) ;
3278: END IF;
3279:
3280: IF NOT OE_SCHEDULE_UTIL.validate_ship_method
3281: (p_x_line_rec.shipping_method_code,
3282: p_old_line_rec.shipping_method_code,
3283: p_x_line_rec.ship_from_org_id) THEN
3284:

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

3338: p_line_id => p_x_line_rec.line_id,
3339: x_index => l_index,
3340: x_return_status => l_return_status);
3341: IF l_debug_level > 0 THEN
3342: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FROM OE_SCHEDULE_UTIL.PROCESS_LINE IS: ' || L_RETURN_STATUS ) ;
3343: oe_debug_pub.add( 'GLOBAL PICTURE INDEX IS: ' || L_INDEX , 1 ) ;
3344: END IF;
3345:
3346: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 3436: l_sales_order_id := OE_SCHEDULE_UTIL.Get_mtl_sales_order_id

3432: END IF;
3433:
3434: l_rsv_rec.reservation_id := fnd_api.g_miss_num;
3435:
3436: l_sales_order_id := OE_SCHEDULE_UTIL.Get_mtl_sales_order_id
3437: (p_line_rec.header_id);
3438:
3439: l_rsv_rec.demand_source_header_id := l_sales_order_id;
3440: l_rsv_rec.demand_source_line_id := p_line_rec.line_id;

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

3613: RAISE FND_API.G_EXC_ERROR;
3614: END IF;
3615:
3616:
3617: IF nvl(p_sch_action, 'A' ) <> OE_Schedule_Util.OESCH_ACT_UNSCHEDULE
3618: AND
3619: nvl(p_sch_action, 'A' ) <> OE_Schedule_Util.OESCH_ACT_UNRESERVE
3620: THEN
3621:

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

3615:
3616:
3617: IF nvl(p_sch_action, 'A' ) <> OE_Schedule_Util.OESCH_ACT_UNSCHEDULE
3618: AND
3619: nvl(p_sch_action, 'A' ) <> OE_Schedule_Util.OESCH_ACT_UNRESERVE
3620: THEN
3621:
3622: l_sch_gloabl_value := OE_SCHEDULE_UTIL.OESCH_PERFORM_SCHEDULING;
3623: OE_SCHEDULE_UTIL.OESCH_PERFORM_SCHEDULING := 'N';

Line 3622: l_sch_gloabl_value := OE_SCHEDULE_UTIL.OESCH_PERFORM_SCHEDULING;

3618: AND
3619: nvl(p_sch_action, 'A' ) <> OE_Schedule_Util.OESCH_ACT_UNRESERVE
3620: THEN
3621:
3622: l_sch_gloabl_value := OE_SCHEDULE_UTIL.OESCH_PERFORM_SCHEDULING;
3623: OE_SCHEDULE_UTIL.OESCH_PERFORM_SCHEDULING := 'N';
3624: OE_ORDER_SCH_UTIL.OESCH_PERFORM_SCHEDULING := 'N';
3625:
3626: IF l_debug_level > 0 THEN

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

3619: nvl(p_sch_action, 'A' ) <> OE_Schedule_Util.OESCH_ACT_UNRESERVE
3620: THEN
3621:
3622: l_sch_gloabl_value := OE_SCHEDULE_UTIL.OESCH_PERFORM_SCHEDULING;
3623: OE_SCHEDULE_UTIL.OESCH_PERFORM_SCHEDULING := 'N';
3624: OE_ORDER_SCH_UTIL.OESCH_PERFORM_SCHEDULING := 'N';
3625:
3626: IF l_debug_level > 0 THEN
3627: oe_debug_pub.add( 'CHECK IF II ITEMS REQ.' , 3 ) ;

Line 3647: OE_SCHEDULE_UTIL.OESCH_PERFORM_SCHEDULING := l_sch_gloabl_value;

3643: RAISE FND_API.G_EXC_ERROR;
3644: END IF;
3645: END LOOP;
3646:
3647: OE_SCHEDULE_UTIL.OESCH_PERFORM_SCHEDULING := l_sch_gloabl_value;
3648: OE_ORDER_SCH_UTIL.OESCH_PERFORM_SCHEDULING := 'Y';
3649: END IF;
3650:
3651:

Line 3698: l_sales_order_id := OE_SCHEDULE_UTIL.Get_mtl_sales_order_id

3694: IF x_line_tbl.count > 0 THEN
3695: IF l_debug_level > 0 THEN
3696: oe_debug_pub.add( 'NO. OF LINES '|| X_LINE_TBL.COUNT , 3 ) ;
3697: END IF;
3698: l_sales_order_id := OE_SCHEDULE_UTIL.Get_mtl_sales_order_id
3699: (p_header_id);
3700: END IF;
3701:
3702: I := x_line_tbl.FIRST;

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

3787:
3788: EXCEPTION
3789:
3790: WHEN FND_API.G_EXC_ERROR THEN
3791: OE_SCHEDULE_UTIL.OESCH_PERFORM_SCHEDULING := 'Y';
3792: OE_ORDER_SCH_UTIL.OESCH_PERFORM_SCHEDULING := 'Y';
3793: IF l_debug_level > 0 THEN
3794: oe_debug_pub.add( 'EXC ERROR IN Query_Set_Lines' , 1 ) ;
3795: END IF;

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

3796: x_return_status := FND_API.G_RET_STS_ERROR;
3797:
3798: WHEN OTHERS THEN
3799:
3800: OE_SCHEDULE_UTIL.OESCH_PERFORM_SCHEDULING := 'Y';
3801: OE_ORDER_SCH_UTIL.OESCH_PERFORM_SCHEDULING := 'Y';
3802:
3803: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3804: THEN

Line 3960: p_sch_action = OE_SCHEDULE_UTIL.OESCH_ACT_SCHEDULE

3956: FROM oe_order_lines
3957: WHERE line_id = p_line_rec.ato_line_id;
3958:
3959: IF l_num_id is NULL AND
3960: p_sch_action = OE_SCHEDULE_UTIL.OESCH_ACT_SCHEDULE
3961: THEN
3962:
3963: FND_MESSAGE.SET_NAME('ONT','OE_SCH_ATO_WHSE_REQD');
3964: OE_MSG_PUB.Add;

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

3968:
3969: END IF;
3970:
3971:
3972: IF (p_sch_action = OE_SCHEDULE_UTIL.OESCH_ACT_RESERVE) OR
3973: (p_sch_action = OE_SCHEDULE_UTIL.OESCH_ACT_UNRESERVE)
3974: THEN
3975:
3976: FND_MESSAGE.SET_NAME('ONT','OE_SCH_RES_NO_CONFIG');

Line 3973: (p_sch_action = OE_SCHEDULE_UTIL.OESCH_ACT_UNRESERVE)

3969: END IF;
3970:
3971:
3972: IF (p_sch_action = OE_SCHEDULE_UTIL.OESCH_ACT_RESERVE) OR
3973: (p_sch_action = OE_SCHEDULE_UTIL.OESCH_ACT_UNRESERVE)
3974: THEN
3975:
3976: FND_MESSAGE.SET_NAME('ONT','OE_SCH_RES_NO_CONFIG');
3977: OE_MSG_PUB.Add;