260: FND_MSG_PUB.Count_And_Get
261: ( p_count => x_msg_count,
262: p_data => x_msg_data
263: );
264: APP_EXCEPTION.RAISE_EXCEPTION;
265: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
266: ROLLBACK TO Create_Profile_Check_PVT;
267: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
268: FND_MSG_PUB.Count_And_Get
268: FND_MSG_PUB.Count_And_Get
269: ( p_count => x_msg_count,
270: p_data => x_msg_data
271: );
272: APP_EXCEPTION.RAISE_EXCEPTION;
273: WHEN OTHERS THEN
274: ROLLBACK TO Create_Profile_Check_PVT;
275: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
276: FND_MSG_PUB.Build_Exc_Msg(G_PKG_NAME, l_api_name);
277: FND_MSG_PUB.Count_And_Get
278: ( p_count => x_msg_count,
279: p_data => x_msg_data
280: );
281: APP_EXCEPTION.RAISE_EXCEPTION;
282: End Create_Profile_Check;
283:
284:
285: PROCEDURE Update_Profile_Check(
543: FND_MSG_PUB.Count_And_Get
544: ( p_encoded => FND_API.G_FALSE,p_count => x_msg_count,
545: p_data => x_msg_data
546: );
547: APP_EXCEPTION.RAISE_EXCEPTION;
548: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
549: ROLLBACK TO Update_Profile_check_PVT;
550: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
551: FND_MSG_PUB.Count_And_Get
551: FND_MSG_PUB.Count_And_Get
552: ( p_count => x_msg_count,
553: p_data => x_msg_data
554: );
555: APP_EXCEPTION.RAISE_EXCEPTION;
556: WHEN OTHERS THEN
557: ROLLBACK TO Update_Profile_check_PVT;
558: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
559: FND_MSG_PUB.Build_Exc_Msg(G_PKG_NAME, l_api_name);
560: FND_MSG_PUB.Count_And_Get
561: ( p_count => x_msg_count,
562: p_data => x_msg_data
563: );
564: APP_EXCEPTION.RAISE_EXCEPTION;
565: End Update_Profile_check;
566:
567: PROCEDURE Delete_profile_check(
568: P_Api_Version_Number IN NUMBER,
634: x_return_status := FND_API.G_RET_STS_ERROR;
635: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,p_count => x_msg_count,
636: p_data => x_msg_data
637: );
638: APP_EXCEPTION.RAISE_EXCEPTION;
639: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
640: ROLLBACK TO DELETE_Profile_Checks_PVT;
641: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
642: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
641: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
642: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
643: p_data => x_msg_data
644: );
645: APP_EXCEPTION.RAISE_EXCEPTION;
646: WHEN OTHERS THEN
647: ROLLBACK TO DELETE_Profile_Checks_PVT;
648: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
649: FND_MSG_PUB.Build_Exc_Msg(G_PKG_NAME, l_api_name);
649: FND_MSG_PUB.Build_Exc_Msg(G_PKG_NAME, l_api_name);
650: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
651: p_data => x_msg_data
652: );
653: APP_EXCEPTION.RAISE_EXCEPTION;
654: End Delete_profile_check;
655:
656:
657: