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_TRY_PVT dependencies on OKL_API

Line 413: if (l_tryv_rec.formula_yn = Okl_Api.G_MISS_CHAR) then

409: l_tryv_rec.tax_schedule_yn := null;
410: end if;
411: --Bug 4386433 - End of Changes
412: --Bug 5707866 dpsingh
413: if (l_tryv_rec.formula_yn = Okl_Api.G_MISS_CHAR) then
414: l_tryv_rec.formula_yn := null;
415: end if;
416: if (l_tryv_rec.accounting_event_class_code = Okl_Api.G_MISS_CHAR) then
417: l_tryv_rec.accounting_event_class_code := null;

Line 416: if (l_tryv_rec.accounting_event_class_code = Okl_Api.G_MISS_CHAR) then

412: --Bug 5707866 dpsingh
413: if (l_tryv_rec.formula_yn = Okl_Api.G_MISS_CHAR) then
414: l_tryv_rec.formula_yn := null;
415: end if;
416: if (l_tryv_rec.accounting_event_class_code = Okl_Api.G_MISS_CHAR) then
417: l_tryv_rec.accounting_event_class_code := null;
418: end if;
419: return(l_tryv_rec);
420: end null_out_defaults;

Line 1441: l_dummy varchar2(1) := OKL_API.G_FALSE;

1437: procedure Validate_Formula_YN(
1438: x_return_status out NOCOPY varchar2
1439: ,p_tryv_rec in tryv_rec_type ) is
1440:
1441: l_dummy varchar2(1) := OKL_API.G_FALSE;
1442:
1443: begin
1444:
1445: -- initialize return status

Line 1446: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

1442:
1443: begin
1444:
1445: -- initialize return status
1446: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
1447:
1448: IF p_tryv_rec.formula_yn IS NOT NULL THEN
1449: --Check if formula_yn exists in the fnd_common_lookups or not
1450: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_LOOKUP_CODE(p_lookup_type => 'OKL_YES_NO',

Line 1454: IF l_dummy = OKL_API.G_FALSE THEN

1450: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_LOOKUP_CODE(p_lookup_type => 'OKL_YES_NO',
1451: p_lookup_code => p_tryv_rec.formula_yn,
1452: p_app_id => 540,
1453: p_view_app_id => 0);
1454: IF l_dummy = OKL_API.G_FALSE THEN
1455: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
1456: p_msg_name => g_invalid_value,
1457: p_token1 => g_col_name_token,
1458: p_token1_value => 'formula_yn');

Line 1455: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,

1451: p_lookup_code => p_tryv_rec.formula_yn,
1452: p_app_id => 540,
1453: p_view_app_id => 0);
1454: IF l_dummy = OKL_API.G_FALSE THEN
1455: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
1456: p_msg_name => g_invalid_value,
1457: p_token1 => g_col_name_token,
1458: p_token1_value => 'formula_yn');
1459: x_return_status := Okl_Api.G_RET_STS_ERROR;

Line 1459: x_return_status := Okl_Api.G_RET_STS_ERROR;

1455: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
1456: p_msg_name => g_invalid_value,
1457: p_token1 => g_col_name_token,
1458: p_token1_value => 'formula_yn');
1459: x_return_status := Okl_Api.G_RET_STS_ERROR;
1460: RAISE G_EXCEPTION_HALT_VALIDATION;
1461: END IF;
1462: END IF;
1463:

Line 1472: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,

1468: null;
1469:
1470: when OTHERS then
1471: -- store SQL error message on message stack for caller
1472: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
1473: p_msg_name => g_unexpected_error,
1474: p_token1 => g_sqlcode_token,
1475: p_token1_value => SQLCODE,
1476: p_token2 => g_sqlerrm_token,

Line 1480: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

1476: p_token2 => g_sqlerrm_token,
1477: p_token2_value => SQLERRM);
1478:
1479: -- notify caller of an UNEXPECTED error
1480: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
1481:
1482: end Validate_Formula_YN;
1483:
1484:

Line 1502: l_dummy varchar2(1) := OKL_API.G_FALSE;

1498: procedure Validate_Accnt_Evnt_Class_Cde(
1499: x_return_status out NOCOPY varchar2
1500: ,p_tryv_rec in tryv_rec_type ) is
1501:
1502: l_dummy varchar2(1) := OKL_API.G_FALSE;
1503:
1504: begin
1505:
1506: -- initialize return status

Line 1507: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

1503:
1504: begin
1505:
1506: -- initialize return status
1507: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
1508:
1509: IF p_tryv_rec.accounting_event_class_code IS NOT NULL THEN
1510: --Check if accounting_event_class_code exists in the fnd_common_lookups or not
1511: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_LOOKUP_CODE(p_lookup_type => 'OKL_ACCOUNTING_EVENT_CLASS',

Line 1515: IF l_dummy = OKL_API.G_FALSE THEN

1511: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_LOOKUP_CODE(p_lookup_type => 'OKL_ACCOUNTING_EVENT_CLASS',
1512: p_lookup_code => p_tryv_rec.accounting_event_class_code,
1513: p_app_id => 540,
1514: p_view_app_id => 0);
1515: IF l_dummy = OKL_API.G_FALSE THEN
1516: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
1517: p_msg_name => g_invalid_value,
1518: p_token1 => g_col_name_token,
1519: p_token1_value => 'accounting_event_class_code');

Line 1516: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,

1512: p_lookup_code => p_tryv_rec.accounting_event_class_code,
1513: p_app_id => 540,
1514: p_view_app_id => 0);
1515: IF l_dummy = OKL_API.G_FALSE THEN
1516: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
1517: p_msg_name => g_invalid_value,
1518: p_token1 => g_col_name_token,
1519: p_token1_value => 'accounting_event_class_code');
1520: x_return_status := Okl_Api.G_RET_STS_ERROR;

Line 1520: x_return_status := Okl_Api.G_RET_STS_ERROR;

1516: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
1517: p_msg_name => g_invalid_value,
1518: p_token1 => g_col_name_token,
1519: p_token1_value => 'accounting_event_class_code');
1520: x_return_status := Okl_Api.G_RET_STS_ERROR;
1521: RAISE G_EXCEPTION_HALT_VALIDATION;
1522: END IF;
1523: END IF;
1524:

Line 1533: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,

1529: null;
1530:
1531: when OTHERS then
1532: -- store SQL error message on message stack for caller
1533: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
1534: p_msg_name => g_unexpected_error,
1535: p_token1 => g_sqlcode_token,
1536: p_token1_value => SQLCODE,
1537: p_token2 => g_sqlerrm_token,

Line 1541: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

1537: p_token2 => g_sqlerrm_token,
1538: p_token2_value => SQLERRM);
1539:
1540: -- notify caller of an UNEXPECTED error
1541: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
1542:
1543: end Validate_Accnt_Evnt_Class_Cde;
1544:
1545: ---------------------------------------------------------------------------

Line 3171: if (x_try_rec.formula_yn = Okl_Api.G_MISS_CHAR)

3167: x_try_rec.tax_schedule_yn := l_try_rec.tax_schedule_yn;
3168: end if;
3169: --Bug 4386433 - End of Changes
3170: --Bug 5707866 dpsingh
3171: if (x_try_rec.formula_yn = Okl_Api.G_MISS_CHAR)
3172: then
3173: x_try_rec.formula_yn := l_try_rec.formula_yn;
3174: end if;
3175: if (x_try_rec.accounting_event_class_code = Okl_Api.G_MISS_CHAR)

Line 3175: if (x_try_rec.accounting_event_class_code = Okl_Api.G_MISS_CHAR)

3171: if (x_try_rec.formula_yn = Okl_Api.G_MISS_CHAR)
3172: then
3173: x_try_rec.formula_yn := l_try_rec.formula_yn;
3174: end if;
3175: if (x_try_rec.accounting_event_class_code = Okl_Api.G_MISS_CHAR)
3176: then
3177: x_try_rec.accounting_event_class_code := l_try_rec.accounting_event_class_code;
3178: end if;
3179: return(l_return_status);

Line 3603: if (x_tryv_rec.formula_yn = Okl_Api.G_MISS_CHAR)

3599: x_tryv_rec.tax_schedule_yn := l_tryv_rec.tax_schedule_yn;
3600: end if;
3601: --Bug 4386433 - End of Changes
3602: --Bug 5707866 dpsingh
3603: if (x_tryv_rec.formula_yn = Okl_Api.G_MISS_CHAR)
3604: then
3605: x_tryv_rec.formula_yn := l_tryv_rec.formula_yn;
3606: end if;
3607: if (x_tryv_rec.accounting_event_class_code = Okl_Api.G_MISS_CHAR)

Line 3607: if (x_tryv_rec.accounting_event_class_code = Okl_Api.G_MISS_CHAR)

3603: if (x_tryv_rec.formula_yn = Okl_Api.G_MISS_CHAR)
3604: then
3605: x_tryv_rec.formula_yn := l_tryv_rec.formula_yn;
3606: end if;
3607: if (x_tryv_rec.accounting_event_class_code = Okl_Api.G_MISS_CHAR)
3608: then
3609: x_tryv_rec.accounting_event_class_code := l_tryv_rec.accounting_event_class_code;
3610: end if;
3611: return(l_return_status);

Line 4395: l_return_status varchar2(1) := okl_api.g_ret_sts_success;

4391: p_accounting_event_class_code IN VARCHAR2) IS
4392:
4393: l_api_version CONSTANT number := 1;
4394: l_api_name CONSTANT varchar2(30) := 'LOAD_SEED_ROW';
4395: l_return_status varchar2(1) := okl_api.g_ret_sts_success;
4396: l_msg_count number;
4397: l_msg_data varchar2(4000);
4398: l_init_msg_list VARCHAR2(1):= 'T';
4399: l_tryv_rec tryv_rec_type;