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 2967: inv_trx_util_pub.trace('After commit'

2963: -- For logging purpose
2964: l_commit_count := l_commit_count + 1;
2965:
2966: IF (l_debug = 1) THEN
2967: inv_trx_util_pub.trace('After commit'
2968: ||', commit count: '
2969: ||to_char(l_commit_count)
2970: ||', last locator index: '
2971: ||to_char(t_physical_location_id.LAST)

Line 2978: inv_trx_util_pub.trace(t_locator(k));

2974: 'Locator_Capacity_Clean_Up',9);
2975: END IF;
2976:
2977: FOR k IN t_locator.FIRST..t_locator.LAST LOOP
2978: inv_trx_util_pub.trace(t_locator(k));
2979: END LOOP;
2980:
2981: t_location_current_units.DELETE;
2982: t_location_suggested_units.DELETE;

Line 3713: inv_trx_util_pub.trace('After commit'

3709: -- For logging purpose
3710: l_commit_count := l_commit_count + 1;
3711:
3712: IF (l_debug = 1) THEN
3713: inv_trx_util_pub.trace('After commit'
3714: ||', commit count: '
3715: ||to_char(l_commit_count)
3716: ||', last locator index: '
3717: ||to_char(t_locator.LAST),

Line 3801: inv_trx_util_pub.trace('End ','Locator_Capacity_Clean_Up',9);

3797:
3798: -- Bug 12937771 additions (End)
3799:
3800: IF (l_debug = 1) THEN
3801: inv_trx_util_pub.trace('End ','Locator_Capacity_Clean_Up',9);
3802: END IF;
3803: EXCEPTION
3804: WHEN fnd_api.g_exc_error THEN
3805: mdebug('Error:-'

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

3875:
3876: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
3877: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
3878: IF (l_debug = 1) THEN
3879: INV_TRX_UTIL_PUB.TRACE('Locator capacity calc prog completed with Errors ', 'launch Upgrade',9);
3880: END IF;
3881: RAISE fnd_api.g_exc_error;
3882: ELSE
3883: IF (l_debug = 1) THEN

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

3880: END IF;
3881: RAISE fnd_api.g_exc_error;
3882: ELSE
3883: IF (l_debug = 1) THEN
3884: INV_TRX_UTIL_PUB.TRACE('Locator capacity calc prog completed with Unexp errors ', 'launch Upgrade',9);
3885: END IF;
3886: RAISE fnd_api.g_exc_unexpected_error;
3887: END IF;
3888: ELSE

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

3886: RAISE fnd_api.g_exc_unexpected_error;
3887: END IF;
3888: ELSE
3889: IF (l_debug = 1) THEN
3890: INV_TRX_UTIL_PUB.TRACE('Locator capacity calc prog completed successfully ', 'launch Upgrade',9);
3891: END IF;
3892: print_message();
3893: l_conc_status := fnd_concurrent.set_completion_status('NORMAL','NORMAL');
3894: x_retcode := RETCODE_SUCCESS;

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

6383: x_return_status := fnd_api.g_ret_sts_success;
6384:
6385: savepoint lpn_loc_cleanup;
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,

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

6394: p_mixed_flag => p_mixed_flag);
6395:
6396: IF X_RETURN_STATUS =fnd_api.g_ret_sts_error THEN
6397: IF (l_debug = 1) THEN
6398: INV_TRX_UTIL_PUB.TRACE('Call to LPN_LOC_current_CAPACITY failed with Status E ','lpn_loc_capacity_clean_up',9);
6399: END IF;
6400: RAISE fnd_api.g_exc_error;
6401: ELSIF X_RETURN_STATUS =fnd_api.g_ret_sts_unexp_error THEN
6402: IF (l_debug = 1) THEN

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

6399: END IF;
6400: RAISE fnd_api.g_exc_error;
6401: ELSIF X_RETURN_STATUS =fnd_api.g_ret_sts_unexp_error THEN
6402: IF (l_debug = 1) THEN
6403: INV_TRX_UTIL_PUB.TRACE('Call to LPN_LOC_current_CAPACITY failed with status U','lpn_loc_capacity_clean_up',9);
6404: END IF;
6405: RAISE fnd_api.g_exc_unexpected_error;
6406: END IF;
6407:

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

6405: RAISE fnd_api.g_exc_unexpected_error;
6406: END IF;
6407:
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,

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

6416: p_mixed_flag =>p_mixed_flag);
6417:
6418: IF X_RETURN_STATUS =fnd_api.g_ret_sts_error THEN
6419: IF (l_debug = 1) THEN
6420: INV_TRX_UTIL_PUB.TRACE('Call to lpn_loc_cleanup_mmtt failed with status E','lpn_loc_capacity_clean_up',9);
6421: END IF;
6422: RAISE fnd_api.g_exc_error;
6423: ELSIF X_RETURN_STATUS =fnd_api.g_ret_sts_unexp_error THEN
6424: IF (l_debug = 1) THEN

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

6421: END IF;
6422: RAISE fnd_api.g_exc_error;
6423: ELSIF X_RETURN_STATUS =fnd_api.g_ret_sts_unexp_error THEN
6424: IF (l_debug = 1) THEN
6425: INV_TRX_UTIL_PUB.TRACE('Call to lpn_loc_cleanup_mmtt failed with status U','lpn_loc_capacity_clean_up',9);
6426: END IF;
6427: RAISE fnd_api.g_exc_unexpected_error;
6428: END IF;
6429:

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

6751: null;
6752: end;
6753:
6754: IF (l_debug = 1) THEN
6755: INV_TRX_UTIL_PUB.TRACE('The p_lpn_id '||to_char(p_lpn_id),'LPN-ATTRIBUTE-UPDATE_LPN_LOC',9);
6756: INV_TRX_UTIL_PUB.TRACE('The attribute of the lpn_id are :'||
6757: 'l_gross_weight_uom_code :'||l_gross_weight_uom_code ||
6758: 'l_content_volume_uom_code :'||l_content_volume_uom_code ||
6759: 'l_Subinventory_code :'||l_subinventory_code||

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

6752: end;
6753:
6754: IF (l_debug = 1) THEN
6755: INV_TRX_UTIL_PUB.TRACE('The p_lpn_id '||to_char(p_lpn_id),'LPN-ATTRIBUTE-UPDATE_LPN_LOC',9);
6756: INV_TRX_UTIL_PUB.TRACE('The attribute of the lpn_id are :'||
6757: 'l_gross_weight_uom_code :'||l_gross_weight_uom_code ||
6758: 'l_content_volume_uom_code :'||l_content_volume_uom_code ||
6759: 'l_Subinventory_code :'||l_subinventory_code||
6760: 'l_gross_weight '||to_char(l_gross_weight)||

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

6785: 'Y'
6786: );
6787: IF l_return_status =fnd_api.g_ret_sts_error THEN
6788: IF (l_debug = 1) THEN
6789: INV_TRX_UTIL_PUB.TRACE('Error fetching container item attributes - '||l_return_status , 'LPN-ATTRIBUTE-UPDATE_LPN_LOC',4);
6790: END IF;
6791: RAISE fnd_api.g_exc_error;
6792: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
6793: IF (l_debug = 1) THEN

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

6790: END IF;
6791: RAISE fnd_api.g_exc_error;
6792: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
6793: IF (l_debug = 1) THEN
6794: INV_TRX_UTIL_PUB.TRACE('Error fetching container item attributes - '||l_return_status , 'LPN-ATTRIBUTE-UPDATE_LPN_LOC',4);
6795: END IF;
6796: RAISE fnd_api.g_exc_unexpected_error;
6797: END IF;
6798: END IF;

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

6802: l_container_item_unit_weight >0 THEN
6803: IF (l_gross_weight_uom_code <> L_CONTAINER_ITEM_WT_UOM_CODE) THEN
6804:
6805: IF (l_debug = 1) THEN
6806: INV_TRX_UTIL_PUB.TRACE('Gross_weight_uom_weight code different from container item weight uom code', 'LPN-ATTRIBUTE-UPDATE_LPN_LOC',4);
6807: END IF;
6808: l_container_item_xacted_weight := inv_convert.inv_um_convert(
6809: item_id => null,
6810: precision => null,

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

6821: IF l_container_item_xacted_weight = -99999 THEN
6822: RAISE fnd_api.g_exc_error;
6823: END IF;
6824: IF (l_debug = 1) THEN
6825: INV_TRX_UTIL_PUB.TRACE('l_container_item_xacted_weight is '||to_char(l_container_item_xacted_weight), 'LPN-ATTRIBUTE-UPDATE_LPN_LOC',4);
6826: END IF;
6827: END IF;
6828:
6829: IF l_content_volume_uom_code is not null AND

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

6843: ELSE
6844: l_container_item_xacted_volume := l_container_item_unit_volume;
6845: END IF;
6846: IF (l_debug = 1) THEN
6847: INV_TRX_UTIL_PUB.TRACE('l_container_item_xacted_volume is '||to_char(l_container_item_xacted_volume), 'LPN-ATTRIBUTE-UPDATE_LPN_LOC',4);
6848: END IF;
6849: IF l_container_item_xacted_volume = -99999 THEN
6850: RAISE fnd_api.g_exc_error;
6851: END IF;

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

6852:
6853: END IF;
6854:
6855: IF (l_debug = 1) THEN
6856: INV_TRX_UTIL_PUB.TRACE('The weight and volume of the Container item are :'||
6857: 'l_container_item_unit_weight :'||to_char(l_container_item_unit_weight) ||
6858: 'L_CONTAINER_ITEM_WT_UOM_CODE :'||L_CONTAINER_ITEM_WT_UOM_CODE ||
6859: 'l_container_item_unit_volume :'||to_char(l_container_item_unit_volume)||
6860: 'l_container_item_vol_uom_code'||l_container_item_vol_uom_code

Line 6876: INV_TRX_UTIL_PUB.TRACE('l_gross_weight is negative', 'LPN-ATTRIBUTE-UPDATE_LPN_LOC', 4);

6872:
6873: -- Bug 12937771 additions (Start)
6874: IF l_gross_weight < 0 THEN
6875: IF (l_debug = 1) THEN
6876: INV_TRX_UTIL_PUB.TRACE('l_gross_weight is negative', 'LPN-ATTRIBUTE-UPDATE_LPN_LOC', 4);
6877: END IF;
6878: x_gross_weight := 0;
6879: ELSE
6880: x_gross_weight := NVL(l_gross_weight, 0);

Line 6885: INV_TRX_UTIL_PUB.TRACE('l_content_volume is negative', 'LPN-ATTRIBUTE-UPDATE_LPN_LOC', 4);

6881: END IF;
6882:
6883: IF l_content_volume < 0 THEN
6884: IF (l_debug = 1) THEN
6885: INV_TRX_UTIL_PUB.TRACE('l_content_volume is negative', 'LPN-ATTRIBUTE-UPDATE_LPN_LOC', 4);
6886: END IF;
6887: x_content_volume := 0;
6888: ELSE
6889: x_content_volume := NVL(l_content_volume, 0);

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

6986: inventory_item_id = p_inventory_item_id and
6987: organization_id = p_organization_id;
6988:
6989: IF (l_debug = 1) THEN
6990: INV_TRX_UTIL_PUB.TRACE('The attributes of p_inventory_item are :' ||
6991: 'l_item_primary_uom_code :'||l_item_primary_uom_code ||
6992: 'l_item_weight_uom_code :'||l_item_weight_uom_code ||
6993: 'l_item_unit_weight :'||to_char(l_item_unit_weight)||
6994: 'l_item_volume_uom_code :'||l_item_volume_uom_code ||

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

6997: END IF;
6998:
6999: IF l_item_unit_weight IS NULL THEN
7000: IF (l_debug = 1) THEN
7001: INV_TRX_UTIL_PUB.TRACE('The item_unit_weight is either < 0 or null','UPD_LPN_LOC-ITEM_ATTRIBUTES',4);
7002: END IF;
7003: l_item_unit_weight := 0;
7004: ELSIF l_item_unit_volume IS NULL THEN
7005: IF (l_debug = 1) THEN

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

7002: END IF;
7003: l_item_unit_weight := 0;
7004: ELSIF l_item_unit_volume IS NULL THEN
7005: IF (l_debug = 1) THEN
7006: INV_TRX_UTIL_PUB.TRACE('The item_unit_volume is either < 0 or null','UPD_LPN_LOC-ITEM_ATTRIBUTES',4);
7007: END IF;
7008: l_item_unit_volume := 0;
7009: END IF;
7010:

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

7063: x_item_xacted_weight := null;
7064: x_item_xacted_volume := null;
7065:
7066: IF (l_debug = 1) THEN
7067: INV_TRX_UTIL_PUB.TRACE('Item passed is a container item ','UPD_LPN_LOC-ITEM_ATTRIBUTES',4);
7068: END IF;
7069:
7070: ELSE /* Item passed is not a container item */
7071:

Line 7076: 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);

7072: IF l_primary_uom_code <> p_transaction_uom_code and p_primary_uom_flag <>'Y' THEN
7073:
7074: /* Convert the transaction_uom_qty into primary_uom_quantity if p_primary_uom_quantity_flag <>Y */
7075: IF (l_debug = 1) THEN
7076: 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);
7077: END IF;
7078:
7079: l_quantity := inv_convert.inv_um_convert(item_id => p_inventory_item_id,
7080: precision => null,

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

7091: IF l_quantity = -99999 THEN
7092: RAISE fnd_api.g_exc_error;
7093: END IF;
7094: IF (l_debug = 1) THEN
7095: INV_TRX_UTIL_PUB.TRACE('The value of l_quantity is '||to_char(l_quantity),'UPD_LPN_LOC-ITEM_ATTRIBUTES',4);
7096: END IF;
7097:
7098: /* Check if the weight and volume uom code of item and locator are different.
7099: If so convert the weight and volume code of item in terms of locator weight

Line 7108: 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);

7104: p_locator_weight_uom_code is not null AND
7105: l_item_unit_weight >0 THEN
7106:
7107: IF (l_debug = 1) THEN
7108: 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);
7109: END IF;
7110:
7111: l_item_xacted_weight := l_quantity *l_item_unit_weight;
7112:

Line 7115: 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);

7111: l_item_xacted_weight := l_quantity *l_item_unit_weight;
7112:
7113: IF (l_item_weight_uom_code <> p_locator_weight_uom_code) THEN
7114: IF (l_debug = 1) THEN
7115: 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);
7116: END IF;
7117:
7118: l_item_xacted_weight := inv_convert.inv_um_convert(
7119: item_id => p_inventory_item_id,

Line 7134: 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);

7130: END IF;
7131: END IF;
7132:
7133: IF (l_debug = 1) THEN
7134: 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);
7135: END IF;
7136:
7137: IF l_item_volume_uom_code IS NOT NULL and
7138: p_locator_volume_uom_code IS NOT NULL and

Line 7146: 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);

7142:
7143: IF l_item_volume_uom_code <> p_locator_volume_uom_code THEN
7144:
7145: IF (l_debug = 1) THEN
7146: 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);
7147: END IF;
7148:
7149: l_item_xacted_volume := inv_convert.inv_um_convert(item_id => p_inventory_item_id,
7150: precision => null,

Line 7171: 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);

7167: x_item_xacted_weight := nvl(l_item_xacted_weight,0);
7168: x_item_xacted_volume := nvl(l_item_xacted_volume,0);
7169:
7170: IF (l_debug = 1) THEN
7171: 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);
7172: END IF;
7173:
7174: END IF; /* End of p_container_item =Y */
7175: EXCEPTION

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

7314: l_locator_locked BOOLEAN := TRUE;
7315: /*11809528.ends*/
7316: BEGIN
7317: IF (l_debug = 1) THEN
7318: INV_TRX_UTIL_PUB.TRACE('In LOC_EMPTY_MIXED_FLAG Procedure ','LOC_EMPTY_MIXED_FLAG',10);
7319: END IF;
7320:
7321: -- Fixed bug 2342723, remove the savepoint
7322: savepoint loc_empty; --13346632

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

7389: ** out the inventory Item id column in MIL.
7390: */
7391:
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

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

7405: ) ;
7406:
7407: IF X_RETURN_STATUS =fnd_api.g_ret_sts_error THEN
7408: IF (l_debug = 1) THEN
7409: INV_TRX_UTIL_PUB.TRACE('Failed for Receipt transaction with status -E ', 'LOC_EMPTY_MIXED_FLAG',9);
7410: END IF;
7411: RAISE fnd_api.g_exc_error;
7412: ELSIF X_RETURN_STATUS =fnd_api.g_ret_sts_unexp_error THEN
7413: IF (l_debug = 1) THEN

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

7410: END IF;
7411: RAISE fnd_api.g_exc_error;
7412: ELSIF X_RETURN_STATUS =fnd_api.g_ret_sts_unexp_error THEN
7413: IF (l_debug = 1) THEN
7414: INV_TRX_UTIL_PUB.TRACE('Failed for Receipt transaction with status -U ', 'LOC_EMPTY_MIXED_FLAG',9);
7415: END IF;
7416: RAISE fnd_api.g_exc_unexpected_error;
7417: END IF;
7418:

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

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

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

7433: ,P_SOURCE =>p_source
7434: ) ;
7435: IF X_RETURN_STATUS =fnd_api.g_ret_sts_error THEN
7436: IF (l_debug = 1) THEN
7437: INV_TRX_UTIL_PUB.TRACE('Failed for Issue transaction with status -E ', 'LOC_EMPTY_MIXED_FLAG',9);
7438: END IF;
7439: RAISE fnd_api.g_exc_error;
7440: ELSIF X_RETURN_STATUS =fnd_api.g_ret_sts_unexp_error THEN
7441: IF (l_debug = 1) THEN

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

7438: END IF;
7439: RAISE fnd_api.g_exc_error;
7440: ELSIF X_RETURN_STATUS =fnd_api.g_ret_sts_unexp_error THEN
7441: IF (l_debug = 1) THEN
7442: INV_TRX_UTIL_PUB.TRACE('Failed for Issue transaction with status - U', 'LOC_EMPTY_MIXED_FLAG',9);
7443: END IF;
7444: RAISE fnd_api.g_exc_unexpected_error;
7445: END IF;
7446: ELSIF p_transaction_action_id in(2,3,28) /* TRANSFER */ THEN

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

7445: END IF;
7446: ELSIF p_transaction_action_id in(2,3,28) /* TRANSFER */ THEN
7447:
7448: IF (l_debug = 1) THEN
7449: INV_TRX_UTIL_PUB.TRACE('Transfer transaction ','LOC_EMPTY_MIXED_FLAG',10);
7450: END IF;
7451:
7452: if (p_transfer_location_id > 0) then
7453: /* For the destination organization */

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

7508: END LOOP;
7509: /*11809528.ends*/
7510:
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

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

7524: ,P_INVENTORY_ITEM_ID => P_INVENTORY_ITEM_ID
7525: ) ;
7526: IF X_RETURN_STATUS =fnd_api.g_ret_sts_error THEN
7527: IF (l_debug = 1) THEN
7528: INV_TRX_UTIL_PUB.TRACE('Failed for Receipt transaction with status -E ', 'LOC_EMPTY_MIXED_FLAG',9);
7529: END IF;
7530: RAISE fnd_api.g_exc_error;
7531: ELSIF X_RETURN_STATUS =fnd_api.g_ret_sts_unexp_error THEN
7532: IF (l_debug = 1) THEN

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

7529: END IF;
7530: RAISE fnd_api.g_exc_error;
7531: ELSIF X_RETURN_STATUS =fnd_api.g_ret_sts_unexp_error THEN
7532: IF (l_debug = 1) THEN
7533: INV_TRX_UTIL_PUB.TRACE('Failed for Receipt transaction with status -U ', 'LOC_EMPTY_MIXED_FLAG',9);
7534: END IF;
7535: RAISE fnd_api.g_exc_unexpected_error;
7536: END IF;
7537:

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

7535: RAISE fnd_api.g_exc_unexpected_error;
7536: END IF;
7537:
7538: IF (l_debug = 1) THEN
7539: INV_TRX_UTIL_PUB.TRACE('Before Updating destination locator ', 'LOC_EMPTY_MIXED_FLAG',10);
7540: INV_TRX_UTIL_PUB.TRACE('The values of Empty _Flag is '||l_empty_flag , 'LOC_EMPTY_MIXED_FLAG',10);
7541: INV_TRX_UTIL_PUB.TRACE('The values of Mixed_Flag is '||l_mixed_flag , 'LOC_EMPTY_MIXED_FLAG',10);
7542: INV_TRX_UTIL_PUB.TRACE('The values of Item ID is '||l_item_id , 'LOC_EMPTY_MIXED_FLAG',10);
7543: END IF;

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

7536: END IF;
7537:
7538: IF (l_debug = 1) THEN
7539: INV_TRX_UTIL_PUB.TRACE('Before Updating destination locator ', 'LOC_EMPTY_MIXED_FLAG',10);
7540: INV_TRX_UTIL_PUB.TRACE('The values of Empty _Flag is '||l_empty_flag , 'LOC_EMPTY_MIXED_FLAG',10);
7541: INV_TRX_UTIL_PUB.TRACE('The values of Mixed_Flag is '||l_mixed_flag , 'LOC_EMPTY_MIXED_FLAG',10);
7542: INV_TRX_UTIL_PUB.TRACE('The values of Item ID is '||l_item_id , 'LOC_EMPTY_MIXED_FLAG',10);
7543: END IF;
7544:

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

7537:
7538: IF (l_debug = 1) THEN
7539: INV_TRX_UTIL_PUB.TRACE('Before Updating destination locator ', 'LOC_EMPTY_MIXED_FLAG',10);
7540: INV_TRX_UTIL_PUB.TRACE('The values of Empty _Flag is '||l_empty_flag , 'LOC_EMPTY_MIXED_FLAG',10);
7541: INV_TRX_UTIL_PUB.TRACE('The values of Mixed_Flag is '||l_mixed_flag , 'LOC_EMPTY_MIXED_FLAG',10);
7542: INV_TRX_UTIL_PUB.TRACE('The values of Item ID is '||l_item_id , 'LOC_EMPTY_MIXED_FLAG',10);
7543: END IF;
7544:
7545: --Fix for 8630843

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

7538: IF (l_debug = 1) THEN
7539: INV_TRX_UTIL_PUB.TRACE('Before Updating destination locator ', 'LOC_EMPTY_MIXED_FLAG',10);
7540: INV_TRX_UTIL_PUB.TRACE('The values of Empty _Flag is '||l_empty_flag , 'LOC_EMPTY_MIXED_FLAG',10);
7541: INV_TRX_UTIL_PUB.TRACE('The values of Mixed_Flag is '||l_mixed_flag , 'LOC_EMPTY_MIXED_FLAG',10);
7542: INV_TRX_UTIL_PUB.TRACE('The values of Item ID is '||l_item_id , 'LOC_EMPTY_MIXED_FLAG',10);
7543: END IF;
7544:
7545: --Fix for 8630843
7546: --LAST_UPDATED_BY = fnd_global.user_id added to the update statment

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

7558:
7559: /* For the Source Organization */
7560:
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

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

7574: ,P_SOURCE =>p_source
7575: ) ;
7576: IF X_RETURN_STATUS =fnd_api.g_ret_sts_error THEN
7577: IF (l_debug = 1) THEN
7578: INV_TRX_UTIL_PUB.TRACE('Failed for Issue transaction with status -E ', 'LOC_EMPTY_MIXED_FLAG',9);
7579: END IF;
7580: RAISE fnd_api.g_exc_error;
7581: ELSIF X_RETURN_STATUS =fnd_api.g_ret_sts_unexp_error THEN
7582: IF (l_debug = 1) THEN

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

7579: END IF;
7580: RAISE fnd_api.g_exc_error;
7581: ELSIF X_RETURN_STATUS =fnd_api.g_ret_sts_unexp_error THEN
7582: IF (l_debug = 1) THEN
7583: INV_TRX_UTIL_PUB.TRACE('Failed for Issue transaction with status - U', 'LOC_EMPTY_MIXED_FLAG',9);
7584: END IF;
7585: RAISE fnd_api.g_exc_unexpected_error;
7586: END IF;
7587: END IF; /* End if for the transaction_action_id */

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

7586: END IF;
7587: END IF; /* End if for the transaction_action_id */
7588:
7589: IF (l_debug = 1) THEN
7590: INV_TRX_UTIL_PUB.TRACE('The values of Empty _Flag is '|| l_empty_flag , 'LOC_EMPTY_MIXED_FLAG',10);
7591: INV_TRX_UTIL_PUB.TRACE('The values of Mixed_Flag is '|| l_mixed_flag , 'LOC_EMPTY_MIXED_FLAG',10);
7592: INV_TRX_UTIL_PUB.TRACE('The values of Item ID is '|| l_item_id , 'LOC_EMPTY_MIXED_FLAG',10);
7593: END IF;
7594:

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

7587: END IF; /* End if for the transaction_action_id */
7588:
7589: IF (l_debug = 1) THEN
7590: INV_TRX_UTIL_PUB.TRACE('The values of Empty _Flag is '|| l_empty_flag , 'LOC_EMPTY_MIXED_FLAG',10);
7591: INV_TRX_UTIL_PUB.TRACE('The values of Mixed_Flag is '|| l_mixed_flag , 'LOC_EMPTY_MIXED_FLAG',10);
7592: INV_TRX_UTIL_PUB.TRACE('The values of Item ID is '|| l_item_id , 'LOC_EMPTY_MIXED_FLAG',10);
7593: END IF;
7594:
7595: --Bug#2756609. Should update empty_flag and mixed_items_flag only if

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

7588:
7589: IF (l_debug = 1) THEN
7590: INV_TRX_UTIL_PUB.TRACE('The values of Empty _Flag is '|| l_empty_flag , 'LOC_EMPTY_MIXED_FLAG',10);
7591: INV_TRX_UTIL_PUB.TRACE('The values of Mixed_Flag is '|| l_mixed_flag , 'LOC_EMPTY_MIXED_FLAG',10);
7592: INV_TRX_UTIL_PUB.TRACE('The values of Item ID is '|| l_item_id , 'LOC_EMPTY_MIXED_FLAG',10);
7593: END IF;
7594:
7595: --Bug#2756609. Should update empty_flag and mixed_items_flag only if
7596: --the values passed are not null.

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

7607: WHERE INVENTORY_LOCATION_ID = l_inventory_location_id
7608: AND ORGANIZATION_ID = P_ORGANIZATION_ID;
7609:
7610: IF (l_debug = 1) THEN
7611: INV_TRX_UTIL_PUB.TRACE('End of Procedure LOC_EMPTY_MIXED_FLAG ', 'LOC_EMPTY_MIXED_FLAG',10);
7612: END IF;
7613: EXCEPTION
7614: WHEN fnd_api.g_exc_error THEN
7615: x_return_status := fnd_api.g_ret_sts_error;

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

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);
7685: END IF;
7686:
7687: x_return_status := FND_API.G_RET_STS_SUCCESS;
7688:

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

7688:
7689: IF P_SOURCE IS NULL THEN
7690:
7691: IF (l_debug = 1) THEN
7692: INV_TRX_UTIL_PUB.TRACE('P_Source is null ','inv_loc_issues',10);
7693: END IF;
7694:
7695: SELECT LOCATION_CURRENT_UNITS,
7696: location_suggested_units,

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

7709: IF ((nvl(l_loc_current_units,0) = 0) and
7710: (nvl(l_loc_suggested_units,0) = 0)) THEN
7711:
7712: IF (l_debug = 1) THEN
7713: INV_TRX_UTIL_PUB.TRACE('Current/Suggested units is 0 ','inv_loc_issues',10);
7714: END IF;
7715: x_empty_flag := 'Y';
7716: x_mixed_flag := 'N';
7717: x_item_id := null;

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

7721: x_item_id := l_inventory_item_id;
7722: END IF;
7723: ELSE
7724: IF (l_debug = 1) THEN
7725: INV_TRX_UTIL_PUB.TRACE('P_Source is not null ','inv_loc_issues',10);
7726: END IF;
7727: BEGIN
7728: SELECT 1
7729: INTO l_chk_flag

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

7734: AND ORGANIZATION_ID = P_ORG_ID
7735: AND INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID
7736: );
7737: IF (l_debug = 1) THEN
7738: INV_TRX_UTIL_PUB.TRACE('Item exists in MOQD ','inv_loc_issues',10);
7739: END IF;
7740: BEGIN
7741: SELECT 1
7742: INTO l_chk_flag

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

7751: x_mixed_flag :='Y';
7752: x_item_id := NULL;
7753:
7754: IF (l_debug = 1) THEN
7755: INV_TRX_UTIL_PUB.TRACE('More than one item exists in locator ', 'inv_loc_issues',10);
7756: END IF;
7757: EXCEPTION
7758: WHEN NO_DATA_FOUND THEN
7759: IF (l_debug = 1) THEN

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

7756: END IF;
7757: EXCEPTION
7758: WHEN NO_DATA_FOUND THEN
7759: IF (l_debug = 1) THEN
7760: INV_TRX_UTIL_PUB.TRACE('Only one item exists in locator', 'inv_loc_issues',10);
7761: END IF;
7762: x_empty_flag :='N';
7763: x_mixed_flag :='N';
7764: x_item_id := p_inventory_item_id;

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

7765: END;
7766: EXCEPTION
7767: WHEN NO_DATA_FOUND THEN
7768: IF (l_debug = 1) THEN
7769: INV_TRX_UTIL_PUB.TRACE('Item passed does not exists in MOQD ', 'inv_loc_issues',10);
7770: END IF;
7771: open item_cnt;
7772: loop
7773: fetch item_cnt into l_item;

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

7774: exit when item_cnt%notfound or item_cnt%rowcount =2;
7775: end loop;
7776: IF item_cnt%rowcount =0 THEN
7777: IF (l_debug = 1) THEN
7778: INV_TRX_UTIL_PUB.TRACE('Locator is empty','inv_loc_issues',10);
7779: END IF;
7780: x_empty_flag := 'Y';
7781: x_mixed_flag := 'N';
7782: x_item_id := null;

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

7781: x_mixed_flag := 'N';
7782: x_item_id := null;
7783: ELSIF item_cnt%rowcount =1 THEN
7784: IF (l_debug = 1) THEN
7785: INV_TRX_UTIL_PUB.TRACE('One item alone exists in the locator', 'inv_loc_issues',10);
7786: END IF;
7787: x_empty_flag := 'N';
7788: x_mixed_flag := 'N';
7789: x_item_id := l_item.inventory_item_id;

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

7788: x_mixed_flag := 'N';
7789: x_item_id := l_item.inventory_item_id;
7790: ELSIF item_cnt%rowcount =2 THEN
7791: IF (l_debug = 1) THEN
7792: INV_TRX_UTIL_PUB.TRACE('More than one item alone exists in the locator', 'inv_loc_issues',10);
7793: END IF;
7794: x_empty_flag := 'N';
7795: x_mixed_flag := 'Y';
7796: x_item_id := null;

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

7830: BEGIN
7831: x_return_status := FND_API.G_RET_STS_SUCCESS;
7832:
7833: IF (l_debug = 1) THEN
7834: INV_TRX_UTIL_PUB.TRACE('In Procedure inv_loc_receipt ','receipts',10);
7835: END IF;
7836: --Added to get subinventory bug3237709
7837: SELECT subinventory_code
7838: INTO l_subinventory_code

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

7882: X_mixed_flag := 'Y';
7883: X_item_id := NULL;
7884:
7885: IF (l_debug = 1) THEN
7886: INV_TRX_UTIL_PUB.TRACE('More than 1 item exists in the locator','inv_loc_receipts',10);
7887: END IF;
7888:
7889: EXCEPTION
7890: WHEN NO_DATA_FOUND THEN

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

7888:
7889: EXCEPTION
7890: WHEN NO_DATA_FOUND THEN
7891: IF (l_debug = 1) THEN
7892: INV_TRX_UTIL_PUB.TRACE('Only one item exists in the locator','inv_loc_receipts',10);
7893: END IF;
7894: X_EMPTY_FLAG := 'N';
7895: x_mixed_flag := 'N';
7896: x_item_id := P_INVENTORY_ITEM_ID;

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

7979: loop
7980: fetch mmtt_cur_mixed_flg into l_mmtt_cur_mixed_flg;
7981: exit when mmtt_cur_mixed_flg%NOTFOUND;
7982: IF (l_debug = 1) THEN
7983: INV_TRX_UTIL_PUB.TRACE('Fetch from mmtt_cur_mixed_flg is success','LPN_LOC_CLEANUP_MMTT',4);
7984: END IF;
7985:
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

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

8002: p_quantity => l_mmtt_cur_mixed_flg.primary_quantity
8003: );
8004: IF X_RETURN_STATUS =fnd_api.g_ret_sts_error THEN
8005: IF (l_debug = 1) THEN
8006: INV_TRX_UTIL_PUB.TRACE('Loc cpty calc -Transfer case- failed with status E','LPN_LOC_CLEANUP_MMTT',10);
8007: END IF;
8008: RAISE fnd_api.g_exc_error;
8009: ELSIF X_RETURN_STATUS =fnd_api.g_ret_sts_unexp_error THEN
8010: IF (l_debug = 1) THEN

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

8007: END IF;
8008: RAISE fnd_api.g_exc_error;
8009: ELSIF X_RETURN_STATUS =fnd_api.g_ret_sts_unexp_error THEN
8010: IF (l_debug = 1) THEN
8011: INV_TRX_UTIL_PUB.TRACE('Loc cpty calc-Transfer case- failed with status U','LPN_LOC_CLEANUP_MMTT',10);
8012: END IF;
8013: RAISE fnd_api.g_exc_unexpected_error;
8014: END IF;
8015:

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

8026: ,P_SOURCE => 'CONCURRENT'
8027: );
8028: IF X_RETURN_STATUS =fnd_api.g_ret_sts_error THEN
8029: IF (l_debug = 1) THEN
8030: INV_TRX_UTIL_PUB.TRACE('LOC_EMPTY_MIXED-Transfer Case failed with status E','LPN_LOC_CLEANUP_MMTT',10);
8031: END IF;
8032: RAISE fnd_api.g_exc_error;
8033: ELSIF X_RETURN_STATUS =fnd_api.g_ret_sts_unexp_error THEN
8034: IF (l_debug = 1) THEN

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

8031: END IF;
8032: RAISE fnd_api.g_exc_error;
8033: ELSIF X_RETURN_STATUS =fnd_api.g_ret_sts_unexp_error THEN
8034: IF (l_debug = 1) THEN
8035: INV_TRX_UTIL_PUB.TRACE('LOC_EMPTY_MIXED-Transfer case failed with status U','LPN_LOC_CLEANUP_MMTT',10);
8036: END IF;
8037: RAISE fnd_api.g_exc_unexpected_error;
8038: END IF;
8039:

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

8053: p_quantity => l_mmtt_cur_mixed_flg.primary_quantity
8054: );
8055: IF X_RETURN_STATUS =fnd_api.g_ret_sts_error THEN
8056: IF (l_debug = 1) THEN
8057: INV_TRX_UTIL_PUB.TRACE('Loc cpty calc - failed with status E','LPN_LOC_CLEANUP_MMTT',10);
8058: END IF;
8059: RAISE fnd_api.g_exc_error;
8060: ELSIF X_RETURN_STATUS =fnd_api.g_ret_sts_unexp_error THEN
8061: IF (l_debug = 1) THEN

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

8058: END IF;
8059: RAISE fnd_api.g_exc_error;
8060: ELSIF X_RETURN_STATUS =fnd_api.g_ret_sts_unexp_error THEN
8061: IF (l_debug = 1) THEN
8062: INV_TRX_UTIL_PUB.TRACE('Loc cpty calc - failed with status U','LPN_LOC_CLEANUP_MMTT',10);
8063: END IF;
8064: RAISE fnd_api.g_exc_unexpected_error;
8065: END IF;
8066:

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

8077: ,P_SOURCE => 'CONCURRENT'
8078: );
8079: IF X_RETURN_STATUS =fnd_api.g_ret_sts_error THEN
8080: IF (l_debug = 1) THEN
8081: INV_TRX_UTIL_PUB.TRACE('LOC_EMPTY_MIXED failed with status E','LPN_LOC_CLEANUP_MMTT',10);
8082: END IF;
8083: RAISE fnd_api.g_exc_error;
8084: ELSIF X_RETURN_STATUS =fnd_api.g_ret_sts_unexp_error THEN
8085: IF (l_debug = 1) THEN

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

8082: END IF;
8083: RAISE fnd_api.g_exc_error;
8084: ELSIF X_RETURN_STATUS =fnd_api.g_ret_sts_unexp_error THEN
8085: IF (l_debug = 1) THEN
8086: INV_TRX_UTIL_PUB.TRACE('LOC_EMPTY_MIXED failed with status U','LPN_LOC_CLEANUP_MMTT',10);
8087: END IF;
8088: RAISE fnd_api.g_exc_unexpected_error;
8089: END IF;
8090:

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

8097: LOOP
8098: FETCH mmtt_cur into l_mmtt_cur ;
8099: exit when mmtt_cur%NOTFOUND;
8100: IF (l_debug = 1) THEN
8101: INV_TRX_UTIL_PUB.TRACE('Fetch from mmtt_cur is success','LPN_LOC_CLEANUP_MMTT',10);
8102: END IF;
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;

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

8119: p_quantity => l_mmtt_cur.primary_quantity
8120: );
8121: IF X_RETURN_STATUS =fnd_api.g_ret_sts_error THEN
8122: IF (l_debug = 1) THEN
8123: INV_TRX_UTIL_PUB.TRACE('Loc cpty calc -Transfer case- failed with status E','LPN_LOC_CLEANUP_MMTT',10);
8124: END IF;
8125: RAISE fnd_api.g_exc_error;
8126: ELSIF X_RETURN_STATUS =fnd_api.g_ret_sts_unexp_error THEN
8127: IF (l_debug = 1) THEN

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

8124: END IF;
8125: RAISE fnd_api.g_exc_error;
8126: ELSIF X_RETURN_STATUS =fnd_api.g_ret_sts_unexp_error THEN
8127: IF (l_debug = 1) THEN
8128: INV_TRX_UTIL_PUB.TRACE('Loc cpty calc -Transfer case- failed with status U','LPN_LOC_CLEANUP_MMTT',10);
8129: END IF;
8130: RAISE fnd_api.g_exc_unexpected_error;
8131: END IF;
8132:

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

8143: ,P_SOURCE => 'CONCURRENT'
8144: );
8145: IF X_RETURN_STATUS =fnd_api.g_ret_sts_error THEN
8146: IF (l_debug = 1) THEN
8147: INV_TRX_UTIL_PUB.TRACE('LOC_EMPTY_MIXED-Transfer Case failed with status E','LPN_LOC_CLEANUP_MMTT',10);
8148: END IF;
8149: RAISE fnd_api.g_exc_error;
8150: ELSIF X_RETURN_STATUS =fnd_api.g_ret_sts_unexp_error THEN
8151: IF (l_debug = 1) THEN

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

8148: END IF;
8149: RAISE fnd_api.g_exc_error;
8150: ELSIF X_RETURN_STATUS =fnd_api.g_ret_sts_unexp_error THEN
8151: IF (l_debug = 1) THEN
8152: INV_TRX_UTIL_PUB.TRACE('LOC_EMPTY_MIXED-Transfer Case failed with status U','LPN_LOC_CLEANUP_MMTT',10);
8153: END IF;
8154: RAISE fnd_api.g_exc_unexpected_error;
8155: END IF;
8156:

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

8170: p_quantity => l_mmtt_cur.primary_quantity
8171: );
8172: IF X_RETURN_STATUS =fnd_api.g_ret_sts_error THEN
8173: IF (l_debug = 1) THEN
8174: INV_TRX_UTIL_PUB.TRACE('Loc cpty calc - failed with status E','LPN_LOC_CLEANUP_MMTT',10);
8175: END IF;
8176: RAISE fnd_api.g_exc_error;
8177: ELSIF X_RETURN_STATUS =fnd_api.g_ret_sts_unexp_error THEN
8178: IF (l_debug = 1) THEN

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

8175: END IF;
8176: RAISE fnd_api.g_exc_error;
8177: ELSIF X_RETURN_STATUS =fnd_api.g_ret_sts_unexp_error THEN
8178: IF (l_debug = 1) THEN
8179: INV_TRX_UTIL_PUB.TRACE('Loc cpty calc - failed with status U','LPN_LOC_CLEANUP_MMTT',10);
8180: END IF;
8181: RAISE fnd_api.g_exc_unexpected_error;
8182: END IF;
8183:

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

8194: ,P_SOURCE => 'CONCURRENT'
8195: );
8196: IF X_RETURN_STATUS =fnd_api.g_ret_sts_error THEN
8197: IF (l_debug = 1) THEN
8198: INV_TRX_UTIL_PUB.TRACE('LOC_EMPTY_MIXED failed with Return status E','LPN_LOC_CLEANUP_MMTT',10);
8199: END IF;
8200: RAISE fnd_api.g_exc_error;
8201: ELSIF X_RETURN_STATUS =fnd_api.g_ret_sts_unexp_error THEN
8202: RAISE fnd_api.g_exc_unexpected_error;

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

8200: RAISE fnd_api.g_exc_error;
8201: ELSIF X_RETURN_STATUS =fnd_api.g_ret_sts_unexp_error THEN
8202: RAISE fnd_api.g_exc_unexpected_error;
8203: IF (l_debug = 1) THEN
8204: INV_TRX_UTIL_PUB.TRACE('LOC_EMPTY_MIXED failed with Return status U','LPN_LOC_CLEANUP_MMTT',10);
8205: END IF;
8206: END IF;
8207: END IF;
8208: END LOOP;

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

8207: END IF;
8208: END LOOP;
8209: CLOSE mmtt_cur;
8210: IF (l_debug = 1) THEN
8211: INV_TRX_UTIL_PUB.TRACE('successful Completion of LPN_LOC_CLEANUP_MMTT ','LPN_LOC_CLEANUP_MMTT',10);
8212: END IF;
8213: END IF;
8214: EXCEPTION
8215:

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

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

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

8379: processing.Else we have to use the inventory_location_id
8380: for further processing
8381: */
8382: IF (l_debug = 1) THEN
8383: INV_TRX_UTIL_PUB.TRACE('Curr_cpty_mixed_flag is successful ','LPN_LOC_CURRENT_CAPACITY',10);
8384: END IF;
8385: l_inventory_location_id :=null;
8386: l_physical_locator_id :=null;
8387: l_locator_id :=null;

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

8402: /* Update current weight and current cubic area of the locator with the
8403: LPN's gross weight and content volume
8404: */
8405: IF (l_debug = 1) THEN
8406: INV_TRX_UTIL_PUB.TRACE('The value of locator _id is '||to_char(l_inventory_location_id), 'LPN_LOC_CURRENT_CAPACITY',10);
8407: INV_TRX_UTIL_PUB.TRACE('The value of org_id is'||to_char(p_organization_id),'LPN_LOC_CURRENT_CAPACITY',10);
8408: INV_TRX_UTIL_PUB.TRACE('The value of gross_weight is '||to_char(l_curr_cpty.gross_weight), 'LPN_LOC_CURRENT_CAPACITY',10);
8409: INV_TRX_UTIL_PUB.TRACE('The value of content_volume is '||to_char(l_curr_cpty.content_volume), 'LPN_LOC_CURRENT_CAPACITY',10);
8410: END IF;

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

8403: LPN's gross weight and content volume
8404: */
8405: IF (l_debug = 1) THEN
8406: INV_TRX_UTIL_PUB.TRACE('The value of locator _id is '||to_char(l_inventory_location_id), 'LPN_LOC_CURRENT_CAPACITY',10);
8407: INV_TRX_UTIL_PUB.TRACE('The value of org_id is'||to_char(p_organization_id),'LPN_LOC_CURRENT_CAPACITY',10);
8408: INV_TRX_UTIL_PUB.TRACE('The value of gross_weight is '||to_char(l_curr_cpty.gross_weight), 'LPN_LOC_CURRENT_CAPACITY',10);
8409: INV_TRX_UTIL_PUB.TRACE('The value of content_volume is '||to_char(l_curr_cpty.content_volume), 'LPN_LOC_CURRENT_CAPACITY',10);
8410: END IF;
8411: begin

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

8404: */
8405: IF (l_debug = 1) THEN
8406: INV_TRX_UTIL_PUB.TRACE('The value of locator _id is '||to_char(l_inventory_location_id), 'LPN_LOC_CURRENT_CAPACITY',10);
8407: INV_TRX_UTIL_PUB.TRACE('The value of org_id is'||to_char(p_organization_id),'LPN_LOC_CURRENT_CAPACITY',10);
8408: INV_TRX_UTIL_PUB.TRACE('The value of gross_weight is '||to_char(l_curr_cpty.gross_weight), 'LPN_LOC_CURRENT_CAPACITY',10);
8409: INV_TRX_UTIL_PUB.TRACE('The value of content_volume is '||to_char(l_curr_cpty.content_volume), 'LPN_LOC_CURRENT_CAPACITY',10);
8410: END IF;
8411: begin
8412: SELECT sum(abs(primary_transaction_quantity))

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

8405: IF (l_debug = 1) THEN
8406: INV_TRX_UTIL_PUB.TRACE('The value of locator _id is '||to_char(l_inventory_location_id), 'LPN_LOC_CURRENT_CAPACITY',10);
8407: INV_TRX_UTIL_PUB.TRACE('The value of org_id is'||to_char(p_organization_id),'LPN_LOC_CURRENT_CAPACITY',10);
8408: INV_TRX_UTIL_PUB.TRACE('The value of gross_weight is '||to_char(l_curr_cpty.gross_weight), 'LPN_LOC_CURRENT_CAPACITY',10);
8409: INV_TRX_UTIL_PUB.TRACE('The value of content_volume is '||to_char(l_curr_cpty.content_volume), 'LPN_LOC_CURRENT_CAPACITY',10);
8410: END IF;
8411: begin
8412: SELECT sum(abs(primary_transaction_quantity))
8413: into l_units

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

8439: loop
8440: fetch current_cpty into l_curr_cpty;
8441: exit when current_cpty%notfound;
8442: IF (l_debug = 1) THEN
8443: INV_TRX_UTIL_PUB.TRACE('Fetch from current_cpty is success','LPN_LOC_CURRENT_CAPACITY',10);
8444: END IF;
8445:
8446: /* If the locator has a physical_location_id
8447: then use the physical_location_id for further

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

8468: /* Update current weight and current cubic area of the locator with the
8469: LPN gross weight and content volume
8470: */
8471: IF (l_debug = 1) THEN
8472: INV_TRX_UTIL_PUB.TRACE('The value of locator _id is '||to_char(l_inventory_location_id), 'LPN_LOC_CURRENT_CAPACITY',10);
8473: INV_TRX_UTIL_PUB.TRACE('The value of org_id is'||to_char(p_organization_id),'LPN_LOC_CURRENT_CAPACITY',10);
8474: INV_TRX_UTIL_PUB.TRACE('The value of gross_weight is '||to_char(l_curr_cpty.gross_weight), 'LPN_LOC_CURRENT_CAPACITY',10);
8475: INV_TRX_UTIL_PUB.TRACE('The value of content_volume is '||to_char(l_curr_cpty.content_volume), 'LPN_LOC_CURRENT_CAPACITY',10);
8476: END IF;

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

8469: LPN gross weight and content volume
8470: */
8471: IF (l_debug = 1) THEN
8472: INV_TRX_UTIL_PUB.TRACE('The value of locator _id is '||to_char(l_inventory_location_id), 'LPN_LOC_CURRENT_CAPACITY',10);
8473: INV_TRX_UTIL_PUB.TRACE('The value of org_id is'||to_char(p_organization_id),'LPN_LOC_CURRENT_CAPACITY',10);
8474: INV_TRX_UTIL_PUB.TRACE('The value of gross_weight is '||to_char(l_curr_cpty.gross_weight), 'LPN_LOC_CURRENT_CAPACITY',10);
8475: INV_TRX_UTIL_PUB.TRACE('The value of content_volume is '||to_char(l_curr_cpty.content_volume), 'LPN_LOC_CURRENT_CAPACITY',10);
8476: END IF;
8477: begin

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

8470: */
8471: IF (l_debug = 1) THEN
8472: INV_TRX_UTIL_PUB.TRACE('The value of locator _id is '||to_char(l_inventory_location_id), 'LPN_LOC_CURRENT_CAPACITY',10);
8473: INV_TRX_UTIL_PUB.TRACE('The value of org_id is'||to_char(p_organization_id),'LPN_LOC_CURRENT_CAPACITY',10);
8474: INV_TRX_UTIL_PUB.TRACE('The value of gross_weight is '||to_char(l_curr_cpty.gross_weight), 'LPN_LOC_CURRENT_CAPACITY',10);
8475: INV_TRX_UTIL_PUB.TRACE('The value of content_volume is '||to_char(l_curr_cpty.content_volume), 'LPN_LOC_CURRENT_CAPACITY',10);
8476: END IF;
8477: begin
8478: SELECT sum(abs(primary_transaction_quantity))

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

8471: IF (l_debug = 1) THEN
8472: INV_TRX_UTIL_PUB.TRACE('The value of locator _id is '||to_char(l_inventory_location_id), 'LPN_LOC_CURRENT_CAPACITY',10);
8473: INV_TRX_UTIL_PUB.TRACE('The value of org_id is'||to_char(p_organization_id),'LPN_LOC_CURRENT_CAPACITY',10);
8474: INV_TRX_UTIL_PUB.TRACE('The value of gross_weight is '||to_char(l_curr_cpty.gross_weight), 'LPN_LOC_CURRENT_CAPACITY',10);
8475: INV_TRX_UTIL_PUB.TRACE('The value of content_volume is '||to_char(l_curr_cpty.content_volume), 'LPN_LOC_CURRENT_CAPACITY',10);
8476: END IF;
8477: begin
8478: SELECT sum(abs(primary_transaction_quantity))
8479: into l_units

Line 8763: inv_trx_util_pub.TRACE('In DB TRIGGER - The locator id '

8759:
8760: END IF;
8761: IF l_source_max_units IS NULL AND l_source_max_weight IS NULL AND l_source_max_cubic_area IS NULL THEN
8762: IF (l_debug = 1) THEN
8763: inv_trx_util_pub.TRACE('In DB TRIGGER - The locator id '
8764: || p_locator_id
8765: ||' has infinite capacity', 'get_source_type', 4);
8766: END IF;
8767: l_item_count := 0;

Line 8786: inv_trx_util_pub.TRACE(' Exception is thrown when selecting l_onhand_for_others ' , 'get_source_type', 4);

8782:
8783: EXCEPTION
8784: WHEN OTHERS THEN
8785: l_onhand_for_others := 0;
8786: inv_trx_util_pub.TRACE(' Exception is thrown when selecting l_onhand_for_others ' , 'get_source_type', 4);
8787: END;
8788: inv_trx_util_pub.TRACE(' After selecting l_onhand_for_others '
8789: || l_onhand_for_others
8790: || ' -- content_lpn_id --'

Line 8788: inv_trx_util_pub.TRACE(' After selecting l_onhand_for_others '

8784: WHEN OTHERS THEN
8785: l_onhand_for_others := 0;
8786: inv_trx_util_pub.TRACE(' Exception is thrown when selecting l_onhand_for_others ' , 'get_source_type', 4);
8787: END;
8788: inv_trx_util_pub.TRACE(' After selecting l_onhand_for_others '
8789: || l_onhand_for_others
8790: || ' -- content_lpn_id --'
8791: || p_content_lpn_id , 'get_source_type', 4);
8792: END IF ;

Line 8797: inv_trx_util_pub.TRACE(' before selecting l_ietm_count, l_item_count is- '

8793: IF p_content_lpn_id IS NOT NULL AND l_onhand_for_others = 1 THEN
8794: p_source := 'INFINITE';
8795: ELSE
8796: BEGIN
8797: inv_trx_util_pub.TRACE(' before selecting l_ietm_count, l_item_count is- '
8798: || l_item_count
8799: || 'p_inventory_item_id is -'
8800: || p_inventory_item_id
8801: || ' p_locator_id is-'

Line 8818: inv_trx_util_pub.TRACE(' Exception is thrown when selecting l_item_count ' , 'get_source_type', 4);

8814: EXCEPTION
8815: WHEN NO_DATA_FOUND THEN --fixing bug 14489644
8816: l_item_count := 0;
8817: WHEN OTHERS THEN
8818: inv_trx_util_pub.TRACE(' Exception is thrown when selecting l_item_count ' , 'get_source_type', 4);
8819: END;
8820: inv_trx_util_pub.TRACE(' After selecting l_item_count '
8821: || l_item_count , 'get_source_type', 4);
8822: IF l_item_count > 0 THEN

Line 8820: inv_trx_util_pub.TRACE(' After selecting l_item_count '

8816: l_item_count := 0;
8817: WHEN OTHERS THEN
8818: inv_trx_util_pub.TRACE(' Exception is thrown when selecting l_item_count ' , 'get_source_type', 4);
8819: END;
8820: inv_trx_util_pub.TRACE(' After selecting l_item_count '
8821: || l_item_count , 'get_source_type', 4);
8822: IF l_item_count > 0 THEN
8823: p_source := 'INFINITE';
8824: ELSE

Line 8835: inv_trx_util_pub.TRACE(' Exception is thrown when selecting l_onhand_qty_for_item ' , 'get_source_type', 4);

8831: AND inventory_item_id = p_inventory_item_id;
8832:
8833: EXCEPTION
8834: WHEN OTHERS THEN
8835: inv_trx_util_pub.TRACE(' Exception is thrown when selecting l_onhand_qty_for_item ' , 'get_source_type', 4);
8836: END;
8837: inv_trx_util_pub.TRACE(' l_onhand_qty_for_item is'
8838: || l_onhand_qty_for_item, 'get_source_type', 4);
8839: inv_trx_util_pub.TRACE(' ABS(p_primary_quantity) is'

Line 8837: inv_trx_util_pub.TRACE(' l_onhand_qty_for_item is'

8833: EXCEPTION
8834: WHEN OTHERS THEN
8835: inv_trx_util_pub.TRACE(' Exception is thrown when selecting l_onhand_qty_for_item ' , 'get_source_type', 4);
8836: END;
8837: inv_trx_util_pub.TRACE(' l_onhand_qty_for_item is'
8838: || l_onhand_qty_for_item, 'get_source_type', 4);
8839: inv_trx_util_pub.TRACE(' ABS(p_primary_quantity) is'
8840: || ABS(p_primary_quantity), 'get_source_type', 4);
8841: IF ABS(p_primary_quantity) < l_onhand_qty_for_item THEN

Line 8839: inv_trx_util_pub.TRACE(' ABS(p_primary_quantity) is'

8835: inv_trx_util_pub.TRACE(' Exception is thrown when selecting l_onhand_qty_for_item ' , 'get_source_type', 4);
8836: END;
8837: inv_trx_util_pub.TRACE(' l_onhand_qty_for_item is'
8838: || l_onhand_qty_for_item, 'get_source_type', 4);
8839: inv_trx_util_pub.TRACE(' ABS(p_primary_quantity) is'
8840: || ABS(p_primary_quantity), 'get_source_type', 4);
8841: IF ABS(p_primary_quantity) < l_onhand_qty_for_item THEN
8842: p_source := 'INFINITE';
8843: ELSE

Line 8853: inv_trx_util_pub.TRACE(' p_source 1 is - '|| p_source , 'get_source_type', 4);

8849: END IF ;
8850:
8851: x_source:=p_source;
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;