DBA Data[Home] [Help]

APPS.IGS_PR_CLSRNK_LGCY_PUB dependencies on FND_API

Line 119: IF NOT FND_API.Compatible_API_Call(

115: --Standard start of API savepoint
116: SAVEPOINT create_class_rank;
117:
118: --Standard call to check for call compatibility.
119: IF NOT FND_API.Compatible_API_Call(
120: l_api_version,
121: p_api_version,
122: l_api_name,
123: G_PKG_NAME)

Line 125: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

121: p_api_version,
122: l_api_name,
123: G_PKG_NAME)
124: THEN
125: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
126: END IF;
127:
128: --Initialize message list if p_init_msg_list is set to TRUE.
129: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 129: IF FND_API.to_Boolean(p_init_msg_list) THEN

125: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
126: END IF;
127:
128: --Initialize message list if p_init_msg_list is set to TRUE.
129: IF FND_API.to_Boolean(p_init_msg_list) THEN
130: FND_MSG_PUB.initialize;
131: END IF;
132:
133: --Initialize API return status to success.

Line 134: x_return_status := FND_API.G_RET_STS_SUCCESS;

130: FND_MSG_PUB.initialize;
131: END IF;
132:
133: --Initialize API return status to success.
134: x_return_status := FND_API.G_RET_STS_SUCCESS;
135:
136:
137: -- main code logic begins
138: /*

Line 145: RAISE FND_API.G_EXC_ERROR;

141: IF NOT validate_parameters
142: (
143: p_lgcy_clsrnk_rec => p_lgcy_clsrnk_rec
144: ) THEN
145: RAISE FND_API.G_EXC_ERROR;
146: END IF;
147: /*
148: derive the necessary data,
149: if this proc raised any error, exception

Line 217: IF FND_API.to_Boolean(p_commit) AND l_return = 'S' THEN

213: ELSE
214: x_return_status := l_return;
215: END IF;
216: --Standard check of p_commit.
217: IF FND_API.to_Boolean(p_commit) AND l_return = 'S' THEN
218: commit;
219: END IF;
220:
221: --Standard call to get message count and if count is 1, get message info.

Line 227: WHEN FND_API.G_EXC_ERROR THEN

223: p_count => x_msg_count,
224: p_data => x_msg_data);
225:
226: EXCEPTION
227: WHEN FND_API.G_EXC_ERROR THEN
228: ROLLBACK TO create_class_rank;
229: x_return_status := FND_API.G_RET_STS_ERROR;
230: FND_MSG_PUB.Count_And_Get(
231: p_count => x_msg_count,

Line 229: x_return_status := FND_API.G_RET_STS_ERROR;

225:
226: EXCEPTION
227: WHEN FND_API.G_EXC_ERROR THEN
228: ROLLBACK TO create_class_rank;
229: x_return_status := FND_API.G_RET_STS_ERROR;
230: FND_MSG_PUB.Count_And_Get(
231: p_count => x_msg_count,
232: p_data => x_msg_data);
233:

Line 234: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

230: FND_MSG_PUB.Count_And_Get(
231: p_count => x_msg_count,
232: p_data => x_msg_data);
233:
234: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
235: ROLLBACK TO create_class_rank;
236: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
237: FND_MSG_PUB.Count_And_Get(
238: p_count => x_msg_count,

Line 236: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

232: p_data => x_msg_data);
233:
234: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
235: ROLLBACK TO create_class_rank;
236: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
237: FND_MSG_PUB.Count_And_Get(
238: p_count => x_msg_count,
239: p_data => x_msg_data);
240: WHEN OTHERS THEN

Line 242: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

238: p_count => x_msg_count,
239: p_data => x_msg_data);
240: WHEN OTHERS THEN
241: ROLLBACK TO create_class_rank;
242: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
243: FND_MESSAGE.SET_NAME('IGS', 'IGS_AV_UNHANDLED_ERROR');
244: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
245: FND_MSG_PUB.ADD;
246: FND_MSG_PUB.Count_And_Get(

Line 379: RAISE FND_API.G_EXC_ERROR;

375: END IF;
376: END;
377:
378: IF NOT x_return_status THEN
379: RAISE FND_API.G_EXC_ERROR;
380: END IF;
381:
382: END derive_clsrnk_data;
383: