Search Results attn_message

Overview

AP_APXVDLBL_XMLP_PKG is the packaged body associated with the Oracle E-Business Suite concurrent program that produces the Vendor Mailing Label report (APXVDLBL). The report generates printable mailing labels for suppliers and supplier sites, and the package supplies the initialization, lookup, and formatting logic that the Oracle Reports XML Publisher (XMLP) executable requires at runtime. It is owned by APPS and classified as an OTHER API, indicating that it is an internal implementation object rather than a supported public interface. In both 12.1.1 and 12.2.2 the package follows the standard XMLP report package pattern: a CUSTOM_INIT entry point that performs environment discovery and default substitution, a BEFOREREPORT trigger that validates initialization before the query executes, an AFTERREPORT trigger that releases resources, and formula columns that derive display values used by the label layout.

Key Procedures and Functions

• CUSTOM_INIT — The central initialization routine and the object most commonly referenced in searches. It populates package-level variables that drive report behavior. It reads the SORT_BY_ALTERNATE_FIELD flag from AP_SYSTEM_PARAMETERS (defaulting to 'N' on error), resolves the default country code to 'US' when unset, derives the country name from FND_TERRITORIES_VL, retrieves the attention-line text from the MAIL_LABEL_ATTN_MESSAGE lookup, and normalizes vendor type and site parameters to 'All' when null. It also sets the PAY_SITE flag based on the P_SITE parameter value ('Pay' or 'Non-Pay').
• BEFOREREPORT — Executes the FND SRWINIT concurrent request initialization and then calls CUSTOM_INIT. If CUSTOM_INIT does not return TRUE, it raises an init_failure exception, aborting the report before any data is fetched. Debug messages are emitted when p_debug_switch is 'y' or 'Y'.
• AFTERREPORT — The complementary trigger invoked after report execution; it performs cleanup of the initialization context established by the environment exit.
• C_ORDER_BYFORMULA — A formula column that constructs the ORDER BY clause string controlling the sequence in which mailing labels are emitted, honoring the alternate-field sort preference established during initialization.
• C_ADDRESS_CONCATENATEDFORMULA — A formula column that concatenates supplier address components into the single formatted block printed on each mailing label.

Tables Accessed

The only documented table reference is AP_SYSTEM_PARAMETERS, accessed through the APPS synonym. It is read during CUSTOM_INIT solely to obtain SORT_BY_ALTERNATE_FIELD, which determines whether labels are ordered by the supplier alternate name field or by the standard name. The lookup AP_LOOKUP_CODES supplies the configurable attention-line message text; FND_TERRITORIES_VL supplies the country short name corresponding to the default country code; and the FND profile option DEFAULT_COUNTRY provides the fallback value. All accesses are read-only; the package does not write to any table.

Usage Notes

This package is invoked exclusively by the APXVDLBL concurrent program when the report is submitted from the Payables responsibility or from the Standard Request Submission form. CUSTOM_INIT is not a public API and should not be called from custom code. Site-level behavior of the report is influenced through AP_SYSTEM_PARAMETERS and the MAIL_LABEL_ATTN_MESSAGE lookup so administrators can adjust sorting and the printed attention line without modifying code. Because the package is flagged noship in its header and is unsupported, any customization risks being overwritten during patching; the supported extension points remain the system parameter, the lookup, and the report parameters P_VENDOR_TYPE, P_SITE, and P_DEBUG_SWITCH.