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 2385: IF (l_talv_rec.asset_key_id = OKL_API.G_MISS_NUM) THEN

2381: IF (l_talv_rec.percent_salvage_value = OKC_API.G_MISS_NUM) THEN
2382: l_talv_rec.percent_salvage_value := NULL;
2383: END IF;
2384: --Bug# 2981308
2385: IF (l_talv_rec.asset_key_id = OKL_API.G_MISS_NUM) THEN
2386: l_talv_rec.asset_key_id := NULL;
2387: END IF;
2388: -- Bug# 4028371
2389: IF (l_talv_rec.fa_trx_date = OKL_API.G_MISS_DATE) THEN

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

2385: IF (l_talv_rec.asset_key_id = OKL_API.G_MISS_NUM) THEN
2386: l_talv_rec.asset_key_id := NULL;
2387: END IF;
2388: -- Bug# 4028371
2389: IF (l_talv_rec.fa_trx_date = OKL_API.G_MISS_DATE) THEN
2390: l_talv_rec.fa_trx_date := NULL;
2391: END IF;
2392: --Bug# 4899328
2393: IF (l_talv_rec.fa_cost = OKL_API.G_MISS_NUM) THEN

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

2389: IF (l_talv_rec.fa_trx_date = OKL_API.G_MISS_DATE) THEN
2390: l_talv_rec.fa_trx_date := NULL;
2391: END IF;
2392: --Bug# 4899328
2393: IF (l_talv_rec.fa_cost = OKL_API.G_MISS_NUM) THEN
2394: l_talv_rec.fa_cost := NULL;
2395: END IF;
2396: IF (l_talv_rec.attribute_category = OKC_API.G_MISS_CHAR) THEN
2397: l_talv_rec.attribute_category := NULL;

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

4330: THEN
4331: x_tal_rec.percent_salvage_value := l_tal_rec.percent_salvage_value;
4332: END IF;
4333: --Bug# 2981308
4334: IF (x_tal_rec.asset_key_id = OKL_API.G_MISS_NUM)
4335: THEN
4336: x_tal_rec.asset_key_id := l_tal_rec.asset_key_id;
4337: END IF;
4338: -- Bug# 4028371

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

4340: THEN
4341: x_tal_rec.fa_trx_date := l_tal_rec.fa_trx_date;
4342: END IF;
4343: --Bug# 4899328
4344: IF (x_tal_rec.fa_cost = OKL_API.G_MISS_NUM)
4345: THEN
4346: x_tal_rec.fa_cost := l_tal_rec.fa_cost;
4347: END IF;
4348: IF (x_tal_rec.attribute_category = OKC_API.G_MISS_CHAR)

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

5052: THEN
5053: x_talv_rec.percent_salvage_value := l_talv_rec.percent_salvage_value;
5054: END IF;
5055: --Bug# 2981308
5056: IF (x_talv_rec.asset_key_id = OKL_API.G_MISS_NUM)
5057: THEN
5058: x_talv_rec.asset_key_id := l_talv_rec.asset_key_id;
5059: END IF;
5060: -- Bug# 4028371

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

5062: THEN
5063: x_talv_rec.fa_trx_date := l_talv_rec.fa_trx_date;
5064: END IF;
5065: --Bug# 4899328
5066: IF (x_talv_rec.fa_cost = OKL_API.G_MISS_NUM)
5067: THEN
5068: x_talv_rec.fa_cost := l_talv_rec.fa_cost;
5069: END IF;
5070: IF (x_talv_rec.attribute_category = OKC_API.G_MISS_CHAR)