DBA Data[Home] [Help]

APPS.IGS_PR_GET_CLASS_STD dependencies on IGS_PR_GET_CLASS_STD

Line 1: PACKAGE BODY Igs_Pr_Get_Class_Std AS

1: PACKAGE BODY Igs_Pr_Get_Class_Std AS
2: /* $Header: IGSPR28B.pls 120.2 2006/04/29 02:27:11 swaghmar ship $ */
3:
4: ----------------------------------------------------------------------------------------------------------------
5: --Change History:

Line 202: 'igs.plsql.igs_pr_get_class_std.get_class_standing' || '.begin',

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|| ';' ||
206: ' p_effective_dt => '||p_effective_dt|| ';' ||

Line 219: 'igs.plsql.igs_pr_get_class_std.get_class_standing',

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;
223:

Line 257: 'igs.plsql.igs_pr_get_class_std.get_class_standing',

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;
261: RETURN NULL;

Line 272: 'igs.plsql.igs_pr_get_class_std.get_class_standing',

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;
276: RETURN NULL;

Line 289: 'igs.plsql.igs_pr_get_class_std.get_class_standing',

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||';'||
293: 'l_onsider_changes => '||l_consider_changes||';'

Line 308: 'igs.plsql.igs_pr_get_class_std.get_class_standing',

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;
312: RETURN l_class_standing_override;

Line 321: 'igs.plsql.igs_pr_get_class_std.get_class_standing',

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;
325: RETURN NULL;

Line 354: 'igs.plsql.igs_pr_get_class_std.get_class_standing',

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;
358: RETURN NULL;

Line 367: 'igs.plsql.igs_pr_get_class_std.get_class_standing',

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: );
371: END IF;

Line 391: 'igs.plsql.igs_pr_get_class_std.get_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;
395: RETURN l_class_standing;

Line 419: 'igs.plsql.igs_pr_get_class_std.get_class_standing',

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;
423: l_cp := NVL(l_earned_cp, 0);

Line 462: 'igs.plsql.igs_pr_get_class_std.get_class_standing',

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;
466: /* For predictive the cp total is earned cp plus enrolled cp */

Line 479: 'igs.plsql.igs_pr_get_class_std.get_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;
483: RETURN l_class_standing;

Line 489: Fnd_Message.SET_TOKEN('NAME', 'Igs_Pr_Get_Class_Std.get_class_standing');

485: END IF;
486: EXCEPTION
487: WHEN OTHERS THEN
488: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
489: Fnd_Message.SET_TOKEN('NAME', 'Igs_Pr_Get_Class_Std.get_class_standing');
490: Igs_Ge_Msg_Stack.ADD;
491: App_Exception.Raise_Exception;
492: END get_class_standing;
493:

Line 494: END Igs_Pr_Get_Class_Std;

490: Igs_Ge_Msg_Stack.ADD;
491: App_Exception.Raise_Exception;
492: END get_class_standing;
493:
494: END Igs_Pr_Get_Class_Std;