2278: g_token1 := null;
2279: raise FND_API.G_EXC_ERROR;
2280: end if;
2281:
2282: if g_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'do fa_transaction_headers_pkg.insert_row', '', p_log_level_rec); end if;
2283: fa_transaction_headers_pkg.insert_row
2284: (x_rowid => l_th_rowid,
2285: x_transaction_header_id => l_trans_rec.transaction_header_id,
2286: x_book_type_code => l_asset_hdr_rec.book_type_code,
2279: raise FND_API.G_EXC_ERROR;
2280: end if;
2281:
2282: if g_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'do fa_transaction_headers_pkg.insert_row', '', p_log_level_rec); end if;
2283: fa_transaction_headers_pkg.insert_row
2284: (x_rowid => l_th_rowid,
2285: x_transaction_header_id => l_trans_rec.transaction_header_id,
2286: x_book_type_code => l_asset_hdr_rec.book_type_code,
2287: x_asset_id => l_asset_hdr_rec.asset_id,
4000: ,p_log_level_rec => p_log_level_rec);
4001:
4002: end if; -- if corporate
4003:
4004: if g_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'FA_TRANSACTION_HEADERS_PKG.DELETE_ROW', '', p_log_level_rec); end if;
4005: FA_TRANSACTION_HEADERS_PKG.DELETE_ROW -- delete PARTIAL RETIREMENT row
4006: (X_Transaction_Header_Id =>
4007: l_asset_retire_rec.detail_info.transaction_header_id_in,
4008: X_Calling_Fn => l_calling_fn);
4001:
4002: end if; -- if corporate
4003:
4004: if g_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'FA_TRANSACTION_HEADERS_PKG.DELETE_ROW', '', p_log_level_rec); end if;
4005: FA_TRANSACTION_HEADERS_PKG.DELETE_ROW -- delete PARTIAL RETIREMENT row
4006: (X_Transaction_Header_Id =>
4007: l_asset_retire_rec.detail_info.transaction_header_id_in,
4008: X_Calling_Fn => l_calling_fn);
4009:
4006: (X_Transaction_Header_Id =>
4007: l_asset_retire_rec.detail_info.transaction_header_id_in,
4008: X_Calling_Fn => l_calling_fn);
4009:
4010: if g_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); end if;
4011: FA_TRANSACTION_HEADERS_PKG.DELETE_ROW -- delete TRANSFER OUT row
4012: (X_Transaction_Header_Id =>
4013: transfer_id,
4014: X_Calling_Fn => l_calling_fn);
4007: l_asset_retire_rec.detail_info.transaction_header_id_in,
4008: X_Calling_Fn => l_calling_fn);
4009:
4010: if g_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); end if;
4011: FA_TRANSACTION_HEADERS_PKG.DELETE_ROW -- delete TRANSFER OUT row
4012: (X_Transaction_Header_Id =>
4013: transfer_id,
4014: X_Calling_Fn => l_calling_fn);
4015:
4089: X_Calling_Fn => l_calling_fn
4090: ,p_log_level_rec => p_log_level_rec);
4091: end if; -- if corporate
4092:
4093: if g_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'FA_TRANSACTION_HEADERS_PKG.DELETE_ROW', '', p_log_level_rec); end if;
4094: FA_TRANSACTION_HEADERS_PKG.DELETE_ROW
4095: (X_Transaction_Header_Id =>
4096: l_asset_retire_rec.detail_info.transaction_header_id_in,
4097: X_Calling_Fn => l_calling_fn
4090: ,p_log_level_rec => p_log_level_rec);
4091: end if; -- if corporate
4092:
4093: if g_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'FA_TRANSACTION_HEADERS_PKG.DELETE_ROW', '', p_log_level_rec); end if;
4094: FA_TRANSACTION_HEADERS_PKG.DELETE_ROW
4095: (X_Transaction_Header_Id =>
4096: l_asset_retire_rec.detail_info.transaction_header_id_in,
4097: X_Calling_Fn => l_calling_fn
4098: ,p_log_level_rec => p_log_level_rec);
5332: p_log_level_rec => p_log_level_rec) then
5333: raise FND_API.G_EXC_UNEXPECTED_ERROR;
5334: end if;
5335:
5336: if g_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'do fa_transaction_headers_pkg.insert_row', '', p_log_level_rec); end if;
5337:
5338: fa_transaction_headers_pkg.insert_row
5339: (x_rowid => l_rowid,
5340: x_transaction_header_id => l_trans_rec.transaction_header_id,
5334: end if;
5335:
5336: if g_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'do fa_transaction_headers_pkg.insert_row', '', p_log_level_rec); end if;
5337:
5338: fa_transaction_headers_pkg.insert_row
5339: (x_rowid => l_rowid,
5340: x_transaction_header_id => l_trans_rec.transaction_header_id,
5341: x_book_type_code => l_asset_hdr_rec.book_type_code,
5342: x_asset_id => l_asset_hdr_rec.asset_id,
6182:
6183: if (p_mrc_sob_type_code <> 'R') then
6184: -- ? check this parameter again
6185: -- delete transaction_headers row only for primary book
6186: FA_TRANSACTION_HEADERS_PKG.DELETE_ROW
6187: (X_Transaction_Header_Id => l_asset_retire_rec.detail_info.transaction_header_id_out,
6188: X_Calling_Fn => l_calling_fn
6189: ,p_log_level_rec => p_log_level_rec);
6190:
7080: end if;
7081: raise FND_API.G_EXC_UNEXPECTED_ERROR;
7082: end if;
7083:
7084: FA_TRANSACTION_HEADERS_PKG.UPDATE_ROW(
7085: X_Rowid => p_rowid,
7086: X_Invoice_Transaction_Id => l_inv_trans_rec.invoice_transaction_id,
7087: X_Calling_Fn => l_calling_fn
7088: ,p_log_level_rec => p_log_level_rec);