DBA Data[Home] [Help]

APPS.OKL_SETUPOPTRULES_PVT dependencies on OKL_ORL_PVT

Line 379: Okl_Api.SET_MESSAGE(p_app_name => Okl_Orl_Pvt.g_app_name

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;

Line 380: ,p_msg_name => Okl_Orl_Pvt.g_required_value

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;

Line 381: ,p_token1 => Okl_Orl_Pvt.g_col_name_token

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;

Line 395: Okl_Api.SET_MESSAGE(p_app_name => Okl_Orl_Pvt.g_app_name,

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,

Line 396: p_msg_name => Okl_Orl_Pvt.g_unexpected_error,

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);

Line 397: p_token1 => Okl_Orl_Pvt.g_sqlcode_token,

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:

Line 399: p_token2 => Okl_Orl_Pvt.g_sqlerrm_token,

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;

Line 446: Okl_Api.SET_MESSAGE(p_app_name => Okl_Orl_Pvt.g_app_name,

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,

Line 447: p_msg_name => Okl_Orl_Pvt.g_unexpected_error,

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);

Line 448: p_token1 => Okl_Orl_Pvt.g_sqlcode_token,

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

Line 450: p_token2 => Okl_Orl_Pvt.g_sqlerrm_token,

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);