conversion getting failed in sql

See more:

SQL

Here is my table name contacts

Column name             Datatype            (? tree view tickboxes ?(RD sp))
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
contacttypedetailid	int	             Unchecked
contactid	        char(6)	             Checked
contacttypecode	        char(3)	             Checked
Applicable	        char(1)	             Checked
TargetAmount	        decimal(18, 0)       Checked

The query:

select * from contacts

output:

contacttypedetailid	contactid	contacttypecode	  Applicable	  TargetAmount
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~	        
1	                     1     	    01 	             T	               0
2	                     1     	    02               T	               0
3	                     2     	    01 	             T	               0

while ("deleting") running procedure, I am getting error.

(The Deleting Procedure):

create PROCEDURE [dbo].[SP_DeleteContacttypeDetail]
            @contactid as int
  AS
  BEGIN
    Delete from contacttypedetail where contactid=@contactid 
  END

Here while executing these procedure am getting error.