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 FND_PROFILE

Line 1087: l_source_code VARCHAR2(40) := FND_PROFILE.VALUE('ONT_SOURCE_CODE');

1083: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;
1084: l_count NUMBER;
1085: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
1086: l_qty_to_unreserve NUMBER;
1087: l_source_code VARCHAR2(40) := FND_PROFILE.VALUE('ONT_SOURCE_CODE');
1088: l_sales_order_id NUMBER;
1089: l_x_error_code NUMBER;
1090: l_lock_records VARCHAR2(1);
1091: l_sort_by_req_date NUMBER ;

Line 1274: IF NVL(fnd_profile.value('ONT_SHIP_METHOD_FOR_SHIP_SET'),'N') = 'Y' THEN

1270: p_line_ship_to_org_id = p_set_Ship_To_Org_Id AND
1271: p_line_schedule_ship_date = p_set_schedule_ship_date) THEN
1272:
1273: /* Modified the above line and added followinf 7 lines to fix the bug 3393033 */
1274: IF NVL(fnd_profile.value('ONT_SHIP_METHOD_FOR_SHIP_SET'),'N') = 'Y' THEN
1275: -- 3878494
1276: IF OE_GLOBALS.equal(p_line_shipping_method_code,p_set_shipping_method_code) THEN
1277: RETURN TRUE;
1278: END IF;

Line 1468: AND NVL(fnd_profile.value('ONT_SET_FOR_EACH_LINE'),'N') = 'Y'

1464: l_set_ship_from_org_id := l_ship_from_org_id;
1465: l_set_shipping_method_code := l_shipping_method_code;
1466:
1467: IF l_schedule_ship_date is null
1468: AND NVL(fnd_profile.value('ONT_SET_FOR_EACH_LINE'),'N') = 'Y'
1469: AND p_line_rec.schedule_status_code is null
1470: AND l_set_status = 'T' THEN
1471:
1472: l_action := OESCH_ACT_SCHEDULE;

Line 2341: IF FND_PROFILE.VALUE('POR_SYNC_NEEDBYDATE_OM') = 'YES' THEN

2337:
2338: IF NOT OE_Internal_Requisition_Pvt.G_Update_ISO_From_Req
2339: AND NOT OE_SALES_CAN_UTIL.G_IR_ISO_HDR_CANCEL THEN
2340:
2341: IF FND_PROFILE.VALUE('POR_SYNC_NEEDBYDATE_OM') = 'YES' THEN
2342:
2343: IF l_debug_level > 0 THEN
2344: oe_debug_pub.add(' Logging G_UPDATE_REQUISITION delayed request for date change');
2345: END IF;

Line 3190: l_inv_ctp := fnd_profile.value('INV_CTP');

3186: END IF;
3187:
3188: ELSE
3189:
3190: l_inv_ctp := fnd_profile.value('INV_CTP');
3191:
3192: IF l_debug_level > 0 THEN
3193: oe_debug_pub.add( 'INV_CTP : '||L_INV_CTP , 3 ) ;
3194: END IF;

Line 3539: l_mrp_calc_sd := fnd_profile.value('MRP_ATP_CALC_SD');

3535: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3536: --
3537: BEGIN
3538:
3539: l_mrp_calc_sd := fnd_profile.value('MRP_ATP_CALC_SD');
3540:
3541: IF l_debug_level > 0 THEN
3542: oe_debug_pub.add( 'MRP_ATP_CALC_SD : '||L_MRP_CALC_SD , 3 ) ;
3543: END IF;

Line 3625: l_mrp_calc_sd := fnd_profile.value('MRP_ATP_CALC_SD');

3621:
3622: IF l_debug_level > 0 THEN
3623: oe_debug_pub.add( 'ENTERING LOAD_MRP_REQUEST_FROM_TBL' , 1 ) ;
3624: END IF;
3625: l_mrp_calc_sd := fnd_profile.value('MRP_ATP_CALC_SD');
3626:
3627: IF l_debug_level > 0 THEN
3628: oe_debug_pub.add( 'MRP_ATP_CALC_SD : '||L_MRP_CALC_SD , 3 ) ;
3629: END IF;

Line 3690: NVL(fnd_profile.value('ONT_BYPASS_ATP'),'N') = 'Y' THEN

3686:
3687: --3763015
3688: IF l_scheduling_level_code = SCH_LEVEL_FOUR OR
3689: l_scheduling_level_code = SCH_LEVEL_FIVE OR
3690: NVL(fnd_profile.value('ONT_BYPASS_ATP'),'N') = 'Y' THEN
3691:
3692: IF l_debug_level > 0 THEN
3693: oe_debug_pub.add( 'INACTIVE DEMAND LINE , LINE_ID = ' || P_LINE_TBL.LAST ) ;
3694: END IF;

Line 4845: IF FND_PROFILE.VALUE('POR_SYNC_NEEDBYDATE_OM') = 'YES' THEN

4841:
4842: IF p_x_line_rec.order_source_id = 10 THEN
4843: IF NOT OE_Internal_Requisition_Pvt.G_Update_ISO_From_Req
4844: AND NOT OE_SALES_CAN_UTIL.G_IR_ISO_HDR_CANCEL THEN
4845: IF FND_PROFILE.VALUE('POR_SYNC_NEEDBYDATE_OM') = 'YES' THEN
4846: -- Modified for IR ISO Tracking bug 7667702
4847:
4848: IF l_debug_level > 0 THEN
4849: oe_debug_pub.add(' Logging G_UPDATE_REQUISITION delayed request for date change',5);

Line 5252: -- AND FND_PROFILE.VALUE('POR_SYNC_NEEDBYDATE_OM') = 'YES' THEN

5248: ) THEN
5249:
5250: IF NOT OE_Internal_Requisition_Pvt.G_Update_ISO_From_Req
5251: AND NOT OE_SALES_CAN_UTIL.G_IR_ISO_HDR_CANCEL THEN
5252: -- AND FND_PROFILE.VALUE('POR_SYNC_NEEDBYDATE_OM') = 'YES' THEN
5253: IF FND_PROFILE.VALUE('POR_SYNC_NEEDBYDATE_OM') = 'YES' THEN
5254: -- Modified for IR ISO Tracking bug 7667702
5255:
5256: IF l_debug_level > 0 THEN

Line 5253: IF FND_PROFILE.VALUE('POR_SYNC_NEEDBYDATE_OM') = 'YES' THEN

5249:
5250: IF NOT OE_Internal_Requisition_Pvt.G_Update_ISO_From_Req
5251: AND NOT OE_SALES_CAN_UTIL.G_IR_ISO_HDR_CANCEL THEN
5252: -- AND FND_PROFILE.VALUE('POR_SYNC_NEEDBYDATE_OM') = 'YES' THEN
5253: IF FND_PROFILE.VALUE('POR_SYNC_NEEDBYDATE_OM') = 'YES' THEN
5254: -- Modified for IR ISO Tracking bug 7667702
5255:
5256: IF l_debug_level > 0 THEN
5257: oe_debug_pub.add(' Logging G_UPDATE_REQUISITION delayed request for date change');

Line 5563: NVL(fnd_profile.value('ONT_BYPASS_ATP'),'N') = 'Y') THEN

5559: -- BUG 1955004
5560: -- 3763015
5561: IF (sch_cached_sch_level_code = SCH_LEVEL_FOUR OR
5562: sch_cached_sch_level_code = SCH_LEVEL_FIVE OR
5563: NVL(fnd_profile.value('ONT_BYPASS_ATP'),'N') = 'Y') THEN
5564: -- this is an inactive demand line.
5565:
5566: IF l_debug_level > 0 THEN
5567: oe_debug_pub.add( 'THIS IS A SINGLE INACTIVE DEMAND LINE' , 1 ) ;

Line 6670: NVL(fnd_profile.value('ONT_BYPASS_ATP'),'N') = 'Y') THEN

6666: END IF;
6667: -- 3763015
6668: IF (l_scheduling_level_code = SCH_LEVEL_FOUR OR
6669: l_scheduling_level_code = SCH_LEVEL_FIVE OR
6670: NVL(fnd_profile.value('ONT_BYPASS_ATP'),'N') = 'Y') THEN
6671: -- this is an inactive demand line.
6672:
6673: IF l_debug_level > 0 THEN
6674: oe_debug_pub.add( 'IT IS AN INACTIVE DEMAND LINE' , 1 ) ;

Line 7657: l_source_code VARCHAR2(40) := FND_PROFILE.VALUE('ONT_SOURCE_CODE');

7653: , p_quantity2_to_reserve IN NUMBER DEFAULT NULL
7654: , x_reservation_rec OUT NOCOPY Inv_Reservation_Global.Mtl_Reservation_Rec_Type)
7655:
7656: IS
7657: l_source_code VARCHAR2(40) := FND_PROFILE.VALUE('ONT_SOURCE_CODE');
7658: l_sales_order_id NUMBER;
7659: l_subinventory VARCHAR2(10);
7660: --
7661: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 8388: AND fnd_profile.value('ONT_SHIP_METHOD_FOR_SHIP_SET') = 'Y'

8384:
8385: IF NVL(OE_SYS_PARAMETERS.value('RESCHEDULE_SHIP_METHOD_FLAG'),'Y') = 'N'
8386: AND NOT OE_GLOBALS.Equal(p_x_line_rec.shipping_method_code,
8387: l_old_line_rec.shipping_method_code)
8388: AND fnd_profile.value('ONT_SHIP_METHOD_FOR_SHIP_SET') = 'Y'
8389: THEN
8390:
8391: IF l_debug_level > 0 THEN
8392: oe_debug_pub.add( 'SHIPPING_METHOD CHANGED , CASCADE' , 4 ) ;

Line 8720: l_delayed_schedule VARCHAR2(1) := NVL(fnd_profile.value('ONT_DELAY_SCHEDULING'),'N') ;

8716: l_order_date_type_code VARCHAR2(30):='';
8717: l_request_date_flag VARCHAR2(1) := 'Y';
8718: l_shipping_method_flag VARCHAR2(1) := 'Y';
8719: /* 6663462 Added the following 3 variables for the Delayed Scheduling feature */
8720: l_delayed_schedule VARCHAR2(1) := NVL(fnd_profile.value('ONT_DELAY_SCHEDULING'),'N') ;
8721: l_index NUMBER := 0;
8722: l_return_status VARCHAR2(1);
8723:
8724:

Line 9644: IF NVL(fnd_profile.value('ONT_BYPASS_ATP'),'N') = 'Y' THEN

9640: END IF;
9641: x_return_status := FND_API.G_RET_STS_ERROR;
9642: END IF;
9643: -- 3763015
9644: IF NVL(fnd_profile.value('ONT_BYPASS_ATP'),'N') = 'Y' THEN
9645:
9646: -- An item with this profile set MUST have a warehouse
9647: IF l_debug_level > 0 THEN
9648: oe_debug_pub.add( 'CHECKING THAT LINE HAS A WAREHOUSE...' , 1 ) ;

Line 9833: OR NVL(fnd_profile.value('ONT_BYPASS_ATP'),'N') = 'Y' THEN

9829:
9830: -- 3763015
9831: IF (l_scheduling_level_code is not null
9832: AND l_scheduling_level_code <> SCH_LEVEL_THREE)
9833: OR NVL(fnd_profile.value('ONT_BYPASS_ATP'),'N') = 'Y' THEN
9834: IF l_scheduling_level_code = SCH_LEVEL_ONE THEN
9835: IF p_sch_action = OESCH_ACT_SCHEDULE OR
9836: p_sch_action = OESCH_ACT_RESERVE OR
9837: (p_line_rec.schedule_status_code is null AND

Line 9880: NVL(fnd_profile.value('ONT_BYPASS_ATP'),'N') = 'Y' THEN

9876: --BUG 1955004
9877: -- 3763015
9878: IF l_scheduling_level_code = SCH_LEVEL_FOUR OR
9879: l_scheduling_level_code = SCH_LEVEL_FIVE OR
9880: NVL(fnd_profile.value('ONT_BYPASS_ATP'),'N') = 'Y' THEN
9881: IF p_sch_action = OESCH_ACT_ATP_CHECK THEN
9882: -- levels Four and Five CANNOT have ATP Performed
9883: FND_MESSAGE.SET_NAME('ONT', 'OE_SCH_ACTION_NOT_ALLOWED');
9884: FND_MESSAGE.SET_TOKEN('ACTION',

Line 9998: IF NVL(FND_PROFILE.VALUE('ONT_SCH_ATO_ITEM_WO_BOM'), 'N') = 'N' THEN

9994: -- code fix for 3300528
9995: END IF; -- part of ato
9996:
9997: -- Added for 3451987
9998: IF NVL(FND_PROFILE.VALUE('ONT_SCH_ATO_ITEM_WO_BOM'), 'N') = 'N' THEN
9999: -- Added this part of validation to fix bug 2051855
10000: IF p_line_rec.ato_line_id = p_line_rec.line_id
10001: AND p_line_rec.item_type_code in ('STANDARD','OPTION')
10002: AND fnd_profile.value('INV_CTP') = '5'THEN

Line 10002: AND fnd_profile.value('INV_CTP') = '5'THEN

9998: IF NVL(FND_PROFILE.VALUE('ONT_SCH_ATO_ITEM_WO_BOM'), 'N') = 'N' THEN
9999: -- Added this part of validation to fix bug 2051855
10000: IF p_line_rec.ato_line_id = p_line_rec.line_id
10001: AND p_line_rec.item_type_code in ('STANDARD','OPTION')
10002: AND fnd_profile.value('INV_CTP') = '5'THEN
10003:
10004: l_org_id := OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
10005:
10006: -- Added code to fix bug 2156268

Line 10183: NVL(FND_PROFILE.VALUE('ONT_OVERRIDE_ATP'), 'N');

10179: */
10180: -- BUG 1282873
10181: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110509' THEN
10182: l_auth_to_override_atp :=
10183: NVL(FND_PROFILE.VALUE('ONT_OVERRIDE_ATP'), 'N');
10184:
10185: IF l_debug_level > 0 THEN
10186: oe_debug_pub.add( 'ONT_OVERRIDE_ATP' || L_AUTH_TO_OVERRIDE_ATP , 3 ) ;
10187: END IF;

Line 11112: l_source_code VARCHAR2(40) := FND_PROFILE.VALUE('ONT_SOURCE_CODE');

11108: FUNCTION Get_mtl_sales_order_id(p_header_id IN NUMBER,
11109: p_order_type_id IN NUMBER DEFAULT NULL)
11110: RETURN NUMBER
11111: IS
11112: l_source_code VARCHAR2(40) := FND_PROFILE.VALUE('ONT_SOURCE_CODE');
11113: l_sales_order_id NUMBER := 0;
11114: l_order_type_name VARCHAR2(80);
11115: l_order_type_id NUMBER;
11116: --

Line 11250: l_source_code VARCHAR2(40) := FND_PROFILE.VALUE('ONT_SOURCE_CODE');

11246: Procedure Insert_Into_Mtl_Sales_Orders
11247: ( p_header_rec IN OE_ORDER_PUB.header_rec_type)
11248: IS
11249: l_order_type_name VARCHAR2(80);
11250: l_source_code VARCHAR2(40) := FND_PROFILE.VALUE('ONT_SOURCE_CODE');
11251: l_sales_order_id NUMBER;
11252: l_msg_data VARCHAR2(2000);
11253: l_msg_count NUMBER;
11254: l_return_status VARCHAR2(1);

Line 12341: NVL(fnd_profile.value('ONT_BYPASS_ATP'),'N') = 'N' THEN

12337: END IF;
12338: -- 3763015
12339: IF l_scheduling_level_code <> SCH_LEVEL_FOUR AND
12340: l_scheduling_level_code <> SCH_LEVEL_FIVE AND
12341: NVL(fnd_profile.value('ONT_BYPASS_ATP'),'N') = 'N' THEN
12342: -- FOUR and FIVE CANNOT have ATP Performed
12343: -- validation may be off, so we we need to double-check here
12344: --END 1955004
12345:

Line 13993: fnd_profile.put('OE_DEBUG_LOG_DIRECTORY','/sqlcom/outbound/dom1151');

13989: IF l_debug_level > 0 THEN
13990: oe_debug_pub.add( 'This API is not supported ' , 1 ) ;
13991: END IF;
13992: /*
13993: fnd_profile.put('OE_DEBUG_LOG_DIRECTORY','/sqlcom/outbound/dom1151');
13994:
13995: IF l_debug_level > 0 THEN
13996: oe_debug_pub.add( 'ENTERING UPDATE_RESULTS_FROM_BACKLOG_WB' , 1 ) ;
13997: END IF;

Line 14498: l_source_code VARCHAR2(40) := FND_PROFILE.VALUE('ONT_SOURCE_CODE');

14494: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;
14495: l_count NUMBER;
14496: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
14497: l_qty_to_unreserve NUMBER;
14498: l_source_code VARCHAR2(40) := FND_PROFILE.VALUE('ONT_SOURCE_CODE');
14499: l_sales_order_id NUMBER;
14500: l_x_error_code NUMBER;
14501: l_lock_records VARCHAR2(1);
14502: l_sort_by_req_date NUMBER ;

Line 15179: l_insert_flag := fnd_profile.value('MRP_ATP_CALC_SD');

15175: SELECT instance_id
15176: INTO l_instance_id
15177: FROM mrp_ap_apps_instances;
15178:
15179: l_insert_flag := fnd_profile.value('MRP_ATP_CALC_SD');
15180:
15181: IF nvl(l_insert_flag,'N') = 'Y' THEN
15182: l_insert_code := 1;
15183: ELSE