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 661: IF NOT HZ_MATCH_RULE_42.check_staged THEN

657: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
658: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,'N',x_search_ctx_id,x_num_matches);
659: -- Code for Match rule SAMPLE: SEARCH EXACT
660: ELSIF p_rule_id=42 THEN
661: IF NOT HZ_MATCH_RULE_42.check_staged THEN
662: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
663: FND_MSG_PUB.ADD;
664: RAISE FND_API.G_EXC_ERROR;
665: END IF;

Line 666: HZ_MATCH_RULE_42.find_persons(

662: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
663: FND_MSG_PUB.ADD;
664: RAISE FND_API.G_EXC_ERROR;
665: END IF;
666: HZ_MATCH_RULE_42.find_persons(
667: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
668: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,'N',x_search_ctx_id,x_num_matches);
669: -- Code for Match rule DL SYSTEM DUPLICATE IDENTIFICATION
670: ELSIF p_rule_id=48 THEN

Line 1060: IF NOT HZ_MATCH_RULE_42.check_staged THEN

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 SAMPLE: SEARCH EXACT
1059: ELSIF p_rule_id=42 THEN
1060: IF NOT HZ_MATCH_RULE_42.check_staged THEN
1061: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1062: FND_MSG_PUB.ADD;
1063: RAISE FND_API.G_EXC_ERROR;
1064: END IF;

Line 1065: HZ_MATCH_RULE_42.find_party_details(

1061: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1062: FND_MSG_PUB.ADD;
1063: RAISE FND_API.G_EXC_ERROR;
1064: END IF;
1065: HZ_MATCH_RULE_42.find_party_details(
1066: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
1067: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
1068: -- Code for Match rule DL SYSTEM DUPLICATE IDENTIFICATION
1069: ELSIF p_rule_id=48 THEN

Line 1440: IF NOT HZ_MATCH_RULE_42.check_staged THEN

1436: p_rule_id,p_party_id,
1437: p_restrict_sql,p_match_type,p_dup_batch_id,p_search_merged,x_dup_set_id, x_search_ctx_id,x_num_matches);
1438: -- Code for Match rule SAMPLE: SEARCH EXACT
1439: ELSIF p_rule_id=42 THEN
1440: IF NOT HZ_MATCH_RULE_42.check_staged THEN
1441: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1442: FND_MSG_PUB.ADD;
1443: RAISE FND_API.G_EXC_ERROR;
1444: END IF;

Line 1445: HZ_MATCH_RULE_42.find_duplicate_parties(

1441: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1442: FND_MSG_PUB.ADD;
1443: RAISE FND_API.G_EXC_ERROR;
1444: END IF;
1445: HZ_MATCH_RULE_42.find_duplicate_parties(
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 SYSTEM DUPLICATE IDENTIFICATION
1449: ELSIF p_rule_id=48 THEN

Line 1815: IF NOT HZ_MATCH_RULE_42.check_staged THEN

1811: p_rule_id,p_party_site_id,p_party_id,
1812: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
1813: -- Code for Match rule SAMPLE: SEARCH EXACT
1814: ELSIF p_rule_id=42 THEN
1815: IF NOT HZ_MATCH_RULE_42.check_staged THEN
1816: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1817: FND_MSG_PUB.ADD;
1818: RAISE FND_API.G_EXC_ERROR;
1819: END IF;

Line 1820: HZ_MATCH_RULE_42.find_duplicate_party_sites(

1816: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1817: FND_MSG_PUB.ADD;
1818: RAISE FND_API.G_EXC_ERROR;
1819: END IF;
1820: HZ_MATCH_RULE_42.find_duplicate_party_sites(
1821: p_rule_id,p_party_site_id,p_party_id,
1822: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
1823: -- Code for Match rule DL SYSTEM DUPLICATE IDENTIFICATION
1824: ELSIF p_rule_id=48 THEN

Line 2189: IF NOT HZ_MATCH_RULE_42.check_staged THEN

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 SAMPLE: SEARCH EXACT
2188: ELSIF p_rule_id=42 THEN
2189: IF NOT HZ_MATCH_RULE_42.check_staged THEN
2190: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2191: FND_MSG_PUB.ADD;
2192: RAISE FND_API.G_EXC_ERROR;
2193: END IF;

Line 2194: HZ_MATCH_RULE_42.find_duplicate_contacts(

2190: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2191: FND_MSG_PUB.ADD;
2192: RAISE FND_API.G_EXC_ERROR;
2193: END IF;
2194: HZ_MATCH_RULE_42.find_duplicate_contacts(
2195: p_rule_id,p_org_contact_id,p_party_id,
2196: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2197: -- Code for Match rule DL SYSTEM DUPLICATE IDENTIFICATION
2198: ELSIF p_rule_id=48 THEN

Line 2563: IF NOT HZ_MATCH_RULE_42.check_staged THEN

2559: p_rule_id,p_contact_point_id,p_party_id,
2560: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2561: -- Code for Match rule SAMPLE: SEARCH EXACT
2562: ELSIF p_rule_id=42 THEN
2563: IF NOT HZ_MATCH_RULE_42.check_staged THEN
2564: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2565: FND_MSG_PUB.ADD;
2566: RAISE FND_API.G_EXC_ERROR;
2567: END IF;

Line 2568: HZ_MATCH_RULE_42.find_duplicate_contact_points(

2564: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2565: FND_MSG_PUB.ADD;
2566: RAISE FND_API.G_EXC_ERROR;
2567: END IF;
2568: HZ_MATCH_RULE_42.find_duplicate_contact_points(
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 DL SYSTEM DUPLICATE IDENTIFICATION
2572: ELSIF p_rule_id=48 THEN

Line 3113: IF NOT HZ_MATCH_RULE_42.check_staged THEN

3109: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3110: p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
3111: -- Code for Match rule SAMPLE: SEARCH EXACT
3112: ELSIF p_rule_id=42 THEN
3113: IF NOT HZ_MATCH_RULE_42.check_staged THEN
3114: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3115: FND_MSG_PUB.ADD;
3116: RAISE FND_API.G_EXC_ERROR;
3117: END IF;

Line 3118: HZ_MATCH_RULE_42.find_parties_dynamic(

3114: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3115: FND_MSG_PUB.ADD;
3116: RAISE FND_API.G_EXC_ERROR;
3117: END IF;
3118: HZ_MATCH_RULE_42.find_parties_dynamic(
3119: p_rule_id,
3120: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
3121: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
3122: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 3760: IF NOT HZ_MATCH_RULE_42.check_staged THEN

3756: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3757: p_restrict_sql,p_api_name,p_match_type,p_party_id,p_search_merged,x_search_ctx_id,x_num_matches);
3758: -- Code for Match rule SAMPLE: SEARCH EXACT
3759: ELSIF p_rule_id=42 THEN
3760: IF NOT HZ_MATCH_RULE_42.check_staged THEN
3761: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3762: FND_MSG_PUB.ADD;
3763: RAISE FND_API.G_EXC_ERROR;
3764: END IF;

Line 3765: HZ_MATCH_RULE_42.call_api_dynamic(

3761: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3762: FND_MSG_PUB.ADD;
3763: RAISE FND_API.G_EXC_ERROR;
3764: END IF;
3765: HZ_MATCH_RULE_42.call_api_dynamic(
3766: p_rule_id,
3767: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
3768: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
3769: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 4462: IF NOT HZ_MATCH_RULE_42.check_staged THEN

4458: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4459: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4460: -- Code for Match rule SAMPLE: SEARCH EXACT
4461: ELSIF p_rule_id=42 THEN
4462: IF NOT HZ_MATCH_RULE_42.check_staged THEN
4463: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4464: FND_MSG_PUB.ADD;
4465: RAISE FND_API.G_EXC_ERROR;
4466: END IF;

Line 4467: HZ_MATCH_RULE_42.get_matching_party_sites(

4463: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4464: FND_MSG_PUB.ADD;
4465: RAISE FND_API.G_EXC_ERROR;
4466: END IF;
4467: HZ_MATCH_RULE_42.get_matching_party_sites(
4468: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4469: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4470: -- Code for Match rule DL SYSTEM DUPLICATE IDENTIFICATION
4471: ELSIF p_rule_id=48 THEN

Line 4861: IF NOT HZ_MATCH_RULE_42.check_staged THEN

4857: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
4858: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4859: -- Code for Match rule SAMPLE: SEARCH EXACT
4860: ELSIF p_rule_id=42 THEN
4861: IF NOT HZ_MATCH_RULE_42.check_staged THEN
4862: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4863: FND_MSG_PUB.ADD;
4864: RAISE FND_API.G_EXC_ERROR;
4865: END IF;

Line 4866: HZ_MATCH_RULE_42.get_matching_contacts(

4862: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4863: FND_MSG_PUB.ADD;
4864: RAISE FND_API.G_EXC_ERROR;
4865: END IF;
4866: HZ_MATCH_RULE_42.get_matching_contacts(
4867: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
4868: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4869: -- Code for Match rule DL SYSTEM DUPLICATE IDENTIFICATION
4870: ELSIF p_rule_id=48 THEN

Line 5258: IF NOT HZ_MATCH_RULE_42.check_staged THEN

5254: p_rule_id, p_party_id, p_contact_point_list,
5255: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5256: -- Code for Match rule SAMPLE: SEARCH EXACT
5257: ELSIF p_rule_id=42 THEN
5258: IF NOT HZ_MATCH_RULE_42.check_staged THEN
5259: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5260: FND_MSG_PUB.ADD;
5261: RAISE FND_API.G_EXC_ERROR;
5262: END IF;

Line 5263: HZ_MATCH_RULE_42.get_matching_contact_points(

5259: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5260: FND_MSG_PUB.ADD;
5261: RAISE FND_API.G_EXC_ERROR;
5262: END IF;
5263: HZ_MATCH_RULE_42.get_matching_contact_points(
5264: p_rule_id, p_party_id, p_contact_point_list,
5265: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5266: -- Code for Match rule DL SYSTEM DUPLICATE IDENTIFICATION
5267: ELSIF p_rule_id=48 THEN

Line 5675: IF NOT HZ_MATCH_RULE_42.check_staged THEN

5671: p_party_id, p_party_search_rec,p_party_site_list,
5672: p_contact_list, p_contact_point_list,x_search_ctx_id);
5673: -- Code for Match rule SAMPLE: SEARCH EXACT
5674: ELSIF p_rule_id=42 THEN
5675: IF NOT HZ_MATCH_RULE_42.check_staged THEN
5676: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5677: FND_MSG_PUB.ADD;
5678: RAISE FND_API.G_EXC_ERROR;
5679: END IF;

Line 5680: HZ_MATCH_RULE_42.get_score_details(

5676: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5677: FND_MSG_PUB.ADD;
5678: RAISE FND_API.G_EXC_ERROR;
5679: END IF;
5680: HZ_MATCH_RULE_42.get_score_details(
5681: p_rule_id,
5682: p_party_id, p_party_search_rec,p_party_site_list,
5683: p_contact_list, p_contact_point_list,x_search_ctx_id);
5684: -- Code for Match rule DL SYSTEM DUPLICATE IDENTIFICATION

Line 6056: IF NOT HZ_MATCH_RULE_42.check_staged THEN

6052: p_party_id, x_party_search_rec,x_party_site_list,
6053: x_contact_list, x_contact_point_list);
6054: -- Code for Match rule SAMPLE: SEARCH EXACT
6055: ELSIF p_rule_id=42 THEN
6056: IF NOT HZ_MATCH_RULE_42.check_staged THEN
6057: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6058: FND_MSG_PUB.ADD;
6059: RAISE FND_API.G_EXC_ERROR;
6060: END IF;

Line 6061: HZ_MATCH_RULE_42.get_party_for_search(

6057: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6058: FND_MSG_PUB.ADD;
6059: RAISE FND_API.G_EXC_ERROR;
6060: END IF;
6061: HZ_MATCH_RULE_42.get_party_for_search(
6062: p_party_id, x_party_search_rec,x_party_site_list,
6063: x_contact_list, x_contact_point_list);
6064: -- Code for Match rule DL SYSTEM DUPLICATE IDENTIFICATION
6065: ELSIF p_rule_id=48 THEN

Line 6428: IF NOT HZ_MATCH_RULE_42.check_staged THEN

6424: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6425: x_contact_list, x_contact_point_list);
6426: -- Code for Match rule SAMPLE: SEARCH EXACT
6427: ELSIF p_rule_id=42 THEN
6428: IF NOT HZ_MATCH_RULE_42.check_staged THEN
6429: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6430: FND_MSG_PUB.ADD;
6431: RAISE FND_API.G_EXC_ERROR;
6432: END IF;

Line 6433: HZ_MATCH_RULE_42.get_search_criteria(

6429: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6430: FND_MSG_PUB.ADD;
6431: RAISE FND_API.G_EXC_ERROR;
6432: END IF;
6433: HZ_MATCH_RULE_42.get_search_criteria(
6434: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6435: x_contact_list, x_contact_point_list);
6436: -- Code for Match rule DL SYSTEM DUPLICATE IDENTIFICATION
6437: ELSIF p_rule_id=48 THEN