Search Results validate_charcter_set

Overview

APPS.PER_ZA_USER_HOOK_PKG is the South Africa (ZA) legislative localization user hook package for Oracle Human Resources in Oracle E-Business Suite 12.1.1 and 12.2.2. Its purpose is to enforce country-specific statutory validation rules on person, assignment, address, and payment data as it is created or updated through the standard HR and Payroll flows. The package is classified under the ETRM as an "OTHER" API rather than a public transactional API, reflecting its role as an internal exit point invoked by the Oracle HR business logic rather than being called directly by customer code.

The central business requirement implemented here is the mandatory capture of statutory South African person information — most notably the Race attribute carried on the PER_INFORMATION4 descriptive flexfield segment — together with related identity, contact, organization, and payment validation checks. The package header comment explicitly notes that the race validation routine is called from the applicant, employee, contingent worker, and person validation entry points, confirming that the hook is wired into the core person-validation chain.

Key Procedures and Functions

The documented procedures fall into several functional groups:

• Person and worker validation: VALIDATE_PERSON, VALIDATE_APPLICANT, VALIDATE_EMPLOYEE, and VALIDATE_CWK are the entry points invoked by the respective HR person types. VALIDATE_PERSON is the general person-level hook, while the other three apply segment rules specific to applicants, employees, and contingent workers. These routines drive the race check against the PER_INFORMATION4 flexfield segment.
• Contact validation: VALIDATE_EMAIL_ID and VALIDATE_PHONE_NO apply format and content checks to electronic mail addresses and telephone numbers captured for the person.
• Assignment extras: VALIDATE_ASG_EXTRA_INFO, CREATE_ZA_ASSIGN_EXTRA_INFO, and UPDATE_ZA_ASSIGN_EXTRA_INFO validate, insert, and maintain South African assignment extra information records.
• Address and organization: VALIDATE_PERSON_ADDRESS, VALIDATE_LOCATION_EXTRA_INFO, VALIDATE_ORG_INFO, and VALIDATE_CHARCTER_SET enforce format, character-set, and organizational rules on address and location data.
• Payments: VALIDATE_UPDATE_PER_PAYMENT and VALIDATE_CREATE_PER_PAYMENT apply statutory checks when personal payment methods are created or updated.

Tables Accessed

The package reads and writes the following objects through APPS synonyms:

• PER_ALL_PEOPLE_F — the primary person record; the race value is read from the PER_INFORMATION4 DFF segment via HR_MULTI_MESSAGE checks.
• PER_PERSON_TYPES — queried to resolve the SYSTEM_PERSON_TYPE (APL, EMP, CWK) that determines which validation rules apply.
• PER_ALL_ASSIGNMENTS_F — assignment data validated alongside person records.
• PER_ASSIGNMENT_EXTRA_INFO — the South African assignment extra information table maintained by the create/update procedures.
• HR_ORGANIZATION_INFORMATION — organization-level legislative information supporting organization validation.
• PAY_PERSONAL_PAYMENT_METHODS_F — personal payment method records validated on create and update.

Usage Notes

PER_ZA_USER_HOOK_PKG is not intended for direct invocation by custom code. It is called by the Oracle HR person, assignment, and payroll validation framework — the package is referenced by five other packages within the EBS schema — and its procedures are invoked automatically during form-based data entry in the People, Assignment, and Personal Payment Method windows. It also takes effect on any API-driven insert or update of person or assignment data that passes through the standard HR validation chain. Because the race check depends on HR_MULTI_MESSAGE error handling, validation failures surface through the standard EBS messages framework rather than as raw exceptions. The package should be treated as a system-owned localization hook: modifications risk conflicting with Oracle patches, and the documented procedures should be treated as internal interfaces.