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.IGI_IAC_TRANSFERS_PKG dependencies on IGI_IAC_COMMON_UTILS

Line 63: IF IGI_IAC_COMMON_UTILS.Iac_Round(X_Amount => l_amount, X_Book => p_book_type_code)

59: l_amount_old number := p_amount;
60: --l_path varchar2(150) := g_path||'do_round';
61: begin
62: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'--- Inside Round() ---');
63: IF IGI_IAC_COMMON_UTILS.Iac_Round(X_Amount => l_amount, X_Book => p_book_type_code)
64: THEN
65: p_amount := l_amount;
66: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'IGI_IAC_COMMON_UTILS.Iac_Round is TRUE');
67: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_amount = '||p_amount);

Line 66: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'IGI_IAC_COMMON_UTILS.Iac_Round is TRUE');

62: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'--- Inside Round() ---');
63: IF IGI_IAC_COMMON_UTILS.Iac_Round(X_Amount => l_amount, X_Book => p_book_type_code)
64: THEN
65: p_amount := l_amount;
66: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'IGI_IAC_COMMON_UTILS.Iac_Round is TRUE');
67: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_amount = '||p_amount);
68: ELSE
69: p_amount := round( l_amount, 2);
70: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'IGI_IAC_COMMON_UTILS.Iac_Round is FALSE');

Line 70: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'IGI_IAC_COMMON_UTILS.Iac_Round is FALSE');

66: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'IGI_IAC_COMMON_UTILS.Iac_Round is TRUE');
67: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_amount = '||p_amount);
68: ELSE
69: p_amount := round( l_amount, 2);
70: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'IGI_IAC_COMMON_UTILS.Iac_Round is FALSE');
71: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_amount = '||p_amount);
72: END IF;
73: exception when others then
74: p_amount := l_amount_old;

Line 483: l_return_value:=IGI_IAC_COMMON_UTILS.get_account_ccid(p_book_type_code,

479:
480: l_path := g_path||'find_ccid';
481:
482: -- For reval reserve get the ccid into p_reval_ccid
483: l_return_value:=IGI_IAC_COMMON_UTILS.get_account_ccid(p_book_type_code,
484: p_asset_id,
485: p_dist_id,
486: 'REVAL_RESERVE_ACCT',
487: p_transaction_header_id,

Line 493: l_return_value:=IGI_IAC_COMMON_UTILS.get_account_ccid(p_book_type_code,

489: p_reval_ccid);
490:
491:
492: -- For general fund get the ccid into p_gen_fund_ccid
493: l_return_value:=IGI_IAC_COMMON_UTILS.get_account_ccid(p_book_type_code,
494: p_asset_id,
495: p_dist_id,
496: 'GENERAL_FUND_ACCT',
497: p_transaction_header_id,

Line 502: l_return_value:=IGI_IAC_COMMON_UTILS.get_account_ccid(p_book_type_code,

498: 'TRANSFER',
499: p_Gen_fund_ccid);
500:
501: -- For backlog deprn reserve get the ccid into p_backlog_ccid
502: l_return_value:=IGI_IAC_COMMON_UTILS.get_account_ccid(p_book_type_code,
503: p_asset_id,
504: p_dist_id,
505: 'BACKLOG_DEPRN_RSV_ACCT',
506: p_transaction_header_id,

Line 511: l_return_value:=IGI_IAC_COMMON_UTILS.get_account_ccid(p_book_type_code,

507: 'TRANSFER',
508: p_backlog_ccid);
509:
510: -- For deprn reserve get the ccid into p_deprn_ccid
511: l_return_value:=IGI_IAC_COMMON_UTILS.get_account_ccid(p_book_type_code,
512: p_asset_id,
513: p_dist_id,
514: 'DEPRN_RESERVE_ACCT',
515: p_transaction_header_id,

Line 520: l_return_value:=IGI_IAC_COMMON_UTILS.get_account_ccid(p_book_type_code,

516: 'TRANSFER',
517: p_deprn_ccid);
518:
519: -- For asset cost get the ccid into p_cost_ccid
520: l_return_value:=IGI_IAC_COMMON_UTILS.get_account_ccid(p_book_type_code,
521: p_asset_id,
522: p_dist_id,
523: 'ASSET_COST_ACCT',
524: p_transaction_header_id,

Line 529: l_return_value:=IGI_IAC_COMMON_UTILS.get_account_ccid(p_book_type_code,

525: 'TRANSFER',
526: p_cost_ccid);
527:
528: -- For operating expense get the ccid into p_op_expense_ccid
529: l_return_value:=IGI_IAC_COMMON_UTILS.get_account_ccid(p_book_type_code,
530: p_asset_id,
531: p_dist_id,
532: 'OPERATING_EXPENSE_ACCT',
533: p_transaction_header_id,

Line 538: l_return_value:=IGI_IAC_COMMON_UTILS.get_account_ccid(p_book_type_code,

534: 'TRANSFER',
535: p_op_expense_ccid);
536:
537: -- get the account info for the DEPRN_EXPENSE_ACCT
538: l_return_value:=IGI_IAC_COMMON_UTILS.get_account_ccid(p_book_type_code,
539: p_asset_id,
540: p_dist_id,
541: 'DEPRN_EXPENSE_ACCT',
542: p_transaction_header_id,

Line 1280: IF NOT igi_iac_common_utils.is_iac_book(p_asset_hdr_rec.book_type_code) THEN

1276: RAISE e_iac_not_enabled;
1277: END IF;
1278:
1279: -- Check If Book is an IAC book
1280: IF NOT igi_iac_common_utils.is_iac_book(p_asset_hdr_rec.book_type_code) THEN
1281: RAISE e_not_iac_book;
1282: END IF;
1283:
1284: -- check if the asset has been revalued atleast once

Line 1285: IF NOT igi_iac_common_utils.is_asset_proc(p_asset_hdr_rec.book_type_code,

1281: RAISE e_not_iac_book;
1282: END IF;
1283:
1284: -- check if the asset has been revalued atleast once
1285: IF NOT igi_iac_common_utils.is_asset_proc(p_asset_hdr_rec.book_type_code,
1286: p_asset_hdr_rec.asset_id)
1287: THEN
1288: RAISE e_asset_not_revalued;
1289: END IF;

Line 1293: IF NOT igi_iac_common_utils.get_book_GL_info(p_asset_hdr_rec.book_type_code,

1289: END IF;
1290:
1291: -- get the GL set of books id if p_asset_hdr_rec.set_of_books_id is null
1292: IF p_asset_hdr_rec.set_of_books_id is NULL THEN
1293: IF NOT igi_iac_common_utils.get_book_GL_info(p_asset_hdr_rec.book_type_code,
1294: l_sob_id,
1295: l_coa_id,
1296: l_currency,
1297: l_precision)

Line 1305: IF NOT igi_iac_common_utils.populate_iac_fa_deprn_data(p_asset_hdr_rec.book_type_code,

1301: END IF;
1302:
1303: -- populate igi_iac_fa_deprn table with asset detials if no rows exist for that
1304: -- asset
1305: IF NOT igi_iac_common_utils.populate_iac_fa_deprn_data(p_asset_hdr_rec.book_type_code,
1306: 'TRANSFER') THEN
1307: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'*** Error in Synchronizing Depreciation Data ***');
1308: RETURN FALSE;
1309: END IF;

Line 1312: IF igi_iac_common_utils.get_latest_transaction (p_asset_hdr_rec.book_type_code,

1308: RETURN FALSE;
1309: END IF;
1310:
1311: --Fetch the latest transaction = prev trans if latest is revaluation-preview or obsolete
1312: IF igi_iac_common_utils.get_latest_transaction (p_asset_hdr_rec.book_type_code,
1313: p_asset_hdr_rec.asset_id,
1314: l_transaction_type_code,
1315: l_transaction_header_id,
1316: l_mass_reference_id,

Line 1337: IF igi_iac_common_utils.get_open_period_info(p_asset_hdr_rec.book_type_code,

1333: END IF; */
1334: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Prev adj: '||l_prev_adjustment_id||' Current: '||l_adjustment_id);
1335:
1336: -- Get the current open period counter
1337: IF igi_iac_common_utils.get_open_period_info(p_asset_hdr_rec.book_type_code,
1338: l_prd_rec)
1339: THEN
1340: l_current_period_counter:=l_prd_rec.period_counter;
1341: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Current Period Counter :'||l_current_period_counter);

Line 1346: IF IGI_IAC_COMMON_UTILS.Is_Asset_Adjustment_Done(p_asset_hdr_rec.book_type_code,

1342: END IF;
1343:
1344: -- Check whether adjustments exist in the open period
1345: -- If Adjustments exists then stop the Transfer
1346: IF IGI_IAC_COMMON_UTILS.Is_Asset_Adjustment_Done(p_asset_hdr_rec.book_type_code,
1347: p_asset_hdr_rec.asset_id) THEN
1348:
1349: FA_SRVR_MSG.Add_Message(
1350: Calling_FN => 'IGI_IAC_TRANSFERS_PKG.Do_Transfer' ,

Line 1360: IF igi_iac_common_utils.get_period_info_for_date(p_asset_hdr_rec.book_type_code,

1356:
1357: -- check if this is a prior period transfer
1358: g_prior_period := FALSE;
1359: -- get the period counter for the transfer date period
1360: IF igi_iac_common_utils.get_period_info_for_date(p_asset_hdr_rec.book_type_code,
1361: p_trans_rec.transaction_date_entered,
1362: l_prd_rec_prior)
1363: THEN
1364: l_prior_period_counter:=l_prd_rec_prior.period_counter;

Line 1688: IF IGI_IAC_COMMON_UTILS.Iac_round(l_reval_reserve,

1684:
1685: -- prepare distribution data for igi_iac_det_balances
1686: -- igi_iac_fa_deprn and igi_iac_adjustments
1687: -- Rounding All amounts
1688: IF IGI_IAC_COMMON_UTILS.Iac_round(l_reval_reserve,
1689: p_asset_hdr_rec.book_type_code) THEN
1690: null;
1691: END IF;
1692: IF IGI_IAC_COMMON_UTILS.Iac_round(l_general_fund,

Line 1692: IF IGI_IAC_COMMON_UTILS.Iac_round(l_general_fund,

1688: IF IGI_IAC_COMMON_UTILS.Iac_round(l_reval_reserve,
1689: p_asset_hdr_rec.book_type_code) THEN
1690: null;
1691: END IF;
1692: IF IGI_IAC_COMMON_UTILS.Iac_round(l_general_fund,
1693: p_asset_hdr_rec.book_type_code) THEN
1694: null;
1695: END IF;
1696: IF IGI_IAC_COMMON_UTILS.Iac_round(l_backlog_deprn_reserve,

Line 1696: IF IGI_IAC_COMMON_UTILS.Iac_round(l_backlog_deprn_reserve,

1692: IF IGI_IAC_COMMON_UTILS.Iac_round(l_general_fund,
1693: p_asset_hdr_rec.book_type_code) THEN
1694: null;
1695: END IF;
1696: IF IGI_IAC_COMMON_UTILS.Iac_round(l_backlog_deprn_reserve,
1697: p_asset_hdr_rec.book_type_code) THEN
1698: null;
1699: END IF;
1700: IF IGI_IAC_COMMON_UTILS.Iac_round(l_deprn_reserve,

Line 1700: IF IGI_IAC_COMMON_UTILS.Iac_round(l_deprn_reserve,

1696: IF IGI_IAC_COMMON_UTILS.Iac_round(l_backlog_deprn_reserve,
1697: p_asset_hdr_rec.book_type_code) THEN
1698: null;
1699: END IF;
1700: IF IGI_IAC_COMMON_UTILS.Iac_round(l_deprn_reserve,
1701: p_asset_hdr_rec.book_type_code) THEN
1702: null;
1703: END IF;
1704: IF IGI_IAC_COMMON_UTILS.Iac_round(l_adjusted_cost,

Line 1704: IF IGI_IAC_COMMON_UTILS.Iac_round(l_adjusted_cost,

1700: IF IGI_IAC_COMMON_UTILS.Iac_round(l_deprn_reserve,
1701: p_asset_hdr_rec.book_type_code) THEN
1702: null;
1703: END IF;
1704: IF IGI_IAC_COMMON_UTILS.Iac_round(l_adjusted_cost,
1705: p_asset_hdr_rec.book_type_code) THEN
1706: null;
1707: END IF;
1708: IF IGI_IAC_COMMON_UTILS.Iac_round(l_op_acct,

Line 1708: IF IGI_IAC_COMMON_UTILS.Iac_round(l_op_acct,

1704: IF IGI_IAC_COMMON_UTILS.Iac_round(l_adjusted_cost,
1705: p_asset_hdr_rec.book_type_code) THEN
1706: null;
1707: END IF;
1708: IF IGI_IAC_COMMON_UTILS.Iac_round(l_op_acct,
1709: p_asset_hdr_rec.book_type_code) THEN
1710: null;
1711: END IF;
1712: IF IGI_IAC_COMMON_UTILS.Iac_round(l_net_book_value,

Line 1712: IF IGI_IAC_COMMON_UTILS.Iac_round(l_net_book_value,

1708: IF IGI_IAC_COMMON_UTILS.Iac_round(l_op_acct,
1709: p_asset_hdr_rec.book_type_code) THEN
1710: null;
1711: END IF;
1712: IF IGI_IAC_COMMON_UTILS.Iac_round(l_net_book_value,
1713: p_asset_hdr_rec.book_type_code) THEN
1714: null;
1715: END IF;
1716: IF IGI_IAC_COMMON_UTILS.Iac_round(l_deprn_per,

Line 1716: IF IGI_IAC_COMMON_UTILS.Iac_round(l_deprn_per,

1712: IF IGI_IAC_COMMON_UTILS.Iac_round(l_net_book_value,
1713: p_asset_hdr_rec.book_type_code) THEN
1714: null;
1715: END IF;
1716: IF IGI_IAC_COMMON_UTILS.Iac_round(l_deprn_per,
1717: p_asset_hdr_rec.book_type_code) THEN
1718: null;
1719: END IF;
1720: IF IGI_IAC_COMMON_UTILS.Iac_round(l_ytd_deprn,

Line 1720: IF IGI_IAC_COMMON_UTILS.Iac_round(l_ytd_deprn,

1716: IF IGI_IAC_COMMON_UTILS.Iac_round(l_deprn_per,
1717: p_asset_hdr_rec.book_type_code) THEN
1718: null;
1719: END IF;
1720: IF IGI_IAC_COMMON_UTILS.Iac_round(l_ytd_deprn,
1721: p_asset_hdr_rec.book_type_code) THEN
1722: null;
1723: END IF;
1724: IF IGI_IAC_COMMON_UTILS.Iac_round(l_op_acct_ytd,

Line 1724: IF IGI_IAC_COMMON_UTILS.Iac_round(l_op_acct_ytd,

1720: IF IGI_IAC_COMMON_UTILS.Iac_round(l_ytd_deprn,
1721: p_asset_hdr_rec.book_type_code) THEN
1722: null;
1723: END IF;
1724: IF IGI_IAC_COMMON_UTILS.Iac_round(l_op_acct_ytd,
1725: p_asset_hdr_rec.book_type_code) THEN
1726: null;
1727: END IF;
1728: IF IGI_IAC_COMMON_UTILS.Iac_round(l_reval_reserve_backlog,

Line 1728: IF IGI_IAC_COMMON_UTILS.Iac_round(l_reval_reserve_backlog,

1724: IF IGI_IAC_COMMON_UTILS.Iac_round(l_op_acct_ytd,
1725: p_asset_hdr_rec.book_type_code) THEN
1726: null;
1727: END IF;
1728: IF IGI_IAC_COMMON_UTILS.Iac_round(l_reval_reserve_backlog,
1729: p_asset_hdr_rec.book_type_code) THEN
1730: null;
1731: END IF;
1732: IF IGI_IAC_COMMON_UTILS.Iac_round(l_operating_acct_backlog,

Line 1732: IF IGI_IAC_COMMON_UTILS.Iac_round(l_operating_acct_backlog,

1728: IF IGI_IAC_COMMON_UTILS.Iac_round(l_reval_reserve_backlog,
1729: p_asset_hdr_rec.book_type_code) THEN
1730: null;
1731: END IF;
1732: IF IGI_IAC_COMMON_UTILS.Iac_round(l_operating_acct_backlog,
1733: p_asset_hdr_rec.book_type_code) THEN
1734: null;
1735: END IF;
1736: IF IGI_IAC_COMMON_UTILS.Iac_round(l_general_fund_per,

Line 1736: IF IGI_IAC_COMMON_UTILS.Iac_round(l_general_fund_per,

1732: IF IGI_IAC_COMMON_UTILS.Iac_round(l_operating_acct_backlog,
1733: p_asset_hdr_rec.book_type_code) THEN
1734: null;
1735: END IF;
1736: IF IGI_IAC_COMMON_UTILS.Iac_round(l_general_fund_per,
1737: p_asset_hdr_rec.book_type_code) THEN
1738: null;
1739: END IF;
1740: IF IGI_IAC_COMMON_UTILS.Iac_round(l_fa_deprn_period,

Line 1740: IF IGI_IAC_COMMON_UTILS.Iac_round(l_fa_deprn_period,

1736: IF IGI_IAC_COMMON_UTILS.Iac_round(l_general_fund_per,
1737: p_asset_hdr_rec.book_type_code) THEN
1738: null;
1739: END IF;
1740: IF IGI_IAC_COMMON_UTILS.Iac_round(l_fa_deprn_period,
1741: p_asset_hdr_rec.book_type_code) THEN
1742: null;
1743: END IF;
1744: IF IGI_IAC_COMMON_UTILS.Iac_round(l_fa_deprn_reserve,

Line 1744: IF IGI_IAC_COMMON_UTILS.Iac_round(l_fa_deprn_reserve,

1740: IF IGI_IAC_COMMON_UTILS.Iac_round(l_fa_deprn_period,
1741: p_asset_hdr_rec.book_type_code) THEN
1742: null;
1743: END IF;
1744: IF IGI_IAC_COMMON_UTILS.Iac_round(l_fa_deprn_reserve,
1745: p_asset_hdr_rec.book_type_code) THEN
1746: null;
1747: END IF;
1748: IF IGI_IAC_COMMON_UTILS.Iac_round(l_fa_deprn_ytd,

Line 1748: IF IGI_IAC_COMMON_UTILS.Iac_round(l_fa_deprn_ytd,

1744: IF IGI_IAC_COMMON_UTILS.Iac_round(l_fa_deprn_reserve,
1745: p_asset_hdr_rec.book_type_code) THEN
1746: null;
1747: END IF;
1748: IF IGI_IAC_COMMON_UTILS.Iac_round(l_fa_deprn_ytd,
1749: p_asset_hdr_rec.book_type_code) THEN
1750: null;
1751: END IF;
1752:

Line 1755: IF IGI_IAC_COMMON_UTILS.Iac_round(l_deprn_expense,

1751: END IF;
1752:
1753: IF g_prior_period THEN
1754: -- do currency rounding for the catchup amounts
1755: IF IGI_IAC_COMMON_UTILS.Iac_round(l_deprn_expense,
1756: p_asset_hdr_rec.book_type_code) THEN
1757: NULL;
1758: END IF;
1759: IF IGI_IAC_COMMON_UTILS.Iac_round(l_dist_op_exp,

Line 1759: IF IGI_IAC_COMMON_UTILS.Iac_round(l_dist_op_exp,

1755: IF IGI_IAC_COMMON_UTILS.Iac_round(l_deprn_expense,
1756: p_asset_hdr_rec.book_type_code) THEN
1757: NULL;
1758: END IF;
1759: IF IGI_IAC_COMMON_UTILS.Iac_round(l_dist_op_exp,
1760: p_asset_hdr_rec.book_type_code) THEN
1761: NULL;
1762: END IF;
1763: END IF; -- prior period

Line 2226: l_return_value:=IGI_IAC_COMMON_UTILS.get_account_ccid(p_asset_hdr_rec.book_type_code,

2222: IF (l_all_dist.distribution_id = l_old_dist) THEN
2223: -- old distribution
2224: -- get ccid
2225: -- get the ccod for interco ar
2226: l_return_value:=IGI_IAC_COMMON_UTILS.get_account_ccid(p_asset_hdr_rec.book_type_code,
2227: p_asset_hdr_rec.asset_id,
2228: l_all_dist.distribution_id,
2229: 'INTERCO_AR_ACCT',
2230: p_trans_rec.transaction_header_id,

Line 2253: l_return_value:=IGI_IAC_COMMON_UTILS.get_account_ccid(p_asset_hdr_rec.book_type_code,

2249: );
2250: ELSIF (l_all_dist.distribution_id = l_impacted_dist) THEN
2251: -- new distribution
2252: -- get the ccod for interco ap
2253: l_return_value:=IGI_IAC_COMMON_UTILS.get_account_ccid(p_asset_hdr_rec.book_type_code,
2254: p_asset_hdr_rec.asset_id,
2255: l_all_dist.distribution_id,
2256: 'INTERCO_AP_ACCT',
2257: p_trans_rec.transaction_header_id,

Line 2827: IF (IGI_IAC_COMMON_UTILS.get_period_info_for_date(p_book_type_code,

2823: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Asset Id :'||l_trans_headers.asset_id);
2824:
2825:
2826: /*Check If it is Prior Period Transfer*/
2827: IF (IGI_IAC_COMMON_UTILS.get_period_info_for_date(p_book_type_code,
2828: l_trans_headers.transaction_date_entered,
2829: l_prd_rec_prior)) THEN
2830: l_prior_period_counter:=l_prd_rec_prior.period_counter;
2831: END IF;