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