DBA Data[Home] [Help]

APPS.HZ_PARTY_SEARCH dependencies on HZ_MATCH_RULE_51

Line 310: IF NOT HZ_MATCH_RULE_51.check_staged THEN

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
310: IF NOT HZ_MATCH_RULE_51.check_staged THEN
311: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
312: FND_MSG_PUB.ADD;
313: RAISE FND_API.G_EXC_ERROR;
314: END IF;

Line 315: HZ_MATCH_RULE_51.find_parties(

311: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
312: FND_MSG_PUB.ADD;
313: RAISE FND_API.G_EXC_ERROR;
314: END IF;
315: HZ_MATCH_RULE_51.find_parties(
316: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
317: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,NULL,NULL,NULL,'N',x_search_ctx_id,x_num_matches);
318: -- Code for Match rule BULK MATCH: IDENTICAL PARTIES
319: ELSIF p_rule_id=52 THEN

Line 691: IF NOT HZ_MATCH_RULE_51.check_staged THEN

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
691: IF NOT HZ_MATCH_RULE_51.check_staged THEN
692: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
693: FND_MSG_PUB.ADD;
694: RAISE FND_API.G_EXC_ERROR;
695: END IF;

Line 696: HZ_MATCH_RULE_51.find_persons(

692: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
693: FND_MSG_PUB.ADD;
694: RAISE FND_API.G_EXC_ERROR;
695: END IF;
696: HZ_MATCH_RULE_51.find_persons(
697: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
698: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,'N',x_search_ctx_id,x_num_matches);
699: -- Code for Match rule BULK MATCH: IDENTICAL PARTIES
700: ELSIF p_rule_id=52 THEN

Line 1090: IF NOT HZ_MATCH_RULE_51.check_staged THEN

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
1090: IF NOT HZ_MATCH_RULE_51.check_staged THEN
1091: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1092: FND_MSG_PUB.ADD;
1093: RAISE FND_API.G_EXC_ERROR;
1094: END IF;

Line 1095: HZ_MATCH_RULE_51.find_party_details(

1091: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1092: FND_MSG_PUB.ADD;
1093: RAISE FND_API.G_EXC_ERROR;
1094: END IF;
1095: HZ_MATCH_RULE_51.find_party_details(
1096: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
1097: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
1098: -- Code for Match rule BULK MATCH: IDENTICAL PARTIES
1099: ELSIF p_rule_id=52 THEN

Line 1470: IF NOT HZ_MATCH_RULE_51.check_staged THEN

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
1470: IF NOT HZ_MATCH_RULE_51.check_staged THEN
1471: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1472: FND_MSG_PUB.ADD;
1473: RAISE FND_API.G_EXC_ERROR;
1474: END IF;

Line 1475: HZ_MATCH_RULE_51.find_duplicate_parties(

1471: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1472: FND_MSG_PUB.ADD;
1473: RAISE FND_API.G_EXC_ERROR;
1474: END IF;
1475: HZ_MATCH_RULE_51.find_duplicate_parties(
1476: p_rule_id,p_party_id,
1477: p_restrict_sql,p_match_type,p_dup_batch_id,p_search_merged,x_dup_set_id, x_search_ctx_id,x_num_matches);
1478: -- Code for Match rule BULK MATCH: IDENTICAL PARTIES
1479: ELSIF p_rule_id=52 THEN

Line 1845: IF NOT HZ_MATCH_RULE_51.check_staged THEN

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
1845: IF NOT HZ_MATCH_RULE_51.check_staged THEN
1846: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1847: FND_MSG_PUB.ADD;
1848: RAISE FND_API.G_EXC_ERROR;
1849: END IF;

Line 1850: HZ_MATCH_RULE_51.find_duplicate_party_sites(

1846: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1847: FND_MSG_PUB.ADD;
1848: RAISE FND_API.G_EXC_ERROR;
1849: END IF;
1850: HZ_MATCH_RULE_51.find_duplicate_party_sites(
1851: p_rule_id,p_party_site_id,p_party_id,
1852: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
1853: -- Code for Match rule BULK MATCH: IDENTICAL PARTIES
1854: ELSIF p_rule_id=52 THEN

Line 2219: IF NOT HZ_MATCH_RULE_51.check_staged THEN

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
2219: IF NOT HZ_MATCH_RULE_51.check_staged THEN
2220: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2221: FND_MSG_PUB.ADD;
2222: RAISE FND_API.G_EXC_ERROR;
2223: END IF;

Line 2224: HZ_MATCH_RULE_51.find_duplicate_contacts(

2220: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2221: FND_MSG_PUB.ADD;
2222: RAISE FND_API.G_EXC_ERROR;
2223: END IF;
2224: HZ_MATCH_RULE_51.find_duplicate_contacts(
2225: p_rule_id,p_org_contact_id,p_party_id,
2226: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2227: -- Code for Match rule BULK MATCH: IDENTICAL PARTIES
2228: ELSIF p_rule_id=52 THEN

Line 2593: IF NOT HZ_MATCH_RULE_51.check_staged THEN

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
2593: IF NOT HZ_MATCH_RULE_51.check_staged THEN
2594: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2595: FND_MSG_PUB.ADD;
2596: RAISE FND_API.G_EXC_ERROR;
2597: END IF;

Line 2598: HZ_MATCH_RULE_51.find_duplicate_contact_points(

2594: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2595: FND_MSG_PUB.ADD;
2596: RAISE FND_API.G_EXC_ERROR;
2597: END IF;
2598: HZ_MATCH_RULE_51.find_duplicate_contact_points(
2599: p_rule_id,p_contact_point_id,p_party_id,
2600: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2601: -- Code for Match rule BULK MATCH: IDENTICAL PARTIES
2602: ELSIF p_rule_id=52 THEN

Line 3167: IF NOT HZ_MATCH_RULE_51.check_staged THEN

3163: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3164: p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
3165: -- Code for Match rule BULK MATCH: IDENTICAL PERSONS
3166: ELSIF p_rule_id=51 THEN
3167: IF NOT HZ_MATCH_RULE_51.check_staged THEN
3168: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3169: FND_MSG_PUB.ADD;
3170: RAISE FND_API.G_EXC_ERROR;
3171: END IF;

Line 3172: HZ_MATCH_RULE_51.find_parties_dynamic(

3168: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3169: FND_MSG_PUB.ADD;
3170: RAISE FND_API.G_EXC_ERROR;
3171: END IF;
3172: HZ_MATCH_RULE_51.find_parties_dynamic(
3173: p_rule_id,
3174: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
3175: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
3176: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 3814: IF NOT HZ_MATCH_RULE_51.check_staged THEN

3810: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3811: p_restrict_sql,p_api_name,p_match_type,p_party_id,p_search_merged,x_search_ctx_id,x_num_matches);
3812: -- Code for Match rule BULK MATCH: IDENTICAL PERSONS
3813: ELSIF p_rule_id=51 THEN
3814: IF NOT HZ_MATCH_RULE_51.check_staged THEN
3815: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3816: FND_MSG_PUB.ADD;
3817: RAISE FND_API.G_EXC_ERROR;
3818: END IF;

Line 3819: HZ_MATCH_RULE_51.call_api_dynamic(

3815: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3816: FND_MSG_PUB.ADD;
3817: RAISE FND_API.G_EXC_ERROR;
3818: END IF;
3819: HZ_MATCH_RULE_51.call_api_dynamic(
3820: p_rule_id,
3821: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
3822: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
3823: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 4492: IF NOT HZ_MATCH_RULE_51.check_staged THEN

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
4492: IF NOT HZ_MATCH_RULE_51.check_staged THEN
4493: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4494: FND_MSG_PUB.ADD;
4495: RAISE FND_API.G_EXC_ERROR;
4496: END IF;

Line 4497: HZ_MATCH_RULE_51.get_matching_party_sites(

4493: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4494: FND_MSG_PUB.ADD;
4495: RAISE FND_API.G_EXC_ERROR;
4496: END IF;
4497: HZ_MATCH_RULE_51.get_matching_party_sites(
4498: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4499: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4500: -- Code for Match rule BULK MATCH: IDENTICAL PARTIES
4501: ELSIF p_rule_id=52 THEN

Line 4891: IF NOT HZ_MATCH_RULE_51.check_staged THEN

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
4891: IF NOT HZ_MATCH_RULE_51.check_staged THEN
4892: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4893: FND_MSG_PUB.ADD;
4894: RAISE FND_API.G_EXC_ERROR;
4895: END IF;

Line 4896: HZ_MATCH_RULE_51.get_matching_contacts(

4892: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4893: FND_MSG_PUB.ADD;
4894: RAISE FND_API.G_EXC_ERROR;
4895: END IF;
4896: HZ_MATCH_RULE_51.get_matching_contacts(
4897: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
4898: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4899: -- Code for Match rule BULK MATCH: IDENTICAL PARTIES
4900: ELSIF p_rule_id=52 THEN

Line 5288: IF NOT HZ_MATCH_RULE_51.check_staged THEN

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
5288: IF NOT HZ_MATCH_RULE_51.check_staged THEN
5289: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5290: FND_MSG_PUB.ADD;
5291: RAISE FND_API.G_EXC_ERROR;
5292: END IF;

Line 5293: HZ_MATCH_RULE_51.get_matching_contact_points(

5289: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5290: FND_MSG_PUB.ADD;
5291: RAISE FND_API.G_EXC_ERROR;
5292: END IF;
5293: HZ_MATCH_RULE_51.get_matching_contact_points(
5294: p_rule_id, p_party_id, p_contact_point_list,
5295: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5296: -- Code for Match rule BULK MATCH: IDENTICAL PARTIES
5297: ELSIF p_rule_id=52 THEN

Line 5708: IF NOT HZ_MATCH_RULE_51.check_staged THEN

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
5707: ELSIF p_rule_id=51 THEN
5708: IF NOT HZ_MATCH_RULE_51.check_staged THEN
5709: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5710: FND_MSG_PUB.ADD;
5711: RAISE FND_API.G_EXC_ERROR;
5712: END IF;

Line 5713: HZ_MATCH_RULE_51.get_score_details(

5709: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5710: FND_MSG_PUB.ADD;
5711: RAISE FND_API.G_EXC_ERROR;
5712: END IF;
5713: HZ_MATCH_RULE_51.get_score_details(
5714: p_rule_id,
5715: p_party_id, p_party_search_rec,p_party_site_list,
5716: p_contact_list, p_contact_point_list,x_search_ctx_id);
5717: -- Code for Match rule BULK MATCH: IDENTICAL PARTIES

Line 6086: IF NOT HZ_MATCH_RULE_51.check_staged THEN

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
6086: IF NOT HZ_MATCH_RULE_51.check_staged THEN
6087: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6088: FND_MSG_PUB.ADD;
6089: RAISE FND_API.G_EXC_ERROR;
6090: END IF;

Line 6091: HZ_MATCH_RULE_51.get_party_for_search(

6087: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6088: FND_MSG_PUB.ADD;
6089: RAISE FND_API.G_EXC_ERROR;
6090: END IF;
6091: HZ_MATCH_RULE_51.get_party_for_search(
6092: p_party_id, x_party_search_rec,x_party_site_list,
6093: x_contact_list, x_contact_point_list);
6094: -- Code for Match rule BULK MATCH: IDENTICAL PARTIES
6095: ELSIF p_rule_id=52 THEN

Line 6458: IF NOT HZ_MATCH_RULE_51.check_staged THEN

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
6458: IF NOT HZ_MATCH_RULE_51.check_staged THEN
6459: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6460: FND_MSG_PUB.ADD;
6461: RAISE FND_API.G_EXC_ERROR;
6462: END IF;

Line 6463: HZ_MATCH_RULE_51.get_search_criteria(

6459: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6460: FND_MSG_PUB.ADD;
6461: RAISE FND_API.G_EXC_ERROR;
6462: END IF;
6463: HZ_MATCH_RULE_51.get_search_criteria(
6464: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6465: x_contact_list, x_contact_point_list);
6466: -- Code for Match rule BULK MATCH: IDENTICAL PARTIES
6467: ELSIF p_rule_id=52 THEN