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_VAL_ACAI_FTR_OFFER dependencies on FND_FILE

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

427:
428: EXCEPTION WHEN OTHERS THEN
429:
430: FND_MESSAGE.SET_NAME('IGS','IGS_AD_CAND_COPY_FAIL');
431: Fnd_File.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
432:
433: FND_MESSAGE.SET_NAME('IGS',v_message_name);
434: fnd_file.put_line(FND_FILE.LOG, FND_MESSAGE.GET || SQLERRM);
435:

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

430: FND_MESSAGE.SET_NAME('IGS','IGS_AD_CAND_COPY_FAIL');
431: Fnd_File.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
432:
433: FND_MESSAGE.SET_NAME('IGS',v_message_name);
434: fnd_file.put_line(FND_FILE.LOG, FND_MESSAGE.GET || SQLERRM);
435:
436: RETURN FALSE;
437:
438: END copy_candidacy_records;

Line 623: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD('Person Number',38) || ' : ' || l_person_number);

619: OPEN c_pergr_cur;
620: FETCH c_pergr_cur INTO l_group_desc;
621: CLOSE c_pergr_cur;
622:
623: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD('Person Number',38) || ' : ' || l_person_number);
624: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD('Person ID Group' ,38) || ' : ' || l_group_desc);
625: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD('Program',38) || ' : ' || p_nominated_course_cd);
626:
627: IF p_prev_acad_adm_cal IS NOT NULL THEN

Line 624: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD('Person ID Group' ,38) || ' : ' || l_group_desc);

620: FETCH c_pergr_cur INTO l_group_desc;
621: CLOSE c_pergr_cur;
622:
623: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD('Person Number',38) || ' : ' || l_person_number);
624: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD('Person ID Group' ,38) || ' : ' || l_group_desc);
625: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD('Program',38) || ' : ' || p_nominated_course_cd);
626:
627: IF p_prev_acad_adm_cal IS NOT NULL THEN
628: OPEN acad_adm_alt_code( p_prev_acad_cal_type,

Line 625: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD('Program',38) || ' : ' || p_nominated_course_cd);

621: CLOSE c_pergr_cur;
622:
623: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD('Person Number',38) || ' : ' || l_person_number);
624: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD('Person ID Group' ,38) || ' : ' || l_group_desc);
625: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD('Program',38) || ' : ' || p_nominated_course_cd);
626:
627: IF p_prev_acad_adm_cal IS NOT NULL THEN
628: OPEN acad_adm_alt_code( p_prev_acad_cal_type,
629: p_prev_acad_cal_seq_no,

Line 645: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD('Current Academic / Admission Calendar',38) || ' : ' || cur_acad_adm_alt_code );

641: FETCH acad_adm_alt_code INTO fut_acad_adm_alt_code;
642: CLOSE acad_adm_alt_code;
643: END IF;
644:
645: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD('Current Academic / Admission Calendar',38) || ' : ' || cur_acad_adm_alt_code );
646: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD('Future Academic / Admission Calendar',38) || ' : ' || fut_acad_adm_alt_code );
647:
648:
649: l_offer_dt := igs_ge_date.igsdate(p_offer_dt);

Line 646: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD('Future Academic / Admission Calendar',38) || ' : ' || fut_acad_adm_alt_code );

642: CLOSE acad_adm_alt_code;
643: END IF;
644:
645: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD('Current Academic / Admission Calendar',38) || ' : ' || cur_acad_adm_alt_code );
646: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD('Future Academic / Admission Calendar',38) || ' : ' || fut_acad_adm_alt_code );
647:
648:
649: l_offer_dt := igs_ge_date.igsdate(p_offer_dt);
650: l_offer_response_dt := igs_ge_date.igsdate(p_offer_response_dt);

Line 652: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD('Offer Date',38) || ' : ' || l_offer_dt);

648:
649: l_offer_dt := igs_ge_date.igsdate(p_offer_dt);
650: l_offer_response_dt := igs_ge_date.igsdate(p_offer_response_dt);
651:
652: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD('Offer Date',38) || ' : ' || l_offer_dt);
653: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD('Override Offer Response Date',38) || ' : ' || l_offer_response_dt);
654: FND_FILE.PUT_LINE(FND_FILE.LOG,'');
655:
656: -- check whether the parameter combination passed is correct

Line 653: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD('Override Offer Response Date',38) || ' : ' || l_offer_response_dt);

649: l_offer_dt := igs_ge_date.igsdate(p_offer_dt);
650: l_offer_response_dt := igs_ge_date.igsdate(p_offer_response_dt);
651:
652: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD('Offer Date',38) || ' : ' || l_offer_dt);
653: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD('Override Offer Response Date',38) || ' : ' || l_offer_response_dt);
654: FND_FILE.PUT_LINE(FND_FILE.LOG,'');
655:
656: -- check whether the parameter combination passed is correct
657: -- if user gives both person group and person

Line 654: FND_FILE.PUT_LINE(FND_FILE.LOG,'');

650: l_offer_response_dt := igs_ge_date.igsdate(p_offer_response_dt);
651:
652: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD('Offer Date',38) || ' : ' || l_offer_dt);
653: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD('Override Offer Response Date',38) || ' : ' || l_offer_response_dt);
654: FND_FILE.PUT_LINE(FND_FILE.LOG,'');
655:
656: -- check whether the parameter combination passed is correct
657: -- if user gives both person group and person
658: -- then it should check whether the person exists in that group

Line 662: fnd_file.put_line(fnd_file.log, 'Application could not be created');

658: -- then it should check whether the person exists in that group
659: -- if the person doesnot exists, it gives a message --rghosh bug#2767294
660:
661: IF (p_group_id IS NULL AND p_person_id IS NULL AND p_application_id IS NULL)THEN
662: fnd_file.put_line(fnd_file.log, 'Application could not be created');
663: fnd_file.put_line(fnd_file.log, 'Either Person Number or Person ID Group or Application ID should be passed');
664: ELSIF (p_group_id IS NOT NULL AND p_person_id IS NOT NULL) THEN
665: OPEN c_group_id(p_person_id,p_group_id);
666: FETCH c_group_id INTO l_exists;

Line 663: fnd_file.put_line(fnd_file.log, 'Either Person Number or Person ID Group or Application ID should be passed');

659: -- if the person doesnot exists, it gives a message --rghosh bug#2767294
660:
661: IF (p_group_id IS NULL AND p_person_id IS NULL AND p_application_id IS NULL)THEN
662: fnd_file.put_line(fnd_file.log, 'Application could not be created');
663: fnd_file.put_line(fnd_file.log, 'Either Person Number or Person ID Group or Application ID should be passed');
664: ELSIF (p_group_id IS NOT NULL AND p_person_id IS NOT NULL) THEN
665: OPEN c_group_id(p_person_id,p_group_id);
666: FETCH c_group_id INTO l_exists;
667: IF c_group_id%NOTFOUND THEN

Line 668: fnd_file.put_line(fnd_file.log, 'Application could not be created');

664: ELSIF (p_group_id IS NOT NULL AND p_person_id IS NOT NULL) THEN
665: OPEN c_group_id(p_person_id,p_group_id);
666: FETCH c_group_id INTO l_exists;
667: IF c_group_id%NOTFOUND THEN
668: fnd_file.put_line(fnd_file.log, 'Application could not be created');
669: fnd_file.put_line(fnd_file.log, 'Person does not exists in the Person ID Group');
670: END IF;
671: CLOSE c_group_id;
672: END IF;

Line 669: fnd_file.put_line(fnd_file.log, 'Person does not exists in the Person ID Group');

665: OPEN c_group_id(p_person_id,p_group_id);
666: FETCH c_group_id INTO l_exists;
667: IF c_group_id%NOTFOUND THEN
668: fnd_file.put_line(fnd_file.log, 'Application could not be created');
669: fnd_file.put_line(fnd_file.log, 'Person does not exists in the Person ID Group');
670: END IF;
671: CLOSE c_group_id;
672: END IF;
673:

Line 703: fnd_file.put_line(fnd_file.log, 'Creating Future Term Application for ' );

699: FOR c_appl_inst_rec IN c_appl_inst(c_ref_cur_rec.person_id) LOOP
700: l_applcreated_flag := FALSE;
701:
702: -- UPDATE the log file with application details
703: fnd_file.put_line(fnd_file.log, 'Creating Future Term Application for ' );
704: fnd_file.put_line(fnd_file.log,RPAD( ' Person Id',29) || ' : ' || IGS_GE_NUMBER.TO_CANN(c_appl_inst_rec.person_id));
705: fnd_file.put_line(fnd_file.log, RPAD(' Admission Application Number',29) || ' : ' || IGS_GE_NUMBER.TO_CANN(c_appl_inst_rec.admission_appl_number));
706: fnd_file.put_line(fnd_file.log, RPAD(' Nominated course Code',29) || ' : ' || c_appl_inst_rec.nominated_course_cd);
707: fnd_file.put_line(fnd_file.log,RPAD(' Sequence Number',29) || ' : ' || IGS_GE_NUMBER.TO_CANN( c_appl_inst_rec.sequence_number ));

Line 704: fnd_file.put_line(fnd_file.log,RPAD( ' Person Id',29) || ' : ' || IGS_GE_NUMBER.TO_CANN(c_appl_inst_rec.person_id));

700: l_applcreated_flag := FALSE;
701:
702: -- UPDATE the log file with application details
703: fnd_file.put_line(fnd_file.log, 'Creating Future Term Application for ' );
704: fnd_file.put_line(fnd_file.log,RPAD( ' Person Id',29) || ' : ' || IGS_GE_NUMBER.TO_CANN(c_appl_inst_rec.person_id));
705: fnd_file.put_line(fnd_file.log, RPAD(' Admission Application Number',29) || ' : ' || IGS_GE_NUMBER.TO_CANN(c_appl_inst_rec.admission_appl_number));
706: fnd_file.put_line(fnd_file.log, RPAD(' Nominated course Code',29) || ' : ' || c_appl_inst_rec.nominated_course_cd);
707: fnd_file.put_line(fnd_file.log,RPAD(' Sequence Number',29) || ' : ' || IGS_GE_NUMBER.TO_CANN( c_appl_inst_rec.sequence_number ));
708:

Line 705: fnd_file.put_line(fnd_file.log, RPAD(' Admission Application Number',29) || ' : ' || IGS_GE_NUMBER.TO_CANN(c_appl_inst_rec.admission_appl_number));

701:
702: -- UPDATE the log file with application details
703: fnd_file.put_line(fnd_file.log, 'Creating Future Term Application for ' );
704: fnd_file.put_line(fnd_file.log,RPAD( ' Person Id',29) || ' : ' || IGS_GE_NUMBER.TO_CANN(c_appl_inst_rec.person_id));
705: fnd_file.put_line(fnd_file.log, RPAD(' Admission Application Number',29) || ' : ' || IGS_GE_NUMBER.TO_CANN(c_appl_inst_rec.admission_appl_number));
706: fnd_file.put_line(fnd_file.log, RPAD(' Nominated course Code',29) || ' : ' || c_appl_inst_rec.nominated_course_cd);
707: fnd_file.put_line(fnd_file.log,RPAD(' Sequence Number',29) || ' : ' || IGS_GE_NUMBER.TO_CANN( c_appl_inst_rec.sequence_number ));
708:
709: -- Set the save point here

Line 706: fnd_file.put_line(fnd_file.log, RPAD(' Nominated course Code',29) || ' : ' || c_appl_inst_rec.nominated_course_cd);

702: -- UPDATE the log file with application details
703: fnd_file.put_line(fnd_file.log, 'Creating Future Term Application for ' );
704: fnd_file.put_line(fnd_file.log,RPAD( ' Person Id',29) || ' : ' || IGS_GE_NUMBER.TO_CANN(c_appl_inst_rec.person_id));
705: fnd_file.put_line(fnd_file.log, RPAD(' Admission Application Number',29) || ' : ' || IGS_GE_NUMBER.TO_CANN(c_appl_inst_rec.admission_appl_number));
706: fnd_file.put_line(fnd_file.log, RPAD(' Nominated course Code',29) || ' : ' || c_appl_inst_rec.nominated_course_cd);
707: fnd_file.put_line(fnd_file.log,RPAD(' Sequence Number',29) || ' : ' || IGS_GE_NUMBER.TO_CANN( c_appl_inst_rec.sequence_number ));
708:
709: -- Set the save point here
710: -- Since when the application related transaction fails we need to rollback the transaction for that application

Line 707: fnd_file.put_line(fnd_file.log,RPAD(' Sequence Number',29) || ' : ' || IGS_GE_NUMBER.TO_CANN( c_appl_inst_rec.sequence_number ));

703: fnd_file.put_line(fnd_file.log, 'Creating Future Term Application for ' );
704: fnd_file.put_line(fnd_file.log,RPAD( ' Person Id',29) || ' : ' || IGS_GE_NUMBER.TO_CANN(c_appl_inst_rec.person_id));
705: fnd_file.put_line(fnd_file.log, RPAD(' Admission Application Number',29) || ' : ' || IGS_GE_NUMBER.TO_CANN(c_appl_inst_rec.admission_appl_number));
706: fnd_file.put_line(fnd_file.log, RPAD(' Nominated course Code',29) || ' : ' || c_appl_inst_rec.nominated_course_cd);
707: fnd_file.put_line(fnd_file.log,RPAD(' Sequence Number',29) || ' : ' || IGS_GE_NUMBER.TO_CANN( c_appl_inst_rec.sequence_number ));
708:
709: -- Set the save point here
710: -- Since when the application related transaction fails we need to rollback the transaction for that application
711: -- and it should proceed to the next record in the cursor

Line 823: fnd_file.put_line(fnd_file.log, 'Creating Future Term Application for ' );

819: -- Set the save point here
820: -- Since when the application related transaction fails we need to rollback the transaction for that application
821: -- and it should proceed to the next record in the cursor
822:
823: fnd_file.put_line(fnd_file.log, 'Creating Future Term Application for ' );
824: fnd_file.put_line(fnd_file.log,RPAD(' Person Id' , 29) || ' : ' || IGS_GE_NUMBER.TO_CANN(c_appl_inst_rec.person_id));
825: fnd_file.put_line(fnd_file.log, RPAD(' Admission Application Number',29) || ' : ' || IGS_GE_NUMBER.TO_CANN(c_appl_inst_rec.admission_appl_number));
826: fnd_file.put_line(fnd_file.log,RPAD(' Nominated course Code',29) || ' : ' || c_appl_inst_rec.nominated_course_cd);
827: fnd_file.put_line(fnd_file.log,RPAD(' Sequence Number',29) || ' : ' || IGS_GE_NUMBER.TO_CANN( c_appl_inst_rec.sequence_number ));

Line 824: fnd_file.put_line(fnd_file.log,RPAD(' Person Id' , 29) || ' : ' || IGS_GE_NUMBER.TO_CANN(c_appl_inst_rec.person_id));

820: -- Since when the application related transaction fails we need to rollback the transaction for that application
821: -- and it should proceed to the next record in the cursor
822:
823: fnd_file.put_line(fnd_file.log, 'Creating Future Term Application for ' );
824: fnd_file.put_line(fnd_file.log,RPAD(' Person Id' , 29) || ' : ' || IGS_GE_NUMBER.TO_CANN(c_appl_inst_rec.person_id));
825: fnd_file.put_line(fnd_file.log, RPAD(' Admission Application Number',29) || ' : ' || IGS_GE_NUMBER.TO_CANN(c_appl_inst_rec.admission_appl_number));
826: fnd_file.put_line(fnd_file.log,RPAD(' Nominated course Code',29) || ' : ' || c_appl_inst_rec.nominated_course_cd);
827: fnd_file.put_line(fnd_file.log,RPAD(' Sequence Number',29) || ' : ' || IGS_GE_NUMBER.TO_CANN( c_appl_inst_rec.sequence_number ));
828:

Line 825: fnd_file.put_line(fnd_file.log, RPAD(' Admission Application Number',29) || ' : ' || IGS_GE_NUMBER.TO_CANN(c_appl_inst_rec.admission_appl_number));

821: -- and it should proceed to the next record in the cursor
822:
823: fnd_file.put_line(fnd_file.log, 'Creating Future Term Application for ' );
824: fnd_file.put_line(fnd_file.log,RPAD(' Person Id' , 29) || ' : ' || IGS_GE_NUMBER.TO_CANN(c_appl_inst_rec.person_id));
825: fnd_file.put_line(fnd_file.log, RPAD(' Admission Application Number',29) || ' : ' || IGS_GE_NUMBER.TO_CANN(c_appl_inst_rec.admission_appl_number));
826: fnd_file.put_line(fnd_file.log,RPAD(' Nominated course Code',29) || ' : ' || c_appl_inst_rec.nominated_course_cd);
827: fnd_file.put_line(fnd_file.log,RPAD(' Sequence Number',29) || ' : ' || IGS_GE_NUMBER.TO_CANN( c_appl_inst_rec.sequence_number ));
828:
829: SAVEPOINT sp_save_point2;

Line 826: fnd_file.put_line(fnd_file.log,RPAD(' Nominated course Code',29) || ' : ' || c_appl_inst_rec.nominated_course_cd);

822:
823: fnd_file.put_line(fnd_file.log, 'Creating Future Term Application for ' );
824: fnd_file.put_line(fnd_file.log,RPAD(' Person Id' , 29) || ' : ' || IGS_GE_NUMBER.TO_CANN(c_appl_inst_rec.person_id));
825: fnd_file.put_line(fnd_file.log, RPAD(' Admission Application Number',29) || ' : ' || IGS_GE_NUMBER.TO_CANN(c_appl_inst_rec.admission_appl_number));
826: fnd_file.put_line(fnd_file.log,RPAD(' Nominated course Code',29) || ' : ' || c_appl_inst_rec.nominated_course_cd);
827: fnd_file.put_line(fnd_file.log,RPAD(' Sequence Number',29) || ' : ' || IGS_GE_NUMBER.TO_CANN( c_appl_inst_rec.sequence_number ));
828:
829: SAVEPOINT sp_save_point2;
830:

Line 827: fnd_file.put_line(fnd_file.log,RPAD(' Sequence Number',29) || ' : ' || IGS_GE_NUMBER.TO_CANN( c_appl_inst_rec.sequence_number ));

823: fnd_file.put_line(fnd_file.log, 'Creating Future Term Application for ' );
824: fnd_file.put_line(fnd_file.log,RPAD(' Person Id' , 29) || ' : ' || IGS_GE_NUMBER.TO_CANN(c_appl_inst_rec.person_id));
825: fnd_file.put_line(fnd_file.log, RPAD(' Admission Application Number',29) || ' : ' || IGS_GE_NUMBER.TO_CANN(c_appl_inst_rec.admission_appl_number));
826: fnd_file.put_line(fnd_file.log,RPAD(' Nominated course Code',29) || ' : ' || c_appl_inst_rec.nominated_course_cd);
827: fnd_file.put_line(fnd_file.log,RPAD(' Sequence Number',29) || ' : ' || IGS_GE_NUMBER.TO_CANN( c_appl_inst_rec.sequence_number ));
828:
829: SAVEPOINT sp_save_point2;
830:
831: -- Call handle application

Line 927: fnd_file.put_line(fnd_file.log, fnd_message.get_string('IGS','IGS_AD_FTAPP_NOT_FOUND'));

923: END LOOP; -- end loop list of application instances
924: END IF;
925: IF l_applcreated_flag THEN
926: --Put the message into log that application could not be found for given parameters.
927: fnd_file.put_line(fnd_file.log, fnd_message.get_string('IGS','IGS_AD_FTAPP_NOT_FOUND'));
928: END IF;
929: EXCEPTION
930: WHEN OTHERS THEN
931: retcode:=2;

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

1053: p_routeb_pref =>c_appl_inst_rec.routeb_pref,
1054: p_alt_appl_id =>c_appl_inst_rec.alt_appl_id) = FALSE THEN
1055:
1056: fnd_message.set_name('IGS', l_message_name);
1057: fnd_file.put_line(fnd_file.log, fnd_message.get);
1058:
1059: RETURN FALSE;
1060:
1061: ELSE -- Else for Application

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

1162: fnd_message.set_name('IGS', l_message_name);
1163: fnd_message.set_token('PGM', c_appl_inst_rec.nominated_course_cd);
1164: fnd_message.set_token('ALTCODE',c_appl_inst_rec.acad_cal_type||','||IGS_GE_NUMBER.TO_CANN(c_appl_inst_rec.acad_ci_sequence_number)
1165: ||'/'||c_appl_inst_rec.final_adm_cal_type||','||IGS_GE_NUMBER.TO_CANN(c_appl_inst_rec.final_adm_ci_sequence_number));
1166: fnd_file.put_line(fnd_file.log, fnd_message.get);
1167: ELSE
1168: fnd_message.set_name('IGS', l_message_name);
1169: fnd_file.put_line(fnd_file.log, fnd_message.get);
1170: END IF;

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

1165: ||'/'||c_appl_inst_rec.final_adm_cal_type||','||IGS_GE_NUMBER.TO_CANN(c_appl_inst_rec.final_adm_ci_sequence_number));
1166: fnd_file.put_line(fnd_file.log, fnd_message.get);
1167: ELSE
1168: fnd_message.set_name('IGS', l_message_name);
1169: fnd_file.put_line(fnd_file.log, fnd_message.get);
1170: END IF;
1171: RETURN FALSE;
1172: END IF;
1173: RETURN FALSE;

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

1172: END IF;
1173: RETURN FALSE;
1174: ELSE -- Else for Application Program
1175: fnd_message.set_name('IGS', l_message_name);
1176: fnd_file.put_line(fnd_file.log, fnd_message.get);
1177: RETURN FALSE;
1178: END IF;
1179: END IF;
1180: END LOOP;

Line 1183: fnd_file.put_line(fnd_file.log, 'Exception From handle application log ' || SQLERRM);

1179: END IF;
1180: END LOOP;
1181: RETURN TRUE;
1182: EXCEPTION WHEN OTHERS THEN
1183: fnd_file.put_line(fnd_file.log, 'Exception From handle application log ' || SQLERRM);
1184: RETURN FALSE;
1185: END handle_application;
1186:
1187: FUNCTION copy_child_records(p_new_admission_appl_number IGS_AD_APPL.admission_appl_number%TYPE,

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

2037: RETURN TRUE;
2038:
2039: EXCEPTION WHEN OTHERS THEN
2040: FND_MESSAGE.SET_NAME('IGS','IGS_AD_CHILD_COPY_FAILED');
2041: Fnd_File.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
2042:
2043: FND_MESSAGE.SET_NAME('IGS',l_last_error);
2044: fnd_file.put_line(FND_FILE.LOG, FND_MESSAGE.GET || SQLERRM);
2045:

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

2040: FND_MESSAGE.SET_NAME('IGS','IGS_AD_CHILD_COPY_FAILED');
2041: Fnd_File.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
2042:
2043: FND_MESSAGE.SET_NAME('IGS',l_last_error);
2044: fnd_file.put_line(FND_FILE.LOG, FND_MESSAGE.GET || SQLERRM);
2045:
2046: RETURN FALSE;
2047: END copy_child_records;
2048:

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

2261: c_appl_offer_rec.adm_cal_type,
2262: c_appl_offer_rec.adm_ci_sequence_number,
2263: v_message_name) = FALSE THEN
2264: fnd_message.set_name('IGS', v_message_name);
2265: fnd_file.put_line(fnd_file.log, fnd_message.get);
2266: END IF;
2267:
2268:
2269: -- calculate the offer response date if the user doesn't passes the value

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

2461: l_adm_cat,
2462: c_appl_offer_rec.enrolment_cat,
2463: v_message_name) = FALSE THEN
2464: fnd_message.set_name('IGS', v_message_name);
2465: fnd_file.put_line(fnd_file.log, fnd_message.get);
2466: RETURN FALSE;
2467: END IF;
2468:
2469:

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

2481: 'N', -- Confirm course indicator.
2482: 'N', -- Perform eligibility check indicator.
2483: v_message_name) = FALSE THEN
2484: fnd_message.set_name('IGS', v_message_name);
2485: fnd_file.put_line(fnd_file.log, fnd_message.get);
2486: END IF;
2487: END IF; -- PRE-ENROLL IND = 'Y'
2488:
2489: ELSE

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

2492: fnd_message.set_name('IGS', v_message_name);
2493: fnd_message.set_token('PGM', c_appl_offer_rec.nominated_course_cd);
2494: fnd_message.set_token('ALTCODE',c_appl_offer_rec.acad_cal_type||','||IGS_GE_NUMBER.TO_CANN(c_appl_offer_rec.acad_ci_sequence_number)
2495: ||'/'||c_appl_offer_rec.final_adm_cal_type||','||IGS_GE_NUMBER.TO_CANN(c_appl_offer_rec.final_adm_ci_sequence_number));
2496: fnd_file.put_line(fnd_file.log, fnd_message.get);
2497: ELSE
2498: fnd_message.set_name('IGS', v_message_name);
2499: fnd_file.put_line(fnd_file.log, fnd_message.get);
2500: END IF;

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

2495: ||'/'||c_appl_offer_rec.final_adm_cal_type||','||IGS_GE_NUMBER.TO_CANN(c_appl_offer_rec.final_adm_ci_sequence_number));
2496: fnd_file.put_line(fnd_file.log, fnd_message.get);
2497: ELSE
2498: fnd_message.set_name('IGS', v_message_name);
2499: fnd_file.put_line(fnd_file.log, fnd_message.get);
2500: END IF;
2501: RETURN FALSE;
2502: END IF;
2503: END LOOP;

Line 2506: fnd_file.put_line(fnd_file.log, SQLERRM);

2502: END IF;
2503: END LOOP;
2504: RETURN TRUE;
2505: EXCEPTION WHEN OTHERS THEN
2506: fnd_file.put_line(fnd_file.log, SQLERRM);
2507: RETURN FALSE;
2508: END validate_offer_validations;
2509:
2510: FUNCTION copy_entrycomp_qual_status(p_person_id HZ_PARTIES.PARTY_ID%TYPE,

Line 2793: fnd_file.put_line(fnd_file.log, SQLERRM);

2789: END LOOP;
2790: END LOOP;
2791: RETURN TRUE;
2792: EXCEPTION WHEN OTHERS THEN
2793: fnd_file.put_line(fnd_file.log, SQLERRM);
2794: RETURN FALSE;
2795: END copy_entrycomp_qual_status;
2796:
2797: