DBA Data[Home] [Help]

APPS.IEM_ROUTE_CLASS_PUB dependencies on FND_MSG_PUB

Line 269: FND_MSG_PUB.initialize;

265: END IF;
266:
267: -- Initialize message list if p_init_msg_list is set to TRUE.
268: IF FND_API.to_Boolean( p_init_msg_list ) THEN
269: FND_MSG_PUB.initialize;
270: END IF;
271:
272: -- Initialize API return status to SUCCESS
273: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 456: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

452: COMMIT WORK;
453: End if;
454:
455: --Standard call to get message count and if count is 1 then get message info
456: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
457:
458: EXCEPTION
459: WHEN FND_API.G_EXC_ERROR THEN
460: Rollback to Classify_PUB;

Line 462: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

458: EXCEPTION
459: WHEN FND_API.G_EXC_ERROR THEN
460: Rollback to Classify_PUB;
461: x_return_status := FND_API.G_RET_STS_ERROR;
462: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
463: if l_exception_log then
464: errorMessage := '[' || sqlcode || sqlerrm || ']' || ' Execution Error';
465: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'IEM.PLSQL.IEM_ROUTE_CLASS_PUB.ROUTE.EXEC_ERROR', errorMessage);
466: end if;

Line 470: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

466: end if;
467: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
468: Rollback to Classify_PUB;
469: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
470: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
471: if l_exception_log then
472: errorMessage := '[' || sqlcode || sqlerrm || ']' || ' Unexpected Execution Error';
473: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'IEM.PLSQL.IEM_ROUTE_CLASS_PUB.ROUTE.UNEXP_EXEC_ERROR', errorMessage);
474: end if;

Line 478: IF fnd_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

474: end if;
475: WHEN OTHERS THEN
476: Rollback to Classify_PUB;
477: x_return_status := FND_API.G_RET_STS_ERROR;
478: IF fnd_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
479: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
480: END IF;
481: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
482:

Line 479: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

475: WHEN OTHERS THEN
476: Rollback to Classify_PUB;
477: x_return_status := FND_API.G_RET_STS_ERROR;
478: IF fnd_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
479: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
480: END IF;
481: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
482:
483: if l_exception_log then

Line 481: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

477: x_return_status := FND_API.G_RET_STS_ERROR;
478: IF fnd_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
479: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
480: END IF;
481: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
482:
483: if l_exception_log then
484: errorMessage := '[' || sqlcode || sqlerrm || ']' || ' Others';
485: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'IEM.PLSQL.IEM_ROUTE_CLASS_PUB.ROUTE.OTHERS', errorMessage);