APPS.PA_ROLE_LISTS_PVT dependencies on FND_API

Line 45: if X_RETURN_STATUS = FND_API.G_RET_STS_SUCCESS then

41: p_name,
42: X_RETURN_STATUS,
43: X_MSG_DATA);
44:
45: if X_RETURN_STATUS = FND_API.G_RET_STS_SUCCESS then
46: --call table handler to insert the row
47: PA_ROLE_LISTS_PKG.INSERT_ROW(
48: P_ROWID,
49: P_ROLE_LIST_ID,

Line 76: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

72: P_LAST_UPDATE_DATE,
73: P_LAST_UPDATED_BY,
74: P_LAST_UPDATE_LOGIN);
75:
76: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
77: X_MSG_COUNT := 0;
78: X_MSG_DATA := NULL;
79: PA_DEBUG.reset_err_stack;
80: else

Line 90: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

86: end if;
87:
88: exception
89: when others then
90: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
91: X_MSG_COUNT := 1;
92: X_MSG_DATA := substr(SQLERRM, 1, 240);
93: FND_MSG_PUB.add_exc_msg(
94: p_pkg_name => 'PA_ROLE_LISTS_PVT',

Line 115: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

111: PA_ROLE_LISTS_PKG.LOCK_ROW(
112: P_ROWID,
113: P_RECORD_VERSION_NUMBER);
114:
115: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
116: X_MSG_COUNT := 0;
117: X_MSG_DATA := NULL;
118: PA_DEBUG.reset_err_stack;
119:

Line 122: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

118: PA_DEBUG.reset_err_stack;
119:
120: exception
121: when others then
122: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
123: X_MSG_COUNT := 1;
124: X_MSG_DATA := substr(SQLERRM, 1, 240);
125: FND_MSG_PUB.add_exc_msg(
126: p_pkg_name => 'PA_ROLE_LISTS_PVT',

Line 173: x_return_status := FND_API.G_RET_STS_SUCCESS;

169: into v_name
170: from pa_role_lists
171: where rowid = p_rowid;
172:
173: x_return_status := FND_API.G_RET_STS_SUCCESS;
174:
175: if v_name <> p_name then
176: -- Check for duplicate row list names
177: PA_ROLE_UTILS.CHECK_DUP_ROLE_LIST_NAME(

Line 183: if X_RETURN_STATUS = FND_API.G_RET_STS_SUCCESS then

179: X_RETURN_STATUS,
180: X_MSG_DATA);
181: end if;
182:
183: if X_RETURN_STATUS = FND_API.G_RET_STS_SUCCESS then
184: --call table handler to update the row
185: PA_ROLE_LISTS_PKG.UPDATE_ROW(
186: P_ROWID,
187: P_ROLE_LIST_ID,

Line 214: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

210: P_LAST_UPDATE_DATE,
211: P_LAST_UPDATED_BY,
212: P_LAST_UPDATE_LOGIN);
213:
214: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
215: X_MSG_COUNT := 0;
216: X_MSG_DATA := NULL;
217: PA_DEBUG.reset_err_stack;
218: else

Line 228: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

224: end if;
225:
226: exception
227: when others then
228: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
229: X_MSG_COUNT := 1;
230: X_MSG_DATA := substr(SQLERRM, 1, 240);
231: FND_MSG_PUB.add_exc_msg(
232: p_pkg_name => 'PA_ROLE_LISTS_PVT',

Line 258: if X_RETURN_STATUS = FND_API.G_RET_STS_SUCCESS then

254: v_role_list_id,
255: X_RETURN_STATUS,
256: X_MSG_DATA);
257:
258: if X_RETURN_STATUS = FND_API.G_RET_STS_SUCCESS then
259: ----call the table handler to delete role list
260: PA_ROLE_LISTS_PKG.DELETE_ROW(P_ROWID);
261:
262: delete from PA_ROLE_LIST_MEMBERS

Line 279: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

275: end if;
276:
277: exception
278: when others then
279: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
280: X_MSG_COUNT := 1;
281: X_MSG_DATA := substr(SQLERRM, 1, 240);
282: FND_MSG_PUB.add_exc_msg(
283: p_pkg_name => 'PA_ROLE_LISTS_PVT',