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_TRX_UTIL_PUB

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 3359: INV_TRX_UTIL_PUB.TRACE('After commit' ||

3355: -- For logging purpose
3356: l_commit_count := l_commit_count + 1;
3357:
3358: IF (l_debug = 1) THEN
3359: INV_TRX_UTIL_PUB.TRACE('After commit' ||
3360: ', commit count: ' || to_char(l_commit_count) ||
3361: ', last locator: ' || to_char(t_locator.last) ,
3362: 'Locator_Capacity_Clean_Up',9);
3363: END IF;

Line 3371: INV_TRX_UTIL_PUB.TRACE('End ','Locator_Capacity_Clean_Up',9);

3367:
3368: close c_all_locators;
3369:
3370: IF (l_debug = 1) THEN
3371: INV_TRX_UTIL_PUB.TRACE('End ','Locator_Capacity_Clean_Up',9);
3372: END IF;
3373:
3374: EXCEPTION
3375: WHEN fnd_api.g_exc_error THEN

Line 3451: INV_TRX_UTIL_PUB.TRACE('Locator capacity calc prog completed with Errors ', 'launch Upgrade',9);

3447:
3448: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
3449: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
3450: IF (l_debug = 1) THEN
3451: INV_TRX_UTIL_PUB.TRACE('Locator capacity calc prog completed with Errors ', 'launch Upgrade',9);
3452: END IF;
3453: RAISE fnd_api.g_exc_error;
3454: ELSE
3455: IF (l_debug = 1) THEN

Line 3456: INV_TRX_UTIL_PUB.TRACE('Locator capacity calc prog completed with Unexp errors ', 'launch Upgrade',9);

3452: END IF;
3453: RAISE fnd_api.g_exc_error;
3454: ELSE
3455: IF (l_debug = 1) THEN
3456: INV_TRX_UTIL_PUB.TRACE('Locator capacity calc prog completed with Unexp errors ', 'launch Upgrade',9);
3457: END IF;
3458: RAISE fnd_api.g_exc_unexpected_error;
3459: END IF;
3460: ELSE

Line 3462: INV_TRX_UTIL_PUB.TRACE('Locator capacity calc prog completed successfully ', 'launch Upgrade',9);

3458: RAISE fnd_api.g_exc_unexpected_error;
3459: END IF;
3460: ELSE
3461: IF (l_debug = 1) THEN
3462: INV_TRX_UTIL_PUB.TRACE('Locator capacity calc prog completed successfully ', 'launch Upgrade',9);
3463: END IF;
3464: print_message();
3465: l_conc_status := fnd_concurrent.set_completion_status('NORMAL','NORMAL');
3466: x_retcode := RETCODE_SUCCESS;

Line 5959: INV_TRX_UTIL_PUB.TRACE('In LPN_LOC_CAPACITY_clean_up Procedure ','lpn_loc_capacity_clean_up',9);

5955: x_return_status := fnd_api.g_ret_sts_success;
5956:
5957: savepoint lpn_loc_cleanup;
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,

Line 5970: INV_TRX_UTIL_PUB.TRACE('Call to LPN_LOC_current_CAPACITY failed with Status E ','lpn_loc_capacity_clean_up',9);

5966: p_mixed_flag => p_mixed_flag);
5967:
5968: IF X_RETURN_STATUS =fnd_api.g_ret_sts_error THEN
5969: IF (l_debug = 1) THEN
5970: INV_TRX_UTIL_PUB.TRACE('Call to LPN_LOC_current_CAPACITY failed with Status E ','lpn_loc_capacity_clean_up',9);
5971: END IF;
5972: RAISE fnd_api.g_exc_error;
5973: ELSIF X_RETURN_STATUS =fnd_api.g_ret_sts_unexp_error THEN
5974: IF (l_debug = 1) THEN

Line 5975: INV_TRX_UTIL_PUB.TRACE('Call to LPN_LOC_current_CAPACITY failed with status U','lpn_loc_capacity_clean_up',9);

5971: END IF;
5972: RAISE fnd_api.g_exc_error;
5973: ELSIF X_RETURN_STATUS =fnd_api.g_ret_sts_unexp_error THEN
5974: IF (l_debug = 1) THEN
5975: INV_TRX_UTIL_PUB.TRACE('Call to LPN_LOC_current_CAPACITY failed with status U','lpn_loc_capacity_clean_up',9);
5976: END IF;
5977: RAISE fnd_api.g_exc_unexpected_error;
5978: END IF;
5979:

Line 5981: INV_TRX_UTIL_PUB.TRACE('Before call to lpn_loc_cleanup_mmtt','lpn_loc_capacity_clean_up',9);

5977: RAISE fnd_api.g_exc_unexpected_error;
5978: END IF;
5979:
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,

Line 5992: INV_TRX_UTIL_PUB.TRACE('Call to lpn_loc_cleanup_mmtt failed with status E','lpn_loc_capacity_clean_up',9);

5988: p_mixed_flag =>p_mixed_flag);
5989:
5990: IF X_RETURN_STATUS =fnd_api.g_ret_sts_error THEN
5991: IF (l_debug = 1) THEN
5992: INV_TRX_UTIL_PUB.TRACE('Call to lpn_loc_cleanup_mmtt failed with status E','lpn_loc_capacity_clean_up',9);
5993: END IF;
5994: RAISE fnd_api.g_exc_error;
5995: ELSIF X_RETURN_STATUS =fnd_api.g_ret_sts_unexp_error THEN
5996: IF (l_debug = 1) THEN

Line 5997: INV_TRX_UTIL_PUB.TRACE('Call to lpn_loc_cleanup_mmtt failed with status U','lpn_loc_capacity_clean_up',9);

5993: END IF;
5994: RAISE fnd_api.g_exc_error;
5995: ELSIF X_RETURN_STATUS =fnd_api.g_ret_sts_unexp_error THEN
5996: IF (l_debug = 1) THEN
5997: INV_TRX_UTIL_PUB.TRACE('Call to lpn_loc_cleanup_mmtt failed with status U','lpn_loc_capacity_clean_up',9);
5998: END IF;
5999: RAISE fnd_api.g_exc_unexpected_error;
6000: END IF;
6001:

Line 6327: INV_TRX_UTIL_PUB.TRACE('The p_lpn_id '||to_char(p_lpn_id),'LPN-ATTRIBUTE-UPDATE_LPN_LOC',9);

6323: null;
6324: end;
6325:
6326: IF (l_debug = 1) THEN
6327: INV_TRX_UTIL_PUB.TRACE('The p_lpn_id '||to_char(p_lpn_id),'LPN-ATTRIBUTE-UPDATE_LPN_LOC',9);
6328: INV_TRX_UTIL_PUB.TRACE('The attribute of the lpn_id are :'||
6329: 'l_gross_weight_uom_code :'||l_gross_weight_uom_code ||
6330: 'l_content_volume_uom_code :'||l_content_volume_uom_code ||
6331: 'l_Subinventory_code :'||l_subinventory_code||

Line 6328: INV_TRX_UTIL_PUB.TRACE('The attribute of the lpn_id are :'||

6324: end;
6325:
6326: IF (l_debug = 1) THEN
6327: INV_TRX_UTIL_PUB.TRACE('The p_lpn_id '||to_char(p_lpn_id),'LPN-ATTRIBUTE-UPDATE_LPN_LOC',9);
6328: INV_TRX_UTIL_PUB.TRACE('The attribute of the lpn_id are :'||
6329: 'l_gross_weight_uom_code :'||l_gross_weight_uom_code ||
6330: 'l_content_volume_uom_code :'||l_content_volume_uom_code ||
6331: 'l_Subinventory_code :'||l_subinventory_code||
6332: 'l_gross_weight '||to_char(l_gross_weight)||

Line 6361: INV_TRX_UTIL_PUB.TRACE('Error fetching container item attributes - '||l_return_status , 'LPN-ATTRIBUTE-UPDATE_LPN_LOC',4);

6357: 'Y'
6358: );
6359: IF l_return_status =fnd_api.g_ret_sts_error THEN
6360: IF (l_debug = 1) THEN
6361: INV_TRX_UTIL_PUB.TRACE('Error fetching container item attributes - '||l_return_status , 'LPN-ATTRIBUTE-UPDATE_LPN_LOC',4);
6362: END IF;
6363: RAISE fnd_api.g_exc_error;
6364: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
6365: IF (l_debug = 1) THEN

Line 6366: INV_TRX_UTIL_PUB.TRACE('Error fetching container item attributes - '||l_return_status , 'LPN-ATTRIBUTE-UPDATE_LPN_LOC',4);

6362: END IF;
6363: RAISE fnd_api.g_exc_error;
6364: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
6365: IF (l_debug = 1) THEN
6366: INV_TRX_UTIL_PUB.TRACE('Error fetching container item attributes - '||l_return_status , 'LPN-ATTRIBUTE-UPDATE_LPN_LOC',4);
6367: END IF;
6368: RAISE fnd_api.g_exc_unexpected_error;
6369: END IF;
6370: END IF;

Line 6378: INV_TRX_UTIL_PUB.TRACE('Gross_weight_uom_weight code different from container item weight uom code', 'LPN-ATTRIBUTE-UPDATE_LPN_LOC',4);

6374: l_container_item_unit_weight >0 THEN
6375: IF (l_gross_weight_uom_code <> L_CONTAINER_ITEM_WT_UOM_CODE) THEN
6376:
6377: IF (l_debug = 1) THEN
6378: INV_TRX_UTIL_PUB.TRACE('Gross_weight_uom_weight code different from container item weight uom code', 'LPN-ATTRIBUTE-UPDATE_LPN_LOC',4);
6379: END IF;
6380: l_container_item_xacted_weight := inv_convert.inv_um_convert(
6381: item_id => null,
6382: precision => null,

Line 6397: INV_TRX_UTIL_PUB.TRACE('l_container_item_xacted_weight is '||to_char(l_container_item_xacted_weight), 'LPN-ATTRIBUTE-UPDATE_LPN_LOC',4);

6393: IF l_container_item_xacted_weight = -99999 THEN
6394: RAISE fnd_api.g_exc_error;
6395: END IF;
6396: IF (l_debug = 1) THEN
6397: INV_TRX_UTIL_PUB.TRACE('l_container_item_xacted_weight is '||to_char(l_container_item_xacted_weight), 'LPN-ATTRIBUTE-UPDATE_LPN_LOC',4);
6398: END IF;
6399: END IF;
6400:
6401: IF l_content_volume_uom_code is not null AND

Line 6419: INV_TRX_UTIL_PUB.TRACE('l_container_item_xacted_volume is '||to_char(l_container_item_xacted_volume), 'LPN-ATTRIBUTE-UPDATE_LPN_LOC',4);

6415: ELSE
6416: l_container_item_xacted_volume := l_container_item_unit_volume;
6417: END IF;
6418: IF (l_debug = 1) THEN
6419: INV_TRX_UTIL_PUB.TRACE('l_container_item_xacted_volume is '||to_char(l_container_item_xacted_volume), 'LPN-ATTRIBUTE-UPDATE_LPN_LOC',4);
6420: END IF;
6421: IF l_container_item_xacted_volume = -99999 THEN
6422: RAISE fnd_api.g_exc_error;
6423: END IF;

Line 6428: INV_TRX_UTIL_PUB.TRACE('The weight and volume of the Container item are :'||

6424:
6425: END IF;
6426:
6427: IF (l_debug = 1) THEN
6428: INV_TRX_UTIL_PUB.TRACE('The weight and volume of the Container item are :'||
6429: 'l_container_item_unit_weight :'||to_char(l_container_item_unit_weight) ||
6430: 'L_CONTAINER_ITEM_WT_UOM_CODE :'||L_CONTAINER_ITEM_WT_UOM_CODE ||
6431: 'l_container_item_unit_volume :'||to_char(l_container_item_unit_volume)||
6432: 'l_container_item_vol_uom_code'||l_container_item_vol_uom_code

Line 6543: INV_TRX_UTIL_PUB.TRACE('The attributes of p_inventory_item are :' ||

6539: inventory_item_id = p_inventory_item_id and
6540: organization_id = p_organization_id;
6541:
6542: IF (l_debug = 1) THEN
6543: INV_TRX_UTIL_PUB.TRACE('The attributes of p_inventory_item are :' ||
6544: 'l_item_primary_uom_code :'||l_item_primary_uom_code ||
6545: 'l_item_weight_uom_code :'||l_item_weight_uom_code ||
6546: 'l_item_unit_weight :'||to_char(l_item_unit_weight)||
6547: 'l_item_volume_uom_code :'||l_item_volume_uom_code ||

Line 6554: INV_TRX_UTIL_PUB.TRACE('The item_unit_weight is either < 0 or null','UPD_LPN_LOC-ITEM_ATTRIBUTES',4);

6550: END IF;
6551:
6552: IF l_item_unit_weight IS NULL THEN
6553: IF (l_debug = 1) THEN
6554: INV_TRX_UTIL_PUB.TRACE('The item_unit_weight is either < 0 or null','UPD_LPN_LOC-ITEM_ATTRIBUTES',4);
6555: END IF;
6556: l_item_unit_weight := 0;
6557: ELSIF l_item_unit_volume IS NULL THEN
6558: IF (l_debug = 1) THEN

Line 6559: INV_TRX_UTIL_PUB.TRACE('The item_unit_volume is either < 0 or null','UPD_LPN_LOC-ITEM_ATTRIBUTES',4);

6555: END IF;
6556: l_item_unit_weight := 0;
6557: ELSIF l_item_unit_volume IS NULL THEN
6558: IF (l_debug = 1) THEN
6559: INV_TRX_UTIL_PUB.TRACE('The item_unit_volume is either < 0 or null','UPD_LPN_LOC-ITEM_ATTRIBUTES',4);
6560: END IF;
6561: l_item_unit_volume := 0;
6562: END IF;
6563:

Line 6620: INV_TRX_UTIL_PUB.TRACE('Item passed is a container item ','UPD_LPN_LOC-ITEM_ATTRIBUTES',4);

6616: x_item_xacted_weight := null;
6617: x_item_xacted_volume := null;
6618:
6619: IF (l_debug = 1) THEN
6620: INV_TRX_UTIL_PUB.TRACE('Item passed is a container item ','UPD_LPN_LOC-ITEM_ATTRIBUTES',4);
6621: END IF;
6622:
6623: ELSE /* Item passed is not a container item */
6624:

Line 6629: INV_TRX_UTIL_PUB.TRACE('The value of primary_uom_flag <>y or PUOM is not equal to Transaction UOM', 'UPDATE_LPN_LOC_CURR_CAPACITY',9);

6625: IF l_primary_uom_code <> p_transaction_uom_code and p_primary_uom_flag <>'Y' THEN
6626:
6627: /* Convert the transaction_uom_qty into primary_uom_quantity if p_primary_uom_quantity_flag <>Y */
6628: IF (l_debug = 1) THEN
6629: INV_TRX_UTIL_PUB.TRACE('The value of primary_uom_flag <>y or PUOM is not equal to Transaction UOM', 'UPDATE_LPN_LOC_CURR_CAPACITY',9);
6630: END IF;
6631:
6632: l_quantity := inv_convert.inv_um_convert(item_id => p_inventory_item_id,
6633: precision => null,

Line 6648: INV_TRX_UTIL_PUB.TRACE('The value of l_quantity is '||to_char(l_quantity),'UPD_LPN_LOC-ITEM_ATTRIBUTES',4);

6644: IF l_quantity = -99999 THEN
6645: RAISE fnd_api.g_exc_error;
6646: END IF;
6647: IF (l_debug = 1) THEN
6648: INV_TRX_UTIL_PUB.TRACE('The value of l_quantity is '||to_char(l_quantity),'UPD_LPN_LOC-ITEM_ATTRIBUTES',4);
6649: END IF;
6650:
6651: /* Check if the weight and volume uom code of item and locator are different.
6652: If so convert the weight and volume code of item in terms of locator weight

Line 6661: INV_TRX_UTIL_PUB.TRACE('check if the p_locator_weight_uom_code and l_item_weight_uom_code are same or not', 'UPD_LPN_LOC-ITEM_ATTRIBUTES',4);

6657: p_locator_weight_uom_code is not null AND
6658: l_item_unit_weight >0 THEN
6659:
6660: IF (l_debug = 1) THEN
6661: INV_TRX_UTIL_PUB.TRACE('check if the p_locator_weight_uom_code and l_item_weight_uom_code are same or not', 'UPD_LPN_LOC-ITEM_ATTRIBUTES',4);
6662: END IF;
6663:
6664: l_item_xacted_weight := l_quantity *l_item_unit_weight;
6665:

Line 6668: INV_TRX_UTIL_PUB.TRACE('p_locator_weight_uom_code and l_item_weight_uom_code are not same', 'UPD_LPN_LOC-ITEM_ATTRIBUTES',4);

6664: l_item_xacted_weight := l_quantity *l_item_unit_weight;
6665:
6666: IF (l_item_weight_uom_code <> p_locator_weight_uom_code) THEN
6667: IF (l_debug = 1) THEN
6668: INV_TRX_UTIL_PUB.TRACE('p_locator_weight_uom_code and l_item_weight_uom_code are not same', 'UPD_LPN_LOC-ITEM_ATTRIBUTES',4);
6669: END IF;
6670:
6671: l_item_xacted_weight := inv_convert.inv_um_convert(
6672: item_id => p_inventory_item_id,

Line 6687: INV_TRX_UTIL_PUB.TRACE('The value of l_item_xacted_weight is ' ||to_char(l_item_xacted_weight), 'UPD_LPN_LOC-ITEM_ATTRIBUTES',4);

6683: END IF;
6684: END IF;
6685:
6686: IF (l_debug = 1) THEN
6687: INV_TRX_UTIL_PUB.TRACE('The value of l_item_xacted_weight is ' ||to_char(l_item_xacted_weight), 'UPD_LPN_LOC-ITEM_ATTRIBUTES',4);
6688: END IF;
6689:
6690: IF l_item_volume_uom_code IS NOT NULL and
6691: p_locator_volume_uom_code IS NOT NULL and

Line 6699: INV_TRX_UTIL_PUB.TRACE('p_locator_volume_uom_code and l_item_volume_uom_code are same or not', 'UPD_LPN_LOC-ITEM_ATTRIBUTES',4);

6695:
6696: IF l_item_volume_uom_code <> p_locator_volume_uom_code THEN
6697:
6698: IF (l_debug = 1) THEN
6699: INV_TRX_UTIL_PUB.TRACE('p_locator_volume_uom_code and l_item_volume_uom_code are same or not', 'UPD_LPN_LOC-ITEM_ATTRIBUTES',4);
6700: END IF;
6701:
6702: l_item_xacted_volume := inv_convert.inv_um_convert(item_id => p_inventory_item_id,
6703: precision => null,

Line 6724: INV_TRX_UTIL_PUB.TRACE('The value of l_item_xacted_volume is ' ||to_char(l_item_xacted_volume), 'UPD_LPN_LOC-ITEM_ATTRIBUTES',4);

6720: x_item_xacted_weight := nvl(l_item_xacted_weight,0);
6721: x_item_xacted_volume := nvl(l_item_xacted_volume,0);
6722:
6723: IF (l_debug = 1) THEN
6724: INV_TRX_UTIL_PUB.TRACE('The value of l_item_xacted_volume is ' ||to_char(l_item_xacted_volume), 'UPD_LPN_LOC-ITEM_ATTRIBUTES',4);
6725: END IF;
6726:
6727: END IF; /* End of p_container_item =Y */
6728: EXCEPTION

Line 6861: INV_TRX_UTIL_PUB.TRACE('In LOC_EMPTY_MIXED_FLAG Procedure ','LOC_EMPTY_MIXED_FLAG',10);

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;
6863:
6864: -- Fixed bug 2342723, remove the savepoint
6865: -- savepoint loc_empty;

Line 6908: INV_TRX_UTIL_PUB.TRACE('Receipt transaction ','LOC_EMPTY_MIXED_FLAG',10);

6904: ** out the inventory Item id column in MIL.
6905: */
6906:
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

Line 6924: INV_TRX_UTIL_PUB.TRACE('Failed for Receipt transaction with status -E ', 'LOC_EMPTY_MIXED_FLAG',9);

6920: ) ;
6921:
6922: IF X_RETURN_STATUS =fnd_api.g_ret_sts_error THEN
6923: IF (l_debug = 1) THEN
6924: INV_TRX_UTIL_PUB.TRACE('Failed for Receipt transaction with status -E ', 'LOC_EMPTY_MIXED_FLAG',9);
6925: END IF;
6926: RAISE fnd_api.g_exc_error;
6927: ELSIF X_RETURN_STATUS =fnd_api.g_ret_sts_unexp_error THEN
6928: IF (l_debug = 1) THEN

Line 6929: INV_TRX_UTIL_PUB.TRACE('Failed for Receipt transaction with status -U ', 'LOC_EMPTY_MIXED_FLAG',9);

6925: END IF;
6926: RAISE fnd_api.g_exc_error;
6927: ELSIF X_RETURN_STATUS =fnd_api.g_ret_sts_unexp_error THEN
6928: IF (l_debug = 1) THEN
6929: INV_TRX_UTIL_PUB.TRACE('Failed for Receipt transaction with status -U ', 'LOC_EMPTY_MIXED_FLAG',9);
6930: END IF;
6931: RAISE fnd_api.g_exc_unexpected_error;
6932: END IF;
6933:

Line 6936: INV_TRX_UTIL_PUB.TRACE('Issue transaction ','LOC_EMPTY_MIXED_FLAG',10);

6932: END IF;
6933:
6934: ELSIF P_TRANSACTION_ACTION_ID in (1,21,32,34) /* Issue */ THEN
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

Line 6952: INV_TRX_UTIL_PUB.TRACE('Failed for Issue transaction with status -E ', 'LOC_EMPTY_MIXED_FLAG',9);

6948: ,P_SOURCE =>p_source
6949: ) ;
6950: IF X_RETURN_STATUS =fnd_api.g_ret_sts_error THEN
6951: IF (l_debug = 1) THEN
6952: INV_TRX_UTIL_PUB.TRACE('Failed for Issue transaction with status -E ', 'LOC_EMPTY_MIXED_FLAG',9);
6953: END IF;
6954: RAISE fnd_api.g_exc_error;
6955: ELSIF X_RETURN_STATUS =fnd_api.g_ret_sts_unexp_error THEN
6956: IF (l_debug = 1) THEN

Line 6957: INV_TRX_UTIL_PUB.TRACE('Failed for Issue transaction with status - U', 'LOC_EMPTY_MIXED_FLAG',9);

6953: END IF;
6954: RAISE fnd_api.g_exc_error;
6955: ELSIF X_RETURN_STATUS =fnd_api.g_ret_sts_unexp_error THEN
6956: IF (l_debug = 1) THEN
6957: INV_TRX_UTIL_PUB.TRACE('Failed for Issue transaction with status - U', 'LOC_EMPTY_MIXED_FLAG',9);
6958: END IF;
6959: RAISE fnd_api.g_exc_unexpected_error;
6960: END IF;
6961: ELSIF p_transaction_action_id in(2,3,28) /* TRANSFER */ THEN

Line 6964: INV_TRX_UTIL_PUB.TRACE('Transfer transaction ','LOC_EMPTY_MIXED_FLAG',10);

6960: END IF;
6961: ELSIF p_transaction_action_id in(2,3,28) /* TRANSFER */ THEN
6962:
6963: IF (l_debug = 1) THEN
6964: INV_TRX_UTIL_PUB.TRACE('Transfer transaction ','LOC_EMPTY_MIXED_FLAG',10);
6965: END IF;
6966:
6967: if (p_transfer_location_id > 0) then
6968: /* For the destination organization */

Line 7000: INV_TRX_UTIL_PUB.TRACE('Before call to Receipt transaction ', 'LOC_EMPTY_MIXED_FLAG',10);

6996: mdebug('After locking destination locator ' || l_des_inventory_location_id || ' in LOC_EMPTY_MIXED_FLAG(2)');
6997: END IF;
6998:
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

Line 7016: INV_TRX_UTIL_PUB.TRACE('Failed for Receipt transaction with status -E ', 'LOC_EMPTY_MIXED_FLAG',9);

7012: ,P_INVENTORY_ITEM_ID => P_INVENTORY_ITEM_ID
7013: ) ;
7014: IF X_RETURN_STATUS =fnd_api.g_ret_sts_error THEN
7015: IF (l_debug = 1) THEN
7016: INV_TRX_UTIL_PUB.TRACE('Failed for Receipt transaction with status -E ', 'LOC_EMPTY_MIXED_FLAG',9);
7017: END IF;
7018: RAISE fnd_api.g_exc_error;
7019: ELSIF X_RETURN_STATUS =fnd_api.g_ret_sts_unexp_error THEN
7020: IF (l_debug = 1) THEN

Line 7021: INV_TRX_UTIL_PUB.TRACE('Failed for Receipt transaction with status -U ', 'LOC_EMPTY_MIXED_FLAG',9);

7017: END IF;
7018: RAISE fnd_api.g_exc_error;
7019: ELSIF X_RETURN_STATUS =fnd_api.g_ret_sts_unexp_error THEN
7020: IF (l_debug = 1) THEN
7021: INV_TRX_UTIL_PUB.TRACE('Failed for Receipt transaction with status -U ', 'LOC_EMPTY_MIXED_FLAG',9);
7022: END IF;
7023: RAISE fnd_api.g_exc_unexpected_error;
7024: END IF;
7025:

Line 7027: INV_TRX_UTIL_PUB.TRACE('Before Updating destination locator ', 'LOC_EMPTY_MIXED_FLAG',10);

7023: RAISE fnd_api.g_exc_unexpected_error;
7024: END IF;
7025:
7026: IF (l_debug = 1) THEN
7027: INV_TRX_UTIL_PUB.TRACE('Before Updating destination locator ', 'LOC_EMPTY_MIXED_FLAG',10);
7028: INV_TRX_UTIL_PUB.TRACE('The values of Empty _Flag is '||l_empty_flag , 'LOC_EMPTY_MIXED_FLAG',10);
7029: INV_TRX_UTIL_PUB.TRACE('The values of Mixed_Flag is '||l_mixed_flag , 'LOC_EMPTY_MIXED_FLAG',10);
7030: INV_TRX_UTIL_PUB.TRACE('The values of Item ID is '||l_item_id , 'LOC_EMPTY_MIXED_FLAG',10);
7031: END IF;

Line 7028: INV_TRX_UTIL_PUB.TRACE('The values of Empty _Flag is '||l_empty_flag , 'LOC_EMPTY_MIXED_FLAG',10);

7024: END IF;
7025:
7026: IF (l_debug = 1) THEN
7027: INV_TRX_UTIL_PUB.TRACE('Before Updating destination locator ', 'LOC_EMPTY_MIXED_FLAG',10);
7028: INV_TRX_UTIL_PUB.TRACE('The values of Empty _Flag is '||l_empty_flag , 'LOC_EMPTY_MIXED_FLAG',10);
7029: INV_TRX_UTIL_PUB.TRACE('The values of Mixed_Flag is '||l_mixed_flag , 'LOC_EMPTY_MIXED_FLAG',10);
7030: INV_TRX_UTIL_PUB.TRACE('The values of Item ID is '||l_item_id , 'LOC_EMPTY_MIXED_FLAG',10);
7031: END IF;
7032:

Line 7029: INV_TRX_UTIL_PUB.TRACE('The values of Mixed_Flag is '||l_mixed_flag , 'LOC_EMPTY_MIXED_FLAG',10);

7025:
7026: IF (l_debug = 1) THEN
7027: INV_TRX_UTIL_PUB.TRACE('Before Updating destination locator ', 'LOC_EMPTY_MIXED_FLAG',10);
7028: INV_TRX_UTIL_PUB.TRACE('The values of Empty _Flag is '||l_empty_flag , 'LOC_EMPTY_MIXED_FLAG',10);
7029: INV_TRX_UTIL_PUB.TRACE('The values of Mixed_Flag is '||l_mixed_flag , 'LOC_EMPTY_MIXED_FLAG',10);
7030: INV_TRX_UTIL_PUB.TRACE('The values of Item ID is '||l_item_id , 'LOC_EMPTY_MIXED_FLAG',10);
7031: END IF;
7032:
7033: UPDATE MTL_ITEM_LOCATIONS mil

Line 7030: INV_TRX_UTIL_PUB.TRACE('The values of Item ID is '||l_item_id , 'LOC_EMPTY_MIXED_FLAG',10);

7026: IF (l_debug = 1) THEN
7027: INV_TRX_UTIL_PUB.TRACE('Before Updating destination locator ', 'LOC_EMPTY_MIXED_FLAG',10);
7028: INV_TRX_UTIL_PUB.TRACE('The values of Empty _Flag is '||l_empty_flag , 'LOC_EMPTY_MIXED_FLAG',10);
7029: INV_TRX_UTIL_PUB.TRACE('The values of Mixed_Flag is '||l_mixed_flag , 'LOC_EMPTY_MIXED_FLAG',10);
7030: INV_TRX_UTIL_PUB.TRACE('The values of Item ID is '||l_item_id , 'LOC_EMPTY_MIXED_FLAG',10);
7031: END IF;
7032:
7033: UPDATE MTL_ITEM_LOCATIONS mil
7034: SET EMPTY_FLAG = nvl(l_empty_flag,mil.empty_flag)

Line 7046: INV_TRX_UTIL_PUB.TRACE('Before call to Issue transaction ','LOC_EMPTY_MIXED_FLAG',10);

7042:
7043: /* For the Source Organization */
7044:
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

Line 7062: INV_TRX_UTIL_PUB.TRACE('Failed for Issue transaction with status -E ', 'LOC_EMPTY_MIXED_FLAG',9);

7058: ,P_SOURCE =>p_source
7059: ) ;
7060: IF X_RETURN_STATUS =fnd_api.g_ret_sts_error THEN
7061: IF (l_debug = 1) THEN
7062: INV_TRX_UTIL_PUB.TRACE('Failed for Issue transaction with status -E ', 'LOC_EMPTY_MIXED_FLAG',9);
7063: END IF;
7064: RAISE fnd_api.g_exc_error;
7065: ELSIF X_RETURN_STATUS =fnd_api.g_ret_sts_unexp_error THEN
7066: IF (l_debug = 1) THEN

Line 7067: INV_TRX_UTIL_PUB.TRACE('Failed for Issue transaction with status - U', 'LOC_EMPTY_MIXED_FLAG',9);

7063: END IF;
7064: RAISE fnd_api.g_exc_error;
7065: ELSIF X_RETURN_STATUS =fnd_api.g_ret_sts_unexp_error THEN
7066: IF (l_debug = 1) THEN
7067: INV_TRX_UTIL_PUB.TRACE('Failed for Issue transaction with status - U', 'LOC_EMPTY_MIXED_FLAG',9);
7068: END IF;
7069: RAISE fnd_api.g_exc_unexpected_error;
7070: END IF;
7071: END IF; /* End if for the transaction_action_id */

Line 7074: INV_TRX_UTIL_PUB.TRACE('The values of Empty _Flag is '|| l_empty_flag , 'LOC_EMPTY_MIXED_FLAG',10);

7070: END IF;
7071: END IF; /* End if for the transaction_action_id */
7072:
7073: IF (l_debug = 1) THEN
7074: INV_TRX_UTIL_PUB.TRACE('The values of Empty _Flag is '|| l_empty_flag , 'LOC_EMPTY_MIXED_FLAG',10);
7075: INV_TRX_UTIL_PUB.TRACE('The values of Mixed_Flag is '|| l_mixed_flag , 'LOC_EMPTY_MIXED_FLAG',10);
7076: INV_TRX_UTIL_PUB.TRACE('The values of Item ID is '|| l_item_id , 'LOC_EMPTY_MIXED_FLAG',10);
7077: END IF;
7078:

Line 7075: INV_TRX_UTIL_PUB.TRACE('The values of Mixed_Flag is '|| l_mixed_flag , 'LOC_EMPTY_MIXED_FLAG',10);

7071: END IF; /* End if for the transaction_action_id */
7072:
7073: IF (l_debug = 1) THEN
7074: INV_TRX_UTIL_PUB.TRACE('The values of Empty _Flag is '|| l_empty_flag , 'LOC_EMPTY_MIXED_FLAG',10);
7075: INV_TRX_UTIL_PUB.TRACE('The values of Mixed_Flag is '|| l_mixed_flag , 'LOC_EMPTY_MIXED_FLAG',10);
7076: INV_TRX_UTIL_PUB.TRACE('The values of Item ID is '|| l_item_id , 'LOC_EMPTY_MIXED_FLAG',10);
7077: END IF;
7078:
7079: --Bug#2756609. Should update empty_flag and mixed_items_flag only if

Line 7076: INV_TRX_UTIL_PUB.TRACE('The values of Item ID is '|| l_item_id , 'LOC_EMPTY_MIXED_FLAG',10);

7072:
7073: IF (l_debug = 1) THEN
7074: INV_TRX_UTIL_PUB.TRACE('The values of Empty _Flag is '|| l_empty_flag , 'LOC_EMPTY_MIXED_FLAG',10);
7075: INV_TRX_UTIL_PUB.TRACE('The values of Mixed_Flag is '|| l_mixed_flag , 'LOC_EMPTY_MIXED_FLAG',10);
7076: INV_TRX_UTIL_PUB.TRACE('The values of Item ID is '|| l_item_id , 'LOC_EMPTY_MIXED_FLAG',10);
7077: END IF;
7078:
7079: --Bug#2756609. Should update empty_flag and mixed_items_flag only if
7080: --the values passed are not null.

Line 7091: INV_TRX_UTIL_PUB.TRACE('End of Procedure LOC_EMPTY_MIXED_FLAG ', 'LOC_EMPTY_MIXED_FLAG',10);

7087: WHERE INVENTORY_LOCATION_ID = l_inventory_location_id
7088: AND ORGANIZATION_ID = P_ORGANIZATION_ID;
7089:
7090: IF (l_debug = 1) THEN
7091: INV_TRX_UTIL_PUB.TRACE('End of Procedure LOC_EMPTY_MIXED_FLAG ', 'LOC_EMPTY_MIXED_FLAG',10);
7092: END IF;
7093: EXCEPTION
7094: WHEN fnd_api.g_exc_error THEN
7095: x_return_status := fnd_api.g_ret_sts_error;

Line 7164: INV_TRX_UTIL_PUB.TRACE('In Procedure inv_loc_issues ','inv_loc_issues',10);

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);
7165: END IF;
7166:
7167: x_return_status := FND_API.G_RET_STS_SUCCESS;
7168:

Line 7172: INV_TRX_UTIL_PUB.TRACE('P_Source is null ','inv_loc_issues',10);

7168:
7169: IF P_SOURCE IS NULL THEN
7170:
7171: IF (l_debug = 1) THEN
7172: INV_TRX_UTIL_PUB.TRACE('P_Source is null ','inv_loc_issues',10);
7173: END IF;
7174:
7175: SELECT LOCATION_CURRENT_UNITS,
7176: location_suggested_units,

Line 7193: INV_TRX_UTIL_PUB.TRACE('Current/Suggested units is 0 ','inv_loc_issues',10);

7189: IF ((nvl(l_loc_current_units,0) = 0) and
7190: (nvl(l_loc_suggested_units,0) = 0)) THEN
7191:
7192: IF (l_debug = 1) THEN
7193: INV_TRX_UTIL_PUB.TRACE('Current/Suggested units is 0 ','inv_loc_issues',10);
7194: END IF;
7195: x_empty_flag := 'Y';
7196: x_mixed_flag := 'N';
7197: x_item_id := null;

Line 7205: INV_TRX_UTIL_PUB.TRACE('P_Source is not null ','inv_loc_issues',10);

7201: x_item_id := l_inventory_item_id;
7202: END IF;
7203: ELSE
7204: IF (l_debug = 1) THEN
7205: INV_TRX_UTIL_PUB.TRACE('P_Source is not null ','inv_loc_issues',10);
7206: END IF;
7207: BEGIN
7208: SELECT 1
7209: INTO l_chk_flag

Line 7218: INV_TRX_UTIL_PUB.TRACE('Item exists in MOQD ','inv_loc_issues',10);

7214: AND ORGANIZATION_ID = P_ORG_ID
7215: AND INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID
7216: );
7217: IF (l_debug = 1) THEN
7218: INV_TRX_UTIL_PUB.TRACE('Item exists in MOQD ','inv_loc_issues',10);
7219: END IF;
7220: BEGIN
7221: SELECT 1
7222: INTO l_chk_flag

Line 7235: INV_TRX_UTIL_PUB.TRACE('More than one item exists in locator ', 'inv_loc_issues',10);

7231: x_mixed_flag :='Y';
7232: x_item_id := NULL;
7233:
7234: IF (l_debug = 1) THEN
7235: INV_TRX_UTIL_PUB.TRACE('More than one item exists in locator ', 'inv_loc_issues',10);
7236: END IF;
7237: EXCEPTION
7238: WHEN NO_DATA_FOUND THEN
7239: IF (l_debug = 1) THEN

Line 7240: INV_TRX_UTIL_PUB.TRACE('Only one item exists in locator', 'inv_loc_issues',10);

7236: END IF;
7237: EXCEPTION
7238: WHEN NO_DATA_FOUND THEN
7239: IF (l_debug = 1) THEN
7240: INV_TRX_UTIL_PUB.TRACE('Only one item exists in locator', 'inv_loc_issues',10);
7241: END IF;
7242: x_empty_flag :='N';
7243: x_mixed_flag :='N';
7244: x_item_id := p_inventory_item_id;

Line 7249: INV_TRX_UTIL_PUB.TRACE('Item passed does not exists in MOQD ', 'inv_loc_issues',10);

7245: END;
7246: EXCEPTION
7247: WHEN NO_DATA_FOUND THEN
7248: IF (l_debug = 1) THEN
7249: INV_TRX_UTIL_PUB.TRACE('Item passed does not exists in MOQD ', 'inv_loc_issues',10);
7250: END IF;
7251: open item_cnt;
7252: loop
7253: fetch item_cnt into l_item;

Line 7258: INV_TRX_UTIL_PUB.TRACE('Locator is empty','inv_loc_issues',10);

7254: exit when item_cnt%notfound or item_cnt%rowcount =2;
7255: end loop;
7256: IF item_cnt%rowcount =0 THEN
7257: IF (l_debug = 1) THEN
7258: INV_TRX_UTIL_PUB.TRACE('Locator is empty','inv_loc_issues',10);
7259: END IF;
7260: x_empty_flag := 'Y';
7261: x_mixed_flag := 'N';
7262: x_item_id := null;

Line 7265: INV_TRX_UTIL_PUB.TRACE('One item alone exists in the locator', 'inv_loc_issues',10);

7261: x_mixed_flag := 'N';
7262: x_item_id := null;
7263: ELSIF item_cnt%rowcount =1 THEN
7264: IF (l_debug = 1) THEN
7265: INV_TRX_UTIL_PUB.TRACE('One item alone exists in the locator', 'inv_loc_issues',10);
7266: END IF;
7267: x_empty_flag := 'N';
7268: x_mixed_flag := 'N';
7269: x_item_id := l_item.inventory_item_id;

Line 7272: INV_TRX_UTIL_PUB.TRACE('More than one item alone exists in the locator', 'inv_loc_issues',10);

7268: x_mixed_flag := 'N';
7269: x_item_id := l_item.inventory_item_id;
7270: ELSIF item_cnt%rowcount =2 THEN
7271: IF (l_debug = 1) THEN
7272: INV_TRX_UTIL_PUB.TRACE('More than one item alone exists in the locator', 'inv_loc_issues',10);
7273: END IF;
7274: x_empty_flag := 'N';
7275: x_mixed_flag := 'Y';
7276: x_item_id := null;

Line 7314: INV_TRX_UTIL_PUB.TRACE('In Procedure inv_loc_receipt ','receipts',10);

7310: BEGIN
7311: x_return_status := FND_API.G_RET_STS_SUCCESS;
7312:
7313: IF (l_debug = 1) THEN
7314: INV_TRX_UTIL_PUB.TRACE('In Procedure inv_loc_receipt ','receipts',10);
7315: END IF;
7316: --Added to get subinventory bug3237709
7317: SELECT subinventory_code
7318: INTO l_subinventory_code

Line 7366: INV_TRX_UTIL_PUB.TRACE('More than 1 item exists in the locator','inv_loc_receipts',10);

7362: X_mixed_flag := 'Y';
7363: X_item_id := NULL;
7364:
7365: IF (l_debug = 1) THEN
7366: INV_TRX_UTIL_PUB.TRACE('More than 1 item exists in the locator','inv_loc_receipts',10);
7367: END IF;
7368:
7369: EXCEPTION
7370: WHEN NO_DATA_FOUND THEN

Line 7372: INV_TRX_UTIL_PUB.TRACE('Only one item exists in the locator','inv_loc_receipts',10);

7368:
7369: EXCEPTION
7370: WHEN NO_DATA_FOUND THEN
7371: IF (l_debug = 1) THEN
7372: INV_TRX_UTIL_PUB.TRACE('Only one item exists in the locator','inv_loc_receipts',10);
7373: END IF;
7374: X_EMPTY_FLAG := 'N';
7375: x_mixed_flag := 'N';
7376: x_item_id := P_INVENTORY_ITEM_ID;

Line 7463: INV_TRX_UTIL_PUB.TRACE('Fetch from mmtt_cur_mixed_flg is success','LPN_LOC_CLEANUP_MMTT',4);

7459: loop
7460: fetch mmtt_cur_mixed_flg into l_mmtt_cur_mixed_flg;
7461: exit when mmtt_cur_mixed_flg%NOTFOUND;
7462: IF (l_debug = 1) THEN
7463: INV_TRX_UTIL_PUB.TRACE('Fetch from mmtt_cur_mixed_flg is success','LPN_LOC_CLEANUP_MMTT',4);
7464: END IF;
7465:
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

Line 7486: INV_TRX_UTIL_PUB.TRACE('Loc cpty calc -Transfer case- failed with status E','LPN_LOC_CLEANUP_MMTT',10);

7482: p_quantity => l_mmtt_cur_mixed_flg.primary_quantity
7483: );
7484: IF X_RETURN_STATUS =fnd_api.g_ret_sts_error THEN
7485: IF (l_debug = 1) THEN
7486: INV_TRX_UTIL_PUB.TRACE('Loc cpty calc -Transfer case- failed with status E','LPN_LOC_CLEANUP_MMTT',10);
7487: END IF;
7488: RAISE fnd_api.g_exc_error;
7489: ELSIF X_RETURN_STATUS =fnd_api.g_ret_sts_unexp_error THEN
7490: IF (l_debug = 1) THEN

Line 7491: INV_TRX_UTIL_PUB.TRACE('Loc cpty calc-Transfer case- failed with status U','LPN_LOC_CLEANUP_MMTT',10);

7487: END IF;
7488: RAISE fnd_api.g_exc_error;
7489: ELSIF X_RETURN_STATUS =fnd_api.g_ret_sts_unexp_error THEN
7490: IF (l_debug = 1) THEN
7491: INV_TRX_UTIL_PUB.TRACE('Loc cpty calc-Transfer case- failed with status U','LPN_LOC_CLEANUP_MMTT',10);
7492: END IF;
7493: RAISE fnd_api.g_exc_unexpected_error;
7494: END IF;
7495:

Line 7510: INV_TRX_UTIL_PUB.TRACE('LOC_EMPTY_MIXED-Transfer Case failed with status E','LPN_LOC_CLEANUP_MMTT',10);

7506: ,P_SOURCE => 'CONCURRENT'
7507: );
7508: IF X_RETURN_STATUS =fnd_api.g_ret_sts_error THEN
7509: IF (l_debug = 1) THEN
7510: INV_TRX_UTIL_PUB.TRACE('LOC_EMPTY_MIXED-Transfer Case failed with status E','LPN_LOC_CLEANUP_MMTT',10);
7511: END IF;
7512: RAISE fnd_api.g_exc_error;
7513: ELSIF X_RETURN_STATUS =fnd_api.g_ret_sts_unexp_error THEN
7514: IF (l_debug = 1) THEN

Line 7515: INV_TRX_UTIL_PUB.TRACE('LOC_EMPTY_MIXED-Transfer case failed with status U','LPN_LOC_CLEANUP_MMTT',10);

7511: END IF;
7512: RAISE fnd_api.g_exc_error;
7513: ELSIF X_RETURN_STATUS =fnd_api.g_ret_sts_unexp_error THEN
7514: IF (l_debug = 1) THEN
7515: INV_TRX_UTIL_PUB.TRACE('LOC_EMPTY_MIXED-Transfer case failed with status U','LPN_LOC_CLEANUP_MMTT',10);
7516: END IF;
7517: RAISE fnd_api.g_exc_unexpected_error;
7518: END IF;
7519:

Line 7537: INV_TRX_UTIL_PUB.TRACE('Loc cpty calc - failed with status E','LPN_LOC_CLEANUP_MMTT',10);

7533: p_quantity => l_mmtt_cur_mixed_flg.primary_quantity
7534: );
7535: IF X_RETURN_STATUS =fnd_api.g_ret_sts_error THEN
7536: IF (l_debug = 1) THEN
7537: INV_TRX_UTIL_PUB.TRACE('Loc cpty calc - failed with status E','LPN_LOC_CLEANUP_MMTT',10);
7538: END IF;
7539: RAISE fnd_api.g_exc_error;
7540: ELSIF X_RETURN_STATUS =fnd_api.g_ret_sts_unexp_error THEN
7541: IF (l_debug = 1) THEN

Line 7542: INV_TRX_UTIL_PUB.TRACE('Loc cpty calc - failed with status U','LPN_LOC_CLEANUP_MMTT',10);

7538: END IF;
7539: RAISE fnd_api.g_exc_error;
7540: ELSIF X_RETURN_STATUS =fnd_api.g_ret_sts_unexp_error THEN
7541: IF (l_debug = 1) THEN
7542: INV_TRX_UTIL_PUB.TRACE('Loc cpty calc - failed with status U','LPN_LOC_CLEANUP_MMTT',10);
7543: END IF;
7544: RAISE fnd_api.g_exc_unexpected_error;
7545: END IF;
7546:

Line 7561: INV_TRX_UTIL_PUB.TRACE('LOC_EMPTY_MIXED failed with status E','LPN_LOC_CLEANUP_MMTT',10);

7557: ,P_SOURCE => 'CONCURRENT'
7558: );
7559: IF X_RETURN_STATUS =fnd_api.g_ret_sts_error THEN
7560: IF (l_debug = 1) THEN
7561: INV_TRX_UTIL_PUB.TRACE('LOC_EMPTY_MIXED failed with status E','LPN_LOC_CLEANUP_MMTT',10);
7562: END IF;
7563: RAISE fnd_api.g_exc_error;
7564: ELSIF X_RETURN_STATUS =fnd_api.g_ret_sts_unexp_error THEN
7565: IF (l_debug = 1) THEN

