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

Line 1: PACKAGE BODY OE_SCHEDULE_UTIL AS

1: PACKAGE BODY OE_SCHEDULE_UTIL AS
2: /* $Header: OEXUSCHB.pls 120.54.12010000.8 2009/02/05 06:07:08 vbkapoor ship $ */
3:
4:
5: /*-----------------------------------------------------------

Line 8: G_PKG_NAME CONSTANT VARCHAR2(30):='OE_SCHEDULE_UTIL';

4:
5: /*-----------------------------------------------------------
6: CONSTANTS and Forward declarations
7: ------------------------------------------------------------*/
8: G_PKG_NAME CONSTANT VARCHAR2(30):='OE_SCHEDULE_UTIL';
9: G_OVERRIDE_FLAG VARCHAR2(1) := 'N';
10: G_ATP_CHECK_SESSION_ID NUMBER;
11:
12: /*-- 3288805 -- */ -- moved to spec.

Line 193: , 'oe_schedule_util.validate_ship_method'

189: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
190: THEN
191: OE_MSG_PUB.Add_Exc_Msg
192: ( G_PKG_NAME
193: , 'oe_schedule_util.validate_ship_method'
194: );
195: END IF;
196: RETURN FALSE;
197:

Line 660: oe_debug_pub.add( 'ENTERING OE_SCHEDULE_UTIL.UPDATE_PO' , 2 ) ;

656: --
657: BEGIN
658:
659: IF l_debug_level > 0 THEN
660: oe_debug_pub.add( 'ENTERING OE_SCHEDULE_UTIL.UPDATE_PO' , 2 ) ;
661: END IF;
662:
663: -- Call po if internal req and quantity is changed
664:

Line 682: oe_debug_pub.add( 'EXITING OE_SCHEDULE_UTIL.UPDATE_PO' , 1 ) ;

678: p_receipt_date => p_schedule_ship_date);
679: END IF;
680:
681: IF l_debug_level > 0 THEN
682: oe_debug_pub.add( 'EXITING OE_SCHEDULE_UTIL.UPDATE_PO' , 1 ) ;
683: END IF;
684:
685: EXCEPTION
686: WHEN OTHERS THEN

Line 942: IF OE_SCHEDULE_UTIL.OESCH_ITEM_IS_SUBSTITUTED = 'Y' THEN

938: END IF;
939: l_quantity2_reserved :=NULL;
940:
941: /* Added the below code for ER 6110708 */
942: IF OE_SCHEDULE_UTIL.OESCH_ITEM_IS_SUBSTITUTED = 'Y' THEN
943: l_substitute_flag := TRUE;
944: ELSE
945: l_substitute_flag := FALSE;
946: END IF;

Line 2382: OE_SCHEDULE_UTIL.Update_PO(p_x_line_rec.schedule_arrival_date,

2378: IF l_debug_level > 0 THEN
2379: oe_debug_pub.add(' Need By Date is not allowed to update. Updating MTL_Supply only',5);
2380: END IF;
2381:
2382: OE_SCHEDULE_UTIL.Update_PO(p_x_line_rec.schedule_arrival_date,
2383: p_x_line_rec.source_document_id,
2384: p_x_line_rec.source_document_line_id);
2385: END IF;
2386: END IF;

Line 2559: oe_debug_pub.add( 'ENTERING OE_SCHEDULE_UTIL.LOAD_MRP_REQUEST' , 1 ) ;

2555: --
2556: Begin
2557:
2558: IF l_debug_level > 0 THEN
2559: oe_debug_pub.add( 'ENTERING OE_SCHEDULE_UTIL.LOAD_MRP_REQUEST' , 1 ) ;
2560: END IF;
2561: IF l_debug_level > 0 THEN
2562: oe_debug_pub.add('------------Load MRP Table-----------',1);
2563: END IF;

Line 2971: IF (l_action_code = OE_SCHEDULE_UTIL.OESCH_ACT_ATP_CHECK) THEN

2967: IF l_debug_level > 0 THEN
2968: oe_debug_pub.add( 'REQUEST ARRIVAL DATE : ' || TO_CHAR ( X_ATP_REC.REQUESTED_ARRIVAL_DATE ( I ) , 'DD-MON-RR:HH:MM:SS' ) , 3 ) ;
2969: END IF;
2970:
2971: IF (l_action_code = OE_SCHEDULE_UTIL.OESCH_ACT_ATP_CHECK) THEN
2972: x_atp_rec.Action(I) := 100;
2973: IF l_debug_level > 0 THEN
2974: oe_debug_pub.add( 'MRP ACTION: ' || X_ATP_REC.ACTION ( I ) , 3 ) ;
2975: END IF;

Line 2976: ELSIF (l_action_code = OE_SCHEDULE_UTIL.OESCH_ACT_DEMAND) OR

2972: x_atp_rec.Action(I) := 100;
2973: IF l_debug_level > 0 THEN
2974: oe_debug_pub.add( 'MRP ACTION: ' || X_ATP_REC.ACTION ( I ) , 3 ) ;
2975: END IF;
2976: ELSIF (l_action_code = OE_SCHEDULE_UTIL.OESCH_ACT_DEMAND) OR
2977: (l_action_code = OE_SCHEDULE_UTIL.OESCH_ACT_SCHEDULE)
2978: THEN
2979: x_atp_rec.Action(I) := 110;
2980: IF l_debug_level > 0 THEN

Line 2977: (l_action_code = OE_SCHEDULE_UTIL.OESCH_ACT_SCHEDULE)

2973: IF l_debug_level > 0 THEN
2974: oe_debug_pub.add( 'MRP ACTION: ' || X_ATP_REC.ACTION ( I ) , 3 ) ;
2975: END IF;
2976: ELSIF (l_action_code = OE_SCHEDULE_UTIL.OESCH_ACT_DEMAND) OR
2977: (l_action_code = OE_SCHEDULE_UTIL.OESCH_ACT_SCHEDULE)
2978: THEN
2979: x_atp_rec.Action(I) := 110;
2980: IF l_debug_level > 0 THEN
2981: oe_debug_pub.add( 'MRP ACTION: ' || X_ATP_REC.ACTION ( I ) , 3 ) ;

Line 2983: ELSIF (l_action_code = OE_SCHEDULE_UTIL.OESCH_ACT_REDEMAND) OR

2979: x_atp_rec.Action(I) := 110;
2980: IF l_debug_level > 0 THEN
2981: oe_debug_pub.add( 'MRP ACTION: ' || X_ATP_REC.ACTION ( I ) , 3 ) ;
2982: END IF;
2983: ELSIF (l_action_code = OE_SCHEDULE_UTIL.OESCH_ACT_REDEMAND) OR
2984: (l_action_code = OE_SCHEDULE_UTIL.OESCH_ACT_RESCHEDULE)
2985: THEN
2986: x_atp_rec.Action(I) := 120;
2987: x_atp_rec.Old_Source_Organization_Id(I) :=

Line 2984: (l_action_code = OE_SCHEDULE_UTIL.OESCH_ACT_RESCHEDULE)

2980: IF l_debug_level > 0 THEN
2981: oe_debug_pub.add( 'MRP ACTION: ' || X_ATP_REC.ACTION ( I ) , 3 ) ;
2982: END IF;
2983: ELSIF (l_action_code = OE_SCHEDULE_UTIL.OESCH_ACT_REDEMAND) OR
2984: (l_action_code = OE_SCHEDULE_UTIL.OESCH_ACT_RESCHEDULE)
2985: THEN
2986: x_atp_rec.Action(I) := 120;
2987: x_atp_rec.Old_Source_Organization_Id(I) :=
2988: p_old_line_rec.ship_from_org_id;

Line 2994: ELSIF (l_action_code = OE_SCHEDULE_UTIL.OESCH_ACT_UNDEMAND)

2990: p_old_line_rec.demand_class_code;
2991: IF l_debug_level > 0 THEN
2992: oe_debug_pub.add( 'MRP ACTION: ' || X_ATP_REC.ACTION ( I ) , 3 ) ;
2993: END IF;
2994: ELSIF (l_action_code = OE_SCHEDULE_UTIL.OESCH_ACT_UNDEMAND)
2995: THEN
2996: x_atp_rec.Action(I) := 120;
2997: x_atp_rec.Quantity_Ordered(I) := 0;
2998: x_atp_rec.Old_Source_Organization_Id(I) :=

Line 4381: OE_SCHEDULE_UTIL.OESCH_ITEM_IS_SUBSTITUTED := 'Y'; -- Added for ER 6110708.

4377: := p_atp_rec.inventory_item_id(J);
4378: p_x_line_rec.item_identifier_type := 'INT';
4379:
4380: -- This variable is to track that the Item is being Substituted by Scheduling and not being changed manully by user.
4381: OE_SCHEDULE_UTIL.OESCH_ITEM_IS_SUBSTITUTED := 'Y'; -- Added for ER 6110708.
4382: END IF; -- inv changed.
4383:
4384: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110509' THEN
4385:

Line 4589: OE_SCHEDULE_UTIL.OESCH_ITEM_IS_SUBSTITUTED := 'Y'; -- Added for ER 6110708.

4585: := p_atp_rec.inventory_item_id(J);
4586: p_x_line_rec.item_identifier_type := 'INT';
4587:
4588: -- This variable is to track that the Item is being Substituted by Scheduling and not being changed manully by user.
4589: OE_SCHEDULE_UTIL.OESCH_ITEM_IS_SUBSTITUTED := 'Y'; -- Added for ER 6110708.
4590: END IF; -- inv changed.
4591:
4592:
4593: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110509' THEN

Line 4889: OE_SCHEDULE_UTIL.Update_PO(p_x_line_rec.schedule_arrival_date,

4885: IF l_debug_level > 0 THEN
4886: oe_debug_pub.add(' Need By Date is not allowed to update. Updating MTL_Supply only',5);
4887: END IF;
4888:
4889: OE_SCHEDULE_UTIL.Update_PO(p_x_line_rec.schedule_arrival_date,
4890: p_x_line_rec.source_document_id,
4891: p_x_line_rec.source_document_line_id);
4892: END IF;
4893: END IF;

Line 5297: OE_SCHEDULE_UTIL.Update_PO(p_x_line_tbl(i).schedule_arrival_date,

5293: IF l_debug_level > 0 THEN
5294: oe_debug_pub.add(' Need By Date is not allowed to update. Updating MTL_Supply only',5);
5295: END IF;
5296:
5297: OE_SCHEDULE_UTIL.Update_PO(p_x_line_tbl(i).schedule_arrival_date,
5298: p_x_line_tbl(i).source_document_id,
5299: p_x_line_tbl(i).source_document_line_id);
5300: END IF;
5301: END IF;

Line 5814: FND_MESSAGE.SET_TOKEN('WHERE','OE_SCHEDULE_UTIL');

5810: THEN
5811: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
5812: FND_MESSAGE.SET_TOKEN('BY_PROC',
5813: 'GMI_Reservation_Util.Get_OPM_item_from_Apps');
5814: FND_MESSAGE.SET_TOKEN('WHERE','OE_SCHEDULE_UTIL');
5815: RAISE FND_API.G_EXC_ERROR;
5816: END IF;
5817: get_process_query_quantities ( p_org_id => p_org_id,
5818: p_item_id => l_ic_item_mst_rec.item_id,

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

7946: END IF;
7947: END IF;
7948:
7949:
7950: OE_SCHEDULE_UTIL.OESCH_PERFORM_SCHEDULING := 'N';
7951: OE_ORDER_SCH_UTIL.OESCH_PERFORM_SCHEDULING := 'N';
7952:
7953: IF l_debug_level > 0 THEN
7954: oe_debug_pub.add( 'CALLING PROCESS ORDER' , 1 ) ;

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

7992: IF l_debug_level > 0 THEN
7993: oe_debug_pub.add( 'UI CASCADE FLAG SET TO TRUE' , 4 ) ;
7994: END IF;
7995:
7996: OE_SCHEDULE_UTIL.OESCH_PERFORM_SCHEDULING := 'Y';
7997: OE_ORDER_SCH_UTIL.OESCH_PERFORM_SCHEDULING := 'Y';
7998:
7999: EXCEPTION
8000: WHEN OTHERS THEN

Line 8055: Print_Time('Entering ** OE_SCHEDULE_UTIL.Schedule_Line ');

8051:
8052:
8053: BEGIN
8054:
8055: Print_Time('Entering ** OE_SCHEDULE_UTIL.Schedule_Line ');
8056: IF l_debug_level > 0 THEN
8057: oe_debug_pub.add('---- Old Record ---- ',1);
8058: OE_DEBUG_PUB.ADD ( 'LINE ID : '||P_OLD_LINE_REC.LINE_ID , 1 ) ;
8059: oe_debug_pub.add( 'ATO LINE ID : '||P_OLD_LINE_REC.ATO_LINE_ID , 1 ) ;

Line 8429: oe_debug_pub.add( 'CALLING OE_SCHEDULE_UTIL.VALIDATE LINE' , 1 ) ;

8425:
8426: <>
8427:
8428: IF l_debug_level > 0 THEN
8429: oe_debug_pub.add( 'CALLING OE_SCHEDULE_UTIL.VALIDATE LINE' , 1 ) ;
8430: END IF;
8431:
8432: Validate_Line(p_line_rec => p_x_line_rec,
8433: p_old_line_rec => l_old_line_rec,

Line 8973: l_index := OE_SCHEDULE_UTIL.OE_Delayed_Schedule_line_tbl.count;

8969: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,
8970: p_requesting_entity_id => p_line_rec.header_id,
8971: p_request_type => OE_GLOBALS.G_DELAYED_SCHEDULE,
8972: x_return_status => l_return_status);
8973: l_index := OE_SCHEDULE_UTIL.OE_Delayed_Schedule_line_tbl.count;
8974: OE_SCHEDULE_UTIL.OE_Delayed_Schedule_line_tbl(l_index+1) := p_line_rec;
8975: oe_debug_pub.add( '6663462 : logging delayed scheduling req for header_id ' || OE_SCHEDULE_UTIL.OE_Delayed_Schedule_line_tbl(l_index+1).header_id, 1 ) ;
8976: END IF;
8977:

Line 8974: OE_SCHEDULE_UTIL.OE_Delayed_Schedule_line_tbl(l_index+1) := p_line_rec;

8970: p_requesting_entity_id => p_line_rec.header_id,
8971: p_request_type => OE_GLOBALS.G_DELAYED_SCHEDULE,
8972: x_return_status => l_return_status);
8973: l_index := OE_SCHEDULE_UTIL.OE_Delayed_Schedule_line_tbl.count;
8974: OE_SCHEDULE_UTIL.OE_Delayed_Schedule_line_tbl(l_index+1) := p_line_rec;
8975: oe_debug_pub.add( '6663462 : logging delayed scheduling req for header_id ' || OE_SCHEDULE_UTIL.OE_Delayed_Schedule_line_tbl(l_index+1).header_id, 1 ) ;
8976: END IF;
8977:
8978: END IF;

Line 8975: oe_debug_pub.add( '6663462 : logging delayed scheduling req for header_id ' || OE_SCHEDULE_UTIL.OE_Delayed_Schedule_line_tbl(l_index+1).header_id, 1 ) ;

8971: p_request_type => OE_GLOBALS.G_DELAYED_SCHEDULE,
8972: x_return_status => l_return_status);
8973: l_index := OE_SCHEDULE_UTIL.OE_Delayed_Schedule_line_tbl.count;
8974: OE_SCHEDULE_UTIL.OE_Delayed_Schedule_line_tbl(l_index+1) := p_line_rec;
8975: oe_debug_pub.add( '6663462 : logging delayed scheduling req for header_id ' || OE_SCHEDULE_UTIL.OE_Delayed_Schedule_line_tbl(l_index+1).header_id, 1 ) ;
8976: END IF;
8977:
8978: END IF;
8979: END IF;

Line 9357: oe_debug_pub.add( '..ENTERING OE_SCHEDULE_UTIL.VALIDATE_LINE :' || P_SCH_ACTION , 1 ) ;

9353: --
9354: BEGIN
9355:
9356: IF l_debug_level > 0 THEN
9357: oe_debug_pub.add( '..ENTERING OE_SCHEDULE_UTIL.VALIDATE_LINE :' || P_SCH_ACTION , 1 ) ;
9358: END IF;
9359: x_return_status := FND_API.G_RET_STS_SUCCESS;
9360:
9361: -- If the quantity on the line is missing or null and if

Line 9939: p_sch_action = OE_SCHEDULE_UTIL.OESCH_ACT_SCHEDULE

9935: END IF;
9936: ELSE
9937:
9938: IF p_line_rec.ship_from_org_id is NULL AND
9939: p_sch_action = OE_SCHEDULE_UTIL.OESCH_ACT_SCHEDULE
9940: THEN
9941:
9942: FND_MESSAGE.SET_NAME('ONT','OE_SCH_ATO_WHSE_REQD');
9943: OE_MSG_PUB.Add;

Line 9951: IF (p_sch_action = OE_SCHEDULE_UTIL.OESCH_ACT_RESERVE

9947: x_return_status := FND_API.G_RET_STS_ERROR;
9948:
9949: END IF;
9950: END IF; -- Gop code level
9951: IF (p_sch_action = OE_SCHEDULE_UTIL.OESCH_ACT_RESERVE
9952: OR p_sch_action = OE_SCHEDULE_UTIL.OESCH_ACT_UNRESERVE)
9953: AND p_line_rec.schedule_status_code is null
9954: THEN
9955:

Line 9952: OR p_sch_action = OE_SCHEDULE_UTIL.OESCH_ACT_UNRESERVE)

9948:
9949: END IF;
9950: END IF; -- Gop code level
9951: IF (p_sch_action = OE_SCHEDULE_UTIL.OESCH_ACT_RESERVE
9952: OR p_sch_action = OE_SCHEDULE_UTIL.OESCH_ACT_UNRESERVE)
9953: AND p_line_rec.schedule_status_code is null
9954: THEN
9955:
9956: FND_MESSAGE.SET_NAME('ONT','OE_SCH_RES_NO_CONFIG');

Line 9971: IF p_sch_action = OE_SCHEDULE_UTIL.OESCH_ACT_RESERVE

9967: END IF;
9968: /* 4171389: Reservations cannot be placed for config items if order
9969: * is not booked.
9970: */
9971: IF p_sch_action = OE_SCHEDULE_UTIL.OESCH_ACT_RESERVE
9972: AND p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CONFIG
9973: AND p_line_rec.booked_flag <> 'Y'
9974: THEN
9975: FND_MESSAGE.SET_NAME('ONT','OE_SCH_NO_ACTION_DONE_NO_EXP');

Line 9985: AND ( p_sch_action = OE_SCHEDULE_UTIL.OESCH_ACT_RESERVE

9981: END IF;
9982: -- code fix for 3300528
9983: -- a message has to be given when the user tries to reserve PTO models and classes
9984: ELSIF nvl(p_line_rec.shippable_flag,'N') = 'N'
9985: AND ( p_sch_action = OE_SCHEDULE_UTIL.OESCH_ACT_RESERVE
9986: OR p_sch_action = OE_SCHEDULE_UTIL.OESCH_ACT_UNRESERVE)
9987: AND p_line_rec.schedule_status_code IS NULL
9988: THEN
9989: FND_MESSAGE.SET_NAME('ONT','ONT_SCH_NOT_RESERVABLE');

Line 9986: OR p_sch_action = OE_SCHEDULE_UTIL.OESCH_ACT_UNRESERVE)

9982: -- code fix for 3300528
9983: -- a message has to be given when the user tries to reserve PTO models and classes
9984: ELSIF nvl(p_line_rec.shippable_flag,'N') = 'N'
9985: AND ( p_sch_action = OE_SCHEDULE_UTIL.OESCH_ACT_RESERVE
9986: OR p_sch_action = OE_SCHEDULE_UTIL.OESCH_ACT_UNRESERVE)
9987: AND p_line_rec.schedule_status_code IS NULL
9988: THEN
9989: FND_MESSAGE.SET_NAME('ONT','ONT_SCH_NOT_RESERVABLE');
9990: OE_MSG_PUB.Add;

Line 10528: oe_debug_pub.add( '..EXITING OE_SCHEDULE_UTIL.VALIDATE_LINE WITH ' || X_RETURN_STATUS , 1 ) ;

10524: END IF;
10525: END IF;
10526:
10527: IF l_debug_level > 0 THEN
10528: oe_debug_pub.add( '..EXITING OE_SCHEDULE_UTIL.VALIDATE_LINE WITH ' || X_RETURN_STATUS , 1 ) ;
10529: END IF;
10530:
10531:
10532: EXCEPTION

Line 10578: oe_debug_pub.add( 'ENTERING OE_SCHEDULE_UTIL.PROCESS_REQUEST' , 1 ) ;

10574: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS; --Bug 5343902
10575: BEGIN
10576:
10577: IF l_debug_level > 0 THEN
10578: oe_debug_pub.add( 'ENTERING OE_SCHEDULE_UTIL.PROCESS_REQUEST' , 1 ) ;
10579: END IF;
10580: IF l_debug_level > 0 THEN
10581: oe_debug_pub.add( 'OESCH_AUTO_SCH_FLAG : ' || OESCH_AUTO_SCH_FLAG , 1 ) ;
10582: END IF;

Line 10902: oe_debug_pub.add( 'EXITING OE_SCHEDULE_UTIL.PROCESS_REQUEST: ' || X_RETURN_STATUS , 1 ) ;

10898: END IF;
10899: END IF;
10900:
10901: IF l_debug_level > 0 THEN
10902: oe_debug_pub.add( 'EXITING OE_SCHEDULE_UTIL.PROCESS_REQUEST: ' || X_RETURN_STATUS , 1 ) ;
10903: END IF;
10904:
10905:
10906: EXCEPTION

Line 11155: IF l_order_type_id = oe_schedule_util.sch_cached_mtl_order_type_id AND

11151: oe_debug_pub.add( 'ORDER TYPE ID :' || L_ORDER_TYPE_ID , 2 ) ;
11152: END IF;
11153:
11154: --3748723
11155: IF l_order_type_id = oe_schedule_util.sch_cached_mtl_order_type_id AND
11156: oe_schedule_util.sch_cached_mtl_order_type_name IS NOT NULL THEN
11157: IF l_debug_level > 0 THEN
11158: oe_debug_pub.add( 'From order_type_id_Cache ' , 2 ) ;
11159: END IF;

Line 11156: oe_schedule_util.sch_cached_mtl_order_type_name IS NOT NULL THEN

11152: END IF;
11153:
11154: --3748723
11155: IF l_order_type_id = oe_schedule_util.sch_cached_mtl_order_type_id AND
11156: oe_schedule_util.sch_cached_mtl_order_type_name IS NOT NULL THEN
11157: IF l_debug_level > 0 THEN
11158: oe_debug_pub.add( 'From order_type_id_Cache ' , 2 ) ;
11159: END IF;
11160: l_order_type_name := oe_schedule_util.sch_cached_mtl_order_type_name;

Line 11160: l_order_type_name := oe_schedule_util.sch_cached_mtl_order_type_name;

11156: oe_schedule_util.sch_cached_mtl_order_type_name IS NOT NULL THEN
11157: IF l_debug_level > 0 THEN
11158: oe_debug_pub.add( 'From order_type_id_Cache ' , 2 ) ;
11159: END IF;
11160: l_order_type_name := oe_schedule_util.sch_cached_mtl_order_type_name;
11161: ELSE
11162: BEGIN
11163: SELECT NAME
11164: INTO l_order_type_name

Line 11170: oe_schedule_util.sch_cached_mtl_order_type_name := l_order_type_name;

11166: WHERE TRANSACTION_TYPE_ID = l_order_type_id
11167: AND language = (select language_code
11168: from fnd_languages
11169: where installed_flag = 'B');
11170: oe_schedule_util.sch_cached_mtl_order_type_name := l_order_type_name;
11171: --Begin Bug#6719001
11172: oe_schedule_util.sch_cached_mtl_order_type_id := l_order_type_id;
11173: --End Bug#6719001
11174: EXCEPTION

Line 11172: oe_schedule_util.sch_cached_mtl_order_type_id := l_order_type_id;

11168: from fnd_languages
11169: where installed_flag = 'B');
11170: oe_schedule_util.sch_cached_mtl_order_type_name := l_order_type_name;
11171: --Begin Bug#6719001
11172: oe_schedule_util.sch_cached_mtl_order_type_id := l_order_type_id;
11173: --End Bug#6719001
11174: EXCEPTION
11175: WHEN NO_DATA_FOUND THEN
11176: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 11187: IF l_order_type_name = oe_schedule_util.sch_cached_mtl_order_type_name AND

11183: oe_debug_pub.add( 'SOURCE CODE: ' || L_SOURCE_CODE , 2 ) ;
11184: END IF;
11185:
11186: --3748723
11187: IF l_order_type_name = oe_schedule_util.sch_cached_mtl_order_type_name AND
11188: l_source_code = oe_schedule_util.sch_cached_mtl_source_code AND
11189: p_header_id = oe_schedule_util.sch_cached_mtl_header_id THEN
11190:
11191: IF l_debug_level > 0 THEN

Line 11188: l_source_code = oe_schedule_util.sch_cached_mtl_source_code AND

11184: END IF;
11185:
11186: --3748723
11187: IF l_order_type_name = oe_schedule_util.sch_cached_mtl_order_type_name AND
11188: l_source_code = oe_schedule_util.sch_cached_mtl_source_code AND
11189: p_header_id = oe_schedule_util.sch_cached_mtl_header_id THEN
11190:
11191: IF l_debug_level > 0 THEN
11192: oe_debug_pub.add( 'CACHED SALES_ORDER_ID ' || oe_schedule_util.sch_cached_mtl_sales_order_id , 2 ) ;

Line 11189: p_header_id = oe_schedule_util.sch_cached_mtl_header_id THEN

11185:
11186: --3748723
11187: IF l_order_type_name = oe_schedule_util.sch_cached_mtl_order_type_name AND
11188: l_source_code = oe_schedule_util.sch_cached_mtl_source_code AND
11189: p_header_id = oe_schedule_util.sch_cached_mtl_header_id THEN
11190:
11191: IF l_debug_level > 0 THEN
11192: oe_debug_pub.add( 'CACHED SALES_ORDER_ID ' || oe_schedule_util.sch_cached_mtl_sales_order_id , 2 ) ;
11193: END IF;

Line 11192: oe_debug_pub.add( 'CACHED SALES_ORDER_ID ' || oe_schedule_util.sch_cached_mtl_sales_order_id , 2 ) ;

11188: l_source_code = oe_schedule_util.sch_cached_mtl_source_code AND
11189: p_header_id = oe_schedule_util.sch_cached_mtl_header_id THEN
11190:
11191: IF l_debug_level > 0 THEN
11192: oe_debug_pub.add( 'CACHED SALES_ORDER_ID ' || oe_schedule_util.sch_cached_mtl_sales_order_id , 2 ) ;
11193: END IF;
11194:
11195: RETURN oe_schedule_util.sch_cached_mtl_sales_order_id;
11196: ELSE

Line 11195: RETURN oe_schedule_util.sch_cached_mtl_sales_order_id;

11191: IF l_debug_level > 0 THEN
11192: oe_debug_pub.add( 'CACHED SALES_ORDER_ID ' || oe_schedule_util.sch_cached_mtl_sales_order_id , 2 ) ;
11193: END IF;
11194:
11195: RETURN oe_schedule_util.sch_cached_mtl_sales_order_id;
11196: ELSE
11197: SELECT S.SALES_ORDER_ID
11198: INTO l_sales_order_id
11199: FROM MTL_SALES_ORDERS S,

Line 11206: oe_schedule_util.sch_cached_mtl_header_id := p_header_id;

11202: AND S.SEGMENT2 = l_order_type_name
11203: AND S.SEGMENT3 = l_source_code
11204: AND H.HEADER_ID = p_header_id;
11205: --3748723
11206: oe_schedule_util.sch_cached_mtl_header_id := p_header_id;
11207: oe_schedule_util.sch_cached_mtl_source_code :=l_source_code;
11208: oe_schedule_util.sch_cached_mtl_sales_order_id := l_sales_order_id;
11209: oe_schedule_util.sch_cached_mtl_order_type_id := l_order_type_id;
11210: END IF;

Line 11207: oe_schedule_util.sch_cached_mtl_source_code :=l_source_code;

11203: AND S.SEGMENT3 = l_source_code
11204: AND H.HEADER_ID = p_header_id;
11205: --3748723
11206: oe_schedule_util.sch_cached_mtl_header_id := p_header_id;
11207: oe_schedule_util.sch_cached_mtl_source_code :=l_source_code;
11208: oe_schedule_util.sch_cached_mtl_sales_order_id := l_sales_order_id;
11209: oe_schedule_util.sch_cached_mtl_order_type_id := l_order_type_id;
11210: END IF;
11211:

Line 11208: oe_schedule_util.sch_cached_mtl_sales_order_id := l_sales_order_id;

11204: AND H.HEADER_ID = p_header_id;
11205: --3748723
11206: oe_schedule_util.sch_cached_mtl_header_id := p_header_id;
11207: oe_schedule_util.sch_cached_mtl_source_code :=l_source_code;
11208: oe_schedule_util.sch_cached_mtl_sales_order_id := l_sales_order_id;
11209: oe_schedule_util.sch_cached_mtl_order_type_id := l_order_type_id;
11210: END IF;
11211:
11212: IF l_debug_level > 0 THEN

Line 11209: oe_schedule_util.sch_cached_mtl_order_type_id := l_order_type_id;

11205: --3748723
11206: oe_schedule_util.sch_cached_mtl_header_id := p_header_id;
11207: oe_schedule_util.sch_cached_mtl_source_code :=l_source_code;
11208: oe_schedule_util.sch_cached_mtl_sales_order_id := l_sales_order_id;
11209: oe_schedule_util.sch_cached_mtl_order_type_id := l_order_type_id;
11210: END IF;
11211:
11212: IF l_debug_level > 0 THEN
11213: oe_debug_pub.add( 'L_SALES_ORDER_ID' || L_SALES_ORDER_ID , 2 ) ;

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

11375: IF l_debug_level > 0 THEN
11376: oe_debug_pub.add( 'ENTERING CALL_PROCESS_ORDER' , 1 ) ;
11377: END IF;
11378:
11379: OE_SCHEDULE_UTIL.OESCH_PERFORM_SCHEDULING := 'N';
11380: OE_ORDER_SCH_UTIL.OESCH_PERFORM_SCHEDULING := 'N';
11381:
11382: IF l_debug_level > 0 THEN
11383: oe_debug_pub.add( 'CALLING PROCESS ORDER' , 1 ) ;

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

11427: END IF;
11428: RAISE FND_API.G_EXC_ERROR;
11429: END IF;
11430:
11431: OE_SCHEDULE_UTIL.OESCH_PERFORM_SCHEDULING := 'Y';
11432: OE_ORDER_SCH_UTIL.OESCH_PERFORM_SCHEDULING := 'Y';
11433:
11434: -- Resetting the variable after the Process Order API Call.
11435: OE_SCHEDULE_UTIL.OESCH_ITEM_IS_SUBSTITUTED := 'N'; -- Added for ER 6110708

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

11431: OE_SCHEDULE_UTIL.OESCH_PERFORM_SCHEDULING := 'Y';
11432: OE_ORDER_SCH_UTIL.OESCH_PERFORM_SCHEDULING := 'Y';
11433:
11434: -- Resetting the variable after the Process Order API Call.
11435: OE_SCHEDULE_UTIL.OESCH_ITEM_IS_SUBSTITUTED := 'N'; -- Added for ER 6110708
11436:
11437: IF l_debug_level > 0 THEN
11438: oe_debug_pub.add( 'EXITING CALL PROCESS ORDER' , 1 ) ;
11439: END IF;

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

11440: EXCEPTION
11441:
11442: WHEN FND_API.G_EXC_ERROR THEN
11443:
11444: OE_SCHEDULE_UTIL.OESCH_PERFORM_SCHEDULING := 'Y';
11445: OE_ORDER_SCH_UTIL.OESCH_PERFORM_SCHEDULING := 'Y';
11446: x_return_status := FND_API.G_RET_STS_ERROR;
11447:
11448: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

11446: x_return_status := FND_API.G_RET_STS_ERROR;
11447:
11448: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
11449:
11450: OE_SCHEDULE_UTIL.OESCH_PERFORM_SCHEDULING := 'Y';
11451: OE_ORDER_SCH_UTIL.OESCH_PERFORM_SCHEDULING := 'Y';
11452: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11453:
11454: WHEN OTHERS THEN

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

11452: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11453:
11454: WHEN OTHERS THEN
11455:
11456: OE_SCHEDULE_UTIL.OESCH_PERFORM_SCHEDULING := 'Y';
11457: OE_ORDER_SCH_UTIL.OESCH_PERFORM_SCHEDULING := 'Y';
11458: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11459:
11460: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 11555: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FROM OE_SCHEDULE_UTIL.PROCESS_GROUP_OF_LINE IS: ' || X_RETURN_STATUS ) ;

11551: p_line_id => p_x_line_tbl(I).line_id,
11552: x_index => l_index,
11553: x_return_status => x_return_status);
11554: IF l_debug_level > 0 THEN
11555: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FROM OE_SCHEDULE_UTIL.PROCESS_GROUP_OF_LINE IS: ' || X_RETURN_STATUS ) ;
11556: END IF;
11557: IF l_debug_level > 0 THEN
11558: oe_debug_pub.add( 'GLOBAL PICTURE INDEX IS: ' || L_INDEX , 1 ) ;
11559: END IF;

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

11694: END IF;
11695: END IF; /*code_release_level*/
11696:
11697:
11698: OE_SCHEDULE_UTIL.OESCH_PERFORM_SCHEDULING := 'Y';
11699: OE_ORDER_SCH_UTIL.OESCH_PERFORM_SCHEDULING := 'Y';
11700: IF l_debug_level > 0 THEN
11701: oe_debug_pub.add( 'PROCESS GROUP ' || OESCH_PERFORM_SCHEDULING , 1 ) ;
11702: END IF;

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

11706: EXCEPTION
11707:
11708: WHEN FND_API.G_EXC_ERROR THEN
11709:
11710: OE_SCHEDULE_UTIL.OESCH_PERFORM_SCHEDULING := 'Y';
11711: OE_ORDER_SCH_UTIL.OESCH_PERFORM_SCHEDULING := 'Y';
11712: x_return_status := FND_API.G_RET_STS_ERROR;
11713: ROLLBACK TO SAVEPOINT Process_Group_of_lines;
11714:

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

11713: ROLLBACK TO SAVEPOINT Process_Group_of_lines;
11714:
11715: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
11716:
11717: OE_SCHEDULE_UTIL.OESCH_PERFORM_SCHEDULING := 'Y';
11718: OE_ORDER_SCH_UTIL.OESCH_PERFORM_SCHEDULING := 'Y';
11719: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11720: ROLLBACK TO SAVEPOINT Process_Group_of_lines;
11721:

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

11720: ROLLBACK TO SAVEPOINT Process_Group_of_lines;
11721:
11722: WHEN OTHERS THEN
11723:
11724: OE_SCHEDULE_UTIL.OESCH_PERFORM_SCHEDULING := 'Y';
11725: OE_ORDER_SCH_UTIL.OESCH_PERFORM_SCHEDULING := 'Y';
11726: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11727: ROLLBACK TO SAVEPOINT Process_Group_of_lines;
11728:

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

12129: p_line_id => p_x_line_rec.line_id,
12130: x_index => l_index,
12131: x_return_status => x_return_status);
12132: IF l_debug_level > 0 THEN
12133: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FROM OE_SCHEDULE_UTIL.PROCESS_LINE IS: ' || X_RETURN_STATUS ) ;
12134: END IF;
12135: IF l_debug_level > 0 THEN
12136: oe_debug_pub.add( 'GLOBAL PICTURE INDEX IS: ' || L_INDEX , 1 ) ;
12137: END IF;

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

12256:
12257: WHEN FND_API.G_EXC_ERROR THEN
12258:
12259: x_return_status := FND_API.G_RET_STS_ERROR;
12260: OE_SCHEDULE_UTIL.OESCH_PERFORM_SCHEDULING := 'Y';
12261: OE_ORDER_SCH_UTIL.OESCH_PERFORM_SCHEDULING := 'Y';
12262:
12263: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
12264:

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

12262:
12263: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
12264:
12265: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12266: OE_SCHEDULE_UTIL.OESCH_PERFORM_SCHEDULING := 'Y';
12267: OE_ORDER_SCH_UTIL.OESCH_PERFORM_SCHEDULING := 'Y';
12268:
12269: WHEN OTHERS THEN
12270:

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

12268:
12269: WHEN OTHERS THEN
12270:
12271: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12272: OE_SCHEDULE_UTIL.OESCH_PERFORM_SCHEDULING := 'Y';
12273: OE_ORDER_SCH_UTIL.OESCH_PERFORM_SCHEDULING := 'Y';
12274:
12275: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
12276: THEN

Line 12644: oe_debug_pub.add( 'ENTERING OE_SCHEDULE_UTIL.DELETE_ROW' , 1 ) ;

12640: --
12641: BEGIN
12642:
12643: IF l_debug_level > 0 THEN
12644: oe_debug_pub.add( 'ENTERING OE_SCHEDULE_UTIL.DELETE_ROW' , 1 ) ;
12645: END IF;
12646: OE_Line_Util.Query_Row(p_line_id => p_line_id,
12647: x_line_rec => l_line_rec);
12648:

Line 12654: l_sales_order_id := OE_SCHEDULE_UTIL.Get_mtl_sales_order_id

12650: shippable line */
12651:
12652: IF nvl(l_line_rec.shippable_flag,'N') = 'Y' THEN
12653:
12654: l_sales_order_id := OE_SCHEDULE_UTIL.Get_mtl_sales_order_id
12655: (l_line_rec.HEADER_ID);
12656:
12657:
12658: -- INVCONV - MERGED CALLS FOR OE_LINE_UTIL.Get_Reserved_Quantity and OE_LINE_UTIL.Get_Reserved_Quantity2

Line 12773: p_param1 => OE_Schedule_Util.OESCH_ACT_RESCHEDULE,

12769: p_entity_id => l_line_rec.ato_line_id,
12770: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
12771: p_requesting_entity_id => l_line_rec.line_id,
12772: p_request_type => OE_GLOBALS.G_SCHEDULE_ATO,
12773: p_param1 => OE_Schedule_Util.OESCH_ACT_RESCHEDULE,
12774: p_param2 => l_line_rec.top_model_line_id,
12775: p_param3 => l_line_rec.ship_from_org_id,
12776: p_param4 => l_line_rec.ship_to_org_id,
12777: p_param5 => l_line_rec.shipping_method_code,

Line 12815: oe_debug_pub.add( 'EXITING OE_SCHEDULE_UTIL.DELETE_ROW' , 1 ) ;

12811:
12812: END IF;
12813:
12814: IF l_debug_level > 0 THEN
12815: oe_debug_pub.add( 'EXITING OE_SCHEDULE_UTIL.DELETE_ROW' , 1 ) ;
12816: END IF;
12817: EXCEPTION
12818:
12819: WHEN OTHERS THEN

Line 13090: OE_SCHEDULE_UTIL.OESCH_ACT_RESCHEDULE;

13086:
13087: K := K +1;
13088: l_line_tbl(K) := l_local_line_tbl(L);
13089: l_line_tbl(K).schedule_action_code :=
13090: OE_SCHEDULE_UTIL.OESCH_ACT_RESCHEDULE;
13091: l_line_tbl(K).arrival_set := l_set_rec.set_name;
13092:
13093: END LOOP;
13094:

Line 13110: OE_SCHEDULE_UTIL.OESCH_ACT_RESCHEDULE;

13106:
13107: K := K +1;
13108: l_line_tbl(K) := l_local_line_tbl(L);
13109: l_line_tbl(K).schedule_action_code :=
13110: OE_SCHEDULE_UTIL.OESCH_ACT_RESCHEDULE;
13111:
13112: l_line_tbl(K).ship_set := l_set_rec.set_name;
13113: END LOOP;
13114:

Line 13131: OE_SCHEDULE_UTIL.OESCH_ACT_RESCHEDULE;

13127:
13128: K := K +1;
13129: l_line_tbl(K) := l_local_line_tbl(L);
13130: l_line_tbl(K).schedule_action_code :=
13131: OE_SCHEDULE_UTIL.OESCH_ACT_RESCHEDULE;
13132: l_line_tbl(K).ship_set := p_x_line_tbl(I).top_model_line_id;
13133:
13134: END LOOP;
13135:

Line 13166: OE_SCHEDULE_UTIL.OESCH_ACT_RESCHEDULE;

13162:
13163: K := K +1;
13164: l_line_tbl(K) := l_local_line_tbl(L);
13165: l_line_tbl(K).schedule_action_code :=
13166: OE_SCHEDULE_UTIL.OESCH_ACT_RESCHEDULE;
13167: l_line_tbl(K).ship_set := l_ato_line_id;
13168:
13169:
13170: END LOOP;

Line 13180: OE_SCHEDULE_UTIL.OESCH_ACT_RESCHEDULE;

13176:
13177: K := K +1;
13178: l_line_tbl(K) := p_x_line_tbl(I);
13179: l_line_tbl(K).schedule_action_code :=
13180: OE_SCHEDULE_UTIL.OESCH_ACT_RESCHEDULE;
13181:
13182:
13183: END IF;
13184: END IF; -- 2680748

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

14049:
14050: IF l_debug_level > 0 THEN
14051: oe_debug_pub.add( 'LINE COUNT IS: ' || L_LINE_TBL.COUNT , 1 ) ;
14052: END IF;
14053: OE_SCHEDULE_UTIL.OESCH_PERFORM_SCHEDULING := 'N';
14054: OE_ORDER_SCH_UTIL.OESCH_PERFORM_SCHEDULING := 'N';
14055:
14056: IF l_debug_level > 0 THEN
14057: oe_debug_pub.add( 'BKL: CALLING PROCESS ORDER' , 1 ) ;

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

