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_SETUPPQUALITYS_PVT dependencies on OKL_PQY_PVT

Line 246: Okl_Api.set_message(Okl_Pqy_Pvt.G_APP_NAME, Okl_Pqy_Pvt.G_REQUIRED_VALUE,Okl_Pqy_Pvt.G_COL_NAME_TOKEN,l_token_1);

242:
243: l_token_1 := Okl_Accounting_Util.Get_Message_Token('OKL_LP_PRDQLTY_CRUPD','OKL_NAME');
244: IF p_pqyv_rec.name = Okl_Api.G_MISS_CHAR OR p_pqyv_rec.name IS NULL
245: THEN
246: Okl_Api.set_message(Okl_Pqy_Pvt.G_APP_NAME, Okl_Pqy_Pvt.G_REQUIRED_VALUE,Okl_Pqy_Pvt.G_COL_NAME_TOKEN,l_token_1);
247: x_return_status := Okl_Api.G_RET_STS_ERROR;
248: END IF;
249: p_pqyv_rec.name := Okl_Accounting_Util.okl_upper(p_pqyv_rec.name);
250: EXCEPTION

Line 252: Okl_Api.set_message(p_app_name =>Okl_Pqy_Pvt.G_APP_NAME,

248: END IF;
249: p_pqyv_rec.name := Okl_Accounting_Util.okl_upper(p_pqyv_rec.name);
250: EXCEPTION
251: WHEN OTHERS THEN
252: Okl_Api.set_message(p_app_name =>Okl_Pqy_Pvt.G_APP_NAME,
253: p_msg_name =>Okl_Pqy_Pvt.G_UNEXPECTED_ERROR,
254: p_token1 =>Okl_Pqy_Pvt.G_SQL_SQLCODE_TOKEN,
255: p_token1_value =>SQLCODE,
256: p_token2 =>Okl_Pqy_Pvt.G_SQL_SQLERRM_TOKEN,

Line 253: p_msg_name =>Okl_Pqy_Pvt.G_UNEXPECTED_ERROR,

249: p_pqyv_rec.name := Okl_Accounting_Util.okl_upper(p_pqyv_rec.name);
250: EXCEPTION
251: WHEN OTHERS THEN
252: Okl_Api.set_message(p_app_name =>Okl_Pqy_Pvt.G_APP_NAME,
253: p_msg_name =>Okl_Pqy_Pvt.G_UNEXPECTED_ERROR,
254: p_token1 =>Okl_Pqy_Pvt.G_SQL_SQLCODE_TOKEN,
255: p_token1_value =>SQLCODE,
256: p_token2 =>Okl_Pqy_Pvt.G_SQL_SQLERRM_TOKEN,
257: p_token2_value =>SQLERRM);

Line 254: p_token1 =>Okl_Pqy_Pvt.G_SQL_SQLCODE_TOKEN,

250: EXCEPTION
251: WHEN OTHERS THEN
252: Okl_Api.set_message(p_app_name =>Okl_Pqy_Pvt.G_APP_NAME,
253: p_msg_name =>Okl_Pqy_Pvt.G_UNEXPECTED_ERROR,
254: p_token1 =>Okl_Pqy_Pvt.G_SQL_SQLCODE_TOKEN,
255: p_token1_value =>SQLCODE,
256: p_token2 =>Okl_Pqy_Pvt.G_SQL_SQLERRM_TOKEN,
257: p_token2_value =>SQLERRM);
258: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

Line 256: p_token2 =>Okl_Pqy_Pvt.G_SQL_SQLERRM_TOKEN,

252: Okl_Api.set_message(p_app_name =>Okl_Pqy_Pvt.G_APP_NAME,
253: p_msg_name =>Okl_Pqy_Pvt.G_UNEXPECTED_ERROR,
254: p_token1 =>Okl_Pqy_Pvt.G_SQL_SQLCODE_TOKEN,
255: p_token1_value =>SQLCODE,
256: p_token2 =>Okl_Pqy_Pvt.G_SQL_SQLERRM_TOKEN,
257: p_token2_value =>SQLERRM);
258: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
259:
260: END Validate_Name;

Line 288: Okl_Api.set_message(Okl_Pqy_Pvt.G_APP_NAME, Okl_Pqy_Pvt.G_REQUIRED_VALUE,Okl_Pqy_Pvt.G_COL_NAME_TOKEN,l_token_1);

284:
285: l_token_1 := Okl_Accounting_Util.Get_Message_Token('OKL_LP_PRDQLTY_CRUPD','OKL_EFFECTIVE_FROM');
286: IF p_pqyv_rec.from_date = Okl_Api.G_MISS_DATE OR p_pqyv_rec.from_date IS NULL
287: THEN
288: Okl_Api.set_message(Okl_Pqy_Pvt.G_APP_NAME, Okl_Pqy_Pvt.G_REQUIRED_VALUE,Okl_Pqy_Pvt.G_COL_NAME_TOKEN,l_token_1);
289: x_return_status := Okl_Api.G_RET_STS_ERROR;
290: END IF;
291: EXCEPTION
292: WHEN OTHERS THEN

Line 293: Okl_Api.set_message(p_app_name =>Okl_Pqy_Pvt.G_APP_NAME,

289: x_return_status := Okl_Api.G_RET_STS_ERROR;
290: END IF;
291: EXCEPTION
292: WHEN OTHERS THEN
293: Okl_Api.set_message(p_app_name =>Okl_Pqy_Pvt.G_APP_NAME,
294: p_msg_name =>Okl_Pqy_Pvt.G_UNEXPECTED_ERROR,
295: p_token1 =>Okl_Pqy_Pvt.G_SQL_SQLCODE_TOKEN,
296: p_token1_value =>SQLCODE,
297: p_token2 =>Okl_Pqy_Pvt.G_SQL_SQLERRM_TOKEN,

Line 294: p_msg_name =>Okl_Pqy_Pvt.G_UNEXPECTED_ERROR,

290: END IF;
291: EXCEPTION
292: WHEN OTHERS THEN
293: Okl_Api.set_message(p_app_name =>Okl_Pqy_Pvt.G_APP_NAME,
294: p_msg_name =>Okl_Pqy_Pvt.G_UNEXPECTED_ERROR,
295: p_token1 =>Okl_Pqy_Pvt.G_SQL_SQLCODE_TOKEN,
296: p_token1_value =>SQLCODE,
297: p_token2 =>Okl_Pqy_Pvt.G_SQL_SQLERRM_TOKEN,
298: p_token2_value =>SQLERRM);

Line 295: p_token1 =>Okl_Pqy_Pvt.G_SQL_SQLCODE_TOKEN,

291: EXCEPTION
292: WHEN OTHERS THEN
293: Okl_Api.set_message(p_app_name =>Okl_Pqy_Pvt.G_APP_NAME,
294: p_msg_name =>Okl_Pqy_Pvt.G_UNEXPECTED_ERROR,
295: p_token1 =>Okl_Pqy_Pvt.G_SQL_SQLCODE_TOKEN,
296: p_token1_value =>SQLCODE,
297: p_token2 =>Okl_Pqy_Pvt.G_SQL_SQLERRM_TOKEN,
298: p_token2_value =>SQLERRM);
299: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

Line 297: p_token2 =>Okl_Pqy_Pvt.G_SQL_SQLERRM_TOKEN,

293: Okl_Api.set_message(p_app_name =>Okl_Pqy_Pvt.G_APP_NAME,
294: p_msg_name =>Okl_Pqy_Pvt.G_UNEXPECTED_ERROR,
295: p_token1 =>Okl_Pqy_Pvt.G_SQL_SQLCODE_TOKEN,
296: p_token1_value =>SQLCODE,
297: p_token2 =>Okl_Pqy_Pvt.G_SQL_SQLERRM_TOKEN,
298: p_token2_value =>SQLERRM);
299: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
300:
301: END Validate_From_Date;

Line 359: Okl_Api.set_message(p_app_name =>Okl_Pqy_Pvt.G_APP_NAME,

355: NULL;
356: RETURN (l_return_status);
357:
358: WHEN OTHERS THEN
359: Okl_Api.set_message(p_app_name =>Okl_Pqy_Pvt.G_APP_NAME,
360: p_msg_name =>Okl_Pqy_Pvt.G_UNEXPECTED_ERROR,
361: p_token1 =>Okl_Pqy_Pvt.G_SQL_SQLCODE_TOKEN,
362: p_token1_value =>SQLCODE,
363: p_token2 =>Okl_Pqy_Pvt.G_SQL_SQLERRM_TOKEN,

Line 360: p_msg_name =>Okl_Pqy_Pvt.G_UNEXPECTED_ERROR,

356: RETURN (l_return_status);
357:
358: WHEN OTHERS THEN
359: Okl_Api.set_message(p_app_name =>Okl_Pqy_Pvt.G_APP_NAME,
360: p_msg_name =>Okl_Pqy_Pvt.G_UNEXPECTED_ERROR,
361: p_token1 =>Okl_Pqy_Pvt.G_SQL_SQLCODE_TOKEN,
362: p_token1_value =>SQLCODE,
363: p_token2 =>Okl_Pqy_Pvt.G_SQL_SQLERRM_TOKEN,
364: p_token2_value =>SQLERRM);

Line 361: p_token1 =>Okl_Pqy_Pvt.G_SQL_SQLCODE_TOKEN,

357:
358: WHEN OTHERS THEN
359: Okl_Api.set_message(p_app_name =>Okl_Pqy_Pvt.G_APP_NAME,
360: p_msg_name =>Okl_Pqy_Pvt.G_UNEXPECTED_ERROR,
361: p_token1 =>Okl_Pqy_Pvt.G_SQL_SQLCODE_TOKEN,
362: p_token1_value =>SQLCODE,
363: p_token2 =>Okl_Pqy_Pvt.G_SQL_SQLERRM_TOKEN,
364: p_token2_value =>SQLERRM);
365: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

Line 363: p_token2 =>Okl_Pqy_Pvt.G_SQL_SQLERRM_TOKEN,

359: Okl_Api.set_message(p_app_name =>Okl_Pqy_Pvt.G_APP_NAME,
360: p_msg_name =>Okl_Pqy_Pvt.G_UNEXPECTED_ERROR,
361: p_token1 =>Okl_Pqy_Pvt.G_SQL_SQLCODE_TOKEN,
362: p_token1_value =>SQLCODE,
363: p_token2 =>Okl_Pqy_Pvt.G_SQL_SQLERRM_TOKEN,
364: p_token2_value =>SQLERRM);
365: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
366: RETURN(l_return_status);
367:

Line 698: ,p_msg_name => Okl_Pqy_Pvt.g_to_date_error

694: END IF;
695:
696: IF (l_pqyv_rec.TO_DATE IS NOT NULL) AND (l_pqyv_rec.TO_DATE < l_pqyv_rec.from_date) THEN
697: Okl_Api.SET_MESSAGE(p_app_name => g_app_name
698: ,p_msg_name => Okl_Pqy_Pvt.g_to_date_error
699: ,p_token1 => Okl_Pqy_Pvt.g_col_name_token
700: ,p_token1_value => 'to_date');
701: x_return_status := Okl_Api.G_RET_STS_ERROR;
702: RAISE Okl_Api.G_EXCEPTION_ERROR;

Line 699: ,p_token1 => Okl_Pqy_Pvt.g_col_name_token

695:
696: IF (l_pqyv_rec.TO_DATE IS NOT NULL) AND (l_pqyv_rec.TO_DATE < l_pqyv_rec.from_date) THEN
697: Okl_Api.SET_MESSAGE(p_app_name => g_app_name
698: ,p_msg_name => Okl_Pqy_Pvt.g_to_date_error
699: ,p_token1 => Okl_Pqy_Pvt.g_col_name_token
700: ,p_token1_value => 'to_date');
701: x_return_status := Okl_Api.G_RET_STS_ERROR;
702: RAISE Okl_Api.G_EXCEPTION_ERROR;
703: END IF;

Line 853: ,p_msg_name => Okl_Pqy_Pvt.g_to_date_error

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

Line 854: ,p_token1 => Okl_Pqy_Pvt.g_col_name_token

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