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

Line 6: -- History :26 Nov 02 jamose made changes for the NOCOPY and FND_API.G_MISS*

2: /* $Header: cscvpcrb.pls 115.13 2002/12/03 17:57:22 jamose ship $ */
3: -- Start of Comments
4: -- Package name : CSC_PROFILE_CHECK_RULES_PVT
5: -- Purpose :
6: -- History :26 Nov 02 jamose made changes for the NOCOPY and FND_API.G_MISS*
7: -- NOTE :
8: -- End of Comments
9:
10:

Line 145: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

141: SAVEPOINT CREATE_PROFILE_CHECK_RULES_PVT;
142:
143:
144: -- Standard call to check for call compatibility.
145: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
146: p_api_version_number,
147: l_api_name,
148: G_PKG_NAME)
149: THEN

Line 150: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 155: IF FND_API.to_Boolean( p_init_msg_list )

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

Line 162: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 182: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

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

Line 183: RAISE FND_API.G_EXC_ERROR;

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

Line 206: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

202: p_RIGHT_PAREN => l_CHK_RULES_rec.RIGHT_PAREN,
203: p_SEEDED_FLAG => l_CHK_RULES_rec.SEEDED_FLAG,
204: x_OBJECT_VERSION_NUMBER => X_OBJECT_VERSION_NUMBER);
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_SEEDED_FLAG => l_CHK_RULES_rec.SEEDED_FLAG,
204: x_OBJECT_VERSION_NUMBER => X_OBJECT_VERSION_NUMBER);
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: --

Line 216: IF FND_API.to_Boolean( p_commit )

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

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_check_rules_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_check_rules_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: APP_EXCEPTION.RAISE_EXCEPTION;

Line 236: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 238: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 245: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 371: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

367: -- Standard Start of API savepoint
368: SAVEPOINT UPDATE_PROFILE_CHECK_RULES_PVT;
369:
370: -- Standard call to check for call compatibility.
371: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
372: p_api_version_number,
373: l_api_name,
374: G_PKG_NAME)
375: THEN

Line 376: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

372: p_api_version_number,
373: l_api_name,
374: G_PKG_NAME)
375: THEN
376: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
377: END IF;
378:
379:
380: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 381: IF FND_API.to_Boolean( p_init_msg_list )

377: END IF;
378:
379:
380: -- Initialize message list if p_init_msg_list is set to TRUE.
381: IF FND_API.to_Boolean( p_init_msg_list )
382: THEN
383: FND_MSG_PUB.initialize;
384: END IF;
385:

Line 389: x_return_status := FND_API.G_RET_STS_SUCCESS;

385:
386:
387:
388: -- Initialize API return status to SUCCESS
389: x_return_status := FND_API.G_RET_STS_SUCCESS;
390:
391: --
392: -- Api body
393: --

Line 419: raise FND_API.G_EXC_ERROR;

415: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
416: THEN
417: CSC_CORE_UTILS_PVT.Record_Is_Locked_Msg(p_api_name => l_api_name);
418: END IF;
419: raise FND_API.G_EXC_ERROR;
420: END IF;
421:
422:
423: IF ( P_validation_level >= CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL)

Line 441: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

437:
438:
439: END IF;
440:
441: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
442: RAISE FND_API.G_EXC_ERROR;
443: END IF;
444:
445: -- Invoke table handler(CSC_PROF_CHECK_RULES_PKG.Update_Row)

Line 442: RAISE FND_API.G_EXC_ERROR;

438:
439: END IF;
440:
441: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
442: RAISE FND_API.G_EXC_ERROR;
443: END IF;
444:
445: -- Invoke table handler(CSC_PROF_CHECK_RULES_PKG.Update_Row)
446: CSC_PROFILE_CHECK_RULES_PKG.Update_Row(

Line 467: IF FND_API.to_Boolean( p_commit )

463: -- End of API body.
464: --
465:
466: -- Standard check for p_commit
467: IF FND_API.to_Boolean( p_commit )
468: THEN
469: COMMIT WORK;
470: END IF;
471:

Line 480: WHEN FND_API.G_EXC_ERROR THEN

476: p_data => x_msg_data
477: );
478:
479: EXCEPTION
480: WHEN FND_API.G_EXC_ERROR THEN
481: ROLLBACK TO Update_profile_check_rules_PVT;
482: x_return_status := FND_API.G_RET_STS_ERROR;
483: FND_MSG_PUB.Count_And_Get(
484: p_count => x_msg_count,

Line 482: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 487: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

483: FND_MSG_PUB.Count_And_Get(
484: p_count => x_msg_count,
485: p_data => x_msg_data );
486: APP_EXCEPTION.RAISE_EXCEPTION;
487: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
488: ROLLBACK TO Update_profile_check_rules_PVT;
489: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
490: FND_MSG_PUB.Count_And_Get(
491: p_count => x_msg_count,

Line 489: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

485: p_data => x_msg_data );
486: APP_EXCEPTION.RAISE_EXCEPTION;
487: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
488: ROLLBACK TO Update_profile_check_rules_PVT;
489: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
490: FND_MSG_PUB.Count_And_Get(
491: p_count => x_msg_count,
492: p_data => x_msg_data );
493: APP_EXCEPTION.RAISE_EXCEPTION;

Line 496: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

492: p_data => x_msg_data );
493: APP_EXCEPTION.RAISE_EXCEPTION;
494: WHEN OTHERS THEN
495: ROLLBACK TO Update_profile_check_rules_PVT;
496: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
497: FND_MSG_PUB.Count_And_Get(
498: p_count => x_msg_count,
499: p_data => x_msg_data );
500: FND_MSG_PUB.Build_Exc_Msg;

Line 526: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

522: -- Standard Start of API savepoint
523: SAVEPOINT DELETE_PROFILE_CHECK_RULES_PVT;
524:
525: -- Standard call to check for call compatibility.
526: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
527: p_api_version_number,
528: l_api_name,
529: G_PKG_NAME)
530: THEN

Line 531: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

527: p_api_version_number,
528: l_api_name,
529: G_PKG_NAME)
530: THEN
531: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
532: END IF;
533:
534:
535: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 536: IF FND_API.to_Boolean( p_init_msg_list )

532: END IF;
533:
534:
535: -- Initialize message list if p_init_msg_list is set to TRUE.
536: IF FND_API.to_Boolean( p_init_msg_list )
537: THEN
538: FND_MSG_PUB.initialize;
539: END IF;
540:

Line 542: x_return_status := FND_API.G_RET_STS_SUCCESS;

538: FND_MSG_PUB.initialize;
539: END IF;
540:
541: -- Initialize API return status to SUCCESS
542: x_return_status := FND_API.G_RET_STS_SUCCESS;
543:
544: --
545: -- Api body
546: --

Line 559: IF FND_API.to_Boolean( p_commit )

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

Line 572: WHEN FND_API.G_EXC_ERROR THEN

568: p_data => x_msg_data
569: );
570:
571: EXCEPTION
572: WHEN FND_API.G_EXC_ERROR THEN
573: ROLLBACK TO Delete_profile_check_rules_PVT;
574: x_return_status := FND_API.G_RET_STS_ERROR;
575: FND_MSG_PUB.Count_And_Get(
576: p_count => x_msg_count,

Line 574: x_return_status := FND_API.G_RET_STS_ERROR;

570:
571: EXCEPTION
572: WHEN FND_API.G_EXC_ERROR THEN
573: ROLLBACK TO Delete_profile_check_rules_PVT;
574: x_return_status := FND_API.G_RET_STS_ERROR;
575: FND_MSG_PUB.Count_And_Get(
576: p_count => x_msg_count,
577: p_data => x_msg_data );
578: APP_EXCEPTION.RAISE_EXCEPTION;

Line 579: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

575: FND_MSG_PUB.Count_And_Get(
576: p_count => x_msg_count,
577: p_data => x_msg_data );
578: APP_EXCEPTION.RAISE_EXCEPTION;
579: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
580: ROLLBACK TO Delete_profile_check_rules_PVT;
581: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
582: FND_MSG_PUB.Count_And_Get(
583: p_count => x_msg_count,

Line 581: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 588: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

584: p_data => x_msg_data );
585: APP_EXCEPTION.RAISE_EXCEPTION;
586: WHEN OTHERS THEN
587: ROLLBACK TO Delete_profile_check_rules_PVT;
588: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
589: FND_MSG_PUB.Count_And_Get(
590: p_count => x_msg_count,
591: p_data => x_msg_data );
592: FND_MSG_PUB.Build_Exc_Msg;

Line 616: IF FND_API.to_Boolean( p_init_msg_list )

612: l_dummy NUMBER;
613: BEGIN
614:
615: -- Initialize message list if p_init_msg_list is set to TRUE.
616: IF FND_API.to_Boolean( p_init_msg_list )
617: THEN
618: FND_MSG_PUB.initialize;
619: END IF;
620:

Line 623: x_return_status := FND_API.G_RET_STS_SUCCESS;

619: END IF;
620:
621:
622: -- Initialize API return status to SUCCESS
623: x_return_status := FND_API.G_RET_STS_SUCCESS;
624:
625: -- validate NOT NULL column
626: IF(p_CHECK_ID is NULL)
627: THEN

Line 628: x_return_status := FND_API.G_RET_STS_ERROR;

624:
625: -- validate NOT NULL column
626: IF(p_CHECK_ID is NULL)
627: THEN
628: x_return_status := FND_API.G_RET_STS_ERROR;
629: CSC_CORE_UTILS_PVT.mandatory_arg_error(
630: p_Api_name => p_Api_Name,
631: p_Argument => 'p_CHECK_ID',
632: p_Argument_Value => p_CHECK_ID);

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

640: THEN
641: -- Hint: Validate data
642: -- IF p_CHECK_ID is not NULL and p_CHECK_ID <> G_MISS_CHAR
643: -- verify if data is valid
644: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
645: IF p_CHECK_ID is not NULL and p_CHECK_ID <> CSC_CORE_UTILS_PVT.G_MISS_NUM
646: THEN
647: Open C1;
648: Fetch C1 INTO l_dummy;

Line 653: x_return_status := FND_API.G_RET_STS_ERROR;

649: --IF C1%FOUND THEN
650: IF C1%NOTFOUND THEN
651: --Changed as % found is valid and %notfound
652: -- is error in this case
653: x_return_status := FND_API.G_RET_STS_ERROR;
654: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg (
655: p_Api_Name => p_Api_Name,
656: p_Argument => 'p_CHECK_ID',
657: p_Argument_Value => to_char(p_CHECK_ID));

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

662: THEN
663: -- Hint: Validate data
664: -- IF p_CHECK_ID <> CSC_CORE_UTILS_PVT.G_MISS_CHAR
665: -- verify if data is valid
666: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
667: IF p_CHECK_ID <> CSC_CORE_UTILS_PVT.G_MISS_NUM
668: THEN
669: --** update not allowed
670: NULL;

Line 703: IF FND_API.to_Boolean( p_init_msg_list )

699: l_dummy varchar2(30);
700: BEGIN
701:
702: -- Initialize message list if p_init_msg_list is set to TRUE.
703: IF FND_API.to_Boolean( p_init_msg_list )
704: THEN
705: FND_MSG_PUB.initialize;
706: END IF;
707:

Line 710: x_return_status := FND_API.G_RET_STS_SUCCESS;

706: END IF;
707:
708:
709: -- Initialize API return status to SUCCESS
710: x_return_status := FND_API.G_RET_STS_SUCCESS;
711:
712: -- validate NOT NULL column
713: IF(p_SEQUENCE is NULL)
714: THEN

Line 715: x_return_status := FND_API.G_RET_STS_ERROR;

711:
712: -- validate NOT NULL column
713: IF(p_SEQUENCE is NULL)
714: THEN
715: x_return_status := FND_API.G_RET_STS_ERROR;
716: CSC_CORE_UTILS_PVT.mandatory_arg_error(
717: p_Api_name => p_Api_Name,
718: p_Argument => 'p_SEQUENCE',
719: p_Argument_Value => p_SEQUENCE);

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

724: THEN
725: -- Hint: Validate data
726: -- IF p_SEQUENCE is not NULL and p_SEQUENCE <> CSC_CORE_UTILS_PVT.G_MISS_CHAR
727: -- verify if data is valid
728: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
729:
730: IF p_SEQUENCE <> CSC_CORE_UTILS_PVT.G_MISS_NUM
731: THEN
732: Open C1;

Line 735: x_return_status := FND_API.G_RET_STS_ERROR;

731: THEN
732: Open C1;
733: Fetch C1 into l_dummy;
734: IF C1%FOUND THEN
735: x_return_status := FND_API.G_RET_STS_ERROR;
736: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg (
737: p_Api_Name => p_Api_Name,
738: p_Argument => 'p_CHECK_ID',
739: p_Argument_Value => to_char(p_CHECK_ID));

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

744: THEN
745: -- Hint: Validate data
746: -- IF p_SEQUENCE <> CSC_CORE_UTILS_PVT.G_MISS_CHAR
747: -- verify if data is valid
748: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
749: IF p_SEQUENCE <> CSC_CORE_UTILS_PVT.G_MISS_NUM
750: THEN
751: --**cannot update sequence as part of pk
752: NULL;

Line 778: IF FND_API.to_Boolean( p_init_msg_list )

774: BEGIN
775:
776:
777: -- Initialize message list if p_init_msg_list is set to TRUE.
778: IF FND_API.to_Boolean( p_init_msg_list )
779: THEN
780: FND_MSG_PUB.initialize;
781: END IF;
782:

Line 785: x_return_status := FND_API.G_RET_STS_SUCCESS;

781: END IF;
782:
783:
784: -- Initialize API return status to SUCCESS
785: x_return_status := FND_API.G_RET_STS_SUCCESS;
786:
787: IF(p_validation_mode = CSC_CORE_UTILS_PVT.G_CREATE)
788: THEN
789: IF p_EXPR_TO_BLOCK_ID is not NULL and p_EXPR_TO_BLOCK_ID <> CSC_CORE_UTILS_PVT.G_MISS_NUM

Line 794: x_return_status := FND_API.G_RET_STS_ERROR;

790: THEN
791: Open C1;
792: Fetch C1 into l_dummy;
793: IF C1%NOTFOUND THEN
794: x_return_status := FND_API.G_RET_STS_ERROR;
795: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg (
796: p_Api_Name => p_Api_Name,
797: p_Argument => 'p_Expr_to_BLOCK_ID',
798: p_Argument_Value => to_char(p_Expr_to_BLOCK_ID));

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

804: THEN
805: -- Hint: Validate data
806: -- IF p_BLOCK_ID <> CSC_CORE_UTILS_PVT.G_MISS_CHAR
807: -- verify if data is valid
808: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
809: IF p_EXPR_TO_BLOCK_ID <> CSC_CORE_UTILS_PVT.G_MISS_NUM THEN
810: Open C1;
811: Fetch C1 into l_dummy;
812: IF C1%NOTFOUND THEN

Line 813: x_return_status := FND_API.G_RET_STS_ERROR;

809: IF p_EXPR_TO_BLOCK_ID <> CSC_CORE_UTILS_PVT.G_MISS_NUM THEN
810: Open C1;
811: Fetch C1 into l_dummy;
812: IF C1%NOTFOUND THEN
813: x_return_status := FND_API.G_RET_STS_ERROR;
814: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg (
815: p_Api_Name => p_Api_Name,
816: p_Argument => 'p_EXPR_To_BLOCK_ID',
817: p_Argument_Value => to_char(p_EXPR_TO_BLOCK_ID));

Line 846: IF FND_API.to_Boolean( p_init_msg_list )

842: l_dummy varchar2(30);
843: BEGIN
844:
845: -- Initialize message list if p_init_msg_list is set to TRUE.
846: IF FND_API.to_Boolean( p_init_msg_list )
847: THEN
848: FND_MSG_PUB.initialize;
849: END IF;
850:

Line 853: x_return_status := FND_API.G_RET_STS_SUCCESS;

849: END IF;
850:
851:
852: -- Initialize API return status to SUCCESS
853: x_return_status := FND_API.G_RET_STS_SUCCESS;
854:
855: -- validate NOT NULL column
856: IF(p_BLOCK_ID is NULL)
857: THEN

Line 859: x_return_status := FND_API.G_RET_STS_ERROR;

855: -- validate NOT NULL column
856: IF(p_BLOCK_ID is NULL)
857: THEN
858: --mandatory arg error
859: x_return_status := FND_API.G_RET_STS_ERROR;
860: CSC_CORE_UTILS_PVT.mandatory_arg_error(
861: p_Api_name => p_Api_Name,
862: p_Argument => 'p_BLOCK_ID',
863: p_Argument_Value => p_BLOCK_ID);

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_BLOCK_ID is not NULL and p_BLOCK_ID <> CSC_CORE_UTILS_PVT.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: IF p_BLOCK_ID is not NULL and p_BLOCK_ID <> CSC_CORE_UTILS_PVT.G_MISS_NUM
874: THEN
875: Open C1;
876: Fetch C1 into l_dummy;

Line 878: x_return_status := FND_API.G_RET_STS_ERROR;

874: THEN
875: Open C1;
876: Fetch C1 into l_dummy;
877: IF C1%NOTFOUND THEN
878: x_return_status := FND_API.G_RET_STS_ERROR;
879: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg (
880: p_Api_Name => p_Api_Name,
881: p_Argument => 'p_BLOCK_ID',
882: p_Argument_Value => to_char(p_BLOCK_ID));

Line 886: x_return_status := FND_API.G_RET_STS_ERROR;

882: p_Argument_Value => to_char(p_BLOCK_ID));
883: END IF;
884: Close C1;
885: ELSE
886: x_return_status := FND_API.G_RET_STS_ERROR;
887: CSC_CORE_UTILS_PVT.mandatory_arg_error(
888: p_Api_name => p_Api_Name,
889: p_Argument => 'p_BLOCK_ID',
890: p_Argument_Value => p_BLOCK_ID);

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

894: THEN
895: -- Hint: Validate data
896: -- IF p_BLOCK_ID <> CSC_CORE_UTILS_PVT.G_MISS_CHAR
897: -- verify if data is valid
898: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
899: IF p_BLOCK_ID <> CSC_CORE_UTILS_PVT.G_MISS_NUM THEN
900: Open C1;
901: Fetch C1 into l_dummy;
902: IF C1%NOTFOUND THEN

Line 903: x_return_status := FND_API.G_RET_STS_ERROR;

899: IF p_BLOCK_ID <> CSC_CORE_UTILS_PVT.G_MISS_NUM THEN
900: Open C1;
901: Fetch C1 into l_dummy;
902: IF C1%NOTFOUND THEN
903: x_return_status := FND_API.G_RET_STS_ERROR;
904: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg (
905: p_Api_Name => p_Api_Name,
906: p_Argument => 'p_BLOCK_ID',
907: p_Argument_Value => to_char(p_BLOCK_ID));

Line 958: x_return_status := FND_API.G_RET_STS_SUCCESS;

954: IS
955: cursor_id NUMBER;
956: BEGIN
957: -- Initialize API return status to SUCCESS
958: x_return_status := FND_API.G_RET_STS_SUCCESS;
959:
960: cursor_id := dbms_sql.open_cursor;
961: dbms_sql.parse(cursor_id,p_Sql_Stmnt,dbms_Sql.native);
962: dbms_sql.close_cursor(cursor_id);

Line 968: x_return_status := FND_API.G_RET_STS_SUCCESS;

964: WHEN OTHERS THEN
965: IF (dbms_sql.is_open(cursor_id)) THEN
966: dbms_sql.close_cursor(cursor_id);
967: END IF;
968: x_return_status := FND_API.G_RET_STS_SUCCESS;
969: END;
970:
971:
972: /*

Line 987: IF FND_API.to_Boolean( p_init_msg_list )

983: l_condition VARCHAR2(2000);
984: BEGIN
985:
986: -- Initialize message list if p_init_msg_list is set to TRUE.
987: IF FND_API.to_Boolean( p_init_msg_list )
988: THEN
989: FND_MSG_PUB.initialize;
990: END IF;
991:

Line 993: x_return_status := FND_API.G_RET_STS_SUCCESS;

989: FND_MSG_PUB.initialize;
990: END IF;
991:
992: -- Initialize API return status to SUCCESS
993: x_return_status := FND_API.G_RET_STS_SUCCESS;
994:
995: -- build the rule using the table.
996: build_rule(p_Chk_Rules_Tbl,l_condition);
997:

Line 1001: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

997:
998: -- validate rule
999: validate_rule(l_condition,x_Return_status);
1000:
1001: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1002: raise FND_API.G_EXC_ERROR;
1003: END IF;
1004:
1005: -- Standard call to get message count and if count is 1, get message info.

Line 1002: raise FND_API.G_EXC_ERROR;

998: -- validate rule
999: validate_rule(l_condition,x_Return_status);
1000:
1001: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1002: raise FND_API.G_EXC_ERROR;
1003: END IF;
1004:
1005: -- Standard call to get message count and if count is 1, get message info.
1006: FND_MSG_PUB.Count_And_Get

Line 1031: x_return_status := FND_API.G_RET_STS_SUCCESS;

1027: BEGIN
1028:
1029:
1030: -- Initialize API return status to SUCCESS
1031: x_return_status := FND_API.G_RET_STS_SUCCESS;
1032:
1033:
1034: Validate_CHECK_ID(
1035: p_api_name => p_api_name,

Line 1042: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1038: p_CHECK_ID => p_chk_rules_rec.CHECK_ID,
1039: x_return_status => x_return_status,
1040: x_msg_count => x_msg_count,
1041: x_msg_data => x_msg_data);
1042: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1043: raise FND_API.G_EXC_ERROR;
1044: END IF;
1045:
1046: Validate_SEQUENCE(

Line 1043: raise FND_API.G_EXC_ERROR;

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

Line 1055: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1051: p_CHECK_ID => p_CHK_RULES_Rec.Check_Id,
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: Validate_BLOCK_ID(

Line 1068: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1064: p_BLOCK_ID => p_Chk_rules_rec.BLOCK_ID,
1065: x_return_status => x_return_status,
1066: x_msg_count => x_msg_count,
1067: x_msg_data => x_msg_data);
1068: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1069: raise FND_API.G_EXC_ERROR;
1070: END IF;
1071:
1072:

Line 1069: raise FND_API.G_EXC_ERROR;

1065: x_return_status => x_return_status,
1066: x_msg_count => x_msg_count,
1067: x_msg_data => x_msg_data);
1068: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1069: raise FND_API.G_EXC_ERROR;
1070: END IF;
1071:
1072:
1073:

Line 1082: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1078: p_EXPR_TO_BLOCK_ID => p_Chk_rules_rec.Expr_TO_BLOCK_ID,
1079: x_return_status => x_return_status,
1080: x_msg_count => x_msg_count,
1081: x_msg_data => x_msg_data);
1082: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1083: raise FND_API.G_EXC_ERROR;
1084: END IF;
1085:
1086: --Validate seeded flag

Line 1083: raise FND_API.G_EXC_ERROR;

1079: x_return_status => x_return_status,
1080: x_msg_count => x_msg_count,
1081: x_msg_data => x_msg_data);
1082: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1083: raise FND_API.G_EXC_ERROR;
1084: END IF;
1085:
1086: --Validate seeded flag
1087:

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

1089: p_api_name =>'CSC_PROF_CHECK_RULES_PVT.VALIDATE_SEEDED_FLAG',
1090: p_seeded_flag => p_Chk_rules_rec.seeded_flag,
1091: x_return_status => x_return_status );
1092:
1093: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1094: RAISE FND_API.G_EXC_ERROR;
1095: END IF;
1096:
1097: /*

Line 1094: RAISE FND_API.G_EXC_ERROR;

1090: p_seeded_flag => p_Chk_rules_rec.seeded_flag,
1091: x_return_status => x_return_status );
1092:
1093: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1094: RAISE FND_API.G_EXC_ERROR;
1095: END IF;
1096:
1097: /*
1098: Validate_CONDITION(

Line 1106: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1102: p_CHK_RULES_Tbl => P_CHK_RULES_Tbl,
1103: x_return_status => x_return_status,
1104: x_msg_count => x_msg_count,
1105: x_msg_data => x_msg_data);
1106: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1107: raise FND_API.G_EXC_ERROR;
1108: END IF;
1109: */
1110:

Line 1107: raise FND_API.G_EXC_ERROR;

1103: x_return_status => x_return_status,
1104: x_msg_count => x_msg_count,
1105: x_msg_data => x_msg_data);
1106: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1107: raise FND_API.G_EXC_ERROR;
1108: END IF;
1109: */
1110:
1111: END Validate_profile_check_rules;