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_MSG_PUB

Line 256: fnd_msg_pub.initialize;

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:
259: -- The following parameters should not be null
260: IF ( p_av_stnd_unit_id IS NULL

Line 266: fnd_msg_pub.ADD;

262: )
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

Line 357: fnd_msg_pub.count_and_get (

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,
360: p_data=> p_msg_data
361: );

Line 367: fnd_msg_pub.count_and_get (

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

Line 376: fnd_msg_pub.count_and_get (

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
380: );

Line 388: fnd_msg_pub.ADD;

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

Line 389: fnd_msg_pub.count_and_get (

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

Line 490: fnd_msg_pub.initialize;

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: --
494: -- Check for the Parameters which are mandatory. If the parameters are

Line 501: fnd_msg_pub.ADD;

497: IF (p_person_id IS NULL
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: --

Line 514: fnd_msg_pub.ADD;

510: IF (p_system_stat IS NOT NULL
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: --

Line 551: fnd_msg_pub.ADD;

547: -- Added to fix Bug# 2685741
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: --

Line 572: fnd_msg_pub.count_and_get(

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,
575: p_data => p_msg_data);
576:

Line 580: fnd_msg_pub.count_and_get(

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);
584: WHEN fnd_api.g_exc_unexpected_error THEN

Line 586: fnd_msg_pub.count_and_get(

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);
590: WHEN OTHERS THEN

Line 594: fnd_msg_pub.ADD;

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(
596: p_encoded => fnd_api.g_false,
597: p_count => p_msg_count,
598: p_data => p_msg_data);

Line 595: fnd_msg_pub.count_and_get(

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(
596: p_encoded => fnd_api.g_false,
597: p_count => p_msg_count,
598: p_data => p_msg_data);
599: END get_stat_dtls;

Line 698: fnd_msg_pub.initialize;

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
702: IF (p_unit_cd IS NULL

Line 707: fnd_msg_pub.ADD;

703: OR p_unit_version_number IS NULL
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

Line 789: fnd_msg_pub.count_and_get(

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,
792: p_data => p_msg_data);
793: RETURN l_include;

Line 797: fnd_msg_pub.count_and_get(

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

Line 804: fnd_msg_pub.count_and_get(

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

Line 813: fnd_msg_pub.ADD;

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(
815: p_encoded => fnd_api.g_false,
816: p_count => p_msg_count,
817: p_data => p_msg_data);

Line 814: fnd_msg_pub.count_and_get(

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(
815: p_encoded => fnd_api.g_false,
816: p_count => p_msg_count,
817: p_data => p_msg_data);
818: RETURN NULL;

Line 946: fnd_msg_pub.initialize;

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
950: -- If achievable credit points is greater than zero, call Sub Function to

Line 1030: fnd_msg_pub.count_and_get(

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,
1033: p_data => p_msg_data);
1034:

Line 1038: fnd_msg_pub.count_and_get(

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);
1042: WHEN fnd_api.g_exc_unexpected_error THEN

Line 1044: fnd_msg_pub.count_and_get(

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);
1048: WHEN OTHERS THEN

Line 1052: fnd_msg_pub.ADD;

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(
1054: p_encoded => fnd_api.g_false,
1055: p_count => p_msg_count,
1056: p_data => p_msg_data);

Line 1053: fnd_msg_pub.count_and_get(

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(
1054: p_encoded => fnd_api.g_false,
1055: p_count => p_msg_count,
1056: p_data => p_msg_data);
1057: END get_adv_stats;

Line 1173: fnd_msg_pub.initialize;

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
1177: -- Modified the Fetch statment to fix Bug# 3419920; Nalin Kumar; 17-Feb-2004;

Line 1272: fnd_msg_pub.count_and_get(

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,
1275: p_data => p_msg_data);
1276: EXCEPTION

Line 1279: fnd_msg_pub.count_and_get(

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);
1283: WHEN fnd_api.g_exc_unexpected_error THEN

Line 1285: fnd_msg_pub.count_and_get(

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);
1289: WHEN OTHERS THEN

Line 1293: fnd_msg_pub.ADD;

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(
1295: p_encoded => fnd_api.g_false,
1296: p_count => p_msg_count,
1297: p_data => p_msg_data);

Line 1294: fnd_msg_pub.count_and_get(

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(
1295: p_encoded => fnd_api.g_false,
1296: p_count => p_msg_count,
1297: p_data => p_msg_data);
1298: END get_sua_stats;

Line 1367: fnd_msg_pub.initialize;

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
1371: IF (p_person_id IS NULL

Line 1378: fnd_msg_pub.ADD;

1374: OR p_unit_version_number IS NULL
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;

Line 1536: fnd_msg_pub.count_and_get(

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,
1539: p_data => p_msg_data);
1540: EXCEPTION

Line 1543: fnd_msg_pub.count_and_get(

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);
1547: WHEN fnd_api.g_exc_unexpected_error THEN

Line 1549: fnd_msg_pub.count_and_get(

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);
1553: WHEN OTHERS THEN

Line 1557: fnd_msg_pub.ADD;

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(
1559: p_encoded => fnd_api.g_false,
1560: p_count => p_msg_count,
1561: p_data => p_msg_data);

Line 1558: fnd_msg_pub.count_and_get(

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(
1559: p_encoded => fnd_api.g_false,
1560: p_count => p_msg_count,
1561: p_data => p_msg_data);
1562: END get_sua_all;

Line 1625: fnd_msg_pub.initialize;

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
1629: IF (p_person_id IS NULL

Line 1636: fnd_msg_pub.ADD;

1632: OR p_unit_version_number IS NULL
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

Line 1677: fnd_msg_pub.count_and_get(

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,
1680: p_data => p_msg_data);
1681: EXCEPTION

Line 1684: fnd_msg_pub.count_and_get(

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);
1688: WHEN fnd_api.g_exc_unexpected_error THEN

Line 1690: fnd_msg_pub.count_and_get(

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);
1694: WHEN OTHERS THEN

Line 1698: fnd_msg_pub.ADD;

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(
1700: p_encoded => fnd_api.g_false,
1701: p_count => p_msg_count,
1702: p_data => p_msg_data);

Line 1699: fnd_msg_pub.count_and_get(

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(
1700: p_encoded => fnd_api.g_false,
1701: p_count => p_msg_count,
1702: p_data => p_msg_data);
1703: END get_sua_cp;

Line 1759: fnd_msg_pub.initialize;

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
1763: IF (p_person_id IS NULL

Line 1770: fnd_msg_pub.ADD;

1766: OR p_unit_version_number IS NULL
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

Line 1812: fnd_msg_pub.count_and_get(

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,
1815: p_data => p_msg_data);
1816: EXCEPTION

Line 1819: fnd_msg_pub.count_and_get(

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);
1823: WHEN fnd_api.g_exc_unexpected_error THEN

Line 1825: fnd_msg_pub.count_and_get(

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);
1829: WHEN OTHERS THEN

Line 1833: fnd_msg_pub.ADD;

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(
1835: p_encoded => fnd_api.g_false,
1836: p_count => p_msg_count,
1837: p_data => p_msg_data);

Line 1834: fnd_msg_pub.count_and_get(

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(
1835: p_encoded => fnd_api.g_false,
1836: p_count => p_msg_count,
1837: p_data => p_msg_data);
1838: END get_sua_gpa;

Line 2026: fnd_msg_pub.initialize;

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
2030: IF (p_person_id IS NULL

Line 2035: fnd_msg_pub.ADD;

2031: OR p_course_cd IS NULL
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;

Line 2106: fnd_msg_pub.count_and_get(

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,
2109: p_data => p_msg_data);
2110: RETURN;

Line 2123: fnd_msg_pub.count_and_get(

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,
2126: p_data => p_msg_data);
2127:

Line 2150: fnd_msg_pub.count_and_get(

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,
2153: p_data => p_msg_data);
2154: RETURN;

Line 2312: fnd_msg_pub.count_and_get(

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,
2314: p_count => p_msg_count,
2315: p_data => p_msg_data);
2316: EXCEPTION

Line 2319: fnd_msg_pub.count_and_get(

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);
2323: WHEN fnd_api.g_exc_unexpected_error THEN

Line 2325: fnd_msg_pub.count_and_get(

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);
2329: WHEN OTHERS THEN

Line 2333: fnd_msg_pub.ADD;

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(
2335: p_encoded => fnd_api.g_false,
2336: p_count => p_msg_count,
2337: p_data => p_msg_data);

Line 2334: fnd_msg_pub.count_and_get(

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(
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;

Line 2383: fnd_msg_pub.initialize;

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
2387: IF (p_person_id IS NULL

Line 2392: fnd_msg_pub.ADD;

2388: OR p_course_cd IS NULL
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

Line 2431: fnd_msg_pub.count_and_get(

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,
2434: p_data => p_msg_data);
2435: EXCEPTION

Line 2438: fnd_msg_pub.count_and_get(

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);
2442: WHEN fnd_api.g_exc_unexpected_error THEN

Line 2444: fnd_msg_pub.count_and_get(

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);
2448: WHEN OTHERS THEN

Line 2452: fnd_msg_pub.ADD;

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(
2454: p_encoded => fnd_api.g_false,
2455: p_count => p_msg_count,
2456: p_data => p_msg_data);

Line 2453: fnd_msg_pub.count_and_get(

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(
2454: p_encoded => fnd_api.g_false,
2455: p_count => p_msg_count,
2456: p_data => p_msg_data);
2457: END get_cp_stats;

Line 2501: fnd_msg_pub.initialize;

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
2505: IF (p_person_id IS NULL

Line 2510: fnd_msg_pub.ADD;

2506: OR p_course_cd IS NULL
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

Line 2550: fnd_msg_pub.count_and_get(

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,
2553: p_data => p_msg_data);
2554: EXCEPTION

Line 2557: fnd_msg_pub.count_and_get(

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);
2561: WHEN fnd_api.g_exc_unexpected_error THEN

Line 2563: fnd_msg_pub.count_and_get(

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);
2567: WHEN OTHERS THEN

Line 2571: fnd_msg_pub.ADD;

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(
2573: p_encoded => fnd_api.g_false,
2574: p_count => p_msg_count,
2575: p_data => p_msg_data);

Line 2572: fnd_msg_pub.count_and_get(

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(
2573: p_encoded => fnd_api.g_false,
2574: p_count => p_msg_count,
2575: p_data => p_msg_data);
2576: END get_gpa_stats;

Line 2679: fnd_msg_pub.initialize;

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
2683: IF (p_person_id IS NULL

Line 2689: fnd_msg_pub.ADD;

2685: OR p_course_cd IS NULL
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

Line 2770: fnd_msg_pub.count_and_get(

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,
2773: p_data => p_msg_data);
2774: RETURN l_include;

Line 2778: fnd_msg_pub.count_and_get(

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

Line 2785: fnd_msg_pub.count_and_get(

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

Line 2794: fnd_msg_pub.ADD;

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(
2796: p_encoded => fnd_api.g_false,
2797: p_count => p_msg_count,
2798: p_data => p_msg_data);

Line 2795: fnd_msg_pub.count_and_get(

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(
2796: p_encoded => fnd_api.g_false,
2797: p_count => p_msg_count,
2798: p_data => p_msg_data);
2799: RETURN NULL;