APPS.WMS_ITEM_LOAD dependencies on FND_PROFILE

Line 11: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

7:
8:
9: PROCEDURE print_debug(p_debug_msg IN VARCHAR2)
10: IS
11: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
12: BEGIN
13: IF (l_debug = 1) THEN
14: inv_mobile_helper_functions.tracelog
15: (p_err_msg => p_debug_msg,

Line 38: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

34: x_total_qty OUT NOCOPY NUMBER)--Added for bug 5002690
35: IS
36: l_api_name CONSTANT VARCHAR2(30) := 'get_available_qty';
37: l_progress VARCHAR2(10);
38: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
39:
40: -- Variables used to call validate_operation API
41: l_error_code NUMBER;
42: l_inspection_flag NUMBER;

Line 240: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

236: x_available_lot_qty OUT NOCOPY NUMBER)
237: IS
238: l_api_name CONSTANT VARCHAR2(30) := 'get_available_lot_qty';
239: l_progress VARCHAR2(10);
240: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
241:
242: -- Variables used to call validate_operation API
243: l_error_code NUMBER;
244: l_inspection_flag NUMBER;

Line 418: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

414: x_msg_data OUT NOCOPY VARCHAR2)
415: IS
416: l_api_name CONSTANT VARCHAR2(30) := 'pre_process_load';
417: l_progress VARCHAR2(10);
418: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
419: l_lpn_context NUMBER;
420: -- Variables used to lock the WLC (WMS_LPN_CONTENTS) records.
421: -- WLC records should always exist for the given LPN if an item
422: -- load on the java side has been done.

Line 2096: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

2092: x_msg_data OUT NOCOPY VARCHAR2)
2093: IS
2094: l_api_name CONSTANT VARCHAR2(30) := 'process_load';
2095: l_progress VARCHAR2(10);
2096: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2097: -- Variables used to call Suggestions_PUB and activate_operation_instance
2098: l_number_of_rows NUMBER;
2099: l_crossdock VARCHAR2(3);
2100: l_mo_line_id NUMBER;

Line 3406: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

3402: x_msg_data OUT NOCOPY VARCHAR2)
3403: IS
3404: l_api_name CONSTANT VARCHAR2(30) := 'unmark_serials';
3405: l_progress VARCHAR2(10);
3406: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3407:
3408: BEGIN
3409: IF (l_debug = 1) THEN
3410: print_debug('***Calling unmark_serials with the following parameters***');

Line 3518: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

3514: x_msg_data OUT NOCOPY VARCHAR2)
3515: IS
3516: l_api_name CONSTANT VARCHAR2(30) := 'cleanup_ATF';
3517: l_progress VARCHAR2(10);
3518: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3519: l_mmtt_temp_id NUMBER;
3520: l_error_code NUMBER;
3521: -- This cursor will get all of the MMTT suggestionss associated with the lpn_id passed.
3522: -- Cleanup should not be called if there are no WDT records.