DBA Data[Home] [Help]

APPS.JTF_TASK_PHONES_PUB dependencies on FND_MSG_PUB

Line 110: fnd_msg_pub.initialize;

106: END IF;
107:
108: IF fnd_api.to_boolean (p_init_msg_list)
109: THEN
110: fnd_msg_pub.initialize;
111: END IF;
112:
113: jtf_task_utl.validate_phones_table (
114: p_owner_table_name => p_owner_table_name,

Line 232: fnd_msg_pub.add;

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

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

239: THEN
240: COMMIT WORK;
241: END IF;
242:
243: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
244: EXCEPTION
245: WHEN fnd_api.g_exc_unexpected_error
246: THEN
247: ROLLBACK TO create_task_phones_pub;

Line 249: fnd_msg_pub.count_and_get (

245: WHEN fnd_api.g_exc_unexpected_error
246: THEN
247: ROLLBACK TO create_task_phones_pub;
248: x_return_status := fnd_api.g_ret_sts_unexp_error;
249: fnd_msg_pub.count_and_get (
250: p_count => x_msg_count,
251: p_data => x_msg_data
252: );
253: WHEN OTHERS

Line 258: fnd_msg_pub.add;

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

Line 260: fnd_msg_pub.count_and_get (

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,
262: p_data => x_msg_data
263: );
264: END;

Line 297: fnd_msg_pub.initialize;

293: END IF;
294:
295: IF fnd_api.to_boolean (p_init_msg_list)
296: THEN
297: fnd_msg_pub.initialize;
298: END IF;
299:
300: x_return_status := fnd_api.g_ret_sts_success;
301: jtf_task_phones_pkg.lock_row (

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

301: jtf_task_phones_pkg.lock_row (
302: x_task_phone_id => p_task_phone_id,
303: x_object_version_number => p_object_version_number
304: );
305: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
306: EXCEPTION
307: WHEN resource_locked
308: THEN
309: ROLLBACK TO lock_task_phones_pub;

Line 312: fnd_msg_pub.add;

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

Line 314: fnd_msg_pub.count_and_get (

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,
316: p_data => x_msg_data
317: );
318: WHEN fnd_api.g_exc_unexpected_error

Line 322: fnd_msg_pub.count_and_get (

318: WHEN fnd_api.g_exc_unexpected_error
319: THEN
320: ROLLBACK TO lock_task_phones_pub;
321: x_return_status := fnd_api.g_ret_sts_unexp_error;
322: fnd_msg_pub.count_and_get (
323: p_count => x_msg_count,
324: p_data => x_msg_data
325: );
326: WHEN OTHERS

Line 331: fnd_msg_pub.add;

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

Line 333: fnd_msg_pub.count_and_get (

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,
335: p_data => x_msg_data
336: );
337: END;

Line 485: fnd_msg_pub.initialize;

481: END IF;
482:
483: IF fnd_api.to_boolean (p_init_msg_list)
484: THEN
485: fnd_msg_pub.initialize;
486: END IF;
487:
488: IF p_task_phone_id IS NULL
489: THEN

Line 491: fnd_msg_pub.add;

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;
495:

Line 508: fnd_msg_pub.add;

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;
512:

Line 524: fnd_msg_pub.add;

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;
528: ELSE

Line 538: fnd_msg_pub.add;

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

Line 547: fnd_msg_pub.add;

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;
551:

Line 577: fnd_msg_pub.add;

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:
581: jtf_task_phones_pub.lock_task_phones (

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

655: THEN
656: COMMIT WORK;
657: END IF;
658:
659: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
660: EXCEPTION
661: WHEN fnd_api.g_exc_unexpected_error
662: THEN
663: ROLLBACK TO update_task_phones_pub;

Line 665: fnd_msg_pub.count_and_get (

661: WHEN fnd_api.g_exc_unexpected_error
662: THEN
663: ROLLBACK TO update_task_phones_pub;
664: x_return_status := fnd_api.g_ret_sts_unexp_error;
665: fnd_msg_pub.count_and_get (
666: p_count => x_msg_count,
667: p_data => x_msg_data
668: );
669: WHEN OTHERS

Line 674: fnd_msg_pub.add;

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

Line 676: fnd_msg_pub.count_and_get (

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,
678: p_data => x_msg_data
679: );
680: END;

Line 718: fnd_msg_pub.initialize;

714: END IF;
715:
716: IF fnd_api.to_boolean (p_init_msg_list)
717: THEN
718: fnd_msg_pub.initialize;
719: END IF;
720:
721: jtf_task_phones_pub.lock_task_phones (
722: p_api_version => 1.0,

Line 746: fnd_msg_pub.add;

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:
750: IF fnd_api.to_boolean (p_commit)

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

751: THEN
752: COMMIT WORK;
753: END IF;
754:
755: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
756: EXCEPTION
757: WHEN fnd_api.g_exc_unexpected_error
758: THEN
759: ROLLBACK TO delete_task_phones_pub;

Line 761: fnd_msg_pub.count_and_get (

757: WHEN fnd_api.g_exc_unexpected_error
758: THEN
759: ROLLBACK TO delete_task_phones_pub;
760: x_return_status := fnd_api.g_ret_sts_unexp_error;
761: fnd_msg_pub.count_and_get (
762: p_count => x_msg_count,
763: p_data => x_msg_data
764: );
765: WHEN OTHERS

Line 770: fnd_msg_pub.add;

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

Line 772: fnd_msg_pub.count_and_get (

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,
774: p_data => x_msg_data
775: );
776: END;