DBA Data[Home] [Help]

APPS.HZ_PARTY_SEARCH dependencies on HZ_MATCH_RULE_61

Line 360: IF NOT HZ_MATCH_RULE_61.check_staged THEN

356: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
357: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,NULL,NULL,NULL,'N',x_search_ctx_id,x_num_matches);
358: -- Code for Match rule HZ_ORG_SIMPLE_SEARCH_RULE
359: ELSIF p_rule_id=61 THEN
360: IF NOT HZ_MATCH_RULE_61.check_staged THEN
361: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
362: FND_MSG_PUB.ADD;
363: RAISE FND_API.G_EXC_ERROR;
364: END IF;

Line 365: HZ_MATCH_RULE_61.find_parties(

361: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
362: FND_MSG_PUB.ADD;
363: RAISE FND_API.G_EXC_ERROR;
364: END IF;
365: HZ_MATCH_RULE_61.find_parties(
366: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
367: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,NULL,NULL,NULL,'N',x_search_ctx_id,x_num_matches);
368: -- Code for Match rule HZ_ORG_ADV_SEARCH_RULE
369: ELSIF p_rule_id=62 THEN

Line 741: IF NOT HZ_MATCH_RULE_61.check_staged THEN

737: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
738: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,'N',x_search_ctx_id,x_num_matches);
739: -- Code for Match rule HZ_ORG_SIMPLE_SEARCH_RULE
740: ELSIF p_rule_id=61 THEN
741: IF NOT HZ_MATCH_RULE_61.check_staged THEN
742: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
743: FND_MSG_PUB.ADD;
744: RAISE FND_API.G_EXC_ERROR;
745: END IF;

Line 746: HZ_MATCH_RULE_61.find_persons(

742: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
743: FND_MSG_PUB.ADD;
744: RAISE FND_API.G_EXC_ERROR;
745: END IF;
746: HZ_MATCH_RULE_61.find_persons(
747: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
748: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,'N',x_search_ctx_id,x_num_matches);
749: -- Code for Match rule HZ_ORG_ADV_SEARCH_RULE
750: ELSIF p_rule_id=62 THEN

Line 1140: IF NOT HZ_MATCH_RULE_61.check_staged THEN

1136: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
1137: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
1138: -- Code for Match rule HZ_ORG_SIMPLE_SEARCH_RULE
1139: ELSIF p_rule_id=61 THEN
1140: IF NOT HZ_MATCH_RULE_61.check_staged THEN
1141: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1142: FND_MSG_PUB.ADD;
1143: RAISE FND_API.G_EXC_ERROR;
1144: END IF;

Line 1145: HZ_MATCH_RULE_61.find_party_details(

1141: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1142: FND_MSG_PUB.ADD;
1143: RAISE FND_API.G_EXC_ERROR;
1144: END IF;
1145: HZ_MATCH_RULE_61.find_party_details(
1146: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
1147: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
1148: -- Code for Match rule HZ_ORG_ADV_SEARCH_RULE
1149: ELSIF p_rule_id=62 THEN

Line 1520: IF NOT HZ_MATCH_RULE_61.check_staged THEN

1516: p_rule_id,p_party_id,
1517: p_restrict_sql,p_match_type,p_dup_batch_id,p_search_merged,x_dup_set_id, x_search_ctx_id,x_num_matches);
1518: -- Code for Match rule HZ_ORG_SIMPLE_SEARCH_RULE
1519: ELSIF p_rule_id=61 THEN
1520: IF NOT HZ_MATCH_RULE_61.check_staged THEN
1521: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1522: FND_MSG_PUB.ADD;
1523: RAISE FND_API.G_EXC_ERROR;
1524: END IF;

Line 1525: HZ_MATCH_RULE_61.find_duplicate_parties(

1521: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1522: FND_MSG_PUB.ADD;
1523: RAISE FND_API.G_EXC_ERROR;
1524: END IF;
1525: HZ_MATCH_RULE_61.find_duplicate_parties(
1526: p_rule_id,p_party_id,
1527: p_restrict_sql,p_match_type,p_dup_batch_id,p_search_merged,x_dup_set_id, x_search_ctx_id,x_num_matches);
1528: -- Code for Match rule HZ_ORG_ADV_SEARCH_RULE
1529: ELSIF p_rule_id=62 THEN

Line 1895: IF NOT HZ_MATCH_RULE_61.check_staged THEN

1891: p_rule_id,p_party_site_id,p_party_id,
1892: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
1893: -- Code for Match rule HZ_ORG_SIMPLE_SEARCH_RULE
1894: ELSIF p_rule_id=61 THEN
1895: IF NOT HZ_MATCH_RULE_61.check_staged THEN
1896: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1897: FND_MSG_PUB.ADD;
1898: RAISE FND_API.G_EXC_ERROR;
1899: END IF;

Line 1900: HZ_MATCH_RULE_61.find_duplicate_party_sites(

1896: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1897: FND_MSG_PUB.ADD;
1898: RAISE FND_API.G_EXC_ERROR;
1899: END IF;
1900: HZ_MATCH_RULE_61.find_duplicate_party_sites(
1901: p_rule_id,p_party_site_id,p_party_id,
1902: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
1903: -- Code for Match rule HZ_ORG_ADV_SEARCH_RULE
1904: ELSIF p_rule_id=62 THEN

Line 2269: IF NOT HZ_MATCH_RULE_61.check_staged THEN

2265: p_rule_id,p_org_contact_id,p_party_id,
2266: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2267: -- Code for Match rule HZ_ORG_SIMPLE_SEARCH_RULE
2268: ELSIF p_rule_id=61 THEN
2269: IF NOT HZ_MATCH_RULE_61.check_staged THEN
2270: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2271: FND_MSG_PUB.ADD;
2272: RAISE FND_API.G_EXC_ERROR;
2273: END IF;

Line 2274: HZ_MATCH_RULE_61.find_duplicate_contacts(

2270: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2271: FND_MSG_PUB.ADD;
2272: RAISE FND_API.G_EXC_ERROR;
2273: END IF;
2274: HZ_MATCH_RULE_61.find_duplicate_contacts(
2275: p_rule_id,p_org_contact_id,p_party_id,
2276: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2277: -- Code for Match rule HZ_ORG_ADV_SEARCH_RULE
2278: ELSIF p_rule_id=62 THEN

Line 2643: IF NOT HZ_MATCH_RULE_61.check_staged THEN

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 HZ_ORG_SIMPLE_SEARCH_RULE
2642: ELSIF p_rule_id=61 THEN
2643: IF NOT HZ_MATCH_RULE_61.check_staged THEN
2644: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2645: FND_MSG_PUB.ADD;
2646: RAISE FND_API.G_EXC_ERROR;
2647: END IF;

Line 2648: HZ_MATCH_RULE_61.find_duplicate_contact_points(

2644: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2645: FND_MSG_PUB.ADD;
2646: RAISE FND_API.G_EXC_ERROR;
2647: END IF;
2648: HZ_MATCH_RULE_61.find_duplicate_contact_points(
2649: p_rule_id,p_contact_point_id,p_party_id,
2650: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2651: -- Code for Match rule HZ_ORG_ADV_SEARCH_RULE
2652: ELSIF p_rule_id=62 THEN

Line 3257: IF NOT HZ_MATCH_RULE_61.check_staged THEN

3253: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3254: p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
3255: -- Code for Match rule HZ_ORG_SIMPLE_SEARCH_RULE
3256: ELSIF p_rule_id=61 THEN
3257: IF NOT HZ_MATCH_RULE_61.check_staged THEN
3258: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3259: FND_MSG_PUB.ADD;
3260: RAISE FND_API.G_EXC_ERROR;
3261: END IF;

Line 3262: HZ_MATCH_RULE_61.find_parties_dynamic(

3258: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3259: FND_MSG_PUB.ADD;
3260: RAISE FND_API.G_EXC_ERROR;
3261: END IF;
3262: HZ_MATCH_RULE_61.find_parties_dynamic(
3263: p_rule_id,
3264: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
3265: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
3266: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 3904: IF NOT HZ_MATCH_RULE_61.check_staged THEN

3900: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3901: p_restrict_sql,p_api_name,p_match_type,p_party_id,p_search_merged,x_search_ctx_id,x_num_matches);
3902: -- Code for Match rule HZ_ORG_SIMPLE_SEARCH_RULE
3903: ELSIF p_rule_id=61 THEN
3904: IF NOT HZ_MATCH_RULE_61.check_staged THEN
3905: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3906: FND_MSG_PUB.ADD;
3907: RAISE FND_API.G_EXC_ERROR;
3908: END IF;

Line 3909: HZ_MATCH_RULE_61.call_api_dynamic(

3905: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3906: FND_MSG_PUB.ADD;
3907: RAISE FND_API.G_EXC_ERROR;
3908: END IF;
3909: HZ_MATCH_RULE_61.call_api_dynamic(
3910: p_rule_id,
3911: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
3912: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
3913: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 4542: IF NOT HZ_MATCH_RULE_61.check_staged THEN

4538: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4539: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4540: -- Code for Match rule HZ_ORG_SIMPLE_SEARCH_RULE
4541: ELSIF p_rule_id=61 THEN
4542: IF NOT HZ_MATCH_RULE_61.check_staged THEN
4543: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4544: FND_MSG_PUB.ADD;
4545: RAISE FND_API.G_EXC_ERROR;
4546: END IF;

Line 4547: HZ_MATCH_RULE_61.get_matching_party_sites(

4543: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4544: FND_MSG_PUB.ADD;
4545: RAISE FND_API.G_EXC_ERROR;
4546: END IF;
4547: HZ_MATCH_RULE_61.get_matching_party_sites(
4548: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4549: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4550: -- Code for Match rule HZ_ORG_ADV_SEARCH_RULE
4551: ELSIF p_rule_id=62 THEN

Line 4941: IF NOT HZ_MATCH_RULE_61.check_staged THEN

4937: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
4938: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4939: -- Code for Match rule HZ_ORG_SIMPLE_SEARCH_RULE
4940: ELSIF p_rule_id=61 THEN
4941: IF NOT HZ_MATCH_RULE_61.check_staged THEN
4942: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4943: FND_MSG_PUB.ADD;
4944: RAISE FND_API.G_EXC_ERROR;
4945: END IF;

Line 4946: HZ_MATCH_RULE_61.get_matching_contacts(

4942: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4943: FND_MSG_PUB.ADD;
4944: RAISE FND_API.G_EXC_ERROR;
4945: END IF;
4946: HZ_MATCH_RULE_61.get_matching_contacts(
4947: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
4948: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4949: -- Code for Match rule HZ_ORG_ADV_SEARCH_RULE
4950: ELSIF p_rule_id=62 THEN

Line 5338: IF NOT HZ_MATCH_RULE_61.check_staged THEN

5334: p_rule_id, p_party_id, p_contact_point_list,
5335: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5336: -- Code for Match rule HZ_ORG_SIMPLE_SEARCH_RULE
5337: ELSIF p_rule_id=61 THEN
5338: IF NOT HZ_MATCH_RULE_61.check_staged THEN
5339: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5340: FND_MSG_PUB.ADD;
5341: RAISE FND_API.G_EXC_ERROR;
5342: END IF;

Line 5343: HZ_MATCH_RULE_61.get_matching_contact_points(

5339: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5340: FND_MSG_PUB.ADD;
5341: RAISE FND_API.G_EXC_ERROR;
5342: END IF;
5343: HZ_MATCH_RULE_61.get_matching_contact_points(
5344: p_rule_id, p_party_id, p_contact_point_list,
5345: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5346: -- Code for Match rule HZ_ORG_ADV_SEARCH_RULE
5347: ELSIF p_rule_id=62 THEN

Line 5763: IF NOT HZ_MATCH_RULE_61.check_staged THEN

5759: p_party_id, p_party_search_rec,p_party_site_list,
5760: p_contact_list, p_contact_point_list,x_search_ctx_id);
5761: -- Code for Match rule HZ_ORG_SIMPLE_SEARCH_RULE
5762: ELSIF p_rule_id=61 THEN
5763: IF NOT HZ_MATCH_RULE_61.check_staged THEN
5764: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5765: FND_MSG_PUB.ADD;
5766: RAISE FND_API.G_EXC_ERROR;
5767: END IF;

Line 5768: HZ_MATCH_RULE_61.get_score_details(

5764: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5765: FND_MSG_PUB.ADD;
5766: RAISE FND_API.G_EXC_ERROR;
5767: END IF;
5768: HZ_MATCH_RULE_61.get_score_details(
5769: p_rule_id,
5770: p_party_id, p_party_search_rec,p_party_site_list,
5771: p_contact_list, p_contact_point_list,x_search_ctx_id);
5772: -- Code for Match rule HZ_ORG_ADV_SEARCH_RULE

Line 6136: IF NOT HZ_MATCH_RULE_61.check_staged THEN

6132: p_party_id, x_party_search_rec,x_party_site_list,
6133: x_contact_list, x_contact_point_list);
6134: -- Code for Match rule HZ_ORG_SIMPLE_SEARCH_RULE
6135: ELSIF p_rule_id=61 THEN
6136: IF NOT HZ_MATCH_RULE_61.check_staged THEN
6137: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6138: FND_MSG_PUB.ADD;
6139: RAISE FND_API.G_EXC_ERROR;
6140: END IF;

Line 6141: HZ_MATCH_RULE_61.get_party_for_search(

6137: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6138: FND_MSG_PUB.ADD;
6139: RAISE FND_API.G_EXC_ERROR;
6140: END IF;
6141: HZ_MATCH_RULE_61.get_party_for_search(
6142: p_party_id, x_party_search_rec,x_party_site_list,
6143: x_contact_list, x_contact_point_list);
6144: -- Code for Match rule HZ_ORG_ADV_SEARCH_RULE
6145: ELSIF p_rule_id=62 THEN

Line 6508: IF NOT HZ_MATCH_RULE_61.check_staged THEN

6504: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6505: x_contact_list, x_contact_point_list);
6506: -- Code for Match rule HZ_ORG_SIMPLE_SEARCH_RULE
6507: ELSIF p_rule_id=61 THEN
6508: IF NOT HZ_MATCH_RULE_61.check_staged THEN
6509: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6510: FND_MSG_PUB.ADD;
6511: RAISE FND_API.G_EXC_ERROR;
6512: END IF;

Line 6513: HZ_MATCH_RULE_61.get_search_criteria(

6509: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6510: FND_MSG_PUB.ADD;
6511: RAISE FND_API.G_EXC_ERROR;
6512: END IF;
6513: HZ_MATCH_RULE_61.get_search_criteria(
6514: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6515: x_contact_list, x_contact_point_list);
6516: -- Code for Match rule HZ_ORG_ADV_SEARCH_RULE
6517: ELSIF p_rule_id=62 THEN