371: FETCH c_task INTO rec_task;
372: IF c_task%NOTFOUND
373: THEN
374: CLOSE c_task;
375: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_TASK_ID');
376: fnd_message.set_token ('P_TASK_ID', l_task_id);
377: fnd_msg_pub.add;
378: x_return_status := fnd_api.g_ret_sts_unexp_error;
379: RAISE fnd_api.g_exc_unexpected_error;
372: IF c_task%NOTFOUND
373: THEN
374: CLOSE c_task;
375: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_TASK_ID');
376: fnd_message.set_token ('P_TASK_ID', l_task_id);
377: fnd_msg_pub.add;
378: x_return_status := fnd_api.g_ret_sts_unexp_error;
379: RAISE fnd_api.g_exc_unexpected_error;
380: END IF;
412: RETURN;
413: ELSIF p_add_option IS NOT NULL AND
414: p_add_option <> JTF_TASK_REPEAT_APPT_PVT.G_SKIP
415: THEN
416: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_FLAG');
417: fnd_message.set_token ('P_FLAG_NAME', 'The parameter p_add_option ');
418: fnd_msg_pub.add;
419:
420: x_return_status := fnd_api.g_ret_sts_unexp_error;
413: ELSIF p_add_option IS NOT NULL AND
414: p_add_option <> JTF_TASK_REPEAT_APPT_PVT.G_SKIP
415: THEN
416: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_FLAG');
417: fnd_message.set_token ('P_FLAG_NAME', 'The parameter p_add_option ');
418: fnd_msg_pub.add;
419:
420: x_return_status := fnd_api.g_ret_sts_unexp_error;
421: RAISE fnd_api.g_exc_unexpected_error;
427: THEN
428: IF p_task_assignment_id > jtf_task_utl_ext.get_last_number('JTF_TASK_ASSIGNMENTS_S') and -- Enh# 2734020
429: p_task_assignment_id < 1e+12
430: THEN
431: fnd_message.set_name ('JTF', 'JTF_TASK_OUT_OF_RANGE');
432: fnd_msg_pub.add;
433: x_return_status := fnd_api.g_ret_sts_unexp_error;
434: RAISE fnd_api.g_exc_unexpected_error;
435: ELSE
510: );
511:
512: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
513: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
514: fnd_message.set_name ('JTF', 'JTF_TASK_DUP_TK_ASS');
515: fnd_msg_pub.add;
516: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
517: END IF;
518:
580: IF ra_cur1%NOTFOUND
581: THEN
582: CLOSE ra_cur1; -- Fix a missing CLOSE on 4/18/2002
583: x_return_status := fnd_api.g_ret_sts_unexp_error;
584: fnd_message.set_name ('JTF', 'JTF_TASK_INV_TK_ASS');
585: fnd_msg_pub.add;
586: RAISE fnd_api.g_exc_unexpected_error;
587: ELSE
588: x_task_assignment_id := l_task_assignment_id;
612: jtf_task_wf_events_pvt.publish_create_assignment(l_assignment_rec, x_event_return_status);
613:
614: IF (x_event_return_status = 'WARNING')
615: THEN
616: fnd_message.set_name ('JTF', 'JTF_TASK_ASS_EVENT_WARNING');
617: fnd_message.set_token ('P_ASSIGNMENT_ID', l_task_assignment_id);
618: fnd_msg_pub.add;
619: ELSIF(x_event_return_status = 'ERROR')
620: THEN
613:
614: IF (x_event_return_status = 'WARNING')
615: THEN
616: fnd_message.set_name ('JTF', 'JTF_TASK_ASS_EVENT_WARNING');
617: fnd_message.set_token ('P_ASSIGNMENT_ID', l_task_assignment_id);
618: fnd_msg_pub.add;
619: ELSIF(x_event_return_status = 'ERROR')
620: THEN
621: fnd_message.set_name ('JTF', 'JTF_TASK_ASS_EVENT_ERROR');
617: fnd_message.set_token ('P_ASSIGNMENT_ID', l_task_assignment_id);
618: fnd_msg_pub.add;
619: ELSIF(x_event_return_status = 'ERROR')
620: THEN
621: fnd_message.set_name ('JTF', 'JTF_TASK_ASS_EVENT_ERROR');
622: fnd_message.set_token ('P_ASSIGNMENT_ID', l_task_assignment_id);
623: fnd_msg_pub.add;
624: x_return_status := fnd_api.g_ret_sts_unexp_error;
625: RAISE fnd_api.g_exc_unexpected_error;
618: fnd_msg_pub.add;
619: ELSIF(x_event_return_status = 'ERROR')
620: THEN
621: fnd_message.set_name ('JTF', 'JTF_TASK_ASS_EVENT_ERROR');
622: fnd_message.set_token ('P_ASSIGNMENT_ID', l_task_assignment_id);
623: fnd_msg_pub.add;
624: x_return_status := fnd_api.g_ret_sts_unexp_error;
625: RAISE fnd_api.g_exc_unexpected_error;
626: END IF ;
662: );
663: WHEN OTHERS
664: THEN
665: ROLLBACK TO create_task_assign_pvt;
666: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
667: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
668: fnd_msg_pub.add;
669: x_return_status := fnd_api.g_ret_sts_unexp_error;
670: fnd_msg_pub.count_and_get (
663: WHEN OTHERS
664: THEN
665: ROLLBACK TO create_task_assign_pvt;
666: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
667: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
668: fnd_msg_pub.add;
669: x_return_status := fnd_api.g_ret_sts_unexp_error;
670: fnd_msg_pub.count_and_get (
671: p_count => x_msg_count,
1732:
1733: IF task_ass_u%NOTFOUND
1734: THEN
1735: CLOSE task_ass_u;
1736: fnd_message.set_name ('JTF', 'JTF_TASK_INS_TK_ASS');
1737: fnd_message.set_token ('TASK_ASSIGNMENT', p_task_assignment_id);
1738: fnd_msg_pub.add;
1739: x_return_status := fnd_api.g_ret_sts_unexp_error;
1740: RAISE fnd_api.g_exc_unexpected_error;
1733: IF task_ass_u%NOTFOUND
1734: THEN
1735: CLOSE task_ass_u;
1736: fnd_message.set_name ('JTF', 'JTF_TASK_INS_TK_ASS');
1737: fnd_message.set_token ('TASK_ASSIGNMENT', p_task_assignment_id);
1738: fnd_msg_pub.add;
1739: x_return_status := fnd_api.g_ret_sts_unexp_error;
1740: RAISE fnd_api.g_exc_unexpected_error;
1741: END IF;
1747:
1748: IF jtf_task_utl.c_ass_orig%NOTFOUND
1749: THEN
1750: CLOSE jtf_task_utl.c_ass_orig;
1751: fnd_message.set_name ('JTF', 'JTF_TASK_INS_TK_ASS');
1752: fnd_message.set_token ('TASK_ASSIGNMENT', p_task_assignment_id);
1753: fnd_msg_pub.add;
1754: x_return_status := fnd_api.g_ret_sts_unexp_error;
1755: RAISE fnd_api.g_exc_unexpected_error;
1748: IF jtf_task_utl.c_ass_orig%NOTFOUND
1749: THEN
1750: CLOSE jtf_task_utl.c_ass_orig;
1751: fnd_message.set_name ('JTF', 'JTF_TASK_INS_TK_ASS');
1752: fnd_message.set_token ('TASK_ASSIGNMENT', p_task_assignment_id);
1753: fnd_msg_pub.add;
1754: x_return_status := fnd_api.g_ret_sts_unexp_error;
1755: RAISE fnd_api.g_exc_unexpected_error;
1756: END IF;
1807: , l_entity;
1808: IF c_task%NOTFOUND
1809: THEN
1810: CLOSE c_task;
1811: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_TASK_ID');
1812: fnd_message.set_token ('P_TASK_ID', l_task_id);
1813: fnd_msg_pub.add;
1814: x_return_status := fnd_api.g_ret_sts_unexp_error;
1815: RAISE fnd_api.g_exc_unexpected_error;
1808: IF c_task%NOTFOUND
1809: THEN
1810: CLOSE c_task;
1811: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_TASK_ID');
1812: fnd_message.set_token ('P_TASK_ID', l_task_id);
1813: fnd_msg_pub.add;
1814: x_return_status := fnd_api.g_ret_sts_unexp_error;
1815: RAISE fnd_api.g_exc_unexpected_error;
1816: END IF;
1994: );
1995:
1996: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1997: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
1998: fnd_message.set_name ('JTF', 'JTF_TASK_DUP_TK_ASS');
1999: fnd_msg_pub.add;
2000: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2001: END IF;
2002:
2137: jtf_task_wf_events_pvt.publish_update_assignment(l_assignment_rec_new,l_assignment_rec_old,x_event_return_status);
2138:
2139: IF (x_event_return_status = 'WARNING')
2140: THEN
2141: fnd_message.set_name ('JTF', 'JTF_TASK_ASS_EVENT_WARNING');
2142: fnd_message.set_token ('P_ASSIGNMENT_ID', l_task_assignment_id);
2143: fnd_msg_pub.add;
2144: ELSIF(x_event_return_status = 'ERROR')
2145: THEN
2138:
2139: IF (x_event_return_status = 'WARNING')
2140: THEN
2141: fnd_message.set_name ('JTF', 'JTF_TASK_ASS_EVENT_WARNING');
2142: fnd_message.set_token ('P_ASSIGNMENT_ID', l_task_assignment_id);
2143: fnd_msg_pub.add;
2144: ELSIF(x_event_return_status = 'ERROR')
2145: THEN
2146: fnd_message.set_name ('JTF', 'JTF_TASK_ASS_EVENT_ERROR');
2142: fnd_message.set_token ('P_ASSIGNMENT_ID', l_task_assignment_id);
2143: fnd_msg_pub.add;
2144: ELSIF(x_event_return_status = 'ERROR')
2145: THEN
2146: fnd_message.set_name ('JTF', 'JTF_TASK_ASS_EVENT_ERROR');
2147: fnd_message.set_token ('P_ASSIGNMENT_ID', l_task_assignment_id);
2148: fnd_msg_pub.add;
2149: x_return_status := fnd_api.g_ret_sts_unexp_error;
2150: RAISE fnd_api.g_exc_unexpected_error;
2143: fnd_msg_pub.add;
2144: ELSIF(x_event_return_status = 'ERROR')
2145: THEN
2146: fnd_message.set_name ('JTF', 'JTF_TASK_ASS_EVENT_ERROR');
2147: fnd_message.set_token ('P_ASSIGNMENT_ID', l_task_assignment_id);
2148: fnd_msg_pub.add;
2149: x_return_status := fnd_api.g_ret_sts_unexp_error;
2150: RAISE fnd_api.g_exc_unexpected_error;
2151: END IF ;
2186:
2187: ROLLBACK TO update_task_assign_pvt;
2188:
2189: -- Added by SBARAT on 23/05/2006 for bug# 5176073
2190: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
2191: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
2192: fnd_msg_pub.add;
2193:
2194: x_return_status := fnd_api.g_ret_sts_unexp_error;
2187: ROLLBACK TO update_task_assign_pvt;
2188:
2189: -- Added by SBARAT on 23/05/2006 for bug# 5176073
2190: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
2191: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
2192: fnd_msg_pub.add;
2193:
2194: x_return_status := fnd_api.g_ret_sts_unexp_error;
2195: fnd_msg_pub.count_and_get (
2586: FETCH c_task INTO rec_task;
2587: IF c_task%NOTFOUND
2588: THEN
2589: CLOSE c_task;
2590: fnd_message.set_name ('JTF', 'JTF_TASK_INV_TK_ASS');
2591: fnd_message.set_token ('P_TASK_ASSIGNMENT_ID', p_task_assignment_id);
2592: fnd_msg_pub.add;
2593: x_return_status := fnd_api.g_ret_sts_unexp_error;
2594: RAISE fnd_api.g_exc_unexpected_error;
2587: IF c_task%NOTFOUND
2588: THEN
2589: CLOSE c_task;
2590: fnd_message.set_name ('JTF', 'JTF_TASK_INV_TK_ASS');
2591: fnd_message.set_token ('P_TASK_ASSIGNMENT_ID', p_task_assignment_id);
2592: fnd_msg_pub.add;
2593: x_return_status := fnd_api.g_ret_sts_unexp_error;
2594: RAISE fnd_api.g_exc_unexpected_error;
2595: END IF;
2625: RETURN;
2626: ELSIF p_delete_option IS NOT NULL AND
2627: p_delete_option <> JTF_TASK_REPEAT_APPT_PVT.G_SKIP
2628: THEN
2629: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_FLAG');
2630: fnd_message.set_token ('P_FLAG_NAME', 'The parameter p_delete_option ');
2631: fnd_msg_pub.add;
2632:
2633: x_return_status := fnd_api.g_ret_sts_unexp_error;
2626: ELSIF p_delete_option IS NOT NULL AND
2627: p_delete_option <> JTF_TASK_REPEAT_APPT_PVT.G_SKIP
2628: THEN
2629: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_FLAG');
2630: fnd_message.set_token ('P_FLAG_NAME', 'The parameter p_delete_option ');
2631: fnd_msg_pub.add;
2632:
2633: x_return_status := fnd_api.g_ret_sts_unexp_error;
2634: RAISE fnd_api.g_exc_unexpected_error;
2665:
2666: IF ass_res_orig%NOTFOUND
2667: THEN
2668: CLOSE ass_res_orig; -- Fix a missing CLOSE on 4/18/2002
2669: fnd_message.set_name ('JTF', 'JTF_TASK_INV_TK_ASS');
2670: fnd_message.set_token ('P_TASK_ASSIGNMENT_ID', p_task_assignment_id);
2671: fnd_msg_pub.add;
2672: x_return_status := fnd_api.g_ret_sts_unexp_error;
2673: RAISE fnd_api.g_exc_unexpected_error;
2666: IF ass_res_orig%NOTFOUND
2667: THEN
2668: CLOSE ass_res_orig; -- Fix a missing CLOSE on 4/18/2002
2669: fnd_message.set_name ('JTF', 'JTF_TASK_INV_TK_ASS');
2670: fnd_message.set_token ('P_TASK_ASSIGNMENT_ID', p_task_assignment_id);
2671: fnd_msg_pub.add;
2672: x_return_status := fnd_api.g_ret_sts_unexp_error;
2673: RAISE fnd_api.g_exc_unexpected_error;
2674: END IF;
2695:
2696: IF c_res_ass%FOUND
2697: THEN
2698: CLOSE c_res_ass; -- Fix a missing CLOSE on 4/18/2002
2699: fnd_message.set_name ('JTF', 'JTF_TASK_DELETING_TK_ASS');
2700: fnd_msg_pub.add;
2701: x_return_status := fnd_api.g_ret_sts_unexp_error;
2702: RAISE fnd_api.g_exc_unexpected_error;
2703: --CLOSE c_res_ass; -- Incorrect position for CLOSE
2747: jtf_task_wf_events_pvt.publish_delete_assignment(l_assignment_rec, x_event_return_status);
2748:
2749: IF (x_event_return_status = 'WARNING')
2750: THEN
2751: fnd_message.set_name ('JTF', 'JTF_TASK_ASS_EVENT_WARNING');
2752: fnd_message.set_token ('P_ASSIGNMENT_ID', l_task_assignment_id);
2753: fnd_msg_pub.add;
2754: ELSIF(x_event_return_status = 'ERROR')
2755: THEN
2748:
2749: IF (x_event_return_status = 'WARNING')
2750: THEN
2751: fnd_message.set_name ('JTF', 'JTF_TASK_ASS_EVENT_WARNING');
2752: fnd_message.set_token ('P_ASSIGNMENT_ID', l_task_assignment_id);
2753: fnd_msg_pub.add;
2754: ELSIF(x_event_return_status = 'ERROR')
2755: THEN
2756: fnd_message.set_name ('JTF', 'JTF_TASK_ASS_EVENT_ERROR');
2752: fnd_message.set_token ('P_ASSIGNMENT_ID', l_task_assignment_id);
2753: fnd_msg_pub.add;
2754: ELSIF(x_event_return_status = 'ERROR')
2755: THEN
2756: fnd_message.set_name ('JTF', 'JTF_TASK_ASS_EVENT_ERROR');
2757: fnd_message.set_token ('P_ASSIGNMENT_ID', l_task_assignment_id);
2758: fnd_msg_pub.add;
2759: x_return_status := fnd_api.g_ret_sts_unexp_error;
2760: RAISE fnd_api.g_exc_unexpected_error;
2753: fnd_msg_pub.add;
2754: ELSIF(x_event_return_status = 'ERROR')
2755: THEN
2756: fnd_message.set_name ('JTF', 'JTF_TASK_ASS_EVENT_ERROR');
2757: fnd_message.set_token ('P_ASSIGNMENT_ID', l_task_assignment_id);
2758: fnd_msg_pub.add;
2759: x_return_status := fnd_api.g_ret_sts_unexp_error;
2760: RAISE fnd_api.g_exc_unexpected_error;
2761: END IF ;
2786: THEN
2787: ROLLBACK TO delete_task_ass_pvt;
2788:
2789: -- Added by SBARAT on 23/05/2006 for bug# 5176073
2790: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
2791: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
2792: fnd_msg_pub.add;
2793:
2794: x_return_status := fnd_api.g_ret_sts_unexp_error;
2787: ROLLBACK TO delete_task_ass_pvt;
2788:
2789: -- Added by SBARAT on 23/05/2006 for bug# 5176073
2790: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
2791: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
2792: fnd_msg_pub.add;
2793:
2794: x_return_status := fnd_api.g_ret_sts_unexp_error;
2795: fnd_msg_pub.count_and_get (