Search Results create_pl_location

Overview

APPS.PER_PL_LOCATION is a PL/SQL package body in Oracle E-Business Suite that supports address validation for the localized Polish (PL) address style within Oracle Human Resources. The package provides validation logic that is invoked during the creation and modification of locations whose address style is set to 'PL'. Its principal business purpose is to enforce data integrity rules specific to the Polish address format, ensuring that required combinations of address components are supplied before a location record is written or updated. The readme header identifies the file as pepllhla.pkb and records a version stamp dated 2006, and the object is owned by APPS with an API classification of OTHER, indicating it is an internal supporting package rather than a published public API.

Key Procedures and Functions

The package body documents three procedures. Notably, the search term "p_address_line_1" corresponds directly to the first parameter used throughout these procedures.

• CHECK_PL_LOCATION — The core validation routine. It accepts the address line attributes (such as p_address_line_1 and p_address_line_2) and enforces the Polish address rule that a street name must be entered when a street type is entered. If p_address_line_1 is populated while p_address_line_2 is null, the procedure calls hr_utility.set_message(800,'HR_PL_ST_NAME_NOT_SPEC') and then hr_utility.raise_error, returning the message "Street Name not specified" to the caller.
• CREATE_PL_LOCATION — Invoked during creation of a location. It first checks whether the Polish localization for Oracle Human Resources is installed using hr_utility.chk_product_install('Oracle Human Resources','PL') (added for GSI Bug 5472781). If PL is not installed it writes a trace message and returns immediately. If the incoming p_style equals 'PL', it delegates validation to CHECK_PL_LOCATION.
• UPDATE_PL_LOCATION — Performs the same installation check and style check as CREATE_PL_LOCATION, but is intended for the update path. When p_style is 'PL' it calls CHECK_PL_LOCATION with the supplied address line values.

Tables Accessed

The documented metadata lists no tables referenced through APPS synonyms for this package. Consistent with its role, PER_PL_LOCATION is a validation-only package: it does not insert, update, or query application tables directly. All persistence of the location record is handled by the calling process (typically the HR location form or the location API), while this package contributes only the Polish-specific rule checking and the HR product installation guard through hr_utility.

Usage Notes

PER_PL_LOCATION is an internal helper invoked indirectly, not a standalone API called by end users. It is referenced by two other packages, which act as the entry points that supply the address line parameters and the address style. It is most commonly reached when a user maintains an address of style 'PL' through the Oracle HRMS Location form, or when custom code creates/updates locations programmatically. Because CHECK_PL_LOCATION raises an HR error when p_address_line_1 is present without p_address_line_2, callers must be prepared to handle that exception. The chk_product_install guard ensures the validation is skipped harmlessly in environments where the Polish localization is not licensed or installed, making the package safe to invoke unconditionally across multi-country deployments on EBS 12.1.1 and 12.2.2.