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.35.12020000.4 2012/10/04 14:26:10 abasheer 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.35.12020000.4 2012/10/04 14:26:10 abasheer 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 1046: inv_loc_wms_utils.update_loc_curr_capacity_nauto

1042:
1043: -- Initialize API return status to success
1044: x_return_status := FND_API.G_RET_STS_SUCCESS;
1045:
1046: inv_loc_wms_utils.update_loc_curr_capacity_nauto
1047: ( x_return_status => l_return_status,
1048: x_msg_count => x_msg_count,
1049: x_msg_data => x_msg_data,
1050: p_organization_id => p_organization_id,

Line 1139: inv_loc_wms_utils.update_loc_sugg_capacity_nauto

1135:
1136: -- Initialize API return status to success
1137: x_return_status := FND_API.G_RET_STS_SUCCESS;
1138:
1139: inv_loc_wms_utils.update_loc_sugg_capacity_nauto
1140: ( x_return_status => l_return_status,
1141: x_msg_count => x_msg_count,
1142: x_msg_data => x_msg_data,
1143: p_organization_id => p_organization_id,

Line 1672: inv_loc_wms_utils.update_loc_sugg_capacity_nauto

1668:
1669: -- Initialize API return status to success
1670: x_return_status := FND_API.G_RET_STS_SUCCESS;
1671:
1672: inv_loc_wms_utils.update_loc_sugg_capacity_nauto
1673: ( x_return_status => l_return_status,
1674: x_msg_count => x_msg_count,
1675: x_msg_data => x_msg_data,
1676: p_organization_id => p_organization_id,

Line 1695: INV_LOC_WMS_UTILS.LOC_EMPTY_MIXED_FLAG (

1691:
1692: -- Update empty_flag, mixed_item_flag. Pass transaction action of receipt
1693: -- regardless of whether suggestion is receipt or transfer
1694:
1695: INV_LOC_WMS_UTILS.LOC_EMPTY_MIXED_FLAG (
1696: X_RETURN_STATUS => l_return_status
1697: , X_MSG_COUNT => x_msg_count
1698: , X_MSG_DATA => x_msg_data
1699: , p_organization_id => p_organization_id

Line 2181: inv_loc_wms_utils.get_source_type( x_source => l_source ,

2177: mdebug('revert_loc_suggested_cap_nauto l_source' || l_source );
2178: mdebug('revert_loc_suggested_cap_nauto p_quantity' || p_quantity );
2179: mdebug('revert_loc_suggested_cap_nauto p_content_lpn_id' ||p_content_lpn_id );
2180: END IF;
2181: inv_loc_wms_utils.get_source_type( x_source => l_source ,
2182: p_locator_id => l_inventory_location_id,
2183: p_organization_id => p_organization_id,
2184: p_inventory_item_id=>p_inventory_item_id,
2185: p_content_lpn_id => p_content_lpn_id ,

Line 2189: mdebug('revert_loc_suggested_cap_nauto after executing inv_loc_wms_utils.get_source_type procedure l_source' || l_source);

2185: p_content_lpn_id => p_content_lpn_id ,
2186: p_transaction_action_id => 1 ,
2187: p_primary_quantity => p_quantity );
2188: IF (l_debug = 1) THEN
2189: mdebug('revert_loc_suggested_cap_nauto after executing inv_loc_wms_utils.get_source_type procedure l_source' || l_source);
2190: END IF;
2191: --bug#9159019 FPing fix for #8944467 end
2192:
2193: -- Start of Bug 13095024 change

Line 2207: INV_LOC_WMS_UTILS.LOC_EMPTY_MIXED_FLAG (

2203:
2204: END IF;
2205: -- End of Bug 13095024 change
2206:
2207: INV_LOC_WMS_UTILS.LOC_EMPTY_MIXED_FLAG (
2208: X_RETURN_STATUS => l_return_status
2209: , X_MSG_COUNT => x_msg_count
2210: , X_MSG_DATA => x_msg_data
2211: , p_organization_id => p_organization_id

Line 2352: INV_LOC_WMS_UTILS.lpn_attributes(

2348: l_lpn_volume NUMBER := 0;
2349: l_content_volume NUMBER := 0;
2350: l_prog_name VARCHAR2(40) := 'get_container_capacity';
2351: BEGIN
2352: INV_LOC_WMS_UTILS.lpn_attributes(
2353: x_return_status => x_return_status
2354: , x_msg_data => x_msg_data
2355: , x_msg_count => x_msg_count
2356: , x_gross_weight_uom_code => l_lpn_gross_weight_uom_code

Line 3831: fnd_msg_pub.add_exc_msg('inv_loc_wms_utils','locator_capacity_cleanup');

3827:
3828: x_return_status := fnd_api.g_ret_sts_unexp_error;
3829:
3830: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3831: fnd_msg_pub.add_exc_msg('inv_loc_wms_utils','locator_capacity_cleanup');
3832: END IF;
3833:
3834: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
3835: END locators_capacity_cleanup;

Line 3868: inv_loc_wms_utils.locators_capacity_cleanup

3864: l_mixed_items_flag := null;
3865: END IF;
3866:
3867: -- call cleanup API
3868: inv_loc_wms_utils.locators_capacity_cleanup
3869: ( x_return_status => l_return_status
3870: , x_msg_count => l_msg_count
3871: , x_msg_data => l_msg_data
3872: , p_organization_id => p_organization_id

Line 4226: INV_LOC_WMS_UTILS.lpn_attributes(

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 ');
4225: END IF;
4226: INV_LOC_WMS_UTILS.lpn_attributes(
4227: x_return_status => x_return_status
4228: , x_msg_data => x_msg_data
4229: , x_msg_count => x_msg_count
4230: , x_gross_weight_uom_code => l_lpn_gross_weight_uom_code

Line 4407: INV_LOC_WMS_UTILS.lpn_attributes(

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 ');
4406: END IF;
4407: INV_LOC_WMS_UTILS.lpn_attributes(
4408: x_return_status => x_return_status
4409: , x_msg_data => x_msg_data
4410: , x_msg_count => x_msg_count
4411: , x_gross_weight_uom_code => l_trn_gross_weight_uom_code

Line 4592: INV_LOC_WMS_UTILS.lpn_attributes(

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));
4591: END IF;
4592: INV_LOC_WMS_UTILS.lpn_attributes(
4593: x_return_status => x_return_status
4594: , x_msg_data => x_msg_data
4595: , x_msg_count => x_msg_count
4596: , x_gross_weight_uom_code => l_cnt_gross_weight_uom_code

Line 4786: INV_LOC_WMS_UTILS.cal_locator_current_volume(

4782: + p_loc_attr.l_locator_suggested_weight);
4783: IF l_locator_available_weight <0 THEN
4784: l_locator_available_weight := 0;
4785: END IF;
4786: INV_LOC_WMS_UTILS.cal_locator_current_volume(
4787: x_return_status => x_return_status
4788: , x_msg_data => x_msg_data
4789: , x_msg_count => x_msg_count
4790: , x_locator_current_volume => l_locator_current_cubic_area

Line 4917: INV_LOC_WMS_UTILS.cal_locator_current_volume(

4913:
4914: IF p_transfer_lpn_id IS NULL THEN
4915: l_locator_current_cubic_area := p_loc_attr.l_locator_current_cubic_area + p_item_attr.l_item_xacted_volume;
4916: ELSE
4917: INV_LOC_WMS_UTILS.cal_locator_current_volume(
4918: x_return_status => x_return_status
4919: , x_msg_data => x_msg_data
4920: , x_msg_count => x_msg_count
4921: , x_locator_current_volume => l_locator_current_cubic_area

Line 5502: INV_LOC_WMS_UTILS.cal_locator_current_volume(

5498: IF p_content_lpn_id IS NULL THEN
5499: IF (l_debug = 1) THEN
5500: mdebug(l_proc_name||'The p_content_id is null -case Unpack ');
5501: END IF;
5502: INV_LOC_WMS_UTILS.cal_locator_current_volume(
5503: x_return_status => x_return_status
5504: , x_msg_data => x_msg_data
5505: , x_msg_count => x_msg_count
5506: , x_locator_current_volume => l_locator_current_cubic_area

Line 5529: INV_LOC_WMS_UTILS.cal_locator_current_volume(

5525: IF (l_debug = 1) THEN
5526: mdebug(l_proc_name||'The P_content_lpn_id is not null -case Unpack ');
5527: END IF;
5528:
5529: INV_LOC_WMS_UTILS.cal_locator_current_volume(
5530: x_return_status => x_return_status
5531: , x_msg_data => x_msg_data
5532: , x_msg_count => x_msg_count
5533: , x_locator_current_volume => l_locator_current_cubic_area

Line 5694: INV_LOC_WMS_UTILS.cal_locator_current_volume(

5690: IF p_content_lpn_id IS NULL THEN
5691: IF (l_debug = 1) THEN
5692: mdebug(l_proc_name||'The p_content_id is null -case pack ');
5693: END IF;
5694: INV_LOC_WMS_UTILS.cal_locator_current_volume(
5695: x_return_status => x_return_status
5696: , x_msg_data => x_msg_data
5697: , x_msg_count => x_msg_count
5698: , x_locator_current_volume => l_locator_current_cubic_area

Line 5720: INV_LOC_WMS_UTILS.cal_locator_current_volume(

5716: -------------------------------------------------------------------------------------------------*/
5717: IF (l_debug = 1) THEN
5718: mdebug(l_proc_name||'The P_content_lpn_id is not null -case pack ');
5719: END IF;
5720: INV_LOC_WMS_UTILS.cal_locator_current_volume(
5721: x_return_status => x_return_status
5722: , x_msg_data => x_msg_data
5723: , x_msg_count => x_msg_count
5724: , x_locator_current_volume => l_locator_current_cubic_area

Line 6305: INV_LOC_WMS_UTILS.upd_lpn_loc_curr_cpty_nauto

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,
6307: x_msg_count =>l_msg_count,
6308: x_msg_data =>l_msg_data,
6309: p_organization_id => p_organization_id,

Line 6361: ( 'inv_loc_wms_utils'

6357: x_return_status := fnd_api.g_ret_sts_unexp_error;
6358: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
6359: THEN
6360: fnd_msg_pub.add_exc_msg
6361: ( 'inv_loc_wms_utils'
6362: , 'update_lpn_loc_curr_capacity'
6363: );
6364: END IF;
6365: fnd_msg_pub.count_and_get

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

6386: IF (l_debug = 1) THEN
6387: INV_TRX_UTIL_PUB.TRACE('In LPN_LOC_CAPACITY_clean_up Procedure ','lpn_loc_capacity_clean_up',9);
6388: END IF;
6389:
6390: INV_LOC_WMS_UTILS.LPN_LOC_CURRENT_CAPACITY (x_return_status =>l_return_status,
6391: x_msg_count =>l_msg_count,
6392: x_msg_data => x_msg_data,
6393: p_organization_id =>p_organization_id,
6394: p_mixed_flag => p_mixed_flag);

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

6408: IF (l_debug = 1) THEN
6409: INV_TRX_UTIL_PUB.TRACE('Before call to lpn_loc_cleanup_mmtt','lpn_loc_capacity_clean_up',9);
6410: END IF;
6411:
6412: INV_LOC_WMS_UTILS.lpn_loc_cleanup_mmtt(x_return_status =>l_return_status,
6413: x_msg_count =>l_msg_count,
6414: x_msg_data =>l_msg_data,
6415: p_organization_id =>p_organization_id,
6416: p_mixed_flag =>p_mixed_flag);

Line 6466: ( 'INV_LOC_WMS_UTILS',

6462: --rollback;
6463: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
6464: THEN
6465: fnd_msg_pub.add_exc_msg
6466: ( 'INV_LOC_WMS_UTILS',
6467: 'lpn_loc_capacity_clean_up'
6468: );
6469: END IF;
6470: fnd_msg_pub.count_and_get

Line 6681: ( 'inv_loc_wms_utils'

6677: x_return_status := fnd_api.g_ret_sts_unexp_error;
6678: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
6679: THEN
6680: fnd_msg_pub.add_exc_msg
6681: ( 'inv_loc_wms_utils'
6682: , 'cal_locator_current_volume'
6683: );
6684: END IF;
6685: fnd_msg_pub.count_and_get

Line 6769: INV_LOC_WMS_UTILS.item_attributes( l_return_status,

6765: );
6766: END IF;
6767:
6768: IF l_container_item_id is not null THEN
6769: INV_LOC_WMS_UTILS.item_attributes( l_return_status,
6770: l_msg_data,
6771: l_msg_count,
6772: L_CONTAINER_ITEM_WT_UOM_CODE,
6773: l_container_item_unit_weight,

Line 6919: ( 'inv_loc_wms_utils'

6915: x_return_status := fnd_api.g_ret_sts_unexp_error;
6916: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
6917: THEN
6918: fnd_msg_pub.add_exc_msg
6919: ( 'inv_loc_wms_utils'
6920: , 'lpn_attributes'
6921: );
6922: END IF;
6923: fnd_msg_pub.count_and_get

Line 7198: ( 'inv_loc_wms_utils'

7194: x_return_status := fnd_api.g_ret_sts_unexp_error;
7195: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
7196: THEN
7197: fnd_msg_pub.add_exc_msg
7198: ( 'inv_loc_wms_utils'
7199: , 'item_attributes'
7200: );
7201: END IF;
7202: fnd_msg_pub.count_and_get

Line 7229: INV_LOC_WMS_UTILS.LOC_EMPTY_MIXED_FLAG (

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 (
7230: X_RETURN_STATUS => l_return_status
7231: , X_MSG_COUNT => l_MSG_COUNT
7232: , X_MSG_DATA => l_MSG_DATA
7233: , P_ORGANIZATION_ID => p_organization_id

Line 7277: ( 'inv_loc_wms_utils'

7273: x_return_status := fnd_api.g_ret_sts_unexp_error;
7274: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
7275: THEN
7276: fnd_msg_pub.add_exc_msg
7277: ( 'inv_loc_wms_utils'
7278: , 'LOC_EMPTY_MIXED_FLAG_AUTO'
7279: );
7280: END IF;
7281: fnd_msg_pub.count_and_get

Line 7396: INV_LOC_WMS_UTILS.inv_loc_receipt (x_return_status => X_return_status

7392: IF (l_debug = 1) THEN
7393: INV_TRX_UTIL_PUB.TRACE('Receipt transaction ','LOC_EMPTY_MIXED_FLAG',10);
7394: END IF;
7395:
7396: INV_LOC_WMS_UTILS.inv_loc_receipt (x_return_status => X_return_status
7397: ,X_MSG_COUNT => X_msg_count
7398: ,X_MSG_DATA => X_msg_data
7399: ,X_EMPTY_FLAG => l_empty_flag
7400: ,X_MIXED_FLAG => l_mixed_flag

Line 7424: INV_LOC_WMS_UTILS.inv_loc_issues (x_return_status => X_return_status

7420: IF (l_debug = 1) THEN
7421: INV_TRX_UTIL_PUB.TRACE('Issue transaction ','LOC_EMPTY_MIXED_FLAG',10);
7422: END IF;
7423:
7424: INV_LOC_WMS_UTILS.inv_loc_issues (x_return_status => X_return_status
7425: ,X_MSG_COUNT => X_msg_count
7426: ,X_MSG_DATA => X_msg_data
7427: ,X_EMPTY_FLAG => l_empty_flag
7428: ,X_MIXED_FLAG => l_mixed_flag

Line 7515: INV_LOC_WMS_UTILS.inv_loc_receipt (

7511: IF (l_debug = 1) THEN
7512: INV_TRX_UTIL_PUB.TRACE('Before call to Receipt transaction ', 'LOC_EMPTY_MIXED_FLAG',10);
7513: END IF;
7514:
7515: INV_LOC_WMS_UTILS.inv_loc_receipt (
7516: x_return_status => X_return_status
7517: ,X_MSG_COUNT => X_msg_count
7518: ,X_MSG_DATA => X_msg_data
7519: ,X_EMPTY_FLAG => l_empty_flag

Line 7565: INV_LOC_WMS_UTILS.inv_loc_issues(x_return_status => X_return_status

7561: IF (l_debug = 1) THEN
7562: INV_TRX_UTIL_PUB.TRACE('Before call to Issue transaction ','LOC_EMPTY_MIXED_FLAG',10);
7563: END IF;
7564:
7565: INV_LOC_WMS_UTILS.inv_loc_issues(x_return_status => X_return_status
7566: ,X_MSG_COUNT => X_msg_count
7567: ,X_MSG_DATA => X_msg_data
7568: ,X_EMPTY_FLAG => l_empty_flag
7569: ,X_MIXED_FLAG => l_mixed_flag

Line 7641: ( 'inv_loc_wms_utils'

7637: ROLLBACK TO loc_empty; --1334632
7638: -- ROLLBACK; -- 13816420 missed to comment out by 13346632
7639: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
7640: fnd_msg_pub.add_exc_msg
7641: ( 'inv_loc_wms_utils'
7642: , 'LOC_EMPTY_MIXED_FLAG '
7643: );
7644: END IF;
7645: fnd_msg_pub.count_and_get

Line 7806: ( 'inv_loc_wms_utils'

7802: WHEN OTHERS THEN
7803: x_return_status := fnd_api.g_ret_sts_unexp_error;
7804: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
7805: fnd_msg_pub.add_exc_msg
7806: ( 'inv_loc_wms_utils'
7807: , 'inv_loc_issues'
7808: );
7809: END IF;
7810: fnd_msg_pub.count_and_get

Line 7904: ( 'inv_loc_wms_utils'

7900: x_return_status := fnd_api.g_ret_sts_unexp_error;
7901:
7902: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
7903: fnd_msg_pub.add_exc_msg
7904: ( 'inv_loc_wms_utils'
7905: , 'lpn_loc_receipt'
7906: );
7907: END IF;
7908:

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

7986: IF l_mmtt_cur_mixed_flg.transaction_action_id in (2,3,28) then
7987: if l_mmtt_cur_mixed_flg.transfer_organization is null then
7988: l_mmtt_cur_mixed_flg.transfer_organization := l_mmtt_cur_mixed_flg.organization_id;
7989: end if;
7990: INV_LOC_WMS_UTILS.upd_lpn_loc_curr_cpty_nauto(x_return_status => l_return_status,
7991: x_msg_count => l_msg_count ,
7992: x_msg_data => l_msg_data ,
7993: p_organization_id => l_mmtt_cur_mixed_flg.transfer_organization,
7994: p_inventory_location_id => l_mmtt_cur_mixed_flg.transfer_to_location,

Line 8016: INV_LOC_WMS_UTILS.LOC_EMPTY_MIXED_FLAG (

8012: END IF;
8013: RAISE fnd_api.g_exc_unexpected_error;
8014: END IF;
8015:
8016: INV_LOC_WMS_UTILS.LOC_EMPTY_MIXED_FLAG (
8017: X_RETURN_STATUS => l_return_status
8018: ,X_MSG_COUNT => l_MSG_COUNT
8019: ,X_MSG_DATA => l_MSG_DATA
8020: ,P_ORGANIZATION_ID => l_mmtt_cur_mixed_flg.organization_id

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

8037: RAISE fnd_api.g_exc_unexpected_error;
8038: END IF;
8039:
8040: ELSE /* For transaction_action_id not in (2,3,28) */
8041: INV_LOC_WMS_UTILS.upd_lpn_loc_curr_cpty_nauto(x_return_status => l_return_status,
8042: x_msg_count => l_msg_count ,
8043: x_msg_data => l_msg_data ,
8044: p_organization_id => l_mmtt_cur_mixed_flg.organization_id,
8045: p_inventory_location_id => l_mmtt_cur_mixed_flg.locator_id,

Line 8067: INV_LOC_WMS_UTILS.LOC_EMPTY_MIXED_FLAG (

8063: END IF;
8064: RAISE fnd_api.g_exc_unexpected_error;
8065: END IF;
8066:
8067: INV_LOC_WMS_UTILS.LOC_EMPTY_MIXED_FLAG (
8068: X_RETURN_STATUS => l_return_status
8069: ,X_MSG_COUNT => l_MSG_COUNT
8070: ,X_MSG_DATA => l_MSG_DATA
8071: ,P_ORGANIZATION_ID => l_mmtt_cur_mixed_flg.organization_id

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

8103: IF l_mmtt_cur.transaction_action_id in (2,3,28) then
8104: if l_mmtt_cur.transfer_organization is null then
8105: l_mmtt_cur.transfer_organization := l_mmtt_cur.organization_id;
8106: end if;
8107: INV_LOC_WMS_UTILS.upd_lpn_loc_curr_cpty_nauto(x_return_status => l_return_status,
8108: x_msg_count => l_msg_count ,
8109: x_msg_data => l_msg_data ,
8110: p_organization_id => l_mmtt_cur.transfer_organization,
8111: p_inventory_location_id => l_mmtt_cur.transfer_to_location,

Line 8133: INV_LOC_WMS_UTILS.LOC_EMPTY_MIXED_FLAG (

8129: END IF;
8130: RAISE fnd_api.g_exc_unexpected_error;
8131: END IF;
8132:
8133: INV_LOC_WMS_UTILS.LOC_EMPTY_MIXED_FLAG (
8134: X_RETURN_STATUS => l_return_status
8135: ,X_MSG_COUNT => l_MSG_COUNT
8136: ,X_MSG_DATA => l_MSG_DATA
8137: ,P_ORGANIZATION_ID => l_mmtt_cur.organization_id

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

8154: RAISE fnd_api.g_exc_unexpected_error;
8155: END IF;
8156:
8157: ELSE /* For transaction_action_id not in (2,3,28) */
8158: INV_LOC_WMS_UTILS.upd_lpn_loc_curr_cpty_nauto(x_return_status => l_return_status,
8159: x_msg_count => l_msg_count ,
8160: x_msg_data => l_msg_data ,
8161: p_organization_id => l_mmtt_cur.organization_id,
8162: p_inventory_location_id => l_mmtt_cur.locator_id,

Line 8184: INV_LOC_WMS_UTILS.LOC_EMPTY_MIXED_FLAG (

8180: END IF;
8181: RAISE fnd_api.g_exc_unexpected_error;
8182: END IF;
8183:
8184: INV_LOC_WMS_UTILS.LOC_EMPTY_MIXED_FLAG (
8185: X_RETURN_STATUS => l_return_status
8186: ,X_MSG_COUNT => l_MSG_COUNT
8187: ,X_MSG_DATA => l_MSG_DATA
8188: ,P_ORGANIZATION_ID => l_mmtt_cur.organization_id

Line 8271: ( 'INV_LOC_WMS_UTILS',

8267: --rollback;
8268: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
8269: THEN
8270: fnd_msg_pub.add_exc_msg
8271: ( 'INV_LOC_WMS_UTILS',
8272: 'lpn_loc_cleanup_mmtt'
8273: );
8274: END IF;
8275: fnd_msg_pub.count_and_get

Line 8559: ( 'INV_LOC_WMS_UTILS',

8555: --rollback;
8556: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
8557: THEN
8558: fnd_msg_pub.add_exc_msg
8559: ( 'INV_LOC_WMS_UTILS',
8560: 'LPN_LOC_CURRENT_CAPACITY'
8561: );
8562: END IF;
8563: fnd_msg_pub.count_and_get

Line 8676: ( 'inv_loc_wms_utils'

8672: x_return_status := fnd_api.g_ret_sts_unexp_error;
8673:
8674: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
8675: fnd_msg_pub.add_exc_msg
8676: ( 'inv_loc_wms_utils'
8677: , 'upd_empty_mixed_flag_rcv_loc'
8678: );
8679: END IF;
8680:

Line 8856: END inv_loc_wms_utils;

8852:
8853: inv_trx_util_pub.TRACE(' p_source 1 is - '|| p_source , 'get_source_type', 4);
8854: END get_source_type;
8855:
8856: END inv_loc_wms_utils;