52: p_instance_asset_id IN number)
53: RETURN number IS
54: CURSOR ma_txn_cur IS
55: SELECT transaction_id
56: FROM csi_transactions
57: WHERE transaction_type_id = 123
58: AND source_line_ref = 'MASS_ADD_ID'
59: AND source_line_ref_id = p_mass_addition_id
60: ORDER by source_transaction_date desc;
578: l_txn_error_rec.error_text := l_error_message;
579: l_txn_error_rec.error_stage := cse_datastructures_pub.g_fa_update;
580: l_txn_error_rec.message_string := l_xml_string;
581:
582: debug('calling csi_transactions_pvt.create_txn_error to create unit adjustment entry');
583:
584: csi_transactions_pvt.create_txn_error(
585: p_api_version => 1.0,
586: p_init_msg_list => fnd_api.g_true,
580: l_txn_error_rec.message_string := l_xml_string;
581:
582: debug('calling csi_transactions_pvt.create_txn_error to create unit adjustment entry');
583:
584: csi_transactions_pvt.create_txn_error(
585: p_api_version => 1.0,
586: p_init_msg_list => fnd_api.g_true,
587: p_commit => fnd_api.g_false,
588: p_validation_level => fnd_api.g_valid_level_full,