DBA Data[Home] [Help]

APPS.HZ_PARTY_SEARCH dependencies on HZ_MATCH_RULE_238

Line 400: IF NOT HZ_MATCH_RULE_238.check_staged THEN

396: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
397: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,NULL,NULL,NULL,'N',x_search_ctx_id,x_num_matches);
398: -- Code for Match rule Web Services: Identical Organizations
399: ELSIF p_rule_id=238 THEN
400: IF NOT HZ_MATCH_RULE_238.check_staged THEN
401: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
402: FND_MSG_PUB.ADD;
403: RAISE FND_API.G_EXC_ERROR;
404: END IF;

Line 405: HZ_MATCH_RULE_238.find_parties(

401: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
402: FND_MSG_PUB.ADD;
403: RAISE FND_API.G_EXC_ERROR;
404: END IF;
405: HZ_MATCH_RULE_238.find_parties(
406: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
407: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,NULL,NULL,NULL,'N',x_search_ctx_id,x_num_matches);
408: -- Code for Match rule Web Services: Identical Persons
409: ELSIF p_rule_id=240 THEN

Line 801: IF NOT HZ_MATCH_RULE_238.check_staged THEN

797: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
798: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,'N',x_search_ctx_id,x_num_matches);
799: -- Code for Match rule Web Services: Identical Organizations
800: ELSIF p_rule_id=238 THEN
801: IF NOT HZ_MATCH_RULE_238.check_staged THEN
802: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
803: FND_MSG_PUB.ADD;
804: RAISE FND_API.G_EXC_ERROR;
805: END IF;

Line 806: HZ_MATCH_RULE_238.find_persons(

802: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
803: FND_MSG_PUB.ADD;
804: RAISE FND_API.G_EXC_ERROR;
805: END IF;
806: HZ_MATCH_RULE_238.find_persons(
807: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
808: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,'N',x_search_ctx_id,x_num_matches);
809: -- Code for Match rule Web Services: Identical Persons
810: ELSIF p_rule_id=240 THEN

Line 1220: IF NOT HZ_MATCH_RULE_238.check_staged THEN

1216: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
1217: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
1218: -- Code for Match rule Web Services: Identical Organizations
1219: ELSIF p_rule_id=238 THEN
1220: IF NOT HZ_MATCH_RULE_238.check_staged THEN
1221: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1222: FND_MSG_PUB.ADD;
1223: RAISE FND_API.G_EXC_ERROR;
1224: END IF;

Line 1225: HZ_MATCH_RULE_238.find_party_details(

1221: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1222: FND_MSG_PUB.ADD;
1223: RAISE FND_API.G_EXC_ERROR;
1224: END IF;
1225: HZ_MATCH_RULE_238.find_party_details(
1226: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
1227: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
1228: -- Code for Match rule Web Services: Identical Persons
1229: ELSIF p_rule_id=240 THEN

Line 1620: IF NOT HZ_MATCH_RULE_238.check_staged THEN

1616: p_rule_id,p_party_id,
1617: p_restrict_sql,p_match_type,p_dup_batch_id,p_search_merged,x_dup_set_id, x_search_ctx_id,x_num_matches);
1618: -- Code for Match rule Web Services: Identical Organizations
1619: ELSIF p_rule_id=238 THEN
1620: IF NOT HZ_MATCH_RULE_238.check_staged THEN
1621: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1622: FND_MSG_PUB.ADD;
1623: RAISE FND_API.G_EXC_ERROR;
1624: END IF;

Line 1625: HZ_MATCH_RULE_238.find_duplicate_parties(

1621: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1622: FND_MSG_PUB.ADD;
1623: RAISE FND_API.G_EXC_ERROR;
1624: END IF;
1625: HZ_MATCH_RULE_238.find_duplicate_parties(
1626: p_rule_id,p_party_id,
1627: p_restrict_sql,p_match_type,p_dup_batch_id,p_search_merged,x_dup_set_id, x_search_ctx_id,x_num_matches);
1628: -- Code for Match rule Web Services: Identical Persons
1629: ELSIF p_rule_id=240 THEN

Line 2015: IF NOT HZ_MATCH_RULE_238.check_staged THEN

2011: p_rule_id,p_party_site_id,p_party_id,
2012: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2013: -- Code for Match rule Web Services: Identical Organizations
2014: ELSIF p_rule_id=238 THEN
2015: IF NOT HZ_MATCH_RULE_238.check_staged THEN
2016: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2017: FND_MSG_PUB.ADD;
2018: RAISE FND_API.G_EXC_ERROR;
2019: END IF;

Line 2020: HZ_MATCH_RULE_238.find_duplicate_party_sites(

2016: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2017: FND_MSG_PUB.ADD;
2018: RAISE FND_API.G_EXC_ERROR;
2019: END IF;
2020: HZ_MATCH_RULE_238.find_duplicate_party_sites(
2021: p_rule_id,p_party_site_id,p_party_id,
2022: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2023: -- Code for Match rule Web Services: Identical Persons
2024: ELSIF p_rule_id=240 THEN

Line 2409: IF NOT HZ_MATCH_RULE_238.check_staged THEN

2405: p_rule_id,p_org_contact_id,p_party_id,
2406: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2407: -- Code for Match rule Web Services: Identical Organizations
2408: ELSIF p_rule_id=238 THEN
2409: IF NOT HZ_MATCH_RULE_238.check_staged THEN
2410: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2411: FND_MSG_PUB.ADD;
2412: RAISE FND_API.G_EXC_ERROR;
2413: END IF;

Line 2414: HZ_MATCH_RULE_238.find_duplicate_contacts(

2410: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2411: FND_MSG_PUB.ADD;
2412: RAISE FND_API.G_EXC_ERROR;
2413: END IF;
2414: HZ_MATCH_RULE_238.find_duplicate_contacts(
2415: p_rule_id,p_org_contact_id,p_party_id,
2416: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2417: -- Code for Match rule Web Services: Identical Persons
2418: ELSIF p_rule_id=240 THEN

Line 2803: IF NOT HZ_MATCH_RULE_238.check_staged THEN

2799: p_rule_id,p_contact_point_id,p_party_id,
2800: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2801: -- Code for Match rule Web Services: Identical Organizations
2802: ELSIF p_rule_id=238 THEN
2803: IF NOT HZ_MATCH_RULE_238.check_staged THEN
2804: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2805: FND_MSG_PUB.ADD;
2806: RAISE FND_API.G_EXC_ERROR;
2807: END IF;

Line 2808: HZ_MATCH_RULE_238.find_duplicate_contact_points(

2804: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2805: FND_MSG_PUB.ADD;
2806: RAISE FND_API.G_EXC_ERROR;
2807: END IF;
2808: HZ_MATCH_RULE_238.find_duplicate_contact_points(
2809: p_rule_id,p_contact_point_id,p_party_id,
2810: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2811: -- Code for Match rule Web Services: Identical Persons
2812: ELSIF p_rule_id=240 THEN

Line 3469: IF NOT HZ_MATCH_RULE_238.check_staged THEN

3465: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3466: p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
3467: -- Code for Match rule Web Services: Identical Organizations
3468: ELSIF p_rule_id=238 THEN
3469: IF NOT HZ_MATCH_RULE_238.check_staged THEN
3470: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3471: FND_MSG_PUB.ADD;
3472: RAISE FND_API.G_EXC_ERROR;
3473: END IF;

Line 3474: HZ_MATCH_RULE_238.find_parties_dynamic(

3470: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3471: FND_MSG_PUB.ADD;
3472: RAISE FND_API.G_EXC_ERROR;
3473: END IF;
3474: HZ_MATCH_RULE_238.find_parties_dynamic(
3475: p_rule_id,
3476: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
3477: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
3478: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 4152: IF NOT HZ_MATCH_RULE_238.check_staged THEN

4148: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
4149: p_restrict_sql,p_api_name,p_match_type,p_party_id,p_search_merged,x_search_ctx_id,x_num_matches);
4150: -- Code for Match rule Web Services: Identical Organizations
4151: ELSIF p_rule_id=238 THEN
4152: IF NOT HZ_MATCH_RULE_238.check_staged THEN
4153: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4154: FND_MSG_PUB.ADD;
4155: RAISE FND_API.G_EXC_ERROR;
4156: END IF;

Line 4157: HZ_MATCH_RULE_238.call_api_dynamic(

4153: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4154: FND_MSG_PUB.ADD;
4155: RAISE FND_API.G_EXC_ERROR;
4156: END IF;
4157: HZ_MATCH_RULE_238.call_api_dynamic(
4158: p_rule_id,
4159: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
4160: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
4161: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 4794: IF NOT HZ_MATCH_RULE_238.check_staged THEN

4790: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4791: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4792: -- Code for Match rule Web Services: Identical Organizations
4793: ELSIF p_rule_id=238 THEN
4794: IF NOT HZ_MATCH_RULE_238.check_staged THEN
4795: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4796: FND_MSG_PUB.ADD;
4797: RAISE FND_API.G_EXC_ERROR;
4798: END IF;

Line 4799: HZ_MATCH_RULE_238.get_matching_party_sites(

4795: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4796: FND_MSG_PUB.ADD;
4797: RAISE FND_API.G_EXC_ERROR;
4798: END IF;
4799: HZ_MATCH_RULE_238.get_matching_party_sites(
4800: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4801: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4802: -- Code for Match rule Web Services: Identical Persons
4803: ELSIF p_rule_id=240 THEN

Line 5213: IF NOT HZ_MATCH_RULE_238.check_staged THEN

5209: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
5210: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5211: -- Code for Match rule Web Services: Identical Organizations
5212: ELSIF p_rule_id=238 THEN
5213: IF NOT HZ_MATCH_RULE_238.check_staged THEN
5214: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5215: FND_MSG_PUB.ADD;
5216: RAISE FND_API.G_EXC_ERROR;
5217: END IF;

Line 5218: HZ_MATCH_RULE_238.get_matching_contacts(

5214: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5215: FND_MSG_PUB.ADD;
5216: RAISE FND_API.G_EXC_ERROR;
5217: END IF;
5218: HZ_MATCH_RULE_238.get_matching_contacts(
5219: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
5220: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5221: -- Code for Match rule Web Services: Identical Persons
5222: ELSIF p_rule_id=240 THEN

Line 5630: IF NOT HZ_MATCH_RULE_238.check_staged THEN

5626: p_rule_id, p_party_id, p_contact_point_list,
5627: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5628: -- Code for Match rule Web Services: Identical Organizations
5629: ELSIF p_rule_id=238 THEN
5630: IF NOT HZ_MATCH_RULE_238.check_staged THEN
5631: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5632: FND_MSG_PUB.ADD;
5633: RAISE FND_API.G_EXC_ERROR;
5634: END IF;

Line 5635: HZ_MATCH_RULE_238.get_matching_contact_points(

5631: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5632: FND_MSG_PUB.ADD;
5633: RAISE FND_API.G_EXC_ERROR;
5634: END IF;
5635: HZ_MATCH_RULE_238.get_matching_contact_points(
5636: p_rule_id, p_party_id, p_contact_point_list,
5637: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5638: -- Code for Match rule Web Services: Identical Persons
5639: ELSIF p_rule_id=240 THEN

Line 6079: IF NOT HZ_MATCH_RULE_238.check_staged THEN

6075: p_party_id, p_party_search_rec,p_party_site_list,
6076: p_contact_list, p_contact_point_list,x_search_ctx_id);
6077: -- Code for Match rule Web Services: Identical Organizations
6078: ELSIF p_rule_id=238 THEN
6079: IF NOT HZ_MATCH_RULE_238.check_staged THEN
6080: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6081: FND_MSG_PUB.ADD;
6082: RAISE FND_API.G_EXC_ERROR;
6083: END IF;

Line 6084: HZ_MATCH_RULE_238.get_score_details(

6080: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6081: FND_MSG_PUB.ADD;
6082: RAISE FND_API.G_EXC_ERROR;
6083: END IF;
6084: HZ_MATCH_RULE_238.get_score_details(
6085: p_rule_id,
6086: p_party_id, p_party_search_rec,p_party_site_list,
6087: p_contact_list, p_contact_point_list,x_search_ctx_id);
6088: -- Code for Match rule Web Services: Identical Persons

Line 6470: IF NOT HZ_MATCH_RULE_238.check_staged THEN

6466: p_party_id, x_party_search_rec,x_party_site_list,
6467: x_contact_list, x_contact_point_list);
6468: -- Code for Match rule Web Services: Identical Organizations
6469: ELSIF p_rule_id=238 THEN
6470: IF NOT HZ_MATCH_RULE_238.check_staged THEN
6471: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6472: FND_MSG_PUB.ADD;
6473: RAISE FND_API.G_EXC_ERROR;
6474: END IF;

Line 6475: HZ_MATCH_RULE_238.get_party_for_search(

6471: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6472: FND_MSG_PUB.ADD;
6473: RAISE FND_API.G_EXC_ERROR;
6474: END IF;
6475: HZ_MATCH_RULE_238.get_party_for_search(
6476: p_party_id, x_party_search_rec,x_party_site_list,
6477: x_contact_list, x_contact_point_list);
6478: -- Code for Match rule Web Services: Identical Persons
6479: ELSIF p_rule_id=240 THEN

Line 6862: IF NOT HZ_MATCH_RULE_238.check_staged THEN

6858: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6859: x_contact_list, x_contact_point_list);
6860: -- Code for Match rule Web Services: Identical Organizations
6861: ELSIF p_rule_id=238 THEN
6862: IF NOT HZ_MATCH_RULE_238.check_staged THEN
6863: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6864: FND_MSG_PUB.ADD;
6865: RAISE FND_API.G_EXC_ERROR;
6866: END IF;

Line 6867: HZ_MATCH_RULE_238.get_search_criteria(

6863: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6864: FND_MSG_PUB.ADD;
6865: RAISE FND_API.G_EXC_ERROR;
6866: END IF;
6867: HZ_MATCH_RULE_238.get_search_criteria(
6868: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6869: x_contact_list, x_contact_point_list);
6870: -- Code for Match rule Web Services: Identical Persons
6871: ELSIF p_rule_id=240 THEN