3: -- Start of Comments
4: -- Package name : CSC_PROF_COLOR_CODE_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:
104: -- Standard Start of API savepoint
105: SAVEPOINT CREATE_PROF_COLOR_CODE_PVT;
106:
107: -- Standard call to check for call compatibility.
108: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
109: p_api_version_number,
110: l_api_name,
111: G_PKG_NAME)
112: THEN
109: p_api_version_number,
110: l_api_name,
111: G_PKG_NAME)
112: THEN
113: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
114: END IF;
115:
116:
117: -- Initialize message list if p_init_msg_list is set to TRUE.
114: END IF;
115:
116:
117: -- Initialize message list if p_init_msg_list is set to TRUE.
118: IF FND_API.to_Boolean( p_init_msg_list )
119: THEN
120: FND_MSG_PUB.initialize;
121: END IF;
122:
121: END IF;
122:
123:
124: -- Initialize API return status to SUCCESS
125: x_return_status := FND_API.G_RET_STS_SUCCESS;
126:
127: --
128: -- API body
129: --
128: -- API body
129: --
130:
131:
132: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
133: THEN
134: -- Invoke validation procedures
135: Validate_prof_color_code(
136: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,
141: x_msg_count => x_msg_count,
142: x_msg_data => x_msg_data);
143: END IF;
144:
145: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
146: RAISE FND_API.G_EXC_ERROR;
147: END IF;
148:
149:
142: x_msg_data => x_msg_data);
143: END IF;
144:
145: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
146: RAISE FND_API.G_EXC_ERROR;
147: END IF;
148:
149:
150: CSC_COLOR_CODES_PKG.Insert_Row(
155: p_CREATION_DATE => SYSDATE,
156: p_CREATED_BY => FND_GLOBAL.USER_ID,
157: p_LAST_UPDATE_LOGIN => p_prof_color_rec.LAST_UPDATE_LOGIN);
158:
159: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
160: RAISE FND_API.G_EXC_ERROR;
161: END IF;
162:
163: --
156: p_CREATED_BY => FND_GLOBAL.USER_ID,
157: p_LAST_UPDATE_LOGIN => p_prof_color_rec.LAST_UPDATE_LOGIN);
158:
159: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
160: RAISE FND_API.G_EXC_ERROR;
161: END IF;
162:
163: --
164: -- End of API body
164: -- End of API body
165: --
166:
167: -- Standard check for p_commit
168: IF FND_API.to_Boolean( p_commit )
169: THEN
170: COMMIT WORK;
171: END IF;
172:
177: p_data => x_msg_data
178: );
179:
180: EXCEPTION
181: WHEN FND_API.G_EXC_ERROR THEN
182: ROLLBACK TO CREATE_PROF_COLOR_CODE_PVT;
183: x_return_status := FND_API.G_RET_STS_ERROR ;
184: --FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
185: --p_data => x_msg_data) ;
179:
180: EXCEPTION
181: WHEN FND_API.G_EXC_ERROR THEN
182: ROLLBACK TO CREATE_PROF_COLOR_CODE_PVT;
183: x_return_status := FND_API.G_RET_STS_ERROR ;
184: --FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
185: --p_data => x_msg_data) ;
186:
187: APP_EXCEPTION.RAISE_EXCEPTION;
184: --FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
185: --p_data => x_msg_data) ;
186:
187: APP_EXCEPTION.RAISE_EXCEPTION;
188: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
189: ROLLBACK TO CREATE_PROF_COLOR_CODE_PVT;
190: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
191: --FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
192: --p_data => x_msg_data) ;
186:
187: APP_EXCEPTION.RAISE_EXCEPTION;
188: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
189: ROLLBACK TO CREATE_PROF_COLOR_CODE_PVT;
190: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
191: --FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
192: --p_data => x_msg_data) ;
193: APP_EXCEPTION.RAISE_EXCEPTION;
194:
193: APP_EXCEPTION.RAISE_EXCEPTION;
194:
195: WHEN OTHERS THEN
196: ROLLBACK TO CREATE_PROF_COLOR_CODE_PVT;
197: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
198: --FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
199: --p_data => x_msg_data) ;
200: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
201: FND_MSG_PUB.Build_Exc_Msg(G_PKG_NAME, l_api_name);
282: -- Standard Start of API savepoint
283: SAVEPOINT UPDATE_PROF_COLOR_CODE_PVT;
284:
285: -- Standard call to check for call compatibility.
286: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
287: p_api_version_number,
288: l_api_name,
289: G_PKG_NAME)
290: THEN
287: p_api_version_number,
288: l_api_name,
289: G_PKG_NAME)
290: THEN
291: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
292: END IF;
293:
294:
295: -- Initialize message list if p_init_msg_list is set to TRUE.
292: END IF;
293:
294:
295: -- Initialize message list if p_init_msg_list is set to TRUE.
296: IF FND_API.to_Boolean( p_init_msg_list )
297: THEN
298: FND_MSG_PUB.initialize;
299: END IF;
300:
301:
302:
303:
304: -- Initialize API return status to SUCCESS
305: x_return_status := FND_API.G_RET_STS_SUCCESS;
306:
307: --
308: -- Api body
309: --
325: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
326: THEN
327: CSC_CORE_UTILS_PVT.RECORD_IS_LOCKED_MSG(l_api_name);
328: END IF;
329: raise FND_API.G_EXC_ERROR;
330:
331: END IF;
332: Close C_Get_prof_color_code;
333:
331: END IF;
332: Close C_Get_prof_color_code;
333:
334:
335: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
336: THEN
337:
338: -- Invoke validation procedures
339: Validate_prof_color_code(
336: THEN
337:
338: -- Invoke validation procedures
339: Validate_prof_color_code(
340: p_init_msg_list => FND_API.G_FALSE,
341: p_validation_level => p_validation_level,
342: p_validation_mode => CSC_CORE_UTILS_PVT.G_UPDATE,
343: P_prof_color_rec_type_Rec => P_prof_color_rec,
344: x_return_status => x_return_status,
345: x_msg_count => x_msg_count,
346: x_msg_data => x_msg_data);
347: END IF;
348:
349: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
350: RAISE FND_API.G_EXC_ERROR;
351: END IF;
352:
353: -- Invoke table handler(CSC_COLOR_CODES_PKG.Update_Row)
346: x_msg_data => x_msg_data);
347: END IF;
348:
349: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
350: RAISE FND_API.G_EXC_ERROR;
351: END IF;
352:
353: -- Invoke table handler(CSC_COLOR_CODES_PKG.Update_Row)
354: CSC_COLOR_CODES_PKG.Update_Row(
361: -- End of API body.
362: --
363:
364: -- Standard check for p_commit
365: IF FND_API.to_Boolean( p_commit )
366: THEN
367: COMMIT WORK;
368: END IF;
369:
373: p_data => x_msg_data
374: );
375:
376: EXCEPTION
377: WHEN FND_API.G_EXC_ERROR THEN
378: ROLLBACK TO UPDATE_PROF_COLOR_CODE_PVT;
379: x_return_status := FND_API.G_RET_STS_ERROR ;
380: --FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
381: --p_data => x_msg_data) ;
375:
376: EXCEPTION
377: WHEN FND_API.G_EXC_ERROR THEN
378: ROLLBACK TO UPDATE_PROF_COLOR_CODE_PVT;
379: x_return_status := FND_API.G_RET_STS_ERROR ;
380: --FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
381: --p_data => x_msg_data) ;
382: APP_EXCEPTION.RAISE_EXCEPTION;
383:
380: --FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
381: --p_data => x_msg_data) ;
382: APP_EXCEPTION.RAISE_EXCEPTION;
383:
384: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
385: ROLLBACK TO UPDATE_PROF_COLOR_CODE_PVT;
386: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
387: --FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
388: --p_data => x_msg_data) ;
382: APP_EXCEPTION.RAISE_EXCEPTION;
383:
384: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
385: ROLLBACK TO UPDATE_PROF_COLOR_CODE_PVT;
386: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
387: --FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
388: --p_data => x_msg_data) ;
389: APP_EXCEPTION.RAISE_EXCEPTION;
390:
389: APP_EXCEPTION.RAISE_EXCEPTION;
390:
391: WHEN OTHERS THEN
392: ROLLBACK TO UPDATE_PROF_COLOR_CODE_PVT;
393: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
394: --FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
395: --p_data => x_msg_data) ;
396: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
397: FND_MSG_PUB.Build_Exc_Msg(G_PKG_NAME, l_api_name);
419: -- Standard Start of API savepoint
420: SAVEPOINT DELETE_PROF_COLOR_CODE_PVT;
421:
422: -- Standard call to check for call compatibility.
423: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
424: p_api_version_number,
425: l_api_name,
426: G_PKG_NAME)
427: THEN
424: p_api_version_number,
425: l_api_name,
426: G_PKG_NAME)
427: THEN
428: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
429: END IF;
430:
431:
432: -- Initialize message list if p_init_msg_list is set to TRUE.
429: END IF;
430:
431:
432: -- Initialize message list if p_init_msg_list is set to TRUE.
433: IF FND_API.to_Boolean( p_init_msg_list )
434: THEN
435: FND_MSG_PUB.initialize;
436: END IF;
437:
438:
439:
440:
441: -- Initialize API return status to SUCCESS
442: x_return_status := FND_API.G_RET_STS_SUCCESS;
443:
444: --
445: -- Api body
446: --
451: -- End of API body
452: --
453:
454: -- Standard check for p_commit
455: IF FND_API.to_Boolean( p_commit )
456: THEN
457: COMMIT WORK;
458: END IF;
459:
466: p_data => x_msg_data
467: );
468:
469: EXCEPTION
470: WHEN FND_API.G_EXC_ERROR THEN
471: ROLLBACK TO DELETE_PROF_COLOR_CODE_PVT;
472: x_return_status := FND_API.G_RET_STS_ERROR ;
473: --FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
474: --p_data => x_msg_data) ;
468:
469: EXCEPTION
470: WHEN FND_API.G_EXC_ERROR THEN
471: ROLLBACK TO DELETE_PROF_COLOR_CODE_PVT;
472: x_return_status := FND_API.G_RET_STS_ERROR ;
473: --FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
474: --p_data => x_msg_data) ;
475: APP_EXCEPTION.RAISE_EXCEPTION;
476:
473: --FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
474: --p_data => x_msg_data) ;
475: APP_EXCEPTION.RAISE_EXCEPTION;
476:
477: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
478: ROLLBACK TO DELETE_PROF_COLOR_CODE_PVT;
479: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
480: --FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
481: --p_data => x_msg_data) ;
475: APP_EXCEPTION.RAISE_EXCEPTION;
476:
477: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
478: ROLLBACK TO DELETE_PROF_COLOR_CODE_PVT;
479: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
480: --FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
481: --p_data => x_msg_data) ;
482: APP_EXCEPTION.RAISE_EXCEPTION;
483:
482: APP_EXCEPTION.RAISE_EXCEPTION;
483:
484: WHEN OTHERS THEN
485: ROLLBACK TO DELETE_PROF_COLOR_CODE_PVT;
486: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
487: --FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
488: --p_data => x_msg_data) ;
489: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
490: FND_MSG_PUB.Build_Exc_Msg(G_PKG_NAME, l_api_name);
508:
509: BEGIN
510:
511: -- Initialize message list if p_init_msg_list is set to TRUE.
512: IF FND_API.to_Boolean( p_init_msg_list )
513: THEN
514: FND_MSG_PUB.initialize;
515: END IF;
516:
515: END IF;
516:
517:
518: -- Initialize API return status to SUCCESS
519: x_return_status := FND_API.G_RET_STS_SUCCESS;
520:
521: -- validate NOT NULL column
522: IF(p_COLOR_CODE is NULL)
523: THEN
520:
521: -- validate NOT NULL column
522: IF(p_COLOR_CODE is NULL)
523: THEN
524: x_return_status := FND_API.G_RET_STS_ERROR;
525: END IF;
526:
527: IF(p_validation_mode = CSC_CORE_UTILS_PVT.G_CREATE)
528: THEN
590: where rating_code = p_rating_code;
591: BEGIN
592:
593: -- Initialize message list if p_init_msg_list is set to TRUE.
594: IF FND_API.to_Boolean( p_init_msg_list )
595: THEN
596: FND_MSG_PUB.initialize;
597: END IF;
598:
596: FND_MSG_PUB.initialize;
597: END IF;
598:
599: -- Initialize API return status to SUCCESS
600: x_return_status := FND_API.G_RET_STS_SUCCESS;
601:
602: -- validate NOT NULL column
603: IF(p_RATING_CODE is NULL and p_RATING_CODE = CSC_CORE_UTILS_PVT.G_MISS_CHAR)
604: THEN
601:
602: -- validate NOT NULL column
603: IF(p_RATING_CODE is NULL and p_RATING_CODE = CSC_CORE_UTILS_PVT.G_MISS_CHAR)
604: THEN
605: x_return_status := FND_API.G_RET_STS_ERROR;
606: CSC_CORE_UTILS_PVT.mandatory_arg_error(
607: p_api_name => p_api_name,
608: p_argument => 'P_RATING_CODE',
609: p_argument_value => p_rating_code);
618: l_lookup_code := p_rating_code;
619: open c;
620: fetch c into l_dummy;
621: if c%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_rating_code,
626: p_argument => 'p_rating_code');
629: THEN
630: open c1;
631: fetch c1 into l_dummy;
632: if c1%found then
633: x_return_status := FND_API.G_RET_STS_ERROR;
634: CSC_CORE_UTILS_PVT.Add_Duplicate_Value_Msg(
635: p_api_name => p_api_name,
636: p_argument => 'p_rating_code' ,
637: p_argument_value => p_rating_code );
667:
668:
669:
670: -- Initialize API return status to SUCCESS
671: x_return_status := FND_API.G_RET_STS_SUCCESS;
672:
673: IF (p_validation_level > CSC_CORE_UTILS_PVT.G_VALID_LEVEL_NONE) THEN
674:
675: Validate_COLOR_CODE(
672:
673: IF (p_validation_level > CSC_CORE_UTILS_PVT.G_VALID_LEVEL_NONE) THEN
674:
675: Validate_COLOR_CODE(
676: p_init_msg_list => FND_API.G_FALSE,
677: p_validation_mode => p_validation_mode,
678: p_COLOR_CODE => P_prof_color_rec_type_Rec.COLOR_CODE,
679: x_return_status => x_return_status,
680: x_msg_count => x_msg_count,
678: p_COLOR_CODE => P_prof_color_rec_type_Rec.COLOR_CODE,
679: x_return_status => x_return_status,
680: x_msg_count => x_msg_count,
681: x_msg_data => x_msg_data);
682: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
683: raise FND_API.G_EXC_ERROR;
684: END IF;
685:
686: Validate_RATING_CODE(
679: x_return_status => x_return_status,
680: x_msg_count => x_msg_count,
681: x_msg_data => x_msg_data);
682: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
683: raise FND_API.G_EXC_ERROR;
684: END IF;
685:
686: Validate_RATING_CODE(
687: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,
689: p_RATING_CODE => P_prof_color_rec_type_Rec.RATING_CODE,
690: x_return_status => x_return_status,
691: x_msg_count => x_msg_count,
692: x_msg_data => x_msg_data);
693: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
694: raise FND_API.G_EXC_ERROR;
695: END IF;
696:
697: END IF;
690: x_return_status => x_return_status,
691: x_msg_count => x_msg_count,
692: x_msg_data => x_msg_data);
693: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
694: raise FND_API.G_EXC_ERROR;
695: END IF;
696:
697: END IF;
698: