The error messsage is telling you to declare your variables.
DECLARE @FILENAME VARCHAR(128)
DECLARE @FILEPATH VARCHAR(4)
DECLARE @FILETYPE INT
...
...
...
DECLARE @DELETED BIT
SELECT
@FILENAME ='harshal',
@FILEPATH ='g:',
@FILETYPE = 1,
...
...
...
@DELETED = 0
exec [K2_CHECKENTRYINFILELOG] @FILENAME,@FILEPATH,FILETYPE,@FILEDATE,@CIRCLEID,@TOTALROWS,@SUCCESSCOUNT,@FAILURECOUNT,@PROCESSED,@ERROR,@VENDORID,@CREATEDBY,@CREATEDON,@DELETED;
IF NOT EXISTS (
select count(CIRCLEID) from K2FILELOG where FILEPATH = @FILEPATH and
[FILENAME] = @FILENAME and
FILETYPE = @FILETYPE and
FILEDATE = @FILEDATE and
CIRCLEID = @CIRCLEID and
TOTALROWS = @TOTALROWS and
SUCCESSCOUNT = @SUCCESSCOUNT and
FAILURECOUNT = @FAILURECOUNT and
PROCESSED = @PROCESSED and
ERROR = @ERROR and
VENDORID = @VENDORID and
CREATEDBY = @CREATEDBY and
CREATEDON = @CREATEDON and
DELETED = @DELETED)