DBA Data[Home] [Help]

APPS.IGS_AS_ADI_UPLD_PR_PKG dependencies on IGS_AS_UG_INTERFACE

Line 92: 'There were errors in the progression upload, error are being transferred to the IGS_AS_UG_INTERFACE table'

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

Line 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

Line 236: 'There were errors in the progression upload, error are being transferred to the IGS_AS_UG_INTERFACE table'

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

Line 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

Line 265: 'There were errors in the assessment item upload, error are being transferred to the IGS_AS_UG_INTERFACE table'

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

Line 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