DML Error Logging while Inserting records

Create a log table  (Eg: Emp_Err_Log)

  INSERT INTO dw_empl
  SELECT empno, first_name, last_name, hire_date, sal, Deptno
  FROM emp
  WHERE hire_date > sysdate - 7
  LOG ERRORS INTO Emp_Err_Log('daily_load') REJECT LIMIT 25

If the records are exceeded 25 in Emp_Err_Log, the transaction will rollback.