13569: ,p_need_by_date => supp_to_tbl(l_rec_index).need_by_date
13570: ,x_return_status => l_return_status
13571: ,x_error_msg_code => l_error_msg_code );
13572:
13573: IF (l_return_status = PA_API.G_RET_STS_UNEXP_ERROR) THEN
13574: RAISE PA_API.G_EXCEPTION_UNEXPECTED_ERROR;
13575: ELSIF (l_return_status = PA_API.G_RET_STS_ERROR) THEN
13576: RAISE PA_API.G_EXCEPTION_ERROR;
13577: END IF;
13570: ,x_return_status => l_return_status
13571: ,x_error_msg_code => l_error_msg_code );
13572:
13573: IF (l_return_status = PA_API.G_RET_STS_UNEXP_ERROR) THEN
13574: RAISE PA_API.G_EXCEPTION_UNEXPECTED_ERROR;
13575: ELSIF (l_return_status = PA_API.G_RET_STS_ERROR) THEN
13576: RAISE PA_API.G_EXCEPTION_ERROR;
13577: END IF;
13578:
13571: ,x_error_msg_code => l_error_msg_code );
13572:
13573: IF (l_return_status = PA_API.G_RET_STS_UNEXP_ERROR) THEN
13574: RAISE PA_API.G_EXCEPTION_UNEXPECTED_ERROR;
13575: ELSIF (l_return_status = PA_API.G_RET_STS_ERROR) THEN
13576: RAISE PA_API.G_EXCEPTION_ERROR;
13577: END IF;
13578:
13579: end if; -- l_found
13572:
13573: IF (l_return_status = PA_API.G_RET_STS_UNEXP_ERROR) THEN
13574: RAISE PA_API.G_EXCEPTION_UNEXPECTED_ERROR;
13575: ELSIF (l_return_status = PA_API.G_RET_STS_ERROR) THEN
13576: RAISE PA_API.G_EXCEPTION_ERROR;
13577: END IF;
13578:
13579: end if; -- l_found
13580:
13695: u_change_description SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();
13696: --
13697: l_api_version number := 1;
13698: l_api_name CONSTANT VARCHAR2(60) := 'PA_FP_CI_MERGE.copy_direct_cost_data';
13699: l_return_status VARCHAR2(1) := PA_API.G_RET_STS_SUCCESS;
13700: l_msg_count number;
13701: l_msg_data varchar2(2000);
13702: l_dir_cost_flag VARCHAR2(1);
13703: l_debug_mode VARCHAR2(30);
13951: x_msg_data => l_msg_data,
13952: PPaCiDirectCostDetailsTbl => i_PaCiDirCostDetTbl,
13953: XPaCiDirectCostDetailsTbl => x_PaCiDirCostDetTbl);
13954:
13955: IF (l_return_status = PA_API.G_RET_STS_UNEXP_ERROR) THEN
13956: RAISE PA_API.G_EXCEPTION_UNEXPECTED_ERROR;
13957: ELSIF (l_return_status = PA_API.G_RET_STS_ERROR) THEN
13958: RAISE PA_API.G_EXCEPTION_ERROR;
13959: END IF;
13952: PPaCiDirectCostDetailsTbl => i_PaCiDirCostDetTbl,
13953: XPaCiDirectCostDetailsTbl => x_PaCiDirCostDetTbl);
13954:
13955: IF (l_return_status = PA_API.G_RET_STS_UNEXP_ERROR) THEN
13956: RAISE PA_API.G_EXCEPTION_UNEXPECTED_ERROR;
13957: ELSIF (l_return_status = PA_API.G_RET_STS_ERROR) THEN
13958: RAISE PA_API.G_EXCEPTION_ERROR;
13959: END IF;
13960:
13953: XPaCiDirectCostDetailsTbl => x_PaCiDirCostDetTbl);
13954:
13955: IF (l_return_status = PA_API.G_RET_STS_UNEXP_ERROR) THEN
13956: RAISE PA_API.G_EXCEPTION_UNEXPECTED_ERROR;
13957: ELSIF (l_return_status = PA_API.G_RET_STS_ERROR) THEN
13958: RAISE PA_API.G_EXCEPTION_ERROR;
13959: END IF;
13960:
13961: end if;
13954:
13955: IF (l_return_status = PA_API.G_RET_STS_UNEXP_ERROR) THEN
13956: RAISE PA_API.G_EXCEPTION_UNEXPECTED_ERROR;
13957: ELSIF (l_return_status = PA_API.G_RET_STS_ERROR) THEN
13958: RAISE PA_API.G_EXCEPTION_ERROR;
13959: END IF;
13960:
13961: end if;
13962:
13969: x_msg_data => l_msg_data,
13970: PPaCiDirectCostDetailsTbl => u_PaCiDirCostDetTbl,
13971: XPaCiDirectCostDetailsTbl => x_PaCiDirCostDetTbl);
13972:
13973: IF (l_return_status = PA_API.G_RET_STS_UNEXP_ERROR) THEN
13974: RAISE PA_API.G_EXCEPTION_UNEXPECTED_ERROR;
13975: ELSIF (l_return_status = PA_API.G_RET_STS_ERROR) THEN
13976: RAISE PA_API.G_EXCEPTION_ERROR;
13977: END IF;
13970: PPaCiDirectCostDetailsTbl => u_PaCiDirCostDetTbl,
13971: XPaCiDirectCostDetailsTbl => x_PaCiDirCostDetTbl);
13972:
13973: IF (l_return_status = PA_API.G_RET_STS_UNEXP_ERROR) THEN
13974: RAISE PA_API.G_EXCEPTION_UNEXPECTED_ERROR;
13975: ELSIF (l_return_status = PA_API.G_RET_STS_ERROR) THEN
13976: RAISE PA_API.G_EXCEPTION_ERROR;
13977: END IF;
13978: end if;
13971: XPaCiDirectCostDetailsTbl => x_PaCiDirCostDetTbl);
13972:
13973: IF (l_return_status = PA_API.G_RET_STS_UNEXP_ERROR) THEN
13974: RAISE PA_API.G_EXCEPTION_UNEXPECTED_ERROR;
13975: ELSIF (l_return_status = PA_API.G_RET_STS_ERROR) THEN
13976: RAISE PA_API.G_EXCEPTION_ERROR;
13977: END IF;
13978: end if;
13979:
13972:
13973: IF (l_return_status = PA_API.G_RET_STS_UNEXP_ERROR) THEN
13974: RAISE PA_API.G_EXCEPTION_UNEXPECTED_ERROR;
13975: ELSIF (l_return_status = PA_API.G_RET_STS_ERROR) THEN
13976: RAISE PA_API.G_EXCEPTION_ERROR;
13977: END IF;
13978: end if;
13979:
13980: -- bug 9840053: modified the update stmt.