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 136: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

132: PROCEDURE split_child_mmtt(p_child_temp_id NUMBER,
133: p_new_child_temp_id NUMBER,
134: p_split_pri_qty NUMBER)
135: IS
136: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
137: BEGIN
138: INSERT INTO mtl_material_transactions_temp
139: (
140: transaction_header_id

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

552: p_new_serial_temp_id NUMBER,
553: p_split_pri_qty NUMBER,
554: p_child_lot_number VARCHAR2) --v1 Bug 3902766
555: IS
556: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
557: BEGIN
558: -- insert into mtlt and update the qty for old line
559: INSERT INTO mtl_transaction_lots_temp
560: (

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

761: l_parent_loc_id NUMBER;
762: l_lpn_id NUMBER;
763: l_transfer_lpn_id NUMBER;
764: l_api_name VARCHAR2(32):= 'update_child';
765: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
766:
767: BEGIN
768: IF l_debug=1 THEN
769: mydebug('get parent line info, parent temp id:'||p_parent_temp_id,l_api_name);

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

827: l_mmtt_rec mtl_material_transactions_temp%ROWTYPE;
828: l_mtlt_rec mtl_transaction_lots_temp%ROWTYPE;
829: l_new_temp_id NUMBER;
830: l_api_name VARCHAR2(30) := 'create_sub_transfer';
831: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
832:
833: CURSOR over_picked_lots(p_temp_id NUMBER) IS
834: select sum(transaction_quantity) transaction_quantity,
835: sum(primary_quantity) primary_quantity, lot_number

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

1089: l_parent_sub_code VARCHAR2(30);
1090: l_parent_loc_id NUMBER;
1091: l_lpn_id NUMBER;
1092: l_transfer_lpn_id NUMBER;
1093: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
1094: l_new_temp_id NUMBER;
1095: l_serial_temp_id NUMBER;
1096: l_api_name VARCHAR2(30) := 'bulk_pick';
1097: l_mmtt_qty NUMBER;