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.INV_LOC_WMS_UTILS dependencies on FND_PROFILE

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

6:
7: -- to turn off debugger, comment out the line 'dbms_output.put_line(msg);'
8: PROCEDURE mdebug(msg in varchar2)
9: IS
10: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
11: BEGIN
12: -- dbms_output.put_line(msg);
13: INV_TRX_UTIL_PUB.TRACE(msg,'INV_LOC_WMS_UTILS ',9);
14: END;

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

39: IS
40: l_physical_locator_id NUMBER;
41: l_locator_id NUMBER;
42: l_inventory_location_id NUMBER;
43: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
44: BEGIN
45:
46: -- Initialize API return status to success
47: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

185: IS
186: l_physical_locator_id NUMBER;
187: l_locator_id NUMBER;
188: l_inventory_location_id NUMBER;
189: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
190: BEGIN
191:
192: -- Initialize API return status to success
193: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

289: IS
290: l_physical_locator_id NUMBER;
291: l_locator_id NUMBER;
292: l_inventory_location_id NUMBER;
293: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
294: BEGIN
295:
296: -- Initialize API return status to success
297: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

396: IS
397: l_physical_locator_id NUMBER;
398: l_locator_id NUMBER;
399: l_inventory_location_id NUMBER;
400: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
401: BEGIN
402:
403: -- Initialize API return status to success
404: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

553:
554: l_physical_locator_id NUMBER;
555: l_locator_id NUMBER;
556: l_inventory_location_id NUMBER;
557: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
558: BEGIN
559: IF (l_debug = 1) THEN
560: mdebug('In update_loc_curr_capacity_nauto');
561: END IF;

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

1003: l_return_status varchar2(1);
1004: l_msg_count number;
1005: l_msg_data varchar2(1000);
1006:
1007: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1008: BEGIN
1009:
1010: -- Initialize API return status to success
1011: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1096:
1097: l_return_status varchar2(1);
1098: l_msg_count number;
1099: l_msg_data varchar2(1000);
1100: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1101: BEGIN
1102:
1103: -- Initialize API return status to success
1104: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1230: l_physical_locator_id NUMBER;
1231: l_locator_id NUMBER;
1232: l_inventory_location_id NUMBER;
1233:
1234: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1235: BEGIN
1236: IF (l_debug = 1) THEN
1237: mdebug('In update_loc_sugg_capacity_nauto');
1238: END IF;

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

1597:
1598: l_return_status varchar2(1);
1599: l_msg_count number;
1600: l_msg_data varchar2(1000);
1601: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1602: BEGIN
1603:
1604: -- Initialize API return status to success
1605: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1762: resource_busy_detected EXCEPTION;
1763:
1764: PRAGMA EXCEPTION_INIT(resource_busy_detected, -54);
1765:
1766: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1767: BEGIN
1768: -- Initialize API return status to success
1769: x_return_status := FND_API.G_RET_STS_SUCCESS;
1770:

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

2622: AND mmtt.transaction_action_id IN (l_txn_action_subxfer , l_txn_action_orgxfer, l_txn_action_stgxfer );
2623:
2624: l_commit_count number := 0;
2625:
2626: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2627: BEGIN
2628: -- Initialize API return status to success
2629: x_return_status := FND_API.G_RET_STS_SUCCESS;
2630: SAVEPOINT locators_capacity_cleanup;

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

3420: l_msg_count number;
3421: l_msg_data varchar2(1000);
3422: l_conc_status BOOLEAN;
3423: l_mixed_items_flag varchar2(1);
3424: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3425: BEGIN
3426:
3427: IF (p_organization_id is null) THEN
3428: fnd_message.set_name('INV', 'INV_ORG_REQUIRED');

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

3495:
3496: l_msg_count NUMBER;
3497: l_msg_data VARCHAR2(2000);
3498:
3499: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3500: BEGIN
3501:
3502: fnd_msg_pub.count_and_get(
3503: p_count => l_msg_count,

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

3534: )
3535: IS
3536: l_loc_id NUMBER;
3537: l_physical_locator_id NUMBER;
3538: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3539: BEGIN
3540: /*---------------------------------------------------------------------------------------------
3541: Check if the locator has a physical_location_id then use the physical_location_id for further
3542: processing.Else we have to use the inventory_location_id for further processing

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

3580: l_locator_maximum_units NUMBER;
3581: l_locator_current_units NUMBER;
3582: l_locator_available_units NUMBER;
3583: l_locator_suggested_units NUMBER;
3584: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3585: l_proc_name VARCHAR2(20) := 'FETCH_LOCATOR: ';
3586: BEGIN
3587: /*---------------------------------------------------------------------------------------------
3588: Fetch the locator's current capacity.

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

3727: , p_organization_id IN NUMBER
3728: , p_container_item IN VARCHAR2
3729: )
3730: IS
3731: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3732: l_proc_name VARCHAR2(50) := 'FETCH_ITEM_ATTRIBUTES: ';
3733: BEGIN
3734: x_return_status := FND_API.G_RET_STS_SUCCESS;
3735: item_attributes(

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

3788: l_lpn_container_item_weight NUMBER;
3789: l_lpn_container_item_vol NUMBER;
3790: l_lpn_exists_in_locator VARCHAR2(1);
3791: l_proc_name VARCHAR2(50) := 'FETCH_LPN_ATTR: ';
3792: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3793: BEGIN
3794: x_return_status := FND_API.G_RET_STS_SUCCESS;
3795: IF (l_debug = 1) THEN
3796: mdebug(l_proc_name||'Fetching of LPN attibutes ');

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

3969: l_trn_gross_weight_uom_code VARCHAR2(3);
3970: l_trn_content_volume_uom_code VARCHAR2(3);
3971: l_trn_lpn_exists_in_locator VARCHAR2(1);
3972: l_proc_name VARCHAR2(50) := 'FETCH_TRANSFER_LPN_ATTR: ';
3973: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3974: BEGIN
3975: x_return_status := FND_API.G_RET_STS_SUCCESS;
3976: IF (l_debug = 1) THEN
3977: mdebug(l_proc_name||'Fetching of Transfer LPN attibutes ');

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

4154: l_cnt_content_volume_uom_code VARCHAR2(3);
4155: l_cnt_lpn_exists_in_locator VARCHAR2(1);
4156: l_quantity NUMBER := 0;
4157: l_proc_name VARCHAR2(50) := 'FETCH_CONTENT_LPN_ATTR: ';
4158: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
4159: BEGIN
4160: x_return_status := FND_API.G_RET_STS_SUCCESS;
4161: IF (l_debug = 1) THEN
4162: mdebug(l_proc_name||'Fetching attributes of the Content lpn: '||to_char(p_lpn_id));

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

4335: l_locator_current_weight NUMBER := 0;
4336: l_locator_available_weight NUMBER;
4337: l_locator_current_units NUMBER := 0;
4338: l_locator_available_units NUMBER;
4339: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
4340: BEGIN
4341: x_return_status := FND_API.G_RET_STS_SUCCESS;
4342:
4343: IF (l_debug = 1) THEN

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

4446: l_locator_current_weight NUMBER := 0;
4447: l_locator_available_weight NUMBER;
4448: l_locator_current_units NUMBER := 0;
4449: l_locator_available_units NUMBER;
4450: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
4451: BEGIN
4452: x_return_status := FND_API.G_RET_STS_SUCCESS;
4453:
4454: IF (l_debug = 1) THEN

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

4585: l_update_table BOOLEAN := TRUE;
4586: l_content_lpn_quantity NUMBER;
4587:
4588: l_proc_name VARCHAR2(50) := 'UPD_LPN_LOC_CPTY_FOR_XFR:';
4589: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
4590: BEGIN
4591: x_return_status := FND_API.G_RET_STS_SUCCESS;
4592:
4593: /*--------------------------------------------------------------------------------------------

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

5055: l_locator_current_cubic_area NUMBER := 0;
5056: l_locator_available_cubic_area NUMBER;
5057: l_locator_current_weight NUMBER := 0;
5058: l_locator_available_weight NUMBER;
5059: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
5060: l_content_qty NUMBER;
5061: l_lpn_qty NUMBER;
5062: l_content_lpn_vol NUMBER;
5063: BEGIN

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

5181: l_locator_current_cubic_area NUMBER;
5182: l_locator_available_cubic_area NUMBER;
5183: l_locator_current_weight NUMBER;
5184: l_locator_available_weight NUMBER;
5185: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
5186: l_container_item_weight NUMBER;
5187: l_container_item_vol NUMBER;
5188: l_content_volume NUMBER;
5189: l_lpn_exists_in_locator VARCHAR2(1);

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

5377: l_max_cubic_area NUMBER;
5378:
5379:
5380: /* Debug Check */
5381: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
5382: l_proc_name VARCHAR2(50) := 'UPD_LPN_LOC_CURR_CPTY_NOAUTO:';
5383: BEGIN
5384:
5385: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

5870: PRAGMA autonomous_transaction;
5871: l_return_status VARCHAR2(1);
5872: l_msg_count NUMBER;
5873: l_msg_data VARCHAR2(1000);
5874: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
5875: BEGIN
5876: x_return_status := FND_API.G_RET_STS_SUCCESS;
5877: INV_LOC_WMS_UTILS.upd_lpn_loc_curr_cpty_nauto
5878: ( x_return_status =>l_return_status,

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

5949: IS
5950: l_return_status varchar2(10);
5951: l_msg_data varchar2(1000);
5952: l_msg_count number;
5953: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
5954: BEGIN
5955: x_return_status := fnd_api.g_ret_sts_success;
5956:
5957: savepoint lpn_loc_cleanup;

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

6074: l_cnt_lpn_content_volume NUMBER;
6075: l_xacted_volume NUMBER;
6076: l_trn_xacted_volume NUMBER;
6077: l_trn_lpn_exists_in_loc VARCHAR2(1);
6078: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
6079: l_proc_name VARCHAR2(40) := 'CAL_LOCATOR_CURRENT_VOL: ';
6080: BEGIN
6081: l_locator_current_volume :=p_locator_current_cubic_area;
6082: l_trn_lpn_container_item_vol :=p_trn_lpn_container_item_vol;

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

6296: l_container_item_xacted_volume NUMBER;
6297:
6298: l_msg_data VARCHAR2(1000);
6299: l_msg_count NUMBER;
6300: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
6301: BEGIN
6302: x_return_status := FND_API.G_RET_STS_SUCCESS;
6303: BEGIN
6304:

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

6517: l_item_xacted_weight NUMBER;
6518: l_item_xacted_volume NUMBER;
6519: l_quantity NUMBER;
6520:
6521: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
6522: BEGIN
6523: x_return_status := FND_API.G_RET_STS_SUCCESS;
6524:
6525: SELECT primary_uom_code

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

6774:
6775: l_return_status varchar2(1);
6776: l_msg_data varchar2(1000);
6777: l_msg_count number;
6778: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
6779: BEGIN
6780: x_return_status := fnd_api.g_ret_sts_success ;
6781:
6782: INV_LOC_WMS_UTILS.LOC_EMPTY_MIXED_FLAG (

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

6854: l_chk_flag NUMBER;
6855: l_mixed_flag VARCHAR2(1);
6856: l_empty_flag VARCHAR2(1);
6857: l_item_id NUMBER;
6858: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
6859: BEGIN
6860: IF (l_debug = 1) THEN
6861: INV_TRX_UTIL_PUB.TRACE('In LOC_EMPTY_MIXED_FLAG Procedure ','LOC_EMPTY_MIXED_FLAG',10);
6862: END IF;

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

7156: l_item item_cnt%rowtype;
7157: l_mixed_flag varchar2(1);
7158: l_empty_flag varchar2(1);
7159: l_inventory_item_id number;
7160: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
7161: BEGIN
7162:
7163: IF (l_debug = 1) THEN
7164: INV_TRX_UTIL_PUB.TRACE('In Procedure inv_loc_issues ','inv_loc_issues',10);

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

7305: )
7306: is
7307: l_chk_flag number;
7308: l_subinventory_code varchar2(30); --Added variable for 3237709
7309: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
7310: BEGIN
7311: x_return_status := FND_API.G_RET_STS_SUCCESS;
7312:
7313: IF (l_debug = 1) THEN

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

7447: l_mmtt_cur mmtt_cur%ROWTYPE ;
7448: l_return_status varchar2(10);
7449: l_msg_data varchar2(1000);
7450: l_msg_count number;
7451: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
7452: BEGIN
7453: x_return_status := fnd_api.g_ret_sts_success;
7454: --Fixed bug 2342723, removed savepoint
7455: -- bug 3511690 retained the savepoint

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

7839: l_msg_data VARCHAR2(1000);
7840: l_msg_count NUMBER;
7841: l_units NUMBER ;
7842:
7843: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
7844: BEGIN
7845: IF (l_debug = 1) THEN
7846: INV_TRX_UTIL_PUB.TRACE('In LPN_LOC_CURRENT_CAPACITY Procedure ','LPN_LOC_CURRENT_CAPACITY',9);
7847: END IF;

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

8060: l_mixed_num NUMBER := 0;
8061:
8062: l_physical_locator_id NUMBER := NULL;
8063: l_locator_id NUMBER;
8064: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
8065: BEGIN
8066: x_return_status := FND_API.G_RET_STS_SUCCESS;
8067:
8068: l_locator_id := p_locator_id;