375:
376: -- check for data before processing
377: IF (p_orlv_rec.rgr_rdf_code IS NULL) OR
378: (p_orlv_rec.rgr_rdf_code = Okl_Api.G_MISS_CHAR) THEN
379: Okl_Api.SET_MESSAGE(p_app_name => Okl_Orl_Pvt.g_app_name
380: ,p_msg_name => Okl_Orl_Pvt.g_required_value
381: ,p_token1 => Okl_Orl_Pvt.g_col_name_token
382: ,p_token1_value => l_token_1);
383: x_return_status := Okl_Api.G_RET_STS_ERROR;
376: -- check for data before processing
377: IF (p_orlv_rec.rgr_rdf_code IS NULL) OR
378: (p_orlv_rec.rgr_rdf_code = Okl_Api.G_MISS_CHAR) THEN
379: Okl_Api.SET_MESSAGE(p_app_name => Okl_Orl_Pvt.g_app_name
380: ,p_msg_name => Okl_Orl_Pvt.g_required_value
381: ,p_token1 => Okl_Orl_Pvt.g_col_name_token
382: ,p_token1_value => l_token_1);
383: x_return_status := Okl_Api.G_RET_STS_ERROR;
384: RAISE G_EXCEPTION_HALT_PROCESSING;
377: IF (p_orlv_rec.rgr_rdf_code IS NULL) OR
378: (p_orlv_rec.rgr_rdf_code = Okl_Api.G_MISS_CHAR) THEN
379: Okl_Api.SET_MESSAGE(p_app_name => Okl_Orl_Pvt.g_app_name
380: ,p_msg_name => Okl_Orl_Pvt.g_required_value
381: ,p_token1 => Okl_Orl_Pvt.g_col_name_token
382: ,p_token1_value => l_token_1);
383: x_return_status := Okl_Api.G_RET_STS_ERROR;
384: RAISE G_EXCEPTION_HALT_PROCESSING;
385: END IF;
391: NULL;
392:
393: WHEN OTHERS THEN
394: -- store SQL error message on message stack for caller
395: Okl_Api.SET_MESSAGE(p_app_name => Okl_Orl_Pvt.g_app_name,
396: p_msg_name => Okl_Orl_Pvt.g_unexpected_error,
397: p_token1 => Okl_Orl_Pvt.g_sqlcode_token,
398: p_token1_value => SQLCODE,
399: p_token2 => Okl_Orl_Pvt.g_sqlerrm_token,
392:
393: WHEN OTHERS THEN
394: -- store SQL error message on message stack for caller
395: Okl_Api.SET_MESSAGE(p_app_name => Okl_Orl_Pvt.g_app_name,
396: p_msg_name => Okl_Orl_Pvt.g_unexpected_error,
397: p_token1 => Okl_Orl_Pvt.g_sqlcode_token,
398: p_token1_value => SQLCODE,
399: p_token2 => Okl_Orl_Pvt.g_sqlerrm_token,
400: p_token2_value => SQLERRM);
393: WHEN OTHERS THEN
394: -- store SQL error message on message stack for caller
395: Okl_Api.SET_MESSAGE(p_app_name => Okl_Orl_Pvt.g_app_name,
396: p_msg_name => Okl_Orl_Pvt.g_unexpected_error,
397: p_token1 => Okl_Orl_Pvt.g_sqlcode_token,
398: p_token1_value => SQLCODE,
399: p_token2 => Okl_Orl_Pvt.g_sqlerrm_token,
400: p_token2_value => SQLERRM);
401:
395: Okl_Api.SET_MESSAGE(p_app_name => Okl_Orl_Pvt.g_app_name,
396: p_msg_name => Okl_Orl_Pvt.g_unexpected_error,
397: p_token1 => Okl_Orl_Pvt.g_sqlcode_token,
398: p_token1_value => SQLCODE,
399: p_token2 => Okl_Orl_Pvt.g_sqlerrm_token,
400: p_token2_value => SQLERRM);
401:
402: -- notify caller of an UNEXPECTED error
403: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
442: RETURN (l_return_status);
443:
444: WHEN OTHERS THEN
445: -- store SQL error message on message stack for caller
446: Okl_Api.SET_MESSAGE(p_app_name => Okl_Orl_Pvt.g_app_name,
447: p_msg_name => Okl_Orl_Pvt.g_unexpected_error,
448: p_token1 => Okl_Orl_Pvt.g_sqlcode_token,
449: p_token1_value => SQLCODE,
450: p_token2 => Okl_Orl_Pvt.g_sqlerrm_token,
443:
444: WHEN OTHERS THEN
445: -- store SQL error message on message stack for caller
446: Okl_Api.SET_MESSAGE(p_app_name => Okl_Orl_Pvt.g_app_name,
447: p_msg_name => Okl_Orl_Pvt.g_unexpected_error,
448: p_token1 => Okl_Orl_Pvt.g_sqlcode_token,
449: p_token1_value => SQLCODE,
450: p_token2 => Okl_Orl_Pvt.g_sqlerrm_token,
451: p_token2_value => SQLERRM);
444: WHEN OTHERS THEN
445: -- store SQL error message on message stack for caller
446: Okl_Api.SET_MESSAGE(p_app_name => Okl_Orl_Pvt.g_app_name,
447: p_msg_name => Okl_Orl_Pvt.g_unexpected_error,
448: p_token1 => Okl_Orl_Pvt.g_sqlcode_token,
449: p_token1_value => SQLCODE,
450: p_token2 => Okl_Orl_Pvt.g_sqlerrm_token,
451: p_token2_value => SQLERRM);
452: -- notify caller of an UNEXPECTED error
446: Okl_Api.SET_MESSAGE(p_app_name => Okl_Orl_Pvt.g_app_name,
447: p_msg_name => Okl_Orl_Pvt.g_unexpected_error,
448: p_token1 => Okl_Orl_Pvt.g_sqlcode_token,
449: p_token1_value => SQLCODE,
450: p_token2 => Okl_Orl_Pvt.g_sqlerrm_token,
451: p_token2_value => SQLERRM);
452: -- notify caller of an UNEXPECTED error
453: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
454: RETURN(l_return_status);