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_58

Line 340: IF NOT HZ_MATCH_RULE_58.check_staged THEN

336: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
337: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,NULL,NULL,NULL,'N',x_search_ctx_id,x_num_matches);
338: -- Code for Match rule HZ_PERSON_SIMPLE_SEARCH_RULE
339: ELSIF p_rule_id=58 THEN
340: IF NOT HZ_MATCH_RULE_58.check_staged THEN
341: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
342: FND_MSG_PUB.ADD;
343: RAISE FND_API.G_EXC_ERROR;
344: END IF;

Line 345: HZ_MATCH_RULE_58.find_parties(

341: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
342: FND_MSG_PUB.ADD;
343: RAISE FND_API.G_EXC_ERROR;
344: END IF;
345: HZ_MATCH_RULE_58.find_parties(
346: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
347: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,NULL,NULL,NULL,'N',x_search_ctx_id,x_num_matches);
348: -- Code for Match rule HZ_PERSON_ADVANCED_SEARCH_MATCH_RULE
349: ELSIF p_rule_id=60 THEN

Line 721: IF NOT HZ_MATCH_RULE_58.check_staged THEN

717: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
718: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,'N',x_search_ctx_id,x_num_matches);
719: -- Code for Match rule HZ_PERSON_SIMPLE_SEARCH_RULE
720: ELSIF p_rule_id=58 THEN
721: IF NOT HZ_MATCH_RULE_58.check_staged THEN
722: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
723: FND_MSG_PUB.ADD;
724: RAISE FND_API.G_EXC_ERROR;
725: END IF;

