APPS.MTL_INV_UTIL_GRP dependencies on FND_PROFILE

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

3: G_PKG_NAME CONSTANT VARCHAR2(30) := 'MTL_INV_UTIL_GRP';
4:
5: procedure mdebug(msg in varchar2)
6: is
7: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
8: begin
9: --dbms_output.put_line(msg);
10: inv_log_util.trace(msg , g_pkg_name || ' ',9);
11: end;

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

25: p_inventory_item_id IN NUMBER ,
26: p_locator_id IN NUMBER ,
27: x_item_cost OUT NOCOPY NUMBER )
28: IS
29: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
30: BEGIN
31: -- Start OF comments
32: -- API name : Get_Item_Cost
33: -- TYPE : Private

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

195: p_serial_number_control IN NUMBER ,
196: p_serial_count_option IN NUMBER ,
197: x_system_quantity OUT NOCOPY NUMBER )
198: IS
199: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
200: BEGIN
201: -- Start OF comments
202: -- API name : Calculate_Systemquantity
203: -- TYPE : Private

Line 458: l_debug NUMBER := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);

454: x_system_quantity OUT NOCOPY NUMBER,
455: x_sec_system_quantity OUT NOCOPY NUMBER
456: )
457: IS
458: l_debug NUMBER := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);
459: BEGIN
460: -- Start OF comments
461: -- API name : Calculate_Systemquantity
462: -- TYPE : Private

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

869: L_current_locator_id NUMBER(38) ;
870: L_current_organization_id NUMBER(38) ;
871: L_nothing VARCHAR2(30);
872: L_user_id NUMBER;
873: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
874: BEGIN
875: IF P_SERIAL_CONTROL NOT IN (2,5) THEN
876: RETURN(FALSE);
877: END IF;

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

1153: e_Invalid_Inputs EXCEPTION;
1154:
1155: L_api_version CONSTANT NUMBER := 0.9;
1156: L_api_name CONSTANT VARCHAR2(30) := 'Get_LPN_Item_SysQty';
1157: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1158: BEGIN
1159: -- Standard start of API savepoint
1160: SAVEPOINT Get_LPN_Item_SysQty;
1161:

Line 1376: l_debug NUMBER := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);

1372: l_loaded_sec_sys_qty NUMBER;
1373: e_invalid_inputs EXCEPTION;
1374: l_api_version CONSTANT NUMBER := 0.9;
1375: l_api_name CONSTANT VARCHAR2 (30) := 'Get_LPN_Item_SysQty2';
1376: l_debug NUMBER := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);
1377: BEGIN
1378: -- Standard start of API savepoint
1379: SAVEPOINT get_lpn_item_sysqty;
1380:

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

1559: AND cycle_count_header_id = MTL_CCEOI_VAR_PVT.G_CC_HEADER_ID; -- 8300310
1560:
1561: l_dummy MTL_CYCLE_COUNT_ENTRIES.inventory_item_id%TYPE;
1562:
1563: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1564: BEGIN
1565: OPEN cce_csr;
1566: FETCH cce_csr INTO l_dummy;
1567: IF cce_csr%FOUND THEN

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

1595: AND cycle_count_header_id = p_cc_header_id;
1596:
1597: l_dummy MTL_CYCLE_COUNT_ITEMS.inventory_item_id%TYPE;
1598:
1599: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1600: BEGIN
1601: OPEN cci_csr;
1602: FETCH cci_csr INTO l_dummy;
1603: IF cci_csr%FOUND THEN