DBA Data[Home] [Help]

APPS.JTF_RS_GROUP_MEMBERS_AUD_PVT dependencies on FND_MSG_PUB

Line 56: FND_MSG_PUB.Initialize;

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:
59: l_date := sysdate;
60: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);

Line 96: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

92: THEN
93: COMMIT WORK;
94: END IF;
95:
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

Line 105: FND_MSG_PUB.add;

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
108: THEN
109: ROLLBACK TO group_audit;

Line 106: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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
108: THEN
109: ROLLBACK TO group_audit;
110: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 112: FND_MSG_PUB.add;

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:
115: END INSERT_MEMBER;
116:

Line 113: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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:
115: END INSERT_MEMBER;
116:
117: /* FOR UPDATE */

Line 187: FND_MSG_PUB.Initialize;

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:
190: l_date := sysdate;
191: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);

Line 253: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

249: THEN
250: COMMIT WORK;
251: END IF;
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

Line 261: FND_MSG_PUB.add;

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
264: THEN
265: ROLLBACK TO group_audit;

Line 262: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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
264: THEN
265: ROLLBACK TO group_audit;
266: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 268: FND_MSG_PUB.add;

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:
271: END UPDATE_MEMBER;
272:

Line 269: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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:
271: END UPDATE_MEMBER;
272:
273:

Line 333: FND_MSG_PUB.Initialize;

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:
336: l_date := sysdate;
337: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);

Line 384: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

380: THEN
381: COMMIT WORK;
382: END IF;
383:
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

Line 393: FND_MSG_PUB.add;

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
396: THEN
397: ROLLBACK TO group_audit;

Line 394: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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
396: THEN
397: ROLLBACK TO group_audit;
398: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 400: FND_MSG_PUB.add;

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:
403: END delete_member;
404: END; -- Package Body JTF_RS_GROUP_MEMBERS_AUD_PVT

Line 401: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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:
403: END delete_member;
404: END; -- Package Body JTF_RS_GROUP_MEMBERS_AUD_PVT