Search Results retrieve_party_display_name

Overview

APPS.PON_LOCALE_PKG is a locale-aware name formatting utility within the Oracle E-Business Suite procurement (PON) schema. Its principal business function is to produce a person's display name formatted according to the locale and name-format conventions of the party who will receive a document or notification. In Oracle Purchasing and iProcurement, communications such as e-mail notifications, approval routings, and printed documents are addressed to individual parties, and the addressing convention varies by country and language. Rather than requiring each calling module to derive a display name, PON_LOCALE_PKG centralizes that logic.

The header comment embedded in the package identifies the purpose directly: the procedure takes a first name and last name of a person together with the desired name format and the party id of the recipient, and formats the name according to the locale settings of the receiving party. This makes the package a presentation-layer compatibility utility for internationalized Oracle EBS deployments at 12.1.1 and 12.2.2.

Key Procedures and Functions

• RETRIEVE_PARTY_DISPLAY_NAME — The central documented routine, and the object most commonly sought by developers searching on that name. It accepts individual name components (first, last, middle, prefix, suffix), a party identifier, a requested name format code, and a language, and returns the assembled display name along with a status code and an exception message. When a caller supplies incomplete name components, the procedure attempts to derive the missing values from HZ_PARTIES using the party id; if the party id is also absent, it returns an error status with an explanatory message. Interior formatting decisions — spacing and comma placement around prefix, first name, middle name, and suffix — are resolved through local variables and DUAL-based expressions so that the result matches the locale conventions encoded in the name format.
• PARTY_DISPLAY_NAME — A companion entry point exposed for producing the display name of a party in the same locale-aware manner. It serves callers that already resolve party context and simply require the formatted string.
• GET_PARTY_DISPLAY_NAME — A retrieval-style entry point over the same formatting logic, allowing requesters to obtain a party display name without duplicating the component-assembly rules.

The three exposed routines form a layered API: one low-level formatter operating on raw name components, and two convenience entry points oriented to party identifiers.

Tables Accessed

• HZ_PARTIES — The primary data source. Columns for person first name, last name, middle name, title, and name suffix are selected by party id when the caller does not provide complete name components. The package reads this table only; it does not modify party records.
• FND_LOOKUP_VALUES — Consulted to obtain the valid name-format and locale-related lookup codes that govern how components are ordered and punctuated.
• DUAL — Used for expression evaluation, notably the NVL2-based derivation of separator characters such as spaces and commas between name components.

Usage Notes

PON_LOCALE_PKG is an internal API classified as OTHER, and ETRM records nine other packages referencing it, indicating that it is consumed by supplier- and buyer-facing communication logic rather than invoked directly by end users. In practice it is called from PL/SQL packages and workflows that generate e-mail notifications, approval messages, and document text addressed to a named party.

Customizations should invoke RETRIEVE_PARTY_DISPLAY_NAME rather than reproducing name-assembly logic, because the package encapsulates locale-specific ordering and punctuation. Callers must always check the returned status and handle the documented error condition where neither name components nor a valid party id are available. Because the underlying name-format lookups are locale-driven, behavior depends on the language and format codes configured in the instance, and testing should cover multiple locales when extending any calling code.