176: raise cache_err;
177: end if;
178: end if;
179:
180: --fa_rx_conc_mesg_pkg.log('Hello World');
181:
182: ret := TRUE;
183: h_arc_change_flag := FALSE;
184:
385: dpr_in.formula_factor := 1;
386:
387: else -- HYPOTHETICAL
388:
389: --fa_rx_conc_mesg_pkg.log('step 1');
390:
391: -- RUNNING IN HYPOTHETICAL MODE. ASSET DOESN'T EXIST,
392: -- SO ALL BOOKS INFO HAD TO BE PASSED INTO THIS FUNCTION.
393:
392: -- SO ALL BOOKS INFO HAD TO BE PASSED INTO THIS FUNCTION.
393:
394: h_mesg_name := 'FA_AMT_BD_DPR_STRUCT';
395:
396: --fa_rx_conc_mesg_pkg.log('step 1.1');
397: SELECT cbd.life_in_months,
398: cbd.deprn_method,
399: cbd.prorate_convention_code,
400: cbd.adjusted_rate,
411: AND cbd.category_id = X_category_id
412: AND X_dpis BETWEEN CBD.START_DPIS AND
413: NVL(CBD.END_DPIS,TO_DATE('31-12-4712','DD-MM-YYYY'));
414:
415: --fa_rx_conc_mesg_pkg.log('step 1.2');
416: --fa_rx_conc_mesg_pkg.log(h_prorate_conv);
417:
418: if X_prorate_conv is not null then
419: h_prorate_conv := X_prorate_conv;
412: AND X_dpis BETWEEN CBD.START_DPIS AND
413: NVL(CBD.END_DPIS,TO_DATE('31-12-4712','DD-MM-YYYY'));
414:
415: --fa_rx_conc_mesg_pkg.log('step 1.2');
416: --fa_rx_conc_mesg_pkg.log(h_prorate_conv);
417:
418: if X_prorate_conv is not null then
419: h_prorate_conv := X_prorate_conv;
420: end if;
425: FROM fa_conventions conv
426: WHERE conv.prorate_convention_code = h_prorate_conv
427: AND X_dpis between conv.start_date and conv.end_date;
428:
429: --fa_rx_conc_mesg_pkg.log('step 1.3');
430: if (X_prorate_date is not null) then
431: dpr_in.prorate_jdate := to_number(to_char(X_prorate_date,'J'));
432: end if;
433:
453:
454: dpr_in.rec_cost := X_cost - nvl(dpr_in.salvage_value,0);
455: dpr_in.adj_cost := dpr_in.rec_cost;
456:
457: --fa_rx_conc_mesg_pkg.log('step 1.4');
458: if (X_rec_cost is not null) then
459: dpr_in.rec_cost := X_rec_cost;
460: end if;
461:
464: dpr_in.adj_cost := X_adj_cost;
465: end if;
466:
467:
468: --fa_rx_conc_mesg_pkg.log('step 1.5');
469:
470: dpr_in.reval_amo_basis := NULL;
471: dpr_in.rate_adj_factor := 1;
472:
469:
470: dpr_in.reval_amo_basis := NULL;
471: dpr_in.rate_adj_factor := 1;
472:
473: --fa_rx_conc_mesg_pkg.log('step 1.6');
474:
475: if (X_adj_rate is not null) then
476: dpr_in.adj_rate := X_adj_rate;
477: dpr_in.life := NULL;
487:
488: dpr_in.capacity := NULL;
489: dpr_in.adj_capacity := NULL;
490:
491: --fa_rx_conc_mesg_pkg.log('step 1.7');
492: if (X_method_code is not null) then
493: dpr_in.method_code := X_method_code;
494: end if;
495:
502: dpr_in.adj_rec_cost := dpr_in.rec_cost;
503:
504: dpr_in.formula_factor := 1;
505:
506: --fa_rx_conc_mesg_pkg.log('step 1.8');
507: dpr_in.pc_life_end := NULL;
508: dpr_in.deprn_rounding_flag := NULL;
509: h_current_cost := X_cost;
510: end if; --X_mode <> 'HYPOTHETICAL' then
528: dpr_in.p_cl_begin := fa_cache_pkg.fazcdp_record.period_num;
529: dpr_in.y_begin := fa_cache_pkg.fazcdp_record.fiscal_year;
530: h_deprn_run := fa_cache_pkg.fazcdp_record.deprn_run;
531:
532: --fa_rx_conc_mesg_pkg.log('step 2111');
533:
534: if X_mode in ('EXPENSED','AMORTIZED') then
535:
536: -- IF WE'RE DOING ADJUSTMENT, NEED TO LOAD A FIN_INFO
634: end if;
635:
636: else -- X_method_code not populated .. just propagate asset's current
637: -- state to fin_info
638: --fa_rx_conc_mesg_pkg.log('step 2');
639:
640: fin_info.method_code := dpr_in.method_code;
641: fin_info.life := dpr_in.life;
642: fin_info.adj_rate := dpr_in.adj_rate;
642: fin_info.adj_rate := dpr_in.adj_rate;
643:
644: end if; -- (X_method_code is not null)
645:
646: --fa_rx_conc_mesg_pkg.log('step 3');
647:
648: if (X_ceiling_name is not null) then
649: fin_info.ceiling_name := X_ceiling_name;
650: dpr_in.ceil_name := X_ceiling_name;
729: --dpr_row.mrc_sob_type_code := 'P';
730: dpr_row.mrc_sob_type_code := FARX_C_WD.mrc_sob_type; -- Enhancement Bug 3037321
731: dpr_row.set_of_books_id := FARX_C_WD.sob_id;
732:
733: --fa_rx_conc_mesg_pkg.log('step 4');
734:
735: if not fa_cache_pkg.fazcbc_clr(X_BOOK => X_BOOK) then
736: return (FALSE);
737: end if;
763:
764: fa_srvr_msg.get_message(mesg_count,mesg1,mesg2,mesg3,mesg4,
765: mesg5,mesg6,mesg7);
766:
767: fa_rx_conc_mesg_pkg.log(mesg1);
768: fa_rx_conc_mesg_pkg.log(mesg2);
769: fa_rx_conc_mesg_pkg.log(mesg3);
770: fa_rx_conc_mesg_pkg.log(mesg4);
771: fa_rx_conc_mesg_pkg.log(mesg5);
764: fa_srvr_msg.get_message(mesg_count,mesg1,mesg2,mesg3,mesg4,
765: mesg5,mesg6,mesg7);
766:
767: fa_rx_conc_mesg_pkg.log(mesg1);
768: fa_rx_conc_mesg_pkg.log(mesg2);
769: fa_rx_conc_mesg_pkg.log(mesg3);
770: fa_rx_conc_mesg_pkg.log(mesg4);
771: fa_rx_conc_mesg_pkg.log(mesg5);
772: fa_rx_conc_mesg_pkg.log(mesg6);
765: mesg5,mesg6,mesg7);
766:
767: fa_rx_conc_mesg_pkg.log(mesg1);
768: fa_rx_conc_mesg_pkg.log(mesg2);
769: fa_rx_conc_mesg_pkg.log(mesg3);
770: fa_rx_conc_mesg_pkg.log(mesg4);
771: fa_rx_conc_mesg_pkg.log(mesg5);
772: fa_rx_conc_mesg_pkg.log(mesg6);
773: fa_rx_conc_mesg_pkg.log(mesg7);
766:
767: fa_rx_conc_mesg_pkg.log(mesg1);
768: fa_rx_conc_mesg_pkg.log(mesg2);
769: fa_rx_conc_mesg_pkg.log(mesg3);
770: fa_rx_conc_mesg_pkg.log(mesg4);
771: fa_rx_conc_mesg_pkg.log(mesg5);
772: fa_rx_conc_mesg_pkg.log(mesg6);
773: fa_rx_conc_mesg_pkg.log(mesg7);
774:
767: fa_rx_conc_mesg_pkg.log(mesg1);
768: fa_rx_conc_mesg_pkg.log(mesg2);
769: fa_rx_conc_mesg_pkg.log(mesg3);
770: fa_rx_conc_mesg_pkg.log(mesg4);
771: fa_rx_conc_mesg_pkg.log(mesg5);
772: fa_rx_conc_mesg_pkg.log(mesg6);
773: fa_rx_conc_mesg_pkg.log(mesg7);
774:
775:
768: fa_rx_conc_mesg_pkg.log(mesg2);
769: fa_rx_conc_mesg_pkg.log(mesg3);
770: fa_rx_conc_mesg_pkg.log(mesg4);
771: fa_rx_conc_mesg_pkg.log(mesg5);
772: fa_rx_conc_mesg_pkg.log(mesg6);
773: fa_rx_conc_mesg_pkg.log(mesg7);
774:
775:
776: x_return_status := 2;
769: fa_rx_conc_mesg_pkg.log(mesg3);
770: fa_rx_conc_mesg_pkg.log(mesg4);
771: fa_rx_conc_mesg_pkg.log(mesg5);
772: fa_rx_conc_mesg_pkg.log(mesg6);
773: fa_rx_conc_mesg_pkg.log(mesg7);
774:
775:
776: x_return_status := 2;
777: return (FALSE);
776: x_return_status := 2;
777: return (FALSE);
778: end if;
779:
780: --fa_rx_conc_mesg_pkg.log('step 5');
781:
782: -- Recoverable cost requires special treatment if there's a ceiling and/or
783: -- ITC amount.
784:
817: where ir.itc_amount_id = h_itc_amount_id;
818:
819: end if;
820:
821: --fa_rx_conc_mesg_pkg.log('step 6');
822:
823: h_mesg_name := 'FA_WHATIF_NO_METHOD';
824:
825: --
836:
837: -- ADJ_REC_COST DEPENDENT ON WHETHER WE'RE USING DEPRN_LIMITS
838: h_mesg_name := 'FA_MAP_SV_DL_ERROR';
839:
840: --fa_rx_conc_mesg_pkg.log('step 7');
841:
842: SELECT CBD.USE_DEPRN_LIMITS_FLAG
843: , CBD.ALLOWED_DEPRN_LIMIT
844: , CBD.SPECIAL_DEPRN_LIMIT_AMOUNT
873:
874: dpr_in.adj_rec_cost := h_adjusted_rec_cost;
875: fin_info.adj_rec_cost := h_adjusted_rec_cost;
876:
877: --fa_rx_conc_mesg_pkg.log('step 7');
878:
879: if fnd_profile.value('PRINT_DEBUG') = 'Y' then
880: fa_rx_conc_mesg_pkg.log('FIN_INFO STRUCT:');
881: fa_rx_conc_mesg_pkg.log('asset_id: ' || fin_info.asset_id);
876:
877: --fa_rx_conc_mesg_pkg.log('step 7');
878:
879: if fnd_profile.value('PRINT_DEBUG') = 'Y' then
880: fa_rx_conc_mesg_pkg.log('FIN_INFO STRUCT:');
881: fa_rx_conc_mesg_pkg.log('asset_id: ' || fin_info.asset_id);
882: fa_rx_conc_mesg_pkg.log('category_id: ' || fin_info.category_id);
883: fa_rx_conc_mesg_pkg.log('transaction_id: ' || fin_info.transaction_id);
884: fa_rx_conc_mesg_pkg.log('jdate_in_svc: ' || fin_info.jdate_in_svc);
877: --fa_rx_conc_mesg_pkg.log('step 7');
878:
879: if fnd_profile.value('PRINT_DEBUG') = 'Y' then
880: fa_rx_conc_mesg_pkg.log('FIN_INFO STRUCT:');
881: fa_rx_conc_mesg_pkg.log('asset_id: ' || fin_info.asset_id);
882: fa_rx_conc_mesg_pkg.log('category_id: ' || fin_info.category_id);
883: fa_rx_conc_mesg_pkg.log('transaction_id: ' || fin_info.transaction_id);
884: fa_rx_conc_mesg_pkg.log('jdate_in_svc: ' || fin_info.jdate_in_svc);
885: fa_rx_conc_mesg_pkg.log('period_ctr: ' || fin_info.period_ctr);
878:
879: if fnd_profile.value('PRINT_DEBUG') = 'Y' then
880: fa_rx_conc_mesg_pkg.log('FIN_INFO STRUCT:');
881: fa_rx_conc_mesg_pkg.log('asset_id: ' || fin_info.asset_id);
882: fa_rx_conc_mesg_pkg.log('category_id: ' || fin_info.category_id);
883: fa_rx_conc_mesg_pkg.log('transaction_id: ' || fin_info.transaction_id);
884: fa_rx_conc_mesg_pkg.log('jdate_in_svc: ' || fin_info.jdate_in_svc);
885: fa_rx_conc_mesg_pkg.log('period_ctr: ' || fin_info.period_ctr);
886: fa_rx_conc_mesg_pkg.log('book: ' || fin_info.book);
879: if fnd_profile.value('PRINT_DEBUG') = 'Y' then
880: fa_rx_conc_mesg_pkg.log('FIN_INFO STRUCT:');
881: fa_rx_conc_mesg_pkg.log('asset_id: ' || fin_info.asset_id);
882: fa_rx_conc_mesg_pkg.log('category_id: ' || fin_info.category_id);
883: fa_rx_conc_mesg_pkg.log('transaction_id: ' || fin_info.transaction_id);
884: fa_rx_conc_mesg_pkg.log('jdate_in_svc: ' || fin_info.jdate_in_svc);
885: fa_rx_conc_mesg_pkg.log('period_ctr: ' || fin_info.period_ctr);
886: fa_rx_conc_mesg_pkg.log('book: ' || fin_info.book);
887: fa_rx_conc_mesg_pkg.log('asset_number: ' || fin_info.asset_number);
880: fa_rx_conc_mesg_pkg.log('FIN_INFO STRUCT:');
881: fa_rx_conc_mesg_pkg.log('asset_id: ' || fin_info.asset_id);
882: fa_rx_conc_mesg_pkg.log('category_id: ' || fin_info.category_id);
883: fa_rx_conc_mesg_pkg.log('transaction_id: ' || fin_info.transaction_id);
884: fa_rx_conc_mesg_pkg.log('jdate_in_svc: ' || fin_info.jdate_in_svc);
885: fa_rx_conc_mesg_pkg.log('period_ctr: ' || fin_info.period_ctr);
886: fa_rx_conc_mesg_pkg.log('book: ' || fin_info.book);
887: fa_rx_conc_mesg_pkg.log('asset_number: ' || fin_info.asset_number);
888: fa_rx_conc_mesg_pkg.log('asset_Type: ' || fin_info.asset_type);
881: fa_rx_conc_mesg_pkg.log('asset_id: ' || fin_info.asset_id);
882: fa_rx_conc_mesg_pkg.log('category_id: ' || fin_info.category_id);
883: fa_rx_conc_mesg_pkg.log('transaction_id: ' || fin_info.transaction_id);
884: fa_rx_conc_mesg_pkg.log('jdate_in_svc: ' || fin_info.jdate_in_svc);
885: fa_rx_conc_mesg_pkg.log('period_ctr: ' || fin_info.period_ctr);
886: fa_rx_conc_mesg_pkg.log('book: ' || fin_info.book);
887: fa_rx_conc_mesg_pkg.log('asset_number: ' || fin_info.asset_number);
888: fa_rx_conc_mesg_pkg.log('asset_Type: ' || fin_info.asset_type);
889: fa_rx_conc_mesg_pkg.log('date_placed_in_svc: ' ||
882: fa_rx_conc_mesg_pkg.log('category_id: ' || fin_info.category_id);
883: fa_rx_conc_mesg_pkg.log('transaction_id: ' || fin_info.transaction_id);
884: fa_rx_conc_mesg_pkg.log('jdate_in_svc: ' || fin_info.jdate_in_svc);
885: fa_rx_conc_mesg_pkg.log('period_ctr: ' || fin_info.period_ctr);
886: fa_rx_conc_mesg_pkg.log('book: ' || fin_info.book);
887: fa_rx_conc_mesg_pkg.log('asset_number: ' || fin_info.asset_number);
888: fa_rx_conc_mesg_pkg.log('asset_Type: ' || fin_info.asset_type);
889: fa_rx_conc_mesg_pkg.log('date_placed_in_svc: ' ||
890: to_char(fin_info.date_placed_in_svc,'DD-MM-YYYY'));
883: fa_rx_conc_mesg_pkg.log('transaction_id: ' || fin_info.transaction_id);
884: fa_rx_conc_mesg_pkg.log('jdate_in_svc: ' || fin_info.jdate_in_svc);
885: fa_rx_conc_mesg_pkg.log('period_ctr: ' || fin_info.period_ctr);
886: fa_rx_conc_mesg_pkg.log('book: ' || fin_info.book);
887: fa_rx_conc_mesg_pkg.log('asset_number: ' || fin_info.asset_number);
888: fa_rx_conc_mesg_pkg.log('asset_Type: ' || fin_info.asset_type);
889: fa_rx_conc_mesg_pkg.log('date_placed_in_svc: ' ||
890: to_char(fin_info.date_placed_in_svc,'DD-MM-YYYY'));
891: fa_rx_conc_mesg_pkg.log('prorate_date: ' ||
884: fa_rx_conc_mesg_pkg.log('jdate_in_svc: ' || fin_info.jdate_in_svc);
885: fa_rx_conc_mesg_pkg.log('period_ctr: ' || fin_info.period_ctr);
886: fa_rx_conc_mesg_pkg.log('book: ' || fin_info.book);
887: fa_rx_conc_mesg_pkg.log('asset_number: ' || fin_info.asset_number);
888: fa_rx_conc_mesg_pkg.log('asset_Type: ' || fin_info.asset_type);
889: fa_rx_conc_mesg_pkg.log('date_placed_in_svc: ' ||
890: to_char(fin_info.date_placed_in_svc,'DD-MM-YYYY'));
891: fa_rx_conc_mesg_pkg.log('prorate_date: ' ||
892: to_char(fin_info.prorate_date,'DD-MM-YYYY'));
885: fa_rx_conc_mesg_pkg.log('period_ctr: ' || fin_info.period_ctr);
886: fa_rx_conc_mesg_pkg.log('book: ' || fin_info.book);
887: fa_rx_conc_mesg_pkg.log('asset_number: ' || fin_info.asset_number);
888: fa_rx_conc_mesg_pkg.log('asset_Type: ' || fin_info.asset_type);
889: fa_rx_conc_mesg_pkg.log('date_placed_in_svc: ' ||
890: to_char(fin_info.date_placed_in_svc,'DD-MM-YYYY'));
891: fa_rx_conc_mesg_pkg.log('prorate_date: ' ||
892: to_char(fin_info.prorate_date,'DD-MM-YYYY'));
893: fa_rx_conc_mesg_pkg.log('deprn_start_date: ' ||
887: fa_rx_conc_mesg_pkg.log('asset_number: ' || fin_info.asset_number);
888: fa_rx_conc_mesg_pkg.log('asset_Type: ' || fin_info.asset_type);
889: fa_rx_conc_mesg_pkg.log('date_placed_in_svc: ' ||
890: to_char(fin_info.date_placed_in_svc,'DD-MM-YYYY'));
891: fa_rx_conc_mesg_pkg.log('prorate_date: ' ||
892: to_char(fin_info.prorate_date,'DD-MM-YYYY'));
893: fa_rx_conc_mesg_pkg.log('deprn_start_date: ' ||
894: to_char(fin_info.deprn_start_date,'DD-MM-YYYY'));
895: fa_rx_conc_mesg_pkg.log('ceiling_name: ' || fin_info.ceiling_name);
889: fa_rx_conc_mesg_pkg.log('date_placed_in_svc: ' ||
890: to_char(fin_info.date_placed_in_svc,'DD-MM-YYYY'));
891: fa_rx_conc_mesg_pkg.log('prorate_date: ' ||
892: to_char(fin_info.prorate_date,'DD-MM-YYYY'));
893: fa_rx_conc_mesg_pkg.log('deprn_start_date: ' ||
894: to_char(fin_info.deprn_start_date,'DD-MM-YYYY'));
895: fa_rx_conc_mesg_pkg.log('ceiling_name: ' || fin_info.ceiling_name);
896: fa_rx_conc_mesg_pkg.log('bonus_rule: ' || fin_info.bonus_rule);
897: fa_rx_conc_mesg_pkg.log('current_time: ' ||
891: fa_rx_conc_mesg_pkg.log('prorate_date: ' ||
892: to_char(fin_info.prorate_date,'DD-MM-YYYY'));
893: fa_rx_conc_mesg_pkg.log('deprn_start_date: ' ||
894: to_char(fin_info.deprn_start_date,'DD-MM-YYYY'));
895: fa_rx_conc_mesg_pkg.log('ceiling_name: ' || fin_info.ceiling_name);
896: fa_rx_conc_mesg_pkg.log('bonus_rule: ' || fin_info.bonus_rule);
897: fa_rx_conc_mesg_pkg.log('current_time: ' ||
898: to_char(fin_info.current_time,'DD-MM-YYYY'));
899: fa_rx_conc_mesg_pkg.log('method_code: ' || fin_info.method_code);
892: to_char(fin_info.prorate_date,'DD-MM-YYYY'));
893: fa_rx_conc_mesg_pkg.log('deprn_start_date: ' ||
894: to_char(fin_info.deprn_start_date,'DD-MM-YYYY'));
895: fa_rx_conc_mesg_pkg.log('ceiling_name: ' || fin_info.ceiling_name);
896: fa_rx_conc_mesg_pkg.log('bonus_rule: ' || fin_info.bonus_rule);
897: fa_rx_conc_mesg_pkg.log('current_time: ' ||
898: to_char(fin_info.current_time,'DD-MM-YYYY'));
899: fa_rx_conc_mesg_pkg.log('method_code: ' || fin_info.method_code);
900: fa_rx_conc_mesg_pkg.log('cost: ' || fin_info.cost);
893: fa_rx_conc_mesg_pkg.log('deprn_start_date: ' ||
894: to_char(fin_info.deprn_start_date,'DD-MM-YYYY'));
895: fa_rx_conc_mesg_pkg.log('ceiling_name: ' || fin_info.ceiling_name);
896: fa_rx_conc_mesg_pkg.log('bonus_rule: ' || fin_info.bonus_rule);
897: fa_rx_conc_mesg_pkg.log('current_time: ' ||
898: to_char(fin_info.current_time,'DD-MM-YYYY'));
899: fa_rx_conc_mesg_pkg.log('method_code: ' || fin_info.method_code);
900: fa_rx_conc_mesg_pkg.log('cost: ' || fin_info.cost);
901: fa_rx_conc_mesg_pkg.log('old_cost: ' || fin_info.old_cost);
895: fa_rx_conc_mesg_pkg.log('ceiling_name: ' || fin_info.ceiling_name);
896: fa_rx_conc_mesg_pkg.log('bonus_rule: ' || fin_info.bonus_rule);
897: fa_rx_conc_mesg_pkg.log('current_time: ' ||
898: to_char(fin_info.current_time,'DD-MM-YYYY'));
899: fa_rx_conc_mesg_pkg.log('method_code: ' || fin_info.method_code);
900: fa_rx_conc_mesg_pkg.log('cost: ' || fin_info.cost);
901: fa_rx_conc_mesg_pkg.log('old_cost: ' || fin_info.old_cost);
902: fa_rx_conc_mesg_pkg.log('rec_cost: ' || fin_info.rec_cost);
903: fa_rx_conc_mesg_pkg.log('adj_cost: ' || fin_info.adj_cost);
896: fa_rx_conc_mesg_pkg.log('bonus_rule: ' || fin_info.bonus_rule);
897: fa_rx_conc_mesg_pkg.log('current_time: ' ||
898: to_char(fin_info.current_time,'DD-MM-YYYY'));
899: fa_rx_conc_mesg_pkg.log('method_code: ' || fin_info.method_code);
900: fa_rx_conc_mesg_pkg.log('cost: ' || fin_info.cost);
901: fa_rx_conc_mesg_pkg.log('old_cost: ' || fin_info.old_cost);
902: fa_rx_conc_mesg_pkg.log('rec_cost: ' || fin_info.rec_cost);
903: fa_rx_conc_mesg_pkg.log('adj_cost: ' || fin_info.adj_cost);
904: fa_rx_conc_mesg_pkg.log('rate_adj_factor: ' || fin_info.rate_adj_Factor);
897: fa_rx_conc_mesg_pkg.log('current_time: ' ||
898: to_char(fin_info.current_time,'DD-MM-YYYY'));
899: fa_rx_conc_mesg_pkg.log('method_code: ' || fin_info.method_code);
900: fa_rx_conc_mesg_pkg.log('cost: ' || fin_info.cost);
901: fa_rx_conc_mesg_pkg.log('old_cost: ' || fin_info.old_cost);
902: fa_rx_conc_mesg_pkg.log('rec_cost: ' || fin_info.rec_cost);
903: fa_rx_conc_mesg_pkg.log('adj_cost: ' || fin_info.adj_cost);
904: fa_rx_conc_mesg_pkg.log('rate_adj_factor: ' || fin_info.rate_adj_Factor);
905: fa_rx_conc_mesg_pkg.log('adj_rate: ' || fin_info.adj_Rate);
898: to_char(fin_info.current_time,'DD-MM-YYYY'));
899: fa_rx_conc_mesg_pkg.log('method_code: ' || fin_info.method_code);
900: fa_rx_conc_mesg_pkg.log('cost: ' || fin_info.cost);
901: fa_rx_conc_mesg_pkg.log('old_cost: ' || fin_info.old_cost);
902: fa_rx_conc_mesg_pkg.log('rec_cost: ' || fin_info.rec_cost);
903: fa_rx_conc_mesg_pkg.log('adj_cost: ' || fin_info.adj_cost);
904: fa_rx_conc_mesg_pkg.log('rate_adj_factor: ' || fin_info.rate_adj_Factor);
905: fa_rx_conc_mesg_pkg.log('adj_rate: ' || fin_info.adj_Rate);
906: fa_rx_conc_mesg_pkg.log('units: ' || fin_info.units);
899: fa_rx_conc_mesg_pkg.log('method_code: ' || fin_info.method_code);
900: fa_rx_conc_mesg_pkg.log('cost: ' || fin_info.cost);
901: fa_rx_conc_mesg_pkg.log('old_cost: ' || fin_info.old_cost);
902: fa_rx_conc_mesg_pkg.log('rec_cost: ' || fin_info.rec_cost);
903: fa_rx_conc_mesg_pkg.log('adj_cost: ' || fin_info.adj_cost);
904: fa_rx_conc_mesg_pkg.log('rate_adj_factor: ' || fin_info.rate_adj_Factor);
905: fa_rx_conc_mesg_pkg.log('adj_rate: ' || fin_info.adj_Rate);
906: fa_rx_conc_mesg_pkg.log('units: ' || fin_info.units);
907: fa_rx_conc_mesg_pkg.log('reval_amo_basis: ' || fin_info.reval_amo_basis);
900: fa_rx_conc_mesg_pkg.log('cost: ' || fin_info.cost);
901: fa_rx_conc_mesg_pkg.log('old_cost: ' || fin_info.old_cost);
902: fa_rx_conc_mesg_pkg.log('rec_cost: ' || fin_info.rec_cost);
903: fa_rx_conc_mesg_pkg.log('adj_cost: ' || fin_info.adj_cost);
904: fa_rx_conc_mesg_pkg.log('rate_adj_factor: ' || fin_info.rate_adj_Factor);
905: fa_rx_conc_mesg_pkg.log('adj_rate: ' || fin_info.adj_Rate);
906: fa_rx_conc_mesg_pkg.log('units: ' || fin_info.units);
907: fa_rx_conc_mesg_pkg.log('reval_amo_basis: ' || fin_info.reval_amo_basis);
908: fa_rx_conc_mesg_pkg.log('capacity: ' || fin_info.capacity);
901: fa_rx_conc_mesg_pkg.log('old_cost: ' || fin_info.old_cost);
902: fa_rx_conc_mesg_pkg.log('rec_cost: ' || fin_info.rec_cost);
903: fa_rx_conc_mesg_pkg.log('adj_cost: ' || fin_info.adj_cost);
904: fa_rx_conc_mesg_pkg.log('rate_adj_factor: ' || fin_info.rate_adj_Factor);
905: fa_rx_conc_mesg_pkg.log('adj_rate: ' || fin_info.adj_Rate);
906: fa_rx_conc_mesg_pkg.log('units: ' || fin_info.units);
907: fa_rx_conc_mesg_pkg.log('reval_amo_basis: ' || fin_info.reval_amo_basis);
908: fa_rx_conc_mesg_pkg.log('capacity: ' || fin_info.capacity);
909: fa_rx_conc_mesg_pkg.log('adj_capacity: ' || fin_info.adj_capacity);
902: fa_rx_conc_mesg_pkg.log('rec_cost: ' || fin_info.rec_cost);
903: fa_rx_conc_mesg_pkg.log('adj_cost: ' || fin_info.adj_cost);
904: fa_rx_conc_mesg_pkg.log('rate_adj_factor: ' || fin_info.rate_adj_Factor);
905: fa_rx_conc_mesg_pkg.log('adj_rate: ' || fin_info.adj_Rate);
906: fa_rx_conc_mesg_pkg.log('units: ' || fin_info.units);
907: fa_rx_conc_mesg_pkg.log('reval_amo_basis: ' || fin_info.reval_amo_basis);
908: fa_rx_conc_mesg_pkg.log('capacity: ' || fin_info.capacity);
909: fa_rx_conc_mesg_pkg.log('adj_capacity: ' || fin_info.adj_capacity);
910: fa_rx_conc_mesg_pkg.log('life: ' || fin_info.life);
903: fa_rx_conc_mesg_pkg.log('adj_cost: ' || fin_info.adj_cost);
904: fa_rx_conc_mesg_pkg.log('rate_adj_factor: ' || fin_info.rate_adj_Factor);
905: fa_rx_conc_mesg_pkg.log('adj_rate: ' || fin_info.adj_Rate);
906: fa_rx_conc_mesg_pkg.log('units: ' || fin_info.units);
907: fa_rx_conc_mesg_pkg.log('reval_amo_basis: ' || fin_info.reval_amo_basis);
908: fa_rx_conc_mesg_pkg.log('capacity: ' || fin_info.capacity);
909: fa_rx_conc_mesg_pkg.log('adj_capacity: ' || fin_info.adj_capacity);
910: fa_rx_conc_mesg_pkg.log('life: ' || fin_info.life);
911: fa_rx_conc_mesg_pkg.log('adj_rec_cost: ' || fin_info.adj_rec_cost);
904: fa_rx_conc_mesg_pkg.log('rate_adj_factor: ' || fin_info.rate_adj_Factor);
905: fa_rx_conc_mesg_pkg.log('adj_rate: ' || fin_info.adj_Rate);
906: fa_rx_conc_mesg_pkg.log('units: ' || fin_info.units);
907: fa_rx_conc_mesg_pkg.log('reval_amo_basis: ' || fin_info.reval_amo_basis);
908: fa_rx_conc_mesg_pkg.log('capacity: ' || fin_info.capacity);
909: fa_rx_conc_mesg_pkg.log('adj_capacity: ' || fin_info.adj_capacity);
910: fa_rx_conc_mesg_pkg.log('life: ' || fin_info.life);
911: fa_rx_conc_mesg_pkg.log('adj_rec_cost: ' || fin_info.adj_rec_cost);
912: fa_rx_conc_mesg_pkg.log('salvage_value: ' || fin_info.salvage_value);
905: fa_rx_conc_mesg_pkg.log('adj_rate: ' || fin_info.adj_Rate);
906: fa_rx_conc_mesg_pkg.log('units: ' || fin_info.units);
907: fa_rx_conc_mesg_pkg.log('reval_amo_basis: ' || fin_info.reval_amo_basis);
908: fa_rx_conc_mesg_pkg.log('capacity: ' || fin_info.capacity);
909: fa_rx_conc_mesg_pkg.log('adj_capacity: ' || fin_info.adj_capacity);
910: fa_rx_conc_mesg_pkg.log('life: ' || fin_info.life);
911: fa_rx_conc_mesg_pkg.log('adj_rec_cost: ' || fin_info.adj_rec_cost);
912: fa_rx_conc_mesg_pkg.log('salvage_value: ' || fin_info.salvage_value);
913: fa_rx_conc_mesg_pkg.log('deprn_rounding_flag: '||fin_info.deprn_rounding_flag);
906: fa_rx_conc_mesg_pkg.log('units: ' || fin_info.units);
907: fa_rx_conc_mesg_pkg.log('reval_amo_basis: ' || fin_info.reval_amo_basis);
908: fa_rx_conc_mesg_pkg.log('capacity: ' || fin_info.capacity);
909: fa_rx_conc_mesg_pkg.log('adj_capacity: ' || fin_info.adj_capacity);
910: fa_rx_conc_mesg_pkg.log('life: ' || fin_info.life);
911: fa_rx_conc_mesg_pkg.log('adj_rec_cost: ' || fin_info.adj_rec_cost);
912: fa_rx_conc_mesg_pkg.log('salvage_value: ' || fin_info.salvage_value);
913: fa_rx_conc_mesg_pkg.log('deprn_rounding_flag: '||fin_info.deprn_rounding_flag);
914: end if;
907: fa_rx_conc_mesg_pkg.log('reval_amo_basis: ' || fin_info.reval_amo_basis);
908: fa_rx_conc_mesg_pkg.log('capacity: ' || fin_info.capacity);
909: fa_rx_conc_mesg_pkg.log('adj_capacity: ' || fin_info.adj_capacity);
910: fa_rx_conc_mesg_pkg.log('life: ' || fin_info.life);
911: fa_rx_conc_mesg_pkg.log('adj_rec_cost: ' || fin_info.adj_rec_cost);
912: fa_rx_conc_mesg_pkg.log('salvage_value: ' || fin_info.salvage_value);
913: fa_rx_conc_mesg_pkg.log('deprn_rounding_flag: '||fin_info.deprn_rounding_flag);
914: end if;
915:
908: fa_rx_conc_mesg_pkg.log('capacity: ' || fin_info.capacity);
909: fa_rx_conc_mesg_pkg.log('adj_capacity: ' || fin_info.adj_capacity);
910: fa_rx_conc_mesg_pkg.log('life: ' || fin_info.life);
911: fa_rx_conc_mesg_pkg.log('adj_rec_cost: ' || fin_info.adj_rec_cost);
912: fa_rx_conc_mesg_pkg.log('salvage_value: ' || fin_info.salvage_value);
913: fa_rx_conc_mesg_pkg.log('deprn_rounding_flag: '||fin_info.deprn_rounding_flag);
914: end if;
915:
916: -- Fix for Bug #1259562. Default formula_factor to 1.
909: fa_rx_conc_mesg_pkg.log('adj_capacity: ' || fin_info.adj_capacity);
910: fa_rx_conc_mesg_pkg.log('life: ' || fin_info.life);
911: fa_rx_conc_mesg_pkg.log('adj_rec_cost: ' || fin_info.adj_rec_cost);
912: fa_rx_conc_mesg_pkg.log('salvage_value: ' || fin_info.salvage_value);
913: fa_rx_conc_mesg_pkg.log('deprn_rounding_flag: '||fin_info.deprn_rounding_flag);
914: end if;
915:
916: -- Fix for Bug #1259562. Default formula_factor to 1.
917: if (fin_info.formula_factor is null) then
944:
945: fa_srvr_msg.get_message(mesg_count,mesg1,mesg2,mesg3,mesg4,
946: mesg5,mesg6,mesg7);
947:
948: fa_rx_conc_mesg_pkg.log(mesg1);
949: fa_rx_conc_mesg_pkg.log(mesg2);
950: fa_rx_conc_mesg_pkg.log(mesg3);
951: fa_rx_conc_mesg_pkg.log(mesg4);
952: fa_rx_conc_mesg_pkg.log(mesg5);
945: fa_srvr_msg.get_message(mesg_count,mesg1,mesg2,mesg3,mesg4,
946: mesg5,mesg6,mesg7);
947:
948: fa_rx_conc_mesg_pkg.log(mesg1);
949: fa_rx_conc_mesg_pkg.log(mesg2);
950: fa_rx_conc_mesg_pkg.log(mesg3);
951: fa_rx_conc_mesg_pkg.log(mesg4);
952: fa_rx_conc_mesg_pkg.log(mesg5);
953: fa_rx_conc_mesg_pkg.log(mesg6);
946: mesg5,mesg6,mesg7);
947:
948: fa_rx_conc_mesg_pkg.log(mesg1);
949: fa_rx_conc_mesg_pkg.log(mesg2);
950: fa_rx_conc_mesg_pkg.log(mesg3);
951: fa_rx_conc_mesg_pkg.log(mesg4);
952: fa_rx_conc_mesg_pkg.log(mesg5);
953: fa_rx_conc_mesg_pkg.log(mesg6);
954: fa_rx_conc_mesg_pkg.log(mesg7);
947:
948: fa_rx_conc_mesg_pkg.log(mesg1);
949: fa_rx_conc_mesg_pkg.log(mesg2);
950: fa_rx_conc_mesg_pkg.log(mesg3);
951: fa_rx_conc_mesg_pkg.log(mesg4);
952: fa_rx_conc_mesg_pkg.log(mesg5);
953: fa_rx_conc_mesg_pkg.log(mesg6);
954: fa_rx_conc_mesg_pkg.log(mesg7);
955:
948: fa_rx_conc_mesg_pkg.log(mesg1);
949: fa_rx_conc_mesg_pkg.log(mesg2);
950: fa_rx_conc_mesg_pkg.log(mesg3);
951: fa_rx_conc_mesg_pkg.log(mesg4);
952: fa_rx_conc_mesg_pkg.log(mesg5);
953: fa_rx_conc_mesg_pkg.log(mesg6);
954: fa_rx_conc_mesg_pkg.log(mesg7);
955:
956: x_return_status := 2;
949: fa_rx_conc_mesg_pkg.log(mesg2);
950: fa_rx_conc_mesg_pkg.log(mesg3);
951: fa_rx_conc_mesg_pkg.log(mesg4);
952: fa_rx_conc_mesg_pkg.log(mesg5);
953: fa_rx_conc_mesg_pkg.log(mesg6);
954: fa_rx_conc_mesg_pkg.log(mesg7);
955:
956: x_return_status := 2;
957: return (FALSE);
950: fa_rx_conc_mesg_pkg.log(mesg3);
951: fa_rx_conc_mesg_pkg.log(mesg4);
952: fa_rx_conc_mesg_pkg.log(mesg5);
953: fa_rx_conc_mesg_pkg.log(mesg6);
954: fa_rx_conc_mesg_pkg.log(mesg7);
955:
956: x_return_status := 2;
957: return (FALSE);
958: end if;
971: h_mesg_name := 'FA_WHATIF_ASSET_AMORTIZE_ERR';
972:
973:
974: if fnd_profile.value('PRINT_DEBUG') = 'Y' then
975: fa_rx_conc_mesg_pkg.log('old adj_cost: ' || to_char(dpr_in.adj_cost));
976: fa_rx_conc_mesg_pkg.log('old raf: ' || to_char(dpr_in.rate_adj_factor));
977: end if;
978:
979: if not fa_amort_pkg.faxama (fin_info,
972:
973:
974: if fnd_profile.value('PRINT_DEBUG') = 'Y' then
975: fa_rx_conc_mesg_pkg.log('old adj_cost: ' || to_char(dpr_in.adj_cost));
976: fa_rx_conc_mesg_pkg.log('old raf: ' || to_char(dpr_in.rate_adj_factor));
977: end if;
978:
979: if not fa_amort_pkg.faxama (fin_info,
980: h_new_raf, h_new_adj_cost, h_new_adj_capacity,
984:
985: fa_srvr_msg.get_message(mesg_count,mesg1,mesg2,mesg3,mesg4,
986: mesg5,mesg6,mesg7);
987:
988: fa_rx_conc_mesg_pkg.log(mesg1);
989: fa_rx_conc_mesg_pkg.log(mesg2);
990: fa_rx_conc_mesg_pkg.log(mesg3);
991: fa_rx_conc_mesg_pkg.log(mesg4);
992: fa_rx_conc_mesg_pkg.log(mesg5);
985: fa_srvr_msg.get_message(mesg_count,mesg1,mesg2,mesg3,mesg4,
986: mesg5,mesg6,mesg7);
987:
988: fa_rx_conc_mesg_pkg.log(mesg1);
989: fa_rx_conc_mesg_pkg.log(mesg2);
990: fa_rx_conc_mesg_pkg.log(mesg3);
991: fa_rx_conc_mesg_pkg.log(mesg4);
992: fa_rx_conc_mesg_pkg.log(mesg5);
993: fa_rx_conc_mesg_pkg.log(mesg6);
986: mesg5,mesg6,mesg7);
987:
988: fa_rx_conc_mesg_pkg.log(mesg1);
989: fa_rx_conc_mesg_pkg.log(mesg2);
990: fa_rx_conc_mesg_pkg.log(mesg3);
991: fa_rx_conc_mesg_pkg.log(mesg4);
992: fa_rx_conc_mesg_pkg.log(mesg5);
993: fa_rx_conc_mesg_pkg.log(mesg6);
994: fa_rx_conc_mesg_pkg.log(mesg7);
987:
988: fa_rx_conc_mesg_pkg.log(mesg1);
989: fa_rx_conc_mesg_pkg.log(mesg2);
990: fa_rx_conc_mesg_pkg.log(mesg3);
991: fa_rx_conc_mesg_pkg.log(mesg4);
992: fa_rx_conc_mesg_pkg.log(mesg5);
993: fa_rx_conc_mesg_pkg.log(mesg6);
994: fa_rx_conc_mesg_pkg.log(mesg7);
995:
988: fa_rx_conc_mesg_pkg.log(mesg1);
989: fa_rx_conc_mesg_pkg.log(mesg2);
990: fa_rx_conc_mesg_pkg.log(mesg3);
991: fa_rx_conc_mesg_pkg.log(mesg4);
992: fa_rx_conc_mesg_pkg.log(mesg5);
993: fa_rx_conc_mesg_pkg.log(mesg6);
994: fa_rx_conc_mesg_pkg.log(mesg7);
995:
996: x_return_status := 2;
989: fa_rx_conc_mesg_pkg.log(mesg2);
990: fa_rx_conc_mesg_pkg.log(mesg3);
991: fa_rx_conc_mesg_pkg.log(mesg4);
992: fa_rx_conc_mesg_pkg.log(mesg5);
993: fa_rx_conc_mesg_pkg.log(mesg6);
994: fa_rx_conc_mesg_pkg.log(mesg7);
995:
996: x_return_status := 2;
997: return (FALSE);
990: fa_rx_conc_mesg_pkg.log(mesg3);
991: fa_rx_conc_mesg_pkg.log(mesg4);
992: fa_rx_conc_mesg_pkg.log(mesg5);
993: fa_rx_conc_mesg_pkg.log(mesg6);
994: fa_rx_conc_mesg_pkg.log(mesg7);
995:
996: x_return_status := 2;
997: return (FALSE);
998: end if;
1003: dpr_in.adj_capacity := h_new_adj_capacity;
1004: dpr_in.reval_amo_basis := h_new_reval_amo_basis;
1005:
1006: if fnd_profile.value('PRINT_DEBUG') = 'Y' then
1007: fa_rx_conc_mesg_pkg.log('new adj_cost: ' || to_char(dpr_in.adj_cost));
1008: fa_rx_conc_mesg_pkg.log('new adj_rec_cost: '||to_char(dpr_in.adj_rec_cost));
1009: fa_rx_conc_mesg_pkg.log('new rec_cost: ' || to_char(dpr_in.rec_cost));
1010: fa_rx_conc_mesg_pkg.log('new salvage_val: '||to_char(dpr_in.salvage_value));
1011: fa_rx_conc_mesg_pkg.log('new raf: ' || to_char(dpr_in.rate_adj_factor));
1004: dpr_in.reval_amo_basis := h_new_reval_amo_basis;
1005:
1006: if fnd_profile.value('PRINT_DEBUG') = 'Y' then
1007: fa_rx_conc_mesg_pkg.log('new adj_cost: ' || to_char(dpr_in.adj_cost));
1008: fa_rx_conc_mesg_pkg.log('new adj_rec_cost: '||to_char(dpr_in.adj_rec_cost));
1009: fa_rx_conc_mesg_pkg.log('new rec_cost: ' || to_char(dpr_in.rec_cost));
1010: fa_rx_conc_mesg_pkg.log('new salvage_val: '||to_char(dpr_in.salvage_value));
1011: fa_rx_conc_mesg_pkg.log('new raf: ' || to_char(dpr_in.rate_adj_factor));
1012: end if;
1005:
1006: if fnd_profile.value('PRINT_DEBUG') = 'Y' then
1007: fa_rx_conc_mesg_pkg.log('new adj_cost: ' || to_char(dpr_in.adj_cost));
1008: fa_rx_conc_mesg_pkg.log('new adj_rec_cost: '||to_char(dpr_in.adj_rec_cost));
1009: fa_rx_conc_mesg_pkg.log('new rec_cost: ' || to_char(dpr_in.rec_cost));
1010: fa_rx_conc_mesg_pkg.log('new salvage_val: '||to_char(dpr_in.salvage_value));
1011: fa_rx_conc_mesg_pkg.log('new raf: ' || to_char(dpr_in.rate_adj_factor));
1012: end if;
1013: end if; -- (X_mode = 'EXPENSED')
1006: if fnd_profile.value('PRINT_DEBUG') = 'Y' then
1007: fa_rx_conc_mesg_pkg.log('new adj_cost: ' || to_char(dpr_in.adj_cost));
1008: fa_rx_conc_mesg_pkg.log('new adj_rec_cost: '||to_char(dpr_in.adj_rec_cost));
1009: fa_rx_conc_mesg_pkg.log('new rec_cost: ' || to_char(dpr_in.rec_cost));
1010: fa_rx_conc_mesg_pkg.log('new salvage_val: '||to_char(dpr_in.salvage_value));
1011: fa_rx_conc_mesg_pkg.log('new raf: ' || to_char(dpr_in.rate_adj_factor));
1012: end if;
1013: end if; -- (X_mode = 'EXPENSED')
1014: end if; -- X_mode in ('EXPENSED','AMORTIZED')
1007: fa_rx_conc_mesg_pkg.log('new adj_cost: ' || to_char(dpr_in.adj_cost));
1008: fa_rx_conc_mesg_pkg.log('new adj_rec_cost: '||to_char(dpr_in.adj_rec_cost));
1009: fa_rx_conc_mesg_pkg.log('new rec_cost: ' || to_char(dpr_in.rec_cost));
1010: fa_rx_conc_mesg_pkg.log('new salvage_val: '||to_char(dpr_in.salvage_value));
1011: fa_rx_conc_mesg_pkg.log('new raf: ' || to_char(dpr_in.rate_adj_factor));
1012: end if;
1013: end if; -- (X_mode = 'EXPENSED')
1014: end if; -- X_mode in ('EXPENSED','AMORTIZED')
1015:
1015:
1016:
1017: -- LOAD DPR_IN STRUCT... MAKE SURE TO ADD ADJUSTMENTS TO EXPENSE TO BALANCES HERE.
1018:
1019: --fa_rx_conc_mesg_pkg.log('step 811');
1020:
1021: -- HAVEN'T CALLED QUERY BALANCES FOR NORMAL MODE YET
1022: if (X_Mode not in ('EXPENSED','AMORTIZED')) then
1023: --fa_rx_conc_mesg_pkg.log('step 8');
1019: --fa_rx_conc_mesg_pkg.log('step 811');
1020:
1021: -- HAVEN'T CALLED QUERY BALANCES FOR NORMAL MODE YET
1022: if (X_Mode not in ('EXPENSED','AMORTIZED')) then
1023: --fa_rx_conc_mesg_pkg.log('step 8');
1024:
1025: h_mesg_name := 'FA_WHATIF_ASSET_QUERY_BAL';
1026:
1027: dpr_row.asset_id := X_asset_id;
1050: p_log_level_rec => null);
1051: end if; -- (X_Mode not in ('EXPENSED','AMORTIZED'))
1052:
1053: -- Get adjustments to deprn expense already taken this period.
1054: -- fa_rx_conc_mesg_pkg.log('step 8');
1055: h_mesg_name := 'FA_REC_SQL_GET_ADJ';
1056:
1057: --
1058: -- SQL to get expenses from fa_adjustments have been removed becuase
1123: dpr_in.ret_prorate_jdate := 0;
1124: dpr_in.rsv_known_flag := TRUE;
1125:
1126:
1127: --fa_rx_conc_mesg_pkg.log('step 9');
1128:
1129: -- GET CALENDAR INFO: TYPE, FY_NAME, NUM_PER_FISCAL_YEAR
1130:
1131: h_mesg_name := 'FA_DEPRN_SQL_SNFY';
1257: end if;
1258:
1259: -- Call deprn engine.
1260:
1261: --fa_rx_conc_mesg_pkg.log('step 10');
1262:
1263: if X_mode in ('EXPENSED','AMORTIZED') then
1264: dpr_in.deprn_rounding_flag := 'ADJ';
1265: end if;
1267:
1268:
1269: if fnd_profile.value('PRINT_DEBUG') = 'Y' then
1270:
1271: fa_rx_conc_mesg_pkg.log('DPR_IN STRUCT:');
1272: fa_rx_conc_mesg_pkg.log('Contents of dpr_struct for asset_id '||dpr_in.asset_id);
1273: fa_rx_conc_mesg_pkg.log('asset_num '||dpr_in.asset_num);
1274: fa_rx_conc_mesg_pkg.log('book '||dpr_in.book);
1275: fa_rx_conc_mesg_pkg.log('calendar_type '||dpr_in.calendar_type);
1268:
1269: if fnd_profile.value('PRINT_DEBUG') = 'Y' then
1270:
1271: fa_rx_conc_mesg_pkg.log('DPR_IN STRUCT:');
1272: fa_rx_conc_mesg_pkg.log('Contents of dpr_struct for asset_id '||dpr_in.asset_id);
1273: fa_rx_conc_mesg_pkg.log('asset_num '||dpr_in.asset_num);
1274: fa_rx_conc_mesg_pkg.log('book '||dpr_in.book);
1275: fa_rx_conc_mesg_pkg.log('calendar_type '||dpr_in.calendar_type);
1276: fa_rx_conc_mesg_pkg.log('ceil_name '||dpr_in.ceil_name);
1269: if fnd_profile.value('PRINT_DEBUG') = 'Y' then
1270:
1271: fa_rx_conc_mesg_pkg.log('DPR_IN STRUCT:');
1272: fa_rx_conc_mesg_pkg.log('Contents of dpr_struct for asset_id '||dpr_in.asset_id);
1273: fa_rx_conc_mesg_pkg.log('asset_num '||dpr_in.asset_num);
1274: fa_rx_conc_mesg_pkg.log('book '||dpr_in.book);
1275: fa_rx_conc_mesg_pkg.log('calendar_type '||dpr_in.calendar_type);
1276: fa_rx_conc_mesg_pkg.log('ceil_name '||dpr_in.ceil_name);
1277: fa_rx_conc_mesg_pkg.log('bonus_rule '||dpr_in.bonus_rule);
1270:
1271: fa_rx_conc_mesg_pkg.log('DPR_IN STRUCT:');
1272: fa_rx_conc_mesg_pkg.log('Contents of dpr_struct for asset_id '||dpr_in.asset_id);
1273: fa_rx_conc_mesg_pkg.log('asset_num '||dpr_in.asset_num);
1274: fa_rx_conc_mesg_pkg.log('book '||dpr_in.book);
1275: fa_rx_conc_mesg_pkg.log('calendar_type '||dpr_in.calendar_type);
1276: fa_rx_conc_mesg_pkg.log('ceil_name '||dpr_in.ceil_name);
1277: fa_rx_conc_mesg_pkg.log('bonus_rule '||dpr_in.bonus_rule);
1278: fa_rx_conc_mesg_pkg.log('method_code '||dpr_in.method_code);
1271: fa_rx_conc_mesg_pkg.log('DPR_IN STRUCT:');
1272: fa_rx_conc_mesg_pkg.log('Contents of dpr_struct for asset_id '||dpr_in.asset_id);
1273: fa_rx_conc_mesg_pkg.log('asset_num '||dpr_in.asset_num);
1274: fa_rx_conc_mesg_pkg.log('book '||dpr_in.book);
1275: fa_rx_conc_mesg_pkg.log('calendar_type '||dpr_in.calendar_type);
1276: fa_rx_conc_mesg_pkg.log('ceil_name '||dpr_in.ceil_name);
1277: fa_rx_conc_mesg_pkg.log('bonus_rule '||dpr_in.bonus_rule);
1278: fa_rx_conc_mesg_pkg.log('method_code '||dpr_in.method_code);
1279: fa_rx_conc_mesg_pkg.log('adj_cost '||dpr_in.adj_cost);
1272: fa_rx_conc_mesg_pkg.log('Contents of dpr_struct for asset_id '||dpr_in.asset_id);
1273: fa_rx_conc_mesg_pkg.log('asset_num '||dpr_in.asset_num);
1274: fa_rx_conc_mesg_pkg.log('book '||dpr_in.book);
1275: fa_rx_conc_mesg_pkg.log('calendar_type '||dpr_in.calendar_type);
1276: fa_rx_conc_mesg_pkg.log('ceil_name '||dpr_in.ceil_name);
1277: fa_rx_conc_mesg_pkg.log('bonus_rule '||dpr_in.bonus_rule);
1278: fa_rx_conc_mesg_pkg.log('method_code '||dpr_in.method_code);
1279: fa_rx_conc_mesg_pkg.log('adj_cost '||dpr_in.adj_cost);
1280: fa_rx_conc_mesg_pkg.log('rec_cost '||dpr_in.rec_cost);
1273: fa_rx_conc_mesg_pkg.log('asset_num '||dpr_in.asset_num);
1274: fa_rx_conc_mesg_pkg.log('book '||dpr_in.book);
1275: fa_rx_conc_mesg_pkg.log('calendar_type '||dpr_in.calendar_type);
1276: fa_rx_conc_mesg_pkg.log('ceil_name '||dpr_in.ceil_name);
1277: fa_rx_conc_mesg_pkg.log('bonus_rule '||dpr_in.bonus_rule);
1278: fa_rx_conc_mesg_pkg.log('method_code '||dpr_in.method_code);
1279: fa_rx_conc_mesg_pkg.log('adj_cost '||dpr_in.adj_cost);
1280: fa_rx_conc_mesg_pkg.log('rec_cost '||dpr_in.rec_cost);
1281: fa_rx_conc_mesg_pkg.log('reval_amo_basis '||dpr_in.reval_amo_basis);
1274: fa_rx_conc_mesg_pkg.log('book '||dpr_in.book);
1275: fa_rx_conc_mesg_pkg.log('calendar_type '||dpr_in.calendar_type);
1276: fa_rx_conc_mesg_pkg.log('ceil_name '||dpr_in.ceil_name);
1277: fa_rx_conc_mesg_pkg.log('bonus_rule '||dpr_in.bonus_rule);
1278: fa_rx_conc_mesg_pkg.log('method_code '||dpr_in.method_code);
1279: fa_rx_conc_mesg_pkg.log('adj_cost '||dpr_in.adj_cost);
1280: fa_rx_conc_mesg_pkg.log('rec_cost '||dpr_in.rec_cost);
1281: fa_rx_conc_mesg_pkg.log('reval_amo_basis '||dpr_in.reval_amo_basis);
1282: fa_rx_conc_mesg_pkg.log('deprn_rsv '||dpr_in.deprn_rsv);
1275: fa_rx_conc_mesg_pkg.log('calendar_type '||dpr_in.calendar_type);
1276: fa_rx_conc_mesg_pkg.log('ceil_name '||dpr_in.ceil_name);
1277: fa_rx_conc_mesg_pkg.log('bonus_rule '||dpr_in.bonus_rule);
1278: fa_rx_conc_mesg_pkg.log('method_code '||dpr_in.method_code);
1279: fa_rx_conc_mesg_pkg.log('adj_cost '||dpr_in.adj_cost);
1280: fa_rx_conc_mesg_pkg.log('rec_cost '||dpr_in.rec_cost);
1281: fa_rx_conc_mesg_pkg.log('reval_amo_basis '||dpr_in.reval_amo_basis);
1282: fa_rx_conc_mesg_pkg.log('deprn_rsv '||dpr_in.deprn_rsv);
1283: fa_rx_conc_mesg_pkg.log('reval_rsv '||dpr_in.reval_rsv);
1276: fa_rx_conc_mesg_pkg.log('ceil_name '||dpr_in.ceil_name);
1277: fa_rx_conc_mesg_pkg.log('bonus_rule '||dpr_in.bonus_rule);
1278: fa_rx_conc_mesg_pkg.log('method_code '||dpr_in.method_code);
1279: fa_rx_conc_mesg_pkg.log('adj_cost '||dpr_in.adj_cost);
1280: fa_rx_conc_mesg_pkg.log('rec_cost '||dpr_in.rec_cost);
1281: fa_rx_conc_mesg_pkg.log('reval_amo_basis '||dpr_in.reval_amo_basis);
1282: fa_rx_conc_mesg_pkg.log('deprn_rsv '||dpr_in.deprn_rsv);
1283: fa_rx_conc_mesg_pkg.log('reval_rsv '||dpr_in.reval_rsv);
1284: -- bonus
1277: fa_rx_conc_mesg_pkg.log('bonus_rule '||dpr_in.bonus_rule);
1278: fa_rx_conc_mesg_pkg.log('method_code '||dpr_in.method_code);
1279: fa_rx_conc_mesg_pkg.log('adj_cost '||dpr_in.adj_cost);
1280: fa_rx_conc_mesg_pkg.log('rec_cost '||dpr_in.rec_cost);
1281: fa_rx_conc_mesg_pkg.log('reval_amo_basis '||dpr_in.reval_amo_basis);
1282: fa_rx_conc_mesg_pkg.log('deprn_rsv '||dpr_in.deprn_rsv);
1283: fa_rx_conc_mesg_pkg.log('reval_rsv '||dpr_in.reval_rsv);
1284: -- bonus
1285: fa_rx_conc_mesg_pkg.log('bonus_deprn_rsv ' || dpr_in.bonus_deprn_rsv);
1278: fa_rx_conc_mesg_pkg.log('method_code '||dpr_in.method_code);
1279: fa_rx_conc_mesg_pkg.log('adj_cost '||dpr_in.adj_cost);
1280: fa_rx_conc_mesg_pkg.log('rec_cost '||dpr_in.rec_cost);
1281: fa_rx_conc_mesg_pkg.log('reval_amo_basis '||dpr_in.reval_amo_basis);
1282: fa_rx_conc_mesg_pkg.log('deprn_rsv '||dpr_in.deprn_rsv);
1283: fa_rx_conc_mesg_pkg.log('reval_rsv '||dpr_in.reval_rsv);
1284: -- bonus
1285: fa_rx_conc_mesg_pkg.log('bonus_deprn_rsv ' || dpr_in.bonus_deprn_rsv);
1286: fa_rx_conc_mesg_pkg.log('adj_rate '||dpr_in.adj_rate);
1279: fa_rx_conc_mesg_pkg.log('adj_cost '||dpr_in.adj_cost);
1280: fa_rx_conc_mesg_pkg.log('rec_cost '||dpr_in.rec_cost);
1281: fa_rx_conc_mesg_pkg.log('reval_amo_basis '||dpr_in.reval_amo_basis);
1282: fa_rx_conc_mesg_pkg.log('deprn_rsv '||dpr_in.deprn_rsv);
1283: fa_rx_conc_mesg_pkg.log('reval_rsv '||dpr_in.reval_rsv);
1284: -- bonus
1285: fa_rx_conc_mesg_pkg.log('bonus_deprn_rsv ' || dpr_in.bonus_deprn_rsv);
1286: fa_rx_conc_mesg_pkg.log('adj_rate '||dpr_in.adj_rate);
1287: fa_rx_conc_mesg_pkg.log('rate_adj_factor '||dpr_in.rate_adj_factor);
1281: fa_rx_conc_mesg_pkg.log('reval_amo_basis '||dpr_in.reval_amo_basis);
1282: fa_rx_conc_mesg_pkg.log('deprn_rsv '||dpr_in.deprn_rsv);
1283: fa_rx_conc_mesg_pkg.log('reval_rsv '||dpr_in.reval_rsv);
1284: -- bonus
1285: fa_rx_conc_mesg_pkg.log('bonus_deprn_rsv ' || dpr_in.bonus_deprn_rsv);
1286: fa_rx_conc_mesg_pkg.log('adj_rate '||dpr_in.adj_rate);
1287: fa_rx_conc_mesg_pkg.log('rate_adj_factor '||dpr_in.rate_adj_factor);
1288: fa_rx_conc_mesg_pkg.log('capacity '||dpr_in.capacity);
1289: fa_rx_conc_mesg_pkg.log('adj_capacity '||dpr_in.adj_capacity);
1282: fa_rx_conc_mesg_pkg.log('deprn_rsv '||dpr_in.deprn_rsv);
1283: fa_rx_conc_mesg_pkg.log('reval_rsv '||dpr_in.reval_rsv);
1284: -- bonus
1285: fa_rx_conc_mesg_pkg.log('bonus_deprn_rsv ' || dpr_in.bonus_deprn_rsv);
1286: fa_rx_conc_mesg_pkg.log('adj_rate '||dpr_in.adj_rate);
1287: fa_rx_conc_mesg_pkg.log('rate_adj_factor '||dpr_in.rate_adj_factor);
1288: fa_rx_conc_mesg_pkg.log('capacity '||dpr_in.capacity);
1289: fa_rx_conc_mesg_pkg.log('adj_capacity '||dpr_in.adj_capacity);
1290: fa_rx_conc_mesg_pkg.log('ltd_prod '||dpr_in.ltd_prod);
1283: fa_rx_conc_mesg_pkg.log('reval_rsv '||dpr_in.reval_rsv);
1284: -- bonus
1285: fa_rx_conc_mesg_pkg.log('bonus_deprn_rsv ' || dpr_in.bonus_deprn_rsv);
1286: fa_rx_conc_mesg_pkg.log('adj_rate '||dpr_in.adj_rate);
1287: fa_rx_conc_mesg_pkg.log('rate_adj_factor '||dpr_in.rate_adj_factor);
1288: fa_rx_conc_mesg_pkg.log('capacity '||dpr_in.capacity);
1289: fa_rx_conc_mesg_pkg.log('adj_capacity '||dpr_in.adj_capacity);
1290: fa_rx_conc_mesg_pkg.log('ltd_prod '||dpr_in.ltd_prod);
1291: fa_rx_conc_mesg_pkg.log('adj_rec_cost '||dpr_in.adj_rec_cost);
1284: -- bonus
1285: fa_rx_conc_mesg_pkg.log('bonus_deprn_rsv ' || dpr_in.bonus_deprn_rsv);
1286: fa_rx_conc_mesg_pkg.log('adj_rate '||dpr_in.adj_rate);
1287: fa_rx_conc_mesg_pkg.log('rate_adj_factor '||dpr_in.rate_adj_factor);
1288: fa_rx_conc_mesg_pkg.log('capacity '||dpr_in.capacity);
1289: fa_rx_conc_mesg_pkg.log('adj_capacity '||dpr_in.adj_capacity);
1290: fa_rx_conc_mesg_pkg.log('ltd_prod '||dpr_in.ltd_prod);
1291: fa_rx_conc_mesg_pkg.log('adj_rec_cost '||dpr_in.adj_rec_cost);
1292: fa_rx_conc_mesg_pkg.log('salvage_value '||dpr_in.salvage_value);
1285: fa_rx_conc_mesg_pkg.log('bonus_deprn_rsv ' || dpr_in.bonus_deprn_rsv);
1286: fa_rx_conc_mesg_pkg.log('adj_rate '||dpr_in.adj_rate);
1287: fa_rx_conc_mesg_pkg.log('rate_adj_factor '||dpr_in.rate_adj_factor);
1288: fa_rx_conc_mesg_pkg.log('capacity '||dpr_in.capacity);
1289: fa_rx_conc_mesg_pkg.log('adj_capacity '||dpr_in.adj_capacity);
1290: fa_rx_conc_mesg_pkg.log('ltd_prod '||dpr_in.ltd_prod);
1291: fa_rx_conc_mesg_pkg.log('adj_rec_cost '||dpr_in.adj_rec_cost);
1292: fa_rx_conc_mesg_pkg.log('salvage_value '||dpr_in.salvage_value);
1293: fa_rx_conc_mesg_pkg.log('prior_fy_exp '||dpr_in.prior_fy_exp);
1286: fa_rx_conc_mesg_pkg.log('adj_rate '||dpr_in.adj_rate);
1287: fa_rx_conc_mesg_pkg.log('rate_adj_factor '||dpr_in.rate_adj_factor);
1288: fa_rx_conc_mesg_pkg.log('capacity '||dpr_in.capacity);
1289: fa_rx_conc_mesg_pkg.log('adj_capacity '||dpr_in.adj_capacity);
1290: fa_rx_conc_mesg_pkg.log('ltd_prod '||dpr_in.ltd_prod);
1291: fa_rx_conc_mesg_pkg.log('adj_rec_cost '||dpr_in.adj_rec_cost);
1292: fa_rx_conc_mesg_pkg.log('salvage_value '||dpr_in.salvage_value);
1293: fa_rx_conc_mesg_pkg.log('prior_fy_exp '||dpr_in.prior_fy_exp);
1294: fa_rx_conc_mesg_pkg.log('ytd_deprn '||dpr_in.ytd_deprn);
1287: fa_rx_conc_mesg_pkg.log('rate_adj_factor '||dpr_in.rate_adj_factor);
1288: fa_rx_conc_mesg_pkg.log('capacity '||dpr_in.capacity);
1289: fa_rx_conc_mesg_pkg.log('adj_capacity '||dpr_in.adj_capacity);
1290: fa_rx_conc_mesg_pkg.log('ltd_prod '||dpr_in.ltd_prod);
1291: fa_rx_conc_mesg_pkg.log('adj_rec_cost '||dpr_in.adj_rec_cost);
1292: fa_rx_conc_mesg_pkg.log('salvage_value '||dpr_in.salvage_value);
1293: fa_rx_conc_mesg_pkg.log('prior_fy_exp '||dpr_in.prior_fy_exp);
1294: fa_rx_conc_mesg_pkg.log('ytd_deprn '||dpr_in.ytd_deprn);
1295: fa_rx_conc_mesg_pkg.log('asset_id '||dpr_in.asset_id);
1288: fa_rx_conc_mesg_pkg.log('capacity '||dpr_in.capacity);
1289: fa_rx_conc_mesg_pkg.log('adj_capacity '||dpr_in.adj_capacity);
1290: fa_rx_conc_mesg_pkg.log('ltd_prod '||dpr_in.ltd_prod);
1291: fa_rx_conc_mesg_pkg.log('adj_rec_cost '||dpr_in.adj_rec_cost);
1292: fa_rx_conc_mesg_pkg.log('salvage_value '||dpr_in.salvage_value);
1293: fa_rx_conc_mesg_pkg.log('prior_fy_exp '||dpr_in.prior_fy_exp);
1294: fa_rx_conc_mesg_pkg.log('ytd_deprn '||dpr_in.ytd_deprn);
1295: fa_rx_conc_mesg_pkg.log('asset_id '||dpr_in.asset_id);
1296: fa_rx_conc_mesg_pkg.log('jdate_in_service '||dpr_in.jdate_in_service);
1289: fa_rx_conc_mesg_pkg.log('adj_capacity '||dpr_in.adj_capacity);
1290: fa_rx_conc_mesg_pkg.log('ltd_prod '||dpr_in.ltd_prod);
1291: fa_rx_conc_mesg_pkg.log('adj_rec_cost '||dpr_in.adj_rec_cost);
1292: fa_rx_conc_mesg_pkg.log('salvage_value '||dpr_in.salvage_value);
1293: fa_rx_conc_mesg_pkg.log('prior_fy_exp '||dpr_in.prior_fy_exp);
1294: fa_rx_conc_mesg_pkg.log('ytd_deprn '||dpr_in.ytd_deprn);
1295: fa_rx_conc_mesg_pkg.log('asset_id '||dpr_in.asset_id);
1296: fa_rx_conc_mesg_pkg.log('jdate_in_service '||dpr_in.jdate_in_service);
1297: fa_rx_conc_mesg_pkg.log('prorate_jdate '||dpr_in.prorate_jdate);
1290: fa_rx_conc_mesg_pkg.log('ltd_prod '||dpr_in.ltd_prod);
1291: fa_rx_conc_mesg_pkg.log('adj_rec_cost '||dpr_in.adj_rec_cost);
1292: fa_rx_conc_mesg_pkg.log('salvage_value '||dpr_in.salvage_value);
1293: fa_rx_conc_mesg_pkg.log('prior_fy_exp '||dpr_in.prior_fy_exp);
1294: fa_rx_conc_mesg_pkg.log('ytd_deprn '||dpr_in.ytd_deprn);
1295: fa_rx_conc_mesg_pkg.log('asset_id '||dpr_in.asset_id);
1296: fa_rx_conc_mesg_pkg.log('jdate_in_service '||dpr_in.jdate_in_service);
1297: fa_rx_conc_mesg_pkg.log('prorate_jdate '||dpr_in.prorate_jdate);
1298: fa_rx_conc_mesg_pkg.log('deprn_start_jdate '||dpr_in.deprn_start_jdate);
1291: fa_rx_conc_mesg_pkg.log('adj_rec_cost '||dpr_in.adj_rec_cost);
1292: fa_rx_conc_mesg_pkg.log('salvage_value '||dpr_in.salvage_value);
1293: fa_rx_conc_mesg_pkg.log('prior_fy_exp '||dpr_in.prior_fy_exp);
1294: fa_rx_conc_mesg_pkg.log('ytd_deprn '||dpr_in.ytd_deprn);
1295: fa_rx_conc_mesg_pkg.log('asset_id '||dpr_in.asset_id);
1296: fa_rx_conc_mesg_pkg.log('jdate_in_service '||dpr_in.jdate_in_service);
1297: fa_rx_conc_mesg_pkg.log('prorate_jdate '||dpr_in.prorate_jdate);
1298: fa_rx_conc_mesg_pkg.log('deprn_start_jdate '||dpr_in.deprn_start_jdate);
1299: fa_rx_conc_mesg_pkg.log('jdate_retired '||dpr_in.jdate_retired);
1292: fa_rx_conc_mesg_pkg.log('salvage_value '||dpr_in.salvage_value);
1293: fa_rx_conc_mesg_pkg.log('prior_fy_exp '||dpr_in.prior_fy_exp);
1294: fa_rx_conc_mesg_pkg.log('ytd_deprn '||dpr_in.ytd_deprn);
1295: fa_rx_conc_mesg_pkg.log('asset_id '||dpr_in.asset_id);
1296: fa_rx_conc_mesg_pkg.log('jdate_in_service '||dpr_in.jdate_in_service);
1297: fa_rx_conc_mesg_pkg.log('prorate_jdate '||dpr_in.prorate_jdate);
1298: fa_rx_conc_mesg_pkg.log('deprn_start_jdate '||dpr_in.deprn_start_jdate);
1299: fa_rx_conc_mesg_pkg.log('jdate_retired '||dpr_in.jdate_retired);
1300: fa_rx_conc_mesg_pkg.log('ret_prorate_jdate '||dpr_in.ret_prorate_jdate);
1293: fa_rx_conc_mesg_pkg.log('prior_fy_exp '||dpr_in.prior_fy_exp);
1294: fa_rx_conc_mesg_pkg.log('ytd_deprn '||dpr_in.ytd_deprn);
1295: fa_rx_conc_mesg_pkg.log('asset_id '||dpr_in.asset_id);
1296: fa_rx_conc_mesg_pkg.log('jdate_in_service '||dpr_in.jdate_in_service);
1297: fa_rx_conc_mesg_pkg.log('prorate_jdate '||dpr_in.prorate_jdate);
1298: fa_rx_conc_mesg_pkg.log('deprn_start_jdate '||dpr_in.deprn_start_jdate);
1299: fa_rx_conc_mesg_pkg.log('jdate_retired '||dpr_in.jdate_retired);
1300: fa_rx_conc_mesg_pkg.log('ret_prorate_jdate '||dpr_in.ret_prorate_jdate);
1301: fa_rx_conc_mesg_pkg.log('life '||dpr_in.life);
1294: fa_rx_conc_mesg_pkg.log('ytd_deprn '||dpr_in.ytd_deprn);
1295: fa_rx_conc_mesg_pkg.log('asset_id '||dpr_in.asset_id);
1296: fa_rx_conc_mesg_pkg.log('jdate_in_service '||dpr_in.jdate_in_service);
1297: fa_rx_conc_mesg_pkg.log('prorate_jdate '||dpr_in.prorate_jdate);
1298: fa_rx_conc_mesg_pkg.log('deprn_start_jdate '||dpr_in.deprn_start_jdate);
1299: fa_rx_conc_mesg_pkg.log('jdate_retired '||dpr_in.jdate_retired);
1300: fa_rx_conc_mesg_pkg.log('ret_prorate_jdate '||dpr_in.ret_prorate_jdate);
1301: fa_rx_conc_mesg_pkg.log('life '||dpr_in.life);
1302: fa_rx_conc_mesg_pkg.log('prorate_year_pcal_begin '||dpr_in.y_begin);
1295: fa_rx_conc_mesg_pkg.log('asset_id '||dpr_in.asset_id);
1296: fa_rx_conc_mesg_pkg.log('jdate_in_service '||dpr_in.jdate_in_service);
1297: fa_rx_conc_mesg_pkg.log('prorate_jdate '||dpr_in.prorate_jdate);
1298: fa_rx_conc_mesg_pkg.log('deprn_start_jdate '||dpr_in.deprn_start_jdate);
1299: fa_rx_conc_mesg_pkg.log('jdate_retired '||dpr_in.jdate_retired);
1300: fa_rx_conc_mesg_pkg.log('ret_prorate_jdate '||dpr_in.ret_prorate_jdate);
1301: fa_rx_conc_mesg_pkg.log('life '||dpr_in.life);
1302: fa_rx_conc_mesg_pkg.log('prorate_year_pcal_begin '||dpr_in.y_begin);
1303: fa_rx_conc_mesg_pkg.log('y_end '||dpr_in.y_end);
1296: fa_rx_conc_mesg_pkg.log('jdate_in_service '||dpr_in.jdate_in_service);
1297: fa_rx_conc_mesg_pkg.log('prorate_jdate '||dpr_in.prorate_jdate);
1298: fa_rx_conc_mesg_pkg.log('deprn_start_jdate '||dpr_in.deprn_start_jdate);
1299: fa_rx_conc_mesg_pkg.log('jdate_retired '||dpr_in.jdate_retired);
1300: fa_rx_conc_mesg_pkg.log('ret_prorate_jdate '||dpr_in.ret_prorate_jdate);
1301: fa_rx_conc_mesg_pkg.log('life '||dpr_in.life);
1302: fa_rx_conc_mesg_pkg.log('prorate_year_pcal_begin '||dpr_in.y_begin);
1303: fa_rx_conc_mesg_pkg.log('y_end '||dpr_in.y_end);
1304: fa_rx_conc_mesg_pkg.log('p_cl_begin '||dpr_in.p_cl_begin);
1297: fa_rx_conc_mesg_pkg.log('prorate_jdate '||dpr_in.prorate_jdate);
1298: fa_rx_conc_mesg_pkg.log('deprn_start_jdate '||dpr_in.deprn_start_jdate);
1299: fa_rx_conc_mesg_pkg.log('jdate_retired '||dpr_in.jdate_retired);
1300: fa_rx_conc_mesg_pkg.log('ret_prorate_jdate '||dpr_in.ret_prorate_jdate);
1301: fa_rx_conc_mesg_pkg.log('life '||dpr_in.life);
1302: fa_rx_conc_mesg_pkg.log('prorate_year_pcal_begin '||dpr_in.y_begin);
1303: fa_rx_conc_mesg_pkg.log('y_end '||dpr_in.y_end);
1304: fa_rx_conc_mesg_pkg.log('p_cl_begin '||dpr_in.p_cl_begin);
1305: fa_rx_conc_mesg_pkg.log('p_cl_end '||dpr_in.p_cl_end);
1298: fa_rx_conc_mesg_pkg.log('deprn_start_jdate '||dpr_in.deprn_start_jdate);
1299: fa_rx_conc_mesg_pkg.log('jdate_retired '||dpr_in.jdate_retired);
1300: fa_rx_conc_mesg_pkg.log('ret_prorate_jdate '||dpr_in.ret_prorate_jdate);
1301: fa_rx_conc_mesg_pkg.log('life '||dpr_in.life);
1302: fa_rx_conc_mesg_pkg.log('prorate_year_pcal_begin '||dpr_in.y_begin);
1303: fa_rx_conc_mesg_pkg.log('y_end '||dpr_in.y_end);
1304: fa_rx_conc_mesg_pkg.log('p_cl_begin '||dpr_in.p_cl_begin);
1305: fa_rx_conc_mesg_pkg.log('p_cl_end '||dpr_in.p_cl_end);
1306: fa_rx_conc_mesg_pkg.log('pc_life_end '||dpr_in.pc_life_end);
1299: fa_rx_conc_mesg_pkg.log('jdate_retired '||dpr_in.jdate_retired);
1300: fa_rx_conc_mesg_pkg.log('ret_prorate_jdate '||dpr_in.ret_prorate_jdate);
1301: fa_rx_conc_mesg_pkg.log('life '||dpr_in.life);
1302: fa_rx_conc_mesg_pkg.log('prorate_year_pcal_begin '||dpr_in.y_begin);
1303: fa_rx_conc_mesg_pkg.log('y_end '||dpr_in.y_end);
1304: fa_rx_conc_mesg_pkg.log('p_cl_begin '||dpr_in.p_cl_begin);
1305: fa_rx_conc_mesg_pkg.log('p_cl_end '||dpr_in.p_cl_end);
1306: fa_rx_conc_mesg_pkg.log('pc_life_end '||dpr_in.pc_life_end);
1307:
1300: fa_rx_conc_mesg_pkg.log('ret_prorate_jdate '||dpr_in.ret_prorate_jdate);
1301: fa_rx_conc_mesg_pkg.log('life '||dpr_in.life);
1302: fa_rx_conc_mesg_pkg.log('prorate_year_pcal_begin '||dpr_in.y_begin);
1303: fa_rx_conc_mesg_pkg.log('y_end '||dpr_in.y_end);
1304: fa_rx_conc_mesg_pkg.log('p_cl_begin '||dpr_in.p_cl_begin);
1305: fa_rx_conc_mesg_pkg.log('p_cl_end '||dpr_in.p_cl_end);
1306: fa_rx_conc_mesg_pkg.log('pc_life_end '||dpr_in.pc_life_end);
1307:
1308: if (dpr_in.rsv_known_flag) then
1301: fa_rx_conc_mesg_pkg.log('life '||dpr_in.life);
1302: fa_rx_conc_mesg_pkg.log('prorate_year_pcal_begin '||dpr_in.y_begin);
1303: fa_rx_conc_mesg_pkg.log('y_end '||dpr_in.y_end);
1304: fa_rx_conc_mesg_pkg.log('p_cl_begin '||dpr_in.p_cl_begin);
1305: fa_rx_conc_mesg_pkg.log('p_cl_end '||dpr_in.p_cl_end);
1306: fa_rx_conc_mesg_pkg.log('pc_life_end '||dpr_in.pc_life_end);
1307:
1308: if (dpr_in.rsv_known_flag) then
1309: fa_rx_conc_mesg_pkg.log('rsv_known_flag '||'TRUE');
1302: fa_rx_conc_mesg_pkg.log('prorate_year_pcal_begin '||dpr_in.y_begin);
1303: fa_rx_conc_mesg_pkg.log('y_end '||dpr_in.y_end);
1304: fa_rx_conc_mesg_pkg.log('p_cl_begin '||dpr_in.p_cl_begin);
1305: fa_rx_conc_mesg_pkg.log('p_cl_end '||dpr_in.p_cl_end);
1306: fa_rx_conc_mesg_pkg.log('pc_life_end '||dpr_in.pc_life_end);
1307:
1308: if (dpr_in.rsv_known_flag) then
1309: fa_rx_conc_mesg_pkg.log('rsv_known_flag '||'TRUE');
1310: else
1305: fa_rx_conc_mesg_pkg.log('p_cl_end '||dpr_in.p_cl_end);
1306: fa_rx_conc_mesg_pkg.log('pc_life_end '||dpr_in.pc_life_end);
1307:
1308: if (dpr_in.rsv_known_flag) then
1309: fa_rx_conc_mesg_pkg.log('rsv_known_flag '||'TRUE');
1310: else
1311: fa_rx_conc_mesg_pkg.log('rsv_known_flag '||'FALSE');
1312: end if;
1313:
1307:
1308: if (dpr_in.rsv_known_flag) then
1309: fa_rx_conc_mesg_pkg.log('rsv_known_flag '||'TRUE');
1310: else
1311: fa_rx_conc_mesg_pkg.log('rsv_known_flag '||'FALSE');
1312: end if;
1313:
1314: fa_rx_conc_mesg_pkg.log('deprn_rounding_flag '||dpr_in.deprn_rounding_flag);
1315: end if;
1310: else
1311: fa_rx_conc_mesg_pkg.log('rsv_known_flag '||'FALSE');
1312: end if;
1313:
1314: fa_rx_conc_mesg_pkg.log('deprn_rounding_flag '||dpr_in.deprn_rounding_flag);
1315: end if;
1316:
1317: -- override
1318: dpr_in.used_by_adjustment:= FALSE;
1415: --tk_util.debug('faxcde returned false');
1416: fa_srvr_msg.get_message(mesg_count,mesg1,mesg2,mesg3,mesg4,
1417: mesg5,mesg6,mesg7);
1418:
1419: fa_rx_conc_mesg_pkg.log(mesg1);
1420: fa_rx_conc_mesg_pkg.log(mesg2);
1421: fa_rx_conc_mesg_pkg.log(mesg3);
1422: fa_rx_conc_mesg_pkg.log(mesg4);
1423: fa_rx_conc_mesg_pkg.log(mesg5);
1416: fa_srvr_msg.get_message(mesg_count,mesg1,mesg2,mesg3,mesg4,
1417: mesg5,mesg6,mesg7);
1418:
1419: fa_rx_conc_mesg_pkg.log(mesg1);
1420: fa_rx_conc_mesg_pkg.log(mesg2);
1421: fa_rx_conc_mesg_pkg.log(mesg3);
1422: fa_rx_conc_mesg_pkg.log(mesg4);
1423: fa_rx_conc_mesg_pkg.log(mesg5);
1424: fa_rx_conc_mesg_pkg.log(mesg6);
1417: mesg5,mesg6,mesg7);
1418:
1419: fa_rx_conc_mesg_pkg.log(mesg1);
1420: fa_rx_conc_mesg_pkg.log(mesg2);
1421: fa_rx_conc_mesg_pkg.log(mesg3);
1422: fa_rx_conc_mesg_pkg.log(mesg4);
1423: fa_rx_conc_mesg_pkg.log(mesg5);
1424: fa_rx_conc_mesg_pkg.log(mesg6);
1425: fa_rx_conc_mesg_pkg.log(mesg7);
1418:
1419: fa_rx_conc_mesg_pkg.log(mesg1);
1420: fa_rx_conc_mesg_pkg.log(mesg2);
1421: fa_rx_conc_mesg_pkg.log(mesg3);
1422: fa_rx_conc_mesg_pkg.log(mesg4);
1423: fa_rx_conc_mesg_pkg.log(mesg5);
1424: fa_rx_conc_mesg_pkg.log(mesg6);
1425: fa_rx_conc_mesg_pkg.log(mesg7);
1426:
1419: fa_rx_conc_mesg_pkg.log(mesg1);
1420: fa_rx_conc_mesg_pkg.log(mesg2);
1421: fa_rx_conc_mesg_pkg.log(mesg3);
1422: fa_rx_conc_mesg_pkg.log(mesg4);
1423: fa_rx_conc_mesg_pkg.log(mesg5);
1424: fa_rx_conc_mesg_pkg.log(mesg6);
1425: fa_rx_conc_mesg_pkg.log(mesg7);
1426:
1427:
1420: fa_rx_conc_mesg_pkg.log(mesg2);
1421: fa_rx_conc_mesg_pkg.log(mesg3);
1422: fa_rx_conc_mesg_pkg.log(mesg4);
1423: fa_rx_conc_mesg_pkg.log(mesg5);
1424: fa_rx_conc_mesg_pkg.log(mesg6);
1425: fa_rx_conc_mesg_pkg.log(mesg7);
1426:
1427:
1428: x_return_status := 2;
1421: fa_rx_conc_mesg_pkg.log(mesg3);
1422: fa_rx_conc_mesg_pkg.log(mesg4);
1423: fa_rx_conc_mesg_pkg.log(mesg5);
1424: fa_rx_conc_mesg_pkg.log(mesg6);
1425: fa_rx_conc_mesg_pkg.log(mesg7);
1426:
1427:
1428: x_return_status := 2;
1429: return (FALSE);
1452:
1453: h_deprn_rsv := nvl(X_deprn_rsv,0);
1454:
1455:
1456: -- fa_rx_conc_mesg_pkg.log('orig.fiscal_year: ' || dpr_arr(0).fiscal_year);
1457: -- fa_rx_conc_mesg_pkg.log('new.fiscal_year: ' || h_start_per_fy);
1458: -- fa_rx_conc_mesg_pkg.log('num per fy: ' || fa_cache_pkg.fazcct_record.NUMBER_PER_FISCAL_YEAR);
1459: -- fa_rx_conc_mesg_pkg.log('h_start_per_num: ' || h_start_per_num );
1460:
1453: h_deprn_rsv := nvl(X_deprn_rsv,0);
1454:
1455:
1456: -- fa_rx_conc_mesg_pkg.log('orig.fiscal_year: ' || dpr_arr(0).fiscal_year);
1457: -- fa_rx_conc_mesg_pkg.log('new.fiscal_year: ' || h_start_per_fy);
1458: -- fa_rx_conc_mesg_pkg.log('num per fy: ' || fa_cache_pkg.fazcct_record.NUMBER_PER_FISCAL_YEAR);
1459: -- fa_rx_conc_mesg_pkg.log('h_start_per_num: ' || h_start_per_num );
1460:
1461: l_st_period_counter := h_start_per_fy *
1454:
1455:
1456: -- fa_rx_conc_mesg_pkg.log('orig.fiscal_year: ' || dpr_arr(0).fiscal_year);
1457: -- fa_rx_conc_mesg_pkg.log('new.fiscal_year: ' || h_start_per_fy);
1458: -- fa_rx_conc_mesg_pkg.log('num per fy: ' || fa_cache_pkg.fazcct_record.NUMBER_PER_FISCAL_YEAR);
1459: -- fa_rx_conc_mesg_pkg.log('h_start_per_num: ' || h_start_per_num );
1460:
1461: l_st_period_counter := h_start_per_fy *
1462: fa_cache_pkg.fazcct_record.NUMBER_PER_FISCAL_YEAR +
1455:
1456: -- fa_rx_conc_mesg_pkg.log('orig.fiscal_year: ' || dpr_arr(0).fiscal_year);
1457: -- fa_rx_conc_mesg_pkg.log('new.fiscal_year: ' || h_start_per_fy);
1458: -- fa_rx_conc_mesg_pkg.log('num per fy: ' || fa_cache_pkg.fazcct_record.NUMBER_PER_FISCAL_YEAR);
1459: -- fa_rx_conc_mesg_pkg.log('h_start_per_num: ' || h_start_per_num );
1460:
1461: l_st_period_counter := h_start_per_fy *
1462: fa_cache_pkg.fazcct_record.NUMBER_PER_FISCAL_YEAR +
1463: h_start_per_num;
1461: l_st_period_counter := h_start_per_fy *
1462: fa_cache_pkg.fazcct_record.NUMBER_PER_FISCAL_YEAR +
1463: h_start_per_num;
1464:
1465: --fa_rx_conc_mesg_pkg.log('l_st_period_counter: ' || l_st_period_counter);
1466:
1467: -- dpr_arr(0).period_num is wrong as start period, it will only
1468: -- cause current open period to be used.
1469:
1493: if dpr_in.method_code = 'JP-STL-EXTND' THEN
1494: if h_chrono_start_per < h_chrono_cur_per then -- If condition Added by Satish Byreddy for Bug# 7135753 . This will calculate the Depreciation from the First Period of Extended Depren.
1495: for h_count in 0 .. (h_delta_index - 1) loop
1496: if (X_mode in ('NORMAL','HYPOTHETICAL')) then
1497: --fa_rx_conc_mesg_pkg.log('step 11');
1498:
1499: -- POPULATE DEPRECIATION COLUMN, SELECTING PERIOD_NAME IN
1500: -- LIEU OF NUMBER/YEAR
1501:
1519: end loop;
1520: end if; -- end of If Condition
1521: end if;
1522:
1523: -- fa_rx_conc_mesg_pkg.log('before loop');
1524: -- fa_rx_conc_mesg_pkg.log('start pc' || l_st_period_counter);
1525: -- fa_rx_conc_mesg_pkg.log('end pc' || l_ed_period_counter);
1526: -- fa_rx_conc_mesg_pkg.log('last: '||to_char(tb_period_name.last));
1527: -- fa_rx_conc_mesg_pkg.log('X_mode: '||X_mode);
1520: end if; -- end of If Condition
1521: end if;
1522:
1523: -- fa_rx_conc_mesg_pkg.log('before loop');
1524: -- fa_rx_conc_mesg_pkg.log('start pc' || l_st_period_counter);
1525: -- fa_rx_conc_mesg_pkg.log('end pc' || l_ed_period_counter);
1526: -- fa_rx_conc_mesg_pkg.log('last: '||to_char(tb_period_name.last));
1527: -- fa_rx_conc_mesg_pkg.log('X_mode: '||X_mode);
1528: -- fa_rx_conc_mesg_pkg.log('h_adj_prev_deprn_exp: '||to_char(h_adj_prev_deprn_exp));
1521: end if;
1522:
1523: -- fa_rx_conc_mesg_pkg.log('before loop');
1524: -- fa_rx_conc_mesg_pkg.log('start pc' || l_st_period_counter);
1525: -- fa_rx_conc_mesg_pkg.log('end pc' || l_ed_period_counter);
1526: -- fa_rx_conc_mesg_pkg.log('last: '||to_char(tb_period_name.last));
1527: -- fa_rx_conc_mesg_pkg.log('X_mode: '||X_mode);
1528: -- fa_rx_conc_mesg_pkg.log('h_adj_prev_deprn_exp: '||to_char(h_adj_prev_deprn_exp));
1529:
1522:
1523: -- fa_rx_conc_mesg_pkg.log('before loop');
1524: -- fa_rx_conc_mesg_pkg.log('start pc' || l_st_period_counter);
1525: -- fa_rx_conc_mesg_pkg.log('end pc' || l_ed_period_counter);
1526: -- fa_rx_conc_mesg_pkg.log('last: '||to_char(tb_period_name.last));
1527: -- fa_rx_conc_mesg_pkg.log('X_mode: '||X_mode);
1528: -- fa_rx_conc_mesg_pkg.log('h_adj_prev_deprn_exp: '||to_char(h_adj_prev_deprn_exp));
1529:
1530: -- Added by Satish Byreddy for Bug# 7128175 . This will calculate the Depreciation from the First Period of Extended Depren
1523: -- fa_rx_conc_mesg_pkg.log('before loop');
1524: -- fa_rx_conc_mesg_pkg.log('start pc' || l_st_period_counter);
1525: -- fa_rx_conc_mesg_pkg.log('end pc' || l_ed_period_counter);
1526: -- fa_rx_conc_mesg_pkg.log('last: '||to_char(tb_period_name.last));
1527: -- fa_rx_conc_mesg_pkg.log('X_mode: '||X_mode);
1528: -- fa_rx_conc_mesg_pkg.log('h_adj_prev_deprn_exp: '||to_char(h_adj_prev_deprn_exp));
1529:
1530: -- Added by Satish Byreddy for Bug# 7128175 . This will calculate the Depreciation from the First Period of Extended Depren
1531:
1524: -- fa_rx_conc_mesg_pkg.log('start pc' || l_st_period_counter);
1525: -- fa_rx_conc_mesg_pkg.log('end pc' || l_ed_period_counter);
1526: -- fa_rx_conc_mesg_pkg.log('last: '||to_char(tb_period_name.last));
1527: -- fa_rx_conc_mesg_pkg.log('X_mode: '||X_mode);
1528: -- fa_rx_conc_mesg_pkg.log('h_adj_prev_deprn_exp: '||to_char(h_adj_prev_deprn_exp));
1529:
1530: -- Added by Satish Byreddy for Bug# 7128175 . This will calculate the Depreciation from the First Period of Extended Depren
1531:
1532:
1531:
1532:
1533: for h_count in (h_start_index + h_delta_index) .. h_end_index loop
1534: if (X_mode in ('NORMAL','HYPOTHETICAL')) then
1535: --fa_rx_conc_mesg_pkg.log('step 11');
1536:
1537: -- POPULATE DEPRECIATION COLUMN, SELECTING PERIOD_NAME IN
1538: -- LIEU OF NUMBER/YEAR
1539: -- BUG # 7193797Added the Begin , Exception in order to handle the case when Number of periods is More than
1599: --tk_util.debug('cache_err: '||sqlerrm);
1600: x_return_status := 2;
1601:
1602: if SQLCODE <> 0 then
1603: fa_Rx_conc_mesg_pkg.log(SQLERRM);
1604: end if;
1605:
1606: g_deprn.delete;
1607: fnd_message.set_name('OFA',h_mesg_name);
1608: if h_mesg_name like 'FA_WHATIF_ASSET%' then
1609: fnd_message.set_token('ASSET_ID',X_asset_id,FALSE);
1610: end if;
1611: h_mesg_str := fnd_message.get;
1612: fa_rx_conc_mesg_pkg.log(h_mesg_str);
1613:
1614: return FALSE;
1615:
1616: when others then
1617: --tk_util.debug('others: '||sqlerrm);
1618: x_return_status := 2;
1619:
1620: if SQLCODE <> 0 then
1621: fa_Rx_conc_mesg_pkg.log(SQLERRM);
1622: end if;
1623:
1624: g_deprn.delete;
1625: fnd_message.set_name('OFA',h_mesg_name);
1626: if h_mesg_name like 'FA_WHATIF_ASSET%' then
1627: fnd_message.set_token('ASSET_ID',X_asset_id,FALSE);
1628: end if;
1629: h_mesg_str := fnd_message.get;
1630: fa_rx_conc_mesg_pkg.log(h_mesg_str);
1631:
1632: return FALSE;
1633:
1634:
2195: when others then
2196:
2197:
2198: if SQLCODE <> 0 then
2199: fa_Rx_conc_mesg_pkg.log(SQLERRM);
2200: end if;
2201:
2202: if (dist_lines%ISOPEN) then
2203: close dist_lines;
2215: fnd_message.set_token('CCID',h_ccid_error,FALSE);
2216: fnd_message.set_token('FLEX_CODE',h_flex_error,FALSE);
2217: end if;
2218: h_mesg_str := fnd_message.get;
2219: fa_rx_conc_mesg_pkg.log(h_mesg_str);
2220:
2221: x_return_status := 2;
2222: return FALSE;
2223: