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_API

Line 50: x_return_status := fnd_api.g_ret_sts_success;

46: rec_mapping c_mapping%ROWTYPE;
47: BEGIN
48: SAVEPOINT create_contact_mapping_sv;
49:
50: x_return_status := fnd_api.g_ret_sts_success;
51:
52: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
53: THEN
54: RAISE fnd_api.g_exc_unexpected_error;

Line 52: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)

48: SAVEPOINT create_contact_mapping_sv;
49:
50: x_return_status := fnd_api.g_ret_sts_success;
51:
52: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
53: THEN
54: RAISE fnd_api.g_exc_unexpected_error;
55: END IF;
56:

Line 54: RAISE fnd_api.g_exc_unexpected_error;

50: x_return_status := fnd_api.g_ret_sts_success;
51:
52: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
53: THEN
54: RAISE fnd_api.g_exc_unexpected_error;
55: END IF;
56:
57: IF p_init_msg_list IS NULL OR
58: fnd_api.to_boolean (p_init_msg_list)

Line 58: fnd_api.to_boolean (p_init_msg_list)

54: RAISE fnd_api.g_exc_unexpected_error;
55: END IF;
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:

Line 91: IF fnd_api.to_boolean(p_commit)

87: , x_msg_count => x_msg_count
88: , x_msg_data => x_msg_data
89: );
90:
91: IF fnd_api.to_boolean(p_commit)
92: THEN
93: COMMIT WORK;
94: END IF;
95:

Line 131: IF fnd_api.to_boolean(p_commit)

127: , x_last_update_date => NVL(p_last_sync_date,SYSDATE)
128: , x_last_update_login => fnd_global.login_id
129: );
130:
131: IF fnd_api.to_boolean(p_commit)
132: THEN
133: COMMIT WORK;
134: END IF;
135:

Line 139: WHEN fnd_api.g_exc_unexpected_error THEN

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

Line 141: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

Line 152: x_return_status := fnd_api.g_ret_sts_unexp_error;

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;
156: END IF;

Line 193: x_return_status := fnd_api.g_ret_sts_success;

189: rec_mapping c_mapping%ROWTYPE;
190: BEGIN
191: SAVEPOINT update_contact_mapping_sv;
192:
193: x_return_status := fnd_api.g_ret_sts_success;
194:
195: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
196: THEN
197: RAISE fnd_api.g_exc_unexpected_error;

Line 195: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)

191: SAVEPOINT update_contact_mapping_sv;
192:
193: x_return_status := fnd_api.g_ret_sts_success;
194:
195: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
196: THEN
197: RAISE fnd_api.g_exc_unexpected_error;
198: END IF;
199:

Line 197: RAISE fnd_api.g_exc_unexpected_error;

193: x_return_status := fnd_api.g_ret_sts_success;
194:
195: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
196: THEN
197: RAISE fnd_api.g_exc_unexpected_error;
198: END IF;
199:
200: IF p_init_msg_list IS NULL OR
201: fnd_api.to_boolean (p_init_msg_list)

Line 201: fnd_api.to_boolean (p_init_msg_list)

197: RAISE fnd_api.g_exc_unexpected_error;
198: END IF;
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:

Line 214: RAISE fnd_api.g_exc_unexpected_error;

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:
218: cac_sync_contact_mappings_pkg.update_row

Line 235: IF fnd_api.to_boolean(p_commit)

231: , x_last_update_date => NVL(p_last_sync_date,SYSDATE)
232: , x_last_update_login => fnd_global.login_id
233: );
234:
235: IF fnd_api.to_boolean(p_commit)
236: THEN
237: COMMIT WORK;
238: END IF;
239:

Line 243: WHEN fnd_api.g_exc_unexpected_error THEN

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

Line 245: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

Line 256: x_return_status := fnd_api.g_ret_sts_unexp_error;

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:
260:

Line 277: x_return_status := fnd_api.g_ret_sts_success;

273: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_CONTACT_MAPPING';
274: BEGIN
275: SAVEPOINT delete_contact_mapping_sv;
276:
277: x_return_status := fnd_api.g_ret_sts_success;
278:
279: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
280: THEN
281: RAISE fnd_api.g_exc_unexpected_error;

Line 279: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)

275: SAVEPOINT delete_contact_mapping_sv;
276:
277: x_return_status := fnd_api.g_ret_sts_success;
278:
279: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
280: THEN
281: RAISE fnd_api.g_exc_unexpected_error;
282: END IF;
283:

Line 281: RAISE fnd_api.g_exc_unexpected_error;

277: x_return_status := fnd_api.g_ret_sts_success;
278:
279: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
280: THEN
281: RAISE fnd_api.g_exc_unexpected_error;
282: END IF;
283:
284: IF p_init_msg_list IS NULL OR
285: fnd_api.to_boolean (p_init_msg_list)

Line 285: fnd_api.to_boolean (p_init_msg_list)

281: RAISE fnd_api.g_exc_unexpected_error;
282: END IF;
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:

Line 293: IF fnd_api.to_boolean(p_commit)

289:
290: cac_sync_contact_mappings_pkg.delete_row
291: (x_sync_contact_mapping_id => p_sync_contact_mapping_id);
292:
293: IF fnd_api.to_boolean(p_commit)
294: THEN
295: COMMIT WORK;
296: END IF;
297:

Line 301: WHEN fnd_api.g_exc_unexpected_error THEN

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

Line 303: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

Line 311: x_return_status := fnd_api.g_ret_sts_unexp_error;

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:
315: