Search Results write_message




Overview
Explore in AI Chat

Overview

IGS_DA_TRNS_IMP is a PL/SQL package body owned by APPS within the Oracle E-Business Suite product family for student systems, classified as a legacy integration/import utility. Its purpose is to import and process transcript and advanced-standing data into the student records schema. The package header and body signature open with PACKAGE BODY igs_da_trns_imp AS, and the header comment indicates a last revision of version 120.19 dated December 2005. The package coordinates a multi-step import cycle: resolving or creating a batch identifier, creating advanced-standing unit records, populating academic history records, deleting prior advanced-standing records, and finally marking the batch import as complete or failed. It also contains an internal error-notification routine that writes diagnostic text back to request and request-student tables when processing fails.

The user search for "notify_error" locates the internal procedure notify_error, declared with a private scope inside the package body. This procedure is the package's contained error-reporting mechanism, and it produces an HTML-formatted error report that is stored on the request-student row.

Key Procedures and Functions

  • CREATE_ACAD_HIST_REC — Creates academic history records, presumably by writing to the transcript and education tables from the imported transcript and advanced-standing interface data.
  • CREATE_ADV_STND_UNIT — Creates advanced-standing unit records, translating external or legacy unit details into the internal advanced-standing unit structures used for credit recognition.
  • CREATE_OR_GET_BATCH_ID — Resolves an existing batch identifier or creates a new one, so that all rows processed within a single import run are grouped and tracked consistently.
  • DELETE_ADV_STND_RECORDS — Removes previously existing advanced-standing records, typically invoked to avoid duplication before re-importing or re-processing a batch.
  • COMPLETE_IMPORT_PROCESS — Finalizes the import, marking the batch as successfully or unsuccessfully completed and driving overall status handling.

Two additional private helper routines, write_log and write_message, push diagnostic strings to the ECX debug stack and to FND_LOG at statement level. The internal notify_error procedure accepts a batch identifier, person/party identifier, program code, and message text. It builds an HTML error report wrapped in BODY tags, updates IGS_DA_RQST to set request_status to 'COMPLETE_ERROR', and updates IGS_DA_REQ_STDNTS with the report text and an error code constant, specifically 'REPLY_ERROR'.

Tables Accessed

The package references a set of APPS synonyms spanning student records, person, and legacy interface data.

Usage Notes

This package is a server-side utility rather than a form-bound API. It is typically invoked by concurrent programs or batch import routines that load transcript and advanced-standing data from legacy sources. Because the package is referenced by zero other packages and exposes private helpers such as notify_error, its callers invoke the documented procedures directly within a batch processing cycle. When processing fails, notify_error ensures the failure is surfaced to both the batch header (IGS_DA_RQST) and the individual student rows (IGS_DA_REQ_STDNTS), allowing end users to review the HTML error report and identify which person and program combination failed. Debug output is written conditionally using FND_LOG at statement level, so diagnostic tracing requires the appropriate log level to be enabled.