PS_MESSAGE_CATALOG

PS_MESSAGE_CATALOG – this table is used as a catalog, to keep the messages that appear in the Message Log, PIA error/warning messages ,etc., their corresponding message set number and the message number.
In order to determine the messages in the Message Log of a process instance one can issue the followin statement on a Sql Server database:
SELECT V.PROCESSINSTANCE, C.MESSAGE_SET_NBR,C.MESSAGE_NBR,C.MESSAGE_TEXT,SEVERITY=CASE C.MSG_SEVERITY
WHEN ‘C’ THEN ‘Cancel’
WHEN ‘E’ THEN ‘Error’
WHEN ‘M’ THEN ‘Message’
WHEN ‘W’ THEN ‘Warning’
ELSE ‘N/A’
END,V.MESSAGE_SEQ, L.MESSAGE_PARM
FROM  PS_MESSAGE_CATALOG C�
INNER JOIN PS_PMN_MSGLOG_VW V ON C.MESSAGE_SET_NBR=V.MESSAGE_SET_NBR AND C.MESSAGE_NBR=V.MESSAGE_NBR
INNER JOIN PS_MESSAGE_LOGPARM L ON V.PROCESSINSTANCE=L.PROCESS_INSTANCE
WHERE C.LANGUAGE_CD=’ENG’ AND V.PROCESSINSTANCE=’Process_instance’
or simply check the on the Details link (and further on the Message Log link) of a specific process instance, in Process Monitor tool.