Search Results check_address_upd

Overview

APPS.PER_AU_ADD_LEG_HOOK is an Oracle E-Business Suite legislative hook package body that implements address validation logic specific to the Australian (AU) localization within Oracle Human Resources. Its primary business function is to enforce country-specific address data requirements when an address record is created or modified. The package follows the EBS "legislation hook" design pattern, in which a generic framework procedure conditionally delegates to country-specific validation routines based on the address style and country values supplied at runtime. In the Australian localization, the hook validates that a state or region value is present whenever an address is recorded using the AU_GLB address style for the AU country. Validation failures are surfaced to the calling form through the standard HR message and error-raising utilities, producing a user-visible error rather than silently accepting incomplete data.

Key Procedures and Functions

• CHECK_ADDRESS — Declared as a private procedure, this is the core driver routine for address validation. It first determines whether the Oracle Human Resources product is installed with the AU legislation enabled; if not, it writes a trace message and returns without performing any validation. When the address style is AU_GLB and the country is AU, it verifies that the region (state) value is populated, raising the HR_AU_INVALID_STATE error if it is null. Because it is private, it is not intended to be called directly by external code.
• CHECK_ADDRESS_INS — A public procedure that serves as the hook entry point when an address is inserted. It delegates to CHECK_ADDRESS to perform the underlying validation.
• CHECK_ADDRESS_UPD — The documented counterpart used when an address is updated. It applies the same Australian validation logic to modification events, ensuring consistency between inserts and updates.

Tables Accessed

The package operates against the PER_ADDRESSES table via its APPS synonym. This table stores person and organization address records within Oracle Human Resources, including the style, country, and region/state attributes that the hook validates. The package does not directly manipulate data in this table; rather, it participates in the validation path that Oracle HR executes around DML operations on address records, ensuring the column values conform to Australian legislative requirements before the transaction is committed.

Usage Notes

PER_AU_ADD_LEG_HOOK is invoked automatically by the Oracle HR address maintenance framework rather than being called explicitly by end users. When a user creates or updates an address in the People or Organization forms, the framework routes the operation through the appropriate legislative hook, which is why CHECK_ADDRESS_INS and CHECK_ADDRESS_UPD are bound to the insert and update events respectively. The package is referenced by two other packages, consistent with its role as a delegated validation layer rather than a standalone API. Because the validation is gated on both product installation and the AU_GLB/AU style-country combination, the hook is effectively a no-op for non-Australian addresses. Developers troubleshooting address validation errors such as HR_AU_INVALID_STATE should inspect this package first, and any custom code extending Australian address rules should follow the same conditional pattern to avoid interfering with other localizations.