Trigger not firing on cascade delete table

ALTER TRIGGER mwtrig_tblBulkUpload
ON	tblBulkUpload
FOR INSERT, UPDATE, DELETE
AS
DECLARE	@BulkUploadID		INT,
		@BulkUploadBatchID	INT,
		@EnglishName		VARCHAR( 200 ),		-- tblMember
		@NonEnglishName		NVARCHAR( 200 ),
		@OfficeName			VARCHAR( 500 ),		-- tblMemberLocation
		@StreetAddress		VARCHAR( 200 ),
		@ChineseStreetAddress	NVARCHAR( 200 ),
		@Country			VARCHAR( 200 ),		-- tblLocation
		@Region				VARCHAR( 200 ),
		@City				VARCHAR( 200 ),
		@Zip				VARCHAR( 50 ),		-- tblMemberLocation
		@Email				VARCHAR( 200 ),		-- tblMemberInternetInfo
		@Phone				VARCHAR( 200 ),
		@Description		VARCHAR( 5000 ),	-- tblMember
		@Classification		VARCHAR( 200 ),		-- tblMemberClassification
		@LastUpdateDate		SMALLDATETIME,
		@WhoID				INT,
		@Inserted			BIT,
		@InsertComment		VARCHAR( 8000 ),
		@LocationID			INT,
		@ClassificationID	INT,
		@CompanyID	INT
 
 
IF EXISTS( SELECT BulkUploadID FROM INSERTED )
	BEGIN
 
		SELECT	@BulkUploadID	=	BulkUploadID,
				@BulkUploadBatchID	=	BulkUploadBatchID,
				@EnglishName	=	EnglishName,
				@NonEnglishName	=	NonEnglishName,
				@OfficeName	=	OfficeName,
				@StreetAddress	=	StreetAddress,
				@ChineseStreetAddress	=	ChineseStreetAddress,
				@Country	=	Country,
				@Region	=	Region,
				@City	=	City,
				@Zip	=	Zip,
				@Email	=	Email,
				@Phone	=	Phone,
				@Description	=	Description,
				@Classification	=	Classification,
				@LastUpdateDate	=	LastUpdateDate,
				@WhoID	=	WhoID,
				@Inserted	=	Inserted,
				@InsertComment	= 'Please have a look at this record',		-- used for validation
				@LocationID = dbo.mwfn_getLocationID( Country, Region, City ),
				@ClassificationID = dbo.mwfn_getClassificationID( Classification ),
				@CompanyID = 0		-- will get id if successful insert
 
		FROM	INSERTED
 
		-- location
		IF @LocationID = 0
			BEGIN
				SET @InsertComment = 'Unable to determine location'
			END
 
		-- classification
		SELECT	ID, Value, RelID
		INTO	#ParsedTable
		FROM	dbo.mwfn_getClassificationInsertTable( @Classification )
 
		-- count classification records that couldn't be resolved
		DECLARE @CountClassificationZeros INT
		SELECT @CountClassificationZeros = COUNT( ID ) FROM #ParsedTable WHERE RelID = 0
 
 
		IF @CountClassificationZeros > 0
			BEGIN
				SET @InsertComment = 'Unable to determine classification'
			END
 
		-- get ready for insert
		IF @CountClassificationZeros = 0 AND @LocationID > 0
			BEGIN
				SET @InsertComment	= 'Inserting...'		
 
				--	INSERT COMPANY:
				EXEC mwsp_insertMemberForBulkUpload
					1,	-- typeID: company(1)
					@WhoID,	-- this is parent ID... not sure why we are using a user's ID
					'- none -',
					7,	--  EnglishPrefixID(7)
					'',	--	FirstName (company doesn't have one)
					@EnglishName,
					@NonEnglishName,
					6,	-- Chinese Suffix ID
					@WhoID,
					@CompanyID OUT
						
				--	INSERT PHONE NUMBER:
				DECLARE @Token AS VARCHAR( 8000 )
				SET @Token = @Phone
				DECLARE @Temp  AS VARCHAR(50)
 
				WHILE LEN( @Token ) > 0
					BEGIN
					   IF CHARINDEX('|', @Token) = 0
						  BEGIN
							SET @TEMP =@Token
							SET @Token = ''
 
							-- insert value
							EXEC mwsp_insertMemberContactNumber
								@CompanyID,
								7,	-- Business Phone 1 (id:7)
								@TEMP,
								@WhoID
						  END
					ELSE
					  BEGIN
						SET @Temp = LEFT( @Token, CHARINDEX( '|', @Token )-1 )
						
						-- insert value
						EXEC mwsp_insertMemberContactNumber
							@CompanyID,
							7,	-- Business Phone 1 (id:7)
							@TEMP,
							@WhoID
 
						SET @Token = RIGHT(@Token, LEN(@Token)-LEN(@Temp)-1)
				   END
				END
 
 
				--	EMAIL ADDRESS
				SET @Token = @Email
 
				WHILE LEN( @Token ) > 0
					BEGIN
					  IF CHARINDEX('|', @Token) = 0
					  BEGIN
						SET @TEMP =@Token
						SET @Token = ''
 
						-- insert value
						EXEC mwsp_insertMemberInternetInfo
							@CompanyID,
							1, -- InternetInfoTypeID Email( 1 )
							@TEMP,
							@WhoID
					  END
					ELSE
					  BEGIN
						SET @Temp = LEFT( @Token, CHARINDEX( '|', @Token )-1 )
						
						-- insert value
						EXEC mwsp_insertMemberInternetInfo
							@CompanyID,
							1, -- InternetInfoTypeID Email( 1 )
							@TEMP,
							@WhoID
 
						SET @Token = RIGHT(@Token, LEN(@Token)-LEN(@Temp)-1)
					  END
					END
 
				--	INSERT CLASSIFICATION REL
				DECLARE		@RelID INT
				DECLARE cur_CwClassification	CURSOR LOCAL FORWARD_ONLY STATIC
					FOR (	SELECT 	RelID
							FROM	#ParsedTable	)
				OPEN 	cur_CwClassification
				FETCH 	cur_CwClassification
				INTO 	@RelID
 
				WHILE @@FETCH_STATUS = 0
				BEGIN
					-- insert into classification
					EXEC mwsp_insertMemberClassificationRel @CompanyID, @RelID, @WhoID
 
					FETCH 	cur_CwClassification
					INTO 	@RelID
				END
				CLOSE 	cur_CwClassification
				DEALLOCATE cur_CwClassification
 
				--	INSERT LOCATION
				EXEC mwsp_insertMemberLocationForBulkUpload
					@CompanyID,
					@OfficeName,
					@StreetAddress,
					'',	-- street address 2
					@ChineseStreetAddress,
					@LocationID,
					1,	-- @MainAddressBool_6 	[bit],
					@Zip,
					@WhoID
 
				SET @Inserted = 1
				SET	@InsertComment = 'Successful insert!'
			END
 
		-- update the Bulk Upload File
		EXEC mwsp_updateBulkUpload
			@BulkUploadID,
			@BulkUploadBatchID,
			@EnglishName,
			@NonEnglishName,
			@OfficeName,
			@StreetAddress,
			@ChineseStreetAddress,
			@Country,
			@Region,
			@City,
			@Zip,
			@Email,
			@Phone,
			@Description,
			@Classification,
			@WhoID,
			@Inserted,
			@InsertComment,
			@CompanyID
	END
ELSE
	BEGIN
		DECLARE @CompID	INT
		SELECT @CompID = ISNULL( d.MemberID, 0 )
		FROM	DELETED d
 
		IF @CompID > 0
			BEGIN
				EXEC jcDeleteMember @CompID
			END
	END
GO

CREATE TABLE tblBulkUploadBatch
(
	BulkUploadBatchID	INT PRIMARY KEY IDENTITY( 1, 1 ),
	Guid				UNIQUEIDENTIFIER DEFAULT( NEWID() ),
	Name				NVARCHAR( 400 ),	-- used to name the bulk upload
	WhoID				INT,	-- who did the initial upload
	UploadDate			SMALLDATETIME DEFAULT( GETDATE() ),
	FOREIGN KEY( WhoID )	REFERENCES tblMember( ID ) ON DELETE CASCADE
)
GO
 
CREATE TABLE tblBulkUpload
(
	BulkUploadID		INT PRIMARY KEY IDENTITY( 1, 1 ),
	BulkUploadBatchID	INT,
	EnglishName			VARCHAR( 200 ),		-- tblMember
	NonEnglishName		NVARCHAR( 200 ),
	OfficeName			VARCHAR( 500 ),		-- tblMemberLocation
	StreetAddress		VARCHAR( 200 ),
	ChineseStreetAddress	NVARCHAR( 200 ),
	Country				VARCHAR( 200 ),		-- tblLocation
	Region				VARCHAR( 200 ),
	City				VARCHAR( 200 ),
	Zip					VARCHAR( 50 ),		-- tblMemberLocation
	Email				VARCHAR( 200 ),		-- tblMemberInternetInfo
	Phone				VARCHAR( 200 ),
	Description			VARCHAR( 500 ),		-- tblMember ( should be 5K but row size is exceeded )
	Classification		VARCHAR( 200 ),		-- tblMemberClassification
	LastUpdateDate		SMALLDATETIME DEFAULT( GETDATE() ),
	WhoID				INT,
	Inserted			BIT DEFAULT( 0 ),
	InsertComment		VARCHAR( 1000 ) DEFAULT( 'No attempt yet... please refresh in 10 seconds' ),
	MemberID			INT NULL,	-- is populated with the memberId after an insert is completed
	FOREIGN KEY( BulkUploadBatchID )	REFERENCES tblBulkUploadBatch( BulkUploadBatchID ) ON DELETE CASCADE,
	FOREIGN KEY( WhoID )	REFERENCES tblMember( ID )
)