3106: EXCEPTION
3107: -- other appropriate handlers
3108: WHEN OTHERS THEN
3109: -- store SQL error message on message stack
3110: OKC_API.SET_MESSAGE(p_app_name => okc_version_pvt.G_APP_NAME,
3111: p_msg_name => okc_version_pvt.G_UNEXPECTED_ERROR,
3112: p_token1 => okc_version_pvt.G_SQLCODE_TOKEN,
3113: p_token1_value => sqlcode,
3114: p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,
3107: -- other appropriate handlers
3108: WHEN OTHERS THEN
3109: -- store SQL error message on message stack
3110: OKC_API.SET_MESSAGE(p_app_name => okc_version_pvt.G_APP_NAME,
3111: p_msg_name => okc_version_pvt.G_UNEXPECTED_ERROR,
3112: p_token1 => okc_version_pvt.G_SQLCODE_TOKEN,
3113: p_token1_value => sqlcode,
3114: p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,
3115: p_token2_value => sqlerrm);
3108: WHEN OTHERS THEN
3109: -- store SQL error message on message stack
3110: OKC_API.SET_MESSAGE(p_app_name => okc_version_pvt.G_APP_NAME,
3111: p_msg_name => okc_version_pvt.G_UNEXPECTED_ERROR,
3112: p_token1 => okc_version_pvt.G_SQLCODE_TOKEN,
3113: p_token1_value => sqlcode,
3114: p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,
3115: p_token2_value => sqlerrm);
3116:
3110: OKC_API.SET_MESSAGE(p_app_name => okc_version_pvt.G_APP_NAME,
3111: p_msg_name => okc_version_pvt.G_UNEXPECTED_ERROR,
3112: p_token1 => okc_version_pvt.G_SQLCODE_TOKEN,
3113: p_token1_value => sqlcode,
3114: p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,
3115: p_token2_value => sqlerrm);
3116:
3117: -- notify UNEXPECTED error
3118: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
3196: EXCEPTION
3197: -- other appropriate handlers
3198: WHEN OTHERS THEN
3199: -- store SQL error message on message stack
3200: OKC_API.SET_MESSAGE(p_app_name => okc_version_pvt.G_APP_NAME,
3201: p_msg_name => okc_version_pvt.G_UNEXPECTED_ERROR,
3202: p_token1 => okc_version_pvt.G_SQLCODE_TOKEN,
3203: p_token1_value => sqlcode,
3204: p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,
3197: -- other appropriate handlers
3198: WHEN OTHERS THEN
3199: -- store SQL error message on message stack
3200: OKC_API.SET_MESSAGE(p_app_name => okc_version_pvt.G_APP_NAME,
3201: p_msg_name => okc_version_pvt.G_UNEXPECTED_ERROR,
3202: p_token1 => okc_version_pvt.G_SQLCODE_TOKEN,
3203: p_token1_value => sqlcode,
3204: p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,
3205: p_token2_value => sqlerrm);
3198: WHEN OTHERS THEN
3199: -- store SQL error message on message stack
3200: OKC_API.SET_MESSAGE(p_app_name => okc_version_pvt.G_APP_NAME,
3201: p_msg_name => okc_version_pvt.G_UNEXPECTED_ERROR,
3202: p_token1 => okc_version_pvt.G_SQLCODE_TOKEN,
3203: p_token1_value => sqlcode,
3204: p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,
3205: p_token2_value => sqlerrm);
3206:
3200: OKC_API.SET_MESSAGE(p_app_name => okc_version_pvt.G_APP_NAME,
3201: p_msg_name => okc_version_pvt.G_UNEXPECTED_ERROR,
3202: p_token1 => okc_version_pvt.G_SQLCODE_TOKEN,
3203: p_token1_value => sqlcode,
3204: p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,
3205: p_token2_value => sqlerrm);
3206:
3207: -- notify UNEXPECTED error
3208: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;