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_SETUPOPTIONS_PVT dependencies on OKL_OPT_PVT

Line 361: Okl_Api.set_message(Okl_Opt_Pvt.G_APP_NAME, Okl_Opt_Pvt.G_REQUIRED_VALUE,Okl_Opt_Pvt.G_COL_NAME_TOKEN,l_token_1);

357: l_token_1 := Okl_Accounting_Util.Get_Message_Token('OKL_LP_OPTION_CRUPD','OKL_NAME');
358: IF p_optv_rec.name = Okl_Api.G_MISS_CHAR OR
359: p_optv_rec.name IS NULL
360: THEN
361: Okl_Api.set_message(Okl_Opt_Pvt.G_APP_NAME, Okl_Opt_Pvt.G_REQUIRED_VALUE,Okl_Opt_Pvt.G_COL_NAME_TOKEN,l_token_1);
362: x_return_status := Okl_Api.G_RET_STS_ERROR;
363: END IF;
364: p_optv_rec.name := Okl_Accounting_Util.okl_upper(p_optv_rec.name);
365: EXCEPTION

Line 367: Okl_Api.set_message(p_app_name =>Okl_Opt_Pvt.G_APP_NAME,

363: END IF;
364: p_optv_rec.name := Okl_Accounting_Util.okl_upper(p_optv_rec.name);
365: EXCEPTION
366: WHEN OTHERS THEN
367: Okl_Api.set_message(p_app_name =>Okl_Opt_Pvt.G_APP_NAME,
368: p_msg_name =>Okl_Opt_Pvt.G_UNEXPECTED_ERROR,
369: p_token1 =>Okl_Opt_Pvt.G_SQL_SQLCODE_TOKEN,
370: p_token1_value =>SQLCODE,
371: p_token2 =>Okl_Opt_Pvt.G_SQL_SQLERRM_TOKEN,

Line 368: p_msg_name =>Okl_Opt_Pvt.G_UNEXPECTED_ERROR,

364: p_optv_rec.name := Okl_Accounting_Util.okl_upper(p_optv_rec.name);
365: EXCEPTION
366: WHEN OTHERS THEN
367: Okl_Api.set_message(p_app_name =>Okl_Opt_Pvt.G_APP_NAME,
368: p_msg_name =>Okl_Opt_Pvt.G_UNEXPECTED_ERROR,
369: p_token1 =>Okl_Opt_Pvt.G_SQL_SQLCODE_TOKEN,
370: p_token1_value =>SQLCODE,
371: p_token2 =>Okl_Opt_Pvt.G_SQL_SQLERRM_TOKEN,
372: p_token2_value =>SQLERRM);

Line 369: p_token1 =>Okl_Opt_Pvt.G_SQL_SQLCODE_TOKEN,

365: EXCEPTION
366: WHEN OTHERS THEN
367: Okl_Api.set_message(p_app_name =>Okl_Opt_Pvt.G_APP_NAME,
368: p_msg_name =>Okl_Opt_Pvt.G_UNEXPECTED_ERROR,
369: p_token1 =>Okl_Opt_Pvt.G_SQL_SQLCODE_TOKEN,
370: p_token1_value =>SQLCODE,
371: p_token2 =>Okl_Opt_Pvt.G_SQL_SQLERRM_TOKEN,
372: p_token2_value =>SQLERRM);
373: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

Line 371: p_token2 =>Okl_Opt_Pvt.G_SQL_SQLERRM_TOKEN,

367: Okl_Api.set_message(p_app_name =>Okl_Opt_Pvt.G_APP_NAME,
368: p_msg_name =>Okl_Opt_Pvt.G_UNEXPECTED_ERROR,
369: p_token1 =>Okl_Opt_Pvt.G_SQL_SQLCODE_TOKEN,
370: p_token1_value =>SQLCODE,
371: p_token2 =>Okl_Opt_Pvt.G_SQL_SQLERRM_TOKEN,
372: p_token2_value =>SQLERRM);
373: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
374:
375: END Validate_Name;

Line 400: Okl_Api.set_message(Okl_Opt_Pvt.G_APP_NAME, Okl_Opt_Pvt.G_REQUIRED_VALUE,Okl_Opt_Pvt.G_COL_NAME_TOKEN,l_token_1);

396: BEGIN
397: l_token_1 := Okl_Accounting_Util.Get_Message_Token('OKL_LP_OPTION_CRUPD','OKL_EFFECTIVE_FROM');
398: IF p_optv_rec.from_date IS NULL OR p_optv_rec.from_date = Okl_Api.G_MISS_DATE
399: THEN
400: Okl_Api.set_message(Okl_Opt_Pvt.G_APP_NAME, Okl_Opt_Pvt.G_REQUIRED_VALUE,Okl_Opt_Pvt.G_COL_NAME_TOKEN,l_token_1);
401: x_return_status := Okl_Api.G_RET_STS_ERROR;
402: END IF;
403: EXCEPTION
404: WHEN OTHERS THEN

Line 405: Okl_Api.set_message(p_app_name =>Okl_Opt_Pvt.G_APP_NAME,

401: x_return_status := Okl_Api.G_RET_STS_ERROR;
402: END IF;
403: EXCEPTION
404: WHEN OTHERS THEN
405: Okl_Api.set_message(p_app_name =>Okl_Opt_Pvt.G_APP_NAME,
406: p_msg_name =>Okl_Opt_Pvt.G_UNEXPECTED_ERROR,
407: p_token1 =>Okl_Opt_Pvt.G_SQL_SQLCODE_TOKEN,
408: p_token1_value =>SQLCODE,
409: p_token2 =>Okl_Opt_Pvt.G_SQL_SQLERRM_TOKEN,

Line 406: p_msg_name =>Okl_Opt_Pvt.G_UNEXPECTED_ERROR,

402: END IF;
403: EXCEPTION
404: WHEN OTHERS THEN
405: Okl_Api.set_message(p_app_name =>Okl_Opt_Pvt.G_APP_NAME,
406: p_msg_name =>Okl_Opt_Pvt.G_UNEXPECTED_ERROR,
407: p_token1 =>Okl_Opt_Pvt.G_SQL_SQLCODE_TOKEN,
408: p_token1_value =>SQLCODE,
409: p_token2 =>Okl_Opt_Pvt.G_SQL_SQLERRM_TOKEN,
410: p_token2_value =>SQLERRM);

Line 407: p_token1 =>Okl_Opt_Pvt.G_SQL_SQLCODE_TOKEN,

403: EXCEPTION
404: WHEN OTHERS THEN
405: Okl_Api.set_message(p_app_name =>Okl_Opt_Pvt.G_APP_NAME,
406: p_msg_name =>Okl_Opt_Pvt.G_UNEXPECTED_ERROR,
407: p_token1 =>Okl_Opt_Pvt.G_SQL_SQLCODE_TOKEN,
408: p_token1_value =>SQLCODE,
409: p_token2 =>Okl_Opt_Pvt.G_SQL_SQLERRM_TOKEN,
410: p_token2_value =>SQLERRM);
411: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

Line 409: p_token2 =>Okl_Opt_Pvt.G_SQL_SQLERRM_TOKEN,

405: Okl_Api.set_message(p_app_name =>Okl_Opt_Pvt.G_APP_NAME,
406: p_msg_name =>Okl_Opt_Pvt.G_UNEXPECTED_ERROR,
407: p_token1 =>Okl_Opt_Pvt.G_SQL_SQLCODE_TOKEN,
408: p_token1_value =>SQLCODE,
409: p_token2 =>Okl_Opt_Pvt.G_SQL_SQLERRM_TOKEN,
410: p_token2_value =>SQLERRM);
411: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
412:
413: END Validate_From_Date;

Line 472: p_msg_name =>Okl_Opt_Pvt.G_UNEXPECTED_ERROR,

468: RETURN (l_return_status);
469:
470: WHEN OTHERS THEN
471: Okl_Api.set_message(p_app_name =>G_APP_NAME,
472: p_msg_name =>Okl_Opt_Pvt.G_UNEXPECTED_ERROR,
473: p_token1 =>Okl_Opt_Pvt.G_SQL_SQLCODE_TOKEN,
474: p_token1_value =>SQLCODE,
475: p_token2 =>Okl_Opt_Pvt.G_SQL_SQLERRM_TOKEN,
476: p_token2_value =>SQLERRM);

Line 473: p_token1 =>Okl_Opt_Pvt.G_SQL_SQLCODE_TOKEN,

469:
470: WHEN OTHERS THEN
471: Okl_Api.set_message(p_app_name =>G_APP_NAME,
472: p_msg_name =>Okl_Opt_Pvt.G_UNEXPECTED_ERROR,
473: p_token1 =>Okl_Opt_Pvt.G_SQL_SQLCODE_TOKEN,
474: p_token1_value =>SQLCODE,
475: p_token2 =>Okl_Opt_Pvt.G_SQL_SQLERRM_TOKEN,
476: p_token2_value =>SQLERRM);
477: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

Line 475: p_token2 =>Okl_Opt_Pvt.G_SQL_SQLERRM_TOKEN,

471: Okl_Api.set_message(p_app_name =>G_APP_NAME,
472: p_msg_name =>Okl_Opt_Pvt.G_UNEXPECTED_ERROR,
473: p_token1 =>Okl_Opt_Pvt.G_SQL_SQLCODE_TOKEN,
474: p_token1_value =>SQLCODE,
475: p_token2 =>Okl_Opt_Pvt.G_SQL_SQLERRM_TOKEN,
476: p_token2_value =>SQLERRM);
477: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
478: RETURN(l_return_status);
479:

Line 1059: ,p_msg_name => Okl_Opt_Pvt.g_to_date_error

1055:
1056: /* To Check end date is > from_date */
1057: IF (l_upd_optv_rec.TO_DATE IS NOT NULL) AND (l_upd_optv_rec.TO_DATE < l_upd_optv_rec.from_date) THEN
1058: Okl_Api.SET_MESSAGE(p_app_name => g_app_name
1059: ,p_msg_name => Okl_Opt_Pvt.g_to_date_error
1060: ,p_token1 => Okl_Opt_Pvt.g_col_name_token
1061: ,p_token1_value => 'to_date');
1062: x_return_status := Okl_Api.G_RET_STS_ERROR;
1063: RAISE Okl_Api.G_EXCEPTION_ERROR;

Line 1060: ,p_token1 => Okl_Opt_Pvt.g_col_name_token

1056: /* To Check end date is > from_date */
1057: IF (l_upd_optv_rec.TO_DATE IS NOT NULL) AND (l_upd_optv_rec.TO_DATE < l_upd_optv_rec.from_date) THEN
1058: Okl_Api.SET_MESSAGE(p_app_name => g_app_name
1059: ,p_msg_name => Okl_Opt_Pvt.g_to_date_error
1060: ,p_token1 => Okl_Opt_Pvt.g_col_name_token
1061: ,p_token1_value => 'to_date');
1062: x_return_status := Okl_Api.G_RET_STS_ERROR;
1063: RAISE Okl_Api.G_EXCEPTION_ERROR;
1064: END IF;