--EMP_NO_CHK_WHEN_VALIDATE_ITEM Trigger
-----------------------------------
Declare
cursor c is Select * from emp where Emp_no = :header.empno;
c1 emp%rowtype;
n NUMBER;
BEGIN
  OPEN c;
  Loop
	FETCH c into C1;
	Exit when c%notfound;
	n := n + 1;
  END LOOP:
  CLOSE c;
  If n = 0 then
	Raise NO_DATA_FOUND;
  END IF;
Exception
	WHEN NO_DATA_FOUND THEN
		RAISE FORM_FAILURE_TRIGGER;	
	WHEN OTHERS THEN
		Message('asasdsad');

END;

--EMP_NO_CHK_WHEN_VALIDATE_ITEM Trigger
-----------------------------------
Declare
cursor c is Select * from emp where Emp_no = :header.empno;
c1 emp%rowtype;
n NUMBER;
BEGIN
  OPEN c;
  Loop
	FETCH c into C1;
	Exit when c%notfound;
	n := n + 1;
  END LOOP:
  CLOSE c;
  If n = 0 then
	Raise NO_DATA_FOUND;
  END IF;
Exception
	WHEN NO_DATA_FOUND THEN
		RAISE FORM_TRIGGER_FAILURE;	
	WHEN OTHERS THEN
		Message('asasdsad');

END;

DECLARE
  v_count NUMBER;
BEGIN
  SELECT COUNT(*)
  INTO v_count
  FROM EMP
  WHERE Emp_No = :HEADER.EMPNO;
  
  IF v_count > 0 THEN
     MESSAGE('The Number of Records Found - '||v_count);
  ELSE
     RAISE FORM_TRIGGER_FAILURE;
  END IF;
END;

(OR)

DECLARE
  v_empno NUMBER;
BEGIN
  SELECT Emp_No
  INTO v_empno
  FROM EMP
  WHERE Emp_No = :HEADER.EMPNO;

  MESSAGE('This means it has got some Records');
EXCEPTION
  WHEN NO_DATA_FOUND THEN
    MESSAGE('No Data Found..!!');
    RAISE FORM_TRIGGER_FAILURE;
  WHEN OTHERS THEN
    MESSAGE('Error - '||SQLCODE);
END;