1891: BEGIN
1892: -- check for valid parameters, return message if invalid.
1893: IF p_attr_type NOT IN ('X','Y') THEN
1894: x_return_status := FND_API.G_RET_STS_ERROR;
1895: FND_MESSAGE.Set_Name('EGO', 'EGO_API_INVALID_PARAMS');
1896: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
1897: FND_MESSAGE.Set_Token('PROC_NAME"', l_api_name);
1898: FND_MSG_PUB.Add;
1899: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
1892: -- check for valid parameters, return message if invalid.
1893: IF p_attr_type NOT IN ('X','Y') THEN
1894: x_return_status := FND_API.G_RET_STS_ERROR;
1895: FND_MESSAGE.Set_Name('EGO', 'EGO_API_INVALID_PARAMS');
1896: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
1897: FND_MESSAGE.Set_Token('PROC_NAME"', l_api_name);
1898: FND_MSG_PUB.Add;
1899: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
1900: ,p_count => x_msg_count
1893: IF p_attr_type NOT IN ('X','Y') THEN
1894: x_return_status := FND_API.G_RET_STS_ERROR;
1895: FND_MESSAGE.Set_Name('EGO', 'EGO_API_INVALID_PARAMS');
1896: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
1897: FND_MESSAGE.Set_Token('PROC_NAME"', l_api_name);
1898: FND_MSG_PUB.Add;
1899: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
1900: ,p_count => x_msg_count
1901: ,p_data => x_msg_data);
1917: RETURN l_attr_int_value;
1918: EXCEPTION
1919: WHEN OTHERS THEN
1920: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1921: FND_MESSAGE.SET_NAME('FND', 'SQL_PLSQL_ERROR');
1922: FND_MESSAGE.SET_TOKEN('ROUTINE',G_PKG_NAME||l_api_name);
1923: FND_MESSAGE.SET_TOKEN('ERRNO', SQLCODE);
1924: FND_MESSAGE.SET_TOKEN('REASON', SQLERRM);
1925: FND_MSG_PUB.Add;
1918: EXCEPTION
1919: WHEN OTHERS THEN
1920: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1921: FND_MESSAGE.SET_NAME('FND', 'SQL_PLSQL_ERROR');
1922: FND_MESSAGE.SET_TOKEN('ROUTINE',G_PKG_NAME||l_api_name);
1923: FND_MESSAGE.SET_TOKEN('ERRNO', SQLCODE);
1924: FND_MESSAGE.SET_TOKEN('REASON', SQLERRM);
1925: FND_MSG_PUB.Add;
1926: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
1919: WHEN OTHERS THEN
1920: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1921: FND_MESSAGE.SET_NAME('FND', 'SQL_PLSQL_ERROR');
1922: FND_MESSAGE.SET_TOKEN('ROUTINE',G_PKG_NAME||l_api_name);
1923: FND_MESSAGE.SET_TOKEN('ERRNO', SQLCODE);
1924: FND_MESSAGE.SET_TOKEN('REASON', SQLERRM);
1925: FND_MSG_PUB.Add;
1926: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
1927: ,p_count => x_msg_count
1920: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1921: FND_MESSAGE.SET_NAME('FND', 'SQL_PLSQL_ERROR');
1922: FND_MESSAGE.SET_TOKEN('ROUTINE',G_PKG_NAME||l_api_name);
1923: FND_MESSAGE.SET_TOKEN('ERRNO', SQLCODE);
1924: FND_MESSAGE.SET_TOKEN('REASON', SQLERRM);
1925: FND_MSG_PUB.Add;
1926: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
1927: ,p_count => x_msg_count
1928: ,p_data => x_msg_data);