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 671: IF NOT HZ_MATCH_RULE_48.check_staged THEN

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
671: IF NOT HZ_MATCH_RULE_48.check_staged THEN
672: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
673: FND_MSG_PUB.ADD;
674: RAISE FND_API.G_EXC_ERROR;
675: END IF;

Line 676: HZ_MATCH_RULE_48.find_persons(

672: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
673: FND_MSG_PUB.ADD;
674: RAISE FND_API.G_EXC_ERROR;
675: END IF;
676: HZ_MATCH_RULE_48.find_persons(
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 BULK MATCH: IDENTICAL ORGANIZATIONS
680: ELSIF p_rule_id=50 THEN

Line 1070: IF NOT HZ_MATCH_RULE_48.check_staged THEN

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
1070: IF NOT HZ_MATCH_RULE_48.check_staged THEN
1071: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1072: FND_MSG_PUB.ADD;
1073: RAISE FND_API.G_EXC_ERROR;
1074: END IF;

Line 1075: HZ_MATCH_RULE_48.find_party_details(

1071: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1072: FND_MSG_PUB.ADD;
1073: RAISE FND_API.G_EXC_ERROR;
1074: END IF;
1075: HZ_MATCH_RULE_48.find_party_details(
1076: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
1077: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
1078: -- Code for Match rule BULK MATCH: IDENTICAL ORGANIZATIONS
1079: ELSIF p_rule_id=50 THEN

Line 1450: IF NOT HZ_MATCH_RULE_48.check_staged THEN

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
1450: IF NOT HZ_MATCH_RULE_48.check_staged THEN
1451: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1452: FND_MSG_PUB.ADD;
1453: RAISE FND_API.G_EXC_ERROR;
1454: END IF;

Line 1455: HZ_MATCH_RULE_48.find_duplicate_parties(

1451: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1452: FND_MSG_PUB.ADD;
1453: RAISE FND_API.G_EXC_ERROR;
1454: END IF;
1455: HZ_MATCH_RULE_48.find_duplicate_parties(
1456: p_rule_id,p_party_id,
1457: p_restrict_sql,p_match_type,p_dup_batch_id,p_search_merged,x_dup_set_id, x_search_ctx_id,x_num_matches);
1458: -- Code for Match rule BULK MATCH: IDENTICAL ORGANIZATIONS
1459: ELSIF p_rule_id=50 THEN

Line 1825: IF NOT HZ_MATCH_RULE_48.check_staged THEN

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
1825: IF NOT HZ_MATCH_RULE_48.check_staged THEN
1826: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1827: FND_MSG_PUB.ADD;
1828: RAISE FND_API.G_EXC_ERROR;
1829: END IF;

Line 1830: HZ_MATCH_RULE_48.find_duplicate_party_sites(

1826: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1827: FND_MSG_PUB.ADD;
1828: RAISE FND_API.G_EXC_ERROR;
1829: END IF;
1830: HZ_MATCH_RULE_48.find_duplicate_party_sites(
1831: p_rule_id,p_party_site_id,p_party_id,
1832: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
1833: -- Code for Match rule BULK MATCH: IDENTICAL ORGANIZATIONS
1834: ELSIF p_rule_id=50 THEN

Line 2199: IF NOT HZ_MATCH_RULE_48.check_staged THEN

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
2199: IF NOT HZ_MATCH_RULE_48.check_staged THEN
2200: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2201: FND_MSG_PUB.ADD;
2202: RAISE FND_API.G_EXC_ERROR;
2203: END IF;

Line 2204: HZ_MATCH_RULE_48.find_duplicate_contacts(

2200: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2201: FND_MSG_PUB.ADD;
2202: RAISE FND_API.G_EXC_ERROR;
2203: END IF;
2204: HZ_MATCH_RULE_48.find_duplicate_contacts(
2205: p_rule_id,p_org_contact_id,p_party_id,
2206: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2207: -- Code for Match rule BULK MATCH: IDENTICAL ORGANIZATIONS
2208: ELSIF p_rule_id=50 THEN

Line 2573: IF NOT HZ_MATCH_RULE_48.check_staged THEN

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
2573: IF NOT HZ_MATCH_RULE_48.check_staged THEN
2574: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2575: FND_MSG_PUB.ADD;
2576: RAISE FND_API.G_EXC_ERROR;
2577: END IF;

Line 2578: HZ_MATCH_RULE_48.find_duplicate_contact_points(

2574: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2575: FND_MSG_PUB.ADD;
2576: RAISE FND_API.G_EXC_ERROR;
2577: END IF;
2578: HZ_MATCH_RULE_48.find_duplicate_contact_points(
2579: p_rule_id,p_contact_point_id,p_party_id,
2580: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2581: -- Code for Match rule BULK MATCH: IDENTICAL ORGANIZATIONS
2582: ELSIF p_rule_id=50 THEN

Line 3131: IF NOT HZ_MATCH_RULE_48.check_staged THEN

3127: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3128: p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
3129: -- Code for Match rule DL SYSTEM DUPLICATE IDENTIFICATION
3130: ELSIF p_rule_id=48 THEN
3131: IF NOT HZ_MATCH_RULE_48.check_staged THEN
3132: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3133: FND_MSG_PUB.ADD;
3134: RAISE FND_API.G_EXC_ERROR;
3135: END IF;

Line 3136: HZ_MATCH_RULE_48.find_parties_dynamic(

3132: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3133: FND_MSG_PUB.ADD;
3134: RAISE FND_API.G_EXC_ERROR;
3135: END IF;
3136: HZ_MATCH_RULE_48.find_parties_dynamic(
3137: p_rule_id,
3138: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
3139: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
3140: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 3778: IF NOT HZ_MATCH_RULE_48.check_staged THEN

3774: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3775: p_restrict_sql,p_api_name,p_match_type,p_party_id,p_search_merged,x_search_ctx_id,x_num_matches);
3776: -- Code for Match rule DL SYSTEM DUPLICATE IDENTIFICATION
3777: ELSIF p_rule_id=48 THEN
3778: IF NOT HZ_MATCH_RULE_48.check_staged THEN
3779: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3780: FND_MSG_PUB.ADD;
3781: RAISE FND_API.G_EXC_ERROR;
3782: END IF;

Line 3783: HZ_MATCH_RULE_48.call_api_dynamic(

3779: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3780: FND_MSG_PUB.ADD;
3781: RAISE FND_API.G_EXC_ERROR;
3782: END IF;
3783: HZ_MATCH_RULE_48.call_api_dynamic(
3784: p_rule_id,
3785: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
3786: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
3787: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 4472: IF NOT HZ_MATCH_RULE_48.check_staged THEN

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
4472: IF NOT HZ_MATCH_RULE_48.check_staged THEN
4473: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4474: FND_MSG_PUB.ADD;
4475: RAISE FND_API.G_EXC_ERROR;
4476: END IF;

Line 4477: HZ_MATCH_RULE_48.get_matching_party_sites(

4473: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4474: FND_MSG_PUB.ADD;
4475: RAISE FND_API.G_EXC_ERROR;
4476: END IF;
4477: HZ_MATCH_RULE_48.get_matching_party_sites(
4478: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4479: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4480: -- Code for Match rule BULK MATCH: IDENTICAL ORGANIZATIONS
4481: ELSIF p_rule_id=50 THEN

Line 4871: IF NOT HZ_MATCH_RULE_48.check_staged THEN

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
4871: IF NOT HZ_MATCH_RULE_48.check_staged THEN
4872: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4873: FND_MSG_PUB.ADD;
4874: RAISE FND_API.G_EXC_ERROR;
4875: END IF;

Line 4876: HZ_MATCH_RULE_48.get_matching_contacts(

4872: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4873: FND_MSG_PUB.ADD;
4874: RAISE FND_API.G_EXC_ERROR;
4875: END IF;
4876: HZ_MATCH_RULE_48.get_matching_contacts(
4877: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
4878: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4879: -- Code for Match rule BULK MATCH: IDENTICAL ORGANIZATIONS
4880: ELSIF p_rule_id=50 THEN

Line 5268: IF NOT HZ_MATCH_RULE_48.check_staged THEN

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
5268: IF NOT HZ_MATCH_RULE_48.check_staged THEN
5269: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5270: FND_MSG_PUB.ADD;
5271: RAISE FND_API.G_EXC_ERROR;
5272: END IF;

Line 5273: HZ_MATCH_RULE_48.get_matching_contact_points(

5269: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5270: FND_MSG_PUB.ADD;
5271: RAISE FND_API.G_EXC_ERROR;
5272: END IF;
5273: HZ_MATCH_RULE_48.get_matching_contact_points(
5274: p_rule_id, p_party_id, p_contact_point_list,
5275: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5276: -- Code for Match rule BULK MATCH: IDENTICAL ORGANIZATIONS
5277: ELSIF p_rule_id=50 THEN

Line 5686: IF NOT HZ_MATCH_RULE_48.check_staged THEN

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
5685: ELSIF p_rule_id=48 THEN
5686: IF NOT HZ_MATCH_RULE_48.check_staged THEN
5687: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5688: FND_MSG_PUB.ADD;
5689: RAISE FND_API.G_EXC_ERROR;
5690: END IF;

Line 5691: HZ_MATCH_RULE_48.get_score_details(

5687: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5688: FND_MSG_PUB.ADD;
5689: RAISE FND_API.G_EXC_ERROR;
5690: END IF;
5691: HZ_MATCH_RULE_48.get_score_details(
5692: p_rule_id,
5693: p_party_id, p_party_search_rec,p_party_site_list,
5694: p_contact_list, p_contact_point_list,x_search_ctx_id);
5695: -- Code for Match rule BULK MATCH: IDENTICAL ORGANIZATIONS

Line 6066: IF NOT HZ_MATCH_RULE_48.check_staged THEN

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
6066: IF NOT HZ_MATCH_RULE_48.check_staged THEN
6067: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6068: FND_MSG_PUB.ADD;
6069: RAISE FND_API.G_EXC_ERROR;
6070: END IF;

Line 6071: HZ_MATCH_RULE_48.get_party_for_search(

6067: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6068: FND_MSG_PUB.ADD;
6069: RAISE FND_API.G_EXC_ERROR;
6070: END IF;
6071: HZ_MATCH_RULE_48.get_party_for_search(
6072: p_party_id, x_party_search_rec,x_party_site_list,
6073: x_contact_list, x_contact_point_list);
6074: -- Code for Match rule BULK MATCH: IDENTICAL ORGANIZATIONS
6075: ELSIF p_rule_id=50 THEN

Line 6438: IF NOT HZ_MATCH_RULE_48.check_staged THEN

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
6438: IF NOT HZ_MATCH_RULE_48.check_staged THEN
6439: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6440: FND_MSG_PUB.ADD;
6441: RAISE FND_API.G_EXC_ERROR;
6442: END IF;

Line 6443: HZ_MATCH_RULE_48.get_search_criteria(

6439: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6440: FND_MSG_PUB.ADD;
6441: RAISE FND_API.G_EXC_ERROR;
6442: END IF;
6443: HZ_MATCH_RULE_48.get_search_criteria(
6444: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6445: x_contact_list, x_contact_point_list);
6446: -- Code for Match rule BULK MATCH: IDENTICAL ORGANIZATIONS
6447: ELSIF p_rule_id=50 THEN