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_PR_GET_CLASS_STD dependencies on FND_LOG

Line 16: --swaghmar 25-Apr-2006 Bug# 5171158 Enabled FND Logging and added call to user hook procedure

12: --ptandon 20-Nov-03 Modified cursor c_spa in Function Get_Class_Standing to consider
13: -- class standing in term records table as per Term Based Fee Calc build.
14: -- Enh. Bug# 2829263.
15: --swaghmar 15-Sep-2005 Bug# 4491456 Changed datatypes for l_gpa_value, l_gpa_cp, l_gpa_quality_points
16: --swaghmar 25-Apr-2006 Bug# 5171158 Enabled FND Logging and added call to user hook procedure
17: -- for the customers to customize the derivation of class standing
18: ----------------------------------------------------------------------------------------------------------------
19: FUNCTION Get_Class_Standing(
20: p_PERSON_ID IN NUMBER,

Line 200: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN

196:
197: /**
198: * Logging all params
199: */
200: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
201: fnd_log.string ( fnd_log.level_procedure,
202: 'igs.plsql.igs_pr_get_class_std.get_class_standing' || '.begin',
203: 'Params: p_person_id => '||p_person_id|| ';' ||
204: ' p_course_cd => '||p_course_cd|| ';' ||

Line 201: fnd_log.string ( fnd_log.level_procedure,

197: /**
198: * Logging all params
199: */
200: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
201: fnd_log.string ( fnd_log.level_procedure,
202: 'igs.plsql.igs_pr_get_class_std.get_class_standing' || '.begin',
203: 'Params: p_person_id => '||p_person_id|| ';' ||
204: ' p_course_cd => '||p_course_cd|| ';' ||
205: ' p_predictive_ind => '||p_predictive_ind|| ';' ||

Line 217: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

213: /**
214: * Logging for validating whether or not class standing calculation is
215: * customized
216: */
217: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
218: fnd_log.string (fnd_log.level_statement,
219: 'igs.plsql.igs_pr_get_class_std.get_class_standing',
220: 'Customization Flag => '||l_flag
221: );

Line 218: fnd_log.string (fnd_log.level_statement,

214: * Logging for validating whether or not class standing calculation is
215: * customized
216: */
217: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
218: fnd_log.string (fnd_log.level_statement,
219: 'igs.plsql.igs_pr_get_class_std.get_class_standing',
220: 'Customization Flag => '||l_flag
221: );
222: END IF;

Line 255: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

251: /**
252: * Logging Load Calendar Set-Up
253: *
254: */
255: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
256: fnd_log.string (fnd_log.level_statement,
257: 'igs.plsql.igs_pr_get_class_std.get_class_standing',
258: 'Load Calendar attributes not set up properly'
259: );

Line 256: fnd_log.string (fnd_log.level_statement,

252: * Logging Load Calendar Set-Up
253: *
254: */
255: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
256: fnd_log.string (fnd_log.level_statement,
257: 'igs.plsql.igs_pr_get_class_std.get_class_standing',
258: 'Load Calendar attributes not set up properly'
259: );
260: END IF;

Line 270: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

266: /**
267: * Logging -
268: *
269: */
270: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
271: fnd_log.string (fnd_log.level_statement,
272: 'igs.plsql.igs_pr_get_class_std.get_class_standing',
273: 'Both load Calendar attributes and effective dates are passed, hence exiting'
274: );

Line 271: fnd_log.string (fnd_log.level_statement,

267: * Logging -
268: *
269: */
270: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
271: fnd_log.string (fnd_log.level_statement,
272: 'igs.plsql.igs_pr_get_class_std.get_class_standing',
273: 'Both load Calendar attributes and effective dates are passed, hence exiting'
274: );
275: END IF;

Line 287: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

283: /**
284: * Logging - l_igs_pr_class_std_id, l_igs_pr_cs_schdl_id, l_consider_changes
285: *
286: */
287: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
288: fnd_log.string (fnd_log.level_statement,
289: 'igs.plsql.igs_pr_get_class_std.get_class_standing',
290: 'Student Program Attempt and Program Type details - '||
291: 'l_igs_pr_class_std_id => '||l_igs_pr_class_std_id||';'||

Line 288: fnd_log.string (fnd_log.level_statement,

284: * Logging - l_igs_pr_class_std_id, l_igs_pr_cs_schdl_id, l_consider_changes
285: *
286: */
287: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
288: fnd_log.string (fnd_log.level_statement,
289: 'igs.plsql.igs_pr_get_class_std.get_class_standing',
290: 'Student Program Attempt and Program Type details - '||
291: 'l_igs_pr_class_std_id => '||l_igs_pr_class_std_id||';'||
292: 'l_igs_pr_cs_schdl_id => '||l_igs_pr_cs_schdl_id||';'||

Line 306: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

302: /**
303: * Logging - l_class_standing_override
304: *
305: */
306: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
307: fnd_log.string (fnd_log.level_statement,
308: 'igs.plsql.igs_pr_get_class_std.get_class_standing',
309: 'Class Standing Override values set => '||l_class_standing_override
310: );

Line 307: fnd_log.string (fnd_log.level_statement,

303: * Logging - l_class_standing_override
304: *
305: */
306: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
307: fnd_log.string (fnd_log.level_statement,
308: 'igs.plsql.igs_pr_get_class_std.get_class_standing',
309: 'Class Standing Override values set => '||l_class_standing_override
310: );
311: END IF;

Line 319: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

315: /**
316: * Logging -
317: *
318: */
319: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
320: fnd_log.string (fnd_log.level_statement,
321: 'igs.plsql.igs_pr_get_class_std.get_class_standing',
322: 'Class Standing setup is not done, hence exiting'
323: );

Line 320: fnd_log.string (fnd_log.level_statement,

316: * Logging -
317: *
318: */
319: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
320: fnd_log.string (fnd_log.level_statement,
321: 'igs.plsql.igs_pr_get_class_std.get_class_standing',
322: 'Class Standing setup is not done, hence exiting'
323: );
324: END IF;

Line 352: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

348: /**
349: * Logging -
350: *
351: */
352: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
353: fnd_log.string (fnd_log.level_statement,
354: 'igs.plsql.igs_pr_get_class_std.get_class_standing',
355: 'l_min_cp_count and l_acad_year_count both are NULL or 0, hence exiting'
356: );

Line 353: fnd_log.string (fnd_log.level_statement,

349: * Logging -
350: *
351: */
352: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
353: fnd_log.string (fnd_log.level_statement,
354: 'igs.plsql.igs_pr_get_class_std.get_class_standing',
355: 'l_min_cp_count and l_acad_year_count both are NULL or 0, hence exiting'
356: );
357: END IF;

Line 365: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

361: /**
362: * Logging -
363: *
364: */
365: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
366: fnd_log.string (fnd_log.level_statement,
367: 'igs.plsql.igs_pr_get_class_std.get_class_standing',
368: 'l_min_cp_count => '|| l_min_cp_count||';'||
369: 'l_acad_year_count => '||l_acad_year_count||';'

Line 366: fnd_log.string (fnd_log.level_statement,

362: * Logging -
363: *
364: */
365: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
366: fnd_log.string (fnd_log.level_statement,
367: 'igs.plsql.igs_pr_get_class_std.get_class_standing',
368: 'l_min_cp_count => '|| l_min_cp_count||';'||
369: 'l_acad_year_count => '||l_acad_year_count||';'
370: );

Line 389: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

385: /**
386: * Logging - l_class_standing
387: *
388: */
389: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
390: fnd_log.string (fnd_log.level_statement,
391: 'igs.plsql.igs_pr_get_class_std.get_class_standing',
392: 'l_class_standing => '|| l_class_standing||';'
393: );

Line 390: fnd_log.string (fnd_log.level_statement,

386: * Logging - l_class_standing
387: *
388: */
389: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
390: fnd_log.string (fnd_log.level_statement,
391: 'igs.plsql.igs_pr_get_class_std.get_class_standing',
392: 'l_class_standing => '|| l_class_standing||';'
393: );
394: END IF;

Line 417: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

413: /**
414: * Logging - l_earned_cp
415: *
416: */
417: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
418: fnd_log.string (fnd_log.level_statement,
419: 'igs.plsql.igs_pr_get_class_std.get_class_standing',
420: 'l_earned_cp => '|| l_earned_cp||';'
421: );

Line 418: fnd_log.string (fnd_log.level_statement,

414: * Logging - l_earned_cp
415: *
416: */
417: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
418: fnd_log.string (fnd_log.level_statement,
419: 'igs.plsql.igs_pr_get_class_std.get_class_standing',
420: 'l_earned_cp => '|| l_earned_cp||';'
421: );
422: END IF;

Line 460: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

456: /**
457: * Logging - l_enrolled_cp
458: *
459: */
460: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
461: fnd_log.string (fnd_log.level_statement,
462: 'igs.plsql.igs_pr_get_class_std.get_class_standing',
463: 'l_enrolled_cp => '|| l_enrolled_cp||';'
464: );

Line 461: fnd_log.string (fnd_log.level_statement,

457: * Logging - l_enrolled_cp
458: *
459: */
460: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
461: fnd_log.string (fnd_log.level_statement,
462: 'igs.plsql.igs_pr_get_class_std.get_class_standing',
463: 'l_enrolled_cp => '|| l_enrolled_cp||';'
464: );
465: END IF;

Line 477: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

473: /**
474: * Logging - l_class_standing
475: *
476: */
477: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
478: fnd_log.string (fnd_log.level_statement,
479: 'igs.plsql.igs_pr_get_class_std.get_class_standing',
480: 'l_class_standing => '|| l_class_standing||';'
481: );

Line 478: fnd_log.string (fnd_log.level_statement,

474: * Logging - l_class_standing
475: *
476: */
477: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
478: fnd_log.string (fnd_log.level_statement,
479: 'igs.plsql.igs_pr_get_class_std.get_class_standing',
480: 'l_class_standing => '|| l_class_standing||';'
481: );
482: END IF;