DBA Data[Home] [Help]

APPS.CSC_PROF_COLOR_CODE_PVT dependencies on FND_MSG_PUB

Line 120: FND_MSG_PUB.initialize;

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

Line 175: FND_MSG_PUB.Count_And_Get

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:

Line 184: --FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,

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

Line 191: --FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,

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

Line 198: --FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,

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;

Line 200: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) 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;
203: APP_EXCEPTION.RAISE_EXCEPTION;
204:

Line 201: FND_MSG_PUB.Build_Exc_Msg(G_PKG_NAME, l_api_name);

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;

Line 298: FND_MSG_PUB.initialize;

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:

Line 325: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

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;

Line 371: FND_MSG_PUB.Count_And_Get

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:

Line 380: --FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,

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

Line 387: --FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,

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

Line 394: --FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,

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;

Line 396: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) 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;
399: APP_EXCEPTION.RAISE_EXCEPTION;
400:

Line 397: FND_MSG_PUB.Build_Exc_Msg(G_PKG_NAME, l_api_name);

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;

Line 435: FND_MSG_PUB.initialize;

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:

Line 464: FND_MSG_PUB.Count_And_Get

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:

Line 473: --FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,

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

Line 480: --FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,

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

Line 487: --FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,

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;

Line 489: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) 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;
492: APP_EXCEPTION.RAISE_EXCEPTION;
493:

Line 490: FND_MSG_PUB.Build_Exc_Msg(G_PKG_NAME, l_api_name);

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;

Line 514: FND_MSG_PUB.initialize;

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

Line 559: FND_MSG_PUB.Count_And_Get

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:

Line 596: FND_MSG_PUB.initialize;

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;

Line 648: FND_MSG_PUB.Count_And_Get

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: