APPS.HZ_PARTY_SEARCH dependencies on HZ_MATCH_RULE_5

Line 140: IF NOT HZ_MATCH_RULE_5.check_staged THEN

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
140: IF NOT HZ_MATCH_RULE_5.check_staged THEN
141: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
142: FND_MSG_PUB.ADD;
143: RAISE FND_API.G_EXC_ERROR;
144: END IF;

Line 145: HZ_MATCH_RULE_5.find_parties(

141: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
142: FND_MSG_PUB.ADD;
143: RAISE FND_API.G_EXC_ERROR;
144: END IF;
145: HZ_MATCH_RULE_5.find_parties(
146: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
147: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,NULL,NULL,NULL,'N',x_search_ctx_id,x_num_matches);
148: -- Code for Match rule SAMPLE: SIMILAR_ORGANIZATION
149: ELSIF p_rule_id=6 THEN

Line 300: IF NOT HZ_MATCH_RULE_50.check_staged THEN

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
300: IF NOT HZ_MATCH_RULE_50.check_staged THEN
301: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
302: FND_MSG_PUB.ADD;
303: RAISE FND_API.G_EXC_ERROR;
304: END IF;

Line 305: HZ_MATCH_RULE_50.find_parties(

301: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
302: FND_MSG_PUB.ADD;
303: RAISE FND_API.G_EXC_ERROR;
304: END IF;
305: HZ_MATCH_RULE_50.find_parties(
306: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
307: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,NULL,NULL,NULL,'N',x_search_ctx_id,x_num_matches);
308: -- Code for Match rule BULK MATCH: IDENTICAL PERSONS
309: ELSIF p_rule_id=51 THEN

Line 310: IF NOT HZ_MATCH_RULE_51.check_staged THEN

306: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
307: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,NULL,NULL,NULL,'N',x_search_ctx_id,x_num_matches);
308: -- Code for Match rule BULK MATCH: IDENTICAL PERSONS
309: ELSIF p_rule_id=51 THEN
310: IF NOT HZ_MATCH_RULE_51.check_staged THEN
311: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
312: FND_MSG_PUB.ADD;
313: RAISE FND_API.G_EXC_ERROR;
314: END IF;

Line 315: HZ_MATCH_RULE_51.find_parties(

311: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
312: FND_MSG_PUB.ADD;
313: RAISE FND_API.G_EXC_ERROR;
314: END IF;
315: HZ_MATCH_RULE_51.find_parties(
316: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
317: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,NULL,NULL,NULL,'N',x_search_ctx_id,x_num_matches);
318: -- Code for Match rule BULK MATCH: IDENTICAL PARTIES
319: ELSIF p_rule_id=52 THEN

Line 320: IF NOT HZ_MATCH_RULE_52.check_staged THEN

316: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
317: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,NULL,NULL,NULL,'N',x_search_ctx_id,x_num_matches);
318: -- Code for Match rule BULK MATCH: IDENTICAL PARTIES
319: ELSIF p_rule_id=52 THEN
320: IF NOT HZ_MATCH_RULE_52.check_staged THEN
321: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
322: FND_MSG_PUB.ADD;
323: RAISE FND_API.G_EXC_ERROR;
324: END IF;

Line 325: HZ_MATCH_RULE_52.find_parties(

321: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
322: FND_MSG_PUB.ADD;
323: RAISE FND_API.G_EXC_ERROR;
324: END IF;
325: HZ_MATCH_RULE_52.find_parties(
326: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
327: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,NULL,NULL,NULL,'N',x_search_ctx_id,x_num_matches);
328: -- Code for Match rule CREDIT MANAGEMENT SEARCH
329: ELSIF p_rule_id=53 THEN

Line 330: IF NOT HZ_MATCH_RULE_53.check_staged THEN

326: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
327: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,NULL,NULL,NULL,'N',x_search_ctx_id,x_num_matches);
328: -- Code for Match rule CREDIT MANAGEMENT SEARCH
329: ELSIF p_rule_id=53 THEN
330: IF NOT HZ_MATCH_RULE_53.check_staged THEN
331: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
332: FND_MSG_PUB.ADD;
333: RAISE FND_API.G_EXC_ERROR;
334: END IF;

Line 335: HZ_MATCH_RULE_53.find_parties(

331: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
332: FND_MSG_PUB.ADD;
333: RAISE FND_API.G_EXC_ERROR;
334: END IF;
335: HZ_MATCH_RULE_53.find_parties(
336: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
337: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,NULL,NULL,NULL,'N',x_search_ctx_id,x_num_matches);
338: -- Code for Match rule HZ_PERSON_SIMPLE_SEARCH_RULE
339: ELSIF p_rule_id=58 THEN

Line 340: IF NOT HZ_MATCH_RULE_58.check_staged THEN

336: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
337: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,NULL,NULL,NULL,'N',x_search_ctx_id,x_num_matches);
338: -- Code for Match rule HZ_PERSON_SIMPLE_SEARCH_RULE
339: ELSIF p_rule_id=58 THEN
340: IF NOT HZ_MATCH_RULE_58.check_staged THEN
341: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
342: FND_MSG_PUB.ADD;
343: RAISE FND_API.G_EXC_ERROR;
344: END IF;

Line 345: HZ_MATCH_RULE_58.find_parties(

341: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
342: FND_MSG_PUB.ADD;
343: RAISE FND_API.G_EXC_ERROR;
344: END IF;
345: HZ_MATCH_RULE_58.find_parties(
346: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
347: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,NULL,NULL,NULL,'N',x_search_ctx_id,x_num_matches);
348: -- Code for Match rule HZ_PERSON_ADVANCED_SEARCH_MATCH_RULE
349: ELSIF p_rule_id=60 THEN

Line 541: IF NOT HZ_MATCH_RULE_5.check_staged THEN

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
541: IF NOT HZ_MATCH_RULE_5.check_staged THEN
542: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
543: FND_MSG_PUB.ADD;
544: RAISE FND_API.G_EXC_ERROR;
545: END IF;

Line 546: HZ_MATCH_RULE_5.find_persons(

542: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
543: FND_MSG_PUB.ADD;
544: RAISE FND_API.G_EXC_ERROR;
545: END IF;
546: HZ_MATCH_RULE_5.find_persons(
547: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
548: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,'N',x_search_ctx_id,x_num_matches);
549: -- Code for Match rule SAMPLE: SIMILAR_ORGANIZATION
550: ELSIF p_rule_id=6 THEN

Line 701: IF NOT HZ_MATCH_RULE_50.check_staged THEN

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
701: IF NOT HZ_MATCH_RULE_50.check_staged THEN
702: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
703: FND_MSG_PUB.ADD;
704: RAISE FND_API.G_EXC_ERROR;
705: END IF;

Line 706: HZ_MATCH_RULE_50.find_persons(

702: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
703: FND_MSG_PUB.ADD;
704: RAISE FND_API.G_EXC_ERROR;
705: END IF;
706: HZ_MATCH_RULE_50.find_persons(
707: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
708: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,'N',x_search_ctx_id,x_num_matches);
709: -- Code for Match rule BULK MATCH: IDENTICAL PERSONS
710: ELSIF p_rule_id=51 THEN

Line 711: IF NOT HZ_MATCH_RULE_51.check_staged THEN

707: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
708: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,'N',x_search_ctx_id,x_num_matches);
709: -- Code for Match rule BULK MATCH: IDENTICAL PERSONS
710: ELSIF p_rule_id=51 THEN
711: IF NOT HZ_MATCH_RULE_51.check_staged THEN
712: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
713: FND_MSG_PUB.ADD;
714: RAISE FND_API.G_EXC_ERROR;
715: END IF;

Line 716: HZ_MATCH_RULE_51.find_persons(

712: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
713: FND_MSG_PUB.ADD;
714: RAISE FND_API.G_EXC_ERROR;
715: END IF;
716: HZ_MATCH_RULE_51.find_persons(
717: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
718: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,'N',x_search_ctx_id,x_num_matches);
719: -- Code for Match rule BULK MATCH: IDENTICAL PARTIES
720: ELSIF p_rule_id=52 THEN

Line 721: IF NOT HZ_MATCH_RULE_52.check_staged THEN

717: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
718: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,'N',x_search_ctx_id,x_num_matches);
719: -- Code for Match rule BULK MATCH: IDENTICAL PARTIES
720: ELSIF p_rule_id=52 THEN
721: IF NOT HZ_MATCH_RULE_52.check_staged THEN
722: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
723: FND_MSG_PUB.ADD;
724: RAISE FND_API.G_EXC_ERROR;
725: END IF;

Line 726: HZ_MATCH_RULE_52.find_persons(

722: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
723: FND_MSG_PUB.ADD;
724: RAISE FND_API.G_EXC_ERROR;
725: END IF;
726: HZ_MATCH_RULE_52.find_persons(
727: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
728: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,'N',x_search_ctx_id,x_num_matches);
729: -- Code for Match rule CREDIT MANAGEMENT SEARCH
730: ELSIF p_rule_id=53 THEN

Line 731: IF NOT HZ_MATCH_RULE_53.check_staged THEN

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

Line 736: HZ_MATCH_RULE_53.find_persons(

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

Line 741: IF NOT HZ_MATCH_RULE_58.check_staged THEN

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

Line 746: HZ_MATCH_RULE_58.find_persons(

742: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
743: FND_MSG_PUB.ADD;
744: RAISE FND_API.G_EXC_ERROR;
745: END IF;
746: HZ_MATCH_RULE_58.find_persons(
747: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
748: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,'N',x_search_ctx_id,x_num_matches);
749: -- Code for Match rule HZ_PERSON_ADVANCED_SEARCH_MATCH_RULE
750: ELSIF p_rule_id=60 THEN

Line 960: IF NOT HZ_MATCH_RULE_5.check_staged THEN

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
960: IF NOT HZ_MATCH_RULE_5.check_staged THEN
961: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
962: FND_MSG_PUB.ADD;
963: RAISE FND_API.G_EXC_ERROR;
964: END IF;

Line 965: HZ_MATCH_RULE_5.find_party_details(

961: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
962: FND_MSG_PUB.ADD;
963: RAISE FND_API.G_EXC_ERROR;
964: END IF;
965: HZ_MATCH_RULE_5.find_party_details(
966: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
967: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
968: -- Code for Match rule SAMPLE: SIMILAR_ORGANIZATION
969: ELSIF p_rule_id=6 THEN

Line 1120: IF NOT HZ_MATCH_RULE_50.check_staged THEN

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
1120: IF NOT HZ_MATCH_RULE_50.check_staged THEN
1121: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1122: FND_MSG_PUB.ADD;
1123: RAISE FND_API.G_EXC_ERROR;
1124: END IF;

Line 1125: HZ_MATCH_RULE_50.find_party_details(

1121: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1122: FND_MSG_PUB.ADD;
1123: RAISE FND_API.G_EXC_ERROR;
1124: END IF;
1125: HZ_MATCH_RULE_50.find_party_details(
1126: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
1127: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
1128: -- Code for Match rule BULK MATCH: IDENTICAL PERSONS
1129: ELSIF p_rule_id=51 THEN

Line 1130: IF NOT HZ_MATCH_RULE_51.check_staged THEN

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

Line 1135: HZ_MATCH_RULE_51.find_party_details(

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

Line 1140: IF NOT HZ_MATCH_RULE_52.check_staged THEN

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

Line 1145: HZ_MATCH_RULE_52.find_party_details(

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

Line 1150: IF NOT HZ_MATCH_RULE_53.check_staged THEN

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

Line 1155: HZ_MATCH_RULE_53.find_party_details(

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

Line 1160: IF NOT HZ_MATCH_RULE_58.check_staged THEN

1156: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
1157: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
1158: -- Code for Match rule HZ_PERSON_SIMPLE_SEARCH_RULE
1159: ELSIF p_rule_id=58 THEN
1160: IF NOT HZ_MATCH_RULE_58.check_staged THEN
1161: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1162: FND_MSG_PUB.ADD;
1163: RAISE FND_API.G_EXC_ERROR;
1164: END IF;

Line 1165: HZ_MATCH_RULE_58.find_party_details(

1161: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1162: FND_MSG_PUB.ADD;
1163: RAISE FND_API.G_EXC_ERROR;
1164: END IF;
1165: HZ_MATCH_RULE_58.find_party_details(
1166: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
1167: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
1168: -- Code for Match rule HZ_PERSON_ADVANCED_SEARCH_MATCH_RULE
1169: ELSIF p_rule_id=60 THEN

Line 1360: IF NOT HZ_MATCH_RULE_5.check_staged THEN

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
1360: IF NOT HZ_MATCH_RULE_5.check_staged THEN
1361: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1362: FND_MSG_PUB.ADD;
1363: RAISE FND_API.G_EXC_ERROR;
1364: END IF;

Line 1365: HZ_MATCH_RULE_5.find_duplicate_parties(

1361: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1362: FND_MSG_PUB.ADD;
1363: RAISE FND_API.G_EXC_ERROR;
1364: END IF;
1365: HZ_MATCH_RULE_5.find_duplicate_parties(
1366: p_rule_id,p_party_id,
1367: p_restrict_sql,p_match_type,p_dup_batch_id,p_search_merged,x_dup_set_id, x_search_ctx_id,x_num_matches);
1368: -- Code for Match rule SAMPLE: SIMILAR_ORGANIZATION
1369: ELSIF p_rule_id=6 THEN

Line 1520: IF NOT HZ_MATCH_RULE_50.check_staged THEN

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

Line 1525: HZ_MATCH_RULE_50.find_duplicate_parties(

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

Line 1530: IF NOT HZ_MATCH_RULE_51.check_staged THEN

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

Line 1535: HZ_MATCH_RULE_51.find_duplicate_parties(

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

Line 1540: IF NOT HZ_MATCH_RULE_52.check_staged THEN

1536: p_rule_id,p_party_id,
1537: p_restrict_sql,p_match_type,p_dup_batch_id,p_search_merged,x_dup_set_id, x_search_ctx_id,x_num_matches);
1538: -- Code for Match rule BULK MATCH: IDENTICAL PARTIES
1539: ELSIF p_rule_id=52 THEN
1540: IF NOT HZ_MATCH_RULE_52.check_staged THEN
1541: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1542: FND_MSG_PUB.ADD;
1543: RAISE FND_API.G_EXC_ERROR;
1544: END IF;

Line 1545: HZ_MATCH_RULE_52.find_duplicate_parties(

1541: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1542: FND_MSG_PUB.ADD;
1543: RAISE FND_API.G_EXC_ERROR;
1544: END IF;
1545: HZ_MATCH_RULE_52.find_duplicate_parties(
1546: p_rule_id,p_party_id,
1547: p_restrict_sql,p_match_type,p_dup_batch_id,p_search_merged,x_dup_set_id, x_search_ctx_id,x_num_matches);
1548: -- Code for Match rule CREDIT MANAGEMENT SEARCH
1549: ELSIF p_rule_id=53 THEN

Line 1550: IF NOT HZ_MATCH_RULE_53.check_staged THEN

1546: p_rule_id,p_party_id,
1547: p_restrict_sql,p_match_type,p_dup_batch_id,p_search_merged,x_dup_set_id, x_search_ctx_id,x_num_matches);
1548: -- Code for Match rule CREDIT MANAGEMENT SEARCH
1549: ELSIF p_rule_id=53 THEN
1550: IF NOT HZ_MATCH_RULE_53.check_staged THEN
1551: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1552: FND_MSG_PUB.ADD;
1553: RAISE FND_API.G_EXC_ERROR;
1554: END IF;

Line 1555: HZ_MATCH_RULE_53.find_duplicate_parties(

1551: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1552: FND_MSG_PUB.ADD;
1553: RAISE FND_API.G_EXC_ERROR;
1554: END IF;
1555: HZ_MATCH_RULE_53.find_duplicate_parties(
1556: p_rule_id,p_party_id,
1557: p_restrict_sql,p_match_type,p_dup_batch_id,p_search_merged,x_dup_set_id, x_search_ctx_id,x_num_matches);
1558: -- Code for Match rule HZ_PERSON_SIMPLE_SEARCH_RULE
1559: ELSIF p_rule_id=58 THEN

Line 1560: IF NOT HZ_MATCH_RULE_58.check_staged THEN

1556: p_rule_id,p_party_id,
1557: p_restrict_sql,p_match_type,p_dup_batch_id,p_search_merged,x_dup_set_id, x_search_ctx_id,x_num_matches);
1558: -- Code for Match rule HZ_PERSON_SIMPLE_SEARCH_RULE
1559: ELSIF p_rule_id=58 THEN
1560: IF NOT HZ_MATCH_RULE_58.check_staged THEN
1561: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1562: FND_MSG_PUB.ADD;
1563: RAISE FND_API.G_EXC_ERROR;
1564: END IF;

Line 1565: HZ_MATCH_RULE_58.find_duplicate_parties(

1561: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1562: FND_MSG_PUB.ADD;
1563: RAISE FND_API.G_EXC_ERROR;
1564: END IF;
1565: HZ_MATCH_RULE_58.find_duplicate_parties(
1566: p_rule_id,p_party_id,
1567: p_restrict_sql,p_match_type,p_dup_batch_id,p_search_merged,x_dup_set_id, x_search_ctx_id,x_num_matches);
1568: -- Code for Match rule HZ_PERSON_ADVANCED_SEARCH_MATCH_RULE
1569: ELSIF p_rule_id=60 THEN

Line 1755: IF NOT HZ_MATCH_RULE_5.check_staged THEN

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
1755: IF NOT HZ_MATCH_RULE_5.check_staged THEN
1756: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1757: FND_MSG_PUB.ADD;
1758: RAISE FND_API.G_EXC_ERROR;
1759: END IF;

Line 1760: HZ_MATCH_RULE_5.find_duplicate_party_sites(

1756: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1757: FND_MSG_PUB.ADD;
1758: RAISE FND_API.G_EXC_ERROR;
1759: END IF;
1760: HZ_MATCH_RULE_5.find_duplicate_party_sites(
1761: p_rule_id,p_party_site_id,p_party_id,
1762: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
1763: -- Code for Match rule SAMPLE: SIMILAR_ORGANIZATION
1764: ELSIF p_rule_id=6 THEN

Line 1915: IF NOT HZ_MATCH_RULE_50.check_staged THEN

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
1915: IF NOT HZ_MATCH_RULE_50.check_staged THEN
1916: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1917: FND_MSG_PUB.ADD;
1918: RAISE FND_API.G_EXC_ERROR;
1919: END IF;

Line 1920: HZ_MATCH_RULE_50.find_duplicate_party_sites(

1916: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1917: FND_MSG_PUB.ADD;
1918: RAISE FND_API.G_EXC_ERROR;
1919: END IF;
1920: HZ_MATCH_RULE_50.find_duplicate_party_sites(
1921: p_rule_id,p_party_site_id,p_party_id,
1922: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
1923: -- Code for Match rule BULK MATCH: IDENTICAL PERSONS
1924: ELSIF p_rule_id=51 THEN

Line 1925: IF NOT HZ_MATCH_RULE_51.check_staged THEN

1921: p_rule_id,p_party_site_id,p_party_id,
1922: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
1923: -- Code for Match rule BULK MATCH: IDENTICAL PERSONS
1924: ELSIF p_rule_id=51 THEN
1925: IF NOT HZ_MATCH_RULE_51.check_staged THEN
1926: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1927: FND_MSG_PUB.ADD;
1928: RAISE FND_API.G_EXC_ERROR;
1929: END IF;

Line 1930: HZ_MATCH_RULE_51.find_duplicate_party_sites(

1926: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1927: FND_MSG_PUB.ADD;
1928: RAISE FND_API.G_EXC_ERROR;
1929: END IF;
1930: HZ_MATCH_RULE_51.find_duplicate_party_sites(
1931: p_rule_id,p_party_site_id,p_party_id,
1932: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
1933: -- Code for Match rule BULK MATCH: IDENTICAL PARTIES
1934: ELSIF p_rule_id=52 THEN

Line 1935: IF NOT HZ_MATCH_RULE_52.check_staged THEN

1931: p_rule_id,p_party_site_id,p_party_id,
1932: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
1933: -- Code for Match rule BULK MATCH: IDENTICAL PARTIES
1934: ELSIF p_rule_id=52 THEN
1935: IF NOT HZ_MATCH_RULE_52.check_staged THEN
1936: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1937: FND_MSG_PUB.ADD;
1938: RAISE FND_API.G_EXC_ERROR;
1939: END IF;

Line 1940: HZ_MATCH_RULE_52.find_duplicate_party_sites(

1936: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1937: FND_MSG_PUB.ADD;
1938: RAISE FND_API.G_EXC_ERROR;
1939: END IF;
1940: HZ_MATCH_RULE_52.find_duplicate_party_sites(
1941: p_rule_id,p_party_site_id,p_party_id,
1942: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
1943: -- Code for Match rule CREDIT MANAGEMENT SEARCH
1944: ELSIF p_rule_id=53 THEN

Line 1945: IF NOT HZ_MATCH_RULE_53.check_staged THEN

1941: p_rule_id,p_party_site_id,p_party_id,
1942: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
1943: -- Code for Match rule CREDIT MANAGEMENT SEARCH
1944: ELSIF p_rule_id=53 THEN
1945: IF NOT HZ_MATCH_RULE_53.check_staged THEN
1946: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1947: FND_MSG_PUB.ADD;
1948: RAISE FND_API.G_EXC_ERROR;
1949: END IF;

Line 1950: HZ_MATCH_RULE_53.find_duplicate_party_sites(

1946: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1947: FND_MSG_PUB.ADD;
1948: RAISE FND_API.G_EXC_ERROR;
1949: END IF;
1950: HZ_MATCH_RULE_53.find_duplicate_party_sites(
1951: p_rule_id,p_party_site_id,p_party_id,
1952: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
1953: -- Code for Match rule HZ_PERSON_SIMPLE_SEARCH_RULE
1954: ELSIF p_rule_id=58 THEN

Line 1955: IF NOT HZ_MATCH_RULE_58.check_staged THEN

1951: p_rule_id,p_party_site_id,p_party_id,
1952: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
1953: -- Code for Match rule HZ_PERSON_SIMPLE_SEARCH_RULE
1954: ELSIF p_rule_id=58 THEN
1955: IF NOT HZ_MATCH_RULE_58.check_staged THEN
1956: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1957: FND_MSG_PUB.ADD;
1958: RAISE FND_API.G_EXC_ERROR;
1959: END IF;

Line 1960: HZ_MATCH_RULE_58.find_duplicate_party_sites(

1956: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1957: FND_MSG_PUB.ADD;
1958: RAISE FND_API.G_EXC_ERROR;
1959: END IF;
1960: HZ_MATCH_RULE_58.find_duplicate_party_sites(
1961: p_rule_id,p_party_site_id,p_party_id,
1962: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
1963: -- Code for Match rule HZ_PERSON_ADVANCED_SEARCH_MATCH_RULE
1964: ELSIF p_rule_id=60 THEN

Line 2149: IF NOT HZ_MATCH_RULE_5.check_staged THEN

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
2149: IF NOT HZ_MATCH_RULE_5.check_staged THEN
2150: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2151: FND_MSG_PUB.ADD;
2152: RAISE FND_API.G_EXC_ERROR;
2153: END IF;

Line 2154: HZ_MATCH_RULE_5.find_duplicate_contacts(

2150: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2151: FND_MSG_PUB.ADD;
2152: RAISE FND_API.G_EXC_ERROR;
2153: END IF;
2154: HZ_MATCH_RULE_5.find_duplicate_contacts(
2155: p_rule_id,p_org_contact_id,p_party_id,
2156: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2157: -- Code for Match rule SAMPLE: SIMILAR_ORGANIZATION
2158: ELSIF p_rule_id=6 THEN

Line 2309: IF NOT HZ_MATCH_RULE_50.check_staged THEN

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
2309: IF NOT HZ_MATCH_RULE_50.check_staged THEN
2310: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2311: FND_MSG_PUB.ADD;
2312: RAISE FND_API.G_EXC_ERROR;
2313: END IF;

Line 2314: HZ_MATCH_RULE_50.find_duplicate_contacts(

2310: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2311: FND_MSG_PUB.ADD;
2312: RAISE FND_API.G_EXC_ERROR;
2313: END IF;
2314: HZ_MATCH_RULE_50.find_duplicate_contacts(
2315: p_rule_id,p_org_contact_id,p_party_id,
2316: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2317: -- Code for Match rule BULK MATCH: IDENTICAL PERSONS
2318: ELSIF p_rule_id=51 THEN

Line 2319: IF NOT HZ_MATCH_RULE_51.check_staged THEN

2315: p_rule_id,p_org_contact_id,p_party_id,
2316: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2317: -- Code for Match rule BULK MATCH: IDENTICAL PERSONS
2318: ELSIF p_rule_id=51 THEN
2319: IF NOT HZ_MATCH_RULE_51.check_staged THEN
2320: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2321: FND_MSG_PUB.ADD;
2322: RAISE FND_API.G_EXC_ERROR;
2323: END IF;

Line 2324: HZ_MATCH_RULE_51.find_duplicate_contacts(

2320: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2321: FND_MSG_PUB.ADD;
2322: RAISE FND_API.G_EXC_ERROR;
2323: END IF;
2324: HZ_MATCH_RULE_51.find_duplicate_contacts(
2325: p_rule_id,p_org_contact_id,p_party_id,
2326: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2327: -- Code for Match rule BULK MATCH: IDENTICAL PARTIES
2328: ELSIF p_rule_id=52 THEN

Line 2329: IF NOT HZ_MATCH_RULE_52.check_staged THEN

2325: p_rule_id,p_org_contact_id,p_party_id,
2326: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2327: -- Code for Match rule BULK MATCH: IDENTICAL PARTIES
2328: ELSIF p_rule_id=52 THEN
2329: IF NOT HZ_MATCH_RULE_52.check_staged THEN
2330: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2331: FND_MSG_PUB.ADD;
2332: RAISE FND_API.G_EXC_ERROR;
2333: END IF;

Line 2334: HZ_MATCH_RULE_52.find_duplicate_contacts(

2330: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2331: FND_MSG_PUB.ADD;
2332: RAISE FND_API.G_EXC_ERROR;
2333: END IF;
2334: HZ_MATCH_RULE_52.find_duplicate_contacts(
2335: p_rule_id,p_org_contact_id,p_party_id,
2336: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2337: -- Code for Match rule CREDIT MANAGEMENT SEARCH
2338: ELSIF p_rule_id=53 THEN

Line 2339: IF NOT HZ_MATCH_RULE_53.check_staged THEN

2335: p_rule_id,p_org_contact_id,p_party_id,
2336: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2337: -- Code for Match rule CREDIT MANAGEMENT SEARCH
2338: ELSIF p_rule_id=53 THEN
2339: IF NOT HZ_MATCH_RULE_53.check_staged THEN
2340: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2341: FND_MSG_PUB.ADD;
2342: RAISE FND_API.G_EXC_ERROR;
2343: END IF;

Line 2344: HZ_MATCH_RULE_53.find_duplicate_contacts(

2340: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2341: FND_MSG_PUB.ADD;
2342: RAISE FND_API.G_EXC_ERROR;
2343: END IF;
2344: HZ_MATCH_RULE_53.find_duplicate_contacts(
2345: p_rule_id,p_org_contact_id,p_party_id,
2346: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2347: -- Code for Match rule HZ_PERSON_SIMPLE_SEARCH_RULE
2348: ELSIF p_rule_id=58 THEN

Line 2349: IF NOT HZ_MATCH_RULE_58.check_staged THEN

2345: p_rule_id,p_org_contact_id,p_party_id,
2346: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2347: -- Code for Match rule HZ_PERSON_SIMPLE_SEARCH_RULE
2348: ELSIF p_rule_id=58 THEN
2349: IF NOT HZ_MATCH_RULE_58.check_staged THEN
2350: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2351: FND_MSG_PUB.ADD;
2352: RAISE FND_API.G_EXC_ERROR;
2353: END IF;

Line 2354: HZ_MATCH_RULE_58.find_duplicate_contacts(

2350: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2351: FND_MSG_PUB.ADD;
2352: RAISE FND_API.G_EXC_ERROR;
2353: END IF;
2354: HZ_MATCH_RULE_58.find_duplicate_contacts(
2355: p_rule_id,p_org_contact_id,p_party_id,
2356: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2357: -- Code for Match rule HZ_PERSON_ADVANCED_SEARCH_MATCH_RULE
2358: ELSIF p_rule_id=60 THEN

Line 2543: IF NOT HZ_MATCH_RULE_5.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: ADDRESS_PERSONS
2542: ELSIF p_rule_id=5 THEN
2543: IF NOT HZ_MATCH_RULE_5.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_5.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_5.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: SIMILAR_ORGANIZATION
2552: ELSIF p_rule_id=6 THEN

Line 2703: IF NOT HZ_MATCH_RULE_50.check_staged THEN

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
2703: IF NOT HZ_MATCH_RULE_50.check_staged THEN
2704: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2705: FND_MSG_PUB.ADD;
2706: RAISE FND_API.G_EXC_ERROR;
2707: END IF;

Line 2708: HZ_MATCH_RULE_50.find_duplicate_contact_points(

2704: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2705: FND_MSG_PUB.ADD;
2706: RAISE FND_API.G_EXC_ERROR;
2707: END IF;
2708: HZ_MATCH_RULE_50.find_duplicate_contact_points(
2709: p_rule_id,p_contact_point_id,p_party_id,
2710: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2711: -- Code for Match rule BULK MATCH: IDENTICAL PERSONS
2712: ELSIF p_rule_id=51 THEN

Line 2713: IF NOT HZ_MATCH_RULE_51.check_staged THEN

2709: p_rule_id,p_contact_point_id,p_party_id,
2710: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2711: -- Code for Match rule BULK MATCH: IDENTICAL PERSONS
2712: ELSIF p_rule_id=51 THEN
2713: IF NOT HZ_MATCH_RULE_51.check_staged THEN
2714: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2715: FND_MSG_PUB.ADD;
2716: RAISE FND_API.G_EXC_ERROR;
2717: END IF;

Line 2718: HZ_MATCH_RULE_51.find_duplicate_contact_points(

2714: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2715: FND_MSG_PUB.ADD;
2716: RAISE FND_API.G_EXC_ERROR;
2717: END IF;
2718: HZ_MATCH_RULE_51.find_duplicate_contact_points(
2719: p_rule_id,p_contact_point_id,p_party_id,
2720: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2721: -- Code for Match rule BULK MATCH: IDENTICAL PARTIES
2722: ELSIF p_rule_id=52 THEN

Line 2723: IF NOT HZ_MATCH_RULE_52.check_staged THEN

2719: p_rule_id,p_contact_point_id,p_party_id,
2720: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2721: -- Code for Match rule BULK MATCH: IDENTICAL PARTIES
2722: ELSIF p_rule_id=52 THEN
2723: IF NOT HZ_MATCH_RULE_52.check_staged THEN
2724: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2725: FND_MSG_PUB.ADD;
2726: RAISE FND_API.G_EXC_ERROR;
2727: END IF;

Line 2728: HZ_MATCH_RULE_52.find_duplicate_contact_points(

2724: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2725: FND_MSG_PUB.ADD;
2726: RAISE FND_API.G_EXC_ERROR;
2727: END IF;
2728: HZ_MATCH_RULE_52.find_duplicate_contact_points(
2729: p_rule_id,p_contact_point_id,p_party_id,
2730: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2731: -- Code for Match rule CREDIT MANAGEMENT SEARCH
2732: ELSIF p_rule_id=53 THEN

Line 2733: IF NOT HZ_MATCH_RULE_53.check_staged THEN

2729: p_rule_id,p_contact_point_id,p_party_id,
2730: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2731: -- Code for Match rule CREDIT MANAGEMENT SEARCH
2732: ELSIF p_rule_id=53 THEN
2733: IF NOT HZ_MATCH_RULE_53.check_staged THEN
2734: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2735: FND_MSG_PUB.ADD;
2736: RAISE FND_API.G_EXC_ERROR;
2737: END IF;

Line 2738: HZ_MATCH_RULE_53.find_duplicate_contact_points(

2734: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2735: FND_MSG_PUB.ADD;
2736: RAISE FND_API.G_EXC_ERROR;
2737: END IF;
2738: HZ_MATCH_RULE_53.find_duplicate_contact_points(
2739: p_rule_id,p_contact_point_id,p_party_id,
2740: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2741: -- Code for Match rule HZ_PERSON_SIMPLE_SEARCH_RULE
2742: ELSIF p_rule_id=58 THEN

Line 2743: IF NOT HZ_MATCH_RULE_58.check_staged THEN

2739: p_rule_id,p_contact_point_id,p_party_id,
2740: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2741: -- Code for Match rule HZ_PERSON_SIMPLE_SEARCH_RULE
2742: ELSIF p_rule_id=58 THEN
2743: IF NOT HZ_MATCH_RULE_58.check_staged THEN
2744: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2745: FND_MSG_PUB.ADD;
2746: RAISE FND_API.G_EXC_ERROR;
2747: END IF;

Line 2748: HZ_MATCH_RULE_58.find_duplicate_contact_points(

2744: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2745: FND_MSG_PUB.ADD;
2746: RAISE FND_API.G_EXC_ERROR;
2747: END IF;
2748: HZ_MATCH_RULE_58.find_duplicate_contact_points(
2749: p_rule_id,p_contact_point_id,p_party_id,
2750: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2751: -- Code for Match rule HZ_PERSON_ADVANCED_SEARCH_MATCH_RULE
2752: ELSIF p_rule_id=60 THEN

Line 3001: IF NOT HZ_MATCH_RULE_5.check_staged THEN

2997: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
2998: p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
2999: -- Code for Match rule SAMPLE: ADDRESS_PERSONS
3000: ELSIF p_rule_id=5 THEN
3001: IF NOT HZ_MATCH_RULE_5.check_staged THEN
3002: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3003: FND_MSG_PUB.ADD;
3004: RAISE FND_API.G_EXC_ERROR;
3005: END IF;

Line 3006: HZ_MATCH_RULE_5.find_parties_dynamic(

3002: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3003: FND_MSG_PUB.ADD;
3004: RAISE FND_API.G_EXC_ERROR;
3005: END IF;
3006: HZ_MATCH_RULE_5.find_parties_dynamic(
3007: p_rule_id,
3008: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
3009: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
3010: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 3289: IF NOT HZ_MATCH_RULE_50.check_staged THEN

3285: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3286: p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
3287: -- Code for Match rule BULK MATCH: IDENTICAL ORGANIZATIONS
3288: ELSIF p_rule_id=50 THEN
3289: IF NOT HZ_MATCH_RULE_50.check_staged THEN
3290: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3291: FND_MSG_PUB.ADD;
3292: RAISE FND_API.G_EXC_ERROR;
3293: END IF;

Line 3294: HZ_MATCH_RULE_50.find_parties_dynamic(

3290: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3291: FND_MSG_PUB.ADD;
3292: RAISE FND_API.G_EXC_ERROR;
3293: END IF;
3294: HZ_MATCH_RULE_50.find_parties_dynamic(
3295: p_rule_id,
3296: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
3297: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
3298: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 3307: IF NOT HZ_MATCH_RULE_51.check_staged THEN

3303: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3304: p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
3305: -- Code for Match rule BULK MATCH: IDENTICAL PERSONS
3306: ELSIF p_rule_id=51 THEN
3307: IF NOT HZ_MATCH_RULE_51.check_staged THEN
3308: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3309: FND_MSG_PUB.ADD;
3310: RAISE FND_API.G_EXC_ERROR;
3311: END IF;

Line 3312: HZ_MATCH_RULE_51.find_parties_dynamic(

3308: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3309: FND_MSG_PUB.ADD;
3310: RAISE FND_API.G_EXC_ERROR;
3311: END IF;
3312: HZ_MATCH_RULE_51.find_parties_dynamic(
3313: p_rule_id,
3314: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
3315: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
3316: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 3325: IF NOT HZ_MATCH_RULE_52.check_staged THEN

3321: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3322: p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
3323: -- Code for Match rule BULK MATCH: IDENTICAL PARTIES
3324: ELSIF p_rule_id=52 THEN
3325: IF NOT HZ_MATCH_RULE_52.check_staged THEN
3326: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3327: FND_MSG_PUB.ADD;
3328: RAISE FND_API.G_EXC_ERROR;
3329: END IF;

Line 3330: HZ_MATCH_RULE_52.find_parties_dynamic(

3326: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3327: FND_MSG_PUB.ADD;
3328: RAISE FND_API.G_EXC_ERROR;
3329: END IF;
3330: HZ_MATCH_RULE_52.find_parties_dynamic(
3331: p_rule_id,
3332: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
3333: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
3334: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 3343: IF NOT HZ_MATCH_RULE_53.check_staged THEN

3339: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3340: p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
3341: -- Code for Match rule CREDIT MANAGEMENT SEARCH
3342: ELSIF p_rule_id=53 THEN
3343: IF NOT HZ_MATCH_RULE_53.check_staged THEN
3344: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3345: FND_MSG_PUB.ADD;
3346: RAISE FND_API.G_EXC_ERROR;
3347: END IF;

Line 3348: HZ_MATCH_RULE_53.find_parties_dynamic(

3344: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3345: FND_MSG_PUB.ADD;
3346: RAISE FND_API.G_EXC_ERROR;
3347: END IF;
3348: HZ_MATCH_RULE_53.find_parties_dynamic(
3349: p_rule_id,
3350: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
3351: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
3352: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 3361: IF NOT HZ_MATCH_RULE_58.check_staged THEN

3357: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3358: p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
3359: -- Code for Match rule HZ_PERSON_SIMPLE_SEARCH_RULE
3360: ELSIF p_rule_id=58 THEN
3361: IF NOT HZ_MATCH_RULE_58.check_staged THEN
3362: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3363: FND_MSG_PUB.ADD;
3364: RAISE FND_API.G_EXC_ERROR;
3365: END IF;

Line 3366: HZ_MATCH_RULE_58.find_parties_dynamic(

3362: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3363: FND_MSG_PUB.ADD;
3364: RAISE FND_API.G_EXC_ERROR;
3365: END IF;
3366: HZ_MATCH_RULE_58.find_parties_dynamic(
3367: p_rule_id,
3368: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
3369: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
3370: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 3684: IF NOT HZ_MATCH_RULE_5.check_staged THEN

3680: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3681: p_restrict_sql,p_api_name,p_match_type,p_party_id,p_search_merged,x_search_ctx_id,x_num_matches);
3682: -- Code for Match rule SAMPLE: ADDRESS_PERSONS
3683: ELSIF p_rule_id=5 THEN
3684: IF NOT HZ_MATCH_RULE_5.check_staged THEN
3685: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3686: FND_MSG_PUB.ADD;
3687: RAISE FND_API.G_EXC_ERROR;
3688: END IF;

Line 3689: HZ_MATCH_RULE_5.call_api_dynamic(

3685: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3686: FND_MSG_PUB.ADD;
3687: RAISE FND_API.G_EXC_ERROR;
3688: END IF;
3689: HZ_MATCH_RULE_5.call_api_dynamic(
3690: p_rule_id,
3691: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
3692: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
3693: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 3972: IF NOT HZ_MATCH_RULE_50.check_staged THEN

3968: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3969: p_restrict_sql,p_api_name,p_match_type,p_party_id,p_search_merged,x_search_ctx_id,x_num_matches);
3970: -- Code for Match rule BULK MATCH: IDENTICAL ORGANIZATIONS
3971: ELSIF p_rule_id=50 THEN
3972: IF NOT HZ_MATCH_RULE_50.check_staged THEN
3973: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3974: FND_MSG_PUB.ADD;
3975: RAISE FND_API.G_EXC_ERROR;
3976: END IF;

Line 3977: HZ_MATCH_RULE_50.call_api_dynamic(

3973: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3974: FND_MSG_PUB.ADD;
3975: RAISE FND_API.G_EXC_ERROR;
3976: END IF;
3977: HZ_MATCH_RULE_50.call_api_dynamic(
3978: p_rule_id,
3979: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
3980: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
3981: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 3990: IF NOT HZ_MATCH_RULE_51.check_staged THEN

3986: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3987: p_restrict_sql,p_api_name,p_match_type,p_party_id,p_search_merged,x_search_ctx_id,x_num_matches);
3988: -- Code for Match rule BULK MATCH: IDENTICAL PERSONS
3989: ELSIF p_rule_id=51 THEN
3990: IF NOT HZ_MATCH_RULE_51.check_staged THEN
3991: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3992: FND_MSG_PUB.ADD;
3993: RAISE FND_API.G_EXC_ERROR;
3994: END IF;

Line 3995: HZ_MATCH_RULE_51.call_api_dynamic(

3991: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3992: FND_MSG_PUB.ADD;
3993: RAISE FND_API.G_EXC_ERROR;
3994: END IF;
3995: HZ_MATCH_RULE_51.call_api_dynamic(
3996: p_rule_id,
3997: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
3998: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
3999: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 4008: IF NOT HZ_MATCH_RULE_52.check_staged THEN

4004: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
4005: p_restrict_sql,p_api_name,p_match_type,p_party_id,p_search_merged,x_search_ctx_id,x_num_matches);
4006: -- Code for Match rule BULK MATCH: IDENTICAL PARTIES
4007: ELSIF p_rule_id=52 THEN
4008: IF NOT HZ_MATCH_RULE_52.check_staged THEN
4009: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4010: FND_MSG_PUB.ADD;
4011: RAISE FND_API.G_EXC_ERROR;
4012: END IF;

Line 4013: HZ_MATCH_RULE_52.call_api_dynamic(

4009: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4010: FND_MSG_PUB.ADD;
4011: RAISE FND_API.G_EXC_ERROR;
4012: END IF;
4013: HZ_MATCH_RULE_52.call_api_dynamic(
4014: p_rule_id,
4015: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
4016: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
4017: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 4026: IF NOT HZ_MATCH_RULE_53.check_staged THEN

4022: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
4023: p_restrict_sql,p_api_name,p_match_type,p_party_id,p_search_merged,x_search_ctx_id,x_num_matches);
4024: -- Code for Match rule CREDIT MANAGEMENT SEARCH
4025: ELSIF p_rule_id=53 THEN
4026: IF NOT HZ_MATCH_RULE_53.check_staged THEN
4027: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4028: FND_MSG_PUB.ADD;
4029: RAISE FND_API.G_EXC_ERROR;
4030: END IF;

Line 4031: HZ_MATCH_RULE_53.call_api_dynamic(

4027: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4028: FND_MSG_PUB.ADD;
4029: RAISE FND_API.G_EXC_ERROR;
4030: END IF;
4031: HZ_MATCH_RULE_53.call_api_dynamic(
4032: p_rule_id,
4033: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
4034: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
4035: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 4044: IF NOT HZ_MATCH_RULE_58.check_staged THEN

4040: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
4041: p_restrict_sql,p_api_name,p_match_type,p_party_id,p_search_merged,x_search_ctx_id,x_num_matches);
4042: -- Code for Match rule HZ_PERSON_SIMPLE_SEARCH_RULE
4043: ELSIF p_rule_id=58 THEN
4044: IF NOT HZ_MATCH_RULE_58.check_staged THEN
4045: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4046: FND_MSG_PUB.ADD;
4047: RAISE FND_API.G_EXC_ERROR;
4048: END IF;

Line 4049: HZ_MATCH_RULE_58.call_api_dynamic(

4045: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4046: FND_MSG_PUB.ADD;
4047: RAISE FND_API.G_EXC_ERROR;
4048: END IF;
4049: HZ_MATCH_RULE_58.call_api_dynamic(
4050: p_rule_id,
4051: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
4052: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
4053: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 4534: IF NOT HZ_MATCH_RULE_5.check_staged THEN

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
4534: IF NOT HZ_MATCH_RULE_5.check_staged THEN
4535: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4536: FND_MSG_PUB.ADD;
4537: RAISE FND_API.G_EXC_ERROR;
4538: END IF;

Line 4539: HZ_MATCH_RULE_5.get_matching_party_sites(

4535: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4536: FND_MSG_PUB.ADD;
4537: RAISE FND_API.G_EXC_ERROR;
4538: END IF;
4539: HZ_MATCH_RULE_5.get_matching_party_sites(
4540: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4541: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4542: -- Code for Match rule SAMPLE: SIMILAR_ORGANIZATION
4543: ELSIF p_rule_id=6 THEN

Line 4694: IF NOT HZ_MATCH_RULE_50.check_staged THEN

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
4694: IF NOT HZ_MATCH_RULE_50.check_staged THEN
4695: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4696: FND_MSG_PUB.ADD;
4697: RAISE FND_API.G_EXC_ERROR;
4698: END IF;

Line 4699: HZ_MATCH_RULE_50.get_matching_party_sites(

4695: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4696: FND_MSG_PUB.ADD;
4697: RAISE FND_API.G_EXC_ERROR;
4698: END IF;
4699: HZ_MATCH_RULE_50.get_matching_party_sites(
4700: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4701: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4702: -- Code for Match rule BULK MATCH: IDENTICAL PERSONS
4703: ELSIF p_rule_id=51 THEN

Line 4704: IF NOT HZ_MATCH_RULE_51.check_staged THEN

4700: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4701: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4702: -- Code for Match rule BULK MATCH: IDENTICAL PERSONS
4703: ELSIF p_rule_id=51 THEN
4704: IF NOT HZ_MATCH_RULE_51.check_staged THEN
4705: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4706: FND_MSG_PUB.ADD;
4707: RAISE FND_API.G_EXC_ERROR;
4708: END IF;

Line 4709: HZ_MATCH_RULE_51.get_matching_party_sites(

4705: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4706: FND_MSG_PUB.ADD;
4707: RAISE FND_API.G_EXC_ERROR;
4708: END IF;
4709: HZ_MATCH_RULE_51.get_matching_party_sites(
4710: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4711: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4712: -- Code for Match rule BULK MATCH: IDENTICAL PARTIES
4713: ELSIF p_rule_id=52 THEN

Line 4714: IF NOT HZ_MATCH_RULE_52.check_staged THEN

4710: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4711: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4712: -- Code for Match rule BULK MATCH: IDENTICAL PARTIES
4713: ELSIF p_rule_id=52 THEN
4714: IF NOT HZ_MATCH_RULE_52.check_staged THEN
4715: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4716: FND_MSG_PUB.ADD;
4717: RAISE FND_API.G_EXC_ERROR;
4718: END IF;

Line 4719: HZ_MATCH_RULE_52.get_matching_party_sites(

4715: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4716: FND_MSG_PUB.ADD;
4717: RAISE FND_API.G_EXC_ERROR;
4718: END IF;
4719: HZ_MATCH_RULE_52.get_matching_party_sites(
4720: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4721: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4722: -- Code for Match rule CREDIT MANAGEMENT SEARCH
4723: ELSIF p_rule_id=53 THEN

Line 4724: IF NOT HZ_MATCH_RULE_53.check_staged THEN

4720: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4721: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4722: -- Code for Match rule CREDIT MANAGEMENT SEARCH
4723: ELSIF p_rule_id=53 THEN
4724: IF NOT HZ_MATCH_RULE_53.check_staged THEN
4725: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4726: FND_MSG_PUB.ADD;
4727: RAISE FND_API.G_EXC_ERROR;
4728: END IF;

Line 4729: HZ_MATCH_RULE_53.get_matching_party_sites(

4725: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4726: FND_MSG_PUB.ADD;
4727: RAISE FND_API.G_EXC_ERROR;
4728: END IF;
4729: HZ_MATCH_RULE_53.get_matching_party_sites(
4730: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4731: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4732: -- Code for Match rule HZ_PERSON_SIMPLE_SEARCH_RULE
4733: ELSIF p_rule_id=58 THEN

Line 4734: IF NOT HZ_MATCH_RULE_58.check_staged THEN

4730: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4731: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4732: -- Code for Match rule HZ_PERSON_SIMPLE_SEARCH_RULE
4733: ELSIF p_rule_id=58 THEN
4734: IF NOT HZ_MATCH_RULE_58.check_staged THEN
4735: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4736: FND_MSG_PUB.ADD;
4737: RAISE FND_API.G_EXC_ERROR;
4738: END IF;

Line 4739: HZ_MATCH_RULE_58.get_matching_party_sites(

4735: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4736: FND_MSG_PUB.ADD;
4737: RAISE FND_API.G_EXC_ERROR;
4738: END IF;
4739: HZ_MATCH_RULE_58.get_matching_party_sites(
4740: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4741: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4742: -- Code for Match rule HZ_PERSON_ADVANCED_SEARCH_MATCH_RULE
4743: ELSIF p_rule_id=60 THEN

Line 4953: IF NOT HZ_MATCH_RULE_5.check_staged THEN

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
4953: IF NOT HZ_MATCH_RULE_5.check_staged THEN
4954: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4955: FND_MSG_PUB.ADD;
4956: RAISE FND_API.G_EXC_ERROR;
4957: END IF;

Line 4958: HZ_MATCH_RULE_5.get_matching_contacts(

4954: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4955: FND_MSG_PUB.ADD;
4956: RAISE FND_API.G_EXC_ERROR;
4957: END IF;
4958: HZ_MATCH_RULE_5.get_matching_contacts(
4959: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
4960: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4961: -- Code for Match rule SAMPLE: SIMILAR_ORGANIZATION
4962: ELSIF p_rule_id=6 THEN

Line 5113: IF NOT HZ_MATCH_RULE_50.check_staged THEN

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
5113: IF NOT HZ_MATCH_RULE_50.check_staged THEN
5114: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5115: FND_MSG_PUB.ADD;
5116: RAISE FND_API.G_EXC_ERROR;
5117: END IF;

Line 5118: HZ_MATCH_RULE_50.get_matching_contacts(

5114: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5115: FND_MSG_PUB.ADD;
5116: RAISE FND_API.G_EXC_ERROR;
5117: END IF;
5118: HZ_MATCH_RULE_50.get_matching_contacts(
5119: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
5120: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5121: -- Code for Match rule BULK MATCH: IDENTICAL PERSONS
5122: ELSIF p_rule_id=51 THEN

Line 5123: IF NOT HZ_MATCH_RULE_51.check_staged THEN

5119: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
5120: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5121: -- Code for Match rule BULK MATCH: IDENTICAL PERSONS
5122: ELSIF p_rule_id=51 THEN
5123: IF NOT HZ_MATCH_RULE_51.check_staged THEN
5124: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5125: FND_MSG_PUB.ADD;
5126: RAISE FND_API.G_EXC_ERROR;
5127: END IF;

Line 5128: HZ_MATCH_RULE_51.get_matching_contacts(

5124: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5125: FND_MSG_PUB.ADD;
5126: RAISE FND_API.G_EXC_ERROR;
5127: END IF;
5128: HZ_MATCH_RULE_51.get_matching_contacts(
5129: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
5130: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5131: -- Code for Match rule BULK MATCH: IDENTICAL PARTIES
5132: ELSIF p_rule_id=52 THEN

Line 5133: IF NOT HZ_MATCH_RULE_52.check_staged THEN

5129: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
5130: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5131: -- Code for Match rule BULK MATCH: IDENTICAL PARTIES
5132: ELSIF p_rule_id=52 THEN
5133: IF NOT HZ_MATCH_RULE_52.check_staged THEN
5134: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5135: FND_MSG_PUB.ADD;
5136: RAISE FND_API.G_EXC_ERROR;
5137: END IF;

Line 5138: HZ_MATCH_RULE_52.get_matching_contacts(

5134: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5135: FND_MSG_PUB.ADD;
5136: RAISE FND_API.G_EXC_ERROR;
5137: END IF;
5138: HZ_MATCH_RULE_52.get_matching_contacts(
5139: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
5140: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5141: -- Code for Match rule CREDIT MANAGEMENT SEARCH
5142: ELSIF p_rule_id=53 THEN

Line 5143: IF NOT HZ_MATCH_RULE_53.check_staged THEN

5139: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
5140: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5141: -- Code for Match rule CREDIT MANAGEMENT SEARCH
5142: ELSIF p_rule_id=53 THEN
5143: IF NOT HZ_MATCH_RULE_53.check_staged THEN
5144: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5145: FND_MSG_PUB.ADD;
5146: RAISE FND_API.G_EXC_ERROR;
5147: END IF;

Line 5148: HZ_MATCH_RULE_53.get_matching_contacts(

5144: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5145: FND_MSG_PUB.ADD;
5146: RAISE FND_API.G_EXC_ERROR;
5147: END IF;
5148: HZ_MATCH_RULE_53.get_matching_contacts(
5149: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
5150: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5151: -- Code for Match rule HZ_PERSON_SIMPLE_SEARCH_RULE
5152: ELSIF p_rule_id=58 THEN

Line 5153: IF NOT HZ_MATCH_RULE_58.check_staged THEN

5149: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
5150: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5151: -- Code for Match rule HZ_PERSON_SIMPLE_SEARCH_RULE
5152: ELSIF p_rule_id=58 THEN
5153: IF NOT HZ_MATCH_RULE_58.check_staged THEN
5154: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5155: FND_MSG_PUB.ADD;
5156: RAISE FND_API.G_EXC_ERROR;
5157: END IF;

Line 5158: HZ_MATCH_RULE_58.get_matching_contacts(

5154: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5155: FND_MSG_PUB.ADD;
5156: RAISE FND_API.G_EXC_ERROR;
5157: END IF;
5158: HZ_MATCH_RULE_58.get_matching_contacts(
5159: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
5160: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5161: -- Code for Match rule HZ_PERSON_ADVANCED_SEARCH_MATCH_RULE
5162: ELSIF p_rule_id=60 THEN

Line 5370: IF NOT HZ_MATCH_RULE_5.check_staged THEN

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
5370: IF NOT HZ_MATCH_RULE_5.check_staged THEN
5371: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5372: FND_MSG_PUB.ADD;
5373: RAISE FND_API.G_EXC_ERROR;
5374: END IF;

Line 5375: HZ_MATCH_RULE_5.get_matching_contact_points(

5371: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5372: FND_MSG_PUB.ADD;
5373: RAISE FND_API.G_EXC_ERROR;
5374: END IF;
5375: HZ_MATCH_RULE_5.get_matching_contact_points(
5376: p_rule_id, p_party_id, p_contact_point_list,
5377: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5378: -- Code for Match rule SAMPLE: SIMILAR_ORGANIZATION
5379: ELSIF p_rule_id=6 THEN

Line 5530: IF NOT HZ_MATCH_RULE_50.check_staged THEN

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
5530: IF NOT HZ_MATCH_RULE_50.check_staged THEN
5531: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5532: FND_MSG_PUB.ADD;
5533: RAISE FND_API.G_EXC_ERROR;
5534: END IF;

Line 5535: HZ_MATCH_RULE_50.get_matching_contact_points(

5531: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5532: FND_MSG_PUB.ADD;
5533: RAISE FND_API.G_EXC_ERROR;
5534: END IF;
5535: HZ_MATCH_RULE_50.get_matching_contact_points(
5536: p_rule_id, p_party_id, p_contact_point_list,
5537: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5538: -- Code for Match rule BULK MATCH: IDENTICAL PERSONS
5539: ELSIF p_rule_id=51 THEN

Line 5540: IF NOT HZ_MATCH_RULE_51.check_staged THEN

5536: p_rule_id, p_party_id, p_contact_point_list,
5537: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5538: -- Code for Match rule BULK MATCH: IDENTICAL PERSONS
5539: ELSIF p_rule_id=51 THEN
5540: IF NOT HZ_MATCH_RULE_51.check_staged THEN
5541: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5542: FND_MSG_PUB.ADD;
5543: RAISE FND_API.G_EXC_ERROR;
5544: END IF;

Line 5545: HZ_MATCH_RULE_51.get_matching_contact_points(

5541: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5542: FND_MSG_PUB.ADD;
5543: RAISE FND_API.G_EXC_ERROR;
5544: END IF;
5545: HZ_MATCH_RULE_51.get_matching_contact_points(
5546: p_rule_id, p_party_id, p_contact_point_list,
5547: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5548: -- Code for Match rule BULK MATCH: IDENTICAL PARTIES
5549: ELSIF p_rule_id=52 THEN

Line 5550: IF NOT HZ_MATCH_RULE_52.check_staged THEN

5546: p_rule_id, p_party_id, p_contact_point_list,
5547: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5548: -- Code for Match rule BULK MATCH: IDENTICAL PARTIES
5549: ELSIF p_rule_id=52 THEN
5550: IF NOT HZ_MATCH_RULE_52.check_staged THEN
5551: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5552: FND_MSG_PUB.ADD;
5553: RAISE FND_API.G_EXC_ERROR;
5554: END IF;

Line 5555: HZ_MATCH_RULE_52.get_matching_contact_points(

5551: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5552: FND_MSG_PUB.ADD;
5553: RAISE FND_API.G_EXC_ERROR;
5554: END IF;
5555: HZ_MATCH_RULE_52.get_matching_contact_points(
5556: p_rule_id, p_party_id, p_contact_point_list,
5557: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5558: -- Code for Match rule CREDIT MANAGEMENT SEARCH
5559: ELSIF p_rule_id=53 THEN

Line 5560: IF NOT HZ_MATCH_RULE_53.check_staged THEN

5556: p_rule_id, p_party_id, p_contact_point_list,
5557: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5558: -- Code for Match rule CREDIT MANAGEMENT SEARCH
5559: ELSIF p_rule_id=53 THEN
5560: IF NOT HZ_MATCH_RULE_53.check_staged THEN
5561: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5562: FND_MSG_PUB.ADD;
5563: RAISE FND_API.G_EXC_ERROR;
5564: END IF;

Line 5565: HZ_MATCH_RULE_53.get_matching_contact_points(

5561: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5562: FND_MSG_PUB.ADD;
5563: RAISE FND_API.G_EXC_ERROR;
5564: END IF;
5565: HZ_MATCH_RULE_53.get_matching_contact_points(
5566: p_rule_id, p_party_id, p_contact_point_list,
5567: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5568: -- Code for Match rule HZ_PERSON_SIMPLE_SEARCH_RULE
5569: ELSIF p_rule_id=58 THEN

Line 5570: IF NOT HZ_MATCH_RULE_58.check_staged THEN

5566: p_rule_id, p_party_id, p_contact_point_list,
5567: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5568: -- Code for Match rule HZ_PERSON_SIMPLE_SEARCH_RULE
5569: ELSIF p_rule_id=58 THEN
5570: IF NOT HZ_MATCH_RULE_58.check_staged THEN
5571: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5572: FND_MSG_PUB.ADD;
5573: RAISE FND_API.G_EXC_ERROR;
5574: END IF;

Line 5575: HZ_MATCH_RULE_58.get_matching_contact_points(

5571: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5572: FND_MSG_PUB.ADD;
5573: RAISE FND_API.G_EXC_ERROR;
5574: END IF;
5575: HZ_MATCH_RULE_58.get_matching_contact_points(
5576: p_rule_id, p_party_id, p_contact_point_list,
5577: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5578: -- Code for Match rule HZ_PERSON_ADVANCED_SEARCH_MATCH_RULE
5579: ELSIF p_rule_id=60 THEN

Line 5793: IF NOT HZ_MATCH_RULE_5.check_staged THEN

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
5792: ELSIF p_rule_id=5 THEN
5793: IF NOT HZ_MATCH_RULE_5.check_staged THEN
5794: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5795: FND_MSG_PUB.ADD;
5796: RAISE FND_API.G_EXC_ERROR;
5797: END IF;

Line 5798: HZ_MATCH_RULE_5.get_score_details(

5794: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5795: FND_MSG_PUB.ADD;
5796: RAISE FND_API.G_EXC_ERROR;
5797: END IF;
5798: HZ_MATCH_RULE_5.get_score_details(
5799: p_rule_id,
5800: p_party_id, p_party_search_rec,p_party_site_list,
5801: p_contact_list, p_contact_point_list,x_search_ctx_id);
5802: -- Code for Match rule SAMPLE: SIMILAR_ORGANIZATION

Line 5969: IF NOT HZ_MATCH_RULE_50.check_staged THEN

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
5968: ELSIF p_rule_id=50 THEN
5969: IF NOT HZ_MATCH_RULE_50.check_staged THEN
5970: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5971: FND_MSG_PUB.ADD;
5972: RAISE FND_API.G_EXC_ERROR;
5973: END IF;

Line 5974: HZ_MATCH_RULE_50.get_score_details(

5970: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5971: FND_MSG_PUB.ADD;
5972: RAISE FND_API.G_EXC_ERROR;
5973: END IF;
5974: HZ_MATCH_RULE_50.get_score_details(
5975: p_rule_id,
5976: p_party_id, p_party_search_rec,p_party_site_list,
5977: p_contact_list, p_contact_point_list,x_search_ctx_id);
5978: -- Code for Match rule BULK MATCH: IDENTICAL PERSONS

Line 5980: IF NOT HZ_MATCH_RULE_51.check_staged THEN

5976: p_party_id, p_party_search_rec,p_party_site_list,
5977: p_contact_list, p_contact_point_list,x_search_ctx_id);
5978: -- Code for Match rule BULK MATCH: IDENTICAL PERSONS
5979: ELSIF p_rule_id=51 THEN
5980: IF NOT HZ_MATCH_RULE_51.check_staged THEN
5981: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5982: FND_MSG_PUB.ADD;
5983: RAISE FND_API.G_EXC_ERROR;
5984: END IF;

Line 5985: HZ_MATCH_RULE_51.get_score_details(

5981: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5982: FND_MSG_PUB.ADD;
5983: RAISE FND_API.G_EXC_ERROR;
5984: END IF;
5985: HZ_MATCH_RULE_51.get_score_details(
5986: p_rule_id,
5987: p_party_id, p_party_search_rec,p_party_site_list,
5988: p_contact_list, p_contact_point_list,x_search_ctx_id);
5989: -- Code for Match rule BULK MATCH: IDENTICAL PARTIES

Line 5991: IF NOT HZ_MATCH_RULE_52.check_staged THEN

5987: p_party_id, p_party_search_rec,p_party_site_list,
5988: p_contact_list, p_contact_point_list,x_search_ctx_id);
5989: -- Code for Match rule BULK MATCH: IDENTICAL PARTIES
5990: ELSIF p_rule_id=52 THEN
5991: IF NOT HZ_MATCH_RULE_52.check_staged THEN
5992: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5993: FND_MSG_PUB.ADD;
5994: RAISE FND_API.G_EXC_ERROR;
5995: END IF;

Line 5996: HZ_MATCH_RULE_52.get_score_details(

5992: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5993: FND_MSG_PUB.ADD;
5994: RAISE FND_API.G_EXC_ERROR;
5995: END IF;
5996: HZ_MATCH_RULE_52.get_score_details(
5997: p_rule_id,
5998: p_party_id, p_party_search_rec,p_party_site_list,
5999: p_contact_list, p_contact_point_list,x_search_ctx_id);
6000: -- Code for Match rule CREDIT MANAGEMENT SEARCH

Line 6002: IF NOT HZ_MATCH_RULE_53.check_staged THEN

5998: p_party_id, p_party_search_rec,p_party_site_list,
5999: p_contact_list, p_contact_point_list,x_search_ctx_id);
6000: -- Code for Match rule CREDIT MANAGEMENT SEARCH
6001: ELSIF p_rule_id=53 THEN
6002: IF NOT HZ_MATCH_RULE_53.check_staged THEN
6003: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6004: FND_MSG_PUB.ADD;
6005: RAISE FND_API.G_EXC_ERROR;
6006: END IF;

Line 6007: HZ_MATCH_RULE_53.get_score_details(

6003: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6004: FND_MSG_PUB.ADD;
6005: RAISE FND_API.G_EXC_ERROR;
6006: END IF;
6007: HZ_MATCH_RULE_53.get_score_details(
6008: p_rule_id,
6009: p_party_id, p_party_search_rec,p_party_site_list,
6010: p_contact_list, p_contact_point_list,x_search_ctx_id);
6011: -- Code for Match rule HZ_PERSON_SIMPLE_SEARCH_RULE

Line 6013: IF NOT HZ_MATCH_RULE_58.check_staged THEN

6009: p_party_id, p_party_search_rec,p_party_site_list,
6010: p_contact_list, p_contact_point_list,x_search_ctx_id);
6011: -- Code for Match rule HZ_PERSON_SIMPLE_SEARCH_RULE
6012: ELSIF p_rule_id=58 THEN
6013: IF NOT HZ_MATCH_RULE_58.check_staged THEN
6014: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6015: FND_MSG_PUB.ADD;
6016: RAISE FND_API.G_EXC_ERROR;
6017: END IF;

Line 6018: HZ_MATCH_RULE_58.get_score_details(

6014: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6015: FND_MSG_PUB.ADD;
6016: RAISE FND_API.G_EXC_ERROR;
6017: END IF;
6018: HZ_MATCH_RULE_58.get_score_details(
6019: p_rule_id,
6020: p_party_id, p_party_search_rec,p_party_site_list,
6021: p_contact_list, p_contact_point_list,x_search_ctx_id);
6022: -- Code for Match rule HZ_PERSON_ADVANCED_SEARCH_MATCH_RULE

Line 6210: IF NOT HZ_MATCH_RULE_5.check_staged THEN

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
6210: IF NOT HZ_MATCH_RULE_5.check_staged THEN
6211: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6212: FND_MSG_PUB.ADD;
6213: RAISE FND_API.G_EXC_ERROR;
6214: END IF;

Line 6215: HZ_MATCH_RULE_5.get_party_for_search(

6211: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6212: FND_MSG_PUB.ADD;
6213: RAISE FND_API.G_EXC_ERROR;
6214: END IF;
6215: HZ_MATCH_RULE_5.get_party_for_search(
6216: p_party_id, x_party_search_rec,x_party_site_list,
6217: x_contact_list, x_contact_point_list);
6218: -- Code for Match rule SAMPLE: SIMILAR_ORGANIZATION
6219: ELSIF p_rule_id=6 THEN

Line 6370: IF NOT HZ_MATCH_RULE_50.check_staged THEN

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
6370: IF NOT HZ_MATCH_RULE_50.check_staged THEN
6371: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6372: FND_MSG_PUB.ADD;
6373: RAISE FND_API.G_EXC_ERROR;
6374: END IF;

Line 6375: HZ_MATCH_RULE_50.get_party_for_search(

6371: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6372: FND_MSG_PUB.ADD;
6373: RAISE FND_API.G_EXC_ERROR;
6374: END IF;
6375: HZ_MATCH_RULE_50.get_party_for_search(
6376: p_party_id, x_party_search_rec,x_party_site_list,
6377: x_contact_list, x_contact_point_list);
6378: -- Code for Match rule BULK MATCH: IDENTICAL PERSONS
6379: ELSIF p_rule_id=51 THEN

Line 6380: IF NOT HZ_MATCH_RULE_51.check_staged THEN

6376: p_party_id, x_party_search_rec,x_party_site_list,
6377: x_contact_list, x_contact_point_list);
6378: -- Code for Match rule BULK MATCH: IDENTICAL PERSONS
6379: ELSIF p_rule_id=51 THEN
6380: IF NOT HZ_MATCH_RULE_51.check_staged THEN
6381: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6382: FND_MSG_PUB.ADD;
6383: RAISE FND_API.G_EXC_ERROR;
6384: END IF;

Line 6385: HZ_MATCH_RULE_51.get_party_for_search(

6381: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6382: FND_MSG_PUB.ADD;
6383: RAISE FND_API.G_EXC_ERROR;
6384: END IF;
6385: HZ_MATCH_RULE_51.get_party_for_search(
6386: p_party_id, x_party_search_rec,x_party_site_list,
6387: x_contact_list, x_contact_point_list);
6388: -- Code for Match rule BULK MATCH: IDENTICAL PARTIES
6389: ELSIF p_rule_id=52 THEN

Line 6390: IF NOT HZ_MATCH_RULE_52.check_staged THEN

6386: p_party_id, x_party_search_rec,x_party_site_list,
6387: x_contact_list, x_contact_point_list);
6388: -- Code for Match rule BULK MATCH: IDENTICAL PARTIES
6389: ELSIF p_rule_id=52 THEN
6390: IF NOT HZ_MATCH_RULE_52.check_staged THEN
6391: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6392: FND_MSG_PUB.ADD;
6393: RAISE FND_API.G_EXC_ERROR;
6394: END IF;

Line 6395: HZ_MATCH_RULE_52.get_party_for_search(

6391: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6392: FND_MSG_PUB.ADD;
6393: RAISE FND_API.G_EXC_ERROR;
6394: END IF;
6395: HZ_MATCH_RULE_52.get_party_for_search(
6396: p_party_id, x_party_search_rec,x_party_site_list,
6397: x_contact_list, x_contact_point_list);
6398: -- Code for Match rule CREDIT MANAGEMENT SEARCH
6399: ELSIF p_rule_id=53 THEN

Line 6400: IF NOT HZ_MATCH_RULE_53.check_staged THEN

6396: p_party_id, x_party_search_rec,x_party_site_list,
6397: x_contact_list, x_contact_point_list);
6398: -- Code for Match rule CREDIT MANAGEMENT SEARCH
6399: ELSIF p_rule_id=53 THEN
6400: IF NOT HZ_MATCH_RULE_53.check_staged THEN
6401: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6402: FND_MSG_PUB.ADD;
6403: RAISE FND_API.G_EXC_ERROR;
6404: END IF;

Line 6405: HZ_MATCH_RULE_53.get_party_for_search(

6401: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6402: FND_MSG_PUB.ADD;
6403: RAISE FND_API.G_EXC_ERROR;
6404: END IF;
6405: HZ_MATCH_RULE_53.get_party_for_search(
6406: p_party_id, x_party_search_rec,x_party_site_list,
6407: x_contact_list, x_contact_point_list);
6408: -- Code for Match rule HZ_PERSON_SIMPLE_SEARCH_RULE
6409: ELSIF p_rule_id=58 THEN

Line 6410: IF NOT HZ_MATCH_RULE_58.check_staged THEN

6406: p_party_id, x_party_search_rec,x_party_site_list,
6407: x_contact_list, x_contact_point_list);
6408: -- Code for Match rule HZ_PERSON_SIMPLE_SEARCH_RULE
6409: ELSIF p_rule_id=58 THEN
6410: IF NOT HZ_MATCH_RULE_58.check_staged THEN
6411: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6412: FND_MSG_PUB.ADD;
6413: RAISE FND_API.G_EXC_ERROR;
6414: END IF;

Line 6415: HZ_MATCH_RULE_58.get_party_for_search(

6411: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6412: FND_MSG_PUB.ADD;
6413: RAISE FND_API.G_EXC_ERROR;
6414: END IF;
6415: HZ_MATCH_RULE_58.get_party_for_search(
6416: p_party_id, x_party_search_rec,x_party_site_list,
6417: x_contact_list, x_contact_point_list);
6418: -- Code for Match rule HZ_PERSON_ADVANCED_SEARCH_MATCH_RULE
6419: ELSIF p_rule_id=60 THEN

Line 6602: IF NOT HZ_MATCH_RULE_5.check_staged THEN

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
6602: IF NOT HZ_MATCH_RULE_5.check_staged THEN
6603: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6604: FND_MSG_PUB.ADD;
6605: RAISE FND_API.G_EXC_ERROR;
6606: END IF;

Line 6607: HZ_MATCH_RULE_5.get_search_criteria(

6603: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6604: FND_MSG_PUB.ADD;
6605: RAISE FND_API.G_EXC_ERROR;
6606: END IF;
6607: HZ_MATCH_RULE_5.get_search_criteria(
6608: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6609: x_contact_list, x_contact_point_list);
6610: -- Code for Match rule SAMPLE: SIMILAR_ORGANIZATION
6611: ELSIF p_rule_id=6 THEN

Line 6762: IF NOT HZ_MATCH_RULE_50.check_staged THEN

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
6762: IF NOT HZ_MATCH_RULE_50.check_staged THEN
6763: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6764: FND_MSG_PUB.ADD;
6765: RAISE FND_API.G_EXC_ERROR;
6766: END IF;

Line 6767: HZ_MATCH_RULE_50.get_search_criteria(

6763: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6764: FND_MSG_PUB.ADD;
6765: RAISE FND_API.G_EXC_ERROR;
6766: END IF;
6767: HZ_MATCH_RULE_50.get_search_criteria(
6768: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6769: x_contact_list, x_contact_point_list);
6770: -- Code for Match rule BULK MATCH: IDENTICAL PERSONS
6771: ELSIF p_rule_id=51 THEN

Line 6772: IF NOT HZ_MATCH_RULE_51.check_staged THEN

6768: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6769: x_contact_list, x_contact_point_list);
6770: -- Code for Match rule BULK MATCH: IDENTICAL PERSONS
6771: ELSIF p_rule_id=51 THEN
6772: IF NOT HZ_MATCH_RULE_51.check_staged THEN
6773: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6774: FND_MSG_PUB.ADD;
6775: RAISE FND_API.G_EXC_ERROR;
6776: END IF;

Line 6777: HZ_MATCH_RULE_51.get_search_criteria(

6773: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6774: FND_MSG_PUB.ADD;
6775: RAISE FND_API.G_EXC_ERROR;
6776: END IF;
6777: HZ_MATCH_RULE_51.get_search_criteria(
6778: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6779: x_contact_list, x_contact_point_list);
6780: -- Code for Match rule BULK MATCH: IDENTICAL PARTIES
6781: ELSIF p_rule_id=52 THEN

Line 6782: IF NOT HZ_MATCH_RULE_52.check_staged THEN

6778: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6779: x_contact_list, x_contact_point_list);
6780: -- Code for Match rule BULK MATCH: IDENTICAL PARTIES
6781: ELSIF p_rule_id=52 THEN
6782: IF NOT HZ_MATCH_RULE_52.check_staged THEN
6783: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6784: FND_MSG_PUB.ADD;
6785: RAISE FND_API.G_EXC_ERROR;
6786: END IF;

Line 6787: HZ_MATCH_RULE_52.get_search_criteria(

6783: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6784: FND_MSG_PUB.ADD;
6785: RAISE FND_API.G_EXC_ERROR;
6786: END IF;
6787: HZ_MATCH_RULE_52.get_search_criteria(
6788: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6789: x_contact_list, x_contact_point_list);
6790: -- Code for Match rule CREDIT MANAGEMENT SEARCH
6791: ELSIF p_rule_id=53 THEN

Line 6792: IF NOT HZ_MATCH_RULE_53.check_staged THEN

6788: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6789: x_contact_list, x_contact_point_list);
6790: -- Code for Match rule CREDIT MANAGEMENT SEARCH
6791: ELSIF p_rule_id=53 THEN
6792: IF NOT HZ_MATCH_RULE_53.check_staged THEN
6793: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6794: FND_MSG_PUB.ADD;
6795: RAISE FND_API.G_EXC_ERROR;
6796: END IF;

Line 6797: HZ_MATCH_RULE_53.get_search_criteria(

6793: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6794: FND_MSG_PUB.ADD;
6795: RAISE FND_API.G_EXC_ERROR;
6796: END IF;
6797: HZ_MATCH_RULE_53.get_search_criteria(
6798: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6799: x_contact_list, x_contact_point_list);
6800: -- Code for Match rule HZ_PERSON_SIMPLE_SEARCH_RULE
6801: ELSIF p_rule_id=58 THEN

Line 6802: IF NOT HZ_MATCH_RULE_58.check_staged THEN

6798: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6799: x_contact_list, x_contact_point_list);
6800: -- Code for Match rule HZ_PERSON_SIMPLE_SEARCH_RULE
6801: ELSIF p_rule_id=58 THEN
6802: IF NOT HZ_MATCH_RULE_58.check_staged THEN
6803: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6804: FND_MSG_PUB.ADD;
6805: RAISE FND_API.G_EXC_ERROR;
6806: END IF;

Line 6807: HZ_MATCH_RULE_58.get_search_criteria(

6803: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6804: FND_MSG_PUB.ADD;
6805: RAISE FND_API.G_EXC_ERROR;
6806: END IF;
6807: HZ_MATCH_RULE_58.get_search_criteria(
6808: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6809: x_contact_list, x_contact_point_list);
6810: -- Code for Match rule HZ_PERSON_ADVANCED_SEARCH_MATCH_RULE
6811: ELSIF p_rule_id=60 THEN