DBA Data[Home] [Help]

APPS.IBY_UTILITY_PVT dependencies on FND_API

Line 130: x_return_status := FND_API.G_RET_STS_ERROR;

126: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(p_rollback_point);
127:
128: IF p_exception_type = iby_utility_pvt.g_expt_err
129: THEN
130: x_return_status := FND_API.G_RET_STS_ERROR;
131: l_error_reason := 'FND_API.G_RET_STS_ERROR';
132: ELSIF p_exception_type = iby_utility_pvt.g_expt_unexp_err
133: THEN
134: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 131: l_error_reason := 'FND_API.G_RET_STS_ERROR';

127:
128: IF p_exception_type = iby_utility_pvt.g_expt_err
129: THEN
130: x_return_status := FND_API.G_RET_STS_ERROR;
131: l_error_reason := 'FND_API.G_RET_STS_ERROR';
132: ELSIF p_exception_type = iby_utility_pvt.g_expt_unexp_err
133: THEN
134: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
135: l_error_reason := 'FND_API.G_RET_STS_UNEXP_ERROR';

Line 134: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

130: x_return_status := FND_API.G_RET_STS_ERROR;
131: l_error_reason := 'FND_API.G_RET_STS_ERROR';
132: ELSIF p_exception_type = iby_utility_pvt.g_expt_unexp_err
133: THEN
134: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
135: l_error_reason := 'FND_API.G_RET_STS_UNEXP_ERROR';
136: ELSIF p_exception_type = iby_utility_pvt.g_expt_otr_err
137: THEN
138: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 135: l_error_reason := 'FND_API.G_RET_STS_UNEXP_ERROR';

131: l_error_reason := 'FND_API.G_RET_STS_ERROR';
132: ELSIF p_exception_type = iby_utility_pvt.g_expt_unexp_err
133: THEN
134: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
135: l_error_reason := 'FND_API.G_RET_STS_UNEXP_ERROR';
136: ELSIF p_exception_type = iby_utility_pvt.g_expt_otr_err
137: THEN
138: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
139: l_error_reason := 'G_EXC_OTHERS';

Line 138: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

134: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
135: l_error_reason := 'FND_API.G_RET_STS_UNEXP_ERROR';
136: ELSIF p_exception_type = iby_utility_pvt.g_expt_otr_err
137: THEN
138: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
139: l_error_reason := 'G_EXC_OTHERS';
140:
141: l_ora_err_code := SQLCODE;
142: l_ora_err_msg := SQLERRM;

Line 306: p_init_msg_list VARCHAR2(2000) := FND_API.G_FALSE;

302: FUNCTION get_jtf_property(p_name IN VARCHAR2)
303: RETURN VARCHAR2 IS
304:
305: p_api_version_number NUMBER := 1.0;
306: p_init_msg_list VARCHAR2(2000) := FND_API.G_FALSE;
307: p_application_id NUMBER := 673;
308: p_profile_id NUMBER;
309: p_profile_name VARCHAR2(2000) := 'JTF_PROPERTY_MANAGER_DEFAULT_1';
310: p_perz_data_id NUMBER;

Line 346: x_return_status <> FND_API.G_RET_STS_SUCCESS) OR

342: x_msg_data
343: );
344:
345: IF ((x_return_status IS NULL OR
346: x_return_status <> FND_API.G_RET_STS_SUCCESS) OR
347: (x_data_attrib_tbl.count<1)) THEN
348: x_val := NULL;
349: ELSE
350: x_val := x_data_attrib_tbl(1).attribute_value;