DBA Data[Home] [Help]

APPS.JTF_RS_GROUP_MEMBERS_AUD_PVT dependencies on FND_API

Line 45: x_return_status := fnd_api.g_ret_sts_success;

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

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

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

Line 50: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 54: IF FND_API.To_boolean(P_INIT_MSG_LIST)

50: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
51: END IF;
52:
53: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
54: IF FND_API.To_boolean(P_INIT_MSG_LIST)
55: THEN
56: FND_MSG_PUB.Initialize;
57: END IF;
58:

Line 91: IF fnd_api.to_boolean (p_commit)

87: X_LAST_UPDATE_LOGIN => l_login_id
88: );
89:
90:
91: IF fnd_api.to_boolean (p_commit)
92: THEN
93: COMMIT WORK;
94: END IF;
95:

Line 100: WHEN fnd_api.g_exc_unexpected_error

96: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
97:
98:
99: EXCEPTION
100: WHEN fnd_api.g_exc_unexpected_error
101: THEN
102: ROLLBACK TO group_audit;
103: x_return_status := fnd_api.g_ret_sts_unexp_error;
104: fnd_message.set_name ('JTF', 'JTF_RS_GROUP_MEM_AUD_ERR');

Line 103: x_return_status := fnd_api.g_ret_sts_unexp_error;

99: EXCEPTION
100: WHEN fnd_api.g_exc_unexpected_error
101: THEN
102: ROLLBACK TO group_audit;
103: x_return_status := fnd_api.g_ret_sts_unexp_error;
104: fnd_message.set_name ('JTF', 'JTF_RS_GROUP_MEM_AUD_ERR');
105: FND_MSG_PUB.add;
106: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
107: WHEN OTHERS

Line 110: x_return_status := fnd_api.g_ret_sts_unexp_error;

106: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
107: WHEN OTHERS
108: THEN
109: ROLLBACK TO group_audit;
110: x_return_status := fnd_api.g_ret_sts_unexp_error;
111: fnd_message.set_name ('JTF', 'JTF_RS_GROUP_MEM_AUD_ERR');
112: FND_MSG_PUB.add;
113: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
114:

Line 176: x_return_status := fnd_api.g_ret_sts_success;

172:
173: --Standard Start of API SAVEPOINT
174: SAVEPOINT GROUP_AUDIT;
175:
176: x_return_status := fnd_api.g_ret_sts_success;
177:
178: --Standard Call to check API compatibility
179: IF NOT FND_API.Compatible_API_CALL(l_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
180: THEN

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

175:
176: x_return_status := fnd_api.g_ret_sts_success;
177:
178: --Standard Call to check API compatibility
179: IF NOT FND_API.Compatible_API_CALL(l_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
180: THEN
181: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
182: END IF;
183:

Line 181: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

177:
178: --Standard Call to check API compatibility
179: IF NOT FND_API.Compatible_API_CALL(l_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
180: THEN
181: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
182: END IF;
183:
184: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
185: IF FND_API.To_boolean(P_INIT_MSG_LIST)

Line 185: IF FND_API.To_boolean(P_INIT_MSG_LIST)

181: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
182: END IF;
183:
184: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
185: IF FND_API.To_boolean(P_INIT_MSG_LIST)
186: THEN
187: FND_MSG_PUB.Initialize;
188: END IF;
189:

Line 248: IF fnd_api.to_boolean (p_commit)

244: X_LAST_UPDATE_LOGIN => l_login_id
245: );
246:
247:
248: IF fnd_api.to_boolean (p_commit)
249: THEN
250: COMMIT WORK;
251: END IF;
252:

Line 256: WHEN fnd_api.g_exc_unexpected_error

252:
253: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
254:
255: EXCEPTION
256: WHEN fnd_api.g_exc_unexpected_error
257: THEN
258: ROLLBACK TO group_audit;
259: x_return_status := fnd_api.g_ret_sts_unexp_error;
260: fnd_message.set_name ('JTF', 'JTF_RS_GROUP_MEM_AUD_ERR');

Line 259: x_return_status := fnd_api.g_ret_sts_unexp_error;

255: EXCEPTION
256: WHEN fnd_api.g_exc_unexpected_error
257: THEN
258: ROLLBACK TO group_audit;
259: x_return_status := fnd_api.g_ret_sts_unexp_error;
260: fnd_message.set_name ('JTF', 'JTF_RS_GROUP_MEM_AUD_ERR');
261: FND_MSG_PUB.add;
262: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
263: WHEN OTHERS

Line 266: x_return_status := fnd_api.g_ret_sts_unexp_error;

262: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
263: WHEN OTHERS
264: THEN
265: ROLLBACK TO group_audit;
266: x_return_status := fnd_api.g_ret_sts_unexp_error;
267: fnd_message.set_name ('JTF', 'JTF_RS_GROUP_MEM_AUD_ERR');
268: FND_MSG_PUB.add;
269: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
270:

Line 322: x_return_status := fnd_api.g_ret_sts_success;

318:
319: --Standard Start of API SAVEPOINT
320: SAVEPOINT GROUP_AUDIT;
321:
322: x_return_status := fnd_api.g_ret_sts_success;
323:
324: --Standard Call to check API compatibility
325: IF NOT FND_API.Compatible_API_CALL(l_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
326: THEN

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

321:
322: x_return_status := fnd_api.g_ret_sts_success;
323:
324: --Standard Call to check API compatibility
325: IF NOT FND_API.Compatible_API_CALL(l_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
326: THEN
327: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
328: END IF;
329:

Line 327: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

323:
324: --Standard Call to check API compatibility
325: IF NOT FND_API.Compatible_API_CALL(l_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
326: THEN
327: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
328: END IF;
329:
330: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
331: IF FND_API.To_boolean(P_INIT_MSG_LIST)

Line 331: IF FND_API.To_boolean(P_INIT_MSG_LIST)

327: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
328: END IF;
329:
330: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
331: IF FND_API.To_boolean(P_INIT_MSG_LIST)
332: THEN
333: FND_MSG_PUB.Initialize;
334: END IF;
335:

Line 379: IF fnd_api.to_boolean (p_commit)

375: X_LAST_UPDATE_LOGIN => l_login_id
376: );
377:
378:
379: IF fnd_api.to_boolean (p_commit)
380: THEN
381: COMMIT WORK;
382: END IF;
383:

Line 388: WHEN fnd_api.g_exc_unexpected_error

384: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
385:
386:
387: EXCEPTION
388: WHEN fnd_api.g_exc_unexpected_error
389: THEN
390: ROLLBACK TO group_audit;
391: x_return_status := fnd_api.g_ret_sts_unexp_error;
392: fnd_message.set_name ('JTF', 'JTF_RS_GROUP_MEM_AUD_ERR');

Line 391: x_return_status := fnd_api.g_ret_sts_unexp_error;

387: EXCEPTION
388: WHEN fnd_api.g_exc_unexpected_error
389: THEN
390: ROLLBACK TO group_audit;
391: x_return_status := fnd_api.g_ret_sts_unexp_error;
392: fnd_message.set_name ('JTF', 'JTF_RS_GROUP_MEM_AUD_ERR');
393: FND_MSG_PUB.add;
394: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
395: WHEN OTHERS

Line 398: x_return_status := fnd_api.g_ret_sts_unexp_error;

394: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
395: WHEN OTHERS
396: THEN
397: ROLLBACK TO group_audit;
398: x_return_status := fnd_api.g_ret_sts_unexp_error;
399: fnd_message.set_name ('JTF', 'JTF_RS_GROUP_MEM_AUD_ERR');
400: FND_MSG_PUB.add;
401: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
402: