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 ECX_DEBUG

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 1006: ecx_debug.pl (0, 'IGS', 'IGS_PROCEDURE_EXECUTION', 'PROCEDURE_NAME',g_pkg_name);

1002: update_request_status(p_batch_id);
1003: END IF;
1004:
1005: IF NOT (l_found) THEN
1006: ecx_debug.pl (0, 'IGS', 'IGS_PROCEDURE_EXECUTION', 'PROCEDURE_NAME',g_pkg_name);
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:

Line 1007: ecx_debug.pl (0, 'IGS', 'IGS_ERROR_MSG'||'Error Code =' || p_error_code ,'E: Unable to Update');

1003: END IF;
1004:
1005: IF NOT (l_found) THEN
1006: ecx_debug.pl (0, 'IGS', 'IGS_PROCEDURE_EXECUTION', 'PROCEDURE_NAME',g_pkg_name);
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');

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 1016: ecx_debug.pl(0,'IGS','IGS_ERROR_MSG - NO DATA','ERROR_MESSAGE',SQLERRM);

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
1020: ecx_debug.pl(0,'IGS','IGS_PROGRAM_ERROR','PROGRESS_LEVEL','IGS_DA_XML_PKG.UPDATE_REQ_STUDENTS');

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 1021: ecx_debug.pl(0,'IGS','IGS_ERROR_MSG - OTHERS','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:
1025: END;

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 1292: ecx_debug.pl (0, 'IGS', 'IGS_PROCEDURE_EXECUTION', 'PROCEDURE_NAME',g_pkg_name);

1288: update_request_status(p_batch_id);
1289: END IF;
1290:
1291: IF NOT (l_found) THEN
1292: ecx_debug.pl (0, 'IGS', 'IGS_PROCEDURE_EXECUTION', 'PROCEDURE_NAME',g_pkg_name);
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:

Line 1293: ecx_debug.pl (0, 'IGS', 'IGS_REPORT_UPDATE_FAILED','E: Unable to Update');

1289: END IF;
1290:
1291: IF NOT (l_found) THEN
1292: ecx_debug.pl (0, 'IGS', 'IGS_PROCEDURE_EXECUTION', 'PROCEDURE_NAME',g_pkg_name);
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');

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 1302: ecx_debug.pl(0,'IGS','IGS_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);

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
1306: ecx_debug.pl(0,'IGS','IGS_PROGRAM_ERROR','PROGRESS_LEVEL','IGS_DA_XML_PKG.UPDATE_REQ_STUDENTS');

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 1307: 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:
1311: END;

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 1399: ecx_debug.pl(0,'IGS','IGS_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);

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;
1403:

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 1469: ecx_debug.pl(0,'IGS','IGS_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);

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;
1473:

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 1630: wf_event.AddParameterToList(p_name=>'ECX_DEBUG_LEVEL',p_value=>l_debug_level

1626: wf_event.AddParameterToList(p_name=>'ECX_TRANSACTION_SUBTYPE',p_value=>l_trans_subtype
1627: ,p_parameterlist=>l_parameter_list);
1628: wf_event.AddParameterToList(p_name=>'ECX_PARTY_TYPE',p_value=>l_party_type
1629: ,p_parameterlist=>l_parameter_list);
1630: wf_event.AddParameterToList(p_name=>'ECX_DEBUG_LEVEL',p_value=>l_debug_level
1631: ,p_parameterlist=>l_parameter_list);
1632: -- Raise the Event without the message
1633: -- The Generate Function Callback will create the XML Document
1634: -- Also possible that an API might be called from here to

Line 1669: wf_event.AddParameterToList(p_name=>'ECX_DEBUG_LEVEL',p_value=>l_debug_level

1665: wf_event.AddParameterToList(p_name=>'ECX_TRANSACTION_SUBTYPE',p_value=>l_trans_subtype
1666: ,p_parameterlist=>l_parameter_list);
1667: wf_event.AddParameterToList(p_name=>'ECX_PARTY_TYPE',p_value=>l_party_type
1668: ,p_parameterlist=>l_parameter_list);
1669: wf_event.AddParameterToList(p_name=>'ECX_DEBUG_LEVEL',p_value=>l_debug_level
1670: ,p_parameterlist=>l_parameter_list);
1671: -- Raise the Event without the message
1672: -- The Generate Function Callback will create the XML Document
1673: -- Also possible that an API might be called from here to

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 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 2128: ECX_DEBUG.PUSH('BEFORE CALL TO SUBMIT_EVENT');

2124: /*
2125: now, check the count and directly call the
2126: submit_event else first launch the workflow to notify the error
2127: */
2128: ECX_DEBUG.PUSH('BEFORE CALL TO SUBMIT_EVENT');
2129: IF ctr_tbl = 0 THEN
2130: submit_event(p_batch_id);
2131: ELSE
2132: launch_notify_err_wf(p_batch_id);

Line 2137: ECX_DEBUG.POP('BEFORE CALL TO SUBMIT_EVENT');

2133: IF l_count_person_id <> ctr_tbl THEN
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 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;