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;
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
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;
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;
242: End Create_check_ratings;
243:
244:
245: PROCEDURE Update_check_ratings(
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;
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
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;
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;
468: End Update_check_ratings;
469:
470:
471: PROCEDURE Delete_check_ratings(
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;
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
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;
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;
559: End Delete_check_ratings;
560:
561: -- Item-level validation procedures
562: PROCEDURE Validate_CHECK_ID (