DBA Data[Home] [Help]

APPS.JTF_RS_GROUPS_AUD_PVT dependencies on FND_MSG_PUB

Line 61: FND_MSG_PUB.Initialize;

57:
58: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
59: IF FND_API.To_boolean(P_INIT_MSG_LIST)
60: THEN
61: FND_MSG_PUB.Initialize;
62: END IF;
63:
64: l_date := sysdate;
65: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);

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

108: THEN
109: COMMIT WORK;
110: END IF;
111:
112: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
113:
114:
115: EXCEPTION
116: WHEN fnd_api.g_exc_unexpected_error

Line 120: FND_MSG_PUB.add;

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

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

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

Line 127: FND_MSG_PUB.add;

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

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

125: ROLLBACK TO group_audit;
126: fnd_message.set_name ('JTF', 'JTF_RS_GROUP_AUDIT_ERR');
127: FND_MSG_PUB.add;
128: x_return_status := fnd_api.g_ret_sts_unexp_error;
129: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
130:
131: END INSERT_GROUP;
132:
133: /* FOR UPDATE */

Line 229: FND_MSG_PUB.Initialize;

225:
226: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
227: IF FND_API.To_boolean(P_INIT_MSG_LIST)
228: THEN
229: FND_MSG_PUB.Initialize;
230: END IF;
231:
232: l_date := sysdate;
233: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);

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

334: THEN
335: COMMIT WORK;
336: END IF;
337:
338: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
339:
340:
341: EXCEPTION
342: WHEN fnd_api.g_exc_unexpected_error

Line 346: FND_MSG_PUB.add;

342: WHEN fnd_api.g_exc_unexpected_error
343: THEN
344: ROLLBACK TO group_audit;
345: fnd_message.set_name ('JTF', 'JTF_RS_GROUP_AUDIT_ERR');
346: FND_MSG_PUB.add;
347: x_return_status := fnd_api.g_ret_sts_unexp_error;
348: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
349: WHEN OTHERS
350: THEN

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

344: ROLLBACK TO group_audit;
345: fnd_message.set_name ('JTF', 'JTF_RS_GROUP_AUDIT_ERR');
346: FND_MSG_PUB.add;
347: x_return_status := fnd_api.g_ret_sts_unexp_error;
348: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
349: WHEN OTHERS
350: THEN
351: ROLLBACK TO group_audit;
352: fnd_message.set_name ('JTF', 'JTF_RS_GROUP_AUDIT_ERR');

Line 353: FND_MSG_PUB.add;

349: WHEN OTHERS
350: THEN
351: ROLLBACK TO group_audit;
352: fnd_message.set_name ('JTF', 'JTF_RS_GROUP_AUDIT_ERR');
353: FND_MSG_PUB.add;
354: x_return_status := fnd_api.g_ret_sts_unexp_error;
355: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
356:
357: END UPDATE_GROUP;

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

351: ROLLBACK TO group_audit;
352: fnd_message.set_name ('JTF', 'JTF_RS_GROUP_AUDIT_ERR');
353: FND_MSG_PUB.add;
354: x_return_status := fnd_api.g_ret_sts_unexp_error;
355: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
356:
357: END UPDATE_GROUP;
358:
359:

Line 427: FND_MSG_PUB.Initialize;

423:
424: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
425: IF FND_API.To_boolean(P_INIT_MSG_LIST)
426: THEN
427: FND_MSG_PUB.Initialize;
428: END IF;
429:
430: l_date := sysdate;
431: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);

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

491: THEN
492: COMMIT WORK;
493: END IF;
494:
495: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
496:
497:
498: EXCEPTION
499: WHEN fnd_api.g_exc_unexpected_error

Line 503: FND_MSG_PUB.add;

499: WHEN fnd_api.g_exc_unexpected_error
500: THEN
501: ROLLBACK TO group_audit;
502: fnd_message.set_name ('JTF', 'JTF_RS_GROUP_AUDIT_ERR');
503: FND_MSG_PUB.add;
504: x_return_status := fnd_api.g_ret_sts_unexp_error;
505: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
506: WHEN OTHERS
507: THEN

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

501: ROLLBACK TO group_audit;
502: fnd_message.set_name ('JTF', 'JTF_RS_GROUP_AUDIT_ERR');
503: FND_MSG_PUB.add;
504: x_return_status := fnd_api.g_ret_sts_unexp_error;
505: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
506: WHEN OTHERS
507: THEN
508: ROLLBACK TO group_audit;
509: fnd_message.set_name ('JTF', 'JTF_RS_GROUP_AUDIT_ERR');

Line 510: FND_MSG_PUB.add;

506: WHEN OTHERS
507: THEN
508: ROLLBACK TO group_audit;
509: fnd_message.set_name ('JTF', 'JTF_RS_GROUP_AUDIT_ERR');
510: FND_MSG_PUB.add;
511: x_return_status := fnd_api.g_ret_sts_unexp_error;
512: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
513: END DELETE_GROUP;
514: END; -- Package Body JTF_RS_GROUPS_AUD_PVT

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

508: ROLLBACK TO group_audit;
509: fnd_message.set_name ('JTF', 'JTF_RS_GROUP_AUDIT_ERR');
510: FND_MSG_PUB.add;
511: x_return_status := fnd_api.g_ret_sts_unexp_error;
512: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
513: END DELETE_GROUP;
514: END; -- Package Body JTF_RS_GROUPS_AUD_PVT