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 INV_LOC_WMS_UTILS

Line 1: PACKAGE BODY inv_loc_wms_utils AS

1: PACKAGE BODY inv_loc_wms_utils AS
2: /* $Header: INVLCPYB.pls 120.11.12010000.2 2008/07/29 13:41:33 ptkumar ship $ */
3:
4: g_pkg_name CONSTANT VARCHAR2(30) := 'INV_LOC_WMS_UTILS';
5:

Line 4: g_pkg_name CONSTANT VARCHAR2(30) := 'INV_LOC_WMS_UTILS';

1: PACKAGE BODY inv_loc_wms_utils AS
2: /* $Header: INVLCPYB.pls 120.11.12010000.2 2008/07/29 13:41:33 ptkumar ship $ */
3:
4: g_pkg_name CONSTANT VARCHAR2(30) := 'INV_LOC_WMS_UTILS';
5:
6:
7: -- to turn off debugger, comment out the line 'dbms_output.put_line(msg);'
8: PROCEDURE mdebug(msg in varchar2)

Line 13: INV_TRX_UTIL_PUB.TRACE(msg,'INV_LOC_WMS_UTILS ',9);

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;
15:
16: -- This API returns the current and suggested volume, weight, and units capacity of a
17: -- given locator in the primary unit of measure

Line 1013: inv_loc_wms_utils.update_loc_curr_capacity_nauto

1009:
1010: -- Initialize API return status to success
1011: x_return_status := FND_API.G_RET_STS_SUCCESS;
1012:
1013: inv_loc_wms_utils.update_loc_curr_capacity_nauto
1014: ( x_return_status => l_return_status,
1015: x_msg_count => x_msg_count,
1016: x_msg_data => x_msg_data,
1017: p_organization_id => p_organization_id,

Line 1106: inv_loc_wms_utils.update_loc_sugg_capacity_nauto

1102:
1103: -- Initialize API return status to success
1104: x_return_status := FND_API.G_RET_STS_SUCCESS;
1105:
1106: inv_loc_wms_utils.update_loc_sugg_capacity_nauto
1107: ( x_return_status => l_return_status,
1108: x_msg_count => x_msg_count,
1109: x_msg_data => x_msg_data,
1110: p_organization_id => p_organization_id,

Line 1607: inv_loc_wms_utils.update_loc_sugg_capacity_nauto

1603:
1604: -- Initialize API return status to success
1605: x_return_status := FND_API.G_RET_STS_SUCCESS;
1606:
1607: inv_loc_wms_utils.update_loc_sugg_capacity_nauto
1608: ( x_return_status => l_return_status,
1609: x_msg_count => x_msg_count,
1610: x_msg_data => x_msg_data,
1611: p_organization_id => p_organization_id,

Line 1630: INV_LOC_WMS_UTILS.LOC_EMPTY_MIXED_FLAG (

1626:
1627: -- Update empty_flag, mixed_item_flag. Pass transaction action of receipt
1628: -- regardless of whether suggestion is receipt or transfer
1629:
1630: INV_LOC_WMS_UTILS.LOC_EMPTY_MIXED_FLAG (
1631: X_RETURN_STATUS => l_return_status
1632: , X_MSG_COUNT => x_msg_count
1633: , X_MSG_DATA => x_msg_data
1634: , p_organization_id => p_organization_id

Line 2102: INV_LOC_WMS_UTILS.LOC_EMPTY_MIXED_FLAG (

2098: END IF;
2099:
2100: -- Update empty_flag, mixed_item_flag. Pass transaction action of issue
2101:
2102: INV_LOC_WMS_UTILS.LOC_EMPTY_MIXED_FLAG (
2103: X_RETURN_STATUS => l_return_status
2104: , X_MSG_COUNT => x_msg_count
2105: , X_MSG_DATA => x_msg_data
2106: , p_organization_id => p_organization_id

Line 2246: INV_LOC_WMS_UTILS.lpn_attributes(

2242: l_lpn_volume NUMBER := 0;
2243: l_content_volume NUMBER := 0;
2244: l_prog_name VARCHAR2(40) := 'get_container_capacity';
2245: BEGIN
2246: INV_LOC_WMS_UTILS.lpn_attributes(
2247: x_return_status => x_return_status
2248: , x_msg_data => x_msg_data
2249: , x_msg_count => x_msg_count
2250: , x_gross_weight_uom_code => l_lpn_gross_weight_uom_code

Line 3400: ( 'inv_loc_wms_utils'

3396: x_return_status := fnd_api.g_ret_sts_unexp_error;
3397: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
3398: THEN
3399: fnd_msg_pub.add_exc_msg
3400: ( 'inv_loc_wms_utils'
3401: , 'locator_capacity_cleanup'
3402: );
3403: END IF;
3404: fnd_msg_pub.count_and_get

Line 3440: inv_loc_wms_utils.locators_capacity_cleanup

3436: l_mixed_items_flag := null;
3437: END IF;
3438:
3439: -- call cleanup API
3440: inv_loc_wms_utils.locators_capacity_cleanup
3441: ( x_return_status => l_return_status
3442: , x_msg_count => l_msg_count
3443: , x_msg_data => l_msg_data
3444: , p_organization_id => p_organization_id

Line 3798: INV_LOC_WMS_UTILS.lpn_attributes(

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 ');
3797: END IF;
3798: INV_LOC_WMS_UTILS.lpn_attributes(
3799: x_return_status => x_return_status
3800: , x_msg_data => x_msg_data
3801: , x_msg_count => x_msg_count
3802: , x_gross_weight_uom_code => l_lpn_gross_weight_uom_code

Line 3979: INV_LOC_WMS_UTILS.lpn_attributes(

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 ');
3978: END IF;
3979: INV_LOC_WMS_UTILS.lpn_attributes(
3980: x_return_status => x_return_status
3981: , x_msg_data => x_msg_data
3982: , x_msg_count => x_msg_count
3983: , x_gross_weight_uom_code => l_trn_gross_weight_uom_code

Line 4164: INV_LOC_WMS_UTILS.lpn_attributes(

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));
4163: END IF;
4164: INV_LOC_WMS_UTILS.lpn_attributes(
4165: x_return_status => x_return_status
4166: , x_msg_data => x_msg_data
4167: , x_msg_count => x_msg_count
4168: , x_gross_weight_uom_code => l_cnt_gross_weight_uom_code

Line 4358: INV_LOC_WMS_UTILS.cal_locator_current_volume(

4354: + p_loc_attr.l_locator_suggested_weight);
4355: IF l_locator_available_weight <0 THEN
4356: l_locator_available_weight := 0;
4357: END IF;
4358: INV_LOC_WMS_UTILS.cal_locator_current_volume(
4359: x_return_status => x_return_status
4360: , x_msg_data => x_msg_data
4361: , x_msg_count => x_msg_count
4362: , x_locator_current_volume => l_locator_current_cubic_area

Line 4489: INV_LOC_WMS_UTILS.cal_locator_current_volume(

4485:
4486: IF p_transfer_lpn_id IS NULL THEN
4487: l_locator_current_cubic_area := p_loc_attr.l_locator_current_cubic_area + p_item_attr.l_item_xacted_volume;
4488: ELSE
4489: INV_LOC_WMS_UTILS.cal_locator_current_volume(
4490: x_return_status => x_return_status
4491: , x_msg_data => x_msg_data
4492: , x_msg_count => x_msg_count
4493: , x_locator_current_volume => l_locator_current_cubic_area

Line 5074: INV_LOC_WMS_UTILS.cal_locator_current_volume(

5070: IF p_content_lpn_id IS NULL THEN
5071: IF (l_debug = 1) THEN
5072: mdebug(l_proc_name||'The p_content_id is null -case Unpack ');
5073: END IF;
5074: INV_LOC_WMS_UTILS.cal_locator_current_volume(
5075: x_return_status => x_return_status
5076: , x_msg_data => x_msg_data
5077: , x_msg_count => x_msg_count
5078: , x_locator_current_volume => l_locator_current_cubic_area

Line 5101: INV_LOC_WMS_UTILS.cal_locator_current_volume(

5097: IF (l_debug = 1) THEN
5098: mdebug(l_proc_name||'The P_content_lpn_id is not null -case Unpack ');
5099: END IF;
5100:
5101: INV_LOC_WMS_UTILS.cal_locator_current_volume(
5102: x_return_status => x_return_status
5103: , x_msg_data => x_msg_data
5104: , x_msg_count => x_msg_count
5105: , x_locator_current_volume => l_locator_current_cubic_area

Line 5266: INV_LOC_WMS_UTILS.cal_locator_current_volume(

5262: IF p_content_lpn_id IS NULL THEN
5263: IF (l_debug = 1) THEN
5264: mdebug(l_proc_name||'The p_content_id is null -case pack ');
5265: END IF;
5266: INV_LOC_WMS_UTILS.cal_locator_current_volume(
5267: x_return_status => x_return_status
5268: , x_msg_data => x_msg_data
5269: , x_msg_count => x_msg_count
5270: , x_locator_current_volume => l_locator_current_cubic_area

Line 5292: INV_LOC_WMS_UTILS.cal_locator_current_volume(

5288: -------------------------------------------------------------------------------------------------*/
5289: IF (l_debug = 1) THEN
5290: mdebug(l_proc_name||'The P_content_lpn_id is not null -case pack ');
5291: END IF;
5292: INV_LOC_WMS_UTILS.cal_locator_current_volume(
5293: x_return_status => x_return_status
5294: , x_msg_data => x_msg_data
5295: , x_msg_count => x_msg_count
5296: , x_locator_current_volume => l_locator_current_cubic_area

Line 5877: INV_LOC_WMS_UTILS.upd_lpn_loc_curr_cpty_nauto

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,
5879: x_msg_count =>l_msg_count,
5880: x_msg_data =>l_msg_data,
5881: p_organization_id => p_organization_id,

Line 5933: ( 'inv_loc_wms_utils'

5929: x_return_status := fnd_api.g_ret_sts_unexp_error;
5930: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
5931: THEN
5932: fnd_msg_pub.add_exc_msg
5933: ( 'inv_loc_wms_utils'
5934: , 'update_lpn_loc_curr_capacity'
5935: );
5936: END IF;
5937: fnd_msg_pub.count_and_get

Line 5962: INV_LOC_WMS_UTILS.LPN_LOC_CURRENT_CAPACITY (x_return_status =>l_return_status,

5958: IF (l_debug = 1) THEN
5959: INV_TRX_UTIL_PUB.TRACE('In LPN_LOC_CAPACITY_clean_up Procedure ','lpn_loc_capacity_clean_up',9);
5960: END IF;
5961:
5962: INV_LOC_WMS_UTILS.LPN_LOC_CURRENT_CAPACITY (x_return_status =>l_return_status,
5963: x_msg_count =>l_msg_count,
5964: x_msg_data => x_msg_data,
5965: p_organization_id =>p_organization_id,
5966: p_mixed_flag => p_mixed_flag);

Line 5984: INV_LOC_WMS_UTILS.lpn_loc_cleanup_mmtt(x_return_status =>l_return_status,

5980: IF (l_debug = 1) THEN
5981: INV_TRX_UTIL_PUB.TRACE('Before call to lpn_loc_cleanup_mmtt','lpn_loc_capacity_clean_up',9);
5982: END IF;
5983:
5984: INV_LOC_WMS_UTILS.lpn_loc_cleanup_mmtt(x_return_status =>l_return_status,
5985: x_msg_count =>l_msg_count,
5986: x_msg_data =>l_msg_data,
5987: p_organization_id =>p_organization_id,
5988: p_mixed_flag =>p_mixed_flag);

Line 6038: ( 'INV_LOC_WMS_UTILS',

6034: --rollback;
6035: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
6036: THEN
6037: fnd_msg_pub.add_exc_msg
6038: ( 'INV_LOC_WMS_UTILS',
6039: 'lpn_loc_capacity_clean_up'
6040: );
6041: END IF;
6042: fnd_msg_pub.count_and_get

Line 6253: ( 'inv_loc_wms_utils'

6249: x_return_status := fnd_api.g_ret_sts_unexp_error;
6250: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
6251: THEN
6252: fnd_msg_pub.add_exc_msg
6253: ( 'inv_loc_wms_utils'
6254: , 'cal_locator_current_volume'
6255: );
6256: END IF;
6257: fnd_msg_pub.count_and_get

Line 6341: INV_LOC_WMS_UTILS.item_attributes( l_return_status,

6337: );
6338: END IF;
6339:
6340: IF l_container_item_id is not null THEN
6341: INV_LOC_WMS_UTILS.item_attributes( l_return_status,
6342: l_msg_data,
6343: l_msg_count,
6344: L_CONTAINER_ITEM_WT_UOM_CODE,
6345: l_container_item_unit_weight,

Line 6472: ( 'inv_loc_wms_utils'

6468: x_return_status := fnd_api.g_ret_sts_unexp_error;
6469: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
6470: THEN
6471: fnd_msg_pub.add_exc_msg
6472: ( 'inv_loc_wms_utils'
6473: , 'lpn_attributes'
6474: );
6475: END IF;
6476: fnd_msg_pub.count_and_get

Line 6751: ( 'inv_loc_wms_utils'

6747: x_return_status := fnd_api.g_ret_sts_unexp_error;
6748: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
6749: THEN
6750: fnd_msg_pub.add_exc_msg
6751: ( 'inv_loc_wms_utils'
6752: , 'item_attributes'
6753: );
6754: END IF;
6755: fnd_msg_pub.count_and_get

Line 6782: INV_LOC_WMS_UTILS.LOC_EMPTY_MIXED_FLAG (

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 (
6783: X_RETURN_STATUS => l_return_status
6784: , X_MSG_COUNT => l_MSG_COUNT
6785: , X_MSG_DATA => l_MSG_DATA
6786: , P_ORGANIZATION_ID => p_organization_id

Line 6826: ( 'inv_loc_wms_utils'

6822: x_return_status := fnd_api.g_ret_sts_unexp_error;
6823: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
6824: THEN
6825: fnd_msg_pub.add_exc_msg
6826: ( 'inv_loc_wms_utils'
6827: , 'LOC_EMPTY_MIXED_FLAG_AUTO'
6828: );
6829: END IF;
6830: fnd_msg_pub.count_and_get

Line 6911: INV_LOC_WMS_UTILS.inv_loc_receipt (x_return_status => X_return_status

6907: IF (l_debug = 1) THEN
6908: INV_TRX_UTIL_PUB.TRACE('Receipt transaction ','LOC_EMPTY_MIXED_FLAG',10);
6909: END IF;
6910:
6911: INV_LOC_WMS_UTILS.inv_loc_receipt (x_return_status => X_return_status
6912: ,X_MSG_COUNT => X_msg_count
6913: ,X_MSG_DATA => X_msg_data
6914: ,X_EMPTY_FLAG => l_empty_flag
6915: ,X_MIXED_FLAG => l_mixed_flag

Line 6939: INV_LOC_WMS_UTILS.inv_loc_issues (x_return_status => X_return_status

6935: IF (l_debug = 1) THEN
6936: INV_TRX_UTIL_PUB.TRACE('Issue transaction ','LOC_EMPTY_MIXED_FLAG',10);
6937: END IF;
6938:
6939: INV_LOC_WMS_UTILS.inv_loc_issues (x_return_status => X_return_status
6940: ,X_MSG_COUNT => X_msg_count
6941: ,X_MSG_DATA => X_msg_data
6942: ,X_EMPTY_FLAG => l_empty_flag
6943: ,X_MIXED_FLAG => l_mixed_flag

Line 7003: INV_LOC_WMS_UTILS.inv_loc_receipt (

6999: IF (l_debug = 1) THEN
7000: INV_TRX_UTIL_PUB.TRACE('Before call to Receipt transaction ', 'LOC_EMPTY_MIXED_FLAG',10);
7001: END IF;
7002:
7003: INV_LOC_WMS_UTILS.inv_loc_receipt (
7004: x_return_status => X_return_status
7005: ,X_MSG_COUNT => X_msg_count
7006: ,X_MSG_DATA => X_msg_data
7007: ,X_EMPTY_FLAG => l_empty_flag

Line 7049: INV_LOC_WMS_UTILS.inv_loc_issues(x_return_status => X_return_status

7045: IF (l_debug = 1) THEN
7046: INV_TRX_UTIL_PUB.TRACE('Before call to Issue transaction ','LOC_EMPTY_MIXED_FLAG',10);
7047: END IF;
7048:
7049: INV_LOC_WMS_UTILS.inv_loc_issues(x_return_status => X_return_status
7050: ,X_MSG_COUNT => X_msg_count
7051: ,X_MSG_DATA => X_msg_data
7052: ,X_EMPTY_FLAG => l_empty_flag
7053: ,X_MIXED_FLAG => l_mixed_flag

Line 7121: ( 'inv_loc_wms_utils'

7117: --ROLLBACK TO loc_empty;
7118: ROLLBACK;
7119: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
7120: fnd_msg_pub.add_exc_msg
7121: ( 'inv_loc_wms_utils'
7122: , 'LOC_EMPTY_MIXED_FLAG '
7123: );
7124: END IF;
7125: fnd_msg_pub.count_and_get

Line 7286: ( 'inv_loc_wms_utils'

7282: WHEN OTHERS THEN
7283: x_return_status := fnd_api.g_ret_sts_unexp_error;
7284: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
7285: fnd_msg_pub.add_exc_msg
7286: ( 'inv_loc_wms_utils'
7287: , 'inv_loc_issues'
7288: );
7289: END IF;
7290: fnd_msg_pub.count_and_get

Line 7384: ( 'inv_loc_wms_utils'

7380: x_return_status := fnd_api.g_ret_sts_unexp_error;
7381:
7382: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
7383: fnd_msg_pub.add_exc_msg
7384: ( 'inv_loc_wms_utils'
7385: , 'lpn_loc_receipt'
7386: );
7387: END IF;
7388:

Line 7470: INV_LOC_WMS_UTILS.upd_lpn_loc_curr_cpty_nauto(x_return_status => l_return_status,

7466: IF l_mmtt_cur_mixed_flg.transaction_action_id in (2,3,28) then
7467: if l_mmtt_cur_mixed_flg.transfer_organization is null then
7468: l_mmtt_cur_mixed_flg.transfer_organization := l_mmtt_cur_mixed_flg.organization_id;
7469: end if;
7470: INV_LOC_WMS_UTILS.upd_lpn_loc_curr_cpty_nauto(x_return_status => l_return_status,
7471: x_msg_count => l_msg_count ,
7472: x_msg_data => l_msg_data ,
7473: p_organization_id => l_mmtt_cur_mixed_flg.transfer_organization,
7474: p_inventory_location_id => l_mmtt_cur_mixed_flg.transfer_to_location,

Line 7496: INV_LOC_WMS_UTILS.LOC_EMPTY_MIXED_FLAG (

7492: END IF;
7493: RAISE fnd_api.g_exc_unexpected_error;
7494: END IF;
7495:
7496: INV_LOC_WMS_UTILS.LOC_EMPTY_MIXED_FLAG (
7497: X_RETURN_STATUS => l_return_status
7498: ,X_MSG_COUNT => l_MSG_COUNT
7499: ,X_MSG_DATA => l_MSG_DATA
7500: ,P_ORGANIZATION_ID => l_mmtt_cur_mixed_flg.organization_id

Line 7521: INV_LOC_WMS_UTILS.upd_lpn_loc_curr_cpty_nauto(x_return_status => l_return_status,

7517: RAISE fnd_api.g_exc_unexpected_error;
7518: END IF;
7519:
7520: ELSE /* For transaction_action_id not in (2,3,28) */
7521: INV_LOC_WMS_UTILS.upd_lpn_loc_curr_cpty_nauto(x_return_status => l_return_status,
7522: x_msg_count => l_msg_count ,
7523: x_msg_data => l_msg_data ,
7524: p_organization_id => l_mmtt_cur_mixed_flg.organization_id,
7525: p_inventory_location_id => l_mmtt_cur_mixed_flg.locator_id,

Line 7547: INV_LOC_WMS_UTILS.LOC_EMPTY_MIXED_FLAG (

7543: END IF;
7544: RAISE fnd_api.g_exc_unexpected_error;
7545: END IF;
7546:
7547: INV_LOC_WMS_UTILS.LOC_EMPTY_MIXED_FLAG (
7548: X_RETURN_STATUS => l_return_status
7549: ,X_MSG_COUNT => l_MSG_COUNT
7550: ,X_MSG_DATA => l_MSG_DATA
7551: ,P_ORGANIZATION_ID => l_mmtt_cur_mixed_flg.organization_id

Line 7587: INV_LOC_WMS_UTILS.upd_lpn_loc_curr_cpty_nauto(x_return_status => l_return_status,

7583: IF l_mmtt_cur.transaction_action_id in (2,3,28) then
7584: if l_mmtt_cur.transfer_organization is null then
7585: l_mmtt_cur.transfer_organization := l_mmtt_cur.organization_id;
7586: end if;
7587: INV_LOC_WMS_UTILS.upd_lpn_loc_curr_cpty_nauto(x_return_status => l_return_status,
7588: x_msg_count => l_msg_count ,
7589: x_msg_data => l_msg_data ,
7590: p_organization_id => l_mmtt_cur.transfer_organization,
7591: p_inventory_location_id => l_mmtt_cur.transfer_to_location,

Line 7613: INV_LOC_WMS_UTILS.LOC_EMPTY_MIXED_FLAG (

7609: END IF;
7610: RAISE fnd_api.g_exc_unexpected_error;
7611: END IF;
7612:
7613: INV_LOC_WMS_UTILS.LOC_EMPTY_MIXED_FLAG (
7614: X_RETURN_STATUS => l_return_status
7615: ,X_MSG_COUNT => l_MSG_COUNT
7616: ,X_MSG_DATA => l_MSG_DATA
7617: ,P_ORGANIZATION_ID => l_mmtt_cur.organization_id

Line 7638: INV_LOC_WMS_UTILS.upd_lpn_loc_curr_cpty_nauto(x_return_status => l_return_status,

7634: RAISE fnd_api.g_exc_unexpected_error;
7635: END IF;
7636:
7637: ELSE /* For transaction_action_id not in (2,3,28) */
7638: INV_LOC_WMS_UTILS.upd_lpn_loc_curr_cpty_nauto(x_return_status => l_return_status,
7639: x_msg_count => l_msg_count ,
7640: x_msg_data => l_msg_data ,
7641: p_organization_id => l_mmtt_cur.organization_id,
7642: p_inventory_location_id => l_mmtt_cur.locator_id,

Line 7664: INV_LOC_WMS_UTILS.LOC_EMPTY_MIXED_FLAG (

7660: END IF;
7661: RAISE fnd_api.g_exc_unexpected_error;
7662: END IF;
7663:
7664: INV_LOC_WMS_UTILS.LOC_EMPTY_MIXED_FLAG (
7665: X_RETURN_STATUS => l_return_status
7666: ,X_MSG_COUNT => l_MSG_COUNT
7667: ,X_MSG_DATA => l_MSG_DATA
7668: ,P_ORGANIZATION_ID => l_mmtt_cur.organization_id

Line 7751: ( 'INV_LOC_WMS_UTILS',

7747: --rollback;
7748: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
7749: THEN
7750: fnd_msg_pub.add_exc_msg
7751: ( 'INV_LOC_WMS_UTILS',
7752: 'lpn_loc_cleanup_mmtt'
7753: );
7754: END IF;
7755: fnd_msg_pub.count_and_get

Line 8039: ( 'INV_LOC_WMS_UTILS',

8035: --rollback;
8036: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
8037: THEN
8038: fnd_msg_pub.add_exc_msg
8039: ( 'INV_LOC_WMS_UTILS',
8040: 'LPN_LOC_CURRENT_CAPACITY'
8041: );
8042: END IF;
8043: fnd_msg_pub.count_and_get

Line 8151: ( 'inv_loc_wms_utils'

8147: x_return_status := fnd_api.g_ret_sts_unexp_error;
8148:
8149: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
8150: fnd_msg_pub.add_exc_msg
8151: ( 'inv_loc_wms_utils'
8152: , 'upd_empty_mixed_flag_rcv_loc'
8153: );
8154: END IF;
8155:

Line 8196: END inv_loc_wms_utils;

8192: WHEN OTHERS THEN
8193: x_locator_id := NULL;
8194: END get_locator_id;
8195:
8196: END inv_loc_wms_utils;