DBA Data[Home] [Help]

APPS.CAC_SYNC_CONTACT_MAPPINGS_PVT dependencies on FND_MESSAGE

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

145: END IF;
146:
147: WHEN OTHERS THEN
148: ROLLBACK TO create_contact_mapping_sv;
149: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
150: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
151: fnd_msg_pub.add;
152: x_return_status := fnd_api.g_ret_sts_unexp_error;
153: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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

146:
147: WHEN OTHERS THEN
148: ROLLBACK TO create_contact_mapping_sv;
149: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
150: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
151: fnd_msg_pub.add;
152: x_return_status := fnd_api.g_ret_sts_unexp_error;
153: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
154: IF c_mapping%ISOPEN THEN

Line 212: fnd_message.set_name ('JTF', 'CAC_SYNC_CONTACT_MAPPING_NF');

208:
209: IF c_mapping%NOTFOUND THEN
210: CLOSE c_mapping;
211:
212: fnd_message.set_name ('JTF', 'CAC_SYNC_CONTACT_MAPPING_NF');
213: fnd_msg_pub.add;
214: RAISE fnd_api.g_exc_unexpected_error;
215: END IF;
216: CLOSE c_mapping;

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

249: END IF;
250:
251: WHEN OTHERS THEN
252: ROLLBACK TO update_contact_mapping_sv;
253: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
254: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
255: fnd_msg_pub.add;
256: x_return_status := fnd_api.g_ret_sts_unexp_error;
257: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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

250:
251: WHEN OTHERS THEN
252: ROLLBACK TO update_contact_mapping_sv;
253: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
254: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
255: fnd_msg_pub.add;
256: x_return_status := fnd_api.g_ret_sts_unexp_error;
257: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
258: END UPDATE_CONTACT_MAPPING;

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

304: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
305:
306: WHEN OTHERS THEN
307: ROLLBACK TO delete_contact_mapping_sv;
308: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
309: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
310: fnd_msg_pub.add;
311: x_return_status := fnd_api.g_ret_sts_unexp_error;
312: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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

305:
306: WHEN OTHERS THEN
307: ROLLBACK TO delete_contact_mapping_sv;
308: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
309: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
310: fnd_msg_pub.add;
311: x_return_status := fnd_api.g_ret_sts_unexp_error;
312: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
313: END DELETE_CONTACT_MAPPING;