DBA Data[Home] [Help]

APPS.JTF_RS_SKILL_LEVELS_PVT dependencies on FND_MESSAGE

Line 41: fnd_message.set_name ('JTF', 'JTF_RS_DUP_SKILL_LEVEL');

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;

Line 75: fnd_message.set_name ('JTF', 'JTF_RS_DUP_SKILL_LEVEL_NAME');

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;

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

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;

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

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;

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

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

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

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:

Line 508: fnd_message.set_name('JTF', 'JTF_RS_ROW_LOCK_ERROR');

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;

Line 548: fnd_message.set_name ('JTF', 'JTF_RS_SKILL_LEVEL_ID_INVALID');

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;

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

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;

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

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;

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

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

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

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;

Line 664: fnd_message.set_name('JTF', 'JTF_RS_ROW_LOCK_ERROR');

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;

Line 676: fnd_message.set_name ('JTF', 'JTF_RS_SKILL_LEVEL_ID_INVALID');

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;

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

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;

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

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;

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

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

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

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: