DBA Data[Home] [Help]

APPS.HZ_PARTY_SEARCH dependencies on HZ_MATCH_RULE_41

Line 270: IF NOT HZ_MATCH_RULE_41.check_staged THEN

266: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
267: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,NULL,NULL,NULL,'N',x_search_ctx_id,x_num_matches);
268: -- Code for Match rule SAMPLE: SEARCH SIMILAR PERSON EXACT
269: ELSIF p_rule_id=41 THEN
270: IF NOT HZ_MATCH_RULE_41.check_staged THEN
271: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
272: FND_MSG_PUB.ADD;
273: RAISE FND_API.G_EXC_ERROR;
274: END IF;

Line 275: HZ_MATCH_RULE_41.find_parties(

271: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
272: FND_MSG_PUB.ADD;
273: RAISE FND_API.G_EXC_ERROR;
274: END IF;
275: HZ_MATCH_RULE_41.find_parties(
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

Line 651: IF NOT HZ_MATCH_RULE_41.check_staged THEN

647: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
648: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,'N',x_search_ctx_id,x_num_matches);
649: -- Code for Match rule SAMPLE: SEARCH SIMILAR PERSON EXACT
650: ELSIF p_rule_id=41 THEN
651: IF NOT HZ_MATCH_RULE_41.check_staged THEN
652: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
653: FND_MSG_PUB.ADD;
654: RAISE FND_API.G_EXC_ERROR;
655: END IF;

Line 656: HZ_MATCH_RULE_41.find_persons(

652: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
653: FND_MSG_PUB.ADD;
654: RAISE FND_API.G_EXC_ERROR;
655: END IF;
656: HZ_MATCH_RULE_41.find_persons(
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

Line 1050: IF NOT HZ_MATCH_RULE_41.check_staged THEN

1046: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
1047: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
1048: -- Code for Match rule SAMPLE: SEARCH SIMILAR PERSON EXACT
1049: ELSIF p_rule_id=41 THEN
1050: IF NOT HZ_MATCH_RULE_41.check_staged THEN
1051: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1052: FND_MSG_PUB.ADD;
1053: RAISE FND_API.G_EXC_ERROR;
1054: END IF;

Line 1055: HZ_MATCH_RULE_41.find_party_details(

1051: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1052: FND_MSG_PUB.ADD;
1053: RAISE FND_API.G_EXC_ERROR;
1054: END IF;
1055: HZ_MATCH_RULE_41.find_party_details(
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

Line 1430: IF NOT HZ_MATCH_RULE_41.check_staged THEN

1426: p_rule_id,p_party_id,
1427: p_restrict_sql,p_match_type,p_dup_batch_id,p_search_merged,x_dup_set_id, x_search_ctx_id,x_num_matches);
1428: -- Code for Match rule SAMPLE: SEARCH SIMILAR PERSON EXACT
1429: ELSIF p_rule_id=41 THEN
1430: IF NOT HZ_MATCH_RULE_41.check_staged THEN
1431: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1432: FND_MSG_PUB.ADD;
1433: RAISE FND_API.G_EXC_ERROR;
1434: END IF;

Line 1435: HZ_MATCH_RULE_41.find_duplicate_parties(

1431: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1432: FND_MSG_PUB.ADD;
1433: RAISE FND_API.G_EXC_ERROR;
1434: END IF;
1435: HZ_MATCH_RULE_41.find_duplicate_parties(
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

Line 1805: IF NOT HZ_MATCH_RULE_41.check_staged THEN

1801: p_rule_id,p_party_site_id,p_party_id,
1802: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
1803: -- Code for Match rule SAMPLE: SEARCH SIMILAR PERSON EXACT
1804: ELSIF p_rule_id=41 THEN
1805: IF NOT HZ_MATCH_RULE_41.check_staged THEN
1806: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1807: FND_MSG_PUB.ADD;
1808: RAISE FND_API.G_EXC_ERROR;
1809: END IF;

Line 1810: HZ_MATCH_RULE_41.find_duplicate_party_sites(

1806: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1807: FND_MSG_PUB.ADD;
1808: RAISE FND_API.G_EXC_ERROR;
1809: END IF;
1810: HZ_MATCH_RULE_41.find_duplicate_party_sites(
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

Line 2179: IF NOT HZ_MATCH_RULE_41.check_staged THEN

2175: p_rule_id,p_org_contact_id,p_party_id,
2176: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2177: -- Code for Match rule SAMPLE: SEARCH SIMILAR PERSON EXACT
2178: ELSIF p_rule_id=41 THEN
2179: IF NOT HZ_MATCH_RULE_41.check_staged THEN
2180: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2181: FND_MSG_PUB.ADD;
2182: RAISE FND_API.G_EXC_ERROR;
2183: END IF;

Line 2184: HZ_MATCH_RULE_41.find_duplicate_contacts(

2180: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2181: FND_MSG_PUB.ADD;
2182: RAISE FND_API.G_EXC_ERROR;
2183: END IF;
2184: HZ_MATCH_RULE_41.find_duplicate_contacts(
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

Line 2553: IF NOT HZ_MATCH_RULE_41.check_staged THEN

2549: p_rule_id,p_contact_point_id,p_party_id,
2550: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2551: -- Code for Match rule SAMPLE: SEARCH SIMILAR PERSON EXACT
2552: ELSIF p_rule_id=41 THEN
2553: IF NOT HZ_MATCH_RULE_41.check_staged THEN
2554: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2555: FND_MSG_PUB.ADD;
2556: RAISE FND_API.G_EXC_ERROR;
2557: END IF;

Line 2558: HZ_MATCH_RULE_41.find_duplicate_contact_points(

2554: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2555: FND_MSG_PUB.ADD;
2556: RAISE FND_API.G_EXC_ERROR;
2557: END IF;
2558: HZ_MATCH_RULE_41.find_duplicate_contact_points(
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

Line 3095: IF NOT HZ_MATCH_RULE_41.check_staged THEN

3091: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3092: p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
3093: -- Code for Match rule SAMPLE: SEARCH SIMILAR PERSON EXACT
3094: ELSIF p_rule_id=41 THEN
3095: IF NOT HZ_MATCH_RULE_41.check_staged THEN
3096: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3097: FND_MSG_PUB.ADD;
3098: RAISE FND_API.G_EXC_ERROR;
3099: END IF;

Line 3100: HZ_MATCH_RULE_41.find_parties_dynamic(

3096: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3097: FND_MSG_PUB.ADD;
3098: RAISE FND_API.G_EXC_ERROR;
3099: END IF;
3100: HZ_MATCH_RULE_41.find_parties_dynamic(
3101: p_rule_id,
3102: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
3103: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
3104: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 3742: IF NOT HZ_MATCH_RULE_41.check_staged THEN

3738: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3739: p_restrict_sql,p_api_name,p_match_type,p_party_id,p_search_merged,x_search_ctx_id,x_num_matches);
3740: -- Code for Match rule SAMPLE: SEARCH SIMILAR PERSON EXACT
3741: ELSIF p_rule_id=41 THEN
3742: IF NOT HZ_MATCH_RULE_41.check_staged THEN
3743: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3744: FND_MSG_PUB.ADD;
3745: RAISE FND_API.G_EXC_ERROR;
3746: END IF;

Line 3747: HZ_MATCH_RULE_41.call_api_dynamic(

3743: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3744: FND_MSG_PUB.ADD;
3745: RAISE FND_API.G_EXC_ERROR;
3746: END IF;
3747: HZ_MATCH_RULE_41.call_api_dynamic(
3748: p_rule_id,
3749: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
3750: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
3751: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 4452: IF NOT HZ_MATCH_RULE_41.check_staged THEN

4448: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4449: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4450: -- Code for Match rule SAMPLE: SEARCH SIMILAR PERSON EXACT
4451: ELSIF p_rule_id=41 THEN
4452: IF NOT HZ_MATCH_RULE_41.check_staged THEN
4453: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4454: FND_MSG_PUB.ADD;
4455: RAISE FND_API.G_EXC_ERROR;
4456: END IF;

Line 4457: HZ_MATCH_RULE_41.get_matching_party_sites(

4453: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4454: FND_MSG_PUB.ADD;
4455: RAISE FND_API.G_EXC_ERROR;
4456: END IF;
4457: HZ_MATCH_RULE_41.get_matching_party_sites(
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

Line 4851: IF NOT HZ_MATCH_RULE_41.check_staged THEN

4847: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
4848: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4849: -- Code for Match rule SAMPLE: SEARCH SIMILAR PERSON EXACT
4850: ELSIF p_rule_id=41 THEN
4851: IF NOT HZ_MATCH_RULE_41.check_staged THEN
4852: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4853: FND_MSG_PUB.ADD;
4854: RAISE FND_API.G_EXC_ERROR;
4855: END IF;

Line 4856: HZ_MATCH_RULE_41.get_matching_contacts(

4852: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4853: FND_MSG_PUB.ADD;
4854: RAISE FND_API.G_EXC_ERROR;
4855: END IF;
4856: HZ_MATCH_RULE_41.get_matching_contacts(
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

Line 5248: IF NOT HZ_MATCH_RULE_41.check_staged THEN

5244: p_rule_id, p_party_id, p_contact_point_list,
5245: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5246: -- Code for Match rule SAMPLE: SEARCH SIMILAR PERSON EXACT
5247: ELSIF p_rule_id=41 THEN
5248: IF NOT HZ_MATCH_RULE_41.check_staged THEN
5249: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5250: FND_MSG_PUB.ADD;
5251: RAISE FND_API.G_EXC_ERROR;
5252: END IF;

Line 5253: HZ_MATCH_RULE_41.get_matching_contact_points(

5249: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5250: FND_MSG_PUB.ADD;
5251: RAISE FND_API.G_EXC_ERROR;
5252: END IF;
5253: HZ_MATCH_RULE_41.get_matching_contact_points(
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

Line 5664: IF NOT HZ_MATCH_RULE_41.check_staged THEN

5660: p_party_id, p_party_search_rec,p_party_site_list,
5661: p_contact_list, p_contact_point_list,x_search_ctx_id);
5662: -- Code for Match rule SAMPLE: SEARCH SIMILAR PERSON EXACT
5663: ELSIF p_rule_id=41 THEN
5664: IF NOT HZ_MATCH_RULE_41.check_staged THEN
5665: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5666: FND_MSG_PUB.ADD;
5667: RAISE FND_API.G_EXC_ERROR;
5668: END IF;

Line 5669: HZ_MATCH_RULE_41.get_score_details(

5665: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5666: FND_MSG_PUB.ADD;
5667: RAISE FND_API.G_EXC_ERROR;
5668: END IF;
5669: HZ_MATCH_RULE_41.get_score_details(
5670: p_rule_id,
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

Line 6046: IF NOT HZ_MATCH_RULE_41.check_staged THEN

6042: p_party_id, x_party_search_rec,x_party_site_list,
6043: x_contact_list, x_contact_point_list);
6044: -- Code for Match rule SAMPLE: SEARCH SIMILAR PERSON EXACT
6045: ELSIF p_rule_id=41 THEN
6046: IF NOT HZ_MATCH_RULE_41.check_staged THEN
6047: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6048: FND_MSG_PUB.ADD;
6049: RAISE FND_API.G_EXC_ERROR;
6050: END IF;

Line 6051: HZ_MATCH_RULE_41.get_party_for_search(

6047: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6048: FND_MSG_PUB.ADD;
6049: RAISE FND_API.G_EXC_ERROR;
6050: END IF;
6051: HZ_MATCH_RULE_41.get_party_for_search(
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

Line 6418: IF NOT HZ_MATCH_RULE_41.check_staged THEN

6414: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6415: x_contact_list, x_contact_point_list);
6416: -- Code for Match rule SAMPLE: SEARCH SIMILAR PERSON EXACT
6417: ELSIF p_rule_id=41 THEN
6418: IF NOT HZ_MATCH_RULE_41.check_staged THEN
6419: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6420: FND_MSG_PUB.ADD;
6421: RAISE FND_API.G_EXC_ERROR;
6422: END IF;

Line 6423: HZ_MATCH_RULE_41.get_search_criteria(

6419: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6420: FND_MSG_PUB.ADD;
6421: RAISE FND_API.G_EXC_ERROR;
6422: END IF;
6423: HZ_MATCH_RULE_41.get_search_criteria(
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