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_DQM_PVT dependencies on FND_API

Line 267: fnd_api.to_boolean (p_init_msg_list)

263: l_num_matches NUMBER;
264: l_rule_id NUMBER;
265: BEGIN
266: IF p_init_msg_list IS NULL OR
267: fnd_api.to_boolean (p_init_msg_list)
268: THEN
269: fnd_msg_pub.initialize;
270: END IF;
271:

Line 278: RAISE fnd_api.g_exc_unexpected_error;

274: IF l_rule_id IS NULL THEN
275: fnd_message.set_name ('JTF', 'CAC_SYNC_CONTACT_MATCH_RULE_NF');
276: fnd_message.set_token ('P_PROFILE', get_user_profile_name('HZ_ORG_DUP_PREV_MATCHRULE'));
277: fnd_msg_pub.add;
278: RAISE fnd_api.g_exc_unexpected_error;
279: END IF;
280:
281: l_party_search_rec.organization_name := p_organization_name;
282: l_party_search_rec.party_all_names := p_organization_name;

Line 288: p_init_msg_list => fnd_api.g_false,

284: l_party_search_rec.party_type := 'ORGANIZATION';
285: l_party_search_rec.status := 'A';
286:
287: hz_party_search.find_parties(
288: p_init_msg_list => fnd_api.g_false,
289: x_rule_id => l_rule_id,
290: p_party_search_rec => l_party_search_rec,
291: p_party_site_list => l_party_site_list,
292: p_contact_list => l_contact_list,

Line 303: IF NOT (x_return_status = fnd_api.g_ret_sts_success)

299: x_msg_count => x_msg_count,
300: x_msg_data => x_msg_data
301: );
302:
303: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
304: THEN
305: x_return_status := fnd_api.g_ret_sts_unexp_error;
306: RAISE fnd_api.g_exc_unexpected_error;
307: ELSE

Line 305: x_return_status := fnd_api.g_ret_sts_unexp_error;

301: );
302:
303: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
304: THEN
305: x_return_status := fnd_api.g_ret_sts_unexp_error;
306: RAISE fnd_api.g_exc_unexpected_error;
307: ELSE
308: IF l_num_matches = 1 THEN
309: x_organization_id := get_organization_party_id(l_search_ctx_id);

Line 306: RAISE fnd_api.g_exc_unexpected_error;

302:
303: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
304: THEN
305: x_return_status := fnd_api.g_ret_sts_unexp_error;
306: RAISE fnd_api.g_exc_unexpected_error;
307: ELSE
308: IF l_num_matches = 1 THEN
309: x_organization_id := get_organization_party_id(l_search_ctx_id);
310: ELSE

Line 321: RAISE fnd_api.g_exc_unexpected_error;

317: fnd_message.set_name ('JTF', 'CAC_SYNC_DQM_ORG_TOOMANY');
318: fnd_message.set_token ('P_CONTACT_NAME', p_contact_name);
319: END IF;
320: fnd_msg_pub.add;
321: RAISE fnd_api.g_exc_unexpected_error;
322: END IF;
323: END IF;
324:
325: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 328: WHEN fnd_api.g_exc_unexpected_error THEN

324:
325: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
326:
327: EXCEPTION
328: WHEN fnd_api.g_exc_unexpected_error THEN
329: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
330: x_return_status := fnd_api.g_ret_sts_unexp_error;
331:
332: WHEN OTHERS THEN

Line 330: x_return_status := fnd_api.g_ret_sts_unexp_error;

326:
327: EXCEPTION
328: WHEN fnd_api.g_exc_unexpected_error THEN
329: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
330: x_return_status := fnd_api.g_ret_sts_unexp_error;
331:
332: WHEN OTHERS THEN
333: fnd_message.set_name ('JTF', 'CAC_SYNC_CONTACT_UNEXPECTED_ER');
334: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);

Line 336: x_return_status := fnd_api.g_ret_sts_unexp_error;

332: WHEN OTHERS THEN
333: fnd_message.set_name ('JTF', 'CAC_SYNC_CONTACT_UNEXPECTED_ER');
334: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
335: fnd_msg_pub.add;
336: x_return_status := fnd_api.g_ret_sts_unexp_error;
337: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
338: END FIND_ORGANIZATION;
339:
340: PROCEDURE CHECK_CONTACT

Line 384: fnd_api.to_boolean (p_init_msg_list)

380: l_num_matches NUMBER;
381: l_index NUMBER;
382: BEGIN
383: IF p_init_msg_list IS NULL OR
384: fnd_api.to_boolean (p_init_msg_list)
385: THEN
386: fnd_msg_pub.initialize;
387: END IF;
388:

Line 389: x_return_status := fnd_api.g_ret_sts_success;

385: THEN
386: fnd_msg_pub.initialize;
387: END IF;
388:
389: x_return_status := fnd_api.g_ret_sts_success;
390:
391: l_rule_id := fnd_profile.value('HZ_CON_DUP_PREV_MATCHRULE');
392: IF l_rule_id IS NULL THEN
393: fnd_message.set_name ('JTF', 'CAC_SYNC_CONTACT_MATCH_RULE_NF');

Line 396: RAISE fnd_api.g_exc_unexpected_error;

392: IF l_rule_id IS NULL THEN
393: fnd_message.set_name ('JTF', 'CAC_SYNC_CONTACT_MATCH_RULE_NF');
394: fnd_message.set_token ('P_PROFILE', get_user_profile_name('HZ_CON_DUP_PREV_MATCHRULE'));
395: fnd_msg_pub.add;
396: RAISE fnd_api.g_exc_unexpected_error;
397: END IF;
398:
399: -- Prepare contact list
400: l_contact_list(1) := get_contact_search_rec

Line 435: p_init_msg_list => fnd_api.g_false,

431: );
432:
433: -- Perform DQM check for contacts
434: hz_party_search.get_matching_contacts(
435: p_init_msg_list => fnd_api.g_false,
436: p_rule_id => l_rule_id,
437: p_party_id => p_org_party_id,
438: p_contact_list => l_contact_list,
439: p_contact_point_list => l_contact_point_list,

Line 449: IF NOT (x_return_status = fnd_api.g_ret_sts_success)

445: x_msg_count => x_msg_count,
446: x_msg_data => x_msg_data
447: );
448:
449: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
450: THEN
451: x_return_status := fnd_api.g_ret_sts_unexp_error;
452: RAISE fnd_api.g_exc_unexpected_error;
453: ELSE

Line 451: x_return_status := fnd_api.g_ret_sts_unexp_error;

447: );
448:
449: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
450: THEN
451: x_return_status := fnd_api.g_ret_sts_unexp_error;
452: RAISE fnd_api.g_exc_unexpected_error;
453: ELSE
454: IF l_num_matches > 1 THEN
455: -- Error message: : Multiple matches for the contact were found, contact not synchronized.

Line 452: RAISE fnd_api.g_exc_unexpected_error;

448:
449: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
450: THEN
451: x_return_status := fnd_api.g_ret_sts_unexp_error;
452: RAISE fnd_api.g_exc_unexpected_error;
453: ELSE
454: IF l_num_matches > 1 THEN
455: -- Error message: : Multiple matches for the contact were found, contact not synchronized.
456: fnd_message.set_name ('JTF', 'CAC_SYNC_DQM_CONTACT_EXISTS');

Line 459: RAISE fnd_api.g_exc_unexpected_error;

455: -- Error message: : Multiple matches for the contact were found, contact not synchronized.
456: fnd_message.set_name ('JTF', 'CAC_SYNC_DQM_CONTACT_EXISTS');
457: fnd_message.set_token ('P_CONTACT_NAME', p_person_full_name);
458: fnd_msg_pub.add;
459: RAISE fnd_api.g_exc_unexpected_error;
460: ELSE
461: x_num_of_matches := l_num_matches;
462: x_party_id := get_party_id(l_search_ctx_id);
463: END IF;

Line 469: WHEN fnd_api.g_exc_unexpected_error THEN

465:
466: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
467:
468: EXCEPTION
469: WHEN fnd_api.g_exc_unexpected_error THEN
470: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
471: x_return_status := fnd_api.g_ret_sts_unexp_error;
472:
473: WHEN OTHERS THEN

Line 471: x_return_status := fnd_api.g_ret_sts_unexp_error;

467:
468: EXCEPTION
469: WHEN fnd_api.g_exc_unexpected_error THEN
470: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
471: x_return_status := fnd_api.g_ret_sts_unexp_error;
472:
473: WHEN OTHERS THEN
474: fnd_message.set_name ('JTF', 'CAC_SYNC_CONTACT_UNEXPECTED_ER');
475: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);

Line 477: x_return_status := fnd_api.g_ret_sts_unexp_error;

473: WHEN OTHERS THEN
474: fnd_message.set_name ('JTF', 'CAC_SYNC_CONTACT_UNEXPECTED_ER');
475: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
476: fnd_msg_pub.add;
477: x_return_status := fnd_api.g_ret_sts_unexp_error;
478: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
479: END CHECK_CONTACT;
480:
481: END CAC_SYNC_CONTACT_DQM_PVT;