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

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

38: prev_rec_grading_schema_grades cur_grading_schema_grades%ROWTYPE;
39: l_routine VARCHAR2(30) := 'validate_grading_schema';
40: --
41: BEGIN
42: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
43: fnd_log.string (
44: fnd_log.level_procedure,
45: g_module_head || l_routine || '.begin',
46: 'Params: p_grading_schema_cd=>' || p_grading_schema_cd || ';' ||

Line 43: fnd_log.string (

39: l_routine VARCHAR2(30) := 'validate_grading_schema';
40: --
41: BEGIN
42: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
43: fnd_log.string (
44: fnd_log.level_procedure,
45: g_module_head || l_routine || '.begin',
46: 'Params: p_grading_schema_cd=>' || p_grading_schema_cd || ';' ||
47: 'p_version_number=>' || p_version_number || ';'

Line 44: fnd_log.level_procedure,

40: --
41: BEGIN
42: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
43: fnd_log.string (
44: fnd_log.level_procedure,
45: g_module_head || l_routine || '.begin',
46: 'Params: p_grading_schema_cd=>' || p_grading_schema_cd || ';' ||
47: 'p_version_number=>' || p_version_number || ';'
48: );

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

50: FOR rec_grading_schema_grades IN cur_grading_schema_grades (
51: p_grading_schema_cd,
52: p_version_number
53: ) LOOP
54: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
55: fnd_log.string (
56: fnd_log.level_statement,
57: g_module_head || l_routine || '.mark_range',
58: 'Lower =>' || rec_grading_schema_grades.lower_mark_range ||

Line 55: fnd_log.string (

51: p_grading_schema_cd,
52: p_version_number
53: ) LOOP
54: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
55: fnd_log.string (
56: fnd_log.level_statement,
57: g_module_head || l_routine || '.mark_range',
58: 'Lower =>' || rec_grading_schema_grades.lower_mark_range ||
59: '; Upper =>' || rec_grading_schema_grades.upper_mark_range || ';'

Line 56: fnd_log.level_statement,

52: p_version_number
53: ) LOOP
54: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
55: fnd_log.string (
56: fnd_log.level_statement,
57: g_module_head || l_routine || '.mark_range',
58: 'Lower =>' || rec_grading_schema_grades.lower_mark_range ||
59: '; Upper =>' || rec_grading_schema_grades.upper_mark_range || ';'
60: );

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

60: );
61: END IF;
62: IF ((rec_grading_schema_grades.lower_mark_range IS NULL) OR
63: (rec_grading_schema_grades.upper_mark_range IS NULL)) THEN
64: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
65: fnd_log.string (
66: fnd_log.level_statement,
67: g_module_head || l_routine || '.mark_range_null',
68: 'Mark Range is NULL'

Line 65: fnd_log.string (

61: END IF;
62: IF ((rec_grading_schema_grades.lower_mark_range IS NULL) OR
63: (rec_grading_schema_grades.upper_mark_range IS NULL)) THEN
64: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
65: fnd_log.string (
66: fnd_log.level_statement,
67: g_module_head || l_routine || '.mark_range_null',
68: 'Mark Range is NULL'
69: );

Line 66: fnd_log.level_statement,

62: IF ((rec_grading_schema_grades.lower_mark_range IS NULL) OR
63: (rec_grading_schema_grades.upper_mark_range IS NULL)) THEN
64: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
65: fnd_log.string (
66: fnd_log.level_statement,
67: g_module_head || l_routine || '.mark_range_null',
68: 'Mark Range is NULL'
69: );
70: END IF;

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

72: ELSIF NOT ((rec_grading_schema_grades.lower_mark_range -
73: prev_rec_grading_schema_grades.upper_mark_range > 0) AND
74: (rec_grading_schema_grades.lower_mark_range -
75: prev_rec_grading_schema_grades.upper_mark_range <= 1)) THEN
76: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
77: fnd_log.string (
78: fnd_log.level_statement,
79: g_module_head || l_routine || '.lower_upper_mark_gap',
80: 'Gap Between Lower mark Of Current Range And Upper Mark Of Previous Range'

Line 77: fnd_log.string (

73: prev_rec_grading_schema_grades.upper_mark_range > 0) AND
74: (rec_grading_schema_grades.lower_mark_range -
75: prev_rec_grading_schema_grades.upper_mark_range <= 1)) THEN
76: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
77: fnd_log.string (
78: fnd_log.level_statement,
79: g_module_head || l_routine || '.lower_upper_mark_gap',
80: 'Gap Between Lower mark Of Current Range And Upper Mark Of Previous Range'
81: );

Line 78: fnd_log.level_statement,

74: (rec_grading_schema_grades.lower_mark_range -
75: prev_rec_grading_schema_grades.upper_mark_range <= 1)) THEN
76: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
77: fnd_log.string (
78: fnd_log.level_statement,
79: g_module_head || l_routine || '.lower_upper_mark_gap',
80: 'Gap Between Lower mark Of Current Range And Upper Mark Of Previous Range'
81: );
82: END IF;

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

83: RETURN 'IGS_AS_US_GRD_SCH_HAS_NO_MARKS';
84: END IF;
85: prev_rec_grading_schema_grades := rec_grading_schema_grades;
86: END LOOP;
87: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
88: fnd_log.string (
89: fnd_log.level_procedure,
90: g_module_head || l_routine || '.end',
91: l_routine

Line 88: fnd_log.string (

84: END IF;
85: prev_rec_grading_schema_grades := rec_grading_schema_grades;
86: END LOOP;
87: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
88: fnd_log.string (
89: fnd_log.level_procedure,
90: g_module_head || l_routine || '.end',
91: l_routine
92: );

Line 89: fnd_log.level_procedure,

85: prev_rec_grading_schema_grades := rec_grading_schema_grades;
86: END LOOP;
87: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
88: fnd_log.string (
89: fnd_log.level_procedure,
90: g_module_head || l_routine || '.end',
91: l_routine
92: );
93: END IF;

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

194: rec_uai_reference cur_uai_reference%ROWTYPE;
195: rec_usai_reference cur_usai_reference%ROWTYPE;
196: --
197: BEGIN
198: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
199: fnd_log.string (
200: fnd_log.level_procedure,
201: g_module_head || l_routine || '.begin',
202: 'Params: p_person_id=>' || p_person_id || ';' ||

Line 199: fnd_log.string (

195: rec_usai_reference cur_usai_reference%ROWTYPE;
196: --
197: BEGIN
198: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
199: fnd_log.string (
200: fnd_log.level_procedure,
201: g_module_head || l_routine || '.begin',
202: 'Params: p_person_id=>' || p_person_id || ';' ||
203: 'p_course_cd=>' || p_course_cd || ';' ||

Line 200: fnd_log.level_procedure,

196: --
197: BEGIN
198: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
199: fnd_log.string (
200: fnd_log.level_procedure,
201: g_module_head || l_routine || '.begin',
202: 'Params: p_person_id=>' || p_person_id || ';' ||
203: 'p_course_cd=>' || p_course_cd || ';' ||
204: 'p_uoo_id=>' || p_uoo_id || ';' ||

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

235: rec_usec_dflt_grading_schema.grading_schema_code,
236: rec_usec_dflt_grading_schema.grd_schm_version_number
237: );
238: IF (p_message_name IS NOT NULL) THEN
239: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
240: fnd_log.string (
241: fnd_log.level_statement,
242: g_module_head || l_routine || '.dflt_grd_sch_for_uoo_id',
243: 'Default Unit Section Grading Schema has gaps/invalid range'

Line 240: fnd_log.string (

236: rec_usec_dflt_grading_schema.grd_schm_version_number
237: );
238: IF (p_message_name IS NOT NULL) THEN
239: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
240: fnd_log.string (
241: fnd_log.level_statement,
242: g_module_head || l_routine || '.dflt_grd_sch_for_uoo_id',
243: 'Default Unit Section Grading Schema has gaps/invalid range'
244: );

Line 241: fnd_log.level_statement,

237: );
238: IF (p_message_name IS NOT NULL) THEN
239: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
240: fnd_log.string (
241: fnd_log.level_statement,
242: g_module_head || l_routine || '.dflt_grd_sch_for_uoo_id',
243: 'Default Unit Section Grading Schema has gaps/invalid range'
244: );
245: END IF;

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

284: p_message_name := 'IGS_AS_AI_GRD_SCH_HAS_NO_MARKS::' ||
285: rec_sua_ai_failing.ass_id || '^^' ||
286: rec_usai_reference.reference;
287: END IF;
288: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
289: fnd_log.string (
290: fnd_log.level_statement,
291: g_module_head || l_routine || '.suaai_grd_sch',
292: 'Student Unit Attempt Assessment Item Grading Schema has gaps/invalid range'

Line 289: fnd_log.string (

285: rec_sua_ai_failing.ass_id || '^^' ||
286: rec_usai_reference.reference;
287: END IF;
288: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
289: fnd_log.string (
290: fnd_log.level_statement,
291: g_module_head || l_routine || '.suaai_grd_sch',
292: 'Student Unit Attempt Assessment Item Grading Schema has gaps/invalid range'
293: );

Line 290: fnd_log.level_statement,

286: rec_usai_reference.reference;
287: END IF;
288: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
289: fnd_log.string (
290: fnd_log.level_statement,
291: g_module_head || l_routine || '.suaai_grd_sch',
292: 'Student Unit Attempt Assessment Item Grading Schema has gaps/invalid range'
293: );
294: END IF;

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

295: RETURN;
296: END IF;
297: END LOOP;
298: END IF;
299: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
300: fnd_log.string (
301: fnd_log.level_procedure,
302: g_module_head || l_routine || '.end',
303: l_routine

Line 300: fnd_log.string (

296: END IF;
297: END LOOP;
298: END IF;
299: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
300: fnd_log.string (
301: fnd_log.level_procedure,
302: g_module_head || l_routine || '.end',
303: l_routine
304: );

Line 301: fnd_log.level_procedure,

297: END LOOP;
298: END IF;
299: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
300: fnd_log.string (
301: fnd_log.level_procedure,
302: g_module_head || l_routine || '.end',
303: l_routine
304: );
305: END IF;

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

476: v_mark_weight_products NUMBER := 0;
477: v_mandatory_pass_items_passed BOOLEAN := TRUE;
478: --
479: BEGIN
480: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
481: fnd_log.string (
482: fnd_log.level_procedure,
483: g_module_head || l_routine || '.begin',
484: 'Params: p_person_id=>' || p_person_id || ';' ||

Line 481: fnd_log.string (

477: v_mandatory_pass_items_passed BOOLEAN := TRUE;
478: --
479: BEGIN
480: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
481: fnd_log.string (
482: fnd_log.level_procedure,
483: g_module_head || l_routine || '.begin',
484: 'Params: p_person_id=>' || p_person_id || ';' ||
485: 'p_course_cd=>' || p_course_cd || ';' ||

Line 482: fnd_log.level_procedure,

478: --
479: BEGIN
480: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
481: fnd_log.string (
482: fnd_log.level_procedure,
483: g_module_head || l_routine || '.begin',
484: 'Params: p_person_id=>' || p_person_id || ';' ||
485: 'p_course_cd=>' || p_course_cd || ';' ||
486: 'p_uoo_id=>' || p_uoo_id || ';' ||

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

506: p_course_cd,
507: p_uoo_id,
508: p_grading_period_cd
509: ) LOOP
510: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
511: fnd_log.string (
512: fnd_log.level_statement,
513: g_module_head || l_routine || '.selected values',
514: 'group_name =>' || rec_suaaig.group_name || ';' ||

Line 511: fnd_log.string (

507: p_uoo_id,
508: p_grading_period_cd
509: ) LOOP
510: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
511: fnd_log.string (
512: fnd_log.level_statement,
513: g_module_head || l_routine || '.selected values',
514: 'group_name =>' || rec_suaaig.group_name || ';' ||
515: 'group_formula_code =>' || rec_suaaig.group_formula_code || ';' ||

Line 512: fnd_log.level_statement,

508: p_grading_period_cd
509: ) LOOP
510: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
511: fnd_log.string (
512: fnd_log.level_statement,
513: g_module_head || l_routine || '.selected values',
514: 'group_name =>' || rec_suaaig.group_name || ';' ||
515: 'group_formula_code =>' || rec_suaaig.group_formula_code || ';' ||
516: 'group_formula_qty =>' || rec_suaaig.group_formula_qty || ';' ||

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

541: --
542: -- Student does not have enough Best N or Atleast N for SUAO derivation;
543: -- So return Mark and Grade as NULL
544: --
545: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
546: fnd_log.string (
547: fnd_log.level_statement,
548: g_module_head || l_routine || '.not_enough_best_atleast_n_items',
549: 'Returning the SUAO Mark as NULL and Grade as NULL with error message IGS_AS_STU_HAS_INSUF_AI_ATTMPS'

Line 546: fnd_log.string (

542: -- Student does not have enough Best N or Atleast N for SUAO derivation;
543: -- So return Mark and Grade as NULL
544: --
545: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
546: fnd_log.string (
547: fnd_log.level_statement,
548: g_module_head || l_routine || '.not_enough_best_atleast_n_items',
549: 'Returning the SUAO Mark as NULL and Grade as NULL with error message IGS_AS_STU_HAS_INSUF_AI_ATTMPS'
550: );

Line 547: fnd_log.level_statement,

543: -- So return Mark and Grade as NULL
544: --
545: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
546: fnd_log.string (
547: fnd_log.level_statement,
548: g_module_head || l_routine || '.not_enough_best_atleast_n_items',
549: 'Returning the SUAO Mark as NULL and Grade as NULL with error message IGS_AS_STU_HAS_INSUF_AI_ATTMPS'
550: );
551: END IF;

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

564: --
565: IF ((rec_suaaig.mandatory_type_code = 'MANDATORY') AND
566: (rec_suaaig.mark IS NULL) AND
567: (rec_suaaig.waived_flag = 'N')) THEN
568: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
569: fnd_log.string (
570: fnd_log.level_statement,
571: g_module_head || l_routine || '.mandatory_items_enough_best_atleast_n_items',
572: 'Returning the SUAO Mark as 0 and Grade as NULL with error message IGS_AS_STU_NOT_ATMPT_MAND_AI'

Line 569: fnd_log.string (

565: IF ((rec_suaaig.mandatory_type_code = 'MANDATORY') AND
566: (rec_suaaig.mark IS NULL) AND
567: (rec_suaaig.waived_flag = 'N')) THEN
568: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
569: fnd_log.string (
570: fnd_log.level_statement,
571: g_module_head || l_routine || '.mandatory_items_enough_best_atleast_n_items',
572: 'Returning the SUAO Mark as 0 and Grade as NULL with error message IGS_AS_STU_NOT_ATMPT_MAND_AI'
573: );

Line 570: fnd_log.level_statement,

566: (rec_suaaig.mark IS NULL) AND
567: (rec_suaaig.waived_flag = 'N')) THEN
568: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
569: fnd_log.string (
570: fnd_log.level_statement,
571: g_module_head || l_routine || '.mandatory_items_enough_best_atleast_n_items',
572: 'Returning the SUAO Mark as 0 and Grade as NULL with error message IGS_AS_STU_NOT_ATMPT_MAND_AI'
573: );
574: END IF;

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

627: --
628: -- Student does not have enough Best N or Atleast N for SUAO derivation;
629: -- So return Mark and Grade as NULL
630: --
631: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
632: fnd_log.string (
633: fnd_log.level_statement,
634: g_module_head || l_routine || '.not_enough_best_atleast_n_items',
635: 'Returning the SUAO Mark as NULL and Grade as NULL with error message IGS_AS_STU_HAS_INSUF_AI_ATTMPS'

Line 632: fnd_log.string (

628: -- Student does not have enough Best N or Atleast N for SUAO derivation;
629: -- So return Mark and Grade as NULL
630: --
631: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
632: fnd_log.string (
633: fnd_log.level_statement,
634: g_module_head || l_routine || '.not_enough_best_atleast_n_items',
635: 'Returning the SUAO Mark as NULL and Grade as NULL with error message IGS_AS_STU_HAS_INSUF_AI_ATTMPS'
636: );

Line 633: fnd_log.level_statement,

629: -- So return Mark and Grade as NULL
630: --
631: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
632: fnd_log.string (
633: fnd_log.level_statement,
634: g_module_head || l_routine || '.not_enough_best_atleast_n_items',
635: 'Returning the SUAO Mark as NULL and Grade as NULL with error message IGS_AS_STU_HAS_INSUF_AI_ATTMPS'
636: );
637: END IF;

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

641: IF (v_previous_group_name = '`') THEN
642: --
643: -- No Student Unit Attempts Assessment Items found so return NULL
644: --
645: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
646: fnd_log.string (
647: fnd_log.level_statement,
648: g_module_head || l_routine || '.no_assessment_items_setup',
649: 'Returning the SUAO Mark as NULL and Grade as NULL as there are no assessment items setup'

Line 646: fnd_log.string (

642: --
643: -- No Student Unit Attempts Assessment Items found so return NULL
644: --
645: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
646: fnd_log.string (
647: fnd_log.level_statement,
648: g_module_head || l_routine || '.no_assessment_items_setup',
649: 'Returning the SUAO Mark as NULL and Grade as NULL as there are no assessment items setup'
650: );

Line 647: fnd_log.level_statement,

643: -- No Student Unit Attempts Assessment Items found so return NULL
644: --
645: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
646: fnd_log.string (
647: fnd_log.level_statement,
648: g_module_head || l_routine || '.no_assessment_items_setup',
649: 'Returning the SUAO Mark as NULL and Grade as NULL as there are no assessment items setup'
650: );
651: END IF;

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

681: suaaig_table(aig_table_index).mark := 0;
682: END IF;
683: suaaig_table(aig_table_index).group_weight_qty := v_previous_group_formula;
684: --
685: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
686: fnd_log.string (
687: fnd_log.level_statement,
688: g_module_head || l_routine || '.assessment_item_group_mark',
689: 'Group Name =>' || v_previous_group_name || ';' ||

Line 686: fnd_log.string (

682: END IF;
683: suaaig_table(aig_table_index).group_weight_qty := v_previous_group_formula;
684: --
685: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
686: fnd_log.string (
687: fnd_log.level_statement,
688: g_module_head || l_routine || '.assessment_item_group_mark',
689: 'Group Name =>' || v_previous_group_name || ';' ||
690: 'Group Formula Weight =>' || v_previous_group_formula || ';' ||

Line 687: fnd_log.level_statement,

683: suaaig_table(aig_table_index).group_weight_qty := v_previous_group_formula;
684: --
685: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
686: fnd_log.string (
687: fnd_log.level_statement,
688: g_module_head || l_routine || '.assessment_item_group_mark',
689: 'Group Name =>' || v_previous_group_name || ';' ||
690: 'Group Formula Weight =>' || v_previous_group_formula || ';' ||
691: 'Mark =>' || suaaig_table(aig_table_index).mark || ';'

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

714: suaaig_table(aig_table_index).mark := 0;
715: END IF;
716: suaaig_table(aig_table_index).group_weight_qty := v_previous_group_formula;
717: --
718: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
719: fnd_log.string (
720: fnd_log.level_statement,
721: g_module_head || l_routine || '.assessment_item_group_mark',
722: 'Group Name =>' || v_previous_group_name || ';' ||

Line 719: fnd_log.string (

715: END IF;
716: suaaig_table(aig_table_index).group_weight_qty := v_previous_group_formula;
717: --
718: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
719: fnd_log.string (
720: fnd_log.level_statement,
721: g_module_head || l_routine || '.assessment_item_group_mark',
722: 'Group Name =>' || v_previous_group_name || ';' ||
723: 'Group Formula Weight =>' || v_previous_group_formula || ';' ||

Line 720: fnd_log.level_statement,

716: suaaig_table(aig_table_index).group_weight_qty := v_previous_group_formula;
717: --
718: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
719: fnd_log.string (
720: fnd_log.level_statement,
721: g_module_head || l_routine || '.assessment_item_group_mark',
722: 'Group Name =>' || v_previous_group_name || ';' ||
723: 'Group Formula Weight =>' || v_previous_group_formula || ';' ||
724: 'Mark =>' || suaaig_table(aig_table_index).mark || ';'

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

744: ELSE
745: v_suao_raw_mark := 0;
746: END IF;
747: --
748: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
749: fnd_log.string (
750: fnd_log.level_statement,
751: g_module_head || l_routine || '.suao_raw_mark',
752: 'SUAO Raw Mark =>' || v_suao_raw_mark || ';'

Line 749: fnd_log.string (

745: v_suao_raw_mark := 0;
746: END IF;
747: --
748: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
749: fnd_log.string (
750: fnd_log.level_statement,
751: g_module_head || l_routine || '.suao_raw_mark',
752: 'SUAO Raw Mark =>' || v_suao_raw_mark || ';'
753: );

Line 750: fnd_log.level_statement,

746: END IF;
747: --
748: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
749: fnd_log.string (
750: fnd_log.level_statement,
751: g_module_head || l_routine || '.suao_raw_mark',
752: 'SUAO Raw Mark =>' || v_suao_raw_mark || ';'
753: );
754: END IF;

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

765: CLOSE cur_usec_grd_sch;
766: OPEN cur_unit_grd_sch (p_uoo_id);
767: FETCH cur_unit_grd_sch INTO rec_usec_grd_sch;
768: CLOSE cur_unit_grd_sch;
769: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
770: fnd_log.string (
771: fnd_log.level_statement,
772: g_module_head || l_routine || '.usec_dflt_grd_sch_not_available',
773: '=>Default Unit Grading Schema=>' || rec_usec_grd_sch.grading_schema_code || ';' || rec_usec_grd_sch.grd_schm_version_number || ';'

Line 770: fnd_log.string (

766: OPEN cur_unit_grd_sch (p_uoo_id);
767: FETCH cur_unit_grd_sch INTO rec_usec_grd_sch;
768: CLOSE cur_unit_grd_sch;
769: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
770: fnd_log.string (
771: fnd_log.level_statement,
772: g_module_head || l_routine || '.usec_dflt_grd_sch_not_available',
773: '=>Default Unit Grading Schema=>' || rec_usec_grd_sch.grading_schema_code || ';' || rec_usec_grd_sch.grd_schm_version_number || ';'
774: );

Line 771: fnd_log.level_statement,

767: FETCH cur_unit_grd_sch INTO rec_usec_grd_sch;
768: CLOSE cur_unit_grd_sch;
769: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
770: fnd_log.string (
771: fnd_log.level_statement,
772: g_module_head || l_routine || '.usec_dflt_grd_sch_not_available',
773: '=>Default Unit Grading Schema=>' || rec_usec_grd_sch.grading_schema_code || ';' || rec_usec_grd_sch.grd_schm_version_number || ';'
774: );
775: END IF;

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

773: '=>Default Unit Grading Schema=>' || rec_usec_grd_sch.grading_schema_code || ';' || rec_usec_grd_sch.grd_schm_version_number || ';'
774: );
775: END IF;
776: ELSE
777: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
778: fnd_log.string (
779: fnd_log.level_statement,
780: g_module_head || l_routine || '.usec_dflt_grd_sch_available',
781: '=>Default Unit Section Grading Schema=>' || rec_usec_grd_sch.grading_schema_code || ';' || rec_usec_grd_sch.grd_schm_version_number || ';'

Line 778: fnd_log.string (

774: );
775: END IF;
776: ELSE
777: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
778: fnd_log.string (
779: fnd_log.level_statement,
780: g_module_head || l_routine || '.usec_dflt_grd_sch_available',
781: '=>Default Unit Section Grading Schema=>' || rec_usec_grd_sch.grading_schema_code || ';' || rec_usec_grd_sch.grd_schm_version_number || ';'
782: );

Line 779: fnd_log.level_statement,

775: END IF;
776: ELSE
777: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
778: fnd_log.string (
779: fnd_log.level_statement,
780: g_module_head || l_routine || '.usec_dflt_grd_sch_available',
781: '=>Default Unit Section Grading Schema=>' || rec_usec_grd_sch.grading_schema_code || ';' || rec_usec_grd_sch.grd_schm_version_number || ';'
782: );
783: END IF;

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

785: END IF;
786: --
787: v_suao_mark := TO_CHAR ((v_suao_raw_mark * ((rec_usec_grd_sch.upper_limit - rec_usec_grd_sch.lower_limit)/100)) + rec_usec_grd_sch.lower_limit, l_format_mask);
788: --
789: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
790: fnd_log.string (
791: fnd_log.level_statement,
792: g_module_head || l_routine || '.suao_mark_using_usec_grd_sch',
793: 'SUAO Mark Converted to Unit Section Grading Schema=>' || v_suao_mark || ';'

Line 790: fnd_log.string (

786: --
787: v_suao_mark := TO_CHAR ((v_suao_raw_mark * ((rec_usec_grd_sch.upper_limit - rec_usec_grd_sch.lower_limit)/100)) + rec_usec_grd_sch.lower_limit, l_format_mask);
788: --
789: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
790: fnd_log.string (
791: fnd_log.level_statement,
792: g_module_head || l_routine || '.suao_mark_using_usec_grd_sch',
793: 'SUAO Mark Converted to Unit Section Grading Schema=>' || v_suao_mark || ';'
794: );

Line 791: fnd_log.level_statement,

787: v_suao_mark := TO_CHAR ((v_suao_raw_mark * ((rec_usec_grd_sch.upper_limit - rec_usec_grd_sch.lower_limit)/100)) + rec_usec_grd_sch.lower_limit, l_format_mask);
788: --
789: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
790: fnd_log.string (
791: fnd_log.level_statement,
792: g_module_head || l_routine || '.suao_mark_using_usec_grd_sch',
793: 'SUAO Mark Converted to Unit Section Grading Schema=>' || v_suao_mark || ';'
794: );
795: END IF;

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

801: );
802: FETCH cur_grade INTO rec_grade;
803: CLOSE cur_grade;
804: --
805: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
806: fnd_log.string (
807: fnd_log.level_statement,
808: g_module_head || l_routine || '.suao_grade',
809: 'SUAO Grade=>' || rec_grade.grade || ';'

Line 806: fnd_log.string (

802: FETCH cur_grade INTO rec_grade;
803: CLOSE cur_grade;
804: --
805: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
806: fnd_log.string (
807: fnd_log.level_statement,
808: g_module_head || l_routine || '.suao_grade',
809: 'SUAO Grade=>' || rec_grade.grade || ';'
810: );

Line 807: fnd_log.level_statement,

803: CLOSE cur_grade;
804: --
805: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
806: fnd_log.string (
807: fnd_log.level_statement,
808: g_module_head || l_routine || '.suao_grade',
809: 'SUAO Grade=>' || rec_grade.grade || ';'
810: );
811: END IF;

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

816: -- If not, then keep marks unchanged and assign a "Fail" grade for the SUAO.
817: --
818: IF (NOT v_mandatory_pass_items_passed) THEN
819: rec_grade.grade := NULL;
820: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
821: fnd_log.string (
822: fnd_log.level_statement,
823: g_module_head || l_routine || '.not_passed_mand_pass_items',
824: 'Returning the derived SUAO Mark and NULL for Grade with error message IGS_AS_STU_NOT_PAS_MAND_PAS_AI'

Line 821: fnd_log.string (

817: --
818: IF (NOT v_mandatory_pass_items_passed) THEN
819: rec_grade.grade := NULL;
820: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
821: fnd_log.string (
822: fnd_log.level_statement,
823: g_module_head || l_routine || '.not_passed_mand_pass_items',
824: 'Returning the derived SUAO Mark and NULL for Grade with error message IGS_AS_STU_NOT_PAS_MAND_PAS_AI'
825: );

Line 822: fnd_log.level_statement,

818: IF (NOT v_mandatory_pass_items_passed) THEN
819: rec_grade.grade := NULL;
820: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
821: fnd_log.string (
822: fnd_log.level_statement,
823: g_module_head || l_routine || '.not_passed_mand_pass_items',
824: 'Returning the derived SUAO Mark and NULL for Grade with error message IGS_AS_STU_NOT_PAS_MAND_PAS_AI'
825: );
826: END IF;

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

826: END IF;
827: RETURN (v_suao_mark || '::;;IGS_AS_STU_NOT_PAS_MAND_PAS_AI');
828: END IF;
829: --
830: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
831: fnd_log.string (
832: fnd_log.level_procedure,
833: g_module_head || l_routine || '.end',
834: l_routine

Line 831: fnd_log.string (

827: RETURN (v_suao_mark || '::;;IGS_AS_STU_NOT_PAS_MAND_PAS_AI');
828: END IF;
829: --
830: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
831: fnd_log.string (
832: fnd_log.level_procedure,
833: g_module_head || l_routine || '.end',
834: l_routine
835: );

Line 832: fnd_log.level_procedure,

828: END IF;
829: --
830: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
831: fnd_log.string (
832: fnd_log.level_procedure,
833: g_module_head || l_routine || '.end',
834: l_routine
835: );
836: END IF;

Line 841: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

837: --
838: RETURN (v_suao_mark || '::' || rec_grade.grade);
839: EXCEPTION
840: WHEN OTHERS THEN
841: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
842: fnd_log.string (
843: fnd_log.level_exception,
844: g_module_head || l_routine || '.exception',
845: 'Returning the derived SUAO Mark and NULL for Grade with error : ' || SQLERRM

Line 842: fnd_log.string (

838: RETURN (v_suao_mark || '::' || rec_grade.grade);
839: EXCEPTION
840: WHEN OTHERS THEN
841: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
842: fnd_log.string (
843: fnd_log.level_exception,
844: g_module_head || l_routine || '.exception',
845: 'Returning the derived SUAO Mark and NULL for Grade with error : ' || SQLERRM
846: );

Line 843: fnd_log.level_exception,

839: EXCEPTION
840: WHEN OTHERS THEN
841: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
842: fnd_log.string (
843: fnd_log.level_exception,
844: g_module_head || l_routine || '.exception',
845: 'Returning the derived SUAO Mark and NULL for Grade with error : ' || SQLERRM
846: );
847: END IF;

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

862: p_message_name OUT NOCOPY VARCHAR2
863: ) IS
864: l_routine VARCHAR2(30) := 'derive_suao_mark_grade_suaio';
865: BEGIN
866: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
867: fnd_log.string (
868: fnd_log.level_procedure,
869: g_module_head || l_routine || '.begin',
870: 'Params: p_person_id=>' || p_person_id || ';' ||

Line 867: fnd_log.string (

863: ) IS
864: l_routine VARCHAR2(30) := 'derive_suao_mark_grade_suaio';
865: BEGIN
866: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
867: fnd_log.string (
868: fnd_log.level_procedure,
869: g_module_head || l_routine || '.begin',
870: 'Params: p_person_id=>' || p_person_id || ';' ||
871: 'p_course_cd=>' || p_course_cd || ';' ||

Line 868: fnd_log.level_procedure,

864: l_routine VARCHAR2(30) := 'derive_suao_mark_grade_suaio';
865: BEGIN
866: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
867: fnd_log.string (
868: fnd_log.level_procedure,
869: g_module_head || l_routine || '.begin',
870: 'Params: p_person_id=>' || p_person_id || ';' ||
871: 'p_course_cd=>' || p_course_cd || ';' ||
872: 'p_uoo_id=>' || p_uoo_id || ';' ||

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

892: g_grading_period_cd = p_grading_period_cd THEN
893: --
894: -- Mark/Grade already derived for the Student so return mark without recomputing
895: --
896: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
897: fnd_log.string (
898: fnd_log.level_statement,
899: g_module_head || l_routine || '.mark_already_derived',
900: 'Returning the already derived mark=>' ||

Line 897: fnd_log.string (

893: --
894: -- Mark/Grade already derived for the Student so return mark without recomputing
895: --
896: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
897: fnd_log.string (
898: fnd_log.level_statement,
899: g_module_head || l_routine || '.mark_already_derived',
900: 'Returning the already derived mark=>' ||
901: SUBSTR (g_mark_grade, 1, INSTR (g_mark_grade, '::') - 1) ||

Line 898: fnd_log.level_statement,

894: -- Mark/Grade already derived for the Student so return mark without recomputing
895: --
896: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
897: fnd_log.string (
898: fnd_log.level_statement,
899: g_module_head || l_routine || '.mark_already_derived',
900: 'Returning the already derived mark=>' ||
901: SUBSTR (g_mark_grade, 1, INSTR (g_mark_grade, '::') - 1) ||
902: '; grade=>' || SUBSTR (g_mark_grade, INSTR (g_mark_grade, '::') + 2) || '; with error message ' || p_message_name

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

911: p_course_cd,
912: p_uoo_id,
913: p_grading_period_cd
914: );
915: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
916: fnd_log.string (
917: fnd_log.level_statement,
918: g_module_head || l_routine || '.derived_mark',
919: 'Derived Mark=>' ||

Line 916: fnd_log.string (

912: p_uoo_id,
913: p_grading_period_cd
914: );
915: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
916: fnd_log.string (
917: fnd_log.level_statement,
918: g_module_head || l_routine || '.derived_mark',
919: 'Derived Mark=>' ||
920: SUBSTR (g_mark_grade, 1, INSTR (g_mark_grade, '::') - 1) ||

Line 917: fnd_log.level_statement,

913: p_grading_period_cd
914: );
915: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
916: fnd_log.string (
917: fnd_log.level_statement,
918: g_module_head || l_routine || '.derived_mark',
919: 'Derived Mark=>' ||
920: SUBSTR (g_mark_grade, 1, INSTR (g_mark_grade, '::') - 1) ||
921: '; with error message ' || p_message_name

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

939: --
940: -- Extract Mark
941: --
942: p_mark := SUBSTR (g_mark_grade, 1, INSTR (g_mark_grade, '::') - 1);
943: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
944: fnd_log.string (
945: fnd_log.level_procedure,
946: g_module_head || l_routine || '.end',
947: l_routine

Line 944: fnd_log.string (

940: -- Extract Mark
941: --
942: p_mark := SUBSTR (g_mark_grade, 1, INSTR (g_mark_grade, '::') - 1);
943: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
944: fnd_log.string (
945: fnd_log.level_procedure,
946: g_module_head || l_routine || '.end',
947: l_routine
948: );

Line 945: fnd_log.level_procedure,

941: --
942: p_mark := SUBSTR (g_mark_grade, 1, INSTR (g_mark_grade, '::') - 1);
943: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
944: fnd_log.string (
945: fnd_log.level_procedure,
946: g_module_head || l_routine || '.end',
947: l_routine
948: );
949: END IF;

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

965: p_message_name OUT NOCOPY VARCHAR2
966: ) RETURN NUMBER IS
967: l_routine VARCHAR2(30) := 'derive_suao_mark_from_suaio';
968: BEGIN
969: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
970: fnd_log.string (
971: fnd_log.level_procedure,
972: g_module_head || l_routine || '.begin',
973: 'Params: p_person_id=>' || p_person_id || ';' ||

Line 970: fnd_log.string (

966: ) RETURN NUMBER IS
967: l_routine VARCHAR2(30) := 'derive_suao_mark_from_suaio';
968: BEGIN
969: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
970: fnd_log.string (
971: fnd_log.level_procedure,
972: g_module_head || l_routine || '.begin',
973: 'Params: p_person_id=>' || p_person_id || ';' ||
974: 'p_course_cd=>' || p_course_cd || ';' ||

Line 971: fnd_log.level_procedure,

967: l_routine VARCHAR2(30) := 'derive_suao_mark_from_suaio';
968: BEGIN
969: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
970: fnd_log.string (
971: fnd_log.level_procedure,
972: g_module_head || l_routine || '.begin',
973: 'Params: p_person_id=>' || p_person_id || ';' ||
974: 'p_course_cd=>' || p_course_cd || ';' ||
975: 'p_uoo_id=>' || p_uoo_id || ';' ||

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

995: g_grading_period_cd = p_grading_period_cd THEN
996: --
997: -- Mark/Grade already derived for the Student so return mark without recomputing
998: --
999: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1000: fnd_log.string (
1001: fnd_log.level_statement,
1002: g_module_head || l_routine || '.mark_already_derived',
1003: 'Returning the already derived mark=>' ||

Line 1000: fnd_log.string (

996: --
997: -- Mark/Grade already derived for the Student so return mark without recomputing
998: --
999: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1000: fnd_log.string (
1001: fnd_log.level_statement,
1002: g_module_head || l_routine || '.mark_already_derived',
1003: 'Returning the already derived mark=>' ||
1004: SUBSTR (g_mark_grade, 1, INSTR (g_mark_grade, '::') - 1) ||

Line 1001: fnd_log.level_statement,

997: -- Mark/Grade already derived for the Student so return mark without recomputing
998: --
999: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1000: fnd_log.string (
1001: fnd_log.level_statement,
1002: g_module_head || l_routine || '.mark_already_derived',
1003: 'Returning the already derived mark=>' ||
1004: SUBSTR (g_mark_grade, 1, INSTR (g_mark_grade, '::') - 1) ||
1005: '; with error message ' || SUBSTR (g_mark_grade, INSTR (g_mark_grade, ';;') + 2)

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

1014: p_course_cd,
1015: p_uoo_id,
1016: p_grading_period_cd
1017: );
1018: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1019: fnd_log.string (
1020: fnd_log.level_statement,
1021: g_module_head || l_routine || '.derived_mark',
1022: 'Derived Mark=>' ||

Line 1019: fnd_log.string (

1015: p_uoo_id,
1016: p_grading_period_cd
1017: );
1018: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1019: fnd_log.string (
1020: fnd_log.level_statement,
1021: g_module_head || l_routine || '.derived_mark',
1022: 'Derived Mark=>' ||
1023: SUBSTR (g_mark_grade, 1, INSTR (g_mark_grade, '::') - 1) ||

Line 1020: fnd_log.level_statement,

1016: p_grading_period_cd
1017: );
1018: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1019: fnd_log.string (
1020: fnd_log.level_statement,
1021: g_module_head || l_routine || '.derived_mark',
1022: 'Derived Mark=>' ||
1023: SUBSTR (g_mark_grade, 1, INSTR (g_mark_grade, '::') - 1) ||
1024: '; with error message ' || SUBSTR (g_mark_grade, INSTR (g_mark_grade, ';;') + 2)

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

1027: END IF;
1028: IF (INSTR (g_mark_grade, ';;') > 0) THEN
1029: p_message_name := SUBSTR (g_mark_grade, INSTR (g_mark_grade, ';;') + 2);
1030: END IF;
1031: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
1032: fnd_log.string (
1033: fnd_log.level_procedure,
1034: g_module_head || l_routine || '.end',
1035: l_routine

Line 1032: fnd_log.string (

1028: IF (INSTR (g_mark_grade, ';;') > 0) THEN
1029: p_message_name := SUBSTR (g_mark_grade, INSTR (g_mark_grade, ';;') + 2);
1030: END IF;
1031: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
1032: fnd_log.string (
1033: fnd_log.level_procedure,
1034: g_module_head || l_routine || '.end',
1035: l_routine
1036: );

Line 1033: fnd_log.level_procedure,

1029: p_message_name := SUBSTR (g_mark_grade, INSTR (g_mark_grade, ';;') + 2);
1030: END IF;
1031: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
1032: fnd_log.string (
1033: fnd_log.level_procedure,
1034: g_module_head || l_routine || '.end',
1035: l_routine
1036: );
1037: END IF;

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

1049: p_reset_mark_grade IN VARCHAR2 DEFAULT 'N'
1050: ) RETURN NUMBER IS
1051: l_routine VARCHAR2(30) := 'derive_suao_mark_from_suaio';
1052: BEGIN
1053: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
1054: fnd_log.string (
1055: fnd_log.level_procedure,
1056: g_module_head || l_routine || '.begin',
1057: 'Params: p_person_id=>' || p_person_id || ';' ||

Line 1054: fnd_log.string (

1050: ) RETURN NUMBER IS
1051: l_routine VARCHAR2(30) := 'derive_suao_mark_from_suaio';
1052: BEGIN
1053: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
1054: fnd_log.string (
1055: fnd_log.level_procedure,
1056: g_module_head || l_routine || '.begin',
1057: 'Params: p_person_id=>' || p_person_id || ';' ||
1058: 'p_course_cd=>' || p_course_cd || ';' ||

Line 1055: fnd_log.level_procedure,

1051: l_routine VARCHAR2(30) := 'derive_suao_mark_from_suaio';
1052: BEGIN
1053: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
1054: fnd_log.string (
1055: fnd_log.level_procedure,
1056: g_module_head || l_routine || '.begin',
1057: 'Params: p_person_id=>' || p_person_id || ';' ||
1058: 'p_course_cd=>' || p_course_cd || ';' ||
1059: 'p_uoo_id=>' || p_uoo_id || ';' ||

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

1079: g_grading_period_cd = p_grading_period_cd THEN
1080: --
1081: -- Mark/Grade already derived for the Student so return Mark without recomputing
1082: --
1083: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1084: fnd_log.string (
1085: fnd_log.level_statement,
1086: g_module_head || l_routine || '.mark_already_derived',
1087: 'Returning the already derived mark=>' ||

Line 1084: fnd_log.string (

1080: --
1081: -- Mark/Grade already derived for the Student so return Mark without recomputing
1082: --
1083: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1084: fnd_log.string (
1085: fnd_log.level_statement,
1086: g_module_head || l_routine || '.mark_already_derived',
1087: 'Returning the already derived mark=>' ||
1088: SUBSTR (g_mark_grade, 1, INSTR (g_mark_grade, '::') - 1)

Line 1085: fnd_log.level_statement,

1081: -- Mark/Grade already derived for the Student so return Mark without recomputing
1082: --
1083: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1084: fnd_log.string (
1085: fnd_log.level_statement,
1086: g_module_head || l_routine || '.mark_already_derived',
1087: 'Returning the already derived mark=>' ||
1088: SUBSTR (g_mark_grade, 1, INSTR (g_mark_grade, '::') - 1)
1089: );

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

1097: p_course_cd,
1098: p_uoo_id,
1099: p_grading_period_cd
1100: );
1101: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1102: fnd_log.string (
1103: fnd_log.level_statement,
1104: g_module_head || l_routine || '.derived_mark',
1105: 'Derived Mark=>' ||

Line 1102: fnd_log.string (

1098: p_uoo_id,
1099: p_grading_period_cd
1100: );
1101: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1102: fnd_log.string (
1103: fnd_log.level_statement,
1104: g_module_head || l_routine || '.derived_mark',
1105: 'Derived Mark=>' ||
1106: SUBSTR (g_mark_grade, 1, INSTR (g_mark_grade, '::') - 1)

Line 1103: fnd_log.level_statement,

1099: p_grading_period_cd
1100: );
1101: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1102: fnd_log.string (
1103: fnd_log.level_statement,
1104: g_module_head || l_routine || '.derived_mark',
1105: 'Derived Mark=>' ||
1106: SUBSTR (g_mark_grade, 1, INSTR (g_mark_grade, '::') - 1)
1107: );

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

1106: SUBSTR (g_mark_grade, 1, INSTR (g_mark_grade, '::') - 1)
1107: );
1108: END IF;
1109: END IF;
1110: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
1111: fnd_log.string (
1112: fnd_log.level_procedure,
1113: g_module_head || l_routine || '.end',
1114: l_routine

Line 1111: fnd_log.string (

1107: );
1108: END IF;
1109: END IF;
1110: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
1111: fnd_log.string (
1112: fnd_log.level_procedure,
1113: g_module_head || l_routine || '.end',
1114: l_routine
1115: );

Line 1112: fnd_log.level_procedure,

1108: END IF;
1109: END IF;
1110: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
1111: fnd_log.string (
1112: fnd_log.level_procedure,
1113: g_module_head || l_routine || '.end',
1114: l_routine
1115: );
1116: END IF;

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

1166: rec_usec_submitted cur_usec_submitted%ROWTYPE;
1167: rec_suao_final_man_ovr cur_suao_final_man_ovr%ROWTYPE;
1168: --
1169: BEGIN
1170: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
1171: fnd_log.string (
1172: fnd_log.level_procedure,
1173: g_module_head || l_routine || '.begin',
1174: 'Params: p_person_id=>' || p_person_id || ';' ||

Line 1171: fnd_log.string (

1167: rec_suao_final_man_ovr cur_suao_final_man_ovr%ROWTYPE;
1168: --
1169: BEGIN
1170: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
1171: fnd_log.string (
1172: fnd_log.level_procedure,
1173: g_module_head || l_routine || '.begin',
1174: 'Params: p_person_id=>' || p_person_id || ';' ||
1175: 'p_course_cd=>' || p_course_cd || ';' ||

Line 1172: fnd_log.level_procedure,

1168: --
1169: BEGIN
1170: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
1171: fnd_log.string (
1172: fnd_log.level_procedure,
1173: g_module_head || l_routine || '.begin',
1174: 'Params: p_person_id=>' || p_person_id || ';' ||
1175: 'p_course_cd=>' || p_course_cd || ';' ||
1176: 'p_uoo_id=>' || p_uoo_id || ';' ||

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

1201: --
1202: -- As the Unit Section is submitted Mark/Grade need not be derived so
1203: -- return the passed values as Mark/Grade
1204: --
1205: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1206: fnd_log.string (
1207: fnd_log.level_statement,
1208: g_module_head || l_routine || '.usec_submitted_mark_not_derived',
1209: 'Returning the passed mark as Unit Section is submitted=>' || p_mark

Line 1206: fnd_log.string (

1202: -- As the Unit Section is submitted Mark/Grade need not be derived so
1203: -- return the passed values as Mark/Grade
1204: --
1205: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1206: fnd_log.string (
1207: fnd_log.level_statement,
1208: g_module_head || l_routine || '.usec_submitted_mark_not_derived',
1209: 'Returning the passed mark as Unit Section is submitted=>' || p_mark
1210: );

Line 1207: fnd_log.level_statement,

1203: -- return the passed values as Mark/Grade
1204: --
1205: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1206: fnd_log.string (
1207: fnd_log.level_statement,
1208: g_module_head || l_routine || '.usec_submitted_mark_not_derived',
1209: 'Returning the passed mark as Unit Section is submitted=>' || p_mark
1210: );
1211: END IF;

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

1213: ELSE
1214: --
1215: -- Mark/Grade already derived for the Student so return Mark without recomputing
1216: --
1217: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1218: fnd_log.string (
1219: fnd_log.level_statement,
1220: g_module_head || l_routine || '.mark_already_derived_usec_not_submitted',
1221: 'Returning the already derived mark as Unit Section is not Submitted=>' ||

Line 1218: fnd_log.string (

1214: --
1215: -- Mark/Grade already derived for the Student so return Mark without recomputing
1216: --
1217: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1218: fnd_log.string (
1219: fnd_log.level_statement,
1220: g_module_head || l_routine || '.mark_already_derived_usec_not_submitted',
1221: 'Returning the already derived mark as Unit Section is not Submitted=>' ||
1222: SUBSTR (g_mark_grade, 1, INSTR (g_mark_grade, '::') - 1)

Line 1219: fnd_log.level_statement,

1215: -- Mark/Grade already derived for the Student so return Mark without recomputing
1216: --
1217: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1218: fnd_log.string (
1219: fnd_log.level_statement,
1220: g_module_head || l_routine || '.mark_already_derived_usec_not_submitted',
1221: 'Returning the already derived mark as Unit Section is not Submitted=>' ||
1222: SUBSTR (g_mark_grade, 1, INSTR (g_mark_grade, '::') - 1)
1223: );

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

1241: -- Return back the passed Mark/Grade as Unit Section is Submitted
1242: --
1243: g_mark_grade := p_mark || '::' || p_grade;
1244: --
1245: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1246: fnd_log.string (
1247: fnd_log.level_statement,
1248: g_module_head || l_routine || '.mark_not_derived_as_usec_submitted',
1249: 'Returning back the passed mark as Unit Section is Submitted=>' ||

Line 1246: fnd_log.string (

1242: --
1243: g_mark_grade := p_mark || '::' || p_grade;
1244: --
1245: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1246: fnd_log.string (
1247: fnd_log.level_statement,
1248: g_module_head || l_routine || '.mark_not_derived_as_usec_submitted',
1249: 'Returning back the passed mark as Unit Section is Submitted=>' ||
1250: SUBSTR (g_mark_grade, 1, INSTR (g_mark_grade, '::') - 1)

Line 1247: fnd_log.level_statement,

1243: g_mark_grade := p_mark || '::' || p_grade;
1244: --
1245: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1246: fnd_log.string (
1247: fnd_log.level_statement,
1248: g_module_head || l_routine || '.mark_not_derived_as_usec_submitted',
1249: 'Returning back the passed mark as Unit Section is Submitted=>' ||
1250: SUBSTR (g_mark_grade, 1, INSTR (g_mark_grade, '::') - 1)
1251: );

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

1266: -- Return back the passed Mark/Grade as Student Unit Attempt Outcome
1267: -- is 'Finalized' or 'Manually Overridden'
1268: --
1269: g_mark_grade := p_mark || '::' || p_grade;
1270: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1271: fnd_log.string (
1272: fnd_log.level_statement,
1273: g_module_head || l_routine || '.mark_not_derived_as_suao_fin_man_ovr',
1274: 'Returning back the passed mark as Student Unit Attempt Outcome is ' ||

Line 1271: fnd_log.string (

1267: -- is 'Finalized' or 'Manually Overridden'
1268: --
1269: g_mark_grade := p_mark || '::' || p_grade;
1270: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1271: fnd_log.string (
1272: fnd_log.level_statement,
1273: g_module_head || l_routine || '.mark_not_derived_as_suao_fin_man_ovr',
1274: 'Returning back the passed mark as Student Unit Attempt Outcome is ' ||
1275: 'Finalized or Manually Overridden=>' ||

Line 1272: fnd_log.level_statement,

1268: --
1269: g_mark_grade := p_mark || '::' || p_grade;
1270: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1271: fnd_log.string (
1272: fnd_log.level_statement,
1273: g_module_head || l_routine || '.mark_not_derived_as_suao_fin_man_ovr',
1274: 'Returning back the passed mark as Student Unit Attempt Outcome is ' ||
1275: 'Finalized or Manually Overridden=>' ||
1276: SUBSTR (g_mark_grade, 1, INSTR (g_mark_grade, '::') - 1)

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

1285: p_course_cd,
1286: p_uoo_id,
1287: p_grading_period_cd
1288: );
1289: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1290: fnd_log.string (
1291: fnd_log.level_statement,
1292: g_module_head || l_routine || '.derived_mark',
1293: 'Derived Mark=>' ||

Line 1290: fnd_log.string (

1286: p_uoo_id,
1287: p_grading_period_cd
1288: );
1289: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1290: fnd_log.string (
1291: fnd_log.level_statement,
1292: g_module_head || l_routine || '.derived_mark',
1293: 'Derived Mark=>' ||
1294: SUBSTR (g_mark_grade, 1, INSTR (g_mark_grade, '::') - 1)

Line 1291: fnd_log.level_statement,

1287: p_grading_period_cd
1288: );
1289: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1290: fnd_log.string (
1291: fnd_log.level_statement,
1292: g_module_head || l_routine || '.derived_mark',
1293: 'Derived Mark=>' ||
1294: SUBSTR (g_mark_grade, 1, INSTR (g_mark_grade, '::') - 1)
1295: );

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

1297: END IF;
1298: END IF;
1299: END IF;
1300: --
1301: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
1302: fnd_log.string (
1303: fnd_log.level_procedure,
1304: g_module_head || l_routine || '.end',
1305: l_routine

Line 1302: fnd_log.string (

1298: END IF;
1299: END IF;
1300: --
1301: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
1302: fnd_log.string (
1303: fnd_log.level_procedure,
1304: g_module_head || l_routine || '.end',
1305: l_routine
1306: );

Line 1303: fnd_log.level_procedure,

1299: END IF;
1300: --
1301: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
1302: fnd_log.string (
1303: fnd_log.level_procedure,
1304: g_module_head || l_routine || '.end',
1305: l_routine
1306: );
1307: END IF;

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

1321: p_message_name OUT NOCOPY VARCHAR2
1322: ) RETURN VARCHAR2 IS
1323: l_routine VARCHAR2(30) := 'derive_suao_grade_from_suaio';
1324: BEGIN
1325: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
1326: fnd_log.string (
1327: fnd_log.level_procedure,
1328: g_module_head || l_routine || '.begin',
1329: 'Params: p_person_id=>' || p_person_id || ';' ||

Line 1326: fnd_log.string (

1322: ) RETURN VARCHAR2 IS
1323: l_routine VARCHAR2(30) := 'derive_suao_grade_from_suaio';
1324: BEGIN
1325: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
1326: fnd_log.string (
1327: fnd_log.level_procedure,
1328: g_module_head || l_routine || '.begin',
1329: 'Params: p_person_id=>' || p_person_id || ';' ||
1330: 'p_course_cd=>' || p_course_cd || ';' ||

Line 1327: fnd_log.level_procedure,

1323: l_routine VARCHAR2(30) := 'derive_suao_grade_from_suaio';
1324: BEGIN
1325: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
1326: fnd_log.string (
1327: fnd_log.level_procedure,
1328: g_module_head || l_routine || '.begin',
1329: 'Params: p_person_id=>' || p_person_id || ';' ||
1330: 'p_course_cd=>' || p_course_cd || ';' ||
1331: 'p_uoo_id=>' || p_uoo_id || ';' ||

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

1351: g_grading_period_cd = p_grading_period_cd THEN
1352: --
1353: -- Mark/Grade already derived for the Student so return Grade without recomputing
1354: --
1355: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1356: fnd_log.string (
1357: fnd_log.level_statement,
1358: g_module_head || l_routine || '.grade_already_derived',
1359: 'Returning the already derived grade=>' ||

Line 1356: fnd_log.string (

1352: --
1353: -- Mark/Grade already derived for the Student so return Grade without recomputing
1354: --
1355: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1356: fnd_log.string (
1357: fnd_log.level_statement,
1358: g_module_head || l_routine || '.grade_already_derived',
1359: 'Returning the already derived grade=>' ||
1360: SUBSTR (g_mark_grade, INSTR (g_mark_grade, '::') + 2) ||

Line 1357: fnd_log.level_statement,

1353: -- Mark/Grade already derived for the Student so return Grade without recomputing
1354: --
1355: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1356: fnd_log.string (
1357: fnd_log.level_statement,
1358: g_module_head || l_routine || '.grade_already_derived',
1359: 'Returning the already derived grade=>' ||
1360: SUBSTR (g_mark_grade, INSTR (g_mark_grade, '::') + 2) ||
1361: '; with error message ' || SUBSTR (g_mark_grade, INSTR (g_mark_grade, ';;') + 2)

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

1370: p_course_cd,
1371: p_uoo_id,
1372: p_grading_period_cd
1373: );
1374: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1375: fnd_log.string (
1376: fnd_log.level_statement,
1377: g_module_head || l_routine || '.derived_grade',
1378: 'Derived Grade=>' ||

Line 1375: fnd_log.string (

1371: p_uoo_id,
1372: p_grading_period_cd
1373: );
1374: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1375: fnd_log.string (
1376: fnd_log.level_statement,
1377: g_module_head || l_routine || '.derived_grade',
1378: 'Derived Grade=>' ||
1379: SUBSTR (g_mark_grade, INSTR (g_mark_grade, '::') + 2) ||

Line 1376: fnd_log.level_statement,

1372: p_grading_period_cd
1373: );
1374: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1375: fnd_log.string (
1376: fnd_log.level_statement,
1377: g_module_head || l_routine || '.derived_grade',
1378: 'Derived Grade=>' ||
1379: SUBSTR (g_mark_grade, INSTR (g_mark_grade, '::') + 2) ||
1380: '; with error message ' || SUBSTR (g_mark_grade, INSTR (g_mark_grade, ';;') + 2)

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

1383: END IF;
1384: IF (INSTR (g_mark_grade, ';;') > 0) THEN
1385: p_message_name := SUBSTR (g_mark_grade, INSTR (g_mark_grade, ';;') + 2);
1386: END IF;
1387: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
1388: fnd_log.string (
1389: fnd_log.level_procedure,
1390: g_module_head || l_routine || '.end',
1391: l_routine

Line 1388: fnd_log.string (

1384: IF (INSTR (g_mark_grade, ';;') > 0) THEN
1385: p_message_name := SUBSTR (g_mark_grade, INSTR (g_mark_grade, ';;') + 2);
1386: END IF;
1387: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
1388: fnd_log.string (
1389: fnd_log.level_procedure,
1390: g_module_head || l_routine || '.end',
1391: l_routine
1392: );

Line 1389: fnd_log.level_procedure,

1385: p_message_name := SUBSTR (g_mark_grade, INSTR (g_mark_grade, ';;') + 2);
1386: END IF;
1387: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
1388: fnd_log.string (
1389: fnd_log.level_procedure,
1390: g_module_head || l_routine || '.end',
1391: l_routine
1392: );
1393: END IF;

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

1408: p_reset_mark_grade IN VARCHAR2 DEFAULT 'N'
1409: ) RETURN VARCHAR2 IS
1410: l_routine VARCHAR2(30) := 'derive_suao_grade_from_suaio';
1411: BEGIN
1412: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
1413: fnd_log.string (
1414: fnd_log.level_procedure,
1415: g_module_head || l_routine || '.begin',
1416: 'Params: p_person_id=>' || p_person_id || ';' ||

Line 1413: fnd_log.string (

1409: ) RETURN VARCHAR2 IS
1410: l_routine VARCHAR2(30) := 'derive_suao_grade_from_suaio';
1411: BEGIN
1412: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
1413: fnd_log.string (
1414: fnd_log.level_procedure,
1415: g_module_head || l_routine || '.begin',
1416: 'Params: p_person_id=>' || p_person_id || ';' ||
1417: 'p_course_cd=>' || p_course_cd || ';' ||

Line 1414: fnd_log.level_procedure,

1410: l_routine VARCHAR2(30) := 'derive_suao_grade_from_suaio';
1411: BEGIN
1412: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
1413: fnd_log.string (
1414: fnd_log.level_procedure,
1415: g_module_head || l_routine || '.begin',
1416: 'Params: p_person_id=>' || p_person_id || ';' ||
1417: 'p_course_cd=>' || p_course_cd || ';' ||
1418: 'p_uoo_id=>' || p_uoo_id || ';' ||

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

1438: g_grading_period_cd = p_grading_period_cd THEN
1439: --
1440: -- Mark/Grade already derived for the Student so return Grade without recomputing
1441: --
1442: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1443: fnd_log.string (
1444: fnd_log.level_statement,
1445: g_module_head || l_routine || '.grade_already_derived',
1446: 'Returning the already derived grade=>' ||

Line 1443: fnd_log.string (

1439: --
1440: -- Mark/Grade already derived for the Student so return Grade without recomputing
1441: --
1442: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1443: fnd_log.string (
1444: fnd_log.level_statement,
1445: g_module_head || l_routine || '.grade_already_derived',
1446: 'Returning the already derived grade=>' ||
1447: SUBSTR (g_mark_grade, INSTR (g_mark_grade, '::') + 2)

Line 1444: fnd_log.level_statement,

1440: -- Mark/Grade already derived for the Student so return Grade without recomputing
1441: --
1442: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1443: fnd_log.string (
1444: fnd_log.level_statement,
1445: g_module_head || l_routine || '.grade_already_derived',
1446: 'Returning the already derived grade=>' ||
1447: SUBSTR (g_mark_grade, INSTR (g_mark_grade, '::') + 2)
1448: );

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

1456: p_course_cd,
1457: p_uoo_id,
1458: p_grading_period_cd
1459: );
1460: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1461: fnd_log.string (
1462: fnd_log.level_statement,
1463: g_module_head || l_routine || '.derived_grade',
1464: 'Derived Grade=>' ||

Line 1461: fnd_log.string (

1457: p_uoo_id,
1458: p_grading_period_cd
1459: );
1460: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1461: fnd_log.string (
1462: fnd_log.level_statement,
1463: g_module_head || l_routine || '.derived_grade',
1464: 'Derived Grade=>' ||
1465: SUBSTR (g_mark_grade, INSTR (g_mark_grade, '::') + 2)

Line 1462: fnd_log.level_statement,

1458: p_grading_period_cd
1459: );
1460: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1461: fnd_log.string (
1462: fnd_log.level_statement,
1463: g_module_head || l_routine || '.derived_grade',
1464: 'Derived Grade=>' ||
1465: SUBSTR (g_mark_grade, INSTR (g_mark_grade, '::') + 2)
1466: );

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

1465: SUBSTR (g_mark_grade, INSTR (g_mark_grade, '::') + 2)
1466: );
1467: END IF;
1468: END IF;
1469: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
1470: fnd_log.string (
1471: fnd_log.level_procedure,
1472: g_module_head || l_routine || '.end',
1473: l_routine

Line 1470: fnd_log.string (

1466: );
1467: END IF;
1468: END IF;
1469: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
1470: fnd_log.string (
1471: fnd_log.level_procedure,
1472: g_module_head || l_routine || '.end',
1473: l_routine
1474: );

Line 1471: fnd_log.level_procedure,

1467: END IF;
1468: END IF;
1469: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
1470: fnd_log.string (
1471: fnd_log.level_procedure,
1472: g_module_head || l_routine || '.end',
1473: l_routine
1474: );
1475: END IF;

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

1529: rec_usec_submitted cur_usec_submitted%ROWTYPE;
1530: rec_suao_final_man_ovr cur_suao_final_man_ovr%ROWTYPE;
1531: --
1532: BEGIN
1533: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
1534: fnd_log.string (
1535: fnd_log.level_procedure,
1536: g_module_head || l_routine || '.begin',
1537: 'Params: p_person_id=>' || p_person_id || ';' ||

Line 1534: fnd_log.string (

1530: rec_suao_final_man_ovr cur_suao_final_man_ovr%ROWTYPE;
1531: --
1532: BEGIN
1533: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
1534: fnd_log.string (
1535: fnd_log.level_procedure,
1536: g_module_head || l_routine || '.begin',
1537: 'Params: p_person_id=>' || p_person_id || ';' ||
1538: 'p_course_cd=>' || p_course_cd || ';' ||

Line 1535: fnd_log.level_procedure,

1531: --
1532: BEGIN
1533: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
1534: fnd_log.string (
1535: fnd_log.level_procedure,
1536: g_module_head || l_routine || '.begin',
1537: 'Params: p_person_id=>' || p_person_id || ';' ||
1538: 'p_course_cd=>' || p_course_cd || ';' ||
1539: 'p_uoo_id=>' || p_uoo_id || ';' ||

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

1564: --
1565: -- As the Unit Section is submitted Mark/Grade need not be derived so
1566: -- return the passed values as Mark/Grade
1567: --
1568: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1569: fnd_log.string (
1570: fnd_log.level_statement,
1571: g_module_head || l_routine || '.usec_submitted_grade_not_derived',
1572: 'Returning the passed grade as Unit Section is submitted=>' || p_grade

Line 1569: fnd_log.string (

1565: -- As the Unit Section is submitted Mark/Grade need not be derived so
1566: -- return the passed values as Mark/Grade
1567: --
1568: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1569: fnd_log.string (
1570: fnd_log.level_statement,
1571: g_module_head || l_routine || '.usec_submitted_grade_not_derived',
1572: 'Returning the passed grade as Unit Section is submitted=>' || p_grade
1573: );

Line 1570: fnd_log.level_statement,

1566: -- return the passed values as Mark/Grade
1567: --
1568: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1569: fnd_log.string (
1570: fnd_log.level_statement,
1571: g_module_head || l_routine || '.usec_submitted_grade_not_derived',
1572: 'Returning the passed grade as Unit Section is submitted=>' || p_grade
1573: );
1574: END IF;

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

1576: ELSE
1577: --
1578: -- Mark/Grade already derived for the Student so return Grade without recomputing
1579: --
1580: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1581: fnd_log.string (
1582: fnd_log.level_statement,
1583: g_module_head || l_routine || '.grade_already_derived_usec_not_submitted',
1584: 'Returning the already derived grade as Unit Section is not Submitted=>' ||

Line 1581: fnd_log.string (

1577: --
1578: -- Mark/Grade already derived for the Student so return Grade without recomputing
1579: --
1580: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1581: fnd_log.string (
1582: fnd_log.level_statement,
1583: g_module_head || l_routine || '.grade_already_derived_usec_not_submitted',
1584: 'Returning the already derived grade as Unit Section is not Submitted=>' ||
1585: SUBSTR (g_mark_grade, INSTR (g_mark_grade, '::') + 2)

Line 1582: fnd_log.level_statement,

1578: -- Mark/Grade already derived for the Student so return Grade without recomputing
1579: --
1580: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1581: fnd_log.string (
1582: fnd_log.level_statement,
1583: g_module_head || l_routine || '.grade_already_derived_usec_not_submitted',
1584: 'Returning the already derived grade as Unit Section is not Submitted=>' ||
1585: SUBSTR (g_mark_grade, INSTR (g_mark_grade, '::') + 2)
1586: );

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

1604: -- Return back the passed Mark/Grade as Unit Section is Submitted
1605: --
1606: g_mark_grade := p_mark || '::' || p_grade;
1607: --
1608: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1609: fnd_log.string (
1610: fnd_log.level_statement,
1611: g_module_head || l_routine || '.grade_not_derived_as_usec_submitted',
1612: 'Returning back the passed grade as Unit Section is Submitted=>' ||

Line 1609: fnd_log.string (

1605: --
1606: g_mark_grade := p_mark || '::' || p_grade;
1607: --
1608: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1609: fnd_log.string (
1610: fnd_log.level_statement,
1611: g_module_head || l_routine || '.grade_not_derived_as_usec_submitted',
1612: 'Returning back the passed grade as Unit Section is Submitted=>' ||
1613: SUBSTR (g_mark_grade, INSTR (g_mark_grade, '::') + 2)

Line 1610: fnd_log.level_statement,

1606: g_mark_grade := p_mark || '::' || p_grade;
1607: --
1608: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1609: fnd_log.string (
1610: fnd_log.level_statement,
1611: g_module_head || l_routine || '.grade_not_derived_as_usec_submitted',
1612: 'Returning back the passed grade as Unit Section is Submitted=>' ||
1613: SUBSTR (g_mark_grade, INSTR (g_mark_grade, '::') + 2)
1614: );

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

1629: -- Return back the passed Mark/Grade as Student Unit Attempt Outcome
1630: -- is 'Finalized' or 'Manually Overridden'
1631: --
1632: g_mark_grade := p_mark || '::' || p_grade;
1633: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1634: fnd_log.string (
1635: fnd_log.level_statement,
1636: g_module_head || l_routine || '.grade_not_derived_as_suao_fin_man_ovr',
1637: 'Returning back the passed grade as Student Unit Attempt Outcome is ' ||

Line 1634: fnd_log.string (

1630: -- is 'Finalized' or 'Manually Overridden'
1631: --
1632: g_mark_grade := p_mark || '::' || p_grade;
1633: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1634: fnd_log.string (
1635: fnd_log.level_statement,
1636: g_module_head || l_routine || '.grade_not_derived_as_suao_fin_man_ovr',
1637: 'Returning back the passed grade as Student Unit Attempt Outcome is ' ||
1638: 'Finalized or Manually Overridden=>' ||

Line 1635: fnd_log.level_statement,

1631: --
1632: g_mark_grade := p_mark || '::' || p_grade;
1633: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1634: fnd_log.string (
1635: fnd_log.level_statement,
1636: g_module_head || l_routine || '.grade_not_derived_as_suao_fin_man_ovr',
1637: 'Returning back the passed grade as Student Unit Attempt Outcome is ' ||
1638: 'Finalized or Manually Overridden=>' ||
1639: SUBSTR (g_mark_grade, INSTR (g_mark_grade, '::') + 2)

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

1648: p_course_cd,
1649: p_uoo_id,
1650: p_grading_period_cd
1651: );
1652: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1653: fnd_log.string (
1654: fnd_log.level_statement,
1655: g_module_head || l_routine || '.derived_grade',
1656: 'Derived Grade=>' ||

Line 1653: fnd_log.string (

1649: p_uoo_id,
1650: p_grading_period_cd
1651: );
1652: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1653: fnd_log.string (
1654: fnd_log.level_statement,
1655: g_module_head || l_routine || '.derived_grade',
1656: 'Derived Grade=>' ||
1657: SUBSTR (g_mark_grade, INSTR (g_mark_grade, '::') + 2)

Line 1654: fnd_log.level_statement,

1650: p_grading_period_cd
1651: );
1652: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1653: fnd_log.string (
1654: fnd_log.level_statement,
1655: g_module_head || l_routine || '.derived_grade',
1656: 'Derived Grade=>' ||
1657: SUBSTR (g_mark_grade, INSTR (g_mark_grade, '::') + 2)
1658: );

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

1660: END IF;
1661: END IF;
1662: END IF;
1663: --
1664: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
1665: fnd_log.string (
1666: fnd_log.level_procedure,
1667: g_module_head || l_routine || '.end',
1668: l_routine

Line 1665: fnd_log.string (

1661: END IF;
1662: END IF;
1663: --
1664: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
1665: fnd_log.string (
1666: fnd_log.level_procedure,
1667: g_module_head || l_routine || '.end',
1668: l_routine
1669: );

Line 1666: fnd_log.level_procedure,

1662: END IF;
1663: --
1664: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
1665: fnd_log.string (
1666: fnd_log.level_procedure,
1667: g_module_head || l_routine || '.end',
1668: l_routine
1669: );
1670: END IF;

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

1733: lnrepeat NUMBER := 0;
1734: l_routine CONSTANT VARCHAR2(30) := 'get_assessment_status';
1735: --
1736: BEGIN
1737: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
1738: fnd_log.string (
1739: fnd_log.level_procedure,
1740: g_module_head || l_routine || '.begin',
1741: 'Params: p_person_id=>' || p_person_id || ';' ||

Line 1738: fnd_log.string (

1734: l_routine CONSTANT VARCHAR2(30) := 'get_assessment_status';
1735: --
1736: BEGIN
1737: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
1738: fnd_log.string (
1739: fnd_log.level_procedure,
1740: g_module_head || l_routine || '.begin',
1741: 'Params: p_person_id=>' || p_person_id || ';' ||
1742: 'p_course_cd=>' || p_course_cd || ';' ||

Line 1739: fnd_log.level_procedure,

1735: --
1736: BEGIN
1737: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
1738: fnd_log.string (
1739: fnd_log.level_procedure,
1740: g_module_head || l_routine || '.begin',
1741: 'Params: p_person_id=>' || p_person_id || ';' ||
1742: 'p_course_cd=>' || p_course_cd || ';' ||
1743: 'p_uoo_id=>' || p_uoo_id || ';' ||

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

1751: IF (l_st_dt > rec_suao.ci_start_dt) THEN
1752: lnrepeat := lnrepeat + 1;
1753: END IF;
1754: END LOOP;
1755: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
1756: fnd_log.string (
1757: fnd_log.level_procedure,
1758: g_module_head || l_routine || '.end',
1759: 'Total number of repeats lnrepeat=>' || lnrepeat

Line 1756: fnd_log.string (

1752: lnrepeat := lnrepeat + 1;
1753: END IF;
1754: END LOOP;
1755: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
1756: fnd_log.string (
1757: fnd_log.level_procedure,
1758: g_module_head || l_routine || '.end',
1759: 'Total number of repeats lnrepeat=>' || lnrepeat
1760: );

Line 1757: fnd_log.level_procedure,

1753: END IF;
1754: END LOOP;
1755: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
1756: fnd_log.string (
1757: fnd_log.level_procedure,
1758: g_module_head || l_routine || '.end',
1759: 'Total number of repeats lnrepeat=>' || lnrepeat
1760: );
1761: END IF;