DBA Data[Home] [Help]

APPS.IGS_AD_INT_RECONSIDER dependencies on FND_MESSAGE

Line 408: FND_MESSAGE.SET_NAME('IGS','IGS_AD_CAND_COPY_FAIL');

404: RETURN TRUE;
405:
406: EXCEPTION WHEN OTHERS THEN
407:
408: FND_MESSAGE.SET_NAME('IGS','IGS_AD_CAND_COPY_FAIL');
409: Fnd_File.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
410:
411: FND_MESSAGE.SET_NAME('IGS',v_message_name);
412: fnd_file.put_line(FND_FILE.LOG, FND_MESSAGE.GET || SQLERRM);

Line 409: Fnd_File.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

405:
406: EXCEPTION WHEN OTHERS THEN
407:
408: FND_MESSAGE.SET_NAME('IGS','IGS_AD_CAND_COPY_FAIL');
409: Fnd_File.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
410:
411: FND_MESSAGE.SET_NAME('IGS',v_message_name);
412: fnd_file.put_line(FND_FILE.LOG, FND_MESSAGE.GET || SQLERRM);
413:

Line 411: FND_MESSAGE.SET_NAME('IGS',v_message_name);

407:
408: FND_MESSAGE.SET_NAME('IGS','IGS_AD_CAND_COPY_FAIL');
409: Fnd_File.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
410:
411: FND_MESSAGE.SET_NAME('IGS',v_message_name);
412: fnd_file.put_line(FND_FILE.LOG, FND_MESSAGE.GET || SQLERRM);
413:
414: RETURN FALSE;
415:

Line 412: fnd_file.put_line(FND_FILE.LOG, FND_MESSAGE.GET || SQLERRM);

408: FND_MESSAGE.SET_NAME('IGS','IGS_AD_CAND_COPY_FAIL');
409: Fnd_File.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
410:
411: FND_MESSAGE.SET_NAME('IGS',v_message_name);
412: fnd_file.put_line(FND_FILE.LOG, FND_MESSAGE.GET || SQLERRM);
413:
414: RETURN FALSE;
415:
416: END copy_candidacy_records;

Line 745: FND_MESSAGE.SET_NAME('IGS','IGS_AD_CHILD_COPY_FAILED');

741: fnd_file.put_line(fnd_file.log, 'Application Instance Creation Failed for Person ID: '|| RPAD(p_person_id,15,' ') || '; Admission Application Number: ' ||
742: RPAD(p_old_admission_appl_number,2,' ') || '; Course Code: ' || RPAD(p_nominated_course_cd,6,' ') || '; Sequence Number: '||
743: RPAD(p_sequence_number,6,' ') || ' Reason: ');
744:
745: FND_MESSAGE.SET_NAME('IGS','IGS_AD_CHILD_COPY_FAILED');
746: Fnd_File.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
747:
748: FND_MESSAGE.SET_NAME('IGS',l_last_error);
749: fnd_file.put_line(FND_FILE.LOG, FND_MESSAGE.GET || SQLERRM);

Line 746: Fnd_File.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

742: RPAD(p_old_admission_appl_number,2,' ') || '; Course Code: ' || RPAD(p_nominated_course_cd,6,' ') || '; Sequence Number: '||
743: RPAD(p_sequence_number,6,' ') || ' Reason: ');
744:
745: FND_MESSAGE.SET_NAME('IGS','IGS_AD_CHILD_COPY_FAILED');
746: Fnd_File.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
747:
748: FND_MESSAGE.SET_NAME('IGS',l_last_error);
749: fnd_file.put_line(FND_FILE.LOG, FND_MESSAGE.GET || SQLERRM);
750:

Line 748: FND_MESSAGE.SET_NAME('IGS',l_last_error);

744:
745: FND_MESSAGE.SET_NAME('IGS','IGS_AD_CHILD_COPY_FAILED');
746: Fnd_File.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
747:
748: FND_MESSAGE.SET_NAME('IGS',l_last_error);
749: fnd_file.put_line(FND_FILE.LOG, FND_MESSAGE.GET || SQLERRM);
750:
751: RETURN FALSE;
752: END copy_application_child_records;

Line 749: fnd_file.put_line(FND_FILE.LOG, FND_MESSAGE.GET || SQLERRM);

745: FND_MESSAGE.SET_NAME('IGS','IGS_AD_CHILD_COPY_FAILED');
746: Fnd_File.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
747:
748: FND_MESSAGE.SET_NAME('IGS',l_last_error);
749: fnd_file.put_line(FND_FILE.LOG, FND_MESSAGE.GET || SQLERRM);
750:
751: RETURN FALSE;
752: END copy_application_child_records;
753:

Line 1386: FND_MESSAGE.SET_NAME('IGS','IGS_AD_CHILD_COPY_FAILED');

1382: fnd_file.put_line(fnd_file.log, 'Application Instance Creation Failed for Person ID: '|| RPAD(p_person_id,15,' ') || '; Admission Application Number: ' ||
1383: RPAD(p_old_admission_appl_number,2,' ') || '; Course Code: ' || RPAD(p_nominated_course_cd,6,' ') || '; Sequence Number: '||
1384: RPAD(p_old_sequence_number,6,' ') || ' Reason: ');
1385:
1386: FND_MESSAGE.SET_NAME('IGS','IGS_AD_CHILD_COPY_FAILED');
1387: Fnd_File.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
1388:
1389: FND_MESSAGE.SET_NAME('IGS',l_last_error);
1390: fnd_file.put_line(FND_FILE.LOG, FND_MESSAGE.GET || SQLERRM);

Line 1387: Fnd_File.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

1383: RPAD(p_old_admission_appl_number,2,' ') || '; Course Code: ' || RPAD(p_nominated_course_cd,6,' ') || '; Sequence Number: '||
1384: RPAD(p_old_sequence_number,6,' ') || ' Reason: ');
1385:
1386: FND_MESSAGE.SET_NAME('IGS','IGS_AD_CHILD_COPY_FAILED');
1387: Fnd_File.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
1388:
1389: FND_MESSAGE.SET_NAME('IGS',l_last_error);
1390: fnd_file.put_line(FND_FILE.LOG, FND_MESSAGE.GET || SQLERRM);
1391:

Line 1389: FND_MESSAGE.SET_NAME('IGS',l_last_error);

1385:
1386: FND_MESSAGE.SET_NAME('IGS','IGS_AD_CHILD_COPY_FAILED');
1387: Fnd_File.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
1388:
1389: FND_MESSAGE.SET_NAME('IGS',l_last_error);
1390: fnd_file.put_line(FND_FILE.LOG, FND_MESSAGE.GET || SQLERRM);
1391:
1392: RETURN FALSE;
1393: END copy_instance_child_records;

Line 1390: fnd_file.put_line(FND_FILE.LOG, FND_MESSAGE.GET || SQLERRM);

1386: FND_MESSAGE.SET_NAME('IGS','IGS_AD_CHILD_COPY_FAILED');
1387: Fnd_File.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
1388:
1389: FND_MESSAGE.SET_NAME('IGS',l_last_error);
1390: fnd_file.put_line(FND_FILE.LOG, FND_MESSAGE.GET || SQLERRM);
1391:
1392: RETURN FALSE;
1393: END copy_instance_child_records;
1394:

Line 1833: fnd_message.set_name('IGS', 'Failed to update the Request for Reconsideration Checkbox: ' || SQLERRM );

1829: ROLLBACK TO c_create_application;
1830: fnd_file.put_line(fnd_file.log, 'Application Instance Creation Failed for Person ID: '|| RPAD(l_appl_inst_rec.person_id,15,' ') || '; Admission Application Number: ' ||
1831: RPAD(l_appl_inst_rec.admission_appl_number,2,' ') || '; Course Code: ' || RPAD(l_appl_inst_rec.nominated_course_cd,6,' ') || '; Sequence Number: '||
1832: RPAD(l_appl_inst_rec.sequence_number,6,' ') || ' Reason: ');
1833: fnd_message.set_name('IGS', 'Failed to update the Request for Reconsideration Checkbox: ' || SQLERRM );
1834: l_program_created := FALSE;
1835:
1836: END;
1837:

Line 2351: fnd_message.set_name('IGS', l_message_name);

2347:
2348: IF l_message_name IN ('IGS_AD_NOMINATE_PRG_OFR_ENTRY', 'IGS_AD_NOMINATED_PRG_ENTRYPNT') THEN
2349:
2350: l_message_name := 'IGS_AD_CAL_PGM_NOT_OFFER';
2351: fnd_message.set_name('IGS', l_message_name);
2352: fnd_message.set_token('PGM', l_appl_inst_rec.nominated_course_cd);
2353: fnd_message.set_token('ALTCODE',l_appl_inst_rec.future_acad_cal_type||','||
2354: IGS_GE_NUMBER.TO_CANN(l_appl_inst_rec.future_acad_ci_sequence_number)
2355: ||'/'||l_appl_inst_rec.future_adm_cal_type||','||

Line 2352: fnd_message.set_token('PGM', l_appl_inst_rec.nominated_course_cd);

2348: IF l_message_name IN ('IGS_AD_NOMINATE_PRG_OFR_ENTRY', 'IGS_AD_NOMINATED_PRG_ENTRYPNT') THEN
2349:
2350: l_message_name := 'IGS_AD_CAL_PGM_NOT_OFFER';
2351: fnd_message.set_name('IGS', l_message_name);
2352: fnd_message.set_token('PGM', l_appl_inst_rec.nominated_course_cd);
2353: fnd_message.set_token('ALTCODE',l_appl_inst_rec.future_acad_cal_type||','||
2354: IGS_GE_NUMBER.TO_CANN(l_appl_inst_rec.future_acad_ci_sequence_number)
2355: ||'/'||l_appl_inst_rec.future_adm_cal_type||','||
2356: IGS_GE_NUMBER.TO_CANN(l_appl_inst_rec.future_adm_ci_sequence_number));

Line 2353: fnd_message.set_token('ALTCODE',l_appl_inst_rec.future_acad_cal_type||','||

2349:
2350: l_message_name := 'IGS_AD_CAL_PGM_NOT_OFFER';
2351: fnd_message.set_name('IGS', l_message_name);
2352: fnd_message.set_token('PGM', l_appl_inst_rec.nominated_course_cd);
2353: fnd_message.set_token('ALTCODE',l_appl_inst_rec.future_acad_cal_type||','||
2354: IGS_GE_NUMBER.TO_CANN(l_appl_inst_rec.future_acad_ci_sequence_number)
2355: ||'/'||l_appl_inst_rec.future_adm_cal_type||','||
2356: IGS_GE_NUMBER.TO_CANN(l_appl_inst_rec.future_adm_ci_sequence_number));
2357: fnd_file.put_line(fnd_file.log, fnd_message.get);

Line 2357: fnd_file.put_line(fnd_file.log, fnd_message.get);

2353: fnd_message.set_token('ALTCODE',l_appl_inst_rec.future_acad_cal_type||','||
2354: IGS_GE_NUMBER.TO_CANN(l_appl_inst_rec.future_acad_ci_sequence_number)
2355: ||'/'||l_appl_inst_rec.future_adm_cal_type||','||
2356: IGS_GE_NUMBER.TO_CANN(l_appl_inst_rec.future_adm_ci_sequence_number));
2357: fnd_file.put_line(fnd_file.log, fnd_message.get);
2358:
2359: ELSE
2360:
2361: fnd_message.set_name('IGS', l_message_name);

Line 2361: fnd_message.set_name('IGS', l_message_name);

2357: fnd_file.put_line(fnd_file.log, fnd_message.get);
2358:
2359: ELSE
2360:
2361: fnd_message.set_name('IGS', l_message_name);
2362: fnd_file.put_line(fnd_file.log, fnd_message.get);
2363:
2364: END IF;
2365: ROLLBACK TO c_create_application;

Line 2362: fnd_file.put_line(fnd_file.log, fnd_message.get);

2358:
2359: ELSE
2360:
2361: fnd_message.set_name('IGS', l_message_name);
2362: fnd_file.put_line(fnd_file.log, fnd_message.get);
2363:
2364: END IF;
2365: ROLLBACK TO c_create_application;
2366:

Line 2553: fnd_message.set_name('IGS', 'Failed to update the Request for Reconsideration Checkbox: ' || SQLERRM );

2549: ROLLBACK TO c_create_application;
2550: fnd_file.put_line(fnd_file.log, 'Application Instance Creation Failed for Person ID: '|| RPAD(l_appl_inst_rec.person_id,15,' ') || '; Admission Application Number: ' ||
2551: RPAD(l_appl_inst_rec.admission_appl_number,2,' ') || '; Course Code: ' || RPAD(l_appl_inst_rec.nominated_course_cd,6,' ') || '; Sequence Number: '||
2552: RPAD(l_appl_inst_rec.sequence_number,6,' ') || ' Reason: ');
2553: fnd_message.set_name('IGS', 'Failed to update the Request for Reconsideration Checkbox: ' || SQLERRM );
2554: l_program_created:= FALSE;
2555: END;
2556:
2557: END IF;

Line 3066: fnd_message.set_name('IGS', l_message_name);

3062: RPAD(l_appl_inst_rec.sequence_number,6,' ') || ' Reason: ');
3063:
3064: IF l_message_name IN ('IGS_AD_NOMINATE_PRG_OFR_ENTRY', 'IGS_AD_NOMINATED_PRG_ENTRYPNT') THEN
3065: l_message_name := 'IGS_AD_CAL_PGM_NOT_OFFER';
3066: fnd_message.set_name('IGS', l_message_name);
3067: fnd_message.set_token('PGM', l_appl_inst_rec.nominated_course_cd);
3068: fnd_message.set_token('ALTCODE',l_appl_inst_rec.future_acad_cal_type||','||
3069: IGS_GE_NUMBER.TO_CANN(l_appl_inst_rec.future_acad_ci_sequence_number)
3070: ||'/'||l_appl_inst_rec.future_adm_cal_type||','||

Line 3067: fnd_message.set_token('PGM', l_appl_inst_rec.nominated_course_cd);

3063:
3064: IF l_message_name IN ('IGS_AD_NOMINATE_PRG_OFR_ENTRY', 'IGS_AD_NOMINATED_PRG_ENTRYPNT') THEN
3065: l_message_name := 'IGS_AD_CAL_PGM_NOT_OFFER';
3066: fnd_message.set_name('IGS', l_message_name);
3067: fnd_message.set_token('PGM', l_appl_inst_rec.nominated_course_cd);
3068: fnd_message.set_token('ALTCODE',l_appl_inst_rec.future_acad_cal_type||','||
3069: IGS_GE_NUMBER.TO_CANN(l_appl_inst_rec.future_acad_ci_sequence_number)
3070: ||'/'||l_appl_inst_rec.future_adm_cal_type||','||
3071: IGS_GE_NUMBER.TO_CANN(l_appl_inst_rec.future_adm_ci_sequence_number));

Line 3068: fnd_message.set_token('ALTCODE',l_appl_inst_rec.future_acad_cal_type||','||

3064: IF l_message_name IN ('IGS_AD_NOMINATE_PRG_OFR_ENTRY', 'IGS_AD_NOMINATED_PRG_ENTRYPNT') THEN
3065: l_message_name := 'IGS_AD_CAL_PGM_NOT_OFFER';
3066: fnd_message.set_name('IGS', l_message_name);
3067: fnd_message.set_token('PGM', l_appl_inst_rec.nominated_course_cd);
3068: fnd_message.set_token('ALTCODE',l_appl_inst_rec.future_acad_cal_type||','||
3069: IGS_GE_NUMBER.TO_CANN(l_appl_inst_rec.future_acad_ci_sequence_number)
3070: ||'/'||l_appl_inst_rec.future_adm_cal_type||','||
3071: IGS_GE_NUMBER.TO_CANN(l_appl_inst_rec.future_adm_ci_sequence_number));
3072: fnd_file.put_line(fnd_file.log, fnd_message.get);

Line 3072: fnd_file.put_line(fnd_file.log, fnd_message.get);

3068: fnd_message.set_token('ALTCODE',l_appl_inst_rec.future_acad_cal_type||','||
3069: IGS_GE_NUMBER.TO_CANN(l_appl_inst_rec.future_acad_ci_sequence_number)
3070: ||'/'||l_appl_inst_rec.future_adm_cal_type||','||
3071: IGS_GE_NUMBER.TO_CANN(l_appl_inst_rec.future_adm_ci_sequence_number));
3072: fnd_file.put_line(fnd_file.log, fnd_message.get);
3073: ELSE
3074: fnd_message.set_name('IGS', l_message_name);
3075: fnd_file.put_line(fnd_file.log, fnd_message.get);
3076:

Line 3074: fnd_message.set_name('IGS', l_message_name);

3070: ||'/'||l_appl_inst_rec.future_adm_cal_type||','||
3071: IGS_GE_NUMBER.TO_CANN(l_appl_inst_rec.future_adm_ci_sequence_number));
3072: fnd_file.put_line(fnd_file.log, fnd_message.get);
3073: ELSE
3074: fnd_message.set_name('IGS', l_message_name);
3075: fnd_file.put_line(fnd_file.log, fnd_message.get);
3076:
3077: END IF;
3078: ROLLBACK TO c_create_application;

Line 3075: fnd_file.put_line(fnd_file.log, fnd_message.get);

3071: IGS_GE_NUMBER.TO_CANN(l_appl_inst_rec.future_adm_ci_sequence_number));
3072: fnd_file.put_line(fnd_file.log, fnd_message.get);
3073: ELSE
3074: fnd_message.set_name('IGS', l_message_name);
3075: fnd_file.put_line(fnd_file.log, fnd_message.get);
3076:
3077: END IF;
3078: ROLLBACK TO c_create_application;
3079: END;