DBA Data[Home] [Help]

APPS.EGO_USER_ATTRS_COMMON_PVT dependencies on FND_MESSAGE

Line 2051: FND_MESSAGE.Set_Name('EGO', 'EGO_API_INVALID_PARAMS');

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;
2055: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

Line 2052: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);

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;
2055: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
2056: ,p_count => x_msg_count

Line 2053: FND_MESSAGE.Set_Token('PROC_NAME"', l_api_name);

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;
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);

Line 2077: FND_MESSAGE.SET_NAME('FND', 'SQL_PLSQL_ERROR');

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);
2081: FND_MSG_PUB.Add;

Line 2078: FND_MESSAGE.SET_TOKEN('ROUTINE',G_PKG_NAME||l_api_name);

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);
2081: FND_MSG_PUB.Add;
2082: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

Line 2079: FND_MESSAGE.SET_TOKEN('ERRNO', SQLCODE);

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);
2081: FND_MSG_PUB.Add;
2082: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
2083: ,p_count => x_msg_count

Line 2080: FND_MESSAGE.SET_TOKEN('REASON', SQLERRM);

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);
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);