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 44: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

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

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

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

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

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

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

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

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

560: PRAGMA EXCEPTION_INIT(resource_busy_detected, -54);
561: l_loc_counter NUMBER := 10000;
562: l_locator_locked BOOLEAN := TRUE;
563: /*13451495 .ends*/
564: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
565: BEGIN
566: IF (l_debug = 1) THEN
567: mdebug('In update_loc_curr_capacity_nauto');
568: END IF;

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

1036: l_return_status varchar2(1);
1037: l_msg_count number;
1038: l_msg_data varchar2(1000);
1039:
1040: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1041: BEGIN
1042:
1043: -- Initialize API return status to success
1044: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1129:
1130: l_return_status varchar2(1);
1131: l_msg_count number;
1132: l_msg_data varchar2(1000);
1133: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1134: BEGIN
1135:
1136: -- Initialize API return status to success
1137: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1270: resource_busy_detected EXCEPTION;
1271: PRAGMA EXCEPTION_INIT(resource_busy_detected, -54);
1272: --Bug#9864825(Base Bug : 9120873) end
1273:
1274: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1275: BEGIN
1276: IF (l_debug = 1) THEN
1277: mdebug('In update_loc_sugg_capacity_nauto');
1278: END IF;

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

1662:
1663: l_return_status varchar2(1);
1664: l_msg_count number;
1665: l_msg_data varchar2(1000);
1666: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1667: BEGIN
1668:
1669: -- Initialize API return status to success
1670: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1828: resource_busy_detected EXCEPTION;
1829:
1830: PRAGMA EXCEPTION_INIT(resource_busy_detected, -54);
1831:
1832: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1833: BEGIN
1834: -- Initialize API return status to success
1835: x_return_status := FND_API.G_RET_STS_SUCCESS;
1836:

Line 2753: l_debug NUMBER := nvl(fnd_profile.value('INV_DEBUG_TRACE'),0);

2749:
2750: -- Bug 12937771 additions (End)
2751:
2752: l_commit_count NUMBER := 0;
2753: l_debug NUMBER := nvl(fnd_profile.value('INV_DEBUG_TRACE'),0);
2754: BEGIN
2755: -- Initialize API return status to success
2756: x_return_status := fnd_api.g_ret_sts_success;
2757:

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

3848: l_msg_count number;
3849: l_msg_data varchar2(1000);
3850: l_conc_status BOOLEAN;
3851: l_mixed_items_flag varchar2(1);
3852: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3853: BEGIN
3854:
3855: IF (p_organization_id is null) THEN
3856: fnd_message.set_name('INV', 'INV_ORG_REQUIRED');

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

3923:
3924: l_msg_count NUMBER;
3925: l_msg_data VARCHAR2(2000);
3926:
3927: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3928: BEGIN
3929:
3930: fnd_msg_pub.count_and_get(
3931: p_count => l_msg_count,

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

3962: )
3963: IS
3964: l_loc_id NUMBER;
3965: l_physical_locator_id NUMBER;
3966: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3967: BEGIN
3968: /*---------------------------------------------------------------------------------------------
3969: Check if the locator has a physical_location_id then use the physical_location_id for further
3970: processing.Else we have to use the inventory_location_id for further processing

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

4008: l_locator_maximum_units NUMBER;
4009: l_locator_current_units NUMBER;
4010: l_locator_available_units NUMBER;
4011: l_locator_suggested_units NUMBER;
4012: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
4013: l_proc_name VARCHAR2(20) := 'FETCH_LOCATOR: ';
4014: BEGIN
4015: /*---------------------------------------------------------------------------------------------
4016: Fetch the locator's current capacity.

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

4155: , p_organization_id IN NUMBER
4156: , p_container_item IN VARCHAR2
4157: )
4158: IS
4159: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
4160: l_proc_name VARCHAR2(50) := 'FETCH_ITEM_ATTRIBUTES: ';
4161: BEGIN
4162: x_return_status := FND_API.G_RET_STS_SUCCESS;
4163: item_attributes(

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

4216: l_lpn_container_item_weight NUMBER;
4217: l_lpn_container_item_vol NUMBER;
4218: l_lpn_exists_in_locator VARCHAR2(1);
4219: l_proc_name VARCHAR2(50) := 'FETCH_LPN_ATTR: ';
4220: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
4221: BEGIN
4222: x_return_status := FND_API.G_RET_STS_SUCCESS;
4223: IF (l_debug = 1) THEN
4224: mdebug(l_proc_name||'Fetching of LPN attibutes ');

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

4397: l_trn_gross_weight_uom_code VARCHAR2(3);
4398: l_trn_content_volume_uom_code VARCHAR2(3);
4399: l_trn_lpn_exists_in_locator VARCHAR2(1);
4400: l_proc_name VARCHAR2(50) := 'FETCH_TRANSFER_LPN_ATTR: ';
4401: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
4402: BEGIN
4403: x_return_status := FND_API.G_RET_STS_SUCCESS;
4404: IF (l_debug = 1) THEN
4405: mdebug(l_proc_name||'Fetching of Transfer LPN attibutes ');

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

4582: l_cnt_content_volume_uom_code VARCHAR2(3);
4583: l_cnt_lpn_exists_in_locator VARCHAR2(1);
4584: l_quantity NUMBER := 0;
4585: l_proc_name VARCHAR2(50) := 'FETCH_CONTENT_LPN_ATTR: ';
4586: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
4587: BEGIN
4588: x_return_status := FND_API.G_RET_STS_SUCCESS;
4589: IF (l_debug = 1) THEN
4590: mdebug(l_proc_name||'Fetching attributes of the Content lpn: '||to_char(p_lpn_id));

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

4763: l_locator_current_weight NUMBER := 0;
4764: l_locator_available_weight NUMBER;
4765: l_locator_current_units NUMBER := 0;
4766: l_locator_available_units NUMBER;
4767: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
4768: BEGIN
4769: x_return_status := FND_API.G_RET_STS_SUCCESS;
4770:
4771: IF (l_debug = 1) THEN

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

4874: l_locator_current_weight NUMBER := 0;
4875: l_locator_available_weight NUMBER;
4876: l_locator_current_units NUMBER := 0;
4877: l_locator_available_units NUMBER;
4878: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
4879: BEGIN
4880: x_return_status := FND_API.G_RET_STS_SUCCESS;
4881:
4882: IF (l_debug = 1) THEN

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

5013: l_update_table BOOLEAN := TRUE;
5014: l_content_lpn_quantity NUMBER;
5015:
5016: l_proc_name VARCHAR2(50) := 'UPD_LPN_LOC_CPTY_FOR_XFR:';
5017: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
5018: BEGIN
5019: x_return_status := FND_API.G_RET_STS_SUCCESS;
5020:
5021: /*--------------------------------------------------------------------------------------------

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

5483: l_locator_current_cubic_area NUMBER := 0;
5484: l_locator_available_cubic_area NUMBER;
5485: l_locator_current_weight NUMBER := 0;
5486: l_locator_available_weight NUMBER;
5487: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
5488: l_content_qty NUMBER;
5489: l_lpn_qty NUMBER;
5490: l_content_lpn_vol NUMBER;
5491: BEGIN

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

5609: l_locator_current_cubic_area NUMBER;
5610: l_locator_available_cubic_area NUMBER;
5611: l_locator_current_weight NUMBER;
5612: l_locator_available_weight NUMBER;
5613: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
5614: l_container_item_weight NUMBER;
5615: l_container_item_vol NUMBER;
5616: l_content_volume NUMBER;
5617: l_lpn_exists_in_locator VARCHAR2(1);

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

5805: l_max_cubic_area NUMBER;
5806:
5807:
5808: /* Debug Check */
5809: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
5810: l_proc_name VARCHAR2(50) := 'UPD_LPN_LOC_CURR_CPTY_NOAUTO:';
5811: BEGIN
5812:
5813: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

6298: PRAGMA autonomous_transaction;
6299: l_return_status VARCHAR2(1);
6300: l_msg_count NUMBER;
6301: l_msg_data VARCHAR2(1000);
6302: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
6303: BEGIN
6304: x_return_status := FND_API.G_RET_STS_SUCCESS;
6305: INV_LOC_WMS_UTILS.upd_lpn_loc_curr_cpty_nauto
6306: ( x_return_status =>l_return_status,

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

6377: IS
6378: l_return_status varchar2(10);
6379: l_msg_data varchar2(1000);
6380: l_msg_count number;
6381: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
6382: BEGIN
6383: x_return_status := fnd_api.g_ret_sts_success;
6384:
6385: savepoint lpn_loc_cleanup;

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

6502: l_cnt_lpn_content_volume NUMBER;
6503: l_xacted_volume NUMBER;
6504: l_trn_xacted_volume NUMBER;
6505: l_trn_lpn_exists_in_loc VARCHAR2(1);
6506: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
6507: l_proc_name VARCHAR2(40) := 'CAL_LOCATOR_CURRENT_VOL: ';
6508: BEGIN
6509: l_locator_current_volume :=p_locator_current_cubic_area;
6510: l_trn_lpn_container_item_vol :=p_trn_lpn_container_item_vol;

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

6724: l_container_item_xacted_volume NUMBER;
6725:
6726: l_msg_data VARCHAR2(1000);
6727: l_msg_count NUMBER;
6728: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
6729: BEGIN
6730: x_return_status := FND_API.G_RET_STS_SUCCESS;
6731: BEGIN
6732:

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

6964: l_item_xacted_weight NUMBER;
6965: l_item_xacted_volume NUMBER;
6966: l_quantity NUMBER;
6967:
6968: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
6969: BEGIN
6970: x_return_status := FND_API.G_RET_STS_SUCCESS;
6971:
6972: SELECT primary_uom_code

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

7221:
7222: l_return_status varchar2(1);
7223: l_msg_data varchar2(1000);
7224: l_msg_count number;
7225: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
7226: BEGIN
7227: x_return_status := fnd_api.g_ret_sts_success ;
7228:
7229: INV_LOC_WMS_UTILS.LOC_EMPTY_MIXED_FLAG (

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

7305: l_chk_flag NUMBER;
7306: l_mixed_flag VARCHAR2(1);
7307: l_empty_flag VARCHAR2(1);
7308: l_item_id NUMBER;
7309: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
7310: /*11809528.starts*/
7311: resource_busy_detected EXCEPTION;
7312: PRAGMA EXCEPTION_INIT(resource_busy_detected, -54);
7313: l_loc_counter NUMBER := 10000;

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

7676: l_item item_cnt%rowtype;
7677: l_mixed_flag varchar2(1);
7678: l_empty_flag varchar2(1);
7679: l_inventory_item_id number;
7680: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
7681: BEGIN
7682:
7683: IF (l_debug = 1) THEN
7684: INV_TRX_UTIL_PUB.TRACE('In Procedure inv_loc_issues ','inv_loc_issues',10);

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

7825: )
7826: is
7827: l_chk_flag number;
7828: l_subinventory_code varchar2(30); --Added variable for 3237709
7829: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
7830: BEGIN
7831: x_return_status := FND_API.G_RET_STS_SUCCESS;
7832:
7833: IF (l_debug = 1) THEN

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

7967: l_mmtt_cur mmtt_cur%ROWTYPE ;
7968: l_return_status varchar2(10);
7969: l_msg_data varchar2(1000);
7970: l_msg_count number;
7971: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
7972: BEGIN
7973: x_return_status := fnd_api.g_ret_sts_success;
7974: --Fixed bug 2342723, removed savepoint
7975: -- bug 3511690 retained the savepoint

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

8359: l_msg_data VARCHAR2(1000);
8360: l_msg_count NUMBER;
8361: l_units NUMBER ;
8362:
8363: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
8364: BEGIN
8365: IF (l_debug = 1) THEN
8366: INV_TRX_UTIL_PUB.TRACE('In LPN_LOC_CURRENT_CAPACITY Procedure ','LPN_LOC_CURRENT_CAPACITY',9);
8367: END IF;

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

8582: l_mixed_num NUMBER := 0;
8583:
8584: l_physical_locator_id NUMBER := NULL;
8585: l_locator_id NUMBER;
8586: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
8587: BEGIN
8588: x_return_status := FND_API.G_RET_STS_SUCCESS;
8589:
8590: l_locator_id := p_locator_id;

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

8741: l_return_status varchar2(1);
8742: l_msg_data varchar2(1000);
8743: l_msg_count number;
8744:
8745: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
8746: BEGIN
8747:
8748: --p_source := NULL;
8749: IF p_transaction_action_id IN(1,2,4,28) THEN