DBA Data[Home] [Help]

APPS.IGS_AS_NOTIFY_PKG dependencies on FND_FILE

Line 415: FND_FILE.PUT_LINE(FND_FILE.LOG,'+-------------------------Parameters Passed---------------------------------+');

411: l_ld_sequence_number := TO_NUMBER(SUBSTR(p_load_calendar,-6));
412:
413: /* Print the Parameters Passed */
414:
415: FND_FILE.PUT_LINE(FND_FILE.LOG,'+-------------------------Parameters Passed---------------------------------+');
416: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
417: FND_FILE.PUT_LINE(FND_FILE.LOG,'Load Calendar Type : ' || l_ld_cal_type);
418: FND_FILE.PUT_LINE(FND_FILE.LOG,'Load Calendar Sequence no. : ' || to_char(l_ld_sequence_number));
419: FND_FILE.PUT_LINE(FND_FILE.LOG,'Attendance Advance Offset : ' || TO_CHAR(p_attend_advance_offset));

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

412:
413: /* Print the Parameters Passed */
414:
415: FND_FILE.PUT_LINE(FND_FILE.LOG,'+-------------------------Parameters Passed---------------------------------+');
416: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
417: FND_FILE.PUT_LINE(FND_FILE.LOG,'Load Calendar Type : ' || l_ld_cal_type);
418: FND_FILE.PUT_LINE(FND_FILE.LOG,'Load Calendar Sequence no. : ' || to_char(l_ld_sequence_number));
419: FND_FILE.PUT_LINE(FND_FILE.LOG,'Attendance Advance Offset : ' || TO_CHAR(p_attend_advance_offset));
420: FND_FILE.PUT_LINE(FND_FILE.LOG,'Attendance Start Offset : ' || TO_CHAR(p_attend_start_offset)) ;

Line 417: FND_FILE.PUT_LINE(FND_FILE.LOG,'Load Calendar Type : ' || l_ld_cal_type);

413: /* Print the Parameters Passed */
414:
415: FND_FILE.PUT_LINE(FND_FILE.LOG,'+-------------------------Parameters Passed---------------------------------+');
416: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
417: FND_FILE.PUT_LINE(FND_FILE.LOG,'Load Calendar Type : ' || l_ld_cal_type);
418: FND_FILE.PUT_LINE(FND_FILE.LOG,'Load Calendar Sequence no. : ' || to_char(l_ld_sequence_number));
419: FND_FILE.PUT_LINE(FND_FILE.LOG,'Attendance Advance Offset : ' || TO_CHAR(p_attend_advance_offset));
420: FND_FILE.PUT_LINE(FND_FILE.LOG,'Attendance Start Offset : ' || TO_CHAR(p_attend_start_offset)) ;
421: FND_FILE.PUT_LINE(FND_FILE.LOG,'Attendance End Offset : ' || TO_CHAR(p_attend_end_offset));

Line 418: FND_FILE.PUT_LINE(FND_FILE.LOG,'Load Calendar Sequence no. : ' || to_char(l_ld_sequence_number));

414:
415: FND_FILE.PUT_LINE(FND_FILE.LOG,'+-------------------------Parameters Passed---------------------------------+');
416: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
417: FND_FILE.PUT_LINE(FND_FILE.LOG,'Load Calendar Type : ' || l_ld_cal_type);
418: FND_FILE.PUT_LINE(FND_FILE.LOG,'Load Calendar Sequence no. : ' || to_char(l_ld_sequence_number));
419: FND_FILE.PUT_LINE(FND_FILE.LOG,'Attendance Advance Offset : ' || TO_CHAR(p_attend_advance_offset));
420: FND_FILE.PUT_LINE(FND_FILE.LOG,'Attendance Start Offset : ' || TO_CHAR(p_attend_start_offset)) ;
421: FND_FILE.PUT_LINE(FND_FILE.LOG,'Attendance End Offset : ' || TO_CHAR(p_attend_end_offset));
422: FND_FILE.PUT_LINE(FND_FILE.LOG,'Grade-Mid Term Advance Offset : ' || TO_CHAR(p_midterm_advance_offset));

Line 419: FND_FILE.PUT_LINE(FND_FILE.LOG,'Attendance Advance Offset : ' || TO_CHAR(p_attend_advance_offset));

415: FND_FILE.PUT_LINE(FND_FILE.LOG,'+-------------------------Parameters Passed---------------------------------+');
416: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
417: FND_FILE.PUT_LINE(FND_FILE.LOG,'Load Calendar Type : ' || l_ld_cal_type);
418: FND_FILE.PUT_LINE(FND_FILE.LOG,'Load Calendar Sequence no. : ' || to_char(l_ld_sequence_number));
419: FND_FILE.PUT_LINE(FND_FILE.LOG,'Attendance Advance Offset : ' || TO_CHAR(p_attend_advance_offset));
420: FND_FILE.PUT_LINE(FND_FILE.LOG,'Attendance Start Offset : ' || TO_CHAR(p_attend_start_offset)) ;
421: FND_FILE.PUT_LINE(FND_FILE.LOG,'Attendance End Offset : ' || TO_CHAR(p_attend_end_offset));
422: FND_FILE.PUT_LINE(FND_FILE.LOG,'Grade-Mid Term Advance Offset : ' || TO_CHAR(p_midterm_advance_offset));
423: FND_FILE.PUT_LINE(FND_FILE.LOG,'Grade-Mid Term Start Offset : ' || TO_CHAR(p_midterm_start_offset));

Line 420: FND_FILE.PUT_LINE(FND_FILE.LOG,'Attendance Start Offset : ' || TO_CHAR(p_attend_start_offset)) ;

416: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
417: FND_FILE.PUT_LINE(FND_FILE.LOG,'Load Calendar Type : ' || l_ld_cal_type);
418: FND_FILE.PUT_LINE(FND_FILE.LOG,'Load Calendar Sequence no. : ' || to_char(l_ld_sequence_number));
419: FND_FILE.PUT_LINE(FND_FILE.LOG,'Attendance Advance Offset : ' || TO_CHAR(p_attend_advance_offset));
420: FND_FILE.PUT_LINE(FND_FILE.LOG,'Attendance Start Offset : ' || TO_CHAR(p_attend_start_offset)) ;
421: FND_FILE.PUT_LINE(FND_FILE.LOG,'Attendance End Offset : ' || TO_CHAR(p_attend_end_offset));
422: FND_FILE.PUT_LINE(FND_FILE.LOG,'Grade-Mid Term Advance Offset : ' || TO_CHAR(p_midterm_advance_offset));
423: FND_FILE.PUT_LINE(FND_FILE.LOG,'Grade-Mid Term Start Offset : ' || TO_CHAR(p_midterm_start_offset));
424: FND_FILE.PUT_LINE(FND_FILE.LOG,'Grade-Mid Term End Offset : ' || TO_CHAR(p_midterm_end_offset));

Line 421: FND_FILE.PUT_LINE(FND_FILE.LOG,'Attendance End Offset : ' || TO_CHAR(p_attend_end_offset));

417: FND_FILE.PUT_LINE(FND_FILE.LOG,'Load Calendar Type : ' || l_ld_cal_type);
418: FND_FILE.PUT_LINE(FND_FILE.LOG,'Load Calendar Sequence no. : ' || to_char(l_ld_sequence_number));
419: FND_FILE.PUT_LINE(FND_FILE.LOG,'Attendance Advance Offset : ' || TO_CHAR(p_attend_advance_offset));
420: FND_FILE.PUT_LINE(FND_FILE.LOG,'Attendance Start Offset : ' || TO_CHAR(p_attend_start_offset)) ;
421: FND_FILE.PUT_LINE(FND_FILE.LOG,'Attendance End Offset : ' || TO_CHAR(p_attend_end_offset));
422: FND_FILE.PUT_LINE(FND_FILE.LOG,'Grade-Mid Term Advance Offset : ' || TO_CHAR(p_midterm_advance_offset));
423: FND_FILE.PUT_LINE(FND_FILE.LOG,'Grade-Mid Term Start Offset : ' || TO_CHAR(p_midterm_start_offset));
424: FND_FILE.PUT_LINE(FND_FILE.LOG,'Grade-Mid Term End Offset : ' || TO_CHAR(p_midterm_end_offset));
425: FND_FILE.PUT_LINE(FND_FILE.LOG,'Grade-Early Final Advance Offset : ' || TO_CHAR(p_earlyfinal_advance_offset));

Line 422: FND_FILE.PUT_LINE(FND_FILE.LOG,'Grade-Mid Term Advance Offset : ' || TO_CHAR(p_midterm_advance_offset));

418: FND_FILE.PUT_LINE(FND_FILE.LOG,'Load Calendar Sequence no. : ' || to_char(l_ld_sequence_number));
419: FND_FILE.PUT_LINE(FND_FILE.LOG,'Attendance Advance Offset : ' || TO_CHAR(p_attend_advance_offset));
420: FND_FILE.PUT_LINE(FND_FILE.LOG,'Attendance Start Offset : ' || TO_CHAR(p_attend_start_offset)) ;
421: FND_FILE.PUT_LINE(FND_FILE.LOG,'Attendance End Offset : ' || TO_CHAR(p_attend_end_offset));
422: FND_FILE.PUT_LINE(FND_FILE.LOG,'Grade-Mid Term Advance Offset : ' || TO_CHAR(p_midterm_advance_offset));
423: FND_FILE.PUT_LINE(FND_FILE.LOG,'Grade-Mid Term Start Offset : ' || TO_CHAR(p_midterm_start_offset));
424: FND_FILE.PUT_LINE(FND_FILE.LOG,'Grade-Mid Term End Offset : ' || TO_CHAR(p_midterm_end_offset));
425: FND_FILE.PUT_LINE(FND_FILE.LOG,'Grade-Early Final Advance Offset : ' || TO_CHAR(p_earlyfinal_advance_offset));
426: FND_FILE.PUT_LINE(FND_FILE.LOG,'Grade-Early Final Start Offset : ' || TO_CHAR(p_earlyfinal_start_offset));

Line 423: FND_FILE.PUT_LINE(FND_FILE.LOG,'Grade-Mid Term Start Offset : ' || TO_CHAR(p_midterm_start_offset));

419: FND_FILE.PUT_LINE(FND_FILE.LOG,'Attendance Advance Offset : ' || TO_CHAR(p_attend_advance_offset));
420: FND_FILE.PUT_LINE(FND_FILE.LOG,'Attendance Start Offset : ' || TO_CHAR(p_attend_start_offset)) ;
421: FND_FILE.PUT_LINE(FND_FILE.LOG,'Attendance End Offset : ' || TO_CHAR(p_attend_end_offset));
422: FND_FILE.PUT_LINE(FND_FILE.LOG,'Grade-Mid Term Advance Offset : ' || TO_CHAR(p_midterm_advance_offset));
423: FND_FILE.PUT_LINE(FND_FILE.LOG,'Grade-Mid Term Start Offset : ' || TO_CHAR(p_midterm_start_offset));
424: FND_FILE.PUT_LINE(FND_FILE.LOG,'Grade-Mid Term End Offset : ' || TO_CHAR(p_midterm_end_offset));
425: FND_FILE.PUT_LINE(FND_FILE.LOG,'Grade-Early Final Advance Offset : ' || TO_CHAR(p_earlyfinal_advance_offset));
426: FND_FILE.PUT_LINE(FND_FILE.LOG,'Grade-Early Final Start Offset : ' || TO_CHAR(p_earlyfinal_start_offset));
427: FND_FILE.PUT_LINE(FND_FILE.LOG,'Grade-Early Final End Offset : ' || TO_CHAR(p_earlyfinal_end_offset));

Line 424: FND_FILE.PUT_LINE(FND_FILE.LOG,'Grade-Mid Term End Offset : ' || TO_CHAR(p_midterm_end_offset));

420: FND_FILE.PUT_LINE(FND_FILE.LOG,'Attendance Start Offset : ' || TO_CHAR(p_attend_start_offset)) ;
421: FND_FILE.PUT_LINE(FND_FILE.LOG,'Attendance End Offset : ' || TO_CHAR(p_attend_end_offset));
422: FND_FILE.PUT_LINE(FND_FILE.LOG,'Grade-Mid Term Advance Offset : ' || TO_CHAR(p_midterm_advance_offset));
423: FND_FILE.PUT_LINE(FND_FILE.LOG,'Grade-Mid Term Start Offset : ' || TO_CHAR(p_midterm_start_offset));
424: FND_FILE.PUT_LINE(FND_FILE.LOG,'Grade-Mid Term End Offset : ' || TO_CHAR(p_midterm_end_offset));
425: FND_FILE.PUT_LINE(FND_FILE.LOG,'Grade-Early Final Advance Offset : ' || TO_CHAR(p_earlyfinal_advance_offset));
426: FND_FILE.PUT_LINE(FND_FILE.LOG,'Grade-Early Final Start Offset : ' || TO_CHAR(p_earlyfinal_start_offset));
427: FND_FILE.PUT_LINE(FND_FILE.LOG,'Grade-Early Final End Offset : ' || TO_CHAR(p_earlyfinal_end_offset));
428: FND_FILE.PUT_LINE(FND_FILE.LOG,'Grade-Final Advance Offset : ' || TO_CHAR(p_final_advance_offset));

Line 425: FND_FILE.PUT_LINE(FND_FILE.LOG,'Grade-Early Final Advance Offset : ' || TO_CHAR(p_earlyfinal_advance_offset));

421: FND_FILE.PUT_LINE(FND_FILE.LOG,'Attendance End Offset : ' || TO_CHAR(p_attend_end_offset));
422: FND_FILE.PUT_LINE(FND_FILE.LOG,'Grade-Mid Term Advance Offset : ' || TO_CHAR(p_midterm_advance_offset));
423: FND_FILE.PUT_LINE(FND_FILE.LOG,'Grade-Mid Term Start Offset : ' || TO_CHAR(p_midterm_start_offset));
424: FND_FILE.PUT_LINE(FND_FILE.LOG,'Grade-Mid Term End Offset : ' || TO_CHAR(p_midterm_end_offset));
425: FND_FILE.PUT_LINE(FND_FILE.LOG,'Grade-Early Final Advance Offset : ' || TO_CHAR(p_earlyfinal_advance_offset));
426: FND_FILE.PUT_LINE(FND_FILE.LOG,'Grade-Early Final Start Offset : ' || TO_CHAR(p_earlyfinal_start_offset));
427: FND_FILE.PUT_LINE(FND_FILE.LOG,'Grade-Early Final End Offset : ' || TO_CHAR(p_earlyfinal_end_offset));
428: FND_FILE.PUT_LINE(FND_FILE.LOG,'Grade-Final Advance Offset : ' || TO_CHAR(p_final_advance_offset));
429: FND_FILE.PUT_LINE(FND_FILE.LOG,'Grade-Final Start Offset : ' || TO_CHAR(p_final_start_offset));

Line 426: FND_FILE.PUT_LINE(FND_FILE.LOG,'Grade-Early Final Start Offset : ' || TO_CHAR(p_earlyfinal_start_offset));

422: FND_FILE.PUT_LINE(FND_FILE.LOG,'Grade-Mid Term Advance Offset : ' || TO_CHAR(p_midterm_advance_offset));
423: FND_FILE.PUT_LINE(FND_FILE.LOG,'Grade-Mid Term Start Offset : ' || TO_CHAR(p_midterm_start_offset));
424: FND_FILE.PUT_LINE(FND_FILE.LOG,'Grade-Mid Term End Offset : ' || TO_CHAR(p_midterm_end_offset));
425: FND_FILE.PUT_LINE(FND_FILE.LOG,'Grade-Early Final Advance Offset : ' || TO_CHAR(p_earlyfinal_advance_offset));
426: FND_FILE.PUT_LINE(FND_FILE.LOG,'Grade-Early Final Start Offset : ' || TO_CHAR(p_earlyfinal_start_offset));
427: FND_FILE.PUT_LINE(FND_FILE.LOG,'Grade-Early Final End Offset : ' || TO_CHAR(p_earlyfinal_end_offset));
428: FND_FILE.PUT_LINE(FND_FILE.LOG,'Grade-Final Advance Offset : ' || TO_CHAR(p_final_advance_offset));
429: FND_FILE.PUT_LINE(FND_FILE.LOG,'Grade-Final Start Offset : ' || TO_CHAR(p_final_start_offset));
430: FND_FILE.PUT_LINE(FND_FILE.LOG,'Grade-Final End Offset : ' || TO_CHAR(p_final_end_offset));

Line 427: FND_FILE.PUT_LINE(FND_FILE.LOG,'Grade-Early Final End Offset : ' || TO_CHAR(p_earlyfinal_end_offset));

423: FND_FILE.PUT_LINE(FND_FILE.LOG,'Grade-Mid Term Start Offset : ' || TO_CHAR(p_midterm_start_offset));
424: FND_FILE.PUT_LINE(FND_FILE.LOG,'Grade-Mid Term End Offset : ' || TO_CHAR(p_midterm_end_offset));
425: FND_FILE.PUT_LINE(FND_FILE.LOG,'Grade-Early Final Advance Offset : ' || TO_CHAR(p_earlyfinal_advance_offset));
426: FND_FILE.PUT_LINE(FND_FILE.LOG,'Grade-Early Final Start Offset : ' || TO_CHAR(p_earlyfinal_start_offset));
427: FND_FILE.PUT_LINE(FND_FILE.LOG,'Grade-Early Final End Offset : ' || TO_CHAR(p_earlyfinal_end_offset));
428: FND_FILE.PUT_LINE(FND_FILE.LOG,'Grade-Final Advance Offset : ' || TO_CHAR(p_final_advance_offset));
429: FND_FILE.PUT_LINE(FND_FILE.LOG,'Grade-Final Start Offset : ' || TO_CHAR(p_final_start_offset));
430: FND_FILE.PUT_LINE(FND_FILE.LOG,'Grade-Final End Offset : ' || TO_CHAR(p_final_end_offset));
431: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');

Line 428: FND_FILE.PUT_LINE(FND_FILE.LOG,'Grade-Final Advance Offset : ' || TO_CHAR(p_final_advance_offset));

424: FND_FILE.PUT_LINE(FND_FILE.LOG,'Grade-Mid Term End Offset : ' || TO_CHAR(p_midterm_end_offset));
425: FND_FILE.PUT_LINE(FND_FILE.LOG,'Grade-Early Final Advance Offset : ' || TO_CHAR(p_earlyfinal_advance_offset));
426: FND_FILE.PUT_LINE(FND_FILE.LOG,'Grade-Early Final Start Offset : ' || TO_CHAR(p_earlyfinal_start_offset));
427: FND_FILE.PUT_LINE(FND_FILE.LOG,'Grade-Early Final End Offset : ' || TO_CHAR(p_earlyfinal_end_offset));
428: FND_FILE.PUT_LINE(FND_FILE.LOG,'Grade-Final Advance Offset : ' || TO_CHAR(p_final_advance_offset));
429: FND_FILE.PUT_LINE(FND_FILE.LOG,'Grade-Final Start Offset : ' || TO_CHAR(p_final_start_offset));
430: FND_FILE.PUT_LINE(FND_FILE.LOG,'Grade-Final End Offset : ' || TO_CHAR(p_final_end_offset));
431: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
432:

Line 429: FND_FILE.PUT_LINE(FND_FILE.LOG,'Grade-Final Start Offset : ' || TO_CHAR(p_final_start_offset));

425: FND_FILE.PUT_LINE(FND_FILE.LOG,'Grade-Early Final Advance Offset : ' || TO_CHAR(p_earlyfinal_advance_offset));
426: FND_FILE.PUT_LINE(FND_FILE.LOG,'Grade-Early Final Start Offset : ' || TO_CHAR(p_earlyfinal_start_offset));
427: FND_FILE.PUT_LINE(FND_FILE.LOG,'Grade-Early Final End Offset : ' || TO_CHAR(p_earlyfinal_end_offset));
428: FND_FILE.PUT_LINE(FND_FILE.LOG,'Grade-Final Advance Offset : ' || TO_CHAR(p_final_advance_offset));
429: FND_FILE.PUT_LINE(FND_FILE.LOG,'Grade-Final Start Offset : ' || TO_CHAR(p_final_start_offset));
430: FND_FILE.PUT_LINE(FND_FILE.LOG,'Grade-Final End Offset : ' || TO_CHAR(p_final_end_offset));
431: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
432:
433:

Line 430: FND_FILE.PUT_LINE(FND_FILE.LOG,'Grade-Final End Offset : ' || TO_CHAR(p_final_end_offset));

426: FND_FILE.PUT_LINE(FND_FILE.LOG,'Grade-Early Final Start Offset : ' || TO_CHAR(p_earlyfinal_start_offset));
427: FND_FILE.PUT_LINE(FND_FILE.LOG,'Grade-Early Final End Offset : ' || TO_CHAR(p_earlyfinal_end_offset));
428: FND_FILE.PUT_LINE(FND_FILE.LOG,'Grade-Final Advance Offset : ' || TO_CHAR(p_final_advance_offset));
429: FND_FILE.PUT_LINE(FND_FILE.LOG,'Grade-Final Start Offset : ' || TO_CHAR(p_final_start_offset));
430: FND_FILE.PUT_LINE(FND_FILE.LOG,'Grade-Final End Offset : ' || TO_CHAR(p_final_end_offset));
431: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
432:
433:
434: -- Get grading date aliases

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

427: FND_FILE.PUT_LINE(FND_FILE.LOG,'Grade-Early Final End Offset : ' || TO_CHAR(p_earlyfinal_end_offset));
428: FND_FILE.PUT_LINE(FND_FILE.LOG,'Grade-Final Advance Offset : ' || TO_CHAR(p_final_advance_offset));
429: FND_FILE.PUT_LINE(FND_FILE.LOG,'Grade-Final Start Offset : ' || TO_CHAR(p_final_start_offset));
430: FND_FILE.PUT_LINE(FND_FILE.LOG,'Grade-Final End Offset : ' || TO_CHAR(p_final_end_offset));
431: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
432:
433:
434: -- Get grading date aliases
435: SELECT acc.mid_mgs_start_dt_alias,

Line 453: FND_FILE.PUT_LINE(FND_FILE.LOG,'+-------------------------Processing for Teaching Calendar'||':'||v_ttl_rec.teach_description||'---------------------------------+');

449: WHERE s_control_num = 1;
450:
451:
452: FOR v_ttl_rec IN c_ttl LOOP
453: FND_FILE.PUT_LINE(FND_FILE.LOG,'+-------------------------Processing for Teaching Calendar'||':'||v_ttl_rec.teach_description||'---------------------------------+');
454: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
455: -- Get the date alias values for each of the grading date aliases
456: v_midterm_start_dt := get_dt_alias_val (lp_dt_alias => v_mid_mgs_start_dt_alias,
457: lp_teach_cal_type => v_ttl_rec.teach_cal_type,

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

450:
451:
452: FOR v_ttl_rec IN c_ttl LOOP
453: FND_FILE.PUT_LINE(FND_FILE.LOG,'+-------------------------Processing for Teaching Calendar'||':'||v_ttl_rec.teach_description||'---------------------------------+');
454: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
455: -- Get the date alias values for each of the grading date aliases
456: v_midterm_start_dt := get_dt_alias_val (lp_dt_alias => v_mid_mgs_start_dt_alias,
457: lp_teach_cal_type => v_ttl_rec.teach_cal_type,
458: lp_teach_ci_sequence_number => v_ttl_rec.teach_ci_sequence_number);

Line 475: FND_FILE.PUT_LINE(FND_FILE.LOG,'+-------------------------Alias Date Values Derived---------------------------------+');

471: v_final_end_dt := get_dt_alias_val (lp_dt_alias => v_final_mgs_end_dt_alias,
472: lp_teach_cal_type => v_ttl_rec.teach_cal_type,
473: lp_teach_ci_sequence_number => v_ttl_rec.teach_ci_sequence_number);
474:
475: FND_FILE.PUT_LINE(FND_FILE.LOG,'+-------------------------Alias Date Values Derived---------------------------------+');
476: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
477: -- Attendance Notifications
478:
479: -- Check if the Attendance Advanced Notification date

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

472: lp_teach_cal_type => v_ttl_rec.teach_cal_type,
473: lp_teach_ci_sequence_number => v_ttl_rec.teach_ci_sequence_number);
474:
475: FND_FILE.PUT_LINE(FND_FILE.LOG,'+-------------------------Alias Date Values Derived---------------------------------+');
476: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
477: -- Attendance Notifications
478:
479: -- Check if the Attendance Advanced Notification date
480: -- has been reached. Offset from final grading start date.

Line 654: FND_FILE.PUT_LINE(FND_FILE.LOG,'+----Processing for Unit Section'||':'||to_char(v_uoo_rec.uoo_id)||':'||v_uoo_rec.unit_cd||':'||v_uoo_rec.unit_class||'----+');

650: v_final_end )THEN
651:
652: FOR v_uoo_rec IN c_uoo(v_ttl_rec.teach_cal_type,v_ttl_rec.teach_ci_sequence_number) LOOP
653:
654: FND_FILE.PUT_LINE(FND_FILE.LOG,'+----Processing for Unit Section'||':'||to_char(v_uoo_rec.uoo_id)||':'||v_uoo_rec.unit_cd||':'||v_uoo_rec.unit_class||'----+');
655: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
656: -- Attendance Notifications
657: IF (v_uoo_rec.attendance_required_ind = 'Y' AND
658: (v_attend_advance OR

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

651:
652: FOR v_uoo_rec IN c_uoo(v_ttl_rec.teach_cal_type,v_ttl_rec.teach_ci_sequence_number) LOOP
653:
654: FND_FILE.PUT_LINE(FND_FILE.LOG,'+----Processing for Unit Section'||':'||to_char(v_uoo_rec.uoo_id)||':'||v_uoo_rec.unit_cd||':'||v_uoo_rec.unit_class||'----+');
655: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
656: -- Attendance Notifications
657: IF (v_uoo_rec.attendance_required_ind = 'Y' AND
658: (v_attend_advance OR
659: v_attend_start OR

Line 949: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.Get);

945: errbuf := FND_MESSAGE.GET_STRING('IGS','IGS_GE_UNHANDLED_EXCEPTION');
946: retcode := 2;
947: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
948: FND_MESSAGE.SET_TOKEN('NAME','IGS_AS_NOTIFY_PKG.GEN_AS_NOTIFICATIONS');
949: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.Get);
950: IGS_GE_MSG_STACK.ADD;
951: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;
952:
953: