eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.JTF_TASK_ASSIGNMENTS_PVT dependencies on FND_MSG_PUB

Line 336: fnd_msg_pub.add;

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;
340: CLOSE c_task;

Line 377: fnd_msg_pub.add;

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;
381: END IF;

Line 391: fnd_msg_pub.add;

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
395: l_task_assignment_id := p_task_assignment_id;

Line 526: fnd_msg_pub.add;

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;
530: END IF;

Line 559: fnd_msg_pub.add;

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');
563: fnd_message.set_token ('P_ASSIGNMENT_ID', l_task_assignment_id);

Line 564: 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 ;
568:

Line 594: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

590: END IF;
591:
592: END IF; -- for the if statement for (rec_task.source_object_type_code <> 'APPOINTMENT')
593:
594: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
595: EXCEPTION
596: WHEN fnd_api.g_exc_unexpected_error
597: THEN
598: ROLLBACK TO create_task_assign_pvt;

Line 600: fnd_msg_pub.count_and_get (

596: WHEN fnd_api.g_exc_unexpected_error
597: THEN
598: ROLLBACK TO create_task_assign_pvt;
599: x_return_status := fnd_api.g_ret_sts_unexp_error;
600: fnd_msg_pub.count_and_get (
601: p_count => x_msg_count,
602: p_data => x_msg_data
603: );
604: WHEN OTHERS

Line 609: fnd_msg_pub.add;

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,
613: p_data => x_msg_data

Line 611: fnd_msg_pub.count_and_get (

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,
613: p_data => x_msg_data
614: );
615: END;

Line 1679: fnd_msg_pub.add;

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;
1683: CLOSE task_ass_u;

Line 1694: fnd_msg_pub.add;

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;
1698: CLOSE jtf_task_utl.c_ass_orig;

Line 1754: fnd_msg_pub.add;

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;
1758: CLOSE c_task;

Line 2066: fnd_msg_pub.add;

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');
2070: fnd_message.set_token ('P_ASSIGNMENT_ID', l_task_assignment_id);

Line 2071: 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 ;
2075:

Line 2088: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

2084: THEN
2085: COMMIT WORK;
2086: END IF;
2087:
2088: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2089: EXCEPTION
2090: WHEN fnd_api.g_exc_unexpected_error
2091: THEN
2092: IF task_ass_u%ISOPEN

Line 2099: fnd_msg_pub.count_and_get (

2095: END IF;
2096:
2097: ROLLBACK TO update_task_assign_pvt;
2098: x_return_status := fnd_api.g_ret_sts_unexp_error;
2099: fnd_msg_pub.count_and_get (
2100: p_count => x_msg_count,
2101: p_data => x_msg_data
2102: );
2103: WHEN OTHERS

Line 2115: fnd_msg_pub.add;

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 (
2119: p_count => x_msg_count,

Line 2118: fnd_msg_pub.count_and_get (

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 (
2119: p_count => x_msg_count,
2120: p_data => x_msg_data
2121: );
2122: END;

Line 2515: fnd_msg_pub.add;

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;
2519: CLOSE c_task;

Line 2554: fnd_msg_pub.add;

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;
2558: END IF;

Line 2594: fnd_msg_pub.add;

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;
2598: CLOSE ass_res_orig; -- Fix a missing CLOSE on 4/18/2002

Line 2623: fnd_msg_pub.add;

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
2627: ELSE

Line 2676: fnd_msg_pub.add;

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');
2680: fnd_message.set_token ('P_ASSIGNMENT_ID', l_task_assignment_id);

Line 2681: 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 ;
2685:

Line 2698: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

2694: THEN
2695: COMMIT WORK;
2696: END IF;
2697:
2698: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2699: EXCEPTION
2700: WHEN fnd_api.g_exc_unexpected_error
2701: THEN
2702: ROLLBACK TO delete_task_ass_pvt;

Line 2704: fnd_msg_pub.count_and_get (

2700: WHEN fnd_api.g_exc_unexpected_error
2701: THEN
2702: ROLLBACK TO delete_task_ass_pvt;
2703: x_return_status := fnd_api.g_ret_sts_unexp_error;
2704: fnd_msg_pub.count_and_get (
2705: p_count => x_msg_count,
2706: p_data => x_msg_data
2707: );
2708: WHEN OTHERS

Line 2715: fnd_msg_pub.add;

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 (
2719: p_count => x_msg_count,

Line 2718: fnd_msg_pub.count_and_get (

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 (
2719: p_count => x_msg_count,
2720: p_data => x_msg_data
2721: );
2722: END;