APEX

I am creating a CSV file validation error report and currently am testing with some sample data and this is what I have:

How can I make the error message appear more user friendly? Ex: ‘First Name is Required’?

This is my code for the table:

select n001 as row_num,
      apex_lang.message( 'APEX.DATA_LOAD.' || c049 ) as action,
      c048 as error,
      c001, c002, c003,
      c004, c005, c006,
      c007, c008, c009,
      c010, c011, c012,
      c013, c014, c015,
      c016, c017, c018,
      c019, c020, c021,
      c022, c023, c024,
      c025, c026, c027,
      c028, c029, c030,
      c031, c032, c033,
      c034, c035, c036,
      c037, c038, c039,
      c040, c041, c042,
      c043, c044, c045
 from apex_collections
where collection_name = 'LOAD_CONTENT'
  and c047 in ('FAILED') 
order by seq_id