DBA Data[Home] [Help]

APPS.HZ_PARTY_SEARCH dependencies on HZ_MATCH_RULE_50

Line 300: IF NOT HZ_MATCH_RULE_50.check_staged THEN

296: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
297: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,NULL,NULL,NULL,'N',x_search_ctx_id,x_num_matches);
298: -- Code for Match rule BULK MATCH: IDENTICAL ORGANIZATIONS
299: ELSIF p_rule_id=50 THEN
300: IF NOT HZ_MATCH_RULE_50.check_staged THEN
301: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
302: FND_MSG_PUB.ADD;
303: RAISE FND_API.G_EXC_ERROR;
304: END IF;

Line 305: HZ_MATCH_RULE_50.find_parties(

301: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
302: FND_MSG_PUB.ADD;
303: RAISE FND_API.G_EXC_ERROR;
304: END IF;
305: HZ_MATCH_RULE_50.find_parties(
306: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
307: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,NULL,NULL,NULL,'N',x_search_ctx_id,x_num_matches);
308: -- Code for Match rule BULK MATCH: IDENTICAL PERSONS
309: ELSIF p_rule_id=51 THEN

Line 701: IF NOT HZ_MATCH_RULE_50.check_staged THEN

697: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
698: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,'N',x_search_ctx_id,x_num_matches);
699: -- Code for Match rule BULK MATCH: IDENTICAL ORGANIZATIONS
700: ELSIF p_rule_id=50 THEN
701: IF NOT HZ_MATCH_RULE_50.check_staged THEN
702: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
703: FND_MSG_PUB.ADD;
704: RAISE FND_API.G_EXC_ERROR;
705: END IF;

Line 706: HZ_MATCH_RULE_50.find_persons(

702: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
703: FND_MSG_PUB.ADD;
704: RAISE FND_API.G_EXC_ERROR;
705: END IF;
706: HZ_MATCH_RULE_50.find_persons(
707: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
708: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,'N',x_search_ctx_id,x_num_matches);
709: -- Code for Match rule BULK MATCH: IDENTICAL PERSONS
710: ELSIF p_rule_id=51 THEN

Line 1120: IF NOT HZ_MATCH_RULE_50.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 BULK MATCH: IDENTICAL ORGANIZATIONS
1119: ELSIF p_rule_id=50 THEN
1120: IF NOT HZ_MATCH_RULE_50.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_50.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_50.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 BULK MATCH: IDENTICAL PERSONS
1129: ELSIF p_rule_id=51 THEN

Line 1520: IF NOT HZ_MATCH_RULE_50.check_staged THEN

1516: p_rule_id,p_party_id,
1517: p_restrict_sql,p_match_type,p_dup_batch_id,p_search_merged,x_dup_set_id, x_search_ctx_id,x_num_matches);
1518: -- Code for Match rule BULK MATCH: IDENTICAL ORGANIZATIONS
1519: ELSIF p_rule_id=50 THEN
1520: IF NOT HZ_MATCH_RULE_50.check_staged THEN
1521: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1522: FND_MSG_PUB.ADD;
1523: RAISE FND_API.G_EXC_ERROR;
1524: END IF;

