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

Line 35: fnd_file.put_line(fnd_file.LOG,FND_MESSAGE.GET);

31: BEGIN
32: fnd_message.set_name('IGS','IGS_PS_DEL_PRIORITY_LOG');
33: fnd_message.set_token('PARAMETER_NAME', p_c_param_name );
34: fnd_message.set_token('PARAMETER_VAL' , p_c_param_value ) ;
35: fnd_file.put_line(fnd_file.LOG,FND_MESSAGE.GET);
36: END log_parameters ;
37:
38:
39: PROCEDURE crsp_get_coo_key(

Line 627: fnd_file.put_line ( fnd_file.LOG, ' ' );

623:
624: l_start_dt := TO_DATE ( RTRIM(SUBSTR(p_source_cal, 12, 10)), 'DD/MM/YYYY' ) ;
625: l_end_dt := TO_DATE ( RTRIM(SUBSTR(p_source_cal, 23, 10)), 'DD/MM/YYYY' );
626:
627: fnd_file.put_line ( fnd_file.LOG, ' ' );
628: log_parameters ( p_c_param_name => igs_ge_gen_004.GENP_GET_LOOKUP ( 'IGS_PS_LOG_PARAMETERS', 'SOURCE_CAL' ),
629: p_c_param_value => TO_CHAR ( l_start_dt, 'DD-MON-YYYY' ) || ' - ' ||
630: TO_CHAR ( l_end_dt, 'DD-MON-YYYY' ) || ' - ' ||
631: p_source_cal_type );

Line 642: fnd_file.put_line ( fnd_file.LOG, ' ' );

638: TO_CHAR ( l_end_dt, 'DD-MON-YYYY' ) || ' - ' ||
639: p_dest_cal_type );
640: log_parameters ( p_c_param_name => igs_ge_gen_004.GENP_GET_LOOKUP ( 'LEGACY_TOKENS', 'ORG_UNIT_CD' ),
641: p_c_param_value => p_org_unit_cd );
642: fnd_file.put_line ( fnd_file.LOG, ' ' );
643: fnd_file.put_line ( fnd_file.LOG, ' ' );
644:
645: v_message := NULL;
646:

Line 643: fnd_file.put_line ( fnd_file.LOG, ' ' );

639: p_dest_cal_type );
640: log_parameters ( p_c_param_name => igs_ge_gen_004.GENP_GET_LOOKUP ( 'LEGACY_TOKENS', 'ORG_UNIT_CD' ),
641: p_c_param_value => p_org_unit_cd );
642: fnd_file.put_line ( fnd_file.LOG, ' ' );
643: fnd_file.put_line ( fnd_file.LOG, ' ' );
644:
645: v_message := NULL;
646:
647: -- Can only transfer within the same IGS_CA_TYPE

Line 705: fnd_file.put_line ( fnd_file.LOG, ' ');

701: FETCH c_course_offering_instance INTO v_coi_rec;
702: EXIT WHEN c_course_offering_instance%NOTFOUND;
703:
704: -- This logging Unit information has been added as part of Bug# 2550392 by shtatiko
705: fnd_file.put_line ( fnd_file.LOG, ' ');
706: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'IGS_PS_LOG_PARAMETERS', 'PROGRAM_CD' )
707: || ' : ' || v_coi_rec.course_cd );
708: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'IGS_PS_LOG_PARAMETERS', 'VERSION_NUMBER' )
709: || ' : ' || TO_CHAR (v_coi_rec.version_number) );

Line 706: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'IGS_PS_LOG_PARAMETERS', 'PROGRAM_CD' )

702: EXIT WHEN c_course_offering_instance%NOTFOUND;
703:
704: -- This logging Unit information has been added as part of Bug# 2550392 by shtatiko
705: fnd_file.put_line ( fnd_file.LOG, ' ');
706: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'IGS_PS_LOG_PARAMETERS', 'PROGRAM_CD' )
707: || ' : ' || v_coi_rec.course_cd );
708: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'IGS_PS_LOG_PARAMETERS', 'VERSION_NUMBER' )
709: || ' : ' || TO_CHAR (v_coi_rec.version_number) );
710: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'CAL_TYPE' )

Line 708: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'IGS_PS_LOG_PARAMETERS', 'VERSION_NUMBER' )

704: -- This logging Unit information has been added as part of Bug# 2550392 by shtatiko
705: fnd_file.put_line ( fnd_file.LOG, ' ');
706: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'IGS_PS_LOG_PARAMETERS', 'PROGRAM_CD' )
707: || ' : ' || v_coi_rec.course_cd );
708: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'IGS_PS_LOG_PARAMETERS', 'VERSION_NUMBER' )
709: || ' : ' || TO_CHAR (v_coi_rec.version_number) );
710: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'CAL_TYPE' )
711: || ' : ' || p_dest_cal_type );
712: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'IGS_FI_LOCKBOX', 'START_DT' )

Line 710: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'CAL_TYPE' )

706: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'IGS_PS_LOG_PARAMETERS', 'PROGRAM_CD' )
707: || ' : ' || v_coi_rec.course_cd );
708: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'IGS_PS_LOG_PARAMETERS', 'VERSION_NUMBER' )
709: || ' : ' || TO_CHAR (v_coi_rec.version_number) );
710: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'CAL_TYPE' )
711: || ' : ' || p_dest_cal_type );
712: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'IGS_FI_LOCKBOX', 'START_DT' )
713: || ' : ' || fnd_date.date_to_displaydate (gv_ci_start_dt) );
714: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'IGS_FI_LOCKBOX', 'END_DT' )

Line 712: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'IGS_FI_LOCKBOX', 'START_DT' )

708: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'IGS_PS_LOG_PARAMETERS', 'VERSION_NUMBER' )
709: || ' : ' || TO_CHAR (v_coi_rec.version_number) );
710: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'CAL_TYPE' )
711: || ' : ' || p_dest_cal_type );
712: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'IGS_FI_LOCKBOX', 'START_DT' )
713: || ' : ' || fnd_date.date_to_displaydate (gv_ci_start_dt) );
714: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'IGS_FI_LOCKBOX', 'END_DT' )
715: || ' : ' || fnd_date.date_to_displaydate (gv_ci_end_dt) );
716: fnd_file.put_line ( fnd_file.LOG, ' ');

Line 714: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'IGS_FI_LOCKBOX', 'END_DT' )

710: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'CAL_TYPE' )
711: || ' : ' || p_dest_cal_type );
712: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'IGS_FI_LOCKBOX', 'START_DT' )
713: || ' : ' || fnd_date.date_to_displaydate (gv_ci_start_dt) );
714: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'IGS_FI_LOCKBOX', 'END_DT' )
715: || ' : ' || fnd_date.date_to_displaydate (gv_ci_end_dt) );
716: fnd_file.put_line ( fnd_file.LOG, ' ');
717:
718: -- Check that IGS_PS_COURSE version is still active and can be updated

Line 716: fnd_file.put_line ( fnd_file.LOG, ' ');

712: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'IGS_FI_LOCKBOX', 'START_DT' )
713: || ' : ' || fnd_date.date_to_displaydate (gv_ci_start_dt) );
714: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'IGS_FI_LOCKBOX', 'END_DT' )
715: || ' : ' || fnd_date.date_to_displaydate (gv_ci_end_dt) );
716: fnd_file.put_line ( fnd_file.LOG, ' ');
717:
718: -- Check that IGS_PS_COURSE version is still active and can be updated
719: IF (IGS_PS_VAL_CRS.crsp_val_iud_crv_dtl(
720: v_coi_rec.course_cd,

Line 742: fnd_file.put_line ( fnd_file.LOG, ' ' || fnd_message.get );

738: X_MODE => 'R');
739: v_rec_inserted_cnt := v_rec_inserted_cnt + 1;
740: -- This message has been added as part of Bug# 2550392 by shtatiko
741: fnd_message.set_name ( 'IGS', 'IGS_PS_ROLL_POI_SUCCESS' );
742: fnd_file.put_line ( fnd_file.LOG, ' ' || fnd_message.get );
743: ELSE
744: -- This message has been added as part of Bug# 2550392 by shtatiko
745: fnd_message.set_name ( 'IGS', 'IGS_PS_ROLL_POI_EXISTS' );
746: fnd_file.put_line ( fnd_file.LOG, ' ' || fnd_message.get );

Line 746: fnd_file.put_line ( fnd_file.LOG, ' ' || fnd_message.get );

742: fnd_file.put_line ( fnd_file.LOG, ' ' || fnd_message.get );
743: ELSE
744: -- This message has been added as part of Bug# 2550392 by shtatiko
745: fnd_message.set_name ( 'IGS', 'IGS_PS_ROLL_POI_EXISTS' );
746: fnd_file.put_line ( fnd_file.LOG, ' ' || fnd_message.get );
747: END IF;
748: CLOSE c_check_coi_exist;
749: -- Rollover all course_offering_patterns
750: -- within IGS_PS_OFR_INST.

Line 764: fnd_file.put_line ( fnd_file.LOG, ' ' || fnd_message.get );

760: RAISE invalid;
761: END IF;
762:
763: fnd_message.set_name ( 'IGS', v_message );
764: fnd_file.put_line ( fnd_file.LOG, ' ' || fnd_message.get );
765: -- no course_offering_patterns rolled over
766: IF (v_message = 'IGS_PS_PRGOFFR_ROLLED_EXIST' OR
767: v_message = 'IGS_PS_NO_POP_TOBE_ENROLLED') THEN
768: cst_all_cop_rec_inserted := FALSE;

Line 815: fnd_file.put_line ( fnd_file.LOG, ' ');

811: EXCEPTION
812: WHEN VALID THEN
813: COMMIT;
814: RETCODE:=0;
815: fnd_file.put_line ( fnd_file.LOG, ' ');
816: fnd_file.put_line ( fnd_file.LOG, fnd_message.get_string('IGS',v_message) );
817: WHEN INVALID THEN
818: RETCODE:=2;
819: fnd_file.put_line ( fnd_file.LOG, ' ');

Line 816: fnd_file.put_line ( fnd_file.LOG, fnd_message.get_string('IGS',v_message) );

812: WHEN VALID THEN
813: COMMIT;
814: RETCODE:=0;
815: fnd_file.put_line ( fnd_file.LOG, ' ');
816: fnd_file.put_line ( fnd_file.LOG, fnd_message.get_string('IGS',v_message) );
817: WHEN INVALID THEN
818: RETCODE:=2;
819: fnd_file.put_line ( fnd_file.LOG, ' ');
820: fnd_file.put_line ( fnd_file.LOG, fnd_message.get_string('IGS',v_message) );

Line 819: fnd_file.put_line ( fnd_file.LOG, ' ');

815: fnd_file.put_line ( fnd_file.LOG, ' ');
816: fnd_file.put_line ( fnd_file.LOG, fnd_message.get_string('IGS',v_message) );
817: WHEN INVALID THEN
818: RETCODE:=2;
819: fnd_file.put_line ( fnd_file.LOG, ' ');
820: fnd_file.put_line ( fnd_file.LOG, fnd_message.get_string('IGS',v_message) );
821: WHEN OTHERS THEN
822: RETCODE:=2;
823: ERRBUF:=FND_MESSAGE.GET_STRING('IGS','IGS_GE_UNHANDLED_EXCEPTION') || ' : ' || SQLERRM;

Line 820: fnd_file.put_line ( fnd_file.LOG, fnd_message.get_string('IGS',v_message) );

816: fnd_file.put_line ( fnd_file.LOG, fnd_message.get_string('IGS',v_message) );
817: WHEN INVALID THEN
818: RETCODE:=2;
819: fnd_file.put_line ( fnd_file.LOG, ' ');
820: fnd_file.put_line ( fnd_file.LOG, fnd_message.get_string('IGS',v_message) );
821: WHEN OTHERS THEN
822: RETCODE:=2;
823: ERRBUF:=FND_MESSAGE.GET_STRING('IGS','IGS_GE_UNHANDLED_EXCEPTION') || ' : ' || SQLERRM;
824: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;