DBA Data[Home] [Help]

APPS.PA_PROJ_OPP_ATTRS_PKG dependencies on FND_API

Line 25: x_return_status := FND_API.G_RET_STS_SUCCESS;

21: x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
22: IS
23:
24: BEGIN
25: x_return_status := FND_API.G_RET_STS_SUCCESS;
26:
27: INSERT INTO pa_project_opp_attrs
28: ( project_id ,
29: opportunity_value ,

Line 60: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

56: fnd_global.login_id );
57:
58: EXCEPTION
59: WHEN OTHERS THEN
60: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
61: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_PROJ_OPP_ATTRS_PKG',
62: p_procedure_name => 'insert_row');
63: raise;
64:

Line 81: x_return_status := FND_API.G_RET_STS_SUCCESS;

77: x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
78: IS
79:
80: BEGIN
81: x_return_status := FND_API.G_RET_STS_SUCCESS;
82:
83: DELETE FROM pa_project_opp_attrs
84: WHERE project_id = p_project_id;
85:

Line 88: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

84: WHERE project_id = p_project_id;
85:
86: EXCEPTION
87: WHEN OTHERS THEN
88: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
89: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_PROJ_OPP_ATTRS_PKG',
90: p_procedure_name => 'delete_row');
91: raise;
92:

Line 117: x_return_status := FND_API.G_RET_STS_SUCCESS;

113: x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
114: IS
115:
116: BEGIN
117: x_return_status := FND_API.G_RET_STS_SUCCESS;
118:
119: UPDATE pa_project_opp_attrs
120: SET
121: opportunity_value = p_opportunity_value,

Line 139: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

135: WHERE project_id = p_project_id;
136:
137: EXCEPTION
138: WHEN OTHERS THEN
139: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
140: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_PROJ_OPP_ATTRS_PKG',
141: p_procedure_name => 'update_row');
142: raise;
143: