DBA Data[Home] [Help]

APPS.JTF_TASK_ASSIGNMENTS_PVT dependencies on FND_MESSAGE

Line 375: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_TASK_ID');

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;

Line 376: fnd_message.set_token ('P_TASK_ID', l_task_id);

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;

Line 416: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_FLAG');

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;

Line 417: fnd_message.set_token ('P_FLAG_NAME', 'The parameter p_add_option ');

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;

Line 431: fnd_message.set_name ('JTF', 'JTF_TASK_OUT_OF_RANGE');

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

Line 514: fnd_message.set_name ('JTF', 'JTF_TASK_DUP_TK_ASS');

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:

Line 584: fnd_message.set_name ('JTF', 'JTF_TASK_INV_TK_ASS');

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;

Line 616: fnd_message.set_name ('JTF', 'JTF_TASK_ASS_EVENT_WARNING');

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

Line 617: fnd_message.set_token ('P_ASSIGNMENT_ID', l_task_assignment_id);

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');

Line 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;

Line 622: 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;
626: END IF ;

Line 666: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');

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 (

Line 667: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);

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,

Line 1736: fnd_message.set_name ('JTF', 'JTF_TASK_INS_TK_ASS');

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;

Line 1737: fnd_message.set_token ('TASK_ASSIGNMENT', p_task_assignment_id);

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;

Line 1751: fnd_message.set_name ('JTF', 'JTF_TASK_INS_TK_ASS');

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;

Line 1752: fnd_message.set_token ('TASK_ASSIGNMENT', p_task_assignment_id);

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;

Line 1811: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_TASK_ID');

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;

Line 1812: fnd_message.set_token ('P_TASK_ID', l_task_id);

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;

Line 1998: fnd_message.set_name ('JTF', 'JTF_TASK_DUP_TK_ASS');

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:

Line 2141: fnd_message.set_name ('JTF', 'JTF_TASK_ASS_EVENT_WARNING');

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

Line 2142: fnd_message.set_token ('P_ASSIGNMENT_ID', l_task_assignment_id);

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');

Line 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;

Line 2147: 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;
2151: END IF ;

Line 2190: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');

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;

Line 2191: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);

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 (

Line 2590: fnd_message.set_name ('JTF', 'JTF_TASK_INV_TK_ASS');

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;

Line 2591: fnd_message.set_token ('P_TASK_ASSIGNMENT_ID', p_task_assignment_id);

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;

Line 2629: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_FLAG');

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;

Line 2630: fnd_message.set_token ('P_FLAG_NAME', 'The parameter p_delete_option ');

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;

Line 2669: fnd_message.set_name ('JTF', 'JTF_TASK_INV_TK_ASS');

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;

Line 2670: fnd_message.set_token ('P_TASK_ASSIGNMENT_ID', p_task_assignment_id);

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;

Line 2699: fnd_message.set_name ('JTF', 'JTF_TASK_DELETING_TK_ASS');

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

Line 2751: fnd_message.set_name ('JTF', 'JTF_TASK_ASS_EVENT_WARNING');

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

Line 2752: fnd_message.set_token ('P_ASSIGNMENT_ID', l_task_assignment_id);

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');

Line 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;

Line 2757: 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;
2761: END IF ;

Line 2790: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');

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;

Line 2791: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);

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 (