DBA Data[Home] [Help]

APPS.HZ_PARTY_SEARCH dependencies on HZ_MATCH_RULE_58

Line 340: IF NOT HZ_MATCH_RULE_58.check_staged THEN

336: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
337: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,NULL,NULL,NULL,'N',x_search_ctx_id,x_num_matches);
338: -- Code for Match rule HZ_PERSON_SIMPLE_SEARCH_RULE
339: ELSIF p_rule_id=58 THEN
340: IF NOT HZ_MATCH_RULE_58.check_staged THEN
341: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
342: FND_MSG_PUB.ADD;
343: RAISE FND_API.G_EXC_ERROR;
344: END IF;

Line 345: HZ_MATCH_RULE_58.find_parties(

341: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
342: FND_MSG_PUB.ADD;
343: RAISE FND_API.G_EXC_ERROR;
344: END IF;
345: HZ_MATCH_RULE_58.find_parties(
346: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
347: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,NULL,NULL,NULL,'N',x_search_ctx_id,x_num_matches);
348: -- Code for Match rule HZ_PERSON_ADVANCED_SEARCH_MATCH_RULE
349: ELSIF p_rule_id=60 THEN

Line 741: IF NOT HZ_MATCH_RULE_58.check_staged THEN

737: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
738: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,'N',x_search_ctx_id,x_num_matches);
739: -- Code for Match rule HZ_PERSON_SIMPLE_SEARCH_RULE
740: ELSIF p_rule_id=58 THEN
741: IF NOT HZ_MATCH_RULE_58.check_staged THEN
742: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
743: FND_MSG_PUB.ADD;
744: RAISE FND_API.G_EXC_ERROR;
745: END IF;

