HDL errors report

Summary:

We have a process which is doing HDL loads for requisitions automatically. Our client has asked whether we could make a report that would be sent out to them in case errors occured in the HDL loads. They want the report to contain per requisition whether an error occured for it or not.
We have this query which selects whether an error occured on the same date during the HDL load:
SELECT
ds.data_set_name,
ds.imported_status,
ds.validated_status,
ds.loaded_status,
ds.creation_date AS from_date,

ml.message_type,

ml.msg_text

FROM fusion.hrc_dl_processes p