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

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

200: FETCH c_pergr_cur INTO l_group_desc;
201: CLOSE c_pergr_cur;
202:
203: -- added the following lines for displaying the parameters person number, person id group and program --rghosh bug #2767294
204: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD('Person Number',38) || ' : ' || l_person_number);
205: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD('Person ID Group' ,38) || ' : ' || l_group_desc);
206: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD('Program',38) || ' : ' || p_nominated_course_cd);
207:
208: IF p_prev_acad_adm_cal IS NOT NULL THEN

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

201: CLOSE c_pergr_cur;
202:
203: -- added the following lines for displaying the parameters person number, person id group and program --rghosh bug #2767294
204: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD('Person Number',38) || ' : ' || l_person_number);
205: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD('Person ID Group' ,38) || ' : ' || l_group_desc);
206: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD('Program',38) || ' : ' || p_nominated_course_cd);
207:
208: IF p_prev_acad_adm_cal IS NOT NULL THEN
209: OPEN acad_adm_alt_code( p_prev_acad_cal_type,

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

202:
203: -- added the following lines for displaying the parameters person number, person id group and program --rghosh bug #2767294
204: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD('Person Number',38) || ' : ' || l_person_number);
205: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD('Person ID Group' ,38) || ' : ' || l_group_desc);
206: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD('Program',38) || ' : ' || p_nominated_course_cd);
207:
208: IF p_prev_acad_adm_cal IS NOT NULL THEN
209: OPEN acad_adm_alt_code( p_prev_acad_cal_type,
210: p_prev_acad_cal_seq_no,

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

222: FETCH acad_adm_alt_code INTO def_acad_adm_alt_code;
223: CLOSE acad_adm_alt_code;
224: END IF;
225:
226: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD('Current Academic / Admission Calendar',38) || ' : ' || cur_acad_adm_alt_code );
227: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD('Deferred Academic / Admission Calendar',38) || ' : ' || def_acad_adm_alt_code );
228:
229: l_offer_dt := igs_ge_date.igsdate(p_offer_dt);
230: l_offer_response_dt := igs_ge_date.igsdate(p_offer_response_dt);

Line 227: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD('Deferred Academic / Admission Calendar',38) || ' : ' || def_acad_adm_alt_code );

223: CLOSE acad_adm_alt_code;
224: END IF;
225:
226: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD('Current Academic / Admission Calendar',38) || ' : ' || cur_acad_adm_alt_code );
227: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD('Deferred Academic / Admission Calendar',38) || ' : ' || def_acad_adm_alt_code );
228:
229: l_offer_dt := igs_ge_date.igsdate(p_offer_dt);
230: l_offer_response_dt := igs_ge_date.igsdate(p_offer_response_dt);
231:

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

228:
229: l_offer_dt := igs_ge_date.igsdate(p_offer_dt);
230: l_offer_response_dt := igs_ge_date.igsdate(p_offer_response_dt);
231:
232: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD('Offer Date',38) || ' : ' || l_offer_dt);
233: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD('Override Offer Response Date',38) || ' : ' || l_offer_response_dt);
234: FND_FILE.PUT_LINE(FND_FILE.LOG,'');
235:
236: -- check whether the parameter combination passed is correct

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

229: l_offer_dt := igs_ge_date.igsdate(p_offer_dt);
230: l_offer_response_dt := igs_ge_date.igsdate(p_offer_response_dt);
231:
232: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD('Offer Date',38) || ' : ' || l_offer_dt);
233: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD('Override Offer Response Date',38) || ' : ' || l_offer_response_dt);
234: FND_FILE.PUT_LINE(FND_FILE.LOG,'');
235:
236: -- check whether the parameter combination passed is correct
237: -- if user gives both person group and person

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

230: l_offer_response_dt := igs_ge_date.igsdate(p_offer_response_dt);
231:
232: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD('Offer Date',38) || ' : ' || l_offer_dt);
233: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD('Override Offer Response Date',38) || ' : ' || l_offer_response_dt);
234: FND_FILE.PUT_LINE(FND_FILE.LOG,'');
235:
236: -- check whether the parameter combination passed is correct
237: -- if user gives both person group and person
238: -- then it should check whether the person exists in that group

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

238: -- then it should check whether the person exists in that group
239: -- if the person doesnot exists, it gives a message --rghosh bug#2767294
240:
241: IF (p_group_id IS NULL AND p_person_id IS NULL)THEN
242: fnd_file.put_line(fnd_file.log, 'Application could not be created');
243: fnd_file.put_line(fnd_file.log, 'Either Person Number or Person ID Group should be passed');
244: ELSIF (p_group_id IS NOT NULL AND p_person_id IS NOT NULL) THEN
245: OPEN c_group_id(p_person_id,p_group_id);
246: FETCH c_group_id INTO l_exists;

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

239: -- if the person doesnot exists, it gives a message --rghosh bug#2767294
240:
241: IF (p_group_id IS NULL AND p_person_id IS NULL)THEN
242: fnd_file.put_line(fnd_file.log, 'Application could not be created');
243: fnd_file.put_line(fnd_file.log, 'Either Person Number or Person ID Group should be passed');
244: ELSIF (p_group_id IS NOT NULL AND p_person_id IS NOT NULL) THEN
245: OPEN c_group_id(p_person_id,p_group_id);
246: FETCH c_group_id INTO l_exists;
247: IF c_group_id%NOTFOUND THEN

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

244: ELSIF (p_group_id IS NOT NULL AND p_person_id IS NOT NULL) THEN
245: OPEN c_group_id(p_person_id,p_group_id);
246: FETCH c_group_id INTO l_exists;
247: IF c_group_id%NOTFOUND THEN
248: fnd_file.put_line(fnd_file.log, 'Application could not be created');
249: fnd_file.put_line(fnd_file.log, 'Person does not exists in the Person ID Group');
250: END IF;
251: CLOSE c_group_id;
252: END IF;

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

245: OPEN c_group_id(p_person_id,p_group_id);
246: FETCH c_group_id INTO l_exists;
247: IF c_group_id%NOTFOUND THEN
248: fnd_file.put_line(fnd_file.log, 'Application could not be created');
249: fnd_file.put_line(fnd_file.log, 'Person does not exists in the Person ID Group');
250: END IF;
251: CLOSE c_group_id;
252: END IF;
253:

Line 282: fnd_file.put_line(fnd_file.log, 'Creating Deferred Application for ' );

278: -- Find out NOCOPY the list applications
279: FOR c_appl_inst_rec IN c_appl_inst(c_ref_cur_rec.person_id) LOOP
280:
281: -- UPDATE the log file with application details
282: fnd_file.put_line(fnd_file.log, 'Creating Deferred Application for ' );
283: fnd_file.put_line(fnd_file.log,RPAD( ' Person Number',29) || ' : ' || get_person_number(IGS_GE_NUMBER.TO_CANN(c_appl_inst_rec.person_id)));
284: fnd_file.put_line(fnd_file.log, RPAD(' Admission Application Number',29) || ' : ' || IGS_GE_NUMBER.TO_CANN(c_appl_inst_rec.admission_appl_number));
285: fnd_file.put_line(fnd_file.log, RPAD(' Nominated course Code',29) || ' : ' || c_appl_inst_rec.nominated_course_cd);
286: fnd_file.put_line(fnd_file.log, RPAD(' Sequence Number',29) || ' : ' || IGS_GE_NUMBER.TO_CANN( c_appl_inst_rec.sequence_number ));

Line 283: fnd_file.put_line(fnd_file.log,RPAD( ' Person Number',29) || ' : ' || get_person_number(IGS_GE_NUMBER.TO_CANN(c_appl_inst_rec.person_id)));

279: FOR c_appl_inst_rec IN c_appl_inst(c_ref_cur_rec.person_id) LOOP
280:
281: -- UPDATE the log file with application details
282: fnd_file.put_line(fnd_file.log, 'Creating Deferred Application for ' );
283: fnd_file.put_line(fnd_file.log,RPAD( ' Person Number',29) || ' : ' || get_person_number(IGS_GE_NUMBER.TO_CANN(c_appl_inst_rec.person_id)));
284: fnd_file.put_line(fnd_file.log, RPAD(' Admission Application Number',29) || ' : ' || IGS_GE_NUMBER.TO_CANN(c_appl_inst_rec.admission_appl_number));
285: fnd_file.put_line(fnd_file.log, RPAD(' Nominated course Code',29) || ' : ' || c_appl_inst_rec.nominated_course_cd);
286: fnd_file.put_line(fnd_file.log, RPAD(' Sequence Number',29) || ' : ' || IGS_GE_NUMBER.TO_CANN( c_appl_inst_rec.sequence_number ));
287:

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

280:
281: -- UPDATE the log file with application details
282: fnd_file.put_line(fnd_file.log, 'Creating Deferred Application for ' );
283: fnd_file.put_line(fnd_file.log,RPAD( ' Person Number',29) || ' : ' || get_person_number(IGS_GE_NUMBER.TO_CANN(c_appl_inst_rec.person_id)));
284: fnd_file.put_line(fnd_file.log, RPAD(' Admission Application Number',29) || ' : ' || IGS_GE_NUMBER.TO_CANN(c_appl_inst_rec.admission_appl_number));
285: fnd_file.put_line(fnd_file.log, RPAD(' Nominated course Code',29) || ' : ' || c_appl_inst_rec.nominated_course_cd);
286: fnd_file.put_line(fnd_file.log, RPAD(' Sequence Number',29) || ' : ' || IGS_GE_NUMBER.TO_CANN( c_appl_inst_rec.sequence_number ));
287:
288: -- Call cmn_handle_application which will create application, copying child record

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

281: -- UPDATE the log file with application details
282: fnd_file.put_line(fnd_file.log, 'Creating Deferred Application for ' );
283: fnd_file.put_line(fnd_file.log,RPAD( ' Person Number',29) || ' : ' || get_person_number(IGS_GE_NUMBER.TO_CANN(c_appl_inst_rec.person_id)));
284: fnd_file.put_line(fnd_file.log, RPAD(' Admission Application Number',29) || ' : ' || IGS_GE_NUMBER.TO_CANN(c_appl_inst_rec.admission_appl_number));
285: fnd_file.put_line(fnd_file.log, RPAD(' Nominated course Code',29) || ' : ' || c_appl_inst_rec.nominated_course_cd);
286: fnd_file.put_line(fnd_file.log, RPAD(' Sequence Number',29) || ' : ' || IGS_GE_NUMBER.TO_CANN( c_appl_inst_rec.sequence_number ));
287:
288: -- Call cmn_handle_application which will create application, copying child record
289: -- changing the entry qualification status , completness status and offer validations and update the same

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

282: fnd_file.put_line(fnd_file.log, 'Creating Deferred Application for ' );
283: fnd_file.put_line(fnd_file.log,RPAD( ' Person Number',29) || ' : ' || get_person_number(IGS_GE_NUMBER.TO_CANN(c_appl_inst_rec.person_id)));
284: fnd_file.put_line(fnd_file.log, RPAD(' Admission Application Number',29) || ' : ' || IGS_GE_NUMBER.TO_CANN(c_appl_inst_rec.admission_appl_number));
285: fnd_file.put_line(fnd_file.log, RPAD(' Nominated course Code',29) || ' : ' || c_appl_inst_rec.nominated_course_cd);
286: fnd_file.put_line(fnd_file.log, RPAD(' Sequence Number',29) || ' : ' || IGS_GE_NUMBER.TO_CANN( c_appl_inst_rec.sequence_number ));
287:
288: -- Call cmn_handle_application which will create application, copying child record
289: -- changing the entry qualification status , completness status and offer validations and update the same
290:

Line 309: fnd_file.put_line(fnd_file.log, 'Creating Deferred Application for ' );

305: ELSE
306: -- This case will come into picture if the user has given only Person Id
307: -- Find out NOCOPY the list applications
308: FOR c_appl_inst_rec IN c_appl_inst(p_person_id) LOOP
309: fnd_file.put_line(fnd_file.log, 'Creating Deferred Application for ' );
310: fnd_file.put_line(fnd_file.log, RPAD(' Person Number',29) || ' : ' || get_person_number(IGS_GE_NUMBER.TO_CANN(c_appl_inst_rec.person_id)));
311: fnd_file.put_line(fnd_file.log, RPAD(' Admission Application Number',29) || ' : ' || IGS_GE_NUMBER.TO_CANN(c_appl_inst_rec.admission_appl_number));
312: fnd_file.put_line(fnd_file.log, RPAD(' Nominated course Code',29) || ' : ' || c_appl_inst_rec.nominated_course_cd);
313: fnd_file.put_line(fnd_file.log, RPAD(' Sequence Number',29) || ' : ' || IGS_GE_NUMBER.TO_CANN( c_appl_inst_rec.sequence_number ));

Line 310: fnd_file.put_line(fnd_file.log, RPAD(' Person Number',29) || ' : ' || get_person_number(IGS_GE_NUMBER.TO_CANN(c_appl_inst_rec.person_id)));

306: -- This case will come into picture if the user has given only Person Id
307: -- Find out NOCOPY the list applications
308: FOR c_appl_inst_rec IN c_appl_inst(p_person_id) LOOP
309: fnd_file.put_line(fnd_file.log, 'Creating Deferred Application for ' );
310: fnd_file.put_line(fnd_file.log, RPAD(' Person Number',29) || ' : ' || get_person_number(IGS_GE_NUMBER.TO_CANN(c_appl_inst_rec.person_id)));
311: fnd_file.put_line(fnd_file.log, RPAD(' Admission Application Number',29) || ' : ' || IGS_GE_NUMBER.TO_CANN(c_appl_inst_rec.admission_appl_number));
312: fnd_file.put_line(fnd_file.log, RPAD(' Nominated course Code',29) || ' : ' || c_appl_inst_rec.nominated_course_cd);
313: fnd_file.put_line(fnd_file.log, RPAD(' Sequence Number',29) || ' : ' || IGS_GE_NUMBER.TO_CANN( c_appl_inst_rec.sequence_number ));
314: -- Call cmn_hanlde_applicaiton which will create application, copying child record

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

307: -- Find out NOCOPY the list applications
308: FOR c_appl_inst_rec IN c_appl_inst(p_person_id) LOOP
309: fnd_file.put_line(fnd_file.log, 'Creating Deferred Application for ' );
310: fnd_file.put_line(fnd_file.log, RPAD(' Person Number',29) || ' : ' || get_person_number(IGS_GE_NUMBER.TO_CANN(c_appl_inst_rec.person_id)));
311: fnd_file.put_line(fnd_file.log, RPAD(' Admission Application Number',29) || ' : ' || IGS_GE_NUMBER.TO_CANN(c_appl_inst_rec.admission_appl_number));
312: fnd_file.put_line(fnd_file.log, RPAD(' Nominated course Code',29) || ' : ' || c_appl_inst_rec.nominated_course_cd);
313: fnd_file.put_line(fnd_file.log, RPAD(' Sequence Number',29) || ' : ' || IGS_GE_NUMBER.TO_CANN( c_appl_inst_rec.sequence_number ));
314: -- Call cmn_hanlde_applicaiton which will create application, copying child record
315: -- changing the entry qualification status , completness status and offer validations and update the same

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

308: FOR c_appl_inst_rec IN c_appl_inst(p_person_id) LOOP
309: fnd_file.put_line(fnd_file.log, 'Creating Deferred Application for ' );
310: fnd_file.put_line(fnd_file.log, RPAD(' Person Number',29) || ' : ' || get_person_number(IGS_GE_NUMBER.TO_CANN(c_appl_inst_rec.person_id)));
311: fnd_file.put_line(fnd_file.log, RPAD(' Admission Application Number',29) || ' : ' || IGS_GE_NUMBER.TO_CANN(c_appl_inst_rec.admission_appl_number));
312: fnd_file.put_line(fnd_file.log, RPAD(' Nominated course Code',29) || ' : ' || c_appl_inst_rec.nominated_course_cd);
313: fnd_file.put_line(fnd_file.log, RPAD(' Sequence Number',29) || ' : ' || IGS_GE_NUMBER.TO_CANN( c_appl_inst_rec.sequence_number ));
314: -- Call cmn_hanlde_applicaiton which will create application, copying child record
315: -- changing the entry qualification status , completness status and offer validations and update the same
316: cmn_handle_application(

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

309: fnd_file.put_line(fnd_file.log, 'Creating Deferred Application for ' );
310: fnd_file.put_line(fnd_file.log, RPAD(' Person Number',29) || ' : ' || get_person_number(IGS_GE_NUMBER.TO_CANN(c_appl_inst_rec.person_id)));
311: fnd_file.put_line(fnd_file.log, RPAD(' Admission Application Number',29) || ' : ' || IGS_GE_NUMBER.TO_CANN(c_appl_inst_rec.admission_appl_number));
312: fnd_file.put_line(fnd_file.log, RPAD(' Nominated course Code',29) || ' : ' || c_appl_inst_rec.nominated_course_cd);
313: fnd_file.put_line(fnd_file.log, RPAD(' Sequence Number',29) || ' : ' || IGS_GE_NUMBER.TO_CANN( c_appl_inst_rec.sequence_number ));
314: -- Call cmn_hanlde_applicaiton which will create application, copying child record
315: -- changing the entry qualification status , completness status and offer validations and update the same
316: cmn_handle_application(
317: p_person_id => p_person_id,

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

618: p_choice_number => c_appl_inst_rec.choice_number,
619: p_routeb_pref => c_appl_inst_rec.routeb_pref,
620: p_alt_appl_id => c_appl_inst_rec.alt_appl_id ) = FALSE THEN
621:
622: fnd_file.put_line(fnd_file.log, 'Application could not be created');
623: fnd_message.set_name('IGS', l_message_name);
624: fnd_file.put_line(fnd_file.log, fnd_message.get);
625: RETURN FALSE;
626:

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

620: p_alt_appl_id => c_appl_inst_rec.alt_appl_id ) = FALSE THEN
621:
622: fnd_file.put_line(fnd_file.log, 'Application could not be created');
623: fnd_message.set_name('IGS', l_message_name);
624: fnd_file.put_line(fnd_file.log, fnd_message.get);
625: RETURN FALSE;
626:
627: ELSE -- Else for Application
628: IF IGS_AD_GEN_014.insert_adm_appl_prog(

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

724: fnd_message.set_name('IGS', l_message_name);
725: fnd_message.set_token('PGM', c_appl_inst_rec.nominated_course_cd);
726: 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)
727: || '/' || c_appl_inst_rec.final_adm_cal_type || ',' || IGS_GE_NUMBER.TO_CANN(c_appl_inst_rec.final_adm_ci_sequence_number) );
728: fnd_file.put_line(fnd_file.log, 'Application could not be created');
729: fnd_file.put_line(fnd_file.log, fnd_message.get);
730: ELSE
731: fnd_file.put_line(fnd_file.log, 'Application could not be created');
732: fnd_message.set_name('IGS', l_message_name);

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

725: fnd_message.set_token('PGM', c_appl_inst_rec.nominated_course_cd);
726: 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)
727: || '/' || c_appl_inst_rec.final_adm_cal_type || ',' || IGS_GE_NUMBER.TO_CANN(c_appl_inst_rec.final_adm_ci_sequence_number) );
728: fnd_file.put_line(fnd_file.log, 'Application could not be created');
729: fnd_file.put_line(fnd_file.log, fnd_message.get);
730: ELSE
731: fnd_file.put_line(fnd_file.log, 'Application could not be created');
732: fnd_message.set_name('IGS', l_message_name);
733: fnd_file.put_line(fnd_file.log, fnd_message.get);

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

727: || '/' || c_appl_inst_rec.final_adm_cal_type || ',' || IGS_GE_NUMBER.TO_CANN(c_appl_inst_rec.final_adm_ci_sequence_number) );
728: fnd_file.put_line(fnd_file.log, 'Application could not be created');
729: fnd_file.put_line(fnd_file.log, fnd_message.get);
730: ELSE
731: fnd_file.put_line(fnd_file.log, 'Application could not be created');
732: fnd_message.set_name('IGS', l_message_name);
733: fnd_file.put_line(fnd_file.log, fnd_message.get);
734: END IF;
735: RETURN FALSE;

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

729: fnd_file.put_line(fnd_file.log, fnd_message.get);
730: ELSE
731: fnd_file.put_line(fnd_file.log, 'Application could not be created');
732: fnd_message.set_name('IGS', l_message_name);
733: fnd_file.put_line(fnd_file.log, fnd_message.get);
734: END IF;
735: RETURN FALSE;
736: END IF;
737: RETURN FALSE;

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

735: RETURN FALSE;
736: END IF;
737: RETURN FALSE;
738: ELSE -- Else for Application Program
739: fnd_file.put_line(fnd_file.log, 'Application could not be created');
740: fnd_message.set_name('IGS', l_message_name);
741: fnd_file.put_line(fnd_file.log, fnd_message.get);
742: RETURN FALSE;
743: END IF;

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

737: RETURN FALSE;
738: ELSE -- Else for Application Program
739: fnd_file.put_line(fnd_file.log, 'Application could not be created');
740: fnd_message.set_name('IGS', l_message_name);
741: fnd_file.put_line(fnd_file.log, fnd_message.get);
742: RETURN FALSE;
743: END IF;
744: END IF;
745: END LOOP;

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

744: END IF;
745: END LOOP;
746: RETURN TRUE;
747: EXCEPTION WHEN OTHERS THEN
748: fnd_file.put_line(fnd_file.log, 'Exception From handle application log ' || l_message_name);
749: RETURN FALSE;
750: END handle_application;
751:
752: FUNCTION validate_offer_validations(p_person_id HZ_PARTIES.PARTY_ID%TYPE,

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

970: c_appl_offer_rec.adm_cal_type,
971: c_appl_offer_rec.adm_ci_sequence_number,
972: v_message_name) = FALSE THEN
973: fnd_message.set_name('IGS', v_message_name);
974: fnd_file.put_line(fnd_file.log, fnd_message.get);
975: END IF;
976: -- calculate the offer response date if the user doesn't passes the value
977: IF p_offer_response_dt IS NULL THEN
978:

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

995:
996: IF l_offer_response_dt IS NOT NULL THEN
997: IF l_offer_response_dt < p_offer_dt THEN
998: fnd_message.set_name('IGS', 'IGS_AD_OFR_RSPDT_GE_OFRDT');
999: fnd_file.put_line(fnd_file.log, 'Application could not be created');
1000: fnd_file.put_line(fnd_file.log, fnd_message.get);
1001: RETURN FALSE;
1002: END IF;
1003: END IF;

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

996: IF l_offer_response_dt IS NOT NULL THEN
997: IF l_offer_response_dt < p_offer_dt THEN
998: fnd_message.set_name('IGS', 'IGS_AD_OFR_RSPDT_GE_OFRDT');
999: fnd_file.put_line(fnd_file.log, 'Application could not be created');
1000: fnd_file.put_line(fnd_file.log, fnd_message.get);
1001: RETURN FALSE;
1002: END IF;
1003: END IF;
1004:

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

1177: l_adm_cat,
1178: c_appl_offer_rec.enrolment_cat,
1179: v_message_name) = FALSE THEN
1180: fnd_message.set_name('IGS', v_message_name);
1181: fnd_file.put_line(fnd_file.log, 'Application could not be created');
1182: fnd_file.put_line(fnd_file.log, fnd_message.get);
1183: RETURN FALSE;
1184: END IF;
1185:

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

1178: c_appl_offer_rec.enrolment_cat,
1179: v_message_name) = FALSE THEN
1180: fnd_message.set_name('IGS', v_message_name);
1181: fnd_file.put_line(fnd_file.log, 'Application could not be created');
1182: fnd_file.put_line(fnd_file.log, fnd_message.get);
1183: RETURN FALSE;
1184: END IF;
1185:
1186: -- rrengara

Line 1200: fnd_file.put_line(fnd_file.log, 'Application could not be created'); -- added - apadegal adtd001 igs.m

1196: 'N', -- Confirm course indicator.
1197: 'N', -- Perform eligibility check indicator.
1198: v_message_name) = FALSE THEN
1199: fnd_message.set_name('IGS', v_message_name);
1200: fnd_file.put_line(fnd_file.log, 'Application could not be created'); -- added - apadegal adtd001 igs.m
1201: fnd_file.put_line(fnd_file.log, fnd_message.get);
1202: RETURN FALSE; -- added - apadegal adtd001 igs.m
1203: END IF;
1204: END IF; -- PRE-ENROLL IND = 'Y'

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

1197: 'N', -- Perform eligibility check indicator.
1198: v_message_name) = FALSE THEN
1199: fnd_message.set_name('IGS', v_message_name);
1200: fnd_file.put_line(fnd_file.log, 'Application could not be created'); -- added - apadegal adtd001 igs.m
1201: fnd_file.put_line(fnd_file.log, fnd_message.get);
1202: RETURN FALSE; -- added - apadegal adtd001 igs.m
1203: END IF;
1204: END IF; -- PRE-ENROLL IND = 'Y'
1205: ELSE

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

1208: fnd_message.set_name('IGS', v_message_name);
1209: fnd_message.set_token('PGM', c_appl_offer_rec.nominated_course_cd);
1210: 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)
1211: || '/' || c_appl_offer_rec.final_adm_cal_type || ',' || IGS_GE_NUMBER.TO_CANN(c_appl_offer_rec.final_adm_ci_sequence_number) );
1212: fnd_file.put_line(fnd_file.log, 'Application could not be created');
1213: fnd_file.put_line(fnd_file.log, fnd_message.get);
1214: ELSE
1215: fnd_file.put_line(fnd_file.log, 'Application could not be created');
1216: fnd_message.set_name('IGS', v_message_name);

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

1209: fnd_message.set_token('PGM', c_appl_offer_rec.nominated_course_cd);
1210: 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)
1211: || '/' || c_appl_offer_rec.final_adm_cal_type || ',' || IGS_GE_NUMBER.TO_CANN(c_appl_offer_rec.final_adm_ci_sequence_number) );
1212: fnd_file.put_line(fnd_file.log, 'Application could not be created');
1213: fnd_file.put_line(fnd_file.log, fnd_message.get);
1214: ELSE
1215: fnd_file.put_line(fnd_file.log, 'Application could not be created');
1216: fnd_message.set_name('IGS', v_message_name);
1217: fnd_file.put_line(fnd_file.log, fnd_message.get);

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

1211: || '/' || c_appl_offer_rec.final_adm_cal_type || ',' || IGS_GE_NUMBER.TO_CANN(c_appl_offer_rec.final_adm_ci_sequence_number) );
1212: fnd_file.put_line(fnd_file.log, 'Application could not be created');
1213: fnd_file.put_line(fnd_file.log, fnd_message.get);
1214: ELSE
1215: fnd_file.put_line(fnd_file.log, 'Application could not be created');
1216: fnd_message.set_name('IGS', v_message_name);
1217: fnd_file.put_line(fnd_file.log, fnd_message.get);
1218: END IF;
1219: RETURN FALSE;

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

1213: fnd_file.put_line(fnd_file.log, fnd_message.get);
1214: ELSE
1215: fnd_file.put_line(fnd_file.log, 'Application could not be created');
1216: fnd_message.set_name('IGS', v_message_name);
1217: fnd_file.put_line(fnd_file.log, fnd_message.get);
1218: END IF;
1219: RETURN FALSE;
1220: END IF;
1221: END LOOP;

Line 1224: fnd_file.put_line(fnd_file.log, 'Error from validate_offer_validations: ' || SQLERRM);

1220: END IF;
1221: END LOOP;
1222: RETURN TRUE;
1223: EXCEPTION WHEN OTHERS THEN
1224: fnd_file.put_line(fnd_file.log, 'Error from validate_offer_validations: ' || SQLERRM);
1225: fnd_file.put_line(fnd_file.log, 'Person Number : ' || get_person_number(IGS_GE_NUMBER.TO_CANN(p_person_id)));
1226: fnd_file.put_line(fnd_file.log, 'Admission Appl Number : ' || IGS_GE_NUMBER.TO_CANN(p_admission_appl_number));
1227: fnd_file.put_line(fnd_file.log, 'Nominated Course Code : ' || p_nominated_course_cd);
1228: fnd_file.put_line(fnd_file.log, 'Sequence Number : ' || p_sequence_number);

Line 1225: fnd_file.put_line(fnd_file.log, 'Person Number : ' || get_person_number(IGS_GE_NUMBER.TO_CANN(p_person_id)));

1221: END LOOP;
1222: RETURN TRUE;
1223: EXCEPTION WHEN OTHERS THEN
1224: fnd_file.put_line(fnd_file.log, 'Error from validate_offer_validations: ' || SQLERRM);
1225: fnd_file.put_line(fnd_file.log, 'Person Number : ' || get_person_number(IGS_GE_NUMBER.TO_CANN(p_person_id)));
1226: fnd_file.put_line(fnd_file.log, 'Admission Appl Number : ' || IGS_GE_NUMBER.TO_CANN(p_admission_appl_number));
1227: fnd_file.put_line(fnd_file.log, 'Nominated Course Code : ' || p_nominated_course_cd);
1228: fnd_file.put_line(fnd_file.log, 'Sequence Number : ' || p_sequence_number);
1229: RETURN FALSE;

Line 1226: fnd_file.put_line(fnd_file.log, 'Admission Appl Number : ' || IGS_GE_NUMBER.TO_CANN(p_admission_appl_number));

1222: RETURN TRUE;
1223: EXCEPTION WHEN OTHERS THEN
1224: fnd_file.put_line(fnd_file.log, 'Error from validate_offer_validations: ' || SQLERRM);
1225: fnd_file.put_line(fnd_file.log, 'Person Number : ' || get_person_number(IGS_GE_NUMBER.TO_CANN(p_person_id)));
1226: fnd_file.put_line(fnd_file.log, 'Admission Appl Number : ' || IGS_GE_NUMBER.TO_CANN(p_admission_appl_number));
1227: fnd_file.put_line(fnd_file.log, 'Nominated Course Code : ' || p_nominated_course_cd);
1228: fnd_file.put_line(fnd_file.log, 'Sequence Number : ' || p_sequence_number);
1229: RETURN FALSE;
1230: END validate_offer_validations;

Line 1227: fnd_file.put_line(fnd_file.log, 'Nominated Course Code : ' || p_nominated_course_cd);

1223: EXCEPTION WHEN OTHERS THEN
1224: fnd_file.put_line(fnd_file.log, 'Error from validate_offer_validations: ' || SQLERRM);
1225: fnd_file.put_line(fnd_file.log, 'Person Number : ' || get_person_number(IGS_GE_NUMBER.TO_CANN(p_person_id)));
1226: fnd_file.put_line(fnd_file.log, 'Admission Appl Number : ' || IGS_GE_NUMBER.TO_CANN(p_admission_appl_number));
1227: fnd_file.put_line(fnd_file.log, 'Nominated Course Code : ' || p_nominated_course_cd);
1228: fnd_file.put_line(fnd_file.log, 'Sequence Number : ' || p_sequence_number);
1229: RETURN FALSE;
1230: END validate_offer_validations;
1231:

Line 1228: fnd_file.put_line(fnd_file.log, 'Sequence Number : ' || p_sequence_number);

1224: fnd_file.put_line(fnd_file.log, 'Error from validate_offer_validations: ' || SQLERRM);
1225: fnd_file.put_line(fnd_file.log, 'Person Number : ' || get_person_number(IGS_GE_NUMBER.TO_CANN(p_person_id)));
1226: fnd_file.put_line(fnd_file.log, 'Admission Appl Number : ' || IGS_GE_NUMBER.TO_CANN(p_admission_appl_number));
1227: fnd_file.put_line(fnd_file.log, 'Nominated Course Code : ' || p_nominated_course_cd);
1228: fnd_file.put_line(fnd_file.log, 'Sequence Number : ' || p_sequence_number);
1229: RETURN FALSE;
1230: END validate_offer_validations;
1231:
1232: FUNCTION copy_entrycomp_qual_status(p_person_id HZ_PARTIES.PARTY_ID%TYPE,

Line 1516: fnd_file.put_line(fnd_file.log, 'Error from copy_entrycomp_qual_status: ' || SQLERRM);

1512: END LOOP;
1513: END LOOP;
1514: RETURN TRUE;
1515: EXCEPTION WHEN OTHERS THEN
1516: fnd_file.put_line(fnd_file.log, 'Error from copy_entrycomp_qual_status: ' || SQLERRM);
1517: fnd_file.put_line(fnd_file.log, 'Person Number : ' || get_person_number(IGS_GE_NUMBER.TO_CANN(p_person_id)));
1518: fnd_file.put_line(fnd_file.log, 'Admission Appl Number : ' || IGS_GE_NUMBER.TO_CANN(p_admission_appl_number));
1519: fnd_file.put_line(fnd_file.log, 'Nominated Course Code : ' || p_nominated_course_cd);
1520: fnd_file.put_line(fnd_file.log, 'Sequence Number : ' || p_sequence_number);

Line 1517: fnd_file.put_line(fnd_file.log, 'Person Number : ' || get_person_number(IGS_GE_NUMBER.TO_CANN(p_person_id)));

1513: END LOOP;
1514: RETURN TRUE;
1515: EXCEPTION WHEN OTHERS THEN
1516: fnd_file.put_line(fnd_file.log, 'Error from copy_entrycomp_qual_status: ' || SQLERRM);
1517: fnd_file.put_line(fnd_file.log, 'Person Number : ' || get_person_number(IGS_GE_NUMBER.TO_CANN(p_person_id)));
1518: fnd_file.put_line(fnd_file.log, 'Admission Appl Number : ' || IGS_GE_NUMBER.TO_CANN(p_admission_appl_number));
1519: fnd_file.put_line(fnd_file.log, 'Nominated Course Code : ' || p_nominated_course_cd);
1520: fnd_file.put_line(fnd_file.log, 'Sequence Number : ' || p_sequence_number);
1521: RETURN FALSE;

Line 1518: fnd_file.put_line(fnd_file.log, 'Admission Appl Number : ' || IGS_GE_NUMBER.TO_CANN(p_admission_appl_number));

1514: RETURN TRUE;
1515: EXCEPTION WHEN OTHERS THEN
1516: fnd_file.put_line(fnd_file.log, 'Error from copy_entrycomp_qual_status: ' || SQLERRM);
1517: fnd_file.put_line(fnd_file.log, 'Person Number : ' || get_person_number(IGS_GE_NUMBER.TO_CANN(p_person_id)));
1518: fnd_file.put_line(fnd_file.log, 'Admission Appl Number : ' || IGS_GE_NUMBER.TO_CANN(p_admission_appl_number));
1519: fnd_file.put_line(fnd_file.log, 'Nominated Course Code : ' || p_nominated_course_cd);
1520: fnd_file.put_line(fnd_file.log, 'Sequence Number : ' || p_sequence_number);
1521: RETURN FALSE;
1522: END copy_entrycomp_qual_status;

Line 1519: fnd_file.put_line(fnd_file.log, 'Nominated Course Code : ' || p_nominated_course_cd);

1515: EXCEPTION WHEN OTHERS THEN
1516: fnd_file.put_line(fnd_file.log, 'Error from copy_entrycomp_qual_status: ' || SQLERRM);
1517: fnd_file.put_line(fnd_file.log, 'Person Number : ' || get_person_number(IGS_GE_NUMBER.TO_CANN(p_person_id)));
1518: fnd_file.put_line(fnd_file.log, 'Admission Appl Number : ' || IGS_GE_NUMBER.TO_CANN(p_admission_appl_number));
1519: fnd_file.put_line(fnd_file.log, 'Nominated Course Code : ' || p_nominated_course_cd);
1520: fnd_file.put_line(fnd_file.log, 'Sequence Number : ' || p_sequence_number);
1521: RETURN FALSE;
1522: END copy_entrycomp_qual_status;
1523:

Line 1520: fnd_file.put_line(fnd_file.log, 'Sequence Number : ' || p_sequence_number);

1516: fnd_file.put_line(fnd_file.log, 'Error from copy_entrycomp_qual_status: ' || SQLERRM);
1517: fnd_file.put_line(fnd_file.log, 'Person Number : ' || get_person_number(IGS_GE_NUMBER.TO_CANN(p_person_id)));
1518: fnd_file.put_line(fnd_file.log, 'Admission Appl Number : ' || IGS_GE_NUMBER.TO_CANN(p_admission_appl_number));
1519: fnd_file.put_line(fnd_file.log, 'Nominated Course Code : ' || p_nominated_course_cd);
1520: fnd_file.put_line(fnd_file.log, 'Sequence Number : ' || p_sequence_number);
1521: RETURN FALSE;
1522: END copy_entrycomp_qual_status;
1523:
1524:

Line 1754: fnd_file.put_line(fnd_file.log, 'Application could not be created'); -- added - apadegal adtd001 igs.m

1750: 'Y', -- Confirm course indicator.
1751: 'Y', -- Perform eligibility check indicator.
1752: v_message_name) = FALSE THEN
1753: fnd_message.set_name('IGS', v_message_name);
1754: fnd_file.put_line(fnd_file.log, 'Application could not be created'); -- added - apadegal adtd001 igs.m
1755: fnd_file.put_line(fnd_file.log, fnd_message.get);
1756: RETURN FALSE ; -- added - apadegal adtd001 igs.m
1757: END IF;
1758:

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

1751: 'Y', -- Perform eligibility check indicator.
1752: v_message_name) = FALSE THEN
1753: fnd_message.set_name('IGS', v_message_name);
1754: fnd_file.put_line(fnd_file.log, 'Application could not be created'); -- added - apadegal adtd001 igs.m
1755: fnd_file.put_line(fnd_file.log, fnd_message.get);
1756: RETURN FALSE ; -- added - apadegal adtd001 igs.m
1757: END IF;
1758:
1759: RETURN TRUE; -- added - apadegal adtd001 igs.m

Line 1762: -- fnd_file.put_line(fnd_file.log, 'Exception From Update offer response log ' || v_message_name);

1758:
1759: RETURN TRUE; -- added - apadegal adtd001 igs.m
1760:
1761: EXCEPTION WHEN OTHERS THEN
1762: -- fnd_file.put_line(fnd_file.log, 'Exception From Update offer response log ' || v_message_name);
1763:
1764: -- begin - apadegal adtd001 igs.m
1765: fnd_file.put_line(fnd_file.log, 'Exception From Update offer response log ' || SQLERRM);
1766: RETURN FALSE;

Line 1765: fnd_file.put_line(fnd_file.log, 'Exception From Update offer response log ' || SQLERRM);

1761: EXCEPTION WHEN OTHERS THEN
1762: -- fnd_file.put_line(fnd_file.log, 'Exception From Update offer response log ' || v_message_name);
1763:
1764: -- begin - apadegal adtd001 igs.m
1765: fnd_file.put_line(fnd_file.log, 'Exception From Update offer response log ' || SQLERRM);
1766: RETURN FALSE;
1767: -- end - apadegal adtd001 igs.m
1768: END update_offer_response_accepted;
1769: