Warning Status in Concurrent Program if Report does not have no Data

Warning Status in Concurrent Program if Report does not have no Data

We can display "Warning Status" when we run a concurrent program and the output does not have no data.

Using oracle report builder, Create a summary column which includes count of any column.

Use below logic in After Report in Report Builder.

FUNCTION AfterReport
  RETURN BOOLEAN
IS
  l_count BOOLEAN;
BEGIN
  SRW.USER_EXIT('FND SRWEXIT');
  IF (:cs_count < 1) THEN
    l_count    := fnd_concurrent.set_completion_status('WARNING','Warning details');
  END IF;
  COMMIT;
  RETURN(l_count);
END;