6036: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
6037: --RAISE;
6038: END INSERT_ROW_UPG;
6039:
6040: --This function is called from versioning API OKC_VERSION_PVT
6041: --Old Location: OKCRVERB.pls
6042: --New Location: Base Table API
6043:
6044: FUNCTION create_version(
6230: WHEN OTHERS THEN
6231:
6232:
6233: -- store SQL error message on message stack
6234: OKC_API.SET_MESSAGE(p_app_name => okc_version_pvt.G_APP_NAME,
6235: p_msg_name => okc_version_pvt.G_UNEXPECTED_ERROR,
6236: p_token1 => okc_version_pvt.G_SQLCODE_TOKEN,
6237: p_token1_value => sqlcode,
6238: p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,
6231:
6232:
6233: -- store SQL error message on message stack
6234: OKC_API.SET_MESSAGE(p_app_name => okc_version_pvt.G_APP_NAME,
6235: p_msg_name => okc_version_pvt.G_UNEXPECTED_ERROR,
6236: p_token1 => okc_version_pvt.G_SQLCODE_TOKEN,
6237: p_token1_value => sqlcode,
6238: p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,
6239: p_token2_value => sqlerrm);
6232:
6233: -- store SQL error message on message stack
6234: OKC_API.SET_MESSAGE(p_app_name => okc_version_pvt.G_APP_NAME,
6235: p_msg_name => okc_version_pvt.G_UNEXPECTED_ERROR,
6236: p_token1 => okc_version_pvt.G_SQLCODE_TOKEN,
6237: p_token1_value => sqlcode,
6238: p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,
6239: p_token2_value => sqlerrm);
6240:
6234: OKC_API.SET_MESSAGE(p_app_name => okc_version_pvt.G_APP_NAME,
6235: p_msg_name => okc_version_pvt.G_UNEXPECTED_ERROR,
6236: p_token1 => okc_version_pvt.G_SQLCODE_TOKEN,
6237: p_token1_value => sqlcode,
6238: p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,
6239: p_token2_value => sqlerrm);
6240:
6241: -- notify UNEXPECTED error
6242: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
6242: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
6243: return l_return_status;
6244: END create_version;
6245:
6246: --This Function is called from Versioning API OKC_VERSION_PVT
6247: --Old Location:OKCRVERB.pls
6248: --New Location:Base Table API
6249:
6250: FUNCTION restore_version(
6435: WHEN OTHERS THEN
6436:
6437:
6438: -- store SQL error message on message stack
6439: OKC_API.SET_MESSAGE(p_app_name => okc_version_pvt.G_APP_NAME,
6440: p_msg_name => okc_version_pvt.G_UNEXPECTED_ERROR,
6441: p_token1 => okc_version_pvt.G_SQLCODE_TOKEN,
6442: p_token1_value => sqlcode,
6443: p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,
6436:
6437:
6438: -- store SQL error message on message stack
6439: OKC_API.SET_MESSAGE(p_app_name => okc_version_pvt.G_APP_NAME,
6440: p_msg_name => okc_version_pvt.G_UNEXPECTED_ERROR,
6441: p_token1 => okc_version_pvt.G_SQLCODE_TOKEN,
6442: p_token1_value => sqlcode,
6443: p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,
6444: p_token2_value => sqlerrm);
6437:
6438: -- store SQL error message on message stack
6439: OKC_API.SET_MESSAGE(p_app_name => okc_version_pvt.G_APP_NAME,
6440: p_msg_name => okc_version_pvt.G_UNEXPECTED_ERROR,
6441: p_token1 => okc_version_pvt.G_SQLCODE_TOKEN,
6442: p_token1_value => sqlcode,
6443: p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,
6444: p_token2_value => sqlerrm);
6445:
6439: OKC_API.SET_MESSAGE(p_app_name => okc_version_pvt.G_APP_NAME,
6440: p_msg_name => okc_version_pvt.G_UNEXPECTED_ERROR,
6441: p_token1 => okc_version_pvt.G_SQLCODE_TOKEN,
6442: p_token1_value => sqlcode,
6443: p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,
6444: p_token2_value => sqlerrm);
6445:
6446: -- notify UNEXPECTED error
6447: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
6516:
6517: EXCEPTION
6518: WHEN OTHERS THEN
6519: -- store SQL error message on message stack
6520: OKC_API.SET_MESSAGE(p_app_name => okc_version_pvt.G_APP_NAME,
6521: p_msg_name => okc_version_pvt.G_UNEXPECTED_ERROR,
6522: p_token1 => okc_version_pvt.G_SQLCODE_TOKEN,
6523: p_token1_value => sqlcode,
6524: p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,
6517: EXCEPTION
6518: WHEN OTHERS THEN
6519: -- store SQL error message on message stack
6520: OKC_API.SET_MESSAGE(p_app_name => okc_version_pvt.G_APP_NAME,
6521: p_msg_name => okc_version_pvt.G_UNEXPECTED_ERROR,
6522: p_token1 => okc_version_pvt.G_SQLCODE_TOKEN,
6523: p_token1_value => sqlcode,
6524: p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,
6525: p_token2_value => sqlerrm);
6518: WHEN OTHERS THEN
6519: -- store SQL error message on message stack
6520: OKC_API.SET_MESSAGE(p_app_name => okc_version_pvt.G_APP_NAME,
6521: p_msg_name => okc_version_pvt.G_UNEXPECTED_ERROR,
6522: p_token1 => okc_version_pvt.G_SQLCODE_TOKEN,
6523: p_token1_value => sqlcode,
6524: p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,
6525: p_token2_value => sqlerrm);
6526: -- notify UNEXPECTED error
6520: OKC_API.SET_MESSAGE(p_app_name => okc_version_pvt.G_APP_NAME,
6521: p_msg_name => okc_version_pvt.G_UNEXPECTED_ERROR,
6522: p_token1 => okc_version_pvt.G_SQLCODE_TOKEN,
6523: p_token1_value => sqlcode,
6524: p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,
6525: p_token2_value => sqlerrm);
6526: -- notify UNEXPECTED error
6527: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
6528: END populate_global_tab;
6596:
6597: EXCEPTION
6598: WHEN OTHERS THEN
6599: -- store SQL error message on message stack
6600: OKC_API.SET_MESSAGE(p_app_name => okc_version_pvt.G_APP_NAME,
6601: p_msg_name => okc_version_pvt.G_UNEXPECTED_ERROR,
6602: p_token1 => okc_version_pvt.G_SQLCODE_TOKEN,
6603: p_token1_value => sqlcode,
6604: p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,
6597: EXCEPTION
6598: WHEN OTHERS THEN
6599: -- store SQL error message on message stack
6600: OKC_API.SET_MESSAGE(p_app_name => okc_version_pvt.G_APP_NAME,
6601: p_msg_name => okc_version_pvt.G_UNEXPECTED_ERROR,
6602: p_token1 => okc_version_pvt.G_SQLCODE_TOKEN,
6603: p_token1_value => sqlcode,
6604: p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,
6605: p_token2_value => sqlerrm);
6598: WHEN OTHERS THEN
6599: -- store SQL error message on message stack
6600: OKC_API.SET_MESSAGE(p_app_name => okc_version_pvt.G_APP_NAME,
6601: p_msg_name => okc_version_pvt.G_UNEXPECTED_ERROR,
6602: p_token1 => okc_version_pvt.G_SQLCODE_TOKEN,
6603: p_token1_value => sqlcode,
6604: p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,
6605: p_token2_value => sqlerrm);
6606: -- notify UNEXPECTED error
6600: OKC_API.SET_MESSAGE(p_app_name => okc_version_pvt.G_APP_NAME,
6601: p_msg_name => okc_version_pvt.G_UNEXPECTED_ERROR,
6602: p_token1 => okc_version_pvt.G_SQLCODE_TOKEN,
6603: p_token1_value => sqlcode,
6604: p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,
6605: p_token2_value => sqlerrm);
6606: -- notify UNEXPECTED error
6607: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
6608: END populate_obj_global_tab;