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_CP_GPA dependencies on FND_API

Line 37: mismatch by adding default FND_API.G_TRUE FOR get_sua_cp

33: Removed all the default values from the program
34: units' parameters and replaced DEFAULT with := in the
35: declaration sections of the program units.
36: prchandr 16-JUL-2002 Bug No. 2463175 Removed package and package body
37: mismatch by adding default FND_API.G_TRUE FOR get_sua_cp
38: nalkumar 05-Dec-2002 Modified get_stat_dtls procedure as per the Bug# 2685741
39: jhanda 19-Dec-2002 Bug Fix 2707516 wrong GPA being calculated, changes
40: specified in Bug Description in Bug DB.
41: kdande 26-Jul-2004 Changed the of get_sua_stats to return proper value for

Line 254: IF fnd_api.to_boolean (NVL (p_init_msg_list, fnd_api.g_true))

250: l_message VARCHAR2 (1000);
251: BEGIN
252: l_include := 'Y';
253: -- Initialize message list if p_init_msg_list is set to TRUE.
254: IF fnd_api.to_boolean (NVL (p_init_msg_list, fnd_api.g_true))
255: THEN
256: fnd_msg_pub.initialize;
257: END IF;
258:

Line 267: RAISE fnd_api.g_exc_error;

263: THEN
264: l_message := 'IGS_GE_INSUFFICIENT_PARAM_VAL';
265: fnd_message.set_name ('IGS', l_message);
266: fnd_msg_pub.ADD;
267: RAISE fnd_api.g_exc_error;
268: END IF;
269:
270: -- If the Organizational Unit is not null then statistic type is
271: -- defined at Organizational level. Check if any unit reference

Line 355: p_return_status := fnd_api.g_ret_sts_success;

351: CLOSE c_inst_setup;
352: END IF;
353:
354: -- Initialize API return status to success.
355: p_return_status := fnd_api.g_ret_sts_success;
356: -- Standard call to get message count and if count is 1, get message info
357: fnd_msg_pub.count_and_get (
358: p_encoded=> fnd_api.g_false,
359: p_count=> p_msg_count,

Line 358: p_encoded=> fnd_api.g_false,

354: -- Initialize API return status to success.
355: p_return_status := fnd_api.g_ret_sts_success;
356: -- Standard call to get message count and if count is 1, get message info
357: fnd_msg_pub.count_and_get (
358: p_encoded=> fnd_api.g_false,
359: p_count=> p_msg_count,
360: p_data=> p_msg_data
361: );
362: RETURN l_include;

Line 364: WHEN fnd_api.g_exc_error

360: p_data=> p_msg_data
361: );
362: RETURN l_include;
363: EXCEPTION
364: WHEN fnd_api.g_exc_error
365: THEN
366: p_return_status := fnd_api.g_ret_sts_error;
367: fnd_msg_pub.count_and_get (
368: p_encoded=> fnd_api.g_false,

Line 366: p_return_status := fnd_api.g_ret_sts_error;

362: RETURN l_include;
363: EXCEPTION
364: WHEN fnd_api.g_exc_error
365: THEN
366: p_return_status := fnd_api.g_ret_sts_error;
367: fnd_msg_pub.count_and_get (
368: p_encoded=> fnd_api.g_false,
369: p_count=> p_msg_count,
370: p_data=> p_msg_data

Line 368: p_encoded=> fnd_api.g_false,

364: WHEN fnd_api.g_exc_error
365: THEN
366: p_return_status := fnd_api.g_ret_sts_error;
367: fnd_msg_pub.count_and_get (
368: p_encoded=> fnd_api.g_false,
369: p_count=> p_msg_count,
370: p_data=> p_msg_data
371: );
372: RETURN NULL;

Line 373: WHEN fnd_api.g_exc_unexpected_error

369: p_count=> p_msg_count,
370: p_data=> p_msg_data
371: );
372: RETURN NULL;
373: WHEN fnd_api.g_exc_unexpected_error
374: THEN
375: p_return_status := fnd_api.g_ret_sts_unexp_error;
376: fnd_msg_pub.count_and_get (
377: p_encoded=> fnd_api.g_false,

Line 375: p_return_status := fnd_api.g_ret_sts_unexp_error;

371: );
372: RETURN NULL;
373: WHEN fnd_api.g_exc_unexpected_error
374: THEN
375: p_return_status := fnd_api.g_ret_sts_unexp_error;
376: fnd_msg_pub.count_and_get (
377: p_encoded=> fnd_api.g_false,
378: p_count=> p_msg_count,
379: p_data=> p_msg_data

Line 377: p_encoded=> fnd_api.g_false,

373: WHEN fnd_api.g_exc_unexpected_error
374: THEN
375: p_return_status := fnd_api.g_ret_sts_unexp_error;
376: fnd_msg_pub.count_and_get (
377: p_encoded=> fnd_api.g_false,
378: p_count=> p_msg_count,
379: p_data=> p_msg_data
380: );
381: RETURN NULL;

Line 384: p_return_status := fnd_api.g_ret_sts_unexp_error;

380: );
381: RETURN NULL;
382: WHEN OTHERS
383: THEN
384: p_return_status := fnd_api.g_ret_sts_unexp_error;
385: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
386: fnd_message.set_token ('NAME', 'chk_av_unit_ref_cd: '
387: || SQLERRM);
388: fnd_msg_pub.ADD;

Line 390: p_encoded=> fnd_api.g_false,

386: fnd_message.set_token ('NAME', 'chk_av_unit_ref_cd: '
387: || SQLERRM);
388: fnd_msg_pub.ADD;
389: fnd_msg_pub.count_and_get (
390: p_encoded=> fnd_api.g_false,
391: p_count=> p_msg_count,
392: p_data=> p_msg_data
393: );
394: RETURN NULL;

Line 489: IF fnd_api.to_boolean(NVL(p_init_msg_list, fnd_api.g_true)) THEN

485: BEGIN
486: --
487: -- Initialize message list if p_init_msg_list is set to TRUE.
488: --
489: IF fnd_api.to_boolean(NVL(p_init_msg_list, fnd_api.g_true)) THEN
490: fnd_msg_pub.initialize;
491: END IF;
492:
493: --

Line 502: RAISE fnd_api.g_exc_error;

498: OR p_course_cd IS NULL) THEN
499: l_message := 'IGS_GE_INSUFFICIENT_PARAM_VAL';
500: fnd_message.set_name('IGS', l_message);
501: fnd_msg_pub.ADD;
502: RAISE fnd_api.g_exc_error;
503: END IF;
504:
505: --
506: -- Check whether the system stat is not within the given values

Line 515: RAISE fnd_api.g_exc_error;

511: AND p_system_stat NOT IN ('STANDARD', 'FIN_AID', 'PROGRESSION')) THEN
512: l_message := 'IGS_PR_SYSTEM_STAT_INCORRECT';
513: fnd_message.set_name('IGS', l_message);
514: fnd_msg_pub.ADD;
515: RAISE fnd_api.g_exc_error;
516: END IF;
517:
518: --
519: -- ## Check if there records at Organization Level.

Line 552: RAISE fnd_api.g_exc_error;

548: --
549: CLOSE c_inst_stat;
550: fnd_message.set_name('IGS', 'IGS_PR_INVALID_STAT_TYPE');
551: fnd_msg_pub.ADD;
552: RAISE fnd_api.g_exc_error;
553: --
554: -- End of new code added as per Bug# 2685741
555: --
556: ELSE

Line 570: p_return_status := fnd_api.g_ret_sts_success;

566: END IF;
567:
568: CLOSE c_org_stat;
569: -- Initialize API return status to success.
570: p_return_status := fnd_api.g_ret_sts_success;
571: -- Standard call to get message count and if count is 1, get message info
572: fnd_msg_pub.count_and_get(
573: p_encoded => fnd_api.g_false,
574: p_count => p_msg_count,

Line 573: p_encoded => fnd_api.g_false,

569: -- Initialize API return status to success.
570: p_return_status := fnd_api.g_ret_sts_success;
571: -- Standard call to get message count and if count is 1, get message info
572: fnd_msg_pub.count_and_get(
573: p_encoded => fnd_api.g_false,
574: p_count => p_msg_count,
575: p_data => p_msg_data);
576:
577: EXCEPTION

Line 578: WHEN fnd_api.g_exc_error THEN

574: p_count => p_msg_count,
575: p_data => p_msg_data);
576:
577: EXCEPTION
578: WHEN fnd_api.g_exc_error THEN
579: p_return_status := fnd_api.g_ret_sts_error;
580: fnd_msg_pub.count_and_get(
581: p_encoded => fnd_api.g_false,
582: p_count => p_msg_count,

Line 579: p_return_status := fnd_api.g_ret_sts_error;

575: p_data => p_msg_data);
576:
577: EXCEPTION
578: WHEN fnd_api.g_exc_error THEN
579: p_return_status := fnd_api.g_ret_sts_error;
580: fnd_msg_pub.count_and_get(
581: p_encoded => fnd_api.g_false,
582: p_count => p_msg_count,
583: p_data => p_msg_data);

Line 581: p_encoded => fnd_api.g_false,

577: EXCEPTION
578: WHEN fnd_api.g_exc_error THEN
579: p_return_status := fnd_api.g_ret_sts_error;
580: fnd_msg_pub.count_and_get(
581: p_encoded => fnd_api.g_false,
582: p_count => p_msg_count,
583: p_data => p_msg_data);
584: WHEN fnd_api.g_exc_unexpected_error THEN
585: p_return_status := fnd_api.g_ret_sts_unexp_error;

Line 584: WHEN fnd_api.g_exc_unexpected_error THEN

580: fnd_msg_pub.count_and_get(
581: p_encoded => fnd_api.g_false,
582: p_count => p_msg_count,
583: p_data => p_msg_data);
584: WHEN fnd_api.g_exc_unexpected_error THEN
585: p_return_status := fnd_api.g_ret_sts_unexp_error;
586: fnd_msg_pub.count_and_get(
587: p_encoded => fnd_api.g_false,
588: p_count => p_msg_count,

Line 585: p_return_status := fnd_api.g_ret_sts_unexp_error;

581: p_encoded => fnd_api.g_false,
582: p_count => p_msg_count,
583: p_data => p_msg_data);
584: WHEN fnd_api.g_exc_unexpected_error THEN
585: p_return_status := fnd_api.g_ret_sts_unexp_error;
586: fnd_msg_pub.count_and_get(
587: p_encoded => fnd_api.g_false,
588: p_count => p_msg_count,
589: p_data => p_msg_data);

Line 587: p_encoded => fnd_api.g_false,

583: p_data => p_msg_data);
584: WHEN fnd_api.g_exc_unexpected_error THEN
585: p_return_status := fnd_api.g_ret_sts_unexp_error;
586: fnd_msg_pub.count_and_get(
587: p_encoded => fnd_api.g_false,
588: p_count => p_msg_count,
589: p_data => p_msg_data);
590: WHEN OTHERS THEN
591: p_return_status := fnd_api.g_ret_sts_unexp_error;

Line 591: p_return_status := fnd_api.g_ret_sts_unexp_error;

587: p_encoded => fnd_api.g_false,
588: p_count => p_msg_count,
589: p_data => p_msg_data);
590: WHEN OTHERS THEN
591: p_return_status := fnd_api.g_ret_sts_unexp_error;
592: fnd_message.set_name('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
593: fnd_message.set_token('NAME', 'GET_STAT_DTLS: ' || SQLERRM);
594: fnd_msg_pub.ADD;
595: fnd_msg_pub.count_and_get(

Line 596: p_encoded => fnd_api.g_false,

592: fnd_message.set_name('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
593: fnd_message.set_token('NAME', 'GET_STAT_DTLS: ' || SQLERRM);
594: fnd_msg_pub.ADD;
595: fnd_msg_pub.count_and_get(
596: p_encoded => fnd_api.g_false,
597: p_count => p_msg_count,
598: p_data => p_msg_data);
599: END get_stat_dtls;
600:

Line 697: IF fnd_api.to_boolean(NVL(p_init_msg_list, fnd_api.g_true)) THEN

693: l_message VARCHAR2(1000);
694: BEGIN
695: l_include := 'Y';
696: -- Initialize message list if p_init_msg_list is set to TRUE.
697: IF fnd_api.to_boolean(NVL(p_init_msg_list, fnd_api.g_true)) THEN
698: fnd_msg_pub.initialize;
699: END IF;
700:
701: -- The following parameters should not be null

Line 708: RAISE fnd_api.g_exc_error;

704: OR p_stat_type IS NULL) THEN
705: l_message := 'IGS_GE_INSUFFICIENT_PARAM_VAL';
706: fnd_message.set_name('IGS', l_message);
707: fnd_msg_pub.ADD;
708: RAISE fnd_api.g_exc_error;
709: END IF;
710:
711: -- If the Organizational Unit is not null then statistic type is
712: -- defined at Organizational level. Check if any unit reference

Line 787: p_return_status := fnd_api.g_ret_sts_success;

783: CLOSE c_inst_setup;
784: END IF;
785:
786: -- Initialize API return status to success.
787: p_return_status := fnd_api.g_ret_sts_success;
788: -- Standard call to get message count and if count is 1, get message info
789: fnd_msg_pub.count_and_get(
790: p_encoded => fnd_api.g_false,
791: p_count => p_msg_count,

Line 790: p_encoded => fnd_api.g_false,

786: -- Initialize API return status to success.
787: p_return_status := fnd_api.g_ret_sts_success;
788: -- Standard call to get message count and if count is 1, get message info
789: fnd_msg_pub.count_and_get(
790: p_encoded => fnd_api.g_false,
791: p_count => p_msg_count,
792: p_data => p_msg_data);
793: RETURN l_include;
794: EXCEPTION

Line 795: WHEN fnd_api.g_exc_error THEN

791: p_count => p_msg_count,
792: p_data => p_msg_data);
793: RETURN l_include;
794: EXCEPTION
795: WHEN fnd_api.g_exc_error THEN
796: p_return_status := fnd_api.g_ret_sts_error;
797: fnd_msg_pub.count_and_get(
798: p_encoded => fnd_api.g_false,
799: p_count => p_msg_count,

Line 796: p_return_status := fnd_api.g_ret_sts_error;

792: p_data => p_msg_data);
793: RETURN l_include;
794: EXCEPTION
795: WHEN fnd_api.g_exc_error THEN
796: p_return_status := fnd_api.g_ret_sts_error;
797: fnd_msg_pub.count_and_get(
798: p_encoded => fnd_api.g_false,
799: p_count => p_msg_count,
800: p_data => p_msg_data);

Line 798: p_encoded => fnd_api.g_false,

794: EXCEPTION
795: WHEN fnd_api.g_exc_error THEN
796: p_return_status := fnd_api.g_ret_sts_error;
797: fnd_msg_pub.count_and_get(
798: p_encoded => fnd_api.g_false,
799: p_count => p_msg_count,
800: p_data => p_msg_data);
801: RETURN NULL;
802: WHEN fnd_api.g_exc_unexpected_error THEN

Line 802: WHEN fnd_api.g_exc_unexpected_error THEN

798: p_encoded => fnd_api.g_false,
799: p_count => p_msg_count,
800: p_data => p_msg_data);
801: RETURN NULL;
802: WHEN fnd_api.g_exc_unexpected_error THEN
803: p_return_status := fnd_api.g_ret_sts_unexp_error;
804: fnd_msg_pub.count_and_get(
805: p_encoded => fnd_api.g_false,
806: p_count => p_msg_count,

Line 803: p_return_status := fnd_api.g_ret_sts_unexp_error;

799: p_count => p_msg_count,
800: p_data => p_msg_data);
801: RETURN NULL;
802: WHEN fnd_api.g_exc_unexpected_error THEN
803: p_return_status := fnd_api.g_ret_sts_unexp_error;
804: fnd_msg_pub.count_and_get(
805: p_encoded => fnd_api.g_false,
806: p_count => p_msg_count,
807: p_data => p_msg_data);

Line 805: p_encoded => fnd_api.g_false,

801: RETURN NULL;
802: WHEN fnd_api.g_exc_unexpected_error THEN
803: p_return_status := fnd_api.g_ret_sts_unexp_error;
804: fnd_msg_pub.count_and_get(
805: p_encoded => fnd_api.g_false,
806: p_count => p_msg_count,
807: p_data => p_msg_data);
808: RETURN NULL;
809: WHEN OTHERS THEN

Line 810: p_return_status := fnd_api.g_ret_sts_unexp_error;

806: p_count => p_msg_count,
807: p_data => p_msg_data);
808: RETURN NULL;
809: WHEN OTHERS THEN
810: p_return_status := fnd_api.g_ret_sts_unexp_error;
811: fnd_message.set_name('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
812: fnd_message.set_token('NAME', 'chk_unit_ref_cd: ' || SQLERRM);
813: fnd_msg_pub.ADD;
814: fnd_msg_pub.count_and_get(

Line 815: p_encoded => fnd_api.g_false,

811: fnd_message.set_name('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
812: fnd_message.set_token('NAME', 'chk_unit_ref_cd: ' || SQLERRM);
813: fnd_msg_pub.ADD;
814: fnd_msg_pub.count_and_get(
815: p_encoded => fnd_api.g_false,
816: p_count => p_msg_count,
817: p_data => p_msg_data);
818: RETURN NULL;
819: END chk_unit_ref_cd;

Line 945: IF fnd_api.to_boolean(NVL(p_init_msg_list, fnd_api.g_true)) THEN

941: l_msg_count NUMBER(2);
942: l_msg_data VARCHAR2(30);
943: BEGIN
944: -- Initialize message list if p_init_msg_list is set to TRUE.
945: IF fnd_api.to_boolean(NVL(p_init_msg_list, fnd_api.g_true)) THEN
946: fnd_msg_pub.initialize;
947: END IF;
948: -- Unit Advanced Standing
949: FOR lc_asu IN c_asu LOOP

Line 968: fnd_api.g_true ,

964: OR chk_av_unit_ref_cd (
965: lc_asu.av_stnd_unit_id ,
966: p_org_unit_cd ,
967: p_stat_type ,
968: fnd_api.g_true ,
969: l_return_status ,
970: l_msg_count ,
971: l_msg_data
972: )= 'Y' )

Line 1028: p_return_status := fnd_api.g_ret_sts_success;

1024: p_gpa_quality_points := l_gpa_quality_points;
1025: p_attempted_cp := l_attempted_cp_total;
1026: p_earned_cp := l_earned_cp_total;
1027: -- Initialize API return status to success.
1028: p_return_status := fnd_api.g_ret_sts_success;
1029: -- Standard call to get message count and if count is 1, get message info.
1030: fnd_msg_pub.count_and_get(
1031: p_encoded => fnd_api.g_false,
1032: p_count => p_msg_count,

Line 1031: p_encoded => fnd_api.g_false,

1027: -- Initialize API return status to success.
1028: p_return_status := fnd_api.g_ret_sts_success;
1029: -- Standard call to get message count and if count is 1, get message info.
1030: fnd_msg_pub.count_and_get(
1031: p_encoded => fnd_api.g_false,
1032: p_count => p_msg_count,
1033: p_data => p_msg_data);
1034:
1035: EXCEPTION

Line 1036: WHEN fnd_api.g_exc_error THEN

1032: p_count => p_msg_count,
1033: p_data => p_msg_data);
1034:
1035: EXCEPTION
1036: WHEN fnd_api.g_exc_error THEN
1037: p_return_status := fnd_api.g_ret_sts_error;
1038: fnd_msg_pub.count_and_get(
1039: p_encoded => fnd_api.g_false,
1040: p_count => p_msg_count,

Line 1037: p_return_status := fnd_api.g_ret_sts_error;

1033: p_data => p_msg_data);
1034:
1035: EXCEPTION
1036: WHEN fnd_api.g_exc_error THEN
1037: p_return_status := fnd_api.g_ret_sts_error;
1038: fnd_msg_pub.count_and_get(
1039: p_encoded => fnd_api.g_false,
1040: p_count => p_msg_count,
1041: p_data => p_msg_data);

Line 1039: p_encoded => fnd_api.g_false,

1035: EXCEPTION
1036: WHEN fnd_api.g_exc_error THEN
1037: p_return_status := fnd_api.g_ret_sts_error;
1038: fnd_msg_pub.count_and_get(
1039: p_encoded => fnd_api.g_false,
1040: p_count => p_msg_count,
1041: p_data => p_msg_data);
1042: WHEN fnd_api.g_exc_unexpected_error THEN
1043: p_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1042: WHEN fnd_api.g_exc_unexpected_error THEN

1038: fnd_msg_pub.count_and_get(
1039: p_encoded => fnd_api.g_false,
1040: p_count => p_msg_count,
1041: p_data => p_msg_data);
1042: WHEN fnd_api.g_exc_unexpected_error THEN
1043: p_return_status := fnd_api.g_ret_sts_unexp_error;
1044: fnd_msg_pub.count_and_get(
1045: p_encoded => fnd_api.g_false,
1046: p_count => p_msg_count,

Line 1043: p_return_status := fnd_api.g_ret_sts_unexp_error;

1039: p_encoded => fnd_api.g_false,
1040: p_count => p_msg_count,
1041: p_data => p_msg_data);
1042: WHEN fnd_api.g_exc_unexpected_error THEN
1043: p_return_status := fnd_api.g_ret_sts_unexp_error;
1044: fnd_msg_pub.count_and_get(
1045: p_encoded => fnd_api.g_false,
1046: p_count => p_msg_count,
1047: p_data => p_msg_data);

Line 1045: p_encoded => fnd_api.g_false,

1041: p_data => p_msg_data);
1042: WHEN fnd_api.g_exc_unexpected_error THEN
1043: p_return_status := fnd_api.g_ret_sts_unexp_error;
1044: fnd_msg_pub.count_and_get(
1045: p_encoded => fnd_api.g_false,
1046: p_count => p_msg_count,
1047: p_data => p_msg_data);
1048: WHEN OTHERS THEN
1049: p_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1049: p_return_status := fnd_api.g_ret_sts_unexp_error;

1045: p_encoded => fnd_api.g_false,
1046: p_count => p_msg_count,
1047: p_data => p_msg_data);
1048: WHEN OTHERS THEN
1049: p_return_status := fnd_api.g_ret_sts_unexp_error;
1050: fnd_message.set_name('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
1051: fnd_message.set_token('NAME', 'GET_ADV_STATS: ' || SQLERRM);
1052: fnd_msg_pub.ADD;
1053: fnd_msg_pub.count_and_get(

Line 1054: p_encoded => fnd_api.g_false,

1050: fnd_message.set_name('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
1051: fnd_message.set_token('NAME', 'GET_ADV_STATS: ' || SQLERRM);
1052: fnd_msg_pub.ADD;
1053: fnd_msg_pub.count_and_get(
1054: p_encoded => fnd_api.g_false,
1055: p_count => p_msg_count,
1056: p_data => p_msg_data);
1057: END get_adv_stats;
1058:

Line 1172: IF fnd_api.to_boolean(NVL(p_init_msg_list, fnd_api.g_true)) THEN

1168: l_gsg_show igs_as_grd_sch_grade.show_in_earned_crdt_ind%TYPE;
1169: l_origin_course_cd igs_ps_stdnt_unt_trn.transfer_course_cd%TYPE;
1170: BEGIN
1171: -- Initialize message list if p_init_msg_list is set to TRUE.
1172: IF fnd_api.to_boolean(NVL(p_init_msg_list, fnd_api.g_true)) THEN
1173: fnd_msg_pub.initialize;
1174: END IF;
1175: --
1176: -- Getting the Student Unit Attempt details

Line 1187: p_return_status := fnd_api.g_ret_sts_success;

1183: l_uv_credit_points;
1184: IF c_sua_uv%NOTFOUND THEN
1185: CLOSE c_sua_uv;
1186: -- Initialize API return status to success.
1187: p_return_status := fnd_api.g_ret_sts_success;
1188: RETURN;
1189: END IF;
1190: CLOSE c_sua_uv;
1191: --

Line 1270: p_return_status := fnd_api.g_ret_sts_success;

1266: p_enrolled_cp := l_unit_cp;
1267: END IF;
1268:
1269: -- Initialize API return status to success.
1270: p_return_status := fnd_api.g_ret_sts_success;
1271: -- Standard call to get message count and if count is 1, get message info.
1272: fnd_msg_pub.count_and_get(
1273: p_encoded => fnd_api.g_false,
1274: p_count => p_msg_count,

Line 1273: p_encoded => fnd_api.g_false,

1269: -- Initialize API return status to success.
1270: p_return_status := fnd_api.g_ret_sts_success;
1271: -- Standard call to get message count and if count is 1, get message info.
1272: fnd_msg_pub.count_and_get(
1273: p_encoded => fnd_api.g_false,
1274: p_count => p_msg_count,
1275: p_data => p_msg_data);
1276: EXCEPTION
1277: WHEN fnd_api.g_exc_error THEN

Line 1277: WHEN fnd_api.g_exc_error THEN

1273: p_encoded => fnd_api.g_false,
1274: p_count => p_msg_count,
1275: p_data => p_msg_data);
1276: EXCEPTION
1277: WHEN fnd_api.g_exc_error THEN
1278: p_return_status := fnd_api.g_ret_sts_error;
1279: fnd_msg_pub.count_and_get(
1280: p_encoded => fnd_api.g_false,
1281: p_count => p_msg_count,

Line 1278: p_return_status := fnd_api.g_ret_sts_error;

1274: p_count => p_msg_count,
1275: p_data => p_msg_data);
1276: EXCEPTION
1277: WHEN fnd_api.g_exc_error THEN
1278: p_return_status := fnd_api.g_ret_sts_error;
1279: fnd_msg_pub.count_and_get(
1280: p_encoded => fnd_api.g_false,
1281: p_count => p_msg_count,
1282: p_data => p_msg_data);

Line 1280: p_encoded => fnd_api.g_false,

1276: EXCEPTION
1277: WHEN fnd_api.g_exc_error THEN
1278: p_return_status := fnd_api.g_ret_sts_error;
1279: fnd_msg_pub.count_and_get(
1280: p_encoded => fnd_api.g_false,
1281: p_count => p_msg_count,
1282: p_data => p_msg_data);
1283: WHEN fnd_api.g_exc_unexpected_error THEN
1284: p_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1283: WHEN fnd_api.g_exc_unexpected_error THEN

1279: fnd_msg_pub.count_and_get(
1280: p_encoded => fnd_api.g_false,
1281: p_count => p_msg_count,
1282: p_data => p_msg_data);
1283: WHEN fnd_api.g_exc_unexpected_error THEN
1284: p_return_status := fnd_api.g_ret_sts_unexp_error;
1285: fnd_msg_pub.count_and_get(
1286: p_encoded => fnd_api.g_false,
1287: p_count => p_msg_count,

Line 1284: p_return_status := fnd_api.g_ret_sts_unexp_error;

1280: p_encoded => fnd_api.g_false,
1281: p_count => p_msg_count,
1282: p_data => p_msg_data);
1283: WHEN fnd_api.g_exc_unexpected_error THEN
1284: p_return_status := fnd_api.g_ret_sts_unexp_error;
1285: fnd_msg_pub.count_and_get(
1286: p_encoded => fnd_api.g_false,
1287: p_count => p_msg_count,
1288: p_data => p_msg_data);

Line 1286: p_encoded => fnd_api.g_false,

1282: p_data => p_msg_data);
1283: WHEN fnd_api.g_exc_unexpected_error THEN
1284: p_return_status := fnd_api.g_ret_sts_unexp_error;
1285: fnd_msg_pub.count_and_get(
1286: p_encoded => fnd_api.g_false,
1287: p_count => p_msg_count,
1288: p_data => p_msg_data);
1289: WHEN OTHERS THEN
1290: p_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1290: p_return_status := fnd_api.g_ret_sts_unexp_error;

1286: p_encoded => fnd_api.g_false,
1287: p_count => p_msg_count,
1288: p_data => p_msg_data);
1289: WHEN OTHERS THEN
1290: p_return_status := fnd_api.g_ret_sts_unexp_error;
1291: fnd_message.set_name('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
1292: fnd_message.set_token('NAME', 'GET_SUA_STATS: ' || SQLERRM);
1293: fnd_msg_pub.ADD;
1294: fnd_msg_pub.count_and_get(

Line 1295: p_encoded => fnd_api.g_false,

1291: fnd_message.set_name('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
1292: fnd_message.set_token('NAME', 'GET_SUA_STATS: ' || SQLERRM);
1293: fnd_msg_pub.ADD;
1294: fnd_msg_pub.count_and_get(
1295: p_encoded => fnd_api.g_false,
1296: p_count => p_msg_count,
1297: p_data => p_msg_data);
1298: END get_sua_stats;
1299: --

Line 1366: IF fnd_api.to_boolean(NVL(p_init_msg_list, fnd_api.g_true)) THEN

1362: l_org_id := igs_ge_gen_003.get_org_id;
1363: igs_ge_gen_003.set_org_id(l_org_id);
1364:
1365: -- Initialize message list if p_init_msg_list is set to TRUE.
1366: IF fnd_api.to_boolean(NVL(p_init_msg_list, fnd_api.g_true)) THEN
1367: fnd_msg_pub.initialize;
1368: END IF;
1369:
1370: -- Validate the Parameters, so that must not be NULL

Line 1379: RAISE fnd_api.g_exc_error;

1375: OR p_teach_cal_type IS NULL
1376: OR p_teach_ci_sequence_number IS NULL) THEN
1377: fnd_message.set_name('IGS', 'IGS_GE_INSUFFICIENT_PARAM_VAL');
1378: fnd_msg_pub.ADD;
1379: RAISE fnd_api.g_exc_error;
1380: END IF;
1381:
1382: p_gpa_value := NULL;
1383: p_gpa_cp := NULL;

Line 1400: fnd_api.g_true,

1396: l_include_std_ind,
1397: l_include_local_ind,
1398: l_include_other_ind,
1399: l_derivation,
1400: fnd_api.g_true,
1401: l_return_status,
1402: l_msg_count,
1403: l_msg_data);
1404:

Line 1405: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1401: l_return_status,
1402: l_msg_count,
1403: l_msg_data);
1404:
1405: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1406: p_gpa_value := NULL;
1407: p_gpa_cp := NULL;
1408: p_gpa_quality_points := NULL;
1409: p_earned_cp := NULL;

Line 1439: fnd_api.g_true,

1435: p_unit_cd,
1436: p_unit_version_number,
1437: l_org_unit_cd,
1438: l_stat_type,
1439: fnd_api.g_true,
1440: l_return_status,
1441: l_msg_count,
1442: l_msg_data) = 'Y' THEN
1443: IF l_return_status <> fnd_api.g_ret_sts_success THEN

Line 1443: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1439: fnd_api.g_true,
1440: l_return_status,
1441: l_msg_count,
1442: l_msg_data) = 'Y' THEN
1443: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1444: p_return_status := l_return_status;
1445: p_msg_count := l_msg_count;
1446: p_msg_data := l_msg_data;
1447: RETURN;

Line 1451: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1447: RETURN;
1448: END IF;
1449: v_inc_exc_ul := 'Y';
1450: ELSE -- Added as part of fix for Bug# 5260180
1451: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1452: p_return_status := l_return_status;
1453: p_msg_count := l_msg_count;
1454: p_msg_data := l_msg_data;
1455: RETURN;

Line 1468: fnd_api.g_true,

1464: p_course_cd,
1465: p_uoo_id,
1466: l_org_unit_cd,
1467: l_stat_type,
1468: fnd_api.g_true,
1469: l_return_status,
1470: l_msg_count,
1471: l_msg_data) = 'Y' THEN
1472: IF l_return_status <> fnd_api.g_ret_sts_success THEN

Line 1472: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1468: fnd_api.g_true,
1469: l_return_status,
1470: l_msg_count,
1471: l_msg_data) = 'Y' THEN
1472: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1473: p_return_status := l_return_status;
1474: p_msg_count := l_msg_count;
1475: p_msg_data := l_msg_data;
1476: RETURN;

Line 1480: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1476: RETURN;
1477: END IF;
1478: v_inc_exc_sua := 'Y';
1479: ELSE -- Added as part of fix for Bug# 5260180
1480: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1481: p_return_status := l_return_status;
1482: p_msg_count := l_msg_count;
1483: p_msg_data := l_msg_data;
1484: RETURN;

Line 1504: fnd_api.g_true,

1500: l_attempted_cp,
1501: l_gpa_value,
1502: l_gpa_cp,
1503: l_gpa_quality_points,
1504: fnd_api.g_true,
1505: l_return_status,
1506: l_msg_count,
1507: l_msg_data,
1508: p_uoo_id,

Line 1512: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1508: p_uoo_id,
1509: p_use_released_grade,
1510: p_enrolled_cp);
1511:
1512: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1513: p_gpa_value := NULL;
1514: p_gpa_cp := NULL;
1515: p_gpa_quality_points := NULL;
1516: p_earned_cp := NULL;

Line 1534: p_return_status := fnd_api.g_ret_sts_success;

1530: p_gpa_quality_points := l_gpa_quality_points;
1531: p_earned_cp := l_earned_cp;
1532: p_attempted_cp := l_attempted_cp;
1533: -- Initialize API return status to success.
1534: p_return_status := fnd_api.g_ret_sts_success;
1535: -- Standard call to get message count and if count is 1, get message info.
1536: fnd_msg_pub.count_and_get(
1537: p_encoded => fnd_api.g_false,
1538: p_count => p_msg_count,

Line 1537: p_encoded => fnd_api.g_false,

1533: -- Initialize API return status to success.
1534: p_return_status := fnd_api.g_ret_sts_success;
1535: -- Standard call to get message count and if count is 1, get message info.
1536: fnd_msg_pub.count_and_get(
1537: p_encoded => fnd_api.g_false,
1538: p_count => p_msg_count,
1539: p_data => p_msg_data);
1540: EXCEPTION
1541: WHEN fnd_api.g_exc_error THEN

Line 1541: WHEN fnd_api.g_exc_error THEN

1537: p_encoded => fnd_api.g_false,
1538: p_count => p_msg_count,
1539: p_data => p_msg_data);
1540: EXCEPTION
1541: WHEN fnd_api.g_exc_error THEN
1542: p_return_status := fnd_api.g_ret_sts_error;
1543: fnd_msg_pub.count_and_get(
1544: p_encoded => fnd_api.g_false,
1545: p_count => p_msg_count,

Line 1542: p_return_status := fnd_api.g_ret_sts_error;

1538: p_count => p_msg_count,
1539: p_data => p_msg_data);
1540: EXCEPTION
1541: WHEN fnd_api.g_exc_error THEN
1542: p_return_status := fnd_api.g_ret_sts_error;
1543: fnd_msg_pub.count_and_get(
1544: p_encoded => fnd_api.g_false,
1545: p_count => p_msg_count,
1546: p_data => p_msg_data);

Line 1544: p_encoded => fnd_api.g_false,

1540: EXCEPTION
1541: WHEN fnd_api.g_exc_error THEN
1542: p_return_status := fnd_api.g_ret_sts_error;
1543: fnd_msg_pub.count_and_get(
1544: p_encoded => fnd_api.g_false,
1545: p_count => p_msg_count,
1546: p_data => p_msg_data);
1547: WHEN fnd_api.g_exc_unexpected_error THEN
1548: p_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1547: WHEN fnd_api.g_exc_unexpected_error THEN

1543: fnd_msg_pub.count_and_get(
1544: p_encoded => fnd_api.g_false,
1545: p_count => p_msg_count,
1546: p_data => p_msg_data);
1547: WHEN fnd_api.g_exc_unexpected_error THEN
1548: p_return_status := fnd_api.g_ret_sts_unexp_error;
1549: fnd_msg_pub.count_and_get(
1550: p_encoded => fnd_api.g_false,
1551: p_count => p_msg_count,

Line 1548: p_return_status := fnd_api.g_ret_sts_unexp_error;

1544: p_encoded => fnd_api.g_false,
1545: p_count => p_msg_count,
1546: p_data => p_msg_data);
1547: WHEN fnd_api.g_exc_unexpected_error THEN
1548: p_return_status := fnd_api.g_ret_sts_unexp_error;
1549: fnd_msg_pub.count_and_get(
1550: p_encoded => fnd_api.g_false,
1551: p_count => p_msg_count,
1552: p_data => p_msg_data);

Line 1550: p_encoded => fnd_api.g_false,

1546: p_data => p_msg_data);
1547: WHEN fnd_api.g_exc_unexpected_error THEN
1548: p_return_status := fnd_api.g_ret_sts_unexp_error;
1549: fnd_msg_pub.count_and_get(
1550: p_encoded => fnd_api.g_false,
1551: p_count => p_msg_count,
1552: p_data => p_msg_data);
1553: WHEN OTHERS THEN
1554: p_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1554: p_return_status := fnd_api.g_ret_sts_unexp_error;

1550: p_encoded => fnd_api.g_false,
1551: p_count => p_msg_count,
1552: p_data => p_msg_data);
1553: WHEN OTHERS THEN
1554: p_return_status := fnd_api.g_ret_sts_unexp_error;
1555: fnd_message.set_name('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
1556: fnd_message.set_token('NAME', 'GET_SUA_ALL: ' || SQLERRM);
1557: fnd_msg_pub.ADD;
1558: fnd_msg_pub.count_and_get(

Line 1559: p_encoded => fnd_api.g_false,

1555: fnd_message.set_name('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
1556: fnd_message.set_token('NAME', 'GET_SUA_ALL: ' || SQLERRM);
1557: fnd_msg_pub.ADD;
1558: fnd_msg_pub.count_and_get(
1559: p_encoded => fnd_api.g_false,
1560: p_count => p_msg_count,
1561: p_data => p_msg_data);
1562: END get_sua_all;
1563:

Line 1624: IF fnd_api.to_boolean(p_init_msg_list) THEN

1620: l_org_id := igs_ge_gen_003.get_org_id;
1621: igs_ge_gen_003.set_org_id(l_org_id);
1622:
1623: --Initialize message list if p_init_msg_list is set to TRUE.
1624: IF fnd_api.to_boolean(p_init_msg_list) THEN
1625: fnd_msg_pub.initialize;
1626: END IF;
1627:
1628: -- Validate the Parameters, so that must not be NULL

Line 1637: RAISE fnd_api.g_exc_error;

1633: OR p_teach_cal_type IS NULL
1634: OR p_teach_ci_sequence_number IS NULL) THEN
1635: fnd_message.set_name('IGS', 'IGS_GE_INSUFFICIENT_PARAM_VAL');
1636: fnd_msg_pub.ADD;
1637: RAISE fnd_api.g_exc_error;
1638: END IF;
1639:
1640: -- Call GET_SUA_ALL to calculate the GPA and CP values for the Student Unit
1641: -- Attempt

Line 1656: fnd_api.g_true,

1652: l_attempted_cp,
1653: l_gpa_value,
1654: l_gpa_cp,
1655: l_gpa_quality_points,
1656: fnd_api.g_true,
1657: l_return_status,
1658: l_msg_count,
1659: l_msg_data,
1660: p_uoo_id,

Line 1664: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

1660: p_uoo_id,
1661: p_use_released_grade);
1662:
1663: -- If any Error is occurred in get_cp procedure Then return.
1664: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
1665: p_return_status := l_return_status;
1666: p_msg_count := l_msg_count;
1667: p_msg_data := l_msg_data;
1668: RETURN;

Line 1675: p_return_status := fnd_api.g_ret_sts_success;

1671: -- Set out NOCOPY parameters
1672: p_earned_cp := l_earned_cp;
1673: p_attempted_cp := l_attempted_cp;
1674: -- Initialize API return status to success.
1675: p_return_status := fnd_api.g_ret_sts_success;
1676: -- Standard call to get message count and if count is 1, get message info.
1677: fnd_msg_pub.count_and_get(
1678: p_encoded => fnd_api.g_false,
1679: p_count => p_msg_count,

Line 1678: p_encoded => fnd_api.g_false,

1674: -- Initialize API return status to success.
1675: p_return_status := fnd_api.g_ret_sts_success;
1676: -- Standard call to get message count and if count is 1, get message info.
1677: fnd_msg_pub.count_and_get(
1678: p_encoded => fnd_api.g_false,
1679: p_count => p_msg_count,
1680: p_data => p_msg_data);
1681: EXCEPTION
1682: WHEN fnd_api.g_exc_error THEN

Line 1682: WHEN fnd_api.g_exc_error THEN

1678: p_encoded => fnd_api.g_false,
1679: p_count => p_msg_count,
1680: p_data => p_msg_data);
1681: EXCEPTION
1682: WHEN fnd_api.g_exc_error THEN
1683: p_return_status := fnd_api.g_ret_sts_error;
1684: fnd_msg_pub.count_and_get(
1685: p_encoded => fnd_api.g_false,
1686: p_count => p_msg_count,

Line 1683: p_return_status := fnd_api.g_ret_sts_error;

1679: p_count => p_msg_count,
1680: p_data => p_msg_data);
1681: EXCEPTION
1682: WHEN fnd_api.g_exc_error THEN
1683: p_return_status := fnd_api.g_ret_sts_error;
1684: fnd_msg_pub.count_and_get(
1685: p_encoded => fnd_api.g_false,
1686: p_count => p_msg_count,
1687: p_data => p_msg_data);

Line 1685: p_encoded => fnd_api.g_false,

1681: EXCEPTION
1682: WHEN fnd_api.g_exc_error THEN
1683: p_return_status := fnd_api.g_ret_sts_error;
1684: fnd_msg_pub.count_and_get(
1685: p_encoded => fnd_api.g_false,
1686: p_count => p_msg_count,
1687: p_data => p_msg_data);
1688: WHEN fnd_api.g_exc_unexpected_error THEN
1689: p_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1688: WHEN fnd_api.g_exc_unexpected_error THEN

1684: fnd_msg_pub.count_and_get(
1685: p_encoded => fnd_api.g_false,
1686: p_count => p_msg_count,
1687: p_data => p_msg_data);
1688: WHEN fnd_api.g_exc_unexpected_error THEN
1689: p_return_status := fnd_api.g_ret_sts_unexp_error;
1690: fnd_msg_pub.count_and_get(
1691: p_encoded => fnd_api.g_false,
1692: p_count => p_msg_count,

Line 1689: p_return_status := fnd_api.g_ret_sts_unexp_error;

1685: p_encoded => fnd_api.g_false,
1686: p_count => p_msg_count,
1687: p_data => p_msg_data);
1688: WHEN fnd_api.g_exc_unexpected_error THEN
1689: p_return_status := fnd_api.g_ret_sts_unexp_error;
1690: fnd_msg_pub.count_and_get(
1691: p_encoded => fnd_api.g_false,
1692: p_count => p_msg_count,
1693: p_data => p_msg_data);

Line 1691: p_encoded => fnd_api.g_false,

1687: p_data => p_msg_data);
1688: WHEN fnd_api.g_exc_unexpected_error THEN
1689: p_return_status := fnd_api.g_ret_sts_unexp_error;
1690: fnd_msg_pub.count_and_get(
1691: p_encoded => fnd_api.g_false,
1692: p_count => p_msg_count,
1693: p_data => p_msg_data);
1694: WHEN OTHERS THEN
1695: p_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1695: p_return_status := fnd_api.g_ret_sts_unexp_error;

1691: p_encoded => fnd_api.g_false,
1692: p_count => p_msg_count,
1693: p_data => p_msg_data);
1694: WHEN OTHERS THEN
1695: p_return_status := fnd_api.g_ret_sts_unexp_error;
1696: fnd_message.set_name('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
1697: fnd_message.set_token('NAME', 'get_sua_cp: ' || SQLERRM);
1698: fnd_msg_pub.ADD;
1699: fnd_msg_pub.count_and_get(

Line 1700: p_encoded => fnd_api.g_false,

1696: fnd_message.set_name('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
1697: fnd_message.set_token('NAME', 'get_sua_cp: ' || SQLERRM);
1698: fnd_msg_pub.ADD;
1699: fnd_msg_pub.count_and_get(
1700: p_encoded => fnd_api.g_false,
1701: p_count => p_msg_count,
1702: p_data => p_msg_data);
1703: END get_sua_cp;
1704:

Line 1758: IF fnd_api.to_boolean(p_init_msg_list) THEN

1754: l_org_id := igs_ge_gen_003.get_org_id;
1755: igs_ge_gen_003.set_org_id(l_org_id);
1756:
1757: --Initialize message list if p_init_msg_list is set to TRUE.
1758: IF fnd_api.to_boolean(p_init_msg_list) THEN
1759: fnd_msg_pub.initialize;
1760: END IF;
1761:
1762: -- Validate the Parameters, so that must not be NULL

Line 1771: RAISE fnd_api.g_exc_error;

1767: OR p_teach_cal_type IS NULL
1768: OR p_teach_ci_sequence_number IS NULL) THEN
1769: fnd_message.set_name('IGS', 'IGS_GE_INSUFFICIENT_PARAM_VAL');
1770: fnd_msg_pub.ADD;
1771: RAISE fnd_api.g_exc_error;
1772: END IF;
1773:
1774: -- Call GET_SUA_ALL to calculate the GPA and CP values for the Student Unit
1775: -- Attempt

Line 1790: fnd_api.g_true,

1786: l_attempted_cp,
1787: l_gpa_value,
1788: l_gpa_cp,
1789: l_gpa_quality_points,
1790: fnd_api.g_true,
1791: l_return_status,
1792: l_msg_count,
1793: l_msg_data,
1794: p_uoo_id,

Line 1798: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

1794: p_uoo_id,
1795: p_use_released_grade);
1796:
1797: -- If any Error is occurred in get_cp procedure Then return.
1798: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
1799: p_return_status := l_return_status;
1800: p_msg_count := l_msg_count;
1801: p_msg_data := l_msg_data;
1802: RETURN;

Line 1810: p_return_status := fnd_api.g_ret_sts_success;

1806: p_gpa_value := l_gpa_value;
1807: p_gpa_cp := l_gpa_cp;
1808: p_gpa_quality_points := l_gpa_quality_points;
1809: -- Initialize API return status to success.
1810: p_return_status := fnd_api.g_ret_sts_success;
1811: -- Standard call to get message count and if count is 1, get message info.
1812: fnd_msg_pub.count_and_get(
1813: p_encoded => fnd_api.g_false,
1814: p_count => p_msg_count,

Line 1813: p_encoded => fnd_api.g_false,

1809: -- Initialize API return status to success.
1810: p_return_status := fnd_api.g_ret_sts_success;
1811: -- Standard call to get message count and if count is 1, get message info.
1812: fnd_msg_pub.count_and_get(
1813: p_encoded => fnd_api.g_false,
1814: p_count => p_msg_count,
1815: p_data => p_msg_data);
1816: EXCEPTION
1817: WHEN fnd_api.g_exc_error THEN

Line 1817: WHEN fnd_api.g_exc_error THEN

1813: p_encoded => fnd_api.g_false,
1814: p_count => p_msg_count,
1815: p_data => p_msg_data);
1816: EXCEPTION
1817: WHEN fnd_api.g_exc_error THEN
1818: p_return_status := fnd_api.g_ret_sts_error;
1819: fnd_msg_pub.count_and_get(
1820: p_encoded => fnd_api.g_false,
1821: p_count => p_msg_count,

Line 1818: p_return_status := fnd_api.g_ret_sts_error;

1814: p_count => p_msg_count,
1815: p_data => p_msg_data);
1816: EXCEPTION
1817: WHEN fnd_api.g_exc_error THEN
1818: p_return_status := fnd_api.g_ret_sts_error;
1819: fnd_msg_pub.count_and_get(
1820: p_encoded => fnd_api.g_false,
1821: p_count => p_msg_count,
1822: p_data => p_msg_data);

Line 1820: p_encoded => fnd_api.g_false,

1816: EXCEPTION
1817: WHEN fnd_api.g_exc_error THEN
1818: p_return_status := fnd_api.g_ret_sts_error;
1819: fnd_msg_pub.count_and_get(
1820: p_encoded => fnd_api.g_false,
1821: p_count => p_msg_count,
1822: p_data => p_msg_data);
1823: WHEN fnd_api.g_exc_unexpected_error THEN
1824: p_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1823: WHEN fnd_api.g_exc_unexpected_error THEN

1819: fnd_msg_pub.count_and_get(
1820: p_encoded => fnd_api.g_false,
1821: p_count => p_msg_count,
1822: p_data => p_msg_data);
1823: WHEN fnd_api.g_exc_unexpected_error THEN
1824: p_return_status := fnd_api.g_ret_sts_unexp_error;
1825: fnd_msg_pub.count_and_get(
1826: p_encoded => fnd_api.g_false,
1827: p_count => p_msg_count,

Line 1824: p_return_status := fnd_api.g_ret_sts_unexp_error;

1820: p_encoded => fnd_api.g_false,
1821: p_count => p_msg_count,
1822: p_data => p_msg_data);
1823: WHEN fnd_api.g_exc_unexpected_error THEN
1824: p_return_status := fnd_api.g_ret_sts_unexp_error;
1825: fnd_msg_pub.count_and_get(
1826: p_encoded => fnd_api.g_false,
1827: p_count => p_msg_count,
1828: p_data => p_msg_data);

Line 1826: p_encoded => fnd_api.g_false,

1822: p_data => p_msg_data);
1823: WHEN fnd_api.g_exc_unexpected_error THEN
1824: p_return_status := fnd_api.g_ret_sts_unexp_error;
1825: fnd_msg_pub.count_and_get(
1826: p_encoded => fnd_api.g_false,
1827: p_count => p_msg_count,
1828: p_data => p_msg_data);
1829: WHEN OTHERS THEN
1830: p_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1830: p_return_status := fnd_api.g_ret_sts_unexp_error;

1826: p_encoded => fnd_api.g_false,
1827: p_count => p_msg_count,
1828: p_data => p_msg_data);
1829: WHEN OTHERS THEN
1830: p_return_status := fnd_api.g_ret_sts_unexp_error;
1831: fnd_message.set_name('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
1832: fnd_message.set_token('NAME', 'GET_SUA_GPA: ' || SQLERRM);
1833: fnd_msg_pub.ADD;
1834: fnd_msg_pub.count_and_get(

Line 1835: p_encoded => fnd_api.g_false,

1831: fnd_message.set_name('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
1832: fnd_message.set_token('NAME', 'GET_SUA_GPA: ' || SQLERRM);
1833: fnd_msg_pub.ADD;
1834: fnd_msg_pub.count_and_get(
1835: p_encoded => fnd_api.g_false,
1836: p_count => p_msg_count,
1837: p_data => p_msg_data);
1838: END get_sua_gpa;
1839:

Line 2025: IF fnd_api.to_boolean(NVL(p_init_msg_list, fnd_api.g_true)) THEN

2021: l_org_id := igs_ge_gen_003.get_org_id;
2022: igs_ge_gen_003.set_org_id(l_org_id);
2023:
2024: -- Initialize message list if p_init_msg_list is set to TRUE.
2025: IF fnd_api.to_boolean(NVL(p_init_msg_list, fnd_api.g_true)) THEN
2026: fnd_msg_pub.initialize;
2027: END IF;
2028:
2029: -- Validate the Parameters, so that must not be NULL

Line 2036: RAISE fnd_api.g_exc_error;

2032: OR p_load_cal_type IS NULL
2033: OR p_load_ci_sequence_number IS NULL) THEN
2034: fnd_message.set_name('IGS', 'IGS_GE_INSUFFICIENT_PARAM_VAL');
2035: fnd_msg_pub.ADD;
2036: RAISE fnd_api.g_exc_error;
2037: END IF;
2038:
2039: p_gpa_value := NULL;
2040: p_gpa_cp := NULL;

Line 2057: fnd_api.g_true,

2053: l_include_std_ind,
2054: l_include_local_ind,
2055: l_include_other_ind,
2056: l_derivation,
2057: fnd_api.g_true,
2058: l_return_status,
2059: l_msg_count,
2060: l_msg_data);
2061:

Line 2062: IF l_return_status <> fnd_api.g_ret_sts_success THEN

2058: l_return_status,
2059: l_msg_count,
2060: l_msg_data);
2061:
2062: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2063: p_gpa_value := NULL;
2064: p_gpa_cp := NULL;
2065: p_gpa_quality_points := NULL;
2066: p_earned_cp := NULL;

Line 2104: p_return_status := fnd_api.g_ret_sts_success;

2100: p_gpa_value := lc_sas.gpa;
2101: p_gpa_cp := lc_sas.gpa_credit_points;
2102: p_gpa_quality_points := lc_sas.gpa_quality_points;
2103: -- Initialize API return status to success.
2104: p_return_status := fnd_api.g_ret_sts_success;
2105: -- Standard call to get message count and if count is 1, get message info
2106: fnd_msg_pub.count_and_get(
2107: p_encoded => fnd_api.g_false,
2108: p_count => p_msg_count,

Line 2107: p_encoded => fnd_api.g_false,

2103: -- Initialize API return status to success.
2104: p_return_status := fnd_api.g_ret_sts_success;
2105: -- Standard call to get message count and if count is 1, get message info
2106: fnd_msg_pub.count_and_get(
2107: p_encoded => fnd_api.g_false,
2108: p_count => p_msg_count,
2109: p_data => p_msg_data);
2110: RETURN;
2111: ELSE

Line 2121: p_return_status := fnd_api.g_ret_sts_success;

2117: p_gpa_cp :=NULL;
2118: p_gpa_quality_points :=NULL;
2119:
2120: -- Initialize API return status to success.
2121: p_return_status := fnd_api.g_ret_sts_success;
2122: -- Standard call to get message count and if count is 1, get message info
2123: fnd_msg_pub.count_and_get(
2124: p_encoded => fnd_api.g_false,
2125: p_count => p_msg_count,

Line 2124: p_encoded => fnd_api.g_false,

2120: -- Initialize API return status to success.
2121: p_return_status := fnd_api.g_ret_sts_success;
2122: -- Standard call to get message count and if count is 1, get message info
2123: fnd_msg_pub.count_and_get(
2124: p_encoded => fnd_api.g_false,
2125: p_count => p_msg_count,
2126: p_data => p_msg_data);
2127:
2128: RETURN;

Line 2148: p_return_status := fnd_api.g_ret_sts_success;

2144: p_gpa_value := lc_sas.gpa;
2145: p_gpa_cp := lc_sas.gpa_credit_points;
2146: p_gpa_quality_points := lc_sas.gpa_quality_points;
2147: -- Initialize API return status to success.
2148: p_return_status := fnd_api.g_ret_sts_success;
2149: -- Standard call to get message count and if count is 1, get message info
2150: fnd_msg_pub.count_and_get(
2151: p_encoded => fnd_api.g_false,
2152: p_count => p_msg_count,

Line 2151: p_encoded => fnd_api.g_false,

2147: -- Initialize API return status to success.
2148: p_return_status := fnd_api.g_ret_sts_success;
2149: -- Standard call to get message count and if count is 1, get message info
2150: fnd_msg_pub.count_and_get(
2151: p_encoded => fnd_api.g_false,
2152: p_count => p_msg_count,
2153: p_data => p_msg_data);
2154: RETURN;
2155: END IF;

Line 2172: fnd_api.g_true,

2168: lc_sua_uv.unit_cd,
2169: lc_sua_uv.version_number,
2170: l_org_unit_cd,
2171: l_stat_type,
2172: fnd_api.g_true,
2173: l_return_status,
2174: l_msg_count,
2175: l_msg_data) = 'Y' THEN
2176: IF l_return_status <> fnd_api.g_ret_sts_success THEN

Line 2176: IF l_return_status <> fnd_api.g_ret_sts_success THEN

2172: fnd_api.g_true,
2173: l_return_status,
2174: l_msg_count,
2175: l_msg_data) = 'Y' THEN
2176: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2177: p_return_status := l_return_status;
2178: p_msg_count := l_msg_count;
2179: p_msg_data := l_msg_data;
2180: RETURN;

Line 2184: IF l_return_status <> fnd_api.g_ret_sts_success THEN

2180: RETURN;
2181: END IF;
2182: ELSE -- Added as part of fix for Bug# 5260180
2183: v_inc_exc_ul := 'N';
2184: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2185: p_return_status := l_return_status;
2186: p_msg_count := l_msg_count;
2187: p_msg_data := l_msg_data;
2188: RETURN;

Line 2201: fnd_api.g_true,

2197: lc_sua_uv.course_cd,
2198: lc_sua_uv.uoo_id,
2199: l_org_unit_cd,
2200: l_stat_type,
2201: fnd_api.g_true,
2202: l_return_status,
2203: l_msg_count,
2204: l_msg_data) = 'Y' THEN
2205: IF l_return_status <> fnd_api.g_ret_sts_success THEN

Line 2205: IF l_return_status <> fnd_api.g_ret_sts_success THEN

2201: fnd_api.g_true,
2202: l_return_status,
2203: l_msg_count,
2204: l_msg_data) = 'Y' THEN
2205: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2206: p_return_status := l_return_status;
2207: p_msg_count := l_msg_count;
2208: p_msg_data := l_msg_data;
2209: RETURN;

Line 2213: IF l_return_status <> fnd_api.g_ret_sts_success THEN

2209: RETURN;
2210: END IF;
2211: ELSE -- Added as part of fix for Bug# 5260180
2212: v_inc_exc_sua := 'N';
2213: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2214: p_return_status := l_return_status;
2215: p_msg_count := l_msg_count;
2216: p_msg_data := l_msg_data;
2217: RETURN;

Line 2235: fnd_api.g_true,

2231: l_attempted_cp,
2232: l_gpa_value,
2233: l_gpa_cp,
2234: l_gpa_quality_points,
2235: fnd_api.g_true,
2236: l_return_status,
2237: l_msg_count,
2238: l_msg_data,
2239: lc_sua_uv.uoo_id,

Line 2243: IF l_return_status <> fnd_api.g_ret_sts_success THEN

2239: lc_sua_uv.uoo_id,
2240: p_use_released_grade,
2241: l_enrolled_cp);
2242:
2243: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2244: p_gpa_value := NULL;
2245: p_gpa_cp := NULL;
2246: p_gpa_quality_points := NULL;
2247: p_earned_cp := NULL;

Line 2285: fnd_api.g_true,

2281: l_earned_cp,
2282: l_attempted_cp,
2283: l_gpa_cp,
2284: l_gpa_quality_points,
2285: fnd_api.g_true,
2286: l_return_status,
2287: l_msg_count,
2288: l_msg_data);
2289: --Total the Credit Points for all the Student Unit Attempts.

Line 2309: p_return_status := fnd_api.g_ret_sts_success;

2305: p_attempted_cp := l_attempted_cp_total;
2306: p_earned_cp := l_earned_cp_total;
2307: p_enrolled_cp :=l_enrolled_cp_total;
2308: -- Initialize API return status to success.
2309: p_return_status := fnd_api.g_ret_sts_success;
2310: -- Standard call to get message count and if count is 1, get message
2311: -- info.
2312: fnd_msg_pub.count_and_get(
2313: p_encoded => fnd_api.g_false,

Line 2313: p_encoded => fnd_api.g_false,

2309: p_return_status := fnd_api.g_ret_sts_success;
2310: -- Standard call to get message count and if count is 1, get message
2311: -- info.
2312: fnd_msg_pub.count_and_get(
2313: p_encoded => fnd_api.g_false,
2314: p_count => p_msg_count,
2315: p_data => p_msg_data);
2316: EXCEPTION
2317: WHEN fnd_api.g_exc_error THEN

Line 2317: WHEN fnd_api.g_exc_error THEN

2313: p_encoded => fnd_api.g_false,
2314: p_count => p_msg_count,
2315: p_data => p_msg_data);
2316: EXCEPTION
2317: WHEN fnd_api.g_exc_error THEN
2318: p_return_status := fnd_api.g_ret_sts_error;
2319: fnd_msg_pub.count_and_get(
2320: p_encoded => fnd_api.g_false,
2321: p_count => p_msg_count,

Line 2318: p_return_status := fnd_api.g_ret_sts_error;

2314: p_count => p_msg_count,
2315: p_data => p_msg_data);
2316: EXCEPTION
2317: WHEN fnd_api.g_exc_error THEN
2318: p_return_status := fnd_api.g_ret_sts_error;
2319: fnd_msg_pub.count_and_get(
2320: p_encoded => fnd_api.g_false,
2321: p_count => p_msg_count,
2322: p_data => p_msg_data);

Line 2320: p_encoded => fnd_api.g_false,

2316: EXCEPTION
2317: WHEN fnd_api.g_exc_error THEN
2318: p_return_status := fnd_api.g_ret_sts_error;
2319: fnd_msg_pub.count_and_get(
2320: p_encoded => fnd_api.g_false,
2321: p_count => p_msg_count,
2322: p_data => p_msg_data);
2323: WHEN fnd_api.g_exc_unexpected_error THEN
2324: p_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2323: WHEN fnd_api.g_exc_unexpected_error THEN

2319: fnd_msg_pub.count_and_get(
2320: p_encoded => fnd_api.g_false,
2321: p_count => p_msg_count,
2322: p_data => p_msg_data);
2323: WHEN fnd_api.g_exc_unexpected_error THEN
2324: p_return_status := fnd_api.g_ret_sts_unexp_error;
2325: fnd_msg_pub.count_and_get(
2326: p_encoded => fnd_api.g_false,
2327: p_count => p_msg_count,

Line 2324: p_return_status := fnd_api.g_ret_sts_unexp_error;

2320: p_encoded => fnd_api.g_false,
2321: p_count => p_msg_count,
2322: p_data => p_msg_data);
2323: WHEN fnd_api.g_exc_unexpected_error THEN
2324: p_return_status := fnd_api.g_ret_sts_unexp_error;
2325: fnd_msg_pub.count_and_get(
2326: p_encoded => fnd_api.g_false,
2327: p_count => p_msg_count,
2328: p_data => p_msg_data);

Line 2326: p_encoded => fnd_api.g_false,

2322: p_data => p_msg_data);
2323: WHEN fnd_api.g_exc_unexpected_error THEN
2324: p_return_status := fnd_api.g_ret_sts_unexp_error;
2325: fnd_msg_pub.count_and_get(
2326: p_encoded => fnd_api.g_false,
2327: p_count => p_msg_count,
2328: p_data => p_msg_data);
2329: WHEN OTHERS THEN
2330: p_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2330: p_return_status := fnd_api.g_ret_sts_unexp_error;

2326: p_encoded => fnd_api.g_false,
2327: p_count => p_msg_count,
2328: p_data => p_msg_data);
2329: WHEN OTHERS THEN
2330: p_return_status := fnd_api.g_ret_sts_unexp_error;
2331: fnd_message.set_name('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
2332: fnd_message.set_token('NAME', 'GET_ALL_STATS: ' || SQLERRM);
2333: fnd_msg_pub.ADD;
2334: fnd_msg_pub.count_and_get(

Line 2335: p_encoded => fnd_api.g_false,

2331: fnd_message.set_name('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
2332: fnd_message.set_token('NAME', 'GET_ALL_STATS: ' || SQLERRM);
2333: fnd_msg_pub.ADD;
2334: fnd_msg_pub.count_and_get(
2335: p_encoded => fnd_api.g_false,
2336: p_count => p_msg_count,
2337: p_data => p_msg_data);
2338: END get_all_stats_new;
2339: --

Line 2382: IF fnd_api.to_boolean(p_init_msg_list) THEN

2378: l_org_id := igs_ge_gen_003.get_org_id;
2379: igs_ge_gen_003.set_org_id(l_org_id);
2380:
2381: -- Initialize message list if p_init_msg_list is set to TRUE.
2382: IF fnd_api.to_boolean(p_init_msg_list) THEN
2383: fnd_msg_pub.initialize;
2384: END IF;
2385:
2386: -- Validate the Parameters, so that must not be NULL

Line 2393: RAISE fnd_api.g_exc_error;

2389: OR p_load_cal_type IS NULL
2390: OR p_load_ci_sequence_number IS NULL) THEN
2391: fnd_message.set_name('IGS', 'IGS_GE_INSUFFICIENT_PARAM_VAL');
2392: fnd_msg_pub.ADD;
2393: RAISE fnd_api.g_exc_error;
2394: END IF;
2395:
2396: -- Call GET_ALL_STATS to calculate the GPA and CP values for the Student
2397: -- Unit Attempt

Line 2418: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

2414: p_msg_data => l_msg_data,
2415: p_use_released_grade => p_use_released_grade);
2416:
2417: -- If any Error is occurred in get_cp procedure Then return.
2418: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
2419: p_return_status := l_return_status;
2420: p_msg_count := l_msg_count;
2421: p_msg_data := l_msg_data;
2422: RETURN;

Line 2429: p_return_status := fnd_api.g_ret_sts_success;

2425: -- Set out NOCOPY parameters
2426: p_earned_cp := l_earned_cp;
2427: p_attempted_cp := l_attempted_cp;
2428: -- Initialize API return status to success.
2429: p_return_status := fnd_api.g_ret_sts_success;
2430: -- Standard call to get message count and if count is 1, get message info.
2431: fnd_msg_pub.count_and_get(
2432: p_encoded => fnd_api.g_false,
2433: p_count => p_msg_count,

Line 2432: p_encoded => fnd_api.g_false,

2428: -- Initialize API return status to success.
2429: p_return_status := fnd_api.g_ret_sts_success;
2430: -- Standard call to get message count and if count is 1, get message info.
2431: fnd_msg_pub.count_and_get(
2432: p_encoded => fnd_api.g_false,
2433: p_count => p_msg_count,
2434: p_data => p_msg_data);
2435: EXCEPTION
2436: WHEN fnd_api.g_exc_error THEN

Line 2436: WHEN fnd_api.g_exc_error THEN

2432: p_encoded => fnd_api.g_false,
2433: p_count => p_msg_count,
2434: p_data => p_msg_data);
2435: EXCEPTION
2436: WHEN fnd_api.g_exc_error THEN
2437: p_return_status := fnd_api.g_ret_sts_error;
2438: fnd_msg_pub.count_and_get(
2439: p_encoded => fnd_api.g_false,
2440: p_count => p_msg_count,

Line 2437: p_return_status := fnd_api.g_ret_sts_error;

2433: p_count => p_msg_count,
2434: p_data => p_msg_data);
2435: EXCEPTION
2436: WHEN fnd_api.g_exc_error THEN
2437: p_return_status := fnd_api.g_ret_sts_error;
2438: fnd_msg_pub.count_and_get(
2439: p_encoded => fnd_api.g_false,
2440: p_count => p_msg_count,
2441: p_data => p_msg_data);

Line 2439: p_encoded => fnd_api.g_false,

2435: EXCEPTION
2436: WHEN fnd_api.g_exc_error THEN
2437: p_return_status := fnd_api.g_ret_sts_error;
2438: fnd_msg_pub.count_and_get(
2439: p_encoded => fnd_api.g_false,
2440: p_count => p_msg_count,
2441: p_data => p_msg_data);
2442: WHEN fnd_api.g_exc_unexpected_error THEN
2443: p_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2442: WHEN fnd_api.g_exc_unexpected_error THEN

2438: fnd_msg_pub.count_and_get(
2439: p_encoded => fnd_api.g_false,
2440: p_count => p_msg_count,
2441: p_data => p_msg_data);
2442: WHEN fnd_api.g_exc_unexpected_error THEN
2443: p_return_status := fnd_api.g_ret_sts_unexp_error;
2444: fnd_msg_pub.count_and_get(
2445: p_encoded => fnd_api.g_false,
2446: p_count => p_msg_count,

Line 2443: p_return_status := fnd_api.g_ret_sts_unexp_error;

2439: p_encoded => fnd_api.g_false,
2440: p_count => p_msg_count,
2441: p_data => p_msg_data);
2442: WHEN fnd_api.g_exc_unexpected_error THEN
2443: p_return_status := fnd_api.g_ret_sts_unexp_error;
2444: fnd_msg_pub.count_and_get(
2445: p_encoded => fnd_api.g_false,
2446: p_count => p_msg_count,
2447: p_data => p_msg_data);

Line 2445: p_encoded => fnd_api.g_false,

2441: p_data => p_msg_data);
2442: WHEN fnd_api.g_exc_unexpected_error THEN
2443: p_return_status := fnd_api.g_ret_sts_unexp_error;
2444: fnd_msg_pub.count_and_get(
2445: p_encoded => fnd_api.g_false,
2446: p_count => p_msg_count,
2447: p_data => p_msg_data);
2448: WHEN OTHERS THEN
2449: p_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2449: p_return_status := fnd_api.g_ret_sts_unexp_error;

2445: p_encoded => fnd_api.g_false,
2446: p_count => p_msg_count,
2447: p_data => p_msg_data);
2448: WHEN OTHERS THEN
2449: p_return_status := fnd_api.g_ret_sts_unexp_error;
2450: fnd_message.set_name('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
2451: fnd_message.set_token('NAME', 'GET_CP_STATS: ' || SQLERRM);
2452: fnd_msg_pub.ADD;
2453: fnd_msg_pub.count_and_get(

Line 2454: p_encoded => fnd_api.g_false,

2450: fnd_message.set_name('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
2451: fnd_message.set_token('NAME', 'GET_CP_STATS: ' || SQLERRM);
2452: fnd_msg_pub.ADD;
2453: fnd_msg_pub.count_and_get(
2454: p_encoded => fnd_api.g_false,
2455: p_count => p_msg_count,
2456: p_data => p_msg_data);
2457: END get_cp_stats;
2458:

Line 2500: IF fnd_api.to_boolean(p_init_msg_list) THEN

2496: l_org_id := igs_ge_gen_003.get_org_id;
2497: igs_ge_gen_003.set_org_id(l_org_id);
2498:
2499: -- Initialize message list if p_init_msg_list is set to TRUE.
2500: IF fnd_api.to_boolean(p_init_msg_list) THEN
2501: fnd_msg_pub.initialize;
2502: END IF;
2503:
2504: -- Validate the Parameters, so that must not be NULL

Line 2511: RAISE fnd_api.g_exc_error;

2507: OR p_load_cal_type IS NULL
2508: OR p_load_ci_sequence_number IS NULL) THEN
2509: fnd_message.set_name('IGS', 'IGS_GE_INSUFFICIENT_PARAM_VAL');
2510: fnd_msg_pub.ADD;
2511: RAISE fnd_api.g_exc_error;
2512: END IF;
2513:
2514: -- Call GET_ALL_STATS to calculate the GPA and CP values for the
2515: -- Student Unit Attempt

Line 2536: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

2532: p_msg_data => l_msg_data,
2533: p_use_released_grade => p_use_released_grade);
2534:
2535: -- If any Error is occurred in get_cp procedure Then return.
2536: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
2537: p_return_status := l_return_status;
2538: p_msg_count := l_msg_count;
2539: p_msg_data := l_msg_data;
2540: RETURN;

Line 2548: p_return_status := fnd_api.g_ret_sts_success;

2544: p_gpa_value := to_number(to_char(l_gpa_value,'99D999'));
2545: p_gpa_cp := l_gpa_cp;
2546: p_gpa_quality_points := l_gpa_quality_points;
2547: -- Initialize API return status to success.
2548: p_return_status := fnd_api.g_ret_sts_success;
2549: -- Standard call to get message count and if count is 1, get message info.
2550: fnd_msg_pub.count_and_get(
2551: p_encoded => fnd_api.g_false,
2552: p_count => p_msg_count,

Line 2551: p_encoded => fnd_api.g_false,

2547: -- Initialize API return status to success.
2548: p_return_status := fnd_api.g_ret_sts_success;
2549: -- Standard call to get message count and if count is 1, get message info.
2550: fnd_msg_pub.count_and_get(
2551: p_encoded => fnd_api.g_false,
2552: p_count => p_msg_count,
2553: p_data => p_msg_data);
2554: EXCEPTION
2555: WHEN fnd_api.g_exc_error THEN

Line 2555: WHEN fnd_api.g_exc_error THEN

2551: p_encoded => fnd_api.g_false,
2552: p_count => p_msg_count,
2553: p_data => p_msg_data);
2554: EXCEPTION
2555: WHEN fnd_api.g_exc_error THEN
2556: p_return_status := fnd_api.g_ret_sts_error;
2557: fnd_msg_pub.count_and_get(
2558: p_encoded => fnd_api.g_false,
2559: p_count => p_msg_count,

Line 2556: p_return_status := fnd_api.g_ret_sts_error;

2552: p_count => p_msg_count,
2553: p_data => p_msg_data);
2554: EXCEPTION
2555: WHEN fnd_api.g_exc_error THEN
2556: p_return_status := fnd_api.g_ret_sts_error;
2557: fnd_msg_pub.count_and_get(
2558: p_encoded => fnd_api.g_false,
2559: p_count => p_msg_count,
2560: p_data => p_msg_data);

Line 2558: p_encoded => fnd_api.g_false,

2554: EXCEPTION
2555: WHEN fnd_api.g_exc_error THEN
2556: p_return_status := fnd_api.g_ret_sts_error;
2557: fnd_msg_pub.count_and_get(
2558: p_encoded => fnd_api.g_false,
2559: p_count => p_msg_count,
2560: p_data => p_msg_data);
2561: WHEN fnd_api.g_exc_unexpected_error THEN
2562: p_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2561: WHEN fnd_api.g_exc_unexpected_error THEN

2557: fnd_msg_pub.count_and_get(
2558: p_encoded => fnd_api.g_false,
2559: p_count => p_msg_count,
2560: p_data => p_msg_data);
2561: WHEN fnd_api.g_exc_unexpected_error THEN
2562: p_return_status := fnd_api.g_ret_sts_unexp_error;
2563: fnd_msg_pub.count_and_get(
2564: p_encoded => fnd_api.g_false,
2565: p_count => p_msg_count,

Line 2562: p_return_status := fnd_api.g_ret_sts_unexp_error;

2558: p_encoded => fnd_api.g_false,
2559: p_count => p_msg_count,
2560: p_data => p_msg_data);
2561: WHEN fnd_api.g_exc_unexpected_error THEN
2562: p_return_status := fnd_api.g_ret_sts_unexp_error;
2563: fnd_msg_pub.count_and_get(
2564: p_encoded => fnd_api.g_false,
2565: p_count => p_msg_count,
2566: p_data => p_msg_data);

Line 2564: p_encoded => fnd_api.g_false,

2560: p_data => p_msg_data);
2561: WHEN fnd_api.g_exc_unexpected_error THEN
2562: p_return_status := fnd_api.g_ret_sts_unexp_error;
2563: fnd_msg_pub.count_and_get(
2564: p_encoded => fnd_api.g_false,
2565: p_count => p_msg_count,
2566: p_data => p_msg_data);
2567: WHEN OTHERS THEN
2568: p_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2568: p_return_status := fnd_api.g_ret_sts_unexp_error;

2564: p_encoded => fnd_api.g_false,
2565: p_count => p_msg_count,
2566: p_data => p_msg_data);
2567: WHEN OTHERS THEN
2568: p_return_status := fnd_api.g_ret_sts_unexp_error;
2569: fnd_message.set_name('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
2570: fnd_message.set_token('NAME', 'GET_GPA_STATS: ' || SQLERRM);
2571: fnd_msg_pub.ADD;
2572: fnd_msg_pub.count_and_get(

Line 2573: p_encoded => fnd_api.g_false,

2569: fnd_message.set_name('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
2570: fnd_message.set_token('NAME', 'GET_GPA_STATS: ' || SQLERRM);
2571: fnd_msg_pub.ADD;
2572: fnd_msg_pub.count_and_get(
2573: p_encoded => fnd_api.g_false,
2574: p_count => p_msg_count,
2575: p_data => p_msg_data);
2576: END get_gpa_stats;
2577:

Line 2678: IF fnd_api.to_boolean(NVL(p_init_msg_list, fnd_api.g_true)) THEN

2674: l_message VARCHAR2(1000);
2675: BEGIN
2676: l_include := 'Y';
2677: -- Initialize message list if p_init_msg_list is set to TRUE.
2678: IF fnd_api.to_boolean(NVL(p_init_msg_list, fnd_api.g_true)) THEN
2679: fnd_msg_pub.initialize;
2680: END IF;
2681:
2682: -- The following parameters should not be null

Line 2690: RAISE fnd_api.g_exc_error;

2686: OR p_stat_type IS NULL) THEN
2687: l_message := 'IGS_GE_INSUFFICIENT_PARAM_VAL';
2688: fnd_message.set_name('IGS', l_message);
2689: fnd_msg_pub.ADD;
2690: RAISE fnd_api.g_exc_error;
2691: END IF;
2692:
2693: -- If the Organizational Unit is not null then statistic type is
2694: -- defined at Organizational level. Check if any unit reference

Line 2768: p_return_status := fnd_api.g_ret_sts_success;

2764: CLOSE c_inst_setup;
2765: END IF;
2766:
2767: -- Initialize API return status to success.
2768: p_return_status := fnd_api.g_ret_sts_success;
2769: -- Standard call to get message count and if count is 1, get message info
2770: fnd_msg_pub.count_and_get(
2771: p_encoded => fnd_api.g_false,
2772: p_count => p_msg_count,

Line 2771: p_encoded => fnd_api.g_false,

2767: -- Initialize API return status to success.
2768: p_return_status := fnd_api.g_ret_sts_success;
2769: -- Standard call to get message count and if count is 1, get message info
2770: fnd_msg_pub.count_and_get(
2771: p_encoded => fnd_api.g_false,
2772: p_count => p_msg_count,
2773: p_data => p_msg_data);
2774: RETURN l_include;
2775: EXCEPTION

Line 2776: WHEN fnd_api.g_exc_error THEN

2772: p_count => p_msg_count,
2773: p_data => p_msg_data);
2774: RETURN l_include;
2775: EXCEPTION
2776: WHEN fnd_api.g_exc_error THEN
2777: p_return_status := fnd_api.g_ret_sts_error;
2778: fnd_msg_pub.count_and_get(
2779: p_encoded => fnd_api.g_false,
2780: p_count => p_msg_count,

Line 2777: p_return_status := fnd_api.g_ret_sts_error;

2773: p_data => p_msg_data);
2774: RETURN l_include;
2775: EXCEPTION
2776: WHEN fnd_api.g_exc_error THEN
2777: p_return_status := fnd_api.g_ret_sts_error;
2778: fnd_msg_pub.count_and_get(
2779: p_encoded => fnd_api.g_false,
2780: p_count => p_msg_count,
2781: p_data => p_msg_data);

Line 2779: p_encoded => fnd_api.g_false,

2775: EXCEPTION
2776: WHEN fnd_api.g_exc_error THEN
2777: p_return_status := fnd_api.g_ret_sts_error;
2778: fnd_msg_pub.count_and_get(
2779: p_encoded => fnd_api.g_false,
2780: p_count => p_msg_count,
2781: p_data => p_msg_data);
2782: RETURN NULL;
2783: WHEN fnd_api.g_exc_unexpected_error THEN

Line 2783: WHEN fnd_api.g_exc_unexpected_error THEN

2779: p_encoded => fnd_api.g_false,
2780: p_count => p_msg_count,
2781: p_data => p_msg_data);
2782: RETURN NULL;
2783: WHEN fnd_api.g_exc_unexpected_error THEN
2784: p_return_status := fnd_api.g_ret_sts_unexp_error;
2785: fnd_msg_pub.count_and_get(
2786: p_encoded => fnd_api.g_false,
2787: p_count => p_msg_count,

Line 2784: p_return_status := fnd_api.g_ret_sts_unexp_error;

2780: p_count => p_msg_count,
2781: p_data => p_msg_data);
2782: RETURN NULL;
2783: WHEN fnd_api.g_exc_unexpected_error THEN
2784: p_return_status := fnd_api.g_ret_sts_unexp_error;
2785: fnd_msg_pub.count_and_get(
2786: p_encoded => fnd_api.g_false,
2787: p_count => p_msg_count,
2788: p_data => p_msg_data);

Line 2786: p_encoded => fnd_api.g_false,

2782: RETURN NULL;
2783: WHEN fnd_api.g_exc_unexpected_error THEN
2784: p_return_status := fnd_api.g_ret_sts_unexp_error;
2785: fnd_msg_pub.count_and_get(
2786: p_encoded => fnd_api.g_false,
2787: p_count => p_msg_count,
2788: p_data => p_msg_data);
2789: RETURN NULL;
2790: WHEN OTHERS THEN

Line 2791: p_return_status := fnd_api.g_ret_sts_unexp_error;

2787: p_count => p_msg_count,
2788: p_data => p_msg_data);
2789: RETURN NULL;
2790: WHEN OTHERS THEN
2791: p_return_status := fnd_api.g_ret_sts_unexp_error;
2792: fnd_message.set_name('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
2793: fnd_message.set_token('NAME', 'chk_sua_ref_cd: ' || SQLERRM);
2794: fnd_msg_pub.ADD;
2795: fnd_msg_pub.count_and_get(

Line 2796: p_encoded => fnd_api.g_false,

2792: fnd_message.set_name('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
2793: fnd_message.set_token('NAME', 'chk_sua_ref_cd: ' || SQLERRM);
2794: fnd_msg_pub.ADD;
2795: fnd_msg_pub.count_and_get(
2796: p_encoded => fnd_api.g_false,
2797: p_count => p_msg_count,
2798: p_data => p_msg_data);
2799: RETURN NULL;
2800: END chk_sua_ref_cd;