[Home] [Help]
131: raise pub_error;
132: end if;
133:
134:
135: l_err_stage:= 'FA_UTIL_PVT.get_asset_desc_rec';
136: if (g_log_level_rec.statement_level) then
137: fa_debug_pkg.add('Update_desc', 'before', l_err_stage, p_log_level_rec => g_log_level_rec);
138: end if;
139:
136: if (g_log_level_rec.statement_level) then
137: fa_debug_pkg.add('Update_desc', 'before', l_err_stage, p_log_level_rec => g_log_level_rec);
138: end if;
139:
140: if not FA_UTIL_PVT.get_asset_desc_rec(
141: p_asset_hdr_rec => px_asset_hdr_rec,
142: px_asset_desc_rec => l_asset_desc_rec , p_log_level_rec => g_log_level_rec) then
143: raise pub_error;
144: end if;
246: fa_debug_pkg.add('Update_desc', 'before', l_err_stage, p_log_level_rec => g_log_level_rec);
247: end if;
248:
249:
250: if not FA_UTIL_PVT.get_asset_cat_rec(
251: p_asset_hdr_rec => px_asset_hdr_rec,
252: px_asset_cat_rec => l_asset_cat_rec , p_log_level_rec => g_log_level_rec) then
253: raise pub_error;
254: end if;
479: --px_asset_desc_rec_new.warranty_id := NULL;
480: null;
481: else
482: -- We will need dpis to validate warranty. Same in primary/rep
483: if not FA_UTIL_PVT.get_asset_fin_rec(
484: p_asset_hdr_rec => px_asset_hdr_rec,
485: px_asset_fin_rec => l_asset_fin_rec,
486: p_mrc_sob_type_code => 'P' , p_log_level_rec => g_log_level_rec) then
487: raise pub_error;
1456:
1457: px_asset_hdr_rec.set_of_books_id :=
1458: fa_cache_pkg.fazcbc_record.set_of_books_id;
1459:
1460: if (NOT FA_UTIL_PVT.get_period_rec (
1461: p_book => px_asset_hdr_rec.book_type_code,
1462: p_effective_date => NULL,
1463: x_period_rec => l_period_rec
1464: , p_log_level_rec => g_log_level_rec)) then
1524:
1525: -- Retrieve old invoice record
1526: l_inv_rec.source_line_id := px_inv_tbl_new(i).source_line_id;
1527:
1528: if (NOT FA_UTIL_PVT.get_inv_rec (
1529: px_inv_rec => l_inv_rec,
1530: p_mrc_sob_type_code => l_reporting_flag,
1531: p_set_of_books_id => l_mrc_asset_hdr_rec.set_of_books_id,
1532: p_log_level_rec => g_log_level_rec)) then
2046: -- and asset_id if they are not supplied.
2047: if (px_asset_hdr_rec.book_type_code is null or
2048: px_asset_hdr_rec.asset_id is null) then
2049: l_asset_retire_rec.retirement_id := px_asset_retire_rec_new.retirement_id;
2050: if not FA_UTIL_PVT.get_asset_retire_rec
2051: (px_asset_retire_rec => l_asset_retire_rec,
2052: p_mrc_sob_type_code => 'P',
2053: p_set_of_books_id => null,
2054: p_log_level_rec => g_log_level_rec) then
2068:
2069: px_asset_hdr_rec.set_of_books_id :=
2070: fa_cache_pkg.fazcbc_record.set_of_books_id;
2071:
2072: if (NOT FA_UTIL_PVT.get_period_rec (
2073: p_book => px_asset_hdr_rec.book_type_code,
2074: p_effective_date => NULL,
2075: x_period_rec => l_period_rec
2076: , p_log_level_rec => g_log_level_rec)) then
2143: fa_debug_pkg.add('Retirement ID','l_asset_retire_rec.retirement_id',
2144: to_char(l_asset_retire_rec.retirement_id), g_log_level_rec);
2145: end if;
2146:
2147: if (NOT FA_UTIL_PVT.get_asset_retire_rec (
2148: px_asset_retire_rec => l_asset_retire_rec,
2149: p_mrc_sob_type_code => l_reporting_flag,
2150: p_set_of_books_id => l_mrc_asset_hdr_rec.set_of_books_id
2151: , p_log_level_rec => g_log_level_rec)) then