DBA Data[Home] [Help]

APPS.HZ_PARTY_SEARCH dependencies on HZ_MATCH_RULE_50

Line 300: IF NOT HZ_MATCH_RULE_50.check_staged THEN

296: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
297: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,NULL,NULL,NULL,'N',x_search_ctx_id,x_num_matches);
298: -- Code for Match rule BULK MATCH: IDENTICAL ORGANIZATIONS
299: ELSIF p_rule_id=50 THEN
300: IF NOT HZ_MATCH_RULE_50.check_staged THEN
301: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
302: FND_MSG_PUB.ADD;
303: RAISE FND_API.G_EXC_ERROR;
304: END IF;

Line 305: HZ_MATCH_RULE_50.find_parties(

301: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
302: FND_MSG_PUB.ADD;
303: RAISE FND_API.G_EXC_ERROR;
304: END IF;
305: HZ_MATCH_RULE_50.find_parties(
306: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
307: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,NULL,NULL,NULL,'N',x_search_ctx_id,x_num_matches);
308: -- Code for Match rule BULK MATCH: IDENTICAL PERSONS
309: ELSIF p_rule_id=51 THEN

Line 681: IF NOT HZ_MATCH_RULE_50.check_staged THEN

677: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
678: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,'N',x_search_ctx_id,x_num_matches);
679: -- Code for Match rule BULK MATCH: IDENTICAL ORGANIZATIONS
680: ELSIF p_rule_id=50 THEN
681: IF NOT HZ_MATCH_RULE_50.check_staged THEN
682: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
683: FND_MSG_PUB.ADD;
684: RAISE FND_API.G_EXC_ERROR;
685: END IF;

Line 686: HZ_MATCH_RULE_50.find_persons(

682: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
683: FND_MSG_PUB.ADD;
684: RAISE FND_API.G_EXC_ERROR;
685: END IF;
686: HZ_MATCH_RULE_50.find_persons(
687: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
688: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,'N',x_search_ctx_id,x_num_matches);
689: -- Code for Match rule BULK MATCH: IDENTICAL PERSONS
690: ELSIF p_rule_id=51 THEN

Line 1080: IF NOT HZ_MATCH_RULE_50.check_staged THEN

1076: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
1077: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
1078: -- Code for Match rule BULK MATCH: IDENTICAL ORGANIZATIONS
1079: ELSIF p_rule_id=50 THEN
1080: IF NOT HZ_MATCH_RULE_50.check_staged THEN
1081: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1082: FND_MSG_PUB.ADD;
1083: RAISE FND_API.G_EXC_ERROR;
1084: END IF;

Line 1085: HZ_MATCH_RULE_50.find_party_details(

1081: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1082: FND_MSG_PUB.ADD;
1083: RAISE FND_API.G_EXC_ERROR;
1084: END IF;
1085: HZ_MATCH_RULE_50.find_party_details(
1086: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
1087: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
1088: -- Code for Match rule BULK MATCH: IDENTICAL PERSONS
1089: ELSIF p_rule_id=51 THEN

Line 1460: IF NOT HZ_MATCH_RULE_50.check_staged THEN

1456: p_rule_id,p_party_id,
1457: p_restrict_sql,p_match_type,p_dup_batch_id,p_search_merged,x_dup_set_id, x_search_ctx_id,x_num_matches);
1458: -- Code for Match rule BULK MATCH: IDENTICAL ORGANIZATIONS
1459: ELSIF p_rule_id=50 THEN
1460: IF NOT HZ_MATCH_RULE_50.check_staged THEN
1461: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1462: FND_MSG_PUB.ADD;
1463: RAISE FND_API.G_EXC_ERROR;
1464: END IF;

Line 1465: HZ_MATCH_RULE_50.find_duplicate_parties(

1461: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1462: FND_MSG_PUB.ADD;
1463: RAISE FND_API.G_EXC_ERROR;
1464: END IF;
1465: HZ_MATCH_RULE_50.find_duplicate_parties(
1466: p_rule_id,p_party_id,
1467: p_restrict_sql,p_match_type,p_dup_batch_id,p_search_merged,x_dup_set_id, x_search_ctx_id,x_num_matches);
1468: -- Code for Match rule BULK MATCH: IDENTICAL PERSONS
1469: ELSIF p_rule_id=51 THEN

Line 1835: IF NOT HZ_MATCH_RULE_50.check_staged THEN

1831: p_rule_id,p_party_site_id,p_party_id,
1832: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
1833: -- Code for Match rule BULK MATCH: IDENTICAL ORGANIZATIONS
1834: ELSIF p_rule_id=50 THEN
1835: IF NOT HZ_MATCH_RULE_50.check_staged THEN
1836: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1837: FND_MSG_PUB.ADD;
1838: RAISE FND_API.G_EXC_ERROR;
1839: END IF;

Line 1840: HZ_MATCH_RULE_50.find_duplicate_party_sites(

1836: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1837: FND_MSG_PUB.ADD;
1838: RAISE FND_API.G_EXC_ERROR;
1839: END IF;
1840: HZ_MATCH_RULE_50.find_duplicate_party_sites(
1841: p_rule_id,p_party_site_id,p_party_id,
1842: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
1843: -- Code for Match rule BULK MATCH: IDENTICAL PERSONS
1844: ELSIF p_rule_id=51 THEN

Line 2209: IF NOT HZ_MATCH_RULE_50.check_staged THEN

2205: p_rule_id,p_org_contact_id,p_party_id,
2206: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2207: -- Code for Match rule BULK MATCH: IDENTICAL ORGANIZATIONS
2208: ELSIF p_rule_id=50 THEN
2209: IF NOT HZ_MATCH_RULE_50.check_staged THEN
2210: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2211: FND_MSG_PUB.ADD;
2212: RAISE FND_API.G_EXC_ERROR;
2213: END IF;

Line 2214: HZ_MATCH_RULE_50.find_duplicate_contacts(

2210: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2211: FND_MSG_PUB.ADD;
2212: RAISE FND_API.G_EXC_ERROR;
2213: END IF;
2214: HZ_MATCH_RULE_50.find_duplicate_contacts(
2215: p_rule_id,p_org_contact_id,p_party_id,
2216: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2217: -- Code for Match rule BULK MATCH: IDENTICAL PERSONS
2218: ELSIF p_rule_id=51 THEN

Line 2583: IF NOT HZ_MATCH_RULE_50.check_staged THEN

2579: p_rule_id,p_contact_point_id,p_party_id,
2580: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2581: -- Code for Match rule BULK MATCH: IDENTICAL ORGANIZATIONS
2582: ELSIF p_rule_id=50 THEN
2583: IF NOT HZ_MATCH_RULE_50.check_staged THEN
2584: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2585: FND_MSG_PUB.ADD;
2586: RAISE FND_API.G_EXC_ERROR;
2587: END IF;

Line 2588: HZ_MATCH_RULE_50.find_duplicate_contact_points(

2584: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2585: FND_MSG_PUB.ADD;
2586: RAISE FND_API.G_EXC_ERROR;
2587: END IF;
2588: HZ_MATCH_RULE_50.find_duplicate_contact_points(
2589: p_rule_id,p_contact_point_id,p_party_id,
2590: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2591: -- Code for Match rule BULK MATCH: IDENTICAL PERSONS
2592: ELSIF p_rule_id=51 THEN

Line 3149: IF NOT HZ_MATCH_RULE_50.check_staged THEN

3145: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3146: p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
3147: -- Code for Match rule BULK MATCH: IDENTICAL ORGANIZATIONS
3148: ELSIF p_rule_id=50 THEN
3149: IF NOT HZ_MATCH_RULE_50.check_staged THEN
3150: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3151: FND_MSG_PUB.ADD;
3152: RAISE FND_API.G_EXC_ERROR;
3153: END IF;

Line 3154: HZ_MATCH_RULE_50.find_parties_dynamic(

3150: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3151: FND_MSG_PUB.ADD;
3152: RAISE FND_API.G_EXC_ERROR;
3153: END IF;
3154: HZ_MATCH_RULE_50.find_parties_dynamic(
3155: p_rule_id,
3156: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
3157: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
3158: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 3796: IF NOT HZ_MATCH_RULE_50.check_staged THEN

3792: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3793: p_restrict_sql,p_api_name,p_match_type,p_party_id,p_search_merged,x_search_ctx_id,x_num_matches);
3794: -- Code for Match rule BULK MATCH: IDENTICAL ORGANIZATIONS
3795: ELSIF p_rule_id=50 THEN
3796: IF NOT HZ_MATCH_RULE_50.check_staged THEN
3797: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3798: FND_MSG_PUB.ADD;
3799: RAISE FND_API.G_EXC_ERROR;
3800: END IF;

Line 3801: HZ_MATCH_RULE_50.call_api_dynamic(

3797: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3798: FND_MSG_PUB.ADD;
3799: RAISE FND_API.G_EXC_ERROR;
3800: END IF;
3801: HZ_MATCH_RULE_50.call_api_dynamic(
3802: p_rule_id,
3803: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
3804: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
3805: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 4482: IF NOT HZ_MATCH_RULE_50.check_staged THEN

4478: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4479: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4480: -- Code for Match rule BULK MATCH: IDENTICAL ORGANIZATIONS
4481: ELSIF p_rule_id=50 THEN
4482: IF NOT HZ_MATCH_RULE_50.check_staged THEN
4483: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4484: FND_MSG_PUB.ADD;
4485: RAISE FND_API.G_EXC_ERROR;
4486: END IF;

Line 4487: HZ_MATCH_RULE_50.get_matching_party_sites(

4483: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4484: FND_MSG_PUB.ADD;
4485: RAISE FND_API.G_EXC_ERROR;
4486: END IF;
4487: HZ_MATCH_RULE_50.get_matching_party_sites(
4488: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4489: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4490: -- Code for Match rule BULK MATCH: IDENTICAL PERSONS
4491: ELSIF p_rule_id=51 THEN

Line 4881: IF NOT HZ_MATCH_RULE_50.check_staged THEN

4877: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
4878: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4879: -- Code for Match rule BULK MATCH: IDENTICAL ORGANIZATIONS
4880: ELSIF p_rule_id=50 THEN
4881: IF NOT HZ_MATCH_RULE_50.check_staged THEN
4882: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4883: FND_MSG_PUB.ADD;
4884: RAISE FND_API.G_EXC_ERROR;
4885: END IF;

Line 4886: HZ_MATCH_RULE_50.get_matching_contacts(

4882: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4883: FND_MSG_PUB.ADD;
4884: RAISE FND_API.G_EXC_ERROR;
4885: END IF;
4886: HZ_MATCH_RULE_50.get_matching_contacts(
4887: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
4888: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4889: -- Code for Match rule BULK MATCH: IDENTICAL PERSONS
4890: ELSIF p_rule_id=51 THEN

Line 5278: IF NOT HZ_MATCH_RULE_50.check_staged THEN

5274: p_rule_id, p_party_id, p_contact_point_list,
5275: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5276: -- Code for Match rule BULK MATCH: IDENTICAL ORGANIZATIONS
5277: ELSIF p_rule_id=50 THEN
5278: IF NOT HZ_MATCH_RULE_50.check_staged THEN
5279: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5280: FND_MSG_PUB.ADD;
5281: RAISE FND_API.G_EXC_ERROR;
5282: END IF;

Line 5283: HZ_MATCH_RULE_50.get_matching_contact_points(

5279: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5280: FND_MSG_PUB.ADD;
5281: RAISE FND_API.G_EXC_ERROR;
5282: END IF;
5283: HZ_MATCH_RULE_50.get_matching_contact_points(
5284: p_rule_id, p_party_id, p_contact_point_list,
5285: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5286: -- Code for Match rule BULK MATCH: IDENTICAL PERSONS
5287: ELSIF p_rule_id=51 THEN

Line 5697: IF NOT HZ_MATCH_RULE_50.check_staged THEN

5693: p_party_id, p_party_search_rec,p_party_site_list,
5694: p_contact_list, p_contact_point_list,x_search_ctx_id);
5695: -- Code for Match rule BULK MATCH: IDENTICAL ORGANIZATIONS
5696: ELSIF p_rule_id=50 THEN
5697: IF NOT HZ_MATCH_RULE_50.check_staged THEN
5698: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5699: FND_MSG_PUB.ADD;
5700: RAISE FND_API.G_EXC_ERROR;
5701: END IF;

Line 5702: HZ_MATCH_RULE_50.get_score_details(

5698: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5699: FND_MSG_PUB.ADD;
5700: RAISE FND_API.G_EXC_ERROR;
5701: END IF;
5702: HZ_MATCH_RULE_50.get_score_details(
5703: p_rule_id,
5704: p_party_id, p_party_search_rec,p_party_site_list,
5705: p_contact_list, p_contact_point_list,x_search_ctx_id);
5706: -- Code for Match rule BULK MATCH: IDENTICAL PERSONS

Line 6076: IF NOT HZ_MATCH_RULE_50.check_staged THEN

6072: p_party_id, x_party_search_rec,x_party_site_list,
6073: x_contact_list, x_contact_point_list);
6074: -- Code for Match rule BULK MATCH: IDENTICAL ORGANIZATIONS
6075: ELSIF p_rule_id=50 THEN
6076: IF NOT HZ_MATCH_RULE_50.check_staged THEN
6077: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6078: FND_MSG_PUB.ADD;
6079: RAISE FND_API.G_EXC_ERROR;
6080: END IF;

Line 6081: HZ_MATCH_RULE_50.get_party_for_search(

6077: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6078: FND_MSG_PUB.ADD;
6079: RAISE FND_API.G_EXC_ERROR;
6080: END IF;
6081: HZ_MATCH_RULE_50.get_party_for_search(
6082: p_party_id, x_party_search_rec,x_party_site_list,
6083: x_contact_list, x_contact_point_list);
6084: -- Code for Match rule BULK MATCH: IDENTICAL PERSONS
6085: ELSIF p_rule_id=51 THEN

Line 6448: IF NOT HZ_MATCH_RULE_50.check_staged THEN

6444: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6445: x_contact_list, x_contact_point_list);
6446: -- Code for Match rule BULK MATCH: IDENTICAL ORGANIZATIONS
6447: ELSIF p_rule_id=50 THEN
6448: IF NOT HZ_MATCH_RULE_50.check_staged THEN
6449: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6450: FND_MSG_PUB.ADD;
6451: RAISE FND_API.G_EXC_ERROR;
6452: END IF;

Line 6453: HZ_MATCH_RULE_50.get_search_criteria(

6449: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6450: FND_MSG_PUB.ADD;
6451: RAISE FND_API.G_EXC_ERROR;
6452: END IF;
6453: HZ_MATCH_RULE_50.get_search_criteria(
6454: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6455: x_contact_list, x_contact_point_list);
6456: -- Code for Match rule BULK MATCH: IDENTICAL PERSONS
6457: ELSIF p_rule_id=51 THEN