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 511: IF NOT HZ_MATCH_RULE_4.check_staged THEN

507: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
508: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,'N',x_search_ctx_id,x_num_matches);
509: -- Code for Match rule SAMPLE: ADDRESS_ORGANIZATIONS
510: ELSIF p_rule_id=4 THEN
511: IF NOT HZ_MATCH_RULE_4.check_staged THEN
512: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
513: FND_MSG_PUB.ADD;
514: RAISE FND_API.G_EXC_ERROR;
515: END IF;

Line 516: HZ_MATCH_RULE_4.find_persons(

512: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
513: FND_MSG_PUB.ADD;
514: RAISE FND_API.G_EXC_ERROR;
515: END IF;
516: HZ_MATCH_RULE_4.find_persons(
517: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
518: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,'N',x_search_ctx_id,x_num_matches);
519: -- Code for Match rule SAMPLE: ADDRESS_PERSONS
520: ELSIF p_rule_id=5 THEN

Line 641: IF NOT HZ_MATCH_RULE_40.check_staged THEN

637: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
638: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,'N',x_search_ctx_id,x_num_matches);
639: -- Code for Match rule SAMPLE: SEARCH SIMILAR ORGANIZATION EXACT
640: ELSIF p_rule_id=40 THEN
641: IF NOT HZ_MATCH_RULE_40.check_staged THEN
642: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
643: FND_MSG_PUB.ADD;
644: RAISE FND_API.G_EXC_ERROR;
645: END IF;

Line 646: HZ_MATCH_RULE_40.find_persons(

642: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
643: FND_MSG_PUB.ADD;
644: RAISE FND_API.G_EXC_ERROR;
645: END IF;
646: HZ_MATCH_RULE_40.find_persons(
647: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
648: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,'N',x_search_ctx_id,x_num_matches);
649: -- Code for Match rule SAMPLE: SEARCH SIMILAR PERSON EXACT
650: ELSIF p_rule_id=41 THEN

Line 651: IF NOT HZ_MATCH_RULE_41.check_staged THEN

647: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
648: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,'N',x_search_ctx_id,x_num_matches);
649: -- Code for Match rule SAMPLE: SEARCH SIMILAR PERSON EXACT
650: ELSIF p_rule_id=41 THEN
651: IF NOT HZ_MATCH_RULE_41.check_staged THEN
652: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
653: FND_MSG_PUB.ADD;
654: RAISE FND_API.G_EXC_ERROR;
655: END IF;

Line 656: HZ_MATCH_RULE_41.find_persons(

652: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
653: FND_MSG_PUB.ADD;
654: RAISE FND_API.G_EXC_ERROR;
655: END IF;
656: HZ_MATCH_RULE_41.find_persons(
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 EXACT
660: ELSIF p_rule_id=42 THEN

Line 661: IF NOT HZ_MATCH_RULE_42.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 EXACT
660: ELSIF p_rule_id=42 THEN
661: IF NOT HZ_MATCH_RULE_42.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_42.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_42.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 DL SYSTEM DUPLICATE IDENTIFICATION
670: ELSIF p_rule_id=48 THEN

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

Line 910: IF NOT HZ_MATCH_RULE_4.check_staged THEN

906: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
907: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
908: -- Code for Match rule SAMPLE: ADDRESS_ORGANIZATIONS
909: ELSIF p_rule_id=4 THEN
910: IF NOT HZ_MATCH_RULE_4.check_staged THEN
911: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
912: FND_MSG_PUB.ADD;
913: RAISE FND_API.G_EXC_ERROR;
914: END IF;

Line 915: HZ_MATCH_RULE_4.find_party_details(

911: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
912: FND_MSG_PUB.ADD;
913: RAISE FND_API.G_EXC_ERROR;
914: END IF;
915: HZ_MATCH_RULE_4.find_party_details(
916: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
917: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
918: -- Code for Match rule SAMPLE: ADDRESS_PERSONS
919: ELSIF p_rule_id=5 THEN

Line 1040: IF NOT HZ_MATCH_RULE_40.check_staged THEN

1036: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
1037: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
1038: -- Code for Match rule SAMPLE: SEARCH SIMILAR ORGANIZATION EXACT
1039: ELSIF p_rule_id=40 THEN
1040: IF NOT HZ_MATCH_RULE_40.check_staged THEN
1041: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1042: FND_MSG_PUB.ADD;
1043: RAISE FND_API.G_EXC_ERROR;
1044: END IF;

Line 1045: HZ_MATCH_RULE_40.find_party_details(

1041: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1042: FND_MSG_PUB.ADD;
1043: RAISE FND_API.G_EXC_ERROR;
1044: END IF;
1045: HZ_MATCH_RULE_40.find_party_details(
1046: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
1047: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
1048: -- Code for Match rule SAMPLE: SEARCH SIMILAR PERSON EXACT
1049: ELSIF p_rule_id=41 THEN

Line 1050: IF NOT HZ_MATCH_RULE_41.check_staged THEN

1046: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
1047: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
1048: -- Code for Match rule SAMPLE: SEARCH SIMILAR PERSON EXACT
1049: ELSIF p_rule_id=41 THEN
1050: IF NOT HZ_MATCH_RULE_41.check_staged THEN
1051: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1052: FND_MSG_PUB.ADD;
1053: RAISE FND_API.G_EXC_ERROR;
1054: END IF;

Line 1055: HZ_MATCH_RULE_41.find_party_details(

1051: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1052: FND_MSG_PUB.ADD;
1053: RAISE FND_API.G_EXC_ERROR;
1054: END IF;
1055: HZ_MATCH_RULE_41.find_party_details(
1056: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
1057: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
1058: -- Code for Match rule SAMPLE: SEARCH EXACT
1059: ELSIF p_rule_id=42 THEN

Line 1060: IF NOT HZ_MATCH_RULE_42.check_staged THEN

1056: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
1057: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
1058: -- Code for Match rule SAMPLE: SEARCH EXACT
1059: ELSIF p_rule_id=42 THEN
1060: IF NOT HZ_MATCH_RULE_42.check_staged THEN
1061: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1062: FND_MSG_PUB.ADD;
1063: RAISE FND_API.G_EXC_ERROR;
1064: END IF;

Line 1065: HZ_MATCH_RULE_42.find_party_details(

1061: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1062: FND_MSG_PUB.ADD;
1063: RAISE FND_API.G_EXC_ERROR;
1064: END IF;
1065: HZ_MATCH_RULE_42.find_party_details(
1066: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
1067: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
1068: -- Code for Match rule DL SYSTEM DUPLICATE IDENTIFICATION
1069: ELSIF p_rule_id=48 THEN

Line 1070: IF NOT HZ_MATCH_RULE_48.check_staged THEN

1066: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
1067: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
1068: -- Code for Match rule DL SYSTEM DUPLICATE IDENTIFICATION
1069: ELSIF p_rule_id=48 THEN
1070: IF NOT HZ_MATCH_RULE_48.check_staged THEN
1071: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1072: FND_MSG_PUB.ADD;
1073: RAISE FND_API.G_EXC_ERROR;
1074: END IF;

Line 1075: HZ_MATCH_RULE_48.find_party_details(

1071: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1072: FND_MSG_PUB.ADD;
1073: RAISE FND_API.G_EXC_ERROR;
1074: END IF;
1075: HZ_MATCH_RULE_48.find_party_details(
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 BULK MATCH: IDENTICAL ORGANIZATIONS
1079: ELSIF p_rule_id=50 THEN

Line 1290: IF NOT HZ_MATCH_RULE_4.check_staged THEN

1286: p_rule_id,p_party_id,
1287: p_restrict_sql,p_match_type,p_dup_batch_id,p_search_merged,x_dup_set_id, x_search_ctx_id,x_num_matches);
1288: -- Code for Match rule SAMPLE: ADDRESS_ORGANIZATIONS
1289: ELSIF p_rule_id=4 THEN
1290: IF NOT HZ_MATCH_RULE_4.check_staged THEN
1291: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1292: FND_MSG_PUB.ADD;
1293: RAISE FND_API.G_EXC_ERROR;
1294: END IF;

Line 1295: HZ_MATCH_RULE_4.find_duplicate_parties(

1291: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1292: FND_MSG_PUB.ADD;
1293: RAISE FND_API.G_EXC_ERROR;
1294: END IF;
1295: HZ_MATCH_RULE_4.find_duplicate_parties(
1296: p_rule_id,p_party_id,
1297: p_restrict_sql,p_match_type,p_dup_batch_id,p_search_merged,x_dup_set_id, x_search_ctx_id,x_num_matches);
1298: -- Code for Match rule SAMPLE: ADDRESS_PERSONS
1299: ELSIF p_rule_id=5 THEN

Line 1420: IF NOT HZ_MATCH_RULE_40.check_staged THEN

1416: p_rule_id,p_party_id,
1417: p_restrict_sql,p_match_type,p_dup_batch_id,p_search_merged,x_dup_set_id, x_search_ctx_id,x_num_matches);
1418: -- Code for Match rule SAMPLE: SEARCH SIMILAR ORGANIZATION EXACT
1419: ELSIF p_rule_id=40 THEN
1420: IF NOT HZ_MATCH_RULE_40.check_staged THEN
1421: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1422: FND_MSG_PUB.ADD;
1423: RAISE FND_API.G_EXC_ERROR;
1424: END IF;

Line 1425: HZ_MATCH_RULE_40.find_duplicate_parties(

1421: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1422: FND_MSG_PUB.ADD;
1423: RAISE FND_API.G_EXC_ERROR;
1424: END IF;
1425: HZ_MATCH_RULE_40.find_duplicate_parties(
1426: p_rule_id,p_party_id,
1427: p_restrict_sql,p_match_type,p_dup_batch_id,p_search_merged,x_dup_set_id, x_search_ctx_id,x_num_matches);
1428: -- Code for Match rule SAMPLE: SEARCH SIMILAR PERSON EXACT
1429: ELSIF p_rule_id=41 THEN

Line 1430: IF NOT HZ_MATCH_RULE_41.check_staged THEN

1426: p_rule_id,p_party_id,
1427: p_restrict_sql,p_match_type,p_dup_batch_id,p_search_merged,x_dup_set_id, x_search_ctx_id,x_num_matches);
1428: -- Code for Match rule SAMPLE: SEARCH SIMILAR PERSON EXACT
1429: ELSIF p_rule_id=41 THEN
1430: IF NOT HZ_MATCH_RULE_41.check_staged THEN
1431: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1432: FND_MSG_PUB.ADD;
1433: RAISE FND_API.G_EXC_ERROR;
1434: END IF;

Line 1435: HZ_MATCH_RULE_41.find_duplicate_parties(

1431: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1432: FND_MSG_PUB.ADD;
1433: RAISE FND_API.G_EXC_ERROR;
1434: END IF;
1435: HZ_MATCH_RULE_41.find_duplicate_parties(
1436: p_rule_id,p_party_id,
1437: p_restrict_sql,p_match_type,p_dup_batch_id,p_search_merged,x_dup_set_id, x_search_ctx_id,x_num_matches);
1438: -- Code for Match rule SAMPLE: SEARCH EXACT
1439: ELSIF p_rule_id=42 THEN

Line 1440: IF NOT HZ_MATCH_RULE_42.check_staged THEN

1436: p_rule_id,p_party_id,
1437: p_restrict_sql,p_match_type,p_dup_batch_id,p_search_merged,x_dup_set_id, x_search_ctx_id,x_num_matches);
1438: -- Code for Match rule SAMPLE: SEARCH EXACT
1439: ELSIF p_rule_id=42 THEN
1440: IF NOT HZ_MATCH_RULE_42.check_staged THEN
1441: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1442: FND_MSG_PUB.ADD;
1443: RAISE FND_API.G_EXC_ERROR;
1444: END IF;

Line 1445: HZ_MATCH_RULE_42.find_duplicate_parties(

1441: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1442: FND_MSG_PUB.ADD;
1443: RAISE FND_API.G_EXC_ERROR;
1444: END IF;
1445: HZ_MATCH_RULE_42.find_duplicate_parties(
1446: p_rule_id,p_party_id,
1447: p_restrict_sql,p_match_type,p_dup_batch_id,p_search_merged,x_dup_set_id, x_search_ctx_id,x_num_matches);
1448: -- Code for Match rule DL SYSTEM DUPLICATE IDENTIFICATION
1449: ELSIF p_rule_id=48 THEN

Line 1450: IF NOT HZ_MATCH_RULE_48.check_staged THEN

1446: p_rule_id,p_party_id,
1447: p_restrict_sql,p_match_type,p_dup_batch_id,p_search_merged,x_dup_set_id, x_search_ctx_id,x_num_matches);
1448: -- Code for Match rule DL SYSTEM DUPLICATE IDENTIFICATION
1449: ELSIF p_rule_id=48 THEN
1450: IF NOT HZ_MATCH_RULE_48.check_staged THEN
1451: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1452: FND_MSG_PUB.ADD;
1453: RAISE FND_API.G_EXC_ERROR;
1454: END IF;

Line 1455: HZ_MATCH_RULE_48.find_duplicate_parties(

1451: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1452: FND_MSG_PUB.ADD;
1453: RAISE FND_API.G_EXC_ERROR;
1454: END IF;
1455: HZ_MATCH_RULE_48.find_duplicate_parties(
1456: p_rule_id,p_party_id,
1457: p_restrict_sql,p_match_type,p_dup_batch_id,p_search_merged,x_dup_set_id, x_search_ctx_id,x_num_matches);
1458: -- Code for Match rule BULK MATCH: IDENTICAL ORGANIZATIONS
1459: ELSIF p_rule_id=50 THEN

Line 1665: IF NOT HZ_MATCH_RULE_4.check_staged THEN

1661: p_rule_id,p_party_site_id,p_party_id,
1662: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
1663: -- Code for Match rule SAMPLE: ADDRESS_ORGANIZATIONS
1664: ELSIF p_rule_id=4 THEN
1665: IF NOT HZ_MATCH_RULE_4.check_staged THEN
1666: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1667: FND_MSG_PUB.ADD;
1668: RAISE FND_API.G_EXC_ERROR;
1669: END IF;

Line 1670: HZ_MATCH_RULE_4.find_duplicate_party_sites(

1666: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1667: FND_MSG_PUB.ADD;
1668: RAISE FND_API.G_EXC_ERROR;
1669: END IF;
1670: HZ_MATCH_RULE_4.find_duplicate_party_sites(
1671: p_rule_id,p_party_site_id,p_party_id,
1672: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
1673: -- Code for Match rule SAMPLE: ADDRESS_PERSONS
1674: ELSIF p_rule_id=5 THEN

Line 1795: IF NOT HZ_MATCH_RULE_40.check_staged THEN

1791: p_rule_id,p_party_site_id,p_party_id,
1792: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
1793: -- Code for Match rule SAMPLE: SEARCH SIMILAR ORGANIZATION EXACT
1794: ELSIF p_rule_id=40 THEN
1795: IF NOT HZ_MATCH_RULE_40.check_staged THEN
1796: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1797: FND_MSG_PUB.ADD;
1798: RAISE FND_API.G_EXC_ERROR;
1799: END IF;

Line 1800: HZ_MATCH_RULE_40.find_duplicate_party_sites(

1796: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1797: FND_MSG_PUB.ADD;
1798: RAISE FND_API.G_EXC_ERROR;
1799: END IF;
1800: HZ_MATCH_RULE_40.find_duplicate_party_sites(
1801: p_rule_id,p_party_site_id,p_party_id,
1802: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
1803: -- Code for Match rule SAMPLE: SEARCH SIMILAR PERSON EXACT
1804: ELSIF p_rule_id=41 THEN

Line 1805: IF NOT HZ_MATCH_RULE_41.check_staged THEN

1801: p_rule_id,p_party_site_id,p_party_id,
1802: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
1803: -- Code for Match rule SAMPLE: SEARCH SIMILAR PERSON EXACT
1804: ELSIF p_rule_id=41 THEN
1805: IF NOT HZ_MATCH_RULE_41.check_staged THEN
1806: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1807: FND_MSG_PUB.ADD;
1808: RAISE FND_API.G_EXC_ERROR;
1809: END IF;

Line 1810: HZ_MATCH_RULE_41.find_duplicate_party_sites(

1806: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1807: FND_MSG_PUB.ADD;
1808: RAISE FND_API.G_EXC_ERROR;
1809: END IF;
1810: HZ_MATCH_RULE_41.find_duplicate_party_sites(
1811: p_rule_id,p_party_site_id,p_party_id,
1812: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
1813: -- Code for Match rule SAMPLE: SEARCH EXACT
1814: ELSIF p_rule_id=42 THEN

Line 1815: IF NOT HZ_MATCH_RULE_42.check_staged THEN

1811: p_rule_id,p_party_site_id,p_party_id,
1812: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
1813: -- Code for Match rule SAMPLE: SEARCH EXACT
1814: ELSIF p_rule_id=42 THEN
1815: IF NOT HZ_MATCH_RULE_42.check_staged THEN
1816: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1817: FND_MSG_PUB.ADD;
1818: RAISE FND_API.G_EXC_ERROR;
1819: END IF;

Line 1820: HZ_MATCH_RULE_42.find_duplicate_party_sites(

1816: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1817: FND_MSG_PUB.ADD;
1818: RAISE FND_API.G_EXC_ERROR;
1819: END IF;
1820: HZ_MATCH_RULE_42.find_duplicate_party_sites(
1821: p_rule_id,p_party_site_id,p_party_id,
1822: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
1823: -- Code for Match rule DL SYSTEM DUPLICATE IDENTIFICATION
1824: ELSIF p_rule_id=48 THEN

Line 1825: IF NOT HZ_MATCH_RULE_48.check_staged THEN

1821: p_rule_id,p_party_site_id,p_party_id,
1822: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
1823: -- Code for Match rule DL SYSTEM DUPLICATE IDENTIFICATION
1824: ELSIF p_rule_id=48 THEN
1825: IF NOT HZ_MATCH_RULE_48.check_staged THEN
1826: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1827: FND_MSG_PUB.ADD;
1828: RAISE FND_API.G_EXC_ERROR;
1829: END IF;

Line 1830: HZ_MATCH_RULE_48.find_duplicate_party_sites(

1826: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1827: FND_MSG_PUB.ADD;
1828: RAISE FND_API.G_EXC_ERROR;
1829: END IF;
1830: HZ_MATCH_RULE_48.find_duplicate_party_sites(
1831: p_rule_id,p_party_site_id,p_party_id,
1832: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
1833: -- Code for Match rule BULK MATCH: IDENTICAL ORGANIZATIONS
1834: ELSIF p_rule_id=50 THEN

Line 2039: IF NOT HZ_MATCH_RULE_4.check_staged THEN

2035: p_rule_id,p_org_contact_id,p_party_id,
2036: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2037: -- Code for Match rule SAMPLE: ADDRESS_ORGANIZATIONS
2038: ELSIF p_rule_id=4 THEN
2039: IF NOT HZ_MATCH_RULE_4.check_staged THEN
2040: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2041: FND_MSG_PUB.ADD;
2042: RAISE FND_API.G_EXC_ERROR;
2043: END IF;

Line 2044: HZ_MATCH_RULE_4.find_duplicate_contacts(

2040: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2041: FND_MSG_PUB.ADD;
2042: RAISE FND_API.G_EXC_ERROR;
2043: END IF;
2044: HZ_MATCH_RULE_4.find_duplicate_contacts(
2045: p_rule_id,p_org_contact_id,p_party_id,
2046: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2047: -- Code for Match rule SAMPLE: ADDRESS_PERSONS
2048: ELSIF p_rule_id=5 THEN

Line 2169: IF NOT HZ_MATCH_RULE_40.check_staged THEN

2165: p_rule_id,p_org_contact_id,p_party_id,
2166: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2167: -- Code for Match rule SAMPLE: SEARCH SIMILAR ORGANIZATION EXACT
2168: ELSIF p_rule_id=40 THEN
2169: IF NOT HZ_MATCH_RULE_40.check_staged THEN
2170: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2171: FND_MSG_PUB.ADD;
2172: RAISE FND_API.G_EXC_ERROR;
2173: END IF;

Line 2174: HZ_MATCH_RULE_40.find_duplicate_contacts(

2170: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2171: FND_MSG_PUB.ADD;
2172: RAISE FND_API.G_EXC_ERROR;
2173: END IF;
2174: HZ_MATCH_RULE_40.find_duplicate_contacts(
2175: p_rule_id,p_org_contact_id,p_party_id,
2176: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2177: -- Code for Match rule SAMPLE: SEARCH SIMILAR PERSON EXACT
2178: ELSIF p_rule_id=41 THEN

Line 2179: IF NOT HZ_MATCH_RULE_41.check_staged THEN

2175: p_rule_id,p_org_contact_id,p_party_id,
2176: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2177: -- Code for Match rule SAMPLE: SEARCH SIMILAR PERSON EXACT
2178: ELSIF p_rule_id=41 THEN
2179: IF NOT HZ_MATCH_RULE_41.check_staged THEN
2180: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2181: FND_MSG_PUB.ADD;
2182: RAISE FND_API.G_EXC_ERROR;
2183: END IF;

Line 2184: HZ_MATCH_RULE_41.find_duplicate_contacts(

2180: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2181: FND_MSG_PUB.ADD;
2182: RAISE FND_API.G_EXC_ERROR;
2183: END IF;
2184: HZ_MATCH_RULE_41.find_duplicate_contacts(
2185: p_rule_id,p_org_contact_id,p_party_id,
2186: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2187: -- Code for Match rule SAMPLE: SEARCH EXACT
2188: ELSIF p_rule_id=42 THEN

Line 2189: IF NOT HZ_MATCH_RULE_42.check_staged THEN

2185: p_rule_id,p_org_contact_id,p_party_id,
2186: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2187: -- Code for Match rule SAMPLE: SEARCH EXACT
2188: ELSIF p_rule_id=42 THEN
2189: IF NOT HZ_MATCH_RULE_42.check_staged THEN
2190: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2191: FND_MSG_PUB.ADD;
2192: RAISE FND_API.G_EXC_ERROR;
2193: END IF;

Line 2194: HZ_MATCH_RULE_42.find_duplicate_contacts(

2190: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2191: FND_MSG_PUB.ADD;
2192: RAISE FND_API.G_EXC_ERROR;
2193: END IF;
2194: HZ_MATCH_RULE_42.find_duplicate_contacts(
2195: p_rule_id,p_org_contact_id,p_party_id,
2196: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2197: -- Code for Match rule DL SYSTEM DUPLICATE IDENTIFICATION
2198: ELSIF p_rule_id=48 THEN

Line 2199: IF NOT HZ_MATCH_RULE_48.check_staged THEN

2195: p_rule_id,p_org_contact_id,p_party_id,
2196: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2197: -- Code for Match rule DL SYSTEM DUPLICATE IDENTIFICATION
2198: ELSIF p_rule_id=48 THEN
2199: IF NOT HZ_MATCH_RULE_48.check_staged THEN
2200: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2201: FND_MSG_PUB.ADD;
2202: RAISE FND_API.G_EXC_ERROR;
2203: END IF;

Line 2204: HZ_MATCH_RULE_48.find_duplicate_contacts(

2200: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2201: FND_MSG_PUB.ADD;
2202: RAISE FND_API.G_EXC_ERROR;
2203: END IF;
2204: HZ_MATCH_RULE_48.find_duplicate_contacts(
2205: p_rule_id,p_org_contact_id,p_party_id,
2206: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2207: -- Code for Match rule BULK MATCH: IDENTICAL ORGANIZATIONS
2208: ELSIF p_rule_id=50 THEN

Line 2413: IF NOT HZ_MATCH_RULE_4.check_staged THEN

2409: p_rule_id,p_contact_point_id,p_party_id,
2410: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2411: -- Code for Match rule SAMPLE: ADDRESS_ORGANIZATIONS
2412: ELSIF p_rule_id=4 THEN
2413: IF NOT HZ_MATCH_RULE_4.check_staged THEN
2414: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2415: FND_MSG_PUB.ADD;
2416: RAISE FND_API.G_EXC_ERROR;
2417: END IF;

Line 2418: HZ_MATCH_RULE_4.find_duplicate_contact_points(

2414: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2415: FND_MSG_PUB.ADD;
2416: RAISE FND_API.G_EXC_ERROR;
2417: END IF;
2418: HZ_MATCH_RULE_4.find_duplicate_contact_points(
2419: p_rule_id,p_contact_point_id,p_party_id,
2420: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2421: -- Code for Match rule SAMPLE: ADDRESS_PERSONS
2422: ELSIF p_rule_id=5 THEN

Line 2543: IF NOT HZ_MATCH_RULE_40.check_staged THEN

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: SEARCH SIMILAR ORGANIZATION EXACT
2542: ELSIF p_rule_id=40 THEN
2543: IF NOT HZ_MATCH_RULE_40.check_staged THEN
2544: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2545: FND_MSG_PUB.ADD;
2546: RAISE FND_API.G_EXC_ERROR;
2547: END IF;

Line 2548: HZ_MATCH_RULE_40.find_duplicate_contact_points(

2544: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2545: FND_MSG_PUB.ADD;
2546: RAISE FND_API.G_EXC_ERROR;
2547: END IF;
2548: HZ_MATCH_RULE_40.find_duplicate_contact_points(
2549: p_rule_id,p_contact_point_id,p_party_id,
2550: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2551: -- Code for Match rule SAMPLE: SEARCH SIMILAR PERSON EXACT
2552: ELSIF p_rule_id=41 THEN

Line 2553: IF NOT HZ_MATCH_RULE_41.check_staged THEN

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

Line 2558: HZ_MATCH_RULE_41.find_duplicate_contact_points(

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

Line 2563: IF NOT HZ_MATCH_RULE_42.check_staged THEN

2559: p_rule_id,p_contact_point_id,p_party_id,
2560: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2561: -- Code for Match rule SAMPLE: SEARCH EXACT
2562: ELSIF p_rule_id=42 THEN
2563: IF NOT HZ_MATCH_RULE_42.check_staged THEN
2564: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2565: FND_MSG_PUB.ADD;
2566: RAISE FND_API.G_EXC_ERROR;
2567: END IF;

Line 2568: HZ_MATCH_RULE_42.find_duplicate_contact_points(

2564: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2565: FND_MSG_PUB.ADD;
2566: RAISE FND_API.G_EXC_ERROR;
2567: END IF;
2568: HZ_MATCH_RULE_42.find_duplicate_contact_points(
2569: p_rule_id,p_contact_point_id,p_party_id,
2570: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2571: -- Code for Match rule DL SYSTEM DUPLICATE IDENTIFICATION
2572: ELSIF p_rule_id=48 THEN

Line 2573: IF NOT HZ_MATCH_RULE_48.check_staged THEN

2569: p_rule_id,p_contact_point_id,p_party_id,
2570: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2571: -- Code for Match rule DL SYSTEM DUPLICATE IDENTIFICATION
2572: ELSIF p_rule_id=48 THEN
2573: IF NOT HZ_MATCH_RULE_48.check_staged THEN
2574: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2575: FND_MSG_PUB.ADD;
2576: RAISE FND_API.G_EXC_ERROR;
2577: END IF;

Line 2578: HZ_MATCH_RULE_48.find_duplicate_contact_points(

2574: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2575: FND_MSG_PUB.ADD;
2576: RAISE FND_API.G_EXC_ERROR;
2577: END IF;
2578: HZ_MATCH_RULE_48.find_duplicate_contact_points(
2579: p_rule_id,p_contact_point_id,p_party_id,
2580: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2581: -- Code for Match rule BULK MATCH: IDENTICAL ORGANIZATIONS
2582: ELSIF p_rule_id=50 THEN

Line 2843: IF NOT HZ_MATCH_RULE_4.check_staged THEN

2839: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
2840: p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
2841: -- Code for Match rule SAMPLE: ADDRESS_ORGANIZATIONS
2842: ELSIF p_rule_id=4 THEN
2843: IF NOT HZ_MATCH_RULE_4.check_staged THEN
2844: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2845: FND_MSG_PUB.ADD;
2846: RAISE FND_API.G_EXC_ERROR;
2847: END IF;

Line 2848: HZ_MATCH_RULE_4.find_parties_dynamic(

2844: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2845: FND_MSG_PUB.ADD;
2846: RAISE FND_API.G_EXC_ERROR;
2847: END IF;
2848: HZ_MATCH_RULE_4.find_parties_dynamic(
2849: p_rule_id,
2850: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
2851: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
2852: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 3077: IF NOT HZ_MATCH_RULE_40.check_staged THEN

3073: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3074: p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
3075: -- Code for Match rule SAMPLE: SEARCH SIMILAR ORGANIZATION EXACT
3076: ELSIF p_rule_id=40 THEN
3077: IF NOT HZ_MATCH_RULE_40.check_staged THEN
3078: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3079: FND_MSG_PUB.ADD;
3080: RAISE FND_API.G_EXC_ERROR;
3081: END IF;

Line 3082: HZ_MATCH_RULE_40.find_parties_dynamic(

3078: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3079: FND_MSG_PUB.ADD;
3080: RAISE FND_API.G_EXC_ERROR;
3081: END IF;
3082: HZ_MATCH_RULE_40.find_parties_dynamic(
3083: p_rule_id,
3084: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
3085: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
3086: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 3095: IF NOT HZ_MATCH_RULE_41.check_staged THEN

3091: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3092: p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
3093: -- Code for Match rule SAMPLE: SEARCH SIMILAR PERSON EXACT
3094: ELSIF p_rule_id=41 THEN
3095: IF NOT HZ_MATCH_RULE_41.check_staged THEN
3096: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3097: FND_MSG_PUB.ADD;
3098: RAISE FND_API.G_EXC_ERROR;
3099: END IF;

Line 3100: HZ_MATCH_RULE_41.find_parties_dynamic(

3096: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3097: FND_MSG_PUB.ADD;
3098: RAISE FND_API.G_EXC_ERROR;
3099: END IF;
3100: HZ_MATCH_RULE_41.find_parties_dynamic(
3101: p_rule_id,
3102: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
3103: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
3104: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 3113: IF NOT HZ_MATCH_RULE_42.check_staged THEN

3109: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3110: p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
3111: -- Code for Match rule SAMPLE: SEARCH EXACT
3112: ELSIF p_rule_id=42 THEN
3113: IF NOT HZ_MATCH_RULE_42.check_staged THEN
3114: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3115: FND_MSG_PUB.ADD;
3116: RAISE FND_API.G_EXC_ERROR;
3117: END IF;

Line 3118: HZ_MATCH_RULE_42.find_parties_dynamic(

3114: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3115: FND_MSG_PUB.ADD;
3116: RAISE FND_API.G_EXC_ERROR;
3117: END IF;
3118: HZ_MATCH_RULE_42.find_parties_dynamic(
3119: p_rule_id,
3120: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
3121: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
3122: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 3131: IF NOT HZ_MATCH_RULE_48.check_staged THEN

3127: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3128: p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
3129: -- Code for Match rule DL SYSTEM DUPLICATE IDENTIFICATION
3130: ELSIF p_rule_id=48 THEN
3131: IF NOT HZ_MATCH_RULE_48.check_staged THEN
3132: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3133: FND_MSG_PUB.ADD;
3134: RAISE FND_API.G_EXC_ERROR;
3135: END IF;

Line 3136: HZ_MATCH_RULE_48.find_parties_dynamic(

3132: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3133: FND_MSG_PUB.ADD;
3134: RAISE FND_API.G_EXC_ERROR;
3135: END IF;
3136: HZ_MATCH_RULE_48.find_parties_dynamic(
3137: p_rule_id,
3138: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
3139: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
3140: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 3490: IF NOT HZ_MATCH_RULE_4.check_staged THEN

3486: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3487: p_restrict_sql,p_api_name,p_match_type,p_party_id,p_search_merged,x_search_ctx_id,x_num_matches);
3488: -- Code for Match rule SAMPLE: ADDRESS_ORGANIZATIONS
3489: ELSIF p_rule_id=4 THEN
3490: IF NOT HZ_MATCH_RULE_4.check_staged THEN
3491: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3492: FND_MSG_PUB.ADD;
3493: RAISE FND_API.G_EXC_ERROR;
3494: END IF;

Line 3495: HZ_MATCH_RULE_4.call_api_dynamic(

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

Line 3724: IF NOT HZ_MATCH_RULE_40.check_staged THEN

3720: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3721: p_restrict_sql,p_api_name,p_match_type,p_party_id,p_search_merged,x_search_ctx_id,x_num_matches);
3722: -- Code for Match rule SAMPLE: SEARCH SIMILAR ORGANIZATION EXACT
3723: ELSIF p_rule_id=40 THEN
3724: IF NOT HZ_MATCH_RULE_40.check_staged THEN
3725: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3726: FND_MSG_PUB.ADD;
3727: RAISE FND_API.G_EXC_ERROR;
3728: END IF;

Line 3729: HZ_MATCH_RULE_40.call_api_dynamic(

3725: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3726: FND_MSG_PUB.ADD;
3727: RAISE FND_API.G_EXC_ERROR;
3728: END IF;
3729: HZ_MATCH_RULE_40.call_api_dynamic(
3730: p_rule_id,
3731: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
3732: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
3733: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 3742: IF NOT HZ_MATCH_RULE_41.check_staged THEN

3738: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3739: p_restrict_sql,p_api_name,p_match_type,p_party_id,p_search_merged,x_search_ctx_id,x_num_matches);
3740: -- Code for Match rule SAMPLE: SEARCH SIMILAR PERSON EXACT
3741: ELSIF p_rule_id=41 THEN
3742: IF NOT HZ_MATCH_RULE_41.check_staged THEN
3743: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3744: FND_MSG_PUB.ADD;
3745: RAISE FND_API.G_EXC_ERROR;
3746: END IF;

Line 3747: HZ_MATCH_RULE_41.call_api_dynamic(

3743: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3744: FND_MSG_PUB.ADD;
3745: RAISE FND_API.G_EXC_ERROR;
3746: END IF;
3747: HZ_MATCH_RULE_41.call_api_dynamic(
3748: p_rule_id,
3749: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
3750: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
3751: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 3760: IF NOT HZ_MATCH_RULE_42.check_staged THEN

3756: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3757: p_restrict_sql,p_api_name,p_match_type,p_party_id,p_search_merged,x_search_ctx_id,x_num_matches);
3758: -- Code for Match rule SAMPLE: SEARCH EXACT
3759: ELSIF p_rule_id=42 THEN
3760: IF NOT HZ_MATCH_RULE_42.check_staged THEN
3761: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3762: FND_MSG_PUB.ADD;
3763: RAISE FND_API.G_EXC_ERROR;
3764: END IF;

Line 3765: HZ_MATCH_RULE_42.call_api_dynamic(

3761: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3762: FND_MSG_PUB.ADD;
3763: RAISE FND_API.G_EXC_ERROR;
3764: END IF;
3765: HZ_MATCH_RULE_42.call_api_dynamic(
3766: p_rule_id,
3767: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
3768: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
3769: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 3778: IF NOT HZ_MATCH_RULE_48.check_staged THEN

3774: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3775: p_restrict_sql,p_api_name,p_match_type,p_party_id,p_search_merged,x_search_ctx_id,x_num_matches);
3776: -- Code for Match rule DL SYSTEM DUPLICATE IDENTIFICATION
3777: ELSIF p_rule_id=48 THEN
3778: IF NOT HZ_MATCH_RULE_48.check_staged THEN
3779: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3780: FND_MSG_PUB.ADD;
3781: RAISE FND_API.G_EXC_ERROR;
3782: END IF;

Line 3783: HZ_MATCH_RULE_48.call_api_dynamic(

3779: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3780: FND_MSG_PUB.ADD;
3781: RAISE FND_API.G_EXC_ERROR;
3782: END IF;
3783: HZ_MATCH_RULE_48.call_api_dynamic(
3784: p_rule_id,
3785: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
3786: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
3787: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 4312: IF NOT HZ_MATCH_RULE_4.check_staged THEN

4308: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4309: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4310: -- Code for Match rule SAMPLE: ADDRESS_ORGANIZATIONS
4311: ELSIF p_rule_id=4 THEN
4312: IF NOT HZ_MATCH_RULE_4.check_staged THEN
4313: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4314: FND_MSG_PUB.ADD;
4315: RAISE FND_API.G_EXC_ERROR;
4316: END IF;

Line 4317: HZ_MATCH_RULE_4.get_matching_party_sites(

4313: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4314: FND_MSG_PUB.ADD;
4315: RAISE FND_API.G_EXC_ERROR;
4316: END IF;
4317: HZ_MATCH_RULE_4.get_matching_party_sites(
4318: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4319: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4320: -- Code for Match rule SAMPLE: ADDRESS_PERSONS
4321: ELSIF p_rule_id=5 THEN

Line 4442: IF NOT HZ_MATCH_RULE_40.check_staged THEN

4438: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4439: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4440: -- Code for Match rule SAMPLE: SEARCH SIMILAR ORGANIZATION EXACT
4441: ELSIF p_rule_id=40 THEN
4442: IF NOT HZ_MATCH_RULE_40.check_staged THEN
4443: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4444: FND_MSG_PUB.ADD;
4445: RAISE FND_API.G_EXC_ERROR;
4446: END IF;

Line 4447: HZ_MATCH_RULE_40.get_matching_party_sites(

4443: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4444: FND_MSG_PUB.ADD;
4445: RAISE FND_API.G_EXC_ERROR;
4446: END IF;
4447: HZ_MATCH_RULE_40.get_matching_party_sites(
4448: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4449: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4450: -- Code for Match rule SAMPLE: SEARCH SIMILAR PERSON EXACT
4451: ELSIF p_rule_id=41 THEN

Line 4452: IF NOT HZ_MATCH_RULE_41.check_staged THEN

4448: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4449: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4450: -- Code for Match rule SAMPLE: SEARCH SIMILAR PERSON EXACT
4451: ELSIF p_rule_id=41 THEN
4452: IF NOT HZ_MATCH_RULE_41.check_staged THEN
4453: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4454: FND_MSG_PUB.ADD;
4455: RAISE FND_API.G_EXC_ERROR;
4456: END IF;

Line 4457: HZ_MATCH_RULE_41.get_matching_party_sites(

4453: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4454: FND_MSG_PUB.ADD;
4455: RAISE FND_API.G_EXC_ERROR;
4456: END IF;
4457: HZ_MATCH_RULE_41.get_matching_party_sites(
4458: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4459: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4460: -- Code for Match rule SAMPLE: SEARCH EXACT
4461: ELSIF p_rule_id=42 THEN

Line 4462: IF NOT HZ_MATCH_RULE_42.check_staged THEN

4458: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4459: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4460: -- Code for Match rule SAMPLE: SEARCH EXACT
4461: ELSIF p_rule_id=42 THEN
4462: IF NOT HZ_MATCH_RULE_42.check_staged THEN
4463: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4464: FND_MSG_PUB.ADD;
4465: RAISE FND_API.G_EXC_ERROR;
4466: END IF;

Line 4467: HZ_MATCH_RULE_42.get_matching_party_sites(

4463: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4464: FND_MSG_PUB.ADD;
4465: RAISE FND_API.G_EXC_ERROR;
4466: END IF;
4467: HZ_MATCH_RULE_42.get_matching_party_sites(
4468: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4469: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4470: -- Code for Match rule DL SYSTEM DUPLICATE IDENTIFICATION
4471: ELSIF p_rule_id=48 THEN

Line 4472: IF NOT HZ_MATCH_RULE_48.check_staged THEN

4468: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4469: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4470: -- Code for Match rule DL SYSTEM DUPLICATE IDENTIFICATION
4471: ELSIF p_rule_id=48 THEN
4472: IF NOT HZ_MATCH_RULE_48.check_staged THEN
4473: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4474: FND_MSG_PUB.ADD;
4475: RAISE FND_API.G_EXC_ERROR;
4476: END IF;

Line 4477: HZ_MATCH_RULE_48.get_matching_party_sites(

4473: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4474: FND_MSG_PUB.ADD;
4475: RAISE FND_API.G_EXC_ERROR;
4476: END IF;
4477: HZ_MATCH_RULE_48.get_matching_party_sites(
4478: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4479: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4480: -- Code for Match rule BULK MATCH: IDENTICAL ORGANIZATIONS
4481: ELSIF p_rule_id=50 THEN

Line 4711: IF NOT HZ_MATCH_RULE_4.check_staged THEN

4707: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
4708: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4709: -- Code for Match rule SAMPLE: ADDRESS_ORGANIZATIONS
4710: ELSIF p_rule_id=4 THEN
4711: IF NOT HZ_MATCH_RULE_4.check_staged THEN
4712: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4713: FND_MSG_PUB.ADD;
4714: RAISE FND_API.G_EXC_ERROR;
4715: END IF;

Line 4716: HZ_MATCH_RULE_4.get_matching_contacts(

4712: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4713: FND_MSG_PUB.ADD;
4714: RAISE FND_API.G_EXC_ERROR;
4715: END IF;
4716: HZ_MATCH_RULE_4.get_matching_contacts(
4717: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
4718: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4719: -- Code for Match rule SAMPLE: ADDRESS_PERSONS
4720: ELSIF p_rule_id=5 THEN

Line 4841: IF NOT HZ_MATCH_RULE_40.check_staged THEN

4837: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
4838: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4839: -- Code for Match rule SAMPLE: SEARCH SIMILAR ORGANIZATION EXACT
4840: ELSIF p_rule_id=40 THEN
4841: IF NOT HZ_MATCH_RULE_40.check_staged THEN
4842: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4843: FND_MSG_PUB.ADD;
4844: RAISE FND_API.G_EXC_ERROR;
4845: END IF;

Line 4846: HZ_MATCH_RULE_40.get_matching_contacts(

4842: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4843: FND_MSG_PUB.ADD;
4844: RAISE FND_API.G_EXC_ERROR;
4845: END IF;
4846: HZ_MATCH_RULE_40.get_matching_contacts(
4847: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
4848: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4849: -- Code for Match rule SAMPLE: SEARCH SIMILAR PERSON EXACT
4850: ELSIF p_rule_id=41 THEN

Line 4851: IF NOT HZ_MATCH_RULE_41.check_staged THEN

4847: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
4848: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4849: -- Code for Match rule SAMPLE: SEARCH SIMILAR PERSON EXACT
4850: ELSIF p_rule_id=41 THEN
4851: IF NOT HZ_MATCH_RULE_41.check_staged THEN
4852: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4853: FND_MSG_PUB.ADD;
4854: RAISE FND_API.G_EXC_ERROR;
4855: END IF;

Line 4856: HZ_MATCH_RULE_41.get_matching_contacts(

4852: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4853: FND_MSG_PUB.ADD;
4854: RAISE FND_API.G_EXC_ERROR;
4855: END IF;
4856: HZ_MATCH_RULE_41.get_matching_contacts(
4857: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
4858: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4859: -- Code for Match rule SAMPLE: SEARCH EXACT
4860: ELSIF p_rule_id=42 THEN

Line 4861: IF NOT HZ_MATCH_RULE_42.check_staged THEN

4857: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
4858: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4859: -- Code for Match rule SAMPLE: SEARCH EXACT
4860: ELSIF p_rule_id=42 THEN
4861: IF NOT HZ_MATCH_RULE_42.check_staged THEN
4862: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4863: FND_MSG_PUB.ADD;
4864: RAISE FND_API.G_EXC_ERROR;
4865: END IF;

Line 4866: HZ_MATCH_RULE_42.get_matching_contacts(

4862: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4863: FND_MSG_PUB.ADD;
4864: RAISE FND_API.G_EXC_ERROR;
4865: END IF;
4866: HZ_MATCH_RULE_42.get_matching_contacts(
4867: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
4868: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4869: -- Code for Match rule DL SYSTEM DUPLICATE IDENTIFICATION
4870: ELSIF p_rule_id=48 THEN

Line 4871: IF NOT HZ_MATCH_RULE_48.check_staged THEN

4867: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
4868: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4869: -- Code for Match rule DL SYSTEM DUPLICATE IDENTIFICATION
4870: ELSIF p_rule_id=48 THEN
4871: IF NOT HZ_MATCH_RULE_48.check_staged THEN
4872: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4873: FND_MSG_PUB.ADD;
4874: RAISE FND_API.G_EXC_ERROR;
4875: END IF;

Line 4876: HZ_MATCH_RULE_48.get_matching_contacts(

4872: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4873: FND_MSG_PUB.ADD;
4874: RAISE FND_API.G_EXC_ERROR;
4875: END IF;
4876: HZ_MATCH_RULE_48.get_matching_contacts(
4877: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
4878: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4879: -- Code for Match rule BULK MATCH: IDENTICAL ORGANIZATIONS
4880: ELSIF p_rule_id=50 THEN

Line 5108: IF NOT HZ_MATCH_RULE_4.check_staged THEN

5104: p_rule_id, p_party_id, p_contact_point_list,
5105: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5106: -- Code for Match rule SAMPLE: ADDRESS_ORGANIZATIONS
5107: ELSIF p_rule_id=4 THEN
5108: IF NOT HZ_MATCH_RULE_4.check_staged THEN
5109: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5110: FND_MSG_PUB.ADD;
5111: RAISE FND_API.G_EXC_ERROR;
5112: END IF;

Line 5113: HZ_MATCH_RULE_4.get_matching_contact_points(

5109: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5110: FND_MSG_PUB.ADD;
5111: RAISE FND_API.G_EXC_ERROR;
5112: END IF;
5113: HZ_MATCH_RULE_4.get_matching_contact_points(
5114: p_rule_id, p_party_id, p_contact_point_list,
5115: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5116: -- Code for Match rule SAMPLE: ADDRESS_PERSONS
5117: ELSIF p_rule_id=5 THEN

Line 5238: IF NOT HZ_MATCH_RULE_40.check_staged THEN

5234: p_rule_id, p_party_id, p_contact_point_list,
5235: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5236: -- Code for Match rule SAMPLE: SEARCH SIMILAR ORGANIZATION EXACT
5237: ELSIF p_rule_id=40 THEN
5238: IF NOT HZ_MATCH_RULE_40.check_staged THEN
5239: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5240: FND_MSG_PUB.ADD;
5241: RAISE FND_API.G_EXC_ERROR;
5242: END IF;

Line 5243: HZ_MATCH_RULE_40.get_matching_contact_points(

5239: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5240: FND_MSG_PUB.ADD;
5241: RAISE FND_API.G_EXC_ERROR;
5242: END IF;
5243: HZ_MATCH_RULE_40.get_matching_contact_points(
5244: p_rule_id, p_party_id, p_contact_point_list,
5245: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5246: -- Code for Match rule SAMPLE: SEARCH SIMILAR PERSON EXACT
5247: ELSIF p_rule_id=41 THEN

Line 5248: IF NOT HZ_MATCH_RULE_41.check_staged THEN

5244: p_rule_id, p_party_id, p_contact_point_list,
5245: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5246: -- Code for Match rule SAMPLE: SEARCH SIMILAR PERSON EXACT
5247: ELSIF p_rule_id=41 THEN
5248: IF NOT HZ_MATCH_RULE_41.check_staged THEN
5249: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5250: FND_MSG_PUB.ADD;
5251: RAISE FND_API.G_EXC_ERROR;
5252: END IF;

Line 5253: HZ_MATCH_RULE_41.get_matching_contact_points(

5249: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5250: FND_MSG_PUB.ADD;
5251: RAISE FND_API.G_EXC_ERROR;
5252: END IF;
5253: HZ_MATCH_RULE_41.get_matching_contact_points(
5254: p_rule_id, p_party_id, p_contact_point_list,
5255: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5256: -- Code for Match rule SAMPLE: SEARCH EXACT
5257: ELSIF p_rule_id=42 THEN

Line 5258: IF NOT HZ_MATCH_RULE_42.check_staged THEN

5254: p_rule_id, p_party_id, p_contact_point_list,
5255: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5256: -- Code for Match rule SAMPLE: SEARCH EXACT
5257: ELSIF p_rule_id=42 THEN
5258: IF NOT HZ_MATCH_RULE_42.check_staged THEN
5259: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5260: FND_MSG_PUB.ADD;
5261: RAISE FND_API.G_EXC_ERROR;
5262: END IF;

Line 5263: HZ_MATCH_RULE_42.get_matching_contact_points(

5259: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5260: FND_MSG_PUB.ADD;
5261: RAISE FND_API.G_EXC_ERROR;
5262: END IF;
5263: HZ_MATCH_RULE_42.get_matching_contact_points(
5264: p_rule_id, p_party_id, p_contact_point_list,
5265: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5266: -- Code for Match rule DL SYSTEM DUPLICATE IDENTIFICATION
5267: ELSIF p_rule_id=48 THEN

Line 5268: IF NOT HZ_MATCH_RULE_48.check_staged THEN

5264: p_rule_id, p_party_id, p_contact_point_list,
5265: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5266: -- Code for Match rule DL SYSTEM DUPLICATE IDENTIFICATION
5267: ELSIF p_rule_id=48 THEN
5268: IF NOT HZ_MATCH_RULE_48.check_staged THEN
5269: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5270: FND_MSG_PUB.ADD;
5271: RAISE FND_API.G_EXC_ERROR;
5272: END IF;

Line 5273: HZ_MATCH_RULE_48.get_matching_contact_points(

5269: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5270: FND_MSG_PUB.ADD;
5271: RAISE FND_API.G_EXC_ERROR;
5272: END IF;
5273: HZ_MATCH_RULE_48.get_matching_contact_points(
5274: p_rule_id, p_party_id, p_contact_point_list,
5275: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5276: -- Code for Match rule BULK MATCH: IDENTICAL ORGANIZATIONS
5277: ELSIF p_rule_id=50 THEN

Line 5510: IF NOT HZ_MATCH_RULE_4.check_staged THEN

5506: p_party_id, p_party_search_rec,p_party_site_list,
5507: p_contact_list, p_contact_point_list,x_search_ctx_id);
5508: -- Code for Match rule SAMPLE: ADDRESS_ORGANIZATIONS
5509: ELSIF p_rule_id=4 THEN
5510: IF NOT HZ_MATCH_RULE_4.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_4.get_score_details(

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_4.get_score_details(
5516: p_rule_id,
5517: p_party_id, p_party_search_rec,p_party_site_list,
5518: p_contact_list, p_contact_point_list,x_search_ctx_id);
5519: -- Code for Match rule SAMPLE: ADDRESS_PERSONS

Line 5653: IF NOT HZ_MATCH_RULE_40.check_staged THEN

5649: p_party_id, p_party_search_rec,p_party_site_list,
5650: p_contact_list, p_contact_point_list,x_search_ctx_id);
5651: -- Code for Match rule SAMPLE: SEARCH SIMILAR ORGANIZATION EXACT
5652: ELSIF p_rule_id=40 THEN
5653: IF NOT HZ_MATCH_RULE_40.check_staged THEN
5654: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5655: FND_MSG_PUB.ADD;
5656: RAISE FND_API.G_EXC_ERROR;
5657: END IF;

Line 5658: HZ_MATCH_RULE_40.get_score_details(

5654: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5655: FND_MSG_PUB.ADD;
5656: RAISE FND_API.G_EXC_ERROR;
5657: END IF;
5658: HZ_MATCH_RULE_40.get_score_details(
5659: p_rule_id,
5660: p_party_id, p_party_search_rec,p_party_site_list,
5661: p_contact_list, p_contact_point_list,x_search_ctx_id);
5662: -- Code for Match rule SAMPLE: SEARCH SIMILAR PERSON EXACT

Line 5664: IF NOT HZ_MATCH_RULE_41.check_staged THEN

5660: p_party_id, p_party_search_rec,p_party_site_list,
5661: p_contact_list, p_contact_point_list,x_search_ctx_id);
5662: -- Code for Match rule SAMPLE: SEARCH SIMILAR PERSON EXACT
5663: ELSIF p_rule_id=41 THEN
5664: IF NOT HZ_MATCH_RULE_41.check_staged THEN
5665: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5666: FND_MSG_PUB.ADD;
5667: RAISE FND_API.G_EXC_ERROR;
5668: END IF;

Line 5669: HZ_MATCH_RULE_41.get_score_details(

5665: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5666: FND_MSG_PUB.ADD;
5667: RAISE FND_API.G_EXC_ERROR;
5668: END IF;
5669: HZ_MATCH_RULE_41.get_score_details(
5670: p_rule_id,
5671: p_party_id, p_party_search_rec,p_party_site_list,
5672: p_contact_list, p_contact_point_list,x_search_ctx_id);
5673: -- Code for Match rule SAMPLE: SEARCH EXACT

Line 5675: IF NOT HZ_MATCH_RULE_42.check_staged THEN

5671: p_party_id, p_party_search_rec,p_party_site_list,
5672: p_contact_list, p_contact_point_list,x_search_ctx_id);
5673: -- Code for Match rule SAMPLE: SEARCH EXACT
5674: ELSIF p_rule_id=42 THEN
5675: IF NOT HZ_MATCH_RULE_42.check_staged THEN
5676: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5677: FND_MSG_PUB.ADD;
5678: RAISE FND_API.G_EXC_ERROR;
5679: END IF;

Line 5680: HZ_MATCH_RULE_42.get_score_details(

5676: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5677: FND_MSG_PUB.ADD;
5678: RAISE FND_API.G_EXC_ERROR;
5679: END IF;
5680: HZ_MATCH_RULE_42.get_score_details(
5681: p_rule_id,
5682: p_party_id, p_party_search_rec,p_party_site_list,
5683: p_contact_list, p_contact_point_list,x_search_ctx_id);
5684: -- Code for Match rule DL SYSTEM DUPLICATE IDENTIFICATION

Line 5686: IF NOT HZ_MATCH_RULE_48.check_staged THEN

5682: p_party_id, p_party_search_rec,p_party_site_list,
5683: p_contact_list, p_contact_point_list,x_search_ctx_id);
5684: -- Code for Match rule DL SYSTEM DUPLICATE IDENTIFICATION
5685: ELSIF p_rule_id=48 THEN
5686: IF NOT HZ_MATCH_RULE_48.check_staged THEN
5687: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5688: FND_MSG_PUB.ADD;
5689: RAISE FND_API.G_EXC_ERROR;
5690: END IF;

Line 5691: HZ_MATCH_RULE_48.get_score_details(

5687: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5688: FND_MSG_PUB.ADD;
5689: RAISE FND_API.G_EXC_ERROR;
5690: END IF;
5691: HZ_MATCH_RULE_48.get_score_details(
5692: p_rule_id,
5693: p_party_id, p_party_search_rec,p_party_site_list,
5694: p_contact_list, p_contact_point_list,x_search_ctx_id);
5695: -- Code for Match rule BULK MATCH: IDENTICAL ORGANIZATIONS

Line 5906: IF NOT HZ_MATCH_RULE_4.check_staged THEN

5902: p_party_id, x_party_search_rec,x_party_site_list,
5903: x_contact_list, x_contact_point_list);
5904: -- Code for Match rule SAMPLE: ADDRESS_ORGANIZATIONS
5905: ELSIF p_rule_id=4 THEN
5906: IF NOT HZ_MATCH_RULE_4.check_staged THEN
5907: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5908: FND_MSG_PUB.ADD;
5909: RAISE FND_API.G_EXC_ERROR;
5910: END IF;

Line 5911: HZ_MATCH_RULE_4.get_party_for_search(

5907: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5908: FND_MSG_PUB.ADD;
5909: RAISE FND_API.G_EXC_ERROR;
5910: END IF;
5911: HZ_MATCH_RULE_4.get_party_for_search(
5912: p_party_id, x_party_search_rec,x_party_site_list,
5913: x_contact_list, x_contact_point_list);
5914: -- Code for Match rule SAMPLE: ADDRESS_PERSONS
5915: ELSIF p_rule_id=5 THEN

Line 6036: IF NOT HZ_MATCH_RULE_40.check_staged THEN

6032: p_party_id, x_party_search_rec,x_party_site_list,
6033: x_contact_list, x_contact_point_list);
6034: -- Code for Match rule SAMPLE: SEARCH SIMILAR ORGANIZATION EXACT
6035: ELSIF p_rule_id=40 THEN
6036: IF NOT HZ_MATCH_RULE_40.check_staged THEN
6037: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6038: FND_MSG_PUB.ADD;
6039: RAISE FND_API.G_EXC_ERROR;
6040: END IF;

Line 6041: HZ_MATCH_RULE_40.get_party_for_search(

6037: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6038: FND_MSG_PUB.ADD;
6039: RAISE FND_API.G_EXC_ERROR;
6040: END IF;
6041: HZ_MATCH_RULE_40.get_party_for_search(
6042: p_party_id, x_party_search_rec,x_party_site_list,
6043: x_contact_list, x_contact_point_list);
6044: -- Code for Match rule SAMPLE: SEARCH SIMILAR PERSON EXACT
6045: ELSIF p_rule_id=41 THEN

Line 6046: IF NOT HZ_MATCH_RULE_41.check_staged THEN

6042: p_party_id, x_party_search_rec,x_party_site_list,
6043: x_contact_list, x_contact_point_list);
6044: -- Code for Match rule SAMPLE: SEARCH SIMILAR PERSON EXACT
6045: ELSIF p_rule_id=41 THEN
6046: IF NOT HZ_MATCH_RULE_41.check_staged THEN
6047: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6048: FND_MSG_PUB.ADD;
6049: RAISE FND_API.G_EXC_ERROR;
6050: END IF;

Line 6051: HZ_MATCH_RULE_41.get_party_for_search(

6047: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6048: FND_MSG_PUB.ADD;
6049: RAISE FND_API.G_EXC_ERROR;
6050: END IF;
6051: HZ_MATCH_RULE_41.get_party_for_search(
6052: p_party_id, x_party_search_rec,x_party_site_list,
6053: x_contact_list, x_contact_point_list);
6054: -- Code for Match rule SAMPLE: SEARCH EXACT
6055: ELSIF p_rule_id=42 THEN

Line 6056: IF NOT HZ_MATCH_RULE_42.check_staged THEN

6052: p_party_id, x_party_search_rec,x_party_site_list,
6053: x_contact_list, x_contact_point_list);
6054: -- Code for Match rule SAMPLE: SEARCH EXACT
6055: ELSIF p_rule_id=42 THEN
6056: IF NOT HZ_MATCH_RULE_42.check_staged THEN
6057: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6058: FND_MSG_PUB.ADD;
6059: RAISE FND_API.G_EXC_ERROR;
6060: END IF;

Line 6061: HZ_MATCH_RULE_42.get_party_for_search(

6057: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6058: FND_MSG_PUB.ADD;
6059: RAISE FND_API.G_EXC_ERROR;
6060: END IF;
6061: HZ_MATCH_RULE_42.get_party_for_search(
6062: p_party_id, x_party_search_rec,x_party_site_list,
6063: x_contact_list, x_contact_point_list);
6064: -- Code for Match rule DL SYSTEM DUPLICATE IDENTIFICATION
6065: ELSIF p_rule_id=48 THEN

Line 6066: IF NOT HZ_MATCH_RULE_48.check_staged THEN

6062: p_party_id, x_party_search_rec,x_party_site_list,
6063: x_contact_list, x_contact_point_list);
6064: -- Code for Match rule DL SYSTEM DUPLICATE IDENTIFICATION
6065: ELSIF p_rule_id=48 THEN
6066: IF NOT HZ_MATCH_RULE_48.check_staged THEN
6067: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6068: FND_MSG_PUB.ADD;
6069: RAISE FND_API.G_EXC_ERROR;
6070: END IF;

Line 6071: HZ_MATCH_RULE_48.get_party_for_search(

6067: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6068: FND_MSG_PUB.ADD;
6069: RAISE FND_API.G_EXC_ERROR;
6070: END IF;
6071: HZ_MATCH_RULE_48.get_party_for_search(
6072: p_party_id, x_party_search_rec,x_party_site_list,
6073: x_contact_list, x_contact_point_list);
6074: -- Code for Match rule BULK MATCH: IDENTICAL ORGANIZATIONS
6075: ELSIF p_rule_id=50 THEN

Line 6278: IF NOT HZ_MATCH_RULE_4.check_staged THEN

6274: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6275: x_contact_list, x_contact_point_list);
6276: -- Code for Match rule SAMPLE: ADDRESS_ORGANIZATIONS
6277: ELSIF p_rule_id=4 THEN
6278: IF NOT HZ_MATCH_RULE_4.check_staged THEN
6279: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6280: FND_MSG_PUB.ADD;
6281: RAISE FND_API.G_EXC_ERROR;
6282: END IF;

Line 6283: HZ_MATCH_RULE_4.get_search_criteria(

6279: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6280: FND_MSG_PUB.ADD;
6281: RAISE FND_API.G_EXC_ERROR;
6282: END IF;
6283: HZ_MATCH_RULE_4.get_search_criteria(
6284: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6285: x_contact_list, x_contact_point_list);
6286: -- Code for Match rule SAMPLE: ADDRESS_PERSONS
6287: ELSIF p_rule_id=5 THEN

Line 6408: IF NOT HZ_MATCH_RULE_40.check_staged THEN

6404: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6405: x_contact_list, x_contact_point_list);
6406: -- Code for Match rule SAMPLE: SEARCH SIMILAR ORGANIZATION EXACT
6407: ELSIF p_rule_id=40 THEN
6408: IF NOT HZ_MATCH_RULE_40.check_staged THEN
6409: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6410: FND_MSG_PUB.ADD;
6411: RAISE FND_API.G_EXC_ERROR;
6412: END IF;

Line 6413: HZ_MATCH_RULE_40.get_search_criteria(

6409: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6410: FND_MSG_PUB.ADD;
6411: RAISE FND_API.G_EXC_ERROR;
6412: END IF;
6413: HZ_MATCH_RULE_40.get_search_criteria(
6414: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6415: x_contact_list, x_contact_point_list);
6416: -- Code for Match rule SAMPLE: SEARCH SIMILAR PERSON EXACT
6417: ELSIF p_rule_id=41 THEN

Line 6418: IF NOT HZ_MATCH_RULE_41.check_staged THEN

6414: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6415: x_contact_list, x_contact_point_list);
6416: -- Code for Match rule SAMPLE: SEARCH SIMILAR PERSON EXACT
6417: ELSIF p_rule_id=41 THEN
6418: IF NOT HZ_MATCH_RULE_41.check_staged THEN
6419: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6420: FND_MSG_PUB.ADD;
6421: RAISE FND_API.G_EXC_ERROR;
6422: END IF;

Line 6423: HZ_MATCH_RULE_41.get_search_criteria(

6419: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6420: FND_MSG_PUB.ADD;
6421: RAISE FND_API.G_EXC_ERROR;
6422: END IF;
6423: HZ_MATCH_RULE_41.get_search_criteria(
6424: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6425: x_contact_list, x_contact_point_list);
6426: -- Code for Match rule SAMPLE: SEARCH EXACT
6427: ELSIF p_rule_id=42 THEN

Line 6428: IF NOT HZ_MATCH_RULE_42.check_staged THEN

6424: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6425: x_contact_list, x_contact_point_list);
6426: -- Code for Match rule SAMPLE: SEARCH EXACT
6427: ELSIF p_rule_id=42 THEN
6428: IF NOT HZ_MATCH_RULE_42.check_staged THEN
6429: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6430: FND_MSG_PUB.ADD;
6431: RAISE FND_API.G_EXC_ERROR;
6432: END IF;

Line 6433: HZ_MATCH_RULE_42.get_search_criteria(

6429: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6430: FND_MSG_PUB.ADD;
6431: RAISE FND_API.G_EXC_ERROR;
6432: END IF;
6433: HZ_MATCH_RULE_42.get_search_criteria(
6434: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6435: x_contact_list, x_contact_point_list);
6436: -- Code for Match rule DL SYSTEM DUPLICATE IDENTIFICATION
6437: ELSIF p_rule_id=48 THEN

Line 6438: IF NOT HZ_MATCH_RULE_48.check_staged THEN

6434: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6435: x_contact_list, x_contact_point_list);
6436: -- Code for Match rule DL SYSTEM DUPLICATE IDENTIFICATION
6437: ELSIF p_rule_id=48 THEN
6438: IF NOT HZ_MATCH_RULE_48.check_staged THEN
6439: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6440: FND_MSG_PUB.ADD;
6441: RAISE FND_API.G_EXC_ERROR;
6442: END IF;

Line 6443: HZ_MATCH_RULE_48.get_search_criteria(

6439: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6440: FND_MSG_PUB.ADD;
6441: RAISE FND_API.G_EXC_ERROR;
6442: END IF;
6443: HZ_MATCH_RULE_48.get_search_criteria(
6444: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6445: x_contact_list, x_contact_point_list);
6446: -- Code for Match rule BULK MATCH: IDENTICAL ORGANIZATIONS
6447: ELSIF p_rule_id=50 THEN