top of page

Get Person Default Language in IFS

Writer's picture: Rumesh Aponso (RMAX)Rumesh Aponso (RMAX)
DECLARE 
   user_id_         VARCHAR2(50);
   language_code_   VARCHAR2(10);
BEGIN
   --Get Session Logged-in Language Code
   user_id_ := Fnd_Session_API.Get_Fnd_User;
   Dbms_Output.Put_Line('user_id_: ' || user_id_);

   --Get User's Language Code
   language_code_ := Language_Code_API.Get_Lang_Code_Rfc3066(
                        Iso_Language_API.Encode(
                           Person_Info_API.Get_Default_Language(
                              Person_Info_API.Get_Id_For_User(user_id_)
                           )
                        )
                     );
   Dbms_Output.Put_Line('language_code_: ' || language_code_);
END;




2 views0 comments

Related Posts

See All

Fnd Dynamic Tab Page in IEE Client

[FndWindowRegistration("YVVDA_COMPANY_ADDR", "YvvdaCompanyAddr", FndWindowRegistrationFlags.HomePage)] [FndDynamicTabPage("frmCompanyAddr...

LISTAGG in PLSQL

Example 1: SELECT DISTINCT LISTAGG(t.commission_receiver, ';') WITHIN GROUP (ORDER BY t.commission_receiver) FROM...

Get Foundation Error from ORA Error

FUNCTION Strip_Ora_Error ( sqlerrm_        IN VARCHAR2,    sqlcode_        IN NUMBER DEFAULT NULL,    strip_ora_only_ IN BOOLEAN DEFAULT...

Comments


Copyright © 2025 RMAXOneNote

  • Online CV
  • LinkedIn
  • Youtube
  • GitHub
  • Blogger
bottom of page