[Home] [Help]
696:
697: BEGIN
698: x_return_status := FND_API.G_RET_STS_SUCCESS;
699: x_error_message := NULL;
700: cse_util_pkg.set_debug;
701:
702: debug('Inside API cse_deployment_grp.interface_nl_to_pa');
703:
704: debug(' inventory_item_id : '||p_trf_pa_attr_rec.item_id);
1072: END IF;
1073:
1074: --update transaction record with new txn_status_code = 'INTERFACE_TO_PA'
1075: /* --commented for bug 8670632 --
1076: l_txn_rec := CSE_UTIL_PKG.init_txn_rec;
1077: l_txn_rec.transaction_id := p_trf_pa_attr_rec.transaction_id;
1078: l_txn_rec.source_group_ref_id := p_conc_request_id;
1079: l_txn_rec.transaction_status_code := cse_datastructures_pub.G_INTERFACED_TO_PA;
1080: select object_version_number
1082: from csi_transactions
1083: where transaction_id = l_txn_rec.transaction_id;
1084: l_txn_rec.transaction_date := sysdate;
1085: l_txn_rec.source_transaction_date := sysdate;
1086: l_txn_rec.transaction_type_id:= 152; --cse_util_pkg.get_txn_type_id('PROJECT_TRANSFER', l_app_short_name);
1087:
1088: debug('Calling API csi_transactions_pvt.update_transactions');
1089: debug(' transaction_id : '||l_txn_rec.transaction_id);
1090:
1168: x_return_status := fnd_api.g_ret_sts_success ;
1169:
1170: savepoint process_transaction;
1171:
1172: cse_util_pkg.set_debug;
1173:
1174: csi_t_gen_utility_pvt.build_file_name(
1175: p_file_segment1 => 'cse',
1176: p_file_segment2 => to_char(sysdate, 'DDMONYYYY'));
1540:
1541: EXCEPTION
1542: WHEN fnd_api.g_exc_error THEN
1543: x_return_status := fnd_api.g_ret_sts_error;
1544: x_error_msg := nvl(l_error_msg, cse_util_pkg.dump_error_stack);
1545: debug('Error : '||x_error_msg);
1546: rollback to process_transaction;
1547: END process_transaction;
1548: