Results for “get_industry_message”

16 results




AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

APPS.GL_FORMSINFO2 is a General Ledger utility package body that centralizes the retrieval of accounting structure information for Oracle E-Business Suite forms. Its core purpose is to bridge the gap between the Oracle Forms presentation layer and the underlying Flexfield definitions stored in the Applications Foundation schema, primarily by resolving chart of accounts attributes such as the segment delimiter, enabled segment count, segment ordering, and the positions of the natural account, balancing, and intercompany segments.

Rather than embedding this lookup logic directly inside compiled Oracle Forms modules, the General Ledger development team consolidated it into a single server-side PL/SQL package. This design allows multiple forms to reuse consistent, cached logic when constructing Key Flexfield combinations, validating account entry, and rendering the correct segment prompts. The package remains applicable to both Oracle EBS 12.1.1 and 12.2.2, since the FND Flexfield APIs and the FND_ID_FLEX_SEGMENTS table structure are unchanged across these releases. The requested term "acr gazebo form" does not correspond to this package; no documented procedure or table reference within GL_FORMSINFO2 relates to an ACR or "gazebo" form, and the metadata confirms this object is strictly a General Ledger forms-support utility.

Key Procedures and Functions

  • GET_COA_INFO — Returns the descriptive attributes of a specified chart of accounts: segment delimiter, enabled segment count, segment order-by string, and the segment number, application column name, and display prompt for the natural account (GL_ACCOUNT), balancing (GL_BALANCING), and intercompany (GL_INTERCOMPANY) qualifiers. It relies on FND_FLEX_APIS and a cursor over FND_ID_FLEX_SEGMENTS.
  • GET_SOB_INFO — Retrieves set of books context information used by General Ledger forms when establishing the operating environment.
  • MULTI_ORG — Supports multi-organization (Multiple Reporting Currencies / multi-org) determination for the current form session.
  • INSTALL_INFO — Exposes installation-level configuration details derived from product group data.
  • GET_IEA_INFO — Supplies intercompany and inter-entity accounting parameter information.
  • GET_USAGE_INFO — Returns usage-related metadata for the calling form.
  • GET_BUSINESS_DAYS_PATTERN — Provides the business days pattern used by General Ledger for calendar-oriented processing.
  • IEA_DISABLED_SUBSIDIARY — Determines whether a subsidiary is disabled for intercompany accounting purposes.
  • GET_INDUSTRY_MESSAGE — Returns the industry-specific message associated with the current installation.

Tables Accessed

  • FND_ID_FLEX_SEGMENTS — The primary source for enabled segment definitions. GET_COA_INFO queries it by APPLICATION_ID (101 for General Ledger), ID_FLEX_CODE 'GL#', and ID_FLEX_NUM (the chart of accounts identifier) to count enabled segments and build ordering and prompt data.
  • FND_PRODUCT_GROUPS — Provides installation and product group context, supporting INSTALL_INFO and related environment lookups.
  • GL_IEA_SUBSIDIARIES — Supports intercompany / inter-entity subsidiary validation for IEA_DISABLED_SUBSIDIARY and GET_IEA_INFO.

Usage Notes

GL_FORMSINFO2 is invoked from Oracle Forms modules and supporting PL/SQL within the General Ledger application, typically during form initialization and account entry. It is classified as an OTHER API, meaning Oracle does not publish it as a supported public interface but expects it to remain internally consistent for form-level use. No other packages are documented as referencing it, so direct external dependencies are limited. Customers extending General Ledger should treat these procedures as internal and use supported Flexfield APIs (FND_FLEX_APIS) rather than calling GL_FORMSINFO2 directly, as procedure signatures and behavior are not guaranteed across patches.