DBA Data[Home] [Help]

APPS.JTF_RS_GROUP_RELATE_AUD_PVT dependencies on FND_MSG_PUB

Line 59: FND_MSG_PUB.Initialize;

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

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

96: THEN
97: COMMIT WORK;
98: END IF;
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

Line 107: FND_MSG_PUB.add;

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;
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

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

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;
113: fnd_message.set_name ('JTF', 'JTF_RS_GRP_RELATE_AUDIT_ERR');

Line 114: FND_MSG_PUB.add;

110: WHEN OTHERS
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:

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

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;
120:

Line 204: FND_MSG_PUB.Initialize;

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

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

286: THEN
287: COMMIT WORK;
288: END IF;
289:
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

Line 298: FND_MSG_PUB.add;

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;
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

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

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;
304: fnd_message.set_name ('JTF', 'JTF_RS_GRP_RELATE_AUDIT_ERR');

Line 305: FND_MSG_PUB.add;

301: WHEN OTHERS
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:

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

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;
311:

Line 377: FND_MSG_PUB.Initialize;

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

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

432: THEN
433: COMMIT WORK;
434: END IF;
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

Line 443: FND_MSG_PUB.add;

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;
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

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

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;
449: fnd_message.set_name ('JTF', 'JTF_RS_GRP_RELATE_AUDIT_ERR');

Line 450: FND_MSG_PUB.add;

446: WHEN OTHERS
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:

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

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;
456: