eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_AS_CALC_AWARD_MARK dependencies on FND_API

Line 658: RAISE fnd_api.g_exc_error;

654: OR p_unit_level IS NULL
655: THEN
656: fnd_message.set_name ('IGS', 'IGS_PR_CALC_UNIT_LVL_PARAM_REQ');
657: igs_ge_msg_stack.ADD;
658: RAISE fnd_api.g_exc_error;
659: END IF;
660:
661: -- obtain the course version number
662: OPEN c_course_version_number (p_person_id, p_course_cd);

Line 1158: x_return_status := fnd_api.g_ret_sts_success;

1154: l_unit_lvl_mark := l_unit_lvl_mark / l_total_unit_lvl_cp_config;
1155: END IF; -- IF l_mark_config_id IS NOT NULL THEN
1156:
1157: -- Initialize API return status to success.
1158: x_return_status := fnd_api.g_ret_sts_success;
1159: -- Standard call to get message count and if count is 1, get message
1160: -- info.
1161: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1162:

Line 1170: WHEN fnd_api.g_exc_error

1166: ELSE
1167: RETURN l_unit_lvl_mark;
1168: END IF;
1169: EXCEPTION
1170: WHEN fnd_api.g_exc_error
1171: THEN
1172: l_unit_lvl_mark := NULL;
1173: x_return_status := fnd_api.g_ret_sts_error;
1174: fnd_msg_pub.count_and_get (

Line 1173: x_return_status := fnd_api.g_ret_sts_error;

1169: EXCEPTION
1170: WHEN fnd_api.g_exc_error
1171: THEN
1172: l_unit_lvl_mark := NULL;
1173: x_return_status := fnd_api.g_ret_sts_error;
1174: fnd_msg_pub.count_and_get (
1175: p_count=> x_msg_count,
1176: p_data=> x_msg_data
1177: );

Line 1179: WHEN fnd_api.g_exc_unexpected_error

1175: p_count=> x_msg_count,
1176: p_data=> x_msg_data
1177: );
1178: RETURN TO_NUMBER (NULL);
1179: WHEN fnd_api.g_exc_unexpected_error
1180: THEN
1181: l_unit_lvl_mark := NULL;
1182: x_return_status := fnd_api.g_ret_sts_unexp_error;
1183: fnd_msg_pub.count_and_get (

Line 1182: x_return_status := fnd_api.g_ret_sts_unexp_error;

1178: RETURN TO_NUMBER (NULL);
1179: WHEN fnd_api.g_exc_unexpected_error
1180: THEN
1181: l_unit_lvl_mark := NULL;
1182: x_return_status := fnd_api.g_ret_sts_unexp_error;
1183: fnd_msg_pub.count_and_get (
1184: p_count=> x_msg_count,
1185: p_data=> x_msg_data
1186: );

Line 1191: x_return_status := fnd_api.g_ret_sts_unexp_error;

1187: RETURN TO_NUMBER (NULL);
1188: WHEN OTHERS
1189: THEN
1190: l_unit_lvl_mark := NULL;
1191: x_return_status := fnd_api.g_ret_sts_unexp_error;
1192: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
1193: fnd_message.set_token ('NAME', 'pr_calc_unit_lvl_mark : '
1194: || SQLERRM);
1195: fnd_msg_pub.ADD;

Line 1387: RAISE FND_API.G_EXC_ERROR;

1383: p_course_cd IS NULL OR
1384: p_award_cd IS NULL THEN
1385: FND_MESSAGE.SET_NAME('IGS', 'IGS_PR_CALC_AWD_MARK_PARAM_REQ');
1386: IGS_GE_MSG_STACK.ADD;
1387: RAISE FND_API.G_EXC_ERROR;
1388: END IF;
1389:
1390: -- check for the career enabled model
1391: IF NVL(FND_PROFILE.VALUE('CAREER_MODEL_ENABLED'),'N') = 'N' THEN -- i..e Program Centric

Line 1445: p_init_msg_list => FND_API.G_TRUE,

1441: p_cumulative_ind => 'Y',
1442: p_gpa_value => l_gpa_value,
1443: p_gpa_cp => l_gpa_cp,
1444: p_gpa_quality_points => l_gpa_quality_points,
1445: p_init_msg_list => FND_API.G_TRUE,
1446: p_return_status => X_RETURN_STATUS,
1447: p_msg_count => X_MSG_COUNT,
1448: p_msg_data => X_MSG_DATA
1449: );

Line 1451: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

1447: p_msg_count => X_MSG_COUNT,
1448: p_msg_data => X_MSG_DATA
1449: );
1450:
1451: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
1452: FND_MESSAGE.SET_NAME('IGS',X_MSG_DATA);
1453: IGS_GE_MSG_STACK.ADD;
1454: RAISE FND_API.G_EXC_ERROR;
1455: END IF;

Line 1454: RAISE FND_API.G_EXC_ERROR;

1450:
1451: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
1452: FND_MESSAGE.SET_NAME('IGS',X_MSG_DATA);
1453: IGS_GE_MSG_STACK.ADD;
1454: RAISE FND_API.G_EXC_ERROR;
1455: END IF;
1456: -- now derive the honofrs level
1457: l_sum := l_gpa_value;
1458: get_hnr_grade(

Line 1475: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

1471: -- now assign the out parameters
1472: p_award_mark := l_sum;
1473: p_honors_level := l_honors_level;
1474: -- Initialize API return status to success.
1475: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1476: -- Standard call to get message count and if count is 1, get message info.
1477: FND_MSG_PUB.Count_And_Get(
1478: p_count => x_MSG_COUNT,
1479: p_data => X_MSG_DATA);

Line 1481: WHEN FND_API.G_EXC_ERROR THEN

1477: FND_MSG_PUB.Count_And_Get(
1478: p_count => x_MSG_COUNT,
1479: p_data => X_MSG_DATA);
1480: EXCEPTION
1481: WHEN FND_API.G_EXC_ERROR THEN
1482: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1483: FND_MSG_PUB.Count_And_Get(
1484: p_count => x_MSG_COUNT,
1485: p_data => X_MSG_DATA);

Line 1482: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

1478: p_count => x_MSG_COUNT,
1479: p_data => X_MSG_DATA);
1480: EXCEPTION
1481: WHEN FND_API.G_EXC_ERROR THEN
1482: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1483: FND_MSG_PUB.Count_And_Get(
1484: p_count => x_MSG_COUNT,
1485: p_data => X_MSG_DATA);
1486: RETURN;

Line 1487: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1483: FND_MSG_PUB.Count_And_Get(
1484: p_count => x_MSG_COUNT,
1485: p_data => X_MSG_DATA);
1486: RETURN;
1487: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1488: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
1489: FND_MSG_PUB.Count_And_Get(
1490: p_count => x_MSG_COUNT,
1491: p_data => X_MSG_DATA);

Line 1488: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

1484: p_count => x_MSG_COUNT,
1485: p_data => X_MSG_DATA);
1486: RETURN;
1487: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1488: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
1489: FND_MSG_PUB.Count_And_Get(
1490: p_count => x_MSG_COUNT,
1491: p_data => X_MSG_DATA);
1492: RETURN;

Line 1494: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

1490: p_count => x_MSG_COUNT,
1491: p_data => X_MSG_DATA);
1492: RETURN;
1493: WHEN OTHERS THEN
1494: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
1495: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
1496: FND_MESSAGE.SET_TOKEN('NAME','pr_calc_award_mark : '||SQLERRM);
1497: FND_MSG_PUB.ADD;
1498: FND_MSG_PUB.Count_And_Get(

Line 1531: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

1527: X_RETURN_STATUS => X_RETURN_STATUS,
1528: X_MSG_DATA => X_MSG_DATA,
1529: X_MSG_COUNT => X_MSG_COUNT);
1530:
1531: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
1532: FND_MESSAGE.SET_NAME('IGS',X_MSG_DATA);
1533: IGS_GE_MSG_STACK.ADD;
1534: RAISE FND_API.G_EXC_ERROR;
1535: END IF;

Line 1534: RAISE FND_API.G_EXC_ERROR;

1530:
1531: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
1532: FND_MESSAGE.SET_NAME('IGS',X_MSG_DATA);
1533: IGS_GE_MSG_STACK.ADD;
1534: RAISE FND_API.G_EXC_ERROR;
1535: END IF;
1536: --Calculation sucessful hence return properly with value.
1537: RETURN l_award_mark;
1538:

Line 1539: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

1535: END IF;
1536: --Calculation sucessful hence return properly with value.
1537: RETURN l_award_mark;
1538:
1539: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1540: -- Standard call to get message count and if count is 1, get message info.
1541: FND_MSG_PUB.Count_And_Get(
1542: p_count => x_MSG_COUNT,
1543: p_data => X_MSG_DATA);

Line 1545: WHEN FND_API.G_EXC_ERROR THEN

1541: FND_MSG_PUB.Count_And_Get(
1542: p_count => x_MSG_COUNT,
1543: p_data => X_MSG_DATA);
1544: EXCEPTION
1545: WHEN FND_API.G_EXC_ERROR THEN
1546: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1547: FND_MSG_PUB.Count_And_Get(
1548: p_count => x_MSG_COUNT,
1549: p_data => X_MSG_DATA);

Line 1546: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

1542: p_count => x_MSG_COUNT,
1543: p_data => X_MSG_DATA);
1544: EXCEPTION
1545: WHEN FND_API.G_EXC_ERROR THEN
1546: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1547: FND_MSG_PUB.Count_And_Get(
1548: p_count => x_MSG_COUNT,
1549: p_data => X_MSG_DATA);
1550: RETURN l_award_mark;

Line 1551: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1547: FND_MSG_PUB.Count_And_Get(
1548: p_count => x_MSG_COUNT,
1549: p_data => X_MSG_DATA);
1550: RETURN l_award_mark;
1551: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1552: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
1553: FND_MSG_PUB.Count_And_Get(
1554: p_count => x_MSG_COUNT,
1555: p_data => X_MSG_DATA);

Line 1552: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

1548: p_count => x_MSG_COUNT,
1549: p_data => X_MSG_DATA);
1550: RETURN l_award_mark;
1551: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1552: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
1553: FND_MSG_PUB.Count_And_Get(
1554: p_count => x_MSG_COUNT,
1555: p_data => X_MSG_DATA);
1556: RETURN l_award_mark;

Line 1558: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

1554: p_count => x_MSG_COUNT,
1555: p_data => X_MSG_DATA);
1556: RETURN l_award_mark;
1557: WHEN OTHERS THEN
1558: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
1559: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
1560: FND_MESSAGE.SET_TOKEN('NAME','pr_calc_award_mark : '||SQLERRM);
1561: FND_MSG_PUB.ADD;
1562: FND_MSG_PUB.Count_And_Get(

Line 1679: IF ((lReturnStatus <> FND_API.G_RET_STS_SUCCESS) OR (NVL(lrowawd_grd.grade, lawadrdgrade) IS NULL) )THEN

1675: x_msg_count => l_msg_count);
1676:
1677:
1678:
1679: IF ((lReturnStatus <> FND_API.G_RET_STS_SUCCESS) OR (NVL(lrowawd_grd.grade, lawadrdgrade) IS NULL) )THEN
1680: -- Get the proper message and log it to the file
1681: FOR l_index IN 1..NVL(l_msg_count, 0) LOOP
1682:
1683: FND_MSG_PUB.GET (

Line 1685: FND_API.G_TRUE,

1681: FOR l_index IN 1..NVL(l_msg_count, 0) LOOP
1682:
1683: FND_MSG_PUB.GET (
1684: FND_MSG_PUB.G_FIRST,
1685: FND_API.G_TRUE,
1686: l_enc_msg,
1687: l_msg_index
1688: );
1689: FND_MESSAGE.SET_ENCODED(l_enc_msg);

Line 1736: WHEN FND_API.G_EXC_ERROR THEN

1732: fnd_file.put_line (fnd_file.LOG, 'Total program attempt award records selected : ' || l_total_spa_rec);
1733: fnd_file.put_line (fnd_file.LOG, 'Total program attempt award records updated successfully : ' || l_total_spa_updated_rec);
1734:
1735: EXCEPTION
1736: WHEN FND_API.G_EXC_ERROR THEN
1737: FOR l_index IN 1..NVL(l_msg_count, 0) LOOP
1738: FND_MSG_PUB.GET (
1739: FND_MSG_PUB.G_FIRST,
1740: FND_API.G_TRUE,

Line 1740: FND_API.G_TRUE,

1736: WHEN FND_API.G_EXC_ERROR THEN
1737: FOR l_index IN 1..NVL(l_msg_count, 0) LOOP
1738: FND_MSG_PUB.GET (
1739: FND_MSG_PUB.G_FIRST,
1740: FND_API.G_TRUE,
1741: l_enc_msg,
1742: l_msg_index );
1743:
1744: FND_MESSAGE.SET_ENCODED(l_enc_msg);

Line 1751: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1747: FND_MSG_PUB.DELETE_MSG(l_msg_index);
1748: END LOOP;
1749: fnd_file.put_line (fnd_file.LOG, 'Error Ocuured : ' ||l_mesg_text );
1750:
1751: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1752: FOR l_index IN 1..NVL(l_msg_count, 0) LOOP
1753:
1754: FND_MSG_PUB.GET (
1755: FND_MSG_PUB.G_FIRST,

Line 1756: FND_API.G_TRUE,

1752: FOR l_index IN 1..NVL(l_msg_count, 0) LOOP
1753:
1754: FND_MSG_PUB.GET (
1755: FND_MSG_PUB.G_FIRST,
1756: FND_API.G_TRUE,
1757: l_enc_msg,
1758: l_msg_index
1759: );
1760: FND_MESSAGE.SET_ENCODED(l_enc_msg);