DBA Data[Home] [Help]

APPS.HZ_PARTY_SEARCH dependencies on HZ_MATCH_RULE_98

Line 380: IF NOT HZ_MATCH_RULE_98.check_staged THEN

376: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
377: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,NULL,NULL,NULL,'N',x_search_ctx_id,x_num_matches);
378: -- Code for Match rule HZ_CONTACT_SIMPLE_SEARCH_RULE
379: ELSIF p_rule_id=98 THEN
380: IF NOT HZ_MATCH_RULE_98.check_staged THEN
381: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
382: FND_MSG_PUB.ADD;
383: RAISE FND_API.G_EXC_ERROR;
384: END IF;

Line 385: HZ_MATCH_RULE_98.find_parties(

381: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
382: FND_MSG_PUB.ADD;
383: RAISE FND_API.G_EXC_ERROR;
384: END IF;
385: HZ_MATCH_RULE_98.find_parties(
386: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
387: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,NULL,NULL,NULL,'N',x_search_ctx_id,x_num_matches);
388: -- Code for Match rule HZ_CONTACT_ADV_SEARCH_MATCH_RULE
389: ELSIF p_rule_id=99 THEN

Line 761: IF NOT HZ_MATCH_RULE_98.check_staged THEN

757: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
758: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,'N',x_search_ctx_id,x_num_matches);
759: -- Code for Match rule HZ_CONTACT_SIMPLE_SEARCH_RULE
760: ELSIF p_rule_id=98 THEN
761: IF NOT HZ_MATCH_RULE_98.check_staged THEN
762: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
763: FND_MSG_PUB.ADD;
764: RAISE FND_API.G_EXC_ERROR;
765: END IF;

Line 766: HZ_MATCH_RULE_98.find_persons(

762: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
763: FND_MSG_PUB.ADD;
764: RAISE FND_API.G_EXC_ERROR;
765: END IF;
766: HZ_MATCH_RULE_98.find_persons(
767: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
768: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,'N',x_search_ctx_id,x_num_matches);
769: -- Code for Match rule HZ_CONTACT_ADV_SEARCH_MATCH_RULE
770: ELSIF p_rule_id=99 THEN

Line 1160: IF NOT HZ_MATCH_RULE_98.check_staged THEN

1156: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
1157: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
1158: -- Code for Match rule HZ_CONTACT_SIMPLE_SEARCH_RULE
1159: ELSIF p_rule_id=98 THEN
1160: IF NOT HZ_MATCH_RULE_98.check_staged THEN
1161: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1162: FND_MSG_PUB.ADD;
1163: RAISE FND_API.G_EXC_ERROR;
1164: END IF;

Line 1165: HZ_MATCH_RULE_98.find_party_details(

1161: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1162: FND_MSG_PUB.ADD;
1163: RAISE FND_API.G_EXC_ERROR;
1164: END IF;
1165: HZ_MATCH_RULE_98.find_party_details(
1166: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
1167: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
1168: -- Code for Match rule HZ_CONTACT_ADV_SEARCH_MATCH_RULE
1169: ELSIF p_rule_id=99 THEN

Line 1540: IF NOT HZ_MATCH_RULE_98.check_staged THEN

1536: p_rule_id,p_party_id,
1537: p_restrict_sql,p_match_type,p_dup_batch_id,p_search_merged,x_dup_set_id, x_search_ctx_id,x_num_matches);
1538: -- Code for Match rule HZ_CONTACT_SIMPLE_SEARCH_RULE
1539: ELSIF p_rule_id=98 THEN
1540: IF NOT HZ_MATCH_RULE_98.check_staged THEN
1541: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1542: FND_MSG_PUB.ADD;
1543: RAISE FND_API.G_EXC_ERROR;
1544: END IF;

Line 1545: HZ_MATCH_RULE_98.find_duplicate_parties(

1541: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1542: FND_MSG_PUB.ADD;
1543: RAISE FND_API.G_EXC_ERROR;
1544: END IF;
1545: HZ_MATCH_RULE_98.find_duplicate_parties(
1546: p_rule_id,p_party_id,
1547: p_restrict_sql,p_match_type,p_dup_batch_id,p_search_merged,x_dup_set_id, x_search_ctx_id,x_num_matches);
1548: -- Code for Match rule HZ_CONTACT_ADV_SEARCH_MATCH_RULE
1549: ELSIF p_rule_id=99 THEN

Line 1915: IF NOT HZ_MATCH_RULE_98.check_staged THEN

1911: p_rule_id,p_party_site_id,p_party_id,
1912: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
1913: -- Code for Match rule HZ_CONTACT_SIMPLE_SEARCH_RULE
1914: ELSIF p_rule_id=98 THEN
1915: IF NOT HZ_MATCH_RULE_98.check_staged THEN
1916: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1917: FND_MSG_PUB.ADD;
1918: RAISE FND_API.G_EXC_ERROR;
1919: END IF;

Line 1920: HZ_MATCH_RULE_98.find_duplicate_party_sites(

1916: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1917: FND_MSG_PUB.ADD;
1918: RAISE FND_API.G_EXC_ERROR;
1919: END IF;
1920: HZ_MATCH_RULE_98.find_duplicate_party_sites(
1921: p_rule_id,p_party_site_id,p_party_id,
1922: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
1923: -- Code for Match rule HZ_CONTACT_ADV_SEARCH_MATCH_RULE
1924: ELSIF p_rule_id=99 THEN

Line 2289: IF NOT HZ_MATCH_RULE_98.check_staged THEN

2285: p_rule_id,p_org_contact_id,p_party_id,
2286: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2287: -- Code for Match rule HZ_CONTACT_SIMPLE_SEARCH_RULE
2288: ELSIF p_rule_id=98 THEN
2289: IF NOT HZ_MATCH_RULE_98.check_staged THEN
2290: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2291: FND_MSG_PUB.ADD;
2292: RAISE FND_API.G_EXC_ERROR;
2293: END IF;

Line 2294: HZ_MATCH_RULE_98.find_duplicate_contacts(

2290: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2291: FND_MSG_PUB.ADD;
2292: RAISE FND_API.G_EXC_ERROR;
2293: END IF;
2294: HZ_MATCH_RULE_98.find_duplicate_contacts(
2295: p_rule_id,p_org_contact_id,p_party_id,
2296: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2297: -- Code for Match rule HZ_CONTACT_ADV_SEARCH_MATCH_RULE
2298: ELSIF p_rule_id=99 THEN

Line 2663: IF NOT HZ_MATCH_RULE_98.check_staged THEN

2659: p_rule_id,p_contact_point_id,p_party_id,
2660: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2661: -- Code for Match rule HZ_CONTACT_SIMPLE_SEARCH_RULE
2662: ELSIF p_rule_id=98 THEN
2663: IF NOT HZ_MATCH_RULE_98.check_staged THEN
2664: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2665: FND_MSG_PUB.ADD;
2666: RAISE FND_API.G_EXC_ERROR;
2667: END IF;

Line 2668: HZ_MATCH_RULE_98.find_duplicate_contact_points(

2664: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2665: FND_MSG_PUB.ADD;
2666: RAISE FND_API.G_EXC_ERROR;
2667: END IF;
2668: HZ_MATCH_RULE_98.find_duplicate_contact_points(
2669: p_rule_id,p_contact_point_id,p_party_id,
2670: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2671: -- Code for Match rule HZ_CONTACT_ADV_SEARCH_MATCH_RULE
2672: ELSIF p_rule_id=99 THEN

Line 3293: IF NOT HZ_MATCH_RULE_98.check_staged THEN

3289: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3290: p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
3291: -- Code for Match rule HZ_CONTACT_SIMPLE_SEARCH_RULE
3292: ELSIF p_rule_id=98 THEN
3293: IF NOT HZ_MATCH_RULE_98.check_staged THEN
3294: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3295: FND_MSG_PUB.ADD;
3296: RAISE FND_API.G_EXC_ERROR;
3297: END IF;

Line 3298: HZ_MATCH_RULE_98.find_parties_dynamic(

3294: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3295: FND_MSG_PUB.ADD;
3296: RAISE FND_API.G_EXC_ERROR;
3297: END IF;
3298: HZ_MATCH_RULE_98.find_parties_dynamic(
3299: p_rule_id,
3300: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
3301: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
3302: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 3940: IF NOT HZ_MATCH_RULE_98.check_staged THEN

3936: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3937: p_restrict_sql,p_api_name,p_match_type,p_party_id,p_search_merged,x_search_ctx_id,x_num_matches);
3938: -- Code for Match rule HZ_CONTACT_SIMPLE_SEARCH_RULE
3939: ELSIF p_rule_id=98 THEN
3940: IF NOT HZ_MATCH_RULE_98.check_staged THEN
3941: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3942: FND_MSG_PUB.ADD;
3943: RAISE FND_API.G_EXC_ERROR;
3944: END IF;

Line 3945: HZ_MATCH_RULE_98.call_api_dynamic(

3941: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3942: FND_MSG_PUB.ADD;
3943: RAISE FND_API.G_EXC_ERROR;
3944: END IF;
3945: HZ_MATCH_RULE_98.call_api_dynamic(
3946: p_rule_id,
3947: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
3948: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
3949: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 4562: IF NOT HZ_MATCH_RULE_98.check_staged THEN

4558: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4559: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4560: -- Code for Match rule HZ_CONTACT_SIMPLE_SEARCH_RULE
4561: ELSIF p_rule_id=98 THEN
4562: IF NOT HZ_MATCH_RULE_98.check_staged THEN
4563: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4564: FND_MSG_PUB.ADD;
4565: RAISE FND_API.G_EXC_ERROR;
4566: END IF;

Line 4567: HZ_MATCH_RULE_98.get_matching_party_sites(

4563: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4564: FND_MSG_PUB.ADD;
4565: RAISE FND_API.G_EXC_ERROR;
4566: END IF;
4567: HZ_MATCH_RULE_98.get_matching_party_sites(
4568: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4569: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4570: -- Code for Match rule HZ_CONTACT_ADV_SEARCH_MATCH_RULE
4571: ELSIF p_rule_id=99 THEN

Line 4961: IF NOT HZ_MATCH_RULE_98.check_staged THEN

4957: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
4958: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4959: -- Code for Match rule HZ_CONTACT_SIMPLE_SEARCH_RULE
4960: ELSIF p_rule_id=98 THEN
4961: IF NOT HZ_MATCH_RULE_98.check_staged THEN
4962: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4963: FND_MSG_PUB.ADD;
4964: RAISE FND_API.G_EXC_ERROR;
4965: END IF;

Line 4966: HZ_MATCH_RULE_98.get_matching_contacts(

4962: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4963: FND_MSG_PUB.ADD;
4964: RAISE FND_API.G_EXC_ERROR;
4965: END IF;
4966: HZ_MATCH_RULE_98.get_matching_contacts(
4967: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
4968: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4969: -- Code for Match rule HZ_CONTACT_ADV_SEARCH_MATCH_RULE
4970: ELSIF p_rule_id=99 THEN

Line 5358: IF NOT HZ_MATCH_RULE_98.check_staged THEN

5354: p_rule_id, p_party_id, p_contact_point_list,
5355: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5356: -- Code for Match rule HZ_CONTACT_SIMPLE_SEARCH_RULE
5357: ELSIF p_rule_id=98 THEN
5358: IF NOT HZ_MATCH_RULE_98.check_staged THEN
5359: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5360: FND_MSG_PUB.ADD;
5361: RAISE FND_API.G_EXC_ERROR;
5362: END IF;

Line 5363: HZ_MATCH_RULE_98.get_matching_contact_points(

5359: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5360: FND_MSG_PUB.ADD;
5361: RAISE FND_API.G_EXC_ERROR;
5362: END IF;
5363: HZ_MATCH_RULE_98.get_matching_contact_points(
5364: p_rule_id, p_party_id, p_contact_point_list,
5365: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5366: -- Code for Match rule HZ_CONTACT_ADV_SEARCH_MATCH_RULE
5367: ELSIF p_rule_id=99 THEN

Line 5785: IF NOT HZ_MATCH_RULE_98.check_staged THEN

5781: p_party_id, p_party_search_rec,p_party_site_list,
5782: p_contact_list, p_contact_point_list,x_search_ctx_id);
5783: -- Code for Match rule HZ_CONTACT_SIMPLE_SEARCH_RULE
5784: ELSIF p_rule_id=98 THEN
5785: IF NOT HZ_MATCH_RULE_98.check_staged THEN
5786: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5787: FND_MSG_PUB.ADD;
5788: RAISE FND_API.G_EXC_ERROR;
5789: END IF;

Line 5790: HZ_MATCH_RULE_98.get_score_details(

5786: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5787: FND_MSG_PUB.ADD;
5788: RAISE FND_API.G_EXC_ERROR;
5789: END IF;
5790: HZ_MATCH_RULE_98.get_score_details(
5791: p_rule_id,
5792: p_party_id, p_party_search_rec,p_party_site_list,
5793: p_contact_list, p_contact_point_list,x_search_ctx_id);
5794: -- Code for Match rule HZ_CONTACT_ADV_SEARCH_MATCH_RULE

Line 6156: IF NOT HZ_MATCH_RULE_98.check_staged THEN

6152: p_party_id, x_party_search_rec,x_party_site_list,
6153: x_contact_list, x_contact_point_list);
6154: -- Code for Match rule HZ_CONTACT_SIMPLE_SEARCH_RULE
6155: ELSIF p_rule_id=98 THEN
6156: IF NOT HZ_MATCH_RULE_98.check_staged THEN
6157: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6158: FND_MSG_PUB.ADD;
6159: RAISE FND_API.G_EXC_ERROR;
6160: END IF;

Line 6161: HZ_MATCH_RULE_98.get_party_for_search(

6157: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6158: FND_MSG_PUB.ADD;
6159: RAISE FND_API.G_EXC_ERROR;
6160: END IF;
6161: HZ_MATCH_RULE_98.get_party_for_search(
6162: p_party_id, x_party_search_rec,x_party_site_list,
6163: x_contact_list, x_contact_point_list);
6164: -- Code for Match rule HZ_CONTACT_ADV_SEARCH_MATCH_RULE
6165: ELSIF p_rule_id=99 THEN

Line 6528: IF NOT HZ_MATCH_RULE_98.check_staged THEN

6524: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6525: x_contact_list, x_contact_point_list);
6526: -- Code for Match rule HZ_CONTACT_SIMPLE_SEARCH_RULE
6527: ELSIF p_rule_id=98 THEN
6528: IF NOT HZ_MATCH_RULE_98.check_staged THEN
6529: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6530: FND_MSG_PUB.ADD;
6531: RAISE FND_API.G_EXC_ERROR;
6532: END IF;

Line 6533: HZ_MATCH_RULE_98.get_search_criteria(

6529: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6530: FND_MSG_PUB.ADD;
6531: RAISE FND_API.G_EXC_ERROR;
6532: END IF;
6533: HZ_MATCH_RULE_98.get_search_criteria(
6534: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6535: x_contact_list, x_contact_point_list);
6536: -- Code for Match rule HZ_CONTACT_ADV_SEARCH_MATCH_RULE
6537: ELSIF p_rule_id=99 THEN