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_TRNS_IMP dependencies on ECX_DEBUG

Line 17: ecx_debug.push (l_debug_str);

13: PROCEDURE write_log (l_debug_str IN VARCHAR2, l_label IN VARCHAR2)
14: AS
15: l_prog_label VARCHAR2 (100) := 'igs.plsql.igs_da_trns_imp';
16: BEGIN
17: ecx_debug.push (l_debug_str);
18: ecx_debug.pop (l_debug_str);
19:
20: IF fnd_log.test (fnd_log.level_statement, l_prog_label)
21: THEN

Line 18: ecx_debug.pop (l_debug_str);

14: AS
15: l_prog_label VARCHAR2 (100) := 'igs.plsql.igs_da_trns_imp';
16: BEGIN
17: ecx_debug.push (l_debug_str);
18: ecx_debug.pop (l_debug_str);
19:
20: IF fnd_log.test (fnd_log.level_statement, l_prog_label)
21: THEN
22: fnd_log.string_with_context (fnd_log.level_statement,

Line 53: ecx_debug.push ('IGS_DA_TRNS_IMP.NOTIFY_ERROR');

49:
50: v_report_text VARCHAR2 (4000);
51: l_error_code VARCHAR2 (30) := 'REPLY_ERROR';
52: BEGIN
53: ecx_debug.push ('IGS_DA_TRNS_IMP.NOTIFY_ERROR');
54:
55: IF p_msg IS NOT NULL
56: THEN
57: v_report_text :=

Line 80: ecx_debug.pop ('IGS_DA_TRNS_IMP.NOTIFY_ERROR');

76: END IF;
77:
78: write_message ('Calling IGS_DA_TRNS_IMP.NOTIFY_ERROR ' || p_msg);
79: igs_da_xml_pkg.process_reply_failure (p_batch_id);
80: ecx_debug.pop ('IGS_DA_TRNS_IMP.NOTIFY_ERROR');
81: EXCEPTION
82: WHEN OTHERS
83: THEN
84: write_message ('Error occurred. See log for Details' || sqlerrm);

Line 116: ecx_debug.push ('IGS_DA_TRNS_IMP.VALIDATE_ACADHIS');

112: AND oit.system_inst_type IN ('POST-SECONDARY', 'SECONDARY');
113:
114: c_val_inst_cd_rec c_val_inst_cd_non_uk_cur%ROWTYPE;
115: BEGIN
116: ecx_debug.push ('IGS_DA_TRNS_IMP.VALIDATE_ACADHIS');
117: -- log header
118: c_val_inst_cd_rec.row_id := NULL;
119:
120: --1. Institution Code

Line 167: ecx_debug.pop ('IGS_DA_TRNS_IMP.VALIDATE_ACADHIS');

163: END IF;
164:
165: p_error_code := NULL;
166: p_status := '1';
167: ecx_debug.pop ('IGS_DA_TRNS_IMP.VALIDATE_ACADHIS');
168: RETURN;
169: EXCEPTION
170: WHEN OTHERS
171: THEN

Line 172: ecx_debug.pop ('IGS_DA_TRNS_IMP.VALIDATE_ACADHIS');

168: RETURN;
169: EXCEPTION
170: WHEN OTHERS
171: THEN
172: ecx_debug.pop ('IGS_DA_TRNS_IMP.VALIDATE_ACADHIS');
173: write_message('ERROR ' || sqlerrm);
174: p_error_code := 'E518';
175: p_status := '3';
176: -- log detail

Line 202: ecx_debug.push ('IGS_DA_TRNS_IMP.CRC_PE_ACAD_HIST');

198: l_rowid VARCHAR2 (25);
199: l_prog_label VARCHAR2 (100)
200: := 'igs.plsql.igs_da_trns_imp';
201: BEGIN
202: ecx_debug.push ('IGS_DA_TRNS_IMP.CRC_PE_ACAD_HIST');
203: l_status := '1';
204: l_error_code := NULL;
205: l_error_text := NULL;
206: validate_acadhis (person_history_rec, l_error_code, l_status);

Line 283: ecx_debug.pop ('IGS_DA_TRNS_IMP.CRC_PE_ACAD_HIST');

279: );
280: END IF;
281:
282: person_history_rec.education_id := l_education_id;
283: ecx_debug.pop ('IGS_DA_TRNS_IMP.CRC_PE_ACAD_HIST');
284: EXCEPTION
285: WHEN OTHERS
286: THEN
287: ecx_debug.pop ('IGS_DA_TRNS_IMP.CRC_PE_ACAD_HIST');

Line 287: ecx_debug.pop ('IGS_DA_TRNS_IMP.CRC_PE_ACAD_HIST');

283: ecx_debug.pop ('IGS_DA_TRNS_IMP.CRC_PE_ACAD_HIST');
284: EXCEPTION
285: WHEN OTHERS
286: THEN
287: ecx_debug.pop ('IGS_DA_TRNS_IMP.CRC_PE_ACAD_HIST');
288: write_message('ERROR ' || sqlerrm);
289: -- ROLLBACK TO before_create_hist;
290: igs_ad_gen_016.extract_msg_from_stack (p_msg_at_index => l_msg_at_index,
291: p_return_status => l_return_status,

Line 375: ecx_debug.push ('IGS_DA_TRNS_IMP.PRC_PE_ACAD_HIST');

371:
372: l_error_code VARCHAR2 (10);
373: l_prog_label VARCHAR2 (100);
374: BEGIN
375: ecx_debug.push ('IGS_DA_TRNS_IMP.PRC_PE_ACAD_HIST');
376: l_prog_label := 'igs.plsql.igs_da_trns_imp.crc_pe_acad_hist';
377: write_log ( 'Entered prc_pe_acad_hist prev_institution_code='
378: || acad_hist_rec.prev_institution_code
379: || ' person_id ='

Line 415: ecx_debug.pop ('IGS_DA_TRNS_IMP.PRC_PE_ACAD_HIST');

411: ---
412: END IF;
413:
414: CLOSE c_dup_cur;
415: ecx_debug.pop ('IGS_DA_TRNS_IMP.PRC_PE_ACAD_HIST');
416: EXCEPTION
417: WHEN OTHERS
418: THEN
419: write_message('ERROR ' || sqlerrm);

Line 492: ecx_debug.push ('IGS_DA_TRNS_IMP.DELETE_ADV_STND_RECORDS');

488: WHERE unt.AV_STND_UNIT_ID = cp_AV_STND_UNIT_ID
489: FOR UPDATE NOWAIT;
490:
491: BEGIN
492: ecx_debug.push ('IGS_DA_TRNS_IMP.DELETE_ADV_STND_RECORDS');
493:
494: FOR l_edu_id IN c_edu_id
495: LOOP
496: -- delete transcript information

Line 550: ecx_debug.pop ('IGS_DA_TRNS_IMP.DELETE_ADV_STND_RECORDS');

546: NULL;
547: END;
548: END LOOP;
549:
550: ecx_debug.pop ('IGS_DA_TRNS_IMP.DELETE_ADV_STND_RECORDS');
551: EXCEPTION
552: WHEN OTHERS
553: THEN
554: write_message('ERROR ' || sqlerrm);

Line 580: ecx_debug.push ('IGS_DA_TRNS_IMP.CREATE_NEW_TRANSCRIPT_DETAILS');

576: ORDER BY NVL (system_default, 'A') DESC;
577:
578: l_transcript_source igs_ad_code_classes.code_id%TYPE;
579: BEGIN
580: ecx_debug.push ('IGS_DA_TRNS_IMP.CREATE_NEW_TRANSCRIPT_DETAILS');
581: l_transcript_id := NULL;
582:
583: BEGIN
584: -- insert academic history record or find the education id if one already exists

Line 638: ecx_debug.pop ('IGS_DA_TRNS_IMP.CREATE_NEW_TRANSCRIPT_DETAILS');

634: igs_ad_wf_001.transcript_entrd_event (p_trans_record.person_id,
635: p_trans_record.education_id,
636: l_transcript_id
637: );
638: ecx_debug.pop ('IGS_DA_TRNS_IMP.CREATE_NEW_TRANSCRIPT_DETAILS');
639: EXCEPTION
640: WHEN OTHERS
641: THEN
642: ecx_debug.pop ('IGS_DA_TRNS_IMP.CREATE_NEW_TRANSCRIPT_DETAILS');

Line 642: ecx_debug.pop ('IGS_DA_TRNS_IMP.CREATE_NEW_TRANSCRIPT_DETAILS');

638: ecx_debug.pop ('IGS_DA_TRNS_IMP.CREATE_NEW_TRANSCRIPT_DETAILS');
639: EXCEPTION
640: WHEN OTHERS
641: THEN
642: ecx_debug.pop ('IGS_DA_TRNS_IMP.CREATE_NEW_TRANSCRIPT_DETAILS');
643: write_message('ERROR ' || sqlerrm);
644: -- ROLLBACK TO before_create_transcript;
645: igs_ad_gen_016.extract_msg_from_stack (p_msg_at_index => l_msg_at_index,
646: p_return_status => l_return_status,

Line 720: ecx_debug.push ('IGS_DA_TRNS_IMP.UPDATE_TRANSCRIPT_DETAILS');

716:
717: dup_cur_rec c_dup_cur%ROWTYPE;
718: l_source igs_ad_code_classes.code_id%TYPE;
719: BEGIN
720: ecx_debug.push ('IGS_DA_TRNS_IMP.UPDATE_TRANSCRIPT_DETAILS');
721: l_transcript_id := NULL;
722: OPEN c_dup_cur;
723: FETCH c_dup_cur INTO dup_cur_rec;
724: CLOSE c_dup_cur;

Line 766: ecx_debug.pop ('IGS_DA_TRNS_IMP.UPDATE_TRANSCRIPT_DETAILS');

762: p_trans_record.transcript_id := dup_cur_rec.transcript_id;
763: write_log ('Update trans details',
764: 'igs.plsql.igs_da_trns_imp.update_transcript_details'
765: );
766: ecx_debug.pop ('IGS_DA_TRNS_IMP.UPDATE_TRANSCRIPT_DETAILS');
767: EXCEPTION
768: WHEN OTHERS
769: THEN
770: ecx_debug.pop ('IGS_DA_TRNS_IMP.UPDATE_TRANSCRIPT_DETAILS');

Line 770: ecx_debug.pop ('IGS_DA_TRNS_IMP.UPDATE_TRANSCRIPT_DETAILS');

766: ecx_debug.pop ('IGS_DA_TRNS_IMP.UPDATE_TRANSCRIPT_DETAILS');
767: EXCEPTION
768: WHEN OTHERS
769: THEN
770: ecx_debug.pop ('IGS_DA_TRNS_IMP.UPDATE_TRANSCRIPT_DETAILS');
771: write_message('ERROR ' || sqlerrm);
772: -- ROLLBACK TO before_update_transcript;
773: igs_ad_gen_016.extract_msg_from_stack (p_msg_at_index => l_msg_at_index,
774: p_return_status => l_return_status,

Line 833: ecx_debug.push ('IGS_DA_TRNS_IMP.UPDATE_TERM_UNIT_DETAILS');

829: AND unit = p_term_unitdtls_record.unit;
830:
831: dup_cur_rec c_dup_cur%ROWTYPE;
832: BEGIN
833: ecx_debug.push ('IGS_DA_TRNS_IMP.UPDATE_TERM_UNIT_DETAILS');
834: OPEN c_dup_cur;
835: FETCH c_dup_cur INTO dup_cur_rec;
836: CLOSE c_dup_cur;
837: l_msg_at_index := igs_ge_msg_stack.count_msg;

Line 860: ecx_debug.pop ('IGS_DA_TRNS_IMP.UPDATE_TERM_UNIT_DETAILS');

856: write_log ( 'igs_ad_term_unitdtls_pkg.update_row unit_details_id='
857: || p_term_unitdtls_record.unit_details_id,
858: 'igs.plsql.igs_da_trns_imp.update_term_unit_details'
859: );
860: ecx_debug.pop ('IGS_DA_TRNS_IMP.UPDATE_TERM_UNIT_DETAILS');
861: EXCEPTION
862: WHEN OTHERS
863: THEN
864: ecx_debug.pop ('IGS_DA_TRNS_IMP.UPDATE_TERM_UNIT_DETAILS');

Line 864: ecx_debug.pop ('IGS_DA_TRNS_IMP.UPDATE_TERM_UNIT_DETAILS');

860: ecx_debug.pop ('IGS_DA_TRNS_IMP.UPDATE_TERM_UNIT_DETAILS');
861: EXCEPTION
862: WHEN OTHERS
863: THEN
864: ecx_debug.pop ('IGS_DA_TRNS_IMP.UPDATE_TERM_UNIT_DETAILS');
865: write_message('ERROR ' || sqlerrm);
866: -- ROLLBACK TO before_update_unit;
867: igs_ad_gen_016.extract_msg_from_stack (p_msg_at_index => l_msg_at_index,
868: p_return_status => l_return_status,

Line 929: ecx_debug.push ('IGS_DA_TRNS_IMP.CREATE_TERM_UNIT_DETAILS');

925: l_error_code VARCHAR2 (4) := NULL;
926: l_error_text VARCHAR2 (2000) := NULL;
927: l_unit_difficulty NUMBER;
928: BEGIN
929: ecx_debug.push ('IGS_DA_TRNS_IMP.CREATE_TERM_UNIT_DETAILS');
930: l_msg_at_index := igs_ge_msg_stack.count_msg;
931: SAVEPOINT before_create_unit;
932:
933: IF (NVL (fnd_profile.VALUE ('IGS_AV_STND_SOURCE'), 'X') = 'EXTERNAL')

Line 960: ecx_debug.pop ('IGS_DA_TRNS_IMP.CREATE_TERM_UNIT_DETAILS');

956: || l_unit_details_id,
957: 'igs.plsql.igs_da_trns_imp.create_term_unit_details'
958: );
959: p_term_unitdtls_record.unit_details_id := l_unit_details_id;
960: ecx_debug.pop ('IGS_DA_TRNS_IMP.CREATE_TERM_UNIT_DETAILS');
961: RETURN l_unit_details_id;
962: EXCEPTION
963: WHEN OTHERS
964: THEN

Line 1027: ecx_debug.push ('IGS_DA_TRNS_IMP.PROCESS_TERM_UNIT_DETAILS');

1023: AND unit_name = p_trans_cur_rec.unit_name;
1024:
1025: dup_cur_rec c_dup_cur%ROWTYPE;
1026: BEGIN
1027: ecx_debug.push ('IGS_DA_TRNS_IMP.PROCESS_TERM_UNIT_DETAILS');
1028: write_log ('Entering process_term_unit_details',
1029: 'igs.plsql.igs_da_trns_imp.process_term_unit_details'
1030: );
1031: OPEN c_dup_cur;

Line 1069: ecx_debug.pop ('IGS_DA_TRNS_IMP.PROCESS_TERM_UNIT_DETAILS');

1065: CLOSE c_dup_cur;
1066: write_log ('Source Unit l_unit_details_id=' || l_unit_details_id,
1067: 'igs.plsql.igs_da_trns_imp.process_term_unit_details'
1068: );
1069: ecx_debug.pop ('IGS_DA_TRNS_IMP.PROCESS_TERM_UNIT_DETAILS');
1070: RETURN l_unit_details_id;
1071: EXCEPTION
1072: WHEN OTHERS
1073: THEN

Line 1091: ecx_debug.push ('IGS_DA_TRNS_IMP.CREATE_TERM_DETAILS');

1087: l_hash_msg_name_text_type_tab igs_ad_gen_016.g_msg_name_text_type_table;
1088: l_error_code VARCHAR2 (4) := NULL;
1089: l_error_text VARCHAR2 (2000) := NULL;
1090: BEGIN
1091: ecx_debug.push ('IGS_DA_TRNS_IMP.CREATE_TERM_DETAILS');
1092: l_msg_at_index := igs_ge_msg_stack.count_msg;
1093: SAVEPOINT before_create_term;
1094:
1095: IF (NVL (fnd_profile.VALUE ('IGS_AV_STND_SOURCE'), 'X') = 'EXTERNAL')

Line 1123: ecx_debug.pop ('IGS_DA_TRNS_IMP.CREATE_TERM_DETAILS');

1119: p_term_dtls_record.term_details_id := l_term_details_id;
1120: write_log (l_term_details_id,
1121: 'igs.plsql.igs_da_trns_imp.create_term_details'
1122: );
1123: ecx_debug.pop ('IGS_DA_TRNS_IMP.CREATE_TERM_DETAILS');
1124: -- Update Transcript Status
1125: EXCEPTION
1126: WHEN OTHERS
1127: THEN

Line 1128: ecx_debug.pop ('IGS_DA_TRNS_IMP.CREATE_TERM_DETAILS');

1124: -- Update Transcript Status
1125: EXCEPTION
1126: WHEN OTHERS
1127: THEN
1128: ecx_debug.pop ('IGS_DA_TRNS_IMP.CREATE_TERM_DETAILS');
1129: -- ROLLBACK TO before_create_term;
1130: write_message('ERROR ' || sqlerrm);
1131: igs_ad_gen_016.extract_msg_from_stack (p_msg_at_index => l_msg_at_index,
1132: p_return_status => l_return_status,

Line 1196: ecx_debug.push ('IGS_DA_TRNS_IMP.UPDATE_TERM_DETAILS');

1192: AND TRUNC (end_date) = TRUNC (p_term_dtls_record.end_date);
1193:
1194: dup_cur_rec c_dup_cur%ROWTYPE;
1195: BEGIN
1196: ecx_debug.push ('IGS_DA_TRNS_IMP.UPDATE_TERM_DETAILS');
1197: OPEN c_dup_cur;
1198: FETCH c_dup_cur INTO dup_cur_rec;
1199: CLOSE c_dup_cur;
1200: l_msg_at_index := igs_ge_msg_stack.count_msg;

Line 1229: ecx_debug.pop ('IGS_DA_TRNS_IMP.UPDATE_TERM_DETAILS');

1225: p_term_dtls_record.term_details_id := dup_cur_rec.term_details_id;
1226: write_log ('igs_ad_term_details_pkg.update_row',
1227: 'igs.plsql.igs_da_trns_imp.update_term_details'
1228: );
1229: ecx_debug.pop ('IGS_DA_TRNS_IMP.UPDATE_TERM_DETAILS');
1230: EXCEPTION
1231: WHEN OTHERS
1232: THEN
1233: ecx_debug.pop ('IGS_DA_TRNS_IMP.UPDATE_TERM_DETAILS');

Line 1233: ecx_debug.pop ('IGS_DA_TRNS_IMP.UPDATE_TERM_DETAILS');

1229: ecx_debug.pop ('IGS_DA_TRNS_IMP.UPDATE_TERM_DETAILS');
1230: EXCEPTION
1231: WHEN OTHERS
1232: THEN
1233: ecx_debug.pop ('IGS_DA_TRNS_IMP.UPDATE_TERM_DETAILS');
1234: write_message('ERROR ' || sqlerrm);
1235: -- ROLLBACK TO before_update_term;
1236: igs_ad_gen_016.extract_msg_from_stack (p_msg_at_index => l_msg_at_index,
1237: p_return_status => l_return_status,

Line 1298: ecx_debug.push ('IGS_DA_TRNS_IMP.PROCESS_TERM_DETAILS');

1294: AND TRUNC (end_date) = TRUNC (p_trans_cur_rec.end_date);
1295:
1296: dup_cur_rec c_dup_cur%ROWTYPE;
1297: BEGIN
1298: ecx_debug.push ('IGS_DA_TRNS_IMP.PROCESS_TERM_DETAILS');
1299: write_log ('process_term_details',
1300: 'igs.plsql.igs_da_trns_imp.process_term_details'
1301: );
1302: OPEN c_dup_cur;

Line 1331: ecx_debug.pop ('IGS_DA_TRNS_IMP.PROCESS_TERM_DETAILS');

1327: CLOSE c_dup_cur;
1328: write_log ('end process_term_details',
1329: 'igs.plsql.igs_da_trns_imp.process_term_details'
1330: );
1331: ecx_debug.pop ('IGS_DA_TRNS_IMP.PROCESS_TERM_DETAILS');
1332: EXCEPTION
1333: WHEN OTHERS
1334: THEN
1335: write_message('ERROR ' || sqlerrm);

Line 1442: ecx_debug.push ('IGS_DA_TRNS_IMP.CREATE_ACAD_HIST_REC');

1438: write_message (' p_cp_attempted ' || p_cp_attempted);
1439: write_message (' p_cp_earned ' || p_cp_earned);
1440: write_message (' p_grade ' || p_grade);
1441: write_message (' p_unit_grade_points ' || p_unit_grade_points);
1442: ecx_debug.push ('IGS_DA_TRNS_IMP.CREATE_ACAD_HIST_REC');
1443: write_log ('start create_acad_hist_rec',
1444: 'igs.plsql.igs_da_trns_imp.create_acad_hist_rec'
1445: );
1446: --initialise(trans_cur_rec);

Line 1606: ecx_debug.pop ('IGS_DA_TRNS_IMP.CREATE_ACAD_HIST_REC');

1602: x_application_id => l_edu_rec.application_id
1603: );
1604: CLOSE c_edu;
1605: -- COMMIT;
1606: ecx_debug.pop ('IGS_DA_TRNS_IMP.CREATE_ACAD_HIST_REC');
1607: EXCEPTION
1608: WHEN OTHERS
1609: THEN
1610: write_message('ERROR ' || sqlerrm);

Line 1629: ecx_debug.push ('IGS_DA_TRNS_IMP.GET_ADV_STND_GRANTING_STATUS');

1625: WHERE batch_id = p_batch_id AND feature_code = 'AUT';
1626:
1627: l_automatic_grant VARCHAR2 (5);
1628: BEGIN
1629: ecx_debug.push ('IGS_DA_TRNS_IMP.GET_ADV_STND_GRANTING_STATUS');
1630:
1631: IF (NVL (fnd_profile.VALUE ('IGS_AV_STND_SOURCE'), 'X') = 'EXTERNAL')
1632: THEN
1633: RETURN 'GRANTED';

Line 1649: ecx_debug.pop ('IGS_DA_TRNS_IMP.GET_ADV_STND_GRANTING_STATUS');

1645: RETURN 'APPROVED';
1646: END IF;
1647: END IF;
1648:
1649: ecx_debug.pop ('IGS_DA_TRNS_IMP.GET_ADV_STND_GRANTING_STATUS');
1650: EXCEPTION
1651: WHEN OTHERS
1652: THEN
1653: write_message('ERROR ' || sqlerrm);

Line 1681: ecx_debug.push ('IGS_DA_TRNS_IMP.VALIDATE_PARAMETERS');

1677: +===========================================================================*/
1678: l_b_return_val BOOLEAN DEFAULT TRUE;
1679: l_s_message_name VARCHAR2 (30);
1680: BEGIN
1681: ecx_debug.push ('IGS_DA_TRNS_IMP.VALIDATE_PARAMETERS');
1682: write_message ('Inside validate_parameters');
1683:
1684: IF p_person_number IS NULL
1685: THEN

Line 1739: ecx_debug.pop ('IGS_DA_TRNS_IMP.VALIDATE_PARAMETERS');

1735: );
1736: END IF;
1737:
1738: write_message ('Comming Out Of validate_parameters' || l_s_message_name);
1739: ecx_debug.pop ('IGS_DA_TRNS_IMP.VALIDATE_PARAMETERS');
1740: RETURN l_b_return_val;
1741: EXCEPTION
1742: WHEN OTHERS
1743: THEN

Line 1794: ecx_debug.push ('IGS_DA_TRNS_IMP.DERIVE_UNIT_DATA');

1790: l_start_dt igs_ad_term_details.start_date%TYPE;
1791: l_end_dt igs_ad_term_details.end_date%TYPE;
1792: l_return_status VARCHAR2 (1000);
1793: BEGIN
1794: ecx_debug.push ('IGS_DA_TRNS_IMP.DERIVE_UNIT_DATA');
1795: p_s_adv_stnd_type := 'UNIT'; -- initialise
1796: p_person_id := igs_ge_gen_003.get_person_id (p_person_number);
1797: write_message ('Got person ID as ' || p_person_id);
1798:

Line 1872: ecx_debug.pop ('IGS_DA_TRNS_IMP.DERIVE_UNIT_DATA');

1868:
1869: write_message ( 'Got p_achievable_credit_points as '
1870: || p_achievable_credit_points
1871: );
1872: ecx_debug.pop ('IGS_DA_TRNS_IMP.DERIVE_UNIT_DATA');
1873: RETURN TRUE;
1874: EXCEPTION
1875: WHEN OTHERS
1876: THEN

Line 1910: ecx_debug.push ('IGS_DA_TRNS_IMP.VALIDATE_ADV_STD_DB_CONS');

1906: | jhanda 11-08-2005 Created |
1907: +===========================================================================*/
1908: x_return_status BOOLEAN := TRUE;
1909: BEGIN
1910: ecx_debug.push ('IGS_DA_TRNS_IMP.VALIDATE_ADV_STD_DB_CONS');
1911: x_return_status := TRUE;
1912: write_message ('Before igs_ps_ver_pkg.get_pk_for_validation ');
1913:
1914: IF NOT igs_ps_ver_pkg.get_pk_for_validation (x_course_cd => p_program_cd,

Line 1931: ecx_debug.pop ('IGS_DA_TRNS_IMP.VALIDATE_ADV_STD_DB_CONS');

1927: );
1928: END IF;
1929:
1930: write_message ('Inside validate_adv_std_db_cons Got x_return_status as ');
1931: ecx_debug.pop ('IGS_DA_TRNS_IMP.VALIDATE_ADV_STD_DB_CONS');
1932: RETURN x_return_status;
1933: EXCEPTION
1934: WHEN OTHERS
1935: THEN

Line 1970: ecx_debug.push ('IGS_DA_TRNS_IMP.VALIDATE_ADV_STND');

1966: | cursor c_validate_inst |
1967: +===========================================================================*/
1968: x_return_status BOOLEAN;
1969: BEGIN
1970: ecx_debug.push ('IGS_DA_TRNS_IMP.VALIDATE_ADV_STND');
1971: x_return_status := TRUE;
1972:
1973: /*
1974: check whether person is deceased or not

Line 2165: ecx_debug.pop ('IGS_DA_TRNS_IMP.VALIDATE_ADV_STND');

2161:
2162: CLOSE c_exists;
2163: END;
2164:
2165: ecx_debug.pop ('IGS_DA_TRNS_IMP.VALIDATE_ADV_STND');
2166: RETURN x_return_status;
2167: EXCEPTION
2168: WHEN OTHERS
2169: THEN

Line 2210: ecx_debug.push ('IGS_DA_TRNS_IMP.VALIDATE_STD_UNT_DB_CONS');

2206: x_return_status BOOLEAN := TRUE;
2207: l_c_tmp_msg VARCHAR2 (30);
2208: BEGIN
2209: -- Foreign Key with Table IGS_AV_ADV_STANDING_PKG
2210: ecx_debug.push ('IGS_DA_TRNS_IMP.VALIDATE_STD_UNT_DB_CONS');
2211: write_message ( 'p_person_id='
2212: || p_person_id
2213: || ' p_program_cd='
2214: || p_program_cd

Line 2300: ecx_debug.pop ('IGS_DA_TRNS_IMP.VALIDATE_STD_UNT_DB_CONS');

2296: )
2297: );
2298: END IF;
2299:
2300: ecx_debug.pop ('IGS_DA_TRNS_IMP.VALIDATE_STD_UNT_DB_CONS');
2301: RETURN x_return_status;
2302: EXCEPTION
2303: WHEN OTHERS
2304: THEN

Line 2348: ecx_debug.push ('IGS_DA_TRNS_IMP.VALIDATE_UNIT');

2344: l_total_exmptn_perc_grntd igs_av_adv_standing_all.total_exmptn_perc_grntd%TYPE;
2345: l_message_name VARCHAR2 (30);
2346: l_grant_status igs_av_stnd_unit_all.s_adv_stnd_granting_status%TYPE;
2347: BEGIN
2348: ecx_debug.push ('IGS_DA_TRNS_IMP.VALIDATE_UNIT');
2349:
2350: IF (NVL (fnd_profile.VALUE ('IGS_AV_STND_SOURCE'), 'X') = 'EXTERNAL')
2351: THEN
2352: l_grant_status := 'GRANTED';

Line 2487: ecx_debug.pop ('IGS_DA_TRNS_IMP.VALIDATE_UNIT');

2483:
2484: CLOSE c_exists;
2485: END;
2486:
2487: ecx_debug.pop ('IGS_DA_TRNS_IMP.VALIDATE_UNIT');
2488: RETURN x_return_status;
2489: EXCEPTION
2490: WHEN OTHERS
2491: THEN

Line 2539: ecx_debug.push ('IGS_DA_TRNS_IMP.CREATE_POST_UNIT');

2535: l_total_exmptn_granted igs_av_adv_standing_all.total_exmptn_granted%TYPE;
2536: l_total_exmptn_perc_grntd igs_av_adv_standing_all.total_exmptn_perc_grntd%TYPE;
2537: l_adv_stnd c_adv_stnd%ROWTYPE;
2538: BEGIN
2539: ecx_debug.push ('IGS_DA_TRNS_IMP.CREATE_POST_UNIT');
2540: x_return_status := TRUE;
2541: write_message ('In create_post_unit');
2542:
2543: /*

Line 2598: ecx_debug.pop ('IGS_DA_TRNS_IMP.CREATE_POST_UNIT');

2594: CLOSE c_adv_stnd;
2595: END IF;
2596:
2597: write_message ('Out create_post_unit');
2598: ecx_debug.pop ('IGS_DA_TRNS_IMP.CREATE_POST_UNIT');
2599: RETURN x_return_status;
2600: EXCEPTION
2601: WHEN OTHERS
2602: THEN

Line 2760: ecx_debug.push ('IGS_DA_TRNS_IMP.CREATE_ADV_STND_UNIT');

2756: );
2757: write_message ( ' p_inst_id_code_type => '
2758: || p_inst_id_code_type
2759: );
2760: ecx_debug.push ('IGS_DA_TRNS_IMP.CREATE_ADV_STND_UNIT');
2761: OPEN c_present_inst;
2762: FETCH c_present_inst INTO l_institution_cd;
2763: CLOSE c_present_inst;
2764:

Line 3234: ecx_debug.pop ('IGS_DA_TRNS_IMP.CREATE_ADV_STND_UNIT');

3230:
3231: -- COMMIT;
3232: write_message ('************************ END ADVSTND ********************'
3233: );
3234: ecx_debug.pop ('IGS_DA_TRNS_IMP.CREATE_ADV_STND_UNIT');
3235: --Standard call to get message count and if count is 1, get message info.
3236: fnd_msg_pub.count_and_get (p_count => l_msg_count,
3237: p_data => l_msg_data);
3238: EXCEPTION

Line 3241: ecx_debug.pop ('IGS_DA_TRNS_IMP.CREATE_ADV_STND_UNIT');

3237: p_data => l_msg_data);
3238: EXCEPTION
3239: WHEN duplicate_record_exists
3240: THEN
3241: ecx_debug.pop ('IGS_DA_TRNS_IMP.CREATE_ADV_STND_UNIT');
3242: notify_error (p_batch_id,
3243: l_person_id,
3244: p_program_cd,
3245: 'Error has occurred.See log for Details'

Line 3358: ecx_debug.push ('IGS_DA_TRNS_IMP.CREATE_OR_GET_BATCH_ID');

3354: l_msg_data VARCHAR2 (2000);
3355: l_msg_count NUMBER;
3356: l_igs_da_req_stdnts_id igs_da_req_stdnts.igs_da_req_stdnts_id%TYPE;
3357: BEGIN
3358: ecx_debug.push ('IGS_DA_TRNS_IMP.CREATE_OR_GET_BATCH_ID');
3359: write_message (' p_batch_id ' || p_batch_id);
3360: write_message (' p_person_id_code ' || p_person_id_code);
3361: write_message (' p_person_id_code_type ' || p_person_id_code_type);
3362: write_message (' p_program_code ' || p_program_code);

Line 3541: ecx_debug.pop ('IGS_DA_TRNS_IMP.CREATE_OR_GET_BATCH_ID');

3537:
3538: write_message (' New Batch ID is ' || p_out_batch_id);
3539: END IF;
3540:
3541: ecx_debug.pop ('IGS_DA_TRNS_IMP.CREATE_OR_GET_BATCH_ID');
3542: EXCEPTION
3543: WHEN OTHERS
3544: THEN
3545: ecx_debug.pop ('IGS_DA_TRNS_IMP.CREATE_OR_GET_BATCH_ID');

Line 3545: ecx_debug.pop ('IGS_DA_TRNS_IMP.CREATE_OR_GET_BATCH_ID');

3541: ecx_debug.pop ('IGS_DA_TRNS_IMP.CREATE_OR_GET_BATCH_ID');
3542: EXCEPTION
3543: WHEN OTHERS
3544: THEN
3545: ecx_debug.pop ('IGS_DA_TRNS_IMP.CREATE_OR_GET_BATCH_ID');
3546: notify_error (p_batch_id,
3547: l_person_id,
3548: p_program_code,
3549: 'Setup Template not defined'

Line 3557: ecx_debug.push ('IGS_DA_TRNS_IMP.COMPLETE_IMPORT_PROCESS');

3553:
3554: PROCEDURE complete_import_process (p_batch_id IN igs_da_rqst.batch_id%TYPE)
3555: AS
3556: BEGIN
3557: ecx_debug.push ('IGS_DA_TRNS_IMP.COMPLETE_IMPORT_PROCESS');
3558: write_message ( 'Entered complete_import_process p_batch_id='
3559: || p_batch_id
3560: );
3561:

Line 3575: ecx_debug.pop ('IGS_DA_TRNS_IMP.COMPLETE_IMPORT_PROCESS');

3571: || ' '
3572: WHERE batch_id = p_batch_id AND report_text IS NULL;
3573:
3574: igs_da_xml_pkg.update_request_status (p_batch_id);
3575: ecx_debug.pop ('IGS_DA_TRNS_IMP.COMPLETE_IMPORT_PROCESS');
3576: EXCEPTION
3577: WHEN OTHERS
3578: THEN
3579: write_message('ERROR ' || sqlerrm);