DECLARE
  P_JOB_NUMBER long;
  P_ERROR_IND  nchar;
BEGIN
P_JOB_NUMBER:=6666;
P_ERROR_IND:='Y';
  dbms_output.put_line('Job ' || P_JOB_NUMBER || ' Ended Status=' ||
                       P_ERROR_IND);
  IF P_ERROR_IND='N'
    THEN 
      DBMS_OUTPUT.PUT_LINE('No Errors in Admin Utility for this Group');
      ELSE
        DBMS_OUTPUT.PUT_LINE('---------------------------------------------------------------------------------');
        DBMS_OUTPUT.PUT_LINE('Note:Following errors can also be seen in the control report through Admin Utility');
  FOR cursor1 IN ( SELECT m.*
    FROM OWBREP.mdrlogd m
    WHERE --to_char(mdrlogd_run_date,'mm/dd/yyyy') =to_char(sysdate-13,'mm/dd/yyyy')---match till hh:mm
    trunc(mdrlogd_run_date) =trunc(sysdate-13)
       and mdrlogd_message like '%Error%'AND
          NVL(mdrlogd_jobno, 1)= NVL(P_JOB_NUMBER, 1)
        AND   mdrlogd_process ='EDW_DIM_GR2' ----'&MDRLOGD_PROCESS'--- 
    ORDER BY mdrlogd_sequence)
   
  LOOP   
    DBMS_OUTPUT.PUT_LINE('*** Run Date = ' || cursor1.mdrlogd_run_date ||'; Mapping = ' || cursor1.mdrlogd_procedure||';Error Message = ' || cursor1.mdrlogd_message ||';
    Process = ' || cursor1.mdrlogd_process||'; Job No = ' || cursor1.mdrlogd_jobno);
  END LOOP;
    END IF;                 
                       
END;