DBA Data[Home] [Help]

APPS.JTF_TASK_ASSIGNMENTS_PVT dependencies on FND_MSG_PUB

Line 377: fnd_msg_pub.add;

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

Line 418: fnd_msg_pub.add;

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

Line 432: fnd_msg_pub.add;

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

Line 515: fnd_msg_pub.add;

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:
519: jtf_task_assignments_pkg.insert_row (

Line 585: fnd_msg_pub.add;

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

Line 618: fnd_msg_pub.add;

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

Line 623: 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 ;
627:

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

649: END IF;
650:
651: END IF; -- for the if statement for (rec_task.source_object_type_code <> 'APPOINTMENT')
652:
653: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
654: EXCEPTION
655: WHEN fnd_api.g_exc_unexpected_error
656: THEN
657: ROLLBACK TO create_task_assign_pvt;

Line 659: fnd_msg_pub.count_and_get (

655: WHEN fnd_api.g_exc_unexpected_error
656: THEN
657: ROLLBACK TO create_task_assign_pvt;
658: x_return_status := fnd_api.g_ret_sts_unexp_error;
659: fnd_msg_pub.count_and_get (
660: p_count => x_msg_count,
661: p_data => x_msg_data
662: );
663: WHEN OTHERS

Line 668: fnd_msg_pub.add;

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

Line 670: fnd_msg_pub.count_and_get (

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,
672: p_data => x_msg_data
673: );
674: END;

Line 1738: fnd_msg_pub.add;

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

Line 1753: fnd_msg_pub.add;

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

Line 1813: fnd_msg_pub.add;

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

Line 1999: fnd_msg_pub.add;

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:
2003: p_object_version_number := p_object_version_number + 1;

Line 2143: fnd_msg_pub.add;

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

Line 2148: 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 ;
2152:

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

2161: THEN
2162: COMMIT WORK;
2163: END IF;
2164:
2165: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2166: EXCEPTION
2167: WHEN fnd_api.g_exc_unexpected_error
2168: THEN
2169: IF task_ass_u%ISOPEN

Line 2176: fnd_msg_pub.count_and_get (

2172: END IF;
2173:
2174: ROLLBACK TO update_task_assign_pvt;
2175: x_return_status := fnd_api.g_ret_sts_unexp_error;
2176: fnd_msg_pub.count_and_get (
2177: p_count => x_msg_count,
2178: p_data => x_msg_data
2179: );
2180: WHEN OTHERS

Line 2192: fnd_msg_pub.add;

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

Line 2195: fnd_msg_pub.count_and_get (

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 (
2196: p_count => x_msg_count,
2197: p_data => x_msg_data
2198: );
2199: END;

Line 2592: fnd_msg_pub.add;

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

Line 2631: fnd_msg_pub.add;

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

Line 2671: fnd_msg_pub.add;

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

Line 2700: fnd_msg_pub.add;

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

Line 2753: fnd_msg_pub.add;

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

Line 2758: 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 ;
2762:

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

2771: THEN
2772: COMMIT WORK;
2773: END IF;
2774:
2775: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2776: EXCEPTION
2777: WHEN fnd_api.g_exc_unexpected_error
2778: THEN
2779: ROLLBACK TO delete_task_ass_pvt;

Line 2781: fnd_msg_pub.count_and_get (

2777: WHEN fnd_api.g_exc_unexpected_error
2778: THEN
2779: ROLLBACK TO delete_task_ass_pvt;
2780: x_return_status := fnd_api.g_ret_sts_unexp_error;
2781: fnd_msg_pub.count_and_get (
2782: p_count => x_msg_count,
2783: p_data => x_msg_data
2784: );
2785: WHEN OTHERS

Line 2792: fnd_msg_pub.add;

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

Line 2795: fnd_msg_pub.count_and_get (

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 (
2796: p_count => x_msg_count,
2797: p_data => x_msg_data
2798: );
2799: END;