DBA Data[Home] [Help]

APPS.HZ_PARTY_SEARCH dependencies on HZ_MATCH_RULE_40

Line 260: IF NOT HZ_MATCH_RULE_40.check_staged THEN

256: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
257: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,NULL,NULL,NULL,'N',x_search_ctx_id,x_num_matches);
258: -- Code for Match rule SAMPLE: SEARCH SIMILAR ORGANIZATION EXACT
259: ELSIF p_rule_id=40 THEN
260: IF NOT HZ_MATCH_RULE_40.check_staged THEN
261: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
262: FND_MSG_PUB.ADD;
263: RAISE FND_API.G_EXC_ERROR;
264: END IF;

Line 265: HZ_MATCH_RULE_40.find_parties(

261: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
262: FND_MSG_PUB.ADD;
263: RAISE FND_API.G_EXC_ERROR;
264: END IF;
265: HZ_MATCH_RULE_40.find_parties(
266: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
267: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,NULL,NULL,NULL,'N',x_search_ctx_id,x_num_matches);
268: -- Code for Match rule SAMPLE: SEARCH SIMILAR PERSON EXACT
269: ELSIF p_rule_id=41 THEN

Line 661: IF NOT HZ_MATCH_RULE_40.check_staged THEN

657: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
658: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,'N',x_search_ctx_id,x_num_matches);
659: -- Code for Match rule SAMPLE: SEARCH SIMILAR ORGANIZATION EXACT
660: ELSIF p_rule_id=40 THEN
661: IF NOT HZ_MATCH_RULE_40.check_staged THEN
662: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
663: FND_MSG_PUB.ADD;
664: RAISE FND_API.G_EXC_ERROR;
665: END IF;

Line 666: HZ_MATCH_RULE_40.find_persons(

662: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
663: FND_MSG_PUB.ADD;
664: RAISE FND_API.G_EXC_ERROR;
665: END IF;
666: HZ_MATCH_RULE_40.find_persons(
667: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
668: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,'N',x_search_ctx_id,x_num_matches);
669: -- Code for Match rule SAMPLE: SEARCH SIMILAR PERSON EXACT
670: ELSIF p_rule_id=41 THEN

Line 1080: IF NOT HZ_MATCH_RULE_40.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 SAMPLE: SEARCH SIMILAR ORGANIZATION EXACT
1079: ELSIF p_rule_id=40 THEN
1080: IF NOT HZ_MATCH_RULE_40.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_40.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_40.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 SAMPLE: SEARCH SIMILAR PERSON EXACT
1089: ELSIF p_rule_id=41 THEN

Line 1480: IF NOT HZ_MATCH_RULE_40.check_staged THEN

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 SAMPLE: SEARCH SIMILAR ORGANIZATION EXACT
1479: ELSIF p_rule_id=40 THEN
1480: IF NOT HZ_MATCH_RULE_40.check_staged THEN
1481: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1482: FND_MSG_PUB.ADD;
1483: RAISE FND_API.G_EXC_ERROR;
1484: END IF;

Line 1485: HZ_MATCH_RULE_40.find_duplicate_parties(

1481: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1482: FND_MSG_PUB.ADD;
1483: RAISE FND_API.G_EXC_ERROR;
1484: END IF;
1485: HZ_MATCH_RULE_40.find_duplicate_parties(
1486: p_rule_id,p_party_id,
1487: p_restrict_sql,p_match_type,p_dup_batch_id,p_search_merged,x_dup_set_id, x_search_ctx_id,x_num_matches);
1488: -- Code for Match rule SAMPLE: SEARCH SIMILAR PERSON EXACT
1489: ELSIF p_rule_id=41 THEN

Line 1875: IF NOT HZ_MATCH_RULE_40.check_staged THEN

1871: p_rule_id,p_party_site_id,p_party_id,
1872: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
1873: -- Code for Match rule SAMPLE: SEARCH SIMILAR ORGANIZATION EXACT
1874: ELSIF p_rule_id=40 THEN
1875: IF NOT HZ_MATCH_RULE_40.check_staged THEN
1876: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1877: FND_MSG_PUB.ADD;
1878: RAISE FND_API.G_EXC_ERROR;
1879: END IF;

Line 1880: HZ_MATCH_RULE_40.find_duplicate_party_sites(

1876: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1877: FND_MSG_PUB.ADD;
1878: RAISE FND_API.G_EXC_ERROR;
1879: END IF;
1880: HZ_MATCH_RULE_40.find_duplicate_party_sites(
1881: p_rule_id,p_party_site_id,p_party_id,
1882: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
1883: -- Code for Match rule SAMPLE: SEARCH SIMILAR PERSON EXACT
1884: ELSIF p_rule_id=41 THEN

Line 2269: IF NOT HZ_MATCH_RULE_40.check_staged THEN

2265: p_rule_id,p_org_contact_id,p_party_id,
2266: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2267: -- Code for Match rule SAMPLE: SEARCH SIMILAR ORGANIZATION EXACT
2268: ELSIF p_rule_id=40 THEN
2269: IF NOT HZ_MATCH_RULE_40.check_staged THEN
2270: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2271: FND_MSG_PUB.ADD;
2272: RAISE FND_API.G_EXC_ERROR;
2273: END IF;

Line 2274: HZ_MATCH_RULE_40.find_duplicate_contacts(

2270: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2271: FND_MSG_PUB.ADD;
2272: RAISE FND_API.G_EXC_ERROR;
2273: END IF;
2274: HZ_MATCH_RULE_40.find_duplicate_contacts(
2275: p_rule_id,p_org_contact_id,p_party_id,
2276: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2277: -- Code for Match rule SAMPLE: SEARCH SIMILAR PERSON EXACT
2278: ELSIF p_rule_id=41 THEN

Line 2663: IF NOT HZ_MATCH_RULE_40.check_staged THEN

2659: p_rule_id,p_contact_point_id,p_party_id,
2660: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2661: -- Code for Match rule SAMPLE: SEARCH SIMILAR ORGANIZATION EXACT
2662: ELSIF p_rule_id=40 THEN
2663: IF NOT HZ_MATCH_RULE_40.check_staged THEN
2664: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2665: FND_MSG_PUB.ADD;
2666: RAISE FND_API.G_EXC_ERROR;
2667: END IF;

Line 2668: HZ_MATCH_RULE_40.find_duplicate_contact_points(

2664: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2665: FND_MSG_PUB.ADD;
2666: RAISE FND_API.G_EXC_ERROR;
2667: END IF;
2668: HZ_MATCH_RULE_40.find_duplicate_contact_points(
2669: p_rule_id,p_contact_point_id,p_party_id,
2670: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2671: -- Code for Match rule SAMPLE: SEARCH SIMILAR PERSON EXACT
2672: ELSIF p_rule_id=41 THEN

Line 3217: IF NOT HZ_MATCH_RULE_40.check_staged THEN

3213: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3214: p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
3215: -- Code for Match rule SAMPLE: SEARCH SIMILAR ORGANIZATION EXACT
3216: ELSIF p_rule_id=40 THEN
3217: IF NOT HZ_MATCH_RULE_40.check_staged THEN
3218: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3219: FND_MSG_PUB.ADD;
3220: RAISE FND_API.G_EXC_ERROR;
3221: END IF;

Line 3222: HZ_MATCH_RULE_40.find_parties_dynamic(

3218: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3219: FND_MSG_PUB.ADD;
3220: RAISE FND_API.G_EXC_ERROR;
3221: END IF;
3222: HZ_MATCH_RULE_40.find_parties_dynamic(
3223: p_rule_id,
3224: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
3225: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
3226: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 3900: IF NOT HZ_MATCH_RULE_40.check_staged THEN

3896: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3897: p_restrict_sql,p_api_name,p_match_type,p_party_id,p_search_merged,x_search_ctx_id,x_num_matches);
3898: -- Code for Match rule SAMPLE: SEARCH SIMILAR ORGANIZATION EXACT
3899: ELSIF p_rule_id=40 THEN
3900: IF NOT HZ_MATCH_RULE_40.check_staged THEN
3901: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3902: FND_MSG_PUB.ADD;
3903: RAISE FND_API.G_EXC_ERROR;
3904: END IF;

Line 3905: HZ_MATCH_RULE_40.call_api_dynamic(

3901: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3902: FND_MSG_PUB.ADD;
3903: RAISE FND_API.G_EXC_ERROR;
3904: END IF;
3905: HZ_MATCH_RULE_40.call_api_dynamic(
3906: p_rule_id,
3907: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
3908: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
3909: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 4654: IF NOT HZ_MATCH_RULE_40.check_staged THEN

4650: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4651: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4652: -- Code for Match rule SAMPLE: SEARCH SIMILAR ORGANIZATION EXACT
4653: ELSIF p_rule_id=40 THEN
4654: IF NOT HZ_MATCH_RULE_40.check_staged THEN
4655: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4656: FND_MSG_PUB.ADD;
4657: RAISE FND_API.G_EXC_ERROR;
4658: END IF;

Line 4659: HZ_MATCH_RULE_40.get_matching_party_sites(

4655: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4656: FND_MSG_PUB.ADD;
4657: RAISE FND_API.G_EXC_ERROR;
4658: END IF;
4659: HZ_MATCH_RULE_40.get_matching_party_sites(
4660: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4661: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4662: -- Code for Match rule SAMPLE: SEARCH SIMILAR PERSON EXACT
4663: ELSIF p_rule_id=41 THEN

Line 5073: IF NOT HZ_MATCH_RULE_40.check_staged THEN

5069: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
5070: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5071: -- Code for Match rule SAMPLE: SEARCH SIMILAR ORGANIZATION EXACT
5072: ELSIF p_rule_id=40 THEN
5073: IF NOT HZ_MATCH_RULE_40.check_staged THEN
5074: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5075: FND_MSG_PUB.ADD;
5076: RAISE FND_API.G_EXC_ERROR;
5077: END IF;

Line 5078: HZ_MATCH_RULE_40.get_matching_contacts(

5074: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5075: FND_MSG_PUB.ADD;
5076: RAISE FND_API.G_EXC_ERROR;
5077: END IF;
5078: HZ_MATCH_RULE_40.get_matching_contacts(
5079: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
5080: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5081: -- Code for Match rule SAMPLE: SEARCH SIMILAR PERSON EXACT
5082: ELSIF p_rule_id=41 THEN

Line 5490: IF NOT HZ_MATCH_RULE_40.check_staged THEN

5486: p_rule_id, p_party_id, p_contact_point_list,
5487: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5488: -- Code for Match rule SAMPLE: SEARCH SIMILAR ORGANIZATION EXACT
5489: ELSIF p_rule_id=40 THEN
5490: IF NOT HZ_MATCH_RULE_40.check_staged THEN
5491: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5492: FND_MSG_PUB.ADD;
5493: RAISE FND_API.G_EXC_ERROR;
5494: END IF;

Line 5495: HZ_MATCH_RULE_40.get_matching_contact_points(

5491: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5492: FND_MSG_PUB.ADD;
5493: RAISE FND_API.G_EXC_ERROR;
5494: END IF;
5495: HZ_MATCH_RULE_40.get_matching_contact_points(
5496: p_rule_id, p_party_id, p_contact_point_list,
5497: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5498: -- Code for Match rule SAMPLE: SEARCH SIMILAR PERSON EXACT
5499: ELSIF p_rule_id=41 THEN

Line 5925: IF NOT HZ_MATCH_RULE_40.check_staged THEN

5921: p_party_id, p_party_search_rec,p_party_site_list,
5922: p_contact_list, p_contact_point_list,x_search_ctx_id);
5923: -- Code for Match rule SAMPLE: SEARCH SIMILAR ORGANIZATION EXACT
5924: ELSIF p_rule_id=40 THEN
5925: IF NOT HZ_MATCH_RULE_40.check_staged THEN
5926: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5927: FND_MSG_PUB.ADD;
5928: RAISE FND_API.G_EXC_ERROR;
5929: END IF;

Line 5930: HZ_MATCH_RULE_40.get_score_details(

5926: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5927: FND_MSG_PUB.ADD;
5928: RAISE FND_API.G_EXC_ERROR;
5929: END IF;
5930: HZ_MATCH_RULE_40.get_score_details(
5931: p_rule_id,
5932: p_party_id, p_party_search_rec,p_party_site_list,
5933: p_contact_list, p_contact_point_list,x_search_ctx_id);
5934: -- Code for Match rule SAMPLE: SEARCH SIMILAR PERSON EXACT

Line 6330: IF NOT HZ_MATCH_RULE_40.check_staged THEN

6326: p_party_id, x_party_search_rec,x_party_site_list,
6327: x_contact_list, x_contact_point_list);
6328: -- Code for Match rule SAMPLE: SEARCH SIMILAR ORGANIZATION EXACT
6329: ELSIF p_rule_id=40 THEN
6330: IF NOT HZ_MATCH_RULE_40.check_staged THEN
6331: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6332: FND_MSG_PUB.ADD;
6333: RAISE FND_API.G_EXC_ERROR;
6334: END IF;

Line 6335: HZ_MATCH_RULE_40.get_party_for_search(

6331: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6332: FND_MSG_PUB.ADD;
6333: RAISE FND_API.G_EXC_ERROR;
6334: END IF;
6335: HZ_MATCH_RULE_40.get_party_for_search(
6336: p_party_id, x_party_search_rec,x_party_site_list,
6337: x_contact_list, x_contact_point_list);
6338: -- Code for Match rule SAMPLE: SEARCH SIMILAR PERSON EXACT
6339: ELSIF p_rule_id=41 THEN

Line 6722: IF NOT HZ_MATCH_RULE_40.check_staged THEN

6718: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6719: x_contact_list, x_contact_point_list);
6720: -- Code for Match rule SAMPLE: SEARCH SIMILAR ORGANIZATION EXACT
6721: ELSIF p_rule_id=40 THEN
6722: IF NOT HZ_MATCH_RULE_40.check_staged THEN
6723: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6724: FND_MSG_PUB.ADD;
6725: RAISE FND_API.G_EXC_ERROR;
6726: END IF;

Line 6727: HZ_MATCH_RULE_40.get_search_criteria(

6723: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6724: FND_MSG_PUB.ADD;
6725: RAISE FND_API.G_EXC_ERROR;
6726: END IF;
6727: HZ_MATCH_RULE_40.get_search_criteria(
6728: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6729: x_contact_list, x_contact_point_list);
6730: -- Code for Match rule SAMPLE: SEARCH SIMILAR PERSON EXACT
6731: ELSIF p_rule_id=41 THEN