DBA Data[Home] [Help]

APPS.CSC_PROF_GROUP_CAT_PVT dependencies on APP_EXCEPTION

Line 202: APP_EXCEPTION.RAISE_EXCEPTION;

198: EXCEPTION
199: WHEN FND_API.G_EXC_ERROR THEN
200: ROLLBACK TO CREATE_CSC_PROF_GROUP_CAT_PVT;
201: x_return_status := FND_API.G_RET_STS_ERROR;
202: APP_EXCEPTION.RAISE_EXCEPTION;
203:
204: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
205: ROLLBACK TO CREATE_CSC_PROF_GROUP_CAT_PVT;
206: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 207: APP_EXCEPTION.RAISE_EXCEPTION;

203:
204: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
205: ROLLBACK TO CREATE_CSC_PROF_GROUP_CAT_PVT;
206: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
207: APP_EXCEPTION.RAISE_EXCEPTION;
208:
209: WHEN OTHERS THEN
210: ROLLBACK TO CREATE_CSC_PROF_GROUP_CAT_PVT;
211: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 213: APP_EXCEPTION.RAISE_EXCEPTION;

209: WHEN OTHERS THEN
210: ROLLBACK TO CREATE_CSC_PROF_GROUP_CAT_PVT;
211: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
212: FND_MSG_PUB.Build_Exc_Msg;
213: APP_EXCEPTION.RAISE_EXCEPTION;
214: End Create_csc_prof_group_cat;
215:
216: PROCEDURE Update_csc_prof_group_cat(
217: P_Api_Version_Number IN NUMBER,

Line 407: APP_EXCEPTION.RAISE_EXCEPTION;

403: EXCEPTION
404: WHEN FND_API.G_EXC_ERROR THEN
405: ROLLBACK TO UPDATE_CSC_PROF_GROUP_CAT_PVT;
406: x_return_status := FND_API.G_RET_STS_ERROR;
407: APP_EXCEPTION.RAISE_EXCEPTION;
408:
409: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
410: ROLLBACK TO UPDATE_CSC_PROF_GROUP_CAT_PVT;
411: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 412: APP_EXCEPTION.RAISE_EXCEPTION;

408:
409: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
410: ROLLBACK TO UPDATE_CSC_PROF_GROUP_CAT_PVT;
411: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
412: APP_EXCEPTION.RAISE_EXCEPTION;
413:
414: WHEN OTHERS THEN
415: ROLLBACK TO UPDATE_CSC_PROF_GROUP_CAT_PVT;
416: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 420: APP_EXCEPTION.RAISE_EXCEPTION;

416: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
417: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
418: FND_MSG_PUB.Build_Exc_Msg(G_PKG_NAME, l_api_name);
419: END IF;
420: APP_EXCEPTION.RAISE_EXCEPTION;
421:
422: End Update_csc_prof_group_cat;
423:
424:

Line 497: APP_EXCEPTION.RAISE_EXCEPTION;

493: --FND_MSG_PUB.Count_And_Get(
494: --p_count =>x_msg_count,
495: --p_data => x_msg_data
496: --);
497: APP_EXCEPTION.RAISE_EXCEPTION;
498:
499: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
500: ROLLBACK TO DELETE_CSC_PROF_GROUP_CAT_PVT;
501: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 504: APP_EXCEPTION.RAISE_EXCEPTION;

500: ROLLBACK TO DELETE_CSC_PROF_GROUP_CAT_PVT;
501: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
502: --FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
503: --p_data => x_msg_data) ;
504: APP_EXCEPTION.RAISE_EXCEPTION;
505:
506: WHEN OTHERS THEN
507: ROLLBACK TO DELETE_CSC_PROF_GROUP_CAT_PVT;
508: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 513: APP_EXCEPTION.RAISE_EXCEPTION;

509: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
510: THEN
511: FND_MSG_PUB.Build_Exc_Msg(G_PKG_NAME,l_api_name);
512: END IF ;
513: APP_EXCEPTION.RAISE_EXCEPTION;
514: End Delete_csc_prof_group_cat;
515:
516: -- Item-level validation procedures
517: PROCEDURE Validate_GROUP_CATEGORY_ID (