204:
205: -- Initialize message list if p_init_msg_list is set to TRUE.
206: IF FND_API.to_Boolean( p_init_msg_list )
207: THEN
208: FND_MSG_PUB.initialize;
209: END IF;
210:
211:
212: -- Initialize API return status to SUCCESS
250: END IF;
251:
252:
253: -- Standard call to get message count and if count is 1, get message info.
254: FND_MSG_PUB.Count_And_Get
255: ( p_count => x_msg_count,
256: p_data => x_msg_data
257: );
258:
259: EXCEPTION
260: WHEN FND_API.G_EXC_ERROR THEN
261: ROLLBACK TO Create_Profile_Check_PUB;
262: x_return_status := FND_API.G_RET_STS_ERROR;
263: FND_MSG_PUB.Count_And_Get
264: ( p_count => x_msg_count,
265: p_data => x_msg_data
266: );
267: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
266: );
267: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
268: ROLLBACK TO Create_Profile_Check_PUB;
269: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
270: FND_MSG_PUB.Count_And_Get
271: ( p_count => x_msg_count,
272: p_data => x_msg_data
273: );
274: WHEN OTHERS THEN
273: );
274: WHEN OTHERS THEN
275: ROLLBACK TO Create_Profile_Check_PUB;
276: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
277: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
278: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
279: END IF;
280: FND_MSG_PUB.Count_And_Get
281: ( p_count => x_msg_count,
274: WHEN OTHERS THEN
275: ROLLBACK TO Create_Profile_Check_PUB;
276: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
277: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
278: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
279: END IF;
280: FND_MSG_PUB.Count_And_Get
281: ( p_count => x_msg_count,
282: p_data => x_msg_data
276: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
277: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
278: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
279: END IF;
280: FND_MSG_PUB.Count_And_Get
281: ( p_count => x_msg_count,
282: p_data => x_msg_data
283: );
284: End Create_Profile_check;
395:
396: -- Initialize message list if p_init_msg_list is set to TRUE.
397: IF FND_API.to_Boolean( p_init_msg_list )
398: THEN
399: FND_MSG_PUB.initialize;
400: END IF;
401:
402:
403: -- Initialize API return status to SUCCESS
443: END IF;
444:
445:
446: -- Standard call to get message count and if count is 1, get message info.
447: FND_MSG_PUB.Count_And_Get
448: ( p_count => x_msg_count,
449: p_data => x_msg_data
450: );
451:
452: EXCEPTION
453: WHEN FND_API.G_EXC_ERROR THEN
454: ROLLBACK TO Update_Profile_Check_PUB;
455: x_return_status := FND_API.G_RET_STS_ERROR;
456: FND_MSG_PUB.Count_And_Get
457: ( p_count => x_msg_count,
458: p_data => x_msg_data
459: );
460: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
459: );
460: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
461: ROLLBACK TO Update_Profile_Check_PUB;
462: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
463: FND_MSG_PUB.Count_And_Get
464: ( p_count => x_msg_count,
465: p_data => x_msg_data
466: );
467: WHEN OTHERS THEN
466: );
467: WHEN OTHERS THEN
468: ROLLBACK TO Update_Profile_Check_PUB;
469: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
470: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
471: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
472: END IF;
473: FND_MSG_PUB.Count_And_Get
474: ( p_count => x_msg_count,
467: WHEN OTHERS THEN
468: ROLLBACK TO Update_Profile_Check_PUB;
469: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
470: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
471: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
472: END IF;
473: FND_MSG_PUB.Count_And_Get
474: ( p_count => x_msg_count,
475: p_data => x_msg_data
469: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
470: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
471: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
472: END IF;
473: FND_MSG_PUB.Count_And_Get
474: ( p_count => x_msg_count,
475: p_data => x_msg_data
476: );
477: End Update_Profile_check;
506:
507: -- Initialize message list if p_init_msg_list is set to TRUE.
508: IF FND_API.to_Boolean( p_init_msg_list )
509: THEN
510: FND_MSG_PUB.initialize;
511: END IF;
512:
513:
514: -- Initialize API return status to SUCCESS
548:
549:
550:
551: -- Standard call to get message count and if count is 1, get message info.
552: FND_MSG_PUB.Count_And_Get
553: ( p_count => x_msg_count,
554: p_data => x_msg_data
555: );
556:
557: EXCEPTION
558: WHEN FND_API.G_EXC_ERROR THEN
559: ROLLBACK TO Delete_Profile_Check_PUB;
560: x_return_status := FND_API.G_RET_STS_ERROR;
561: FND_MSG_PUB.Count_And_Get
562: ( p_count => x_msg_count,
563: p_data => x_msg_data
564: );
565: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
564: );
565: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
566: ROLLBACK TO Delete_Profile_Check_PUB;
567: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
568: FND_MSG_PUB.Count_And_Get
569: ( p_count => x_msg_count,
570: p_data => x_msg_data
571: );
572: WHEN OTHERS THEN
571: );
572: WHEN OTHERS THEN
573: ROLLBACK TO Delete_Profile_Check_PUB;
574: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
575: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
576: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
577: END IF;
578: FND_MSG_PUB.Count_And_Get
579: ( p_count => x_msg_count,
572: WHEN OTHERS THEN
573: ROLLBACK TO Delete_Profile_Check_PUB;
574: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
575: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
576: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
577: END IF;
578: FND_MSG_PUB.Count_And_Get
579: ( p_count => x_msg_count,
580: p_data => x_msg_data
574: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
575: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
576: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
577: END IF;
578: FND_MSG_PUB.Count_And_Get
579: ( p_count => x_msg_count,
580: p_data => x_msg_data
581: );
582: End Delete_Profile_check;