44:
45: --Standard Start of API SAVEPOINT
46: SAVEPOINT GROUP_RELATE_AUDIT;
47:
48: x_return_status := fnd_api.g_ret_sts_success;
49:
50: --Standard Call to check API compatibility
51: IF NOT FND_API.Compatible_API_CALL(l_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
52: THEN
47:
48: x_return_status := fnd_api.g_ret_sts_success;
49:
50: --Standard Call to check API compatibility
51: IF NOT FND_API.Compatible_API_CALL(l_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
52: THEN
53: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
54: END IF;
55:
49:
50: --Standard Call to check API compatibility
51: IF NOT FND_API.Compatible_API_CALL(l_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
52: THEN
53: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
54: END IF;
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)
53: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
54: END IF;
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:
91: X_LAST_UPDATED_BY => l_user_id,
92: X_LAST_UPDATE_LOGIN => l_login_id
93: );
94:
95: IF fnd_api.to_boolean (p_commit)
96: THEN
97: COMMIT WORK;
98: END IF;
99:
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
105: ROLLBACK TO group_relate_audit;
106: fnd_message.set_name ('JTF', 'JTF_RS_GRP_RELATE_AUDIT_ERR');
107: FND_MSG_PUB.add;
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
112: ROLLBACK TO group_relate_audit;
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:
119: END INSERT_GROUP_RELATE;
189:
190: --Standard Start of API SAVEPOINT
191: SAVEPOINT group_RELATE_AUDIT;
192:
193: x_return_status := fnd_api.g_ret_sts_success;
194:
195: --Standard Call to check API compatibility
196: IF NOT FND_API.Compatible_API_CALL(l_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
197: THEN
192:
193: x_return_status := fnd_api.g_ret_sts_success;
194:
195: --Standard Call to check API compatibility
196: IF NOT FND_API.Compatible_API_CALL(l_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
197: THEN
198: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
199: END IF;
200:
194:
195: --Standard Call to check API compatibility
196: IF NOT FND_API.Compatible_API_CALL(l_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
197: THEN
198: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
199: END IF;
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)
198: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
199: END IF;
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:
233: l_start_date_active := rr_old_rec.start_date_active;
234: l_start_date_active_n := p_start_date_active;
235: end if;
236: if (p_end_date_active <> rr_old_rec.end_date_active) OR
237: /* (p_end_date_active is null AND rr_old_rec.end_date_active <> FND_API.G_MISS_DATE) OR
238: (p_end_date_active is not null AND rr_old_rec.end_date_active = FND_API.G_MISS_DATE) */
239: /* Modified the above date validation to fix bug # 2760129 */
240: (p_end_date_active is null AND rr_old_rec.end_date_active is NOT NULL) OR
241: (p_end_date_active is not null AND rr_old_rec.end_date_active is NULL)
234: l_start_date_active_n := p_start_date_active;
235: end if;
236: if (p_end_date_active <> rr_old_rec.end_date_active) OR
237: /* (p_end_date_active is null AND rr_old_rec.end_date_active <> FND_API.G_MISS_DATE) OR
238: (p_end_date_active is not null AND rr_old_rec.end_date_active = FND_API.G_MISS_DATE) */
239: /* Modified the above date validation to fix bug # 2760129 */
240: (p_end_date_active is null AND rr_old_rec.end_date_active is NOT NULL) OR
241: (p_end_date_active is not null AND rr_old_rec.end_date_active is NULL)
242:
281:
282:
283:
284:
285: IF fnd_api.to_boolean (p_commit)
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
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;
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
303: ROLLBACK TO group_relate_audit;
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:
310: END UPDATE_group_RELATE;
362:
363: --Standard Start of API SAVEPOINT
364: SAVEPOINT group_RELATE_AUDIT;
365:
366: x_return_status := fnd_api.g_ret_sts_success;
367:
368: --Standard Call to check API compatibility
369: IF NOT FND_API.Compatible_API_CALL(l_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
370: THEN
365:
366: x_return_status := fnd_api.g_ret_sts_success;
367:
368: --Standard Call to check API compatibility
369: IF NOT FND_API.Compatible_API_CALL(l_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
370: THEN
371: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
372: END IF;
373:
367:
368: --Standard Call to check API compatibility
369: IF NOT FND_API.Compatible_API_CALL(l_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
370: THEN
371: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
372: END IF;
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)
371: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
372: END IF;
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:
427:
428:
429:
430:
431: IF fnd_api.to_boolean (p_commit)
432: THEN
433: COMMIT WORK;
434: END IF;
435:
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
441: ROLLBACK TO group_relate_audit;
442: fnd_message.set_name ('JTF', 'JTF_RS_GRP_RELATE_AUDIT_ERR');
443: FND_MSG_PUB.add;
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
448: ROLLBACK TO group_relate_audit;
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:
455: END DELETE_group_RELATE;