DBA Data[Home] [Help]

APPS.HZ_PARTY_SEARCH dependencies on HZ_MATCH_RULE_48

Line 290: IF NOT HZ_MATCH_RULE_48.check_staged THEN

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
290: IF NOT HZ_MATCH_RULE_48.check_staged THEN
291: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
292: FND_MSG_PUB.ADD;
293: RAISE FND_API.G_EXC_ERROR;
294: END IF;

Line 295: HZ_MATCH_RULE_48.find_parties(

291: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
292: FND_MSG_PUB.ADD;
293: RAISE FND_API.G_EXC_ERROR;
294: END IF;
295: HZ_MATCH_RULE_48.find_parties(
296: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
297: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,NULL,NULL,NULL,'N',x_search_ctx_id,x_num_matches);
298: -- Code for Match rule BULK MATCH: IDENTICAL ORGANIZATIONS
299: ELSIF p_rule_id=50 THEN

Line 691: IF NOT HZ_MATCH_RULE_48.check_staged THEN

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
691: IF NOT HZ_MATCH_RULE_48.check_staged THEN
692: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
693: FND_MSG_PUB.ADD;
694: RAISE FND_API.G_EXC_ERROR;
695: END IF;

Line 696: HZ_MATCH_RULE_48.find_persons(

692: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
693: FND_MSG_PUB.ADD;
694: RAISE FND_API.G_EXC_ERROR;
695: END IF;
696: HZ_MATCH_RULE_48.find_persons(
697: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
698: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,'N',x_search_ctx_id,x_num_matches);
699: -- Code for Match rule BULK MATCH: IDENTICAL ORGANIZATIONS
700: ELSIF p_rule_id=50 THEN

Line 1110: IF NOT HZ_MATCH_RULE_48.check_staged THEN

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
1110: IF NOT HZ_MATCH_RULE_48.check_staged THEN
1111: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1112: FND_MSG_PUB.ADD;
1113: RAISE FND_API.G_EXC_ERROR;
1114: END IF;

Line 1115: HZ_MATCH_RULE_48.find_party_details(

1111: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1112: FND_MSG_PUB.ADD;
1113: RAISE FND_API.G_EXC_ERROR;
1114: END IF;
1115: HZ_MATCH_RULE_48.find_party_details(
1116: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
1117: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
1118: -- Code for Match rule BULK MATCH: IDENTICAL ORGANIZATIONS
1119: ELSIF p_rule_id=50 THEN

Line 1510: IF NOT HZ_MATCH_RULE_48.check_staged THEN

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
1510: IF NOT HZ_MATCH_RULE_48.check_staged THEN
1511: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1512: FND_MSG_PUB.ADD;
1513: RAISE FND_API.G_EXC_ERROR;
1514: END IF;

Line 1515: HZ_MATCH_RULE_48.find_duplicate_parties(

1511: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1512: FND_MSG_PUB.ADD;
1513: RAISE FND_API.G_EXC_ERROR;
1514: END IF;
1515: HZ_MATCH_RULE_48.find_duplicate_parties(
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 BULK MATCH: IDENTICAL ORGANIZATIONS
1519: ELSIF p_rule_id=50 THEN

Line 1905: IF NOT HZ_MATCH_RULE_48.check_staged THEN

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
1905: IF NOT HZ_MATCH_RULE_48.check_staged THEN
1906: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1907: FND_MSG_PUB.ADD;
1908: RAISE FND_API.G_EXC_ERROR;
1909: END IF;

Line 1910: HZ_MATCH_RULE_48.find_duplicate_party_sites(

1906: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1907: FND_MSG_PUB.ADD;
1908: RAISE FND_API.G_EXC_ERROR;
1909: END IF;
1910: HZ_MATCH_RULE_48.find_duplicate_party_sites(
1911: p_rule_id,p_party_site_id,p_party_id,
1912: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
1913: -- Code for Match rule BULK MATCH: IDENTICAL ORGANIZATIONS
1914: ELSIF p_rule_id=50 THEN

Line 2299: IF NOT HZ_MATCH_RULE_48.check_staged THEN

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
2299: IF NOT HZ_MATCH_RULE_48.check_staged THEN
2300: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2301: FND_MSG_PUB.ADD;
2302: RAISE FND_API.G_EXC_ERROR;
2303: END IF;

Line 2304: HZ_MATCH_RULE_48.find_duplicate_contacts(

2300: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2301: FND_MSG_PUB.ADD;
2302: RAISE FND_API.G_EXC_ERROR;
2303: END IF;
2304: HZ_MATCH_RULE_48.find_duplicate_contacts(
2305: p_rule_id,p_org_contact_id,p_party_id,
2306: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2307: -- Code for Match rule BULK MATCH: IDENTICAL ORGANIZATIONS
2308: ELSIF p_rule_id=50 THEN

Line 2693: IF NOT HZ_MATCH_RULE_48.check_staged THEN

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
2693: IF NOT HZ_MATCH_RULE_48.check_staged THEN
2694: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2695: FND_MSG_PUB.ADD;
2696: RAISE FND_API.G_EXC_ERROR;
2697: END IF;

Line 2698: HZ_MATCH_RULE_48.find_duplicate_contact_points(

2694: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2695: FND_MSG_PUB.ADD;
2696: RAISE FND_API.G_EXC_ERROR;
2697: END IF;
2698: HZ_MATCH_RULE_48.find_duplicate_contact_points(
2699: p_rule_id,p_contact_point_id,p_party_id,
2700: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2701: -- Code for Match rule BULK MATCH: IDENTICAL ORGANIZATIONS
2702: ELSIF p_rule_id=50 THEN

Line 3271: IF NOT HZ_MATCH_RULE_48.check_staged THEN

3267: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3268: p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
3269: -- Code for Match rule DL SYSTEM DUPLICATE IDENTIFICATION
3270: ELSIF p_rule_id=48 THEN
3271: IF NOT HZ_MATCH_RULE_48.check_staged THEN
3272: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3273: FND_MSG_PUB.ADD;
3274: RAISE FND_API.G_EXC_ERROR;
3275: END IF;

Line 3276: HZ_MATCH_RULE_48.find_parties_dynamic(

3272: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3273: FND_MSG_PUB.ADD;
3274: RAISE FND_API.G_EXC_ERROR;
3275: END IF;
3276: HZ_MATCH_RULE_48.find_parties_dynamic(
3277: p_rule_id,
3278: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
3279: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
3280: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 3954: IF NOT HZ_MATCH_RULE_48.check_staged THEN

3950: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3951: p_restrict_sql,p_api_name,p_match_type,p_party_id,p_search_merged,x_search_ctx_id,x_num_matches);
3952: -- Code for Match rule DL SYSTEM DUPLICATE IDENTIFICATION
3953: ELSIF p_rule_id=48 THEN
3954: IF NOT HZ_MATCH_RULE_48.check_staged THEN
3955: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3956: FND_MSG_PUB.ADD;
3957: RAISE FND_API.G_EXC_ERROR;
3958: END IF;

Line 3959: HZ_MATCH_RULE_48.call_api_dynamic(

3955: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3956: FND_MSG_PUB.ADD;
3957: RAISE FND_API.G_EXC_ERROR;
3958: END IF;
3959: HZ_MATCH_RULE_48.call_api_dynamic(
3960: p_rule_id,
3961: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
3962: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
3963: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 4684: IF NOT HZ_MATCH_RULE_48.check_staged THEN

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
4684: IF NOT HZ_MATCH_RULE_48.check_staged THEN
4685: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4686: FND_MSG_PUB.ADD;
4687: RAISE FND_API.G_EXC_ERROR;
4688: END IF;

Line 4689: HZ_MATCH_RULE_48.get_matching_party_sites(

4685: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4686: FND_MSG_PUB.ADD;
4687: RAISE FND_API.G_EXC_ERROR;
4688: END IF;
4689: HZ_MATCH_RULE_48.get_matching_party_sites(
4690: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4691: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4692: -- Code for Match rule BULK MATCH: IDENTICAL ORGANIZATIONS
4693: ELSIF p_rule_id=50 THEN

Line 5103: IF NOT HZ_MATCH_RULE_48.check_staged THEN

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
5103: IF NOT HZ_MATCH_RULE_48.check_staged THEN
5104: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5105: FND_MSG_PUB.ADD;
5106: RAISE FND_API.G_EXC_ERROR;
5107: END IF;

Line 5108: HZ_MATCH_RULE_48.get_matching_contacts(

5104: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5105: FND_MSG_PUB.ADD;
5106: RAISE FND_API.G_EXC_ERROR;
5107: END IF;
5108: HZ_MATCH_RULE_48.get_matching_contacts(
5109: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
5110: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5111: -- Code for Match rule BULK MATCH: IDENTICAL ORGANIZATIONS
5112: ELSIF p_rule_id=50 THEN

Line 5520: IF NOT HZ_MATCH_RULE_48.check_staged THEN

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
5520: IF NOT HZ_MATCH_RULE_48.check_staged THEN
5521: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5522: FND_MSG_PUB.ADD;
5523: RAISE FND_API.G_EXC_ERROR;
5524: END IF;

Line 5525: HZ_MATCH_RULE_48.get_matching_contact_points(

5521: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5522: FND_MSG_PUB.ADD;
5523: RAISE FND_API.G_EXC_ERROR;
5524: END IF;
5525: HZ_MATCH_RULE_48.get_matching_contact_points(
5526: p_rule_id, p_party_id, p_contact_point_list,
5527: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5528: -- Code for Match rule BULK MATCH: IDENTICAL ORGANIZATIONS
5529: ELSIF p_rule_id=50 THEN

Line 5958: IF NOT HZ_MATCH_RULE_48.check_staged THEN

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
5957: ELSIF p_rule_id=48 THEN
5958: IF NOT HZ_MATCH_RULE_48.check_staged THEN
5959: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5960: FND_MSG_PUB.ADD;
5961: RAISE FND_API.G_EXC_ERROR;
5962: END IF;

Line 5963: HZ_MATCH_RULE_48.get_score_details(

5959: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5960: FND_MSG_PUB.ADD;
5961: RAISE FND_API.G_EXC_ERROR;
5962: END IF;
5963: HZ_MATCH_RULE_48.get_score_details(
5964: p_rule_id,
5965: p_party_id, p_party_search_rec,p_party_site_list,
5966: p_contact_list, p_contact_point_list,x_search_ctx_id);
5967: -- Code for Match rule BULK MATCH: IDENTICAL ORGANIZATIONS

Line 6360: IF NOT HZ_MATCH_RULE_48.check_staged THEN

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
6360: IF NOT HZ_MATCH_RULE_48.check_staged THEN
6361: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6362: FND_MSG_PUB.ADD;
6363: RAISE FND_API.G_EXC_ERROR;
6364: END IF;

Line 6365: HZ_MATCH_RULE_48.get_party_for_search(

6361: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6362: FND_MSG_PUB.ADD;
6363: RAISE FND_API.G_EXC_ERROR;
6364: END IF;
6365: HZ_MATCH_RULE_48.get_party_for_search(
6366: p_party_id, x_party_search_rec,x_party_site_list,
6367: x_contact_list, x_contact_point_list);
6368: -- Code for Match rule BULK MATCH: IDENTICAL ORGANIZATIONS
6369: ELSIF p_rule_id=50 THEN

Line 6752: IF NOT HZ_MATCH_RULE_48.check_staged THEN

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
6752: IF NOT HZ_MATCH_RULE_48.check_staged THEN
6753: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6754: FND_MSG_PUB.ADD;
6755: RAISE FND_API.G_EXC_ERROR;
6756: END IF;

Line 6757: HZ_MATCH_RULE_48.get_search_criteria(

6753: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6754: FND_MSG_PUB.ADD;
6755: RAISE FND_API.G_EXC_ERROR;
6756: END IF;
6757: HZ_MATCH_RULE_48.get_search_criteria(
6758: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6759: x_contact_list, x_contact_point_list);
6760: -- Code for Match rule BULK MATCH: IDENTICAL ORGANIZATIONS
6761: ELSIF p_rule_id=50 THEN