2172: );
2173: END delete_row;
2174:
2175:
2176: --This function is called from versioning API OKC_VERSION_PVT
2177: --Old Location: OKCRVERB.pls
2178: --New Location: Base Table API
2179:
2180: FUNCTION create_version(
2221: EXCEPTION
2222: -- other appropriate handlers
2223: WHEN OTHERS THEN
2224: -- store SQL error message on message stack
2225: OKC_API.SET_MESSAGE(p_app_name => okc_version_pvt.G_APP_NAME,
2226: p_msg_name => okc_version_pvt.G_UNEXPECTED_ERROR,
2227: p_token1 => okc_version_pvt.G_SQLCODE_TOKEN,
2228: p_token1_value => sqlcode,
2229: p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,
2222: -- other appropriate handlers
2223: WHEN OTHERS THEN
2224: -- store SQL error message on message stack
2225: OKC_API.SET_MESSAGE(p_app_name => okc_version_pvt.G_APP_NAME,
2226: p_msg_name => okc_version_pvt.G_UNEXPECTED_ERROR,
2227: p_token1 => okc_version_pvt.G_SQLCODE_TOKEN,
2228: p_token1_value => sqlcode,
2229: p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,
2230: p_token2_value => sqlerrm);
2223: WHEN OTHERS THEN
2224: -- store SQL error message on message stack
2225: OKC_API.SET_MESSAGE(p_app_name => okc_version_pvt.G_APP_NAME,
2226: p_msg_name => okc_version_pvt.G_UNEXPECTED_ERROR,
2227: p_token1 => okc_version_pvt.G_SQLCODE_TOKEN,
2228: p_token1_value => sqlcode,
2229: p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,
2230: p_token2_value => sqlerrm);
2231:
2225: OKC_API.SET_MESSAGE(p_app_name => okc_version_pvt.G_APP_NAME,
2226: p_msg_name => okc_version_pvt.G_UNEXPECTED_ERROR,
2227: p_token1 => okc_version_pvt.G_SQLCODE_TOKEN,
2228: p_token1_value => sqlcode,
2229: p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,
2230: p_token2_value => sqlerrm);
2231:
2232: -- notify UNEXPECTED error
2233: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2233: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2234: return l_return_status;
2235: END create_version;
2236:
2237: --This Function is called from Versioning API OKC_VERSION_PVT
2238: --Old Location:OKCRVERB.pls
2239: --New Location:Base Table API
2240:
2241: FUNCTION restore_version(
2280: EXCEPTION
2281: -- other appropriate handlers
2282: WHEN OTHERS THEN
2283: -- store SQL error message on message stack
2284: OKC_API.SET_MESSAGE(p_app_name => okc_version_pvt.G_APP_NAME,
2285: p_msg_name => okc_version_pvt.G_UNEXPECTED_ERROR,
2286: p_token1 => okc_version_pvt.G_SQLCODE_TOKEN,
2287: p_token1_value => sqlcode,
2288: p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,
2281: -- other appropriate handlers
2282: WHEN OTHERS THEN
2283: -- store SQL error message on message stack
2284: OKC_API.SET_MESSAGE(p_app_name => okc_version_pvt.G_APP_NAME,
2285: p_msg_name => okc_version_pvt.G_UNEXPECTED_ERROR,
2286: p_token1 => okc_version_pvt.G_SQLCODE_TOKEN,
2287: p_token1_value => sqlcode,
2288: p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,
2289: p_token2_value => sqlerrm);
2282: WHEN OTHERS THEN
2283: -- store SQL error message on message stack
2284: OKC_API.SET_MESSAGE(p_app_name => okc_version_pvt.G_APP_NAME,
2285: p_msg_name => okc_version_pvt.G_UNEXPECTED_ERROR,
2286: p_token1 => okc_version_pvt.G_SQLCODE_TOKEN,
2287: p_token1_value => sqlcode,
2288: p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,
2289: p_token2_value => sqlerrm);
2290:
2284: OKC_API.SET_MESSAGE(p_app_name => okc_version_pvt.G_APP_NAME,
2285: p_msg_name => okc_version_pvt.G_UNEXPECTED_ERROR,
2286: p_token1 => okc_version_pvt.G_SQLCODE_TOKEN,
2287: p_token1_value => sqlcode,
2288: p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,
2289: p_token2_value => sqlerrm);
2290:
2291: -- notify UNEXPECTED error
2292: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;