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_RESOURCE_SKILLS_PUB dependencies on FND_MSG_PUB

Line 559: FND_MSG_PUB.Initialize;

555:
556: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
557: IF FND_API.To_boolean(P_INIT_MSG_LIST)
558: THEN
559: FND_MSG_PUB.Initialize;
560: END IF;
561:
562: JTF_RS_RESOURCE_SKILLS_PVT.CREATE_RESOURCE_SKILLS(
563: P_API_VERSION => l_api_version,

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

613: THEN
614: COMMIT WORK;
615: END IF;
616:
617: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
618:
619: EXCEPTION
620: WHEN fnd_api.g_exc_unexpected_error
621: THEN

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

621: THEN
622:
623: ROLLBACK TO CREATE_RESOURCE_SKILLS_SP;
624: x_return_status := fnd_api.g_ret_sts_unexp_error;
625: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
626: WHEN fnd_api.g_exc_error
627: THEN
628: ROLLBACK TO CREATE_RESOURCE_SKILLS_SP;
629: --x_return_status := fnd_api.g_ret_sts_error;

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

626: WHEN fnd_api.g_exc_error
627: THEN
628: ROLLBACK TO CREATE_RESOURCE_SKILLS_SP;
629: --x_return_status := fnd_api.g_ret_sts_error;
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');

Line 638: FND_MSG_PUB.add;

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:
642: END CREATE_RESOURCE_SKILLS;

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

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:
642: END CREATE_RESOURCE_SKILLS;
643:
644:

Line 714: FND_MSG_PUB.Initialize;

710:
711: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
712: IF FND_API.To_boolean(P_INIT_MSG_LIST)
713: THEN
714: FND_MSG_PUB.Initialize;
715: END IF;
716:
717: JTF_RS_RESOURCE_SKILLS_PVT.UPDATE_RESOURCE_SKILLS(
718: P_API_VERSION => l_api_version,

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

768: THEN
769: COMMIT WORK;
770: END IF;
771:
772: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
773:
774: EXCEPTION
775: WHEN fnd_api.g_exc_error
776: THEN

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

775: WHEN fnd_api.g_exc_error
776: THEN
777: ROLLBACK TO UPDATE_RESOURCE_SKILLS_SP;
778: --x_return_status := fnd_api.g_ret_sts_error;
779: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
780:
781: WHEN fnd_api.g_exc_unexpected_error
782: THEN
783: ROLLBACK TO UPDATE_RESOURCE_SKILLS_SP;

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

781: WHEN fnd_api.g_exc_unexpected_error
782: THEN
783: ROLLBACK TO UPDATE_RESOURCE_SKILLS_SP;
784: x_return_status := fnd_api.g_ret_sts_unexp_error;
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');

Line 793: FND_MSG_PUB.add;

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

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

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;
797:
798:
799: /* Procedure to delete the resource skills */

Line 840: FND_MSG_PUB.Initialize;

836:
837: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
838: IF FND_API.To_boolean(P_INIT_MSG_LIST)
839: THEN
840: FND_MSG_PUB.Initialize;
841: END IF;
842:
843: JTF_RS_RESOURCE_SKILLS_PVT.DELETE_RESOURCE_SKILLS
844: (P_API_VERSION => l_api_version,

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

865: THEN
866: COMMIT WORK;
867: END IF;
868:
869: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
870:
871: EXCEPTION
872: WHEN fnd_api.g_exc_unexpected_error
873: THEN

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

872: WHEN fnd_api.g_exc_unexpected_error
873: THEN
874: ROLLBACK TO DELETE_RESOURCE_SKILLS_SP;
875: x_return_status := fnd_api.g_ret_sts_unexp_error;
876: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
877: WHEN fnd_api.g_exc_error
878: THEN
879: ROLLBACK TO DELETE_RESOURCE_SKILLS_SP;
880: --x_return_status := fnd_api.g_ret_sts_error;

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

877: WHEN fnd_api.g_exc_error
878: THEN
879: ROLLBACK TO DELETE_RESOURCE_SKILLS_SP;
880: --x_return_status := fnd_api.g_ret_sts_error;
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');

Line 889: FND_MSG_PUB.add;

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:
893: END delete_resource_skills;

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

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:
893: END delete_resource_skills;
894:
895: /* Procedure to create skill rating with cascading.

Line 969: FND_MSG_PUB.Initialize;

965:
966: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
967: IF FND_API.To_boolean(P_INIT_MSG_LIST)
968: THEN
969: FND_MSG_PUB.Initialize;
970: END IF;
971:
972: IF (l_cascade_option is NULL) THEN
973: l_cascade_option := DONT_CASCADE;

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

1241: WHEN fnd_api.g_exc_unexpected_error
1242: THEN
1243: ROLLBACK TO CREATE_RESOURCE_SKILLS_SP;
1244: x_return_status := fnd_api.g_ret_sts_unexp_error;
1245: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1246: WHEN fnd_api.g_exc_error
1247: THEN
1248: ROLLBACK TO CREATE_RESOURCE_SKILLS_SP;
1249: x_return_status := fnd_api.g_ret_sts_error;

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

1246: WHEN fnd_api.g_exc_error
1247: THEN
1248: ROLLBACK TO CREATE_RESOURCE_SKILLS_SP;
1249: x_return_status := fnd_api.g_ret_sts_error;
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');

Line 1258: FND_MSG_PUB.add;

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:
1262: END CREATE_RESOURCE_SKILLS;

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

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:
1262: END CREATE_RESOURCE_SKILLS;
1263:
1264: /* Procedure to update skill rating with cascading.

Line 1376: FND_MSG_PUB.Initialize;

1372:
1373: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
1374: IF FND_API.To_boolean(P_INIT_MSG_LIST)
1375: THEN
1376: FND_MSG_PUB.Initialize;
1377: END IF;
1378:
1379: IF (l_cascade_option is NULL) THEN
1380: l_cascade_option := DONT_CASCADE;

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

1585: CLOSE skill_curr;
1586: END IF;
1587: ROLLBACK TO UPDATE_RESOURCE_SKILLS_SP;
1588: x_return_status := fnd_api.g_ret_sts_unexp_error;
1589: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1590: WHEN fnd_api.g_exc_error
1591: THEN
1592: IF skill_curr%ISOPEN THEN
1593: CLOSE skill_curr;

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

1593: CLOSE skill_curr;
1594: END IF;
1595: ROLLBACK TO UPDATE_RESOURCE_SKILLS_SP;
1596: x_return_status := fnd_api.g_ret_sts_error;
1597: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1598: WHEN OTHERS
1599: THEN
1600: IF skill_curr%ISOPEN THEN
1601: CLOSE skill_curr;

Line 1608: FND_MSG_PUB.add;

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:
1612: END UPDATE_RESOURCE_SKILLS;

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

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:
1612: END UPDATE_RESOURCE_SKILLS;
1613: END jtf_rs_resource_skills_pub;