APPS.HZ_PARTY_SEARCH dependencies on HZ_MATCH_RULE_6

Line 150: IF NOT HZ_MATCH_RULE_6.check_staged THEN

146: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
147: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,NULL,NULL,NULL,'N',x_search_ctx_id,x_num_matches);
148: -- Code for Match rule SAMPLE: SIMILAR_ORGANIZATION
149: ELSIF p_rule_id=6 THEN
150: IF NOT HZ_MATCH_RULE_6.check_staged THEN
151: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
152: FND_MSG_PUB.ADD;
153: RAISE FND_API.G_EXC_ERROR;
154: END IF;

Line 155: HZ_MATCH_RULE_6.find_parties(

151: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
152: FND_MSG_PUB.ADD;
153: RAISE FND_API.G_EXC_ERROR;
154: END IF;
155: HZ_MATCH_RULE_6.find_parties(
156: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
157: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,NULL,NULL,NULL,'N',x_search_ctx_id,x_num_matches);
158: -- Code for Match rule SAMPLE: SIMILAR_PERSON
159: ELSIF p_rule_id=7 THEN

Line 350: IF NOT HZ_MATCH_RULE_60.check_staged THEN

346: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
347: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,NULL,NULL,NULL,'N',x_search_ctx_id,x_num_matches);
348: -- Code for Match rule HZ_PERSON_ADVANCED_SEARCH_MATCH_RULE
349: ELSIF p_rule_id=60 THEN
350: IF NOT HZ_MATCH_RULE_60.check_staged THEN
351: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
352: FND_MSG_PUB.ADD;
353: RAISE FND_API.G_EXC_ERROR;
354: END IF;

Line 355: HZ_MATCH_RULE_60.find_parties(

351: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
352: FND_MSG_PUB.ADD;
353: RAISE FND_API.G_EXC_ERROR;
354: END IF;
355: HZ_MATCH_RULE_60.find_parties(
356: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
357: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,NULL,NULL,NULL,'N',x_search_ctx_id,x_num_matches);
358: -- Code for Match rule HZ_ORG_SIMPLE_SEARCH_RULE
359: ELSIF p_rule_id=61 THEN

Line 360: IF NOT HZ_MATCH_RULE_61.check_staged THEN

356: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
357: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,NULL,NULL,NULL,'N',x_search_ctx_id,x_num_matches);
358: -- Code for Match rule HZ_ORG_SIMPLE_SEARCH_RULE
359: ELSIF p_rule_id=61 THEN
360: IF NOT HZ_MATCH_RULE_61.check_staged THEN
361: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
362: FND_MSG_PUB.ADD;
363: RAISE FND_API.G_EXC_ERROR;
364: END IF;

Line 365: HZ_MATCH_RULE_61.find_parties(

361: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
362: FND_MSG_PUB.ADD;
363: RAISE FND_API.G_EXC_ERROR;
364: END IF;
365: HZ_MATCH_RULE_61.find_parties(
366: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
367: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,NULL,NULL,NULL,'N',x_search_ctx_id,x_num_matches);
368: -- Code for Match rule HZ_ORG_ADV_SEARCH_RULE
369: ELSIF p_rule_id=62 THEN

Line 370: IF NOT HZ_MATCH_RULE_62.check_staged THEN

366: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
367: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,NULL,NULL,NULL,'N',x_search_ctx_id,x_num_matches);
368: -- Code for Match rule HZ_ORG_ADV_SEARCH_RULE
369: ELSIF p_rule_id=62 THEN
370: IF NOT HZ_MATCH_RULE_62.check_staged THEN
371: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
372: FND_MSG_PUB.ADD;
373: RAISE FND_API.G_EXC_ERROR;
374: END IF;

