46:
47: --Standard Start of API SAVEPOINT
48: SAVEPOINT GROUP_AUDIT;
49:
50: x_return_status := fnd_api.g_ret_sts_success;
51:
52: --Standard Call to check API compatibility
53: IF NOT FND_API.Compatible_API_CALL(l_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
54: THEN
49:
50: x_return_status := fnd_api.g_ret_sts_success;
51:
52: --Standard Call to check API compatibility
53: IF NOT FND_API.Compatible_API_CALL(l_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
54: THEN
55: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
56: END IF;
57:
51:
52: --Standard Call to check API compatibility
53: IF NOT FND_API.Compatible_API_CALL(l_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
54: THEN
55: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
56: END IF;
57:
58: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
59: IF FND_API.To_boolean(P_INIT_MSG_LIST)
55: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
56: END IF;
57:
58: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
59: IF FND_API.To_boolean(P_INIT_MSG_LIST)
60: THEN
61: FND_MSG_PUB.Initialize;
62: END IF;
63:
103: );
104:
105:
106:
107: IF fnd_api.to_boolean (p_commit)
108: THEN
109: COMMIT WORK;
110: END IF;
111:
112: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
113:
114:
115: EXCEPTION
116: WHEN fnd_api.g_exc_unexpected_error
117: THEN
118: ROLLBACK TO group_audit;
119: fnd_message.set_name ('JTF', 'JTF_RS_GROUP_AUDIT_ERR');
120: FND_MSG_PUB.add;
117: THEN
118: ROLLBACK TO group_audit;
119: fnd_message.set_name ('JTF', 'JTF_RS_GROUP_AUDIT_ERR');
120: FND_MSG_PUB.add;
121: x_return_status := fnd_api.g_ret_sts_unexp_error;
122: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
123: WHEN OTHERS
124: THEN
125: ROLLBACK TO group_audit;
124: THEN
125: ROLLBACK TO group_audit;
126: fnd_message.set_name ('JTF', 'JTF_RS_GROUP_AUDIT_ERR');
127: FND_MSG_PUB.add;
128: x_return_status := fnd_api.g_ret_sts_unexp_error;
129: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
130:
131: END INSERT_GROUP;
132:
214:
215: --Standard Start of API SAVEPOINT
216: SAVEPOINT GROUP_AUDIT;
217:
218: x_return_status := fnd_api.g_ret_sts_success;
219:
220: --Standard Call to check API compatibility
221: IF NOT FND_API.Compatible_API_CALL(l_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
222: THEN
217:
218: x_return_status := fnd_api.g_ret_sts_success;
219:
220: --Standard Call to check API compatibility
221: IF NOT FND_API.Compatible_API_CALL(l_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
222: THEN
223: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
224: END IF;
225:
219:
220: --Standard Call to check API compatibility
221: IF NOT FND_API.Compatible_API_CALL(l_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
222: THEN
223: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
224: END IF;
225:
226: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
227: IF FND_API.To_boolean(P_INIT_MSG_LIST)
223: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
224: END IF;
225:
226: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
227: IF FND_API.To_boolean(P_INIT_MSG_LIST)
228: THEN
229: FND_MSG_PUB.Initialize;
230: END IF;
231:
248: l_start_date_active := rr_old_rec.start_date_active;
249: l_start_date_active_n := p_start_date_active;
250: end if;
251: if (p_end_date_active <> rr_old_rec.end_date_active) OR
252: /* (p_end_date_active is null AND rr_old_rec.end_date_active <> FND_API.G_MISS_DATE) OR
253: (p_end_date_active is not null AND rr_old_rec.end_date_active = FND_API.G_MISS_DATE) */
254: /* Modified the above date validation to fix bug # 2760129 */
255: (p_end_date_active is null AND rr_old_rec.end_date_active is NOT NULL) OR
256: (p_end_date_active is not null AND rr_old_rec.end_date_active is NULL)
249: l_start_date_active_n := p_start_date_active;
250: end if;
251: if (p_end_date_active <> rr_old_rec.end_date_active) OR
252: /* (p_end_date_active is null AND rr_old_rec.end_date_active <> FND_API.G_MISS_DATE) OR
253: (p_end_date_active is not null AND rr_old_rec.end_date_active = FND_API.G_MISS_DATE) */
254: /* Modified the above date validation to fix bug # 2760129 */
255: (p_end_date_active is null AND rr_old_rec.end_date_active is NOT NULL) OR
256: (p_end_date_active is not null AND rr_old_rec.end_date_active is NULL)
257: then
329: x_new_time_zone => l_time_zone_n,
330: x_old_time_zone => l_time_zone
331: );
332:
333: IF fnd_api.to_boolean (p_commit)
334: THEN
335: COMMIT WORK;
336: END IF;
337:
338: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
339:
340:
341: EXCEPTION
342: WHEN fnd_api.g_exc_unexpected_error
343: THEN
344: ROLLBACK TO group_audit;
345: fnd_message.set_name ('JTF', 'JTF_RS_GROUP_AUDIT_ERR');
346: FND_MSG_PUB.add;
343: THEN
344: ROLLBACK TO group_audit;
345: fnd_message.set_name ('JTF', 'JTF_RS_GROUP_AUDIT_ERR');
346: FND_MSG_PUB.add;
347: x_return_status := fnd_api.g_ret_sts_unexp_error;
348: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
349: WHEN OTHERS
350: THEN
351: ROLLBACK TO group_audit;
350: THEN
351: ROLLBACK TO group_audit;
352: fnd_message.set_name ('JTF', 'JTF_RS_GROUP_AUDIT_ERR');
353: FND_MSG_PUB.add;
354: x_return_status := fnd_api.g_ret_sts_unexp_error;
355: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
356:
357: END UPDATE_GROUP;
358:
412:
413: --Standard Start of API SAVEPOINT
414: SAVEPOINT GROUP_AUDIT;
415:
416: x_return_status := fnd_api.g_ret_sts_success;
417:
418: --Standard Call to check API compatibility
419: IF NOT FND_API.Compatible_API_CALL(l_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
420: THEN
415:
416: x_return_status := fnd_api.g_ret_sts_success;
417:
418: --Standard Call to check API compatibility
419: IF NOT FND_API.Compatible_API_CALL(l_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
420: THEN
421: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
422: END IF;
423:
417:
418: --Standard Call to check API compatibility
419: IF NOT FND_API.Compatible_API_CALL(l_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
420: THEN
421: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
422: END IF;
423:
424: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
425: IF FND_API.To_boolean(P_INIT_MSG_LIST)
421: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
422: END IF;
423:
424: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
425: IF FND_API.To_boolean(P_INIT_MSG_LIST)
426: THEN
427: FND_MSG_PUB.Initialize;
428: END IF;
429:
486:
487:
488:
489:
490: IF fnd_api.to_boolean (p_commit)
491: THEN
492: COMMIT WORK;
493: END IF;
494:
495: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
496:
497:
498: EXCEPTION
499: WHEN fnd_api.g_exc_unexpected_error
500: THEN
501: ROLLBACK TO group_audit;
502: fnd_message.set_name ('JTF', 'JTF_RS_GROUP_AUDIT_ERR');
503: FND_MSG_PUB.add;
500: THEN
501: ROLLBACK TO group_audit;
502: fnd_message.set_name ('JTF', 'JTF_RS_GROUP_AUDIT_ERR');
503: FND_MSG_PUB.add;
504: x_return_status := fnd_api.g_ret_sts_unexp_error;
505: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
506: WHEN OTHERS
507: THEN
508: ROLLBACK TO group_audit;
507: THEN
508: ROLLBACK TO group_audit;
509: fnd_message.set_name ('JTF', 'JTF_RS_GROUP_AUDIT_ERR');
510: FND_MSG_PUB.add;
511: x_return_status := fnd_api.g_ret_sts_unexp_error;
512: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
513: END DELETE_GROUP;
514: END; -- Package Body JTF_RS_GROUPS_AUD_PVT