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 711: IF NOT HZ_MATCH_RULE_51.check_staged THEN

707: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
708: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,'N',x_search_ctx_id,x_num_matches);
709: -- Code for Match rule BULK MATCH: IDENTICAL PERSONS
710: ELSIF p_rule_id=51 THEN
711: IF NOT HZ_MATCH_RULE_51.check_staged THEN
712: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
713: FND_MSG_PUB.ADD;
714: RAISE FND_API.G_EXC_ERROR;
715: END IF;

Line 716: HZ_MATCH_RULE_51.find_persons(

712: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
713: FND_MSG_PUB.ADD;
714: RAISE FND_API.G_EXC_ERROR;
715: END IF;
716: HZ_MATCH_RULE_51.find_persons(
717: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
718: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,'N',x_search_ctx_id,x_num_matches);
719: -- Code for Match rule BULK MATCH: IDENTICAL PARTIES
720: ELSIF p_rule_id=52 THEN

Line 1130: IF NOT HZ_MATCH_RULE_51.check_staged THEN

1126: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
1127: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
1128: -- Code for Match rule BULK MATCH: IDENTICAL PERSONS
1129: ELSIF p_rule_id=51 THEN
1130: IF NOT HZ_MATCH_RULE_51.check_staged THEN
1131: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1132: FND_MSG_PUB.ADD;
1133: RAISE FND_API.G_EXC_ERROR;
1134: END IF;

Line 1135: HZ_MATCH_RULE_51.find_party_details(

1131: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1132: FND_MSG_PUB.ADD;
1133: RAISE FND_API.G_EXC_ERROR;
1134: END IF;
1135: HZ_MATCH_RULE_51.find_party_details(
1136: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
1137: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
1138: -- Code for Match rule BULK MATCH: IDENTICAL PARTIES
1139: ELSIF p_rule_id=52 THEN

Line 1530: IF NOT HZ_MATCH_RULE_51.check_staged THEN

1526: p_rule_id,p_party_id,
1527: p_restrict_sql,p_match_type,p_dup_batch_id,p_search_merged,x_dup_set_id, x_search_ctx_id,x_num_matches);
1528: -- Code for Match rule BULK MATCH: IDENTICAL PERSONS
1529: ELSIF p_rule_id=51 THEN
1530: IF NOT HZ_MATCH_RULE_51.check_staged THEN
1531: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1532: FND_MSG_PUB.ADD;
1533: RAISE FND_API.G_EXC_ERROR;
1534: END IF;

Line 1535: HZ_MATCH_RULE_51.find_duplicate_parties(

1531: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1532: FND_MSG_PUB.ADD;
1533: RAISE FND_API.G_EXC_ERROR;
1534: END IF;
1535: HZ_MATCH_RULE_51.find_duplicate_parties(
1536: p_rule_id,p_party_id,
1537: p_restrict_sql,p_match_type,p_dup_batch_id,p_search_merged,x_dup_set_id, x_search_ctx_id,x_num_matches);
1538: -- Code for Match rule BULK MATCH: IDENTICAL PARTIES
1539: ELSIF p_rule_id=52 THEN

Line 1925: IF NOT HZ_MATCH_RULE_51.check_staged THEN

1921: p_rule_id,p_party_site_id,p_party_id,
1922: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
1923: -- Code for Match rule BULK MATCH: IDENTICAL PERSONS
1924: ELSIF p_rule_id=51 THEN
1925: IF NOT HZ_MATCH_RULE_51.check_staged THEN
1926: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1927: FND_MSG_PUB.ADD;
1928: RAISE FND_API.G_EXC_ERROR;
1929: END IF;

Line 1930: HZ_MATCH_RULE_51.find_duplicate_party_sites(

1926: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1927: FND_MSG_PUB.ADD;
1928: RAISE FND_API.G_EXC_ERROR;
1929: END IF;
1930: HZ_MATCH_RULE_51.find_duplicate_party_sites(
1931: p_rule_id,p_party_site_id,p_party_id,
1932: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
1933: -- Code for Match rule BULK MATCH: IDENTICAL PARTIES
1934: ELSIF p_rule_id=52 THEN

Line 2319: IF NOT HZ_MATCH_RULE_51.check_staged THEN

2315: p_rule_id,p_org_contact_id,p_party_id,
2316: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2317: -- Code for Match rule BULK MATCH: IDENTICAL PERSONS
2318: ELSIF p_rule_id=51 THEN
2319: IF NOT HZ_MATCH_RULE_51.check_staged THEN
2320: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2321: FND_MSG_PUB.ADD;
2322: RAISE FND_API.G_EXC_ERROR;
2323: END IF;

Line 2324: HZ_MATCH_RULE_51.find_duplicate_contacts(

2320: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2321: FND_MSG_PUB.ADD;
2322: RAISE FND_API.G_EXC_ERROR;
2323: END IF;
2324: HZ_MATCH_RULE_51.find_duplicate_contacts(
2325: p_rule_id,p_org_contact_id,p_party_id,
2326: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2327: -- Code for Match rule BULK MATCH: IDENTICAL PARTIES
2328: ELSIF p_rule_id=52 THEN

Line 2713: IF NOT HZ_MATCH_RULE_51.check_staged THEN

2709: p_rule_id,p_contact_point_id,p_party_id,
2710: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2711: -- Code for Match rule BULK MATCH: IDENTICAL PERSONS
2712: ELSIF p_rule_id=51 THEN
2713: IF NOT HZ_MATCH_RULE_51.check_staged THEN
2714: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2715: FND_MSG_PUB.ADD;
2716: RAISE FND_API.G_EXC_ERROR;
2717: END IF;

Line 2718: HZ_MATCH_RULE_51.find_duplicate_contact_points(

2714: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2715: FND_MSG_PUB.ADD;
2716: RAISE FND_API.G_EXC_ERROR;
2717: END IF;
2718: HZ_MATCH_RULE_51.find_duplicate_contact_points(
2719: p_rule_id,p_contact_point_id,p_party_id,
2720: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2721: -- Code for Match rule BULK MATCH: IDENTICAL PARTIES
2722: ELSIF p_rule_id=52 THEN

Line 3307: IF NOT HZ_MATCH_RULE_51.check_staged THEN

3303: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3304: p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
3305: -- Code for Match rule BULK MATCH: IDENTICAL PERSONS
3306: ELSIF p_rule_id=51 THEN
3307: IF NOT HZ_MATCH_RULE_51.check_staged THEN
3308: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3309: FND_MSG_PUB.ADD;
3310: RAISE FND_API.G_EXC_ERROR;
3311: END IF;

Line 3312: HZ_MATCH_RULE_51.find_parties_dynamic(

3308: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3309: FND_MSG_PUB.ADD;
3310: RAISE FND_API.G_EXC_ERROR;
3311: END IF;
3312: HZ_MATCH_RULE_51.find_parties_dynamic(
3313: p_rule_id,
3314: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
3315: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
3316: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 3990: IF NOT HZ_MATCH_RULE_51.check_staged THEN

3986: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3987: p_restrict_sql,p_api_name,p_match_type,p_party_id,p_search_merged,x_search_ctx_id,x_num_matches);
3988: -- Code for Match rule BULK MATCH: IDENTICAL PERSONS
3989: ELSIF p_rule_id=51 THEN
3990: IF NOT HZ_MATCH_RULE_51.check_staged THEN
3991: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3992: FND_MSG_PUB.ADD;
3993: RAISE FND_API.G_EXC_ERROR;
3994: END IF;

Line 3995: HZ_MATCH_RULE_51.call_api_dynamic(

3991: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3992: FND_MSG_PUB.ADD;
3993: RAISE FND_API.G_EXC_ERROR;
3994: END IF;
3995: HZ_MATCH_RULE_51.call_api_dynamic(
3996: p_rule_id,
3997: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
3998: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
3999: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 4704: IF NOT HZ_MATCH_RULE_51.check_staged THEN

4700: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4701: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4702: -- Code for Match rule BULK MATCH: IDENTICAL PERSONS
4703: ELSIF p_rule_id=51 THEN
4704: IF NOT HZ_MATCH_RULE_51.check_staged THEN
4705: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4706: FND_MSG_PUB.ADD;
4707: RAISE FND_API.G_EXC_ERROR;
4708: END IF;

Line 4709: HZ_MATCH_RULE_51.get_matching_party_sites(

4705: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4706: FND_MSG_PUB.ADD;
4707: RAISE FND_API.G_EXC_ERROR;
4708: END IF;
4709: HZ_MATCH_RULE_51.get_matching_party_sites(
4710: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4711: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4712: -- Code for Match rule BULK MATCH: IDENTICAL PARTIES
4713: ELSIF p_rule_id=52 THEN

Line 5123: IF NOT HZ_MATCH_RULE_51.check_staged THEN

5119: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
5120: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5121: -- Code for Match rule BULK MATCH: IDENTICAL PERSONS
5122: ELSIF p_rule_id=51 THEN
5123: IF NOT HZ_MATCH_RULE_51.check_staged THEN
5124: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5125: FND_MSG_PUB.ADD;
5126: RAISE FND_API.G_EXC_ERROR;
5127: END IF;

Line 5128: HZ_MATCH_RULE_51.get_matching_contacts(

5124: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5125: FND_MSG_PUB.ADD;
5126: RAISE FND_API.G_EXC_ERROR;
5127: END IF;
5128: HZ_MATCH_RULE_51.get_matching_contacts(
5129: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
5130: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5131: -- Code for Match rule BULK MATCH: IDENTICAL PARTIES
5132: ELSIF p_rule_id=52 THEN

Line 5540: IF NOT HZ_MATCH_RULE_51.check_staged THEN

5536: p_rule_id, p_party_id, p_contact_point_list,
5537: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5538: -- Code for Match rule BULK MATCH: IDENTICAL PERSONS
5539: ELSIF p_rule_id=51 THEN
5540: IF NOT HZ_MATCH_RULE_51.check_staged THEN
5541: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5542: FND_MSG_PUB.ADD;
5543: RAISE FND_API.G_EXC_ERROR;
5544: END IF;

Line 5545: HZ_MATCH_RULE_51.get_matching_contact_points(

5541: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5542: FND_MSG_PUB.ADD;
5543: RAISE FND_API.G_EXC_ERROR;
5544: END IF;
5545: HZ_MATCH_RULE_51.get_matching_contact_points(
5546: p_rule_id, p_party_id, p_contact_point_list,
5547: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5548: -- Code for Match rule BULK MATCH: IDENTICAL PARTIES
5549: ELSIF p_rule_id=52 THEN

Line 5980: IF NOT HZ_MATCH_RULE_51.check_staged THEN

5976: p_party_id, p_party_search_rec,p_party_site_list,
5977: p_contact_list, p_contact_point_list,x_search_ctx_id);
5978: -- Code for Match rule BULK MATCH: IDENTICAL PERSONS
5979: ELSIF p_rule_id=51 THEN
5980: IF NOT HZ_MATCH_RULE_51.check_staged THEN
5981: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5982: FND_MSG_PUB.ADD;
5983: RAISE FND_API.G_EXC_ERROR;
5984: END IF;

Line 5985: HZ_MATCH_RULE_51.get_score_details(

5981: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5982: FND_MSG_PUB.ADD;
5983: RAISE FND_API.G_EXC_ERROR;
5984: END IF;
5985: HZ_MATCH_RULE_51.get_score_details(
5986: p_rule_id,
5987: p_party_id, p_party_search_rec,p_party_site_list,
5988: p_contact_list, p_contact_point_list,x_search_ctx_id);
5989: -- Code for Match rule BULK MATCH: IDENTICAL PARTIES

Line 6380: IF NOT HZ_MATCH_RULE_51.check_staged THEN

6376: p_party_id, x_party_search_rec,x_party_site_list,
6377: x_contact_list, x_contact_point_list);
6378: -- Code for Match rule BULK MATCH: IDENTICAL PERSONS
6379: ELSIF p_rule_id=51 THEN
6380: IF NOT HZ_MATCH_RULE_51.check_staged THEN
6381: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6382: FND_MSG_PUB.ADD;
6383: RAISE FND_API.G_EXC_ERROR;
6384: END IF;

Line 6385: HZ_MATCH_RULE_51.get_party_for_search(

6381: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6382: FND_MSG_PUB.ADD;
6383: RAISE FND_API.G_EXC_ERROR;
6384: END IF;
6385: HZ_MATCH_RULE_51.get_party_for_search(
6386: p_party_id, x_party_search_rec,x_party_site_list,
6387: x_contact_list, x_contact_point_list);
6388: -- Code for Match rule BULK MATCH: IDENTICAL PARTIES
6389: ELSIF p_rule_id=52 THEN

Line 6772: IF NOT HZ_MATCH_RULE_51.check_staged THEN

6768: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6769: x_contact_list, x_contact_point_list);
6770: -- Code for Match rule BULK MATCH: IDENTICAL PERSONS
6771: ELSIF p_rule_id=51 THEN
6772: IF NOT HZ_MATCH_RULE_51.check_staged THEN
6773: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6774: FND_MSG_PUB.ADD;
6775: RAISE FND_API.G_EXC_ERROR;
6776: END IF;

Line 6777: HZ_MATCH_RULE_51.get_search_criteria(

6773: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6774: FND_MSG_PUB.ADD;
6775: RAISE FND_API.G_EXC_ERROR;
6776: END IF;
6777: HZ_MATCH_RULE_51.get_search_criteria(
6778: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6779: x_contact_list, x_contact_point_list);
6780: -- Code for Match rule BULK MATCH: IDENTICAL PARTIES
6781: ELSIF p_rule_id=52 THEN