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_AD_IMP_010 dependencies on IGS_AD_GEN_016

Line 53: cst_et_val_E700 CONSTANT VARCHAR2(100) := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E700', 8405);

49: cst_insert CONSTANT VARCHAR2(6) := 'INSERT';
50: cst_update CONSTANT VARCHAR2(6) := 'UPDATE';
51: cst_unique_record CONSTANT NUMBER := 1;
52:
53: cst_et_val_E700 CONSTANT VARCHAR2(100) := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E700', 8405);
54: cst_et_val_E701 CONSTANT VARCHAR2(100) := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E701', 8405);
55: cst_et_val_E678 CONSTANT VARCHAR2(100) := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E678', 8405);
56:
57: cst_ec_val_E700 CONSTANT VARCHAR2(4) := 'E700';

Line 54: cst_et_val_E701 CONSTANT VARCHAR2(100) := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E701', 8405);

50: cst_update CONSTANT VARCHAR2(6) := 'UPDATE';
51: cst_unique_record CONSTANT NUMBER := 1;
52:
53: cst_et_val_E700 CONSTANT VARCHAR2(100) := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E700', 8405);
54: cst_et_val_E701 CONSTANT VARCHAR2(100) := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E701', 8405);
55: cst_et_val_E678 CONSTANT VARCHAR2(100) := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E678', 8405);
56:
57: cst_ec_val_E700 CONSTANT VARCHAR2(4) := 'E700';
58: cst_ec_val_E701 CONSTANT VARCHAR2(4) := 'E701';

Line 55: cst_et_val_E678 CONSTANT VARCHAR2(100) := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E678', 8405);

51: cst_unique_record CONSTANT NUMBER := 1;
52:
53: cst_et_val_E700 CONSTANT VARCHAR2(100) := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E700', 8405);
54: cst_et_val_E701 CONSTANT VARCHAR2(100) := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E701', 8405);
55: cst_et_val_E678 CONSTANT VARCHAR2(100) := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E678', 8405);
56:
57: cst_ec_val_E700 CONSTANT VARCHAR2(4) := 'E700';
58: cst_ec_val_E701 CONSTANT VARCHAR2(4) := 'E701';
59: cst_ec_val_E678 CONSTANT VARCHAR2(4) := 'E678';

Line 96: l_hash_msg_name_text_type_tab igs_ad_gen_016.g_msg_name_text_type_table;

92: l_error_text VARCHAR2(2000);
93: l_return_status VARCHAR2(1);
94: l_msg_count NUMBER ;
95: l_msg_data VARCHAR2(2000);
96: l_hash_msg_name_text_type_tab igs_ad_gen_016.g_msg_name_text_type_table;
97:
98: l_admission_cat igs_ad_appl.admission_cat%TYPE;
99: l_s_admission_process_type igs_ad_appl.s_admission_process_type%TYPE;
100:

Line 118: IF igs_ad_gen_016.get_appl_type_apc (p_application_type => notes_rec.admission_application_type,

114: l_records_processed := 0;
115:
116: FOR notes_rec IN c_igs_ad_notes_int
117: LOOP
118: IF igs_ad_gen_016.get_appl_type_apc (p_application_type => notes_rec.admission_application_type,
119: p_admission_cat => l_admission_cat,
120: p_s_admission_process_type => l_s_admission_process_type) = 'TRUE' THEN
121:
122: IF igs_ad_gen_016.get_apcs (p_admission_cat => l_admission_cat,

Line 122: IF igs_ad_gen_016.get_apcs (p_admission_cat => l_admission_cat,

118: IF igs_ad_gen_016.get_appl_type_apc (p_application_type => notes_rec.admission_application_type,
119: p_admission_cat => l_admission_cat,
120: p_s_admission_process_type => l_s_admission_process_type) = 'TRUE' THEN
121:
122: IF igs_ad_gen_016.get_apcs (p_admission_cat => l_admission_cat,
123: p_s_admission_process_type => l_s_admission_process_type,
124: p_s_admission_step_type => 'APPL-NOTES') = 'FALSE' THEN
125: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_NOT_APC_STEP');
126: FND_MESSAGE.SET_TOKEN ('CATEGORY', p_category_meaning);

Line 188: igs_ad_gen_016.extract_msg_from_stack (

184: ROLLBACK TO before_create;
185: l_error_code := 'E322';
186: l_msg_data := SQLERRM;
187:
188: igs_ad_gen_016.extract_msg_from_stack (
189: p_msg_at_index => l_msg_at_index,
190: p_return_status => l_return_status,
191: p_msg_count => l_msg_count,
192: p_msg_data => l_msg_data,

Line 194: l_error_text := NVL(l_msg_data,igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', l_error_code, 8405));

190: p_return_status => l_return_status,
191: p_msg_count => l_msg_count,
192: p_msg_data => l_msg_data,
193: p_hash_msg_name_text_type_tab => l_hash_msg_name_text_type_tab);
194: l_error_text := NVL(l_msg_data,igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', l_error_code, 8405));
195:
196: IF l_hash_msg_name_text_type_tab(l_msg_count-1).name <> 'ORA' THEN
197: IF p_enable_log = 'Y' THEN
198: igs_ad_imp_001.logerrormessage(notes_rec.interface_notes_id,l_msg_data,'IGS_AD_NOTES_INT');

Line 321: l_hash_msg_name_text_type_tab igs_ad_gen_016.g_msg_name_text_type_table;

317: l_return_status VARCHAR2(1);
318: l_error_text VARCHAR2(2000);
319: l_msg_count NUMBER ;
320: l_msg_data VARCHAR2(2000);
321: l_hash_msg_name_text_type_tab igs_ad_gen_016.g_msg_name_text_type_table;
322:
323: l_admission_cat igs_ad_appl.admission_cat%TYPE;
324: l_s_admission_process_type igs_ad_appl.s_admission_process_type%TYPE;
325:

Line 341: IF igs_ad_gen_016.get_appl_type_apc (p_application_type => edugoal_rec.admission_application_type,

337: l_records_processed := 0;
338:
339: FOR edugoal_rec IN c_igs_ad_edugoal_int
340: LOOP
341: IF igs_ad_gen_016.get_appl_type_apc (p_application_type => edugoal_rec.admission_application_type,
342: p_admission_cat => l_admission_cat,
343: p_s_admission_process_type => l_s_admission_process_type) = 'TRUE' THEN
344:
345: IF igs_ad_gen_016.get_apcs (p_admission_cat => l_admission_cat,

Line 345: IF igs_ad_gen_016.get_apcs (p_admission_cat => l_admission_cat,

341: IF igs_ad_gen_016.get_appl_type_apc (p_application_type => edugoal_rec.admission_application_type,
342: p_admission_cat => l_admission_cat,
343: p_s_admission_process_type => l_s_admission_process_type) = 'TRUE' THEN
344:
345: IF igs_ad_gen_016.get_apcs (p_admission_cat => l_admission_cat,
346: p_s_admission_process_type => l_s_admission_process_type,
347: p_s_admission_step_type => 'EDU-GOALS') = 'FALSE' THEN
348: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_NOT_APC_STEP');
349: FND_MESSAGE.SET_TOKEN ('CATEGORY', p_category_meaning);

Line 391: igs_ad_gen_016.extract_msg_from_stack (

387: WHEN OTHERS THEN
388: ROLLBACK TO before_create;
389: l_error_code := 'E322';
390: l_msg_data := SQLERRM;
391: igs_ad_gen_016.extract_msg_from_stack (
392: p_msg_at_index => l_msg_at_index,
393: p_return_status => l_return_status,
394: p_msg_count => l_msg_count,
395: p_msg_data => l_msg_data,

Line 398: l_error_text := NVL(l_msg_data,igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', l_error_code, 8405));

394: p_msg_count => l_msg_count,
395: p_msg_data => l_msg_data,
396: p_hash_msg_name_text_type_tab => l_hash_msg_name_text_type_tab);
397:
398: l_error_text := NVL(l_msg_data,igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', l_error_code, 8405));
399:
400: IF l_hash_msg_name_text_type_tab(l_msg_count-1).name <> 'ORA' THEN
401: IF p_enable_log = 'Y' THEN
402: igs_ad_imp_001.logerrormessage(edugoal_rec.interface_edugoal_id,l_msg_data,'IGS_AD_EDUGOAL_INT');

Line 551: l_hash_msg_name_text_type_tab igs_ad_gen_016.g_msg_name_text_type_table;

547: l_return_status VARCHAR2(1);
548: l_error_text VARCHAR2(2000);
549: l_msg_count NUMBER ;
550: l_msg_data VARCHAR2(2000);
551: l_hash_msg_name_text_type_tab igs_ad_gen_016.g_msg_name_text_type_table;
552:
553: l_records_processed NUMBER;
554: l_rowid VARCHAR2(30);
555: l_unit_set_id igs_ad_unit_sets.unit_set_id%TYPE;

Line 574: IF igs_ad_gen_016.get_appl_type_apc (p_application_type => unitsets_rec.admission_application_type,

570: l_records_processed := 0;
571:
572: FOR unitsets_rec IN c_igs_ad_unitsets_int
573: LOOP
574: IF igs_ad_gen_016.get_appl_type_apc (p_application_type => unitsets_rec.admission_application_type,
575: p_admission_cat => l_admission_cat,
576: p_s_admission_process_type => l_s_admission_process_type) = 'TRUE' THEN
577: IF igs_ad_gen_016.get_apcs (p_admission_cat => l_admission_cat,
578: p_s_admission_process_type => l_s_admission_process_type,

Line 577: IF igs_ad_gen_016.get_apcs (p_admission_cat => l_admission_cat,

573: LOOP
574: IF igs_ad_gen_016.get_appl_type_apc (p_application_type => unitsets_rec.admission_application_type,
575: p_admission_cat => l_admission_cat,
576: p_s_admission_process_type => l_s_admission_process_type) = 'TRUE' THEN
577: IF igs_ad_gen_016.get_apcs (p_admission_cat => l_admission_cat,
578: p_s_admission_process_type => l_s_admission_process_type,
579: p_s_admission_step_type => 'DES-UNITSETS') = 'FALSE' THEN
580:
581: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_NOT_APC_STEP');

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

651: ELSIF unitsets_rec.dmlmode = cst_update THEN
652: l_error_code := 'E014'; -- Update Failed
653: END IF;
654:
655: igs_ad_gen_016.extract_msg_from_stack (p_msg_at_index => l_msg_at_index,
656: p_return_status => l_return_status,
657: p_msg_count => l_msg_count,
658: p_msg_data => l_msg_data,
659: p_hash_msg_name_text_type_tab => l_hash_msg_name_text_type_tab);

Line 660: l_error_text := NVL(l_msg_data,igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', l_error_code, 8405));

656: p_return_status => l_return_status,
657: p_msg_count => l_msg_count,
658: p_msg_data => l_msg_data,
659: p_hash_msg_name_text_type_tab => l_hash_msg_name_text_type_tab);
660: l_error_text := NVL(l_msg_data,igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', l_error_code, 8405));
661:
662: IF l_hash_msg_name_text_type_tab(l_msg_count-1).name <> 'ORA' THEN
663: IF p_enable_log = 'Y' THEN
664: igs_ad_imp_001.logerrormessage(unitsets_rec.interface_unitsets_id,l_msg_data,'IGS_AD_UNITSETS_INT');