DBA Data[Home] [Help]

APPS.HZ_PARTY_SEARCH dependencies on HZ_MATCH_RULE_7

Line 160: IF NOT HZ_MATCH_RULE_7.check_staged THEN

156: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
157: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,NULL,NULL,NULL,'N',x_search_ctx_id,x_num_matches);
158: -- Code for Match rule SAMPLE: SIMILAR_PERSON
159: ELSIF p_rule_id=7 THEN
160: IF NOT HZ_MATCH_RULE_7.check_staged THEN
161: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
162: FND_MSG_PUB.ADD;
163: RAISE FND_API.G_EXC_ERROR;
164: END IF;

Line 165: HZ_MATCH_RULE_7.find_parties(

161: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
162: FND_MSG_PUB.ADD;
163: RAISE FND_API.G_EXC_ERROR;
164: END IF;
165: HZ_MATCH_RULE_7.find_parties(
166: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
167: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,NULL,NULL,NULL,'N',x_search_ctx_id,x_num_matches);
168: -- Code for Match rule SAMPLE: SEARCH
169: ELSIF p_rule_id=8 THEN

Line 541: IF NOT HZ_MATCH_RULE_7.check_staged THEN

537: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
538: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,'N',x_search_ctx_id,x_num_matches);
539: -- Code for Match rule SAMPLE: SIMILAR_PERSON
540: ELSIF p_rule_id=7 THEN
541: IF NOT HZ_MATCH_RULE_7.check_staged THEN
542: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
543: FND_MSG_PUB.ADD;
544: RAISE FND_API.G_EXC_ERROR;
545: END IF;

Line 546: HZ_MATCH_RULE_7.find_persons(

542: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
543: FND_MSG_PUB.ADD;
544: RAISE FND_API.G_EXC_ERROR;
545: END IF;
546: HZ_MATCH_RULE_7.find_persons(
547: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
548: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,'N',x_search_ctx_id,x_num_matches);
549: -- Code for Match rule SAMPLE: SEARCH
550: ELSIF p_rule_id=8 THEN

Line 940: IF NOT HZ_MATCH_RULE_7.check_staged THEN

936: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
937: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
938: -- Code for Match rule SAMPLE: SIMILAR_PERSON
939: ELSIF p_rule_id=7 THEN
940: IF NOT HZ_MATCH_RULE_7.check_staged THEN
941: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
942: FND_MSG_PUB.ADD;
943: RAISE FND_API.G_EXC_ERROR;
944: END IF;

Line 945: HZ_MATCH_RULE_7.find_party_details(

941: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
942: FND_MSG_PUB.ADD;
943: RAISE FND_API.G_EXC_ERROR;
944: END IF;
945: HZ_MATCH_RULE_7.find_party_details(
946: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
947: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
948: -- Code for Match rule SAMPLE: SEARCH
949: ELSIF p_rule_id=8 THEN

Line 1320: IF NOT HZ_MATCH_RULE_7.check_staged THEN

1316: p_rule_id,p_party_id,
1317: p_restrict_sql,p_match_type,p_dup_batch_id,p_search_merged,x_dup_set_id, x_search_ctx_id,x_num_matches);
1318: -- Code for Match rule SAMPLE: SIMILAR_PERSON
1319: ELSIF p_rule_id=7 THEN
1320: IF NOT HZ_MATCH_RULE_7.check_staged THEN
1321: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1322: FND_MSG_PUB.ADD;
1323: RAISE FND_API.G_EXC_ERROR;
1324: END IF;

Line 1325: HZ_MATCH_RULE_7.find_duplicate_parties(

1321: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1322: FND_MSG_PUB.ADD;
1323: RAISE FND_API.G_EXC_ERROR;
1324: END IF;
1325: HZ_MATCH_RULE_7.find_duplicate_parties(
1326: p_rule_id,p_party_id,
1327: p_restrict_sql,p_match_type,p_dup_batch_id,p_search_merged,x_dup_set_id, x_search_ctx_id,x_num_matches);
1328: -- Code for Match rule SAMPLE: SEARCH
1329: ELSIF p_rule_id=8 THEN

Line 1695: IF NOT HZ_MATCH_RULE_7.check_staged THEN

1691: p_rule_id,p_party_site_id,p_party_id,
1692: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
1693: -- Code for Match rule SAMPLE: SIMILAR_PERSON
1694: ELSIF p_rule_id=7 THEN
1695: IF NOT HZ_MATCH_RULE_7.check_staged THEN
1696: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1697: FND_MSG_PUB.ADD;
1698: RAISE FND_API.G_EXC_ERROR;
1699: END IF;

Line 1700: HZ_MATCH_RULE_7.find_duplicate_party_sites(

1696: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1697: FND_MSG_PUB.ADD;
1698: RAISE FND_API.G_EXC_ERROR;
1699: END IF;
1700: HZ_MATCH_RULE_7.find_duplicate_party_sites(
1701: p_rule_id,p_party_site_id,p_party_id,
1702: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
1703: -- Code for Match rule SAMPLE: SEARCH
1704: ELSIF p_rule_id=8 THEN

Line 2069: IF NOT HZ_MATCH_RULE_7.check_staged THEN

2065: p_rule_id,p_org_contact_id,p_party_id,
2066: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2067: -- Code for Match rule SAMPLE: SIMILAR_PERSON
2068: ELSIF p_rule_id=7 THEN
2069: IF NOT HZ_MATCH_RULE_7.check_staged THEN
2070: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2071: FND_MSG_PUB.ADD;
2072: RAISE FND_API.G_EXC_ERROR;
2073: END IF;

Line 2074: HZ_MATCH_RULE_7.find_duplicate_contacts(

2070: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2071: FND_MSG_PUB.ADD;
2072: RAISE FND_API.G_EXC_ERROR;
2073: END IF;
2074: HZ_MATCH_RULE_7.find_duplicate_contacts(
2075: p_rule_id,p_org_contact_id,p_party_id,
2076: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2077: -- Code for Match rule SAMPLE: SEARCH
2078: ELSIF p_rule_id=8 THEN

Line 2443: IF NOT HZ_MATCH_RULE_7.check_staged THEN

2439: p_rule_id,p_contact_point_id,p_party_id,
2440: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2441: -- Code for Match rule SAMPLE: SIMILAR_PERSON
2442: ELSIF p_rule_id=7 THEN
2443: IF NOT HZ_MATCH_RULE_7.check_staged THEN
2444: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2445: FND_MSG_PUB.ADD;
2446: RAISE FND_API.G_EXC_ERROR;
2447: END IF;

Line 2448: HZ_MATCH_RULE_7.find_duplicate_contact_points(

2444: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2445: FND_MSG_PUB.ADD;
2446: RAISE FND_API.G_EXC_ERROR;
2447: END IF;
2448: HZ_MATCH_RULE_7.find_duplicate_contact_points(
2449: p_rule_id,p_contact_point_id,p_party_id,
2450: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2451: -- Code for Match rule SAMPLE: SEARCH
2452: ELSIF p_rule_id=8 THEN

Line 2897: IF NOT HZ_MATCH_RULE_7.check_staged THEN

2893: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
2894: p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
2895: -- Code for Match rule SAMPLE: SIMILAR_PERSON
2896: ELSIF p_rule_id=7 THEN
2897: IF NOT HZ_MATCH_RULE_7.check_staged THEN
2898: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2899: FND_MSG_PUB.ADD;
2900: RAISE FND_API.G_EXC_ERROR;
2901: END IF;

Line 2902: HZ_MATCH_RULE_7.find_parties_dynamic(

2898: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2899: FND_MSG_PUB.ADD;
2900: RAISE FND_API.G_EXC_ERROR;
2901: END IF;
2902: HZ_MATCH_RULE_7.find_parties_dynamic(
2903: p_rule_id,
2904: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
2905: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
2906: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 3544: IF NOT HZ_MATCH_RULE_7.check_staged THEN

3540: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3541: p_restrict_sql,p_api_name,p_match_type,p_party_id,p_search_merged,x_search_ctx_id,x_num_matches);
3542: -- Code for Match rule SAMPLE: SIMILAR_PERSON
3543: ELSIF p_rule_id=7 THEN
3544: IF NOT HZ_MATCH_RULE_7.check_staged THEN
3545: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3546: FND_MSG_PUB.ADD;
3547: RAISE FND_API.G_EXC_ERROR;
3548: END IF;

Line 3549: HZ_MATCH_RULE_7.call_api_dynamic(

3545: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3546: FND_MSG_PUB.ADD;
3547: RAISE FND_API.G_EXC_ERROR;
3548: END IF;
3549: HZ_MATCH_RULE_7.call_api_dynamic(
3550: p_rule_id,
3551: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
3552: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
3553: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 4342: IF NOT HZ_MATCH_RULE_7.check_staged THEN

4338: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4339: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4340: -- Code for Match rule SAMPLE: SIMILAR_PERSON
4341: ELSIF p_rule_id=7 THEN
4342: IF NOT HZ_MATCH_RULE_7.check_staged THEN
4343: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4344: FND_MSG_PUB.ADD;
4345: RAISE FND_API.G_EXC_ERROR;
4346: END IF;

Line 4347: HZ_MATCH_RULE_7.get_matching_party_sites(

4343: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4344: FND_MSG_PUB.ADD;
4345: RAISE FND_API.G_EXC_ERROR;
4346: END IF;
4347: HZ_MATCH_RULE_7.get_matching_party_sites(
4348: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4349: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4350: -- Code for Match rule SAMPLE: SEARCH
4351: ELSIF p_rule_id=8 THEN

Line 4741: IF NOT HZ_MATCH_RULE_7.check_staged THEN

4737: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
4738: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4739: -- Code for Match rule SAMPLE: SIMILAR_PERSON
4740: ELSIF p_rule_id=7 THEN
4741: IF NOT HZ_MATCH_RULE_7.check_staged THEN
4742: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4743: FND_MSG_PUB.ADD;
4744: RAISE FND_API.G_EXC_ERROR;
4745: END IF;

Line 4746: HZ_MATCH_RULE_7.get_matching_contacts(

4742: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4743: FND_MSG_PUB.ADD;
4744: RAISE FND_API.G_EXC_ERROR;
4745: END IF;
4746: HZ_MATCH_RULE_7.get_matching_contacts(
4747: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
4748: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4749: -- Code for Match rule SAMPLE: SEARCH
4750: ELSIF p_rule_id=8 THEN

Line 5138: IF NOT HZ_MATCH_RULE_7.check_staged THEN

5134: p_rule_id, p_party_id, p_contact_point_list,
5135: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5136: -- Code for Match rule SAMPLE: SIMILAR_PERSON
5137: ELSIF p_rule_id=7 THEN
5138: IF NOT HZ_MATCH_RULE_7.check_staged THEN
5139: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5140: FND_MSG_PUB.ADD;
5141: RAISE FND_API.G_EXC_ERROR;
5142: END IF;

Line 5143: HZ_MATCH_RULE_7.get_matching_contact_points(

5139: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5140: FND_MSG_PUB.ADD;
5141: RAISE FND_API.G_EXC_ERROR;
5142: END IF;
5143: HZ_MATCH_RULE_7.get_matching_contact_points(
5144: p_rule_id, p_party_id, p_contact_point_list,
5145: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5146: -- Code for Match rule SAMPLE: SEARCH
5147: ELSIF p_rule_id=8 THEN

Line 5543: IF NOT HZ_MATCH_RULE_7.check_staged THEN

5539: p_party_id, p_party_search_rec,p_party_site_list,
5540: p_contact_list, p_contact_point_list,x_search_ctx_id);
5541: -- Code for Match rule SAMPLE: SIMILAR_PERSON
5542: ELSIF p_rule_id=7 THEN
5543: IF NOT HZ_MATCH_RULE_7.check_staged THEN
5544: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5545: FND_MSG_PUB.ADD;
5546: RAISE FND_API.G_EXC_ERROR;
5547: END IF;

Line 5548: HZ_MATCH_RULE_7.get_score_details(

5544: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5545: FND_MSG_PUB.ADD;
5546: RAISE FND_API.G_EXC_ERROR;
5547: END IF;
5548: HZ_MATCH_RULE_7.get_score_details(
5549: p_rule_id,
5550: p_party_id, p_party_search_rec,p_party_site_list,
5551: p_contact_list, p_contact_point_list,x_search_ctx_id);
5552: -- Code for Match rule SAMPLE: SEARCH

Line 5936: IF NOT HZ_MATCH_RULE_7.check_staged THEN

5932: p_party_id, x_party_search_rec,x_party_site_list,
5933: x_contact_list, x_contact_point_list);
5934: -- Code for Match rule SAMPLE: SIMILAR_PERSON
5935: ELSIF p_rule_id=7 THEN
5936: IF NOT HZ_MATCH_RULE_7.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_7.get_party_for_search(

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_7.get_party_for_search(
5942: p_party_id, x_party_search_rec,x_party_site_list,
5943: x_contact_list, x_contact_point_list);
5944: -- Code for Match rule SAMPLE: SEARCH
5945: ELSIF p_rule_id=8 THEN

Line 6308: IF NOT HZ_MATCH_RULE_7.check_staged THEN

6304: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6305: x_contact_list, x_contact_point_list);
6306: -- Code for Match rule SAMPLE: SIMILAR_PERSON
6307: ELSIF p_rule_id=7 THEN
6308: IF NOT HZ_MATCH_RULE_7.check_staged THEN
6309: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6310: FND_MSG_PUB.ADD;
6311: RAISE FND_API.G_EXC_ERROR;
6312: END IF;

Line 6313: HZ_MATCH_RULE_7.get_search_criteria(

6309: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6310: FND_MSG_PUB.ADD;
6311: RAISE FND_API.G_EXC_ERROR;
6312: END IF;
6313: HZ_MATCH_RULE_7.get_search_criteria(
6314: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6315: x_contact_list, x_contact_point_list);
6316: -- Code for Match rule SAMPLE: SEARCH
6317: ELSIF p_rule_id=8 THEN