182:
183: -- Initialize message list if p_init_msg_list is set to TRUE.
184: IF FND_API.to_Boolean( p_init_msg_list )
185: THEN
186: FND_MSG_PUB.initialize;
187: END IF;
188:
189:
190:
236:
237:
238:
239: -- Standard call to get message count and if count is 1, get message info.
240: FND_MSG_PUB.Count_And_Get
241: ( p_count => x_msg_count,
242: p_data => x_msg_data
243: );
244:
245: EXCEPTION
246: WHEN FND_API.G_EXC_ERROR THEN
247: ROLLBACK TO CREATE_PROF_MODULE_GROUPS_PUB;
248: x_return_status := FND_API.G_RET_STS_ERROR ;
249: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
250: p_data => x_msg_data) ;
251:
252: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
253: ROLLBACK TO CREATE_PROF_MODULE_GROUPS_PUB;
251:
252: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
253: ROLLBACK TO CREATE_PROF_MODULE_GROUPS_PUB;
254: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
255: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
256: p_data => x_msg_data) ;
257:
258: WHEN OTHERS THEN
259: ROLLBACK TO CREATE_PROF_MODULE_GROUPS_PUB;
257:
258: WHEN OTHERS THEN
259: ROLLBACK TO CREATE_PROF_MODULE_GROUPS_PUB;
260: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
261: IF FND_MSG_PUB.Check_Msg_Level
262: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
263: THEN
264: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
265: END IF ;
258: WHEN OTHERS THEN
259: ROLLBACK TO CREATE_PROF_MODULE_GROUPS_PUB;
260: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
261: IF FND_MSG_PUB.Check_Msg_Level
262: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
263: THEN
264: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
265: END IF ;
266: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
260: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
261: IF FND_MSG_PUB.Check_Msg_Level
262: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
263: THEN
264: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
265: END IF ;
266: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
267: p_data => x_msg_data) ;
268:
262: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
263: THEN
264: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
265: END IF ;
266: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
267: p_data => x_msg_data) ;
268:
269: End Create_prof_module_groups;
270:
360:
361: -- Initialize message list if p_init_msg_list is set to TRUE.
362: IF FND_API.to_Boolean( p_init_msg_list )
363: THEN
364: FND_MSG_PUB.initialize;
365: END IF;
366:
367:
368:
411:
412:
413:
414: -- Standard call to get message count and if count is 1, get message info.
415: FND_MSG_PUB.Count_And_Get
416: ( p_count => x_msg_count,
417: p_data => x_msg_data
418: );
419:
420: EXCEPTION
421: WHEN FND_API.G_EXC_ERROR THEN
422: ROLLBACK TO UPDATE_PROF_MODULE_GROUPS_PUB;
423: x_return_status := FND_API.G_RET_STS_ERROR ;
424: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
425: p_data => x_msg_data) ;
426:
427:
428: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
427:
428: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
429: ROLLBACK TO UPDATE_PROF_MODULE_GROUPS_PUB;
430: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
431: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
432: p_data => x_msg_data) ;
433:
434: WHEN OTHERS THEN
435: ROLLBACK TO UPDATE_PROF_MODULE_GROUPS_PUB;
433:
434: WHEN OTHERS THEN
435: ROLLBACK TO UPDATE_PROF_MODULE_GROUPS_PUB;
436: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
437: IF FND_MSG_PUB.Check_Msg_Level
438: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
439: THEN
440: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
441: END IF ;
434: WHEN OTHERS THEN
435: ROLLBACK TO UPDATE_PROF_MODULE_GROUPS_PUB;
436: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
437: IF FND_MSG_PUB.Check_Msg_Level
438: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
439: THEN
440: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
441: END IF ;
442: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
436: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
437: IF FND_MSG_PUB.Check_Msg_Level
438: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
439: THEN
440: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
441: END IF ;
442: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
443: p_data => x_msg_data) ;
444:
438: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
439: THEN
440: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
441: END IF ;
442: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
443: p_data => x_msg_data) ;
444:
445: End Update_prof_module_groups;
446:
475:
476: -- Initialize message list if p_init_msg_list is set to TRUE.
477: IF FND_API.to_Boolean( p_init_msg_list )
478: THEN
479: FND_MSG_PUB.initialize;
480: END IF;
481:
482:
483:
527:
528:
529:
530: -- Standard call to get message count and if count is 1, get message info.
531: FND_MSG_PUB.Count_And_Get
532: ( p_count => x_msg_count,
533: p_data => x_msg_data
534: );
535:
536: EXCEPTION
537: WHEN FND_API.G_EXC_ERROR THEN
538: ROLLBACK TO DELETE_PROF_MODULE_GROUPS_PUB;
539: x_return_status := FND_API.G_RET_STS_ERROR;
540: FND_MSG_PUB.Count_And_Get
541: ( p_count => x_msg_count,
542: p_data => x_msg_data
543: );
544:
544:
545: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
546: ROLLBACK TO DELETE_PROF_MODULE_GROUPS_PUB;
547: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
548: FND_MSG_PUB.Count_And_Get
549: ( p_count => x_msg_count,
550: p_data => x_msg_data
551: );
552:
552:
553: WHEN OTHERS THEN
554: ROLLBACK TO DELETE_PROF_MODULE_GROUPS_PUB;
555: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
556: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
557: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
558: END IF;
559: FND_MSG_PUB.Count_And_Get
560: ( p_count => x_msg_count,
553: WHEN OTHERS THEN
554: ROLLBACK TO DELETE_PROF_MODULE_GROUPS_PUB;
555: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
556: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
557: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
558: END IF;
559: FND_MSG_PUB.Count_And_Get
560: ( p_count => x_msg_count,
561: p_data => x_msg_data
555: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
556: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
557: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
558: END IF;
559: FND_MSG_PUB.Count_And_Get
560: ( p_count => x_msg_count,
561: p_data => x_msg_data
562: );
563: