Search Results gmd_api_pub




Overview
Explore in AI Chat

Overview

GMD_API_PUB is a public PL/SQL API package body owned by the APPS schema in Oracle E-Business Suite release 12.1.1 and 12.2.2. It belongs to the Process Manufacturing (OPM) product family, where the GMD prefix denotes objects in the Process Manufacturing Systems module. In the ETRM object inventory the package is recorded with a status of VALID and carries a public (PUB) API classification, indicating that it is intended for external invocation by other application modules, forms, concurrent programs, and customer extensions rather than being restricted to internal use.

The package provides a centralized utility layer for standardized error handling and message raising across the Process Manufacturing APIs, together with a helper that establishes the correct application user context for a session. Functionally it acts as a wrapper around the Oracle Application Object Library (FND) message and API stack, allowing OPM APIs to emit consistent, translatable messages and to raise structured exceptions without duplicating boilerplate code in each calling program.

Key Procedures and Functions

The documented package exposes four program units:

  • LOG_MESSAGE — Records a message against the current session, providing the logging half of the API's error-reporting strategy. It allows an API to accumulate diagnostic or informational messages for later retrieval by the caller rather than aborting immediately.
  • RAISE — Raises an exception based on a message token, translating stored application messages into a PL/SQL exception suitable for propagation to the calling program.
  • RAISE2 — A companion raising routine that supports the two-argument message pattern used by many OPM APIs, enabling a message to be raised with an associated token or substitution value.
  • SET_USER_CONTEXT — Establishes the runtime user, responsibility, and application context for the session, ensuring that FND_GLOBAL, FND_MESSAGE, and FND_MSG_PUB resolve the correct user and language settings when the API is invoked outside a standard Forms or concurrent environment.

Tables Accessed

The documented table references are resolved through APPS synonyms:

  • GMD_RESULTS — the Process Manufacturing results table, used within the API's domain logic for retrieving or storing result records.
  • GMD_SPEC_RESULTS — the specification results table, accessed alongside GMD_RESULTS for quality and specification-related result data.
  • FND_APPLICATION — the Oracle Application Object Library application definition table, consulted during message resolution and user-context setup so that the correct application identifier and message dictionary entries are used.

Usage Notes

GMD_API_PUB is a low-level support package rather than a user-facing transaction API. It is typically invoked indirectly: the OPM public APIs and quality modules call LOG_MESSAGE, RAISE, and RAISE2 to report validation failures and unexpected conditions to their callers, while SET_USER_CONTEXT is used by custom PL/SQL code, integration scripts, and concurrent programs that need to initialize an APPS session before calling Process Manufacturing APIs.

The documented dependency list confirms this role. The package references FND_API, FND_APPLICATION, FND_GLOBAL, FND_MESSAGE, FND_MSG_PUB, FND_RESPONSIBILITY_VL, and WF_EVENT, and it is referenced by 51 other packages — a strong indication that it sits beneath much of the Process Manufacturing API layer. Any modification to its raising or context-setting behavior therefore propagates widely, and it should be treated as a shared infrastructure component when developing extensions on release 12.1.1 or 12.2.2.