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 566: l_fa_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;

562: l_ret_ass_bal c_ret_ass_bal%ROWTYPE;
563: l_units_assigned fa_distribution_history.units_assigned%TYPE;
564:
565: -- bug 2480915 start(1)
566: l_fa_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
567: l_fa_deprn_period igi_iac_fa_deprn.deprn_period%TYPE;
568: l_fa_deprn_reserve igi_iac_fa_deprn.deprn_reserve%TYPE;
569: -- bug 2480915 end(1)
570: l_active_flag igi_iac_det_balances.active_flag%TYPE;

Line 567: l_fa_deprn_period igi_iac_fa_deprn.deprn_period%TYPE;

563: l_units_assigned fa_distribution_history.units_assigned%TYPE;
564:
565: -- bug 2480915 start(1)
566: l_fa_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
567: l_fa_deprn_period igi_iac_fa_deprn.deprn_period%TYPE;
568: l_fa_deprn_reserve igi_iac_fa_deprn.deprn_reserve%TYPE;
569: -- bug 2480915 end(1)
570: l_active_flag igi_iac_det_balances.active_flag%TYPE;
571:

Line 568: l_fa_deprn_reserve igi_iac_fa_deprn.deprn_reserve%TYPE;

564:
565: -- bug 2480915 start(1)
566: l_fa_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
567: l_fa_deprn_period igi_iac_fa_deprn.deprn_period%TYPE;
568: l_fa_deprn_reserve igi_iac_fa_deprn.deprn_reserve%TYPE;
569: -- bug 2480915 end(1)
570: l_active_flag igi_iac_det_balances.active_flag%TYPE;
571:
572: -- exceptions

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

683: l_operating_acct_net := l_operating_acct_cost - l_operating_acct_backlog;
684: l_net_book_value := l_adjustment_cost - (l_deprn_reserve + l_deprn_reserve_backlog);
685:
686: -- bug 2480915 start(5) Modified for bug 2906034
687: -- get the deprn values from igi_iac_fa_deprn or fa_deprn_detail
688: OPEN c_get_fa_deprn(l_prev_adj_id, l_det_bal.distribution_id);
689: FETCH c_get_fa_deprn INTO l_fa_deprn_period, l_fa_deprn_ytd, l_fa_deprn_reserve;
690: IF c_get_fa_deprn%NOTFOUND THEN
691: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Record not found in igi_iac_fa_deprn');

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

687: -- get the deprn values from igi_iac_fa_deprn or fa_deprn_detail
688: OPEN c_get_fa_deprn(l_prev_adj_id, l_det_bal.distribution_id);
689: FETCH c_get_fa_deprn INTO l_fa_deprn_period, l_fa_deprn_ytd, l_fa_deprn_reserve;
690: IF c_get_fa_deprn%NOTFOUND THEN
691: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Record not found in igi_iac_fa_deprn');
692: OPEN c_get_fa_det(g_book_type_code,
693: g_asset_id,
694: l_det_bal.distribution_id,
695: l_det_bal.period_counter);

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

704: l_fa_deprn_ytd := 0;
705: END IF;
706: CLOSE c_get_fa_ytd;
707: ELSE
708: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Record found in igi_iac_fa_deprn');
709: IF l_fully_reserved > 0 THEN
710: l_fa_deprn_period := 0;
711: END IF;
712: IF (p_transaction_run = 'SECOND') THEN

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

773: x_mode => 'R'
774: );
775:
776: -- Bug 2480915, start(6)
777: -- insert into igi_iac_fa_deprn with the reinstatement adjustment_id
778: IGI_IAC_FA_DEPRN_PKG.Insert_Row(
779: x_rowid => l_rowid,
780: x_book_type_code => g_book_type_code,
781: x_asset_id => g_asset_id,

Line 778: IGI_IAC_FA_DEPRN_PKG.Insert_Row(

774: );
775:
776: -- Bug 2480915, start(6)
777: -- insert into igi_iac_fa_deprn with the reinstatement adjustment_id
778: IGI_IAC_FA_DEPRN_PKG.Insert_Row(
779: x_rowid => l_rowid,
780: x_book_type_code => g_book_type_code,
781: x_asset_id => g_asset_id,
782: x_period_counter => p_period_counter,

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

999: -- Bug 2480915, start(7) Modified for 2906034
1000: OPEN c_get_fa_deprn(l_get_ytd.adjustment_id, l_get_ytd.distribution_id);
1001: FETCH c_get_fa_deprn INTO l_fa_deprn_period, l_fa_deprn_ytd, l_fa_deprn_reserve;
1002: IF c_get_fa_deprn%NOTFOUND THEN
1003: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Record not found in igi_iac_fa_deprn');
1004: OPEN c_get_fa_ytd(g_book_type_code,
1005: g_asset_id,
1006: l_get_ytd.distribution_id);
1007: FETCH c_get_fa_ytd INTO l_fa_deprn_ytd;

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

1015:
1016: IF nvl(l_get_ytd.active_flag,'Y') = 'Y' THEN
1017: l_fa_deprn_ytd := 0;
1018: END IF;
1019: -- insert into igi_iac_fa_deprn with the reinstatement adjustment_id
1020: IGI_IAC_FA_DEPRN_PKG.Insert_Row(
1021: x_rowid => l_rowid,
1022: x_book_type_code => g_book_type_code,
1023: x_asset_id => g_asset_id,

Line 1020: IGI_IAC_FA_DEPRN_PKG.Insert_Row(

1016: IF nvl(l_get_ytd.active_flag,'Y') = 'Y' THEN
1017: l_fa_deprn_ytd := 0;
1018: END IF;
1019: -- insert into igi_iac_fa_deprn with the reinstatement adjustment_id
1020: IGI_IAC_FA_DEPRN_PKG.Insert_Row(
1021: x_rowid => l_rowid,
1022: x_book_type_code => g_book_type_code,
1023: x_asset_id => g_asset_id,
1024: x_period_counter => p_period_counter,

Line 1259: l_fa_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;

1255: l_units_assigned fa_distribution_history.units_assigned%TYPE;
1256: l_fully_reserved NUMBER;
1257:
1258: -- bug 2480915 start(8)
1259: l_fa_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1260: l_fa_deprn_period igi_iac_fa_deprn.deprn_period%TYPE;
1261: l_fa_deprn_reserve igi_iac_fa_deprn.deprn_reserve%TYPE;
1262: -- bug 2480915 end(8)
1263: l_ret boolean;

Line 1260: l_fa_deprn_period igi_iac_fa_deprn.deprn_period%TYPE;

1256: l_fully_reserved NUMBER;
1257:
1258: -- bug 2480915 start(8)
1259: l_fa_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1260: l_fa_deprn_period igi_iac_fa_deprn.deprn_period%TYPE;
1261: l_fa_deprn_reserve igi_iac_fa_deprn.deprn_reserve%TYPE;
1262: -- bug 2480915 end(8)
1263: l_ret boolean;
1264: -- exceptions

Line 1261: l_fa_deprn_reserve igi_iac_fa_deprn.deprn_reserve%TYPE;

1257:
1258: -- bug 2480915 start(8)
1259: l_fa_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1260: l_fa_deprn_period igi_iac_fa_deprn.deprn_period%TYPE;
1261: l_fa_deprn_reserve igi_iac_fa_deprn.deprn_reserve%TYPE;
1262: -- bug 2480915 end(8)
1263: l_ret boolean;
1264: -- exceptions
1265: e_no_ccid_found EXCEPTION;

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

1387: -- bug 2480915 start(12) Modified for Bug 2906034
1388: OPEN c_get_fa_deprn(l_prev_adj_id, l_det_bal.distribution_id);
1389: FETCH c_get_fa_deprn INTO l_fa_deprn_period, l_fa_deprn_ytd, l_fa_deprn_reserve;
1390: IF c_get_fa_deprn%NOTFOUND THEN
1391: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Record not found in igi_iac_fa_deprn');
1392: OPEN c_get_fa_det(g_book_type_code,
1393: g_asset_id,
1394: l_det_bal.distribution_id,
1395: l_det_bal.period_counter);

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

1404: l_fa_deprn_ytd := 0;
1405: END IF;
1406: CLOSE c_get_fa_ytd;
1407: ELSE
1408: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Record found in igi_iac_fa_deprn');
1409: IF l_fully_reserved > 0 THEN
1410: l_fa_deprn_period := 0;
1411: END IF;
1412: IF (p_transaction_run = 'SECOND') THEN

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

1474: );
1475:
1476: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Inserted into det balances dist id '||l_det_bal.distribution_id);
1477: -- Bug 2480915, start(13)
1478: -- insert into igi_iac_fa_deprn with the reinstatement adjustment_id
1479: IGI_IAC_FA_DEPRN_PKG.Insert_Row(
1480: x_rowid => l_rowid,
1481: x_book_type_code => g_book_type_code,
1482: x_asset_id => g_asset_id,

Line 1479: IGI_IAC_FA_DEPRN_PKG.Insert_Row(

1475:
1476: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Inserted into det balances dist id '||l_det_bal.distribution_id);
1477: -- Bug 2480915, start(13)
1478: -- insert into igi_iac_fa_deprn with the reinstatement adjustment_id
1479: IGI_IAC_FA_DEPRN_PKG.Insert_Row(
1480: x_rowid => l_rowid,
1481: x_book_type_code => g_book_type_code,
1482: x_asset_id => g_asset_id,
1483: x_period_counter => p_period_counter,

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

1709: -- Bug 2480915, start(14)
1710: OPEN c_get_fa_deprn(l_get_ytd.adjustment_id, l_get_ytd.distribution_id);
1711: FETCH c_get_fa_deprn INTO l_fa_deprn_period, l_fa_deprn_ytd, l_fa_deprn_reserve;
1712: IF c_get_fa_deprn%NOTFOUND THEN
1713: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Record not found in igi_iac_fa_deprn');
1714: OPEN c_get_fa_ytd(g_book_type_code,
1715: g_asset_id,
1716: l_get_ytd.distribution_id);
1717: FETCH c_get_fa_ytd INTO l_fa_deprn_ytd;

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

1722: END IF;
1723: CLOSE c_get_fa_deprn;
1724: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'In YTD: YTD deprn: '||l_fa_deprn_ytd);
1725:
1726: -- insert into igi_iac_fa_deprn with the reinstatement adjustment_id
1727: IGI_IAC_FA_DEPRN_PKG.Insert_Row(
1728: x_rowid => l_rowid,
1729: x_book_type_code => g_book_type_code,
1730: x_asset_id => g_asset_id,

Line 1727: IGI_IAC_FA_DEPRN_PKG.Insert_Row(

1723: CLOSE c_get_fa_deprn;
1724: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'In YTD: YTD deprn: '||l_fa_deprn_ytd);
1725:
1726: -- insert into igi_iac_fa_deprn with the reinstatement adjustment_id
1727: IGI_IAC_FA_DEPRN_PKG.Insert_Row(
1728: x_rowid => l_rowid,
1729: x_book_type_code => g_book_type_code,
1730: x_asset_id => g_asset_id,
1731: x_period_counter => p_period_counter,

Line 2044: l_fa_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;

2040: l_fully_reserved NUMBER;
2041: l_exists NUMBER;
2042:
2043: -- bug 2480915 start(15)
2044: l_fa_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
2045: l_fa_deprn_period igi_iac_fa_deprn.deprn_period%TYPE;
2046: l_fa_deprn_reserve igi_iac_fa_deprn.deprn_reserve%TYPE;
2047: -- bug 2480915 end(15)
2048: l_active_flag igi_iac_det_balances.active_flag%TYPE;

Line 2045: l_fa_deprn_period igi_iac_fa_deprn.deprn_period%TYPE;

2041: l_exists NUMBER;
2042:
2043: -- bug 2480915 start(15)
2044: l_fa_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
2045: l_fa_deprn_period igi_iac_fa_deprn.deprn_period%TYPE;
2046: l_fa_deprn_reserve igi_iac_fa_deprn.deprn_reserve%TYPE;
2047: -- bug 2480915 end(15)
2048: l_active_flag igi_iac_det_balances.active_flag%TYPE;
2049:

Line 2046: l_fa_deprn_reserve igi_iac_fa_deprn.deprn_reserve%TYPE;

2042:
2043: -- bug 2480915 start(15)
2044: l_fa_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
2045: l_fa_deprn_period igi_iac_fa_deprn.deprn_period%TYPE;
2046: l_fa_deprn_reserve igi_iac_fa_deprn.deprn_reserve%TYPE;
2047: -- bug 2480915 end(15)
2048: l_active_flag igi_iac_det_balances.active_flag%TYPE;
2049:
2050: -- exceptions

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

2168: -- bug 2480915 start(19) Modified for bug 2906034
2169: OPEN c_get_fa_deprn(l_prev_adj_id, l_det_bal.distribution_id);
2170: FETCH c_get_fa_deprn INTO l_fa_deprn_period, l_fa_deprn_ytd, l_fa_deprn_reserve;
2171: IF c_get_fa_deprn%NOTFOUND THEN
2172: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Record not found in igi_iac_fa_deprn');
2173: OPEN c_get_fa_det(g_book_type_code,
2174: g_asset_id,
2175: l_det_bal.distribution_id,
2176: l_det_bal.period_counter);

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

2185: l_fa_deprn_ytd := 0;
2186: END IF;
2187: CLOSE c_get_fa_ytd;
2188: ELSE
2189: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Record found in igi_iac_fa_deprn');
2190: IF l_fully_reserved > 0 THEN
2191: l_fa_deprn_period := 0;
2192: END IF;
2193: IF (p_transaction_run = 'SECOND') THEN

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

2253: x_mode => 'R'
2254: );
2255:
2256: -- Bug 2480915, start(20)
2257: -- insert into igi_iac_fa_deprn with the reinstatement adjustment_id
2258: IGI_IAC_FA_DEPRN_PKG.Insert_Row(
2259: x_rowid => l_rowid,
2260: x_book_type_code => g_book_type_code,
2261: x_asset_id => g_asset_id,

Line 2258: IGI_IAC_FA_DEPRN_PKG.Insert_Row(

2254: );
2255:
2256: -- Bug 2480915, start(20)
2257: -- insert into igi_iac_fa_deprn with the reinstatement adjustment_id
2258: IGI_IAC_FA_DEPRN_PKG.Insert_Row(
2259: x_rowid => l_rowid,
2260: x_book_type_code => g_book_type_code,
2261: x_asset_id => g_asset_id,
2262: x_period_counter => p_period_counter,

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

2493: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Inserted YTD for partially retired distribution: '||l_ret_dist_id);
2494: -- bug 2485778, end 2
2495:
2496: -- Bug 2480915, start(21) Modified for 2906034
2497: -- insert into igi_iac_fa_deprn with the reinstatement adjustment_id
2498: OPEN c_get_fa_deprn(l_ret_ytd.adjustment_id, l_ret_ytd.distribution_id);
2499: FETCH c_get_fa_deprn INTO l_fa_deprn_period, l_fa_deprn_ytd, l_fa_deprn_reserve;
2500: IF c_get_fa_deprn%NOTFOUND THEN
2501: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Record not found in igi_iac_fa_deprn');

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

2497: -- insert into igi_iac_fa_deprn with the reinstatement adjustment_id
2498: OPEN c_get_fa_deprn(l_ret_ytd.adjustment_id, l_ret_ytd.distribution_id);
2499: FETCH c_get_fa_deprn INTO l_fa_deprn_period, l_fa_deprn_ytd, l_fa_deprn_reserve;
2500: IF c_get_fa_deprn%NOTFOUND THEN
2501: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Record not found in igi_iac_fa_deprn');
2502: OPEN c_get_fa_ytd(g_book_type_code,
2503: g_asset_id,
2504: l_ret_ytd.distribution_id);
2505: FETCH c_get_fa_ytd INTO l_fa_deprn_ytd;

Line 2514: IGI_IAC_FA_DEPRN_PKG.Insert_Row(

2510: END IF;
2511: CLOSE c_get_fa_deprn;
2512:
2513: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'In YTD: YTD deprn: '||l_fa_deprn_ytd);
2514: IGI_IAC_FA_DEPRN_PKG.Insert_Row(
2515: x_rowid => l_rowid,
2516: x_book_type_code => g_book_type_code,
2517: x_asset_id => g_asset_id,
2518: x_period_counter => p_period_counter,

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

2748: -- Bug 2480915, start(22)
2749: OPEN c_get_fa_deprn(l_get_ytd.adjustment_id, l_get_ytd.distribution_id);
2750: FETCH c_get_fa_deprn INTO l_fa_deprn_period, l_fa_deprn_ytd, l_fa_deprn_reserve;
2751: IF c_get_fa_deprn%NOTFOUND THEN
2752: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Record not found in igi_iac_fa_deprn');
2753: OPEN c_get_fa_ytd(g_book_type_code,
2754: g_asset_id,
2755: l_get_ytd.distribution_id);
2756: FETCH c_get_fa_ytd INTO l_fa_deprn_ytd;

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

2764: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'In YTD: YTD deprn: '||l_fa_deprn_ytd);
2765: IF nvl(l_get_ytd.active_flag,'Y') = 'Y' THEN
2766: l_fa_deprn_ytd := 0;
2767: END IF;
2768: -- insert into igi_iac_fa_deprn with the reinstatement adjustment_id
2769: IGI_IAC_FA_DEPRN_PKG.Insert_Row(
2770: x_rowid => l_rowid,
2771: x_book_type_code => g_book_type_code,
2772: x_asset_id => g_asset_id,

Line 2769: IGI_IAC_FA_DEPRN_PKG.Insert_Row(

2765: IF nvl(l_get_ytd.active_flag,'Y') = 'Y' THEN
2766: l_fa_deprn_ytd := 0;
2767: END IF;
2768: -- insert into igi_iac_fa_deprn with the reinstatement adjustment_id
2769: IGI_IAC_FA_DEPRN_PKG.Insert_Row(
2770: x_rowid => l_rowid,
2771: x_book_type_code => g_book_type_code,
2772: x_asset_id => g_asset_id,
2773: x_period_counter => p_period_counter,

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

3465: FROM fa_additions_b
3466: WHERE asset_id = p_asset_id;
3467: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'There is an IAC effect on the asset: '||l_asset_num);
3468:
3469: -- bug 2480915 start, call ytd preprocessor to populate igi_iac_fa_deprn
3470: -- if no entries exist for the book in the table
3471: IF NOT igi_iac_common_utils.populate_iac_fa_deprn_data(p_book_type_code,
3472: 'REINSTATEMENT')
3473: THEN

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

3470: -- if no entries exist for the book in the table
3471: IF NOT igi_iac_common_utils.populate_iac_fa_deprn_data(p_book_type_code,
3472: 'REINSTATEMENT')
3473: THEN
3474: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Problems creating rows in igi_iac_fa_deprn');
3475: RAISE e_iac_fa_deprn;
3476: END IF;
3477: -- bug 2480915, end
3478:

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

3668: IF c_fa_trx_headers%ISOPEN THEN
3669: CLOSE c_fa_trx_headers;
3670: END IF;
3671:
3672: g_message := 'Could not create the ytd rows in igi_iac_fa_deprn';
3673: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,g_message);
3674: FA_SRVR_MSG.add_message(
3675: Calling_Fn => g_calling_fn,
3676: Name => 'IGI_IAC_FA_DEPR_CREATE_PROB',