Line 726: HZ_MATCH_RULE_58.find_persons(

722: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
723: FND_MSG_PUB.ADD;
724: RAISE FND_API.G_EXC_ERROR;
725: END IF;
726: HZ_MATCH_RULE_58.find_persons(
727: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
728: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,'N',x_search_ctx_id,x_num_matches);
729: -- Code for Match rule HZ_PERSON_ADVANCED_SEARCH_MATCH_RULE
730: ELSIF p_rule_id=60 THEN

Line 1120: IF NOT HZ_MATCH_RULE_58.check_staged THEN

1116: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
1117: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
1118: -- Code for Match rule HZ_PERSON_SIMPLE_SEARCH_RULE
1119: ELSIF p_rule_id=58 THEN
1120: IF NOT HZ_MATCH_RULE_58.check_staged THEN
1121: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1122: FND_MSG_PUB.ADD;
1123: RAISE FND_API.G_EXC_ERROR;
1124: END IF;

Line 1125: HZ_MATCH_RULE_58.find_party_details(

1121: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1122: FND_MSG_PUB.ADD;
1123: RAISE FND_API.G_EXC_ERROR;
1124: END IF;
1125: HZ_MATCH_RULE_58.find_party_details(
1126: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
1127: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
1128: -- Code for Match rule HZ_PERSON_ADVANCED_SEARCH_MATCH_RULE
1129: ELSIF p_rule_id=60 THEN

Line 1500: IF NOT HZ_MATCH_RULE_58.check_staged THEN

1496: p_rule_id,p_party_id,
1497: p_restrict_sql,p_match_type,p_dup_batch_id,p_search_merged,x_dup_set_id, x_search_ctx_id,x_num_matches);
1498: -- Code for Match rule HZ_PERSON_SIMPLE_SEARCH_RULE
1499: ELSIF p_rule_id=58 THEN
1500: IF NOT HZ_MATCH_RULE_58.check_staged THEN
1501: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1502: FND_MSG_PUB.ADD;
1503: RAISE FND_API.G_EXC_ERROR;
1504: END IF;

Line 1505: HZ_MATCH_RULE_58.find_duplicate_parties(

1501: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1502: FND_MSG_PUB.ADD;
1503: RAISE FND_API.G_EXC_ERROR;
1504: END IF;
1505: HZ_MATCH_RULE_58.find_duplicate_parties(
1506: p_rule_id,p_party_id,
1507: p_restrict_sql,p_match_type,p_dup_batch_id,p_search_merged,x_dup_set_id, x_search_ctx_id,x_num_matches);
1508: -- Code for Match rule HZ_PERSON_ADVANCED_SEARCH_MATCH_RULE
1509: ELSIF p_rule_id=60 THEN

Line 1875: IF NOT HZ_MATCH_RULE_58.check_staged THEN

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 HZ_PERSON_SIMPLE_SEARCH_RULE
1874: ELSIF p_rule_id=58 THEN
1875: IF NOT HZ_MATCH_RULE_58.check_staged THEN
1876: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1877: FND_MSG_PUB.ADD;
1878: RAISE FND_API.G_EXC_ERROR;
1879: END IF;

Line 1880: HZ_MATCH_RULE_58.find_duplicate_party_sites(

1876: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1877: FND_MSG_PUB.ADD;
1878: RAISE FND_API.G_EXC_ERROR;
1879: END IF;
1880: HZ_MATCH_RULE_58.find_duplicate_party_sites(
1881: p_rule_id,p_party_site_id,p_party_id,
1882: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
1883: -- Code for Match rule HZ_PERSON_ADVANCED_SEARCH_MATCH_RULE
1884: ELSIF p_rule_id=60 THEN

Line 2249: IF NOT HZ_MATCH_RULE_58.check_staged THEN

2245: p_rule_id,p_org_contact_id,p_party_id,
2246: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2247: -- Code for Match rule HZ_PERSON_SIMPLE_SEARCH_RULE
2248: ELSIF p_rule_id=58 THEN
2249: IF NOT HZ_MATCH_RULE_58.check_staged THEN
2250: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2251: FND_MSG_PUB.ADD;
2252: RAISE FND_API.G_EXC_ERROR;
2253: END IF;

Line 2254: HZ_MATCH_RULE_58.find_duplicate_contacts(

2250: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2251: FND_MSG_PUB.ADD;
2252: RAISE FND_API.G_EXC_ERROR;
2253: END IF;
2254: HZ_MATCH_RULE_58.find_duplicate_contacts(
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 HZ_PERSON_ADVANCED_SEARCH_MATCH_RULE
2258: ELSIF p_rule_id=60 THEN

Line 2623: IF NOT HZ_MATCH_RULE_58.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 HZ_PERSON_SIMPLE_SEARCH_RULE
2622: ELSIF p_rule_id=58 THEN
2623: IF NOT HZ_MATCH_RULE_58.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_58.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_58.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 HZ_PERSON_ADVANCED_SEARCH_MATCH_RULE
2632: ELSIF p_rule_id=60 THEN

Line 3221: IF NOT HZ_MATCH_RULE_58.check_staged THEN

3217: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3218: p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
3219: -- Code for Match rule HZ_PERSON_SIMPLE_SEARCH_RULE
3220: ELSIF p_rule_id=58 THEN
3221: IF NOT HZ_MATCH_RULE_58.check_staged THEN
3222: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3223: FND_MSG_PUB.ADD;
3224: RAISE FND_API.G_EXC_ERROR;
3225: END IF;

Line 3226: HZ_MATCH_RULE_58.find_parties_dynamic(

3222: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3223: FND_MSG_PUB.ADD;
3224: RAISE FND_API.G_EXC_ERROR;
3225: END IF;
3226: HZ_MATCH_RULE_58.find_parties_dynamic(
3227: p_rule_id,
3228: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
3229: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
3230: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 3868: IF NOT HZ_MATCH_RULE_58.check_staged THEN

3864: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3865: p_restrict_sql,p_api_name,p_match_type,p_party_id,p_search_merged,x_search_ctx_id,x_num_matches);
3866: -- Code for Match rule HZ_PERSON_SIMPLE_SEARCH_RULE
3867: ELSIF p_rule_id=58 THEN
3868: IF NOT HZ_MATCH_RULE_58.check_staged THEN
3869: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3870: FND_MSG_PUB.ADD;
3871: RAISE FND_API.G_EXC_ERROR;
3872: END IF;

Line 3873: HZ_MATCH_RULE_58.call_api_dynamic(

3869: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3870: FND_MSG_PUB.ADD;
3871: RAISE FND_API.G_EXC_ERROR;
3872: END IF;
3873: HZ_MATCH_RULE_58.call_api_dynamic(
3874: p_rule_id,
3875: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
3876: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
3877: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 4522: IF NOT HZ_MATCH_RULE_58.check_staged THEN

4518: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4519: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4520: -- Code for Match rule HZ_PERSON_SIMPLE_SEARCH_RULE
4521: ELSIF p_rule_id=58 THEN
4522: IF NOT HZ_MATCH_RULE_58.check_staged THEN
4523: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4524: FND_MSG_PUB.ADD;
4525: RAISE FND_API.G_EXC_ERROR;
4526: END IF;

Line 4527: HZ_MATCH_RULE_58.get_matching_party_sites(

4523: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4524: FND_MSG_PUB.ADD;
4525: RAISE FND_API.G_EXC_ERROR;
4526: END IF;
4527: HZ_MATCH_RULE_58.get_matching_party_sites(
4528: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4529: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4530: -- Code for Match rule HZ_PERSON_ADVANCED_SEARCH_MATCH_RULE
4531: ELSIF p_rule_id=60 THEN

Line 4921: IF NOT HZ_MATCH_RULE_58.check_staged THEN

4917: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
4918: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4919: -- Code for Match rule HZ_PERSON_SIMPLE_SEARCH_RULE
4920: ELSIF p_rule_id=58 THEN
4921: IF NOT HZ_MATCH_RULE_58.check_staged THEN
4922: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4923: FND_MSG_PUB.ADD;
4924: RAISE FND_API.G_EXC_ERROR;
4925: END IF;

Line 4926: HZ_MATCH_RULE_58.get_matching_contacts(

4922: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4923: FND_MSG_PUB.ADD;
4924: RAISE FND_API.G_EXC_ERROR;
4925: END IF;
4926: HZ_MATCH_RULE_58.get_matching_contacts(
4927: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
4928: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4929: -- Code for Match rule HZ_PERSON_ADVANCED_SEARCH_MATCH_RULE
4930: ELSIF p_rule_id=60 THEN

Line 5318: IF NOT HZ_MATCH_RULE_58.check_staged THEN

5314: p_rule_id, p_party_id, p_contact_point_list,
5315: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5316: -- Code for Match rule HZ_PERSON_SIMPLE_SEARCH_RULE
5317: ELSIF p_rule_id=58 THEN
5318: IF NOT HZ_MATCH_RULE_58.check_staged THEN
5319: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5320: FND_MSG_PUB.ADD;
5321: RAISE FND_API.G_EXC_ERROR;
5322: END IF;

Line 5323: HZ_MATCH_RULE_58.get_matching_contact_points(

5319: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5320: FND_MSG_PUB.ADD;
5321: RAISE FND_API.G_EXC_ERROR;
5322: END IF;
5323: HZ_MATCH_RULE_58.get_matching_contact_points(
5324: p_rule_id, p_party_id, p_contact_point_list,
5325: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5326: -- Code for Match rule HZ_PERSON_ADVANCED_SEARCH_MATCH_RULE
5327: ELSIF p_rule_id=60 THEN

Line 5741: IF NOT HZ_MATCH_RULE_58.check_staged THEN

5737: p_party_id, p_party_search_rec,p_party_site_list,
5738: p_contact_list, p_contact_point_list,x_search_ctx_id);
5739: -- Code for Match rule HZ_PERSON_SIMPLE_SEARCH_RULE
5740: ELSIF p_rule_id=58 THEN
5741: IF NOT HZ_MATCH_RULE_58.check_staged THEN
5742: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5743: FND_MSG_PUB.ADD;
5744: RAISE FND_API.G_EXC_ERROR;
5745: END IF;

Line 5746: HZ_MATCH_RULE_58.get_score_details(

5742: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5743: FND_MSG_PUB.ADD;
5744: RAISE FND_API.G_EXC_ERROR;
5745: END IF;
5746: HZ_MATCH_RULE_58.get_score_details(
5747: p_rule_id,
5748: p_party_id, p_party_search_rec,p_party_site_list,
5749: p_contact_list, p_contact_point_list,x_search_ctx_id);
5750: -- Code for Match rule HZ_PERSON_ADVANCED_SEARCH_MATCH_RULE

Line 6116: IF NOT HZ_MATCH_RULE_58.check_staged THEN

6112: p_party_id, x_party_search_rec,x_party_site_list,
6113: x_contact_list, x_contact_point_list);
6114: -- Code for Match rule HZ_PERSON_SIMPLE_SEARCH_RULE
6115: ELSIF p_rule_id=58 THEN
6116: IF NOT HZ_MATCH_RULE_58.check_staged THEN
6117: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6118: FND_MSG_PUB.ADD;
6119: RAISE FND_API.G_EXC_ERROR;
6120: END IF;

Line 6121: HZ_MATCH_RULE_58.get_party_for_search(

6117: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6118: FND_MSG_PUB.ADD;
6119: RAISE FND_API.G_EXC_ERROR;
6120: END IF;
6121: HZ_MATCH_RULE_58.get_party_for_search(
6122: p_party_id, x_party_search_rec,x_party_site_list,
6123: x_contact_list, x_contact_point_list);
6124: -- Code for Match rule HZ_PERSON_ADVANCED_SEARCH_MATCH_RULE
6125: ELSIF p_rule_id=60 THEN

Line 6488: IF NOT HZ_MATCH_RULE_58.check_staged THEN

6484: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6485: x_contact_list, x_contact_point_list);
6486: -- Code for Match rule HZ_PERSON_SIMPLE_SEARCH_RULE
6487: ELSIF p_rule_id=58 THEN
6488: IF NOT HZ_MATCH_RULE_58.check_staged THEN
6489: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6490: FND_MSG_PUB.ADD;
6491: RAISE FND_API.G_EXC_ERROR;
6492: END IF;

Line 6493: HZ_MATCH_RULE_58.get_search_criteria(

6489: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6490: FND_MSG_PUB.ADD;
6491: RAISE FND_API.G_EXC_ERROR;
6492: END IF;
6493: HZ_MATCH_RULE_58.get_search_criteria(
6494: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6495: x_contact_list, x_contact_point_list);
6496: -- Code for Match rule HZ_PERSON_ADVANCED_SEARCH_MATCH_RULE
6497: ELSIF p_rule_id=60 THEN