FND Messages API is not returning the message text with substituted token values
Tried calling the standard API as a stand-alone call. It did not work in both cases.
Pasting the content below from the word document for your easy reference:
set serveroutput on
declare
l_chr_msg varchar2(4000);
begin
apps.fnd_message.set_name ('XXCORP', 'HNI_CZ_MODEL_SEGS_MISMATCH_MSG');
apps.fnd_message.set_token ('BASE_MODEL', 'H312');
apps.fnd_message.set_token ('N', '2');
l_chr_msg := apps.fnd_message.get;
dbms_output.put_line(l_chr_msg);
end;
Result
anonymous block completed
HNI_CZ_MODEL_SEGS_MISMATCH_MSG (BASE_MODEL=H312) (N=2)
The expected result was H312 expects 2 segments