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_SETUPTQYVALUES_PVT dependencies on OKL_PTV_PVT

Line 188: Okl_Api.set_message(G_APP_NAME,Okl_Ptv_Pvt.G_UNQS,Okl_Ptv_Pvt.G_TABLE_TOKEN, l_token_1); ---CHG001

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

Line 285: Okl_Api.SET_MESSAGE(p_app_name => Okl_Ptv_Pvt.g_app_name

281:
282: -- check for data before processing
283: IF (p_ptvv_rec.from_date IS NULL) OR
284: (p_ptvv_rec.from_date = Okl_Api.G_MISS_DATE) THEN
285: Okl_Api.SET_MESSAGE(p_app_name => Okl_Ptv_Pvt.g_app_name
286: ,p_msg_name => Okl_Ptv_Pvt.g_required_value
287: ,p_token1 => Okl_Ptv_Pvt.g_col_name_token
288: ,p_token1_value => l_token_1);
289: x_return_status := Okl_Api.G_RET_STS_ERROR;

Line 286: ,p_msg_name => Okl_Ptv_Pvt.g_required_value

282: -- check for data before processing
283: IF (p_ptvv_rec.from_date IS NULL) OR
284: (p_ptvv_rec.from_date = Okl_Api.G_MISS_DATE) THEN
285: Okl_Api.SET_MESSAGE(p_app_name => Okl_Ptv_Pvt.g_app_name
286: ,p_msg_name => Okl_Ptv_Pvt.g_required_value
287: ,p_token1 => Okl_Ptv_Pvt.g_col_name_token
288: ,p_token1_value => l_token_1);
289: x_return_status := Okl_Api.G_RET_STS_ERROR;
290: RAISE G_EXCEPTION_HALT_PROCESSING;

Line 287: ,p_token1 => Okl_Ptv_Pvt.g_col_name_token

283: IF (p_ptvv_rec.from_date IS NULL) OR
284: (p_ptvv_rec.from_date = Okl_Api.G_MISS_DATE) THEN
285: Okl_Api.SET_MESSAGE(p_app_name => Okl_Ptv_Pvt.g_app_name
286: ,p_msg_name => Okl_Ptv_Pvt.g_required_value
287: ,p_token1 => Okl_Ptv_Pvt.g_col_name_token
288: ,p_token1_value => l_token_1);
289: x_return_status := Okl_Api.G_RET_STS_ERROR;
290: RAISE G_EXCEPTION_HALT_PROCESSING;
291: END IF;

Line 301: Okl_Api.SET_MESSAGE(p_app_name => Okl_Ptv_Pvt.g_app_name,

297: NULL;
298:
299: WHEN OTHERS THEN
300: -- store SQL error message on message stack for caller
301: Okl_Api.SET_MESSAGE(p_app_name => Okl_Ptv_Pvt.g_app_name,
302: p_msg_name => Okl_Ptv_Pvt.g_unexpected_error,
303: p_token1 => Okl_Ptv_Pvt.g_sqlcode_token,
304: p_token1_value => SQLCODE,
305: p_token2 => Okl_Ptv_Pvt.g_sqlerrm_token,

Line 302: p_msg_name => Okl_Ptv_Pvt.g_unexpected_error,

298:
299: WHEN OTHERS THEN
300: -- store SQL error message on message stack for caller
301: Okl_Api.SET_MESSAGE(p_app_name => Okl_Ptv_Pvt.g_app_name,
302: p_msg_name => Okl_Ptv_Pvt.g_unexpected_error,
303: p_token1 => Okl_Ptv_Pvt.g_sqlcode_token,
304: p_token1_value => SQLCODE,
305: p_token2 => Okl_Ptv_Pvt.g_sqlerrm_token,
306: p_token2_value => SQLERRM);

Line 303: p_token1 => Okl_Ptv_Pvt.g_sqlcode_token,

299: WHEN OTHERS THEN
300: -- store SQL error message on message stack for caller
301: Okl_Api.SET_MESSAGE(p_app_name => Okl_Ptv_Pvt.g_app_name,
302: p_msg_name => Okl_Ptv_Pvt.g_unexpected_error,
303: p_token1 => Okl_Ptv_Pvt.g_sqlcode_token,
304: p_token1_value => SQLCODE,
305: p_token2 => Okl_Ptv_Pvt.g_sqlerrm_token,
306: p_token2_value => SQLERRM);
307:

Line 305: p_token2 => Okl_Ptv_Pvt.g_sqlerrm_token,

301: Okl_Api.SET_MESSAGE(p_app_name => Okl_Ptv_Pvt.g_app_name,
302: p_msg_name => Okl_Ptv_Pvt.g_unexpected_error,
303: p_token1 => Okl_Ptv_Pvt.g_sqlcode_token,
304: p_token1_value => SQLCODE,
305: p_token2 => Okl_Ptv_Pvt.g_sqlerrm_token,
306: p_token2_value => SQLERRM);
307:
308: -- notify caller of an UNEXPECTED error
309: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

Line 340: Okl_Api.SET_MESSAGE(p_app_name => Okl_Ptv_Pvt.g_app_name

336:
337: -- check for data before processing
338: IF (p_ptvv_rec.value IS NULL) OR
339: (p_ptvv_rec.value = Okl_Api.G_MISS_CHAR) THEN
340: Okl_Api.SET_MESSAGE(p_app_name => Okl_Ptv_Pvt.g_app_name
341: ,p_msg_name => Okl_Ptv_Pvt.g_required_value
342: ,p_token1 => Okl_Ptv_Pvt.g_col_name_token
343: ,p_token1_value => l_token_1);
344: x_return_status := Okl_Api.G_RET_STS_ERROR;

Line 341: ,p_msg_name => Okl_Ptv_Pvt.g_required_value

337: -- check for data before processing
338: IF (p_ptvv_rec.value IS NULL) OR
339: (p_ptvv_rec.value = Okl_Api.G_MISS_CHAR) THEN
340: Okl_Api.SET_MESSAGE(p_app_name => Okl_Ptv_Pvt.g_app_name
341: ,p_msg_name => Okl_Ptv_Pvt.g_required_value
342: ,p_token1 => Okl_Ptv_Pvt.g_col_name_token
343: ,p_token1_value => l_token_1);
344: x_return_status := Okl_Api.G_RET_STS_ERROR;
345: RAISE G_EXCEPTION_HALT_PROCESSING;

Line 342: ,p_token1 => Okl_Ptv_Pvt.g_col_name_token

338: IF (p_ptvv_rec.value IS NULL) OR
339: (p_ptvv_rec.value = Okl_Api.G_MISS_CHAR) THEN
340: Okl_Api.SET_MESSAGE(p_app_name => Okl_Ptv_Pvt.g_app_name
341: ,p_msg_name => Okl_Ptv_Pvt.g_required_value
342: ,p_token1 => Okl_Ptv_Pvt.g_col_name_token
343: ,p_token1_value => l_token_1);
344: x_return_status := Okl_Api.G_RET_STS_ERROR;
345: RAISE G_EXCEPTION_HALT_PROCESSING;
346: END IF;

Line 358: Okl_Api.SET_MESSAGE(p_app_name => Okl_Ptv_Pvt.g_app_name,

354: NULL;
355:
356: WHEN OTHERS THEN
357: -- store SQL error message on message stack for caller
358: Okl_Api.SET_MESSAGE(p_app_name => Okl_Ptv_Pvt.g_app_name,
359: p_msg_name => Okl_Ptv_Pvt.g_unexpected_error,
360: p_token1 => Okl_Ptv_Pvt.g_sqlcode_token,
361: p_token1_value => SQLCODE,
362: p_token2 => Okl_Ptv_Pvt.g_sqlerrm_token,

Line 359: p_msg_name => Okl_Ptv_Pvt.g_unexpected_error,

355:
356: WHEN OTHERS THEN
357: -- store SQL error message on message stack for caller
358: Okl_Api.SET_MESSAGE(p_app_name => Okl_Ptv_Pvt.g_app_name,
359: p_msg_name => Okl_Ptv_Pvt.g_unexpected_error,
360: p_token1 => Okl_Ptv_Pvt.g_sqlcode_token,
361: p_token1_value => SQLCODE,
362: p_token2 => Okl_Ptv_Pvt.g_sqlerrm_token,
363: p_token2_value => SQLERRM);

Line 360: p_token1 => Okl_Ptv_Pvt.g_sqlcode_token,

356: WHEN OTHERS THEN
357: -- store SQL error message on message stack for caller
358: Okl_Api.SET_MESSAGE(p_app_name => Okl_Ptv_Pvt.g_app_name,
359: p_msg_name => Okl_Ptv_Pvt.g_unexpected_error,
360: p_token1 => Okl_Ptv_Pvt.g_sqlcode_token,
361: p_token1_value => SQLCODE,
362: p_token2 => Okl_Ptv_Pvt.g_sqlerrm_token,
363: p_token2_value => SQLERRM);
364:

Line 362: p_token2 => Okl_Ptv_Pvt.g_sqlerrm_token,

358: Okl_Api.SET_MESSAGE(p_app_name => Okl_Ptv_Pvt.g_app_name,
359: p_msg_name => Okl_Ptv_Pvt.g_unexpected_error,
360: p_token1 => Okl_Ptv_Pvt.g_sqlcode_token,
361: p_token1_value => SQLCODE,
362: p_token2 => Okl_Ptv_Pvt.g_sqlerrm_token,
363: p_token2_value => SQLERRM);
364:
365: -- notify caller of an UNEXPECTED error
366: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

Line 412: Okl_Api.SET_MESSAGE(p_app_name => Okl_Ptv_Pvt.g_app_name,

408: RETURN (l_return_status);
409:
410: WHEN OTHERS THEN
411: -- store SQL error message on message stack for caller
412: Okl_Api.SET_MESSAGE(p_app_name => Okl_Ptv_Pvt.g_app_name,
413: p_msg_name => Okl_Ptv_Pvt.g_unexpected_error,
414: p_token1 => Okl_Ptv_Pvt.g_sqlcode_token,
415: p_token1_value => SQLCODE,
416: p_token2 => Okl_Ptv_Pvt.g_sqlerrm_token,

Line 413: p_msg_name => Okl_Ptv_Pvt.g_unexpected_error,

409:
410: WHEN OTHERS THEN
411: -- store SQL error message on message stack for caller
412: Okl_Api.SET_MESSAGE(p_app_name => Okl_Ptv_Pvt.g_app_name,
413: p_msg_name => Okl_Ptv_Pvt.g_unexpected_error,
414: p_token1 => Okl_Ptv_Pvt.g_sqlcode_token,
415: p_token1_value => SQLCODE,
416: p_token2 => Okl_Ptv_Pvt.g_sqlerrm_token,
417: p_token2_value => SQLERRM);

Line 414: p_token1 => Okl_Ptv_Pvt.g_sqlcode_token,

410: WHEN OTHERS THEN
411: -- store SQL error message on message stack for caller
412: Okl_Api.SET_MESSAGE(p_app_name => Okl_Ptv_Pvt.g_app_name,
413: p_msg_name => Okl_Ptv_Pvt.g_unexpected_error,
414: p_token1 => Okl_Ptv_Pvt.g_sqlcode_token,
415: p_token1_value => SQLCODE,
416: p_token2 => Okl_Ptv_Pvt.g_sqlerrm_token,
417: p_token2_value => SQLERRM);
418: -- notify caller of an UNEXPECTED error

Line 416: p_token2 => Okl_Ptv_Pvt.g_sqlerrm_token,

412: Okl_Api.SET_MESSAGE(p_app_name => Okl_Ptv_Pvt.g_app_name,
413: p_msg_name => Okl_Ptv_Pvt.g_unexpected_error,
414: p_token1 => Okl_Ptv_Pvt.g_sqlcode_token,
415: p_token1_value => SQLCODE,
416: p_token2 => Okl_Ptv_Pvt.g_sqlerrm_token,
417: p_token2_value => SQLERRM);
418: -- notify caller of an UNEXPECTED error
419: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
420: RETURN(l_return_status);

Line 843: ,p_msg_name => Okl_Ptv_Pvt.g_to_date_error

839:
840: /* check for end date greater than start date */
841: IF (l_upd_ptvv_rec.TO_DATE IS NOT NULL) AND (l_upd_ptvv_rec.TO_DATE < l_upd_ptvv_rec.from_date) THEN
842: Okl_Api.SET_MESSAGE(p_app_name => g_app_name
843: ,p_msg_name => Okl_Ptv_Pvt.g_to_date_error
844: ,p_token1 => Okl_Ptv_Pvt.g_col_name_token
845: ,p_token1_value => 'TO_DATE');
846: x_return_status := Okl_Api.G_RET_STS_ERROR;
847: RAISE Okl_Api.G_EXCEPTION_ERROR;

Line 844: ,p_token1 => Okl_Ptv_Pvt.g_col_name_token

840: /* check for end date greater than start date */
841: IF (l_upd_ptvv_rec.TO_DATE IS NOT NULL) AND (l_upd_ptvv_rec.TO_DATE < l_upd_ptvv_rec.from_date) THEN
842: Okl_Api.SET_MESSAGE(p_app_name => g_app_name
843: ,p_msg_name => Okl_Ptv_Pvt.g_to_date_error
844: ,p_token1 => Okl_Ptv_Pvt.g_col_name_token
845: ,p_token1_value => 'TO_DATE');
846: x_return_status := Okl_Api.G_RET_STS_ERROR;
847: RAISE Okl_Api.G_EXCEPTION_ERROR;
848: END IF;