88: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
89: fnd_log.string (
90: fnd_log.level_statement,
91: 'igs.plsql.igs_as_adi_upld_pr_pkg.prog_ug_process',
92: 'There were errors in the progression upload, error are being transferred to the IGS_AS_UG_INTERFACE table'
93: );
94: END IF;
95: --
96: UPDATE igs_as_ug_interface
92: 'There were errors in the progression upload, error are being transferred to the IGS_AS_UG_INTERFACE table'
93: );
94: END IF;
95: --
96: UPDATE igs_as_ug_interface
97: SET error_code = pr_error_rows.error_code
98: WHERE user_id = p_user_id
99: AND trunc(batch_date) = trunc(p_batch_date)
100: AND (alternate_code = pr_error_rows.progression_outcome_type
232: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
233: fnd_log.string (
234: fnd_log.level_statement,
235: 'igs.plsql.igs_as_adi_upld_pr_pkg.prog_ug_aio_process',
236: 'There were errors in the progression upload, error are being transferred to the IGS_AS_UG_INTERFACE table'
237: );
238: END IF;
239: --
240: UPDATE igs_as_ug_interface
236: 'There were errors in the progression upload, error are being transferred to the IGS_AS_UG_INTERFACE table'
237: );
238: END IF;
239: --
240: UPDATE igs_as_ug_interface
241: SET error_code = pr_error_rows.error_code
242: WHERE user_id = p_user_id
243: AND trunc(batch_date) = trunc(p_batch_date)
244: AND (alternate_code = pr_error_rows.progression_outcome_type
261: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
262: fnd_log.string (
263: fnd_log.level_statement,
264: 'igs.plsql.igs_as_adi_upld_pr_pkg.prog_ug_aio_process',
265: 'There were errors in the assessment item upload, error are being transferred to the IGS_AS_UG_INTERFACE table'
266: );
267: END IF;
268: --
269: UPDATE igs_as_ug_interface
265: 'There were errors in the assessment item upload, error are being transferred to the IGS_AS_UG_INTERFACE table'
266: );
267: END IF;
268: --
269: UPDATE igs_as_ug_interface
270: SET error_code = aio_error_rows.error_code
271: WHERE user_id = p_user_id
272: AND trunc(batch_date) = trunc(p_batch_date)
273: AND (person_number = aio_error_rows.person_number