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

Line 7: -- 29 Nov 02 jamose made changes for the NOCOPY and FND_API.G_MISS*

3: -- Start of Comments
4: -- Package name : CSC_PROFILE_GROUPS_PVT
5: -- Purpose :
6: -- History :
7: -- 29 Nov 02 jamose made changes for the NOCOPY and FND_API.G_MISS*
8: -- NOTE :
9: -- End of Comments
10:
11:

Line 144: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

140: -- Standard Start of API savepoint
141: SAVEPOINT CREATE_PROFILE_GROUPS_PVT;
142:
143: -- Standard call to check for call compatibility.
144: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
145: p_api_version_number,
146: l_api_name,
147: G_PKG_NAME)
148: THEN

Line 149: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

145: p_api_version_number,
146: l_api_name,
147: G_PKG_NAME)
148: THEN
149: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
150: END IF;
151:
152:
153: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 154: IF FND_API.to_Boolean( p_init_msg_list )

150: END IF;
151:
152:
153: -- Initialize message list if p_init_msg_list is set to TRUE.
154: IF FND_API.to_Boolean( p_init_msg_list )
155: THEN
156: FND_MSG_PUB.initialize;
157: END IF;
158:

Line 161: x_return_status := FND_API.G_RET_STS_SUCCESS;

157: END IF;
158:
159:
160: -- Initialize API return status to SUCCESS
161: x_return_status := FND_API.G_RET_STS_SUCCESS;
162:
163: --
164: -- API body
165: --

Line 181: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

177: x_msg_count => x_msg_count,
178: x_msg_data => x_msg_data);
179: END IF;
180:
181: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
182: RAISE FND_API.G_EXC_ERROR;
183: END IF;
184:
185:

Line 182: RAISE FND_API.G_EXC_ERROR;

178: x_msg_data => x_msg_data);
179: END IF;
180:
181: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
182: RAISE FND_API.G_EXC_ERROR;
183: END IF;
184:
185:
186: -- Invoke table handler(CSC_PROF_GROUPS_PKG.Insert_Row)

Line 206: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

202: x_OBJECT_VERSION_NUMBER => X_OBJECT_VERSION_NUMBER,
203: p_APPLICATION_ID => p_PROF_GROUP_rec.APPLICATION_ID );
204:
205:
206: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
207: RAISE FND_API.G_EXC_ERROR;
208: END IF;
209:
210: --

Line 207: RAISE FND_API.G_EXC_ERROR;

203: p_APPLICATION_ID => p_PROF_GROUP_rec.APPLICATION_ID );
204:
205:
206: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
207: RAISE FND_API.G_EXC_ERROR;
208: END IF;
209:
210: --
211: -- End of API body

Line 215: IF FND_API.to_Boolean( p_commit )

211: -- End of API body
212: --
213:
214: -- Standard check for p_commit
215: IF FND_API.to_Boolean( p_commit )
216: THEN
217: COMMIT WORK;
218: END IF;
219:

Line 229: WHEN FND_API.G_EXC_ERROR THEN

225: p_data => x_msg_data
226: );
227:
228: EXCEPTION
229: WHEN FND_API.G_EXC_ERROR THEN
230: ROLLBACK TO Create_profile_groups_PVT;
231: x_return_status := FND_API.G_RET_STS_ERROR;
232: FND_MSG_PUB.Count_And_Get
233: ( p_count => x_msg_count,

Line 231: x_return_status := FND_API.G_RET_STS_ERROR;

227:
228: EXCEPTION
229: WHEN FND_API.G_EXC_ERROR THEN
230: ROLLBACK TO Create_profile_groups_PVT;
231: x_return_status := FND_API.G_RET_STS_ERROR;
232: FND_MSG_PUB.Count_And_Get
233: ( p_count => x_msg_count,
234: p_data => x_msg_data
235: );

Line 237: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

233: ( p_count => x_msg_count,
234: p_data => x_msg_data
235: );
236: APP_EXCEPTION.RAISE_EXCEPTION;
237: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
238: ROLLBACK TO Create_profile_groups_PVT;
239: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
240: FND_MSG_PUB.Count_And_Get
241: ( p_count => x_msg_count,

Line 239: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

235: );
236: APP_EXCEPTION.RAISE_EXCEPTION;
237: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
238: ROLLBACK TO Create_profile_groups_PVT;
239: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
240: FND_MSG_PUB.Count_And_Get
241: ( p_count => x_msg_count,
242: p_data => x_msg_data
243: );

Line 247: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

243: );
244: APP_EXCEPTION.RAISE_EXCEPTION;
245: WHEN OTHERS THEN
246: ROLLBACK TO Create_profile_groups_PVT;
247: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
248: FND_MSG_PUB.Build_Exc_Msg(G_PKG_NAME, l_api_name);
249: FND_MSG_PUB.Count_And_Get
250: ( p_count => x_msg_count,
251: p_data => x_msg_data

Line 362: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

Line 367: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 372: IF FND_API.to_Boolean( p_init_msg_list )

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

Line 380: x_return_status := FND_API.G_RET_STS_SUCCESS;

376:
377:
378:
379: -- Initialize API return status to SUCCESS
380: x_return_status := FND_API.G_RET_STS_SUCCESS;
381:
382: --
383: -- Api body
384: --

Line 413: raise FND_API.G_EXC_ERROR;

409: --FND_MESSAGE.Set_Name('CSC', 'API_MISSING_UPDATE_TARGET');
410: --FND_MESSAGE.Set_Token ('INFO', 'CSC_PROF_GROUPS', FALSE);
411: --FND_MSG_PUB.Add;
412: END IF;
413: raise FND_API.G_EXC_ERROR;
414: END IF;
415: IF C_Get_Profile_Groups%ISOPEN THEN
416: Close C_Get_profile_groups;
417: END IF;

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

416: Close C_Get_profile_groups;
417: END IF;
418:
419:
420: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
421: THEN
422:
423: -- Invoke validation procedures
424: Validate_profile_groups(

Line 434: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

430: x_msg_count => x_msg_count,
431: x_msg_data => x_msg_data);
432: END IF;
433:
434: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
435: RAISE FND_API.G_EXC_ERROR;
436: END IF;
437:
438:

Line 435: RAISE FND_API.G_EXC_ERROR;

431: x_msg_data => x_msg_data);
432: END IF;
433:
434: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
435: RAISE FND_API.G_EXC_ERROR;
436: END IF;
437:
438:
439: -- Invoke table handler(CSC_PROF_GROUPS_PKG.Update_Row)

Line 460: IF FND_API.to_Boolean( p_commit )

456: -- End of API body.
457: --
458:
459: -- Standard check for p_commit
460: IF FND_API.to_Boolean( p_commit )
461: THEN
462: COMMIT WORK;
463: END IF;
464:

Line 474: WHEN FND_API.G_EXC_ERROR THEN

470: p_data => x_msg_data
471: );
472:
473: EXCEPTION
474: WHEN FND_API.G_EXC_ERROR THEN
475: ROLLBACK TO Update_profile_groups_PVT;
476: x_return_status := FND_API.G_RET_STS_ERROR;
477: FND_MSG_PUB.Count_And_Get
478: ( p_count => x_msg_count,

Line 476: x_return_status := FND_API.G_RET_STS_ERROR;

472:
473: EXCEPTION
474: WHEN FND_API.G_EXC_ERROR THEN
475: ROLLBACK TO Update_profile_groups_PVT;
476: x_return_status := FND_API.G_RET_STS_ERROR;
477: FND_MSG_PUB.Count_And_Get
478: ( p_count => x_msg_count,
479: p_data => x_msg_data
480: );

Line 482: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

478: ( p_count => x_msg_count,
479: p_data => x_msg_data
480: );
481: APP_EXCEPTION.RAISE_EXCEPTION;
482: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
483: ROLLBACK TO Update_profile_groups_PVT;
484: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
485: FND_MSG_PUB.Count_And_Get
486: ( p_count => x_msg_count,

Line 484: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

480: );
481: APP_EXCEPTION.RAISE_EXCEPTION;
482: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
483: ROLLBACK TO Update_profile_groups_PVT;
484: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
485: FND_MSG_PUB.Count_And_Get
486: ( p_count => x_msg_count,
487: p_data => x_msg_data
488: );

Line 492: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

488: );
489: APP_EXCEPTION.RAISE_EXCEPTION;
490: WHEN OTHERS THEN
491: ROLLBACK TO Update_profile_groups_PVT;
492: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
493: FND_MSG_PUB.Build_Exc_Msg(G_PKG_NAME, l_api_name);
494: APP_EXCEPTION.RAISE_EXCEPTION;
495: End Update_profile_groups;
496:

Line 518: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

514: -- Standard Start of API savepoint
515: SAVEPOINT DELETE_PROFILE_GROUPS_PVT;
516:
517: -- Standard call to check for call compatibility.
518: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
519: p_api_version_number,
520: l_api_name,
521: G_PKG_NAME)
522: THEN

Line 523: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

519: p_api_version_number,
520: l_api_name,
521: G_PKG_NAME)
522: THEN
523: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
524: END IF;
525:
526:
527: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 528: IF FND_API.to_Boolean( p_init_msg_list )

524: END IF;
525:
526:
527: -- Initialize message list if p_init_msg_list is set to TRUE.
528: IF FND_API.to_Boolean( p_init_msg_list )
529: THEN
530: FND_MSG_PUB.initialize;
531: END IF;
532:

Line 536: x_return_status := FND_API.G_RET_STS_SUCCESS;

532:
533:
534:
535: -- Initialize API return status to SUCCESS
536: x_return_status := FND_API.G_RET_STS_SUCCESS;
537:
538: --
539: -- Api body
540: --

Line 550: IF FND_API.to_Boolean( p_commit )

546: --
547: -- End of API body
548: --
549: -- Standard check for p_commit
550: IF FND_API.to_Boolean( p_commit )
551: THEN
552: COMMIT WORK;
553: END IF;
554:

Line 563: WHEN FND_API.G_EXC_ERROR THEN

559: p_data => x_msg_data
560: );
561:
562: EXCEPTION
563: WHEN FND_API.G_EXC_ERROR THEN
564: ROLLBACK TO Delete_profile_groups_PVT;
565: x_return_status := FND_API.G_RET_STS_ERROR;
566: FND_MSG_PUB.Count_And_Get
567: ( p_count => x_msg_count,

Line 565: x_return_status := FND_API.G_RET_STS_ERROR;

561:
562: EXCEPTION
563: WHEN FND_API.G_EXC_ERROR THEN
564: ROLLBACK TO Delete_profile_groups_PVT;
565: x_return_status := FND_API.G_RET_STS_ERROR;
566: FND_MSG_PUB.Count_And_Get
567: ( p_count => x_msg_count,
568: p_data => x_msg_data
569: );

Line 571: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

567: ( p_count => x_msg_count,
568: p_data => x_msg_data
569: );
570: APP_EXCEPTION.RAISE_EXCEPTION;
571: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
572: ROLLBACK TO Delete_profile_groups_PVT;
573: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
574: FND_MSG_PUB.Count_And_Get
575: ( p_count => x_msg_count,

Line 573: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

569: );
570: APP_EXCEPTION.RAISE_EXCEPTION;
571: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
572: ROLLBACK TO Delete_profile_groups_PVT;
573: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
574: FND_MSG_PUB.Count_And_Get
575: ( p_count => x_msg_count,
576: p_data => x_msg_data
577: );

Line 581: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

577: );
578: APP_EXCEPTION.RAISE_EXCEPTION;
579: WHEN OTHERS THEN
580: ROLLBACK TO Delete_profile_groups_PVT;
581: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
582: FND_MSG_PUB.build_Exc_Msg(G_PKG_NAME, l_api_name);
583: FND_MSG_PUB.Count_And_Get
584: ( p_count => x_msg_count,
585: p_data => x_msg_data

Line 610: IF FND_API.to_Boolean( p_init_msg_list )

606: l_dummy Number;
607: BEGIN
608:
609: -- Initialize message list if p_init_msg_list is set to TRUE.
610: IF FND_API.to_Boolean( p_init_msg_list )
611: THEN
612: FND_MSG_PUB.initialize;
613: END IF;
614:

Line 616: x_return_status := FND_API.G_RET_STS_SUCCESS;

612: FND_MSG_PUB.initialize;
613: END IF;
614:
615: -- Initialize API return status to SUCCESS
616: x_return_status := FND_API.G_RET_STS_SUCCESS;
617:
618: -- validate NOT NULL column
619: IF(p_GROUP_NAME is NULL)
620: THEN

Line 621: x_return_status := FND_API.G_RET_STS_ERROR;

617:
618: -- validate NOT NULL column
619: IF(p_GROUP_NAME is NULL)
620: THEN
621: x_return_status := FND_API.G_RET_STS_ERROR;
622: CSC_CORE_UTILS_PVT.mandatory_arg_error(
623: p_api_name => p_api_name,
624: p_argument => 'p_GROUP_NAME',
625: p_argument_value => p_GROUP_NAME);

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

629: THEN
630: -- Hint: Validate data
631: -- IF p_GROUP_NAME is not NULL and p_GROUP_NAME <> G_MISS_CHAR
632: -- verify if data is valid
633: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
634: IF p_GROUP_NAME is not NULL and p_GROUP_NAME <> CSC_CORE_UTILS_PVT.G_MISS_CHAR
635: THEN
636: Open C1;
637: Fetch C1 into l_dummy;

Line 639: x_return_status := FND_API.G_RET_STS_ERROR;

635: THEN
636: Open C1;
637: Fetch C1 into l_dummy;
638: IF C1%FOUND THEN
639: x_return_status := FND_API.G_RET_STS_ERROR;
640: CSC_CORE_UTILS_PVT.Add_Duplicate_Value_Msg(
641: p_api_name => p_api_name,
642: p_argument => 'p_GROUP_NAME' ,
643: p_argument_value => p_GROUP_NAME);

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

649: THEN
650: -- Hint: Validate data
651: -- IF p_GROUP_NAME <> G_MISS_CHAR
652: -- verify if data is valid
653: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
654: IF p_GROUP_NAME <> CSC_CORE_UTILS_PVT.G_MISS_CHAR
655: THEN
656: FOR C1_REC IN C1 LOOP
657: IF c1_rec.group_id <> p_GROUP_ID THEN

Line 658: x_return_status := FND_API.G_RET_STS_ERROR;

654: IF p_GROUP_NAME <> CSC_CORE_UTILS_PVT.G_MISS_CHAR
655: THEN
656: FOR C1_REC IN C1 LOOP
657: IF c1_rec.group_id <> p_GROUP_ID THEN
658: x_return_status := FND_API.G_RET_STS_ERROR;
659: CSC_CORE_UTILS_PVT.Add_Duplicate_Value_Msg(
660: p_api_name => p_api_name,
661: p_argument => 'p_GROUP_NAME' ,
662: p_argument_value => p_GROUP_NAME);

Line 695: IF FND_API.to_Boolean( p_init_msg_list )

691: l_dummy Number;
692: BEGIN
693:
694: -- Initialize message list if p_init_msg_list is set to TRUE.
695: IF FND_API.to_Boolean( p_init_msg_list )
696: THEN
697: FND_MSG_PUB.initialize;
698: END IF;
699:

Line 702: x_return_status := FND_API.G_RET_STS_SUCCESS;

698: END IF;
699:
700:
701: -- Initialize API return status to SUCCESS
702: x_return_status := FND_API.G_RET_STS_SUCCESS;
703:
704: IF(p_validation_mode = CSC_CORE_UTILS_PVT.G_CREATE)
705: THEN
706: -- Hint: Validate data

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

705: THEN
706: -- Hint: Validate data
707: -- IF p_GROUP_NAME_CODE is not NULL and p_GROUP_NAME_CODE <> G_MISS_CHAR
708: -- verify if data is valid
709: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
710: IF p_GROUP_NAME_CODE is not NULL and p_GROUP_NAME_CODE <> CSC_CORE_UTILS_PVT.G_MISS_CHAR
711: THEN
712: Open C1;
713: Fetch C1 into l_dummy;

Line 715: x_return_status := FND_API.G_RET_STS_ERROR;

711: THEN
712: Open C1;
713: Fetch C1 into l_dummy;
714: IF C1%FOUND THEN
715: x_return_status := FND_API.G_RET_STS_ERROR;
716: CSC_CORE_UTILS_PVT.Add_Duplicate_Value_Msg(
717: p_api_name => p_api_name,
718: p_argument => 'p_GROUP_NAME_CODE' ,
719: p_argument_value => p_GROUP_NAME_CODE);

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

725: THEN
726: -- Hint: Validate data
727: -- IF p_GROUP_NAME_CODE <> G_MISS_CHAR
728: -- verify if data is valid
729: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
730: --no validate of group name code
731: NULL;
732: END IF;
733:

Line 757: IF FND_API.to_Boolean( p_init_msg_list )

753: IS
754: BEGIN
755:
756: -- Initialize message list if p_init_msg_list is set to TRUE.
757: IF FND_API.to_Boolean( p_init_msg_list )
758: THEN
759: FND_MSG_PUB.initialize;
760: END IF;
761:

Line 763: x_return_status := FND_API.G_RET_STS_SUCCESS;

759: FND_MSG_PUB.initialize;
760: END IF;
761:
762: -- Initialize API return status to SUCCESS
763: x_return_status := FND_API.G_RET_STS_SUCCESS;
764:
765: IF ( P_USE_IN_CUSTOMER_DASHBOARD <> CSC_CORE_UTILS_PVT.G_MISS_CHAR ) AND
766: ( P_USE_IN_CUSTOMER_DASHBOARD IS NOT NULL )
767: THEN

Line 771: p_lookup_code => P_USE_IN_CUSTOMER_DASHBOARD ) <> FND_API.G_RET_STS_SUCCESS

767: THEN
768: IF CSC_CORE_UTILS_PVT.lookup_code_not_exists(
769: p_effective_date => trunc(sysdate),
770: p_lookup_type => 'YES_NO',
771: p_lookup_code => P_USE_IN_CUSTOMER_DASHBOARD ) <> FND_API.G_RET_STS_SUCCESS
772: THEN
773: x_return_status := FND_API.G_RET_STS_ERROR;
774: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(
775: p_api_name => p_api_name,

Line 773: x_return_status := FND_API.G_RET_STS_ERROR;

769: p_effective_date => trunc(sysdate),
770: p_lookup_type => 'YES_NO',
771: p_lookup_code => P_USE_IN_CUSTOMER_DASHBOARD ) <> FND_API.G_RET_STS_SUCCESS
772: THEN
773: x_return_status := FND_API.G_RET_STS_ERROR;
774: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(
775: p_api_name => p_api_name,
776: p_argument_value => P_USE_IN_CUSTOMER_DASHBOARD,
777: p_argument => 'P_USE_IN_CUSTOMER_DASHBOARD');

Line 803: IF FND_API.to_Boolean( p_init_msg_list )

799: IS
800: BEGIN
801:
802: -- Initialize message list if p_init_msg_list is set to TRUE.
803: IF FND_API.to_Boolean( p_init_msg_list )
804: THEN
805: FND_MSG_PUB.initialize;
806: END IF;
807:

Line 810: x_return_status := FND_API.G_RET_STS_SUCCESS;

806: END IF;
807:
808:
809: -- Initialize API return status to SUCCESS
810: x_return_status := FND_API.G_RET_STS_SUCCESS;
811:
812: --Its a hardcode right now but should change i guess.***
813: IF ( P_SEEDED_FLAG IS NOT NULL AND
814: P_SEEDED_FLAG <> CSC_CORE_UTILS_PVT.G_MISS_CHAR ) THEN

Line 817: x_return_status := FND_API.G_RET_STS_ERROR;

813: IF ( P_SEEDED_FLAG IS NOT NULL AND
814: P_SEEDED_FLAG <> CSC_CORE_UTILS_PVT.G_MISS_CHAR ) THEN
815: IF P_SEEDED_FLAG NOT IN ('Y','N')
816: THEN
817: x_return_status := FND_API.G_RET_STS_ERROR;
818: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(
819: p_api_name => p_api_name,
820: p_argument_value => P_SEEDED_FLAG,
821: p_argument => 'P_SEEDED_FLAG');

Line 849: x_return_status := FND_API.G_RET_STS_SUCCESS;

845: BEGIN
846:
847:
848: -- Initialize API return status to SUCCESS
849: x_return_status := FND_API.G_RET_STS_SUCCESS;
850:
851: Validate_GROUP_NAME(
852: p_Api_Name => l_api_name,
853: p_init_msg_list => FND_API.G_FALSE,

Line 853: p_init_msg_list => FND_API.G_FALSE,

849: x_return_status := FND_API.G_RET_STS_SUCCESS;
850:
851: Validate_GROUP_NAME(
852: p_Api_Name => l_api_name,
853: p_init_msg_list => FND_API.G_FALSE,
854: p_validation_mode => p_validation_mode,
855: p_GROUP_NAME => P_PROF_GROUP_Rec.GROUP_NAME,
856: p_GROUP_ID => P_PROF_GROUP_Rec.GROUP_ID,
857: x_return_status => x_return_status,

Line 860: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

856: p_GROUP_ID => P_PROF_GROUP_Rec.GROUP_ID,
857: x_return_status => x_return_status,
858: x_msg_count => x_msg_count,
859: x_msg_data => x_msg_data);
860: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
861: raise FND_API.G_EXC_ERROR;
862: END IF;
863: Validate_GROUP_NAME_CODE(
864: p_Api_Name => l_api_name,

Line 861: raise FND_API.G_EXC_ERROR;

857: x_return_status => x_return_status,
858: x_msg_count => x_msg_count,
859: x_msg_data => x_msg_data);
860: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
861: raise FND_API.G_EXC_ERROR;
862: END IF;
863: Validate_GROUP_NAME_CODE(
864: p_Api_Name => l_api_name,
865: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,

Line 871: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

867: p_GROUP_NAME_CODE => P_PROF_GROUP_Rec.GROUP_NAME_CODE,
868: x_return_status => x_return_status,
869: x_msg_count => x_msg_count,
870: x_msg_data => x_msg_data);
871: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
872: raise FND_API.G_EXC_ERROR;
873: END IF;
874:
875: -- validate start and end date

Line 872: raise FND_API.G_EXC_ERROR;

868: x_return_status => x_return_status,
869: x_msg_count => x_msg_count,
870: x_msg_data => x_msg_data);
871: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
872: raise FND_API.G_EXC_ERROR;
873: END IF;
874:
875: -- validate start and end date
876: CSC_CORE_UTILS_PVT.Validate_Start_End_Dt(

Line 881: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

877: p_Api_name => l_Api_name,
878: p_START_DATE => P_PROF_GROUP_Rec.START_DATE_ACTIVE,
879: p_END_DATE => P_PROF_GROUP_Rec.END_DATE_ACTIVE,
880: x_return_status => x_return_status );
881: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
882: raise FND_API.G_EXC_ERROR;
883: END IF;
884:
885: Validate_IN_CUST_DASHBOARD(

Line 882: raise FND_API.G_EXC_ERROR;

878: p_START_DATE => P_PROF_GROUP_Rec.START_DATE_ACTIVE,
879: p_END_DATE => P_PROF_GROUP_Rec.END_DATE_ACTIVE,
880: x_return_status => x_return_status );
881: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
882: raise FND_API.G_EXC_ERROR;
883: END IF;
884:
885: Validate_IN_CUST_DASHBOARD(
886: p_Api_Name => l_api_name,

Line 893: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

889: p_USE_IN_CUSTOMER_DASHBOARD => P_PROF_GROUP_Rec.USE_IN_CUSTOMER_DASHBOARD,
890: x_return_status => x_return_status,
891: x_msg_count => x_msg_count,
892: x_msg_data => x_msg_data);
893: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
894: raise FND_API.G_EXC_ERROR;
895: END IF;
896: Validate_SEEDED_FLAG(
897: p_Api_Name => l_api_name,

Line 894: raise FND_API.G_EXC_ERROR;

890: x_return_status => x_return_status,
891: x_msg_count => x_msg_count,
892: x_msg_data => x_msg_data);
893: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
894: raise FND_API.G_EXC_ERROR;
895: END IF;
896: Validate_SEEDED_FLAG(
897: p_Api_Name => l_api_name,
898: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,

Line 904: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

900: p_SEEDED_FLAG => P_PROF_GROUP_Rec.SEEDED_FLAG,
901: x_return_status => x_return_status,
902: x_msg_count => x_msg_count,
903: x_msg_data => x_msg_data);
904: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
905: raise FND_API.G_EXC_ERROR;
906: END IF;
907:
908: CSC_CORE_UTILS_PVT.Validate_APPLICATION_ID (

Line 905: raise FND_API.G_EXC_ERROR;

901: x_return_status => x_return_status,
902: x_msg_count => x_msg_count,
903: x_msg_data => x_msg_data);
904: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
905: raise FND_API.G_EXC_ERROR;
906: END IF;
907:
908: CSC_CORE_UTILS_PVT.Validate_APPLICATION_ID (
909: P_Init_Msg_List => CSC_CORE_UTILS_PVT.G_FALSE,

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

912: X_Return_Status => x_return_status,
913: X_Msg_Count => x_msg_count,
914: X_Msg_Data => x_msg_data );
915:
916: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
917: RAISE FND_API.G_EXC_ERROR;
918: END IF;
919:
920:

Line 917: RAISE FND_API.G_EXC_ERROR;

913: X_Msg_Count => x_msg_count,
914: X_Msg_Data => x_msg_data );
915:
916: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
917: RAISE FND_API.G_EXC_ERROR;
918: END IF;
919:
920:
921: