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

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

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

Line 118: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

114: -- Standard Start of API savepoint
115: SAVEPOINT CREATE_CSC_PROF_GROUP_CAT_PVT;
116:
117: -- Standard call to check for call compatibility.
118: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
119: p_api_version_number,
120: l_api_name,
121: G_PKG_NAME)
122: THEN

Line 123: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

119: p_api_version_number,
120: l_api_name,
121: G_PKG_NAME)
122: THEN
123: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
124: END IF;
125:
126:
127: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 128: IF FND_API.to_Boolean( p_init_msg_list )

124: END IF;
125:
126:
127: -- Initialize message list if p_init_msg_list is set to TRUE.
128: IF FND_API.to_Boolean( p_init_msg_list )
129: THEN
130: FND_MSG_PUB.initialize;
131: END IF;
132:

Line 135: x_return_status := FND_API.G_RET_STS_SUCCESS;

131: END IF;
132:
133:
134: -- Initialize API return status to SUCCESS
135: x_return_status := FND_API.G_RET_STS_SUCCESS;
136:
137: --
138: -- API body
139: --

Line 156: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

152: x_msg_count => x_msg_count,
153: x_msg_data => x_msg_data);
154: END IF;
155:
156: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
157: RAISE FND_API.G_EXC_ERROR;
158: END IF;
159:
160:

Line 157: RAISE FND_API.G_EXC_ERROR;

153: x_msg_data => x_msg_data);
154: END IF;
155:
156: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
157: RAISE FND_API.G_EXC_ERROR;
158: END IF;
159:
160:
161: -- Invoke table handler(CSC_PROF_GROUP_CATEGORIES_PKG.Insert_Row)

Line 176: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

172: p_SEEDED_FLAG => p_PROF_GRP_CAT_rec.SEEDED_FLAG);
173: -- Hint: Primary key should be returned.
174: -- x_GROUP_CATEGORY_ID := px_GROUP_CATEGORY_ID;
175:
176: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
177: RAISE FND_API.G_EXC_ERROR;
178: END IF;
179:
180: --

Line 177: RAISE FND_API.G_EXC_ERROR;

173: -- Hint: Primary key should be returned.
174: -- x_GROUP_CATEGORY_ID := px_GROUP_CATEGORY_ID;
175:
176: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
177: RAISE FND_API.G_EXC_ERROR;
178: END IF;
179:
180: --
181: -- End of API body

Line 185: IF FND_API.to_Boolean( p_commit )

181: -- End of API body
182: --
183:
184: -- Standard check for p_commit
185: IF FND_API.to_Boolean( p_commit )
186: THEN
187: COMMIT WORK;
188: END IF;
189:

Line 199: WHEN FND_API.G_EXC_ERROR THEN

195: p_data => x_msg_data
196: );
197:
198: EXCEPTION
199: WHEN FND_API.G_EXC_ERROR THEN
200: ROLLBACK TO CREATE_CSC_PROF_GROUP_CAT_PVT;
201: x_return_status := FND_API.G_RET_STS_ERROR;
202: APP_EXCEPTION.RAISE_EXCEPTION;
203:

Line 201: x_return_status := FND_API.G_RET_STS_ERROR;

197:
198: EXCEPTION
199: WHEN FND_API.G_EXC_ERROR THEN
200: ROLLBACK TO CREATE_CSC_PROF_GROUP_CAT_PVT;
201: x_return_status := FND_API.G_RET_STS_ERROR;
202: APP_EXCEPTION.RAISE_EXCEPTION;
203:
204: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
205: ROLLBACK TO CREATE_CSC_PROF_GROUP_CAT_PVT;

Line 204: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

200: ROLLBACK TO CREATE_CSC_PROF_GROUP_CAT_PVT;
201: x_return_status := FND_API.G_RET_STS_ERROR;
202: APP_EXCEPTION.RAISE_EXCEPTION;
203:
204: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
205: ROLLBACK TO CREATE_CSC_PROF_GROUP_CAT_PVT;
206: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
207: APP_EXCEPTION.RAISE_EXCEPTION;
208:

Line 206: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

202: APP_EXCEPTION.RAISE_EXCEPTION;
203:
204: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
205: ROLLBACK TO CREATE_CSC_PROF_GROUP_CAT_PVT;
206: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
207: APP_EXCEPTION.RAISE_EXCEPTION;
208:
209: WHEN OTHERS THEN
210: ROLLBACK TO CREATE_CSC_PROF_GROUP_CAT_PVT;

Line 211: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

207: APP_EXCEPTION.RAISE_EXCEPTION;
208:
209: WHEN OTHERS THEN
210: ROLLBACK TO CREATE_CSC_PROF_GROUP_CAT_PVT;
211: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
212: FND_MSG_PUB.Build_Exc_Msg;
213: APP_EXCEPTION.RAISE_EXCEPTION;
214: End Create_csc_prof_group_cat;
215:

Line 307: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

303: -- Standard Start of API savepoint
304: SAVEPOINT UPDATE_CSC_PROF_GROUP_CAT_PVT;
305:
306: -- Standard call to check for call compatibility.
307: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
308: p_api_version_number,
309: l_api_name,
310: G_PKG_NAME)
311: THEN

Line 312: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

308: p_api_version_number,
309: l_api_name,
310: G_PKG_NAME)
311: THEN
312: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
313: END IF;
314:
315:
316: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 317: IF FND_API.to_Boolean( p_init_msg_list )

313: END IF;
314:
315:
316: -- Initialize message list if p_init_msg_list is set to TRUE.
317: IF FND_API.to_Boolean( p_init_msg_list )
318: THEN
319: FND_MSG_PUB.initialize;
320: END IF;
321:

Line 325: x_return_status := FND_API.G_RET_STS_SUCCESS;

321:
322:
323:
324: -- Initialize API return status to SUCCESS
325: x_return_status := FND_API.G_RET_STS_SUCCESS;
326:
327: --
328: -- Api body
329: --

Line 352: raise FND_API.G_EXC_ERROR;

348: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
349: THEN
350: CSC_CORE_UTILS_PVT.RECORD_IS_LOCKED_MSG(l_Api_Name);
351: END IF;
352: raise FND_API.G_EXC_ERROR;
353: END IF;
354:
355:
356: IF ( P_validation_level >= CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL)

Line 369: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

365: x_msg_count => x_msg_count,
366: x_msg_data => x_msg_data);
367: END IF;
368:
369: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
370: RAISE FND_API.G_EXC_ERROR;
371: END IF;
372:
373:

Line 370: RAISE FND_API.G_EXC_ERROR;

366: x_msg_data => x_msg_data);
367: END IF;
368:
369: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
370: RAISE FND_API.G_EXC_ERROR;
371: END IF;
372:
373:
374: -- Invoke table handler(CSC_PROF_GROUP_CATEGORIES_PKG.Update_Row)

Line 389: IF FND_API.to_Boolean( p_commit )

385: -- End of API body.
386: --
387:
388: -- Standard check for p_commit
389: IF FND_API.to_Boolean( p_commit )
390: THEN
391: COMMIT WORK;
392: END IF;
393:

Line 404: WHEN FND_API.G_EXC_ERROR THEN

400: p_data => x_msg_data
401: );
402:
403: EXCEPTION
404: WHEN FND_API.G_EXC_ERROR THEN
405: ROLLBACK TO UPDATE_CSC_PROF_GROUP_CAT_PVT;
406: x_return_status := FND_API.G_RET_STS_ERROR;
407: APP_EXCEPTION.RAISE_EXCEPTION;
408:

Line 406: x_return_status := FND_API.G_RET_STS_ERROR;

402:
403: EXCEPTION
404: WHEN FND_API.G_EXC_ERROR THEN
405: ROLLBACK TO UPDATE_CSC_PROF_GROUP_CAT_PVT;
406: x_return_status := FND_API.G_RET_STS_ERROR;
407: APP_EXCEPTION.RAISE_EXCEPTION;
408:
409: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
410: ROLLBACK TO UPDATE_CSC_PROF_GROUP_CAT_PVT;

Line 409: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

405: ROLLBACK TO UPDATE_CSC_PROF_GROUP_CAT_PVT;
406: x_return_status := FND_API.G_RET_STS_ERROR;
407: APP_EXCEPTION.RAISE_EXCEPTION;
408:
409: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
410: ROLLBACK TO UPDATE_CSC_PROF_GROUP_CAT_PVT;
411: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
412: APP_EXCEPTION.RAISE_EXCEPTION;
413:

Line 411: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

407: APP_EXCEPTION.RAISE_EXCEPTION;
408:
409: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
410: ROLLBACK TO UPDATE_CSC_PROF_GROUP_CAT_PVT;
411: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
412: APP_EXCEPTION.RAISE_EXCEPTION;
413:
414: WHEN OTHERS THEN
415: ROLLBACK TO UPDATE_CSC_PROF_GROUP_CAT_PVT;

Line 416: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

412: APP_EXCEPTION.RAISE_EXCEPTION;
413:
414: WHEN OTHERS THEN
415: ROLLBACK TO UPDATE_CSC_PROF_GROUP_CAT_PVT;
416: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
417: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
418: FND_MSG_PUB.Build_Exc_Msg(G_PKG_NAME, l_api_name);
419: END IF;
420: APP_EXCEPTION.RAISE_EXCEPTION;

Line 444: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

440: -- Standard Start of API savepoint
441: SAVEPOINT DELETE_CSC_PROF_GROUP_CAT_PVT;
442:
443: -- Standard call to check for call compatibility.
444: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
445: p_api_version_number,
446: l_api_name,
447: G_PKG_NAME)
448: THEN

Line 449: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

445: p_api_version_number,
446: l_api_name,
447: G_PKG_NAME)
448: THEN
449: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
450: END IF;
451:
452:
453: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 454: IF FND_API.to_Boolean( p_init_msg_list )

450: END IF;
451:
452:
453: -- Initialize message list if p_init_msg_list is set to TRUE.
454: IF FND_API.to_Boolean( p_init_msg_list )
455: THEN
456: FND_MSG_PUB.initialize;
457: END IF;
458:

Line 461: x_return_status := FND_API.G_RET_STS_SUCCESS;

457: END IF;
458:
459:
460: -- Initialize API return status to SUCCESS
461: x_return_status := FND_API.G_RET_STS_SUCCESS;
462:
463: --
464: -- Api body
465: --

Line 475: IF FND_API.to_Boolean( p_commit )

471: -- End of API body
472: --
473:
474: -- Standard check for p_commit
475: IF FND_API.to_Boolean( p_commit )
476: THEN
477: COMMIT WORK;
478: END IF;
479:

Line 490: WHEN FND_API.G_EXC_ERROR THEN

486: p_data => x_msg_data
487: );
488:
489: EXCEPTION
490: WHEN FND_API.G_EXC_ERROR THEN
491: ROLLBACK TO DELETE_CSC_PROF_GROUP_CAT_PVT;
492: x_return_status := FND_API.G_RET_STS_ERROR ;
493: --FND_MSG_PUB.Count_And_Get(
494: --p_count =>x_msg_count,

Line 492: x_return_status := FND_API.G_RET_STS_ERROR ;

488:
489: EXCEPTION
490: WHEN FND_API.G_EXC_ERROR THEN
491: ROLLBACK TO DELETE_CSC_PROF_GROUP_CAT_PVT;
492: x_return_status := FND_API.G_RET_STS_ERROR ;
493: --FND_MSG_PUB.Count_And_Get(
494: --p_count =>x_msg_count,
495: --p_data => x_msg_data
496: --);

Line 499: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

495: --p_data => x_msg_data
496: --);
497: APP_EXCEPTION.RAISE_EXCEPTION;
498:
499: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
500: ROLLBACK TO DELETE_CSC_PROF_GROUP_CAT_PVT;
501: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
502: --FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
503: --p_data => x_msg_data) ;

Line 501: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

497: APP_EXCEPTION.RAISE_EXCEPTION;
498:
499: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
500: ROLLBACK TO DELETE_CSC_PROF_GROUP_CAT_PVT;
501: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
502: --FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
503: --p_data => x_msg_data) ;
504: APP_EXCEPTION.RAISE_EXCEPTION;
505:

Line 508: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

504: APP_EXCEPTION.RAISE_EXCEPTION;
505:
506: WHEN OTHERS THEN
507: ROLLBACK TO DELETE_CSC_PROF_GROUP_CAT_PVT;
508: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
509: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
510: THEN
511: FND_MSG_PUB.Build_Exc_Msg(G_PKG_NAME,l_api_name);
512: END IF ;

Line 529: IF FND_API.to_Boolean( p_init_msg_list )

525: IS
526: BEGIN
527:
528: -- Initialize message list if p_init_msg_list is set to TRUE.
529: IF FND_API.to_Boolean( p_init_msg_list )
530: THEN
531: FND_MSG_PUB.initialize;
532: END IF;
533:

Line 536: x_return_status := FND_API.G_RET_STS_SUCCESS;

532: END IF;
533:
534:
535: -- Initialize API return status to SUCCESS
536: x_return_status := FND_API.G_RET_STS_SUCCESS;
537:
538: -- validate NOT NULL column
539: IF(p_GROUP_CATEGORY_ID is NULL)
540: THEN

Line 541: x_return_status := FND_API.G_RET_STS_ERROR;

537:
538: -- validate NOT NULL column
539: IF(p_GROUP_CATEGORY_ID is NULL)
540: THEN
541: x_return_status := FND_API.G_RET_STS_ERROR;
542: END IF;
543:
544: IF(p_validation_mode = CSC_CORE_UTILS_PVT.G_CREATE)
545: THEN

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

545: THEN
546: -- Hint: Validate data
547: -- IF p_GROUP_CATEGORY_ID is not NULL and p_GROUP_CATEGORY_ID <> G_MISS_CHAR
548: -- verify if data is valid
549: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
550: NULL;
551: ELSIF(p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE)
552: THEN
553: -- Hint: Validate data

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

552: THEN
553: -- Hint: Validate data
554: -- IF p_GROUP_CATEGORY_ID <> G_MISS_CHAR
555: -- verify if data is valid
556: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
557: NULL;
558: END IF;
559:
560: -- Standard call to get message count and if count is 1, get message info.

Line 586: IF FND_API.to_Boolean( p_init_msg_list )

582: where group_id = P_GROUP_ID;
583: BEGIN
584:
585: -- Initialize message list if p_init_msg_list is set to TRUE.
586: IF FND_API.to_Boolean( p_init_msg_list )
587: THEN
588: FND_MSG_PUB.initialize;
589: END IF;
590:

Line 593: x_return_status := FND_API.G_RET_STS_SUCCESS;

589: END IF;
590:
591:
592: -- Initialize API return status to SUCCESS
593: x_return_status := FND_API.G_RET_STS_SUCCESS;
594:
595: -- validate NOT NULL column
596: IF(p_GROUP_ID is NULL)
597: THEN

Line 598: x_return_status := FND_API.G_RET_STS_ERROR;

594:
595: -- validate NOT NULL column
596: IF(p_GROUP_ID is NULL)
597: THEN
598: x_return_status := FND_API.G_RET_STS_ERROR;
599: CSC_CORE_UTILS_PVT.mandatory_arg_error(
600: p_api_name => p_api_name,
601: p_argument => 'p_GROUP_ID',
602: p_argument_value => p_GROUP_ID);

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

605: THEN
606: -- Hint: Validate data
607: -- IF p_GROUP_ID is not NULL and p_GROUP_ID <> G_MISS_CHAR
608: -- verify if data is valid
609: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
610: IF p_GROUP_ID = CSC_CORE_UTILS_PVT.G_MISS_NUM
611: THEN
612: x_return_status := FND_API.G_RET_STS_ERROR;
613: CSC_CORE_UTILS_PVT.mandatory_arg_error(

Line 612: x_return_status := FND_API.G_RET_STS_ERROR;

608: -- verify if data is valid
609: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
610: IF p_GROUP_ID = CSC_CORE_UTILS_PVT.G_MISS_NUM
611: THEN
612: x_return_status := FND_API.G_RET_STS_ERROR;
613: CSC_CORE_UTILS_PVT.mandatory_arg_error(
614: p_api_name => p_api_name,
615: p_argument => 'p_GROUP_ID',
616: p_argument_value => p_GROUP_ID);

Line 622: x_return_status := FND_API.G_RET_STS_ERROR;

618: THEN
619: Open C1;
620: Fetch C1 into l_dummy;
621: IF C1%NOTFOUND THEN
622: x_return_status := FND_API.G_RET_STS_ERROR;
623: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(
624: p_api_name => p_api_name,
625: p_argument_value => p_GROUP_ID,
626: p_argument => 'P_GROUP_ID' );

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

631: THEN
632: -- Hint: Validate data
633: -- IF p_GROUP_ID <> G_MISS_CHAR
634: -- verify if data is valid
635: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
636: IF p_GROUP_ID is not NULL and p_GROUP_ID <> CSC_CORE_UTILS_PVT.G_MISS_NUM
637: THEN
638: Open C1;
639: Fetch C1 into l_dummy;

Line 641: x_return_status := FND_API.G_RET_STS_ERROR;

637: THEN
638: Open C1;
639: Fetch C1 into l_dummy;
640: IF C1%NOTFOUND THEN
641: x_return_status := FND_API.G_RET_STS_ERROR;
642: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(
643: p_api_name => p_api_name,
644: p_argument_value => p_GROUP_ID,
645: p_argument => 'P_GROUP_ID' );

Line 679: IF FND_API.to_Boolean( p_init_msg_list )

675: and category_code = p_CATEGORY_CODE;
676: BEGIN
677:
678: -- Initialize message list if p_init_msg_list is set to TRUE.
679: IF FND_API.to_Boolean( p_init_msg_list )
680: THEN
681: FND_MSG_PUB.initialize;
682: END IF;
683:

Line 686: x_return_status := FND_API.G_RET_STS_SUCCESS;

682: END IF;
683:
684:
685: -- Initialize API return status to SUCCESS
686: x_return_status := FND_API.G_RET_STS_SUCCESS;
687:
688: IF(p_validation_mode = CSC_CORE_UTILS_PVT.G_CREATE)
689: THEN
690: -- Hint: Validate data

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

689: THEN
690: -- Hint: Validate data
691: -- IF p_CATEGORY_CODE is not NULL and p_CATEGORY_CODE <> G_MISS_CHAR
692: -- verify if data is valid
693: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
694: IF p_CATEGORY_CODE is not NULL and p_CATEGORY_CODE <> CSC_CORE_UTILS_PVT.G_MISS_CHAR
695: THEN
696: Open C1;
697: Fetch C1 into l_dummy;

Line 699: x_return_status := FND_API.G_RET_STS_ERROR;

695: THEN
696: Open C1;
697: Fetch C1 into l_dummy;
698: IF C1%FOUND THEN
699: x_return_status := FND_API.G_RET_STS_ERROR;
700: CSC_CORE_UTILS_PVT.Add_Duplicate_Value_Msg(
701: p_api_name => p_api_name,
702: p_argument => 'P_CATEGORY_CODE' ,
703: p_argument_value => p_CATEGORY_CODE);

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

708: THEN
709: -- Hint: Validate data
710: -- IF p_CATEGORY_CODE <> G_MISS_CHAR
711: -- verify if data is valid
712: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
713: IF p_CATEGORY_CODE is not NULL
714: THEN
715: Open C1;
716: Fetch C1 into l_dummy;

Line 718: x_return_status := FND_API.G_RET_STS_ERROR;

714: THEN
715: Open C1;
716: Fetch C1 into l_dummy;
717: IF C1%NOTFOUND THEN
718: x_return_status := FND_API.G_RET_STS_ERROR;
719: CSC_CORE_UTILS_PVT.Add_Duplicate_Value_Msg(
720: p_api_name => p_api_name,
721: p_argument => 'P_CATEGORY_CODE' ,
722: p_argument_value => p_CATEGORY_CODE);

Line 749: IF FND_API.to_Boolean( p_init_msg_list )

745: IS
746: BEGIN
747:
748: -- Initialize message list if p_init_msg_list is set to TRUE.
749: IF FND_API.to_Boolean( p_init_msg_list )
750: THEN
751: FND_MSG_PUB.initialize;
752: END IF;
753:

Line 756: x_return_status := FND_API.G_RET_STS_SUCCESS;

752: END IF;
753:
754:
755: -- Initialize API return status to SUCCESS
756: x_return_status := FND_API.G_RET_STS_SUCCESS;
757:
758: IF(p_validation_mode = CSC_CORE_UTILS_PVT.G_CREATE)
759: THEN
760: -- Hint: Validate data

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

759: THEN
760: -- Hint: Validate data
761: -- IF p_CATEGORY_SEQUENCE is not NULL and p_CATEGORY_SEQUENCE <> G_MISS_CHAR
762: -- verify if data is valid
763: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
764: NULL;
765: ELSIF(p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE)
766: THEN
767: -- Hint: Validate data

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

766: THEN
767: -- Hint: Validate data
768: -- IF p_CATEGORY_SEQUENCE <> G_MISS_CHAR
769: -- verify if data is valid
770: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
771: NULL;
772: END IF;
773:
774: -- Standard call to get message count and if count is 1, get message info.

Line 799: x_return_status := FND_API.G_RET_STS_SUCCESS;

795:
796:
797:
798: -- Initialize API return status to SUCCESS
799: x_return_status := FND_API.G_RET_STS_SUCCESS;
800:
801: IF (p_validation_level >= CSC_CORE_UTILS_PVT.G_VALID_LEVEL_NONE) THEN
802: -- Hint: We provide validation procedure for every column. Developer should delete
803: -- unnecessary validation procedures.

Line 812: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

808: p_GROUP_CATEGORY_ID => P_PROF_GRP_CAT_Rec.GROUP_CATEGORY_ID,
809: x_return_status => x_return_status,
810: x_msg_count => x_msg_count,
811: x_msg_data => x_msg_data);
812: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
813: raise FND_API.G_EXC_ERROR;
814: END IF;
815: */
816: Validate_GROUP_ID(

Line 813: raise FND_API.G_EXC_ERROR;

809: x_return_status => x_return_status,
810: x_msg_count => x_msg_count,
811: x_msg_data => x_msg_data);
812: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
813: raise FND_API.G_EXC_ERROR;
814: END IF;
815: */
816: Validate_GROUP_ID(
817: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,

Line 823: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

819: p_GROUP_ID => P_PROF_GRP_CAT_Rec.GROUP_ID,
820: x_return_status => x_return_status,
821: x_msg_count => x_msg_count,
822: x_msg_data => x_msg_data);
823: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
824: raise FND_API.G_EXC_ERROR;
825: END IF;
826:
827: Validate_CATEGORY_CODE(

Line 824: raise FND_API.G_EXC_ERROR;

820: x_return_status => x_return_status,
821: x_msg_count => x_msg_count,
822: x_msg_data => x_msg_data);
823: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
824: raise FND_API.G_EXC_ERROR;
825: END IF;
826:
827: Validate_CATEGORY_CODE(
828: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,

Line 835: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

831: P_GROUP_ID => P_PROF_GRP_CAT_Rec.GROUP_ID,
832: x_return_status => x_return_status,
833: x_msg_count => x_msg_count,
834: x_msg_data => x_msg_data);
835: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
836: raise FND_API.G_EXC_ERROR;
837: END IF;
838:
839: Validate_CATEGORY_SEQUENCE(

Line 836: raise FND_API.G_EXC_ERROR;

832: x_return_status => x_return_status,
833: x_msg_count => x_msg_count,
834: x_msg_data => x_msg_data);
835: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
836: raise FND_API.G_EXC_ERROR;
837: END IF;
838:
839: Validate_CATEGORY_SEQUENCE(
840: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,

Line 846: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

842: p_CATEGORY_SEQUENCE => P_PROF_GRP_CAT_Rec.CATEGORY_SEQUENCE,
843: x_return_status => x_return_status,
844: x_msg_count => x_msg_count,
845: x_msg_data => x_msg_data);
846: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
847: raise FND_API.G_EXC_ERROR;
848: END IF;
849:
850: --Validate seeded flag

Line 847: raise FND_API.G_EXC_ERROR;

843: x_return_status => x_return_status,
844: x_msg_count => x_msg_count,
845: x_msg_data => x_msg_data);
846: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
847: raise FND_API.G_EXC_ERROR;
848: END IF;
849:
850: --Validate seeded flag
851:

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

853: p_api_name =>'CSC_PROF_GROUP_CAT_PVT.VALIDATE_SEEDED_FLAG',
854: p_seeded_flag => p_PROF_GRP_CAT_rec.seeded_flag,
855: x_return_status => x_return_status );
856:
857: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
858: RAISE FND_API.G_EXC_ERROR;
859: END IF;
860:
861: END IF;

Line 858: RAISE FND_API.G_EXC_ERROR;

854: p_seeded_flag => p_PROF_GRP_CAT_rec.seeded_flag,
855: x_return_status => x_return_status );
856:
857: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
858: RAISE FND_API.G_EXC_ERROR;
859: END IF;
860:
861: END IF;
862: