Search Results fetch_sql_token

Overview

HR_BPL_MESSAGE is an Oracle EBS PL/SQL package owned by APPS and classified as an "OTHER" API. It provides message-resolution and message-token facilities for Oracle Human Resources, with particular emphasis on returning message text in the language of a specific Business Group rather than the session language. The header comment in the source (perbamsg.pkh, version 120.0) states the package's core purpose: "Function to return a MESSAGE in the Language of a Business Group." This distinguishes the package from the generic FND_MESSAGE utility, which is language-agnostic with respect to HR business groups.

The package declares AUTHID CURRENT_USER, meaning its SQL executes with the privileges of the invoking user rather than the definer. The package exposes twelve documented procedures and functions, several of which are explicitly described in the source as "Required unchanged FND_MESSAGE Functions," indicating that HR_BPL_MESSAGE is a thin, HR-aware wrapper around the standard FND_MESSAGE infrastructure. In Oracle EBS 12.1.1 and 12.2.2, the package remains available for backward compatibility with business-group-aware messaging requirements.

Key Procedures and Functions

• GET_STRING_LNG_BG — Returns a message string in the language of a specified Business Group; declared with two input parameters (application and message name).
• GET — Updated version of the GET function that permits explicit setting of the language; returns a VARCHAR2.
• SET_NAME_PSN — Sets the message using the language of a specified person (person_id).
• SET_NAME_SUP — Sets the message using the language of the supervisor of a given assignment.
• SET_NAME_PSUP — Sets the message using the language of the primary supervisor of a given assignment.
• SET_NAME_PSN_PSUP — Sets the message using the language of a person's primary supervisor.
• SET_NAME — Sets the message name using a Business Group identifier; declared with application, name, and business_group_id parameters.
• FETCH_SQL_TOKEN — Retrieves a SQL token used in database-side dynamic message resolution (the user's search term).
• SET_TOKEN — Sets a token value within the message context.
• SET_TOKEN_SQL — Sets a token whose value is derived from a SQL statement.
• RETRIEVE — Retrieves the currently configured message text.
• CLEAR — Clears the current message and token state.

Tables Accessed

• FND_APPLICATION — Read to validate or resolve application short names and their associated language context.
• FND_NEW_MESSAGES — Read to obtain message text, including translated message strings keyed by language, which supports the business-group language resolution behavior central to this package.

Usage Notes

HR_BPL_MESSAGE is typically invoked from HR forms, concurrent programs, and custom PL/SQL where a message must be presented in the language associated with a person, supervisor, or Business Group rather than the runtime session language. Because the package is classified as OTHER and carries legacy ("noship") versioning, new development should generally prefer the standard FND_MESSAGE API; HR_BPL_MESSAGE is most relevant where business-group language fidelity is required, or where existing code already depends on its token and message-state procedures (SET_TOKEN, SET_TOKEN_SQL, FETCH_SQL_TOKEN, RETRIEVE, CLEAR). The package is referenced by one other documented package, confirming its role as a supporting utility within the HR module rather than a standalone integration point.