DBA Data[Home] [Help]

APPS.HZ_PARTY_SEARCH dependencies on HZ_MATCH_RULE_41

Line 270: IF NOT HZ_MATCH_RULE_41.check_staged THEN

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
270: IF NOT HZ_MATCH_RULE_41.check_staged THEN
271: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
272: FND_MSG_PUB.ADD;
273: RAISE FND_API.G_EXC_ERROR;
274: END IF;

Line 275: HZ_MATCH_RULE_41.find_parties(

271: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
272: FND_MSG_PUB.ADD;
273: RAISE FND_API.G_EXC_ERROR;
274: END IF;
275: HZ_MATCH_RULE_41.find_parties(
276: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
277: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,NULL,NULL,NULL,'N',x_search_ctx_id,x_num_matches);
278: -- Code for Match rule SAMPLE: SEARCH EXACT
279: ELSIF p_rule_id=42 THEN

Line 671: IF NOT HZ_MATCH_RULE_41.check_staged THEN

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
671: IF NOT HZ_MATCH_RULE_41.check_staged THEN
672: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
673: FND_MSG_PUB.ADD;
674: RAISE FND_API.G_EXC_ERROR;
675: END IF;

Line 676: HZ_MATCH_RULE_41.find_persons(

672: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
673: FND_MSG_PUB.ADD;
674: RAISE FND_API.G_EXC_ERROR;
675: END IF;
676: HZ_MATCH_RULE_41.find_persons(
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 SAMPLE: SEARCH EXACT
680: ELSIF p_rule_id=42 THEN

Line 1090: IF NOT HZ_MATCH_RULE_41.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 SAMPLE: SEARCH SIMILAR PERSON EXACT
1089: ELSIF p_rule_id=41 THEN
1090: IF NOT HZ_MATCH_RULE_41.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_41.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_41.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 SAMPLE: SEARCH EXACT
1099: ELSIF p_rule_id=42 THEN

Line 1490: IF NOT HZ_MATCH_RULE_41.check_staged THEN

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
1490: IF NOT HZ_MATCH_RULE_41.check_staged THEN
1491: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1492: FND_MSG_PUB.ADD;
1493: RAISE FND_API.G_EXC_ERROR;
1494: END IF;

Line 1495: HZ_MATCH_RULE_41.find_duplicate_parties(

1491: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1492: FND_MSG_PUB.ADD;
1493: RAISE FND_API.G_EXC_ERROR;
1494: END IF;
1495: HZ_MATCH_RULE_41.find_duplicate_parties(
1496: p_rule_id,p_party_id,
1497: p_restrict_sql,p_match_type,p_dup_batch_id,p_search_merged,x_dup_set_id, x_search_ctx_id,x_num_matches);
1498: -- Code for Match rule SAMPLE: SEARCH EXACT
1499: ELSIF p_rule_id=42 THEN

Line 1885: IF NOT HZ_MATCH_RULE_41.check_staged THEN

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
1885: IF NOT HZ_MATCH_RULE_41.check_staged THEN
1886: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1887: FND_MSG_PUB.ADD;
1888: RAISE FND_API.G_EXC_ERROR;
1889: END IF;

Line 1890: HZ_MATCH_RULE_41.find_duplicate_party_sites(

1886: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1887: FND_MSG_PUB.ADD;
1888: RAISE FND_API.G_EXC_ERROR;
1889: END IF;
1890: HZ_MATCH_RULE_41.find_duplicate_party_sites(
1891: p_rule_id,p_party_site_id,p_party_id,
1892: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
1893: -- Code for Match rule SAMPLE: SEARCH EXACT
1894: ELSIF p_rule_id=42 THEN

Line 2279: IF NOT HZ_MATCH_RULE_41.check_staged THEN

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
2279: IF NOT HZ_MATCH_RULE_41.check_staged THEN
2280: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2281: FND_MSG_PUB.ADD;
2282: RAISE FND_API.G_EXC_ERROR;
2283: END IF;

Line 2284: HZ_MATCH_RULE_41.find_duplicate_contacts(

2280: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2281: FND_MSG_PUB.ADD;
2282: RAISE FND_API.G_EXC_ERROR;
2283: END IF;
2284: HZ_MATCH_RULE_41.find_duplicate_contacts(
2285: p_rule_id,p_org_contact_id,p_party_id,
2286: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2287: -- Code for Match rule SAMPLE: SEARCH EXACT
2288: ELSIF p_rule_id=42 THEN

Line 2673: IF NOT HZ_MATCH_RULE_41.check_staged THEN

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
2673: IF NOT HZ_MATCH_RULE_41.check_staged THEN
2674: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2675: FND_MSG_PUB.ADD;
2676: RAISE FND_API.G_EXC_ERROR;
2677: END IF;

Line 2678: HZ_MATCH_RULE_41.find_duplicate_contact_points(

2674: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2675: FND_MSG_PUB.ADD;
2676: RAISE FND_API.G_EXC_ERROR;
2677: END IF;
2678: HZ_MATCH_RULE_41.find_duplicate_contact_points(
2679: p_rule_id,p_contact_point_id,p_party_id,
2680: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2681: -- Code for Match rule SAMPLE: SEARCH EXACT
2682: ELSIF p_rule_id=42 THEN

Line 3235: IF NOT HZ_MATCH_RULE_41.check_staged THEN

3231: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3232: p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
3233: -- Code for Match rule SAMPLE: SEARCH SIMILAR PERSON EXACT
3234: ELSIF p_rule_id=41 THEN
3235: IF NOT HZ_MATCH_RULE_41.check_staged THEN
3236: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3237: FND_MSG_PUB.ADD;
3238: RAISE FND_API.G_EXC_ERROR;
3239: END IF;

Line 3240: HZ_MATCH_RULE_41.find_parties_dynamic(

3236: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3237: FND_MSG_PUB.ADD;
3238: RAISE FND_API.G_EXC_ERROR;
3239: END IF;
3240: HZ_MATCH_RULE_41.find_parties_dynamic(
3241: p_rule_id,
3242: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
3243: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
3244: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 3918: IF NOT HZ_MATCH_RULE_41.check_staged THEN

3914: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3915: p_restrict_sql,p_api_name,p_match_type,p_party_id,p_search_merged,x_search_ctx_id,x_num_matches);
3916: -- Code for Match rule SAMPLE: SEARCH SIMILAR PERSON EXACT
3917: ELSIF p_rule_id=41 THEN
3918: IF NOT HZ_MATCH_RULE_41.check_staged THEN
3919: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3920: FND_MSG_PUB.ADD;
3921: RAISE FND_API.G_EXC_ERROR;
3922: END IF;

Line 3923: HZ_MATCH_RULE_41.call_api_dynamic(

3919: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3920: FND_MSG_PUB.ADD;
3921: RAISE FND_API.G_EXC_ERROR;
3922: END IF;
3923: HZ_MATCH_RULE_41.call_api_dynamic(
3924: p_rule_id,
3925: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
3926: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
3927: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 4664: IF NOT HZ_MATCH_RULE_41.check_staged THEN

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
4664: IF NOT HZ_MATCH_RULE_41.check_staged THEN
4665: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4666: FND_MSG_PUB.ADD;
4667: RAISE FND_API.G_EXC_ERROR;
4668: END IF;

Line 4669: HZ_MATCH_RULE_41.get_matching_party_sites(

4665: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4666: FND_MSG_PUB.ADD;
4667: RAISE FND_API.G_EXC_ERROR;
4668: END IF;
4669: HZ_MATCH_RULE_41.get_matching_party_sites(
4670: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4671: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4672: -- Code for Match rule SAMPLE: SEARCH EXACT
4673: ELSIF p_rule_id=42 THEN

Line 5083: IF NOT HZ_MATCH_RULE_41.check_staged THEN

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
5083: IF NOT HZ_MATCH_RULE_41.check_staged THEN
5084: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5085: FND_MSG_PUB.ADD;
5086: RAISE FND_API.G_EXC_ERROR;
5087: END IF;

Line 5088: HZ_MATCH_RULE_41.get_matching_contacts(

5084: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5085: FND_MSG_PUB.ADD;
5086: RAISE FND_API.G_EXC_ERROR;
5087: END IF;
5088: HZ_MATCH_RULE_41.get_matching_contacts(
5089: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
5090: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5091: -- Code for Match rule SAMPLE: SEARCH EXACT
5092: ELSIF p_rule_id=42 THEN

Line 5500: IF NOT HZ_MATCH_RULE_41.check_staged THEN

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
5500: IF NOT HZ_MATCH_RULE_41.check_staged THEN
5501: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5502: FND_MSG_PUB.ADD;
5503: RAISE FND_API.G_EXC_ERROR;
5504: END IF;

Line 5505: HZ_MATCH_RULE_41.get_matching_contact_points(

5501: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5502: FND_MSG_PUB.ADD;
5503: RAISE FND_API.G_EXC_ERROR;
5504: END IF;
5505: HZ_MATCH_RULE_41.get_matching_contact_points(
5506: p_rule_id, p_party_id, p_contact_point_list,
5507: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5508: -- Code for Match rule SAMPLE: SEARCH EXACT
5509: ELSIF p_rule_id=42 THEN

Line 5936: IF NOT HZ_MATCH_RULE_41.check_staged THEN

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
5935: ELSIF p_rule_id=41 THEN
5936: IF NOT HZ_MATCH_RULE_41.check_staged THEN
5937: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5938: FND_MSG_PUB.ADD;
5939: RAISE FND_API.G_EXC_ERROR;
5940: END IF;

Line 5941: HZ_MATCH_RULE_41.get_score_details(

5937: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5938: FND_MSG_PUB.ADD;
5939: RAISE FND_API.G_EXC_ERROR;
5940: END IF;
5941: HZ_MATCH_RULE_41.get_score_details(
5942: p_rule_id,
5943: p_party_id, p_party_search_rec,p_party_site_list,
5944: p_contact_list, p_contact_point_list,x_search_ctx_id);
5945: -- Code for Match rule SAMPLE: SEARCH EXACT

Line 6340: IF NOT HZ_MATCH_RULE_41.check_staged THEN

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
6340: IF NOT HZ_MATCH_RULE_41.check_staged THEN
6341: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6342: FND_MSG_PUB.ADD;
6343: RAISE FND_API.G_EXC_ERROR;
6344: END IF;

Line 6345: HZ_MATCH_RULE_41.get_party_for_search(

6341: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6342: FND_MSG_PUB.ADD;
6343: RAISE FND_API.G_EXC_ERROR;
6344: END IF;
6345: HZ_MATCH_RULE_41.get_party_for_search(
6346: p_party_id, x_party_search_rec,x_party_site_list,
6347: x_contact_list, x_contact_point_list);
6348: -- Code for Match rule SAMPLE: SEARCH EXACT
6349: ELSIF p_rule_id=42 THEN

Line 6732: IF NOT HZ_MATCH_RULE_41.check_staged THEN

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
6732: IF NOT HZ_MATCH_RULE_41.check_staged THEN
6733: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6734: FND_MSG_PUB.ADD;
6735: RAISE FND_API.G_EXC_ERROR;
6736: END IF;

Line 6737: HZ_MATCH_RULE_41.get_search_criteria(

6733: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6734: FND_MSG_PUB.ADD;
6735: RAISE FND_API.G_EXC_ERROR;
6736: END IF;
6737: HZ_MATCH_RULE_41.get_search_criteria(
6738: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6739: x_contact_list, x_contact_point_list);
6740: -- Code for Match rule SAMPLE: SEARCH EXACT
6741: ELSIF p_rule_id=42 THEN