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_MESSAGE

Line 24: ex: apps.fnd_message.setname --> fnd_message.setname

20: STORED stats the function should then return null
21: jhanda 28-May-2003 Changed gpa , gpa_quality points , gpa_credit_points
22: procedure parameter types.
23: anilk 27-Dec-2002 Removed prefixed apps in the fnd calls. Bug# 2413841
24: ex: apps.fnd_message.setname --> fnd_message.setname
25: prraj 18-Feb-2002 Removed parameter p_uc_achievable_credit_points from
26: the parameter list of procedures get_cp and get_gpa.
27: Also removed the functionality to obtain the achievable
28: credit points from the unit section level (Bug# 2224366)

Line 265: fnd_message.set_name ('IGS', l_message);

261: OR p_stat_type IS NULL
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:

Line 385: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');

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;
389: fnd_msg_pub.count_and_get (

Line 386: fnd_message.set_token ('NAME', 'chk_av_unit_ref_cd: '

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;
389: fnd_msg_pub.count_and_get (
390: p_encoded=> fnd_api.g_false,

Line 500: fnd_message.set_name('IGS', l_message);

496: --
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:

Line 513: fnd_message.set_name('IGS', l_message);

509: --
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:

Line 550: fnd_message.set_name('IGS', 'IGS_PR_INVALID_STAT_TYPE');

546: -- p_stat_type := NULL;
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

Line 592: fnd_message.set_name('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');

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(
596: p_encoded => fnd_api.g_false,

Line 593: fnd_message.set_token('NAME', 'GET_STAT_DTLS: ' || SQLERRM);

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

Line 706: fnd_message.set_name('IGS', l_message);

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

Line 811: fnd_message.set_name('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');

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(
815: p_encoded => fnd_api.g_false,

Line 812: fnd_message.set_token('NAME', 'chk_unit_ref_cd: ' || SQLERRM);

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

Line 1050: fnd_message.set_name('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');

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(
1054: p_encoded => fnd_api.g_false,

Line 1051: fnd_message.set_token('NAME', 'GET_ADV_STATS: ' || SQLERRM);

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

Line 1291: fnd_message.set_name('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');

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(
1295: p_encoded => fnd_api.g_false,

Line 1292: fnd_message.set_token('NAME', 'GET_SUA_STATS: ' || SQLERRM);

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

Line 1377: fnd_message.set_name('IGS', 'IGS_GE_INSUFFICIENT_PARAM_VAL');

1373: OR p_unit_cd IS NULL
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:

Line 1555: fnd_message.set_name('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');

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(
1559: p_encoded => fnd_api.g_false,

Line 1556: fnd_message.set_token('NAME', 'GET_SUA_ALL: ' || SQLERRM);

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

Line 1635: fnd_message.set_name('IGS', 'IGS_GE_INSUFFICIENT_PARAM_VAL');

1631: OR p_unit_cd IS NULL
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:

Line 1696: fnd_message.set_name('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');

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(
1700: p_encoded => fnd_api.g_false,

Line 1697: fnd_message.set_token('NAME', 'get_sua_cp: ' || SQLERRM);

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

Line 1769: fnd_message.set_name('IGS', 'IGS_GE_INSUFFICIENT_PARAM_VAL');

1765: OR p_unit_cd IS NULL
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:

Line 1831: fnd_message.set_name('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');

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(
1835: p_encoded => fnd_api.g_false,

Line 1832: fnd_message.set_token('NAME', 'GET_SUA_GPA: ' || SQLERRM);

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

Line 2034: fnd_message.set_name('IGS', 'IGS_GE_INSUFFICIENT_PARAM_VAL');

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

Line 2331: fnd_message.set_name('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');

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(
2335: p_encoded => fnd_api.g_false,

Line 2332: fnd_message.set_token('NAME', 'GET_ALL_STATS: ' || SQLERRM);

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

Line 2391: fnd_message.set_name('IGS', 'IGS_GE_INSUFFICIENT_PARAM_VAL');

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

Line 2450: fnd_message.set_name('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');

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(
2454: p_encoded => fnd_api.g_false,

Line 2451: fnd_message.set_token('NAME', 'GET_CP_STATS: ' || SQLERRM);

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

Line 2509: fnd_message.set_name('IGS', 'IGS_GE_INSUFFICIENT_PARAM_VAL');

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

Line 2569: fnd_message.set_name('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');

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(
2573: p_encoded => fnd_api.g_false,

Line 2570: fnd_message.set_token('NAME', 'GET_GPA_STATS: ' || SQLERRM);

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

Line 2688: fnd_message.set_name('IGS', l_message);

2684: OR p_uoo_id IS NULL
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:

Line 2792: fnd_message.set_name('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');

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(
2796: p_encoded => fnd_api.g_false,

Line 2793: fnd_message.set_token('NAME', 'chk_sua_ref_cd: ' || SQLERRM);

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