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_MODULE_GROUPS_PVT dependencies on FND_API

Line 7: -- 26 Nov 02 JAmose Addition of NOCOPY and the Removal of Fnd_Api.G_MISS*

3: -- Start of Comments
4: -- Package name : CSC_PROF_MODULE_GROUPS_PVT
5: -- Purpose :
6: -- History :
7: -- 26 Nov 02 JAmose Addition of NOCOPY and the Removal of Fnd_Api.G_MISS*
8: -- from the definition for the performance reason
9: -- NOTE :
10: -- End of Comments
11:

Line 148: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

144: -- Standard Start of API savepoint
145: SAVEPOINT CREATE_PROF_MODULE_GROUPS_PVT;
146:
147: -- Standard call to check for call compatibility.
148: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
149: p_api_version_number,
150: l_api_name,
151: G_PKG_NAME)
152: THEN

Line 153: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

149: p_api_version_number,
150: l_api_name,
151: G_PKG_NAME)
152: THEN
153: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
154: END IF;
155:
156:
157: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 158: IF FND_API.to_Boolean( p_init_msg_list )

154: END IF;
155:
156:
157: -- Initialize message list if p_init_msg_list is set to TRUE.
158: IF FND_API.to_Boolean( p_init_msg_list )
159: THEN
160: FND_MSG_PUB.initialize;
161: END IF;
162:

Line 165: x_return_status := FND_API.G_RET_STS_SUCCESS;

161: END IF;
162:
163:
164: -- Initialize API return status to SUCCESS
165: x_return_status := FND_API.G_RET_STS_SUCCESS;
166:
167: --
168: -- API body
169: --

Line 172: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)

168: -- API body
169: --
170:
171:
172: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
173: THEN
174:
175: -- Invoke validation procedures
176: Validate_prof_module_groups(

Line 186: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

182: x_msg_count => x_msg_count,
183: x_msg_data => x_msg_data);
184: END IF;
185:
186: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
187: RAISE FND_API.G_EXC_ERROR;
188: END IF;
189:
190: -- Invoke table handler(CSC_PROF_MODULE_GROUPS_PKG.Insert_Row)

Line 187: RAISE FND_API.G_EXC_ERROR;

183: x_msg_data => x_msg_data);
184: END IF;
185:
186: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
187: RAISE FND_API.G_EXC_ERROR;
188: END IF;
189:
190: -- Invoke table handler(CSC_PROF_MODULE_GROUPS_PKG.Insert_Row)
191: CSC_PROF_MODULE_GROUPS_PKG.Insert_Row(

Line 212: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

208: p_DASHBOARD_GROUP_ID => p_PROF_MODULE_GRP_rec.DASHBOARD_GROUP_ID);
209:
210: -- x_MODULE_GROUP_ID := px_MODULE_GROUP_ID;
211:
212: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
213: RAISE FND_API.G_EXC_ERROR;
214: END IF;
215:
216: --

Line 213: RAISE FND_API.G_EXC_ERROR;

209:
210: -- x_MODULE_GROUP_ID := px_MODULE_GROUP_ID;
211:
212: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
213: RAISE FND_API.G_EXC_ERROR;
214: END IF;
215:
216: --
217: -- End of API body

Line 221: IF FND_API.to_Boolean( p_commit )

217: -- End of API body
218: --
219:
220: -- Standard check for p_commit
221: IF FND_API.to_Boolean( p_commit )
222: THEN
223: COMMIT WORK;
224: END IF;
225:

Line 234: WHEN FND_API.G_EXC_ERROR THEN

230: p_data => x_msg_data
231: );
232:
233: EXCEPTION
234: WHEN FND_API.G_EXC_ERROR THEN
235: ROLLBACK TO CREATE_PROF_MODULE_GROUPS_PVT;
236: x_return_status := FND_API.G_RET_STS_ERROR;
237: APP_EXCEPTION.RAISE_EXCEPTION;
238:

Line 236: x_return_status := FND_API.G_RET_STS_ERROR;

232:
233: EXCEPTION
234: WHEN FND_API.G_EXC_ERROR THEN
235: ROLLBACK TO CREATE_PROF_MODULE_GROUPS_PVT;
236: x_return_status := FND_API.G_RET_STS_ERROR;
237: APP_EXCEPTION.RAISE_EXCEPTION;
238:
239: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
240: ROLLBACK TO CREATE_PROF_MODULE_GROUPS_PVT;

Line 239: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

235: ROLLBACK TO CREATE_PROF_MODULE_GROUPS_PVT;
236: x_return_status := FND_API.G_RET_STS_ERROR;
237: APP_EXCEPTION.RAISE_EXCEPTION;
238:
239: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
240: ROLLBACK TO CREATE_PROF_MODULE_GROUPS_PVT;
241: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
242: APP_EXCEPTION.RAISE_EXCEPTION;
243:

Line 241: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

237: APP_EXCEPTION.RAISE_EXCEPTION;
238:
239: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
240: ROLLBACK TO CREATE_PROF_MODULE_GROUPS_PVT;
241: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
242: APP_EXCEPTION.RAISE_EXCEPTION;
243:
244: WHEN OTHERS THEN
245: ROLLBACK TO CREATE_PROF_MODULE_GROUPS_PVT;

Line 246: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

242: APP_EXCEPTION.RAISE_EXCEPTION;
243:
244: WHEN OTHERS THEN
245: ROLLBACK TO CREATE_PROF_MODULE_GROUPS_PVT;
246: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
247: FND_MSG_PUB.Build_Exc_Msg;
248: APP_EXCEPTION.RAISE_EXCEPTION;
249: End Create_prof_module_groups;
250:

Line 364: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

360: -- Standard Start of API savepoint
361: SAVEPOINT UPDATE_PROF_MODULE_GROUPS_PVT;
362:
363: -- Standard call to check for call compatibility.
364: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
365: p_api_version_number,
366: l_api_name,
367: G_PKG_NAME)
368: THEN

Line 369: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

365: p_api_version_number,
366: l_api_name,
367: G_PKG_NAME)
368: THEN
369: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
370: END IF;
371:
372:
373: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 374: IF FND_API.to_Boolean( p_init_msg_list )

370: END IF;
371:
372:
373: -- Initialize message list if p_init_msg_list is set to TRUE.
374: IF FND_API.to_Boolean( p_init_msg_list )
375: THEN
376: FND_MSG_PUB.initialize;
377: END IF;
378:

Line 382: x_return_status := FND_API.G_RET_STS_SUCCESS;

378:
379:
380:
381: -- Initialize API return status to SUCCESS
382: x_return_status := FND_API.G_RET_STS_SUCCESS;
383:
384: Open C_Get_prof_module_groups( P_PROF_MODULE_GRP_rec.MODULE_GROUP_ID);
385:
386: Fetch C_Get_prof_module_groups into

Line 412: raise FND_API.G_EXC_ERROR;

408: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
409: THEN
410: CSC_CORE_UTILS_PVT.RECORD_IS_LOCKED_MSG(p_Api_Name => l_api_name);
411: END IF;
412: raise FND_API.G_EXC_ERROR;
413:
414: END IF;
415: Close C_Get_prof_module_groups;
416:

Line 417: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)

