The code below contains errors. Can you please correct the errors so that the procedure can execute successfully.

CREATE PRO usp_delete_person(

 @person_id 

) AS

BEGIN

 BEGIN TRY

 BEGIN TRANSACTION;

 DELETE FROM sales.persons 

 WHERE person_iid = @person_id;

 COMMIT TRANSACTION; 

 END TRY

 BEGIN CATCH

 usp_report_error;

 IF (XACT_STATE) = -1 

 BEGIN 

 PRINT N'The transaction is in an uncommittable state.' + 

 'Rolling back transaction.' 

 ROLBACK TRANSACTION; 

 END; 

 IF (XACT_STATE) = 1 

 BEGIN 

 PRINT N'The transaction is committable.' + 

 'Committing transaction.' 

 COMIT TRANSACTION; 

 END; 

 END CATCH

END;

GO