DBA Data[Home] [Help]

APPS.PA_FP_CI_MERGE dependencies on PA_API

Line 13573: IF (l_return_status = PA_API.G_RET_STS_UNEXP_ERROR) THEN

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;

Line 13574: RAISE PA_API.G_EXCEPTION_UNEXPECTED_ERROR;

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:

Line 13575: ELSIF (l_return_status = PA_API.G_RET_STS_ERROR) THEN

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

Line 13576: RAISE PA_API.G_EXCEPTION_ERROR;

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:

Line 13699: l_return_status VARCHAR2(1) := PA_API.G_RET_STS_SUCCESS;

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);

Line 13955: IF (l_return_status = PA_API.G_RET_STS_UNEXP_ERROR) THEN

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;

Line 13956: RAISE PA_API.G_EXCEPTION_UNEXPECTED_ERROR;

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:

Line 13957: ELSIF (l_return_status = PA_API.G_RET_STS_ERROR) THEN

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;

Line 13958: RAISE PA_API.G_EXCEPTION_ERROR;

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:

Line 13973: IF (l_return_status = PA_API.G_RET_STS_UNEXP_ERROR) THEN

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;

Line 13974: RAISE PA_API.G_EXCEPTION_UNEXPECTED_ERROR;

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;

Line 13975: ELSIF (l_return_status = PA_API.G_RET_STS_ERROR) THEN

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:

Line 13976: RAISE PA_API.G_EXCEPTION_ERROR;

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.