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: null;
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 1562: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

1558: AND entry_status_code IN (1, 3);
1559:
1560: l_dummy MTL_CYCLE_COUNT_ENTRIES.inventory_item_id%TYPE;
1561:
1562: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1563: BEGIN
1564: OPEN cce_csr;
1565: FETCH cce_csr INTO l_dummy;
1566: IF cce_csr%FOUND THEN

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

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