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_38

Line 240: IF NOT HZ_MATCH_RULE_38.check_staged THEN

236: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
237: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,NULL,NULL,NULL,'N',x_search_ctx_id,x_num_matches);
238: -- Code for Match rule DL RELATIONSHIP DEFAULT
239: ELSIF p_rule_id=38 THEN
240: IF NOT HZ_MATCH_RULE_38.check_staged THEN
241: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
242: FND_MSG_PUB.ADD;
243: RAISE FND_API.G_EXC_ERROR;
244: END IF;

Line 245: HZ_MATCH_RULE_38.find_parties(

241: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
242: FND_MSG_PUB.ADD;
243: RAISE FND_API.G_EXC_ERROR;
244: END IF;
245: HZ_MATCH_RULE_38.find_parties(
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

Line 621: IF NOT HZ_MATCH_RULE_38.check_staged THEN

617: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
618: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,'N',x_search_ctx_id,x_num_matches);
619: -- Code for Match rule DL RELATIONSHIP DEFAULT
620: ELSIF p_rule_id=38 THEN
621: IF NOT HZ_MATCH_RULE_38.check_staged THEN
622: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
623: FND_MSG_PUB.ADD;
624: RAISE FND_API.G_EXC_ERROR;
625: END IF;

Line 626: HZ_MATCH_RULE_38.find_persons(

622: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
623: FND_MSG_PUB.ADD;
624: RAISE FND_API.G_EXC_ERROR;
625: END IF;
626: HZ_MATCH_RULE_38.find_persons(
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

Line 1020: IF NOT HZ_MATCH_RULE_38.check_staged THEN

1016: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
1017: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
1018: -- Code for Match rule DL RELATIONSHIP DEFAULT
1019: ELSIF p_rule_id=38 THEN
1020: IF NOT HZ_MATCH_RULE_38.check_staged THEN
1021: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1022: FND_MSG_PUB.ADD;
1023: RAISE FND_API.G_EXC_ERROR;
1024: END IF;

Line 1025: HZ_MATCH_RULE_38.find_party_details(

1021: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1022: FND_MSG_PUB.ADD;
1023: RAISE FND_API.G_EXC_ERROR;
1024: END IF;
1025: HZ_MATCH_RULE_38.find_party_details(
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

Line 1400: IF NOT HZ_MATCH_RULE_38.check_staged THEN

1396: p_rule_id,p_party_id,
1397: p_restrict_sql,p_match_type,p_dup_batch_id,p_search_merged,x_dup_set_id, x_search_ctx_id,x_num_matches);
1398: -- Code for Match rule DL RELATIONSHIP DEFAULT
1399: ELSIF p_rule_id=38 THEN
1400: IF NOT HZ_MATCH_RULE_38.check_staged THEN
1401: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1402: FND_MSG_PUB.ADD;
1403: RAISE FND_API.G_EXC_ERROR;
1404: END IF;

Line 1405: HZ_MATCH_RULE_38.find_duplicate_parties(

1401: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1402: FND_MSG_PUB.ADD;
1403: RAISE FND_API.G_EXC_ERROR;
1404: END IF;
1405: HZ_MATCH_RULE_38.find_duplicate_parties(
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

Line 1775: IF NOT HZ_MATCH_RULE_38.check_staged THEN

1771: p_rule_id,p_party_site_id,p_party_id,
1772: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
1773: -- Code for Match rule DL RELATIONSHIP DEFAULT
1774: ELSIF p_rule_id=38 THEN
1775: IF NOT HZ_MATCH_RULE_38.check_staged THEN
1776: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1777: FND_MSG_PUB.ADD;
1778: RAISE FND_API.G_EXC_ERROR;
1779: END IF;

Line 1780: HZ_MATCH_RULE_38.find_duplicate_party_sites(

1776: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1777: FND_MSG_PUB.ADD;
1778: RAISE FND_API.G_EXC_ERROR;
1779: END IF;
1780: HZ_MATCH_RULE_38.find_duplicate_party_sites(
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

Line 2149: IF NOT HZ_MATCH_RULE_38.check_staged THEN

2145: p_rule_id,p_org_contact_id,p_party_id,
2146: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2147: -- Code for Match rule DL RELATIONSHIP DEFAULT
2148: ELSIF p_rule_id=38 THEN
2149: IF NOT HZ_MATCH_RULE_38.check_staged THEN
2150: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2151: FND_MSG_PUB.ADD;
2152: RAISE FND_API.G_EXC_ERROR;
2153: END IF;

Line 2154: HZ_MATCH_RULE_38.find_duplicate_contacts(

2150: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2151: FND_MSG_PUB.ADD;
2152: RAISE FND_API.G_EXC_ERROR;
2153: END IF;
2154: HZ_MATCH_RULE_38.find_duplicate_contacts(
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

Line 2523: IF NOT HZ_MATCH_RULE_38.check_staged THEN

2519: p_rule_id,p_contact_point_id,p_party_id,
2520: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2521: -- Code for Match rule DL RELATIONSHIP DEFAULT
2522: ELSIF p_rule_id=38 THEN
2523: IF NOT HZ_MATCH_RULE_38.check_staged THEN
2524: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2525: FND_MSG_PUB.ADD;
2526: RAISE FND_API.G_EXC_ERROR;
2527: END IF;

Line 2528: HZ_MATCH_RULE_38.find_duplicate_contact_points(

2524: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2525: FND_MSG_PUB.ADD;
2526: RAISE FND_API.G_EXC_ERROR;
2527: END IF;
2528: HZ_MATCH_RULE_38.find_duplicate_contact_points(
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

Line 3041: IF NOT HZ_MATCH_RULE_38.check_staged THEN

3037: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3038: p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
3039: -- Code for Match rule DL RELATIONSHIP DEFAULT
3040: ELSIF p_rule_id=38 THEN
3041: IF NOT HZ_MATCH_RULE_38.check_staged THEN
3042: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3043: FND_MSG_PUB.ADD;
3044: RAISE FND_API.G_EXC_ERROR;
3045: END IF;

Line 3046: HZ_MATCH_RULE_38.find_parties_dynamic(

3042: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3043: FND_MSG_PUB.ADD;
3044: RAISE FND_API.G_EXC_ERROR;
3045: END IF;
3046: HZ_MATCH_RULE_38.find_parties_dynamic(
3047: p_rule_id,
3048: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
3049: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
3050: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 3688: IF NOT HZ_MATCH_RULE_38.check_staged THEN

3684: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3685: p_restrict_sql,p_api_name,p_match_type,p_party_id,p_search_merged,x_search_ctx_id,x_num_matches);
3686: -- Code for Match rule DL RELATIONSHIP DEFAULT
3687: ELSIF p_rule_id=38 THEN
3688: IF NOT HZ_MATCH_RULE_38.check_staged THEN
3689: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3690: FND_MSG_PUB.ADD;
3691: RAISE FND_API.G_EXC_ERROR;
3692: END IF;

Line 3693: HZ_MATCH_RULE_38.call_api_dynamic(

3689: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3690: FND_MSG_PUB.ADD;
3691: RAISE FND_API.G_EXC_ERROR;
3692: END IF;
3693: HZ_MATCH_RULE_38.call_api_dynamic(
3694: p_rule_id,
3695: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
3696: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
3697: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 4422: IF NOT HZ_MATCH_RULE_38.check_staged THEN

4418: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4419: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4420: -- Code for Match rule DL RELATIONSHIP DEFAULT
4421: ELSIF p_rule_id=38 THEN
4422: IF NOT HZ_MATCH_RULE_38.check_staged THEN
4423: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4424: FND_MSG_PUB.ADD;
4425: RAISE FND_API.G_EXC_ERROR;
4426: END IF;

Line 4427: HZ_MATCH_RULE_38.get_matching_party_sites(

4423: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4424: FND_MSG_PUB.ADD;
4425: RAISE FND_API.G_EXC_ERROR;
4426: END IF;
4427: HZ_MATCH_RULE_38.get_matching_party_sites(
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

Line 4821: IF NOT HZ_MATCH_RULE_38.check_staged THEN

4817: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
4818: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4819: -- Code for Match rule DL RELATIONSHIP DEFAULT
4820: ELSIF p_rule_id=38 THEN
4821: IF NOT HZ_MATCH_RULE_38.check_staged THEN
4822: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4823: FND_MSG_PUB.ADD;
4824: RAISE FND_API.G_EXC_ERROR;
4825: END IF;

Line 4826: HZ_MATCH_RULE_38.get_matching_contacts(

4822: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4823: FND_MSG_PUB.ADD;
4824: RAISE FND_API.G_EXC_ERROR;
4825: END IF;
4826: HZ_MATCH_RULE_38.get_matching_contacts(
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

Line 5218: IF NOT HZ_MATCH_RULE_38.check_staged THEN

5214: p_rule_id, p_party_id, p_contact_point_list,
5215: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5216: -- Code for Match rule DL RELATIONSHIP DEFAULT
5217: ELSIF p_rule_id=38 THEN
5218: IF NOT HZ_MATCH_RULE_38.check_staged THEN
5219: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5220: FND_MSG_PUB.ADD;
5221: RAISE FND_API.G_EXC_ERROR;
5222: END IF;

Line 5223: HZ_MATCH_RULE_38.get_matching_contact_points(

5219: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5220: FND_MSG_PUB.ADD;
5221: RAISE FND_API.G_EXC_ERROR;
5222: END IF;
5223: HZ_MATCH_RULE_38.get_matching_contact_points(
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

Line 5631: IF NOT HZ_MATCH_RULE_38.check_staged THEN

5627: p_party_id, p_party_search_rec,p_party_site_list,
5628: p_contact_list, p_contact_point_list,x_search_ctx_id);
5629: -- Code for Match rule DL RELATIONSHIP DEFAULT
5630: ELSIF p_rule_id=38 THEN
5631: IF NOT HZ_MATCH_RULE_38.check_staged THEN
5632: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5633: FND_MSG_PUB.ADD;
5634: RAISE FND_API.G_EXC_ERROR;
5635: END IF;

Line 5636: HZ_MATCH_RULE_38.get_score_details(

5632: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5633: FND_MSG_PUB.ADD;
5634: RAISE FND_API.G_EXC_ERROR;
5635: END IF;
5636: HZ_MATCH_RULE_38.get_score_details(
5637: p_rule_id,
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

Line 6016: IF NOT HZ_MATCH_RULE_38.check_staged THEN

6012: p_party_id, x_party_search_rec,x_party_site_list,
6013: x_contact_list, x_contact_point_list);
6014: -- Code for Match rule DL RELATIONSHIP DEFAULT
6015: ELSIF p_rule_id=38 THEN
6016: IF NOT HZ_MATCH_RULE_38.check_staged THEN
6017: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6018: FND_MSG_PUB.ADD;
6019: RAISE FND_API.G_EXC_ERROR;
6020: END IF;

Line 6021: HZ_MATCH_RULE_38.get_party_for_search(

6017: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6018: FND_MSG_PUB.ADD;
6019: RAISE FND_API.G_EXC_ERROR;
6020: END IF;
6021: HZ_MATCH_RULE_38.get_party_for_search(
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

Line 6388: IF NOT HZ_MATCH_RULE_38.check_staged THEN

6384: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6385: x_contact_list, x_contact_point_list);
6386: -- Code for Match rule DL RELATIONSHIP DEFAULT
6387: ELSIF p_rule_id=38 THEN
6388: IF NOT HZ_MATCH_RULE_38.check_staged THEN
6389: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6390: FND_MSG_PUB.ADD;
6391: RAISE FND_API.G_EXC_ERROR;
6392: END IF;

Line 6393: HZ_MATCH_RULE_38.get_search_criteria(

6389: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6390: FND_MSG_PUB.ADD;
6391: RAISE FND_API.G_EXC_ERROR;
6392: END IF;
6393: HZ_MATCH_RULE_38.get_search_criteria(
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