Line 7566: INV_TRX_UTIL_PUB.TRACE('LOC_EMPTY_MIXED failed with status U','LPN_LOC_CLEANUP_MMTT',10);

7562: END IF;
7563: RAISE fnd_api.g_exc_error;
7564: ELSIF X_RETURN_STATUS =fnd_api.g_ret_sts_unexp_error THEN
7565: IF (l_debug = 1) THEN
7566: INV_TRX_UTIL_PUB.TRACE('LOC_EMPTY_MIXED failed with status U','LPN_LOC_CLEANUP_MMTT',10);
7567: END IF;
7568: RAISE fnd_api.g_exc_unexpected_error;
7569: END IF;
7570:

Line 7581: INV_TRX_UTIL_PUB.TRACE('Fetch from mmtt_cur is success','LPN_LOC_CLEANUP_MMTT',10);

7577: LOOP
7578: FETCH mmtt_cur into l_mmtt_cur ;
7579: exit when mmtt_cur%NOTFOUND;
7580: IF (l_debug = 1) THEN
7581: INV_TRX_UTIL_PUB.TRACE('Fetch from mmtt_cur is success','LPN_LOC_CLEANUP_MMTT',10);
7582: END IF;
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;

Line 7603: INV_TRX_UTIL_PUB.TRACE('Loc cpty calc -Transfer case- failed with status E','LPN_LOC_CLEANUP_MMTT',10);

7599: p_quantity => l_mmtt_cur.primary_quantity
7600: );
7601: IF X_RETURN_STATUS =fnd_api.g_ret_sts_error THEN
7602: IF (l_debug = 1) THEN
7603: INV_TRX_UTIL_PUB.TRACE('Loc cpty calc -Transfer case- failed with status E','LPN_LOC_CLEANUP_MMTT',10);
7604: END IF;
7605: RAISE fnd_api.g_exc_error;
7606: ELSIF X_RETURN_STATUS =fnd_api.g_ret_sts_unexp_error THEN
7607: IF (l_debug = 1) THEN

Line 7608: INV_TRX_UTIL_PUB.TRACE('Loc cpty calc -Transfer case- failed with status U','LPN_LOC_CLEANUP_MMTT',10);

7604: END IF;
7605: RAISE fnd_api.g_exc_error;
7606: ELSIF X_RETURN_STATUS =fnd_api.g_ret_sts_unexp_error THEN
7607: IF (l_debug = 1) THEN
7608: INV_TRX_UTIL_PUB.TRACE('Loc cpty calc -Transfer case- failed with status U','LPN_LOC_CLEANUP_MMTT',10);
7609: END IF;
7610: RAISE fnd_api.g_exc_unexpected_error;
7611: END IF;
7612:

Line 7627: INV_TRX_UTIL_PUB.TRACE('LOC_EMPTY_MIXED-Transfer Case failed with status E','LPN_LOC_CLEANUP_MMTT',10);

7623: ,P_SOURCE => 'CONCURRENT'
7624: );
7625: IF X_RETURN_STATUS =fnd_api.g_ret_sts_error THEN
7626: IF (l_debug = 1) THEN
7627: INV_TRX_UTIL_PUB.TRACE('LOC_EMPTY_MIXED-Transfer Case failed with status E','LPN_LOC_CLEANUP_MMTT',10);
7628: END IF;
7629: RAISE fnd_api.g_exc_error;
7630: ELSIF X_RETURN_STATUS =fnd_api.g_ret_sts_unexp_error THEN
7631: IF (l_debug = 1) THEN

Line 7632: INV_TRX_UTIL_PUB.TRACE('LOC_EMPTY_MIXED-Transfer Case failed with status U','LPN_LOC_CLEANUP_MMTT',10);

7628: END IF;
7629: RAISE fnd_api.g_exc_error;
7630: ELSIF X_RETURN_STATUS =fnd_api.g_ret_sts_unexp_error THEN
7631: IF (l_debug = 1) THEN
7632: INV_TRX_UTIL_PUB.TRACE('LOC_EMPTY_MIXED-Transfer Case failed with status U','LPN_LOC_CLEANUP_MMTT',10);
7633: END IF;
7634: RAISE fnd_api.g_exc_unexpected_error;
7635: END IF;
7636:

Line 7654: INV_TRX_UTIL_PUB.TRACE('Loc cpty calc - failed with status E','LPN_LOC_CLEANUP_MMTT',10);

7650: p_quantity => l_mmtt_cur.primary_quantity
7651: );
7652: IF X_RETURN_STATUS =fnd_api.g_ret_sts_error THEN
7653: IF (l_debug = 1) THEN
7654: INV_TRX_UTIL_PUB.TRACE('Loc cpty calc - failed with status E','LPN_LOC_CLEANUP_MMTT',10);
7655: END IF;
7656: RAISE fnd_api.g_exc_error;
7657: ELSIF X_RETURN_STATUS =fnd_api.g_ret_sts_unexp_error THEN
7658: IF (l_debug = 1) THEN

Line 7659: INV_TRX_UTIL_PUB.TRACE('Loc cpty calc - failed with status U','LPN_LOC_CLEANUP_MMTT',10);

7655: END IF;
7656: RAISE fnd_api.g_exc_error;
7657: ELSIF X_RETURN_STATUS =fnd_api.g_ret_sts_unexp_error THEN
7658: IF (l_debug = 1) THEN
7659: INV_TRX_UTIL_PUB.TRACE('Loc cpty calc - failed with status U','LPN_LOC_CLEANUP_MMTT',10);
7660: END IF;
7661: RAISE fnd_api.g_exc_unexpected_error;
7662: END IF;
7663:

Line 7678: INV_TRX_UTIL_PUB.TRACE('LOC_EMPTY_MIXED failed with Return status E','LPN_LOC_CLEANUP_MMTT',10);

7674: ,P_SOURCE => 'CONCURRENT'
7675: );
7676: IF X_RETURN_STATUS =fnd_api.g_ret_sts_error THEN
7677: IF (l_debug = 1) THEN
7678: INV_TRX_UTIL_PUB.TRACE('LOC_EMPTY_MIXED failed with Return status E','LPN_LOC_CLEANUP_MMTT',10);
7679: END IF;
7680: RAISE fnd_api.g_exc_error;
7681: ELSIF X_RETURN_STATUS =fnd_api.g_ret_sts_unexp_error THEN
7682: RAISE fnd_api.g_exc_unexpected_error;

Line 7684: INV_TRX_UTIL_PUB.TRACE('LOC_EMPTY_MIXED failed with Return status U','LPN_LOC_CLEANUP_MMTT',10);

7680: RAISE fnd_api.g_exc_error;
7681: ELSIF X_RETURN_STATUS =fnd_api.g_ret_sts_unexp_error THEN
7682: RAISE fnd_api.g_exc_unexpected_error;
7683: IF (l_debug = 1) THEN
7684: INV_TRX_UTIL_PUB.TRACE('LOC_EMPTY_MIXED failed with Return status U','LPN_LOC_CLEANUP_MMTT',10);
7685: END IF;
7686: END IF;
7687: END IF;
7688: END LOOP;

Line 7691: INV_TRX_UTIL_PUB.TRACE('successful Completion of LPN_LOC_CLEANUP_MMTT ','LPN_LOC_CLEANUP_MMTT',10);

7687: END IF;
7688: END LOOP;
7689: CLOSE mmtt_cur;
7690: IF (l_debug = 1) THEN
7691: INV_TRX_UTIL_PUB.TRACE('successful Completion of LPN_LOC_CLEANUP_MMTT ','LPN_LOC_CLEANUP_MMTT',10);
7692: END IF;
7693: END IF;
7694: EXCEPTION
7695:

Line 7846: INV_TRX_UTIL_PUB.TRACE('In LPN_LOC_CURRENT_CAPACITY Procedure ','LPN_LOC_CURRENT_CAPACITY',9);

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;
7848: x_return_status := fnd_api.g_ret_sts_success;
7849: --Fixed bug 2342723, romoved the savepoint
7850: -- Bug 3511690 savepoint retained

Line 7863: INV_TRX_UTIL_PUB.TRACE('Curr_cpty_mixed_flag is successful ','LPN_LOC_CURRENT_CAPACITY',10);

7859: processing.Else we have to use the inventory_location_id
7860: for further processing
7861: */
7862: IF (l_debug = 1) THEN
7863: INV_TRX_UTIL_PUB.TRACE('Curr_cpty_mixed_flag is successful ','LPN_LOC_CURRENT_CAPACITY',10);
7864: END IF;
7865: l_inventory_location_id :=null;
7866: l_physical_locator_id :=null;
7867: l_locator_id :=null;

Line 7886: INV_TRX_UTIL_PUB.TRACE('The value of locator _id is '||to_char(l_inventory_location_id), 'LPN_LOC_CURRENT_CAPACITY',10);

7882: /* Update current weight and current cubic area of the locator with the
7883: LPN's gross weight and content volume
7884: */
7885: IF (l_debug = 1) THEN
7886: INV_TRX_UTIL_PUB.TRACE('The value of locator _id is '||to_char(l_inventory_location_id), 'LPN_LOC_CURRENT_CAPACITY',10);
7887: INV_TRX_UTIL_PUB.TRACE('The value of org_id is'||to_char(p_organization_id),'LPN_LOC_CURRENT_CAPACITY',10);
7888: INV_TRX_UTIL_PUB.TRACE('The value of gross_weight is '||to_char(l_curr_cpty.gross_weight), 'LPN_LOC_CURRENT_CAPACITY',10);
7889: INV_TRX_UTIL_PUB.TRACE('The value of content_volume is '||to_char(l_curr_cpty.content_volume), 'LPN_LOC_CURRENT_CAPACITY',10);
7890: END IF;

Line 7887: INV_TRX_UTIL_PUB.TRACE('The value of org_id is'||to_char(p_organization_id),'LPN_LOC_CURRENT_CAPACITY',10);

7883: LPN's gross weight and content volume
7884: */
7885: IF (l_debug = 1) THEN
7886: INV_TRX_UTIL_PUB.TRACE('The value of locator _id is '||to_char(l_inventory_location_id), 'LPN_LOC_CURRENT_CAPACITY',10);
7887: INV_TRX_UTIL_PUB.TRACE('The value of org_id is'||to_char(p_organization_id),'LPN_LOC_CURRENT_CAPACITY',10);
7888: INV_TRX_UTIL_PUB.TRACE('The value of gross_weight is '||to_char(l_curr_cpty.gross_weight), 'LPN_LOC_CURRENT_CAPACITY',10);
7889: INV_TRX_UTIL_PUB.TRACE('The value of content_volume is '||to_char(l_curr_cpty.content_volume), 'LPN_LOC_CURRENT_CAPACITY',10);
7890: END IF;
7891: begin

Line 7888: INV_TRX_UTIL_PUB.TRACE('The value of gross_weight is '||to_char(l_curr_cpty.gross_weight), 'LPN_LOC_CURRENT_CAPACITY',10);

7884: */
7885: IF (l_debug = 1) THEN
7886: INV_TRX_UTIL_PUB.TRACE('The value of locator _id is '||to_char(l_inventory_location_id), 'LPN_LOC_CURRENT_CAPACITY',10);
7887: INV_TRX_UTIL_PUB.TRACE('The value of org_id is'||to_char(p_organization_id),'LPN_LOC_CURRENT_CAPACITY',10);
7888: INV_TRX_UTIL_PUB.TRACE('The value of gross_weight is '||to_char(l_curr_cpty.gross_weight), 'LPN_LOC_CURRENT_CAPACITY',10);
7889: INV_TRX_UTIL_PUB.TRACE('The value of content_volume is '||to_char(l_curr_cpty.content_volume), 'LPN_LOC_CURRENT_CAPACITY',10);
7890: END IF;
7891: begin
7892: SELECT sum(abs(primary_transaction_quantity))

Line 7889: INV_TRX_UTIL_PUB.TRACE('The value of content_volume is '||to_char(l_curr_cpty.content_volume), 'LPN_LOC_CURRENT_CAPACITY',10);

7885: IF (l_debug = 1) THEN
7886: INV_TRX_UTIL_PUB.TRACE('The value of locator _id is '||to_char(l_inventory_location_id), 'LPN_LOC_CURRENT_CAPACITY',10);
7887: INV_TRX_UTIL_PUB.TRACE('The value of org_id is'||to_char(p_organization_id),'LPN_LOC_CURRENT_CAPACITY',10);
7888: INV_TRX_UTIL_PUB.TRACE('The value of gross_weight is '||to_char(l_curr_cpty.gross_weight), 'LPN_LOC_CURRENT_CAPACITY',10);
7889: INV_TRX_UTIL_PUB.TRACE('The value of content_volume is '||to_char(l_curr_cpty.content_volume), 'LPN_LOC_CURRENT_CAPACITY',10);
7890: END IF;
7891: begin
7892: SELECT sum(abs(primary_transaction_quantity))
7893: into l_units

Line 7923: INV_TRX_UTIL_PUB.TRACE('Fetch from current_cpty is success','LPN_LOC_CURRENT_CAPACITY',10);

7919: loop
7920: fetch current_cpty into l_curr_cpty;
7921: exit when current_cpty%notfound;
7922: IF (l_debug = 1) THEN
7923: INV_TRX_UTIL_PUB.TRACE('Fetch from current_cpty is success','LPN_LOC_CURRENT_CAPACITY',10);
7924: END IF;
7925:
7926: /* If the locator has a physical_location_id
7927: then use the physical_location_id for further

Line 7952: INV_TRX_UTIL_PUB.TRACE('The value of locator _id is '||to_char(l_inventory_location_id), 'LPN_LOC_CURRENT_CAPACITY',10);

7948: /* Update current weight and current cubic area of the locator with the
7949: LPN gross weight and content volume
7950: */
7951: IF (l_debug = 1) THEN
7952: INV_TRX_UTIL_PUB.TRACE('The value of locator _id is '||to_char(l_inventory_location_id), 'LPN_LOC_CURRENT_CAPACITY',10);
7953: INV_TRX_UTIL_PUB.TRACE('The value of org_id is'||to_char(p_organization_id),'LPN_LOC_CURRENT_CAPACITY',10);
7954: INV_TRX_UTIL_PUB.TRACE('The value of gross_weight is '||to_char(l_curr_cpty.gross_weight), 'LPN_LOC_CURRENT_CAPACITY',10);
7955: INV_TRX_UTIL_PUB.TRACE('The value of content_volume is '||to_char(l_curr_cpty.content_volume), 'LPN_LOC_CURRENT_CAPACITY',10);
7956: END IF;

Line 7953: INV_TRX_UTIL_PUB.TRACE('The value of org_id is'||to_char(p_organization_id),'LPN_LOC_CURRENT_CAPACITY',10);

7949: LPN gross weight and content volume
7950: */
7951: IF (l_debug = 1) THEN
7952: INV_TRX_UTIL_PUB.TRACE('The value of locator _id is '||to_char(l_inventory_location_id), 'LPN_LOC_CURRENT_CAPACITY',10);
7953: INV_TRX_UTIL_PUB.TRACE('The value of org_id is'||to_char(p_organization_id),'LPN_LOC_CURRENT_CAPACITY',10);
7954: INV_TRX_UTIL_PUB.TRACE('The value of gross_weight is '||to_char(l_curr_cpty.gross_weight), 'LPN_LOC_CURRENT_CAPACITY',10);
7955: INV_TRX_UTIL_PUB.TRACE('The value of content_volume is '||to_char(l_curr_cpty.content_volume), 'LPN_LOC_CURRENT_CAPACITY',10);
7956: END IF;
7957: begin

Line 7954: INV_TRX_UTIL_PUB.TRACE('The value of gross_weight is '||to_char(l_curr_cpty.gross_weight), 'LPN_LOC_CURRENT_CAPACITY',10);

7950: */
7951: IF (l_debug = 1) THEN
7952: INV_TRX_UTIL_PUB.TRACE('The value of locator _id is '||to_char(l_inventory_location_id), 'LPN_LOC_CURRENT_CAPACITY',10);
7953: INV_TRX_UTIL_PUB.TRACE('The value of org_id is'||to_char(p_organization_id),'LPN_LOC_CURRENT_CAPACITY',10);
7954: INV_TRX_UTIL_PUB.TRACE('The value of gross_weight is '||to_char(l_curr_cpty.gross_weight), 'LPN_LOC_CURRENT_CAPACITY',10);
7955: INV_TRX_UTIL_PUB.TRACE('The value of content_volume is '||to_char(l_curr_cpty.content_volume), 'LPN_LOC_CURRENT_CAPACITY',10);
7956: END IF;
7957: begin
7958: SELECT sum(abs(primary_transaction_quantity))

Line 7955: INV_TRX_UTIL_PUB.TRACE('The value of content_volume is '||to_char(l_curr_cpty.content_volume), 'LPN_LOC_CURRENT_CAPACITY',10);

7951: IF (l_debug = 1) THEN
7952: INV_TRX_UTIL_PUB.TRACE('The value of locator _id is '||to_char(l_inventory_location_id), 'LPN_LOC_CURRENT_CAPACITY',10);
7953: INV_TRX_UTIL_PUB.TRACE('The value of org_id is'||to_char(p_organization_id),'LPN_LOC_CURRENT_CAPACITY',10);
7954: INV_TRX_UTIL_PUB.TRACE('The value of gross_weight is '||to_char(l_curr_cpty.gross_weight), 'LPN_LOC_CURRENT_CAPACITY',10);
7955: INV_TRX_UTIL_PUB.TRACE('The value of content_volume is '||to_char(l_curr_cpty.content_volume), 'LPN_LOC_CURRENT_CAPACITY',10);
7956: END IF;
7957: begin
7958: SELECT sum(abs(primary_transaction_quantity))
7959: into l_units