APPS.WMS_TXNRSN_ACTIONS_PUB dependencies on FND_PROFILE

Line 10: g_trace_on CONSTANT NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'wms_txnrsn_actions_pub';
7: l_g_ret_sts_error CONSTANT VARCHAR2(30) := fnd_api.g_ret_sts_error;
8: l_g_ret_sts_unexp_error CONSTANT VARCHAR2(30) := fnd_api.g_ret_sts_unexp_error;
9: l_g_ret_sts_success CONSTANT VARCHAR2(30) := fnd_api.g_ret_sts_success;
10: g_trace_on CONSTANT NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
11:
12: g_debug NUMBER := 1;
13: g_module_name VARCHAR2(30) := NULL;
14:

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

90:
91: l_mmtt_header_id NUMBER;
92:
93:
94: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
95: l_proc_name VARCHAR2(30) := 'Inadequate_Qty';
96: BEGIN
97:
98: g_debug := l_debug;

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

561: AND moqd.lot_number = l_lot
562: ORDER BY 1 DESC;
563:
564:
565: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
566: l_proc_name VARCHAR2(30) := 'Suggest_alternate_location';
567: l_original_serial_number inv_reservation_global.serial_number_tbl_type; --Bug#8267628
568: l_new_rsv_id NUMBER ; --8557758
569: l_parent_line_id NUMBER := NULL ; --Bug8460179

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

1958: l_loc_id number; -- 11858770
1959: l_insert_sub VARCHAR2(50); -- 11858770
1960: l_insert_loc number; -- 11858770
1961:
1962: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1963: l_proc_name VARCHAR2(30) := 'Log_exception';
1964: BEGIN
1965:
1966: --Calculate Sequence Number

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

2111: l_allocated_lpn_id NUMBER ;
2112: l_revision VARCHAR2(3);
2113:
2114: l_proc_name VARCHAR2(60) := 'cleanup_task (wrapper)';
2115: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
2116:
2117:
2118: CURSOR rem_mmtt_csr IS
2119: SELECT mmtt.transaction_temp_id

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

2276: l_mtrl_uom VARCHAR2(3);
2277: l_primary_quantity NUMBER;
2278: l_mmtt_transaction_uom VARCHAR2(3);
2279:
2280: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
2281: l_proc_name VARCHAR2(30) := 'CLEANUP_TASK';
2282: l_progress VARCHAR2(30) := '100';
2283: l_wf NUMBER := -1;
2284: l_calling_program VARCHAR2(30) := 'CLEANUP_TASK: QTY EXCEPTION';

Line 2287: l_kill_mo_profile NUMBER := NVL(FND_PROFILE.VALUE_WNPS('INV_KILL_MOVE_ORDER'),2);

2283: l_wf NUMBER := -1;
2284: l_calling_program VARCHAR2(30) := 'CLEANUP_TASK: QTY EXCEPTION';
2285: l_update_parent BOOLEAN := FALSE ; -- No need to call update_parent_mmtt in INV_TRX_UTIL_PUB
2286: l_parent_line_id NUMBER; --For checking bulk task
2287: l_kill_mo_profile NUMBER := NVL(FND_PROFILE.VALUE_WNPS('INV_KILL_MOVE_ORDER'),2);
2288: l_return_status VARCHAR2(1);
2289:
2290: --Bug#6027401.
2291: l_reservation_id NUMBER;