139: ELSE
140: IF c_dup_res_avail%ISOPEN THEN
141: CLOSE c_dup_res_avail;
142: END IF;
143: fnd_message.set_name ('JTF', 'JTF_RS_DUP_RES_AVAIL');
144: FND_MSG_PUB.add;
145: raise fnd_api.g_exc_error;
146: END IF;
147: IF c_dup_res_avail%ISOPEN THEN
172: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
173: WHEN OTHERS
174: THEN
175: ROLLBACK TO RESOURCE_AVAILABILITY_SP;
176: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
177: fnd_message.set_token('P_SQLCODE',SQLCODE);
178: fnd_message.set_token('P_SQLERRM',SQLERRM);
179: fnd_message.set_token('P_API_NAME', l_api_name);
180: FND_MSG_PUB.add;
173: WHEN OTHERS
174: THEN
175: ROLLBACK TO RESOURCE_AVAILABILITY_SP;
176: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
177: fnd_message.set_token('P_SQLCODE',SQLCODE);
178: fnd_message.set_token('P_SQLERRM',SQLERRM);
179: fnd_message.set_token('P_API_NAME', l_api_name);
180: FND_MSG_PUB.add;
181: x_return_status := fnd_api.g_ret_sts_unexp_error;
174: THEN
175: ROLLBACK TO RESOURCE_AVAILABILITY_SP;
176: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
177: fnd_message.set_token('P_SQLCODE',SQLCODE);
178: fnd_message.set_token('P_SQLERRM',SQLERRM);
179: fnd_message.set_token('P_API_NAME', l_api_name);
180: FND_MSG_PUB.add;
181: x_return_status := fnd_api.g_ret_sts_unexp_error;
182: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
175: ROLLBACK TO RESOURCE_AVAILABILITY_SP;
176: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
177: fnd_message.set_token('P_SQLCODE',SQLCODE);
178: fnd_message.set_token('P_SQLERRM',SQLERRM);
179: fnd_message.set_token('P_API_NAME', l_api_name);
180: FND_MSG_PUB.add;
181: x_return_status := fnd_api.g_ret_sts_unexp_error;
182: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
183:
490: IF c_dup_res_avail%FOUND THEN
491: IF c_dup_res_avail%ISOPEN THEN
492: CLOSE c_dup_res_avail;
493: END IF;
494: fnd_message.set_name ('JTF', 'JTF_RS_DUP_RES_AVAIL');
495: FND_MSG_PUB.add;
496: raise fnd_api.g_exc_error;
497: END IF;
498: IF c_dup_res_avail%ISOPEN THEN
509: EXCEPTION
510:
511: WHEN OTHERS THEN
512: x_return_status := fnd_api.g_ret_sts_error;
513: fnd_message.set_name('JTF', 'JTF_RS_ROW_LOCK_ERROR');
514: fnd_msg_pub.add;
515: RAISE fnd_api.g_exc_error;
516:
517: END;
553: P_OBJECT_VERSION_NUM := l_object_version_number;
554:
555: ELSIF (resource_cur%notfound) THEN
556: x_return_status := fnd_api.g_ret_sts_error;
557: fnd_message.set_name ('JTF', 'JTF_RS_AVAILABILITY_ID_INVALID');
558: FND_MSG_PUB.add;
559: RAISE fnd_api.g_exc_error;
560:
561: END IF;
582: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
583: WHEN OTHERS
584: THEN
585: ROLLBACK TO RES_AVAILABILITY_SP;
586: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
587: fnd_message.set_token('P_SQLCODE',SQLCODE);
588: fnd_message.set_token('P_SQLERRM',SQLERRM);
589: fnd_message.set_token('P_API_NAME',l_api_name);
590: FND_MSG_PUB.add;
583: WHEN OTHERS
584: THEN
585: ROLLBACK TO RES_AVAILABILITY_SP;
586: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
587: fnd_message.set_token('P_SQLCODE',SQLCODE);
588: fnd_message.set_token('P_SQLERRM',SQLERRM);
589: fnd_message.set_token('P_API_NAME',l_api_name);
590: FND_MSG_PUB.add;
591: x_return_status := fnd_api.g_ret_sts_unexp_error;
584: THEN
585: ROLLBACK TO RES_AVAILABILITY_SP;
586: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
587: fnd_message.set_token('P_SQLCODE',SQLCODE);
588: fnd_message.set_token('P_SQLERRM',SQLERRM);
589: fnd_message.set_token('P_API_NAME',l_api_name);
590: FND_MSG_PUB.add;
591: x_return_status := fnd_api.g_ret_sts_unexp_error;
592: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
585: ROLLBACK TO RES_AVAILABILITY_SP;
586: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
587: fnd_message.set_token('P_SQLCODE',SQLCODE);
588: fnd_message.set_token('P_SQLERRM',SQLERRM);
589: fnd_message.set_token('P_API_NAME',l_api_name);
590: FND_MSG_PUB.add;
591: x_return_status := fnd_api.g_ret_sts_unexp_error;
592: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
593: END update_res_availability;
655: X_AVAILABILITY_ID => l_availability_id);
656:
657: ELSIF (chk_res_exist_cur%notfound) THEN
658: x_return_status := fnd_api.g_ret_sts_error;
659: fnd_message.set_name ('JTF', 'JTF_RS_AVAILABILITY_ID_INVALID');
660: FND_MSG_PUB.add;
661: RAISE fnd_api.g_exc_error;
662:
663: END IF;
684: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
685: WHEN OTHERS
686: THEN
687: ROLLBACK TO RES_AVAILABILITY_SP;
688: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
689: fnd_message.set_token('P_SQLCODE',SQLCODE);
690: fnd_message.set_token('P_SQLERRM',SQLERRM);
691: fnd_message.set_token('P_API_NAME',l_api_name);
692: FND_MSG_PUB.add;
685: WHEN OTHERS
686: THEN
687: ROLLBACK TO RES_AVAILABILITY_SP;
688: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
689: fnd_message.set_token('P_SQLCODE',SQLCODE);
690: fnd_message.set_token('P_SQLERRM',SQLERRM);
691: fnd_message.set_token('P_API_NAME',l_api_name);
692: FND_MSG_PUB.add;
693: x_return_status := fnd_api.g_ret_sts_unexp_error;
686: THEN
687: ROLLBACK TO RES_AVAILABILITY_SP;
688: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
689: fnd_message.set_token('P_SQLCODE',SQLCODE);
690: fnd_message.set_token('P_SQLERRM',SQLERRM);
691: fnd_message.set_token('P_API_NAME',l_api_name);
692: FND_MSG_PUB.add;
693: x_return_status := fnd_api.g_ret_sts_unexp_error;
694: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
687: ROLLBACK TO RES_AVAILABILITY_SP;
688: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
689: fnd_message.set_token('P_SQLCODE',SQLCODE);
690: fnd_message.set_token('P_SQLERRM',SQLERRM);
691: fnd_message.set_token('P_API_NAME',l_api_name);
692: FND_MSG_PUB.add;
693: x_return_status := fnd_api.g_ret_sts_unexp_error;
694: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
695: