Search Results reply_error

Overview

IGS_DA_XML_PKG is a PL/SQL package body owned by APPS in the Oracle E-Business Suite, classified under the generic "OTHER" API category. Its header comment dates the original authorship to March 2001 (Steven Hogan and Nimit Mankodi) and its last recorded revision to February 2006, indicating a long-lived component within the Student Systems (IGS) product family. The package belongs to the academic transcript and student data exchange area of EBS, where "DA" refers to the Degree Audit / transcript data aggregation layer that extracts student academic records and renders them as XML for downstream consumers.

The central business function is the assembly, submission and monitoring of student academic XML payloads. The package populates staging tables (SUA — Student Unit Attempt — and load tables), derives GPA and credit-point metrics from those staged rows, formats student and person demographic data, and then submits or answers an XML event through the ECX (e-Commerce XML) transaction framework. The reply_error concern that led to this object relates to error handling: when a downstream service returns a failure response, the package records the error code and message against the request and student rows rather than failing silently. This behaviour is evidenced by the change history entries referencing "write error report and launch a workflow," the addition of update_stdnts_err, and the revision of update_req_students to carry a p_error_code parameter.

Key Procedures and Functions

• POPULATE_SUA_TABLE and POPULATE_LOAD_TABLE — build the working student unit attempt and load/staging data used by subsequent extraction calls.
• GET_SUA_GPA_CP, GET_SUA_GPA_QP, GET_SUA_EARNED_CP, GET_SUA_ATTEMPTED_CP, GET_SUA_GRADE, GET_SUA_MARK, GET_SUA_RESULT_TYPE — the SUA metric family, returning per-unit-attempt grade points, quality points, earned and attempted credit points, grade, mark and result type for XML rendering.
• GET_CUM_GPA, GET_CUM_GPA_CP, GET_CUM_GPA_QP, GET_CUM_EARNED_CP, GET_CUM_ATTEMPTED_CP — cumulative counterparts supplying the running GPA and credit totals that appear on an academic transcript.
• GET_COURSE_ABBR_NUM — resolves the abbreviated course identifier.
• STUDENT_TYPE_LIST — returns the set of student classifications used to filter and label the extract.
• GET_UNIT_REPEATABLE — reads IGS_PS_UNIT_VER repeatability, behaviour corrected in the September 2003 PSP integration build.
• GET_PERSON_DETAILS — retrieves person and party data required in the student XML header.
• UPDATE_STDNTS_ERR — writes the error code and report message returned by the downstream process, and is the principal receptor for a "reply_error" style response.
• UPDATE_REQ_STUDENTS — updates request-to-student rows; revised (Nov 2004, Sep 2005, Dec 2006) to accept and safely handle a null error code before performing string operations.

Additional handling for pre-submission errors and event submission was added in 2003 and 2004, including a loop in Submit_Event with table updates carrying error_code, and removal of the workflow process call from igsdaxmlgen.wft.

Tables Accessed

• IGS_DA_REQ_STDNTS — the primary request/student staging table updated by UPDATE_REQ_STUDENTS and UPDATE_STDNTS_ERR.
• IGS_AS_GRD_SCH_GRADE — grade scheme values for the GET_SUA_* grade and mark functions.
• IGS_PR_ORG_STAT, IGS_PR_SPA_COMPLETE_INT, IGS_PR_STU_ACAD_STAT_INT — organisational and student academic standing interfaces used in the extract.
• IGS_PE_ALT_PERS_ID, IGS_PE_TYP_INSTANCES_ALL — person identifiers and type instances for person detail assembly.
• HZ_PARTIES, HZ_PARTY_SITES, FND_USER — TCA party data; note the suite-wide change from FND_USER.CUSTOMER_ID to PERSON_PARTY_ID documented April 2005.
• ECX_TRANSACTIONS, ECX_EXT_PROCESSES, ECX_TP_HEADERS, ECX_TP_DETAILS — the XML transaction framework that carries the generated payload and its response.
• FND_PROFILE_OPTIONS — profile lookups controlling behaviour such as single large versus per-student XML.

Usage Notes

IGS_DA_XML_PKG is not intended for direct end-user invocation. It is called by concurrent programs and workflow/event machinery that generate transcript or academic XML files, and is referenced by five other packages. The cursor added in January 2005 (c_ftr_val) and the March 2005 revision to igs_pr_cp_gpa.get_sua_all — which added uoo_id — govern whether a single consolidated XML or one file per student is produced. In 12.1.1 and 12.2.2 environments, customisations should treat UPDATE_STDNTS_ERR and UPDATE_REQ_STUDENTS as the supported points for persisting downstream error replies, and should expect null-safe handling of error codes.