176:
177: -- DBMS_OUTPUT.put_line (SQLCODE || SQLERRM);
178:
179: ROLLBACK TO create_resource_member_pub;
180: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
181: fnd_message.set_token('P_SQLCODE',SQLCODE);
182: fnd_message.set_token('P_SQLERRM',SQLERRM);
183: fnd_message.set_token('P_API_NAME',l_api_name);
184: FND_MSG_PUB.add;
177: -- DBMS_OUTPUT.put_line (SQLCODE || SQLERRM);
178:
179: ROLLBACK TO create_resource_member_pub;
180: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
181: fnd_message.set_token('P_SQLCODE',SQLCODE);
182: fnd_message.set_token('P_SQLERRM',SQLERRM);
183: fnd_message.set_token('P_API_NAME',l_api_name);
184: FND_MSG_PUB.add;
185:
178:
179: ROLLBACK TO create_resource_member_pub;
180: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
181: fnd_message.set_token('P_SQLCODE',SQLCODE);
182: fnd_message.set_token('P_SQLERRM',SQLERRM);
183: fnd_message.set_token('P_API_NAME',l_api_name);
184: FND_MSG_PUB.add;
185:
186: x_return_status := fnd_api.g_ret_sts_unexp_error;
179: ROLLBACK TO create_resource_member_pub;
180: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
181: fnd_message.set_token('P_SQLCODE',SQLCODE);
182: fnd_message.set_token('P_SQLERRM',SQLERRM);
183: fnd_message.set_token('P_API_NAME',l_api_name);
184: FND_MSG_PUB.add;
185:
186: x_return_status := fnd_api.g_ret_sts_unexp_error;
187:
352:
353: -- DBMS_OUTPUT.put_line (SQLCODE || SQLERRM);
354:
355: ROLLBACK TO update_resource_member_pub;
356: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
357: fnd_message.set_token('P_SQLCODE',SQLCODE);
358: fnd_message.set_token('P_SQLERRM',SQLERRM);
359: fnd_message.set_token('P_API_NAME',l_api_name);
360: FND_MSG_PUB.add;
353: -- DBMS_OUTPUT.put_line (SQLCODE || SQLERRM);
354:
355: ROLLBACK TO update_resource_member_pub;
356: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
357: fnd_message.set_token('P_SQLCODE',SQLCODE);
358: fnd_message.set_token('P_SQLERRM',SQLERRM);
359: fnd_message.set_token('P_API_NAME',l_api_name);
360: FND_MSG_PUB.add;
361:
354:
355: ROLLBACK TO update_resource_member_pub;
356: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
357: fnd_message.set_token('P_SQLCODE',SQLCODE);
358: fnd_message.set_token('P_SQLERRM',SQLERRM);
359: fnd_message.set_token('P_API_NAME',l_api_name);
360: FND_MSG_PUB.add;
361:
362: x_return_status := fnd_api.g_ret_sts_unexp_error;
355: ROLLBACK TO update_resource_member_pub;
356: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
357: fnd_message.set_token('P_SQLCODE',SQLCODE);
358: fnd_message.set_token('P_SQLERRM',SQLERRM);
359: fnd_message.set_token('P_API_NAME',l_api_name);
360: FND_MSG_PUB.add;
361:
362: x_return_status := fnd_api.g_ret_sts_unexp_error;
363:
461:
462: IF p_resource_id IS NULL AND p_resource_number is NULL THEN
463:
464:
465: fnd_message.set_name('JTF', 'JTF_RS_RESOURCE_NULL');
466: fnd_msg_pub.add;
467:
468: x_return_status := fnd_api.g_ret_sts_unexp_error;
469: RAISE fnd_api.g_exc_unexpected_error;
478: IF c_resource_id%NOTFOUND THEN
479:
480: -- dbms_output.put_line('Invalid or Inactive Resource');
481:
482: fnd_message.set_name('JTF', 'JTF_RS_INVALID_RESOURCE');
483: fnd_message.set_token('P_RESOURCE_ID', p_resource_id);
484: fnd_msg_pub.add;
485:
486: x_return_status := fnd_api.g_ret_sts_unexp_error;
479:
480: -- dbms_output.put_line('Invalid or Inactive Resource');
481:
482: fnd_message.set_name('JTF', 'JTF_RS_INVALID_RESOURCE');
483: fnd_message.set_token('P_RESOURCE_ID', p_resource_id);
484: fnd_msg_pub.add;
485:
486: x_return_status := fnd_api.g_ret_sts_unexp_error;
487: RAISE fnd_api.g_exc_unexpected_error;
498:
499: IF c_resource_number%NOTFOUND THEN
500:
501:
502: fnd_message.set_name('JTF', 'JTF_RS_INVALID_RESOURCE_NUMBER');
503: fnd_message.set_token('P_RESOURCE_NUMBER', p_resource_number);
504: fnd_msg_pub.add;
505:
506: x_return_status := fnd_api.g_ret_sts_unexp_error;
499: IF c_resource_number%NOTFOUND THEN
500:
501:
502: fnd_message.set_name('JTF', 'JTF_RS_INVALID_RESOURCE_NUMBER');
503: fnd_message.set_token('P_RESOURCE_NUMBER', p_resource_number);
504: fnd_msg_pub.add;
505:
506: x_return_status := fnd_api.g_ret_sts_unexp_error;
507: RAISE fnd_api.g_exc_unexpected_error;
571:
572: -- DBMS_OUTPUT.put_line (SQLCODE || SQLERRM);
573:
574: ROLLBACK TO delete_resource_member_pub;
575: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
576: fnd_message.set_token('P_SQLCODE',SQLCODE);
577: fnd_message.set_token('P_SQLERRM',SQLERRM);
578: fnd_message.set_token('P_API_NAME',l_api_name);
579: FND_MSG_PUB.add;
572: -- DBMS_OUTPUT.put_line (SQLCODE || SQLERRM);
573:
574: ROLLBACK TO delete_resource_member_pub;
575: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
576: fnd_message.set_token('P_SQLCODE',SQLCODE);
577: fnd_message.set_token('P_SQLERRM',SQLERRM);
578: fnd_message.set_token('P_API_NAME',l_api_name);
579: FND_MSG_PUB.add;
580:
573:
574: ROLLBACK TO delete_resource_member_pub;
575: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
576: fnd_message.set_token('P_SQLCODE',SQLCODE);
577: fnd_message.set_token('P_SQLERRM',SQLERRM);
578: fnd_message.set_token('P_API_NAME',l_api_name);
579: FND_MSG_PUB.add;
580:
581: x_return_status := fnd_api.g_ret_sts_unexp_error;
574: ROLLBACK TO delete_resource_member_pub;
575: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
576: fnd_message.set_token('P_SQLCODE',SQLCODE);
577: fnd_message.set_token('P_SQLERRM',SQLERRM);
578: fnd_message.set_token('P_API_NAME',l_api_name);
579: FND_MSG_PUB.add;
580:
581: x_return_status := fnd_api.g_ret_sts_unexp_error;
582: