APPS.OKL_VP_CHANGE_REQUEST_PVT dependencies on OKL_VCR_PVT

Line 209: okl_vcr_pvt.insert_row(p_api_version => p_api_version

205: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
206: RAISE OKL_API.G_EXCEPTION_ERROR;
207: END IF;
208:
209: okl_vcr_pvt.insert_row(p_api_version => p_api_version
210: ,p_init_msg_list => p_init_msg_list
211: ,x_return_status => x_return_status
212: ,x_msg_count => x_msg_count
213: ,x_msg_data => x_msg_data

Line 221: 'okl_vcr_pvt.insert_row returned with status '||x_return_status||' x_msg_data '||x_msg_data||' id '||x_vcrv_rec.id

217: -- write to log
218: IF(NVL(l_debug_enabled,'N')='Y') THEN
219: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
220: l_module,
221: 'okl_vcr_pvt.insert_row returned with status '||x_return_status||' x_msg_data '||x_msg_data||' id '||x_vcrv_rec.id
222: );
223: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
224: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
225: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 280: lv_vcrv_rec okl_vcr_pvt.vcrv_rec_type;

276: FROM okl_vp_change_requests
277: WHERE id = cp_change_request_id;
278: lv_chr_id okc_k_headers_b.id%TYPE;
279:
280: lv_vcrv_rec okl_vcr_pvt.vcrv_rec_type;
281:
282: l_api_version CONSTANT NUMBER DEFAULT 1.0;
283: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'UPDATE_CHANGE_REQUEST_HDR';
284: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_VP_CHANGE_REQUEST_PVT.UPDATE_CHANGE_REQUEST_HEADER';

Line 319: okl_vcr_pvt.update_row(p_api_version => p_api_version

315: OPEN c_get_chr_id(lv_vcrv_rec.id); FETCH c_get_chr_id INTO lv_chr_id;
316: CLOSE c_get_chr_id;
317: lv_vcrv_rec.chr_id := lv_chr_id;
318: END IF;
319: okl_vcr_pvt.update_row(p_api_version => p_api_version
320: ,p_init_msg_list => p_init_msg_list
321: ,x_return_status => x_return_status
322: ,x_msg_count => x_msg_count
323: ,x_msg_data => x_msg_data

Line 331: 'okl_vcr_pvt.update_row returned with status '||x_return_status||' x_msg_data '||x_msg_data||' id '||x_vcrv_rec.id

327: -- write to log
328: IF(NVL(l_debug_enabled,'N')='Y') THEN
329: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
330: l_module,
331: 'okl_vcr_pvt.update_row returned with status '||x_return_status||' x_msg_data '||x_msg_data||' id '||x_vcrv_rec.id
332: );
333: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
334:
335: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN