Stored Procedure for Restricting Part Number without Blank Spaces while Adding/Updating an Item

IF @transaction_type in ('U', 'A' ) AND @object_type = '4'
BEGIN
If exists
 (select T0.Frgnname ,T0.Itemcode , T0.Itemname
from OITM T0
WHERE T0.ItemCode =@list_of_cols_val_tab_del  and  CHARINDEX(' ', T0.[Frgnname]) > 0
 )
SET @error = 401-01
SET @error_message = N'!!Pls Update Part Number without Blank Spaces!'
End