Query to get error occurred during payroll run for a pay period in Fusion HCM

select
PAP.PERSON_NUMBER,
PPN.FULL_NAME,
PAA.ASSIGNMENT_NUMBER, 
SUBSTR(PTP.START_DATE,1,10) AS PAYROLL_START_DATE,
SUBSTR(PTP.END_DATE,1,10) AS PAYROLL_END_DATE,
MSG.LINE_TEXT
FROM 
PAY_PAYROLL_REL_ACTIONS PREL,
PAY_REL_GROUPS_DN PRG,
PAY_PAYROLL_ACTIONS PPAA,
PAY_TIME_PERIODS PTP,
PAY_MESSAGE_LINES MSG,
PER_ALL_ASSIGNMENTS_M PAA,
PER_PERSON_NAMES_F PPN,
PER_ALL_PEOPLE_F PAP
WHERE 
1=1
AND PREL.PAYROLL_RELATIONSHIP_ID = PRG.PAYROLL_RELATIONSHIP_ID
AND PREL.PAYROLL_ACTION_ID   = PPAA.PAYROLL_ACTION_ID
AND MSG.MESSAGE_LEVEL IN ('E','F')
AND PPAA.ACTION_TYPE   IN ('Q', 'R') -- PAYROLL TYPE QUICK PAY OR PAYROLL RUN
AND PTP.TIME_PERIOD_ID = PPAA.EARN_TIME_PERIOD_ID
AND UPPER(PTP.PERIOD_NAME) LIKE '%'||:1||'%'
AND PTP.PAYROLL_ID   = PPAA.PAYROLL_ID
AND PRG.ASSIGNMENT_ID = PAA.ASSIGNMENT_ID
AND PAA.ASSIGNMENT_TYPE IN('E','C')
AND PAA.PERSON_ID = PAP.PERSON_ID
AND PAP.PERSON_ID = PPN.PERSON_ID
AND PPN.NAME_TYPE = 'GLOBAL'
AND PPAA.EFFECTIVE_DATE BETWEEN PAA.EFFECTIVE_START_DATE AND PAA.EFFECTIVE_END_DATE
AND PPAA.EFFECTIVE_DATE BETWEEN PAP.EFFECTIVE_START_DATE AND PAP.EFFECTIVE_END_DATE
AND PPAA.EFFECTIVE_DATE BETWEEN PPN.EFFECTIVE_START_DATE AND PPN.EFFECTIVE_END_DATE
AND MSG.SOURCE_ID = PREL.PAYROLL_REL_ACTION_ID
ORDER BY PAP.PERSON_NUMBER