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_LPN_TRX_PUB dependencies on INV_CACHE

Line 296: IF ( inv_cache.set_org_rec(v_mmtt_rec.organization_id ) ) THEN

292: END IF;
293:
294: -- Start Bug 10158934
295: -- Call GMF_get_transfer_price_PUB.get_transfer_price API if either from or to org is process enabled.
296: IF ( inv_cache.set_org_rec(v_mmtt_rec.organization_id ) ) THEN
297: IF ( NVL(inv_cache.org_rec.process_enabled_flag,'N') = 'Y') THEN
298: p_from_opm_org := 'Y';
299: inv_log_util.trace('p_from_opm_org is:' ||p_from_opm_org, g_pkg_name || '.' || l_api_name, 5);
300:

Line 297: IF ( NVL(inv_cache.org_rec.process_enabled_flag,'N') = 'Y') THEN

293:
294: -- Start Bug 10158934
295: -- Call GMF_get_transfer_price_PUB.get_transfer_price API if either from or to org is process enabled.
296: IF ( inv_cache.set_org_rec(v_mmtt_rec.organization_id ) ) THEN
297: IF ( NVL(inv_cache.org_rec.process_enabled_flag,'N') = 'Y') THEN
298: p_from_opm_org := 'Y';
299: inv_log_util.trace('p_from_opm_org is:' ||p_from_opm_org, g_pkg_name || '.' || l_api_name, 5);
300:
301: END IF;

Line 304: IF ( inv_cache.set_org_rec(v_mmtt_rec.transfer_organization ) ) THEN

300:
301: END IF;
302: END IF;
303:
304: IF ( inv_cache.set_org_rec(v_mmtt_rec.transfer_organization ) ) THEN
305: IF ( NVL(inv_cache.org_rec.process_enabled_flag,'N') = 'Y') THEN
306: p_to_opm_org := 'Y';
307: inv_log_util.trace('p_to_opm_org is:' ||p_to_opm_org, g_pkg_name || '.' || l_api_name, 5);
308: END IF;

Line 305: IF ( NVL(inv_cache.org_rec.process_enabled_flag,'N') = 'Y') THEN

301: END IF;
302: END IF;
303:
304: IF ( inv_cache.set_org_rec(v_mmtt_rec.transfer_organization ) ) THEN
305: IF ( NVL(inv_cache.org_rec.process_enabled_flag,'N') = 'Y') THEN
306: p_to_opm_org := 'Y';
307: inv_log_util.trace('p_to_opm_org is:' ||p_to_opm_org, g_pkg_name || '.' || l_api_name, 5);
308: END IF;
309: END IF;

Line 4289: IF (inv_cache.set_org_rec(v_mmtt.organization_id)) THEN

4285: -- is neither S.O nor I.O
4286:
4287: -- Bug 14341547 added for project contracts type .
4288:
4289: IF (inv_cache.set_org_rec(v_mmtt.organization_id)) THEN
4290: l_wms_enabled_org := inv_cache.org_rec.WMS_ENABLED_FLAG;
4291: END IF;
4292:
4293: inv_log_util.TRACE('Wms_enabled_flag: '||l_wms_enabled_org, 'INV_LPN_TRX_PUB', 1);

Line 4290: l_wms_enabled_org := inv_cache.org_rec.WMS_ENABLED_FLAG;

4286:
4287: -- Bug 14341547 added for project contracts type .
4288:
4289: IF (inv_cache.set_org_rec(v_mmtt.organization_id)) THEN
4290: l_wms_enabled_org := inv_cache.org_rec.WMS_ENABLED_FLAG;
4291: END IF;
4292:
4293: inv_log_util.TRACE('Wms_enabled_flag: '||l_wms_enabled_org, 'INV_LPN_TRX_PUB', 1);
4294: IF NOT(

Line 5443: IF inv_cache.set_item_rec(p_organization_id => p_organization_id, p_item_id => p_inventory_item_id) THEN

5439: x_return_status := fnd_api.g_ret_sts_success;
5440:
5441: --SAVEPOINT PROCESS_LPN_TRX_LINE;
5442:
5443: IF inv_cache.set_item_rec(p_organization_id => p_organization_id, p_item_id => p_inventory_item_id) THEN
5444: IF inv_cache.item_rec.tracking_quantity_ind = 'PS' THEN
5445: IF l_secondary_trx_quantity IS NULL THEN
5446: IF inv_cache.item_rec.secondary_default_ind = 'F' THEN
5447: l_secondary_trx_quantity := inv_convert.inv_um_convert(

Line 5444: IF inv_cache.item_rec.tracking_quantity_ind = 'PS' THEN

5440:
5441: --SAVEPOINT PROCESS_LPN_TRX_LINE;
5442:
5443: IF inv_cache.set_item_rec(p_organization_id => p_organization_id, p_item_id => p_inventory_item_id) THEN
5444: IF inv_cache.item_rec.tracking_quantity_ind = 'PS' THEN
5445: IF l_secondary_trx_quantity IS NULL THEN
5446: IF inv_cache.item_rec.secondary_default_ind = 'F' THEN
5447: l_secondary_trx_quantity := inv_convert.inv_um_convert(
5448: item_id => p_inventory_item_id

Line 5446: IF inv_cache.item_rec.secondary_default_ind = 'F' THEN

5442:
5443: IF inv_cache.set_item_rec(p_organization_id => p_organization_id, p_item_id => p_inventory_item_id) THEN
5444: IF inv_cache.item_rec.tracking_quantity_ind = 'PS' THEN
5445: IF l_secondary_trx_quantity IS NULL THEN
5446: IF inv_cache.item_rec.secondary_default_ind = 'F' THEN
5447: l_secondary_trx_quantity := inv_convert.inv_um_convert(
5448: item_id => p_inventory_item_id
5449: , lot_number => p_lot_number
5450: , organization_id => p_organization_id

Line 5474: l_progress := 'Calling INV_CACHE.Set_Item_Rec to get item values';

5470: -- Retrieve item properties if not passed by TM: used by bug 3158847 as well
5471: IF (p_inventory_item_id > 0) THEN
5472: IF (p_primary_uom IS NULL
5473: OR p_serial_control_code IS NULL) THEN
5474: l_progress := 'Calling INV_CACHE.Set_Item_Rec to get item values';
5475: l_ret_bool := inv_cache.set_item_rec(p_organization_id => p_organization_id, p_item_id => p_inventory_item_id);
5476:
5477: IF (l_ret_bool) THEN
5478: l_progress := 'Found item assigning it to l_item_rec';

Line 5475: l_ret_bool := inv_cache.set_item_rec(p_organization_id => p_organization_id, p_item_id => p_inventory_item_id);

5471: IF (p_inventory_item_id > 0) THEN
5472: IF (p_primary_uom IS NULL
5473: OR p_serial_control_code IS NULL) THEN
5474: l_progress := 'Calling INV_CACHE.Set_Item_Rec to get item values';
5475: l_ret_bool := inv_cache.set_item_rec(p_organization_id => p_organization_id, p_item_id => p_inventory_item_id);
5476:
5477: IF (l_ret_bool) THEN
5478: l_progress := 'Found item assigning it to l_item_rec';
5479: l_item_rec := inv_cache.item_rec;

Line 5479: l_item_rec := inv_cache.item_rec;

5475: l_ret_bool := inv_cache.set_item_rec(p_organization_id => p_organization_id, p_item_id => p_inventory_item_id);
5476:
5477: IF (l_ret_bool) THEN
5478: l_progress := 'Found item assigning it to l_item_rec';
5479: l_item_rec := inv_cache.item_rec;
5480:
5481: IF (l_debug = 1) THEN
5482: inv_log_util.TRACE(
5483: 'Got item properties puom=' || l_item_rec.primary_uom_code || ' sctl=' || l_item_rec.serial_number_control_code

Line 5489: l_progress := 'Error calling INV_CACHE.Set_Item_Rec to get item info';

5485: , 9
5486: );
5487: END IF;
5488: ELSE --failed to get item info
5489: l_progress := 'Error calling INV_CACHE.Set_Item_Rec to get item info';
5490: RAISE fnd_api.g_exc_unexpected_error;
5491: END IF;
5492: ELSE --Values already passed, assign to item rec type
5493: l_item_rec.organization_id := p_organization_id;

Line 7617: IF ( inv_cache.set_org_rec(p_organization_id) ) THEN

7613: ELSIF ( p_transaction_action_id = inv_globals.G_ACTION_ASSYRETURN AND
7614: p_transaction_source_type_id = inv_globals.G_SOURCETYPE_WIP AND
7615: NVL(p_lpn_id,-1) > 0
7616: ) THEN
7617: IF ( inv_cache.set_org_rec(p_organization_id) ) THEN
7618: IF ( NVL(inv_cache.org_rec.process_enabled_flag,'N') = 'Y') THEN --We will do this only for OPM
7619:
7620: Call_Pack_Unpack (
7621: p_tempid => p_transaction_temp_id

Line 7618: IF ( NVL(inv_cache.org_rec.process_enabled_flag,'N') = 'Y') THEN --We will do this only for OPM

7614: p_transaction_source_type_id = inv_globals.G_SOURCETYPE_WIP AND
7615: NVL(p_lpn_id,-1) > 0
7616: ) THEN
7617: IF ( inv_cache.set_org_rec(p_organization_id) ) THEN
7618: IF ( NVL(inv_cache.org_rec.process_enabled_flag,'N') = 'Y') THEN --We will do this only for OPM
7619:
7620: Call_Pack_Unpack (
7621: p_tempid => p_transaction_temp_id
7622: , p_content_lpn => NULL

Line 7686: IF (NOT inv_cache.Set_org_rec(p_organization_id => p_organization_id)) THEN

7682: END IF; --lpn_id = null AND content_lpn_id = null and xfr_lpn_id = null
7683:
7684: -- Start 9740452
7685:
7686: IF (NOT inv_cache.Set_org_rec(p_organization_id => p_organization_id)) THEN
7687: IF (l_debug = 1) THEN
7688: inv_log_util.TRACE(l_api_name||' : '||p_organization_id||' is an invalid organization id', 'INV_LPN_TRX_PUB', 1);
7689: END IF;
7690: fnd_message.Set_name('WMS','WMS_CONT_INVALID_ORG');

Line 7695: IF NVL(inv_cache.org_rec.PROCESS_ENABLED_FLAG,'N') = 'Y' then

7691: fnd_msg_pub.ADD;
7692: RAISE fnd_api.g_exc_error;
7693: END IF;
7694:
7695: IF NVL(inv_cache.org_rec.PROCESS_ENABLED_FLAG,'N') = 'Y' then
7696:
7697: -- Start 8379698
7698: SELECT transaction_type_id INTO l_transaction_type_id
7699: FROM mtl_material_transactions_temp