DBA Data[Home] [Help]

APPS.JTF_TASK_PHONES_PUB dependencies on FND_MESSAGE

Line 231: fnd_message.set_name ('JTF', 'JTF_TASK_CREATING_PHONE');

227:
228: IF c_jtf_task_phones%NOTFOUND
229: THEN
230: x_return_status := fnd_api.g_ret_sts_unexp_error;
231: fnd_message.set_name ('JTF', 'JTF_TASK_CREATING_PHONE');
232: fnd_msg_pub.add;
233: RAISE fnd_api.g_exc_unexpected_error;
234: ELSE
235: x_task_phone_id := l_task_phone_id;

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

252: );
253: WHEN OTHERS
254: THEN
255: ROLLBACK TO create_task_phones_pub;
256: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
257: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
258: fnd_msg_pub.add;
259: x_return_status := fnd_api.g_ret_sts_unexp_error;
260: fnd_msg_pub.count_and_get (

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

253: WHEN OTHERS
254: THEN
255: ROLLBACK TO create_task_phones_pub;
256: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
257: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
258: fnd_msg_pub.add;
259: x_return_status := fnd_api.g_ret_sts_unexp_error;
260: fnd_msg_pub.count_and_get (
261: p_count => x_msg_count,

Line 310: fnd_message.set_name ('JTF', 'JTF_TASK_RESOURCE_LOCKED');

306: EXCEPTION
307: WHEN resource_locked
308: THEN
309: ROLLBACK TO lock_task_phones_pub;
310: fnd_message.set_name ('JTF', 'JTF_TASK_RESOURCE_LOCKED');
311: fnd_message.set_token ('P_LOCKED_RESOURCE', 'Contacts');
312: fnd_msg_pub.add;
313: x_return_status := fnd_api.g_ret_sts_unexp_error;
314: fnd_msg_pub.count_and_get (

Line 311: fnd_message.set_token ('P_LOCKED_RESOURCE', 'Contacts');

307: WHEN resource_locked
308: THEN
309: ROLLBACK TO lock_task_phones_pub;
310: fnd_message.set_name ('JTF', 'JTF_TASK_RESOURCE_LOCKED');
311: fnd_message.set_token ('P_LOCKED_RESOURCE', 'Contacts');
312: fnd_msg_pub.add;
313: x_return_status := fnd_api.g_ret_sts_unexp_error;
314: fnd_msg_pub.count_and_get (
315: p_count => x_msg_count,

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

325: );
326: WHEN OTHERS
327: THEN
328: ROLLBACK TO lock_task_phones_pub;
329: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
330: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
331: fnd_msg_pub.add;
332: x_return_status := fnd_api.g_ret_sts_unexp_error;
333: fnd_msg_pub.count_and_get (

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

326: WHEN OTHERS
327: THEN
328: ROLLBACK TO lock_task_phones_pub;
329: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
330: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
331: fnd_msg_pub.add;
332: x_return_status := fnd_api.g_ret_sts_unexp_error;
333: fnd_msg_pub.count_and_get (
334: p_count => x_msg_count,

Line 490: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_PHONE_ID');

486: END IF;
487:
488: IF p_task_phone_id IS NULL
489: THEN
490: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_PHONE_ID');
491: fnd_msg_pub.add;
492: x_return_status := fnd_api.g_ret_sts_unexp_error;
493: RAISE fnd_api.g_exc_unexpected_error;
494: END IF;

Line 507: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_PHONE');

503: WHERE task_phone_id = p_task_phone_id;
504: EXCEPTION
505: WHEN NO_DATA_FOUND
506: THEN
507: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_PHONE');
508: fnd_msg_pub.add;
509: x_return_status := fnd_api.g_ret_sts_unexp_error;
510: RAISE fnd_api.g_exc_unexpected_error;
511: END;

Line 523: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_CONTACT');

519: WHERE task_contact_id = l_task_contact_id;
520: EXCEPTION
521: WHEN NO_DATA_FOUND
522: THEN
523: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_CONTACT');
524: fnd_msg_pub.add;
525: x_return_status := fnd_api.g_ret_sts_unexp_error;
526: RAISE fnd_api.g_exc_unexpected_error;
527: END;

Line 537: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_PHONE');

533: WHERE task_id = l_task_contact_id;
534: EXCEPTION
535: WHEN NO_DATA_FOUND
536: THEN
537: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_PHONE');
538: fnd_msg_pub.add;
539: x_return_status := fnd_api.g_ret_sts_unexp_error;
540: RAISE fnd_api.g_exc_unexpected_error;
541: END;

Line 546: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_PHONE');

542: END IF;
543:
544: IF p_phone_id IS NULL
545: THEN
546: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_PHONE');
547: fnd_msg_pub.add;
548: x_return_status := fnd_api.g_ret_sts_unexp_error;
549: RAISE fnd_api.g_exc_unexpected_error;
550: END IF;

Line 575: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_PHONE');

571: WHERE task_phone_id = p_task_phone_id;
572: EXCEPTION
573: WHEN NO_DATA_FOUND
574: THEN
575: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_PHONE');
576: fnd_message.set_token ('P_TASK_PHONE_ID', p_task_phone_id);
577: fnd_msg_pub.add;
578: RAISE fnd_api.g_exc_unexpected_error;
579: END;

Line 576: fnd_message.set_token ('P_TASK_PHONE_ID', p_task_phone_id);

572: EXCEPTION
573: WHEN NO_DATA_FOUND
574: THEN
575: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_PHONE');
576: fnd_message.set_token ('P_TASK_PHONE_ID', p_task_phone_id);
577: fnd_msg_pub.add;
578: RAISE fnd_api.g_exc_unexpected_error;
579: END;
580:

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

668: );
669: WHEN OTHERS
670: THEN
671: ROLLBACK TO update_task_phones_pub;
672: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
673: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
674: fnd_msg_pub.add;
675: x_return_status := fnd_api.g_ret_sts_unexp_error;
676: fnd_msg_pub.count_and_get (

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

669: WHEN OTHERS
670: THEN
671: ROLLBACK TO update_task_phones_pub;
672: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
673: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
674: fnd_msg_pub.add;
675: x_return_status := fnd_api.g_ret_sts_unexp_error;
676: fnd_msg_pub.count_and_get (
677: p_count => x_msg_count,

Line 745: fnd_message.set_name ('JTF', 'JTF_TASK_DELETING_PHONES');

741:
742: IF c_jtf_task_phones%FOUND
743: THEN
744: x_return_status := fnd_api.g_ret_sts_unexp_error;
745: fnd_message.set_name ('JTF', 'JTF_TASK_DELETING_PHONES');
746: fnd_msg_pub.add;
747: RAISE fnd_api.g_exc_unexpected_error;
748: END IF;
749:

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

764: );
765: WHEN OTHERS
766: THEN
767: ROLLBACK TO delete_task_phones_pub;
768: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
769: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
770: fnd_msg_pub.add;
771: x_return_status := fnd_api.g_ret_sts_unexp_error;
772: fnd_msg_pub.count_and_get (

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

765: WHEN OTHERS
766: THEN
767: ROLLBACK TO delete_task_phones_pub;
768: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
769: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
770: fnd_msg_pub.add;
771: x_return_status := fnd_api.g_ret_sts_unexp_error;
772: fnd_msg_pub.count_and_get (
773: p_count => x_msg_count,