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

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

21:
22: --Commonly used variables
23: g_version_printed BOOLEAN := FALSE;
24: g_pkg_name VARCHAR2(30) := 'WMS_PUTAWAY_UTILS';
25: --l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
26:
27: G_DT_CONSOLIDATED_DROP CONSTANT VARCHAR2(2) := 'CD';
28: G_DT_ITEM_DROP CONSTANT VARCHAR2(2) := 'ID';
29: G_DT_USER_DROP CONSTANT VARCHAR2(2) := 'UD';

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

163: p_organization_id IN NUMBER,
164: p_subinventory_code IN VARCHAR2)
165: RETURN NUMBER
166: IS
167: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
168: l_progress VARCHAR2(10) := '10';
169: l_proc_name VARCHAR2(30) := 'Get_Subinventory_Type:';
170: l_sub_type NUMBER := 1;
171: BEGIN

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

235: **/
236: FUNCTION Get_Row_Count (p_mode IN NUMBER)
237: RETURN NUMBER
238: IS
239: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
240: l_progress VARCHAR2(10) := '10';
241: l_proc_name VARCHAR2(30) := 'Get_Row_Count:';
242: l_rec_count NUMBER := 0;
243: BEGIN

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

345: p_del_type IN NUMBER
346: ,p_group_id IN NUMBER )
347: RETURN NUMBER
348: IS
349: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
350: l_progress VARCHAR2(10) := '10';
351: l_proc_name VARCHAR2(30) := 'Remove_Tasks_In_Group:';
352: l_rec_count NUMBER := 0;
353:

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

498: **/
499: FUNCTION Sync_Group_Tasks
500: RETURN NUMBER
501: IS
502: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
503: l_progress VARCHAR2(10) := '10';
504: l_proc_name VARCHAR2(30) := 'Sync_Group_Tasks:';
505: l_rec_count NUMBER := 0;
506:

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

621: ,p_lpn_name IN VARCHAR2 )
622: RETURN NUMBER
623: IS
624:
625: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
626: l_progress VARCHAR2(10) := '10';
627: l_proc_name VARCHAR2(30) := 'Mark_Consolidated_LPN:';
628: l_rec_count NUMBER := 0;
629: l_min_drop_order NUMBER;

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

732: **/
733: FUNCTION Mark_Item_Drop(p_lpn_id IN NUMBER)
734: RETURN NUMBER
735: IS
736: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
737: l_progress VARCHAR2(10) := '10';
738: l_proc_name VARCHAR2(30) := 'Mark_Item_Drop:';
739: l_rec_count NUMBER := 0;
740: l_temp NUMBER := 0;

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

835: ,l_drop_lpn_option_tab IN num_tab
836: ,l_consolidation_method_id_tab IN num_tab )
837: RETURN NUMBER
838: IS
839: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
840: l_progress VARCHAR2(10) := '10';
841: l_proc_name VARCHAR2(30) := 'Insert_Group_Tasks:';
842: l_rec_count NUMBER := 0;
843:

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

1040: **/
1041: FUNCTION Group_Consolidated_Drop_Tasks
1042: RETURN NUMBER
1043: IS
1044: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
1045: l_progress VARCHAR2(10) := '10';
1046: l_proc_name VARCHAR2(30) := 'Group_Consolidated_Drop_Task:';
1047: l_rec_count NUMBER := 0;
1048: l_cur_count NUMBER := 0;

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

1191: **/
1192: FUNCTION Group_Item_Drop_Tasks
1193: RETURN NUMBER
1194: IS
1195: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
1196: l_progress VARCHAR2(10) := '10';
1197: l_proc_name VARCHAR2(30) := 'Group_Item_Drop_Tasks:';
1198: l_rec_count NUMBER := 0;
1199: l_cur_count NUMBER := 0;

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

1607: **/
1608: FUNCTION Populate_Drop_Type
1609: RETURN NUMBER
1610: IS
1611: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
1612: l_progress VARCHAR2(10) := '10';
1613: l_proc_name VARCHAR2(30) := 'Populate_Drop_Type:';
1614: l_rec_count NUMBER := 0;
1615:

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

2439: p_lpn_id IN NUMBER,
2440: p_item_drop_flag IN VARCHAR2)
2441: RETURN NUMBER
2442: IS
2443: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
2444: l_progress VARCHAR2(10) := '10';
2445: l_proc_name VARCHAR2(30) := 'Populate_Group_Tasks:';
2446: l_rec_count NUMBER := 0;
2447:

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

3115: ,p_emp_id IN NUMBER )
3116: RETURN NUMBER
3117: IS
3118:
3119: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
3120: l_progress VARCHAR2(10) := '10';
3121: l_rec_count NUMBER := 0;
3122: l_proc_name VARCHAR2(30) := 'Activate_Plan_For_Load:';
3123:

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

3302: ,p_emp_id IN NUMBER )
3303: RETURN NUMBER
3304: IS
3305:
3306: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
3307: l_progress VARCHAR2(10) := '10';
3308: l_rec_count NUMBER := 0;
3309: l_proc_name VARCHAR2(30) := 'Complete_Plan_For_Load:';
3310:

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

3478: ,p_lpn_id IN NUMBER
3479: ,p_emp_id IN NUMBER )
3480: IS
3481:
3482: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
3483: l_progress VARCHAR2(10) := '10';
3484: l_rec_count NUMBER := 0;
3485: l_proc_name VARCHAR2(30) := 'Complete_ATF_Load:';
3486:

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

3614: x_msg_data OUT NOCOPY VARCHAR2 )
3615:
3616: RETURN NUMBER
3617: IS
3618: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
3619: l_progress VARCHAR2(10) := '10';
3620: l_rec_count NUMBER := 0;
3621: l_proc_name VARCHAR2(30) := 'Activate_Plan_For_Drop:';
3622:

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

3915: ,x_msg_count OUT NOCOPY NUMBER
3916: ,x_msg_data OUT NOCOPY VARCHAR2 )
3917: IS
3918:
3919: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
3920: l_progress VARCHAR2(10) := '10';
3921: l_proc_name VARCHAR2(30) := 'Lock_LPNs:';
3922: l_rec_count NUMBER := 0;
3923:

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

4015: ,p_lpn_id IN NUMBER
4016: ,p_item_drop_flag IN VARCHAR2
4017: ,p_lpn_is_loaded IN VARCHAR2 )
4018: IS
4019: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
4020: l_progress VARCHAR2(10) := '10';
4021: l_proc_name VARCHAR2(30) := 'Create_Grouped_Tasks:';
4022: l_rec_count NUMBER := 0;
4023: l_del_count NUMBER := 0;

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

4570: ,p_org_id IN NUMBER
4571: ,p_lpn_id IN NUMBER
4572: ,p_emp_id IN NUMBER
4573: ) IS
4574: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
4575: l_progress VARCHAR2(10) := '10';
4576: l_rec_count NUMBER := 0;
4577: l_proc_name VARCHAR2(30) := 'ATF_For_Manual_Drop:';
4578:

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

4820: ,p_mo_line_id IN NUMBER )
4821: RETURN NUMBER
4822: IS
4823:
4824: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
4825: l_progress VARCHAR2(10) := '10';
4826: l_rec_count NUMBER := 0;
4827: l_proc_name VARCHAR2(30) := 'Activate_Plan_For_Inspect:';
4828:

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

5056: ,p_parent_lpn_id IN NUMBER
5057: ,p_drop_all IN VARCHAR2 --BUG 5075410
5058: ,p_emp_id IN NUMBER) --BUG 5075410
5059: IS
5060: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
5061: l_progress VARCHAR2(10) := '10';
5062: l_rec_count NUMBER := 0;
5063: l_proc_name VARCHAR2(30) := 'Cleanup_ATF:';
5064:

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

5734: , x_msg_data OUT NOCOPY VARCHAR2
5735: ) IS
5736: l_progress NUMBER;
5737: l_lpn_id NUMBER;
5738: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
5739: l_content_lpn VARCHAR2(1) := 'N';
5740: l_x_ret NUMBER :=0;
5741:
5742: l_x_msg_count NUMBER;

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

6216: l_number_of_rows NUMBER := 0;
6217: l_x_crossdock VARCHAR2(2) := 'Y';
6218: l_progress NUMBER := 10;
6219: l_is_content_lpn VARCHAR2(2) := 'N';
6220: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
6221: l_error_messages VARCHAR2(1200);
6222: l_msg_count NUMBER;
6223: l_msg_data VARCHAR2(1200);
6224: CURSOR lpn_cursor IS

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

6384: , x_msg_data OUT NOCOPY VARCHAR2
6385: ) IS
6386: l_progress NUMBER;
6387: l_txn_temp_id NUMBER;
6388: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
6389: l_ret NUMBER;
6390:
6391: BEGIN
6392: x_return_status := fnd_api.g_ret_sts_success;

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

6496: l_progress NUMBER;
6497: l_lpn_context NUMBER;
6498: l_parent_lpn_id NUMBER;
6499: l_trx_header_id NUMBER;
6500: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
6501: l_x_num_of_rows NUMBER := 0;
6502: l_x_return_status VARCHAR2(2);
6503: l_x_msg_count NUMBER;
6504: l_x_msg_data VARCHAR2(2000);

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

7164: l_lpn_id NUMBER;
7165: l_xfer_lpn_id NUMBER;
7166: l_from_org NUMBER;
7167: l_to_org NUMBER;
7168: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
7169: l_progress VARCHAR(3) := '0';
7170: l_txn_mode_code VARCHAR2(10);
7171: l_error_code NUMBER;
7172:

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

7487: , p_batch_seq IN NUMBER
7488: , p_pack_trans_id IN NUMBER
7489: , x_batch_seq OUT NOCOPY NUMBER --BUG 3544918
7490: ) IS
7491: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
7492: l_group_id NUMBER;
7493: l_progress NUMBER;
7494: l_ret NUMBER;
7495: l_lpn_id NUMBER;

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

7754: , p_pack_trans_id IN NUMBER
7755: , p_batch_id IN NUMBER
7756: , p_batch_seq IN NUMBER
7757: ) IS
7758: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
7759: l_group_id NUMBER;
7760: l_progress NUMBER;
7761: l_ret NUMBER;
7762: l_lpn_id NUMBER;

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

7904: l_to_loc NUMBER;
7905: l_ser_trx_id NUMBER;
7906: l_return_status NUMBER;
7907: l_task_execute_rec wms_dispatched_tasks%ROWTYPE;
7908: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
7909: l_progress VARCHAR2(10) := '0';
7910: l_user_id NUMBER;
7911: l_emp_id NUMBER;
7912: l_error_code NUMBER;

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

9527: l_txn_ret NUMBER := 0; --Return status of the Inventory TM
9528: l_msg_data VARCHAR2(10000);
9529: l_del_count NUMBER; --No. of rows deleted in the temp table
9530: l_business_flow_code NUMBER := 30; -- default to Inventory Putaway
9531: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
9532: l_progress VARCHAR2(10); --Progress indicator
9533: l_proc_name VARCHAR2(30) := 'complete_putaway_wrapper';
9534: l_mos_to_split_tbl split_mo_tb_tp;
9535: l_mo_splt_tb inv_rcv_integration_apis.mo_in_tb_tp;

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

11326: l_lot_count NUMBER;
11327: l_rev_count NUMBER;
11328: l_qty_gtmp NUMBER;
11329: l_qty_wlc NUMBER;
11330: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
11331: l_back_order_delivery_id NUMBER := -999;
11332: l_crossdock_type NUMBER;
11333: l_wip_supply_type NUMBER := -999;
11334: l_sub_validation_passed NUMBER := 1;

Line 12177: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'),

12173: l_wip_supply_type NUMBER := -1;
12174: l_backorder_delivery_ids num_tab;
12175: l_crossdock_types num_tab;
12176: l_wip_supply_types num_tab;
12177: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'),
12178: 0);
12179: l_progress VARCHAR(5) := '0';
12180:
12181: BEGIN

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

12282: l_item_id NUMBER;
12283: l_locator_id NUMBER;
12284: l_quantity NUMBER;
12285: l_uom_code VARCHAR2(3);
12286: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
12287:
12288: CURSOR l_suggestions_cursor IS
12289: --BUG 3435079: Use organization_id MTRL and MMTT
12290: --for performance reason

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

12418: , p_organization_id IN NUMBER
12419: , p_sub IN VARCHAR2
12420: , p_loc IN NUMBER
12421: ) IS
12422: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
12423: l_proc_name VARCHAR2(30) := 'validate_material_status';
12424: BEGIN
12425: IF (l_debug = 1) THEN
12426: DEBUG(' Function Entered at ' ||

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

12482: l_count NUMBER := 1;
12483: l_bo_dd_id NUMBER;
12484: l_return_status VARCHAR2(1);
12485: l_progress NUMBER;
12486: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
12487: l_proc_name VARCHAR2(30) := 'populate_grouping_rows';
12488:
12489: BEGIN
12490:

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

12520: l_count NUMBER;
12521: l_bo_dd_id NUMBER := -1;
12522: l_duplicate NUMBER := 0;
12523: l_progress NUMBER;
12524: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
12525: l_proc_name VARCHAR2(30) := 'get_grouping_count';
12526:
12527: BEGIN
12528:

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

12557:
12558: l_index NUMBER;
12559: i NUMBER;
12560: l_progress NUMBER;
12561: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
12562: l_proc_name VARCHAR2(30) := 'get_grouping';
12563:
12564: BEGIN
12565: IF (l_debug = 1) THEN

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

12610: IS
12611: l_progress NUMBER;
12612: l_lpn_id NUMBER;
12613: l_tempid NUMBER;
12614: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
12615: l_content_lpn VARCHAR2(1) := 'N';
12616: l_lpn_context NUMBER;
12617: l_lpn_has_contents VARCHAR2(1) := 'N';
12618: l_x_msg_count NUMBER;