56:
57: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
58: IF FND_API.To_boolean(P_INIT_MSG_LIST)
59: THEN
60: FND_MSG_PUB.Initialize;
61: END IF;
62:
63: l_date := sysdate;
64: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
105: THEN
106: COMMIT WORK;
107: END IF;
108:
109: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
110:
111:
112: EXCEPTION
113: WHEN fnd_api.g_exc_unexpected_error
113: WHEN fnd_api.g_exc_unexpected_error
114: THEN
115: ROLLBACK TO group_audit;
116: fnd_message.set_name ('JTF', 'JTF_RS_GROUP_AUDIT_ERR');
117: FND_MSG_PUB.add;
118: x_return_status := fnd_api.g_ret_sts_unexp_error;
119: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
120: WHEN OTHERS
121: THEN
115: ROLLBACK TO group_audit;
116: fnd_message.set_name ('JTF', 'JTF_RS_GROUP_AUDIT_ERR');
117: FND_MSG_PUB.add;
118: x_return_status := fnd_api.g_ret_sts_unexp_error;
119: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
120: WHEN OTHERS
121: THEN
122: ROLLBACK TO group_audit;
123: fnd_message.set_name ('JTF', 'JTF_RS_GROUP_AUDIT_ERR');
120: WHEN OTHERS
121: THEN
122: ROLLBACK TO group_audit;
123: fnd_message.set_name ('JTF', 'JTF_RS_GROUP_AUDIT_ERR');
124: FND_MSG_PUB.add;
125: x_return_status := fnd_api.g_ret_sts_unexp_error;
126: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
127:
128: END INSERT_GROUP;
122: ROLLBACK TO group_audit;
123: fnd_message.set_name ('JTF', 'JTF_RS_GROUP_AUDIT_ERR');
124: FND_MSG_PUB.add;
125: x_return_status := fnd_api.g_ret_sts_unexp_error;
126: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
127:
128: END INSERT_GROUP;
129:
130: /* FOR UPDATE */
219:
220: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
221: IF FND_API.To_boolean(P_INIT_MSG_LIST)
222: THEN
223: FND_MSG_PUB.Initialize;
224: END IF;
225:
226: l_date := sysdate;
227: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
321: THEN
322: COMMIT WORK;
323: END IF;
324:
325: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
326:
327:
328: EXCEPTION
329: WHEN fnd_api.g_exc_unexpected_error
329: WHEN fnd_api.g_exc_unexpected_error
330: THEN
331: ROLLBACK TO group_audit;
332: fnd_message.set_name ('JTF', 'JTF_RS_GROUP_AUDIT_ERR');
333: FND_MSG_PUB.add;
334: x_return_status := fnd_api.g_ret_sts_unexp_error;
335: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
336: WHEN OTHERS
337: THEN
331: ROLLBACK TO group_audit;
332: fnd_message.set_name ('JTF', 'JTF_RS_GROUP_AUDIT_ERR');
333: FND_MSG_PUB.add;
334: x_return_status := fnd_api.g_ret_sts_unexp_error;
335: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
336: WHEN OTHERS
337: THEN
338: ROLLBACK TO group_audit;
339: fnd_message.set_name ('JTF', 'JTF_RS_GROUP_AUDIT_ERR');
336: WHEN OTHERS
337: THEN
338: ROLLBACK TO group_audit;
339: fnd_message.set_name ('JTF', 'JTF_RS_GROUP_AUDIT_ERR');
340: FND_MSG_PUB.add;
341: x_return_status := fnd_api.g_ret_sts_unexp_error;
342: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
343:
344: END UPDATE_GROUP;
338: ROLLBACK TO group_audit;
339: fnd_message.set_name ('JTF', 'JTF_RS_GROUP_AUDIT_ERR');
340: FND_MSG_PUB.add;
341: x_return_status := fnd_api.g_ret_sts_unexp_error;
342: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
343:
344: END UPDATE_GROUP;
345:
346:
408:
409: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
410: IF FND_API.To_boolean(P_INIT_MSG_LIST)
411: THEN
412: FND_MSG_PUB.Initialize;
413: END IF;
414:
415: l_date := sysdate;
416: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
473: THEN
474: COMMIT WORK;
475: END IF;
476:
477: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
478:
479:
480: EXCEPTION
481: WHEN fnd_api.g_exc_unexpected_error
481: WHEN fnd_api.g_exc_unexpected_error
482: THEN
483: ROLLBACK TO group_audit;
484: fnd_message.set_name ('JTF', 'JTF_RS_GROUP_AUDIT_ERR');
485: FND_MSG_PUB.add;
486: x_return_status := fnd_api.g_ret_sts_unexp_error;
487: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
488: WHEN OTHERS
489: THEN
483: ROLLBACK TO group_audit;
484: fnd_message.set_name ('JTF', 'JTF_RS_GROUP_AUDIT_ERR');
485: FND_MSG_PUB.add;
486: x_return_status := fnd_api.g_ret_sts_unexp_error;
487: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
488: WHEN OTHERS
489: THEN
490: ROLLBACK TO group_audit;
491: fnd_message.set_name ('JTF', 'JTF_RS_GROUP_AUDIT_ERR');
488: WHEN OTHERS
489: THEN
490: ROLLBACK TO group_audit;
491: fnd_message.set_name ('JTF', 'JTF_RS_GROUP_AUDIT_ERR');
492: FND_MSG_PUB.add;
493: x_return_status := fnd_api.g_ret_sts_unexp_error;
494: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
495: END DELETE_GROUP;
496: END; -- Package Body JTF_RS_GROUPS_AUD_PVT
490: ROLLBACK TO group_audit;
491: fnd_message.set_name ('JTF', 'JTF_RS_GROUP_AUDIT_ERR');
492: FND_MSG_PUB.add;
493: x_return_status := fnd_api.g_ret_sts_unexp_error;
494: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
495: END DELETE_GROUP;
496: END; -- Package Body JTF_RS_GROUPS_AUD_PVT