DBA Data[Home] [Help]

APPS.JTF_RS_GROUPS_AUD_PVT dependencies on FND_MSG_PUB

Line 60: FND_MSG_PUB.Initialize;

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

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

105: THEN
106: COMMIT WORK;
107: END IF;
108:
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

Line 117: FND_MSG_PUB.add;

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

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

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

Line 124: FND_MSG_PUB.add;

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

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

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:
130: /* FOR UPDATE */

Line 223: FND_MSG_PUB.Initialize;

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

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

321: THEN
322: COMMIT WORK;
323: END IF;
324:
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

Line 333: FND_MSG_PUB.add;

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

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

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

Line 340: FND_MSG_PUB.add;

336: WHEN OTHERS
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;

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

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

Line 412: FND_MSG_PUB.Initialize;

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

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

473: THEN
474: COMMIT WORK;
475: END IF;
476:
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

Line 485: FND_MSG_PUB.add;

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

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

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

Line 492: FND_MSG_PUB.add;

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

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

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