Results for “check_language”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

APPS.CZMLS is a client-side character set and language information utility package in Oracle E-Business Suite. Its package body, identified by the header identifier czmlsb.pls version 115.11 (last modified 2002/11/27), provides centralized constants and helper routines that allow the EBS middle tier to interpret the character set and locale information of a connected client — typically a Windows-based desktop session — and to reconcile that information with the Oracle database session's own NLS configuration.

In 12.1.1 and 12.2.2 the EBS technology stack relies on accurate knowledge of the client character set so that data entered through Java-based forms, character-mode forms, or other client interfaces is converted correctly between the client's native encoding and the database character set. CZMLS encapsulates the numeric Windows code-page identifiers and Windows language codes needed for this mapping, rather than scattering literal values throughout the code base. The package therefore supports multilingual deployments in which users may run clients configured for Japanese, Korean, Traditional Chinese, Cyrillic, Greek, Turkish, Hebrew, Arabic, or Western European locales. Despite the user search term "picerija vrsac zmaj jovina", which appears unrelated to EBS functionality, the object itself is a standard EBS internal utility and has no business-specific content.

Key Procedures and Functions

• SET_WINDOWS_CLIENT_INFO — Populates the package's cached client environment information, recording the Windows character set and language settings for the current session so that subsequent calls can reference them without repeated lookups.
• SET_ORACLE_CHARSET — Captures and stores the Oracle character set in effect for the session, providing the database-side counterpart to the Windows client character set.
• CLIENT_CHARSET — Returns the character set determined for the current client, allowing callers to perform encoding conversion or validation against the correct code page.
• CHECK_LANGUAGE — Validates the language setting against the available language definitions, enabling the package to confirm that requested or reported language codes are recognized.

The package additionally declares an internal variable current_client_charset and an extensive set of constants for Windows character sets (for example, cs_windows_japan 932, cs_windows_korea 949, cs_windows_taiwan 950, cs_windows_unicode 1200, cs_windows_windows_cyrillic 1251, cs_windows_windows_multilng_us 1252, cs_windows_greek 1253, cs_windows_turkish 1254, cs_windows_hebrew 1255, cs_windows_arabic 1256) and for Windows language codes (for example, l_arabic 1025, l_american 1033, l_greek, l_german, and the Castilian Spanish entry 0x040A).

Tables Accessed

The package reads the following objects through APPS synonyms:

• FND_LANGUAGES — the Oracle Applications installed-language table, used to validate language codes and to associate language settings with the appropriate NLS environment.
• V$NLS_PARAMETERS — the dynamic performance view exposing current NLS parameter values, used to determine the database character set and related session settings handled by SET_ORACLE_CHARSET.
• V$NLS_VALID_VALUES — the view of valid NLS parameter values, used when verifying that a requested language or character set corresponds to a supported NLS value.

No application data tables are modified; the package is read-only with respect to business data and operates purely on configuration and NLS metadata.

Usage Notes

CZMLS is an internal utility invoked by EBS framework code rather than directly by end users. It is most commonly called during client session initialization, when a forms session or Java client must advertise its character set and language to the middle tier, and during character-set conversion or validation logic in multilingual deployments. It may also be referenced by custom code that needs to compare a Windows client code page with the Oracle database character set. The package is not referenced by any other documented package in the ETRM inventory, which is consistent with it being a low-level helper consumed by the client runtime rather than by application-level APIs. Because it relies on V$NLS_PARAMETERS and V$NLS_VALID_VALUES, the invoking database user requires the privileges normally granted to the APPS schema in a standard EBS installation. The single global current_client_charset variable means its values are session-scoped and should not be relied upon across database sessions.