126:
127: -- Initialize message list if p_init_msg_list is set to TRUE.
128: IF FND_API.to_Boolean( p_init_msg_list )
129: THEN
130: FND_MSG_PUB.initialize;
131: END IF;
132:
133:
134: -- Initialize API return status to SUCCESS
189:
190:
191:
192: -- Standard call to get message count and if count is 1, get message info.
193: FND_MSG_PUB.Count_And_Get
194: ( p_count => x_msg_count,
195: p_data => x_msg_data
196: );
197:
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;
215:
216: PROCEDURE Update_csc_prof_group_cat(
315:
316: -- Initialize message list if p_init_msg_list is set to TRUE.
317: IF FND_API.to_Boolean( p_init_msg_list )
318: THEN
319: FND_MSG_PUB.initialize;
320: END IF;
321:
322:
323:
344: l_old_PROF_GRP_CAT_rec.LAST_UPDATE_LOGIN,
345: l_old_PROF_GRP_CAT_rec.SEEDED_FLAG;
346:
347: If ( C_Get_csc_prof_group_cat%NOTFOUND) Then
348: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
349: THEN
350: CSC_CORE_UTILS_PVT.RECORD_IS_LOCKED_MSG(l_Api_Name);
351: END IF;
352: raise FND_API.G_EXC_ERROR;
394:
395:
396:
397: -- Standard call to get message count and if count is 1, get message info.
398: FND_MSG_PUB.Count_And_Get
399: ( p_count => x_msg_count,
400: p_data => x_msg_data
401: );
402:
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;
420: APP_EXCEPTION.RAISE_EXCEPTION;
421:
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;
420: APP_EXCEPTION.RAISE_EXCEPTION;
421:
422: End Update_csc_prof_group_cat;
452:
453: -- Initialize message list if p_init_msg_list is set to TRUE.
454: IF FND_API.to_Boolean( p_init_msg_list )
455: THEN
456: FND_MSG_PUB.initialize;
457: END IF;
458:
459:
460: -- Initialize API return status to SUCCESS
480:
481:
482:
483: -- Standard call to get message count and if count is 1, get message info.
484: FND_MSG_PUB.Count_And_Get
485: ( p_count => x_msg_count,
486: p_data => x_msg_data
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
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;
505:
506: WHEN OTHERS THEN
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);
512: END IF ;
513: APP_EXCEPTION.RAISE_EXCEPTION;
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);
512: END IF ;
513: APP_EXCEPTION.RAISE_EXCEPTION;
514: End Delete_csc_prof_group_cat;
515:
527:
528: -- Initialize message list if p_init_msg_list is set to TRUE.
529: IF FND_API.to_Boolean( p_init_msg_list )
530: THEN
531: FND_MSG_PUB.initialize;
532: END IF;
533:
534:
535: -- Initialize API return status to SUCCESS
557: NULL;
558: END IF;
559:
560: -- Standard call to get message count and if count is 1, get message info.
561: FND_MSG_PUB.Count_And_Get
562: ( p_count => x_msg_count,
563: p_data => x_msg_data
564: );
565:
584:
585: -- Initialize message list if p_init_msg_list is set to TRUE.
586: IF FND_API.to_Boolean( p_init_msg_list )
587: THEN
588: FND_MSG_PUB.initialize;
589: END IF;
590:
591:
592: -- Initialize API return status to SUCCESS
648: END IF;
649: END IF;
650:
651: -- Standard call to get message count and if count is 1, get message info.
652: FND_MSG_PUB.Count_And_Get
653: ( p_count => x_msg_count,
654: p_data => x_msg_data
655: );
656:
677:
678: -- Initialize message list if p_init_msg_list is set to TRUE.
679: IF FND_API.to_Boolean( p_init_msg_list )
680: THEN
681: FND_MSG_PUB.initialize;
682: END IF;
683:
684:
685: -- Initialize API return status to SUCCESS
725: END IF;
726: END IF;
727:
728: -- Standard call to get message count and if count is 1, get message info.
729: FND_MSG_PUB.Count_And_Get
730: ( p_count => x_msg_count,
731: p_data => x_msg_data
732: );
733:
747:
748: -- Initialize message list if p_init_msg_list is set to TRUE.
749: IF FND_API.to_Boolean( p_init_msg_list )
750: THEN
751: FND_MSG_PUB.initialize;
752: END IF;
753:
754:
755: -- Initialize API return status to SUCCESS
771: NULL;
772: END IF;
773:
774: -- Standard call to get message count and if count is 1, get message info.
775: FND_MSG_PUB.Count_And_Get
776: ( p_count => x_msg_count,
777: p_data => x_msg_data
778: );
779: