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 IGS_DA_TRNS_IMP

Line 1: PACKAGE BODY igs_da_trns_imp AS

1: PACKAGE BODY igs_da_trns_imp AS
2: /* $Header: IGSDA12B.pls 120.19 2005/12/11 23:31:01 appldev noship $ */
3: l_msg_at_index NUMBER := 0;
4: l_return_status VARCHAR2 (1);
5: l_debug_str VARCHAR2 (1000);

Line 10: := 'igs.plsql.igs_da_trns_imp';

6: l_msg_count NUMBER;
7: l_msg_data VARCHAR2 (2000);
8: l_hash_msg_name_text_type_tab igs_ad_gen_016.g_msg_name_text_type_table;
9: l_label VARCHAR2 (200)
10: := 'igs.plsql.igs_da_trns_imp';
11: g_pkg_name CONSTANT VARCHAR2 (30) := 'igs_da_trns_imp';
12:
13: PROCEDURE write_log (l_debug_str IN VARCHAR2, l_label IN VARCHAR2)
14: AS

Line 11: g_pkg_name CONSTANT VARCHAR2 (30) := 'igs_da_trns_imp';

7: l_msg_data VARCHAR2 (2000);
8: l_hash_msg_name_text_type_tab igs_ad_gen_016.g_msg_name_text_type_table;
9: l_label VARCHAR2 (200)
10: := 'igs.plsql.igs_da_trns_imp';
11: g_pkg_name CONSTANT VARCHAR2 (30) := 'igs_da_trns_imp';
12:
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';

Line 15: l_prog_label VARCHAR2 (100) := 'igs.plsql.igs_da_trns_imp';

11: g_pkg_name CONSTANT VARCHAR2 (30) := 'igs_da_trns_imp';
12:
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:

Line 39: write_log (p_msg, 'igs.plsql.igs_da_trns_imp.adv_stnd_import');

35: PROCEDURE write_message (p_msg IN VARCHAR2)
36: -- this procedure will be used to debug
37: IS
38: BEGIN
39: write_log (p_msg, 'igs.plsql.igs_da_trns_imp.adv_stnd_import');
40: END write_message;
41:
42: PROCEDURE notify_error (
43: p_batch_id IN igs_da_rqst.batch_id%TYPE,

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 78: write_message ('Calling IGS_DA_TRNS_IMP.NOTIFY_ERROR ' || p_msg);

74: AND person_id = p_person_id
75: AND program_code = p_program_code;
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

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 200: := 'igs.plsql.igs_da_trns_imp';

196: l_object_version_number hz_education.object_version_number%TYPE
197: := NULL;
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;

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 303: 'igs.plsql.igs_da_trns_imp.crc_pe_acad_hist'

299: THEN
300: l_error_text := l_msg_data;
301: l_error_code := NULL;
302: write_log (l_msg_data,
303: 'igs.plsql.igs_da_trns_imp.crc_pe_acad_hist'
304: );
305: ELSE
306: l_error_text := NULL;
307: l_error_code := 'E518';

Line 312: 'igs.plsql.igs_da_trns_imp.crc_pe_acad_hist'

308:
309: IF fnd_log.test (fnd_log.level_exception, l_prog_label)
310: THEN
311: write_log (l_msg_data,
312: 'igs.plsql.igs_da_trns_imp.crc_pe_acad_hist'
313: );
314: l_debug_str := fnd_message.get;
315: write_log (l_msg_data,
316: 'igs.plsql.igs_da_trns_imp.crc_pe_acad_hist'

Line 316: 'igs.plsql.igs_da_trns_imp.crc_pe_acad_hist'

312: 'igs.plsql.igs_da_trns_imp.crc_pe_acad_hist'
313: );
314: l_debug_str := fnd_message.get;
315: write_log (l_msg_data,
316: 'igs.plsql.igs_da_trns_imp.crc_pe_acad_hist'
317: );
318: END IF;
319: END IF;
320:

Line 322: 'igs.plsql.igs_da_trns_imp.crc_pe_acad_hist'

318: END IF;
319: END IF;
320:
321: write_log (l_error_text,
322: 'igs.plsql.igs_da_trns_imp.crc_pe_acad_hist'
323: );
324: RETURN;
325: END;
326:

Line 330: 'igs.plsql.igs_da_trns_imp.crc_pe_acad_hist'

326:
327: IF l_return_status IN ('E', 'U')
328: THEN
329: write_log (l_msg_data,
330: 'igs.plsql.igs_da_trns_imp.crc_pe_acad_hist'
331: );
332: --log detail
333: ELSE
334: person_history_rec.education_id := l_education_id;

Line 341: 'igs.plsql.igs_da_trns_imp.crc_pe_acad_hist'

337: write_log (igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE',
338: l_error_code,
339: 8405
340: ),
341: 'igs.plsql.igs_da_trns_imp.crc_pe_acad_hist'
342: );
343: NULL;
344: END IF; -- end of ( l_error_code IS NULL ) */
345: EXCEPTION

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 376: l_prog_label := 'igs.plsql.igs_da_trns_imp.crc_pe_acad_hist';

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 ='
380: || acad_hist_rec.person_id,

Line 381: 'igs.plsql.igs_da_trns_imp.prc_pe_acad_hist'

377: write_log ( 'Entered prc_pe_acad_hist prev_institution_code='
378: || acad_hist_rec.prev_institution_code
379: || ' person_id ='
380: || acad_hist_rec.person_id,
381: 'igs.plsql.igs_da_trns_imp.prc_pe_acad_hist'
382: );
383: OPEN c_dup_cur;
384: FETCH c_dup_cur INTO dup_cur_rec;
385:

Line 389: 'igs.plsql.igs_da_trns_imp.prc_pe_acad_hist'

385:
386: IF c_dup_cur%NOTFOUND
387: THEN
388: write_log ('calling crc_pe_acad_hist ',
389: 'igs.plsql.igs_da_trns_imp.prc_pe_acad_hist'
390: );
391: crc_pe_acad_hist (acad_hist_rec, l_error_code);
392: ELSE
393: write_log ('Not calling crc_pe_acad_hist ',

Line 394: 'igs.plsql.igs_da_trns_imp.prc_pe_acad_hist'

390: );
391: crc_pe_acad_hist (acad_hist_rec, l_error_code);
392: ELSE
393: write_log ('Not calling crc_pe_acad_hist ',
394: 'igs.plsql.igs_da_trns_imp.prc_pe_acad_hist'
395: );
396: -- find the education id if acad hist exists
397: OPEN c_edu_id;
398: FETCH c_edu_id INTO acad_hist_rec.education_id;

Line 408: 'igs.plsql.igs_da_trns_imp.crc_pe_acad_hist'

404: write_log (igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE',
405: 'E711',
406: 8405
407: ),
408: 'igs.plsql.igs_da_trns_imp.crc_pe_acad_hist'
409: );
410: END IF;
411: ---
412: END IF;

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 632: 'igs.plsql.igs_da_trns_imp.create_new_transcript_details'

628: END IF;
629:
630: p_trans_record.transcript_id := l_transcript_id;
631: write_log ('igs_ad_transcript_pkg.insert_row',
632: 'igs.plsql.igs_da_trns_imp.create_new_transcript_details'
633: );
634: igs_ad_wf_001.transcript_entrd_event (p_trans_record.person_id,
635: p_trans_record.education_id,
636: l_transcript_id

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 657: 'igs.plsql.igs_da_trns_imp.create_new_transcript_details'

653: THEN
654: l_error_text := l_msg_data;
655: l_error_code := 'E322';
656: write_log (l_msg_data,
657: 'igs.plsql.igs_da_trns_imp.create_new_transcript_details'
658: );
659: ELSE
660: l_error_text :=
661: igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE',

Line 667: 'igs.plsql.igs_da_trns_imp.create_new_transcript_details.exception '

663: 8405
664: );
665: l_error_code := 'E518';
666: l_label :=
667: 'igs.plsql.igs_da_trns_imp.create_new_transcript_details.exception '
668: || l_msg_data;
669: fnd_message.set_name ('IGS', 'IGS_PE_IMP_ERROR');
670: fnd_message.set_token ('INTERFACE_ID', 'Some Value');
671: fnd_message.set_token ('ERROR_CD', 'E322');

Line 674: 'igs.plsql.igs_da_trns_imp.create_new_transcript_details'

670: fnd_message.set_token ('INTERFACE_ID', 'Some Value');
671: fnd_message.set_token ('ERROR_CD', 'E322');
672: l_debug_str := fnd_message.get;
673: write_log (l_debug_str,
674: 'igs.plsql.igs_da_trns_imp.create_new_transcript_details'
675: );
676: END IF;
677:
678: write_log (l_error_text,

Line 679: 'igs.plsql.igs_da_trns_imp.create_new_transcript_details'

675: );
676: END IF;
677:
678: write_log (l_error_text,
679: 'igs.plsql.igs_da_trns_imp.create_new_transcript_details'
680: );
681: END;
682: EXCEPTION
683: WHEN OTHERS

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 764: 'igs.plsql.igs_da_trns_imp.update_transcript_details'

760: END IF;
761:
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

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 785: 'igs.plsql.igs_da_trns_imp.update_transcript_details'

781: THEN
782: l_error_text := l_msg_data;
783: l_error_code := 'E014';
784: write_log (l_msg_data,
785: 'igs.plsql.igs_da_trns_imp.update_transcript_details'
786: );
787: ELSE
788: l_error_text :=
789: igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE',

Line 799: 'igs.plsql.igs_da_trns_imp.update_transcript_details'

795: fnd_message.set_token ('INTERFACE_ID', 'Some Value');
796: fnd_message.set_token ('ERROR_CD', 'E014');
797: l_debug_str := fnd_message.get;
798: write_log (l_debug_str,
799: 'igs.plsql.igs_da_trns_imp.update_transcript_details'
800: );
801: END IF;
802:
803: write_log (l_error_text,

Line 804: 'igs.plsql.igs_da_trns_imp.update_transcript_details'

800: );
801: END IF;
802:
803: write_log (l_error_text,
804: 'igs.plsql.igs_da_trns_imp.update_transcript_details'
805: );
806: END update_transcript_details;
807:
808: -- Update term unit details

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 858: 'igs.plsql.igs_da_trns_imp.update_term_unit_details'

854:
855: p_term_unitdtls_record.unit_details_id := dup_cur_rec.unit_details_id;
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

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 879: 'igs.plsql.igs_da_trns_imp.update_term_unit_details'

875: THEN
876: l_error_text := l_msg_data;
877: l_error_code := 'E014';
878: write_log (l_msg_data,
879: 'igs.plsql.igs_da_trns_imp.update_term_unit_details'
880: );
881: ELSE
882: l_error_text :=
883: igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE',

Line 895: 'igs.plsql.igs_da_trns_imp.update_term_unit_details'

891: );
892: fnd_message.set_token ('ERROR_CD', 'E014');
893: l_debug_str := fnd_message.get;
894: write_log (l_debug_str,
895: 'igs.plsql.igs_da_trns_imp.update_term_unit_details'
896: );
897: END IF;
898:
899: write_log (l_error_text,

Line 900: 'igs.plsql.igs_da_trns_imp.update_term_unit_details'

896: );
897: END IF;
898:
899: write_log (l_error_text,
900: 'igs.plsql.igs_da_trns_imp.update_term_unit_details'
901: );
902: END update_term_unit_details;
903:
904: -- Create term unit details

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 936: 'igs.plsql.igs_da_trns_imp.create_term_unit_details'

932:
933: IF (NVL (fnd_profile.VALUE ('IGS_AV_STND_SOURCE'), 'X') = 'EXTERNAL')
934: THEN
935: write_log ('Before igs_ad_term_unitdtls_pkg.insert_row',
936: 'igs.plsql.igs_da_trns_imp.create_term_unit_details'
937: );
938: OPEN c_unit_difficulty;
939: FETCH c_unit_difficulty INTO l_unit_difficulty;
940: CLOSE c_unit_difficulty;

Line 957: 'igs.plsql.igs_da_trns_imp.create_term_unit_details'

953: END IF;
954:
955: write_log ( 'After igs_ad_term_unitdtls_pkg.insert_row l_unit_details_id='
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;

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 979: 'igs.plsql.igs_da_trns_imp.create_term_unit_details'

975: THEN
976: l_error_text := l_msg_data || SQLERRM || ' ERROR';
977: l_error_code := 'E322';
978: write_log (l_msg_data || SQLERRM,
979: 'igs.plsql.igs_da_trns_imp.create_term_unit_details'
980: );
981: ELSE
982: l_error_text :=
983: igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE',

Line 989: 'igs.plsql.igs_da_trns_imp.create_term_unit_details.exception '

985: 8405
986: );
987: l_error_code := 'E518';
988: l_label :=
989: 'igs.plsql.igs_da_trns_imp.create_term_unit_details.exception '
990: || l_msg_data;
991: fnd_message.set_name ('IGS', 'IGS_PE_IMP_ERROR');
992: fnd_message.set_token ('INTERFACE_ID',
993: p_term_unitdtls_record.term_details_id

Line 998: 'igs.plsql.igs_da_trns_imp.create_term_unit_details'

994: );
995: fnd_message.set_token ('ERROR_CD', 'E322');
996: l_debug_str := fnd_message.get;
997: write_log (l_debug_str,
998: 'igs.plsql.igs_da_trns_imp.create_term_unit_details'
999: );
1000: END IF;
1001:
1002: write_log (l_error_text,

Line 1003: 'igs.plsql.igs_da_trns_imp.create_term_unit_details'

999: );
1000: END IF;
1001:
1002: write_log (l_error_text,
1003: 'igs.plsql.igs_da_trns_imp.create_term_unit_details'
1004: );
1005: END create_term_unit_details;
1006:
1007: FUNCTION process_term_unit_details (

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 1029: 'igs.plsql.igs_da_trns_imp.process_term_unit_details'

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;
1032: FETCH c_dup_cur INTO dup_cur_rec;
1033:

Line 1039: 'igs.plsql.igs_da_trns_imp.process_term_unit_details'

1035: AND (NVL (fnd_profile.VALUE ('IGS_AV_STND_SOURCE'), 'X') = 'EXTERNAL'
1036: )
1037: THEN
1038: write_log ('Entering create_term_unit_details',
1039: 'igs.plsql.igs_da_trns_imp.process_term_unit_details'
1040: );
1041: l_unit_details_id := create_term_unit_details (p_trans_cur_rec);
1042: ELSIF (NVL (fnd_profile.VALUE ('IGS_AV_STND_SOURCE'), 'X') = 'EXTERNAL')
1043: THEN

Line 1045: 'igs.plsql.igs_da_trns_imp.process_term_unit_details'

1041: l_unit_details_id := create_term_unit_details (p_trans_cur_rec);
1042: ELSIF (NVL (fnd_profile.VALUE ('IGS_AV_STND_SOURCE'), 'X') = 'EXTERNAL')
1043: THEN
1044: write_log ('Entering update_term_unit_details',
1045: 'igs.plsql.igs_da_trns_imp.process_term_unit_details'
1046: );
1047: l_unit_details_id := dup_cur_rec.unit_details_id;
1048: update_term_unit_details (p_trans_cur_rec);
1049: ELSIF c_dup_cur%FOUND

Line 1054: 'igs.plsql.igs_da_trns_imp.process_term_unit_details'

1050: THEN
1051: l_unit_details_id := dup_cur_rec.unit_details_id;
1052: ELSE
1053: write_log ('Source Unit Not Found',
1054: 'igs.plsql.igs_da_trns_imp.process_term_unit_details'
1055: );
1056: notify_error (p_batch_id,
1057: p_person_id,
1058: p_program_cd,

Line 1067: 'igs.plsql.igs_da_trns_imp.process_term_unit_details'

1063: END IF;
1064:
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

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 1121: 'igs.plsql.igs_da_trns_imp.create_term_details'

1117: END IF;
1118:
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

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 1143: 'igs.plsql.igs_da_trns_imp.create_term_details'

1139: THEN
1140: l_error_text := l_msg_data;
1141: l_error_code := 'E322';
1142: write_log (l_error_text,
1143: 'igs.plsql.igs_da_trns_imp.create_term_details'
1144: );
1145: ELSE
1146: l_error_text :=
1147: igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE',

Line 1153: 'igs.plsql.igs_da_trns_imp.create_term_details.exception '

1149: 8405
1150: );
1151: l_error_code := 'E518';
1152: l_label :=
1153: 'igs.plsql.igs_da_trns_imp.create_term_details.exception '
1154: || l_msg_data;
1155: fnd_message.set_name ('IGS', 'IGS_PE_IMP_ERROR');
1156: fnd_message.set_token ('INTERFACE_ID',
1157: p_term_dtls_record.term_details_id

Line 1162: 'igs.plsql.igs_da_trns_imp.create_term_details'

1158: );
1159: fnd_message.set_token ('ERROR_CD', 'E322');
1160: l_debug_str := fnd_message.get;
1161: write_log (l_debug_str,
1162: 'igs.plsql.igs_da_trns_imp.create_term_details'
1163: );
1164: END IF;
1165:
1166: write_log (l_error_text,

Line 1167: 'igs.plsql.igs_da_trns_imp.create_term_details'

1163: );
1164: END IF;
1165:
1166: write_log (l_error_text,
1167: 'igs.plsql.igs_da_trns_imp.create_term_details'
1168: );
1169: END create_term_details;
1170:
1171: PROCEDURE update_term_details (

Line 1183: := 'igs.plsql.igs_da_trns_imp.update_term_details';

1179: l_hash_msg_name_text_type_tab igs_ad_gen_016.g_msg_name_text_type_table;
1180: l_error_code VARCHAR2 (4) := NULL;
1181: l_error_text VARCHAR2 (2000) := NULL;
1182: l_prog_label VARCHAR2 (100)
1183: := 'igs.plsql.igs_da_trns_imp.update_term_details';
1184:
1185: CURSOR c_dup_cur
1186: IS
1187: SELECT term_oss.ROWID, term_oss.*

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 1227: 'igs.plsql.igs_da_trns_imp.update_term_details'

1223: END IF;
1224:
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

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 1248: 'igs.plsql.igs_da_trns_imp.update_term_details'

1244: THEN
1245: l_error_text := l_msg_data;
1246: l_error_code := 'E014';
1247: write_log (l_msg_data,
1248: 'igs.plsql.igs_da_trns_imp.update_term_details'
1249: );
1250: ELSE
1251: l_error_text :=
1252: igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE',

Line 1270: 'igs.plsql.igs_da_trns_imp.update_term_details'

1266: );
1267: fnd_message.set_token ('ERROR_CD', 'E014');
1268: l_debug_str := fnd_message.get;
1269: write_log (l_debug_str,
1270: 'igs.plsql.igs_da_trns_imp.update_term_details'
1271: );
1272: END IF;
1273: END IF;
1274:

Line 1275: write_log ('igs_da_trns_imp.update_term_details',

1271: );
1272: END IF;
1273: END IF;
1274:
1275: write_log ('igs_da_trns_imp.update_term_details',
1276: 'igs.plsql.igs_da_trns_imp.update_term_details'
1277: );
1278: END update_term_details;
1279:

Line 1276: 'igs.plsql.igs_da_trns_imp.update_term_details'

1272: END IF;
1273: END IF;
1274:
1275: write_log ('igs_da_trns_imp.update_term_details',
1276: 'igs.plsql.igs_da_trns_imp.update_term_details'
1277: );
1278: END update_term_details;
1279:
1280: PROCEDURE process_term_details (

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 1300: 'igs.plsql.igs_da_trns_imp.process_term_details'

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;
1303: FETCH c_dup_cur INTO dup_cur_rec;
1304:

Line 1318: 'igs.plsql.igs_da_trns_imp.update_term_details'

1314: THEN
1315: p_trans_cur_rec.term_details_id := dup_cur_rec.term_details_id;
1316: ELSE
1317: write_log ('ERROR :- Term details not found ',
1318: 'igs.plsql.igs_da_trns_imp.update_term_details'
1319: );
1320: notify_error (p_batch_id,
1321: p_person_id,
1322: p_program_cd,

Line 1329: 'igs.plsql.igs_da_trns_imp.process_term_details'

1325: END IF;
1326:
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

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 1444: 'igs.plsql.igs_da_trns_imp.create_acad_hist_rec'

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);
1447: l_unit := p_source_course_subject || p_source_course_num;
1448: l_trans_cur_rec.term_type := SUBSTR (p_term_type, 1, 1);

Line 1481: 'igs.plsql.igs_da_trns_imp.create_acad_hist_rec'

1477:
1478: IF l_trans_cur_rec.person_id IS NULL
1479: THEN
1480: write_log ('ERROR Unable to validate student ID',
1481: 'igs.plsql.igs_da_trns_imp.create_acad_hist_rec'
1482: );
1483: igs_da_xml_pkg.process_reply_failure (p_batch_id);
1484: p_unit_details_id := NULL;
1485: END IF;

Line 1514: 'igs.plsql.igs_da_trns_imp.create_acad_hist_rec'

1510: END IF;
1511:
1512: CLOSE c_edu_id;
1513: write_log ('Got education ID as ' || l_trans_cur_rec.education_id,
1514: 'igs.plsql.igs_da_trns_imp.create_acad_hist_rec'
1515: );
1516: OPEN c_dup_cur;
1517: FETCH c_dup_cur INTO dup_cur_rec;
1518:

Line 1524: 'igs.plsql.igs_da_trns_imp.create_acad_hist_rec'

1520: AND NVL (fnd_profile.VALUE ('IGS_AV_STND_SOURCE'), 'X') = 'EXTERNAL'
1521: )
1522: THEN
1523: write_log ('Calling create_new_transcript_details',
1524: 'igs.plsql.igs_da_trns_imp.create_acad_hist_rec'
1525: );
1526: create_new_transcript_details (l_trans_cur_rec);
1527: ELSIF (NVL (fnd_profile.VALUE ('IGS_AV_STND_SOURCE'), 'X') = 'EXTERNAL')
1528: THEN

Line 1531: 'igs.plsql.igs_da_trns_imp.create_acad_hist_rec'

1527: ELSIF (NVL (fnd_profile.VALUE ('IGS_AV_STND_SOURCE'), 'X') = 'EXTERNAL')
1528: THEN
1529: write_log ( 'Calling update_transcript_details for transcript_id='
1530: || dup_cur_rec.transcript_id,
1531: 'igs.plsql.igs_da_trns_imp.create_acad_hist_rec'
1532: );
1533: l_trans_cur_rec.transcript_id := dup_cur_rec.transcript_id;
1534: update_transcript_details (l_trans_cur_rec);
1535: ELSIF (c_dup_cur%NOTFOUND)

Line 1554: 'igs.plsql.igs_da_trns_imp.create_acad_hist_rec'

1550: END IF;
1551:
1552: CLOSE c_dup_cur;
1553: write_log ('Before c_transcript_id',
1554: 'igs.plsql.igs_da_trns_imp.create_acad_hist_rec'
1555: );
1556:
1557: IF (NVL (fnd_profile.VALUE ('IGS_AV_STND_SOURCE'), 'X') = 'EXTERNAL')
1558: THEN

Line 1566: 'igs.plsql.igs_da_trns_imp.create_acad_hist_rec'

1562: END IF;
1563:
1564: write_log ( 'After c_transcript_id transcript_id='
1565: || l_trans_cur_rec.transcript_id,
1566: 'igs.plsql.igs_da_trns_imp.create_acad_hist_rec'
1567: );
1568: write_log ('Before process_term_details',
1569: 'igs.plsql.igs_da_trns_imp.create_acad_hist_rec'
1570: );

Line 1569: 'igs.plsql.igs_da_trns_imp.create_acad_hist_rec'

1565: || l_trans_cur_rec.transcript_id,
1566: 'igs.plsql.igs_da_trns_imp.create_acad_hist_rec'
1567: );
1568: write_log ('Before process_term_details',
1569: 'igs.plsql.igs_da_trns_imp.create_acad_hist_rec'
1570: );
1571: process_term_details (p_batch_id,
1572: l_trans_cur_rec.person_id,
1573: p_program_cd,

Line 1577: 'igs.plsql.igs_da_trns_imp.create_acad_hist_rec'

1573: p_program_cd,
1574: l_trans_cur_rec
1575: );
1576: write_log ('Before process_term_unit_details',
1577: 'igs.plsql.igs_da_trns_imp.create_acad_hist_rec'
1578: );
1579: p_unit_details_id :=
1580: process_term_unit_details (p_batch_id,
1581: l_trans_cur_rec.person_id,

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);

Line 3581: END igs_da_trns_imp;

3577: WHEN OTHERS
3578: THEN
3579: write_message('ERROR ' || sqlerrm);
3580: END complete_import_process;
3581: END igs_da_trns_imp;