DBA Data[Home] [Help]

APPS.JTF_RS_GROUPS_AUD_PVT dependencies on FND_API

Line 50: x_return_status := fnd_api.g_ret_sts_success;

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

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

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:

Line 55: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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)

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

Line 107: IF fnd_api.to_boolean (p_commit)

103: );
104:
105:
106:
107: IF fnd_api.to_boolean (p_commit)
108: THEN
109: COMMIT WORK;
110: END IF;
111:

Line 116: WHEN fnd_api.g_exc_unexpected_error

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;

Line 121: x_return_status := fnd_api.g_ret_sts_unexp_error;

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;

Line 128: x_return_status := fnd_api.g_ret_sts_unexp_error;

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:

Line 218: x_return_status := fnd_api.g_ret_sts_success;

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

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

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:

Line 223: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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)

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

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

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)

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

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

Line 333: IF fnd_api.to_boolean (p_commit)

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:

Line 342: WHEN fnd_api.g_exc_unexpected_error

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;

Line 347: x_return_status := fnd_api.g_ret_sts_unexp_error;

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;

Line 354: x_return_status := fnd_api.g_ret_sts_unexp_error;

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:

Line 416: x_return_status := fnd_api.g_ret_sts_success;

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

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

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:

Line 421: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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)

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

Line 490: IF fnd_api.to_boolean (p_commit)

486:
487:
488:
489:
490: IF fnd_api.to_boolean (p_commit)
491: THEN
492: COMMIT WORK;
493: END IF;
494:

Line 499: WHEN fnd_api.g_exc_unexpected_error

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;

Line 504: x_return_status := fnd_api.g_ret_sts_unexp_error;

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;

Line 511: x_return_status := fnd_api.g_ret_sts_unexp_error;

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