Search Results igs_ad_offresp_err_s

Overview

The APPS.IGS_AD_IMP_OFF_RESP_DATA package body belongs to the Oracle E-Business Suite (EBS) Student System / Advanced Degree (AD) product family. It is a PL/SQL implementation package designed to import and process the responses received from external offering or admissions institutions against offers extended to prospective applicants. In institutional practice, offers of admission or offers of a place on a program are dispatched to applicants, and their acceptances, declines, or deferrals are returned (frequently from third-party or partner institutions and clearing systems) in batch form. This package provides the server-side engine that ingests that inbound response data, validates it against the applicant and admissions configuration records, and persists it to the appropriate staging and transactional tables.

The presence of the table IGS_AD_OFFRESP_ERR and its sequence IGS_AD_OFFRESP_ERR_S in the dependency list confirms that the package is responsible not only for successful import but also for error capture. The package's status is documented as VALID, and it is classified as a custom/other (OTHER) API rather than a standard public interface, indicating it is intended primarily for internal invocation by concurrent programs and batch logic.

Key Procedures and Functions

Only one procedure is documented for this package body:

• IMP_OFF_RESP — The core import routine. It orchestrates the processing of inbound offer response data, driving validation, error detection, and writing of results. Errors encountered during processing are written to the IGS_AD_OFFRESP_ERR table, with sequence values drawn from IGS_AD_OFFRESP_ERR_S. Because the package body is the implementation of the public specification, IMP_OFF_RESP is the entry point exposed to concurrent processing and dependent packages.

The metadata does not document parameter lists, and they are not reproduced here. The procedure should be treated as a batch-oriented driver rather than a fine-grained row-level API.

Tables Accessed

The documented table dependencies, resolved through APPS synonyms, are as follows:

• IGS_AD_OFFRESP_BATCH — Identifies and controls the inbound response batch being imported.
• IGS_AD_OFFRESP_INT — The interface/staging table holding the raw inbound offer response records prior to validation and transfer.
• IGS_AD_OFFRESP_ERR — The error table that records individual records rejected during import; populated using IGS_AD_OFFRESP_ERR_S.
• IGS_AD_APPL_ALL — The applicant/admissions application base table, used to resolve and update the application against which a response is received.
• IGS_AD_PRD_AD_PRC_CA — Links program admission processing to admission categories/curricula, used to validate the response against the applicant's intended program.
• IGS_AD_PS_APPL_INST_ALL — The application instance table, updated to reflect the outcome of the applicant's response.
• IGS_CA_INST_REL and IGS_CA_TYPE — Institution/calendaring reference data used to validate institutional and type context.
• PLITBLM — The standard PL/SQL table type used internally for array processing within the package.

Usage Notes

The package is typically invoked from a concurrent program that submits the offer response import, most commonly from the Advanced Degree admissions concurrent request set. It leverages standard EBS utilities including FND_FILE for log/output, FND_MESSAGE and IGS_GE_MSG_STACK for message handling, FND_REQUEST for submitting downstream requests, and FND_GLOBAL/FND_STATS for session context and statistics gathering.

Because IGS_AD_IMP_OFF_RESP_DATA is not referenced by any other database object, it is effectively a terminal worker: external orchestration (concurrent manager, custom jobs, or manual SQL*Plus execution) drives it. Users tracing the error-side table IGS_AD_OFFRESP_ERR_S should understand that this sequence is populated exclusively through error-recording activity of IMP_OFF_RESP, and reviewing IGS_AD_OFFRESP_ERR alongside IGS_AD_OFFRESP_BATCH will reveal which inbound records failed validation and why.