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_DEBUG_PKG

Line 62: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'--- Inside Round() ---');

58: l_amount number := p_amount;
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');

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 67: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_amount = '||p_amount);

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');
71: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_amount = '||p_amount);

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 71: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_amount = '||p_amount);

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;
75: igi_iac_debug_pkg.debug_unexpected_msg(l_path);

Line 75: igi_iac_debug_pkg.debug_unexpected_msg(l_path);

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;
75: igi_iac_debug_pkg.debug_unexpected_msg(l_path);
76: Raise;
77: END;
78:
79: -- ===============================================================================

Line 133: igi_iac_debug_pkg.debug_unexpected_msg(l_path);

129:
130: EXCEPTION
131: WHEN OTHERS THEN
132: l_mesg:=SQLERRM;
133: igi_iac_debug_pkg.debug_unexpected_msg(l_path);
134: FA_SRVR_MSG.Add_Message(
135: Calling_FN => 'IGI_IAC_TRANSFER_PKG.Do_Transfer',
136: Name => 'IGI_IAC_EXCEPTION',
137: TOKEN1 => 'PACKAGE',

Line 221: igi_iac_debug_pkg.debug_unexpected_msg(l_path);

217: TOKEN1 => 'PACKAGE',
218: VALUE1 => 'Transfers',
219: TOKEN2 => 'ERROR_MESSAGE',
220: VALUE2 => l_mesg);
221: igi_iac_debug_pkg.debug_unexpected_msg(l_path);
222: rollback;
223: END insert_data_det;
224:
225: -- ===============================================================================+

Line 262: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'prorate_factor: ' || prorate_factor);

258: where DISTRIBUTION_ID=p_dist_id;
259:
260: -- Prorate the various amounts between for the given distribution
261: prorate_factor := p_units_dist/p_units_total;
262: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'prorate_factor: ' || prorate_factor);
263: p_reval_reserve := p_ab_amounts.reval_reserve* Prorate_factor ;
264: do_round(p_reval_reserve,l_book_type_code);
265: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_reval_reserve: ' || p_reval_reserve);
266: P_general_fund := P_ab_amounts.general_fund * Prorate_factor ;

Line 265: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_reval_reserve: ' || p_reval_reserve);

261: prorate_factor := p_units_dist/p_units_total;
262: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'prorate_factor: ' || prorate_factor);
263: p_reval_reserve := p_ab_amounts.reval_reserve* Prorate_factor ;
264: do_round(p_reval_reserve,l_book_type_code);
265: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_reval_reserve: ' || p_reval_reserve);
266: P_general_fund := P_ab_amounts.general_fund * Prorate_factor ;
267: do_round(P_general_fund,l_book_type_code);
268: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'P_general_fund: ' || P_general_fund);
269: P_backlog_deprn := p_ab_amounts.backlog_deprn_reserve* Prorate_factor ;

Line 268: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'P_general_fund: ' || P_general_fund);

264: do_round(p_reval_reserve,l_book_type_code);
265: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_reval_reserve: ' || p_reval_reserve);
266: P_general_fund := P_ab_amounts.general_fund * Prorate_factor ;
267: do_round(P_general_fund,l_book_type_code);
268: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'P_general_fund: ' || P_general_fund);
269: P_backlog_deprn := p_ab_amounts.backlog_deprn_reserve* Prorate_factor ;
270: do_round(P_backlog_deprn,l_book_type_code);
271: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'P_backlog_deprn: ' || P_backlog_deprn);
272: P_deprn_reserve := p_ab_amounts.deprn_reserve* Prorate_factor ;

Line 271: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'P_backlog_deprn: ' || P_backlog_deprn);

267: do_round(P_general_fund,l_book_type_code);
268: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'P_general_fund: ' || P_general_fund);
269: P_backlog_deprn := p_ab_amounts.backlog_deprn_reserve* Prorate_factor ;
270: do_round(P_backlog_deprn,l_book_type_code);
271: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'P_backlog_deprn: ' || P_backlog_deprn);
272: P_deprn_reserve := p_ab_amounts.deprn_reserve* Prorate_factor ;
273: do_round(P_deprn_reserve,l_book_type_code);
274: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'P_deprn_reserve: ' || P_deprn_reserve);
275: P_adjusted_cost := p_ab_amounts.adjusted_cost* Prorate_factor ;

Line 274: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'P_deprn_reserve: ' || P_deprn_reserve);

270: do_round(P_backlog_deprn,l_book_type_code);
271: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'P_backlog_deprn: ' || P_backlog_deprn);
272: P_deprn_reserve := p_ab_amounts.deprn_reserve* Prorate_factor ;
273: do_round(P_deprn_reserve,l_book_type_code);
274: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'P_deprn_reserve: ' || P_deprn_reserve);
275: P_adjusted_cost := p_ab_amounts.adjusted_cost* Prorate_factor ;
276: do_round(P_adjusted_cost,l_book_type_code);
277: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'P_adjusted_cost: ' || P_adjusted_cost);
278: P_net_book_value := p_ab_amounts.net_book_value* Prorate_factor ;

Line 277: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'P_adjusted_cost: ' || P_adjusted_cost);

273: do_round(P_deprn_reserve,l_book_type_code);
274: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'P_deprn_reserve: ' || P_deprn_reserve);
275: P_adjusted_cost := p_ab_amounts.adjusted_cost* Prorate_factor ;
276: do_round(P_adjusted_cost,l_book_type_code);
277: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'P_adjusted_cost: ' || P_adjusted_cost);
278: P_net_book_value := p_ab_amounts.net_book_value* Prorate_factor ;
279: do_round(P_net_book_value,l_book_type_code);
280: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'P_net_book_value: ' || P_net_book_value);
281: P_deprn_per := p_ab_amounts.deprn_amount* Prorate_factor;

Line 280: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'P_net_book_value: ' || P_net_book_value);

276: do_round(P_adjusted_cost,l_book_type_code);
277: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'P_adjusted_cost: ' || P_adjusted_cost);
278: P_net_book_value := p_ab_amounts.net_book_value* Prorate_factor ;
279: do_round(P_net_book_value,l_book_type_code);
280: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'P_net_book_value: ' || P_net_book_value);
281: P_deprn_per := p_ab_amounts.deprn_amount* Prorate_factor;
282: do_round(P_deprn_per,l_book_type_code);
283: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'P_deprn_per: ' || P_deprn_per);
284: P_op_acct := p_ab_amounts.operating_acct*Prorate_factor;

Line 283: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'P_deprn_per: ' || P_deprn_per);

279: do_round(P_net_book_value,l_book_type_code);
280: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'P_net_book_value: ' || P_net_book_value);
281: P_deprn_per := p_ab_amounts.deprn_amount* Prorate_factor;
282: do_round(P_deprn_per,l_book_type_code);
283: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'P_deprn_per: ' || P_deprn_per);
284: P_op_acct := p_ab_amounts.operating_acct*Prorate_factor;
285: do_round(P_op_acct,l_book_type_code);
286: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'P_op_acct: ' || P_op_acct);
287: P_ytd_deprn := p_ab_amounts.ytd_deprn*Prorate_factor;

Line 286: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'P_op_acct: ' || P_op_acct);

282: do_round(P_deprn_per,l_book_type_code);
283: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'P_deprn_per: ' || P_deprn_per);
284: P_op_acct := p_ab_amounts.operating_acct*Prorate_factor;
285: do_round(P_op_acct,l_book_type_code);
286: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'P_op_acct: ' || P_op_acct);
287: P_ytd_deprn := p_ab_amounts.ytd_deprn*Prorate_factor;
288: do_round(P_ytd_deprn,l_book_type_code);
289: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'P_ytd_deprn: ' || P_ytd_deprn);
290: P_op_acct_ytd := 0; --p_ab_op_acct_ytd*Prorate_factor;

Line 289: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'P_ytd_deprn: ' || P_ytd_deprn);

285: do_round(P_op_acct,l_book_type_code);
286: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'P_op_acct: ' || P_op_acct);
287: P_ytd_deprn := p_ab_amounts.ytd_deprn*Prorate_factor;
288: do_round(P_ytd_deprn,l_book_type_code);
289: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'P_ytd_deprn: ' || P_ytd_deprn);
290: P_op_acct_ytd := 0; --p_ab_op_acct_ytd*Prorate_factor;
291: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'P_op_acct_ytd: ' || P_op_acct_ytd);
292:
293: p_rr_blog := p_ab_amounts.reval_reserve_backlog*Prorate_factor;

Line 291: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'P_op_acct_ytd: ' || P_op_acct_ytd);

287: P_ytd_deprn := p_ab_amounts.ytd_deprn*Prorate_factor;
288: do_round(P_ytd_deprn,l_book_type_code);
289: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'P_ytd_deprn: ' || P_ytd_deprn);
290: P_op_acct_ytd := 0; --p_ab_op_acct_ytd*Prorate_factor;
291: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'P_op_acct_ytd: ' || P_op_acct_ytd);
292:
293: p_rr_blog := p_ab_amounts.reval_reserve_backlog*Prorate_factor;
294: do_round(p_rr_blog,l_book_type_code);
295: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_rr_blog: ' || p_rr_blog);

Line 295: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_rr_blog: ' || p_rr_blog);

291: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'P_op_acct_ytd: ' || P_op_acct_ytd);
292:
293: p_rr_blog := p_ab_amounts.reval_reserve_backlog*Prorate_factor;
294: do_round(p_rr_blog,l_book_type_code);
295: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_rr_blog: ' || p_rr_blog);
296: p_op_blog := p_ab_amounts.operating_acct_backlog*Prorate_factor;
297: do_round(p_op_blog,l_book_type_code);
298: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_op_blog: ' || p_op_blog);
299: p_gf_per := p_ab_amounts.general_fund_per*Prorate_factor;

Line 298: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_op_blog: ' || p_op_blog);

294: do_round(p_rr_blog,l_book_type_code);
295: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_rr_blog: ' || p_rr_blog);
296: p_op_blog := p_ab_amounts.operating_acct_backlog*Prorate_factor;
297: do_round(p_op_blog,l_book_type_code);
298: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_op_blog: ' || p_op_blog);
299: p_gf_per := p_ab_amounts.general_fund_per*Prorate_factor;
300: do_round(p_gf_per,l_book_type_code);
301: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_gf_per: ' || p_gf_per);
302:

Line 301: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_gf_per: ' || p_gf_per);

297: do_round(p_op_blog,l_book_type_code);
298: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_op_blog: ' || p_op_blog);
299: p_gf_per := p_ab_amounts.general_fund_per*Prorate_factor;
300: do_round(p_gf_per,l_book_type_code);
301: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_gf_per: ' || p_gf_per);
302:
303: EXCEPTION
304: WHEN OTHERS THEN
305: l_mesg:=SQLERRM;

Line 321: igi_iac_debug_pkg.debug_unexpected_msg(l_path);

317: p_rr_blog := 0;
318: p_op_blog := 0;
319: p_gf_per := 0;
320:
321: igi_iac_debug_pkg.debug_unexpected_msg(l_path);
322: FA_SRVR_MSG.Add_Message(
323: Calling_FN => 'IGI_IAC_TRANSFER_PKG.Do_Transfer',
324: Name => 'IGI_IAC_EXCEPTION',
325: TOKEN1 => 'PACKAGE',

Line 366: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_Prorate_factor: ' || l_Prorate_factor);

362:
363: -- Prorate the various amounts between for the given distribution
364:
365: l_Prorate_factor := p_units_dist/p_units_total;
366: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_Prorate_factor: ' || l_Prorate_factor);
367: P_deprn_period := P_ab_amounts.deprn_period * l_Prorate_factor ;
368: do_round(P_deprn_period,l_book_type_code);
369: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'P_deprn_period: ' || P_deprn_period);
370: P_deprn_ytd := P_ab_amounts.deprn_ytd * l_Prorate_factor ;

Line 369: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'P_deprn_period: ' || P_deprn_period);

365: l_Prorate_factor := p_units_dist/p_units_total;
366: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_Prorate_factor: ' || l_Prorate_factor);
367: P_deprn_period := P_ab_amounts.deprn_period * l_Prorate_factor ;
368: do_round(P_deprn_period,l_book_type_code);
369: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'P_deprn_period: ' || P_deprn_period);
370: P_deprn_ytd := P_ab_amounts.deprn_ytd * l_Prorate_factor ;
371: do_round(P_deprn_ytd,l_book_type_code);
372: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'P_deprn_ytd: ' || P_deprn_ytd);
373: P_deprn_reserve := P_ab_amounts.deprn_reserve * l_Prorate_factor ;

Line 372: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'P_deprn_ytd: ' || P_deprn_ytd);

368: do_round(P_deprn_period,l_book_type_code);
369: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'P_deprn_period: ' || P_deprn_period);
370: P_deprn_ytd := P_ab_amounts.deprn_ytd * l_Prorate_factor ;
371: do_round(P_deprn_ytd,l_book_type_code);
372: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'P_deprn_ytd: ' || P_deprn_ytd);
373: P_deprn_reserve := P_ab_amounts.deprn_reserve * l_Prorate_factor ;
374: do_round(P_deprn_reserve,l_book_type_code);
375: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'P_deprn_reserve: ' || P_deprn_reserve);
376:

Line 375: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'P_deprn_reserve: ' || P_deprn_reserve);

371: do_round(P_deprn_ytd,l_book_type_code);
372: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'P_deprn_ytd: ' || P_deprn_ytd);
373: P_deprn_reserve := P_ab_amounts.deprn_reserve * l_Prorate_factor ;
374: do_round(P_deprn_reserve,l_book_type_code);
375: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'P_deprn_reserve: ' || P_deprn_reserve);
376:
377: EXCEPTION
378: WHEN OTHERS THEN
379: l_mesg:=SQLERRM;

Line 386: igi_iac_debug_pkg.debug_unexpected_msg(l_path);

382: P_deprn_period := P_deprn_period_old;
383: P_deprn_ytd := P_deprn_ytd_old;
384: P_deprn_reserve := P_deprn_reserve_old;
385:
386: igi_iac_debug_pkg.debug_unexpected_msg(l_path);
387:
388: FA_SRVR_MSG.Add_Message(
389: Calling_FN => 'IGI_IAC_TRANSFER_PKG.Do_Transfer',
390: Name => 'IGI_IAC_EXCEPTION',

Line 427: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'prorate_factor :'||prorate_factor);

423: where DISTRIBUTION_ID=p_dist_id;
424:
425: -- Prorate the various amounts between for the given distribution
426: prorate_factor := p_units_dist/p_transfer_units;
427: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'prorate_factor :'||prorate_factor);
428:
429: p_dist_dep_exp := 0;
430: p_dist_op_exp := 0;
431: p_fa_dist_dep_exp := 0;

Line 436: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_dist_dep_exp :'||p_dist_dep_exp);

432:
433: IF g_prior_period THEN
434: p_dist_dep_exp := p_ab_dep_exp*Prorate_factor;
435: do_round(p_dist_dep_exp,l_book_type_code);
436: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_dist_dep_exp :'||p_dist_dep_exp);
437: p_dist_op_exp := p_ab_op_exp*Prorate_factor;
438: do_round(p_dist_op_exp,l_book_type_code);
439: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_dist_op_exp :'||p_dist_op_exp);
440: p_fa_dist_dep_exp := p_fa_ab_dep_exp*Prorate_factor;

Line 439: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_dist_op_exp :'||p_dist_op_exp);

435: do_round(p_dist_dep_exp,l_book_type_code);
436: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_dist_dep_exp :'||p_dist_dep_exp);
437: p_dist_op_exp := p_ab_op_exp*Prorate_factor;
438: do_round(p_dist_op_exp,l_book_type_code);
439: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_dist_op_exp :'||p_dist_op_exp);
440: p_fa_dist_dep_exp := p_fa_ab_dep_exp*Prorate_factor;
441: do_round(p_fa_dist_dep_exp,l_book_type_code);
442: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_fa_dist_dep_exp :'||p_fa_dist_dep_exp);
443: END IF;

Line 442: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_fa_dist_dep_exp :'||p_fa_dist_dep_exp);

438: do_round(p_dist_op_exp,l_book_type_code);
439: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_dist_op_exp :'||p_dist_op_exp);
440: p_fa_dist_dep_exp := p_fa_ab_dep_exp*Prorate_factor;
441: do_round(p_fa_dist_dep_exp,l_book_type_code);
442: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_fa_dist_dep_exp :'||p_fa_dist_dep_exp);
443: END IF;
444:
445: EXCEPTION
446: WHEN OTHERS THEN

Line 448: igi_iac_debug_pkg.debug_unexpected_msg(l_path);

444:
445: EXCEPTION
446: WHEN OTHERS THEN
447: l_mesg:=SQLERRM;
448: igi_iac_debug_pkg.debug_unexpected_msg(l_path);
449: FA_SRVR_MSG.Add_Message(
450: Calling_FN => 'IGI_IAC_TRANSFER_PKG.Do_Transfer',
451: Name => 'IGI_IAC_EXCEPTION',
452: TOKEN1 => 'PACKAGE',

Line 557: igi_iac_debug_pkg.debug_unexpected_msg(l_path);

553: p_deprn_ccid := NULL;
554: p_cost_ccid := NULL;
555: p_op_expense_ccid := NULL;
556:
557: igi_iac_debug_pkg.debug_unexpected_msg(l_path);
558: FA_SRVR_MSG.Add_Message(
559: Calling_FN => 'IGI_IAC_TRANSFER_PKG.Do_Transfer',
560: Name => 'IGI_IAC_EXCEPTION',
561: TOKEN1 => 'PACKAGE',

Line 694: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_ab_amounts.period_counter: ' || l_ab_amounts.period_counter);

690: IF c_amounts%NOTFOUND THEN
691: RAISE NO_DATA_FOUND;
692: END IF;
693: CLOSE c_amounts;
694: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_ab_amounts.period_counter: ' || l_ab_amounts.period_counter);
695: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_ab_amounts.net_book_value: ' || l_ab_amounts.net_book_value);
696: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_ab_amounts.adjusted_cost: ' || l_ab_amounts.adjusted_cost);
697: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_ab_amounts.operating_acct: ' || l_ab_amounts.operating_acct);
698: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_ab_amounts.reval_reserve: ' || l_ab_amounts.reval_reserve);

Line 695: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_ab_amounts.net_book_value: ' || l_ab_amounts.net_book_value);

691: RAISE NO_DATA_FOUND;
692: END IF;
693: CLOSE c_amounts;
694: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_ab_amounts.period_counter: ' || l_ab_amounts.period_counter);
695: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_ab_amounts.net_book_value: ' || l_ab_amounts.net_book_value);
696: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_ab_amounts.adjusted_cost: ' || l_ab_amounts.adjusted_cost);
697: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_ab_amounts.operating_acct: ' || l_ab_amounts.operating_acct);
698: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_ab_amounts.reval_reserve: ' || l_ab_amounts.reval_reserve);
699: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_ab_amounts.deprn_amount: ' || l_ab_amounts.deprn_amount);

Line 696: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_ab_amounts.adjusted_cost: ' || l_ab_amounts.adjusted_cost);

692: END IF;
693: CLOSE c_amounts;
694: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_ab_amounts.period_counter: ' || l_ab_amounts.period_counter);
695: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_ab_amounts.net_book_value: ' || l_ab_amounts.net_book_value);
696: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_ab_amounts.adjusted_cost: ' || l_ab_amounts.adjusted_cost);
697: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_ab_amounts.operating_acct: ' || l_ab_amounts.operating_acct);
698: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_ab_amounts.reval_reserve: ' || l_ab_amounts.reval_reserve);
699: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_ab_amounts.deprn_amount: ' || l_ab_amounts.deprn_amount);
700: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_ab_amounts.deprn_reserve: ' || l_ab_amounts.deprn_reserve);

Line 697: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_ab_amounts.operating_acct: ' || l_ab_amounts.operating_acct);

693: CLOSE c_amounts;
694: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_ab_amounts.period_counter: ' || l_ab_amounts.period_counter);
695: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_ab_amounts.net_book_value: ' || l_ab_amounts.net_book_value);
696: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_ab_amounts.adjusted_cost: ' || l_ab_amounts.adjusted_cost);
697: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_ab_amounts.operating_acct: ' || l_ab_amounts.operating_acct);
698: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_ab_amounts.reval_reserve: ' || l_ab_amounts.reval_reserve);
699: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_ab_amounts.deprn_amount: ' || l_ab_amounts.deprn_amount);
700: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_ab_amounts.deprn_reserve: ' || l_ab_amounts.deprn_reserve);
701: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_ab_amounts.backlog_deprn_reserve: ' || l_ab_amounts.backlog_deprn_reserve);

Line 698: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_ab_amounts.reval_reserve: ' || l_ab_amounts.reval_reserve);

694: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_ab_amounts.period_counter: ' || l_ab_amounts.period_counter);
695: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_ab_amounts.net_book_value: ' || l_ab_amounts.net_book_value);
696: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_ab_amounts.adjusted_cost: ' || l_ab_amounts.adjusted_cost);
697: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_ab_amounts.operating_acct: ' || l_ab_amounts.operating_acct);
698: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_ab_amounts.reval_reserve: ' || l_ab_amounts.reval_reserve);
699: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_ab_amounts.deprn_amount: ' || l_ab_amounts.deprn_amount);
700: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_ab_amounts.deprn_reserve: ' || l_ab_amounts.deprn_reserve);
701: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_ab_amounts.backlog_deprn_reserve: ' || l_ab_amounts.backlog_deprn_reserve);
702: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_ab_amounts.general_fund: ' || l_ab_amounts.general_fund);

Line 699: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_ab_amounts.deprn_amount: ' || l_ab_amounts.deprn_amount);

695: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_ab_amounts.net_book_value: ' || l_ab_amounts.net_book_value);
696: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_ab_amounts.adjusted_cost: ' || l_ab_amounts.adjusted_cost);
697: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_ab_amounts.operating_acct: ' || l_ab_amounts.operating_acct);
698: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_ab_amounts.reval_reserve: ' || l_ab_amounts.reval_reserve);
699: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_ab_amounts.deprn_amount: ' || l_ab_amounts.deprn_amount);
700: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_ab_amounts.deprn_reserve: ' || l_ab_amounts.deprn_reserve);
701: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_ab_amounts.backlog_deprn_reserve: ' || l_ab_amounts.backlog_deprn_reserve);
702: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_ab_amounts.general_fund: ' || l_ab_amounts.general_fund);
703: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_ab_amounts.last_reval_date: ' || l_ab_amounts.last_reval_date);

Line 700: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_ab_amounts.deprn_reserve: ' || l_ab_amounts.deprn_reserve);

696: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_ab_amounts.adjusted_cost: ' || l_ab_amounts.adjusted_cost);
697: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_ab_amounts.operating_acct: ' || l_ab_amounts.operating_acct);
698: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_ab_amounts.reval_reserve: ' || l_ab_amounts.reval_reserve);
699: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_ab_amounts.deprn_amount: ' || l_ab_amounts.deprn_amount);
700: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_ab_amounts.deprn_reserve: ' || l_ab_amounts.deprn_reserve);
701: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_ab_amounts.backlog_deprn_reserve: ' || l_ab_amounts.backlog_deprn_reserve);
702: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_ab_amounts.general_fund: ' || l_ab_amounts.general_fund);
703: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_ab_amounts.last_reval_date: ' || l_ab_amounts.last_reval_date);
704: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_ab_amounts.current_reval_factor: ' || l_ab_amounts.current_reval_factor);

Line 701: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_ab_amounts.backlog_deprn_reserve: ' || l_ab_amounts.backlog_deprn_reserve);

697: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_ab_amounts.operating_acct: ' || l_ab_amounts.operating_acct);
698: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_ab_amounts.reval_reserve: ' || l_ab_amounts.reval_reserve);
699: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_ab_amounts.deprn_amount: ' || l_ab_amounts.deprn_amount);
700: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_ab_amounts.deprn_reserve: ' || l_ab_amounts.deprn_reserve);
701: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_ab_amounts.backlog_deprn_reserve: ' || l_ab_amounts.backlog_deprn_reserve);
702: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_ab_amounts.general_fund: ' || l_ab_amounts.general_fund);
703: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_ab_amounts.last_reval_date: ' || l_ab_amounts.last_reval_date);
704: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_ab_amounts.current_reval_factor: ' || l_ab_amounts.current_reval_factor);
705: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_ab_amounts.cumulative_reval_factor: ' || l_ab_amounts.cumulative_reval_factor);

Line 702: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_ab_amounts.general_fund: ' || l_ab_amounts.general_fund);

698: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_ab_amounts.reval_reserve: ' || l_ab_amounts.reval_reserve);
699: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_ab_amounts.deprn_amount: ' || l_ab_amounts.deprn_amount);
700: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_ab_amounts.deprn_reserve: ' || l_ab_amounts.deprn_reserve);
701: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_ab_amounts.backlog_deprn_reserve: ' || l_ab_amounts.backlog_deprn_reserve);
702: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_ab_amounts.general_fund: ' || l_ab_amounts.general_fund);
703: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_ab_amounts.last_reval_date: ' || l_ab_amounts.last_reval_date);
704: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_ab_amounts.current_reval_factor: ' || l_ab_amounts.current_reval_factor);
705: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_ab_amounts.cumulative_reval_factor: ' || l_ab_amounts.cumulative_reval_factor);
706:

Line 703: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_ab_amounts.last_reval_date: ' || l_ab_amounts.last_reval_date);

699: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_ab_amounts.deprn_amount: ' || l_ab_amounts.deprn_amount);
700: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_ab_amounts.deprn_reserve: ' || l_ab_amounts.deprn_reserve);
701: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_ab_amounts.backlog_deprn_reserve: ' || l_ab_amounts.backlog_deprn_reserve);
702: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_ab_amounts.general_fund: ' || l_ab_amounts.general_fund);
703: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_ab_amounts.last_reval_date: ' || l_ab_amounts.last_reval_date);
704: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_ab_amounts.current_reval_factor: ' || l_ab_amounts.current_reval_factor);
705: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_ab_amounts.cumulative_reval_factor: ' || l_ab_amounts.cumulative_reval_factor);
706:
707: -- fetch asset level backlog and general fund periodic amounts

Line 704: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_ab_amounts.current_reval_factor: ' || l_ab_amounts.current_reval_factor);

700: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_ab_amounts.deprn_reserve: ' || l_ab_amounts.deprn_reserve);
701: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_ab_amounts.backlog_deprn_reserve: ' || l_ab_amounts.backlog_deprn_reserve);
702: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_ab_amounts.general_fund: ' || l_ab_amounts.general_fund);
703: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_ab_amounts.last_reval_date: ' || l_ab_amounts.last_reval_date);
704: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_ab_amounts.current_reval_factor: ' || l_ab_amounts.current_reval_factor);
705: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_ab_amounts.cumulative_reval_factor: ' || l_ab_amounts.cumulative_reval_factor);
706:
707: -- fetch asset level backlog and general fund periodic amounts
708: -- for the latest adjustment_id

Line 705: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_ab_amounts.cumulative_reval_factor: ' || l_ab_amounts.cumulative_reval_factor);

701: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_ab_amounts.backlog_deprn_reserve: ' || l_ab_amounts.backlog_deprn_reserve);
702: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_ab_amounts.general_fund: ' || l_ab_amounts.general_fund);
703: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_ab_amounts.last_reval_date: ' || l_ab_amounts.last_reval_date);
704: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_ab_amounts.current_reval_factor: ' || l_ab_amounts.current_reval_factor);
705: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_ab_amounts.cumulative_reval_factor: ' || l_ab_amounts.cumulative_reval_factor);
706:
707: -- fetch asset level backlog and general fund periodic amounts
708: -- for the latest adjustment_id
709: OPEN c_backlog_data(p_adjustment_id);

Line 715: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_ab_backlog_data.reval_reserve_backlog: ' || l_ab_backlog_data.reval_reserve_backlog);

711: IF c_backlog_data%NOTFOUND THEN
712: RAISE NO_DATA_FOUND;
713: END IF;
714: CLOSE c_backlog_data;
715: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_ab_backlog_data.reval_reserve_backlog: ' || l_ab_backlog_data.reval_reserve_backlog);
716: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_ab_backlog_data.operating_acct_backlog: ' || l_ab_backlog_data.operating_acct_backlog);
717: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_ab_backlog_data.general_fund_per: ' || l_ab_backlog_data.general_fund_per);
718: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_ab_backlog_data.ytd_deprn: ' || l_ab_backlog_data.ytd_deprn);
719:

Line 716: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_ab_backlog_data.operating_acct_backlog: ' || l_ab_backlog_data.operating_acct_backlog);

712: RAISE NO_DATA_FOUND;
713: END IF;
714: CLOSE c_backlog_data;
715: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_ab_backlog_data.reval_reserve_backlog: ' || l_ab_backlog_data.reval_reserve_backlog);
716: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_ab_backlog_data.operating_acct_backlog: ' || l_ab_backlog_data.operating_acct_backlog);
717: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_ab_backlog_data.general_fund_per: ' || l_ab_backlog_data.general_fund_per);
718: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_ab_backlog_data.ytd_deprn: ' || l_ab_backlog_data.ytd_deprn);
719:
720: -- set the asset info

Line 717: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_ab_backlog_data.general_fund_per: ' || l_ab_backlog_data.general_fund_per);

713: END IF;
714: CLOSE c_backlog_data;
715: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_ab_backlog_data.reval_reserve_backlog: ' || l_ab_backlog_data.reval_reserve_backlog);
716: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_ab_backlog_data.operating_acct_backlog: ' || l_ab_backlog_data.operating_acct_backlog);
717: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_ab_backlog_data.general_fund_per: ' || l_ab_backlog_data.general_fund_per);
718: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_ab_backlog_data.ytd_deprn: ' || l_ab_backlog_data.ytd_deprn);
719:
720: -- set the asset info
721: l_asset_rec.asset_id := l_ab_amounts.asset_id;

Line 718: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_ab_backlog_data.ytd_deprn: ' || l_ab_backlog_data.ytd_deprn);

714: CLOSE c_backlog_data;
715: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_ab_backlog_data.reval_reserve_backlog: ' || l_ab_backlog_data.reval_reserve_backlog);
716: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_ab_backlog_data.operating_acct_backlog: ' || l_ab_backlog_data.operating_acct_backlog);
717: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_ab_backlog_data.general_fund_per: ' || l_ab_backlog_data.general_fund_per);
718: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_ab_backlog_data.ytd_deprn: ' || l_ab_backlog_data.ytd_deprn);
719:
720: -- set the asset info
721: l_asset_rec.asset_id := l_ab_amounts.asset_id;
722: l_asset_rec.book_type_code := l_ab_amounts.book_type_code;

Line 744: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Processing prior period data ');

740: -- calculate the asset level catchup amounts
741: l_asset_rec.dep_expense_catchup := 0;
742: l_asset_rec.op_expense_catchup := 0;
743: IF g_prior_period THEN
744: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Processing prior period data ');
745: -- l_historic_deprn_expense will be calculated from fa_adjustments
746: -- OPEN c_get_deprn_expense (p_trans_rec.transaction_header_id);
747: OPEN c_get_deprn_expense(p_curr_prd_cntr - 1);
748: FETCH c_get_deprn_expense INTO l_historic_deprn_expense;

Line 754: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_historic_deprn_expense: ' || l_historic_deprn_expense);

750: IF c_get_deprn_expense%NOTFOUND THEN
751: l_historic_deprn_expense:=0;
752: CLOSE c_get_deprn_expense;
753: ELSE
754: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_historic_deprn_expense: ' || l_historic_deprn_expense);
755: -- do salvage value correction for l_historic_deprn_expense
756: IF NOT IGI_IAC_SALVAGE_PKG.Correction(
757: P_asset_id => p_asset_id,
758: P_book_type_code => p_book_type_code,

Line 769: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Historic Expense Amount :'||l_historic_deprn_expense);

765: RAISE e_salvage_val_corr_err;
766: END IF;
767: CLOSE c_get_deprn_expense;
768: END IF;
769: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Historic Expense Amount :'||l_historic_deprn_expense);
770: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Cumulative Reval Factor :'||l_ab_amounts.cumulative_reval_factor);
771:
772: -- calculate the additional IAC expense
773: l_asset_rec.dep_expense_catchup :=l_historic_deprn_expense*(l_ab_amounts.cumulative_reval_factor - 1);

Line 770: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Cumulative Reval Factor :'||l_ab_amounts.cumulative_reval_factor);

766: END IF;
767: CLOSE c_get_deprn_expense;
768: END IF;
769: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Historic Expense Amount :'||l_historic_deprn_expense);
770: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Cumulative Reval Factor :'||l_ab_amounts.cumulative_reval_factor);
771:
772: -- calculate the additional IAC expense
773: l_asset_rec.dep_expense_catchup :=l_historic_deprn_expense*(l_ab_amounts.cumulative_reval_factor - 1);
774: do_round(l_asset_rec.dep_expense_catchup,p_book_type_code);

Line 775: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_asset_rec.dep_expense_catchup :'||l_asset_rec.dep_expense_catchup);

771:
772: -- calculate the additional IAC expense
773: l_asset_rec.dep_expense_catchup :=l_historic_deprn_expense*(l_ab_amounts.cumulative_reval_factor - 1);
774: do_round(l_asset_rec.dep_expense_catchup,p_book_type_code);
775: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_asset_rec.dep_expense_catchup :'||l_asset_rec.dep_expense_catchup);
776: l_asset_rec.dep_expense_catchup := l_asset_rec.dep_expense_catchup*(p_curr_prd_cntr - p_tfr_prd_cntr);
777: do_round(l_asset_rec.dep_expense_catchup,p_book_type_code);
778: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_asset_rec.dep_expense_catchup :'||l_asset_rec.dep_expense_catchup);
779: l_asset_rec.dep_expense_catchup := l_asset_rec.dep_expense_catchup*(p_transfer_units/p_asset_units);

Line 778: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_asset_rec.dep_expense_catchup :'||l_asset_rec.dep_expense_catchup);

774: do_round(l_asset_rec.dep_expense_catchup,p_book_type_code);
775: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_asset_rec.dep_expense_catchup :'||l_asset_rec.dep_expense_catchup);
776: l_asset_rec.dep_expense_catchup := l_asset_rec.dep_expense_catchup*(p_curr_prd_cntr - p_tfr_prd_cntr);
777: do_round(l_asset_rec.dep_expense_catchup,p_book_type_code);
778: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_asset_rec.dep_expense_catchup :'||l_asset_rec.dep_expense_catchup);
779: l_asset_rec.dep_expense_catchup := l_asset_rec.dep_expense_catchup*(p_transfer_units/p_asset_units);
780: do_round(l_asset_rec.dep_expense_catchup,p_book_type_code);
781: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_asset_rec.dep_expense_catchup :'||l_asset_rec.dep_expense_catchup);
782:

Line 781: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_asset_rec.dep_expense_catchup :'||l_asset_rec.dep_expense_catchup);

777: do_round(l_asset_rec.dep_expense_catchup,p_book_type_code);
778: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_asset_rec.dep_expense_catchup :'||l_asset_rec.dep_expense_catchup);
779: l_asset_rec.dep_expense_catchup := l_asset_rec.dep_expense_catchup*(p_transfer_units/p_asset_units);
780: do_round(l_asset_rec.dep_expense_catchup,p_book_type_code);
781: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_asset_rec.dep_expense_catchup :'||l_asset_rec.dep_expense_catchup);
782:
783: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Additional IAC Expense :'||l_expense_diff);
784: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'No of Catch up periods :'||(p_curr_prd_cntr-p_tfr_prd_cntr));
785:

Line 783: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Additional IAC Expense :'||l_expense_diff);

779: l_asset_rec.dep_expense_catchup := l_asset_rec.dep_expense_catchup*(p_transfer_units/p_asset_units);
780: do_round(l_asset_rec.dep_expense_catchup,p_book_type_code);
781: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_asset_rec.dep_expense_catchup :'||l_asset_rec.dep_expense_catchup);
782:
783: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Additional IAC Expense :'||l_expense_diff);
784: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'No of Catch up periods :'||(p_curr_prd_cntr-p_tfr_prd_cntr));
785:
786: -- if asset has been revalued between the transfer period and current period
787: -- the calculate the operating expense amount

Line 784: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'No of Catch up periods :'||(p_curr_prd_cntr-p_tfr_prd_cntr));

