-
-

Messages

CORE HCM

Messages

SELECT fm.message_name Message_Name, fatl.application_name Application, fatv.user_module_name Module, fm.message_number, fm.context Translation_Notes, msg_type.meaning Message_Type, msg_cat.meaning Category, msg_sev.meaning Severity, HR_GENERAL.DECODE_LOOKUP('YES_NO',fm.loggable_alertable) Logging_Enabled, fm.message_text Short_Text, fm.message_user_Details User_Details, fm.message_Admin_details Administrator_Details, fm.message_Cause Cause, fm.message_user_action User_Action, fm.message_Admin_Action Administrator_Action, fmt.token_name, fmt.data_type, fmt.description FROM FND_MESSAGES fm, FND_APPLICATION_TL fatl, FND_MESSAGE_TOKENS fmt, fnd_lookups msg_type, fnd_lookups msg_cat, fnd_lookups msg_sev, fnd_appl_taxonomy_vl fatv WHERE msg_type.lookup_type(+) = 'MESSAGE_TYPE' AND msg_type.lookup_code(+) = fm.type AND msg_cat.lookup_type(+) = 'MESSAGE_CATEGORY' AND msg_cat.lookup_code(+) = fm.message_category AND msg_sev.lookup_type(+) = 'MESSAGE_SEVERITY' AND msg_sev.lookup_code(+) = fm.message_Severity AND fatv.module_id = fm.module_id AND fatl.application_id = fm.application_id AND fmt.message_name(+) = fm.message_name AND fatl.language = USERENV('LANG') AND fatl.application_name = 'Absence Management' AND ( (:P_CREATION_TYPE= 'Custom' and fm.created_by <> 'SEED_DATA_FROM_APPLICATION' ) OR (:P_CREATION_TYPE = 'Seeded' and fm.created_by = 'SEED_DATA_FROM_APPLICATION' ) OR (:P_CREATION_TYPE = 'Seeded Modified' and fm.created_by = 'SEED_DATA_FROM_APPLICATION' and fm.last_updated_by <> 'SEED_DATA_FROM_APPLICATION') OR (:P_CREATION_TYPE = 'ALL') ) ORDER BY fm.message_name