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_MSG_PUB

Line 645: fnd_msg_pub.initialize;

641: sua.version_number
642: ) = 'TRUE';
643: BEGIN -- main begin
644: --Initialize the variables
645: fnd_msg_pub.initialize;
646: l_total_unit_lvl_cp_config := NULL;
647: l_total_unit_lvl_cp := 0;
648: l_unit_lvl_mark := 0;
649: l_mark_config_id := NULL;

Line 1161: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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:
1163: IF l_unit_lvl_mark IS NOT NULL
1164: THEN
1165: RETURN TO_NUMBER (TO_CHAR (l_unit_lvl_mark, '999.999'));

Line 1174: fnd_msg_pub.count_and_get (

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: );
1178: RETURN TO_NUMBER (NULL);

Line 1183: fnd_msg_pub.count_and_get (

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: );
1187: RETURN TO_NUMBER (NULL);

Line 1195: fnd_msg_pub.ADD;

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;
1196: fnd_msg_pub.count_and_get (
1197: p_count=> x_msg_count,
1198: p_data=> x_msg_data
1199: );

Line 1196: fnd_msg_pub.count_and_get (

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;
1196: fnd_msg_pub.count_and_get (
1197: p_count=> x_msg_count,
1198: p_data=> x_msg_data
1199: );
1200: RETURN l_unit_lvl_mark;

Line 1376: FND_MSG_PUB.initialize;

1372: l_grading_schema_cd igs_as_grd_sch_grade.grading_schema_cd%TYPE;
1373: l_gs_version_number igs_as_grd_sch_grade.version_number%TYPE;
1374: BEGIN
1375: --Initialize the variables
1376: FND_MSG_PUB.initialize;
1377: l_unit_level_mark :=0;
1378: l_sum :=0;
1379: -- validate the IN parameters for null values
1380: -- raise error msg IGS_PR_CALC_AWD_MARK_PARAM_REQ

Line 1477: FND_MSG_PUB.Count_And_Get(

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);
1480: EXCEPTION
1481: WHEN FND_API.G_EXC_ERROR THEN

Line 1483: FND_MSG_PUB.Count_And_Get(

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;
1487: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1489: FND_MSG_PUB.Count_And_Get(

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

Line 1497: FND_MSG_PUB.ADD;

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(
1499: p_count => x_MSG_COUNT,
1500: p_data => X_MSG_DATA);
1501: RETURN;

Line 1498: FND_MSG_PUB.Count_And_Get(

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(
1499: p_count => x_MSG_COUNT,
1500: p_data => X_MSG_DATA);
1501: RETURN;
1502: END pr_calc_award_mark;

Line 1541: FND_MSG_PUB.Count_And_Get(

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);
1544: EXCEPTION
1545: WHEN FND_API.G_EXC_ERROR THEN

Line 1547: FND_MSG_PUB.Count_And_Get(

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;
1551: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1553: FND_MSG_PUB.Count_And_Get(

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

Line 1561: FND_MSG_PUB.ADD;

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(
1563: p_count => x_MSG_COUNT,
1564: p_data => X_MSG_DATA);
1565: RETURN l_award_mark;

Line 1562: FND_MSG_PUB.Count_And_Get(

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(
1563: p_count => x_MSG_COUNT,
1564: p_data => X_MSG_DATA);
1565: RETURN l_award_mark;
1566: END fn_calc_award_mark;

Line 1683: FND_MSG_PUB.GET (

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 (
1684: FND_MSG_PUB.G_FIRST,
1685: FND_API.G_TRUE,
1686: l_enc_msg,
1687: l_msg_index

Line 1684: FND_MSG_PUB.G_FIRST,

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 (
1684: FND_MSG_PUB.G_FIRST,
1685: FND_API.G_TRUE,
1686: l_enc_msg,
1687: l_msg_index
1688: );

Line 1692: FND_MSG_PUB.DELETE_MSG(l_msg_index);

1688: );
1689: FND_MESSAGE.SET_ENCODED(l_enc_msg);
1690: lmsgdata := FND_MESSAGE.GET;
1691: l_mesg_text := l_mesg_text || lmsgdata || ';' ;
1692: FND_MSG_PUB.DELETE_MSG(l_msg_index);
1693: END LOOP;
1694:
1695: fnd_file.put_line (fnd_file.LOG, ' Failed to Update ' || spaa_rec.person_id || ' - ' || spaa_rec.course_cd || ' - ' || P_AWARD_CD );
1696: fnd_file.put_line (fnd_file.LOG, l_mesg_text);

Line 1738: FND_MSG_PUB.GET (

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,
1741: l_enc_msg,
1742: l_msg_index );

Line 1739: FND_MSG_PUB.G_FIRST,

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,
1741: l_enc_msg,
1742: l_msg_index );
1743:

Line 1747: FND_MSG_PUB.DELETE_MSG(l_msg_index);

1743:
1744: FND_MESSAGE.SET_ENCODED(l_enc_msg);
1745: lmsgdata := FND_MESSAGE.GET;
1746: l_mesg_text := l_mesg_text || lmsgdata || ';' ;
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

Line 1754: FND_MSG_PUB.GET (

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,
1756: FND_API.G_TRUE,
1757: l_enc_msg,
1758: l_msg_index

Line 1755: FND_MSG_PUB.G_FIRST,

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,
1756: FND_API.G_TRUE,
1757: l_enc_msg,
1758: l_msg_index
1759: );

Line 1763: FND_MSG_PUB.DELETE_MSG(l_msg_index);

1759: );
1760: FND_MESSAGE.SET_ENCODED(l_enc_msg);
1761: lmsgdata := FND_MESSAGE.GET;
1762: l_mesg_text := l_mesg_text || lmsgdata || ';' ;
1763: FND_MSG_PUB.DELETE_MSG(l_msg_index);
1764: END LOOP;
1765: fnd_file.put_line (fnd_file.LOG, 'Error Ocuured : ' ||l_mesg_text );
1766:
1767: WHEN OTHERS THEN