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

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

3:
4: g_pkg_body_ver CONSTANT VARCHAR2(100) := '$Header: WMSPKDPB.pls 120.18.12010000.4 2008/12/01 10:22:22 kjujjuru ship $';
5: g_newline CONSTANT VARCHAR2(10) := fnd_global.newline;
6:
7: g_gtin_cross_ref_type VARCHAR2(25) := fnd_profile.value('INV:GTIN_CROSS_REFERENCE_TYPE');
8:
9: --
10: -- These tables type store the current list of temp IDs
11: -- for a drop LPN, and the groups they belong to

Line 64: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

60:
61: PROCEDURE clear_lpn_cache
62: ( x_return_status OUT NOCOPY VARCHAR2
63: ) IS
64: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
65: BEGIN
66: x_return_status := fnd_api.g_ret_sts_success;
67:
68: g_current_drop_lpn.current_drop_list.DELETE;

Line 98: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

94: , p_temp_id IN NUMBER
95: ) IS
96:
97: l_api_name VARCHAR2(30) := 'get_drop_type';
98: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
99:
100: CURSOR c_txn_info
101: ( p_txn_tmp_id IN NUMBER
102: ) IS

Line 247: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

243: , p_temp_id IN NUMBER
244: ) IS
245:
246: l_api_name VARCHAR2(30) := 'get_delivery_id';
247: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
248:
249: l_delivery_id NUMBER := NULL;
250:
251: CURSOR c_get_deliv_id

Line 329: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

325: ) IS
326:
327: PRAGMA AUTONOMOUS_TRANSACTION;
328:
329: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
330: l_api_name VARCHAR2(30) := 'gen_lock_handle';
331:
332: l_lock_name VARCHAR2(128);
333: l_lock_handle VARCHAR2(128);

Line 396: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

392: , p_org_id IN NUMBER
393: , p_xfer_lpn_id IN NUMBER
394: ) IS
395:
396: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
397: l_api_name VARCHAR2(30) := 'lock_lpn';
398:
399: l_lock_handle VARCHAR2(128);
400: l_api_return_status VARCHAR2(1);

Line 476: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

472: , p_txn_temp_id IN NUMBER
473: ) IS
474:
475: l_api_name VARCHAR2(30) := 'get_group_info';
476: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
477: l_api_return_status VARCHAR2(1);
478:
479: l_parent_temp_id NUMBER;
480: l_task_type NUMBER;

Line 634: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

630: , p_organization_id IN NUMBER
631: , p_transfer_lpn_id IN NUMBER
632: ) IS
633:
634: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
635: l_api_name VARCHAR2(30) := 'insert_wdt';
636:
637: l_api_return_status VARCHAR2(1);
638:

Line 782: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

778: , p_transfer_lpn_id IN NUMBER
779: ) IS
780:
781: l_api_name VARCHAR2(30) := 'chk_if_deconsolidate';
782: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
783:
784: l_drop_count NUMBER := 0;
785: l_drop_lpn_option NUMBER;
786:

Line 1449: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

1445: ( p_drop_type IN VARCHAR2
1446: , x_return_status OUT NOCOPY VARCHAR2
1447: ) IS
1448:
1449: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1450: l_api_name VARCHAR2(30) := 'group_drop_details';
1451:
1452: ii NUMBER := 0;
1453: jj NUMBER := 0;

Line 2471: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

2467: , p_temp_id IN NUMBER
2468: ) IS
2469:
2470: l_api_name VARCHAR2(30) := 'split_mmtt';
2471: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2472:
2473: l_new_temp_id NUMBER;
2474:
2475: BEGIN

Line 2976: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

2972: , p_status IN VARCHAR2 DEFAULT NULL
2973: ) IS
2974:
2975: l_api_name VARCHAR2(30) := 'get_temp_list';
2976: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2977:
2978: ii NUMBER;
2979: l_transaction_temp_id NUMBER;
2980:

Line 3069: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

3065: ( x_return_status OUT NOCOPY VARCHAR2
3066: ) IS
3067:
3068: l_api_name VARCHAR2(30) := 'split_lots';
3069: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3070: l_api_return_status VARCHAR2(1);
3071:
3072: l_temp_tbl g_temp_id_tbl;
3073: l_transaction_temp_id NUMBER;

Line 3317: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

3313: , p_transfer_lpn_id IN NUMBER
3314: ) IS
3315:
3316: l_api_name VARCHAR2(30) := 'fetch_next_drop';
3317: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3318:
3319: l_msg_count NUMBER;
3320: l_msg_data VARCHAR2(2000);
3321: l_api_return_status VARCHAR2(1);

Line 3966: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

3962: , p_transfer_lpn_id IN NUMBER
3963: ) IS
3964:
3965: l_api_name VARCHAR2(30) := 'get_wip_job_info';
3966: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3967:
3968: l_msg_count NUMBER;
3969: l_msg_data VARCHAR2(2000);
3970: l_api_return_status VARCHAR2(1);

Line 4127: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

4123: x_transfer_lpn_id OUT nocopy NUMBER,
4124: x_transfer_lpn OUT nocopy VARCHAR2) IS
4125:
4126: l_api_name VARCHAR2(30) := 'get_sub_xfer_dest_info';
4127: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
4128:
4129: l_msg_count NUMBER;
4130: l_msg_data VARCHAR2(2000);
4131:

Line 4240: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

4236: , p_to_loc IN NUMBER
4237: ) IS
4238:
4239: l_api_name VARCHAR2(30) := 'get_default_drop_lpn';
4240: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
4241:
4242: l_lpn_id NUMBER;
4243: l_lpn_num VARCHAR2(30) := NULL;
4244:

Line 4337: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

4333: , p_lot_num IN VARCHAR2
4334: ) IS
4335:
4336: l_api_name VARCHAR2(30) := 'get_lot_lov';
4337: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
4338:
4339: l_dum_lpn VARCHAR2(31) := '@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@';
4340:
4341: BEGIN

Line 4405: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

4401: , p_serial IN VARCHAR2
4402: ) IS
4403:
4404: l_api_name VARCHAR2(30) := 'get_serial_lov';
4405: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
4406:
4407: l_dum_lpn VARCHAR2(31) := '@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@';
4408:
4409: BEGIN

Line 4452: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

4448: , p_txn_header_id IN NUMBER
4449: ) IS
4450:
4451: l_api_name VARCHAR2(30) := 'insert_child_msnt';
4452: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
4453:
4454: l_dummy VARCHAR2(1) := NULL;
4455: l_lot_controlled BOOLEAN;
4456: l_srl_qty NUMBER;

Line 4775: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

4771: , p_serial_control IN VARCHAR2
4772: ) IS
4773:
4774: l_api_name VARCHAR2(30) := 'process_inner_lpn';
4775: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
4776: l_api_return_status VARCHAR2(1);
4777:
4778: l_temp_tbl g_temp_id_tbl;
4779:

Line 5343: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

5339: , p_primary_uom IN VARCHAR2
5340: ) IS
5341:
5342: l_api_name VARCHAR2(30) := 'process_loose_qty';
5343: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
5344: l_api_return_status VARCHAR2(1);
5345:
5346: l_available_qty NUMBER;
5347:

Line 5974: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

5970: , p_group_number IN NUMBER
5971: ) IS
5972:
5973: l_api_name VARCHAR2(30) := 'process_serial';
5974: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
5975:
5976: l_api_return_status VARCHAR2(1);
5977: l_msg_count NUMBER;
5978: l_msg_data VARCHAR2(2000);

Line 7152: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

7148: , p_transfer_lpn_id IN NUMBER
7149: ) IS
7150:
7151: l_api_name VARCHAR2(30) := 'cancel_task';
7152: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
7153:
7154: l_api_return_status VARCHAR2(1);
7155:
7156: CURSOR c_get_temp_ids

Line 7356: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

7352: , p_delivery_id IN NUMBER
7353: ) IS
7354:
7355: l_api_name VARCHAR2(30) := 'validate_xfer_to_lpn';
7356: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
7357:
7358: l_api_return_status VARCHAR2(1);
7359: l_msg_count NUMBER;
7360: l_msg_data VARCHAR2(2000);

Line 8023: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

8019: , p_outer_lpn_id IN NUMBER
8020: ) IS
8021:
8022: l_api_name VARCHAR2(30) := 'insert_mmtt_pack';
8023: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
8024:
8025: l_msg_count NUMBER;
8026: l_msg_data VARCHAR2(2000);
8027:

Line 8515: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

8511: , p_drop_lpn IN VARCHAR2
8512: ) IS
8513:
8514: l_api_name VARCHAR2(30) := 'preprocess_bulk_drop';
8515: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
8516:
8517: l_api_return_status VARCHAR2(1);
8518: l_msg_count NUMBER;
8519: l_msg_data VARCHAR2(2000);

Line 8886: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

8882: , p_bulk_drop IN VARCHAR2
8883: ) IS
8884:
8885: l_api_name VARCHAR2(30) := 'pick_drop';
8886: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
8887:
8888: l_api_return_status VARCHAR2(1);
8889: l_msg_count NUMBER;
8890: l_msg_data VARCHAR2(2000);

Line 10042: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

10038: , p_transfer_lpn_id IN NUMBER
10039: ) IS
10040:
10041: l_api_name VARCHAR2(30) := 'create_temp_id_list';
10042: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
10043:
10044: l_temp_tbl g_temp_id_tbl;
10045:
10046: l_api_return_status VARCHAR2(1);

Line 10185: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

10181: , p_delivery_id IN NUMBER
10182: ) IS
10183:
10184: l_api_name VARCHAR2(30) := 'get_delivery_info';
10185: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
10186:
10187: l_delivery_name VARCHAR2(30);
10188: l_order_number NUMBER;
10189: l_count NUMBER;

Line 10288: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

10284: , p_conf_item IN VARCHAR2
10285: ) IS
10286:
10287: l_api_name VARCHAR2(30) := 'process_conf_item';
10288: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
10289:
10290: l_count NUMBER;
10291: l_item_segs VARCHAR2(1000);
10292:

Line 10422: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

10418: , p_delivery_id IN NUMBER
10419: ) IS
10420:
10421: l_api_name VARCHAR2(30) := 'validate_pick_drop_lpn';
10422: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
10423:
10424: l_api_return_status VARCHAR2(1);
10425: l_msg_count NUMBER;
10426: l_msg_data VARCHAR2(2000);