Line 1525: HZ_MATCH_RULE_50.find_duplicate_parties(

1521: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1522: FND_MSG_PUB.ADD;
1523: RAISE FND_API.G_EXC_ERROR;
1524: END IF;
1525: HZ_MATCH_RULE_50.find_duplicate_parties(
1526: p_rule_id,p_party_id,
1527: p_restrict_sql,p_match_type,p_dup_batch_id,p_search_merged,x_dup_set_id, x_search_ctx_id,x_num_matches);
1528: -- Code for Match rule BULK MATCH: IDENTICAL PERSONS
1529: ELSIF p_rule_id=51 THEN

Line 1915: IF NOT HZ_MATCH_RULE_50.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 BULK MATCH: IDENTICAL ORGANIZATIONS
1914: ELSIF p_rule_id=50 THEN
1915: IF NOT HZ_MATCH_RULE_50.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_50.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_50.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 BULK MATCH: IDENTICAL PERSONS
1924: ELSIF p_rule_id=51 THEN

Line 2309: IF NOT HZ_MATCH_RULE_50.check_staged THEN

2305: p_rule_id,p_org_contact_id,p_party_id,
2306: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2307: -- Code for Match rule BULK MATCH: IDENTICAL ORGANIZATIONS
2308: ELSIF p_rule_id=50 THEN
2309: IF NOT HZ_MATCH_RULE_50.check_staged THEN
2310: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2311: FND_MSG_PUB.ADD;
2312: RAISE FND_API.G_EXC_ERROR;
2313: END IF;

Line 2314: HZ_MATCH_RULE_50.find_duplicate_contacts(

2310: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2311: FND_MSG_PUB.ADD;
2312: RAISE FND_API.G_EXC_ERROR;
2313: END IF;
2314: HZ_MATCH_RULE_50.find_duplicate_contacts(
2315: p_rule_id,p_org_contact_id,p_party_id,
2316: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2317: -- Code for Match rule BULK MATCH: IDENTICAL PERSONS
2318: ELSIF p_rule_id=51 THEN

Line 2703: IF NOT HZ_MATCH_RULE_50.check_staged THEN

2699: p_rule_id,p_contact_point_id,p_party_id,
2700: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2701: -- Code for Match rule BULK MATCH: IDENTICAL ORGANIZATIONS
2702: ELSIF p_rule_id=50 THEN
2703: IF NOT HZ_MATCH_RULE_50.check_staged THEN
2704: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2705: FND_MSG_PUB.ADD;
2706: RAISE FND_API.G_EXC_ERROR;
2707: END IF;

Line 2708: HZ_MATCH_RULE_50.find_duplicate_contact_points(

2704: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2705: FND_MSG_PUB.ADD;
2706: RAISE FND_API.G_EXC_ERROR;
2707: END IF;
2708: HZ_MATCH_RULE_50.find_duplicate_contact_points(
2709: p_rule_id,p_contact_point_id,p_party_id,
2710: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2711: -- Code for Match rule BULK MATCH: IDENTICAL PERSONS
2712: ELSIF p_rule_id=51 THEN

Line 3289: IF NOT HZ_MATCH_RULE_50.check_staged THEN

3285: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3286: p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
3287: -- Code for Match rule BULK MATCH: IDENTICAL ORGANIZATIONS
3288: ELSIF p_rule_id=50 THEN
3289: IF NOT HZ_MATCH_RULE_50.check_staged THEN
3290: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3291: FND_MSG_PUB.ADD;
3292: RAISE FND_API.G_EXC_ERROR;
3293: END IF;

Line 3294: HZ_MATCH_RULE_50.find_parties_dynamic(

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

Line 3972: IF NOT HZ_MATCH_RULE_50.check_staged THEN

3968: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3969: p_restrict_sql,p_api_name,p_match_type,p_party_id,p_search_merged,x_search_ctx_id,x_num_matches);
3970: -- Code for Match rule BULK MATCH: IDENTICAL ORGANIZATIONS
3971: ELSIF p_rule_id=50 THEN
3972: IF NOT HZ_MATCH_RULE_50.check_staged THEN
3973: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3974: FND_MSG_PUB.ADD;
3975: RAISE FND_API.G_EXC_ERROR;
3976: END IF;

Line 3977: HZ_MATCH_RULE_50.call_api_dynamic(

3973: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3974: FND_MSG_PUB.ADD;
3975: RAISE FND_API.G_EXC_ERROR;
3976: END IF;
3977: HZ_MATCH_RULE_50.call_api_dynamic(
3978: p_rule_id,
3979: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
3980: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
3981: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 4694: IF NOT HZ_MATCH_RULE_50.check_staged THEN

4690: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4691: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4692: -- Code for Match rule BULK MATCH: IDENTICAL ORGANIZATIONS
4693: ELSIF p_rule_id=50 THEN
4694: IF NOT HZ_MATCH_RULE_50.check_staged THEN
4695: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4696: FND_MSG_PUB.ADD;
4697: RAISE FND_API.G_EXC_ERROR;
4698: END IF;

Line 4699: HZ_MATCH_RULE_50.get_matching_party_sites(

4695: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4696: FND_MSG_PUB.ADD;
4697: RAISE FND_API.G_EXC_ERROR;
4698: END IF;
4699: HZ_MATCH_RULE_50.get_matching_party_sites(
4700: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4701: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4702: -- Code for Match rule BULK MATCH: IDENTICAL PERSONS
4703: ELSIF p_rule_id=51 THEN

Line 5113: IF NOT HZ_MATCH_RULE_50.check_staged THEN

5109: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
5110: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5111: -- Code for Match rule BULK MATCH: IDENTICAL ORGANIZATIONS
5112: ELSIF p_rule_id=50 THEN
5113: IF NOT HZ_MATCH_RULE_50.check_staged THEN
5114: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5115: FND_MSG_PUB.ADD;
5116: RAISE FND_API.G_EXC_ERROR;
5117: END IF;

Line 5118: HZ_MATCH_RULE_50.get_matching_contacts(

5114: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5115: FND_MSG_PUB.ADD;
5116: RAISE FND_API.G_EXC_ERROR;
5117: END IF;
5118: HZ_MATCH_RULE_50.get_matching_contacts(
5119: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
5120: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5121: -- Code for Match rule BULK MATCH: IDENTICAL PERSONS
5122: ELSIF p_rule_id=51 THEN

Line 5530: IF NOT HZ_MATCH_RULE_50.check_staged THEN

5526: p_rule_id, p_party_id, p_contact_point_list,
5527: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5528: -- Code for Match rule BULK MATCH: IDENTICAL ORGANIZATIONS
5529: ELSIF p_rule_id=50 THEN
5530: IF NOT HZ_MATCH_RULE_50.check_staged THEN
5531: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5532: FND_MSG_PUB.ADD;
5533: RAISE FND_API.G_EXC_ERROR;
5534: END IF;

Line 5535: HZ_MATCH_RULE_50.get_matching_contact_points(

5531: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5532: FND_MSG_PUB.ADD;
5533: RAISE FND_API.G_EXC_ERROR;
5534: END IF;
5535: HZ_MATCH_RULE_50.get_matching_contact_points(
5536: p_rule_id, p_party_id, p_contact_point_list,
5537: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5538: -- Code for Match rule BULK MATCH: IDENTICAL PERSONS
5539: ELSIF p_rule_id=51 THEN

Line 5969: IF NOT HZ_MATCH_RULE_50.check_staged THEN

5965: p_party_id, p_party_search_rec,p_party_site_list,
5966: p_contact_list, p_contact_point_list,x_search_ctx_id);
5967: -- Code for Match rule BULK MATCH: IDENTICAL ORGANIZATIONS
5968: ELSIF p_rule_id=50 THEN
5969: IF NOT HZ_MATCH_RULE_50.check_staged THEN
5970: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5971: FND_MSG_PUB.ADD;
5972: RAISE FND_API.G_EXC_ERROR;
5973: END IF;

Line 5974: HZ_MATCH_RULE_50.get_score_details(

5970: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5971: FND_MSG_PUB.ADD;
5972: RAISE FND_API.G_EXC_ERROR;
5973: END IF;
5974: HZ_MATCH_RULE_50.get_score_details(
5975: p_rule_id,
5976: p_party_id, p_party_search_rec,p_party_site_list,
5977: p_contact_list, p_contact_point_list,x_search_ctx_id);
5978: -- Code for Match rule BULK MATCH: IDENTICAL PERSONS

Line 6370: IF NOT HZ_MATCH_RULE_50.check_staged THEN

6366: p_party_id, x_party_search_rec,x_party_site_list,
6367: x_contact_list, x_contact_point_list);
6368: -- Code for Match rule BULK MATCH: IDENTICAL ORGANIZATIONS
6369: ELSIF p_rule_id=50 THEN
6370: IF NOT HZ_MATCH_RULE_50.check_staged THEN
6371: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6372: FND_MSG_PUB.ADD;
6373: RAISE FND_API.G_EXC_ERROR;
6374: END IF;

Line 6375: HZ_MATCH_RULE_50.get_party_for_search(

6371: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6372: FND_MSG_PUB.ADD;
6373: RAISE FND_API.G_EXC_ERROR;
6374: END IF;
6375: HZ_MATCH_RULE_50.get_party_for_search(
6376: p_party_id, x_party_search_rec,x_party_site_list,
6377: x_contact_list, x_contact_point_list);
6378: -- Code for Match rule BULK MATCH: IDENTICAL PERSONS
6379: ELSIF p_rule_id=51 THEN

Line 6762: IF NOT HZ_MATCH_RULE_50.check_staged THEN

6758: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6759: x_contact_list, x_contact_point_list);
6760: -- Code for Match rule BULK MATCH: IDENTICAL ORGANIZATIONS
6761: ELSIF p_rule_id=50 THEN
6762: IF NOT HZ_MATCH_RULE_50.check_staged THEN
6763: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6764: FND_MSG_PUB.ADD;
6765: RAISE FND_API.G_EXC_ERROR;
6766: END IF;

Line 6767: HZ_MATCH_RULE_50.get_search_criteria(

6763: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6764: FND_MSG_PUB.ADD;
6765: RAISE FND_API.G_EXC_ERROR;
6766: END IF;
6767: HZ_MATCH_RULE_50.get_search_criteria(
6768: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6769: x_contact_list, x_contact_point_list);
6770: -- Code for Match rule BULK MATCH: IDENTICAL PERSONS
6771: ELSIF p_rule_id=51 THEN