DBA Data[Home] [Help]

APPS.JTF_TASK_CONTACTS_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_task (
114: x_return_status => x_return_status,

Line 278: fnd_msg_pub.add;

274: IF c_jtf_task_contacts%NOTFOUND
275: THEN
276: x_return_status := fnd_api.g_ret_sts_unexp_error;
277: fnd_message.set_name ('JTF', 'JTF_TASK_CREATING_CONTACTS');
278: fnd_msg_pub.add;
279: RAISE fnd_api.g_exc_unexpected_error;
280: ELSE
281: x_task_contact_id := l_task_contact_id;
282: END IF;

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

304: THEN
305: COMMIT WORK;
306: END IF;
307:
308: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
309: EXCEPTION
310: WHEN fnd_api.g_exc_unexpected_error
311: THEN
312: ROLLBACK TO create_task_contacts_pub;

Line 314: fnd_msg_pub.count_and_get (

310: WHEN fnd_api.g_exc_unexpected_error
311: THEN
312: ROLLBACK TO create_task_contacts_pub;
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 OTHERS

Line 324: fnd_msg_pub.count_and_get (

320: ROLLBACK TO create_task_contacts_pub;
321: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
322: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
323: x_return_status := fnd_api.g_ret_sts_unexp_error;
324: fnd_msg_pub.count_and_get (
325: p_count => x_msg_count,
326: p_data => x_msg_data
327: );
328: END;

Line 363: fnd_msg_pub.initialize;

359: END IF;
360:
361: IF fnd_api.to_boolean (p_init_msg_list)
362: THEN
363: fnd_msg_pub.initialize;
364: END IF;
365:
366: x_return_status := fnd_api.g_ret_sts_success;
367: jtf_task_contacts_pkg.lock_row (

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

366: x_return_status := fnd_api.g_ret_sts_success;
367: jtf_task_contacts_pkg.lock_row (
368: x_task_contact_id => p_task_contact_id,
369: x_object_version_number => p_object_version_number);
370: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
371:
372: EXCEPTION
373: WHEN resource_locked
374: THEN

Line 379: fnd_msg_pub.add;

375:
376: ROLLBACK TO lock_task_contacts_pub;
377: fnd_message.set_name ('JTF', 'JTF_TASK_RESOURCE_LOCKED');
378: fnd_message.set_token ('P_LOCKED_RESOURCE', 'Contacts');
379: fnd_msg_pub.add;
380: x_return_status := fnd_api.g_ret_sts_unexp_error;
381: fnd_msg_pub.count_and_get (
382: p_count => x_msg_count,
383: p_data => x_msg_data

Line 381: fnd_msg_pub.count_and_get (

377: fnd_message.set_name ('JTF', 'JTF_TASK_RESOURCE_LOCKED');
378: fnd_message.set_token ('P_LOCKED_RESOURCE', 'Contacts');
379: fnd_msg_pub.add;
380: x_return_status := fnd_api.g_ret_sts_unexp_error;
381: fnd_msg_pub.count_and_get (
382: p_count => x_msg_count,
383: p_data => x_msg_data
384: );
385: WHEN fnd_api.g_exc_unexpected_error

Line 390: fnd_msg_pub.count_and_get (

386: THEN
387:
388: ROLLBACK TO lock_task_contacts_pub;
389: x_return_status := fnd_api.g_ret_sts_unexp_error;
390: fnd_msg_pub.count_and_get (
391: p_count => x_msg_count,
392: p_data => x_msg_data
393: );
394: WHEN OTHERS

Line 399: fnd_msg_pub.add;

395: THEN
396: ROLLBACK TO lock_task_contacts_pub;
397: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
398: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
399: fnd_msg_pub.add;
400: x_return_status := fnd_api.g_ret_sts_unexp_error;
401: fnd_msg_pub.count_and_get (
402: p_count => x_msg_count,
403: p_data => x_msg_data

Line 401: fnd_msg_pub.count_and_get (

397: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
398: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
399: fnd_msg_pub.add;
400: x_return_status := fnd_api.g_ret_sts_unexp_error;
401: fnd_msg_pub.count_and_get (
402: p_count => x_msg_count,
403: p_data => x_msg_data
404: );
405: END;

Line 586: fnd_msg_pub.initialize;

582:
583:
584: IF fnd_api.to_boolean (p_init_msg_list)
585: THEN
586: fnd_msg_pub.initialize;
587: END IF;
588:
589: x_return_status := fnd_api.g_ret_sts_success;
590:

Line 616: fnd_msg_pub.add;

612:
613: IF c_task_contacts%NOTFOUND
614: THEN
615: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_CONTACTS');
616: fnd_msg_pub.add;
617: x_return_status := fnd_api.g_ret_sts_unexp_error;
618: RAISE fnd_api.g_exc_unexpected_error;
619: END IF;
620:

Line 644: fnd_msg_pub.add;

640: EXCEPTION
641: WHEN NO_DATA_FOUND
642: THEN
643: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_CONTACTS');
644: fnd_msg_pub.add;
645: x_return_status := fnd_api.g_ret_sts_unexp_error;
646: RAISE fnd_api.g_exc_unexpected_error;
647: END;
648:

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

825: THEN
826: COMMIT WORK;
827: END IF;
828:
829: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
830: p_object_version_number := p_object_version_number + 1;
831: EXCEPTION
832: WHEN fnd_api.g_exc_unexpected_error
833: THEN

Line 836: fnd_msg_pub.count_and_get (

832: WHEN fnd_api.g_exc_unexpected_error
833: THEN
834: ROLLBACK TO update_task_contacts_pub;
835: x_return_status := fnd_api.g_ret_sts_unexp_error;
836: fnd_msg_pub.count_and_get (
837: p_count => x_msg_count,
838: p_data => x_msg_data
839: );
840: WHEN OTHERS

Line 846: fnd_msg_pub.count_and_get (

842: ROLLBACK TO update_task_contacts_pub;
843: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
844: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
845: x_return_status := fnd_api.g_ret_sts_unexp_error;
846: fnd_msg_pub.count_and_get (
847: p_count => x_msg_count,
848: p_data => x_msg_data
849: );
850: END;

Line 893: fnd_msg_pub.initialize;

889: END IF;
890:
891: IF fnd_api.to_boolean (p_init_msg_list)
892: THEN
893: fnd_msg_pub.initialize;
894: END IF;
895:
896: x_return_status := fnd_api.g_ret_sts_success;
897:

Line 918: fnd_msg_pub.add;

914: EXCEPTION
915: WHEN NO_DATA_FOUND
916: THEN
917: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_CONTACTS');
918: fnd_msg_pub.add;
919: x_return_status := fnd_api.g_ret_sts_unexp_error;
920: RAISE fnd_api.g_exc_unexpected_error;
921: END;
922:

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

989: THEN
990: COMMIT WORK;
991: END IF;
992:
993: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
994: EXCEPTION
995: WHEN fnd_api.g_exc_unexpected_error
996: THEN
997: ROLLBACK TO delete_task_contacts_pvt;

Line 999: fnd_msg_pub.count_and_get (

995: WHEN fnd_api.g_exc_unexpected_error
996: THEN
997: ROLLBACK TO delete_task_contacts_pvt;
998: x_return_status := fnd_api.g_ret_sts_unexp_error;
999: fnd_msg_pub.count_and_get (
1000: p_count => x_msg_count,
1001: p_data => x_msg_data
1002: );
1003: WHEN OTHERS

Line 1009: fnd_msg_pub.count_and_get (

1005: ROLLBACK TO delete_task_contacts_pvt;
1006: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
1007: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
1008: x_return_status := fnd_api.g_ret_sts_unexp_error;
1009: fnd_msg_pub.count_and_get (
1010: p_count => x_msg_count,
1011: p_data => x_msg_data
1012: );
1013: END;