APPS.IGS_PR_CLASS_RANK dependencies on FND_MSG_PUB

Line 1563: Fnd_Msg_Pub.Initialize;

1559: SELECT LTRIM (TO_CHAR (TO_DATE (cp_rank,'J'),'Jth'),'0') FROM DUAL;
1560: l_nth VARCHAR2(4000);
1561:
1562: BEGIN
1563: Fnd_Msg_Pub.Initialize;
1564: l_formatted_rank := NULL;
1565: -- validate parameters
1566: IF p_cohort_name IS NULL OR
1567: p_cal_type IS NULL OR

Line 1573: FND_MSG_PUB.ADD;

1569: p_person_id IS NULL OR
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

Line 1596: FND_MSG_PUB.ADD;

1592: FETCH c_rank INTO l_rank;
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:

Line 1651: Fnd_Msg_Pub.Count_And_Get(

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(
1652: p_encoded => Fnd_Api.G_FALSE,
1653: p_count => x_msg_count,
1654: p_data => x_msg_data);
1655:

Line 1660: FND_MSG_PUB.Count_And_Get(

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

Line 1668: FND_MSG_PUB.Count_And_Get(

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

Line 1678: FND_MSG_PUB.ADD;

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(
1680: p_encoded => FND_API.G_FALSE,
1681: p_count => x_MSG_COUNT,
1682: p_data => X_MSG_DATA);

Line 1679: FND_MSG_PUB.Count_And_Get(

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(
1680: p_encoded => FND_API.G_FALSE,
1681: p_count => x_MSG_COUNT,
1682: p_data => X_MSG_DATA);
1683: RETURN;