DBA Data[Home] [Help]

APPS.HZ_PARTY_SEARCH dependencies on HZ_MATCH_RULE_42

Line 280: IF NOT HZ_MATCH_RULE_42.check_staged THEN

276: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
277: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,NULL,NULL,NULL,'N',x_search_ctx_id,x_num_matches);
278: -- Code for Match rule SAMPLE: SEARCH EXACT
279: ELSIF p_rule_id=42 THEN
280: IF NOT HZ_MATCH_RULE_42.check_staged THEN
281: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
282: FND_MSG_PUB.ADD;
283: RAISE FND_API.G_EXC_ERROR;
284: END IF;

Line 285: HZ_MATCH_RULE_42.find_parties(

281: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
282: FND_MSG_PUB.ADD;
283: RAISE FND_API.G_EXC_ERROR;
284: END IF;
285: HZ_MATCH_RULE_42.find_parties(
286: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
287: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,NULL,NULL,NULL,'N',x_search_ctx_id,x_num_matches);
288: -- Code for Match rule DL SYSTEM DUPLICATE IDENTIFICATION
289: ELSIF p_rule_id=48 THEN

Line 681: IF NOT HZ_MATCH_RULE_42.check_staged THEN

677: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
678: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,'N',x_search_ctx_id,x_num_matches);
679: -- Code for Match rule SAMPLE: SEARCH EXACT
680: ELSIF p_rule_id=42 THEN
681: IF NOT HZ_MATCH_RULE_42.check_staged THEN
682: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
683: FND_MSG_PUB.ADD;
684: RAISE FND_API.G_EXC_ERROR;
685: END IF;

Line 686: HZ_MATCH_RULE_42.find_persons(

682: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
683: FND_MSG_PUB.ADD;
684: RAISE FND_API.G_EXC_ERROR;
685: END IF;
686: HZ_MATCH_RULE_42.find_persons(
687: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
688: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,'N',x_search_ctx_id,x_num_matches);
689: -- Code for Match rule DL SYSTEM DUPLICATE IDENTIFICATION
690: ELSIF p_rule_id=48 THEN

Line 1100: IF NOT HZ_MATCH_RULE_42.check_staged THEN

1096: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
1097: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
1098: -- Code for Match rule SAMPLE: SEARCH EXACT
1099: ELSIF p_rule_id=42 THEN
1100: IF NOT HZ_MATCH_RULE_42.check_staged THEN
1101: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1102: FND_MSG_PUB.ADD;
1103: RAISE FND_API.G_EXC_ERROR;
1104: END IF;

Line 1105: HZ_MATCH_RULE_42.find_party_details(

1101: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1102: FND_MSG_PUB.ADD;
1103: RAISE FND_API.G_EXC_ERROR;
1104: END IF;
1105: HZ_MATCH_RULE_42.find_party_details(
1106: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
1107: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
1108: -- Code for Match rule DL SYSTEM DUPLICATE IDENTIFICATION
1109: ELSIF p_rule_id=48 THEN

Line 1500: IF NOT HZ_MATCH_RULE_42.check_staged THEN

1496: p_rule_id,p_party_id,
1497: p_restrict_sql,p_match_type,p_dup_batch_id,p_search_merged,x_dup_set_id, x_search_ctx_id,x_num_matches);
1498: -- Code for Match rule SAMPLE: SEARCH EXACT
1499: ELSIF p_rule_id=42 THEN
1500: IF NOT HZ_MATCH_RULE_42.check_staged THEN
1501: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1502: FND_MSG_PUB.ADD;
1503: RAISE FND_API.G_EXC_ERROR;
1504: END IF;

Line 1505: HZ_MATCH_RULE_42.find_duplicate_parties(

1501: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1502: FND_MSG_PUB.ADD;
1503: RAISE FND_API.G_EXC_ERROR;
1504: END IF;
1505: HZ_MATCH_RULE_42.find_duplicate_parties(
1506: p_rule_id,p_party_id,
1507: p_restrict_sql,p_match_type,p_dup_batch_id,p_search_merged,x_dup_set_id, x_search_ctx_id,x_num_matches);
1508: -- Code for Match rule DL SYSTEM DUPLICATE IDENTIFICATION
1509: ELSIF p_rule_id=48 THEN

Line 1895: IF NOT HZ_MATCH_RULE_42.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 SAMPLE: SEARCH EXACT
1894: ELSIF p_rule_id=42 THEN
1895: IF NOT HZ_MATCH_RULE_42.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_42.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_42.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 DL SYSTEM DUPLICATE IDENTIFICATION
1904: ELSIF p_rule_id=48 THEN

Line 2289: IF NOT HZ_MATCH_RULE_42.check_staged THEN

2285: p_rule_id,p_org_contact_id,p_party_id,
2286: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2287: -- Code for Match rule SAMPLE: SEARCH EXACT
2288: ELSIF p_rule_id=42 THEN
2289: IF NOT HZ_MATCH_RULE_42.check_staged THEN
2290: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2291: FND_MSG_PUB.ADD;
2292: RAISE FND_API.G_EXC_ERROR;
2293: END IF;

Line 2294: HZ_MATCH_RULE_42.find_duplicate_contacts(

2290: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2291: FND_MSG_PUB.ADD;
2292: RAISE FND_API.G_EXC_ERROR;
2293: END IF;
2294: HZ_MATCH_RULE_42.find_duplicate_contacts(
2295: p_rule_id,p_org_contact_id,p_party_id,
2296: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2297: -- Code for Match rule DL SYSTEM DUPLICATE IDENTIFICATION
2298: ELSIF p_rule_id=48 THEN

Line 2683: IF NOT HZ_MATCH_RULE_42.check_staged THEN

2679: p_rule_id,p_contact_point_id,p_party_id,
2680: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2681: -- Code for Match rule SAMPLE: SEARCH EXACT
2682: ELSIF p_rule_id=42 THEN
2683: IF NOT HZ_MATCH_RULE_42.check_staged THEN
2684: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2685: FND_MSG_PUB.ADD;
2686: RAISE FND_API.G_EXC_ERROR;
2687: END IF;

Line 2688: HZ_MATCH_RULE_42.find_duplicate_contact_points(

2684: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2685: FND_MSG_PUB.ADD;
2686: RAISE FND_API.G_EXC_ERROR;
2687: END IF;
2688: HZ_MATCH_RULE_42.find_duplicate_contact_points(
2689: p_rule_id,p_contact_point_id,p_party_id,
2690: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2691: -- Code for Match rule DL SYSTEM DUPLICATE IDENTIFICATION
2692: ELSIF p_rule_id=48 THEN

Line 3253: IF NOT HZ_MATCH_RULE_42.check_staged THEN

3249: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3250: p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
3251: -- Code for Match rule SAMPLE: SEARCH EXACT
3252: ELSIF p_rule_id=42 THEN
3253: IF NOT HZ_MATCH_RULE_42.check_staged THEN
3254: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3255: FND_MSG_PUB.ADD;
3256: RAISE FND_API.G_EXC_ERROR;
3257: END IF;

Line 3258: HZ_MATCH_RULE_42.find_parties_dynamic(

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

Line 3936: IF NOT HZ_MATCH_RULE_42.check_staged THEN

3932: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3933: p_restrict_sql,p_api_name,p_match_type,p_party_id,p_search_merged,x_search_ctx_id,x_num_matches);
3934: -- Code for Match rule SAMPLE: SEARCH EXACT
3935: ELSIF p_rule_id=42 THEN
3936: IF NOT HZ_MATCH_RULE_42.check_staged THEN
3937: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3938: FND_MSG_PUB.ADD;
3939: RAISE FND_API.G_EXC_ERROR;
3940: END IF;

Line 3941: HZ_MATCH_RULE_42.call_api_dynamic(

3937: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3938: FND_MSG_PUB.ADD;
3939: RAISE FND_API.G_EXC_ERROR;
3940: END IF;
3941: HZ_MATCH_RULE_42.call_api_dynamic(
3942: p_rule_id,
3943: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
3944: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
3945: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 4674: IF NOT HZ_MATCH_RULE_42.check_staged THEN

4670: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4671: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4672: -- Code for Match rule SAMPLE: SEARCH EXACT
4673: ELSIF p_rule_id=42 THEN
4674: IF NOT HZ_MATCH_RULE_42.check_staged THEN
4675: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4676: FND_MSG_PUB.ADD;
4677: RAISE FND_API.G_EXC_ERROR;
4678: END IF;

Line 4679: HZ_MATCH_RULE_42.get_matching_party_sites(

4675: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4676: FND_MSG_PUB.ADD;
4677: RAISE FND_API.G_EXC_ERROR;
4678: END IF;
4679: HZ_MATCH_RULE_42.get_matching_party_sites(
4680: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4681: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4682: -- Code for Match rule DL SYSTEM DUPLICATE IDENTIFICATION
4683: ELSIF p_rule_id=48 THEN

Line 5093: IF NOT HZ_MATCH_RULE_42.check_staged THEN

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

Line 5098: HZ_MATCH_RULE_42.get_matching_contacts(

5094: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5095: FND_MSG_PUB.ADD;
5096: RAISE FND_API.G_EXC_ERROR;
5097: END IF;
5098: HZ_MATCH_RULE_42.get_matching_contacts(
5099: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
5100: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5101: -- Code for Match rule DL SYSTEM DUPLICATE IDENTIFICATION
5102: ELSIF p_rule_id=48 THEN

Line 5510: IF NOT HZ_MATCH_RULE_42.check_staged THEN

5506: p_rule_id, p_party_id, p_contact_point_list,
5507: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5508: -- Code for Match rule SAMPLE: SEARCH EXACT
5509: ELSIF p_rule_id=42 THEN
5510: IF NOT HZ_MATCH_RULE_42.check_staged THEN
5511: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5512: FND_MSG_PUB.ADD;
5513: RAISE FND_API.G_EXC_ERROR;
5514: END IF;

Line 5515: HZ_MATCH_RULE_42.get_matching_contact_points(

5511: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5512: FND_MSG_PUB.ADD;
5513: RAISE FND_API.G_EXC_ERROR;
5514: END IF;
5515: HZ_MATCH_RULE_42.get_matching_contact_points(
5516: p_rule_id, p_party_id, p_contact_point_list,
5517: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5518: -- Code for Match rule DL SYSTEM DUPLICATE IDENTIFICATION
5519: ELSIF p_rule_id=48 THEN

Line 5947: IF NOT HZ_MATCH_RULE_42.check_staged THEN

5943: p_party_id, p_party_search_rec,p_party_site_list,
5944: p_contact_list, p_contact_point_list,x_search_ctx_id);
5945: -- Code for Match rule SAMPLE: SEARCH EXACT
5946: ELSIF p_rule_id=42 THEN
5947: IF NOT HZ_MATCH_RULE_42.check_staged THEN
5948: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5949: FND_MSG_PUB.ADD;
5950: RAISE FND_API.G_EXC_ERROR;
5951: END IF;

Line 5952: HZ_MATCH_RULE_42.get_score_details(

5948: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5949: FND_MSG_PUB.ADD;
5950: RAISE FND_API.G_EXC_ERROR;
5951: END IF;
5952: HZ_MATCH_RULE_42.get_score_details(
5953: p_rule_id,
5954: p_party_id, p_party_search_rec,p_party_site_list,
5955: p_contact_list, p_contact_point_list,x_search_ctx_id);
5956: -- Code for Match rule DL SYSTEM DUPLICATE IDENTIFICATION

Line 6350: IF NOT HZ_MATCH_RULE_42.check_staged THEN

6346: p_party_id, x_party_search_rec,x_party_site_list,
6347: x_contact_list, x_contact_point_list);
6348: -- Code for Match rule SAMPLE: SEARCH EXACT
6349: ELSIF p_rule_id=42 THEN
6350: IF NOT HZ_MATCH_RULE_42.check_staged THEN
6351: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6352: FND_MSG_PUB.ADD;
6353: RAISE FND_API.G_EXC_ERROR;
6354: END IF;

Line 6355: HZ_MATCH_RULE_42.get_party_for_search(

6351: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6352: FND_MSG_PUB.ADD;
6353: RAISE FND_API.G_EXC_ERROR;
6354: END IF;
6355: HZ_MATCH_RULE_42.get_party_for_search(
6356: p_party_id, x_party_search_rec,x_party_site_list,
6357: x_contact_list, x_contact_point_list);
6358: -- Code for Match rule DL SYSTEM DUPLICATE IDENTIFICATION
6359: ELSIF p_rule_id=48 THEN

Line 6742: IF NOT HZ_MATCH_RULE_42.check_staged THEN

6738: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6739: x_contact_list, x_contact_point_list);
6740: -- Code for Match rule SAMPLE: SEARCH EXACT
6741: ELSIF p_rule_id=42 THEN
6742: IF NOT HZ_MATCH_RULE_42.check_staged THEN
6743: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6744: FND_MSG_PUB.ADD;
6745: RAISE FND_API.G_EXC_ERROR;
6746: END IF;

Line 6747: HZ_MATCH_RULE_42.get_search_criteria(

6743: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6744: FND_MSG_PUB.ADD;
6745: RAISE FND_API.G_EXC_ERROR;
6746: END IF;
6747: HZ_MATCH_RULE_42.get_search_criteria(
6748: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6749: x_contact_list, x_contact_point_list);
6750: -- Code for Match rule DL SYSTEM DUPLICATE IDENTIFICATION
6751: ELSIF p_rule_id=48 THEN