Search Results mrp_log




Overview
Explore in AI Chat

Overview

MRP_UTIL is a utility package body owned by APPS in the Oracle E-Business Suite, classified under the ETRM API classification UTIL. It forms part of the Material Requirements Planning (MRP) module and provides a small set of reusable helper routines that other MRP-related packages invoke rather than duplicating common logic. The package consolidates three distinct utility responsibilities: conditional debug tracing, unconditional log and output file messaging for concurrent programs, and a lookup value translation function.

The package is a compile-safe, low-impact library. Every procedure and function wraps its body in a WHEN OTHERS THEN RETURN exception handler so that a failure inside a utility call can never abort the calling process. This defensive design is deliberate: the routines exist to support diagnostics and formatting, and their failure must remain silent so that the primary business logic continues unaffected.

Key Procedures and Functions

  • MRP_DEBUG — Writes a single line of text to the concurrent program log file only when the profile option MRP:Debug is set to Y. If the profile is not enabled, the procedure returns immediately without writing anything. This provides opt-in tracing controlled at the site or user level.
  • MRP_LOG — Writes a line of text to the log file unconditionally, regardless of the debug profile setting. Used for messages that must always be captured, such as milestone notifications and error reporting.
  • MRP_OUT — Writes a line of text to the concurrent program output file and appends a line terminator via FND_FILE.NEW_LINE. Suitable for report-style formatted output delivered to the user.
  • LOOKUP_DESC — A function returning the meaning (MEANING) for a given lookup type and lookup code, resolving values against the MFG_LOOKUPS table. Returns NULL when the code is null or when no match is found.

Tables Accessed

The only documented table reference is MFG_LOOKUPS, accessed through an APPS synonym. The LOOKUP_DESC function opens a cursor selecting MEANING filtered by LOOKUP_CODE and LOOKUP_TYPE. This is a read-only, single-row lookup that allows MRP routines to convert internal codes into user-facing descriptions. No insert, update, or delete activity is documented against any table. The remaining procedures write exclusively to the FND_FILE log and output buffers managed by the concurrent manager, not to database tables.

Usage Notes

MRP_UTIL is referenced by nine other APPS packages, confirming its role as a shared foundation library across MRP processing. It is typically invoked from PL/SQL code executing inside concurrent programs, where FND_FILE is populated and later retrieved by the concurrent manager. MRP_DEBUG is used during troubleshooting and support engagements, since enabling the MRP:Debug profile option activates trace output without code changes. MRP_LOG and MRP_OUT support standard concurrent program reporting and diagnostics. LOOKUP_DESC is called wherever a plan, exception, or report must display a lookup meaning rather than a raw code. Custom code in the MRP schema commonly calls these routines to achieve consistent logging and lookup behavior with delivered functionality.