DBA Data[Home] [Help]

APPS.HZ_PARTY_SEARCH dependencies on HZ_MATCH_RULE_8

Line 170: IF NOT HZ_MATCH_RULE_8.check_staged THEN

166: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
167: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,NULL,NULL,NULL,'N',x_search_ctx_id,x_num_matches);
168: -- Code for Match rule SAMPLE: SEARCH
169: ELSIF p_rule_id=8 THEN
170: IF NOT HZ_MATCH_RULE_8.check_staged THEN
171: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
172: FND_MSG_PUB.ADD;
173: RAISE FND_API.G_EXC_ERROR;
174: END IF;

Line 175: HZ_MATCH_RULE_8.find_parties(

171: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
172: FND_MSG_PUB.ADD;
173: RAISE FND_API.G_EXC_ERROR;
174: END IF;
175: HZ_MATCH_RULE_8.find_parties(
176: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
177: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,NULL,NULL,NULL,'N',x_search_ctx_id,x_num_matches);
178: -- Code for Match rule RM SEARCH RULE
179: ELSIF p_rule_id=32 THEN

Line 551: IF NOT HZ_MATCH_RULE_8.check_staged THEN

547: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
548: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,'N',x_search_ctx_id,x_num_matches);
549: -- Code for Match rule SAMPLE: SEARCH
550: ELSIF p_rule_id=8 THEN
551: IF NOT HZ_MATCH_RULE_8.check_staged THEN
552: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
553: FND_MSG_PUB.ADD;
554: RAISE FND_API.G_EXC_ERROR;
555: END IF;

Line 556: HZ_MATCH_RULE_8.find_persons(

552: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
553: FND_MSG_PUB.ADD;
554: RAISE FND_API.G_EXC_ERROR;
555: END IF;
556: HZ_MATCH_RULE_8.find_persons(
557: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
558: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,'N',x_search_ctx_id,x_num_matches);
559: -- Code for Match rule RM SEARCH RULE
560: ELSIF p_rule_id=32 THEN

Line 950: IF NOT HZ_MATCH_RULE_8.check_staged THEN

946: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
947: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
948: -- Code for Match rule SAMPLE: SEARCH
949: ELSIF p_rule_id=8 THEN
950: IF NOT HZ_MATCH_RULE_8.check_staged THEN
951: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
952: FND_MSG_PUB.ADD;
953: RAISE FND_API.G_EXC_ERROR;
954: END IF;

Line 955: HZ_MATCH_RULE_8.find_party_details(

951: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
952: FND_MSG_PUB.ADD;
953: RAISE FND_API.G_EXC_ERROR;
954: END IF;
955: HZ_MATCH_RULE_8.find_party_details(
956: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
957: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
958: -- Code for Match rule RM SEARCH RULE
959: ELSIF p_rule_id=32 THEN

Line 1330: IF NOT HZ_MATCH_RULE_8.check_staged THEN

1326: p_rule_id,p_party_id,
1327: p_restrict_sql,p_match_type,p_dup_batch_id,p_search_merged,x_dup_set_id, x_search_ctx_id,x_num_matches);
1328: -- Code for Match rule SAMPLE: SEARCH
1329: ELSIF p_rule_id=8 THEN
1330: IF NOT HZ_MATCH_RULE_8.check_staged THEN
1331: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1332: FND_MSG_PUB.ADD;
1333: RAISE FND_API.G_EXC_ERROR;
1334: END IF;

Line 1335: HZ_MATCH_RULE_8.find_duplicate_parties(

1331: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1332: FND_MSG_PUB.ADD;
1333: RAISE FND_API.G_EXC_ERROR;
1334: END IF;
1335: HZ_MATCH_RULE_8.find_duplicate_parties(
1336: p_rule_id,p_party_id,
1337: p_restrict_sql,p_match_type,p_dup_batch_id,p_search_merged,x_dup_set_id, x_search_ctx_id,x_num_matches);
1338: -- Code for Match rule RM SEARCH RULE
1339: ELSIF p_rule_id=32 THEN

Line 1705: IF NOT HZ_MATCH_RULE_8.check_staged THEN

1701: p_rule_id,p_party_site_id,p_party_id,
1702: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
1703: -- Code for Match rule SAMPLE: SEARCH
1704: ELSIF p_rule_id=8 THEN
1705: IF NOT HZ_MATCH_RULE_8.check_staged THEN
1706: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1707: FND_MSG_PUB.ADD;
1708: RAISE FND_API.G_EXC_ERROR;
1709: END IF;

Line 1710: HZ_MATCH_RULE_8.find_duplicate_party_sites(

1706: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1707: FND_MSG_PUB.ADD;
1708: RAISE FND_API.G_EXC_ERROR;
1709: END IF;
1710: HZ_MATCH_RULE_8.find_duplicate_party_sites(
1711: p_rule_id,p_party_site_id,p_party_id,
1712: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
1713: -- Code for Match rule RM SEARCH RULE
1714: ELSIF p_rule_id=32 THEN

Line 2079: IF NOT HZ_MATCH_RULE_8.check_staged THEN

2075: p_rule_id,p_org_contact_id,p_party_id,
2076: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2077: -- Code for Match rule SAMPLE: SEARCH
2078: ELSIF p_rule_id=8 THEN
2079: IF NOT HZ_MATCH_RULE_8.check_staged THEN
2080: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2081: FND_MSG_PUB.ADD;
2082: RAISE FND_API.G_EXC_ERROR;
2083: END IF;

Line 2084: HZ_MATCH_RULE_8.find_duplicate_contacts(

2080: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2081: FND_MSG_PUB.ADD;
2082: RAISE FND_API.G_EXC_ERROR;
2083: END IF;
2084: HZ_MATCH_RULE_8.find_duplicate_contacts(
2085: p_rule_id,p_org_contact_id,p_party_id,
2086: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2087: -- Code for Match rule RM SEARCH RULE
2088: ELSIF p_rule_id=32 THEN

Line 2453: IF NOT HZ_MATCH_RULE_8.check_staged THEN

2449: p_rule_id,p_contact_point_id,p_party_id,
2450: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2451: -- Code for Match rule SAMPLE: SEARCH
2452: ELSIF p_rule_id=8 THEN
2453: IF NOT HZ_MATCH_RULE_8.check_staged THEN
2454: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2455: FND_MSG_PUB.ADD;
2456: RAISE FND_API.G_EXC_ERROR;
2457: END IF;

Line 2458: HZ_MATCH_RULE_8.find_duplicate_contact_points(

2454: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2455: FND_MSG_PUB.ADD;
2456: RAISE FND_API.G_EXC_ERROR;
2457: END IF;
2458: HZ_MATCH_RULE_8.find_duplicate_contact_points(
2459: p_rule_id,p_contact_point_id,p_party_id,
2460: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2461: -- Code for Match rule RM SEARCH RULE
2462: ELSIF p_rule_id=32 THEN

Line 2915: IF NOT HZ_MATCH_RULE_8.check_staged THEN

2911: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
2912: p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
2913: -- Code for Match rule SAMPLE: SEARCH
2914: ELSIF p_rule_id=8 THEN
2915: IF NOT HZ_MATCH_RULE_8.check_staged THEN
2916: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2917: FND_MSG_PUB.ADD;
2918: RAISE FND_API.G_EXC_ERROR;
2919: END IF;

Line 2920: HZ_MATCH_RULE_8.find_parties_dynamic(

2916: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2917: FND_MSG_PUB.ADD;
2918: RAISE FND_API.G_EXC_ERROR;
2919: END IF;
2920: HZ_MATCH_RULE_8.find_parties_dynamic(
2921: p_rule_id,
2922: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
2923: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
2924: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 3562: IF NOT HZ_MATCH_RULE_8.check_staged THEN

3558: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3559: p_restrict_sql,p_api_name,p_match_type,p_party_id,p_search_merged,x_search_ctx_id,x_num_matches);
3560: -- Code for Match rule SAMPLE: SEARCH
3561: ELSIF p_rule_id=8 THEN
3562: IF NOT HZ_MATCH_RULE_8.check_staged THEN
3563: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3564: FND_MSG_PUB.ADD;
3565: RAISE FND_API.G_EXC_ERROR;
3566: END IF;

Line 3567: HZ_MATCH_RULE_8.call_api_dynamic(

3563: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3564: FND_MSG_PUB.ADD;
3565: RAISE FND_API.G_EXC_ERROR;
3566: END IF;
3567: HZ_MATCH_RULE_8.call_api_dynamic(
3568: p_rule_id,
3569: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
3570: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
3571: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 4352: IF NOT HZ_MATCH_RULE_8.check_staged THEN

4348: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4349: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4350: -- Code for Match rule SAMPLE: SEARCH
4351: ELSIF p_rule_id=8 THEN
4352: IF NOT HZ_MATCH_RULE_8.check_staged THEN
4353: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4354: FND_MSG_PUB.ADD;
4355: RAISE FND_API.G_EXC_ERROR;
4356: END IF;

Line 4357: HZ_MATCH_RULE_8.get_matching_party_sites(

4353: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4354: FND_MSG_PUB.ADD;
4355: RAISE FND_API.G_EXC_ERROR;
4356: END IF;
4357: HZ_MATCH_RULE_8.get_matching_party_sites(
4358: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4359: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4360: -- Code for Match rule RM SEARCH RULE
4361: ELSIF p_rule_id=32 THEN

Line 4751: IF NOT HZ_MATCH_RULE_8.check_staged THEN

4747: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
4748: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4749: -- Code for Match rule SAMPLE: SEARCH
4750: ELSIF p_rule_id=8 THEN
4751: IF NOT HZ_MATCH_RULE_8.check_staged THEN
4752: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4753: FND_MSG_PUB.ADD;
4754: RAISE FND_API.G_EXC_ERROR;
4755: END IF;

Line 4756: HZ_MATCH_RULE_8.get_matching_contacts(

4752: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4753: FND_MSG_PUB.ADD;
4754: RAISE FND_API.G_EXC_ERROR;
4755: END IF;
4756: HZ_MATCH_RULE_8.get_matching_contacts(
4757: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
4758: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4759: -- Code for Match rule RM SEARCH RULE
4760: ELSIF p_rule_id=32 THEN

Line 5148: IF NOT HZ_MATCH_RULE_8.check_staged THEN

5144: p_rule_id, p_party_id, p_contact_point_list,
5145: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5146: -- Code for Match rule SAMPLE: SEARCH
5147: ELSIF p_rule_id=8 THEN
5148: IF NOT HZ_MATCH_RULE_8.check_staged THEN
5149: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5150: FND_MSG_PUB.ADD;
5151: RAISE FND_API.G_EXC_ERROR;
5152: END IF;

Line 5153: HZ_MATCH_RULE_8.get_matching_contact_points(

5149: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5150: FND_MSG_PUB.ADD;
5151: RAISE FND_API.G_EXC_ERROR;
5152: END IF;
5153: HZ_MATCH_RULE_8.get_matching_contact_points(
5154: p_rule_id, p_party_id, p_contact_point_list,
5155: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5156: -- Code for Match rule RM SEARCH RULE
5157: ELSIF p_rule_id=32 THEN

Line 5554: IF NOT HZ_MATCH_RULE_8.check_staged THEN

5550: p_party_id, p_party_search_rec,p_party_site_list,
5551: p_contact_list, p_contact_point_list,x_search_ctx_id);
5552: -- Code for Match rule SAMPLE: SEARCH
5553: ELSIF p_rule_id=8 THEN
5554: IF NOT HZ_MATCH_RULE_8.check_staged THEN
5555: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5556: FND_MSG_PUB.ADD;
5557: RAISE FND_API.G_EXC_ERROR;
5558: END IF;

Line 5559: HZ_MATCH_RULE_8.get_score_details(

5555: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5556: FND_MSG_PUB.ADD;
5557: RAISE FND_API.G_EXC_ERROR;
5558: END IF;
5559: HZ_MATCH_RULE_8.get_score_details(
5560: p_rule_id,
5561: p_party_id, p_party_search_rec,p_party_site_list,
5562: p_contact_list, p_contact_point_list,x_search_ctx_id);
5563: -- Code for Match rule RM SEARCH RULE

Line 5946: IF NOT HZ_MATCH_RULE_8.check_staged THEN

5942: p_party_id, x_party_search_rec,x_party_site_list,
5943: x_contact_list, x_contact_point_list);
5944: -- Code for Match rule SAMPLE: SEARCH
5945: ELSIF p_rule_id=8 THEN
5946: IF NOT HZ_MATCH_RULE_8.check_staged THEN
5947: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5948: FND_MSG_PUB.ADD;
5949: RAISE FND_API.G_EXC_ERROR;
5950: END IF;

Line 5951: HZ_MATCH_RULE_8.get_party_for_search(

5947: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5948: FND_MSG_PUB.ADD;
5949: RAISE FND_API.G_EXC_ERROR;
5950: END IF;
5951: HZ_MATCH_RULE_8.get_party_for_search(
5952: p_party_id, x_party_search_rec,x_party_site_list,
5953: x_contact_list, x_contact_point_list);
5954: -- Code for Match rule RM SEARCH RULE
5955: ELSIF p_rule_id=32 THEN

Line 6318: IF NOT HZ_MATCH_RULE_8.check_staged THEN

6314: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6315: x_contact_list, x_contact_point_list);
6316: -- Code for Match rule SAMPLE: SEARCH
6317: ELSIF p_rule_id=8 THEN
6318: IF NOT HZ_MATCH_RULE_8.check_staged THEN
6319: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6320: FND_MSG_PUB.ADD;
6321: RAISE FND_API.G_EXC_ERROR;
6322: END IF;

Line 6323: HZ_MATCH_RULE_8.get_search_criteria(

6319: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6320: FND_MSG_PUB.ADD;
6321: RAISE FND_API.G_EXC_ERROR;
6322: END IF;
6323: HZ_MATCH_RULE_8.get_search_criteria(
6324: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6325: x_contact_list, x_contact_point_list);
6326: -- Code for Match rule RM SEARCH RULE
6327: ELSIF p_rule_id=32 THEN