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_REVAL_UTILITIES dependencies on IGI_IAC_DEBUG_PKG

Line 84: igi_iac_debug_pkg.debug_unexpected_msg(p_full_path => l_path_name);

80: end if;
81:
82: return l_prev_adjustment_id;
83: exception when others then
84: igi_iac_debug_pkg.debug_unexpected_msg(p_full_path => l_path_name);
85: return -1;
86: end;
87:
88: function last_period_counter

Line 112: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

108: and bc.book_type_code = p_book_type_code ;
109:
110: p_last_period_counter := p_dpis_period_counter + (( l_life_in_months/12 ) * l_number_per_fiscal_year ) - 1 ;
111:
112: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
113: p_full_path => l_path_name,
114: p_string => '+last period counter '|| p_last_period_counter );
115:
116: return true ;

Line 120: igi_iac_debug_pkg.debug_unexpected_msg(p_full_path => l_path_name);

116: return true ;
117:
118: exception
119: when others then
120: igi_iac_debug_pkg.debug_unexpected_msg(p_full_path => l_path_name);
121: return false ;
122: end;
123:
124: function Populate_Depreciation ( fp_asset_id IN number

Line 197: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

193: The fully resreved counter period in FA is not equal to actual fully reserved counter
194: this period counter will be the period counter on the period action performed rarther than actual period counter
195: modified code to get the actual fully reserved counter rarther than using the FA fully resereved period counter */
196:
197: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
198: p_full_path => l_path_name,
199: p_string => ' Fully reserved asset');
200: OPEN c_get_deprn_calendar(fp_book_type_code);
201: FETCH c_get_deprn_calendar INTO l_deprn_calendar;

Line 209: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

205: FETCH c_get_periods_in_year INTO l_periods_in_year;
206: CLOSE c_get_periods_in_year;
207:
208: l_last_period_counter := (l_dpis_prd_rec.period_counter + ceil((fp_hist_info.life_in_months*l_periods_in_year)/12) - 1);
209: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
210: p_full_path => l_path_name,
211: p_string => ' Last Period counter :'||to_char(l_last_period_counter));
212: -- removed the following code
213: --l_last_period_counter := fp_hist_info.period_counter_fully_reserved ;

Line 251: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

247: l_num_of_periods_in_cyr := 0;
248: l_num_of_periods_elapsed := l_prd_rec.period_counter
249: - l_dpis_prd_rec.period_counter + 1;
250: else
251: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
252: p_full_path => l_path_name,
253: p_string => 'fiscal year of the period fully reserved is incorrect');
254: end if;
255: exception

Line 257: igi_iac_debug_pkg.debug_unexpected_msg(p_full_path => l_path_name);

253: p_string => 'fiscal year of the period fully reserved is incorrect');
254: end if;
255: exception
256: when others then
257: igi_iac_debug_pkg.debug_unexpected_msg(p_full_path => l_path_name);
258: null;
259: end;
260: end if;
261:

Line 268: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

264: fp_hist_info.deprn_periods_elapsed := l_num_of_periods_elapsed;
265: fp_hist_info.deprn_periods_current_year := l_num_of_periods_in_cyr;
266: fp_hist_info.deprn_periods_prior_year := l_num_of_periods_in_pyr;
267:
268: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
269: p_full_path => l_path_name,
270: p_string => '+periods elapsed '|| l_num_of_periods_elapsed );
271: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
272: p_full_path => l_path_name,

Line 271: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

267:
268: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
269: p_full_path => l_path_name,
270: p_string => '+periods elapsed '|| l_num_of_periods_elapsed );
271: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
272: p_full_path => l_path_name,
273: p_string => '+periods cy '|| l_num_of_periods_in_cyr );
274: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
275: p_full_path => l_path_name,

Line 274: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

270: p_string => '+periods elapsed '|| l_num_of_periods_elapsed );
271: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
272: p_full_path => l_path_name,
273: p_string => '+periods cy '|| l_num_of_periods_in_cyr );
274: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
275: p_full_path => l_path_name,
276: p_string => '+periods py '|| l_num_of_periods_in_pyr );
277: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
278: p_full_path => l_path_name,

Line 277: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

273: p_string => '+periods cy '|| l_num_of_periods_in_cyr );
274: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
275: p_full_path => l_path_name,
276: p_string => '+periods py '|| l_num_of_periods_in_pyr );
277: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
278: p_full_path => l_path_name,
279: p_string => '+period ctr last '|| l_last_period_counter );
280:
281: /* YTD deprn = num of periods in cy/num of periods elapsed * Acc Deprn */

Line 299: igi_iac_debug_pkg.debug_unexpected_msg(p_full_path => l_path_name);

295: fp_hist_info.deprn_amount := fp_hist_info.deprn_reserve/fp_hist_info.deprn_periods_elapsed;
296:
297: return true;
298: exception when others then
299: igi_iac_debug_pkg.debug_unexpected_msg(p_full_path => l_path_name);
300: fp_hist_info := fp_hist_info_old;
301: return false;
302: end;
303:

Line 327: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

323: l_path_name VARCHAR2(150);
324:
325: begin
326: l_path_name := g_path||'split_rates';
327: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
328: p_full_path => l_path_name,
329: p_string => 'begin split_rates');
330: if fp_first_time_flag then /* only one movement possible */
331: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

Line 331: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

327: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
328: p_full_path => l_path_name,
329: p_string => 'begin split_rates');
330: if fp_first_time_flag then /* only one movement possible */
331: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
332: p_full_path => l_path_name,
333: p_string => '+first time flag set');
334: end if;
335: fp_reval_curr_rate_info_first := fp_reval_prev_rate_info ;

Line 353: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

349: l_cumulative_rate := fp_reval_prev_rate_info.cumulative_reval_factor;
350: l_cumulative_rate := l_current_rate * l_cumulative_rate;
351:
352: if l_cumulative_rate > 1 and fp_reval_prev_rate_info.cumulative_reval_factor < 1 then
353: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
354: p_full_path => l_path_name,
355: p_string => '+Upwards Mixed case scenario');
356: -- prev till cummulative rate =1 as first set.
357: -- cumm rate till current as second set.

Line 366: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

362: fp_reval_curr_rate_info_next.cumulative_reval_factor := l_cumulative_rate;
363: fp_reval_curr_rate_info_next.latest_record := 'Y';
364: fp_mixed_scenario := true;
365: elsif l_cumulative_rate < 1 and fp_reval_prev_rate_info.cumulative_reval_factor > 1 then
366: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
367: p_full_path => l_path_name,
368: p_string => '+Downwards Mixed case scenario');
369: fp_reval_curr_rate_info_first.current_reval_factor :=
370: (1/fp_reval_prev_rate_info.cumulative_reval_factor );

Line 372: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

368: p_string => '+Downwards Mixed case scenario');
369: fp_reval_curr_rate_info_first.current_reval_factor :=
370: (1/fp_reval_prev_rate_info.cumulative_reval_factor );
371: fp_reval_curr_rate_info_first.cumulative_reval_factor := 1;
372: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
373: p_full_path => l_path_name,
374: p_string => '+Second set rate '|| l_cumulative_rate );
375: fp_reval_curr_rate_info_next.current_reval_factor := l_cumulative_rate;
376: fp_reval_curr_rate_info_next.cumulative_reval_factor := l_cumulative_rate;

Line 380: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

376: fp_reval_curr_rate_info_next.cumulative_reval_factor := l_cumulative_rate;
377: fp_reval_curr_rate_info_next.latest_record := 'Y';
378: fp_mixed_scenario := true;
379: elsif l_cumulative_rate = 1 and fp_reval_prev_rate_info.cumulative_reval_factor = 1 then
380: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
381: p_full_path => l_path_name,
382: p_string => '+Static revaluation');
383: fp_reval_curr_rate_info_first.current_reval_factor := 1;
384: fp_reval_curr_rate_info_first.cumulative_reval_factor := 1;

Line 388: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

384: fp_reval_curr_rate_info_first.cumulative_reval_factor := 1;
385: fp_reval_curr_rate_info_first.latest_record := 'Y';
386: fp_mixed_scenario := false;
387: elsif l_cumulative_rate > 1 and fp_reval_prev_rate_info.cumulative_reval_factor >= 1 then
388: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
389: p_full_path => l_path_name,
390: p_string => '+Upwards revaluation');
391: fp_reval_curr_rate_info_first.current_reval_factor := l_cumulative_rate/
392: fp_reval_prev_rate_info.cumulative_reval_factor ;

Line 397: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

393: fp_reval_curr_rate_info_first.cumulative_reval_factor := l_cumulative_rate;
394: fp_reval_curr_rate_info_first.latest_record := 'Y';
395: fp_mixed_scenario := false;
396: elsif l_cumulative_rate = 1 and fp_reval_prev_rate_info.cumulative_reval_factor > 1 then
397: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
398: p_full_path => l_path_name,
399: p_string => '+Upwards revaluation');
400: fp_reval_curr_rate_info_first.current_reval_factor := l_cumulative_rate/
401: fp_reval_prev_rate_info.cumulative_reval_factor ;

Line 406: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

402: fp_reval_curr_rate_info_first.cumulative_reval_factor := l_cumulative_rate;
403: fp_reval_curr_rate_info_first.latest_record := 'Y';
404: fp_mixed_scenario := false;
405: elsif l_cumulative_rate < 1 and fp_reval_prev_rate_info.cumulative_reval_factor <= 1 then
406: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
407: p_full_path => l_path_name,
408: p_string => '+Downwards revaluation');
409: fp_reval_curr_rate_info_first.current_reval_factor := l_cumulative_rate/
410: fp_reval_prev_rate_info.cumulative_reval_factor ;

Line 415: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

411: fp_reval_curr_rate_info_first.cumulative_reval_factor := l_cumulative_rate;
412: fp_reval_curr_rate_info_first.latest_record := 'Y';
413: fp_mixed_scenario := false;
414: elsif l_cumulative_rate = 1 and fp_reval_prev_rate_info.cumulative_reval_factor < 1 then
415: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
416: p_full_path => l_path_name,
417: p_string => '+Downwards revaluation');
418: fp_reval_curr_rate_info_first.current_reval_factor := l_cumulative_rate/
419: fp_reval_prev_rate_info.cumulative_reval_factor ;

Line 425: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

421: fp_reval_curr_rate_info_first.latest_record := 'Y';
422: fp_mixed_scenario := false;
423: end if;
424:
425: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
426: p_full_path => l_path_name,
427: p_string => 'end split rates');
428: return true;
429: exception when others then

Line 430: igi_iac_debug_pkg.debug_unexpected_msg(p_full_path => l_path_name);

426: p_full_path => l_path_name,
427: p_string => 'end split rates');
428: return true;
429: exception when others then
430: igi_iac_debug_pkg.debug_unexpected_msg(p_full_path => l_path_name);
431: fp_reval_curr_rate_info_first := fp_reval_curr_first_old;
432: fp_reval_curr_rate_info_next := fp_reval_curr_next_old;
433: fp_mixed_scenario := FALSE;
434: return false;

Line 441: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

437: procedure display_prorate_dists ( fp_prorate_dists igi_iac_types.prorate_dists ) is
438: l_path_name VARCHAR2(150);
439: begin
440: l_path_name := g_path||'display_prorate_dists';
441: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
442: p_full_path => l_path_name,
443: p_string => '----------------------------------------------------');
444: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
445: p_full_path => l_path_name,

Line 444: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

440: l_path_name := g_path||'display_prorate_dists';
441: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
442: p_full_path => l_path_name,
443: p_string => '----------------------------------------------------');
444: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
445: p_full_path => l_path_name,
446: p_string => 'distribution id '|| fp_prorate_dists.distribution_id );
447: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
448: p_full_path => l_path_name,

Line 447: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

443: p_string => '----------------------------------------------------');
444: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
445: p_full_path => l_path_name,
446: p_string => 'distribution id '|| fp_prorate_dists.distribution_id );
447: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
448: p_full_path => l_path_name,
449: p_string => 'ytd prorate factor '|| fp_prorate_dists.ytd_prorate_factor );
450: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
451: p_full_path => l_path_name,

Line 450: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

446: p_string => 'distribution id '|| fp_prorate_dists.distribution_id );
447: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
448: p_full_path => l_path_name,
449: p_string => 'ytd prorate factor '|| fp_prorate_dists.ytd_prorate_factor );
450: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
451: p_full_path => l_path_name,
452: p_string => 'normal prorate factor '|| fp_prorate_dists.normal_prorate_factor );
453: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
454: p_full_path => l_path_name,

Line 453: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

449: p_string => 'ytd prorate factor '|| fp_prorate_dists.ytd_prorate_factor );
450: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
451: p_full_path => l_path_name,
452: p_string => 'normal prorate factor '|| fp_prorate_dists.normal_prorate_factor );
453: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
454: p_full_path => l_path_name,
455: p_string => 'latest period counter '|| fp_prorate_dists.latest_period_counter );
456: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
457: p_full_path => l_path_name,

Line 456: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

452: p_string => 'normal prorate factor '|| fp_prorate_dists.normal_prorate_factor );
453: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
454: p_full_path => l_path_name,
455: p_string => 'latest period counter '|| fp_prorate_dists.latest_period_counter );
456: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
457: p_full_path => l_path_name,
458: p_string => 'units assigned '|| fp_prorate_dists.units_assigned );
459: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
460: p_full_path => l_path_name,

Line 459: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

455: p_string => 'latest period counter '|| fp_prorate_dists.latest_period_counter );
456: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
457: p_full_path => l_path_name,
458: p_string => 'units assigned '|| fp_prorate_dists.units_assigned );
459: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
460: p_full_path => l_path_name,
461: p_string => 'units active '|| fp_prorate_dists.units_active );
462: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
463: p_full_path => l_path_name,

Line 462: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

458: p_string => 'units assigned '|| fp_prorate_dists.units_assigned );
459: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
460: p_full_path => l_path_name,
461: p_string => 'units active '|| fp_prorate_dists.units_active );
462: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
463: p_full_path => l_path_name,
464: p_string => '----------------------------------------------------');
465: end;
466:

Line 575: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

571: begin
572: l_prorate_dists_idx := 0;
573: l_path_name := g_path||'prorate_dists';
574:
575: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
576: p_full_path => l_path_name,
577: p_string => 'Begin prorate dists');
578: for l_asset in c_deprn_asset loop
579: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

Line 579: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

575: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
576: p_full_path => l_path_name,
577: p_string => 'Begin prorate dists');
578: for l_asset in c_deprn_asset loop
579: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
580: p_full_path => l_path_name,
581: p_string => '+initialize variables');
582: l_prorate_dists_idx := 0;
583: l_prorate_dists_tab.delete;

Line 584: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

580: p_full_path => l_path_name,
581: p_string => '+initialize variables');
582: l_prorate_dists_idx := 0;
583: l_prorate_dists_tab.delete;
584: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
585: p_full_path => l_path_name,
586: p_string => '+Paramteres variables ytd '|| l_asset.ytd_deprn );
587: for l_dists in c_deprn_dists ( cp_asset_id => l_asset.asset_id
588: , cp_book_type_code => l_asset.book_type_code

Line 596: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

592: )
593:
594:
595: loop
596: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
597: p_full_path => l_path_name,
598: p_string => '+Process variables');
599:
600: l_prorate_dists_idx := l_prorate_dists_idx + 1;

Line 621: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

617: end if;
618: display_prorate_dists ( l_prorate_dists_tab ( l_prorate_dists_idx ) );
619: end loop;
620: end loop;
621: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
622: p_full_path => l_path_name,
623: p_string => '+final processing');
624: fp_prorate_dists_tab := l_prorate_dists_tab;
625: fp_prorate_dists_idx := l_prorate_dists_idx;

Line 626: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

622: p_full_path => l_path_name,
623: p_string => '+final processing');
624: fp_prorate_dists_tab := l_prorate_dists_tab;
625: fp_prorate_dists_idx := l_prorate_dists_idx;
626: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
627: p_full_path => l_path_name,
628: p_string => 'end prorate dists');
629: return true;
630: exception when others then

Line 631: igi_iac_debug_pkg.debug_unexpected_msg(p_full_path => l_path_name);

627: p_full_path => l_path_name,
628: p_string => 'end prorate dists');
629: return true;
630: exception when others then
631: igi_iac_debug_pkg.debug_unexpected_msg(p_full_path => l_path_name);
632: return false;
633: end;
634:
635: FUNCTION prorate_active_dists_YTD ( fp_asset_id in number

Line 701: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,p_full_path => l_path_name,

697:
698: BEGIN
699:
700: l_path_name := g_path||'prorate_active_dists_YTD';
701: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,p_full_path => l_path_name,
702: p_string => 'Start of Processing');
703:
704: l_prorate_dists_idx := 0;
705: l_prorate_dists_tab.delete;

Line 716: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,p_full_path => l_path_name,

712: IF NOT igi_iac_common_utils.Get_Period_Info_for_Date( fp_book_type_code ,
713: l_dpis ,
714: l_dpis_period) THEN
715:
716: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,p_full_path => l_path_name,
717: p_string => 'Error in fetching DPIS period information ');
718: RETURN FALSE;
719: END IF;
720: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,p_full_path => l_path_name,

Line 720: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,p_full_path => l_path_name,

716: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,p_full_path => l_path_name,
717: p_string => 'Error in fetching DPIS period information ');
718: RETURN FALSE;
719: END IF;
720: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,p_full_path => l_path_name,
721: p_string => 'DPIS Period:'||l_dpis_period.period_counter);
722:
723: IF NOT igi_iac_common_utils.Get_Period_Info_for_Counter( fp_book_type_code ,
724: fp_current_period_counter ,

Line 726: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,p_full_path => l_path_name,

722:
723: IF NOT igi_iac_common_utils.Get_Period_Info_for_Counter( fp_book_type_code ,
724: fp_current_period_counter ,
725: l_current_period) THEN
726: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,p_full_path => l_path_name,
727: p_string => 'Error in fetching current period information ');
728: RETURN FALSE;
729: END IF;
730: l_last_period := l_current_period;

Line 731: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,p_full_path => l_path_name,

727: p_string => 'Error in fetching current period information ');
728: RETURN FALSE;
729: END IF;
730: l_last_period := l_current_period;
731: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,p_full_path => l_path_name,
732: p_string => 'Current Period:'||l_current_period.period_counter);
733:
734: IF l_fully_reserved IS NOT NULL THEN
735: OPEN c_get_periods_in_year;

Line 745: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,p_full_path => l_path_name,

741:
742: IF NOT igi_iac_common_utils.Get_Period_Info_for_Counter( fp_book_type_code ,
743: l_fully_reserved_counter ,
744: l_fully_reserved_period) THEN
745: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,p_full_path => l_path_name,
746: p_string => 'Error in fetching fully reserved period information ');
747:
748: RETURN FALSE;
749: END IF;

Line 750: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,p_full_path => l_path_name,

746: p_string => 'Error in fetching fully reserved period information ');
747:
748: RETURN FALSE;
749: END IF;
750: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,p_full_path => l_path_name,
751: p_string => 'Fully Reserved Period:'||l_fully_reserved_counter);
752:
753: l_last_period := l_fully_reserved_period;
754: END IF;

Line 759: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,p_full_path => l_path_name,

755:
756: OPEN c_first_deprn_period;
757: FETCH c_first_deprn_period INTO l_first_deprn_period;
758: CLOSE c_first_deprn_period;
759: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,p_full_path => l_path_name,
760: p_string => 'First Deprn Period:'||l_first_deprn_period);
761:
762: FOR l_dist IN C_active_dists LOOP
763: l_prorate_dists_idx := l_prorate_dists_idx + 1;

Line 767: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,p_full_path => l_path_name,

763: l_prorate_dists_idx := l_prorate_dists_idx + 1;
764:
765: l_prorate_dists_tab ( l_prorate_dists_idx ).distribution_id
766: := l_dist.distribution_id;
767: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,p_full_path => l_path_name,
768: p_string => 'Distribution Id:'||l_dist.distribution_id);
769:
770: IF (l_last_period.fiscal_year < l_current_period.fiscal_year) OR (l_depreciate_flag='NO') THEN
771: l_dist_active_periods := 0;

Line 793: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,p_full_path => l_path_name,

789: l_dist_active_periods := l_last_period.period_num;
790: END IF;
791: END IF;
792: END IF;
793: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,p_full_path => l_path_name,
794: p_string => 'Active Periods:'||l_dist_active_periods);
795: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,p_full_path => l_path_name,
796: p_string => 'Units_assigned:'||l_dist.units_assigned);
797:

Line 795: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,p_full_path => l_path_name,

791: END IF;
792: END IF;
793: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,p_full_path => l_path_name,
794: p_string => 'Active Periods:'||l_dist_active_periods);
795: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,p_full_path => l_path_name,
796: p_string => 'Units_assigned:'||l_dist.units_assigned);
797:
798: l_prorate_dists_tab ( l_prorate_dists_idx ).ytd_prorate_factor
799: := l_dist_active_periods * l_dist.units_assigned;

Line 803: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,p_full_path => l_path_name,

799: := l_dist_active_periods * l_dist.units_assigned;
800: l_asset_prorate_units := l_asset_prorate_units +
801: l_prorate_dists_tab ( l_prorate_dists_idx ).ytd_prorate_factor;
802: END LOOP;
803: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,p_full_path => l_path_name,
804: p_string => 'Asset total active units:'||l_asset_prorate_units);
805:
806: FOR i IN 1..l_prorate_dists_idx LOOP
807: IF l_asset_prorate_units = 0 THEN

Line 813: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,p_full_path => l_path_name,

809: ELSE
810: l_prorate_dists_tab ( i ).ytd_prorate_factor
811: := l_prorate_dists_tab(i).ytd_prorate_factor/l_asset_prorate_units;
812: END IF;
813: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,p_full_path => l_path_name,
814: p_string => 'Distribution Id:'||l_prorate_dists_tab(i).distribution_id);
815: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,p_full_path => l_path_name,
816: p_string => 'Prorate Factor:'||l_prorate_dists_tab(i).ytd_prorate_factor);
817:

Line 815: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,p_full_path => l_path_name,

811: := l_prorate_dists_tab(i).ytd_prorate_factor/l_asset_prorate_units;
812: END IF;
813: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,p_full_path => l_path_name,
814: p_string => 'Distribution Id:'||l_prorate_dists_tab(i).distribution_id);
815: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,p_full_path => l_path_name,
816: p_string => 'Prorate Factor:'||l_prorate_dists_tab(i).ytd_prorate_factor);
817:
818: END LOOP;
819: fp_prorate_dists_idx := l_prorate_dists_idx;

Line 824: igi_iac_debug_pkg.debug_unexpected_msg(p_full_path => l_path_name);

820: fp_prorate_dists_tab := l_prorate_dists_tab;
821: RETURN TRUE;
822: EXCEPTION
823: WHEN OTHERS THEN
824: igi_iac_debug_pkg.debug_unexpected_msg(p_full_path => l_path_name);
825: RETURN FALSE;
826: END prorate_active_dists_YTD;
827:
828: FUNCTION prorate_all_dists_YTD ( fp_asset_id in number

Line 921: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,p_full_path => l_path_name,

917:
918: BEGIN
919:
920: l_path_name := g_path||'prorate_all_dists_YTD';
921: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,p_full_path => l_path_name,
922: p_string => 'Start of Processing');
923:
924: l_prorate_dists_idx := 0;
925: l_prorate_dists_tab.delete;

Line 935: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,p_full_path => l_path_name,

931:
932: IF NOT igi_iac_common_utils.Get_Period_Info_for_Date( fp_book_type_code ,
933: l_dpis ,
934: l_dpis_period) THEN
935: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,p_full_path => l_path_name,
936: p_string => 'Error in fetching DPIS period information ');
937: RETURN FALSE;
938: END IF;
939: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,p_full_path => l_path_name,

Line 939: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,p_full_path => l_path_name,

935: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,p_full_path => l_path_name,
936: p_string => 'Error in fetching DPIS period information ');
937: RETURN FALSE;
938: END IF;
939: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,p_full_path => l_path_name,
940: p_string => 'DPIS Period:'||l_dpis_period.period_counter);
941:
942: IF NOT igi_iac_common_utils.Get_Period_Info_for_Counter( fp_book_type_code ,
943: fp_current_period_counter ,

Line 945: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,p_full_path => l_path_name,

941:
942: IF NOT igi_iac_common_utils.Get_Period_Info_for_Counter( fp_book_type_code ,
943: fp_current_period_counter ,
944: l_current_period) THEN
945: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,p_full_path => l_path_name,
946: p_string => 'Error in fetching current period information ');
947: RETURN FALSE;
948: END IF;
949: l_last_period := l_current_period;

Line 950: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,p_full_path => l_path_name,

946: p_string => 'Error in fetching current period information ');
947: RETURN FALSE;
948: END IF;
949: l_last_period := l_current_period;
950: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,p_full_path => l_path_name,
951: p_string => 'Current Period:'||l_current_period.period_counter);
952:
953: IF l_fully_reserved IS NOT NULL THEN
954: OPEN c_get_periods_in_year;

Line 968: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,p_full_path => l_path_name,

964:
965: IF NOT igi_iac_common_utils.Get_Period_Info_for_Counter( fp_book_type_code ,
966: l_fully_reserved_counter ,
967: l_fully_reserved_period) THEN
968: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,p_full_path => l_path_name,
969: p_string => 'Error in fetching fully reserved period information ');
970:
971: RETURN FALSE;
972: END IF;

Line 973: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,p_full_path => l_path_name,

969: p_string => 'Error in fetching fully reserved period information ');
970:
971: RETURN FALSE;
972: END IF;
973: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,p_full_path => l_path_name,
974: p_string => 'Fully Reserved Period:'||l_fully_reserved_counter);
975:
976: l_last_period := l_fully_reserved_period;
977: END IF;

Line 982: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,p_full_path => l_path_name,

978:
979: OPEN c_first_deprn_period;
980: FETCH c_first_deprn_period INTO l_first_deprn_period;
981: CLOSE c_first_deprn_period;
982: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,p_full_path => l_path_name,
983: p_string => 'First Deprn Period:'||l_first_deprn_period);
984:
985: FOR l_dist IN C_all_dists(l_current_period.fiscal_year) LOOP
986:

Line 994: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,p_full_path => l_path_name,

990:
991: l_prorate_dists_tab ( l_prorate_dists_idx ).distribution_id
992: := l_dist.distribution_id;
993: l_prorate_dists_tab(l_prorate_dists_idx).active_flag := l_dist.active_flag;
994: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,p_full_path => l_path_name,
995: p_string => 'Distribution Id:'||l_dist.distribution_id);
996: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,p_full_path => l_path_name,
997: p_string => 'Active Flag:'||l_dist.active_flag);
998:

Line 996: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,p_full_path => l_path_name,

992: := l_dist.distribution_id;
993: l_prorate_dists_tab(l_prorate_dists_idx).active_flag := l_dist.active_flag;
994: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,p_full_path => l_path_name,
995: p_string => 'Distribution Id:'||l_dist.distribution_id);
996: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,p_full_path => l_path_name,
997: p_string => 'Active Flag:'||l_dist.active_flag);
998:
999: IF l_dist.active_flag = 'N' THEN -- inactive
1000: IF l_last_dist_period.period_counter >= l_dist.period_counter_closed THEN --

Line 1005: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,p_full_path => l_path_name,

1001: -- get info for the period counter closed.
1002: IF NOT igi_iac_common_utils.Get_Period_Info_for_Counter( fp_book_type_code ,
1003: l_dist.period_counter_closed - 1 ,
1004: l_last_dist_period) THEN
1005: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,p_full_path => l_path_name,
1006: p_string => 'Error in fetching dist closed period information ');
1007: RETURN FALSE;
1008: END IF;
1009: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,p_full_path => l_path_name,

Line 1009: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,p_full_path => l_path_name,

1005: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,p_full_path => l_path_name,
1006: p_string => 'Error in fetching dist closed period information ');
1007: RETURN FALSE;
1008: END IF;
1009: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,p_full_path => l_path_name,
1010: p_string => ' Distribution closed Period:'||l_last_dist_period.period_counter);
1011: END IF;--
1012: END IF;-- inactive end
1013:

Line 1041: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,p_full_path => l_path_name,

1037: l_dist_active_periods := l_last_dist_period.period_num;
1038: END IF;
1039: END IF;
1040: END IF;
1041: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,p_full_path => l_path_name,
1042: p_string => 'Active Periods:'||l_dist_active_periods);
1043: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,p_full_path => l_path_name,
1044: p_string => 'Units_assigned:'||l_dist.units_assigned);
1045:

Line 1043: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,p_full_path => l_path_name,

1039: END IF;
1040: END IF;
1041: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,p_full_path => l_path_name,
1042: p_string => 'Active Periods:'||l_dist_active_periods);
1043: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,p_full_path => l_path_name,
1044: p_string => 'Units_assigned:'||l_dist.units_assigned);
1045:
1046: l_prorate_dists_tab ( l_prorate_dists_idx ).ytd_prorate_factor
1047: := l_dist_active_periods * l_dist.units_assigned;

Line 1051: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,p_full_path => l_path_name,

1047: := l_dist_active_periods * l_dist.units_assigned;
1048: l_asset_prorate_units := l_asset_prorate_units +
1049: l_prorate_dists_tab ( l_prorate_dists_idx ).ytd_prorate_factor;
1050: END LOOP;
1051: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,p_full_path => l_path_name,
1052: p_string => 'Asset total active units:'||l_asset_prorate_units);
1053:
1054: FOR i IN 1..l_prorate_dists_idx LOOP
1055: IF l_asset_prorate_units = 0 THEN

Line 1061: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,p_full_path => l_path_name,

1057: ELSE
1058: l_prorate_dists_tab ( i ).ytd_prorate_factor
1059: := l_prorate_dists_tab(i).ytd_prorate_factor/l_asset_prorate_units;
1060: END IF;
1061: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,p_full_path => l_path_name,
1062: p_string => 'Distribution Id:'||l_prorate_dists_tab(i).distribution_id);
1063: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,p_full_path => l_path_name,
1064: p_string => 'Prorate Factor:'||l_prorate_dists_tab(i).ytd_prorate_factor);
1065:

Line 1063: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,p_full_path => l_path_name,

1059: := l_prorate_dists_tab(i).ytd_prorate_factor/l_asset_prorate_units;
1060: END IF;
1061: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,p_full_path => l_path_name,
1062: p_string => 'Distribution Id:'||l_prorate_dists_tab(i).distribution_id);
1063: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,p_full_path => l_path_name,
1064: p_string => 'Prorate Factor:'||l_prorate_dists_tab(i).ytd_prorate_factor);
1065:
1066: END LOOP;
1067: fp_prorate_dists_idx := l_prorate_dists_idx;

Line 1072: igi_iac_debug_pkg.debug_unexpected_msg(p_full_path => l_path_name);

1068: fp_prorate_dists_tab := l_prorate_dists_tab;
1069: RETURN TRUE;
1070: EXCEPTION
1071: WHEN OTHERS THEN
1072: igi_iac_debug_pkg.debug_unexpected_msg(p_full_path => l_path_name);
1073: RETURN FALSE;
1074: END prorate_all_dists_YTD;
1075:
1076: -- Bug 3434121

Line 1165: igi_iac_debug_pkg.debug_unexpected_msg(p_full_path => l_path_name);

1161: END LOOP;
1162:
1163: EXCEPTION
1164: WHEN OTHERS THEN
1165: igi_iac_debug_pkg.debug_unexpected_msg(p_full_path => l_path_name);
1166: app_exception.raise_exception;
1167: END get_coa_info;
1168:
1169: FUNCTION Synchronize_Accounts(

Line 1274: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Start of processing for synchronize accounts ');

1270: l_loop_count number;
1271:
1272: BEGIN
1273: l_path := g_path||'Synchronize_Accounts';
1274: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Start of processing for synchronize accounts ');
1275: FOR l_get_transaction IN c_get_transaction LOOP
1276:
1277: OPEN c_get_adjustments(l_get_transaction.adjustment_id);
1278: FETCH c_get_adjustments BULK COLLECT INTO

Line 1305: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Success in get account ccid from distribution accounts ');

1301: l_expense_ccid,
1302: l_reserve_ccid,
1303: l_flex_num;
1304: IF (c_get_accounts%FOUND) THEN
1305: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Success in get account ccid from distribution accounts ');
1306: IF (l_adj_type(l_loop_count) = 'COST') THEN
1307: l_account_ccid := l_cost_ccid;
1308: ELSIF (l_adj_type(l_loop_count) = 'RESERVE') THEN
1309: l_account_ccid := l_reserve_ccid;

Line 1319: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,' Failed to get account ccid from distribution accounts *****');

1315: --- get the account from the fa_adjustmemts and fa_distribution_history if not found im
1316: -- fa_distribution_accounts.
1317:
1318: IF (l_account_ccid = -1) THEN
1319: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,' Failed to get account ccid from distribution accounts *****');
1320: OPEN c_get_account_ccid(l_asset_id(l_loop_count),l_dist_id(l_loop_count),
1321: l_get_transaction.transaction_type_code ,
1322: l_adj_type(l_loop_count),
1323: l_get_transaction.transaction_header_id);

Line 1326: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,' Failed to get COST/RESERVE ccid in synchronize accounts *****');

1322: l_adj_type(l_loop_count),
1323: l_get_transaction.transaction_header_id);
1324: FETCH c_get_account_ccid into l_account_ccid;
1325: IF c_get_account_ccid%NOTFOUND THEN
1326: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,' Failed to get COST/RESERVE ccid in synchronize accounts *****');
1327: l_account_ccid := -1;
1328: END IF;
1329: CLOSE c_get_account_ccid;
1330:

Line 1333: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' asset_id' || l_asset_id(l_loop_count));

1329: CLOSE c_get_account_ccid;
1330:
1331: END IF;
1332:
1333: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' asset_id' || l_asset_id(l_loop_count));
1334: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' distribution' || l_dist_id(l_loop_count));
1335: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' adjustment type ' ||l_adj_type(l_loop_count));
1336: -- get the account ccid for the adjustment
1337: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' account ccid ' || l_account_ccid);

Line 1334: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' distribution' || l_dist_id(l_loop_count));

1330:
1331: END IF;
1332:
1333: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' asset_id' || l_asset_id(l_loop_count));
1334: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' distribution' || l_dist_id(l_loop_count));
1335: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' adjustment type ' ||l_adj_type(l_loop_count));
1336: -- get the account ccid for the adjustment
1337: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' account ccid ' || l_account_ccid);
1338: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' fetched ccid '|| l_code_comb_id(l_loop_count));

Line 1335: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' adjustment type ' ||l_adj_type(l_loop_count));

1331: END IF;
1332:
1333: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' asset_id' || l_asset_id(l_loop_count));
1334: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' distribution' || l_dist_id(l_loop_count));
1335: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' adjustment type ' ||l_adj_type(l_loop_count));
1336: -- get the account ccid for the adjustment
1337: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' account ccid ' || l_account_ccid);
1338: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' fetched ccid '|| l_code_comb_id(l_loop_count));
1339:

Line 1337: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' account ccid ' || l_account_ccid);

1333: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' asset_id' || l_asset_id(l_loop_count));
1334: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' distribution' || l_dist_id(l_loop_count));
1335: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' adjustment type ' ||l_adj_type(l_loop_count));
1336: -- get the account ccid for the adjustment
1337: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' account ccid ' || l_account_ccid);
1338: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' fetched ccid '|| l_code_comb_id(l_loop_count));
1339:
1340: IF l_account_ccid = -1 THEN
1341:

Line 1338: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' fetched ccid '|| l_code_comb_id(l_loop_count));

1334: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' distribution' || l_dist_id(l_loop_count));
1335: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' adjustment type ' ||l_adj_type(l_loop_count));
1336: -- get the account ccid for the adjustment
1337: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' account ccid ' || l_account_ccid);
1338: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' fetched ccid '|| l_code_comb_id(l_loop_count));
1339:
1340: IF l_account_ccid = -1 THEN
1341:
1342: -- IF the accounts are not found

Line 1412: igi_iac_debug_pkg.debug_other_msg(p_level => g_error_level,

1408:
1409: IF l_account_ccid = -1 THEN
1410: FND_MESSAGE.SET_NAME('IGI', 'IGI_IAC_ACCOUNT_NOT_FOUND');
1411: FND_MESSAGE.SET_TOKEN('PROCESS','Revaluation',TRUE);
1412: igi_iac_debug_pkg.debug_other_msg(p_level => g_error_level,
1413: p_full_path => l_path,
1414: p_remove_from_stack => FALSE);
1415: fnd_file.put_line(fnd_file.log, fnd_message.get);
1416:

Line 1427: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Updated the adjusment with correct ccid' );

1423: UPDATE igi_iac_adjustments
1424: SET code_combination_id= l_account_ccid
1425: WHERE rowid=l_rowid;
1426:
1427: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Updated the adjusment with correct ccid' );
1428: END IF;
1429:
1430: END LOOP;
1431: END LOOP;

Line 1436: igi_iac_debug_pkg.debug_unexpected_msg(l_path);

1432: return TRUE;
1433:
1434: EXCEPTION
1435: WHEN others THEN
1436: igi_iac_debug_pkg.debug_unexpected_msg(l_path);
1437: return FALSE;
1438: END Synchronize_Accounts;
1439:
1440: BEGIN