APPS.WMS_CARTNZN_PUB dependencies on INV_CACHE

Line 6154: IF NOT INV_CACHE.set_item_rec(v1.organization_id, v1.inventory_item_id) THEN

6150: END IF;
6151: EXIT WHEN wct_rows%NOTFOUND;
6152: END IF;
6153:
6154: IF NOT INV_CACHE.set_item_rec(v1.organization_id, v1.inventory_item_id) THEN
6155: IF (g_trace_on = 1) THEN
6156: log_event('Inventory Cache Set Item Rec Failed');
6157: END IF;
6158: RAISE fnd_api.g_exc_unexpected_error;

Line 6161: l_revision_code := inv_cache.item_rec.revision_qty_control_code;

6157: END IF;
6158: RAISE fnd_api.g_exc_unexpected_error;
6159: END IF;
6160:
6161: l_revision_code := inv_cache.item_rec.revision_qty_control_code;
6162: l_lot_code := inv_cache.item_rec.lot_control_code;
6163: l_serial_code := inv_cache.item_rec.serial_number_control_code;
6164:
6165: IF (g_trace_on = 1) THEN

Line 6162: l_lot_code := inv_cache.item_rec.lot_control_code;

6158: RAISE fnd_api.g_exc_unexpected_error;
6159: END IF;
6160:
6161: l_revision_code := inv_cache.item_rec.revision_qty_control_code;
6162: l_lot_code := inv_cache.item_rec.lot_control_code;
6163: l_serial_code := inv_cache.item_rec.serial_number_control_code;
6164:
6165: IF (g_trace_on = 1) THEN
6166: log_event('revision code : '|| l_revision_code);

Line 6163: l_serial_code := inv_cache.item_rec.serial_number_control_code;

6159: END IF;
6160:
6161: l_revision_code := inv_cache.item_rec.revision_qty_control_code;
6162: l_lot_code := inv_cache.item_rec.lot_control_code;
6163: l_serial_code := inv_cache.item_rec.serial_number_control_code;
6164:
6165: IF (g_trace_on = 1) THEN
6166: log_event('revision code : '|| l_revision_code);
6167: log_event('lot code : '|| l_lot_code);

Line 6274: v_primary_uom_code := inv_cache.item_rec.primary_uom_code;

6270: END IF;
6271:
6272: error_code := 'CARTONIZE 170';
6273:
6274: v_primary_uom_code := inv_cache.item_rec.primary_uom_code;
6275:
6276: IF ( v1.content_lpn_id IS NOT NULL ) THEN
6277: -- We want to set the transaction uom same as primary uom
6278: v1.transaction_uom := v_primary_uom_code;

Line 6419: v_serial_control_code := inv_cache.item_rec.serial_number_control_code;

6415: IF (g_trace_on = 1) THEN
6416: log_event('improper values returned by container_required_qty ');
6417: END IF;
6418: ELSE
6419: v_serial_control_code := inv_cache.item_rec.serial_number_control_code;
6420:
6421: IF( (v_serial_control_code NOT IN (1,6) )
6422: AND (Ceil(v_qty_per_cont) > v_qty_per_cont )) THEN
6423: IF (g_trace_on = 1) THEN