Line 746: HZ_MATCH_RULE_58.find_persons(

742: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
743: FND_MSG_PUB.ADD;
744: RAISE FND_API.G_EXC_ERROR;
745: END IF;
746: HZ_MATCH_RULE_58.find_persons(
747: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
748: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,'N',x_search_ctx_id,x_num_matches);
749: -- Code for Match rule HZ_PERSON_ADVANCED_SEARCH_MATCH_RULE
750: ELSIF p_rule_id=60 THEN

Line 1160: IF NOT HZ_MATCH_RULE_58.check_staged THEN

1156: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
1157: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
1158: -- Code for Match rule HZ_PERSON_SIMPLE_SEARCH_RULE
1159: ELSIF p_rule_id=58 THEN
1160: IF NOT HZ_MATCH_RULE_58.check_staged THEN
1161: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1162: FND_MSG_PUB.ADD;
1163: RAISE FND_API.G_EXC_ERROR;
1164: END IF;

Line 1165: HZ_MATCH_RULE_58.find_party_details(

1161: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1162: FND_MSG_PUB.ADD;
1163: RAISE FND_API.G_EXC_ERROR;
1164: END IF;
1165: HZ_MATCH_RULE_58.find_party_details(
1166: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
1167: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
1168: -- Code for Match rule HZ_PERSON_ADVANCED_SEARCH_MATCH_RULE
1169: ELSIF p_rule_id=60 THEN

Line 1560: IF NOT HZ_MATCH_RULE_58.check_staged THEN

1556: p_rule_id,p_party_id,
1557: p_restrict_sql,p_match_type,p_dup_batch_id,p_search_merged,x_dup_set_id, x_search_ctx_id,x_num_matches);
1558: -- Code for Match rule HZ_PERSON_SIMPLE_SEARCH_RULE
1559: ELSIF p_rule_id=58 THEN
1560: IF NOT HZ_MATCH_RULE_58.check_staged THEN
1561: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1562: FND_MSG_PUB.ADD;
1563: RAISE FND_API.G_EXC_ERROR;
1564: END IF;

Line 1565: HZ_MATCH_RULE_58.find_duplicate_parties(

1561: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1562: FND_MSG_PUB.ADD;
1563: RAISE FND_API.G_EXC_ERROR;
1564: END IF;
1565: HZ_MATCH_RULE_58.find_duplicate_parties(
1566: p_rule_id,p_party_id,
1567: p_restrict_sql,p_match_type,p_dup_batch_id,p_search_merged,x_dup_set_id, x_search_ctx_id,x_num_matches);
1568: -- Code for Match rule HZ_PERSON_ADVANCED_SEARCH_MATCH_RULE
1569: ELSIF p_rule_id=60 THEN

Line 1955: IF NOT HZ_MATCH_RULE_58.check_staged THEN

1951: p_rule_id,p_party_site_id,p_party_id,
1952: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
1953: -- Code for Match rule HZ_PERSON_SIMPLE_SEARCH_RULE
1954: ELSIF p_rule_id=58 THEN
1955: IF NOT HZ_MATCH_RULE_58.check_staged THEN
1956: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1957: FND_MSG_PUB.ADD;
1958: RAISE FND_API.G_EXC_ERROR;
1959: END IF;

Line 1960: HZ_MATCH_RULE_58.find_duplicate_party_sites(

1956: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1957: FND_MSG_PUB.ADD;
1958: RAISE FND_API.G_EXC_ERROR;
1959: END IF;
1960: HZ_MATCH_RULE_58.find_duplicate_party_sites(
1961: p_rule_id,p_party_site_id,p_party_id,
1962: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
1963: -- Code for Match rule HZ_PERSON_ADVANCED_SEARCH_MATCH_RULE
1964: ELSIF p_rule_id=60 THEN

Line 2349: IF NOT HZ_MATCH_RULE_58.check_staged THEN

2345: p_rule_id,p_org_contact_id,p_party_id,
2346: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2347: -- Code for Match rule HZ_PERSON_SIMPLE_SEARCH_RULE
2348: ELSIF p_rule_id=58 THEN
2349: IF NOT HZ_MATCH_RULE_58.check_staged THEN
2350: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2351: FND_MSG_PUB.ADD;
2352: RAISE FND_API.G_EXC_ERROR;
2353: END IF;

Line 2354: HZ_MATCH_RULE_58.find_duplicate_contacts(

2350: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2351: FND_MSG_PUB.ADD;
2352: RAISE FND_API.G_EXC_ERROR;
2353: END IF;
2354: HZ_MATCH_RULE_58.find_duplicate_contacts(
2355: p_rule_id,p_org_contact_id,p_party_id,
2356: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2357: -- Code for Match rule HZ_PERSON_ADVANCED_SEARCH_MATCH_RULE
2358: ELSIF p_rule_id=60 THEN

Line 2743: IF NOT HZ_MATCH_RULE_58.check_staged THEN

2739: p_rule_id,p_contact_point_id,p_party_id,
2740: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2741: -- Code for Match rule HZ_PERSON_SIMPLE_SEARCH_RULE
2742: ELSIF p_rule_id=58 THEN
2743: IF NOT HZ_MATCH_RULE_58.check_staged THEN
2744: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2745: FND_MSG_PUB.ADD;
2746: RAISE FND_API.G_EXC_ERROR;
2747: END IF;

Line 2748: HZ_MATCH_RULE_58.find_duplicate_contact_points(

2744: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2745: FND_MSG_PUB.ADD;
2746: RAISE FND_API.G_EXC_ERROR;
2747: END IF;
2748: HZ_MATCH_RULE_58.find_duplicate_contact_points(
2749: p_rule_id,p_contact_point_id,p_party_id,
2750: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2751: -- Code for Match rule HZ_PERSON_ADVANCED_SEARCH_MATCH_RULE
2752: ELSIF p_rule_id=60 THEN

Line 3361: IF NOT HZ_MATCH_RULE_58.check_staged THEN

3357: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3358: p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
3359: -- Code for Match rule HZ_PERSON_SIMPLE_SEARCH_RULE
3360: ELSIF p_rule_id=58 THEN
3361: IF NOT HZ_MATCH_RULE_58.check_staged THEN
3362: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3363: FND_MSG_PUB.ADD;
3364: RAISE FND_API.G_EXC_ERROR;
3365: END IF;

Line 3366: HZ_MATCH_RULE_58.find_parties_dynamic(

3362: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3363: FND_MSG_PUB.ADD;
3364: RAISE FND_API.G_EXC_ERROR;
3365: END IF;
3366: HZ_MATCH_RULE_58.find_parties_dynamic(
3367: p_rule_id,
3368: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
3369: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
3370: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 4044: IF NOT HZ_MATCH_RULE_58.check_staged THEN

4040: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
4041: p_restrict_sql,p_api_name,p_match_type,p_party_id,p_search_merged,x_search_ctx_id,x_num_matches);
4042: -- Code for Match rule HZ_PERSON_SIMPLE_SEARCH_RULE
4043: ELSIF p_rule_id=58 THEN
4044: IF NOT HZ_MATCH_RULE_58.check_staged THEN
4045: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4046: FND_MSG_PUB.ADD;
4047: RAISE FND_API.G_EXC_ERROR;
4048: END IF;

Line 4049: HZ_MATCH_RULE_58.call_api_dynamic(

4045: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4046: FND_MSG_PUB.ADD;
4047: RAISE FND_API.G_EXC_ERROR;
4048: END IF;
4049: HZ_MATCH_RULE_58.call_api_dynamic(
4050: p_rule_id,
4051: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
4052: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
4053: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 4734: IF NOT HZ_MATCH_RULE_58.check_staged THEN

4730: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4731: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4732: -- Code for Match rule HZ_PERSON_SIMPLE_SEARCH_RULE
4733: ELSIF p_rule_id=58 THEN
4734: IF NOT HZ_MATCH_RULE_58.check_staged THEN
4735: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4736: FND_MSG_PUB.ADD;
4737: RAISE FND_API.G_EXC_ERROR;
4738: END IF;

Line 4739: HZ_MATCH_RULE_58.get_matching_party_sites(

4735: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4736: FND_MSG_PUB.ADD;
4737: RAISE FND_API.G_EXC_ERROR;
4738: END IF;
4739: HZ_MATCH_RULE_58.get_matching_party_sites(
4740: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4741: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4742: -- Code for Match rule HZ_PERSON_ADVANCED_SEARCH_MATCH_RULE
4743: ELSIF p_rule_id=60 THEN

Line 5153: IF NOT HZ_MATCH_RULE_58.check_staged THEN

5149: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
5150: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5151: -- Code for Match rule HZ_PERSON_SIMPLE_SEARCH_RULE
5152: ELSIF p_rule_id=58 THEN
5153: IF NOT HZ_MATCH_RULE_58.check_staged THEN
5154: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5155: FND_MSG_PUB.ADD;
5156: RAISE FND_API.G_EXC_ERROR;
5157: END IF;

Line 5158: HZ_MATCH_RULE_58.get_matching_contacts(

5154: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5155: FND_MSG_PUB.ADD;
5156: RAISE FND_API.G_EXC_ERROR;
5157: END IF;
5158: HZ_MATCH_RULE_58.get_matching_contacts(
5159: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
5160: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5161: -- Code for Match rule HZ_PERSON_ADVANCED_SEARCH_MATCH_RULE
5162: ELSIF p_rule_id=60 THEN

Line 5570: IF NOT HZ_MATCH_RULE_58.check_staged THEN

5566: p_rule_id, p_party_id, p_contact_point_list,
5567: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5568: -- Code for Match rule HZ_PERSON_SIMPLE_SEARCH_RULE
5569: ELSIF p_rule_id=58 THEN
5570: IF NOT HZ_MATCH_RULE_58.check_staged THEN
5571: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5572: FND_MSG_PUB.ADD;
5573: RAISE FND_API.G_EXC_ERROR;
5574: END IF;

Line 5575: HZ_MATCH_RULE_58.get_matching_contact_points(

5571: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5572: FND_MSG_PUB.ADD;
5573: RAISE FND_API.G_EXC_ERROR;
5574: END IF;
5575: HZ_MATCH_RULE_58.get_matching_contact_points(
5576: p_rule_id, p_party_id, p_contact_point_list,
5577: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5578: -- Code for Match rule HZ_PERSON_ADVANCED_SEARCH_MATCH_RULE
5579: ELSIF p_rule_id=60 THEN

Line 6013: IF NOT HZ_MATCH_RULE_58.check_staged THEN

6009: p_party_id, p_party_search_rec,p_party_site_list,
6010: p_contact_list, p_contact_point_list,x_search_ctx_id);
6011: -- Code for Match rule HZ_PERSON_SIMPLE_SEARCH_RULE
6012: ELSIF p_rule_id=58 THEN
6013: IF NOT HZ_MATCH_RULE_58.check_staged THEN
6014: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6015: FND_MSG_PUB.ADD;
6016: RAISE FND_API.G_EXC_ERROR;
6017: END IF;

Line 6018: HZ_MATCH_RULE_58.get_score_details(

6014: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6015: FND_MSG_PUB.ADD;
6016: RAISE FND_API.G_EXC_ERROR;
6017: END IF;
6018: HZ_MATCH_RULE_58.get_score_details(
6019: p_rule_id,
6020: p_party_id, p_party_search_rec,p_party_site_list,
6021: p_contact_list, p_contact_point_list,x_search_ctx_id);
6022: -- Code for Match rule HZ_PERSON_ADVANCED_SEARCH_MATCH_RULE

Line 6410: IF NOT HZ_MATCH_RULE_58.check_staged THEN

6406: p_party_id, x_party_search_rec,x_party_site_list,
6407: x_contact_list, x_contact_point_list);
6408: -- Code for Match rule HZ_PERSON_SIMPLE_SEARCH_RULE
6409: ELSIF p_rule_id=58 THEN
6410: IF NOT HZ_MATCH_RULE_58.check_staged THEN
6411: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6412: FND_MSG_PUB.ADD;
6413: RAISE FND_API.G_EXC_ERROR;
6414: END IF;

Line 6415: HZ_MATCH_RULE_58.get_party_for_search(

6411: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6412: FND_MSG_PUB.ADD;
6413: RAISE FND_API.G_EXC_ERROR;
6414: END IF;
6415: HZ_MATCH_RULE_58.get_party_for_search(
6416: p_party_id, x_party_search_rec,x_party_site_list,
6417: x_contact_list, x_contact_point_list);
6418: -- Code for Match rule HZ_PERSON_ADVANCED_SEARCH_MATCH_RULE
6419: ELSIF p_rule_id=60 THEN

Line 6802: IF NOT HZ_MATCH_RULE_58.check_staged THEN

6798: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6799: x_contact_list, x_contact_point_list);
6800: -- Code for Match rule HZ_PERSON_SIMPLE_SEARCH_RULE
6801: ELSIF p_rule_id=58 THEN
6802: IF NOT HZ_MATCH_RULE_58.check_staged THEN
6803: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6804: FND_MSG_PUB.ADD;
6805: RAISE FND_API.G_EXC_ERROR;
6806: END IF;

Line 6807: HZ_MATCH_RULE_58.get_search_criteria(

6803: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6804: FND_MSG_PUB.ADD;
6805: RAISE FND_API.G_EXC_ERROR;
6806: END IF;
6807: HZ_MATCH_RULE_58.get_search_criteria(
6808: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6809: x_contact_list, x_contact_point_list);
6810: -- Code for Match rule HZ_PERSON_ADVANCED_SEARCH_MATCH_RULE
6811: ELSIF p_rule_id=60 THEN