CREATE PROCEDURE [dbo].[p_acct_delete]

	-- input parameter
	@isn_num varchar(10)
AS
BEGIN
	SET NOCOUNT ON;
	DECLARE @ErrorCode VARCHAR(500)
	set @ErrorCode = '0'

	BEGIN TRY
	DELETE FROM emplr WHERE isn_num=@isn_num
	IF @@ROWCOUNT = 0
		set @ErrorCode = '6002' 
--  Error Code based on that you will be showing the exact message in UI
	END TRY
	BEGIN CATCH
		SELECT @ErrorCode = ERROR_MESSAGE()
	END CATCH
	SELECT @ErrorCode
-- This will return your error code
	RETURN
END
GO