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

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

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

Line 137: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

133: -- Standard Start of API savepoint
134: SAVEPOINT CREATE_CHECK_RATINGS_PVT;
135:
136: -- Standard call to check for call compatibility.
137: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
138: p_api_version_number,
139: l_api_name,
140: G_PKG_NAME)
141: THEN

Line 142: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

138: p_api_version_number,
139: l_api_name,
140: G_PKG_NAME)
141: THEN
142: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
143: END IF;
144:
145:
146: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 147: IF FND_API.to_Boolean( p_init_msg_list )

143: END IF;
144:
145:
146: -- Initialize message list if p_init_msg_list is set to TRUE.
147: IF FND_API.to_Boolean( p_init_msg_list )
148: THEN
149: FND_MSG_PUB.initialize;
150: END IF;
151:

Line 153: x_return_status := FND_API.G_RET_STS_SUCCESS;

149: FND_MSG_PUB.initialize;
150: END IF;
151:
152: -- Initialize API return status to SUCCESS
153: x_return_status := FND_API.G_RET_STS_SUCCESS;
154:
155: --
156: -- API body
157: --

Line 173: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

169: x_msg_count => x_msg_count,
170: x_msg_data => x_msg_data);
171: END IF;
172:
173: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
174: RAISE FND_API.G_EXC_ERROR;
175: END IF;
176:
177: -- Invoke table handler(CSC_PROF_CHECK_RATINGS_PKG.Insert_Row)

Line 174: RAISE FND_API.G_EXC_ERROR;

170: x_msg_data => x_msg_data);
171: END IF;
172:
173: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
174: RAISE FND_API.G_EXC_ERROR;
175: END IF;
176:
177: -- Invoke table handler(CSC_PROF_CHECK_RATINGS_PKG.Insert_Row)
178: CSC_PROF_CHECK_RATINGS_PKG.Insert_Row(

Line 195: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

191: p_LAST_UPDATE_LOGIN => P_CHK_RATING_rec.LAST_UPDATE_LOGIN ,
192: p_SEEDED_FLAG => P_CHK_RATING_rec.SEEDED_FLAG);
193:
194:
195: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
196: RAISE FND_API.G_EXC_ERROR;
197: END IF;
198:
199: --

Line 196: RAISE FND_API.G_EXC_ERROR;

192: p_SEEDED_FLAG => P_CHK_RATING_rec.SEEDED_FLAG);
193:
194:
195: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
196: RAISE FND_API.G_EXC_ERROR;
197: END IF;
198:
199: --
200: -- End of API body

Line 204: IF FND_API.to_Boolean( p_commit )

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

Line 217: WHEN FND_API.G_EXC_ERROR THEN

213: p_data => x_msg_data
214: );
215:
216: EXCEPTION
217: WHEN FND_API.G_EXC_ERROR THEN
218: ROLLBACK TO Create_check_ratings_PVT;
219: x_return_status := FND_API.G_RET_STS_ERROR;
220: FND_MSG_PUB.Count_And_Get
221: ( p_count => x_msg_count,

Line 219: x_return_status := FND_API.G_RET_STS_ERROR;

215:
216: EXCEPTION
217: WHEN FND_API.G_EXC_ERROR THEN
218: ROLLBACK TO Create_check_ratings_PVT;
219: x_return_status := FND_API.G_RET_STS_ERROR;
220: FND_MSG_PUB.Count_And_Get
221: ( p_count => x_msg_count,
222: p_data => x_msg_data
223: );

Line 225: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

221: ( p_count => x_msg_count,
222: p_data => x_msg_data
223: );
224: APP_EXCEPTION.RAISE_EXCEPTION;
225: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
226: ROLLBACK TO Create_check_ratings_PVT;
227: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
228: FND_MSG_PUB.Count_And_Get
229: ( p_count => x_msg_count,

Line 227: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

223: );
224: APP_EXCEPTION.RAISE_EXCEPTION;
225: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
226: ROLLBACK TO Create_check_ratings_PVT;
227: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
228: FND_MSG_PUB.Count_And_Get
229: ( p_count => x_msg_count,
230: p_data => x_msg_data
231: );

Line 235: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

231: );
232: APP_EXCEPTION.RAISE_EXCEPTION;
233: WHEN OTHERS THEN
234: ROLLBACK TO Create_check_ratings_PVT;
235: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
236: FND_MSG_PUB.Build_Exc_Msg(G_PKG_NAME, l_api_name);
237: FND_MSG_PUB.Count_And_Get
238: ( p_count => x_msg_count,
239: p_data => x_msg_data

Line 345: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

341: -- Standard Start of API savepoint
342: SAVEPOINT UPDATE_CHECK_RATINGS_PVT;
343:
344: -- Standard call to check for call compatibility.
345: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
346: p_api_version_number,
347: l_api_name,
348: G_PKG_NAME)
349: THEN

Line 350: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

346: p_api_version_number,
347: l_api_name,
348: G_PKG_NAME)
349: THEN
350: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
351: END IF;
352:
353:
354: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 355: IF FND_API.to_Boolean( p_init_msg_list )

351: END IF;
352:
353:
354: -- Initialize message list if p_init_msg_list is set to TRUE.
355: IF FND_API.to_Boolean( p_init_msg_list )
356: THEN
357: FND_MSG_PUB.initialize;
358: END IF;
359:

Line 362: x_return_status := FND_API.G_RET_STS_SUCCESS;

358: END IF;
359:
360:
361: -- Initialize API return status to SUCCESS
362: x_return_status := FND_API.G_RET_STS_SUCCESS;
363:
364: --
365: -- Api body
366: --

Line 389: raise FND_API.G_EXC_ERROR;

385: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
386: THEN
387: CSC_CORE_UTILS_PVT.Record_Is_Locked_msg(p_Api_Name=> l_api_name);
388: END IF;
389: raise FND_API.G_EXC_ERROR;
390: END IF;
391:
392: IF ( P_validation_level >= CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL)
393: THEN

Line 406: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

402: x_msg_count => x_msg_count,
403: x_msg_data => x_msg_data);
404: END IF;
405:
406: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
407: RAISE FND_API.G_EXC_ERROR;
408: END IF;
409:
410: -- Invoke table handler(CSC_PROF_CHECK_RATINGS_PKG.Update_Row)

Line 407: RAISE FND_API.G_EXC_ERROR;

403: x_msg_data => x_msg_data);
404: END IF;
405:
406: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
407: RAISE FND_API.G_EXC_ERROR;
408: END IF;
409:
410: -- Invoke table handler(CSC_PROF_CHECK_RATINGS_PKG.Update_Row)
411: CSC_PROF_CHECK_RATINGS_PKG.Update_Row(

Line 430: IF FND_API.to_Boolean( p_commit )

426: -- End of API body.
427: --
428:
429: -- Standard check for p_commit
430: IF FND_API.to_Boolean( p_commit )
431: THEN
432: COMMIT WORK;
433: END IF;
434:

Line 443: WHEN FND_API.G_EXC_ERROR THEN

439: p_data => x_msg_data
440: );
441:
442: EXCEPTION
443: WHEN FND_API.G_EXC_ERROR THEN
444: ROLLBACK TO Update_check_ratings_PVT;
445: x_return_status := FND_API.G_RET_STS_ERROR;
446: FND_MSG_PUB.Count_And_Get
447: ( p_count => x_msg_count,

Line 445: x_return_status := FND_API.G_RET_STS_ERROR;

441:
442: EXCEPTION
443: WHEN FND_API.G_EXC_ERROR THEN
444: ROLLBACK TO Update_check_ratings_PVT;
445: x_return_status := FND_API.G_RET_STS_ERROR;
446: FND_MSG_PUB.Count_And_Get
447: ( p_count => x_msg_count,
448: p_data => x_msg_data
449: );

Line 451: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

447: ( p_count => x_msg_count,
448: p_data => x_msg_data
449: );
450: APP_EXCEPTION.RAISE_EXCEPTION;
451: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
452: ROLLBACK TO Update_check_ratings_PVT;
453: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
454: FND_MSG_PUB.Count_And_Get
455: ( p_count => x_msg_count,

Line 453: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

449: );
450: APP_EXCEPTION.RAISE_EXCEPTION;
451: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
452: ROLLBACK TO Update_check_ratings_PVT;
453: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
454: FND_MSG_PUB.Count_And_Get
455: ( p_count => x_msg_count,
456: p_data => x_msg_data
457: );

Line 461: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

457: );
458: APP_EXCEPTION.RAISE_EXCEPTION;
459: WHEN OTHERS THEN
460: ROLLBACK TO Update_check_ratings_PVT;
461: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
462: FND_MSG_PUB.Build_Exc_Msg(G_PKG_NAME, l_api_name);
463: FND_MSG_PUB.Count_And_Get
464: ( p_count => x_msg_count,
465: p_data => x_msg_data

Line 490: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

486: -- Standard Start of API savepoint
487: SAVEPOINT DELETE_CHECK_RATINGS_PVT;
488:
489: -- Standard call to check for call compatibility.
490: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
491: p_api_version_number,
492: l_api_name,
493: G_PKG_NAME)
494: THEN

Line 495: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

491: p_api_version_number,
492: l_api_name,
493: G_PKG_NAME)
494: THEN
495: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
496: END IF;
497:
498:
499: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 500: IF FND_API.to_Boolean( p_init_msg_list )

496: END IF;
497:
498:
499: -- Initialize message list if p_init_msg_list is set to TRUE.
500: IF FND_API.to_Boolean( p_init_msg_list )
501: THEN
502: FND_MSG_PUB.initialize;
503: END IF;
504:

Line 506: x_return_status := FND_API.G_RET_STS_SUCCESS;

502: FND_MSG_PUB.initialize;
503: END IF;
504:
505: -- Initialize API return status to SUCCESS
506: x_return_status := FND_API.G_RET_STS_SUCCESS;
507:
508: --
509: -- Api body
510: --

Line 520: IF FND_API.to_Boolean( p_commit )

516: -- End of API body
517: --
518:
519: -- Standard check for p_commit
520: IF FND_API.to_Boolean( p_commit )
521: THEN
522: COMMIT WORK;
523: END IF;
524:

Line 534: WHEN FND_API.G_EXC_ERROR THEN

530: p_data => x_msg_data
531: );
532:
533: EXCEPTION
534: WHEN FND_API.G_EXC_ERROR THEN
535: ROLLBACK TO Delete_check_ratings_PVT;
536: x_return_status := FND_API.G_RET_STS_ERROR;
537: FND_MSG_PUB.Count_And_Get
538: ( p_count => x_msg_count,

Line 536: x_return_status := FND_API.G_RET_STS_ERROR;

532:
533: EXCEPTION
534: WHEN FND_API.G_EXC_ERROR THEN
535: ROLLBACK TO Delete_check_ratings_PVT;
536: x_return_status := FND_API.G_RET_STS_ERROR;
537: FND_MSG_PUB.Count_And_Get
538: ( p_count => x_msg_count,
539: p_data => x_msg_data
540: );

Line 542: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

538: ( p_count => x_msg_count,
539: p_data => x_msg_data
540: );
541: APP_EXCEPTION.RAISE_EXCEPTION;
542: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
543: ROLLBACK TO Delete_check_ratings_PVT;
544: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
545: FND_MSG_PUB.Count_And_Get
546: ( p_count => x_msg_count,

Line 544: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 552: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

548: );
549: APP_EXCEPTION.RAISE_EXCEPTION;
550: WHEN OTHERS THEN
551: ROLLBACK TO Delete_check_ratings_PVT;
552: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
553: FND_MSG_PUB.Build_Exc_Msg(G_PKG_NAME, l_api_name);
554: FND_MSG_PUB.Count_And_Get
555: ( p_count => x_msg_count,
556: p_data => x_msg_data

Line 580: IF FND_API.to_Boolean( p_init_msg_list )

576: p_Api_Name VARCHAR2(100) := 'Validate_Check_Id';
577: BEGIN
578:
579: -- Initialize message list if p_init_msg_list is set to TRUE.
580: IF FND_API.to_Boolean( p_init_msg_list )
581: THEN
582: FND_MSG_PUB.initialize;
583: END IF;
584:

Line 586: x_return_status := FND_API.G_RET_STS_SUCCESS;

582: FND_MSG_PUB.initialize;
583: END IF;
584:
585: -- Initialize API return status to SUCCESS
586: x_return_status := FND_API.G_RET_STS_SUCCESS;
587:
588:
589: IF(p_validation_mode = CSC_CORE_UTILS_PVT.G_CREATE)
590: THEN

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

590: THEN
591: -- Hint: Validate data
592: -- IF p_CHECK_ID is not NULL and p_CHECK_ID <> G_MISS_NUM
593: -- verify if data is valid
594: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
595: IF p_CHECK_ID is not NULL and p_CHECK_ID <> CSC_CORE_UTILS_PVT.G_MISS_NUM
596: THEN
597: Open C1;
598: Fetch C1 into l_dummy;

Line 600: x_return_status := FND_API.G_RET_STS_ERROR;

596: THEN
597: Open C1;
598: Fetch C1 into l_dummy;
599: IF C1%NOTFOUND THEN
600: x_return_status := FND_API.G_RET_STS_ERROR;
601: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(
602: p_api_name=> p_api_name,
603: p_argument_value => p_check_id,
604: p_argument=>'P_CHECK_ID' );

Line 608: x_return_status := FND_API.G_RET_STS_ERROR;

604: p_argument=>'P_CHECK_ID' );
605: END IF;
606: Close C1;
607: ELSE
608: x_return_status := FND_API.G_RET_STS_ERROR;
609: CSC_CORE_UTILS_PVT.mandatory_arg_error(
610: p_api_name => p_api_name,
611: p_argument => 'P_CHECK_ID',
612: p_argument_Value => p_check_id );

Line 617: -- IF p_CHECK_ID <> FND_API.G_MISS_NUM

613: END IF;
614: ELSIF(p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE)
615: THEN
616: -- Hint: Validate data
617: -- IF p_CHECK_ID <> FND_API.G_MISS_NUM
618: -- verify if data is valid
619: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
620: IF p_CHECK_ID <> CSC_CORE_UTILS_PVT.G_MISS_NUM
621: THEN

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

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

Line 625: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 634: x_return_status := FND_API.G_RET_STS_ERROR;

630: END IF;
631: Close C1;
632: ELSIF p_CHECK_ID IS NULL
633: THEN
634: x_return_status := FND_API.G_RET_STS_ERROR;
635: CSC_CORE_UTILS_PVT.mandatory_arg_error(
636: p_api_name => p_api_name,
637: p_argument => 'P_CHECK_ID',
638: p_argument_Value => p_check_id );

Line 663: IF FND_API.to_Boolean( p_init_msg_list )

659: IS
660: p_Api_Name VARCHAR2(100) := 'VALIDATE_CHECK_RATINGS_GRADE';
661: BEGIN
662: -- Initialize message list if p_init_msg_list is set to TRUE.
663: IF FND_API.to_Boolean( p_init_msg_list )
664: THEN
665: FND_MSG_PUB.initialize;
666: END IF;
667: -- Initialize API return status to SUCCESS

Line 668: x_return_status := FND_API.G_RET_STS_SUCCESS;

664: THEN
665: FND_MSG_PUB.initialize;
666: END IF;
667: -- Initialize API return status to SUCCESS
668: x_return_status := FND_API.G_RET_STS_SUCCESS;
669: -- validate NOT NULL column
670: IF(p_CHECK_RATING_GRADE is NULL)
671: THEN
672: x_return_status := FND_API.G_RET_STS_ERROR;

Line 672: x_return_status := FND_API.G_RET_STS_ERROR;

668: x_return_status := FND_API.G_RET_STS_SUCCESS;
669: -- validate NOT NULL column
670: IF(p_CHECK_RATING_GRADE is NULL)
671: THEN
672: x_return_status := FND_API.G_RET_STS_ERROR;
673: END IF;
674: IF(p_validation_mode = CSC_CORE_UTILS_PVT.G_CREATE)
675: THEN
676: -- Hint: Validate data

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

675: THEN
676: -- Hint: Validate data
677: -- IF p_CHECK_RATING_GRADE is not NULL and p_CHECK_RATING_GRADE <> G_MISS_CHAR
678: -- verify if data is valid
679: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
680: NULL;
681: ELSIF(p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE)
682: THEN
683: -- Hint: Validate data

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

682: THEN
683: -- Hint: Validate data
684: -- IF p_CHECK_RATING_GRADE <> G_MISS_CHAR
685: -- verify if data is valid
686: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
687: NULL;
688: END IF;
689: -- Standard call to get message count and if count is 1, get message info.
690: FND_MSG_PUB.Count_And_Get

Line 711: IF FND_API.to_Boolean( p_init_msg_list )

707: p_Api_Name VARCHAR2(100) := 'VALIDATE_RATING_CODE';
708: BEGIN
709:
710: -- Initialize message list if p_init_msg_list is set to TRUE.
711: IF FND_API.to_Boolean( p_init_msg_list )
712: THEN
713: FND_MSG_PUB.initialize;
714: END IF;
715:

Line 717: x_return_status := FND_API.G_RET_STS_SUCCESS;

713: FND_MSG_PUB.initialize;
714: END IF;
715:
716: -- Initialize API return status to SUCCESS
717: x_return_status := FND_API.G_RET_STS_SUCCESS;
718:
719: -- validate NOT NULL column
720: IF(p_RATING_CODE is NULL)
721: THEN

Line 722: x_return_status := FND_API.G_RET_STS_ERROR;

718:
719: -- validate NOT NULL column
720: IF(p_RATING_CODE is NULL)
721: THEN
722: x_return_status := FND_API.G_RET_STS_ERROR;
723: CSC_CORE_UTILS_PVT.mandatory_arg_error(
724: p_api_name => p_api_name,
725: p_argument => 'P_RATING_CODE',
726: p_argument_Value => p_rating_code );

Line 737: p_lookup_Code => p_rating_code ) <> FND_API.G_RET_STS_SUCCESS

733: THEN
734: IF CSC_CORE_UTILS_PVT.csc_lookup_code_not_exists(
735: p_effective_date => trunc(sysdate),
736: p_lookup_type => 'CSC_PROF_RATINGS',
737: p_lookup_Code => p_rating_code ) <> FND_API.G_RET_STS_SUCCESS
738: THEN
739:
740: x_return_status := FND_API.G_RET_STS_ERROR;
741: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(

Line 740: x_return_status := FND_API.G_RET_STS_ERROR;

736: p_lookup_type => 'CSC_PROF_RATINGS',
737: p_lookup_Code => p_rating_code ) <> FND_API.G_RET_STS_SUCCESS
738: THEN
739:
740: x_return_status := FND_API.G_RET_STS_ERROR;
741: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(
742: p_api_name=> p_api_name,
743: p_argument_value => p_rating_code,
744: p_argument=>'P_RATING_CODE' );

Line 747: x_return_status := FND_API.G_RET_STS_ERROR;

743: p_argument_value => p_rating_code,
744: p_argument=>'P_RATING_CODE' );
745: END IF;
746: ELSE
747: x_return_status := FND_API.G_RET_STS_ERROR;
748: CSC_CORE_UTILS_PVT.mandatory_arg_error(
749: p_api_name => p_api_name,
750: p_argument => 'P_RATING_CODE',
751: p_argument_Value => p_rating_code );

Line 761: p_lookup_Code => p_rating_code ) <> FND_API.G_RET_STS_SUCCESS

757: THEN
758: IF CSC_CORE_UTILS_PVT.csc_lookup_code_not_exists(
759: p_effective_date => trunc(sysdate),
760: p_lookup_type => 'CSC_PROF_RATINGS',
761: p_lookup_Code => p_rating_code ) <> FND_API.G_RET_STS_SUCCESS
762: THEN
763:
764: x_return_status := FND_API.G_RET_STS_ERROR;
765: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(

Line 764: x_return_status := FND_API.G_RET_STS_ERROR;

760: p_lookup_type => 'CSC_PROF_RATINGS',
761: p_lookup_Code => p_rating_code ) <> FND_API.G_RET_STS_SUCCESS
762: THEN
763:
764: x_return_status := FND_API.G_RET_STS_ERROR;
765: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(
766: p_api_name=> p_api_name,
767: p_argument_value => p_rating_code,
768: p_argument=>'P_RATING_CODE' );

Line 796: x_return_status := FND_API.G_RET_STS_SUCCESS;

792:
793: BEGIN
794:
795: -- Initialize API return status to SUCCESS
796: x_return_status := FND_API.G_RET_STS_SUCCESS;
797: /*
798: Validate_CHECK_RATING_ID(
799: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,
800: p_validation_mode => p_validation_mode,

Line 805: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

801: p_CHECK_RATING_ID => l_CHECK_RATING_ID,
802: x_return_status => x_return_status,
803: x_msg_count => x_msg_count,
804: x_msg_data => x_msg_data);
805: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
806: raise FND_API.G_EXC_ERROR;
807: END IF;
808: */
809: Validate_CHECK_ID(

Line 806: raise FND_API.G_EXC_ERROR;

802: x_return_status => x_return_status,
803: x_msg_count => x_msg_count,
804: x_msg_data => x_msg_data);
805: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
806: raise FND_API.G_EXC_ERROR;
807: END IF;
808: */
809: Validate_CHECK_ID(
810: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,

Line 816: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

812: p_CHECK_ID => P_CHK_RATING_REC.CHECK_ID,
813: x_return_status => x_return_status,
814: x_msg_count => x_msg_count,
815: x_msg_data => x_msg_data);
816: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
817: raise FND_API.G_EXC_ERROR;
818: END IF;
819:
820: /*

Line 817: raise FND_API.G_EXC_ERROR;

813: x_return_status => x_return_status,
814: x_msg_count => x_msg_count,
815: x_msg_data => x_msg_data);
816: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
817: raise FND_API.G_EXC_ERROR;
818: END IF;
819:
820: /*
821: Validate_CHECK_RATING_GRADE(

Line 828: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

824: p_CHECK_RATING_GRADE => p_CHK_RATING_REC.CHECK_RATING_GRADE,
825: x_return_status => x_return_status,
826: x_msg_count => x_msg_count,
827: x_msg_data => x_msg_data);
828: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
829: raise FND_API.G_EXC_ERROR;
830: END IF;
831: */
832:

Line 829: raise FND_API.G_EXC_ERROR;

825: x_return_status => x_return_status,
826: x_msg_count => x_msg_count,
827: x_msg_data => x_msg_data);
828: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
829: raise FND_API.G_EXC_ERROR;
830: END IF;
831: */
832:
833:

Line 842: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

838: p_RATING_CODE => p_CHK_RATING_REC.RATING_CODE,
839: x_return_status => x_return_status,
840: x_msg_count => x_msg_count,
841: x_msg_data => x_msg_data);
842: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
843: raise FND_API.G_EXC_ERROR;
844: END IF;
845:
846: CSC_CORE_UTILS_PVT.Validate_Seeded_Flag(

Line 843: raise FND_API.G_EXC_ERROR;

839: x_return_status => x_return_status,
840: x_msg_count => x_msg_count,
841: x_msg_data => x_msg_data);
842: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
843: raise FND_API.G_EXC_ERROR;
844: END IF;
845:
846: CSC_CORE_UTILS_PVT.Validate_Seeded_Flag(
847: p_api_name =>'CSC_CHECK_RATINGS_PVT.VALIDATE_SEEDED_FLAG',

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

847: p_api_name =>'CSC_CHECK_RATINGS_PVT.VALIDATE_SEEDED_FLAG',
848: p_seeded_flag => p_CHK_RATING_rec.seeded_flag,
849: x_return_status => x_return_status );
850:
851: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
852: RAISE FND_API.G_EXC_ERROR;
853: END IF;
854:
855:

Line 852: RAISE FND_API.G_EXC_ERROR;

848: p_seeded_flag => p_CHK_RATING_rec.seeded_flag,
849: x_return_status => x_return_status );
850:
851: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
852: RAISE FND_API.G_EXC_ERROR;
853: END IF;
854:
855:
856: