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:
272: l_rule_id := fnd_profile.value('HZ_ORG_DUP_PREV_MATCHRULE');
273:
273:
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;
316: -- Error message:
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:
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);
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);
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
333: fnd_message.set_name ('JTF', 'CAC_SYNC_CONTACT_UNEXPECTED_ER');
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);
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:
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
341: ( p_init_msg_list IN VARCHAR2
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:
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');
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
454: IF l_num_matches > 1 THEN
455: -- Error message:
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);
462: x_party_id := get_party_id(l_search_ctx_id);
463: END IF;
464: END IF;
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);
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
474: fnd_message.set_name ('JTF', 'CAC_SYNC_CONTACT_UNEXPECTED_ER');
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);
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:
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;