141:
142: -- Initialize message list if p_init_msg_list is set to TRUE.
143: IF FND_API.to_Boolean( p_init_msg_list )
144: THEN
145: FND_MSG_PUB.initialize;
146: END IF;
147:
148:
149: -- Initialize API return status to SUCCESS
204: COMMIT WORK;
205: END IF;
206:
207: -- Standard call to get message count and if count is 1, get message info.
208: FND_MSG_PUB.Count_And_Get
209: ( p_count => x_msg_count,
210: p_data => x_msg_data
211: );
212:
213: EXCEPTION
214: WHEN FND_API.G_EXC_ERROR THEN
215: ROLLBACK TO Create_group_checks_PVT;
216: x_return_status := FND_API.G_RET_STS_ERROR;
217: FND_MSG_PUB.Count_And_Get
218: ( p_count => x_msg_count,
219: p_data => x_msg_data
220: );
221: APP_EXCEPTION.RAISE_EXCEPTION;
221: APP_EXCEPTION.RAISE_EXCEPTION;
222: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
223: ROLLBACK TO Create_group_checks_PVT;
224: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
225: FND_MSG_PUB.Count_And_Get
226: ( p_count => x_msg_count,
227: p_data => x_msg_data
228: );
229: APP_EXCEPTION.RAISE_EXCEPTION;
229: APP_EXCEPTION.RAISE_EXCEPTION;
230: WHEN OTHERS THEN
231: ROLLBACK TO Create_group_checks_PVT;
232: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
233: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
234: FND_MSG_PUB.Count_And_Get
235: ( p_count => x_msg_count,
236: p_data => x_msg_data
237: );
230: WHEN OTHERS THEN
231: ROLLBACK TO Create_group_checks_PVT;
232: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
233: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
234: FND_MSG_PUB.Count_And_Get
235: ( p_count => x_msg_count,
236: p_data => x_msg_data
237: );
238: APP_EXCEPTION.RAISE_EXCEPTION;
357:
358: -- Initialize message list if p_init_msg_list is set to TRUE.
359: IF FND_API.to_Boolean( p_init_msg_list )
360: THEN
361: FND_MSG_PUB.initialize;
362: END IF;
363:
364:
365:
390: l_old_GROUP_CHK_rec.LAST_UPDATE_DATE,
391: l_old_GROUP_CHK_rec.LAST_UPDATE_LOGIN;
392:
393: If ( C_Get_group_checks%NOTFOUND) Then
394: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
395: THEN
396: CSC_CORE_UTILS_PVT.RECORD_IS_LOCKED_MSG(p_api_name=>l_api_name);
397: --FND_MESSAGE.Set_Name('CSC', 'API_MISSING_UPDATE_TARGET');
398: --FND_MESSAGE.Set_Token ('INFO', 'CSC_PROF_GROUP_CHECKS', FALSE);
395: THEN
396: CSC_CORE_UTILS_PVT.RECORD_IS_LOCKED_MSG(p_api_name=>l_api_name);
397: --FND_MESSAGE.Set_Name('CSC', 'API_MISSING_UPDATE_TARGET');
398: --FND_MESSAGE.Set_Token ('INFO', 'CSC_PROF_GROUP_CHECKS', FALSE);
399: --FND_MSG_PUB.Add;
400: END IF;
401: raise FND_API.G_EXC_ERROR;
402: END IF;
403:
445: END IF;
446:
447:
448: -- Standard call to get message count and if count is 1, get message info.
449: FND_MSG_PUB.Count_And_Get
450: ( p_count => x_msg_count,
451: p_data => x_msg_data
452: );
453:
454: EXCEPTION
455: WHEN FND_API.G_EXC_ERROR THEN
456: ROLLBACK TO Update_group_checks_PVT;
457: x_return_status := FND_API.G_RET_STS_ERROR;
458: FND_MSG_PUB.Count_And_Get
459: ( p_count => x_msg_count,
460: p_data => x_msg_data
461: );
462: APP_EXCEPTION.RAISE_EXCEPTION;
462: APP_EXCEPTION.RAISE_EXCEPTION;
463: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
464: ROLLBACK TO Update_group_checks_PVT;
465: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
466: FND_MSG_PUB.Count_And_Get
467: ( p_count => x_msg_count,
468: p_data => x_msg_data
469: );
470: APP_EXCEPTION.RAISE_EXCEPTION;
470: APP_EXCEPTION.RAISE_EXCEPTION;
471: WHEN OTHERS THEN
472: ROLLBACK TO Update_group_checks_PVT;
473: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
474: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
475: FND_MSG_PUB.Count_And_Get
476: ( p_count => x_msg_count,
477: p_data => x_msg_data
478: );
471: WHEN OTHERS THEN
472: ROLLBACK TO Update_group_checks_PVT;
473: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
474: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
475: FND_MSG_PUB.Count_And_Get
476: ( p_count => x_msg_count,
477: p_data => x_msg_data
478: );
479: APP_EXCEPTION.RAISE_EXCEPTION;
511:
512: -- Initialize message list if p_init_msg_list is set to TRUE.
513: IF FND_API.to_Boolean( p_init_msg_list )
514: THEN
515: FND_MSG_PUB.initialize;
516: END IF;
517:
518:
519:
541:
542:
543:
544: -- Standard call to get message count and if count is 1, get message info.
545: FND_MSG_PUB.Count_And_Get
546: ( p_count => x_msg_count,
547: p_data => x_msg_data
548: );
549:
550: EXCEPTION
551: WHEN FND_API.G_EXC_ERROR THEN
552: ROLLBACK TO Delete_group_checks_PVT;
553: x_return_status := FND_API.G_RET_STS_ERROR;
554: FND_MSG_PUB.Count_And_Get
555: ( p_count => x_msg_count,
556: p_data => x_msg_data
557: );
558: APP_EXCEPTION.RAISE_EXCEPTION;
558: APP_EXCEPTION.RAISE_EXCEPTION;
559: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
560: ROLLBACK TO Delete_group_checks_PVT;
561: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
562: FND_MSG_PUB.Count_And_Get
563: ( p_count => x_msg_count,
564: p_data => x_msg_data
565: );
566: APP_EXCEPTION.RAISE_EXCEPTION;
566: APP_EXCEPTION.RAISE_EXCEPTION;
567: WHEN OTHERS THEN
568: ROLLBACK TO Delete_group_checks_PVT;
569: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
570: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
571: FND_MSG_PUB.Count_And_Get
572: ( p_count => x_msg_count,
573: p_data => x_msg_data
574: );
567: WHEN OTHERS THEN
568: ROLLBACK TO Delete_group_checks_PVT;
569: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
570: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
571: FND_MSG_PUB.Count_And_Get
572: ( p_count => x_msg_count,
573: p_data => x_msg_data
574: );
575: APP_EXCEPTION.RAISE_EXCEPTION;
595:
596: -- Initialize message list if p_init_msg_list is set to TRUE.
597: IF FND_API.to_Boolean( p_init_msg_list )
598: THEN
599: FND_MSG_PUB.initialize;
600: END IF;
601:
602:
603: -- Initialize API return status to SUCCESS
651: END IF;
652: END IF;
653:
654: -- Standard call to get message count and if count is 1, get message info.
655: FND_MSG_PUB.Count_And_Get
656: ( p_count => x_msg_count,
657: p_data => x_msg_data
658: );
659:
678:
679: -- Initialize message list if p_init_msg_list is set to TRUE.
680: IF FND_API.to_Boolean( p_init_msg_list )
681: THEN
682: FND_MSG_PUB.initialize;
683: END IF;
684:
685:
686: -- Initialize API return status to SUCCESS
736: END IF;
737: END IF;
738:
739: -- Standard call to get message count and if count is 1, get message info.
740: FND_MSG_PUB.Count_And_Get
741: ( p_count => x_msg_count,
742: p_data => x_msg_data
743: );
744:
759:
760: -- Initialize message list if p_init_msg_list is set to TRUE.
761: IF FND_API.to_Boolean( p_init_msg_list )
762: THEN
763: FND_MSG_PUB.initialize;
764: END IF;
765:
766:
767: -- Initialize API return status to SUCCESS
793: NULL;
794: END IF;
795:
796: -- Standard call to get message count and if count is 1, get message info.
797: FND_MSG_PUB.Count_And_Get
798: ( p_count => x_msg_count,
799: p_data => x_msg_data
800: );
801:
817:
818: -- Initialize message list if p_init_msg_list is set to TRUE.
819: IF FND_API.to_Boolean( p_init_msg_list )
820: THEN
821: FND_MSG_PUB.initialize;
822: END IF;
823:
824:
825: -- Initialize API return status to SUCCESS
827:
828: NULL;
829:
830: -- Standard call to get message count and if count is 1, get message info.
831: FND_MSG_PUB.Count_And_Get
832: ( p_count => x_msg_count,
833: p_data => x_msg_data
834: );
835:
856:
857: -- Initialize message list if p_init_msg_list is set to TRUE.
858: IF FND_API.to_Boolean( p_init_msg_list )
859: THEN
860: FND_MSG_PUB.initialize;
861: END IF;
862:
863:
864: -- Initialize API return status to SUCCESS
892: END IF;
893: END IF;
894:
895: -- Standard call to get message count and if count is 1, get message info.
896: FND_MSG_PUB.Count_And_Get
897: ( p_count => x_msg_count,
898: p_data => x_msg_data
899: );
900:
915:
916: -- Initialize message list if p_init_msg_list is set to TRUE.
917: IF FND_API.to_Boolean( p_init_msg_list )
918: THEN
919: FND_MSG_PUB.initialize;
920: END IF;
921:
922:
923: -- Initialize API return status to SUCCESS
939: END IF;
940: END IF;
941:
942: -- Standard call to get message count and if count is 1, get message info.
943: FND_MSG_PUB.Count_And_Get
944: ( p_count => x_msg_count,
945: p_data => x_msg_data
946: );
947: