DBA Data[Home] [Help]

APPS.IGS_PE_CONFIG_PVT dependencies on FND_API

Line 100: IF NOT FND_API.Compatible_Api_Call( l_api_version,

96: -- default the x_result variable to true, so that if error occurs, then aslo the return status is TRUE
97:
98: x_result := 'TRUE' ;
99:
100: IF NOT FND_API.Compatible_Api_Call( l_api_version,
101: p_api_version,
102: l_api_name,
103: g_pkg_name) THEN
104:

Line 107: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

103: g_pkg_name) THEN
104:
105: -- if the versions of the API and the version passed are different then raise then
106: -- unexpected error message
107: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
108: END IF;
109:
110:
111: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 111: x_return_status := FND_API.G_RET_STS_SUCCESS;

107: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
108: END IF;
109:
110:
111: x_return_status := FND_API.G_RET_STS_SUCCESS;
112:
113: IF FND_API.to_Boolean (p_init_msg_list) THEN
114: FND_MSG_PUB.initialize;
115: END IF;

Line 113: IF FND_API.to_Boolean (p_init_msg_list) THEN

109:
110:
111: x_return_status := FND_API.G_RET_STS_SUCCESS;
112:
113: IF FND_API.to_Boolean (p_init_msg_list) THEN
114: FND_MSG_PUB.initialize;
115: END IF;
116:
117: -- API body

Line 198: WHEN FND_API.G_EXC_ERROR THEN

194: -- End of API body.
195:
196:
197: EXCEPTION
198: WHEN FND_API.G_EXC_ERROR THEN
199:
200: ROLLBACK TO sp_config;
201: x_result :='TRUE';
202: x_return_status := NVL(FND_API.G_RET_STS_ERROR,'E');

Line 202: x_return_status := NVL(FND_API.G_RET_STS_ERROR,'E');

198: WHEN FND_API.G_EXC_ERROR THEN
199:
200: ROLLBACK TO sp_config;
201: x_result :='TRUE';
202: x_return_status := NVL(FND_API.G_RET_STS_ERROR,'E');
203:
204:
205: FND_MSG_PUB.Count_And_Get (
206: -- p_encoded => FND_API.G_FALSE,

Line 206: -- p_encoded => FND_API.G_FALSE,

202: x_return_status := NVL(FND_API.G_RET_STS_ERROR,'E');
203:
204:
205: FND_MSG_PUB.Count_And_Get (
206: -- p_encoded => FND_API.G_FALSE,
207: p_count => x_msg_count,
208: p_data => x_msg_data );
209:
210: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 210: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

206: -- p_encoded => FND_API.G_FALSE,
207: p_count => x_msg_count,
208: p_data => x_msg_data );
209:
210: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
211:
212: ROLLBACK TO sp_config;
213: x_result :='TRUE';
214: x_return_status := NVL(FND_API.G_RET_STS_UNEXP_ERROR,'U');

Line 214: x_return_status := NVL(FND_API.G_RET_STS_UNEXP_ERROR,'U');

210: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
211:
212: ROLLBACK TO sp_config;
213: x_result :='TRUE';
214: x_return_status := NVL(FND_API.G_RET_STS_UNEXP_ERROR,'U');
215:
216: FND_MSG_PUB.Count_And_Get (
217: -- p_encoded => FND_API.G_FALSE,
218: p_count => x_msg_count,

Line 217: -- p_encoded => FND_API.G_FALSE,

213: x_result :='TRUE';
214: x_return_status := NVL(FND_API.G_RET_STS_UNEXP_ERROR,'U');
215:
216: FND_MSG_PUB.Count_And_Get (
217: -- p_encoded => FND_API.G_FALSE,
218: p_count => x_msg_count,
219: p_data => x_msg_data );
220:
221: WHEN OTHERS THEN

Line 225: x_return_status := NVL(FND_API.G_RET_STS_UNEXP_ERROR,'U');

221: WHEN OTHERS THEN
222:
223: ROLLBACK TO sp_config;
224: x_result :='TRUE';
225: x_return_status := NVL(FND_API.G_RET_STS_UNEXP_ERROR,'U');
226: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
227: THEN
228: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name );
229: END IF;

Line 237: --p_encoded => FND_API.G_FALSE,

233: -- FND_MESSAGE.SET_TOKEN('NAME','VERIFY_PE_INFO: '||SQLERRM);
234: -- FND_MSG_PUB.ADD;
235:
236: FND_MSG_PUB.Count_And_Get(
237: --p_encoded => FND_API.G_FALSE,
238: p_count => x_msg_count,
239: p_data => x_msg_data);
240:
241: END verify_pe_info ;

Line 290: IF NOT FND_API.Compatible_Api_Call( l_api_version,

286: BEGIN
287: -- Standard Start of API savepoint
288: SAVEPOINT sp_verify;
289:
290: IF NOT FND_API.Compatible_Api_Call( l_api_version,
291: p_api_version,
292: l_api_name,
293: g_pkg_name) THEN
294:

Line 297: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

293: g_pkg_name) THEN
294:
295: -- if the versions of the API and the version passed are different then raise then
296: -- unexpected error message
297: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
298: END IF;
299:
300: -- Initialize message list if p_init_msg_list is set to TRUE.
301:

Line 302: x_return_status := FND_API.G_RET_STS_SUCCESS;

298: END IF;
299:
300: -- Initialize message list if p_init_msg_list is set to TRUE.
301:
302: x_return_status := FND_API.G_RET_STS_SUCCESS;
303:
304: --Initialize message list if p_init_msg_list is set to TRUE.
305: IF FND_API.to_Boolean (p_init_msg_list) THEN
306: FND_MSG_PUB.initialize;

Line 305: IF FND_API.to_Boolean (p_init_msg_list) THEN

301:
302: x_return_status := FND_API.G_RET_STS_SUCCESS;
303:
304: --Initialize message list if p_init_msg_list is set to TRUE.
305: IF FND_API.to_Boolean (p_init_msg_list) THEN
306: FND_MSG_PUB.initialize;
307: END IF;
308:
309:

Line 369: IF FND_API.To_Boolean( p_commit ) THEN

365:
366: -- End of Updation.
367:
368: -- Standard check of p_commit.
369: IF FND_API.To_Boolean( p_commit ) THEN
370: COMMIT;
371: END IF;
372:
373: -- Standard call to get message count and if count is 1, get message info.

Line 380: WHEN FND_API.G_EXC_ERROR THEN

376: p_data => x_msg_data
377: );
378:
379: EXCEPTION
380: WHEN FND_API.G_EXC_ERROR THEN
381:
382: ROLLBACK TO sp_verify;
383: x_return_status := FND_API.G_RET_STS_ERROR;
384: FND_MSG_PUB.Count_And_Get (--p_encoded => FND_API.G_FALSE,

Line 383: x_return_status := FND_API.G_RET_STS_ERROR;

379: EXCEPTION
380: WHEN FND_API.G_EXC_ERROR THEN
381:
382: ROLLBACK TO sp_verify;
383: x_return_status := FND_API.G_RET_STS_ERROR;
384: FND_MSG_PUB.Count_And_Get (--p_encoded => FND_API.G_FALSE,
385: p_count => x_msg_count,
386: p_data => x_msg_data );
387:

Line 384: FND_MSG_PUB.Count_And_Get (--p_encoded => FND_API.G_FALSE,

380: WHEN FND_API.G_EXC_ERROR THEN
381:
382: ROLLBACK TO sp_verify;
383: x_return_status := FND_API.G_RET_STS_ERROR;
384: FND_MSG_PUB.Count_And_Get (--p_encoded => FND_API.G_FALSE,
385: p_count => x_msg_count,
386: p_data => x_msg_data );
387:
388: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 388: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

384: FND_MSG_PUB.Count_And_Get (--p_encoded => FND_API.G_FALSE,
385: p_count => x_msg_count,
386: p_data => x_msg_data );
387:
388: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
389:
390: ROLLBACK TO sp_verify;
391: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
392: FND_MSG_PUB.Count_And_Get ( --p_encoded => FND_API.G_FALSE,

Line 391: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

387:
388: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
389:
390: ROLLBACK TO sp_verify;
391: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
392: FND_MSG_PUB.Count_And_Get ( --p_encoded => FND_API.G_FALSE,
393: p_count => x_msg_count,
394: p_data => x_msg_data );
395:

Line 392: FND_MSG_PUB.Count_And_Get ( --p_encoded => FND_API.G_FALSE,

388: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
389:
390: ROLLBACK TO sp_verify;
391: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
392: FND_MSG_PUB.Count_And_Get ( --p_encoded => FND_API.G_FALSE,
393: p_count => x_msg_count,
394: p_data => x_msg_data );
395:
396: WHEN OTHERS THEN

Line 400: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

396: WHEN OTHERS THEN
397:
398: ROLLBACK TO sp_verify;
399:
400: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
401: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
402: THEN
403: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name );
404: END IF;

Line 409: FND_MSG_PUB.Count_And_Get(--p_encoded => FND_API.G_FALSE,

405: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
406: FND_MESSAGE.SET_TOKEN('NAME',' SET_PE_INFO_VERIFY_TIME: '||SQLERRM);
407: FND_MSG_PUB.ADD;
408:
409: FND_MSG_PUB.Count_And_Get(--p_encoded => FND_API.G_FALSE,
410: p_count => x_msg_count,
411: p_data => x_msg_data);
412: END set_pe_info_verify_time;
413: