145: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
146: WHEN OTHERS
147: THEN
148: ROLLBACK TO response_invitation_pvt;
149: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
150: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
151: fnd_msg_pub.add;
152: x_return_status := fnd_api.g_ret_sts_unexp_error;
153: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
146: WHEN OTHERS
147: THEN
148: ROLLBACK TO response_invitation_pvt;
149: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
150: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
151: fnd_msg_pub.add;
152: x_return_status := fnd_api.g_ret_sts_unexp_error;
153: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
154: END response_invitation;
242: FETCH c_recur INTO rec_recur;
243: IF c_recur%NOTFOUND
244: THEN
245: CLOSE c_recur;
246: fnd_message.set_name ('JTF', 'JTF_TK_INVALID_RECUR_RULE');
247: fnd_message.set_token ('P_TASK_RECURRENCE_RULE_ID', p_add_assignee_rec.recurrence_rule_id);
248: fnd_msg_pub.add;
249:
250: x_return_status := fnd_api.g_ret_sts_unexp_error;
243: IF c_recur%NOTFOUND
244: THEN
245: CLOSE c_recur;
246: fnd_message.set_name ('JTF', 'JTF_TK_INVALID_RECUR_RULE');
247: fnd_message.set_token ('P_TASK_RECURRENCE_RULE_ID', p_add_assignee_rec.recurrence_rule_id);
248: fnd_msg_pub.add;
249:
250: x_return_status := fnd_api.g_ret_sts_unexp_error;
251: RAISE fnd_api.g_exc_unexpected_error;
394: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
395: WHEN OTHERS
396: THEN
397: ROLLBACK TO add_assignee_pvt;
398: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
399: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
400: fnd_msg_pub.add;
401: x_return_status := fnd_api.g_ret_sts_unexp_error;
402: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
395: WHEN OTHERS
396: THEN
397: ROLLBACK TO add_assignee_pvt;
398: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
399: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
400: fnd_msg_pub.add;
401: x_return_status := fnd_api.g_ret_sts_unexp_error;
402: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
403: END add_assignee;
499: FETCH c_recur INTO rec_recur;
500: IF c_recur%NOTFOUND
501: THEN
502: CLOSE c_recur;
503: fnd_message.set_name ('JTF', 'JTF_TK_INVALID_RECUR_RULE');
504: fnd_message.set_token ('P_TASK_RECURRENCE_RULE_ID', p_delete_assignee_rec.recurrence_rule_id);
505: fnd_msg_pub.add;
506:
507: x_return_status := fnd_api.g_ret_sts_unexp_error;
500: IF c_recur%NOTFOUND
501: THEN
502: CLOSE c_recur;
503: fnd_message.set_name ('JTF', 'JTF_TK_INVALID_RECUR_RULE');
504: fnd_message.set_token ('P_TASK_RECURRENCE_RULE_ID', p_delete_assignee_rec.recurrence_rule_id);
505: fnd_msg_pub.add;
506:
507: x_return_status := fnd_api.g_ret_sts_unexp_error;
508: RAISE fnd_api.g_exc_unexpected_error;
647: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
648: WHEN OTHERS
649: THEN
650: ROLLBACK TO delete_assignee_pvt;
651: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
652: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
653: fnd_msg_pub.add;
654: x_return_status := fnd_api.g_ret_sts_unexp_error;
655: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
648: WHEN OTHERS
649: THEN
650: ROLLBACK TO delete_assignee_pvt;
651: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
652: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
653: fnd_msg_pub.add;
654: x_return_status := fnd_api.g_ret_sts_unexp_error;
655: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
656: END delete_assignee;