APPS.EGO_USER_ATTRS_COMMON_PVT dependencies on FND_API

Line 2050: x_return_status := FND_API.G_RET_STS_ERROR;

2046: l_space_pos NUMBER;
2047: BEGIN
2048: -- check for valid parameters, return message if invalid.
2049: IF p_attr_type NOT IN ('X','Y') THEN
2050: x_return_status := FND_API.G_RET_STS_ERROR;
2051: FND_MESSAGE.Set_Name('EGO', 'EGO_API_INVALID_PARAMS');
2052: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
2053: FND_MESSAGE.Set_Token('PROC_NAME"', l_api_name);
2054: FND_MSG_PUB.Add;

Line 2055: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

2051: FND_MESSAGE.Set_Name('EGO', 'EGO_API_INVALID_PARAMS');
2052: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
2053: FND_MESSAGE.Set_Token('PROC_NAME"', l_api_name);
2054: FND_MSG_PUB.Add;
2055: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
2056: ,p_count => x_msg_count
2057: ,p_data => x_msg_data);
2058: RETURN p_date;
2059: END IF;

Line 2076: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2072: END IF;
2073: RETURN l_attr_int_value;
2074: EXCEPTION
2075: WHEN OTHERS THEN
2076: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2077: FND_MESSAGE.SET_NAME('FND', 'SQL_PLSQL_ERROR');
2078: FND_MESSAGE.SET_TOKEN('ROUTINE',G_PKG_NAME||l_api_name);
2079: FND_MESSAGE.SET_TOKEN('ERRNO', SQLCODE);
2080: FND_MESSAGE.SET_TOKEN('REASON', SQLERRM);

Line 2082: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

2078: FND_MESSAGE.SET_TOKEN('ROUTINE',G_PKG_NAME||l_api_name);
2079: FND_MESSAGE.SET_TOKEN('ERRNO', SQLCODE);
2080: FND_MESSAGE.SET_TOKEN('REASON', SQLERRM);
2081: FND_MSG_PUB.Add;
2082: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
2083: ,p_count => x_msg_count
2084: ,p_data => x_msg_data);
2085: RETURN NULL;
2086: END Get_User_Pref_Date_Time_Val;

Line 2555: RETURN FND_API.G_FALSE;

2551: -- than deriving it.
2552: --
2553:
2554: IF l_owner = 'NOTEXISTS' THEN
2555: RETURN FND_API.G_FALSE;
2556: END IF;
2557: --
2558: -- bug 12998006. Add PLSQL session level caching.
2559: -- Added caching to the logic.

Line 2572: l_value := FND_API.G_TRUE;

2568: FETCH c INTO l_dummy_number;
2569: CLOSE c;
2570:
2571: IF l_dummy_number = 1 THEN
2572: l_value := FND_API.G_TRUE;
2573: ELSE
2574: l_value := FND_API.G_FALSE;
2575: END IF;
2576: cache_tablecol_data(p_owner => l_owner,

Line 2574: l_value := FND_API.G_FALSE;

2570:
2571: IF l_dummy_number = 1 THEN
2572: l_value := FND_API.G_TRUE;
2573: ELSE
2574: l_value := FND_API.G_FALSE;
2575: END IF;
2576: cache_tablecol_data(p_owner => l_owner,
2577: p_table_name => p_table_name,
2578: p_column_name => p_column_name,

Line 2587: RETURN FND_API.G_FALSE;

2583:
2584: EXCEPTION
2585: WHEN OTHERS THEN
2586: --code_debug('has_column_in_table() : '|| 'Exception ' || SQLERRM);
2587: RETURN FND_API.G_FALSE;
2588:
2589: END has_column_in_table;
2590:
2591: