DBA Data[Home] [Help]

APPS.IGS_PS_GEN_003 dependencies on IGS_GE_GEN_004

Line 628: log_parameters ( p_c_param_name => igs_ge_gen_004.GENP_GET_LOOKUP ( 'IGS_PS_LOG_PARAMETERS', 'SOURCE_CAL' ),

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 );
632:

Line 636: log_parameters ( p_c_param_name => igs_ge_gen_004.GENP_GET_LOOKUP ( 'IGS_PS_LOG_PARAMETERS', 'DEST_CAL' ),

632:
633: l_start_dt := TO_DATE ( RTRIM(SUBSTR(p_dest_cal, 12, 10)), 'DD/MM/YYYY' ) ;
634: l_end_dt := TO_DATE ( RTRIM(SUBSTR(p_dest_cal, 23, 10)), 'DD/MM/YYYY' );
635:
636: log_parameters ( p_c_param_name => igs_ge_gen_004.GENP_GET_LOOKUP ( 'IGS_PS_LOG_PARAMETERS', 'DEST_CAL' ),
637: p_c_param_value => TO_CHAR ( l_start_dt, 'DD-MON-YYYY' ) || ' - ' ||
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' ),

Line 640: log_parameters ( p_c_param_name => igs_ge_gen_004.GENP_GET_LOOKUP ( 'LEGACY_TOKENS', 'ORG_UNIT_CD' ),

636: log_parameters ( p_c_param_name => igs_ge_gen_004.GENP_GET_LOOKUP ( 'IGS_PS_LOG_PARAMETERS', 'DEST_CAL' ),
637: p_c_param_value => TO_CHAR ( l_start_dt, 'DD-MON-YYYY' ) || ' - ' ||
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:

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