DBA Data[Home] [Help]

APPS.IGS_PR_CLASS_RANK dependencies on FND_API

Line 1574: RAISE FND_API.G_EXC_ERROR;

1570: p_program_cd IS NULL THEN
1571: l_formatted_rank := NULL;
1572: FND_MESSAGE.SET_NAME ('IGS','IGS_AD_INVALID_PARAM_COMB');
1573: FND_MSG_PUB.ADD;
1574: RAISE FND_API.G_EXC_ERROR;
1575: END IF;
1576:
1577: -- select the default display type if p_disp_type is null
1578: IF p_disp_type IS NULL THEN

Line 1597: RAISE FND_API.G_EXC_ERROR;

1593: IF c_rank%NOTFOUND THEN
1594: CLOSE c_rank;
1595: FND_MESSAGE.SET_NAME ('IGS','IGS_PR_NO_RANK_AVL');
1596: FND_MSG_PUB.ADD;
1597: RAISE FND_API.G_EXC_ERROR;
1598: END IF;
1599: CLOSE c_rank;
1600:
1601: -- select the cohort population

Line 1647: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

1643:
1644:
1645: x_formatted_rank := l_formatted_rank;
1646: --Initialize API return status to success.
1647: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1648:
1649: --Standard call to get message count and if count is 1, get message
1650: --info.
1651: Fnd_Msg_Pub.Count_And_Get(

Line 1652: p_encoded => Fnd_Api.G_FALSE,

1648:
1649: --Standard call to get message count and if count is 1, get message
1650: --info.
1651: Fnd_Msg_Pub.Count_And_Get(
1652: p_encoded => Fnd_Api.G_FALSE,
1653: p_count => x_msg_count,
1654: p_data => x_msg_data);
1655:
1656: EXCEPTION

Line 1657: WHEN FND_API.G_EXC_ERROR THEN

1653: p_count => x_msg_count,
1654: p_data => x_msg_data);
1655:
1656: EXCEPTION
1657: WHEN FND_API.G_EXC_ERROR THEN
1658: x_formatted_rank := l_formatted_rank;
1659: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1660: FND_MSG_PUB.Count_And_Get(
1661: p_encoded => FND_API.G_FALSE,

Line 1659: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

1655:
1656: EXCEPTION
1657: WHEN FND_API.G_EXC_ERROR THEN
1658: x_formatted_rank := l_formatted_rank;
1659: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1660: FND_MSG_PUB.Count_And_Get(
1661: p_encoded => FND_API.G_FALSE,
1662: p_count => x_MSG_COUNT,
1663: p_data => X_MSG_DATA);

Line 1661: p_encoded => FND_API.G_FALSE,

1657: WHEN FND_API.G_EXC_ERROR THEN
1658: x_formatted_rank := l_formatted_rank;
1659: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1660: FND_MSG_PUB.Count_And_Get(
1661: p_encoded => FND_API.G_FALSE,
1662: p_count => x_MSG_COUNT,
1663: p_data => X_MSG_DATA);
1664: RETURN;
1665: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1665: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1661: p_encoded => FND_API.G_FALSE,
1662: p_count => x_MSG_COUNT,
1663: p_data => X_MSG_DATA);
1664: RETURN;
1665: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1666: x_formatted_rank := l_formatted_rank;
1667: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
1668: FND_MSG_PUB.Count_And_Get(
1669: p_encoded => FND_API.G_FALSE,

Line 1667: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

1663: p_data => X_MSG_DATA);
1664: RETURN;
1665: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1666: x_formatted_rank := l_formatted_rank;
1667: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
1668: FND_MSG_PUB.Count_And_Get(
1669: p_encoded => FND_API.G_FALSE,
1670: p_count => x_MSG_COUNT,
1671: p_data => X_MSG_DATA);

Line 1669: p_encoded => FND_API.G_FALSE,

1665: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1666: x_formatted_rank := l_formatted_rank;
1667: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
1668: FND_MSG_PUB.Count_And_Get(
1669: p_encoded => FND_API.G_FALSE,
1670: p_count => x_MSG_COUNT,
1671: p_data => X_MSG_DATA);
1672: RETURN;
1673: WHEN OTHERS THEN

Line 1675: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

1671: p_data => X_MSG_DATA);
1672: RETURN;
1673: WHEN OTHERS THEN
1674: x_formatted_rank := l_formatted_rank;
1675: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
1676: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
1677: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
1678: FND_MSG_PUB.ADD;
1679: FND_MSG_PUB.Count_And_Get(

Line 1680: p_encoded => FND_API.G_FALSE,

1676: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
1677: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
1678: FND_MSG_PUB.ADD;
1679: FND_MSG_PUB.Count_And_Get(
1680: p_encoded => FND_API.G_FALSE,
1681: p_count => x_MSG_COUNT,
1682: p_data => X_MSG_DATA);
1683: RETURN;
1684: END get_formatted_rank;