eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_DA_XML_PKG dependencies on IGS_DA_XML_PKG

Line 1: PACKAGE BODY IGS_DA_XML_PKG AS

1: PACKAGE BODY IGS_DA_XML_PKG AS
2: /* $Header: IGSDA10B.pls 120.3 2006/02/09 01:30:24 ijeddy ship $ */
3: /***************************************************************************************************************
4:
5: Created By: Steven Hogan, Nimit Mankodi

Line 45: g_pkg_name CONSTANT VARCHAR2(30) := 'IGS_DA_XML_PKG';

41:
42: --
43: --
44: --
45: g_pkg_name CONSTANT VARCHAR2(30) := 'IGS_DA_XML_PKG';
46: PROCEDURE populate_sua_table
47: (
48: p_person_id IN igs_en_su_attempt.person_id%TYPE,
49: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,

Line 976: ecx_debug.push('IGS_DA_XML_PKG.UPDATE_STDNTS_ERR');

972:
973: l_found BOOLEAN := FALSE;
974:
975: BEGIN
976: ecx_debug.push('IGS_DA_XML_PKG.UPDATE_STDNTS_ERR');
977: x_return_status := 'S';
978:
979: get_person_details (p_person_id_code,p_person_id_code_type,l_person_id,l_person_number);
980:

Line 1011: ecx_debug.pop('IGS_DA_XML_PKG.UPDATE_REQ_STUDENTS');

1007: ecx_debug.pl (0, 'IGS', 'IGS_ERROR_MSG'||'Error Code =' || p_error_code ,'E: Unable to Update');
1008: x_return_status := 'E: Unable to Update';
1009: END IF;
1010:
1011: ecx_debug.pop('IGS_DA_XML_PKG.UPDATE_REQ_STUDENTS');
1012: -- Check if the error code updated successfully , else return status error.
1013: EXCEPTION
1014: WHEN NO_DATA_FOUND THEN
1015: ecx_debug.pl(0,'IGS','IGS_PROGRAM_ERROR','PROGRESS_LEVEL','IGS_DA_XML_PKG.UPDATE_REQ_STUDENTS');

Line 1015: ecx_debug.pl(0,'IGS','IGS_PROGRAM_ERROR','PROGRESS_LEVEL','IGS_DA_XML_PKG.UPDATE_REQ_STUDENTS');

1011: ecx_debug.pop('IGS_DA_XML_PKG.UPDATE_REQ_STUDENTS');
1012: -- Check if the error code updated successfully , else return status error.
1013: EXCEPTION
1014: WHEN NO_DATA_FOUND THEN
1015: ecx_debug.pl(0,'IGS','IGS_PROGRAM_ERROR','PROGRESS_LEVEL','IGS_DA_XML_PKG.UPDATE_REQ_STUDENTS');
1016: ecx_debug.pl(0,'IGS','IGS_ERROR_MSG - NO DATA','ERROR_MESSAGE',SQLERRM);
1017: ecx_debug.setErrorInfo(2,30,SQLERRM||' -IGS_DA_XML_PKG.UPDATE_REQ_STUDENTS');
1018: x_return_status := 'E: UPDATE FAILED';
1019: WHEN OTHERS THEN

Line 1017: ecx_debug.setErrorInfo(2,30,SQLERRM||' -IGS_DA_XML_PKG.UPDATE_REQ_STUDENTS');

1013: EXCEPTION
1014: WHEN NO_DATA_FOUND THEN
1015: ecx_debug.pl(0,'IGS','IGS_PROGRAM_ERROR','PROGRESS_LEVEL','IGS_DA_XML_PKG.UPDATE_REQ_STUDENTS');
1016: ecx_debug.pl(0,'IGS','IGS_ERROR_MSG - NO DATA','ERROR_MESSAGE',SQLERRM);
1017: ecx_debug.setErrorInfo(2,30,SQLERRM||' -IGS_DA_XML_PKG.UPDATE_REQ_STUDENTS');
1018: x_return_status := 'E: UPDATE FAILED';
1019: WHEN OTHERS THEN
1020: ecx_debug.pl(0,'IGS','IGS_PROGRAM_ERROR','PROGRESS_LEVEL','IGS_DA_XML_PKG.UPDATE_REQ_STUDENTS');
1021: ecx_debug.pl(0,'IGS','IGS_ERROR_MSG - OTHERS','ERROR_MESSAGE',SQLERRM);

Line 1020: ecx_debug.pl(0,'IGS','IGS_PROGRAM_ERROR','PROGRESS_LEVEL','IGS_DA_XML_PKG.UPDATE_REQ_STUDENTS');

1016: ecx_debug.pl(0,'IGS','IGS_ERROR_MSG - NO DATA','ERROR_MESSAGE',SQLERRM);
1017: ecx_debug.setErrorInfo(2,30,SQLERRM||' -IGS_DA_XML_PKG.UPDATE_REQ_STUDENTS');
1018: x_return_status := 'E: UPDATE FAILED';
1019: WHEN OTHERS THEN
1020: ecx_debug.pl(0,'IGS','IGS_PROGRAM_ERROR','PROGRESS_LEVEL','IGS_DA_XML_PKG.UPDATE_REQ_STUDENTS');
1021: ecx_debug.pl(0,'IGS','IGS_ERROR_MSG - OTHERS','ERROR_MESSAGE',SQLERRM);
1022: ecx_debug.setErrorInfo(2,30,SQLERRM||' -IGS_DA_XML_PKG.UPDATE_REQ_STUDENTS');
1023: x_return_status := 'E: Other Exception';
1024:

Line 1022: ecx_debug.setErrorInfo(2,30,SQLERRM||' -IGS_DA_XML_PKG.UPDATE_REQ_STUDENTS');

1018: x_return_status := 'E: UPDATE FAILED';
1019: WHEN OTHERS THEN
1020: ecx_debug.pl(0,'IGS','IGS_PROGRAM_ERROR','PROGRESS_LEVEL','IGS_DA_XML_PKG.UPDATE_REQ_STUDENTS');
1021: ecx_debug.pl(0,'IGS','IGS_ERROR_MSG - OTHERS','ERROR_MESSAGE',SQLERRM);
1022: ecx_debug.setErrorInfo(2,30,SQLERRM||' -IGS_DA_XML_PKG.UPDATE_REQ_STUDENTS');
1023: x_return_status := 'E: Other Exception';
1024:
1025: END;
1026:

Line 1164: ecx_debug.push('IGS_DA_XML_PKG.UPDATE_REQ_STUDENTS');

1160: IF p_error_code IS NOT NULL THEN
1161: l_error_code := 'REPLY_ERROR';
1162: END IF;
1163:
1164: ecx_debug.push('IGS_DA_XML_PKG.UPDATE_REQ_STUDENTS');
1165: x_return_status := 'S';
1166:
1167: get_person_details ( RTRIM(LTRIM(p_person_id_code)), RTRIM(LTRIM(p_person_id_code_type)),l_person_id,l_person_number);
1168:

Line 1297: ecx_debug.pop('IGS_DA_XML_PKG.UPDATE_REQ_STUDENTS');

1293: ecx_debug.pl (0, 'IGS', 'IGS_REPORT_UPDATE_FAILED','E: Unable to Update');
1294: x_return_status := 'E: Unable to Update';
1295: END IF;
1296:
1297: ecx_debug.pop('IGS_DA_XML_PKG.UPDATE_REQ_STUDENTS');
1298: -- Check if the update is successfull , else return status error.
1299: EXCEPTION
1300: WHEN NO_DATA_FOUND THEN
1301: ecx_debug.pl(0,'IGS','IGS_PROGRAM_ERROR','PROGRESS_LEVEL','IGS_DA_XML_PKG.UPDATE_REQ_STUDENTS');

Line 1301: ecx_debug.pl(0,'IGS','IGS_PROGRAM_ERROR','PROGRESS_LEVEL','IGS_DA_XML_PKG.UPDATE_REQ_STUDENTS');

1297: ecx_debug.pop('IGS_DA_XML_PKG.UPDATE_REQ_STUDENTS');
1298: -- Check if the update is successfull , else return status error.
1299: EXCEPTION
1300: WHEN NO_DATA_FOUND THEN
1301: ecx_debug.pl(0,'IGS','IGS_PROGRAM_ERROR','PROGRESS_LEVEL','IGS_DA_XML_PKG.UPDATE_REQ_STUDENTS');
1302: ecx_debug.pl(0,'IGS','IGS_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
1303: ecx_debug.setErrorInfo(2,30,SQLERRM||' -IGS_DA_XML_PKG.UPDATE_REQ_STUDENTS');
1304: x_return_status := 'E: UPDATE FAILED';
1305: WHEN OTHERS THEN

Line 1303: ecx_debug.setErrorInfo(2,30,SQLERRM||' -IGS_DA_XML_PKG.UPDATE_REQ_STUDENTS');

1299: EXCEPTION
1300: WHEN NO_DATA_FOUND THEN
1301: ecx_debug.pl(0,'IGS','IGS_PROGRAM_ERROR','PROGRESS_LEVEL','IGS_DA_XML_PKG.UPDATE_REQ_STUDENTS');
1302: ecx_debug.pl(0,'IGS','IGS_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
1303: ecx_debug.setErrorInfo(2,30,SQLERRM||' -IGS_DA_XML_PKG.UPDATE_REQ_STUDENTS');
1304: x_return_status := 'E: UPDATE FAILED';
1305: WHEN OTHERS THEN
1306: ecx_debug.pl(0,'IGS','IGS_PROGRAM_ERROR','PROGRESS_LEVEL','IGS_DA_XML_PKG.UPDATE_REQ_STUDENTS');
1307: ecx_debug.pl(0,'IGS','IGS_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);

Line 1306: ecx_debug.pl(0,'IGS','IGS_PROGRAM_ERROR','PROGRESS_LEVEL','IGS_DA_XML_PKG.UPDATE_REQ_STUDENTS');

1302: ecx_debug.pl(0,'IGS','IGS_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
1303: ecx_debug.setErrorInfo(2,30,SQLERRM||' -IGS_DA_XML_PKG.UPDATE_REQ_STUDENTS');
1304: x_return_status := 'E: UPDATE FAILED';
1305: WHEN OTHERS THEN
1306: ecx_debug.pl(0,'IGS','IGS_PROGRAM_ERROR','PROGRESS_LEVEL','IGS_DA_XML_PKG.UPDATE_REQ_STUDENTS');
1307: ecx_debug.pl(0,'IGS','IGS_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
1308: ecx_debug.setErrorInfo(2,30,SQLERRM||' -IGS_DA_XML_PKG.UPDATE_REQ_STUDENTS');
1309: x_return_status := 'E: Other Exception';
1310:

Line 1308: ecx_debug.setErrorInfo(2,30,SQLERRM||' -IGS_DA_XML_PKG.UPDATE_REQ_STUDENTS');

1304: x_return_status := 'E: UPDATE FAILED';
1305: WHEN OTHERS THEN
1306: ecx_debug.pl(0,'IGS','IGS_PROGRAM_ERROR','PROGRESS_LEVEL','IGS_DA_XML_PKG.UPDATE_REQ_STUDENTS');
1307: ecx_debug.pl(0,'IGS','IGS_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
1308: ecx_debug.setErrorInfo(2,30,SQLERRM||' -IGS_DA_XML_PKG.UPDATE_REQ_STUDENTS');
1309: x_return_status := 'E: Other Exception';
1310:
1311: END;
1312:

Line 1343: ecx_debug.push('IGS_DA_XML_PKG.INSERT_GPA');

1339: AND drs.person_id = l_person_id
1340: AND ((drs.program_major_code = RTRIM(LTRIM(p_program_code))) OR (drs.program_code = RTRIM(LTRIM(p_program_code))));
1341:
1342: BEGIN
1343: ecx_debug.push('IGS_DA_XML_PKG.INSERT_GPA');
1344: x_return_status := 'S';
1345:
1346: get_person_details ( RTRIM(LTRIM(p_person_id_code)), RTRIM(LTRIM(p_person_id_code_type)),l_person_id,l_person_number);
1347:

Line 1395: ecx_debug.pop('IGS_DA_XML_PKG.INSERT_GPA');

1391: 1,
1392: SYSDATE,
1393: NULL);
1394:
1395: ecx_debug.pop('IGS_DA_XML_PKG.INSERT_GPA');
1396: EXCEPTION
1397: WHEN OTHERS THEN
1398: ecx_debug.pl(0,'IGS','IGS_PROGRAM_ERROR','PROGRESS_LEVEL','IGS_DA_XML_PKG.INSERT_GPA');
1399: ecx_debug.pl(0,'IGS','IGS_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);

Line 1398: ecx_debug.pl(0,'IGS','IGS_PROGRAM_ERROR','PROGRESS_LEVEL','IGS_DA_XML_PKG.INSERT_GPA');

1394:
1395: ecx_debug.pop('IGS_DA_XML_PKG.INSERT_GPA');
1396: EXCEPTION
1397: WHEN OTHERS THEN
1398: ecx_debug.pl(0,'IGS','IGS_PROGRAM_ERROR','PROGRESS_LEVEL','IGS_DA_XML_PKG.INSERT_GPA');
1399: ecx_debug.pl(0,'IGS','IGS_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
1400: ecx_debug.setErrorInfo(2,30,SQLERRM||' -IGS_DA_XML_PKG.INSERT_GPA');
1401: x_return_status := 'E: Other Exception';
1402: END;

Line 1400: ecx_debug.setErrorInfo(2,30,SQLERRM||' -IGS_DA_XML_PKG.INSERT_GPA');

1396: EXCEPTION
1397: WHEN OTHERS THEN
1398: ecx_debug.pl(0,'IGS','IGS_PROGRAM_ERROR','PROGRESS_LEVEL','IGS_DA_XML_PKG.INSERT_GPA');
1399: ecx_debug.pl(0,'IGS','IGS_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
1400: ecx_debug.setErrorInfo(2,30,SQLERRM||' -IGS_DA_XML_PKG.INSERT_GPA');
1401: x_return_status := 'E: Other Exception';
1402: END;
1403:
1404: PROCEDURE insert_program_completion

Line 1428: ecx_debug.push('IGS_DA_XML_PKG.INSERT_DEGREE_COMPLETION');

1424: AND drs.person_id = l_person_id
1425: AND ((drs.program_major_code = RTRIM(LTRIM(p_program_code))) OR (drs.program_code = RTRIM(LTRIM(p_program_code))));
1426:
1427: BEGIN
1428: ecx_debug.push('IGS_DA_XML_PKG.INSERT_DEGREE_COMPLETION');
1429: x_return_status := 'S';
1430:
1431: get_person_details ( RTRIM(LTRIM(p_person_id_code)), RTRIM(LTRIM(p_person_id_code_type)),l_person_id,l_person_number);
1432:

Line 1464: ecx_debug.pop('IGS_DA_XML_PKG.INSERT_DEGREE_COMPLETION');

1460: SYSDATE,
1461: NULL);
1462: END IF;
1463:
1464: ecx_debug.pop('IGS_DA_XML_PKG.INSERT_DEGREE_COMPLETION');
1465:
1466: EXCEPTION
1467: WHEN OTHERS THEN
1468: ecx_debug.pl(0,'IGS','IGS_PROGRAM_ERROR','PROGRESS_LEVEL','IGS_DA_XML_PKG.INSERT_PROGRAM_COMPLETION');

Line 1468: ecx_debug.pl(0,'IGS','IGS_PROGRAM_ERROR','PROGRESS_LEVEL','IGS_DA_XML_PKG.INSERT_PROGRAM_COMPLETION');

1464: ecx_debug.pop('IGS_DA_XML_PKG.INSERT_DEGREE_COMPLETION');
1465:
1466: EXCEPTION
1467: WHEN OTHERS THEN
1468: ecx_debug.pl(0,'IGS','IGS_PROGRAM_ERROR','PROGRESS_LEVEL','IGS_DA_XML_PKG.INSERT_PROGRAM_COMPLETION');
1469: ecx_debug.pl(0,'IGS','IGS_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
1470: ecx_debug.setErrorInfo(2,30,SQLERRM||' -IGS_DA_XML_PKG.INSERT_PROGRAM_COMPLETION');
1471: x_return_status := 'E: Other Exception';
1472: END;

Line 1470: ecx_debug.setErrorInfo(2,30,SQLERRM||' -IGS_DA_XML_PKG.INSERT_PROGRAM_COMPLETION');

1466: EXCEPTION
1467: WHEN OTHERS THEN
1468: ecx_debug.pl(0,'IGS','IGS_PROGRAM_ERROR','PROGRESS_LEVEL','IGS_DA_XML_PKG.INSERT_PROGRAM_COMPLETION');
1469: ecx_debug.pl(0,'IGS','IGS_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
1470: ecx_debug.setErrorInfo(2,30,SQLERRM||' -IGS_DA_XML_PKG.INSERT_PROGRAM_COMPLETION');
1471: x_return_status := 'E: Other Exception';
1472: END;
1473:
1474: /*****************************************************************/

Line 1720: ecx_debug.push('IGS_DA_XML_PKG.PROCESS_REPLY_FAILURE');

1716: l_error_message VARCHAR2(20);
1717:
1718: BEGIN
1719: SAVEPOINT PROCESS_REPLY_FAILURE;
1720: ecx_debug.push('IGS_DA_XML_PKG.PROCESS_REPLY_FAILURE');
1721: FOR v_dummy IN c_request_status LOOP
1722: UPDATE igs_da_rqst
1723: SET request_status = 'ERROR'
1724: WHERE CURRENT OF c_request_status;

Line 1754: ecx_debug.pop('IGS_DA_XML_PKG.PROCESS_REPLY_FAILURE');

1750:
1751: ELSE
1752: ECX_ACTIONS.SET_ERROR_EXIT_PROGRAM(l_error_type,l_error_code,l_error_message);
1753: END IF;
1754: ecx_debug.pop('IGS_DA_XML_PKG.PROCESS_REPLY_FAILURE');
1755: END;
1756:
1757: PROCEDURE update_request_status
1758: (p_batch_id IN igs_da_req_stdnts.batch_id%TYPE

Line 1855: ECX_DEBUG.PUSH('IGS_DA_XML_PKG.LAUNCH_NOTIFY_ERR_WF');

1851: FROM igs_da_rqst
1852: WHERE batch_id = cp_batch_id);
1853: l_req VARCHAR2(2000);
1854: BEGIN
1855: ECX_DEBUG.PUSH('IGS_DA_XML_PKG.LAUNCH_NOTIFY_ERR_WF');
1856: l_item_key := 'DANTFERR'||TO_CHAR(SYSDATE,'YYYYMMDDHH24MISSSSS');
1857: OPEN c_req(p_batch_id);
1858: FETCH c_req INTO l_req;
1859: CLOSE c_req;

Line 1877: ECX_DEBUG.POP('IGS_DA_XML_PKG.LAUNCH_NOTIFY_ERR_WF');

1873: avalue => l_req);
1874:
1875: WF_ENGINE.StartProcess (ItemType => 'DANTFERR',
1876: ItemKey => l_item_key);
1877: ECX_DEBUG.POP('IGS_DA_XML_PKG.LAUNCH_NOTIFY_ERR_WF');
1878: EXCEPTION
1879: WHEN OTHERS THEN
1880: WF_CORE.Context('IGS_DA_XML_PKG','launch_notify_err_wf',l_item_key);
1881: RAISE;

Line 1880: WF_CORE.Context('IGS_DA_XML_PKG','launch_notify_err_wf',l_item_key);

1876: ItemKey => l_item_key);
1877: ECX_DEBUG.POP('IGS_DA_XML_PKG.LAUNCH_NOTIFY_ERR_WF');
1878: EXCEPTION
1879: WHEN OTHERS THEN
1880: WF_CORE.Context('IGS_DA_XML_PKG','launch_notify_err_wf',l_item_key);
1881: RAISE;
1882: END launch_notify_err_wf;
1883:
1884: PROCEDURE pre_submit_event (p_batch_id IN igs_da_req_stdnts.batch_id%TYPE) IS

Line 1986: ECX_DEBUG.PUSH('IGS_DA_XML_PKG.PRE_SUBMIT_EVENT');

1982: RETURN v_get_pers;
1983: END get_person;
1984:
1985: BEGIN
1986: ECX_DEBUG.PUSH('IGS_DA_XML_PKG.PRE_SUBMIT_EVENT');
1987: -- initialize the variable
1988: ctr_tbl:=0;
1989: pid_exists:='N';
1990: l_pcode_qual_exists:='N';

Line 2138: ECX_DEBUG.POP('IGS_DA_XML_PKG.PRE_SUBMIT_EVENT');

2134: submit_event(p_batch_id);
2135: END IF;
2136: END IF; -- IF v_person_tbl.COUNT = 0 THEN
2137: ECX_DEBUG.POP('BEFORE CALL TO SUBMIT_EVENT');
2138: ECX_DEBUG.POP('IGS_DA_XML_PKG.PRE_SUBMIT_EVENT');
2139: END pre_submit_event;
2140:
2141: END IGS_DA_XML_PKG;

Line 2141: END IGS_DA_XML_PKG;

2137: ECX_DEBUG.POP('BEFORE CALL TO SUBMIT_EVENT');
2138: ECX_DEBUG.POP('IGS_DA_XML_PKG.PRE_SUBMIT_EVENT');
2139: END pre_submit_event;
2140:
2141: END IGS_DA_XML_PKG;