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));
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)) ;
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));
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));
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));
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));
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));
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));
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));
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));
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));
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));
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,' ');
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:
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:
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
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,
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,
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);
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
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.
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
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
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: