eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSC_PROF_GROUP_CAT_PVT dependencies on CSC_PROF_GROUP_CAT_PVT

Line 1: PACKAGE BODY CSC_PROF_GROUP_CAT_PVT as

1: PACKAGE BODY CSC_PROF_GROUP_CAT_PVT as
2: /* $Header: cscvpcab.pls 115.9 2002/12/03 19:27:39 jamose ship $ */
3: -- Start of Comments
4: -- Package name : CSC_PROF_GROUP_CAT_PVT
5: -- Purpose :

Line 4: -- Package name : CSC_PROF_GROUP_CAT_PVT

1: PACKAGE BODY CSC_PROF_GROUP_CAT_PVT as
2: /* $Header: cscvpcab.pls 115.9 2002/12/03 19:27:39 jamose ship $ */
3: -- Start of Comments
4: -- Package name : CSC_PROF_GROUP_CAT_PVT
5: -- Purpose :
6: -- History :
7: -- 27 Nov 02 jamose For Fnd_Api_G_Miss* and NOCOPY changes
8: -- NOTE :

Line 12: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSC_PROF_GROUP_CAT_PVT';

8: -- NOTE :
9: -- End of Comments
10:
11:
12: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSC_PROF_GROUP_CAT_PVT';
13: G_FILE_NAME CONSTANT VARCHAR2(12) := 'cscvpgcb.pls';
14:
15: PROCEDURE Convert_Columns_to_Rec (
16: p_GROUP_CATEGORY_ID NUMBER DEFAULT NULL,

Line 115: SAVEPOINT CREATE_CSC_PROF_GROUP_CAT_PVT;

111: l_api_version_number CONSTANT NUMBER := 1.0;
112: l_return_status_full VARCHAR2(1);
113: BEGIN
114: -- Standard Start of API savepoint
115: SAVEPOINT CREATE_CSC_PROF_GROUP_CAT_PVT;
116:
117: -- Standard call to check for call compatibility.
118: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
119: p_api_version_number,

Line 200: ROLLBACK TO CREATE_CSC_PROF_GROUP_CAT_PVT;

196: );
197:
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

Line 205: 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;
207: APP_EXCEPTION.RAISE_EXCEPTION;
208:
209: WHEN OTHERS THEN

Line 210: 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;
212: FND_MSG_PUB.Build_Exc_Msg;
213: APP_EXCEPTION.RAISE_EXCEPTION;
214: End Create_csc_prof_group_cat;

Line 300: l_old_PROF_GRP_CAT_rec csc_prof_group_cat_PVT.PROF_GRP_CAT_Rec_Type;

296:
297: l_api_name CONSTANT VARCHAR2(30) := 'Update_csc_prof_group_cat';
298: l_api_version_number CONSTANT NUMBER := 1.0;
299: -- Local Variables
300: l_old_PROF_GRP_CAT_rec csc_prof_group_cat_PVT.PROF_GRP_CAT_Rec_Type;
301: l_rowid ROWID;
302: BEGIN
303: -- Standard Start of API savepoint
304: SAVEPOINT UPDATE_CSC_PROF_GROUP_CAT_PVT;

Line 304: SAVEPOINT UPDATE_CSC_PROF_GROUP_CAT_PVT;

300: l_old_PROF_GRP_CAT_rec csc_prof_group_cat_PVT.PROF_GRP_CAT_Rec_Type;
301: l_rowid ROWID;
302: BEGIN
303: -- Standard Start of API savepoint
304: SAVEPOINT UPDATE_CSC_PROF_GROUP_CAT_PVT;
305:
306: -- Standard call to check for call compatibility.
307: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
308: p_api_version_number,

Line 405: ROLLBACK TO UPDATE_CSC_PROF_GROUP_CAT_PVT;

401: );
402:
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

Line 410: 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;
412: APP_EXCEPTION.RAISE_EXCEPTION;
413:
414: WHEN OTHERS THEN

Line 415: 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;
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;

Line 441: SAVEPOINT DELETE_CSC_PROF_GROUP_CAT_PVT;

437: l_api_name CONSTANT VARCHAR2(30) := 'Delete_csc_prof_group_cat';
438: l_api_version_number CONSTANT NUMBER := 1.0;
439: BEGIN
440: -- Standard Start of API savepoint
441: SAVEPOINT DELETE_CSC_PROF_GROUP_CAT_PVT;
442:
443: -- Standard call to check for call compatibility.
444: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
445: p_api_version_number,

Line 491: ROLLBACK TO DELETE_CSC_PROF_GROUP_CAT_PVT;

487: );
488:
489: EXCEPTION
490: WHEN FND_API.G_EXC_ERROR THEN
491: ROLLBACK TO DELETE_CSC_PROF_GROUP_CAT_PVT;
492: x_return_status := FND_API.G_RET_STS_ERROR ;
493: --FND_MSG_PUB.Count_And_Get(
494: --p_count =>x_msg_count,
495: --p_data => x_msg_data

Line 500: ROLLBACK TO DELETE_CSC_PROF_GROUP_CAT_PVT;

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 ;
502: --FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
503: --p_data => x_msg_data) ;
504: APP_EXCEPTION.RAISE_EXCEPTION;

Line 507: ROLLBACK TO DELETE_CSC_PROF_GROUP_CAT_PVT;

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 ;
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);

Line 853: p_api_name =>'CSC_PROF_GROUP_CAT_PVT.VALIDATE_SEEDED_FLAG',

849:
850: --Validate seeded flag
851:
852: CSC_CORE_UTILS_PVT.Validate_Seeded_Flag(
853: p_api_name =>'CSC_PROF_GROUP_CAT_PVT.VALIDATE_SEEDED_FLAG',
854: p_seeded_flag => p_PROF_GRP_CAT_rec.seeded_flag,
855: x_return_status => x_return_status );
856:
857: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 867: End CSC_PROF_GROUP_CAT_PVT;

863:
864:
865: END Validate_csc_prof_group_cat;
866:
867: End CSC_PROF_GROUP_CAT_PVT;