Search Results fa_exc_error




Overview
Explore in AI Chat

Overview

FA_SRVR_MSG is the server-side messaging and diagnostic utility package for Oracle Assets (Fixed Assets) in Oracle E-Business Suite 12.1.1 and 12.2.2. Its role is to provide a consistent, centralized mechanism through which Fixed Assets PL/SQL programs on the middle tier build, retain, and emit an in-memory message stack describing the outcome of their processing — including success statuses, known application errors, and unexpected database errors. The package delivers the standard EBS API conventions used across the application, defining the FA_RET_SUCCESS, FA_RET_ERROR, and FA_RET_UNEXPECTED constants, which are mapped directly to the values held in FND_API (G_RET_STS_SUCCESS, G_RET_STS_ERROR and G_RET_STS_UNEXP_ERROR), along with the FA_EXC_ERROR and FA_EXC_UNEXPECTED exceptions used by server-side callers to signal failure.

Key Procedures and Functions

The package exposes eight documented entry points. INIT_SERVER_MESSAGE is called by a server-side program to initialize the global message table and to read the PRINT_DEBUG user profile value into the FA_MSG_DEBUG global; the packaged constant FA_MSG_DEBUG defaults to 'NO' and the default FA_ERROR_LEVEL is 10. RESET_SERVER_MESSAGE clears all entries from the global API message table so that a subsequent call starts with an empty stack.

  • ADD_SQL_ERROR — Invoked from a WHEN OTHER exception handler to append the SQL error text (and the calling function name) to the message stack; it also resets the global message level to 1.
  • ADD_MESSAGE — Inserts a formatted message, at a caller-specified level, into the global message table.
  • GET_MESSAGE — Retrieves a message from the stack so the caller can inspect the accumulated diagnostic text.
  • SET_MESSAGE_LEVEL — Controls the verbosity threshold at which messages are retained and printed, allowing debug information to be suppressed in normal production runs and surfaced when troubleshooting.
  • DUMP_API_MESSAGES — Emits the entire accumulated message stack in one operation.
  • WRITE_MSG_LOG — Persists the message stack or individual messages to the log destination used for diagnostics.

Tables Accessed

The documented metadata does not list any base tables accessed through APPS synonyms. FA_SRVR_MSG is designed around a global in-memory PL/SQL API message table, which is populated by ADD_MESSAGE and ADD_SQL_ERROR and read by GET_MESSAGE and DUMP_API_MESSAGES during the lifetime of a session. No persistent Fixed Assets schema objects are registered as being read or written by the package.

Usage Notes

FA_SRVR_MSG is a foundational server-side utility rather than an end-user-facing component, and ETRM records it as being referenced by 189 other packages. It is therefore invoked indirectly by nearly every Fixed Assets server-side routine: callers begin with INIT_SERVER_MESSAGE, accumulate diagnostics via ADD_MESSAGE and ADD_SQL_ERROR, and close out by calling DUMP_API_MESSAGES or WRITE_MSG_LOG when an error must be reported to a form or concurrent program. SET_MESSAGE_LEVEL is the control point for turning message verbosity up or down, and is the object most frequently sought when developers investigate PRINT_DEBUG behaviour in Fixed Assets. Because the package is classified as an "OTHER" API in the APPS schema, custom code should adopt the same init/add/dump lifecycle rather than modifying the package itself; Freeze 1.0 conventions at 12.1.1 and 12.2.2 indicate the FA_RET_* constants and FA_EXC_* exceptions are stable public interfaces.