DBA Data[Home] [Help]

APPS.HZ_PARTY_SEARCH dependencies on HZ_MATCH_RULE_39

Line 250: IF NOT HZ_MATCH_RULE_39.check_staged THEN

246: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
247: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,NULL,NULL,NULL,'N',x_search_ctx_id,x_num_matches);
248: -- Code for Match rule SAMPLE: SEARCH ADDRESS ORGANIZATIONS EXACT
249: ELSIF p_rule_id=39 THEN
250: IF NOT HZ_MATCH_RULE_39.check_staged THEN
251: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
252: FND_MSG_PUB.ADD;
253: RAISE FND_API.G_EXC_ERROR;
254: END IF;

Line 255: HZ_MATCH_RULE_39.find_parties(

251: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
252: FND_MSG_PUB.ADD;
253: RAISE FND_API.G_EXC_ERROR;
254: END IF;
255: HZ_MATCH_RULE_39.find_parties(
256: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
257: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,NULL,NULL,NULL,'N',x_search_ctx_id,x_num_matches);
258: -- Code for Match rule SAMPLE: SEARCH SIMILAR ORGANIZATION EXACT
259: ELSIF p_rule_id=40 THEN

Line 651: IF NOT HZ_MATCH_RULE_39.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 ADDRESS ORGANIZATIONS EXACT
650: ELSIF p_rule_id=39 THEN
651: IF NOT HZ_MATCH_RULE_39.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_39.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_39.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 SIMILAR ORGANIZATION EXACT
660: ELSIF p_rule_id=40 THEN

Line 1070: IF NOT HZ_MATCH_RULE_39.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 SAMPLE: SEARCH ADDRESS ORGANIZATIONS EXACT
1069: ELSIF p_rule_id=39 THEN
1070: IF NOT HZ_MATCH_RULE_39.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_39.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_39.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 SAMPLE: SEARCH SIMILAR ORGANIZATION EXACT
1079: ELSIF p_rule_id=40 THEN

Line 1470: IF NOT HZ_MATCH_RULE_39.check_staged THEN

1466: p_rule_id,p_party_id,
1467: p_restrict_sql,p_match_type,p_dup_batch_id,p_search_merged,x_dup_set_id, x_search_ctx_id,x_num_matches);
1468: -- Code for Match rule SAMPLE: SEARCH ADDRESS ORGANIZATIONS EXACT
1469: ELSIF p_rule_id=39 THEN
1470: IF NOT HZ_MATCH_RULE_39.check_staged THEN
1471: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1472: FND_MSG_PUB.ADD;
1473: RAISE FND_API.G_EXC_ERROR;
1474: END IF;

Line 1475: HZ_MATCH_RULE_39.find_duplicate_parties(

1471: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1472: FND_MSG_PUB.ADD;
1473: RAISE FND_API.G_EXC_ERROR;
1474: END IF;
1475: HZ_MATCH_RULE_39.find_duplicate_parties(
1476: p_rule_id,p_party_id,
1477: p_restrict_sql,p_match_type,p_dup_batch_id,p_search_merged,x_dup_set_id, x_search_ctx_id,x_num_matches);
1478: -- Code for Match rule SAMPLE: SEARCH SIMILAR ORGANIZATION EXACT
1479: ELSIF p_rule_id=40 THEN

Line 1865: IF NOT HZ_MATCH_RULE_39.check_staged THEN

1861: p_rule_id,p_party_site_id,p_party_id,
1862: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
1863: -- Code for Match rule SAMPLE: SEARCH ADDRESS ORGANIZATIONS EXACT
1864: ELSIF p_rule_id=39 THEN
1865: IF NOT HZ_MATCH_RULE_39.check_staged THEN
1866: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1867: FND_MSG_PUB.ADD;
1868: RAISE FND_API.G_EXC_ERROR;
1869: END IF;

Line 1870: HZ_MATCH_RULE_39.find_duplicate_party_sites(

1866: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1867: FND_MSG_PUB.ADD;
1868: RAISE FND_API.G_EXC_ERROR;
1869: END IF;
1870: HZ_MATCH_RULE_39.find_duplicate_party_sites(
1871: p_rule_id,p_party_site_id,p_party_id,
1872: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
1873: -- Code for Match rule SAMPLE: SEARCH SIMILAR ORGANIZATION EXACT
1874: ELSIF p_rule_id=40 THEN

Line 2259: IF NOT HZ_MATCH_RULE_39.check_staged THEN

2255: p_rule_id,p_org_contact_id,p_party_id,
2256: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2257: -- Code for Match rule SAMPLE: SEARCH ADDRESS ORGANIZATIONS EXACT
2258: ELSIF p_rule_id=39 THEN
2259: IF NOT HZ_MATCH_RULE_39.check_staged THEN
2260: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2261: FND_MSG_PUB.ADD;
2262: RAISE FND_API.G_EXC_ERROR;
2263: END IF;

Line 2264: HZ_MATCH_RULE_39.find_duplicate_contacts(

2260: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2261: FND_MSG_PUB.ADD;
2262: RAISE FND_API.G_EXC_ERROR;
2263: END IF;
2264: HZ_MATCH_RULE_39.find_duplicate_contacts(
2265: p_rule_id,p_org_contact_id,p_party_id,
2266: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2267: -- Code for Match rule SAMPLE: SEARCH SIMILAR ORGANIZATION EXACT
2268: ELSIF p_rule_id=40 THEN

Line 2653: IF NOT HZ_MATCH_RULE_39.check_staged THEN

2649: p_rule_id,p_contact_point_id,p_party_id,
2650: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2651: -- Code for Match rule SAMPLE: SEARCH ADDRESS ORGANIZATIONS EXACT
2652: ELSIF p_rule_id=39 THEN
2653: IF NOT HZ_MATCH_RULE_39.check_staged THEN
2654: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2655: FND_MSG_PUB.ADD;
2656: RAISE FND_API.G_EXC_ERROR;
2657: END IF;

Line 2658: HZ_MATCH_RULE_39.find_duplicate_contact_points(

2654: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2655: FND_MSG_PUB.ADD;
2656: RAISE FND_API.G_EXC_ERROR;
2657: END IF;
2658: HZ_MATCH_RULE_39.find_duplicate_contact_points(
2659: p_rule_id,p_contact_point_id,p_party_id,
2660: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2661: -- Code for Match rule SAMPLE: SEARCH SIMILAR ORGANIZATION EXACT
2662: ELSIF p_rule_id=40 THEN

Line 3199: IF NOT HZ_MATCH_RULE_39.check_staged THEN

3195: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3196: p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
3197: -- Code for Match rule SAMPLE: SEARCH ADDRESS ORGANIZATIONS EXACT
3198: ELSIF p_rule_id=39 THEN
3199: IF NOT HZ_MATCH_RULE_39.check_staged THEN
3200: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3201: FND_MSG_PUB.ADD;
3202: RAISE FND_API.G_EXC_ERROR;
3203: END IF;

Line 3204: HZ_MATCH_RULE_39.find_parties_dynamic(

3200: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3201: FND_MSG_PUB.ADD;
3202: RAISE FND_API.G_EXC_ERROR;
3203: END IF;
3204: HZ_MATCH_RULE_39.find_parties_dynamic(
3205: p_rule_id,
3206: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
3207: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
3208: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 3882: IF NOT HZ_MATCH_RULE_39.check_staged THEN

3878: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3879: p_restrict_sql,p_api_name,p_match_type,p_party_id,p_search_merged,x_search_ctx_id,x_num_matches);
3880: -- Code for Match rule SAMPLE: SEARCH ADDRESS ORGANIZATIONS EXACT
3881: ELSIF p_rule_id=39 THEN
3882: IF NOT HZ_MATCH_RULE_39.check_staged THEN
3883: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3884: FND_MSG_PUB.ADD;
3885: RAISE FND_API.G_EXC_ERROR;
3886: END IF;

Line 3887: HZ_MATCH_RULE_39.call_api_dynamic(

3883: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3884: FND_MSG_PUB.ADD;
3885: RAISE FND_API.G_EXC_ERROR;
3886: END IF;
3887: HZ_MATCH_RULE_39.call_api_dynamic(
3888: p_rule_id,
3889: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
3890: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
3891: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 4644: IF NOT HZ_MATCH_RULE_39.check_staged THEN

4640: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4641: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4642: -- Code for Match rule SAMPLE: SEARCH ADDRESS ORGANIZATIONS EXACT
4643: ELSIF p_rule_id=39 THEN
4644: IF NOT HZ_MATCH_RULE_39.check_staged THEN
4645: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4646: FND_MSG_PUB.ADD;
4647: RAISE FND_API.G_EXC_ERROR;
4648: END IF;

Line 4649: HZ_MATCH_RULE_39.get_matching_party_sites(

4645: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4646: FND_MSG_PUB.ADD;
4647: RAISE FND_API.G_EXC_ERROR;
4648: END IF;
4649: HZ_MATCH_RULE_39.get_matching_party_sites(
4650: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4651: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4652: -- Code for Match rule SAMPLE: SEARCH SIMILAR ORGANIZATION EXACT
4653: ELSIF p_rule_id=40 THEN

Line 5063: IF NOT HZ_MATCH_RULE_39.check_staged THEN

5059: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
5060: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5061: -- Code for Match rule SAMPLE: SEARCH ADDRESS ORGANIZATIONS EXACT
5062: ELSIF p_rule_id=39 THEN
5063: IF NOT HZ_MATCH_RULE_39.check_staged THEN
5064: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5065: FND_MSG_PUB.ADD;
5066: RAISE FND_API.G_EXC_ERROR;
5067: END IF;

Line 5068: HZ_MATCH_RULE_39.get_matching_contacts(

5064: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5065: FND_MSG_PUB.ADD;
5066: RAISE FND_API.G_EXC_ERROR;
5067: END IF;
5068: HZ_MATCH_RULE_39.get_matching_contacts(
5069: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
5070: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5071: -- Code for Match rule SAMPLE: SEARCH SIMILAR ORGANIZATION EXACT
5072: ELSIF p_rule_id=40 THEN

Line 5480: IF NOT HZ_MATCH_RULE_39.check_staged THEN

5476: p_rule_id, p_party_id, p_contact_point_list,
5477: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5478: -- Code for Match rule SAMPLE: SEARCH ADDRESS ORGANIZATIONS EXACT
5479: ELSIF p_rule_id=39 THEN
5480: IF NOT HZ_MATCH_RULE_39.check_staged THEN
5481: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5482: FND_MSG_PUB.ADD;
5483: RAISE FND_API.G_EXC_ERROR;
5484: END IF;

Line 5485: HZ_MATCH_RULE_39.get_matching_contact_points(

5481: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5482: FND_MSG_PUB.ADD;
5483: RAISE FND_API.G_EXC_ERROR;
5484: END IF;
5485: HZ_MATCH_RULE_39.get_matching_contact_points(
5486: p_rule_id, p_party_id, p_contact_point_list,
5487: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5488: -- Code for Match rule SAMPLE: SEARCH SIMILAR ORGANIZATION EXACT
5489: ELSIF p_rule_id=40 THEN

Line 5914: IF NOT HZ_MATCH_RULE_39.check_staged THEN

5910: p_party_id, p_party_search_rec,p_party_site_list,
5911: p_contact_list, p_contact_point_list,x_search_ctx_id);
5912: -- Code for Match rule SAMPLE: SEARCH ADDRESS ORGANIZATIONS EXACT
5913: ELSIF p_rule_id=39 THEN
5914: IF NOT HZ_MATCH_RULE_39.check_staged THEN
5915: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5916: FND_MSG_PUB.ADD;
5917: RAISE FND_API.G_EXC_ERROR;
5918: END IF;

Line 5919: HZ_MATCH_RULE_39.get_score_details(

5915: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5916: FND_MSG_PUB.ADD;
5917: RAISE FND_API.G_EXC_ERROR;
5918: END IF;
5919: HZ_MATCH_RULE_39.get_score_details(
5920: p_rule_id,
5921: p_party_id, p_party_search_rec,p_party_site_list,
5922: p_contact_list, p_contact_point_list,x_search_ctx_id);
5923: -- Code for Match rule SAMPLE: SEARCH SIMILAR ORGANIZATION EXACT

Line 6320: IF NOT HZ_MATCH_RULE_39.check_staged THEN

6316: p_party_id, x_party_search_rec,x_party_site_list,
6317: x_contact_list, x_contact_point_list);
6318: -- Code for Match rule SAMPLE: SEARCH ADDRESS ORGANIZATIONS EXACT
6319: ELSIF p_rule_id=39 THEN
6320: IF NOT HZ_MATCH_RULE_39.check_staged THEN
6321: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6322: FND_MSG_PUB.ADD;
6323: RAISE FND_API.G_EXC_ERROR;
6324: END IF;

Line 6325: HZ_MATCH_RULE_39.get_party_for_search(

6321: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6322: FND_MSG_PUB.ADD;
6323: RAISE FND_API.G_EXC_ERROR;
6324: END IF;
6325: HZ_MATCH_RULE_39.get_party_for_search(
6326: p_party_id, x_party_search_rec,x_party_site_list,
6327: x_contact_list, x_contact_point_list);
6328: -- Code for Match rule SAMPLE: SEARCH SIMILAR ORGANIZATION EXACT
6329: ELSIF p_rule_id=40 THEN

Line 6712: IF NOT HZ_MATCH_RULE_39.check_staged THEN

6708: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6709: x_contact_list, x_contact_point_list);
6710: -- Code for Match rule SAMPLE: SEARCH ADDRESS ORGANIZATIONS EXACT
6711: ELSIF p_rule_id=39 THEN
6712: IF NOT HZ_MATCH_RULE_39.check_staged THEN
6713: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6714: FND_MSG_PUB.ADD;
6715: RAISE FND_API.G_EXC_ERROR;
6716: END IF;

Line 6717: HZ_MATCH_RULE_39.get_search_criteria(

6713: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6714: FND_MSG_PUB.ADD;
6715: RAISE FND_API.G_EXC_ERROR;
6716: END IF;
6717: HZ_MATCH_RULE_39.get_search_criteria(
6718: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6719: x_contact_list, x_contact_point_list);
6720: -- Code for Match rule SAMPLE: SEARCH SIMILAR ORGANIZATION EXACT
6721: ELSIF p_rule_id=40 THEN