608: begin
609:
610: csi_t_gen_utility_pvt.dump_api_info(
611: p_api_name => 'insert_row',
612: p_pkg_name => 'csi_t_txn_line_details_pkg');
613:
614: csi_t_txn_line_details_pkg.insert_row(
615: px_txn_line_detail_id => l_txn_line_detail_id,
616: p_transaction_line_id => p_txn_line_dtl_rec.transaction_line_id,
610: csi_t_gen_utility_pvt.dump_api_info(
611: p_api_name => 'insert_row',
612: p_pkg_name => 'csi_t_txn_line_details_pkg');
613:
614: csi_t_txn_line_details_pkg.insert_row(
615: px_txn_line_detail_id => l_txn_line_detail_id,
616: p_transaction_line_id => p_txn_line_dtl_rec.transaction_line_id,
617: p_sub_type_id => p_txn_line_dtl_rec.sub_type_id,
618: p_instance_exists_flag => p_txn_line_dtl_rec.instance_exists_flag,
694: exception
695: when others then
696: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
697: fnd_message.set_token('MESSAGE',
698: 'csi_t_txn_line_details_pkg.insert_row Failed. '||substr(sqlerrm,1,200));
699: fnd_msg_pub.add;
700: raise fnd_api.g_exc_error;
701: end;
702:
2076: begin
2077:
2078: csi_t_gen_utility_pvt.dump_api_info(
2079: p_api_name => 'update_row',
2080: p_pkg_name => 'csi_t_txn_line_details_pkg');
2081:
2082: csi_t_txn_line_details_pkg.update_row(
2083: p_txn_line_detail_id => l_td_rec.txn_line_detail_id,
2084: p_transaction_line_id => l_td_rec.transaction_line_id,
2078: csi_t_gen_utility_pvt.dump_api_info(
2079: p_api_name => 'update_row',
2080: p_pkg_name => 'csi_t_txn_line_details_pkg');
2081:
2082: csi_t_txn_line_details_pkg.update_row(
2083: p_txn_line_detail_id => l_td_rec.txn_line_detail_id,
2084: p_transaction_line_id => l_td_rec.transaction_line_id,
2085: p_sub_type_id => l_td_rec.sub_type_id,
2086: p_instance_exists_flag => l_td_rec.instance_exists_flag,
2162: exception
2163: when others then
2164: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
2165: fnd_message.set_token('MESSAGE',
2166: 'csi_t_txn_line_details_pkg.update_row Failed. '||substr(sqlerrm,1,200));
2167: fnd_msg_pub.add;
2168: raise fnd_api.g_exc_error;
2169: end;
2170:
3414: FOR l_ind in p_txn_line_detail_ids_tbl.FIRST..
3415: p_txn_line_detail_ids_tbl.LAST
3416: LOOP
3417:
3418: csi_t_txn_line_details_pkg.delete_row(
3419: p_txn_line_detail_id => p_txn_line_detail_ids_tbl(l_ind).
3420: txn_line_detail_id);
3421:
3422: END LOOP;