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_ADDITION_PVT dependencies on FA_CACHE_PKG

Line 4: g_release number := fa_cache_pkg.fazarel_release;

1: PACKAGE BODY FA_ADDITION_PVT AS
2: /* $Header: FAVADDB.pls 120.64.12020000.5 2013/04/08 09:40:01 gigupta ship $ */
3:
4: g_release number := fa_cache_pkg.fazarel_release;
5:
6: function initialize (
7: -- Transaction Object --
8: px_trans_rec IN OUT NOCOPY fa_api_types.trans_rec_type,

Line 164: if (fa_cache_pkg.fazcbc_record.book_class = 'CORPORATE') then

160: px_asset_dist_tbl(i).units_assigned;
161: end loop;
162:
163: -- For corporate books, default the following info if its null
164: if (fa_cache_pkg.fazcbc_record.book_class = 'CORPORATE') then
165:
166: if (px_asset_hdr_rec.asset_id is null) then
167: -- Pop the asset_id
168: select fa_additions_s.nextval

Line 174: if not fa_cache_pkg.fazcat (

170: from dual;
171: end if;
172:
173: -- Get defaults from the category.
174: if not fa_cache_pkg.fazcat (
175: X_cat_id => px_asset_cat_rec.category_id
176: , p_log_level_rec => p_log_level_rec) then
177: raise init_err;
178: end if;

Line 229: fa_cache_pkg.fazcat_record.inventorial;

225:
226: if (px_asset_desc_rec.inventorial = FND_API.G_MISS_CHAR or
227: px_asset_desc_rec.inventorial is null) then
228: px_asset_desc_rec.inventorial :=
229: fa_cache_pkg.fazcat_record.inventorial;
230: end if;
231:
232: if (px_asset_desc_rec.property_type_code = FND_API.G_MISS_CHAR or
233: px_asset_desc_rec.property_type_code is null) then

Line 235: fa_cache_pkg.fazcat_record.property_type_code;

231:
232: if (px_asset_desc_rec.property_type_code = FND_API.G_MISS_CHAR or
233: px_asset_desc_rec.property_type_code is null) then
234: px_asset_desc_rec.property_type_code :=
235: fa_cache_pkg.fazcat_record.property_type_code;
236: end if;
237:
238: if (px_asset_desc_rec.property_1245_1250_code = FND_API.G_MISS_CHAR or
239: px_asset_desc_rec.property_1245_1250_code is null) then

Line 241: fa_cache_pkg.fazcat_record.property_1245_1250_code;

237:
238: if (px_asset_desc_rec.property_1245_1250_code = FND_API.G_MISS_CHAR or
239: px_asset_desc_rec.property_1245_1250_code is null) then
240: px_asset_desc_rec.property_1245_1250_code :=
241: fa_cache_pkg.fazcat_record.property_1245_1250_code;
242: end if;
243:
244: if (px_asset_desc_rec.owned_leased = FND_API.G_MISS_CHAR or
245: px_asset_desc_rec.owned_leased is null) then

Line 247: fa_cache_pkg.fazcat_record.owned_leased;

243:
244: if (px_asset_desc_rec.owned_leased = FND_API.G_MISS_CHAR or
245: px_asset_desc_rec.owned_leased is null) then
246: px_asset_desc_rec.owned_leased :=
247: fa_cache_pkg.fazcat_record.owned_leased;
248: end if;
249:
250: if (px_asset_desc_rec.new_used = FND_API.G_MISS_CHAR or
251: px_asset_desc_rec.new_used is null) then

Line 284: fa_cache_pkg.fazcat_record.capitalize_flag;

280: end if;
281:
282: if (px_asset_fin_rec.capitalize_flag = NULL) then
283: px_asset_fin_rec.capitalize_flag :=
284: fa_cache_pkg.fazcat_record.capitalize_flag;
285: end if;
286:
287: if (px_asset_fin_rec.global_attribute1 = FND_API.G_MISS_CHAR) then
288: px_asset_fin_rec.global_attribute1 := NULL;

Line 373: l_return_status := fa_cache_pkg.fazsys(p_log_level_rec);

369: end if;
370:
371: if (px_asset_cat_rec.desc_flex.attribute_category_code is null) then
372:
373: l_return_status := fa_cache_pkg.fazsys(p_log_level_rec);
374:
375: if not (l_return_status) then
376: raise init_err;
377: else

Line 379: fa_cache_pkg.fazsys_record.category_flex_structure;

375: if not (l_return_status) then
376: raise init_err;
377: else
378: l_category_chart_id :=
379: fa_cache_pkg.fazsys_record.category_flex_structure;
380: end if;
381:
382: l_return_status := fa_flex_pvt.get_concat_segs (
383: p_ccid => px_asset_cat_rec.category_id,

Line 433: fa_cache_pkg.fazcbc_record.distribution_source_book

429: into px_asset_fin_rec.cost,
430: px_asset_fin_rec.date_placed_in_service
431: from fa_books bks
432: where book_type_code =
433: fa_cache_pkg.fazcbc_record.distribution_source_book
434: and asset_id = px_asset_hdr_rec.asset_id
435: and transaction_header_id_out is null;
436: end if;
437:

Line 477: if (fa_cache_pkg.fazcbc_record.book_class = 'CORPORATE') then

473:
474: if ((px_trans_rec.transaction_date_entered is null) and
475: (px_asset_fin_rec.date_placed_in_service is null)) then
476:
477: if (fa_cache_pkg.fazcbc_record.book_class = 'CORPORATE') then
478: -- Default to last day of the period
479: px_asset_fin_rec.date_placed_in_service :=
480: l_period_rec.calendar_period_close_date;
481: end if;

Line 531: if (fa_cache_pkg.fazcbc_record.book_class = 'CORPORATE') then

527: else
528: px_trans_rec.transaction_type_code := 'ADDITION';
529: end if;
530:
531: if (fa_cache_pkg.fazcbc_record.book_class = 'CORPORATE') then
532: -- Set the default values for the distribution trans rec if corp book
533: px_dist_trans_rec.transaction_type_code := 'TRANSFER IN';
534:
535: px_dist_trans_rec.transaction_date_entered :=

Line 573: if not fa_cache_pkg.fazccbd (X_book => px_asset_hdr_rec.book_type_code,

569: -- following section is for setting various defaults from the category
570: -- if needed - this code used to reside in the calculation engine
571: -- but has grown complex and easier to place it here.
572:
573: if not fa_cache_pkg.fazccbd (X_book => px_asset_hdr_rec.book_type_code,
574: X_cat_id => px_asset_cat_rec.category_id,
575: X_jdpis => to_number(to_char(px_asset_fin_rec.date_placed_in_service, 'J')),
576: p_log_level_rec => p_log_level_rec) then
577: raise init_err;

Line 585: px_asset_fin_rec.deprn_method_code := fa_cache_pkg.fazccbd_record.deprn_method;

581: -- default from the parent rules (if applicable) or from the category
582:
583: if (px_asset_fin_rec.deprn_method_code is null) then
584:
585: px_asset_fin_rec.deprn_method_code := fa_cache_pkg.fazccbd_record.deprn_method;
586: px_asset_fin_rec.life_in_months := fa_cache_pkg.fazccbd_record.life_in_months;
587: px_asset_fin_rec.basic_rate := fa_cache_pkg.fazccbd_record.basic_rate;
588: px_asset_fin_rec.adjusted_rate := fa_cache_pkg.fazccbd_record.adjusted_rate;
589:

Line 586: px_asset_fin_rec.life_in_months := fa_cache_pkg.fazccbd_record.life_in_months;

582:
583: if (px_asset_fin_rec.deprn_method_code is null) then
584:
585: px_asset_fin_rec.deprn_method_code := fa_cache_pkg.fazccbd_record.deprn_method;
586: px_asset_fin_rec.life_in_months := fa_cache_pkg.fazccbd_record.life_in_months;
587: px_asset_fin_rec.basic_rate := fa_cache_pkg.fazccbd_record.basic_rate;
588: px_asset_fin_rec.adjusted_rate := fa_cache_pkg.fazccbd_record.adjusted_rate;
589:
590: -- BUG# 2417520 - mass additions can send in prod capacity only, so allow this

Line 587: px_asset_fin_rec.basic_rate := fa_cache_pkg.fazccbd_record.basic_rate;

583: if (px_asset_fin_rec.deprn_method_code is null) then
584:
585: px_asset_fin_rec.deprn_method_code := fa_cache_pkg.fazccbd_record.deprn_method;
586: px_asset_fin_rec.life_in_months := fa_cache_pkg.fazccbd_record.life_in_months;
587: px_asset_fin_rec.basic_rate := fa_cache_pkg.fazccbd_record.basic_rate;
588: px_asset_fin_rec.adjusted_rate := fa_cache_pkg.fazccbd_record.adjusted_rate;
589:
590: -- BUG# 2417520 - mass additions can send in prod capacity only, so allow this
591: px_asset_fin_rec.production_capacity := nvl(px_asset_fin_rec.production_capacity,

Line 588: px_asset_fin_rec.adjusted_rate := fa_cache_pkg.fazccbd_record.adjusted_rate;

584:
585: px_asset_fin_rec.deprn_method_code := fa_cache_pkg.fazccbd_record.deprn_method;
586: px_asset_fin_rec.life_in_months := fa_cache_pkg.fazccbd_record.life_in_months;
587: px_asset_fin_rec.basic_rate := fa_cache_pkg.fazccbd_record.basic_rate;
588: px_asset_fin_rec.adjusted_rate := fa_cache_pkg.fazccbd_record.adjusted_rate;
589:
590: -- BUG# 2417520 - mass additions can send in prod capacity only, so allow this
591: px_asset_fin_rec.production_capacity := nvl(px_asset_fin_rec.production_capacity,
592: fa_cache_pkg.fazccbd_record.production_capacity);

Line 592: fa_cache_pkg.fazccbd_record.production_capacity);

588: px_asset_fin_rec.adjusted_rate := fa_cache_pkg.fazccbd_record.adjusted_rate;
589:
590: -- BUG# 2417520 - mass additions can send in prod capacity only, so allow this
591: px_asset_fin_rec.production_capacity := nvl(px_asset_fin_rec.production_capacity,
592: fa_cache_pkg.fazccbd_record.production_capacity);
593:
594: -- BUG# 3066139 - need to default UOP as well
595: px_asset_fin_rec.unit_of_measure := nvl(px_asset_fin_rec.unit_of_measure,
596: fa_cache_pkg.fazccbd_record.unit_of_measure);

Line 596: fa_cache_pkg.fazccbd_record.unit_of_measure);

592: fa_cache_pkg.fazccbd_record.production_capacity);
593:
594: -- BUG# 3066139 - need to default UOP as well
595: px_asset_fin_rec.unit_of_measure := nvl(px_asset_fin_rec.unit_of_measure,
596: fa_cache_pkg.fazccbd_record.unit_of_measure);
597:
598: if (nvl(fa_cache_pkg.fazccbd_record.subcomponent_life_rule, 'NULL') <> 'NULL' and
599: nvl(px_asset_desc_rec.parent_asset_id, -99) <> -99) then
600:

Line 598: if (nvl(fa_cache_pkg.fazccbd_record.subcomponent_life_rule, 'NULL') <> 'NULL' and

594: -- BUG# 3066139 - need to default UOP as well
595: px_asset_fin_rec.unit_of_measure := nvl(px_asset_fin_rec.unit_of_measure,
596: fa_cache_pkg.fazccbd_record.unit_of_measure);
597:
598: if (nvl(fa_cache_pkg.fazccbd_record.subcomponent_life_rule, 'NULL') <> 'NULL' and
599: nvl(px_asset_desc_rec.parent_asset_id, -99) <> -99) then
600:
601: if not FA_ASSET_CALC_PVT.calc_subcomp_life
602: (p_trans_rec => px_trans_rec,

Line 619: if not fa_cache_pkg.fazccmt

615:
616:
617: /*Bug# 7715087 -to default amortization start date for energy if not provided.
618: Initialize the cache first*/
619: if not fa_cache_pkg.fazccmt
620: (X_method => px_asset_fin_rec.deprn_method_code,
621: X_life => px_asset_fin_rec.life_in_months, p_log_level_rec => p_log_level_rec) then
622: raise init_err;
623: end if;

Line 624: if( fa_cache_pkg.fazccmt_record.rate_source_rule = 'PRODUCTION'

620: (X_method => px_asset_fin_rec.deprn_method_code,
621: X_life => px_asset_fin_rec.life_in_months, p_log_level_rec => p_log_level_rec) then
622: raise init_err;
623: end if;
624: if( fa_cache_pkg.fazccmt_record.rate_source_rule = 'PRODUCTION'
625: AND fa_cache_pkg.fazcdrd_record.rule_name = 'ENERGY PERIOD END BALANCE') then
626: open c_get_context_date(px_asset_hdr_rec.book_type_code);
627: fetch c_get_context_date into l_trx_date ;
628: close c_get_context_date;

Line 625: AND fa_cache_pkg.fazcdrd_record.rule_name = 'ENERGY PERIOD END BALANCE') then

621: X_life => px_asset_fin_rec.life_in_months, p_log_level_rec => p_log_level_rec) then
622: raise init_err;
623: end if;
624: if( fa_cache_pkg.fazccmt_record.rate_source_rule = 'PRODUCTION'
625: AND fa_cache_pkg.fazcdrd_record.rule_name = 'ENERGY PERIOD END BALANCE') then
626: open c_get_context_date(px_asset_hdr_rec.book_type_code);
627: fetch c_get_context_date into l_trx_date ;
628: close c_get_context_date;
629: if( px_trans_rec.amortization_start_date is null ) then

Line 636: if( fa_cache_pkg.fazccmt_record.deprn_basis_rule = 'NBV'

632: end if;
633: end if;
634: --Bug# 7715087 end
635: /*bug#15897249 starts*/
636: if( fa_cache_pkg.fazccmt_record.deprn_basis_rule = 'NBV'
637: AND fa_cache_pkg.fazcdrd_record.rule_name = 'YEAR END BALANCE WITH POSITIVE REDUCTION AMOUNT'
638: AND px_asset_type_rec.asset_type = 'GROUP'
639: AND px_asset_fin_rec.tracking_method = 'CALCULATE'
640: AND px_asset_fin_rec.member_rollup_flag = 'Y'

Line 637: AND fa_cache_pkg.fazcdrd_record.rule_name = 'YEAR END BALANCE WITH POSITIVE REDUCTION AMOUNT'

633: end if;
634: --Bug# 7715087 end
635: /*bug#15897249 starts*/
636: if( fa_cache_pkg.fazccmt_record.deprn_basis_rule = 'NBV'
637: AND fa_cache_pkg.fazcdrd_record.rule_name = 'YEAR END BALANCE WITH POSITIVE REDUCTION AMOUNT'
638: AND px_asset_type_rec.asset_type = 'GROUP'
639: AND px_asset_fin_rec.tracking_method = 'CALCULATE'
640: AND px_asset_fin_rec.member_rollup_flag = 'Y'
641: AND px_asset_fin_rec.exclude_proceeds_from_basis is null

Line 649: fa_cache_pkg.fazccbd_record.bonus_rule;

645: /*bug#15897249 ends */
646:
647: if (px_asset_fin_rec.bonus_rule is null) then
648: px_asset_fin_rec.bonus_rule :=
649: fa_cache_pkg.fazccbd_record.bonus_rule;
650: elsif (px_asset_fin_rec.bonus_rule = FND_API.G_MISS_CHAR) then
651: px_asset_fin_rec.bonus_rule := NULL;
652: end if;
653:

Line 656: fa_cache_pkg.fazccbd_record.ceiling_name;

652: end if;
653:
654: if (px_asset_fin_rec.ceiling_name is null) then
655: px_asset_fin_rec.ceiling_name :=
656: fa_cache_pkg.fazccbd_record.ceiling_name;
657: elsif (px_asset_fin_rec.ceiling_name = FND_API.G_MISS_CHAR) then
658: px_asset_fin_rec.ceiling_name := NULL;
659: end if;
660:

Line 668: (p_group_asset_id => fa_cache_pkg.fazccbd_record.group_asset_id,

664: if px_asset_type_rec.asset_type <> 'GROUP' then
665: if (px_asset_fin_rec.group_asset_id is null) then
666: --Call validate disabled_flag to confirm default group is not disabled
667: if NOT FA_ASSET_VAL_PVT.validate_group_info
668: (p_group_asset_id => fa_cache_pkg.fazccbd_record.group_asset_id,
669: p_book_type_code => px_asset_hdr_rec.book_type_code,
670: p_calling_fn => 'fa_addition_pvt.initialize', p_log_level_rec => p_log_level_rec) then
671: fa_srvr_msg.add_message(calling_fn => 'fa_addition_pvt.initialize',
672: name => 'FA_DISABLED_DEFAULT_GROUP', p_log_level_rec => p_log_level_rec);

Line 678: (fa_cache_pkg.fazcbc_record.allow_cip_member_flag = 'Y')) then

674: end if;
675: --HH do this check for conditional group defaulting
676: if (px_asset_type_rec.asset_type <> 'CIP') OR
677: ((px_asset_type_rec.asset_type = 'CIP') AND
678: (fa_cache_pkg.fazcbc_record.allow_cip_member_flag = 'Y')) then
679: px_asset_fin_rec.group_asset_id := fa_cache_pkg.fazccbd_record.group_asset_id;
680: else
681: px_asset_fin_rec.group_asset_id := NULL;
682: /* fa_srvr_msg.add_message(calling_fn => 'fa_addition_pvt.initialize',

Line 679: px_asset_fin_rec.group_asset_id := fa_cache_pkg.fazccbd_record.group_asset_id;

675: --HH do this check for conditional group defaulting
676: if (px_asset_type_rec.asset_type <> 'CIP') OR
677: ((px_asset_type_rec.asset_type = 'CIP') AND
678: (fa_cache_pkg.fazcbc_record.allow_cip_member_flag = 'Y')) then
679: px_asset_fin_rec.group_asset_id := fa_cache_pkg.fazccbd_record.group_asset_id;
680: else
681: px_asset_fin_rec.group_asset_id := NULL;
682: /* fa_srvr_msg.add_message(calling_fn => 'fa_addition_pvt.initialize',
683: name => 'FA_CIP_MEMBER_NOT_ALLOWED', p_log_level_rec => p_log_level_rec);

Line 702: if (fa_cache_pkg.fazcbc_record.book_class = 'TAX' and

698:
699: if (px_asset_fin_rec.salvage_type is null) then
700: if (px_asset_fin_rec.percent_salvage_value is null and
701: px_asset_fin_rec.salvage_value is null) then
702: if (fa_cache_pkg.fazcbc_record.book_class = 'TAX' and
703: px_trans_rec.source_transaction_header_id is not null and
704: fa_cache_pkg.fazcbc_record.copy_salvage_value_flag = 'YES') then
705: -- get the primary corp book value from source transaction
706: -- using this and then converting in case mrc is anabled on tax

Line 704: fa_cache_pkg.fazcbc_record.copy_salvage_value_flag = 'YES') then

700: if (px_asset_fin_rec.percent_salvage_value is null and
701: px_asset_fin_rec.salvage_value is null) then
702: if (fa_cache_pkg.fazcbc_record.book_class = 'TAX' and
703: px_trans_rec.source_transaction_header_id is not null and
704: fa_cache_pkg.fazcbc_record.copy_salvage_value_flag = 'YES') then
705: -- get the primary corp book value from source transaction
706: -- using this and then converting in case mrc is anabled on tax
707: -- books but not on corp
708:

Line 719: fa_cache_pkg.fazccbd_record.percent_salvage_value;

715: px_asset_fin_rec.salvage_value := 0;
716: end if;
717: else -- corp, manual tax, or no copy salvage
718: px_asset_fin_rec.percent_salvage_value :=
719: fa_cache_pkg.fazccbd_record.percent_salvage_value;
720: end if;
721: end if;
722:
723: if (px_asset_fin_rec.percent_salvage_value is null) then

Line 736: px_asset_fin_rec.percent_salvage_value := nvl(fa_cache_pkg.fazccbd_record.percent_salvage_value, 0);

732: end if;
733:
734: elsif (px_asset_fin_rec.salvage_type = 'PCT' and
735: px_asset_fin_rec.percent_salvage_value is null) then
736: px_asset_fin_rec.percent_salvage_value := nvl(fa_cache_pkg.fazccbd_record.percent_salvage_value, 0);
737: elsif (px_asset_fin_rec.salvage_type = 'AMT' and
738: px_asset_fin_rec.salvage_value is null) then
739: px_asset_fin_rec.salvage_value := 0;
740: elsif (px_asset_fin_rec.salvage_type <> 'PCT' and

Line 759: if (fa_cache_pkg.fazccbd_record.use_deprn_limits_flag = 'YES') then

755:
756: if (px_asset_fin_rec.deprn_limit_type is null) then
757: if (px_asset_fin_rec.allowed_deprn_limit_amount is null and
758: px_asset_fin_rec.allowed_deprn_limit is null) then
759: if (fa_cache_pkg.fazccbd_record.use_deprn_limits_flag = 'YES') then
760: px_asset_fin_rec.allowed_deprn_limit :=
761: fa_cache_pkg.fazccbd_record.allowed_deprn_limit;
762: px_asset_fin_rec.allowed_deprn_limit_amount :=
763: fa_cache_pkg.fazccbd_record.special_deprn_limit_amount;

Line 761: fa_cache_pkg.fazccbd_record.allowed_deprn_limit;

757: if (px_asset_fin_rec.allowed_deprn_limit_amount is null and
758: px_asset_fin_rec.allowed_deprn_limit is null) then
759: if (fa_cache_pkg.fazccbd_record.use_deprn_limits_flag = 'YES') then
760: px_asset_fin_rec.allowed_deprn_limit :=
761: fa_cache_pkg.fazccbd_record.allowed_deprn_limit;
762: px_asset_fin_rec.allowed_deprn_limit_amount :=
763: fa_cache_pkg.fazccbd_record.special_deprn_limit_amount;
764: end if;
765: end if;

Line 763: fa_cache_pkg.fazccbd_record.special_deprn_limit_amount;

759: if (fa_cache_pkg.fazccbd_record.use_deprn_limits_flag = 'YES') then
760: px_asset_fin_rec.allowed_deprn_limit :=
761: fa_cache_pkg.fazccbd_record.allowed_deprn_limit;
762: px_asset_fin_rec.allowed_deprn_limit_amount :=
763: fa_cache_pkg.fazccbd_record.special_deprn_limit_amount;
764: end if;
765: end if;
766:
767: if (px_asset_fin_rec.allowed_deprn_limit is not null) then

Line 778: fa_cache_pkg.fazccbd_record.allowed_deprn_limit;

774:
775: elsif (px_asset_fin_rec.deprn_limit_type = 'PCT' and
776: px_asset_fin_rec.allowed_deprn_limit is null) then
777: px_asset_fin_rec.allowed_deprn_limit:=
778: fa_cache_pkg.fazccbd_record.allowed_deprn_limit;
779: if (px_asset_fin_rec.allowed_deprn_limit is null) then
780: fa_srvr_msg.add_message(
781: calling_fn => 'fa_addition_pvt.initialize',
782: name => '***FA_MUST_SPECIFY_LIMIT***',

Line 789: fa_cache_pkg.fazccbd_record.special_deprn_limit_amount;

785: end if;
786: elsif (px_asset_fin_rec.deprn_limit_type = 'AMT' and
787: px_asset_fin_rec.allowed_deprn_limit_amount is null) then
788: px_asset_fin_rec.allowed_deprn_limit_amount:=
789: fa_cache_pkg.fazccbd_record.special_deprn_limit_amount;
790: if (px_asset_fin_rec.allowed_deprn_limit_amount is null) then
791: fa_srvr_msg.add_message(
792: calling_fn => 'fa_addition_pvt.initialize',
793: name => '***FA_MUST_SPECIFY_LIMIT***',

Line 888: if not fa_cache_pkg.fazccmt

884: 'px_asset_fin_rec.over_depreciate_option',
885: px_asset_fin_rec.over_depreciate_option, p_log_level_rec => p_log_level_rec);
886: end if;
887:
888: if not fa_cache_pkg.fazccmt
889: (X_method => px_asset_fin_rec.deprn_method_code,
890: X_life => px_asset_fin_rec.life_in_months, p_log_level_rec => p_log_level_rec) then
891: raise init_err;
892: end if;

Line 894: if (nvl(fa_cache_pkg.fazcdrd_record.allow_reduction_rate_flag, 'N') = 'N') then

890: X_life => px_asset_fin_rec.life_in_months, p_log_level_rec => p_log_level_rec) then
891: raise init_err;
892: end if;
893:
894: if (nvl(fa_cache_pkg.fazcdrd_record.allow_reduction_rate_flag, 'N') = 'N') then
895: px_asset_fin_rec.reduction_rate := to_number(null);
896: px_asset_fin_rec.reduce_addition_flag := null;
897: px_asset_fin_rec.reduce_adjustment_flag := null;
898: px_asset_fin_rec.reduce_adjustment_flag := null;

Line 954: nvl(fa_cache_pkg.fazcdrd_record.rule_name,'ZZ') <> 'YEAR END BALANCE WITH POSITIVE REDUCTION AMOUNT')

950: /*bug#15897249 modified if statement */
951: if ((px_asset_fin_rec.recognize_gain_loss = 'NO') or
952: (px_asset_fin_rec.terminal_gain_loss <> 'YES')) and
953: ((px_asset_fin_rec.member_rollup_flag = 'Y' and
954: nvl(fa_cache_pkg.fazcdrd_record.rule_name,'ZZ') <> 'YEAR END BALANCE WITH POSITIVE REDUCTION AMOUNT')
955: ) then
956: fa_srvr_msg.add_message(
957: calling_fn => 'fa_addition_pvt.initialize',
958: name => 'FA_INVALID_PARAMETER',

Line 1185: and mcbc.book_type_code = fa_cache_pkg.fazcbc_record.distribution_source_book

1181: and gltr.ledger_id = p_asset_hdr_rec.set_of_books_id
1182: and gltr.currency_code = glcr.currency_code
1183: and gltr.chart_of_accounts_id = glcr.chart_of_accounts_id
1184: and gltr.ledger_id <> glcr.ledger_id
1185: and mcbc.book_type_code = fa_cache_pkg.fazcbc_record.distribution_source_book
1186: and glcr.ledger_id = mcbc.set_of_books_id;
1187: begin
1188:
1189: l_period_counter := fa_cache_pkg.fazcbc_record.last_period_counter;

Line 1189: l_period_counter := fa_cache_pkg.fazcbc_record.last_period_counter;

1185: and mcbc.book_type_code = fa_cache_pkg.fazcbc_record.distribution_source_book
1186: and glcr.ledger_id = mcbc.set_of_books_id;
1187: begin
1188:
1189: l_period_counter := fa_cache_pkg.fazcbc_record.last_period_counter;
1190:
1191: l_rowid := NULL;
1192: l_transaction_header_id := p_trans_rec.transaction_header_id;
1193: l_trans_in_header_id := p_dist_trans_rec.transaction_header_id;

Line 1201: if (fa_cache_pkg.fazcbc_record.book_class = 'CORPORATE') then

1197: deprn_override_flag_default:= fa_std_types.FA_NO_OVERRIDE;
1198:
1199: if (p_mrc_sob_type_code <> 'R') then
1200:
1201: if (fa_cache_pkg.fazcbc_record.book_class = 'CORPORATE') then
1202:
1203: -- Insert into fa_additions.
1204: l_rowid := NULL;
1205: l_asset_id := p_asset_hdr_rec.asset_id;

Line 1467: if (fa_cache_pkg.fazcbc_record.book_class = 'CORPORATE') then

1463: end if;
1464:
1465: l_rowid := NULL;
1466:
1467: if (fa_cache_pkg.fazcbc_record.book_class = 'CORPORATE') then
1468:
1469: fa_transaction_headers_pkg.insert_row (
1470: X_Rowid => l_rowid,
1471: X_Transaction_Header_Id => l_trans_in_header_id,

Line 1670: if (fa_cache_pkg.fazcbc_record.book_class = 'CORPORATE') then

1666: raise general_error;
1667: end if;
1668:
1669: if ( p_mrc_sob_type_code <> 'R') then
1670: if (fa_cache_pkg.fazcbc_record.book_class = 'CORPORATE') then
1671:
1672: -- Insert into fa_asset_history.
1673: l_rowid := NULL;
1674:

Line 1789: l_status := fa_cache_pkg.fazcbc (

1785:
1786:
1787: -- BUG# 2115343 need to reset the cache to the active book after faxindd
1788:
1789: l_status := fa_cache_pkg.fazcbc (
1790: X_book => p_asset_hdr_rec.book_type_code
1791: , p_log_level_rec => p_log_level_rec);
1792:
1793: if not (l_status) then

Line 1798: if not fa_cache_pkg.fazccmt

1794: raise general_error;
1795: end if;
1796:
1797: -- Insert into fa_books_summary if polish rule
1798: if not fa_cache_pkg.fazccmt
1799: (X_method => p_asset_fin_rec.deprn_method_code,
1800: X_life => p_asset_fin_rec.life_in_months, p_log_level_rec => p_log_level_rec) then
1801: raise general_error;
1802: end if;

Line 2204: l_adj.period_counter_created := fa_cache_pkg.fazcbc_record.last_period_counter + 1;

2200:
2201: l_adj.transaction_header_id := p_trans_rec.transaction_header_id;
2202: l_adj.asset_id := p_asset_hdr_rec.asset_id;
2203: l_adj.book_type_code := p_asset_hdr_rec.book_type_code;
2204: l_adj.period_counter_created := fa_cache_pkg.fazcbc_record.last_period_counter + 1;
2205: l_adj.period_counter_adjusted := fa_cache_pkg.fazcbc_record.last_period_counter + 1;
2206: l_adj.current_units := p_asset_desc_rec.current_units ;
2207: l_adj.selection_mode := FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE;
2208: l_adj.selection_thid := 0;

Line 2205: l_adj.period_counter_adjusted := fa_cache_pkg.fazcbc_record.last_period_counter + 1;

2201: l_adj.transaction_header_id := p_trans_rec.transaction_header_id;
2202: l_adj.asset_id := p_asset_hdr_rec.asset_id;
2203: l_adj.book_type_code := p_asset_hdr_rec.book_type_code;
2204: l_adj.period_counter_created := fa_cache_pkg.fazcbc_record.last_period_counter + 1;
2205: l_adj.period_counter_adjusted := fa_cache_pkg.fazcbc_record.last_period_counter + 1;
2206: l_adj.current_units := p_asset_desc_rec.current_units ;
2207: l_adj.selection_mode := FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE;
2208: l_adj.selection_thid := 0;
2209: l_adj.selection_retid := 0;

Line 2280: if fa_cache_pkg.fazcbc_record.book_class = 'TAX' and l_payables_cost_tbl.count = 0 then

2276: l_payables_cost_tbl,
2277: l_payables_ccid_tbl;
2278: close c_mc_invoices;
2279: /*Bug 16463079 */
2280: if fa_cache_pkg.fazcbc_record.book_class = 'TAX' and l_payables_cost_tbl.count = 0 then
2281: open c_mc_invoices_sec(p_asset_id => p_asset_hdr_rec.asset_id,
2282: p_invoice_transaction_id => p_inv_trans_rec.invoice_transaction_id);
2283: FETCH c_mc_invoices_sec bulk collect
2284: into l_source_line_id_tbl,

Line 2366: if nvl(fa_cache_pkg.fazccmt_record.guarantee_rate_method_flag,'NO') = 'YES' then

2362: end if;
2363:
2364: -- Bug:5930979:Japan Tax Reform Project (Start)
2365: -- Modified below code for Japan enhancement 6606548 (Backdated Asset Addition for JP-250DB methods)
2366: if nvl(fa_cache_pkg.fazccmt_record.guarantee_rate_method_flag,'NO') = 'YES' then
2367:
2368: p_asset_fin_rec.nbv_at_switch := nvl(p_asset_fin_rec.nbv_at_switch,0); -- Changes made as per the ER No.s 6606548 and 6606552 by Sbyreddy Start
2369:
2370: -- deprn reserve not entered and nbv_at_switch entered

Line 2627: if nvl(fa_cache_pkg.fazccmt_record.guarantee_rate_method_flag,'NO') = 'YES' then

2623: -- End of Japan profile option value
2624:
2625: -- if px_asset_fin_rec.deprn_method_code like 'JP%250DB%' then
2626: -- JP_TAX_2012
2627: if nvl(fa_cache_pkg.fazccmt_record.guarantee_rate_method_flag,'NO') = 'YES' then
2628: px_asset_fin_rec.prior_deprn_limit_type := null;
2629: px_asset_fin_rec.prior_deprn_limit_amount := null;
2630: px_asset_fin_rec.prior_deprn_limit := null;
2631: px_asset_fin_rec.extended_depreciation_period := null;