APPS.INV_EXPRESS_PICK_PUB dependencies on INV_CACHE

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

34: IF p_reservation_rec.subinventory_code IS NULL THEN
35: Return False;
36: END IF;
37:
38: IF NOT INV_CACHE.set_item_rec(p_mo_line_rec.organization_id, p_mo_line_rec.inventory_item_id) THEN
39: print_debug('Inventory Cache Set Item Rec Failed', 'INV_Express_Pick_Pub.Check_Detailed_Rsv');
40: RAISE fnd_api.g_exc_unexpected_error;
41: END IF;
42:

Line 43: If (inv_cache.item_rec.lot_control_code = 2) AND l_detailed THEN

39: print_debug('Inventory Cache Set Item Rec Failed', 'INV_Express_Pick_Pub.Check_Detailed_Rsv');
40: RAISE fnd_api.g_exc_unexpected_error;
41: END IF;
42:
43: If (inv_cache.item_rec.lot_control_code = 2) AND l_detailed THEN
44: if p_reservation_rec.lot_number IS NULL THEN
45: l_detailed := FALSE;
46: end if;
47: END IF;

Line 49: If (inv_cache.item_rec.revision_qty_control_code = 2) AND l_detailed THEN

45: l_detailed := FALSE;
46: end if;
47: END IF;
48:
49: If (inv_cache.item_rec.revision_qty_control_code = 2) AND l_detailed THEN
50: if p_reservation_rec.revision IS NULL THEN
51: l_detailed := FALSE;
52: end if;
53: END IF;

Line 57: If (inv_cache.item_rec.location_control_code in (2,3)) THEN

53: END IF;
54:
55: /* Locators not supported - If Org, Item or Sub is locator controlled don't match */
56: /* If reservation has locator don't match */
57: If (inv_cache.item_rec.location_control_code in (2,3)) THEN
58: l_detailed := FALSE;
59: END IF;
60:
61: If (p_reservation_rec.locator_id is NOT NULL) THEN

Line 69: IF NOT INV_CACHE.set_tosub_rec(p_mo_line_rec.organization_id, p_reservation_rec.subinventory_code) THEN

65: IF l_detailed THEN
66: IF p_mo_line_rec.organization_id <> nvl(g_organization_id,-9999) OR
67: p_reservation_rec.subinventory_code <> nvl(g_subinventory_code,'-9999') THEN
68:
69: IF NOT INV_CACHE.set_tosub_rec(p_mo_line_rec.organization_id, p_reservation_rec.subinventory_code) THEN
70: print_debug('Inventory Cache Set ToSub Rec Failed', 'INV_Express_Pick_Pub.Check_Detailed_Rsv');
71: RAISE fnd_api.g_exc_unexpected_error;
72: END IF;
73:

Line 74: IF NOT INV_CACHE.set_org_rec(p_mo_line_rec.organization_id) THEN

70: print_debug('Inventory Cache Set ToSub Rec Failed', 'INV_Express_Pick_Pub.Check_Detailed_Rsv');
71: RAISE fnd_api.g_exc_unexpected_error;
72: END IF;
73:
74: IF NOT INV_CACHE.set_org_rec(p_mo_line_rec.organization_id) THEN
75: print_debug('Inventory Cache Set ORG Rec Failed', 'INV_Express_Pick_Pub.Check_Detailed_Rsv');
76: RAISE fnd_api.g_exc_unexpected_error;
77: END IF;
78:

Line 81: g_sub_loc_control_code := inv_cache.org_rec.stock_locator_control_code;

77: END IF;
78:
79: g_organization_id := p_mo_line_rec.organization_id;
80: g_subinventory_code := p_reservation_rec.subinventory_code;
81: g_sub_loc_control_code := inv_cache.org_rec.stock_locator_control_code;
82: g_org_loc_control_code := inv_cache.tosub_rec.locator_type;
83: END IF;
84:
85: If g_sub_loc_control_code in (2,3) OR g_org_loc_control_code in (2,3) THEN

Line 82: g_org_loc_control_code := inv_cache.tosub_rec.locator_type;

78:
79: g_organization_id := p_mo_line_rec.organization_id;
80: g_subinventory_code := p_reservation_rec.subinventory_code;
81: g_sub_loc_control_code := inv_cache.org_rec.stock_locator_control_code;
82: g_org_loc_control_code := inv_cache.tosub_rec.locator_type;
83: END IF;
84:
85: If g_sub_loc_control_code in (2,3) OR g_org_loc_control_code in (2,3) THEN
86: l_detailed := FALSE;

Line 310: IF NOT INV_CACHE.set_mtt_rec(p_mo_line_tbl(l_line_index).transaction_type_id) THEN

306: End If;
307: l_delivery_detail_id:= p_mo_line_tbl(l_line_index).txn_source_line_detail_id;
308: p_pick_release_status_tbl(g_pr_status_cntr).delivery_detail_id := l_delivery_detail_id;
309:
310: IF NOT INV_CACHE.set_mtt_rec(p_mo_line_tbl(l_line_index).transaction_type_id) THEN
311: print_debug('Inventory Cache Set Transaction Type Rec Failed', 'INV_Express_Pick_Pub.Pick_Release');
312: RAISE fnd_api.g_exc_unexpected_error;
313: END IF;
314:

Line 315: l_source_type_id := inv_cache.mtt_rec.transaction_source_type_id;

311: print_debug('Inventory Cache Set Transaction Type Rec Failed', 'INV_Express_Pick_Pub.Pick_Release');
312: RAISE fnd_api.g_exc_unexpected_error;
313: END IF;
314:
315: l_source_type_id := inv_cache.mtt_rec.transaction_source_type_id;
316: l_source_line_id := p_mo_line_tbl(l_line_index).TXN_source_line_id;
317:
318: If is_debug then
319: print_debug('Checking reservations for Delivery Detail : ' || l_delivery_detail_id,

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

641:
642:
643: BEGIN
644: x_return_status :=fnd_api.g_ret_sts_success;
645: IF NOT INV_CACHE.set_item_rec(p_mo_line_rec.organization_id, p_mo_line_rec.inventory_item_id) THEN
646: print_debug('Inventory Cache Set Item Rec Failed', 'INV_Express_Pick_Pub.Pick_Release');
647: RAISE fnd_api.g_exc_unexpected_error;
648: END IF;
649: IF inv_cache.item_rec.serial_number_control_code NOT IN (1,6) then

Line 649: IF inv_cache.item_rec.serial_number_control_code NOT IN (1,6) then

645: IF NOT INV_CACHE.set_item_rec(p_mo_line_rec.organization_id, p_mo_line_rec.inventory_item_id) THEN
646: print_debug('Inventory Cache Set Item Rec Failed', 'INV_Express_Pick_Pub.Pick_Release');
647: RAISE fnd_api.g_exc_unexpected_error;
648: END IF;
649: IF inv_cache.item_rec.serial_number_control_code NOT IN (1,6) then
650: print_debug('Item is Serialized ','INV_Express_Pick_Pub.Pick_Release');
651: is_serial_controlled :=true;
652: END IF;
653: