DBA Data[Home] [Help]

APPS.PA_VALUE_MAPS_PKG dependencies on FND_API

Line 30: x_return_status := FND_API.G_RET_STS_SUCCESS;

26: IS
27:
28: BEGIN
29:
30: x_return_status := FND_API.G_RET_STS_SUCCESS;
31: FORALL j IN p_source_value_arr.FIRST .. p_source_value_arr.LAST
32: INSERT INTO pa_value_maps
33: ( value_map_id ,
34: value_map_def_id ,

Line 75: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

71: fnd_global.login_id );
72:
73: EXCEPTION
74: WHEN OTHERS THEN
75: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
76: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_VALUE_MAPS_PKG',
77: p_procedure_name => 'insert_rows');
78: raise;
79:

Line 98: x_return_status := FND_API.G_RET_STS_SUCCESS;

94: x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
95: IS
96:
97: BEGIN
98: x_return_status := FND_API.G_RET_STS_SUCCESS;
99:
100: IF p_value_map_def_type = 'PROBABILITY_OPP_PROJ' THEN
101: DELETE FROM pa_value_maps
102: WHERE value_map_def_id = p_value_map_def_id

Line 113: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

109: END IF;
110:
111: EXCEPTION
112: WHEN OTHERS THEN
113: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
114: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_VALUE_MAPS_PKG',
115: p_procedure_name => 'delete_rows');
116: raise;
117: