DBA Data[Home] [Help]

APPS.CSC_CHECK_RATINGS_PUB dependencies on FND_MSG_PUB

Line 170: FND_MSG_PUB.initialize;

166:
167: -- Initialize message list if p_init_msg_list is set to TRUE.
168: IF FND_API.to_Boolean( p_init_msg_list )
169: THEN
170: FND_MSG_PUB.initialize;
171: END IF;
172:
173:
174: -- Initialize API return status to SUCCESS

Line 217: FND_MSG_PUB.Count_And_Get

213: END IF;
214:
215:
216: -- Standard call to get message count and if count is 1, get message info.
217: FND_MSG_PUB.Count_And_Get
218: ( p_count => x_msg_count,
219: p_data => x_msg_data
220: );
221:

Line 226: FND_MSG_PUB.Count_And_Get

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

Line 233: FND_MSG_PUB.Count_And_Get

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

Line 240: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

236: );
237: WHEN OTHERS THEN
238: ROLLBACK TO Create_check_ratings_PUB;
239: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
240: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
241: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
242: END IF;
243: FND_MSG_PUB.Count_And_Get
244: ( p_count => x_msg_count,

Line 241: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

237: WHEN OTHERS THEN
238: ROLLBACK TO Create_check_ratings_PUB;
239: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
240: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
241: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
242: END IF;
243: FND_MSG_PUB.Count_And_Get
244: ( p_count => x_msg_count,
245: p_data => x_msg_data

Line 243: FND_MSG_PUB.Count_And_Get

239: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
240: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
241: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
242: END IF;
243: FND_MSG_PUB.Count_And_Get
244: ( p_count => x_msg_count,
245: p_data => x_msg_data
246: );
247: End Create_check_ratings;

Line 340: FND_MSG_PUB.initialize;

336:
337: -- Initialize message list if p_init_msg_list is set to TRUE.
338: IF FND_API.to_Boolean( p_init_msg_list )
339: THEN
340: FND_MSG_PUB.initialize;
341: END IF;
342:
343:
344: -- Initialize API return status to SUCCESS

Line 386: FND_MSG_PUB.Count_And_Get

382: END IF;
383:
384:
385: -- Standard call to get message count and if count is 1, get message info.
386: FND_MSG_PUB.Count_And_Get
387: ( p_count => x_msg_count,
388: p_data => x_msg_data
389: );
390:

Line 395: FND_MSG_PUB.Count_And_Get

391: EXCEPTION
392: WHEN FND_API.G_EXC_ERROR THEN
393: ROLLBACK TO Update_check_ratings_PUB;
394: x_return_status := FND_API.G_RET_STS_ERROR;
395: FND_MSG_PUB.Count_And_Get
396: ( p_count => x_msg_count,
397: p_data => x_msg_data
398: );
399: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 402: FND_MSG_PUB.Count_And_Get

398: );
399: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
400: ROLLBACK TO Update_check_ratings_PUB;
401: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
402: FND_MSG_PUB.Count_And_Get
403: ( p_count => x_msg_count,
404: p_data => x_msg_data
405: );
406: WHEN OTHERS THEN

Line 409: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

405: );
406: WHEN OTHERS THEN
407: ROLLBACK TO Update_check_ratings_PUB;
408: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
409: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
410: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
411: END IF;
412: FND_MSG_PUB.Count_And_Get
413: ( p_count => x_msg_count,

Line 410: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

406: WHEN OTHERS THEN
407: ROLLBACK TO Update_check_ratings_PUB;
408: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
409: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
410: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
411: END IF;
412: FND_MSG_PUB.Count_And_Get
413: ( p_count => x_msg_count,
414: p_data => x_msg_data

Line 412: FND_MSG_PUB.Count_And_Get

408: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
409: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
410: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
411: END IF;
412: FND_MSG_PUB.Count_And_Get
413: ( p_count => x_msg_count,
414: p_data => x_msg_data
415: );
416: End Update_check_ratings;

Line 450: FND_MSG_PUB.initialize;

446:
447: -- Initialize message list if p_init_msg_list is set to TRUE.
448: IF FND_API.to_Boolean( p_init_msg_list )
449: THEN
450: FND_MSG_PUB.initialize;
451: END IF;
452:
453:
454: -- Initialize API return status to SUCCESS

Line 493: FND_MSG_PUB.Count_And_Get

489: END IF;
490:
491:
492: -- Standard call to get message count and if count is 1, get message info.
493: FND_MSG_PUB.Count_And_Get
494: ( p_count => x_msg_count,
495: p_data => x_msg_data
496: );
497:

Line 502: FND_MSG_PUB.Count_And_Get

498: EXCEPTION
499: WHEN FND_API.G_EXC_ERROR THEN
500: ROLLBACK TO Delete_check_ratings_PUB;
501: x_return_status := FND_API.G_RET_STS_ERROR;
502: FND_MSG_PUB.Count_And_Get
503: ( p_count => x_msg_count,
504: p_data => x_msg_data
505: );
506: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 509: FND_MSG_PUB.Count_And_Get

505: );
506: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
507: ROLLBACK TO Delete_check_ratings_PUB;
508: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
509: FND_MSG_PUB.Count_And_Get
510: ( p_count => x_msg_count,
511: p_data => x_msg_data
512: );
513: WHEN OTHERS THEN

Line 516: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

512: );
513: WHEN OTHERS THEN
514: ROLLBACK TO Delete_check_ratings_PUB;
515: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
516: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
517: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
518: END IF;
519: FND_MSG_PUB.Count_And_Get
520: ( p_count => x_msg_count,

Line 517: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

513: WHEN OTHERS THEN
514: ROLLBACK TO Delete_check_ratings_PUB;
515: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
516: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
517: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
518: END IF;
519: FND_MSG_PUB.Count_And_Get
520: ( p_count => x_msg_count,
521: p_data => x_msg_data

Line 519: FND_MSG_PUB.Count_And_Get

515: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
516: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
517: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
518: END IF;
519: FND_MSG_PUB.Count_And_Get
520: ( p_count => x_msg_count,
521: p_data => x_msg_data
522: );
523: