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 197: IF NOT igi_iac_common_utils.get_period_info_for_date(p_book_type_code,

193: p_last_asset_period := NULL;
194: return TRUE;
195: END IF;
196:
197: IF NOT igi_iac_common_utils.get_period_info_for_date(p_book_type_code,
198: l_asset_info.date_placed_in_service,
199: l_dpis_period) THEN
200: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,
201: p_full_path => l_path_name,

Line 217: IF NOT igi_iac_common_utils.get_period_info_for_counter(p_book_type_code,

213: IF l_last_period_counter > p_period_counter THEN
214: l_last_period_counter := NULL;
215: END IF;
216:
217: IF NOT igi_iac_common_utils.get_period_info_for_counter(p_book_type_code,
218: p_period_counter,
219: l_current_period) THEN
220: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,
221: p_full_path => l_path_name,

Line 243: IF NOT igi_iac_common_utils.get_period_info_for_counter(p_book_type_code,

239: ELSE
240: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
241: p_full_path => l_path_name,
242: p_string => ' Asset is fully reserved');
243: IF NOT igi_iac_common_utils.get_period_info_for_counter(p_book_type_code,
244: l_last_period_counter,
245: l_last_period) THEN
246: return FALSE;
247: END IF;

Line 329: IF NOT igi_iac_common_utils.get_period_info_for_date(p_book_type_code,

325: p_string => ' Total Periods in Asset life :'||to_char(l_total_periods));
326:
327: /* Added for bug 2411599 vgadde 12/06/2002 Start(1)*/
328: /* Modified logic for getting last period in asset life */
329: IF NOT igi_iac_common_utils.get_period_info_for_date(p_book_type_code,
330: l_asset_info.date_placed_in_service,
331: l_dpis_period) THEN
332: return FALSE;
333: END IF;

Line 360: IF NOT igi_iac_common_utils.get_period_info_for_counter(p_book_type_code,

356:
357: ------------- supplied YTD -----------------
358: IF Nvl(l_booksrow_ytd_deprn,0) <> 0 Then
359:
360: IF NOT igi_iac_common_utils.get_period_info_for_counter(p_book_type_code,
361: p_period_counter-1,
362: l_current_period) THEN
363: return FALSE;
364: END IF;

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

660: CLOSE c_get_user_deprn;
661:
662: IF ((p_calling_function = 'ADDITION') AND (nvl(l_booksrow_YTD,0) <> 0) AND (p_asset_last_period IS NULL)) THEN
663:
664: IF NOT igi_iac_common_utils.get_period_info_for_counter(p_asset_balance.book_type_code,
665: p_period_counter_from,l_period_from) THEN
666: return FALSE;
667: END IF;
668:

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

665: p_period_counter_from,l_period_from) THEN
666: return FALSE;
667: END IF;
668:
669: IF NOT igi_iac_common_utils.get_period_info_for_counter(p_asset_balance.book_type_code,
670: p_period_counter_to-1,l_period_to) THEN
671: return FALSE;
672: END IF;
673:

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

670: p_period_counter_to-1,l_period_to) THEN
671: return FALSE;
672: END IF;
673:
674: IF NOT igi_iac_common_utils.get_period_info_for_counter(p_asset_balance.book_type_code,
675: p_period_counter-1,
676: l_period_open) THEN
677: return FALSE;
678: END IF;

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

724: END IF;
725: END IF; -- Addition and reclass
726:
727: IF (p_calling_function = 'UPGRADE') THEN
728: IF NOT igi_iac_common_utils.get_period_info_for_counter(p_asset_balance.book_type_code,
729: p_period_counter_from,
730: l_period_from) THEN
731: return FALSE;
732: END IF;

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

730: l_period_from) THEN
731: return FALSE;
732: END IF;
733:
734: IF NOT igi_iac_common_utils.get_period_info_for_counter(p_asset_balance.book_type_code,
735: p_period_counter_to-1,
736: l_period_to) THEN
737: return FALSE;
738: END IF;

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

735: p_period_counter_to-1,
736: l_period_to) THEN
737: return FALSE;
738: END IF;
739: IF NOT igi_iac_common_utils.get_period_info_for_counter(p_asset_balance.book_type_code,
740: p_period_counter,
741: l_period_open) THEN
742: return FALSE;
743: END IF;

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

758: END IF;
759: ELSIF p_asset_last_period < p_period_counter_from THEN
760: return TRUE;
761: ELSE
762: IF NOT igi_iac_common_utils.get_period_info_for_counter(p_asset_balance.book_type_code,
763: p_asset_last_period,
764: l_period_reserved) THEN
765: return FALSE;
766: END IF;

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

788:
789: END IF;
790: /* Bug 2961656 vgadde 08-jul-2003 End(5) */
791:
792: IF NOT (igi_iac_common_utils.iac_round(l_deprn_catchup_amount,p_asset_balance.book_type_code)) THEN
793: return FALSE;
794: END IF;
795:
796: IF NOT (igi_iac_common_utils.iac_round(l_fa_deprn_catchup_amount,p_asset_balance.book_type_code)) THEN

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

792: IF NOT (igi_iac_common_utils.iac_round(l_deprn_catchup_amount,p_asset_balance.book_type_code)) THEN
793: return FALSE;
794: END IF;
795:
796: IF NOT (igi_iac_common_utils.iac_round(l_fa_deprn_catchup_amount,p_asset_balance.book_type_code)) THEN
797: return FALSE;
798: END IF;
799:
800: /* Bug 2961656 vgadde 08-jul-2003 Start(6) */

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

797: return FALSE;
798: END IF;
799:
800: /* Bug 2961656 vgadde 08-jul-2003 Start(6) */
801: IF NOT (igi_iac_common_utils.iac_round(l_iac_deprn_amount_py,p_asset_balance.book_type_code)) THEN
802: return FALSE;
803: END IF;
804:
805: IF NOT (igi_iac_common_utils.iac_round(l_iac_deprn_amount_cy,p_asset_balance.book_type_code)) THEN

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

801: IF NOT (igi_iac_common_utils.iac_round(l_iac_deprn_amount_py,p_asset_balance.book_type_code)) THEN
802: return FALSE;
803: END IF;
804:
805: IF NOT (igi_iac_common_utils.iac_round(l_iac_deprn_amount_cy,p_asset_balance.book_type_code)) THEN
806: return FALSE;
807: END IF;
808: /* Bug 2961656 vgadde 08-jul-2003 End(6) */
809:

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

837: ELSE
838: l_last_deprn_catchup_period := p_period_counter - 1;
839: END IF;
840:
841: IF NOT igi_iac_common_utils.get_period_info_for_counter(p_asset_balance.book_type_code,
842: l_last_deprn_catchup_period,
843: l_last_catchup_prd_rec) THEN
844: return FALSE;
845: END IF;

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

843: l_last_catchup_prd_rec) THEN
844: return FALSE;
845: END IF;
846:
847: IF NOT igi_iac_common_utils.get_period_info_for_counter(p_asset_balance.book_type_code,
848: p_period_counter_from-1,
849: l_last_reval_prd_rec) THEN
850: return FALSE;
851: END IF;

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

855: /* Accounting entries to be created */
856: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
857: p_full_path => l_path_name,
858: p_string => ' Inserting records into IAC tables');
859: IF NOT (igi_iac_common_utils.get_book_gl_info(p_asset_balance.book_type_code ,
860: l_set_of_books_id ,
861: l_chart_of_accts_id ,
862: l_currency_code ,
863: l_precision )) THEN

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

979: l_fa_active_dists_YTD := l_fa_all_dists_YTD - l_fa_inactive_dists_YTD;
980: END IF;
981:
982:
983: IF NOT igi_iac_common_utils.Prorate_Amt_to_Active_Dists( l_transaction.book_type_Code ,
984: l_transaction.Asset_id ,
985: l_deprn_catchup_amount ,
986: l_distributions_tab ) THEN
987: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,

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

989: p_string => '*** Error in prorating catchup amount to active distributions');
990: return FALSE;
991: END IF;
992:
993: IF NOT igi_iac_common_utils.Prorate_Amt_to_Active_Dists( l_transaction.book_type_Code ,
994: l_transaction.Asset_id ,
995: l_fa_deprn_catchup_amount ,
996: l_fa_dist_catchup_tab ) THEN
997: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,

Line 1024: IF NOT igi_iac_common_utils.iac_round(l_distribution_amount,

1020:
1021: l_distribution_amount := l_distributions_tab(l_idx).amount;
1022: l_dist_period_amount := l_iac_deprn_amount_cy * l_distributions_tab(l_idx).prorate_factor;
1023:
1024: IF NOT igi_iac_common_utils.iac_round(l_distribution_amount,
1025: l_transaction.book_type_code) THEN
1026: return FALSE;
1027: END IF;
1028:

Line 1029: IF NOT igi_iac_common_utils.iac_round(l_dist_period_amount,

1025: l_transaction.book_type_code) THEN
1026: return FALSE;
1027: END IF;
1028:
1029: IF NOT igi_iac_common_utils.iac_round(l_dist_period_amount,
1030: l_transaction.book_type_code) THEN
1031: return FALSE;
1032: END IF;
1033:

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

1038: l_account_ccid := NULL ;
1039: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1040: p_full_path => l_path_name,
1041: p_string => ' Inserting records into igi_iac_adjustments');
1042: IF NOT (igi_iac_common_utils.get_account_ccid(l_transaction.book_type_code ,
1043: l_transaction.asset_id ,
1044: l_distributions_tab(l_idx).distribution_id ,
1045: 'DEPRN_EXPENSE_ACCT' ,
1046: l_account_ccid )) THEN

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

1070: X_event_id => p_event_id ) ;
1071:
1072: l_rowid := NULL;
1073: l_account_ccid := NULL ;
1074: IF NOT (igi_iac_common_utils.get_account_ccid(l_transaction.book_type_code ,
1075: l_transaction.asset_id ,
1076: l_distributions_tab(l_idx).distribution_id ,
1077: 'DEPRN_RESERVE_ACCT' ,
1078: l_account_ccid )) THEN

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

1106: l_rowid := NULL;
1107: l_account_ccid := NULL ;
1108: l_reval_rsv_ccid := Null;
1109:
1110: IF NOT (igi_iac_common_utils.get_account_ccid(l_transaction.book_type_code ,
1111: l_transaction.asset_id ,
1112: l_distributions_tab(l_idx).distribution_id ,
1113: 'REVAL_RESERVE_ACCT' ,
1114: l_account_ccid )) THEN

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

1139: X_event_id => p_event_id ) ;
1140:
1141: l_rowid := NULL;
1142: l_account_ccid := NULL ;
1143: IF NOT (igi_iac_common_utils.get_account_ccid(l_transaction.book_type_code ,
1144: l_transaction.asset_id ,
1145: l_distributions_tab(l_idx).distribution_id ,
1146: 'GENERAL_FUND_ACCT' ,
1147: l_account_ccid )) THEN

Line 1200: IF NOT igi_iac_common_utils.iac_round(l_deprn_ytd,

1196: ELSE
1197: l_deprn_ytd := (l_iac_active_dists_YTD * l_distributions_tab(l_idx).prorate_factor);
1198: END IF;
1199:
1200: IF NOT igi_iac_common_utils.iac_round(l_deprn_ytd,
1201: l_transaction.book_type_code) THEN
1202: return FALSE;
1203: END IF;
1204:

Line 1306: IF NOT igi_iac_common_utils.iac_round(l_fa_deprn_period_amount,

1302: ELSE
1303: l_fa_deprn_period_amount := p_fa_deprn_expense_cy * l_fa_dist_catchup_tab(l_idx).prorate_factor;
1304: END IF;
1305:
1306: IF NOT igi_iac_common_utils.iac_round(l_fa_deprn_period_amount,
1307: l_iac_fa_deprn_rec.book_type_code) THEN
1308: return FALSE;
1309: END IF;
1310:

Line 1311: IF NOT igi_iac_common_utils.iac_round(l_deprn_ytd,

1307: l_iac_fa_deprn_rec.book_type_code) THEN
1308: return FALSE;
1309: END IF;
1310:
1311: IF NOT igi_iac_common_utils.iac_round(l_deprn_ytd,
1312: l_iac_fa_deprn_rec.book_type_code) THEN
1313: return FALSE;
1314: END IF;
1315:

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

1312: l_iac_fa_deprn_rec.book_type_code) THEN
1313: return FALSE;
1314: END IF;
1315:
1316: IF NOT igi_iac_common_utils.iac_round(l_fa_dist_catchup_tab(l_idx).amount,
1317: l_iac_fa_deprn_rec.book_type_code) THEN
1318: return FALSE;
1319: END IF;
1320:

Line 1502: IF NOT igi_iac_common_utils.get_period_info_for_date(

1498: OPEN c_fa_asset_info;
1499: FETCH c_fa_asset_info INTO l_fa_asset_info;
1500: CLOSE c_fa_asset_info;
1501:
1502: IF NOT igi_iac_common_utils.get_period_info_for_date(
1503: p_reval_asset_params(1).book_type_code,
1504: l_fa_asset_info.date_placed_in_service,
1505: l_dpis_period) THEN
1506: return FALSE;

Line 1513: IF NOT igi_iac_common_utils.get_price_index_value(

1509: p_full_path => l_path_name,
1510: p_string => ' DPIS Period Info');
1511: Debug_Period(l_dpis_period);
1512:
1513: IF NOT igi_iac_common_utils.get_price_index_value(
1514: p_reval_asset_params(1).book_type_code,
1515: p_reval_asset_params(1).asset_id,
1516: l_dpis_period.period_name,
1517: l_dpis_price_index) THEN

Line 1557: IF NOT (igi_iac_common_utils.get_period_info_for_counter(

1553:
1554:
1555: FOR idx IN p_reval_control.FIRST..p_reval_control.LAST LOOP
1556:
1557: IF NOT (igi_iac_common_utils.get_period_info_for_counter(
1558: p_reval_asset_params(idx).book_type_code,
1559: p_reval_asset_params(idx).period_counter,
1560: l_curr_period)) THEN
1561: return FALSE;

Line 1564: IF NOT (igi_iac_common_utils.get_price_index_value(

1560: l_curr_period)) THEN
1561: return FALSE;
1562: END IF;
1563:
1564: IF NOT (igi_iac_common_utils.get_price_index_value(
1565: p_reval_asset_params(idx).book_type_code,
1566: p_reval_asset_params(idx).asset_id,
1567: l_curr_period.period_name,
1568: l_curr_price_index)) THEN

Line 1736: IF NOT (igi_iac_common_utils.get_period_info_for_counter(

1732:
1733: ---Get the details for supplied depreciation and YTD --------
1734: IF ((p_calling_function = 'ADDITION') AND (NVL(l_booksrow_YTD,0) <> 0) AND (p_asset_last_period IS NuLL)) THEN -- supplied YYD
1735:
1736: IF NOT (igi_iac_common_utils.get_period_info_for_counter(
1737: p_reval_asset_params(idx).book_type_code,
1738: p_period_counter-1,
1739: l_open_period)) THEN
1740: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,

Line 1829: IF NOT (igi_iac_common_utils.get_period_info_for_counter(

1825: RETURN FALSE;
1826: END IF;
1827: ELSE
1828:
1829: IF NOT (igi_iac_common_utils.get_period_info_for_counter(
1830: p_reval_asset_params(idx).book_type_code,
1831: p_period_counter,
1832: l_open_period)) THEN
1833: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,

Line 1840: IF NOT igi_iac_common_utils.get_period_info_for_counter(

1836: return FALSE;
1837: END IF;
1838:
1839: IF p_asset_last_period IS NOT NULL THEN
1840: IF NOT igi_iac_common_utils.get_period_info_for_counter(
1841: p_reval_asset_params(idx).book_type_code,
1842: p_asset_last_period,
1843: l_last_deprn_period) THEN
1844: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,