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_REINSTATE_PKG dependencies on IGI_IAC_FA_DEPRN

Line 145: -- igi_iac_fa_deprn for a adjustment_id and

141: ORDER BY iidb.distribution_id;
142:
143: /* Bug 2906934 vgadde 25/04/2003 Start(1) */
144: -- Cursor to fetch depreciation balances from
145: -- igi_iac_fa_deprn for a adjustment_id and
146: -- distribution_id
147: CURSOR c_get_fa_deprn(cp_adjustment_id NUMBER,cp_distribution_id NUMBER) IS
148: SELECT iifd.deprn_period,
149: iifd.deprn_ytd,

Line 151: FROM igi_iac_fa_deprn iifd

147: CURSOR c_get_fa_deprn(cp_adjustment_id NUMBER,cp_distribution_id NUMBER) IS
148: SELECT iifd.deprn_period,
149: iifd.deprn_ytd,
150: iifd.deprn_reserve
151: FROM igi_iac_fa_deprn iifd
152: WHERE iifd.adjustment_id = cp_adjustment_id
153: AND iifd.distribution_id = cp_distribution_id;
154:
155: -- Cursor to fetch depreciation balances from

Line 247: -- cursor to retrieve a row from igi_iac_fa_deprn

243: WHERE iidb.adjustment_id = n_adjust_id
244: AND iidb.distribution_id = n_dist_id;
245:
246: -- bug 2480915, start (1)
247: -- cursor to retrieve a row from igi_iac_fa_deprn
248:
249: CURSOR c_fa_deprn(n_adjust_id NUMBER,
250: n_dist_id NUMBER,
251: n_prd_cnt NUMBER)

Line 262: FROM igi_iac_fa_deprn ifd

258: ifd.deprn_period,
259: ifd.deprn_ytd,
260: ifd.deprn_reserve,
261: ifd.active_flag
262: FROM igi_iac_fa_deprn ifd
263: WHERE ifd.adjustment_id = n_adjust_id
264: AND ifd.distribution_id = n_dist_id
265: AND ifd.period_counter = n_prd_cnt;
266:

Line 544: l_fa_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;

540: l_ret_ass_bal c_ret_ass_bal%ROWTYPE;
541: l_units_assigned fa_distribution_history.units_assigned%TYPE;
542:
543: -- bug 2480915 start(1)
544: l_fa_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
545: l_fa_deprn_period igi_iac_fa_deprn.deprn_period%TYPE;
546: l_fa_deprn_reserve igi_iac_fa_deprn.deprn_reserve%TYPE;
547: -- bug 2480915 end(1)
548: l_active_flag igi_iac_det_balances.active_flag%TYPE;

Line 545: l_fa_deprn_period igi_iac_fa_deprn.deprn_period%TYPE;

541: l_units_assigned fa_distribution_history.units_assigned%TYPE;
542:
543: -- bug 2480915 start(1)
544: l_fa_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
545: l_fa_deprn_period igi_iac_fa_deprn.deprn_period%TYPE;
546: l_fa_deprn_reserve igi_iac_fa_deprn.deprn_reserve%TYPE;
547: -- bug 2480915 end(1)
548: l_active_flag igi_iac_det_balances.active_flag%TYPE;
549:

Line 546: l_fa_deprn_reserve igi_iac_fa_deprn.deprn_reserve%TYPE;

542:
543: -- bug 2480915 start(1)
544: l_fa_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
545: l_fa_deprn_period igi_iac_fa_deprn.deprn_period%TYPE;
546: l_fa_deprn_reserve igi_iac_fa_deprn.deprn_reserve%TYPE;
547: -- bug 2480915 end(1)
548: l_active_flag igi_iac_det_balances.active_flag%TYPE;
549:
550: -- exceptions

Line 663: -- get the deprn values from igi_iac_fa_deprn or fa_deprn_detail

659: l_operating_acct_net := l_operating_acct_cost - l_operating_acct_backlog;
660: l_net_book_value := l_adjustment_cost - (l_deprn_reserve + l_deprn_reserve_backlog);
661:
662: -- bug 2480915 start(5) Modified for bug 2906034
663: -- get the deprn values from igi_iac_fa_deprn or fa_deprn_detail
664: OPEN c_get_fa_deprn(l_prev_adj_id, l_det_bal.distribution_id);
665: FETCH c_get_fa_deprn INTO l_fa_deprn_period, l_fa_deprn_ytd, l_fa_deprn_reserve;
666: IF c_get_fa_deprn%NOTFOUND THEN
667: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Record not found in igi_iac_fa_deprn');

Line 667: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Record not found in igi_iac_fa_deprn');

663: -- get the deprn values from igi_iac_fa_deprn or fa_deprn_detail
664: OPEN c_get_fa_deprn(l_prev_adj_id, l_det_bal.distribution_id);
665: FETCH c_get_fa_deprn INTO l_fa_deprn_period, l_fa_deprn_ytd, l_fa_deprn_reserve;
666: IF c_get_fa_deprn%NOTFOUND THEN
667: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Record not found in igi_iac_fa_deprn');
668: OPEN c_get_fa_det(g_book_type_code,
669: g_asset_id,
670: l_det_bal.distribution_id,
671: l_det_bal.period_counter);

Line 684: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Record found in igi_iac_fa_deprn');

680: l_fa_deprn_ytd := 0;
681: END IF;
682: CLOSE c_get_fa_ytd;
683: ELSE
684: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Record found in igi_iac_fa_deprn');
685: IF l_fully_reserved > 0 THEN
686: l_fa_deprn_period := 0;
687: END IF;
688: IF (p_transaction_run = 'SECOND') THEN

Line 751: -- insert into igi_iac_fa_deprn with the reinstatement adjustment_id

747: x_mode => 'R'
748: );
749:
750: -- Bug 2480915, start(6)
751: -- insert into igi_iac_fa_deprn with the reinstatement adjustment_id
752: IGI_IAC_FA_DEPRN_PKG.Insert_Row(
753: x_rowid => l_rowid,
754: x_book_type_code => g_book_type_code,
755: x_asset_id => g_asset_id,

Line 752: IGI_IAC_FA_DEPRN_PKG.Insert_Row(

748: );
749:
750: -- Bug 2480915, start(6)
751: -- insert into igi_iac_fa_deprn with the reinstatement adjustment_id
752: IGI_IAC_FA_DEPRN_PKG.Insert_Row(
753: x_rowid => l_rowid,
754: x_book_type_code => g_book_type_code,
755: x_asset_id => g_asset_id,
756: x_period_counter => p_period_counter,

Line 977: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Record not found in igi_iac_fa_deprn');

973: -- Bug 2480915, start(7) Modified for 2906034
974: OPEN c_get_fa_deprn(l_get_ytd.adjustment_id, l_get_ytd.distribution_id);
975: FETCH c_get_fa_deprn INTO l_fa_deprn_period, l_fa_deprn_ytd, l_fa_deprn_reserve;
976: IF c_get_fa_deprn%NOTFOUND THEN
977: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Record not found in igi_iac_fa_deprn');
978: OPEN c_get_fa_ytd(g_book_type_code,
979: g_asset_id,
980: l_get_ytd.distribution_id);
981: FETCH c_get_fa_ytd INTO l_fa_deprn_ytd;

Line 993: -- insert into igi_iac_fa_deprn with the reinstatement adjustment_id

989:
990: IF nvl(l_get_ytd.active_flag,'Y') = 'Y' THEN
991: l_fa_deprn_ytd := 0;
992: END IF;
993: -- insert into igi_iac_fa_deprn with the reinstatement adjustment_id
994: IGI_IAC_FA_DEPRN_PKG.Insert_Row(
995: x_rowid => l_rowid,
996: x_book_type_code => g_book_type_code,
997: x_asset_id => g_asset_id,

Line 994: IGI_IAC_FA_DEPRN_PKG.Insert_Row(

990: IF nvl(l_get_ytd.active_flag,'Y') = 'Y' THEN
991: l_fa_deprn_ytd := 0;
992: END IF;
993: -- insert into igi_iac_fa_deprn with the reinstatement adjustment_id
994: IGI_IAC_FA_DEPRN_PKG.Insert_Row(
995: x_rowid => l_rowid,
996: x_book_type_code => g_book_type_code,
997: x_asset_id => g_asset_id,
998: x_period_counter => p_period_counter,

Line 1233: l_fa_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;

1229: l_units_assigned fa_distribution_history.units_assigned%TYPE;
1230: l_fully_reserved NUMBER;
1231:
1232: -- bug 2480915 start(8)
1233: l_fa_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1234: l_fa_deprn_period igi_iac_fa_deprn.deprn_period%TYPE;
1235: l_fa_deprn_reserve igi_iac_fa_deprn.deprn_reserve%TYPE;
1236: -- bug 2480915 end(8)
1237: l_ret boolean;

Line 1234: l_fa_deprn_period igi_iac_fa_deprn.deprn_period%TYPE;

1230: l_fully_reserved NUMBER;
1231:
1232: -- bug 2480915 start(8)
1233: l_fa_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1234: l_fa_deprn_period igi_iac_fa_deprn.deprn_period%TYPE;
1235: l_fa_deprn_reserve igi_iac_fa_deprn.deprn_reserve%TYPE;
1236: -- bug 2480915 end(8)
1237: l_ret boolean;
1238: -- exceptions

Line 1235: l_fa_deprn_reserve igi_iac_fa_deprn.deprn_reserve%TYPE;

1231:
1232: -- bug 2480915 start(8)
1233: l_fa_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1234: l_fa_deprn_period igi_iac_fa_deprn.deprn_period%TYPE;
1235: l_fa_deprn_reserve igi_iac_fa_deprn.deprn_reserve%TYPE;
1236: -- bug 2480915 end(8)
1237: l_ret boolean;
1238: -- exceptions
1239: e_no_ccid_found EXCEPTION;

Line 1362: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Record not found in igi_iac_fa_deprn');

1358: -- bug 2480915 start(12) Modified for Bug 2906034
1359: OPEN c_get_fa_deprn(l_prev_adj_id, l_det_bal.distribution_id);
1360: FETCH c_get_fa_deprn INTO l_fa_deprn_period, l_fa_deprn_ytd, l_fa_deprn_reserve;
1361: IF c_get_fa_deprn%NOTFOUND THEN
1362: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Record not found in igi_iac_fa_deprn');
1363: OPEN c_get_fa_det(g_book_type_code,
1364: g_asset_id,
1365: l_det_bal.distribution_id,
1366: l_det_bal.period_counter);

Line 1379: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Record found in igi_iac_fa_deprn');

1375: l_fa_deprn_ytd := 0;
1376: END IF;
1377: CLOSE c_get_fa_ytd;
1378: ELSE
1379: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Record found in igi_iac_fa_deprn');
1380: IF l_fully_reserved > 0 THEN
1381: l_fa_deprn_period := 0;
1382: END IF;
1383: IF (p_transaction_run = 'SECOND') THEN

Line 1447: -- insert into igi_iac_fa_deprn with the reinstatement adjustment_id

1443: );
1444:
1445: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Inserted into det balances dist id '||l_det_bal.distribution_id);
1446: -- Bug 2480915, start(13)
1447: -- insert into igi_iac_fa_deprn with the reinstatement adjustment_id
1448: IGI_IAC_FA_DEPRN_PKG.Insert_Row(
1449: x_rowid => l_rowid,
1450: x_book_type_code => g_book_type_code,
1451: x_asset_id => g_asset_id,

Line 1448: IGI_IAC_FA_DEPRN_PKG.Insert_Row(

1444:
1445: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Inserted into det balances dist id '||l_det_bal.distribution_id);
1446: -- Bug 2480915, start(13)
1447: -- insert into igi_iac_fa_deprn with the reinstatement adjustment_id
1448: IGI_IAC_FA_DEPRN_PKG.Insert_Row(
1449: x_rowid => l_rowid,
1450: x_book_type_code => g_book_type_code,
1451: x_asset_id => g_asset_id,
1452: x_period_counter => p_period_counter,

Line 1681: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Record not found in igi_iac_fa_deprn');

1677: -- Bug 2480915, start(14)
1678: OPEN c_get_fa_deprn(l_get_ytd.adjustment_id, l_get_ytd.distribution_id);
1679: FETCH c_get_fa_deprn INTO l_fa_deprn_period, l_fa_deprn_ytd, l_fa_deprn_reserve;
1680: IF c_get_fa_deprn%NOTFOUND THEN
1681: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Record not found in igi_iac_fa_deprn');
1682: OPEN c_get_fa_ytd(g_book_type_code,
1683: g_asset_id,
1684: l_get_ytd.distribution_id);
1685: FETCH c_get_fa_ytd INTO l_fa_deprn_ytd;

Line 1694: -- insert into igi_iac_fa_deprn with the reinstatement adjustment_id

1690: END IF;
1691: CLOSE c_get_fa_deprn;
1692: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'In YTD: YTD deprn: '||l_fa_deprn_ytd);
1693:
1694: -- insert into igi_iac_fa_deprn with the reinstatement adjustment_id
1695: IGI_IAC_FA_DEPRN_PKG.Insert_Row(
1696: x_rowid => l_rowid,
1697: x_book_type_code => g_book_type_code,
1698: x_asset_id => g_asset_id,

Line 1695: IGI_IAC_FA_DEPRN_PKG.Insert_Row(

1691: CLOSE c_get_fa_deprn;
1692: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'In YTD: YTD deprn: '||l_fa_deprn_ytd);
1693:
1694: -- insert into igi_iac_fa_deprn with the reinstatement adjustment_id
1695: IGI_IAC_FA_DEPRN_PKG.Insert_Row(
1696: x_rowid => l_rowid,
1697: x_book_type_code => g_book_type_code,
1698: x_asset_id => g_asset_id,
1699: x_period_counter => p_period_counter,

Line 2012: l_fa_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;

2008: l_fully_reserved NUMBER;
2009: l_exists NUMBER;
2010:
2011: -- bug 2480915 start(15)
2012: l_fa_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
2013: l_fa_deprn_period igi_iac_fa_deprn.deprn_period%TYPE;
2014: l_fa_deprn_reserve igi_iac_fa_deprn.deprn_reserve%TYPE;
2015: -- bug 2480915 end(15)
2016: l_active_flag igi_iac_det_balances.active_flag%TYPE;

Line 2013: l_fa_deprn_period igi_iac_fa_deprn.deprn_period%TYPE;

2009: l_exists NUMBER;
2010:
2011: -- bug 2480915 start(15)
2012: l_fa_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
2013: l_fa_deprn_period igi_iac_fa_deprn.deprn_period%TYPE;
2014: l_fa_deprn_reserve igi_iac_fa_deprn.deprn_reserve%TYPE;
2015: -- bug 2480915 end(15)
2016: l_active_flag igi_iac_det_balances.active_flag%TYPE;
2017:

Line 2014: l_fa_deprn_reserve igi_iac_fa_deprn.deprn_reserve%TYPE;

2010:
2011: -- bug 2480915 start(15)
2012: l_fa_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
2013: l_fa_deprn_period igi_iac_fa_deprn.deprn_period%TYPE;
2014: l_fa_deprn_reserve igi_iac_fa_deprn.deprn_reserve%TYPE;
2015: -- bug 2480915 end(15)
2016: l_active_flag igi_iac_det_balances.active_flag%TYPE;
2017:
2018: -- exceptions

Line 2138: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Record not found in igi_iac_fa_deprn');

2134: -- bug 2480915 start(19) Modified for bug 2906034
2135: OPEN c_get_fa_deprn(l_prev_adj_id, l_det_bal.distribution_id);
2136: FETCH c_get_fa_deprn INTO l_fa_deprn_period, l_fa_deprn_ytd, l_fa_deprn_reserve;
2137: IF c_get_fa_deprn%NOTFOUND THEN
2138: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Record not found in igi_iac_fa_deprn');
2139: OPEN c_get_fa_det(g_book_type_code,
2140: g_asset_id,
2141: l_det_bal.distribution_id,
2142: l_det_bal.period_counter);

Line 2155: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Record found in igi_iac_fa_deprn');

2151: l_fa_deprn_ytd := 0;
2152: END IF;
2153: CLOSE c_get_fa_ytd;
2154: ELSE
2155: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Record found in igi_iac_fa_deprn');
2156: IF l_fully_reserved > 0 THEN
2157: l_fa_deprn_period := 0;
2158: END IF;
2159: IF (p_transaction_run = 'SECOND') THEN

Line 2221: -- insert into igi_iac_fa_deprn with the reinstatement adjustment_id

2217: x_mode => 'R'
2218: );
2219:
2220: -- Bug 2480915, start(20)
2221: -- insert into igi_iac_fa_deprn with the reinstatement adjustment_id
2222: IGI_IAC_FA_DEPRN_PKG.Insert_Row(
2223: x_rowid => l_rowid,
2224: x_book_type_code => g_book_type_code,
2225: x_asset_id => g_asset_id,

Line 2222: IGI_IAC_FA_DEPRN_PKG.Insert_Row(

2218: );
2219:
2220: -- Bug 2480915, start(20)
2221: -- insert into igi_iac_fa_deprn with the reinstatement adjustment_id
2222: IGI_IAC_FA_DEPRN_PKG.Insert_Row(
2223: x_rowid => l_rowid,
2224: x_book_type_code => g_book_type_code,
2225: x_asset_id => g_asset_id,
2226: x_period_counter => p_period_counter,

Line 2461: -- insert into igi_iac_fa_deprn with the reinstatement adjustment_id

2457: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Inserted YTD for partially retired distribution: '||l_ret_dist_id);
2458: -- bug 2485778, end 2
2459:
2460: -- Bug 2480915, start(21) Modified for 2906034
2461: -- insert into igi_iac_fa_deprn with the reinstatement adjustment_id
2462: OPEN c_get_fa_deprn(l_ret_ytd.adjustment_id, l_ret_ytd.distribution_id);
2463: FETCH c_get_fa_deprn INTO l_fa_deprn_period, l_fa_deprn_ytd, l_fa_deprn_reserve;
2464: IF c_get_fa_deprn%NOTFOUND THEN
2465: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Record not found in igi_iac_fa_deprn');

Line 2465: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Record not found in igi_iac_fa_deprn');

2461: -- insert into igi_iac_fa_deprn with the reinstatement adjustment_id
2462: OPEN c_get_fa_deprn(l_ret_ytd.adjustment_id, l_ret_ytd.distribution_id);
2463: FETCH c_get_fa_deprn INTO l_fa_deprn_period, l_fa_deprn_ytd, l_fa_deprn_reserve;
2464: IF c_get_fa_deprn%NOTFOUND THEN
2465: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Record not found in igi_iac_fa_deprn');
2466: OPEN c_get_fa_ytd(g_book_type_code,
2467: g_asset_id,
2468: l_ret_ytd.distribution_id);
2469: FETCH c_get_fa_ytd INTO l_fa_deprn_ytd;

Line 2478: IGI_IAC_FA_DEPRN_PKG.Insert_Row(

2474: END IF;
2475: CLOSE c_get_fa_deprn;
2476:
2477: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'In YTD: YTD deprn: '||l_fa_deprn_ytd);
2478: IGI_IAC_FA_DEPRN_PKG.Insert_Row(
2479: x_rowid => l_rowid,
2480: x_book_type_code => g_book_type_code,
2481: x_asset_id => g_asset_id,
2482: x_period_counter => p_period_counter,

Line 2715: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Record not found in igi_iac_fa_deprn');

2711: -- Bug 2480915, start(22)
2712: OPEN c_get_fa_deprn(l_get_ytd.adjustment_id, l_get_ytd.distribution_id);
2713: FETCH c_get_fa_deprn INTO l_fa_deprn_period, l_fa_deprn_ytd, l_fa_deprn_reserve;
2714: IF c_get_fa_deprn%NOTFOUND THEN
2715: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Record not found in igi_iac_fa_deprn');
2716: OPEN c_get_fa_ytd(g_book_type_code,
2717: g_asset_id,
2718: l_get_ytd.distribution_id);
2719: FETCH c_get_fa_ytd INTO l_fa_deprn_ytd;

Line 2731: -- insert into igi_iac_fa_deprn with the reinstatement adjustment_id

2727: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'In YTD: YTD deprn: '||l_fa_deprn_ytd);
2728: IF nvl(l_get_ytd.active_flag,'Y') = 'Y' THEN
2729: l_fa_deprn_ytd := 0;
2730: END IF;
2731: -- insert into igi_iac_fa_deprn with the reinstatement adjustment_id
2732: IGI_IAC_FA_DEPRN_PKG.Insert_Row(
2733: x_rowid => l_rowid,
2734: x_book_type_code => g_book_type_code,
2735: x_asset_id => g_asset_id,

Line 2732: IGI_IAC_FA_DEPRN_PKG.Insert_Row(

2728: IF nvl(l_get_ytd.active_flag,'Y') = 'Y' THEN
2729: l_fa_deprn_ytd := 0;
2730: END IF;
2731: -- insert into igi_iac_fa_deprn with the reinstatement adjustment_id
2732: IGI_IAC_FA_DEPRN_PKG.Insert_Row(
2733: x_rowid => l_rowid,
2734: x_book_type_code => g_book_type_code,
2735: x_asset_id => g_asset_id,
2736: x_period_counter => p_period_counter,

Line 3432: -- bug 2480915 start, call ytd preprocessor to populate igi_iac_fa_deprn

3428: FROM fa_additions_b
3429: WHERE asset_id = p_asset_id;
3430: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'There is an IAC effect on the asset: '||l_asset_num);
3431:
3432: -- bug 2480915 start, call ytd preprocessor to populate igi_iac_fa_deprn
3433: -- if no entries exist for the book in the table
3434: IF NOT igi_iac_common_utils.populate_iac_fa_deprn_data(p_book_type_code,
3435: 'REINSTATEMENT')
3436: THEN

Line 3437: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Problems creating rows in igi_iac_fa_deprn');

3433: -- if no entries exist for the book in the table
3434: IF NOT igi_iac_common_utils.populate_iac_fa_deprn_data(p_book_type_code,
3435: 'REINSTATEMENT')
3436: THEN
3437: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Problems creating rows in igi_iac_fa_deprn');
3438: RAISE e_iac_fa_deprn;
3439: END IF;
3440: -- bug 2480915, end
3441:

Line 3633: g_message := 'Could not create the ytd rows in igi_iac_fa_deprn';

3629: IF c_fa_trx_headers%ISOPEN THEN
3630: CLOSE c_fa_trx_headers;
3631: END IF;
3632:
3633: g_message := 'Could not create the ytd rows in igi_iac_fa_deprn';
3634: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,g_message);
3635: FA_SRVR_MSG.add_message(
3636: Calling_Fn => g_calling_fn,
3637: Name => 'IGI_IAC_FA_DEPR_CREATE_PROB',