Search Results get_msg

Overview

FII_MSG is a utility PL/SQL package owned by the APPS schema in Oracle E-Business Suite, delivered as part of the Financial Intelligence (FII) product family. Its source header, FIIGLC3S.pls version 120.7, indicates the package originated in the General Ledger code line and was created in June 2002 by M. Bedekar. The package is classified as "OTHER" within the ETRM metadata, meaning it is neither a public open interface nor a standard business API; it functions as an internal helper library.

The business role of FII_MSG is to centralize message retrieval and labeling logic for Financial Intelligence reporting components. Rather than embedding literal strings or currency/period descriptions inside individual report definitions, the FII reporting framework calls FII_MSG to obtain the correct text at runtime, keyed by page, user, session, and function context. This design permits a single point of change when message content, currency labels, or period headers must be adjusted across the FII application suite.

Key Procedures and Functions

• GET_MSG — the primary message retrieval function. The documentation explicitly states its purpose: it returns the string "XTD". It accepts page, user, session, and function name context values and returns a VARCHAR2 result. This is the function users locate when searching for "get_msg".
• GET_MSG1, GET_MSG2 — companion retrieval functions with the same four context parameters, providing alternate message variants for different page or function contexts.
• GET_MSG3 — a simplified retrieval function that takes a single current-value parameter and returns a VARCHAR2 result.
• GET_CURR — returns the currency identifier applicable to the current reporting context.
• GET_MANAGER — returns a NUMBER, typically the manager or reporting-level identifier used in FII hierarchies.
• GET_DBI_PARAMS — accepts a region ID and returns a VARCHAR2 parameter string, supplying Dashboard/DBI configuration values for a given region.
• GET_CURR_LABEL, GET_PRIOR_LABEL, GET_MARGIN_LABEL — return display labels for the current period, prior period, and margin columns respectively, used as column headings in FII reports.

Tables Accessed

FII_MSG references four FII time-dimension tables through APPS synonyms:

• FII_TIME_ENT_PERIOD — enterprise period definitions, used to resolve period labels and current-period context.
• FII_TIME_ENT_QTR — quarterly time entries supporting quarter-level reporting labels.
• FII_TIME_ENT_YEAR — year definitions used by GET_CURR_LABEL and related functions.
• FII_TIME_WEEK — weekly time entries, supporting week-grain FII analysis.

These tables supply the period and calendar values that the label functions translate into user-facing text.

Usage Notes

FII_MSG is invoked at runtime by FII reporting forms and concurrent program logic rather than executed directly by end users. No other package references it (referenced by 0 other packages per ETRM), suggesting it is called from form-level PL/SQL libraries or report triggers. Custom code extending FII reports may call GET_MSG-family functions with the appropriate page, user, session, and function context values. Because GET_MSG returns a fixed literal ("XTD"), implementations should treat it as a context flag rather than a general-purpose message source, and use GET_MSG1 through GET_MSG3 or the label functions for actual display text.