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

Line 4: g_trace_on NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 2);

1: PACKAGE BODY wms_picking_pkg AS
2: /* $Header: WMSPLPDB.pls 120.37.12010000.2 2008/08/19 20:36:13 zhzhwang ship $ */
3:
4: g_trace_on NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 2);
5: g_group_sequence_number NUMBER := 1;
6: g_max_group_sequence_number NUMBER := -1; -- Bug#5185031
7: g_period_id NUMBER;
8:

Line 10: g_gtin_cross_ref_type VARCHAR2(25) := fnd_profile.value('INV:GTIN_CROSS_REFERENCE_TYPE');

6: g_max_group_sequence_number NUMBER := -1; -- Bug#5185031
7: g_period_id NUMBER;
8:
9: --for UCC128, same as in WMSUCCSB.pls
10: g_gtin_cross_ref_type VARCHAR2(25) := fnd_profile.value('INV:GTIN_CROSS_REFERENCE_TYPE');
11: g_gtin_code_length NUMBER := 14;
12:
13: g_cartonization_ids numset_tabType; --Bug: 7254397 Store LPNs for ClusterPickByLabel
14: g_cartonization_ids_inx NUMBER := 0; --Bug: 7254397

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

13: g_cartonization_ids numset_tabType; --Bug: 7254397 Store LPNs for ClusterPickByLabel
14: g_cartonization_ids_inx NUMBER := 0; --Bug: 7254397
15:
16: PROCEDURE mydebug(p_msg IN VARCHAR2, p_api_name IN VARCHAR2) IS
17: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
18: BEGIN
19: IF g_trace_on = 1 THEN
20: inv_mobile_helper_functions.tracelog( p_err_msg => p_msg
21: , p_module => 'WMS_PICKING_PKG.' || p_api_name

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

30: x_msg_count OUT nocopy NUMBER,
31: x_msg_data OUT nocopy VARCHAR2)
32: IS
33: l_api_name VARCHAR2(30) := 'insert_cartonization_id';
34: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
35: BEGIN
36: IF (l_debug = 1) THEN
37: mydebug('Enter:', l_api_name);
38: mydebug('p_lpn_id: ' || TO_CHAR(p_lpn_id), l_api_name);

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

51: -- Bug: 7254397
52: FUNCTION list_cartonization_id RETURN numset_t PIPELINED
53: IS
54: l_api_name VARCHAR2(30) := 'list_cartonization_id';
55: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
56: l_count NUMBER;
57: BEGIN
58: IF (l_debug = 1) THEN
59: mydebug('Enter:', l_api_name);

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

76: x_msg_count OUT nocopy NUMBER,
77: x_msg_data OUT nocopy VARCHAR2)
78: IS
79: l_api_name VARCHAR2(30) := 'clear_cartonization_id';
80: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
81: BEGIN
82: IF (l_debug = 1) THEN
83: mydebug('Enter:', l_api_name);
84: END IF;

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

100:
101:
102: PROCEDURE change_task_to_active(p_transaction_temp_id IN NUMBER, x_return_status OUT NOCOPY VARCHAR2) IS
103: --PRAGMA AUTONOMOUS_TRANSACTION;
104: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
105: BEGIN
106: x_return_status := fnd_api.g_ret_sts_success;
107:
108: UPDATE wms_dispatched_tasks

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

193: l_sql VARCHAR2(20000);
194: l_task_cur t_genref;
195: b_is_cluster_pick BOOLEAN := FALSE;
196: l_cartons_list VARCHAR2(4000) := ' (-999) ';
197: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
198:
199: l_same_lot_rec_cnt NUMBER;
200: l_same_lot_pri_qty NUMBER;
201: l_same_lot_tra_qty NUMBER;

Line 958: l_check_overpick_passed := NVL(fnd_profile.VALUE('WSH_OVERPICK_ENABLED'), 'N');

954: END IF;
955:
956: ELSIF (l_move_order_type = inv_globals.g_move_order_pick_wave) THEN
957:
958: l_check_overpick_passed := NVL(fnd_profile.VALUE('WSH_OVERPICK_ENABLED'), 'N');
959:
960: IF l_debug = 1 THEN
961: mydebug('OVPK: l_check_overpick_passed for PickWave MO = '||l_check_overpick_passed, l_api_name);
962: END IF;

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

1295: FROM mtl_material_transactions_temp t2
1296: WHERE t2.parent_line_id = t1.transaction_temp_id
1297: AND t2.organization_id = t1.organization_id
1298: );
1299: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1300: BEGIN
1301: x_return_status := fnd_api.g_ret_sts_success;
1302: -- For each transaction returned by the cursor update the Child Records and delete the Parent.
1303: FOR v_rec IN c_get_bulk_txn(p_organization_id, p_transfer_lpn_id) LOOP

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

1386: mfg_orig_drop_rec c_get_mfg_drop_details%ROWTYPE;
1387:
1388: b_multiple_drops BOOLEAN := FALSE;
1389:
1390: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1391: BEGIN
1392: -- This API just update transfer_locator of each MMTT record for
1393: -- passed transfer_lpn_id. In case it fails, MMTT will not be updated
1394: -- and pick drop will continue.

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

1857: l_mmtt_rowcnt NUMBER;
1858: l_wdt_rowcnt NUMBER;
1859: l_undispatched_picks NUMBER;
1860: l_equipment_serial WMS_DISPATCHED_TASKS.EQUIPMENT_INSTANCE%TYPE;
1861: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
1862: l_status NUMBER ; --Bug#5157839.
1863:
1864: /*6009436 Begin */
1865: CURSOR c_fm_to_serial_number IS

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

2473: AND wtf.task_filter_id = wtfd.task_filter_id;
2474:
2475: l_task_status NUMBER; -- bug 4310093
2476:
2477: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
2478: l_api_name VARCHAR2(30) := 'WMS_PICKING_PKG.NEXT_TASK';
2479: --
2480: -- Bug 4722574
2481: --

Line 2557: l_ignore_equipment := NVL(fnd_profile.VALUE('WMS_IGNORE_EQUIPMENT'), 1);

2553: END IF;
2554: --
2555: -- Start Bug 4722574
2556: --
2557: l_ignore_equipment := NVL(fnd_profile.VALUE('WMS_IGNORE_EQUIPMENT'), 1);
2558: IF l_ignore_equipment = 2 THEN
2559: l_equipment_serial := 'NONE';
2560: END IF;
2561: --

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

3482: qty_tbl wms_Task_mgmt_pub.TASK_QTY_TBL_TYPE;
3483: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
3484: l_resultant_task_details wms_Task_mgmt_pub.TASK_DETAIL_TBL_TYPE;
3485: l_resultant_tasks wms_Task_mgmt_pub.TASK_TAB_TYPE;
3486: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
3487:
3488: BEGIN
3489:
3490: mydebug('inside split_mmtt_lpn p_transaction_temp_id' || p_transaction_temp_id, 'split_mmtt_lpn');

Line 3598: g_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

3594: l_invalid_quantities EXCEPTION;
3595: l_unexpected_error EXCEPTION;
3596: l_query_task_exception EXCEPTION;
3597:
3598: g_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
3599: BEGIN
3600: IF g_debug = 1 THEN
3601: mydebug( 'In Split Task ', 'split_task');
3602: END IF;

Line 3909: g_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

3905: l_sum_tbl_transaction_qty NUMBER := 0;
3906: l_sum_tbl_primary_qty NUMBER := 0;
3907: l_remaining_primary_qty NUMBER := 0;
3908: l_remaining_transaction_qty NUMBER := 0;
3909: g_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
3910: BEGIN
3911: x_return_status := 'E';
3912: IF g_debug = 1 THEN
3913: mydebug( 'Entered','validate_quantities');

Line 4189: g_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

4185: x_msg_data OUT NOCOPY VARCHAR2 ,
4186: x_msg_count OUT NOCOPY VARCHAR2 ) IS
4187:
4188: l_sysdate DATE := SYSDATE;
4189: g_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
4190: BEGIN
4191: x_return_status := 'E';
4192: IF g_debug = 1 THEN
4193: mydebug( ' Entered ', 'split_mmtt');

Line 4698: g_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

4694: x_msg_data OUT NOCOPY VARCHAR2 ,
4695: x_msg_count OUT NOCOPY VARCHAR2 ) IS
4696:
4697: l_sysdate DATE := SYSDATE;
4698: g_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
4699: BEGIN
4700: x_return_status := 'E';
4701: IF g_debug = 1 THEN
4702: mydebug( ' Entered ','SPLIT_WDT');

Line 4850: g_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

4846: l_lot_control_code NUMBER;
4847: l_serial_control_code NUMBER;
4848: x_lot_return_status VARCHAR2(1);
4849:
4850: g_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
4851: BEGIN
4852: x_return_status := 'E';
4853: IF g_debug = 1 THEN
4854: mydebug( 'Entered.', 'SPLIT_LOT_SERIAL');

Line 4953: g_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

4949: ORDER BY fm_serial_number;
4950:
4951: l_transaction_remaining_qty NUMBER;
4952: l_primary_remaining_qty NUMBER;
4953: g_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
4954: BEGIN
4955: x_return_status := 'E';
4956: l_transaction_remaining_qty := p_transaction_qty_to_split;
4957: l_primary_remaining_qty := p_primary_qty_to_split;