DBA Data[Home] [Help]

APPS.PA_ROLE_LIST_MEMBERS_PVT dependencies on FND_API

Line 31: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

27: P_LAST_UPDATE_DATE,
28: P_LAST_UPDATED_BY,
29: P_LAST_UPDATE_LOGIN);
30:
31: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
32: X_MSG_COUNT := 0;
33: X_MSG_DATA := NULL;
34: PA_DEBUG.reset_err_stack;
35:

Line 38: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

34: PA_DEBUG.reset_err_stack;
35:
36: exception
37: when others then
38: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
39: X_MSG_COUNT := 1;
40: X_MSG_DATA := substr(SQLERRM, 1, 240);
41: FND_MSG_PUB.add_exc_msg(
42: p_pkg_name => 'PA_ROLE_LIST_MEMBERS_PVT',

Line 63: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

59: PA_ROLE_LIST_MEMBERS_PKG.LOCK_ROW(
60: P_ROWID,
61: P_RECORD_VERSION_NUMBER);
62:
63: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
64: X_MSG_COUNT := 0;
65: X_MSG_DATA := NULL;
66: PA_DEBUG.reset_err_stack;
67:

Line 70: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

66: PA_DEBUG.reset_err_stack;
67:
68: exception
69: when others then
70: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
71: X_MSG_COUNT := 1;
72: X_MSG_DATA := substr(SQLERRM, 1, 240);
73: FND_MSG_PUB.add_exc_msg(
74: p_pkg_name => 'PA_ROLE_LIST_MEMBERS_PVT',

Line 107: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

103: P_LAST_UPDATE_DATE,
104: P_LAST_UPDATED_BY,
105: P_LAST_UPDATE_LOGIN);
106:
107: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
108: X_MSG_COUNT := 0;
109: X_MSG_DATA := NULL;
110: PA_DEBUG.reset_err_stack;
111:

Line 114: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

110: PA_DEBUG.reset_err_stack;
111:
112: exception
113: when others then
114: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
115: X_MSG_COUNT := 1;
116: X_MSG_DATA := substr(SQLERRM, 1, 240);
117: FND_MSG_PUB.add_exc_msg(
118: p_pkg_name => 'PA_ROLE_LIST_MEMBERS_PVT',

Line 137: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

133: --any validation to be added here ?
134: --call table handler to delete the row
135: PA_ROLE_LIST_MEMBERS_PKG.DELETE_ROW(P_ROWID);
136:
137: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
138: X_MSG_COUNT := 0;
139: X_MSG_DATA := NULL;
140: PA_DEBUG.reset_err_stack;
141:

Line 144: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

140: PA_DEBUG.reset_err_stack;
141:
142: exception
143: when others then
144: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
145: X_MSG_COUNT := 1;
146: X_MSG_DATA := substr(SQLERRM, 1, 240);
147: FND_MSG_PUB.add_exc_msg(
148: p_pkg_name => 'PA_ROLE_LIST_MEMBERS_PVT',