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

Line 330: IF ( inv_cache.set_item_rec(

326: --first store the original count uom and quantity
327: g_orig_count_uom := p_count_uom;
328: g_orig_count_quantity := p_count_quantity;
329:
330: IF ( inv_cache.set_item_rec(
331: p_organization_id => p_organization_id
332: , p_item_id => p_inventory_item_id ) )
333: THEN
334: IF (l_debug = 1) THEN

Line 335: print_debug('Got Item info puom='||inv_cache.item_rec.primary_uom_code);

331: p_organization_id => p_organization_id
332: , p_item_id => p_inventory_item_id ) )
333: THEN
334: IF (l_debug = 1) THEN
335: print_debug('Got Item info puom='||inv_cache.item_rec.primary_uom_code);
336: END IF;
337: ELSE
338: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_ITEM');
339: fnd_msg_pub.ADD;

Line 343: if(p_count_uom <> inv_cache.item_rec.primary_uom_code) then

339: fnd_msg_pub.ADD;
340: RAISE fnd_api.g_exc_error;
341: END IF;
342:
343: if(p_count_uom <> inv_cache.item_rec.primary_uom_code) then
344: g_count_uom := inv_cache.item_rec.primary_uom_code;
345: g_count_quantity := inv_convert.inv_um_convert ( p_inventory_item_id,
346: p_lot_number,
347: p_organization_id,

Line 344: g_count_uom := inv_cache.item_rec.primary_uom_code;

340: RAISE fnd_api.g_exc_error;
341: END IF;
342:
343: if(p_count_uom <> inv_cache.item_rec.primary_uom_code) then
344: g_count_uom := inv_cache.item_rec.primary_uom_code;
345: g_count_quantity := inv_convert.inv_um_convert ( p_inventory_item_id,
346: p_lot_number,
347: p_organization_id,
348: 5,

Line 4607: IF (inv_cache.set_item_rec(p_organization_id => g_cc_entry.organization_id, p_item_id => g_cc_entry.inventory_item_id))

4603: /* End of fix for bug number 4886188 */
4604:
4605: -- Bug 13796753 - Deleted block comments to improve file readibility
4606: -- Bug 13652899
4607: IF (inv_cache.set_item_rec(p_organization_id => g_cc_entry.organization_id, p_item_id => g_cc_entry.inventory_item_id))
4608: THEN
4609: l_from_uom := inv_cache.item_rec.primary_uom_code;
4610: l_serial_number_control_code := inv_cache.item_rec.serial_number_control_code;
4611: END IF;

Line 4609: l_from_uom := inv_cache.item_rec.primary_uom_code;

4605: -- Bug 13796753 - Deleted block comments to improve file readibility
4606: -- Bug 13652899
4607: IF (inv_cache.set_item_rec(p_organization_id => g_cc_entry.organization_id, p_item_id => g_cc_entry.inventory_item_id))
4608: THEN
4609: l_from_uom := inv_cache.item_rec.primary_uom_code;
4610: l_serial_number_control_code := inv_cache.item_rec.serial_number_control_code;
4611: END IF;
4612:
4613: SELECT NVL ( serial_count_option, 1 )

Line 4610: l_serial_number_control_code := inv_cache.item_rec.serial_number_control_code;

4606: -- Bug 13652899
4607: IF (inv_cache.set_item_rec(p_organization_id => g_cc_entry.organization_id, p_item_id => g_cc_entry.inventory_item_id))
4608: THEN
4609: l_from_uom := inv_cache.item_rec.primary_uom_code;
4610: l_serial_number_control_code := inv_cache.item_rec.serial_number_control_code;
4611: END IF;
4612:
4613: SELECT NVL ( serial_count_option, 1 )
4614: INTO l_serial_count_option

Line 4907: IF (inv_cache.set_item_rec(p_organization_id => g_cc_entry.organization_id, p_item_id => g_cc_entry.inventory_item_id))

4903: AND organization_id = g_cc_entry.organization_id;
4904: */
4905:
4906: -- Bug 13652899
4907: IF (inv_cache.set_item_rec(p_organization_id => g_cc_entry.organization_id, p_item_id => g_cc_entry.inventory_item_id))
4908: THEN
4909: l_to_uom := inv_cache.item_rec.primary_uom_code;
4910: END IF;
4911:

Line 4909: l_to_uom := inv_cache.item_rec.primary_uom_code;

4905:
4906: -- Bug 13652899
4907: IF (inv_cache.set_item_rec(p_organization_id => g_cc_entry.organization_id, p_item_id => g_cc_entry.inventory_item_id))
4908: THEN
4909: l_to_uom := inv_cache.item_rec.primary_uom_code;
4910: END IF;
4911:
4912: -- Convert the system quantity into the count uom
4913: /*2977288l_system_qty :=

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

5147: END IF;
5148:
5149: IF p_lpn_id IS NULL THEN
5150: -- Bug 13796753
5151: IF (inv_cache.set_item_rec(p_organization_id => p_organization_id, p_item_id => p_inventory_item_id))
5152: THEN
5153: l_lot_control_code := inv_cache.item_rec.lot_control_code;
5154: END IF;
5155:

Line 5153: l_lot_control_code := inv_cache.item_rec.lot_control_code;

5149: IF p_lpn_id IS NULL THEN
5150: -- Bug 13796753
5151: IF (inv_cache.set_item_rec(p_organization_id => p_organization_id, p_item_id => p_inventory_item_id))
5152: THEN
5153: l_lot_control_code := inv_cache.item_rec.lot_control_code;
5154: END IF;
5155:
5156: IF l_lot_control_code = 1 THEN -- no lot control code
5157: -- just check with msnt

Line 5812: IF (inv_cache.set_item_rec(p_organization_id => g_cc_entry.organization_id, p_item_id => g_cc_entry.inventory_item_id))

5808: END IF;
5809:
5810: -- Get the item primary uom code
5811: -- Bug 13652899
5812: IF (inv_cache.set_item_rec(p_organization_id => g_cc_entry.organization_id, p_item_id => g_cc_entry.inventory_item_id))
5813: THEN
5814: l_primary_uom := inv_cache.item_rec.primary_uom_code;
5815: END IF;
5816:

Line 5814: l_primary_uom := inv_cache.item_rec.primary_uom_code;

5810: -- Get the item primary uom code
5811: -- Bug 13652899
5812: IF (inv_cache.set_item_rec(p_organization_id => g_cc_entry.organization_id, p_item_id => g_cc_entry.inventory_item_id))
5813: THEN
5814: l_primary_uom := inv_cache.item_rec.primary_uom_code;
5815: END IF;
5816:
5817:
5818: IF ( l_debug = 1 ) THEN

Line 10155: IF inv_cache.set_org_rec ( p_organization_id) THEN

10151: WHEN NO_DATA_FOUND THEN
10152: null;
10153: END;
10154:
10155: IF inv_cache.set_org_rec ( p_organization_id) THEN
10156: l_serial_number_type := inv_cache.org_rec.serial_number_type;
10157: ELSE
10158: print_debug('Issue with Organization ');
10159: RETURN FALSE;

Line 10156: l_serial_number_type := inv_cache.org_rec.serial_number_type;

10152: null;
10153: END;
10154:
10155: IF inv_cache.set_org_rec ( p_organization_id) THEN
10156: l_serial_number_type := inv_cache.org_rec.serial_number_type;
10157: ELSE
10158: print_debug('Issue with Organization ');
10159: RETURN FALSE;
10160: END IF;

Line 10488: IF ( inv_cache.set_item_rec(p_organization_id => g_cc_entry.organization_id, p_item_id => g_cc_entry.inventory_item_id) ) THEN

10484: ROLLBACK TO save_serial_detail;
10485: RAISE FND_API.G_EXC_ERROR;
10486: END;
10487:
10488: IF ( inv_cache.set_item_rec(p_organization_id => g_cc_entry.organization_id, p_item_id => g_cc_entry.inventory_item_id) ) THEN
10489: g_count_uom := inv_cache.item_rec.primary_uom_code;
10490: END IF;
10491:
10492: g_cc_entry.approval_date := SYSDATE;

Line 10489: g_count_uom := inv_cache.item_rec.primary_uom_code;

10485: RAISE FND_API.G_EXC_ERROR;
10486: END;
10487:
10488: IF ( inv_cache.set_item_rec(p_organization_id => g_cc_entry.organization_id, p_item_id => g_cc_entry.inventory_item_id) ) THEN
10489: g_count_uom := inv_cache.item_rec.primary_uom_code;
10490: END IF;
10491:
10492: g_cc_entry.approval_date := SYSDATE;
10493: g_cc_entry.entry_status_code := 5; -- as there is no adjustment, count will be automatically approved