413:
414: END IF;
415: Close C_Get_prof_module_groups;
416:
417: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
418: THEN
419: /*
420: IF p_prof_module_grp_rec.group_id = CSC_CORE_UTILS_PVT.G_MISS_NUM THEN
421: l_prof_module_grp_rec.group_id := l_old_prof_module_grp_rec.group_id;

Line 454: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

450: x_msg_count => x_msg_count,
451: x_msg_data => x_msg_data);
452: END IF;
453:
454: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
455: RAISE FND_API.G_EXC_ERROR;
456: END IF;
457:
458:

Line 455: RAISE FND_API.G_EXC_ERROR;

451: x_msg_data => x_msg_data);
452: END IF;
453:
454: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
455: RAISE FND_API.G_EXC_ERROR;
456: END IF;
457:
458:
459: -- Invoke table handler(CSC_PROF_MODULE_GROUPS_PKG.Update_Row)

Line 481: IF FND_API.to_Boolean( p_commit )

477: -- End of API body.
478: --
479:
480: -- Standard check for p_commit
481: IF FND_API.to_Boolean( p_commit )
482: THEN
483: COMMIT WORK;
484: END IF;
485:

Line 494: WHEN FND_API.G_EXC_ERROR THEN

490: p_data => x_msg_data
491: );
492:
493: EXCEPTION
494: WHEN FND_API.G_EXC_ERROR THEN
495: ROLLBACK TO UPDATE_PROF_MODULE_GROUPS_PVT;
496: x_return_status := FND_API.G_RET_STS_ERROR;
497: APP_EXCEPTION.RAISE_EXCEPTION;
498:

Line 496: x_return_status := FND_API.G_RET_STS_ERROR;

492:
493: EXCEPTION
494: WHEN FND_API.G_EXC_ERROR THEN
495: ROLLBACK TO UPDATE_PROF_MODULE_GROUPS_PVT;
496: x_return_status := FND_API.G_RET_STS_ERROR;
497: APP_EXCEPTION.RAISE_EXCEPTION;
498:
499: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
500: ROLLBACK TO UPDATE_PROF_MODULE_GROUPS_PVT;

Line 499: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

495: ROLLBACK TO UPDATE_PROF_MODULE_GROUPS_PVT;
496: x_return_status := FND_API.G_RET_STS_ERROR;
497: APP_EXCEPTION.RAISE_EXCEPTION;
498:
499: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
500: ROLLBACK TO UPDATE_PROF_MODULE_GROUPS_PVT;
501: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
502: APP_EXCEPTION.RAISE_EXCEPTION;
503:

Line 501: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

497: APP_EXCEPTION.RAISE_EXCEPTION;
498:
499: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
500: ROLLBACK TO UPDATE_PROF_MODULE_GROUPS_PVT;
501: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
502: APP_EXCEPTION.RAISE_EXCEPTION;
503:
504: WHEN OTHERS THEN
505: ROLLBACK TO UPDATE_PROF_MODULE_GROUPS_PVT;

Line 506: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

502: APP_EXCEPTION.RAISE_EXCEPTION;
503:
504: WHEN OTHERS THEN
505: ROLLBACK TO UPDATE_PROF_MODULE_GROUPS_PVT;
506: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
507: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
508: THEN
509: FND_MSG_PUB.Build_Exc_Msg(G_PKG_NAME, l_api_name);
510: END IF;

Line 534: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

530: -- Standard Start of API savepoint
531: SAVEPOINT DELETE_PROF_MODULE_GROUPS_PVT;
532:
533: -- Standard call to check for call compatibility.
534: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
535: p_api_version_number,
536: l_api_name,
537: G_PKG_NAME)
538: THEN

Line 539: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

535: p_api_version_number,
536: l_api_name,
537: G_PKG_NAME)
538: THEN
539: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
540: END IF;
541:
542:
543: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 544: IF FND_API.to_Boolean( p_init_msg_list )

540: END IF;
541:
542:
543: -- Initialize message list if p_init_msg_list is set to TRUE.
544: IF FND_API.to_Boolean( p_init_msg_list )
545: THEN
546: FND_MSG_PUB.initialize;
547: END IF;
548:

Line 551: x_return_status := FND_API.G_RET_STS_SUCCESS;

547: END IF;
548:
549:
550: -- Initialize API return status to SUCCESS
551: x_return_status := FND_API.G_RET_STS_SUCCESS;
552:
553: -- Invoke table handler(CSC_PROF_MODULE_GROUPS_PKG.Delete_Row)
554: CSC_PROF_MODULE_GROUPS_PKG.Delete_Row(
555: p_MODULE_GROUP_ID => p_PROF_MODULE_GRP_Id);

Line 561: IF FND_API.to_Boolean( p_commit )

557: -- End of API body
558: --
559:
560: -- Standard check for p_commit
561: IF FND_API.to_Boolean( p_commit )
562: THEN
563: COMMIT WORK;
564: END IF;
565:

Line 575: WHEN FND_API.G_EXC_ERROR THEN

571: p_data => x_msg_data
572: );
573:
574: EXCEPTION
575: WHEN FND_API.G_EXC_ERROR THEN
576: ROLLBACK TO DELETE_PROF_MODULE_GROUPS_PVT;
577: x_return_status := FND_API.G_RET_STS_ERROR ;
578: APP_EXCEPTION.RAISE_EXCEPTION;
579:

Line 577: x_return_status := FND_API.G_RET_STS_ERROR ;

573:
574: EXCEPTION
575: WHEN FND_API.G_EXC_ERROR THEN
576: ROLLBACK TO DELETE_PROF_MODULE_GROUPS_PVT;
577: x_return_status := FND_API.G_RET_STS_ERROR ;
578: APP_EXCEPTION.RAISE_EXCEPTION;
579:
580: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
581: ROLLBACK TO DELETE_PROF_MODULE_GROUPS_PVT;

Line 580: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

576: ROLLBACK TO DELETE_PROF_MODULE_GROUPS_PVT;
577: x_return_status := FND_API.G_RET_STS_ERROR ;
578: APP_EXCEPTION.RAISE_EXCEPTION;
579:
580: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
581: ROLLBACK TO DELETE_PROF_MODULE_GROUPS_PVT;
582: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
583: APP_EXCEPTION.RAISE_EXCEPTION;
584:

Line 582: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

578: APP_EXCEPTION.RAISE_EXCEPTION;
579:
580: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
581: ROLLBACK TO DELETE_PROF_MODULE_GROUPS_PVT;
582: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
583: APP_EXCEPTION.RAISE_EXCEPTION;
584:
585: WHEN OTHERS THEN
586: ROLLBACK TO DELETE_PROF_MODULE_GROUPS_PVT;

Line 587: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

583: APP_EXCEPTION.RAISE_EXCEPTION;
584:
585: WHEN OTHERS THEN
586: ROLLBACK TO DELETE_PROF_MODULE_GROUPS_PVT;
587: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
588: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
589: THEN
590: FND_MSG_PUB.Build_Exc_Msg(G_PKG_NAME,l_api_name);
591: END IF ;

Line 611: IF FND_API.to_Boolean( p_init_msg_list )

607: p_Api_Name VARCHAR2(100) := 'Validate_Module_Group_Id';
608: BEGIN
609:
610: -- Initialize message list if p_init_msg_list is set to TRUE.
611: IF FND_API.to_Boolean( p_init_msg_list )
612: THEN
613: FND_MSG_PUB.initialize;
614: END IF;
615:

Line 618: x_return_status := FND_API.G_RET_STS_SUCCESS;

614: END IF;
615:
616:
617: -- Initialize API return status to SUCCESS
618: x_return_status := FND_API.G_RET_STS_SUCCESS;
619:
620: -- validate NOT NULL column
621:
622: IF(p_validation_mode = CSC_CORE_UTILS_PVT.G_CREATE)

Line 627: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;

623: THEN
624: -- Hint: Validate data
625: -- IF p_MODULE_GROUP_ID is not NULL and p_MODULE_GROUP_ID <> G_MISS_CHAR
626: -- verify if data is valid
627: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
628: NULL;
629: ELSIF(p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE)
630: THEN
631: -- Hint: Validate data

Line 634: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;

630: THEN
631: -- Hint: Validate data
632: -- IF p_MODULE_GROUP_ID <> G_MISS_CHAR
633: -- verify if data is valid
634: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
635: -- NULL;
636: IF(p_MODULE_GROUP_ID is NULL)
637: THEN
638: x_return_status := FND_API.G_RET_STS_ERROR;

Line 638: x_return_status := FND_API.G_RET_STS_ERROR;

634: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
635: -- NULL;
636: IF(p_MODULE_GROUP_ID is NULL)
637: THEN
638: x_return_status := FND_API.G_RET_STS_ERROR;
639: END IF;
640: END IF;
641:
642: -- Standard call to get message count and if count is 1, get message info.

Line 673: IF FND_API.to_Boolean( p_init_msg_list )

669: BEGIN
670:
671:
672: -- Initialize message list if p_init_msg_list is set to TRUE.
673: IF FND_API.to_Boolean( p_init_msg_list )
674: THEN
675: FND_MSG_PUB.initialize;
676: END IF;
677:

Line 679: x_return_status := FND_API.G_RET_STS_SUCCESS;

675: FND_MSG_PUB.initialize;
676: END IF;
677:
678: -- Initialize API return status to SUCCESS
679: x_return_status := FND_API.G_RET_STS_SUCCESS;
680:
681: IF p_RESPONSIBILITY_ID is not NULL and p_RESPONSIBILITY_ID <> CSC_CORE_UTILS_PVT.G_MISS_CHAR
682: THEN
683: Open C1;

Line 686: x_return_status := FND_API.G_RET_STS_ERROR;

682: THEN
683: Open C1;
684: Fetch C1 INTO l_dummy;
685: IF C1%NOTFOUND THEN
686: x_return_status := FND_API.G_RET_STS_ERROR;
687: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(
688: p_api_name => p_api_name,
689: p_argument_value => p_Responsibility_id,
690: p_argument => 'P_RESPONSIBILITY_ID');

Line 724: IF FND_API.to_Boolean( p_init_msg_list )

720: BEGIN
721:
722:
723: -- Initialize message list if p_init_msg_list is set to TRUE.
724: IF FND_API.to_Boolean( p_init_msg_list )
725: THEN
726: FND_MSG_PUB.initialize;
727: END IF;
728:

Line 730: x_return_status := FND_API.G_RET_STS_SUCCESS;

726: FND_MSG_PUB.initialize;
727: END IF;
728:
729: -- Initialize API return status to SUCCESS
730: x_return_status := FND_API.G_RET_STS_SUCCESS;
731:
732: IF p_FORM_FUNCTION_NAME is not NULL and p_FORM_FUNCTION_NAME <> CSC_CORE_UTILS_PVT.G_MISS_CHAR
733: THEN
734: Open C1;

Line 737: x_return_status := FND_API.G_RET_STS_ERROR;

733: THEN
734: Open C1;
735: Fetch C1 INTO l_dummy;
736: IF C1%NOTFOUND THEN
737: x_return_status := FND_API.G_RET_STS_ERROR;
738: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(
739: p_api_name => p_api_name,
740: p_argument_value => p_form_function_name,
741: p_argument => 'P_FORM_FUNCTION_NAME');

Line 772: IF FND_API.to_Boolean( p_init_msg_list )

768:
769: BEGIN
770:
771: -- Initialize message list if p_init_msg_list is set to TRUE.
772: IF FND_API.to_Boolean( p_init_msg_list )
773: THEN
774: FND_MSG_PUB.initialize;
775: END IF;
776:

Line 779: x_return_status := FND_API.G_RET_STS_SUCCESS;

775: END IF;
776:
777:
778: -- Initialize API return status to SUCCESS
779: x_return_status := FND_API.G_RET_STS_SUCCESS;
780:
781:
782: IF p_FORM_FUNCTION_ID is not NULL and p_FORM_FUNCTION_ID <> CSC_CORE_UTILS_PVT.G_MISS_NUM
783: THEN

Line 788: x_return_status := FND_API.G_RET_STS_ERROR;

784: open C1;
785: fetch C1 INTO l_dummy;
786: if C1%NOTFOUND then
787: -- if the form_function_id is not valid its an invalid argument
788: x_return_status := FND_API.G_RET_STS_ERROR;
789: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(
790: p_api_name => p_api_name,
791: p_argument_value => p_form_function_id,
792: p_argument => 'P_FORM_FUNCTION_ID');

Line 819: IF FND_API.to_Boolean( p_init_msg_list )

815: p_Api_Name VARCHAR2(100) := 'Validate_Party_Type';
816: BEGIN
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:

Line 826: x_return_status := FND_API.G_RET_STS_SUCCESS;

822: END IF;
823:
824:
825: -- Initialize API return status to SUCCESS
826: x_return_status := FND_API.G_RET_STS_SUCCESS;
827:
828: IF(p_validation_mode = CSC_CORE_UTILS_PVT.G_CREATE)
829: THEN
830: -- Hint: Validate data

Line 833: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;

829: THEN
830: -- Hint: Validate data
831: -- IF p_PARTY_TYPE is not NULL and p_PARTY_TYPE <> G_MISS_CHAR
832: -- verify if data is valid
833: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
834: IF p_PARTY_TYPE is not NULL and p_PARTY_TYPE <> CSC_CORE_UTILS_PVT.G_MISS_CHAR
835: THEN
836: IF p_PARTY_TYPE NOT IN ('ALL','GROUP','PERSON','ORGANIZATION') THEN
837: x_return_status := FND_API.G_RET_STS_ERROR;

Line 837: x_return_status := FND_API.G_RET_STS_ERROR;

833: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
834: IF p_PARTY_TYPE is not NULL and p_PARTY_TYPE <> CSC_CORE_UTILS_PVT.G_MISS_CHAR
835: THEN
836: IF p_PARTY_TYPE NOT IN ('ALL','GROUP','PERSON','ORGANIZATION') THEN
837: x_return_status := FND_API.G_RET_STS_ERROR;
838: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(
839: p_api_name => p_api_name,
840: p_argument_value => p_PARTY_TYPE,
841: p_argument => 'P_PARTY_TYPE');

Line 849: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;

845: THEN
846: -- Hint: Validate data
847: -- IF p_PARTY_TYPE <> G_MISS_CHAR
848: -- verify if data is valid
849: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
850: IF p_PARTY_TYPE is not NULL and p_PARTY_TYPE <> CSC_CORE_UTILS_PVT.G_MISS_CHAR
851: THEN
852: IF p_PARTY_TYPE NOT IN ('ALL','GROUP','PERSON','ORGANIZATION') THEN
853: x_return_status := FND_API.G_RET_STS_ERROR;

Line 853: x_return_status := FND_API.G_RET_STS_ERROR;

849: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
850: IF p_PARTY_TYPE is not NULL and p_PARTY_TYPE <> CSC_CORE_UTILS_PVT.G_MISS_CHAR
851: THEN
852: IF p_PARTY_TYPE NOT IN ('ALL','GROUP','PERSON','ORGANIZATION') THEN
853: x_return_status := FND_API.G_RET_STS_ERROR;
854: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(
855: p_api_name => p_api_name,
856: p_argument_value => p_PARTY_TYPE,
857: p_argument => 'P_PARTY_TYPE');

Line 898: IF FND_API.to_Boolean( p_init_msg_list )

894: and nvl(use_in_customer_dashboard,'Y') = 'N';
895: BEGIN
896:
897: -- Initialize message list if p_init_msg_list is set to TRUE.
898: IF FND_API.to_Boolean( p_init_msg_list )
899: THEN
900: FND_MSG_PUB.initialize;
901: END IF;
902:

Line 905: x_return_status := FND_API.G_RET_STS_SUCCESS;

901: END IF;
902:
903:
904: -- Initialize API return status to SUCCESS
905: x_return_status := FND_API.G_RET_STS_SUCCESS;
906:
907: IF(p_validation_mode = CSC_CORE_UTILS_PVT.G_CREATE)
908: THEN
909: -- Hint: Validate data

Line 912: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;

908: THEN
909: -- Hint: Validate data
910: -- IF p_GROUP_ID is not NULL and p_GROUP_ID <> G_MISS_CHAR
911: -- verify if data is valid
912: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
913: /* IF p_GROUP_ID = CSC_CORE_UTILS_PVT.G_MISS_NUM
914: THEN
915: x_return_status := FND_API.G_RET_STS_ERROR;
916: CSC_CORE_UTILS_PVT.mandatory_arg_error(

Line 915: x_return_status := FND_API.G_RET_STS_ERROR;

911: -- verify if data is valid
912: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
913: /* IF p_GROUP_ID = CSC_CORE_UTILS_PVT.G_MISS_NUM
914: THEN
915: x_return_status := FND_API.G_RET_STS_ERROR;
916: CSC_CORE_UTILS_PVT.mandatory_arg_error(
917: p_api_name => p_api_name,
918: p_argument => 'p_GROUP_ID',
919: p_argument_value => p_GROUP_ID);

Line 926: x_return_status := FND_API.G_RET_STS_ERROR;

922: THEN
923: Open C1;
924: Fetch C1 into l_dummy;
925: IF C1%NOTFOUND THEN
926: x_return_status := FND_API.G_RET_STS_ERROR;
927: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(
928: p_api_name => p_api_name,
929: p_argument_value => p_GROUP_ID,
930: p_argument => 'P_GROUP_ID' );

Line 939: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;

935: THEN
936: -- Hint: Validate data
937: -- IF p_GROUP_ID <> G_MISS_CHAR
938: -- verify if data is valid
939: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
940: IF p_GROUP_ID is not NULL and p_GROUP_ID <> CSC_CORE_UTILS_PVT.G_MISS_NUM
941: THEN
942: Open C1;
943: Fetch C1 into l_dummy;

Line 945: x_return_status := FND_API.G_RET_STS_ERROR;

941: THEN
942: Open C1;
943: Fetch C1 into l_dummy;
944: IF C1%NOTFOUND THEN
945: x_return_status := FND_API.G_RET_STS_ERROR;
946: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(
947: p_api_name => p_api_name,
948: p_argument_value => p_GROUP_ID,
949: p_argument => 'P_GROUP_ID' );

Line 979: IF FND_API.to_Boolean( p_init_msg_list )

975:
976: null;
977: /*
978: -- Initialize message list if p_init_msg_list is set to TRUE.
979: IF FND_API.to_Boolean( p_init_msg_list )
980: THEN
981: FND_MSG_PUB.initialize;
982: END IF;
983:

Line 986: x_return_status := FND_API.G_RET_STS_SUCCESS;

982: END IF;
983:
984:
985: -- Initialize API return status to SUCCESS
986: x_return_status := FND_API.G_RET_STS_SUCCESS;
987:
988: -- validate NOT NULL column
989: IF(p_DASHBOARD_GROUP_FLAG is NULL)
990: THEN

Line 991: x_return_status := FND_API.G_RET_STS_ERROR;

987:
988: -- validate NOT NULL column
989: IF(p_DASHBOARD_GROUP_FLAG is NULL)
990: THEN
991: x_return_status := FND_API.G_RET_STS_ERROR;
992: CSC_CORE_UTILS_PVT.mandatory_arg_error(
993: p_api_name => p_api_name,
994: p_argument => 'P_DASHBOARD_GROUP_FLAG',
995: p_argument_value => p_dashboard_group_flag);

Line 1003: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;

999: THEN
1000: -- Hint: Validate data
1001: -- IF p_DASHBOARD_GROUP_FLAG is not NULL and p_DASHBOARD_GROUP_FLAG <> G_MISS_CHAR
1002: -- verify if data is valid
1003: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1004: IF p_DASHBOARD_GROUP_FLAG is not NULL AND
1005: p_DASHBOARD_GROUP_FLAG <> CSC_CORE_UTILS_PVT.G_MISS_CHAR
1006: THEN
1007: IF p_DASHBOARD_GROUP_FLAG NOT IN ('Y','N')

Line 1009: x_return_status := FND_API.G_RET_STS_ERROR;

1005: p_DASHBOARD_GROUP_FLAG <> CSC_CORE_UTILS_PVT.G_MISS_CHAR
1006: THEN
1007: IF p_DASHBOARD_GROUP_FLAG NOT IN ('Y','N')
1008: THEN
1009: x_return_status := FND_API.G_RET_STS_ERROR;
1010: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(
1011: p_api_name => p_api_name,
1012: p_argument_value => p_dashboard_group_flag,
1013: p_argument => 'P_DASHBOARD_GROUP_FLAG');

Line 1023: x_return_status := FND_API.G_RET_STS_ERROR;

1019: p_DASHBOARD_GROUP_FLAG <> CSC_CORE_UTILS_PVT.G_MISS_CHAR
1020: THEN
1021: IF p_DASHBOARD_GROUP_FLAG NOT IN ('Y','N')
1022: THEN
1023: x_return_status := FND_API.G_RET_STS_ERROR;
1024: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(
1025: p_api_name => p_api_name,
1026: p_argument_value => p_dashboard_group_flag,
1027: p_argument => 'P_Dashboard_Group_Flag');

Line 1056: IF FND_API.to_Boolean( p_init_msg_list )

1052: p_Api_Name VARCHAR2(100) := 'Validate_Currency_Code';
1053: BEGIN
1054:
1055: -- Initialize message list if p_init_msg_list is set to TRUE.
1056: IF FND_API.to_Boolean( p_init_msg_list )
1057: THEN
1058: FND_MSG_PUB.initialize;
1059: END IF;
1060:

Line 1063: x_return_status := FND_API.G_RET_STS_SUCCESS;

1059: END IF;
1060:
1061:
1062: -- Initialize API return status to SUCCESS
1063: x_return_status := FND_API.G_RET_STS_SUCCESS;
1064:
1065: IF (p_currency_Code <> CSC_CORE_UTILS_PVT.G_MISS_CHAR ) AND
1066: p_currency_code IS NOT NULL
1067: THEN

Line 1070: p_currency_code => p_currency_code ) <> FND_API.G_RET_STS_SUCCESS

1066: p_currency_code IS NOT NULL
1067: THEN
1068: IF CSC_CORE_UTILS_PVT.Currency_code_not_exists(
1069: p_effective_date => sysdate,
1070: p_currency_code => p_currency_code ) <> FND_API.G_RET_STS_SUCCESS
1071: THEN
1072:
1073: x_return_status := FND_API.G_RET_STS_ERROR;
1074: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(

Line 1073: x_return_status := FND_API.G_RET_STS_ERROR;

1069: p_effective_date => sysdate,
1070: p_currency_code => p_currency_code ) <> FND_API.G_RET_STS_SUCCESS
1071: THEN
1072:
1073: x_return_status := FND_API.G_RET_STS_ERROR;
1074: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(
1075: p_api_name => p_api_name,
1076: p_argument_value => p_currency_code,
1077: p_argument => 'P_CURRENCY_CODE');

Line 1138: IF FND_API.to_Boolean( p_init_msg_list )

1134:
1135: BEGIN
1136:
1137: -- Initialize message list if p_init_msg_list is set to TRUE.
1138: IF FND_API.to_Boolean( p_init_msg_list )
1139: THEN
1140: FND_MSG_PUB.initialize;
1141: END IF;
1142:

Line 1145: x_return_status := FND_API.G_RET_STS_SUCCESS;

1141: END IF;
1142:
1143:
1144: -- Initialize API return status to SUCCESS
1145: x_return_status := FND_API.G_RET_STS_SUCCESS;
1146:
1147: IF p_prof_module_grp_rec.form_function_name IS NULL then
1148: OPEN C1(p_PROF_MODULE_GRP_Rec.form_function_id);
1149: FETCH C1 into l_function_name;

Line 1160: x_return_status := FND_API.G_RET_STS_ERROR;

1156: or p_prof_module_grp_rec.group_id = CSC_CORE_UTILS_PVT.G_MISS_NUM )
1157: and ( p_prof_module_grp_rec.dashboard_group_id is null
1158: or p_prof_module_grp_rec.dashboard_group_id = CSC_CORE_UTILS_PVT.G_MISS_NUM ) then
1159:
1160: x_return_status := FND_API.G_RET_STS_ERROR;
1161: FND_MESSAGE.Set_Name('CSC', 'CSC_PROFILE_GROUP_UNDEFINED');
1162:
1163: End If;
1164:

Line 1174: x_return_status := FND_API.G_RET_STS_ERROR;

1170: Fetch C3 into x;
1171: Close C3;
1172:
1173: If x<>0 then -- and P_Validation_mode=CSC_CORE_UTILS_PVT.G_CREATE then
1174: x_return_status := FND_API.G_RET_STS_ERROR;
1175: FND_MESSAGE.Set_Name('CSC', 'CSC_PROFILE_DUPLICATE_RECORD');
1176: End If;
1177:
1178: elsif p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE then

Line 1187: x_return_status := FND_API.G_RET_STS_ERROR;

1183: Fetch C4 into x;
1184: Close C4;
1185:
1186: If x<>0 then
1187: x_return_status := FND_API.G_RET_STS_ERROR;
1188: FND_MESSAGE.Set_Name('CSC', 'CSC_PROFILE_DUPLICATE_RECORD');
1189: End If;
1190:
1191: end if;

Line 1229: IF FND_API.to_Boolean( p_init_msg_list )

1225: and nvl(use_in_customer_dashboard,'N') = 'Y';
1226: BEGIN
1227:
1228: -- Initialize message list if p_init_msg_list is set to TRUE.
1229: IF FND_API.to_Boolean( p_init_msg_list )
1230: THEN
1231: FND_MSG_PUB.initialize;
1232: END IF;
1233:

Line 1236: x_return_status := FND_API.G_RET_STS_SUCCESS;

1232: END IF;
1233:
1234:
1235: -- Initialize API return status to SUCCESS
1236: x_return_status := FND_API.G_RET_STS_SUCCESS;
1237:
1238: IF(p_validation_mode = CSC_CORE_UTILS_PVT.G_CREATE)
1239: THEN
1240: -- Hint: Validate data

Line 1243: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;

1239: THEN
1240: -- Hint: Validate data
1241: -- IF p_DASHBOARD_GROUP_ID is not NULL and p_DASHBOARD_GROUP_ID <> G_MISS_CHAR
1242: -- verify if data is valid
1243: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1244:
1245: IF p_DASHBOARD_GROUP_ID is not NULL and p_DASHBOARD_GROUP_ID <> CSC_CORE_UTILS_PVT.G_MISS_NUM
1246: THEN
1247: Open C1;

Line 1250: x_return_status := FND_API.G_RET_STS_ERROR;

1246: THEN
1247: Open C1;
1248: Fetch C1 into l_dummy;
1249: IF C1%NOTFOUND THEN
1250: x_return_status := FND_API.G_RET_STS_ERROR;
1251: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(
1252: p_api_name => p_api_name,
1253: p_argument_value => p_DASHBOARD_GROUP_ID,
1254: p_argument => 'P_DASHBOARD_GROUP_ID' );

Line 1263: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;

1259: THEN
1260: -- Hint: Validate data
1261: -- IF p_DASHBOARD_GROUP_ID <> G_MISS_CHAR
1262: -- verify if data is valid
1263: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1264: IF p_DASHBOARD_GROUP_ID is not NULL and p_DASHBOARD_GROUP_ID <> CSC_CORE_UTILS_PVT.G_MISS_NUM
1265: THEN
1266: Open C1;
1267: Fetch C1 into l_dummy;

Line 1269: x_return_status := FND_API.G_RET_STS_ERROR;

1265: THEN
1266: Open C1;
1267: Fetch C1 into l_dummy;
1268: IF C1%NOTFOUND THEN
1269: x_return_status := FND_API.G_RET_STS_ERROR;
1270: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(
1271: p_api_name => p_api_name,
1272: p_argument_value => p_DASHBOARD_GROUP_ID,
1273: p_argument => 'P_DASHBOARD_GROUP_ID' );

Line 1304: x_return_status := FND_API.G_RET_STS_SUCCESS;

1300: BEGIN
1301:
1302:
1303: -- Initialize API return status to SUCCESS
1304: x_return_status := FND_API.G_RET_STS_SUCCESS;
1305:
1306: IF (p_validation_level > CSC_CORE_UTILS_PVT.G_VALID_LEVEL_NONE) THEN
1307:
1308: Validate_MODULE_GROUP_ID(

Line 1315: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1311: p_MODULE_GROUP_ID => P_PROF_MODULE_GRP_Rec.MODULE_GROUP_ID,
1312: x_return_status => x_return_status,
1313: x_msg_count => x_msg_count,
1314: x_msg_data => x_msg_data);
1315: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1316: raise FND_API.G_EXC_ERROR;
1317: END IF;
1318:
1319: /* Validate_FORM_FUNCTION_ID(

Line 1316: raise FND_API.G_EXC_ERROR;

1312: x_return_status => x_return_status,
1313: x_msg_count => x_msg_count,
1314: x_msg_data => x_msg_data);
1315: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1316: raise FND_API.G_EXC_ERROR;
1317: END IF;
1318:
1319: /* Validate_FORM_FUNCTION_ID(
1320: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,

Line 1326: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1322: p_FORM_FUNCTION_ID => P_PROF_MODULE_GRP_Rec.FORM_FUNCTION_ID,
1323: x_return_status => x_return_status,
1324: x_msg_count => x_msg_count,
1325: x_msg_data => x_msg_data);
1326: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1327: raise FND_API.G_EXC_ERROR;
1328: END IF;
1329: */
1330:

Line 1327: raise FND_API.G_EXC_ERROR;

1323: x_return_status => x_return_status,
1324: x_msg_count => x_msg_count,
1325: x_msg_data => x_msg_data);
1326: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1327: raise FND_API.G_EXC_ERROR;
1328: END IF;
1329: */
1330:
1331: Validate_FORM_FUNCTION_NAME(

Line 1338: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1334: p_FORM_FUNCTION_NAME => P_PROF_MODULE_GRP_Rec.FORM_FUNCTION_NAME,
1335: x_return_status => x_return_status,
1336: x_msg_count => x_msg_count,
1337: x_msg_data => x_msg_data);
1338: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1339: raise FND_API.G_EXC_ERROR;
1340: END IF;
1341:
1342: Validate_FORM_FUNCTION_NAME(

Line 1339: raise FND_API.G_EXC_ERROR;

1335: x_return_status => x_return_status,
1336: x_msg_count => x_msg_count,
1337: x_msg_data => x_msg_data);
1338: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1339: raise FND_API.G_EXC_ERROR;
1340: END IF;
1341:
1342: Validate_FORM_FUNCTION_NAME(
1343: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,

Line 1349: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1345: p_FORM_FUNCTION_NAME => P_PROF_MODULE_GRP_Rec.FORM_FUNCTION_NAME,
1346: x_return_status => x_return_status,
1347: x_msg_count => x_msg_count,
1348: x_msg_data => x_msg_data);
1349: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1350: raise FND_API.G_EXC_ERROR;
1351: END IF;
1352:
1353: Validate_PARTY_TYPE(

Line 1350: raise FND_API.G_EXC_ERROR;

1346: x_return_status => x_return_status,
1347: x_msg_count => x_msg_count,
1348: x_msg_data => x_msg_data);
1349: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1350: raise FND_API.G_EXC_ERROR;
1351: END IF;
1352:
1353: Validate_PARTY_TYPE(
1354: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,

Line 1360: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1356: p_PARTY_TYPE => P_PROF_MODULE_GRP_Rec.PARTY_TYPE,
1357: x_return_status => x_return_status,
1358: x_msg_count => x_msg_count,
1359: x_msg_data => x_msg_data);
1360: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1361: raise FND_API.G_EXC_ERROR;
1362: END IF;
1363:
1364: Validate_GROUP_ID(

Line 1361: raise FND_API.G_EXC_ERROR;

1357: x_return_status => x_return_status,
1358: x_msg_count => x_msg_count,
1359: x_msg_data => x_msg_data);
1360: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1361: raise FND_API.G_EXC_ERROR;
1362: END IF;
1363:
1364: Validate_GROUP_ID(
1365: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,

Line 1372: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1368: P_PARTY_TYPE => P_PROF_MODULE_GRP_Rec.PARTY_TYPE,
1369: x_return_status => x_return_status,
1370: x_msg_count => x_msg_count,
1371: x_msg_data => x_msg_data);
1372: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1373: raise FND_API.G_EXC_ERROR;
1374: END IF;
1375:
1376: /* Validate_DASHBOARD_GROUP_FLAG(

Line 1373: raise FND_API.G_EXC_ERROR;

1369: x_return_status => x_return_status,
1370: x_msg_count => x_msg_count,
1371: x_msg_data => x_msg_data);
1372: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1373: raise FND_API.G_EXC_ERROR;
1374: END IF;
1375:
1376: /* Validate_DASHBOARD_GROUP_FLAG(
1377: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,

Line 1383: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1379: p_DASHBOARD_GROUP_FLAG => P_PROF_MODULE_GRP_Rec.DASHBOARD_GROUP_FLAG,
1380: x_return_status => x_return_status,
1381: x_msg_count => x_msg_count,
1382: x_msg_data => x_msg_data);
1383: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1384: raise FND_API.G_EXC_ERROR;
1385: END IF;
1386: */
1387:

Line 1384: raise FND_API.G_EXC_ERROR;

1380: x_return_status => x_return_status,
1381: x_msg_count => x_msg_count,
1382: x_msg_data => x_msg_data);
1383: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1384: raise FND_API.G_EXC_ERROR;
1385: END IF;
1386: */
1387:
1388: Validate_CURRENCY_CODE(

Line 1395: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1391: p_CURRENCY_CODE => P_PROF_MODULE_GRP_Rec.CURRENCY_CODE,
1392: x_return_status => x_return_status,
1393: x_msg_count => x_msg_count,
1394: x_msg_data => x_msg_data);
1395: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1396: raise FND_API.G_EXC_ERROR;
1397: END IF;
1398:
1399: --Validate seeded flag

Line 1396: raise FND_API.G_EXC_ERROR;

1392: x_return_status => x_return_status,
1393: x_msg_count => x_msg_count,
1394: x_msg_data => x_msg_data);
1395: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1396: raise FND_API.G_EXC_ERROR;
1397: END IF;
1398:
1399: --Validate seeded flag
1400:

Line 1406: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1402: p_api_name =>'CSC_PROF_MODULE_GROUPS_PVT.VALIDATE_SEEDED_FLAG',
1403: p_seeded_flag => p_PROF_MODULE_GRP_rec.seeded_flag,
1404: x_return_status => x_return_status );
1405:
1406: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1407: RAISE FND_API.G_EXC_ERROR;
1408: END IF;
1409:
1410: /* This Call added for Enhancement 1781726 for Validating Application_id*/

Line 1407: RAISE FND_API.G_EXC_ERROR;

1403: p_seeded_flag => p_PROF_MODULE_GRP_rec.seeded_flag,
1404: x_return_status => x_return_status );
1405:
1406: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1407: RAISE FND_API.G_EXC_ERROR;
1408: END IF;
1409:
1410: /* This Call added for Enhancement 1781726 for Validating Application_id*/
1411:

Line 1420: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1416: X_Msg_Count => x_msg_count,
1417: X_Msg_Data => x_msg_data,
1418: p_effective_date => SYSDATE );
1419:
1420: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1421: RAISE FND_API.G_EXC_ERROR;
1422: END IF;
1423:
1424: Validate_DASHBOARD_GROUP_ID(

Line 1421: RAISE FND_API.G_EXC_ERROR;

1417: X_Msg_Data => x_msg_data,
1418: p_effective_date => SYSDATE );
1419:
1420: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1421: RAISE FND_API.G_EXC_ERROR;
1422: END IF;
1423:
1424: Validate_DASHBOARD_GROUP_ID(
1425: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,

Line 1433: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1429: P_PARTY_TYPE => P_PROF_MODULE_GRP_Rec.PARTY_TYPE,
1430: x_return_status => x_return_status,
1431: x_msg_count => x_msg_count,
1432: x_msg_data => x_msg_data);
1433: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1434: raise FND_API.G_EXC_ERROR;
1435: END IF;
1436:
1437: Validate_PROF_MODULE_GRP_Rec(

Line 1434: raise FND_API.G_EXC_ERROR;

1430: x_return_status => x_return_status,
1431: x_msg_count => x_msg_count,
1432: x_msg_data => x_msg_data);
1433: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1434: raise FND_API.G_EXC_ERROR;
1435: END IF;
1436:
1437: Validate_PROF_MODULE_GRP_Rec(
1438: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,

Line 1444: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1440: p_PROF_MODULE_GRP_Rec => P_PROF_MODULE_GRP_Rec,
1441: x_return_status => x_return_status,
1442: x_msg_count => x_msg_count,
1443: x_msg_data => x_msg_data);
1444: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1445: raise FND_API.G_EXC_ERROR;
1446: END IF;
1447:
1448:

Line 1445: raise FND_API.G_EXC_ERROR;

1441: x_return_status => x_return_status,
1442: x_msg_count => x_msg_count,
1443: x_msg_data => x_msg_data);
1444: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1445: raise FND_API.G_EXC_ERROR;
1446: END IF;
1447:
1448:
1449: