DBA Data[Home] [Help]

APPS.JTF_TASK_REPEAT_APPT_PVT dependencies on FND_API

Line 118: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,

114: END modify_time;
115:
116: PROCEDURE update_repeat_appointment(
117: p_api_version IN NUMBER,
118: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
119: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
120: p_object_version_number IN OUT NOCOPY NUMBER,
121: p_updated_field_rec IN updated_field_rec,
122: x_return_status OUT NOCOPY VARCHAR2,

Line 119: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,

115:
116: PROCEDURE update_repeat_appointment(
117: p_api_version IN NUMBER,
118: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
119: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
120: p_object_version_number IN OUT NOCOPY NUMBER,
121: p_updated_field_rec IN updated_field_rec,
122: x_return_status OUT NOCOPY VARCHAR2,
123: x_msg_count OUT NOCOPY NUMBER,

Line 175: x_return_status := fnd_api.g_ret_sts_success;

171:
172: BEGIN
173: SAVEPOINT update_repeat_appointment_pvt;
174:
175: x_return_status := fnd_api.g_ret_sts_success;
176:
177: IF fnd_api.to_boolean (p_init_msg_list)
178: THEN
179: fnd_msg_pub.initialize;

Line 177: IF fnd_api.to_boolean (p_init_msg_list)

173: SAVEPOINT update_repeat_appointment_pvt;
174:
175: x_return_status := fnd_api.g_ret_sts_success;
176:
177: IF fnd_api.to_boolean (p_init_msg_list)
178: THEN
179: fnd_msg_pub.initialize;
180: END IF;
181:

Line 380: IF NOT (x_return_status = fnd_api.g_ret_sts_success)

376: p_child_sequence_num => jtf_task_utl.g_miss_number,
377: p_location_id => p_updated_field_rec.location_id
378: );
379:
380: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
381: THEN
382: x_return_status := fnd_api.g_ret_sts_unexp_error;
383: RAISE fnd_api.g_exc_unexpected_error;
384: END IF;

Line 382: x_return_status := fnd_api.g_ret_sts_unexp_error;

378: );
379:
380: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
381: THEN
382: x_return_status := fnd_api.g_ret_sts_unexp_error;
383: RAISE fnd_api.g_exc_unexpected_error;
384: END IF;
385:
386: --------------------------------------------------------

Line 383: RAISE fnd_api.g_exc_unexpected_error;

379:
380: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
381: THEN
382: x_return_status := fnd_api.g_ret_sts_unexp_error;
383: RAISE fnd_api.g_exc_unexpected_error;
384: END IF;
385:
386: --------------------------------------------------------
387: -- Nullify recurrence_rule_id for this appointment

Line 421: x_return_status := fnd_api.g_ret_sts_unexp_error;

417: fnd_message.set_name ('JTF', 'JTF_TK_INVALID_RECUR_RULE');
418: fnd_message.set_token ('P_TASK_RECURRENCE_RULE_ID', p_updated_field_rec.recurrence_rule_id);
419: fnd_msg_pub.add;
420:
421: x_return_status := fnd_api.g_ret_sts_unexp_error;
422: RAISE fnd_api.g_exc_unexpected_error;
423: END IF;
424: CLOSE c_recur;
425:

Line 422: RAISE fnd_api.g_exc_unexpected_error;

418: fnd_message.set_token ('P_TASK_RECURRENCE_RULE_ID', p_updated_field_rec.recurrence_rule_id);
419: fnd_msg_pub.add;
420:
421: x_return_status := fnd_api.g_ret_sts_unexp_error;
422: RAISE fnd_api.g_exc_unexpected_error;
423: END IF;
424: CLOSE c_recur;
425:
426: SELECT jtf_task_recur_rules_s.NEXTVAL

Line 620: IF NOT (x_return_status = fnd_api.g_ret_sts_success)

616: cac_view_util_pvt.update_repeat_collab_details(
617: p_source_task_id => p_updated_field_rec.task_id,
618: p_target_task_id => rec_future.task_id );
619:
620: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
621: THEN
622: x_return_status := fnd_api.g_ret_sts_unexp_error;
623: RAISE fnd_api.g_exc_unexpected_error;
624: END IF;

Line 622: x_return_status := fnd_api.g_ret_sts_unexp_error;

618: p_target_task_id => rec_future.task_id );
619:
620: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
621: THEN
622: x_return_status := fnd_api.g_ret_sts_unexp_error;
623: RAISE fnd_api.g_exc_unexpected_error;
624: END IF;
625:
626: UPDATE jtf_tasks_b

Line 623: RAISE fnd_api.g_exc_unexpected_error;

619:
620: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
621: THEN
622: x_return_status := fnd_api.g_ret_sts_unexp_error;
623: RAISE fnd_api.g_exc_unexpected_error;
624: END IF;
625:
626: UPDATE jtf_tasks_b
627: SET recurrence_rule_id = l_new_recurrence_rule_id

Line 780: IF NOT (x_return_status = fnd_api.g_ret_sts_success)

776: cac_view_util_pvt.update_repeat_collab_details(
777: p_source_task_id => p_updated_field_rec.task_id,
778: p_target_task_id => rec_all.task_id );
779:
780: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
781: THEN
782: x_return_status := fnd_api.g_ret_sts_unexp_error;
783: RAISE fnd_api.g_exc_unexpected_error;
784: END IF;

Line 782: x_return_status := fnd_api.g_ret_sts_unexp_error;

778: p_target_task_id => rec_all.task_id );
779:
780: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
781: THEN
782: x_return_status := fnd_api.g_ret_sts_unexp_error;
783: RAISE fnd_api.g_exc_unexpected_error;
784: END IF;
785:
786: IF rec_all.task_id = p_updated_field_rec.task_id

Line 783: RAISE fnd_api.g_exc_unexpected_error;

779:
780: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
781: THEN
782: x_return_status := fnd_api.g_ret_sts_unexp_error;
783: RAISE fnd_api.g_exc_unexpected_error;
784: END IF;
785:
786: IF rec_all.task_id = p_updated_field_rec.task_id
787: THEN

Line 800: IF fnd_api.to_boolean (p_commit)

796: END LOOP;
797:
798: END IF; -- end-if trunc(tasks.calendar_start_date) <> trunc(l_calendar_start_date)
799:
800: IF fnd_api.to_boolean (p_commit)
801: THEN
802: COMMIT WORK;
803: END IF;
804:

Line 807: WHEN fnd_api.g_exc_unexpected_error

803: END IF;
804:
805: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
806: EXCEPTION
807: WHEN fnd_api.g_exc_unexpected_error
808: THEN
809: ROLLBACK TO update_repeat_appointment_pvt;
810: x_return_status := fnd_api.g_ret_sts_unexp_error;
811: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 810: x_return_status := fnd_api.g_ret_sts_unexp_error;

806: EXCEPTION
807: WHEN fnd_api.g_exc_unexpected_error
808: THEN
809: ROLLBACK TO update_repeat_appointment_pvt;
810: x_return_status := fnd_api.g_ret_sts_unexp_error;
811: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
812: WHEN OTHERS
813: THEN
814: ROLLBACK TO update_repeat_appointment_pvt;

Line 818: x_return_status := fnd_api.g_ret_sts_unexp_error;

814: ROLLBACK TO update_repeat_appointment_pvt;
815: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
816: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
817: fnd_msg_pub.add;
818: x_return_status := fnd_api.g_ret_sts_unexp_error;
819: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
820: END update_repeat_appointment;
821:
822: END JTF_TASK_REPEAT_APPT_PVT;