179:
180: IF c_status%NOTFOUND
181: THEN
182: CLOSE c_status;
183: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_STATUS_ID');
184: fnd_message.set_token ('P_TASK_STATUS_ID', p_task_status_id);
185: fnd_msg_pub.add;
186: RAISE fnd_api.g_exc_unexpected_error;
187: END IF;
180: IF c_status%NOTFOUND
181: THEN
182: CLOSE c_status;
183: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_STATUS_ID');
184: fnd_message.set_token ('P_TASK_STATUS_ID', p_task_status_id);
185: fnd_msg_pub.add;
186: RAISE fnd_api.g_exc_unexpected_error;
187: END IF;
188: CLOSE c_status;
367: x_return_status := fnd_api.g_ret_sts_unexp_error;
368:
369: WHEN OTHERS
370: THEN
371: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
372: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
373: fnd_msg_pub.add;
374: x_return_status := fnd_api.g_ret_sts_unexp_error;
375: end;
368:
369: WHEN OTHERS
370: THEN
371: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
372: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
373: fnd_msg_pub.add;
374: x_return_status := fnd_api.g_ret_sts_unexp_error;
375: end;
376:
409:
410: IF c_status%NOTFOUND
411: THEN
412: CLOSE c_status;
413: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_STATUS_ID');
414: fnd_message.set_token ('P_TASK_STATUS_ID', p_task_status_id);
415: fnd_msg_pub.add;
416: RAISE fnd_api.g_exc_unexpected_error;
417: END IF;
410: IF c_status%NOTFOUND
411: THEN
412: CLOSE c_status;
413: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_STATUS_ID');
414: fnd_message.set_token ('P_TASK_STATUS_ID', p_task_status_id);
415: fnd_msg_pub.add;
416: RAISE fnd_api.g_exc_unexpected_error;
417: END IF;
418: CLOSE c_status;
458: IF p_planned_start_date IS NULL
459: THEN
460: -- If date type is deriven by planned start date and its value is null
461: -- then throw an error "The planned start date must be provided."
462: fnd_message.set_name ('JTF', 'JTF_TASK_NULL_PLANNED_ST_DATE');
463: fnd_msg_pub.add;
464: x_return_status := fnd_api.g_ret_sts_unexp_error;
465: END IF;
466:
471: IF p_scheduled_start_date IS NULL
472: THEN
473: -- If date type is deriven by schedule start date and its value is null,
474: -- then throw an error "The scheduled start date must be provided."
475: fnd_message.set_name ('JTF', 'JTF_TASK_NULL_SCHEDULE_ST_DATE');
476: fnd_msg_pub.add;
477: x_return_status := fnd_api.g_ret_sts_unexp_error;
478: END IF;
479:
484: IF p_actual_start_date IS NULL
485: THEN
486: -- If date type is deriven by actual start date and its value is null
487: -- then throw an error "The actual start date must be provided."
488: fnd_message.set_name ('JTF', 'JTF_TASK_NULL_ACTUAL_ST_DATE');
489: fnd_msg_pub.add;
490: x_return_status := fnd_api.g_ret_sts_unexp_error;
491: END IF;
492:
504: IF p_planned_end_date IS NULL
505: THEN
506: -- If date type is deriven by planned end date and its value is null
507: -- then throw an error "The planned end date must be provided."
508: fnd_message.set_name ('JTF', 'JTF_TASK_NULL_PLANNED_EN_DATE');
509: fnd_msg_pub.add;
510: x_return_status := fnd_api.g_ret_sts_unexp_error;
511: END IF;
512:
517: IF p_scheduled_end_date IS NULL
518: THEN
519: -- If date type is deriven by schedule end date and its value is null,
520: -- then throw an error "The scheduled end date must be provided."
521: fnd_message.set_name ('JTF', 'JTF_TASK_NULL_SCHEDULE_EN_DATE');
522: fnd_msg_pub.add;
523: x_return_status := fnd_api.g_ret_sts_unexp_error;
524: END IF;
525:
530: IF p_actual_end_date IS NULL
531: THEN
532: -- If date type is deriven by actual end date and its value is null
533: -- then throw an error "The actual end date must be provided."
534: fnd_message.set_name ('JTF', 'JTF_TASK_NULL_ACTUAL_EN_DATE');
535: fnd_msg_pub.add;
536: x_return_status := fnd_api.g_ret_sts_unexp_error;
537: END IF;
538:
549: x_return_status := fnd_api.g_ret_sts_unexp_error;
550:
551: WHEN OTHERS THEN
552: x_return_status := fnd_api.g_ret_sts_unexp_error;
553: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
554: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
555: fnd_msg_pub.add;
556: END set_start_n_due_date;
557:
550:
551: WHEN OTHERS THEN
552: x_return_status := fnd_api.g_ret_sts_unexp_error;
553: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
554: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
555: fnd_msg_pub.add;
556: END set_start_n_due_date;
557:
558: ------------------------------------------------------
591:
592: IF c_seq%NOTFOUND
593: THEN
594: CLOSE c_seq;
595: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_SEQ');
596: fnd_message.set_token ('P_SEQ', p_sequence_name);
597: fnd_msg_pub.add;
598: raise fnd_api.g_exc_unexpected_error;
599: END IF;
592: IF c_seq%NOTFOUND
593: THEN
594: CLOSE c_seq;
595: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_SEQ');
596: fnd_message.set_token ('P_SEQ', p_sequence_name);
597: fnd_msg_pub.add;
598: raise fnd_api.g_exc_unexpected_error;
599: END IF;
600: CLOSE c_seq;
628: LOOP
629: IF (p_parent_task_id = cyclic_task_rec.task_id)
630: THEN
631: x_return_status := fnd_api.g_ret_sts_unexp_error;
632: fnd_message.set_name ('JTF', 'JTF_TASK_CYCLIC_TASKS');
633: fnd_message.set_token ('P_TASK_NAME', jtf_task_utl_ext.get_task_name(p_task_id));
634: fnd_message.set_token ('P_PARENT_TASK_NAME', jtf_task_utl_ext.get_task_name(p_parent_task_id));
635: fnd_msg_pub.add;
636: END IF;
629: IF (p_parent_task_id = cyclic_task_rec.task_id)
630: THEN
631: x_return_status := fnd_api.g_ret_sts_unexp_error;
632: fnd_message.set_name ('JTF', 'JTF_TASK_CYCLIC_TASKS');
633: fnd_message.set_token ('P_TASK_NAME', jtf_task_utl_ext.get_task_name(p_task_id));
634: fnd_message.set_token ('P_PARENT_TASK_NAME', jtf_task_utl_ext.get_task_name(p_parent_task_id));
635: fnd_msg_pub.add;
636: END IF;
637: END LOOP;
630: THEN
631: x_return_status := fnd_api.g_ret_sts_unexp_error;
632: fnd_message.set_name ('JTF', 'JTF_TASK_CYCLIC_TASKS');
633: fnd_message.set_token ('P_TASK_NAME', jtf_task_utl_ext.get_task_name(p_task_id));
634: fnd_message.set_token ('P_PARENT_TASK_NAME', jtf_task_utl_ext.get_task_name(p_parent_task_id));
635: fnd_msg_pub.add;
636: END IF;
637: END LOOP;
638:
796:
797: IF c_object%NOTFOUND
798: THEN
799: CLOSE c_object;
800: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_OBJECT_CODE');
801: fnd_message.set_token ('P_OBJECT_CODE', p_object_code);
802: fnd_msg_pub.add;
803: RAISE fnd_api.g_exc_unexpected_error;
804: END IF;
797: IF c_object%NOTFOUND
798: THEN
799: CLOSE c_object;
800: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_OBJECT_CODE');
801: fnd_message.set_token ('P_OBJECT_CODE', p_object_code);
802: fnd_msg_pub.add;
803: RAISE fnd_api.g_exc_unexpected_error;
804: END IF;
805: CLOSE c_object;