2501: g_token1 := null;
2502: raise FND_API.G_EXC_ERROR;
2503: end if;
2504:
2505: if p_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'do fa_transaction_headers_pkg.insert_row', '', p_log_level_rec => p_log_level_rec); end if;
2506: fa_transaction_headers_pkg.insert_row
2507: (x_rowid => l_th_rowid,
2508: x_transaction_header_id => l_trans_rec.transaction_header_id,
2509: x_book_type_code => l_asset_hdr_rec.book_type_code,
2502: raise FND_API.G_EXC_ERROR;
2503: end if;
2504:
2505: if p_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'do fa_transaction_headers_pkg.insert_row', '', p_log_level_rec => p_log_level_rec); end if;
2506: fa_transaction_headers_pkg.insert_row
2507: (x_rowid => l_th_rowid,
2508: x_transaction_header_id => l_trans_rec.transaction_header_id,
2509: x_book_type_code => l_asset_hdr_rec.book_type_code,
2510: x_asset_id => l_asset_hdr_rec.asset_id,
4281: X_Calling_Fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
4282:
4283: end if; -- if corporate
4284:
4285: if p_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'FA_TRANSACTION_HEADERS_PKG.DELETE_ROW', '', p_log_level_rec => p_log_level_rec); end if;
4286: FA_TRANSACTION_HEADERS_PKG.DELETE_ROW -- delete PARTIAL RETIREMENT row
4287: (X_Transaction_Header_Id =>
4288: l_asset_retire_rec.detail_info.transaction_header_id_in,
4289: X_Calling_Fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
4282:
4283: end if; -- if corporate
4284:
4285: if p_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'FA_TRANSACTION_HEADERS_PKG.DELETE_ROW', '', p_log_level_rec => p_log_level_rec); end if;
4286: FA_TRANSACTION_HEADERS_PKG.DELETE_ROW -- delete PARTIAL RETIREMENT row
4287: (X_Transaction_Header_Id =>
4288: l_asset_retire_rec.detail_info.transaction_header_id_in,
4289: X_Calling_Fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
4290:
4287: (X_Transaction_Header_Id =>
4288: l_asset_retire_rec.detail_info.transaction_header_id_in,
4289: X_Calling_Fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
4290:
4291: if p_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'FA_TRANSACTION_HEADERS_PKG.DELETE_ROW -- delete TRANSFER OUT row', '', p_log_level_rec => p_log_level_rec); end if;
4292: FA_TRANSACTION_HEADERS_PKG.DELETE_ROW -- delete TRANSFER OUT row
4293: (X_Transaction_Header_Id =>
4294: transfer_id,
4295: X_Calling_Fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
4288: l_asset_retire_rec.detail_info.transaction_header_id_in,
4289: X_Calling_Fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
4290:
4291: if p_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'FA_TRANSACTION_HEADERS_PKG.DELETE_ROW -- delete TRANSFER OUT row', '', p_log_level_rec => p_log_level_rec); end if;
4292: FA_TRANSACTION_HEADERS_PKG.DELETE_ROW -- delete TRANSFER OUT row
4293: (X_Transaction_Header_Id =>
4294: transfer_id,
4295: X_Calling_Fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
4296:
4369: X_Book_Type_Code=> l_asset_hdr_rec.book_type_code,
4370: X_Calling_Fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
4371: end if; -- if corporate
4372:
4373: if p_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'FA_TRANSACTION_HEADERS_PKG.DELETE_ROW', '', p_log_level_rec => p_log_level_rec); end if;
4374: FA_TRANSACTION_HEADERS_PKG.DELETE_ROW
4375: (X_Transaction_Header_Id =>
4376: l_asset_retire_rec.detail_info.transaction_header_id_in,
4377: X_Calling_Fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
4370: X_Calling_Fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
4371: end if; -- if corporate
4372:
4373: if p_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'FA_TRANSACTION_HEADERS_PKG.DELETE_ROW', '', p_log_level_rec => p_log_level_rec); end if;
4374: FA_TRANSACTION_HEADERS_PKG.DELETE_ROW
4375: (X_Transaction_Header_Id =>
4376: l_asset_retire_rec.detail_info.transaction_header_id_in,
4377: X_Calling_Fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
4378:
5678: raise FND_API.G_EXC_UNEXPECTED_ERROR;
5679: end if;
5680: end if;
5681:
5682: if p_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'do fa_transaction_headers_pkg.insert_row', '', p_log_level_rec => p_log_level_rec); end if;
5683:
5684: fa_transaction_headers_pkg.insert_row
5685: (x_rowid => l_rowid,
5686: x_transaction_header_id => l_trans_rec.transaction_header_id,
5680: end if;
5681:
5682: if p_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'do fa_transaction_headers_pkg.insert_row', '', p_log_level_rec => p_log_level_rec); end if;
5683:
5684: fa_transaction_headers_pkg.insert_row
5685: (x_rowid => l_rowid,
5686: x_transaction_header_id => l_trans_rec.transaction_header_id,
5687: x_book_type_code => l_asset_hdr_rec.book_type_code,
5688: x_asset_id => l_asset_hdr_rec.asset_id,
6530:
6531: if (p_mrc_sob_type_code <> 'R') then
6532: -- ? check this parameter again
6533: -- delete transaction_headers row only for primary book
6534: FA_TRANSACTION_HEADERS_PKG.DELETE_ROW
6535: (X_Transaction_Header_Id => l_asset_retire_rec.detail_info.transaction_header_id_out,
6536: X_Calling_Fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
6537:
6538: end if; -- reporting_flag
7666: end if;
7667: raise FND_API.G_EXC_UNEXPECTED_ERROR;
7668: end if;
7669:
7670: FA_TRANSACTION_HEADERS_PKG.UPDATE_ROW(
7671: X_Rowid => p_rowid,
7672: X_Invoice_Transaction_Id => l_inv_trans_rec.invoice_transaction_id,
7673: X_Calling_Fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
7674: