DBA Data[Home] [Help]

APPS.IBY_UTILITY_PVT dependencies on FND_API

Line 119: x_return_status := FND_API.G_RET_STS_ERROR;

115: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(p_rollback_point);
116:
117: IF p_exception_type = iby_utility_pvt.g_expt_err
118: THEN
119: x_return_status := FND_API.G_RET_STS_ERROR;
120: l_error_reason := 'FND_API.G_RET_STS_ERROR';
121: ELSIF p_exception_type = iby_utility_pvt.g_expt_unexp_err
122: THEN
123: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

116:
117: IF p_exception_type = iby_utility_pvt.g_expt_err
118: THEN
119: x_return_status := FND_API.G_RET_STS_ERROR;
120: l_error_reason := 'FND_API.G_RET_STS_ERROR';
121: ELSIF p_exception_type = iby_utility_pvt.g_expt_unexp_err
122: THEN
123: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
124: l_error_reason := 'FND_API.G_RET_STS_UNEXP_ERROR';

Line 123: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

119: x_return_status := FND_API.G_RET_STS_ERROR;
120: l_error_reason := 'FND_API.G_RET_STS_ERROR';
121: ELSIF p_exception_type = iby_utility_pvt.g_expt_unexp_err
122: THEN
123: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
124: l_error_reason := 'FND_API.G_RET_STS_UNEXP_ERROR';
125: ELSIF p_exception_type = iby_utility_pvt.g_expt_otr_err
126: THEN
127: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

120: l_error_reason := 'FND_API.G_RET_STS_ERROR';
121: ELSIF p_exception_type = iby_utility_pvt.g_expt_unexp_err
122: THEN
123: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
124: l_error_reason := 'FND_API.G_RET_STS_UNEXP_ERROR';
125: ELSIF p_exception_type = iby_utility_pvt.g_expt_otr_err
126: THEN
127: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
128: l_error_reason := 'G_EXC_OTHERS';

Line 127: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

123: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
124: l_error_reason := 'FND_API.G_RET_STS_UNEXP_ERROR';
125: ELSIF p_exception_type = iby_utility_pvt.g_expt_otr_err
126: THEN
127: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
128: l_error_reason := 'G_EXC_OTHERS';
129:
130: l_ora_err_code := SQLCODE;
131: l_ora_err_msg := SQLERRM;

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

291: FUNCTION get_jtf_property(p_name IN VARCHAR2)
292: RETURN VARCHAR2 IS
293:
294: p_api_version_number NUMBER := 1.0;
295: p_init_msg_list VARCHAR2(2000) := FND_API.G_FALSE;
296: p_application_id NUMBER := 673;
297: p_profile_id NUMBER;
298: p_profile_name VARCHAR2(2000) := 'JTF_PROPERTY_MANAGER_DEFAULT_1';
299: p_perz_data_id NUMBER;

Line 335: x_return_status <> FND_API.G_RET_STS_SUCCESS) OR

331: x_msg_data
332: );
333:
334: IF ((x_return_status IS NULL OR
335: x_return_status <> FND_API.G_RET_STS_SUCCESS) OR
336: (x_data_attrib_tbl.count<1)) THEN
337: x_val := NULL;
338: ELSE
339: x_val := x_data_attrib_tbl(1).attribute_value;