171:
172: --
173: IGS_GE_GEN_003.SET_ORG_ID(); -- swaghmar, bug# 4951054
174: --
175: -- FND_LOGGING
176: --
177: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
178: fnd_log.string ( fnd_log.level_procedure,
179: 'igs.plsql.igs_as_adi_upld_aio_pkg.assessment_item_grade_process.begin',
173: IGS_GE_GEN_003.SET_ORG_ID(); -- swaghmar, bug# 4951054
174: --
175: -- FND_LOGGING
176: --
177: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
178: fnd_log.string ( fnd_log.level_procedure,
179: 'igs.plsql.igs_as_adi_upld_aio_pkg.assessment_item_grade_process.begin',
180: 'Params: p_user_id => '||p_user_id|| ';' ||
181: ' p_batch_datetime => '||p_batch_datetime|| ';' ||
174: --
175: -- FND_LOGGING
176: --
177: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
178: fnd_log.string ( fnd_log.level_procedure,
179: 'igs.plsql.igs_as_adi_upld_aio_pkg.assessment_item_grade_process.begin',
180: 'Params: p_user_id => '||p_user_id|| ';' ||
181: ' p_batch_datetime => '||p_batch_datetime|| ';' ||
182: ' p_grade_creation_method_type => '||p_grade_creation_method_type|| ';' ||
207: WHERE ROWID = v_aio_upld.ROWID;
208: ELSE
209:
210: --
211: -- FND_LOGGING
212: --
213: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
214: fnd_log.string (fnd_log.level_statement,
215: 'igs.plsql.IGS_AS_ADI_UPLD_AIO_PKG.assessment_item_grade_process.c_upload_outcome_ai',
209:
210: --
211: -- FND_LOGGING
212: --
213: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
214: fnd_log.string (fnd_log.level_statement,
215: 'igs.plsql.IGS_AS_ADI_UPLD_AIO_PKG.assessment_item_grade_process.c_upload_outcome_ai',
216: 'v_ugi_rec.person_number => '||v_aio_upld.person_number||';'||
217: 'v_ugi_rec.anonymous_id => '||v_aio_upld.anonymous_id||';'||
210: --
211: -- FND_LOGGING
212: --
213: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
214: fnd_log.string (fnd_log.level_statement,
215: 'igs.plsql.IGS_AS_ADI_UPLD_AIO_PKG.assessment_item_grade_process.c_upload_outcome_ai',
216: 'v_ugi_rec.person_number => '||v_aio_upld.person_number||';'||
217: 'v_ugi_rec.anonymous_id => '||v_aio_upld.anonymous_id||';'||
218: 'v_cal_type => '||v_cal_type||';'||
294: v_aio_upld.penalty_applied_flag := (v_aio_upld.penalty_applied_flag) ;
295: END IF;
296:
297: --
298: -- FND_LOGGING
299: --
300: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
301: fnd_log.string (fnd_log.level_statement,
302: 'igs.plsql.IGS_AS_ADI_UPLD_AIO_PKG.assessment_item_grade_process.c_upload_outcome_ai',
296:
297: --
298: -- FND_LOGGING
299: --
300: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
301: fnd_log.string (fnd_log.level_statement,
302: 'igs.plsql.IGS_AS_ADI_UPLD_AIO_PKG.assessment_item_grade_process.c_upload_outcome_ai',
303: 'v_ugi_rec.person_number => '||v_aio_upld.person_number||';'||
304: 'v_ugi_rec.anonymous_id => '||v_aio_upld.anonymous_id||';'||
297: --
298: -- FND_LOGGING
299: --
300: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
301: fnd_log.string (fnd_log.level_statement,
302: 'igs.plsql.IGS_AS_ADI_UPLD_AIO_PKG.assessment_item_grade_process.c_upload_outcome_ai',
303: 'v_ugi_rec.person_number => '||v_aio_upld.person_number||';'||
304: 'v_ugi_rec.anonymous_id => '||v_aio_upld.anonymous_id||';'||
305: 'v_cal_type => '||v_cal_type||';'||
462: RAISE fnd_api.g_exc_unexpected_error;
463: END IF;
464:
465: --
466: -- FND_LOGGING
467: --
468: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
469: fnd_log.string ( fnd_log.level_procedure,
470: 'igs.plsql.IGS_AS_ADI_UPLD_AIO_PKG.assessment_item_grade_process.end',
464:
465: --
466: -- FND_LOGGING
467: --
468: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
469: fnd_log.string ( fnd_log.level_procedure,
470: 'igs.plsql.IGS_AS_ADI_UPLD_AIO_PKG.assessment_item_grade_process.end',
471: 'Exiting IGS_AS_ADI_UPLD_AIO_PKG.assessment_item_grade_process'
472: );
465: --
466: -- FND_LOGGING
467: --
468: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
469: fnd_log.string ( fnd_log.level_procedure,
470: 'igs.plsql.IGS_AS_ADI_UPLD_AIO_PKG.assessment_item_grade_process.end',
471: 'Exiting IGS_AS_ADI_UPLD_AIO_PKG.assessment_item_grade_process'
472: );
473: END IF;