data not saving in database

See more:

SQL

Hi All,
I am trying to save data in a table using store procedure.while saving the data i am getting a message saying

error message:
INSERT statement conflicted with COLUMN FOREIGN KEY constraint 'FK_tbl_Items_tbl_StoreProfile'. The conflict occurred in database 'CSTORESDB', table 'tbl_StoreProfile', column 'stp_Storeid'.
The COMMIT TRANSACTION request has no corresponding BEGIN TRANSACTION.
The statement has been terminated.


store procedure:

ALTER       proc usp_InsertItems
(
@categoryID int,
@storeID int,
@itemCode varchar(30),
@itemName varchar(30),
@qty int,
@uomID int,
@itemValue decimal(18,2),
@desc varchar(255),
@status bit,
@returnValue int out
)
as

if not exists(select itm_ItemCode from tbl_Items where (itm_ItemCode =@itemCode and stp_Storeid = @storeID /*and ctg_Categoryid = @categoryID*/))
begin
	if not exists(select itm_ItemCode from tbl_NonInventoryItems where (itm_ItemCode =@itemCode and stp_Storeid = @storeID /*and ctg_Categoryid = @categoryID*/))
	begin
		if not exists(select Lott_ItemCode from tbl_Lottery where (Lott_ItemCode =@itemCode and stp_Storeid = @storeID /*and ctg_Categoryid = @categoryID*/))
		begin
			if not exists(select itm_ItemName from tbl_Items where (itm_ItemName = @itemName and stp_Storeid = @storeID /*and ctg_Categoryid = @categoryID*/))
			begin
				begin tran insertItems
				declare @id int
				select @id=isnull(max(itm_Itemid),0)+1 from tbl_Items
				insert into tbl_Items 
				(
					itm_Itemid,ctg_Categoryid,stp_Storeid,itm_ItemCode,itm_ItemName,itm_OpeningQty,uom_Uomid
					,item_ItemValue,itm_Description,itm_Status
				)
				values
				(
					@id,@categoryID,@storeID,@itemCode,@itemName,@qty,@uomID,@itemValue,@desc,@status
				)
					if @@error > 0
					begin 
						rollback tran insertItems
					end
				commit tran insertItems
				set @returnValue = 1
				return @returnValue
			end
			else
			begin
				set @returnValue = 3
				return @returnValue
			end	
		end
		else 
		begin
			set @returnValue = -2
			return @returnValue
		end
	end
	else
	begin
		set @returnValue = -3
		return @returnValue
	end
end
else
begin
	set @returnValue = -4
	return @returnValue
end

I will be thankful if any one can help

Thanks in Advance
Randheer kumar