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 531: IF NOT HZ_MATCH_RULE_6.check_staged THEN

527: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
528: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,'N',x_search_ctx_id,x_num_matches);
529: -- Code for Match rule SAMPLE: SIMILAR_ORGANIZATION
530: ELSIF p_rule_id=6 THEN
531: IF NOT HZ_MATCH_RULE_6.check_staged THEN
532: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
533: FND_MSG_PUB.ADD;
534: RAISE FND_API.G_EXC_ERROR;
535: END IF;

Line 536: HZ_MATCH_RULE_6.find_persons(

532: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
533: FND_MSG_PUB.ADD;
534: RAISE FND_API.G_EXC_ERROR;
535: END IF;
536: HZ_MATCH_RULE_6.find_persons(
537: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
538: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,'N',x_search_ctx_id,x_num_matches);
539: -- Code for Match rule SAMPLE: SIMILAR_PERSON
540: ELSIF p_rule_id=7 THEN

Line 731: IF NOT HZ_MATCH_RULE_60.check_staged THEN

727: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
728: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,'N',x_search_ctx_id,x_num_matches);
729: -- Code for Match rule HZ_PERSON_ADVANCED_SEARCH_MATCH_RULE
730: ELSIF p_rule_id=60 THEN
731: IF NOT HZ_MATCH_RULE_60.check_staged THEN
732: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
733: FND_MSG_PUB.ADD;
734: RAISE FND_API.G_EXC_ERROR;
735: END IF;

Line 736: HZ_MATCH_RULE_60.find_persons(

732: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
733: FND_MSG_PUB.ADD;
734: RAISE FND_API.G_EXC_ERROR;
735: END IF;
736: HZ_MATCH_RULE_60.find_persons(
737: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
738: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,'N',x_search_ctx_id,x_num_matches);
739: -- Code for Match rule HZ_ORG_SIMPLE_SEARCH_RULE
740: ELSIF p_rule_id=61 THEN

Line 741: IF NOT HZ_MATCH_RULE_61.check_staged THEN

737: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
738: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,'N',x_search_ctx_id,x_num_matches);
739: -- Code for Match rule HZ_ORG_SIMPLE_SEARCH_RULE
740: ELSIF p_rule_id=61 THEN
741: IF NOT HZ_MATCH_RULE_61.check_staged THEN
742: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
743: FND_MSG_PUB.ADD;
744: RAISE FND_API.G_EXC_ERROR;
745: END IF;

Line 746: HZ_MATCH_RULE_61.find_persons(

742: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
743: FND_MSG_PUB.ADD;
744: RAISE FND_API.G_EXC_ERROR;
745: END IF;
746: HZ_MATCH_RULE_61.find_persons(
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_ORG_ADV_SEARCH_RULE
750: ELSIF p_rule_id=62 THEN

Line 751: IF NOT HZ_MATCH_RULE_62.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_ORG_ADV_SEARCH_RULE
750: ELSIF p_rule_id=62 THEN
751: IF NOT HZ_MATCH_RULE_62.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_62.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_62.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_CONTACT_SIMPLE_SEARCH_RULE
760: ELSIF p_rule_id=98 THEN

Line 930: IF NOT HZ_MATCH_RULE_6.check_staged THEN

926: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
927: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
928: -- Code for Match rule SAMPLE: SIMILAR_ORGANIZATION
929: ELSIF p_rule_id=6 THEN
930: IF NOT HZ_MATCH_RULE_6.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_6.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_6.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: SIMILAR_PERSON
939: ELSIF p_rule_id=7 THEN

Line 1130: IF NOT HZ_MATCH_RULE_60.check_staged THEN

1126: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
1127: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
1128: -- Code for Match rule HZ_PERSON_ADVANCED_SEARCH_MATCH_RULE
1129: ELSIF p_rule_id=60 THEN
1130: IF NOT HZ_MATCH_RULE_60.check_staged THEN
1131: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1132: FND_MSG_PUB.ADD;
1133: RAISE FND_API.G_EXC_ERROR;
1134: END IF;

Line 1135: HZ_MATCH_RULE_60.find_party_details(

1131: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1132: FND_MSG_PUB.ADD;
1133: RAISE FND_API.G_EXC_ERROR;
1134: END IF;
1135: HZ_MATCH_RULE_60.find_party_details(
1136: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
1137: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
1138: -- Code for Match rule HZ_ORG_SIMPLE_SEARCH_RULE
1139: ELSIF p_rule_id=61 THEN

Line 1140: IF NOT HZ_MATCH_RULE_61.check_staged THEN

1136: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
1137: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
1138: -- Code for Match rule HZ_ORG_SIMPLE_SEARCH_RULE
1139: ELSIF p_rule_id=61 THEN
1140: IF NOT HZ_MATCH_RULE_61.check_staged THEN
1141: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1142: FND_MSG_PUB.ADD;
1143: RAISE FND_API.G_EXC_ERROR;
1144: END IF;

Line 1145: HZ_MATCH_RULE_61.find_party_details(

1141: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1142: FND_MSG_PUB.ADD;
1143: RAISE FND_API.G_EXC_ERROR;
1144: END IF;
1145: HZ_MATCH_RULE_61.find_party_details(
1146: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
1147: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
1148: -- Code for Match rule HZ_ORG_ADV_SEARCH_RULE
1149: ELSIF p_rule_id=62 THEN

Line 1150: IF NOT HZ_MATCH_RULE_62.check_staged THEN

1146: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
1147: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
1148: -- Code for Match rule HZ_ORG_ADV_SEARCH_RULE
1149: ELSIF p_rule_id=62 THEN
1150: IF NOT HZ_MATCH_RULE_62.check_staged THEN
1151: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1152: FND_MSG_PUB.ADD;
1153: RAISE FND_API.G_EXC_ERROR;
1154: END IF;

Line 1155: HZ_MATCH_RULE_62.find_party_details(

1151: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1152: FND_MSG_PUB.ADD;
1153: RAISE FND_API.G_EXC_ERROR;
1154: END IF;
1155: HZ_MATCH_RULE_62.find_party_details(
1156: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
1157: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
1158: -- Code for Match rule HZ_CONTACT_SIMPLE_SEARCH_RULE
1159: ELSIF p_rule_id=98 THEN

Line 1310: IF NOT HZ_MATCH_RULE_6.check_staged THEN

1306: p_rule_id,p_party_id,
1307: p_restrict_sql,p_match_type,p_dup_batch_id,p_search_merged,x_dup_set_id, x_search_ctx_id,x_num_matches);
1308: -- Code for Match rule SAMPLE: SIMILAR_ORGANIZATION
1309: ELSIF p_rule_id=6 THEN
1310: IF NOT HZ_MATCH_RULE_6.check_staged THEN
1311: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1312: FND_MSG_PUB.ADD;
1313: RAISE FND_API.G_EXC_ERROR;
1314: END IF;

Line 1315: HZ_MATCH_RULE_6.find_duplicate_parties(

1311: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1312: FND_MSG_PUB.ADD;
1313: RAISE FND_API.G_EXC_ERROR;
1314: END IF;
1315: HZ_MATCH_RULE_6.find_duplicate_parties(
1316: p_rule_id,p_party_id,
1317: p_restrict_sql,p_match_type,p_dup_batch_id,p_search_merged,x_dup_set_id, x_search_ctx_id,x_num_matches);
1318: -- Code for Match rule SAMPLE: SIMILAR_PERSON
1319: ELSIF p_rule_id=7 THEN

Line 1510: IF NOT HZ_MATCH_RULE_60.check_staged THEN

1506: p_rule_id,p_party_id,
1507: p_restrict_sql,p_match_type,p_dup_batch_id,p_search_merged,x_dup_set_id, x_search_ctx_id,x_num_matches);
1508: -- Code for Match rule HZ_PERSON_ADVANCED_SEARCH_MATCH_RULE
1509: ELSIF p_rule_id=60 THEN
1510: IF NOT HZ_MATCH_RULE_60.check_staged THEN
1511: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1512: FND_MSG_PUB.ADD;
1513: RAISE FND_API.G_EXC_ERROR;
1514: END IF;

Line 1515: HZ_MATCH_RULE_60.find_duplicate_parties(

1511: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1512: FND_MSG_PUB.ADD;
1513: RAISE FND_API.G_EXC_ERROR;
1514: END IF;
1515: HZ_MATCH_RULE_60.find_duplicate_parties(
1516: p_rule_id,p_party_id,
1517: p_restrict_sql,p_match_type,p_dup_batch_id,p_search_merged,x_dup_set_id, x_search_ctx_id,x_num_matches);
1518: -- Code for Match rule HZ_ORG_SIMPLE_SEARCH_RULE
1519: ELSIF p_rule_id=61 THEN

Line 1520: IF NOT HZ_MATCH_RULE_61.check_staged THEN

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

Line 1525: HZ_MATCH_RULE_61.find_duplicate_parties(

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

Line 1530: IF NOT HZ_MATCH_RULE_62.check_staged THEN

1526: p_rule_id,p_party_id,
1527: p_restrict_sql,p_match_type,p_dup_batch_id,p_search_merged,x_dup_set_id, x_search_ctx_id,x_num_matches);
1528: -- Code for Match rule HZ_ORG_ADV_SEARCH_RULE
1529: ELSIF p_rule_id=62 THEN
1530: IF NOT HZ_MATCH_RULE_62.check_staged THEN
1531: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1532: FND_MSG_PUB.ADD;
1533: RAISE FND_API.G_EXC_ERROR;
1534: END IF;

Line 1535: HZ_MATCH_RULE_62.find_duplicate_parties(

1531: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1532: FND_MSG_PUB.ADD;
1533: RAISE FND_API.G_EXC_ERROR;
1534: END IF;
1535: HZ_MATCH_RULE_62.find_duplicate_parties(
1536: p_rule_id,p_party_id,
1537: p_restrict_sql,p_match_type,p_dup_batch_id,p_search_merged,x_dup_set_id, x_search_ctx_id,x_num_matches);
1538: -- Code for Match rule HZ_CONTACT_SIMPLE_SEARCH_RULE
1539: ELSIF p_rule_id=98 THEN

Line 1685: IF NOT HZ_MATCH_RULE_6.check_staged THEN

1681: p_rule_id,p_party_site_id,p_party_id,
1682: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
1683: -- Code for Match rule SAMPLE: SIMILAR_ORGANIZATION
1684: ELSIF p_rule_id=6 THEN
1685: IF NOT HZ_MATCH_RULE_6.check_staged THEN
1686: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1687: FND_MSG_PUB.ADD;
1688: RAISE FND_API.G_EXC_ERROR;
1689: END IF;

Line 1690: HZ_MATCH_RULE_6.find_duplicate_party_sites(

1686: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1687: FND_MSG_PUB.ADD;
1688: RAISE FND_API.G_EXC_ERROR;
1689: END IF;
1690: HZ_MATCH_RULE_6.find_duplicate_party_sites(
1691: p_rule_id,p_party_site_id,p_party_id,
1692: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
1693: -- Code for Match rule SAMPLE: SIMILAR_PERSON
1694: ELSIF p_rule_id=7 THEN

Line 1885: IF NOT HZ_MATCH_RULE_60.check_staged THEN

1881: p_rule_id,p_party_site_id,p_party_id,
1882: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
1883: -- Code for Match rule HZ_PERSON_ADVANCED_SEARCH_MATCH_RULE
1884: ELSIF p_rule_id=60 THEN
1885: IF NOT HZ_MATCH_RULE_60.check_staged THEN
1886: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1887: FND_MSG_PUB.ADD;
1888: RAISE FND_API.G_EXC_ERROR;
1889: END IF;

Line 1890: HZ_MATCH_RULE_60.find_duplicate_party_sites(

1886: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1887: FND_MSG_PUB.ADD;
1888: RAISE FND_API.G_EXC_ERROR;
1889: END IF;
1890: HZ_MATCH_RULE_60.find_duplicate_party_sites(
1891: p_rule_id,p_party_site_id,p_party_id,
1892: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
1893: -- Code for Match rule HZ_ORG_SIMPLE_SEARCH_RULE
1894: ELSIF p_rule_id=61 THEN

Line 1895: IF NOT HZ_MATCH_RULE_61.check_staged THEN

1891: p_rule_id,p_party_site_id,p_party_id,
1892: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
1893: -- Code for Match rule HZ_ORG_SIMPLE_SEARCH_RULE
1894: ELSIF p_rule_id=61 THEN
1895: IF NOT HZ_MATCH_RULE_61.check_staged THEN
1896: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1897: FND_MSG_PUB.ADD;
1898: RAISE FND_API.G_EXC_ERROR;
1899: END IF;

Line 1900: HZ_MATCH_RULE_61.find_duplicate_party_sites(

1896: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1897: FND_MSG_PUB.ADD;
1898: RAISE FND_API.G_EXC_ERROR;
1899: END IF;
1900: HZ_MATCH_RULE_61.find_duplicate_party_sites(
1901: p_rule_id,p_party_site_id,p_party_id,
1902: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
1903: -- Code for Match rule HZ_ORG_ADV_SEARCH_RULE
1904: ELSIF p_rule_id=62 THEN

Line 1905: IF NOT HZ_MATCH_RULE_62.check_staged THEN

1901: p_rule_id,p_party_site_id,p_party_id,
1902: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
1903: -- Code for Match rule HZ_ORG_ADV_SEARCH_RULE
1904: ELSIF p_rule_id=62 THEN
1905: IF NOT HZ_MATCH_RULE_62.check_staged THEN
1906: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1907: FND_MSG_PUB.ADD;
1908: RAISE FND_API.G_EXC_ERROR;
1909: END IF;

Line 1910: HZ_MATCH_RULE_62.find_duplicate_party_sites(

1906: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1907: FND_MSG_PUB.ADD;
1908: RAISE FND_API.G_EXC_ERROR;
1909: END IF;
1910: HZ_MATCH_RULE_62.find_duplicate_party_sites(
1911: p_rule_id,p_party_site_id,p_party_id,
1912: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
1913: -- Code for Match rule HZ_CONTACT_SIMPLE_SEARCH_RULE
1914: ELSIF p_rule_id=98 THEN

Line 2059: IF NOT HZ_MATCH_RULE_6.check_staged THEN

2055: p_rule_id,p_org_contact_id,p_party_id,
2056: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2057: -- Code for Match rule SAMPLE: SIMILAR_ORGANIZATION
2058: ELSIF p_rule_id=6 THEN
2059: IF NOT HZ_MATCH_RULE_6.check_staged THEN
2060: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2061: FND_MSG_PUB.ADD;
2062: RAISE FND_API.G_EXC_ERROR;
2063: END IF;

Line 2064: HZ_MATCH_RULE_6.find_duplicate_contacts(

2060: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2061: FND_MSG_PUB.ADD;
2062: RAISE FND_API.G_EXC_ERROR;
2063: END IF;
2064: HZ_MATCH_RULE_6.find_duplicate_contacts(
2065: p_rule_id,p_org_contact_id,p_party_id,
2066: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2067: -- Code for Match rule SAMPLE: SIMILAR_PERSON
2068: ELSIF p_rule_id=7 THEN

Line 2259: IF NOT HZ_MATCH_RULE_60.check_staged THEN

2255: p_rule_id,p_org_contact_id,p_party_id,
2256: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2257: -- Code for Match rule HZ_PERSON_ADVANCED_SEARCH_MATCH_RULE
2258: ELSIF p_rule_id=60 THEN
2259: IF NOT HZ_MATCH_RULE_60.check_staged THEN
2260: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2261: FND_MSG_PUB.ADD;
2262: RAISE FND_API.G_EXC_ERROR;
2263: END IF;

Line 2264: HZ_MATCH_RULE_60.find_duplicate_contacts(

2260: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2261: FND_MSG_PUB.ADD;
2262: RAISE FND_API.G_EXC_ERROR;
2263: END IF;
2264: HZ_MATCH_RULE_60.find_duplicate_contacts(
2265: p_rule_id,p_org_contact_id,p_party_id,
2266: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2267: -- Code for Match rule HZ_ORG_SIMPLE_SEARCH_RULE
2268: ELSIF p_rule_id=61 THEN

Line 2269: IF NOT HZ_MATCH_RULE_61.check_staged THEN

2265: p_rule_id,p_org_contact_id,p_party_id,
2266: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2267: -- Code for Match rule HZ_ORG_SIMPLE_SEARCH_RULE
2268: ELSIF p_rule_id=61 THEN
2269: IF NOT HZ_MATCH_RULE_61.check_staged THEN
2270: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2271: FND_MSG_PUB.ADD;
2272: RAISE FND_API.G_EXC_ERROR;
2273: END IF;

Line 2274: HZ_MATCH_RULE_61.find_duplicate_contacts(

2270: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2271: FND_MSG_PUB.ADD;
2272: RAISE FND_API.G_EXC_ERROR;
2273: END IF;
2274: HZ_MATCH_RULE_61.find_duplicate_contacts(
2275: p_rule_id,p_org_contact_id,p_party_id,
2276: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2277: -- Code for Match rule HZ_ORG_ADV_SEARCH_RULE
2278: ELSIF p_rule_id=62 THEN

Line 2279: IF NOT HZ_MATCH_RULE_62.check_staged THEN

2275: p_rule_id,p_org_contact_id,p_party_id,
2276: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2277: -- Code for Match rule HZ_ORG_ADV_SEARCH_RULE
2278: ELSIF p_rule_id=62 THEN
2279: IF NOT HZ_MATCH_RULE_62.check_staged THEN
2280: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2281: FND_MSG_PUB.ADD;
2282: RAISE FND_API.G_EXC_ERROR;
2283: END IF;

Line 2284: HZ_MATCH_RULE_62.find_duplicate_contacts(

2280: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2281: FND_MSG_PUB.ADD;
2282: RAISE FND_API.G_EXC_ERROR;
2283: END IF;
2284: HZ_MATCH_RULE_62.find_duplicate_contacts(
2285: p_rule_id,p_org_contact_id,p_party_id,
2286: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2287: -- Code for Match rule HZ_CONTACT_SIMPLE_SEARCH_RULE
2288: ELSIF p_rule_id=98 THEN

Line 2433: IF NOT HZ_MATCH_RULE_6.check_staged THEN

2429: p_rule_id,p_contact_point_id,p_party_id,
2430: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2431: -- Code for Match rule SAMPLE: SIMILAR_ORGANIZATION
2432: ELSIF p_rule_id=6 THEN
2433: IF NOT HZ_MATCH_RULE_6.check_staged THEN
2434: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2435: FND_MSG_PUB.ADD;
2436: RAISE FND_API.G_EXC_ERROR;
2437: END IF;

Line 2438: HZ_MATCH_RULE_6.find_duplicate_contact_points(

2434: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2435: FND_MSG_PUB.ADD;
2436: RAISE FND_API.G_EXC_ERROR;
2437: END IF;
2438: HZ_MATCH_RULE_6.find_duplicate_contact_points(
2439: p_rule_id,p_contact_point_id,p_party_id,
2440: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2441: -- Code for Match rule SAMPLE: SIMILAR_PERSON
2442: ELSIF p_rule_id=7 THEN

Line 2633: IF NOT HZ_MATCH_RULE_60.check_staged THEN

2629: p_rule_id,p_contact_point_id,p_party_id,
2630: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2631: -- Code for Match rule HZ_PERSON_ADVANCED_SEARCH_MATCH_RULE
2632: ELSIF p_rule_id=60 THEN
2633: IF NOT HZ_MATCH_RULE_60.check_staged THEN
2634: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2635: FND_MSG_PUB.ADD;
2636: RAISE FND_API.G_EXC_ERROR;
2637: END IF;

Line 2638: HZ_MATCH_RULE_60.find_duplicate_contact_points(

2634: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2635: FND_MSG_PUB.ADD;
2636: RAISE FND_API.G_EXC_ERROR;
2637: END IF;
2638: HZ_MATCH_RULE_60.find_duplicate_contact_points(
2639: p_rule_id,p_contact_point_id,p_party_id,
2640: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2641: -- Code for Match rule HZ_ORG_SIMPLE_SEARCH_RULE
2642: ELSIF p_rule_id=61 THEN

Line 2643: IF NOT HZ_MATCH_RULE_61.check_staged THEN

2639: p_rule_id,p_contact_point_id,p_party_id,
2640: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2641: -- Code for Match rule HZ_ORG_SIMPLE_SEARCH_RULE
2642: ELSIF p_rule_id=61 THEN
2643: IF NOT HZ_MATCH_RULE_61.check_staged THEN
2644: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2645: FND_MSG_PUB.ADD;
2646: RAISE FND_API.G_EXC_ERROR;
2647: END IF;

Line 2648: HZ_MATCH_RULE_61.find_duplicate_contact_points(

2644: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2645: FND_MSG_PUB.ADD;
2646: RAISE FND_API.G_EXC_ERROR;
2647: END IF;
2648: HZ_MATCH_RULE_61.find_duplicate_contact_points(
2649: p_rule_id,p_contact_point_id,p_party_id,
2650: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2651: -- Code for Match rule HZ_ORG_ADV_SEARCH_RULE
2652: ELSIF p_rule_id=62 THEN

Line 2653: IF NOT HZ_MATCH_RULE_62.check_staged THEN

2649: p_rule_id,p_contact_point_id,p_party_id,
2650: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2651: -- Code for Match rule HZ_ORG_ADV_SEARCH_RULE
2652: ELSIF p_rule_id=62 THEN
2653: IF NOT HZ_MATCH_RULE_62.check_staged THEN
2654: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2655: FND_MSG_PUB.ADD;
2656: RAISE FND_API.G_EXC_ERROR;
2657: END IF;

Line 2658: HZ_MATCH_RULE_62.find_duplicate_contact_points(

2654: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2655: FND_MSG_PUB.ADD;
2656: RAISE FND_API.G_EXC_ERROR;
2657: END IF;
2658: HZ_MATCH_RULE_62.find_duplicate_contact_points(
2659: p_rule_id,p_contact_point_id,p_party_id,
2660: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2661: -- Code for Match rule HZ_CONTACT_SIMPLE_SEARCH_RULE
2662: ELSIF p_rule_id=98 THEN

Line 2879: IF NOT HZ_MATCH_RULE_6.check_staged THEN

2875: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
2876: p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
2877: -- Code for Match rule SAMPLE: SIMILAR_ORGANIZATION
2878: ELSIF p_rule_id=6 THEN
2879: IF NOT HZ_MATCH_RULE_6.check_staged THEN
2880: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2881: FND_MSG_PUB.ADD;
2882: RAISE FND_API.G_EXC_ERROR;
2883: END IF;

Line 2884: HZ_MATCH_RULE_6.find_parties_dynamic(

2880: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2881: FND_MSG_PUB.ADD;
2882: RAISE FND_API.G_EXC_ERROR;
2883: END IF;
2884: HZ_MATCH_RULE_6.find_parties_dynamic(
2885: p_rule_id,
2886: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
2887: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
2888: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 3239: IF NOT HZ_MATCH_RULE_60.check_staged THEN

3235: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3236: p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
3237: -- Code for Match rule HZ_PERSON_ADVANCED_SEARCH_MATCH_RULE
3238: ELSIF p_rule_id=60 THEN
3239: IF NOT HZ_MATCH_RULE_60.check_staged THEN
3240: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3241: FND_MSG_PUB.ADD;
3242: RAISE FND_API.G_EXC_ERROR;
3243: END IF;

Line 3244: HZ_MATCH_RULE_60.find_parties_dynamic(

3240: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3241: FND_MSG_PUB.ADD;
3242: RAISE FND_API.G_EXC_ERROR;
3243: END IF;
3244: HZ_MATCH_RULE_60.find_parties_dynamic(
3245: p_rule_id,
3246: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
3247: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
3248: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 3257: IF NOT HZ_MATCH_RULE_61.check_staged THEN

3253: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3254: p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
3255: -- Code for Match rule HZ_ORG_SIMPLE_SEARCH_RULE
3256: ELSIF p_rule_id=61 THEN
3257: IF NOT HZ_MATCH_RULE_61.check_staged THEN
3258: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3259: FND_MSG_PUB.ADD;
3260: RAISE FND_API.G_EXC_ERROR;
3261: END IF;

Line 3262: HZ_MATCH_RULE_61.find_parties_dynamic(

3258: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3259: FND_MSG_PUB.ADD;
3260: RAISE FND_API.G_EXC_ERROR;
3261: END IF;
3262: HZ_MATCH_RULE_61.find_parties_dynamic(
3263: p_rule_id,
3264: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
3265: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
3266: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 3275: IF NOT HZ_MATCH_RULE_62.check_staged THEN

3271: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3272: p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
3273: -- Code for Match rule HZ_ORG_ADV_SEARCH_RULE
3274: ELSIF p_rule_id=62 THEN
3275: IF NOT HZ_MATCH_RULE_62.check_staged THEN
3276: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3277: FND_MSG_PUB.ADD;
3278: RAISE FND_API.G_EXC_ERROR;
3279: END IF;

Line 3280: HZ_MATCH_RULE_62.find_parties_dynamic(

3276: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3277: FND_MSG_PUB.ADD;
3278: RAISE FND_API.G_EXC_ERROR;
3279: END IF;
3280: HZ_MATCH_RULE_62.find_parties_dynamic(
3281: p_rule_id,
3282: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
3283: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
3284: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 3526: IF NOT HZ_MATCH_RULE_6.check_staged THEN

3522: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3523: p_restrict_sql,p_api_name,p_match_type,p_party_id,p_search_merged,x_search_ctx_id,x_num_matches);
3524: -- Code for Match rule SAMPLE: SIMILAR_ORGANIZATION
3525: ELSIF p_rule_id=6 THEN
3526: IF NOT HZ_MATCH_RULE_6.check_staged THEN
3527: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3528: FND_MSG_PUB.ADD;
3529: RAISE FND_API.G_EXC_ERROR;
3530: END IF;

Line 3531: HZ_MATCH_RULE_6.call_api_dynamic(

3527: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3528: FND_MSG_PUB.ADD;
3529: RAISE FND_API.G_EXC_ERROR;
3530: END IF;
3531: HZ_MATCH_RULE_6.call_api_dynamic(
3532: p_rule_id,
3533: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
3534: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
3535: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 3886: IF NOT HZ_MATCH_RULE_60.check_staged THEN

3882: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3883: p_restrict_sql,p_api_name,p_match_type,p_party_id,p_search_merged,x_search_ctx_id,x_num_matches);
3884: -- Code for Match rule HZ_PERSON_ADVANCED_SEARCH_MATCH_RULE
3885: ELSIF p_rule_id=60 THEN
3886: IF NOT HZ_MATCH_RULE_60.check_staged THEN
3887: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3888: FND_MSG_PUB.ADD;
3889: RAISE FND_API.G_EXC_ERROR;
3890: END IF;

Line 3891: HZ_MATCH_RULE_60.call_api_dynamic(

3887: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3888: FND_MSG_PUB.ADD;
3889: RAISE FND_API.G_EXC_ERROR;
3890: END IF;
3891: HZ_MATCH_RULE_60.call_api_dynamic(
3892: p_rule_id,
3893: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
3894: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
3895: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 3904: IF NOT HZ_MATCH_RULE_61.check_staged THEN

3900: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3901: p_restrict_sql,p_api_name,p_match_type,p_party_id,p_search_merged,x_search_ctx_id,x_num_matches);
3902: -- Code for Match rule HZ_ORG_SIMPLE_SEARCH_RULE
3903: ELSIF p_rule_id=61 THEN
3904: IF NOT HZ_MATCH_RULE_61.check_staged THEN
3905: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3906: FND_MSG_PUB.ADD;
3907: RAISE FND_API.G_EXC_ERROR;
3908: END IF;

Line 3909: HZ_MATCH_RULE_61.call_api_dynamic(

3905: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3906: FND_MSG_PUB.ADD;
3907: RAISE FND_API.G_EXC_ERROR;
3908: END IF;
3909: HZ_MATCH_RULE_61.call_api_dynamic(
3910: p_rule_id,
3911: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
3912: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
3913: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 3922: IF NOT HZ_MATCH_RULE_62.check_staged THEN

3918: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3919: p_restrict_sql,p_api_name,p_match_type,p_party_id,p_search_merged,x_search_ctx_id,x_num_matches);
3920: -- Code for Match rule HZ_ORG_ADV_SEARCH_RULE
3921: ELSIF p_rule_id=62 THEN
3922: IF NOT HZ_MATCH_RULE_62.check_staged THEN
3923: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3924: FND_MSG_PUB.ADD;
3925: RAISE FND_API.G_EXC_ERROR;
3926: END IF;

Line 3927: HZ_MATCH_RULE_62.call_api_dynamic(

3923: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3924: FND_MSG_PUB.ADD;
3925: RAISE FND_API.G_EXC_ERROR;
3926: END IF;
3927: HZ_MATCH_RULE_62.call_api_dynamic(
3928: p_rule_id,
3929: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
3930: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
3931: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 4332: IF NOT HZ_MATCH_RULE_6.check_staged THEN

4328: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4329: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4330: -- Code for Match rule SAMPLE: SIMILAR_ORGANIZATION
4331: ELSIF p_rule_id=6 THEN
4332: IF NOT HZ_MATCH_RULE_6.check_staged THEN
4333: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4334: FND_MSG_PUB.ADD;
4335: RAISE FND_API.G_EXC_ERROR;
4336: END IF;

Line 4337: HZ_MATCH_RULE_6.get_matching_party_sites(

4333: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4334: FND_MSG_PUB.ADD;
4335: RAISE FND_API.G_EXC_ERROR;
4336: END IF;
4337: HZ_MATCH_RULE_6.get_matching_party_sites(
4338: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4339: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4340: -- Code for Match rule SAMPLE: SIMILAR_PERSON
4341: ELSIF p_rule_id=7 THEN

Line 4532: IF NOT HZ_MATCH_RULE_60.check_staged THEN

4528: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4529: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4530: -- Code for Match rule HZ_PERSON_ADVANCED_SEARCH_MATCH_RULE
4531: ELSIF p_rule_id=60 THEN
4532: IF NOT HZ_MATCH_RULE_60.check_staged THEN
4533: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4534: FND_MSG_PUB.ADD;
4535: RAISE FND_API.G_EXC_ERROR;
4536: END IF;

Line 4537: HZ_MATCH_RULE_60.get_matching_party_sites(

4533: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4534: FND_MSG_PUB.ADD;
4535: RAISE FND_API.G_EXC_ERROR;
4536: END IF;
4537: HZ_MATCH_RULE_60.get_matching_party_sites(
4538: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4539: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4540: -- Code for Match rule HZ_ORG_SIMPLE_SEARCH_RULE
4541: ELSIF p_rule_id=61 THEN

Line 4542: IF NOT HZ_MATCH_RULE_61.check_staged THEN

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

Line 4547: HZ_MATCH_RULE_61.get_matching_party_sites(

4543: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4544: FND_MSG_PUB.ADD;
4545: RAISE FND_API.G_EXC_ERROR;
4546: END IF;
4547: HZ_MATCH_RULE_61.get_matching_party_sites(
4548: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4549: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4550: -- Code for Match rule HZ_ORG_ADV_SEARCH_RULE
4551: ELSIF p_rule_id=62 THEN

Line 4552: IF NOT HZ_MATCH_RULE_62.check_staged THEN

4548: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4549: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4550: -- Code for Match rule HZ_ORG_ADV_SEARCH_RULE
4551: ELSIF p_rule_id=62 THEN
4552: IF NOT HZ_MATCH_RULE_62.check_staged THEN
4553: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4554: FND_MSG_PUB.ADD;
4555: RAISE FND_API.G_EXC_ERROR;
4556: END IF;

Line 4557: HZ_MATCH_RULE_62.get_matching_party_sites(

4553: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4554: FND_MSG_PUB.ADD;
4555: RAISE FND_API.G_EXC_ERROR;
4556: END IF;
4557: HZ_MATCH_RULE_62.get_matching_party_sites(
4558: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4559: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4560: -- Code for Match rule HZ_CONTACT_SIMPLE_SEARCH_RULE
4561: ELSIF p_rule_id=98 THEN

Line 4731: IF NOT HZ_MATCH_RULE_6.check_staged THEN

4727: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
4728: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4729: -- Code for Match rule SAMPLE: SIMILAR_ORGANIZATION
4730: ELSIF p_rule_id=6 THEN
4731: IF NOT HZ_MATCH_RULE_6.check_staged THEN
4732: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4733: FND_MSG_PUB.ADD;
4734: RAISE FND_API.G_EXC_ERROR;
4735: END IF;

Line 4736: HZ_MATCH_RULE_6.get_matching_contacts(

4732: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4733: FND_MSG_PUB.ADD;
4734: RAISE FND_API.G_EXC_ERROR;
4735: END IF;
4736: HZ_MATCH_RULE_6.get_matching_contacts(
4737: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
4738: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4739: -- Code for Match rule SAMPLE: SIMILAR_PERSON
4740: ELSIF p_rule_id=7 THEN

Line 4931: IF NOT HZ_MATCH_RULE_60.check_staged THEN

4927: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
4928: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4929: -- Code for Match rule HZ_PERSON_ADVANCED_SEARCH_MATCH_RULE
4930: ELSIF p_rule_id=60 THEN
4931: IF NOT HZ_MATCH_RULE_60.check_staged THEN
4932: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4933: FND_MSG_PUB.ADD;
4934: RAISE FND_API.G_EXC_ERROR;
4935: END IF;

Line 4936: HZ_MATCH_RULE_60.get_matching_contacts(

4932: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4933: FND_MSG_PUB.ADD;
4934: RAISE FND_API.G_EXC_ERROR;
4935: END IF;
4936: HZ_MATCH_RULE_60.get_matching_contacts(
4937: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
4938: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4939: -- Code for Match rule HZ_ORG_SIMPLE_SEARCH_RULE
4940: ELSIF p_rule_id=61 THEN

Line 4941: IF NOT HZ_MATCH_RULE_61.check_staged THEN

4937: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
4938: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4939: -- Code for Match rule HZ_ORG_SIMPLE_SEARCH_RULE
4940: ELSIF p_rule_id=61 THEN
4941: IF NOT HZ_MATCH_RULE_61.check_staged THEN
4942: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4943: FND_MSG_PUB.ADD;
4944: RAISE FND_API.G_EXC_ERROR;
4945: END IF;

Line 4946: HZ_MATCH_RULE_61.get_matching_contacts(

4942: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4943: FND_MSG_PUB.ADD;
4944: RAISE FND_API.G_EXC_ERROR;
4945: END IF;
4946: HZ_MATCH_RULE_61.get_matching_contacts(
4947: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
4948: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4949: -- Code for Match rule HZ_ORG_ADV_SEARCH_RULE
4950: ELSIF p_rule_id=62 THEN

Line 4951: IF NOT HZ_MATCH_RULE_62.check_staged THEN

4947: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
4948: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4949: -- Code for Match rule HZ_ORG_ADV_SEARCH_RULE
4950: ELSIF p_rule_id=62 THEN
4951: IF NOT HZ_MATCH_RULE_62.check_staged THEN
4952: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4953: FND_MSG_PUB.ADD;
4954: RAISE FND_API.G_EXC_ERROR;
4955: END IF;

Line 4956: HZ_MATCH_RULE_62.get_matching_contacts(

4952: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4953: FND_MSG_PUB.ADD;
4954: RAISE FND_API.G_EXC_ERROR;
4955: END IF;
4956: HZ_MATCH_RULE_62.get_matching_contacts(
4957: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
4958: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4959: -- Code for Match rule HZ_CONTACT_SIMPLE_SEARCH_RULE
4960: ELSIF p_rule_id=98 THEN

Line 5128: IF NOT HZ_MATCH_RULE_6.check_staged THEN

5124: p_rule_id, p_party_id, p_contact_point_list,
5125: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5126: -- Code for Match rule SAMPLE: SIMILAR_ORGANIZATION
5127: ELSIF p_rule_id=6 THEN
5128: IF NOT HZ_MATCH_RULE_6.check_staged THEN
5129: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5130: FND_MSG_PUB.ADD;
5131: RAISE FND_API.G_EXC_ERROR;
5132: END IF;

Line 5133: HZ_MATCH_RULE_6.get_matching_contact_points(

5129: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5130: FND_MSG_PUB.ADD;
5131: RAISE FND_API.G_EXC_ERROR;
5132: END IF;
5133: HZ_MATCH_RULE_6.get_matching_contact_points(
5134: p_rule_id, p_party_id, p_contact_point_list,
5135: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5136: -- Code for Match rule SAMPLE: SIMILAR_PERSON
5137: ELSIF p_rule_id=7 THEN

Line 5328: IF NOT HZ_MATCH_RULE_60.check_staged THEN

5324: p_rule_id, p_party_id, p_contact_point_list,
5325: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5326: -- Code for Match rule HZ_PERSON_ADVANCED_SEARCH_MATCH_RULE
5327: ELSIF p_rule_id=60 THEN
5328: IF NOT HZ_MATCH_RULE_60.check_staged THEN
5329: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5330: FND_MSG_PUB.ADD;
5331: RAISE FND_API.G_EXC_ERROR;
5332: END IF;

Line 5333: HZ_MATCH_RULE_60.get_matching_contact_points(

5329: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5330: FND_MSG_PUB.ADD;
5331: RAISE FND_API.G_EXC_ERROR;
5332: END IF;
5333: HZ_MATCH_RULE_60.get_matching_contact_points(
5334: p_rule_id, p_party_id, p_contact_point_list,
5335: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5336: -- Code for Match rule HZ_ORG_SIMPLE_SEARCH_RULE
5337: ELSIF p_rule_id=61 THEN

Line 5338: IF NOT HZ_MATCH_RULE_61.check_staged THEN

5334: p_rule_id, p_party_id, p_contact_point_list,
5335: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5336: -- Code for Match rule HZ_ORG_SIMPLE_SEARCH_RULE
5337: ELSIF p_rule_id=61 THEN
5338: IF NOT HZ_MATCH_RULE_61.check_staged THEN
5339: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5340: FND_MSG_PUB.ADD;
5341: RAISE FND_API.G_EXC_ERROR;
5342: END IF;

Line 5343: HZ_MATCH_RULE_61.get_matching_contact_points(

5339: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5340: FND_MSG_PUB.ADD;
5341: RAISE FND_API.G_EXC_ERROR;
5342: END IF;
5343: HZ_MATCH_RULE_61.get_matching_contact_points(
5344: p_rule_id, p_party_id, p_contact_point_list,
5345: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5346: -- Code for Match rule HZ_ORG_ADV_SEARCH_RULE
5347: ELSIF p_rule_id=62 THEN

Line 5348: IF NOT HZ_MATCH_RULE_62.check_staged THEN

5344: p_rule_id, p_party_id, p_contact_point_list,
5345: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5346: -- Code for Match rule HZ_ORG_ADV_SEARCH_RULE
5347: ELSIF p_rule_id=62 THEN
5348: IF NOT HZ_MATCH_RULE_62.check_staged THEN
5349: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5350: FND_MSG_PUB.ADD;
5351: RAISE FND_API.G_EXC_ERROR;
5352: END IF;

Line 5353: HZ_MATCH_RULE_62.get_matching_contact_points(

5349: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5350: FND_MSG_PUB.ADD;
5351: RAISE FND_API.G_EXC_ERROR;
5352: END IF;
5353: HZ_MATCH_RULE_62.get_matching_contact_points(
5354: p_rule_id, p_party_id, p_contact_point_list,
5355: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5356: -- Code for Match rule HZ_CONTACT_SIMPLE_SEARCH_RULE
5357: ELSIF p_rule_id=98 THEN

Line 5532: IF NOT HZ_MATCH_RULE_6.check_staged THEN

5528: p_party_id, p_party_search_rec,p_party_site_list,
5529: p_contact_list, p_contact_point_list,x_search_ctx_id);
5530: -- Code for Match rule SAMPLE: SIMILAR_ORGANIZATION
5531: ELSIF p_rule_id=6 THEN
5532: IF NOT HZ_MATCH_RULE_6.check_staged THEN
5533: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5534: FND_MSG_PUB.ADD;
5535: RAISE FND_API.G_EXC_ERROR;
5536: END IF;

Line 5537: HZ_MATCH_RULE_6.get_score_details(

5533: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5534: FND_MSG_PUB.ADD;
5535: RAISE FND_API.G_EXC_ERROR;
5536: END IF;
5537: HZ_MATCH_RULE_6.get_score_details(
5538: p_rule_id,
5539: p_party_id, p_party_search_rec,p_party_site_list,
5540: p_contact_list, p_contact_point_list,x_search_ctx_id);
5541: -- Code for Match rule SAMPLE: SIMILAR_PERSON

Line 5752: IF NOT HZ_MATCH_RULE_60.check_staged THEN

5748: p_party_id, p_party_search_rec,p_party_site_list,
5749: p_contact_list, p_contact_point_list,x_search_ctx_id);
5750: -- Code for Match rule HZ_PERSON_ADVANCED_SEARCH_MATCH_RULE
5751: ELSIF p_rule_id=60 THEN
5752: IF NOT HZ_MATCH_RULE_60.check_staged THEN
5753: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5754: FND_MSG_PUB.ADD;
5755: RAISE FND_API.G_EXC_ERROR;
5756: END IF;

Line 5757: HZ_MATCH_RULE_60.get_score_details(

5753: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5754: FND_MSG_PUB.ADD;
5755: RAISE FND_API.G_EXC_ERROR;
5756: END IF;
5757: HZ_MATCH_RULE_60.get_score_details(
5758: p_rule_id,
5759: p_party_id, p_party_search_rec,p_party_site_list,
5760: p_contact_list, p_contact_point_list,x_search_ctx_id);
5761: -- Code for Match rule HZ_ORG_SIMPLE_SEARCH_RULE

Line 5763: IF NOT HZ_MATCH_RULE_61.check_staged THEN

5759: p_party_id, p_party_search_rec,p_party_site_list,
5760: p_contact_list, p_contact_point_list,x_search_ctx_id);
5761: -- Code for Match rule HZ_ORG_SIMPLE_SEARCH_RULE
5762: ELSIF p_rule_id=61 THEN
5763: IF NOT HZ_MATCH_RULE_61.check_staged THEN
5764: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5765: FND_MSG_PUB.ADD;
5766: RAISE FND_API.G_EXC_ERROR;
5767: END IF;

Line 5768: HZ_MATCH_RULE_61.get_score_details(

5764: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5765: FND_MSG_PUB.ADD;
5766: RAISE FND_API.G_EXC_ERROR;
5767: END IF;
5768: HZ_MATCH_RULE_61.get_score_details(
5769: p_rule_id,
5770: p_party_id, p_party_search_rec,p_party_site_list,
5771: p_contact_list, p_contact_point_list,x_search_ctx_id);
5772: -- Code for Match rule HZ_ORG_ADV_SEARCH_RULE

Line 5774: IF NOT HZ_MATCH_RULE_62.check_staged THEN

5770: p_party_id, p_party_search_rec,p_party_site_list,
5771: p_contact_list, p_contact_point_list,x_search_ctx_id);
5772: -- Code for Match rule HZ_ORG_ADV_SEARCH_RULE
5773: ELSIF p_rule_id=62 THEN
5774: IF NOT HZ_MATCH_RULE_62.check_staged THEN
5775: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5776: FND_MSG_PUB.ADD;
5777: RAISE FND_API.G_EXC_ERROR;
5778: END IF;

Line 5779: HZ_MATCH_RULE_62.get_score_details(

5775: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5776: FND_MSG_PUB.ADD;
5777: RAISE FND_API.G_EXC_ERROR;
5778: END IF;
5779: HZ_MATCH_RULE_62.get_score_details(
5780: p_rule_id,
5781: p_party_id, p_party_search_rec,p_party_site_list,
5782: p_contact_list, p_contact_point_list,x_search_ctx_id);
5783: -- Code for Match rule HZ_CONTACT_SIMPLE_SEARCH_RULE

Line 5926: IF NOT HZ_MATCH_RULE_6.check_staged THEN

5922: p_party_id, x_party_search_rec,x_party_site_list,
5923: x_contact_list, x_contact_point_list);
5924: -- Code for Match rule SAMPLE: SIMILAR_ORGANIZATION
5925: ELSIF p_rule_id=6 THEN
5926: IF NOT HZ_MATCH_RULE_6.check_staged THEN
5927: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5928: FND_MSG_PUB.ADD;
5929: RAISE FND_API.G_EXC_ERROR;
5930: END IF;

Line 5931: HZ_MATCH_RULE_6.get_party_for_search(

5927: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5928: FND_MSG_PUB.ADD;
5929: RAISE FND_API.G_EXC_ERROR;
5930: END IF;
5931: HZ_MATCH_RULE_6.get_party_for_search(
5932: p_party_id, x_party_search_rec,x_party_site_list,
5933: x_contact_list, x_contact_point_list);
5934: -- Code for Match rule SAMPLE: SIMILAR_PERSON
5935: ELSIF p_rule_id=7 THEN

Line 6126: IF NOT HZ_MATCH_RULE_60.check_staged THEN

6122: p_party_id, x_party_search_rec,x_party_site_list,
6123: x_contact_list, x_contact_point_list);
6124: -- Code for Match rule HZ_PERSON_ADVANCED_SEARCH_MATCH_RULE
6125: ELSIF p_rule_id=60 THEN
6126: IF NOT HZ_MATCH_RULE_60.check_staged THEN
6127: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6128: FND_MSG_PUB.ADD;
6129: RAISE FND_API.G_EXC_ERROR;
6130: END IF;

Line 6131: HZ_MATCH_RULE_60.get_party_for_search(

6127: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6128: FND_MSG_PUB.ADD;
6129: RAISE FND_API.G_EXC_ERROR;
6130: END IF;
6131: HZ_MATCH_RULE_60.get_party_for_search(
6132: p_party_id, x_party_search_rec,x_party_site_list,
6133: x_contact_list, x_contact_point_list);
6134: -- Code for Match rule HZ_ORG_SIMPLE_SEARCH_RULE
6135: ELSIF p_rule_id=61 THEN

Line 6136: IF NOT HZ_MATCH_RULE_61.check_staged THEN

6132: p_party_id, x_party_search_rec,x_party_site_list,
6133: x_contact_list, x_contact_point_list);
6134: -- Code for Match rule HZ_ORG_SIMPLE_SEARCH_RULE
6135: ELSIF p_rule_id=61 THEN
6136: IF NOT HZ_MATCH_RULE_61.check_staged THEN
6137: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6138: FND_MSG_PUB.ADD;
6139: RAISE FND_API.G_EXC_ERROR;
6140: END IF;

Line 6141: HZ_MATCH_RULE_61.get_party_for_search(

6137: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6138: FND_MSG_PUB.ADD;
6139: RAISE FND_API.G_EXC_ERROR;
6140: END IF;
6141: HZ_MATCH_RULE_61.get_party_for_search(
6142: p_party_id, x_party_search_rec,x_party_site_list,
6143: x_contact_list, x_contact_point_list);
6144: -- Code for Match rule HZ_ORG_ADV_SEARCH_RULE
6145: ELSIF p_rule_id=62 THEN

Line 6146: IF NOT HZ_MATCH_RULE_62.check_staged THEN

6142: p_party_id, x_party_search_rec,x_party_site_list,
6143: x_contact_list, x_contact_point_list);
6144: -- Code for Match rule HZ_ORG_ADV_SEARCH_RULE
6145: ELSIF p_rule_id=62 THEN
6146: IF NOT HZ_MATCH_RULE_62.check_staged THEN
6147: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6148: FND_MSG_PUB.ADD;
6149: RAISE FND_API.G_EXC_ERROR;
6150: END IF;

Line 6151: HZ_MATCH_RULE_62.get_party_for_search(

6147: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6148: FND_MSG_PUB.ADD;
6149: RAISE FND_API.G_EXC_ERROR;
6150: END IF;
6151: HZ_MATCH_RULE_62.get_party_for_search(
6152: p_party_id, x_party_search_rec,x_party_site_list,
6153: x_contact_list, x_contact_point_list);
6154: -- Code for Match rule HZ_CONTACT_SIMPLE_SEARCH_RULE
6155: ELSIF p_rule_id=98 THEN

Line 6298: IF NOT HZ_MATCH_RULE_6.check_staged THEN

6294: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6295: x_contact_list, x_contact_point_list);
6296: -- Code for Match rule SAMPLE: SIMILAR_ORGANIZATION
6297: ELSIF p_rule_id=6 THEN
6298: IF NOT HZ_MATCH_RULE_6.check_staged THEN
6299: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6300: FND_MSG_PUB.ADD;
6301: RAISE FND_API.G_EXC_ERROR;
6302: END IF;

Line 6303: HZ_MATCH_RULE_6.get_search_criteria(

6299: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6300: FND_MSG_PUB.ADD;
6301: RAISE FND_API.G_EXC_ERROR;
6302: END IF;
6303: HZ_MATCH_RULE_6.get_search_criteria(
6304: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6305: x_contact_list, x_contact_point_list);
6306: -- Code for Match rule SAMPLE: SIMILAR_PERSON
6307: ELSIF p_rule_id=7 THEN

Line 6498: IF NOT HZ_MATCH_RULE_60.check_staged THEN

6494: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6495: x_contact_list, x_contact_point_list);
6496: -- Code for Match rule HZ_PERSON_ADVANCED_SEARCH_MATCH_RULE
6497: ELSIF p_rule_id=60 THEN
6498: IF NOT HZ_MATCH_RULE_60.check_staged THEN
6499: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6500: FND_MSG_PUB.ADD;
6501: RAISE FND_API.G_EXC_ERROR;
6502: END IF;

Line 6503: HZ_MATCH_RULE_60.get_search_criteria(

6499: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6500: FND_MSG_PUB.ADD;
6501: RAISE FND_API.G_EXC_ERROR;
6502: END IF;
6503: HZ_MATCH_RULE_60.get_search_criteria(
6504: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6505: x_contact_list, x_contact_point_list);
6506: -- Code for Match rule HZ_ORG_SIMPLE_SEARCH_RULE
6507: ELSIF p_rule_id=61 THEN

Line 6508: IF NOT HZ_MATCH_RULE_61.check_staged THEN

6504: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6505: x_contact_list, x_contact_point_list);
6506: -- Code for Match rule HZ_ORG_SIMPLE_SEARCH_RULE
6507: ELSIF p_rule_id=61 THEN
6508: IF NOT HZ_MATCH_RULE_61.check_staged THEN
6509: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6510: FND_MSG_PUB.ADD;
6511: RAISE FND_API.G_EXC_ERROR;
6512: END IF;

Line 6513: HZ_MATCH_RULE_61.get_search_criteria(

6509: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6510: FND_MSG_PUB.ADD;
6511: RAISE FND_API.G_EXC_ERROR;
6512: END IF;
6513: HZ_MATCH_RULE_61.get_search_criteria(
6514: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6515: x_contact_list, x_contact_point_list);
6516: -- Code for Match rule HZ_ORG_ADV_SEARCH_RULE
6517: ELSIF p_rule_id=62 THEN

Line 6518: IF NOT HZ_MATCH_RULE_62.check_staged THEN

6514: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6515: x_contact_list, x_contact_point_list);
6516: -- Code for Match rule HZ_ORG_ADV_SEARCH_RULE
6517: ELSIF p_rule_id=62 THEN
6518: IF NOT HZ_MATCH_RULE_62.check_staged THEN
6519: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6520: FND_MSG_PUB.ADD;
6521: RAISE FND_API.G_EXC_ERROR;
6522: END IF;

Line 6523: HZ_MATCH_RULE_62.get_search_criteria(

6519: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6520: FND_MSG_PUB.ADD;
6521: RAISE FND_API.G_EXC_ERROR;
6522: END IF;
6523: HZ_MATCH_RULE_62.get_search_criteria(
6524: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6525: x_contact_list, x_contact_point_list);
6526: -- Code for Match rule HZ_CONTACT_SIMPLE_SEARCH_RULE
6527: ELSIF p_rule_id=98 THEN