[Home] [Help]
2443: --Bug# 6336455
2444: lp_artv_rec.LEGAL_ENTITY_ID := l_asset_return_rec.LEGAL_ENTITY_ID;
2445:
2446: -- call insert of tapi
2447: OKL_ASSET_RETURNS_PUB.insert_asset_returns(
2448: p_api_version => p_api_version,
2449: p_init_msg_list => OKL_API.G_FALSE,
2450: x_return_status => x_return_status,
2451: x_msg_count => x_msg_count,
2451: x_msg_count => x_msg_count,
2452: x_msg_data => x_msg_data,
2453: p_artv_rec => lp_artv_rec,
2454: x_artv_rec => lx_artv_rec);
2455: -- dbms_output.put_line('Calling OKL_ASSET_RETURNS_PUB.insert_asset_returns status >'||x_return_status);
2456: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2457: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2458: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2459: RAISE OKL_API.G_EXCEPTION_ERROR;
2486: -- this is parent asset so adjust the floor price
2487: lp_upd_artv_rec.id:=l_asset_return_rec.id;
2488: lp_upd_artv_rec.FLOOR_PRICE := NVL(l_asset_return_rec.FLOOR_PRICE,0.0)-l_chld_total_flr_price;
2489: -- call update of tapi
2490: OKL_ASSET_RETURNS_PUB.update_asset_returns(
2491: p_api_version => p_api_version,
2492: p_init_msg_list => OKL_API.G_FALSE,
2493: x_return_status => x_return_status,
2494: x_msg_count => x_msg_count,
2494: x_msg_count => x_msg_count,
2495: x_msg_data => x_msg_data,
2496: p_artv_rec => lp_upd_artv_rec,
2497: x_artv_rec => lx_artv_rec);
2498: -- dbms_output.put_line('Calling OKL_ASSET_RETURNS_PUB.update_asset_returns status >'||x_return_status);
2499: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2500: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2501: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2502: RAISE OKL_API.G_EXCEPTION_ERROR;