2 Replies Latest reply on May 15, 2015 11:09 AM by 2892158

    Sending Email to User based on USER PREFERENCES Language.

    2892158

      The requirement is, a email should be sent to user based on USERENV('LANG') Looks simple but the complicated part is we need to pass values to the email at run time as follows:

       

      HI &User, --Here User should be passed.





      The site With Active Status are &Site_List.--Here Site_List is to be passed at run time.

       

       

      1.)DataBase Version is 12.1.3.2

      2.)I have tried  FND_MESSAGE so far i have created message with Three Languages ARABIC, FRENCH, ENGLISH based on USER Preferences language it has to pick email and send message body but i dont see any Function/Procedure to get USerPrefered languagefrom FND_MESSAGE API