DBA Data[Home] [Help]

APPS.IGS_EN_VAL_BULKRULE dependencies on FND_FILE

Line 111: FND_FILE.PUT_LINE(FND_FILE.LOG,'================================================================================');

107: p_acad_cal_type||','||TO_CHAR(p_acad_sequence_number)||','||p_course_cd,
108: v_creation_dt);
109:
110: -- Logging parameters in the Log File.
111: FND_FILE.PUT_LINE(FND_FILE.LOG,'================================================================================');
112: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
113: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING('IGS','IGS_EN_ACAD_CAL') || ': ' || RTRIM(SUBSTR(p_acad_calander,1,74)));
114: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING('IGS','IGS_AD_CRS_CD') || ': ' || p_crs_cd);
115: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING('IGS','IGS_EN_TERM_TEACH_CAL') || ': ' || RTRIM(SUBSTR(p_load_teach_calendar,1,100)));

Line 112: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');

108: v_creation_dt);
109:
110: -- Logging parameters in the Log File.
111: FND_FILE.PUT_LINE(FND_FILE.LOG,'================================================================================');
112: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
113: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING('IGS','IGS_EN_ACAD_CAL') || ': ' || RTRIM(SUBSTR(p_acad_calander,1,74)));
114: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING('IGS','IGS_AD_CRS_CD') || ': ' || p_crs_cd);
115: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING('IGS','IGS_EN_TERM_TEACH_CAL') || ': ' || RTRIM(SUBSTR(p_load_teach_calendar,1,100)));
116: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING('IGS','IGS_PR_ORG_UNIT') || ': ' || p_org_unit_cd);

Line 113: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING('IGS','IGS_EN_ACAD_CAL') || ': ' || RTRIM(SUBSTR(p_acad_calander,1,74)));

109:
110: -- Logging parameters in the Log File.
111: FND_FILE.PUT_LINE(FND_FILE.LOG,'================================================================================');
112: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
113: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING('IGS','IGS_EN_ACAD_CAL') || ': ' || RTRIM(SUBSTR(p_acad_calander,1,74)));
114: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING('IGS','IGS_AD_CRS_CD') || ': ' || p_crs_cd);
115: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING('IGS','IGS_EN_TERM_TEACH_CAL') || ': ' || RTRIM(SUBSTR(p_load_teach_calendar,1,100)));
116: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING('IGS','IGS_PR_ORG_UNIT') || ': ' || p_org_unit_cd);
117: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING('IGS','IGS_EN_RULE_TO_VAL') || ': ' || p_rule_to_be_validated);

Line 114: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING('IGS','IGS_AD_CRS_CD') || ': ' || p_crs_cd);

110: -- Logging parameters in the Log File.
111: FND_FILE.PUT_LINE(FND_FILE.LOG,'================================================================================');
112: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
113: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING('IGS','IGS_EN_ACAD_CAL') || ': ' || RTRIM(SUBSTR(p_acad_calander,1,74)));
114: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING('IGS','IGS_AD_CRS_CD') || ': ' || p_crs_cd);
115: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING('IGS','IGS_EN_TERM_TEACH_CAL') || ': ' || RTRIM(SUBSTR(p_load_teach_calendar,1,100)));
116: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING('IGS','IGS_PR_ORG_UNIT') || ': ' || p_org_unit_cd);
117: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING('IGS','IGS_EN_RULE_TO_VAL') || ': ' || p_rule_to_be_validated);
118: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');

Line 115: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING('IGS','IGS_EN_TERM_TEACH_CAL') || ': ' || RTRIM(SUBSTR(p_load_teach_calendar,1,100)));

111: FND_FILE.PUT_LINE(FND_FILE.LOG,'================================================================================');
112: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
113: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING('IGS','IGS_EN_ACAD_CAL') || ': ' || RTRIM(SUBSTR(p_acad_calander,1,74)));
114: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING('IGS','IGS_AD_CRS_CD') || ': ' || p_crs_cd);
115: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING('IGS','IGS_EN_TERM_TEACH_CAL') || ': ' || RTRIM(SUBSTR(p_load_teach_calendar,1,100)));
116: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING('IGS','IGS_PR_ORG_UNIT') || ': ' || p_org_unit_cd);
117: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING('IGS','IGS_EN_RULE_TO_VAL') || ': ' || p_rule_to_be_validated);
118: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
119: FND_FILE.PUT_LINE(FND_FILE.LOG,'================================================================================');

Line 116: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING('IGS','IGS_PR_ORG_UNIT') || ': ' || p_org_unit_cd);

112: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
113: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING('IGS','IGS_EN_ACAD_CAL') || ': ' || RTRIM(SUBSTR(p_acad_calander,1,74)));
114: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING('IGS','IGS_AD_CRS_CD') || ': ' || p_crs_cd);
115: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING('IGS','IGS_EN_TERM_TEACH_CAL') || ': ' || RTRIM(SUBSTR(p_load_teach_calendar,1,100)));
116: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING('IGS','IGS_PR_ORG_UNIT') || ': ' || p_org_unit_cd);
117: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING('IGS','IGS_EN_RULE_TO_VAL') || ': ' || p_rule_to_be_validated);
118: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
119: FND_FILE.PUT_LINE(FND_FILE.LOG,'================================================================================');
120:

Line 117: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING('IGS','IGS_EN_RULE_TO_VAL') || ': ' || p_rule_to_be_validated);

113: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING('IGS','IGS_EN_ACAD_CAL') || ': ' || RTRIM(SUBSTR(p_acad_calander,1,74)));
114: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING('IGS','IGS_AD_CRS_CD') || ': ' || p_crs_cd);
115: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING('IGS','IGS_EN_TERM_TEACH_CAL') || ': ' || RTRIM(SUBSTR(p_load_teach_calendar,1,100)));
116: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING('IGS','IGS_PR_ORG_UNIT') || ': ' || p_org_unit_cd);
117: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING('IGS','IGS_EN_RULE_TO_VAL') || ': ' || p_rule_to_be_validated);
118: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
119: FND_FILE.PUT_LINE(FND_FILE.LOG,'================================================================================');
120:
121: v_last_person_id := 0;

Line 118: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');

114: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING('IGS','IGS_AD_CRS_CD') || ': ' || p_crs_cd);
115: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING('IGS','IGS_EN_TERM_TEACH_CAL') || ': ' || RTRIM(SUBSTR(p_load_teach_calendar,1,100)));
116: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING('IGS','IGS_PR_ORG_UNIT') || ': ' || p_org_unit_cd);
117: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING('IGS','IGS_EN_RULE_TO_VAL') || ': ' || p_rule_to_be_validated);
118: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
119: FND_FILE.PUT_LINE(FND_FILE.LOG,'================================================================================');
120:
121: v_last_person_id := 0;
122: BEGIN

Line 119: FND_FILE.PUT_LINE(FND_FILE.LOG,'================================================================================');

115: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING('IGS','IGS_EN_TERM_TEACH_CAL') || ': ' || RTRIM(SUBSTR(p_load_teach_calendar,1,100)));
116: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING('IGS','IGS_PR_ORG_UNIT') || ': ' || p_org_unit_cd);
117: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING('IGS','IGS_EN_RULE_TO_VAL') || ': ' || p_rule_to_be_validated);
118: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
119: FND_FILE.PUT_LINE(FND_FILE.LOG,'================================================================================');
120:
121: v_last_person_id := 0;
122: BEGIN
123: FOR v_st_rec IN c_st

Line 170: Fnd_File.PUT_LINE(Fnd_File.LOG,SQLERRM);

166:
167: EXCEPTION
168: WHEN OTHERS THEN
169: retcode:=2;
170: Fnd_File.PUT_LINE(Fnd_File.LOG,SQLERRM);
171: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
172: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,'igs.plsql.igs_en_val_bulkrule.enrp_val_sca_rultodo.UNH_EXP','Unhandled Exception raised with code '||SQLCODE||' and error '||SQLERRM);
173: END IF;
174: ERRBUF := FND_MESSAGE.GET_STRING('IGS','IGS_GE_UNHANDLED_EXCEPTION');