APPS.INV_LPN_RESERVATIONS_PVT dependencies on FND_PROFILE

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

10: -- This procedure will create a separate reservation for each lot and
11: -- revision in that LPN.
12:
13: PROCEDURE debug_print(p_message IN VARCHAR2, p_level IN NUMBER := 9) IS
14: --l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
15: BEGIN
16: inv_log_util.TRACE(p_message, g_pkg_name, p_level);
17: -- dbms_output.put_line(p_message);
18: END debug_print;

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

179: SELECT SUM(primary_transaction_quantity)
180: FROM mtl_onhand_quantities_detail
181: WHERE lpn_id = p_lpn_id;
182:
183: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
184: BEGIN
185: IF (l_debug = 1) THEN
186: debug_print('Enter Create_LPN_Reservations');
187: debug_print('OrgID = ' || p_organization_id || ' : ItemID = ' || p_inventory_item_id || ' : LPN ID = ' || p_lpn_id);

Line 783: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

779: l_reservable_type NUMBER; --Bug 6007873
780: l_lpn_controlled_flag NUMBER; --Bug 6007873
781: BEGIN
782: IF (g_debug IS NULL) THEN
783: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
784: END IF;
785:
786: l_debug := g_debug;
787:

Line 950: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

946: l_reservable_type NUMBER;
947: l_lpn_controlled_flag NUMBER;
948: BEGIN
949: IF (g_debug IS NULL) THEN
950: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
951: END IF;
952:
953: l_debug := g_debug;
954: