eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WMS_TASK_LOAD dependencies on FND_PROFILE

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

310: l_mtlt_rec mtl_transaction_lots_temp%ROWTYPE;
311: l_row_exists NUMBER;
312: i NUMBER;
313: j NUMBER;
314: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
315: l_lpn_id NUMBER;
316:
317: TYPE lot_record_type IS RECORD
318: (lot_number mtl_serial_numbers.lot_number%TYPE,

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

1147: ,x_msg_data OUT NOCOPY VARCHAR2)
1148: IS
1149: --PRAGMA AUTONOMOUS_TRANSACTION;
1150: l_proc_name VARCHAR2(30) := 'TASK_MERGE_SPLIT';
1151: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
1152: l_progress VARCHAR2(30) := '100';
1153: l_transaction_temp_id_to_merge NUMBER := NULL;
1154: l_new_transaction_temp_id NUMBER := NULL;
1155: l_insert VARCHAR2(2) := NULL;

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

4303: --PRAGMA AUTONOMOUS_TRANSACTION;
4304:
4305: l_proc_name VARCHAR2(30) := 'PROCESS_F2';
4306: l_progress VARCHAR2(30) := '100';
4307: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
4308: l_new_transaction_temp_id NUMBER := NULL;
4309: l_serial_transaction_temp_id NUMBER := NULL;
4310: l_transaction_temp_id NUMBER := NULL;
4311: l_original_sub_loc VARCHAR2(1) := 'N';

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

5208: ,x_return_status OUT NOCOPY VARCHAR2
5209: ,x_msg_count OUT NOCOPY NUMBER
5210: ,x_msg_data OUT NOCOPY VARCHAR2 )
5211: IS
5212: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
5213: l_proc_name VARCHAR2(30) := 'PROC_DEVICE_CALL';
5214: l_progress VARCHAR2(30) := '100';
5215: l_dev_request_msg VARCHAR2(1000) := NULL;
5216:

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

5323: ,x_return_status OUT NOCOPY VARCHAR2
5324: ,x_msg_count OUT NOCOPY NUMBER
5325: ,x_msg_data OUT NOCOPY VARCHAR2)
5326: IS
5327: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
5328: l_proc_name VARCHAR2(30) := 'PROC_PROCESS_CANCELLED_MOLs';
5329: l_progress VARCHAR2(30) := '100';
5330:
5331: l_deleted_mmtt_qty NUMBER := 0;

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

5805:
5806: IS
5807: l_proc_name VARCHAR2(30) := 'PROC_START_OVER';
5808: l_progress VARCHAR2(30) := '100';
5809: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
5810: l_prev_task_status NUMBER :=0;
5811: l_last_index NUMBER := NULL;
5812: l_first_index NUMBER := NULL;
5813: l_existing_count NUMBER :=0;

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

6228: IS
6229: l_return_status VARCHAR2(1);
6230: l_msg_count NUMBER;
6231: l_msg_data VARCHAR2(4000);
6232: l_debug NUMBER:= NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
6233: l_proc_name VARCHAR2(30) := 'TASK_LOAD';
6234: l_progress VARCHAR2(30) := '100';
6235: l_temp_id NUMBER;
6236: l_business_flow_code NUMBER;

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

7026: from wms_ALLOCATIONS_GTMP
7027: GROUP BY LOT_NUMBER
7028: ORDER BY LOT_NUMBER;
7029:
7030: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
7031:
7032: BEGIN
7033: BEGIN
7034: -- this is done to release a lock on LPN that was picked first and later changed

Line 9912: NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

9908:
9909: -- Increased lot size to 80 Char - Mercy Thomas - B4625329
9910: l_lot_number VARCHAR2(80) := null;
9911: l_debug NUMBER :=
9912: NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
9913: l_table_index NUMBER := 0;
9914: l_pick_to_lpn_id NUMBER;
9915: l_lot_v VARCHAR2(2000) :=null ;
9916: l_is_lot_control VARCHAR2(1);

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

10308:
10309:
10310: FUNCTION can_pickdrop(p_transaction_temp_id IN NUMBER) RETURN VARCHAR2 IS
10311: l_ret VARCHAR2(10) := 'PASS';
10312: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
10313: CURSOR c_cancelled_tasks IS
10314: --SELECT decode(mmtt.transaction_type_id, 35,'N',51,'N','Y')
10315: SELECT 'FAIL'
10316: FROM mtl_material_transactions_temp mmtt, mtl_txn_request_lines mol

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

10356: l_exist NUMBER;
10357: p_lpn_id NUMBER;
10358: l_org_id NUMBER;
10359: l_locator_id NUMBER;
10360: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
10361: honor_case_pick_count NUMBER := 0; --Bug7120019
10362: l_CursorStmt VARCHAR2(32000);
10363: l_CursorID INTEGER;
10364: l_Dummy INTEGER;

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

10612: l_multiple_pick VARCHAR2(1);
10613: l_bulk_task_exist VARCHAR2(1);
10614: -- Increased lot size to 80 Char - Mercy Thomas - B4625329
10615: l_lot_number VARCHAR2(80) := null;
10616: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
10617: --************added for cartonized check******************
10618: l_container_item_id NUMBER;
10619: l_concatenated_segments VARCHAR2(40);
10620: --***

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

11836: ) IS
11837: l_transaction_type_id NUMBER;
11838: l_org_id NUMBER;
11839: l_item_id NUMBER;
11840: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
11841: BEGIN
11842: IF (l_debug = 1) THEN
11843: mydebug('validate_sub_loc_status: validate_sub_loc_status begins');
11844: END IF;

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

11940: l_msg_count NUMBER;
11941: l_success NUMBER := 0;
11942: l_count NUMBER := 0;
11943: l_temp_qty NUMBER :=0 ;
11944: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
11945: BEGIN
11946: x_return_status := fnd_api.g_ret_sts_success;
11947: l_progress := '10';
11948: IF (l_debug = 1) THEN

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

12089: x_return_status OUT NOCOPY VARCHAR2,
12090: p_trx_type_id IN VARCHAR2, -- Bug 4632519
12091: p_trx_action_id IN VARCHAR2) -- Bug 4632519
12092: IS
12093: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
12094: l_cur_cost_group_id NUMBER := NULL;
12095: l_exist_cost_group_id NUMBER := NULL;
12096: l_sub VARCHAR2(20);
12097: l_loc NUMBER;