Translate titles, messages and button labels of alerts in the When-New-Form-Instance trigger or immediately before invoking the alert.
DECLARE
l_alert_title m_glossary_details.translated_prompt%TYPE;
l_alert_msg_text m_glossary_details.translated_prompt%TYPE;
l_alert_button_label m_glossary_details.translated_prompt%TYPE;
l_translated_hint m_glossary_details.translated_hint%TYPE;
l_translated_tooltip m_glossary_details.translated_tooltip%TYPE;
BEGIN
/* Alert title */
m_pck_dynamic_labels.get_translated_prompt (‘My title’,
l_alert_title,
l_translated_hint,
l_translated_tooltip
);
SET_ALERT_PROPERTY('my_alert', TITLE, l_alert_title));
/* Alert message */
m_pck_dynamic_labels.get_translated_prompt (‘My title’,
l_alert_msg_text,
l_translated_hint,
l_translated_tooltip
);
SET_ALERT_PROPERTY('my_alert', ALERT_MESSAGE_TEXT, l_alert_msg_text));
/* Alert button label */
m_pck_dynamic_labels.get_translated_prompt (‘My title’,
l_alert_button_label,
l_translated_hint,
l_translated_tooltip
);
SET_ALERT_BUTTON_PROPERTY('my_alert', ALERT_BUTTON1, LABEL, l_alert_button_label);
END;