186: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
187: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,NULL,NULL,NULL,'N',x_search_ctx_id,x_num_matches);
188: -- Code for Match rule SAMPLE:BASIC SEARCH RULE
189: ELSIF p_rule_id=33 THEN
190: IF NOT HZ_MATCH_RULE_33.check_staged THEN
191: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
192: FND_MSG_PUB.ADD;
193: RAISE FND_API.G_EXC_ERROR;
194: END IF;
191: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
192: FND_MSG_PUB.ADD;
193: RAISE FND_API.G_EXC_ERROR;
194: END IF;
195: HZ_MATCH_RULE_33.find_parties(
196: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
197: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,NULL,NULL,NULL,'N',x_search_ctx_id,x_num_matches);
198: -- Code for Match rule SAMPLE:ADVANCED SEARCH RULE
199: ELSIF p_rule_id=34 THEN
587: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
588: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,'N',x_search_ctx_id,x_num_matches);
589: -- Code for Match rule SAMPLE:BASIC SEARCH RULE
590: ELSIF p_rule_id=33 THEN
591: IF NOT HZ_MATCH_RULE_33.check_staged THEN
592: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
593: FND_MSG_PUB.ADD;
594: RAISE FND_API.G_EXC_ERROR;
595: END IF;
592: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
593: FND_MSG_PUB.ADD;
594: RAISE FND_API.G_EXC_ERROR;
595: END IF;
596: HZ_MATCH_RULE_33.find_persons(
597: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
598: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,'N',x_search_ctx_id,x_num_matches);
599: -- Code for Match rule SAMPLE:ADVANCED SEARCH RULE
600: ELSIF p_rule_id=34 THEN
1006: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
1007: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
1008: -- Code for Match rule SAMPLE:BASIC SEARCH RULE
1009: ELSIF p_rule_id=33 THEN
1010: IF NOT HZ_MATCH_RULE_33.check_staged THEN
1011: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1012: FND_MSG_PUB.ADD;
1013: RAISE FND_API.G_EXC_ERROR;
1014: END IF;
1011: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1012: FND_MSG_PUB.ADD;
1013: RAISE FND_API.G_EXC_ERROR;
1014: END IF;
1015: HZ_MATCH_RULE_33.find_party_details(
1016: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
1017: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
1018: -- Code for Match rule SAMPLE:ADVANCED SEARCH RULE
1019: ELSIF p_rule_id=34 THEN
1406: p_rule_id,p_party_id,
1407: p_restrict_sql,p_match_type,p_dup_batch_id,p_search_merged,x_dup_set_id, x_search_ctx_id,x_num_matches);
1408: -- Code for Match rule SAMPLE:BASIC SEARCH RULE
1409: ELSIF p_rule_id=33 THEN
1410: IF NOT HZ_MATCH_RULE_33.check_staged THEN
1411: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1412: FND_MSG_PUB.ADD;
1413: RAISE FND_API.G_EXC_ERROR;
1414: END IF;
1411: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1412: FND_MSG_PUB.ADD;
1413: RAISE FND_API.G_EXC_ERROR;
1414: END IF;
1415: HZ_MATCH_RULE_33.find_duplicate_parties(
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:ADVANCED SEARCH RULE
1419: ELSIF p_rule_id=34 THEN
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:BASIC SEARCH RULE
1804: ELSIF p_rule_id=33 THEN
1805: IF NOT HZ_MATCH_RULE_33.check_staged THEN
1806: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1807: FND_MSG_PUB.ADD;
1808: RAISE FND_API.G_EXC_ERROR;
1809: END IF;
1806: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1807: FND_MSG_PUB.ADD;
1808: RAISE FND_API.G_EXC_ERROR;
1809: END IF;
1810: HZ_MATCH_RULE_33.find_duplicate_party_sites(
1811: p_rule_id,p_party_site_id,p_party_id,
1812: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
1813: -- Code for Match rule SAMPLE:ADVANCED SEARCH RULE
1814: ELSIF p_rule_id=34 THEN
2195: p_rule_id,p_org_contact_id,p_party_id,
2196: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2197: -- Code for Match rule SAMPLE:BASIC SEARCH RULE
2198: ELSIF p_rule_id=33 THEN
2199: IF NOT HZ_MATCH_RULE_33.check_staged THEN
2200: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2201: FND_MSG_PUB.ADD;
2202: RAISE FND_API.G_EXC_ERROR;
2203: END IF;
2200: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2201: FND_MSG_PUB.ADD;
2202: RAISE FND_API.G_EXC_ERROR;
2203: END IF;
2204: HZ_MATCH_RULE_33.find_duplicate_contacts(
2205: p_rule_id,p_org_contact_id,p_party_id,
2206: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2207: -- Code for Match rule SAMPLE:ADVANCED SEARCH RULE
2208: ELSIF p_rule_id=34 THEN
2589: p_rule_id,p_contact_point_id,p_party_id,
2590: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2591: -- Code for Match rule SAMPLE:BASIC SEARCH RULE
2592: ELSIF p_rule_id=33 THEN
2593: IF NOT HZ_MATCH_RULE_33.check_staged THEN
2594: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2595: FND_MSG_PUB.ADD;
2596: RAISE FND_API.G_EXC_ERROR;
2597: END IF;
2594: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2595: FND_MSG_PUB.ADD;
2596: RAISE FND_API.G_EXC_ERROR;
2597: END IF;
2598: HZ_MATCH_RULE_33.find_duplicate_contact_points(
2599: p_rule_id,p_contact_point_id,p_party_id,
2600: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2601: -- Code for Match rule SAMPLE:ADVANCED SEARCH RULE
2602: ELSIF p_rule_id=34 THEN
3087: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3088: p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
3089: -- Code for Match rule SAMPLE:BASIC SEARCH RULE
3090: ELSIF p_rule_id=33 THEN
3091: IF NOT HZ_MATCH_RULE_33.check_staged THEN
3092: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3093: FND_MSG_PUB.ADD;
3094: RAISE FND_API.G_EXC_ERROR;
3095: END IF;
3092: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3093: FND_MSG_PUB.ADD;
3094: RAISE FND_API.G_EXC_ERROR;
3095: END IF;
3096: HZ_MATCH_RULE_33.find_parties_dynamic(
3097: p_rule_id,
3098: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
3099: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
3100: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,
3770: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3771: p_restrict_sql,p_api_name,p_match_type,p_party_id,p_search_merged,x_search_ctx_id,x_num_matches);
3772: -- Code for Match rule SAMPLE:BASIC SEARCH RULE
3773: ELSIF p_rule_id=33 THEN
3774: IF NOT HZ_MATCH_RULE_33.check_staged THEN
3775: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3776: FND_MSG_PUB.ADD;
3777: RAISE FND_API.G_EXC_ERROR;
3778: END IF;
3775: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3776: FND_MSG_PUB.ADD;
3777: RAISE FND_API.G_EXC_ERROR;
3778: END IF;
3779: HZ_MATCH_RULE_33.call_api_dynamic(
3780: p_rule_id,
3781: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
3782: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
3783: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,
4580: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4581: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4582: -- Code for Match rule SAMPLE:BASIC SEARCH RULE
4583: ELSIF p_rule_id=33 THEN
4584: IF NOT HZ_MATCH_RULE_33.check_staged THEN
4585: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4586: FND_MSG_PUB.ADD;
4587: RAISE FND_API.G_EXC_ERROR;
4588: END IF;
4585: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4586: FND_MSG_PUB.ADD;
4587: RAISE FND_API.G_EXC_ERROR;
4588: END IF;
4589: HZ_MATCH_RULE_33.get_matching_party_sites(
4590: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4591: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4592: -- Code for Match rule SAMPLE:ADVANCED SEARCH RULE
4593: ELSIF p_rule_id=34 THEN
4999: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
5000: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5001: -- Code for Match rule SAMPLE:BASIC SEARCH RULE
5002: ELSIF p_rule_id=33 THEN
5003: IF NOT HZ_MATCH_RULE_33.check_staged THEN
5004: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5005: FND_MSG_PUB.ADD;
5006: RAISE FND_API.G_EXC_ERROR;
5007: END IF;
5004: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5005: FND_MSG_PUB.ADD;
5006: RAISE FND_API.G_EXC_ERROR;
5007: END IF;
5008: HZ_MATCH_RULE_33.get_matching_contacts(
5009: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
5010: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5011: -- Code for Match rule SAMPLE:ADVANCED SEARCH RULE
5012: ELSIF p_rule_id=34 THEN
5416: p_rule_id, p_party_id, p_contact_point_list,
5417: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5418: -- Code for Match rule SAMPLE:BASIC SEARCH RULE
5419: ELSIF p_rule_id=33 THEN
5420: IF NOT HZ_MATCH_RULE_33.check_staged THEN
5421: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5422: FND_MSG_PUB.ADD;
5423: RAISE FND_API.G_EXC_ERROR;
5424: END IF;
5421: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5422: FND_MSG_PUB.ADD;
5423: RAISE FND_API.G_EXC_ERROR;
5424: END IF;
5425: HZ_MATCH_RULE_33.get_matching_contact_points(
5426: p_rule_id, p_party_id, p_contact_point_list,
5427: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5428: -- Code for Match rule SAMPLE:ADVANCED SEARCH RULE
5429: ELSIF p_rule_id=34 THEN
5844: p_party_id, p_party_search_rec,p_party_site_list,
5845: p_contact_list, p_contact_point_list,x_search_ctx_id);
5846: -- Code for Match rule SAMPLE:BASIC SEARCH RULE
5847: ELSIF p_rule_id=33 THEN
5848: IF NOT HZ_MATCH_RULE_33.check_staged THEN
5849: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5850: FND_MSG_PUB.ADD;
5851: RAISE FND_API.G_EXC_ERROR;
5852: END IF;
5849: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5850: FND_MSG_PUB.ADD;
5851: RAISE FND_API.G_EXC_ERROR;
5852: END IF;
5853: HZ_MATCH_RULE_33.get_score_details(
5854: p_rule_id,
5855: p_party_id, p_party_search_rec,p_party_site_list,
5856: p_contact_list, p_contact_point_list,x_search_ctx_id);
5857: -- Code for Match rule SAMPLE:ADVANCED SEARCH RULE
6256: p_party_id, x_party_search_rec,x_party_site_list,
6257: x_contact_list, x_contact_point_list);
6258: -- Code for Match rule SAMPLE:BASIC SEARCH RULE
6259: ELSIF p_rule_id=33 THEN
6260: IF NOT HZ_MATCH_RULE_33.check_staged THEN
6261: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6262: FND_MSG_PUB.ADD;
6263: RAISE FND_API.G_EXC_ERROR;
6264: END IF;
6261: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6262: FND_MSG_PUB.ADD;
6263: RAISE FND_API.G_EXC_ERROR;
6264: END IF;
6265: HZ_MATCH_RULE_33.get_party_for_search(
6266: p_party_id, x_party_search_rec,x_party_site_list,
6267: x_contact_list, x_contact_point_list);
6268: -- Code for Match rule SAMPLE:ADVANCED SEARCH RULE
6269: ELSIF p_rule_id=34 THEN
6648: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6649: x_contact_list, x_contact_point_list);
6650: -- Code for Match rule SAMPLE:BASIC SEARCH RULE
6651: ELSIF p_rule_id=33 THEN
6652: IF NOT HZ_MATCH_RULE_33.check_staged THEN
6653: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6654: FND_MSG_PUB.ADD;
6655: RAISE FND_API.G_EXC_ERROR;
6656: END IF;
6653: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6654: FND_MSG_PUB.ADD;
6655: RAISE FND_API.G_EXC_ERROR;
6656: END IF;
6657: HZ_MATCH_RULE_33.get_search_criteria(
6658: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6659: x_contact_list, x_contact_point_list);
6660: -- Code for Match rule SAMPLE:ADVANCED SEARCH RULE
6661: ELSIF p_rule_id=34 THEN