APPS.OE_DS_PVT dependencies on FND_PROFILE

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

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

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

931: -- bug 5357879
932: SAVEPOINT DECREMENT_INV;
933: x_return_status := FND_API.G_RET_STS_SUCCESS;
934:
935: profile_values.oe_source_code := FND_PROFILE.VALUE('ONT_SOURCE_CODE');
936: profile_values.user_id := FND_GLOBAL.USER_ID;
937: profile_values.login_id := FND_GLOBAL.LOGIN_ID;
938: profile_values.request_id := 0;
939: profile_values.application_id := 0;

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

1323: END; */
1324:
1325: IF l_debug_level > 0 THEN
1326: oe_debug_pub.add('Inserting header record' ) ;
1327: oe_debug_pub.add('Source_code : ' || fnd_profile.value ( 'ont_source_code' ) , 1 ) ;
1328: oe_debug_pub.add('Source_line_id : ' || l_source_line_id , 1 ) ;
1329: oe_debug_pub.add('Source_header_id : ' || l_transaction_reference , 1 ) ;
1330: oe_debug_pub.add('Process_flag : ' || 1 , 1 ) ;
1331: oe_debug_pub.add('Transaction_mode : ' || 1 , 1 ) ;

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

1345: oe_debug_pub.add('Created_by : ' || fnd_global.user_id , 1 ) ;
1346: oe_debug_pub.add('Transaction_source_id : ' || l_transaction_source_id , 1 ) ;
1347: -- oe_debug_pub.add('Dsp_segment1 : ' || l_order_number , 1 ) ; bug 4456817
1348: -- oe_debug_pub.add('Dsp_segment2 : ' || l_order_type_name , 1 ) ;
1349: -- oe_debug_pub.add('Dsp_segment3 : ' || fnd_profile.value ( 'ont_source_code' ) , 1 ) ;
1350: oe_debug_pub.add('Transaction_source_type_id : ' || l_trx_source_type_id , 1 ) ;
1351: oe_debug_pub.add('Transaction_action_id : ' || l_trx_action_id , 1 ) ;
1352: oe_debug_pub.add('Transaction_type_id : ' || l_trx_type_code , 1 ) ;
1353: oe_debug_pub.add('Distribution_account_id : ' || l_trans_acc , 1 ) ;

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

1725: -------------------------------------------------------------------------- */
1726: FUNCTION Get_mtl_sales_order_id(p_header_id IN NUMBER)
1727: RETURN NUMBER
1728: IS
1729: l_source_code VARCHAR2(40) := FND_PROFILE.VALUE('ONT_SOURCE_CODE');
1730: l_sales_order_id NUMBER := 0;
1731: l_order_type_name VARCHAR2(80);
1732: l_order_type_id NUMBER;
1733: --

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

1883: l_po_line_id,
1884: l_line_location_id,
1885: l_po_release_id,
1886: trunc(Sysdate),
1887: nvl(To_Number(FND_PROFILE.VALUE('USER_ID')),-1),
1888: trunc(Sysdate),
1889: nvl(To_Number(FND_PROFILE.VALUE('USER_ID')),-1)
1890: );
1891:

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

1885: l_po_release_id,
1886: trunc(Sysdate),
1887: nvl(To_Number(FND_PROFILE.VALUE('USER_ID')),-1),
1888: trunc(Sysdate),
1889: nvl(To_Number(FND_PROFILE.VALUE('USER_ID')),-1)
1890: );
1891:
1892: End Insert_OE_Drop_Ship_Source;
1893:

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

2034: oe_debug_pub.add( ' P_SN_CONTROL_CODE : ' || P_SN_CONTROL_CODE , 1 ) ;
2035: oe_debug_pub.add( ' P_TRANSACTION_ID : ' || P_TRANSACTION_ID , 1 ) ;
2036: END IF;
2037:
2038: profile_values.oe_source_code := FND_PROFILE.VALUE('ONT_SOURCE_CODE');
2039:
2040: /*
2041: ** Check For The Transaction Account
2042: */