DBA Data[Home] [Help]

APPS.BIS_RL_PKG dependencies on FND_API

Line 1961: WHEN FND_API.G_EXC_ERROR THEN

1957: CLOSE cr_customlinks;
1958: END IF;
1959:
1960: EXCEPTION
1961: WHEN FND_API.G_EXC_ERROR THEN
1962: x_return_status := FND_API.G_RET_STS_ERROR;
1963: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
1964: ,p_data => x_msg_data);
1965: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1962: x_return_status := FND_API.G_RET_STS_ERROR;

1958: END IF;
1959:
1960: EXCEPTION
1961: WHEN FND_API.G_EXC_ERROR THEN
1962: x_return_status := FND_API.G_RET_STS_ERROR;
1963: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
1964: ,p_data => x_msg_data);
1965: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1966: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1965: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1961: WHEN FND_API.G_EXC_ERROR THEN
1962: x_return_status := FND_API.G_RET_STS_ERROR;
1963: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
1964: ,p_data => x_msg_data);
1965: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1966: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1967: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
1968: ,p_data => x_msg_data);
1969: WHEN NO_DATA_FOUND THEN

Line 1966: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1962: x_return_status := FND_API.G_RET_STS_ERROR;
1963: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
1964: ,p_data => x_msg_data);
1965: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1966: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1967: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
1968: ,p_data => x_msg_data);
1969: WHEN NO_DATA_FOUND THEN
1970: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1970: x_return_status := FND_API.G_RET_STS_ERROR;

1966: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1967: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
1968: ,p_data => x_msg_data);
1969: WHEN NO_DATA_FOUND THEN
1970: x_return_status := FND_API.G_RET_STS_ERROR;
1971: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
1972: ,p_data => x_msg_data);
1973: WHEN OTHERS THEN
1974: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1974: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1970: x_return_status := FND_API.G_RET_STS_ERROR;
1971: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
1972: ,p_data => x_msg_data);
1973: WHEN OTHERS THEN
1974: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1975: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
1976: ,p_data => x_msg_data);
1977: if (x_msg_data is null) then
1978: x_msg_data := SQLERRM;

Line 2068: WHEN FND_API.G_EXC_ERROR THEN

2064: from bis_related_links_tl
2065: where related_link_id = l_related_link_id
2066: and language = l.language_code);
2067: EXCEPTION
2068: WHEN FND_API.G_EXC_ERROR THEN
2069: x_return_status := FND_API.G_RET_STS_ERROR;
2070: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
2071: ,p_data => x_msg_data);
2072: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2069: x_return_status := FND_API.G_RET_STS_ERROR;

2065: where related_link_id = l_related_link_id
2066: and language = l.language_code);
2067: EXCEPTION
2068: WHEN FND_API.G_EXC_ERROR THEN
2069: x_return_status := FND_API.G_RET_STS_ERROR;
2070: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
2071: ,p_data => x_msg_data);
2072: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2073: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2072: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2068: WHEN FND_API.G_EXC_ERROR THEN
2069: x_return_status := FND_API.G_RET_STS_ERROR;
2070: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
2071: ,p_data => x_msg_data);
2072: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2073: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2074: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
2075: ,p_data => x_msg_data);
2076: WHEN NO_DATA_FOUND THEN

Line 2073: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2069: x_return_status := FND_API.G_RET_STS_ERROR;
2070: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
2071: ,p_data => x_msg_data);
2072: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2073: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2074: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
2075: ,p_data => x_msg_data);
2076: WHEN NO_DATA_FOUND THEN
2077: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2077: x_return_status := FND_API.G_RET_STS_ERROR;

2073: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2074: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
2075: ,p_data => x_msg_data);
2076: WHEN NO_DATA_FOUND THEN
2077: x_return_status := FND_API.G_RET_STS_ERROR;
2078: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
2079: ,p_data => x_msg_data);
2080: WHEN OTHERS THEN
2081: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2081: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2077: x_return_status := FND_API.G_RET_STS_ERROR;
2078: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
2079: ,p_data => x_msg_data);
2080: WHEN OTHERS THEN
2081: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2082: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
2083: ,p_data => x_msg_data);
2084: if (x_msg_data is null) then
2085: x_msg_data := SQLERRM;

Line 2132: WHEN FND_API.G_EXC_ERROR THEN

2128: end if;
2129:
2130:
2131: EXCEPTION
2132: WHEN FND_API.G_EXC_ERROR THEN
2133: x_return_status := FND_API.G_RET_STS_ERROR;
2134: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
2135: ,p_data => x_msg_data);
2136: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2133: x_return_status := FND_API.G_RET_STS_ERROR;

2129:
2130:
2131: EXCEPTION
2132: WHEN FND_API.G_EXC_ERROR THEN
2133: x_return_status := FND_API.G_RET_STS_ERROR;
2134: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
2135: ,p_data => x_msg_data);
2136: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2137: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2136: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2132: WHEN FND_API.G_EXC_ERROR THEN
2133: x_return_status := FND_API.G_RET_STS_ERROR;
2134: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
2135: ,p_data => x_msg_data);
2136: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2137: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2138: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
2139: ,p_data => x_msg_data);
2140: WHEN NO_DATA_FOUND THEN

Line 2137: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2133: x_return_status := FND_API.G_RET_STS_ERROR;
2134: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
2135: ,p_data => x_msg_data);
2136: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2137: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2138: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
2139: ,p_data => x_msg_data);
2140: WHEN NO_DATA_FOUND THEN
2141: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2141: x_return_status := FND_API.G_RET_STS_ERROR;

2137: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2138: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
2139: ,p_data => x_msg_data);
2140: WHEN NO_DATA_FOUND THEN
2141: x_return_status := FND_API.G_RET_STS_ERROR;
2142: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
2143: ,p_data => x_msg_data);
2144: WHEN OTHERS THEN
2145: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2145: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2141: x_return_status := FND_API.G_RET_STS_ERROR;
2142: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
2143: ,p_data => x_msg_data);
2144: WHEN OTHERS THEN
2145: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2146: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
2147: ,p_data => x_msg_data);
2148: if (x_msg_data is null) then
2149: x_msg_data := SQLERRM;

Line 2203: WHEN FND_API.G_EXC_ERROR THEN

2199: CLOSE cr_seedlinks;
2200: END IF;
2201:
2202: EXCEPTION
2203: WHEN FND_API.G_EXC_ERROR THEN
2204: x_return_status := FND_API.G_RET_STS_ERROR;
2205: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
2206: ,p_data => x_msg_data);
2207: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2204: x_return_status := FND_API.G_RET_STS_ERROR;

2200: END IF;
2201:
2202: EXCEPTION
2203: WHEN FND_API.G_EXC_ERROR THEN
2204: x_return_status := FND_API.G_RET_STS_ERROR;
2205: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
2206: ,p_data => x_msg_data);
2207: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2208: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2207: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2203: WHEN FND_API.G_EXC_ERROR THEN
2204: x_return_status := FND_API.G_RET_STS_ERROR;
2205: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
2206: ,p_data => x_msg_data);
2207: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2208: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2209: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
2210: ,p_data => x_msg_data);
2211: WHEN NO_DATA_FOUND THEN

Line 2208: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2204: x_return_status := FND_API.G_RET_STS_ERROR;
2205: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
2206: ,p_data => x_msg_data);
2207: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2208: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2209: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
2210: ,p_data => x_msg_data);
2211: WHEN NO_DATA_FOUND THEN
2212: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2212: x_return_status := FND_API.G_RET_STS_ERROR;

2208: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2209: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
2210: ,p_data => x_msg_data);
2211: WHEN NO_DATA_FOUND THEN
2212: x_return_status := FND_API.G_RET_STS_ERROR;
2213: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
2214: ,p_data => x_msg_data);
2215: WHEN OTHERS THEN
2216: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2216: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2212: x_return_status := FND_API.G_RET_STS_ERROR;
2213: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
2214: ,p_data => x_msg_data);
2215: WHEN OTHERS THEN
2216: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2217: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
2218: ,p_data => x_msg_data);
2219: if (x_msg_data is null) then
2220: x_msg_data := SQLERRM;