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

Line 7: -- 27 Nov 02 jamose For Fnd_Api_G_Miss* and NOCOPY changes

3: -- Start of Comments
4: -- Package name : CSC_GROUP_CHECKS_PVT
5: -- Purpose :
6: -- History :
7: -- 27 Nov 02 jamose For Fnd_Api_G_Miss* and NOCOPY changes
8: -- NOTE :
9: -- End of Comments
10:
11:

Line 133: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

129: -- Standard Start of API savepoint
130: SAVEPOINT CREATE_GROUP_CHECKS_PVT;
131:
132: -- Standard call to check for call compatibility.
133: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
134: p_api_version_number,
135: l_api_name,
136: G_PKG_NAME)
137: THEN

Line 138: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

134: p_api_version_number,
135: l_api_name,
136: G_PKG_NAME)
137: THEN
138: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
139: END IF;
140:
141:
142: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 143: IF FND_API.to_Boolean( p_init_msg_list )

139: END IF;
140:
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:

Line 150: x_return_status := FND_API.G_RET_STS_SUCCESS;

146: END IF;
147:
148:
149: -- Initialize API return status to SUCCESS
150: x_return_status := FND_API.G_RET_STS_SUCCESS;
151:
152: --
153: -- API body
154: --

Line 170: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

166: x_msg_count => x_msg_count,
167: x_msg_data => x_msg_data);
168: END IF;
169:
170: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
171: RAISE FND_API.G_EXC_ERROR;
172: END IF;
173:
174:

Line 171: RAISE FND_API.G_EXC_ERROR;

167: x_msg_data => x_msg_data);
168: END IF;
169:
170: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
171: RAISE FND_API.G_EXC_ERROR;
172: END IF;
173:
174:
175: -- Invoke table handler(CSC_PROF_GROUP_CHECKS_PKG.Insert_Row)

Line 193: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

189: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
190: p_LAST_UPDATE_DATE => SYSDATE,
191: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID);
192:
193: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
194: RAISE FND_API.G_EXC_ERROR;
195: END IF;
196:
197: --

Line 194: RAISE FND_API.G_EXC_ERROR;

190: p_LAST_UPDATE_DATE => SYSDATE,
191: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID);
192:
193: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
194: RAISE FND_API.G_EXC_ERROR;
195: END IF;
196:
197: --
198: -- End of API body

Line 202: IF FND_API.to_Boolean( p_commit )

198: -- End of API body
199: --
200:
201: -- Standard check for p_commit
202: IF FND_API.to_Boolean( p_commit )
203: THEN
204: COMMIT WORK;
205: END IF;
206:

Line 214: WHEN FND_API.G_EXC_ERROR THEN

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,

Line 216: x_return_status := FND_API.G_RET_STS_ERROR;

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: );

Line 222: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

218: ( p_count => x_msg_count,
219: p_data => x_msg_data
220: );
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,

Line 224: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

220: );
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: );

Line 232: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

228: );
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

Line 349: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

345: -- Standard Start of API savepoint
346: SAVEPOINT UPDATE_GROUP_CHECKS_PVT;
347:
348: -- Standard call to check for call compatibility.
349: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
350: p_api_version_number,
351: l_api_name,
352: G_PKG_NAME)
353: THEN

Line 354: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

350: p_api_version_number,
351: l_api_name,
352: G_PKG_NAME)
353: THEN
354: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
355: END IF;
356:
357:
358: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 359: IF FND_API.to_Boolean( p_init_msg_list )

355: END IF;
356:
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:

Line 367: x_return_status := FND_API.G_RET_STS_SUCCESS;

363:
364:
365:
366: -- Initialize API return status to SUCCESS
367: x_return_status := FND_API.G_RET_STS_SUCCESS;
368:
369: --
370: -- Api body
371: --

Line 401: raise FND_API.G_EXC_ERROR;

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:
404: IF ( P_validation_level >= CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL)
405: THEN

Line 418: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

414: x_msg_count => x_msg_count,
415: x_msg_data => x_msg_data);
416: END IF;
417:
418: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
419: RAISE FND_API.G_EXC_ERROR;
420: END IF;
421: -- Invoke table handler(CSC_PROF_GROUP_CHECKS_PKG.Update_Row)
422: CSC_PROF_GROUP_CHECKS_PKG.Update_Row(

Line 419: RAISE FND_API.G_EXC_ERROR;

415: x_msg_data => x_msg_data);
416: END IF;
417:
418: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
419: RAISE FND_API.G_EXC_ERROR;
420: END IF;
421: -- Invoke table handler(CSC_PROF_GROUP_CHECKS_PKG.Update_Row)
422: CSC_PROF_GROUP_CHECKS_PKG.Update_Row(
423: p_GROUP_ID =>csc_core_utils_pvt.Get_G_Miss_num(p_GROUP_CHK_rec.GROUP_ID,l_old_GROUP_CHK_rec.GROUP_ID),

Line 442: IF FND_API.to_Boolean( p_commit )

438: -- End of API body.
439: --
440:
441: -- Standard check for p_commit
442: IF FND_API.to_Boolean( p_commit )
443: THEN
444: COMMIT WORK;
445: END IF;
446:

Line 455: WHEN FND_API.G_EXC_ERROR THEN

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,

Line 457: x_return_status := FND_API.G_RET_STS_ERROR;

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: );

Line 463: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

459: ( p_count => x_msg_count,
460: p_data => x_msg_data
461: );
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,

Line 465: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

461: );
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: );

Line 473: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

469: );
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

Line 503: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

499: -- Standard Start of API savepoint
500: SAVEPOINT DELETE_GROUP_CHECKS_PVT;
501:
502: -- Standard call to check for call compatibility.
503: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
504: p_api_version_number,
505: l_api_name,
506: G_PKG_NAME)
507: THEN

Line 508: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

504: p_api_version_number,
505: l_api_name,
506: G_PKG_NAME)
507: THEN
508: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
509: END IF;
510:
511:
512: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 513: IF FND_API.to_Boolean( p_init_msg_list )

509: END IF;
510:
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:

Line 521: x_return_status := FND_API.G_RET_STS_SUCCESS;

517:
518:
519:
520: -- Initialize API return status to SUCCESS
521: x_return_status := FND_API.G_RET_STS_SUCCESS;
522:
523: --
524: -- Api body
525: --

Line 537: IF FND_API.to_Boolean( p_commit )

533: -- End of API body
534: --
535:
536: -- Standard check for p_commit
537: IF FND_API.to_Boolean( p_commit )
538: THEN
539: COMMIT WORK;
540: END IF;
541:

Line 551: WHEN FND_API.G_EXC_ERROR THEN

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,

Line 553: x_return_status := FND_API.G_RET_STS_ERROR;

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: );

Line 559: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

555: ( p_count => x_msg_count,
556: p_data => x_msg_data
557: );
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,

Line 561: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

557: );
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: );

Line 569: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

565: );
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

Line 597: IF FND_API.to_Boolean( p_init_msg_list )

593: l_dummy number;
594: BEGIN
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:

Line 604: x_return_status := FND_API.G_RET_STS_SUCCESS;

600: END IF;
601:
602:
603: -- Initialize API return status to SUCCESS
604: x_return_status := FND_API.G_RET_STS_SUCCESS;
605:
606: -- validate NOT NULL column
607: IF(p_GROUP_ID is NULL)
608: THEN

Line 609: x_return_status := FND_API.G_RET_STS_ERROR;

605:
606: -- validate NOT NULL column
607: IF(p_GROUP_ID is NULL)
608: THEN
609: x_return_status := FND_API.G_RET_STS_ERROR;
610: CSC_CORE_UTILS_PVT.mandatory_arg_error(
611: p_api_name => p_api_name,
612: p_argument => 'p_GROUP_ID',
613: p_argument_value => p_GROUP_ID);

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

616: THEN
617: -- Hint: Validate data
618: -- IF p_GROUP_ID is not NULL and p_GROUP_ID <> CSC_CORE_UTILS_PVT.G_MISS_CHAR
619: -- verify if data is valid
620: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
621: IF p_GROUP_ID is not NULL and p_GROUP_ID <> CSC_CORE_UTILS_PVT.G_MISS_NUM
622: THEN
623: Open C1;
624: Fetch C1 into l_dummy;

Line 626: x_return_status := FND_API.G_RET_STS_ERROR;

622: THEN
623: Open C1;
624: Fetch C1 into l_dummy;
625: IF C1%NOTFOUND THEN
626: x_return_status := FND_API.G_RET_STS_ERROR;
627: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(
628: p_api_name => p_api_name,
629: p_argument_value => p_GROUP_ID,
630: p_argument => p_GROUP_ID);

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

635: THEN
636: -- Hint: Validate data
637: -- IF p_GROUP_ID <> G_MISS_CHAR
638: -- verify if data is valid
639: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
640: IF p_GROUP_ID <> CSC_CORE_UTILS_PVT.G_MISS_NUM THEN
641: Open C1;
642: Fetch C1 into l_dummy;
643: IF C1%NOTFOUND THEN

Line 644: x_return_status := FND_API.G_RET_STS_ERROR;

640: IF p_GROUP_ID <> CSC_CORE_UTILS_PVT.G_MISS_NUM THEN
641: Open C1;
642: Fetch C1 into l_dummy;
643: IF C1%NOTFOUND THEN
644: x_return_status := FND_API.G_RET_STS_ERROR;
645: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(
646: p_api_name => p_api_name,
647: p_argument_value => p_GROUP_ID,
648: p_argument => p_GROUP_ID);

Line 680: IF FND_API.to_Boolean( p_init_msg_list )

676: l_dummy number;
677: BEGIN
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:

Line 687: x_return_status := FND_API.G_RET_STS_SUCCESS;

683: END IF;
684:
685:
686: -- Initialize API return status to SUCCESS
687: x_return_status := FND_API.G_RET_STS_SUCCESS;
688:
689: -- validate NOT NULL column
690: IF(p_CHECK_ID is NULL)
691: THEN

Line 692: x_return_status := FND_API.G_RET_STS_ERROR;

688:
689: -- validate NOT NULL column
690: IF(p_CHECK_ID is NULL)
691: THEN
692: x_return_status := FND_API.G_RET_STS_ERROR;
693: CSC_CORE_UTILS_PVT.mandatory_arg_error(
694: p_api_name => p_api_name,
695: p_argument => 'p_CHECK_ID',
696: p_argument_value => p_CHECK_ID);

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

700: THEN
701: -- Hint: Validate data
702: -- IF p_CHECK_ID is not NULL and p_CHECK_ID <> G_MISS_CHAR
703: -- verify if data is valid
704: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
705: IF p_CHECK_ID is not NULL and p_CHECK_ID <> CSC_CORE_UTILS_PVT.G_MISS_NUM
706: THEN
707: Open C1;
708: Fetch C1 into l_dummy;

Line 710: x_return_status := FND_API.G_RET_STS_ERROR;

706: THEN
707: Open C1;
708: Fetch C1 into l_dummy;
709: IF C1%NOTFOUND THEN
710: x_return_status := FND_API.G_RET_STS_ERROR;
711: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(
712: p_api_name => p_api_name,
713: p_argument_value => p_CHECK_ID,
714: p_argument => p_CHECK_ID);

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

719: THEN
720: -- Hint: Validate data
721: -- IF p_CHECK_ID <> G_MISS_CHAR
722: -- verify if data is valid
723: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
724: IF p_CHECK_ID <> CSC_CORE_UTILS_PVT.G_MISS_NUM
725: THEN
726: Open C1;
727: Fetch C1 into l_dummy;

Line 729: x_return_status := FND_API.G_RET_STS_ERROR;

725: THEN
726: Open C1;
727: Fetch C1 into l_dummy;
728: IF C1%NOTFOUND THEN
729: x_return_status := FND_API.G_RET_STS_ERROR;
730: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(
731: p_api_name => p_api_name,
732: p_argument_value => p_CHECK_ID,
733: p_argument => p_CHECK_ID);

Line 761: IF FND_API.to_Boolean( p_init_msg_list )

757: IS
758: BEGIN
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:

Line 768: x_return_status := FND_API.G_RET_STS_SUCCESS;

764: END IF;
765:
766:
767: -- Initialize API return status to SUCCESS
768: x_return_status := FND_API.G_RET_STS_SUCCESS;
769:
770: -- validate NOT NULL column
771: IF(p_CHECK_SEQUENCE is NULL)
772: THEN

Line 773: x_return_status := FND_API.G_RET_STS_ERROR;

769:
770: -- validate NOT NULL column
771: IF(p_CHECK_SEQUENCE is NULL)
772: THEN
773: x_return_status := FND_API.G_RET_STS_ERROR;
774: CSC_CORE_UTILS_PVT.mandatory_arg_error(
775: p_api_name => p_api_name,
776: p_argument => 'p_CHECK_SEQUENCE',
777: p_argument_value => p_CHECK_SEQUENCE);

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

781: THEN
782: -- Hint: Validate data
783: -- IF p_CHECK_SEQUENCE is not NULL and p_CHECK_SEQUENCE <> G_MISS_CHAR
784: -- verify if data is valid
785: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
786: NULL;
787: ELSIF(p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE)
788: THEN
789: -- Hint: Validate data

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

788: THEN
789: -- Hint: Validate data
790: -- IF p_CHECK_SEQUENCE <> G_MISS_CHAR
791: -- verify if data is valid
792: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
793: NULL;
794: END IF;
795:
796: -- Standard call to get message count and if count is 1, get message info.

Line 819: IF FND_API.to_Boolean( p_init_msg_list )

815: IS
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: NULL;
829:
830: -- Standard call to get message count and if count is 1, get message info.

Line 858: IF FND_API.to_Boolean( p_init_msg_list )

854: l_dummy number;
855: BEGIN
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:

Line 865: x_return_status := FND_API.G_RET_STS_SUCCESS;

861: END IF;
862:
863:
864: -- Initialize API return status to SUCCESS
865: x_return_status := FND_API.G_RET_STS_SUCCESS;
866:
867: IF(p_validation_mode = CSC_CORE_UTILS_PVT.G_CREATE)
868: THEN
869: -- Hint: Validate data

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

868: THEN
869: -- Hint: Validate data
870: -- IF p_CATEGORY_SEQUENCE is not NULL and p_CATEGORY_SEQUENCE <> G_MISS_CHAR
871: -- verify if data is valid
872: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
873: NULL;
874: ELSIF(p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE)
875: THEN
876: -- Hint: Validate data

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

875: THEN
876: -- Hint: Validate data
877: -- IF p_CATEGORY_SEQUENCE <> G_MISS_CHAR
878: -- verify if data is valid
879: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
880: IF p_CATEGORY_SEQUENCE <> CSC_CORE_UTILS_PVT.G_MISS_CHAR THEN
881: Open C1;
882: Fetch C1 into l_dummy;
883: IF C1%FOUND THEN

Line 884: x_return_status := FND_API.G_RET_STS_ERROR;

880: IF p_CATEGORY_SEQUENCE <> CSC_CORE_UTILS_PVT.G_MISS_CHAR THEN
881: Open C1;
882: Fetch C1 into l_dummy;
883: IF C1%FOUND THEN
884: x_return_status := FND_API.G_RET_STS_ERROR;
885: CSC_CORE_UTILS_PVT.Add_Duplicate_Value_Msg(
886: p_api_name => p_api_name,
887: p_argument => 'p_CATEGORY_SEQUENCE' ,
888: p_argument_value => p_CATEGORY_SEQUENCE);

Line 917: IF FND_API.to_Boolean( p_init_msg_list )

913: IS
914: BEGIN
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:

Line 924: x_return_status := FND_API.G_RET_STS_SUCCESS;

920: END IF;
921:
922:
923: -- Initialize API return status to SUCCESS
924: x_return_status := FND_API.G_RET_STS_SUCCESS;
925:
926: IF (p_THRESHOLD_FLAG IS NOT NULL) AND
927: (p_THRESHOLD_FLAG <> CSC_CORE_UTILS_PVT.G_MISS_CHAR)
928: THEN

Line 932: p_lookup_code => p_THRESHOLD_FLAG ) <> FND_API.G_RET_STS_SUCCESS

928: THEN
929: IF CSC_CORE_UTILS_PVT.lookup_code_not_exists(
930: p_effective_date => trunc(sysdate),
931: p_lookup_type => 'YES_NO',
932: p_lookup_code => p_THRESHOLD_FLAG ) <> FND_API.G_RET_STS_SUCCESS
933: THEN
934: x_return_status := FND_API.G_RET_STS_ERROR;
935: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(
936: p_api_name => p_api_name,

Line 934: x_return_status := FND_API.G_RET_STS_ERROR;

930: p_effective_date => trunc(sysdate),
931: p_lookup_type => 'YES_NO',
932: p_lookup_code => p_THRESHOLD_FLAG ) <> FND_API.G_RET_STS_SUCCESS
933: THEN
934: x_return_status := FND_API.G_RET_STS_ERROR;
935: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(
936: p_api_name => p_api_name,
937: p_argument_value => p_THRESHOLD_FLAG,
938: p_argument => 'p_THRESHOLD_FLAG');

Line 966: x_return_status := FND_API.G_RET_STS_SUCCESS;

962: BEGIN
963:
964:
965: -- Initialize API return status to SUCCESS
966: x_return_status := FND_API.G_RET_STS_SUCCESS;
967: Validate_GROUP_ID(
968: p_api_name => p_api_name,
969: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,
970: p_validation_mode => p_validation_mode,

Line 975: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

971: p_GROUP_ID => P_GROUP_CHK_REC.GROUP_ID,
972: x_return_status => x_return_status,
973: x_msg_count => x_msg_count,
974: x_msg_data => x_msg_data);
975: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
976: raise FND_API.G_EXC_ERROR;
977: END IF;
978: /*
979: Validate_CHECK_ID(

Line 976: raise FND_API.G_EXC_ERROR;

972: x_return_status => x_return_status,
973: x_msg_count => x_msg_count,
974: x_msg_data => x_msg_data);
975: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
976: raise FND_API.G_EXC_ERROR;
977: END IF;
978: /*
979: Validate_CHECK_ID(
980: p_api_name => p_api_name,

Line 987: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

983: p_CHECK_ID => P_GROUP_CHK_Rec.CHECK_ID,
984: x_return_status => x_return_status,
985: x_msg_count => x_msg_count,
986: x_msg_data => x_msg_data);
987: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
988: raise FND_API.G_EXC_ERROR;
989: END IF;
990: */
991:

Line 988: raise FND_API.G_EXC_ERROR;

984: x_return_status => x_return_status,
985: x_msg_count => x_msg_count,
986: x_msg_data => x_msg_data);
987: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
988: raise FND_API.G_EXC_ERROR;
989: END IF;
990: */
991:
992: Validate_CHECK_SEQUENCE(

Line 1001: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

997: p_CHECK_SEQUENCE => P_GROUP_CHK_Rec.CHECK_SEQUENCE,
998: x_return_status => x_return_status,
999: x_msg_count => x_msg_count,
1000: x_msg_data => x_msg_data);
1001: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1002: raise FND_API.G_EXC_ERROR;
1003: END IF;
1004:
1005: CSC_CORE_UTILS_PVT.Validate_Seeded_Flag(

Line 1002: raise FND_API.G_EXC_ERROR;

998: x_return_status => x_return_status,
999: x_msg_count => x_msg_count,
1000: x_msg_data => x_msg_data);
1001: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1002: raise FND_API.G_EXC_ERROR;
1003: END IF;
1004:
1005: CSC_CORE_UTILS_PVT.Validate_Seeded_Flag(
1006: p_api_name =>'CSC_PROF_GROUP_CHECKS_PVT.VALIDATE_SEEDED_FLAG',

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

1006: p_api_name =>'CSC_PROF_GROUP_CHECKS_PVT.VALIDATE_SEEDED_FLAG',
1007: p_seeded_flag => P_GROUP_CHK_Rec.seeded_flag,
1008: x_return_status => x_return_status );
1009:
1010: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1011: RAISE FND_API.G_EXC_ERROR;
1012: END IF;
1013: /*
1014: Validate_CATEGORY_CODE(

Line 1011: RAISE FND_API.G_EXC_ERROR;

1007: p_seeded_flag => P_GROUP_CHK_Rec.seeded_flag,
1008: x_return_status => x_return_status );
1009:
1010: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1011: RAISE FND_API.G_EXC_ERROR;
1012: END IF;
1013: /*
1014: Validate_CATEGORY_CODE(
1015: p_api_name => p_api_name,

Line 1022: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1018: p_CATEGORY_CODE => P_GROUP_CHK_Rec.CATEGORY_CODE,
1019: x_return_status => x_return_status,
1020: x_msg_count => x_msg_count,
1021: x_msg_data => x_msg_data);
1022: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1023: raise FND_API.G_EXC_ERROR;
1024: END IF;
1025:
1026: CSC_CORE_UTILS_PVT.Validate_Start_End_Dt(

Line 1023: raise FND_API.G_EXC_ERROR;

1019: x_return_status => x_return_status,
1020: x_msg_count => x_msg_count,
1021: x_msg_data => x_msg_data);
1022: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1023: raise FND_API.G_EXC_ERROR;
1024: END IF;
1025:
1026: CSC_CORE_UTILS_PVT.Validate_Start_End_Dt(
1027: p_api_name => p_Api_name,

Line 1031: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1027: p_api_name => p_Api_name,
1028: p_start_date => P_GROUP_CHK_Rec.start_date_active,
1029: p_end_date => P_GROUP_CHK_Rec.end_date_active,
1030: x_return_status => x_return_status );
1031: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1032: raise FND_API.G_EXC_ERROR;
1033: END IF;
1034:
1035: Validate_CATEGORY_SEQUENCE(

Line 1032: raise FND_API.G_EXC_ERROR;

1028: p_start_date => P_GROUP_CHK_Rec.start_date_active,
1029: p_end_date => P_GROUP_CHK_Rec.end_date_active,
1030: x_return_status => x_return_status );
1031: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1032: raise FND_API.G_EXC_ERROR;
1033: END IF;
1034:
1035: Validate_CATEGORY_SEQUENCE(
1036: p_api_name => p_api_name,

Line 1043: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1039: p_CATEGORY_SEQUENCE => P_GROUP_CHK_Rec.CATEGORY_SEQUENCE,
1040: x_return_status => x_return_status,
1041: x_msg_count => x_msg_count,
1042: x_msg_data => x_msg_data);
1043: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1044: raise FND_API.G_EXC_ERROR;
1045: END IF;
1046:
1047: Validate_THRESHOLD_FLAG(

Line 1044: raise FND_API.G_EXC_ERROR;

1040: x_return_status => x_return_status,
1041: x_msg_count => x_msg_count,
1042: x_msg_data => x_msg_data);
1043: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1044: raise FND_API.G_EXC_ERROR;
1045: END IF;
1046:
1047: Validate_THRESHOLD_FLAG(
1048: p_api_name => p_api_name,

Line 1055: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1051: p_THRESHOLD_FLAG => P_GROUP_CHK_Rec.THRESHOLD_FLAG,
1052: x_return_status => x_return_status,
1053: x_msg_count => x_msg_count,
1054: x_msg_data => x_msg_data);
1055: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1056: raise FND_API.G_EXC_ERROR;
1057: END IF;
1058: */
1059:

Line 1056: raise FND_API.G_EXC_ERROR;

1052: x_return_status => x_return_status,
1053: x_msg_count => x_msg_count,
1054: x_msg_data => x_msg_data);
1055: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1056: raise FND_API.G_EXC_ERROR;
1057: END IF;
1058: */
1059:
1060: