APPS.OKL_SETUPDQUALITYS_PVT dependencies on OKL_PDQ_PVT

Line 250: ---Okl_Api.set_message(Okl_Pdq_Pvt.G_APP_NAME,Okl_Pdq_Pvt.G_UNQS,Okl_Pdq_Pvt.G_TABLE_TOKEN, l_token_1); ---CHG001

246: l_row_found := c1%FOUND;
247:
248: CLOSE c1;
249: IF l_row_found THEN
250: ---Okl_Api.set_message(Okl_Pdq_Pvt.G_APP_NAME,Okl_Pdq_Pvt.G_UNQS,Okl_Pdq_Pvt.G_TABLE_TOKEN, l_token_1); ---CHG001
251: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
252: p_msg_name => 'OKL_COLUMN_NOT_UNIQUE',
253: p_token1 => G_TABLE_TOKEN,
254: p_token1_value => l_token_1,

Line 463: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pdq_Pvt.g_app_name

459: BEGIN
460: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSDQB.pls call Okl_Api.SET_MESSAGE ');
461: END;
462: END IF;
463: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pdq_Pvt.g_app_name
464: ,p_msg_name => Okl_Pdq_Pvt.g_required_value
465: ,p_token1 => Okl_Pdq_Pvt.g_col_name_token
466: ,p_token1_value => l_token_1);
467: IF(IS_DEBUG_PROCEDURE_ON) THEN

Line 464: ,p_msg_name => Okl_Pdq_Pvt.g_required_value

460: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSDQB.pls call Okl_Api.SET_MESSAGE ');
461: END;
462: END IF;
463: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pdq_Pvt.g_app_name
464: ,p_msg_name => Okl_Pdq_Pvt.g_required_value
465: ,p_token1 => Okl_Pdq_Pvt.g_col_name_token
466: ,p_token1_value => l_token_1);
467: IF(IS_DEBUG_PROCEDURE_ON) THEN
468: BEGIN

Line 465: ,p_token1 => Okl_Pdq_Pvt.g_col_name_token

461: END;
462: END IF;
463: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pdq_Pvt.g_app_name
464: ,p_msg_name => Okl_Pdq_Pvt.g_required_value
465: ,p_token1 => Okl_Pdq_Pvt.g_col_name_token
466: ,p_token1_value => l_token_1);
467: IF(IS_DEBUG_PROCEDURE_ON) THEN
468: BEGIN
469: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSDQB.pls call Okl_Api.SET_MESSAGE ');

Line 491: Okl_Api.set_message(Okl_Pdq_Pvt.G_APP_NAME, Okl_Pdq_Pvt.G_INVALID_VALUE,Okl_Pdq_Pvt.G_COL_NAME_TOKEN,l_token_1);

487: BEGIN
488: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSDQB.pls call Okl_Api.set_message ');
489: END;
490: END IF;
491: Okl_Api.set_message(Okl_Pdq_Pvt.G_APP_NAME, Okl_Pdq_Pvt.G_INVALID_VALUE,Okl_Pdq_Pvt.G_COL_NAME_TOKEN,l_token_1);
492: IF(IS_DEBUG_PROCEDURE_ON) THEN
493: BEGIN
494: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSDQB.pls call Okl_Api.set_message ');
495: END;

Line 512: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pdq_Pvt.g_app_name,

508: x_return_status := Okc_Api.G_RET_STS_ERROR;
509:
510: WHEN OTHERS THEN
511: -- store SQL error message on message stack for caller
512: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pdq_Pvt.g_app_name,
513: p_msg_name => Okl_Pdq_Pvt.g_unexpected_error,
514: p_token1 => Okl_Pdq_Pvt.g_sqlcode_token,
515: p_token1_value => SQLCODE,
516: p_token2 => Okl_Pdq_Pvt.g_sqlerrm_token,

Line 513: p_msg_name => Okl_Pdq_Pvt.g_unexpected_error,

509:
510: WHEN OTHERS THEN
511: -- store SQL error message on message stack for caller
512: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pdq_Pvt.g_app_name,
513: p_msg_name => Okl_Pdq_Pvt.g_unexpected_error,
514: p_token1 => Okl_Pdq_Pvt.g_sqlcode_token,
515: p_token1_value => SQLCODE,
516: p_token2 => Okl_Pdq_Pvt.g_sqlerrm_token,
517: p_token2_value => SQLERRM);

Line 514: p_token1 => Okl_Pdq_Pvt.g_sqlcode_token,

510: WHEN OTHERS THEN
511: -- store SQL error message on message stack for caller
512: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pdq_Pvt.g_app_name,
513: p_msg_name => Okl_Pdq_Pvt.g_unexpected_error,
514: p_token1 => Okl_Pdq_Pvt.g_sqlcode_token,
515: p_token1_value => SQLCODE,
516: p_token2 => Okl_Pdq_Pvt.g_sqlerrm_token,
517: p_token2_value => SQLERRM);
518:

Line 516: p_token2 => Okl_Pdq_Pvt.g_sqlerrm_token,

512: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pdq_Pvt.g_app_name,
513: p_msg_name => Okl_Pdq_Pvt.g_unexpected_error,
514: p_token1 => Okl_Pdq_Pvt.g_sqlcode_token,
515: p_token1_value => SQLCODE,
516: p_token2 => Okl_Pdq_Pvt.g_sqlerrm_token,
517: p_token2_value => SQLERRM);
518:
519: -- notify caller of an UNEXPECTED error
520: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

Line 565: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pdq_Pvt.g_app_name,

561: RETURN (l_return_status);
562:
563: WHEN OTHERS THEN
564: -- store SQL error message on message stack for caller
565: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pdq_Pvt.g_app_name,
566: p_msg_name => Okl_Pdq_Pvt.g_unexpected_error,
567: p_token1 => Okl_Pdq_Pvt.g_sqlcode_token,
568: p_token1_value => SQLCODE,
569: p_token2 => Okl_Pdq_Pvt.g_sqlerrm_token,

Line 566: p_msg_name => Okl_Pdq_Pvt.g_unexpected_error,

562:
563: WHEN OTHERS THEN
564: -- store SQL error message on message stack for caller
565: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pdq_Pvt.g_app_name,
566: p_msg_name => Okl_Pdq_Pvt.g_unexpected_error,
567: p_token1 => Okl_Pdq_Pvt.g_sqlcode_token,
568: p_token1_value => SQLCODE,
569: p_token2 => Okl_Pdq_Pvt.g_sqlerrm_token,
570: p_token2_value => SQLERRM);

Line 567: p_token1 => Okl_Pdq_Pvt.g_sqlcode_token,

563: WHEN OTHERS THEN
564: -- store SQL error message on message stack for caller
565: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pdq_Pvt.g_app_name,
566: p_msg_name => Okl_Pdq_Pvt.g_unexpected_error,
567: p_token1 => Okl_Pdq_Pvt.g_sqlcode_token,
568: p_token1_value => SQLCODE,
569: p_token2 => Okl_Pdq_Pvt.g_sqlerrm_token,
570: p_token2_value => SQLERRM);
571: -- notify caller of an UNEXPECTED error

Line 569: p_token2 => Okl_Pdq_Pvt.g_sqlerrm_token,

565: Okl_Api.SET_MESSAGE(p_app_name => Okl_Pdq_Pvt.g_app_name,
566: p_msg_name => Okl_Pdq_Pvt.g_unexpected_error,
567: p_token1 => Okl_Pdq_Pvt.g_sqlcode_token,
568: p_token1_value => SQLCODE,
569: p_token2 => Okl_Pdq_Pvt.g_sqlerrm_token,
570: p_token2_value => SQLERRM);
571: -- notify caller of an UNEXPECTED error
572: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
573: RETURN(l_return_status);