4319: WHERE ROWID = l_wlpn_row_id;
4320:
4321: ELSIF p_clear_containter_item_id = 'N'
4322: AND l_container_item_id IS NOT NULL THEN
4323: IF ( NOT inv_cache.set_item_rec( p_organization_id => p_new_org_id
4324: , p_item_id => l_container_item_id ) ) THEN
4325: IF l_debug = 1 THEN
4326: mdebug('Error calling inv_cache.set_item_rec');
4327: END IF;
4322: AND l_container_item_id IS NOT NULL THEN
4323: IF ( NOT inv_cache.set_item_rec( p_organization_id => p_new_org_id
4324: , p_item_id => l_container_item_id ) ) THEN
4325: IF l_debug = 1 THEN
4326: mdebug('Error calling inv_cache.set_item_rec');
4327: END IF;
4328: RAISE fnd_api.g_exc_unexpected_error;
4329: END IF;
4330:
4328: RAISE fnd_api.g_exc_unexpected_error;
4329: END IF;
4330:
4331: UPDATE wms_license_plate_numbers
4332: SET gross_weight = inv_cache.item_rec.unit_weight
4333: , gross_weight_uom_code = inv_cache.item_rec.weight_uom_code
4334: , tare_weight = inv_cache.item_rec.unit_weight
4335: , tare_weight_uom_code = inv_cache.item_rec.weight_uom_code
4336: , container_volume = inv_cache.item_rec.unit_volume
4329: END IF;
4330:
4331: UPDATE wms_license_plate_numbers
4332: SET gross_weight = inv_cache.item_rec.unit_weight
4333: , gross_weight_uom_code = inv_cache.item_rec.weight_uom_code
4334: , tare_weight = inv_cache.item_rec.unit_weight
4335: , tare_weight_uom_code = inv_cache.item_rec.weight_uom_code
4336: , container_volume = inv_cache.item_rec.unit_volume
4337: , container_volume_uom = inv_cache.item_rec.volume_uom_code
4330:
4331: UPDATE wms_license_plate_numbers
4332: SET gross_weight = inv_cache.item_rec.unit_weight
4333: , gross_weight_uom_code = inv_cache.item_rec.weight_uom_code
4334: , tare_weight = inv_cache.item_rec.unit_weight
4335: , tare_weight_uom_code = inv_cache.item_rec.weight_uom_code
4336: , container_volume = inv_cache.item_rec.unit_volume
4337: , container_volume_uom = inv_cache.item_rec.volume_uom_code
4338: WHERE ROWID = l_wlpn_row_id;
4331: UPDATE wms_license_plate_numbers
4332: SET gross_weight = inv_cache.item_rec.unit_weight
4333: , gross_weight_uom_code = inv_cache.item_rec.weight_uom_code
4334: , tare_weight = inv_cache.item_rec.unit_weight
4335: , tare_weight_uom_code = inv_cache.item_rec.weight_uom_code
4336: , container_volume = inv_cache.item_rec.unit_volume
4337: , container_volume_uom = inv_cache.item_rec.volume_uom_code
4338: WHERE ROWID = l_wlpn_row_id;
4339: END IF;
4332: SET gross_weight = inv_cache.item_rec.unit_weight
4333: , gross_weight_uom_code = inv_cache.item_rec.weight_uom_code
4334: , tare_weight = inv_cache.item_rec.unit_weight
4335: , tare_weight_uom_code = inv_cache.item_rec.weight_uom_code
4336: , container_volume = inv_cache.item_rec.unit_volume
4337: , container_volume_uom = inv_cache.item_rec.volume_uom_code
4338: WHERE ROWID = l_wlpn_row_id;
4339: END IF;
4340:
4333: , gross_weight_uom_code = inv_cache.item_rec.weight_uom_code
4334: , tare_weight = inv_cache.item_rec.unit_weight
4335: , tare_weight_uom_code = inv_cache.item_rec.weight_uom_code
4336: , container_volume = inv_cache.item_rec.unit_volume
4337: , container_volume_uom = inv_cache.item_rec.volume_uom_code
4338: WHERE ROWID = l_wlpn_row_id;
4339: END IF;
4340:
4341: ELSIF p_unpack_inner_lpns = 'Y' THEN
4548: WHERE lpn_id = all_child_wlpn_rec.lpn_id;
4549:
4550: ELSIF p_clear_containter_item_id = 'N'
4551: AND l_container_item_id IS NOT NULL THEN
4552: IF ( NOT inv_cache.set_item_rec( p_organization_id => p_new_org_id
4553: , p_item_id => l_container_item_id ) ) THEN
4554: IF l_debug = 1 THEN
4555: mdebug('Error calling inv_cache.set_item_rec');
4556: END IF;
4551: AND l_container_item_id IS NOT NULL THEN
4552: IF ( NOT inv_cache.set_item_rec( p_organization_id => p_new_org_id
4553: , p_item_id => l_container_item_id ) ) THEN
4554: IF l_debug = 1 THEN
4555: mdebug('Error calling inv_cache.set_item_rec');
4556: END IF;
4557: RAISE fnd_api.g_exc_unexpected_error;
4558: END IF;
4559:
4557: RAISE fnd_api.g_exc_unexpected_error;
4558: END IF;
4559:
4560: UPDATE wms_license_plate_numbers
4561: SET gross_weight = inv_cache.item_rec.unit_weight
4562: , gross_weight_uom_code = inv_cache.item_rec.weight_uom_code
4563: , tare_weight = inv_cache.item_rec.unit_weight
4564: , tare_weight_uom_code = inv_cache.item_rec.weight_uom_code
4565: , container_volume = inv_cache.item_rec.unit_volume
4558: END IF;
4559:
4560: UPDATE wms_license_plate_numbers
4561: SET gross_weight = inv_cache.item_rec.unit_weight
4562: , gross_weight_uom_code = inv_cache.item_rec.weight_uom_code
4563: , tare_weight = inv_cache.item_rec.unit_weight
4564: , tare_weight_uom_code = inv_cache.item_rec.weight_uom_code
4565: , container_volume = inv_cache.item_rec.unit_volume
4566: , container_volume_uom = inv_cache.item_rec.volume_uom_code
4559:
4560: UPDATE wms_license_plate_numbers
4561: SET gross_weight = inv_cache.item_rec.unit_weight
4562: , gross_weight_uom_code = inv_cache.item_rec.weight_uom_code
4563: , tare_weight = inv_cache.item_rec.unit_weight
4564: , tare_weight_uom_code = inv_cache.item_rec.weight_uom_code
4565: , container_volume = inv_cache.item_rec.unit_volume
4566: , container_volume_uom = inv_cache.item_rec.volume_uom_code
4567: WHERE lpn_id = all_child_wlpn_rec.lpn_id;
4560: UPDATE wms_license_plate_numbers
4561: SET gross_weight = inv_cache.item_rec.unit_weight
4562: , gross_weight_uom_code = inv_cache.item_rec.weight_uom_code
4563: , tare_weight = inv_cache.item_rec.unit_weight
4564: , tare_weight_uom_code = inv_cache.item_rec.weight_uom_code
4565: , container_volume = inv_cache.item_rec.unit_volume
4566: , container_volume_uom = inv_cache.item_rec.volume_uom_code
4567: WHERE lpn_id = all_child_wlpn_rec.lpn_id;
4568: END IF;
4561: SET gross_weight = inv_cache.item_rec.unit_weight
4562: , gross_weight_uom_code = inv_cache.item_rec.weight_uom_code
4563: , tare_weight = inv_cache.item_rec.unit_weight
4564: , tare_weight_uom_code = inv_cache.item_rec.weight_uom_code
4565: , container_volume = inv_cache.item_rec.unit_volume
4566: , container_volume_uom = inv_cache.item_rec.volume_uom_code
4567: WHERE lpn_id = all_child_wlpn_rec.lpn_id;
4568: END IF;
4569:
4562: , gross_weight_uom_code = inv_cache.item_rec.weight_uom_code
4563: , tare_weight = inv_cache.item_rec.unit_weight
4564: , tare_weight_uom_code = inv_cache.item_rec.weight_uom_code
4565: , container_volume = inv_cache.item_rec.unit_volume
4566: , container_volume_uom = inv_cache.item_rec.volume_uom_code
4567: WHERE lpn_id = all_child_wlpn_rec.lpn_id;
4568: END IF;
4569:
4570: END LOOP;