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.FA_IMPAIRMENT_POST_PVT dependencies on FA_DEBUG_PKG

Line 415: fa_debug_pkg.add(l_calling_fn,'Process Post', 'BEGIN', p_log_level_rec => p_log_level_rec);

411:
412: BEGIN
413:
414: if (p_log_level_rec.statement_level) then
415: fa_debug_pkg.add(l_calling_fn,'Process Post', 'BEGIN', p_log_level_rec => p_log_level_rec);
416: fa_debug_pkg.add(l_calling_fn,'worker id', p_worker_id, p_log_level_rec => p_log_level_rec);
417: fa_debug_pkg.add(l_calling_fn,'book type code', p_book_type_code, p_log_level_rec => p_log_level_rec);
418: fa_debug_pkg.add(l_calling_fn,'period counter', p_period_rec.period_counter, p_log_level_rec => p_log_level_rec);
419: fa_debug_pkg.add(l_calling_fn,'request_id', p_request_id, p_log_level_rec => p_log_level_rec);

Line 416: fa_debug_pkg.add(l_calling_fn,'worker id', p_worker_id, p_log_level_rec => p_log_level_rec);

412: BEGIN
413:
414: if (p_log_level_rec.statement_level) then
415: fa_debug_pkg.add(l_calling_fn,'Process Post', 'BEGIN', p_log_level_rec => p_log_level_rec);
416: fa_debug_pkg.add(l_calling_fn,'worker id', p_worker_id, p_log_level_rec => p_log_level_rec);
417: fa_debug_pkg.add(l_calling_fn,'book type code', p_book_type_code, p_log_level_rec => p_log_level_rec);
418: fa_debug_pkg.add(l_calling_fn,'period counter', p_period_rec.period_counter, p_log_level_rec => p_log_level_rec);
419: fa_debug_pkg.add(l_calling_fn,'request_id', p_request_id, p_log_level_rec => p_log_level_rec);
420: end if;

Line 417: fa_debug_pkg.add(l_calling_fn,'book type code', p_book_type_code, p_log_level_rec => p_log_level_rec);

413:
414: if (p_log_level_rec.statement_level) then
415: fa_debug_pkg.add(l_calling_fn,'Process Post', 'BEGIN', p_log_level_rec => p_log_level_rec);
416: fa_debug_pkg.add(l_calling_fn,'worker id', p_worker_id, p_log_level_rec => p_log_level_rec);
417: fa_debug_pkg.add(l_calling_fn,'book type code', p_book_type_code, p_log_level_rec => p_log_level_rec);
418: fa_debug_pkg.add(l_calling_fn,'period counter', p_period_rec.period_counter, p_log_level_rec => p_log_level_rec);
419: fa_debug_pkg.add(l_calling_fn,'request_id', p_request_id, p_log_level_rec => p_log_level_rec);
420: end if;
421:

Line 418: fa_debug_pkg.add(l_calling_fn,'period counter', p_period_rec.period_counter, p_log_level_rec => p_log_level_rec);

414: if (p_log_level_rec.statement_level) then
415: fa_debug_pkg.add(l_calling_fn,'Process Post', 'BEGIN', p_log_level_rec => p_log_level_rec);
416: fa_debug_pkg.add(l_calling_fn,'worker id', p_worker_id, p_log_level_rec => p_log_level_rec);
417: fa_debug_pkg.add(l_calling_fn,'book type code', p_book_type_code, p_log_level_rec => p_log_level_rec);
418: fa_debug_pkg.add(l_calling_fn,'period counter', p_period_rec.period_counter, p_log_level_rec => p_log_level_rec);
419: fa_debug_pkg.add(l_calling_fn,'request_id', p_request_id, p_log_level_rec => p_log_level_rec);
420: end if;
421:
422: -- Initializing common variables

Line 419: fa_debug_pkg.add(l_calling_fn,'request_id', p_request_id, p_log_level_rec => p_log_level_rec);

415: fa_debug_pkg.add(l_calling_fn,'Process Post', 'BEGIN', p_log_level_rec => p_log_level_rec);
416: fa_debug_pkg.add(l_calling_fn,'worker id', p_worker_id, p_log_level_rec => p_log_level_rec);
417: fa_debug_pkg.add(l_calling_fn,'book type code', p_book_type_code, p_log_level_rec => p_log_level_rec);
418: fa_debug_pkg.add(l_calling_fn,'period counter', p_period_rec.period_counter, p_log_level_rec => p_log_level_rec);
419: fa_debug_pkg.add(l_calling_fn,'request_id', p_request_id, p_log_level_rec => p_log_level_rec);
420: end if;
421:
422: -- Initializing common variables
423: l_adj.book_type_code := p_book_type_code;

Line 473: fa_debug_pkg.add(l_calling_fn,'Inside of ', 'Outer Loop', p_log_level_rec => p_log_level_rec);

469: --
470: -- Outer Loop
471: LOOP
472: if (p_log_level_rec.statement_level) then
473: fa_debug_pkg.add(l_calling_fn,'Inside of ', 'Outer Loop', p_log_level_rec => p_log_level_rec);
474: end if;
475:
476: t_thid.delete;
477: t_old_thid.delete;

Line 629: fa_debug_pkg.add(l_calling_fn,'t_request_id.count', t_request_id.count, p_log_level_rec => p_log_level_rec);

625:
626: end if;
627:
628: if (p_log_level_rec.statement_level) then
629: fa_debug_pkg.add(l_calling_fn,'t_request_id.count', t_request_id.count, p_log_level_rec => p_log_level_rec);
630:
631: for i in 1..t_request_id.count loop
632: fa_debug_pkg.add(l_calling_fn,'t_impairment_id', t_impairment_id(i));
633: fa_debug_pkg.add(l_calling_fn,'t_asset_id', t_asset_id(i));

Line 632: fa_debug_pkg.add(l_calling_fn,'t_impairment_id', t_impairment_id(i));

628: if (p_log_level_rec.statement_level) then
629: fa_debug_pkg.add(l_calling_fn,'t_request_id.count', t_request_id.count, p_log_level_rec => p_log_level_rec);
630:
631: for i in 1..t_request_id.count loop
632: fa_debug_pkg.add(l_calling_fn,'t_impairment_id', t_impairment_id(i));
633: fa_debug_pkg.add(l_calling_fn,'t_asset_id', t_asset_id(i));
634: end loop;
635: end if;
636:

Line 633: fa_debug_pkg.add(l_calling_fn,'t_asset_id', t_asset_id(i));

629: fa_debug_pkg.add(l_calling_fn,'t_request_id.count', t_request_id.count, p_log_level_rec => p_log_level_rec);
630:
631: for i in 1..t_request_id.count loop
632: fa_debug_pkg.add(l_calling_fn,'t_impairment_id', t_impairment_id(i));
633: fa_debug_pkg.add(l_calling_fn,'t_asset_id', t_asset_id(i));
634: end loop;
635: end if;
636:
637: if (t_request_id.count = 0) then

Line 665: fa_debug_pkg.add(l_calling_fn,'Getting Records from ', 'FA_TRANSACTION_HEADERS', p_log_level_rec => p_log_level_rec);

661: if (p_mrc_sob_type_code = 'R') then
662: -- select impairment thid of primary book
663: -- Following update is to get thid from primary book
664: if (p_log_level_rec.statement_level) then
665: fa_debug_pkg.add(l_calling_fn,'Getting Records from ', 'FA_TRANSACTION_HEADERS', p_log_level_rec => p_log_level_rec);
666: end if;
667:
668: FORALL i in 1..t_request_id.count
669: UPDATE FA_TRANSACTION_HEADERS

Line 701: fa_debug_pkg.add(l_calling_fn,'Insert into ', 'FA_TRANSACTION_HEADERS', p_log_level_rec => p_log_level_rec);

697:
698: end if;
699: else
700: if (p_log_level_rec.statement_level) then
701: fa_debug_pkg.add(l_calling_fn,'Insert into ', 'FA_TRANSACTION_HEADERS', p_log_level_rec => p_log_level_rec);
702: end if;
703:
704: if G_release = 11 then
705: FORALL i in 1..t_request_id.count

Line 795: fa_debug_pkg.add(l_calling_fn,'Start processing ', 'Prior Period Transfer', p_log_level_rec => p_log_level_rec);

791: -- ************************************
792: -- Process Prior Period Transfer if any
793: -- ************************************
794: if (p_log_level_rec.statement_level) then
795: fa_debug_pkg.add(l_calling_fn,'Start processing ', 'Prior Period Transfer', p_log_level_rec => p_log_level_rec);
796: end if;
797:
798: l_asset_cat_rec.category_id := t_category_id(i);
799:

Line 828: fa_debug_pkg.add(l_calling_fn,'l_asset_dist_tbl has been populated ', t_dist_thid.count, p_log_level_rec => p_log_level_rec);

824: l_asset_dist_tbl(j).location_ccid := t_loc_id(j);
825: end loop;
826:
827: if (p_log_level_rec.statement_level) then
828: fa_debug_pkg.add(l_calling_fn,'l_asset_dist_tbl has been populated ', t_dist_thid.count, p_log_level_rec => p_log_level_rec);
829: end if;
830:
831: if not FA_TRANSFER_PVT.fadppt
832: (p_trans_rec => l_trans_rec,

Line 874: fa_debug_pkg.add(l_calling_fn,'Calling function ', 'create_cost_entries', p_log_level_rec => p_log_level_rec);

870: -- *****************************************
871: -- Process (Cip_)cost entries for addition
872: -- *****************************************
873: if (p_log_level_rec.statement_level) then
874: fa_debug_pkg.add(l_calling_fn,'Calling function ', 'create_cost_entries', p_log_level_rec => p_log_level_rec);
875: end if;
876:
877: if not create_cost_entries(p_asset_hdr_rec => l_asset_hdr_rec
878: , p_trans_rec => l_trans_rec

Line 906: fa_debug_pkg.add(l_calling_fn,'Calling faxinaj for ', 'ppa Catch-up Expense', p_log_level_rec => p_log_level_rec);

902: l_adj.account_type := 'DEPRN_EXPENSE_ACCT';
903: l_adj.debit_credit_flag := 'DR';
904:
905: if (p_log_level_rec.statement_level) then
906: fa_debug_pkg.add(l_calling_fn,'Calling faxinaj for ', 'ppa Catch-up Expense', p_log_level_rec => p_log_level_rec);
907: end if;
908:
909: if not FA_INS_ADJUST_PKG.faxinaj (l_adj,
910: t_creation_date(i),

Line 918: fa_debug_pkg.add(l_calling_fn,'Calling function ', 'Prior Period Addition', p_log_level_rec => p_log_level_rec);

914: raise pos_err;
915: end if;
916:
917: if (p_log_level_rec.statement_level) then
918: fa_debug_pkg.add(l_calling_fn,'Calling function ', 'Prior Period Addition', p_log_level_rec => p_log_level_rec);
919: end if;
920:
921: end if;
922:

Line 949: fa_debug_pkg.add(l_calling_fn,'Calling function ', 'Deprn Basis', p_log_level_rec => p_log_level_rec);

945:
946:
947: -- Calculate New deprn basis
948: if (p_log_level_rec.statement_level) then
949: fa_debug_pkg.add(l_calling_fn,'Calling function ', 'Deprn Basis', p_log_level_rec => p_log_level_rec);
950: end if;
951:
952: if (p_log_level_rec.statement_level) then
953: fa_debug_pkg.add(l_calling_fn, 'Before Calling', 'fa_cache_pkg.fazccmt', p_log_level_rec => p_log_level_rec);

Line 953: fa_debug_pkg.add(l_calling_fn, 'Before Calling', 'fa_cache_pkg.fazccmt', p_log_level_rec => p_log_level_rec);

949: fa_debug_pkg.add(l_calling_fn,'Calling function ', 'Deprn Basis', p_log_level_rec => p_log_level_rec);
950: end if;
951:
952: if (p_log_level_rec.statement_level) then
953: fa_debug_pkg.add(l_calling_fn, 'Before Calling', 'fa_cache_pkg.fazccmt', p_log_level_rec => p_log_level_rec);
954: fa_debug_pkg.add(l_calling_fn, 'deprn_method_code', l_asset_fin_rec.deprn_method_code, p_log_level_rec => p_log_level_rec);
955: fa_debug_pkg.add(l_calling_fn, 'life_in_months', l_asset_fin_rec.life_in_months, p_log_level_rec => p_log_level_rec);
956: end if;
957:

Line 954: fa_debug_pkg.add(l_calling_fn, 'deprn_method_code', l_asset_fin_rec.deprn_method_code, p_log_level_rec => p_log_level_rec);

950: end if;
951:
952: if (p_log_level_rec.statement_level) then
953: fa_debug_pkg.add(l_calling_fn, 'Before Calling', 'fa_cache_pkg.fazccmt', p_log_level_rec => p_log_level_rec);
954: fa_debug_pkg.add(l_calling_fn, 'deprn_method_code', l_asset_fin_rec.deprn_method_code, p_log_level_rec => p_log_level_rec);
955: fa_debug_pkg.add(l_calling_fn, 'life_in_months', l_asset_fin_rec.life_in_months, p_log_level_rec => p_log_level_rec);
956: end if;
957:
958: if (not fa_cache_pkg.fazccmt(l_asset_fin_rec.deprn_method_code,

Line 955: fa_debug_pkg.add(l_calling_fn, 'life_in_months', l_asset_fin_rec.life_in_months, p_log_level_rec => p_log_level_rec);

951:
952: if (p_log_level_rec.statement_level) then
953: fa_debug_pkg.add(l_calling_fn, 'Before Calling', 'fa_cache_pkg.fazccmt', p_log_level_rec => p_log_level_rec);
954: fa_debug_pkg.add(l_calling_fn, 'deprn_method_code', l_asset_fin_rec.deprn_method_code, p_log_level_rec => p_log_level_rec);
955: fa_debug_pkg.add(l_calling_fn, 'life_in_months', l_asset_fin_rec.life_in_months, p_log_level_rec => p_log_level_rec);
956: end if;
957:
958: if (not fa_cache_pkg.fazccmt(l_asset_fin_rec.deprn_method_code,
959: l_asset_fin_rec.life_in_months, p_log_level_rec => p_log_level_rec)) then

Line 961: fa_debug_pkg.add(l_calling_fn, 'Error calling', 'fa_cache_pkg.fazccmt', p_log_level_rec => p_log_level_rec);

957:
958: if (not fa_cache_pkg.fazccmt(l_asset_fin_rec.deprn_method_code,
959: l_asset_fin_rec.life_in_months, p_log_level_rec => p_log_level_rec)) then
960: if (p_log_level_rec.statement_level) then
961: fa_debug_pkg.add(l_calling_fn, 'Error calling', 'fa_cache_pkg.fazccmt', p_log_level_rec => p_log_level_rec);
962: end if;
963:
964: raise pos_err;
965: end if;

Line 968: fa_debug_pkg.add(l_calling_fn, 'rate_source_rule', fa_cache_pkg.fazccmt_record.rate_source_rule, p_log_level_rec => p_log_level_rec);

964: raise pos_err;
965: end if;
966:
967: if (p_log_level_rec.statement_level) then
968: fa_debug_pkg.add(l_calling_fn, 'rate_source_rule', fa_cache_pkg.fazccmt_record.rate_source_rule, p_log_level_rec => p_log_level_rec);
969: fa_debug_pkg.add(l_calling_fn, 'deprn_basis_rule', fa_cache_pkg.fazccmt_record.deprn_basis_rule, p_log_level_rec => p_log_level_rec);
970: fa_debug_pkg.add(l_calling_fn, 'use_rsv_after_imp_flag', fa_cache_pkg.fazcdrd_record.use_rsv_after_imp_flag, p_log_level_rec => p_log_level_rec);
971: end if;
972:

Line 969: fa_debug_pkg.add(l_calling_fn, 'deprn_basis_rule', fa_cache_pkg.fazccmt_record.deprn_basis_rule, p_log_level_rec => p_log_level_rec);

965: end if;
966:
967: if (p_log_level_rec.statement_level) then
968: fa_debug_pkg.add(l_calling_fn, 'rate_source_rule', fa_cache_pkg.fazccmt_record.rate_source_rule, p_log_level_rec => p_log_level_rec);
969: fa_debug_pkg.add(l_calling_fn, 'deprn_basis_rule', fa_cache_pkg.fazccmt_record.deprn_basis_rule, p_log_level_rec => p_log_level_rec);
970: fa_debug_pkg.add(l_calling_fn, 'use_rsv_after_imp_flag', fa_cache_pkg.fazcdrd_record.use_rsv_after_imp_flag, p_log_level_rec => p_log_level_rec);
971: end if;
972:
973: if (fa_cache_pkg.fazccmt_record.rate_source_rule = fa_std_types.FAD_RSR_FLAT) and

Line 970: fa_debug_pkg.add(l_calling_fn, 'use_rsv_after_imp_flag', fa_cache_pkg.fazcdrd_record.use_rsv_after_imp_flag, p_log_level_rec => p_log_level_rec);

966:
967: if (p_log_level_rec.statement_level) then
968: fa_debug_pkg.add(l_calling_fn, 'rate_source_rule', fa_cache_pkg.fazccmt_record.rate_source_rule, p_log_level_rec => p_log_level_rec);
969: fa_debug_pkg.add(l_calling_fn, 'deprn_basis_rule', fa_cache_pkg.fazccmt_record.deprn_basis_rule, p_log_level_rec => p_log_level_rec);
970: fa_debug_pkg.add(l_calling_fn, 'use_rsv_after_imp_flag', fa_cache_pkg.fazcdrd_record.use_rsv_after_imp_flag, p_log_level_rec => p_log_level_rec);
971: end if;
972:
973: if (fa_cache_pkg.fazccmt_record.rate_source_rule = fa_std_types.FAD_RSR_FLAT) and
974: (fa_cache_pkg.fazccmt_record.deprn_basis_rule = fa_std_types.FAD_DBR_COST) and

Line 1055: fa_debug_pkg.add(l_calling_fn,'INSIDE EXTENDED LOGIC FOR', ' PC FULLY RESRVE and LIFE COMPLETE and EXTENDED', p_log_level_rec => p_log_level_rec);

1051: IF (t_new_adj_cost(i) <= 0) THEN
1052: t_period_counter_fully_ext(i) := p_period_rec.period_counter;
1053: END IF;
1054: if (p_log_level_rec.statement_level) then
1055: fa_debug_pkg.add(l_calling_fn,'INSIDE EXTENDED LOGIC FOR', ' PC FULLY RESRVE and LIFE COMPLETE and EXTENDED', p_log_level_rec => p_log_level_rec);
1056: fa_debug_pkg.add(l_calling_fn,'PERIOD_COUNTER_LIFE_COMPLETE', t_period_counter_life_complete(i), p_log_level_rec => p_log_level_rec);
1057: fa_debug_pkg.add(l_calling_fn,'PERIOD_COUNTER_FULLY_RESERVED', t_period_counter_fully_rsv(i), p_log_level_rec => p_log_level_rec);
1058: fa_debug_pkg.add(l_calling_fn,'PERIOD_COUNTER_FULLY_EXTENDED', t_period_counter_fully_ext(i), p_log_level_rec => p_log_level_rec);
1059: end if;

Line 1056: fa_debug_pkg.add(l_calling_fn,'PERIOD_COUNTER_LIFE_COMPLETE', t_period_counter_life_complete(i), p_log_level_rec => p_log_level_rec);

1052: t_period_counter_fully_ext(i) := p_period_rec.period_counter;
1053: END IF;
1054: if (p_log_level_rec.statement_level) then
1055: fa_debug_pkg.add(l_calling_fn,'INSIDE EXTENDED LOGIC FOR', ' PC FULLY RESRVE and LIFE COMPLETE and EXTENDED', p_log_level_rec => p_log_level_rec);
1056: fa_debug_pkg.add(l_calling_fn,'PERIOD_COUNTER_LIFE_COMPLETE', t_period_counter_life_complete(i), p_log_level_rec => p_log_level_rec);
1057: fa_debug_pkg.add(l_calling_fn,'PERIOD_COUNTER_FULLY_RESERVED', t_period_counter_fully_rsv(i), p_log_level_rec => p_log_level_rec);
1058: fa_debug_pkg.add(l_calling_fn,'PERIOD_COUNTER_FULLY_EXTENDED', t_period_counter_fully_ext(i), p_log_level_rec => p_log_level_rec);
1059: end if;
1060: END IF;

Line 1057: fa_debug_pkg.add(l_calling_fn,'PERIOD_COUNTER_FULLY_RESERVED', t_period_counter_fully_rsv(i), p_log_level_rec => p_log_level_rec);

1053: END IF;
1054: if (p_log_level_rec.statement_level) then
1055: fa_debug_pkg.add(l_calling_fn,'INSIDE EXTENDED LOGIC FOR', ' PC FULLY RESRVE and LIFE COMPLETE and EXTENDED', p_log_level_rec => p_log_level_rec);
1056: fa_debug_pkg.add(l_calling_fn,'PERIOD_COUNTER_LIFE_COMPLETE', t_period_counter_life_complete(i), p_log_level_rec => p_log_level_rec);
1057: fa_debug_pkg.add(l_calling_fn,'PERIOD_COUNTER_FULLY_RESERVED', t_period_counter_fully_rsv(i), p_log_level_rec => p_log_level_rec);
1058: fa_debug_pkg.add(l_calling_fn,'PERIOD_COUNTER_FULLY_EXTENDED', t_period_counter_fully_ext(i), p_log_level_rec => p_log_level_rec);
1059: end if;
1060: END IF;
1061: /*Bug 9818289 Initialized below variables so that they have values in case of Non-Japanese methods*/

Line 1058: fa_debug_pkg.add(l_calling_fn,'PERIOD_COUNTER_FULLY_EXTENDED', t_period_counter_fully_ext(i), p_log_level_rec => p_log_level_rec);

1054: if (p_log_level_rec.statement_level) then
1055: fa_debug_pkg.add(l_calling_fn,'INSIDE EXTENDED LOGIC FOR', ' PC FULLY RESRVE and LIFE COMPLETE and EXTENDED', p_log_level_rec => p_log_level_rec);
1056: fa_debug_pkg.add(l_calling_fn,'PERIOD_COUNTER_LIFE_COMPLETE', t_period_counter_life_complete(i), p_log_level_rec => p_log_level_rec);
1057: fa_debug_pkg.add(l_calling_fn,'PERIOD_COUNTER_FULLY_RESERVED', t_period_counter_fully_rsv(i), p_log_level_rec => p_log_level_rec);
1058: fa_debug_pkg.add(l_calling_fn,'PERIOD_COUNTER_FULLY_EXTENDED', t_period_counter_fully_ext(i), p_log_level_rec => p_log_level_rec);
1059: end if;
1060: END IF;
1061: /*Bug 9818289 Initialized below variables so that they have values in case of Non-Japanese methods*/
1062: t_rate_in_use(i) := null;

Line 1078: fa_debug_pkg.add(l_calling_fn,'ASSET WILL SWITCH AFTER', 'CURRENT IMPAIRMENT', p_log_level_rec => p_log_level_rec);

1074: t_rate_in_use(i) := fa_cache_pkg.fazcfor_record.revised_rate;
1075: t_nbv_at_switch(i) := t_new_adj_cost(i) + l_asset_fin_rec.salvage_value;
1076:
1077: if (p_log_level_rec.statement_level) then
1078: fa_debug_pkg.add(l_calling_fn,'ASSET WILL SWITCH AFTER', 'CURRENT IMPAIRMENT', p_log_level_rec => p_log_level_rec);
1079: fa_debug_pkg.add(l_calling_fn,'t_rate_in_use(i)', t_rate_in_use(i), p_log_level_rec => p_log_level_rec);
1080: fa_debug_pkg.add(l_calling_fn,'t_nbv_at_switch(i)', t_nbv_at_switch(i), p_log_level_rec => p_log_level_rec);
1081: end if;
1082: else

Line 1079: fa_debug_pkg.add(l_calling_fn,'t_rate_in_use(i)', t_rate_in_use(i), p_log_level_rec => p_log_level_rec);

1075: t_nbv_at_switch(i) := t_new_adj_cost(i) + l_asset_fin_rec.salvage_value;
1076:
1077: if (p_log_level_rec.statement_level) then
1078: fa_debug_pkg.add(l_calling_fn,'ASSET WILL SWITCH AFTER', 'CURRENT IMPAIRMENT', p_log_level_rec => p_log_level_rec);
1079: fa_debug_pkg.add(l_calling_fn,'t_rate_in_use(i)', t_rate_in_use(i), p_log_level_rec => p_log_level_rec);
1080: fa_debug_pkg.add(l_calling_fn,'t_nbv_at_switch(i)', t_nbv_at_switch(i), p_log_level_rec => p_log_level_rec);
1081: end if;
1082: else
1083: t_rate_in_use(i) := fa_cache_pkg.fazcfor_record.original_rate;

Line 1080: fa_debug_pkg.add(l_calling_fn,'t_nbv_at_switch(i)', t_nbv_at_switch(i), p_log_level_rec => p_log_level_rec);

1076:
1077: if (p_log_level_rec.statement_level) then
1078: fa_debug_pkg.add(l_calling_fn,'ASSET WILL SWITCH AFTER', 'CURRENT IMPAIRMENT', p_log_level_rec => p_log_level_rec);
1079: fa_debug_pkg.add(l_calling_fn,'t_rate_in_use(i)', t_rate_in_use(i), p_log_level_rec => p_log_level_rec);
1080: fa_debug_pkg.add(l_calling_fn,'t_nbv_at_switch(i)', t_nbv_at_switch(i), p_log_level_rec => p_log_level_rec);
1081: end if;
1082: else
1083: t_rate_in_use(i) := fa_cache_pkg.fazcfor_record.original_rate;
1084: t_nbv_at_switch(i) := NULL;

Line 1088: fa_debug_pkg.add(l_calling_fn,'INSIDE JAPAN LOGIC', 'NBV CALCULATIONS FOR NBV', p_log_level_rec => p_log_level_rec);

1084: t_nbv_at_switch(i) := NULL;
1085: end if;
1086: end if;
1087: if (p_log_level_rec.statement_level) then
1088: fa_debug_pkg.add(l_calling_fn,'INSIDE JAPAN LOGIC', 'NBV CALCULATIONS FOR NBV', p_log_level_rec => p_log_level_rec);
1089: fa_debug_pkg.add(l_calling_fn,'t_rate_in_use(i)', t_rate_in_use(i), p_log_level_rec => p_log_level_rec);
1090: fa_debug_pkg.add(l_calling_fn,'t_nbv_at_switch(i)', t_nbv_at_switch(i), p_log_level_rec => p_log_level_rec);
1091: end if;
1092: end if;

Line 1089: fa_debug_pkg.add(l_calling_fn,'t_rate_in_use(i)', t_rate_in_use(i), p_log_level_rec => p_log_level_rec);

1085: end if;
1086: end if;
1087: if (p_log_level_rec.statement_level) then
1088: fa_debug_pkg.add(l_calling_fn,'INSIDE JAPAN LOGIC', 'NBV CALCULATIONS FOR NBV', p_log_level_rec => p_log_level_rec);
1089: fa_debug_pkg.add(l_calling_fn,'t_rate_in_use(i)', t_rate_in_use(i), p_log_level_rec => p_log_level_rec);
1090: fa_debug_pkg.add(l_calling_fn,'t_nbv_at_switch(i)', t_nbv_at_switch(i), p_log_level_rec => p_log_level_rec);
1091: end if;
1092: end if;
1093: -- Insert Adj

Line 1090: fa_debug_pkg.add(l_calling_fn,'t_nbv_at_switch(i)', t_nbv_at_switch(i), p_log_level_rec => p_log_level_rec);

1086: end if;
1087: if (p_log_level_rec.statement_level) then
1088: fa_debug_pkg.add(l_calling_fn,'INSIDE JAPAN LOGIC', 'NBV CALCULATIONS FOR NBV', p_log_level_rec => p_log_level_rec);
1089: fa_debug_pkg.add(l_calling_fn,'t_rate_in_use(i)', t_rate_in_use(i), p_log_level_rec => p_log_level_rec);
1090: fa_debug_pkg.add(l_calling_fn,'t_nbv_at_switch(i)', t_nbv_at_switch(i), p_log_level_rec => p_log_level_rec);
1091: end if;
1092: end if;
1093: -- Insert Adj
1094: if (p_log_level_rec.statement_level) then

Line 1095: fa_debug_pkg.add(l_calling_fn,'Preparing variables for ', 'faxinaj', p_log_level_rec => p_log_level_rec);

1091: end if;
1092: end if;
1093: -- Insert Adj
1094: if (p_log_level_rec.statement_level) then
1095: fa_debug_pkg.add(l_calling_fn,'Preparing variables for ', 'faxinaj', p_log_level_rec => p_log_level_rec);
1096: end if;
1097:
1098: l_adj.source_type_code := 'ADJUSTMENT';
1099:

Line 1101: fa_debug_pkg.add(l_calling_fn,'fa_cache_pkg.fazcbc_record.sorp_enabled_flag', fa_cache_pkg.fazcbc_record.sorp_enabled_flag, p_log_level_rec => p_log_level_rec);

1097:
1098: l_adj.source_type_code := 'ADJUSTMENT';
1099:
1100: if (p_log_level_rec.statement_level) then
1101: fa_debug_pkg.add(l_calling_fn,'fa_cache_pkg.fazcbc_record.sorp_enabled_flag', fa_cache_pkg.fazcbc_record.sorp_enabled_flag, p_log_level_rec => p_log_level_rec);
1102: end if;
1103:
1104: -- Bug 6666666 : Added for the SORP Compliance Project
1105: -- The following code snippet is used to create the impairment accounting

Line 1133: fa_debug_pkg.add(l_calling_fn,'Error creating SORP Impair

1129: , p_created_by => t_created_by(i)
1130: , p_creation_date => t_creation_date(i)
1131: , p_log_level_rec => p_log_level_rec
1132: ) then
1133: fa_debug_pkg.add(l_calling_fn,'Error creating SORP Impair
1134: entries', 'True', p_log_level_rec => p_log_level_rec);
1135: raise pos_err;
1136: end if;
1137:

Line 1139: fa_debug_pkg.add(l_calling_fn,'Processing of create_sorp_imp_acct', 'successful', p_log_level_rec => p_log_level_rec);

1135: raise pos_err;
1136: end if;
1137:
1138: if (p_log_level_rec.statement_level) then
1139: fa_debug_pkg.add(l_calling_fn,'Processing of create_sorp_imp_acct', 'successful', p_log_level_rec => p_log_level_rec);
1140: end if;
1141:
1142: -- ******************************************************
1143: -- Need to create catchup entry for BD SORP IMP

Line 1158: fa_debug_pkg.add(l_calling_fn,'Calling faxinaj for ', 'Catch-up Expense', p_log_level_rec => p_log_level_rec);

1154: l_adj.account_type := 'DEPRN_EXPENSE_ACCT';
1155: l_adj.debit_credit_flag := 'DR';
1156:
1157: if (p_log_level_rec.statement_level) then
1158: fa_debug_pkg.add(l_calling_fn,'Calling faxinaj for ', 'Catch-up Expense', p_log_level_rec => p_log_level_rec);
1159: end if;
1160:
1161: if not FA_INS_ADJUST_PKG.faxinaj (l_adj,
1162: t_creation_date(i),

Line 1178: fa_debug_pkg.add(l_calling_fn,'Error at create_sorp_neutral_acct',

1174: , t_created_by(i)
1175: , t_creation_date(i)
1176: , p_log_level_rec
1177: ) then
1178: fa_debug_pkg.add(l_calling_fn,'Error at create_sorp_neutral_acct',
1179: 'for Catch-up Expense', p_log_level_rec => p_log_level_rec);
1180: return false;
1181: end if;
1182:

Line 1198: fa_debug_pkg.add(l_calling_fn,'Calling faxinaj for ', 'Accumulated Impairments', p_log_level_rec => p_log_level_rec);

1194:
1195: l_adj.debit_credit_flag := 'CR';
1196:
1197: if (p_log_level_rec.statement_level) then
1198: fa_debug_pkg.add(l_calling_fn,'Calling faxinaj for ', 'Accumulated Impairments', p_log_level_rec => p_log_level_rec);
1199: end if;
1200:
1201: if not FA_INS_ADJUST_PKG.faxinaj (l_adj,
1202: t_creation_date(i),

Line 1219: fa_debug_pkg.add(l_calling_fn,'Calling faxinaj for ', 'Impairments Expense', p_log_level_rec => p_log_level_rec);

1215: l_adj.account := fa_cache_pkg.fazccb_record.impair_expense_acct;
1216: l_adj.debit_credit_flag := 'DR';
1217:
1218: if (p_log_level_rec.statement_level) then
1219: fa_debug_pkg.add(l_calling_fn,'Calling faxinaj for ', 'Impairments Expense', p_log_level_rec => p_log_level_rec);
1220: end if;
1221:
1222: if not FA_INS_ADJUST_PKG.faxinaj (l_adj,
1223: t_creation_date(i),

Line 1246: fa_debug_pkg.add(l_calling_fn,'Calling faxinaj for ', 'Catch-up Expense', p_log_level_rec => p_log_level_rec);

1242: l_adj.account_type := 'DEPRN_EXPENSE_ACCT';
1243: l_adj.debit_credit_flag := 'DR';
1244:
1245: if (p_log_level_rec.statement_level) then
1246: fa_debug_pkg.add(l_calling_fn,'Calling faxinaj for ', 'Catch-up Expense', p_log_level_rec => p_log_level_rec);
1247: end if;
1248:
1249: if not FA_INS_ADJUST_PKG.faxinaj (l_adj,
1250: t_creation_date(i),

Line 1274: fa_debug_pkg.add(l_calling_fn,'Calling faxinaj for ', 'Reval Reserve', p_log_level_rec => p_log_level_rec);

1270: l_adj.account := fa_cache_pkg.fazccb_record.reval_reserve_acct;
1271: l_adj.debit_credit_flag := 'DR';
1272:
1273: if (p_log_level_rec.statement_level) then
1274: fa_debug_pkg.add(l_calling_fn,'Calling faxinaj for ', 'Reval Reserve', p_log_level_rec => p_log_level_rec);
1275: end if;
1276:
1277: if not FA_INS_ADJUST_PKG.faxinaj (l_adj,
1278: t_creation_date(i),

Line 1289: fa_debug_pkg.add(l_calling_fn,'Finish calling', 'faxinaj', p_log_level_rec => p_log_level_rec);

1285:
1286: end if; -- End If SORP/Non SORP check
1287:
1288: if (p_log_level_rec.statement_level) then
1289: fa_debug_pkg.add(l_calling_fn,'Finish calling', 'faxinaj', p_log_level_rec => p_log_level_rec);
1290: end if;
1291:
1292: if (p_period_rec.period_counter = l_period_counter) then
1293:

Line 1295: fa_debug_pkg.add(l_calling_fn,'Calling FAXINDD for ', 'FA_DEPRN_DETAIL', p_log_level_rec => p_log_level_rec);

1291:
1292: if (p_period_rec.period_counter = l_period_counter) then
1293:
1294: if (p_log_level_rec.statement_level) then
1295: fa_debug_pkg.add(l_calling_fn,'Calling FAXINDD for ', 'FA_DEPRN_DETAIL', p_log_level_rec => p_log_level_rec);
1296: fa_debug_pkg.add(l_calling_fn,'p_period_rec.period_counter', p_period_rec.period_counter, p_log_level_rec => p_log_level_rec);
1297: fa_debug_pkg.add(l_calling_fn,'t_cost('||to_char(i)||')', t_cost(i));
1298: fa_debug_pkg.add(l_calling_fn,'t_deprn_reserve('||to_char(i)||')', t_deprn_reserve(i));
1299: fa_debug_pkg.add(l_calling_fn,'t_reval_reserve('||to_char(i)||')', t_reval_reserve(i));

Line 1296: fa_debug_pkg.add(l_calling_fn,'p_period_rec.period_counter', p_period_rec.period_counter, p_log_level_rec => p_log_level_rec);

1292: if (p_period_rec.period_counter = l_period_counter) then
1293:
1294: if (p_log_level_rec.statement_level) then
1295: fa_debug_pkg.add(l_calling_fn,'Calling FAXINDD for ', 'FA_DEPRN_DETAIL', p_log_level_rec => p_log_level_rec);
1296: fa_debug_pkg.add(l_calling_fn,'p_period_rec.period_counter', p_period_rec.period_counter, p_log_level_rec => p_log_level_rec);
1297: fa_debug_pkg.add(l_calling_fn,'t_cost('||to_char(i)||')', t_cost(i));
1298: fa_debug_pkg.add(l_calling_fn,'t_deprn_reserve('||to_char(i)||')', t_deprn_reserve(i));
1299: fa_debug_pkg.add(l_calling_fn,'t_reval_reserve('||to_char(i)||')', t_reval_reserve(i));
1300: fa_debug_pkg.add(l_calling_fn,'t_ytd_deprn('||to_char(i)||')', t_ytd_deprn(i));

Line 1297: fa_debug_pkg.add(l_calling_fn,'t_cost('||to_char(i)||')', t_cost(i));

1293:
1294: if (p_log_level_rec.statement_level) then
1295: fa_debug_pkg.add(l_calling_fn,'Calling FAXINDD for ', 'FA_DEPRN_DETAIL', p_log_level_rec => p_log_level_rec);
1296: fa_debug_pkg.add(l_calling_fn,'p_period_rec.period_counter', p_period_rec.period_counter, p_log_level_rec => p_log_level_rec);
1297: fa_debug_pkg.add(l_calling_fn,'t_cost('||to_char(i)||')', t_cost(i));
1298: fa_debug_pkg.add(l_calling_fn,'t_deprn_reserve('||to_char(i)||')', t_deprn_reserve(i));
1299: fa_debug_pkg.add(l_calling_fn,'t_reval_reserve('||to_char(i)||')', t_reval_reserve(i));
1300: fa_debug_pkg.add(l_calling_fn,'t_ytd_deprn('||to_char(i)||')', t_ytd_deprn(i));
1301: fa_debug_pkg.add(l_calling_fn,'t_ytd_reval_deprn_expense('||to_char(i)||')', t_ytd_reval_deprn_expense(i));

Line 1298: fa_debug_pkg.add(l_calling_fn,'t_deprn_reserve('||to_char(i)||')', t_deprn_reserve(i));

1294: if (p_log_level_rec.statement_level) then
1295: fa_debug_pkg.add(l_calling_fn,'Calling FAXINDD for ', 'FA_DEPRN_DETAIL', p_log_level_rec => p_log_level_rec);
1296: fa_debug_pkg.add(l_calling_fn,'p_period_rec.period_counter', p_period_rec.period_counter, p_log_level_rec => p_log_level_rec);
1297: fa_debug_pkg.add(l_calling_fn,'t_cost('||to_char(i)||')', t_cost(i));
1298: fa_debug_pkg.add(l_calling_fn,'t_deprn_reserve('||to_char(i)||')', t_deprn_reserve(i));
1299: fa_debug_pkg.add(l_calling_fn,'t_reval_reserve('||to_char(i)||')', t_reval_reserve(i));
1300: fa_debug_pkg.add(l_calling_fn,'t_ytd_deprn('||to_char(i)||')', t_ytd_deprn(i));
1301: fa_debug_pkg.add(l_calling_fn,'t_ytd_reval_deprn_expense('||to_char(i)||')', t_ytd_reval_deprn_expense(i));
1302: fa_debug_pkg.add(l_calling_fn,'t_new_adj_cost('||to_char(i)||')', t_new_adj_cost(i));

Line 1299: fa_debug_pkg.add(l_calling_fn,'t_reval_reserve('||to_char(i)||')', t_reval_reserve(i));

1295: fa_debug_pkg.add(l_calling_fn,'Calling FAXINDD for ', 'FA_DEPRN_DETAIL', p_log_level_rec => p_log_level_rec);
1296: fa_debug_pkg.add(l_calling_fn,'p_period_rec.period_counter', p_period_rec.period_counter, p_log_level_rec => p_log_level_rec);
1297: fa_debug_pkg.add(l_calling_fn,'t_cost('||to_char(i)||')', t_cost(i));
1298: fa_debug_pkg.add(l_calling_fn,'t_deprn_reserve('||to_char(i)||')', t_deprn_reserve(i));
1299: fa_debug_pkg.add(l_calling_fn,'t_reval_reserve('||to_char(i)||')', t_reval_reserve(i));
1300: fa_debug_pkg.add(l_calling_fn,'t_ytd_deprn('||to_char(i)||')', t_ytd_deprn(i));
1301: fa_debug_pkg.add(l_calling_fn,'t_ytd_reval_deprn_expense('||to_char(i)||')', t_ytd_reval_deprn_expense(i));
1302: fa_debug_pkg.add(l_calling_fn,'t_new_adj_cost('||to_char(i)||')', t_new_adj_cost(i));
1303: fa_debug_pkg.add(l_calling_fn,'t_net_book_value'||to_char(i)||')',t_net_book_value(i));

Line 1300: fa_debug_pkg.add(l_calling_fn,'t_ytd_deprn('||to_char(i)||')', t_ytd_deprn(i));

1296: fa_debug_pkg.add(l_calling_fn,'p_period_rec.period_counter', p_period_rec.period_counter, p_log_level_rec => p_log_level_rec);
1297: fa_debug_pkg.add(l_calling_fn,'t_cost('||to_char(i)||')', t_cost(i));
1298: fa_debug_pkg.add(l_calling_fn,'t_deprn_reserve('||to_char(i)||')', t_deprn_reserve(i));
1299: fa_debug_pkg.add(l_calling_fn,'t_reval_reserve('||to_char(i)||')', t_reval_reserve(i));
1300: fa_debug_pkg.add(l_calling_fn,'t_ytd_deprn('||to_char(i)||')', t_ytd_deprn(i));
1301: fa_debug_pkg.add(l_calling_fn,'t_ytd_reval_deprn_expense('||to_char(i)||')', t_ytd_reval_deprn_expense(i));
1302: fa_debug_pkg.add(l_calling_fn,'t_new_adj_cost('||to_char(i)||')', t_new_adj_cost(i));
1303: fa_debug_pkg.add(l_calling_fn,'t_net_book_value'||to_char(i)||')',t_net_book_value(i));
1304: end if;

Line 1301: fa_debug_pkg.add(l_calling_fn,'t_ytd_reval_deprn_expense('||to_char(i)||')', t_ytd_reval_deprn_expense(i));

1297: fa_debug_pkg.add(l_calling_fn,'t_cost('||to_char(i)||')', t_cost(i));
1298: fa_debug_pkg.add(l_calling_fn,'t_deprn_reserve('||to_char(i)||')', t_deprn_reserve(i));
1299: fa_debug_pkg.add(l_calling_fn,'t_reval_reserve('||to_char(i)||')', t_reval_reserve(i));
1300: fa_debug_pkg.add(l_calling_fn,'t_ytd_deprn('||to_char(i)||')', t_ytd_deprn(i));
1301: fa_debug_pkg.add(l_calling_fn,'t_ytd_reval_deprn_expense('||to_char(i)||')', t_ytd_reval_deprn_expense(i));
1302: fa_debug_pkg.add(l_calling_fn,'t_new_adj_cost('||to_char(i)||')', t_new_adj_cost(i));
1303: fa_debug_pkg.add(l_calling_fn,'t_net_book_value'||to_char(i)||')',t_net_book_value(i));
1304: end if;
1305:

Line 1302: fa_debug_pkg.add(l_calling_fn,'t_new_adj_cost('||to_char(i)||')', t_new_adj_cost(i));

1298: fa_debug_pkg.add(l_calling_fn,'t_deprn_reserve('||to_char(i)||')', t_deprn_reserve(i));
1299: fa_debug_pkg.add(l_calling_fn,'t_reval_reserve('||to_char(i)||')', t_reval_reserve(i));
1300: fa_debug_pkg.add(l_calling_fn,'t_ytd_deprn('||to_char(i)||')', t_ytd_deprn(i));
1301: fa_debug_pkg.add(l_calling_fn,'t_ytd_reval_deprn_expense('||to_char(i)||')', t_ytd_reval_deprn_expense(i));
1302: fa_debug_pkg.add(l_calling_fn,'t_new_adj_cost('||to_char(i)||')', t_new_adj_cost(i));
1303: fa_debug_pkg.add(l_calling_fn,'t_net_book_value'||to_char(i)||')',t_net_book_value(i));
1304: end if;
1305:
1306: -- Insert DD

Line 1303: fa_debug_pkg.add(l_calling_fn,'t_net_book_value'||to_char(i)||')',t_net_book_value(i));

1299: fa_debug_pkg.add(l_calling_fn,'t_reval_reserve('||to_char(i)||')', t_reval_reserve(i));
1300: fa_debug_pkg.add(l_calling_fn,'t_ytd_deprn('||to_char(i)||')', t_ytd_deprn(i));
1301: fa_debug_pkg.add(l_calling_fn,'t_ytd_reval_deprn_expense('||to_char(i)||')', t_ytd_reval_deprn_expense(i));
1302: fa_debug_pkg.add(l_calling_fn,'t_new_adj_cost('||to_char(i)||')', t_new_adj_cost(i));
1303: fa_debug_pkg.add(l_calling_fn,'t_net_book_value'||to_char(i)||')',t_net_book_value(i));
1304: end if;
1305:
1306: -- Insert DD
1307:

Line 1389: fa_debug_pkg.add(l_calling_fn,'Insert into ', 'FA_DEPRN_SUMMARY_MRC_V', p_log_level_rec => p_log_level_rec);

1385: if (p_period_rec.period_counter = l_period_counter) then
1386:
1387: if (p_mrc_sob_type_code = 'R') then
1388: if (p_log_level_rec.statement_level) then
1389: fa_debug_pkg.add(l_calling_fn,'Insert into ', 'FA_DEPRN_SUMMARY_MRC_V', p_log_level_rec => p_log_level_rec);
1390: end if;
1391:
1392: -- Bug 6666666 : If SORP is enabled, insert values for capital adj
1393: -- and general fund

Line 1550: fa_debug_pkg.add(l_calling_fn,'Insert into ', 'FA_DEPRN_SUMMARY', p_log_level_rec => p_log_level_rec);

1546:
1547: else
1548:
1549: if (p_log_level_rec.statement_level) then
1550: fa_debug_pkg.add(l_calling_fn,'Insert into ', 'FA_DEPRN_SUMMARY', p_log_level_rec => p_log_level_rec);
1551: end if;
1552:
1553: -- Bug 6666666 : If SORP is enabled, insert values for capital adj
1554: -- and general fund

Line 1708: fa_debug_pkg.add(l_calling_fn,'Deactivating ', 'FA_BOOKS_MRC_V', p_log_level_rec => p_log_level_rec);

1704:
1705: -- Deactivate Books
1706: if (p_mrc_sob_type_code = 'R') then
1707: if (p_log_level_rec.statement_level) then
1708: fa_debug_pkg.add(l_calling_fn,'Deactivating ', 'FA_BOOKS_MRC_V', p_log_level_rec => p_log_level_rec);
1709: end if;
1710:
1711: FORALL i in 1..t_request_id.count
1712: UPDATE FA_MC_BOOKS

Line 1723: fa_debug_pkg.add(l_calling_fn,'Deactivating ', 'FA_BOOKS', p_log_level_rec => p_log_level_rec);

1719: RETURNING transaction_header_id_in BULK COLLECT INTO t_old_thid;
1720:
1721: else
1722: if (p_log_level_rec.statement_level) then
1723: fa_debug_pkg.add(l_calling_fn,'Deactivating ', 'FA_BOOKS', p_log_level_rec => p_log_level_rec);
1724: end if;
1725:
1726: FORALL i in 1..t_request_id.count
1727: UPDATE FA_BOOKS

Line 1739: fa_debug_pkg.add(l_calling_fn,'Inserting record into ', 'FA_BOOKS_MRC_V', p_log_level_rec => p_log_level_rec);

1735: -- Insert books
1736:
1737: if (p_mrc_sob_type_code = 'R') then
1738: if (p_log_level_rec.statement_level) then
1739: fa_debug_pkg.add(l_calling_fn,'Inserting record into ', 'FA_BOOKS_MRC_V', p_log_level_rec => p_log_level_rec);
1740: end if;
1741:
1742: FORALL i in 1..t_request_id.count
1743: INSERT INTO FA_MC_BOOKS( SET_OF_BOOKS_ID

Line 1979: fa_debug_pkg.add(l_calling_fn,'Inserting record into ', 'FA_BOOKS', p_log_level_rec => p_log_level_rec);

1975: and SET_OF_BOOKS_ID = p_set_of_books_id ;
1976:
1977: else
1978: if (p_log_level_rec.statement_level) then
1979: fa_debug_pkg.add(l_calling_fn,'Inserting record into ', 'FA_BOOKS', p_log_level_rec => p_log_level_rec);
1980: end if;
1981:
1982: FORALL i in 1..t_request_id.count
1983: INSERT INTO FA_BOOKS( BOOK_TYPE_CODE

Line 2240: fa_debug_pkg.add(l_calling_fn,'Reached Commit ', ' ', p_log_level_rec => p_log_level_rec);

2236: WHERE TRANSACTION_HEADER_ID_IN = t_old_thid(i);
2237: end if;
2238:
2239: if (p_log_level_rec.statement_level) then
2240: fa_debug_pkg.add(l_calling_fn,'Reached Commit ', ' ', p_log_level_rec => p_log_level_rec);
2241: end if;
2242:
2243: -- COMMIT;
2244:

Line 2252: fa_debug_pkg.add(l_calling_fn,'Process Posting', 'END', p_log_level_rec => p_log_level_rec);

2248: --
2249: --
2250:
2251: if (p_log_level_rec.statement_level) then
2252: fa_debug_pkg.add(l_calling_fn,'Process Posting', 'END', p_log_level_rec => p_log_level_rec);
2253: end if;
2254:
2255: return true;
2256:

Line 2261: fa_debug_pkg.add(l_calling_fn,'EXCEPTION', 'pos_err', p_log_level_rec => p_log_level_rec);

2257: EXCEPTION
2258: WHEN pos_err THEN
2259:
2260: if (p_log_level_rec.statement_level) then
2261: fa_debug_pkg.add(l_calling_fn,'EXCEPTION', 'pos_err', p_log_level_rec => p_log_level_rec);
2262: fa_debug_pkg.add(l_calling_fn,'sqlerrm', substrb(sqlerrm, 1, 200));
2263: end if;
2264:
2265: return false;

Line 2262: fa_debug_pkg.add(l_calling_fn,'sqlerrm', substrb(sqlerrm, 1, 200));

2258: WHEN pos_err THEN
2259:
2260: if (p_log_level_rec.statement_level) then
2261: fa_debug_pkg.add(l_calling_fn,'EXCEPTION', 'pos_err', p_log_level_rec => p_log_level_rec);
2262: fa_debug_pkg.add(l_calling_fn,'sqlerrm', substrb(sqlerrm, 1, 200));
2263: end if;
2264:
2265: return false;
2266:

Line 2270: fa_debug_pkg.add(l_calling_fn,'EXCEPTION', 'OTHERS', p_log_level_rec => p_log_level_rec);

2266:
2267: WHEN OTHERS THEN
2268:
2269: if (p_log_level_rec.statement_level) then
2270: fa_debug_pkg.add(l_calling_fn,'EXCEPTION', 'OTHERS', p_log_level_rec => p_log_level_rec);
2271: fa_debug_pkg.add(l_calling_fn,'sqlerrm', substrb(sqlerrm, 1, 200));
2272: end if;
2273:
2274: return false;

Line 2271: fa_debug_pkg.add(l_calling_fn,'sqlerrm', substrb(sqlerrm, 1, 200));

2267: WHEN OTHERS THEN
2268:
2269: if (p_log_level_rec.statement_level) then
2270: fa_debug_pkg.add(l_calling_fn,'EXCEPTION', 'OTHERS', p_log_level_rec => p_log_level_rec);
2271: fa_debug_pkg.add(l_calling_fn,'sqlerrm', substrb(sqlerrm, 1, 200));
2272: end if;
2273:
2274: return false;
2275:

Line 2341: fa_debug_pkg.add(l_calling_fn, 'Begin', p_asset_hdr_rec.asset_id, p_log_level_rec => p_log_level_rec);

2337:
2338: BEGIN
2339:
2340: if (p_log_level_rec.statement_level) then
2341: fa_debug_pkg.add(l_calling_fn, 'Begin', p_asset_hdr_rec.asset_id, p_log_level_rec => p_log_level_rec);
2342: end if;
2343:
2344: l_period_rec.period_counter := p_period_rec.period_counter + 1;
2345:

Line 2457: fa_debug_pkg.add(l_calling_fn, 'Error calling', 'fa_cache_pkg.fazcct', p_log_level_rec => p_log_level_rec);

2453: l_running_mode := fa_std_types.FA_DPR_NORMAL;
2454:
2455: if not fa_cache_pkg.fazcct(fa_cache_pkg.fazcbc_record.deprn_calendar, p_log_level_rec => p_log_level_rec) then
2456: if (p_log_level_rec.statement_level) then
2457: fa_debug_pkg.add(l_calling_fn, 'Error calling', 'fa_cache_pkg.fazcct', p_log_level_rec => p_log_level_rec);
2458: end if;
2459:
2460: raise db_err;
2461: end if;

Line 2470: fa_debug_pkg.add(l_calling_fn, 'Error calling',

2466: l_temp_number,
2467: l_dpr_in.y_begin,
2468: l_temp_integer, p_log_level_rec => p_log_level_rec) then
2469: if (p_log_level_rec.statement_level) then
2470: fa_debug_pkg.add(l_calling_fn, 'Error calling',
2471: 'fa_cache_pkg.fazccp', p_log_level_rec => p_log_level_rec);
2472: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.prorate_calendar',
2473: fa_cache_pkg.fazcbc_record.prorate_calendar, p_log_level_rec => p_log_level_rec);
2474: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.fiscal_year_name',

Line 2472: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.prorate_calendar',

2468: l_temp_integer, p_log_level_rec => p_log_level_rec) then
2469: if (p_log_level_rec.statement_level) then
2470: fa_debug_pkg.add(l_calling_fn, 'Error calling',
2471: 'fa_cache_pkg.fazccp', p_log_level_rec => p_log_level_rec);
2472: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.prorate_calendar',
2473: fa_cache_pkg.fazcbc_record.prorate_calendar, p_log_level_rec => p_log_level_rec);
2474: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.fiscal_year_name',
2475: fa_cache_pkg.fazcbc_record.fiscal_year_name, p_log_level_rec => p_log_level_rec);
2476: end if;

Line 2474: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.fiscal_year_name',

2470: fa_debug_pkg.add(l_calling_fn, 'Error calling',
2471: 'fa_cache_pkg.fazccp', p_log_level_rec => p_log_level_rec);
2472: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.prorate_calendar',
2473: fa_cache_pkg.fazcbc_record.prorate_calendar, p_log_level_rec => p_log_level_rec);
2474: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.fiscal_year_name',
2475: fa_cache_pkg.fazcbc_record.fiscal_year_name, p_log_level_rec => p_log_level_rec);
2476: end if;
2477:
2478: raise db_err;

Line 2484: fa_debug_pkg.add(l_calling_fn, 'number_per_fiscal_year',

2480:
2481: l_dpr_in.p_cl_begin := 1;
2482:
2483: if (p_log_level_rec.statement_level) then
2484: fa_debug_pkg.add(l_calling_fn, 'number_per_fiscal_year',
2485: fa_cache_pkg.fazcct_record.number_per_fiscal_year, p_log_level_rec => p_log_level_rec);
2486: fa_debug_pkg.add(l_calling_fn, 'l_period_rec.period_num', l_period_rec.period_num, p_log_level_rec => p_log_level_rec);
2487: end if;
2488:

Line 2486: fa_debug_pkg.add(l_calling_fn, 'l_period_rec.period_num', l_period_rec.period_num, p_log_level_rec => p_log_level_rec);

2482:
2483: if (p_log_level_rec.statement_level) then
2484: fa_debug_pkg.add(l_calling_fn, 'number_per_fiscal_year',
2485: fa_cache_pkg.fazcct_record.number_per_fiscal_year, p_log_level_rec => p_log_level_rec);
2486: fa_debug_pkg.add(l_calling_fn, 'l_period_rec.period_num', l_period_rec.period_num, p_log_level_rec => p_log_level_rec);
2487: end if;
2488:
2489: if (l_period_rec.period_num = 1) then
2490: l_dpr_in.y_end := l_period_rec.fiscal_year - 1;

Line 2498: fa_debug_pkg.add(l_calling_fn, 'l_dpr_in.p_cl_end', l_dpr_in.p_cl_end, p_log_level_rec => p_log_level_rec);

2494: l_dpr_in.p_cl_end := l_period_rec.period_num - 1;
2495: end if;
2496:
2497: if (p_log_level_rec.statement_level) then
2498: fa_debug_pkg.add(l_calling_fn, 'l_dpr_in.p_cl_end', l_dpr_in.p_cl_end, p_log_level_rec => p_log_level_rec);
2499: end if;
2500:
2501: l_dpr_in.rate_adj_factor := 1;
2502:

Line 2509: fa_debug_pkg.add(l_calling_fn, 'Error calling',

2505: if (not fa_cache_pkg.fazccmt(
2506: l_asset_fin_rec_new.deprn_method_code,
2507: l_asset_fin_rec_new.life_in_months, p_log_level_rec => p_log_level_rec)) then
2508: if (p_log_level_rec.statement_level) then
2509: fa_debug_pkg.add(l_calling_fn, 'Error calling',
2510: 'fa_cache_pkg.fazccmt', p_log_level_rec => p_log_level_rec);
2511: end if;
2512:
2513: raise db_err;

Line 2537: fa_debug_pkg.add(l_calling_fn, 'Error calling',

2533: l_dpr_arr,
2534: l_dpr_out,
2535: l_running_mode, p_log_level_rec => p_log_level_rec) then
2536: if (p_log_level_rec.statement_level) then
2537: fa_debug_pkg.add(l_calling_fn, 'Error calling',
2538: 'FA_CDE_PKG.faxcde', p_log_level_rec => p_log_level_rec);
2539: end if;
2540:
2541: raise db_err;

Line 2617: fa_debug_pkg.add(l_calling_fn,'call_deprn_basis', 'END', p_log_level_rec => p_log_level_rec);

2613: raise db_err;
2614: end if;
2615:
2616: if (p_log_level_rec.statement_level) then
2617: fa_debug_pkg.add(l_calling_fn,'call_deprn_basis', 'END', p_log_level_rec => p_log_level_rec);
2618: end if;
2619:
2620: return true;
2621:

Line 2626: fa_debug_pkg.add(l_calling_fn,'EXCEPTION', 'pos_err', p_log_level_rec => p_log_level_rec);

2622: EXCEPTION
2623: WHEN db_err THEN
2624:
2625: if (p_log_level_rec.statement_level) then
2626: fa_debug_pkg.add(l_calling_fn,'EXCEPTION', 'pos_err', p_log_level_rec => p_log_level_rec);
2627: fa_debug_pkg.add(l_calling_fn,'sqlerrm', substrb(sqlerrm, 1, 200));
2628: end if;
2629:
2630: return false;

Line 2627: fa_debug_pkg.add(l_calling_fn,'sqlerrm', substrb(sqlerrm, 1, 200));

2623: WHEN db_err THEN
2624:
2625: if (p_log_level_rec.statement_level) then
2626: fa_debug_pkg.add(l_calling_fn,'EXCEPTION', 'pos_err', p_log_level_rec => p_log_level_rec);
2627: fa_debug_pkg.add(l_calling_fn,'sqlerrm', substrb(sqlerrm, 1, 200));
2628: end if;
2629:
2630: return false;
2631:

Line 2635: fa_debug_pkg.add(l_calling_fn,'EXCEPTION', 'OTHERS', p_log_level_rec => p_log_level_rec);

2631:
2632: WHEN OTHERS THEN
2633:
2634: if (p_log_level_rec.statement_level) then
2635: fa_debug_pkg.add(l_calling_fn,'EXCEPTION', 'OTHERS', p_log_level_rec => p_log_level_rec);
2636: fa_debug_pkg.add(l_calling_fn,'sqlerrm', substrb(sqlerrm, 1, 200));
2637: end if;
2638:
2639: return false;

Line 2636: fa_debug_pkg.add(l_calling_fn,'sqlerrm', substrb(sqlerrm, 1, 200));

2632: WHEN OTHERS THEN
2633:
2634: if (p_log_level_rec.statement_level) then
2635: fa_debug_pkg.add(l_calling_fn,'EXCEPTION', 'OTHERS', p_log_level_rec => p_log_level_rec);
2636: fa_debug_pkg.add(l_calling_fn,'sqlerrm', substrb(sqlerrm, 1, 200));
2637: end if;
2638:
2639: return false;
2640: END call_deprn_basis;

Line 2660: fa_debug_pkg.add(l_calling_fn,'Begin', p_asset_hdr_rec.asset_id, p_log_level_rec => p_log_level_rec);

2656:
2657: cre_err exception;
2658: BEGIN
2659: if (p_log_level_rec.statement_level) then
2660: fa_debug_pkg.add(l_calling_fn,'Begin', p_asset_hdr_rec.asset_id, p_log_level_rec => p_log_level_rec);
2661: end if;
2662:
2663: -- Initializing common variables
2664: l_adj.transaction_header_id := p_trans_rec.transaction_header_id;

Line 2701: fa_debug_pkg.add(l_calling_fn,'calling faxinaj ', 'COST', p_log_level_rec => p_log_level_rec);

2697: l_adj.mrc_sob_type_code := p_mrc_sob_type_code;
2698: l_adj.set_of_books_id := p_asset_hdr_rec.set_of_books_id;
2699:
2700: if (p_log_level_rec.statement_level) then
2701: fa_debug_pkg.add(l_calling_fn,'calling faxinaj ', 'COST', p_log_level_rec => p_log_level_rec);
2702: end if;
2703:
2704:
2705: if not FA_INS_ADJUST_PKG.faxinaj

Line 2734: fa_debug_pkg.add(l_calling_fn,'calling faxinaj ', 'CLEARING', p_log_level_rec => p_log_level_rec);

2730:
2731: l_adj.mrc_sob_type_code := p_mrc_sob_type_code;
2732:
2733: if (p_log_level_rec.statement_level) then
2734: fa_debug_pkg.add(l_calling_fn,'calling faxinaj ', 'CLEARING', p_log_level_rec => p_log_level_rec);
2735: end if;
2736:
2737: if not FA_INS_ADJUST_PKG.faxinaj
2738: (l_adj,

Line 2747: fa_debug_pkg.add(l_calling_fn,'End', p_asset_hdr_rec.asset_id, p_log_level_rec => p_log_level_rec);

2743: end if;
2744:
2745:
2746: if (p_log_level_rec.statement_level) then
2747: fa_debug_pkg.add(l_calling_fn,'End', p_asset_hdr_rec.asset_id, p_log_level_rec => p_log_level_rec);
2748: end if;
2749:
2750: return true;
2751:

Line 2756: fa_debug_pkg.add(l_calling_fn,'EXCEPTION', 'cre_err', p_log_level_rec => p_log_level_rec);

2752: EXCEPTION
2753: WHEN cre_err THEN
2754:
2755: if (p_log_level_rec.statement_level) then
2756: fa_debug_pkg.add(l_calling_fn,'EXCEPTION', 'cre_err', p_log_level_rec => p_log_level_rec);
2757: fa_debug_pkg.add(l_calling_fn,'sqlerrm', substrb(sqlerrm, 1, 200));
2758: end if;
2759:
2760: return false;

Line 2757: fa_debug_pkg.add(l_calling_fn,'sqlerrm', substrb(sqlerrm, 1, 200));

2753: WHEN cre_err THEN
2754:
2755: if (p_log_level_rec.statement_level) then
2756: fa_debug_pkg.add(l_calling_fn,'EXCEPTION', 'cre_err', p_log_level_rec => p_log_level_rec);
2757: fa_debug_pkg.add(l_calling_fn,'sqlerrm', substrb(sqlerrm, 1, 200));
2758: end if;
2759:
2760: return false;
2761:

Line 2765: fa_debug_pkg.add(l_calling_fn,'EXCEPTION', 'OTHERS', p_log_level_rec => p_log_level_rec);

2761:
2762: WHEN OTHERS THEN
2763:
2764: if (p_log_level_rec.statement_level) then
2765: fa_debug_pkg.add(l_calling_fn,'EXCEPTION', 'OTHERS', p_log_level_rec => p_log_level_rec);
2766: fa_debug_pkg.add(l_calling_fn,'sqlerrm', substrb(sqlerrm, 1, 200));
2767: end if;
2768:
2769: return false;

Line 2766: fa_debug_pkg.add(l_calling_fn,'sqlerrm', substrb(sqlerrm, 1, 200));

2762: WHEN OTHERS THEN
2763:
2764: if (p_log_level_rec.statement_level) then
2765: fa_debug_pkg.add(l_calling_fn,'EXCEPTION', 'OTHERS', p_log_level_rec => p_log_level_rec);
2766: fa_debug_pkg.add(l_calling_fn,'sqlerrm', substrb(sqlerrm, 1, 200));
2767: end if;
2768:
2769: return false;
2770: