DBA Data[Home] [Help]

APPS.JTF_RS_RESOURCE_SKILLS_PUB dependencies on FND_MESSAGE

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

630: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
631: WHEN OTHERS
632: THEN
633: ROLLBACK TO CREATE_RESOURCE_SKILLS_SP;
634: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
635: fnd_message.set_token('P_SQLCODE',SQLCODE);
636: fnd_message.set_token('P_SQLERRM',SQLERRM);
637: fnd_message.set_token('P_API_NAME', l_api_name);
638: FND_MSG_PUB.add;

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

631: WHEN OTHERS
632: THEN
633: ROLLBACK TO CREATE_RESOURCE_SKILLS_SP;
634: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
635: fnd_message.set_token('P_SQLCODE',SQLCODE);
636: fnd_message.set_token('P_SQLERRM',SQLERRM);
637: fnd_message.set_token('P_API_NAME', l_api_name);
638: FND_MSG_PUB.add;
639: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

632: THEN
633: ROLLBACK TO CREATE_RESOURCE_SKILLS_SP;
634: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
635: fnd_message.set_token('P_SQLCODE',SQLCODE);
636: fnd_message.set_token('P_SQLERRM',SQLERRM);
637: fnd_message.set_token('P_API_NAME', l_api_name);
638: FND_MSG_PUB.add;
639: x_return_status := fnd_api.g_ret_sts_unexp_error;
640: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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

633: ROLLBACK TO CREATE_RESOURCE_SKILLS_SP;
634: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
635: fnd_message.set_token('P_SQLCODE',SQLCODE);
636: fnd_message.set_token('P_SQLERRM',SQLERRM);
637: fnd_message.set_token('P_API_NAME', l_api_name);
638: FND_MSG_PUB.add;
639: x_return_status := fnd_api.g_ret_sts_unexp_error;
640: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
641:

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

785: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
786: WHEN OTHERS
787: THEN
788: ROLLBACK TO UPDATE_RESOURCE_SKILLS_SP;
789: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
790: fnd_message.set_token('P_SQLCODE',SQLCODE);
791: fnd_message.set_token('P_SQLERRM',SQLERRM);
792: fnd_message.set_token('P_API_NAME',l_api_name);
793: FND_MSG_PUB.add;

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

786: WHEN OTHERS
787: THEN
788: ROLLBACK TO UPDATE_RESOURCE_SKILLS_SP;
789: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
790: fnd_message.set_token('P_SQLCODE',SQLCODE);
791: fnd_message.set_token('P_SQLERRM',SQLERRM);
792: fnd_message.set_token('P_API_NAME',l_api_name);
793: FND_MSG_PUB.add;
794: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

787: THEN
788: ROLLBACK TO UPDATE_RESOURCE_SKILLS_SP;
789: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
790: fnd_message.set_token('P_SQLCODE',SQLCODE);
791: fnd_message.set_token('P_SQLERRM',SQLERRM);
792: fnd_message.set_token('P_API_NAME',l_api_name);
793: FND_MSG_PUB.add;
794: x_return_status := fnd_api.g_ret_sts_unexp_error;
795: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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

788: ROLLBACK TO UPDATE_RESOURCE_SKILLS_SP;
789: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
790: fnd_message.set_token('P_SQLCODE',SQLCODE);
791: fnd_message.set_token('P_SQLERRM',SQLERRM);
792: fnd_message.set_token('P_API_NAME',l_api_name);
793: FND_MSG_PUB.add;
794: x_return_status := fnd_api.g_ret_sts_unexp_error;
795: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
796: END update_resource_skills;

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

881: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
882: WHEN OTHERS
883: THEN
884: ROLLBACK TO DELETE_RESOURCE_SKILLS_SP;
885: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
886: fnd_message.set_token('P_SQLCODE',SQLCODE);
887: fnd_message.set_token('P_SQLERRM',SQLERRM);
888: fnd_message.set_token('P_API_NAME',l_api_name);
889: FND_MSG_PUB.add;

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

882: WHEN OTHERS
883: THEN
884: ROLLBACK TO DELETE_RESOURCE_SKILLS_SP;
885: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
886: fnd_message.set_token('P_SQLCODE',SQLCODE);
887: fnd_message.set_token('P_SQLERRM',SQLERRM);
888: fnd_message.set_token('P_API_NAME',l_api_name);
889: FND_MSG_PUB.add;
890: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

883: THEN
884: ROLLBACK TO DELETE_RESOURCE_SKILLS_SP;
885: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
886: fnd_message.set_token('P_SQLCODE',SQLCODE);
887: fnd_message.set_token('P_SQLERRM',SQLERRM);
888: fnd_message.set_token('P_API_NAME',l_api_name);
889: FND_MSG_PUB.add;
890: x_return_status := fnd_api.g_ret_sts_unexp_error;
891: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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

884: ROLLBACK TO DELETE_RESOURCE_SKILLS_SP;
885: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
886: fnd_message.set_token('P_SQLCODE',SQLCODE);
887: fnd_message.set_token('P_SQLERRM',SQLERRM);
888: fnd_message.set_token('P_API_NAME',l_api_name);
889: FND_MSG_PUB.add;
890: x_return_status := fnd_api.g_ret_sts_unexp_error;
891: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
892:

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

1250: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1251: WHEN OTHERS
1252: THEN
1253: ROLLBACK TO CREATE_RESOURCE_SKILLS_SP;
1254: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
1255: fnd_message.set_token('P_SQLCODE',SQLCODE);
1256: fnd_message.set_token('P_SQLERRM',SQLERRM);
1257: fnd_message.set_token('P_API_NAME', l_api_name);
1258: FND_MSG_PUB.add;

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

1251: WHEN OTHERS
1252: THEN
1253: ROLLBACK TO CREATE_RESOURCE_SKILLS_SP;
1254: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
1255: fnd_message.set_token('P_SQLCODE',SQLCODE);
1256: fnd_message.set_token('P_SQLERRM',SQLERRM);
1257: fnd_message.set_token('P_API_NAME', l_api_name);
1258: FND_MSG_PUB.add;
1259: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

1252: THEN
1253: ROLLBACK TO CREATE_RESOURCE_SKILLS_SP;
1254: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
1255: fnd_message.set_token('P_SQLCODE',SQLCODE);
1256: fnd_message.set_token('P_SQLERRM',SQLERRM);
1257: fnd_message.set_token('P_API_NAME', l_api_name);
1258: FND_MSG_PUB.add;
1259: x_return_status := fnd_api.g_ret_sts_unexp_error;
1260: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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

1253: ROLLBACK TO CREATE_RESOURCE_SKILLS_SP;
1254: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
1255: fnd_message.set_token('P_SQLCODE',SQLCODE);
1256: fnd_message.set_token('P_SQLERRM',SQLERRM);
1257: fnd_message.set_token('P_API_NAME', l_api_name);
1258: FND_MSG_PUB.add;
1259: x_return_status := fnd_api.g_ret_sts_unexp_error;
1260: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1261:

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

1600: IF skill_curr%ISOPEN THEN
1601: CLOSE skill_curr;
1602: END IF;
1603: ROLLBACK TO UPDATE_RESOURCE_SKILLS_SP;
1604: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
1605: fnd_message.set_token('P_SQLCODE',SQLCODE);
1606: fnd_message.set_token('P_SQLERRM',SQLERRM);
1607: fnd_message.set_token('P_API_NAME', l_api_name);
1608: FND_MSG_PUB.add;

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

1601: CLOSE skill_curr;
1602: END IF;
1603: ROLLBACK TO UPDATE_RESOURCE_SKILLS_SP;
1604: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
1605: fnd_message.set_token('P_SQLCODE',SQLCODE);
1606: fnd_message.set_token('P_SQLERRM',SQLERRM);
1607: fnd_message.set_token('P_API_NAME', l_api_name);
1608: FND_MSG_PUB.add;
1609: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

1602: END IF;
1603: ROLLBACK TO UPDATE_RESOURCE_SKILLS_SP;
1604: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
1605: fnd_message.set_token('P_SQLCODE',SQLCODE);
1606: fnd_message.set_token('P_SQLERRM',SQLERRM);
1607: fnd_message.set_token('P_API_NAME', l_api_name);
1608: FND_MSG_PUB.add;
1609: x_return_status := fnd_api.g_ret_sts_unexp_error;
1610: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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

1603: ROLLBACK TO UPDATE_RESOURCE_SKILLS_SP;
1604: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
1605: fnd_message.set_token('P_SQLCODE',SQLCODE);
1606: fnd_message.set_token('P_SQLERRM',SQLERRM);
1607: fnd_message.set_token('P_API_NAME', l_api_name);
1608: FND_MSG_PUB.add;
1609: x_return_status := fnd_api.g_ret_sts_unexp_error;
1610: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1611: