DBA Data[Home] [Help]

APPS.HZ_PARTY_SEARCH dependencies on HZ_MATCH_RULE_99

Line 390: IF NOT HZ_MATCH_RULE_99.check_staged THEN

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
390: IF NOT HZ_MATCH_RULE_99.check_staged THEN
391: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
392: FND_MSG_PUB.ADD;
393: RAISE FND_API.G_EXC_ERROR;
394: END IF;

Line 395: HZ_MATCH_RULE_99.find_parties(

391: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
392: FND_MSG_PUB.ADD;
393: RAISE FND_API.G_EXC_ERROR;
394: END IF;
395: HZ_MATCH_RULE_99.find_parties(
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

Line 791: IF NOT HZ_MATCH_RULE_99.check_staged THEN

787: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
788: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,'N',x_search_ctx_id,x_num_matches);
789: -- Code for Match rule HZ_CONTACT_ADV_SEARCH_MATCH_RULE
790: ELSIF p_rule_id=99 THEN
791: IF NOT HZ_MATCH_RULE_99.check_staged THEN
792: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
793: FND_MSG_PUB.ADD;
794: RAISE FND_API.G_EXC_ERROR;
795: END IF;

Line 796: HZ_MATCH_RULE_99.find_persons(

792: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
793: FND_MSG_PUB.ADD;
794: RAISE FND_API.G_EXC_ERROR;
795: END IF;
796: HZ_MATCH_RULE_99.find_persons(
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

Line 1210: IF NOT HZ_MATCH_RULE_99.check_staged THEN

1206: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
1207: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
1208: -- Code for Match rule HZ_CONTACT_ADV_SEARCH_MATCH_RULE
1209: ELSIF p_rule_id=99 THEN
1210: IF NOT HZ_MATCH_RULE_99.check_staged THEN
1211: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1212: FND_MSG_PUB.ADD;
1213: RAISE FND_API.G_EXC_ERROR;
1214: END IF;

Line 1215: HZ_MATCH_RULE_99.find_party_details(

1211: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1212: FND_MSG_PUB.ADD;
1213: RAISE FND_API.G_EXC_ERROR;
1214: END IF;
1215: HZ_MATCH_RULE_99.find_party_details(
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

Line 1610: IF NOT HZ_MATCH_RULE_99.check_staged THEN

1606: p_rule_id,p_party_id,
1607: p_restrict_sql,p_match_type,p_dup_batch_id,p_search_merged,x_dup_set_id, x_search_ctx_id,x_num_matches);
1608: -- Code for Match rule HZ_CONTACT_ADV_SEARCH_MATCH_RULE
1609: ELSIF p_rule_id=99 THEN
1610: IF NOT HZ_MATCH_RULE_99.check_staged THEN
1611: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1612: FND_MSG_PUB.ADD;
1613: RAISE FND_API.G_EXC_ERROR;
1614: END IF;

Line 1615: HZ_MATCH_RULE_99.find_duplicate_parties(

1611: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1612: FND_MSG_PUB.ADD;
1613: RAISE FND_API.G_EXC_ERROR;
1614: END IF;
1615: HZ_MATCH_RULE_99.find_duplicate_parties(
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

Line 2005: IF NOT HZ_MATCH_RULE_99.check_staged THEN

2001: p_rule_id,p_party_site_id,p_party_id,
2002: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2003: -- Code for Match rule HZ_CONTACT_ADV_SEARCH_MATCH_RULE
2004: ELSIF p_rule_id=99 THEN
2005: IF NOT HZ_MATCH_RULE_99.check_staged THEN
2006: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2007: FND_MSG_PUB.ADD;
2008: RAISE FND_API.G_EXC_ERROR;
2009: END IF;

Line 2010: HZ_MATCH_RULE_99.find_duplicate_party_sites(

2006: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2007: FND_MSG_PUB.ADD;
2008: RAISE FND_API.G_EXC_ERROR;
2009: END IF;
2010: HZ_MATCH_RULE_99.find_duplicate_party_sites(
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

Line 2399: IF NOT HZ_MATCH_RULE_99.check_staged THEN

2395: p_rule_id,p_org_contact_id,p_party_id,
2396: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2397: -- Code for Match rule HZ_CONTACT_ADV_SEARCH_MATCH_RULE
2398: ELSIF p_rule_id=99 THEN
2399: IF NOT HZ_MATCH_RULE_99.check_staged THEN
2400: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2401: FND_MSG_PUB.ADD;
2402: RAISE FND_API.G_EXC_ERROR;
2403: END IF;

Line 2404: HZ_MATCH_RULE_99.find_duplicate_contacts(

2400: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2401: FND_MSG_PUB.ADD;
2402: RAISE FND_API.G_EXC_ERROR;
2403: END IF;
2404: HZ_MATCH_RULE_99.find_duplicate_contacts(
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

Line 2793: IF NOT HZ_MATCH_RULE_99.check_staged THEN

2789: p_rule_id,p_contact_point_id,p_party_id,
2790: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2791: -- Code for Match rule HZ_CONTACT_ADV_SEARCH_MATCH_RULE
2792: ELSIF p_rule_id=99 THEN
2793: IF NOT HZ_MATCH_RULE_99.check_staged THEN
2794: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2795: FND_MSG_PUB.ADD;
2796: RAISE FND_API.G_EXC_ERROR;
2797: END IF;

Line 2798: HZ_MATCH_RULE_99.find_duplicate_contact_points(

2794: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2795: FND_MSG_PUB.ADD;
2796: RAISE FND_API.G_EXC_ERROR;
2797: END IF;
2798: HZ_MATCH_RULE_99.find_duplicate_contact_points(
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

Line 3451: IF NOT HZ_MATCH_RULE_99.check_staged THEN

3447: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3448: p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
3449: -- Code for Match rule HZ_CONTACT_ADV_SEARCH_MATCH_RULE
3450: ELSIF p_rule_id=99 THEN
3451: IF NOT HZ_MATCH_RULE_99.check_staged THEN
3452: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3453: FND_MSG_PUB.ADD;
3454: RAISE FND_API.G_EXC_ERROR;
3455: END IF;

Line 3456: HZ_MATCH_RULE_99.find_parties_dynamic(

3452: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3453: FND_MSG_PUB.ADD;
3454: RAISE FND_API.G_EXC_ERROR;
3455: END IF;
3456: HZ_MATCH_RULE_99.find_parties_dynamic(
3457: p_rule_id,
3458: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
3459: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
3460: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 4134: IF NOT HZ_MATCH_RULE_99.check_staged THEN

4130: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
4131: p_restrict_sql,p_api_name,p_match_type,p_party_id,p_search_merged,x_search_ctx_id,x_num_matches);
4132: -- Code for Match rule HZ_CONTACT_ADV_SEARCH_MATCH_RULE
4133: ELSIF p_rule_id=99 THEN
4134: IF NOT HZ_MATCH_RULE_99.check_staged THEN
4135: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4136: FND_MSG_PUB.ADD;
4137: RAISE FND_API.G_EXC_ERROR;
4138: END IF;

Line 4139: HZ_MATCH_RULE_99.call_api_dynamic(

4135: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4136: FND_MSG_PUB.ADD;
4137: RAISE FND_API.G_EXC_ERROR;
4138: END IF;
4139: HZ_MATCH_RULE_99.call_api_dynamic(
4140: p_rule_id,
4141: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
4142: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
4143: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 4784: IF NOT HZ_MATCH_RULE_99.check_staged THEN

4780: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4781: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4782: -- Code for Match rule HZ_CONTACT_ADV_SEARCH_MATCH_RULE
4783: ELSIF p_rule_id=99 THEN
4784: IF NOT HZ_MATCH_RULE_99.check_staged THEN
4785: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4786: FND_MSG_PUB.ADD;
4787: RAISE FND_API.G_EXC_ERROR;
4788: END IF;

Line 4789: HZ_MATCH_RULE_99.get_matching_party_sites(

4785: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4786: FND_MSG_PUB.ADD;
4787: RAISE FND_API.G_EXC_ERROR;
4788: END IF;
4789: HZ_MATCH_RULE_99.get_matching_party_sites(
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

Line 5203: IF NOT HZ_MATCH_RULE_99.check_staged THEN

5199: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
5200: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5201: -- Code for Match rule HZ_CONTACT_ADV_SEARCH_MATCH_RULE
5202: ELSIF p_rule_id=99 THEN
5203: IF NOT HZ_MATCH_RULE_99.check_staged THEN
5204: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5205: FND_MSG_PUB.ADD;
5206: RAISE FND_API.G_EXC_ERROR;
5207: END IF;

Line 5208: HZ_MATCH_RULE_99.get_matching_contacts(

5204: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5205: FND_MSG_PUB.ADD;
5206: RAISE FND_API.G_EXC_ERROR;
5207: END IF;
5208: HZ_MATCH_RULE_99.get_matching_contacts(
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

Line 5620: IF NOT HZ_MATCH_RULE_99.check_staged THEN

5616: p_rule_id, p_party_id, p_contact_point_list,
5617: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5618: -- Code for Match rule HZ_CONTACT_ADV_SEARCH_MATCH_RULE
5619: ELSIF p_rule_id=99 THEN
5620: IF NOT HZ_MATCH_RULE_99.check_staged THEN
5621: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5622: FND_MSG_PUB.ADD;
5623: RAISE FND_API.G_EXC_ERROR;
5624: END IF;

Line 5625: HZ_MATCH_RULE_99.get_matching_contact_points(

5621: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5622: FND_MSG_PUB.ADD;
5623: RAISE FND_API.G_EXC_ERROR;
5624: END IF;
5625: HZ_MATCH_RULE_99.get_matching_contact_points(
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

Line 6068: IF NOT HZ_MATCH_RULE_99.check_staged THEN

6064: p_party_id, p_party_search_rec,p_party_site_list,
6065: p_contact_list, p_contact_point_list,x_search_ctx_id);
6066: -- Code for Match rule HZ_CONTACT_ADV_SEARCH_MATCH_RULE
6067: ELSIF p_rule_id=99 THEN
6068: IF NOT HZ_MATCH_RULE_99.check_staged THEN
6069: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6070: FND_MSG_PUB.ADD;
6071: RAISE FND_API.G_EXC_ERROR;
6072: END IF;

Line 6073: HZ_MATCH_RULE_99.get_score_details(

6069: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6070: FND_MSG_PUB.ADD;
6071: RAISE FND_API.G_EXC_ERROR;
6072: END IF;
6073: HZ_MATCH_RULE_99.get_score_details(
6074: p_rule_id,
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

Line 6460: IF NOT HZ_MATCH_RULE_99.check_staged THEN

6456: p_party_id, x_party_search_rec,x_party_site_list,
6457: x_contact_list, x_contact_point_list);
6458: -- Code for Match rule HZ_CONTACT_ADV_SEARCH_MATCH_RULE
6459: ELSIF p_rule_id=99 THEN
6460: IF NOT HZ_MATCH_RULE_99.check_staged THEN
6461: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6462: FND_MSG_PUB.ADD;
6463: RAISE FND_API.G_EXC_ERROR;
6464: END IF;

Line 6465: HZ_MATCH_RULE_99.get_party_for_search(

6461: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6462: FND_MSG_PUB.ADD;
6463: RAISE FND_API.G_EXC_ERROR;
6464: END IF;
6465: HZ_MATCH_RULE_99.get_party_for_search(
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

Line 6852: IF NOT HZ_MATCH_RULE_99.check_staged THEN

6848: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6849: x_contact_list, x_contact_point_list);
6850: -- Code for Match rule HZ_CONTACT_ADV_SEARCH_MATCH_RULE
6851: ELSIF p_rule_id=99 THEN
6852: IF NOT HZ_MATCH_RULE_99.check_staged THEN
6853: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6854: FND_MSG_PUB.ADD;
6855: RAISE FND_API.G_EXC_ERROR;
6856: END IF;

Line 6857: HZ_MATCH_RULE_99.get_search_criteria(

6853: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6854: FND_MSG_PUB.ADD;
6855: RAISE FND_API.G_EXC_ERROR;
6856: END IF;
6857: HZ_MATCH_RULE_99.get_search_criteria(
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