APPS.WMS_TASK_UTILS_PVT dependencies on FND_PROFILE

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

25: WHERE mmtt.transfer_lpn_id = p_lpn_id
26: AND mmtt.move_order_line_id = mol.line_id
27: AND mol.line_status = inv_globals.g_to_status_cancel_by_source;
28:
29: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
30: BEGIN
31: IF (l_debug = 1) THEN
32: mydebug('In CAN_DROP for LPN = ' || p_lpn_id);
33: END IF;

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

142: SELECT serial_transaction_temp_id
143: FROM mtl_transaction_lots_temp
144: WHERE transaction_temp_id = p_temp_id;
145:
146: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
147: BEGIN
148: IF (l_debug = 1) THEN
149: mydebug(' in unload_task ');
150: END IF;

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

631: PROCEDURE is_task_processed(x_processed OUT NOCOPY VARCHAR2, p_header_id IN NUMBER) IS
632: l_processed VARCHAR2(1) := 'Y';
633: l_err_status NUMBER := NULL;
634: l_process_flag VARCHAR2(1) := NULL;
635: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
636: BEGIN
637: -- If there are more than one row for this putaway tasks' transaction
638: -- header id , returning an error status of M to discontinue work
639: -- flow processing

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

735: -- Increased lot size to 80 Char - Mercy Thomas - B4625329
736: l_lot_number VARCHAR2(80);
737: l_qty NUMBER := NULL;
738: l_already_used VARCHAR2(1) := 'N';
739: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
740: BEGIN
741: IF (l_debug = 1) THEN
742: mydebug('Enter check_qty_avail');
743: END IF;

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

904: mtln_row mtln_type;
905: mut_row mut_type;
906: l_item_id NUMBER;
907: l_org_id NUMBER;
908: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
909:
910: l_lpn_control_flag NUMBER; -- bug 4230494
911: l_item_uom_code VARCHAR2(3); --Bug#5010991
912: l_lpn_ctx NUMBER ; --Bug#5984021

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

1477: SELECT *
1478: FROM mtl_serial_numbers_temp
1479: WHERE transaction_temp_id = txn_tmp_id;
1480:
1481: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
1482: BEGIN
1483: SAVEPOINT generate_next_task;
1484: x_ret_code := fnd_api.g_ret_sts_success;
1485:

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

2317: AND NOT EXISTS ( SELECT 1
2318: FROM mtl_material_transactions_temp t1
2319: WHERE t1.parent_line_id = mmtt.transaction_temp_id);
2320:
2321: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
2322: BEGIN
2323: IF (l_debug = 1) THEN
2324: mydebug('Cancelling the Task: TxnTempID = ' || p_temp_id || ' : EmployeeID = ' || p_emp_id);
2325: END IF;

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

2429: FUNCTION can_unload(p_temp_id IN NUMBER)
2430: RETURN VARCHAR2 IS
2431: l_transfer_lpn_id NUMBER := NULL;
2432: l_multiple_rows VARCHAR2(1) := NULL;
2433: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
2434: BEGIN
2435: IF (l_debug = 1) THEN
2436: mydebug(' In CAN_UNLOAD for transaction_temp_id ' || p_temp_id);
2437: END IF;