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 972: x_return_status := FND_API.G_RET_STS_ERROR;

968: -- Commented the Following condition for ER#8473903
969: -- IF (p_check_level <> 'PARTY' AND p_check_level <> 'ACCOUNT'AND p_check_level <> 'CONTACT' AND p_check_level <> 'EMPLOYEE')
970: IF (p_check_level <> 'PARTY' AND p_check_level <> 'ACCOUNT'AND p_check_level <> 'CONTACT' AND p_check_level <> 'EMPLOYEE' AND p_check_level<> 'SITE') -- Included the 'SITE' for NCR ER#8473903
971: THEN
972: x_return_status := FND_API.G_RET_STS_ERROR;
973: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(p_api_name => p_api_name,
974: p_argument_value => p_check_level,
975: p_argument => p_parameter_name);
976: END IF;

Line 995: IF FND_API.to_Boolean( p_init_msg_list )

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

Line 1002: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 1006: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1043: IF FND_API.to_Boolean( p_init_msg_list )

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

Line 1050: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 1057: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1066: x_return_status := FND_API.G_RET_STS_ERROR;

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

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

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

Line 1086: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1096: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1111: x_return_status := FND_API.G_RET_STS_ERROR;

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

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

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

Line 1126: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1163: IF FND_API.to_Boolean( p_init_msg_list )

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

Line 1170: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 1177: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1208: IF FND_API.to_Boolean( p_init_msg_list )

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

Line 1215: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

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

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

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

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

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

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

Line 1260: IF FND_API.to_Boolean( p_init_msg_list )

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

Line 1266: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

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

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

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

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

Line 1279: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1309: IF FND_API.to_Boolean( p_init_msg_list )

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

Line 1316: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 1319: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1347: IF FND_API.to_Boolean( p_init_msg_list )

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

Line 1354: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 1380: IF FND_API.to_Boolean( p_init_msg_list )

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

Line 1387: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 1416: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 1421: p_init_msg_list => FND_API.G_FALSE,

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

Line 1426: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

Line 1427: raise FND_API.G_EXC_ERROR;

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

Line 1439: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

Line 1440: raise FND_API.G_EXC_ERROR;

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

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

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

Line 1450: RAISE FND_API.G_EXC_ERROR;

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

Line 1461: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

Line 1462: raise FND_API.G_EXC_ERROR;

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

Line 1473: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

Line 1474: raise FND_API.G_EXC_ERROR;

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

Line 1487: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

Line 1488: raise FND_API.G_EXC_ERROR;

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

Line 1500: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

Line 1501: raise FND_API.G_EXC_ERROR;

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

Line 1513: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

Line 1514: raise FND_API.G_EXC_ERROR;

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

Line 1525: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

Line 1526: raise FND_API.G_EXC_ERROR;

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

Line 1537: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

Line 1538: raise FND_API.G_EXC_ERROR;

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

Line 1549: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

Line 1550: raise FND_API.G_EXC_ERROR;

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

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

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

Line 1562: RAISE FND_API.G_EXC_ERROR;

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

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

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

Line 1573: RAISE FND_API.G_EXC_ERROR;

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

Line 1585: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

Line 1586: raise FND_API.G_EXC_ERROR;

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