What's the name of the table that stores load errors and messages?

MKT_IMP_ERRORS and FND_MESSAGES_TL table stores error messages.

See the Tables and Views for Sales and Fusion Service guide for more information.