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,
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
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;
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');
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;
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:
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,
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
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;
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');
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:
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 */
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,
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
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;
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');
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;
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.
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;
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;
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');
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;
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.
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;
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;
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;
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;
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;