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_GROUP_MEMBERS_PVT dependencies on FND_API

Line 36: x_return_status := fnd_api.g_ret_sts_success;

32:
33: BEGIN
34: SAVEPOINT assign_value_sp;
35:
36: x_return_status := fnd_api.g_ret_sts_success;
37:
38: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
39: RAISE fnd_api.g_exc_unexpected_error;
40: END IF;

Line 38: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

34: SAVEPOINT assign_value_sp;
35:
36: x_return_status := fnd_api.g_ret_sts_success;
37:
38: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
39: RAISE fnd_api.g_exc_unexpected_error;
40: END IF;
41:
42:

Line 39: RAISE fnd_api.g_exc_unexpected_error;

35:
36: x_return_status := fnd_api.g_ret_sts_success;
37:
38: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
39: RAISE fnd_api.g_exc_unexpected_error;
40: END IF;
41:
42:
43: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 43: IF fnd_api.to_boolean(p_init_msg_list) THEN

39: RAISE fnd_api.g_exc_unexpected_error;
40: END IF;
41:
42:
43: IF fnd_api.to_boolean(p_init_msg_list) THEN
44: fnd_msg_pub.initialize;
45: END IF;
46:
47: --assign the value;

Line 58: x_return_status := fnd_api.g_ret_sts_unexp_error;

54: fnd_message.set_token('P_SQLCODE',SQLCODE);
55: fnd_message.set_token('P_SQLERRM',SQLERRM);
56: fnd_message.set_token('P_API_NAME',l_api_name);
57: FND_MSG_PUB.add;
58: x_return_status := fnd_api.g_ret_sts_unexp_error;
59: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
60:
61: END assign_value_to_global;
62:

Line 141: x_return_status := fnd_api.g_ret_sts_success;

137:
138:
139: SAVEPOINT create_resource_member_pvt;
140:
141: x_return_status := fnd_api.g_ret_sts_success;
142:
143: -- DBMS_OUTPUT.put_line(' Started Create Resource Member Pvt ');
144:
145:

Line 146: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

142:
143: -- DBMS_OUTPUT.put_line(' Started Create Resource Member Pvt ');
144:
145:
146: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
147:
148: RAISE fnd_api.g_exc_unexpected_error;
149:
150: END IF;

Line 148: RAISE fnd_api.g_exc_unexpected_error;

144:
145:
146: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
147:
148: RAISE fnd_api.g_exc_unexpected_error;
149:
150: END IF;
151:
152:

Line 153: IF fnd_api.to_boolean(p_init_msg_list) THEN

149:
150: END IF;
151:
152:
153: IF fnd_api.to_boolean(p_init_msg_list) THEN
154:
155: fnd_msg_pub.initialize;
156:
157: END IF;

Line 183: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

179: p_group_id => l_group_id,
180: p_resource_id => l_resource_id,
181: x_return_status => x_return_status);
182:
183: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
184:
185: -- dbms_output.put_line('Returned Error status from the Pre Customer User Hook');
186:
187: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_CUST_USR_HOOK');

Line 190: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

186:
187: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_CUST_USR_HOOK');
188: fnd_msg_pub.add;
189:
190: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
191: RAISE FND_API.G_EXC_ERROR;
192: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
193: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
194: END IF;

Line 191: RAISE FND_API.G_EXC_ERROR;

187: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_CUST_USR_HOOK');
188: fnd_msg_pub.add;
189:
190: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
191: RAISE FND_API.G_EXC_ERROR;
192: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
193: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
194: END IF;
195:

Line 192: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

188: fnd_msg_pub.add;
189:
190: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
191: RAISE FND_API.G_EXC_ERROR;
192: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
193: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
194: END IF;
195:
196: END IF;

Line 193: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

189:
190: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
191: RAISE FND_API.G_EXC_ERROR;
192: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
193: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
194: END IF;
195:
196: END IF;
197:

Line 222: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

218: p_group_id => l_group_id,
219: p_resource_id => l_resource_id,
220: x_return_status => x_return_status);
221:
222: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
223:
224: -- dbms_output.put_line('Returned Error status from the Pre Vertical User Hook');
225:
226: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_VERT_USR_HOOK');

Line 229: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

225:
226: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_VERT_USR_HOOK');
227: fnd_msg_pub.add;
228:
229: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
230: RAISE FND_API.G_EXC_ERROR;
231: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
232: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
233: END IF;

Line 230: RAISE FND_API.G_EXC_ERROR;

226: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_VERT_USR_HOOK');
227: fnd_msg_pub.add;
228:
229: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
230: RAISE FND_API.G_EXC_ERROR;
231: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
232: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
233: END IF;
234:

Line 231: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

227: fnd_msg_pub.add;
228:
229: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
230: RAISE FND_API.G_EXC_ERROR;
231: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
232: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
233: END IF;
234:
235: END IF;

Line 232: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

228:
229: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
230: RAISE FND_API.G_EXC_ERROR;
231: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
232: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
233: END IF;
234:
235: END IF;
236:

Line 261: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

257: p_group_id => l_group_id,
258: p_resource_id => l_resource_id,
259: x_return_status => x_return_status);
260:
261: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
262:
263:
264: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_INT_USR_HOOK');
265: fnd_msg_pub.add;

Line 267: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

263:
264: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_INT_USR_HOOK');
265: fnd_msg_pub.add;
266:
267: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
268: RAISE FND_API.G_EXC_ERROR;
269: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
270: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
271: END IF;

Line 268: RAISE FND_API.G_EXC_ERROR;

264: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_INT_USR_HOOK');
265: fnd_msg_pub.add;
266:
267: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
268: RAISE FND_API.G_EXC_ERROR;
269: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
270: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
271: END IF;
272:

Line 269: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

265: fnd_msg_pub.add;
266:
267: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
268: RAISE FND_API.G_EXC_ERROR;
269: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
270: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
271: END IF;
272:
273: END IF;

Line 270: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

266:
267: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
268: RAISE FND_API.G_EXC_ERROR;
269: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
270: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
271: END IF;
272:
273: END IF;
274:

Line 295: x_return_status := fnd_api.g_ret_sts_error;

291: IF l_check_count > 0 THEN
292:
293: -- dbms_output.put_line('Resource already exists in the group');
294:
295: x_return_status := fnd_api.g_ret_sts_error;
296:
297: fnd_message.set_name('JTF', 'JTF_RS_RESOURCE_EXISTS');
298: fnd_msg_pub.add;
299:

Line 300: RAISE fnd_api.g_exc_error;

296:
297: fnd_message.set_name('JTF', 'JTF_RS_RESOURCE_EXISTS');
298: fnd_msg_pub.add;
299:
300: RAISE fnd_api.g_exc_error;
301:
302: END IF;
303:
304:

Line 331: P_INIT_MSG_LIST => fnd_api.g_false,

327: /* Make a call to the group member Audit API */
328:
329: jtf_rs_group_members_aud_pvt.insert_member
330: (P_API_VERSION => 1,
331: P_INIT_MSG_LIST => fnd_api.g_false,
332: P_COMMIT => fnd_api.g_false,
333: P_GROUP_MEMBER_ID => l_group_member_id,
334: P_GROUP_ID => l_group_id,
335: P_RESOURCE_ID => l_resource_id,

Line 332: P_COMMIT => fnd_api.g_false,

328:
329: jtf_rs_group_members_aud_pvt.insert_member
330: (P_API_VERSION => 1,
331: P_INIT_MSG_LIST => fnd_api.g_false,
332: P_COMMIT => fnd_api.g_false,
333: P_GROUP_MEMBER_ID => l_group_member_id,
334: P_GROUP_ID => l_group_id,
335: P_RESOURCE_ID => l_resource_id,
336: P_PERSON_ID => l_person_id,

Line 344: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

340: X_MSG_DATA => x_msg_data
341: );
342:
343:
344: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
345:
346: -- dbms_output.put_line('Failed status from call to audit procedure');
347:
348: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

Line 348: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

344: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
345:
346: -- dbms_output.put_line('Failed status from call to audit procedure');
347:
348: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
349: RAISE FND_API.G_EXC_ERROR;
350: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
351: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
352: END IF;

Line 349: RAISE FND_API.G_EXC_ERROR;

345:
346: -- dbms_output.put_line('Failed status from call to audit procedure');
347:
348: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
349: RAISE FND_API.G_EXC_ERROR;
350: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
351: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
352: END IF;
353:

Line 350: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

346: -- dbms_output.put_line('Failed status from call to audit procedure');
347:
348: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
349: RAISE FND_API.G_EXC_ERROR;
350: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
351: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
352: END IF;
353:
354: END IF;

Line 351: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

347:
348: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
349: RAISE FND_API.G_EXC_ERROR;
350: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
351: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
352: END IF;
353:
354: END IF;
355:

Line 411: RAISE fnd_api.g_exc_error;

407: CLOSE c_jtf_rs_group_members;
408:
409: END IF;
410:
411: RAISE fnd_api.g_exc_error;
412:
413: ELSE
414:
415: OPEN C_IS_ACTIVE(l_group_id, l_resource_id);

Line 451: RAISE fnd_api.g_exc_error;

447: CLOSE c_jtf_rs_active_grp_mbrs;
448:
449: END IF;
450:
451: RAISE fnd_api.g_exc_error;
452: END IF;
453: IF c_jtf_rs_active_grp_mbrs%ISOPEN THEN
454:
455: CLOSE c_jtf_rs_active_grp_mbrs;

Line 509: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

505: p_group_id => l_group_id,
506: p_resource_id => l_resource_id,
507: x_return_status => x_return_status);
508:
509: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
510:
511: -- dbms_output.put_line('Returned Error status from the Post Customer User Hook');
512:
513:

Line 517: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

513:
514: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_CUST_USR_HOOK');
515: fnd_msg_pub.add;
516:
517: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
518: RAISE FND_API.G_EXC_ERROR;
519: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
520: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
521: END IF;

Line 518: RAISE FND_API.G_EXC_ERROR;

514: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_CUST_USR_HOOK');
515: fnd_msg_pub.add;
516:
517: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
518: RAISE FND_API.G_EXC_ERROR;
519: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
520: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
521: END IF;
522:

Line 519: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

515: fnd_msg_pub.add;
516:
517: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
518: RAISE FND_API.G_EXC_ERROR;
519: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
520: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
521: END IF;
522:
523: END IF;

Line 520: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

516:
517: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
518: RAISE FND_API.G_EXC_ERROR;
519: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
520: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
521: END IF;
522:
523: END IF;
524:

Line 550: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

546: p_group_id => l_group_id,
547: p_resource_id => l_resource_id,
548: x_return_status => x_return_status);
549:
550: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
551:
552: -- dbms_output.put_line('Returned Error status from the Post Vertical User Hook');
553:
554:

Line 559: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

555: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_VERT_USR_HOOK');
556: fnd_msg_pub.add;
557:
558:
559: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
560: RAISE FND_API.G_EXC_ERROR;
561: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
562: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
563: END IF;

Line 560: RAISE FND_API.G_EXC_ERROR;

556: fnd_msg_pub.add;
557:
558:
559: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
560: RAISE FND_API.G_EXC_ERROR;
561: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
562: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
563: END IF;
564:

Line 561: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

557:
558:
559: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
560: RAISE FND_API.G_EXC_ERROR;
561: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
562: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
563: END IF;
564:
565: END IF;

Line 562: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

558:
559: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
560: RAISE FND_API.G_EXC_ERROR;
561: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
562: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
563: END IF;
564:
565: END IF;
566:

Line 592: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

588: p_group_id => l_group_id,
589: p_resource_id => l_resource_id,
590: x_return_status => x_return_status);
591:
592: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
593:
594:
595: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_INT_USR_HOOK');
596: fnd_msg_pub.add;

Line 599: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

595: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_INT_USR_HOOK');
596: fnd_msg_pub.add;
597:
598:
599: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
600: RAISE FND_API.G_EXC_ERROR;
601: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
602: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
603: END IF;

Line 600: RAISE FND_API.G_EXC_ERROR;

596: fnd_msg_pub.add;
597:
598:
599: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
600: RAISE FND_API.G_EXC_ERROR;
601: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
602: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
603: END IF;
604:

Line 601: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

597:
598:
599: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
600: RAISE FND_API.G_EXC_ERROR;
601: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
602: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
603: END IF;
604:
605: END IF;

Line 602: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

598:
599: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
600: RAISE FND_API.G_EXC_ERROR;
601: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
602: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
603: END IF;
604:
605: END IF;
606:

Line 651: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

647: p_bind_data_id => l_bind_data_id,
648: x_return_code => x_return_status);
649:
650:
651: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
652:
653: -- dbms_output.put_line('Returned Error status from the Message Generation API');
654:
655: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 655: x_return_status := fnd_api.g_ret_sts_unexp_error;

651: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
652:
653: -- dbms_output.put_line('Returned Error status from the Message Generation API');
654:
655: x_return_status := fnd_api.g_ret_sts_unexp_error;
656:
657: fnd_message.set_name('JTF', 'JTF_RS_ERR_MESG_GENERATE_API');
658: fnd_msg_pub.add;
659:

Line 661: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

657: fnd_message.set_name('JTF', 'JTF_RS_ERR_MESG_GENERATE_API');
658: fnd_msg_pub.add;
659:
660:
661: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
662: RAISE FND_API.G_EXC_ERROR;
663: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
664: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
665: END IF;

Line 662: RAISE FND_API.G_EXC_ERROR;

658: fnd_msg_pub.add;
659:
660:
661: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
662: RAISE FND_API.G_EXC_ERROR;
663: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
664: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
665: END IF;
666:

Line 663: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

659:
660:
661: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
662: RAISE FND_API.G_EXC_ERROR;
663: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
664: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
665: END IF;
666:
667: END IF;

Line 664: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

660:
661: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
662: RAISE FND_API.G_EXC_ERROR;
663: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
664: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
665: END IF;
666:
667: END IF;
668:

Line 691: IF fnd_api.to_boolean(p_commit) THEN

687: NULL;
688: END;
689:
690:
691: IF fnd_api.to_boolean(p_commit) THEN
692:
693: COMMIT WORK;
694:
695: END IF;

Line 702: WHEN fnd_api.g_exc_error THEN

698:
699: EXCEPTION
700:
701:
702: WHEN fnd_api.g_exc_error THEN
703: ROLLBACK TO create_resource_member_pvt;
704: x_return_status := fnd_api.g_ret_sts_error;
705: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
706: p_data => x_msg_data);

Line 704: x_return_status := fnd_api.g_ret_sts_error;

700:
701:
702: WHEN fnd_api.g_exc_error THEN
703: ROLLBACK TO create_resource_member_pvt;
704: x_return_status := fnd_api.g_ret_sts_error;
705: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
706: p_data => x_msg_data);
707: WHEN fnd_api.g_exc_unexpected_error THEN
708: ROLLBACK TO create_resource_member_pvt;

Line 707: WHEN fnd_api.g_exc_unexpected_error THEN

703: ROLLBACK TO create_resource_member_pvt;
704: x_return_status := fnd_api.g_ret_sts_error;
705: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
706: p_data => x_msg_data);
707: WHEN fnd_api.g_exc_unexpected_error THEN
708: ROLLBACK TO create_resource_member_pvt;
709: x_return_status := fnd_api.g_ret_sts_unexp_error;
710: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
711: p_data => x_msg_data);

Line 709: x_return_status := fnd_api.g_ret_sts_unexp_error;

705: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
706: p_data => x_msg_data);
707: WHEN fnd_api.g_exc_unexpected_error THEN
708: ROLLBACK TO create_resource_member_pvt;
709: x_return_status := fnd_api.g_ret_sts_unexp_error;
710: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
711: p_data => x_msg_data);
712: WHEN OTHERS THEN
713: ROLLBACK TO create_resource_member_pvt;

Line 719: x_return_status := fnd_api.g_ret_sts_unexp_error;

715: fnd_message.set_token('P_SQLCODE',SQLCODE);
716: fnd_message.set_token('P_SQLERRM',SQLERRM);
717: fnd_message.set_token('P_API_NAME', l_api_name);
718: FND_MSG_PUB.add;
719: x_return_status := fnd_api.g_ret_sts_unexp_error;
720: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
721: p_data => x_msg_data);
722:
723: END create_resource_group_members;

Line 785: DECODE(p_group_id, fnd_api.g_miss_num, group_id, p_group_id) l_group_id,

781: l_bind_data_id NUMBER;
782:
783: CURSOR c_rs_group_members_update(l_group_member_id IN NUMBER) is
784: SELECT
785: DECODE(p_group_id, fnd_api.g_miss_num, group_id, p_group_id) l_group_id,
786: DECODE(p_resource_id, fnd_api.g_miss_num, resource_id, p_resource_id) l_resource_id,
787: DECODE(p_person_id, fnd_api.g_miss_num, person_id, p_person_id) l_person_id,
788: DECODE(p_delete_flag, fnd_api.g_miss_char, delete_flag, p_delete_flag) l_delete_flag,
789: DECODE(p_attribute1,fnd_api.g_miss_char, attribute1, p_attribute1) l_attribute1,

Line 786: DECODE(p_resource_id, fnd_api.g_miss_num, resource_id, p_resource_id) l_resource_id,

782:
783: CURSOR c_rs_group_members_update(l_group_member_id IN NUMBER) is
784: SELECT
785: DECODE(p_group_id, fnd_api.g_miss_num, group_id, p_group_id) l_group_id,
786: DECODE(p_resource_id, fnd_api.g_miss_num, resource_id, p_resource_id) l_resource_id,
787: DECODE(p_person_id, fnd_api.g_miss_num, person_id, p_person_id) l_person_id,
788: DECODE(p_delete_flag, fnd_api.g_miss_char, delete_flag, p_delete_flag) l_delete_flag,
789: DECODE(p_attribute1,fnd_api.g_miss_char, attribute1, p_attribute1) l_attribute1,
790: DECODE(p_attribute2,fnd_api.g_miss_char, attribute2, p_attribute2) l_attribute2,

Line 787: DECODE(p_person_id, fnd_api.g_miss_num, person_id, p_person_id) l_person_id,

783: CURSOR c_rs_group_members_update(l_group_member_id IN NUMBER) is
784: SELECT
785: DECODE(p_group_id, fnd_api.g_miss_num, group_id, p_group_id) l_group_id,
786: DECODE(p_resource_id, fnd_api.g_miss_num, resource_id, p_resource_id) l_resource_id,
787: DECODE(p_person_id, fnd_api.g_miss_num, person_id, p_person_id) l_person_id,
788: DECODE(p_delete_flag, fnd_api.g_miss_char, delete_flag, p_delete_flag) l_delete_flag,
789: DECODE(p_attribute1,fnd_api.g_miss_char, attribute1, p_attribute1) l_attribute1,
790: DECODE(p_attribute2,fnd_api.g_miss_char, attribute2, p_attribute2) l_attribute2,
791: DECODE(p_attribute3,fnd_api.g_miss_char, attribute3, p_attribute3) l_attribute3,

Line 788: DECODE(p_delete_flag, fnd_api.g_miss_char, delete_flag, p_delete_flag) l_delete_flag,

784: SELECT
785: DECODE(p_group_id, fnd_api.g_miss_num, group_id, p_group_id) l_group_id,
786: DECODE(p_resource_id, fnd_api.g_miss_num, resource_id, p_resource_id) l_resource_id,
787: DECODE(p_person_id, fnd_api.g_miss_num, person_id, p_person_id) l_person_id,
788: DECODE(p_delete_flag, fnd_api.g_miss_char, delete_flag, p_delete_flag) l_delete_flag,
789: DECODE(p_attribute1,fnd_api.g_miss_char, attribute1, p_attribute1) l_attribute1,
790: DECODE(p_attribute2,fnd_api.g_miss_char, attribute2, p_attribute2) l_attribute2,
791: DECODE(p_attribute3,fnd_api.g_miss_char, attribute3, p_attribute3) l_attribute3,
792: DECODE(p_attribute4,fnd_api.g_miss_char, attribute4, p_attribute4) l_attribute4,

Line 789: DECODE(p_attribute1,fnd_api.g_miss_char, attribute1, p_attribute1) l_attribute1,

785: DECODE(p_group_id, fnd_api.g_miss_num, group_id, p_group_id) l_group_id,
786: DECODE(p_resource_id, fnd_api.g_miss_num, resource_id, p_resource_id) l_resource_id,
787: DECODE(p_person_id, fnd_api.g_miss_num, person_id, p_person_id) l_person_id,
788: DECODE(p_delete_flag, fnd_api.g_miss_char, delete_flag, p_delete_flag) l_delete_flag,
789: DECODE(p_attribute1,fnd_api.g_miss_char, attribute1, p_attribute1) l_attribute1,
790: DECODE(p_attribute2,fnd_api.g_miss_char, attribute2, p_attribute2) l_attribute2,
791: DECODE(p_attribute3,fnd_api.g_miss_char, attribute3, p_attribute3) l_attribute3,
792: DECODE(p_attribute4,fnd_api.g_miss_char, attribute4, p_attribute4) l_attribute4,
793: DECODE(p_attribute5,fnd_api.g_miss_char, attribute5, p_attribute5) l_attribute5,

Line 790: DECODE(p_attribute2,fnd_api.g_miss_char, attribute2, p_attribute2) l_attribute2,

786: DECODE(p_resource_id, fnd_api.g_miss_num, resource_id, p_resource_id) l_resource_id,
787: DECODE(p_person_id, fnd_api.g_miss_num, person_id, p_person_id) l_person_id,
788: DECODE(p_delete_flag, fnd_api.g_miss_char, delete_flag, p_delete_flag) l_delete_flag,
789: DECODE(p_attribute1,fnd_api.g_miss_char, attribute1, p_attribute1) l_attribute1,
790: DECODE(p_attribute2,fnd_api.g_miss_char, attribute2, p_attribute2) l_attribute2,
791: DECODE(p_attribute3,fnd_api.g_miss_char, attribute3, p_attribute3) l_attribute3,
792: DECODE(p_attribute4,fnd_api.g_miss_char, attribute4, p_attribute4) l_attribute4,
793: DECODE(p_attribute5,fnd_api.g_miss_char, attribute5, p_attribute5) l_attribute5,
794: DECODE(p_attribute6,fnd_api.g_miss_char, attribute6, p_attribute6) l_attribute6,

Line 791: DECODE(p_attribute3,fnd_api.g_miss_char, attribute3, p_attribute3) l_attribute3,

787: DECODE(p_person_id, fnd_api.g_miss_num, person_id, p_person_id) l_person_id,
788: DECODE(p_delete_flag, fnd_api.g_miss_char, delete_flag, p_delete_flag) l_delete_flag,
789: DECODE(p_attribute1,fnd_api.g_miss_char, attribute1, p_attribute1) l_attribute1,
790: DECODE(p_attribute2,fnd_api.g_miss_char, attribute2, p_attribute2) l_attribute2,
791: DECODE(p_attribute3,fnd_api.g_miss_char, attribute3, p_attribute3) l_attribute3,
792: DECODE(p_attribute4,fnd_api.g_miss_char, attribute4, p_attribute4) l_attribute4,
793: DECODE(p_attribute5,fnd_api.g_miss_char, attribute5, p_attribute5) l_attribute5,
794: DECODE(p_attribute6,fnd_api.g_miss_char, attribute6, p_attribute6) l_attribute6,
795: DECODE(p_attribute7,fnd_api.g_miss_char, attribute7, p_attribute7) l_attribute7,

Line 792: DECODE(p_attribute4,fnd_api.g_miss_char, attribute4, p_attribute4) l_attribute4,

788: DECODE(p_delete_flag, fnd_api.g_miss_char, delete_flag, p_delete_flag) l_delete_flag,
789: DECODE(p_attribute1,fnd_api.g_miss_char, attribute1, p_attribute1) l_attribute1,
790: DECODE(p_attribute2,fnd_api.g_miss_char, attribute2, p_attribute2) l_attribute2,
791: DECODE(p_attribute3,fnd_api.g_miss_char, attribute3, p_attribute3) l_attribute3,
792: DECODE(p_attribute4,fnd_api.g_miss_char, attribute4, p_attribute4) l_attribute4,
793: DECODE(p_attribute5,fnd_api.g_miss_char, attribute5, p_attribute5) l_attribute5,
794: DECODE(p_attribute6,fnd_api.g_miss_char, attribute6, p_attribute6) l_attribute6,
795: DECODE(p_attribute7,fnd_api.g_miss_char, attribute7, p_attribute7) l_attribute7,
796: DECODE(p_attribute8,fnd_api.g_miss_char, attribute8, p_attribute8) l_attribute8,

Line 793: DECODE(p_attribute5,fnd_api.g_miss_char, attribute5, p_attribute5) l_attribute5,

789: DECODE(p_attribute1,fnd_api.g_miss_char, attribute1, p_attribute1) l_attribute1,
790: DECODE(p_attribute2,fnd_api.g_miss_char, attribute2, p_attribute2) l_attribute2,
791: DECODE(p_attribute3,fnd_api.g_miss_char, attribute3, p_attribute3) l_attribute3,
792: DECODE(p_attribute4,fnd_api.g_miss_char, attribute4, p_attribute4) l_attribute4,
793: DECODE(p_attribute5,fnd_api.g_miss_char, attribute5, p_attribute5) l_attribute5,
794: DECODE(p_attribute6,fnd_api.g_miss_char, attribute6, p_attribute6) l_attribute6,
795: DECODE(p_attribute7,fnd_api.g_miss_char, attribute7, p_attribute7) l_attribute7,
796: DECODE(p_attribute8,fnd_api.g_miss_char, attribute8, p_attribute8) l_attribute8,
797: DECODE(p_attribute9,fnd_api.g_miss_char, attribute9, p_attribute9) l_attribute9,

Line 794: DECODE(p_attribute6,fnd_api.g_miss_char, attribute6, p_attribute6) l_attribute6,

790: DECODE(p_attribute2,fnd_api.g_miss_char, attribute2, p_attribute2) l_attribute2,
791: DECODE(p_attribute3,fnd_api.g_miss_char, attribute3, p_attribute3) l_attribute3,
792: DECODE(p_attribute4,fnd_api.g_miss_char, attribute4, p_attribute4) l_attribute4,
793: DECODE(p_attribute5,fnd_api.g_miss_char, attribute5, p_attribute5) l_attribute5,
794: DECODE(p_attribute6,fnd_api.g_miss_char, attribute6, p_attribute6) l_attribute6,
795: DECODE(p_attribute7,fnd_api.g_miss_char, attribute7, p_attribute7) l_attribute7,
796: DECODE(p_attribute8,fnd_api.g_miss_char, attribute8, p_attribute8) l_attribute8,
797: DECODE(p_attribute9,fnd_api.g_miss_char, attribute9, p_attribute9) l_attribute9,
798: DECODE(p_attribute10,fnd_api.g_miss_char, attribute10, p_attribute10) l_attribute10,

Line 795: DECODE(p_attribute7,fnd_api.g_miss_char, attribute7, p_attribute7) l_attribute7,

791: DECODE(p_attribute3,fnd_api.g_miss_char, attribute3, p_attribute3) l_attribute3,
792: DECODE(p_attribute4,fnd_api.g_miss_char, attribute4, p_attribute4) l_attribute4,
793: DECODE(p_attribute5,fnd_api.g_miss_char, attribute5, p_attribute5) l_attribute5,
794: DECODE(p_attribute6,fnd_api.g_miss_char, attribute6, p_attribute6) l_attribute6,
795: DECODE(p_attribute7,fnd_api.g_miss_char, attribute7, p_attribute7) l_attribute7,
796: DECODE(p_attribute8,fnd_api.g_miss_char, attribute8, p_attribute8) l_attribute8,
797: DECODE(p_attribute9,fnd_api.g_miss_char, attribute9, p_attribute9) l_attribute9,
798: DECODE(p_attribute10,fnd_api.g_miss_char, attribute10, p_attribute10) l_attribute10,
799: DECODE(p_attribute11,fnd_api.g_miss_char, attribute11, p_attribute11) l_attribute11,

Line 796: DECODE(p_attribute8,fnd_api.g_miss_char, attribute8, p_attribute8) l_attribute8,

792: DECODE(p_attribute4,fnd_api.g_miss_char, attribute4, p_attribute4) l_attribute4,
793: DECODE(p_attribute5,fnd_api.g_miss_char, attribute5, p_attribute5) l_attribute5,
794: DECODE(p_attribute6,fnd_api.g_miss_char, attribute6, p_attribute6) l_attribute6,
795: DECODE(p_attribute7,fnd_api.g_miss_char, attribute7, p_attribute7) l_attribute7,
796: DECODE(p_attribute8,fnd_api.g_miss_char, attribute8, p_attribute8) l_attribute8,
797: DECODE(p_attribute9,fnd_api.g_miss_char, attribute9, p_attribute9) l_attribute9,
798: DECODE(p_attribute10,fnd_api.g_miss_char, attribute10, p_attribute10) l_attribute10,
799: DECODE(p_attribute11,fnd_api.g_miss_char, attribute11, p_attribute11) l_attribute11,
800: DECODE(p_attribute12,fnd_api.g_miss_char, attribute12, p_attribute12) l_attribute12,

Line 797: DECODE(p_attribute9,fnd_api.g_miss_char, attribute9, p_attribute9) l_attribute9,

793: DECODE(p_attribute5,fnd_api.g_miss_char, attribute5, p_attribute5) l_attribute5,
794: DECODE(p_attribute6,fnd_api.g_miss_char, attribute6, p_attribute6) l_attribute6,
795: DECODE(p_attribute7,fnd_api.g_miss_char, attribute7, p_attribute7) l_attribute7,
796: DECODE(p_attribute8,fnd_api.g_miss_char, attribute8, p_attribute8) l_attribute8,
797: DECODE(p_attribute9,fnd_api.g_miss_char, attribute9, p_attribute9) l_attribute9,
798: DECODE(p_attribute10,fnd_api.g_miss_char, attribute10, p_attribute10) l_attribute10,
799: DECODE(p_attribute11,fnd_api.g_miss_char, attribute11, p_attribute11) l_attribute11,
800: DECODE(p_attribute12,fnd_api.g_miss_char, attribute12, p_attribute12) l_attribute12,
801: DECODE(p_attribute13,fnd_api.g_miss_char, attribute13, p_attribute13) l_attribute13,

Line 798: DECODE(p_attribute10,fnd_api.g_miss_char, attribute10, p_attribute10) l_attribute10,

794: DECODE(p_attribute6,fnd_api.g_miss_char, attribute6, p_attribute6) l_attribute6,
795: DECODE(p_attribute7,fnd_api.g_miss_char, attribute7, p_attribute7) l_attribute7,
796: DECODE(p_attribute8,fnd_api.g_miss_char, attribute8, p_attribute8) l_attribute8,
797: DECODE(p_attribute9,fnd_api.g_miss_char, attribute9, p_attribute9) l_attribute9,
798: DECODE(p_attribute10,fnd_api.g_miss_char, attribute10, p_attribute10) l_attribute10,
799: DECODE(p_attribute11,fnd_api.g_miss_char, attribute11, p_attribute11) l_attribute11,
800: DECODE(p_attribute12,fnd_api.g_miss_char, attribute12, p_attribute12) l_attribute12,
801: DECODE(p_attribute13,fnd_api.g_miss_char, attribute13, p_attribute13) l_attribute13,
802: DECODE(p_attribute14,fnd_api.g_miss_char, attribute14, p_attribute14) l_attribute14,

Line 799: DECODE(p_attribute11,fnd_api.g_miss_char, attribute11, p_attribute11) l_attribute11,

795: DECODE(p_attribute7,fnd_api.g_miss_char, attribute7, p_attribute7) l_attribute7,
796: DECODE(p_attribute8,fnd_api.g_miss_char, attribute8, p_attribute8) l_attribute8,
797: DECODE(p_attribute9,fnd_api.g_miss_char, attribute9, p_attribute9) l_attribute9,
798: DECODE(p_attribute10,fnd_api.g_miss_char, attribute10, p_attribute10) l_attribute10,
799: DECODE(p_attribute11,fnd_api.g_miss_char, attribute11, p_attribute11) l_attribute11,
800: DECODE(p_attribute12,fnd_api.g_miss_char, attribute12, p_attribute12) l_attribute12,
801: DECODE(p_attribute13,fnd_api.g_miss_char, attribute13, p_attribute13) l_attribute13,
802: DECODE(p_attribute14,fnd_api.g_miss_char, attribute14, p_attribute14) l_attribute14,
803: DECODE(p_attribute15,fnd_api.g_miss_char, attribute15, p_attribute15) l_attribute15,

Line 800: DECODE(p_attribute12,fnd_api.g_miss_char, attribute12, p_attribute12) l_attribute12,

796: DECODE(p_attribute8,fnd_api.g_miss_char, attribute8, p_attribute8) l_attribute8,
797: DECODE(p_attribute9,fnd_api.g_miss_char, attribute9, p_attribute9) l_attribute9,
798: DECODE(p_attribute10,fnd_api.g_miss_char, attribute10, p_attribute10) l_attribute10,
799: DECODE(p_attribute11,fnd_api.g_miss_char, attribute11, p_attribute11) l_attribute11,
800: DECODE(p_attribute12,fnd_api.g_miss_char, attribute12, p_attribute12) l_attribute12,
801: DECODE(p_attribute13,fnd_api.g_miss_char, attribute13, p_attribute13) l_attribute13,
802: DECODE(p_attribute14,fnd_api.g_miss_char, attribute14, p_attribute14) l_attribute14,
803: DECODE(p_attribute15,fnd_api.g_miss_char, attribute15, p_attribute15) l_attribute15,
804: DECODE(p_attribute_category,fnd_api.g_miss_char, attribute1, p_attribute_category) l_attribute_category

Line 801: DECODE(p_attribute13,fnd_api.g_miss_char, attribute13, p_attribute13) l_attribute13,

797: DECODE(p_attribute9,fnd_api.g_miss_char, attribute9, p_attribute9) l_attribute9,
798: DECODE(p_attribute10,fnd_api.g_miss_char, attribute10, p_attribute10) l_attribute10,
799: DECODE(p_attribute11,fnd_api.g_miss_char, attribute11, p_attribute11) l_attribute11,
800: DECODE(p_attribute12,fnd_api.g_miss_char, attribute12, p_attribute12) l_attribute12,
801: DECODE(p_attribute13,fnd_api.g_miss_char, attribute13, p_attribute13) l_attribute13,
802: DECODE(p_attribute14,fnd_api.g_miss_char, attribute14, p_attribute14) l_attribute14,
803: DECODE(p_attribute15,fnd_api.g_miss_char, attribute15, p_attribute15) l_attribute15,
804: DECODE(p_attribute_category,fnd_api.g_miss_char, attribute1, p_attribute_category) l_attribute_category
805: FROM jtf_rs_group_members

Line 802: DECODE(p_attribute14,fnd_api.g_miss_char, attribute14, p_attribute14) l_attribute14,

798: DECODE(p_attribute10,fnd_api.g_miss_char, attribute10, p_attribute10) l_attribute10,
799: DECODE(p_attribute11,fnd_api.g_miss_char, attribute11, p_attribute11) l_attribute11,
800: DECODE(p_attribute12,fnd_api.g_miss_char, attribute12, p_attribute12) l_attribute12,
801: DECODE(p_attribute13,fnd_api.g_miss_char, attribute13, p_attribute13) l_attribute13,
802: DECODE(p_attribute14,fnd_api.g_miss_char, attribute14, p_attribute14) l_attribute14,
803: DECODE(p_attribute15,fnd_api.g_miss_char, attribute15, p_attribute15) l_attribute15,
804: DECODE(p_attribute_category,fnd_api.g_miss_char, attribute1, p_attribute_category) l_attribute_category
805: FROM jtf_rs_group_members
806: WHERE group_member_id = l_group_member_id;

Line 803: DECODE(p_attribute15,fnd_api.g_miss_char, attribute15, p_attribute15) l_attribute15,

799: DECODE(p_attribute11,fnd_api.g_miss_char, attribute11, p_attribute11) l_attribute11,
800: DECODE(p_attribute12,fnd_api.g_miss_char, attribute12, p_attribute12) l_attribute12,
801: DECODE(p_attribute13,fnd_api.g_miss_char, attribute13, p_attribute13) l_attribute13,
802: DECODE(p_attribute14,fnd_api.g_miss_char, attribute14, p_attribute14) l_attribute14,
803: DECODE(p_attribute15,fnd_api.g_miss_char, attribute15, p_attribute15) l_attribute15,
804: DECODE(p_attribute_category,fnd_api.g_miss_char, attribute1, p_attribute_category) l_attribute_category
805: FROM jtf_rs_group_members
806: WHERE group_member_id = l_group_member_id;
807:

Line 804: DECODE(p_attribute_category,fnd_api.g_miss_char, attribute1, p_attribute_category) l_attribute_category

800: DECODE(p_attribute12,fnd_api.g_miss_char, attribute12, p_attribute12) l_attribute12,
801: DECODE(p_attribute13,fnd_api.g_miss_char, attribute13, p_attribute13) l_attribute13,
802: DECODE(p_attribute14,fnd_api.g_miss_char, attribute14, p_attribute14) l_attribute14,
803: DECODE(p_attribute15,fnd_api.g_miss_char, attribute15, p_attribute15) l_attribute15,
804: DECODE(p_attribute_category,fnd_api.g_miss_char, attribute1, p_attribute_category) l_attribute_category
805: FROM jtf_rs_group_members
806: WHERE group_member_id = l_group_member_id;
807:
808: rs_group_member_rec c_rs_group_members_update%ROWTYPE;

Line 811: x_return_status := fnd_api.g_ret_sts_success;

807:
808: rs_group_member_rec c_rs_group_members_update%ROWTYPE;
809: BEGIN
810: SAVEPOINT update_rs_group_members_pvt;
811: x_return_status := fnd_api.g_ret_sts_success;
812: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
813: RAISE fnd_api.g_exc_unexpected_error;
814: END IF;
815: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 812: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

808: rs_group_member_rec c_rs_group_members_update%ROWTYPE;
809: BEGIN
810: SAVEPOINT update_rs_group_members_pvt;
811: x_return_status := fnd_api.g_ret_sts_success;
812: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
813: RAISE fnd_api.g_exc_unexpected_error;
814: END IF;
815: IF fnd_api.to_boolean(p_init_msg_list) THEN
816: fnd_msg_pub.initialize;

Line 813: RAISE fnd_api.g_exc_unexpected_error;

809: BEGIN
810: SAVEPOINT update_rs_group_members_pvt;
811: x_return_status := fnd_api.g_ret_sts_success;
812: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
813: RAISE fnd_api.g_exc_unexpected_error;
814: END IF;
815: IF fnd_api.to_boolean(p_init_msg_list) THEN
816: fnd_msg_pub.initialize;
817: END IF;

Line 815: IF fnd_api.to_boolean(p_init_msg_list) THEN

811: x_return_status := fnd_api.g_ret_sts_success;
812: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
813: RAISE fnd_api.g_exc_unexpected_error;
814: END IF;
815: IF fnd_api.to_boolean(p_init_msg_list) THEN
816: fnd_msg_pub.initialize;
817: END IF;
818:
819: /* Make the pre processing call to the user hooks */

Line 840: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

836: jtf_rs_group_member_cuhk.update_group_members_pre(
837: p_group_member_id => l_group_member_id,
838: x_return_status => x_return_status);
839:
840: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
841:
842: -- dbms_output.put_line('Returned Error status from the Pre Customer User Hook');
843:
844: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 844: x_return_status := fnd_api.g_ret_sts_unexp_error;

840: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
841:
842: -- dbms_output.put_line('Returned Error status from the Pre Customer User Hook');
843:
844: x_return_status := fnd_api.g_ret_sts_unexp_error;
845:
846: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_CUST_USR_HOOK');
847: fnd_msg_pub.add;
848:

Line 849: RAISE fnd_api.g_exc_unexpected_error;

845:
846: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_CUST_USR_HOOK');
847: fnd_msg_pub.add;
848:
849: RAISE fnd_api.g_exc_unexpected_error;
850:
851: END IF;
852:
853: END IF;

Line 876: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

872: jtf_rs_group_member_vuhk.update_group_members_pre(
873: p_group_member_id => l_group_member_id,
874: x_return_status => x_return_status);
875:
876: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
877:
878: -- dbms_output.put_line('Returned Error status from the Pre Vertical User Hook');
879:
880: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 880: x_return_status := fnd_api.g_ret_sts_unexp_error;

876: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
877:
878: -- dbms_output.put_line('Returned Error status from the Pre Vertical User Hook');
879:
880: x_return_status := fnd_api.g_ret_sts_unexp_error;
881:
882: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_VERT_USR_HOOK');
883: fnd_msg_pub.add;
884:

Line 885: RAISE fnd_api.g_exc_unexpected_error;

881:
882: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_VERT_USR_HOOK');
883: fnd_msg_pub.add;
884:
885: RAISE fnd_api.g_exc_unexpected_error;
886:
887: END IF;
888:
889: END IF;

Line 912: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

908: jtf_rs_group_member_iuhk.update_group_members_pre(
909: p_group_member_id => l_group_member_id,
910: x_return_status => x_return_status);
911:
912: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
913:
914: x_return_status := fnd_api.g_ret_sts_unexp_error;
915:
916: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_INT_USR_HOOK');

Line 914: x_return_status := fnd_api.g_ret_sts_unexp_error;

910: x_return_status => x_return_status);
911:
912: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
913:
914: x_return_status := fnd_api.g_ret_sts_unexp_error;
915:
916: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_INT_USR_HOOK');
917: fnd_msg_pub.add;
918:

Line 919: RAISE fnd_api.g_exc_unexpected_error;

915:
916: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_INT_USR_HOOK');
917: fnd_msg_pub.add;
918:
919: RAISE fnd_api.g_exc_unexpected_error;
920:
921: END IF;
922:
923: END IF;

Line 934: x_return_status := fnd_api.g_ret_sts_unexp_error;

930: CLOSE c_rs_group_members_update;
931: fnd_message.set_name('JTF', 'JTF_RS_INVALID_GRP_MBR_ID');
932: fnd_message.set_token('P_GRP_MBR_ID', p_group_member_id);
933: fnd_msg_pub.add;
934: x_return_status := fnd_api.g_ret_sts_unexp_error;
935: RAISE fnd_api.g_exc_unexpected_error;
936: END IF;
937:
938:

Line 935: RAISE fnd_api.g_exc_unexpected_error;

931: fnd_message.set_name('JTF', 'JTF_RS_INVALID_GRP_MBR_ID');
932: fnd_message.set_token('P_GRP_MBR_ID', p_group_member_id);
933: fnd_msg_pub.add;
934: x_return_status := fnd_api.g_ret_sts_unexp_error;
935: RAISE fnd_api.g_exc_unexpected_error;
936: END IF;
937:
938:
939: --Call the Lock Row Table Handler before updating the record

Line 950: P_INIT_MSG_LIST => fnd_api.g_false,

946:
947: jtf_rs_group_members_aud_pvt.update_member
948: (
949: P_API_VERSION => 1,
950: P_INIT_MSG_LIST => fnd_api.g_false,
951: P_COMMIT => fnd_api.g_false,
952: P_GROUP_MEMBER_ID => l_group_member_id,
953: P_GROUP_ID => rs_group_member_rec.l_group_id,
954: P_RESOURCE_ID => rs_group_member_rec.l_resource_id,

Line 951: P_COMMIT => fnd_api.g_false,

947: jtf_rs_group_members_aud_pvt.update_member
948: (
949: P_API_VERSION => 1,
950: P_INIT_MSG_LIST => fnd_api.g_false,
951: P_COMMIT => fnd_api.g_false,
952: P_GROUP_MEMBER_ID => l_group_member_id,
953: P_GROUP_ID => rs_group_member_rec.l_group_id,
954: P_RESOURCE_ID => rs_group_member_rec.l_resource_id,
955: P_PERSON_ID => rs_group_member_rec.l_person_id,

Line 963: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

959: X_MSG_DATA => x_msg_data
960: );
961:
962:
963: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
964:
965: -- dbms_output.put_line('Failed status from call to audit procedure');
966:
967: RAISE fnd_api.g_exc_unexpected_error;

Line 967: RAISE fnd_api.g_exc_unexpected_error;

963: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
964:
965: -- dbms_output.put_line('Failed status from call to audit procedure');
966:
967: RAISE fnd_api.g_exc_unexpected_error;
968:
969: END IF;
970:
971: --Update the Object Version Number by Incrementing It

Line 1009: x_return_status := fnd_api.g_ret_sts_unexp_error;

1005:
1006: EXCEPTION
1007: WHEN NO_DATA_FOUND THEN
1008: CLOSE c_rs_group_members_update;
1009: x_return_status := fnd_api.g_ret_sts_unexp_error;
1010: fnd_message.set_name('JTF', 'JTF_RS_TABLE_HANDLER_ERROR');
1011: fnd_msg_pub.add;
1012: RAISE fnd_api.g_exc_unexpected_error;
1013: END;

Line 1012: RAISE fnd_api.g_exc_unexpected_error;

1008: CLOSE c_rs_group_members_update;
1009: x_return_status := fnd_api.g_ret_sts_unexp_error;
1010: fnd_message.set_name('JTF', 'JTF_RS_TABLE_HANDLER_ERROR');
1011: fnd_msg_pub.add;
1012: RAISE fnd_api.g_exc_unexpected_error;
1013: END;
1014:
1015: /* Make the post processing call to the user hooks */
1016:

Line 1036: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

1032: jtf_rs_group_member_cuhk.update_group_members_post(
1033: p_group_member_id => l_group_member_id,
1034: x_return_status => x_return_status);
1035:
1036: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1037:
1038: -- dbms_output.put_line('Returned Error status from the Post Customer User Hook');
1039:
1040: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1040: x_return_status := fnd_api.g_ret_sts_unexp_error;

1036: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1037:
1038: -- dbms_output.put_line('Returned Error status from the Post Customer User Hook');
1039:
1040: x_return_status := fnd_api.g_ret_sts_unexp_error;
1041:
1042: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_CUST_USR_HOOK');
1043: fnd_msg_pub.add;
1044:

Line 1045: RAISE fnd_api.g_exc_unexpected_error;

1041:
1042: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_CUST_USR_HOOK');
1043: fnd_msg_pub.add;
1044:
1045: RAISE fnd_api.g_exc_unexpected_error;
1046:
1047: END IF;
1048:
1049: END IF;

Line 1072: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

1068: jtf_rs_group_member_vuhk.update_group_members_post(
1069: p_group_member_id => l_group_member_id,
1070: x_return_status => x_return_status);
1071:
1072: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1073:
1074: -- dbms_output.put_line('Returned Error status from the Post Vertical User Hook');
1075:
1076: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1076: x_return_status := fnd_api.g_ret_sts_unexp_error;

1072: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1073:
1074: -- dbms_output.put_line('Returned Error status from the Post Vertical User Hook');
1075:
1076: x_return_status := fnd_api.g_ret_sts_unexp_error;
1077:
1078: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_VERT_USR_HOOK');
1079: fnd_msg_pub.add;
1080:

Line 1081: RAISE fnd_api.g_exc_unexpected_error;

1077:
1078: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_VERT_USR_HOOK');
1079: fnd_msg_pub.add;
1080:
1081: RAISE fnd_api.g_exc_unexpected_error;
1082:
1083: END IF;
1084:
1085: END IF;

Line 1108: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

1104: jtf_rs_group_member_iuhk.update_group_members_post(
1105: p_group_member_id => l_group_member_id,
1106: x_return_status => x_return_status);
1107:
1108: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1109:
1110: x_return_status := fnd_api.g_ret_sts_unexp_error;
1111:
1112: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_INT_USR_HOOK');

Line 1110: x_return_status := fnd_api.g_ret_sts_unexp_error;

1106: x_return_status => x_return_status);
1107:
1108: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1109:
1110: x_return_status := fnd_api.g_ret_sts_unexp_error;
1111:
1112: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_INT_USR_HOOK');
1113: fnd_msg_pub.add;
1114:

Line 1115: RAISE fnd_api.g_exc_unexpected_error;

1111:
1112: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_INT_USR_HOOK');
1113: fnd_msg_pub.add;
1114:
1115: RAISE fnd_api.g_exc_unexpected_error;
1116:
1117: END IF;
1118:
1119: END IF;

Line 1163: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

1159: p_bind_data_id => l_bind_data_id,
1160: x_return_code => x_return_status);
1161:
1162:
1163: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1164:
1165: -- dbms_output.put_line('Returned Error status from the Message Generation API');
1166:
1167: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1167: x_return_status := fnd_api.g_ret_sts_unexp_error;

1163: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1164:
1165: -- dbms_output.put_line('Returned Error status from the Message Generation API');
1166:
1167: x_return_status := fnd_api.g_ret_sts_unexp_error;
1168:
1169: fnd_message.set_name('JTF', 'JTF_RS_ERR_MESG_GENERATE_API');
1170: fnd_msg_pub.add;
1171:

Line 1172: RAISE fnd_api.g_exc_unexpected_error;

1168:
1169: fnd_message.set_name('JTF', 'JTF_RS_ERR_MESG_GENERATE_API');
1170: fnd_msg_pub.add;
1171:
1172: RAISE fnd_api.g_exc_unexpected_error;
1173:
1174: END IF;
1175:
1176: END IF;

Line 1182: IF fnd_api.to_boolean(p_commit) THEN

1178: END IF;
1179: END IF;
1180:
1181:
1182: IF fnd_api.to_boolean(p_commit) THEN
1183:
1184: COMMIT WORK;
1185:
1186: END IF;

Line 1191: WHEN fnd_api.g_exc_unexpected_error THEN

1187:
1188: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1189:
1190: EXCEPTION
1191: WHEN fnd_api.g_exc_unexpected_error THEN
1192: --DBMS_OUTPUT.put_line (' ========================================== ');
1193: --DBMS_OUTPUT.put_line ('=========== Raised Unexpected Error =============== ');
1194: ROLLBACK TO update_rs_group_members_pvt;
1195: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1195: x_return_status := fnd_api.g_ret_sts_unexp_error;

1191: WHEN fnd_api.g_exc_unexpected_error THEN
1192: --DBMS_OUTPUT.put_line (' ========================================== ');
1193: --DBMS_OUTPUT.put_line ('=========== Raised Unexpected Error =============== ');
1194: ROLLBACK TO update_rs_group_members_pvt;
1195: x_return_status := fnd_api.g_ret_sts_unexp_error;
1196: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1197: WHEN OTHERS THEN
1198: --DBMS_OUTPUT.put_line (' ========================================== ');
1199: --DBMS_OUTPUT.put_line (' =========== Raised Others in Update Resource Role Pub =============');

Line 1207: x_return_status := fnd_api.g_ret_sts_unexp_error;

1203: fnd_message.set_token('P_SQLCODE',SQLCODE);
1204: fnd_message.set_token('P_SQLERRM',SQLERRM);
1205: fnd_message.set_token('P_API_NAME',l_api_name);
1206: FND_MSG_PUB.add;
1207: x_return_status := fnd_api.g_ret_sts_unexp_error;
1208: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1209:
1210: END;
1211:

Line 1275: x_return_status := fnd_api.g_ret_sts_success;

1271:
1272:
1273: SAVEPOINT delete_resource_member_pvt;
1274:
1275: x_return_status := fnd_api.g_ret_sts_success;
1276:
1277: -- DBMS_OUTPUT.put_line(' Started Delete Resource Member Pvt ');
1278:
1279:

Line 1280: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

1276:
1277: -- DBMS_OUTPUT.put_line(' Started Delete Resource Member Pvt ');
1278:
1279:
1280: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
1281:
1282: RAISE fnd_api.g_exc_unexpected_error;
1283:
1284: END IF;

Line 1282: RAISE fnd_api.g_exc_unexpected_error;

1278:
1279:
1280: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
1281:
1282: RAISE fnd_api.g_exc_unexpected_error;
1283:
1284: END IF;
1285:
1286:

Line 1287: IF fnd_api.to_boolean(p_init_msg_list) THEN

1283:
1284: END IF;
1285:
1286:
1287: IF fnd_api.to_boolean(p_init_msg_list) THEN
1288:
1289: fnd_msg_pub.initialize;
1290:
1291: END IF;

Line 1316: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

1312: p_group_id => l_group_id,
1313: p_resource_id => l_resource_id,
1314: x_return_status => x_return_status);
1315:
1316: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1317:
1318: -- dbms_output.put_line('Returned Error status from the Pre Customer User Hook');
1319:
1320: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_CUST_USR_HOOK');

Line 1324: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

1320: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_CUST_USR_HOOK');
1321: fnd_msg_pub.add;
1322:
1323:
1324: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1325: RAISE FND_API.G_EXC_ERROR;
1326: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1327: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1328: END IF;

Line 1325: RAISE FND_API.G_EXC_ERROR;

1321: fnd_msg_pub.add;
1322:
1323:
1324: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1325: RAISE FND_API.G_EXC_ERROR;
1326: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1327: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1328: END IF;
1329:

Line 1326: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

1322:
1323:
1324: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1325: RAISE FND_API.G_EXC_ERROR;
1326: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1327: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1328: END IF;
1329:
1330:

Line 1327: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1323:
1324: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1325: RAISE FND_API.G_EXC_ERROR;
1326: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1327: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1328: END IF;
1329:
1330:
1331: END IF;

Line 1357: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

1353: p_group_id => l_group_id,
1354: p_resource_id => l_resource_id,
1355: x_return_status => x_return_status);
1356:
1357: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1358:
1359: -- dbms_output.put_line('Returned Error status from the Pre Vertical User Hook');
1360:
1361: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_VERT_USR_HOOK');

Line 1365: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

1361: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_VERT_USR_HOOK');
1362: fnd_msg_pub.add;
1363:
1364:
1365: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1366: RAISE FND_API.G_EXC_ERROR;
1367: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1368: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1369: END IF;

Line 1366: RAISE FND_API.G_EXC_ERROR;

1362: fnd_msg_pub.add;
1363:
1364:
1365: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1366: RAISE FND_API.G_EXC_ERROR;
1367: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1368: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1369: END IF;
1370:

Line 1367: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

1363:
1364:
1365: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1366: RAISE FND_API.G_EXC_ERROR;
1367: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1368: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1369: END IF;
1370:
1371: END IF;

Line 1368: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1364:
1365: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1366: RAISE FND_API.G_EXC_ERROR;
1367: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1368: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1369: END IF;
1370:
1371: END IF;
1372:

Line 1397: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

1393: p_group_id => l_group_id,
1394: p_resource_id => l_resource_id,
1395: x_return_status => x_return_status);
1396:
1397: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1398:
1399:
1400: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_INT_USR_HOOK');
1401: fnd_msg_pub.add;

Line 1403: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

1399:
1400: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_INT_USR_HOOK');
1401: fnd_msg_pub.add;
1402:
1403: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1404: RAISE FND_API.G_EXC_ERROR;
1405: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1406: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1407: END IF;

Line 1404: RAISE FND_API.G_EXC_ERROR;

1400: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_INT_USR_HOOK');
1401: fnd_msg_pub.add;
1402:
1403: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1404: RAISE FND_API.G_EXC_ERROR;
1405: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1406: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1407: END IF;
1408:

Line 1405: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

1401: fnd_msg_pub.add;
1402:
1403: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1404: RAISE FND_API.G_EXC_ERROR;
1405: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1406: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1407: END IF;
1408:
1409: END IF;

Line 1406: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1402:
1403: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1404: RAISE FND_API.G_EXC_ERROR;
1405: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1406: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1407: END IF;
1408:
1409: END IF;
1410:

Line 1437: RAISE fnd_api.g_exc_error;

1433: fnd_message.set_name('JTF', 'JTF_RS_INVALID_GROUP_MEMBER');
1434: fnd_message.set_token('P_RESOURCE_ID', l_resource_id);
1435: fnd_msg_pub.add;
1436:
1437: RAISE fnd_api.g_exc_error;
1438:
1439: END IF;
1440:
1441:

Line 1473: RAISE fnd_api.g_exc_error;

1469:
1470: fnd_message.set_name('JTF', 'JTF_RS_ERROR_ROLE_COUNT');
1471: fnd_msg_pub.add;
1472:
1473: RAISE fnd_api.g_exc_error;
1474:
1475: ELSE
1476:
1477: IF l_role_relate_count > 0 THEN

Line 1490: x_return_status := fnd_api.g_ret_sts_unexp_error;

1486:
1487: fnd_message.set_name('JTF', 'JTF_RS_ACTIVE_ROLE_EXIST');
1488: fnd_msg_pub.add;
1489:
1490: x_return_status := fnd_api.g_ret_sts_unexp_error;
1491:
1492: RAISE fnd_api.g_exc_error;
1493:
1494: END IF;

Line 1492: RAISE fnd_api.g_exc_error;

1488: fnd_msg_pub.add;
1489:
1490: x_return_status := fnd_api.g_ret_sts_unexp_error;
1491:
1492: RAISE fnd_api.g_exc_error;
1493:
1494: END IF;
1495:
1496: END IF;

Line 1516: x_return_status := fnd_api.g_ret_sts_unexp_error;

1512: WHEN OTHERS THEN
1513:
1514: -- dbms_output.put_line('Error in Locking the Row');
1515:
1516: x_return_status := fnd_api.g_ret_sts_unexp_error;
1517:
1518: fnd_message.set_name('JTF', 'JTF_RS_ROW_LOCK_ERROR');
1519: fnd_msg_pub.add;
1520:

Line 1521: RAISE fnd_api.g_exc_error;

1517:
1518: fnd_message.set_name('JTF', 'JTF_RS_ROW_LOCK_ERROR');
1519: fnd_msg_pub.add;
1520:
1521: RAISE fnd_api.g_exc_error;
1522:
1523: END;
1524:
1525:

Line 1530: P_INIT_MSG_LIST => fnd_api.g_false,

1526: /* Make a call to the group member Audit API */
1527:
1528: jtf_rs_group_members_aud_pvt.delete_member
1529: (P_API_VERSION => 1,
1530: P_INIT_MSG_LIST => fnd_api.g_false,
1531: P_COMMIT => fnd_api.g_false,
1532: P_GROUP_MEMBER_ID => l_group_member_id,
1533: X_RETURN_STATUS => x_return_status,
1534: X_MSG_COUNT => x_msg_count,

Line 1531: P_COMMIT => fnd_api.g_false,

1527:
1528: jtf_rs_group_members_aud_pvt.delete_member
1529: (P_API_VERSION => 1,
1530: P_INIT_MSG_LIST => fnd_api.g_false,
1531: P_COMMIT => fnd_api.g_false,
1532: P_GROUP_MEMBER_ID => l_group_member_id,
1533: X_RETURN_STATUS => x_return_status,
1534: X_MSG_COUNT => x_msg_count,
1535: X_MSG_DATA => x_msg_data

Line 1539: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

1535: X_MSG_DATA => x_msg_data
1536: );
1537:
1538:
1539: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1540:
1541: -- dbms_output.put_line('Failed status from call to audit procedure');
1542:
1543:

Line 1544: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

1540:
1541: -- dbms_output.put_line('Failed status from call to audit procedure');
1542:
1543:
1544: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1545: RAISE FND_API.G_EXC_ERROR;
1546: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1547: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1548: END IF;

Line 1545: RAISE FND_API.G_EXC_ERROR;

1541: -- dbms_output.put_line('Failed status from call to audit procedure');
1542:
1543:
1544: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1545: RAISE FND_API.G_EXC_ERROR;
1546: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1547: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1548: END IF;
1549:

Line 1546: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

1542:
1543:
1544: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1545: RAISE FND_API.G_EXC_ERROR;
1546: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1547: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1548: END IF;
1549:
1550: END IF;

Line 1547: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1543:
1544: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1545: RAISE FND_API.G_EXC_ERROR;
1546: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1547: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1548: END IF;
1549:
1550: END IF;
1551:

Line 1598: RAISE fnd_api.g_exc_error;

1594:
1595: fnd_message.set_name('JTF', 'JTF_RS_TABLE_HANDLER_ERROR');
1596: fnd_msg_pub.add;
1597:
1598: RAISE fnd_api.g_exc_error;
1599:
1600: END;
1601:
1602:

Line 1625: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

1621: p_group_id => l_group_id,
1622: p_resource_id => l_resource_id,
1623: x_return_status => x_return_status);
1624:
1625: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1626:
1627: -- dbms_output.put_line('Returned Error status from the Post Customer User Hook');
1628:
1629:

Line 1634: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

1630: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_CUST_USR_HOOK');
1631: fnd_msg_pub.add;
1632:
1633:
1634: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1635: RAISE FND_API.G_EXC_ERROR;
1636: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1637: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1638: END IF;

Line 1635: RAISE FND_API.G_EXC_ERROR;

1631: fnd_msg_pub.add;
1632:
1633:
1634: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1635: RAISE FND_API.G_EXC_ERROR;
1636: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1637: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1638: END IF;
1639:

Line 1636: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

1632:
1633:
1634: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1635: RAISE FND_API.G_EXC_ERROR;
1636: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1637: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1638: END IF;
1639:
1640: END IF;

Line 1637: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1633:
1634: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1635: RAISE FND_API.G_EXC_ERROR;
1636: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1637: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1638: END IF;
1639:
1640: END IF;
1641:

Line 1666: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

1662: p_group_id => l_group_id,
1663: p_resource_id => l_resource_id,
1664: x_return_status => x_return_status);
1665:
1666: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1667:
1668: -- dbms_output.put_line('Returned Error status from the Post Vertical User Hook');
1669:
1670: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_VERT_USR_HOOK');

Line 1674: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

1670: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_VERT_USR_HOOK');
1671: fnd_msg_pub.add;
1672:
1673:
1674: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1675: RAISE FND_API.G_EXC_ERROR;
1676: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1677: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1678: END IF;

Line 1675: RAISE FND_API.G_EXC_ERROR;

1671: fnd_msg_pub.add;
1672:
1673:
1674: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1675: RAISE FND_API.G_EXC_ERROR;
1676: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1677: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1678: END IF;
1679:

Line 1676: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

1672:
1673:
1674: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1675: RAISE FND_API.G_EXC_ERROR;
1676: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1677: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1678: END IF;
1679:
1680: END IF;

Line 1677: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1673:
1674: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1675: RAISE FND_API.G_EXC_ERROR;
1676: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1677: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1678: END IF;
1679:
1680: END IF;
1681:

Line 1706: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

1702: p_group_id => l_group_id,
1703: p_resource_id => l_resource_id,
1704: x_return_status => x_return_status);
1705:
1706: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1707:
1708: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_INT_USR_HOOK');
1709: fnd_msg_pub.add;
1710:

Line 1712: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

1708: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_INT_USR_HOOK');
1709: fnd_msg_pub.add;
1710:
1711:
1712: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1713: RAISE FND_API.G_EXC_ERROR;
1714: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1715: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1716: END IF;

Line 1713: RAISE FND_API.G_EXC_ERROR;

1709: fnd_msg_pub.add;
1710:
1711:
1712: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1713: RAISE FND_API.G_EXC_ERROR;
1714: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1715: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1716: END IF;
1717:

Line 1714: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

1710:
1711:
1712: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1713: RAISE FND_API.G_EXC_ERROR;
1714: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1715: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1716: END IF;
1717:
1718: END IF;

Line 1715: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1711:
1712: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1713: RAISE FND_API.G_EXC_ERROR;
1714: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1715: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1716: END IF;
1717:
1718: END IF;
1719:

Line 1764: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

1760: p_bind_data_id => l_bind_data_id,
1761: x_return_code => x_return_status);
1762:
1763:
1764: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1765:
1766: -- dbms_output.put_line('Returned Error status from the Message Generation API');
1767:
1768: fnd_message.set_name('JTF', 'JTF_RS_ERR_MESG_GENERATE_API');

Line 1772: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

1768: fnd_message.set_name('JTF', 'JTF_RS_ERR_MESG_GENERATE_API');
1769: fnd_msg_pub.add;
1770:
1771:
1772: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1773: RAISE FND_API.G_EXC_ERROR;
1774: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1775: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1776: END IF;

Line 1773: RAISE FND_API.G_EXC_ERROR;

1769: fnd_msg_pub.add;
1770:
1771:
1772: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1773: RAISE FND_API.G_EXC_ERROR;
1774: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1775: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1776: END IF;
1777:

Line 1774: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

1770:
1771:
1772: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1773: RAISE FND_API.G_EXC_ERROR;
1774: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1775: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1776: END IF;
1777:
1778: END IF;

Line 1775: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1771:
1772: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1773: RAISE FND_API.G_EXC_ERROR;
1774: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1775: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1776: END IF;
1777:
1778: END IF;
1779:

Line 1786: IF fnd_api.to_boolean(p_commit) THEN

1782: END IF;
1783: END IF;
1784:
1785:
1786: IF fnd_api.to_boolean(p_commit) THEN
1787:
1788: COMMIT WORK;
1789:
1790: END IF;

Line 1797: WHEN fnd_api.g_exc_error THEN

1793:
1794:
1795: EXCEPTION
1796:
1797: WHEN fnd_api.g_exc_error THEN
1798: ROLLBACK TO delete_resource_member_pvt;
1799: x_return_status := fnd_api.g_ret_sts_error;
1800: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
1801: p_data => x_msg_data);

Line 1799: x_return_status := fnd_api.g_ret_sts_error;

1795: EXCEPTION
1796:
1797: WHEN fnd_api.g_exc_error THEN
1798: ROLLBACK TO delete_resource_member_pvt;
1799: x_return_status := fnd_api.g_ret_sts_error;
1800: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
1801: p_data => x_msg_data);
1802: WHEN fnd_api.g_exc_unexpected_error THEN
1803: ROLLBACK TO delete_resource_member_pvt;

Line 1802: WHEN fnd_api.g_exc_unexpected_error THEN

1798: ROLLBACK TO delete_resource_member_pvt;
1799: x_return_status := fnd_api.g_ret_sts_error;
1800: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
1801: p_data => x_msg_data);
1802: WHEN fnd_api.g_exc_unexpected_error THEN
1803: ROLLBACK TO delete_resource_member_pvt;
1804: x_return_status := fnd_api.g_ret_sts_unexp_error;
1805: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
1806: p_data => x_msg_data);

Line 1804: x_return_status := fnd_api.g_ret_sts_unexp_error;

1800: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
1801: p_data => x_msg_data);
1802: WHEN fnd_api.g_exc_unexpected_error THEN
1803: ROLLBACK TO delete_resource_member_pvt;
1804: x_return_status := fnd_api.g_ret_sts_unexp_error;
1805: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
1806: p_data => x_msg_data);
1807: WHEN OTHERS THEN
1808: ROLLBACK TO delete_resource_member_pvt;

Line 1814: x_return_status := fnd_api.g_ret_sts_unexp_error;

1810: fnd_message.set_token('P_SQLCODE',SQLCODE);
1811: fnd_message.set_token('P_SQLERRM',SQLERRM);
1812: fnd_message.set_token('P_API_NAME', l_api_name);
1813: FND_MSG_PUB.add;
1814: x_return_status := fnd_api.g_ret_sts_unexp_error;
1815: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
1816: p_data => x_msg_data);
1817:
1818: END delete_resource_group_members;