157: BEGIN
158:
159: IGS_GE_GEN_003.SET_ORG_ID(); -- swaghmar, bug# 4951054
160: --
161: -- FND_LOGGING
162: --
163: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
164: fnd_log.string ( fnd_log.level_procedure,
165: 'igs.plsql.igs_as_adi_upld_ug_pkg.grading_period_grade_process.begin',
159: IGS_GE_GEN_003.SET_ORG_ID(); -- swaghmar, bug# 4951054
160: --
161: -- FND_LOGGING
162: --
163: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
164: fnd_log.string ( fnd_log.level_procedure,
165: 'igs.plsql.igs_as_adi_upld_ug_pkg.grading_period_grade_process.begin',
166: 'Params: p_user_id => '||p_user_id|| ';' ||
167: ' p_batch_datetime => '||p_batch_datetime|| ';' ||
160: --
161: -- FND_LOGGING
162: --
163: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
164: fnd_log.string ( fnd_log.level_procedure,
165: 'igs.plsql.igs_as_adi_upld_ug_pkg.grading_period_grade_process.begin',
166: 'Params: p_user_id => '||p_user_id|| ';' ||
167: ' p_batch_datetime => '||p_batch_datetime|| ';' ||
168: ' p_grade_creation_method_type => '||p_grade_creation_method_type|| ';' ||
190: SET error_code = 'IGS_EN_PERSON_NO_RESP'
191: WHERE ROWID = v_ugi_rec.ROWID;
192: else
193: --
194: -- FND_LOGGING
195: --
196: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
197: fnd_log.string (fnd_log.level_statement,
198: 'igs.plsql.igs_as_adi_upld_ug_pkg.grading_period_grade_process.c_upload_outcome_ugi',
192: else
193: --
194: -- FND_LOGGING
195: --
196: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
197: fnd_log.string (fnd_log.level_statement,
198: 'igs.plsql.igs_as_adi_upld_ug_pkg.grading_period_grade_process.c_upload_outcome_ugi',
199: 'v_ugi_rec.person_number => '||v_ugi_rec.person_number||';'||
200: 'v_ugi_rec.anonymous_id => '||v_ugi_rec.anonymous_id||';'||
193: --
194: -- FND_LOGGING
195: --
196: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
197: fnd_log.string (fnd_log.level_statement,
198: 'igs.plsql.igs_as_adi_upld_ug_pkg.grading_period_grade_process.c_upload_outcome_ugi',
199: 'v_ugi_rec.person_number => '||v_ugi_rec.person_number||';'||
200: 'v_ugi_rec.anonymous_id => '||v_ugi_rec.anonymous_id||';'||
201: 'v_cal_type => '||v_cal_type||';'||
259: v_ugi_rec.mark_capped_flag := 'Y';
260: END IF;
261:
262: --
263: -- FND_LOGGING
264: --
265: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
266: fnd_log.string (fnd_log.level_statement,
267: 'igs.plsql.igs_as_adi_upld_ug_pkg.grading_period_grade_process.c_upload_outcome_ugi_upd',
261:
262: --
263: -- FND_LOGGING
264: --
265: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
266: fnd_log.string (fnd_log.level_statement,
267: 'igs.plsql.igs_as_adi_upld_ug_pkg.grading_period_grade_process.c_upload_outcome_ugi_upd',
268: 'v_ugi_rec.person_number => '||v_ugi_rec.person_number||';'||
269: 'v_ugi_rec.anonymous_id => '||v_ugi_rec.anonymous_id||';'||
262: --
263: -- FND_LOGGING
264: --
265: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
266: fnd_log.string (fnd_log.level_statement,
267: 'igs.plsql.igs_as_adi_upld_ug_pkg.grading_period_grade_process.c_upload_outcome_ugi_upd',
268: 'v_ugi_rec.person_number => '||v_ugi_rec.person_number||';'||
269: 'v_ugi_rec.anonymous_id => '||v_ugi_rec.anonymous_id||';'||
270: 'v_cal_type => '||v_cal_type||';'||
513: RAISE fnd_api.g_exc_unexpected_error;
514: END IF;
515: END IF;
516: --
517: -- FND_LOGGING
518: --
519: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
520: fnd_log.string ( fnd_log.level_procedure,
521: 'igs.plsql.igs_as_adi_upld_ug_pkg.grading_period_grade_process.end',
515: END IF;
516: --
517: -- FND_LOGGING
518: --
519: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
520: fnd_log.string ( fnd_log.level_procedure,
521: 'igs.plsql.igs_as_adi_upld_ug_pkg.grading_period_grade_process.end',
522: 'Exiting IGS_AS_ADI_UPLD_UG_PKG.grading_period_grade_process'
523: );
516: --
517: -- FND_LOGGING
518: --
519: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
520: fnd_log.string ( fnd_log.level_procedure,
521: 'igs.plsql.igs_as_adi_upld_ug_pkg.grading_period_grade_process.end',
522: 'Exiting IGS_AS_ADI_UPLD_UG_PKG.grading_period_grade_process'
523: );
524: END IF;