DBA Data[Home] [Help]

APPS.JTF_RS_GROUP_RELATE_AUD_PVT dependencies on FND_API

Line 48: x_return_status := fnd_api.g_ret_sts_success;

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

Line 51: IF NOT FND_API.Compatible_API_CALL(l_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)

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:

Line 53: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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)

Line 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:

Line 95: IF fnd_api.to_boolean (p_commit)

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:

Line 103: WHEN fnd_api.g_exc_unexpected_error

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;

Line 108: x_return_status := fnd_api.g_ret_sts_unexp_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
112: ROLLBACK TO group_relate_audit;

Line 115: x_return_status := fnd_api.g_ret_sts_unexp_error;

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;

Line 193: x_return_status := fnd_api.g_ret_sts_success;

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

Line 196: IF NOT FND_API.Compatible_API_CALL(l_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)

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:

Line 198: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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)

Line 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:

Line 237: /* (p_end_date_active is null AND rr_old_rec.end_date_active <> FND_API.G_MISS_DATE) OR

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)

Line 238: (p_end_date_active is not null AND rr_old_rec.end_date_active = FND_API.G_MISS_DATE) */

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:

Line 285: IF fnd_api.to_boolean (p_commit)

281:
282:
283:
284:
285: IF fnd_api.to_boolean (p_commit)
286: THEN
287: COMMIT WORK;
288: END IF;
289:

Line 294: WHEN fnd_api.g_exc_unexpected_error

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;

Line 299: x_return_status := fnd_api.g_ret_sts_unexp_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
303: ROLLBACK TO group_relate_audit;

Line 306: x_return_status := fnd_api.g_ret_sts_unexp_error;

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;

Line 366: x_return_status := fnd_api.g_ret_sts_success;

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

Line 369: IF NOT FND_API.Compatible_API_CALL(l_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)

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:

Line 371: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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)

Line 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:

Line 431: IF fnd_api.to_boolean (p_commit)

427:
428:
429:
430:
431: IF fnd_api.to_boolean (p_commit)
432: THEN
433: COMMIT WORK;
434: END IF;
435:

Line 439: WHEN fnd_api.g_exc_unexpected_error

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;

Line 444: x_return_status := fnd_api.g_ret_sts_unexp_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
448: ROLLBACK TO group_relate_audit;

Line 451: x_return_status := fnd_api.g_ret_sts_unexp_error;

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;