DBA Data[Home] [Help]

APPS.CSC_CHECK_RATINGS_PVT dependencies on FND_MSG_PUB

Line 149: FND_MSG_PUB.initialize;

145:
146: -- Initialize message list if p_init_msg_list is set to TRUE.
147: IF FND_API.to_Boolean( p_init_msg_list )
148: THEN
149: FND_MSG_PUB.initialize;
150: END IF;
151:
152: -- Initialize API return status to SUCCESS
153: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 211: FND_MSG_PUB.Count_And_Get

207: END IF;
208:
209:
210: -- Standard call to get message count and if count is 1, get message info.
211: FND_MSG_PUB.Count_And_Get
212: ( p_count => x_msg_count,
213: p_data => x_msg_data
214: );
215:

Line 220: FND_MSG_PUB.Count_And_Get

216: EXCEPTION
217: WHEN FND_API.G_EXC_ERROR THEN
218: ROLLBACK TO Create_check_ratings_PVT;
219: x_return_status := FND_API.G_RET_STS_ERROR;
220: FND_MSG_PUB.Count_And_Get
221: ( p_count => x_msg_count,
222: p_data => x_msg_data
223: );
224: APP_EXCEPTION.RAISE_EXCEPTION;

Line 228: FND_MSG_PUB.Count_And_Get

224: APP_EXCEPTION.RAISE_EXCEPTION;
225: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
226: ROLLBACK TO Create_check_ratings_PVT;
227: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
228: FND_MSG_PUB.Count_And_Get
229: ( p_count => x_msg_count,
230: p_data => x_msg_data
231: );
232: APP_EXCEPTION.RAISE_EXCEPTION;

Line 236: FND_MSG_PUB.Build_Exc_Msg(G_PKG_NAME, l_api_name);

232: APP_EXCEPTION.RAISE_EXCEPTION;
233: WHEN OTHERS THEN
234: ROLLBACK TO Create_check_ratings_PVT;
235: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
236: FND_MSG_PUB.Build_Exc_Msg(G_PKG_NAME, l_api_name);
237: FND_MSG_PUB.Count_And_Get
238: ( p_count => x_msg_count,
239: p_data => x_msg_data
240: );

Line 237: FND_MSG_PUB.Count_And_Get

233: WHEN OTHERS THEN
234: ROLLBACK TO Create_check_ratings_PVT;
235: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
236: FND_MSG_PUB.Build_Exc_Msg(G_PKG_NAME, l_api_name);
237: FND_MSG_PUB.Count_And_Get
238: ( p_count => x_msg_count,
239: p_data => x_msg_data
240: );
241: APP_EXCEPTION.RAISE_EXCEPTION;

Line 357: FND_MSG_PUB.initialize;

353:
354: -- Initialize message list if p_init_msg_list is set to TRUE.
355: IF FND_API.to_Boolean( p_init_msg_list )
356: THEN
357: FND_MSG_PUB.initialize;
358: END IF;
359:
360:
361: -- Initialize API return status to SUCCESS

Line 385: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

381: l_old_CHK_RATING_rec.CREATED_BY,
382: l_old_CHK_RATING_rec.LAST_UPDATE_LOGIN,
383: l_old_CHK_RATING_rec.SEEDED_FLAG;
384: If ( C_Get_check_ratings%NOTFOUND) Then
385: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
386: THEN
387: CSC_CORE_UTILS_PVT.Record_Is_Locked_msg(p_Api_Name=> l_api_name);
388: END IF;
389: raise FND_API.G_EXC_ERROR;

Line 437: FND_MSG_PUB.Count_And_Get

433: END IF;
434:
435:
436: -- Standard call to get message count and if count is 1, get message info.
437: FND_MSG_PUB.Count_And_Get
438: ( p_count => x_msg_count,
439: p_data => x_msg_data
440: );
441:

Line 446: FND_MSG_PUB.Count_And_Get

442: EXCEPTION
443: WHEN FND_API.G_EXC_ERROR THEN
444: ROLLBACK TO Update_check_ratings_PVT;
445: x_return_status := FND_API.G_RET_STS_ERROR;
446: FND_MSG_PUB.Count_And_Get
447: ( p_count => x_msg_count,
448: p_data => x_msg_data
449: );
450: APP_EXCEPTION.RAISE_EXCEPTION;

Line 454: FND_MSG_PUB.Count_And_Get

450: APP_EXCEPTION.RAISE_EXCEPTION;
451: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
452: ROLLBACK TO Update_check_ratings_PVT;
453: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
454: FND_MSG_PUB.Count_And_Get
455: ( p_count => x_msg_count,
456: p_data => x_msg_data
457: );
458: APP_EXCEPTION.RAISE_EXCEPTION;

Line 462: FND_MSG_PUB.Build_Exc_Msg(G_PKG_NAME, l_api_name);

458: APP_EXCEPTION.RAISE_EXCEPTION;
459: WHEN OTHERS THEN
460: ROLLBACK TO Update_check_ratings_PVT;
461: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
462: FND_MSG_PUB.Build_Exc_Msg(G_PKG_NAME, l_api_name);
463: FND_MSG_PUB.Count_And_Get
464: ( p_count => x_msg_count,
465: p_data => x_msg_data
466: );

Line 463: FND_MSG_PUB.Count_And_Get

459: WHEN OTHERS THEN
460: ROLLBACK TO Update_check_ratings_PVT;
461: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
462: FND_MSG_PUB.Build_Exc_Msg(G_PKG_NAME, l_api_name);
463: FND_MSG_PUB.Count_And_Get
464: ( p_count => x_msg_count,
465: p_data => x_msg_data
466: );
467: APP_EXCEPTION.RAISE_EXCEPTION;

Line 502: FND_MSG_PUB.initialize;

498:
499: -- Initialize message list if p_init_msg_list is set to TRUE.
500: IF FND_API.to_Boolean( p_init_msg_list )
501: THEN
502: FND_MSG_PUB.initialize;
503: END IF;
504:
505: -- Initialize API return status to SUCCESS
506: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 528: FND_MSG_PUB.Count_And_Get

524:
525:
526:
527: -- Standard call to get message count and if count is 1, get message info.
528: FND_MSG_PUB.Count_And_Get
529: ( p_count => x_msg_count,
530: p_data => x_msg_data
531: );
532:

Line 537: FND_MSG_PUB.Count_And_Get

533: EXCEPTION
534: WHEN FND_API.G_EXC_ERROR THEN
535: ROLLBACK TO Delete_check_ratings_PVT;
536: x_return_status := FND_API.G_RET_STS_ERROR;
537: FND_MSG_PUB.Count_And_Get
538: ( p_count => x_msg_count,
539: p_data => x_msg_data
540: );
541: APP_EXCEPTION.RAISE_EXCEPTION;

Line 545: FND_MSG_PUB.Count_And_Get

541: APP_EXCEPTION.RAISE_EXCEPTION;
542: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
543: ROLLBACK TO Delete_check_ratings_PVT;
544: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
545: FND_MSG_PUB.Count_And_Get
546: ( p_count => x_msg_count,
547: p_data => x_msg_data
548: );
549: APP_EXCEPTION.RAISE_EXCEPTION;

Line 553: FND_MSG_PUB.Build_Exc_Msg(G_PKG_NAME, l_api_name);

549: APP_EXCEPTION.RAISE_EXCEPTION;
550: WHEN OTHERS THEN
551: ROLLBACK TO Delete_check_ratings_PVT;
552: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
553: FND_MSG_PUB.Build_Exc_Msg(G_PKG_NAME, l_api_name);
554: FND_MSG_PUB.Count_And_Get
555: ( p_count => x_msg_count,
556: p_data => x_msg_data
557: );

Line 554: FND_MSG_PUB.Count_And_Get

550: WHEN OTHERS THEN
551: ROLLBACK TO Delete_check_ratings_PVT;
552: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
553: FND_MSG_PUB.Build_Exc_Msg(G_PKG_NAME, l_api_name);
554: FND_MSG_PUB.Count_And_Get
555: ( p_count => x_msg_count,
556: p_data => x_msg_data
557: );
558: APP_EXCEPTION.RAISE_EXCEPTION;

Line 582: FND_MSG_PUB.initialize;

578:
579: -- Initialize message list if p_init_msg_list is set to TRUE.
580: IF FND_API.to_Boolean( p_init_msg_list )
581: THEN
582: FND_MSG_PUB.initialize;
583: END IF;
584:
585: -- Initialize API return status to SUCCESS
586: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 643: FND_MSG_PUB.Count_And_Get

639: END IF;
640: END IF;
641:
642: -- Standard call to get message count and if count is 1, get message info.
643: FND_MSG_PUB.Count_And_Get
644: ( p_count => x_msg_count,
645: p_data => x_msg_data
646: );
647:

Line 665: FND_MSG_PUB.initialize;

661: BEGIN
662: -- Initialize message list if p_init_msg_list is set to TRUE.
663: IF FND_API.to_Boolean( p_init_msg_list )
664: THEN
665: FND_MSG_PUB.initialize;
666: END IF;
667: -- Initialize API return status to SUCCESS
668: x_return_status := FND_API.G_RET_STS_SUCCESS;
669: -- validate NOT NULL column

Line 690: FND_MSG_PUB.Count_And_Get

686: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
687: NULL;
688: END IF;
689: -- Standard call to get message count and if count is 1, get message info.
690: FND_MSG_PUB.Count_And_Get
691: ( p_count => x_msg_count,
692: p_data => x_msg_data
693: );
694: END Validate_CHECK_RATING_GRADE;

Line 713: FND_MSG_PUB.initialize;

709:
710: -- Initialize message list if p_init_msg_list is set to TRUE.
711: IF FND_API.to_Boolean( p_init_msg_list )
712: THEN
713: FND_MSG_PUB.initialize;
714: END IF;
715:
716: -- Initialize API return status to SUCCESS
717: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 774: FND_MSG_PUB.Count_And_Get

770: END IF;
771: END IF;
772:
773: -- Standard call to get message count and if count is 1, get message info.
774: FND_MSG_PUB.Count_And_Get
775: ( p_count => x_msg_count,
776: p_data => x_msg_data
777: );
778: END Validate_RATING_CODE;