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;
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:
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
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;
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:
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:
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;
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:
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;
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');
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;
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:
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;
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:
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');
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;
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:
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;
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:
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;
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;
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:
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;
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:
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:
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:
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,
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,
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
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;
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:
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;
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:
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);
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;
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:
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;
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:
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;
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:
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:
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;
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:
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;
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:
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;
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;
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:
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;
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:
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;
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:
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;
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:
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;
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:
687: NULL;
688: END;
689:
690:
691: IF fnd_api.to_boolean(p_commit) THEN
692:
693: COMMIT WORK;
694:
695: END IF;
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);
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;
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);
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;
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;
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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
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
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;
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:
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;
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
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;
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;
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 */
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;
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:
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;
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;
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:
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;
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');
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:
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;
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:
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
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,
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,
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;
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
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;
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:
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;
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:
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;
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;
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:
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;
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');
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:
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;
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;
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:
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;
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;
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;
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 =============');
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:
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:
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;
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:
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;
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');
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;
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:
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:
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;
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');
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;
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:
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;
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:
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;
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;
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:
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;
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:
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:
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
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;
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;
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:
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:
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,
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
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:
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;
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:
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;
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:
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:
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:
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;
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:
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;
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:
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');
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;
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:
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;
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:
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:
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;
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:
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;
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:
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');
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;
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:
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;
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:
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;
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);
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;
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);
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;
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;