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_AD_GEN_016

Line 8: l_hash_msg_name_text_type_tab igs_ad_gen_016.g_msg_name_text_type_table;

4: l_return_status VARCHAR2 (1);
5: l_debug_str VARCHAR2 (1000);
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:

Line 192: l_hash_msg_name_text_type_tab igs_ad_gen_016.g_msg_name_text_type_table;

188: l_msg_at_index NUMBER := 0;
189: l_return_status VARCHAR2 (1);
190: l_msg_count NUMBER;
191: l_msg_data VARCHAR2 (2000);
192: l_hash_msg_name_text_type_tab igs_ad_gen_016.g_msg_name_text_type_table;
193: l_error_text VARCHAR2 (2000);
194: l_education_id NUMBER;
195: l_status VARCHAR2 (10);
196: l_object_version_number hz_education.object_version_number%TYPE

Line 290: igs_ad_gen_016.extract_msg_from_stack (p_msg_at_index => l_msg_at_index,

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,
292: p_msg_count => l_msg_count,
293: p_msg_data => l_msg_data,
294: p_hash_msg_name_text_type_tab => l_hash_msg_name_text_type_tab

Line 337: write_log (igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE',

333: ELSE
334: person_history_rec.education_id := l_education_id;
335: END IF;
336: ELSE -- validation fails
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'

Line 404: write_log (igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE',

400:
401: --If invalid education ID then error out.
402: IF acad_hist_rec.education_id IS NULL
403: THEN
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'

Line 645: igs_ad_gen_016.extract_msg_from_stack (p_msg_at_index => l_msg_at_index,

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,
647: p_msg_count => l_msg_count,
648: p_msg_data => l_msg_data,
649: p_hash_msg_name_text_type_tab => l_hash_msg_name_text_type_tab

Line 661: igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE',

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',
662: 'E518',
663: 8405
664: );
665: l_error_code := 'E518';

Line 773: igs_ad_gen_016.extract_msg_from_stack (p_msg_at_index => l_msg_at_index,

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,
775: p_msg_count => l_msg_count,
776: p_msg_data => l_msg_data,
777: p_hash_msg_name_text_type_tab => l_hash_msg_name_text_type_tab

Line 789: igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE',

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',
790: 'E518',
791: 8405
792: );
793: l_error_code := 'E518';

Line 820: l_hash_msg_name_text_type_tab igs_ad_gen_016.g_msg_name_text_type_table;

816: l_msg_at_index NUMBER := 0;
817: l_return_status VARCHAR2 (1);
818: l_msg_count NUMBER;
819: l_msg_data VARCHAR2 (2000);
820: l_hash_msg_name_text_type_tab igs_ad_gen_016.g_msg_name_text_type_table;
821: l_error_code VARCHAR2 (4) := NULL;
822: l_error_text VARCHAR2 (2000) := NULL;
823:
824: CURSOR c_dup_cur

Line 867: igs_ad_gen_016.extract_msg_from_stack (p_msg_at_index => l_msg_at_index,

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,
869: p_msg_count => l_msg_count,
870: p_msg_data => l_msg_data,
871: p_hash_msg_name_text_type_tab => l_hash_msg_name_text_type_tab

Line 883: igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE',

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',
884: 'E518',
885: 8405
886: );
887: l_error_code := 'E518';

Line 924: l_hash_msg_name_text_type_tab igs_ad_gen_016.g_msg_name_text_type_table;

920: l_msg_at_index NUMBER := 0;
921: l_return_status VARCHAR2 (1);
922: l_msg_count NUMBER;
923: l_msg_data VARCHAR2 (2000);
924: l_hash_msg_name_text_type_tab igs_ad_gen_016.g_msg_name_text_type_table;
925: l_error_code VARCHAR2 (4) := NULL;
926: l_error_text VARCHAR2 (2000) := NULL;
927: l_unit_difficulty NUMBER;
928: BEGIN

Line 967: igs_ad_gen_016.extract_msg_from_stack (p_msg_at_index => l_msg_at_index,

963: WHEN OTHERS
964: THEN
965: write_message('ERROR ' || sqlerrm);
966: -- ROLLBACK TO before_create_unit;
967: igs_ad_gen_016.extract_msg_from_stack (p_msg_at_index => l_msg_at_index,
968: p_return_status => l_return_status,
969: p_msg_count => l_msg_count,
970: p_msg_data => l_msg_data,
971: p_hash_msg_name_text_type_tab => l_hash_msg_name_text_type_tab

Line 983: igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE',

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',
984: 'E518',
985: 8405
986: );
987: l_error_code := 'E518';

Line 1087: l_hash_msg_name_text_type_tab igs_ad_gen_016.g_msg_name_text_type_table;

1083: l_msg_at_index NUMBER := 0;
1084: l_return_status VARCHAR2 (1);
1085: l_msg_count NUMBER;
1086: l_msg_data VARCHAR2 (2000);
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');

Line 1131: igs_ad_gen_016.extract_msg_from_stack (p_msg_at_index => l_msg_at_index,

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,
1133: p_msg_count => l_msg_count,
1134: p_msg_data => l_msg_data,
1135: p_hash_msg_name_text_type_tab => l_hash_msg_name_text_type_tab

Line 1147: igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE',

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',
1148: 'E518',
1149: 8405
1150: );
1151: l_error_code := 'E518';

Line 1179: l_hash_msg_name_text_type_tab igs_ad_gen_016.g_msg_name_text_type_table;

1175: l_msg_at_index NUMBER := 0;
1176: l_return_status VARCHAR2 (1);
1177: l_msg_count NUMBER;
1178: l_msg_data VARCHAR2 (2000);
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';

Line 1236: igs_ad_gen_016.extract_msg_from_stack (p_msg_at_index => l_msg_at_index,

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,
1238: p_msg_count => l_msg_count,
1239: p_msg_data => l_msg_data,
1240: p_hash_msg_name_text_type_tab => l_hash_msg_name_text_type_tab

Line 1252: igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE',

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',
1253: 'E518',
1254: 8405
1255: );
1256: l_error_code := 'E518';