eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_AS_ADI_UPLD_PR_PKG dependencies on FND_LOG

Line 32: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

28: AND NVL (progression_outcome_type, '--') <> '-';
29: --
30: BEGIN
31: --
32: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
33: fnd_log.string (
34: fnd_log.level_procedure,
35: 'igs.plsql.igs_as_adi_upld_pr_pkg.prog_ug_process',
36: 'Entered the prog_ug_process procedure with values:' ||

Line 33: fnd_log.string (

29: --
30: BEGIN
31: --
32: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
33: fnd_log.string (
34: fnd_log.level_procedure,
35: 'igs.plsql.igs_as_adi_upld_pr_pkg.prog_ug_process',
36: 'Entered the prog_ug_process procedure with values:' ||
37: 'p_user_id => ' || p_user_id || ';' ||

Line 34: fnd_log.level_procedure,

30: BEGIN
31: --
32: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
33: fnd_log.string (
34: fnd_log.level_procedure,
35: 'igs.plsql.igs_as_adi_upld_pr_pkg.prog_ug_process',
36: 'Entered the prog_ug_process procedure with values:' ||
37: 'p_user_id => ' || p_user_id || ';' ||
38: 'p_batch_datetime => ' || p_batch_datetime || ';' ||

Line 55: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

51: p_grade_creation_method_type,
52: p_delete_rows
53: );
54: --
55: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
56: fnd_log.string (
57: fnd_log.level_statement,
58: 'igs.plsql.igs_as_adi_upld_pr_pkg.prog_ug_process',
59: 'Completed progression_outcome_process'

Line 56: fnd_log.string (

52: p_delete_rows
53: );
54: --
55: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
56: fnd_log.string (
57: fnd_log.level_statement,
58: 'igs.plsql.igs_as_adi_upld_pr_pkg.prog_ug_process',
59: 'Completed progression_outcome_process'
60: );

Line 57: fnd_log.level_statement,

53: );
54: --
55: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
56: fnd_log.string (
57: fnd_log.level_statement,
58: 'igs.plsql.igs_as_adi_upld_pr_pkg.prog_ug_process',
59: 'Completed progression_outcome_process'
60: );
61: END IF;

Line 74: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

70: p_grade_creation_method_type,
71: p_delete_rows
72: );
73: --
74: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
75: fnd_log.string (
76: fnd_log.level_statement,
77: 'igs.plsql.igs_as_adi_upld_pr_pkg.prog_ug_process',
78: 'Completed igs_as_adi_upld_ug_pkg.grading_period_grade_process'

Line 75: fnd_log.string (

71: p_delete_rows
72: );
73: --
74: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
75: fnd_log.string (
76: fnd_log.level_statement,
77: 'igs.plsql.igs_as_adi_upld_pr_pkg.prog_ug_process',
78: 'Completed igs_as_adi_upld_ug_pkg.grading_period_grade_process'
79: );

Line 76: fnd_log.level_statement,

72: );
73: --
74: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
75: fnd_log.string (
76: fnd_log.level_statement,
77: 'igs.plsql.igs_as_adi_upld_pr_pkg.prog_ug_process',
78: 'Completed igs_as_adi_upld_ug_pkg.grading_period_grade_process'
79: );
80: END IF;

Line 88: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

84: -- errors back in the Web ADI spread sheet
85: --
86: FOR pr_error_rows IN error_pr LOOP
87: --
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'

Line 89: fnd_log.string (

85: --
86: FOR pr_error_rows IN error_pr LOOP
87: --
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: );

Line 90: fnd_log.level_statement,

86: FOR pr_error_rows IN error_pr LOOP
87: --
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;

Line 110: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

106: AND course_cd = pr_error_rows.course_cd;
107: --
108: END LOOP;
109: --
110: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
111: fnd_log.string (
112: fnd_log.level_procedure,
113: 'igs.plsql.igs_as_adi_upld_pr_pkg.prog_ug_process',
114: 'Exiting the prog_ug_process procedure'

Line 111: fnd_log.string (

107: --
108: END LOOP;
109: --
110: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
111: fnd_log.string (
112: fnd_log.level_procedure,
113: 'igs.plsql.igs_as_adi_upld_pr_pkg.prog_ug_process',
114: 'Exiting the prog_ug_process procedure'
115: );

Line 112: fnd_log.level_procedure,

108: END LOOP;
109: --
110: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
111: fnd_log.string (
112: fnd_log.level_procedure,
113: 'igs.plsql.igs_as_adi_upld_pr_pkg.prog_ug_process',
114: 'Exiting the prog_ug_process procedure'
115: );
116: END IF;

Line 157: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

153: AND ass_id IS NOT NULL;
154: --
155: BEGIN
156: --
157: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
158: fnd_log.string (
159: fnd_log.level_procedure,
160: 'igs.plsql.igs_as_adi_upld_pr_pkg.prog_ug_aio_process',
161: 'Entered the prog_ug_aio_process procedure with values:' ||

Line 158: fnd_log.string (

154: --
155: BEGIN
156: --
157: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
158: fnd_log.string (
159: fnd_log.level_procedure,
160: 'igs.plsql.igs_as_adi_upld_pr_pkg.prog_ug_aio_process',
161: 'Entered the prog_ug_aio_process procedure with values:' ||
162: 'p_user_id => ' || p_user_id || ';' ||

Line 159: fnd_log.level_procedure,

155: BEGIN
156: --
157: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
158: fnd_log.string (
159: fnd_log.level_procedure,
160: 'igs.plsql.igs_as_adi_upld_pr_pkg.prog_ug_aio_process',
161: 'Entered the prog_ug_aio_process procedure with values:' ||
162: 'p_user_id => ' || p_user_id || ';' ||
163: 'p_batch_datetime => ' || p_batch_datetime || ';' ||

Line 180: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

176: p_grade_creation_method_type,
177: p_delete_rows
178: );
179: --
180: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
181: fnd_log.string (
182: fnd_log.level_statement,
183: 'igs.plsql.igs_as_adi_upld_pr_pkg.prog_ug_aio_process',
184: 'Completed progression_outcome_process'

Line 181: fnd_log.string (

177: p_delete_rows
178: );
179: --
180: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
181: fnd_log.string (
182: fnd_log.level_statement,
183: 'igs.plsql.igs_as_adi_upld_pr_pkg.prog_ug_aio_process',
184: 'Completed progression_outcome_process'
185: );

Line 182: fnd_log.level_statement,

178: );
179: --
180: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
181: fnd_log.string (
182: fnd_log.level_statement,
183: 'igs.plsql.igs_as_adi_upld_pr_pkg.prog_ug_aio_process',
184: 'Completed progression_outcome_process'
185: );
186: END IF;

Line 199: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

195: p_grade_creation_method_type,
196: p_delete_rows
197: );
198: --
199: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
200: fnd_log.string (
201: fnd_log.level_statement,
202: 'igs.plsql.igs_as_adi_upld_pr_pkg.prog_ug_aio_process',
203: 'Completed igs_as_adi_upld_aio_pkg.assessment_item_grade_process'

Line 200: fnd_log.string (

196: p_delete_rows
197: );
198: --
199: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
200: fnd_log.string (
201: fnd_log.level_statement,
202: 'igs.plsql.igs_as_adi_upld_pr_pkg.prog_ug_aio_process',
203: 'Completed igs_as_adi_upld_aio_pkg.assessment_item_grade_process'
204: );

Line 201: fnd_log.level_statement,

197: );
198: --
199: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
200: fnd_log.string (
201: fnd_log.level_statement,
202: 'igs.plsql.igs_as_adi_upld_pr_pkg.prog_ug_aio_process',
203: 'Completed igs_as_adi_upld_aio_pkg.assessment_item_grade_process'
204: );
205: END IF;

Line 218: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

214: p_grade_creation_method_type,
215: p_delete_rows
216: );
217: --
218: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
219: fnd_log.string (
220: fnd_log.level_statement,
221: 'igs.plsql.igs_as_adi_upld_pr_pkg.prog_ug_aio_process',
222: 'Completed igs_as_adi_upld_ug_pkg.grading_period_grade_process'

Line 219: fnd_log.string (

215: p_delete_rows
216: );
217: --
218: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
219: fnd_log.string (
220: fnd_log.level_statement,
221: 'igs.plsql.igs_as_adi_upld_pr_pkg.prog_ug_aio_process',
222: 'Completed igs_as_adi_upld_ug_pkg.grading_period_grade_process'
223: );

Line 220: fnd_log.level_statement,

216: );
217: --
218: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
219: fnd_log.string (
220: fnd_log.level_statement,
221: 'igs.plsql.igs_as_adi_upld_pr_pkg.prog_ug_aio_process',
222: 'Completed igs_as_adi_upld_ug_pkg.grading_period_grade_process'
223: );
224: END IF;

Line 232: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

228: -- errors back in the Web ADI spread sheet
229: --
230: FOR pr_error_rows IN error_pr LOOP
231: --
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'

Line 233: fnd_log.string (

229: --
230: FOR pr_error_rows IN error_pr LOOP
231: --
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: );

Line 234: fnd_log.level_statement,

230: FOR pr_error_rows IN error_pr LOOP
231: --
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;

Line 261: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

257: -- errors back in the Web ADI spread sheet
258: --
259: FOR aio_error_rows IN error_aio LOOP
260: --
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'

Line 262: fnd_log.string (

258: --
259: FOR aio_error_rows IN error_aio LOOP
260: --
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: );

Line 263: fnd_log.level_statement,

259: FOR aio_error_rows IN error_aio LOOP
260: --
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;

Line 286: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

282: AND grading_period_cd = '-';
283: --
284: END LOOP;
285: --
286: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
287: fnd_log.string (
288: fnd_log.level_procedure,
289: 'igs.plsql.igs_as_adi_upld_pr_pkg.prog_ug_aio_process',
290: 'Exiting the prog_ug_aio_process procedure'

Line 287: fnd_log.string (

283: --
284: END LOOP;
285: --
286: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
287: fnd_log.string (
288: fnd_log.level_procedure,
289: 'igs.plsql.igs_as_adi_upld_pr_pkg.prog_ug_aio_process',
290: 'Exiting the prog_ug_aio_process procedure'
291: );

Line 288: fnd_log.level_procedure,

284: END LOOP;
285: --
286: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
287: fnd_log.string (
288: fnd_log.level_procedure,
289: 'igs.plsql.igs_as_adi_upld_pr_pkg.prog_ug_aio_process',
290: 'Exiting the prog_ug_aio_process procedure'
291: );
292: END IF;