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_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.28.12020000.3 2013/01/31 12:14:24 blavu 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: g_xfer_to_lpn_id NUMBER := NULL; --Added for bug 10139672
10: --This variable is used to store the "To LPN" value and assigned in procedure validate_xfer_to_lpn and it will be used in
11: --pick_drop procedure

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

70:
71: PROCEDURE clear_lpn_cache
72: ( x_return_status OUT NOCOPY VARCHAR2
73: ) IS
74: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
75: BEGIN
76: x_return_status := fnd_api.g_ret_sts_success;
77:
78: g_current_drop_lpn.current_drop_list.DELETE;

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

104: , p_temp_id IN NUMBER
105: ) IS
106:
107: l_api_name VARCHAR2(30) := 'get_drop_type';
108: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
109:
110: CURSOR c_txn_info
111: ( p_txn_tmp_id IN NUMBER
112: ) IS

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

253: , p_temp_id IN NUMBER
254: ) IS
255:
256: l_api_name VARCHAR2(30) := 'get_delivery_id';
257: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
258:
259: l_delivery_id NUMBER := NULL;
260:
261: CURSOR c_get_deliv_id

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

335: ) IS
336:
337: PRAGMA AUTONOMOUS_TRANSACTION;
338:
339: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
340: l_api_name VARCHAR2(30) := 'gen_lock_handle';
341:
342: l_lock_name VARCHAR2(128);
343: l_lock_handle VARCHAR2(128);

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

402: , p_org_id IN NUMBER
403: , p_xfer_lpn_id IN NUMBER
404: ) IS
405:
406: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
407: l_api_name VARCHAR2(30) := 'lock_lpn';
408:
409: l_lock_handle VARCHAR2(128);
410: l_api_return_status VARCHAR2(1);

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

482: , p_txn_temp_id IN NUMBER
483: ) IS
484:
485: l_api_name VARCHAR2(30) := 'get_group_info';
486: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
487: l_api_return_status VARCHAR2(1);
488:
489: l_parent_temp_id NUMBER;
490: l_task_type NUMBER;

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

640: , p_organization_id IN NUMBER
641: , p_transfer_lpn_id IN NUMBER
642: ) IS
643:
644: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
645: l_api_name VARCHAR2(30) := 'insert_wdt';
646:
647: l_api_return_status VARCHAR2(1);
648:

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

789: , p_suggestion_drop IN VARCHAR2 -- Added for bug 12853197
790: ) IS
791:
792: l_api_name VARCHAR2(30) := 'chk_if_deconsolidate';
793: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
794:
795: l_drop_count NUMBER := 0;
796: l_drop_lpn_option NUMBER;
797:

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

1586: ( p_drop_type IN VARCHAR2
1587: , x_return_status OUT NOCOPY VARCHAR2
1588: ) IS
1589:
1590: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1591: l_api_name VARCHAR2(30) := 'group_drop_details';
1592:
1593: ii NUMBER := 0;
1594: jj NUMBER := 0;

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

2610: , p_temp_id IN NUMBER
2611: ) IS
2612:
2613: l_api_name VARCHAR2(30) := 'split_mmtt';
2614: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2615:
2616: l_new_temp_id NUMBER;
2617:
2618: BEGIN

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

3115: , p_status IN VARCHAR2 DEFAULT NULL
3116: ) IS
3117:
3118: l_api_name VARCHAR2(30) := 'get_temp_list';
3119: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3120:
3121: ii NUMBER;
3122: l_transaction_temp_id NUMBER;
3123:

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

3245: ( x_return_status OUT NOCOPY VARCHAR2
3246: ) IS
3247:
3248: l_api_name VARCHAR2(30) := 'split_lots';
3249: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3250: l_api_return_status VARCHAR2(1);
3251:
3252: l_temp_tbl g_temp_id_tbl;
3253: l_transaction_temp_id NUMBER;

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

3494: , p_transfer_lpn_id IN NUMBER
3495: ) IS
3496:
3497: l_api_name VARCHAR2(30) := 'fetch_next_drop';
3498: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3499:
3500: l_msg_count NUMBER;
3501: l_msg_data VARCHAR2(2000);
3502: l_api_return_status VARCHAR2(1);

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

4240: , p_transfer_lpn_id IN NUMBER
4241: ) IS
4242:
4243: l_api_name VARCHAR2(30) := 'get_wip_job_info';
4244: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
4245:
4246: l_msg_count NUMBER;
4247: l_msg_data VARCHAR2(2000);
4248: l_api_return_status VARCHAR2(1);

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

4401: x_transfer_lpn_id OUT nocopy NUMBER,
4402: x_transfer_lpn OUT nocopy VARCHAR2) IS
4403:
4404: l_api_name VARCHAR2(30) := 'get_sub_xfer_dest_info';
4405: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
4406:
4407: l_msg_count NUMBER;
4408: l_msg_data VARCHAR2(2000);
4409:

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

4514: , p_to_loc IN NUMBER
4515: ) IS
4516:
4517: l_api_name VARCHAR2(30) := 'get_default_drop_lpn';
4518: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
4519:
4520: l_lpn_id NUMBER;
4521: l_lpn_num VARCHAR2(30) := NULL;
4522:

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

4611: , p_lot_num IN VARCHAR2
4612: ) IS
4613:
4614: l_api_name VARCHAR2(30) := 'get_lot_lov';
4615: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
4616:
4617: l_dum_lpn VARCHAR2(31) := '@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@';
4618:
4619: BEGIN

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

4679: , p_serial IN VARCHAR2
4680: ) IS
4681:
4682: l_api_name VARCHAR2(30) := 'get_serial_lov';
4683: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
4684:
4685: l_dum_lpn VARCHAR2(31) := '@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@';
4686:
4687: BEGIN

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

4726: , p_txn_header_id IN NUMBER
4727: ) IS
4728:
4729: l_api_name VARCHAR2(30) := 'insert_child_msnt';
4730: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
4731:
4732: l_dummy VARCHAR2(1) := NULL;
4733: l_lot_controlled BOOLEAN;
4734: l_srl_qty NUMBER;

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

5049: , p_serial_control IN VARCHAR2
5050: ) IS
5051:
5052: l_api_name VARCHAR2(30) := 'process_inner_lpn';
5053: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
5054: l_api_return_status VARCHAR2(1);
5055:
5056: l_temp_tbl g_temp_id_tbl;
5057:

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

5617: , p_primary_uom IN VARCHAR2
5618: ) IS
5619:
5620: l_api_name VARCHAR2(30) := 'process_loose_qty';
5621: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
5622: l_api_return_status VARCHAR2(1);
5623:
5624: l_available_qty NUMBER;
5625:

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

6248: , p_group_number IN NUMBER
6249: ) IS
6250:
6251: l_api_name VARCHAR2(30) := 'process_serial';
6252: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
6253:
6254: l_api_return_status VARCHAR2(1);
6255: l_msg_count NUMBER;
6256: l_msg_data VARCHAR2(2000);

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

7426: , p_transfer_lpn_id IN NUMBER
7427: ) IS
7428:
7429: l_api_name VARCHAR2(30) := 'cancel_task';
7430: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
7431:
7432: l_api_return_status VARCHAR2(1);
7433:
7434: CURSOR c_get_temp_ids

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

7630: , p_delivery_id IN NUMBER
7631: ) IS
7632:
7633: l_api_name VARCHAR2(30) := 'validate_xfer_to_lpn';
7634: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
7635:
7636: l_api_return_status VARCHAR2(1);
7637: l_msg_count NUMBER;
7638: l_msg_data VARCHAR2(2000);

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

8313: , p_outer_lpn_id IN NUMBER
8314: ) IS
8315:
8316: l_api_name VARCHAR2(30) := 'insert_mmtt_pack';
8317: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
8318:
8319: l_msg_count NUMBER;
8320: l_msg_data VARCHAR2(2000);
8321:

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

8805: , p_drop_lpn IN VARCHAR2
8806: ) IS
8807:
8808: l_api_name VARCHAR2(30) := 'preprocess_bulk_drop';
8809: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
8810:
8811: l_api_return_status VARCHAR2(1);
8812: l_msg_count NUMBER;
8813: l_msg_data VARCHAR2(2000);

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

9176: , p_bulk_drop IN VARCHAR2
9177: ) IS
9178:
9179: l_api_name VARCHAR2(30) := 'pick_drop';
9180: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
9181:
9182: l_api_return_status VARCHAR2(1);
9183: l_msg_count NUMBER;
9184: l_msg_data VARCHAR2(2000);

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

10361: , p_transfer_lpn_id IN NUMBER
10362: ) IS
10363:
10364: l_api_name VARCHAR2(30) := 'create_temp_id_list';
10365: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
10366:
10367: l_temp_tbl g_temp_id_tbl;
10368:
10369: l_api_return_status VARCHAR2(1);

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

10504: , p_delivery_id IN NUMBER
10505: ) IS
10506:
10507: l_api_name VARCHAR2(30) := 'get_delivery_info';
10508: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
10509:
10510: l_delivery_name VARCHAR2(30);
10511: l_order_number NUMBER;
10512: l_count NUMBER;

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

10607: , p_conf_item IN VARCHAR2
10608: ) IS
10609:
10610: l_api_name VARCHAR2(30) := 'process_conf_item';
10611: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
10612:
10613: l_count NUMBER;
10614: l_item_segs VARCHAR2(1000);
10615:

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

10741: , p_delivery_id IN NUMBER
10742: ) IS
10743:
10744: l_api_name VARCHAR2(30) := 'validate_pick_drop_lpn';
10745: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
10746:
10747: l_api_return_status VARCHAR2(1);
10748: l_msg_count NUMBER;
10749: l_msg_data VARCHAR2(2000);