Declare
	Int Number(20);
Begin
	SELECT Rtrim(RATE_OF_INTEREST) into Int   
	FROM MASTER_INTEREST
	WHERE RATE_OF_INTEREST = Rtrim(:Rate_Of_Interest);
	
 if Int=rtrim(:RATE_OF_INTEREST) then
    message('This Interest Already Available');
    message(' ');
  Raise Form_trigger_Failure;
 end if;
End;

FRM-40735: WHEN-VALIDATE-ITEM trigger raised unhandled exception ORA-01403

DECLARE

  INT NUMBER(20);
  
BEGIN
  
  SELECT 1 INTO INT   
  FROM MASTER_INTEREST
  WHERE RATE_OF_INTEREST = Rtrim(:Rate_Of_Interest);
  
  message('This Interest Already Available');
  message(' ');
  Raise Form_trigger_Failure;

EXCEPTION WHEN no_data_found THEN
  NULL;
END;