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

Line 661: l_return_value := INV_CACHE.set_fromsub_rec(

657:
658: -- Check if the picking subinventory (if specified on the MO) is
659: -- reservable OR not
660: IF (p_mo_line_rec.from_subinventory_code IS NOT NULL) THEN
661: l_return_value := INV_CACHE.set_fromsub_rec(
662: p_mo_line_rec.organization_id,
663: p_mo_line_rec.from_subinventory_code);
664: If NOT l_return_value Then
665: if is_debug then

Line 670: g_sub_reservable_type := INV_CACHE.fromsub_rec.reservable_type;

666: print_debug('Error setting from sub cache','Inv_Pick_Release_PVT.Process_Reservations');
667: end if;
668: RAISE fnd_api.g_exc_unexpected_error;
669: End If;
670: g_sub_reservable_type := INV_CACHE.fromsub_rec.reservable_type;
671: ELSE
672: g_sub_reservable_type := 1;
673: END IF;
674:

Line 748: l_return_value := INV_CACHE.set_item_rec(

744: l_qty_to_detail_unconv := p_mo_line_rec.quantity - NVL(p_mo_line_rec.quantity_detailed, 0);
745: l_sec_quantity_to_detail := p_mo_line_rec.secondary_quantity - NVL(p_mo_line_rec.secondary_quantity_detailed, 0);
746: l_grade_code := p_mo_line_rec.grade_code;
747:
748: l_return_value := INV_CACHE.set_item_rec(
749: p_mo_line_rec.organization_id,
750: p_mo_line_rec.inventory_item_id);
751: If NOT l_return_value Then
752: if is_debug then

Line 759: l_primary_uom:= INV_CACHE.item_rec.primary_uom_code;

755: end if;
756: RAISE fnd_api.g_exc_unexpected_error;
757: End If;
758:
759: l_primary_uom:= INV_CACHE.item_rec.primary_uom_code;
760: l_secondary_uom:= INV_CACHE.item_rec.secondary_uom_code;
761: l_revision_control_code:= INV_CACHE.item_rec.revision_qty_control_code;
762: l_lot_control_code:= INV_CACHE.item_rec.lot_control_code;
763: l_serial_control_code:= INV_CACHE.item_rec.serial_number_control_code;

Line 760: l_secondary_uom:= INV_CACHE.item_rec.secondary_uom_code;

756: RAISE fnd_api.g_exc_unexpected_error;
757: End If;
758:
759: l_primary_uom:= INV_CACHE.item_rec.primary_uom_code;
760: l_secondary_uom:= INV_CACHE.item_rec.secondary_uom_code;
761: l_revision_control_code:= INV_CACHE.item_rec.revision_qty_control_code;
762: l_lot_control_code:= INV_CACHE.item_rec.lot_control_code;
763: l_serial_control_code:= INV_CACHE.item_rec.serial_number_control_code;
764:

Line 761: l_revision_control_code:= INV_CACHE.item_rec.revision_qty_control_code;

757: End If;
758:
759: l_primary_uom:= INV_CACHE.item_rec.primary_uom_code;
760: l_secondary_uom:= INV_CACHE.item_rec.secondary_uom_code;
761: l_revision_control_code:= INV_CACHE.item_rec.revision_qty_control_code;
762: l_lot_control_code:= INV_CACHE.item_rec.lot_control_code;
763: l_serial_control_code:= INV_CACHE.item_rec.serial_number_control_code;
764:
765: IF(l_lot_control_code = inv_reservation_global.g_lot_control_yes AND INV_CACHE.item_rec.lot_divisible_flag <> 'Y') THEN

Line 762: l_lot_control_code:= INV_CACHE.item_rec.lot_control_code;

758:
759: l_primary_uom:= INV_CACHE.item_rec.primary_uom_code;
760: l_secondary_uom:= INV_CACHE.item_rec.secondary_uom_code;
761: l_revision_control_code:= INV_CACHE.item_rec.revision_qty_control_code;
762: l_lot_control_code:= INV_CACHE.item_rec.lot_control_code;
763: l_serial_control_code:= INV_CACHE.item_rec.serial_number_control_code;
764:
765: IF(l_lot_control_code = inv_reservation_global.g_lot_control_yes AND INV_CACHE.item_rec.lot_divisible_flag <> 'Y') THEN
766: l_lot_divisible_flag := 'N';

Line 763: l_serial_control_code:= INV_CACHE.item_rec.serial_number_control_code;

759: l_primary_uom:= INV_CACHE.item_rec.primary_uom_code;
760: l_secondary_uom:= INV_CACHE.item_rec.secondary_uom_code;
761: l_revision_control_code:= INV_CACHE.item_rec.revision_qty_control_code;
762: l_lot_control_code:= INV_CACHE.item_rec.lot_control_code;
763: l_serial_control_code:= INV_CACHE.item_rec.serial_number_control_code;
764:
765: IF(l_lot_control_code = inv_reservation_global.g_lot_control_yes AND INV_CACHE.item_rec.lot_divisible_flag <> 'Y') THEN
766: l_lot_divisible_flag := 'N';
767: ELSE

Line 765: IF(l_lot_control_code = inv_reservation_global.g_lot_control_yes AND INV_CACHE.item_rec.lot_divisible_flag <> 'Y') THEN

761: l_revision_control_code:= INV_CACHE.item_rec.revision_qty_control_code;
762: l_lot_control_code:= INV_CACHE.item_rec.lot_control_code;
763: l_serial_control_code:= INV_CACHE.item_rec.serial_number_control_code;
764:
765: IF(l_lot_control_code = inv_reservation_global.g_lot_control_yes AND INV_CACHE.item_rec.lot_divisible_flag <> 'Y') THEN
766: l_lot_divisible_flag := 'N';
767: ELSE
768: l_lot_divisible_flag := 'Y';
769: END IF;

Line 834: l_return_value := INV_CACHE.set_oola_rec(p_demand_info.oe_line_id);

830: END IF;
831: -- Bug 4171297, if the order line has Wip supply reservation then l_quantity_to_detail
832: -- should be calculated based on order line quantity. Adding the below logic to calculate
833: -- the l_quantity_to_detail.
834: l_return_value := INV_CACHE.set_oola_rec(p_demand_info.oe_line_id);
835: IF NOT l_return_value Then
836: IF (is_debug) THEN
837: print_debug('Error setting cache for order line', 'Inv_Pick_Release_PVT.Process_Reservations');
838: END IF;

Line 842: l_order_line_qty_unconv := INV_CACHE.oola_rec.ordered_quantity;

838: END IF;
839: RAISE fnd_api.g_exc_unexpected_error;
840: END IF;
841:
842: l_order_line_qty_unconv := INV_CACHE.oola_rec.ordered_quantity;
843: l_order_line_uom := INV_CACHE.oola_rec.order_quantity_uom;
844:
845: IF (is_debug) THEN
846: print_debug('l_order_line_qty_unconv = ' ||l_order_line_qty_unconv, 'Inv_Pick_Release_PVT.Process_Reservations');

Line 843: l_order_line_uom := INV_CACHE.oola_rec.order_quantity_uom;

839: RAISE fnd_api.g_exc_unexpected_error;
840: END IF;
841:
842: l_order_line_qty_unconv := INV_CACHE.oola_rec.ordered_quantity;
843: l_order_line_uom := INV_CACHE.oola_rec.order_quantity_uom;
844:
845: IF (is_debug) THEN
846: print_debug('l_order_line_qty_unconv = ' ||l_order_line_qty_unconv, 'Inv_Pick_Release_PVT.Process_Reservations');
847: print_debug('l_order_line_uom = ' ||l_order_line_uom, 'Inv_Pick_Release_PVT.Process_Reservations');

Line 1338: IF (INV_CACHE.set_item_rec( p_mo_line_rec.organization_id, p_mo_line_rec.inventory_item_id)) THEN

1334: IF ( nvl(l_demand_rsvs_ordered(l_res_tbl_index).primary_reservation_quantity,0)
1335: - nvl(l_demand_rsvs_ordered(l_res_tbl_index).detailed_quantity,0) > 0) THEN
1336:
1337: -- Bug 5535030: fetch from get_rsv_serials only for serial controlled items
1338: IF (INV_CACHE.set_item_rec( p_mo_line_rec.organization_id, p_mo_line_rec.inventory_item_id)) THEN
1339: IF INV_CACHE.item_rec.serial_number_control_code NOT IN (1,6) THEN
1340: l_rsv_serials.DELETE;
1341: OPEN get_rsv_serials(l_demand_rsvs_ordered(l_res_tbl_index).reservation_id);
1342: FETCH get_rsv_serials bulk collect INTO l_rsv_serials;

Line 1339: IF INV_CACHE.item_rec.serial_number_control_code NOT IN (1,6) THEN

1335: - nvl(l_demand_rsvs_ordered(l_res_tbl_index).detailed_quantity,0) > 0) THEN
1336:
1337: -- Bug 5535030: fetch from get_rsv_serials only for serial controlled items
1338: IF (INV_CACHE.set_item_rec( p_mo_line_rec.organization_id, p_mo_line_rec.inventory_item_id)) THEN
1339: IF INV_CACHE.item_rec.serial_number_control_code NOT IN (1,6) THEN
1340: l_rsv_serials.DELETE;
1341: OPEN get_rsv_serials(l_demand_rsvs_ordered(l_res_tbl_index).reservation_id);
1342: FETCH get_rsv_serials bulk collect INTO l_rsv_serials;
1343: CLOSE get_rsv_serials;

Line 1718: l_return_value := INV_CACHE.set_org_rec(p_mo_line_rec.organization_id);

1714: print_debug('Move ORder has project reference',
1715: 'Inv_Pick_Release_PVT.Process_Prj_Dynamic_Locator');
1716: END IF;
1717:
1718: l_return_value := INV_CACHE.set_org_rec(p_mo_line_rec.organization_id);
1719: IF NOT l_return_value THEN
1720: IF (is_debug) THEN
1721: print_debug('error setting org cache',
1722: 'Inv_Pick_Release_PVt.Process_Prj_Dynamic_Locator');

Line 1726: l_org_loc_control := INV_CACHE.org_rec.stock_locator_control_code;

1722: 'Inv_Pick_Release_PVt.Process_Prj_Dynamic_Locator');
1723: END IF;
1724: RAISE fnd_api.g_exc_unexpected_error;
1725: END IF;
1726: l_org_loc_control := INV_CACHE.org_rec.stock_locator_control_code;
1727:
1728: l_return_value := INV_CACHE.set_item_rec(
1729: p_mo_line_rec.organization_id,
1730: p_mo_line_rec.inventory_item_id);

Line 1728: l_return_value := INV_CACHE.set_item_rec(

1724: RAISE fnd_api.g_exc_unexpected_error;
1725: END IF;
1726: l_org_loc_control := INV_CACHE.org_rec.stock_locator_control_code;
1727:
1728: l_return_value := INV_CACHE.set_item_rec(
1729: p_mo_line_rec.organization_id,
1730: p_mo_line_rec.inventory_item_id);
1731: IF NOT l_return_value THEN
1732: IF (is_debug) THEN

Line 1738: l_item_loc_control := INV_CACHE.item_rec.location_control_code;

1734: 'Inv_Pick_Release_PVt.Process_Prj_Dynamic_Locator');
1735: END IF;
1736: RAISE fnd_api.g_exc_unexpected_error;
1737: END IF;
1738: l_item_loc_control := INV_CACHE.item_rec.location_control_code;
1739:
1740: l_return_value := INV_CACHE.set_tosub_rec(
1741: p_mo_line_rec.organization_id,
1742: l_to_subinventory);

Line 1740: l_return_value := INV_CACHE.set_tosub_rec(

1736: RAISE fnd_api.g_exc_unexpected_error;
1737: END IF;
1738: l_item_loc_control := INV_CACHE.item_rec.location_control_code;
1739:
1740: l_return_value := INV_CACHE.set_tosub_rec(
1741: p_mo_line_rec.organization_id,
1742: l_to_subinventory);
1743: IF NOT l_return_value THEN
1744: IF (is_debug) THEN

Line 1750: l_sub_loc_control := INV_CACHE.tosub_rec.locator_type;

1746: 'Inv_Pick_Release_PVt.Process_Prj_Dynamic_Locator');
1747: END IF;
1748: RAISE fnd_api.g_exc_unexpected_error;
1749: END IF;
1750: l_sub_loc_control := INV_CACHE.tosub_rec.locator_type;
1751:
1752: IF (is_debug) THEN
1753: print_debug('l_org_loc_control is '|| l_org_loc_control, 'Inv_Pick_Release_PVT.Process_Prj_Dynamic_Locator');
1754: print_debug('l_item_loc_control is '|| l_item_loc_control, 'Inv_Pick_Release_PVT.Process_Prj_Dynamic_Locator');

Line 1818: , p_org => INV_CACHE.org_rec

1814: l_locator.segment19 := p_mo_line_rec.project_id;
1815: l_locator.segment20 := p_mo_line_rec.task_id;
1816: success := inv_validate.validatelocator(
1817: p_locator => l_locator
1818: , p_org => INV_CACHE.org_rec
1819: , p_sub => INV_CACHE.tosub_rec
1820: , p_validation_mode => inv_validate.exists_or_create
1821: , p_value_or_id => 'I'
1822: );

Line 1819: , p_sub => INV_CACHE.tosub_rec

1815: l_locator.segment20 := p_mo_line_rec.task_id;
1816: success := inv_validate.validatelocator(
1817: p_locator => l_locator
1818: , p_org => INV_CACHE.org_rec
1819: , p_sub => INV_CACHE.tosub_rec
1820: , p_validation_mode => inv_validate.exists_or_create
1821: , p_value_or_id => 'I'
1822: );
1823:

Line 2175: l_return_value := INV_CACHE.set_item_rec(p_mo_line_rec.organization_id, p_mo_line_rec.inventory_item_id);

2171: END;
2172: IF (is_debug) THEN
2173: gmi_reservation_util.println('Process_Line after fetch wdd');
2174: END IF;
2175: l_return_value := INV_CACHE.set_item_rec(p_mo_line_rec.organization_id, p_mo_line_rec.inventory_item_id);
2176: IF NOT l_return_value THEN
2177: If is_debug THEN
2178: print_debug('Error setting item cache', 'Inv_Pick_Release_PVT.Process_Line');
2179: End If;

Line 2182: l_reservable_type:= INV_CACHE.item_rec.reservable_type;

2178: print_debug('Error setting item cache', 'Inv_Pick_Release_PVT.Process_Line');
2179: End If;
2180: raise fnd_api.g_exc_unexpected_error;
2181: End If;
2182: l_reservable_type:= INV_CACHE.item_rec.reservable_type;
2183:
2184: IF p_mo_line_rec.transaction_type_id = 52 THEN
2185: l_demand_source_type := 2;
2186: ELSIF p_mo_line_rec.transaction_type_id = 53 THEN

Line 2191: l_return_value := INV_CACHE.set_mtt_rec(p_mo_line_rec.transaction_type_id);

2187: l_demand_source_type := 8;
2188: ELSIF g_transaction_type_id = p_mo_line_rec.transaction_type_id THEN
2189: l_demand_source_type := g_transaction_source_type_id;
2190: ELSE
2191: l_return_value := INV_CACHE.set_mtt_rec(p_mo_line_rec.transaction_type_id);
2192: IF NOT l_return_value THEN
2193: If is_debug THEN
2194: print_debug('Error setting item cache','Inv_Pick_Release_PVT.Process_Line');
2195: End If;

Line 2198: l_demand_source_type := INV_CACHE.mtt_rec.transaction_source_type_id;

2194: print_debug('Error setting item cache','Inv_Pick_Release_PVT.Process_Line');
2195: End If;
2196: raise fnd_api.g_exc_unexpected_error;
2197: End If;
2198: l_demand_source_type := INV_CACHE.mtt_rec.transaction_source_type_id;
2199: g_transaction_type_id := p_mo_line_rec.transaction_type_id;
2200: g_transaction_source_type_id := l_demand_source_type;
2201: END IF;
2202: IF (is_debug) THEN

Line 2209: l_return_value := INV_CACHE.set_mso_rec(l_demand_info.oe_header_id);

2205:
2206: -- Compute the MTL_SALES_ORDERS header ID to use when dealing with reservations.
2207: --l_mso_header_id := inv_salesorder.get_salesorder_for_oeheader(l_demand_info.oe_header_id);
2208:
2209: l_return_value := INV_CACHE.set_mso_rec(l_demand_info.oe_header_id);
2210: IF NOT l_return_value THEN
2211: IF (is_debug) THEN
2212: print_debug('No Mtl_Sales_Order ID found for oe header', 'Inv_Pick_Release_PVT.Process_Line');
2213: gmi_reservation_util.println('No Mtl_Sales_Order ID found for oe header');

Line 2220: l_mso_header_id := INV_CACHE.mso_rec.sales_order_id;

2216: fnd_msg_pub.ADD;
2217: RAISE fnd_api.g_exc_unexpected_error;
2218: END IF;
2219:
2220: l_mso_header_id := INV_CACHE.mso_rec.sales_order_id;
2221:
2222: IF (is_debug) THEN
2223: gmi_reservation_util.println('Process_Line, l_mso_header_id '|| l_mso_header_id);
2224:

Line 2288: l_return_value := INV_CACHE.set_mtrh_rec(p_mo_line_rec.header_id);

2284: AND p_allow_partial_pick = fnd_api.g_true
2285: AND l_call_mode IS NULL THEN
2286: COMMIT WORK;
2287:
2288: l_return_value := INV_CACHE.set_mtrh_rec(p_mo_line_rec.header_id);
2289: IF NOT l_return_value THEN
2290: If is_debug THEN
2291: print_debug('Error setting header cache', 'Inv_Pick_Release_PVT.Process_Line');
2292: End If;

Line 2295: l_request_number := INV_CACHE.mtrh_rec.request_number;

2291: print_debug('Error setting header cache', 'Inv_Pick_Release_PVT.Process_Line');
2292: End If;
2293: raise fnd_api.g_exc_unexpected_error;
2294: END IF;
2295: l_request_number := INV_CACHE.mtrh_rec.request_number;
2296:
2297: IF g_request_number is NOT NULL and
2298: g_request_number = l_request_number AND
2299: g_report_set_id IS NOT NULL THEN

Line 2344: l_lot_control_code:= INV_CACHE.item_rec.lot_control_code;

2340: ELSE
2341: print_debug('Non-standard reservable type: ' || l_reservable_type, 'Inv_Pick_Release_PVT.Process_Line');
2342: END IF; -- The item is reservable
2343:
2344: l_lot_control_code:= INV_CACHE.item_rec.lot_control_code;
2345:
2346: IF (l_lot_control_code = inv_reservation_global.g_lot_control_yes AND INV_CACHE.item_rec.lot_divisible_flag <> 'Y') THEN
2347: l_lot_divisible_flag := 'N';
2348: ELSE

Line 2346: IF (l_lot_control_code = inv_reservation_global.g_lot_control_yes AND INV_CACHE.item_rec.lot_divisible_flag <> 'Y') THEN

2342: END IF; -- The item is reservable
2343:
2344: l_lot_control_code:= INV_CACHE.item_rec.lot_control_code;
2345:
2346: IF (l_lot_control_code = inv_reservation_global.g_lot_control_yes AND INV_CACHE.item_rec.lot_divisible_flag <> 'Y') THEN
2347: l_lot_divisible_flag := 'N';
2348: ELSE
2349: l_lot_divisible_flag := 'Y';
2350: END IF;

Line 2389: inv_cache.tolocator_id := p_mo_line_rec.to_locator_id;

2385: print_debug('calling create suggestions', 'Inv_Pick_Release_PVT.Process_Line');
2386: print_debug('line_id is '|| p_mo_line_rec.line_id, 'Inv_Pick_Release_PVT.Process_line');
2387: END IF;
2388: --Bug3237702 starts added for caching
2389: inv_cache.tolocator_id := p_mo_line_rec.to_locator_id;
2390: inv_cache.tosubinventory_code := p_mo_line_rec.to_subinventory_code;
2391: --Bug3237702 ends
2392: -- Bug 5264987 Added p_organization_id to the create_suggestions call
2393: inv_ppengine_pvt.create_suggestions(

Line 2390: inv_cache.tosubinventory_code := p_mo_line_rec.to_subinventory_code;

2386: print_debug('line_id is '|| p_mo_line_rec.line_id, 'Inv_Pick_Release_PVT.Process_line');
2387: END IF;
2388: --Bug3237702 starts added for caching
2389: inv_cache.tolocator_id := p_mo_line_rec.to_locator_id;
2390: inv_cache.tosubinventory_code := p_mo_line_rec.to_subinventory_code;
2391: --Bug3237702 ends
2392: -- Bug 5264987 Added p_organization_id to the create_suggestions call
2393: inv_ppengine_pvt.create_suggestions(
2394: p_api_version => 1.0

Line 2439: l_return_value := INV_CACHE.set_mtrh_rec(p_mo_line_rec.header_id);

2435: END IF;
2436:
2437: ROLLBACK TO process_line_pvt;
2438:
2439: l_return_value := INV_CACHE.set_mtrh_rec(p_mo_line_rec.header_id);
2440: IF NOT l_return_value THEN
2441: If is_debug THEN
2442: print_debug('Error setting header cache', 'Inv_Pick_Release_PVT.Process_Line');
2443: End If;

Line 2446: l_request_number := INV_CACHE.mtrh_rec.request_number;

2442: print_debug('Error setting header cache', 'Inv_Pick_Release_PVT.Process_Line');
2443: End If;
2444: raise fnd_api.g_exc_unexpected_error;
2445: END IF;
2446: l_request_number := INV_CACHE.mtrh_rec.request_number;
2447:
2448: fnd_message.set_name('INV', 'INV_DETAILING_FAILED');
2449: fnd_message.set_token('LINE_NUM', TO_CHAR(p_mo_line_rec.line_number));
2450: fnd_message.set_token('MO_NUMBER', l_request_number);

Line 2482: l_primary_uom:= INV_CACHE.item_rec.primary_uom_code; --Get primary UOM of item.

2478: print_debug('l_num_detail_recs is '|| l_num_detail_recs, 'Inv_Pick_Release_PVT.Process_Line');
2479: END IF;
2480:
2481: --Bug#6085577. l_quantity_detailed_conv should hold quantity in the UOM of MTRL.
2482: l_primary_uom:= INV_CACHE.item_rec.primary_uom_code; --Get primary UOM of item.
2483: IF (is_debug) THEN
2484: print_debug('Move Order line UOM '||p_mo_line_rec.uom_code || 'Pri UOM:'|| l_primary_uom,'Inv_Pick_Release_PVT.Process_Line');
2485: END IF;
2486: IF (p_mo_line_rec.uom_code <> l_primary_uom ) THEN

Line 2605: l_primary_uom:= INV_CACHE.item_rec.primary_uom_code;

2601: --update quantity tree
2602: IF is_debug THEN
2603: print_debug('updating quantity tree', 'Inv_Pick_Release_PVT.Process_Line');
2604: END IF;
2605: l_primary_uom:= INV_CACHE.item_rec.primary_uom_code;
2606: l_secondary_uom:= INV_CACHE.item_rec.secondary_uom_code;
2607: l_revision_control_code:=INV_CACHE.item_rec.revision_qty_control_code;
2608: l_lot_control_code:= INV_CACHE.item_rec.lot_control_code;
2609: l_serial_number_control_code:= INV_CACHE.item_rec.serial_number_control_code;

Line 2606: l_secondary_uom:= INV_CACHE.item_rec.secondary_uom_code;

2602: IF is_debug THEN
2603: print_debug('updating quantity tree', 'Inv_Pick_Release_PVT.Process_Line');
2604: END IF;
2605: l_primary_uom:= INV_CACHE.item_rec.primary_uom_code;
2606: l_secondary_uom:= INV_CACHE.item_rec.secondary_uom_code;
2607: l_revision_control_code:=INV_CACHE.item_rec.revision_qty_control_code;
2608: l_lot_control_code:= INV_CACHE.item_rec.lot_control_code;
2609: l_serial_number_control_code:= INV_CACHE.item_rec.serial_number_control_code;
2610: -- convert revision/lot control indicators into boolean

Line 2607: l_revision_control_code:=INV_CACHE.item_rec.revision_qty_control_code;

2603: print_debug('updating quantity tree', 'Inv_Pick_Release_PVT.Process_Line');
2604: END IF;
2605: l_primary_uom:= INV_CACHE.item_rec.primary_uom_code;
2606: l_secondary_uom:= INV_CACHE.item_rec.secondary_uom_code;
2607: l_revision_control_code:=INV_CACHE.item_rec.revision_qty_control_code;
2608: l_lot_control_code:= INV_CACHE.item_rec.lot_control_code;
2609: l_serial_number_control_code:= INV_CACHE.item_rec.serial_number_control_code;
2610: -- convert revision/lot control indicators into boolean
2611:

Line 2608: l_lot_control_code:= INV_CACHE.item_rec.lot_control_code;

2604: END IF;
2605: l_primary_uom:= INV_CACHE.item_rec.primary_uom_code;
2606: l_secondary_uom:= INV_CACHE.item_rec.secondary_uom_code;
2607: l_revision_control_code:=INV_CACHE.item_rec.revision_qty_control_code;
2608: l_lot_control_code:= INV_CACHE.item_rec.lot_control_code;
2609: l_serial_number_control_code:= INV_CACHE.item_rec.serial_number_control_code;
2610: -- convert revision/lot control indicators into boolean
2611:
2612: IF l_revision_control_code = 2 THEN

Line 2609: l_serial_number_control_code:= INV_CACHE.item_rec.serial_number_control_code;

2605: l_primary_uom:= INV_CACHE.item_rec.primary_uom_code;
2606: l_secondary_uom:= INV_CACHE.item_rec.secondary_uom_code;
2607: l_revision_control_code:=INV_CACHE.item_rec.revision_qty_control_code;
2608: l_lot_control_code:= INV_CACHE.item_rec.lot_control_code;
2609: l_serial_number_control_code:= INV_CACHE.item_rec.serial_number_control_code;
2610: -- convert revision/lot control indicators into boolean
2611:
2612: IF l_revision_control_code = 2 THEN
2613: l_is_revision_control := TRUE;

Line 2914: l_primary_uom:= INV_CACHE.item_rec.primary_uom_code;

2910: -- Update the quantity detailed on the reservations
2911: IF l_demand_rsvs_ordered.COUNT > 0 THEN
2912: l_res_ordered_index := l_demand_rsvs_ordered.FIRST;
2913:
2914: l_primary_uom:= INV_CACHE.item_rec.primary_uom_code;
2915: l_secondary_uom:= INV_CACHE.item_rec.secondary_uom_code;
2916: l_revision_control_code:=INV_CACHE.item_rec.revision_qty_control_code;
2917: l_lot_control_code:= INV_CACHE.item_rec.lot_control_code;
2918: l_serial_number_control_code:= INV_CACHE.item_rec.serial_number_control_code;

Line 2915: l_secondary_uom:= INV_CACHE.item_rec.secondary_uom_code;

2911: IF l_demand_rsvs_ordered.COUNT > 0 THEN
2912: l_res_ordered_index := l_demand_rsvs_ordered.FIRST;
2913:
2914: l_primary_uom:= INV_CACHE.item_rec.primary_uom_code;
2915: l_secondary_uom:= INV_CACHE.item_rec.secondary_uom_code;
2916: l_revision_control_code:=INV_CACHE.item_rec.revision_qty_control_code;
2917: l_lot_control_code:= INV_CACHE.item_rec.lot_control_code;
2918: l_serial_number_control_code:= INV_CACHE.item_rec.serial_number_control_code;
2919: -- convert revision/lot control indicators into boolean

Line 2916: l_revision_control_code:=INV_CACHE.item_rec.revision_qty_control_code;

2912: l_res_ordered_index := l_demand_rsvs_ordered.FIRST;
2913:
2914: l_primary_uom:= INV_CACHE.item_rec.primary_uom_code;
2915: l_secondary_uom:= INV_CACHE.item_rec.secondary_uom_code;
2916: l_revision_control_code:=INV_CACHE.item_rec.revision_qty_control_code;
2917: l_lot_control_code:= INV_CACHE.item_rec.lot_control_code;
2918: l_serial_number_control_code:= INV_CACHE.item_rec.serial_number_control_code;
2919: -- convert revision/lot control indicators into boolean
2920: IF l_revision_control_code = 2 THEN

Line 2917: l_lot_control_code:= INV_CACHE.item_rec.lot_control_code;

2913:
2914: l_primary_uom:= INV_CACHE.item_rec.primary_uom_code;
2915: l_secondary_uom:= INV_CACHE.item_rec.secondary_uom_code;
2916: l_revision_control_code:=INV_CACHE.item_rec.revision_qty_control_code;
2917: l_lot_control_code:= INV_CACHE.item_rec.lot_control_code;
2918: l_serial_number_control_code:= INV_CACHE.item_rec.serial_number_control_code;
2919: -- convert revision/lot control indicators into boolean
2920: IF l_revision_control_code = 2 THEN
2921: l_is_revision_control := TRUE;

Line 2918: l_serial_number_control_code:= INV_CACHE.item_rec.serial_number_control_code;

2914: l_primary_uom:= INV_CACHE.item_rec.primary_uom_code;
2915: l_secondary_uom:= INV_CACHE.item_rec.secondary_uom_code;
2916: l_revision_control_code:=INV_CACHE.item_rec.revision_qty_control_code;
2917: l_lot_control_code:= INV_CACHE.item_rec.lot_control_code;
2918: l_serial_number_control_code:= INV_CACHE.item_rec.serial_number_control_code;
2919: -- convert revision/lot control indicators into boolean
2920: IF l_revision_control_code = 2 THEN
2921: l_is_revision_control := TRUE;
2922: ELSE

Line 3203: l_return_value := INV_CACHE.set_mtrh_rec(p_mo_line_rec.header_id);

3199: AND p_mo_line_rec.ship_model_id IS NULL
3200: AND l_call_mode IS NULL THEN
3201: COMMIT WORK;
3202:
3203: l_return_value := INV_CACHE.set_mtrh_rec(p_mo_line_rec.header_id);
3204: IF NOT l_return_value THEN
3205: If is_debug THEN
3206: print_debug('Error setting header cache','Inv_Pick_Release_PVT.Process_Line');
3207: End If;

Line 3210: l_request_number := INV_CACHE.mtrh_rec.request_number;

3206: print_debug('Error setting header cache','Inv_Pick_Release_PVT.Process_Line');
3207: End If;
3208: raise fnd_api.g_exc_unexpected_error;
3209: END IF;
3210: l_request_number := INV_CACHE.mtrh_rec.request_number;
3211:
3212: IF g_request_number is NOT NULL and
3213: g_request_number = l_request_number AND
3214: g_report_set_id IS NOT NULL THEN