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.

[Home] [Help]

APPS.WMS_TASK_LOAD dependencies on FND_PROFILE

Line 26: g_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0); --13860546 selecting from profile earlier hard coded to 1

22: -- Increased lot size to 80 Char - Mercy Thomas - B4625329
23: l_g_action_load_multiple CONSTANT VARCHAR2(80):= 'LOAD_MULTIPLE';
24: l_g_isLotSubstitutionOK NUMBER := 2; -- 1 = yes and 2 = no /* Bug 9448490 Lot Substitution Project */
25:
26: g_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0); --13860546 selecting from profile earlier hard coded to 1
27:
28: --/* Bug 9448490 Lot Substitution Project */ start
29: PROCEDURE proc_decrement_allocated_mtlts
30: (p_temp_id IN NUMBER

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

375: l_mtlt_rec mtl_transaction_lots_temp%ROWTYPE;
376: l_row_exists NUMBER;
377: i NUMBER;
378: j NUMBER;
379: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
380: l_lpn_id NUMBER;
381:
382: TYPE lot_record_type IS RECORD
383: (lot_number mtl_serial_numbers.lot_number%TYPE,

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

1220: ,p_fulfillment_base IN VARCHAR2 DEFAULT 'P') --16070349
1221: IS
1222: --PRAGMA AUTONOMOUS_TRANSACTION;
1223: l_proc_name VARCHAR2(30) := 'TASK_MERGE_SPLIT';
1224: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
1225: l_progress VARCHAR2(30) := '100';
1226: l_transaction_temp_id_to_merge NUMBER := NULL;
1227: l_new_transaction_temp_id NUMBER := NULL;
1228: l_insert VARCHAR2(2) := NULL;

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

5417: --PRAGMA AUTONOMOUS_TRANSACTION;
5418:
5419: l_proc_name VARCHAR2(30) := 'PROCESS_F2';
5420: l_progress VARCHAR2(30) := '100';
5421: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
5422: l_new_transaction_temp_id NUMBER := NULL;
5423: l_serial_transaction_temp_id NUMBER := NULL;
5424: l_transaction_temp_id NUMBER := NULL;
5425: l_original_sub_loc VARCHAR2(1) := 'N';

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

6445: ,x_return_status OUT NOCOPY VARCHAR2
6446: ,x_msg_count OUT NOCOPY NUMBER
6447: ,x_msg_data OUT NOCOPY VARCHAR2 )
6448: IS
6449: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
6450: l_proc_name VARCHAR2(30) := 'PROC_DEVICE_CALL';
6451: l_progress VARCHAR2(30) := '100';
6452: l_dev_request_msg VARCHAR2(1000) := NULL;
6453:

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

6560: ,x_return_status OUT NOCOPY VARCHAR2
6561: ,x_msg_count OUT NOCOPY NUMBER
6562: ,x_msg_data OUT NOCOPY VARCHAR2)
6563: IS
6564: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
6565: l_proc_name VARCHAR2(30) := 'PROC_PROCESS_CANCELLED_MOLs';
6566: l_progress VARCHAR2(30) := '100';
6567:
6568: l_deleted_mmtt_qty NUMBER := 0;

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

7047:
7048: IS
7049: l_proc_name VARCHAR2(30) := 'PROC_START_OVER';
7050: l_progress VARCHAR2(30) := '100';
7051: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
7052: l_prev_task_status NUMBER :=0;
7053: l_last_index NUMBER := NULL;
7054: l_first_index NUMBER := NULL;
7055: l_existing_count NUMBER :=0;

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

7495: IS
7496: l_return_status VARCHAR2(1);
7497: l_msg_count NUMBER;
7498: l_msg_data VARCHAR2(4000);
7499: l_debug NUMBER:= NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
7500: l_proc_name VARCHAR2(30) := 'TASK_LOAD';
7501: l_progress VARCHAR2(30) := '100';
7502: l_temp_id NUMBER;
7503: l_business_flow_code NUMBER;

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

8475: ORDER BY lot_number;
8476:
8477: --/* Bug 9448490 Lot Substitution Project */ end
8478:
8479: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
8480:
8481: BEGIN
8482: mydebug('changeLotNoException is - ' || p_changelotNoException); --/* Bug 9448490 Lot Substitution Project */
8483: --HWSNIssue 13860546

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

12043: l_satt NUMBER; -- Bug #4141928
12044:
12045: -- Increased lot size to 80 Char - Mercy Thomas - B4625329
12046: l_lot_number VARCHAR2(80) := NULL;
12047: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
12048: l_table_index NUMBER := 0;
12049: l_pick_to_lpn_id NUMBER;
12050: l_lot_v VARCHAR2(32767) :=NULL ;-- 14003388 changing 2000 to 32767
12051: l_is_lot_control VARCHAR2(1);

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

12598:
12599:
12600: FUNCTION can_pickdrop(p_transaction_temp_id IN NUMBER) RETURN VARCHAR2 IS
12601: l_ret VARCHAR2(10) := 'PASS';
12602: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
12603: CURSOR c_cancelled_tasks IS
12604: --SELECT decode(mmtt.transaction_type_id, 35,'N',51,'N','Y')
12605: SELECT 'FAIL'
12606: FROM mtl_material_transactions_temp mmtt, mtl_txn_request_lines mol

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

12646: l_exist NUMBER;
12647: p_lpn_id NUMBER;
12648: l_org_id NUMBER;
12649: l_locator_id NUMBER;
12650: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
12651: honor_case_pick_count NUMBER := 0; --Bug7120019
12652: l_CursorStmt VARCHAR2(32000);
12653: l_CursorID INTEGER;
12654: l_Dummy INTEGER;

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

12906: l_multiple_pick VARCHAR2(1);
12907: l_bulk_task_exist VARCHAR2(1);
12908: -- Increased lot size to 80 Char - Mercy Thomas - B4625329
12909: l_lot_number VARCHAR2(80) := null;
12910: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
12911: --************added for cartonized check******************
12912: l_container_item_id NUMBER;
12913: l_concatenated_segments VARCHAR2(40);
12914: --***

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

14143: ) IS
14144: l_transaction_type_id NUMBER;
14145: l_org_id NUMBER;
14146: l_item_id NUMBER;
14147: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
14148: BEGIN
14149: IF (l_debug = 1) THEN
14150: mydebug('validate_sub_loc_status: validate_sub_loc_status begins');
14151: END IF;

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

14247: l_msg_count NUMBER;
14248: l_success NUMBER := 0;
14249: l_count NUMBER := 0;
14250: l_temp_qty NUMBER :=0 ;
14251: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
14252: BEGIN
14253: x_return_status := fnd_api.g_ret_sts_success;
14254: l_progress := '10';
14255: IF (l_debug = 1) THEN

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

14404: x_return_status OUT NOCOPY VARCHAR2,
14405: p_trx_type_id IN VARCHAR2, -- Bug 4632519
14406: p_trx_action_id IN VARCHAR2) -- Bug 4632519
14407: IS
14408: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
14409: l_cur_cost_group_id NUMBER := NULL;
14410: l_exist_cost_group_id NUMBER := NULL;
14411: l_sub VARCHAR2(20);
14412: l_loc NUMBER;

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

14895: )
14896: AND lot_number IS NOT NULL
14897: GROUP BY lot_number
14898: ORDER BY lot_number;
14899: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
14900:
14901: BEGIN
14902: x_return_status := fnd_api.g_ret_sts_success;
14903: t_lpn_lot_qty_table.DELETE;

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

15498:
15499: l_serial_cnt NUMBER := 0;
15500: l_serial_temp_id NUMBER;
15501: l_ser_return_status VARCHAR2 (1);
15502: l_debug NUMBER := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);
15503: l_ser_msg VARCHAR2 (240);
15504: BEGIN
15505: x_return_status := l_g_ret_sts_success;
15506: mydebug ('In insert_serials_temp');

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

15789: b_is_revision_control BOOLEAN;
15790: b_is_serial_control BOOLEAN := FALSE;
15791:
15792:
15793: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
15794:
15795: BEGIN
15796: x_return_status := fnd_api.g_ret_sts_success;
15797: t_lpn_lot_qty_table.DELETE;