DBA Data[Home] [Help]

APPS.HZ_PARTY_SEARCH dependencies on HZ_MATCH_RULE_8

Line 170: IF NOT HZ_MATCH_RULE_8.check_staged THEN

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
170: IF NOT HZ_MATCH_RULE_8.check_staged THEN
171: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
172: FND_MSG_PUB.ADD;
173: RAISE FND_API.G_EXC_ERROR;
174: END IF;

Line 175: HZ_MATCH_RULE_8.find_parties(

171: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
172: FND_MSG_PUB.ADD;
173: RAISE FND_API.G_EXC_ERROR;
174: END IF;
175: HZ_MATCH_RULE_8.find_parties(
176: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
177: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,NULL,NULL,NULL,'N',x_search_ctx_id,x_num_matches);
178: -- Code for Match rule RM SEARCH RULE
179: ELSIF p_rule_id=32 THEN

Line 571: IF NOT HZ_MATCH_RULE_8.check_staged THEN

567: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
568: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,'N',x_search_ctx_id,x_num_matches);
569: -- Code for Match rule SAMPLE: SEARCH
570: ELSIF p_rule_id=8 THEN
571: IF NOT HZ_MATCH_RULE_8.check_staged THEN
572: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
573: FND_MSG_PUB.ADD;
574: RAISE FND_API.G_EXC_ERROR;
575: END IF;

Line 576: HZ_MATCH_RULE_8.find_persons(

572: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
573: FND_MSG_PUB.ADD;
574: RAISE FND_API.G_EXC_ERROR;
575: END IF;
576: HZ_MATCH_RULE_8.find_persons(
577: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
578: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,'N',x_search_ctx_id,x_num_matches);
579: -- Code for Match rule RM SEARCH RULE
580: ELSIF p_rule_id=32 THEN

Line 990: IF NOT HZ_MATCH_RULE_8.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 SAMPLE: SEARCH
989: ELSIF p_rule_id=8 THEN
990: IF NOT HZ_MATCH_RULE_8.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_8.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_8.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 RM SEARCH RULE
999: ELSIF p_rule_id=32 THEN

Line 1390: IF NOT HZ_MATCH_RULE_8.check_staged THEN

1386: p_rule_id,p_party_id,
1387: p_restrict_sql,p_match_type,p_dup_batch_id,p_search_merged,x_dup_set_id, x_search_ctx_id,x_num_matches);
1388: -- Code for Match rule SAMPLE: SEARCH
1389: ELSIF p_rule_id=8 THEN
1390: IF NOT HZ_MATCH_RULE_8.check_staged THEN
1391: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1392: FND_MSG_PUB.ADD;
1393: RAISE FND_API.G_EXC_ERROR;
1394: END IF;

Line 1395: HZ_MATCH_RULE_8.find_duplicate_parties(

1391: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1392: FND_MSG_PUB.ADD;
1393: RAISE FND_API.G_EXC_ERROR;
1394: END IF;
1395: HZ_MATCH_RULE_8.find_duplicate_parties(
1396: p_rule_id,p_party_id,
1397: p_restrict_sql,p_match_type,p_dup_batch_id,p_search_merged,x_dup_set_id, x_search_ctx_id,x_num_matches);
1398: -- Code for Match rule RM SEARCH RULE
1399: ELSIF p_rule_id=32 THEN

Line 1785: IF NOT HZ_MATCH_RULE_8.check_staged THEN

1781: p_rule_id,p_party_site_id,p_party_id,
1782: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
1783: -- Code for Match rule SAMPLE: SEARCH
1784: ELSIF p_rule_id=8 THEN
1785: IF NOT HZ_MATCH_RULE_8.check_staged THEN
1786: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1787: FND_MSG_PUB.ADD;
1788: RAISE FND_API.G_EXC_ERROR;
1789: END IF;

Line 1790: HZ_MATCH_RULE_8.find_duplicate_party_sites(

1786: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1787: FND_MSG_PUB.ADD;
1788: RAISE FND_API.G_EXC_ERROR;
1789: END IF;
1790: HZ_MATCH_RULE_8.find_duplicate_party_sites(
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 RM SEARCH RULE
1794: ELSIF p_rule_id=32 THEN

Line 2179: IF NOT HZ_MATCH_RULE_8.check_staged THEN

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
2178: ELSIF p_rule_id=8 THEN
2179: IF NOT HZ_MATCH_RULE_8.check_staged THEN
2180: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2181: FND_MSG_PUB.ADD;
2182: RAISE FND_API.G_EXC_ERROR;
2183: END IF;

Line 2184: HZ_MATCH_RULE_8.find_duplicate_contacts(

2180: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2181: FND_MSG_PUB.ADD;
2182: RAISE FND_API.G_EXC_ERROR;
2183: END IF;
2184: HZ_MATCH_RULE_8.find_duplicate_contacts(
2185: p_rule_id,p_org_contact_id,p_party_id,
2186: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2187: -- Code for Match rule RM SEARCH RULE
2188: ELSIF p_rule_id=32 THEN

Line 2573: IF NOT HZ_MATCH_RULE_8.check_staged THEN

2569: p_rule_id,p_contact_point_id,p_party_id,
2570: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2571: -- Code for Match rule SAMPLE: SEARCH
2572: ELSIF p_rule_id=8 THEN
2573: IF NOT HZ_MATCH_RULE_8.check_staged THEN
2574: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2575: FND_MSG_PUB.ADD;
2576: RAISE FND_API.G_EXC_ERROR;
2577: END IF;

Line 2578: HZ_MATCH_RULE_8.find_duplicate_contact_points(

2574: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2575: FND_MSG_PUB.ADD;
2576: RAISE FND_API.G_EXC_ERROR;
2577: END IF;
2578: HZ_MATCH_RULE_8.find_duplicate_contact_points(
2579: p_rule_id,p_contact_point_id,p_party_id,
2580: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2581: -- Code for Match rule RM SEARCH RULE
2582: ELSIF p_rule_id=32 THEN

Line 3055: IF NOT HZ_MATCH_RULE_8.check_staged THEN

3051: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3052: p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
3053: -- Code for Match rule SAMPLE: SEARCH
3054: ELSIF p_rule_id=8 THEN
3055: IF NOT HZ_MATCH_RULE_8.check_staged THEN
3056: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3057: FND_MSG_PUB.ADD;
3058: RAISE FND_API.G_EXC_ERROR;
3059: END IF;

Line 3060: HZ_MATCH_RULE_8.find_parties_dynamic(

3056: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3057: FND_MSG_PUB.ADD;
3058: RAISE FND_API.G_EXC_ERROR;
3059: END IF;
3060: HZ_MATCH_RULE_8.find_parties_dynamic(
3061: p_rule_id,
3062: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
3063: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
3064: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 3738: IF NOT HZ_MATCH_RULE_8.check_staged THEN

3734: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3735: p_restrict_sql,p_api_name,p_match_type,p_party_id,p_search_merged,x_search_ctx_id,x_num_matches);
3736: -- Code for Match rule SAMPLE: SEARCH
3737: ELSIF p_rule_id=8 THEN
3738: IF NOT HZ_MATCH_RULE_8.check_staged THEN
3739: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3740: FND_MSG_PUB.ADD;
3741: RAISE FND_API.G_EXC_ERROR;
3742: END IF;

Line 3743: HZ_MATCH_RULE_8.call_api_dynamic(

3739: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3740: FND_MSG_PUB.ADD;
3741: RAISE FND_API.G_EXC_ERROR;
3742: END IF;
3743: HZ_MATCH_RULE_8.call_api_dynamic(
3744: p_rule_id,
3745: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
3746: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
3747: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 4564: IF NOT HZ_MATCH_RULE_8.check_staged THEN

4560: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4561: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4562: -- Code for Match rule SAMPLE: SEARCH
4563: ELSIF p_rule_id=8 THEN
4564: IF NOT HZ_MATCH_RULE_8.check_staged THEN
4565: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4566: FND_MSG_PUB.ADD;
4567: RAISE FND_API.G_EXC_ERROR;
4568: END IF;

Line 4569: HZ_MATCH_RULE_8.get_matching_party_sites(

4565: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4566: FND_MSG_PUB.ADD;
4567: RAISE FND_API.G_EXC_ERROR;
4568: END IF;
4569: HZ_MATCH_RULE_8.get_matching_party_sites(
4570: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4571: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4572: -- Code for Match rule RM SEARCH RULE
4573: ELSIF p_rule_id=32 THEN

Line 4983: IF NOT HZ_MATCH_RULE_8.check_staged THEN

4979: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
4980: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4981: -- Code for Match rule SAMPLE: SEARCH
4982: ELSIF p_rule_id=8 THEN
4983: IF NOT HZ_MATCH_RULE_8.check_staged THEN
4984: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4985: FND_MSG_PUB.ADD;
4986: RAISE FND_API.G_EXC_ERROR;
4987: END IF;

Line 4988: HZ_MATCH_RULE_8.get_matching_contacts(

4984: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4985: FND_MSG_PUB.ADD;
4986: RAISE FND_API.G_EXC_ERROR;
4987: END IF;
4988: HZ_MATCH_RULE_8.get_matching_contacts(
4989: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
4990: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4991: -- Code for Match rule RM SEARCH RULE
4992: ELSIF p_rule_id=32 THEN

Line 5400: IF NOT HZ_MATCH_RULE_8.check_staged THEN

5396: p_rule_id, p_party_id, p_contact_point_list,
5397: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5398: -- Code for Match rule SAMPLE: SEARCH
5399: ELSIF p_rule_id=8 THEN
5400: IF NOT HZ_MATCH_RULE_8.check_staged THEN
5401: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5402: FND_MSG_PUB.ADD;
5403: RAISE FND_API.G_EXC_ERROR;
5404: END IF;

Line 5405: HZ_MATCH_RULE_8.get_matching_contact_points(

5401: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5402: FND_MSG_PUB.ADD;
5403: RAISE FND_API.G_EXC_ERROR;
5404: END IF;
5405: HZ_MATCH_RULE_8.get_matching_contact_points(
5406: p_rule_id, p_party_id, p_contact_point_list,
5407: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5408: -- Code for Match rule RM SEARCH RULE
5409: ELSIF p_rule_id=32 THEN

Line 5826: IF NOT HZ_MATCH_RULE_8.check_staged THEN

5822: p_party_id, p_party_search_rec,p_party_site_list,
5823: p_contact_list, p_contact_point_list,x_search_ctx_id);
5824: -- Code for Match rule SAMPLE: SEARCH
5825: ELSIF p_rule_id=8 THEN
5826: IF NOT HZ_MATCH_RULE_8.check_staged THEN
5827: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5828: FND_MSG_PUB.ADD;
5829: RAISE FND_API.G_EXC_ERROR;
5830: END IF;

Line 5831: HZ_MATCH_RULE_8.get_score_details(

5827: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5828: FND_MSG_PUB.ADD;
5829: RAISE FND_API.G_EXC_ERROR;
5830: END IF;
5831: HZ_MATCH_RULE_8.get_score_details(
5832: p_rule_id,
5833: p_party_id, p_party_search_rec,p_party_site_list,
5834: p_contact_list, p_contact_point_list,x_search_ctx_id);
5835: -- Code for Match rule RM SEARCH RULE

Line 6240: IF NOT HZ_MATCH_RULE_8.check_staged THEN

6236: p_party_id, x_party_search_rec,x_party_site_list,
6237: x_contact_list, x_contact_point_list);
6238: -- Code for Match rule SAMPLE: SEARCH
6239: ELSIF p_rule_id=8 THEN
6240: IF NOT HZ_MATCH_RULE_8.check_staged THEN
6241: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6242: FND_MSG_PUB.ADD;
6243: RAISE FND_API.G_EXC_ERROR;
6244: END IF;

Line 6245: HZ_MATCH_RULE_8.get_party_for_search(

6241: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6242: FND_MSG_PUB.ADD;
6243: RAISE FND_API.G_EXC_ERROR;
6244: END IF;
6245: HZ_MATCH_RULE_8.get_party_for_search(
6246: p_party_id, x_party_search_rec,x_party_site_list,
6247: x_contact_list, x_contact_point_list);
6248: -- Code for Match rule RM SEARCH RULE
6249: ELSIF p_rule_id=32 THEN

Line 6632: IF NOT HZ_MATCH_RULE_8.check_staged THEN

6628: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6629: x_contact_list, x_contact_point_list);
6630: -- Code for Match rule SAMPLE: SEARCH
6631: ELSIF p_rule_id=8 THEN
6632: IF NOT HZ_MATCH_RULE_8.check_staged THEN
6633: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6634: FND_MSG_PUB.ADD;
6635: RAISE FND_API.G_EXC_ERROR;
6636: END IF;

Line 6637: HZ_MATCH_RULE_8.get_search_criteria(

6633: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6634: FND_MSG_PUB.ADD;
6635: RAISE FND_API.G_EXC_ERROR;
6636: END IF;
6637: HZ_MATCH_RULE_8.get_search_criteria(
6638: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6639: x_contact_list, x_contact_point_list);
6640: -- Code for Match rule RM SEARCH RULE
6641: ELSIF p_rule_id=32 THEN