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_SETUPOVERULES_PVT dependencies on OKL_OVD_PVT

Line 244: ---Okl_Api.set_message('OKL','OKL_COLUMN_NOT_UNIQUE', 'OKL_TABLE_NAME',l_token_1,Okl_Ovd_Pvt.G_COL_NAME_TOKEN,l_token_3);

240: FETCH c1 INTO l_ovd_status;
241: l_row_found := c1%FOUND;
242: CLOSE c1;
243: IF l_row_found THEN
244: ---Okl_Api.set_message('OKL','OKL_COLUMN_NOT_UNIQUE', 'OKL_TABLE_NAME',l_token_1,Okl_Ovd_Pvt.G_COL_NAME_TOKEN,l_token_3);
245: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
246: p_msg_name => 'OKL_COLUMN_NOT_UNIQUE',
247: p_token1 => G_TABLE_TOKEN,
248: p_token1_value => l_token_1,

Line 369: Okl_Api.SET_MESSAGE(p_app_name => Okl_Ovd_Pvt.g_app_name

365:
366: -- check for data before processing
367: IF (p_ovdv_rec.orl_id IS NULL) OR
368: (p_ovdv_rec.orl_id = Okl_Api.G_MISS_NUM) THEN
369: Okl_Api.SET_MESSAGE(p_app_name => Okl_Ovd_Pvt.g_app_name
370: ,p_msg_name => Okl_Ovd_Pvt.g_required_value
371: ,p_token1 => Okl_Ovd_Pvt.g_col_name_token
372: ,p_token1_value => l_token_1);
373: x_return_status := Okl_Api.G_RET_STS_ERROR;

Line 370: ,p_msg_name => Okl_Ovd_Pvt.g_required_value

366: -- check for data before processing
367: IF (p_ovdv_rec.orl_id IS NULL) OR
368: (p_ovdv_rec.orl_id = Okl_Api.G_MISS_NUM) THEN
369: Okl_Api.SET_MESSAGE(p_app_name => Okl_Ovd_Pvt.g_app_name
370: ,p_msg_name => Okl_Ovd_Pvt.g_required_value
371: ,p_token1 => Okl_Ovd_Pvt.g_col_name_token
372: ,p_token1_value => l_token_1);
373: x_return_status := Okl_Api.G_RET_STS_ERROR;
374: RAISE G_EXCEPTION_HALT_PROCESSING;

Line 371: ,p_token1 => Okl_Ovd_Pvt.g_col_name_token

367: IF (p_ovdv_rec.orl_id IS NULL) OR
368: (p_ovdv_rec.orl_id = Okl_Api.G_MISS_NUM) THEN
369: Okl_Api.SET_MESSAGE(p_app_name => Okl_Ovd_Pvt.g_app_name
370: ,p_msg_name => Okl_Ovd_Pvt.g_required_value
371: ,p_token1 => Okl_Ovd_Pvt.g_col_name_token
372: ,p_token1_value => l_token_1);
373: x_return_status := Okl_Api.G_RET_STS_ERROR;
374: RAISE G_EXCEPTION_HALT_PROCESSING;
375: END IF;

Line 384: Okl_Api.set_message(Okl_Ovd_Pvt.G_APP_NAME, Okl_Ovd_Pvt.G_INVALID_VALUE,Okl_Ovd_Pvt.G_COL_NAME_TOKEN,l_token_1);

380: FETCH okl_orlv_pk_csr INTO l_orl_status;
381: l_row_notfound := okl_orlv_pk_csr%NOTFOUND;
382: CLOSE okl_orlv_pk_csr;
383: IF (l_row_notfound) THEN
384: Okl_Api.set_message(Okl_Ovd_Pvt.G_APP_NAME, Okl_Ovd_Pvt.G_INVALID_VALUE,Okl_Ovd_Pvt.G_COL_NAME_TOKEN,l_token_1);
385: RAISE G_ITEM_NOT_FOUND_ERROR;
386: END IF;
387: END IF;
388:

Line 399: Okl_Api.SET_MESSAGE(p_app_name => Okl_Ovd_Pvt.g_app_name,

395: x_return_status := Okl_Api.G_RET_STS_ERROR;
396:
397: WHEN OTHERS THEN
398: -- store SQL error message on message stack for caller
399: Okl_Api.SET_MESSAGE(p_app_name => Okl_Ovd_Pvt.g_app_name,
400: p_msg_name => Okl_Ovd_Pvt.g_unexpected_error,
401: p_token1 => Okl_Ovd_Pvt.g_sqlcode_token,
402: p_token1_value => SQLCODE,
403: p_token2 => Okl_Ovd_Pvt.g_sqlerrm_token,

Line 400: p_msg_name => Okl_Ovd_Pvt.g_unexpected_error,

396:
397: WHEN OTHERS THEN
398: -- store SQL error message on message stack for caller
399: Okl_Api.SET_MESSAGE(p_app_name => Okl_Ovd_Pvt.g_app_name,
400: p_msg_name => Okl_Ovd_Pvt.g_unexpected_error,
401: p_token1 => Okl_Ovd_Pvt.g_sqlcode_token,
402: p_token1_value => SQLCODE,
403: p_token2 => Okl_Ovd_Pvt.g_sqlerrm_token,
404: p_token2_value => SQLERRM);

Line 401: p_token1 => Okl_Ovd_Pvt.g_sqlcode_token,

397: WHEN OTHERS THEN
398: -- store SQL error message on message stack for caller
399: Okl_Api.SET_MESSAGE(p_app_name => Okl_Ovd_Pvt.g_app_name,
400: p_msg_name => Okl_Ovd_Pvt.g_unexpected_error,
401: p_token1 => Okl_Ovd_Pvt.g_sqlcode_token,
402: p_token1_value => SQLCODE,
403: p_token2 => Okl_Ovd_Pvt.g_sqlerrm_token,
404: p_token2_value => SQLERRM);
405:

Line 403: p_token2 => Okl_Ovd_Pvt.g_sqlerrm_token,

399: Okl_Api.SET_MESSAGE(p_app_name => Okl_Ovd_Pvt.g_app_name,
400: p_msg_name => Okl_Ovd_Pvt.g_unexpected_error,
401: p_token1 => Okl_Ovd_Pvt.g_sqlcode_token,
402: p_token1_value => SQLCODE,
403: p_token2 => Okl_Ovd_Pvt.g_sqlerrm_token,
404: p_token2_value => SQLERRM);
405:
406: -- notify caller of an UNEXPECTED error
407: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

Line 436: l_return_status := Okl_Accounting_Util.validate_lookup_code(Okl_Ovd_Pvt.G_LOOKUP_TYPE,p_ovdv_rec.copy_or_enter_flag);

432: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
433:
434: l_token_1 := Okl_Accounting_Util.Get_Message_Token('OKL_LP_OPTVAL_RULE_CR_UPD','OKL_ACTION');
435: -- check for data before processing
436: l_return_status := Okl_Accounting_Util.validate_lookup_code(Okl_Ovd_Pvt.G_LOOKUP_TYPE,p_ovdv_rec.copy_or_enter_flag);
437:
438: IF l_return_status = Okl_Api.G_FALSE THEN
439: l_return_status := Okl_Api.G_RET_STS_ERROR;
440: END IF;

Line 445: Okl_Api.SET_MESSAGE(p_app_name => Okl_Ovd_Pvt.g_app_name

441:
442:
443:
444: IF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
445: Okl_Api.SET_MESSAGE(p_app_name => Okl_Ovd_Pvt.g_app_name
446: ,p_msg_name => Okl_Ovd_Pvt.g_required_value
447: ,p_token1 => Okl_Ovd_Pvt.g_col_name_token
448: ,p_token1_value => l_token_1);
449: x_return_status := Okl_Api.G_RET_STS_ERROR;

Line 446: ,p_msg_name => Okl_Ovd_Pvt.g_required_value

442:
443:
444: IF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
445: Okl_Api.SET_MESSAGE(p_app_name => Okl_Ovd_Pvt.g_app_name
446: ,p_msg_name => Okl_Ovd_Pvt.g_required_value
447: ,p_token1 => Okl_Ovd_Pvt.g_col_name_token
448: ,p_token1_value => l_token_1);
449: x_return_status := Okl_Api.G_RET_STS_ERROR;
450: RAISE G_EXCEPTION_HALT_PROCESSING;

Line 447: ,p_token1 => Okl_Ovd_Pvt.g_col_name_token

443:
444: IF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
445: Okl_Api.SET_MESSAGE(p_app_name => Okl_Ovd_Pvt.g_app_name
446: ,p_msg_name => Okl_Ovd_Pvt.g_required_value
447: ,p_token1 => Okl_Ovd_Pvt.g_col_name_token
448: ,p_token1_value => l_token_1);
449: x_return_status := Okl_Api.G_RET_STS_ERROR;
450: RAISE G_EXCEPTION_HALT_PROCESSING;
451: END IF;

Line 461: Okl_Api.SET_MESSAGE(p_app_name => Okl_Ovd_Pvt.g_app_name,

457: NULL;
458:
459: WHEN OTHERS THEN
460: -- store SQL error message on message stack for caller
461: Okl_Api.SET_MESSAGE(p_app_name => Okl_Ovd_Pvt.g_app_name,
462: p_msg_name => Okl_Ovd_Pvt.g_unexpected_error,
463: p_token1 => Okl_Ovd_Pvt.g_sqlcode_token,
464: p_token1_value => SQLCODE,
465: p_token2 => Okl_Ovd_Pvt.g_sqlerrm_token,

Line 462: p_msg_name => Okl_Ovd_Pvt.g_unexpected_error,

458:
459: WHEN OTHERS THEN
460: -- store SQL error message on message stack for caller
461: Okl_Api.SET_MESSAGE(p_app_name => Okl_Ovd_Pvt.g_app_name,
462: p_msg_name => Okl_Ovd_Pvt.g_unexpected_error,
463: p_token1 => Okl_Ovd_Pvt.g_sqlcode_token,
464: p_token1_value => SQLCODE,
465: p_token2 => Okl_Ovd_Pvt.g_sqlerrm_token,
466: p_token2_value => SQLERRM);

Line 463: p_token1 => Okl_Ovd_Pvt.g_sqlcode_token,

459: WHEN OTHERS THEN
460: -- store SQL error message on message stack for caller
461: Okl_Api.SET_MESSAGE(p_app_name => Okl_Ovd_Pvt.g_app_name,
462: p_msg_name => Okl_Ovd_Pvt.g_unexpected_error,
463: p_token1 => Okl_Ovd_Pvt.g_sqlcode_token,
464: p_token1_value => SQLCODE,
465: p_token2 => Okl_Ovd_Pvt.g_sqlerrm_token,
466: p_token2_value => SQLERRM);
467:

Line 465: p_token2 => Okl_Ovd_Pvt.g_sqlerrm_token,

461: Okl_Api.SET_MESSAGE(p_app_name => Okl_Ovd_Pvt.g_app_name,
462: p_msg_name => Okl_Ovd_Pvt.g_unexpected_error,
463: p_token1 => Okl_Ovd_Pvt.g_sqlcode_token,
464: p_token1_value => SQLCODE,
465: p_token2 => Okl_Ovd_Pvt.g_sqlerrm_token,
466: p_token2_value => SQLERRM);
467:
468: -- notify caller of an UNEXPECTED error
469: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

Line 498: l_return_status := Okl_Accounting_Util.validate_lookup_code(Okl_Ovd_Pvt.G_INTENT_TYPE,p_ovdv_rec.context_intent);

494: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
495:
496: l_token_1 := Okl_Accounting_Util.Get_Message_Token('OKL_LP_OPTVAL_RULE_CR_UPD','OKL_INTENT');
497: -- check for data before processing
498: l_return_status := Okl_Accounting_Util.validate_lookup_code(Okl_Ovd_Pvt.G_INTENT_TYPE,p_ovdv_rec.context_intent);
499: IF l_return_status = Okl_Api.G_FALSE THEN
500: l_return_status := Okl_Api.G_RET_STS_ERROR;
501: END IF;
502:

Line 505: Okl_Api.SET_MESSAGE(p_app_name => Okl_Ovd_Pvt.g_app_name

501: END IF;
502:
503:
504: IF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
505: Okl_Api.SET_MESSAGE(p_app_name => Okl_Ovd_Pvt.g_app_name
506: ,p_msg_name => Okl_Ovd_Pvt.g_required_value
507: ,p_token1 => Okl_Ovd_Pvt.g_col_name_token
508: ,p_token1_value => l_token_1);
509: x_return_status := Okl_Api.G_RET_STS_ERROR;

Line 506: ,p_msg_name => Okl_Ovd_Pvt.g_required_value

502:
503:
504: IF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
505: Okl_Api.SET_MESSAGE(p_app_name => Okl_Ovd_Pvt.g_app_name
506: ,p_msg_name => Okl_Ovd_Pvt.g_required_value
507: ,p_token1 => Okl_Ovd_Pvt.g_col_name_token
508: ,p_token1_value => l_token_1);
509: x_return_status := Okl_Api.G_RET_STS_ERROR;
510: RAISE G_EXCEPTION_HALT_PROCESSING;

Line 507: ,p_token1 => Okl_Ovd_Pvt.g_col_name_token

503:
504: IF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
505: Okl_Api.SET_MESSAGE(p_app_name => Okl_Ovd_Pvt.g_app_name
506: ,p_msg_name => Okl_Ovd_Pvt.g_required_value
507: ,p_token1 => Okl_Ovd_Pvt.g_col_name_token
508: ,p_token1_value => l_token_1);
509: x_return_status := Okl_Api.G_RET_STS_ERROR;
510: RAISE G_EXCEPTION_HALT_PROCESSING;
511: END IF;

Line 521: Okl_Api.SET_MESSAGE(p_app_name => Okl_Ovd_Pvt.g_app_name,

517: NULL;
518:
519: WHEN OTHERS THEN
520: -- store SQL error message on message stack for caller
521: Okl_Api.SET_MESSAGE(p_app_name => Okl_Ovd_Pvt.g_app_name,
522: p_msg_name => Okl_Ovd_Pvt.g_unexpected_error,
523: p_token1 => Okl_Ovd_Pvt.g_sqlcode_token,
524: p_token1_value => SQLCODE,
525: p_token2 => Okl_Ovd_Pvt.g_sqlerrm_token,

Line 522: p_msg_name => Okl_Ovd_Pvt.g_unexpected_error,

518:
519: WHEN OTHERS THEN
520: -- store SQL error message on message stack for caller
521: Okl_Api.SET_MESSAGE(p_app_name => Okl_Ovd_Pvt.g_app_name,
522: p_msg_name => Okl_Ovd_Pvt.g_unexpected_error,
523: p_token1 => Okl_Ovd_Pvt.g_sqlcode_token,
524: p_token1_value => SQLCODE,
525: p_token2 => Okl_Ovd_Pvt.g_sqlerrm_token,
526: p_token2_value => SQLERRM);

Line 523: p_token1 => Okl_Ovd_Pvt.g_sqlcode_token,

519: WHEN OTHERS THEN
520: -- store SQL error message on message stack for caller
521: Okl_Api.SET_MESSAGE(p_app_name => Okl_Ovd_Pvt.g_app_name,
522: p_msg_name => Okl_Ovd_Pvt.g_unexpected_error,
523: p_token1 => Okl_Ovd_Pvt.g_sqlcode_token,
524: p_token1_value => SQLCODE,
525: p_token2 => Okl_Ovd_Pvt.g_sqlerrm_token,
526: p_token2_value => SQLERRM);
527:

Line 525: p_token2 => Okl_Ovd_Pvt.g_sqlerrm_token,

521: Okl_Api.SET_MESSAGE(p_app_name => Okl_Ovd_Pvt.g_app_name,
522: p_msg_name => Okl_Ovd_Pvt.g_unexpected_error,
523: p_token1 => Okl_Ovd_Pvt.g_sqlcode_token,
524: p_token1_value => SQLCODE,
525: p_token2 => Okl_Ovd_Pvt.g_sqlerrm_token,
526: p_token2_value => SQLERRM);
527:
528: -- notify caller of an UNEXPECTED error
529: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;