99:
100: IF l_task_id IS NULL
101: THEN
102: x_return_status := fnd_api.g_ret_sts_unexp_error;
103: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_TEMP');
104: fnd_message.set_token ('P_TASK_TEMPLATE_ID', l_task_id);
105: fnd_msg_pub.add;
106: RAISE fnd_api.g_exc_unexpected_error;
107: END IF;
100: IF l_task_id IS NULL
101: THEN
102: x_return_status := fnd_api.g_ret_sts_unexp_error;
103: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_TEMP');
104: fnd_message.set_token ('P_TASK_TEMPLATE_ID', l_task_id);
105: fnd_msg_pub.add;
106: RAISE fnd_api.g_exc_unexpected_error;
107: END IF;
108:
121:
122: IF l_dependent_on_task_id IS NULL
123: THEN
124: x_return_status := fnd_api.g_ret_sts_unexp_error;
125: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_TEMP');
126: fnd_message.set_token ('P_TASK_TEMPLATE_ID', l_task_id);
127: RAISE fnd_api.g_exc_unexpected_error;
128: END IF;
129: ELSE
122: IF l_dependent_on_task_id IS NULL
123: THEN
124: x_return_status := fnd_api.g_ret_sts_unexp_error;
125: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_TEMP');
126: fnd_message.set_token ('P_TASK_TEMPLATE_ID', l_task_id);
127: RAISE fnd_api.g_exc_unexpected_error;
128: END IF;
129: ELSE
130: jtf_task_utl.validate_task (
142:
143: IF l_task_id IS NULL
144: THEN
145: x_return_status := fnd_api.g_ret_sts_unexp_error;
146: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_TASK');
147: fnd_message.set_token ('P_TASK_TEMPLATE_ID', l_task_id);
148: fnd_msg_pub.add;
149: RAISE fnd_api.g_exc_unexpected_error;
150: END IF;
143: IF l_task_id IS NULL
144: THEN
145: x_return_status := fnd_api.g_ret_sts_unexp_error;
146: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_TASK');
147: fnd_message.set_token ('P_TASK_TEMPLATE_ID', l_task_id);
148: fnd_msg_pub.add;
149: RAISE fnd_api.g_exc_unexpected_error;
150: END IF;
151:
165:
166: IF l_dependent_on_task_id IS NULL
167: THEN
168: x_return_status := fnd_api.g_ret_sts_unexp_error;
169: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_TASK');
170: fnd_message.set_token ('P_TASK_TEMPLATE_ID', l_task_id);
171: RAISE fnd_api.g_exc_unexpected_error;
172: END IF;
173:
166: IF l_dependent_on_task_id IS NULL
167: THEN
168: x_return_status := fnd_api.g_ret_sts_unexp_error;
169: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_TASK');
170: fnd_message.set_token ('P_TASK_TEMPLATE_ID', l_task_id);
171: RAISE fnd_api.g_exc_unexpected_error;
172: END IF;
173:
174: END IF;
242: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
243: WHEN OTHERS
244: THEN
245: ROLLBACK TO create_task_dependency_pub;
246: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
247: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
248: x_return_status := fnd_api.g_ret_sts_unexp_error;
249: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
250: END;
243: WHEN OTHERS
244: THEN
245: ROLLBACK TO create_task_dependency_pub;
246: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
247: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
248: x_return_status := fnd_api.g_ret_sts_unexp_error;
249: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
250: END;
251:
298:
299: EXCEPTION
300: WHEN Resource_Locked then
301: ROLLBACK TO lock_task_depends_pub;
302: fnd_message.set_name ('JTF', 'JTF_TASK_RESOURCE_LOCKED');
303: fnd_message.set_token ('P_LOCKED_RESOURCE', 'Contacts');
304: x_return_status := fnd_api.g_ret_sts_unexp_error;
305: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
306:
299: EXCEPTION
300: WHEN Resource_Locked then
301: ROLLBACK TO lock_task_depends_pub;
302: fnd_message.set_name ('JTF', 'JTF_TASK_RESOURCE_LOCKED');
303: fnd_message.set_token ('P_LOCKED_RESOURCE', 'Contacts');
304: x_return_status := fnd_api.g_ret_sts_unexp_error;
305: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
306:
307: WHEN fnd_api.g_exc_unexpected_error
311: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
312: WHEN OTHERS
313: THEN
314: ROLLBACK TO lock_task_depends_pub;
315: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
316: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
317: x_return_status := fnd_api.g_ret_sts_unexp_error;
318: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
319: END;
312: WHEN OTHERS
313: THEN
314: ROLLBACK TO lock_task_depends_pub;
315: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
316: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
317: x_return_status := fnd_api.g_ret_sts_unexp_error;
318: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
319: END;
320: /**********************************************************************************************************
414:
415: -- check if the dependency is invalid or null.
416: IF (l_dependency_id IS NULL)
417: THEN
418: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_DEPENDENCY_ID');
419: fnd_msg_pub.add;
420: x_return_status := fnd_api.g_ret_sts_unexp_error;
421: RAISE fnd_api.g_exc_unexpected_error;
422: END IF;
425: FETCH c_jtf_task_depends INTO task_depends;
426:
427: IF c_jtf_task_depends%NOTFOUND
428: THEN
429: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_DEPENDS_ID');
430: fnd_message.set_token ('P_DEPENDENCY_ID', p_dependency_id);
431: fnd_msg_pub.add;
432: x_return_status := fnd_api.g_ret_sts_unexp_error;
433: RAISE fnd_api.g_exc_unexpected_error;
426:
427: IF c_jtf_task_depends%NOTFOUND
428: THEN
429: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_DEPENDS_ID');
430: fnd_message.set_token ('P_DEPENDENCY_ID', p_dependency_id);
431: fnd_msg_pub.add;
432: x_return_status := fnd_api.g_ret_sts_unexp_error;
433: RAISE fnd_api.g_exc_unexpected_error;
434: END IF;
478:
479: IF l_dependent_on_task_id IS NULL
480: THEN
481: x_return_status := fnd_api.g_ret_sts_unexp_error;
482: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_TASK');
483: fnd_msg_pub.add;
484: RAISE fnd_api.g_exc_unexpected_error;
485: END IF;
486: ELSE
573: CLOSE c_jtf_task_depends;
574: END IF;
575:
576: ROLLBACK TO update_task_dependency_pub;
577: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
578: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
579: x_return_status := fnd_api.g_ret_sts_unexp_error;
580: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
581: END;
574: END IF;
575:
576: ROLLBACK TO update_task_dependency_pub;
577: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
578: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
579: x_return_status := fnd_api.g_ret_sts_unexp_error;
580: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
581: END;
582:
625: ---- if the dependency is null, then it is an error
626: IF (l_dependency_id IS NULL)
627: THEN
628:
629: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_DEPENDS');
630: fnd_msg_pub.add;
631: x_return_status := fnd_api.g_ret_sts_unexp_error;
632: RAISE fnd_api.g_exc_unexpected_error;
633: END IF;
637: FETCH c_jtf_task_depends INTO x;
638:
639: IF c_jtf_task_depends%NOTFOUND
640: THEN
641: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_DEPENDS_ID');
642: fnd_message.set_token('P_DEPENDENCY_ID',P_DEPENDENCY_ID);
643: fnd_msg_pub.add;
644: x_return_status := fnd_api.g_ret_sts_unexp_error;
645: RAISE fnd_api.g_exc_unexpected_error;
638:
639: IF c_jtf_task_depends%NOTFOUND
640: THEN
641: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_DEPENDS_ID');
642: fnd_message.set_token('P_DEPENDENCY_ID',P_DEPENDENCY_ID);
643: fnd_msg_pub.add;
644: x_return_status := fnd_api.g_ret_sts_unexp_error;
645: RAISE fnd_api.g_exc_unexpected_error;
646: ELSE
710: THEN
711: CLOSE c_jtf_task_depends;
712: END IF;
713:
714: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
715: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
716: x_return_status := fnd_api.g_ret_sts_unexp_error;
717: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
718: END; -- Delete Task dependency
711: CLOSE c_jtf_task_depends;
712: END IF;
713:
714: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
715: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
716: x_return_status := fnd_api.g_ret_sts_unexp_error;
717: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
718: END; -- Delete Task dependency
719: END;