90: END IF;
91:
92: WHEN OTHERS THEN
93: ROLLBACK TO create_contact_preference_sv;
94: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
95: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
96: fnd_msg_pub.add;
97: x_return_status := fnd_api.g_ret_sts_unexp_error;
98: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
91:
92: WHEN OTHERS THEN
93: ROLLBACK TO create_contact_preference_sv;
94: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
95: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
96: fnd_msg_pub.add;
97: x_return_status := fnd_api.g_ret_sts_unexp_error;
98: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
99: IF c_preference%ISOPEN THEN
150: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
151:
152: WHEN OTHERS THEN
153: ROLLBACK TO delete_contact_preference_sv;
154: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
155: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
156: fnd_msg_pub.add;
157: x_return_status := fnd_api.g_ret_sts_unexp_error;
158: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
151:
152: WHEN OTHERS THEN
153: ROLLBACK TO delete_contact_preference_sv;
154: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
155: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
156: fnd_msg_pub.add;
157: x_return_status := fnd_api.g_ret_sts_unexp_error;
158: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
159: