APPS.OE_ORDER_SCH_UTIL dependencies on FND_PROFILE

Line 3048: IF FND_PROFILE.VALUE('ONT_SCHEDULE_LINE_ON_HOLD') = 'N' AND

3044:
3045: IF l_debug_level > 0 THEN
3046: oe_debug_pub.add( 'CHECKING FOR HOLDS....' , 1 ) ;
3047: END IF;
3048: IF FND_PROFILE.VALUE('ONT_SCHEDULE_LINE_ON_HOLD') = 'N' AND
3049: (p_line_rec.schedule_action_code = OESCH_ACT_SCHEDULE OR
3050: p_line_rec.schedule_action_code = OESCH_ACT_RESERVE OR
3051: (p_line_rec.schedule_status_code is not null AND
3052: Schedule_Attribute_Changed(p_line_rec => p_line_rec,

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

3151:
3152: -- Added this part of validation to fix bug 2051855
3153: IF p_line_rec.ato_line_id = p_line_rec.line_id
3154: AND p_line_rec.item_type_code in ('STANDARD','OPTION')
3155: AND fnd_profile.value('INV_CTP') = '5' THEN
3156:
3157: l_org_id := OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
3158:
3159: -- Added code to fix bug 2156268

Line 3497: -- FND_PROFILE.VALUE('ONT_RESERVATION_TIME_FENCE');

3493: -- we will return TRUE, else will return FALSE
3494:
3495: -- Moac. Commented the below code
3496: -- l_rsv_time_fence_profile :=
3497: -- FND_PROFILE.VALUE('ONT_RESERVATION_TIME_FENCE');
3498:
3499: -- Moac. Fetching the reservation time fence from system parameter.
3500: l_rsv_time_fence_profile := OE_Sys_Parameters.VALUE('ONT_RESERVATION_TIME_FENCE');
3501:

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

5808: oe_debug_pub.add( '------------------LOAD MRP TABLE---------------' , 1 ) ;
5809: END IF;
5810:
5811:
5812: l_mrp_calc_sd := fnd_profile.value('MRP_ATP_CALC_SD');
5813:
5814: IF l_debug_level > 0 THEN
5815: oe_debug_pub.add( 'MRP_ATP_CALC_SD : '||L_MRP_CALC_SD , 3 ) ;
5816: END IF;

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

6247: l_st_ato_line_id := l_line_rec.ato_line_id;
6248: END IF;
6249: END IF;
6250:
6251: l_inv_ctp := fnd_profile.value('INV_CTP');
6252:
6253: l_explode := TRUE;
6254:
6255: IF l_debug_level > 0 THEN

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

6606: , p_quantity2_to_reserve IN NUMBER -- INVCONV
6607: , x_reservation_rec OUT NOCOPY /* file.sql.39 change */ Inv_Reservation_Global.Mtl_Reservation_Rec_Type)
6608: IS
6609: l_rsv Inv_Reservation_Global.Mtl_Reservation_Rec_Type;
6610: l_source_code VARCHAR2(40) := FND_PROFILE.VALUE('ONT_SOURCE_CODE');
6611: l_sales_order_id NUMBER;
6612: l_subinventory VARCHAR2(10);
6613: --
6614: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

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

6837: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;
6838: l_count NUMBER;
6839: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
6840: l_qty_to_unreserve NUMBER;
6841: l_source_code VARCHAR2(40) := FND_PROFILE.VALUE('ONT_SOURCE_CODE');
6842: l_sales_order_id NUMBER;
6843: l_x_error_code NUMBER;
6844: l_lock_records VARCHAR2(1);
6845: l_sort_by_req_date NUMBER ;

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

8147: Procedure Insert_Into_Mtl_Sales_Orders
8148: ( p_header_rec IN OE_ORDER_PUB.header_rec_type)
8149: IS
8150: l_order_type_name VARCHAR2(80);
8151: l_source_code VARCHAR2(40) := FND_PROFILE.VALUE('ONT_SOURCE_CODE');
8152: l_sales_order_id NUMBER;
8153: l_msg_data VARCHAR2(2000);
8154: l_msg_count NUMBER;
8155: l_return_status VARCHAR2(1);

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

8243: -------------------------------------------------------------------------- */
8244: FUNCTION Get_mtl_sales_order_id(p_header_id IN NUMBER)
8245: RETURN NUMBER
8246: IS
8247: l_source_code VARCHAR2(40) := FND_PROFILE.VALUE('ONT_SOURCE_CODE');
8248: l_sales_order_id NUMBER := 0;
8249: l_order_type_name VARCHAR2(80);
8250: l_order_type_id NUMBER;
8251: --