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_DISPATCH_GEN dependencies on FND_PROFILE

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

54: , x_msg_data OUT NOCOPY VARCHAR2
55: , p_from_cost_group_id IN NUMBER
56: , p_transfer_org_id IN NUMBER
57: ) IS
58: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
59: BEGIN
60: wms_task_dispatch_put_away.create_mo(
61: p_org_id => p_org_id
62: , p_inventory_item_id => p_inventory_item_id

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

119: l_per_res_id NUMBER;
120: l_mac_res_id NUMBER;
121: l_return_status VARCHAR2(1);
122: l_task_id NUMBER;
123: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
124: BEGIN
125: l_return_status := fnd_api.g_ret_sts_success;
126: l_org_id := p_org_id;
127: l_temp_id := p_temp_id;

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

277: AND wdat.device_id = wdb.device_id
278: ORDER BY wdat.assignment_temp_id;
279:
280: l_txn_hdr_id NUMBER;
281: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
282: BEGIN
283: IF (l_debug = 1) THEN
284: mydebug('In next task:');
285: END IF;

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

1048: AND wdat.device_id = wdb.device_id
1049: ORDER BY wdat.assignment_temp_id;
1050:
1051: l_txn_hdr_id NUMBER;
1052: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
1053: BEGIN
1054: IF (l_debug = 1) THEN
1055: mydebug('In next task:');
1056: END IF;

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

1577: , mtlt.transaction_quantity
1578: FROM mtl_transaction_lots_temp mtlt
1579: WHERE mtlt.transaction_temp_id = p_temp_id;
1580:
1581: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
1582: BEGIN
1583: l_return_status := fnd_api.g_ret_sts_success;
1584: l_lpn := p_lpn;
1585: l_loc := p_loc;

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

1959: FUNCTION get_primary_quantity(p_item_id IN NUMBER, p_organization_id IN NUMBER, p_from_quantity IN NUMBER, p_from_unit IN VARCHAR2)
1960: RETURN NUMBER IS
1961: l_primary_uom VARCHAR2(3);
1962: l_primary_quantity NUMBER;
1963: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
1964: BEGIN
1965: SELECT primary_uom_code
1966: INTO l_primary_uom
1967: FROM mtl_system_items

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

2011: l_user_id NUMBER;
2012: l_ser_seq NUMBER;
2013: l_cnt NUMBER;
2014: l_lot_ser_seq NUMBER := 0;
2015: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
2016:
2017: l_from_ser_number NUMBER;
2018: l_to_ser_number NUMBER;
2019: l_temp_prefix VARCHAR2(30);

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

2582: FUNCTION get_lpn_lot_qty(p_lot_number IN VARCHAR2)
2583: RETURN NUMBER IS
2584: l_lpn_qty NUMBER := -1;
2585: i NUMBER;
2586: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
2587: BEGIN
2588: FOR i IN 1 .. t_lpn_lot_qty_table.COUNT LOOP
2589: IF (t_lpn_lot_qty_table(i).lot_number = p_lot_number) THEN
2590: l_lpn_qty := t_lpn_lot_qty_table(i).qty;

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

2732: , mtlt.lot_number
2733: FROM mtl_transaction_lots_temp mtlt
2734: WHERE mtlt.transaction_temp_id = p_temp_id;
2735:
2736: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
2737: BEGIN
2738: IF (l_debug = 1) THEN
2739: mydebug('lpn_match: In lpn Match');
2740: END IF;

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

5054: END lpn_match;
5055:
5056: FUNCTION can_pickdrop(txn_temp_id IN NUMBER) RETURN VARCHAR2 IS
5057: l_ret VARCHAR2(1) := 'X';
5058: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
5059: CURSOR c_cancelled_tasks IS
5060: SELECT decode(mmtt.transaction_type_id, 35,'N',51,'N','Y')
5061: FROM mtl_material_transactions_temp mmtt, mtl_txn_request_lines mol
5062: WHERE (mmtt.transaction_temp_id = txn_temp_id OR mmtt.parent_line_id = txn_temp_id)

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

5189: l_mol_uom VARCHAR2(3);
5190: l_mol_delta_qty NUMBER;
5191: l_primary_qty NUMBER;
5192: --l_detailed_quantity NUMBER;
5193: l_debug NUMBER :=NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'),0);
5194: l_bulk_pick_flag NUMBER := 0;
5195: BEGIN
5196: l_return_status := fnd_api.g_ret_sts_success;
5197: x_return_status := l_return_status;

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

6102: l_return_status VARCHAR2(1);
6103: l_rows NUMBER;
6104: l_loc NUMBER;
6105: l_sub VARCHAR2(10);
6106: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
6107: BEGIN
6108: l_return_status := fnd_api.g_ret_sts_success;
6109: l_temp_id := p_temp_id;
6110: l_lpn_id := p_lpn_id;

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

6652: l_msg_data VARCHAR2(2000);
6653: l_exist_contents NUMBER;
6654: b_can_modify BOOLEAN;
6655: l_sug_lpn_id NUMBER;
6656: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
6657: BEGIN
6658: IF (l_debug = 1) THEN
6659: mydebug('In change lpn');
6660: END IF;

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

6890: l_content_lpn_id NUMBER;
6891: l_to_lpn_id NUMBER;
6892: l_test_qty NUMBER;
6893: l_content_parent_lpn_id NUMBER;
6894: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
6895: l_lpn_sub VARCHAR2(30); --Added bug3765153
6896: l_lpn_loc NUMBER; --Added bug3765153
6897: BEGIN
6898: SAVEPOINT sp_multiple_lpn_pick;

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

7951: l_item_id NUMBER;
7952: l_operation_plan_id NUMBER;
7953: l_current_carton_grouping_id NUMBER := -999;
7954: l_carton_grouping_id NUMBER := -999;
7955: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
7956: l_line_rows WSH_UTIL_CORE.id_tab_type; --Bug#4440585
7957: l_grouping_rows WSH_UTIL_CORE.id_tab_type; --Bug#4440585
7958: l_same_carton_grouping BOOLEAN := FALSE; --Bug#4440585
7959: l_return_status VARCHAR2(2) ;

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

8887: l_content_parent_lpn_id NUMBER;
8888: l_progress VARCHAR2(4);
8889: l_lpn_exact_match VARCHAR2(1) := 'N';
8890: l_lpn_id NUMBER;
8891: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
8892: l_serial_prefix NUMBER;
8893: l_real_serial_prefix VARCHAR2(30);
8894: l_serial_numeric_frm NUMBER;
8895: l_serial_numeric_to NUMBER;

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

10506: l_return_status VARCHAR2(1);
10507: l_msg_count NUMBER;
10508: l_msg_data VARCHAR2(4000);
10509: l_exist NUMBER;
10510: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
10511: BEGIN
10512: l_exist := 0;
10513: l_return_status := fnd_api.g_ret_sts_success;
10514:

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

10686: START WITH lpn_id = l_xfrlpnid
10687: CONNECT BY PRIOR lpn_id = parent_lpn_id;
10688:
10689: -- End of changes for 5222498
10690: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
10691:
10692: --==================================================
10693: --R12.1 Replenishment Project (6681109) Starts
10694:

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

12454: l_mmtt_rowcnt NUMBER;
12455: l_wdt_rowcnt NUMBER;
12456: l_undispatched_picks NUMBER;
12457: l_txn_hdr_id NUMBER;
12458: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
12459: BEGIN
12460: IF (l_debug = 1) THEN
12461: mydebug('pick_by_label: In Pick By Label API');
12462: END IF;

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

12802: l_mmtt_rowcnt NUMBER;
12803: l_wdt_rowcnt NUMBER;
12804: l_undispatched_picks NUMBER;
12805: l_txn_hdr_id NUMBER;
12806: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
12807:
12808: /*6009436 Begin */
12809: CURSOR c_fm_to_serial_number IS
12810: SELECT

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

13161: l_org_id NUMBER;
13162: l_mmtt_rowcnt NUMBER;
13163: l_wdt_rowcnt NUMBER;
13164: l_undispatched_picks NUMBER;
13165: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
13166: BEGIN
13167: IF (l_debug = 1) THEN
13168: mydebug('check_carton: In check carton API');
13169: END IF;

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

13244: l_msg_data VARCHAR2(4000);
13245: l_exist NUMBER;
13246: p_lpn_id NUMBER;
13247: l_org_id NUMBER;
13248: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
13249: BEGIN
13250: IF (l_debug = 1) THEN
13251: mydebug('check_pack_lpn: check_pack_lpn begins');
13252: END IF;

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

13362:
13363: PROCEDURE mydebug(msg IN VARCHAR2) IS
13364: l_msg VARCHAR2(5100);
13365: l_ts VARCHAR2(30);
13366: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
13367: BEGIN
13368: -- select to_char(sysdate,'MM/DD/YYYY HH:MM:SS') INTO l_ts from dual;
13369: -- l_msg:=l_ts||' '||msg;
13370:

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

13387: , x_is_reservable_sub OUT NOCOPY BOOLEAN
13388: ) IS
13389: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
13390: l_reservable_type NUMBER;
13391: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
13392: BEGIN
13393: SELECT reservable_type
13394: INTO l_reservable_type
13395: FROM mtl_secondary_inventories

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

13517: l_mol_src_id NUMBER;
13518: l_mol_src_line_id NUMBER;
13519: l_mol_reference_id NUMBER;
13520: l_mol_status NUMBER;--bug3139307
13521: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
13522: l_wf NUMBER;
13523: l_mmtt_transaction_uom VARCHAR2(3);
13524: l_mtrl_uom VARCHAR2(3);
13525: l_primary_quantity NUMBER;

Line 13526: l_kill_mo_profile NUMBER := NVL(FND_PROFILE.VALUE_WNPS('INV_KILL_MOVE_ORDER'),2);

13522: l_wf NUMBER;
13523: l_mmtt_transaction_uom VARCHAR2(3);
13524: l_mtrl_uom VARCHAR2(3);
13525: l_primary_quantity NUMBER;
13526: l_kill_mo_profile NUMBER := NVL(FND_PROFILE.VALUE_WNPS('INV_KILL_MOVE_ORDER'),2);
13527: l_return_status VARCHAR2(1);
13528:
13529: CURSOR c_mmtt_info IS
13530: SELECT mmtt.transaction_header_id

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

13928: , p_locator_id IN NUMBER
13929: , p_txn_temp_id IN NUMBER
13930: ) IS
13931: l_negative_rcpt_code NUMBER;
13932: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
13933: BEGIN
13934: SELECT negative_inv_receipt_code
13935: INTO l_negative_rcpt_code
13936: FROM mtl_parameters

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

