DBA Data[Home] [Help]

APPS.CAC_SYNC_CONTACT_PREF_PVT dependencies on FND_MESSAGE

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

90: END IF;
91:
92: WHEN OTHERS THEN
93: ROLLBACK TO create_contact_preference_sv;
94: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
95: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
96: fnd_msg_pub.add;
97: x_return_status := fnd_api.g_ret_sts_unexp_error;
98: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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

91:
92: WHEN OTHERS THEN
93: ROLLBACK TO create_contact_preference_sv;
94: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
95: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
96: fnd_msg_pub.add;
97: x_return_status := fnd_api.g_ret_sts_unexp_error;
98: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
99: IF c_preference%ISOPEN THEN

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

150: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
151:
152: WHEN OTHERS THEN
153: ROLLBACK TO delete_contact_preference_sv;
154: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
155: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
156: fnd_msg_pub.add;
157: x_return_status := fnd_api.g_ret_sts_unexp_error;
158: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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

151:
152: WHEN OTHERS THEN
153: ROLLBACK TO delete_contact_preference_sv;
154: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
155: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
156: fnd_msg_pub.add;
157: x_return_status := fnd_api.g_ret_sts_unexp_error;
158: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
159: