37: ELSIF chk_dup_skill%FOUND THEN
38: close chk_dup_skill;
39: x_return_status := fnd_api.g_ret_sts_error;
40: x_skill_level_id := skill_levels_rec.skill_level_id;
41: fnd_message.set_name ('JTF', 'JTF_RS_DUP_SKILL_LEVEL');
42: FND_MSG_PUB.add;
43: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
44: raise fnd_api.g_exc_error;
45: END IF;
71: ELSIF chk_dup_name%FOUND THEN
72: CLOSE chk_dup_name;
73: x_return_status := fnd_api.g_ret_sts_error;
74: x_skill_level_id := levels_vl_rec.skill_level_id;
75: fnd_message.set_name ('JTF', 'JTF_RS_DUP_SKILL_LEVEL_NAME');
76: FND_MSG_PUB.add;
77: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
78: raise fnd_api.g_exc_error;
79: END IF;
224: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
225: WHEN OTHERS
226: THEN
227: ROLLBACK TO SKILL_SP;
228: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
229: fnd_message.set_token('P_SQLCODE',SQLCODE);
230: fnd_message.set_token('P_SQLERRM',SQLERRM);
231: fnd_message.set_token('P_API_NAME', l_api_name);
232: FND_MSG_PUB.add;
225: WHEN OTHERS
226: THEN
227: ROLLBACK TO SKILL_SP;
228: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
229: fnd_message.set_token('P_SQLCODE',SQLCODE);
230: fnd_message.set_token('P_SQLERRM',SQLERRM);
231: fnd_message.set_token('P_API_NAME', l_api_name);
232: FND_MSG_PUB.add;
233: x_return_status := fnd_api.g_ret_sts_unexp_error;
226: THEN
227: ROLLBACK TO SKILL_SP;
228: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
229: fnd_message.set_token('P_SQLCODE',SQLCODE);
230: fnd_message.set_token('P_SQLERRM',SQLERRM);
231: fnd_message.set_token('P_API_NAME', l_api_name);
232: FND_MSG_PUB.add;
233: x_return_status := fnd_api.g_ret_sts_unexp_error;
234: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
227: ROLLBACK TO SKILL_SP;
228: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
229: fnd_message.set_token('P_SQLCODE',SQLCODE);
230: fnd_message.set_token('P_SQLERRM',SQLERRM);
231: fnd_message.set_token('P_API_NAME', l_api_name);
232: FND_MSG_PUB.add;
233: x_return_status := fnd_api.g_ret_sts_unexp_error;
234: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
235:
504: EXCEPTION
505:
506: WHEN OTHERS THEN
507: x_return_status := fnd_api.g_ret_sts_error;
508: fnd_message.set_name('JTF', 'JTF_RS_ROW_LOCK_ERROR');
509: fnd_msg_pub.add;
510: RAISE fnd_api.g_exc_error;
511:
512: END;
544:
545: ELSIF (chk_skill_cur%notfound) THEN
546: CLOSE chk_skill_cur;
547: x_return_status := fnd_api.g_ret_sts_error;
548: fnd_message.set_name ('JTF', 'JTF_RS_SKILL_LEVEL_ID_INVALID');
549: FND_MSG_PUB.add;
550: RAISE fnd_api.g_exc_error;
551:
552: END IF;
573: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
574: WHEN OTHERS
575: THEN
576: ROLLBACK TO SKILL_LEVELS_SP;
577: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
578: fnd_message.set_token('P_SQLCODE',SQLCODE);
579: fnd_message.set_token('P_SQLERRM',SQLERRM);
580: fnd_message.set_token('P_API_NAME',l_api_name);
581: FND_MSG_PUB.add;
574: WHEN OTHERS
575: THEN
576: ROLLBACK TO SKILL_LEVELS_SP;
577: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
578: fnd_message.set_token('P_SQLCODE',SQLCODE);
579: fnd_message.set_token('P_SQLERRM',SQLERRM);
580: fnd_message.set_token('P_API_NAME',l_api_name);
581: FND_MSG_PUB.add;
582: x_return_status := fnd_api.g_ret_sts_unexp_error;
575: THEN
576: ROLLBACK TO SKILL_LEVELS_SP;
577: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
578: fnd_message.set_token('P_SQLCODE',SQLCODE);
579: fnd_message.set_token('P_SQLERRM',SQLERRM);
580: fnd_message.set_token('P_API_NAME',l_api_name);
581: FND_MSG_PUB.add;
582: x_return_status := fnd_api.g_ret_sts_unexp_error;
583: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
576: ROLLBACK TO SKILL_LEVELS_SP;
577: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
578: fnd_message.set_token('P_SQLCODE',SQLCODE);
579: fnd_message.set_token('P_SQLERRM',SQLERRM);
580: fnd_message.set_token('P_API_NAME',l_api_name);
581: FND_MSG_PUB.add;
582: x_return_status := fnd_api.g_ret_sts_unexp_error;
583: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
584: END update_skills;
660: EXCEPTION
661:
662: WHEN OTHERS THEN
663: x_return_status := fnd_api.g_ret_sts_error;
664: fnd_message.set_name('JTF', 'JTF_RS_ROW_LOCK_ERROR');
665: fnd_msg_pub.add;
666: RAISE fnd_api.g_exc_error;
667:
668: END;
672:
673: ELSIF (chk_skill_exist_cur%notfound) THEN
674: CLOSE chk_skill_exist_cur;
675: x_return_status := fnd_api.g_ret_sts_error;
676: fnd_message.set_name ('JTF', 'JTF_RS_SKILL_LEVEL_ID_INVALID');
677: FND_MSG_PUB.add;
678: RAISE fnd_api.g_exc_error;
679:
680: END IF;
697: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
698: WHEN OTHERS
699: THEN
700: ROLLBACK TO SKILL_LEVELS_SP;
701: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
702: fnd_message.set_token('P_SQLCODE',SQLCODE);
703: fnd_message.set_token('P_SQLERRM',SQLERRM);
704: fnd_message.set_token('P_API_NAME',l_api_name);
705: FND_MSG_PUB.add;
698: WHEN OTHERS
699: THEN
700: ROLLBACK TO SKILL_LEVELS_SP;
701: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
702: fnd_message.set_token('P_SQLCODE',SQLCODE);
703: fnd_message.set_token('P_SQLERRM',SQLERRM);
704: fnd_message.set_token('P_API_NAME',l_api_name);
705: FND_MSG_PUB.add;
706: x_return_status := fnd_api.g_ret_sts_unexp_error;
699: THEN
700: ROLLBACK TO SKILL_LEVELS_SP;
701: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
702: fnd_message.set_token('P_SQLCODE',SQLCODE);
703: fnd_message.set_token('P_SQLERRM',SQLERRM);
704: fnd_message.set_token('P_API_NAME',l_api_name);
705: FND_MSG_PUB.add;
706: x_return_status := fnd_api.g_ret_sts_unexp_error;
707: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
700: ROLLBACK TO SKILL_LEVELS_SP;
701: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
702: fnd_message.set_token('P_SQLCODE',SQLCODE);
703: fnd_message.set_token('P_SQLERRM',SQLERRM);
704: fnd_message.set_token('P_API_NAME',l_api_name);
705: FND_MSG_PUB.add;
706: x_return_status := fnd_api.g_ret_sts_unexp_error;
707: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
708: