DBA Data[Home] [Help]

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 184: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

180: sum (secondary_transaction_quantity) -- 16773889
181: FROM mtl_onhand_quantities_detail
182: WHERE lpn_id = p_lpn_id;
183:
184: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
185: -- 16773889
186: l_fb VARCHAR2(1) := 'P';
187: l_lpn_sec_rsv_qty NUMBER;
188: l_sec_rsv_qty NUMBER;

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

863: l_error_code NUMBER;
864:
865: BEGIN
866: IF (g_debug IS NULL) THEN
867: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
868: END IF;
869:
870: l_debug := g_debug;
871:

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

1097:
1098:
1099: BEGIN
1100: IF (g_debug IS NULL) THEN
1101: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1102: END IF;
1103:
1104: l_debug := g_debug;
1105: