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 1478: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

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

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

2302: AND NOT EXISTS ( SELECT 1
2303: FROM mtl_material_transactions_temp t1
2304: WHERE t1.parent_line_id = mmtt.transaction_temp_id);
2305:
2306: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
2307: BEGIN
2308: IF (l_debug = 1) THEN
2309: mydebug('Cancelling the Task: TxnTempID = ' || p_temp_id || ' : EmployeeID = ' || p_emp_id);
2310: END IF;

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

2414: FUNCTION can_unload(p_temp_id IN NUMBER)
2415: RETURN VARCHAR2 IS
2416: l_transfer_lpn_id NUMBER := NULL;
2417: l_multiple_rows VARCHAR2(1) := NULL;
2418: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
2419: BEGIN
2420: IF (l_debug = 1) THEN
2421: mydebug(' In CAN_UNLOAD for transaction_temp_id ' || p_temp_id);
2422: END IF;