Search Results ja_cn_no_data_found

Overview

The APPS.JA_CN_GSSM_EXP_PKG package body is an Oracle E-Business Suite database object that implements the GSSM Export utility for the CNAO (China National Accounting Office) project. As documented in the header comments, the package is used for "GSSM Export, for Enterprise and Public Sector in the CNAO Project." The source file, JACNGSEB.pls, carries a version header dated 2007/08/13, with the original package creation attributed to Andrew Liu on 05/17/2006.

In the context of Oracle EBS 12.1.1 and 12.2.2, this package sits within the JA_CN (China localizations) product family. Its role is to extract General Social Security/Statistical Management (GSSM) configuration data — specifically flex value descriptions and lookup value definitions — and make it available for export. This functionality supports statutory or regulatory reporting obligations applicable to Chinese enterprise and public sector organizations, allowing GSSM reference data to be produced externally in a structured form.

Key Procedures and Functions

The package body exposes exactly one documented procedure:

• GSSM_EXPORT — Declared as a PUBLIC procedure, this program exports GSSM data for Enterprise. It accepts an input parameter identifying the GSSM type (ENT for Enterprise or PUB for Public Sector) and returns standard concurrent program error and return codes. Internally it declares a cursor to retrieve all GSSM records, uses an exception handler (JA_CN_NO_DATA_FOUND) to deal with empty result sets, and records messages in local variables. Procedure-level debugging is instrumented through FND_LOG with the module prefix JA_CN_GSSM_EXP_PKG.

No other procedures or functions are documented within this package body.

Tables Accessed

The package references tables through APPS synonyms to resolve display and validation values required for the export output:

• FND_FLEX_VALUES_TL — This table stores the translated description (the DESCRIPTION column) of flexfield values. The procedure declares a variable typed on FND_FLEX_VALUES_TL.DESCRIPTION%TYPE and uses it to retrieve human-readable descriptions of GSSM flex values included in the export.
• FND_LOOKUP_VALUES — This table holds lookup code definitions and their meanings. It is read to obtain lookup values used during the export, such as mapping codes to their descriptive or decoded forms.

Both tables are read-only reference sources; the package performs no data modification against them.

Usage Notes

GSSM_EXPORT follows the standard concurrent program interface signature (errbuf OUT, retcode OUT, plus program-specific input parameters), indicating that it is designed to be registered and executed as an Oracle EBS concurrent program. Users typically submit it from the standard Submit Requests window or from a localization-specific concurrent program form, choosing the GSSM type (ENT or PUB) at submission time.

The ETRM metadata records that this package is referenced by one other package, meaning at least one additional JA_CN component may call GSSM_EXPORT programmatically rather than solely through the concurrent manager. The package may also be invoked from custom code that wraps the CNAO GSSM export process.

Because the internal cursor retrieves all GSSM records, the procedure raises a dedicated NO_DATA_FOUND exception when no GSSM data qualifies for the requested type. Callers and concurrent program administrators should therefore expect a controlled error message in that scenario rather than a partial or silent output.