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_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 168: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

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

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

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

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

345: l_temp_id NUMBER;
346: l_msg_count NUMBER;
347: l_msg_data VARCHAR2(2000);
348: l_return_status VARCHAR2(3);
349: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
350: BEGIN
351: IF (l_debug = 1) THEN
352: debug('Checking if any of the inner LPNs are loaded for picking tasks');
353: END IF;

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

424: p_del_type IN NUMBER
425: ,p_group_id IN NUMBER )
426: RETURN NUMBER
427: IS
428: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
429: l_progress VARCHAR2(10) := '10';
430: l_proc_name VARCHAR2(30) := 'Remove_Tasks_In_Group:';
431: l_rec_count NUMBER := 0;
432:

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

608: , p_lpn_id IN NUMBER
609: , p_group_id IN NUMBER
610: , p_emp_id IN NUMBER)
611: IS
612: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
613: l_progress VARCHAR2(10) := '10';
614: l_proc_name VARCHAR2(30) := 'Update_Tasks_In_Group:';
615: l_rec_count NUMBER := 0;
616: l_task_rec task_rec := NULL;

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

1119: **/
1120: FUNCTION Sync_Group_Tasks
1121: RETURN NUMBER
1122: IS
1123: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
1124: l_progress VARCHAR2(10) := '10';
1125: l_proc_name VARCHAR2(30) := 'Sync_Group_Tasks:';
1126: l_rec_count NUMBER := 0;
1127:

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

1242: ,p_lpn_name IN VARCHAR2 )
1243: RETURN NUMBER
1244: IS
1245:
1246: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
1247: l_progress VARCHAR2(10) := '10';
1248: l_proc_name VARCHAR2(30) := 'Mark_Consolidated_LPN:';
1249: l_rec_count NUMBER := 0;
1250: l_min_drop_order NUMBER;

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

1353: **/
1354: FUNCTION Mark_Item_Drop(p_lpn_id IN NUMBER)
1355: RETURN NUMBER
1356: IS
1357: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
1358: l_progress VARCHAR2(10) := '10';
1359: l_proc_name VARCHAR2(30) := 'Mark_Item_Drop:';
1360: l_rec_count NUMBER := 0;
1361: l_temp NUMBER := 0;

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

1456: ,l_drop_lpn_option_tab IN num_tab
1457: ,l_consolidation_method_id_tab IN num_tab )
1458: RETURN NUMBER
1459: IS
1460: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
1461: l_progress VARCHAR2(10) := '10';
1462: l_proc_name VARCHAR2(30) := 'Insert_Group_Tasks:';
1463: l_rec_count NUMBER := 0;
1464:

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

1661: **/
1662: FUNCTION Group_Consolidated_Drop_Tasks
1663: RETURN NUMBER
1664: IS
1665: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
1666: l_progress VARCHAR2(10) := '10';
1667: l_proc_name VARCHAR2(30) := 'Group_Consolidated_Drop_Task:';
1668: l_rec_count NUMBER := 0;
1669: l_cur_count NUMBER := 0;

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

1812: **/
1813: FUNCTION Group_Item_Drop_Tasks
1814: RETURN NUMBER
1815: IS
1816: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
1817: l_progress VARCHAR2(10) := '10';
1818: l_proc_name VARCHAR2(30) := 'Group_Item_Drop_Tasks:';
1819: l_rec_count NUMBER := 0;
1820: l_cur_count NUMBER := 0;

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

2228: **/
2229: FUNCTION Populate_Drop_Type
2230: RETURN NUMBER
2231: IS
2232: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
2233: l_progress VARCHAR2(10) := '10';
2234: l_proc_name VARCHAR2(30) := 'Populate_Drop_Type:';
2235: l_rec_count NUMBER := 0;
2236:

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

3060: p_lpn_id IN NUMBER,
3061: p_item_drop_flag IN VARCHAR2)
3062: RETURN NUMBER
3063: IS
3064: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
3065: l_progress VARCHAR2(10) := '10';
3066: l_proc_name VARCHAR2(30) := 'Populate_Group_Tasks:';
3067: l_rec_count NUMBER := 0;
3068:

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

3816: ,p_emp_id IN NUMBER )
3817: RETURN NUMBER
3818: IS
3819:
3820: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
3821: l_progress VARCHAR2(10) := '10';
3822: l_rec_count NUMBER := 0;
3823: l_proc_name VARCHAR2(30) := 'Activate_Plan_For_Load:';
3824:

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

4005: ,p_emp_id IN NUMBER )
4006: RETURN NUMBER
4007: IS
4008:
4009: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
4010: l_progress VARCHAR2(10) := '10';
4011: l_rec_count NUMBER := 0;
4012: l_proc_name VARCHAR2(30) := 'Complete_Plan_For_Load:';
4013:

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

4183: ,p_lpn_id IN NUMBER
4184: ,p_emp_id IN NUMBER )
4185: IS
4186:
4187: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
4188: l_progress VARCHAR2(10) := '10';
4189: l_rec_count NUMBER := 0;
4190: l_proc_name VARCHAR2(30) := 'Complete_ATF_Load:';
4191:

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

4319: x_msg_data OUT NOCOPY VARCHAR2 )
4320:
4321: RETURN NUMBER
4322: IS
4323: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
4324: l_progress VARCHAR2(10) := '10';
4325: l_rec_count NUMBER := 0;
4326: l_proc_name VARCHAR2(30) := 'Activate_Plan_For_Drop:';
4327:

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

4620: ,x_msg_count OUT NOCOPY NUMBER
4621: ,x_msg_data OUT NOCOPY VARCHAR2 )
4622: IS
4623:
4624: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
4625: l_progress VARCHAR2(10) := '10';
4626: l_proc_name VARCHAR2(30) := 'Lock_LPNs:';
4627: l_rec_count NUMBER := 0;
4628:

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

4720: ,p_lpn_id IN NUMBER
4721: ,p_item_drop_flag IN VARCHAR2
4722: ,p_lpn_is_loaded IN VARCHAR2 )
4723: IS
4724: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
4725: l_progress VARCHAR2(10) := '10';
4726: l_proc_name VARCHAR2(30) := 'Create_Grouped_Tasks:';
4727: l_rec_count NUMBER := 0;
4728: l_del_count NUMBER := 0;

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

5275: ,p_org_id IN NUMBER
5276: ,p_lpn_id IN NUMBER
5277: ,p_emp_id IN NUMBER
5278: ) IS
5279: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
5280: l_progress VARCHAR2(10) := '10';
5281: l_rec_count NUMBER := 0;
5282: l_proc_name VARCHAR2(30) := 'ATF_For_Manual_Drop:';
5283:

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

5525: ,p_mo_line_id IN NUMBER )
5526: RETURN NUMBER
5527: IS
5528:
5529: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
5530: l_progress VARCHAR2(10) := '10';
5531: l_rec_count NUMBER := 0;
5532: l_proc_name VARCHAR2(30) := 'Activate_Plan_For_Inspect:';
5533:

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

5761: ,p_parent_lpn_id IN NUMBER
5762: ,p_drop_all IN VARCHAR2 --BUG 5075410
5763: ,p_emp_id IN NUMBER) --BUG 5075410
5764: IS
5765: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
5766: l_progress VARCHAR2(10) := '10';
5767: l_rec_count NUMBER := 0;
5768: l_proc_name VARCHAR2(30) := 'Cleanup_ATF:';
5769:

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

6463: , x_msg_data OUT NOCOPY VARCHAR2
6464: ) IS
6465: l_progress NUMBER;
6466: l_lpn_id NUMBER;
6467: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
6468: l_content_lpn VARCHAR2(1) := 'N';
6469: l_x_ret NUMBER :=0;
6470:
6471: l_x_msg_count NUMBER;

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

7043: l_number_of_rows NUMBER := 0;
7044: l_x_crossdock VARCHAR2(2) := 'Y';
7045: l_progress NUMBER := 10;
7046: l_is_content_lpn VARCHAR2(2) := 'N';
7047: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
7048: l_error_messages VARCHAR2(1200);
7049: l_msg_count NUMBER;
7050: l_msg_data VARCHAR2(1200);
7051: l_wlc_without_mmtt NUMBER := 0; --BUG12681832

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

7246: , x_msg_data OUT NOCOPY VARCHAR2
7247: ) IS
7248: l_progress NUMBER;
7249: l_txn_temp_id NUMBER;
7250: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
7251: l_ret NUMBER;
7252:
7253: BEGIN
7254: x_return_status := fnd_api.g_ret_sts_success;

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

7358: l_progress NUMBER;
7359: l_lpn_context NUMBER;
7360: l_parent_lpn_id NUMBER;
7361: l_trx_header_id NUMBER;
7362: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
7363: l_x_num_of_rows NUMBER := 0;
7364: l_x_return_status VARCHAR2(2);
7365: l_x_msg_count NUMBER;
7366: l_x_msg_data VARCHAR2(2000);

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

8026: l_lpn_id NUMBER;
8027: l_xfer_lpn_id NUMBER;
8028: l_from_org NUMBER;
8029: l_to_org NUMBER;
8030: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
8031: l_progress VARCHAR(3) := '0';
8032: l_txn_mode_code VARCHAR2(10);
8033: l_error_code NUMBER;
8034:

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

8349: , p_batch_seq IN NUMBER
8350: , p_pack_trans_id IN NUMBER
8351: , x_batch_seq OUT NOCOPY NUMBER --BUG 3544918
8352: ) IS
8353: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
8354: l_group_id NUMBER;
8355: l_progress NUMBER;
8356: l_ret NUMBER;
8357: l_lpn_id NUMBER;

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

8616: , p_pack_trans_id IN NUMBER
8617: , p_batch_id IN NUMBER
8618: , p_batch_seq IN NUMBER
8619: ) IS
8620: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
8621: l_group_id NUMBER;
8622: l_progress NUMBER;
8623: l_ret NUMBER;
8624: l_lpn_id NUMBER;

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

8766: l_to_loc NUMBER;
8767: l_ser_trx_id NUMBER;
8768: l_return_status NUMBER;
8769: l_task_execute_rec wms_dispatched_tasks%ROWTYPE;
8770: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
8771: l_progress VARCHAR2(10) := '0';
8772: l_user_id NUMBER;
8773: l_emp_id NUMBER;
8774: l_error_code NUMBER;

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

10400: l_txn_ret NUMBER := 0; --Return status of the Inventory TM
10401: l_msg_data VARCHAR2(10000);
10402: l_del_count NUMBER; --No. of rows deleted in the temp table
10403: l_business_flow_code NUMBER := 30; -- default to Inventory Putaway
10404: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
10405: l_progress VARCHAR2(10); --Progress indicator
10406: l_proc_name VARCHAR2(30) := 'complete_putaway_wrapper';
10407: l_mos_to_split_tbl split_mo_tb_tp;
10408: l_mo_splt_tb inv_rcv_integration_apis.mo_in_tb_tp;

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

12297: l_lot_count NUMBER;
12298: l_rev_count NUMBER;
12299: l_qty_gtmp NUMBER;
12300: l_qty_wlc NUMBER;
12301: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
12302: l_back_order_delivery_id NUMBER := -999;
12303: l_crossdock_type NUMBER;
12304: l_wip_supply_type NUMBER := -999;
12305: l_sub_validation_passed NUMBER := 1;

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

13292: l_tempid_tab num_tab;
13293: l_return_status VARCHAR2(10);
13294: l_user_id NUMBER;
13295: l_cal_api BOOLEAN;
13296: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'),0);
13297:
13298:
13299:
13300:

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

14246: l_wip_supply_type NUMBER := -1;
14247: l_backorder_delivery_ids num_tab;
14248: l_crossdock_types num_tab;
14249: l_wip_supply_types num_tab;
14250: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'),
14251: 0);
14252: l_progress VARCHAR(5) := '0';
14253:
14254: BEGIN

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

14355: l_item_id NUMBER;
14356: l_locator_id NUMBER;
14357: l_quantity NUMBER;
14358: l_uom_code VARCHAR2(3);
14359: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
14360:
14361: CURSOR l_suggestions_cursor IS
14362: --BUG 3435079: Use organization_id MTRL and MMTT
14363: --for performance reason

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

14491: , p_organization_id IN NUMBER
14492: , p_sub IN VARCHAR2
14493: , p_loc IN NUMBER
14494: ) IS
14495: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
14496: l_proc_name VARCHAR2(30) := 'validate_material_status';
14497: BEGIN
14498: IF (l_debug = 1) THEN
14499: DEBUG(' Function Entered at ' ||

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

14557: l_count_non_so NUMBER := 0;
14558: l_bo_dd_id NUMBER := 0 ;
14559: l_return_status VARCHAR2(1);
14560: l_progress NUMBER;
14561: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
14562: l_proc_name VARCHAR2(30) := 'populate_grouping_rows';
14563: l_xdock_type NUMBER; --Bug#6968476
14564: l_non_so_lines WSH_UTIL_CORE.id_tab_type; --9505772-This table will hold non-so lines
14565: BEGIN

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

14640: l_count NUMBER;
14641: l_bo_dd_id NUMBER := -1;
14642: l_duplicate NUMBER := 0;
14643: l_progress NUMBER;
14644: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
14645: l_proc_name VARCHAR2(30) := 'get_grouping_count';
14646: l_line_rows WSH_UTIL_CORE.id_tab_type;
14647: l_temp NUMBER;
14648:

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

14690:
14691: l_index NUMBER;
14692: i NUMBER;
14693: l_progress NUMBER;
14694: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
14695: l_proc_name VARCHAR2(30) := 'get_grouping';
14696:
14697: BEGIN
14698: IF (l_debug = 1) THEN

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

14743: IS
14744: l_progress NUMBER;
14745: l_lpn_id NUMBER;
14746: l_tempid NUMBER;
14747: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
14748: l_content_lpn VARCHAR2(1) := 'N';
14749: l_lpn_context NUMBER;
14750: l_lpn_has_contents VARCHAR2(1) := 'N';
14751: l_x_msg_count NUMBER;