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;
247: FETCH c_recur INTO rec_recur;
248: IF c_recur%NOTFOUND
249: THEN
250: CLOSE c_recur;
251: fnd_message.set_name ('JTF', 'JTF_TK_INVALID_RECUR_RULE');
252: fnd_message.set_token ('P_TASK_RECURRENCE_RULE_ID', p_add_assignee_rec.recurrence_rule_id);
253: fnd_msg_pub.add;
254:
255: x_return_status := fnd_api.g_ret_sts_unexp_error;
248: IF c_recur%NOTFOUND
249: THEN
250: CLOSE c_recur;
251: fnd_message.set_name ('JTF', 'JTF_TK_INVALID_RECUR_RULE');
252: fnd_message.set_token ('P_TASK_RECURRENCE_RULE_ID', p_add_assignee_rec.recurrence_rule_id);
253: fnd_msg_pub.add;
254:
255: x_return_status := fnd_api.g_ret_sts_unexp_error;
256: RAISE fnd_api.g_exc_unexpected_error;
418: fnd_profile.Value('ICX_DATE_FORMAT_MASK')||' HH:MI:SS AM');
419: END IF;
420:
421:
422: fnd_message.set_name ('JTF', 'JTF_APPT_RES_NOT_AVAILABLE');
423: fnd_message.set_token ('RES', l_name );
424: fnd_message.set_token ('DATE', l_date);
425:
426: fnd_msg_pub.add;
419: END IF;
420:
421:
422: fnd_message.set_name ('JTF', 'JTF_APPT_RES_NOT_AVAILABLE');
423: fnd_message.set_token ('RES', l_name );
424: fnd_message.set_token ('DATE', l_date);
425:
426: fnd_msg_pub.add;
427: x_return_status := fnd_api.g_ret_sts_unexp_error;
420:
421:
422: fnd_message.set_name ('JTF', 'JTF_APPT_RES_NOT_AVAILABLE');
423: fnd_message.set_token ('RES', l_name );
424: fnd_message.set_token ('DATE', l_date);
425:
426: fnd_msg_pub.add;
427: x_return_status := fnd_api.g_ret_sts_unexp_error;
428:
449: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
450: WHEN OTHERS
451: THEN
452: ROLLBACK TO add_assignee_pvt;
453: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
454: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
455: fnd_msg_pub.add;
456: x_return_status := fnd_api.g_ret_sts_unexp_error;
457: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
450: WHEN OTHERS
451: THEN
452: ROLLBACK TO add_assignee_pvt;
453: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
454: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
455: fnd_msg_pub.add;
456: x_return_status := fnd_api.g_ret_sts_unexp_error;
457: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
458: END add_assignee;
554: FETCH c_recur INTO rec_recur;
555: IF c_recur%NOTFOUND
556: THEN
557: CLOSE c_recur;
558: fnd_message.set_name ('JTF', 'JTF_TK_INVALID_RECUR_RULE');
559: fnd_message.set_token ('P_TASK_RECURRENCE_RULE_ID', p_delete_assignee_rec.recurrence_rule_id);
560: fnd_msg_pub.add;
561:
562: x_return_status := fnd_api.g_ret_sts_unexp_error;
555: IF c_recur%NOTFOUND
556: THEN
557: CLOSE c_recur;
558: fnd_message.set_name ('JTF', 'JTF_TK_INVALID_RECUR_RULE');
559: fnd_message.set_token ('P_TASK_RECURRENCE_RULE_ID', p_delete_assignee_rec.recurrence_rule_id);
560: fnd_msg_pub.add;
561:
562: x_return_status := fnd_api.g_ret_sts_unexp_error;
563: RAISE fnd_api.g_exc_unexpected_error;
702: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
703: WHEN OTHERS
704: THEN
705: ROLLBACK TO delete_assignee_pvt;
706: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
707: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
708: fnd_msg_pub.add;
709: x_return_status := fnd_api.g_ret_sts_unexp_error;
710: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
703: WHEN OTHERS
704: THEN
705: ROLLBACK TO delete_assignee_pvt;
706: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
707: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
708: fnd_msg_pub.add;
709: x_return_status := fnd_api.g_ret_sts_unexp_error;
710: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
711: END delete_assignee;