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

Line 1354: x_return_status := OKL_API.G_RET_STS_SUCCESS;

1350: --and trunc(sysdate) between trunc(nvl(start_date_active,sysdate))
1351: --and trunc(nvl(end_date_active,sysdate));
1352:
1353: Begin
1354: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1355: If p_talv_rec.asset_key_id <> OKL_API.G_MISS_NUM AND
1356: p_talv_rec.asset_key_id is NOT NULL then
1357: l_exists := 'N';
1358: open l_fak_csr(p_asset_key_id => p_talv_rec.asset_key_id);

Line 1355: If p_talv_rec.asset_key_id <> OKL_API.G_MISS_NUM AND

1351: --and trunc(nvl(end_date_active,sysdate));
1352:
1353: Begin
1354: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1355: If p_talv_rec.asset_key_id <> OKL_API.G_MISS_NUM AND
1356: p_talv_rec.asset_key_id is NOT NULL then
1357: l_exists := 'N';
1358: open l_fak_csr(p_asset_key_id => p_talv_rec.asset_key_id);
1359: fetch l_fak_csr into l_exists;

Line 1365: OKL_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'Asset Key');

1361: NULL;
1362: end if;
1363: close l_fak_csr;
1364: IF l_exists = 'N' then
1365: OKL_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'Asset Key');
1366: x_return_status := OKL_API.G_RET_STS_ERROR;
1367: RAISE G_EXCEPTION_HALT_VALIDATION;
1368: END IF;
1369: End If;

Line 1366: x_return_status := OKL_API.G_RET_STS_ERROR;

1362: end if;
1363: close l_fak_csr;
1364: IF l_exists = 'N' then
1365: OKL_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'Asset Key');
1366: x_return_status := OKL_API.G_RET_STS_ERROR;
1367: RAISE G_EXCEPTION_HALT_VALIDATION;
1368: END IF;
1369: End If;
1370:

Line 1379: OKL_API.SET_MESSAGE( p_app_name => G_APP_NAME

1375: If l_fak_csr%ISOPEN then
1376: close l_fak_csr;
1377: End If;
1378:
1379: OKL_API.SET_MESSAGE( p_app_name => G_APP_NAME
1380: ,p_msg_name => G_UNEXPECTED_ERROR
1381: ,p_token1 => G_SQLCODE_TOKEN
1382: ,p_token1_value => SQLCODE
1383: ,p_token2 => G_SQLERRM_TOKEN

Line 1385: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

1381: ,p_token1 => G_SQLCODE_TOKEN
1382: ,p_token1_value => SQLCODE
1383: ,p_token2 => G_SQLERRM_TOKEN
1384: ,p_token2_value => SQLERRM);
1385: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1386: END validate_asset_key;
1387:
1388:
1389: /************************ HAND-CODED *********************************/

Line 1415: x_return_status := OKL_API.G_RET_STS_SUCCESS;

1411: roundoff_error EXCEPTION;
1412:
1413: BEGIN
1414:
1415: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1416:
1417: -- Take original record values
1418: x_talv_rec := p_talv_rec;
1419:

Line 1430: p_talv_rec.original_cost <> OKL_API.G_MISS_NUM) THEN

1426: --dbms_output.put_line('Round off start '||l_currency_code);
1427: -- Round off all Asset Transaction Line Amounts
1428: IF (p_talv_rec.original_cost IS NOT NULL
1429: AND
1430: p_talv_rec.original_cost <> OKL_API.G_MISS_NUM) THEN
1431:
1432: l_conv_amount := NULL;
1433: l_conv_amount := okl_accounting_util.cross_currency_round_amount(
1434: p_amount => p_talv_rec.original_cost,

Line 1443: p_talv_rec.depreciation_cost <> OKL_API.G_MISS_NUM) THEN

1439: END IF;
1440:
1441: IF (p_talv_rec.depreciation_cost IS NOT NULL
1442: AND
1443: p_talv_rec.depreciation_cost <> OKL_API.G_MISS_NUM) THEN
1444:
1445: l_conv_amount := NULL;
1446: l_conv_amount := okl_accounting_util.cross_currency_round_amount(
1447: p_amount => p_talv_rec.depreciation_cost,

Line 1456: p_talv_rec.salvage_value <> OKL_API.G_MISS_NUM) THEN

1452: END IF;
1453:
1454: IF (p_talv_rec.salvage_value IS NOT NULL
1455: AND
1456: p_talv_rec.salvage_value <> OKL_API.G_MISS_NUM) THEN
1457:
1458: l_conv_amount := NULL;
1459: l_conv_amount := okl_accounting_util.cross_currency_round_amount(
1460: p_amount => p_talv_rec.salvage_value,

Line 1469: p_talv_rec.old_salvage_value <> OKL_API.G_MISS_NUM) THEN

1465: END IF;
1466:
1467: IF (p_talv_rec.old_salvage_value IS NOT NULL
1468: AND
1469: p_talv_rec.old_salvage_value <> OKL_API.G_MISS_NUM) THEN
1470:
1471: l_conv_amount := NULL;
1472: l_conv_amount := okl_accounting_util.cross_currency_round_amount(
1473: p_amount => p_talv_rec.old_salvage_value,

Line 1482: p_talv_rec.new_residual_value <> OKL_API.G_MISS_NUM) THEN

1478: END IF;
1479:
1480: IF (p_talv_rec.new_residual_value IS NOT NULL
1481: AND
1482: p_talv_rec.new_residual_value <> OKL_API.G_MISS_NUM) THEN
1483:
1484: l_conv_amount := NULL;
1485: l_conv_amount := okl_accounting_util.cross_currency_round_amount(
1486: p_amount => p_talv_rec.new_residual_value,

Line 1495: p_talv_rec.old_residual_value <> OKL_API.G_MISS_NUM) THEN

1491: END IF;
1492:
1493: IF (p_talv_rec.old_residual_value IS NOT NULL
1494: AND
1495: p_talv_rec.old_residual_value <> OKL_API.G_MISS_NUM) THEN
1496:
1497: l_conv_amount := NULL;
1498: l_conv_amount := okl_accounting_util.cross_currency_round_amount(
1499: p_amount => p_talv_rec.old_residual_value,

Line 1508: p_talv_rec.cost_retired <> OKL_API.G_MISS_NUM) THEN

1504: END IF;
1505:
1506: IF (p_talv_rec.cost_retired IS NOT NULL
1507: AND
1508: p_talv_rec.cost_retired <> OKL_API.G_MISS_NUM) THEN
1509:
1510: l_conv_amount := NULL;
1511: l_conv_amount := okl_accounting_util.cross_currency_round_amount(
1512: p_amount => p_talv_rec.cost_retired,

Line 1521: p_talv_rec.sale_proceeds <> OKL_API.G_MISS_NUM) THEN

1517: END IF;
1518:
1519: IF (p_talv_rec.sale_proceeds IS NOT NULL
1520: AND
1521: p_talv_rec.sale_proceeds <> OKL_API.G_MISS_NUM) THEN
1522:
1523: l_conv_amount := NULL;
1524: l_conv_amount := okl_accounting_util.cross_currency_round_amount(
1525: p_amount => p_talv_rec.sale_proceeds,

Line 1534: p_talv_rec.match_amount <> OKL_API.G_MISS_NUM) THEN

1530: END IF;
1531:
1532: IF (p_talv_rec.match_amount IS NOT NULL
1533: AND
1534: p_talv_rec.match_amount <> OKL_API.G_MISS_NUM) THEN
1535:
1536: l_conv_amount := NULL;
1537: l_conv_amount := okl_accounting_util.cross_currency_round_amount(
1538: p_amount => p_talv_rec.match_amount,

Line 1548: x_return_status := OKL_API.G_RET_STS_ERROR;

1544: --dbms_output.put_line('Round off complete');
1545:
1546: EXCEPTION
1547: WHEN roundoff_error THEN
1548: x_return_status := OKL_API.G_RET_STS_ERROR;
1549: END roundoff_line_amount;
1550:
1551:
1552: -- Multi-Currency Change

Line 2401: IF (l_talv_rec.asset_key_id = OKL_API.G_MISS_NUM) THEN

2397: IF (l_talv_rec.percent_salvage_value = OKC_API.G_MISS_NUM) THEN
2398: l_talv_rec.percent_salvage_value := NULL;
2399: END IF;
2400: --Bug# 2981308
2401: IF (l_talv_rec.asset_key_id = OKL_API.G_MISS_NUM) THEN
2402: l_talv_rec.asset_key_id := NULL;
2403: END IF;
2404: -- Bug# 4028371
2405: IF (l_talv_rec.fa_trx_date = OKL_API.G_MISS_DATE) THEN

Line 2405: IF (l_talv_rec.fa_trx_date = OKL_API.G_MISS_DATE) THEN

2401: IF (l_talv_rec.asset_key_id = OKL_API.G_MISS_NUM) THEN
2402: l_talv_rec.asset_key_id := NULL;
2403: END IF;
2404: -- Bug# 4028371
2405: IF (l_talv_rec.fa_trx_date = OKL_API.G_MISS_DATE) THEN
2406: l_talv_rec.fa_trx_date := NULL;
2407: END IF;
2408: --Bug# 4899328
2409: IF (l_talv_rec.fa_cost = OKL_API.G_MISS_NUM) THEN

Line 2409: IF (l_talv_rec.fa_cost = OKL_API.G_MISS_NUM) THEN

2405: IF (l_talv_rec.fa_trx_date = OKL_API.G_MISS_DATE) THEN
2406: l_talv_rec.fa_trx_date := NULL;
2407: END IF;
2408: --Bug# 4899328
2409: IF (l_talv_rec.fa_cost = OKL_API.G_MISS_NUM) THEN
2410: l_talv_rec.fa_cost := NULL;
2411: END IF;
2412: IF (l_talv_rec.attribute_category = OKC_API.G_MISS_CHAR) THEN
2413: l_talv_rec.attribute_category := NULL;

Line 4350: IF (x_tal_rec.asset_key_id = OKL_API.G_MISS_NUM)

4346: THEN
4347: x_tal_rec.percent_salvage_value := l_tal_rec.percent_salvage_value;
4348: END IF;
4349: --Bug# 2981308
4350: IF (x_tal_rec.asset_key_id = OKL_API.G_MISS_NUM)
4351: THEN
4352: x_tal_rec.asset_key_id := l_tal_rec.asset_key_id;
4353: END IF;
4354: -- Bug# 4028371

Line 4360: IF (x_tal_rec.fa_cost = OKL_API.G_MISS_NUM)

4356: THEN
4357: x_tal_rec.fa_trx_date := l_tal_rec.fa_trx_date;
4358: END IF;
4359: --Bug# 4899328
4360: IF (x_tal_rec.fa_cost = OKL_API.G_MISS_NUM)
4361: THEN
4362: x_tal_rec.fa_cost := l_tal_rec.fa_cost;
4363: END IF;
4364: IF (x_tal_rec.attribute_category = OKC_API.G_MISS_CHAR)

Line 5072: IF (x_talv_rec.asset_key_id = OKL_API.G_MISS_NUM)

5068: THEN
5069: x_talv_rec.percent_salvage_value := l_talv_rec.percent_salvage_value;
5070: END IF;
5071: --Bug# 2981308
5072: IF (x_talv_rec.asset_key_id = OKL_API.G_MISS_NUM)
5073: THEN
5074: x_talv_rec.asset_key_id := l_talv_rec.asset_key_id;
5075: END IF;
5076: -- Bug# 4028371

Line 5082: IF (x_talv_rec.fa_cost = OKL_API.G_MISS_NUM)

5078: THEN
5079: x_talv_rec.fa_trx_date := l_talv_rec.fa_trx_date;
5080: END IF;
5081: --Bug# 4899328
5082: IF (x_talv_rec.fa_cost = OKL_API.G_MISS_NUM)
5083: THEN
5084: x_talv_rec.fa_cost := l_talv_rec.fa_cost;
5085: END IF;
5086: IF (x_talv_rec.attribute_category = OKC_API.G_MISS_CHAR)