152: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
153: WHEN OTHERS
154: THEN
155: ROLLBACK TO CREATE_SKILL_LEVELS_SP;
156: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
157: fnd_message.set_token('P_SQLCODE',SQLCODE);
158: fnd_message.set_token('P_SQLERRM',SQLERRM);
159: fnd_message.set_token('P_API_NAME', l_api_name);
160: FND_MSG_PUB.add;
153: WHEN OTHERS
154: THEN
155: ROLLBACK TO CREATE_SKILL_LEVELS_SP;
156: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
157: fnd_message.set_token('P_SQLCODE',SQLCODE);
158: fnd_message.set_token('P_SQLERRM',SQLERRM);
159: fnd_message.set_token('P_API_NAME', l_api_name);
160: FND_MSG_PUB.add;
161: x_return_status := fnd_api.g_ret_sts_unexp_error;
154: THEN
155: ROLLBACK TO CREATE_SKILL_LEVELS_SP;
156: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
157: fnd_message.set_token('P_SQLCODE',SQLCODE);
158: fnd_message.set_token('P_SQLERRM',SQLERRM);
159: fnd_message.set_token('P_API_NAME', l_api_name);
160: FND_MSG_PUB.add;
161: x_return_status := fnd_api.g_ret_sts_unexp_error;
162: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
155: ROLLBACK TO CREATE_SKILL_LEVELS_SP;
156: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
157: fnd_message.set_token('P_SQLCODE',SQLCODE);
158: fnd_message.set_token('P_SQLERRM',SQLERRM);
159: fnd_message.set_token('P_API_NAME', l_api_name);
160: FND_MSG_PUB.add;
161: x_return_status := fnd_api.g_ret_sts_unexp_error;
162: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
163:
284: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
285: WHEN OTHERS
286: THEN
287: ROLLBACK TO UPDATE_SKILL_LEVELS_SP;
288: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
289: fnd_message.set_token('P_SQLCODE',SQLCODE);
290: fnd_message.set_token('P_SQLERRM',SQLERRM);
291: fnd_message.set_token('P_API_NAME',l_api_name);
292: FND_MSG_PUB.add;
285: WHEN OTHERS
286: THEN
287: ROLLBACK TO UPDATE_SKILL_LEVELS_SP;
288: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
289: fnd_message.set_token('P_SQLCODE',SQLCODE);
290: fnd_message.set_token('P_SQLERRM',SQLERRM);
291: fnd_message.set_token('P_API_NAME',l_api_name);
292: FND_MSG_PUB.add;
293: x_return_status := fnd_api.g_ret_sts_unexp_error;
286: THEN
287: ROLLBACK TO UPDATE_SKILL_LEVELS_SP;
288: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
289: fnd_message.set_token('P_SQLCODE',SQLCODE);
290: fnd_message.set_token('P_SQLERRM',SQLERRM);
291: fnd_message.set_token('P_API_NAME',l_api_name);
292: FND_MSG_PUB.add;
293: x_return_status := fnd_api.g_ret_sts_unexp_error;
294: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
287: ROLLBACK TO UPDATE_SKILL_LEVELS_SP;
288: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
289: fnd_message.set_token('P_SQLCODE',SQLCODE);
290: fnd_message.set_token('P_SQLERRM',SQLERRM);
291: fnd_message.set_token('P_API_NAME',l_api_name);
292: FND_MSG_PUB.add;
293: x_return_status := fnd_api.g_ret_sts_unexp_error;
294: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
295: END update_skills;
371: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
372: WHEN OTHERS
373: THEN
374: ROLLBACK TO DELETE_SKILL_LEVELS_SP;
375: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
376: fnd_message.set_token('P_SQLCODE',SQLCODE);
377: fnd_message.set_token('P_SQLERRM',SQLERRM);
378: fnd_message.set_token('P_API_NAME',l_api_name);
379: FND_MSG_PUB.add;
372: WHEN OTHERS
373: THEN
374: ROLLBACK TO DELETE_SKILL_LEVELS_SP;
375: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
376: fnd_message.set_token('P_SQLCODE',SQLCODE);
377: fnd_message.set_token('P_SQLERRM',SQLERRM);
378: fnd_message.set_token('P_API_NAME',l_api_name);
379: FND_MSG_PUB.add;
380: x_return_status := fnd_api.g_ret_sts_unexp_error;
373: THEN
374: ROLLBACK TO DELETE_SKILL_LEVELS_SP;
375: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
376: fnd_message.set_token('P_SQLCODE',SQLCODE);
377: fnd_message.set_token('P_SQLERRM',SQLERRM);
378: fnd_message.set_token('P_API_NAME',l_api_name);
379: FND_MSG_PUB.add;
380: x_return_status := fnd_api.g_ret_sts_unexp_error;
381: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
374: ROLLBACK TO DELETE_SKILL_LEVELS_SP;
375: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
376: fnd_message.set_token('P_SQLCODE',SQLCODE);
377: fnd_message.set_token('P_SQLERRM',SQLERRM);
378: fnd_message.set_token('P_API_NAME',l_api_name);
379: FND_MSG_PUB.add;
380: x_return_status := fnd_api.g_ret_sts_unexp_error;
381: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
382: