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 601: IF NOT HZ_MATCH_RULE_36.check_staged THEN

597: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
598: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,'N',x_search_ctx_id,x_num_matches);
599: -- Code for Match rule DL ADDRESS AND RELATIONSHIP SEARCH
600: ELSIF p_rule_id=36 THEN
601: IF NOT HZ_MATCH_RULE_36.check_staged THEN
602: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
603: FND_MSG_PUB.ADD;
604: RAISE FND_API.G_EXC_ERROR;
605: END IF;

Line 606: HZ_MATCH_RULE_36.find_persons(

602: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
603: FND_MSG_PUB.ADD;
604: RAISE FND_API.G_EXC_ERROR;
605: END IF;
606: HZ_MATCH_RULE_36.find_persons(
607: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
608: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,'N',x_search_ctx_id,x_num_matches);
609: -- Code for Match rule DL ADDRESS DEFAULT
610: ELSIF p_rule_id=37 THEN

Line 1000: IF NOT HZ_MATCH_RULE_36.check_staged THEN

996: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
997: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
998: -- Code for Match rule DL ADDRESS AND RELATIONSHIP SEARCH
999: ELSIF p_rule_id=36 THEN
1000: IF NOT HZ_MATCH_RULE_36.check_staged THEN
1001: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1002: FND_MSG_PUB.ADD;
1003: RAISE FND_API.G_EXC_ERROR;
1004: END IF;

Line 1005: HZ_MATCH_RULE_36.find_party_details(

1001: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1002: FND_MSG_PUB.ADD;
1003: RAISE FND_API.G_EXC_ERROR;
1004: END IF;
1005: HZ_MATCH_RULE_36.find_party_details(
1006: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
1007: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
1008: -- Code for Match rule DL ADDRESS DEFAULT
1009: ELSIF p_rule_id=37 THEN

Line 1380: IF NOT HZ_MATCH_RULE_36.check_staged THEN

1376: p_rule_id,p_party_id,
1377: p_restrict_sql,p_match_type,p_dup_batch_id,p_search_merged,x_dup_set_id, x_search_ctx_id,x_num_matches);
1378: -- Code for Match rule DL ADDRESS AND RELATIONSHIP SEARCH
1379: ELSIF p_rule_id=36 THEN
1380: IF NOT HZ_MATCH_RULE_36.check_staged THEN
1381: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1382: FND_MSG_PUB.ADD;
1383: RAISE FND_API.G_EXC_ERROR;
1384: END IF;

Line 1385: HZ_MATCH_RULE_36.find_duplicate_parties(

1381: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1382: FND_MSG_PUB.ADD;
1383: RAISE FND_API.G_EXC_ERROR;
1384: END IF;
1385: HZ_MATCH_RULE_36.find_duplicate_parties(
1386: p_rule_id,p_party_id,
1387: p_restrict_sql,p_match_type,p_dup_batch_id,p_search_merged,x_dup_set_id, x_search_ctx_id,x_num_matches);
1388: -- Code for Match rule DL ADDRESS DEFAULT
1389: ELSIF p_rule_id=37 THEN

Line 1755: IF NOT HZ_MATCH_RULE_36.check_staged THEN

1751: p_rule_id,p_party_site_id,p_party_id,
1752: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
1753: -- Code for Match rule DL ADDRESS AND RELATIONSHIP SEARCH
1754: ELSIF p_rule_id=36 THEN
1755: IF NOT HZ_MATCH_RULE_36.check_staged THEN
1756: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1757: FND_MSG_PUB.ADD;
1758: RAISE FND_API.G_EXC_ERROR;
1759: END IF;

Line 1760: HZ_MATCH_RULE_36.find_duplicate_party_sites(

1756: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1757: FND_MSG_PUB.ADD;
1758: RAISE FND_API.G_EXC_ERROR;
1759: END IF;
1760: HZ_MATCH_RULE_36.find_duplicate_party_sites(
1761: p_rule_id,p_party_site_id,p_party_id,
1762: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
1763: -- Code for Match rule DL ADDRESS DEFAULT
1764: ELSIF p_rule_id=37 THEN

Line 2129: IF NOT HZ_MATCH_RULE_36.check_staged THEN

2125: p_rule_id,p_org_contact_id,p_party_id,
2126: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2127: -- Code for Match rule DL ADDRESS AND RELATIONSHIP SEARCH
2128: ELSIF p_rule_id=36 THEN
2129: IF NOT HZ_MATCH_RULE_36.check_staged THEN
2130: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2131: FND_MSG_PUB.ADD;
2132: RAISE FND_API.G_EXC_ERROR;
2133: END IF;

Line 2134: HZ_MATCH_RULE_36.find_duplicate_contacts(

2130: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2131: FND_MSG_PUB.ADD;
2132: RAISE FND_API.G_EXC_ERROR;
2133: END IF;
2134: HZ_MATCH_RULE_36.find_duplicate_contacts(
2135: p_rule_id,p_org_contact_id,p_party_id,
2136: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2137: -- Code for Match rule DL ADDRESS DEFAULT
2138: ELSIF p_rule_id=37 THEN

Line 2503: IF NOT HZ_MATCH_RULE_36.check_staged THEN

2499: p_rule_id,p_contact_point_id,p_party_id,
2500: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2501: -- Code for Match rule DL ADDRESS AND RELATIONSHIP SEARCH
2502: ELSIF p_rule_id=36 THEN
2503: IF NOT HZ_MATCH_RULE_36.check_staged THEN
2504: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2505: FND_MSG_PUB.ADD;
2506: RAISE FND_API.G_EXC_ERROR;
2507: END IF;

Line 2508: HZ_MATCH_RULE_36.find_duplicate_contact_points(

2504: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2505: FND_MSG_PUB.ADD;
2506: RAISE FND_API.G_EXC_ERROR;
2507: END IF;
2508: HZ_MATCH_RULE_36.find_duplicate_contact_points(
2509: p_rule_id,p_contact_point_id,p_party_id,
2510: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2511: -- Code for Match rule DL ADDRESS DEFAULT
2512: ELSIF p_rule_id=37 THEN

Line 3005: IF NOT HZ_MATCH_RULE_36.check_staged THEN

3001: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3002: p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
3003: -- Code for Match rule DL ADDRESS AND RELATIONSHIP SEARCH
3004: ELSIF p_rule_id=36 THEN
3005: IF NOT HZ_MATCH_RULE_36.check_staged THEN
3006: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3007: FND_MSG_PUB.ADD;
3008: RAISE FND_API.G_EXC_ERROR;
3009: END IF;

Line 3010: HZ_MATCH_RULE_36.find_parties_dynamic(

3006: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3007: FND_MSG_PUB.ADD;
3008: RAISE FND_API.G_EXC_ERROR;
3009: END IF;
3010: HZ_MATCH_RULE_36.find_parties_dynamic(
3011: p_rule_id,
3012: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
3013: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
3014: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 3652: IF NOT HZ_MATCH_RULE_36.check_staged THEN

3648: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3649: p_restrict_sql,p_api_name,p_match_type,p_party_id,p_search_merged,x_search_ctx_id,x_num_matches);
3650: -- Code for Match rule DL ADDRESS AND RELATIONSHIP SEARCH
3651: ELSIF p_rule_id=36 THEN
3652: IF NOT HZ_MATCH_RULE_36.check_staged THEN
3653: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3654: FND_MSG_PUB.ADD;
3655: RAISE FND_API.G_EXC_ERROR;
3656: END IF;

Line 3657: HZ_MATCH_RULE_36.call_api_dynamic(

3653: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3654: FND_MSG_PUB.ADD;
3655: RAISE FND_API.G_EXC_ERROR;
3656: END IF;
3657: HZ_MATCH_RULE_36.call_api_dynamic(
3658: p_rule_id,
3659: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
3660: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
3661: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 4402: IF NOT HZ_MATCH_RULE_36.check_staged THEN

4398: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4399: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4400: -- Code for Match rule DL ADDRESS AND RELATIONSHIP SEARCH
4401: ELSIF p_rule_id=36 THEN
4402: IF NOT HZ_MATCH_RULE_36.check_staged THEN
4403: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4404: FND_MSG_PUB.ADD;
4405: RAISE FND_API.G_EXC_ERROR;
4406: END IF;

Line 4407: HZ_MATCH_RULE_36.get_matching_party_sites(

4403: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4404: FND_MSG_PUB.ADD;
4405: RAISE FND_API.G_EXC_ERROR;
4406: END IF;
4407: HZ_MATCH_RULE_36.get_matching_party_sites(
4408: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4409: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4410: -- Code for Match rule DL ADDRESS DEFAULT
4411: ELSIF p_rule_id=37 THEN

Line 4801: IF NOT HZ_MATCH_RULE_36.check_staged THEN

4797: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
4798: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4799: -- Code for Match rule DL ADDRESS AND RELATIONSHIP SEARCH
4800: ELSIF p_rule_id=36 THEN
4801: IF NOT HZ_MATCH_RULE_36.check_staged THEN
4802: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4803: FND_MSG_PUB.ADD;
4804: RAISE FND_API.G_EXC_ERROR;
4805: END IF;

Line 4806: HZ_MATCH_RULE_36.get_matching_contacts(

4802: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4803: FND_MSG_PUB.ADD;
4804: RAISE FND_API.G_EXC_ERROR;
4805: END IF;
4806: HZ_MATCH_RULE_36.get_matching_contacts(
4807: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
4808: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4809: -- Code for Match rule DL ADDRESS DEFAULT
4810: ELSIF p_rule_id=37 THEN

Line 5198: IF NOT HZ_MATCH_RULE_36.check_staged THEN

5194: p_rule_id, p_party_id, p_contact_point_list,
5195: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5196: -- Code for Match rule DL ADDRESS AND RELATIONSHIP SEARCH
5197: ELSIF p_rule_id=36 THEN
5198: IF NOT HZ_MATCH_RULE_36.check_staged THEN
5199: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5200: FND_MSG_PUB.ADD;
5201: RAISE FND_API.G_EXC_ERROR;
5202: END IF;

Line 5203: HZ_MATCH_RULE_36.get_matching_contact_points(

5199: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5200: FND_MSG_PUB.ADD;
5201: RAISE FND_API.G_EXC_ERROR;
5202: END IF;
5203: HZ_MATCH_RULE_36.get_matching_contact_points(
5204: p_rule_id, p_party_id, p_contact_point_list,
5205: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5206: -- Code for Match rule DL ADDRESS DEFAULT
5207: ELSIF p_rule_id=37 THEN

Line 5609: IF NOT HZ_MATCH_RULE_36.check_staged THEN

5605: p_party_id, p_party_search_rec,p_party_site_list,
5606: p_contact_list, p_contact_point_list,x_search_ctx_id);
5607: -- Code for Match rule DL ADDRESS AND RELATIONSHIP SEARCH
5608: ELSIF p_rule_id=36 THEN
5609: IF NOT HZ_MATCH_RULE_36.check_staged THEN
5610: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5611: FND_MSG_PUB.ADD;
5612: RAISE FND_API.G_EXC_ERROR;
5613: END IF;

Line 5614: HZ_MATCH_RULE_36.get_score_details(

5610: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5611: FND_MSG_PUB.ADD;
5612: RAISE FND_API.G_EXC_ERROR;
5613: END IF;
5614: HZ_MATCH_RULE_36.get_score_details(
5615: p_rule_id,
5616: p_party_id, p_party_search_rec,p_party_site_list,
5617: p_contact_list, p_contact_point_list,x_search_ctx_id);
5618: -- Code for Match rule DL ADDRESS DEFAULT

Line 5996: IF NOT HZ_MATCH_RULE_36.check_staged THEN

5992: p_party_id, x_party_search_rec,x_party_site_list,
5993: x_contact_list, x_contact_point_list);
5994: -- Code for Match rule DL ADDRESS AND RELATIONSHIP SEARCH
5995: ELSIF p_rule_id=36 THEN
5996: IF NOT HZ_MATCH_RULE_36.check_staged THEN
5997: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5998: FND_MSG_PUB.ADD;
5999: RAISE FND_API.G_EXC_ERROR;
6000: END IF;

Line 6001: HZ_MATCH_RULE_36.get_party_for_search(

5997: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5998: FND_MSG_PUB.ADD;
5999: RAISE FND_API.G_EXC_ERROR;
6000: END IF;
6001: HZ_MATCH_RULE_36.get_party_for_search(
6002: p_party_id, x_party_search_rec,x_party_site_list,
6003: x_contact_list, x_contact_point_list);
6004: -- Code for Match rule DL ADDRESS DEFAULT
6005: ELSIF p_rule_id=37 THEN

Line 6368: IF NOT HZ_MATCH_RULE_36.check_staged THEN

6364: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6365: x_contact_list, x_contact_point_list);
6366: -- Code for Match rule DL ADDRESS AND RELATIONSHIP SEARCH
6367: ELSIF p_rule_id=36 THEN
6368: IF NOT HZ_MATCH_RULE_36.check_staged THEN
6369: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6370: FND_MSG_PUB.ADD;
6371: RAISE FND_API.G_EXC_ERROR;
6372: END IF;

Line 6373: HZ_MATCH_RULE_36.get_search_criteria(

6369: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6370: FND_MSG_PUB.ADD;
6371: RAISE FND_API.G_EXC_ERROR;
6372: END IF;
6373: HZ_MATCH_RULE_36.get_search_criteria(
6374: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6375: x_contact_list, x_contact_point_list);
6376: -- Code for Match rule DL ADDRESS DEFAULT
6377: ELSIF p_rule_id=37 THEN