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

Line 174: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

170: -- Standard Start of API savepoint
171: SAVEPOINT CREATE_PROFILE_CHECK_PVT;
172:
173: -- Standard call to check for call compatibility.
174: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
175: p_api_version_number,
176: l_api_name,
177: G_PKG_NAME)
178: THEN

Line 179: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

175: p_api_version_number,
176: l_api_name,
177: G_PKG_NAME)
178: THEN
179: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
180: END IF;
181:
182:
183: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 184: IF FND_API.to_Boolean( p_init_msg_list )

180: END IF;
181:
182:
183: -- Initialize message list if p_init_msg_list is set to TRUE.
184: IF FND_API.to_Boolean( p_init_msg_list )
185: THEN
186: FND_MSG_PUB.initialize;
187: END IF;
188:

Line 191: x_return_status := FND_API.G_RET_STS_SUCCESS;

187: END IF;
188:
189:
190: -- Initialize API return status to SUCCESS
191: x_return_status := FND_API.G_RET_STS_SUCCESS;
192:
193:
194: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
195: THEN

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

190: -- Initialize API return status to SUCCESS
191: x_return_status := FND_API.G_RET_STS_SUCCESS;
192:
193:
194: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
195: THEN
196:
197: -- Invoke validation procedures
198: Validate_check(

Line 199: p_init_msg_list => FND_API.G_FALSE,

195: THEN
196:
197: -- Invoke validation procedures
198: Validate_check(
199: p_init_msg_list => FND_API.G_FALSE,
200: p_Validation_Level => p_Validation_Level,
201: p_Validation_Mode => CSC_CORE_UTILS_PVT.G_CREATE,
202: p_CHECK_REC => p_CHECK_REC,
203: x_return_status => x_return_status,

Line 207: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

203: x_return_status => x_return_status,
204: x_msg_count => x_msg_count,
205: x_msg_data => x_msg_data);
206: END IF;
207: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
208: RAISE FND_API.G_EXC_ERROR;
209: END IF;
210:
211:

Line 208: RAISE FND_API.G_EXC_ERROR;

204: x_msg_count => x_msg_count,
205: x_msg_data => x_msg_data);
206: END IF;
207: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
208: RAISE FND_API.G_EXC_ERROR;
209: END IF;
210:
211:
212: -- Invoke table handler(CSC_PROF_CHECKS_PKG.Insert_Row)

Line 238: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

234: p_LAST_UPDATE_LOGIN => p_Check_rec.LAST_UPDATE_LOGIN,
235: x_OBJECT_VERSION_NUMBER => X_OBJECT_VERSION_NUMBER,
236: p_APPLICATION_ID => p_Check_rec.APPLICATION_ID);
237:
238: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
239: RAISE FND_API.G_EXC_ERROR;
240: END IF;
241:
242:

Line 239: RAISE FND_API.G_EXC_ERROR;

235: x_OBJECT_VERSION_NUMBER => X_OBJECT_VERSION_NUMBER,
236: p_APPLICATION_ID => p_Check_rec.APPLICATION_ID);
237:
238: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
239: RAISE FND_API.G_EXC_ERROR;
240: END IF;
241:
242:
243: -- Standard check for p_commit

Line 244: IF FND_API.to_Boolean( p_commit )

240: END IF;
241:
242:
243: -- Standard check for p_commit
244: IF FND_API.to_Boolean( p_commit )
245: THEN
246: COMMIT WORK;
247: END IF;
248:

Line 257: WHEN FND_API.G_EXC_ERROR THEN

253: p_data => x_msg_data
254: );
255:
256: EXCEPTION
257: WHEN FND_API.G_EXC_ERROR THEN
258: ROLLBACK TO Create_Profile_Check_PVT;
259: x_return_status := FND_API.G_RET_STS_ERROR;
260: FND_MSG_PUB.Count_And_Get
261: ( p_count => x_msg_count,

Line 259: x_return_status := FND_API.G_RET_STS_ERROR;

255:
256: EXCEPTION
257: WHEN FND_API.G_EXC_ERROR THEN
258: ROLLBACK TO Create_Profile_Check_PVT;
259: x_return_status := FND_API.G_RET_STS_ERROR;
260: FND_MSG_PUB.Count_And_Get
261: ( p_count => x_msg_count,
262: p_data => x_msg_data
263: );

Line 265: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

261: ( p_count => x_msg_count,
262: p_data => x_msg_data
263: );
264: APP_EXCEPTION.RAISE_EXCEPTION;
265: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
266: ROLLBACK TO Create_Profile_Check_PVT;
267: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
268: FND_MSG_PUB.Count_And_Get
269: ( p_count => x_msg_count,

Line 267: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

263: );
264: APP_EXCEPTION.RAISE_EXCEPTION;
265: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
266: ROLLBACK TO Create_Profile_Check_PVT;
267: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
268: FND_MSG_PUB.Count_And_Get
269: ( p_count => x_msg_count,
270: p_data => x_msg_data
271: );

Line 275: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

271: );
272: APP_EXCEPTION.RAISE_EXCEPTION;
273: WHEN OTHERS THEN
274: ROLLBACK TO Create_Profile_Check_PVT;
275: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
276: FND_MSG_PUB.Build_Exc_Msg(G_PKG_NAME, l_api_name);
277: FND_MSG_PUB.Count_And_Get
278: ( p_count => x_msg_count,
279: p_data => x_msg_data

Line 415: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

411: -- Standard Start of API savepoint
412: SAVEPOINT UPDATE_PROFILE_CHECK_PVT;
413:
414: -- Standard call to check for call compatibility.
415: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
416: p_api_version_number,
417: l_api_name,
418: G_PKG_NAME)
419: THEN

Line 420: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

416: p_api_version_number,
417: l_api_name,
418: G_PKG_NAME)
419: THEN
420: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
421: END IF;
422:
423: -- Initialize message list if p_init_msg_list is set to TRUE.
424: IF FND_API.to_Boolean( p_init_msg_list )

Line 424: IF FND_API.to_Boolean( p_init_msg_list )

420: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
421: END IF;
422:
423: -- Initialize message list if p_init_msg_list is set to TRUE.
424: IF FND_API.to_Boolean( p_init_msg_list )
425: THEN
426: FND_MSG_PUB.initialize;
427: END IF;
428:

Line 430: x_return_status := FND_API.G_RET_STS_SUCCESS;

426: FND_MSG_PUB.initialize;
427: END IF;
428:
429: -- Initialize API return status to SUCCESS
430: x_return_status := FND_API.G_RET_STS_SUCCESS;
431:
432: --
433: -- Api body
434: --

Line 473: raise FND_API.G_EXC_ERROR;

469: --FND_MESSAGE.Set_Name('CSC', 'API_MISSING_UPDATE_TARGET');
470: --FND_MESSAGE.Set_Token ('INFO', 'CHECK', FALSE);
471: --FND_MSG_PUB.Add;
472: END IF;
473: raise FND_API.G_EXC_ERROR;
474: END IF;
475: IF C_Get_Check%ISOPEN THEN
476: CLOSE C_Get_Check;
477: END IF;

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

475: IF C_Get_Check%ISOPEN THEN
476: CLOSE C_Get_Check;
477: END IF;
478:
479: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
480: THEN
481:
482: -- Invoke validation procedures
483: Validate_check(

Line 484: p_init_msg_list => FND_API.G_FALSE,

480: THEN
481:
482: -- Invoke validation procedures
483: Validate_check(
484: p_init_msg_list => FND_API.G_FALSE,
485: p_validation_level => p_validation_level,
486: p_validation_mode => CSC_CORE_UTILS_PVT.G_UPDATE,
487: P_Check_Rec => P_Check_Rec,
488: x_return_status => x_return_status,

Line 493: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

489: x_msg_count => x_msg_count,
490: x_msg_data => x_msg_data);
491: END IF;
492:
493: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
494: RAISE FND_API.G_EXC_ERROR;
495: END IF;
496:
497:

Line 494: RAISE FND_API.G_EXC_ERROR;

490: x_msg_data => x_msg_data);
491: END IF;
492:
493: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
494: RAISE FND_API.G_EXC_ERROR;
495: END IF;
496:
497:
498: -- Invoke table handler(CS_PROF_CHECKS_PKG.Update_Row)

Line 527: IF FND_API.to_Boolean( p_commit )

523: -- End of API body.
524: --
525:
526: -- Standard check for p_commit
527: IF FND_API.to_Boolean( p_commit )
528: THEN
529: COMMIT WORK;
530: END IF;
531:

Line 540: WHEN FND_API.G_EXC_ERROR THEN

536: p_data => x_msg_data
537: );
538:
539: EXCEPTION
540: WHEN FND_API.G_EXC_ERROR THEN
541: ROLLBACK TO Update_Profile_check_PVT;
542: x_return_status := FND_API.G_RET_STS_ERROR;
543: FND_MSG_PUB.Count_And_Get
544: ( p_encoded => FND_API.G_FALSE,p_count => x_msg_count,

Line 542: x_return_status := FND_API.G_RET_STS_ERROR;

538:
539: EXCEPTION
540: WHEN FND_API.G_EXC_ERROR THEN
541: ROLLBACK TO Update_Profile_check_PVT;
542: x_return_status := FND_API.G_RET_STS_ERROR;
543: FND_MSG_PUB.Count_And_Get
544: ( p_encoded => FND_API.G_FALSE,p_count => x_msg_count,
545: p_data => x_msg_data
546: );

Line 544: ( p_encoded => FND_API.G_FALSE,p_count => x_msg_count,

540: WHEN FND_API.G_EXC_ERROR THEN
541: ROLLBACK TO Update_Profile_check_PVT;
542: x_return_status := FND_API.G_RET_STS_ERROR;
543: FND_MSG_PUB.Count_And_Get
544: ( p_encoded => FND_API.G_FALSE,p_count => x_msg_count,
545: p_data => x_msg_data
546: );
547: APP_EXCEPTION.RAISE_EXCEPTION;
548: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 548: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

544: ( p_encoded => FND_API.G_FALSE,p_count => x_msg_count,
545: p_data => x_msg_data
546: );
547: APP_EXCEPTION.RAISE_EXCEPTION;
548: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
549: ROLLBACK TO Update_Profile_check_PVT;
550: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
551: FND_MSG_PUB.Count_And_Get
552: ( p_count => x_msg_count,

Line 550: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

546: );
547: APP_EXCEPTION.RAISE_EXCEPTION;
548: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
549: ROLLBACK TO Update_Profile_check_PVT;
550: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
551: FND_MSG_PUB.Count_And_Get
552: ( p_count => x_msg_count,
553: p_data => x_msg_data
554: );

Line 558: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

554: );
555: APP_EXCEPTION.RAISE_EXCEPTION;
556: WHEN OTHERS THEN
557: ROLLBACK TO Update_Profile_check_PVT;
558: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
559: FND_MSG_PUB.Build_Exc_Msg(G_PKG_NAME, l_api_name);
560: FND_MSG_PUB.Count_And_Get
561: ( p_count => x_msg_count,
562: p_data => x_msg_data

Line 569: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

565: End Update_Profile_check;
566:
567: PROCEDURE Delete_profile_check(
568: P_Api_Version_Number IN NUMBER,
569: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
570: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
571: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
572: p_Check_Id IN NUMBER,
573: p_OBJECT_VERSION_NUMBER IN NUMBER,

Line 570: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

566:
567: PROCEDURE Delete_profile_check(
568: P_Api_Version_Number IN NUMBER,
569: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
570: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
571: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
572: p_Check_Id IN NUMBER,
573: p_OBJECT_VERSION_NUMBER IN NUMBER,
574: X_Return_Status OUT NOCOPY VARCHAR2,

Line 571: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

567: PROCEDURE Delete_profile_check(
568: P_Api_Version_Number IN NUMBER,
569: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
570: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
571: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
572: p_Check_Id IN NUMBER,
573: p_OBJECT_VERSION_NUMBER IN NUMBER,
574: X_Return_Status OUT NOCOPY VARCHAR2,
575: X_Msg_Count OUT NOCOPY NUMBER,

Line 587: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

583: -- Standard Start of API savepoint
584: SAVEPOINT DELETE_Profile_Checks_PVT;
585:
586: -- Standard call to check for call compatibility.
587: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
588: p_api_version_number,
589: l_api_name,
590: G_PKG_NAME)
591: THEN

Line 592: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

588: p_api_version_number,
589: l_api_name,
590: G_PKG_NAME)
591: THEN
592: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
593: END IF;
594:
595:
596: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 597: IF FND_API.to_Boolean( p_init_msg_list )

593: END IF;
594:
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 605: x_return_status := FND_API.G_RET_STS_SUCCESS;

601:
602:
603:
604: -- Initialize API return status to SUCCESS
605: x_return_status := FND_API.G_RET_STS_SUCCESS;
606:
607: --
608: -- Api body
609: --

Line 619: IF FND_API.to_Boolean( p_commit )

615: -- End of API body
616: --
617:
618: -- Standard check for p_commit
619: IF FND_API.to_Boolean( p_commit )
620: THEN
621: COMMIT WORK;
622: END IF;
623:

Line 632: WHEN FND_API.G_EXC_ERROR THEN

628: p_data => x_msg_data
629: );
630:
631: EXCEPTION
632: WHEN FND_API.G_EXC_ERROR THEN
633: ROLLBACK TO DELETE_Profile_Checks_PVT;
634: x_return_status := FND_API.G_RET_STS_ERROR;
635: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,p_count => x_msg_count,
636: p_data => x_msg_data

Line 634: x_return_status := FND_API.G_RET_STS_ERROR;

630:
631: EXCEPTION
632: WHEN FND_API.G_EXC_ERROR THEN
633: ROLLBACK TO DELETE_Profile_Checks_PVT;
634: x_return_status := FND_API.G_RET_STS_ERROR;
635: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,p_count => x_msg_count,
636: p_data => x_msg_data
637: );
638: APP_EXCEPTION.RAISE_EXCEPTION;

Line 635: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,p_count => x_msg_count,

631: EXCEPTION
632: WHEN FND_API.G_EXC_ERROR THEN
633: ROLLBACK TO DELETE_Profile_Checks_PVT;
634: x_return_status := FND_API.G_RET_STS_ERROR;
635: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,p_count => x_msg_count,
636: p_data => x_msg_data
637: );
638: APP_EXCEPTION.RAISE_EXCEPTION;
639: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 639: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

635: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,p_count => x_msg_count,
636: p_data => x_msg_data
637: );
638: APP_EXCEPTION.RAISE_EXCEPTION;
639: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
640: ROLLBACK TO DELETE_Profile_Checks_PVT;
641: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
642: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
643: p_data => x_msg_data

Line 641: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

637: );
638: APP_EXCEPTION.RAISE_EXCEPTION;
639: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
640: ROLLBACK TO DELETE_Profile_Checks_PVT;
641: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
642: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
643: p_data => x_msg_data
644: );
645: APP_EXCEPTION.RAISE_EXCEPTION;

Line 648: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

644: );
645: APP_EXCEPTION.RAISE_EXCEPTION;
646: WHEN OTHERS THEN
647: ROLLBACK TO DELETE_Profile_Checks_PVT;
648: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
649: FND_MSG_PUB.Build_Exc_Msg(G_PKG_NAME, l_api_name);
650: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
651: p_data => x_msg_data
652: );

Line 677: x_return_status := FND_API.G_RET_STS_SUCCESS;

673: l_dummy NUMBER;
674: BEGIN
675:
676: -- Initialize API return status to SUCCESS
677: x_return_status := FND_API.G_RET_STS_SUCCESS;
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

Line 680: IF FND_API.to_Boolean( p_init_msg_list )

676: -- Initialize API return status to SUCCESS
677: x_return_status := FND_API.G_RET_STS_SUCCESS;
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 689: x_return_status := FND_API.G_RET_STS_ERROR;

685: -- validate NOT NULL column
686: IF (p_CHECK_NAME is NULL)
687: THEN
688: --Mandatory argument error..
689: x_return_status := FND_API.G_RET_STS_ERROR;
690: CSC_CORE_UTILS_PVT.mandatory_arg_error(
691: p_api_name => p_api_name,
692: p_argument => 'p_check_name',
693: p_argument_value => p_check_name);

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

696: IF(p_validation_mode = G_CREATE)
697: THEN
698: -- IF p_CHECK_NAME is not NULL and p_CHECK_NAME <> G_MISS_CHAR
699: -- verify if data is valid
700: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
701: IF (p_check_name is not NULL and p_CHECK_NAME <> CSC_CORE_UTILS_PVT.G_MISS_CHAR)
702: THEN
703: Open C2;
704: Fetch C2 into l_dummy;

Line 706: x_return_status := FND_API.G_RET_STS_ERROR;

702: THEN
703: Open C2;
704: Fetch C2 into l_dummy;
705: IF C2%FOUND THEN
706: x_return_status := FND_API.G_RET_STS_ERROR;
707: CSC_CORE_UTILS_PVT.Add_Duplicate_Value_Msg(
708: p_api_name => p_api_name,
709: p_argument => 'p_check_name' ,
710: p_argument_value => p_check_name);

Line 714: x_return_status := FND_API.G_RET_STS_ERROR;

710: p_argument_value => p_check_name);
711: END IF;
712: Close C2;
713: ELSE
714: x_return_status := FND_API.G_RET_STS_ERROR;
715: CSC_CORE_UTILS_PVT.mandatory_arg_error(
716: p_api_name => p_api_name,
717: p_argument => 'p_check_name',
718: p_argument_value => p_check_name);

Line 726: x_return_status := FND_API.G_RET_STS_ERROR;

722: THEN
723: -- if the check name is passed in and as NULL then
724: -- its a mandatory argument error.
725: if ( p_check_name IS NULL ) then
726: x_return_status := FND_API.G_RET_STS_ERROR;
727: CSC_CORE_UTILS_PVT.mandatory_arg_error(
728: p_api_name => p_api_name,
729: p_argument => 'p_check_name',
730: p_argument_value => p_check_name);

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

729: p_argument => 'p_check_name',
730: p_argument_value => p_check_name);
731: -- IF p_CHECK_NAME <> G_MISS_CHAR
732: -- verify if data is valid
733: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
734: ELSIF p_CHECK_NAME <> CSC_CORE_UTILS_PVT.G_MISS_CHAR
735: THEN
736: Open C2;
737: Loop

Line 740: x_return_status := FND_API.G_RET_STS_ERROR;

736: Open C2;
737: Loop
738: Fetch C2 into l_dummy;
739: IF (l_dummy <> p_Check_id) THEN
740: x_return_status := FND_API.G_RET_STS_ERROR;
741: CSC_CORE_UTILS_PVT.mandatory_arg_error(
742: p_api_name => p_api_name,
743: p_argument => 'p_check_name',
744: p_argument_value => p_check_name);

Line 777: IF FND_API.to_Boolean( p_init_msg_list )

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

Line 784: x_return_status := FND_API.G_RET_STS_SUCCESS;

780: END IF;
781:
782:
783: -- Initialize API return status to SUCCESS
784: x_return_status := FND_API.G_RET_STS_SUCCESS;
785:
786:
787: -- validate NOT NULL column
788: IF (p_CHECK_NAME_CODE is NULL)

Line 791: x_return_status := FND_API.G_RET_STS_ERROR;

787: -- validate NOT NULL column
788: IF (p_CHECK_NAME_CODE is NULL)
789: THEN
790: --Mandatory argument error..
791: x_return_status := FND_API.G_RET_STS_ERROR;
792: CSC_CORE_UTILS_PVT.mandatory_arg_error(
793: p_api_name => p_api_name,
794: p_argument => 'p_check_name_code',
795: p_argument_value => p_check_name_code);

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

799: THEN
800: -- Hint: Validate data
801: -- IF p_CHECK_NAME_CODE is not NULL and p_CHECK_NAME_CODE <> G_MISS_CHAR
802: -- verify if data is valid
803: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
804: IF (p_CHECK_NAME_CODE is not NULL and p_CHECK_NAME_CODE <> CSC_CORE_UTILS_PVT.G_MISS_CHAR)
805: THEN
806: Open C2;
807: Fetch C2 into l_dummy;

Line 809: x_return_status := FND_API.G_RET_STS_ERROR;

805: THEN
806: Open C2;
807: Fetch C2 into l_dummy;
808: IF C2%FOUND THEN
809: x_return_status := FND_API.G_RET_STS_ERROR;
810: CSC_CORE_UTILS_PVT.Add_Duplicate_Value_Msg(
811: p_api_name => p_api_name,
812: p_argument => 'p_check_name_code' ,
813: p_argument_value => p_check_name_code);

Line 817: x_return_status := FND_API.G_RET_STS_ERROR;

813: p_argument_value => p_check_name_code);
814: END IF;
815: Close C2;
816: ELSE
817: x_return_status := FND_API.G_RET_STS_ERROR;
818: CSC_CORE_UTILS_PVT.mandatory_arg_error(
819: p_api_name => p_api_name,
820: p_argument => 'p_check_name_code',
821: p_argument_value => p_check_name_code);

Line 829: x_return_status := FND_API.G_RET_STS_ERROR;

825: THEN
826: -- if the check name code is passed in and as NULL then
827: -- its a mandatory argument error.
828: if ( p_check_name_code IS NULL ) then
829: x_return_status := FND_API.G_RET_STS_ERROR;
830: CSC_CORE_UTILS_PVT.mandatory_arg_error(
831: p_api_name => p_api_name,
832: p_argument => 'p_check_name_code',
833: p_argument_value => p_check_name_code);

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

833: p_argument_value => p_check_name_code);
834: -- Hint: Validate data
835: -- IF p_CHECK_NAME_CODE <> G_MISS_CHAR
836: -- verify if data is valid
837: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
838: ELSIF p_CHECK_NAME_CODE <> CSC_CORE_UTILS_PVT.G_MISS_CHAR
839: THEN
840: Open C2;
841: Loop

Line 844: x_return_status := FND_API.G_RET_STS_ERROR;

840: Open C2;
841: Loop
842: Fetch C2 into l_dummy;
843: IF (l_dummy <> p_Check_id) THEN
844: x_return_status := FND_API.G_RET_STS_ERROR;
845: CSC_CORE_UTILS_PVT.mandatory_arg_error(
846: p_api_name => p_api_name,
847: p_argument => 'p_check_name_code',
848: p_argument_value => p_check_name_code);

Line 875: IF FND_API.to_Boolean( p_init_msg_list )

871: IS
872: BEGIN
873:
874: -- Initialize message list if p_init_msg_list is set to TRUE.
875: IF FND_API.to_Boolean( p_init_msg_list )
876: THEN
877: FND_MSG_PUB.initialize;
878: END IF;
879:

Line 882: x_return_status := FND_API.G_RET_STS_SUCCESS;

878: END IF;
879:
880:
881: -- Initialize API return status to SUCCESS
882: x_return_status := FND_API.G_RET_STS_SUCCESS;
883:
884: CSC_CORE_UTILS_PVT.Validate_Start_End_Dt
885: ( p_api_name => p_Api_name,
886: p_start_date => p_start_date_active,

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

885: ( p_api_name => p_Api_name,
886: p_start_date => p_start_date_active,
887: p_end_date => p_end_date,
888: x_return_status => x_return_status );
889: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
890: x_return_status := FND_API.G_RET_STS_ERROR;
891: END IF;
892:
893: -- Standard call to get message count and if count is 1, get message info.

Line 890: x_return_status := FND_API.G_RET_STS_ERROR;

886: p_start_date => p_start_date_active,
887: p_end_date => p_end_date,
888: x_return_status => x_return_status );
889: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
890: x_return_status := FND_API.G_RET_STS_ERROR;
891: END IF;
892:
893: -- Standard call to get message count and if count is 1, get message info.
894: FND_MSG_PUB.Count_And_Get

Line 915: IF FND_API.to_Boolean( p_init_msg_list )

911: IS
912: BEGIN
913:
914: -- Initialize message list if p_init_msg_list is set to TRUE.
915: IF FND_API.to_Boolean( p_init_msg_list )
916: THEN
917: FND_MSG_PUB.initialize;
918: END IF;
919:

Line 922: x_return_status := FND_API.G_RET_STS_SUCCESS;

918: END IF;
919:
920:
921: -- Initialize API return status to SUCCESS
922: x_return_status := FND_API.G_RET_STS_SUCCESS;
923:
924:
925:
926: -- Check if the seeded flag is passed in and is not null, if passed in

Line 934: p_lookup_code => p_seeded_flag ) <> FND_API.G_RET_STS_SUCCESS

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

Line 936: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 961: x_return_status := FND_API.G_RET_STS_SUCCESS;

957: ) IS
958: --
959: BEGIN
960: --
961: x_return_status := FND_API.G_RET_STS_SUCCESS;
962:
963: -- check if the check_level is passed in and is not
964: -- null
965:

Line 970: x_return_status := FND_API.G_RET_STS_ERROR;

966: IF (( p_check_level <> CSC_CORE_UTILS_PVT.G_MISS_CHAR ) AND
967: ( p_check_level IS NOT NULL )) THEN
968: IF (p_check_level <> 'PARTY' AND p_check_level <> 'ACCOUNT'AND p_check_level <> 'CONTACT' AND p_check_level <> 'EMPLOYEE')
969: THEN
970: x_return_status := FND_API.G_RET_STS_ERROR;
971: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(p_api_name => p_api_name,
972: p_argument_value => p_check_level,
973: p_argument => p_parameter_name);
974: END IF;

Line 993: IF FND_API.to_Boolean( p_init_msg_list )

989: IS
990: BEGIN
991:
992: -- Initialize message list if p_init_msg_list is set to TRUE.
993: IF FND_API.to_Boolean( p_init_msg_list )
994: THEN
995: FND_MSG_PUB.initialize;
996: END IF;
997:

Line 1000: x_return_status := FND_API.G_RET_STS_SUCCESS;

996: END IF;
997:
998:
999: -- Initialize API return status to SUCCESS
1000: x_return_status := FND_API.G_RET_STS_SUCCESS;
1001:
1002:
1003: IF NOT p_select_type in ('B','T') THEN
1004: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1004: x_return_status := FND_API.G_RET_STS_ERROR;

1000: x_return_status := FND_API.G_RET_STS_SUCCESS;
1001:
1002:
1003: IF NOT p_select_type in ('B','T') THEN
1004: x_return_status := FND_API.G_RET_STS_ERROR;
1005: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(
1006: p_api_name => p_api_name,
1007: p_argument => 'P_SELECT_TYPE',
1008: p_argument_value => p_select_type);

Line 1041: IF FND_API.to_Boolean( p_init_msg_list )

1037: l_dummy number;
1038: BEGIN
1039:
1040: -- Initialize message list if p_init_msg_list is set to TRUE.
1041: IF FND_API.to_Boolean( p_init_msg_list )
1042: THEN
1043: FND_MSG_PUB.initialize;
1044: END IF;
1045:

Line 1048: x_return_status := FND_API.G_RET_STS_SUCCESS;

1044: END IF;
1045:
1046:
1047: -- Initialize API return status to SUCCESS
1048: x_return_status := FND_API.G_RET_STS_SUCCESS;
1049:
1050: IF p_SELECT_TYPE = 'B' THEN
1051: -- validate NOT NULL column
1052: IF(p_SELECT_BLOCK_ID is NULL)

Line 1055: x_return_status := FND_API.G_RET_STS_ERROR;

1051: -- validate NOT NULL column
1052: IF(p_SELECT_BLOCK_ID is NULL)
1053: THEN
1054: -- Mandatory argument error..
1055: x_return_status := FND_API.G_RET_STS_ERROR;
1056: CSC_CORE_UTILS_PVT.mandatory_arg_error(
1057: p_api_name => p_api_name,
1058: p_argument => 'p_select_block_id',
1059: p_argument_value => p_select_block_id);

Line 1064: x_return_status := FND_API.G_RET_STS_ERROR;

1060: END IF;
1061: ELSE
1062: IF (p_SELECT_BLOCK_ID IS NOT NULL) AND (p_SELECT_BLOCK_ID <> CSC_CORE_UTILS_PVT.G_MISS_NUM)
1063: THEN
1064: x_return_status := FND_API.G_RET_STS_ERROR;
1065: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(
1066: p_api_name => p_api_name,
1067: p_argument_value => p_select_block_id,
1068: p_argument => 'p_select_block_id');

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

1073: THEN
1074: -- Hint: Validate data
1075: -- IF p_SELECT_BLOCK_ID is not NULL and p_SELECT_BLOCK_ID <> G_MISS_CHAR
1076: -- verify if data is valid
1077: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1078: IF p_SELECT_TYPE = 'B' THEN
1079: IF (p_SELECT_BLOCK_ID <> CSC_CORE_UTILS_PVT.G_MISS_NUM)
1080: THEN
1081: Open C2;

Line 1084: x_return_status := FND_API.G_RET_STS_ERROR;

1080: THEN
1081: Open C2;
1082: Fetch C2 into l_dummy;
1083: IF C2%NOTFOUND THEN
1084: x_return_status := FND_API.G_RET_STS_ERROR;
1085:
1086: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(
1087: p_api_name => p_api_name,
1088: p_argument_value => p_select_block_id,

Line 1094: x_return_status := FND_API.G_RET_STS_ERROR;

1090:
1091: END IF;
1092: Close C2;
1093: ELSE
1094: x_return_status := FND_API.G_RET_STS_ERROR;
1095: CSC_CORE_UTILS_PVT.mandatory_arg_error(
1096: p_api_name => p_api_name,
1097: p_argument => 'p_select_block_id',
1098: p_argument_value => p_select_block_id);

Line 1109: x_return_status := FND_API.G_RET_STS_ERROR;

1105: -- its a mandatory argument error.
1106: -- added the outer if condition to fix the bug 1563264
1107: IF(p_SELECT_TYPE = 'B') THEN
1108: if ( p_select_block_id IS NULL ) then
1109: x_return_status := FND_API.G_RET_STS_ERROR;
1110: CSC_CORE_UTILS_PVT.mandatory_arg_error(
1111: p_api_name => p_api_name,
1112: p_argument => 'p_select_block_id',
1113: p_argument_value => p_select_block_id);

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

1113: p_argument_value => p_select_block_id);
1114: -- Hint: Validate data
1115: -- IF p_SELECT_BLOCK_ID <> G_MISS_NUM
1116: -- verify if data is valid
1117: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1118: ELSIF p_SELECT_BLOCK_ID <> CSC_CORE_UTILS_PVT.G_MISS_NUM
1119: THEN
1120: Open C2;
1121: Loop

Line 1124: x_return_status := FND_API.G_RET_STS_ERROR;

1120: Open C2;
1121: Loop
1122: Fetch C2 into l_dummy;
1123: IF C2%NOTFOUND THEN
1124: x_return_status := FND_API.G_RET_STS_ERROR;
1125: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(
1126: p_api_name => p_api_name,
1127: p_argument_value => p_select_block_id,
1128: p_argument => 'p_select_block_id');

Line 1161: IF FND_API.to_Boolean( p_init_msg_list )

1157: IS
1158: BEGIN
1159:
1160: -- Initialize message list if p_init_msg_list is set to TRUE.
1161: IF FND_API.to_Boolean( p_init_msg_list )
1162: THEN
1163: FND_MSG_PUB.initialize;
1164: END IF;
1165:

Line 1168: x_return_status := FND_API.G_RET_STS_SUCCESS;

1164: END IF;
1165:
1166:
1167: -- Initialize API return status to SUCCESS
1168: x_return_status := FND_API.G_RET_STS_SUCCESS;
1169:
1170:
1171: IF p_DATA_TYPE is not NULL and p_DATA_TYPE <> CSC_CORE_UTILS_PVT.G_MISS_CHAR
1172: THEN

Line 1175: x_return_status := FND_API.G_RET_STS_ERROR;

1171: IF p_DATA_TYPE is not NULL and p_DATA_TYPE <> CSC_CORE_UTILS_PVT.G_MISS_CHAR
1172: THEN
1173: -- Added 'BOOLEAN' in the IN CLAUSE . Bug #1231208
1174: IF NOT p_DATA_TYPE IN ('NUMBER','VARCHAR2','DATE', 'BOOLEAN') THEN
1175: x_return_status := FND_API.G_RET_STS_ERROR;
1176: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(
1177: p_api_name => p_api_name,
1178: p_argument_value => p_data_type,
1179: p_argument => 'P_DATA_TYPE');

Line 1206: IF FND_API.to_Boolean( p_init_msg_list )

1202: IS
1203: BEGIN
1204:
1205: -- Initialize message list if p_init_msg_list is set to TRUE.
1206: IF FND_API.to_Boolean( p_init_msg_list )
1207: THEN
1208: FND_MSG_PUB.initialize;
1209: END IF;
1210:

Line 1213: x_return_status := FND_API.G_RET_STS_SUCCESS;

1209: END IF;
1210:
1211:
1212: -- Initialize API return status to SUCCESS
1213: x_return_status := FND_API.G_RET_STS_SUCCESS;
1214:
1215: -- IF p_THRESHOLD_GRADE is not NULL and p_THRESHOLD_GRADE <> G_MISS_CHAR
1216: -- verify if data is valid
1217: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;

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

1213: x_return_status := FND_API.G_RET_STS_SUCCESS;
1214:
1215: -- IF p_THRESHOLD_GRADE is not NULL and p_THRESHOLD_GRADE <> G_MISS_CHAR
1216: -- verify if data is valid
1217: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1218:
1219:
1220: IF(p_validation_mode = CSC_CORE_UTILS_PVT.G_CREATE)
1221: THEN

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

1221: THEN
1222: -- Hint: Validate data
1223: -- IF p_THRESHOLD_GRADE is not NULL and p_THRESHOLD_GRADE <> G_MISS_CHAR
1224: -- verify if data is valid
1225: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1226: NULL;
1227: ELSIF(p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE)
1228: THEN
1229: -- Hint: Validate data

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

1228: THEN
1229: -- Hint: Validate data
1230: -- IF p_THRESHOLD_GRADE <> G_MISS_CHAR
1231: -- verify if data is valid
1232: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1233: NULL;
1234: END IF;
1235:
1236: -- Standard call to get message count and if count is 1, get message info.

Line 1258: IF FND_API.to_Boolean( p_init_msg_list )

1254: IS
1255: BEGIN
1256:
1257: -- Initialize message list if p_init_msg_list is set to TRUE.
1258: IF FND_API.to_Boolean( p_init_msg_list )
1259: THEN
1260: FND_MSG_PUB.initialize;
1261: END IF;
1262:

Line 1264: x_return_status := FND_API.G_RET_STS_SUCCESS;

1260: FND_MSG_PUB.initialize;
1261: END IF;
1262:
1263: -- Initialize API return status to SUCCESS
1264: x_return_status := FND_API.G_RET_STS_SUCCESS;
1265:
1266: -- Hint: Validate data
1267: -- IF p_THRESHOLD_RATING_CODE is not NULL and p_THRESHOLD_RATING_CODE <> G_MISS_CHAR
1268: -- verify if data is valid

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

1265:
1266: -- Hint: Validate data
1267: -- IF p_THRESHOLD_RATING_CODE is not NULL and p_THRESHOLD_RATING_CODE <> G_MISS_CHAR
1268: -- verify if data is valid
1269: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1270: IF (p_THRESHOLD_RATING_CODE is NOT NULL) AND (p_THRESHOLD_RATING_CODE <> CSC_CORE_UTILS_PVT.G_MISS_CHAR)
1271: THEN
1272: IF CSC_CORE_UTILS_PVT.csc_lookup_code_not_exists(
1273: p_effective_date => trunc(sysdate),

Line 1275: p_lookup_Code => p_threshold_rating_code ) <> FND_API.G_RET_STS_SUCCESS

1271: THEN
1272: IF CSC_CORE_UTILS_PVT.csc_lookup_code_not_exists(
1273: p_effective_date => trunc(sysdate),
1274: p_lookup_type => 'CSC_PROF_RATINGS',
1275: p_lookup_Code => p_threshold_rating_code ) <> FND_API.G_RET_STS_SUCCESS
1276: THEN
1277: x_return_status := FND_API.G_RET_STS_ERROR;
1278: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(
1279: p_api_name=> p_api_name,

Line 1277: x_return_status := FND_API.G_RET_STS_ERROR;

1273: p_effective_date => trunc(sysdate),
1274: p_lookup_type => 'CSC_PROF_RATINGS',
1275: p_lookup_Code => p_threshold_rating_code ) <> FND_API.G_RET_STS_SUCCESS
1276: THEN
1277: x_return_status := FND_API.G_RET_STS_ERROR;
1278: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(
1279: p_api_name=> p_api_name,
1280: p_argument_value => p_threshold_rating_code,
1281: p_argument=>'P_RATING_CODE' );

Line 1307: IF FND_API.to_Boolean( p_init_msg_list )

1303: IS
1304: BEGIN
1305:
1306: -- Initialize message list if p_init_msg_list is set to TRUE.
1307: IF FND_API.to_Boolean( p_init_msg_list )
1308: THEN
1309: FND_MSG_PUB.initialize;
1310: END IF;
1311:

Line 1314: x_return_status := FND_API.G_RET_STS_SUCCESS;

1310: END IF;
1311:
1312:
1313: -- Initialize API return status to SUCCESS
1314: x_return_status := FND_API.G_RET_STS_SUCCESS;
1315:
1316: IF p_CHECK_UPPER_LOWER_FLAG NOT IN ('U','L') THEN
1317: x_return_status := FND_API.G_RET_STS_ERROR;
1318: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(

Line 1317: x_return_status := FND_API.G_RET_STS_ERROR;

1313: -- Initialize API return status to SUCCESS
1314: x_return_status := FND_API.G_RET_STS_SUCCESS;
1315:
1316: IF p_CHECK_UPPER_LOWER_FLAG NOT IN ('U','L') THEN
1317: x_return_status := FND_API.G_RET_STS_ERROR;
1318: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(
1319: p_api_name => p_api_name,
1320: p_argument_value => p_check_upper_lower_flag,
1321: p_argument => 'P_CHECK_UPPER_LOWER_FLAG');

Line 1345: IF FND_API.to_Boolean( p_init_msg_list )

1341: IS
1342: BEGIN
1343:
1344: -- Initialize message list if p_init_msg_list is set to TRUE.
1345: IF FND_API.to_Boolean( p_init_msg_list )
1346: THEN
1347: FND_MSG_PUB.initialize;
1348: END IF;
1349:

Line 1352: x_return_status := FND_API.G_RET_STS_SUCCESS;

1348: END IF;
1349:
1350:
1351: -- Initialize API return status to SUCCESS
1352: x_return_status := FND_API.G_RET_STS_SUCCESS;
1353:
1354: NULL;
1355:
1356: -- Standard call to get message count and if count is 1, get message info.

Line 1378: IF FND_API.to_Boolean( p_init_msg_list )

1374: IS
1375: BEGIN
1376:
1377: -- Initialize message list if p_init_msg_list is set to TRUE.
1378: IF FND_API.to_Boolean( p_init_msg_list )
1379: THEN
1380: FND_MSG_PUB.initialize;
1381: END IF;
1382:

Line 1385: x_return_status := FND_API.G_RET_STS_SUCCESS;

1381: END IF;
1382:
1383:
1384: -- Initialize API return status to SUCCESS
1385: x_return_status := FND_API.G_RET_STS_SUCCESS;
1386:
1387: NULL;
1388:
1389: -- Standard call to get message count and if count is 1, get message info.

Line 1414: x_return_status := FND_API.G_RET_STS_SUCCESS;

1410: BEGIN
1411:
1412:
1413: -- Initialize API return status to SUCCESS
1414: x_return_status := FND_API.G_RET_STS_SUCCESS;
1415:
1416:
1417: Validate_CHECK_NAME(
1418: p_Api_Name => p_Api_Name,

Line 1419: p_init_msg_list => FND_API.G_FALSE,

1415:
1416:
1417: Validate_CHECK_NAME(
1418: p_Api_Name => p_Api_Name,
1419: p_init_msg_list => FND_API.G_FALSE,
1420: p_validation_mode => p_validation_mode,
1421: p_CHECK_NAME => P_Check_Rec.CHECK_NAME,
1422: p_CHECK_ID => P_CHECK_REC.CHECK_ID,
1423: x_return_status => x_return_status );

Line 1424: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1420: p_validation_mode => p_validation_mode,
1421: p_CHECK_NAME => P_Check_Rec.CHECK_NAME,
1422: p_CHECK_ID => P_CHECK_REC.CHECK_ID,
1423: x_return_status => x_return_status );
1424: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1425: raise FND_API.G_EXC_ERROR;
1426: END IF;
1427:
1428: Validate_CHECK_NAME_CODE(

Line 1425: raise FND_API.G_EXC_ERROR;

1421: p_CHECK_NAME => P_Check_Rec.CHECK_NAME,
1422: p_CHECK_ID => P_CHECK_REC.CHECK_ID,
1423: x_return_status => x_return_status );
1424: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1425: raise FND_API.G_EXC_ERROR;
1426: END IF;
1427:
1428: Validate_CHECK_NAME_CODE(
1429: p_Api_Name => p_Api_Name,

Line 1437: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1433: p_CHECK_ID => p_CHECK_Rec.CHECK_ID,
1434: x_return_status => x_return_status,
1435: x_msg_count => x_msg_count,
1436: x_msg_data => x_msg_data);
1437: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1438: raise FND_API.G_EXC_ERROR;
1439: END IF;
1440: -- validate start and end date
1441: CSC_CORE_UTILS_PVT.Validate_Start_End_Dt(

Line 1438: raise FND_API.G_EXC_ERROR;

1434: x_return_status => x_return_status,
1435: x_msg_count => x_msg_count,
1436: x_msg_data => x_msg_data);
1437: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1438: raise FND_API.G_EXC_ERROR;
1439: END IF;
1440: -- validate start and end date
1441: CSC_CORE_UTILS_PVT.Validate_Start_End_Dt(
1442: p_api_name => p_Api_name,

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

1443: p_start_date => p_check_rec.start_date_active,
1444: p_end_date => p_check_rec.end_date_active,
1445: x_return_status => x_return_status );
1446:
1447: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1448: RAISE FND_API.G_EXC_ERROR;
1449: END IF;
1450:
1451: Validate_SEEDED_FLAG(

Line 1448: RAISE FND_API.G_EXC_ERROR;

1444: p_end_date => p_check_rec.end_date_active,
1445: x_return_status => x_return_status );
1446:
1447: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1448: RAISE FND_API.G_EXC_ERROR;
1449: END IF;
1450:
1451: Validate_SEEDED_FLAG(
1452: p_APi_Name => p_Api_Name,

Line 1459: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1455: p_SEEDED_FLAG => P_Check_Rec.SEEDED_FLAG,
1456: x_return_status => x_return_status,
1457: x_msg_count => x_msg_count,
1458: x_msg_data => x_msg_data);
1459: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1460: raise FND_API.G_EXC_ERROR;
1461: END IF;
1462:
1463: Validate_SELECT_TYPE(

Line 1460: raise FND_API.G_EXC_ERROR;

1456: x_return_status => x_return_status,
1457: x_msg_count => x_msg_count,
1458: x_msg_data => x_msg_data);
1459: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1460: raise FND_API.G_EXC_ERROR;
1461: END IF;
1462:
1463: Validate_SELECT_TYPE(
1464: p_Api_Name => p_Api_Name,

Line 1471: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1467: p_SELECT_TYPE => P_Check_Rec.SELECT_TYPE,
1468: x_return_status => x_return_status,
1469: x_msg_count => x_msg_count,
1470: x_msg_data => x_msg_data);
1471: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1472: raise FND_API.G_EXC_ERROR;
1473: END IF;
1474:
1475:

Line 1472: raise FND_API.G_EXC_ERROR;

1468: x_return_status => x_return_status,
1469: x_msg_count => x_msg_count,
1470: x_msg_data => x_msg_data);
1471: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1472: raise FND_API.G_EXC_ERROR;
1473: END IF;
1474:
1475:
1476: Validate_SELECT_BLOCK_ID(

Line 1485: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1481: p_SELECT_TYPE => P_Check_Rec.SELECT_TYPE,
1482: x_return_status => x_return_status,
1483: x_msg_count => x_msg_count,
1484: x_msg_data => x_msg_data);
1485: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1486: raise FND_API.G_EXC_ERROR;
1487: END IF;
1488:
1489:

Line 1486: raise FND_API.G_EXC_ERROR;

1482: x_return_status => x_return_status,
1483: x_msg_count => x_msg_count,
1484: x_msg_data => x_msg_data);
1485: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1486: raise FND_API.G_EXC_ERROR;
1487: END IF;
1488:
1489:
1490: Validate_DATA_TYPE(

Line 1498: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1494: p_DATA_TYPE => P_Check_Rec.DATA_TYPE,
1495: x_return_status => x_return_status,
1496: x_msg_count => x_msg_count,
1497: x_msg_data => x_msg_data);
1498: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1499: raise FND_API.G_EXC_ERROR;
1500: END IF;
1501:
1502:

Line 1499: raise FND_API.G_EXC_ERROR;

1495: x_return_status => x_return_status,
1496: x_msg_count => x_msg_count,
1497: x_msg_data => x_msg_data);
1498: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1499: raise FND_API.G_EXC_ERROR;
1500: END IF;
1501:
1502:
1503: Validate_THRESHOLD_GRADE(

Line 1511: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1507: p_THRESHOLD_GRADE => P_Check_Rec.THRESHOLD_GRADE,
1508: x_return_status => x_return_status,
1509: x_msg_count => x_msg_count,
1510: x_msg_data => x_msg_data);
1511: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1512: raise FND_API.G_EXC_ERROR;
1513: END IF;
1514:
1515: Validate_THRESHOLD_RATING_CODE(

Line 1512: raise FND_API.G_EXC_ERROR;

1508: x_return_status => x_return_status,
1509: x_msg_count => x_msg_count,
1510: x_msg_data => x_msg_data);
1511: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1512: raise FND_API.G_EXC_ERROR;
1513: END IF;
1514:
1515: Validate_THRESHOLD_RATING_CODE(
1516: p_Api_Name => p_Api_Name,

Line 1523: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1519: p_THRESHOLD_RATING_CODE => P_Check_Rec.THRESHOLD_RATING_CODE,
1520: x_return_status => x_return_status,
1521: x_msg_count => x_msg_count,
1522: x_msg_data => x_msg_data);
1523: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1524: raise FND_API.G_EXC_ERROR;
1525: END IF;
1526:
1527: Validate_UPPER_LOWER_FLAG(

Line 1524: raise FND_API.G_EXC_ERROR;

1520: x_return_status => x_return_status,
1521: x_msg_count => x_msg_count,
1522: x_msg_data => x_msg_data);
1523: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1524: raise FND_API.G_EXC_ERROR;
1525: END IF;
1526:
1527: Validate_UPPER_LOWER_FLAG(
1528: p_Api_Name => p_Api_Name,

Line 1535: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1531: p_CHECK_UPPER_LOWER_FLAG => P_Check_Rec.CHECK_UPPER_LOWER_FLAG,
1532: x_return_status => x_return_status,
1533: x_msg_count => x_msg_count,
1534: x_msg_data => x_msg_data);
1535: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1536: raise FND_API.G_EXC_ERROR;
1537: END IF;
1538:
1539: Validate_THRESHOLD_COLOR_CODE(

Line 1536: raise FND_API.G_EXC_ERROR;

1532: x_return_status => x_return_status,
1533: x_msg_count => x_msg_count,
1534: x_msg_data => x_msg_data);
1535: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1536: raise FND_API.G_EXC_ERROR;
1537: END IF;
1538:
1539: Validate_THRESHOLD_COLOR_CODE(
1540: p_Api_Name => p_Api_Name,

Line 1547: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1543: p_THRESHOLD_COLOR_CODE => P_Check_Rec.THRESHOLD_COLOR_CODE,
1544: x_return_status => x_return_status,
1545: x_msg_count => x_msg_count,
1546: x_msg_data => x_msg_data);
1547: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1548: raise FND_API.G_EXC_ERROR;
1549: END IF;
1550:
1551: CSC_CORE_UTILS_PVT.Validate_APPLICATION_ID (

Line 1548: raise FND_API.G_EXC_ERROR;

1544: x_return_status => x_return_status,
1545: x_msg_count => x_msg_count,
1546: x_msg_data => x_msg_data);
1547: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1548: raise FND_API.G_EXC_ERROR;
1549: END IF;
1550:
1551: CSC_CORE_UTILS_PVT.Validate_APPLICATION_ID (
1552: P_Init_Msg_List => CSC_CORE_UTILS_PVT.G_FALSE,

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

1555: X_Return_Status => x_return_status,
1556: X_Msg_Count => x_msg_count,
1557: X_Msg_Data => x_msg_data );
1558:
1559: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1560: RAISE FND_API.G_EXC_ERROR;
1561: END IF;
1562:
1563: --Validate Check_level

Line 1560: RAISE FND_API.G_EXC_ERROR;

1556: X_Msg_Count => x_msg_count,
1557: X_Msg_Data => x_msg_data );
1558:
1559: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1560: RAISE FND_API.G_EXC_ERROR;
1561: END IF;
1562:
1563: --Validate Check_level
1564: Validate_Check_Level(

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

1566: p_parameter_name => 'p_Check_Level',
1567: p_check_level => P_Check_Rec.check_level,
1568: x_return_status => x_return_status );
1569:
1570: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1571: RAISE FND_API.G_EXC_ERROR;
1572: END IF;
1573:
1574: /*

Line 1571: RAISE FND_API.G_EXC_ERROR;

1567: p_check_level => P_Check_Rec.check_level,
1568: x_return_status => x_return_status );
1569:
1570: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1571: RAISE FND_API.G_EXC_ERROR;
1572: END IF;
1573:
1574: /*
1575: Validate_CATEGORY_CODE(

Line 1583: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1579: p_CATEGORY_CODE => P_Check_Rec.CATEGORY_CODE,
1580: x_return_status => x_return_status,
1581: x_msg_count => x_msg_count,
1582: x_msg_data => x_msg_data);
1583: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1584: raise FND_API.G_EXC_ERROR;
1585: END IF;
1586: */
1587: END Validate_check;

Line 1584: raise FND_API.G_EXC_ERROR;

1580: x_return_status => x_return_status,
1581: x_msg_count => x_msg_count,
1582: x_msg_data => x_msg_data);
1583: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1584: raise FND_API.G_EXC_ERROR;
1585: END IF;
1586: */
1587: END Validate_check;
1588: