[Home] [Help]
2415: --Bug# 6336455
2416: lp_artv_rec.LEGAL_ENTITY_ID := l_asset_return_rec.LEGAL_ENTITY_ID;
2417:
2418: -- call insert of tapi
2419: OKL_ASSET_RETURNS_PUB.insert_asset_returns(
2420: p_api_version => p_api_version,
2421: p_init_msg_list => OKL_API.G_FALSE,
2422: x_return_status => x_return_status,
2423: x_msg_count => x_msg_count,
2423: x_msg_count => x_msg_count,
2424: x_msg_data => x_msg_data,
2425: p_artv_rec => lp_artv_rec,
2426: x_artv_rec => lx_artv_rec);
2427: -- dbms_output.put_line('Calling OKL_ASSET_RETURNS_PUB.insert_asset_returns status >'||x_return_status);
2428: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2429: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2430: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2431: RAISE OKL_API.G_EXCEPTION_ERROR;
2458: -- this is parent asset so adjust the floor price
2459: lp_upd_artv_rec.id:=l_asset_return_rec.id;
2460: lp_upd_artv_rec.FLOOR_PRICE := NVL(l_asset_return_rec.FLOOR_PRICE,0.0)-l_chld_total_flr_price;
2461: -- call update of tapi
2462: OKL_ASSET_RETURNS_PUB.update_asset_returns(
2463: p_api_version => p_api_version,
2464: p_init_msg_list => OKL_API.G_FALSE,
2465: x_return_status => x_return_status,
2466: x_msg_count => x_msg_count,
2466: x_msg_count => x_msg_count,
2467: x_msg_data => x_msg_data,
2468: p_artv_rec => lp_upd_artv_rec,
2469: x_artv_rec => lx_artv_rec);
2470: -- dbms_output.put_line('Calling OKL_ASSET_RETURNS_PUB.update_asset_returns status >'||x_return_status);
2471: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2472: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2473: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2474: RAISE OKL_API.G_EXCEPTION_ERROR;