DBA Data[Home] [Help]

APPS.FA_RETIREMENT_PVT dependencies on FA_UTIL_PVT

Line 143: if not FA_UTIL_PVT.get_asset_desc_rec (

139: g_current_units := nvl(p_asset_desc_rec.current_units,0);
140:
141: -- Get asset description for member asset
142: -- p_asset_desc may be null
143: if not FA_UTIL_PVT.get_asset_desc_rec (
144: p_asset_hdr_rec => p_asset_hdr_rec,
145: px_asset_desc_rec => l_asset_desc_rec_m,
146: p_log_level_rec => p_log_level_rec) then
147: raise ret_err;

Line 187: if not FA_UTIL_PVT.get_asset_type_rec (

183: l_asset_hdr_rec.book_type_code := p_asset_hdr_rec.book_type_code;
184: l_asset_hdr_rec.set_of_books_id := p_asset_hdr_rec.set_of_books_id;
185: --l_asset_hdr_rec.period_of_addition := 'N'; -- Guess not necessary
186:
187: if not FA_UTIL_PVT.get_asset_type_rec (
188: p_asset_hdr_rec => l_asset_hdr_rec,
189: px_asset_type_rec => l_asset_type_rec
190: ,p_log_level_rec => p_log_level_rec) then
191: raise ret_err;

Line 194: if not FA_UTIL_PVT.get_asset_desc_rec (

190: ,p_log_level_rec => p_log_level_rec) then
191: raise ret_err;
192: end if;
193:
194: if not FA_UTIL_PVT.get_asset_desc_rec (
195: p_asset_hdr_rec => l_asset_hdr_rec,
196: px_asset_desc_rec => l_asset_desc_rec,
197: p_log_level_rec => p_log_level_rec) then
198: raise ret_err;

Line 201: if not FA_UTIL_PVT.get_asset_cat_rec (

197: p_log_level_rec => p_log_level_rec) then
198: raise ret_err;
199: end if;
200:
201: if not FA_UTIL_PVT.get_asset_cat_rec (
202: p_asset_hdr_rec => l_asset_hdr_rec,
203: px_asset_cat_rec => l_asset_cat_rec,
204: p_date_effective => null,
205: p_log_level_rec => p_log_level_rec) then

Line 209: if not fa_util_pvt.get_asset_fin_rec (

205: p_log_level_rec => p_log_level_rec) then
206: raise ret_err;
207: end if;
208:
209: if not fa_util_pvt.get_asset_fin_rec (
210: p_asset_hdr_rec => l_asset_hdr_rec,
211: px_asset_fin_rec => l_asset_fin_rec_old,
212: p_mrc_sob_type_code => p_mrc_sob_type_code,
213: p_log_level_rec => p_log_level_rec) then

Line 219: if not fa_util_pvt.get_asset_deprn_rec (

215: end if;
216:
217: --tk_util.DumpFinRec(l_asset_fin_rec_old, 'OLD');
218:
219: if not fa_util_pvt.get_asset_deprn_rec (
220: p_asset_hdr_rec => l_asset_hdr_rec,
221: px_asset_deprn_rec => l_asset_deprn_rec_old,
222: p_mrc_sob_type_code => p_mrc_sob_type_code,
223: p_log_level_rec => p_log_level_rec) then

Line 241: if not fa_util_pvt.get_asset_fin_rec (

237:
238: l_asset_deprn_rec_adj.deprn_reserve := -1 * p_asset_retire_rec.reserve_retired;
239:
240: -- Get new member's fin_rec
241: if not fa_util_pvt.get_asset_fin_rec (
242: p_asset_hdr_rec => p_asset_hdr_rec,
243: px_asset_fin_rec => l_asset_fin_rec_new_m,
244: p_mrc_sob_type_code => p_mrc_sob_type_code,
245: p_log_level_rec => p_log_level_rec) then

Line 412: if not fa_util_pvt.get_asset_deprn_rec (

408:
409: raise ret_err;
410: end if;
411: /* Added for bug 7537762 */
412: if not fa_util_pvt.get_asset_deprn_rec (
413: p_asset_hdr_rec => l_asset_hdr_rec,
414: px_asset_deprn_rec => l_asset_deprn_rec_old,
415: p_mrc_sob_type_code => p_mrc_sob_type_code,
416: p_log_level_rec => p_log_level_rec) then

Line 855: if not FA_UTIL_PVT.get_period_rec

851: fa_debug_pkg.add(l_calling_fn, 'Begin', p_asset_hdr_rec.asset_id||':'||p_asset_fin_rec.group_asset_id,p_log_level_rec);
852: end if;
853:
854: -- +++++ populate current period_rec info +++++
855: if not FA_UTIL_PVT.get_period_rec
856: (p_book => p_asset_hdr_rec.book_type_code,
857: x_period_rec => l_period_rec,
858: p_log_level_rec => p_log_level_rec) then
859:

Line 861: fa_debug_pkg.add(l_calling_fn, 'Calling FA_UTIL_PVT.get_period_rec', 'Failed',p_log_level_rec);

857: x_period_rec => l_period_rec,
858: p_log_level_rec => p_log_level_rec) then
859:
860: if (p_log_level_rec.statement_level) then
861: fa_debug_pkg.add(l_calling_fn, 'Calling FA_UTIL_PVT.get_period_rec', 'Failed',p_log_level_rec);
862: end if;
863:
864: raise rein_err;
865: end if;

Line 869: if not FA_UTIL_PVT.get_asset_desc_rec (

865: end if;
866:
867: -- Get asset description for member asset
868: -- p_asset_desc may be null
869: if not FA_UTIL_PVT.get_asset_desc_rec (
870: p_asset_hdr_rec => p_asset_hdr_rec,
871: px_asset_desc_rec => l_asset_desc_rec_m,
872: p_log_level_rec => p_log_level_rec) then
873:

Line 875: fa_debug_pkg.add(l_calling_fn, 'Calling FA_UTIL_PVT.get_asset_desc_rec', 'Failed',p_log_level_rec);

871: px_asset_desc_rec => l_asset_desc_rec_m,
872: p_log_level_rec => p_log_level_rec) then
873:
874: if (p_log_level_rec.statement_level) then
875: fa_debug_pkg.add(l_calling_fn, 'Calling FA_UTIL_PVT.get_asset_desc_rec', 'Failed',p_log_level_rec);
876: end if;
877:
878: raise rein_err;
879: end if;

Line 1061: if not fa_util_pvt.get_asset_deprn_rec (

1057: l_asset_hdr_rec.book_type_code := p_asset_hdr_rec.book_type_code;
1058: l_asset_hdr_rec.set_of_books_id := p_asset_hdr_rec.set_of_books_id;
1059: --l_asset_hdr_rec.period_of_addition := 'N'; -- Guess not necessary
1060:
1061: if not fa_util_pvt.get_asset_deprn_rec (
1062: p_asset_hdr_rec => l_asset_hdr_rec,
1063: px_asset_deprn_rec => l_asset_deprn_rec_old,
1064: p_mrc_sob_type_code => p_mrc_sob_type_code,
1065: p_log_level_rec => p_log_level_rec) then

Line 1069: if not FA_UTIL_PVT.get_asset_type_rec

1065: p_log_level_rec => p_log_level_rec) then
1066: raise rein_err;
1067: end if;
1068:
1069: if not FA_UTIL_PVT.get_asset_type_rec
1070: (p_asset_hdr_rec => l_asset_hdr_rec,
1071: px_asset_type_rec => l_asset_type_rec,
1072: p_log_level_rec => p_log_level_rec) then
1073: raise rein_err;

Line 1076: if not FA_UTIL_PVT.get_asset_desc_rec

1072: p_log_level_rec => p_log_level_rec) then
1073: raise rein_err;
1074: end if;
1075:
1076: if not FA_UTIL_PVT.get_asset_desc_rec
1077: (p_asset_hdr_rec => l_asset_hdr_rec,
1078: px_asset_desc_rec => l_asset_desc_rec,
1079: p_log_level_rec => p_log_level_rec) then
1080: raise rein_err;

Line 1083: if not FA_UTIL_PVT.get_asset_cat_rec

1079: p_log_level_rec => p_log_level_rec) then
1080: raise rein_err;
1081: end if;
1082:
1083: if not FA_UTIL_PVT.get_asset_cat_rec
1084: (p_asset_hdr_rec => l_asset_hdr_rec,
1085: px_asset_cat_rec => l_asset_cat_rec,
1086: p_date_effective => null,
1087: p_log_level_rec => p_log_level_rec) then

Line 1091: if not fa_util_pvt.get_asset_fin_rec (

1087: p_log_level_rec => p_log_level_rec) then
1088: raise rein_err;
1089: end if;
1090:
1091: if not fa_util_pvt.get_asset_fin_rec (
1092: p_asset_hdr_rec => l_asset_hdr_rec,
1093: px_asset_fin_rec => l_asset_fin_rec_old,
1094: p_mrc_sob_type_code => p_mrc_sob_type_code,
1095: p_log_level_rec => p_log_level_rec) then

Line 1111: if not fa_util_pvt.get_asset_deprn_rec (

1107: raise rein_err;
1108: end if; --End HH
1109:
1110: /*
1111: if not fa_util_pvt.get_asset_deprn_rec (
1112: p_asset_hdr_rec => l_asset_hdr_rec,
1113: px_asset_deprn_rec => l_asset_deprn_rec_old,
1114: p_mrc_sob_type_code => p_mrc_sob_type_code,
1115: p_log_level_rec => p_log_level_rec) then

Line 1124: if not fa_util_pvt.get_asset_fin_rec (

1120: l_asset_fin_rec_adj.cost := p_asset_retire_rec.cost_retired;
1121: l_asset_fin_rec_adj.unrevalued_cost := p_asset_retire_rec.cost_retired;
1122:
1123: -- Get new member's fin_rec
1124: if not fa_util_pvt.get_asset_fin_rec (
1125: p_asset_hdr_rec => p_asset_hdr_rec,
1126: px_asset_fin_rec => l_asset_fin_rec_new_m,
1127: p_mrc_sob_type_code => p_mrc_sob_type_code,
1128: p_log_level_rec => p_log_level_rec) then

Line 1675: if not fa_util_pvt.get_asset_deprn_rec ( -- ENERGY

1671: -- handle all allocate cases the same way rather than just energy:
1672: -- (l_group_db_rule_name = 'ENERGY PERIOD END BALANCE')
1673: if (nvl(p_asset_fin_rec.tracking_method, 'NON TRACK') = 'ALLOCATE') then -- ENERGY
1674: -- ENERGY
1675: if not fa_util_pvt.get_asset_deprn_rec ( -- ENERGY
1676: p_asset_hdr_rec => p_asset_hdr_rec, -- ENERGY
1677: px_asset_deprn_rec => l_asset_deprn_rec, -- ENERGY
1678: p_mrc_sob_type_code => p_mrc_sob_type_code,
1679: p_log_level_rec => p_log_level_rec) then -- ENERGY

Line 1827: if not FA_UTIL_PVT.get_asset_cat_rec (

1823: l_asset_hdr_rec.book_type_code := p_asset_hdr_rec.book_type_code;
1824: l_asset_hdr_rec.set_of_books_id := p_asset_hdr_rec.set_of_books_id;
1825: -- l_asset_hdr_rec.period_of_addition := 'N'; -- Set this if necessary
1826:
1827: if not FA_UTIL_PVT.get_asset_cat_rec (
1828: p_asset_hdr_rec => l_asset_hdr_rec,
1829: px_asset_cat_rec => l_asset_cat_rec,
1830: p_date_effective => NULL,
1831: p_log_level_rec => p_log_level_rec) then

Line 2010: if not fa_util_pvt.get_asset_deprn_rec (

2006: p_trans_rec.transaction_date_entered) then
2007:
2008: l_trans_rec := p_trans_rec;
2009:
2010: if not fa_util_pvt.get_asset_deprn_rec (
2011: p_asset_hdr_rec => p_asset_hdr_rec,
2012: px_asset_deprn_rec => l_asset_deprn_rec,
2013: p_mrc_sob_type_code => p_mrc_sob_type_code,
2014: p_log_level_rec => p_log_level_rec) then

Line 2470: if not FA_UTIL_PVT.get_asset_cat_rec (

2466: l_asset_hdr_rec.book_type_code := p_asset_hdr_rec.book_type_code;
2467: l_asset_hdr_rec.set_of_books_id := p_asset_hdr_rec.set_of_books_id;
2468: -- l_asset_hdr_rec.period_of_addition := 'N'; -- Set this if necessary
2469:
2470: if not FA_UTIL_PVT.get_asset_cat_rec (
2471: p_asset_hdr_rec => l_asset_hdr_rec,
2472: px_asset_cat_rec => l_asset_cat_rec,
2473: p_date_effective => NULL,
2474: p_log_level_rec => p_log_level_rec) then

Line 2516: if not FA_UTIL_PVT.get_period_rec(

2512: OPEN c_get_group_thid;
2513: FETCH c_get_group_thid INTO l_group_thid, l_group_asset_id, l_date_effective;
2514: CLOSE c_get_group_thid;
2515:
2516: if not FA_UTIL_PVT.get_period_rec(
2517: p_book => l_asset_hdr_rec.book_type_code,
2518: p_effective_date => l_date_effective,
2519: x_period_rec => l_period_rec,
2520: p_log_level_rec => p_log_level_rec) then

Line 2672: if not fa_util_pvt.get_asset_deprn_rec (

2668: end if;
2669:
2670: l_trans_rec := p_trans_rec;
2671:
2672: if not fa_util_pvt.get_asset_deprn_rec (
2673: p_asset_hdr_rec => p_asset_hdr_rec,
2674: px_asset_deprn_rec => l_asset_deprn_rec,
2675: p_mrc_sob_type_code => p_mrc_sob_type_code,
2676: p_log_level_rec => p_log_level_rec) then

Line 2991: if not FA_UTIL_PVT.get_asset_type_rec (

2987: l_asset_hdr_rec.asset_id := p_bk.group_asset_id;
2988: l_asset_hdr_rec.book_type_code := p_ret.book;
2989: l_asset_hdr_rec.set_of_books_id := fa_cache_pkg.fazcbc_record.set_of_books_id;
2990:
2991: if not FA_UTIL_PVT.get_asset_type_rec (
2992: p_asset_hdr_rec => l_asset_hdr_rec,
2993: px_asset_type_rec => l_asset_type_rec,
2994: p_log_level_rec => p_log_level_rec) then
2995: raise calc_err;

Line 2998: if not FA_UTIL_PVT.get_asset_desc_rec (

2994: p_log_level_rec => p_log_level_rec) then
2995: raise calc_err;
2996: end if;
2997:
2998: if not FA_UTIL_PVT.get_asset_desc_rec (
2999: p_asset_hdr_rec => l_asset_hdr_rec,
3000: px_asset_desc_rec => l_asset_desc_rec,
3001: p_log_level_rec => p_log_level_rec) then
3002: raise calc_err;

Line 3005: if not FA_UTIL_PVT.get_asset_cat_rec (

3001: p_log_level_rec => p_log_level_rec) then
3002: raise calc_err;
3003: end if;
3004:
3005: if not FA_UTIL_PVT.get_asset_cat_rec (
3006: p_asset_hdr_rec => l_asset_hdr_rec,
3007: px_asset_cat_rec => l_asset_cat_rec,
3008: p_date_effective => null,
3009: p_log_level_rec => p_log_level_rec) then

Line 3013: if not fa_util_pvt.get_asset_fin_rec (

3009: p_log_level_rec => p_log_level_rec) then
3010: raise calc_err;
3011: end if;
3012:
3013: if not fa_util_pvt.get_asset_fin_rec (
3014: p_asset_hdr_rec => l_asset_hdr_rec,
3015: px_asset_fin_rec => l_asset_fin_rec_old,
3016: p_mrc_sob_type_code => p_mrc_sob_type_code,
3017: p_log_level_rec => p_log_level_rec) then

Line 3021: if not FA_UTIL_PVT.get_period_rec(

3017: p_log_level_rec => p_log_level_rec) then
3018: raise calc_err;
3019: end if;
3020:
3021: if not FA_UTIL_PVT.get_period_rec(
3022: p_book => l_asset_hdr_rec.book_type_code,
3023: x_period_rec => l_period_rec,
3024: p_log_level_rec => p_log_level_rec) then
3025: raise calc_err;

Line 3059: if not fa_util_pvt.get_asset_fin_rec (

3055: l_asset_hdr_rec_m.book_type_code := p_ret.book;
3056: l_asset_hdr_rec_m.set_of_books_id := fa_cache_pkg.fazcbc_record.set_of_books_id;
3057:
3058: -- Get new member's fin_rec
3059: if not fa_util_pvt.get_asset_fin_rec (
3060: p_asset_hdr_rec => l_asset_hdr_rec_m,
3061: px_asset_fin_rec => l_asset_fin_rec_new_m,
3062: p_mrc_sob_type_code => p_mrc_sob_type_code,
3063: p_log_level_rec => p_log_level_rec) then

Line 3515: if not FA_UTIL_PVT.get_asset_type_rec (

3511: l_asset_hdr_rec.asset_id := p_bk.group_asset_id;
3512: l_asset_hdr_rec.book_type_code := p_ret.book;
3513: l_asset_hdr_rec.set_of_books_id := fa_cache_pkg.fazcbc_record.set_of_books_id;
3514:
3515: if not FA_UTIL_PVT.get_asset_type_rec (
3516: p_asset_hdr_rec => l_asset_hdr_rec,
3517: px_asset_type_rec => l_asset_type_rec,
3518: p_log_level_rec => p_log_level_rec) then
3519: raise calc_err;

Line 3522: if not FA_UTIL_PVT.get_asset_desc_rec (

3518: p_log_level_rec => p_log_level_rec) then
3519: raise calc_err;
3520: end if;
3521:
3522: if not FA_UTIL_PVT.get_asset_desc_rec (
3523: p_asset_hdr_rec => l_asset_hdr_rec,
3524: px_asset_desc_rec => l_asset_desc_rec,
3525: p_log_level_rec => p_log_level_rec) then
3526: raise calc_err;

Line 3529: if not FA_UTIL_PVT.get_asset_cat_rec (

3525: p_log_level_rec => p_log_level_rec) then
3526: raise calc_err;
3527: end if;
3528:
3529: if not FA_UTIL_PVT.get_asset_cat_rec (
3530: p_asset_hdr_rec => l_asset_hdr_rec,
3531: px_asset_cat_rec => l_asset_cat_rec,
3532: p_date_effective => null,
3533: p_log_level_rec => p_log_level_rec) then

Line 3537: if not fa_util_pvt.get_asset_fin_rec (

3533: p_log_level_rec => p_log_level_rec) then
3534: raise calc_err;
3535: end if;
3536:
3537: if not fa_util_pvt.get_asset_fin_rec (
3538: p_asset_hdr_rec => l_asset_hdr_rec,
3539: px_asset_fin_rec => l_asset_fin_rec_old,
3540: p_mrc_sob_type_code => p_mrc_sob_type_code,
3541: p_log_level_rec => p_log_level_rec) then

Line 3545: if not FA_UTIL_PVT.get_period_rec(

3541: p_log_level_rec => p_log_level_rec) then
3542: raise calc_err;
3543: end if;
3544:
3545: if not FA_UTIL_PVT.get_period_rec(
3546: p_book => l_asset_hdr_rec.book_type_code,
3547: x_period_rec => l_period_rec,
3548: p_log_level_rec => p_log_level_rec) then
3549: raise calc_err;

Line 3554: if not fa_util_pvt.get_asset_deprn_rec (

3550: end if;
3551:
3552: --tk_util.DumpFinRec(l_asset_fin_rec_old, 'OLD');
3553:
3554: if not fa_util_pvt.get_asset_deprn_rec (
3555: p_asset_hdr_rec => l_asset_hdr_rec,
3556: px_asset_deprn_rec => l_asset_deprn_rec_old,
3557: p_mrc_sob_type_code => p_mrc_sob_type_code,
3558: p_log_level_rec => p_log_level_rec) then

Line 3580: if not fa_util_pvt.get_asset_fin_rec (

3576: l_asset_hdr_rec_m.book_type_code := p_ret.book;
3577: l_asset_hdr_rec_m.set_of_books_id := fa_cache_pkg.fazcbc_record.set_of_books_id;
3578:
3579: -- Get new member's fin_rec
3580: if not fa_util_pvt.get_asset_fin_rec (
3581: p_asset_hdr_rec => l_asset_hdr_rec_m,
3582: px_asset_fin_rec => l_asset_fin_rec_new_m,
3583: p_mrc_sob_type_code => p_mrc_sob_type_code,
3584: p_log_level_rec => p_log_level_rec) then

Line 3983: if not FA_UTIL_PVT.get_period_rec(

3979: fa_debug_pkg.add(l_calling_fn, 'Begin', p_book_type_code,p_log_level_rec);
3980: end if;
3981:
3982: --+++++ Get Current Period Info +++++
3983: if not FA_UTIL_PVT.get_period_rec(
3984: p_book => p_book_type_code,
3985: x_period_rec => l_period_rec,
3986: p_log_level_rec => p_log_level_rec) then
3987: raise gl_err;