eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CAC_SYNC_CONTACT_MAPPINGS_PVT dependencies on FND_MSG_PUB

Line 60: fnd_msg_pub.initialize;

56:
57: IF p_init_msg_list IS NULL OR
58: fnd_api.to_boolean (p_init_msg_list)
59: THEN
60: fnd_msg_pub.initialize;
61: END IF;
62:
63: -- Check if the given contact_party_id exists
64: OPEN c_mapping;

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

92: THEN
93: COMMIT WORK;
94: END IF;
95:
96: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
97:
98: RETURN;
99: END IF;
100: CLOSE c_mapping;

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

132: THEN
133: COMMIT WORK;
134: END IF;
135:
136: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
137:
138: EXCEPTION
139: WHEN fnd_api.g_exc_unexpected_error THEN
140: ROLLBACK TO create_contact_mapping_sv;

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

138: EXCEPTION
139: WHEN fnd_api.g_exc_unexpected_error THEN
140: ROLLBACK TO create_contact_mapping_sv;
141: x_return_status := fnd_api.g_ret_sts_unexp_error;
142: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
143: IF c_mapping%ISOPEN THEN
144: CLOSE c_mapping;
145: END IF;
146:

Line 151: fnd_msg_pub.add;

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
155: CLOSE c_mapping;

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

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
155: CLOSE c_mapping;
156: END IF;
157: END CREATE_CONTACT_MAPPING;

Line 203: fnd_msg_pub.initialize;

199:
200: IF p_init_msg_list IS NULL OR
201: fnd_api.to_boolean (p_init_msg_list)
202: THEN
203: fnd_msg_pub.initialize;
204: END IF;
205:
206: OPEN c_mapping;
207: FETCH c_mapping INTO rec_mapping;

Line 213: fnd_msg_pub.add;

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

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

236: THEN
237: COMMIT WORK;
238: END IF;
239:
240: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
241:
242: EXCEPTION
243: WHEN fnd_api.g_exc_unexpected_error THEN
244: ROLLBACK TO update_contact_mapping_sv;

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

242: EXCEPTION
243: WHEN fnd_api.g_exc_unexpected_error THEN
244: ROLLBACK TO update_contact_mapping_sv;
245: x_return_status := fnd_api.g_ret_sts_unexp_error;
246: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
247: IF c_mapping%ISOPEN THEN
248: CLOSE c_mapping;
249: END IF;
250:

Line 255: fnd_msg_pub.add;

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

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

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;
259:
260:
261: PROCEDURE DELETE_CONTACT_MAPPING

Line 287: fnd_msg_pub.initialize;

283:
284: IF p_init_msg_list IS NULL OR
285: fnd_api.to_boolean (p_init_msg_list)
286: THEN
287: fnd_msg_pub.initialize;
288: END IF;
289:
290: cac_sync_contact_mappings_pkg.delete_row
291: (x_sync_contact_mapping_id => p_sync_contact_mapping_id);

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

294: THEN
295: COMMIT WORK;
296: END IF;
297:
298: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
299:
300: EXCEPTION
301: WHEN fnd_api.g_exc_unexpected_error THEN
302: ROLLBACK TO delete_contact_mapping_sv;

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

300: EXCEPTION
301: WHEN fnd_api.g_exc_unexpected_error THEN
302: ROLLBACK TO delete_contact_mapping_sv;
303: x_return_status := fnd_api.g_ret_sts_unexp_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');

Line 310: fnd_msg_pub.add;

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

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

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;
314:
315:
316: END CAC_SYNC_CONTACT_MAPPINGS_PVT;