Transaction Notification Change in Card Type only from Lead to Customer Alert Message

[former_member559262]

HI,

I wrote a logic for Transaction Notification on Update of BP, This Logic is working for all update of Customers but I only want the Error message to be triggered only if it changes from Lead to Customer and update of BP.

Any Help will be greatly appreciated

[former_member559262]

IF @object_type = '2' and @transaction_type in('U')
  BEGIN
  IF    (SELECT  T1.CardType  from ACRD T1   WHERE  T1.CARDCODE= @list_of_cols_val_tab_del  AND t1.LogInstanc IN (SELECT max (LogInstanc  ) FROM ACRD T2 where  T2.CARDCODE=@list_of_cols_val_tab_del))  ='L'
      BEGIN
   IF  (SELECT OCPR.FIRSTNAME FROM OCRD T0 JOIN OCPR ON T0.CardCode=OCPR.CardCode  AND T0.[CntctPrsn] = OCPR.[Name]  WHERE T0.CardCode = @list_of_cols_val_tab_del ) IS NULL OR
   (SELECT OCPR.LastName  FROM OCRD T0 JOIN OCPR ON T0.CardCode=OCPR.CardCode AND T0.[CntctPrsn] = OCPR.[Name]  WHERE T0.CardCode = @list_of_cols_val_tab_del) IS NULL OR 
   (SELECT OCPR.Tel1  FROM OCRD T0 JOIN OCPR ON T0.CardCode=OCPR.CardCode AND T0.[CntctPrsn] = OCPR.[Name]  WHERE T0.CardCode = @list_of_cols_val_tab_del) IS NULL OR
   (SELECT OCPR.Fax  FROM OCRD T0 JOIN OCPR ON T0.CardCode=OCPR.CardCode AND T0.[CntctPrsn] = OCPR.[Name]  WHERE T0.CardCode = @list_of_cols_val_tab_del) IS NULL OR
   (SELECT OCPR.E_MailL  FROM OCRD T0 JOIN OCPR ON T0.CardCode=OCPR.CardCode AND T0.[CntctPrsn] = OCPR.[Name]   WHERE T0.CardCode = @list_of_cols_val_tab_del) IS NULL OR
   (SELECT OCPR.U_title  FROM OCRD T0 JOIN OCPR ON T0.CardCode=OCPR.CardCode AND T0.[CntctPrsn] = OCPR.[Name]  WHERE T0.CardCode = @list_of_cols_val_tab_del) IS NULL
   BEGIN
  select @error = 99, @error_message = 'Please Enter the FirstName, LastName,Telephone,Fax, Email and Title' 
  END
END
  END

[kothandaraman_nagarajan]

Hi,

Share your TN here to check.

Regards,

Nagarajan

[former_member559262]

Hi Nagarajan,

I figured out the Answer for this Question, Thanks for your response

IF @object_type = '2' and @transaction_type in('U')
  BEGIN
  IF    (SELECT  T1.CardType  from ACRD T1   WHERE  T1.CARDCODE= @list_of_cols_val_tab_del  AND t1.LogInstanc IN (SELECT max (LogInstanc  ) FROM ACRD T2 where  T2.CARDCODE=@list_of_cols_val_tab_del))  ='L'
      BEGIN
   IF  (SELECT OCPR.FIRSTNAME FROM OCRD T0 JOIN OCPR ON T0.CardCode=OCPR.CardCode  AND T0.[CntctPrsn] = OCPR.[Name]  WHERE T0.CardCode = @list_of_cols_val_tab_del ) IS NULL OR
   (SELECT OCPR.LastName  FROM OCRD T0 JOIN OCPR ON T0.CardCode=OCPR.CardCode AND T0.[CntctPrsn] = OCPR.[Name]  WHERE T0.CardCode = @list_of_cols_val_tab_del) IS NULL OR 
   (SELECT OCPR.Tel1  FROM OCRD T0 JOIN OCPR ON T0.CardCode=OCPR.CardCode AND T0.[CntctPrsn] = OCPR.[Name]  WHERE T0.CardCode = @list_of_cols_val_tab_del) IS NULL OR
   (SELECT OCPR.Fax  FROM OCRD T0 JOIN OCPR ON T0.CardCode=OCPR.CardCode AND T0.[CntctPrsn] = OCPR.[Name]  WHERE T0.CardCode = @list_of_cols_val_tab_del) IS NULL OR
   (SELECT OCPR.E_MailL  FROM OCRD T0 JOIN OCPR ON T0.CardCode=OCPR.CardCode AND T0.[CntctPrsn] = OCPR.[Name]   WHERE T0.CardCode = @list_of_cols_val_tab_del) IS NULL OR
   (SELECT OCPR.U_title  FROM OCRD T0 JOIN OCPR ON T0.CardCode=OCPR.CardCode AND T0.[CntctPrsn] = OCPR.[Name]  WHERE T0.CardCode = @list_of_cols_val_tab_del) IS NULL
   BEGIN
  select @error = 99, @error_message = 'Please Enter the FirstName, LastName,Telephone,Fax, Email and Title' 
  END
END
  END