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_PUB dependencies on CSC_PROF_GROUP_CAT_PUB

Line 1: PACKAGE BODY CSC_PROF_GROUP_CAT_PUB as

1: PACKAGE BODY CSC_PROF_GROUP_CAT_PUB as
2: /* $Header: cscppcab.pls 115.8 2002/11/29 07:27:52 bhroy ship $ */
3: -- Start of Comments
4: -- Package name : CSC_PROF_GROUP_CAT_PUB
5: -- Purpose :

Line 4: -- Package name : CSC_PROF_GROUP_CAT_PUB

1: PACKAGE BODY CSC_PROF_GROUP_CAT_PUB as
2: /* $Header: cscppcab.pls 115.8 2002/11/29 07:27:52 bhroy ship $ */
3: -- Start of Comments
4: -- Package name : CSC_PROF_GROUP_CAT_PUB
5: -- Purpose :
6: -- History :
7: -- NOTE :
8: -- End of Comments

Line 11: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSC_PROF_GROUP_CAT_PUB';

7: -- NOTE :
8: -- End of Comments
9:
10:
11: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSC_PROF_GROUP_CAT_PUB';
12: G_FILE_NAME CONSTANT VARCHAR2(12) := 'cscppgcb.pls';
13:
14: -- Start of Comments
15:

Line 17: P_PROF_GRP_CAT_Rec IN CSC_PROF_GROUP_CAT_PUB.PROF_GRP_CAT_Rec_Type,

13:
14: -- Start of Comments
15:
16: PROCEDURE Convert_pub_to_pvt_Rec (
17: P_PROF_GRP_CAT_Rec IN CSC_PROF_GROUP_CAT_PUB.PROF_GRP_CAT_Rec_Type,
18: x_pvt_PROF_GRP_CAT_rec OUT NOCOPY CSC_PROF_GROUP_CAT_PVT.PROF_GRP_CAT_Rec_Type
19: )
20: IS
21: l_any_errors BOOLEAN := FALSE;

Line 143: SAVEPOINT CREATE_CSC_PROF_GROUP_CAT_PUB;

139: l_api_version_number CONSTANT NUMBER := 1.0;
140: l_pvt_PROF_GRP_CAT_rec CSC_PROF_GROUP_CAT_PVT.PROF_GRP_CAT_Rec_Type;
141: BEGIN
142: -- Standard Start of API savepoint
143: SAVEPOINT CREATE_CSC_PROF_GROUP_CAT_PUB;
144:
145: -- Standard call to check for call compatibility.
146: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
147: p_api_version_number,

Line 219: ROLLBACK TO CREATE_CSC_PROF_GROUP_CAT_PUB;

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

Line 225: ROLLBACK TO CREATE_CSC_PROF_GROUP_CAT_PUB;

221: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
222: p_data => x_msg_data) ;
223:
224: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
225: ROLLBACK TO CREATE_CSC_PROF_GROUP_CAT_PUB;
226: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
227: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
228: p_data => x_msg_data) ;
229:

Line 231: ROLLBACK TO CREATE_CSC_PROF_GROUP_CAT_PUB;

227: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
228: p_data => x_msg_data) ;
229:
230: WHEN OTHERS THEN
231: ROLLBACK TO CREATE_CSC_PROF_GROUP_CAT_PUB;
232: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
233: IF FND_MSG_PUB.Check_Msg_Level
234: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
235: THEN

Line 311: SAVEPOINT UPDATE_CSC_PROF_GROUP_CAT_PUB;

307: l_api_version_number CONSTANT NUMBER := 1.0;
308: l_pvt_PROF_GRP_CAT_rec CSC_PROF_GROUP_CAT_PVT.PROF_GRP_CAT_Rec_Type;
309: BEGIN
310: -- Standard Start of API savepoint
311: SAVEPOINT UPDATE_CSC_PROF_GROUP_CAT_PUB;
312:
313: -- Standard call to check for call compatibility.
314: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
315: p_api_version_number,

Line 384: ROLLBACK TO UPDATE_CSC_PROF_GROUP_CAT_PUB;

380: );
381:
382: EXCEPTION
383: WHEN FND_API.G_EXC_ERROR THEN
384: ROLLBACK TO UPDATE_CSC_PROF_GROUP_CAT_PUB;
385: x_return_status := FND_API.G_RET_STS_ERROR ;
386: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
387: p_data => x_msg_data) ;
388:

Line 391: ROLLBACK TO UPDATE_CSC_PROF_GROUP_CAT_PUB;

387: p_data => x_msg_data) ;
388:
389:
390: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
391: ROLLBACK TO UPDATE_CSC_PROF_GROUP_CAT_PUB;
392: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
393: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
394: p_data => x_msg_data) ;
395:

Line 397: ROLLBACK TO UPDATE_CSC_PROF_GROUP_CAT_PUB;

393: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
394: p_data => x_msg_data) ;
395:
396: WHEN OTHERS THEN
397: ROLLBACK TO UPDATE_CSC_PROF_GROUP_CAT_PUB;
398: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
399: IF FND_MSG_PUB.Check_Msg_Level
400: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
401: THEN

Line 428: SAVEPOINT DELETE_CSC_PROF_GROUP_CAT_PUB;

424: l_api_version_number CONSTANT NUMBER := 1.0;
425: l_pvt_PROF_GRP_CAT_rec CSC_PROF_GROUP_CAT_PVT.PROF_GRP_CAT_Rec_Type;
426: BEGIN
427: -- Standard Start of API savepoint
428: SAVEPOINT DELETE_CSC_PROF_GROUP_CAT_PUB;
429:
430: -- Standard call to check for call compatibility.
431: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
432: p_api_version_number,

Line 500: ROLLBACK TO DELETE_CSC_PROF_GROUP_CAT_PUB;

496: );
497:
498: EXCEPTION
499: WHEN FND_API.G_EXC_ERROR THEN
500: ROLLBACK TO DELETE_CSC_PROF_GROUP_CAT_PUB;
501: x_return_status := FND_API.G_RET_STS_ERROR ;
502: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
503: p_data => x_msg_data) ;
504:

Line 506: ROLLBACK TO DELETE_CSC_PROF_GROUP_CAT_PUB;

502: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
503: p_data => x_msg_data) ;
504:
505: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
506: ROLLBACK TO DELETE_CSC_PROF_GROUP_CAT_PUB;
507: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
508: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
509: p_data => x_msg_data) ;
510:

Line 512: ROLLBACK TO DELETE_CSC_PROF_GROUP_CAT_PUB;

508: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
509: p_data => x_msg_data) ;
510:
511: WHEN OTHERS THEN
512: ROLLBACK TO DELETE_CSC_PROF_GROUP_CAT_PUB;
513: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
514: IF FND_MSG_PUB.Check_Msg_Level
515: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
516: THEN

Line 524: End CSC_PROF_GROUP_CAT_PUB;

520: p_data => x_msg_data) ;
521:
522: End Delete_csc_prof_group_cat;
523:
524: End CSC_PROF_GROUP_CAT_PUB;