780: do_round(l_asset_rec.dep_expense_catchup,p_book_type_code);
781: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_asset_rec.dep_expense_catchup :'||l_asset_rec.dep_expense_catchup);
782:
783: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Additional IAC Expense :'||l_expense_diff);
784: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'No of Catch up periods :'||(p_curr_prd_cntr-p_tfr_prd_cntr));
785:
786: -- if asset has been revalued between the transfer period and current period
787: -- the calculate the operating expense amount
788: OPEN c_op_expense_amt(cp_asset_id => p_asset_id,

Line 801: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_asset_rec.op_expense_catchup :'||l_asset_rec.op_expense_catchup);

797: CLOSE c_op_expense_amt;
798:
799: l_asset_rec.op_expense_catchup := l_asset_rec.op_expense_catchup*(p_transfer_units/p_asset_units);
800: do_round(l_asset_rec.op_expense_catchup,p_book_type_code);
801: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_asset_rec.op_expense_catchup :'||l_asset_rec.op_expense_catchup);
802:
803: END IF;
804: -- end calculation of catchup amounts
805:

Line 813: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_fa_deprn.deprn_period :'||l_iac_fa_deprn.deprn_period);

809: IF c_iac_fa_deprn%NOTFOUND THEN
810: RAISE NO_DATA_FOUND;
811: END IF;
812: CLOSE c_iac_fa_deprn;
813: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_fa_deprn.deprn_period :'||l_iac_fa_deprn.deprn_period);
814: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_fa_deprn.deprn_reserve :'||l_iac_fa_deprn.deprn_reserve);
815: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_fa_deprn.deprn_ytd :'||l_iac_fa_deprn.deprn_ytd);
816:
817: l_iac_fa_dep_rec.asset_id := l_ab_amounts.asset_id;

Line 814: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_fa_deprn.deprn_reserve :'||l_iac_fa_deprn.deprn_reserve);

810: RAISE NO_DATA_FOUND;
811: END IF;
812: CLOSE c_iac_fa_deprn;
813: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_fa_deprn.deprn_period :'||l_iac_fa_deprn.deprn_period);
814: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_fa_deprn.deprn_reserve :'||l_iac_fa_deprn.deprn_reserve);
815: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_fa_deprn.deprn_ytd :'||l_iac_fa_deprn.deprn_ytd);
816:
817: l_iac_fa_dep_rec.asset_id := l_ab_amounts.asset_id;
818: l_iac_fa_dep_rec.book_type_code := l_ab_amounts.book_type_code;

Line 815: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_fa_deprn.deprn_ytd :'||l_iac_fa_deprn.deprn_ytd);

811: END IF;
812: CLOSE c_iac_fa_deprn;
813: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_fa_deprn.deprn_period :'||l_iac_fa_deprn.deprn_period);
814: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_fa_deprn.deprn_reserve :'||l_iac_fa_deprn.deprn_reserve);
815: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_fa_deprn.deprn_ytd :'||l_iac_fa_deprn.deprn_ytd);
816:
817: l_iac_fa_dep_rec.asset_id := l_ab_amounts.asset_id;
818: l_iac_fa_dep_rec.book_type_code := l_ab_amounts.book_type_code;
819: l_iac_fa_dep_rec.period_counter := l_ab_amounts.period_counter;

Line 827: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_fa_dep_rec.dep_expense_catchup :'||l_iac_fa_dep_rec.dep_expense_catchup);

823:
824: -- calculate the historic depreciation catchup amount
825: l_iac_fa_dep_rec.dep_expense_catchup := l_historic_deprn_expense*(p_curr_prd_cntr - p_tfr_prd_cntr);
826: do_round(l_iac_fa_dep_rec.dep_expense_catchup,p_book_type_code);
827: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_fa_dep_rec.dep_expense_catchup :'||l_iac_fa_dep_rec.dep_expense_catchup);
828: l_iac_fa_dep_rec.dep_expense_catchup := l_iac_fa_dep_rec.dep_expense_catchup*(p_transfer_units/p_asset_units);
829: do_round(l_iac_fa_dep_rec.dep_expense_catchup,p_book_type_code);
830: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_fa_dep_rec.dep_expense_catchup :'||l_iac_fa_dep_rec.dep_expense_catchup);
831:

Line 830: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_fa_dep_rec.dep_expense_catchup :'||l_iac_fa_dep_rec.dep_expense_catchup);

826: do_round(l_iac_fa_dep_rec.dep_expense_catchup,p_book_type_code);
827: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_fa_dep_rec.dep_expense_catchup :'||l_iac_fa_dep_rec.dep_expense_catchup);
828: l_iac_fa_dep_rec.dep_expense_catchup := l_iac_fa_dep_rec.dep_expense_catchup*(p_transfer_units/p_asset_units);
829: do_round(l_iac_fa_dep_rec.dep_expense_catchup,p_book_type_code);
830: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_fa_dep_rec.dep_expense_catchup :'||l_iac_fa_dep_rec.dep_expense_catchup);
831:
832: RETURN TRUE;
833: EXCEPTION
834: WHEN e_salvage_val_corr_err THEN

Line 840: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'Salvage Value correction error');

836: Calling_FN => 'IGI_IAC_TRANSFER_PKG.Do_Transfer',
837: Name => 'IGI_IAC_SALVAGE_CORR_ERR',
838: TOKEN1 => 'PROCESS',
839: VALUE1 => 'IGI_IAC_TRANSFER_PKG.Do_Transfer');
840: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'Salvage Value correction error');
841: RETURN FALSE;
842:
843: WHEN OTHERS THEN
844: l_mesg:=SQLERRM;

Line 845: igi_iac_debug_pkg.debug_unexpected_msg(l_path);

841: RETURN FALSE;
842:
843: WHEN OTHERS THEN
844: l_mesg:=SQLERRM;
845: igi_iac_debug_pkg.debug_unexpected_msg(l_path);
846: FA_SRVR_MSG.Add_Message(
847: Calling_FN => 'IGI_IAC_TRANSFER_PKG.Calc_Asset_Amounts',
848: Name => 'IGI_IAC_EXCEPTION',
849: TOKEN1 => 'PACKAGE',

Line 937: igi_iac_debug_pkg.debug_unexpected_msg(sqlerrm);

933: x_mode => 'R');
934: END LOOP;
935: EXCEPTION
936: WHEN OTHERS THEN
937: igi_iac_debug_pkg.debug_unexpected_msg(sqlerrm);
938: FA_SRVR_MSG.Add_Message(
939: Calling_FN => 'IGI_IAC_TRANSFER_PKG.Roll_Inactive_Forward',
940: Name => 'IGI_IAC_EXCEPTION',
941: TOKEN1 => 'PACKAGE',

Line 1261: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'*****************************************************************************');

1257: l_fa_deprn_reserve_sum := 0;
1258: l_path := g_path||'Do_Transfer';
1259: l_exists := false;
1260:
1261: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'*****************************************************************************');
1262: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Processing Transfers on book '||p_asset_hdr_rec.book_type_code);
1263: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Asset Id :'||p_asset_hdr_rec.asset_id);
1264: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Transaction Header Id :'||p_trans_rec.transaction_header_id);
1265: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Mass Reference Id :'||p_trans_rec.mass_reference_id);

Line 1262: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Processing Transfers on book '||p_asset_hdr_rec.book_type_code);

1258: l_path := g_path||'Do_Transfer';
1259: l_exists := false;
1260:
1261: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'*****************************************************************************');
1262: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Processing Transfers on book '||p_asset_hdr_rec.book_type_code);
1263: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Asset Id :'||p_asset_hdr_rec.asset_id);
1264: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Transaction Header Id :'||p_trans_rec.transaction_header_id);
1265: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Mass Reference Id :'||p_trans_rec.mass_reference_id);
1266: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Transaction type code :'||p_trans_rec.transaction_type_code);

Line 1263: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Asset Id :'||p_asset_hdr_rec.asset_id);

1259: l_exists := false;
1260:
1261: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'*****************************************************************************');
1262: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Processing Transfers on book '||p_asset_hdr_rec.book_type_code);
1263: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Asset Id :'||p_asset_hdr_rec.asset_id);
1264: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Transaction Header Id :'||p_trans_rec.transaction_header_id);
1265: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Mass Reference Id :'||p_trans_rec.mass_reference_id);
1266: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Transaction type code :'||p_trans_rec.transaction_type_code);
1267: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Transaction Date :'||p_trans_rec.transaction_date_entered);

Line 1264: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Transaction Header Id :'||p_trans_rec.transaction_header_id);

1260:
1261: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'*****************************************************************************');
1262: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Processing Transfers on book '||p_asset_hdr_rec.book_type_code);
1263: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Asset Id :'||p_asset_hdr_rec.asset_id);
1264: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Transaction Header Id :'||p_trans_rec.transaction_header_id);
1265: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Mass Reference Id :'||p_trans_rec.mass_reference_id);
1266: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Transaction type code :'||p_trans_rec.transaction_type_code);
1267: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Transaction Date :'||p_trans_rec.transaction_date_entered);
1268: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Category Id :'||p_asset_cat_rec.category_id);

Line 1265: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Mass Reference Id :'||p_trans_rec.mass_reference_id);

1261: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'*****************************************************************************');
1262: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Processing Transfers on book '||p_asset_hdr_rec.book_type_code);
1263: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Asset Id :'||p_asset_hdr_rec.asset_id);
1264: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Transaction Header Id :'||p_trans_rec.transaction_header_id);
1265: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Mass Reference Id :'||p_trans_rec.mass_reference_id);
1266: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Transaction type code :'||p_trans_rec.transaction_type_code);
1267: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Transaction Date :'||p_trans_rec.transaction_date_entered);
1268: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Category Id :'||p_asset_cat_rec.category_id);
1269: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Transaction date entered :'||p_trans_rec.transaction_date_entered);

Line 1266: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Transaction type code :'||p_trans_rec.transaction_type_code);

1262: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Processing Transfers on book '||p_asset_hdr_rec.book_type_code);
1263: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Asset Id :'||p_asset_hdr_rec.asset_id);
1264: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Transaction Header Id :'||p_trans_rec.transaction_header_id);
1265: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Mass Reference Id :'||p_trans_rec.mass_reference_id);
1266: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Transaction type code :'||p_trans_rec.transaction_type_code);
1267: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Transaction Date :'||p_trans_rec.transaction_date_entered);
1268: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Category Id :'||p_asset_cat_rec.category_id);
1269: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Transaction date entered :'||p_trans_rec.transaction_date_entered);
1270: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Mass Reference Id entered :'||p_trans_rec.mass_reference_id);

Line 1267: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Transaction Date :'||p_trans_rec.transaction_date_entered);

1263: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Asset Id :'||p_asset_hdr_rec.asset_id);
1264: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Transaction Header Id :'||p_trans_rec.transaction_header_id);
1265: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Mass Reference Id :'||p_trans_rec.mass_reference_id);
1266: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Transaction type code :'||p_trans_rec.transaction_type_code);
1267: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Transaction Date :'||p_trans_rec.transaction_date_entered);
1268: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Category Id :'||p_asset_cat_rec.category_id);
1269: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Transaction date entered :'||p_trans_rec.transaction_date_entered);
1270: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Mass Reference Id entered :'||p_trans_rec.mass_reference_id);
1271: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Mass Reference Id entered :'||p_asset_hdr_rec.set_of_books_id);

Line 1268: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Category Id :'||p_asset_cat_rec.category_id);

1264: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Transaction Header Id :'||p_trans_rec.transaction_header_id);
1265: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Mass Reference Id :'||p_trans_rec.mass_reference_id);
1266: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Transaction type code :'||p_trans_rec.transaction_type_code);
1267: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Transaction Date :'||p_trans_rec.transaction_date_entered);
1268: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Category Id :'||p_asset_cat_rec.category_id);
1269: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Transaction date entered :'||p_trans_rec.transaction_date_entered);
1270: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Mass Reference Id entered :'||p_trans_rec.mass_reference_id);
1271: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Mass Reference Id entered :'||p_asset_hdr_rec.set_of_books_id);
1272: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'******************************************************************************');

Line 1269: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Transaction date entered :'||p_trans_rec.transaction_date_entered);

1265: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Mass Reference Id :'||p_trans_rec.mass_reference_id);
1266: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Transaction type code :'||p_trans_rec.transaction_type_code);
1267: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Transaction Date :'||p_trans_rec.transaction_date_entered);
1268: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Category Id :'||p_asset_cat_rec.category_id);
1269: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Transaction date entered :'||p_trans_rec.transaction_date_entered);
1270: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Mass Reference Id entered :'||p_trans_rec.mass_reference_id);
1271: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Mass Reference Id entered :'||p_asset_hdr_rec.set_of_books_id);
1272: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'******************************************************************************');
1273:

Line 1270: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Mass Reference Id entered :'||p_trans_rec.mass_reference_id);

1266: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Transaction type code :'||p_trans_rec.transaction_type_code);
1267: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Transaction Date :'||p_trans_rec.transaction_date_entered);
1268: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Category Id :'||p_asset_cat_rec.category_id);
1269: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Transaction date entered :'||p_trans_rec.transaction_date_entered);
1270: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Mass Reference Id entered :'||p_trans_rec.mass_reference_id);
1271: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Mass Reference Id entered :'||p_asset_hdr_rec.set_of_books_id);
1272: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'******************************************************************************');
1273:
1274: -- Check If IAC is enabled

Line 1271: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Mass Reference Id entered :'||p_asset_hdr_rec.set_of_books_id);

1267: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Transaction Date :'||p_trans_rec.transaction_date_entered);
1268: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Category Id :'||p_asset_cat_rec.category_id);
1269: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Transaction date entered :'||p_trans_rec.transaction_date_entered);
1270: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Mass Reference Id entered :'||p_trans_rec.mass_reference_id);
1271: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Mass Reference Id entered :'||p_asset_hdr_rec.set_of_books_id);
1272: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'******************************************************************************');
1273:
1274: -- Check If IAC is enabled
1275: IF NOT igi_gen.is_req_installed('IAC') THEN

Line 1272: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'******************************************************************************');

1268: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Category Id :'||p_asset_cat_rec.category_id);
1269: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Transaction date entered :'||p_trans_rec.transaction_date_entered);
1270: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Mass Reference Id entered :'||p_trans_rec.mass_reference_id);
1271: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Mass Reference Id entered :'||p_asset_hdr_rec.set_of_books_id);
1272: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'******************************************************************************');
1273:
1274: -- Check If IAC is enabled
1275: IF NOT igi_gen.is_req_installed('IAC') THEN
1276: RAISE e_iac_not_enabled;

Line 1307: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'* Error in Synchronizing Depreciation Data *');

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;
1310:
1311: --Fetch the latest transaction = prev trans if latest is revaluation-preview or obsolete

Line 1334: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Prev adj: '||l_prev_adjustment_id||' Current: '||l_adjustment_id);

1330: IF (l_transaction_type_code = 'REVALUATION'
1331: AND l_adjustment_status IN ('PREVIEW', 'OBSOLETE')) THEN
1332: l_adjustment_id := l_prev_adjustment_id;
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)

Line 1341: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Current Period Counter :'||l_current_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);
1342: END IF;
1343:
1344: -- Check whether adjustments exist in the open period
1345: -- If Adjustments exists then stop the Transfer

Line 1365: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Prior Period Counter :'||l_prior_period_counter);

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;
1365: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Prior Period Counter :'||l_prior_period_counter);
1366: END IF;
1367:
1368: -- set the Prior_Period flag
1369: IF (l_prior_period_counter < l_current_period_counter) THEN

Line 1371: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Need to Process prior period transfers');

1367:
1368: -- set the Prior_Period flag
1369: IF (l_prior_period_counter < l_current_period_counter) THEN
1370: g_prior_period:= TRUE;
1371: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Need to Process prior period transfers');
1372: ELSE
1373: g_prior_period:= FALSE;
1374: END IF;
1375:

Line 1399: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Data inserted into transaction headers');

1395: x_adjustment_status => 'COMPLETE',
1396: x_period_counter => l_current_period_counter,
1397: x_event_id => p_event_id
1398: );
1399: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Data inserted into transaction headers');
1400:
1401: -- Get the start period counter for the fiscal year
1402: OPEN c_start_period_counter(l_prd_rec.fiscal_year);
1403: FETCH c_start_period_counter INTO l_start_period_counter;

Line 1408: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_start_period_counter = ' || l_start_period_counter);

1404: IF c_start_period_counter%NOTFOUND THEN
1405: RAISE NO_DATA_FOUND;
1406: END IF;
1407: CLOSE c_start_period_counter;
1408: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_start_period_counter = ' || l_start_period_counter);
1409:
1410: -- fetch the Distribution(s) involved in the transfer (old and new) and the non
1411: -- impacted ones
1412: OPEN c_no_of_imp;

Line 1418: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_no_of_imp = ' || l_no_of_imp.counter);

1414: IF c_no_of_imp%NOTFOUND THEN
1415: RAISE NO_DATA_FOUND;
1416: END IF;
1417: CLOSE c_no_of_imp;
1418: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_no_of_imp = ' || l_no_of_imp.counter);
1419:
1420: OPEN c_no_of_active;
1421: FETCH c_no_of_active INTO l_no_of_active;
1422: IF c_no_of_active%NOTFOUND THEN

Line 1426: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_no_of_active = ' || l_no_of_active);

1422: IF c_no_of_active%NOTFOUND THEN
1423: RAISE NO_DATA_FOUND;
1424: END IF;
1425: CLOSE c_no_of_active;
1426: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_no_of_active = ' || l_no_of_active);
1427:
1428: OPEN c_no_of_inactive;
1429: FETCH c_no_of_inactive INTO l_no_of_inactive;
1430: IF c_no_of_inactive%NOTFOUND THEN

Line 1434: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_no_of_inactive = ' || l_no_of_inactive);

1430: IF c_no_of_inactive%NOTFOUND THEN
1431: RAISE NO_DATA_FOUND;
1432: END IF;
1433: CLOSE c_no_of_inactive;
1434: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_no_of_inactive = ' || l_no_of_inactive);
1435:
1436: -- Get the total number of units for the asset
1437: OPEN c_units;
1438: FETCH c_units INTO l_units;

Line 1443: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Asset total units: '||l_units);

1439: IF c_units%NOTFOUND THEN
1440: RAISE NO_DATA_FOUND;
1441: END IF;
1442: CLOSE c_units;
1443: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Asset total units: '||l_units);
1444:
1445: -- get the number of units involved in the transfer
1446: OPEN c_transfer_units;
1447: FETCH c_transfer_units INTO l_transfer_units;

Line 1452: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_transfer_units: '||l_transfer_units);

1448: IF c_transfer_units%NOTFOUND THEN
1449: RAISE NO_DATA_FOUND;
1450: END IF;
1451: CLOSE c_transfer_units;
1452: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_transfer_units: '||l_transfer_units);
1453:
1454: -- fetch historic salvage value and cost for the asset
1455: OPEN c_get_asset_book(p_asset_hdr_rec.asset_id,
1456: p_asset_hdr_rec.book_type_code);

Line 1462: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_get_asset_book- Cost: '||l_get_asset_book.cost);

1458: IF c_get_asset_book%NOTFOUND THEN
1459: RAISE NO_DATA_FOUND;
1460: END IF;
1461: CLOSE c_get_asset_book;
1462: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_get_asset_book- Cost: '||l_get_asset_book.cost);
1463: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_get_asset_book- salvage_value: '||l_get_asset_book.salvage_value);
1464: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path
1465: ,'l_get_asset_book- period_counter_fully_reserved: '||l_get_asset_book.period_counter_fully_reserved);
1466:

Line 1463: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_get_asset_book- salvage_value: '||l_get_asset_book.salvage_value);

1459: RAISE NO_DATA_FOUND;
1460: END IF;
1461: CLOSE c_get_asset_book;
1462: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_get_asset_book- Cost: '||l_get_asset_book.cost);
1463: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_get_asset_book- salvage_value: '||l_get_asset_book.salvage_value);
1464: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path
1465: ,'l_get_asset_book- period_counter_fully_reserved: '||l_get_asset_book.period_counter_fully_reserved);
1466:
1467:

Line 1464: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path

1460: END IF;
1461: CLOSE c_get_asset_book;
1462: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_get_asset_book- Cost: '||l_get_asset_book.cost);
1463: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_get_asset_book- salvage_value: '||l_get_asset_book.salvage_value);
1464: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path
1465: ,'l_get_asset_book- period_counter_fully_reserved: '||l_get_asset_book.period_counter_fully_reserved);
1466:
1467:
1468: -- get asset amounts

Line 1488: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'----------Loop : '||i||'-----------------');

1484:
1485: i := 0;
1486: FOR l_all_dist in c_all_dist
1487: LOOP
1488: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'----------Loop : '||i||'-----------------');
1489: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_all_dist.distribution_id: '||l_all_dist.distribution_id);
1490: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_all_dist.transaction_header_id_in: '||l_all_dist.transaction_header_id_in);
1491: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_all_dist.units_assigned: '||l_all_dist.units_assigned);
1492: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_all_dist.transaction_header_id_out: '||l_all_dist.transaction_header_id_out);

Line 1489: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_all_dist.distribution_id: '||l_all_dist.distribution_id);

1485: i := 0;
1486: FOR l_all_dist in c_all_dist
1487: LOOP
1488: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'----------Loop : '||i||'-----------------');
1489: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_all_dist.distribution_id: '||l_all_dist.distribution_id);
1490: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_all_dist.transaction_header_id_in: '||l_all_dist.transaction_header_id_in);
1491: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_all_dist.units_assigned: '||l_all_dist.units_assigned);
1492: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_all_dist.transaction_header_id_out: '||l_all_dist.transaction_header_id_out);
1493: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_all_dist.transaction_units: '||l_all_dist.transaction_units);

Line 1490: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_all_dist.transaction_header_id_in: '||l_all_dist.transaction_header_id_in);

1486: FOR l_all_dist in c_all_dist
1487: LOOP
1488: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'----------Loop : '||i||'-----------------');
1489: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_all_dist.distribution_id: '||l_all_dist.distribution_id);
1490: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_all_dist.transaction_header_id_in: '||l_all_dist.transaction_header_id_in);
1491: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_all_dist.units_assigned: '||l_all_dist.units_assigned);
1492: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_all_dist.transaction_header_id_out: '||l_all_dist.transaction_header_id_out);
1493: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_all_dist.transaction_units: '||l_all_dist.transaction_units);
1494: i:=i+1;

Line 1491: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_all_dist.units_assigned: '||l_all_dist.units_assigned);

1487: LOOP
1488: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'----------Loop : '||i||'-----------------');
1489: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_all_dist.distribution_id: '||l_all_dist.distribution_id);
1490: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_all_dist.transaction_header_id_in: '||l_all_dist.transaction_header_id_in);
1491: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_all_dist.units_assigned: '||l_all_dist.units_assigned);
1492: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_all_dist.transaction_header_id_out: '||l_all_dist.transaction_header_id_out);
1493: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_all_dist.transaction_units: '||l_all_dist.transaction_units);
1494: i:=i+1;
1495: END LOOP;

Line 1492: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_all_dist.transaction_header_id_out: '||l_all_dist.transaction_header_id_out);

1488: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'----------Loop : '||i||'-----------------');
1489: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_all_dist.distribution_id: '||l_all_dist.distribution_id);
1490: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_all_dist.transaction_header_id_in: '||l_all_dist.transaction_header_id_in);
1491: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_all_dist.units_assigned: '||l_all_dist.units_assigned);
1492: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_all_dist.transaction_header_id_out: '||l_all_dist.transaction_header_id_out);
1493: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_all_dist.transaction_units: '||l_all_dist.transaction_units);
1494: i:=i+1;
1495: END LOOP;
1496:

Line 1493: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_all_dist.transaction_units: '||l_all_dist.transaction_units);

1489: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_all_dist.distribution_id: '||l_all_dist.distribution_id);
1490: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_all_dist.transaction_header_id_in: '||l_all_dist.transaction_header_id_in);
1491: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_all_dist.units_assigned: '||l_all_dist.units_assigned);
1492: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_all_dist.transaction_header_id_out: '||l_all_dist.transaction_header_id_out);
1493: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_all_dist.transaction_units: '||l_all_dist.transaction_units);
1494: i:=i+1;
1495: END LOOP;
1496:
1497: -- process all the distributions involved in the transfer

Line 1501: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Distribution id :'||l_all_dist.distribution_id);

1497: -- process all the distributions involved in the transfer
1498: i := 0;
1499: FOR l_all_dist in c_all_dist
1500: LOOP
1501: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Distribution id :'||l_all_dist.distribution_id);
1502: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Units for dist:'||l_all_dist.units_assigned);
1503:
1504: -- this distribution_id value is set when transaction_header_id_out is the
1505: -- p_trans_rec.transaction_header_id

Line 1502: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Units for dist:'||l_all_dist.units_assigned);

1498: i := 0;
1499: FOR l_all_dist in c_all_dist
1500: LOOP
1501: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Distribution id :'||l_all_dist.distribution_id);
1502: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Units for dist:'||l_all_dist.units_assigned);
1503:
1504: -- this distribution_id value is set when transaction_header_id_out is the
1505: -- p_trans_rec.transaction_header_id
1506: IF (l_all_dist.transaction_header_id_out = p_trans_rec.transaction_header_id) THEN

Line 1512: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_old_dist: '||l_old_dist);

1508: inact_cnt := inact_cnt + 1;
1509: ELSE
1510: l_old_dist := NULL;
1511: END IF;
1512: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_old_dist: '||l_old_dist);
1513: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'inact_cnt: '||inact_cnt);
1514:
1515: -- Get the impacted distribution values
1516: -- this distribution_id value is set when transaction_header_id_in is the

Line 1513: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'inact_cnt: '||inact_cnt);

1509: ELSE
1510: l_old_dist := NULL;
1511: END IF;
1512: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_old_dist: '||l_old_dist);
1513: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'inact_cnt: '||inact_cnt);
1514:
1515: -- Get the impacted distribution values
1516: -- this distribution_id value is set when transaction_header_id_in is the
1517: -- p_trans_rec.transaction_header_id

Line 1529: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_impacted_dist: '||l_impacted_dist);

1525: -- dist is active but was not involved in the transfer
1526: l_impacted_dist := NULL;
1527: l_impacted_units := NULL;
1528: END IF;
1529: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_impacted_dist: '||l_impacted_dist);
1530: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_impacted_units: '||l_impacted_units);
1531: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'act_cnt: '||act_cnt);
1532:
1533: -- keep a count of the active rows for rounding difference

Line 1530: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_impacted_units: '||l_impacted_units);

1526: l_impacted_dist := NULL;
1527: l_impacted_units := NULL;
1528: END IF;
1529: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_impacted_dist: '||l_impacted_dist);
1530: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_impacted_units: '||l_impacted_units);
1531: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'act_cnt: '||act_cnt);
1532:
1533: -- keep a count of the active rows for rounding difference
1534: IF (l_all_dist.transaction_header_id_out IS NULL) THEN

Line 1531: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'act_cnt: '||act_cnt);

1527: l_impacted_units := NULL;
1528: END IF;
1529: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_impacted_dist: '||l_impacted_dist);
1530: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_impacted_units: '||l_impacted_units);
1531: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'act_cnt: '||act_cnt);
1532:
1533: -- keep a count of the active rows for rounding difference
1534: IF (l_all_dist.transaction_header_id_out IS NULL) THEN
1535: i := i + 1;

Line 1537: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'i: '||i);

1533: -- keep a count of the active rows for rounding difference
1534: IF (l_all_dist.transaction_header_id_out IS NULL) THEN
1535: i := i + 1;
1536: END IF;
1537: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'i: '||i);
1538:
1539: -- prorate asset balance and ytd values for the distribution
1540: -- in parameters are asset level values
1541: -- out params are prorated dist values

Line 1587: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.ADJUSTMENT_ID: '||l_iac_dist.ADJUSTMENT_ID);

1583: IF c_iac_dist%NOTFOUND THEN
1584: RAISE NO_DATA_FOUND;
1585: END IF;
1586: CLOSE c_iac_dist;
1587: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.ADJUSTMENT_ID: '||l_iac_dist.ADJUSTMENT_ID);
1588: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.DISTRIBUTION_ID: '||l_iac_dist.DISTRIBUTION_ID);
1589: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.PERIOD_COUNTER: '||l_iac_dist.PERIOD_COUNTER);
1590: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.NET_BOOK_VALUE: '||l_iac_dist.NET_BOOK_VALUE);
1591: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.ADJUSTMENT_COST: '||l_iac_dist.ADJUSTMENT_COST);

Line 1588: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.DISTRIBUTION_ID: '||l_iac_dist.DISTRIBUTION_ID);

1584: RAISE NO_DATA_FOUND;
1585: END IF;
1586: CLOSE c_iac_dist;
1587: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.ADJUSTMENT_ID: '||l_iac_dist.ADJUSTMENT_ID);
1588: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.DISTRIBUTION_ID: '||l_iac_dist.DISTRIBUTION_ID);
1589: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.PERIOD_COUNTER: '||l_iac_dist.PERIOD_COUNTER);
1590: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.NET_BOOK_VALUE: '||l_iac_dist.NET_BOOK_VALUE);
1591: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.ADJUSTMENT_COST: '||l_iac_dist.ADJUSTMENT_COST);
1592: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.REVAL_RESERVE_COST: '||l_iac_dist.REVAL_RESERVE_COST);

Line 1589: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.PERIOD_COUNTER: '||l_iac_dist.PERIOD_COUNTER);

1585: END IF;
1586: CLOSE c_iac_dist;
1587: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.ADJUSTMENT_ID: '||l_iac_dist.ADJUSTMENT_ID);
1588: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.DISTRIBUTION_ID: '||l_iac_dist.DISTRIBUTION_ID);
1589: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.PERIOD_COUNTER: '||l_iac_dist.PERIOD_COUNTER);
1590: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.NET_BOOK_VALUE: '||l_iac_dist.NET_BOOK_VALUE);
1591: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.ADJUSTMENT_COST: '||l_iac_dist.ADJUSTMENT_COST);
1592: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.REVAL_RESERVE_COST: '||l_iac_dist.REVAL_RESERVE_COST);
1593: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.REVAL_RESERVE_BACKLOG: '||l_iac_dist.REVAL_RESERVE_BACKLOG);

Line 1590: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.NET_BOOK_VALUE: '||l_iac_dist.NET_BOOK_VALUE);

1586: CLOSE c_iac_dist;
1587: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.ADJUSTMENT_ID: '||l_iac_dist.ADJUSTMENT_ID);
1588: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.DISTRIBUTION_ID: '||l_iac_dist.DISTRIBUTION_ID);
1589: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.PERIOD_COUNTER: '||l_iac_dist.PERIOD_COUNTER);
1590: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.NET_BOOK_VALUE: '||l_iac_dist.NET_BOOK_VALUE);
1591: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.ADJUSTMENT_COST: '||l_iac_dist.ADJUSTMENT_COST);
1592: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.REVAL_RESERVE_COST: '||l_iac_dist.REVAL_RESERVE_COST);
1593: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.REVAL_RESERVE_BACKLOG: '||l_iac_dist.REVAL_RESERVE_BACKLOG);
1594: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.REVAL_RESERVE_GEN_FUND: '||l_iac_dist.REVAL_RESERVE_GEN_FUND);

Line 1591: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.ADJUSTMENT_COST: '||l_iac_dist.ADJUSTMENT_COST);

1587: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.ADJUSTMENT_ID: '||l_iac_dist.ADJUSTMENT_ID);
1588: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.DISTRIBUTION_ID: '||l_iac_dist.DISTRIBUTION_ID);
1589: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.PERIOD_COUNTER: '||l_iac_dist.PERIOD_COUNTER);
1590: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.NET_BOOK_VALUE: '||l_iac_dist.NET_BOOK_VALUE);
1591: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.ADJUSTMENT_COST: '||l_iac_dist.ADJUSTMENT_COST);
1592: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.REVAL_RESERVE_COST: '||l_iac_dist.REVAL_RESERVE_COST);
1593: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.REVAL_RESERVE_BACKLOG: '||l_iac_dist.REVAL_RESERVE_BACKLOG);
1594: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.REVAL_RESERVE_GEN_FUND: '||l_iac_dist.REVAL_RESERVE_GEN_FUND);
1595: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.REVAL_RESERVE_NET: '||l_iac_dist.REVAL_RESERVE_NET);

Line 1592: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.REVAL_RESERVE_COST: '||l_iac_dist.REVAL_RESERVE_COST);

1588: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.DISTRIBUTION_ID: '||l_iac_dist.DISTRIBUTION_ID);
1589: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.PERIOD_COUNTER: '||l_iac_dist.PERIOD_COUNTER);
1590: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.NET_BOOK_VALUE: '||l_iac_dist.NET_BOOK_VALUE);
1591: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.ADJUSTMENT_COST: '||l_iac_dist.ADJUSTMENT_COST);
1592: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.REVAL_RESERVE_COST: '||l_iac_dist.REVAL_RESERVE_COST);
1593: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.REVAL_RESERVE_BACKLOG: '||l_iac_dist.REVAL_RESERVE_BACKLOG);
1594: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.REVAL_RESERVE_GEN_FUND: '||l_iac_dist.REVAL_RESERVE_GEN_FUND);
1595: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.REVAL_RESERVE_NET: '||l_iac_dist.REVAL_RESERVE_NET);
1596: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.OPERATING_ACCT_COST: '||l_iac_dist.OPERATING_ACCT_COST);

Line 1593: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.REVAL_RESERVE_BACKLOG: '||l_iac_dist.REVAL_RESERVE_BACKLOG);

1589: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.PERIOD_COUNTER: '||l_iac_dist.PERIOD_COUNTER);
1590: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.NET_BOOK_VALUE: '||l_iac_dist.NET_BOOK_VALUE);
1591: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.ADJUSTMENT_COST: '||l_iac_dist.ADJUSTMENT_COST);
1592: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.REVAL_RESERVE_COST: '||l_iac_dist.REVAL_RESERVE_COST);
1593: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.REVAL_RESERVE_BACKLOG: '||l_iac_dist.REVAL_RESERVE_BACKLOG);
1594: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.REVAL_RESERVE_GEN_FUND: '||l_iac_dist.REVAL_RESERVE_GEN_FUND);
1595: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.REVAL_RESERVE_NET: '||l_iac_dist.REVAL_RESERVE_NET);
1596: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.OPERATING_ACCT_COST: '||l_iac_dist.OPERATING_ACCT_COST);
1597: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.OPERATING_ACCT_BACKLOG: '||l_iac_dist.OPERATING_ACCT_BACKLOG);

Line 1594: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.REVAL_RESERVE_GEN_FUND: '||l_iac_dist.REVAL_RESERVE_GEN_FUND);

1590: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.NET_BOOK_VALUE: '||l_iac_dist.NET_BOOK_VALUE);
1591: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.ADJUSTMENT_COST: '||l_iac_dist.ADJUSTMENT_COST);
1592: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.REVAL_RESERVE_COST: '||l_iac_dist.REVAL_RESERVE_COST);
1593: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.REVAL_RESERVE_BACKLOG: '||l_iac_dist.REVAL_RESERVE_BACKLOG);
1594: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.REVAL_RESERVE_GEN_FUND: '||l_iac_dist.REVAL_RESERVE_GEN_FUND);
1595: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.REVAL_RESERVE_NET: '||l_iac_dist.REVAL_RESERVE_NET);
1596: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.OPERATING_ACCT_COST: '||l_iac_dist.OPERATING_ACCT_COST);
1597: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.OPERATING_ACCT_BACKLOG: '||l_iac_dist.OPERATING_ACCT_BACKLOG);
1598: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.OPERATING_ACCT_NET: '||l_iac_dist.OPERATING_ACCT_NET);

Line 1595: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.REVAL_RESERVE_NET: '||l_iac_dist.REVAL_RESERVE_NET);

1591: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.ADJUSTMENT_COST: '||l_iac_dist.ADJUSTMENT_COST);
1592: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.REVAL_RESERVE_COST: '||l_iac_dist.REVAL_RESERVE_COST);
1593: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.REVAL_RESERVE_BACKLOG: '||l_iac_dist.REVAL_RESERVE_BACKLOG);
1594: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.REVAL_RESERVE_GEN_FUND: '||l_iac_dist.REVAL_RESERVE_GEN_FUND);
1595: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.REVAL_RESERVE_NET: '||l_iac_dist.REVAL_RESERVE_NET);
1596: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.OPERATING_ACCT_COST: '||l_iac_dist.OPERATING_ACCT_COST);
1597: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.OPERATING_ACCT_BACKLOG: '||l_iac_dist.OPERATING_ACCT_BACKLOG);
1598: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.OPERATING_ACCT_NET: '||l_iac_dist.OPERATING_ACCT_NET);
1599: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.OPERATING_ACCT_YTD: '||l_iac_dist.OPERATING_ACCT_YTD);

Line 1596: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.OPERATING_ACCT_COST: '||l_iac_dist.OPERATING_ACCT_COST);

1592: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.REVAL_RESERVE_COST: '||l_iac_dist.REVAL_RESERVE_COST);
1593: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.REVAL_RESERVE_BACKLOG: '||l_iac_dist.REVAL_RESERVE_BACKLOG);
1594: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.REVAL_RESERVE_GEN_FUND: '||l_iac_dist.REVAL_RESERVE_GEN_FUND);
1595: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.REVAL_RESERVE_NET: '||l_iac_dist.REVAL_RESERVE_NET);
1596: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.OPERATING_ACCT_COST: '||l_iac_dist.OPERATING_ACCT_COST);
1597: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.OPERATING_ACCT_BACKLOG: '||l_iac_dist.OPERATING_ACCT_BACKLOG);
1598: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.OPERATING_ACCT_NET: '||l_iac_dist.OPERATING_ACCT_NET);
1599: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.OPERATING_ACCT_YTD: '||l_iac_dist.OPERATING_ACCT_YTD);
1600: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.DEPRN_PERIOD: '||l_iac_dist.DEPRN_PERIOD);

Line 1597: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.OPERATING_ACCT_BACKLOG: '||l_iac_dist.OPERATING_ACCT_BACKLOG);

1593: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.REVAL_RESERVE_BACKLOG: '||l_iac_dist.REVAL_RESERVE_BACKLOG);
1594: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.REVAL_RESERVE_GEN_FUND: '||l_iac_dist.REVAL_RESERVE_GEN_FUND);
1595: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.REVAL_RESERVE_NET: '||l_iac_dist.REVAL_RESERVE_NET);
1596: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.OPERATING_ACCT_COST: '||l_iac_dist.OPERATING_ACCT_COST);
1597: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.OPERATING_ACCT_BACKLOG: '||l_iac_dist.OPERATING_ACCT_BACKLOG);
1598: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.OPERATING_ACCT_NET: '||l_iac_dist.OPERATING_ACCT_NET);
1599: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.OPERATING_ACCT_YTD: '||l_iac_dist.OPERATING_ACCT_YTD);
1600: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.DEPRN_PERIOD: '||l_iac_dist.DEPRN_PERIOD);
1601: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.DEPRN_YTD: '||l_iac_dist.DEPRN_YTD);

Line 1598: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.OPERATING_ACCT_NET: '||l_iac_dist.OPERATING_ACCT_NET);

1594: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.REVAL_RESERVE_GEN_FUND: '||l_iac_dist.REVAL_RESERVE_GEN_FUND);
1595: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.REVAL_RESERVE_NET: '||l_iac_dist.REVAL_RESERVE_NET);
1596: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.OPERATING_ACCT_COST: '||l_iac_dist.OPERATING_ACCT_COST);
1597: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.OPERATING_ACCT_BACKLOG: '||l_iac_dist.OPERATING_ACCT_BACKLOG);
1598: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.OPERATING_ACCT_NET: '||l_iac_dist.OPERATING_ACCT_NET);
1599: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.OPERATING_ACCT_YTD: '||l_iac_dist.OPERATING_ACCT_YTD);
1600: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.DEPRN_PERIOD: '||l_iac_dist.DEPRN_PERIOD);
1601: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.DEPRN_YTD: '||l_iac_dist.DEPRN_YTD);
1602: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.DEPRN_RESERVE: '||l_iac_dist.DEPRN_RESERVE);

Line 1599: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.OPERATING_ACCT_YTD: '||l_iac_dist.OPERATING_ACCT_YTD);

1595: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.REVAL_RESERVE_NET: '||l_iac_dist.REVAL_RESERVE_NET);
1596: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.OPERATING_ACCT_COST: '||l_iac_dist.OPERATING_ACCT_COST);
1597: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.OPERATING_ACCT_BACKLOG: '||l_iac_dist.OPERATING_ACCT_BACKLOG);
1598: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.OPERATING_ACCT_NET: '||l_iac_dist.OPERATING_ACCT_NET);
1599: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.OPERATING_ACCT_YTD: '||l_iac_dist.OPERATING_ACCT_YTD);
1600: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.DEPRN_PERIOD: '||l_iac_dist.DEPRN_PERIOD);
1601: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.DEPRN_YTD: '||l_iac_dist.DEPRN_YTD);
1602: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.DEPRN_RESERVE: '||l_iac_dist.DEPRN_RESERVE);
1603: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.DEPRN_RESERVE_BACKLOG: '||l_iac_dist.DEPRN_RESERVE_BACKLOG);

Line 1600: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.DEPRN_PERIOD: '||l_iac_dist.DEPRN_PERIOD);

1596: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.OPERATING_ACCT_COST: '||l_iac_dist.OPERATING_ACCT_COST);
1597: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.OPERATING_ACCT_BACKLOG: '||l_iac_dist.OPERATING_ACCT_BACKLOG);
1598: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.OPERATING_ACCT_NET: '||l_iac_dist.OPERATING_ACCT_NET);
1599: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.OPERATING_ACCT_YTD: '||l_iac_dist.OPERATING_ACCT_YTD);
1600: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.DEPRN_PERIOD: '||l_iac_dist.DEPRN_PERIOD);
1601: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.DEPRN_YTD: '||l_iac_dist.DEPRN_YTD);
1602: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.DEPRN_RESERVE: '||l_iac_dist.DEPRN_RESERVE);
1603: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.DEPRN_RESERVE_BACKLOG: '||l_iac_dist.DEPRN_RESERVE_BACKLOG);
1604: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.GENERAL_FUND_PER: '||l_iac_dist.GENERAL_FUND_PER);

Line 1601: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.DEPRN_YTD: '||l_iac_dist.DEPRN_YTD);

1597: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.OPERATING_ACCT_BACKLOG: '||l_iac_dist.OPERATING_ACCT_BACKLOG);
1598: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.OPERATING_ACCT_NET: '||l_iac_dist.OPERATING_ACCT_NET);
1599: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.OPERATING_ACCT_YTD: '||l_iac_dist.OPERATING_ACCT_YTD);
1600: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.DEPRN_PERIOD: '||l_iac_dist.DEPRN_PERIOD);
1601: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.DEPRN_YTD: '||l_iac_dist.DEPRN_YTD);
1602: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.DEPRN_RESERVE: '||l_iac_dist.DEPRN_RESERVE);
1603: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.DEPRN_RESERVE_BACKLOG: '||l_iac_dist.DEPRN_RESERVE_BACKLOG);
1604: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.GENERAL_FUND_PER: '||l_iac_dist.GENERAL_FUND_PER);
1605: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.GENERAL_FUND_ACC: '||l_iac_dist.GENERAL_FUND_ACC);

Line 1602: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.DEPRN_RESERVE: '||l_iac_dist.DEPRN_RESERVE);

1598: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.OPERATING_ACCT_NET: '||l_iac_dist.OPERATING_ACCT_NET);
1599: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.OPERATING_ACCT_YTD: '||l_iac_dist.OPERATING_ACCT_YTD);
1600: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.DEPRN_PERIOD: '||l_iac_dist.DEPRN_PERIOD);
1601: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.DEPRN_YTD: '||l_iac_dist.DEPRN_YTD);
1602: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.DEPRN_RESERVE: '||l_iac_dist.DEPRN_RESERVE);
1603: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.DEPRN_RESERVE_BACKLOG: '||l_iac_dist.DEPRN_RESERVE_BACKLOG);
1604: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.GENERAL_FUND_PER: '||l_iac_dist.GENERAL_FUND_PER);
1605: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.GENERAL_FUND_ACC: '||l_iac_dist.GENERAL_FUND_ACC);
1606: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.LAST_REVAL_DATE: '||l_iac_dist.LAST_REVAL_DATE);

Line 1603: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.DEPRN_RESERVE_BACKLOG: '||l_iac_dist.DEPRN_RESERVE_BACKLOG);

1599: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.OPERATING_ACCT_YTD: '||l_iac_dist.OPERATING_ACCT_YTD);
1600: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.DEPRN_PERIOD: '||l_iac_dist.DEPRN_PERIOD);
1601: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.DEPRN_YTD: '||l_iac_dist.DEPRN_YTD);
1602: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.DEPRN_RESERVE: '||l_iac_dist.DEPRN_RESERVE);
1603: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.DEPRN_RESERVE_BACKLOG: '||l_iac_dist.DEPRN_RESERVE_BACKLOG);
1604: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.GENERAL_FUND_PER: '||l_iac_dist.GENERAL_FUND_PER);
1605: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.GENERAL_FUND_ACC: '||l_iac_dist.GENERAL_FUND_ACC);
1606: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.LAST_REVAL_DATE: '||l_iac_dist.LAST_REVAL_DATE);
1607: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.CURRENT_REVAL_FACTOR: '||l_iac_dist.CURRENT_REVAL_FACTOR);

Line 1604: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.GENERAL_FUND_PER: '||l_iac_dist.GENERAL_FUND_PER);

1600: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.DEPRN_PERIOD: '||l_iac_dist.DEPRN_PERIOD);
1601: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.DEPRN_YTD: '||l_iac_dist.DEPRN_YTD);
1602: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.DEPRN_RESERVE: '||l_iac_dist.DEPRN_RESERVE);
1603: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.DEPRN_RESERVE_BACKLOG: '||l_iac_dist.DEPRN_RESERVE_BACKLOG);
1604: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.GENERAL_FUND_PER: '||l_iac_dist.GENERAL_FUND_PER);
1605: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.GENERAL_FUND_ACC: '||l_iac_dist.GENERAL_FUND_ACC);
1606: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.LAST_REVAL_DATE: '||l_iac_dist.LAST_REVAL_DATE);
1607: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.CURRENT_REVAL_FACTOR: '||l_iac_dist.CURRENT_REVAL_FACTOR);
1608: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.CUMULATIVE_REVAL_FACTOR: '||l_iac_dist.CUMULATIVE_REVAL_FACTOR);

Line 1605: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.GENERAL_FUND_ACC: '||l_iac_dist.GENERAL_FUND_ACC);

1601: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.DEPRN_YTD: '||l_iac_dist.DEPRN_YTD);
1602: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.DEPRN_RESERVE: '||l_iac_dist.DEPRN_RESERVE);
1603: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.DEPRN_RESERVE_BACKLOG: '||l_iac_dist.DEPRN_RESERVE_BACKLOG);
1604: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.GENERAL_FUND_PER: '||l_iac_dist.GENERAL_FUND_PER);
1605: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.GENERAL_FUND_ACC: '||l_iac_dist.GENERAL_FUND_ACC);
1606: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.LAST_REVAL_DATE: '||l_iac_dist.LAST_REVAL_DATE);
1607: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.CURRENT_REVAL_FACTOR: '||l_iac_dist.CURRENT_REVAL_FACTOR);
1608: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.CUMULATIVE_REVAL_FACTOR: '||l_iac_dist.CUMULATIVE_REVAL_FACTOR);
1609:

Line 1606: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.LAST_REVAL_DATE: '||l_iac_dist.LAST_REVAL_DATE);

1602: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.DEPRN_RESERVE: '||l_iac_dist.DEPRN_RESERVE);
1603: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.DEPRN_RESERVE_BACKLOG: '||l_iac_dist.DEPRN_RESERVE_BACKLOG);
1604: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.GENERAL_FUND_PER: '||l_iac_dist.GENERAL_FUND_PER);
1605: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.GENERAL_FUND_ACC: '||l_iac_dist.GENERAL_FUND_ACC);
1606: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.LAST_REVAL_DATE: '||l_iac_dist.LAST_REVAL_DATE);
1607: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.CURRENT_REVAL_FACTOR: '||l_iac_dist.CURRENT_REVAL_FACTOR);
1608: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.CUMULATIVE_REVAL_FACTOR: '||l_iac_dist.CUMULATIVE_REVAL_FACTOR);
1609:
1610: l_reval_reserve := l_iac_dist.reval_reserve_net;

Line 1607: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.CURRENT_REVAL_FACTOR: '||l_iac_dist.CURRENT_REVAL_FACTOR);

1603: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.DEPRN_RESERVE_BACKLOG: '||l_iac_dist.DEPRN_RESERVE_BACKLOG);
1604: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.GENERAL_FUND_PER: '||l_iac_dist.GENERAL_FUND_PER);
1605: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.GENERAL_FUND_ACC: '||l_iac_dist.GENERAL_FUND_ACC);
1606: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.LAST_REVAL_DATE: '||l_iac_dist.LAST_REVAL_DATE);
1607: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.CURRENT_REVAL_FACTOR: '||l_iac_dist.CURRENT_REVAL_FACTOR);
1608: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.CUMULATIVE_REVAL_FACTOR: '||l_iac_dist.CUMULATIVE_REVAL_FACTOR);
1609:
1610: l_reval_reserve := l_iac_dist.reval_reserve_net;
1611: l_general_fund := l_iac_dist.general_fund_acc;

Line 1608: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.CUMULATIVE_REVAL_FACTOR: '||l_iac_dist.CUMULATIVE_REVAL_FACTOR);

1604: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.GENERAL_FUND_PER: '||l_iac_dist.GENERAL_FUND_PER);
1605: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.GENERAL_FUND_ACC: '||l_iac_dist.GENERAL_FUND_ACC);
1606: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.LAST_REVAL_DATE: '||l_iac_dist.LAST_REVAL_DATE);
1607: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.CURRENT_REVAL_FACTOR: '||l_iac_dist.CURRENT_REVAL_FACTOR);
1608: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_iac_dist.CUMULATIVE_REVAL_FACTOR: '||l_iac_dist.CUMULATIVE_REVAL_FACTOR);
1609:
1610: l_reval_reserve := l_iac_dist.reval_reserve_net;
1611: l_general_fund := l_iac_dist.general_fund_acc;
1612: l_backlog_deprn_reserve := l_iac_dist.deprn_reserve_backlog;

Line 1634: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_fa_dist_data.ADJUSTMENT_ID: '||l_fa_dist_data.ADJUSTMENT_ID);

1630: RAISE NO_DATA_FOUND;
1631: END IF;
1632: CLOSE c_fa_dist_data;
1633:
1634: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_fa_dist_data.ADJUSTMENT_ID: '||l_fa_dist_data.ADJUSTMENT_ID);
1635: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_fa_dist_data.DISTRIBUTION_ID: '||l_fa_dist_data.DISTRIBUTION_ID);
1636: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_fa_dist_data.DEPRN_PERIOD: '||l_fa_dist_data.DEPRN_PERIOD);
1637: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_fa_dist_data.DEPRN_YTD: '||l_fa_dist_data.DEPRN_YTD);
1638: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_fa_dist_data.DEPRN_RESERVE: '||l_fa_dist_data.DEPRN_RESERVE);

Line 1635: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_fa_dist_data.DISTRIBUTION_ID: '||l_fa_dist_data.DISTRIBUTION_ID);

1631: END IF;
1632: CLOSE c_fa_dist_data;
1633:
1634: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_fa_dist_data.ADJUSTMENT_ID: '||l_fa_dist_data.ADJUSTMENT_ID);
1635: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_fa_dist_data.DISTRIBUTION_ID: '||l_fa_dist_data.DISTRIBUTION_ID);
1636: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_fa_dist_data.DEPRN_PERIOD: '||l_fa_dist_data.DEPRN_PERIOD);
1637: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_fa_dist_data.DEPRN_YTD: '||l_fa_dist_data.DEPRN_YTD);
1638: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_fa_dist_data.DEPRN_RESERVE: '||l_fa_dist_data.DEPRN_RESERVE);
1639:

Line 1636: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_fa_dist_data.DEPRN_PERIOD: '||l_fa_dist_data.DEPRN_PERIOD);

1632: CLOSE c_fa_dist_data;
1633:
1634: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_fa_dist_data.ADJUSTMENT_ID: '||l_fa_dist_data.ADJUSTMENT_ID);
1635: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_fa_dist_data.DISTRIBUTION_ID: '||l_fa_dist_data.DISTRIBUTION_ID);
1636: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_fa_dist_data.DEPRN_PERIOD: '||l_fa_dist_data.DEPRN_PERIOD);
1637: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_fa_dist_data.DEPRN_YTD: '||l_fa_dist_data.DEPRN_YTD);
1638: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_fa_dist_data.DEPRN_RESERVE: '||l_fa_dist_data.DEPRN_RESERVE);
1639:
1640: l_fa_deprn_period := l_fa_dist_data.deprn_period;

Line 1637: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_fa_dist_data.DEPRN_YTD: '||l_fa_dist_data.DEPRN_YTD);

1633:
1634: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_fa_dist_data.ADJUSTMENT_ID: '||l_fa_dist_data.ADJUSTMENT_ID);
1635: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_fa_dist_data.DISTRIBUTION_ID: '||l_fa_dist_data.DISTRIBUTION_ID);
1636: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_fa_dist_data.DEPRN_PERIOD: '||l_fa_dist_data.DEPRN_PERIOD);
1637: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_fa_dist_data.DEPRN_YTD: '||l_fa_dist_data.DEPRN_YTD);
1638: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_fa_dist_data.DEPRN_RESERVE: '||l_fa_dist_data.DEPRN_RESERVE);
1639:
1640: l_fa_deprn_period := l_fa_dist_data.deprn_period;
1641: l_fa_deprn_reserve := l_fa_dist_data.deprn_reserve;

Line 1638: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_fa_dist_data.DEPRN_RESERVE: '||l_fa_dist_data.DEPRN_RESERVE);

1634: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_fa_dist_data.ADJUSTMENT_ID: '||l_fa_dist_data.ADJUSTMENT_ID);
1635: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_fa_dist_data.DISTRIBUTION_ID: '||l_fa_dist_data.DISTRIBUTION_ID);
1636: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_fa_dist_data.DEPRN_PERIOD: '||l_fa_dist_data.DEPRN_PERIOD);
1637: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_fa_dist_data.DEPRN_YTD: '||l_fa_dist_data.DEPRN_YTD);
1638: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_fa_dist_data.DEPRN_RESERVE: '||l_fa_dist_data.DEPRN_RESERVE);
1639:
1640: l_fa_deprn_period := l_fa_dist_data.deprn_period;
1641: l_fa_deprn_reserve := l_fa_dist_data.deprn_reserve;
1642: l_fa_deprn_ytd := l_fa_dist_data.deprn_ytd;

Line 1663: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_deprn_expense: '||l_deprn_expense);

1659: l_deprn_expense := 0;
1660: l_dist_op_exp := 0;
1661: l_fa_deprn_expense := 0;
1662: END IF;
1663: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_deprn_expense: '||l_deprn_expense);
1664: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_dist_op_exp: '||l_dist_op_exp);
1665: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_fa_deprn_expense: '||l_fa_deprn_expense);
1666:
1667: -- find all the account ccids for the distribution

Line 1664: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_dist_op_exp: '||l_dist_op_exp);

1660: l_dist_op_exp := 0;
1661: l_fa_deprn_expense := 0;
1662: END IF;
1663: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_deprn_expense: '||l_deprn_expense);
1664: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_dist_op_exp: '||l_dist_op_exp);
1665: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_fa_deprn_expense: '||l_fa_deprn_expense);
1666:
1667: -- find all the account ccids for the distribution
1668: find_ccid(p_asset_hdr_rec.book_type_code,

Line 1665: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_fa_deprn_expense: '||l_fa_deprn_expense);

1661: l_fa_deprn_expense := 0;
1662: END IF;
1663: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_deprn_expense: '||l_deprn_expense);
1664: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_dist_op_exp: '||l_dist_op_exp);
1665: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_fa_deprn_expense: '||l_fa_deprn_expense);
1666:
1667: -- find all the account ccids for the distribution
1668: find_ccid(p_asset_hdr_rec.book_type_code,
1669: p_asset_hdr_rec.asset_id,

Line 1768: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_reval_reserve_sum: '||l_reval_reserve_sum);

1764:
1765: IF l_all_dist.distribution_id <> nvl(l_old_dist, -1) THEN
1766: -- maintain running total for the active distributions
1767: l_reval_reserve_sum :=l_reval_reserve+l_reval_reserve_sum;
1768: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_reval_reserve_sum: '||l_reval_reserve_sum);
1769: l_general_fund_sum :=l_general_fund+l_general_fund_sum;
1770: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_general_fund_sum: '||l_general_fund_sum);
1771: l_Backlog_deprn_reserve_sum :=l_Backlog_deprn_reserve+l_Backlog_deprn_reserve_sum;
1772: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_Backlog_deprn_reserve_sum: '||l_Backlog_deprn_reserve_sum);

Line 1770: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_general_fund_sum: '||l_general_fund_sum);

1766: -- maintain running total for the active distributions
1767: l_reval_reserve_sum :=l_reval_reserve+l_reval_reserve_sum;
1768: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_reval_reserve_sum: '||l_reval_reserve_sum);
1769: l_general_fund_sum :=l_general_fund+l_general_fund_sum;
1770: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_general_fund_sum: '||l_general_fund_sum);
1771: l_Backlog_deprn_reserve_sum :=l_Backlog_deprn_reserve+l_Backlog_deprn_reserve_sum;
1772: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_Backlog_deprn_reserve_sum: '||l_Backlog_deprn_reserve_sum);
1773: l_deprn_reserve_sum :=l_deprn_reserve+l_deprn_reserve_sum;
1774: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_deprn_reserve_sum: '||l_deprn_reserve_sum);

Line 1772: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_Backlog_deprn_reserve_sum: '||l_Backlog_deprn_reserve_sum);

1768: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_reval_reserve_sum: '||l_reval_reserve_sum);
1769: l_general_fund_sum :=l_general_fund+l_general_fund_sum;
1770: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_general_fund_sum: '||l_general_fund_sum);
1771: l_Backlog_deprn_reserve_sum :=l_Backlog_deprn_reserve+l_Backlog_deprn_reserve_sum;
1772: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_Backlog_deprn_reserve_sum: '||l_Backlog_deprn_reserve_sum);
1773: l_deprn_reserve_sum :=l_deprn_reserve+l_deprn_reserve_sum;
1774: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_deprn_reserve_sum: '||l_deprn_reserve_sum);
1775: l_adjusted_cost_sum :=l_adjusted_cost+l_adjusted_cost_sum;
1776: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_adjusted_cost_sum: '||l_adjusted_cost_sum);

Line 1774: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_deprn_reserve_sum: '||l_deprn_reserve_sum);

1770: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_general_fund_sum: '||l_general_fund_sum);
1771: l_Backlog_deprn_reserve_sum :=l_Backlog_deprn_reserve+l_Backlog_deprn_reserve_sum;
1772: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_Backlog_deprn_reserve_sum: '||l_Backlog_deprn_reserve_sum);
1773: l_deprn_reserve_sum :=l_deprn_reserve+l_deprn_reserve_sum;
1774: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_deprn_reserve_sum: '||l_deprn_reserve_sum);
1775: l_adjusted_cost_sum :=l_adjusted_cost+l_adjusted_cost_sum;
1776: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_adjusted_cost_sum: '||l_adjusted_cost_sum);
1777: l_net_book_value_sum :=l_net_book_value+l_net_book_value_sum;
1778: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_net_book_value_sum: '||l_net_book_value_sum);

Line 1776: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_adjusted_cost_sum: '||l_adjusted_cost_sum);

1772: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_Backlog_deprn_reserve_sum: '||l_Backlog_deprn_reserve_sum);
1773: l_deprn_reserve_sum :=l_deprn_reserve+l_deprn_reserve_sum;
1774: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_deprn_reserve_sum: '||l_deprn_reserve_sum);
1775: l_adjusted_cost_sum :=l_adjusted_cost+l_adjusted_cost_sum;
1776: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_adjusted_cost_sum: '||l_adjusted_cost_sum);
1777: l_net_book_value_sum :=l_net_book_value+l_net_book_value_sum;
1778: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_net_book_value_sum: '||l_net_book_value_sum);
1779: l_deprn_per_sum :=l_deprn_per+l_deprn_per_sum;
1780: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_deprn_per_sum: '||l_deprn_per_sum);

Line 1778: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_net_book_value_sum: '||l_net_book_value_sum);

1774: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_deprn_reserve_sum: '||l_deprn_reserve_sum);
1775: l_adjusted_cost_sum :=l_adjusted_cost+l_adjusted_cost_sum;
1776: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_adjusted_cost_sum: '||l_adjusted_cost_sum);
1777: l_net_book_value_sum :=l_net_book_value+l_net_book_value_sum;
1778: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_net_book_value_sum: '||l_net_book_value_sum);
1779: l_deprn_per_sum :=l_deprn_per+l_deprn_per_sum;
1780: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_deprn_per_sum: '||l_deprn_per_sum);
1781: l_ytd_deprn_sum :=l_ytd_deprn+l_ytd_deprn_sum;
1782: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_ytd_deprn_sum: '||l_ytd_deprn_sum);

Line 1780: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_deprn_per_sum: '||l_deprn_per_sum);

1776: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_adjusted_cost_sum: '||l_adjusted_cost_sum);
1777: l_net_book_value_sum :=l_net_book_value+l_net_book_value_sum;
1778: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_net_book_value_sum: '||l_net_book_value_sum);
1779: l_deprn_per_sum :=l_deprn_per+l_deprn_per_sum;
1780: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_deprn_per_sum: '||l_deprn_per_sum);
1781: l_ytd_deprn_sum :=l_ytd_deprn+l_ytd_deprn_sum;
1782: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_ytd_deprn_sum: '||l_ytd_deprn_sum);
1783: l_op_acct_sum :=l_op_acct+l_op_acct_sum;
1784: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_op_acct_sum: '||l_op_acct_sum);

Line 1782: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_ytd_deprn_sum: '||l_ytd_deprn_sum);

1778: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_net_book_value_sum: '||l_net_book_value_sum);
1779: l_deprn_per_sum :=l_deprn_per+l_deprn_per_sum;
1780: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_deprn_per_sum: '||l_deprn_per_sum);
1781: l_ytd_deprn_sum :=l_ytd_deprn+l_ytd_deprn_sum;
1782: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_ytd_deprn_sum: '||l_ytd_deprn_sum);
1783: l_op_acct_sum :=l_op_acct+l_op_acct_sum;
1784: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_op_acct_sum: '||l_op_acct_sum);
1785: l_general_fund_per_sum :=l_general_fund_per+l_general_fund_per_sum;
1786: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_general_fund_per_sum: '||l_general_fund_per_sum);

Line 1784: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_op_acct_sum: '||l_op_acct_sum);

1780: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_deprn_per_sum: '||l_deprn_per_sum);
1781: l_ytd_deprn_sum :=l_ytd_deprn+l_ytd_deprn_sum;
1782: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_ytd_deprn_sum: '||l_ytd_deprn_sum);
1783: l_op_acct_sum :=l_op_acct+l_op_acct_sum;
1784: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_op_acct_sum: '||l_op_acct_sum);
1785: l_general_fund_per_sum :=l_general_fund_per+l_general_fund_per_sum;
1786: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_general_fund_per_sum: '||l_general_fund_per_sum);
1787: l_reval_reserve_backlog_sum :=l_reval_reserve_backlog+l_reval_reserve_backlog_sum;
1788: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_reval_reserve_backlog_sum: '||l_reval_reserve_backlog_sum);

Line 1786: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_general_fund_per_sum: '||l_general_fund_per_sum);

1782: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_ytd_deprn_sum: '||l_ytd_deprn_sum);
1783: l_op_acct_sum :=l_op_acct+l_op_acct_sum;
1784: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_op_acct_sum: '||l_op_acct_sum);
1785: l_general_fund_per_sum :=l_general_fund_per+l_general_fund_per_sum;
1786: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_general_fund_per_sum: '||l_general_fund_per_sum);
1787: l_reval_reserve_backlog_sum :=l_reval_reserve_backlog+l_reval_reserve_backlog_sum;
1788: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_reval_reserve_backlog_sum: '||l_reval_reserve_backlog_sum);
1789: l_operating_acct_backlog_sum :=l_operating_acct_backlog+l_operating_acct_backlog_sum;
1790: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_operating_acct_backlog_sum: '||l_operating_acct_backlog_sum);

Line 1788: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_reval_reserve_backlog_sum: '||l_reval_reserve_backlog_sum);

1784: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_op_acct_sum: '||l_op_acct_sum);
1785: l_general_fund_per_sum :=l_general_fund_per+l_general_fund_per_sum;
1786: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_general_fund_per_sum: '||l_general_fund_per_sum);
1787: l_reval_reserve_backlog_sum :=l_reval_reserve_backlog+l_reval_reserve_backlog_sum;
1788: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_reval_reserve_backlog_sum: '||l_reval_reserve_backlog_sum);
1789: l_operating_acct_backlog_sum :=l_operating_acct_backlog+l_operating_acct_backlog_sum;
1790: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_operating_acct_backlog_sum: '||l_operating_acct_backlog_sum);
1791: l_general_fund_per_sum :=l_general_fund_per+l_general_fund_per_sum;
1792: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_general_fund_per_sum: '||l_general_fund_per_sum);

Line 1790: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_operating_acct_backlog_sum: '||l_operating_acct_backlog_sum);

1786: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_general_fund_per_sum: '||l_general_fund_per_sum);
1787: l_reval_reserve_backlog_sum :=l_reval_reserve_backlog+l_reval_reserve_backlog_sum;
1788: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_reval_reserve_backlog_sum: '||l_reval_reserve_backlog_sum);
1789: l_operating_acct_backlog_sum :=l_operating_acct_backlog+l_operating_acct_backlog_sum;
1790: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_operating_acct_backlog_sum: '||l_operating_acct_backlog_sum);
1791: l_general_fund_per_sum :=l_general_fund_per+l_general_fund_per_sum;
1792: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_general_fund_per_sum: '||l_general_fund_per_sum);
1793: l_fa_deprn_period_sum := l_fa_deprn_period_sum + l_fa_deprn_period;
1794: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_fa_deprn_period_sum: '||l_fa_deprn_period_sum);

Line 1792: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_general_fund_per_sum: '||l_general_fund_per_sum);

1788: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_reval_reserve_backlog_sum: '||l_reval_reserve_backlog_sum);
1789: l_operating_acct_backlog_sum :=l_operating_acct_backlog+l_operating_acct_backlog_sum;
1790: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_operating_acct_backlog_sum: '||l_operating_acct_backlog_sum);
1791: l_general_fund_per_sum :=l_general_fund_per+l_general_fund_per_sum;
1792: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_general_fund_per_sum: '||l_general_fund_per_sum);
1793: l_fa_deprn_period_sum := l_fa_deprn_period_sum + l_fa_deprn_period;
1794: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_fa_deprn_period_sum: '||l_fa_deprn_period_sum);
1795: l_fa_deprn_reserve_sum := l_fa_deprn_reserve_sum + l_fa_deprn_reserve;
1796: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_fa_deprn_reserve_sum: '||l_fa_deprn_reserve_sum);

Line 1794: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_fa_deprn_period_sum: '||l_fa_deprn_period_sum);

1790: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_operating_acct_backlog_sum: '||l_operating_acct_backlog_sum);
1791: l_general_fund_per_sum :=l_general_fund_per+l_general_fund_per_sum;
1792: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_general_fund_per_sum: '||l_general_fund_per_sum);
1793: l_fa_deprn_period_sum := l_fa_deprn_period_sum + l_fa_deprn_period;
1794: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_fa_deprn_period_sum: '||l_fa_deprn_period_sum);
1795: l_fa_deprn_reserve_sum := l_fa_deprn_reserve_sum + l_fa_deprn_reserve;
1796: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_fa_deprn_reserve_sum: '||l_fa_deprn_reserve_sum);
1797: l_fa_deprn_ytd_sum := l_fa_deprn_ytd_sum + l_fa_deprn_ytd;
1798: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_fa_deprn_ytd_sum: '||l_fa_deprn_ytd_sum);

Line 1796: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_fa_deprn_reserve_sum: '||l_fa_deprn_reserve_sum);

1792: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_general_fund_per_sum: '||l_general_fund_per_sum);
1793: l_fa_deprn_period_sum := l_fa_deprn_period_sum + l_fa_deprn_period;
1794: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_fa_deprn_period_sum: '||l_fa_deprn_period_sum);
1795: l_fa_deprn_reserve_sum := l_fa_deprn_reserve_sum + l_fa_deprn_reserve;
1796: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_fa_deprn_reserve_sum: '||l_fa_deprn_reserve_sum);
1797: l_fa_deprn_ytd_sum := l_fa_deprn_ytd_sum + l_fa_deprn_ytd;
1798: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_fa_deprn_ytd_sum: '||l_fa_deprn_ytd_sum);
1799:
1800: -- add rounding diff to the last distribution

Line 1798: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_fa_deprn_ytd_sum: '||l_fa_deprn_ytd_sum);

1794: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_fa_deprn_period_sum: '||l_fa_deprn_period_sum);
1795: l_fa_deprn_reserve_sum := l_fa_deprn_reserve_sum + l_fa_deprn_reserve;
1796: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_fa_deprn_reserve_sum: '||l_fa_deprn_reserve_sum);
1797: l_fa_deprn_ytd_sum := l_fa_deprn_ytd_sum + l_fa_deprn_ytd;
1798: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_fa_deprn_ytd_sum: '||l_fa_deprn_ytd_sum);
1799:
1800: -- add rounding diff to the last distribution
1801: IF (i = l_no_of_imp.counter) THEN
1802: l_reval_reserve:= l_reval_reserve +

Line 1804: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_reval_reserve: '||l_reval_reserve);

1800: -- add rounding diff to the last distribution
1801: IF (i = l_no_of_imp.counter) THEN
1802: l_reval_reserve:= l_reval_reserve +
1803: (l_ab_amounts.reval_reserve - l_reval_reserve_sum);
1804: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_reval_reserve: '||l_reval_reserve);
1805: l_general_fund:=l_general_fund +
1806: (l_ab_amounts.general_fund -l_general_fund_sum);
1807: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_general_fund: '||l_general_fund);
1808: l_Backlog_deprn_reserve:=l_backlog_deprn_reserve +

Line 1807: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_general_fund: '||l_general_fund);

1803: (l_ab_amounts.reval_reserve - l_reval_reserve_sum);
1804: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_reval_reserve: '||l_reval_reserve);
1805: l_general_fund:=l_general_fund +
1806: (l_ab_amounts.general_fund -l_general_fund_sum);
1807: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_general_fund: '||l_general_fund);
1808: l_Backlog_deprn_reserve:=l_backlog_deprn_reserve +
1809: (l_ab_amounts.backlog_deprn_reserve-l_Backlog_deprn_reserve_sum);
1810: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_Backlog_deprn_reserve: '||l_Backlog_deprn_reserve);
1811: l_deprn_reserve:=l_deprn_reserve +

Line 1810: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_Backlog_deprn_reserve: '||l_Backlog_deprn_reserve);

1806: (l_ab_amounts.general_fund -l_general_fund_sum);
1807: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_general_fund: '||l_general_fund);
1808: l_Backlog_deprn_reserve:=l_backlog_deprn_reserve +
1809: (l_ab_amounts.backlog_deprn_reserve-l_Backlog_deprn_reserve_sum);
1810: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_Backlog_deprn_reserve: '||l_Backlog_deprn_reserve);
1811: l_deprn_reserve:=l_deprn_reserve +
1812: (l_ab_amounts.deprn_reserve -l_deprn_reserve_sum);
1813: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_deprn_reserve: '||l_deprn_reserve);
1814: l_adjusted_cost:=l_adjusted_cost + (l_ab_amounts.adjusted_cost -l_adjusted_cost_sum);

Line 1813: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_deprn_reserve: '||l_deprn_reserve);

1809: (l_ab_amounts.backlog_deprn_reserve-l_Backlog_deprn_reserve_sum);
1810: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_Backlog_deprn_reserve: '||l_Backlog_deprn_reserve);
1811: l_deprn_reserve:=l_deprn_reserve +
1812: (l_ab_amounts.deprn_reserve -l_deprn_reserve_sum);
1813: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_deprn_reserve: '||l_deprn_reserve);
1814: l_adjusted_cost:=l_adjusted_cost + (l_ab_amounts.adjusted_cost -l_adjusted_cost_sum);
1815: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_adjusted_cost: '||l_adjusted_cost);
1816: l_net_book_value:=l_net_book_value +
1817: (l_ab_amounts.net_book_value -l_net_book_value_sum);

Line 1815: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_adjusted_cost: '||l_adjusted_cost);

1811: l_deprn_reserve:=l_deprn_reserve +
1812: (l_ab_amounts.deprn_reserve -l_deprn_reserve_sum);
1813: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_deprn_reserve: '||l_deprn_reserve);
1814: l_adjusted_cost:=l_adjusted_cost + (l_ab_amounts.adjusted_cost -l_adjusted_cost_sum);
1815: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_adjusted_cost: '||l_adjusted_cost);
1816: l_net_book_value:=l_net_book_value +
1817: (l_ab_amounts.net_book_value -l_net_book_value_sum);
1818: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_net_book_value: '||l_net_book_value);
1819: l_deprn_per:=l_deprn_per +

Line 1818: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_net_book_value: '||l_net_book_value);

1814: l_adjusted_cost:=l_adjusted_cost + (l_ab_amounts.adjusted_cost -l_adjusted_cost_sum);
1815: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_adjusted_cost: '||l_adjusted_cost);
1816: l_net_book_value:=l_net_book_value +
1817: (l_ab_amounts.net_book_value -l_net_book_value_sum);
1818: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_net_book_value: '||l_net_book_value);
1819: l_deprn_per:=l_deprn_per +
1820: (l_ab_amounts.deprn_amount -l_deprn_per_sum);
1821: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_deprn_per: '||l_deprn_per);
1822: l_op_acct:=l_op_acct +

Line 1821: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_deprn_per: '||l_deprn_per);

1817: (l_ab_amounts.net_book_value -l_net_book_value_sum);
1818: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_net_book_value: '||l_net_book_value);
1819: l_deprn_per:=l_deprn_per +
1820: (l_ab_amounts.deprn_amount -l_deprn_per_sum);
1821: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_deprn_per: '||l_deprn_per);
1822: l_op_acct:=l_op_acct +
1823: (l_ab_amounts.operating_acct -l_op_acct_sum);
1824: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_op_acct: '||l_op_acct);
1825: l_reval_reserve_backlog:=l_reval_reserve_backlog +

Line 1824: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_op_acct: '||l_op_acct);

1820: (l_ab_amounts.deprn_amount -l_deprn_per_sum);
1821: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_deprn_per: '||l_deprn_per);
1822: l_op_acct:=l_op_acct +
1823: (l_ab_amounts.operating_acct -l_op_acct_sum);
1824: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_op_acct: '||l_op_acct);
1825: l_reval_reserve_backlog:=l_reval_reserve_backlog +
1826: (l_ab_amounts.reval_reserve_backlog -l_reval_reserve_backlog_sum);
1827: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_reval_reserve_backlog: '||l_reval_reserve_backlog);
1828: l_operating_acct_backlog:=l_operating_acct_backlog +

Line 1827: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_reval_reserve_backlog: '||l_reval_reserve_backlog);

1823: (l_ab_amounts.operating_acct -l_op_acct_sum);
1824: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_op_acct: '||l_op_acct);
1825: l_reval_reserve_backlog:=l_reval_reserve_backlog +
1826: (l_ab_amounts.reval_reserve_backlog -l_reval_reserve_backlog_sum);
1827: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_reval_reserve_backlog: '||l_reval_reserve_backlog);
1828: l_operating_acct_backlog:=l_operating_acct_backlog +
1829: (l_ab_amounts.operating_acct_backlog -l_operating_acct_backlog_sum);
1830: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_operating_acct_backlog: '||l_operating_acct_backlog);
1831: l_general_fund_per:=l_general_fund_per +

Line 1830: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_operating_acct_backlog: '||l_operating_acct_backlog);

1826: (l_ab_amounts.reval_reserve_backlog -l_reval_reserve_backlog_sum);
1827: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_reval_reserve_backlog: '||l_reval_reserve_backlog);
1828: l_operating_acct_backlog:=l_operating_acct_backlog +
1829: (l_ab_amounts.operating_acct_backlog -l_operating_acct_backlog_sum);
1830: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_operating_acct_backlog: '||l_operating_acct_backlog);
1831: l_general_fund_per:=l_general_fund_per +
1832: (l_ab_amounts.general_fund_per -l_general_fund_per_sum);
1833: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_general_fund_per: '||l_general_fund_per);
1834: l_ytd_deprn:=l_ytd_deprn +

Line 1833: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_general_fund_per: '||l_general_fund_per);

1829: (l_ab_amounts.operating_acct_backlog -l_operating_acct_backlog_sum);
1830: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_operating_acct_backlog: '||l_operating_acct_backlog);
1831: l_general_fund_per:=l_general_fund_per +
1832: (l_ab_amounts.general_fund_per -l_general_fund_per_sum);
1833: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_general_fund_per: '||l_general_fund_per);
1834: l_ytd_deprn:=l_ytd_deprn +
1835: (l_ab_amounts.ytd_deprn -l_ytd_deprn_sum);
1836: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_ytd_deprn: '||l_ytd_deprn);
1837: l_fa_deprn_period :=l_fa_deprn_period +

Line 1836: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_ytd_deprn: '||l_ytd_deprn);

1832: (l_ab_amounts.general_fund_per -l_general_fund_per_sum);
1833: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_general_fund_per: '||l_general_fund_per);
1834: l_ytd_deprn:=l_ytd_deprn +
1835: (l_ab_amounts.ytd_deprn -l_ytd_deprn_sum);
1836: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_ytd_deprn: '||l_ytd_deprn);
1837: l_fa_deprn_period :=l_fa_deprn_period +
1838: (l_iac_fa_dep_amounts.deprn_period -l_fa_deprn_period_sum);
1839: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_fa_deprn_period: '||l_fa_deprn_period);
1840: l_fa_deprn_reserve :=l_fa_deprn_reserve +

Line 1839: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_fa_deprn_period: '||l_fa_deprn_period);

1835: (l_ab_amounts.ytd_deprn -l_ytd_deprn_sum);
1836: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_ytd_deprn: '||l_ytd_deprn);
1837: l_fa_deprn_period :=l_fa_deprn_period +
1838: (l_iac_fa_dep_amounts.deprn_period -l_fa_deprn_period_sum);
1839: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_fa_deprn_period: '||l_fa_deprn_period);
1840: l_fa_deprn_reserve :=l_fa_deprn_reserve +
1841: (l_iac_fa_dep_amounts.deprn_reserve -l_fa_deprn_reserve_sum);
1842: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_fa_deprn_reserve: '||l_fa_deprn_reserve);
1843: l_fa_deprn_ytd :=l_fa_deprn_ytd +

Line 1842: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_fa_deprn_reserve: '||l_fa_deprn_reserve);

1838: (l_iac_fa_dep_amounts.deprn_period -l_fa_deprn_period_sum);
1839: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_fa_deprn_period: '||l_fa_deprn_period);
1840: l_fa_deprn_reserve :=l_fa_deprn_reserve +
1841: (l_iac_fa_dep_amounts.deprn_reserve -l_fa_deprn_reserve_sum);
1842: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_fa_deprn_reserve: '||l_fa_deprn_reserve);
1843: l_fa_deprn_ytd :=l_fa_deprn_ytd +
1844: (l_iac_fa_dep_amounts.deprn_ytd -l_fa_deprn_ytd_sum);
1845: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_fa_deprn_ytd: '||l_fa_deprn_ytd);
1846: END IF;

Line 1845: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_fa_deprn_ytd: '||l_fa_deprn_ytd);

1841: (l_iac_fa_dep_amounts.deprn_reserve -l_fa_deprn_reserve_sum);
1842: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_fa_deprn_reserve: '||l_fa_deprn_reserve);
1843: l_fa_deprn_ytd :=l_fa_deprn_ytd +
1844: (l_iac_fa_dep_amounts.deprn_ytd -l_fa_deprn_ytd_sum);
1845: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_fa_deprn_ytd: '||l_fa_deprn_ytd);
1846: END IF;
1847: END IF; -- active dist rounding
1848:
1849: -- catchup roundings

Line 1853: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_deprn_expense_old_sum: '||l_deprn_expense_old_sum);

1849: -- catchup roundings
1850: IF g_prior_period THEN
1851: IF (l_all_dist.distribution_id = l_old_dist) THEN
1852: l_deprn_expense_old_sum:=l_deprn_expense+l_deprn_expense_old_sum;
1853: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_deprn_expense_old_sum: '||l_deprn_expense_old_sum);
1854: l_dist_op_exp_old_sum:= l_dist_op_exp_old_sum + l_dist_op_exp;
1855: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_dist_op_exp_old_sum: '||l_dist_op_exp_old_sum);
1856: l_fa_deprn_expense_old_sum:=l_fa_deprn_expense + l_fa_deprn_expense_old_sum;
1857: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_fa_deprn_expense_old_sum: '||l_fa_deprn_expense_old_sum);

Line 1855: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_dist_op_exp_old_sum: '||l_dist_op_exp_old_sum);

1851: IF (l_all_dist.distribution_id = l_old_dist) THEN
1852: l_deprn_expense_old_sum:=l_deprn_expense+l_deprn_expense_old_sum;
1853: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_deprn_expense_old_sum: '||l_deprn_expense_old_sum);
1854: l_dist_op_exp_old_sum:= l_dist_op_exp_old_sum + l_dist_op_exp;
1855: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_dist_op_exp_old_sum: '||l_dist_op_exp_old_sum);
1856: l_fa_deprn_expense_old_sum:=l_fa_deprn_expense + l_fa_deprn_expense_old_sum;
1857: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_fa_deprn_expense_old_sum: '||l_fa_deprn_expense_old_sum);
1858: IF (inact_cnt = l_no_of_inactive) THEN
1859: l_deprn_expense := l_deprn_expense +

Line 1857: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_fa_deprn_expense_old_sum: '||l_fa_deprn_expense_old_sum);

1853: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_deprn_expense_old_sum: '||l_deprn_expense_old_sum);
1854: l_dist_op_exp_old_sum:= l_dist_op_exp_old_sum + l_dist_op_exp;
1855: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_dist_op_exp_old_sum: '||l_dist_op_exp_old_sum);
1856: l_fa_deprn_expense_old_sum:=l_fa_deprn_expense + l_fa_deprn_expense_old_sum;
1857: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_fa_deprn_expense_old_sum: '||l_fa_deprn_expense_old_sum);
1858: IF (inact_cnt = l_no_of_inactive) THEN
1859: l_deprn_expense := l_deprn_expense +
1860: (l_ab_amounts.dep_expense_catchup - l_deprn_expense_old_sum);
1861: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_deprn_expense: '||l_deprn_expense);

Line 1861: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_deprn_expense: '||l_deprn_expense);

1857: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_fa_deprn_expense_old_sum: '||l_fa_deprn_expense_old_sum);
1858: IF (inact_cnt = l_no_of_inactive) THEN
1859: l_deprn_expense := l_deprn_expense +
1860: (l_ab_amounts.dep_expense_catchup - l_deprn_expense_old_sum);
1861: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_deprn_expense: '||l_deprn_expense);
1862: l_dist_op_exp := l_dist_op_exp +
1863: (l_ab_amounts.op_expense_catchup - l_dist_op_exp_old_sum);
1864: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_dist_op_exp: '||l_dist_op_exp);
1865: l_fa_deprn_expense := l_fa_deprn_expense +

Line 1864: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_dist_op_exp: '||l_dist_op_exp);

1860: (l_ab_amounts.dep_expense_catchup - l_deprn_expense_old_sum);
1861: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_deprn_expense: '||l_deprn_expense);
1862: l_dist_op_exp := l_dist_op_exp +
1863: (l_ab_amounts.op_expense_catchup - l_dist_op_exp_old_sum);
1864: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_dist_op_exp: '||l_dist_op_exp);
1865: l_fa_deprn_expense := l_fa_deprn_expense +
1866: (l_iac_fa_dep_amounts.dep_expense_catchup - l_fa_deprn_expense_old_sum);
1867: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_fa_deprn_expense: '||l_fa_deprn_expense);
1868: END IF;

Line 1867: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_fa_deprn_expense: '||l_fa_deprn_expense);

1863: (l_ab_amounts.op_expense_catchup - l_dist_op_exp_old_sum);
1864: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_dist_op_exp: '||l_dist_op_exp);
1865: l_fa_deprn_expense := l_fa_deprn_expense +
1866: (l_iac_fa_dep_amounts.dep_expense_catchup - l_fa_deprn_expense_old_sum);
1867: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_fa_deprn_expense: '||l_fa_deprn_expense);
1868: END IF;
1869: ELSIF (l_all_dist.distribution_id = l_impacted_dist) THEN
1870: l_deprn_expense_imp_sum:=l_deprn_expense+l_deprn_expense_imp_sum;
1871: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_deprn_expense_imp_sum: '||l_deprn_expense_imp_sum);

Line 1871: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_deprn_expense_imp_sum: '||l_deprn_expense_imp_sum);

1867: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_fa_deprn_expense: '||l_fa_deprn_expense);
1868: END IF;
1869: ELSIF (l_all_dist.distribution_id = l_impacted_dist) THEN
1870: l_deprn_expense_imp_sum:=l_deprn_expense+l_deprn_expense_imp_sum;
1871: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_deprn_expense_imp_sum: '||l_deprn_expense_imp_sum);
1872: l_dist_op_exp_imp_sum:= l_dist_op_exp_imp_sum + l_dist_op_exp;
1873: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_dist_op_exp_imp_sum: '||l_dist_op_exp_imp_sum);
1874: l_fa_deprn_expense_imp_sum:=l_fa_deprn_expense + l_fa_deprn_expense_imp_sum;
1875: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_fa_deprn_expense_imp_sum: '||l_fa_deprn_expense_imp_sum);

Line 1873: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_dist_op_exp_imp_sum: '||l_dist_op_exp_imp_sum);

1869: ELSIF (l_all_dist.distribution_id = l_impacted_dist) THEN
1870: l_deprn_expense_imp_sum:=l_deprn_expense+l_deprn_expense_imp_sum;
1871: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_deprn_expense_imp_sum: '||l_deprn_expense_imp_sum);
1872: l_dist_op_exp_imp_sum:= l_dist_op_exp_imp_sum + l_dist_op_exp;
1873: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_dist_op_exp_imp_sum: '||l_dist_op_exp_imp_sum);
1874: l_fa_deprn_expense_imp_sum:=l_fa_deprn_expense + l_fa_deprn_expense_imp_sum;
1875: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_fa_deprn_expense_imp_sum: '||l_fa_deprn_expense_imp_sum);
1876: IF (act_cnt = l_no_of_active) THEN
1877: l_deprn_expense := l_deprn_expense +

Line 1875: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_fa_deprn_expense_imp_sum: '||l_fa_deprn_expense_imp_sum);

1871: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_deprn_expense_imp_sum: '||l_deprn_expense_imp_sum);
1872: l_dist_op_exp_imp_sum:= l_dist_op_exp_imp_sum + l_dist_op_exp;
1873: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_dist_op_exp_imp_sum: '||l_dist_op_exp_imp_sum);
1874: l_fa_deprn_expense_imp_sum:=l_fa_deprn_expense + l_fa_deprn_expense_imp_sum;
1875: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_fa_deprn_expense_imp_sum: '||l_fa_deprn_expense_imp_sum);
1876: IF (act_cnt = l_no_of_active) THEN
1877: l_deprn_expense := l_deprn_expense +
1878: (l_ab_amounts.dep_expense_catchup - l_deprn_expense_imp_sum);
1879: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_deprn_expense: '||l_deprn_expense);

Line 1879: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_deprn_expense: '||l_deprn_expense);

1875: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_fa_deprn_expense_imp_sum: '||l_fa_deprn_expense_imp_sum);
1876: IF (act_cnt = l_no_of_active) THEN
1877: l_deprn_expense := l_deprn_expense +
1878: (l_ab_amounts.dep_expense_catchup - l_deprn_expense_imp_sum);
1879: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_deprn_expense: '||l_deprn_expense);
1880: l_dist_op_exp := l_dist_op_exp +
1881: (l_ab_amounts.op_expense_catchup - l_dist_op_exp_imp_sum);
1882: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_dist_op_exp: '||l_dist_op_exp);
1883: l_fa_deprn_expense := l_fa_deprn_expense +

Line 1882: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_dist_op_exp: '||l_dist_op_exp);

1878: (l_ab_amounts.dep_expense_catchup - l_deprn_expense_imp_sum);
1879: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_deprn_expense: '||l_deprn_expense);
1880: l_dist_op_exp := l_dist_op_exp +
1881: (l_ab_amounts.op_expense_catchup - l_dist_op_exp_imp_sum);
1882: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_dist_op_exp: '||l_dist_op_exp);
1883: l_fa_deprn_expense := l_fa_deprn_expense +
1884: (l_iac_fa_dep_amounts.dep_expense_catchup - l_fa_deprn_expense_imp_sum);
1885: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_fa_deprn_expense: '||l_fa_deprn_expense);
1886: END IF;

Line 1885: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_fa_deprn_expense: '||l_fa_deprn_expense);

1881: (l_ab_amounts.op_expense_catchup - l_dist_op_exp_imp_sum);
1882: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_dist_op_exp: '||l_dist_op_exp);
1883: l_fa_deprn_expense := l_fa_deprn_expense +
1884: (l_iac_fa_dep_amounts.dep_expense_catchup - l_fa_deprn_expense_imp_sum);
1885: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_fa_deprn_expense: '||l_fa_deprn_expense);
1886: END IF;
1887: END IF;
1888: ELSE
1889: l_deprn_expense := 0;

Line 1890: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_deprn_expense: '||l_deprn_expense);

1886: END IF;
1887: END IF;
1888: ELSE
1889: l_deprn_expense := 0;
1890: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_deprn_expense: '||l_deprn_expense);
1891: l_dist_op_exp := 0;
1892: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_dist_op_exp: '||l_dist_op_exp);
1893: l_fa_deprn_expense := 0;
1894: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_fa_deprn_expense: '||l_fa_deprn_expense);

Line 1892: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_dist_op_exp: '||l_dist_op_exp);

1888: ELSE
1889: l_deprn_expense := 0;
1890: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_deprn_expense: '||l_deprn_expense);
1891: l_dist_op_exp := 0;
1892: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_dist_op_exp: '||l_dist_op_exp);
1893: l_fa_deprn_expense := 0;
1894: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_fa_deprn_expense: '||l_fa_deprn_expense);
1895: END IF; -- catchup roundings end
1896:

Line 1894: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_fa_deprn_expense: '||l_fa_deprn_expense);

1890: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_deprn_expense: '||l_deprn_expense);
1891: l_dist_op_exp := 0;
1892: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_dist_op_exp: '||l_dist_op_exp);
1893: l_fa_deprn_expense := 0;
1894: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_fa_deprn_expense: '||l_fa_deprn_expense);
1895: END IF; -- catchup roundings end
1896:
1897: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Amounts after rounding for dist id: '||l_all_dist.distribution_id);
1898: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Adjusted Cost :'||l_adjusted_cost);

Line 1897: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Amounts after rounding for dist id: '||l_all_dist.distribution_id);

1893: l_fa_deprn_expense := 0;
1894: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_fa_deprn_expense: '||l_fa_deprn_expense);
1895: END IF; -- catchup roundings end
1896:
1897: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Amounts after rounding for dist id: '||l_all_dist.distribution_id);
1898: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Adjusted Cost :'||l_adjusted_cost);
1899: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Net Book Value :'||l_net_book_value);
1900: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Reval Reserve :'||l_reval_reserve);
1901: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'General Fund :'||l_general_fund);

Line 1898: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Adjusted Cost :'||l_adjusted_cost);

1894: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_fa_deprn_expense: '||l_fa_deprn_expense);
1895: END IF; -- catchup roundings end
1896:
1897: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Amounts after rounding for dist id: '||l_all_dist.distribution_id);
1898: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Adjusted Cost :'||l_adjusted_cost);
1899: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Net Book Value :'||l_net_book_value);
1900: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Reval Reserve :'||l_reval_reserve);
1901: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'General Fund :'||l_general_fund);
1902: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Reval Reserve Backlog :'||l_reval_reserve_backlog);

Line 1899: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Net Book Value :'||l_net_book_value);

1895: END IF; -- catchup roundings end
1896:
1897: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Amounts after rounding for dist id: '||l_all_dist.distribution_id);
1898: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Adjusted Cost :'||l_adjusted_cost);
1899: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Net Book Value :'||l_net_book_value);
1900: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Reval Reserve :'||l_reval_reserve);
1901: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'General Fund :'||l_general_fund);
1902: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Reval Reserve Backlog :'||l_reval_reserve_backlog);
1903: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Operating Account :'||l_op_acct);

Line 1900: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Reval Reserve :'||l_reval_reserve);

1896:
1897: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Amounts after rounding for dist id: '||l_all_dist.distribution_id);
1898: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Adjusted Cost :'||l_adjusted_cost);
1899: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Net Book Value :'||l_net_book_value);
1900: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Reval Reserve :'||l_reval_reserve);
1901: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'General Fund :'||l_general_fund);
1902: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Reval Reserve Backlog :'||l_reval_reserve_backlog);
1903: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Operating Account :'||l_op_acct);
1904: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Deprn Reserve :'||l_deprn_reserve);

Line 1901: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'General Fund :'||l_general_fund);

1897: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Amounts after rounding for dist id: '||l_all_dist.distribution_id);
1898: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Adjusted Cost :'||l_adjusted_cost);
1899: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Net Book Value :'||l_net_book_value);
1900: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Reval Reserve :'||l_reval_reserve);
1901: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'General Fund :'||l_general_fund);
1902: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Reval Reserve Backlog :'||l_reval_reserve_backlog);
1903: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Operating Account :'||l_op_acct);
1904: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Deprn Reserve :'||l_deprn_reserve);
1905: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Backlog Deprn Reserce :'||l_backlog_deprn_reserve);

Line 1902: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Reval Reserve Backlog :'||l_reval_reserve_backlog);

1898: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Adjusted Cost :'||l_adjusted_cost);
1899: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Net Book Value :'||l_net_book_value);
1900: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Reval Reserve :'||l_reval_reserve);
1901: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'General Fund :'||l_general_fund);
1902: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Reval Reserve Backlog :'||l_reval_reserve_backlog);
1903: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Operating Account :'||l_op_acct);
1904: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Deprn Reserve :'||l_deprn_reserve);
1905: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Backlog Deprn Reserce :'||l_backlog_deprn_reserve);
1906: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Deprn Reserve :'||l_deprn_reserve);

Line 1903: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Operating Account :'||l_op_acct);

1899: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Net Book Value :'||l_net_book_value);
1900: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Reval Reserve :'||l_reval_reserve);
1901: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'General Fund :'||l_general_fund);
1902: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Reval Reserve Backlog :'||l_reval_reserve_backlog);
1903: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Operating Account :'||l_op_acct);
1904: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Deprn Reserve :'||l_deprn_reserve);
1905: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Backlog Deprn Reserce :'||l_backlog_deprn_reserve);
1906: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Deprn Reserve :'||l_deprn_reserve);
1907: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'YTD Deprn :'||l_ytd_deprn);

Line 1904: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Deprn Reserve :'||l_deprn_reserve);

1900: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Reval Reserve :'||l_reval_reserve);
1901: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'General Fund :'||l_general_fund);
1902: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Reval Reserve Backlog :'||l_reval_reserve_backlog);
1903: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Operating Account :'||l_op_acct);
1904: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Deprn Reserve :'||l_deprn_reserve);
1905: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Backlog Deprn Reserce :'||l_backlog_deprn_reserve);
1906: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Deprn Reserve :'||l_deprn_reserve);
1907: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'YTD Deprn :'||l_ytd_deprn);
1908: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Generl Fund :'||l_general_fund);

Line 1905: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Backlog Deprn Reserce :'||l_backlog_deprn_reserve);

1901: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'General Fund :'||l_general_fund);
1902: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Reval Reserve Backlog :'||l_reval_reserve_backlog);
1903: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Operating Account :'||l_op_acct);
1904: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Deprn Reserve :'||l_deprn_reserve);
1905: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Backlog Deprn Reserce :'||l_backlog_deprn_reserve);
1906: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Deprn Reserve :'||l_deprn_reserve);
1907: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'YTD Deprn :'||l_ytd_deprn);
1908: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Generl Fund :'||l_general_fund);
1909:

Line 1906: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Deprn Reserve :'||l_deprn_reserve);

1902: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Reval Reserve Backlog :'||l_reval_reserve_backlog);
1903: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Operating Account :'||l_op_acct);
1904: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Deprn Reserve :'||l_deprn_reserve);
1905: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Backlog Deprn Reserce :'||l_backlog_deprn_reserve);
1906: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Deprn Reserve :'||l_deprn_reserve);
1907: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'YTD Deprn :'||l_ytd_deprn);
1908: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Generl Fund :'||l_general_fund);
1909:
1910: -- create the catchup accounting entries

Line 1907: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'YTD Deprn :'||l_ytd_deprn);

1903: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Operating Account :'||l_op_acct);
1904: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Deprn Reserve :'||l_deprn_reserve);
1905: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Backlog Deprn Reserce :'||l_backlog_deprn_reserve);
1906: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Deprn Reserve :'||l_deprn_reserve);
1907: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'YTD Deprn :'||l_ytd_deprn);
1908: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Generl Fund :'||l_general_fund);
1909:
1910: -- create the catchup accounting entries
1911: IF g_prior_period THEN

Line 1908: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Generl Fund :'||l_general_fund);

1904: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Deprn Reserve :'||l_deprn_reserve);
1905: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Backlog Deprn Reserce :'||l_backlog_deprn_reserve);
1906: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Deprn Reserve :'||l_deprn_reserve);
1907: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'YTD Deprn :'||l_ytd_deprn);
1908: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Generl Fund :'||l_general_fund);
1909:
1910: -- create the catchup accounting entries
1911: IF g_prior_period THEN
1912: -- create the accounting entries for prior period

Line 2206: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Data inserted into adjustments for various accounts');

2202: p_event_id => p_event_id
2203: );
2204: END IF; --end of if impacted loop
2205:
2206: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Data inserted into adjustments for various accounts');
2207: -- Check if it the transfer is inter company
2208: l_interco_amount := 0;
2209: l_interco_count := 0;
2210: OPEN c_get_interco(p_asset_hdr_rec.book_type_code,

Line 2452: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Data inserted into detail balances');

2448: x_mode => 'R');
2449:
2450: END IF;
2451: -- End of loop for insert into det_balances table
2452: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Data inserted into detail balances');
2453: END LOOP;
2454: -- End of loop for all active distributions
2455: -- Roll the inactive distributions forward for the new adjustment id
2456: Roll_Inactive_Forward(p_adjustment_id => l_prev_adjustment_id,

Line 2469: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_exists = true');

2465: , cp_book_type_code => p_asset_hdr_rec.book_type_code
2466: )
2467: loop
2468: l_exists := true;
2469: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_exists = true');
2470: end loop;
2471: -- update asset balances table with transfer info
2472: IF l_ab_amounts.period_counter = l_current_period_counter THEN
2473: -- this is a current period transfer

Line 2499: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Data Updated in Asset balances for the catch up');

2495: x_cumulative_reval_factor =>l_ab_amounts.cumulative_reval_factor,
2496: x_mode =>'R'
2497: );
2498:
2499: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Data Updated in Asset balances for the catch up');
2500: END IF;
2501:
2502: ELSE
2503: -- this is a prior period transfer

Line 2554: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Data Inserted in Asset balances');

2550: x_current_reval_factor =>l_ab_amounts.current_reval_factor,
2551: x_cumulative_reval_factor =>l_ab_amounts.cumulative_reval_factor,
2552: x_mode =>'R'
2553: );
2554: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Data Inserted in Asset balances');
2555: END IF;
2556: END IF;
2557:
2558: -- update the previous active row for the asset in igi_iac_transaction_headers

Line 2593: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'This asset has not been revalued');

2589: Calling_FN => 'IGI_IAC_TRANSFER_PKG.Do_Transfer',
2590: Name => 'IGI_IAC_ASSET_NOT_REVALUED',
2591: TOKEN1 => 'ASSET_NUM',
2592: VALUE1 => l_asset_num);
2593: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'This asset has not been revalued');
2594:
2595: RETURN(TRUE);
2596:
2597: WHEN e_no_gl_info THEN

Line 2599: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,

2595: RETURN(TRUE);
2596:
2597: WHEN e_no_gl_info THEN
2598:
2599: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,
2600: p_full_path => l_path,
2601: p_string => 'Could not retrive GL information for Book');
2602:
2603: FA_SRVR_MSG.add_message(

Line 2615: igi_iac_debug_pkg.debug_unexpected_msg(l_path);

2611: RETURN(FALSE); -- Ensures that data is rolled back;calling procedure rolls back on error, no need of rollback here
2612:
2613: WHEN others THEN
2614: l_mesg:=SQLERRM;
2615: igi_iac_debug_pkg.debug_unexpected_msg(l_path);
2616: FA_SRVR_MSG.Add_Message(
2617: Calling_FN => 'IGI_IAC_TRANSFER_PKG.Do_Transfer',
2618: Name => 'IGI_IAC_EXCEPTION',
2619: TOKEN1 => 'PACKAGE',

Line 2698: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'============================================================');

2694: l_asset_hdr_rec.set_of_books_id:=l_asset_data.set_of_books_id;
2695:
2696: l_asset_cat_rec.category_id:=p_category_id;
2697:
2698: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'============================================================');
2699: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Start Of Prior Period Processing');
2700: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'============================================================');
2701: /* Call the Do_Transfer process to insert data for current open period */
2702: IF NOT(Do_transfer(l_trans_rec,

Line 2699: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Start Of Prior Period Processing');

2695:
2696: l_asset_cat_rec.category_id:=p_category_id;
2697:
2698: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'============================================================');
2699: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Start Of Prior Period Processing');
2700: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'============================================================');
2701: /* Call the Do_Transfer process to insert data for current open period */
2702: IF NOT(Do_transfer(l_trans_rec,
2703: l_asset_hdr_rec,

Line 2700: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'============================================================');

2696: l_asset_cat_rec.category_id:=p_category_id;
2697:
2698: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'============================================================');
2699: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Start Of Prior Period Processing');
2700: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'============================================================');
2701: /* Call the Do_Transfer process to insert data for current open period */
2702: IF NOT(Do_transfer(l_trans_rec,
2703: l_asset_hdr_rec,
2704: l_asset_cat_rec,

Line 2725: igi_iac_debug_pkg.debug_unexpected_msg(l_path);

2721: VALUE1 => 'Transfers',
2722: TOKEN2 => 'ERROR_MESSAGE',
2723: VALUE2 => l_mesg);
2724:
2725: igi_iac_debug_pkg.debug_unexpected_msg(l_path);
2726: RETURN(FALSE);
2727:
2728: END Do_prior_transfer;
2729:

Line 2810: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'*****************************************************************');

2806: BEGIN
2807:
2808: l_path := g_path||'Do_Rollback_Deprn';
2809:
2810: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'*****************************************************************');
2811: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Rollback of Transactions ');
2812: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'*****************************************************************');
2813:
2814: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Processing For book '||p_book_type_code);

Line 2811: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Rollback of Transactions ');

2807:
2808: l_path := g_path||'Do_Rollback_Deprn';
2809:
2810: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'*****************************************************************');
2811: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Rollback of Transactions ');
2812: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'*****************************************************************');
2813:
2814: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Processing For book '||p_book_type_code);
2815: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Current Period Counter :'||p_period_counter);

Line 2812: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'*****************************************************************');

2808: l_path := g_path||'Do_Rollback_Deprn';
2809:
2810: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'*****************************************************************');
2811: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Rollback of Transactions ');
2812: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'*****************************************************************');
2813:
2814: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Processing For book '||p_book_type_code);
2815: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Current Period Counter :'||p_period_counter);
2816:

Line 2814: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Processing For book '||p_book_type_code);

2810: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'*****************************************************************');
2811: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Rollback of Transactions ');
2812: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'*****************************************************************');
2813:
2814: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Processing For book '||p_book_type_code);
2815: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Current Period Counter :'||p_period_counter);
2816:
2817:
2818: FOR l_trans_headers in c_trans_headers

Line 2815: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Current Period Counter :'||p_period_counter);

2811: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Rollback of Transactions ');
2812: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'*****************************************************************');
2813:
2814: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Processing For book '||p_book_type_code);
2815: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Current Period Counter :'||p_period_counter);
2816:
2817:
2818: FOR l_trans_headers in c_trans_headers
2819: LOOP

Line 2820: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Transaction header Id :'||l_trans_headers.transaction_header_id);

2816:
2817:
2818: FOR l_trans_headers in c_trans_headers
2819: LOOP
2820: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Transaction header Id :'||l_trans_headers.transaction_header_id);
2821: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Transaction Date Entered :'||l_trans_headers.transaction_date_entered);
2822: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Adjustment Id :'||l_trans_headers.adjustment_id);
2823: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Asset Id :'||l_trans_headers.asset_id);
2824:

Line 2821: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Transaction Date Entered :'||l_trans_headers.transaction_date_entered);

2817:
2818: FOR l_trans_headers in c_trans_headers
2819: LOOP
2820: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Transaction header Id :'||l_trans_headers.transaction_header_id);
2821: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Transaction Date Entered :'||l_trans_headers.transaction_date_entered);
2822: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Adjustment Id :'||l_trans_headers.adjustment_id);
2823: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Asset Id :'||l_trans_headers.asset_id);
2824:
2825:

Line 2822: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Adjustment Id :'||l_trans_headers.adjustment_id);

2818: FOR l_trans_headers in c_trans_headers
2819: LOOP
2820: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Transaction header Id :'||l_trans_headers.transaction_header_id);
2821: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Transaction Date Entered :'||l_trans_headers.transaction_date_entered);
2822: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Adjustment Id :'||l_trans_headers.adjustment_id);
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*/

Line 2823: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Asset Id :'||l_trans_headers.asset_id);

2819: LOOP
2820: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Transaction header Id :'||l_trans_headers.transaction_header_id);
2821: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Transaction Date Entered :'||l_trans_headers.transaction_date_entered);
2822: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Adjustment Id :'||l_trans_headers.adjustment_id);
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,

Line 2834: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Period counter :'||l_prior_period_counter);

2830: l_prior_period_counter:=l_prd_rec_prior.period_counter;
2831: END IF;
2832:
2833:
2834: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Period counter :'||l_prior_period_counter);
2835:
2836: IF l_prior_period_counter is not null AND (L_prior_period_counter< p_period_counter) THEN
2837:
2838: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Processing prior period data on this asset');

Line 2838: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Processing prior period data on this asset');

2834: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Period counter :'||l_prior_period_counter);
2835:
2836: IF l_prior_period_counter is not null AND (L_prior_period_counter< p_period_counter) THEN
2837:
2838: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Processing prior period data on this asset');
2839:
2840: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'============================================================');
2841: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Deleting From detail balances...');
2842: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'============================================================');

Line 2840: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'============================================================');

2836: IF l_prior_period_counter is not null AND (L_prior_period_counter< p_period_counter) THEN
2837:
2838: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Processing prior period data on this asset');
2839:
2840: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'============================================================');
2841: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Deleting From detail balances...');
2842: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'============================================================');
2843:
2844: /*DELETE from igi_iac_det_balances

Line 2841: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Deleting From detail balances...');

2837:
2838: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Processing prior period data on this asset');
2839:
2840: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'============================================================');
2841: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Deleting From detail balances...');
2842: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'============================================================');
2843:
2844: /*DELETE from igi_iac_det_balances
2845: WHERE book_type_code=p_book_type_code

Line 2842: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'============================================================');

2838: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Processing prior period data on this asset');
2839:
2840: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'============================================================');
2841: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Deleting From detail balances...');
2842: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'============================================================');
2843:
2844: /*DELETE from igi_iac_det_balances
2845: WHERE book_type_code=p_book_type_code
2846: AND period_counter=p_period_counter

Line 2871: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'============================================================');

2867: x_period_counter =>l_fa_dist.period_counter
2868: );
2869: END LOOP;
2870:
2871: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'============================================================');
2872: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Deleting From adjustments...');
2873: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'============================================================');
2874:
2875: /* DELETE from igi_iac_adjustments

Line 2872: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Deleting From adjustments...');

2868: );
2869: END LOOP;
2870:
2871: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'============================================================');
2872: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Deleting From adjustments...');
2873: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'============================================================');
2874:
2875: /* DELETE from igi_iac_adjustments
2876: WHERE book_type_code=p_book_type_code

Line 2873: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'============================================================');

2869: END LOOP;
2870:
2871: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'============================================================');
2872: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Deleting From adjustments...');
2873: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'============================================================');
2874:
2875: /* DELETE from igi_iac_adjustments
2876: WHERE book_type_code=p_book_type_code
2877: AND period_counter=p_period_counter

Line 2892: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Expense Amount to be adjusted :'||l_deprn_expense);

2888: open c_deprn_expense(l_trans_headers.asset_id,l_prev_adjustment.adjustment_id);
2889: fetch c_deprn_expense into l_deprn_expense;
2890: close c_deprn_expense;
2891:
2892: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Expense Amount to be adjusted :'||l_deprn_expense);
2893:
2894: open c_amounts(p_period_counter,l_trans_headers.asset_id);
2895: fetch c_amounts into l_amounts;
2896: close c_amounts;

Line 2898: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'============================================================');

2894: open c_amounts(p_period_counter,l_trans_headers.asset_id);
2895: fetch c_amounts into l_amounts;
2896: close c_amounts;
2897:
2898: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'============================================================');
2899: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Updating Asset balances ...');
2900: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'============================================================');
2901:
2902: IGI_IAC_ASSET_BALANCES_PKG.update_row (

Line 2899: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Updating Asset balances ...');

2895: fetch c_amounts into l_amounts;
2896: close c_amounts;
2897:
2898: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'============================================================');
2899: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Updating Asset balances ...');
2900: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'============================================================');
2901:
2902: IGI_IAC_ASSET_BALANCES_PKG.update_row (
2903: x_asset_id =>l_trans_headers.asset_id,

Line 2900: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'============================================================');

2896: close c_amounts;
2897:
2898: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'============================================================');
2899: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Updating Asset balances ...');
2900: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'============================================================');
2901:
2902: IGI_IAC_ASSET_BALANCES_PKG.update_row (
2903: x_asset_id =>l_trans_headers.asset_id,
2904: x_book_type_code =>p_book_type_code,

Line 2921: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'============================================================');

2917: x_mode =>'R'
2918: );
2919:
2920:
2921: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'============================================================');
2922: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Updating transaction headers...');
2923: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'============================================================');
2924:
2925: FOR l_prev_data in c_prev_data(l_trans_headers.adjustment_id)

Line 2922: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Updating transaction headers...');

2918: );
2919:
2920:
2921: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'============================================================');
2922: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Updating transaction headers...');
2923: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'============================================================');
2924:
2925: FOR l_prev_data in c_prev_data(l_trans_headers.adjustment_id)
2926: LOOP

Line 2923: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'============================================================');

2919:
2920:
2921: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'============================================================');
2922: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Updating transaction headers...');
2923: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'============================================================');
2924:
2925: FOR l_prev_data in c_prev_data(l_trans_headers.adjustment_id)
2926: LOOP
2927: IGI_IAC_TRANS_HEADERS_PKG.update_row (

Line 2935: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'============================================================');

2931: );
2932: END LOOP;
2933:
2934:
2935: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'============================================================');
2936: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Deleting From transaction headers...');
2937: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'============================================================');
2938:
2939: IGI_IAC_TRANS_HEADERS_PKG.delete_row (

Line 2936: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Deleting From transaction headers...');

2932: END LOOP;
2933:
2934:
2935: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'============================================================');
2936: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Deleting From transaction headers...');
2937: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'============================================================');
2938:
2939: IGI_IAC_TRANS_HEADERS_PKG.delete_row (
2940: x_adjustment_id =>l_trans_headers.adjustment_id

Line 2937: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'============================================================');

2933:
2934:
2935: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'============================================================');
2936: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Deleting From transaction headers...');
2937: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'============================================================');
2938:
2939: IGI_IAC_TRANS_HEADERS_PKG.delete_row (
2940: x_adjustment_id =>l_trans_headers.adjustment_id
2941: );

Line 2948: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'*****************************************************************');

2944:
2945:
2946: END LOOP; -- End of First for
2947:
2948: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'*****************************************************************');
2949: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Rollback completed successfully ');
2950: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'*****************************************************************');
2951:
2952: RETURN(TRUE);

Line 2949: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Rollback completed successfully ');

2945:
2946: END LOOP; -- End of First for
2947:
2948: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'*****************************************************************');
2949: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Rollback completed successfully ');
2950: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'*****************************************************************');
2951:
2952: RETURN(TRUE);
2953: END Do_rollback_deprn;

Line 2950: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'*****************************************************************');

2946: END LOOP; -- End of First for
2947:
2948: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'*****************************************************************');
2949: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Rollback completed successfully ');
2950: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'*****************************************************************');
2951:
2952: RETURN(TRUE);
2953: END Do_rollback_deprn;
2954: