286: BEGIN
287: x_return_status := FND_API.G_RET_STS_SUCCESS;
288: x_error_message := NULL;
289:
290: cse_util_pkg.set_debug;
291:
292: debug('Inside API cse_proj_item_in_srv_pkg.interface_nl_to_pa');
293:
294: debug(' inventory_item_id : '||p_in_srv_pa_attr_rec.item_id);
320: l_location_type_code := p_in_srv_pa_attr_rec.location_type;
321:
322: IF p_in_srv_pa_attr_rec.location_type ='HZ_PARTY_SITES' THEN
323:
324: debug('Inside API cse_util_pkg.get_hz_location');
325:
326: cse_util_pkg.get_hz_location (
327: p_party_site_id => p_in_srv_pa_attr_rec.location_id,
328: x_hz_location_id => l_location_id,
322: IF p_in_srv_pa_attr_rec.location_type ='HZ_PARTY_SITES' THEN
323:
324: debug('Inside API cse_util_pkg.get_hz_location');
325:
326: cse_util_pkg.get_hz_location (
327: p_party_site_id => p_in_srv_pa_attr_rec.location_id,
328: x_hz_location_id => l_location_id,
329: x_Return_Status => l_return_status,
330: x_Error_Message => l_error_message );
602: RAISE fnd_api.g_exc_error;
603: END IF;
604:
605: --update transaction record with new txn_status_code = 'INTERFACE_TO_PA'
606: l_txn_rec := CSE_UTIL_PKG.init_txn_rec;
607: l_txn_rec.transaction_id := p_in_srv_pa_attr_rec.transaction_id;
608: l_txn_rec.source_group_ref_id := p_conc_request_id;
609: l_txn_rec.source_header_ref_id := p_in_srv_pa_attr_rec.project_id;
610: l_txn_rec.source_header_ref := l_project_number;
642: x_msg_count => l_msg_count,
643: x_msg_data => l_msg_data);
644:
645: IF NOT (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
646: l_error_message := cse_util_pkg.dump_error_stack ;
647: RAISE fnd_api.g_exc_error;
648: END IF;
649: END IF;
650: