100: WHEN fnd_api.g_exc_unexpected_error
101: THEN
102: ROLLBACK TO group_audit;
103: x_return_status := fnd_api.g_ret_sts_unexp_error;
104: fnd_message.set_name ('JTF', 'JTF_RS_GROUP_MEM_AUD_ERR');
105: FND_MSG_PUB.add;
106: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
107: WHEN OTHERS
108: THEN
107: WHEN OTHERS
108: THEN
109: ROLLBACK TO group_audit;
110: x_return_status := fnd_api.g_ret_sts_unexp_error;
111: fnd_message.set_name ('JTF', 'JTF_RS_GROUP_MEM_AUD_ERR');
112: FND_MSG_PUB.add;
113: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
114:
115: END INSERT_MEMBER;
256: WHEN fnd_api.g_exc_unexpected_error
257: THEN
258: ROLLBACK TO group_audit;
259: x_return_status := fnd_api.g_ret_sts_unexp_error;
260: fnd_message.set_name ('JTF', 'JTF_RS_GROUP_MEM_AUD_ERR');
261: FND_MSG_PUB.add;
262: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
263: WHEN OTHERS
264: THEN
263: WHEN OTHERS
264: THEN
265: ROLLBACK TO group_audit;
266: x_return_status := fnd_api.g_ret_sts_unexp_error;
267: fnd_message.set_name ('JTF', 'JTF_RS_GROUP_MEM_AUD_ERR');
268: FND_MSG_PUB.add;
269: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
270:
271: END UPDATE_MEMBER;
388: WHEN fnd_api.g_exc_unexpected_error
389: THEN
390: ROLLBACK TO group_audit;
391: x_return_status := fnd_api.g_ret_sts_unexp_error;
392: fnd_message.set_name ('JTF', 'JTF_RS_GROUP_MEM_AUD_ERR');
393: FND_MSG_PUB.add;
394: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
395: WHEN OTHERS
396: THEN
395: WHEN OTHERS
396: THEN
397: ROLLBACK TO group_audit;
398: x_return_status := fnd_api.g_ret_sts_unexp_error;
399: fnd_message.set_name ('JTF', 'JTF_RS_GROUP_MEM_AUD_ERR');
400: FND_MSG_PUB.add;
401: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
402:
403: END delete_member;