APPS.HZ_PARTY_SEARCH dependencies on HZ_MATCH_RULE_2

Line 110: IF NOT HZ_MATCH_RULE_2.check_staged THEN

106: RAISE FND_API.G_EXC_ERROR;
107: END IF;
108: -- Code for Match rule SAMPLE: ORGANIZATIONS_OPTIMIZED
109: IF p_rule_id=2 THEN
110: IF NOT HZ_MATCH_RULE_2.check_staged THEN
111: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
112: FND_MSG_PUB.ADD;
113: RAISE FND_API.G_EXC_ERROR;
114: END IF;

Line 115: HZ_MATCH_RULE_2.find_parties(

111: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
112: FND_MSG_PUB.ADD;
113: RAISE FND_API.G_EXC_ERROR;
114: END IF;
115: HZ_MATCH_RULE_2.find_parties(
116: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
117: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,NULL,NULL,NULL,'N',x_search_ctx_id,x_num_matches);
118: -- Code for Match rule SAMPLE: PERSON_OPTIMIZED
119: ELSIF p_rule_id=3 THEN

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 410: IF NOT HZ_MATCH_RULE_240.check_staged THEN

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
410: IF NOT HZ_MATCH_RULE_240.check_staged THEN
411: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
412: FND_MSG_PUB.ADD;
413: RAISE FND_API.G_EXC_ERROR;
414: END IF;

Line 415: HZ_MATCH_RULE_240.find_parties(

411: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
412: FND_MSG_PUB.ADD;
413: RAISE FND_API.G_EXC_ERROR;
414: END IF;
415: HZ_MATCH_RULE_240.find_parties(
416: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
417: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,NULL,NULL,NULL,'N',x_search_ctx_id,x_num_matches);
418: END IF;
419: -- User quality score

Line 511: IF NOT HZ_MATCH_RULE_2.check_staged THEN

507: RAISE FND_API.G_EXC_ERROR;
508: END IF;
509: -- Code for Match rule SAMPLE: ORGANIZATIONS_OPTIMIZED
510: IF p_rule_id=2 THEN
511: IF NOT HZ_MATCH_RULE_2.check_staged THEN
512: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
513: FND_MSG_PUB.ADD;
514: RAISE FND_API.G_EXC_ERROR;
515: END IF;

Line 516: HZ_MATCH_RULE_2.find_persons(

512: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
513: FND_MSG_PUB.ADD;
514: RAISE FND_API.G_EXC_ERROR;
515: END IF;
516: HZ_MATCH_RULE_2.find_persons(
517: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
518: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,'N',x_search_ctx_id,x_num_matches);
519: -- Code for Match rule SAMPLE: PERSON_OPTIMIZED
520: ELSIF p_rule_id=3 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 811: IF NOT HZ_MATCH_RULE_240.check_staged THEN

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
811: IF NOT HZ_MATCH_RULE_240.check_staged THEN
812: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
813: FND_MSG_PUB.ADD;
814: RAISE FND_API.G_EXC_ERROR;
815: END IF;

Line 816: HZ_MATCH_RULE_240.find_persons(

812: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
813: FND_MSG_PUB.ADD;
814: RAISE FND_API.G_EXC_ERROR;
815: END IF;
816: HZ_MATCH_RULE_240.find_persons(
817: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
818: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,'N',x_search_ctx_id,x_num_matches);
819: END IF;
820: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 930: IF NOT HZ_MATCH_RULE_2.check_staged THEN

926: RAISE FND_API.G_EXC_ERROR;
927: END IF;
928: -- Code for Match rule SAMPLE: ORGANIZATIONS_OPTIMIZED
929: IF p_rule_id=2 THEN
930: IF NOT HZ_MATCH_RULE_2.check_staged THEN
931: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
932: FND_MSG_PUB.ADD;
933: RAISE FND_API.G_EXC_ERROR;
934: END IF;

Line 935: HZ_MATCH_RULE_2.find_party_details(

931: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
932: FND_MSG_PUB.ADD;
933: RAISE FND_API.G_EXC_ERROR;
934: END IF;
935: HZ_MATCH_RULE_2.find_party_details(
936: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
937: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
938: -- Code for Match rule SAMPLE: PERSON_OPTIMIZED
939: ELSIF p_rule_id=3 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 1230: IF NOT HZ_MATCH_RULE_240.check_staged THEN

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
1230: IF NOT HZ_MATCH_RULE_240.check_staged THEN
1231: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1232: FND_MSG_PUB.ADD;
1233: RAISE FND_API.G_EXC_ERROR;
1234: END IF;

Line 1235: HZ_MATCH_RULE_240.find_party_details(

1231: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1232: FND_MSG_PUB.ADD;
1233: RAISE FND_API.G_EXC_ERROR;
1234: END IF;
1235: HZ_MATCH_RULE_240.find_party_details(
1236: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
1237: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
1238: END IF;
1239: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 1330: IF NOT HZ_MATCH_RULE_2.check_staged THEN

1326: g_last_rule_valid := TRUE;
1327: END IF;
1328: -- Code for Match rule SAMPLE: ORGANIZATIONS_OPTIMIZED
1329: IF p_rule_id=2 THEN
1330: IF NOT HZ_MATCH_RULE_2.check_staged THEN
1331: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1332: FND_MSG_PUB.ADD;
1333: RAISE FND_API.G_EXC_ERROR;
1334: END IF;

Line 1335: HZ_MATCH_RULE_2.find_duplicate_parties(

1331: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1332: FND_MSG_PUB.ADD;
1333: RAISE FND_API.G_EXC_ERROR;
1334: END IF;
1335: HZ_MATCH_RULE_2.find_duplicate_parties(
1336: p_rule_id,p_party_id,
1337: p_restrict_sql,p_match_type,p_dup_batch_id,p_search_merged,x_dup_set_id, x_search_ctx_id,x_num_matches);
1338: -- Code for Match rule SAMPLE: PERSON_OPTIMIZED
1339: ELSIF p_rule_id=3 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 1630: IF NOT HZ_MATCH_RULE_240.check_staged THEN

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
1630: IF NOT HZ_MATCH_RULE_240.check_staged THEN
1631: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1632: FND_MSG_PUB.ADD;
1633: RAISE FND_API.G_EXC_ERROR;
1634: END IF;

Line 1635: HZ_MATCH_RULE_240.find_duplicate_parties(

1631: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1632: FND_MSG_PUB.ADD;
1633: RAISE FND_API.G_EXC_ERROR;
1634: END IF;
1635: HZ_MATCH_RULE_240.find_duplicate_parties(
1636: p_rule_id,p_party_id,
1637: p_restrict_sql,p_match_type,p_dup_batch_id,p_search_merged,x_dup_set_id, x_search_ctx_id,x_num_matches);
1638: END IF;
1639: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 1725: IF NOT HZ_MATCH_RULE_2.check_staged THEN

1721: RAISE FND_API.G_EXC_ERROR;
1722: END IF;
1723: -- Code for Match rule SAMPLE: ORGANIZATIONS_OPTIMIZED
1724: IF p_rule_id=2 THEN
1725: IF NOT HZ_MATCH_RULE_2.check_staged THEN
1726: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1727: FND_MSG_PUB.ADD;
1728: RAISE FND_API.G_EXC_ERROR;
1729: END IF;

Line 1730: HZ_MATCH_RULE_2.find_duplicate_party_sites(

1726: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1727: FND_MSG_PUB.ADD;
1728: RAISE FND_API.G_EXC_ERROR;
1729: END IF;
1730: HZ_MATCH_RULE_2.find_duplicate_party_sites(
1731: p_rule_id,p_party_site_id,p_party_id,
1732: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
1733: -- Code for Match rule SAMPLE: PERSON_OPTIMIZED
1734: ELSIF p_rule_id=3 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 2025: IF NOT HZ_MATCH_RULE_240.check_staged THEN

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
2025: IF NOT HZ_MATCH_RULE_240.check_staged THEN
2026: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2027: FND_MSG_PUB.ADD;
2028: RAISE FND_API.G_EXC_ERROR;
2029: END IF;

Line 2030: HZ_MATCH_RULE_240.find_duplicate_party_sites(

2026: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2027: FND_MSG_PUB.ADD;
2028: RAISE FND_API.G_EXC_ERROR;
2029: END IF;
2030: HZ_MATCH_RULE_240.find_duplicate_party_sites(
2031: p_rule_id,p_party_site_id,p_party_id,
2032: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2033: END IF;
2034: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 2119: IF NOT HZ_MATCH_RULE_2.check_staged THEN

2115: RAISE FND_API.G_EXC_ERROR;
2116: END IF;
2117: -- Code for Match rule SAMPLE: ORGANIZATIONS_OPTIMIZED
2118: IF p_rule_id=2 THEN
2119: IF NOT HZ_MATCH_RULE_2.check_staged THEN
2120: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2121: FND_MSG_PUB.ADD;
2122: RAISE FND_API.G_EXC_ERROR;
2123: END IF;

Line 2124: HZ_MATCH_RULE_2.find_duplicate_contacts(

2120: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2121: FND_MSG_PUB.ADD;
2122: RAISE FND_API.G_EXC_ERROR;
2123: END IF;
2124: HZ_MATCH_RULE_2.find_duplicate_contacts(
2125: p_rule_id,p_org_contact_id,p_party_id,
2126: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2127: -- Code for Match rule SAMPLE: PERSON_OPTIMIZED
2128: ELSIF p_rule_id=3 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 2419: IF NOT HZ_MATCH_RULE_240.check_staged THEN

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
2419: IF NOT HZ_MATCH_RULE_240.check_staged THEN
2420: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2421: FND_MSG_PUB.ADD;
2422: RAISE FND_API.G_EXC_ERROR;
2423: END IF;

Line 2424: HZ_MATCH_RULE_240.find_duplicate_contacts(

2420: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2421: FND_MSG_PUB.ADD;
2422: RAISE FND_API.G_EXC_ERROR;
2423: END IF;
2424: HZ_MATCH_RULE_240.find_duplicate_contacts(
2425: p_rule_id,p_org_contact_id,p_party_id,
2426: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2427: END IF;
2428: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 2513: IF NOT HZ_MATCH_RULE_2.check_staged THEN

2509: RAISE FND_API.G_EXC_ERROR;
2510: END IF;
2511: -- Code for Match rule SAMPLE: ORGANIZATIONS_OPTIMIZED
2512: IF p_rule_id=2 THEN
2513: IF NOT HZ_MATCH_RULE_2.check_staged THEN
2514: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2515: FND_MSG_PUB.ADD;
2516: RAISE FND_API.G_EXC_ERROR;
2517: END IF;

Line 2518: HZ_MATCH_RULE_2.find_duplicate_contact_points(

2514: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2515: FND_MSG_PUB.ADD;
2516: RAISE FND_API.G_EXC_ERROR;
2517: END IF;
2518: HZ_MATCH_RULE_2.find_duplicate_contact_points(
2519: p_rule_id,p_contact_point_id,p_party_id,
2520: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2521: -- Code for Match rule SAMPLE: PERSON_OPTIMIZED
2522: ELSIF p_rule_id=3 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 2813: IF NOT HZ_MATCH_RULE_240.check_staged THEN

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
2813: IF NOT HZ_MATCH_RULE_240.check_staged THEN
2814: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2815: FND_MSG_PUB.ADD;
2816: RAISE FND_API.G_EXC_ERROR;
2817: END IF;

Line 2818: HZ_MATCH_RULE_240.find_duplicate_contact_points(

2814: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2815: FND_MSG_PUB.ADD;
2816: RAISE FND_API.G_EXC_ERROR;
2817: END IF;
2818: HZ_MATCH_RULE_240.find_duplicate_contact_points(
2819: p_rule_id,p_contact_point_id,p_party_id,
2820: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2821: END IF;
2822: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 2947: IF NOT HZ_MATCH_RULE_2.check_staged THEN

2943: RAISE FND_API.G_EXC_ERROR;
2944: END IF;
2945: -- Code for Match rule SAMPLE: ORGANIZATIONS_OPTIMIZED
2946: IF p_rule_id=2 THEN
2947: IF NOT HZ_MATCH_RULE_2.check_staged THEN
2948: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2949: FND_MSG_PUB.ADD;
2950: RAISE FND_API.G_EXC_ERROR;
2951: END IF;

Line 2952: HZ_MATCH_RULE_2.find_parties_dynamic(

2948: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2949: FND_MSG_PUB.ADD;
2950: RAISE FND_API.G_EXC_ERROR;
2951: END IF;
2952: HZ_MATCH_RULE_2.find_parties_dynamic(
2953: p_rule_id,
2954: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
2955: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
2956: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

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 3487: IF NOT HZ_MATCH_RULE_240.check_staged THEN

3483: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3484: p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
3485: -- Code for Match rule Web Services: Identical Persons
3486: ELSIF p_rule_id=240 THEN
3487: IF NOT HZ_MATCH_RULE_240.check_staged THEN
3488: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3489: FND_MSG_PUB.ADD;
3490: RAISE FND_API.G_EXC_ERROR;
3491: END IF;

Line 3492: HZ_MATCH_RULE_240.find_parties_dynamic(

3488: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3489: FND_MSG_PUB.ADD;
3490: RAISE FND_API.G_EXC_ERROR;
3491: END IF;
3492: HZ_MATCH_RULE_240.find_parties_dynamic(
3493: p_rule_id,
3494: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
3495: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
3496: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 3630: IF NOT HZ_MATCH_RULE_2.check_staged THEN

3626: RAISE FND_API.G_EXC_ERROR;
3627: END IF;
3628: -- Code for Match rule SAMPLE: ORGANIZATIONS_OPTIMIZED
3629: IF p_rule_id=2 THEN
3630: IF NOT HZ_MATCH_RULE_2.check_staged THEN
3631: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3632: FND_MSG_PUB.ADD;
3633: RAISE FND_API.G_EXC_ERROR;
3634: END IF;

Line 3635: HZ_MATCH_RULE_2.call_api_dynamic(

3631: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3632: FND_MSG_PUB.ADD;
3633: RAISE FND_API.G_EXC_ERROR;
3634: END IF;
3635: HZ_MATCH_RULE_2.call_api_dynamic(
3636: p_rule_id,
3637: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
3638: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
3639: 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 4170: IF NOT HZ_MATCH_RULE_240.check_staged THEN

4166: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
4167: p_restrict_sql,p_api_name,p_match_type,p_party_id,p_search_merged,x_search_ctx_id,x_num_matches);
4168: -- Code for Match rule Web Services: Identical Persons
4169: ELSIF p_rule_id=240 THEN
4170: IF NOT HZ_MATCH_RULE_240.check_staged THEN
4171: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4172: FND_MSG_PUB.ADD;
4173: RAISE FND_API.G_EXC_ERROR;
4174: END IF;

Line 4175: HZ_MATCH_RULE_240.call_api_dynamic(

4171: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4172: FND_MSG_PUB.ADD;
4173: RAISE FND_API.G_EXC_ERROR;
4174: END IF;
4175: HZ_MATCH_RULE_240.call_api_dynamic(
4176: p_rule_id,
4177: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
4178: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
4179: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 4504: IF NOT HZ_MATCH_RULE_2.check_staged THEN

4500: RAISE FND_API.G_EXC_ERROR;
4501: END IF;
4502: -- Code for Match rule SAMPLE: ORGANIZATIONS_OPTIMIZED
4503: IF p_rule_id=2 THEN
4504: IF NOT HZ_MATCH_RULE_2.check_staged THEN
4505: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4506: FND_MSG_PUB.ADD;
4507: RAISE FND_API.G_EXC_ERROR;
4508: END IF;

Line 4509: HZ_MATCH_RULE_2.get_matching_party_sites(

4505: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4506: FND_MSG_PUB.ADD;
4507: RAISE FND_API.G_EXC_ERROR;
4508: END IF;
4509: HZ_MATCH_RULE_2.get_matching_party_sites(
4510: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4511: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4512: -- Code for Match rule SAMPLE: PERSON_OPTIMIZED
4513: ELSIF p_rule_id=3 THEN

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 4804: IF NOT HZ_MATCH_RULE_240.check_staged THEN

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
4804: IF NOT HZ_MATCH_RULE_240.check_staged THEN
4805: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4806: FND_MSG_PUB.ADD;
4807: RAISE FND_API.G_EXC_ERROR;
4808: END IF;

Line 4809: HZ_MATCH_RULE_240.get_matching_party_sites(

4805: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4806: FND_MSG_PUB.ADD;
4807: RAISE FND_API.G_EXC_ERROR;
4808: END IF;
4809: HZ_MATCH_RULE_240.get_matching_party_sites(
4810: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4811: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4812: END IF;
4813: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 4923: IF NOT HZ_MATCH_RULE_2.check_staged THEN

4919: RAISE FND_API.G_EXC_ERROR;
4920: END IF;
4921: -- Code for Match rule SAMPLE: ORGANIZATIONS_OPTIMIZED
4922: IF p_rule_id=2 THEN
4923: IF NOT HZ_MATCH_RULE_2.check_staged THEN
4924: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4925: FND_MSG_PUB.ADD;
4926: RAISE FND_API.G_EXC_ERROR;
4927: END IF;

Line 4928: HZ_MATCH_RULE_2.get_matching_contacts(

4924: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4925: FND_MSG_PUB.ADD;
4926: RAISE FND_API.G_EXC_ERROR;
4927: END IF;
4928: HZ_MATCH_RULE_2.get_matching_contacts(
4929: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
4930: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4931: -- Code for Match rule SAMPLE: PERSON_OPTIMIZED
4932: ELSIF p_rule_id=3 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 5223: IF NOT HZ_MATCH_RULE_240.check_staged THEN

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
5223: IF NOT HZ_MATCH_RULE_240.check_staged THEN
5224: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5225: FND_MSG_PUB.ADD;
5226: RAISE FND_API.G_EXC_ERROR;
5227: END IF;

Line 5228: HZ_MATCH_RULE_240.get_matching_contacts(

5224: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5225: FND_MSG_PUB.ADD;
5226: RAISE FND_API.G_EXC_ERROR;
5227: END IF;
5228: HZ_MATCH_RULE_240.get_matching_contacts(
5229: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
5230: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5231: END IF;
5232: --Standard call to get message count and if count is 1, get message info

Line 5340: IF NOT HZ_MATCH_RULE_2.check_staged THEN

5336: RAISE FND_API.G_EXC_ERROR;
5337: END IF;
5338: -- Code for Match rule SAMPLE: ORGANIZATIONS_OPTIMIZED
5339: IF p_rule_id=2 THEN
5340: IF NOT HZ_MATCH_RULE_2.check_staged THEN
5341: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5342: FND_MSG_PUB.ADD;
5343: RAISE FND_API.G_EXC_ERROR;
5344: END IF;

Line 5345: HZ_MATCH_RULE_2.get_matching_contact_points(

5341: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5342: FND_MSG_PUB.ADD;
5343: RAISE FND_API.G_EXC_ERROR;
5344: END IF;
5345: HZ_MATCH_RULE_2.get_matching_contact_points(
5346: p_rule_id, p_party_id, p_contact_point_list,
5347: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5348: -- Code for Match rule SAMPLE: PERSON_OPTIMIZED
5349: ELSIF p_rule_id=3 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 5640: IF NOT HZ_MATCH_RULE_240.check_staged THEN

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
5640: IF NOT HZ_MATCH_RULE_240.check_staged THEN
5641: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5642: FND_MSG_PUB.ADD;
5643: RAISE FND_API.G_EXC_ERROR;
5644: END IF;

Line 5645: HZ_MATCH_RULE_240.get_matching_contact_points(

5641: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5642: FND_MSG_PUB.ADD;
5643: RAISE FND_API.G_EXC_ERROR;
5644: END IF;
5645: HZ_MATCH_RULE_240.get_matching_contact_points(
5646: p_rule_id, p_party_id, p_contact_point_list,
5647: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5648: END IF;
5649: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 5760: IF NOT HZ_MATCH_RULE_2.check_staged THEN

5756: RAISE FND_API.G_EXC_ERROR;
5757: END IF;
5758: -- Code for Match rule SAMPLE: ORGANIZATIONS_OPTIMIZED
5759: IF p_rule_id=2 THEN
5760: IF NOT HZ_MATCH_RULE_2.check_staged THEN
5761: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5762: FND_MSG_PUB.ADD;
5763: RAISE FND_API.G_EXC_ERROR;
5764: END IF;

Line 5765: HZ_MATCH_RULE_2.get_score_details(

5761: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5762: FND_MSG_PUB.ADD;
5763: RAISE FND_API.G_EXC_ERROR;
5764: END IF;
5765: HZ_MATCH_RULE_2.get_score_details(
5766: p_rule_id,
5767: p_party_id, p_party_search_rec,p_party_site_list,
5768: p_contact_list, p_contact_point_list,x_search_ctx_id);
5769: -- Code for Match rule SAMPLE: PERSON_OPTIMIZED

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 6090: IF NOT HZ_MATCH_RULE_240.check_staged THEN

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
6089: ELSIF p_rule_id=240 THEN
6090: IF NOT HZ_MATCH_RULE_240.check_staged THEN
6091: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6092: FND_MSG_PUB.ADD;
6093: RAISE FND_API.G_EXC_ERROR;
6094: END IF;

Line 6095: HZ_MATCH_RULE_240.get_score_details(

6091: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6092: FND_MSG_PUB.ADD;
6093: RAISE FND_API.G_EXC_ERROR;
6094: END IF;
6095: HZ_MATCH_RULE_240.get_score_details(
6096: p_rule_id,
6097: p_party_id, p_party_search_rec,p_party_site_list,
6098: p_contact_list, p_contact_point_list,x_search_ctx_id);
6099: END IF;

Line 6180: IF NOT HZ_MATCH_RULE_2.check_staged THEN

6176: RAISE FND_API.G_EXC_ERROR;
6177: END IF;
6178: -- Code for Match rule SAMPLE: ORGANIZATIONS_OPTIMIZED
6179: IF p_rule_id=2 THEN
6180: IF NOT HZ_MATCH_RULE_2.check_staged THEN
6181: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6182: FND_MSG_PUB.ADD;
6183: RAISE FND_API.G_EXC_ERROR;
6184: END IF;

Line 6185: HZ_MATCH_RULE_2.get_party_for_search(

6181: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6182: FND_MSG_PUB.ADD;
6183: RAISE FND_API.G_EXC_ERROR;
6184: END IF;
6185: HZ_MATCH_RULE_2.get_party_for_search(
6186: p_party_id, x_party_search_rec,x_party_site_list,
6187: x_contact_list, x_contact_point_list);
6188: -- Code for Match rule SAMPLE: PERSON_OPTIMIZED
6189: ELSIF p_rule_id=3 THEN

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 6480: IF NOT HZ_MATCH_RULE_240.check_staged THEN

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
6480: IF NOT HZ_MATCH_RULE_240.check_staged THEN
6481: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6482: FND_MSG_PUB.ADD;
6483: RAISE FND_API.G_EXC_ERROR;
6484: END IF;

Line 6485: HZ_MATCH_RULE_240.get_party_for_search(

6481: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6482: FND_MSG_PUB.ADD;
6483: RAISE FND_API.G_EXC_ERROR;
6484: END IF;
6485: HZ_MATCH_RULE_240.get_party_for_search(
6486: p_party_id, x_party_search_rec,x_party_site_list,
6487: x_contact_list, x_contact_point_list);
6488: END IF;
6489: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 6572: IF NOT HZ_MATCH_RULE_2.check_staged THEN

6568: RAISE FND_API.G_EXC_ERROR;
6569: END IF;
6570: -- Code for Match rule SAMPLE: ORGANIZATIONS_OPTIMIZED
6571: IF p_rule_id=2 THEN
6572: IF NOT HZ_MATCH_RULE_2.check_staged THEN
6573: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6574: FND_MSG_PUB.ADD;
6575: RAISE FND_API.G_EXC_ERROR;
6576: END IF;

Line 6577: HZ_MATCH_RULE_2.get_search_criteria(

6573: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6574: FND_MSG_PUB.ADD;
6575: RAISE FND_API.G_EXC_ERROR;
6576: END IF;
6577: HZ_MATCH_RULE_2.get_search_criteria(
6578: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6579: x_contact_list, x_contact_point_list);
6580: -- Code for Match rule SAMPLE: PERSON_OPTIMIZED
6581: ELSIF p_rule_id=3 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

Line 6872: IF NOT HZ_MATCH_RULE_240.check_staged THEN

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
6872: IF NOT HZ_MATCH_RULE_240.check_staged THEN
6873: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6874: FND_MSG_PUB.ADD;
6875: RAISE FND_API.G_EXC_ERROR;
6876: END IF;

Line 6877: HZ_MATCH_RULE_240.get_search_criteria(

6873: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6874: FND_MSG_PUB.ADD;
6875: RAISE FND_API.G_EXC_ERROR;
6876: END IF;
6877: HZ_MATCH_RULE_240.get_search_criteria(
6878: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6879: x_contact_list, x_contact_point_list);
6880: END IF;
6881: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN