DBA Data[Home] [Help]

APPS.ENG_CHANGE_POLICY_PKG dependencies on FND_API

Line 61: IF NOT FND_API.Compatible_API_Call( l_api_version,

57: l_dynamic_sql VARCHAR2(32767);
58: l_api_name CONSTANT VARCHAR2(30) := 'GET_OPATTR_CHANGEPOLICY';
59: l_api_version CONSTANT NUMBER := 1.0;
60: BEGIN
61: IF NOT FND_API.Compatible_API_Call( l_api_version,
62: p_api_version,
63: l_api_name,
64: G_PKG_NAME)
65: THEN

Line 66: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

62: p_api_version,
63: l_api_name,
64: G_PKG_NAME)
65: THEN
66: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
67: END IF;
68:
69: l_dynamic_sql := q'!
70: select decode (max(restrict_id), 30, 'NOT_ALLOWED',

Line 99: x_return_status := FND_API.G_RET_STS_SUCCESS;

95:
96: EXECUTE IMMEDIATE l_dynamic_sql
97: INTO x_policy_value;
98:
99: x_return_status := FND_API.G_RET_STS_SUCCESS;
100:
101: EXCEPTION
102: WHEN no_data_found
103: THEN

Line 105: x_return_status := FND_API.G_RET_STS_SUCCESS;

101: EXCEPTION
102: WHEN no_data_found
103: THEN
104: x_policy_value := 'ALLOWED';
105: x_return_status := FND_API.G_RET_STS_SUCCESS;
106: WHEN OTHERS
107: THEN
108: x_policy_value := 'NOT_ALLOWED';
109: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 109: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

105: x_return_status := FND_API.G_RET_STS_SUCCESS;
106: WHEN OTHERS
107: THEN
108: x_policy_value := 'NOT_ALLOWED';
109: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
110:
111: END GET_OPATTR_CHANGEPOLICY;
112:
113: END ENG_CHANGE_POLICY_PKG ;