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_36

Line 220: IF NOT HZ_MATCH_RULE_36.check_staged THEN

216: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
217: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,NULL,NULL,NULL,'N',x_search_ctx_id,x_num_matches);
218: -- Code for Match rule DL ADDRESS AND RELATIONSHIP SEARCH
219: ELSIF p_rule_id=36 THEN
220: IF NOT HZ_MATCH_RULE_36.check_staged THEN
221: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
222: FND_MSG_PUB.ADD;
223: RAISE FND_API.G_EXC_ERROR;
224: END IF;

Line 225: HZ_MATCH_RULE_36.find_parties(

221: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
222: FND_MSG_PUB.ADD;
223: RAISE FND_API.G_EXC_ERROR;
224: END IF;
225: HZ_MATCH_RULE_36.find_parties(
226: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
227: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,NULL,NULL,NULL,'N',x_search_ctx_id,x_num_matches);
228: -- Code for Match rule DL ADDRESS DEFAULT
229: ELSIF p_rule_id=37 THEN

Line 621: IF NOT HZ_MATCH_RULE_36.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 ADDRESS AND RELATIONSHIP SEARCH
620: ELSIF p_rule_id=36 THEN
621: IF NOT HZ_MATCH_RULE_36.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_36.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_36.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 DL ADDRESS DEFAULT
630: ELSIF p_rule_id=37 THEN

Line 1040: IF NOT HZ_MATCH_RULE_36.check_staged THEN

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 DL ADDRESS AND RELATIONSHIP SEARCH
1039: ELSIF p_rule_id=36 THEN
1040: IF NOT HZ_MATCH_RULE_36.check_staged THEN
1041: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1042: FND_MSG_PUB.ADD;
1043: RAISE FND_API.G_EXC_ERROR;
1044: END IF;

Line 1045: HZ_MATCH_RULE_36.find_party_details(

1041: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1042: FND_MSG_PUB.ADD;
1043: RAISE FND_API.G_EXC_ERROR;
1044: END IF;
1045: HZ_MATCH_RULE_36.find_party_details(
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 DL ADDRESS DEFAULT
1049: ELSIF p_rule_id=37 THEN

Line 1440: IF NOT HZ_MATCH_RULE_36.check_staged THEN

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 DL ADDRESS AND RELATIONSHIP SEARCH
1439: ELSIF p_rule_id=36 THEN
1440: IF NOT HZ_MATCH_RULE_36.check_staged THEN
1441: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1442: FND_MSG_PUB.ADD;
1443: RAISE FND_API.G_EXC_ERROR;
1444: END IF;

Line 1445: HZ_MATCH_RULE_36.find_duplicate_parties(

1441: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1442: FND_MSG_PUB.ADD;
1443: RAISE FND_API.G_EXC_ERROR;
1444: END IF;
1445: HZ_MATCH_RULE_36.find_duplicate_parties(
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 ADDRESS DEFAULT
1449: ELSIF p_rule_id=37 THEN

Line 1835: IF NOT HZ_MATCH_RULE_36.check_staged THEN

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 DL ADDRESS AND RELATIONSHIP SEARCH
1834: ELSIF p_rule_id=36 THEN
1835: IF NOT HZ_MATCH_RULE_36.check_staged THEN
1836: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1837: FND_MSG_PUB.ADD;
1838: RAISE FND_API.G_EXC_ERROR;
1839: END IF;

Line 1840: HZ_MATCH_RULE_36.find_duplicate_party_sites(

1836: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1837: FND_MSG_PUB.ADD;
1838: RAISE FND_API.G_EXC_ERROR;
1839: END IF;
1840: HZ_MATCH_RULE_36.find_duplicate_party_sites(
1841: p_rule_id,p_party_site_id,p_party_id,
1842: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
1843: -- Code for Match rule DL ADDRESS DEFAULT
1844: ELSIF p_rule_id=37 THEN

Line 2229: IF NOT HZ_MATCH_RULE_36.check_staged THEN

2225: p_rule_id,p_org_contact_id,p_party_id,
2226: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2227: -- Code for Match rule DL ADDRESS AND RELATIONSHIP SEARCH
2228: ELSIF p_rule_id=36 THEN
2229: IF NOT HZ_MATCH_RULE_36.check_staged THEN
2230: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2231: FND_MSG_PUB.ADD;
2232: RAISE FND_API.G_EXC_ERROR;
2233: END IF;

Line 2234: HZ_MATCH_RULE_36.find_duplicate_contacts(

2230: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2231: FND_MSG_PUB.ADD;
2232: RAISE FND_API.G_EXC_ERROR;
2233: END IF;
2234: HZ_MATCH_RULE_36.find_duplicate_contacts(
2235: p_rule_id,p_org_contact_id,p_party_id,
2236: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2237: -- Code for Match rule DL ADDRESS DEFAULT
2238: ELSIF p_rule_id=37 THEN

Line 2623: IF NOT HZ_MATCH_RULE_36.check_staged THEN

2619: p_rule_id,p_contact_point_id,p_party_id,
2620: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2621: -- Code for Match rule DL ADDRESS AND RELATIONSHIP SEARCH
2622: ELSIF p_rule_id=36 THEN
2623: IF NOT HZ_MATCH_RULE_36.check_staged THEN
2624: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2625: FND_MSG_PUB.ADD;
2626: RAISE FND_API.G_EXC_ERROR;
2627: END IF;

Line 2628: HZ_MATCH_RULE_36.find_duplicate_contact_points(

2624: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2625: FND_MSG_PUB.ADD;
2626: RAISE FND_API.G_EXC_ERROR;
2627: END IF;
2628: HZ_MATCH_RULE_36.find_duplicate_contact_points(
2629: p_rule_id,p_contact_point_id,p_party_id,
2630: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2631: -- Code for Match rule DL ADDRESS DEFAULT
2632: ELSIF p_rule_id=37 THEN

Line 3145: IF NOT HZ_MATCH_RULE_36.check_staged THEN

3141: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3142: p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
3143: -- Code for Match rule DL ADDRESS AND RELATIONSHIP SEARCH
3144: ELSIF p_rule_id=36 THEN
3145: IF NOT HZ_MATCH_RULE_36.check_staged THEN
3146: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3147: FND_MSG_PUB.ADD;
3148: RAISE FND_API.G_EXC_ERROR;
3149: END IF;

Line 3150: HZ_MATCH_RULE_36.find_parties_dynamic(

3146: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3147: FND_MSG_PUB.ADD;
3148: RAISE FND_API.G_EXC_ERROR;
3149: END IF;
3150: HZ_MATCH_RULE_36.find_parties_dynamic(
3151: p_rule_id,
3152: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
3153: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
3154: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 3828: IF NOT HZ_MATCH_RULE_36.check_staged THEN

3824: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3825: p_restrict_sql,p_api_name,p_match_type,p_party_id,p_search_merged,x_search_ctx_id,x_num_matches);
3826: -- Code for Match rule DL ADDRESS AND RELATIONSHIP SEARCH
3827: ELSIF p_rule_id=36 THEN
3828: IF NOT HZ_MATCH_RULE_36.check_staged THEN
3829: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3830: FND_MSG_PUB.ADD;
3831: RAISE FND_API.G_EXC_ERROR;
3832: END IF;

Line 3833: HZ_MATCH_RULE_36.call_api_dynamic(

3829: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3830: FND_MSG_PUB.ADD;
3831: RAISE FND_API.G_EXC_ERROR;
3832: END IF;
3833: HZ_MATCH_RULE_36.call_api_dynamic(
3834: p_rule_id,
3835: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
3836: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
3837: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 4614: IF NOT HZ_MATCH_RULE_36.check_staged THEN

4610: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4611: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4612: -- Code for Match rule DL ADDRESS AND RELATIONSHIP SEARCH
4613: ELSIF p_rule_id=36 THEN
4614: IF NOT HZ_MATCH_RULE_36.check_staged THEN
4615: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4616: FND_MSG_PUB.ADD;
4617: RAISE FND_API.G_EXC_ERROR;
4618: END IF;

Line 4619: HZ_MATCH_RULE_36.get_matching_party_sites(

4615: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4616: FND_MSG_PUB.ADD;
4617: RAISE FND_API.G_EXC_ERROR;
4618: END IF;
4619: HZ_MATCH_RULE_36.get_matching_party_sites(
4620: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4621: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4622: -- Code for Match rule DL ADDRESS DEFAULT
4623: ELSIF p_rule_id=37 THEN

Line 5033: IF NOT HZ_MATCH_RULE_36.check_staged THEN

5029: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
5030: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5031: -- Code for Match rule DL ADDRESS AND RELATIONSHIP SEARCH
5032: ELSIF p_rule_id=36 THEN
5033: IF NOT HZ_MATCH_RULE_36.check_staged THEN
5034: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5035: FND_MSG_PUB.ADD;
5036: RAISE FND_API.G_EXC_ERROR;
5037: END IF;

Line 5038: HZ_MATCH_RULE_36.get_matching_contacts(

5034: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5035: FND_MSG_PUB.ADD;
5036: RAISE FND_API.G_EXC_ERROR;
5037: END IF;
5038: HZ_MATCH_RULE_36.get_matching_contacts(
5039: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
5040: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5041: -- Code for Match rule DL ADDRESS DEFAULT
5042: ELSIF p_rule_id=37 THEN

Line 5450: IF NOT HZ_MATCH_RULE_36.check_staged THEN

5446: p_rule_id, p_party_id, p_contact_point_list,
5447: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5448: -- Code for Match rule DL ADDRESS AND RELATIONSHIP SEARCH
5449: ELSIF p_rule_id=36 THEN
5450: IF NOT HZ_MATCH_RULE_36.check_staged THEN
5451: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5452: FND_MSG_PUB.ADD;
5453: RAISE FND_API.G_EXC_ERROR;
5454: END IF;

Line 5455: HZ_MATCH_RULE_36.get_matching_contact_points(

5451: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5452: FND_MSG_PUB.ADD;
5453: RAISE FND_API.G_EXC_ERROR;
5454: END IF;
5455: HZ_MATCH_RULE_36.get_matching_contact_points(
5456: p_rule_id, p_party_id, p_contact_point_list,
5457: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5458: -- Code for Match rule DL ADDRESS DEFAULT
5459: ELSIF p_rule_id=37 THEN

Line 5881: IF NOT HZ_MATCH_RULE_36.check_staged THEN

5877: p_party_id, p_party_search_rec,p_party_site_list,
5878: p_contact_list, p_contact_point_list,x_search_ctx_id);
5879: -- Code for Match rule DL ADDRESS AND RELATIONSHIP SEARCH
5880: ELSIF p_rule_id=36 THEN
5881: IF NOT HZ_MATCH_RULE_36.check_staged THEN
5882: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5883: FND_MSG_PUB.ADD;
5884: RAISE FND_API.G_EXC_ERROR;
5885: END IF;

Line 5886: HZ_MATCH_RULE_36.get_score_details(

5882: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5883: FND_MSG_PUB.ADD;
5884: RAISE FND_API.G_EXC_ERROR;
5885: END IF;
5886: HZ_MATCH_RULE_36.get_score_details(
5887: p_rule_id,
5888: p_party_id, p_party_search_rec,p_party_site_list,
5889: p_contact_list, p_contact_point_list,x_search_ctx_id);
5890: -- Code for Match rule DL ADDRESS DEFAULT

Line 6290: IF NOT HZ_MATCH_RULE_36.check_staged THEN

6286: p_party_id, x_party_search_rec,x_party_site_list,
6287: x_contact_list, x_contact_point_list);
6288: -- Code for Match rule DL ADDRESS AND RELATIONSHIP SEARCH
6289: ELSIF p_rule_id=36 THEN
6290: IF NOT HZ_MATCH_RULE_36.check_staged THEN
6291: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6292: FND_MSG_PUB.ADD;
6293: RAISE FND_API.G_EXC_ERROR;
6294: END IF;

Line 6295: HZ_MATCH_RULE_36.get_party_for_search(

6291: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6292: FND_MSG_PUB.ADD;
6293: RAISE FND_API.G_EXC_ERROR;
6294: END IF;
6295: HZ_MATCH_RULE_36.get_party_for_search(
6296: p_party_id, x_party_search_rec,x_party_site_list,
6297: x_contact_list, x_contact_point_list);
6298: -- Code for Match rule DL ADDRESS DEFAULT
6299: ELSIF p_rule_id=37 THEN

Line 6682: IF NOT HZ_MATCH_RULE_36.check_staged THEN

6678: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6679: x_contact_list, x_contact_point_list);
6680: -- Code for Match rule DL ADDRESS AND RELATIONSHIP SEARCH
6681: ELSIF p_rule_id=36 THEN
6682: IF NOT HZ_MATCH_RULE_36.check_staged THEN
6683: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6684: FND_MSG_PUB.ADD;
6685: RAISE FND_API.G_EXC_ERROR;
6686: END IF;

Line 6687: HZ_MATCH_RULE_36.get_search_criteria(

6683: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6684: FND_MSG_PUB.ADD;
6685: RAISE FND_API.G_EXC_ERROR;
6686: END IF;
6687: HZ_MATCH_RULE_36.get_search_criteria(
6688: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6689: x_contact_list, x_contact_point_list);
6690: -- Code for Match rule DL ADDRESS DEFAULT
6691: ELSIF p_rule_id=37 THEN