eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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 631: IF NOT HZ_MATCH_RULE_39.check_staged THEN

627: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
628: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,'N',x_search_ctx_id,x_num_matches);
629: -- Code for Match rule SAMPLE: SEARCH ADDRESS ORGANIZATIONS EXACT
630: ELSIF p_rule_id=39 THEN
631: IF NOT HZ_MATCH_RULE_39.check_staged THEN
632: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
633: FND_MSG_PUB.ADD;
634: RAISE FND_API.G_EXC_ERROR;
635: END IF;

Line 636: HZ_MATCH_RULE_39.find_persons(

632: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
633: FND_MSG_PUB.ADD;
634: RAISE FND_API.G_EXC_ERROR;
635: END IF;
636: HZ_MATCH_RULE_39.find_persons(
637: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
638: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,'N',x_search_ctx_id,x_num_matches);
639: -- Code for Match rule SAMPLE: SEARCH SIMILAR ORGANIZATION EXACT
640: ELSIF p_rule_id=40 THEN

Line 1030: IF NOT HZ_MATCH_RULE_39.check_staged THEN

1026: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
1027: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
1028: -- Code for Match rule SAMPLE: SEARCH ADDRESS ORGANIZATIONS EXACT
1029: ELSIF p_rule_id=39 THEN
1030: IF NOT HZ_MATCH_RULE_39.check_staged THEN
1031: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1032: FND_MSG_PUB.ADD;
1033: RAISE FND_API.G_EXC_ERROR;
1034: END IF;

Line 1035: HZ_MATCH_RULE_39.find_party_details(

1031: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1032: FND_MSG_PUB.ADD;
1033: RAISE FND_API.G_EXC_ERROR;
1034: END IF;
1035: HZ_MATCH_RULE_39.find_party_details(
1036: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
1037: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
1038: -- Code for Match rule SAMPLE: SEARCH SIMILAR ORGANIZATION EXACT
1039: ELSIF p_rule_id=40 THEN

Line 1410: IF NOT HZ_MATCH_RULE_39.check_staged THEN

1406: p_rule_id,p_party_id,
1407: p_restrict_sql,p_match_type,p_dup_batch_id,p_search_merged,x_dup_set_id, x_search_ctx_id,x_num_matches);
1408: -- Code for Match rule SAMPLE: SEARCH ADDRESS ORGANIZATIONS EXACT
1409: ELSIF p_rule_id=39 THEN
1410: IF NOT HZ_MATCH_RULE_39.check_staged THEN
1411: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1412: FND_MSG_PUB.ADD;
1413: RAISE FND_API.G_EXC_ERROR;
1414: END IF;

Line 1415: HZ_MATCH_RULE_39.find_duplicate_parties(

1411: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1412: FND_MSG_PUB.ADD;
1413: RAISE FND_API.G_EXC_ERROR;
1414: END IF;
1415: HZ_MATCH_RULE_39.find_duplicate_parties(
1416: p_rule_id,p_party_id,
1417: p_restrict_sql,p_match_type,p_dup_batch_id,p_search_merged,x_dup_set_id, x_search_ctx_id,x_num_matches);
1418: -- Code for Match rule SAMPLE: SEARCH SIMILAR ORGANIZATION EXACT
1419: ELSIF p_rule_id=40 THEN

Line 1785: IF NOT HZ_MATCH_RULE_39.check_staged THEN

1781: p_rule_id,p_party_site_id,p_party_id,
1782: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
1783: -- Code for Match rule SAMPLE: SEARCH ADDRESS ORGANIZATIONS EXACT
1784: ELSIF p_rule_id=39 THEN
1785: IF NOT HZ_MATCH_RULE_39.check_staged THEN
1786: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1787: FND_MSG_PUB.ADD;
1788: RAISE FND_API.G_EXC_ERROR;
1789: END IF;

Line 1790: HZ_MATCH_RULE_39.find_duplicate_party_sites(

1786: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1787: FND_MSG_PUB.ADD;
1788: RAISE FND_API.G_EXC_ERROR;
1789: END IF;
1790: HZ_MATCH_RULE_39.find_duplicate_party_sites(
1791: p_rule_id,p_party_site_id,p_party_id,
1792: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
1793: -- Code for Match rule SAMPLE: SEARCH SIMILAR ORGANIZATION EXACT
1794: ELSIF p_rule_id=40 THEN

Line 2159: IF NOT HZ_MATCH_RULE_39.check_staged THEN

2155: p_rule_id,p_org_contact_id,p_party_id,
2156: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2157: -- Code for Match rule SAMPLE: SEARCH ADDRESS ORGANIZATIONS EXACT
2158: ELSIF p_rule_id=39 THEN
2159: IF NOT HZ_MATCH_RULE_39.check_staged THEN
2160: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2161: FND_MSG_PUB.ADD;
2162: RAISE FND_API.G_EXC_ERROR;
2163: END IF;

Line 2164: HZ_MATCH_RULE_39.find_duplicate_contacts(

2160: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2161: FND_MSG_PUB.ADD;
2162: RAISE FND_API.G_EXC_ERROR;
2163: END IF;
2164: HZ_MATCH_RULE_39.find_duplicate_contacts(
2165: p_rule_id,p_org_contact_id,p_party_id,
2166: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2167: -- Code for Match rule SAMPLE: SEARCH SIMILAR ORGANIZATION EXACT
2168: ELSIF p_rule_id=40 THEN

Line 2533: IF NOT HZ_MATCH_RULE_39.check_staged THEN

2529: p_rule_id,p_contact_point_id,p_party_id,
2530: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2531: -- Code for Match rule SAMPLE: SEARCH ADDRESS ORGANIZATIONS EXACT
2532: ELSIF p_rule_id=39 THEN
2533: IF NOT HZ_MATCH_RULE_39.check_staged THEN
2534: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2535: FND_MSG_PUB.ADD;
2536: RAISE FND_API.G_EXC_ERROR;
2537: END IF;

Line 2538: HZ_MATCH_RULE_39.find_duplicate_contact_points(

2534: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2535: FND_MSG_PUB.ADD;
2536: RAISE FND_API.G_EXC_ERROR;
2537: END IF;
2538: HZ_MATCH_RULE_39.find_duplicate_contact_points(
2539: p_rule_id,p_contact_point_id,p_party_id,
2540: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2541: -- Code for Match rule SAMPLE: SEARCH SIMILAR ORGANIZATION EXACT
2542: ELSIF p_rule_id=40 THEN

Line 3059: IF NOT HZ_MATCH_RULE_39.check_staged THEN

3055: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3056: p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
3057: -- Code for Match rule SAMPLE: SEARCH ADDRESS ORGANIZATIONS EXACT
3058: ELSIF p_rule_id=39 THEN
3059: IF NOT HZ_MATCH_RULE_39.check_staged THEN
3060: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3061: FND_MSG_PUB.ADD;
3062: RAISE FND_API.G_EXC_ERROR;
3063: END IF;

Line 3064: HZ_MATCH_RULE_39.find_parties_dynamic(

3060: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3061: FND_MSG_PUB.ADD;
3062: RAISE FND_API.G_EXC_ERROR;
3063: END IF;
3064: HZ_MATCH_RULE_39.find_parties_dynamic(
3065: p_rule_id,
3066: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
3067: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
3068: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 3706: IF NOT HZ_MATCH_RULE_39.check_staged THEN

3702: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3703: p_restrict_sql,p_api_name,p_match_type,p_party_id,p_search_merged,x_search_ctx_id,x_num_matches);
3704: -- Code for Match rule SAMPLE: SEARCH ADDRESS ORGANIZATIONS EXACT
3705: ELSIF p_rule_id=39 THEN
3706: IF NOT HZ_MATCH_RULE_39.check_staged THEN
3707: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3708: FND_MSG_PUB.ADD;
3709: RAISE FND_API.G_EXC_ERROR;
3710: END IF;

Line 3711: HZ_MATCH_RULE_39.call_api_dynamic(

3707: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3708: FND_MSG_PUB.ADD;
3709: RAISE FND_API.G_EXC_ERROR;
3710: END IF;
3711: HZ_MATCH_RULE_39.call_api_dynamic(
3712: p_rule_id,
3713: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
3714: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
3715: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 4432: IF NOT HZ_MATCH_RULE_39.check_staged THEN

4428: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4429: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4430: -- Code for Match rule SAMPLE: SEARCH ADDRESS ORGANIZATIONS EXACT
4431: ELSIF p_rule_id=39 THEN
4432: IF NOT HZ_MATCH_RULE_39.check_staged THEN
4433: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4434: FND_MSG_PUB.ADD;
4435: RAISE FND_API.G_EXC_ERROR;
4436: END IF;

Line 4437: HZ_MATCH_RULE_39.get_matching_party_sites(

4433: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4434: FND_MSG_PUB.ADD;
4435: RAISE FND_API.G_EXC_ERROR;
4436: END IF;
4437: HZ_MATCH_RULE_39.get_matching_party_sites(
4438: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4439: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4440: -- Code for Match rule SAMPLE: SEARCH SIMILAR ORGANIZATION EXACT
4441: ELSIF p_rule_id=40 THEN

Line 4831: IF NOT HZ_MATCH_RULE_39.check_staged THEN

4827: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
4828: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4829: -- Code for Match rule SAMPLE: SEARCH ADDRESS ORGANIZATIONS EXACT
4830: ELSIF p_rule_id=39 THEN
4831: IF NOT HZ_MATCH_RULE_39.check_staged THEN
4832: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4833: FND_MSG_PUB.ADD;
4834: RAISE FND_API.G_EXC_ERROR;
4835: END IF;

Line 4836: HZ_MATCH_RULE_39.get_matching_contacts(

4832: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4833: FND_MSG_PUB.ADD;
4834: RAISE FND_API.G_EXC_ERROR;
4835: END IF;
4836: HZ_MATCH_RULE_39.get_matching_contacts(
4837: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
4838: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4839: -- Code for Match rule SAMPLE: SEARCH SIMILAR ORGANIZATION EXACT
4840: ELSIF p_rule_id=40 THEN

Line 5228: IF NOT HZ_MATCH_RULE_39.check_staged THEN

5224: p_rule_id, p_party_id, p_contact_point_list,
5225: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5226: -- Code for Match rule SAMPLE: SEARCH ADDRESS ORGANIZATIONS EXACT
5227: ELSIF p_rule_id=39 THEN
5228: IF NOT HZ_MATCH_RULE_39.check_staged THEN
5229: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5230: FND_MSG_PUB.ADD;
5231: RAISE FND_API.G_EXC_ERROR;
5232: END IF;

Line 5233: HZ_MATCH_RULE_39.get_matching_contact_points(

5229: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5230: FND_MSG_PUB.ADD;
5231: RAISE FND_API.G_EXC_ERROR;
5232: END IF;
5233: HZ_MATCH_RULE_39.get_matching_contact_points(
5234: p_rule_id, p_party_id, p_contact_point_list,
5235: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5236: -- Code for Match rule SAMPLE: SEARCH SIMILAR ORGANIZATION EXACT
5237: ELSIF p_rule_id=40 THEN

Line 5642: IF NOT HZ_MATCH_RULE_39.check_staged THEN

5638: p_party_id, p_party_search_rec,p_party_site_list,
5639: p_contact_list, p_contact_point_list,x_search_ctx_id);
5640: -- Code for Match rule SAMPLE: SEARCH ADDRESS ORGANIZATIONS EXACT
5641: ELSIF p_rule_id=39 THEN
5642: IF NOT HZ_MATCH_RULE_39.check_staged THEN
5643: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5644: FND_MSG_PUB.ADD;
5645: RAISE FND_API.G_EXC_ERROR;
5646: END IF;

Line 5647: HZ_MATCH_RULE_39.get_score_details(

5643: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5644: FND_MSG_PUB.ADD;
5645: RAISE FND_API.G_EXC_ERROR;
5646: END IF;
5647: HZ_MATCH_RULE_39.get_score_details(
5648: p_rule_id,
5649: p_party_id, p_party_search_rec,p_party_site_list,
5650: p_contact_list, p_contact_point_list,x_search_ctx_id);
5651: -- Code for Match rule SAMPLE: SEARCH SIMILAR ORGANIZATION EXACT

Line 6026: IF NOT HZ_MATCH_RULE_39.check_staged THEN

6022: p_party_id, x_party_search_rec,x_party_site_list,
6023: x_contact_list, x_contact_point_list);
6024: -- Code for Match rule SAMPLE: SEARCH ADDRESS ORGANIZATIONS EXACT
6025: ELSIF p_rule_id=39 THEN
6026: IF NOT HZ_MATCH_RULE_39.check_staged THEN
6027: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6028: FND_MSG_PUB.ADD;
6029: RAISE FND_API.G_EXC_ERROR;
6030: END IF;

Line 6031: HZ_MATCH_RULE_39.get_party_for_search(

6027: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6028: FND_MSG_PUB.ADD;
6029: RAISE FND_API.G_EXC_ERROR;
6030: END IF;
6031: HZ_MATCH_RULE_39.get_party_for_search(
6032: p_party_id, x_party_search_rec,x_party_site_list,
6033: x_contact_list, x_contact_point_list);
6034: -- Code for Match rule SAMPLE: SEARCH SIMILAR ORGANIZATION EXACT
6035: ELSIF p_rule_id=40 THEN

Line 6398: IF NOT HZ_MATCH_RULE_39.check_staged THEN

6394: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6395: x_contact_list, x_contact_point_list);
6396: -- Code for Match rule SAMPLE: SEARCH ADDRESS ORGANIZATIONS EXACT
6397: ELSIF p_rule_id=39 THEN
6398: IF NOT HZ_MATCH_RULE_39.check_staged THEN
6399: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6400: FND_MSG_PUB.ADD;
6401: RAISE FND_API.G_EXC_ERROR;
6402: END IF;

Line 6403: HZ_MATCH_RULE_39.get_search_criteria(

6399: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6400: FND_MSG_PUB.ADD;
6401: RAISE FND_API.G_EXC_ERROR;
6402: END IF;
6403: HZ_MATCH_RULE_39.get_search_criteria(
6404: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6405: x_contact_list, x_contact_point_list);
6406: -- Code for Match rule SAMPLE: SEARCH SIMILAR ORGANIZATION EXACT
6407: ELSIF p_rule_id=40 THEN