DBA Data[Home] [Help]

APPS.JTF_TASK_CONTACTS_PUB dependencies on FND_MESSAGE

Line 277: fnd_message.set_name ('JTF', 'JTF_TASK_CREATING_CONTACTS');

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

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

317: );
318: WHEN OTHERS
319: THEN
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,

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

318: WHEN OTHERS
319: THEN
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

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

373: WHEN resource_locked
374: THEN
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 (

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

374: THEN
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,

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

393: );
394: WHEN OTHERS
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 (

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

394: WHEN OTHERS
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,

Line 615: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_CONTACTS');

611: FETCH c_task_contacts INTO task_contacts;
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;

Line 643: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_CONTACTS');

639: WHERE task_contact_id = p_task_contact_id;
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;

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

839: );
840: WHEN OTHERS
841: THEN
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,

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

840: WHEN OTHERS
841: THEN
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

Line 917: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_CONTACTS');

913: WHERE task_contact_id = p_task_contact_id;
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;

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

1002: );
1003: WHEN OTHERS
1004: THEN
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,

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

1003: WHEN OTHERS
1004: THEN
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