DBA Data[Home] [Help]

APPS.HZ_PARTY_SEARCH dependencies on HZ_MATCH_RULE_35

Line 210: IF NOT HZ_MATCH_RULE_35.check_staged THEN

206: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
207: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,NULL,NULL,NULL,'N',x_search_ctx_id,x_num_matches);
208: -- Code for Match rule DL SMART SEARCH
209: ELSIF p_rule_id=35 THEN
210: IF NOT HZ_MATCH_RULE_35.check_staged THEN
211: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
212: FND_MSG_PUB.ADD;
213: RAISE FND_API.G_EXC_ERROR;
214: END IF;

Line 215: HZ_MATCH_RULE_35.find_parties(

211: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
212: FND_MSG_PUB.ADD;
213: RAISE FND_API.G_EXC_ERROR;
214: END IF;
215: HZ_MATCH_RULE_35.find_parties(
216: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
217: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,NULL,NULL,NULL,'N',x_search_ctx_id,x_num_matches);
218: -- Code for Match rule DL ADDRESS AND RELATIONSHIP SEARCH
219: ELSIF p_rule_id=36 THEN

Line 591: IF NOT HZ_MATCH_RULE_35.check_staged 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 DL SMART SEARCH
590: ELSIF p_rule_id=35 THEN
591: IF NOT HZ_MATCH_RULE_35.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;

Line 596: HZ_MATCH_RULE_35.find_persons(

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_35.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 DL ADDRESS AND RELATIONSHIP SEARCH
600: ELSIF p_rule_id=36 THEN

Line 990: IF NOT HZ_MATCH_RULE_35.check_staged THEN

986: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
987: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
988: -- Code for Match rule DL SMART SEARCH
989: ELSIF p_rule_id=35 THEN
990: IF NOT HZ_MATCH_RULE_35.check_staged THEN
991: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
992: FND_MSG_PUB.ADD;
993: RAISE FND_API.G_EXC_ERROR;
994: END IF;

Line 995: HZ_MATCH_RULE_35.find_party_details(

991: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
992: FND_MSG_PUB.ADD;
993: RAISE FND_API.G_EXC_ERROR;
994: END IF;
995: HZ_MATCH_RULE_35.find_party_details(
996: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
997: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
998: -- Code for Match rule DL ADDRESS AND RELATIONSHIP SEARCH
999: ELSIF p_rule_id=36 THEN

Line 1370: IF NOT HZ_MATCH_RULE_35.check_staged THEN

1366: p_rule_id,p_party_id,
1367: p_restrict_sql,p_match_type,p_dup_batch_id,p_search_merged,x_dup_set_id, x_search_ctx_id,x_num_matches);
1368: -- Code for Match rule DL SMART SEARCH
1369: ELSIF p_rule_id=35 THEN
1370: IF NOT HZ_MATCH_RULE_35.check_staged THEN
1371: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1372: FND_MSG_PUB.ADD;
1373: RAISE FND_API.G_EXC_ERROR;
1374: END IF;

Line 1375: HZ_MATCH_RULE_35.find_duplicate_parties(

1371: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1372: FND_MSG_PUB.ADD;
1373: RAISE FND_API.G_EXC_ERROR;
1374: END IF;
1375: HZ_MATCH_RULE_35.find_duplicate_parties(
1376: p_rule_id,p_party_id,
1377: p_restrict_sql,p_match_type,p_dup_batch_id,p_search_merged,x_dup_set_id, x_search_ctx_id,x_num_matches);
1378: -- Code for Match rule DL ADDRESS AND RELATIONSHIP SEARCH
1379: ELSIF p_rule_id=36 THEN

Line 1745: IF NOT HZ_MATCH_RULE_35.check_staged THEN

1741: p_rule_id,p_party_site_id,p_party_id,
1742: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
1743: -- Code for Match rule DL SMART SEARCH
1744: ELSIF p_rule_id=35 THEN
1745: IF NOT HZ_MATCH_RULE_35.check_staged THEN
1746: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1747: FND_MSG_PUB.ADD;
1748: RAISE FND_API.G_EXC_ERROR;
1749: END IF;

Line 1750: HZ_MATCH_RULE_35.find_duplicate_party_sites(

1746: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1747: FND_MSG_PUB.ADD;
1748: RAISE FND_API.G_EXC_ERROR;
1749: END IF;
1750: HZ_MATCH_RULE_35.find_duplicate_party_sites(
1751: p_rule_id,p_party_site_id,p_party_id,
1752: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
1753: -- Code for Match rule DL ADDRESS AND RELATIONSHIP SEARCH
1754: ELSIF p_rule_id=36 THEN

Line 2119: IF NOT HZ_MATCH_RULE_35.check_staged THEN

2115: p_rule_id,p_org_contact_id,p_party_id,
2116: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2117: -- Code for Match rule DL SMART SEARCH
2118: ELSIF p_rule_id=35 THEN
2119: IF NOT HZ_MATCH_RULE_35.check_staged THEN
2120: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2121: FND_MSG_PUB.ADD;
2122: RAISE FND_API.G_EXC_ERROR;
2123: END IF;

Line 2124: HZ_MATCH_RULE_35.find_duplicate_contacts(

2120: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2121: FND_MSG_PUB.ADD;
2122: RAISE FND_API.G_EXC_ERROR;
2123: END IF;
2124: HZ_MATCH_RULE_35.find_duplicate_contacts(
2125: p_rule_id,p_org_contact_id,p_party_id,
2126: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2127: -- Code for Match rule DL ADDRESS AND RELATIONSHIP SEARCH
2128: ELSIF p_rule_id=36 THEN

Line 2493: IF NOT HZ_MATCH_RULE_35.check_staged THEN

2489: p_rule_id,p_contact_point_id,p_party_id,
2490: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2491: -- Code for Match rule DL SMART SEARCH
2492: ELSIF p_rule_id=35 THEN
2493: IF NOT HZ_MATCH_RULE_35.check_staged THEN
2494: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2495: FND_MSG_PUB.ADD;
2496: RAISE FND_API.G_EXC_ERROR;
2497: END IF;

Line 2498: HZ_MATCH_RULE_35.find_duplicate_contact_points(

2494: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2495: FND_MSG_PUB.ADD;
2496: RAISE FND_API.G_EXC_ERROR;
2497: END IF;
2498: HZ_MATCH_RULE_35.find_duplicate_contact_points(
2499: p_rule_id,p_contact_point_id,p_party_id,
2500: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2501: -- Code for Match rule DL ADDRESS AND RELATIONSHIP SEARCH
2502: ELSIF p_rule_id=36 THEN

Line 2987: IF NOT HZ_MATCH_RULE_35.check_staged THEN

2983: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
2984: p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
2985: -- Code for Match rule DL SMART SEARCH
2986: ELSIF p_rule_id=35 THEN
2987: IF NOT HZ_MATCH_RULE_35.check_staged THEN
2988: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2989: FND_MSG_PUB.ADD;
2990: RAISE FND_API.G_EXC_ERROR;
2991: END IF;

Line 2992: HZ_MATCH_RULE_35.find_parties_dynamic(

2988: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2989: FND_MSG_PUB.ADD;
2990: RAISE FND_API.G_EXC_ERROR;
2991: END IF;
2992: HZ_MATCH_RULE_35.find_parties_dynamic(
2993: p_rule_id,
2994: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
2995: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
2996: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 3634: IF NOT HZ_MATCH_RULE_35.check_staged THEN

3630: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3631: p_restrict_sql,p_api_name,p_match_type,p_party_id,p_search_merged,x_search_ctx_id,x_num_matches);
3632: -- Code for Match rule DL SMART SEARCH
3633: ELSIF p_rule_id=35 THEN
3634: IF NOT HZ_MATCH_RULE_35.check_staged THEN
3635: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3636: FND_MSG_PUB.ADD;
3637: RAISE FND_API.G_EXC_ERROR;
3638: END IF;

Line 3639: HZ_MATCH_RULE_35.call_api_dynamic(

3635: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3636: FND_MSG_PUB.ADD;
3637: RAISE FND_API.G_EXC_ERROR;
3638: END IF;
3639: HZ_MATCH_RULE_35.call_api_dynamic(
3640: p_rule_id,
3641: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
3642: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
3643: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 4392: IF NOT HZ_MATCH_RULE_35.check_staged THEN

4388: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4389: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4390: -- Code for Match rule DL SMART SEARCH
4391: ELSIF p_rule_id=35 THEN
4392: IF NOT HZ_MATCH_RULE_35.check_staged THEN
4393: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4394: FND_MSG_PUB.ADD;
4395: RAISE FND_API.G_EXC_ERROR;
4396: END IF;

Line 4397: HZ_MATCH_RULE_35.get_matching_party_sites(

4393: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4394: FND_MSG_PUB.ADD;
4395: RAISE FND_API.G_EXC_ERROR;
4396: END IF;
4397: HZ_MATCH_RULE_35.get_matching_party_sites(
4398: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4399: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4400: -- Code for Match rule DL ADDRESS AND RELATIONSHIP SEARCH
4401: ELSIF p_rule_id=36 THEN

Line 4791: IF NOT HZ_MATCH_RULE_35.check_staged THEN

4787: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
4788: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4789: -- Code for Match rule DL SMART SEARCH
4790: ELSIF p_rule_id=35 THEN
4791: IF NOT HZ_MATCH_RULE_35.check_staged THEN
4792: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4793: FND_MSG_PUB.ADD;
4794: RAISE FND_API.G_EXC_ERROR;
4795: END IF;

Line 4796: HZ_MATCH_RULE_35.get_matching_contacts(

4792: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4793: FND_MSG_PUB.ADD;
4794: RAISE FND_API.G_EXC_ERROR;
4795: END IF;
4796: HZ_MATCH_RULE_35.get_matching_contacts(
4797: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
4798: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4799: -- Code for Match rule DL ADDRESS AND RELATIONSHIP SEARCH
4800: ELSIF p_rule_id=36 THEN

Line 5188: IF NOT HZ_MATCH_RULE_35.check_staged THEN

5184: p_rule_id, p_party_id, p_contact_point_list,
5185: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5186: -- Code for Match rule DL SMART SEARCH
5187: ELSIF p_rule_id=35 THEN
5188: IF NOT HZ_MATCH_RULE_35.check_staged THEN
5189: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5190: FND_MSG_PUB.ADD;
5191: RAISE FND_API.G_EXC_ERROR;
5192: END IF;

Line 5193: HZ_MATCH_RULE_35.get_matching_contact_points(

5189: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5190: FND_MSG_PUB.ADD;
5191: RAISE FND_API.G_EXC_ERROR;
5192: END IF;
5193: HZ_MATCH_RULE_35.get_matching_contact_points(
5194: p_rule_id, p_party_id, p_contact_point_list,
5195: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5196: -- Code for Match rule DL ADDRESS AND RELATIONSHIP SEARCH
5197: ELSIF p_rule_id=36 THEN

Line 5598: IF NOT HZ_MATCH_RULE_35.check_staged THEN

5594: p_party_id, p_party_search_rec,p_party_site_list,
5595: p_contact_list, p_contact_point_list,x_search_ctx_id);
5596: -- Code for Match rule DL SMART SEARCH
5597: ELSIF p_rule_id=35 THEN
5598: IF NOT HZ_MATCH_RULE_35.check_staged THEN
5599: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5600: FND_MSG_PUB.ADD;
5601: RAISE FND_API.G_EXC_ERROR;
5602: END IF;

Line 5603: HZ_MATCH_RULE_35.get_score_details(

5599: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5600: FND_MSG_PUB.ADD;
5601: RAISE FND_API.G_EXC_ERROR;
5602: END IF;
5603: HZ_MATCH_RULE_35.get_score_details(
5604: p_rule_id,
5605: p_party_id, p_party_search_rec,p_party_site_list,
5606: p_contact_list, p_contact_point_list,x_search_ctx_id);
5607: -- Code for Match rule DL ADDRESS AND RELATIONSHIP SEARCH

Line 5986: IF NOT HZ_MATCH_RULE_35.check_staged THEN

5982: p_party_id, x_party_search_rec,x_party_site_list,
5983: x_contact_list, x_contact_point_list);
5984: -- Code for Match rule DL SMART SEARCH
5985: ELSIF p_rule_id=35 THEN
5986: IF NOT HZ_MATCH_RULE_35.check_staged THEN
5987: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5988: FND_MSG_PUB.ADD;
5989: RAISE FND_API.G_EXC_ERROR;
5990: END IF;

Line 5991: HZ_MATCH_RULE_35.get_party_for_search(

5987: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5988: FND_MSG_PUB.ADD;
5989: RAISE FND_API.G_EXC_ERROR;
5990: END IF;
5991: HZ_MATCH_RULE_35.get_party_for_search(
5992: p_party_id, x_party_search_rec,x_party_site_list,
5993: x_contact_list, x_contact_point_list);
5994: -- Code for Match rule DL ADDRESS AND RELATIONSHIP SEARCH
5995: ELSIF p_rule_id=36 THEN

Line 6358: IF NOT HZ_MATCH_RULE_35.check_staged THEN

6354: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6355: x_contact_list, x_contact_point_list);
6356: -- Code for Match rule DL SMART SEARCH
6357: ELSIF p_rule_id=35 THEN
6358: IF NOT HZ_MATCH_RULE_35.check_staged THEN
6359: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6360: FND_MSG_PUB.ADD;
6361: RAISE FND_API.G_EXC_ERROR;
6362: END IF;

Line 6363: HZ_MATCH_RULE_35.get_search_criteria(

6359: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6360: FND_MSG_PUB.ADD;
6361: RAISE FND_API.G_EXC_ERROR;
6362: END IF;
6363: HZ_MATCH_RULE_35.get_search_criteria(
6364: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6365: x_contact_list, x_contact_point_list);
6366: -- Code for Match rule DL ADDRESS AND RELATIONSHIP SEARCH
6367: ELSIF p_rule_id=36 THEN