DBA Data[Home] [Help]

APPS.JTF_RS_GROUPS_AUD_PVT dependencies on FND_API

Line 49: x_return_status := fnd_api.g_ret_sts_success;

45:
46: --Standard Start of API SAVEPOINT
47: SAVEPOINT GROUP_AUDIT;
48:
49: x_return_status := fnd_api.g_ret_sts_success;
50:
51: --Standard Call to check API compatibility
52: IF NOT FND_API.Compatible_API_CALL(l_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
53: THEN

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

48:
49: x_return_status := fnd_api.g_ret_sts_success;
50:
51: --Standard Call to check API compatibility
52: IF NOT FND_API.Compatible_API_CALL(l_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
53: THEN
54: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
55: END IF;
56:

Line 54: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

50:
51: --Standard Call to check API compatibility
52: IF NOT FND_API.Compatible_API_CALL(l_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
53: THEN
54: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
55: END IF;
56:
57: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
58: IF FND_API.To_boolean(P_INIT_MSG_LIST)

Line 58: IF FND_API.To_boolean(P_INIT_MSG_LIST)

54: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
55: END IF;
56:
57: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
58: IF FND_API.To_boolean(P_INIT_MSG_LIST)
59: THEN
60: FND_MSG_PUB.Initialize;
61: END IF;
62:

Line 104: IF fnd_api.to_boolean (p_commit)

100: );
101:
102:
103:
104: IF fnd_api.to_boolean (p_commit)
105: THEN
106: COMMIT WORK;
107: END IF;
108:

Line 113: WHEN fnd_api.g_exc_unexpected_error

109: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
110:
111:
112: EXCEPTION
113: WHEN fnd_api.g_exc_unexpected_error
114: THEN
115: ROLLBACK TO group_audit;
116: fnd_message.set_name ('JTF', 'JTF_RS_GROUP_AUDIT_ERR');
117: FND_MSG_PUB.add;

Line 118: x_return_status := fnd_api.g_ret_sts_unexp_error;

114: THEN
115: ROLLBACK TO group_audit;
116: fnd_message.set_name ('JTF', 'JTF_RS_GROUP_AUDIT_ERR');
117: FND_MSG_PUB.add;
118: x_return_status := fnd_api.g_ret_sts_unexp_error;
119: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
120: WHEN OTHERS
121: THEN
122: ROLLBACK TO group_audit;

Line 125: x_return_status := fnd_api.g_ret_sts_unexp_error;

121: THEN
122: ROLLBACK TO group_audit;
123: fnd_message.set_name ('JTF', 'JTF_RS_GROUP_AUDIT_ERR');
124: FND_MSG_PUB.add;
125: x_return_status := fnd_api.g_ret_sts_unexp_error;
126: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
127:
128: END INSERT_GROUP;
129:

Line 212: x_return_status := fnd_api.g_ret_sts_success;

208:
209: --Standard Start of API SAVEPOINT
210: SAVEPOINT GROUP_AUDIT;
211:
212: x_return_status := fnd_api.g_ret_sts_success;
213:
214: --Standard Call to check API compatibility
215: IF NOT FND_API.Compatible_API_CALL(l_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
216: THEN

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

211:
212: x_return_status := fnd_api.g_ret_sts_success;
213:
214: --Standard Call to check API compatibility
215: IF NOT FND_API.Compatible_API_CALL(l_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
216: THEN
217: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
218: END IF;
219:

Line 217: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

213:
214: --Standard Call to check API compatibility
215: IF NOT FND_API.Compatible_API_CALL(l_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
216: THEN
217: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
218: END IF;
219:
220: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
221: IF FND_API.To_boolean(P_INIT_MSG_LIST)

Line 221: IF FND_API.To_boolean(P_INIT_MSG_LIST)

217: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
218: END IF;
219:
220: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
221: IF FND_API.To_boolean(P_INIT_MSG_LIST)
222: THEN
223: FND_MSG_PUB.Initialize;
224: END IF;
225:

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

242: l_start_date_active := rr_old_rec.start_date_active;
243: l_start_date_active_n := p_start_date_active;
244: end if;
245: if (p_end_date_active <> rr_old_rec.end_date_active) OR
246: /* (p_end_date_active is null AND rr_old_rec.end_date_active <> FND_API.G_MISS_DATE) OR
247: (p_end_date_active is not null AND rr_old_rec.end_date_active = FND_API.G_MISS_DATE) */
248: /* Modified the above date validation to fix bug # 2760129 */
249: (p_end_date_active is null AND rr_old_rec.end_date_active is NOT NULL) OR
250: (p_end_date_active is not null AND rr_old_rec.end_date_active is NULL)

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

243: l_start_date_active_n := p_start_date_active;
244: end if;
245: if (p_end_date_active <> rr_old_rec.end_date_active) OR
246: /* (p_end_date_active is null AND rr_old_rec.end_date_active <> FND_API.G_MISS_DATE) OR
247: (p_end_date_active is not null AND rr_old_rec.end_date_active = FND_API.G_MISS_DATE) */
248: /* Modified the above date validation to fix bug # 2760129 */
249: (p_end_date_active is null AND rr_old_rec.end_date_active is NOT NULL) OR
250: (p_end_date_active is not null AND rr_old_rec.end_date_active is NULL)
251: then

Line 320: IF fnd_api.to_boolean (p_commit)

316: x_last_updated_by => l_user_id,
317: x_last_update_login => l_login_id
318: );
319:
320: IF fnd_api.to_boolean (p_commit)
321: THEN
322: COMMIT WORK;
323: END IF;
324:

Line 329: WHEN fnd_api.g_exc_unexpected_error

325: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
326:
327:
328: EXCEPTION
329: WHEN fnd_api.g_exc_unexpected_error
330: THEN
331: ROLLBACK TO group_audit;
332: fnd_message.set_name ('JTF', 'JTF_RS_GROUP_AUDIT_ERR');
333: FND_MSG_PUB.add;

Line 334: x_return_status := fnd_api.g_ret_sts_unexp_error;

330: THEN
331: ROLLBACK TO group_audit;
332: fnd_message.set_name ('JTF', 'JTF_RS_GROUP_AUDIT_ERR');
333: FND_MSG_PUB.add;
334: x_return_status := fnd_api.g_ret_sts_unexp_error;
335: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
336: WHEN OTHERS
337: THEN
338: ROLLBACK TO group_audit;

Line 341: x_return_status := fnd_api.g_ret_sts_unexp_error;

337: THEN
338: ROLLBACK TO group_audit;
339: fnd_message.set_name ('JTF', 'JTF_RS_GROUP_AUDIT_ERR');
340: FND_MSG_PUB.add;
341: x_return_status := fnd_api.g_ret_sts_unexp_error;
342: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
343:
344: END UPDATE_GROUP;
345:

Line 401: x_return_status := fnd_api.g_ret_sts_success;

397:
398: --Standard Start of API SAVEPOINT
399: SAVEPOINT GROUP_AUDIT;
400:
401: x_return_status := fnd_api.g_ret_sts_success;
402:
403: --Standard Call to check API compatibility
404: IF NOT FND_API.Compatible_API_CALL(l_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
405: THEN

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

400:
401: x_return_status := fnd_api.g_ret_sts_success;
402:
403: --Standard Call to check API compatibility
404: IF NOT FND_API.Compatible_API_CALL(l_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
405: THEN
406: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
407: END IF;
408:

Line 406: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

402:
403: --Standard Call to check API compatibility
404: IF NOT FND_API.Compatible_API_CALL(l_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
405: THEN
406: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
407: END IF;
408:
409: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
410: IF FND_API.To_boolean(P_INIT_MSG_LIST)

Line 410: IF FND_API.To_boolean(P_INIT_MSG_LIST)

406: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
407: END IF;
408:
409: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
410: IF FND_API.To_boolean(P_INIT_MSG_LIST)
411: THEN
412: FND_MSG_PUB.Initialize;
413: END IF;
414:

Line 472: IF fnd_api.to_boolean (p_commit)

468:
469:
470:
471:
472: IF fnd_api.to_boolean (p_commit)
473: THEN
474: COMMIT WORK;
475: END IF;
476:

Line 481: WHEN fnd_api.g_exc_unexpected_error

477: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
478:
479:
480: EXCEPTION
481: WHEN fnd_api.g_exc_unexpected_error
482: THEN
483: ROLLBACK TO group_audit;
484: fnd_message.set_name ('JTF', 'JTF_RS_GROUP_AUDIT_ERR');
485: FND_MSG_PUB.add;

Line 486: x_return_status := fnd_api.g_ret_sts_unexp_error;

482: THEN
483: ROLLBACK TO group_audit;
484: fnd_message.set_name ('JTF', 'JTF_RS_GROUP_AUDIT_ERR');
485: FND_MSG_PUB.add;
486: x_return_status := fnd_api.g_ret_sts_unexp_error;
487: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
488: WHEN OTHERS
489: THEN
490: ROLLBACK TO group_audit;

Line 493: x_return_status := fnd_api.g_ret_sts_unexp_error;

489: THEN
490: ROLLBACK TO group_audit;
491: fnd_message.set_name ('JTF', 'JTF_RS_GROUP_AUDIT_ERR');
492: FND_MSG_PUB.add;
493: x_return_status := fnd_api.g_ret_sts_unexp_error;
494: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
495: END DELETE_GROUP;
496: END; -- Package Body JTF_RS_GROUPS_AUD_PVT