DBA Data[Home] [Help]

APPS.HZ_PARTY_SEARCH dependencies on HZ_MATCH_RULE_37

Line 230: IF NOT HZ_MATCH_RULE_37.check_staged THEN

226: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
227: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,NULL,NULL,NULL,'N',x_search_ctx_id,x_num_matches);
228: -- Code for Match rule DL ADDRESS DEFAULT
229: ELSIF p_rule_id=37 THEN
230: IF NOT HZ_MATCH_RULE_37.check_staged THEN
231: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
232: FND_MSG_PUB.ADD;
233: RAISE FND_API.G_EXC_ERROR;
234: END IF;

Line 235: HZ_MATCH_RULE_37.find_parties(

231: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
232: FND_MSG_PUB.ADD;
233: RAISE FND_API.G_EXC_ERROR;
234: END IF;
235: HZ_MATCH_RULE_37.find_parties(
236: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
237: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,NULL,NULL,NULL,'N',x_search_ctx_id,x_num_matches);
238: -- Code for Match rule DL RELATIONSHIP DEFAULT
239: ELSIF p_rule_id=38 THEN

Line 631: IF NOT HZ_MATCH_RULE_37.check_staged THEN

627: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
628: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,'N',x_search_ctx_id,x_num_matches);
629: -- Code for Match rule DL ADDRESS DEFAULT
630: ELSIF p_rule_id=37 THEN
631: IF NOT HZ_MATCH_RULE_37.check_staged THEN
632: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
633: FND_MSG_PUB.ADD;
634: RAISE FND_API.G_EXC_ERROR;
635: END IF;

Line 636: HZ_MATCH_RULE_37.find_persons(

632: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
633: FND_MSG_PUB.ADD;
634: RAISE FND_API.G_EXC_ERROR;
635: END IF;
636: HZ_MATCH_RULE_37.find_persons(
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 DL RELATIONSHIP DEFAULT
640: ELSIF p_rule_id=38 THEN

Line 1050: IF NOT HZ_MATCH_RULE_37.check_staged THEN

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 DL ADDRESS DEFAULT
1049: ELSIF p_rule_id=37 THEN
1050: IF NOT HZ_MATCH_RULE_37.check_staged THEN
1051: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1052: FND_MSG_PUB.ADD;
1053: RAISE FND_API.G_EXC_ERROR;
1054: END IF;

Line 1055: HZ_MATCH_RULE_37.find_party_details(

1051: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1052: FND_MSG_PUB.ADD;
1053: RAISE FND_API.G_EXC_ERROR;
1054: END IF;
1055: HZ_MATCH_RULE_37.find_party_details(
1056: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
1057: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
1058: -- Code for Match rule DL RELATIONSHIP DEFAULT
1059: ELSIF p_rule_id=38 THEN

Line 1450: IF NOT HZ_MATCH_RULE_37.check_staged THEN

1446: p_rule_id,p_party_id,
1447: p_restrict_sql,p_match_type,p_dup_batch_id,p_search_merged,x_dup_set_id, x_search_ctx_id,x_num_matches);
1448: -- Code for Match rule DL ADDRESS DEFAULT
1449: ELSIF p_rule_id=37 THEN
1450: IF NOT HZ_MATCH_RULE_37.check_staged THEN
1451: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1452: FND_MSG_PUB.ADD;
1453: RAISE FND_API.G_EXC_ERROR;
1454: END IF;

Line 1455: HZ_MATCH_RULE_37.find_duplicate_parties(

1451: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1452: FND_MSG_PUB.ADD;
1453: RAISE FND_API.G_EXC_ERROR;
1454: END IF;
1455: HZ_MATCH_RULE_37.find_duplicate_parties(
1456: p_rule_id,p_party_id,
1457: p_restrict_sql,p_match_type,p_dup_batch_id,p_search_merged,x_dup_set_id, x_search_ctx_id,x_num_matches);
1458: -- Code for Match rule DL RELATIONSHIP DEFAULT
1459: ELSIF p_rule_id=38 THEN

Line 1845: IF NOT HZ_MATCH_RULE_37.check_staged THEN

1841: p_rule_id,p_party_site_id,p_party_id,
1842: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
1843: -- Code for Match rule DL ADDRESS DEFAULT
1844: ELSIF p_rule_id=37 THEN
1845: IF NOT HZ_MATCH_RULE_37.check_staged THEN
1846: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1847: FND_MSG_PUB.ADD;
1848: RAISE FND_API.G_EXC_ERROR;
1849: END IF;

Line 1850: HZ_MATCH_RULE_37.find_duplicate_party_sites(

1846: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1847: FND_MSG_PUB.ADD;
1848: RAISE FND_API.G_EXC_ERROR;
1849: END IF;
1850: HZ_MATCH_RULE_37.find_duplicate_party_sites(
1851: p_rule_id,p_party_site_id,p_party_id,
1852: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
1853: -- Code for Match rule DL RELATIONSHIP DEFAULT
1854: ELSIF p_rule_id=38 THEN

Line 2239: IF NOT HZ_MATCH_RULE_37.check_staged THEN

2235: p_rule_id,p_org_contact_id,p_party_id,
2236: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2237: -- Code for Match rule DL ADDRESS DEFAULT
2238: ELSIF p_rule_id=37 THEN
2239: IF NOT HZ_MATCH_RULE_37.check_staged THEN
2240: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2241: FND_MSG_PUB.ADD;
2242: RAISE FND_API.G_EXC_ERROR;
2243: END IF;

Line 2244: HZ_MATCH_RULE_37.find_duplicate_contacts(

2240: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2241: FND_MSG_PUB.ADD;
2242: RAISE FND_API.G_EXC_ERROR;
2243: END IF;
2244: HZ_MATCH_RULE_37.find_duplicate_contacts(
2245: p_rule_id,p_org_contact_id,p_party_id,
2246: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2247: -- Code for Match rule DL RELATIONSHIP DEFAULT
2248: ELSIF p_rule_id=38 THEN

Line 2633: IF NOT HZ_MATCH_RULE_37.check_staged THEN

2629: p_rule_id,p_contact_point_id,p_party_id,
2630: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2631: -- Code for Match rule DL ADDRESS DEFAULT
2632: ELSIF p_rule_id=37 THEN
2633: IF NOT HZ_MATCH_RULE_37.check_staged THEN
2634: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2635: FND_MSG_PUB.ADD;
2636: RAISE FND_API.G_EXC_ERROR;
2637: END IF;

Line 2638: HZ_MATCH_RULE_37.find_duplicate_contact_points(

2634: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2635: FND_MSG_PUB.ADD;
2636: RAISE FND_API.G_EXC_ERROR;
2637: END IF;
2638: HZ_MATCH_RULE_37.find_duplicate_contact_points(
2639: p_rule_id,p_contact_point_id,p_party_id,
2640: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2641: -- Code for Match rule DL RELATIONSHIP DEFAULT
2642: ELSIF p_rule_id=38 THEN

Line 3163: IF NOT HZ_MATCH_RULE_37.check_staged THEN

3159: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3160: p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
3161: -- Code for Match rule DL ADDRESS DEFAULT
3162: ELSIF p_rule_id=37 THEN
3163: IF NOT HZ_MATCH_RULE_37.check_staged THEN
3164: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3165: FND_MSG_PUB.ADD;
3166: RAISE FND_API.G_EXC_ERROR;
3167: END IF;

Line 3168: HZ_MATCH_RULE_37.find_parties_dynamic(

3164: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3165: FND_MSG_PUB.ADD;
3166: RAISE FND_API.G_EXC_ERROR;
3167: END IF;
3168: HZ_MATCH_RULE_37.find_parties_dynamic(
3169: p_rule_id,
3170: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
3171: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
3172: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 3846: IF NOT HZ_MATCH_RULE_37.check_staged THEN

3842: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3843: p_restrict_sql,p_api_name,p_match_type,p_party_id,p_search_merged,x_search_ctx_id,x_num_matches);
3844: -- Code for Match rule DL ADDRESS DEFAULT
3845: ELSIF p_rule_id=37 THEN
3846: IF NOT HZ_MATCH_RULE_37.check_staged THEN
3847: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3848: FND_MSG_PUB.ADD;
3849: RAISE FND_API.G_EXC_ERROR;
3850: END IF;

Line 3851: HZ_MATCH_RULE_37.call_api_dynamic(

3847: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3848: FND_MSG_PUB.ADD;
3849: RAISE FND_API.G_EXC_ERROR;
3850: END IF;
3851: HZ_MATCH_RULE_37.call_api_dynamic(
3852: p_rule_id,
3853: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
3854: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
3855: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 4624: IF NOT HZ_MATCH_RULE_37.check_staged THEN

4620: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4621: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4622: -- Code for Match rule DL ADDRESS DEFAULT
4623: ELSIF p_rule_id=37 THEN
4624: IF NOT HZ_MATCH_RULE_37.check_staged THEN
4625: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4626: FND_MSG_PUB.ADD;
4627: RAISE FND_API.G_EXC_ERROR;
4628: END IF;

Line 4629: HZ_MATCH_RULE_37.get_matching_party_sites(

4625: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4626: FND_MSG_PUB.ADD;
4627: RAISE FND_API.G_EXC_ERROR;
4628: END IF;
4629: HZ_MATCH_RULE_37.get_matching_party_sites(
4630: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4631: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4632: -- Code for Match rule DL RELATIONSHIP DEFAULT
4633: ELSIF p_rule_id=38 THEN

Line 5043: IF NOT HZ_MATCH_RULE_37.check_staged THEN

5039: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
5040: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5041: -- Code for Match rule DL ADDRESS DEFAULT
5042: ELSIF p_rule_id=37 THEN
5043: IF NOT HZ_MATCH_RULE_37.check_staged THEN
5044: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5045: FND_MSG_PUB.ADD;
5046: RAISE FND_API.G_EXC_ERROR;
5047: END IF;

Line 5048: HZ_MATCH_RULE_37.get_matching_contacts(

5044: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5045: FND_MSG_PUB.ADD;
5046: RAISE FND_API.G_EXC_ERROR;
5047: END IF;
5048: HZ_MATCH_RULE_37.get_matching_contacts(
5049: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
5050: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5051: -- Code for Match rule DL RELATIONSHIP DEFAULT
5052: ELSIF p_rule_id=38 THEN

Line 5460: IF NOT HZ_MATCH_RULE_37.check_staged THEN

5456: p_rule_id, p_party_id, p_contact_point_list,
5457: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5458: -- Code for Match rule DL ADDRESS DEFAULT
5459: ELSIF p_rule_id=37 THEN
5460: IF NOT HZ_MATCH_RULE_37.check_staged THEN
5461: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5462: FND_MSG_PUB.ADD;
5463: RAISE FND_API.G_EXC_ERROR;
5464: END IF;

Line 5465: HZ_MATCH_RULE_37.get_matching_contact_points(

5461: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5462: FND_MSG_PUB.ADD;
5463: RAISE FND_API.G_EXC_ERROR;
5464: END IF;
5465: HZ_MATCH_RULE_37.get_matching_contact_points(
5466: p_rule_id, p_party_id, p_contact_point_list,
5467: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5468: -- Code for Match rule DL RELATIONSHIP DEFAULT
5469: ELSIF p_rule_id=38 THEN

Line 5892: IF NOT HZ_MATCH_RULE_37.check_staged THEN

5888: p_party_id, p_party_search_rec,p_party_site_list,
5889: p_contact_list, p_contact_point_list,x_search_ctx_id);
5890: -- Code for Match rule DL ADDRESS DEFAULT
5891: ELSIF p_rule_id=37 THEN
5892: IF NOT HZ_MATCH_RULE_37.check_staged THEN
5893: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5894: FND_MSG_PUB.ADD;
5895: RAISE FND_API.G_EXC_ERROR;
5896: END IF;

Line 5897: HZ_MATCH_RULE_37.get_score_details(

5893: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5894: FND_MSG_PUB.ADD;
5895: RAISE FND_API.G_EXC_ERROR;
5896: END IF;
5897: HZ_MATCH_RULE_37.get_score_details(
5898: p_rule_id,
5899: p_party_id, p_party_search_rec,p_party_site_list,
5900: p_contact_list, p_contact_point_list,x_search_ctx_id);
5901: -- Code for Match rule DL RELATIONSHIP DEFAULT

Line 6300: IF NOT HZ_MATCH_RULE_37.check_staged THEN

6296: p_party_id, x_party_search_rec,x_party_site_list,
6297: x_contact_list, x_contact_point_list);
6298: -- Code for Match rule DL ADDRESS DEFAULT
6299: ELSIF p_rule_id=37 THEN
6300: IF NOT HZ_MATCH_RULE_37.check_staged THEN
6301: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6302: FND_MSG_PUB.ADD;
6303: RAISE FND_API.G_EXC_ERROR;
6304: END IF;

Line 6305: HZ_MATCH_RULE_37.get_party_for_search(

6301: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6302: FND_MSG_PUB.ADD;
6303: RAISE FND_API.G_EXC_ERROR;
6304: END IF;
6305: HZ_MATCH_RULE_37.get_party_for_search(
6306: p_party_id, x_party_search_rec,x_party_site_list,
6307: x_contact_list, x_contact_point_list);
6308: -- Code for Match rule DL RELATIONSHIP DEFAULT
6309: ELSIF p_rule_id=38 THEN

Line 6692: IF NOT HZ_MATCH_RULE_37.check_staged THEN

6688: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6689: x_contact_list, x_contact_point_list);
6690: -- Code for Match rule DL ADDRESS DEFAULT
6691: ELSIF p_rule_id=37 THEN
6692: IF NOT HZ_MATCH_RULE_37.check_staged THEN
6693: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6694: FND_MSG_PUB.ADD;
6695: RAISE FND_API.G_EXC_ERROR;
6696: END IF;

Line 6697: HZ_MATCH_RULE_37.get_search_criteria(

6693: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6694: FND_MSG_PUB.ADD;
6695: RAISE FND_API.G_EXC_ERROR;
6696: END IF;
6697: HZ_MATCH_RULE_37.get_search_criteria(
6698: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6699: x_contact_list, x_contact_point_list);
6700: -- Code for Match rule DL RELATIONSHIP DEFAULT
6701: ELSIF p_rule_id=38 THEN