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

Line 260: If (inv_cache.set_mtt_rec(l_txn_type_id) AND

256: l_primary_quantity := x_request_line_rec.primary_quantity;
257: l_txn_type_id := x_request_line_rec.transaction_type_id;
258: l_inventory_item_id := x_request_line_rec.inventory_item_id;
259: l_organization_id := x_request_line_rec.organization_id;
260: If (inv_cache.set_mtt_rec(l_txn_type_id) AND
261: inv_cache.set_item_rec(l_organization_id, l_inventory_item_id) AND
262: inv_cache.set_org_rec(l_organization_id)) THEN
263:
264: print_debug('initing request_context ');

Line 261: inv_cache.set_item_rec(l_organization_id, l_inventory_item_id) AND

257: l_txn_type_id := x_request_line_rec.transaction_type_id;
258: l_inventory_item_id := x_request_line_rec.inventory_item_id;
259: l_organization_id := x_request_line_rec.organization_id;
260: If (inv_cache.set_mtt_rec(l_txn_type_id) AND
261: inv_cache.set_item_rec(l_organization_id, l_inventory_item_id) AND
262: inv_cache.set_org_rec(l_organization_id)) THEN
263:
264: print_debug('initing request_context ');
265: x_request_context.transaction_action_id := inv_cache.mtt_rec.transaction_action_id;

Line 262: inv_cache.set_org_rec(l_organization_id)) THEN

258: l_inventory_item_id := x_request_line_rec.inventory_item_id;
259: l_organization_id := x_request_line_rec.organization_id;
260: If (inv_cache.set_mtt_rec(l_txn_type_id) AND
261: inv_cache.set_item_rec(l_organization_id, l_inventory_item_id) AND
262: inv_cache.set_org_rec(l_organization_id)) THEN
263:
264: print_debug('initing request_context ');
265: x_request_context.transaction_action_id := inv_cache.mtt_rec.transaction_action_id;
266: x_request_context.transaction_source_type_id := inv_cache.mtt_rec.transaction_source_type_id;

Line 265: x_request_context.transaction_action_id := inv_cache.mtt_rec.transaction_action_id;

261: inv_cache.set_item_rec(l_organization_id, l_inventory_item_id) AND
262: inv_cache.set_org_rec(l_organization_id)) THEN
263:
264: print_debug('initing request_context ');
265: x_request_context.transaction_action_id := inv_cache.mtt_rec.transaction_action_id;
266: x_request_context.transaction_source_type_id := inv_cache.mtt_rec.transaction_source_type_id;
267: x_request_context.primary_uom_code := inv_cache.item_rec.primary_uom_code;
268: x_request_context.secondary_uom_code := inv_cache.item_rec.secondary_uom_code;
269: x_request_context.item_revision_control := inv_cache.item_rec.revision_qty_control_code;

Line 266: x_request_context.transaction_source_type_id := inv_cache.mtt_rec.transaction_source_type_id;

262: inv_cache.set_org_rec(l_organization_id)) THEN
263:
264: print_debug('initing request_context ');
265: x_request_context.transaction_action_id := inv_cache.mtt_rec.transaction_action_id;
266: x_request_context.transaction_source_type_id := inv_cache.mtt_rec.transaction_source_type_id;
267: x_request_context.primary_uom_code := inv_cache.item_rec.primary_uom_code;
268: x_request_context.secondary_uom_code := inv_cache.item_rec.secondary_uom_code;
269: x_request_context.item_revision_control := inv_cache.item_rec.revision_qty_control_code;
270: x_request_context.item_lot_control_code := inv_cache.item_rec.lot_control_code;

Line 267: x_request_context.primary_uom_code := inv_cache.item_rec.primary_uom_code;

263:
264: print_debug('initing request_context ');
265: x_request_context.transaction_action_id := inv_cache.mtt_rec.transaction_action_id;
266: x_request_context.transaction_source_type_id := inv_cache.mtt_rec.transaction_source_type_id;
267: x_request_context.primary_uom_code := inv_cache.item_rec.primary_uom_code;
268: x_request_context.secondary_uom_code := inv_cache.item_rec.secondary_uom_code;
269: x_request_context.item_revision_control := inv_cache.item_rec.revision_qty_control_code;
270: x_request_context.item_lot_control_code := inv_cache.item_rec.lot_control_code;
271: x_request_context.item_serial_control_code := inv_cache.item_rec.serial_number_control_code;

Line 268: x_request_context.secondary_uom_code := inv_cache.item_rec.secondary_uom_code;

264: print_debug('initing request_context ');
265: x_request_context.transaction_action_id := inv_cache.mtt_rec.transaction_action_id;
266: x_request_context.transaction_source_type_id := inv_cache.mtt_rec.transaction_source_type_id;
267: x_request_context.primary_uom_code := inv_cache.item_rec.primary_uom_code;
268: x_request_context.secondary_uom_code := inv_cache.item_rec.secondary_uom_code;
269: x_request_context.item_revision_control := inv_cache.item_rec.revision_qty_control_code;
270: x_request_context.item_lot_control_code := inv_cache.item_rec.lot_control_code;
271: x_request_context.item_serial_control_code := inv_cache.item_rec.serial_number_control_code;
272: x_request_context.item_locator_control_code := inv_cache.item_rec.location_control_code;

Line 269: x_request_context.item_revision_control := inv_cache.item_rec.revision_qty_control_code;

265: x_request_context.transaction_action_id := inv_cache.mtt_rec.transaction_action_id;
266: x_request_context.transaction_source_type_id := inv_cache.mtt_rec.transaction_source_type_id;
267: x_request_context.primary_uom_code := inv_cache.item_rec.primary_uom_code;
268: x_request_context.secondary_uom_code := inv_cache.item_rec.secondary_uom_code;
269: x_request_context.item_revision_control := inv_cache.item_rec.revision_qty_control_code;
270: x_request_context.item_lot_control_code := inv_cache.item_rec.lot_control_code;
271: x_request_context.item_serial_control_code := inv_cache.item_rec.serial_number_control_code;
272: x_request_context.item_locator_control_code := inv_cache.item_rec.location_control_code;
273: x_request_context.org_locator_control_code := inv_cache.org_rec.stock_locator_control_code;

Line 270: x_request_context.item_lot_control_code := inv_cache.item_rec.lot_control_code;

266: x_request_context.transaction_source_type_id := inv_cache.mtt_rec.transaction_source_type_id;
267: x_request_context.primary_uom_code := inv_cache.item_rec.primary_uom_code;
268: x_request_context.secondary_uom_code := inv_cache.item_rec.secondary_uom_code;
269: x_request_context.item_revision_control := inv_cache.item_rec.revision_qty_control_code;
270: x_request_context.item_lot_control_code := inv_cache.item_rec.lot_control_code;
271: x_request_context.item_serial_control_code := inv_cache.item_rec.serial_number_control_code;
272: x_request_context.item_locator_control_code := inv_cache.item_rec.location_control_code;
273: x_request_context.org_locator_control_code := inv_cache.org_rec.stock_locator_control_code;
274: x_request_context.unit_volume := inv_cache.item_rec.unit_volume;

Line 271: x_request_context.item_serial_control_code := inv_cache.item_rec.serial_number_control_code;

267: x_request_context.primary_uom_code := inv_cache.item_rec.primary_uom_code;
268: x_request_context.secondary_uom_code := inv_cache.item_rec.secondary_uom_code;
269: x_request_context.item_revision_control := inv_cache.item_rec.revision_qty_control_code;
270: x_request_context.item_lot_control_code := inv_cache.item_rec.lot_control_code;
271: x_request_context.item_serial_control_code := inv_cache.item_rec.serial_number_control_code;
272: x_request_context.item_locator_control_code := inv_cache.item_rec.location_control_code;
273: x_request_context.org_locator_control_code := inv_cache.org_rec.stock_locator_control_code;
274: x_request_context.unit_volume := inv_cache.item_rec.unit_volume;
275: x_request_context.volume_uom_code := inv_cache.item_rec.volume_uom_code;

Line 272: x_request_context.item_locator_control_code := inv_cache.item_rec.location_control_code;

268: x_request_context.secondary_uom_code := inv_cache.item_rec.secondary_uom_code;
269: x_request_context.item_revision_control := inv_cache.item_rec.revision_qty_control_code;
270: x_request_context.item_lot_control_code := inv_cache.item_rec.lot_control_code;
271: x_request_context.item_serial_control_code := inv_cache.item_rec.serial_number_control_code;
272: x_request_context.item_locator_control_code := inv_cache.item_rec.location_control_code;
273: x_request_context.org_locator_control_code := inv_cache.org_rec.stock_locator_control_code;
274: x_request_context.unit_volume := inv_cache.item_rec.unit_volume;
275: x_request_context.volume_uom_code := inv_cache.item_rec.volume_uom_code;
276: x_request_context.unit_weight := inv_cache.item_rec.unit_weight;

Line 273: x_request_context.org_locator_control_code := inv_cache.org_rec.stock_locator_control_code;

269: x_request_context.item_revision_control := inv_cache.item_rec.revision_qty_control_code;
270: x_request_context.item_lot_control_code := inv_cache.item_rec.lot_control_code;
271: x_request_context.item_serial_control_code := inv_cache.item_rec.serial_number_control_code;
272: x_request_context.item_locator_control_code := inv_cache.item_rec.location_control_code;
273: x_request_context.org_locator_control_code := inv_cache.org_rec.stock_locator_control_code;
274: x_request_context.unit_volume := inv_cache.item_rec.unit_volume;
275: x_request_context.volume_uom_code := inv_cache.item_rec.volume_uom_code;
276: x_request_context.unit_weight := inv_cache.item_rec.unit_weight;
277: x_request_context.weight_uom_code := inv_cache.item_rec.weight_uom_code;

Line 274: x_request_context.unit_volume := inv_cache.item_rec.unit_volume;

270: x_request_context.item_lot_control_code := inv_cache.item_rec.lot_control_code;
271: x_request_context.item_serial_control_code := inv_cache.item_rec.serial_number_control_code;
272: x_request_context.item_locator_control_code := inv_cache.item_rec.location_control_code;
273: x_request_context.org_locator_control_code := inv_cache.org_rec.stock_locator_control_code;
274: x_request_context.unit_volume := inv_cache.item_rec.unit_volume;
275: x_request_context.volume_uom_code := inv_cache.item_rec.volume_uom_code;
276: x_request_context.unit_weight := inv_cache.item_rec.unit_weight;
277: x_request_context.weight_uom_code := inv_cache.item_rec.weight_uom_code;
278: x_request_context.item_reservable_type := inv_cache.item_rec.reservable_type;

Line 275: x_request_context.volume_uom_code := inv_cache.item_rec.volume_uom_code;

271: x_request_context.item_serial_control_code := inv_cache.item_rec.serial_number_control_code;
272: x_request_context.item_locator_control_code := inv_cache.item_rec.location_control_code;
273: x_request_context.org_locator_control_code := inv_cache.org_rec.stock_locator_control_code;
274: x_request_context.unit_volume := inv_cache.item_rec.unit_volume;
275: x_request_context.volume_uom_code := inv_cache.item_rec.volume_uom_code;
276: x_request_context.unit_weight := inv_cache.item_rec.unit_weight;
277: x_request_context.weight_uom_code := inv_cache.item_rec.weight_uom_code;
278: x_request_context.item_reservable_type := inv_cache.item_rec.reservable_type;
279: l_end_assembly_pegging_flag := NVL(inv_cache.item_rec.end_assembly_pegging_flag,'N');

Line 276: x_request_context.unit_weight := inv_cache.item_rec.unit_weight;

272: x_request_context.item_locator_control_code := inv_cache.item_rec.location_control_code;
273: x_request_context.org_locator_control_code := inv_cache.org_rec.stock_locator_control_code;
274: x_request_context.unit_volume := inv_cache.item_rec.unit_volume;
275: x_request_context.volume_uom_code := inv_cache.item_rec.volume_uom_code;
276: x_request_context.unit_weight := inv_cache.item_rec.unit_weight;
277: x_request_context.weight_uom_code := inv_cache.item_rec.weight_uom_code;
278: x_request_context.item_reservable_type := inv_cache.item_rec.reservable_type;
279: l_end_assembly_pegging_flag := NVL(inv_cache.item_rec.end_assembly_pegging_flag,'N');
280: l_allocate_serial_flag := inv_cache.org_rec.allocate_serial_flag;

Line 277: x_request_context.weight_uom_code := inv_cache.item_rec.weight_uom_code;

273: x_request_context.org_locator_control_code := inv_cache.org_rec.stock_locator_control_code;
274: x_request_context.unit_volume := inv_cache.item_rec.unit_volume;
275: x_request_context.volume_uom_code := inv_cache.item_rec.volume_uom_code;
276: x_request_context.unit_weight := inv_cache.item_rec.unit_weight;
277: x_request_context.weight_uom_code := inv_cache.item_rec.weight_uom_code;
278: x_request_context.item_reservable_type := inv_cache.item_rec.reservable_type;
279: l_end_assembly_pegging_flag := NVL(inv_cache.item_rec.end_assembly_pegging_flag,'N');
280: l_allocate_serial_flag := inv_cache.org_rec.allocate_serial_flag;
281: ELSE

Line 278: x_request_context.item_reservable_type := inv_cache.item_rec.reservable_type;

274: x_request_context.unit_volume := inv_cache.item_rec.unit_volume;
275: x_request_context.volume_uom_code := inv_cache.item_rec.volume_uom_code;
276: x_request_context.unit_weight := inv_cache.item_rec.unit_weight;
277: x_request_context.weight_uom_code := inv_cache.item_rec.weight_uom_code;
278: x_request_context.item_reservable_type := inv_cache.item_rec.reservable_type;
279: l_end_assembly_pegging_flag := NVL(inv_cache.item_rec.end_assembly_pegging_flag,'N');
280: l_allocate_serial_flag := inv_cache.org_rec.allocate_serial_flag;
281: ELSE
282: print_debug('init request_context no data found');

Line 279: l_end_assembly_pegging_flag := NVL(inv_cache.item_rec.end_assembly_pegging_flag,'N');

275: x_request_context.volume_uom_code := inv_cache.item_rec.volume_uom_code;
276: x_request_context.unit_weight := inv_cache.item_rec.unit_weight;
277: x_request_context.weight_uom_code := inv_cache.item_rec.weight_uom_code;
278: x_request_context.item_reservable_type := inv_cache.item_rec.reservable_type;
279: l_end_assembly_pegging_flag := NVL(inv_cache.item_rec.end_assembly_pegging_flag,'N');
280: l_allocate_serial_flag := inv_cache.org_rec.allocate_serial_flag;
281: ELSE
282: print_debug('init request_context no data found');
283: IF inv_pp_debug.is_debug_mode THEN

Line 280: l_allocate_serial_flag := inv_cache.org_rec.allocate_serial_flag;

276: x_request_context.unit_weight := inv_cache.item_rec.unit_weight;
277: x_request_context.weight_uom_code := inv_cache.item_rec.weight_uom_code;
278: x_request_context.item_reservable_type := inv_cache.item_rec.reservable_type;
279: l_end_assembly_pegging_flag := NVL(inv_cache.item_rec.end_assembly_pegging_flag,'N');
280: l_allocate_serial_flag := inv_cache.org_rec.allocate_serial_flag;
281: ELSE
282: print_debug('init request_context no data found');
283: IF inv_pp_debug.is_debug_mode THEN
284: inv_pp_debug.send_message_to_pipe('mo context not found');

Line 1169: AND (inv_cache.is_pickrelease)) THEN --Bug 5246569

1165: IF p_subinventory_code IS NOT NULL THEN
1166: -- get status
1167: IF (nvl(g_isllta_subinventory_code,'@@@') = p_subinventory_code
1168: AND nvl(g_isllta_transaction_type_id, -1) = p_transaction_type_id
1169: AND (inv_cache.is_pickrelease)) THEN --Bug 5246569
1170: l_sub_return := g_sub_return;
1171: ELSE
1172: OPEN c_sub_status;
1173: FETCH c_sub_status INTO l_sub_status;

Line 1207: AND (inv_cache.is_pickrelease)) THEN --Bug 5246569

1203: IF p_locator_id IS NOT NULL THEN
1204: --get status
1205: IF (nvl(g_isllta_locator_id,-1) = p_locator_id
1206: AND nvl(g_isllta_transaction_type_id, -1) = p_transaction_type_id
1207: AND (inv_cache.is_pickrelease)) THEN --Bug 5246569
1208: l_loc_return := g_loc_return;
1209: ELSE
1210: OPEN c_loc_status;
1211: FETCH c_loc_status INTO l_loc_status;

Line 1263: AND (inv_cache.is_pickrelease)) THEN --Bug 5246569

1259: if l_lot_status_enabled = 'Y' AND p_lot_number IS NOT NULL THEN
1260: --get status
1261: IF (nvl(g_isllta_lot_number,'@@@') = p_lot_number
1262: AND nvl(g_isllta_transaction_type_id, -1) = p_transaction_type_id
1263: AND (inv_cache.is_pickrelease)) THEN --Bug 5246569
1264: l_lot_return := g_lot_return;
1265: ELSE
1266: OPEN c_lot_status;
1267: FETCH c_lot_status INTO l_lot_status;

Line 1682: IF g_debug IS NULL or NOT INV_CACHE.is_pickrelease THEN

1678: x_return_status := fnd_api.g_ret_sts_success ;
1679: x_available_sl_qty := 0;
1680: x_serial_index := 0;
1681:
1682: IF g_debug IS NULL or NOT INV_CACHE.is_pickrelease THEN
1683: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),2);
1684: END IF;
1685: l_debug := g_debug;
1686:

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

1689: print_debug('orgid='||p_organization_id||' itm='||p_inventory_item_id||' rev='||p_revision||' lot='||p_lot_number||' sub='||p_subinventory_code||' loc='||p_locator_id||' qty='||p_required_sl_qty||' fmsn='||p_from_range||' tosn='||p_to_range, 4);
1690: print_debug('unt='||p_unit_number||' det='||p_detail_any_serial||' cg='||p_cost_group_id||' trxtyp='||p_transaction_type_id||' styp='||p_demand_source_type_id||' shdr='||p_demand_source_header_id||' sln='||p_demand_source_line_id, 4);
1691: END IF;
1692:
1693: IF ( inv_cache.set_org_rec(p_organization_id) ) THEN
1694: l_allocate_serial_flag := inv_cache.org_rec.allocate_serial_flag;
1695: IF ( l_debug = 1 ) THEN
1696: print_debug('allocate_serial_flag= '||l_allocate_serial_flag);
1697: END IF;

Line 1694: l_allocate_serial_flag := inv_cache.org_rec.allocate_serial_flag;

1690: print_debug('unt='||p_unit_number||' det='||p_detail_any_serial||' cg='||p_cost_group_id||' trxtyp='||p_transaction_type_id||' styp='||p_demand_source_type_id||' shdr='||p_demand_source_header_id||' sln='||p_demand_source_line_id, 4);
1691: END IF;
1692:
1693: IF ( inv_cache.set_org_rec(p_organization_id) ) THEN
1694: l_allocate_serial_flag := inv_cache.org_rec.allocate_serial_flag;
1695: IF ( l_debug = 1 ) THEN
1696: print_debug('allocate_serial_flag= '||l_allocate_serial_flag);
1697: END IF;
1698: ELSE

Line 3118: IF g_debug IS NULL or NOT INV_CACHE.is_pickrelease THEN

3114: inv_pp_debug.send_message_to_pipe('enter '||g_pkg_name||'.'||l_api_name);
3115: END IF;
3116: -- end of debugging section
3117: --
3118: IF g_debug IS NULL or NOT INV_CACHE.is_pickrelease THEN
3119: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),2);
3120: END IF;
3121: l_debug := g_debug;
3122:

Line 3403: l_today := nvl(inv_cache.mo_transaction_date, SYSDATE);

3399: END IF;
3400:
3401: --l_mmtt_tbl(l_mmtt_tbl_size).transaction_source_name :=
3402: -- p_request_line_rec.transaction_source_name;
3403: l_today := nvl(inv_cache.mo_transaction_date, SYSDATE);
3404:
3405: l_mmtt_tbl(l_mmtt_tbl_size).transaction_date := l_today;
3406: -- get accounting period id
3407: IF p_request_context.transfer_flag -- transfer

Line 3461: l_task_priority := NVL(inv_cache.wpb_rec.task_priority,-1);

3457: ELSIF p_request_context.item_serial_control_code <> 1 THEN
3458: l_mmtt_tbl(l_mmtt_tbl_size).serial_allocated_flag := 'N';
3459: END IF;
3460: -- 4292157: task priority project
3461: l_task_priority := NVL(inv_cache.wpb_rec.task_priority,-1);
3462: IF l_task_priority > 0 AND inv_cache.wms_installed
3463: THEN
3464: l_mmtt_tbl(l_mmtt_tbl_size).task_priority := l_task_priority;
3465: END IF;

Line 3462: IF l_task_priority > 0 AND inv_cache.wms_installed

3458: l_mmtt_tbl(l_mmtt_tbl_size).serial_allocated_flag := 'N';
3459: END IF;
3460: -- 4292157: task priority project
3461: l_task_priority := NVL(inv_cache.wpb_rec.task_priority,-1);
3462: IF l_task_priority > 0 AND inv_cache.wms_installed
3463: THEN
3464: l_mmtt_tbl(l_mmtt_tbl_size).task_priority := l_task_priority;
3465: END IF;
3466:

Line 3488: IF inv_cache.set_mtt_rec(p_request_line_rec.transaction_type_id) THEN

3484: p_request_line_rec.project_id;
3485: l_mmtt_tbl(l_mmtt_tbl_size).source_task_id :=
3486: p_request_line_rec.task_id;
3487: ELSE
3488: IF inv_cache.set_mtt_rec(p_request_line_rec.transaction_type_id) THEN
3489: l_proj_enabled := NVL(inv_cache.mtt_rec.type_class,2);
3490: END IF;
3491:
3492: --find out if network logistics is installed

Line 3489: l_proj_enabled := NVL(inv_cache.mtt_rec.type_class,2);

3485: l_mmtt_tbl(l_mmtt_tbl_size).source_task_id :=
3486: p_request_line_rec.task_id;
3487: ELSE
3488: IF inv_cache.set_mtt_rec(p_request_line_rec.transaction_type_id) THEN
3489: l_proj_enabled := NVL(inv_cache.mtt_rec.type_class,2);
3490: END IF;
3491:
3492: --find out if network logistics is installed
3493: IF g_nl_installed is NULL THEN

Line 3821: inv_cache.mo_transaction_date := p_date;

3817:
3818: PROCEDURE set_mo_transact_date (
3819: p_date IN DATE) IS
3820: BEGIN
3821: inv_cache.mo_transaction_date := p_date;
3822: END;
3823:
3824: PROCEDURE clear_mo_transact_date IS
3825: BEGIN

Line 3826: inv_cache.mo_transaction_date := NULL;

3822: END;
3823:
3824: PROCEDURE clear_mo_transact_date IS
3825: BEGIN
3826: inv_cache.mo_transaction_date := NULL;
3827: END;
3828:
3829:
3830: -- LPN Status Project