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 641: IF NOT HZ_MATCH_RULE_40.check_staged THEN

637: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
638: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,'N',x_search_ctx_id,x_num_matches);
639: -- Code for Match rule SAMPLE: SEARCH SIMILAR ORGANIZATION EXACT
640: ELSIF p_rule_id=40 THEN
641: IF NOT HZ_MATCH_RULE_40.check_staged THEN
642: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
643: FND_MSG_PUB.ADD;
644: RAISE FND_API.G_EXC_ERROR;
645: END IF;

Line 646: HZ_MATCH_RULE_40.find_persons(

642: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
643: FND_MSG_PUB.ADD;
644: RAISE FND_API.G_EXC_ERROR;
645: END IF;
646: HZ_MATCH_RULE_40.find_persons(
647: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
648: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,'N',x_search_ctx_id,x_num_matches);
649: -- Code for Match rule SAMPLE: SEARCH SIMILAR PERSON EXACT
650: ELSIF p_rule_id=41 THEN

Line 1040: IF NOT HZ_MATCH_RULE_40.check_staged THEN

1036: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
1037: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
1038: -- Code for Match rule SAMPLE: SEARCH SIMILAR ORGANIZATION EXACT
1039: ELSIF p_rule_id=40 THEN
1040: IF NOT HZ_MATCH_RULE_40.check_staged THEN
1041: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1042: FND_MSG_PUB.ADD;
1043: RAISE FND_API.G_EXC_ERROR;
1044: END IF;

Line 1045: HZ_MATCH_RULE_40.find_party_details(

1041: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1042: FND_MSG_PUB.ADD;
1043: RAISE FND_API.G_EXC_ERROR;
1044: END IF;
1045: HZ_MATCH_RULE_40.find_party_details(
1046: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
1047: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
1048: -- Code for Match rule SAMPLE: SEARCH SIMILAR PERSON EXACT
1049: ELSIF p_rule_id=41 THEN

Line 1420: IF NOT HZ_MATCH_RULE_40.check_staged THEN

1416: p_rule_id,p_party_id,
1417: p_restrict_sql,p_match_type,p_dup_batch_id,p_search_merged,x_dup_set_id, x_search_ctx_id,x_num_matches);
1418: -- Code for Match rule SAMPLE: SEARCH SIMILAR ORGANIZATION EXACT
1419: ELSIF p_rule_id=40 THEN
1420: IF NOT HZ_MATCH_RULE_40.check_staged THEN
1421: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1422: FND_MSG_PUB.ADD;
1423: RAISE FND_API.G_EXC_ERROR;
1424: END IF;

Line 1425: HZ_MATCH_RULE_40.find_duplicate_parties(

1421: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1422: FND_MSG_PUB.ADD;
1423: RAISE FND_API.G_EXC_ERROR;
1424: END IF;
1425: HZ_MATCH_RULE_40.find_duplicate_parties(
1426: p_rule_id,p_party_id,
1427: p_restrict_sql,p_match_type,p_dup_batch_id,p_search_merged,x_dup_set_id, x_search_ctx_id,x_num_matches);
1428: -- Code for Match rule SAMPLE: SEARCH SIMILAR PERSON EXACT
1429: ELSIF p_rule_id=41 THEN

Line 1795: IF NOT HZ_MATCH_RULE_40.check_staged THEN

1791: p_rule_id,p_party_site_id,p_party_id,
1792: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
1793: -- Code for Match rule SAMPLE: SEARCH SIMILAR ORGANIZATION EXACT
1794: ELSIF p_rule_id=40 THEN
1795: IF NOT HZ_MATCH_RULE_40.check_staged THEN
1796: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1797: FND_MSG_PUB.ADD;
1798: RAISE FND_API.G_EXC_ERROR;
1799: END IF;

Line 1800: HZ_MATCH_RULE_40.find_duplicate_party_sites(

1796: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1797: FND_MSG_PUB.ADD;
1798: RAISE FND_API.G_EXC_ERROR;
1799: END IF;
1800: HZ_MATCH_RULE_40.find_duplicate_party_sites(
1801: p_rule_id,p_party_site_id,p_party_id,
1802: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
1803: -- Code for Match rule SAMPLE: SEARCH SIMILAR PERSON EXACT
1804: ELSIF p_rule_id=41 THEN

Line 2169: IF NOT HZ_MATCH_RULE_40.check_staged THEN

2165: p_rule_id,p_org_contact_id,p_party_id,
2166: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2167: -- Code for Match rule SAMPLE: SEARCH SIMILAR ORGANIZATION EXACT
2168: ELSIF p_rule_id=40 THEN
2169: IF NOT HZ_MATCH_RULE_40.check_staged THEN
2170: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2171: FND_MSG_PUB.ADD;
2172: RAISE FND_API.G_EXC_ERROR;
2173: END IF;

Line 2174: HZ_MATCH_RULE_40.find_duplicate_contacts(

2170: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2171: FND_MSG_PUB.ADD;
2172: RAISE FND_API.G_EXC_ERROR;
2173: END IF;
2174: HZ_MATCH_RULE_40.find_duplicate_contacts(
2175: p_rule_id,p_org_contact_id,p_party_id,
2176: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2177: -- Code for Match rule SAMPLE: SEARCH SIMILAR PERSON EXACT
2178: ELSIF p_rule_id=41 THEN

Line 2543: IF NOT HZ_MATCH_RULE_40.check_staged THEN

2539: p_rule_id,p_contact_point_id,p_party_id,
2540: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2541: -- Code for Match rule SAMPLE: SEARCH SIMILAR ORGANIZATION EXACT
2542: ELSIF p_rule_id=40 THEN
2543: IF NOT HZ_MATCH_RULE_40.check_staged THEN
2544: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2545: FND_MSG_PUB.ADD;
2546: RAISE FND_API.G_EXC_ERROR;
2547: END IF;

Line 2548: HZ_MATCH_RULE_40.find_duplicate_contact_points(

2544: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2545: FND_MSG_PUB.ADD;
2546: RAISE FND_API.G_EXC_ERROR;
2547: END IF;
2548: HZ_MATCH_RULE_40.find_duplicate_contact_points(
2549: p_rule_id,p_contact_point_id,p_party_id,
2550: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2551: -- Code for Match rule SAMPLE: SEARCH SIMILAR PERSON EXACT
2552: ELSIF p_rule_id=41 THEN

Line 3077: IF NOT HZ_MATCH_RULE_40.check_staged THEN

3073: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3074: p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
3075: -- Code for Match rule SAMPLE: SEARCH SIMILAR ORGANIZATION EXACT
3076: ELSIF p_rule_id=40 THEN
3077: IF NOT HZ_MATCH_RULE_40.check_staged THEN
3078: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3079: FND_MSG_PUB.ADD;
3080: RAISE FND_API.G_EXC_ERROR;
3081: END IF;

Line 3082: HZ_MATCH_RULE_40.find_parties_dynamic(

3078: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3079: FND_MSG_PUB.ADD;
3080: RAISE FND_API.G_EXC_ERROR;
3081: END IF;
3082: HZ_MATCH_RULE_40.find_parties_dynamic(
3083: p_rule_id,
3084: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
3085: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
3086: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 3724: IF NOT HZ_MATCH_RULE_40.check_staged THEN

3720: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3721: p_restrict_sql,p_api_name,p_match_type,p_party_id,p_search_merged,x_search_ctx_id,x_num_matches);
3722: -- Code for Match rule SAMPLE: SEARCH SIMILAR ORGANIZATION EXACT
3723: ELSIF p_rule_id=40 THEN
3724: IF NOT HZ_MATCH_RULE_40.check_staged THEN
3725: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3726: FND_MSG_PUB.ADD;
3727: RAISE FND_API.G_EXC_ERROR;
3728: END IF;

Line 3729: HZ_MATCH_RULE_40.call_api_dynamic(

3725: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3726: FND_MSG_PUB.ADD;
3727: RAISE FND_API.G_EXC_ERROR;
3728: END IF;
3729: HZ_MATCH_RULE_40.call_api_dynamic(
3730: p_rule_id,
3731: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
3732: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
3733: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 4442: IF NOT HZ_MATCH_RULE_40.check_staged THEN

4438: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4439: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4440: -- Code for Match rule SAMPLE: SEARCH SIMILAR ORGANIZATION EXACT
4441: ELSIF p_rule_id=40 THEN
4442: IF NOT HZ_MATCH_RULE_40.check_staged THEN
4443: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4444: FND_MSG_PUB.ADD;
4445: RAISE FND_API.G_EXC_ERROR;
4446: END IF;

Line 4447: HZ_MATCH_RULE_40.get_matching_party_sites(

4443: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4444: FND_MSG_PUB.ADD;
4445: RAISE FND_API.G_EXC_ERROR;
4446: END IF;
4447: HZ_MATCH_RULE_40.get_matching_party_sites(
4448: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4449: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4450: -- Code for Match rule SAMPLE: SEARCH SIMILAR PERSON EXACT
4451: ELSIF p_rule_id=41 THEN

Line 4841: IF NOT HZ_MATCH_RULE_40.check_staged THEN

4837: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
4838: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4839: -- Code for Match rule SAMPLE: SEARCH SIMILAR ORGANIZATION EXACT
4840: ELSIF p_rule_id=40 THEN
4841: IF NOT HZ_MATCH_RULE_40.check_staged THEN
4842: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4843: FND_MSG_PUB.ADD;
4844: RAISE FND_API.G_EXC_ERROR;
4845: END IF;

Line 4846: HZ_MATCH_RULE_40.get_matching_contacts(

4842: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4843: FND_MSG_PUB.ADD;
4844: RAISE FND_API.G_EXC_ERROR;
4845: END IF;
4846: HZ_MATCH_RULE_40.get_matching_contacts(
4847: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
4848: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4849: -- Code for Match rule SAMPLE: SEARCH SIMILAR PERSON EXACT
4850: ELSIF p_rule_id=41 THEN

Line 5238: IF NOT HZ_MATCH_RULE_40.check_staged THEN

5234: p_rule_id, p_party_id, p_contact_point_list,
5235: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5236: -- Code for Match rule SAMPLE: SEARCH SIMILAR ORGANIZATION EXACT
5237: ELSIF p_rule_id=40 THEN
5238: IF NOT HZ_MATCH_RULE_40.check_staged THEN
5239: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5240: FND_MSG_PUB.ADD;
5241: RAISE FND_API.G_EXC_ERROR;
5242: END IF;

Line 5243: HZ_MATCH_RULE_40.get_matching_contact_points(

5239: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5240: FND_MSG_PUB.ADD;
5241: RAISE FND_API.G_EXC_ERROR;
5242: END IF;
5243: HZ_MATCH_RULE_40.get_matching_contact_points(
5244: p_rule_id, p_party_id, p_contact_point_list,
5245: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5246: -- Code for Match rule SAMPLE: SEARCH SIMILAR PERSON EXACT
5247: ELSIF p_rule_id=41 THEN

Line 5653: IF NOT HZ_MATCH_RULE_40.check_staged THEN

5649: p_party_id, p_party_search_rec,p_party_site_list,
5650: p_contact_list, p_contact_point_list,x_search_ctx_id);
5651: -- Code for Match rule SAMPLE: SEARCH SIMILAR ORGANIZATION EXACT
5652: ELSIF p_rule_id=40 THEN
5653: IF NOT HZ_MATCH_RULE_40.check_staged THEN
5654: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5655: FND_MSG_PUB.ADD;
5656: RAISE FND_API.G_EXC_ERROR;
5657: END IF;

Line 5658: HZ_MATCH_RULE_40.get_score_details(

5654: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5655: FND_MSG_PUB.ADD;
5656: RAISE FND_API.G_EXC_ERROR;
5657: END IF;
5658: HZ_MATCH_RULE_40.get_score_details(
5659: p_rule_id,
5660: p_party_id, p_party_search_rec,p_party_site_list,
5661: p_contact_list, p_contact_point_list,x_search_ctx_id);
5662: -- Code for Match rule SAMPLE: SEARCH SIMILAR PERSON EXACT

Line 6036: IF NOT HZ_MATCH_RULE_40.check_staged THEN

6032: p_party_id, x_party_search_rec,x_party_site_list,
6033: x_contact_list, x_contact_point_list);
6034: -- Code for Match rule SAMPLE: SEARCH SIMILAR ORGANIZATION EXACT
6035: ELSIF p_rule_id=40 THEN
6036: IF NOT HZ_MATCH_RULE_40.check_staged THEN
6037: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6038: FND_MSG_PUB.ADD;
6039: RAISE FND_API.G_EXC_ERROR;
6040: END IF;

Line 6041: HZ_MATCH_RULE_40.get_party_for_search(

6037: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6038: FND_MSG_PUB.ADD;
6039: RAISE FND_API.G_EXC_ERROR;
6040: END IF;
6041: HZ_MATCH_RULE_40.get_party_for_search(
6042: p_party_id, x_party_search_rec,x_party_site_list,
6043: x_contact_list, x_contact_point_list);
6044: -- Code for Match rule SAMPLE: SEARCH SIMILAR PERSON EXACT
6045: ELSIF p_rule_id=41 THEN

Line 6408: IF NOT HZ_MATCH_RULE_40.check_staged THEN

6404: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6405: x_contact_list, x_contact_point_list);
6406: -- Code for Match rule SAMPLE: SEARCH SIMILAR ORGANIZATION EXACT
6407: ELSIF p_rule_id=40 THEN
6408: IF NOT HZ_MATCH_RULE_40.check_staged THEN
6409: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6410: FND_MSG_PUB.ADD;
6411: RAISE FND_API.G_EXC_ERROR;
6412: END IF;

Line 6413: HZ_MATCH_RULE_40.get_search_criteria(

6409: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6410: FND_MSG_PUB.ADD;
6411: RAISE FND_API.G_EXC_ERROR;
6412: END IF;
6413: HZ_MATCH_RULE_40.get_search_criteria(
6414: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6415: x_contact_list, x_contact_point_list);
6416: -- Code for Match rule SAMPLE: SEARCH SIMILAR PERSON EXACT
6417: ELSIF p_rule_id=41 THEN