265: NULL;
266:
267: WHEN OTHERS THEN
268: -- store SQL error message on message stack for caller
269: Okc_Api.SET_MESSAGE(p_app_name => Okl_Pdt_Pvt.g_app_name,
270: p_msg_name => Okl_Pdt_Pvt.g_unexpected_error,
271: p_token1 => Okl_Pdt_Pvt.g_sqlcode_token,
272: p_token1_value => SQLCODE,
273: p_token2 => Okl_Pdt_Pvt.g_sqlerrm_token,
266:
267: WHEN OTHERS THEN
268: -- store SQL error message on message stack for caller
269: Okc_Api.SET_MESSAGE(p_app_name => Okl_Pdt_Pvt.g_app_name,
270: p_msg_name => Okl_Pdt_Pvt.g_unexpected_error,
271: p_token1 => Okl_Pdt_Pvt.g_sqlcode_token,
272: p_token1_value => SQLCODE,
273: p_token2 => Okl_Pdt_Pvt.g_sqlerrm_token,
274: p_token2_value => SQLERRM);
267: WHEN OTHERS THEN
268: -- store SQL error message on message stack for caller
269: Okc_Api.SET_MESSAGE(p_app_name => Okl_Pdt_Pvt.g_app_name,
270: p_msg_name => Okl_Pdt_Pvt.g_unexpected_error,
271: p_token1 => Okl_Pdt_Pvt.g_sqlcode_token,
272: p_token1_value => SQLCODE,
273: p_token2 => Okl_Pdt_Pvt.g_sqlerrm_token,
274: p_token2_value => SQLERRM);
275:
269: Okc_Api.SET_MESSAGE(p_app_name => Okl_Pdt_Pvt.g_app_name,
270: p_msg_name => Okl_Pdt_Pvt.g_unexpected_error,
271: p_token1 => Okl_Pdt_Pvt.g_sqlcode_token,
272: p_token1_value => SQLCODE,
273: p_token2 => Okl_Pdt_Pvt.g_sqlerrm_token,
274: p_token2_value => SQLERRM);
275:
276: -- notify caller of an UNEXPECTED error
277: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;