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

Line 74: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Start of Synchronizing IAC Calendars');

70: l_curr_price_idx_value igi_iac_cal_idx_values.current_price_index_value%TYPE;
71: l_path VARCHAR2(100);
72: BEGIN
73: l_path := g_path||'Synchronize_Calendars';
74: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Start of Synchronizing IAC Calendars');
75: FOR l_get_cal_price_indexes IN c_get_cal_price_indexes LOOP
76:
77: OPEN c_fa_max_date(l_get_cal_price_indexes.cal_price_index_link_id);
78: FETCH c_fa_max_date INTO l_fa_max_date;

Line 86: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Synchronizing for cal_price_index_link_id :'||to_char(l_get_cal_price_indexes.cal_price_index_link_id));

82: FETCH c_iac_max_date INTO l_iac_max_date;
83: CLOSE c_iac_max_date;
84:
85: IF trunc(l_iac_max_date) < trunc(l_fa_max_date) THEN
86: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Synchronizing for cal_price_index_link_id :'||to_char(l_get_cal_price_indexes.cal_price_index_link_id));
87: /* Commented for bug 3197000 vgadde 19_dec-2003 Start(1)
88: OPEN c_current_price_index(l_iac_max_date ,
89: l_get_cal_price_indexes.cal_price_index_link_id);
90: FETCH c_current_price_index INTO l_curr_price_idx_value;

Line 110: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Successful completion of Synchronizing calendars');

106: X_current_price_index_value => 9999.99 );
107: END LOOP;
108: END IF;
109: END LOOP;
110: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Successful completion of Synchronizing calendars');
111: RETURN true;
112:
113: EXCEPTION
114: WHEN OTHERS THEN

Line 115: igi_iac_debug_pkg.debug_other_string(g_unexp_level,l_path,'***Error in IAC synchronize_calendars :'||sqlerrm);

111: RETURN true;
112:
113: EXCEPTION
114: WHEN OTHERS THEN
115: igi_iac_debug_pkg.debug_other_string(g_unexp_level,l_path,'***Error in IAC synchronize_calendars :'||sqlerrm);
116: RETURN false;
117: END Synchronize_calendars;
118:
119: /*=========================================================================+

Line 149: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Start of processing for non-depreciation assets');

145: l_path VARCHAR2(100);
146:
147: BEGIN
148: l_path := g_path||'Process_non_Deprn_Assets';
149: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Start of processing for non-depreciation assets');
150: FOR l_asset IN c_get_non_deprn_assets LOOP
151: IF NOT igi_iac_additions_pkg.do_prior_addition (
152: p_book_type_code => p_book_type_code,
153: p_asset_id => l_asset.asset_id,

Line 166: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'End of processing of non-depreciation assets');

162: p_event_id => p_event_id ) THEN
163: return FALSE;
164: END IF;
165: END LOOP;
166: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'End of processing of non-depreciation assets');
167: return TRUE;
168: EXCEPTION
169: WHEN OTHERS THEN
170: igi_iac_debug_pkg.debug_unexpected_msg(l_path);

Line 170: igi_iac_debug_pkg.debug_unexpected_msg(l_path);

166: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'End of processing of non-depreciation assets');
167: return TRUE;
168: EXCEPTION
169: WHEN OTHERS THEN
170: igi_iac_debug_pkg.debug_unexpected_msg(l_path);
171: return FALSE;
172: END Process_non_Deprn_Assets;*/
173:
174:

Line 413: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Start of Depreciation Processing');

409: END IF;
410: END is_asset_revalued_once;
411:
412: BEGIN
413: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Start of Depreciation Processing');
414:
415: l_Transaction_Type_Code := NULL;
416: l_Transaction_Id := NULL;
417: l_Mass_Reference_ID := NULL;

Line 428: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'***Error in get_book_gl_info');

424: l_chart_of_accts_id ,
425: l_currency_code ,
426: l_precision )) THEN
427:
428: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'***Error in get_book_gl_info');
429: RETURN false;
430: END IF;
431:
432: /* Get period information from FA for the current period */

Line 437: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'***Error in get_period_info_for_counter for current open period');

433: IF NOT (igi_iac_common_utils.Get_Period_Info_for_Counter(p_book_type_code,
434: p_period_counter,
435: l_prd_rec )) THEN
436:
437: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'***Error in get_period_info_for_counter for current open period');
438: RETURN false;
439: END IF;
440:
441: IF NOT igi_iac_common_utils.populate_iac_fa_deprn_data(p_book_type_code,

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

439: END IF;
440:
441: IF NOT igi_iac_common_utils.populate_iac_fa_deprn_data(p_book_type_code,
442: 'DEPRECIATION') THEN
443: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'*** Error in Synchronizing Depreciation Data ***');
444: return FALSE;
445: END IF;
446:
447: --FOR l_fa_deprn_record IN c_fa_deprn_records LOOP

Line 466: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Asset_id :'||to_char(l_fa_asset_id(l_loop_count)));

462: l_salvage_value,
463: l_rate_adjustment_factor,
464: l_cost;
465: CLOSE c_fa_books;
466: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Asset_id :'||to_char(l_fa_asset_id(l_loop_count)));
467: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' FA Transaction id :'||to_char(l_fa_transaction_id));
468:
469: l_transaction_date := NULL;
470: OPEN c_get_transaction_info(l_fa_transaction_id);

Line 467: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' FA Transaction id :'||to_char(l_fa_transaction_id));

463: l_rate_adjustment_factor,
464: l_cost;
465: CLOSE c_fa_books;
466: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Asset_id :'||to_char(l_fa_asset_id(l_loop_count)));
467: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' FA Transaction id :'||to_char(l_fa_transaction_id));
468:
469: l_transaction_date := NULL;
470: OPEN c_get_transaction_info(l_fa_transaction_id);
471: FETCH c_get_transaction_info INTO l_transaction_date;

Line 473: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' FA Adjustment Transaction Date :'||to_char(l_transaction_date));

469: l_transaction_date := NULL;
470: OPEN c_get_transaction_info(l_fa_transaction_id);
471: FETCH c_get_transaction_info INTO l_transaction_date;
472: CLOSE c_get_transaction_info;
473: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' FA Adjustment Transaction Date :'||to_char(l_transaction_date));
474:
475: l_prev_life_months := NULL;
476: IF (l_transaction_date IS NOT NULL) THEN
477: IF (l_transaction_date >= l_prd_rec.period_start_date AND l_transaction_date <= l_prd_rec.period_end_date) THEN

Line 485: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Previous Life in months :'||to_char(l_prev_life_months));

481:
482: l_fully_reserved := NULL;
483: END IF;
484: END IF;
485: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Previous Life in months :'||to_char(l_prev_life_months));
486:
487: /* Bug 2434532 vgadde 28/06/2002 Start(2) */
488: IF NOT igi_iac_common_utils.get_dpis_period_counter(p_book_type_code,
489: l_fa_asset_id(l_loop_count),

Line 491: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'*** Error in Fetching DPIS period counter');

487: /* Bug 2434532 vgadde 28/06/2002 Start(2) */
488: IF NOT igi_iac_common_utils.get_dpis_period_counter(p_book_type_code,
489: l_fa_asset_id(l_loop_count),
490: l_dpis_period_counter) THEN
491: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'*** Error in Fetching DPIS period counter');
492: return FALSE;
493: END IF;
494:
495: OPEN c_get_deprn_calendar;

Line 505: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Last Period Counter :'||to_char(l_last_period_counter));

501: CLOSE c_get_periods_in_year;
502:
503: l_total_periods := ceil((l_life_in_months*l_periods_in_year)/12);
504: l_last_period_counter := (l_dpis_period_counter + l_total_periods - 1);
505: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Last Period Counter :'||to_char(l_last_period_counter));
506:
507: IF (l_last_period_counter = p_period_counter) THEN
508: l_fully_reserved := NULL;
509: END IF;

Line 517: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Asset getting processed by depreciation ');

513: ( l_fully_retired is NULL ) AND
514: l_depreciate_flag = 'YES' AND
515: is_asset_revalued_once(l_fa_asset_id(l_loop_count))) THEN
516:
517: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Asset getting processed by depreciation ');
518:
519: l_Transaction_Type_Code := NULL;
520: l_Transaction_Id := NULL;
521: l_Mass_Reference_ID := NULL;

Line 535: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'*** Error in fetching the latest transaction');

531: X_Mass_Reference_ID => l_Mass_Reference_ID,
532: X_Adjustment_Id => l_adjustment_id_out,
533: X_Prev_Adjustment_Id => l_prev_adjustment_id,
534: X_Adjustment_Status => l_Adjustment_Status) THEN
535: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'*** Error in fetching the latest transaction');
536: return FALSE;
537: END IF;
538:
539: /* Commented for bug 2450345 vgadde 31-Jul-2002 Start

Line 544: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Previous actual adjustment id :'||to_char(l_prev_adjustment_id));

540: OPEN c_get_prev_adjustment(l_fa_deprn_record.asset_id);
541: FETCH c_get_prev_adjustment INTO l_prev_adjustment_id;
542: CLOSE c_get_prev_adjustment;
543: Commenting for bug 2450345 vgadde 31-Jul-2002 End */
544: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Previous actual adjustment id :'||to_char(l_prev_adjustment_id));
545: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Previous adjustment id :'||to_char(l_adjustment_id_out));
546:
547: OPEN c_get_fa_asset(l_fa_asset_id(l_loop_count));
548: FETCH c_get_fa_asset INTO l_category_id,l_asset_units;

Line 545: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Previous adjustment id :'||to_char(l_adjustment_id_out));

541: FETCH c_get_prev_adjustment INTO l_prev_adjustment_id;
542: CLOSE c_get_prev_adjustment;
543: Commenting for bug 2450345 vgadde 31-Jul-2002 End */
544: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Previous actual adjustment id :'||to_char(l_prev_adjustment_id));
545: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Previous adjustment id :'||to_char(l_adjustment_id_out));
546:
547: OPEN c_get_fa_asset(l_fa_asset_id(l_loop_count));
548: FETCH c_get_fa_asset INTO l_category_id,l_asset_units;
549: CLOSE c_get_fa_asset;

Line 550: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Units assigned for the asset :'||to_char(l_asset_units));

546:
547: OPEN c_get_fa_asset(l_fa_asset_id(l_loop_count));
548: FETCH c_get_fa_asset INTO l_category_id,l_asset_units;
549: CLOSE c_get_fa_asset;
550: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Units assigned for the asset :'||to_char(l_asset_units));
551: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Inserting into igi_iac_transaction_headers');
552: l_adjustment_id := NULL;
553: l_rowid := NULL;
554:

Line 551: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Inserting into igi_iac_transaction_headers');

547: OPEN c_get_fa_asset(l_fa_asset_id(l_loop_count));
548: FETCH c_get_fa_asset INTO l_category_id,l_asset_units;
549: CLOSE c_get_fa_asset;
550: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Units assigned for the asset :'||to_char(l_asset_units));
551: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Inserting into igi_iac_transaction_headers');
552: l_adjustment_id := NULL;
553: l_rowid := NULL;
554:
555: -- Fetching the event_id from fa_deprn_summary as in case of depreciation

Line 581: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' New adjustment id :'||to_char(l_adjustment_id));

577: X_adjustment_status => 'COMPLETE' ,
578: X_period_counter => p_period_counter,
579: X_event_id => p_event_id ) ;
580:
581: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' New adjustment id :'||to_char(l_adjustment_id));
582:
583: OPEN c_get_max_period_counter(l_fa_asset_id(l_loop_count));
584: FETCH c_get_max_period_counter INTO l_max_period_counter;
585: CLOSE c_get_max_period_counter;

Line 586: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Max asset balances period counter :'||to_char(l_max_period_counter));

582:
583: OPEN c_get_max_period_counter(l_fa_asset_id(l_loop_count));
584: FETCH c_get_max_period_counter INTO l_max_period_counter;
585: CLOSE c_get_max_period_counter;
586: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Max asset balances period counter :'||to_char(l_max_period_counter));
587:
588: OPEN c_get_asset_balance(l_fa_asset_id(l_loop_count),l_max_period_counter);
589: FETCH c_get_asset_balance INTO l_asset_balance;
590: CLOSE c_get_asset_balance;

Line 606: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' FA Deprn amount for period before salvage correction:'||to_char(l_deprn_amount));

602: /* Modified for adjustments sekhar end*/
603:
604: /* salvage value correction */
605: If l_salvage_value <> 0 Then
606: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' FA Deprn amount for period before salvage correction:'||to_char(l_deprn_amount));
607: IF NOT igi_iac_salvage_pkg.correction(p_asset_id => l_fa_asset_id(l_loop_count),
608: P_book_type_code =>p_book_type_code,
609: P_value=>l_deprn_amount,
610: P_cost=>l_cost,

Line 613: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'+Salavge Value Correction Failed : ');

609: P_value=>l_deprn_amount,
610: P_cost=>l_cost,
611: P_salvage_value=>l_salvage_value,
612: P_calling_program=>'DEPRECIATION') THEN
613: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'+Salavge Value Correction Failed : ');
614: return false;
615: END IF;
616: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' FA Deprn amount for period after salvage correction:'||to_char(l_deprn_amount));
617: END IF;

Line 616: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' FA Deprn amount for period after salvage correction:'||to_char(l_deprn_amount));

612: P_calling_program=>'DEPRECIATION') THEN
613: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'+Salavge Value Correction Failed : ');
614: return false;
615: END IF;
616: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' FA Deprn amount for period after salvage correction:'||to_char(l_deprn_amount));
617: END IF;
618: /* salvage value correction */
619:
620: IF NOT (igi_iac_common_utils.iac_round(l_deprn_amount,p_book_type_code)) THEN

Line 623: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' FA Deprn amount for period :'||to_char(l_deprn_amount));

619:
620: IF NOT (igi_iac_common_utils.iac_round(l_deprn_amount,p_book_type_code)) THEN
621: RETURN false;
622: END IF;
623: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' FA Deprn amount for period :'||to_char(l_deprn_amount));
624:
625: l_deprn_expense := (l_deprn_amount * l_asset_balance.cumulative_reval_factor) - l_deprn_amount;
626:
627: IF NOT (igi_iac_common_utils.iac_round(l_deprn_expense,p_book_type_code)) THEN

Line 630: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Cumulative revaluation rate :'||to_char(l_asset_balance.cumulative_reval_factor));

626:
627: IF NOT (igi_iac_common_utils.iac_round(l_deprn_expense,p_book_type_code)) THEN
628: RETURN false;
629: END IF;
630: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Cumulative revaluation rate :'||to_char(l_asset_balance.cumulative_reval_factor));
631: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' IAC Deprn amount for period :'||to_char(l_deprn_expense));
632:
633: l_remaining_units := l_asset_units;
634: l_remaining_amount := l_deprn_expense;

Line 631: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' IAC Deprn amount for period :'||to_char(l_deprn_expense));

627: IF NOT (igi_iac_common_utils.iac_round(l_deprn_expense,p_book_type_code)) THEN
628: RETURN false;
629: END IF;
630: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Cumulative revaluation rate :'||to_char(l_asset_balance.cumulative_reval_factor));
631: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' IAC Deprn amount for period :'||to_char(l_deprn_expense));
632:
633: l_remaining_units := l_asset_units;
634: l_remaining_amount := l_deprn_expense;
635:

Line 638: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Distribution Id :'||to_char(l_detail_balance.distribution_id));

634: l_remaining_amount := l_deprn_expense;
635:
636: FOR l_detail_balance IN c_get_detail_balance(l_fa_asset_id(l_loop_count),l_prev_adjustment_id) LOOP
637:
638: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Distribution Id :'||to_char(l_detail_balance.distribution_id));
639: IF ( l_prd_rec.period_num = 1) THEN
640: l_deprn_ytd := 0 ;
641: l_is_first_period := TRUE ;
642: ELSE

Line 647: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Current YTD for the distribution :'||to_char(l_deprn_ytd));

643: l_deprn_ytd := l_detail_balance.deprn_ytd ;
644: l_is_first_period := FALSE ;
645: END IF;
646:
647: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Current YTD for the distribution :'||to_char(l_deprn_ytd));
648: IF (nvl(l_detail_balance.active_flag,'Y') <> 'N') THEN
649:
650: OPEN c_get_distribution_units(l_detail_balance.distribution_id);
651: FETCH c_get_distribution_units INTO l_distribution_units;

Line 653: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Active distribution - Units :'||to_char(l_distribution_units));

649:
650: OPEN c_get_distribution_units(l_detail_balance.distribution_id);
651: FETCH c_get_distribution_units INTO l_distribution_units;
652: CLOSE c_get_distribution_units;
653: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Active distribution - Units :'||to_char(l_distribution_units));
654:
655: l_remaining_units := l_remaining_units - l_distribution_units;
656: IF l_remaining_units = 0 THEN
657: l_amount := l_remaining_amount;

Line 665: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Prorated amount for the distribution :'||to_char(l_amount));

661: RETURN false;
662: END IF;
663: l_remaining_amount := l_remaining_amount - l_amount;
664: END IF;
665: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Prorated amount for the distribution :'||to_char(l_amount));
666:
667: IF (nvl(l_amount,0) <> 0) THEN
668: /* Create accounting entries for non zero values */
669: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Creating accounting entries in igi_iac_adjustments');

Line 669: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Creating accounting entries in igi_iac_adjustments');

665: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Prorated amount for the distribution :'||to_char(l_amount));
666:
667: IF (nvl(l_amount,0) <> 0) THEN
668: /* Create accounting entries for non zero values */
669: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Creating accounting entries in igi_iac_adjustments');
670: l_rowid := NULL;
671: l_account_ccid := NULL ;
672:
673: IF NOT (igi_iac_common_utils.get_account_ccid(p_book_type_code ,

Line 681: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Deprn Expense ccid :'||to_char(l_account_ccid));

677: l_account_ccid )) THEN
678:
679: RETURN false;
680: END IF;
681: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Deprn Expense ccid :'||to_char(l_account_ccid));
682: igi_iac_adjustments_pkg.insert_row(
683: X_rowid => l_rowid ,
684: X_adjustment_id => l_adjustment_id ,
685: X_book_type_code => p_book_type_code ,

Line 712: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Deprn Reserve ccid :'||to_char(l_account_ccid));

708: l_account_ccid )) THEN
709:
710: RETURN false;
711: END IF;
712: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Deprn Reserve ccid :'||to_char(l_account_ccid));
713: igi_iac_adjustments_pkg.insert_row(
714: X_rowid => l_rowid ,
715: X_adjustment_id => l_adjustment_id ,
716: X_book_type_code => p_book_type_code ,

Line 747: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Reval reserve ccid :'||to_char(l_account_ccid));

743: RETURN false;
744: END IF;
745: l_reval_reserve_ccid := l_account_ccid;
746:
747: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Reval reserve ccid :'||to_char(l_account_ccid));
748: igi_iac_adjustments_pkg.insert_row(
749: X_rowid => l_rowid ,
750: X_adjustment_id => l_adjustment_id ,
751: X_book_type_code => p_book_type_code ,

Line 778: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' General Fund ccid :'||to_char(l_account_ccid));

774: l_account_ccid )) THEN
775:
776: RETURN false;
777: END IF;
778: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' General Fund ccid :'||to_char(l_account_ccid));
779: igi_iac_adjustments_pkg.insert_row(
780: X_rowid => l_rowid ,
781: X_adjustment_id => l_adjustment_id ,
782: X_book_type_code => p_book_type_code ,

Line 803: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Inserting into igi_iac_det_balances');

799:
800: l_rowid := null ;
801:
802: IF (nvl(l_detail_balance.active_flag,'Y') <> 'N') THEN
803: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Inserting into igi_iac_det_balances');
804: /* Bug 2407393 vgadde 07/06/2002 Start(1) */
805: IF (l_asset_balance.adjusted_cost > 0) THEN
806: l_reval_rsv_net := l_detail_balance.reval_reserve_net - l_amount;
807: l_reval_rsv_gen_fund := l_detail_balance.reval_reserve_gen_fund + l_amount;

Line 850: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Processing inactive distribution');

846:
847: END IF;
848:
849: IF ((nvl(l_detail_balance.active_flag,'Y') = 'N') AND (NOT l_is_first_period)) THEN
850: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Processing inactive distribution');
851: l_rowid := null;
852: igi_iac_det_balances_pkg.insert_row(
853: X_rowid => l_rowid ,
854: X_adjustment_id => l_adjustment_id ,

Line 890: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Processing inactive distribution in first period');

886: FETCH c_get_prev_year_inactive_dist INTO l_prev_year_inactive_dist;
887: CLOSE c_get_prev_year_inactive_dist;
888:
889: IF l_prev_year_inactive_dist IS NULL THEN
890: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Processing inactive distribution in first period');
891: l_rowid := null;
892: igi_iac_det_balances_pkg.insert_row(
893: X_rowid => l_rowid ,
894: X_adjustment_id => l_adjustment_id ,

Line 926: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Distribution Id :'||to_char(l_iac_fa_deprn_dist.distribution_id));

922: END LOOP;
923:
924: FOR l_iac_fa_deprn_dist IN c_get_iac_fa_deprn_dists(l_asset_balance.asset_id,
925: l_prev_adjustment_id) LOOP
926: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Distribution Id :'||to_char(l_iac_fa_deprn_dist.distribution_id));
927: IF ( l_prd_rec.period_num = 1) THEN
928: l_deprn_ytd := 0 ;
929: l_is_first_period := TRUE ;
930: ELSE

Line 935: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Current YTD for the distribution :'||to_char(l_deprn_ytd));

931: l_deprn_ytd := l_iac_fa_deprn_dist.deprn_ytd ;
932: l_is_first_period := FALSE ;
933: END IF;
934:
935: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Current YTD for the distribution :'||to_char(l_deprn_ytd));
936: IF (nvl(l_iac_fa_deprn_dist.active_flag,'Y') <> 'N') THEN
937:
938: FOR l_fa_dist_amounts IN c_get_dist_deprn_amount(l_asset_balance.asset_id,l_iac_fa_deprn_dist.distribution_id) LOOP
939: l_rowid := NULL;

Line 1013: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Updating asset balances for the current period');

1009: OPEN c_get_asset_balance(l_fa_asset_id(l_loop_count),p_period_counter );
1010: FETCH c_get_asset_balance INTO l_asset_balance_curr;
1011: IF c_get_asset_balance%FOUND THEN
1012:
1013: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Updating asset balances for the current period');
1014: igi_iac_asset_balances_pkg.update_row(
1015: X_asset_id => l_asset_balance.asset_id ,
1016: X_book_type_code => p_book_type_code ,
1017: X_period_counter => p_period_counter ,

Line 1030: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Inserting asset balances for the current period');

1026: X_last_reval_date => l_asset_balance.last_reval_date ,
1027: X_current_reval_factor => l_asset_balance.current_reval_factor ,
1028: X_cumulative_reval_factor => l_asset_balance.cumulative_reval_factor ) ;
1029: ELSE
1030: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Inserting asset balances for the current period');
1031: l_rowid := NULL;
1032: igi_iac_asset_balances_pkg.insert_row(
1033: X_rowid => l_rowid ,
1034: X_asset_id => l_asset_balance.asset_id ,

Line 1055: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Updating asset balances for the next period');

1051: OPEN c_get_asset_balance(l_fa_asset_id(l_loop_count),p_period_counter +1);
1052: FETCH c_get_asset_balance INTO l_asset_balance_next;
1053: IF c_get_asset_balance%FOUND THEN
1054:
1055: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Updating asset balances for the next period');
1056: igi_iac_asset_balances_pkg.update_row(
1057: X_asset_id => l_asset_balance.asset_id ,
1058: X_book_type_code => p_book_type_code ,
1059: X_period_counter => p_period_counter + 1 ,

Line 1072: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Inserting asset balances for the next period');

1068: X_last_reval_date => l_asset_balance.last_reval_date ,
1069: X_current_reval_factor => l_asset_balance.current_reval_factor ,
1070: X_cumulative_reval_factor => l_asset_balance.cumulative_reval_factor ) ;
1071: ELSE
1072: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Inserting asset balances for the next period');
1073: l_rowid := NULL;
1074: igi_iac_asset_balances_pkg.insert_row(
1075: X_rowid => l_rowid ,
1076: X_asset_id => l_asset_balance.asset_id ,

Line 1093: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Making previous transaction inactive.');

1089: X_cumulative_reval_factor => l_asset_balance.cumulative_reval_factor ) ;
1090: END IF;
1091: CLOSE c_get_asset_balance;
1092:
1093: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Making previous transaction inactive.');
1094: igi_iac_trans_headers_pkg.update_row(
1095: X_prev_adjustment_id => l_adjustment_id_out ,
1096: X_adjustment_id => l_adjustment_id ) ;
1097:

Line 1101: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Successful completion of periodic_reval_of_deprn');

1097:
1098: END IF;
1099: END LOOP;
1100:
1101: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Successful completion of periodic_reval_of_deprn');
1102: RETURN true;
1103:
1104: EXCEPTION
1105: WHEN OTHERS THEN

Line 1106: igi_iac_debug_pkg.debug_unexpected_msg(l_path);

1102: RETURN true;
1103:
1104: EXCEPTION
1105: WHEN OTHERS THEN
1106: igi_iac_debug_pkg.debug_unexpected_msg(l_path);
1107: RETURN false;
1108: END Periodic_Reval_of_Deprn;
1109:
1110: FUNCTION Synchronize_Accounts(

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

1237: -- Bug 4714606
1238:
1239: BEGIN
1240: l_path := g_path||'Synchronize_Accounts';
1241: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Start of processing for synchronize accounts ');
1242: FOR l_get_transaction IN c_get_transaction LOOP
1243: --get the adjustments in the current period
1244: --FOR l_adjustment IN c_get_adjustments(l_get_transaction.adjustment_id) LOOP
1245:

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

1273: l_expense_ccid,
1274: l_reserve_ccid,
1275: l_flex_num;
1276: IF (c_get_accounts%FOUND) THEN
1277: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Success in get account ccid from distribution accounts ');
1278: IF (l_adj_type(l_loop_count) = 'COST') THEN
1279: l_account_ccid := l_cost_ccid;
1280: ELSIF (l_adj_type(l_loop_count) = 'RESERVE') THEN
1281: l_account_ccid := l_reserve_ccid;

Line 1291: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'Could not get account ccid from distribution accounts ');

1287: --- get the account from the fa_adjustmemts and fa_distribution_history if not found im
1288: -- fa_distribution_accounts.
1289:
1290: IF (l_account_ccid = -1) THEN
1291: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'Could not get account ccid from distribution accounts ');
1292: /* IF (l_adj_type(l_loop_count) in ('COST','RESERVE' ) ) THEN
1293: OPEN c_get_cost_reserve_ccid(l_asset_id(l_loop_count),l_dist_id(l_loop_count),
1294: l_get_transaction.transaction_type_code ,
1295: l_adj_type(l_loop_count),

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

1295: l_adj_type(l_loop_count),
1296: l_get_transaction.transaction_header_id);
1297: FETCH c_get_cost_reserve_ccid into l_account_ccid;
1298: IF c_get_cost_reserve_ccid%NOTFOUND THEN
1299: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,' Failed to get COST/RESERVE ccid in synchronize accounts *****');
1300: END IF;
1301: CLOSE c_get_cost_reserve_ccid;
1302: ELSIF (l_adj_type(l_loop_count) ='EXPENSE' ) THEN
1303: OPEN c_get_expense_ccid(l_asset_id(l_loop_count),l_dist_id(l_loop_count),

Line 1307: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,' Failed to get EXPENSE ccid in synchronize accounts *****');

1303: OPEN c_get_expense_ccid(l_asset_id(l_loop_count),l_dist_id(l_loop_count),
1304: l_get_transaction.transaction_header_id);
1305: FETCH c_get_expense_ccid into l_account_ccid;
1306: IF c_get_expense_ccid%NOTFOUND THEN
1307: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,' Failed to get EXPENSE ccid in synchronize accounts *****');
1308: END IF;
1309: CLOSE c_get_expense_ccid;
1310: END IF;
1311: */

Line 1320: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'Could not get '||l_adj_type(l_loop_count)|| 'ccid from fa_adjustments');

1316: l_adj_type(l_loop_count),
1317: l_get_transaction.transaction_header_id);
1318: FETCH c_get_account_ccid into l_account_ccid;
1319: IF c_get_account_ccid%NOTFOUND THEN
1320: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'Could not get '||l_adj_type(l_loop_count)|| 'ccid from fa_adjustments');
1321: l_account_ccid := -1;
1322: END IF;
1323: CLOSE c_get_account_ccid;
1324:

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

1323: CLOSE c_get_account_ccid;
1324:
1325: END IF;
1326:
1327: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' asset_id' || l_asset_id(l_loop_count));
1328: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' distribution' || l_dist_id(l_loop_count));
1329: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' adjustment type ' ||l_adj_type(l_loop_count));
1330: -- get the account ccid for the adjustment
1331: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' account ccid ' || l_account_ccid);

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

1324:
1325: END IF;
1326:
1327: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' asset_id' || l_asset_id(l_loop_count));
1328: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' distribution' || l_dist_id(l_loop_count));
1329: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' adjustment type ' ||l_adj_type(l_loop_count));
1330: -- get the account ccid for the adjustment
1331: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' account ccid ' || l_account_ccid);
1332: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' fetched ccid '|| l_code_comb_id(l_loop_count));

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

1325: END IF;
1326:
1327: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' asset_id' || l_asset_id(l_loop_count));
1328: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' distribution' || l_dist_id(l_loop_count));
1329: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' adjustment type ' ||l_adj_type(l_loop_count));
1330: -- get the account ccid for the adjustment
1331: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' account ccid ' || l_account_ccid);
1332: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' fetched ccid '|| l_code_comb_id(l_loop_count));
1333:

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

1327: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' asset_id' || l_asset_id(l_loop_count));
1328: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' distribution' || l_dist_id(l_loop_count));
1329: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' adjustment type ' ||l_adj_type(l_loop_count));
1330: -- get the account ccid for the adjustment
1331: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' account ccid ' || l_account_ccid);
1332: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' fetched ccid '|| l_code_comb_id(l_loop_count));
1333:
1334: IF l_account_ccid = -1 THEN
1335:

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

1328: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' distribution' || l_dist_id(l_loop_count));
1329: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' adjustment type ' ||l_adj_type(l_loop_count));
1330: -- get the account ccid for the adjustment
1331: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' account ccid ' || l_account_ccid);
1332: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' fetched ccid '|| l_code_comb_id(l_loop_count));
1333:
1334: IF l_account_ccid = -1 THEN
1335:
1336: -- IF the accounts are not found

Line 1387: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,' Failed to get EXPENSE ccid in synchronize accounts *****');

1383: l_dist_id(l_loop_count),
1384: l_get_transaction.transaction_header_id);
1385: FETCH c_get_expense_ccid into l_dist_ccid;
1386: IF c_get_expense_ccid%NOTFOUND THEN
1387: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,' Failed to get EXPENSE ccid in synchronize accounts *****');
1388: l_dist_ccid := l_code_comb_id(l_loop_count);
1389: END IF;
1390: CLOSE c_get_expense_ccid;
1391: -- Bug 4714606

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

1415:
1416: IF l_account_ccid = -1 THEN
1417: FND_MESSAGE.SET_NAME('IGI', 'IGI_IAC_ACCOUNT_NOT_FOUND');
1418: FND_MESSAGE.SET_TOKEN('PROCESS','Depreciation',TRUE);
1419: igi_iac_debug_pkg.debug_other_msg(p_level => g_error_level,
1420: p_full_path => l_path,
1421: p_remove_from_stack => FALSE);
1422: fnd_file.put_line(fnd_file.log, fnd_message.get);
1423:

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

1428: UPDATE igi_iac_adjustments
1429: SET code_combination_id= l_account_ccid
1430: WHERE rowid=l_rowid;
1431:
1432: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Updated the adjusment with correct ccid' );
1433: END IF;
1434:
1435: END LOOP;
1436: END LOOP;

Line 1441: igi_iac_debug_pkg.debug_unexpected_msg(l_path);

1437: return TRUE;
1438:
1439: EXCEPTION
1440: WHEN others THEN
1441: igi_iac_debug_pkg.debug_unexpected_msg(l_path);
1442: return FALSE;
1443: END Synchronize_Accounts;
1444:
1445:

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

1459: ) RETURN boolean IS
1460: l_path VARCHAR2(100);
1461: BEGIN
1462: l_path := g_path||'Do_Depreciation';
1463: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'*****************************************************');
1464: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Start of IAC Depreciation Processing');
1465: IF NOT igi_iac_common_utils.is_iac_book(p_book_type_code) THEN
1466: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' The book is not an IAC book');
1467: RETURN true;

Line 1464: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Start of IAC Depreciation Processing');

1460: l_path VARCHAR2(100);
1461: BEGIN
1462: l_path := g_path||'Do_Depreciation';
1463: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'*****************************************************');
1464: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Start of IAC Depreciation Processing');
1465: IF NOT igi_iac_common_utils.is_iac_book(p_book_type_code) THEN
1466: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' The book is not an IAC book');
1467: RETURN true;
1468: ELSE

Line 1466: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' The book is not an IAC book');

1462: l_path := g_path||'Do_Depreciation';
1463: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'*****************************************************');
1464: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Start of IAC Depreciation Processing');
1465: IF NOT igi_iac_common_utils.is_iac_book(p_book_type_code) THEN
1466: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' The book is not an IAC book');
1467: RETURN true;
1468: ELSE
1469: IF NOT Synchronize_Calendars(p_book_type_code) THEN
1470: RETURN false;

Line 1501: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Successful completion of IAC Depreciation Processing');

1497: ) THEN
1498: RETURN false;
1499: END IF;
1500:
1501: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Successful completion of IAC Depreciation Processing');
1502: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'******************************************************');
1503: RETURN true;
1504: END IF;
1505:

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

1498: RETURN false;
1499: END IF;
1500:
1501: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Successful completion of IAC Depreciation Processing');
1502: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'******************************************************');
1503: RETURN true;
1504: END IF;
1505:
1506: EXCEPTION

Line 1508: igi_iac_debug_pkg.debug_unexpected_msg(l_path);

1504: END IF;
1505:
1506: EXCEPTION
1507: WHEN OTHERS THEN
1508: igi_iac_debug_pkg.debug_unexpected_msg(l_path);
1509: RETURN false;
1510: END Do_Depreciation;
1511: BEGIN
1512: --===========================FND_LOG.START=====================================