Search Results return_msg_text

Overview

APPS.HR_UTIL_MISC_WEB is a shared Oracle EBS utility package that supplies common web-enabling services to Oracle Human Resources (HRMS) self-service and HTML-based components. It is owned by APPS and classified as OTHER within the ETRM 12.2.2 inventory. The package exposes constants, global variables, and reusable helper routines that render HTML output, manage session state, resolve NLS and localization settings, and validate user input in Oracle EBS 12.1.1 and 12.2.2.

Because the user searched for fnd_session, the most relevant behavior of HR_UTIL_MISC_WEB is its session management layer. The package contains procedures such as INSERT_SESSION_ROW, AUTONOMOUS_COMMIT_FND_SESS_ROW, REMOVE_SESSION_ROW, and VALIDATE_SESSION, which interact with the FND_SESSIONS and ICX_SESSIONS tables. These routines allow HRMS web pages to create, validate, clean up, and commit Oracle Applications session records independently of the main transaction.

The package also centralizes UI and NLS utility logic. Global variables such as g_owa, g_image_dir, g_html_dir, and g_java_dir define the base paths for OA_MEDIA, OA_HTML, and OA_JAVA assets, while g_null, g_line_feed, g_carriage_return, and related constants provide character-handling equivalents for web output across language environments.

Key Procedures and Functions

• GET_NLS_PARAMETER — retrieves NLS configuration values used to render locale-aware output.
• GET_GROUP_SEPARATOR — returns the locale group separator for numeric formatting.
• GET_CURRENCY_MASK — supplies the currency display mask for a given context.
• IS_VALID_NUMBER / IS_VALID_CURRENCY — validate whether input strings conform to numeric or currency formats.
• GET_LANGUAGE_CODE — returns the current language code.
• GET_IMAGE_DIRECTORY / GET_HTML_DIRECTORY / GET_CALENDAR_FILE — resolve directory paths and calendar resources used by HR web pages.
• GET_PERSON_REC — retrieves person record information for HR self-service display.
• RETURN_MSG_TEXT — returns standardized message text, typically for user-facing feedback.
• GET_USER_DATE_FORMAT / BUILD_DATE2CHAR_EXPRESSION / VALIDATE_DATE_LOOKUP_CODE — handle date formatting and validation logic for HR date fields.
• INSERT_SESSION_ROW — creates a session row in the session tables.
• AUTONOMOUS_COMMIT_FND_SESS_ROW — commits the FND session row using an autonomous transaction.
• REMOVE_SESSION_ROW — deletes session rows during cleanup.
• VALIDATE_SESSION — verifies the existence and validity of a session.
• PREPARE_PARAMETER / GET_COMPLETE_URL — build parameter strings and construct fully qualified URLs for HR web navigation.

Tables Accessed

The package references several FND and HR tables through APPS synonyms. FND_SESSIONS and ICX_SESSIONS are central to its session management routines. FND_ATTACHED_DOCUMENTS, FND_DOCUMENTS, FND_DOCUMENTS_TL, FND_DOCUMENTS_LONG_TEXT, FND_DOCUMENT_CATEGORIES, FND_DOCUMENT_CATEGORIES_TL, and FND_DOCUMENT_DATATYPES support document and attachment handling. FND_FORM_FUNCTIONS supports function security checks, FND_PRODUCT_INSTALLATIONS supports installation status, and PER_ALL_PEOPLE_F supplies person data. DUAL is used for scalar queries, and HTP is referenced for HTML generation.

Usage Notes

HR_UTIL_MISC_WEB is typically invoked by HRMS self-service web pages and by other PL/SQL packages; the ETRM metadata notes that it is referenced by 31 other packages. It should not be called directly from custom business logic without understanding its session and NLS dependencies. Customizations that need to create or validate an EBS session for HR web flows may call INSERT_SESSION_ROW, AUTONOMOUS_COMMIT_FND_SESS_ROW, and VALIDATE_SESSION. In 12.1.1 and 12.2.2, its behavior relies on AUTHID CURRENT_USER and FND global context, so callers should ensure correct session initialization.