55:
56: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
57: IF FND_API.To_boolean(P_INIT_MSG_LIST)
58: THEN
59: FND_MSG_PUB.Initialize;
60: END IF;
61:
62: l_date := sysdate;
63: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
96: THEN
97: COMMIT WORK;
98: END IF;
99:
100: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
101:
102: EXCEPTION
103: WHEN fnd_api.g_exc_unexpected_error
104: THEN
103: WHEN fnd_api.g_exc_unexpected_error
104: THEN
105: ROLLBACK TO group_relate_audit;
106: fnd_message.set_name ('JTF', 'JTF_RS_GRP_RELATE_AUDIT_ERR');
107: FND_MSG_PUB.add;
108: x_return_status := fnd_api.g_ret_sts_unexp_error;
109: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
110: WHEN OTHERS
111: THEN
105: ROLLBACK TO group_relate_audit;
106: fnd_message.set_name ('JTF', 'JTF_RS_GRP_RELATE_AUDIT_ERR');
107: FND_MSG_PUB.add;
108: x_return_status := fnd_api.g_ret_sts_unexp_error;
109: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
110: WHEN OTHERS
111: THEN
112: ROLLBACK TO group_relate_audit;
113: fnd_message.set_name ('JTF', 'JTF_RS_GRP_RELATE_AUDIT_ERR');
110: WHEN OTHERS
111: THEN
112: ROLLBACK TO group_relate_audit;
113: fnd_message.set_name ('JTF', 'JTF_RS_GRP_RELATE_AUDIT_ERR');
114: FND_MSG_PUB.add;
115: x_return_status := fnd_api.g_ret_sts_unexp_error;
116: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
117:
118:
112: ROLLBACK TO group_relate_audit;
113: fnd_message.set_name ('JTF', 'JTF_RS_GRP_RELATE_AUDIT_ERR');
114: FND_MSG_PUB.add;
115: x_return_status := fnd_api.g_ret_sts_unexp_error;
116: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
117:
118:
119: END INSERT_GROUP_RELATE;
120:
200:
201: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
202: IF FND_API.To_boolean(P_INIT_MSG_LIST)
203: THEN
204: FND_MSG_PUB.Initialize;
205: END IF;
206:
207: l_date := sysdate;
208: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
286: THEN
287: COMMIT WORK;
288: END IF;
289:
290: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
291:
292:
293: EXCEPTION
294: WHEN fnd_api.g_exc_unexpected_error
294: WHEN fnd_api.g_exc_unexpected_error
295: THEN
296: ROLLBACK TO group_relate_audit;
297: fnd_message.set_name ('JTF', 'JTF_RS_GRP_RELATE_AUDIT_ERR');
298: FND_MSG_PUB.add;
299: x_return_status := fnd_api.g_ret_sts_unexp_error;
300: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
301: WHEN OTHERS
302: THEN
296: ROLLBACK TO group_relate_audit;
297: fnd_message.set_name ('JTF', 'JTF_RS_GRP_RELATE_AUDIT_ERR');
298: FND_MSG_PUB.add;
299: x_return_status := fnd_api.g_ret_sts_unexp_error;
300: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
301: WHEN OTHERS
302: THEN
303: ROLLBACK TO group_relate_audit;
304: fnd_message.set_name ('JTF', 'JTF_RS_GRP_RELATE_AUDIT_ERR');
301: WHEN OTHERS
302: THEN
303: ROLLBACK TO group_relate_audit;
304: fnd_message.set_name ('JTF', 'JTF_RS_GRP_RELATE_AUDIT_ERR');
305: FND_MSG_PUB.add;
306: x_return_status := fnd_api.g_ret_sts_unexp_error;
307: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
308:
309:
303: ROLLBACK TO group_relate_audit;
304: fnd_message.set_name ('JTF', 'JTF_RS_GRP_RELATE_AUDIT_ERR');
305: FND_MSG_PUB.add;
306: x_return_status := fnd_api.g_ret_sts_unexp_error;
307: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
308:
309:
310: END UPDATE_group_RELATE;
311:
373:
374: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
375: IF FND_API.To_boolean(P_INIT_MSG_LIST)
376: THEN
377: FND_MSG_PUB.Initialize;
378: END IF;
379:
380: l_date := sysdate;
381: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
432: THEN
433: COMMIT WORK;
434: END IF;
435:
436: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
437:
438: EXCEPTION
439: WHEN fnd_api.g_exc_unexpected_error
440: THEN
439: WHEN fnd_api.g_exc_unexpected_error
440: THEN
441: ROLLBACK TO group_relate_audit;
442: fnd_message.set_name ('JTF', 'JTF_RS_GRP_RELATE_AUDIT_ERR');
443: FND_MSG_PUB.add;
444: x_return_status := fnd_api.g_ret_sts_unexp_error;
445: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
446: WHEN OTHERS
447: THEN
441: ROLLBACK TO group_relate_audit;
442: fnd_message.set_name ('JTF', 'JTF_RS_GRP_RELATE_AUDIT_ERR');
443: FND_MSG_PUB.add;
444: x_return_status := fnd_api.g_ret_sts_unexp_error;
445: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
446: WHEN OTHERS
447: THEN
448: ROLLBACK TO group_relate_audit;
449: fnd_message.set_name ('JTF', 'JTF_RS_GRP_RELATE_AUDIT_ERR');
446: WHEN OTHERS
447: THEN
448: ROLLBACK TO group_relate_audit;
449: fnd_message.set_name ('JTF', 'JTF_RS_GRP_RELATE_AUDIT_ERR');
450: FND_MSG_PUB.add;
451: x_return_status := fnd_api.g_ret_sts_unexp_error;
452: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
453:
454:
448: ROLLBACK TO group_relate_audit;
449: fnd_message.set_name ('JTF', 'JTF_RS_GRP_RELATE_AUDIT_ERR');
450: FND_MSG_PUB.add;
451: x_return_status := fnd_api.g_ret_sts_unexp_error;
452: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
453:
454:
455: END DELETE_group_RELATE;
456: