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

Line 170: OE_SCHEDULE_UTIL.OESCH_ITEM_IS_SUBSTITUTED := 'N'; -- Added for ER 6110708

166: x_return_status := FND_API.G_RET_STS_SUCCESS;
167:
168: -- This variable is to track that the Item is being Substituted by Planning Loop Back and not being changed manully by user.
169: -- Initializing to 'N' for current set of Lines. Will set it to Y if any item substitutions are happening.
170: OE_SCHEDULE_UTIL.OESCH_ITEM_IS_SUBSTITUTED := 'N'; -- Added for ER 6110708
171:
172: -- Bug #7667702: Tracking bug for IR ISO CMS Project
173: -- Since, in this code, caller can only be Planning (Planning Workbench
174: -- or DRP), setting the global with default value FALSE

Line 344: l_sales_order_id := OE_SCHEDULE_UTIL.Get_mtl_sales_order_id(l_line_rec.HEADER_ID);

340: END IF;
341:
342: l_opm_enabled := INV_GMI_RSV_BRANCH.Process_Branch(p_organization_id => l_line_rec.ship_from_org_id);
343:
344: l_sales_order_id := OE_SCHEDULE_UTIL.Get_mtl_sales_order_id(l_line_rec.HEADER_ID);
345: l_line_rec.reserved_quantity := OE_LINE_UTIL.Get_Reserved_Quantity
346: ( p_header_id => l_sales_order_id,
347: p_line_id => l_line_rec.line_id,
348: p_org_id => l_line_rec.ship_from_org_id

Line 428: l_sales_order_id := OE_SCHEDULE_UTIL.Get_mtl_sales_order_id

424: FOR J IN 1..l_local_line_tbl.COUNT LOOP
425:
426: IF l_local_line_tbl(J).shippable_flag = 'Y' THEN
427:
428: l_sales_order_id := OE_SCHEDULE_UTIL.Get_mtl_sales_order_id
429: (l_local_line_tbl(J).HEADER_ID);
430: l_local_line_tbl(J).reserved_quantity :=
431: OE_LINE_UTIL.Get_Reserved_Quantity
432: (p_header_id => l_sales_order_id,

Line 521: l_sales_order_id := OE_SCHEDULE_UTIL.Get_mtl_sales_order_id

517: ELSE
518:
519: IF nvl(l_line_rec.shippable_flag,'N') = 'Y' THEN
520:
521: l_sales_order_id := OE_SCHEDULE_UTIL.Get_mtl_sales_order_id
522: (l_line_rec.HEADER_ID);
523: l_line_rec.reserved_quantity :=
524: OE_LINE_UTIL.Get_Reserved_Quantity
525: (p_header_id => l_sales_order_id,

Line 550: OE_SCHEDULE_UTIL.OESCH_ITEM_IS_SUBSTITUTED := 'Y';

546: l_line_rec.item_identifier_type := 'INT';
547: l_item_substituted := TRUE;
548:
549: -- This variable is to track that the Item is being Substituted by Planning Loop Back and not being changed manully by user.
550: OE_SCHEDULE_UTIL.OESCH_ITEM_IS_SUBSTITUTED := 'Y';
551:
552: END IF;
553: /* End of ER 6110708 */
554:

Line 650: OE_SCHEDULE_UTIL.Promise_Date_for_Sch_Action

646:
647:
648: IF g_line_tbl(J).schedule_status_code is not null THEN
649:
650: OE_SCHEDULE_UTIL.Promise_Date_for_Sch_Action
651: ( p_x_line_rec => g_line_tbl(J)
652: ,p_sch_action => OE_SCHEDULE_UTIL.OESCH_ACT_RESCHEDULE
653: ,p_header_id => g_line_tbl(J).header_id);
654:

Line 652: ,p_sch_action => OE_SCHEDULE_UTIL.OESCH_ACT_RESCHEDULE

648: IF g_line_tbl(J).schedule_status_code is not null THEN
649:
650: OE_SCHEDULE_UTIL.Promise_Date_for_Sch_Action
651: ( p_x_line_rec => g_line_tbl(J)
652: ,p_sch_action => OE_SCHEDULE_UTIL.OESCH_ACT_RESCHEDULE
653: ,p_header_id => g_line_tbl(J).header_id);
654:
655:
656: ELSE

Line 658: g_line_tbl(J).schedule_status_code := OE_SCHEDULE_UTIL.OESCH_STATUS_SCHEDULED;

654:
655:
656: ELSE
657:
658: g_line_tbl(J).schedule_status_code := OE_SCHEDULE_UTIL.OESCH_STATUS_SCHEDULED;
659: g_line_tbl(J).visible_demand_flag := 'Y';
660:
661: OE_SCHEDULE_UTIL.Promise_Date_for_Sch_Action
662: ( p_x_line_rec => g_line_tbl(J)

Line 661: OE_SCHEDULE_UTIL.Promise_Date_for_Sch_Action

657:
658: g_line_tbl(J).schedule_status_code := OE_SCHEDULE_UTIL.OESCH_STATUS_SCHEDULED;
659: g_line_tbl(J).visible_demand_flag := 'Y';
660:
661: OE_SCHEDULE_UTIL.Promise_Date_for_Sch_Action
662: ( p_x_line_rec => g_line_tbl(J)
663: ,p_sch_action => OE_SCHEDULE_UTIL.OESCH_ACT_SCHEDULE
664: ,p_header_id => g_line_tbl(J).header_id);
665:

Line 663: ,p_sch_action => OE_SCHEDULE_UTIL.OESCH_ACT_SCHEDULE

659: g_line_tbl(J).visible_demand_flag := 'Y';
660:
661: OE_SCHEDULE_UTIL.Promise_Date_for_Sch_Action
662: ( p_x_line_rec => g_line_tbl(J)
663: ,p_sch_action => OE_SCHEDULE_UTIL.OESCH_ACT_SCHEDULE
664: ,p_header_id => g_line_tbl(J).header_id);
665:
666: -- Firm Demand Flag.
667: IF nvl(g_line_tbl(J).firm_demand_flag,'N') = 'N'

Line 743: OE_Schedule_Util.Call_Process_Order

739: oe_debug_pub.add('Ol OP ' || g_old_line_tbl(J).line_id ,2);
740:
741: END LOOP;
742:
743: OE_Schedule_Util.Call_Process_Order
744: ( p_x_old_line_tbl => g_old_line_tbl
745: ,p_x_line_tbl => g_line_tbl
746: ,p_control_rec => l_control_rec
747: ,p_caller => OE_SCHEDULE_UTIL.SCH_EXTERNAL

Line 747: ,p_caller => OE_SCHEDULE_UTIL.SCH_EXTERNAL

743: OE_Schedule_Util.Call_Process_Order
744: ( p_x_old_line_tbl => g_old_line_tbl
745: ,p_x_line_tbl => g_line_tbl
746: ,p_control_rec => l_control_rec
747: ,p_caller => OE_SCHEDULE_UTIL.SCH_EXTERNAL
748: ,x_return_status => x_return_status);
749: /* Commented for 4606248
750: OE_Order_PVT.Process_Requests_And_Notify
751: ( p_process_requests => TRUE

Line 764: ,p_sch_action => OE_SCHEDULE_UTIL.OESCH_ACT_SCHEDULE

760: BEGIN
761: OE_Config_Schedule_Pvt.Save_Sch_Attributes
762: ( p_x_line_tbl => g_line_tbl
763: ,p_old_line_tbl => g_old_line_tbl
764: ,p_sch_action => OE_SCHEDULE_UTIL.OESCH_ACT_SCHEDULE
765: ,p_caller => OE_SCHEDULE_UTIL.SCH_EXTERNAL
766: ,x_return_status => x_return_status);
767:
768: EXCEPTION

Line 765: ,p_caller => OE_SCHEDULE_UTIL.SCH_EXTERNAL

761: OE_Config_Schedule_Pvt.Save_Sch_Attributes
762: ( p_x_line_tbl => g_line_tbl
763: ,p_old_line_tbl => g_old_line_tbl
764: ,p_sch_action => OE_SCHEDULE_UTIL.OESCH_ACT_SCHEDULE
765: ,p_caller => OE_SCHEDULE_UTIL.SCH_EXTERNAL
766: ,x_return_status => x_return_status);
767:
768: EXCEPTION
769: WHEN OTHERS THEN

Line 785: OE_SCHEDULE_UTIL.OESCH_ITEM_IS_SUBSTITUTED := 'N'; -- Added for ER 6110708

781: ,p_old_line_tbl => g_old_line_tbl
782: ,x_return_status => x_return_status);
783:
784: -- Resetting the variable after the Process Order API Call.
785: OE_SCHEDULE_UTIL.OESCH_ITEM_IS_SUBSTITUTED := 'N'; -- Added for ER 6110708
786:
787: -- ELSE -- Updated for bug 7679398/7675256
788: END IF;
789: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 1067: l_scheduling_level_code := OE_SCHEDULE_UTIL.Get_Scheduling_Level

1063: OE_MSG_PUB.ADD;
1064: x_return_status := FND_API.G_RET_STS_ERROR;
1065: END IF;
1066:
1067: l_scheduling_level_code := OE_SCHEDULE_UTIL.Get_Scheduling_Level
1068: (g_line_tbl(I).header_id,
1069: g_line_tbl(I).line_type_id);
1070:
1071: IF l_scheduling_level_code = OE_SCHEDULE_UTIL.SCH_LEVEL_FOUR OR

Line 1071: IF l_scheduling_level_code = OE_SCHEDULE_UTIL.SCH_LEVEL_FOUR OR

1067: l_scheduling_level_code := OE_SCHEDULE_UTIL.Get_Scheduling_Level
1068: (g_line_tbl(I).header_id,
1069: g_line_tbl(I).line_type_id);
1070:
1071: IF l_scheduling_level_code = OE_SCHEDULE_UTIL.SCH_LEVEL_FOUR OR
1072: l_scheduling_level_code = OE_SCHEDULE_UTIL.SCH_LEVEL_FIVE OR
1073: l_scheduling_level_code = OE_SCHEDULE_UTIL.SCH_LEVEL_ONE THEN
1074:
1075: oe_debug_pub.add('E9',2);

Line 1072: l_scheduling_level_code = OE_SCHEDULE_UTIL.SCH_LEVEL_FIVE OR

1068: (g_line_tbl(I).header_id,
1069: g_line_tbl(I).line_type_id);
1070:
1071: IF l_scheduling_level_code = OE_SCHEDULE_UTIL.SCH_LEVEL_FOUR OR
1072: l_scheduling_level_code = OE_SCHEDULE_UTIL.SCH_LEVEL_FIVE OR
1073: l_scheduling_level_code = OE_SCHEDULE_UTIL.SCH_LEVEL_ONE THEN
1074:
1075: oe_debug_pub.add('E9',2);
1076: g_line_tbl(I).operation := OE_GLOBALS.G_OPR_NONE;

Line 1073: l_scheduling_level_code = OE_SCHEDULE_UTIL.SCH_LEVEL_ONE THEN

1069: g_line_tbl(I).line_type_id);
1070:
1071: IF l_scheduling_level_code = OE_SCHEDULE_UTIL.SCH_LEVEL_FOUR OR
1072: l_scheduling_level_code = OE_SCHEDULE_UTIL.SCH_LEVEL_FIVE OR
1073: l_scheduling_level_code = OE_SCHEDULE_UTIL.SCH_LEVEL_ONE THEN
1074:
1075: oe_debug_pub.add('E9',2);
1076: g_line_tbl(I).operation := OE_GLOBALS.G_OPR_NONE;
1077: FND_MESSAGE.SET_NAME('ONT', 'ONT_SCH_LOOP_LVL');

Line 1411: OE_SCHEDULE_UTIL.Unreserve_Line

1407: AND nvl(g_line_tbl(p_index).booked_flag, 'N') = 'N'
1408: ) -- OR clause added for ER 6110708
1409: THEN
1410:
1411: OE_SCHEDULE_UTIL.Unreserve_Line
1412: (p_line_rec => g_old_line_tbl(p_index),
1413: p_quantity_to_unreserve => g_old_line_tbl(p_index).reserved_quantity,
1414: x_return_status => x_return_status);
1415:

Line 1416: OE_SCHEDULE_UTIL.Reserve_Line

1412: (p_line_rec => g_old_line_tbl(p_index),
1413: p_quantity_to_unreserve => g_old_line_tbl(p_index).reserved_quantity,
1414: x_return_status => x_return_status);
1415:
1416: OE_SCHEDULE_UTIL.Reserve_Line
1417: (p_line_rec => g_line_tbl(p_index)
1418: ,p_quantity_to_reserve => g_line_tbl(p_index).reserved_quantity
1419: ,x_return_Status => x_return_status);
1420: