APPS.PO_REQIMP_VAL_PVT dependencies on FND_API

Line 24: * FND_API.G_RET_STS_UNEXP_ERROR if an unexpected error occurs

20: * PO_INTERFACE_ERRORS and any validation warnings to the concurrent
21: * program log.
22: * Returns:
23: * x_return_status -
24: * FND_API.G_RET_STS_UNEXP_ERROR if an unexpected error occurs
25: * FND_API.G_RET_STS_SUCCESS otherwise
26: */
27: PROCEDURE val_pjm_proj_references (
28: p_api_version IN NUMBER,

Line 25: * FND_API.G_RET_STS_SUCCESS otherwise

21: * program log.
22: * Returns:
23: * x_return_status -
24: * FND_API.G_RET_STS_UNEXP_ERROR if an unexpected error occurs
25: * FND_API.G_RET_STS_SUCCESS otherwise
26: */
27: PROCEDURE val_pjm_proj_references (
28: p_api_version IN NUMBER,
29: x_return_status OUT NOCOPY VARCHAR2,

Line 67: IF NOT FND_API.compatible_api_call(l_api_version,p_api_version,

63: l_val_proj_result VARCHAR(1);
64: l_val_proj_error_code VARCHAR2(80);
65:
66: BEGIN
67: IF NOT FND_API.compatible_api_call(l_api_version,p_api_version,
68: l_api_name, G_PKG_NAME ) THEN
69: RAISE FND_API.g_exc_unexpected_error;
70: END IF;
71: x_return_status := FND_API.g_ret_sts_success;

Line 69: RAISE FND_API.g_exc_unexpected_error;

65:
66: BEGIN
67: IF NOT FND_API.compatible_api_call(l_api_version,p_api_version,
68: l_api_name, G_PKG_NAME ) THEN
69: RAISE FND_API.g_exc_unexpected_error;
70: END IF;
71: x_return_status := FND_API.g_ret_sts_success;
72:
73: IF (p_interface_table_code =

Line 71: x_return_status := FND_API.g_ret_sts_success;

67: IF NOT FND_API.compatible_api_call(l_api_version,p_api_version,
68: l_api_name, G_PKG_NAME ) THEN
69: RAISE FND_API.g_exc_unexpected_error;
70: END IF;
71: x_return_status := FND_API.g_ret_sts_success;
72:
73: IF (p_interface_table_code =
74: PO_REQIMP_VAL_PVT.G_PO_REQUISITIONS_INTERFACE) THEN
75: l_interface_table_name := 'PO_REQUISITIONS_INTERFACE';

Line 136: RAISE FND_API.g_exc_unexpected_error;

132:
133: ELSE
134: FND_MSG_PUB.build_exc_msg(G_PKG_NAME,l_api_name,
135: 'Invalid value for p_interface_table_code: ' || p_interface_table_code);
136: RAISE FND_API.g_exc_unexpected_error;
137: END IF; -- p_interface_table_code
138:
139: -- Bulk collect the project information into PL/SQL tables,
140: -- l_bulk_limit records at a time, and perform validation.

Line 206: WHEN FND_API.g_exc_unexpected_error THEN

202: p_login_id,p_request_id,p_prog_application_id,
203: p_program_id,SYSDATE,l_interface_table_name);
204:
205: EXCEPTION
206: WHEN FND_API.g_exc_unexpected_error THEN
207: x_return_status := FND_API.g_ret_sts_unexp_error;
208: IF project_info_cv%ISOPEN THEN
209: CLOSE project_info_cv;
210: END IF;

Line 207: x_return_status := FND_API.g_ret_sts_unexp_error;

203: p_program_id,SYSDATE,l_interface_table_name);
204:
205: EXCEPTION
206: WHEN FND_API.g_exc_unexpected_error THEN
207: x_return_status := FND_API.g_ret_sts_unexp_error;
208: IF project_info_cv%ISOPEN THEN
209: CLOSE project_info_cv;
210: END IF;
211: WHEN OTHERS THEN

Line 212: x_return_status := FND_API.g_ret_sts_unexp_error;

208: IF project_info_cv%ISOPEN THEN
209: CLOSE project_info_cv;
210: END IF;
211: WHEN OTHERS THEN
212: x_return_status := FND_API.g_ret_sts_unexp_error;
213: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
214: FND_MSG_PUB.add_exc_msg(G_PKG_NAME,l_api_name);
215: END IF;
216: IF project_info_cv%ISOPEN THEN