APPS.WMS_BULK_PICK dependencies on FND_PROFILE

Line 11: g_trace_on NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 2);

7: -- Description : WMS bulk picking API for mobile application
8: -- Notes :
9: -- Modified : 07/30/2003 jali created
10: g_pkg_name CONSTANT VARCHAR2(30) := 'wms_bulk_pick';
11: g_trace_on NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 2);
12: g_newline CONSTANT VARCHAR2(10) := fnd_global.newline;
13:
14: -- Bug# 4185621: added global variable to be used later
15: l_g_task_loaded CONSTANT NUMBER := 4;

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

15: l_g_task_loaded CONSTANT NUMBER := 4;
16:
17:
18: PROCEDURE mydebug(p_msg IN VARCHAR2, p_api_name IN VARCHAR2) IS
19: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
20: BEGIN
21: -- dbms_output.put_line(p_msg);
22: IF g_trace_on = 1 THEN
23: inv_mobile_helper_functions.tracelog( p_err_msg => p_msg

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

50: l_msg_data VARCHAR2(2000);
51: l_api_name CONSTANT VARCHAR2(30) := 'wms_concurrent_bulk_process';
52: l_api_version CONSTANT NUMBER := 1.0;
53: ret BOOLEAN;
54: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
55:
56: BEGIN
57:
58: -- Initialize API return status to success

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

133: p_new_child_temp_id NUMBER,
134: p_split_pri_qty NUMBER,
135: p_split_sec_qty NUMBER) --bug 8197506
136: IS
137: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
138: -- starts bug 8197506
139: l_api_name CONSTANT VARCHAR2(30) := 'split_child_mmtt';
140: BEGIN
141: -- 8197506

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

573: p_split_pri_qty NUMBER,
574: p_child_lot_number VARCHAR2, --v1 Bug 3902766
575: p_split_sec_qty NUMBER) --bug 8197506
576: IS
577: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
578: -- 8197506
579: l_api_name CONSTANT VARCHAR2(30) := 'split_child_mtlt';
580: BEGIN
581: -- 8197506

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

798: l_parent_loc_id NUMBER;
799: l_lpn_id NUMBER;
800: l_transfer_lpn_id NUMBER;
801: l_api_name VARCHAR2(32):= 'update_child';
802: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
803:
804: BEGIN
805: IF l_debug=1 THEN
806: mydebug('get parent line info, parent temp id:'||p_parent_temp_id,l_api_name);

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

865: l_mmtt_rec mtl_material_transactions_temp%ROWTYPE;
866: l_mtlt_rec mtl_transaction_lots_temp%ROWTYPE;
867: l_new_temp_id NUMBER;
868: l_api_name VARCHAR2(30) := 'create_sub_transfer';
869: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
870:
871: CURSOR over_picked_lots(p_temp_id NUMBER) IS
872: select sum(transaction_quantity) transaction_quantity,
873: sum(primary_quantity) primary_quantity,

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

1371: l_parent_sub_code VARCHAR2(30);
1372: l_parent_loc_id NUMBER;
1373: l_lpn_id NUMBER;
1374: l_transfer_lpn_id NUMBER;
1375: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
1376: l_new_temp_id NUMBER;
1377: l_serial_temp_id NUMBER;
1378: l_api_name VARCHAR2(30) := 'bulk_pick';
1379: l_mmtt_qty NUMBER;