APPS.IGS_PS_RLOVR_FAC_TSK dependencies on FND_FILE

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

527:
528: FND_MESSAGE.SET_NAME('IGS','IGS_FI_CAL_BALANCES_LOG');
529: FND_MESSAGE.SET_TOKEN('PARAMETER_NAME',p_msg_name);
530: FND_MESSAGE.SET_TOKEN('PARAMETER_VAL' ,p_msg_val) ;
531: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
532:
533: END log_messages ;
534:
535:

Line 678: Fnd_File.Put_Line(Fnd_File.LOG,FND_MESSAGE.GET);

674:
675: /** logs all the parameters in the LOG **/
676: --
677: Fnd_Message.Set_Name('IGS','IGS_FI_ANC_LOG_PARM');
678: Fnd_File.Put_Line(Fnd_File.LOG,FND_MESSAGE.GET);
679: IF p_person_id IS NOT NULL THEN
680: OPEN c_per_id(p_person_id);
681: FETCH c_per_id INTO l_per_id;
682: CLOSE c_per_id;

Line 687: FND_FILE.PUT_LINE(Fnd_File.LOG,' ') ;

683: END IF;
684: log_messages(igs_ps_validate_lgcy_pkg.get_lkup_meaning('PERSON_NUMBER','LEGACY_TOKENS'),l_per_id.person_number);
685: log_messages(igs_ps_validate_lgcy_pkg.get_lkup_meaning('SOURCE_CAL','IGS_PS_LOG_PARAMETERS'),p_source_cal_type);
686: log_messages(igs_ps_validate_lgcy_pkg.get_lkup_meaning('DEST_CAL','IGS_PS_LOG_PARAMETERS'),p_dest_cal_type);
687: FND_FILE.PUT_LINE(Fnd_File.LOG,' ') ;
688:
689: -- get the source and dest calendar categories
690: --
691: OPEN cur_cal_cat(l_source_cal_type);

Line 703: FND_FILE.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET) ;

699: --
700: IF l_source_cal_cat <> l_dest_cal_cat THEN
701: retcode := 2 ;
702: FND_MESSAGE.SET_NAME('IGS','IGS_PS_SAME_CAL_CAT');
703: FND_FILE.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET) ;
704: RETURN ;
705: END IF;
706:
707: --if source calendar starts later than the dest calendar then log message in file and return

Line 712: FND_FILE.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET) ;

708: --
709: IF l_source_start_date >= l_dest_start_date THEN
710: retcode := 2 ;
711: FND_MESSAGE.SET_NAME('IGS','IGS_PS_SOURCE_MORE_DEST');
712: FND_FILE.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET) ;
713: RETURN ;
714: END IF;
715:
716: -- copy all the eligible faculty workload records to be rolled over ,into the plsql table

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

742: --
743: IF l_tab_person_id.COUNT = 0 THEN
744: retcode := 2 ;
745: FND_MESSAGE.SET_NAME('IGS','IGS_PS_NO_ROLLOVER');
746: FND_FILE.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET) ;
747: RETURN ;
748: END IF;
749:
750: -- log the heading

Line 753: FND_FILE.PUT_LINE(Fnd_File.LOG, Fnd_Message.GET ) ;

749:
750: -- log the heading
751: --
752: FND_MESSAGE.SET_NAME('IGS','IGS_PS_ROLLOVER_FAC_PROC');
753: FND_FILE.PUT_LINE(Fnd_File.LOG, Fnd_Message.GET ) ;
754:
755: -- for each of the eligible faculty records rollover into dest calendar
756: -- and copy the tasks assigned to that faculty to the dest calendar also
757: --

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

764: FETCH c_per_id INTO l_per_id;
765: FND_MESSAGE.SET_NAME('IGS','IGS_PS_RLOVR_FACULTY');
766: FND_MESSAGE.SET_TOKEN('NUMBER',RPAD(l_per_id.person_number,30));
767: FND_MESSAGE.SET_TOKEN('NAME',l_per_id.person_name);
768: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);
769: CLOSE c_per_id;
770:
771: OPEN cur_fac_wl_exists(l_tab_person_id(i).person_id) ;
772: FETCH cur_fac_wl_exists INTO l_fac_wl_id ;

Line 839: FND_FILE.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET ) ;

835: -- log the task rolled over
836: --
837: FND_MESSAGE.SET_NAME('IGS','IGS_PS_FAC_RLOVR_TASK');
838: FND_MESSAGE.SET_TOKEN('TASK',cur_source_tasks_rec.faculty_task_type );
839: FND_FILE.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET ) ;
840: END ;
841: END IF; -- task does not exists already
842: CLOSE cur_fat_exists ;
843:

Line 869: FND_FILE.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET) ;

865:
866: -- log the successful completion of the job and return
867: --
868: FND_MESSAGE.SET_NAME('IGS','IGS_PS_FAC_RLOVR_SUC');
869: FND_FILE.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET) ;
870: RETURN ;
871:
872: EXCEPTION
873: WHEN OTHERS THEN