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_SETUPPOVALUES_PVT dependencies on OKL_POV_PVT

Line 352: Okc_Api.set_message(Okl_Pov_Pvt.G_APP_NAME, Okl_Pov_Pvt.G_REQUIRED_VALUE,Okl_Pov_Pvt.G_COL_NAME_TOKEN,l_token_1);

348:
349: IF p_povv_rec.ove_id = Okl_Api.G_MISS_NUM OR
350: p_povv_rec.ove_id IS NULL
351: THEN
352: Okc_Api.set_message(Okl_Pov_Pvt.G_APP_NAME, Okl_Pov_Pvt.G_REQUIRED_VALUE,Okl_Pov_Pvt.G_COL_NAME_TOKEN,l_token_1);
353: x_return_status := Okl_Api.G_RET_STS_ERROR;
354: RAISE G_ITEM_NOT_FOUND_ERROR;
355: END IF;
356:

Line 361: Okc_Api.set_message(Okl_Pov_Pvt.G_APP_NAME, Okl_Pov_Pvt.G_INVALID_KEY,Okl_Pov_Pvt.G_COL_NAME_TOKEN,l_token_1);

357: IF p_povv_rec.ove_id IS NOT NULL THEN
358: OPEN okl_pdt_opt_vals_foreign1 (p_povv_rec.ove_id);
359: FETCH okl_pdt_opt_vals_foreign1 INTO l_foreign_key;
360: IF okl_pdt_opt_vals_foreign1%NOTFOUND THEN
361: Okc_Api.set_message(Okl_Pov_Pvt.G_APP_NAME, Okl_Pov_Pvt.G_INVALID_KEY,Okl_Pov_Pvt.G_COL_NAME_TOKEN,l_token_1);
362: x_return_status := Okl_Api.G_RET_STS_ERROR;
363: RAISE G_ITEM_NOT_FOUND_ERROR;
364: ELSE
365: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

Line 373: Okl_Api.set_message(p_app_name =>Okl_Pov_Pvt.G_APP_NAME,

369: EXCEPTION
370: WHEN G_ITEM_NOT_FOUND_ERROR THEN
371: NULL;
372: WHEN OTHERS THEN
373: Okl_Api.set_message(p_app_name =>Okl_Pov_Pvt.G_APP_NAME,
374: p_msg_name =>Okl_Pov_Pvt.G_UNEXPECTED_ERROR,
375: p_token1 =>Okl_Pov_Pvt.G_SQL_SQLCODE_TOKEN,
376: p_token1_value =>SQLCODE,
377: p_token2 =>Okl_Pov_Pvt.G_SQL_SQLERRM_TOKEN,

Line 374: p_msg_name =>Okl_Pov_Pvt.G_UNEXPECTED_ERROR,

370: WHEN G_ITEM_NOT_FOUND_ERROR THEN
371: NULL;
372: WHEN OTHERS THEN
373: Okl_Api.set_message(p_app_name =>Okl_Pov_Pvt.G_APP_NAME,
374: p_msg_name =>Okl_Pov_Pvt.G_UNEXPECTED_ERROR,
375: p_token1 =>Okl_Pov_Pvt.G_SQL_SQLCODE_TOKEN,
376: p_token1_value =>SQLCODE,
377: p_token2 =>Okl_Pov_Pvt.G_SQL_SQLERRM_TOKEN,
378: p_token2_value =>SQLERRM);

Line 375: p_token1 =>Okl_Pov_Pvt.G_SQL_SQLCODE_TOKEN,

371: NULL;
372: WHEN OTHERS THEN
373: Okl_Api.set_message(p_app_name =>Okl_Pov_Pvt.G_APP_NAME,
374: p_msg_name =>Okl_Pov_Pvt.G_UNEXPECTED_ERROR,
375: p_token1 =>Okl_Pov_Pvt.G_SQL_SQLCODE_TOKEN,
376: p_token1_value =>SQLCODE,
377: p_token2 =>Okl_Pov_Pvt.G_SQL_SQLERRM_TOKEN,
378: p_token2_value =>SQLERRM);
379: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

Line 377: p_token2 =>Okl_Pov_Pvt.G_SQL_SQLERRM_TOKEN,

373: Okl_Api.set_message(p_app_name =>Okl_Pov_Pvt.G_APP_NAME,
374: p_msg_name =>Okl_Pov_Pvt.G_UNEXPECTED_ERROR,
375: p_token1 =>Okl_Pov_Pvt.G_SQL_SQLCODE_TOKEN,
376: p_token1_value =>SQLCODE,
377: p_token2 =>Okl_Pov_Pvt.G_SQL_SQLERRM_TOKEN,
378: p_token2_value =>SQLERRM);
379: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
380:
381: END Validate_Ove_Id;

Line 422: Okl_Api.set_message(p_app_name =>Okl_Pov_Pvt.G_APP_NAME,

418: NULL;
419: RETURN (l_return_status);
420:
421: WHEN OTHERS THEN
422: Okl_Api.set_message(p_app_name =>Okl_Pov_Pvt.G_APP_NAME,
423: p_msg_name =>Okl_Pov_Pvt.G_UNEXPECTED_ERROR,
424: p_token1 =>Okl_Pov_Pvt.G_SQL_SQLCODE_TOKEN,
425: p_token1_value =>SQLCODE,
426: p_token2 =>Okl_Pov_Pvt.G_SQL_SQLERRM_TOKEN,

Line 423: p_msg_name =>Okl_Pov_Pvt.G_UNEXPECTED_ERROR,

419: RETURN (l_return_status);
420:
421: WHEN OTHERS THEN
422: Okl_Api.set_message(p_app_name =>Okl_Pov_Pvt.G_APP_NAME,
423: p_msg_name =>Okl_Pov_Pvt.G_UNEXPECTED_ERROR,
424: p_token1 =>Okl_Pov_Pvt.G_SQL_SQLCODE_TOKEN,
425: p_token1_value =>SQLCODE,
426: p_token2 =>Okl_Pov_Pvt.G_SQL_SQLERRM_TOKEN,
427: p_token2_value =>SQLERRM);

Line 424: p_token1 =>Okl_Pov_Pvt.G_SQL_SQLCODE_TOKEN,

420:
421: WHEN OTHERS THEN
422: Okl_Api.set_message(p_app_name =>Okl_Pov_Pvt.G_APP_NAME,
423: p_msg_name =>Okl_Pov_Pvt.G_UNEXPECTED_ERROR,
424: p_token1 =>Okl_Pov_Pvt.G_SQL_SQLCODE_TOKEN,
425: p_token1_value =>SQLCODE,
426: p_token2 =>Okl_Pov_Pvt.G_SQL_SQLERRM_TOKEN,
427: p_token2_value =>SQLERRM);
428: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

Line 426: p_token2 =>Okl_Pov_Pvt.G_SQL_SQLERRM_TOKEN,

422: Okl_Api.set_message(p_app_name =>Okl_Pov_Pvt.G_APP_NAME,
423: p_msg_name =>Okl_Pov_Pvt.G_UNEXPECTED_ERROR,
424: p_token1 =>Okl_Pov_Pvt.G_SQL_SQLCODE_TOKEN,
425: p_token1_value =>SQLCODE,
426: p_token2 =>Okl_Pov_Pvt.G_SQL_SQLERRM_TOKEN,
427: p_token2_value =>SQLERRM);
428: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
429: RETURN(l_return_status);
430: