APPS.HZ_PARTY_SEARCH dependencies on HZ_MATCH_RULE_4

Line 130: IF NOT HZ_MATCH_RULE_4.check_staged THEN

126: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
127: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,NULL,NULL,NULL,'N',x_search_ctx_id,x_num_matches);
128: -- Code for Match rule SAMPLE: ADDRESS_ORGANIZATIONS
129: ELSIF p_rule_id=4 THEN
130: IF NOT HZ_MATCH_RULE_4.check_staged THEN
131: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
132: FND_MSG_PUB.ADD;
133: RAISE FND_API.G_EXC_ERROR;
134: END IF;

Line 135: HZ_MATCH_RULE_4.find_parties(

131: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
132: FND_MSG_PUB.ADD;
133: RAISE FND_API.G_EXC_ERROR;
134: END IF;
135: HZ_MATCH_RULE_4.find_parties(
136: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
137: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,NULL,NULL,NULL,'N',x_search_ctx_id,x_num_matches);
138: -- Code for Match rule SAMPLE: ADDRESS_PERSONS
139: ELSIF p_rule_id=5 THEN

Line 260: IF NOT HZ_MATCH_RULE_40.check_staged THEN

256: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
257: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,NULL,NULL,NULL,'N',x_search_ctx_id,x_num_matches);
258: -- Code for Match rule SAMPLE: SEARCH SIMILAR ORGANIZATION EXACT
259: ELSIF p_rule_id=40 THEN
260: IF NOT HZ_MATCH_RULE_40.check_staged THEN
261: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
262: FND_MSG_PUB.ADD;
263: RAISE FND_API.G_EXC_ERROR;
264: END IF;

Line 265: HZ_MATCH_RULE_40.find_parties(

261: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
262: FND_MSG_PUB.ADD;
263: RAISE FND_API.G_EXC_ERROR;
264: END IF;
265: HZ_MATCH_RULE_40.find_parties(
266: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
267: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,NULL,NULL,NULL,'N',x_search_ctx_id,x_num_matches);
268: -- Code for Match rule SAMPLE: SEARCH SIMILAR PERSON EXACT
269: ELSIF p_rule_id=41 THEN

Line 270: IF NOT HZ_MATCH_RULE_41.check_staged THEN

266: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
267: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,NULL,NULL,NULL,'N',x_search_ctx_id,x_num_matches);
268: -- Code for Match rule SAMPLE: SEARCH SIMILAR PERSON EXACT
269: ELSIF p_rule_id=41 THEN
270: IF NOT HZ_MATCH_RULE_41.check_staged THEN
271: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
272: FND_MSG_PUB.ADD;
273: RAISE FND_API.G_EXC_ERROR;
274: END IF;

Line 275: HZ_MATCH_RULE_41.find_parties(

271: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
272: FND_MSG_PUB.ADD;
273: RAISE FND_API.G_EXC_ERROR;
274: END IF;
275: HZ_MATCH_RULE_41.find_parties(
276: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
277: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,NULL,NULL,NULL,'N',x_search_ctx_id,x_num_matches);
278: -- Code for Match rule SAMPLE: SEARCH EXACT
279: ELSIF p_rule_id=42 THEN

Line 280: IF NOT HZ_MATCH_RULE_42.check_staged THEN

276: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
277: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,NULL,NULL,NULL,'N',x_search_ctx_id,x_num_matches);
278: -- Code for Match rule SAMPLE: SEARCH EXACT
279: ELSIF p_rule_id=42 THEN
280: IF NOT HZ_MATCH_RULE_42.check_staged THEN
281: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
282: FND_MSG_PUB.ADD;
283: RAISE FND_API.G_EXC_ERROR;
284: END IF;

Line 285: HZ_MATCH_RULE_42.find_parties(

281: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
282: FND_MSG_PUB.ADD;
283: RAISE FND_API.G_EXC_ERROR;
284: END IF;
285: HZ_MATCH_RULE_42.find_parties(
286: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
287: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,NULL,NULL,NULL,'N',x_search_ctx_id,x_num_matches);
288: -- Code for Match rule DL SYSTEM DUPLICATE IDENTIFICATION
289: ELSIF p_rule_id=48 THEN

Line 290: IF NOT HZ_MATCH_RULE_48.check_staged THEN

286: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
287: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,NULL,NULL,NULL,'N',x_search_ctx_id,x_num_matches);
288: -- Code for Match rule DL SYSTEM DUPLICATE IDENTIFICATION
289: ELSIF p_rule_id=48 THEN
290: IF NOT HZ_MATCH_RULE_48.check_staged THEN
291: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
292: FND_MSG_PUB.ADD;
293: RAISE FND_API.G_EXC_ERROR;
294: END IF;

Line 295: HZ_MATCH_RULE_48.find_parties(

291: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
292: FND_MSG_PUB.ADD;
293: RAISE FND_API.G_EXC_ERROR;
294: END IF;
295: HZ_MATCH_RULE_48.find_parties(
296: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
297: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,NULL,NULL,NULL,'N',x_search_ctx_id,x_num_matches);
298: -- Code for Match rule BULK MATCH: IDENTICAL ORGANIZATIONS
299: ELSIF p_rule_id=50 THEN

Line 531: IF NOT HZ_MATCH_RULE_4.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: ADDRESS_ORGANIZATIONS
530: ELSIF p_rule_id=4 THEN
531: IF NOT HZ_MATCH_RULE_4.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_4.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_4.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: ADDRESS_PERSONS
540: ELSIF p_rule_id=5 THEN

Line 661: IF NOT HZ_MATCH_RULE_40.check_staged THEN

657: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
658: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,'N',x_search_ctx_id,x_num_matches);
659: -- Code for Match rule SAMPLE: SEARCH SIMILAR ORGANIZATION EXACT
660: ELSIF p_rule_id=40 THEN
661: IF NOT HZ_MATCH_RULE_40.check_staged THEN
662: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
663: FND_MSG_PUB.ADD;
664: RAISE FND_API.G_EXC_ERROR;
665: END IF;

Line 666: HZ_MATCH_RULE_40.find_persons(

662: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
663: FND_MSG_PUB.ADD;
664: RAISE FND_API.G_EXC_ERROR;
665: END IF;
666: HZ_MATCH_RULE_40.find_persons(
667: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
668: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,'N',x_search_ctx_id,x_num_matches);
669: -- Code for Match rule SAMPLE: SEARCH SIMILAR PERSON EXACT
670: ELSIF p_rule_id=41 THEN

Line 671: IF NOT HZ_MATCH_RULE_41.check_staged THEN

667: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
668: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,'N',x_search_ctx_id,x_num_matches);
669: -- Code for Match rule SAMPLE: SEARCH SIMILAR PERSON EXACT
670: ELSIF p_rule_id=41 THEN
671: IF NOT HZ_MATCH_RULE_41.check_staged THEN
672: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
673: FND_MSG_PUB.ADD;
674: RAISE FND_API.G_EXC_ERROR;
675: END IF;

Line 676: HZ_MATCH_RULE_41.find_persons(

672: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
673: FND_MSG_PUB.ADD;
674: RAISE FND_API.G_EXC_ERROR;
675: END IF;
676: HZ_MATCH_RULE_41.find_persons(
677: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
678: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,'N',x_search_ctx_id,x_num_matches);
679: -- Code for Match rule SAMPLE: SEARCH EXACT
680: ELSIF p_rule_id=42 THEN

Line 681: IF NOT HZ_MATCH_RULE_42.check_staged THEN

677: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
678: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,'N',x_search_ctx_id,x_num_matches);
679: -- Code for Match rule SAMPLE: SEARCH EXACT
680: ELSIF p_rule_id=42 THEN
681: IF NOT HZ_MATCH_RULE_42.check_staged THEN
682: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
683: FND_MSG_PUB.ADD;
684: RAISE FND_API.G_EXC_ERROR;
685: END IF;

Line 686: HZ_MATCH_RULE_42.find_persons(

682: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
683: FND_MSG_PUB.ADD;
684: RAISE FND_API.G_EXC_ERROR;
685: END IF;
686: HZ_MATCH_RULE_42.find_persons(
687: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
688: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,'N',x_search_ctx_id,x_num_matches);
689: -- Code for Match rule DL SYSTEM DUPLICATE IDENTIFICATION
690: ELSIF p_rule_id=48 THEN

Line 691: IF NOT HZ_MATCH_RULE_48.check_staged THEN

687: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
688: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,'N',x_search_ctx_id,x_num_matches);
689: -- Code for Match rule DL SYSTEM DUPLICATE IDENTIFICATION
690: ELSIF p_rule_id=48 THEN
691: IF NOT HZ_MATCH_RULE_48.check_staged THEN
692: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
693: FND_MSG_PUB.ADD;
694: RAISE FND_API.G_EXC_ERROR;
695: END IF;

Line 696: HZ_MATCH_RULE_48.find_persons(

692: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
693: FND_MSG_PUB.ADD;
694: RAISE FND_API.G_EXC_ERROR;
695: END IF;
696: HZ_MATCH_RULE_48.find_persons(
697: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
698: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,'N',x_search_ctx_id,x_num_matches);
699: -- Code for Match rule BULK MATCH: IDENTICAL ORGANIZATIONS
700: ELSIF p_rule_id=50 THEN

Line 950: IF NOT HZ_MATCH_RULE_4.check_staged THEN

946: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
947: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
948: -- Code for Match rule SAMPLE: ADDRESS_ORGANIZATIONS
949: ELSIF p_rule_id=4 THEN
950: IF NOT HZ_MATCH_RULE_4.check_staged THEN
951: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
952: FND_MSG_PUB.ADD;
953: RAISE FND_API.G_EXC_ERROR;
954: END IF;

Line 955: HZ_MATCH_RULE_4.find_party_details(

951: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
952: FND_MSG_PUB.ADD;
953: RAISE FND_API.G_EXC_ERROR;
954: END IF;
955: HZ_MATCH_RULE_4.find_party_details(
956: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
957: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
958: -- Code for Match rule SAMPLE: ADDRESS_PERSONS
959: ELSIF p_rule_id=5 THEN

Line 1080: IF NOT HZ_MATCH_RULE_40.check_staged THEN

1076: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
1077: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
1078: -- Code for Match rule SAMPLE: SEARCH SIMILAR ORGANIZATION EXACT
1079: ELSIF p_rule_id=40 THEN
1080: IF NOT HZ_MATCH_RULE_40.check_staged THEN
1081: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1082: FND_MSG_PUB.ADD;
1083: RAISE FND_API.G_EXC_ERROR;
1084: END IF;

Line 1085: HZ_MATCH_RULE_40.find_party_details(

1081: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1082: FND_MSG_PUB.ADD;
1083: RAISE FND_API.G_EXC_ERROR;
1084: END IF;
1085: HZ_MATCH_RULE_40.find_party_details(
1086: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
1087: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
1088: -- Code for Match rule SAMPLE: SEARCH SIMILAR PERSON EXACT
1089: ELSIF p_rule_id=41 THEN

Line 1090: IF NOT HZ_MATCH_RULE_41.check_staged THEN

1086: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
1087: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
1088: -- Code for Match rule SAMPLE: SEARCH SIMILAR PERSON EXACT
1089: ELSIF p_rule_id=41 THEN
1090: IF NOT HZ_MATCH_RULE_41.check_staged THEN
1091: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1092: FND_MSG_PUB.ADD;
1093: RAISE FND_API.G_EXC_ERROR;
1094: END IF;

Line 1095: HZ_MATCH_RULE_41.find_party_details(

1091: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1092: FND_MSG_PUB.ADD;
1093: RAISE FND_API.G_EXC_ERROR;
1094: END IF;
1095: HZ_MATCH_RULE_41.find_party_details(
1096: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
1097: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
1098: -- Code for Match rule SAMPLE: SEARCH EXACT
1099: ELSIF p_rule_id=42 THEN

Line 1100: IF NOT HZ_MATCH_RULE_42.check_staged THEN

1096: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
1097: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
1098: -- Code for Match rule SAMPLE: SEARCH EXACT
1099: ELSIF p_rule_id=42 THEN
1100: IF NOT HZ_MATCH_RULE_42.check_staged THEN
1101: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1102: FND_MSG_PUB.ADD;
1103: RAISE FND_API.G_EXC_ERROR;
1104: END IF;

Line 1105: HZ_MATCH_RULE_42.find_party_details(

1101: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1102: FND_MSG_PUB.ADD;
1103: RAISE FND_API.G_EXC_ERROR;
1104: END IF;
1105: HZ_MATCH_RULE_42.find_party_details(
1106: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
1107: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
1108: -- Code for Match rule DL SYSTEM DUPLICATE IDENTIFICATION
1109: ELSIF p_rule_id=48 THEN

Line 1110: IF NOT HZ_MATCH_RULE_48.check_staged THEN

1106: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
1107: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
1108: -- Code for Match rule DL SYSTEM DUPLICATE IDENTIFICATION
1109: ELSIF p_rule_id=48 THEN
1110: IF NOT HZ_MATCH_RULE_48.check_staged THEN
1111: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1112: FND_MSG_PUB.ADD;
1113: RAISE FND_API.G_EXC_ERROR;
1114: END IF;

Line 1115: HZ_MATCH_RULE_48.find_party_details(

1111: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1112: FND_MSG_PUB.ADD;
1113: RAISE FND_API.G_EXC_ERROR;
1114: END IF;
1115: HZ_MATCH_RULE_48.find_party_details(
1116: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
1117: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
1118: -- Code for Match rule BULK MATCH: IDENTICAL ORGANIZATIONS
1119: ELSIF p_rule_id=50 THEN

Line 1350: IF NOT HZ_MATCH_RULE_4.check_staged THEN

1346: p_rule_id,p_party_id,
1347: p_restrict_sql,p_match_type,p_dup_batch_id,p_search_merged,x_dup_set_id, x_search_ctx_id,x_num_matches);
1348: -- Code for Match rule SAMPLE: ADDRESS_ORGANIZATIONS
1349: ELSIF p_rule_id=4 THEN
1350: IF NOT HZ_MATCH_RULE_4.check_staged THEN
1351: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1352: FND_MSG_PUB.ADD;
1353: RAISE FND_API.G_EXC_ERROR;
1354: END IF;

Line 1355: HZ_MATCH_RULE_4.find_duplicate_parties(

1351: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1352: FND_MSG_PUB.ADD;
1353: RAISE FND_API.G_EXC_ERROR;
1354: END IF;
1355: HZ_MATCH_RULE_4.find_duplicate_parties(
1356: p_rule_id,p_party_id,
1357: p_restrict_sql,p_match_type,p_dup_batch_id,p_search_merged,x_dup_set_id, x_search_ctx_id,x_num_matches);
1358: -- Code for Match rule SAMPLE: ADDRESS_PERSONS
1359: ELSIF p_rule_id=5 THEN

Line 1480: IF NOT HZ_MATCH_RULE_40.check_staged THEN

1476: p_rule_id,p_party_id,
1477: p_restrict_sql,p_match_type,p_dup_batch_id,p_search_merged,x_dup_set_id, x_search_ctx_id,x_num_matches);
1478: -- Code for Match rule SAMPLE: SEARCH SIMILAR ORGANIZATION EXACT
1479: ELSIF p_rule_id=40 THEN
1480: IF NOT HZ_MATCH_RULE_40.check_staged THEN
1481: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1482: FND_MSG_PUB.ADD;
1483: RAISE FND_API.G_EXC_ERROR;
1484: END IF;

Line 1485: HZ_MATCH_RULE_40.find_duplicate_parties(

1481: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1482: FND_MSG_PUB.ADD;
1483: RAISE FND_API.G_EXC_ERROR;
1484: END IF;
1485: HZ_MATCH_RULE_40.find_duplicate_parties(
1486: p_rule_id,p_party_id,
1487: p_restrict_sql,p_match_type,p_dup_batch_id,p_search_merged,x_dup_set_id, x_search_ctx_id,x_num_matches);
1488: -- Code for Match rule SAMPLE: SEARCH SIMILAR PERSON EXACT
1489: ELSIF p_rule_id=41 THEN

Line 1490: IF NOT HZ_MATCH_RULE_41.check_staged THEN

1486: p_rule_id,p_party_id,
1487: p_restrict_sql,p_match_type,p_dup_batch_id,p_search_merged,x_dup_set_id, x_search_ctx_id,x_num_matches);
1488: -- Code for Match rule SAMPLE: SEARCH SIMILAR PERSON EXACT
1489: ELSIF p_rule_id=41 THEN
1490: IF NOT HZ_MATCH_RULE_41.check_staged THEN
1491: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1492: FND_MSG_PUB.ADD;
1493: RAISE FND_API.G_EXC_ERROR;
1494: END IF;

Line 1495: HZ_MATCH_RULE_41.find_duplicate_parties(

1491: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1492: FND_MSG_PUB.ADD;
1493: RAISE FND_API.G_EXC_ERROR;
1494: END IF;
1495: HZ_MATCH_RULE_41.find_duplicate_parties(
1496: p_rule_id,p_party_id,
1497: p_restrict_sql,p_match_type,p_dup_batch_id,p_search_merged,x_dup_set_id, x_search_ctx_id,x_num_matches);
1498: -- Code for Match rule SAMPLE: SEARCH EXACT
1499: ELSIF p_rule_id=42 THEN

Line 1500: IF NOT HZ_MATCH_RULE_42.check_staged THEN

1496: p_rule_id,p_party_id,
1497: p_restrict_sql,p_match_type,p_dup_batch_id,p_search_merged,x_dup_set_id, x_search_ctx_id,x_num_matches);
1498: -- Code for Match rule SAMPLE: SEARCH EXACT
1499: ELSIF p_rule_id=42 THEN
1500: IF NOT HZ_MATCH_RULE_42.check_staged THEN
1501: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1502: FND_MSG_PUB.ADD;
1503: RAISE FND_API.G_EXC_ERROR;
1504: END IF;

Line 1505: HZ_MATCH_RULE_42.find_duplicate_parties(

1501: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1502: FND_MSG_PUB.ADD;
1503: RAISE FND_API.G_EXC_ERROR;
1504: END IF;
1505: HZ_MATCH_RULE_42.find_duplicate_parties(
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 DL SYSTEM DUPLICATE IDENTIFICATION
1509: ELSIF p_rule_id=48 THEN

Line 1510: IF NOT HZ_MATCH_RULE_48.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 DL SYSTEM DUPLICATE IDENTIFICATION
1509: ELSIF p_rule_id=48 THEN
1510: IF NOT HZ_MATCH_RULE_48.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_48.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_48.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 BULK MATCH: IDENTICAL ORGANIZATIONS
1519: ELSIF p_rule_id=50 THEN

Line 1745: IF NOT HZ_MATCH_RULE_4.check_staged THEN

1741: p_rule_id,p_party_site_id,p_party_id,
1742: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
1743: -- Code for Match rule SAMPLE: ADDRESS_ORGANIZATIONS
1744: ELSIF p_rule_id=4 THEN
1745: IF NOT HZ_MATCH_RULE_4.check_staged THEN
1746: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1747: FND_MSG_PUB.ADD;
1748: RAISE FND_API.G_EXC_ERROR;
1749: END IF;

Line 1750: HZ_MATCH_RULE_4.find_duplicate_party_sites(

1746: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1747: FND_MSG_PUB.ADD;
1748: RAISE FND_API.G_EXC_ERROR;
1749: END IF;
1750: HZ_MATCH_RULE_4.find_duplicate_party_sites(
1751: p_rule_id,p_party_site_id,p_party_id,
1752: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
1753: -- Code for Match rule SAMPLE: ADDRESS_PERSONS
1754: ELSIF p_rule_id=5 THEN

Line 1875: IF NOT HZ_MATCH_RULE_40.check_staged THEN

1871: p_rule_id,p_party_site_id,p_party_id,
1872: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
1873: -- Code for Match rule SAMPLE: SEARCH SIMILAR ORGANIZATION EXACT
1874: ELSIF p_rule_id=40 THEN
1875: IF NOT HZ_MATCH_RULE_40.check_staged THEN
1876: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1877: FND_MSG_PUB.ADD;
1878: RAISE FND_API.G_EXC_ERROR;
1879: END IF;

Line 1880: HZ_MATCH_RULE_40.find_duplicate_party_sites(

1876: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1877: FND_MSG_PUB.ADD;
1878: RAISE FND_API.G_EXC_ERROR;
1879: END IF;
1880: HZ_MATCH_RULE_40.find_duplicate_party_sites(
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 SAMPLE: SEARCH SIMILAR PERSON EXACT
1884: ELSIF p_rule_id=41 THEN

Line 1885: IF NOT HZ_MATCH_RULE_41.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 SAMPLE: SEARCH SIMILAR PERSON EXACT
1884: ELSIF p_rule_id=41 THEN
1885: IF NOT HZ_MATCH_RULE_41.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_41.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_41.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 SAMPLE: SEARCH EXACT
1894: ELSIF p_rule_id=42 THEN

Line 1895: IF NOT HZ_MATCH_RULE_42.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 SAMPLE: SEARCH EXACT
1894: ELSIF p_rule_id=42 THEN
1895: IF NOT HZ_MATCH_RULE_42.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_42.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_42.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 DL SYSTEM DUPLICATE IDENTIFICATION
1904: ELSIF p_rule_id=48 THEN

Line 1905: IF NOT HZ_MATCH_RULE_48.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 DL SYSTEM DUPLICATE IDENTIFICATION
1904: ELSIF p_rule_id=48 THEN
1905: IF NOT HZ_MATCH_RULE_48.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_48.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_48.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 BULK MATCH: IDENTICAL ORGANIZATIONS
1914: ELSIF p_rule_id=50 THEN

Line 2139: IF NOT HZ_MATCH_RULE_4.check_staged THEN

2135: p_rule_id,p_org_contact_id,p_party_id,
2136: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2137: -- Code for Match rule SAMPLE: ADDRESS_ORGANIZATIONS
2138: ELSIF p_rule_id=4 THEN
2139: IF NOT HZ_MATCH_RULE_4.check_staged THEN
2140: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2141: FND_MSG_PUB.ADD;
2142: RAISE FND_API.G_EXC_ERROR;
2143: END IF;

Line 2144: HZ_MATCH_RULE_4.find_duplicate_contacts(

2140: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2141: FND_MSG_PUB.ADD;
2142: RAISE FND_API.G_EXC_ERROR;
2143: END IF;
2144: HZ_MATCH_RULE_4.find_duplicate_contacts(
2145: p_rule_id,p_org_contact_id,p_party_id,
2146: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2147: -- Code for Match rule SAMPLE: ADDRESS_PERSONS
2148: ELSIF p_rule_id=5 THEN

Line 2269: IF NOT HZ_MATCH_RULE_40.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 SAMPLE: SEARCH SIMILAR ORGANIZATION EXACT
2268: ELSIF p_rule_id=40 THEN
2269: IF NOT HZ_MATCH_RULE_40.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_40.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_40.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 SAMPLE: SEARCH SIMILAR PERSON EXACT
2278: ELSIF p_rule_id=41 THEN

Line 2279: IF NOT HZ_MATCH_RULE_41.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 SAMPLE: SEARCH SIMILAR PERSON EXACT
2278: ELSIF p_rule_id=41 THEN
2279: IF NOT HZ_MATCH_RULE_41.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_41.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_41.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 SAMPLE: SEARCH EXACT
2288: ELSIF p_rule_id=42 THEN

Line 2289: IF NOT HZ_MATCH_RULE_42.check_staged THEN

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 SAMPLE: SEARCH EXACT
2288: ELSIF p_rule_id=42 THEN
2289: IF NOT HZ_MATCH_RULE_42.check_staged THEN
2290: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2291: FND_MSG_PUB.ADD;
2292: RAISE FND_API.G_EXC_ERROR;
2293: END IF;

Line 2294: HZ_MATCH_RULE_42.find_duplicate_contacts(

2290: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2291: FND_MSG_PUB.ADD;
2292: RAISE FND_API.G_EXC_ERROR;
2293: END IF;
2294: HZ_MATCH_RULE_42.find_duplicate_contacts(
2295: p_rule_id,p_org_contact_id,p_party_id,
2296: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2297: -- Code for Match rule DL SYSTEM DUPLICATE IDENTIFICATION
2298: ELSIF p_rule_id=48 THEN

Line 2299: IF NOT HZ_MATCH_RULE_48.check_staged THEN

2295: p_rule_id,p_org_contact_id,p_party_id,
2296: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2297: -- Code for Match rule DL SYSTEM DUPLICATE IDENTIFICATION
2298: ELSIF p_rule_id=48 THEN
2299: IF NOT HZ_MATCH_RULE_48.check_staged THEN
2300: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2301: FND_MSG_PUB.ADD;
2302: RAISE FND_API.G_EXC_ERROR;
2303: END IF;

Line 2304: HZ_MATCH_RULE_48.find_duplicate_contacts(

2300: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2301: FND_MSG_PUB.ADD;
2302: RAISE FND_API.G_EXC_ERROR;
2303: END IF;
2304: HZ_MATCH_RULE_48.find_duplicate_contacts(
2305: p_rule_id,p_org_contact_id,p_party_id,
2306: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2307: -- Code for Match rule BULK MATCH: IDENTICAL ORGANIZATIONS
2308: ELSIF p_rule_id=50 THEN

Line 2533: IF NOT HZ_MATCH_RULE_4.check_staged THEN

2529: p_rule_id,p_contact_point_id,p_party_id,
2530: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2531: -- Code for Match rule SAMPLE: ADDRESS_ORGANIZATIONS
2532: ELSIF p_rule_id=4 THEN
2533: IF NOT HZ_MATCH_RULE_4.check_staged THEN
2534: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2535: FND_MSG_PUB.ADD;
2536: RAISE FND_API.G_EXC_ERROR;
2537: END IF;

Line 2538: HZ_MATCH_RULE_4.find_duplicate_contact_points(

2534: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2535: FND_MSG_PUB.ADD;
2536: RAISE FND_API.G_EXC_ERROR;
2537: END IF;
2538: HZ_MATCH_RULE_4.find_duplicate_contact_points(
2539: p_rule_id,p_contact_point_id,p_party_id,
2540: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2541: -- Code for Match rule SAMPLE: ADDRESS_PERSONS
2542: ELSIF p_rule_id=5 THEN

Line 2663: IF NOT HZ_MATCH_RULE_40.check_staged THEN

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 SAMPLE: SEARCH SIMILAR ORGANIZATION EXACT
2662: ELSIF p_rule_id=40 THEN
2663: IF NOT HZ_MATCH_RULE_40.check_staged THEN
2664: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2665: FND_MSG_PUB.ADD;
2666: RAISE FND_API.G_EXC_ERROR;
2667: END IF;

Line 2668: HZ_MATCH_RULE_40.find_duplicate_contact_points(

2664: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2665: FND_MSG_PUB.ADD;
2666: RAISE FND_API.G_EXC_ERROR;
2667: END IF;
2668: HZ_MATCH_RULE_40.find_duplicate_contact_points(
2669: p_rule_id,p_contact_point_id,p_party_id,
2670: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2671: -- Code for Match rule SAMPLE: SEARCH SIMILAR PERSON EXACT
2672: ELSIF p_rule_id=41 THEN

Line 2673: IF NOT HZ_MATCH_RULE_41.check_staged THEN

2669: p_rule_id,p_contact_point_id,p_party_id,
2670: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2671: -- Code for Match rule SAMPLE: SEARCH SIMILAR PERSON EXACT
2672: ELSIF p_rule_id=41 THEN
2673: IF NOT HZ_MATCH_RULE_41.check_staged THEN
2674: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2675: FND_MSG_PUB.ADD;
2676: RAISE FND_API.G_EXC_ERROR;
2677: END IF;

Line 2678: HZ_MATCH_RULE_41.find_duplicate_contact_points(

2674: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2675: FND_MSG_PUB.ADD;
2676: RAISE FND_API.G_EXC_ERROR;
2677: END IF;
2678: HZ_MATCH_RULE_41.find_duplicate_contact_points(
2679: p_rule_id,p_contact_point_id,p_party_id,
2680: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2681: -- Code for Match rule SAMPLE: SEARCH EXACT
2682: ELSIF p_rule_id=42 THEN

Line 2683: IF NOT HZ_MATCH_RULE_42.check_staged THEN

2679: p_rule_id,p_contact_point_id,p_party_id,
2680: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2681: -- Code for Match rule SAMPLE: SEARCH EXACT
2682: ELSIF p_rule_id=42 THEN
2683: IF NOT HZ_MATCH_RULE_42.check_staged THEN
2684: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2685: FND_MSG_PUB.ADD;
2686: RAISE FND_API.G_EXC_ERROR;
2687: END IF;

Line 2688: HZ_MATCH_RULE_42.find_duplicate_contact_points(

2684: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2685: FND_MSG_PUB.ADD;
2686: RAISE FND_API.G_EXC_ERROR;
2687: END IF;
2688: HZ_MATCH_RULE_42.find_duplicate_contact_points(
2689: p_rule_id,p_contact_point_id,p_party_id,
2690: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2691: -- Code for Match rule DL SYSTEM DUPLICATE IDENTIFICATION
2692: ELSIF p_rule_id=48 THEN

Line 2693: IF NOT HZ_MATCH_RULE_48.check_staged THEN

2689: p_rule_id,p_contact_point_id,p_party_id,
2690: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2691: -- Code for Match rule DL SYSTEM DUPLICATE IDENTIFICATION
2692: ELSIF p_rule_id=48 THEN
2693: IF NOT HZ_MATCH_RULE_48.check_staged THEN
2694: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2695: FND_MSG_PUB.ADD;
2696: RAISE FND_API.G_EXC_ERROR;
2697: END IF;

Line 2698: HZ_MATCH_RULE_48.find_duplicate_contact_points(

2694: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2695: FND_MSG_PUB.ADD;
2696: RAISE FND_API.G_EXC_ERROR;
2697: END IF;
2698: HZ_MATCH_RULE_48.find_duplicate_contact_points(
2699: p_rule_id,p_contact_point_id,p_party_id,
2700: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2701: -- Code for Match rule BULK MATCH: IDENTICAL ORGANIZATIONS
2702: ELSIF p_rule_id=50 THEN

Line 2983: IF NOT HZ_MATCH_RULE_4.check_staged THEN

2979: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
2980: p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
2981: -- Code for Match rule SAMPLE: ADDRESS_ORGANIZATIONS
2982: ELSIF p_rule_id=4 THEN
2983: IF NOT HZ_MATCH_RULE_4.check_staged THEN
2984: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2985: FND_MSG_PUB.ADD;
2986: RAISE FND_API.G_EXC_ERROR;
2987: END IF;

Line 2988: HZ_MATCH_RULE_4.find_parties_dynamic(

2984: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2985: FND_MSG_PUB.ADD;
2986: RAISE FND_API.G_EXC_ERROR;
2987: END IF;
2988: HZ_MATCH_RULE_4.find_parties_dynamic(
2989: p_rule_id,
2990: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
2991: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
2992: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 3217: IF NOT HZ_MATCH_RULE_40.check_staged THEN

3213: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3214: p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
3215: -- Code for Match rule SAMPLE: SEARCH SIMILAR ORGANIZATION EXACT
3216: ELSIF p_rule_id=40 THEN
3217: IF NOT HZ_MATCH_RULE_40.check_staged THEN
3218: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3219: FND_MSG_PUB.ADD;
3220: RAISE FND_API.G_EXC_ERROR;
3221: END IF;

Line 3222: HZ_MATCH_RULE_40.find_parties_dynamic(

3218: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3219: FND_MSG_PUB.ADD;
3220: RAISE FND_API.G_EXC_ERROR;
3221: END IF;
3222: HZ_MATCH_RULE_40.find_parties_dynamic(
3223: p_rule_id,
3224: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
3225: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
3226: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 3235: IF NOT HZ_MATCH_RULE_41.check_staged THEN

3231: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3232: p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
3233: -- Code for Match rule SAMPLE: SEARCH SIMILAR PERSON EXACT
3234: ELSIF p_rule_id=41 THEN
3235: IF NOT HZ_MATCH_RULE_41.check_staged THEN
3236: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3237: FND_MSG_PUB.ADD;
3238: RAISE FND_API.G_EXC_ERROR;
3239: END IF;

Line 3240: HZ_MATCH_RULE_41.find_parties_dynamic(

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

Line 3253: IF NOT HZ_MATCH_RULE_42.check_staged THEN

3249: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3250: p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
3251: -- Code for Match rule SAMPLE: SEARCH EXACT
3252: ELSIF p_rule_id=42 THEN
3253: IF NOT HZ_MATCH_RULE_42.check_staged THEN
3254: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3255: FND_MSG_PUB.ADD;
3256: RAISE FND_API.G_EXC_ERROR;
3257: END IF;

Line 3258: HZ_MATCH_RULE_42.find_parties_dynamic(

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

Line 3271: IF NOT HZ_MATCH_RULE_48.check_staged THEN

3267: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3268: p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
3269: -- Code for Match rule DL SYSTEM DUPLICATE IDENTIFICATION
3270: ELSIF p_rule_id=48 THEN
3271: IF NOT HZ_MATCH_RULE_48.check_staged THEN
3272: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3273: FND_MSG_PUB.ADD;
3274: RAISE FND_API.G_EXC_ERROR;
3275: END IF;

Line 3276: HZ_MATCH_RULE_48.find_parties_dynamic(

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

Line 3666: IF NOT HZ_MATCH_RULE_4.check_staged THEN

3662: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3663: p_restrict_sql,p_api_name,p_match_type,p_party_id,p_search_merged,x_search_ctx_id,x_num_matches);
3664: -- Code for Match rule SAMPLE: ADDRESS_ORGANIZATIONS
3665: ELSIF p_rule_id=4 THEN
3666: IF NOT HZ_MATCH_RULE_4.check_staged THEN
3667: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3668: FND_MSG_PUB.ADD;
3669: RAISE FND_API.G_EXC_ERROR;
3670: END IF;

Line 3671: HZ_MATCH_RULE_4.call_api_dynamic(

3667: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3668: FND_MSG_PUB.ADD;
3669: RAISE FND_API.G_EXC_ERROR;
3670: END IF;
3671: HZ_MATCH_RULE_4.call_api_dynamic(
3672: p_rule_id,
3673: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
3674: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
3675: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 3900: IF NOT HZ_MATCH_RULE_40.check_staged THEN

3896: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3897: p_restrict_sql,p_api_name,p_match_type,p_party_id,p_search_merged,x_search_ctx_id,x_num_matches);
3898: -- Code for Match rule SAMPLE: SEARCH SIMILAR ORGANIZATION EXACT
3899: ELSIF p_rule_id=40 THEN
3900: IF NOT HZ_MATCH_RULE_40.check_staged THEN
3901: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3902: FND_MSG_PUB.ADD;
3903: RAISE FND_API.G_EXC_ERROR;
3904: END IF;

Line 3905: HZ_MATCH_RULE_40.call_api_dynamic(

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

Line 3918: IF NOT HZ_MATCH_RULE_41.check_staged THEN

3914: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3915: p_restrict_sql,p_api_name,p_match_type,p_party_id,p_search_merged,x_search_ctx_id,x_num_matches);
3916: -- Code for Match rule SAMPLE: SEARCH SIMILAR PERSON EXACT
3917: ELSIF p_rule_id=41 THEN
3918: IF NOT HZ_MATCH_RULE_41.check_staged THEN
3919: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3920: FND_MSG_PUB.ADD;
3921: RAISE FND_API.G_EXC_ERROR;
3922: END IF;

Line 3923: HZ_MATCH_RULE_41.call_api_dynamic(

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

Line 3936: IF NOT HZ_MATCH_RULE_42.check_staged THEN

3932: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3933: p_restrict_sql,p_api_name,p_match_type,p_party_id,p_search_merged,x_search_ctx_id,x_num_matches);
3934: -- Code for Match rule SAMPLE: SEARCH EXACT
3935: ELSIF p_rule_id=42 THEN
3936: IF NOT HZ_MATCH_RULE_42.check_staged THEN
3937: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3938: FND_MSG_PUB.ADD;
3939: RAISE FND_API.G_EXC_ERROR;
3940: END IF;

Line 3941: HZ_MATCH_RULE_42.call_api_dynamic(

3937: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3938: FND_MSG_PUB.ADD;
3939: RAISE FND_API.G_EXC_ERROR;
3940: END IF;
3941: HZ_MATCH_RULE_42.call_api_dynamic(
3942: p_rule_id,
3943: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
3944: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
3945: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 3954: IF NOT HZ_MATCH_RULE_48.check_staged THEN

3950: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3951: p_restrict_sql,p_api_name,p_match_type,p_party_id,p_search_merged,x_search_ctx_id,x_num_matches);
3952: -- Code for Match rule DL SYSTEM DUPLICATE IDENTIFICATION
3953: ELSIF p_rule_id=48 THEN
3954: IF NOT HZ_MATCH_RULE_48.check_staged THEN
3955: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3956: FND_MSG_PUB.ADD;
3957: RAISE FND_API.G_EXC_ERROR;
3958: END IF;

Line 3959: HZ_MATCH_RULE_48.call_api_dynamic(

3955: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3956: FND_MSG_PUB.ADD;
3957: RAISE FND_API.G_EXC_ERROR;
3958: END IF;
3959: HZ_MATCH_RULE_48.call_api_dynamic(
3960: p_rule_id,
3961: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
3962: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
3963: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 4524: IF NOT HZ_MATCH_RULE_4.check_staged THEN

4520: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4521: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4522: -- Code for Match rule SAMPLE: ADDRESS_ORGANIZATIONS
4523: ELSIF p_rule_id=4 THEN
4524: IF NOT HZ_MATCH_RULE_4.check_staged THEN
4525: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4526: FND_MSG_PUB.ADD;
4527: RAISE FND_API.G_EXC_ERROR;
4528: END IF;

Line 4529: HZ_MATCH_RULE_4.get_matching_party_sites(

4525: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4526: FND_MSG_PUB.ADD;
4527: RAISE FND_API.G_EXC_ERROR;
4528: END IF;
4529: HZ_MATCH_RULE_4.get_matching_party_sites(
4530: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4531: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4532: -- Code for Match rule SAMPLE: ADDRESS_PERSONS
4533: ELSIF p_rule_id=5 THEN

Line 4654: IF NOT HZ_MATCH_RULE_40.check_staged THEN

4650: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4651: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4652: -- Code for Match rule SAMPLE: SEARCH SIMILAR ORGANIZATION EXACT
4653: ELSIF p_rule_id=40 THEN
4654: IF NOT HZ_MATCH_RULE_40.check_staged THEN
4655: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4656: FND_MSG_PUB.ADD;
4657: RAISE FND_API.G_EXC_ERROR;
4658: END IF;

Line 4659: HZ_MATCH_RULE_40.get_matching_party_sites(

4655: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4656: FND_MSG_PUB.ADD;
4657: RAISE FND_API.G_EXC_ERROR;
4658: END IF;
4659: HZ_MATCH_RULE_40.get_matching_party_sites(
4660: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4661: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4662: -- Code for Match rule SAMPLE: SEARCH SIMILAR PERSON EXACT
4663: ELSIF p_rule_id=41 THEN

Line 4664: IF NOT HZ_MATCH_RULE_41.check_staged THEN

4660: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4661: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4662: -- Code for Match rule SAMPLE: SEARCH SIMILAR PERSON EXACT
4663: ELSIF p_rule_id=41 THEN
4664: IF NOT HZ_MATCH_RULE_41.check_staged THEN
4665: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4666: FND_MSG_PUB.ADD;
4667: RAISE FND_API.G_EXC_ERROR;
4668: END IF;

Line 4669: HZ_MATCH_RULE_41.get_matching_party_sites(

4665: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4666: FND_MSG_PUB.ADD;
4667: RAISE FND_API.G_EXC_ERROR;
4668: END IF;
4669: HZ_MATCH_RULE_41.get_matching_party_sites(
4670: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4671: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4672: -- Code for Match rule SAMPLE: SEARCH EXACT
4673: ELSIF p_rule_id=42 THEN

Line 4674: IF NOT HZ_MATCH_RULE_42.check_staged THEN

4670: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4671: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4672: -- Code for Match rule SAMPLE: SEARCH EXACT
4673: ELSIF p_rule_id=42 THEN
4674: IF NOT HZ_MATCH_RULE_42.check_staged THEN
4675: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4676: FND_MSG_PUB.ADD;
4677: RAISE FND_API.G_EXC_ERROR;
4678: END IF;

Line 4679: HZ_MATCH_RULE_42.get_matching_party_sites(

4675: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4676: FND_MSG_PUB.ADD;
4677: RAISE FND_API.G_EXC_ERROR;
4678: END IF;
4679: HZ_MATCH_RULE_42.get_matching_party_sites(
4680: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4681: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4682: -- Code for Match rule DL SYSTEM DUPLICATE IDENTIFICATION
4683: ELSIF p_rule_id=48 THEN

Line 4684: IF NOT HZ_MATCH_RULE_48.check_staged THEN

4680: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4681: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4682: -- Code for Match rule DL SYSTEM DUPLICATE IDENTIFICATION
4683: ELSIF p_rule_id=48 THEN
4684: IF NOT HZ_MATCH_RULE_48.check_staged THEN
4685: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4686: FND_MSG_PUB.ADD;
4687: RAISE FND_API.G_EXC_ERROR;
4688: END IF;

Line 4689: HZ_MATCH_RULE_48.get_matching_party_sites(

4685: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4686: FND_MSG_PUB.ADD;
4687: RAISE FND_API.G_EXC_ERROR;
4688: END IF;
4689: HZ_MATCH_RULE_48.get_matching_party_sites(
4690: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4691: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4692: -- Code for Match rule BULK MATCH: IDENTICAL ORGANIZATIONS
4693: ELSIF p_rule_id=50 THEN

Line 4943: IF NOT HZ_MATCH_RULE_4.check_staged THEN

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

Line 4948: HZ_MATCH_RULE_4.get_matching_contacts(

4944: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4945: FND_MSG_PUB.ADD;
4946: RAISE FND_API.G_EXC_ERROR;
4947: END IF;
4948: HZ_MATCH_RULE_4.get_matching_contacts(
4949: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
4950: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4951: -- Code for Match rule SAMPLE: ADDRESS_PERSONS
4952: ELSIF p_rule_id=5 THEN

Line 5073: IF NOT HZ_MATCH_RULE_40.check_staged THEN

5069: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
5070: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5071: -- Code for Match rule SAMPLE: SEARCH SIMILAR ORGANIZATION EXACT
5072: ELSIF p_rule_id=40 THEN
5073: IF NOT HZ_MATCH_RULE_40.check_staged THEN
5074: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5075: FND_MSG_PUB.ADD;
5076: RAISE FND_API.G_EXC_ERROR;
5077: END IF;

Line 5078: HZ_MATCH_RULE_40.get_matching_contacts(

5074: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5075: FND_MSG_PUB.ADD;
5076: RAISE FND_API.G_EXC_ERROR;
5077: END IF;
5078: HZ_MATCH_RULE_40.get_matching_contacts(
5079: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
5080: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5081: -- Code for Match rule SAMPLE: SEARCH SIMILAR PERSON EXACT
5082: ELSIF p_rule_id=41 THEN

Line 5083: IF NOT HZ_MATCH_RULE_41.check_staged THEN

5079: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
5080: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5081: -- Code for Match rule SAMPLE: SEARCH SIMILAR PERSON EXACT
5082: ELSIF p_rule_id=41 THEN
5083: IF NOT HZ_MATCH_RULE_41.check_staged THEN
5084: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5085: FND_MSG_PUB.ADD;
5086: RAISE FND_API.G_EXC_ERROR;
5087: END IF;

Line 5088: HZ_MATCH_RULE_41.get_matching_contacts(

5084: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5085: FND_MSG_PUB.ADD;
5086: RAISE FND_API.G_EXC_ERROR;
5087: END IF;
5088: HZ_MATCH_RULE_41.get_matching_contacts(
5089: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
5090: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5091: -- Code for Match rule SAMPLE: SEARCH EXACT
5092: ELSIF p_rule_id=42 THEN

Line 5093: IF NOT HZ_MATCH_RULE_42.check_staged THEN

5089: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
5090: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5091: -- Code for Match rule SAMPLE: SEARCH EXACT
5092: ELSIF p_rule_id=42 THEN
5093: IF NOT HZ_MATCH_RULE_42.check_staged THEN
5094: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5095: FND_MSG_PUB.ADD;
5096: RAISE FND_API.G_EXC_ERROR;
5097: END IF;

Line 5098: HZ_MATCH_RULE_42.get_matching_contacts(

5094: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5095: FND_MSG_PUB.ADD;
5096: RAISE FND_API.G_EXC_ERROR;
5097: END IF;
5098: HZ_MATCH_RULE_42.get_matching_contacts(
5099: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
5100: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5101: -- Code for Match rule DL SYSTEM DUPLICATE IDENTIFICATION
5102: ELSIF p_rule_id=48 THEN

Line 5103: IF NOT HZ_MATCH_RULE_48.check_staged THEN

5099: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
5100: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5101: -- Code for Match rule DL SYSTEM DUPLICATE IDENTIFICATION
5102: ELSIF p_rule_id=48 THEN
5103: IF NOT HZ_MATCH_RULE_48.check_staged THEN
5104: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5105: FND_MSG_PUB.ADD;
5106: RAISE FND_API.G_EXC_ERROR;
5107: END IF;

Line 5108: HZ_MATCH_RULE_48.get_matching_contacts(

5104: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5105: FND_MSG_PUB.ADD;
5106: RAISE FND_API.G_EXC_ERROR;
5107: END IF;
5108: HZ_MATCH_RULE_48.get_matching_contacts(
5109: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
5110: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5111: -- Code for Match rule BULK MATCH: IDENTICAL ORGANIZATIONS
5112: ELSIF p_rule_id=50 THEN

Line 5360: IF NOT HZ_MATCH_RULE_4.check_staged THEN

5356: p_rule_id, p_party_id, p_contact_point_list,
5357: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5358: -- Code for Match rule SAMPLE: ADDRESS_ORGANIZATIONS
5359: ELSIF p_rule_id=4 THEN
5360: IF NOT HZ_MATCH_RULE_4.check_staged THEN
5361: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5362: FND_MSG_PUB.ADD;
5363: RAISE FND_API.G_EXC_ERROR;
5364: END IF;

Line 5365: HZ_MATCH_RULE_4.get_matching_contact_points(

5361: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5362: FND_MSG_PUB.ADD;
5363: RAISE FND_API.G_EXC_ERROR;
5364: END IF;
5365: HZ_MATCH_RULE_4.get_matching_contact_points(
5366: p_rule_id, p_party_id, p_contact_point_list,
5367: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5368: -- Code for Match rule SAMPLE: ADDRESS_PERSONS
5369: ELSIF p_rule_id=5 THEN

Line 5490: IF NOT HZ_MATCH_RULE_40.check_staged THEN

5486: p_rule_id, p_party_id, p_contact_point_list,
5487: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5488: -- Code for Match rule SAMPLE: SEARCH SIMILAR ORGANIZATION EXACT
5489: ELSIF p_rule_id=40 THEN
5490: IF NOT HZ_MATCH_RULE_40.check_staged THEN
5491: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5492: FND_MSG_PUB.ADD;
5493: RAISE FND_API.G_EXC_ERROR;
5494: END IF;

Line 5495: HZ_MATCH_RULE_40.get_matching_contact_points(

5491: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5492: FND_MSG_PUB.ADD;
5493: RAISE FND_API.G_EXC_ERROR;
5494: END IF;
5495: HZ_MATCH_RULE_40.get_matching_contact_points(
5496: p_rule_id, p_party_id, p_contact_point_list,
5497: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5498: -- Code for Match rule SAMPLE: SEARCH SIMILAR PERSON EXACT
5499: ELSIF p_rule_id=41 THEN

Line 5500: IF NOT HZ_MATCH_RULE_41.check_staged THEN

5496: p_rule_id, p_party_id, p_contact_point_list,
5497: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5498: -- Code for Match rule SAMPLE: SEARCH SIMILAR PERSON EXACT
5499: ELSIF p_rule_id=41 THEN
5500: IF NOT HZ_MATCH_RULE_41.check_staged THEN
5501: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5502: FND_MSG_PUB.ADD;
5503: RAISE FND_API.G_EXC_ERROR;
5504: END IF;

Line 5505: HZ_MATCH_RULE_41.get_matching_contact_points(

5501: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5502: FND_MSG_PUB.ADD;
5503: RAISE FND_API.G_EXC_ERROR;
5504: END IF;
5505: HZ_MATCH_RULE_41.get_matching_contact_points(
5506: p_rule_id, p_party_id, p_contact_point_list,
5507: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5508: -- Code for Match rule SAMPLE: SEARCH EXACT
5509: ELSIF p_rule_id=42 THEN

Line 5510: IF NOT HZ_MATCH_RULE_42.check_staged THEN

5506: p_rule_id, p_party_id, p_contact_point_list,
5507: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5508: -- Code for Match rule SAMPLE: SEARCH EXACT
5509: ELSIF p_rule_id=42 THEN
5510: IF NOT HZ_MATCH_RULE_42.check_staged THEN
5511: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5512: FND_MSG_PUB.ADD;
5513: RAISE FND_API.G_EXC_ERROR;
5514: END IF;

Line 5515: HZ_MATCH_RULE_42.get_matching_contact_points(

5511: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5512: FND_MSG_PUB.ADD;
5513: RAISE FND_API.G_EXC_ERROR;
5514: END IF;
5515: HZ_MATCH_RULE_42.get_matching_contact_points(
5516: p_rule_id, p_party_id, p_contact_point_list,
5517: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5518: -- Code for Match rule DL SYSTEM DUPLICATE IDENTIFICATION
5519: ELSIF p_rule_id=48 THEN

Line 5520: IF NOT HZ_MATCH_RULE_48.check_staged THEN

5516: p_rule_id, p_party_id, p_contact_point_list,
5517: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5518: -- Code for Match rule DL SYSTEM DUPLICATE IDENTIFICATION
5519: ELSIF p_rule_id=48 THEN
5520: IF NOT HZ_MATCH_RULE_48.check_staged THEN
5521: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5522: FND_MSG_PUB.ADD;
5523: RAISE FND_API.G_EXC_ERROR;
5524: END IF;

Line 5525: HZ_MATCH_RULE_48.get_matching_contact_points(

5521: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5522: FND_MSG_PUB.ADD;
5523: RAISE FND_API.G_EXC_ERROR;
5524: END IF;
5525: HZ_MATCH_RULE_48.get_matching_contact_points(
5526: p_rule_id, p_party_id, p_contact_point_list,
5527: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5528: -- Code for Match rule BULK MATCH: IDENTICAL ORGANIZATIONS
5529: ELSIF p_rule_id=50 THEN

Line 5782: IF NOT HZ_MATCH_RULE_4.check_staged THEN

5778: p_party_id, p_party_search_rec,p_party_site_list,
5779: p_contact_list, p_contact_point_list,x_search_ctx_id);
5780: -- Code for Match rule SAMPLE: ADDRESS_ORGANIZATIONS
5781: ELSIF p_rule_id=4 THEN
5782: IF NOT HZ_MATCH_RULE_4.check_staged THEN
5783: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5784: FND_MSG_PUB.ADD;
5785: RAISE FND_API.G_EXC_ERROR;
5786: END IF;

Line 5787: HZ_MATCH_RULE_4.get_score_details(

5783: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5784: FND_MSG_PUB.ADD;
5785: RAISE FND_API.G_EXC_ERROR;
5786: END IF;
5787: HZ_MATCH_RULE_4.get_score_details(
5788: p_rule_id,
5789: p_party_id, p_party_search_rec,p_party_site_list,
5790: p_contact_list, p_contact_point_list,x_search_ctx_id);
5791: -- Code for Match rule SAMPLE: ADDRESS_PERSONS

Line 5925: IF NOT HZ_MATCH_RULE_40.check_staged THEN

5921: p_party_id, p_party_search_rec,p_party_site_list,
5922: p_contact_list, p_contact_point_list,x_search_ctx_id);
5923: -- Code for Match rule SAMPLE: SEARCH SIMILAR ORGANIZATION EXACT
5924: ELSIF p_rule_id=40 THEN
5925: IF NOT HZ_MATCH_RULE_40.check_staged THEN
5926: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5927: FND_MSG_PUB.ADD;
5928: RAISE FND_API.G_EXC_ERROR;
5929: END IF;

Line 5930: HZ_MATCH_RULE_40.get_score_details(

5926: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5927: FND_MSG_PUB.ADD;
5928: RAISE FND_API.G_EXC_ERROR;
5929: END IF;
5930: HZ_MATCH_RULE_40.get_score_details(
5931: p_rule_id,
5932: p_party_id, p_party_search_rec,p_party_site_list,
5933: p_contact_list, p_contact_point_list,x_search_ctx_id);
5934: -- Code for Match rule SAMPLE: SEARCH SIMILAR PERSON EXACT

Line 5936: IF NOT HZ_MATCH_RULE_41.check_staged THEN

5932: p_party_id, p_party_search_rec,p_party_site_list,
5933: p_contact_list, p_contact_point_list,x_search_ctx_id);
5934: -- Code for Match rule SAMPLE: SEARCH SIMILAR PERSON EXACT
5935: ELSIF p_rule_id=41 THEN
5936: IF NOT HZ_MATCH_RULE_41.check_staged THEN
5937: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5938: FND_MSG_PUB.ADD;
5939: RAISE FND_API.G_EXC_ERROR;
5940: END IF;

Line 5941: HZ_MATCH_RULE_41.get_score_details(

5937: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5938: FND_MSG_PUB.ADD;
5939: RAISE FND_API.G_EXC_ERROR;
5940: END IF;
5941: HZ_MATCH_RULE_41.get_score_details(
5942: p_rule_id,
5943: p_party_id, p_party_search_rec,p_party_site_list,
5944: p_contact_list, p_contact_point_list,x_search_ctx_id);
5945: -- Code for Match rule SAMPLE: SEARCH EXACT

Line 5947: IF NOT HZ_MATCH_RULE_42.check_staged THEN

5943: p_party_id, p_party_search_rec,p_party_site_list,
5944: p_contact_list, p_contact_point_list,x_search_ctx_id);
5945: -- Code for Match rule SAMPLE: SEARCH EXACT
5946: ELSIF p_rule_id=42 THEN
5947: IF NOT HZ_MATCH_RULE_42.check_staged THEN
5948: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5949: FND_MSG_PUB.ADD;
5950: RAISE FND_API.G_EXC_ERROR;
5951: END IF;

Line 5952: HZ_MATCH_RULE_42.get_score_details(

5948: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5949: FND_MSG_PUB.ADD;
5950: RAISE FND_API.G_EXC_ERROR;
5951: END IF;
5952: HZ_MATCH_RULE_42.get_score_details(
5953: p_rule_id,
5954: p_party_id, p_party_search_rec,p_party_site_list,
5955: p_contact_list, p_contact_point_list,x_search_ctx_id);
5956: -- Code for Match rule DL SYSTEM DUPLICATE IDENTIFICATION

Line 5958: IF NOT HZ_MATCH_RULE_48.check_staged THEN

5954: p_party_id, p_party_search_rec,p_party_site_list,
5955: p_contact_list, p_contact_point_list,x_search_ctx_id);
5956: -- Code for Match rule DL SYSTEM DUPLICATE IDENTIFICATION
5957: ELSIF p_rule_id=48 THEN
5958: IF NOT HZ_MATCH_RULE_48.check_staged THEN
5959: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5960: FND_MSG_PUB.ADD;
5961: RAISE FND_API.G_EXC_ERROR;
5962: END IF;

Line 5963: HZ_MATCH_RULE_48.get_score_details(

5959: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5960: FND_MSG_PUB.ADD;
5961: RAISE FND_API.G_EXC_ERROR;
5962: END IF;
5963: HZ_MATCH_RULE_48.get_score_details(
5964: p_rule_id,
5965: p_party_id, p_party_search_rec,p_party_site_list,
5966: p_contact_list, p_contact_point_list,x_search_ctx_id);
5967: -- Code for Match rule BULK MATCH: IDENTICAL ORGANIZATIONS

Line 6200: IF NOT HZ_MATCH_RULE_4.check_staged THEN

6196: p_party_id, x_party_search_rec,x_party_site_list,
6197: x_contact_list, x_contact_point_list);
6198: -- Code for Match rule SAMPLE: ADDRESS_ORGANIZATIONS
6199: ELSIF p_rule_id=4 THEN
6200: IF NOT HZ_MATCH_RULE_4.check_staged THEN
6201: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6202: FND_MSG_PUB.ADD;
6203: RAISE FND_API.G_EXC_ERROR;
6204: END IF;

Line 6205: HZ_MATCH_RULE_4.get_party_for_search(

6201: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6202: FND_MSG_PUB.ADD;
6203: RAISE FND_API.G_EXC_ERROR;
6204: END IF;
6205: HZ_MATCH_RULE_4.get_party_for_search(
6206: p_party_id, x_party_search_rec,x_party_site_list,
6207: x_contact_list, x_contact_point_list);
6208: -- Code for Match rule SAMPLE: ADDRESS_PERSONS
6209: ELSIF p_rule_id=5 THEN

Line 6330: IF NOT HZ_MATCH_RULE_40.check_staged THEN

6326: p_party_id, x_party_search_rec,x_party_site_list,
6327: x_contact_list, x_contact_point_list);
6328: -- Code for Match rule SAMPLE: SEARCH SIMILAR ORGANIZATION EXACT
6329: ELSIF p_rule_id=40 THEN
6330: IF NOT HZ_MATCH_RULE_40.check_staged THEN
6331: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6332: FND_MSG_PUB.ADD;
6333: RAISE FND_API.G_EXC_ERROR;
6334: END IF;

Line 6335: HZ_MATCH_RULE_40.get_party_for_search(

6331: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6332: FND_MSG_PUB.ADD;
6333: RAISE FND_API.G_EXC_ERROR;
6334: END IF;
6335: HZ_MATCH_RULE_40.get_party_for_search(
6336: p_party_id, x_party_search_rec,x_party_site_list,
6337: x_contact_list, x_contact_point_list);
6338: -- Code for Match rule SAMPLE: SEARCH SIMILAR PERSON EXACT
6339: ELSIF p_rule_id=41 THEN

Line 6340: IF NOT HZ_MATCH_RULE_41.check_staged THEN

6336: p_party_id, x_party_search_rec,x_party_site_list,
6337: x_contact_list, x_contact_point_list);
6338: -- Code for Match rule SAMPLE: SEARCH SIMILAR PERSON EXACT
6339: ELSIF p_rule_id=41 THEN
6340: IF NOT HZ_MATCH_RULE_41.check_staged THEN
6341: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6342: FND_MSG_PUB.ADD;
6343: RAISE FND_API.G_EXC_ERROR;
6344: END IF;

Line 6345: HZ_MATCH_RULE_41.get_party_for_search(

6341: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6342: FND_MSG_PUB.ADD;
6343: RAISE FND_API.G_EXC_ERROR;
6344: END IF;
6345: HZ_MATCH_RULE_41.get_party_for_search(
6346: p_party_id, x_party_search_rec,x_party_site_list,
6347: x_contact_list, x_contact_point_list);
6348: -- Code for Match rule SAMPLE: SEARCH EXACT
6349: ELSIF p_rule_id=42 THEN

Line 6350: IF NOT HZ_MATCH_RULE_42.check_staged THEN

6346: p_party_id, x_party_search_rec,x_party_site_list,
6347: x_contact_list, x_contact_point_list);
6348: -- Code for Match rule SAMPLE: SEARCH EXACT
6349: ELSIF p_rule_id=42 THEN
6350: IF NOT HZ_MATCH_RULE_42.check_staged THEN
6351: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6352: FND_MSG_PUB.ADD;
6353: RAISE FND_API.G_EXC_ERROR;
6354: END IF;

Line 6355: HZ_MATCH_RULE_42.get_party_for_search(

6351: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6352: FND_MSG_PUB.ADD;
6353: RAISE FND_API.G_EXC_ERROR;
6354: END IF;
6355: HZ_MATCH_RULE_42.get_party_for_search(
6356: p_party_id, x_party_search_rec,x_party_site_list,
6357: x_contact_list, x_contact_point_list);
6358: -- Code for Match rule DL SYSTEM DUPLICATE IDENTIFICATION
6359: ELSIF p_rule_id=48 THEN

Line 6360: IF NOT HZ_MATCH_RULE_48.check_staged THEN

6356: p_party_id, x_party_search_rec,x_party_site_list,
6357: x_contact_list, x_contact_point_list);
6358: -- Code for Match rule DL SYSTEM DUPLICATE IDENTIFICATION
6359: ELSIF p_rule_id=48 THEN
6360: IF NOT HZ_MATCH_RULE_48.check_staged THEN
6361: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6362: FND_MSG_PUB.ADD;
6363: RAISE FND_API.G_EXC_ERROR;
6364: END IF;

Line 6365: HZ_MATCH_RULE_48.get_party_for_search(

6361: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6362: FND_MSG_PUB.ADD;
6363: RAISE FND_API.G_EXC_ERROR;
6364: END IF;
6365: HZ_MATCH_RULE_48.get_party_for_search(
6366: p_party_id, x_party_search_rec,x_party_site_list,
6367: x_contact_list, x_contact_point_list);
6368: -- Code for Match rule BULK MATCH: IDENTICAL ORGANIZATIONS
6369: ELSIF p_rule_id=50 THEN

Line 6592: IF NOT HZ_MATCH_RULE_4.check_staged THEN

6588: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6589: x_contact_list, x_contact_point_list);
6590: -- Code for Match rule SAMPLE: ADDRESS_ORGANIZATIONS
6591: ELSIF p_rule_id=4 THEN
6592: IF NOT HZ_MATCH_RULE_4.check_staged THEN
6593: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6594: FND_MSG_PUB.ADD;
6595: RAISE FND_API.G_EXC_ERROR;
6596: END IF;

Line 6597: HZ_MATCH_RULE_4.get_search_criteria(

6593: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6594: FND_MSG_PUB.ADD;
6595: RAISE FND_API.G_EXC_ERROR;
6596: END IF;
6597: HZ_MATCH_RULE_4.get_search_criteria(
6598: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6599: x_contact_list, x_contact_point_list);
6600: -- Code for Match rule SAMPLE: ADDRESS_PERSONS
6601: ELSIF p_rule_id=5 THEN

Line 6722: IF NOT HZ_MATCH_RULE_40.check_staged THEN

6718: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6719: x_contact_list, x_contact_point_list);
6720: -- Code for Match rule SAMPLE: SEARCH SIMILAR ORGANIZATION EXACT
6721: ELSIF p_rule_id=40 THEN
6722: IF NOT HZ_MATCH_RULE_40.check_staged THEN
6723: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6724: FND_MSG_PUB.ADD;
6725: RAISE FND_API.G_EXC_ERROR;
6726: END IF;

Line 6727: HZ_MATCH_RULE_40.get_search_criteria(

6723: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6724: FND_MSG_PUB.ADD;
6725: RAISE FND_API.G_EXC_ERROR;
6726: END IF;
6727: HZ_MATCH_RULE_40.get_search_criteria(
6728: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6729: x_contact_list, x_contact_point_list);
6730: -- Code for Match rule SAMPLE: SEARCH SIMILAR PERSON EXACT
6731: ELSIF p_rule_id=41 THEN

Line 6732: IF NOT HZ_MATCH_RULE_41.check_staged THEN

6728: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6729: x_contact_list, x_contact_point_list);
6730: -- Code for Match rule SAMPLE: SEARCH SIMILAR PERSON EXACT
6731: ELSIF p_rule_id=41 THEN
6732: IF NOT HZ_MATCH_RULE_41.check_staged THEN
6733: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6734: FND_MSG_PUB.ADD;
6735: RAISE FND_API.G_EXC_ERROR;
6736: END IF;

Line 6737: HZ_MATCH_RULE_41.get_search_criteria(

6733: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6734: FND_MSG_PUB.ADD;
6735: RAISE FND_API.G_EXC_ERROR;
6736: END IF;
6737: HZ_MATCH_RULE_41.get_search_criteria(
6738: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6739: x_contact_list, x_contact_point_list);
6740: -- Code for Match rule SAMPLE: SEARCH EXACT
6741: ELSIF p_rule_id=42 THEN

Line 6742: IF NOT HZ_MATCH_RULE_42.check_staged THEN

6738: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6739: x_contact_list, x_contact_point_list);
6740: -- Code for Match rule SAMPLE: SEARCH EXACT
6741: ELSIF p_rule_id=42 THEN
6742: IF NOT HZ_MATCH_RULE_42.check_staged THEN
6743: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6744: FND_MSG_PUB.ADD;
6745: RAISE FND_API.G_EXC_ERROR;
6746: END IF;

Line 6747: HZ_MATCH_RULE_42.get_search_criteria(

6743: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6744: FND_MSG_PUB.ADD;
6745: RAISE FND_API.G_EXC_ERROR;
6746: END IF;
6747: HZ_MATCH_RULE_42.get_search_criteria(
6748: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6749: x_contact_list, x_contact_point_list);
6750: -- Code for Match rule DL SYSTEM DUPLICATE IDENTIFICATION
6751: ELSIF p_rule_id=48 THEN

Line 6752: IF NOT HZ_MATCH_RULE_48.check_staged THEN

6748: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6749: x_contact_list, x_contact_point_list);
6750: -- Code for Match rule DL SYSTEM DUPLICATE IDENTIFICATION
6751: ELSIF p_rule_id=48 THEN
6752: IF NOT HZ_MATCH_RULE_48.check_staged THEN
6753: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6754: FND_MSG_PUB.ADD;
6755: RAISE FND_API.G_EXC_ERROR;
6756: END IF;

Line 6757: HZ_MATCH_RULE_48.get_search_criteria(

6753: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6754: FND_MSG_PUB.ADD;
6755: RAISE FND_API.G_EXC_ERROR;
6756: END IF;
6757: HZ_MATCH_RULE_48.get_search_criteria(
6758: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6759: x_contact_list, x_contact_point_list);
6760: -- Code for Match rule BULK MATCH: IDENTICAL ORGANIZATIONS
6761: ELSIF p_rule_id=50 THEN