eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_RS_SKILL_LEVELS_PVT dependencies on FND_MSG_PUB

Line 42: FND_MSG_PUB.add;

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;
46: END;

Line 43: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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;
46: END;
47:

Line 76: FND_MSG_PUB.add;

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

Line 77: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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;
80:
81: END chk_dup_level_name;

Line 150: FND_MSG_PUB.Initialize;

146:
147: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
148: IF FND_API.To_boolean(P_INIT_MSG_LIST)
149: THEN
150: FND_MSG_PUB.Initialize;
151: END IF;
152:
153: --GET USER ID AND SYSDATE
154: l_date := sysdate;

Line 212: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

208: THEN
209: COMMIT WORK;
210: END IF;
211:
212: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
213:
214: EXCEPTION
215: WHEN fnd_api.g_exc_unexpected_error
216: THEN

Line 219: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

215: WHEN fnd_api.g_exc_unexpected_error
216: THEN
217: ROLLBACK TO SKILL_SP;
218: x_return_status := fnd_api.g_ret_sts_unexp_error;
219: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
220: WHEN fnd_api.g_exc_error
221: THEN
222: ROLLBACK TO SKILL_SP;
223: x_return_status := fnd_api.g_ret_sts_error;

Line 224: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

220: WHEN fnd_api.g_exc_error
221: THEN
222: ROLLBACK TO SKILL_SP;
223: x_return_status := fnd_api.g_ret_sts_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');

Line 232: FND_MSG_PUB.add;

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:
236: END create_skills;

Line 234: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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:
236: END create_skills;
237:
238:

Line 337: FND_MSG_PUB.Initialize;

333:
334: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
335: IF FND_API.To_boolean(P_INIT_MSG_LIST)
336: THEN
337: FND_MSG_PUB.Initialize;
338: END IF;
339:
340:
341: --GET USER ID AND SYSDATE

Line 509: fnd_msg_pub.add;

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

Line 549: FND_MSG_PUB.add;

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

Line 560: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

556: THEN
557: COMMIT WORK;
558: END IF;
559:
560: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
561:
562: EXCEPTION
563: WHEN fnd_api.g_exc_error
564: THEN

Line 566: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

562: EXCEPTION
563: WHEN fnd_api.g_exc_error
564: THEN
565: ROLLBACK TO SKILL_LEVELS_SP;
566: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
567: x_return_status := fnd_api.g_ret_sts_error;
568:
569: WHEN fnd_api.g_exc_unexpected_error
570: THEN

Line 573: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

569: WHEN fnd_api.g_exc_unexpected_error
570: THEN
571: ROLLBACK TO SKILL_LEVELS_SP;
572: x_return_status := fnd_api.g_ret_sts_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');

Line 581: FND_MSG_PUB.add;

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

Line 583: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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;
585:
586:
587: /* Procedure to delete the skill levels */

Line 643: FND_MSG_PUB.Initialize;

639:
640: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
641: IF FND_API.To_boolean(P_INIT_MSG_LIST)
642: THEN
643: FND_MSG_PUB.Initialize;
644: END IF;
645:
646: OPEN chk_skill_exist_cur(l_skill_level_id);
647: FETCH chk_skill_exist_cur INTO chk_skill_exist_rec;

Line 665: fnd_msg_pub.add;

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

Line 677: FND_MSG_PUB.add;

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

Line 687: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

683: THEN
684: COMMIT WORK;
685: END IF;
686:
687: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
688:
689: EXCEPTION
690: WHEN fnd_api.g_exc_unexpected_error
691: THEN

Line 693: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

689: EXCEPTION
690: WHEN fnd_api.g_exc_unexpected_error
691: THEN
692: ROLLBACK TO SKILL_LEVELS_SP;
693: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
694: WHEN fnd_api.g_exc_error
695: THEN
696: ROLLBACK TO SKILL_LEVELS_SP;
697: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 697: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

693: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
694: WHEN fnd_api.g_exc_error
695: THEN
696: ROLLBACK TO SKILL_LEVELS_SP;
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');

Line 705: FND_MSG_PUB.add;

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:
709: END delete_skills;

Line 707: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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:
709: END delete_skills;
710:
711: END JTF_RS_SKILL_LEVELS_PVT;