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_SETUPPOPTIONS_PVT dependencies on OKL_PON_PVT

Line 410: Okl_Api.set_message(Okl_Pon_Pvt.G_APP_NAME, Okl_Pon_Pvt.G_REQUIRED_VALUE,Okl_Pon_Pvt.G_COL_NAME_TOKEN,l_token_1);

406:
407: IF p_ponv_rec.opt_id = Okl_Api.G_MISS_NUM OR
408: p_ponv_rec.opt_id IS NULL
409: THEN
410: Okl_Api.set_message(Okl_Pon_Pvt.G_APP_NAME, Okl_Pon_Pvt.G_REQUIRED_VALUE,Okl_Pon_Pvt.G_COL_NAME_TOKEN,l_token_1);
411: x_return_status := Okl_Api.G_RET_STS_ERROR;
412: RAISE G_ITEM_NOT_FOUND_ERROR;
413: END IF;
414:

Line 419: Okl_Api.set_message(Okl_Pon_Pvt.G_APP_NAME, Okl_Pon_Pvt.G_INVALID_VALUE,Okl_Pon_Pvt.G_COL_NAME_TOKEN,l_token_1);

415: IF p_ponv_rec.opt_id IS NOT NULL THEN
416: OPEN okl_pdt_opts_foreign1 (p_ponv_rec.opt_id);
417: FETCH okl_pdt_opts_foreign1 INTO l_foreign_key;
418: IF okl_pdt_opts_foreign1%NOTFOUND THEN
419: Okl_Api.set_message(Okl_Pon_Pvt.G_APP_NAME, Okl_Pon_Pvt.G_INVALID_VALUE,Okl_Pon_Pvt.G_COL_NAME_TOKEN,l_token_1);
420: x_return_status := Okl_Api.G_RET_STS_ERROR;
421: RAISE G_ITEM_NOT_FOUND_ERROR;
422: ELSE
423: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

Line 432: Okl_Api.set_message(p_app_name =>Okl_Pon_Pvt.G_APP_NAME,

428: EXCEPTION
429: WHEN G_ITEM_NOT_FOUND_ERROR THEN
430: NULL;
431: WHEN OTHERS THEN
432: Okl_Api.set_message(p_app_name =>Okl_Pon_Pvt.G_APP_NAME,
433: p_msg_name =>Okl_Pon_Pvt.G_UNEXPECTED_ERROR,
434: p_token1 =>Okl_Pon_Pvt.G_SQL_SQLCODE_TOKEN,
435: p_token1_value =>SQLCODE,
436: p_token2 =>Okl_Pon_Pvt.G_SQL_SQLERRM_TOKEN,

Line 433: p_msg_name =>Okl_Pon_Pvt.G_UNEXPECTED_ERROR,

429: WHEN G_ITEM_NOT_FOUND_ERROR THEN
430: NULL;
431: WHEN OTHERS THEN
432: Okl_Api.set_message(p_app_name =>Okl_Pon_Pvt.G_APP_NAME,
433: p_msg_name =>Okl_Pon_Pvt.G_UNEXPECTED_ERROR,
434: p_token1 =>Okl_Pon_Pvt.G_SQL_SQLCODE_TOKEN,
435: p_token1_value =>SQLCODE,
436: p_token2 =>Okl_Pon_Pvt.G_SQL_SQLERRM_TOKEN,
437: p_token2_value =>SQLERRM);

Line 434: p_token1 =>Okl_Pon_Pvt.G_SQL_SQLCODE_TOKEN,

430: NULL;
431: WHEN OTHERS THEN
432: Okl_Api.set_message(p_app_name =>Okl_Pon_Pvt.G_APP_NAME,
433: p_msg_name =>Okl_Pon_Pvt.G_UNEXPECTED_ERROR,
434: p_token1 =>Okl_Pon_Pvt.G_SQL_SQLCODE_TOKEN,
435: p_token1_value =>SQLCODE,
436: p_token2 =>Okl_Pon_Pvt.G_SQL_SQLERRM_TOKEN,
437: p_token2_value =>SQLERRM);
438: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

Line 436: p_token2 =>Okl_Pon_Pvt.G_SQL_SQLERRM_TOKEN,

432: Okl_Api.set_message(p_app_name =>Okl_Pon_Pvt.G_APP_NAME,
433: p_msg_name =>Okl_Pon_Pvt.G_UNEXPECTED_ERROR,
434: p_token1 =>Okl_Pon_Pvt.G_SQL_SQLCODE_TOKEN,
435: p_token1_value =>SQLCODE,
436: p_token2 =>Okl_Pon_Pvt.G_SQL_SQLERRM_TOKEN,
437: p_token2_value =>SQLERRM);
438: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
439:
440: END Validate_Opt_Id;

Line 484: Okl_Api.set_message(p_app_name =>Okl_Pon_Pvt.G_APP_NAME,

480: NULL;
481: RETURN (l_return_status);
482:
483: WHEN OTHERS THEN
484: Okl_Api.set_message(p_app_name =>Okl_Pon_Pvt.G_APP_NAME,
485: p_msg_name =>Okl_Pon_Pvt.G_UNEXPECTED_ERROR,
486: p_token1 =>Okl_Pon_Pvt.G_SQL_SQLCODE_TOKEN,
487: p_token1_value =>SQLCODE,
488: p_token2 =>Okl_Pon_Pvt.G_SQL_SQLERRM_TOKEN,

Line 485: p_msg_name =>Okl_Pon_Pvt.G_UNEXPECTED_ERROR,

481: RETURN (l_return_status);
482:
483: WHEN OTHERS THEN
484: Okl_Api.set_message(p_app_name =>Okl_Pon_Pvt.G_APP_NAME,
485: p_msg_name =>Okl_Pon_Pvt.G_UNEXPECTED_ERROR,
486: p_token1 =>Okl_Pon_Pvt.G_SQL_SQLCODE_TOKEN,
487: p_token1_value =>SQLCODE,
488: p_token2 =>Okl_Pon_Pvt.G_SQL_SQLERRM_TOKEN,
489: p_token2_value =>SQLERRM);

Line 486: p_token1 =>Okl_Pon_Pvt.G_SQL_SQLCODE_TOKEN,

482:
483: WHEN OTHERS THEN
484: Okl_Api.set_message(p_app_name =>Okl_Pon_Pvt.G_APP_NAME,
485: p_msg_name =>Okl_Pon_Pvt.G_UNEXPECTED_ERROR,
486: p_token1 =>Okl_Pon_Pvt.G_SQL_SQLCODE_TOKEN,
487: p_token1_value =>SQLCODE,
488: p_token2 =>Okl_Pon_Pvt.G_SQL_SQLERRM_TOKEN,
489: p_token2_value =>SQLERRM);
490: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

Line 488: p_token2 =>Okl_Pon_Pvt.G_SQL_SQLERRM_TOKEN,

484: Okl_Api.set_message(p_app_name =>Okl_Pon_Pvt.G_APP_NAME,
485: p_msg_name =>Okl_Pon_Pvt.G_UNEXPECTED_ERROR,
486: p_token1 =>Okl_Pon_Pvt.G_SQL_SQLCODE_TOKEN,
487: p_token1_value =>SQLCODE,
488: p_token2 =>Okl_Pon_Pvt.G_SQL_SQLERRM_TOKEN,
489: p_token2_value =>SQLERRM);
490: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
491: RETURN(l_return_status);
492: