APPS.OE_DS_PVT dependencies on FND_PROFILE

Line 146: l_source_code VARCHAR2(40) := fnd_profile.value('ONT_SOURCE_CODE');

142: l_qty_to_reserve NUMBER;
143: l_rsv_id NUMBER := 0;
144: l_sales_order_id NUMBER;
145: l_return_status VARCHAR2(1);
146: l_source_code VARCHAR2(40) := fnd_profile.value('ONT_SOURCE_CODE');
147: l_chart_of_accts NUMBER;
148:
149: l_lot_set_id NUMBER := null;
150:

Line 910: profile_values.oe_source_code := FND_PROFILE.VALUE('ONT_SOURCE_CODE');

906: -- bug 5357879
907: SAVEPOINT DECREMENT_INV;
908: x_return_status := FND_API.G_RET_STS_SUCCESS;
909:
910: profile_values.oe_source_code := FND_PROFILE.VALUE('ONT_SOURCE_CODE');
911: profile_values.user_id := FND_GLOBAL.USER_ID;
912: profile_values.login_id := FND_GLOBAL.LOGIN_ID;
913: profile_values.request_id := 0;
914: profile_values.application_id := 0;

Line 1302: oe_debug_pub.add('Source_code : ' || fnd_profile.value ( 'ont_source_code' ) , 1 ) ;

1298: END; */
1299:
1300: IF l_debug_level > 0 THEN
1301: oe_debug_pub.add('Inserting header record' ) ;
1302: oe_debug_pub.add('Source_code : ' || fnd_profile.value ( 'ont_source_code' ) , 1 ) ;
1303: oe_debug_pub.add('Source_line_id : ' || l_source_line_id , 1 ) ;
1304: oe_debug_pub.add('Source_header_id : ' || l_transaction_reference , 1 ) ;
1305: oe_debug_pub.add('Process_flag : ' || 1 , 1 ) ;
1306: oe_debug_pub.add('Transaction_mode : ' || 1 , 1 ) ;

Line 1324: -- oe_debug_pub.add('Dsp_segment3 : ' || fnd_profile.value ( 'ont_source_code' ) , 1 ) ;

1320: oe_debug_pub.add('Created_by : ' || fnd_global.user_id , 1 ) ;
1321: oe_debug_pub.add('Transaction_source_id : ' || l_transaction_source_id , 1 ) ;
1322: -- oe_debug_pub.add('Dsp_segment1 : ' || l_order_number , 1 ) ; bug 4456817
1323: -- oe_debug_pub.add('Dsp_segment2 : ' || l_order_type_name , 1 ) ;
1324: -- oe_debug_pub.add('Dsp_segment3 : ' || fnd_profile.value ( 'ont_source_code' ) , 1 ) ;
1325: oe_debug_pub.add('Transaction_source_type_id : ' || l_trx_source_type_id , 1 ) ;
1326: oe_debug_pub.add('Transaction_action_id : ' || l_trx_action_id , 1 ) ;
1327: oe_debug_pub.add('Transaction_type_id : ' || l_trx_type_code , 1 ) ;
1328: oe_debug_pub.add('Distribution_account_id : ' || l_trans_acc , 1 ) ;

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

1700: -------------------------------------------------------------------------- */
1701: FUNCTION Get_mtl_sales_order_id(p_header_id IN NUMBER)
1702: RETURN NUMBER
1703: IS
1704: l_source_code VARCHAR2(40) := FND_PROFILE.VALUE('ONT_SOURCE_CODE');
1705: l_sales_order_id NUMBER := 0;
1706: l_order_type_name VARCHAR2(80);
1707: l_order_type_id NUMBER;
1708: --

Line 1862: nvl(To_Number(FND_PROFILE.VALUE('USER_ID')),-1),

1858: l_po_line_id,
1859: l_line_location_id,
1860: l_po_release_id,
1861: trunc(Sysdate),
1862: nvl(To_Number(FND_PROFILE.VALUE('USER_ID')),-1),
1863: trunc(Sysdate),
1864: nvl(To_Number(FND_PROFILE.VALUE('USER_ID')),-1)
1865: );
1866:

Line 1864: nvl(To_Number(FND_PROFILE.VALUE('USER_ID')),-1)

1860: l_po_release_id,
1861: trunc(Sysdate),
1862: nvl(To_Number(FND_PROFILE.VALUE('USER_ID')),-1),
1863: trunc(Sysdate),
1864: nvl(To_Number(FND_PROFILE.VALUE('USER_ID')),-1)
1865: );
1866:
1867: End Insert_OE_Drop_Ship_Source;
1868:

Line 2013: profile_values.oe_source_code := FND_PROFILE.VALUE('ONT_SOURCE_CODE');

2009: oe_debug_pub.add( ' P_SN_CONTROL_CODE : ' || P_SN_CONTROL_CODE , 1 ) ;
2010: oe_debug_pub.add( ' P_TRANSACTION_ID : ' || P_TRANSACTION_ID , 1 ) ;
2011: END IF;
2012:
2013: profile_values.oe_source_code := FND_PROFILE.VALUE('ONT_SOURCE_CODE');
2014:
2015: /*
2016: ** Check For The Transaction Account
2017: */