DBA Data[Home] [Help]

APPS.HZ_PARTY_SEARCH dependencies on HZ_MATCH_RULE_7

Line 160: IF NOT HZ_MATCH_RULE_7.check_staged THEN

156: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
157: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,NULL,NULL,NULL,'N',x_search_ctx_id,x_num_matches);
158: -- Code for Match rule SAMPLE: SIMILAR_PERSON
159: ELSIF p_rule_id=7 THEN
160: IF NOT HZ_MATCH_RULE_7.check_staged THEN
161: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
162: FND_MSG_PUB.ADD;
163: RAISE FND_API.G_EXC_ERROR;
164: END IF;

Line 165: HZ_MATCH_RULE_7.find_parties(

161: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
162: FND_MSG_PUB.ADD;
163: RAISE FND_API.G_EXC_ERROR;
164: END IF;
165: HZ_MATCH_RULE_7.find_parties(
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

Line 561: IF NOT HZ_MATCH_RULE_7.check_staged THEN

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 SAMPLE: SIMILAR_PERSON
560: ELSIF p_rule_id=7 THEN
561: IF NOT HZ_MATCH_RULE_7.check_staged THEN
562: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
563: FND_MSG_PUB.ADD;
564: RAISE FND_API.G_EXC_ERROR;
565: END IF;

Line 566: HZ_MATCH_RULE_7.find_persons(

562: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
563: FND_MSG_PUB.ADD;
564: RAISE FND_API.G_EXC_ERROR;
565: END IF;
566: HZ_MATCH_RULE_7.find_persons(
567: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
568: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,'N',x_search_ctx_id,x_num_matches);
569: -- Code for Match rule SAMPLE: SEARCH
570: ELSIF p_rule_id=8 THEN

Line 980: IF NOT HZ_MATCH_RULE_7.check_staged THEN

976: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
977: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
978: -- Code for Match rule SAMPLE: SIMILAR_PERSON
979: ELSIF p_rule_id=7 THEN
980: IF NOT HZ_MATCH_RULE_7.check_staged THEN
981: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
982: FND_MSG_PUB.ADD;
983: RAISE FND_API.G_EXC_ERROR;
984: END IF;

Line 985: HZ_MATCH_RULE_7.find_party_details(

981: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
982: FND_MSG_PUB.ADD;
983: RAISE FND_API.G_EXC_ERROR;
984: END IF;
985: HZ_MATCH_RULE_7.find_party_details(
986: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
987: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
988: -- Code for Match rule SAMPLE: SEARCH
989: ELSIF p_rule_id=8 THEN

Line 1380: IF NOT HZ_MATCH_RULE_7.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 SAMPLE: SIMILAR_PERSON
1379: ELSIF p_rule_id=7 THEN
1380: IF NOT HZ_MATCH_RULE_7.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_7.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_7.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 SAMPLE: SEARCH
1389: ELSIF p_rule_id=8 THEN

Line 1775: IF NOT HZ_MATCH_RULE_7.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 SAMPLE: SIMILAR_PERSON
1774: ELSIF p_rule_id=7 THEN
1775: IF NOT HZ_MATCH_RULE_7.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_7.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_7.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
1784: ELSIF p_rule_id=8 THEN

Line 2169: IF NOT HZ_MATCH_RULE_7.check_staged THEN

2165: p_rule_id,p_org_contact_id,p_party_id,
2166: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2167: -- Code for Match rule SAMPLE: SIMILAR_PERSON
2168: ELSIF p_rule_id=7 THEN
2169: IF NOT HZ_MATCH_RULE_7.check_staged THEN
2170: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2171: FND_MSG_PUB.ADD;
2172: RAISE FND_API.G_EXC_ERROR;
2173: END IF;

Line 2174: HZ_MATCH_RULE_7.find_duplicate_contacts(

2170: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2171: FND_MSG_PUB.ADD;
2172: RAISE FND_API.G_EXC_ERROR;
2173: END IF;
2174: HZ_MATCH_RULE_7.find_duplicate_contacts(
2175: p_rule_id,p_org_contact_id,p_party_id,
2176: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2177: -- Code for Match rule SAMPLE: SEARCH
2178: ELSIF p_rule_id=8 THEN

Line 2563: IF NOT HZ_MATCH_RULE_7.check_staged THEN

2559: p_rule_id,p_contact_point_id,p_party_id,
2560: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2561: -- Code for Match rule SAMPLE: SIMILAR_PERSON
2562: ELSIF p_rule_id=7 THEN
2563: IF NOT HZ_MATCH_RULE_7.check_staged THEN
2564: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2565: FND_MSG_PUB.ADD;
2566: RAISE FND_API.G_EXC_ERROR;
2567: END IF;

Line 2568: HZ_MATCH_RULE_7.find_duplicate_contact_points(

2564: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2565: FND_MSG_PUB.ADD;
2566: RAISE FND_API.G_EXC_ERROR;
2567: END IF;
2568: HZ_MATCH_RULE_7.find_duplicate_contact_points(
2569: p_rule_id,p_contact_point_id,p_party_id,
2570: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2571: -- Code for Match rule SAMPLE: SEARCH
2572: ELSIF p_rule_id=8 THEN

Line 3037: IF NOT HZ_MATCH_RULE_7.check_staged THEN

3033: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3034: p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
3035: -- Code for Match rule SAMPLE: SIMILAR_PERSON
3036: ELSIF p_rule_id=7 THEN
3037: IF NOT HZ_MATCH_RULE_7.check_staged THEN
3038: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3039: FND_MSG_PUB.ADD;
3040: RAISE FND_API.G_EXC_ERROR;
3041: END IF;

Line 3042: HZ_MATCH_RULE_7.find_parties_dynamic(

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

Line 3720: IF NOT HZ_MATCH_RULE_7.check_staged THEN

3716: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3717: p_restrict_sql,p_api_name,p_match_type,p_party_id,p_search_merged,x_search_ctx_id,x_num_matches);
3718: -- Code for Match rule SAMPLE: SIMILAR_PERSON
3719: ELSIF p_rule_id=7 THEN
3720: IF NOT HZ_MATCH_RULE_7.check_staged THEN
3721: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3722: FND_MSG_PUB.ADD;
3723: RAISE FND_API.G_EXC_ERROR;
3724: END IF;

Line 3725: HZ_MATCH_RULE_7.call_api_dynamic(

3721: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3722: FND_MSG_PUB.ADD;
3723: RAISE FND_API.G_EXC_ERROR;
3724: END IF;
3725: HZ_MATCH_RULE_7.call_api_dynamic(
3726: p_rule_id,
3727: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
3728: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
3729: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 4554: IF NOT HZ_MATCH_RULE_7.check_staged THEN

4550: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4551: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4552: -- Code for Match rule SAMPLE: SIMILAR_PERSON
4553: ELSIF p_rule_id=7 THEN
4554: IF NOT HZ_MATCH_RULE_7.check_staged THEN
4555: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4556: FND_MSG_PUB.ADD;
4557: RAISE FND_API.G_EXC_ERROR;
4558: END IF;

Line 4559: HZ_MATCH_RULE_7.get_matching_party_sites(

4555: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4556: FND_MSG_PUB.ADD;
4557: RAISE FND_API.G_EXC_ERROR;
4558: END IF;
4559: HZ_MATCH_RULE_7.get_matching_party_sites(
4560: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4561: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4562: -- Code for Match rule SAMPLE: SEARCH
4563: ELSIF p_rule_id=8 THEN

Line 4973: IF NOT HZ_MATCH_RULE_7.check_staged THEN

4969: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
4970: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4971: -- Code for Match rule SAMPLE: SIMILAR_PERSON
4972: ELSIF p_rule_id=7 THEN
4973: IF NOT HZ_MATCH_RULE_7.check_staged THEN
4974: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4975: FND_MSG_PUB.ADD;
4976: RAISE FND_API.G_EXC_ERROR;
4977: END IF;

Line 4978: HZ_MATCH_RULE_7.get_matching_contacts(

4974: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4975: FND_MSG_PUB.ADD;
4976: RAISE FND_API.G_EXC_ERROR;
4977: END IF;
4978: HZ_MATCH_RULE_7.get_matching_contacts(
4979: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
4980: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4981: -- Code for Match rule SAMPLE: SEARCH
4982: ELSIF p_rule_id=8 THEN

Line 5390: IF NOT HZ_MATCH_RULE_7.check_staged THEN

5386: p_rule_id, p_party_id, p_contact_point_list,
5387: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5388: -- Code for Match rule SAMPLE: SIMILAR_PERSON
5389: ELSIF p_rule_id=7 THEN
5390: IF NOT HZ_MATCH_RULE_7.check_staged THEN
5391: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5392: FND_MSG_PUB.ADD;
5393: RAISE FND_API.G_EXC_ERROR;
5394: END IF;

Line 5395: HZ_MATCH_RULE_7.get_matching_contact_points(

5391: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5392: FND_MSG_PUB.ADD;
5393: RAISE FND_API.G_EXC_ERROR;
5394: END IF;
5395: HZ_MATCH_RULE_7.get_matching_contact_points(
5396: p_rule_id, p_party_id, p_contact_point_list,
5397: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5398: -- Code for Match rule SAMPLE: SEARCH
5399: ELSIF p_rule_id=8 THEN

Line 5815: IF NOT HZ_MATCH_RULE_7.check_staged THEN

5811: p_party_id, p_party_search_rec,p_party_site_list,
5812: p_contact_list, p_contact_point_list,x_search_ctx_id);
5813: -- Code for Match rule SAMPLE: SIMILAR_PERSON
5814: ELSIF p_rule_id=7 THEN
5815: IF NOT HZ_MATCH_RULE_7.check_staged THEN
5816: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5817: FND_MSG_PUB.ADD;
5818: RAISE FND_API.G_EXC_ERROR;
5819: END IF;

Line 5820: HZ_MATCH_RULE_7.get_score_details(

5816: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5817: FND_MSG_PUB.ADD;
5818: RAISE FND_API.G_EXC_ERROR;
5819: END IF;
5820: HZ_MATCH_RULE_7.get_score_details(
5821: p_rule_id,
5822: p_party_id, p_party_search_rec,p_party_site_list,
5823: p_contact_list, p_contact_point_list,x_search_ctx_id);
5824: -- Code for Match rule SAMPLE: SEARCH

Line 6230: IF NOT HZ_MATCH_RULE_7.check_staged THEN

6226: p_party_id, x_party_search_rec,x_party_site_list,
6227: x_contact_list, x_contact_point_list);
6228: -- Code for Match rule SAMPLE: SIMILAR_PERSON
6229: ELSIF p_rule_id=7 THEN
6230: IF NOT HZ_MATCH_RULE_7.check_staged THEN
6231: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6232: FND_MSG_PUB.ADD;
6233: RAISE FND_API.G_EXC_ERROR;
6234: END IF;

Line 6235: HZ_MATCH_RULE_7.get_party_for_search(

6231: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6232: FND_MSG_PUB.ADD;
6233: RAISE FND_API.G_EXC_ERROR;
6234: END IF;
6235: HZ_MATCH_RULE_7.get_party_for_search(
6236: p_party_id, x_party_search_rec,x_party_site_list,
6237: x_contact_list, x_contact_point_list);
6238: -- Code for Match rule SAMPLE: SEARCH
6239: ELSIF p_rule_id=8 THEN

Line 6622: IF NOT HZ_MATCH_RULE_7.check_staged THEN

6618: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6619: x_contact_list, x_contact_point_list);
6620: -- Code for Match rule SAMPLE: SIMILAR_PERSON
6621: ELSIF p_rule_id=7 THEN
6622: IF NOT HZ_MATCH_RULE_7.check_staged THEN
6623: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6624: FND_MSG_PUB.ADD;
6625: RAISE FND_API.G_EXC_ERROR;
6626: END IF;

Line 6627: HZ_MATCH_RULE_7.get_search_criteria(

6623: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6624: FND_MSG_PUB.ADD;
6625: RAISE FND_API.G_EXC_ERROR;
6626: END IF;
6627: HZ_MATCH_RULE_7.get_search_criteria(
6628: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6629: x_contact_list, x_contact_point_list);
6630: -- Code for Match rule SAMPLE: SEARCH
6631: ELSIF p_rule_id=8 THEN