APPS.IEM_SUGG_DOC_RANK_PVT dependencies on FND_API

Line 40: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

36: where rownum<=5);
37:
38: BEGIN
39: -- Standard call to check for call compatibility.
40: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
41: p_api_version_number,
42: l_api_name,
43: G_PKG_NAME)
44: THEN

Line 45: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

41: p_api_version_number,
42: l_api_name,
43: G_PKG_NAME)
44: THEN
45: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
46: END IF;
47: x_return_status := FND_API.G_RET_STS_SUCCESS;
48: SAVEPOINT IEM_SUGG_PVT;
49: select * into l_class_id

Line 47: x_return_status := FND_API.G_RET_STS_SUCCESS;

43: G_PKG_NAME)
44: THEN
45: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
46: END IF;
47: x_return_status := FND_API.G_RET_STS_SUCCESS;
48: SAVEPOINT IEM_SUGG_PVT;
49: select * into l_class_id
50: from (select classification_id from iem_email_classifications
51: where message_id=p_message_id order by score desc)

Line 122: WHEN FND_API.G_EXC_ERROR THEN

118: ( p_count => x_msg_count,
119: p_data => x_msg_data
120: );
121: EXCEPTION
122: WHEN FND_API.G_EXC_ERROR THEN
123: x_return_status := FND_API.G_RET_STS_ERROR ;
124: rollback to IEM_SUGG_PVT;
125: FND_MSG_PUB.Count_And_Get
126: ( p_count => x_msg_count,

Line 123: x_return_status := FND_API.G_RET_STS_ERROR ;

119: p_data => x_msg_data
120: );
121: EXCEPTION
122: WHEN FND_API.G_EXC_ERROR THEN
123: x_return_status := FND_API.G_RET_STS_ERROR ;
124: rollback to IEM_SUGG_PVT;
125: FND_MSG_PUB.Count_And_Get
126: ( p_count => x_msg_count,
127: p_data => x_msg_data

Line 129: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

125: FND_MSG_PUB.Count_And_Get
126: ( p_count => x_msg_count,
127: p_data => x_msg_data
128: );
129: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
130: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
131: rollback to IEM_SUGG_PVT;
132: FND_MSG_PUB.Count_And_Get
133: ( p_count => x_msg_count,

Line 130: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

126: ( p_count => x_msg_count,
127: p_data => x_msg_data
128: );
129: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
130: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
131: rollback to IEM_SUGG_PVT;
132: FND_MSG_PUB.Count_And_Get
133: ( p_count => x_msg_count,
134: p_data => x_msg_data

Line 137: x_return_status := FND_API.G_RET_STS_ERROR;

133: ( p_count => x_msg_count,
134: p_data => x_msg_data
135: );
136: WHEN OTHERS THEN
137: x_return_status := FND_API.G_RET_STS_ERROR;
138: rollback to IEM_SUGG_PVT;
139: IF FND_MSG_PUB.Check_Msg_Level
140: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
141: THEN