eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_RS_ROLE_RELATE_PUB dependencies on FND_API

Line 26: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,

22: based on input values passed by calling routines. */
23:
24: PROCEDURE create_resource_role_relate
25: (P_API_VERSION IN NUMBER,
26: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
27: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
28: P_ROLE_RESOURCE_TYPE IN JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_TYPE%TYPE,
29: P_ROLE_RESOURCE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE,
30: P_ROLE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_ID%TYPE,

Line 27: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,

23:
24: PROCEDURE create_resource_role_relate
25: (P_API_VERSION IN NUMBER,
26: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
27: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
28: P_ROLE_RESOURCE_TYPE IN JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_TYPE%TYPE,
29: P_ROLE_RESOURCE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE,
30: P_ROLE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_ID%TYPE,
31: P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE,

Line 80: x_return_status := fnd_api.g_ret_sts_success;

76: BEGIN
77: --Standard Start of API SAVEPOINT
78: SAVEPOINT ROLE_RELATE_SP;
79:
80: x_return_status := fnd_api.g_ret_sts_success;
81:
82: --Standard Call to check API compatibility
83: IF NOT FND_API.Compatible_API_CALL(L_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
84: THEN

Line 83: IF NOT FND_API.Compatible_API_CALL(L_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)

79:
80: x_return_status := fnd_api.g_ret_sts_success;
81:
82: --Standard Call to check API compatibility
83: IF NOT FND_API.Compatible_API_CALL(L_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
84: THEN
85: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
86: END IF;
87:

Line 85: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

81:
82: --Standard Call to check API compatibility
83: IF NOT FND_API.Compatible_API_CALL(L_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
84: THEN
85: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
86: END IF;
87:
88: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
89: IF FND_API.To_boolean(P_INIT_MSG_LIST)

Line 89: IF FND_API.To_boolean(P_INIT_MSG_LIST)

85: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
86: END IF;
87:
88: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
89: IF FND_API.To_boolean(P_INIT_MSG_LIST)
90: THEN
91: FND_MSG_PUB.Initialize;
92: END IF;
93:

Line 110: RAISE fnd_api.g_exc_error;

106: IF l_role_resource_type = 'X'
107: THEN
108: fnd_message.set_name ('JTF', 'JTF_RS_INVALID_RL_RES_TYPE');
109: FND_MSG_PUB.add;
110: RAISE fnd_api.g_exc_error;
111: ELSE
112:
113: --call procedure to check whether id exists for the object
114: JTF_RESOURCE_UTL.CHECK_OBJECT_EXISTENCE(

Line 121: IF(l_return_status <> fnd_api.g_ret_sts_success)

117: P_OBJECT_USER_CODE => 'RESOURCE_ROLES',
118: X_FOUND => L_FOUND,
119: X_RETURN_STATUS => L_RETURN_STATUS
120: );
121: IF(l_return_status <> fnd_api.g_ret_sts_success)
122: THEN
123: IF L_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
124: RAISE FND_API.G_EXC_ERROR;
125: ELSIF L_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 123: IF L_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

119: X_RETURN_STATUS => L_RETURN_STATUS
120: );
121: IF(l_return_status <> fnd_api.g_ret_sts_success)
122: THEN
123: IF L_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
124: RAISE FND_API.G_EXC_ERROR;
125: ELSIF L_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
126: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
127: END IF;

Line 124: RAISE FND_API.G_EXC_ERROR;

120: );
121: IF(l_return_status <> fnd_api.g_ret_sts_success)
122: THEN
123: IF L_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
124: RAISE FND_API.G_EXC_ERROR;
125: ELSIF L_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
126: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
127: END IF;
128: ELSE

Line 125: ELSIF L_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

121: IF(l_return_status <> fnd_api.g_ret_sts_success)
122: THEN
123: IF L_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
124: RAISE FND_API.G_EXC_ERROR;
125: ELSIF L_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
126: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
127: END IF;
128: ELSE
129: IF NOT(l_found)

Line 126: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

122: THEN
123: IF L_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
124: RAISE FND_API.G_EXC_ERROR;
125: ELSIF L_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
126: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
127: END IF;
128: ELSE
129: IF NOT(l_found)
130: --if the id is not found then raise error

Line 134: RAISE fnd_api.g_exc_error;

130: --if the id is not found then raise error
131: THEN
132: fnd_message.set_name ('JTF', 'JTF_RS_INVALID_RR_RESOURCE');
133: FND_MSG_PUB.add;
134: RAISE fnd_api.g_exc_error;
135: END IF;
136: END IF;
137:
138: END IF;

Line 150: RAISE fnd_api.g_exc_error;

146: IF (role_cur%NOTFOUND)
147: THEN
148: fnd_message.set_name ('JTF', 'JTF_RS_INVALID_ROLE');
149: FND_MSG_PUB.add;
150: RAISE fnd_api.g_exc_error;
151: ELSE
152: l_role_id := role_rec.role_id;
153: END IF;
154: CLOSE role_cur;

Line 159: RAISE fnd_api.g_exc_error;

155: ELSE
156: --if both role id and role code is null then raise error
157: fnd_message.set_name ('JTF', 'JTF_RS_ROLE');
158: FND_MSG_PUB.add;
159: RAISE fnd_api.g_exc_error;
160:
161: END IF;
162:
163:

Line 202: IF L_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

198: X_ROLE_RELATE_ID := l_role_relate_id;
199:
200:
201:
202: IF L_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
203: RAISE FND_API.G_EXC_ERROR;
204: ELSIF L_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
205: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
206: END IF;

Line 203: RAISE FND_API.G_EXC_ERROR;

199:
200:
201:
202: IF L_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
203: RAISE FND_API.G_EXC_ERROR;
204: ELSIF L_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
205: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
206: END IF;
207:

Line 204: ELSIF L_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

200:
201:
202: IF L_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
203: RAISE FND_API.G_EXC_ERROR;
204: ELSIF L_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
205: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
206: END IF;
207:
208:

Line 205: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

201:
202: IF L_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
203: RAISE FND_API.G_EXC_ERROR;
204: ELSIF L_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
205: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
206: END IF;
207:
208:
209: IF fnd_api.to_boolean (p_commit)

Line 209: IF fnd_api.to_boolean (p_commit)

205: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
206: END IF;
207:
208:
209: IF fnd_api.to_boolean (p_commit)
210: THEN
211: COMMIT WORK;
212: END IF;
213:

Line 218: WHEN fnd_api.g_exc_error THEN

214:
215: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
216:
217: EXCEPTION
218: WHEN fnd_api.g_exc_error THEN
219: ROLLBACK TO ROLE_RELATE_SP;
220: x_return_status := fnd_api.g_ret_sts_error;
221: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
222: p_data => x_msg_data);

Line 220: x_return_status := fnd_api.g_ret_sts_error;

216:
217: EXCEPTION
218: WHEN fnd_api.g_exc_error THEN
219: ROLLBACK TO ROLE_RELATE_SP;
220: x_return_status := fnd_api.g_ret_sts_error;
221: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
222: p_data => x_msg_data);
223: WHEN fnd_api.g_exc_unexpected_error THEN
224: ROLLBACK TO ROLE_RELATE_SP;

Line 223: WHEN fnd_api.g_exc_unexpected_error THEN

219: ROLLBACK TO ROLE_RELATE_SP;
220: x_return_status := fnd_api.g_ret_sts_error;
221: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
222: p_data => x_msg_data);
223: WHEN fnd_api.g_exc_unexpected_error THEN
224: ROLLBACK TO ROLE_RELATE_SP;
225: x_return_status := fnd_api.g_ret_sts_unexp_error;
226: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
227: p_data => x_msg_data);

Line 225: x_return_status := fnd_api.g_ret_sts_unexp_error;

221: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
222: p_data => x_msg_data);
223: WHEN fnd_api.g_exc_unexpected_error THEN
224: ROLLBACK TO ROLE_RELATE_SP;
225: x_return_status := fnd_api.g_ret_sts_unexp_error;
226: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
227: p_data => x_msg_data);
228: WHEN OTHERS THEN
229: ROLLBACK TO ROLE_RELATE_SP;

Line 235: x_return_status := fnd_api.g_ret_sts_unexp_error;

231: fnd_message.set_token('P_SQLCODE',SQLCODE);
232: fnd_message.set_token('P_SQLERRM',SQLERRM);
233: fnd_message.set_token('P_API_NAME', l_api_name);
234: FND_MSG_PUB.add;
235: x_return_status := fnd_api.g_ret_sts_unexp_error;
236: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
237: p_data => x_msg_data);
238:
239: END create_resource_role_relate;

Line 248: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,

244: based on input values passed by calling routines. */
245:
246: PROCEDURE update_resource_role_relate
247: (P_API_VERSION IN NUMBER,
248: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
249: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
250: P_ROLE_RELATE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
251: P_START_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,
252: P_END_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE,

Line 249: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,

245:
246: PROCEDURE update_resource_role_relate
247: (P_API_VERSION IN NUMBER,
248: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
249: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
250: P_ROLE_RELATE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
251: P_START_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,
252: P_END_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE,
253: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,

Line 285: x_return_status := fnd_api.g_ret_sts_success;

281: BEGIN
282: --Standard Start of API SAVEPOINT
283: SAVEPOINT ROLE_RELATE_SP;
284:
285: x_return_status := fnd_api.g_ret_sts_success;
286:
287: --Standard Call to check API compatibility
288: IF NOT FND_API.Compatible_API_CALL(L_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
289: THEN

Line 288: IF NOT FND_API.Compatible_API_CALL(L_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)

284:
285: x_return_status := fnd_api.g_ret_sts_success;
286:
287: --Standard Call to check API compatibility
288: IF NOT FND_API.Compatible_API_CALL(L_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
289: THEN
290: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
291: END IF;
292:

Line 290: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

286:
287: --Standard Call to check API compatibility
288: IF NOT FND_API.Compatible_API_CALL(L_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
289: THEN
290: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
291: END IF;
292:
293: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
294: IF FND_API.To_boolean(P_INIT_MSG_LIST)

Line 294: IF FND_API.To_boolean(P_INIT_MSG_LIST)

290: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
291: END IF;
292:
293: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
294: IF FND_API.To_boolean(P_INIT_MSG_LIST)
295: THEN
296: FND_MSG_PUB.Initialize;
297: END IF;
298:

Line 324: IF (L_RETURN_STATUS = FND_API.G_RET_STS_SUCCESS)

320: X_MSG_COUNT := l_msg_count;
321: X_MSG_DATA := l_msg_data;
322:
323: --if success then update object version number
324: IF (L_RETURN_STATUS = FND_API.G_RET_STS_SUCCESS)
325: THEN
326: p_object_version_num := l_object_version_number;
327: ELSE
328: IF L_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

Line 328: IF L_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

324: IF (L_RETURN_STATUS = FND_API.G_RET_STS_SUCCESS)
325: THEN
326: p_object_version_num := l_object_version_number;
327: ELSE
328: IF L_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
329: RAISE FND_API.G_EXC_ERROR;
330: ELSIF L_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
331: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
332: END IF;

Line 329: RAISE FND_API.G_EXC_ERROR;

325: THEN
326: p_object_version_num := l_object_version_number;
327: ELSE
328: IF L_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
329: RAISE FND_API.G_EXC_ERROR;
330: ELSIF L_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
331: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
332: END IF;
333: END IF;

Line 330: ELSIF L_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

326: p_object_version_num := l_object_version_number;
327: ELSE
328: IF L_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
329: RAISE FND_API.G_EXC_ERROR;
330: ELSIF L_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
331: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
332: END IF;
333: END IF;
334: ELSE

Line 331: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

327: ELSE
328: IF L_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
329: RAISE FND_API.G_EXC_ERROR;
330: ELSIF L_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
331: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
332: END IF;
333: END IF;
334: ELSE
335: fnd_message.set_name ('JTF', 'JTF_RS_OBJECT_VER_ERR');

Line 337: RAISE fnd_api.g_exc_error;

333: END IF;
334: ELSE
335: fnd_message.set_name ('JTF', 'JTF_RS_OBJECT_VER_ERR');
336: FND_MSG_PUB.add;
337: RAISE fnd_api.g_exc_error;
338: END IF;
339: END IF;
340:
341:

Line 342: IF fnd_api.to_boolean (p_commit)

338: END IF;
339: END IF;
340:
341:
342: IF fnd_api.to_boolean (p_commit)
343: THEN
344: COMMIT WORK;
345: END IF;
346:

Line 351: WHEN fnd_api.g_exc_error THEN

347:
348: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
349:
350: EXCEPTION
351: WHEN fnd_api.g_exc_error THEN
352: ROLLBACK TO ROLE_RELATE_SP;
353: x_return_status := fnd_api.g_ret_sts_error;
354: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
355: p_data => x_msg_data);

Line 353: x_return_status := fnd_api.g_ret_sts_error;

349:
350: EXCEPTION
351: WHEN fnd_api.g_exc_error THEN
352: ROLLBACK TO ROLE_RELATE_SP;
353: x_return_status := fnd_api.g_ret_sts_error;
354: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
355: p_data => x_msg_data);
356: WHEN fnd_api.g_exc_unexpected_error THEN
357: ROLLBACK TO ROLE_RELATE_SP;

Line 356: WHEN fnd_api.g_exc_unexpected_error THEN

352: ROLLBACK TO ROLE_RELATE_SP;
353: x_return_status := fnd_api.g_ret_sts_error;
354: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
355: p_data => x_msg_data);
356: WHEN fnd_api.g_exc_unexpected_error THEN
357: ROLLBACK TO ROLE_RELATE_SP;
358: x_return_status := fnd_api.g_ret_sts_unexp_error;
359: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
360: p_data => x_msg_data);

Line 358: x_return_status := fnd_api.g_ret_sts_unexp_error;

354: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
355: p_data => x_msg_data);
356: WHEN fnd_api.g_exc_unexpected_error THEN
357: ROLLBACK TO ROLE_RELATE_SP;
358: x_return_status := fnd_api.g_ret_sts_unexp_error;
359: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
360: p_data => x_msg_data);
361: WHEN OTHERS THEN
362: ROLLBACK TO ROLE_RELATE_SP;

Line 368: x_return_status := fnd_api.g_ret_sts_unexp_error;

364: fnd_message.set_token('P_SQLCODE',SQLCODE);
365: fnd_message.set_token('P_SQLERRM',SQLERRM);
366: fnd_message.set_token('P_API_NAME', l_api_name);
367: FND_MSG_PUB.add;
368: x_return_status := fnd_api.g_ret_sts_unexp_error;
369: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
370: p_data => x_msg_data);
371:
372: END UPDATE_RESOURCE_ROLE_RELATE;

Line 380: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,

376: /* Procedure to delete the resource roles. */
377:
378: PROCEDURE delete_resource_role_relate
379: (P_API_VERSION IN NUMBER,
380: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
381: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
382: P_ROLE_RELATE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
383: P_OBJECT_VERSION_NUM IN JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
384: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 381: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,

377:
378: PROCEDURE delete_resource_role_relate
379: (P_API_VERSION IN NUMBER,
380: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
381: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
382: P_ROLE_RELATE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
383: P_OBJECT_VERSION_NUM IN JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
384: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
385: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 414: x_return_status := fnd_api.g_ret_sts_success;

410: BEGIN
411: --Standard Start of API SAVEPOINT
412: SAVEPOINT ROLE_RELATE_SP;
413:
414: x_return_status := fnd_api.g_ret_sts_success;
415:
416: --Standard Call to check API compatibility
417: IF NOT FND_API.Compatible_API_CALL(L_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
418: THEN

Line 417: IF NOT FND_API.Compatible_API_CALL(L_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)

413:
414: x_return_status := fnd_api.g_ret_sts_success;
415:
416: --Standard Call to check API compatibility
417: IF NOT FND_API.Compatible_API_CALL(L_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
418: THEN
419: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
420: END IF;
421:

Line 419: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

415:
416: --Standard Call to check API compatibility
417: IF NOT FND_API.Compatible_API_CALL(L_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
418: THEN
419: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
420: END IF;
421:
422: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
423: IF FND_API.To_boolean(P_INIT_MSG_LIST)

Line 423: IF FND_API.To_boolean(P_INIT_MSG_LIST)

419: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
420: END IF;
421:
422: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
423: IF FND_API.To_boolean(P_INIT_MSG_LIST)
424: THEN
425: FND_MSG_PUB.Initialize;
426: END IF;
427:

Line 451: IF (L_RETURN_STATUS <> fnd_api.g_ret_sts_success)

447: X_MSG_COUNT := l_msg_count;
448: X_MSG_DATA := l_msg_data;
449:
450: --if success then update object version number
451: IF (L_RETURN_STATUS <> fnd_api.g_ret_sts_success)
452: THEN
453: IF L_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
454: RAISE FND_API.G_EXC_ERROR;
455: ELSIF L_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 453: IF L_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

449:
450: --if success then update object version number
451: IF (L_RETURN_STATUS <> fnd_api.g_ret_sts_success)
452: THEN
453: IF L_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
454: RAISE FND_API.G_EXC_ERROR;
455: ELSIF L_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
456: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
457: END IF;

Line 454: RAISE FND_API.G_EXC_ERROR;

450: --if success then update object version number
451: IF (L_RETURN_STATUS <> fnd_api.g_ret_sts_success)
452: THEN
453: IF L_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
454: RAISE FND_API.G_EXC_ERROR;
455: ELSIF L_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
456: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
457: END IF;
458: END IF;

Line 455: ELSIF L_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

451: IF (L_RETURN_STATUS <> fnd_api.g_ret_sts_success)
452: THEN
453: IF L_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
454: RAISE FND_API.G_EXC_ERROR;
455: ELSIF L_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
456: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
457: END IF;
458: END IF;
459: ELSE

Line 456: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

452: THEN
453: IF L_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
454: RAISE FND_API.G_EXC_ERROR;
455: ELSIF L_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
456: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
457: END IF;
458: END IF;
459: ELSE
460: fnd_message.set_name ('JTF', 'JTF_RS_OBJECT_VER_ERR');

Line 462: RAISE fnd_api.g_exc_error;

458: END IF;
459: ELSE
460: fnd_message.set_name ('JTF', 'JTF_RS_OBJECT_VER_ERR');
461: FND_MSG_PUB.add;
462: RAISE fnd_api.g_exc_error;
463: END IF;
464: END IF;
465:
466:

Line 467: IF fnd_api.to_boolean (p_commit)

463: END IF;
464: END IF;
465:
466:
467: IF fnd_api.to_boolean (p_commit)
468: THEN
469: COMMIT WORK;
470: END IF;
471:

Line 476: WHEN fnd_api.g_exc_error THEN

472:
473: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
474:
475: EXCEPTION
476: WHEN fnd_api.g_exc_error THEN
477: ROLLBACK TO ROLE_RELATE_SP;
478: x_return_status := fnd_api.g_ret_sts_error;
479: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
480: p_data => x_msg_data);

Line 478: x_return_status := fnd_api.g_ret_sts_error;

474:
475: EXCEPTION
476: WHEN fnd_api.g_exc_error THEN
477: ROLLBACK TO ROLE_RELATE_SP;
478: x_return_status := fnd_api.g_ret_sts_error;
479: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
480: p_data => x_msg_data);
481: WHEN fnd_api.g_exc_unexpected_error THEN
482: ROLLBACK TO ROLE_RELATE_SP;

Line 481: WHEN fnd_api.g_exc_unexpected_error THEN

477: ROLLBACK TO ROLE_RELATE_SP;
478: x_return_status := fnd_api.g_ret_sts_error;
479: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
480: p_data => x_msg_data);
481: WHEN fnd_api.g_exc_unexpected_error THEN
482: ROLLBACK TO ROLE_RELATE_SP;
483: x_return_status := fnd_api.g_ret_sts_unexp_error;
484: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
485: p_data => x_msg_data);

Line 483: x_return_status := fnd_api.g_ret_sts_unexp_error;

479: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
480: p_data => x_msg_data);
481: WHEN fnd_api.g_exc_unexpected_error THEN
482: ROLLBACK TO ROLE_RELATE_SP;
483: x_return_status := fnd_api.g_ret_sts_unexp_error;
484: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
485: p_data => x_msg_data);
486: WHEN OTHERS THEN
487: ROLLBACK TO ROLE_RELATE_SP;

Line 493: x_return_status := fnd_api.g_ret_sts_unexp_error;

489: fnd_message.set_token('P_SQLCODE',SQLCODE);
490: fnd_message.set_token('P_SQLERRM',SQLERRM);
491: fnd_message.set_token('P_API_NAME', l_api_name);
492: FND_MSG_PUB.add;
493: x_return_status := fnd_api.g_ret_sts_unexp_error;
494: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
495: p_data => x_msg_data);
496:
497: END delete_resource_role_relate;