96: end if;
97: SELECT language_code INTO x_language_Code
98: FROM fnd_languages
99: WHERE nls_language = l_language;
100: x_return_status := FND_API.G_RET_STS_SUCCESS;
101: FND_MSG_PUB.Count_And_get
102: (p_count => x_msg_count,
103: p_data => x_msg_data
104: );
103: p_data => x_msg_data
104: );
105: EXCEPTION
106: WHEN OTHERS THEN
107: x_return_status := FND_API.G_RET_STS_ERROR;
108: FND_MSG_PUB.Count_And_get
109: (p_count => x_msg_count,
110: p_data => x_msg_data
111: );