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 OKL_OVE_PVT

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 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 513: p_msg_name =>Okl_Ove_Pvt.G_UNEXPECTED_ERROR,

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,
517: p_token2_value =>SQLERRM);

Line 514: p_token1 =>Okl_Ove_Pvt.G_SQL_SQLCODE_TOKEN,

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,
517: p_token2_value =>SQLERRM);
518: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;

Line 516: p_token2 =>Okl_Ove_Pvt.G_SQL_SQLERRM_TOKEN,

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,
517: p_token2_value =>SQLERRM);
518: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
519:
520: END Validate_Value;

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

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);
549: x_return_status := Okl_Api.G_RET_STS_ERROR;
550: END IF;
551: EXCEPTION
552: WHEN OTHERS THEN

Line 553: Okl_Api.set_message(p_app_name =>Okl_Ove_Pvt.G_APP_NAME,

549: x_return_status := Okl_Api.G_RET_STS_ERROR;
550: END IF;
551: EXCEPTION
552: WHEN OTHERS THEN
553: Okl_Api.set_message(p_app_name =>Okl_Ove_Pvt.G_APP_NAME,
554: p_msg_name =>Okl_Ove_Pvt.G_UNEXPECTED_ERROR,
555: p_token1 =>Okl_Ove_Pvt.G_SQL_SQLCODE_TOKEN,
556: p_token1_value =>SQLCODE,
557: p_token2 =>Okl_Ove_Pvt.G_SQL_SQLERRM_TOKEN,

Line 554: p_msg_name =>Okl_Ove_Pvt.G_UNEXPECTED_ERROR,

550: END IF;
551: EXCEPTION
552: WHEN OTHERS THEN
553: Okl_Api.set_message(p_app_name =>Okl_Ove_Pvt.G_APP_NAME,
554: p_msg_name =>Okl_Ove_Pvt.G_UNEXPECTED_ERROR,
555: p_token1 =>Okl_Ove_Pvt.G_SQL_SQLCODE_TOKEN,
556: p_token1_value =>SQLCODE,
557: p_token2 =>Okl_Ove_Pvt.G_SQL_SQLERRM_TOKEN,
558: p_token2_value =>SQLERRM);

Line 555: p_token1 =>Okl_Ove_Pvt.G_SQL_SQLCODE_TOKEN,

551: EXCEPTION
552: WHEN OTHERS THEN
553: Okl_Api.set_message(p_app_name =>Okl_Ove_Pvt.G_APP_NAME,
554: p_msg_name =>Okl_Ove_Pvt.G_UNEXPECTED_ERROR,
555: p_token1 =>Okl_Ove_Pvt.G_SQL_SQLCODE_TOKEN,
556: p_token1_value =>SQLCODE,
557: p_token2 =>Okl_Ove_Pvt.G_SQL_SQLERRM_TOKEN,
558: p_token2_value =>SQLERRM);
559: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

Line 557: p_token2 =>Okl_Ove_Pvt.G_SQL_SQLERRM_TOKEN,

553: Okl_Api.set_message(p_app_name =>Okl_Ove_Pvt.G_APP_NAME,
554: p_msg_name =>Okl_Ove_Pvt.G_UNEXPECTED_ERROR,
555: p_token1 =>Okl_Ove_Pvt.G_SQL_SQLCODE_TOKEN,
556: p_token1_value =>SQLCODE,
557: p_token2 =>Okl_Ove_Pvt.G_SQL_SQLERRM_TOKEN,
558: p_token2_value =>SQLERRM);
559: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
560:
561: END Validate_From_Date;

Line 621: Okl_Api.set_message(p_app_name =>Okl_Ove_Pvt.G_APP_NAME,

617: NULL;
618: RETURN (l_return_status);
619:
620: WHEN OTHERS THEN
621: Okl_Api.set_message(p_app_name =>Okl_Ove_Pvt.G_APP_NAME,
622: p_msg_name =>Okl_Ove_Pvt.G_UNEXPECTED_ERROR,
623: p_token1 =>Okl_Ove_Pvt.G_SQL_SQLCODE_TOKEN,
624: p_token1_value =>SQLCODE,
625: p_token2 =>Okl_Ove_Pvt.G_SQL_SQLERRM_TOKEN,

Line 622: p_msg_name =>Okl_Ove_Pvt.G_UNEXPECTED_ERROR,

618: RETURN (l_return_status);
619:
620: WHEN OTHERS THEN
621: Okl_Api.set_message(p_app_name =>Okl_Ove_Pvt.G_APP_NAME,
622: p_msg_name =>Okl_Ove_Pvt.G_UNEXPECTED_ERROR,
623: p_token1 =>Okl_Ove_Pvt.G_SQL_SQLCODE_TOKEN,
624: p_token1_value =>SQLCODE,
625: p_token2 =>Okl_Ove_Pvt.G_SQL_SQLERRM_TOKEN,
626: p_token2_value =>SQLERRM);

Line 623: p_token1 =>Okl_Ove_Pvt.G_SQL_SQLCODE_TOKEN,

619:
620: WHEN OTHERS THEN
621: Okl_Api.set_message(p_app_name =>Okl_Ove_Pvt.G_APP_NAME,
622: p_msg_name =>Okl_Ove_Pvt.G_UNEXPECTED_ERROR,
623: p_token1 =>Okl_Ove_Pvt.G_SQL_SQLCODE_TOKEN,
624: p_token1_value =>SQLCODE,
625: p_token2 =>Okl_Ove_Pvt.G_SQL_SQLERRM_TOKEN,
626: p_token2_value =>SQLERRM);
627: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

Line 625: p_token2 =>Okl_Ove_Pvt.G_SQL_SQLERRM_TOKEN,

621: Okl_Api.set_message(p_app_name =>Okl_Ove_Pvt.G_APP_NAME,
622: p_msg_name =>Okl_Ove_Pvt.G_UNEXPECTED_ERROR,
623: p_token1 =>Okl_Ove_Pvt.G_SQL_SQLCODE_TOKEN,
624: p_token1_value =>SQLCODE,
625: p_token2 =>Okl_Ove_Pvt.G_SQL_SQLERRM_TOKEN,
626: p_token2_value =>SQLERRM);
627: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
628: RETURN(l_return_status);
629:

Line 1230: ,p_msg_name => Okl_Ove_Pvt.g_to_date_error

1226:
1227: /* To Check end date is > start date*/
1228: IF (l_upd_ovev_rec.TO_DATE IS NOT NULL) AND (l_upd_ovev_rec.TO_DATE < l_upd_ovev_rec.from_date) THEN
1229: Okl_Api.SET_MESSAGE(p_app_name => g_app_name
1230: ,p_msg_name => Okl_Ove_Pvt.g_to_date_error
1231: ,p_token1 => Okl_Ove_Pvt.g_col_name_token
1232: ,p_token1_value => 'TO_DATE');
1233: x_return_status := Okl_Api.G_RET_STS_ERROR;
1234: RAISE Okl_Api.G_EXCEPTION_ERROR;

Line 1231: ,p_token1 => Okl_Ove_Pvt.g_col_name_token

1227: /* To Check end date is > start date*/
1228: IF (l_upd_ovev_rec.TO_DATE IS NOT NULL) AND (l_upd_ovev_rec.TO_DATE < l_upd_ovev_rec.from_date) THEN
1229: Okl_Api.SET_MESSAGE(p_app_name => g_app_name
1230: ,p_msg_name => Okl_Ove_Pvt.g_to_date_error
1231: ,p_token1 => Okl_Ove_Pvt.g_col_name_token
1232: ,p_token1_value => 'TO_DATE');
1233: x_return_status := Okl_Api.G_RET_STS_ERROR;
1234: RAISE Okl_Api.G_EXCEPTION_ERROR;
1235: END IF;