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_PS_RLOVR_FAC_TSK dependencies on FND_MESSAGE

Line 117: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');

113: RETURN FALSE ;
114:
115: EXCEPTION
116: WHEN OTHERS THEN
117: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
118: FND_MESSAGE.SET_TOKEN('NAME','Igs_ps_rlovr_fac_tsk.crsp_chk_inst_time_conft');
119: IGS_GE_MSG_STACK.ADD;
120: App_exception.raise_exception ;
121:

Line 118: FND_MESSAGE.SET_TOKEN('NAME','Igs_ps_rlovr_fac_tsk.crsp_chk_inst_time_conft');

114:
115: EXCEPTION
116: WHEN OTHERS THEN
117: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
118: FND_MESSAGE.SET_TOKEN('NAME','Igs_ps_rlovr_fac_tsk.crsp_chk_inst_time_conft');
119: IGS_GE_MSG_STACK.ADD;
120: App_exception.raise_exception ;
121:
122: END crsp_chk_inst_time_conft;

Line 295: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');

291: END IF;
292: IF cur_time_conflct%ISOPEN THEN
293: CLOSE cur_time_conflct ;
294: END IF;
295: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
296: FND_MESSAGE.SET_TOKEN('NAME','IGS_PS_RLOVR_FAC_TSK.crsp_instrct_time_conflct');
297: IGS_GE_MSG_STACK.ADD;
298: App_exception.raise_exception ;
299:

Line 296: FND_MESSAGE.SET_TOKEN('NAME','IGS_PS_RLOVR_FAC_TSK.crsp_instrct_time_conflct');

292: IF cur_time_conflct%ISOPEN THEN
293: CLOSE cur_time_conflct ;
294: END IF;
295: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
296: FND_MESSAGE.SET_TOKEN('NAME','IGS_PS_RLOVR_FAC_TSK.crsp_instrct_time_conflct');
297: IGS_GE_MSG_STACK.ADD;
298: App_exception.raise_exception ;
299:
300: END crsp_instrct_time_conflct;

Line 504: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');

500: WHEN OTHERS THEN
501: IF cur_inst_usec_occur%ISOPEN THEN
502: CLOSE cur_inst_usec_occur ;
503: END IF;
504: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
505: FND_MESSAGE.SET_TOKEN('NAME','IGS_PS_RLOVR_FAC_TSK.crsp_prc_inst_time_cft');
506: IGS_GE_MSG_STACK.ADD;
507: App_exception.raise_exception ;
508: END crsp_prc_inst_time_cft;

Line 505: FND_MESSAGE.SET_TOKEN('NAME','IGS_PS_RLOVR_FAC_TSK.crsp_prc_inst_time_cft');

501: IF cur_inst_usec_occur%ISOPEN THEN
502: CLOSE cur_inst_usec_occur ;
503: END IF;
504: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
505: FND_MESSAGE.SET_TOKEN('NAME','IGS_PS_RLOVR_FAC_TSK.crsp_prc_inst_time_cft');
506: IGS_GE_MSG_STACK.ADD;
507: App_exception.raise_exception ;
508: END crsp_prc_inst_time_cft;
509:

Line 528: FND_MESSAGE.SET_NAME('IGS','IGS_FI_CAL_BALANCES_LOG');

524: --Who When What
525: -------------------------------------------------------------------
526: BEGIN
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:

Line 529: FND_MESSAGE.SET_TOKEN('PARAMETER_NAME',p_msg_name);

525: -------------------------------------------------------------------
526: BEGIN
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 ;

Line 530: FND_MESSAGE.SET_TOKEN('PARAMETER_VAL' ,p_msg_val) ;

526: BEGIN
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:

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 677: Fnd_Message.Set_Name('IGS','IGS_FI_ANC_LOG_PARM');

673: l_dest_start_date := TRUNC(TO_DATE(SUBSTR(p_dest_cal_type,12,10),'DD/MM/YY')) ;
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;

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 702: FND_MESSAGE.SET_NAME('IGS','IGS_PS_SAME_CAL_CAT');

698: -- if the source and dest calendars are not of the same category then log message to file and return
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:

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 711: FND_MESSAGE.SET_NAME('IGS','IGS_PS_SOURCE_MORE_DEST');

707: --if source calendar starts later than the dest calendar then log message in file and return
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:

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 745: FND_MESSAGE.SET_NAME('IGS','IGS_PS_NO_ROLLOVER');

741: -- if no records found then return after loging message
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:

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 752: FND_MESSAGE.SET_NAME('IGS','IGS_PS_ROLLOVER_FAC_PROC');

748: END IF;
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

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 765: FND_MESSAGE.SET_NAME('IGS','IGS_PS_RLOVR_FACULTY');

761: --
762: l_fac_wl_id := NULL ;
763: OPEN c_per_id(l_tab_person_id(i).person_id);
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;

Line 766: FND_MESSAGE.SET_TOKEN('NUMBER',RPAD(l_per_id.person_number,30));

762: l_fac_wl_id := NULL ;
763: OPEN c_per_id(l_tab_person_id(i).person_id);
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:

Line 767: FND_MESSAGE.SET_TOKEN('NAME',l_per_id.person_name);

763: OPEN c_per_id(l_tab_person_id(i).person_id);
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) ;

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 837: FND_MESSAGE.SET_NAME('IGS','IGS_PS_FAC_RLOVR_TASK');

833: X_DEFAULT_WL => cur_source_tasks_rec.default_wl ,
834: X_MODE => 'R' );
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

Line 838: FND_MESSAGE.SET_TOKEN('TASK',cur_source_tasks_rec.faculty_task_type );

834: X_MODE => 'R' );
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 ;

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 868: FND_MESSAGE.SET_NAME('IGS','IGS_PS_FAC_RLOVR_SUC');

864: END LOOP ; -- loop all the faculty workloads to be rolled over
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

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

Line 876: ERRBUF := Fnd_Message.GET_STRING('IGS','IGS_GE_UNHANDLED_EXCEPTION');

872: EXCEPTION
873: WHEN OTHERS THEN
874: ROLLBACK TO a;
875: retcode:= 2;
876: ERRBUF := Fnd_Message.GET_STRING('IGS','IGS_GE_UNHANDLED_EXCEPTION');
877: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;
878: END rollover_fac_task;
879:
880: