Search Results log_string

Overview

FUN_NET_UTIL is a utility package body owned by APPS and classified as a UTIL object within Oracle E-Business Suite 12.1.1 and 12.2.2. It belongs to the Financials (FUN) product family and consolidates two distinct areas of shared functionality: diagnostic logging wrappers around the FND_LOG subsystem and a currency rounding helper. The package exists to give Financials development and extension code a consistent, low-overhead way to emit runtime diagnostics and to round monetary amounts in accordance with the currency-specific rules defined in the application's setup data.

The header comment (revision 120.1, dated 2005/12/23, marked noship) indicates the package is an internal, unshipped utility that has been stable for many releases. With four documented procedures and functions and a single referenced table, it is a small but frequently reused building block referenced by six other packages.

Key Procedures and Functions

The ETRM metadata documents four program units in this package:

• LOG_UNEXPECTED_MSG — Writes an unexpected-error entry to the concurrent manager log and, when the current runtime logging level warrants it, emits an FND_LOG message at the unexpected level. It captures SQLCODE and SQLERRM as message tokens so that the underlying database error is preserved in the log. This procedure is intended for exception handlers that need to record unanticipated failures without aborting the calling process.
• LOG_MSG — A conditional wrapper around FND_LOG.MESSAGE. It forwards the message to the logging framework only when the supplied log level is at or above the current runtime level, and it accepts a flag controlling whether the caller's entry is removed from the logging stack.
• LOG_STRING — The string-oriented counterpart to LOG_MSG, wrapping FND_LOG.STRING under the same level-threshold test. This is the entry point associated with the search term "log_string" and is the method most commonly called by Financials code to emit free-text diagnostics.
• ROUND_CURRENCY — A function that returns a monetary amount rounded according to a currency's precision and minimum accountable unit. When no minimum accountable unit is defined, the amount is rounded to the currency's stored precision; otherwise, it is rounded to the nearest multiple of the minimum accountable unit. If the currency code is not found, the function returns NULL rather than raising an error.

Tables Accessed

The only documented table reference is to FND_CURRENCIES, accessed through an APPS synonym. The table is queried by ROUND_CURRENCY, which reads the precision and minimum_accountable_unit columns for the supplied currency code. These columns supply the Oracle Applications setup-defined rounding rules for each enabled currency, ensuring that Financials calculations honour the same conventions used elsewhere in the application. The logging procedures do not reference application tables; their output is directed to the FND logging framework and the concurrent request log file.

Usage Notes

FUN_NET_UTIL is an internal utility invoked from PL/SQL rather than from a user interface directly. Typical callers include concurrent programs, Oracle Forms client-side libraries executing server-side logic, and custom extensions that need to log progress or exceptions. The LOG_STRING and LOG_MSG procedures are generally placed at the start of diagnostic sections so that output is suppressed automatically when the runtime logging level is set above the supplied level, which keeps normal production logging overhead minimal. LOG_UNEXPECTED_MSG is typically used in the exception section of a program to record unhandled errors before control returns to the caller.

Because the package is marked noship, it should be treated as an internal Oracle implementation detail. Customizations may call it, but doing so carries the usual caveat that Oracle does not guarantee its signature across releases. Nothing in the documented metadata indicates dependence on global temporary tables, context-sensitive initialization, or concurrent-program-specific parameters, so the package can be invoked safely from any session with access to the APPS schema and FND_CURRENCIES.