14111: END LOOP ;
14112:
14113: -- End of the code added to fix the bug 3105070
14114:
14115: OE_SCHEDULE_UTIL.OESCH_PERFORM_SCHEDULING := 'Y';
14116: OE_ORDER_SCH_UTIL.OESCH_PERFORM_SCHEDULING := 'Y';
14117:
14118: x_return_status := l_return_status;
14119: x_msg_count := l_msg_count;

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

14132: WHEN FND_API.G_EXC_ERROR THEN
14133:
14134: x_return_status := FND_API.G_RET_STS_ERROR;
14135: /*
14136: OE_SCHEDULE_UTIL.OESCH_PERFORM_SCHEDULING := 'Y';
14137: OE_ORDER_SCH_UTIL.OESCH_PERFORM_SCHEDULING := 'Y';
14138: */
14139: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
14140:

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

14138: */
14139: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
14140:
14141: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
14142: OE_SCHEDULE_UTIL.OESCH_PERFORM_SCHEDULING := 'Y';
14143: OE_ORDER_SCH_UTIL.OESCH_PERFORM_SCHEDULING := 'Y';
14144:
14145: WHEN OTHERS THEN
14146:

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

14145: WHEN OTHERS THEN
14146:
14147: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
14148:
14149: OE_SCHEDULE_UTIL.OESCH_PERFORM_SCHEDULING := 'Y';
14150: OE_ORDER_SCH_UTIL.OESCH_PERFORM_SCHEDULING := 'Y';
14151: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
14152: THEN
14153: OE_MSG_PUB.Add_Exc_Msg

Line 14819: l_order_date_type_code := NVL(oe_schedule_util.Get_Date_Type(l_header_id),'SHIP');

14815: CLOSE order_header_id;
14816: ELSE
14817: l_header_id := p_header_id;
14818: END IF;
14819: l_order_date_type_code := NVL(oe_schedule_util.Get_Date_Type(l_header_id),'SHIP');
14820: l_promise_date_flag := Oe_Sys_Parameters.Value('PROMISE_DATE_FLAG');
14821: IF l_debug_level > 0 THEN
14822: oe_debug_pub.add( 'PROMISE DATE FLAG: '||l_promise_date_flag , 3 ) ;
14823: oe_debug_pub.add( 'STATUS CODE : '||p_x_line_rec.schedule_status_code , 3 ) ;

Line 15066: OE_SCHEDULE_UTIL.Get_Lead_Time

15062: IF l_ato_line_id = l_st_ato_line_id THEN
15063: l_atp_lead_time := l_st_atp_lead_time;
15064: ELSE
15065: l_st_atp_lead_time :=
15066: OE_SCHEDULE_UTIL.Get_Lead_Time
15067: (p_ato_line_id => l_ato_line_id,
15068: p_ship_from_org_id => l_ship_from_org_id);
15069: l_atp_lead_time := l_st_atp_lead_time;
15070:

Line 15778: -- l_old_line_rec.schedule_action_code := OE_SCHEDULE_UTIL.OESCH_ACT_UNSCHEDULE;

15774:
15775: OE_Line_Util.Query_Row(p_line_id => p_line_id,
15776: x_line_rec => l_old_line_rec);
15777: l_old_line_rec.schedule_action_code := p_schedule_action_code ;
15778: -- l_old_line_rec.schedule_action_code := OE_SCHEDULE_UTIL.OESCH_ACT_UNSCHEDULE;
15779: l_new_line_rec := l_old_line_rec;
15780: Load_MRP_request_from_rec
15781: ( p_line_rec => l_new_line_rec
15782: , p_old_line_rec => l_old_line_rec

Line 15915: l_line_tbl := OE_SCHEDULE_UTIL.OE_Delayed_Schedule_line_tbl;

15911: l_old_line_tbl OE_ORDER_PUB.Line_tbl_type;
15912:
15913: BEGIN
15914: oe_debug_pub.add( '6663462 : in schedule_delayed_lines ');
15915: l_line_tbl := OE_SCHEDULE_UTIL.OE_Delayed_Schedule_line_tbl;
15916: l_old_line_tbl := l_line_tbl;
15917: for j in 1..l_line_tbl.count LOOP
15918: oe_debug_pub.add( ' 6663462 : line_id '|| l_line_tbl(j).line_id );
15919: l_line_tbl(j).operation := OE_GLOBALS.G_OPR_UPDATE; --6715950

Line 15932: OE_SCHEDULE_UTIL.OE_Delayed_Schedule_line_tbl.delete;

15928: ,p_sch_action => 'SCHEDULE'
15929: ,p_partial => TRUE
15930: ,x_return_status => x_return_status);
15931:
15932: OE_SCHEDULE_UTIL.OE_Delayed_Schedule_line_tbl.delete;
15933:
15934: END IF;
15935:
15936: EXCEPTION

Line 15964: IF OE_SCHEDULE_UTIL.OESCH_ITEM_IS_SUBSTITUTED = 'Y' THEN

15960: )
15961: IS
15962: BEGIN
15963:
15964: IF OE_SCHEDULE_UTIL.OESCH_ITEM_IS_SUBSTITUTED = 'Y' THEN
15965: x_result_out := 1;
15966: ELSE
15967: x_result_out := 0;
15968: END IF;

Line 16044: OE_SCHEDULE_UTIL.OESCH_ITEM_IS_SUBSTITUTED := 'N';

16040: IF l_shippable_flag <> p_old_shippable_flag THEN
16041: oe_debug_pub.add( 'Item substitution cannot happen between shippable and non-shippable items' , 5 ) ;
16042: Fnd_Message.set_name('ONT','OE_SCH_LOOP_SHP_NONSHP');
16043: Oe_Msg_Pub.Add;
16044: OE_SCHEDULE_UTIL.OESCH_ITEM_IS_SUBSTITUTED := 'N';
16045: RAISE FND_API.G_EXC_ERROR;
16046: END IF;
16047: END;
16048: END VALIDATE_ITEM_SUBSTITUTION;

Line 16050: END OE_SCHEDULE_UTIL;

16046: END IF;
16047: END;
16048: END VALIDATE_ITEM_SUBSTITUTION;
16049:
16050: END OE_SCHEDULE_UTIL;