Stored Procedure Help For Join Query

[Riaaaa]

Hello members,

This is the SQL SERVER 2005 stored procedure.

It contains the data from the two diff tables.
(1)Customer :
Here clpid and cardid are composite primary keys with the identity field.It has storeid as foreign key.
The cardid is to be autogenerated everytime as the new customer is inserted.

I have to put the validations for the
* joindt = currentdate/todaydate
* dob is not greater than today date
* anniverdt is not less than equal to dob (in terms of year)

(2)Store :
Here storeid is the primary key.

ALTER PROCEDURE CustomerStoredProcedure

@cardid INT OUTPUT,
@clpid INT OUTPUT,
@storename varchar(20),
@firstname varchar(20),
@lastname varchar(20),
@joindt datetime,
@anniverdt datetime,
@dob datetime,

@frmErrorMessage AS VARCHAR(256) OUTPUT,
@RETURNVALUE AS INT OUTPUT,
@RETURNID AS INT OUTPUT
AS

DECLARE

  @storeid AS INT
  
BEGIN
SET NOCOUNT ON


--validation...
IF ( @firstname IS NULL OR @firstname = '' ) 
	BEGIN
		SET  @RETURNVALUE = -9
		SET  @frmErrorMessage = 'FName is empty'
		RETURN -9						
	END 
IF ( @lastname IS NULL OR @lastname = '' ) 
	BEGIN
		SET  @RETURNVALUE = -9
		SET  @frmErrorMessage = 'LName is empty'
		RETURN -9						
	END
	
if  @DOB<@AnniversaryDate
				begin
					Select @frmErrorMessage ="AnniversaryDate cannot be greater then DOB"
					return -9
				end 
			if  @DOB=@AnniversaryDate
				begin
					Select @frmErrorMessage ="AnniversaryDate cannot be equal to DOB"
					return -9
				end 
			
			if  @DOB>=getdate()
				begin
					Select @frmErrorMessage ="DOB cannot be greater then Today's Date"
					return -9
				end 	 	
BEGIN			
IF EXISTS (select * from storemaster where storename = @storename)                                  
       select @storeid = storeid from storemaster where storename = @storename                                          	                                       
                    				

IF EXISTS ( SELECT firstname,lastname,joindt,anniverdt,dob,
                 FROM customermaster WHERE clpid = @clpid and cardid=cardid) 
	BEGIN
		UPDATE customermaster
		SET firstname = @firstname,
			lastname = @lastname,
			storeid=@storeid,
			joindt=@joindt,	
			anniverdt=@anniverdt,
			dob=@dob,
				
	WHERE  clpid= @clpid and cardid=@cardid

		SET  @frmErrorMessage = 'Name and other information has been updated'
		SET @RETURNVALUE = 2
	END
END	

BEGIN
   IF EXISTS (select * from storemaster where storename = @storename)                                  
       select @storeid = storeid from storemaster where storename = @storename                                          	                                       
                    				

  IF NOT EXISTS(Select firstname,lastname,address 
	        from customermaster
	        where firstname = @firstname,lastname=@lastname)
		BEGIN
           INSERT INTO customermaster (firstname,lastname,joindt,anniverdt,dob,introducedby)
		       VALUES     (@firstname,@lastname,@joindt,@anniverdt,@dob,@introducedby)
           SELECT @clpid = SCOPE_IDENTITY()
           SELECT @cardid= SCOPE_IDENTITY()
        END
   ELSE
       BEGIN
          Print 'Name already exists'  
       END
		
		SET  @frmErrorMessage = ' Name and other information has been Inserted'
		SET @RETURNVALUE = 1
END
	
SET NOCOUNT OFF
END

Pls can anyone checkout my stored procedure as i have created for the first time for the join stored procedure.
It gives me the error but i can't rectify it.
It is too big but can anyone help then it's fine....
I have mentioned how i created my above procedure.
Can anyone also help me to check or put the validations for the date..

Thanxs in advance...waiti ng for solution

Hope to get a suitable reply