DBA Data[Home] [Help]

APPS.PA_PROJECT_CTX_SEARCH_PKG dependencies on FND_API

Line 36: x_return_status := FND_API.G_RET_STS_SUCCESS;

32: fnd_global.user_id,
33: sysdate,
34: fnd_global.login_id);
35:
36: x_return_status := FND_API.G_RET_STS_SUCCESS;
37:
38: EXCEPTION
39: WHEN OTHERS THEN
40: -- Set the exception Message and the stack

Line 43: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

39: WHEN OTHERS THEN
40: -- Set the exception Message and the stack
41: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_PROJECT_CTX_SEARCH_PKG',
42: p_procedure_name => 'INSERT_ROW' );
43: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
44: RAISE;
45: END INSERT_ROW;
46:
47: PROCEDURE UPDATE_ROW(p_project_id IN NUMBER,

Line 62: x_return_status := FND_API.G_RET_STS_SUCCESS;

58: LAST_UPDATED_BY = fnd_global.user_id,
59: LAST_UPDATE_LOGIN = fnd_global.login_id
60: WHERE project_id = p_project_id;
61:
62: x_return_status := FND_API.G_RET_STS_SUCCESS;
63:
64: EXCEPTION
65: WHEN OTHERS THEN
66: -- Set the exception Message and the stack

Line 69: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

65: WHEN OTHERS THEN
66: -- Set the exception Message and the stack
67: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_PROJECT_CTX_SEARCH_PKG',
68: p_procedure_name => 'UPDATE_ROW' );
69: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
70: RAISE;
71: END UPDATE_ROW;
72:
73: PROCEDURE DELETE_ROW(p_project_id IN NUMBER,

Line 82: x_return_status := FND_API.G_RET_STS_SUCCESS;

78:
79: DELETE FROM pa_project_ctx_search
80: WHERE project_id = p_project_id;
81:
82: x_return_status := FND_API.G_RET_STS_SUCCESS;
83:
84: EXCEPTION
85: WHEN OTHERS THEN
86: -- Set the exception Message and the stack

Line 89: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

85: WHEN OTHERS THEN
86: -- Set the exception Message and the stack
87: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_PROJECT_CTX_SEARCH_PKG',
88: p_procedure_name => 'DELETE_ROW' );
89: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
90: RAISE;
91: END DELETE_ROW;
92:
93: END PA_PROJECT_CTX_SEARCH_PKG;