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_003 dependencies on FND_MESSAGE

Line 154: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_NOT_APC_STEP');

150: IF igs_ad_gen_016.get_apcs (p_admission_cat => l_admission_cat,
151: p_s_admission_process_type => l_s_admission_process_type,
152: p_s_admission_step_type => 'ACAD-INTEREST') = 'FALSE' THEN
153:
154: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_NOT_APC_STEP');
155: FND_MESSAGE.SET_TOKEN ('CATEGORY', p_category_meaning);
156: FND_MESSAGE.SET_TOKEN ('APPLTYPE', c_acadint_rec.admission_application_type);
157:
158: l_error_text := FND_MESSAGE.GET;

Line 155: FND_MESSAGE.SET_TOKEN ('CATEGORY', p_category_meaning);

151: p_s_admission_process_type => l_s_admission_process_type,
152: p_s_admission_step_type => 'ACAD-INTEREST') = 'FALSE' THEN
153:
154: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_NOT_APC_STEP');
155: FND_MESSAGE.SET_TOKEN ('CATEGORY', p_category_meaning);
156: FND_MESSAGE.SET_TOKEN ('APPLTYPE', c_acadint_rec.admission_application_type);
157:
158: l_error_text := FND_MESSAGE.GET;
159: l_error_text1 := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E701', 8405);

Line 156: FND_MESSAGE.SET_TOKEN ('APPLTYPE', c_acadint_rec.admission_application_type);

152: p_s_admission_step_type => 'ACAD-INTEREST') = 'FALSE' THEN
153:
154: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_NOT_APC_STEP');
155: FND_MESSAGE.SET_TOKEN ('CATEGORY', p_category_meaning);
156: FND_MESSAGE.SET_TOKEN ('APPLTYPE', c_acadint_rec.admission_application_type);
157:
158: l_error_text := FND_MESSAGE.GET;
159: l_error_text1 := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E701', 8405);
160:

Line 158: l_error_text := FND_MESSAGE.GET;

154: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_NOT_APC_STEP');
155: FND_MESSAGE.SET_TOKEN ('CATEGORY', p_category_meaning);
156: FND_MESSAGE.SET_TOKEN ('APPLTYPE', c_acadint_rec.admission_application_type);
157:
158: l_error_text := FND_MESSAGE.GET;
159: l_error_text1 := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E701', 8405);
160:
161: UPDATE igs_ad_acadint_int
162: SET status = cst_s_val_3,

Line 232: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_NOT_APC_STEP');

228: END IF;
229:
230: ELSE
231:
232: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_NOT_APC_STEP');
233: FND_MESSAGE.SET_TOKEN ('CATEGORY', p_category_meaning);
234: FND_MESSAGE.SET_TOKEN ('APPLTYPE', c_acadint_rec.admission_application_type);
235:
236: l_error_text := FND_MESSAGE.GET;

Line 233: FND_MESSAGE.SET_TOKEN ('CATEGORY', p_category_meaning);

229:
230: ELSE
231:
232: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_NOT_APC_STEP');
233: FND_MESSAGE.SET_TOKEN ('CATEGORY', p_category_meaning);
234: FND_MESSAGE.SET_TOKEN ('APPLTYPE', c_acadint_rec.admission_application_type);
235:
236: l_error_text := FND_MESSAGE.GET;
237: l_error_text1 := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E701', 8405);

Line 234: FND_MESSAGE.SET_TOKEN ('APPLTYPE', c_acadint_rec.admission_application_type);

230: ELSE
231:
232: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_NOT_APC_STEP');
233: FND_MESSAGE.SET_TOKEN ('CATEGORY', p_category_meaning);
234: FND_MESSAGE.SET_TOKEN ('APPLTYPE', c_acadint_rec.admission_application_type);
235:
236: l_error_text := FND_MESSAGE.GET;
237: l_error_text1 := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E701', 8405);
238:

Line 236: l_error_text := FND_MESSAGE.GET;

232: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_NOT_APC_STEP');
233: FND_MESSAGE.SET_TOKEN ('CATEGORY', p_category_meaning);
234: FND_MESSAGE.SET_TOKEN ('APPLTYPE', c_acadint_rec.admission_application_type);
235:
236: l_error_text := FND_MESSAGE.GET;
237: l_error_text1 := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E701', 8405);
238:
239: UPDATE igs_ad_acadint_int
240: SET status = cst_s_val_3,

Line 275: fnd_message.set_name('IGS','IGS_PE_IMP_DET_ERROR');

271:
272: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
273: l_label := 'igs.plsql.igs_ad_imp_003.prc_acad_int.exception '||'E322';
274:
275: fnd_message.set_name('IGS','IGS_PE_IMP_DET_ERROR');
276: fnd_message.set_token('CONTEXT',c_acadint_rec.interface_appl_id);
277: fnd_message.set_token('ERROR', l_error_text);
278:
279: l_debug_str := fnd_message.get;

Line 276: fnd_message.set_token('CONTEXT',c_acadint_rec.interface_appl_id);

272: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
273: l_label := 'igs.plsql.igs_ad_imp_003.prc_acad_int.exception '||'E322';
274:
275: fnd_message.set_name('IGS','IGS_PE_IMP_DET_ERROR');
276: fnd_message.set_token('CONTEXT',c_acadint_rec.interface_appl_id);
277: fnd_message.set_token('ERROR', l_error_text);
278:
279: l_debug_str := fnd_message.get;
280:

Line 277: fnd_message.set_token('ERROR', l_error_text);

273: l_label := 'igs.plsql.igs_ad_imp_003.prc_acad_int.exception '||'E322';
274:
275: fnd_message.set_name('IGS','IGS_PE_IMP_DET_ERROR');
276: fnd_message.set_token('CONTEXT',c_acadint_rec.interface_appl_id);
277: fnd_message.set_token('ERROR', l_error_text);
278:
279: l_debug_str := fnd_message.get;
280:
281: fnd_log.string_with_context( fnd_log.level_exception,l_label,l_debug_str, NULL,

Line 279: l_debug_str := fnd_message.get;

275: fnd_message.set_name('IGS','IGS_PE_IMP_DET_ERROR');
276: fnd_message.set_token('CONTEXT',c_acadint_rec.interface_appl_id);
277: fnd_message.set_token('ERROR', l_error_text);
278:
279: l_debug_str := fnd_message.get;
280:
281: fnd_log.string_with_context( fnd_log.level_exception,l_label,l_debug_str, NULL,
282: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
283: END IF;

Line 402: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_NOT_APC_STEP');

398: IF igs_ad_gen_016.get_apcs (p_admission_cat => l_admission_cat,
399: p_s_admission_process_type => l_s_admission_process_type,
400: p_s_admission_step_type => 'APPL-INTENT') = 'FALSE' THEN
401:
402: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_NOT_APC_STEP');
403: FND_MESSAGE.SET_TOKEN ('CATEGORY', p_category_meaning);
404: FND_MESSAGE.SET_TOKEN ('APPLTYPE', l_appint_rec.admission_application_type);
405: l_error_text := FND_MESSAGE.GET;
406: l_error_text1 := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E701', 8405);

Line 403: FND_MESSAGE.SET_TOKEN ('CATEGORY', p_category_meaning);

399: p_s_admission_process_type => l_s_admission_process_type,
400: p_s_admission_step_type => 'APPL-INTENT') = 'FALSE' THEN
401:
402: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_NOT_APC_STEP');
403: FND_MESSAGE.SET_TOKEN ('CATEGORY', p_category_meaning);
404: FND_MESSAGE.SET_TOKEN ('APPLTYPE', l_appint_rec.admission_application_type);
405: l_error_text := FND_MESSAGE.GET;
406: l_error_text1 := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E701', 8405);
407:

Line 404: FND_MESSAGE.SET_TOKEN ('APPLTYPE', l_appint_rec.admission_application_type);

400: p_s_admission_step_type => 'APPL-INTENT') = 'FALSE' THEN
401:
402: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_NOT_APC_STEP');
403: FND_MESSAGE.SET_TOKEN ('CATEGORY', p_category_meaning);
404: FND_MESSAGE.SET_TOKEN ('APPLTYPE', l_appint_rec.admission_application_type);
405: l_error_text := FND_MESSAGE.GET;
406: l_error_text1 := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E701', 8405);
407:
408: UPDATE igs_ad_appint_int

Line 405: l_error_text := FND_MESSAGE.GET;

401:
402: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_NOT_APC_STEP');
403: FND_MESSAGE.SET_TOKEN ('CATEGORY', p_category_meaning);
404: FND_MESSAGE.SET_TOKEN ('APPLTYPE', l_appint_rec.admission_application_type);
405: l_error_text := FND_MESSAGE.GET;
406: l_error_text1 := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E701', 8405);
407:
408: UPDATE igs_ad_appint_int
409: SET status = cst_s_val_3,

Line 535: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_NOT_APC_STEP');

531: END IF;
532: END IF;
533: ELSE
534:
535: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_NOT_APC_STEP');
536: FND_MESSAGE.SET_TOKEN ('CATEGORY', p_category_meaning);
537: FND_MESSAGE.SET_TOKEN ('APPLTYPE', l_appint_rec.admission_application_type);
538:
539: l_error_text := FND_MESSAGE.GET;

Line 536: FND_MESSAGE.SET_TOKEN ('CATEGORY', p_category_meaning);

532: END IF;
533: ELSE
534:
535: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_NOT_APC_STEP');
536: FND_MESSAGE.SET_TOKEN ('CATEGORY', p_category_meaning);
537: FND_MESSAGE.SET_TOKEN ('APPLTYPE', l_appint_rec.admission_application_type);
538:
539: l_error_text := FND_MESSAGE.GET;
540: l_error_text1 := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E701', 8405);

Line 537: FND_MESSAGE.SET_TOKEN ('APPLTYPE', l_appint_rec.admission_application_type);

533: ELSE
534:
535: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_NOT_APC_STEP');
536: FND_MESSAGE.SET_TOKEN ('CATEGORY', p_category_meaning);
537: FND_MESSAGE.SET_TOKEN ('APPLTYPE', l_appint_rec.admission_application_type);
538:
539: l_error_text := FND_MESSAGE.GET;
540: l_error_text1 := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E701', 8405);
541:

Line 539: l_error_text := FND_MESSAGE.GET;

535: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_NOT_APC_STEP');
536: FND_MESSAGE.SET_TOKEN ('CATEGORY', p_category_meaning);
537: FND_MESSAGE.SET_TOKEN ('APPLTYPE', l_appint_rec.admission_application_type);
538:
539: l_error_text := FND_MESSAGE.GET;
540: l_error_text1 := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E701', 8405);
541:
542: UPDATE igs_ad_appint_int
543: SET status = cst_s_val_3,

Line 580: fnd_message.set_name('IGS','IGS_PE_IMP_DET_ERROR');

576:
577: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
578: l_label := 'igs.plsql.igs_ad_imp_003.prc_acad_int.exception '||'E322';
579:
580: fnd_message.set_name('IGS','IGS_PE_IMP_DET_ERROR');
581: fnd_message.set_token('CONTEXT',l_appint_rec.interface_appl_id);
582: fnd_message.set_token('ERROR', l_error_text);
583:
584: l_debug_str := fnd_message.get;

Line 581: fnd_message.set_token('CONTEXT',l_appint_rec.interface_appl_id);

577: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
578: l_label := 'igs.plsql.igs_ad_imp_003.prc_acad_int.exception '||'E322';
579:
580: fnd_message.set_name('IGS','IGS_PE_IMP_DET_ERROR');
581: fnd_message.set_token('CONTEXT',l_appint_rec.interface_appl_id);
582: fnd_message.set_token('ERROR', l_error_text);
583:
584: l_debug_str := fnd_message.get;
585:

Line 582: fnd_message.set_token('ERROR', l_error_text);

578: l_label := 'igs.plsql.igs_ad_imp_003.prc_acad_int.exception '||'E322';
579:
580: fnd_message.set_name('IGS','IGS_PE_IMP_DET_ERROR');
581: fnd_message.set_token('CONTEXT',l_appint_rec.interface_appl_id);
582: fnd_message.set_token('ERROR', l_error_text);
583:
584: l_debug_str := fnd_message.get;
585:
586: fnd_log.string_with_context( fnd_log.level_exception,l_label,l_debug_str, NULL,

Line 584: l_debug_str := fnd_message.get;

580: fnd_message.set_name('IGS','IGS_PE_IMP_DET_ERROR');
581: fnd_message.set_token('CONTEXT',l_appint_rec.interface_appl_id);
582: fnd_message.set_token('ERROR', l_error_text);
583:
584: l_debug_str := fnd_message.get;
585:
586: fnd_log.string_with_context( fnd_log.level_exception,l_label,l_debug_str, NULL,
587: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
588: END IF;

Line 720: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_NOT_APC_STEP');

716: IF igs_ad_gen_016.get_apcs (p_admission_cat => l_admission_cat,
717: p_s_admission_process_type => l_s_admission_process_type,
718: p_s_admission_step_type => 'OTH-INST-APPL') = 'FALSE' THEN
719:
720: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_NOT_APC_STEP');
721: FND_MESSAGE.SET_TOKEN ('CATEGORY', p_category_meaning);
722: FND_MESSAGE.SET_TOKEN ('APPLTYPE', l_oth_inst_rec.admission_application_type);
723:
724: l_error_text := FND_MESSAGE.GET;

Line 721: FND_MESSAGE.SET_TOKEN ('CATEGORY', p_category_meaning);

717: p_s_admission_process_type => l_s_admission_process_type,
718: p_s_admission_step_type => 'OTH-INST-APPL') = 'FALSE' THEN
719:
720: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_NOT_APC_STEP');
721: FND_MESSAGE.SET_TOKEN ('CATEGORY', p_category_meaning);
722: FND_MESSAGE.SET_TOKEN ('APPLTYPE', l_oth_inst_rec.admission_application_type);
723:
724: l_error_text := FND_MESSAGE.GET;
725: l_error_text1 := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E701', 8405);

Line 722: FND_MESSAGE.SET_TOKEN ('APPLTYPE', l_oth_inst_rec.admission_application_type);

718: p_s_admission_step_type => 'OTH-INST-APPL') = 'FALSE' THEN
719:
720: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_NOT_APC_STEP');
721: FND_MESSAGE.SET_TOKEN ('CATEGORY', p_category_meaning);
722: FND_MESSAGE.SET_TOKEN ('APPLTYPE', l_oth_inst_rec.admission_application_type);
723:
724: l_error_text := FND_MESSAGE.GET;
725: l_error_text1 := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E701', 8405);
726:

Line 724: l_error_text := FND_MESSAGE.GET;

720: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_NOT_APC_STEP');
721: FND_MESSAGE.SET_TOKEN ('CATEGORY', p_category_meaning);
722: FND_MESSAGE.SET_TOKEN ('APPLTYPE', l_oth_inst_rec.admission_application_type);
723:
724: l_error_text := FND_MESSAGE.GET;
725: l_error_text1 := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E701', 8405);
726:
727: UPDATE igs_ad_othinst_int
728: SET status = cst_s_val_3,

Line 796: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_NOT_APC_STEP');

792:
793: END IF;
794:
795: ELSE
796: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_NOT_APC_STEP');
797: FND_MESSAGE.SET_TOKEN ('CATEGORY', p_category_meaning);
798: FND_MESSAGE.SET_TOKEN ('APPLTYPE', l_oth_inst_rec.admission_application_type);
799:
800: l_error_text := FND_MESSAGE.GET;

Line 797: FND_MESSAGE.SET_TOKEN ('CATEGORY', p_category_meaning);

793: END IF;
794:
795: ELSE
796: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_NOT_APC_STEP');
797: FND_MESSAGE.SET_TOKEN ('CATEGORY', p_category_meaning);
798: FND_MESSAGE.SET_TOKEN ('APPLTYPE', l_oth_inst_rec.admission_application_type);
799:
800: l_error_text := FND_MESSAGE.GET;
801: l_error_text1 := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E701', 8405);

Line 798: FND_MESSAGE.SET_TOKEN ('APPLTYPE', l_oth_inst_rec.admission_application_type);

794:
795: ELSE
796: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_NOT_APC_STEP');
797: FND_MESSAGE.SET_TOKEN ('CATEGORY', p_category_meaning);
798: FND_MESSAGE.SET_TOKEN ('APPLTYPE', l_oth_inst_rec.admission_application_type);
799:
800: l_error_text := FND_MESSAGE.GET;
801: l_error_text1 := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E701', 8405);
802:

Line 800: l_error_text := FND_MESSAGE.GET;

796: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_NOT_APC_STEP');
797: FND_MESSAGE.SET_TOKEN ('CATEGORY', p_category_meaning);
798: FND_MESSAGE.SET_TOKEN ('APPLTYPE', l_oth_inst_rec.admission_application_type);
799:
800: l_error_text := FND_MESSAGE.GET;
801: l_error_text1 := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E701', 8405);
802:
803: UPDATE igs_ad_othinst_int
804: SET status = cst_s_val_3,

Line 836: fnd_message.set_name('IGS','IGS_PE_IMP_DET_ERROR');

832: ELSE
833: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
834: l_label := 'igs.plsql.igs_ad_imp_003.prc_apcnt_oth_inst_apld.exception '||'E322';
835:
836: fnd_message.set_name('IGS','IGS_PE_IMP_DET_ERROR');
837: fnd_message.set_token('CONTEXT',l_oth_inst_rec.interface_appl_id);
838: fnd_message.set_token('ERROR', l_error_text);
839:
840: l_debug_str := fnd_message.get;

Line 837: fnd_message.set_token('CONTEXT',l_oth_inst_rec.interface_appl_id);

833: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
834: l_label := 'igs.plsql.igs_ad_imp_003.prc_apcnt_oth_inst_apld.exception '||'E322';
835:
836: fnd_message.set_name('IGS','IGS_PE_IMP_DET_ERROR');
837: fnd_message.set_token('CONTEXT',l_oth_inst_rec.interface_appl_id);
838: fnd_message.set_token('ERROR', l_error_text);
839:
840: l_debug_str := fnd_message.get;
841:

Line 838: fnd_message.set_token('ERROR', l_error_text);

834: l_label := 'igs.plsql.igs_ad_imp_003.prc_apcnt_oth_inst_apld.exception '||'E322';
835:
836: fnd_message.set_name('IGS','IGS_PE_IMP_DET_ERROR');
837: fnd_message.set_token('CONTEXT',l_oth_inst_rec.interface_appl_id);
838: fnd_message.set_token('ERROR', l_error_text);
839:
840: l_debug_str := fnd_message.get;
841:
842: fnd_log.string_with_context( fnd_log.level_exception,l_label,l_debug_str, NULL,

Line 840: l_debug_str := fnd_message.get;

836: fnd_message.set_name('IGS','IGS_PE_IMP_DET_ERROR');
837: fnd_message.set_token('CONTEXT',l_oth_inst_rec.interface_appl_id);
838: fnd_message.set_token('ERROR', l_error_text);
839:
840: l_debug_str := fnd_message.get;
841:
842: fnd_log.string_with_context( fnd_log.level_exception,l_label,l_debug_str, NULL,
843: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
844: END IF;

Line 957: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_NOT_APC_STEP');

953: IF igs_ad_gen_016.get_apcs (p_admission_cat => l_admission_cat,
954: p_s_admission_process_type => l_s_admission_process_type,
955: p_s_admission_step_type => 'SPL-INTEREST') = 'FALSE' THEN
956:
957: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_NOT_APC_STEP');
958: FND_MESSAGE.SET_TOKEN ('CATEGORY', p_category_meaning);
959: FND_MESSAGE.SET_TOKEN ('APPLTYPE', l_spl_intrst_rec.admission_application_type);
960:
961: l_error_text := FND_MESSAGE.GET;

Line 958: FND_MESSAGE.SET_TOKEN ('CATEGORY', p_category_meaning);

954: p_s_admission_process_type => l_s_admission_process_type,
955: p_s_admission_step_type => 'SPL-INTEREST') = 'FALSE' THEN
956:
957: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_NOT_APC_STEP');
958: FND_MESSAGE.SET_TOKEN ('CATEGORY', p_category_meaning);
959: FND_MESSAGE.SET_TOKEN ('APPLTYPE', l_spl_intrst_rec.admission_application_type);
960:
961: l_error_text := FND_MESSAGE.GET;
962: l_error_text1 := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E701', 8405);

Line 959: FND_MESSAGE.SET_TOKEN ('APPLTYPE', l_spl_intrst_rec.admission_application_type);

955: p_s_admission_step_type => 'SPL-INTEREST') = 'FALSE' THEN
956:
957: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_NOT_APC_STEP');
958: FND_MESSAGE.SET_TOKEN ('CATEGORY', p_category_meaning);
959: FND_MESSAGE.SET_TOKEN ('APPLTYPE', l_spl_intrst_rec.admission_application_type);
960:
961: l_error_text := FND_MESSAGE.GET;
962: l_error_text1 := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E701', 8405);
963:

Line 961: l_error_text := FND_MESSAGE.GET;

957: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_NOT_APC_STEP');
958: FND_MESSAGE.SET_TOKEN ('CATEGORY', p_category_meaning);
959: FND_MESSAGE.SET_TOKEN ('APPLTYPE', l_spl_intrst_rec.admission_application_type);
960:
961: l_error_text := FND_MESSAGE.GET;
962: l_error_text1 := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E701', 8405);
963:
964: UPDATE igs_ad_splint_int
965: SET status = cst_s_val_3,

Line 1033: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_NOT_APC_STEP');

1029: END IF;
1030:
1031: ELSE
1032:
1033: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_NOT_APC_STEP');
1034: FND_MESSAGE.SET_TOKEN ('CATEGORY', p_category_meaning);
1035: FND_MESSAGE.SET_TOKEN ('APPLTYPE', l_spl_intrst_rec.admission_application_type);
1036:
1037: l_error_text := FND_MESSAGE.GET;

Line 1034: FND_MESSAGE.SET_TOKEN ('CATEGORY', p_category_meaning);

1030:
1031: ELSE
1032:
1033: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_NOT_APC_STEP');
1034: FND_MESSAGE.SET_TOKEN ('CATEGORY', p_category_meaning);
1035: FND_MESSAGE.SET_TOKEN ('APPLTYPE', l_spl_intrst_rec.admission_application_type);
1036:
1037: l_error_text := FND_MESSAGE.GET;
1038: l_error_text1 := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E701', 8405);

Line 1035: FND_MESSAGE.SET_TOKEN ('APPLTYPE', l_spl_intrst_rec.admission_application_type);

1031: ELSE
1032:
1033: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_NOT_APC_STEP');
1034: FND_MESSAGE.SET_TOKEN ('CATEGORY', p_category_meaning);
1035: FND_MESSAGE.SET_TOKEN ('APPLTYPE', l_spl_intrst_rec.admission_application_type);
1036:
1037: l_error_text := FND_MESSAGE.GET;
1038: l_error_text1 := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E701', 8405);
1039:

Line 1037: l_error_text := FND_MESSAGE.GET;

1033: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_NOT_APC_STEP');
1034: FND_MESSAGE.SET_TOKEN ('CATEGORY', p_category_meaning);
1035: FND_MESSAGE.SET_TOKEN ('APPLTYPE', l_spl_intrst_rec.admission_application_type);
1036:
1037: l_error_text := FND_MESSAGE.GET;
1038: l_error_text1 := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E701', 8405);
1039:
1040: UPDATE igs_ad_splint_int
1041: SET status = cst_s_val_3,

Line 1076: fnd_message.set_name('IGS','IGS_PE_IMP_DET_ERROR');

1072:
1073: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
1074: l_label := 'igs.plsql.igs_ad_imp_003.prc_apcnt_spl_intrst.exception '||'E322';
1075:
1076: fnd_message.set_name('IGS','IGS_PE_IMP_DET_ERROR');
1077: fnd_message.set_token('CONTEXT',l_spl_intrst_rec.interface_appl_id);
1078: fnd_message.set_token('ERROR', l_error_text);
1079:
1080: l_debug_str := fnd_message.get;

Line 1077: fnd_message.set_token('CONTEXT',l_spl_intrst_rec.interface_appl_id);

1073: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
1074: l_label := 'igs.plsql.igs_ad_imp_003.prc_apcnt_spl_intrst.exception '||'E322';
1075:
1076: fnd_message.set_name('IGS','IGS_PE_IMP_DET_ERROR');
1077: fnd_message.set_token('CONTEXT',l_spl_intrst_rec.interface_appl_id);
1078: fnd_message.set_token('ERROR', l_error_text);
1079:
1080: l_debug_str := fnd_message.get;
1081:

Line 1078: fnd_message.set_token('ERROR', l_error_text);

1074: l_label := 'igs.plsql.igs_ad_imp_003.prc_apcnt_spl_intrst.exception '||'E322';
1075:
1076: fnd_message.set_name('IGS','IGS_PE_IMP_DET_ERROR');
1077: fnd_message.set_token('CONTEXT',l_spl_intrst_rec.interface_appl_id);
1078: fnd_message.set_token('ERROR', l_error_text);
1079:
1080: l_debug_str := fnd_message.get;
1081:
1082: fnd_log.string_with_context( fnd_log.level_exception,l_label,l_debug_str, NULL,

Line 1080: l_debug_str := fnd_message.get;

1076: fnd_message.set_name('IGS','IGS_PE_IMP_DET_ERROR');
1077: fnd_message.set_token('CONTEXT',l_spl_intrst_rec.interface_appl_id);
1078: fnd_message.set_token('ERROR', l_error_text);
1079:
1080: l_debug_str := fnd_message.get;
1081:
1082: fnd_log.string_with_context( fnd_log.level_exception,l_label,l_debug_str, NULL,
1083: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
1084: END IF;

Line 1195: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_NOT_APC_STEP');

1191: IF igs_ad_gen_016.get_apcs (p_admission_cat => l_admission_cat,
1192: p_s_admission_process_type => l_s_admission_process_type,
1193: p_s_admission_step_type => 'SPL-TALENT') = 'FALSE' THEN
1194:
1195: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_NOT_APC_STEP');
1196: FND_MESSAGE.SET_TOKEN ('CATEGORY', p_category_meaning);
1197: FND_MESSAGE.SET_TOKEN ('APPLTYPE', l_spl_tal_rec.admission_application_type);
1198:
1199: l_error_text := FND_MESSAGE.GET;

Line 1196: FND_MESSAGE.SET_TOKEN ('CATEGORY', p_category_meaning);

1192: p_s_admission_process_type => l_s_admission_process_type,
1193: p_s_admission_step_type => 'SPL-TALENT') = 'FALSE' THEN
1194:
1195: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_NOT_APC_STEP');
1196: FND_MESSAGE.SET_TOKEN ('CATEGORY', p_category_meaning);
1197: FND_MESSAGE.SET_TOKEN ('APPLTYPE', l_spl_tal_rec.admission_application_type);
1198:
1199: l_error_text := FND_MESSAGE.GET;
1200: l_error_text1 := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E701', 8405);

Line 1197: FND_MESSAGE.SET_TOKEN ('APPLTYPE', l_spl_tal_rec.admission_application_type);

1193: p_s_admission_step_type => 'SPL-TALENT') = 'FALSE' THEN
1194:
1195: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_NOT_APC_STEP');
1196: FND_MESSAGE.SET_TOKEN ('CATEGORY', p_category_meaning);
1197: FND_MESSAGE.SET_TOKEN ('APPLTYPE', l_spl_tal_rec.admission_application_type);
1198:
1199: l_error_text := FND_MESSAGE.GET;
1200: l_error_text1 := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E701', 8405);
1201:

Line 1199: l_error_text := FND_MESSAGE.GET;

1195: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_NOT_APC_STEP');
1196: FND_MESSAGE.SET_TOKEN ('CATEGORY', p_category_meaning);
1197: FND_MESSAGE.SET_TOKEN ('APPLTYPE', l_spl_tal_rec.admission_application_type);
1198:
1199: l_error_text := FND_MESSAGE.GET;
1200: l_error_text1 := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E701', 8405);
1201:
1202: UPDATE igs_ad_spltal_int
1203: SET status = cst_s_val_3,

Line 1268: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_NOT_APC_STEP');

1264: END IF;
1265:
1266: ELSE
1267:
1268: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_NOT_APC_STEP');
1269: FND_MESSAGE.SET_TOKEN ('CATEGORY', p_category_meaning);
1270: FND_MESSAGE.SET_TOKEN ('APPLTYPE', l_spl_tal_rec.admission_application_type);
1271:
1272: l_error_text := FND_MESSAGE.GET;

Line 1269: FND_MESSAGE.SET_TOKEN ('CATEGORY', p_category_meaning);

1265:
1266: ELSE
1267:
1268: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_NOT_APC_STEP');
1269: FND_MESSAGE.SET_TOKEN ('CATEGORY', p_category_meaning);
1270: FND_MESSAGE.SET_TOKEN ('APPLTYPE', l_spl_tal_rec.admission_application_type);
1271:
1272: l_error_text := FND_MESSAGE.GET;
1273: l_error_text1 := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E701', 8405);

Line 1270: FND_MESSAGE.SET_TOKEN ('APPLTYPE', l_spl_tal_rec.admission_application_type);

1266: ELSE
1267:
1268: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_NOT_APC_STEP');
1269: FND_MESSAGE.SET_TOKEN ('CATEGORY', p_category_meaning);
1270: FND_MESSAGE.SET_TOKEN ('APPLTYPE', l_spl_tal_rec.admission_application_type);
1271:
1272: l_error_text := FND_MESSAGE.GET;
1273: l_error_text1 := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E701', 8405);
1274:

Line 1272: l_error_text := FND_MESSAGE.GET;

1268: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_NOT_APC_STEP');
1269: FND_MESSAGE.SET_TOKEN ('CATEGORY', p_category_meaning);
1270: FND_MESSAGE.SET_TOKEN ('APPLTYPE', l_spl_tal_rec.admission_application_type);
1271:
1272: l_error_text := FND_MESSAGE.GET;
1273: l_error_text1 := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E701', 8405);
1274:
1275: UPDATE igs_ad_spltal_int
1276: SET status = cst_s_val_3,

Line 1312: fnd_message.set_name('IGS','IGS_PE_IMP_DET_ERROR');

1308:
1309: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
1310: l_label := 'igs.plsql.igs_ad_imp_003.prc_apcnt_spl_tal.exception '||'E322';
1311:
1312: fnd_message.set_name('IGS','IGS_PE_IMP_DET_ERROR');
1313: fnd_message.set_token('CONTEXT',l_spl_tal_rec.interface_appl_id);
1314: fnd_message.set_token('ERROR', l_error_text);
1315:
1316: l_debug_str := fnd_message.get;

Line 1313: fnd_message.set_token('CONTEXT',l_spl_tal_rec.interface_appl_id);

1309: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
1310: l_label := 'igs.plsql.igs_ad_imp_003.prc_apcnt_spl_tal.exception '||'E322';
1311:
1312: fnd_message.set_name('IGS','IGS_PE_IMP_DET_ERROR');
1313: fnd_message.set_token('CONTEXT',l_spl_tal_rec.interface_appl_id);
1314: fnd_message.set_token('ERROR', l_error_text);
1315:
1316: l_debug_str := fnd_message.get;
1317:

Line 1314: fnd_message.set_token('ERROR', l_error_text);

1310: l_label := 'igs.plsql.igs_ad_imp_003.prc_apcnt_spl_tal.exception '||'E322';
1311:
1312: fnd_message.set_name('IGS','IGS_PE_IMP_DET_ERROR');
1313: fnd_message.set_token('CONTEXT',l_spl_tal_rec.interface_appl_id);
1314: fnd_message.set_token('ERROR', l_error_text);
1315:
1316: l_debug_str := fnd_message.get;
1317:
1318: fnd_log.string_with_context( fnd_log.level_exception,l_label,l_debug_str, NULL,

Line 1316: l_debug_str := fnd_message.get;

1312: fnd_message.set_name('IGS','IGS_PE_IMP_DET_ERROR');
1313: fnd_message.set_token('CONTEXT',l_spl_tal_rec.interface_appl_id);
1314: fnd_message.set_token('ERROR', l_error_text);
1315:
1316: l_debug_str := fnd_message.get;
1317:
1318: fnd_log.string_with_context( fnd_log.level_exception,l_label,l_debug_str, NULL,
1319: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
1320: END IF;

Line 1507: fnd_message.set_name('IGS','IGS_PE_IMP_DET_ERROR');

1503:
1504: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
1505: l_label := 'igs.plsql.igs_ad_imp_003.prc_persstat_details.exception '||'E322';
1506:
1507: fnd_message.set_name('IGS','IGS_PE_IMP_DET_ERROR');
1508: fnd_message.set_token('CONTEXT',l_appl_pers_rec.interface_appl_id);
1509: fnd_message.set_token('ERROR', l_error_text);
1510:
1511: l_debug_str := fnd_message.get;

Line 1508: fnd_message.set_token('CONTEXT',l_appl_pers_rec.interface_appl_id);

1504: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
1505: l_label := 'igs.plsql.igs_ad_imp_003.prc_persstat_details.exception '||'E322';
1506:
1507: fnd_message.set_name('IGS','IGS_PE_IMP_DET_ERROR');
1508: fnd_message.set_token('CONTEXT',l_appl_pers_rec.interface_appl_id);
1509: fnd_message.set_token('ERROR', l_error_text);
1510:
1511: l_debug_str := fnd_message.get;
1512:

Line 1509: fnd_message.set_token('ERROR', l_error_text);

1505: l_label := 'igs.plsql.igs_ad_imp_003.prc_persstat_details.exception '||'E322';
1506:
1507: fnd_message.set_name('IGS','IGS_PE_IMP_DET_ERROR');
1508: fnd_message.set_token('CONTEXT',l_appl_pers_rec.interface_appl_id);
1509: fnd_message.set_token('ERROR', l_error_text);
1510:
1511: l_debug_str := fnd_message.get;
1512:
1513: fnd_log.string_with_context( fnd_log.level_exception,l_label,l_debug_str, NULL,

Line 1511: l_debug_str := fnd_message.get;

1507: fnd_message.set_name('IGS','IGS_PE_IMP_DET_ERROR');
1508: fnd_message.set_token('CONTEXT',l_appl_pers_rec.interface_appl_id);
1509: fnd_message.set_token('ERROR', l_error_text);
1510:
1511: l_debug_str := fnd_message.get;
1512:
1513: fnd_log.string_with_context( fnd_log.level_exception,l_label,l_debug_str, NULL,
1514: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
1515: END IF;

Line 1783: fnd_message.set_name('IGS','IGS_PE_IMP_DET_ERROR');

1779:
1780: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
1781: l_label := 'igs.plsql.igs_ad_imp_003.prc_acad_int.exception '||l_error_code;
1782:
1783: fnd_message.set_name('IGS','IGS_PE_IMP_DET_ERROR');
1784: fnd_message.set_token('CONTEXT',l_fee_int_rec.interface_appl_id);
1785: fnd_message.set_token('ERROR', l_error_text);
1786:
1787: l_debug_str := fnd_message.get;

Line 1784: fnd_message.set_token('CONTEXT',l_fee_int_rec.interface_appl_id);

1780: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
1781: l_label := 'igs.plsql.igs_ad_imp_003.prc_acad_int.exception '||l_error_code;
1782:
1783: fnd_message.set_name('IGS','IGS_PE_IMP_DET_ERROR');
1784: fnd_message.set_token('CONTEXT',l_fee_int_rec.interface_appl_id);
1785: fnd_message.set_token('ERROR', l_error_text);
1786:
1787: l_debug_str := fnd_message.get;
1788:

Line 1785: fnd_message.set_token('ERROR', l_error_text);

1781: l_label := 'igs.plsql.igs_ad_imp_003.prc_acad_int.exception '||l_error_code;
1782:
1783: fnd_message.set_name('IGS','IGS_PE_IMP_DET_ERROR');
1784: fnd_message.set_token('CONTEXT',l_fee_int_rec.interface_appl_id);
1785: fnd_message.set_token('ERROR', l_error_text);
1786:
1787: l_debug_str := fnd_message.get;
1788:
1789: fnd_log.string_with_context( fnd_log.level_exception,l_label,l_debug_str, NULL,

Line 1787: l_debug_str := fnd_message.get;

1783: fnd_message.set_name('IGS','IGS_PE_IMP_DET_ERROR');
1784: fnd_message.set_token('CONTEXT',l_fee_int_rec.interface_appl_id);
1785: fnd_message.set_token('ERROR', l_error_text);
1786:
1787: l_debug_str := fnd_message.get;
1788:
1789: fnd_log.string_with_context( fnd_log.level_exception,l_label,l_debug_str, NULL,
1790: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
1791: END IF;