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_SETUPPQYVALUES_PVT dependencies on OKL_QVE_PVT

Line 299: Okl_Api.set_message(Okl_Qve_Pvt.G_APP_NAME, Okl_Qve_Pvt.G_REQUIRED_VALUE,Okl_Qve_Pvt.G_COL_NAME_TOKEN,l_token_1);

295:
296: IF p_qvev_rec.value = Okl_Api.G_MISS_CHAR OR
297: p_qvev_rec.value IS NULL
298: THEN
299: Okl_Api.set_message(Okl_Qve_Pvt.G_APP_NAME, Okl_Qve_Pvt.G_REQUIRED_VALUE,Okl_Qve_Pvt.G_COL_NAME_TOKEN,l_token_1);
300: x_return_status := Okl_Api.G_RET_STS_ERROR;
301: END IF;
302: p_qvev_rec.value := Okl_Accounting_Util.okl_upper(p_qvev_rec.value);
303: EXCEPTION

Line 305: Okl_Api.set_message(p_app_name =>Okl_Qve_Pvt.G_APP_NAME,

301: END IF;
302: p_qvev_rec.value := Okl_Accounting_Util.okl_upper(p_qvev_rec.value);
303: EXCEPTION
304: WHEN OTHERS THEN
305: Okl_Api.set_message(p_app_name =>Okl_Qve_Pvt.G_APP_NAME,
306: p_msg_name =>Okl_Qve_Pvt.G_UNEXPECTED_ERROR,
307: p_token1 =>Okl_Qve_Pvt.G_SQL_SQLCODE_TOKEN,
308: p_token1_value =>SQLCODE,
309: p_token2 =>Okl_Qve_Pvt.G_SQL_SQLERRM_TOKEN,

Line 306: p_msg_name =>Okl_Qve_Pvt.G_UNEXPECTED_ERROR,

302: p_qvev_rec.value := Okl_Accounting_Util.okl_upper(p_qvev_rec.value);
303: EXCEPTION
304: WHEN OTHERS THEN
305: Okl_Api.set_message(p_app_name =>Okl_Qve_Pvt.G_APP_NAME,
306: p_msg_name =>Okl_Qve_Pvt.G_UNEXPECTED_ERROR,
307: p_token1 =>Okl_Qve_Pvt.G_SQL_SQLCODE_TOKEN,
308: p_token1_value =>SQLCODE,
309: p_token2 =>Okl_Qve_Pvt.G_SQL_SQLERRM_TOKEN,
310: p_token2_value =>SQLERRM);

Line 307: p_token1 =>Okl_Qve_Pvt.G_SQL_SQLCODE_TOKEN,

303: EXCEPTION
304: WHEN OTHERS THEN
305: Okl_Api.set_message(p_app_name =>Okl_Qve_Pvt.G_APP_NAME,
306: p_msg_name =>Okl_Qve_Pvt.G_UNEXPECTED_ERROR,
307: p_token1 =>Okl_Qve_Pvt.G_SQL_SQLCODE_TOKEN,
308: p_token1_value =>SQLCODE,
309: p_token2 =>Okl_Qve_Pvt.G_SQL_SQLERRM_TOKEN,
310: p_token2_value =>SQLERRM);
311: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

Line 309: p_token2 =>Okl_Qve_Pvt.G_SQL_SQLERRM_TOKEN,

305: Okl_Api.set_message(p_app_name =>Okl_Qve_Pvt.G_APP_NAME,
306: p_msg_name =>Okl_Qve_Pvt.G_UNEXPECTED_ERROR,
307: p_token1 =>Okl_Qve_Pvt.G_SQL_SQLCODE_TOKEN,
308: p_token1_value =>SQLCODE,
309: p_token2 =>Okl_Qve_Pvt.G_SQL_SQLERRM_TOKEN,
310: p_token2_value =>SQLERRM);
311: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
312:
313: END Validate_Value;

Line 341: Okl_Api.set_message(Okl_Qve_Pvt.G_APP_NAME, Okl_Qve_Pvt.G_REQUIRED_VALUE,Okl_Qve_Pvt.G_COL_NAME_TOKEN,l_token_1);

337: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
338: l_token_1 := Okl_Accounting_Util.Get_Message_Token('OKL_LP_PQVALS_CRUPD','OKL_EFFECTIVE_FROM');
339: IF (p_qvev_rec.from_date IS NULL) OR
340: (p_qvev_rec.from_date = Okl_Api.G_MISS_DATE) THEN
341: Okl_Api.set_message(Okl_Qve_Pvt.G_APP_NAME, Okl_Qve_Pvt.G_REQUIRED_VALUE,Okl_Qve_Pvt.G_COL_NAME_TOKEN,l_token_1);
342: x_return_status := Okl_Api.G_RET_STS_ERROR;
343: END IF;
344: EXCEPTION
345: WHEN OTHERS THEN

Line 346: Okl_Api.set_message(p_app_name =>Okl_Qve_Pvt.G_APP_NAME,

342: x_return_status := Okl_Api.G_RET_STS_ERROR;
343: END IF;
344: EXCEPTION
345: WHEN OTHERS THEN
346: Okl_Api.set_message(p_app_name =>Okl_Qve_Pvt.G_APP_NAME,
347: p_msg_name =>Okl_Qve_Pvt.G_UNEXPECTED_ERROR,
348: p_token1 =>Okl_Qve_Pvt.G_SQL_SQLCODE_TOKEN,
349: p_token1_value =>SQLCODE,
350: p_token2 =>Okl_Qve_Pvt.G_SQL_SQLERRM_TOKEN,

Line 347: p_msg_name =>Okl_Qve_Pvt.G_UNEXPECTED_ERROR,

343: END IF;
344: EXCEPTION
345: WHEN OTHERS THEN
346: Okl_Api.set_message(p_app_name =>Okl_Qve_Pvt.G_APP_NAME,
347: p_msg_name =>Okl_Qve_Pvt.G_UNEXPECTED_ERROR,
348: p_token1 =>Okl_Qve_Pvt.G_SQL_SQLCODE_TOKEN,
349: p_token1_value =>SQLCODE,
350: p_token2 =>Okl_Qve_Pvt.G_SQL_SQLERRM_TOKEN,
351: p_token2_value =>SQLERRM);

Line 348: p_token1 =>Okl_Qve_Pvt.G_SQL_SQLCODE_TOKEN,

344: EXCEPTION
345: WHEN OTHERS THEN
346: Okl_Api.set_message(p_app_name =>Okl_Qve_Pvt.G_APP_NAME,
347: p_msg_name =>Okl_Qve_Pvt.G_UNEXPECTED_ERROR,
348: p_token1 =>Okl_Qve_Pvt.G_SQL_SQLCODE_TOKEN,
349: p_token1_value =>SQLCODE,
350: p_token2 =>Okl_Qve_Pvt.G_SQL_SQLERRM_TOKEN,
351: p_token2_value =>SQLERRM);
352: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

Line 350: p_token2 =>Okl_Qve_Pvt.G_SQL_SQLERRM_TOKEN,

346: Okl_Api.set_message(p_app_name =>Okl_Qve_Pvt.G_APP_NAME,
347: p_msg_name =>Okl_Qve_Pvt.G_UNEXPECTED_ERROR,
348: p_token1 =>Okl_Qve_Pvt.G_SQL_SQLCODE_TOKEN,
349: p_token1_value =>SQLCODE,
350: p_token2 =>Okl_Qve_Pvt.G_SQL_SQLERRM_TOKEN,
351: p_token2_value =>SQLERRM);
352: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
353:
354: END Validate_From_Date;

Line 413: Okl_Api.set_message(p_app_name =>Okl_Qve_Pvt.G_APP_NAME,

409: NULL;
410: RETURN (l_return_status);
411:
412: WHEN OTHERS THEN
413: Okl_Api.set_message(p_app_name =>Okl_Qve_Pvt.G_APP_NAME,
414: p_msg_name =>Okl_Qve_Pvt.G_UNEXPECTED_ERROR,
415: p_token1 =>Okl_Qve_Pvt.G_SQL_SQLCODE_TOKEN,
416: p_token1_value =>SQLCODE,
417: p_token2 =>Okl_Qve_Pvt.G_SQL_SQLERRM_TOKEN,

Line 414: p_msg_name =>Okl_Qve_Pvt.G_UNEXPECTED_ERROR,

410: RETURN (l_return_status);
411:
412: WHEN OTHERS THEN
413: Okl_Api.set_message(p_app_name =>Okl_Qve_Pvt.G_APP_NAME,
414: p_msg_name =>Okl_Qve_Pvt.G_UNEXPECTED_ERROR,
415: p_token1 =>Okl_Qve_Pvt.G_SQL_SQLCODE_TOKEN,
416: p_token1_value =>SQLCODE,
417: p_token2 =>Okl_Qve_Pvt.G_SQL_SQLERRM_TOKEN,
418: p_token2_value =>SQLERRM);

Line 415: p_token1 =>Okl_Qve_Pvt.G_SQL_SQLCODE_TOKEN,

411:
412: WHEN OTHERS THEN
413: Okl_Api.set_message(p_app_name =>Okl_Qve_Pvt.G_APP_NAME,
414: p_msg_name =>Okl_Qve_Pvt.G_UNEXPECTED_ERROR,
415: p_token1 =>Okl_Qve_Pvt.G_SQL_SQLCODE_TOKEN,
416: p_token1_value =>SQLCODE,
417: p_token2 =>Okl_Qve_Pvt.G_SQL_SQLERRM_TOKEN,
418: p_token2_value =>SQLERRM);
419: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

Line 417: p_token2 =>Okl_Qve_Pvt.G_SQL_SQLERRM_TOKEN,

413: Okl_Api.set_message(p_app_name =>Okl_Qve_Pvt.G_APP_NAME,
414: p_msg_name =>Okl_Qve_Pvt.G_UNEXPECTED_ERROR,
415: p_token1 =>Okl_Qve_Pvt.G_SQL_SQLCODE_TOKEN,
416: p_token1_value =>SQLCODE,
417: p_token2 =>Okl_Qve_Pvt.G_SQL_SQLERRM_TOKEN,
418: p_token2_value =>SQLERRM);
419: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
420: RETURN(l_return_status);
421:

Line 852: ,p_msg_name => Okl_Qve_Pvt.g_to_date_error

848: end if;
849:
850: IF (l_upd_qvev_rec.TO_DATE IS NOT NULL) AND (l_upd_qvev_rec.TO_DATE < l_upd_qvev_rec.from_date) THEN
851: Okl_Api.SET_MESSAGE(p_app_name => g_app_name
852: ,p_msg_name => Okl_Qve_Pvt.g_to_date_error
853: ,p_token1 => Okl_Qve_Pvt.g_col_name_token
854: ,p_token1_value => 'TO_DATE');
855: x_return_status := Okl_Api.G_RET_STS_ERROR;
856: RAISE Okl_Api.G_EXCEPTION_ERROR;

Line 853: ,p_token1 => Okl_Qve_Pvt.g_col_name_token

849:
850: IF (l_upd_qvev_rec.TO_DATE IS NOT NULL) AND (l_upd_qvev_rec.TO_DATE < l_upd_qvev_rec.from_date) THEN
851: Okl_Api.SET_MESSAGE(p_app_name => g_app_name
852: ,p_msg_name => Okl_Qve_Pvt.g_to_date_error
853: ,p_token1 => Okl_Qve_Pvt.g_col_name_token
854: ,p_token1_value => 'TO_DATE');
855: x_return_status := Okl_Api.G_RET_STS_ERROR;
856: RAISE Okl_Api.G_EXCEPTION_ERROR;
857: END IF;