DBA Data[Home] [Help]

APPS.JTF_TASK_ASSIGNMENTS_PVT dependencies on FND_MESSAGE

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

330: FETCH c_task INTO rec_task;
331: IF c_task%NOTFOUND
332: THEN
333: CLOSE c_task;
334: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_TASK_ID');
335: fnd_message.set_token ('P_TASK_ID', l_task_id);
336: fnd_msg_pub.add;
337: x_return_status := fnd_api.g_ret_sts_unexp_error;
338: RAISE fnd_api.g_exc_unexpected_error;

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

331: IF c_task%NOTFOUND
332: THEN
333: CLOSE c_task;
334: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_TASK_ID');
335: fnd_message.set_token ('P_TASK_ID', l_task_id);
336: fnd_msg_pub.add;
337: x_return_status := fnd_api.g_ret_sts_unexp_error;
338: RAISE fnd_api.g_exc_unexpected_error;
339: END IF;

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

371: RETURN;
372: ELSIF p_add_option IS NOT NULL AND
373: p_add_option <> JTF_TASK_REPEAT_APPT_PVT.G_SKIP
374: THEN
375: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_FLAG');
376: fnd_message.set_token ('P_FLAG_NAME', 'The parameter p_add_option ');
377: fnd_msg_pub.add;
378:
379: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

372: ELSIF p_add_option IS NOT NULL AND
373: p_add_option <> JTF_TASK_REPEAT_APPT_PVT.G_SKIP
374: THEN
375: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_FLAG');
376: fnd_message.set_token ('P_FLAG_NAME', 'The parameter p_add_option ');
377: fnd_msg_pub.add;
378:
379: x_return_status := fnd_api.g_ret_sts_unexp_error;
380: RAISE fnd_api.g_exc_unexpected_error;

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

386: THEN
387: IF p_task_assignment_id > jtf_task_utl_ext.get_last_number('JTF_TASK_ASSIGNMENTS_S') and -- Enh# 2734020
388: p_task_assignment_id < 1e+12
389: THEN
390: fnd_message.set_name ('JTF', 'JTF_TASK_OUT_OF_RANGE');
391: fnd_msg_pub.add;
392: x_return_status := fnd_api.g_ret_sts_unexp_error;
393: RAISE fnd_api.g_exc_unexpected_error;
394: ELSE

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

521: IF ra_cur1%NOTFOUND
522: THEN
523: CLOSE ra_cur1; -- Fix a missing CLOSE on 4/18/2002
524: x_return_status := fnd_api.g_ret_sts_unexp_error;
525: fnd_message.set_name ('JTF', 'JTF_TASK_INV_TK_ASS');
526: fnd_msg_pub.add;
527: RAISE fnd_api.g_exc_unexpected_error;
528: ELSE
529: x_task_assignment_id := l_task_assignment_id;

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

553: jtf_task_wf_events_pvt.publish_create_assignment(l_assignment_rec, x_event_return_status);
554:
555: IF (x_event_return_status = 'WARNING')
556: THEN
557: fnd_message.set_name ('JTF', 'JTF_TASK_ASS_EVENT_WARNING');
558: fnd_message.set_token ('P_ASSIGNMENT_ID', l_task_assignment_id);
559: fnd_msg_pub.add;
560: ELSIF(x_event_return_status = 'ERROR')
561: THEN

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

554:
555: IF (x_event_return_status = 'WARNING')
556: THEN
557: fnd_message.set_name ('JTF', 'JTF_TASK_ASS_EVENT_WARNING');
558: fnd_message.set_token ('P_ASSIGNMENT_ID', l_task_assignment_id);
559: fnd_msg_pub.add;
560: ELSIF(x_event_return_status = 'ERROR')
561: THEN
562: fnd_message.set_name ('JTF', 'JTF_TASK_ASS_EVENT_ERROR');

Line 562: fnd_message.set_name ('JTF', 'JTF_TASK_ASS_EVENT_ERROR');

558: fnd_message.set_token ('P_ASSIGNMENT_ID', l_task_assignment_id);
559: fnd_msg_pub.add;
560: ELSIF(x_event_return_status = 'ERROR')
561: THEN
562: fnd_message.set_name ('JTF', 'JTF_TASK_ASS_EVENT_ERROR');
563: fnd_message.set_token ('P_ASSIGNMENT_ID', l_task_assignment_id);
564: fnd_msg_pub.add;
565: x_return_status := fnd_api.g_ret_sts_unexp_error;
566: RAISE fnd_api.g_exc_unexpected_error;

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

559: fnd_msg_pub.add;
560: ELSIF(x_event_return_status = 'ERROR')
561: THEN
562: fnd_message.set_name ('JTF', 'JTF_TASK_ASS_EVENT_ERROR');
563: fnd_message.set_token ('P_ASSIGNMENT_ID', l_task_assignment_id);
564: fnd_msg_pub.add;
565: x_return_status := fnd_api.g_ret_sts_unexp_error;
566: RAISE fnd_api.g_exc_unexpected_error;
567: END IF ;

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

603: );
604: WHEN OTHERS
605: THEN
606: ROLLBACK TO create_task_assign_pvt;
607: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
608: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
609: fnd_msg_pub.add;
610: x_return_status := fnd_api.g_ret_sts_unexp_error;
611: fnd_msg_pub.count_and_get (

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

604: WHEN OTHERS
605: THEN
606: ROLLBACK TO create_task_assign_pvt;
607: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
608: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
609: fnd_msg_pub.add;
610: x_return_status := fnd_api.g_ret_sts_unexp_error;
611: fnd_msg_pub.count_and_get (
612: p_count => x_msg_count,

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

1673:
1674: IF task_ass_u%NOTFOUND
1675: THEN
1676: CLOSE task_ass_u;
1677: fnd_message.set_name ('JTF', 'JTF_TASK_INS_TK_ASS');
1678: fnd_message.set_token ('TASK_ASSIGNMENT', p_task_assignment_id);
1679: fnd_msg_pub.add;
1680: x_return_status := fnd_api.g_ret_sts_unexp_error;
1681: RAISE fnd_api.g_exc_unexpected_error;

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

1674: IF task_ass_u%NOTFOUND
1675: THEN
1676: CLOSE task_ass_u;
1677: fnd_message.set_name ('JTF', 'JTF_TASK_INS_TK_ASS');
1678: fnd_message.set_token ('TASK_ASSIGNMENT', p_task_assignment_id);
1679: fnd_msg_pub.add;
1680: x_return_status := fnd_api.g_ret_sts_unexp_error;
1681: RAISE fnd_api.g_exc_unexpected_error;
1682: END IF;

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

1688:
1689: IF jtf_task_utl.c_ass_orig%NOTFOUND
1690: THEN
1691: CLOSE jtf_task_utl.c_ass_orig;
1692: fnd_message.set_name ('JTF', 'JTF_TASK_INS_TK_ASS');
1693: fnd_message.set_token ('TASK_ASSIGNMENT', p_task_assignment_id);
1694: fnd_msg_pub.add;
1695: x_return_status := fnd_api.g_ret_sts_unexp_error;
1696: RAISE fnd_api.g_exc_unexpected_error;

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

1689: IF jtf_task_utl.c_ass_orig%NOTFOUND
1690: THEN
1691: CLOSE jtf_task_utl.c_ass_orig;
1692: fnd_message.set_name ('JTF', 'JTF_TASK_INS_TK_ASS');
1693: fnd_message.set_token ('TASK_ASSIGNMENT', p_task_assignment_id);
1694: fnd_msg_pub.add;
1695: x_return_status := fnd_api.g_ret_sts_unexp_error;
1696: RAISE fnd_api.g_exc_unexpected_error;
1697: END IF;

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

1748: , l_entity;
1749: IF c_task%NOTFOUND
1750: THEN
1751: CLOSE c_task;
1752: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_TASK_ID');
1753: fnd_message.set_token ('P_TASK_ID', l_task_id);
1754: fnd_msg_pub.add;
1755: x_return_status := fnd_api.g_ret_sts_unexp_error;
1756: RAISE fnd_api.g_exc_unexpected_error;

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

1749: IF c_task%NOTFOUND
1750: THEN
1751: CLOSE c_task;
1752: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_TASK_ID');
1753: fnd_message.set_token ('P_TASK_ID', l_task_id);
1754: fnd_msg_pub.add;
1755: x_return_status := fnd_api.g_ret_sts_unexp_error;
1756: RAISE fnd_api.g_exc_unexpected_error;
1757: END IF;

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

2060: jtf_task_wf_events_pvt.publish_update_assignment(l_assignment_rec_new,l_assignment_rec_old,x_event_return_status);
2061:
2062: IF (x_event_return_status = 'WARNING')
2063: THEN
2064: fnd_message.set_name ('JTF', 'JTF_TASK_ASS_EVENT_WARNING');
2065: fnd_message.set_token ('P_ASSIGNMENT_ID', l_task_assignment_id);
2066: fnd_msg_pub.add;
2067: ELSIF(x_event_return_status = 'ERROR')
2068: THEN

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

2061:
2062: IF (x_event_return_status = 'WARNING')
2063: THEN
2064: fnd_message.set_name ('JTF', 'JTF_TASK_ASS_EVENT_WARNING');
2065: fnd_message.set_token ('P_ASSIGNMENT_ID', l_task_assignment_id);
2066: fnd_msg_pub.add;
2067: ELSIF(x_event_return_status = 'ERROR')
2068: THEN
2069: fnd_message.set_name ('JTF', 'JTF_TASK_ASS_EVENT_ERROR');

Line 2069: fnd_message.set_name ('JTF', 'JTF_TASK_ASS_EVENT_ERROR');

2065: fnd_message.set_token ('P_ASSIGNMENT_ID', l_task_assignment_id);
2066: fnd_msg_pub.add;
2067: ELSIF(x_event_return_status = 'ERROR')
2068: THEN
2069: fnd_message.set_name ('JTF', 'JTF_TASK_ASS_EVENT_ERROR');
2070: fnd_message.set_token ('P_ASSIGNMENT_ID', l_task_assignment_id);
2071: fnd_msg_pub.add;
2072: x_return_status := fnd_api.g_ret_sts_unexp_error;
2073: RAISE fnd_api.g_exc_unexpected_error;

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

2066: fnd_msg_pub.add;
2067: ELSIF(x_event_return_status = 'ERROR')
2068: THEN
2069: fnd_message.set_name ('JTF', 'JTF_TASK_ASS_EVENT_ERROR');
2070: fnd_message.set_token ('P_ASSIGNMENT_ID', l_task_assignment_id);
2071: fnd_msg_pub.add;
2072: x_return_status := fnd_api.g_ret_sts_unexp_error;
2073: RAISE fnd_api.g_exc_unexpected_error;
2074: END IF ;

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

2109:
2110: ROLLBACK TO update_task_assign_pvt;
2111:
2112: -- Added by SBARAT on 23/05/2006 for bug# 5176073
2113: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
2114: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
2115: fnd_msg_pub.add;
2116:
2117: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

2110: ROLLBACK TO update_task_assign_pvt;
2111:
2112: -- Added by SBARAT on 23/05/2006 for bug# 5176073
2113: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
2114: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
2115: fnd_msg_pub.add;
2116:
2117: x_return_status := fnd_api.g_ret_sts_unexp_error;
2118: fnd_msg_pub.count_and_get (

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

2509: FETCH c_task INTO rec_task;
2510: IF c_task%NOTFOUND
2511: THEN
2512: CLOSE c_task;
2513: fnd_message.set_name ('JTF', 'JTF_TASK_INV_TK_ASS');
2514: fnd_message.set_token ('P_TASK_ASSIGNMENT_ID', p_task_assignment_id);
2515: fnd_msg_pub.add;
2516: x_return_status := fnd_api.g_ret_sts_unexp_error;
2517: RAISE fnd_api.g_exc_unexpected_error;

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

2510: IF c_task%NOTFOUND
2511: THEN
2512: CLOSE c_task;
2513: fnd_message.set_name ('JTF', 'JTF_TASK_INV_TK_ASS');
2514: fnd_message.set_token ('P_TASK_ASSIGNMENT_ID', p_task_assignment_id);
2515: fnd_msg_pub.add;
2516: x_return_status := fnd_api.g_ret_sts_unexp_error;
2517: RAISE fnd_api.g_exc_unexpected_error;
2518: END IF;

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

2548: RETURN;
2549: ELSIF p_delete_option IS NOT NULL AND
2550: p_delete_option <> JTF_TASK_REPEAT_APPT_PVT.G_SKIP
2551: THEN
2552: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_FLAG');
2553: fnd_message.set_token ('P_FLAG_NAME', 'The parameter p_delete_option ');
2554: fnd_msg_pub.add;
2555:
2556: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

2549: ELSIF p_delete_option IS NOT NULL AND
2550: p_delete_option <> JTF_TASK_REPEAT_APPT_PVT.G_SKIP
2551: THEN
2552: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_FLAG');
2553: fnd_message.set_token ('P_FLAG_NAME', 'The parameter p_delete_option ');
2554: fnd_msg_pub.add;
2555:
2556: x_return_status := fnd_api.g_ret_sts_unexp_error;
2557: RAISE fnd_api.g_exc_unexpected_error;

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

2588:
2589: IF ass_res_orig%NOTFOUND
2590: THEN
2591: CLOSE ass_res_orig; -- Fix a missing CLOSE on 4/18/2002
2592: fnd_message.set_name ('JTF', 'JTF_TASK_INV_TK_ASS');
2593: fnd_message.set_token ('P_TASK_ASSIGNMENT_ID', p_task_assignment_id);
2594: fnd_msg_pub.add;
2595: x_return_status := fnd_api.g_ret_sts_unexp_error;
2596: RAISE fnd_api.g_exc_unexpected_error;

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

2589: IF ass_res_orig%NOTFOUND
2590: THEN
2591: CLOSE ass_res_orig; -- Fix a missing CLOSE on 4/18/2002
2592: fnd_message.set_name ('JTF', 'JTF_TASK_INV_TK_ASS');
2593: fnd_message.set_token ('P_TASK_ASSIGNMENT_ID', p_task_assignment_id);
2594: fnd_msg_pub.add;
2595: x_return_status := fnd_api.g_ret_sts_unexp_error;
2596: RAISE fnd_api.g_exc_unexpected_error;
2597: END IF;

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

2618:
2619: IF c_res_ass%FOUND
2620: THEN
2621: CLOSE c_res_ass; -- Fix a missing CLOSE on 4/18/2002
2622: fnd_message.set_name ('JTF', 'JTF_TASK_DELETING_TK_ASS');
2623: fnd_msg_pub.add;
2624: x_return_status := fnd_api.g_ret_sts_unexp_error;
2625: RAISE fnd_api.g_exc_unexpected_error;
2626: --CLOSE c_res_ass; -- Incorrect position for CLOSE

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

2670: jtf_task_wf_events_pvt.publish_delete_assignment(l_assignment_rec, x_event_return_status);
2671:
2672: IF (x_event_return_status = 'WARNING')
2673: THEN
2674: fnd_message.set_name ('JTF', 'JTF_TASK_ASS_EVENT_WARNING');
2675: fnd_message.set_token ('P_ASSIGNMENT_ID', l_task_assignment_id);
2676: fnd_msg_pub.add;
2677: ELSIF(x_event_return_status = 'ERROR')
2678: THEN

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

2671:
2672: IF (x_event_return_status = 'WARNING')
2673: THEN
2674: fnd_message.set_name ('JTF', 'JTF_TASK_ASS_EVENT_WARNING');
2675: fnd_message.set_token ('P_ASSIGNMENT_ID', l_task_assignment_id);
2676: fnd_msg_pub.add;
2677: ELSIF(x_event_return_status = 'ERROR')
2678: THEN
2679: fnd_message.set_name ('JTF', 'JTF_TASK_ASS_EVENT_ERROR');

Line 2679: fnd_message.set_name ('JTF', 'JTF_TASK_ASS_EVENT_ERROR');

2675: fnd_message.set_token ('P_ASSIGNMENT_ID', l_task_assignment_id);
2676: fnd_msg_pub.add;
2677: ELSIF(x_event_return_status = 'ERROR')
2678: THEN
2679: fnd_message.set_name ('JTF', 'JTF_TASK_ASS_EVENT_ERROR');
2680: fnd_message.set_token ('P_ASSIGNMENT_ID', l_task_assignment_id);
2681: fnd_msg_pub.add;
2682: x_return_status := fnd_api.g_ret_sts_unexp_error;
2683: RAISE fnd_api.g_exc_unexpected_error;

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

2676: fnd_msg_pub.add;
2677: ELSIF(x_event_return_status = 'ERROR')
2678: THEN
2679: fnd_message.set_name ('JTF', 'JTF_TASK_ASS_EVENT_ERROR');
2680: fnd_message.set_token ('P_ASSIGNMENT_ID', l_task_assignment_id);
2681: fnd_msg_pub.add;
2682: x_return_status := fnd_api.g_ret_sts_unexp_error;
2683: RAISE fnd_api.g_exc_unexpected_error;
2684: END IF ;

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

2709: THEN
2710: ROLLBACK TO delete_task_ass_pvt;
2711:
2712: -- Added by SBARAT on 23/05/2006 for bug# 5176073
2713: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
2714: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
2715: fnd_msg_pub.add;
2716:
2717: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

2710: ROLLBACK TO delete_task_ass_pvt;
2711:
2712: -- Added by SBARAT on 23/05/2006 for bug# 5176073
2713: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
2714: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
2715: fnd_msg_pub.add;
2716:
2717: x_return_status := fnd_api.g_ret_sts_unexp_error;
2718: fnd_msg_pub.count_and_get (