Using Text Messages in Pages and PL/SQL

Use Text Message substitution syntax in pages and APEX_LANG.GET_MESSAGE in PL/SQL.

Your app pages and process messages access a string with its Statid ID using this substitution syntax:

&{TEAM_MAX_ONE_LEAD}.

If the message includes named tokens, then provide their values like this:

&{TEAM_MAX_ONE_LEAD **name="**&P3_NAME.**"**}.

In PL/SQL code, GET_MESSAGE in the APEX_LANG package gets a string by its unique name. If the message includes named tokens, pass an APEX_T_VARCHAR2 string list with each token name followed by its string value.

l_message := apex_lang.get_message(
                p_name   => 'TEAM_MEMBER_NOT_FOUND',
                p_params => apex_t_varchar2(**'name'**,l_team_member.name));