Line 375: HZ_MATCH_RULE_62.find_parties(

371: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
372: FND_MSG_PUB.ADD;
373: RAISE FND_API.G_EXC_ERROR;
374: END IF;
375: HZ_MATCH_RULE_62.find_parties(
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

Line 551: IF NOT HZ_MATCH_RULE_6.check_staged THEN

547: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
548: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,'N',x_search_ctx_id,x_num_matches);
549: -- Code for Match rule SAMPLE: SIMILAR_ORGANIZATION
550: ELSIF p_rule_id=6 THEN
551: IF NOT HZ_MATCH_RULE_6.check_staged THEN
552: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
553: FND_MSG_PUB.ADD;
554: RAISE FND_API.G_EXC_ERROR;
555: END IF;

Line 556: HZ_MATCH_RULE_6.find_persons(

552: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
553: FND_MSG_PUB.ADD;
554: RAISE FND_API.G_EXC_ERROR;
555: END IF;
556: HZ_MATCH_RULE_6.find_persons(
557: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
558: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,'N',x_search_ctx_id,x_num_matches);
559: -- Code for Match rule SAMPLE: SIMILAR_PERSON
560: ELSIF p_rule_id=7 THEN

Line 751: IF NOT HZ_MATCH_RULE_60.check_staged THEN

747: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
748: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,'N',x_search_ctx_id,x_num_matches);
749: -- Code for Match rule HZ_PERSON_ADVANCED_SEARCH_MATCH_RULE
750: ELSIF p_rule_id=60 THEN
751: IF NOT HZ_MATCH_RULE_60.check_staged THEN
752: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
753: FND_MSG_PUB.ADD;
754: RAISE FND_API.G_EXC_ERROR;
755: END IF;

Line 756: HZ_MATCH_RULE_60.find_persons(

752: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
753: FND_MSG_PUB.ADD;
754: RAISE FND_API.G_EXC_ERROR;
755: END IF;
756: HZ_MATCH_RULE_60.find_persons(
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_ORG_SIMPLE_SEARCH_RULE
760: ELSIF p_rule_id=61 THEN

Line 761: IF NOT HZ_MATCH_RULE_61.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_ORG_SIMPLE_SEARCH_RULE
760: ELSIF p_rule_id=61 THEN
761: IF NOT HZ_MATCH_RULE_61.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_61.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_61.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_ORG_ADV_SEARCH_RULE
770: ELSIF p_rule_id=62 THEN

Line 771: IF NOT HZ_MATCH_RULE_62.check_staged THEN

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_ORG_ADV_SEARCH_RULE
770: ELSIF p_rule_id=62 THEN
771: IF NOT HZ_MATCH_RULE_62.check_staged THEN
772: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
773: FND_MSG_PUB.ADD;
774: RAISE FND_API.G_EXC_ERROR;
775: END IF;

Line 776: HZ_MATCH_RULE_62.find_persons(

772: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
773: FND_MSG_PUB.ADD;
774: RAISE FND_API.G_EXC_ERROR;
775: END IF;
776: HZ_MATCH_RULE_62.find_persons(
777: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
778: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,'N',x_search_ctx_id,x_num_matches);
779: -- Code for Match rule HZ_CONTACT_SIMPLE_SEARCH_RULE
780: ELSIF p_rule_id=98 THEN

Line 970: IF NOT HZ_MATCH_RULE_6.check_staged THEN

966: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
967: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
968: -- Code for Match rule SAMPLE: SIMILAR_ORGANIZATION
969: ELSIF p_rule_id=6 THEN
970: IF NOT HZ_MATCH_RULE_6.check_staged THEN
971: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
972: FND_MSG_PUB.ADD;
973: RAISE FND_API.G_EXC_ERROR;
974: END IF;

Line 975: HZ_MATCH_RULE_6.find_party_details(

971: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
972: FND_MSG_PUB.ADD;
973: RAISE FND_API.G_EXC_ERROR;
974: END IF;
975: HZ_MATCH_RULE_6.find_party_details(
976: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
977: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
978: -- Code for Match rule SAMPLE: SIMILAR_PERSON
979: ELSIF p_rule_id=7 THEN

Line 1170: IF NOT HZ_MATCH_RULE_60.check_staged THEN

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_PERSON_ADVANCED_SEARCH_MATCH_RULE
1169: ELSIF p_rule_id=60 THEN
1170: IF NOT HZ_MATCH_RULE_60.check_staged THEN
1171: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1172: FND_MSG_PUB.ADD;
1173: RAISE FND_API.G_EXC_ERROR;
1174: END IF;

Line 1175: HZ_MATCH_RULE_60.find_party_details(

1171: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1172: FND_MSG_PUB.ADD;
1173: RAISE FND_API.G_EXC_ERROR;
1174: END IF;
1175: HZ_MATCH_RULE_60.find_party_details(
1176: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
1177: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
1178: -- Code for Match rule HZ_ORG_SIMPLE_SEARCH_RULE
1179: ELSIF p_rule_id=61 THEN

Line 1180: IF NOT HZ_MATCH_RULE_61.check_staged THEN

1176: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
1177: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
1178: -- Code for Match rule HZ_ORG_SIMPLE_SEARCH_RULE
1179: ELSIF p_rule_id=61 THEN
1180: IF NOT HZ_MATCH_RULE_61.check_staged THEN
1181: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1182: FND_MSG_PUB.ADD;
1183: RAISE FND_API.G_EXC_ERROR;
1184: END IF;

Line 1185: HZ_MATCH_RULE_61.find_party_details(

1181: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1182: FND_MSG_PUB.ADD;
1183: RAISE FND_API.G_EXC_ERROR;
1184: END IF;
1185: HZ_MATCH_RULE_61.find_party_details(
1186: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
1187: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
1188: -- Code for Match rule HZ_ORG_ADV_SEARCH_RULE
1189: ELSIF p_rule_id=62 THEN

Line 1190: IF NOT HZ_MATCH_RULE_62.check_staged THEN

1186: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
1187: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
1188: -- Code for Match rule HZ_ORG_ADV_SEARCH_RULE
1189: ELSIF p_rule_id=62 THEN
1190: IF NOT HZ_MATCH_RULE_62.check_staged THEN
1191: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1192: FND_MSG_PUB.ADD;
1193: RAISE FND_API.G_EXC_ERROR;
1194: END IF;

Line 1195: HZ_MATCH_RULE_62.find_party_details(

1191: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1192: FND_MSG_PUB.ADD;
1193: RAISE FND_API.G_EXC_ERROR;
1194: END IF;
1195: HZ_MATCH_RULE_62.find_party_details(
1196: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
1197: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
1198: -- Code for Match rule HZ_CONTACT_SIMPLE_SEARCH_RULE
1199: ELSIF p_rule_id=98 THEN

Line 1370: IF NOT HZ_MATCH_RULE_6.check_staged THEN

1366: p_rule_id,p_party_id,
1367: p_restrict_sql,p_match_type,p_dup_batch_id,p_search_merged,x_dup_set_id, x_search_ctx_id,x_num_matches);
1368: -- Code for Match rule SAMPLE: SIMILAR_ORGANIZATION
1369: ELSIF p_rule_id=6 THEN
1370: IF NOT HZ_MATCH_RULE_6.check_staged THEN
1371: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1372: FND_MSG_PUB.ADD;
1373: RAISE FND_API.G_EXC_ERROR;
1374: END IF;

Line 1375: HZ_MATCH_RULE_6.find_duplicate_parties(

1371: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1372: FND_MSG_PUB.ADD;
1373: RAISE FND_API.G_EXC_ERROR;
1374: END IF;
1375: HZ_MATCH_RULE_6.find_duplicate_parties(
1376: p_rule_id,p_party_id,
1377: p_restrict_sql,p_match_type,p_dup_batch_id,p_search_merged,x_dup_set_id, x_search_ctx_id,x_num_matches);
1378: -- Code for Match rule SAMPLE: SIMILAR_PERSON
1379: ELSIF p_rule_id=7 THEN

Line 1570: IF NOT HZ_MATCH_RULE_60.check_staged THEN

1566: p_rule_id,p_party_id,
1567: p_restrict_sql,p_match_type,p_dup_batch_id,p_search_merged,x_dup_set_id, x_search_ctx_id,x_num_matches);
1568: -- Code for Match rule HZ_PERSON_ADVANCED_SEARCH_MATCH_RULE
1569: ELSIF p_rule_id=60 THEN
1570: IF NOT HZ_MATCH_RULE_60.check_staged THEN
1571: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1572: FND_MSG_PUB.ADD;
1573: RAISE FND_API.G_EXC_ERROR;
1574: END IF;

Line 1575: HZ_MATCH_RULE_60.find_duplicate_parties(

1571: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1572: FND_MSG_PUB.ADD;
1573: RAISE FND_API.G_EXC_ERROR;
1574: END IF;
1575: HZ_MATCH_RULE_60.find_duplicate_parties(
1576: p_rule_id,p_party_id,
1577: p_restrict_sql,p_match_type,p_dup_batch_id,p_search_merged,x_dup_set_id, x_search_ctx_id,x_num_matches);
1578: -- Code for Match rule HZ_ORG_SIMPLE_SEARCH_RULE
1579: ELSIF p_rule_id=61 THEN

Line 1580: IF NOT HZ_MATCH_RULE_61.check_staged THEN

1576: p_rule_id,p_party_id,
1577: p_restrict_sql,p_match_type,p_dup_batch_id,p_search_merged,x_dup_set_id, x_search_ctx_id,x_num_matches);
1578: -- Code for Match rule HZ_ORG_SIMPLE_SEARCH_RULE
1579: ELSIF p_rule_id=61 THEN
1580: IF NOT HZ_MATCH_RULE_61.check_staged THEN
1581: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1582: FND_MSG_PUB.ADD;
1583: RAISE FND_API.G_EXC_ERROR;
1584: END IF;

Line 1585: HZ_MATCH_RULE_61.find_duplicate_parties(

1581: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1582: FND_MSG_PUB.ADD;
1583: RAISE FND_API.G_EXC_ERROR;
1584: END IF;
1585: HZ_MATCH_RULE_61.find_duplicate_parties(
1586: p_rule_id,p_party_id,
1587: p_restrict_sql,p_match_type,p_dup_batch_id,p_search_merged,x_dup_set_id, x_search_ctx_id,x_num_matches);
1588: -- Code for Match rule HZ_ORG_ADV_SEARCH_RULE
1589: ELSIF p_rule_id=62 THEN

Line 1590: IF NOT HZ_MATCH_RULE_62.check_staged THEN

1586: p_rule_id,p_party_id,
1587: p_restrict_sql,p_match_type,p_dup_batch_id,p_search_merged,x_dup_set_id, x_search_ctx_id,x_num_matches);
1588: -- Code for Match rule HZ_ORG_ADV_SEARCH_RULE
1589: ELSIF p_rule_id=62 THEN
1590: IF NOT HZ_MATCH_RULE_62.check_staged THEN
1591: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1592: FND_MSG_PUB.ADD;
1593: RAISE FND_API.G_EXC_ERROR;
1594: END IF;

Line 1595: HZ_MATCH_RULE_62.find_duplicate_parties(

1591: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1592: FND_MSG_PUB.ADD;
1593: RAISE FND_API.G_EXC_ERROR;
1594: END IF;
1595: HZ_MATCH_RULE_62.find_duplicate_parties(
1596: p_rule_id,p_party_id,
1597: p_restrict_sql,p_match_type,p_dup_batch_id,p_search_merged,x_dup_set_id, x_search_ctx_id,x_num_matches);
1598: -- Code for Match rule HZ_CONTACT_SIMPLE_SEARCH_RULE
1599: ELSIF p_rule_id=98 THEN

Line 1765: IF NOT HZ_MATCH_RULE_6.check_staged THEN

1761: p_rule_id,p_party_site_id,p_party_id,
1762: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
1763: -- Code for Match rule SAMPLE: SIMILAR_ORGANIZATION
1764: ELSIF p_rule_id=6 THEN
1765: IF NOT HZ_MATCH_RULE_6.check_staged THEN
1766: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1767: FND_MSG_PUB.ADD;
1768: RAISE FND_API.G_EXC_ERROR;
1769: END IF;

Line 1770: HZ_MATCH_RULE_6.find_duplicate_party_sites(

1766: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1767: FND_MSG_PUB.ADD;
1768: RAISE FND_API.G_EXC_ERROR;
1769: END IF;
1770: HZ_MATCH_RULE_6.find_duplicate_party_sites(
1771: p_rule_id,p_party_site_id,p_party_id,
1772: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
1773: -- Code for Match rule SAMPLE: SIMILAR_PERSON
1774: ELSIF p_rule_id=7 THEN

Line 1965: IF NOT HZ_MATCH_RULE_60.check_staged THEN

1961: p_rule_id,p_party_site_id,p_party_id,
1962: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
1963: -- Code for Match rule HZ_PERSON_ADVANCED_SEARCH_MATCH_RULE
1964: ELSIF p_rule_id=60 THEN
1965: IF NOT HZ_MATCH_RULE_60.check_staged THEN
1966: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1967: FND_MSG_PUB.ADD;
1968: RAISE FND_API.G_EXC_ERROR;
1969: END IF;

Line 1970: HZ_MATCH_RULE_60.find_duplicate_party_sites(

1966: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1967: FND_MSG_PUB.ADD;
1968: RAISE FND_API.G_EXC_ERROR;
1969: END IF;
1970: HZ_MATCH_RULE_60.find_duplicate_party_sites(
1971: p_rule_id,p_party_site_id,p_party_id,
1972: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
1973: -- Code for Match rule HZ_ORG_SIMPLE_SEARCH_RULE
1974: ELSIF p_rule_id=61 THEN

Line 1975: IF NOT HZ_MATCH_RULE_61.check_staged THEN

1971: p_rule_id,p_party_site_id,p_party_id,
1972: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
1973: -- Code for Match rule HZ_ORG_SIMPLE_SEARCH_RULE
1974: ELSIF p_rule_id=61 THEN
1975: IF NOT HZ_MATCH_RULE_61.check_staged THEN
1976: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1977: FND_MSG_PUB.ADD;
1978: RAISE FND_API.G_EXC_ERROR;
1979: END IF;

Line 1980: HZ_MATCH_RULE_61.find_duplicate_party_sites(

1976: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1977: FND_MSG_PUB.ADD;
1978: RAISE FND_API.G_EXC_ERROR;
1979: END IF;
1980: HZ_MATCH_RULE_61.find_duplicate_party_sites(
1981: p_rule_id,p_party_site_id,p_party_id,
1982: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
1983: -- Code for Match rule HZ_ORG_ADV_SEARCH_RULE
1984: ELSIF p_rule_id=62 THEN

Line 1985: IF NOT HZ_MATCH_RULE_62.check_staged THEN

1981: p_rule_id,p_party_site_id,p_party_id,
1982: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
1983: -- Code for Match rule HZ_ORG_ADV_SEARCH_RULE
1984: ELSIF p_rule_id=62 THEN
1985: IF NOT HZ_MATCH_RULE_62.check_staged THEN
1986: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1987: FND_MSG_PUB.ADD;
1988: RAISE FND_API.G_EXC_ERROR;
1989: END IF;

Line 1990: HZ_MATCH_RULE_62.find_duplicate_party_sites(

1986: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1987: FND_MSG_PUB.ADD;
1988: RAISE FND_API.G_EXC_ERROR;
1989: END IF;
1990: HZ_MATCH_RULE_62.find_duplicate_party_sites(
1991: p_rule_id,p_party_site_id,p_party_id,
1992: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
1993: -- Code for Match rule HZ_CONTACT_SIMPLE_SEARCH_RULE
1994: ELSIF p_rule_id=98 THEN

Line 2159: IF NOT HZ_MATCH_RULE_6.check_staged THEN

2155: p_rule_id,p_org_contact_id,p_party_id,
2156: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2157: -- Code for Match rule SAMPLE: SIMILAR_ORGANIZATION
2158: ELSIF p_rule_id=6 THEN
2159: IF NOT HZ_MATCH_RULE_6.check_staged THEN
2160: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2161: FND_MSG_PUB.ADD;
2162: RAISE FND_API.G_EXC_ERROR;
2163: END IF;

Line 2164: HZ_MATCH_RULE_6.find_duplicate_contacts(

2160: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2161: FND_MSG_PUB.ADD;
2162: RAISE FND_API.G_EXC_ERROR;
2163: END IF;
2164: HZ_MATCH_RULE_6.find_duplicate_contacts(
2165: p_rule_id,p_org_contact_id,p_party_id,
2166: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2167: -- Code for Match rule SAMPLE: SIMILAR_PERSON
2168: ELSIF p_rule_id=7 THEN

Line 2359: IF NOT HZ_MATCH_RULE_60.check_staged THEN

2355: p_rule_id,p_org_contact_id,p_party_id,
2356: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2357: -- Code for Match rule HZ_PERSON_ADVANCED_SEARCH_MATCH_RULE
2358: ELSIF p_rule_id=60 THEN
2359: IF NOT HZ_MATCH_RULE_60.check_staged THEN
2360: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2361: FND_MSG_PUB.ADD;
2362: RAISE FND_API.G_EXC_ERROR;
2363: END IF;

Line 2364: HZ_MATCH_RULE_60.find_duplicate_contacts(

2360: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2361: FND_MSG_PUB.ADD;
2362: RAISE FND_API.G_EXC_ERROR;
2363: END IF;
2364: HZ_MATCH_RULE_60.find_duplicate_contacts(
2365: p_rule_id,p_org_contact_id,p_party_id,
2366: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2367: -- Code for Match rule HZ_ORG_SIMPLE_SEARCH_RULE
2368: ELSIF p_rule_id=61 THEN

Line 2369: IF NOT HZ_MATCH_RULE_61.check_staged THEN

2365: p_rule_id,p_org_contact_id,p_party_id,
2366: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2367: -- Code for Match rule HZ_ORG_SIMPLE_SEARCH_RULE
2368: ELSIF p_rule_id=61 THEN
2369: IF NOT HZ_MATCH_RULE_61.check_staged THEN
2370: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2371: FND_MSG_PUB.ADD;
2372: RAISE FND_API.G_EXC_ERROR;
2373: END IF;

Line 2374: HZ_MATCH_RULE_61.find_duplicate_contacts(

2370: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2371: FND_MSG_PUB.ADD;
2372: RAISE FND_API.G_EXC_ERROR;
2373: END IF;
2374: HZ_MATCH_RULE_61.find_duplicate_contacts(
2375: p_rule_id,p_org_contact_id,p_party_id,
2376: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2377: -- Code for Match rule HZ_ORG_ADV_SEARCH_RULE
2378: ELSIF p_rule_id=62 THEN

Line 2379: IF NOT HZ_MATCH_RULE_62.check_staged THEN

2375: p_rule_id,p_org_contact_id,p_party_id,
2376: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2377: -- Code for Match rule HZ_ORG_ADV_SEARCH_RULE
2378: ELSIF p_rule_id=62 THEN
2379: IF NOT HZ_MATCH_RULE_62.check_staged THEN
2380: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2381: FND_MSG_PUB.ADD;
2382: RAISE FND_API.G_EXC_ERROR;
2383: END IF;

Line 2384: HZ_MATCH_RULE_62.find_duplicate_contacts(

2380: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2381: FND_MSG_PUB.ADD;
2382: RAISE FND_API.G_EXC_ERROR;
2383: END IF;
2384: HZ_MATCH_RULE_62.find_duplicate_contacts(
2385: p_rule_id,p_org_contact_id,p_party_id,
2386: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2387: -- Code for Match rule HZ_CONTACT_SIMPLE_SEARCH_RULE
2388: ELSIF p_rule_id=98 THEN

Line 2553: IF NOT HZ_MATCH_RULE_6.check_staged THEN

2549: p_rule_id,p_contact_point_id,p_party_id,
2550: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2551: -- Code for Match rule SAMPLE: SIMILAR_ORGANIZATION
2552: ELSIF p_rule_id=6 THEN
2553: IF NOT HZ_MATCH_RULE_6.check_staged THEN
2554: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2555: FND_MSG_PUB.ADD;
2556: RAISE FND_API.G_EXC_ERROR;
2557: END IF;

Line 2558: HZ_MATCH_RULE_6.find_duplicate_contact_points(

2554: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2555: FND_MSG_PUB.ADD;
2556: RAISE FND_API.G_EXC_ERROR;
2557: END IF;
2558: HZ_MATCH_RULE_6.find_duplicate_contact_points(
2559: p_rule_id,p_contact_point_id,p_party_id,
2560: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2561: -- Code for Match rule SAMPLE: SIMILAR_PERSON
2562: ELSIF p_rule_id=7 THEN

Line 2753: IF NOT HZ_MATCH_RULE_60.check_staged THEN

2749: p_rule_id,p_contact_point_id,p_party_id,
2750: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2751: -- Code for Match rule HZ_PERSON_ADVANCED_SEARCH_MATCH_RULE
2752: ELSIF p_rule_id=60 THEN
2753: IF NOT HZ_MATCH_RULE_60.check_staged THEN
2754: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2755: FND_MSG_PUB.ADD;
2756: RAISE FND_API.G_EXC_ERROR;
2757: END IF;

Line 2758: HZ_MATCH_RULE_60.find_duplicate_contact_points(

2754: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2755: FND_MSG_PUB.ADD;
2756: RAISE FND_API.G_EXC_ERROR;
2757: END IF;
2758: HZ_MATCH_RULE_60.find_duplicate_contact_points(
2759: p_rule_id,p_contact_point_id,p_party_id,
2760: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2761: -- Code for Match rule HZ_ORG_SIMPLE_SEARCH_RULE
2762: ELSIF p_rule_id=61 THEN

Line 2763: IF NOT HZ_MATCH_RULE_61.check_staged THEN

2759: p_rule_id,p_contact_point_id,p_party_id,
2760: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2761: -- Code for Match rule HZ_ORG_SIMPLE_SEARCH_RULE
2762: ELSIF p_rule_id=61 THEN
2763: IF NOT HZ_MATCH_RULE_61.check_staged THEN
2764: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2765: FND_MSG_PUB.ADD;
2766: RAISE FND_API.G_EXC_ERROR;
2767: END IF;

Line 2768: HZ_MATCH_RULE_61.find_duplicate_contact_points(

2764: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2765: FND_MSG_PUB.ADD;
2766: RAISE FND_API.G_EXC_ERROR;
2767: END IF;
2768: HZ_MATCH_RULE_61.find_duplicate_contact_points(
2769: p_rule_id,p_contact_point_id,p_party_id,
2770: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2771: -- Code for Match rule HZ_ORG_ADV_SEARCH_RULE
2772: ELSIF p_rule_id=62 THEN

Line 2773: IF NOT HZ_MATCH_RULE_62.check_staged THEN

2769: p_rule_id,p_contact_point_id,p_party_id,
2770: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2771: -- Code for Match rule HZ_ORG_ADV_SEARCH_RULE
2772: ELSIF p_rule_id=62 THEN
2773: IF NOT HZ_MATCH_RULE_62.check_staged THEN
2774: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2775: FND_MSG_PUB.ADD;
2776: RAISE FND_API.G_EXC_ERROR;
2777: END IF;

Line 2778: HZ_MATCH_RULE_62.find_duplicate_contact_points(

2774: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2775: FND_MSG_PUB.ADD;
2776: RAISE FND_API.G_EXC_ERROR;
2777: END IF;
2778: HZ_MATCH_RULE_62.find_duplicate_contact_points(
2779: p_rule_id,p_contact_point_id,p_party_id,
2780: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2781: -- Code for Match rule HZ_CONTACT_SIMPLE_SEARCH_RULE
2782: ELSIF p_rule_id=98 THEN

Line 3019: IF NOT HZ_MATCH_RULE_6.check_staged THEN

3015: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3016: p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
3017: -- Code for Match rule SAMPLE: SIMILAR_ORGANIZATION
3018: ELSIF p_rule_id=6 THEN
3019: IF NOT HZ_MATCH_RULE_6.check_staged THEN
3020: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3021: FND_MSG_PUB.ADD;
3022: RAISE FND_API.G_EXC_ERROR;
3023: END IF;

Line 3024: HZ_MATCH_RULE_6.find_parties_dynamic(

3020: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3021: FND_MSG_PUB.ADD;
3022: RAISE FND_API.G_EXC_ERROR;
3023: END IF;
3024: HZ_MATCH_RULE_6.find_parties_dynamic(
3025: p_rule_id,
3026: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
3027: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
3028: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 3379: IF NOT HZ_MATCH_RULE_60.check_staged THEN

3375: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3376: p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
3377: -- Code for Match rule HZ_PERSON_ADVANCED_SEARCH_MATCH_RULE
3378: ELSIF p_rule_id=60 THEN
3379: IF NOT HZ_MATCH_RULE_60.check_staged THEN
3380: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3381: FND_MSG_PUB.ADD;
3382: RAISE FND_API.G_EXC_ERROR;
3383: END IF;

Line 3384: HZ_MATCH_RULE_60.find_parties_dynamic(

3380: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3381: FND_MSG_PUB.ADD;
3382: RAISE FND_API.G_EXC_ERROR;
3383: END IF;
3384: HZ_MATCH_RULE_60.find_parties_dynamic(
3385: p_rule_id,
3386: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
3387: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
3388: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 3397: IF NOT HZ_MATCH_RULE_61.check_staged THEN

3393: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3394: p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
3395: -- Code for Match rule HZ_ORG_SIMPLE_SEARCH_RULE
3396: ELSIF p_rule_id=61 THEN
3397: IF NOT HZ_MATCH_RULE_61.check_staged THEN
3398: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3399: FND_MSG_PUB.ADD;
3400: RAISE FND_API.G_EXC_ERROR;
3401: END IF;

Line 3402: HZ_MATCH_RULE_61.find_parties_dynamic(

3398: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3399: FND_MSG_PUB.ADD;
3400: RAISE FND_API.G_EXC_ERROR;
3401: END IF;
3402: HZ_MATCH_RULE_61.find_parties_dynamic(
3403: p_rule_id,
3404: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
3405: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
3406: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 3415: IF NOT HZ_MATCH_RULE_62.check_staged THEN

3411: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3412: p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
3413: -- Code for Match rule HZ_ORG_ADV_SEARCH_RULE
3414: ELSIF p_rule_id=62 THEN
3415: IF NOT HZ_MATCH_RULE_62.check_staged THEN
3416: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3417: FND_MSG_PUB.ADD;
3418: RAISE FND_API.G_EXC_ERROR;
3419: END IF;

Line 3420: HZ_MATCH_RULE_62.find_parties_dynamic(

3416: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3417: FND_MSG_PUB.ADD;
3418: RAISE FND_API.G_EXC_ERROR;
3419: END IF;
3420: HZ_MATCH_RULE_62.find_parties_dynamic(
3421: p_rule_id,
3422: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
3423: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
3424: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 3702: IF NOT HZ_MATCH_RULE_6.check_staged THEN

3698: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3699: p_restrict_sql,p_api_name,p_match_type,p_party_id,p_search_merged,x_search_ctx_id,x_num_matches);
3700: -- Code for Match rule SAMPLE: SIMILAR_ORGANIZATION
3701: ELSIF p_rule_id=6 THEN
3702: IF NOT HZ_MATCH_RULE_6.check_staged THEN
3703: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3704: FND_MSG_PUB.ADD;
3705: RAISE FND_API.G_EXC_ERROR;
3706: END IF;

Line 3707: HZ_MATCH_RULE_6.call_api_dynamic(

3703: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3704: FND_MSG_PUB.ADD;
3705: RAISE FND_API.G_EXC_ERROR;
3706: END IF;
3707: HZ_MATCH_RULE_6.call_api_dynamic(
3708: p_rule_id,
3709: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
3710: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
3711: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 4062: IF NOT HZ_MATCH_RULE_60.check_staged THEN

4058: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
4059: p_restrict_sql,p_api_name,p_match_type,p_party_id,p_search_merged,x_search_ctx_id,x_num_matches);
4060: -- Code for Match rule HZ_PERSON_ADVANCED_SEARCH_MATCH_RULE
4061: ELSIF p_rule_id=60 THEN
4062: IF NOT HZ_MATCH_RULE_60.check_staged THEN
4063: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4064: FND_MSG_PUB.ADD;
4065: RAISE FND_API.G_EXC_ERROR;
4066: END IF;

Line 4067: HZ_MATCH_RULE_60.call_api_dynamic(

4063: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4064: FND_MSG_PUB.ADD;
4065: RAISE FND_API.G_EXC_ERROR;
4066: END IF;
4067: HZ_MATCH_RULE_60.call_api_dynamic(
4068: p_rule_id,
4069: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
4070: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
4071: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 4080: IF NOT HZ_MATCH_RULE_61.check_staged THEN

4076: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
4077: p_restrict_sql,p_api_name,p_match_type,p_party_id,p_search_merged,x_search_ctx_id,x_num_matches);
4078: -- Code for Match rule HZ_ORG_SIMPLE_SEARCH_RULE
4079: ELSIF p_rule_id=61 THEN
4080: IF NOT HZ_MATCH_RULE_61.check_staged THEN
4081: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4082: FND_MSG_PUB.ADD;
4083: RAISE FND_API.G_EXC_ERROR;
4084: END IF;

Line 4085: HZ_MATCH_RULE_61.call_api_dynamic(

4081: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4082: FND_MSG_PUB.ADD;
4083: RAISE FND_API.G_EXC_ERROR;
4084: END IF;
4085: HZ_MATCH_RULE_61.call_api_dynamic(
4086: p_rule_id,
4087: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
4088: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
4089: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 4098: IF NOT HZ_MATCH_RULE_62.check_staged THEN

4094: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
4095: p_restrict_sql,p_api_name,p_match_type,p_party_id,p_search_merged,x_search_ctx_id,x_num_matches);
4096: -- Code for Match rule HZ_ORG_ADV_SEARCH_RULE
4097: ELSIF p_rule_id=62 THEN
4098: IF NOT HZ_MATCH_RULE_62.check_staged THEN
4099: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4100: FND_MSG_PUB.ADD;
4101: RAISE FND_API.G_EXC_ERROR;
4102: END IF;

Line 4103: HZ_MATCH_RULE_62.call_api_dynamic(

4099: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4100: FND_MSG_PUB.ADD;
4101: RAISE FND_API.G_EXC_ERROR;
4102: END IF;
4103: HZ_MATCH_RULE_62.call_api_dynamic(
4104: p_rule_id,
4105: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
4106: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
4107: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 4544: IF NOT HZ_MATCH_RULE_6.check_staged THEN

4540: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4541: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4542: -- Code for Match rule SAMPLE: SIMILAR_ORGANIZATION
4543: ELSIF p_rule_id=6 THEN
4544: IF NOT HZ_MATCH_RULE_6.check_staged THEN
4545: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4546: FND_MSG_PUB.ADD;
4547: RAISE FND_API.G_EXC_ERROR;
4548: END IF;

Line 4549: HZ_MATCH_RULE_6.get_matching_party_sites(

4545: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4546: FND_MSG_PUB.ADD;
4547: RAISE FND_API.G_EXC_ERROR;
4548: END IF;
4549: HZ_MATCH_RULE_6.get_matching_party_sites(
4550: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4551: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4552: -- Code for Match rule SAMPLE: SIMILAR_PERSON
4553: ELSIF p_rule_id=7 THEN

Line 4744: IF NOT HZ_MATCH_RULE_60.check_staged THEN

4740: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4741: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4742: -- Code for Match rule HZ_PERSON_ADVANCED_SEARCH_MATCH_RULE
4743: ELSIF p_rule_id=60 THEN
4744: IF NOT HZ_MATCH_RULE_60.check_staged THEN
4745: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4746: FND_MSG_PUB.ADD;
4747: RAISE FND_API.G_EXC_ERROR;
4748: END IF;

Line 4749: HZ_MATCH_RULE_60.get_matching_party_sites(

4745: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4746: FND_MSG_PUB.ADD;
4747: RAISE FND_API.G_EXC_ERROR;
4748: END IF;
4749: HZ_MATCH_RULE_60.get_matching_party_sites(
4750: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4751: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4752: -- Code for Match rule HZ_ORG_SIMPLE_SEARCH_RULE
4753: ELSIF p_rule_id=61 THEN

Line 4754: IF NOT HZ_MATCH_RULE_61.check_staged THEN

4750: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4751: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4752: -- Code for Match rule HZ_ORG_SIMPLE_SEARCH_RULE
4753: ELSIF p_rule_id=61 THEN
4754: IF NOT HZ_MATCH_RULE_61.check_staged THEN
4755: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4756: FND_MSG_PUB.ADD;
4757: RAISE FND_API.G_EXC_ERROR;
4758: END IF;

Line 4759: HZ_MATCH_RULE_61.get_matching_party_sites(

4755: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4756: FND_MSG_PUB.ADD;
4757: RAISE FND_API.G_EXC_ERROR;
4758: END IF;
4759: HZ_MATCH_RULE_61.get_matching_party_sites(
4760: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4761: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4762: -- Code for Match rule HZ_ORG_ADV_SEARCH_RULE
4763: ELSIF p_rule_id=62 THEN

Line 4764: IF NOT HZ_MATCH_RULE_62.check_staged THEN

4760: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4761: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4762: -- Code for Match rule HZ_ORG_ADV_SEARCH_RULE
4763: ELSIF p_rule_id=62 THEN
4764: IF NOT HZ_MATCH_RULE_62.check_staged THEN
4765: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4766: FND_MSG_PUB.ADD;
4767: RAISE FND_API.G_EXC_ERROR;
4768: END IF;

Line 4769: HZ_MATCH_RULE_62.get_matching_party_sites(

4765: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4766: FND_MSG_PUB.ADD;
4767: RAISE FND_API.G_EXC_ERROR;
4768: END IF;
4769: HZ_MATCH_RULE_62.get_matching_party_sites(
4770: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4771: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4772: -- Code for Match rule HZ_CONTACT_SIMPLE_SEARCH_RULE
4773: ELSIF p_rule_id=98 THEN

Line 4963: IF NOT HZ_MATCH_RULE_6.check_staged THEN

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

Line 4968: HZ_MATCH_RULE_6.get_matching_contacts(

4964: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4965: FND_MSG_PUB.ADD;
4966: RAISE FND_API.G_EXC_ERROR;
4967: END IF;
4968: HZ_MATCH_RULE_6.get_matching_contacts(
4969: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
4970: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4971: -- Code for Match rule SAMPLE: SIMILAR_PERSON
4972: ELSIF p_rule_id=7 THEN

Line 5163: IF NOT HZ_MATCH_RULE_60.check_staged THEN

5159: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
5160: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5161: -- Code for Match rule HZ_PERSON_ADVANCED_SEARCH_MATCH_RULE
5162: ELSIF p_rule_id=60 THEN
5163: IF NOT HZ_MATCH_RULE_60.check_staged THEN
5164: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5165: FND_MSG_PUB.ADD;
5166: RAISE FND_API.G_EXC_ERROR;
5167: END IF;

Line 5168: HZ_MATCH_RULE_60.get_matching_contacts(

5164: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5165: FND_MSG_PUB.ADD;
5166: RAISE FND_API.G_EXC_ERROR;
5167: END IF;
5168: HZ_MATCH_RULE_60.get_matching_contacts(
5169: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
5170: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5171: -- Code for Match rule HZ_ORG_SIMPLE_SEARCH_RULE
5172: ELSIF p_rule_id=61 THEN

Line 5173: IF NOT HZ_MATCH_RULE_61.check_staged THEN

5169: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
5170: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5171: -- Code for Match rule HZ_ORG_SIMPLE_SEARCH_RULE
5172: ELSIF p_rule_id=61 THEN
5173: IF NOT HZ_MATCH_RULE_61.check_staged THEN
5174: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5175: FND_MSG_PUB.ADD;
5176: RAISE FND_API.G_EXC_ERROR;
5177: END IF;

Line 5178: HZ_MATCH_RULE_61.get_matching_contacts(

5174: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5175: FND_MSG_PUB.ADD;
5176: RAISE FND_API.G_EXC_ERROR;
5177: END IF;
5178: HZ_MATCH_RULE_61.get_matching_contacts(
5179: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
5180: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5181: -- Code for Match rule HZ_ORG_ADV_SEARCH_RULE
5182: ELSIF p_rule_id=62 THEN

Line 5183: IF NOT HZ_MATCH_RULE_62.check_staged THEN

5179: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
5180: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5181: -- Code for Match rule HZ_ORG_ADV_SEARCH_RULE
5182: ELSIF p_rule_id=62 THEN
5183: IF NOT HZ_MATCH_RULE_62.check_staged THEN
5184: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5185: FND_MSG_PUB.ADD;
5186: RAISE FND_API.G_EXC_ERROR;
5187: END IF;

Line 5188: HZ_MATCH_RULE_62.get_matching_contacts(

5184: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5185: FND_MSG_PUB.ADD;
5186: RAISE FND_API.G_EXC_ERROR;
5187: END IF;
5188: HZ_MATCH_RULE_62.get_matching_contacts(
5189: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
5190: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5191: -- Code for Match rule HZ_CONTACT_SIMPLE_SEARCH_RULE
5192: ELSIF p_rule_id=98 THEN

Line 5380: IF NOT HZ_MATCH_RULE_6.check_staged THEN

5376: p_rule_id, p_party_id, p_contact_point_list,
5377: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5378: -- Code for Match rule SAMPLE: SIMILAR_ORGANIZATION
5379: ELSIF p_rule_id=6 THEN
5380: IF NOT HZ_MATCH_RULE_6.check_staged THEN
5381: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5382: FND_MSG_PUB.ADD;
5383: RAISE FND_API.G_EXC_ERROR;
5384: END IF;

Line 5385: HZ_MATCH_RULE_6.get_matching_contact_points(

5381: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5382: FND_MSG_PUB.ADD;
5383: RAISE FND_API.G_EXC_ERROR;
5384: END IF;
5385: HZ_MATCH_RULE_6.get_matching_contact_points(
5386: p_rule_id, p_party_id, p_contact_point_list,
5387: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5388: -- Code for Match rule SAMPLE: SIMILAR_PERSON
5389: ELSIF p_rule_id=7 THEN

Line 5580: IF NOT HZ_MATCH_RULE_60.check_staged THEN

5576: p_rule_id, p_party_id, p_contact_point_list,
5577: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5578: -- Code for Match rule HZ_PERSON_ADVANCED_SEARCH_MATCH_RULE
5579: ELSIF p_rule_id=60 THEN
5580: IF NOT HZ_MATCH_RULE_60.check_staged THEN
5581: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5582: FND_MSG_PUB.ADD;
5583: RAISE FND_API.G_EXC_ERROR;
5584: END IF;

Line 5585: HZ_MATCH_RULE_60.get_matching_contact_points(

5581: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5582: FND_MSG_PUB.ADD;
5583: RAISE FND_API.G_EXC_ERROR;
5584: END IF;
5585: HZ_MATCH_RULE_60.get_matching_contact_points(
5586: p_rule_id, p_party_id, p_contact_point_list,
5587: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5588: -- Code for Match rule HZ_ORG_SIMPLE_SEARCH_RULE
5589: ELSIF p_rule_id=61 THEN

Line 5590: IF NOT HZ_MATCH_RULE_61.check_staged THEN

5586: p_rule_id, p_party_id, p_contact_point_list,
5587: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5588: -- Code for Match rule HZ_ORG_SIMPLE_SEARCH_RULE
5589: ELSIF p_rule_id=61 THEN
5590: IF NOT HZ_MATCH_RULE_61.check_staged THEN
5591: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5592: FND_MSG_PUB.ADD;
5593: RAISE FND_API.G_EXC_ERROR;
5594: END IF;

Line 5595: HZ_MATCH_RULE_61.get_matching_contact_points(

5591: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5592: FND_MSG_PUB.ADD;
5593: RAISE FND_API.G_EXC_ERROR;
5594: END IF;
5595: HZ_MATCH_RULE_61.get_matching_contact_points(
5596: p_rule_id, p_party_id, p_contact_point_list,
5597: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5598: -- Code for Match rule HZ_ORG_ADV_SEARCH_RULE
5599: ELSIF p_rule_id=62 THEN

Line 5600: IF NOT HZ_MATCH_RULE_62.check_staged THEN

5596: p_rule_id, p_party_id, p_contact_point_list,
5597: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5598: -- Code for Match rule HZ_ORG_ADV_SEARCH_RULE
5599: ELSIF p_rule_id=62 THEN
5600: IF NOT HZ_MATCH_RULE_62.check_staged THEN
5601: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5602: FND_MSG_PUB.ADD;
5603: RAISE FND_API.G_EXC_ERROR;
5604: END IF;

Line 5605: HZ_MATCH_RULE_62.get_matching_contact_points(

5601: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5602: FND_MSG_PUB.ADD;
5603: RAISE FND_API.G_EXC_ERROR;
5604: END IF;
5605: HZ_MATCH_RULE_62.get_matching_contact_points(
5606: p_rule_id, p_party_id, p_contact_point_list,
5607: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5608: -- Code for Match rule HZ_CONTACT_SIMPLE_SEARCH_RULE
5609: ELSIF p_rule_id=98 THEN

Line 5804: IF NOT HZ_MATCH_RULE_6.check_staged THEN

5800: p_party_id, p_party_search_rec,p_party_site_list,
5801: p_contact_list, p_contact_point_list,x_search_ctx_id);
5802: -- Code for Match rule SAMPLE: SIMILAR_ORGANIZATION
5803: ELSIF p_rule_id=6 THEN
5804: IF NOT HZ_MATCH_RULE_6.check_staged THEN
5805: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5806: FND_MSG_PUB.ADD;
5807: RAISE FND_API.G_EXC_ERROR;
5808: END IF;

Line 5809: HZ_MATCH_RULE_6.get_score_details(

5805: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5806: FND_MSG_PUB.ADD;
5807: RAISE FND_API.G_EXC_ERROR;
5808: END IF;
5809: HZ_MATCH_RULE_6.get_score_details(
5810: p_rule_id,
5811: p_party_id, p_party_search_rec,p_party_site_list,
5812: p_contact_list, p_contact_point_list,x_search_ctx_id);
5813: -- Code for Match rule SAMPLE: SIMILAR_PERSON

Line 6024: IF NOT HZ_MATCH_RULE_60.check_staged THEN

6020: p_party_id, p_party_search_rec,p_party_site_list,
6021: p_contact_list, p_contact_point_list,x_search_ctx_id);
6022: -- Code for Match rule HZ_PERSON_ADVANCED_SEARCH_MATCH_RULE
6023: ELSIF p_rule_id=60 THEN
6024: IF NOT HZ_MATCH_RULE_60.check_staged THEN
6025: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6026: FND_MSG_PUB.ADD;
6027: RAISE FND_API.G_EXC_ERROR;
6028: END IF;

Line 6029: HZ_MATCH_RULE_60.get_score_details(

6025: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6026: FND_MSG_PUB.ADD;
6027: RAISE FND_API.G_EXC_ERROR;
6028: END IF;
6029: HZ_MATCH_RULE_60.get_score_details(
6030: p_rule_id,
6031: p_party_id, p_party_search_rec,p_party_site_list,
6032: p_contact_list, p_contact_point_list,x_search_ctx_id);
6033: -- Code for Match rule HZ_ORG_SIMPLE_SEARCH_RULE

Line 6035: IF NOT HZ_MATCH_RULE_61.check_staged THEN

6031: p_party_id, p_party_search_rec,p_party_site_list,
6032: p_contact_list, p_contact_point_list,x_search_ctx_id);
6033: -- Code for Match rule HZ_ORG_SIMPLE_SEARCH_RULE
6034: ELSIF p_rule_id=61 THEN
6035: IF NOT HZ_MATCH_RULE_61.check_staged THEN
6036: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6037: FND_MSG_PUB.ADD;
6038: RAISE FND_API.G_EXC_ERROR;
6039: END IF;

Line 6040: HZ_MATCH_RULE_61.get_score_details(

6036: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6037: FND_MSG_PUB.ADD;
6038: RAISE FND_API.G_EXC_ERROR;
6039: END IF;
6040: HZ_MATCH_RULE_61.get_score_details(
6041: p_rule_id,
6042: p_party_id, p_party_search_rec,p_party_site_list,
6043: p_contact_list, p_contact_point_list,x_search_ctx_id);
6044: -- Code for Match rule HZ_ORG_ADV_SEARCH_RULE

Line 6046: IF NOT HZ_MATCH_RULE_62.check_staged THEN

6042: p_party_id, p_party_search_rec,p_party_site_list,
6043: p_contact_list, p_contact_point_list,x_search_ctx_id);
6044: -- Code for Match rule HZ_ORG_ADV_SEARCH_RULE
6045: ELSIF p_rule_id=62 THEN
6046: IF NOT HZ_MATCH_RULE_62.check_staged THEN
6047: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6048: FND_MSG_PUB.ADD;
6049: RAISE FND_API.G_EXC_ERROR;
6050: END IF;

Line 6051: HZ_MATCH_RULE_62.get_score_details(

6047: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6048: FND_MSG_PUB.ADD;
6049: RAISE FND_API.G_EXC_ERROR;
6050: END IF;
6051: HZ_MATCH_RULE_62.get_score_details(
6052: p_rule_id,
6053: p_party_id, p_party_search_rec,p_party_site_list,
6054: p_contact_list, p_contact_point_list,x_search_ctx_id);
6055: -- Code for Match rule HZ_CONTACT_SIMPLE_SEARCH_RULE

Line 6220: IF NOT HZ_MATCH_RULE_6.check_staged THEN

6216: p_party_id, x_party_search_rec,x_party_site_list,
6217: x_contact_list, x_contact_point_list);
6218: -- Code for Match rule SAMPLE: SIMILAR_ORGANIZATION
6219: ELSIF p_rule_id=6 THEN
6220: IF NOT HZ_MATCH_RULE_6.check_staged THEN
6221: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6222: FND_MSG_PUB.ADD;
6223: RAISE FND_API.G_EXC_ERROR;
6224: END IF;

Line 6225: HZ_MATCH_RULE_6.get_party_for_search(

6221: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6222: FND_MSG_PUB.ADD;
6223: RAISE FND_API.G_EXC_ERROR;
6224: END IF;
6225: HZ_MATCH_RULE_6.get_party_for_search(
6226: p_party_id, x_party_search_rec,x_party_site_list,
6227: x_contact_list, x_contact_point_list);
6228: -- Code for Match rule SAMPLE: SIMILAR_PERSON
6229: ELSIF p_rule_id=7 THEN

Line 6420: IF NOT HZ_MATCH_RULE_60.check_staged THEN

6416: p_party_id, x_party_search_rec,x_party_site_list,
6417: x_contact_list, x_contact_point_list);
6418: -- Code for Match rule HZ_PERSON_ADVANCED_SEARCH_MATCH_RULE
6419: ELSIF p_rule_id=60 THEN
6420: IF NOT HZ_MATCH_RULE_60.check_staged THEN
6421: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6422: FND_MSG_PUB.ADD;
6423: RAISE FND_API.G_EXC_ERROR;
6424: END IF;

Line 6425: HZ_MATCH_RULE_60.get_party_for_search(

6421: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6422: FND_MSG_PUB.ADD;
6423: RAISE FND_API.G_EXC_ERROR;
6424: END IF;
6425: HZ_MATCH_RULE_60.get_party_for_search(
6426: p_party_id, x_party_search_rec,x_party_site_list,
6427: x_contact_list, x_contact_point_list);
6428: -- Code for Match rule HZ_ORG_SIMPLE_SEARCH_RULE
6429: ELSIF p_rule_id=61 THEN

Line 6430: IF NOT HZ_MATCH_RULE_61.check_staged THEN

6426: p_party_id, x_party_search_rec,x_party_site_list,
6427: x_contact_list, x_contact_point_list);
6428: -- Code for Match rule HZ_ORG_SIMPLE_SEARCH_RULE
6429: ELSIF p_rule_id=61 THEN
6430: IF NOT HZ_MATCH_RULE_61.check_staged THEN
6431: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6432: FND_MSG_PUB.ADD;
6433: RAISE FND_API.G_EXC_ERROR;
6434: END IF;

Line 6435: HZ_MATCH_RULE_61.get_party_for_search(

6431: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6432: FND_MSG_PUB.ADD;
6433: RAISE FND_API.G_EXC_ERROR;
6434: END IF;
6435: HZ_MATCH_RULE_61.get_party_for_search(
6436: p_party_id, x_party_search_rec,x_party_site_list,
6437: x_contact_list, x_contact_point_list);
6438: -- Code for Match rule HZ_ORG_ADV_SEARCH_RULE
6439: ELSIF p_rule_id=62 THEN

Line 6440: IF NOT HZ_MATCH_RULE_62.check_staged THEN

6436: p_party_id, x_party_search_rec,x_party_site_list,
6437: x_contact_list, x_contact_point_list);
6438: -- Code for Match rule HZ_ORG_ADV_SEARCH_RULE
6439: ELSIF p_rule_id=62 THEN
6440: IF NOT HZ_MATCH_RULE_62.check_staged THEN
6441: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6442: FND_MSG_PUB.ADD;
6443: RAISE FND_API.G_EXC_ERROR;
6444: END IF;

Line 6445: HZ_MATCH_RULE_62.get_party_for_search(

6441: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6442: FND_MSG_PUB.ADD;
6443: RAISE FND_API.G_EXC_ERROR;
6444: END IF;
6445: HZ_MATCH_RULE_62.get_party_for_search(
6446: p_party_id, x_party_search_rec,x_party_site_list,
6447: x_contact_list, x_contact_point_list);
6448: -- Code for Match rule HZ_CONTACT_SIMPLE_SEARCH_RULE
6449: ELSIF p_rule_id=98 THEN

Line 6612: IF NOT HZ_MATCH_RULE_6.check_staged THEN

6608: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6609: x_contact_list, x_contact_point_list);
6610: -- Code for Match rule SAMPLE: SIMILAR_ORGANIZATION
6611: ELSIF p_rule_id=6 THEN
6612: IF NOT HZ_MATCH_RULE_6.check_staged THEN
6613: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6614: FND_MSG_PUB.ADD;
6615: RAISE FND_API.G_EXC_ERROR;
6616: END IF;

Line 6617: HZ_MATCH_RULE_6.get_search_criteria(

6613: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6614: FND_MSG_PUB.ADD;
6615: RAISE FND_API.G_EXC_ERROR;
6616: END IF;
6617: HZ_MATCH_RULE_6.get_search_criteria(
6618: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6619: x_contact_list, x_contact_point_list);
6620: -- Code for Match rule SAMPLE: SIMILAR_PERSON
6621: ELSIF p_rule_id=7 THEN

Line 6812: IF NOT HZ_MATCH_RULE_60.check_staged THEN

6808: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6809: x_contact_list, x_contact_point_list);
6810: -- Code for Match rule HZ_PERSON_ADVANCED_SEARCH_MATCH_RULE
6811: ELSIF p_rule_id=60 THEN
6812: IF NOT HZ_MATCH_RULE_60.check_staged THEN
6813: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6814: FND_MSG_PUB.ADD;
6815: RAISE FND_API.G_EXC_ERROR;
6816: END IF;

Line 6817: HZ_MATCH_RULE_60.get_search_criteria(

6813: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6814: FND_MSG_PUB.ADD;
6815: RAISE FND_API.G_EXC_ERROR;
6816: END IF;
6817: HZ_MATCH_RULE_60.get_search_criteria(
6818: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6819: x_contact_list, x_contact_point_list);
6820: -- Code for Match rule HZ_ORG_SIMPLE_SEARCH_RULE
6821: ELSIF p_rule_id=61 THEN

Line 6822: IF NOT HZ_MATCH_RULE_61.check_staged THEN

6818: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6819: x_contact_list, x_contact_point_list);
6820: -- Code for Match rule HZ_ORG_SIMPLE_SEARCH_RULE
6821: ELSIF p_rule_id=61 THEN
6822: IF NOT HZ_MATCH_RULE_61.check_staged THEN
6823: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6824: FND_MSG_PUB.ADD;
6825: RAISE FND_API.G_EXC_ERROR;
6826: END IF;

Line 6827: HZ_MATCH_RULE_61.get_search_criteria(

6823: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6824: FND_MSG_PUB.ADD;
6825: RAISE FND_API.G_EXC_ERROR;
6826: END IF;
6827: HZ_MATCH_RULE_61.get_search_criteria(
6828: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6829: x_contact_list, x_contact_point_list);
6830: -- Code for Match rule HZ_ORG_ADV_SEARCH_RULE
6831: ELSIF p_rule_id=62 THEN

Line 6832: IF NOT HZ_MATCH_RULE_62.check_staged THEN

6828: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6829: x_contact_list, x_contact_point_list);
6830: -- Code for Match rule HZ_ORG_ADV_SEARCH_RULE
6831: ELSIF p_rule_id=62 THEN
6832: IF NOT HZ_MATCH_RULE_62.check_staged THEN
6833: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6834: FND_MSG_PUB.ADD;
6835: RAISE FND_API.G_EXC_ERROR;
6836: END IF;

Line 6837: HZ_MATCH_RULE_62.get_search_criteria(

6833: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6834: FND_MSG_PUB.ADD;
6835: RAISE FND_API.G_EXC_ERROR;
6836: END IF;
6837: HZ_MATCH_RULE_62.get_search_criteria(
6838: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6839: x_contact_list, x_contact_point_list);
6840: -- Code for Match rule HZ_CONTACT_SIMPLE_SEARCH_RULE
6841: ELSIF p_rule_id=98 THEN