APPS.MTL_CCEOI_ACTION_PVT dependencies on FND_PROFILE

Line 8: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

4:
5:
6: procedure mdebug(msg in varchar2)
7: is
8: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
9: begin
10: --dbms_output.put_line(msg);
11: null;
12: end;

Line 30: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

26: x_msg_data OUT NOCOPY VARCHAR2 )
27: IS
28: L_api_version CONSTANT NUMBER := 0.9;
29: L_api_name CONSTANT VARCHAR2(30) := 'Process_Error';
30: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
31: BEGIN
32:
33: -- Standard start of API savepoint
34: SAVEPOINT Process_Error;

Line 158: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

154: x_msg_count OUT NOCOPY NUMBER ,
155: x_msg_data OUT NOCOPY VARCHAR2 ,
156: p_interface_rec IN MTL_CCEOI_VAR_PVT.INV_CCEOI_TYPE )
157: IS
158: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
159: BEGIN
160: -- Start OF comments
161: -- API name : Export_CountRequest
162: -- TYPE : Private

Line 307: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

303: p_interface_rec IN MTL_CCEOI_VAR_PVT.INV_CCEOI_TYPE )
304: IS
305: L_api_version CONSTANT NUMBER := 0.9;
306: L_api_name CONSTANT VARCHAR2(30) := 'Create_CountRequest';
307: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
308: BEGIN
309: -- Start OF comments
310: -- API name : Create_CountRequest
311: -- TYPE : Private

Line 607: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

603: L_api_version CONSTANT NUMBER := 0.9;
604: L_err_count NUMBER := 0;
605: L_api_name CONSTANT VARCHAR2(30) := 'Process_CountRequest';
606:
607: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
608: BEGIN
609: -- Start OF comments
610: -- API name : Process_CountRequest
611: -- TYPE : Private

Line 946: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

942: x_msg_count OUT NOCOPY NUMBER ,
943: x_msg_data OUT NOCOPY VARCHAR2 ,
944: p_interface_rec IN MTL_CCEOI_VAR_PVT.INV_CCEOI_TYPE )
945: IS
946: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
947: BEGIN
948: -- Start OF comments
949: -- API name : Validate_CountRequest
950: -- TYPE : Private

Line 1445: AND (NVL(fnd_profile.value_wnps('INV_TRANS_REASON_SECURITY'), 'N') = 'N')

1441: into l_count
1442: FROM MTL_TRANSACTION_REASONS
1443: WHERE REASON_ID = P_INTERFACE_REC.TRANSACTION_REASON_ID
1444: and NVL(DISABLE_DATE, SYSDATE+1) > SYSDATE
1445: AND (NVL(fnd_profile.value_wnps('INV_TRANS_REASON_SECURITY'), 'N') = 'N')
1446: OR reason_id IN
1447: (SELECT reason_id
1448: FROM mtl_trans_reason_security
1449: WHERE (responsibility_id = fnd_global.resp_id

Line 1634: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

1630: x_msg_count OUT NOCOPY NUMBER ,
1631: x_msg_data OUT NOCOPY VARCHAR2 ,
1632: p_interface_rec IN MTL_CCEOI_VAR_PVT.INV_CCEOI_TYPE )
1633: IS
1634: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1635: BEGIN
1636: -- Start OF comments
1637: -- API name : ValSim_CountRequest
1638: -- TYPE : Private

Line 1802: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

1798: x_msg_count OUT NOCOPY NUMBER ,
1799: x_msg_data OUT NOCOPY VARCHAR2 ,
1800: p_interface_rec IN MTL_CCEOI_VAR_PVT.INV_CCEOI_TYPE )
1801: IS
1802: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1803: BEGIN
1804: -- Start OF comments
1805: -- API name : UpdateInsert_CountRequest
1806: -- TYPE : Private