Search Results ap_web_utilities_pkg




Overview
Explore in AI Chat

Overview

AP_WEB_UTILITIES_PKG is a shared utility package within the Oracle Payables Internet Expenses (OIE/AP Web) module set, owned by APPS and classified in ETRM as OTHER. It provides the common infrastructure that the Internet Expenses application — the self-service expense entry, receipt capture, credit card, and approval flows — depends upon. Rather than implementing a single business transaction, the package supplies reusable services: logging and diagnostics, mobile-application detection for the OIE mobile channel, employee and currency lookup helpers, money formatting, justification handling for policy violations, receipt warning messages, and credit card enablement checks. Its header comment ($Header: apwxutlb.pls 120.19.12000000.4 2007/05/16) shows a long-lived, actively patched source unit, and ETRM records 83 documented procedures and functions, with the package referenced by 36 other packages — an indication of its role as a low-level dependency across the Expense reporting stack.

Key Procedures and Functions

  • GETISMOBILEAPP / ISMOBILEAPP — Determine whether the current responsibility is configured for the mobile OIE application. The boolean-returning variant caches the result into the package global GIsMobileApp; the numeric variant exists because BOOLEAN is not a valid SQL type and is called by oracle.apps.ap.oie.utility.OIEUtil. Version is derived from FND_RESPONSIBILITY, with exceptions routed through FND_MESSAGE and APP_EXCEPTION.
  • LOGEXCEPTION, LOGEVENT, LOGPROCEDURE, LOGSTATEMENT — Structured logging and debug tracing used throughout the AP Web codebase.
  • ADDEXPERROR / ADDEXPERRORNOTENCODED / DISPLAYEXCEPTION — Accumulate and present error text to the user, using the package constants C_OpenDelimit and C_CloseDelimit to delimit individual error fields and messages.
  • GETEMPLOYEEINFO — Retrieve employee attributes for the current expense user.
  • MAKEARRAY — Build PL/SQL arrays used by the OIE UI layer.
  • MONEYFORMAT / MONEYFORMAT2 — Format monetary amounts consistently for display in expense and receipt pages.
  • SETRECEIPTWARNINGERRORMESSAGE — Populate the warning shown when receipt entry rules are not satisfied (e.g., minimum calendar days, C_NumOfMinDaysInCal).
  • JUSTIFFLAGELEMENT / RETRIEVEJUSTIFFLAG / RETRIEVEJUSTIFFLAGINDEX — Manage justification text attached to policy-violation flags.
  • CURRENCYINFO / RETRIEVECURRENCYINDEX / POPULATECURRENCYARRAY — Resolve currency details and populate currency arrays for selection lists and conversion display.
  • Credit card enablement — A function (isCreditCardEnabled) returns whether a given employee has the credit card feature enabled.
  • Flexfield helpers — Constants C_InputObjectPrefix ('FLEX') and C_InputPseudoObjectPrefix ('PFLEX') support descriptive flexfield and pseudo-flexfield input object naming.

Tables Accessed

Usage Notes

AP_WEB_UTILITIES_PKG is an internal utility layer rather than a public business API. It is invoked primarily by the Oracle Internet Expenses OA Framework (OIE) pages, by the mobile OIE utility class OIEUtil through GETISMOBILEAPP, and by the 36 dependent packages identified in ETRM. Customizations that touch OIE expense entry, receipt validation, policy violation justification, or currency display commonly call the MONEYFORMAT, CURRENCYINFO, JUSTIFFLAGELEMENT, and logging routines. Because the mobile detection result is cached in the package global GIsMobileApp, the state persists for the duration of the session; callers should not assume re-evaluation of responsibility version within the same database session. Error handling consistently uses FND_MESSAGE with the SQLAP application and APP_EXCEPTION.RAISE_EXCEPTION, so callers should expect standard EBS error-stack behavior. Direct modification of the package body is not supported; extensions should be implemented in custom packages that call these documented utilities. Regarding the user's query on "NOI code size limits," no source line, procedure, or constraint in this package imposes or documents an NOI (Notification of Invoice / expense-related notification) code-length limit; any such restriction originates outside this package and should be confirmed against the specific form, DFF, or interface that consumes the code.