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 706: l_return_value := INV_CACHE.set_fromsub_rec(

702:
703: -- Check if the picking subinventory (if specified on the MO) is
704: -- reservable OR not
705: IF (p_mo_line_rec.from_subinventory_code IS NOT NULL) THEN
706: l_return_value := INV_CACHE.set_fromsub_rec(
707: p_mo_line_rec.organization_id,
708: p_mo_line_rec.from_subinventory_code);
709: If NOT l_return_value Then
710: if is_debug then

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

711: print_debug('Error setting from sub cache','Inv_Pick_Release_PVT.Process_Reservations');
712: end if;
713: RAISE fnd_api.g_exc_unexpected_error;
714: End If;
715: g_sub_reservable_type := INV_CACHE.fromsub_rec.reservable_type;
716: ELSE
717: g_sub_reservable_type := 1;
718: END IF;
719:

Line 802: l_return_value := INV_CACHE.set_item_rec(

798: l_qty_to_detail_unconv := p_mo_line_rec.quantity - NVL(p_mo_line_rec.quantity_detailed, 0);
799: l_sec_quantity_to_detail := p_mo_line_rec.secondary_quantity - NVL(p_mo_line_rec.secondary_quantity_detailed, 0);
800: l_grade_code := p_mo_line_rec.grade_code;
801:
802: l_return_value := INV_CACHE.set_item_rec(
803: p_mo_line_rec.organization_id,
804: p_mo_line_rec.inventory_item_id);
805: If NOT l_return_value Then
806: if is_debug then

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

809: end if;
810: RAISE fnd_api.g_exc_unexpected_error;
811: End If;
812:
813: l_primary_uom:= INV_CACHE.item_rec.primary_uom_code;
814: l_secondary_uom:= INV_CACHE.item_rec.secondary_uom_code;
815: l_revision_control_code:= INV_CACHE.item_rec.revision_qty_control_code;
816: l_lot_control_code:= INV_CACHE.item_rec.lot_control_code;
817: l_serial_control_code:= INV_CACHE.item_rec.serial_number_control_code;

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

810: RAISE fnd_api.g_exc_unexpected_error;
811: End If;
812:
813: l_primary_uom:= INV_CACHE.item_rec.primary_uom_code;
814: l_secondary_uom:= INV_CACHE.item_rec.secondary_uom_code;
815: l_revision_control_code:= INV_CACHE.item_rec.revision_qty_control_code;
816: l_lot_control_code:= INV_CACHE.item_rec.lot_control_code;
817: l_serial_control_code:= INV_CACHE.item_rec.serial_number_control_code;
818:

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

811: End If;
812:
813: l_primary_uom:= INV_CACHE.item_rec.primary_uom_code;
814: l_secondary_uom:= INV_CACHE.item_rec.secondary_uom_code;
815: l_revision_control_code:= INV_CACHE.item_rec.revision_qty_control_code;
816: l_lot_control_code:= INV_CACHE.item_rec.lot_control_code;
817: l_serial_control_code:= INV_CACHE.item_rec.serial_number_control_code;
818:
819: IF(l_lot_control_code = inv_reservation_global.g_lot_control_yes AND INV_CACHE.item_rec.lot_divisible_flag <> 'Y') THEN

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

812:
813: l_primary_uom:= INV_CACHE.item_rec.primary_uom_code;
814: l_secondary_uom:= INV_CACHE.item_rec.secondary_uom_code;
815: l_revision_control_code:= INV_CACHE.item_rec.revision_qty_control_code;
816: l_lot_control_code:= INV_CACHE.item_rec.lot_control_code;
817: l_serial_control_code:= INV_CACHE.item_rec.serial_number_control_code;
818:
819: IF(l_lot_control_code = inv_reservation_global.g_lot_control_yes AND INV_CACHE.item_rec.lot_divisible_flag <> 'Y') THEN
820: l_lot_divisible_flag := 'N';

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

813: l_primary_uom:= INV_CACHE.item_rec.primary_uom_code;
814: l_secondary_uom:= INV_CACHE.item_rec.secondary_uom_code;
815: l_revision_control_code:= INV_CACHE.item_rec.revision_qty_control_code;
816: l_lot_control_code:= INV_CACHE.item_rec.lot_control_code;
817: l_serial_control_code:= INV_CACHE.item_rec.serial_number_control_code;
818:
819: IF(l_lot_control_code = inv_reservation_global.g_lot_control_yes AND INV_CACHE.item_rec.lot_divisible_flag <> 'Y') THEN
820: l_lot_divisible_flag := 'N';
821: ELSE

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

815: l_revision_control_code:= INV_CACHE.item_rec.revision_qty_control_code;
816: l_lot_control_code:= INV_CACHE.item_rec.lot_control_code;
817: l_serial_control_code:= INV_CACHE.item_rec.serial_number_control_code;
818:
819: IF(l_lot_control_code = inv_reservation_global.g_lot_control_yes AND INV_CACHE.item_rec.lot_divisible_flag <> 'Y') THEN
820: l_lot_divisible_flag := 'N';
821: ELSE
822: l_lot_divisible_flag := 'Y';
823: END IF;

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

884: END IF;
885: -- Bug 4171297, if the order line has Wip supply reservation then l_quantity_to_detail
886: -- should be calculated based on order line quantity. Adding the below logic to calculate
887: -- the l_quantity_to_detail.
888: l_return_value := INV_CACHE.set_oola_rec(p_demand_info.oe_line_id);
889: IF NOT l_return_value Then
890: IF (is_debug) THEN
891: print_debug('Error setting cache for order line', 'Inv_Pick_Release_PVT.Process_Reservations');
892: END IF;

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

892: END IF;
893: RAISE fnd_api.g_exc_unexpected_error;
894: END IF;
895:
896: l_order_line_qty_unconv := INV_CACHE.oola_rec.ordered_quantity;
897: l_order_line_uom := INV_CACHE.oola_rec.order_quantity_uom;
898:
899: IF (is_debug) THEN
900: print_debug('l_order_line_qty_unconv = ' ||l_order_line_qty_unconv, 'Inv_Pick_Release_PVT.Process_Reservations');

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

893: RAISE fnd_api.g_exc_unexpected_error;
894: END IF;
895:
896: l_order_line_qty_unconv := INV_CACHE.oola_rec.ordered_quantity;
897: l_order_line_uom := INV_CACHE.oola_rec.order_quantity_uom;
898:
899: IF (is_debug) THEN
900: print_debug('l_order_line_qty_unconv = ' ||l_order_line_qty_unconv, 'Inv_Pick_Release_PVT.Process_Reservations');
901: print_debug('l_order_line_uom = ' ||l_order_line_uom, 'Inv_Pick_Release_PVT.Process_Reservations');

Line 1329: IF(INV_CACHE.item_rec.tracking_quantity_ind<>'PS') THEN

1325: print_debug('no org-wide reservation exist, need to create one',
1326: 'Inv_Pick_Release_Pvt.Process_Reservations');
1327: END IF;
1328: --Bug 12655248 The secondary uom and secondary quantity should be null when the tracking quantity at item level is not Primary and secondary
1329: IF(INV_CACHE.item_rec.tracking_quantity_ind<>'PS') THEN
1330: l_secondary_uom:=NULL;
1331: l_sec_quantity_to_reserve:=NULL;
1332: END IF;
1333:

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

1524: ((nvl(l_demand_rsvs_ordered(l_res_tbl_index).secondary_reservation_quantity,0)
1525: - nvl(l_demand_rsvs_ordered(l_res_tbl_index).secondary_detailed_quantity,0) > 0) AND l_fulfill_base = 'S' ) THEN
1526:
1527: -- Bug 5535030: fetch from get_rsv_serials only for serial controlled items
1528: IF (INV_CACHE.set_item_rec( p_mo_line_rec.organization_id, p_mo_line_rec.inventory_item_id)) THEN
1529: IF INV_CACHE.item_rec.serial_number_control_code NOT IN (1,6) THEN
1530: l_rsv_serials.DELETE;
1531: OPEN get_rsv_serials(l_demand_rsvs_ordered(l_res_tbl_index).reservation_id);
1532: FETCH get_rsv_serials bulk collect INTO l_rsv_serials;

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

1525: - nvl(l_demand_rsvs_ordered(l_res_tbl_index).secondary_detailed_quantity,0) > 0) AND l_fulfill_base = 'S' ) THEN
1526:
1527: -- Bug 5535030: fetch from get_rsv_serials only for serial controlled items
1528: IF (INV_CACHE.set_item_rec( p_mo_line_rec.organization_id, p_mo_line_rec.inventory_item_id)) THEN
1529: IF INV_CACHE.item_rec.serial_number_control_code NOT IN (1,6) THEN
1530: l_rsv_serials.DELETE;
1531: OPEN get_rsv_serials(l_demand_rsvs_ordered(l_res_tbl_index).reservation_id);
1532: FETCH get_rsv_serials bulk collect INTO l_rsv_serials;
1533: CLOSE get_rsv_serials;

Line 1722: IF nvl(inv_cache.item_rec.revision_qty_control_code,1) = 2 THEN -- revision controlled

1718: print_debug('Default Loc is'|| l_default_locator_id, 'Inv_Pick_Release_PVT.Process_Unreservable_Items');
1719: END IF;
1720:
1721: -- 8430412 begin added the following logic to get revision for non-reservable item.
1722: IF nvl(inv_cache.item_rec.revision_qty_control_code,1) = 2 THEN -- revision controlled
1723: IF (is_debug) THEN
1724: print_debug('Revision_ctrl: '||inv_cache.item_rec.revision_qty_control_code,'Inv_Pick_Release_PVT.Process_Unreservable_Items');
1725: END IF;
1726:

Line 1724: print_debug('Revision_ctrl: '||inv_cache.item_rec.revision_qty_control_code,'Inv_Pick_Release_PVT.Process_Unreservable_Items');

1720:
1721: -- 8430412 begin added the following logic to get revision for non-reservable item.
1722: IF nvl(inv_cache.item_rec.revision_qty_control_code,1) = 2 THEN -- revision controlled
1723: IF (is_debug) THEN
1724: print_debug('Revision_ctrl: '||inv_cache.item_rec.revision_qty_control_code,'Inv_Pick_Release_PVT.Process_Unreservable_Items');
1725: END IF;
1726:
1727: l_rule_id := inv_cache.item_rec.picking_rule_id;
1728:

Line 1727: l_rule_id := inv_cache.item_rec.picking_rule_id;

1723: IF (is_debug) THEN
1724: print_debug('Revision_ctrl: '||inv_cache.item_rec.revision_qty_control_code,'Inv_Pick_Release_PVT.Process_Unreservable_Items');
1725: END IF;
1726:
1727: l_rule_id := inv_cache.item_rec.picking_rule_id;
1728:
1729: IF l_rule_id is NULL THEN
1730: IF inv_cache.set_org_rec(g_organization_id) THEN
1731: l_rule_id := inv_cache.org_rec.default_picking_rule_id;

Line 1730: IF inv_cache.set_org_rec(g_organization_id) THEN

1726:
1727: l_rule_id := inv_cache.item_rec.picking_rule_id;
1728:
1729: IF l_rule_id is NULL THEN
1730: IF inv_cache.set_org_rec(g_organization_id) THEN
1731: l_rule_id := inv_cache.org_rec.default_picking_rule_id;
1732: ELSE
1733: l_rule_id := NULL;
1734: END IF;

Line 1731: l_rule_id := inv_cache.org_rec.default_picking_rule_id;

1727: l_rule_id := inv_cache.item_rec.picking_rule_id;
1728:
1729: IF l_rule_id is NULL THEN
1730: IF inv_cache.set_org_rec(g_organization_id) THEN
1731: l_rule_id := inv_cache.org_rec.default_picking_rule_id;
1732: ELSE
1733: l_rule_id := NULL;
1734: END IF;
1735: END IF;

Line 1783: l_txn_date := nvl(inv_cache.mo_transaction_date, SYSDATE);

1779: END IF;
1780:
1781: ELSE --revision sort not defined
1782:
1783: l_txn_date := nvl(inv_cache.mo_transaction_date, SYSDATE);
1784:
1785: IF (is_debug) THEN
1786: print_debug('call bom_revisions.get_revision to get revsion, revision date = '||l_txn_date, 'Inv_Pick_Release_PVT.Process_Unreservable_Items');
1787: END IF;

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

2008: print_debug('Move ORder has project reference',
2009: 'Inv_Pick_Release_PVT.Process_Prj_Dynamic_Locator');
2010: END IF;
2011:
2012: l_return_value := INV_CACHE.set_org_rec(p_mo_line_rec.organization_id);
2013: IF NOT l_return_value THEN
2014: IF (is_debug) THEN
2015: print_debug('error setting org cache',
2016: 'Inv_Pick_Release_PVt.Process_Prj_Dynamic_Locator');

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

2016: 'Inv_Pick_Release_PVt.Process_Prj_Dynamic_Locator');
2017: END IF;
2018: RAISE fnd_api.g_exc_unexpected_error;
2019: END IF;
2020: l_org_loc_control := INV_CACHE.org_rec.stock_locator_control_code;
2021:
2022: l_return_value := INV_CACHE.set_item_rec(
2023: p_mo_line_rec.organization_id,
2024: p_mo_line_rec.inventory_item_id);

Line 2022: l_return_value := INV_CACHE.set_item_rec(

2018: RAISE fnd_api.g_exc_unexpected_error;
2019: END IF;
2020: l_org_loc_control := INV_CACHE.org_rec.stock_locator_control_code;
2021:
2022: l_return_value := INV_CACHE.set_item_rec(
2023: p_mo_line_rec.organization_id,
2024: p_mo_line_rec.inventory_item_id);
2025: IF NOT l_return_value THEN
2026: IF (is_debug) THEN

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

2028: 'Inv_Pick_Release_PVt.Process_Prj_Dynamic_Locator');
2029: END IF;
2030: RAISE fnd_api.g_exc_unexpected_error;
2031: END IF;
2032: l_item_loc_control := INV_CACHE.item_rec.location_control_code;
2033:
2034: l_return_value := INV_CACHE.set_tosub_rec(
2035: p_mo_line_rec.organization_id,
2036: l_to_subinventory);

Line 2034: l_return_value := INV_CACHE.set_tosub_rec(

2030: RAISE fnd_api.g_exc_unexpected_error;
2031: END IF;
2032: l_item_loc_control := INV_CACHE.item_rec.location_control_code;
2033:
2034: l_return_value := INV_CACHE.set_tosub_rec(
2035: p_mo_line_rec.organization_id,
2036: l_to_subinventory);
2037: IF NOT l_return_value THEN
2038: IF (is_debug) THEN

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

2040: 'Inv_Pick_Release_PVt.Process_Prj_Dynamic_Locator');
2041: END IF;
2042: RAISE fnd_api.g_exc_unexpected_error;
2043: END IF;
2044: l_sub_loc_control := INV_CACHE.tosub_rec.locator_type;
2045:
2046: IF (is_debug) THEN
2047: print_debug('l_org_loc_control is '|| l_org_loc_control, 'Inv_Pick_Release_PVT.Process_Prj_Dynamic_Locator');
2048: print_debug('l_item_loc_control is '|| l_item_loc_control, 'Inv_Pick_Release_PVT.Process_Prj_Dynamic_Locator');

Line 2112: , p_org => INV_CACHE.org_rec

2108: l_locator.segment19 := p_mo_line_rec.project_id;
2109: l_locator.segment20 := p_mo_line_rec.task_id;
2110: success := inv_validate.validatelocator(
2111: p_locator => l_locator
2112: , p_org => INV_CACHE.org_rec
2113: , p_sub => INV_CACHE.tosub_rec
2114: , p_validation_mode => inv_validate.exists_or_create
2115: , p_value_or_id => 'I'
2116: );

Line 2113: , p_sub => INV_CACHE.tosub_rec

2109: l_locator.segment20 := p_mo_line_rec.task_id;
2110: success := inv_validate.validatelocator(
2111: p_locator => l_locator
2112: , p_org => INV_CACHE.org_rec
2113: , p_sub => INV_CACHE.tosub_rec
2114: , p_validation_mode => inv_validate.exists_or_create
2115: , p_value_or_id => 'I'
2116: );
2117:

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

2489: END;
2490: IF (is_debug) THEN
2491: gmi_reservation_util.println('Process_Line after fetch wdd');
2492: END IF;
2493: l_return_value := INV_CACHE.set_item_rec(p_mo_line_rec.organization_id, p_mo_line_rec.inventory_item_id);
2494: IF NOT l_return_value THEN
2495: If is_debug THEN
2496: print_debug('Error setting item cache', 'Inv_Pick_Release_PVT.Process_Line');
2497: End If;

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

2496: print_debug('Error setting item cache', 'Inv_Pick_Release_PVT.Process_Line');
2497: End If;
2498: raise fnd_api.g_exc_unexpected_error;
2499: End If;
2500: l_reservable_type:= INV_CACHE.item_rec.reservable_type;
2501:
2502: IF p_mo_line_rec.transaction_type_id = 52 THEN
2503: l_demand_source_type := 2;
2504: ELSIF p_mo_line_rec.transaction_type_id = 53 THEN

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

2505: l_demand_source_type := 8;
2506: ELSIF g_transaction_type_id = p_mo_line_rec.transaction_type_id THEN
2507: l_demand_source_type := g_transaction_source_type_id;
2508: ELSE
2509: l_return_value := INV_CACHE.set_mtt_rec(p_mo_line_rec.transaction_type_id);
2510: IF NOT l_return_value THEN
2511: If is_debug THEN
2512: print_debug('Error setting item cache','Inv_Pick_Release_PVT.Process_Line');
2513: End If;

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

2512: print_debug('Error setting item cache','Inv_Pick_Release_PVT.Process_Line');
2513: End If;
2514: raise fnd_api.g_exc_unexpected_error;
2515: End If;
2516: l_demand_source_type := INV_CACHE.mtt_rec.transaction_source_type_id;
2517: g_transaction_type_id := p_mo_line_rec.transaction_type_id;
2518: g_transaction_source_type_id := l_demand_source_type;
2519: END IF;
2520: IF (is_debug) THEN

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

2523:
2524: -- Compute the MTL_SALES_ORDERS header ID to use when dealing with reservations.
2525: --l_mso_header_id := inv_salesorder.get_salesorder_for_oeheader(l_demand_info.oe_header_id);
2526:
2527: l_return_value := INV_CACHE.set_mso_rec(l_demand_info.oe_header_id);
2528: IF NOT l_return_value THEN
2529: IF (is_debug) THEN
2530: print_debug('No Mtl_Sales_Order ID found for oe header', 'Inv_Pick_Release_PVT.Process_Line');
2531: gmi_reservation_util.println('No Mtl_Sales_Order ID found for oe header');

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

2534: fnd_msg_pub.ADD;
2535: RAISE fnd_api.g_exc_unexpected_error;
2536: END IF;
2537:
2538: l_mso_header_id := INV_CACHE.mso_rec.sales_order_id;
2539:
2540: IF (is_debug) THEN
2541: gmi_reservation_util.println('Process_Line, l_mso_header_id '|| l_mso_header_id);
2542:

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

2602: AND p_allow_partial_pick = fnd_api.g_true
2603: AND l_call_mode IS NULL THEN
2604: COMMIT WORK;
2605:
2606: l_return_value := INV_CACHE.set_mtrh_rec(p_mo_line_rec.header_id);
2607: IF NOT l_return_value THEN
2608: If is_debug THEN
2609: print_debug('Error setting header cache', 'Inv_Pick_Release_PVT.Process_Line');
2610: End If;

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

2609: print_debug('Error setting header cache', 'Inv_Pick_Release_PVT.Process_Line');
2610: End If;
2611: raise fnd_api.g_exc_unexpected_error;
2612: END IF;
2613: l_request_number := INV_CACHE.mtrh_rec.request_number;
2614:
2615: IF g_request_number is NOT NULL and
2616: g_request_number = l_request_number AND
2617: g_report_set_id IS NOT NULL THEN

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

2658: ELSE
2659: print_debug('Non-standard reservable type: ' || l_reservable_type, 'Inv_Pick_Release_PVT.Process_Line');
2660: END IF; -- The item is reservable
2661:
2662: l_lot_control_code:= INV_CACHE.item_rec.lot_control_code;
2663:
2664: IF (l_lot_control_code = inv_reservation_global.g_lot_control_yes AND INV_CACHE.item_rec.lot_divisible_flag <> 'Y') THEN
2665: l_lot_divisible_flag := 'N';
2666: ELSE

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

2660: END IF; -- The item is reservable
2661:
2662: l_lot_control_code:= INV_CACHE.item_rec.lot_control_code;
2663:
2664: IF (l_lot_control_code = inv_reservation_global.g_lot_control_yes AND INV_CACHE.item_rec.lot_divisible_flag <> 'Y') THEN
2665: l_lot_divisible_flag := 'N';
2666: ELSE
2667: l_lot_divisible_flag := 'Y';
2668: END IF;

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

2711: print_debug('calling create suggestions', 'Inv_Pick_Release_PVT.Process_Line');
2712: print_debug('line_id is '|| p_mo_line_rec.line_id, 'Inv_Pick_Release_PVT.Process_line');
2713: END IF;
2714: --Bug3237702 starts added for caching
2715: inv_cache.tolocator_id := p_mo_line_rec.to_locator_id;
2716: inv_cache.tosubinventory_code := p_mo_line_rec.to_subinventory_code;
2717: --Bug3237702 ends
2718: -- Bug 5264987 Added p_organization_id to the create_suggestions call
2719: inv_ppengine_pvt.create_suggestions(

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

2712: print_debug('line_id is '|| p_mo_line_rec.line_id, 'Inv_Pick_Release_PVT.Process_line');
2713: END IF;
2714: --Bug3237702 starts added for caching
2715: inv_cache.tolocator_id := p_mo_line_rec.to_locator_id;
2716: inv_cache.tosubinventory_code := p_mo_line_rec.to_subinventory_code;
2717: --Bug3237702 ends
2718: -- Bug 5264987 Added p_organization_id to the create_suggestions call
2719: inv_ppengine_pvt.create_suggestions(
2720: p_api_version => 1.0

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

2765: END IF;
2766:
2767: ROLLBACK TO process_line_pvt;
2768:
2769: l_return_value := INV_CACHE.set_mtrh_rec(p_mo_line_rec.header_id);
2770: IF NOT l_return_value THEN
2771: If is_debug THEN
2772: print_debug('Error setting header cache', 'Inv_Pick_Release_PVT.Process_Line');
2773: End If;

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

2772: print_debug('Error setting header cache', 'Inv_Pick_Release_PVT.Process_Line');
2773: End If;
2774: raise fnd_api.g_exc_unexpected_error;
2775: END IF;
2776: l_request_number := INV_CACHE.mtrh_rec.request_number;
2777:
2778: fnd_message.set_name('INV', 'INV_DETAILING_FAILED');
2779: fnd_message.set_token('LINE_NUM', TO_CHAR(p_mo_line_rec.line_number));
2780: fnd_message.set_token('MO_NUMBER', l_request_number);

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

2808: print_debug('l_num_detail_recs is '|| l_num_detail_recs, 'Inv_Pick_Release_PVT.Process_Line');
2809: END IF;
2810:
2811: --Bug#6085577. l_quantity_detailed_conv should hold quantity in the UOM of MTRL.
2812: l_primary_uom:= INV_CACHE.item_rec.primary_uom_code; --Get primary UOM of item.
2813: IF (is_debug) THEN
2814: print_debug('Move Order line UOM '||p_mo_line_rec.uom_code || 'Pri UOM:'|| l_primary_uom,'Inv_Pick_Release_PVT.Process_Line');
2815: END IF;
2816: IF (p_mo_line_rec.uom_code <> l_primary_uom ) THEN

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

2990: --update quantity tree
2991: IF is_debug THEN
2992: print_debug('updating quantity tree', 'Inv_Pick_Release_PVT.Process_Line');
2993: END IF;
2994: l_primary_uom:= INV_CACHE.item_rec.primary_uom_code;
2995: l_secondary_uom:= INV_CACHE.item_rec.secondary_uom_code;
2996: l_revision_control_code:=INV_CACHE.item_rec.revision_qty_control_code;
2997: l_lot_control_code:= INV_CACHE.item_rec.lot_control_code;
2998: l_serial_number_control_code:= INV_CACHE.item_rec.serial_number_control_code;

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

2991: IF is_debug THEN
2992: print_debug('updating quantity tree', 'Inv_Pick_Release_PVT.Process_Line');
2993: END IF;
2994: l_primary_uom:= INV_CACHE.item_rec.primary_uom_code;
2995: l_secondary_uom:= INV_CACHE.item_rec.secondary_uom_code;
2996: l_revision_control_code:=INV_CACHE.item_rec.revision_qty_control_code;
2997: l_lot_control_code:= INV_CACHE.item_rec.lot_control_code;
2998: l_serial_number_control_code:= INV_CACHE.item_rec.serial_number_control_code;
2999: -- convert revision/lot control indicators into boolean

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

2992: print_debug('updating quantity tree', 'Inv_Pick_Release_PVT.Process_Line');
2993: END IF;
2994: l_primary_uom:= INV_CACHE.item_rec.primary_uom_code;
2995: l_secondary_uom:= INV_CACHE.item_rec.secondary_uom_code;
2996: l_revision_control_code:=INV_CACHE.item_rec.revision_qty_control_code;
2997: l_lot_control_code:= INV_CACHE.item_rec.lot_control_code;
2998: l_serial_number_control_code:= INV_CACHE.item_rec.serial_number_control_code;
2999: -- convert revision/lot control indicators into boolean
3000:

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

2993: END IF;
2994: l_primary_uom:= INV_CACHE.item_rec.primary_uom_code;
2995: l_secondary_uom:= INV_CACHE.item_rec.secondary_uom_code;
2996: l_revision_control_code:=INV_CACHE.item_rec.revision_qty_control_code;
2997: l_lot_control_code:= INV_CACHE.item_rec.lot_control_code;
2998: l_serial_number_control_code:= INV_CACHE.item_rec.serial_number_control_code;
2999: -- convert revision/lot control indicators into boolean
3000:
3001: IF l_revision_control_code = 2 THEN

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

2994: l_primary_uom:= INV_CACHE.item_rec.primary_uom_code;
2995: l_secondary_uom:= INV_CACHE.item_rec.secondary_uom_code;
2996: l_revision_control_code:=INV_CACHE.item_rec.revision_qty_control_code;
2997: l_lot_control_code:= INV_CACHE.item_rec.lot_control_code;
2998: l_serial_number_control_code:= INV_CACHE.item_rec.serial_number_control_code;
2999: -- convert revision/lot control indicators into boolean
3000:
3001: IF l_revision_control_code = 2 THEN
3002: l_is_revision_control := TRUE;

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

3361: -- Update the quantity detailed on the reservations
3362: IF l_demand_rsvs_ordered.COUNT > 0 THEN
3363: l_res_ordered_index := l_demand_rsvs_ordered.FIRST;
3364:
3365: l_primary_uom:= INV_CACHE.item_rec.primary_uom_code;
3366: l_secondary_uom:= INV_CACHE.item_rec.secondary_uom_code;
3367: l_revision_control_code:=INV_CACHE.item_rec.revision_qty_control_code;
3368: l_lot_control_code:= INV_CACHE.item_rec.lot_control_code;
3369: l_serial_number_control_code:= INV_CACHE.item_rec.serial_number_control_code;

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

3362: IF l_demand_rsvs_ordered.COUNT > 0 THEN
3363: l_res_ordered_index := l_demand_rsvs_ordered.FIRST;
3364:
3365: l_primary_uom:= INV_CACHE.item_rec.primary_uom_code;
3366: l_secondary_uom:= INV_CACHE.item_rec.secondary_uom_code;
3367: l_revision_control_code:=INV_CACHE.item_rec.revision_qty_control_code;
3368: l_lot_control_code:= INV_CACHE.item_rec.lot_control_code;
3369: l_serial_number_control_code:= INV_CACHE.item_rec.serial_number_control_code;
3370: -- convert revision/lot control indicators into boolean

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

3363: l_res_ordered_index := l_demand_rsvs_ordered.FIRST;
3364:
3365: l_primary_uom:= INV_CACHE.item_rec.primary_uom_code;
3366: l_secondary_uom:= INV_CACHE.item_rec.secondary_uom_code;
3367: l_revision_control_code:=INV_CACHE.item_rec.revision_qty_control_code;
3368: l_lot_control_code:= INV_CACHE.item_rec.lot_control_code;
3369: l_serial_number_control_code:= INV_CACHE.item_rec.serial_number_control_code;
3370: -- convert revision/lot control indicators into boolean
3371: IF l_revision_control_code = 2 THEN

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

3364:
3365: l_primary_uom:= INV_CACHE.item_rec.primary_uom_code;
3366: l_secondary_uom:= INV_CACHE.item_rec.secondary_uom_code;
3367: l_revision_control_code:=INV_CACHE.item_rec.revision_qty_control_code;
3368: l_lot_control_code:= INV_CACHE.item_rec.lot_control_code;
3369: l_serial_number_control_code:= INV_CACHE.item_rec.serial_number_control_code;
3370: -- convert revision/lot control indicators into boolean
3371: IF l_revision_control_code = 2 THEN
3372: l_is_revision_control := TRUE;

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

3365: l_primary_uom:= INV_CACHE.item_rec.primary_uom_code;
3366: l_secondary_uom:= INV_CACHE.item_rec.secondary_uom_code;
3367: l_revision_control_code:=INV_CACHE.item_rec.revision_qty_control_code;
3368: l_lot_control_code:= INV_CACHE.item_rec.lot_control_code;
3369: l_serial_number_control_code:= INV_CACHE.item_rec.serial_number_control_code;
3370: -- convert revision/lot control indicators into boolean
3371: IF l_revision_control_code = 2 THEN
3372: l_is_revision_control := TRUE;
3373: ELSE

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

3685: AND p_mo_line_rec.ship_model_id IS NULL
3686: AND l_call_mode IS NULL THEN
3687: COMMIT WORK;
3688:
3689: l_return_value := INV_CACHE.set_mtrh_rec(p_mo_line_rec.header_id);
3690: IF NOT l_return_value THEN
3691: If is_debug THEN
3692: print_debug('Error setting header cache','Inv_Pick_Release_PVT.Process_Line');
3693: End If;

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

3692: print_debug('Error setting header cache','Inv_Pick_Release_PVT.Process_Line');
3693: End If;
3694: raise fnd_api.g_exc_unexpected_error;
3695: END IF;
3696: l_request_number := INV_CACHE.mtrh_rec.request_number;
3697:
3698: IF g_request_number is NOT NULL and
3699: g_request_number = l_request_number AND
3700: g_report_set_id IS NOT NULL THEN