14080: ) IS
14081: l_transaction_type_id NUMBER;
14082: l_org_id NUMBER;
14083: l_item_id NUMBER;
14084: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
14085: BEGIN
14086: IF (l_debug = 1) THEN
14087: mydebug('validate_sub_loc_status: validate_sub_loc_status begins');
14088: END IF;

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

14172: l_lpn_controlled_flag NUMBER;
14173: l_count NUMBER := 0;
14174: l_orig_xfr_sub VARCHAR2(30);
14175: l_mmtt_mo_type NUMBER := NULL;
14176: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
14177: l_wms_task_type NUMBER;
14178: BEGIN
14179: IF (l_debug = 1) THEN
14180: mydebug('validate_pick_drop_sub: validate_pick_drop_sub begins ');

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

14289:
14290: PROCEDURE create_lock_mmtt_temp_id(lock_name IN VARCHAR2, x_return_status OUT NOCOPY VARCHAR2) IS
14291: l_lock_id VARCHAR2(50);
14292: lock_result NUMBER;
14293: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
14294: BEGIN
14295: IF (l_debug = 1) THEN
14296: mydebug('Inside create_lock_mmtt_temp_id');
14297: END IF;

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

14394: l_parent_sub_code VARCHAR2(30);
14395: l_parent_loc_id NUMBER;
14396: l_lpn_id NUMBER;
14397: l_transfer_lpn_id NUMBER;
14398: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
14399: l_new_temp_id NUMBER; --Added bug3765153
14400: BEGIN
14401: x_return_status := fnd_api.g_ret_sts_success;
14402:

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

15107: p_revision_control IN NUMBER,
15108: x_commingle_exist OUT nocopy VARCHAR2,
15109: x_return_status OUT nocopy VARCHAR2)
15110: IS
15111: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
15112: l_cur_cost_group_id NUMBER := NULL;
15113: l_exist_cost_group_id NUMBER := NULL;
15114: l_sub VARCHAR2(20);
15115: l_loc NUMBER;

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

15301: AND wdd.organization_id = p_organization_id ;
15302:
15303: l_delivery_match_flag NUMBER;
15304:
15305: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
15306: BEGIN
15307:
15308: IF (l_debug = 1) THEN
15309: mydebug ('Start Validate_Pick_Drop_Lpn.');

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

15567:
15568: delivery_id_rec pick_delivery_cursor%ROWTYPE;
15569: license_plate_rec drop_delivery_cursor%ROWTYPE;
15570:
15571: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
15572: BEGIN
15573:
15574:
15575: IF NOT fnd_api.compatible_api_call (l_api_version_number