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_CATCHUP_PKG dependencies on IGI_IAC_COMMON_UTILS

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

38: l_amount number := p_amount;
39: l_amount_old number := p_amount;
40: l_path varchar2(150) := g_path||'do_round';
41: begin
42: IF IGI_IAC_COMMON_UTILS.Iac_Round(X_Amount => l_amount, X_Book => p_book_type_code)
43: THEN
44: p_amount := l_amount;
45: ELSE
46: p_amount := round( l_amount, 2);

Line 214: IF NOT igi_iac_common_utils.get_period_info_for_date(p_book_type_code,

210: p_last_asset_period := NULL;
211: return TRUE;
212: END IF;
213:
214: IF NOT igi_iac_common_utils.get_period_info_for_date(p_book_type_code,
215: l_asset_info.date_placed_in_service,
216: l_dpis_period) THEN
217: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,
218: p_full_path => l_path_name,

Line 236: IF NOT igi_iac_common_utils.get_period_info_for_counter(p_book_type_code,

232: l_last_period_counter := NULL;
233: END IF;
234: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path_name,'l_last_period_counter =' || l_last_period_counter);
235:
236: IF NOT igi_iac_common_utils.get_period_info_for_counter(p_book_type_code,
237: p_period_counter,
238: l_current_period) THEN
239: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,
240: p_full_path => l_path_name,

Line 267: IF NOT igi_iac_common_utils.get_period_info_for_counter(p_book_type_code,

263: ELSE
264: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
265: p_full_path => l_path_name,
266: p_string => ' Asset is fully reserved');
267: IF NOT igi_iac_common_utils.get_period_info_for_counter(p_book_type_code,
268: l_last_period_counter,
269: l_last_period) THEN
270: return FALSE;
271: END IF;

Line 359: IF NOT igi_iac_common_utils.get_period_info_for_date(p_book_type_code,

355: p_string => ' Total Periods in Asset life :'||to_char(l_total_periods));
356:
357: /* Added for bug 2411599 vgadde 12/06/2002 Start(1)*/
358: /* Modified logic for getting last period in asset life */
359: IF NOT igi_iac_common_utils.get_period_info_for_date(p_book_type_code,
360: l_asset_info.date_placed_in_service,
361: l_dpis_period) THEN
362: return FALSE;
363: END IF;

Line 390: IF NOT igi_iac_common_utils.get_period_info_for_counter(p_book_type_code,

386:
387: ------------- supplied YTD -----------------
388: IF Nvl(l_booksrow_ytd_deprn,0) <> 0 Then
389:
390: IF NOT igi_iac_common_utils.get_period_info_for_counter(p_book_type_code,
391: p_period_counter-1,
392: l_current_period) THEN
393: return FALSE;
394: END IF;

Line 709: IF NOT igi_iac_common_utils.get_period_info_for_counter(p_asset_balance.book_type_code,

705: CLOSE c_get_user_deprn;
706:
707: IF ((p_calling_function = 'ADDITION') AND (nvl(l_booksrow_YTD,0) <> 0) AND (p_asset_last_period IS NULL)) THEN
708:
709: IF NOT igi_iac_common_utils.get_period_info_for_counter(p_asset_balance.book_type_code,
710: p_period_counter_from,l_period_from) THEN
711: return FALSE;
712: END IF;
713:

Line 714: IF NOT igi_iac_common_utils.get_period_info_for_counter(p_asset_balance.book_type_code,

710: p_period_counter_from,l_period_from) THEN
711: return FALSE;
712: END IF;
713:
714: IF NOT igi_iac_common_utils.get_period_info_for_counter(p_asset_balance.book_type_code,
715: p_period_counter_to-1,l_period_to) THEN
716: return FALSE;
717: END IF;
718:

Line 719: IF NOT igi_iac_common_utils.get_period_info_for_counter(p_asset_balance.book_type_code,

715: p_period_counter_to-1,l_period_to) THEN
716: return FALSE;
717: END IF;
718:
719: IF NOT igi_iac_common_utils.get_period_info_for_counter(p_asset_balance.book_type_code,
720: p_period_counter-1,
721: l_period_open) THEN
722: return FALSE;
723: END IF;

Line 785: IF NOT igi_iac_common_utils.get_period_info_for_counter(p_asset_balance.book_type_code,

781: END IF;
782: END IF; -- Addition and reclass
783:
784: IF (p_calling_function = 'UPGRADE') THEN
785: IF NOT igi_iac_common_utils.get_period_info_for_counter(p_asset_balance.book_type_code,
786: p_period_counter_from,
787: l_period_from) THEN
788: return FALSE;
789: END IF;

Line 791: IF NOT igi_iac_common_utils.get_period_info_for_counter(p_asset_balance.book_type_code,

787: l_period_from) THEN
788: return FALSE;
789: END IF;
790:
791: IF NOT igi_iac_common_utils.get_period_info_for_counter(p_asset_balance.book_type_code,
792: p_period_counter_to-1,
793: l_period_to) THEN
794: return FALSE;
795: END IF;

Line 796: IF NOT igi_iac_common_utils.get_period_info_for_counter(p_asset_balance.book_type_code,

792: p_period_counter_to-1,
793: l_period_to) THEN
794: return FALSE;
795: END IF;
796: IF NOT igi_iac_common_utils.get_period_info_for_counter(p_asset_balance.book_type_code,
797: p_period_counter,
798: l_period_open) THEN
799: return FALSE;
800: END IF;

Line 825: IF NOT igi_iac_common_utils.get_period_info_for_counter(p_asset_balance.book_type_code,

821: END IF;
822: ELSIF p_asset_last_period < p_period_counter_from THEN
823: return TRUE;
824: ELSE
825: IF NOT igi_iac_common_utils.get_period_info_for_counter(p_asset_balance.book_type_code,
826: p_asset_last_period,
827: l_period_reserved) THEN
828: return FALSE;
829: END IF;

Line 863: IF NOT (igi_iac_common_utils.iac_round(l_deprn_catchup_amount,p_asset_balance.book_type_code)) THEN

859:
860: END IF;
861: /* Bug 2961656 vgadde 08-jul-2003 End(5) */
862:
863: IF NOT (igi_iac_common_utils.iac_round(l_deprn_catchup_amount,p_asset_balance.book_type_code)) THEN
864: return FALSE;
865: END IF;
866:
867: IF NOT (igi_iac_common_utils.iac_round(l_fa_deprn_catchup_amount,p_asset_balance.book_type_code)) THEN

Line 867: IF NOT (igi_iac_common_utils.iac_round(l_fa_deprn_catchup_amount,p_asset_balance.book_type_code)) THEN

863: IF NOT (igi_iac_common_utils.iac_round(l_deprn_catchup_amount,p_asset_balance.book_type_code)) THEN
864: return FALSE;
865: END IF;
866:
867: IF NOT (igi_iac_common_utils.iac_round(l_fa_deprn_catchup_amount,p_asset_balance.book_type_code)) THEN
868: return FALSE;
869: END IF;
870:
871: /* Bug 2961656 vgadde 08-jul-2003 Start(6) */

Line 872: IF NOT (igi_iac_common_utils.iac_round(l_iac_deprn_amount_py,p_asset_balance.book_type_code)) THEN

868: return FALSE;
869: END IF;
870:
871: /* Bug 2961656 vgadde 08-jul-2003 Start(6) */
872: IF NOT (igi_iac_common_utils.iac_round(l_iac_deprn_amount_py,p_asset_balance.book_type_code)) THEN
873: return FALSE;
874: END IF;
875:
876: IF NOT (igi_iac_common_utils.iac_round(l_iac_deprn_amount_cy,p_asset_balance.book_type_code)) THEN

Line 876: IF NOT (igi_iac_common_utils.iac_round(l_iac_deprn_amount_cy,p_asset_balance.book_type_code)) THEN

872: IF NOT (igi_iac_common_utils.iac_round(l_iac_deprn_amount_py,p_asset_balance.book_type_code)) THEN
873: return FALSE;
874: END IF;
875:
876: IF NOT (igi_iac_common_utils.iac_round(l_iac_deprn_amount_cy,p_asset_balance.book_type_code)) THEN
877: return FALSE;
878: END IF;
879: /* Bug 2961656 vgadde 08-jul-2003 End(6) */
880:

Line 912: IF NOT igi_iac_common_utils.get_period_info_for_counter(p_asset_balance.book_type_code,

908: ELSE
909: l_last_deprn_catchup_period := p_period_counter - 1;
910: END IF;
911:
912: IF NOT igi_iac_common_utils.get_period_info_for_counter(p_asset_balance.book_type_code,
913: l_last_deprn_catchup_period,
914: l_last_catchup_prd_rec) THEN
915: return FALSE;
916: END IF;

Line 918: IF NOT igi_iac_common_utils.get_period_info_for_counter(p_asset_balance.book_type_code,

914: l_last_catchup_prd_rec) THEN
915: return FALSE;
916: END IF;
917:
918: IF NOT igi_iac_common_utils.get_period_info_for_counter(p_asset_balance.book_type_code,
919: p_period_counter_from-1,
920: l_last_reval_prd_rec) THEN
921: return FALSE;
922: END IF;

Line 930: IF NOT (igi_iac_common_utils.get_book_gl_info(p_asset_balance.book_type_code ,

926: /* Accounting entries to be created */
927: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
928: p_full_path => l_path_name,
929: p_string => ' Inserting records into IAC tables');
930: IF NOT (igi_iac_common_utils.get_book_gl_info(p_asset_balance.book_type_code ,
931: l_set_of_books_id ,
932: l_chart_of_accts_id ,
933: l_currency_code ,
934: l_precision )) THEN

Line 1058: IF NOT igi_iac_common_utils.Prorate_Amt_to_Active_Dists( l_transaction.book_type_Code ,

1054: l_fa_active_dists_YTD := l_fa_all_dists_YTD - l_fa_inactive_dists_YTD;
1055: END IF;
1056:
1057:
1058: IF NOT igi_iac_common_utils.Prorate_Amt_to_Active_Dists( l_transaction.book_type_Code ,
1059: l_transaction.Asset_id ,
1060: l_deprn_catchup_amount ,
1061: l_distributions_tab ) THEN
1062: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,

Line 1068: IF NOT igi_iac_common_utils.Prorate_Amt_to_Active_Dists( l_transaction.book_type_Code ,

1064: p_string => '*** Error in prorating catchup amount to active distributions');
1065: return FALSE;
1066: END IF;
1067:
1068: IF NOT igi_iac_common_utils.Prorate_Amt_to_Active_Dists( l_transaction.book_type_Code ,
1069: l_transaction.Asset_id ,
1070: l_fa_deprn_catchup_amount ,
1071: l_fa_dist_catchup_tab ) THEN
1072: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,

Line 1101: IF NOT igi_iac_common_utils.iac_round(l_distribution_amount,

1097: do_round(l_distribution_amount,p_asset_balance.book_type_code);
1098: l_dist_period_amount := l_iac_deprn_amount_cy * l_distributions_tab(l_idx).prorate_factor;
1099: do_round(l_dist_period_amount,p_asset_balance.book_type_code);
1100:
1101: IF NOT igi_iac_common_utils.iac_round(l_distribution_amount,
1102: l_transaction.book_type_code) THEN
1103: return FALSE;
1104: END IF;
1105:

Line 1106: IF NOT igi_iac_common_utils.iac_round(l_dist_period_amount,

1102: l_transaction.book_type_code) THEN
1103: return FALSE;
1104: END IF;
1105:
1106: IF NOT igi_iac_common_utils.iac_round(l_dist_period_amount,
1107: l_transaction.book_type_code) THEN
1108: return FALSE;
1109: END IF;
1110:

Line 1119: IF NOT (igi_iac_common_utils.get_account_ccid(l_transaction.book_type_code ,

1115: l_account_ccid := NULL ;
1116: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1117: p_full_path => l_path_name,
1118: p_string => ' Inserting records into igi_iac_adjustments');
1119: IF NOT (igi_iac_common_utils.get_account_ccid(l_transaction.book_type_code ,
1120: l_transaction.asset_id ,
1121: l_distributions_tab(l_idx).distribution_id ,
1122: 'DEPRN_EXPENSE_ACCT' ,
1123: l_account_ccid )) THEN

Line 1151: IF NOT (igi_iac_common_utils.get_account_ccid(l_transaction.book_type_code ,

1147: X_event_id => p_event_id ) ;
1148:
1149: l_rowid := NULL;
1150: l_account_ccid := NULL ;
1151: IF NOT (igi_iac_common_utils.get_account_ccid(l_transaction.book_type_code ,
1152: l_transaction.asset_id ,
1153: l_distributions_tab(l_idx).distribution_id ,
1154: 'DEPRN_RESERVE_ACCT' ,
1155: l_account_ccid )) THEN

Line 1187: IF NOT (igi_iac_common_utils.get_account_ccid(l_transaction.book_type_code ,

1183: l_rowid := NULL;
1184: l_account_ccid := NULL ;
1185: l_reval_rsv_ccid := Null;
1186:
1187: IF NOT (igi_iac_common_utils.get_account_ccid(l_transaction.book_type_code ,
1188: l_transaction.asset_id ,
1189: l_distributions_tab(l_idx).distribution_id ,
1190: 'REVAL_RESERVE_ACCT' ,
1191: l_account_ccid )) THEN

Line 1220: IF NOT (igi_iac_common_utils.get_account_ccid(l_transaction.book_type_code ,

1216: X_event_id => p_event_id ) ;
1217:
1218: l_rowid := NULL;
1219: l_account_ccid := NULL ;
1220: IF NOT (igi_iac_common_utils.get_account_ccid(l_transaction.book_type_code ,
1221: l_transaction.asset_id ,
1222: l_distributions_tab(l_idx).distribution_id ,
1223: 'GENERAL_FUND_ACCT' ,
1224: l_account_ccid )) THEN

Line 1279: IF NOT igi_iac_common_utils.iac_round(l_deprn_ytd,

1275: l_deprn_ytd := (l_iac_active_dists_YTD * l_distributions_tab(l_idx).prorate_factor);
1276: do_round(l_deprn_ytd,p_asset_balance.book_type_code);
1277: END IF;
1278:
1279: IF NOT igi_iac_common_utils.iac_round(l_deprn_ytd,
1280: l_transaction.book_type_code) THEN
1281: return FALSE;
1282: END IF;
1283:

Line 1388: IF NOT igi_iac_common_utils.iac_round(l_fa_deprn_period_amount,

1384: l_fa_deprn_period_amount := p_fa_deprn_expense_cy * l_fa_dist_catchup_tab(l_idx).prorate_factor;
1385: do_round(l_fa_deprn_period_amount,p_asset_balance.book_type_code);
1386: END IF;
1387:
1388: IF NOT igi_iac_common_utils.iac_round(l_fa_deprn_period_amount,
1389: l_iac_fa_deprn_rec.book_type_code) THEN
1390: return FALSE;
1391: END IF;
1392:

Line 1393: IF NOT igi_iac_common_utils.iac_round(l_deprn_ytd,

1389: l_iac_fa_deprn_rec.book_type_code) THEN
1390: return FALSE;
1391: END IF;
1392:
1393: IF NOT igi_iac_common_utils.iac_round(l_deprn_ytd,
1394: l_iac_fa_deprn_rec.book_type_code) THEN
1395: return FALSE;
1396: END IF;
1397:

Line 1398: IF NOT igi_iac_common_utils.iac_round(l_fa_dist_catchup_tab(l_idx).amount,

1394: l_iac_fa_deprn_rec.book_type_code) THEN
1395: return FALSE;
1396: END IF;
1397:
1398: IF NOT igi_iac_common_utils.iac_round(l_fa_dist_catchup_tab(l_idx).amount,
1399: l_iac_fa_deprn_rec.book_type_code) THEN
1400: return FALSE;
1401: END IF;
1402:

Line 1585: IF NOT igi_iac_common_utils.get_period_info_for_date(

1581: OPEN c_fa_asset_info;
1582: FETCH c_fa_asset_info INTO l_fa_asset_info;
1583: CLOSE c_fa_asset_info;
1584:
1585: IF NOT igi_iac_common_utils.get_period_info_for_date(
1586: p_reval_asset_params(1).book_type_code,
1587: l_fa_asset_info.date_placed_in_service,
1588: l_dpis_period) THEN
1589: return FALSE;

Line 1596: IF NOT igi_iac_common_utils.get_price_index_value(

1592: p_full_path => l_path_name,
1593: p_string => ' DPIS Period Info');
1594: Debug_Period(l_dpis_period);
1595:
1596: IF NOT igi_iac_common_utils.get_price_index_value(
1597: p_reval_asset_params(1).book_type_code,
1598: p_reval_asset_params(1).asset_id,
1599: l_dpis_period.period_name,
1600: l_dpis_price_index) THEN

Line 1640: IF NOT (igi_iac_common_utils.get_period_info_for_counter(

1636:
1637:
1638: FOR idx IN p_reval_control.FIRST..p_reval_control.LAST LOOP
1639:
1640: IF NOT (igi_iac_common_utils.get_period_info_for_counter(
1641: p_reval_asset_params(idx).book_type_code,
1642: p_reval_asset_params(idx).period_counter,
1643: l_curr_period)) THEN
1644: return FALSE;

Line 1647: IF NOT (igi_iac_common_utils.get_price_index_value(

1643: l_curr_period)) THEN
1644: return FALSE;
1645: END IF;
1646:
1647: IF NOT (igi_iac_common_utils.get_price_index_value(
1648: p_reval_asset_params(idx).book_type_code,
1649: p_reval_asset_params(idx).asset_id,
1650: l_curr_period.period_name,
1651: l_curr_price_index)) THEN

Line 1819: IF NOT (igi_iac_common_utils.get_period_info_for_counter(

1815:
1816: ---Get the details for supplied depreciation and YTD --------
1817: IF ((p_calling_function = 'ADDITION') AND (NVL(l_booksrow_YTD,0) <> 0) AND (p_asset_last_period IS NuLL)) THEN -- supplied YYD
1818:
1819: IF NOT (igi_iac_common_utils.get_period_info_for_counter(
1820: p_reval_asset_params(idx).book_type_code,
1821: p_period_counter-1,
1822: l_open_period)) THEN
1823: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,

Line 1927: IF NOT (igi_iac_common_utils.get_period_info_for_counter(

1923: RETURN FALSE;
1924: END IF;
1925: ELSE
1926:
1927: IF NOT (igi_iac_common_utils.get_period_info_for_counter(
1928: p_reval_asset_params(idx).book_type_code,
1929: p_period_counter,
1930: l_open_period)) THEN
1931: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,

Line 1938: IF NOT igi_iac_common_utils.get_period_info_for_counter(

1934: return FALSE;
1935: END IF;
1936:
1937: IF p_asset_last_period IS NOT NULL THEN
1938: IF NOT igi_iac_common_utils.get_period_info_for_counter(
1939: p_reval_asset_params(idx).book_type_code,
1940: p_asset_last_period,
1941: l_last_deprn_period) THEN
1942: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,