FND_NEW_MESSAGES : Substitute Multiple values dynamically into Single Column

Hi All,

I have a requirement ,I need to substitue multiple values for a single column variable (&CUST_NUM,&CUST_NAME,&CUST_DEPT,.. ) defined as a message (fnd_new_messages.customer_text).

Then email to the Customers.

On the emailing part i have used "UTL_MAIL.SEND" hence not a problem.

Whereas for the "message" text to be send, i would need to send these dynamic values information fetched through some Cursor logic for multiple customers.

Note: I am using multiple language session. E.g. French, American Standard(US) and Italian Format for Customers.

Earlier i was using the below SET_TOKEN and it worked based on API - fnd_global.set_nls_context language defined for Customers language.