6702: EXCEPTION
6703: -- other appropriate handlers
6704: WHEN OTHERS THEN
6705: -- store SQL error message on message stack
6706: OKC_API.SET_MESSAGE(p_app_name => okc_version_pvt.G_APP_NAME,
6707: p_msg_name => okc_version_pvt.G_UNEXPECTED_ERROR,
6708: p_token1 => okc_version_pvt.G_SQLCODE_TOKEN,
6709: p_token1_value => sqlcode,
6710: p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,
6703: -- other appropriate handlers
6704: WHEN OTHERS THEN
6705: -- store SQL error message on message stack
6706: OKC_API.SET_MESSAGE(p_app_name => okc_version_pvt.G_APP_NAME,
6707: p_msg_name => okc_version_pvt.G_UNEXPECTED_ERROR,
6708: p_token1 => okc_version_pvt.G_SQLCODE_TOKEN,
6709: p_token1_value => sqlcode,
6710: p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,
6711: p_token2_value => sqlerrm);
6704: WHEN OTHERS THEN
6705: -- store SQL error message on message stack
6706: OKC_API.SET_MESSAGE(p_app_name => okc_version_pvt.G_APP_NAME,
6707: p_msg_name => okc_version_pvt.G_UNEXPECTED_ERROR,
6708: p_token1 => okc_version_pvt.G_SQLCODE_TOKEN,
6709: p_token1_value => sqlcode,
6710: p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,
6711: p_token2_value => sqlerrm);
6712:
6706: OKC_API.SET_MESSAGE(p_app_name => okc_version_pvt.G_APP_NAME,
6707: p_msg_name => okc_version_pvt.G_UNEXPECTED_ERROR,
6708: p_token1 => okc_version_pvt.G_SQLCODE_TOKEN,
6709: p_token1_value => sqlcode,
6710: p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,
6711: p_token2_value => sqlerrm);
6712:
6713: -- notify UNEXPECTED error
6714: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
7024: EXCEPTION
7025: -- other appropriate handlers
7026: WHEN OTHERS THEN
7027: -- store SQL error message on message stack
7028: OKC_API.SET_MESSAGE(p_app_name => okc_version_pvt.G_APP_NAME,
7029: p_msg_name => okc_version_pvt.G_UNEXPECTED_ERROR,
7030: p_token1 => okc_version_pvt.G_SQLCODE_TOKEN,
7031: p_token1_value => sqlcode,
7032: p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,
7025: -- other appropriate handlers
7026: WHEN OTHERS THEN
7027: -- store SQL error message on message stack
7028: OKC_API.SET_MESSAGE(p_app_name => okc_version_pvt.G_APP_NAME,
7029: p_msg_name => okc_version_pvt.G_UNEXPECTED_ERROR,
7030: p_token1 => okc_version_pvt.G_SQLCODE_TOKEN,
7031: p_token1_value => sqlcode,
7032: p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,
7033: p_token2_value => sqlerrm);
7026: WHEN OTHERS THEN
7027: -- store SQL error message on message stack
7028: OKC_API.SET_MESSAGE(p_app_name => okc_version_pvt.G_APP_NAME,
7029: p_msg_name => okc_version_pvt.G_UNEXPECTED_ERROR,
7030: p_token1 => okc_version_pvt.G_SQLCODE_TOKEN,
7031: p_token1_value => sqlcode,
7032: p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,
7033: p_token2_value => sqlerrm);
7034:
7028: OKC_API.SET_MESSAGE(p_app_name => okc_version_pvt.G_APP_NAME,
7029: p_msg_name => okc_version_pvt.G_UNEXPECTED_ERROR,
7030: p_token1 => okc_version_pvt.G_SQLCODE_TOKEN,
7031: p_token1_value => sqlcode,
7032: p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,
7033: p_token2_value => sqlerrm);
7034:
7035: -- notify UNEXPECTED error
7036: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;