DBA Data[Home] [Help]

APPS.HZ_PARTY_SEARCH dependencies on HZ_MATCH_RULE_2

Line 110: IF NOT HZ_MATCH_RULE_2.check_staged THEN

106: RAISE FND_API.G_EXC_ERROR;
107: END IF;
108: -- Code for Match rule SAMPLE: ORGANIZATIONS_OPTIMIZED
109: IF p_rule_id=2 THEN
110: IF NOT HZ_MATCH_RULE_2.check_staged THEN
111: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
112: FND_MSG_PUB.ADD;
113: RAISE FND_API.G_EXC_ERROR;
114: END IF;

Line 115: HZ_MATCH_RULE_2.find_parties(

111: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
112: FND_MSG_PUB.ADD;
113: RAISE FND_API.G_EXC_ERROR;
114: END IF;
115: HZ_MATCH_RULE_2.find_parties(
116: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
117: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,NULL,NULL,NULL,'N',x_search_ctx_id,x_num_matches);
118: -- Code for Match rule SAMPLE: PERSON_OPTIMIZED
119: ELSIF p_rule_id=3 THEN

Line 491: IF NOT HZ_MATCH_RULE_2.check_staged THEN

487: RAISE FND_API.G_EXC_ERROR;
488: END IF;
489: -- Code for Match rule SAMPLE: ORGANIZATIONS_OPTIMIZED
490: IF p_rule_id=2 THEN
491: IF NOT HZ_MATCH_RULE_2.check_staged THEN
492: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
493: FND_MSG_PUB.ADD;
494: RAISE FND_API.G_EXC_ERROR;
495: END IF;

Line 496: HZ_MATCH_RULE_2.find_persons(

492: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
493: FND_MSG_PUB.ADD;
494: RAISE FND_API.G_EXC_ERROR;
495: END IF;
496: HZ_MATCH_RULE_2.find_persons(
497: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
498: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,'N',x_search_ctx_id,x_num_matches);
499: -- Code for Match rule SAMPLE: PERSON_OPTIMIZED
500: ELSIF p_rule_id=3 THEN

Line 890: IF NOT HZ_MATCH_RULE_2.check_staged THEN

886: RAISE FND_API.G_EXC_ERROR;
887: END IF;
888: -- Code for Match rule SAMPLE: ORGANIZATIONS_OPTIMIZED
889: IF p_rule_id=2 THEN
890: IF NOT HZ_MATCH_RULE_2.check_staged THEN
891: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
892: FND_MSG_PUB.ADD;
893: RAISE FND_API.G_EXC_ERROR;
894: END IF;

Line 895: HZ_MATCH_RULE_2.find_party_details(

891: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
892: FND_MSG_PUB.ADD;
893: RAISE FND_API.G_EXC_ERROR;
894: END IF;
895: HZ_MATCH_RULE_2.find_party_details(
896: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
897: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
898: -- Code for Match rule SAMPLE: PERSON_OPTIMIZED
899: ELSIF p_rule_id=3 THEN

Line 1270: IF NOT HZ_MATCH_RULE_2.check_staged THEN

1266: g_last_rule_valid := TRUE;
1267: END IF;
1268: -- Code for Match rule SAMPLE: ORGANIZATIONS_OPTIMIZED
1269: IF p_rule_id=2 THEN
1270: IF NOT HZ_MATCH_RULE_2.check_staged THEN
1271: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1272: FND_MSG_PUB.ADD;
1273: RAISE FND_API.G_EXC_ERROR;
1274: END IF;

Line 1275: HZ_MATCH_RULE_2.find_duplicate_parties(

1271: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1272: FND_MSG_PUB.ADD;
1273: RAISE FND_API.G_EXC_ERROR;
1274: END IF;
1275: HZ_MATCH_RULE_2.find_duplicate_parties(
1276: p_rule_id,p_party_id,
1277: p_restrict_sql,p_match_type,p_dup_batch_id,p_search_merged,x_dup_set_id, x_search_ctx_id,x_num_matches);
1278: -- Code for Match rule SAMPLE: PERSON_OPTIMIZED
1279: ELSIF p_rule_id=3 THEN

Line 1645: IF NOT HZ_MATCH_RULE_2.check_staged THEN

1641: RAISE FND_API.G_EXC_ERROR;
1642: END IF;
1643: -- Code for Match rule SAMPLE: ORGANIZATIONS_OPTIMIZED
1644: IF p_rule_id=2 THEN
1645: IF NOT HZ_MATCH_RULE_2.check_staged THEN
1646: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1647: FND_MSG_PUB.ADD;
1648: RAISE FND_API.G_EXC_ERROR;
1649: END IF;

Line 1650: HZ_MATCH_RULE_2.find_duplicate_party_sites(

1646: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1647: FND_MSG_PUB.ADD;
1648: RAISE FND_API.G_EXC_ERROR;
1649: END IF;
1650: HZ_MATCH_RULE_2.find_duplicate_party_sites(
1651: p_rule_id,p_party_site_id,p_party_id,
1652: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
1653: -- Code for Match rule SAMPLE: PERSON_OPTIMIZED
1654: ELSIF p_rule_id=3 THEN

Line 2019: IF NOT HZ_MATCH_RULE_2.check_staged THEN

2015: RAISE FND_API.G_EXC_ERROR;
2016: END IF;
2017: -- Code for Match rule SAMPLE: ORGANIZATIONS_OPTIMIZED
2018: IF p_rule_id=2 THEN
2019: IF NOT HZ_MATCH_RULE_2.check_staged THEN
2020: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2021: FND_MSG_PUB.ADD;
2022: RAISE FND_API.G_EXC_ERROR;
2023: END IF;

Line 2024: HZ_MATCH_RULE_2.find_duplicate_contacts(

2020: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2021: FND_MSG_PUB.ADD;
2022: RAISE FND_API.G_EXC_ERROR;
2023: END IF;
2024: HZ_MATCH_RULE_2.find_duplicate_contacts(
2025: p_rule_id,p_org_contact_id,p_party_id,
2026: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2027: -- Code for Match rule SAMPLE: PERSON_OPTIMIZED
2028: ELSIF p_rule_id=3 THEN

Line 2393: IF NOT HZ_MATCH_RULE_2.check_staged THEN

2389: RAISE FND_API.G_EXC_ERROR;
2390: END IF;
2391: -- Code for Match rule SAMPLE: ORGANIZATIONS_OPTIMIZED
2392: IF p_rule_id=2 THEN
2393: IF NOT HZ_MATCH_RULE_2.check_staged THEN
2394: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2395: FND_MSG_PUB.ADD;
2396: RAISE FND_API.G_EXC_ERROR;
2397: END IF;

Line 2398: HZ_MATCH_RULE_2.find_duplicate_contact_points(

2394: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2395: FND_MSG_PUB.ADD;
2396: RAISE FND_API.G_EXC_ERROR;
2397: END IF;
2398: HZ_MATCH_RULE_2.find_duplicate_contact_points(
2399: p_rule_id,p_contact_point_id,p_party_id,
2400: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2401: -- Code for Match rule SAMPLE: PERSON_OPTIMIZED
2402: ELSIF p_rule_id=3 THEN

Line 2807: IF NOT HZ_MATCH_RULE_2.check_staged THEN

2803: RAISE FND_API.G_EXC_ERROR;
2804: END IF;
2805: -- Code for Match rule SAMPLE: ORGANIZATIONS_OPTIMIZED
2806: IF p_rule_id=2 THEN
2807: IF NOT HZ_MATCH_RULE_2.check_staged THEN
2808: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2809: FND_MSG_PUB.ADD;
2810: RAISE FND_API.G_EXC_ERROR;
2811: END IF;

Line 2812: HZ_MATCH_RULE_2.find_parties_dynamic(

2808: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2809: FND_MSG_PUB.ADD;
2810: RAISE FND_API.G_EXC_ERROR;
2811: END IF;
2812: HZ_MATCH_RULE_2.find_parties_dynamic(
2813: p_rule_id,
2814: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
2815: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
2816: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 3454: IF NOT HZ_MATCH_RULE_2.check_staged THEN

3450: RAISE FND_API.G_EXC_ERROR;
3451: END IF;
3452: -- Code for Match rule SAMPLE: ORGANIZATIONS_OPTIMIZED
3453: IF p_rule_id=2 THEN
3454: IF NOT HZ_MATCH_RULE_2.check_staged THEN
3455: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3456: FND_MSG_PUB.ADD;
3457: RAISE FND_API.G_EXC_ERROR;
3458: END IF;

Line 3459: HZ_MATCH_RULE_2.call_api_dynamic(

3455: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3456: FND_MSG_PUB.ADD;
3457: RAISE FND_API.G_EXC_ERROR;
3458: END IF;
3459: HZ_MATCH_RULE_2.call_api_dynamic(
3460: p_rule_id,
3461: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
3462: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
3463: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 4292: IF NOT HZ_MATCH_RULE_2.check_staged THEN

4288: RAISE FND_API.G_EXC_ERROR;
4289: END IF;
4290: -- Code for Match rule SAMPLE: ORGANIZATIONS_OPTIMIZED
4291: IF p_rule_id=2 THEN
4292: IF NOT HZ_MATCH_RULE_2.check_staged THEN
4293: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4294: FND_MSG_PUB.ADD;
4295: RAISE FND_API.G_EXC_ERROR;
4296: END IF;

Line 4297: HZ_MATCH_RULE_2.get_matching_party_sites(

4293: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4294: FND_MSG_PUB.ADD;
4295: RAISE FND_API.G_EXC_ERROR;
4296: END IF;
4297: HZ_MATCH_RULE_2.get_matching_party_sites(
4298: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4299: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4300: -- Code for Match rule SAMPLE: PERSON_OPTIMIZED
4301: ELSIF p_rule_id=3 THEN

Line 4691: IF NOT HZ_MATCH_RULE_2.check_staged THEN

4687: RAISE FND_API.G_EXC_ERROR;
4688: END IF;
4689: -- Code for Match rule SAMPLE: ORGANIZATIONS_OPTIMIZED
4690: IF p_rule_id=2 THEN
4691: IF NOT HZ_MATCH_RULE_2.check_staged THEN
4692: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4693: FND_MSG_PUB.ADD;
4694: RAISE FND_API.G_EXC_ERROR;
4695: END IF;

Line 4696: HZ_MATCH_RULE_2.get_matching_contacts(

4692: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4693: FND_MSG_PUB.ADD;
4694: RAISE FND_API.G_EXC_ERROR;
4695: END IF;
4696: HZ_MATCH_RULE_2.get_matching_contacts(
4697: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
4698: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4699: -- Code for Match rule SAMPLE: PERSON_OPTIMIZED
4700: ELSIF p_rule_id=3 THEN

Line 5088: IF NOT HZ_MATCH_RULE_2.check_staged THEN

5084: RAISE FND_API.G_EXC_ERROR;
5085: END IF;
5086: -- Code for Match rule SAMPLE: ORGANIZATIONS_OPTIMIZED
5087: IF p_rule_id=2 THEN
5088: IF NOT HZ_MATCH_RULE_2.check_staged THEN
5089: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5090: FND_MSG_PUB.ADD;
5091: RAISE FND_API.G_EXC_ERROR;
5092: END IF;

Line 5093: HZ_MATCH_RULE_2.get_matching_contact_points(

5089: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5090: FND_MSG_PUB.ADD;
5091: RAISE FND_API.G_EXC_ERROR;
5092: END IF;
5093: HZ_MATCH_RULE_2.get_matching_contact_points(
5094: p_rule_id, p_party_id, p_contact_point_list,
5095: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5096: -- Code for Match rule SAMPLE: PERSON_OPTIMIZED
5097: ELSIF p_rule_id=3 THEN

Line 5488: IF NOT HZ_MATCH_RULE_2.check_staged THEN

5484: RAISE FND_API.G_EXC_ERROR;
5485: END IF;
5486: -- Code for Match rule SAMPLE: ORGANIZATIONS_OPTIMIZED
5487: IF p_rule_id=2 THEN
5488: IF NOT HZ_MATCH_RULE_2.check_staged THEN
5489: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5490: FND_MSG_PUB.ADD;
5491: RAISE FND_API.G_EXC_ERROR;
5492: END IF;

Line 5493: HZ_MATCH_RULE_2.get_score_details(

5489: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5490: FND_MSG_PUB.ADD;
5491: RAISE FND_API.G_EXC_ERROR;
5492: END IF;
5493: HZ_MATCH_RULE_2.get_score_details(
5494: p_rule_id,
5495: p_party_id, p_party_search_rec,p_party_site_list,
5496: p_contact_list, p_contact_point_list,x_search_ctx_id);
5497: -- Code for Match rule SAMPLE: PERSON_OPTIMIZED

Line 5886: IF NOT HZ_MATCH_RULE_2.check_staged THEN

5882: RAISE FND_API.G_EXC_ERROR;
5883: END IF;
5884: -- Code for Match rule SAMPLE: ORGANIZATIONS_OPTIMIZED
5885: IF p_rule_id=2 THEN
5886: IF NOT HZ_MATCH_RULE_2.check_staged THEN
5887: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5888: FND_MSG_PUB.ADD;
5889: RAISE FND_API.G_EXC_ERROR;
5890: END IF;

Line 5891: HZ_MATCH_RULE_2.get_party_for_search(

5887: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5888: FND_MSG_PUB.ADD;
5889: RAISE FND_API.G_EXC_ERROR;
5890: END IF;
5891: HZ_MATCH_RULE_2.get_party_for_search(
5892: p_party_id, x_party_search_rec,x_party_site_list,
5893: x_contact_list, x_contact_point_list);
5894: -- Code for Match rule SAMPLE: PERSON_OPTIMIZED
5895: ELSIF p_rule_id=3 THEN

Line 6258: IF NOT HZ_MATCH_RULE_2.check_staged THEN

6254: RAISE FND_API.G_EXC_ERROR;
6255: END IF;
6256: -- Code for Match rule SAMPLE: ORGANIZATIONS_OPTIMIZED
6257: IF p_rule_id=2 THEN
6258: IF NOT HZ_MATCH_RULE_2.check_staged THEN
6259: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6260: FND_MSG_PUB.ADD;
6261: RAISE FND_API.G_EXC_ERROR;
6262: END IF;

Line 6263: HZ_MATCH_RULE_2.get_search_criteria(

6259: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6260: FND_MSG_PUB.ADD;
6261: RAISE FND_API.G_EXC_ERROR;
6262: END IF;
6263: HZ_MATCH_RULE_2.get_search_criteria(
6264: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6265: x_contact_list, x_contact_point_list);
6266: -- Code for Match rule SAMPLE: PERSON_OPTIMIZED
6267: ELSIF p_rule_id=3 THEN