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_SETUPPSTYPES_PVT dependencies on OKL_PSY_PVT

Line 187: Okl_Api.set_message('OKL',Okl_Psy_Pvt.G_UNQS,Okl_Psy_Pvt.G_TABLE_TOKEN, l_token_1); ---CHG001

183: FETCH c1 INTO l_psy_status;
184: l_row_found := c1%FOUND;
185: CLOSE c1;
186: IF l_row_found THEN
187: Okl_Api.set_message('OKL',Okl_Psy_Pvt.G_UNQS,Okl_Psy_Pvt.G_TABLE_TOKEN, l_token_1); ---CHG001
188: x_valid := FALSE;
189: x_return_status := Okl_Api.G_RET_STS_ERROR;
190: RAISE G_EXCEPTION_HALT_PROCESSING;
191: END IF;

Line 307: Okl_Api.set_message(Okl_Psy_Pvt.G_APP_NAME, Okl_Psy_Pvt.G_REQUIRED_VALUE, Okl_Psy_Pvt.G_COL_NAME_TOKEN, l_token_1);

303:
304: IF (p_sty_id = Okl_Api.G_MISS_NUM OR
305: p_sty_id IS NULL)
306: THEN
307: Okl_Api.set_message(Okl_Psy_Pvt.G_APP_NAME, Okl_Psy_Pvt.G_REQUIRED_VALUE, Okl_Psy_Pvt.G_COL_NAME_TOKEN, l_token_1);
308: x_return_status := Okl_Api.G_RET_STS_ERROR;
309: RAISE G_EXCEPTION_HALT_PROCESSING;
310: END IF;
311:

Line 319: Okl_Api.set_message(Okl_Psy_Pvt.G_APP_NAME, Okl_Psy_Pvt.G_INVALID_VALUE,Okl_Psy_Pvt.G_COL_NAME_TOKEN,l_token_1);

315: FETCH okl_styv_pk_csr INTO l_sty_status;
316: l_row_notfound := okl_styv_pk_csr%NOTFOUND;
317: CLOSE okl_styv_pk_csr;
318: IF (l_row_notfound) THEN
319: Okl_Api.set_message(Okl_Psy_Pvt.G_APP_NAME, Okl_Psy_Pvt.G_INVALID_VALUE,Okl_Psy_Pvt.G_COL_NAME_TOKEN,l_token_1);
320: RAISE G_ITEM_NOT_FOUND_ERROR;
321: END IF;
322: END IF;
323:

Line 328: Okc_Api.SET_MESSAGE( p_app_name => Okl_Psy_Pvt.G_APP_NAME

324: EXCEPTION
325: WHEN G_EXCEPTION_HALT_PROCESSING THEN
326: NULL;
327: WHEN OTHERS THEN
328: Okc_Api.SET_MESSAGE( p_app_name => Okl_Psy_Pvt.G_APP_NAME
329: ,p_msg_name => Okl_Psy_Pvt.G_UNEXPECTED_ERROR
330: ,p_token1 => Okl_Psy_Pvt.G_SQLCODE_TOKEN
331: ,p_token1_value => SQLCODE
332: ,p_token2 => Okl_Psy_Pvt.G_SQLERRM_TOKEN

Line 329: ,p_msg_name => Okl_Psy_Pvt.G_UNEXPECTED_ERROR

325: WHEN G_EXCEPTION_HALT_PROCESSING THEN
326: NULL;
327: WHEN OTHERS THEN
328: Okc_Api.SET_MESSAGE( p_app_name => Okl_Psy_Pvt.G_APP_NAME
329: ,p_msg_name => Okl_Psy_Pvt.G_UNEXPECTED_ERROR
330: ,p_token1 => Okl_Psy_Pvt.G_SQLCODE_TOKEN
331: ,p_token1_value => SQLCODE
332: ,p_token2 => Okl_Psy_Pvt.G_SQLERRM_TOKEN
333: ,p_token2_value => SQLERRM);

Line 330: ,p_token1 => Okl_Psy_Pvt.G_SQLCODE_TOKEN

326: NULL;
327: WHEN OTHERS THEN
328: Okc_Api.SET_MESSAGE( p_app_name => Okl_Psy_Pvt.G_APP_NAME
329: ,p_msg_name => Okl_Psy_Pvt.G_UNEXPECTED_ERROR
330: ,p_token1 => Okl_Psy_Pvt.G_SQLCODE_TOKEN
331: ,p_token1_value => SQLCODE
332: ,p_token2 => Okl_Psy_Pvt.G_SQLERRM_TOKEN
333: ,p_token2_value => SQLERRM);
334: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

Line 332: ,p_token2 => Okl_Psy_Pvt.G_SQLERRM_TOKEN

328: Okc_Api.SET_MESSAGE( p_app_name => Okl_Psy_Pvt.G_APP_NAME
329: ,p_msg_name => Okl_Psy_Pvt.G_UNEXPECTED_ERROR
330: ,p_token1 => Okl_Psy_Pvt.G_SQLCODE_TOKEN
331: ,p_token1_value => SQLCODE
332: ,p_token2 => Okl_Psy_Pvt.G_SQLERRM_TOKEN
333: ,p_token2_value => SQLERRM);
334: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
335: END validate_sty_id;
336:

Line 366: Okl_Api.SET_MESSAGE( p_app_name => Okl_Psy_Pvt.G_APP_NAME

362: EXCEPTION
363: WHEN G_EXCEPTION_HALT_PROCESSING THEN
364: RETURN(l_return_status);
365: WHEN OTHERS THEN
366: Okl_Api.SET_MESSAGE( p_app_name => Okl_Psy_Pvt.G_APP_NAME
367: ,p_msg_name => Okl_Psy_Pvt.G_UNEXPECTED_ERROR
368: ,p_token1 => Okl_Psy_Pvt.G_SQLCODE_TOKEN
369: ,p_token1_value => SQLCODE
370: ,p_token2 => Okl_Psy_Pvt.G_SQLERRM_TOKEN

Line 367: ,p_msg_name => Okl_Psy_Pvt.G_UNEXPECTED_ERROR

363: WHEN G_EXCEPTION_HALT_PROCESSING THEN
364: RETURN(l_return_status);
365: WHEN OTHERS THEN
366: Okl_Api.SET_MESSAGE( p_app_name => Okl_Psy_Pvt.G_APP_NAME
367: ,p_msg_name => Okl_Psy_Pvt.G_UNEXPECTED_ERROR
368: ,p_token1 => Okl_Psy_Pvt.G_SQLCODE_TOKEN
369: ,p_token1_value => SQLCODE
370: ,p_token2 => Okl_Psy_Pvt.G_SQLERRM_TOKEN
371: ,p_token2_value => SQLERRM);

Line 368: ,p_token1 => Okl_Psy_Pvt.G_SQLCODE_TOKEN

364: RETURN(l_return_status);
365: WHEN OTHERS THEN
366: Okl_Api.SET_MESSAGE( p_app_name => Okl_Psy_Pvt.G_APP_NAME
367: ,p_msg_name => Okl_Psy_Pvt.G_UNEXPECTED_ERROR
368: ,p_token1 => Okl_Psy_Pvt.G_SQLCODE_TOKEN
369: ,p_token1_value => SQLCODE
370: ,p_token2 => Okl_Psy_Pvt.G_SQLERRM_TOKEN
371: ,p_token2_value => SQLERRM);
372: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

Line 370: ,p_token2 => Okl_Psy_Pvt.G_SQLERRM_TOKEN

366: Okl_Api.SET_MESSAGE( p_app_name => Okl_Psy_Pvt.G_APP_NAME
367: ,p_msg_name => Okl_Psy_Pvt.G_UNEXPECTED_ERROR
368: ,p_token1 => Okl_Psy_Pvt.G_SQLCODE_TOKEN
369: ,p_token1_value => SQLCODE
370: ,p_token2 => Okl_Psy_Pvt.G_SQLERRM_TOKEN
371: ,p_token2_value => SQLERRM);
372: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
373: RETURN(l_return_status);
374: END Validate_Attributes;