DBA Data[Home] [Help]

APPS.JTF_RS_GRP_MEMBERSHIP_PUB dependencies on FND_MESSAGE

Line 351: fnd_message.set_name('JTF', 'JTF_RS_RESOURCE_EXISTS_GROUP');

347: close get_group_name;
348:
349: -- hk_debug_proc(l_resource_name ||' is already a member of '||l_group_name);
350:
351: fnd_message.set_name('JTF', 'JTF_RS_RESOURCE_EXISTS_GROUP');
352: fnd_message.set_token('P_RESOURCE',l_resource_name);
353: fnd_message.set_token('P_GROUP',l_group_name);
354: fnd_msg_pub.add;
355: RAISE fnd_api.g_exc_unexpected_error;

Line 352: fnd_message.set_token('P_RESOURCE',l_resource_name);

348:
349: -- hk_debug_proc(l_resource_name ||' is already a member of '||l_group_name);
350:
351: fnd_message.set_name('JTF', 'JTF_RS_RESOURCE_EXISTS_GROUP');
352: fnd_message.set_token('P_RESOURCE',l_resource_name);
353: fnd_message.set_token('P_GROUP',l_group_name);
354: fnd_msg_pub.add;
355: RAISE fnd_api.g_exc_unexpected_error;
356:

Line 353: fnd_message.set_token('P_GROUP',l_group_name);

349: -- hk_debug_proc(l_resource_name ||' is already a member of '||l_group_name);
350:
351: fnd_message.set_name('JTF', 'JTF_RS_RESOURCE_EXISTS_GROUP');
352: fnd_message.set_token('P_RESOURCE',l_resource_name);
353: fnd_message.set_token('P_GROUP',l_group_name);
354: fnd_msg_pub.add;
355: RAISE fnd_api.g_exc_unexpected_error;
356:
357: end if;

Line 407: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');

403: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
404: when others
405: then
406: rollback to cr_grp_memship;
407: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
408: fnd_message.set_token('P_SQLCODE',SQLCODE);
409: fnd_message.set_token('P_SQLERRM',SQLERRM);
410: fnd_message.set_token('P_API_NAME',l_api_name);
411: FND_MSG_PUB.add;

Line 408: fnd_message.set_token('P_SQLCODE',SQLCODE);

404: when others
405: then
406: rollback to cr_grp_memship;
407: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
408: fnd_message.set_token('P_SQLCODE',SQLCODE);
409: fnd_message.set_token('P_SQLERRM',SQLERRM);
410: fnd_message.set_token('P_API_NAME',l_api_name);
411: FND_MSG_PUB.add;
412: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 409: fnd_message.set_token('P_SQLERRM',SQLERRM);

405: then
406: rollback to cr_grp_memship;
407: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
408: fnd_message.set_token('P_SQLCODE',SQLCODE);
409: fnd_message.set_token('P_SQLERRM',SQLERRM);
410: fnd_message.set_token('P_API_NAME',l_api_name);
411: FND_MSG_PUB.add;
412: x_return_status := fnd_api.g_ret_sts_unexp_error;
413: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 410: fnd_message.set_token('P_API_NAME',l_api_name);

406: rollback to cr_grp_memship;
407: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
408: fnd_message.set_token('P_SQLCODE',SQLCODE);
409: fnd_message.set_token('P_SQLERRM',SQLERRM);
410: fnd_message.set_token('P_API_NAME',l_api_name);
411: FND_MSG_PUB.add;
412: x_return_status := fnd_api.g_ret_sts_unexp_error;
413: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
414:

Line 688: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');

684: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
685: when others
686: then
687: rollback to upd_grp_memship;
688: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
689: fnd_message.set_token('P_SQLCODE',SQLCODE);
690: fnd_message.set_token('P_SQLERRM',SQLERRM);
691: fnd_message.set_token('P_API_NAME',l_api_name);
692: FND_MSG_PUB.add;

Line 689: fnd_message.set_token('P_SQLCODE',SQLCODE);

685: when others
686: then
687: rollback to upd_grp_memship;
688: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
689: fnd_message.set_token('P_SQLCODE',SQLCODE);
690: fnd_message.set_token('P_SQLERRM',SQLERRM);
691: fnd_message.set_token('P_API_NAME',l_api_name);
692: FND_MSG_PUB.add;
693: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 690: fnd_message.set_token('P_SQLERRM',SQLERRM);

686: then
687: rollback to upd_grp_memship;
688: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
689: fnd_message.set_token('P_SQLCODE',SQLCODE);
690: fnd_message.set_token('P_SQLERRM',SQLERRM);
691: fnd_message.set_token('P_API_NAME',l_api_name);
692: FND_MSG_PUB.add;
693: x_return_status := fnd_api.g_ret_sts_unexp_error;
694: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 691: fnd_message.set_token('P_API_NAME',l_api_name);

687: rollback to upd_grp_memship;
688: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
689: fnd_message.set_token('P_SQLCODE',SQLCODE);
690: fnd_message.set_token('P_SQLERRM',SQLERRM);
691: fnd_message.set_token('P_API_NAME',l_api_name);
692: FND_MSG_PUB.add;
693: x_return_status := fnd_api.g_ret_sts_unexp_error;
694: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
695:

Line 819: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');

815: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
816: when others
817: then
818: rollback to del_grp_memship;
819: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
820: fnd_message.set_token('P_SQLCODE',SQLCODE);
821: fnd_message.set_token('P_SQLERRM',SQLERRM);
822: fnd_message.set_token('P_API_NAME',l_api_name);
823: FND_MSG_PUB.add;

Line 820: fnd_message.set_token('P_SQLCODE',SQLCODE);

816: when others
817: then
818: rollback to del_grp_memship;
819: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
820: fnd_message.set_token('P_SQLCODE',SQLCODE);
821: fnd_message.set_token('P_SQLERRM',SQLERRM);
822: fnd_message.set_token('P_API_NAME',l_api_name);
823: FND_MSG_PUB.add;
824: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 821: fnd_message.set_token('P_SQLERRM',SQLERRM);

817: then
818: rollback to del_grp_memship;
819: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
820: fnd_message.set_token('P_SQLCODE',SQLCODE);
821: fnd_message.set_token('P_SQLERRM',SQLERRM);
822: fnd_message.set_token('P_API_NAME',l_api_name);
823: FND_MSG_PUB.add;
824: x_return_status := fnd_api.g_ret_sts_unexp_error;
825: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 822: fnd_message.set_token('P_API_NAME',l_api_name);

818: rollback to del_grp_memship;
819: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
820: fnd_message.set_token('P_SQLCODE',SQLCODE);
821: fnd_message.set_token('P_SQLERRM',SQLERRM);
822: fnd_message.set_token('P_API_NAME',l_api_name);
823: FND_MSG_PUB.add;
824: x_return_status := fnd_api.g_ret_sts_unexp_error;
825: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
826: