eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_SETUPOPTVALUES_PVT dependencies on OKC_API

Line 496: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

492: PROCEDURE Validate_Value (
493: p_ovev_rec IN OUT NOCOPY ovev_rec_type,
494: x_return_status OUT NOCOPY VARCHAR2
495: ) IS
496: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
497: l_token_1 VARCHAR2(1999);
498: BEGIN
499: -- initialize return status
500: x_return_status := Okc_Api.G_RET_STS_SUCCESS;

Line 500: x_return_status := Okc_Api.G_RET_STS_SUCCESS;

496: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
497: l_token_1 VARCHAR2(1999);
498: BEGIN
499: -- initialize return status
500: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
501:
502: l_token_1 := Okl_Accounting_Util.Get_Message_Token('OKL_LP_OPTVAL_CRUPD','OKL_NAME');
503: IF p_ovev_rec.value = Okc_Api.G_MISS_CHAR OR
504: p_ovev_rec.value IS NULL

Line 503: IF p_ovev_rec.value = Okc_Api.G_MISS_CHAR OR

499: -- initialize return status
500: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
501:
502: l_token_1 := Okl_Accounting_Util.Get_Message_Token('OKL_LP_OPTVAL_CRUPD','OKL_NAME');
503: IF p_ovev_rec.value = Okc_Api.G_MISS_CHAR OR
504: p_ovev_rec.value IS NULL
505: THEN
506: Okc_Api.set_message(Okl_Ove_Pvt.G_APP_NAME, Okl_Ove_Pvt.G_REQUIRED_VALUE,Okl_Ove_Pvt.G_COL_NAME_TOKEN,l_token_1);
507: x_return_status := Okc_Api.G_RET_STS_ERROR;

Line 506: Okc_Api.set_message(Okl_Ove_Pvt.G_APP_NAME, Okl_Ove_Pvt.G_REQUIRED_VALUE,Okl_Ove_Pvt.G_COL_NAME_TOKEN,l_token_1);

502: l_token_1 := Okl_Accounting_Util.Get_Message_Token('OKL_LP_OPTVAL_CRUPD','OKL_NAME');
503: IF p_ovev_rec.value = Okc_Api.G_MISS_CHAR OR
504: p_ovev_rec.value IS NULL
505: THEN
506: Okc_Api.set_message(Okl_Ove_Pvt.G_APP_NAME, Okl_Ove_Pvt.G_REQUIRED_VALUE,Okl_Ove_Pvt.G_COL_NAME_TOKEN,l_token_1);
507: x_return_status := Okc_Api.G_RET_STS_ERROR;
508: END IF;
509: p_ovev_rec.value := Okl_Accounting_Util.okl_upper(p_ovev_rec.value);
510: EXCEPTION

Line 507: x_return_status := Okc_Api.G_RET_STS_ERROR;

503: IF p_ovev_rec.value = Okc_Api.G_MISS_CHAR OR
504: p_ovev_rec.value IS NULL
505: THEN
506: Okc_Api.set_message(Okl_Ove_Pvt.G_APP_NAME, Okl_Ove_Pvt.G_REQUIRED_VALUE,Okl_Ove_Pvt.G_COL_NAME_TOKEN,l_token_1);
507: x_return_status := Okc_Api.G_RET_STS_ERROR;
508: END IF;
509: p_ovev_rec.value := Okl_Accounting_Util.okl_upper(p_ovev_rec.value);
510: EXCEPTION
511: WHEN OTHERS THEN

Line 512: Okc_Api.set_message(p_app_name =>Okl_Ove_Pvt.G_APP_NAME,

508: END IF;
509: p_ovev_rec.value := Okl_Accounting_Util.okl_upper(p_ovev_rec.value);
510: EXCEPTION
511: WHEN OTHERS THEN
512: Okc_Api.set_message(p_app_name =>Okl_Ove_Pvt.G_APP_NAME,
513: p_msg_name =>Okl_Ove_Pvt.G_UNEXPECTED_ERROR,
514: p_token1 =>Okl_Ove_Pvt.G_SQL_SQLCODE_TOKEN,
515: p_token1_value =>SQLCODE,
516: p_token2 =>Okl_Ove_Pvt.G_SQL_SQLERRM_TOKEN,

Line 518: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;

514: p_token1 =>Okl_Ove_Pvt.G_SQL_SQLCODE_TOKEN,
515: p_token1_value =>SQLCODE,
516: p_token2 =>Okl_Ove_Pvt.G_SQL_SQLERRM_TOKEN,
517: p_token2_value =>SQLERRM);
518: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
519:
520: END Validate_Value;
521: ------end of Validate_Value-----------------------------------
522:

Line 540: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

536: PROCEDURE Validate_From_Date(
537: p_ovev_rec IN ovev_rec_type,
538: x_return_status OUT NOCOPY VARCHAR2
539: ) IS
540: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
541: l_token_1 VARCHAR2(999);
542: BEGIN
543: -- initialize return status
544: x_return_status := Okc_Api.G_RET_STS_SUCCESS;

Line 544: x_return_status := Okc_Api.G_RET_STS_SUCCESS;

540: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
541: l_token_1 VARCHAR2(999);
542: BEGIN
543: -- initialize return status
544: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
545: l_token_1 := Okl_Accounting_Util.Get_Message_Token('OKL_LP_OPTVAL_CRUPD','OKL_EFFECTIVE_FROM');
546: IF p_ovev_rec.from_date IS NULL OR p_ovev_rec.from_date = Okl_Api.G_MISS_DATE
547: THEN
548: Okl_Api.set_message(Okl_Ove_Pvt.G_APP_NAME, Okl_Ove_Pvt.G_REQUIRED_VALUE,Okl_Ove_Pvt.G_COL_NAME_TOKEN,l_token_1);