92: x_return_status := fnd_api.g_ret_sts_success;
93:
94: IF fnd_api.to_boolean (p_init_msg_list)
95: THEN
96: fnd_msg_pub.initialize;
97: END IF;
98:
99: ----------------------------------------------------
100: FOR rec_assignments IN c_assignments(b_recurrence_rule_id => p_response_invitation_rec.recurrence_rule_id
135: THEN
136: COMMIT WORK;
137: END IF;
138:
139: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
140: EXCEPTION
141: WHEN fnd_api.g_exc_unexpected_error
142: THEN
143: ROLLBACK TO response_invitation_pvt;
141: WHEN fnd_api.g_exc_unexpected_error
142: THEN
143: ROLLBACK TO response_invitation_pvt;
144: x_return_status := fnd_api.g_ret_sts_unexp_error;
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');
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;
155:
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;
155:
156: PROCEDURE add_assignee(
157: p_api_version IN NUMBER,
199: x_return_status := fnd_api.g_ret_sts_success;
200:
201: IF fnd_api.to_boolean (p_init_msg_list)
202: THEN
203: fnd_msg_pub.initialize;
204: END IF;
205:
206: ----------------------------------------------------------
207: -- Check whether the current task_id is the first task_id
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;
252: END IF;
384: THEN
385: COMMIT WORK;
386: END IF;
387:
388: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
389: EXCEPTION
390: WHEN fnd_api.g_exc_unexpected_error
391: THEN
392: ROLLBACK TO add_assignee_pvt;
390: WHEN fnd_api.g_exc_unexpected_error
391: THEN
392: ROLLBACK TO add_assignee_pvt;
393: x_return_status := fnd_api.g_ret_sts_unexp_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');
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;
404:
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;
404:
405: PROCEDURE delete_assignee(
406: p_api_version IN NUMBER,
453: x_return_status := fnd_api.g_ret_sts_success;
454:
455: IF fnd_api.to_boolean (p_init_msg_list)
456: THEN
457: fnd_msg_pub.initialize;
458: END IF;
459:
460: ----------------------------------------------------
461: ----------------------------------------------------------
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;
509: END IF;
637: THEN
638: COMMIT WORK;
639: END IF;
640:
641: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
642: EXCEPTION
643: WHEN fnd_api.g_exc_unexpected_error
644: THEN
645: ROLLBACK TO delete_assignee_pvt;
643: WHEN fnd_api.g_exc_unexpected_error
644: THEN
645: ROLLBACK TO delete_assignee_pvt;
646: x_return_status := fnd_api.g_ret_sts_unexp_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');
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;
657:
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;
657:
658: END jtf_task_repeat_assignment_pvt;