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.

[Home] [Help]

APPS.WMS_WAVE_PLANNING_PVT dependencies on INV_CACHE

Line 4112: l_return_value := INV_CACHE.set_item_rec(l_mo_line.organization_id, l_mo_line.inventory_item_id);

4108:
4109: IF l_mo_line.quantity > 0 THEN
4110: SAVEPOINT allocation;
4111:
4112: l_return_value := INV_CACHE.set_item_rec(l_mo_line.organization_id, l_mo_line.inventory_item_id);
4113: IF NOT l_return_value THEN
4114: print_debug('Error setting item cache', 'Inv_Pick_Release_PVT.Process_Line');
4115: raise fnd_api.g_exc_unexpected_error;
4116: End If;

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

4113: IF NOT l_return_value THEN
4114: print_debug('Error setting item cache', 'Inv_Pick_Release_PVT.Process_Line');
4115: raise fnd_api.g_exc_unexpected_error;
4116: End If;
4117: l_reservable_type:= INV_CACHE.item_rec.reservable_type;
4118:
4119: IF l_reservable_type = 2 THEN
4120: print_debug('In wave simulation mode. Update the allocation table with complete quantity fulfilled', l_debug);
4121: UPDATE wms_wp_rules_simulation

Line 4296: l_return_value := INV_CACHE.set_wdd_rec(l_mo_line.line_id);

4292: l_new_line_quantity := l_mo_line.quantity;
4293: ELSE
4294: l_new_line_quantity := l_set_new_req_qty;
4295: print_debug('New line qty: ' || l_new_line_quantity, l_debug);
4296: l_return_value := INV_CACHE.set_wdd_rec(l_mo_line.line_id);
4297: If NOT l_return_value Then
4298: print_debug('Error setting cache for delivery line',l_debug);
4299: RAISE fnd_api.g_exc_unexpected_error;
4300: End If;

Line 5517: IF inv_cache.set_item_rec(L_ORG_ID, L_item_id) THEN

5513: print_debug('Planning Method is Availability to Check and Allocation Method is not Crossdock Only --> Getting ATR ',
5514: l_debug);
5515:
5516: --Find out the total atr for the item
5517: IF inv_cache.set_item_rec(L_ORG_ID, L_item_id) THEN
5518:
5519:
5520: IF inv_cache.item_rec.serial_number_control_code NOT IN (1, 6) THEN
5521: l_is_serial_ctrl := FALSE;

Line 5520: IF inv_cache.item_rec.serial_number_control_code NOT IN (1, 6) THEN

5516: --Find out the total atr for the item
5517: IF inv_cache.set_item_rec(L_ORG_ID, L_item_id) THEN
5518:
5519:
5520: IF inv_cache.item_rec.serial_number_control_code NOT IN (1, 6) THEN
5521: l_is_serial_ctrl := FALSE;
5522: ELSE
5523: l_is_serial_ctrl := TRUE;
5524: END IF;

Line 5692: IF inv_cache.set_item_rec(L_ORG_ID, L_item_id) THEN

5688: print_debug('Planning Method is Availability to Check and Allocation Method is not Crossdock Only --> Getting ATR ',
5689: l_debug);
5690:
5691: --Find out the total atr for the item
5692: IF inv_cache.set_item_rec(L_ORG_ID, L_item_id) THEN
5693:
5694: /* IF inv_cache.item_rec.revision_qty_control_code = 2 THEN
5695: l_is_revision_ctrl := TRUE;
5696: ELSE

Line 5694: /* IF inv_cache.item_rec.revision_qty_control_code = 2 THEN

5690:
5691: --Find out the total atr for the item
5692: IF inv_cache.set_item_rec(L_ORG_ID, L_item_id) THEN
5693:
5694: /* IF inv_cache.item_rec.revision_qty_control_code = 2 THEN
5695: l_is_revision_ctrl := TRUE;
5696: ELSE
5697: l_is_revision_ctrl := FALSE;
5698: END IF;

Line 5700: IF inv_cache.item_rec.lot_control_code = 2 THEN

5696: ELSE
5697: l_is_revision_ctrl := FALSE;
5698: END IF;
5699:
5700: IF inv_cache.item_rec.lot_control_code = 2 THEN
5701: l_is_lot_ctrl := TRUE;
5702: ELSE
5703: l_is_lot_ctrl := FALSE;
5704: END IF;*/

Line 5706: IF inv_cache.item_rec.serial_number_control_code NOT IN (1, 6) THEN

5702: ELSE
5703: l_is_lot_ctrl := FALSE;
5704: END IF;*/
5705:
5706: IF inv_cache.item_rec.serial_number_control_code NOT IN (1, 6) THEN
5707: l_is_serial_ctrl := FALSE;
5708: ELSE
5709: l_is_serial_ctrl := TRUE;
5710: END IF;

Line 8596: IF inv_cache.set_item_rec(p_ORG_ID, p_item_id) THEN

8592: 0);
8593: begin
8594:
8595: --Find out the total atr for the item
8596: IF inv_cache.set_item_rec(p_ORG_ID, p_item_id) THEN
8597:
8598: /* IF inv_cache.item_rec.revision_qty_control_code = 2 THEN
8599: l_is_revision_ctrl := TRUE;
8600: ELSE

Line 8598: /* IF inv_cache.item_rec.revision_qty_control_code = 2 THEN

8594:
8595: --Find out the total atr for the item
8596: IF inv_cache.set_item_rec(p_ORG_ID, p_item_id) THEN
8597:
8598: /* IF inv_cache.item_rec.revision_qty_control_code = 2 THEN
8599: l_is_revision_ctrl := TRUE;
8600: ELSE
8601: l_is_revision_ctrl := FALSE;
8602: END IF;

Line 8604: IF inv_cache.item_rec.lot_control_code = 2 THEN

8600: ELSE
8601: l_is_revision_ctrl := FALSE;
8602: END IF;
8603:
8604: IF inv_cache.item_rec.lot_control_code = 2 THEN
8605: l_is_lot_ctrl := TRUE;
8606: ELSE
8607: l_is_lot_ctrl := FALSE;
8608: END IF; */

Line 8610: IF inv_cache.item_rec.serial_number_control_code NOT IN (1, 6) THEN

8606: ELSE
8607: l_is_lot_ctrl := FALSE;
8608: END IF; */
8609:
8610: IF inv_cache.item_rec.serial_number_control_code NOT IN (1, 6) THEN
8611: l_is_serial_ctrl := FALSE;
8612: ELSE
8613: l_is_serial_ctrl := TRUE;
8614: END IF;

Line 9104: IF (inv_cache.set_item_rec(l_organization_id, l_item_id)) THEN

9100: l_debug);
9101: print_debug('l_txn_pri_uom_ratio => ' || l_txn_pri_uom_ratio,
9102: l_debug);
9103:
9104: IF (inv_cache.set_item_rec(l_organization_id, l_item_id)) THEN
9105: -- {
9106: l_item_v_uom := inv_cache.item_rec.volume_uom_code;
9107: l_item_vol := inv_cache.item_rec.unit_volume;
9108: END IF;

Line 9106: l_item_v_uom := inv_cache.item_rec.volume_uom_code;

9102: l_debug);
9103:
9104: IF (inv_cache.set_item_rec(l_organization_id, l_item_id)) THEN
9105: -- {
9106: l_item_v_uom := inv_cache.item_rec.volume_uom_code;
9107: l_item_vol := inv_cache.item_rec.unit_volume;
9108: END IF;
9109:
9110: IF l_item_v_uom IS NOT NULL THEN

Line 9107: l_item_vol := inv_cache.item_rec.unit_volume;

9103:
9104: IF (inv_cache.set_item_rec(l_organization_id, l_item_id)) THEN
9105: -- {
9106: l_item_v_uom := inv_cache.item_rec.volume_uom_code;
9107: l_item_vol := inv_cache.item_rec.unit_volume;
9108: END IF;
9109:
9110: IF l_item_v_uom IS NOT NULL THEN
9111: -- {

Line 9119: IF (inv_cache.set_item_rec(l_organization_id, l_eqp_capacity)) THEN

9115: FETCH c_eqp_capacity
9116: INTO l_eqp_capacity;
9117: EXIT WHEN c_eqp_capacity%NOTFOUND;
9118:
9119: IF (inv_cache.set_item_rec(l_organization_id, l_eqp_capacity)) THEN
9120: -- {
9121: l_equip_v_uom := inv_cache.item_rec.volume_uom_code;
9122: l_equip_vol := inv_cache.item_rec.internal_volume;
9123: l_minimum_fill_percent := inv_cache.item_rec.minimum_fill_percent;

Line 9121: l_equip_v_uom := inv_cache.item_rec.volume_uom_code;

9117: EXIT WHEN c_eqp_capacity%NOTFOUND;
9118:
9119: IF (inv_cache.set_item_rec(l_organization_id, l_eqp_capacity)) THEN
9120: -- {
9121: l_equip_v_uom := inv_cache.item_rec.volume_uom_code;
9122: l_equip_vol := inv_cache.item_rec.internal_volume;
9123: l_minimum_fill_percent := inv_cache.item_rec.minimum_fill_percent;
9124: END IF; -- }
9125:

Line 9122: l_equip_vol := inv_cache.item_rec.internal_volume;

9118:
9119: IF (inv_cache.set_item_rec(l_organization_id, l_eqp_capacity)) THEN
9120: -- {
9121: l_equip_v_uom := inv_cache.item_rec.volume_uom_code;
9122: l_equip_vol := inv_cache.item_rec.internal_volume;
9123: l_minimum_fill_percent := inv_cache.item_rec.minimum_fill_percent;
9124: END IF; -- }
9125:
9126: IF (l_equip_vol IS NOT NULL AND l_item_vol IS NOT NULL) THEN

Line 9123: l_minimum_fill_percent := inv_cache.item_rec.minimum_fill_percent;

9119: IF (inv_cache.set_item_rec(l_organization_id, l_eqp_capacity)) THEN
9120: -- {
9121: l_equip_v_uom := inv_cache.item_rec.volume_uom_code;
9122: l_equip_vol := inv_cache.item_rec.internal_volume;
9123: l_minimum_fill_percent := inv_cache.item_rec.minimum_fill_percent;
9124: END IF; -- }
9125:
9126: IF (l_equip_vol IS NOT NULL AND l_item_vol IS NOT NULL) THEN
9127: -- {

Line 13882: IF inv_cache.set_item_rec(L_ORG_ID, L_item_id) THEN

13878: print_debug('l_item_id :' || l_item_id, l_debug);
13879: print_debug('l_org_id :' || l_org_id, l_debug);
13880:
13881: --Find out the total atr for the item
13882: IF inv_cache.set_item_rec(L_ORG_ID, L_item_id) THEN
13883:
13884: /* IF inv_cache.item_rec.revision_qty_control_code = 2 THEN
13885: l_is_revision_ctrl := TRUE;
13886: ELSE

Line 13884: /* IF inv_cache.item_rec.revision_qty_control_code = 2 THEN

13880:
13881: --Find out the total atr for the item
13882: IF inv_cache.set_item_rec(L_ORG_ID, L_item_id) THEN
13883:
13884: /* IF inv_cache.item_rec.revision_qty_control_code = 2 THEN
13885: l_is_revision_ctrl := TRUE;
13886: ELSE
13887: l_is_revision_ctrl := FALSE;
13888: END IF;

Line 13890: IF inv_cache.item_rec.lot_control_code = 2 THEN

13886: ELSE
13887: l_is_revision_ctrl := FALSE;
13888: END IF;
13889:
13890: IF inv_cache.item_rec.lot_control_code = 2 THEN
13891: l_is_lot_ctrl := TRUE;
13892: ELSE
13893: l_is_lot_ctrl := FALSE;
13894: END IF; */

Line 13896: IF inv_cache.item_rec.serial_number_control_code NOT IN (1, 6) THEN

13892: ELSE
13893: l_is_lot_ctrl := FALSE;
13894: END IF; */
13895:
13896: IF inv_cache.item_rec.serial_number_control_code NOT IN (1, 6) THEN
13897: l_is_serial_ctrl := FALSE;
13898: ELSE
13899: l_is_serial_ctrl := TRUE;
13900: END IF;