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:
123:
124: -- Initialize API return status to SUCCESS
171: END IF;
172:
173:
174: -- Standard call to get message count and if count is 1, get message info.
175: FND_MSG_PUB.Count_And_Get
176: ( p_count => x_msg_count,
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) ;
186:
187: APP_EXCEPTION.RAISE_EXCEPTION;
188: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
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:
195: WHEN OTHERS THEN
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);
202: END IF;
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);
202: END IF;
203: APP_EXCEPTION.RAISE_EXCEPTION;
204:
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);
202: END IF;
203: APP_EXCEPTION.RAISE_EXCEPTION;
204:
205: End Create_prof_color_code;
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:
321: l_old_prof_color_rec.CREATED_BY,
322: l_old_prof_color_rec.LAST_UPDATE_LOGIN;
323:
324: If ( C_Get_prof_color_code%NOTFOUND) Then
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;
367: COMMIT WORK;
368: END IF;
369:
370: -- Standard call to get message count and if count is 1, get message info.
371: FND_MSG_PUB.Count_And_Get
372: ( p_count => x_msg_count,
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) ;
382: APP_EXCEPTION.RAISE_EXCEPTION;
383:
384: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
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:
391: WHEN OTHERS THEN
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);
398: END IF;
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);
398: END IF;
399: APP_EXCEPTION.RAISE_EXCEPTION;
400:
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);
398: END IF;
399: APP_EXCEPTION.RAISE_EXCEPTION;
400:
401: End Update_prof_color_code;
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:
460:
461:
462:
463: -- Standard call to get message count and if count is 1, get message info.
464: FND_MSG_PUB.Count_And_Get
465: ( p_count => x_msg_count,
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) ;
475: APP_EXCEPTION.RAISE_EXCEPTION;
476:
477: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
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:
484: WHEN OTHERS THEN
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);
491: END IF;
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);
491: END IF;
492: APP_EXCEPTION.RAISE_EXCEPTION;
493:
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);
491: END IF;
492: APP_EXCEPTION.RAISE_EXCEPTION;
493:
494: End Delete_prof_color_code;
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:
517:
518: -- Initialize API return status to SUCCESS
555:
556: END IF;
557:
558: -- Standard call to get message count and if count is 1, get message info.
559: FND_MSG_PUB.Count_And_Get
560: ( p_count => x_msg_count,
561: p_data => x_msg_data
562: );
563:
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:
599: -- Initialize API return status to SUCCESS
600: x_return_status := FND_API.G_RET_STS_SUCCESS;
644:
645: --END IF;
646:
647: -- Standard call to get message count and if count is 1, get message info.
648: FND_MSG_PUB.Count_And_Get
649: ( p_count => x_msg_count,
650: p_data => x_msg_data
651: );
652: