DBA Data[Home] [Help]

APPS.IEM_DB_CONNECTIONS_PVT dependencies on FND_MESSAGE

Line 76: FND_MESSAGE.SET_NAME('IEM','IEM_NON_EXISTENT_DB_SRV_GRP');

72: Select count(*) into l_grp_cnt from iem_db_servers
73: where db_server_id=p_db_server_id
74: and rownum=1;
75: IF l_grp_cnt = 0 then
76: FND_MESSAGE.SET_NAME('IEM','IEM_NON_EXISTENT_DB_SRV_GRP');
77: FND_MSG_PUB.ADD;
78: x_return_status := FND_API.G_RET_STS_ERROR ;
79: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
80: p_data =>x_msg_data);

Line 336: FND_MESSAGE.SET_NAME('IEM','IEM_NON_EXISTENT_DB_SRV_GRP');

332: Select count(*) into l_grp_cnt from iem_db_servers
333: where db_server_id=p_db_Server_id
334: and rownum=1;
335: IF l_grp_cnt = 0 then
336: FND_MESSAGE.SET_NAME('IEM','IEM_NON_EXISTENT_DB_SRV_GRP');
337: FND_MSG_PUB.ADD;
338: x_return_status := FND_API.G_RET_STS_ERROR ;
339: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
340: p_data =>x_msg_data);

Line 477: FND_MESSAGE.SET_NAME('IEM','IEM_NON_EXISTENT_DBLINK_NAME');

473: FROM IEM_DB_CONNECTIONS
474: where db_server_id=p_db_server_id
475: and is_admin=p_is_admin;
476: EXCEPTION WHEN NO_DATA_FOUND THEN
477: FND_MESSAGE.SET_NAME('IEM','IEM_NON_EXISTENT_DBLINK_NAME');
478: FND_MSG_PUB.Add;
479: x_return_status := FND_API.G_RET_STS_ERROR ;
480: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
481: p_data =>x_msg_data);

Line 483: FND_MESSAGE.SET_NAME('IEM','IEM_MORE_THAN_ONE_DBLINK');

479: x_return_status := FND_API.G_RET_STS_ERROR ;
480: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
481: p_data =>x_msg_data);
482: WHEN TOO_MANY_ROWS THEN
483: FND_MESSAGE.SET_NAME('IEM','IEM_MORE_THAN_ONE_DBLINK');
484: FND_MSG_PUB.Add;
485: x_return_status := FND_API.G_RET_STS_ERROR ;
486: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
487: p_data =>x_msg_data);