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 521: IF NOT HZ_MATCH_RULE_5.check_staged THEN

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
521: IF NOT HZ_MATCH_RULE_5.check_staged THEN
522: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
523: FND_MSG_PUB.ADD;
524: RAISE FND_API.G_EXC_ERROR;
525: END IF;

Line 526: HZ_MATCH_RULE_5.find_persons(

522: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
523: FND_MSG_PUB.ADD;
524: RAISE FND_API.G_EXC_ERROR;
525: END IF;
526: HZ_MATCH_RULE_5.find_persons(
527: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
528: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,'N',x_search_ctx_id,x_num_matches);
529: -- Code for Match rule SAMPLE: SIMILAR_ORGANIZATION
530: ELSIF p_rule_id=6 THEN

Line 681: IF NOT HZ_MATCH_RULE_50.check_staged THEN

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

Line 686: HZ_MATCH_RULE_50.find_persons(

682: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
683: FND_MSG_PUB.ADD;
684: RAISE FND_API.G_EXC_ERROR;
685: END IF;
686: HZ_MATCH_RULE_50.find_persons(
687: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
688: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,'N',x_search_ctx_id,x_num_matches);
689: -- Code for Match rule BULK MATCH: IDENTICAL PERSONS
690: ELSIF p_rule_id=51 THEN

Line 691: IF NOT HZ_MATCH_RULE_51.check_staged THEN

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

Line 696: HZ_MATCH_RULE_51.find_persons(

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

Line 701: IF NOT HZ_MATCH_RULE_52.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 PARTIES
700: ELSIF p_rule_id=52 THEN
701: IF NOT HZ_MATCH_RULE_52.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_52.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_52.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 CREDIT MANAGEMENT SEARCH
710: ELSIF p_rule_id=53 THEN

Line 711: IF NOT HZ_MATCH_RULE_53.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 CREDIT MANAGEMENT SEARCH
710: ELSIF p_rule_id=53 THEN
711: IF NOT HZ_MATCH_RULE_53.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_53.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_53.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 HZ_PERSON_SIMPLE_SEARCH_RULE
720: ELSIF p_rule_id=58 THEN

Line 721: IF NOT HZ_MATCH_RULE_58.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 HZ_PERSON_SIMPLE_SEARCH_RULE
720: ELSIF p_rule_id=58 THEN
721: IF NOT HZ_MATCH_RULE_58.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_58.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_58.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 HZ_PERSON_ADVANCED_SEARCH_MATCH_RULE
730: ELSIF p_rule_id=60 THEN

Line 920: IF NOT HZ_MATCH_RULE_5.check_staged THEN

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
920: IF NOT HZ_MATCH_RULE_5.check_staged THEN
921: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
922: FND_MSG_PUB.ADD;
923: RAISE FND_API.G_EXC_ERROR;
924: END IF;

Line 925: HZ_MATCH_RULE_5.find_party_details(

921: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
922: FND_MSG_PUB.ADD;
923: RAISE FND_API.G_EXC_ERROR;
924: END IF;
925: HZ_MATCH_RULE_5.find_party_details(
926: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
927: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
928: -- Code for Match rule SAMPLE: SIMILAR_ORGANIZATION
929: ELSIF p_rule_id=6 THEN

Line 1080: IF NOT HZ_MATCH_RULE_50.check_staged THEN

1076: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
1077: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
1078: -- Code for Match rule BULK MATCH: IDENTICAL ORGANIZATIONS
1079: ELSIF p_rule_id=50 THEN
1080: IF NOT HZ_MATCH_RULE_50.check_staged THEN
1081: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1082: FND_MSG_PUB.ADD;
1083: RAISE FND_API.G_EXC_ERROR;
1084: END IF;

Line 1085: HZ_MATCH_RULE_50.find_party_details(

1081: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1082: FND_MSG_PUB.ADD;
1083: RAISE FND_API.G_EXC_ERROR;
1084: END IF;
1085: HZ_MATCH_RULE_50.find_party_details(
1086: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
1087: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
1088: -- Code for Match rule BULK MATCH: IDENTICAL PERSONS
1089: ELSIF p_rule_id=51 THEN

Line 1090: IF NOT HZ_MATCH_RULE_51.check_staged THEN

1086: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
1087: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
1088: -- Code for Match rule BULK MATCH: IDENTICAL PERSONS
1089: ELSIF p_rule_id=51 THEN
1090: IF NOT HZ_MATCH_RULE_51.check_staged THEN
1091: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1092: FND_MSG_PUB.ADD;
1093: RAISE FND_API.G_EXC_ERROR;
1094: END IF;

Line 1095: HZ_MATCH_RULE_51.find_party_details(

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

Line 1100: IF NOT HZ_MATCH_RULE_52.check_staged THEN

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

Line 1105: HZ_MATCH_RULE_52.find_party_details(

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

Line 1110: IF NOT HZ_MATCH_RULE_53.check_staged THEN

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

Line 1115: HZ_MATCH_RULE_53.find_party_details(

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

Line 1120: IF NOT HZ_MATCH_RULE_58.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 HZ_PERSON_SIMPLE_SEARCH_RULE
1119: ELSIF p_rule_id=58 THEN
1120: IF NOT HZ_MATCH_RULE_58.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_58.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_58.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 HZ_PERSON_ADVANCED_SEARCH_MATCH_RULE
1129: ELSIF p_rule_id=60 THEN

Line 1300: IF NOT HZ_MATCH_RULE_5.check_staged THEN

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
1300: IF NOT HZ_MATCH_RULE_5.check_staged THEN
1301: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1302: FND_MSG_PUB.ADD;
1303: RAISE FND_API.G_EXC_ERROR;
1304: END IF;

Line 1305: HZ_MATCH_RULE_5.find_duplicate_parties(

1301: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1302: FND_MSG_PUB.ADD;
1303: RAISE FND_API.G_EXC_ERROR;
1304: END IF;
1305: HZ_MATCH_RULE_5.find_duplicate_parties(
1306: p_rule_id,p_party_id,
1307: p_restrict_sql,p_match_type,p_dup_batch_id,p_search_merged,x_dup_set_id, x_search_ctx_id,x_num_matches);
1308: -- Code for Match rule SAMPLE: SIMILAR_ORGANIZATION
1309: ELSIF p_rule_id=6 THEN

Line 1460: IF NOT HZ_MATCH_RULE_50.check_staged THEN

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
1460: IF NOT HZ_MATCH_RULE_50.check_staged THEN
1461: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1462: FND_MSG_PUB.ADD;
1463: RAISE FND_API.G_EXC_ERROR;
1464: END IF;

Line 1465: HZ_MATCH_RULE_50.find_duplicate_parties(

1461: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1462: FND_MSG_PUB.ADD;
1463: RAISE FND_API.G_EXC_ERROR;
1464: END IF;
1465: HZ_MATCH_RULE_50.find_duplicate_parties(
1466: p_rule_id,p_party_id,
1467: p_restrict_sql,p_match_type,p_dup_batch_id,p_search_merged,x_dup_set_id, x_search_ctx_id,x_num_matches);
1468: -- Code for Match rule BULK MATCH: IDENTICAL PERSONS
1469: ELSIF p_rule_id=51 THEN

Line 1470: IF NOT HZ_MATCH_RULE_51.check_staged THEN

1466: p_rule_id,p_party_id,
1467: p_restrict_sql,p_match_type,p_dup_batch_id,p_search_merged,x_dup_set_id, x_search_ctx_id,x_num_matches);
1468: -- Code for Match rule BULK MATCH: IDENTICAL PERSONS
1469: ELSIF p_rule_id=51 THEN
1470: IF NOT HZ_MATCH_RULE_51.check_staged THEN
1471: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1472: FND_MSG_PUB.ADD;
1473: RAISE FND_API.G_EXC_ERROR;
1474: END IF;

Line 1475: HZ_MATCH_RULE_51.find_duplicate_parties(

1471: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1472: FND_MSG_PUB.ADD;
1473: RAISE FND_API.G_EXC_ERROR;
1474: END IF;
1475: HZ_MATCH_RULE_51.find_duplicate_parties(
1476: p_rule_id,p_party_id,
1477: p_restrict_sql,p_match_type,p_dup_batch_id,p_search_merged,x_dup_set_id, x_search_ctx_id,x_num_matches);
1478: -- Code for Match rule BULK MATCH: IDENTICAL PARTIES
1479: ELSIF p_rule_id=52 THEN

Line 1480: IF NOT HZ_MATCH_RULE_52.check_staged THEN

1476: p_rule_id,p_party_id,
1477: p_restrict_sql,p_match_type,p_dup_batch_id,p_search_merged,x_dup_set_id, x_search_ctx_id,x_num_matches);
1478: -- Code for Match rule BULK MATCH: IDENTICAL PARTIES
1479: ELSIF p_rule_id=52 THEN
1480: IF NOT HZ_MATCH_RULE_52.check_staged THEN
1481: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1482: FND_MSG_PUB.ADD;
1483: RAISE FND_API.G_EXC_ERROR;
1484: END IF;

Line 1485: HZ_MATCH_RULE_52.find_duplicate_parties(

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

Line 1490: IF NOT HZ_MATCH_RULE_53.check_staged THEN

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

Line 1495: HZ_MATCH_RULE_53.find_duplicate_parties(

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

Line 1500: IF NOT HZ_MATCH_RULE_58.check_staged THEN

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

Line 1505: HZ_MATCH_RULE_58.find_duplicate_parties(

1501: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1502: FND_MSG_PUB.ADD;
1503: RAISE FND_API.G_EXC_ERROR;
1504: END IF;
1505: HZ_MATCH_RULE_58.find_duplicate_parties(
1506: p_rule_id,p_party_id,
1507: p_restrict_sql,p_match_type,p_dup_batch_id,p_search_merged,x_dup_set_id, x_search_ctx_id,x_num_matches);
1508: -- Code for Match rule HZ_PERSON_ADVANCED_SEARCH_MATCH_RULE
1509: ELSIF p_rule_id=60 THEN

Line 1675: IF NOT HZ_MATCH_RULE_5.check_staged THEN

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
1675: IF NOT HZ_MATCH_RULE_5.check_staged THEN
1676: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1677: FND_MSG_PUB.ADD;
1678: RAISE FND_API.G_EXC_ERROR;
1679: END IF;

Line 1680: HZ_MATCH_RULE_5.find_duplicate_party_sites(

1676: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1677: FND_MSG_PUB.ADD;
1678: RAISE FND_API.G_EXC_ERROR;
1679: END IF;
1680: HZ_MATCH_RULE_5.find_duplicate_party_sites(
1681: p_rule_id,p_party_site_id,p_party_id,
1682: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
1683: -- Code for Match rule SAMPLE: SIMILAR_ORGANIZATION
1684: ELSIF p_rule_id=6 THEN

Line 1835: IF NOT HZ_MATCH_RULE_50.check_staged THEN

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
1835: IF NOT HZ_MATCH_RULE_50.check_staged THEN
1836: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1837: FND_MSG_PUB.ADD;
1838: RAISE FND_API.G_EXC_ERROR;
1839: END IF;

Line 1840: HZ_MATCH_RULE_50.find_duplicate_party_sites(

1836: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1837: FND_MSG_PUB.ADD;
1838: RAISE FND_API.G_EXC_ERROR;
1839: END IF;
1840: HZ_MATCH_RULE_50.find_duplicate_party_sites(
1841: p_rule_id,p_party_site_id,p_party_id,
1842: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
1843: -- Code for Match rule BULK MATCH: IDENTICAL PERSONS
1844: ELSIF p_rule_id=51 THEN

Line 1845: IF NOT HZ_MATCH_RULE_51.check_staged THEN

1841: p_rule_id,p_party_site_id,p_party_id,
1842: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
1843: -- Code for Match rule BULK MATCH: IDENTICAL PERSONS
1844: ELSIF p_rule_id=51 THEN
1845: IF NOT HZ_MATCH_RULE_51.check_staged THEN
1846: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1847: FND_MSG_PUB.ADD;
1848: RAISE FND_API.G_EXC_ERROR;
1849: END IF;

Line 1850: HZ_MATCH_RULE_51.find_duplicate_party_sites(

1846: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1847: FND_MSG_PUB.ADD;
1848: RAISE FND_API.G_EXC_ERROR;
1849: END IF;
1850: HZ_MATCH_RULE_51.find_duplicate_party_sites(
1851: p_rule_id,p_party_site_id,p_party_id,
1852: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
1853: -- Code for Match rule BULK MATCH: IDENTICAL PARTIES
1854: ELSIF p_rule_id=52 THEN

Line 1855: IF NOT HZ_MATCH_RULE_52.check_staged THEN

1851: p_rule_id,p_party_site_id,p_party_id,
1852: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
1853: -- Code for Match rule BULK MATCH: IDENTICAL PARTIES
1854: ELSIF p_rule_id=52 THEN
1855: IF NOT HZ_MATCH_RULE_52.check_staged THEN
1856: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1857: FND_MSG_PUB.ADD;
1858: RAISE FND_API.G_EXC_ERROR;
1859: END IF;

Line 1860: HZ_MATCH_RULE_52.find_duplicate_party_sites(

1856: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1857: FND_MSG_PUB.ADD;
1858: RAISE FND_API.G_EXC_ERROR;
1859: END IF;
1860: HZ_MATCH_RULE_52.find_duplicate_party_sites(
1861: p_rule_id,p_party_site_id,p_party_id,
1862: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
1863: -- Code for Match rule CREDIT MANAGEMENT SEARCH
1864: ELSIF p_rule_id=53 THEN

Line 1865: IF NOT HZ_MATCH_RULE_53.check_staged THEN

1861: p_rule_id,p_party_site_id,p_party_id,
1862: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
1863: -- Code for Match rule CREDIT MANAGEMENT SEARCH
1864: ELSIF p_rule_id=53 THEN
1865: IF NOT HZ_MATCH_RULE_53.check_staged THEN
1866: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1867: FND_MSG_PUB.ADD;
1868: RAISE FND_API.G_EXC_ERROR;
1869: END IF;

Line 1870: HZ_MATCH_RULE_53.find_duplicate_party_sites(

1866: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1867: FND_MSG_PUB.ADD;
1868: RAISE FND_API.G_EXC_ERROR;
1869: END IF;
1870: HZ_MATCH_RULE_53.find_duplicate_party_sites(
1871: p_rule_id,p_party_site_id,p_party_id,
1872: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
1873: -- Code for Match rule HZ_PERSON_SIMPLE_SEARCH_RULE
1874: ELSIF p_rule_id=58 THEN

Line 1875: IF NOT HZ_MATCH_RULE_58.check_staged THEN

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

Line 1880: HZ_MATCH_RULE_58.find_duplicate_party_sites(

1876: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1877: FND_MSG_PUB.ADD;
1878: RAISE FND_API.G_EXC_ERROR;
1879: END IF;
1880: HZ_MATCH_RULE_58.find_duplicate_party_sites(
1881: p_rule_id,p_party_site_id,p_party_id,
1882: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
1883: -- Code for Match rule HZ_PERSON_ADVANCED_SEARCH_MATCH_RULE
1884: ELSIF p_rule_id=60 THEN

Line 2049: IF NOT HZ_MATCH_RULE_5.check_staged THEN

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
2049: IF NOT HZ_MATCH_RULE_5.check_staged THEN
2050: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2051: FND_MSG_PUB.ADD;
2052: RAISE FND_API.G_EXC_ERROR;
2053: END IF;

Line 2054: HZ_MATCH_RULE_5.find_duplicate_contacts(

2050: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2051: FND_MSG_PUB.ADD;
2052: RAISE FND_API.G_EXC_ERROR;
2053: END IF;
2054: HZ_MATCH_RULE_5.find_duplicate_contacts(
2055: p_rule_id,p_org_contact_id,p_party_id,
2056: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2057: -- Code for Match rule SAMPLE: SIMILAR_ORGANIZATION
2058: ELSIF p_rule_id=6 THEN

Line 2209: IF NOT HZ_MATCH_RULE_50.check_staged THEN

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
2209: IF NOT HZ_MATCH_RULE_50.check_staged THEN
2210: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2211: FND_MSG_PUB.ADD;
2212: RAISE FND_API.G_EXC_ERROR;
2213: END IF;

Line 2214: HZ_MATCH_RULE_50.find_duplicate_contacts(

2210: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2211: FND_MSG_PUB.ADD;
2212: RAISE FND_API.G_EXC_ERROR;
2213: END IF;
2214: HZ_MATCH_RULE_50.find_duplicate_contacts(
2215: p_rule_id,p_org_contact_id,p_party_id,
2216: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2217: -- Code for Match rule BULK MATCH: IDENTICAL PERSONS
2218: ELSIF p_rule_id=51 THEN

Line 2219: IF NOT HZ_MATCH_RULE_51.check_staged THEN

2215: p_rule_id,p_org_contact_id,p_party_id,
2216: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2217: -- Code for Match rule BULK MATCH: IDENTICAL PERSONS
2218: ELSIF p_rule_id=51 THEN
2219: IF NOT HZ_MATCH_RULE_51.check_staged THEN
2220: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2221: FND_MSG_PUB.ADD;
2222: RAISE FND_API.G_EXC_ERROR;
2223: END IF;

Line 2224: HZ_MATCH_RULE_51.find_duplicate_contacts(

2220: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2221: FND_MSG_PUB.ADD;
2222: RAISE FND_API.G_EXC_ERROR;
2223: END IF;
2224: HZ_MATCH_RULE_51.find_duplicate_contacts(
2225: p_rule_id,p_org_contact_id,p_party_id,
2226: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2227: -- Code for Match rule BULK MATCH: IDENTICAL PARTIES
2228: ELSIF p_rule_id=52 THEN

Line 2229: IF NOT HZ_MATCH_RULE_52.check_staged THEN

2225: p_rule_id,p_org_contact_id,p_party_id,
2226: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2227: -- Code for Match rule BULK MATCH: IDENTICAL PARTIES
2228: ELSIF p_rule_id=52 THEN
2229: IF NOT HZ_MATCH_RULE_52.check_staged THEN
2230: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2231: FND_MSG_PUB.ADD;
2232: RAISE FND_API.G_EXC_ERROR;
2233: END IF;

Line 2234: HZ_MATCH_RULE_52.find_duplicate_contacts(

2230: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2231: FND_MSG_PUB.ADD;
2232: RAISE FND_API.G_EXC_ERROR;
2233: END IF;
2234: HZ_MATCH_RULE_52.find_duplicate_contacts(
2235: p_rule_id,p_org_contact_id,p_party_id,
2236: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2237: -- Code for Match rule CREDIT MANAGEMENT SEARCH
2238: ELSIF p_rule_id=53 THEN

Line 2239: IF NOT HZ_MATCH_RULE_53.check_staged THEN

2235: p_rule_id,p_org_contact_id,p_party_id,
2236: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2237: -- Code for Match rule CREDIT MANAGEMENT SEARCH
2238: ELSIF p_rule_id=53 THEN
2239: IF NOT HZ_MATCH_RULE_53.check_staged THEN
2240: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2241: FND_MSG_PUB.ADD;
2242: RAISE FND_API.G_EXC_ERROR;
2243: END IF;

Line 2244: HZ_MATCH_RULE_53.find_duplicate_contacts(

2240: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2241: FND_MSG_PUB.ADD;
2242: RAISE FND_API.G_EXC_ERROR;
2243: END IF;
2244: HZ_MATCH_RULE_53.find_duplicate_contacts(
2245: p_rule_id,p_org_contact_id,p_party_id,
2246: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2247: -- Code for Match rule HZ_PERSON_SIMPLE_SEARCH_RULE
2248: ELSIF p_rule_id=58 THEN

Line 2249: IF NOT HZ_MATCH_RULE_58.check_staged THEN

2245: p_rule_id,p_org_contact_id,p_party_id,
2246: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2247: -- Code for Match rule HZ_PERSON_SIMPLE_SEARCH_RULE
2248: ELSIF p_rule_id=58 THEN
2249: IF NOT HZ_MATCH_RULE_58.check_staged THEN
2250: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2251: FND_MSG_PUB.ADD;
2252: RAISE FND_API.G_EXC_ERROR;
2253: END IF;

Line 2254: HZ_MATCH_RULE_58.find_duplicate_contacts(

2250: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2251: FND_MSG_PUB.ADD;
2252: RAISE FND_API.G_EXC_ERROR;
2253: END IF;
2254: HZ_MATCH_RULE_58.find_duplicate_contacts(
2255: p_rule_id,p_org_contact_id,p_party_id,
2256: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2257: -- Code for Match rule HZ_PERSON_ADVANCED_SEARCH_MATCH_RULE
2258: ELSIF p_rule_id=60 THEN

Line 2423: IF NOT HZ_MATCH_RULE_5.check_staged THEN

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
2423: IF NOT HZ_MATCH_RULE_5.check_staged THEN
2424: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2425: FND_MSG_PUB.ADD;
2426: RAISE FND_API.G_EXC_ERROR;
2427: END IF;

Line 2428: HZ_MATCH_RULE_5.find_duplicate_contact_points(

2424: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2425: FND_MSG_PUB.ADD;
2426: RAISE FND_API.G_EXC_ERROR;
2427: END IF;
2428: HZ_MATCH_RULE_5.find_duplicate_contact_points(
2429: p_rule_id,p_contact_point_id,p_party_id,
2430: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2431: -- Code for Match rule SAMPLE: SIMILAR_ORGANIZATION
2432: ELSIF p_rule_id=6 THEN

Line 2583: IF NOT HZ_MATCH_RULE_50.check_staged THEN

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
2583: IF NOT HZ_MATCH_RULE_50.check_staged THEN
2584: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2585: FND_MSG_PUB.ADD;
2586: RAISE FND_API.G_EXC_ERROR;
2587: END IF;

Line 2588: HZ_MATCH_RULE_50.find_duplicate_contact_points(

2584: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2585: FND_MSG_PUB.ADD;
2586: RAISE FND_API.G_EXC_ERROR;
2587: END IF;
2588: HZ_MATCH_RULE_50.find_duplicate_contact_points(
2589: p_rule_id,p_contact_point_id,p_party_id,
2590: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2591: -- Code for Match rule BULK MATCH: IDENTICAL PERSONS
2592: ELSIF p_rule_id=51 THEN

Line 2593: IF NOT HZ_MATCH_RULE_51.check_staged THEN

2589: p_rule_id,p_contact_point_id,p_party_id,
2590: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2591: -- Code for Match rule BULK MATCH: IDENTICAL PERSONS
2592: ELSIF p_rule_id=51 THEN
2593: IF NOT HZ_MATCH_RULE_51.check_staged THEN
2594: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2595: FND_MSG_PUB.ADD;
2596: RAISE FND_API.G_EXC_ERROR;
2597: END IF;

Line 2598: HZ_MATCH_RULE_51.find_duplicate_contact_points(

2594: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2595: FND_MSG_PUB.ADD;
2596: RAISE FND_API.G_EXC_ERROR;
2597: END IF;
2598: HZ_MATCH_RULE_51.find_duplicate_contact_points(
2599: p_rule_id,p_contact_point_id,p_party_id,
2600: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2601: -- Code for Match rule BULK MATCH: IDENTICAL PARTIES
2602: ELSIF p_rule_id=52 THEN

Line 2603: IF NOT HZ_MATCH_RULE_52.check_staged THEN

2599: p_rule_id,p_contact_point_id,p_party_id,
2600: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2601: -- Code for Match rule BULK MATCH: IDENTICAL PARTIES
2602: ELSIF p_rule_id=52 THEN
2603: IF NOT HZ_MATCH_RULE_52.check_staged THEN
2604: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2605: FND_MSG_PUB.ADD;
2606: RAISE FND_API.G_EXC_ERROR;
2607: END IF;

Line 2608: HZ_MATCH_RULE_52.find_duplicate_contact_points(

2604: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2605: FND_MSG_PUB.ADD;
2606: RAISE FND_API.G_EXC_ERROR;
2607: END IF;
2608: HZ_MATCH_RULE_52.find_duplicate_contact_points(
2609: p_rule_id,p_contact_point_id,p_party_id,
2610: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2611: -- Code for Match rule CREDIT MANAGEMENT SEARCH
2612: ELSIF p_rule_id=53 THEN

Line 2613: IF NOT HZ_MATCH_RULE_53.check_staged THEN

2609: p_rule_id,p_contact_point_id,p_party_id,
2610: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2611: -- Code for Match rule CREDIT MANAGEMENT SEARCH
2612: ELSIF p_rule_id=53 THEN
2613: IF NOT HZ_MATCH_RULE_53.check_staged THEN
2614: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2615: FND_MSG_PUB.ADD;
2616: RAISE FND_API.G_EXC_ERROR;
2617: END IF;

Line 2618: HZ_MATCH_RULE_53.find_duplicate_contact_points(

2614: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2615: FND_MSG_PUB.ADD;
2616: RAISE FND_API.G_EXC_ERROR;
2617: END IF;
2618: HZ_MATCH_RULE_53.find_duplicate_contact_points(
2619: p_rule_id,p_contact_point_id,p_party_id,
2620: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2621: -- Code for Match rule HZ_PERSON_SIMPLE_SEARCH_RULE
2622: ELSIF p_rule_id=58 THEN

Line 2623: IF NOT HZ_MATCH_RULE_58.check_staged THEN

2619: p_rule_id,p_contact_point_id,p_party_id,
2620: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2621: -- Code for Match rule HZ_PERSON_SIMPLE_SEARCH_RULE
2622: ELSIF p_rule_id=58 THEN
2623: IF NOT HZ_MATCH_RULE_58.check_staged THEN
2624: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2625: FND_MSG_PUB.ADD;
2626: RAISE FND_API.G_EXC_ERROR;
2627: END IF;

Line 2628: HZ_MATCH_RULE_58.find_duplicate_contact_points(

2624: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2625: FND_MSG_PUB.ADD;
2626: RAISE FND_API.G_EXC_ERROR;
2627: END IF;
2628: HZ_MATCH_RULE_58.find_duplicate_contact_points(
2629: p_rule_id,p_contact_point_id,p_party_id,
2630: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2631: -- Code for Match rule HZ_PERSON_ADVANCED_SEARCH_MATCH_RULE
2632: ELSIF p_rule_id=60 THEN

Line 2861: IF NOT HZ_MATCH_RULE_5.check_staged THEN

2857: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
2858: p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
2859: -- Code for Match rule SAMPLE: ADDRESS_PERSONS
2860: ELSIF p_rule_id=5 THEN
2861: IF NOT HZ_MATCH_RULE_5.check_staged THEN
2862: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2863: FND_MSG_PUB.ADD;
2864: RAISE FND_API.G_EXC_ERROR;
2865: END IF;

Line 2866: HZ_MATCH_RULE_5.find_parties_dynamic(

2862: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2863: FND_MSG_PUB.ADD;
2864: RAISE FND_API.G_EXC_ERROR;
2865: END IF;
2866: HZ_MATCH_RULE_5.find_parties_dynamic(
2867: p_rule_id,
2868: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
2869: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
2870: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 3149: IF NOT HZ_MATCH_RULE_50.check_staged THEN

3145: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3146: p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
3147: -- Code for Match rule BULK MATCH: IDENTICAL ORGANIZATIONS
3148: ELSIF p_rule_id=50 THEN
3149: IF NOT HZ_MATCH_RULE_50.check_staged THEN
3150: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3151: FND_MSG_PUB.ADD;
3152: RAISE FND_API.G_EXC_ERROR;
3153: END IF;

Line 3154: HZ_MATCH_RULE_50.find_parties_dynamic(

3150: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3151: FND_MSG_PUB.ADD;
3152: RAISE FND_API.G_EXC_ERROR;
3153: END IF;
3154: HZ_MATCH_RULE_50.find_parties_dynamic(
3155: p_rule_id,
3156: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
3157: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
3158: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 3167: IF NOT HZ_MATCH_RULE_51.check_staged THEN

3163: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3164: p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
3165: -- Code for Match rule BULK MATCH: IDENTICAL PERSONS
3166: ELSIF p_rule_id=51 THEN
3167: IF NOT HZ_MATCH_RULE_51.check_staged THEN
3168: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3169: FND_MSG_PUB.ADD;
3170: RAISE FND_API.G_EXC_ERROR;
3171: END IF;

Line 3172: HZ_MATCH_RULE_51.find_parties_dynamic(

3168: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3169: FND_MSG_PUB.ADD;
3170: RAISE FND_API.G_EXC_ERROR;
3171: END IF;
3172: HZ_MATCH_RULE_51.find_parties_dynamic(
3173: p_rule_id,
3174: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
3175: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
3176: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 3185: IF NOT HZ_MATCH_RULE_52.check_staged THEN

3181: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3182: p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
3183: -- Code for Match rule BULK MATCH: IDENTICAL PARTIES
3184: ELSIF p_rule_id=52 THEN
3185: IF NOT HZ_MATCH_RULE_52.check_staged THEN
3186: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3187: FND_MSG_PUB.ADD;
3188: RAISE FND_API.G_EXC_ERROR;
3189: END IF;

Line 3190: HZ_MATCH_RULE_52.find_parties_dynamic(

3186: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3187: FND_MSG_PUB.ADD;
3188: RAISE FND_API.G_EXC_ERROR;
3189: END IF;
3190: HZ_MATCH_RULE_52.find_parties_dynamic(
3191: p_rule_id,
3192: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
3193: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
3194: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 3203: IF NOT HZ_MATCH_RULE_53.check_staged THEN

3199: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3200: p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
3201: -- Code for Match rule CREDIT MANAGEMENT SEARCH
3202: ELSIF p_rule_id=53 THEN
3203: IF NOT HZ_MATCH_RULE_53.check_staged THEN
3204: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3205: FND_MSG_PUB.ADD;
3206: RAISE FND_API.G_EXC_ERROR;
3207: END IF;

Line 3208: HZ_MATCH_RULE_53.find_parties_dynamic(

3204: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3205: FND_MSG_PUB.ADD;
3206: RAISE FND_API.G_EXC_ERROR;
3207: END IF;
3208: HZ_MATCH_RULE_53.find_parties_dynamic(
3209: p_rule_id,
3210: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
3211: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
3212: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 3221: IF NOT HZ_MATCH_RULE_58.check_staged THEN

3217: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3218: p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
3219: -- Code for Match rule HZ_PERSON_SIMPLE_SEARCH_RULE
3220: ELSIF p_rule_id=58 THEN
3221: IF NOT HZ_MATCH_RULE_58.check_staged THEN
3222: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3223: FND_MSG_PUB.ADD;
3224: RAISE FND_API.G_EXC_ERROR;
3225: END IF;

Line 3226: HZ_MATCH_RULE_58.find_parties_dynamic(

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

Line 3508: IF NOT HZ_MATCH_RULE_5.check_staged THEN

3504: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3505: p_restrict_sql,p_api_name,p_match_type,p_party_id,p_search_merged,x_search_ctx_id,x_num_matches);
3506: -- Code for Match rule SAMPLE: ADDRESS_PERSONS
3507: ELSIF p_rule_id=5 THEN
3508: IF NOT HZ_MATCH_RULE_5.check_staged THEN
3509: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3510: FND_MSG_PUB.ADD;
3511: RAISE FND_API.G_EXC_ERROR;
3512: END IF;

Line 3513: HZ_MATCH_RULE_5.call_api_dynamic(

3509: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3510: FND_MSG_PUB.ADD;
3511: RAISE FND_API.G_EXC_ERROR;
3512: END IF;
3513: HZ_MATCH_RULE_5.call_api_dynamic(
3514: p_rule_id,
3515: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
3516: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
3517: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 3796: IF NOT HZ_MATCH_RULE_50.check_staged THEN

3792: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3793: p_restrict_sql,p_api_name,p_match_type,p_party_id,p_search_merged,x_search_ctx_id,x_num_matches);
3794: -- Code for Match rule BULK MATCH: IDENTICAL ORGANIZATIONS
3795: ELSIF p_rule_id=50 THEN
3796: IF NOT HZ_MATCH_RULE_50.check_staged THEN
3797: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3798: FND_MSG_PUB.ADD;
3799: RAISE FND_API.G_EXC_ERROR;
3800: END IF;

Line 3801: HZ_MATCH_RULE_50.call_api_dynamic(

3797: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3798: FND_MSG_PUB.ADD;
3799: RAISE FND_API.G_EXC_ERROR;
3800: END IF;
3801: HZ_MATCH_RULE_50.call_api_dynamic(
3802: p_rule_id,
3803: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
3804: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
3805: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 3814: IF NOT HZ_MATCH_RULE_51.check_staged THEN

3810: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3811: p_restrict_sql,p_api_name,p_match_type,p_party_id,p_search_merged,x_search_ctx_id,x_num_matches);
3812: -- Code for Match rule BULK MATCH: IDENTICAL PERSONS
3813: ELSIF p_rule_id=51 THEN
3814: IF NOT HZ_MATCH_RULE_51.check_staged THEN
3815: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3816: FND_MSG_PUB.ADD;
3817: RAISE FND_API.G_EXC_ERROR;
3818: END IF;

Line 3819: HZ_MATCH_RULE_51.call_api_dynamic(

3815: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3816: FND_MSG_PUB.ADD;
3817: RAISE FND_API.G_EXC_ERROR;
3818: END IF;
3819: HZ_MATCH_RULE_51.call_api_dynamic(
3820: p_rule_id,
3821: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
3822: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
3823: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 3832: IF NOT HZ_MATCH_RULE_52.check_staged THEN

3828: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3829: p_restrict_sql,p_api_name,p_match_type,p_party_id,p_search_merged,x_search_ctx_id,x_num_matches);
3830: -- Code for Match rule BULK MATCH: IDENTICAL PARTIES
3831: ELSIF p_rule_id=52 THEN
3832: IF NOT HZ_MATCH_RULE_52.check_staged THEN
3833: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3834: FND_MSG_PUB.ADD;
3835: RAISE FND_API.G_EXC_ERROR;
3836: END IF;

Line 3837: HZ_MATCH_RULE_52.call_api_dynamic(

3833: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3834: FND_MSG_PUB.ADD;
3835: RAISE FND_API.G_EXC_ERROR;
3836: END IF;
3837: HZ_MATCH_RULE_52.call_api_dynamic(
3838: p_rule_id,
3839: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
3840: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
3841: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 3850: IF NOT HZ_MATCH_RULE_53.check_staged THEN

3846: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3847: p_restrict_sql,p_api_name,p_match_type,p_party_id,p_search_merged,x_search_ctx_id,x_num_matches);
3848: -- Code for Match rule CREDIT MANAGEMENT SEARCH
3849: ELSIF p_rule_id=53 THEN
3850: IF NOT HZ_MATCH_RULE_53.check_staged THEN
3851: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3852: FND_MSG_PUB.ADD;
3853: RAISE FND_API.G_EXC_ERROR;
3854: END IF;

Line 3855: HZ_MATCH_RULE_53.call_api_dynamic(

3851: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3852: FND_MSG_PUB.ADD;
3853: RAISE FND_API.G_EXC_ERROR;
3854: END IF;
3855: HZ_MATCH_RULE_53.call_api_dynamic(
3856: p_rule_id,
3857: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
3858: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
3859: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 3868: IF NOT HZ_MATCH_RULE_58.check_staged THEN

3864: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3865: p_restrict_sql,p_api_name,p_match_type,p_party_id,p_search_merged,x_search_ctx_id,x_num_matches);
3866: -- Code for Match rule HZ_PERSON_SIMPLE_SEARCH_RULE
3867: ELSIF p_rule_id=58 THEN
3868: IF NOT HZ_MATCH_RULE_58.check_staged THEN
3869: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3870: FND_MSG_PUB.ADD;
3871: RAISE FND_API.G_EXC_ERROR;
3872: END IF;

Line 3873: HZ_MATCH_RULE_58.call_api_dynamic(

3869: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3870: FND_MSG_PUB.ADD;
3871: RAISE FND_API.G_EXC_ERROR;
3872: END IF;
3873: HZ_MATCH_RULE_58.call_api_dynamic(
3874: p_rule_id,
3875: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
3876: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
3877: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 4322: IF NOT HZ_MATCH_RULE_5.check_staged THEN

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
4322: IF NOT HZ_MATCH_RULE_5.check_staged THEN
4323: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4324: FND_MSG_PUB.ADD;
4325: RAISE FND_API.G_EXC_ERROR;
4326: END IF;

Line 4327: HZ_MATCH_RULE_5.get_matching_party_sites(

4323: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4324: FND_MSG_PUB.ADD;
4325: RAISE FND_API.G_EXC_ERROR;
4326: END IF;
4327: HZ_MATCH_RULE_5.get_matching_party_sites(
4328: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4329: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4330: -- Code for Match rule SAMPLE: SIMILAR_ORGANIZATION
4331: ELSIF p_rule_id=6 THEN

Line 4482: IF NOT HZ_MATCH_RULE_50.check_staged THEN

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
4482: IF NOT HZ_MATCH_RULE_50.check_staged THEN
4483: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4484: FND_MSG_PUB.ADD;
4485: RAISE FND_API.G_EXC_ERROR;
4486: END IF;

Line 4487: HZ_MATCH_RULE_50.get_matching_party_sites(

4483: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4484: FND_MSG_PUB.ADD;
4485: RAISE FND_API.G_EXC_ERROR;
4486: END IF;
4487: HZ_MATCH_RULE_50.get_matching_party_sites(
4488: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4489: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4490: -- Code for Match rule BULK MATCH: IDENTICAL PERSONS
4491: ELSIF p_rule_id=51 THEN

Line 4492: IF NOT HZ_MATCH_RULE_51.check_staged THEN

4488: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4489: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4490: -- Code for Match rule BULK MATCH: IDENTICAL PERSONS
4491: ELSIF p_rule_id=51 THEN
4492: IF NOT HZ_MATCH_RULE_51.check_staged THEN
4493: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4494: FND_MSG_PUB.ADD;
4495: RAISE FND_API.G_EXC_ERROR;
4496: END IF;

Line 4497: HZ_MATCH_RULE_51.get_matching_party_sites(

4493: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4494: FND_MSG_PUB.ADD;
4495: RAISE FND_API.G_EXC_ERROR;
4496: END IF;
4497: HZ_MATCH_RULE_51.get_matching_party_sites(
4498: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4499: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4500: -- Code for Match rule BULK MATCH: IDENTICAL PARTIES
4501: ELSIF p_rule_id=52 THEN

Line 4502: IF NOT HZ_MATCH_RULE_52.check_staged THEN

4498: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4499: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4500: -- Code for Match rule BULK MATCH: IDENTICAL PARTIES
4501: ELSIF p_rule_id=52 THEN
4502: IF NOT HZ_MATCH_RULE_52.check_staged THEN
4503: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4504: FND_MSG_PUB.ADD;
4505: RAISE FND_API.G_EXC_ERROR;
4506: END IF;

Line 4507: HZ_MATCH_RULE_52.get_matching_party_sites(

4503: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4504: FND_MSG_PUB.ADD;
4505: RAISE FND_API.G_EXC_ERROR;
4506: END IF;
4507: HZ_MATCH_RULE_52.get_matching_party_sites(
4508: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4509: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4510: -- Code for Match rule CREDIT MANAGEMENT SEARCH
4511: ELSIF p_rule_id=53 THEN

Line 4512: IF NOT HZ_MATCH_RULE_53.check_staged THEN

4508: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4509: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4510: -- Code for Match rule CREDIT MANAGEMENT SEARCH
4511: ELSIF p_rule_id=53 THEN
4512: IF NOT HZ_MATCH_RULE_53.check_staged THEN
4513: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4514: FND_MSG_PUB.ADD;
4515: RAISE FND_API.G_EXC_ERROR;
4516: END IF;

Line 4517: HZ_MATCH_RULE_53.get_matching_party_sites(

4513: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4514: FND_MSG_PUB.ADD;
4515: RAISE FND_API.G_EXC_ERROR;
4516: END IF;
4517: HZ_MATCH_RULE_53.get_matching_party_sites(
4518: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4519: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4520: -- Code for Match rule HZ_PERSON_SIMPLE_SEARCH_RULE
4521: ELSIF p_rule_id=58 THEN

Line 4522: IF NOT HZ_MATCH_RULE_58.check_staged THEN

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

Line 4527: HZ_MATCH_RULE_58.get_matching_party_sites(

4523: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4524: FND_MSG_PUB.ADD;
4525: RAISE FND_API.G_EXC_ERROR;
4526: END IF;
4527: HZ_MATCH_RULE_58.get_matching_party_sites(
4528: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4529: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4530: -- Code for Match rule HZ_PERSON_ADVANCED_SEARCH_MATCH_RULE
4531: ELSIF p_rule_id=60 THEN

Line 4721: IF NOT HZ_MATCH_RULE_5.check_staged THEN

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
4721: IF NOT HZ_MATCH_RULE_5.check_staged THEN
4722: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4723: FND_MSG_PUB.ADD;
4724: RAISE FND_API.G_EXC_ERROR;
4725: END IF;

Line 4726: HZ_MATCH_RULE_5.get_matching_contacts(

4722: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4723: FND_MSG_PUB.ADD;
4724: RAISE FND_API.G_EXC_ERROR;
4725: END IF;
4726: HZ_MATCH_RULE_5.get_matching_contacts(
4727: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
4728: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4729: -- Code for Match rule SAMPLE: SIMILAR_ORGANIZATION
4730: ELSIF p_rule_id=6 THEN

Line 4881: IF NOT HZ_MATCH_RULE_50.check_staged THEN

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
4881: IF NOT HZ_MATCH_RULE_50.check_staged THEN
4882: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4883: FND_MSG_PUB.ADD;
4884: RAISE FND_API.G_EXC_ERROR;
4885: END IF;

Line 4886: HZ_MATCH_RULE_50.get_matching_contacts(

4882: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4883: FND_MSG_PUB.ADD;
4884: RAISE FND_API.G_EXC_ERROR;
4885: END IF;
4886: HZ_MATCH_RULE_50.get_matching_contacts(
4887: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
4888: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4889: -- Code for Match rule BULK MATCH: IDENTICAL PERSONS
4890: ELSIF p_rule_id=51 THEN

Line 4891: IF NOT HZ_MATCH_RULE_51.check_staged THEN

4887: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
4888: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4889: -- Code for Match rule BULK MATCH: IDENTICAL PERSONS
4890: ELSIF p_rule_id=51 THEN
4891: IF NOT HZ_MATCH_RULE_51.check_staged THEN
4892: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4893: FND_MSG_PUB.ADD;
4894: RAISE FND_API.G_EXC_ERROR;
4895: END IF;

Line 4896: HZ_MATCH_RULE_51.get_matching_contacts(

4892: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4893: FND_MSG_PUB.ADD;
4894: RAISE FND_API.G_EXC_ERROR;
4895: END IF;
4896: HZ_MATCH_RULE_51.get_matching_contacts(
4897: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
4898: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4899: -- Code for Match rule BULK MATCH: IDENTICAL PARTIES
4900: ELSIF p_rule_id=52 THEN

Line 4901: IF NOT HZ_MATCH_RULE_52.check_staged THEN

4897: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
4898: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4899: -- Code for Match rule BULK MATCH: IDENTICAL PARTIES
4900: ELSIF p_rule_id=52 THEN
4901: IF NOT HZ_MATCH_RULE_52.check_staged THEN
4902: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4903: FND_MSG_PUB.ADD;
4904: RAISE FND_API.G_EXC_ERROR;
4905: END IF;

Line 4906: HZ_MATCH_RULE_52.get_matching_contacts(

4902: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4903: FND_MSG_PUB.ADD;
4904: RAISE FND_API.G_EXC_ERROR;
4905: END IF;
4906: HZ_MATCH_RULE_52.get_matching_contacts(
4907: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
4908: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4909: -- Code for Match rule CREDIT MANAGEMENT SEARCH
4910: ELSIF p_rule_id=53 THEN

Line 4911: IF NOT HZ_MATCH_RULE_53.check_staged THEN

4907: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
4908: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4909: -- Code for Match rule CREDIT MANAGEMENT SEARCH
4910: ELSIF p_rule_id=53 THEN
4911: IF NOT HZ_MATCH_RULE_53.check_staged THEN
4912: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4913: FND_MSG_PUB.ADD;
4914: RAISE FND_API.G_EXC_ERROR;
4915: END IF;

Line 4916: HZ_MATCH_RULE_53.get_matching_contacts(

4912: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4913: FND_MSG_PUB.ADD;
4914: RAISE FND_API.G_EXC_ERROR;
4915: END IF;
4916: HZ_MATCH_RULE_53.get_matching_contacts(
4917: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
4918: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4919: -- Code for Match rule HZ_PERSON_SIMPLE_SEARCH_RULE
4920: ELSIF p_rule_id=58 THEN

Line 4921: IF NOT HZ_MATCH_RULE_58.check_staged THEN

4917: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
4918: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4919: -- Code for Match rule HZ_PERSON_SIMPLE_SEARCH_RULE
4920: ELSIF p_rule_id=58 THEN
4921: IF NOT HZ_MATCH_RULE_58.check_staged THEN
4922: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4923: FND_MSG_PUB.ADD;
4924: RAISE FND_API.G_EXC_ERROR;
4925: END IF;

Line 4926: HZ_MATCH_RULE_58.get_matching_contacts(

4922: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4923: FND_MSG_PUB.ADD;
4924: RAISE FND_API.G_EXC_ERROR;
4925: END IF;
4926: HZ_MATCH_RULE_58.get_matching_contacts(
4927: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
4928: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4929: -- Code for Match rule HZ_PERSON_ADVANCED_SEARCH_MATCH_RULE
4930: ELSIF p_rule_id=60 THEN

Line 5118: IF NOT HZ_MATCH_RULE_5.check_staged THEN

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
5118: IF NOT HZ_MATCH_RULE_5.check_staged THEN
5119: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5120: FND_MSG_PUB.ADD;
5121: RAISE FND_API.G_EXC_ERROR;
5122: END IF;

Line 5123: HZ_MATCH_RULE_5.get_matching_contact_points(

5119: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5120: FND_MSG_PUB.ADD;
5121: RAISE FND_API.G_EXC_ERROR;
5122: END IF;
5123: HZ_MATCH_RULE_5.get_matching_contact_points(
5124: p_rule_id, p_party_id, p_contact_point_list,
5125: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5126: -- Code for Match rule SAMPLE: SIMILAR_ORGANIZATION
5127: ELSIF p_rule_id=6 THEN

Line 5278: IF NOT HZ_MATCH_RULE_50.check_staged THEN

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
5278: IF NOT HZ_MATCH_RULE_50.check_staged THEN
5279: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5280: FND_MSG_PUB.ADD;
5281: RAISE FND_API.G_EXC_ERROR;
5282: END IF;

Line 5283: HZ_MATCH_RULE_50.get_matching_contact_points(

5279: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5280: FND_MSG_PUB.ADD;
5281: RAISE FND_API.G_EXC_ERROR;
5282: END IF;
5283: HZ_MATCH_RULE_50.get_matching_contact_points(
5284: p_rule_id, p_party_id, p_contact_point_list,
5285: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5286: -- Code for Match rule BULK MATCH: IDENTICAL PERSONS
5287: ELSIF p_rule_id=51 THEN

Line 5288: IF NOT HZ_MATCH_RULE_51.check_staged THEN

5284: p_rule_id, p_party_id, p_contact_point_list,
5285: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5286: -- Code for Match rule BULK MATCH: IDENTICAL PERSONS
5287: ELSIF p_rule_id=51 THEN
5288: IF NOT HZ_MATCH_RULE_51.check_staged THEN
5289: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5290: FND_MSG_PUB.ADD;
5291: RAISE FND_API.G_EXC_ERROR;
5292: END IF;

Line 5293: HZ_MATCH_RULE_51.get_matching_contact_points(

5289: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5290: FND_MSG_PUB.ADD;
5291: RAISE FND_API.G_EXC_ERROR;
5292: END IF;
5293: HZ_MATCH_RULE_51.get_matching_contact_points(
5294: p_rule_id, p_party_id, p_contact_point_list,
5295: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5296: -- Code for Match rule BULK MATCH: IDENTICAL PARTIES
5297: ELSIF p_rule_id=52 THEN

Line 5298: IF NOT HZ_MATCH_RULE_52.check_staged THEN

5294: p_rule_id, p_party_id, p_contact_point_list,
5295: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5296: -- Code for Match rule BULK MATCH: IDENTICAL PARTIES
5297: ELSIF p_rule_id=52 THEN
5298: IF NOT HZ_MATCH_RULE_52.check_staged THEN
5299: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5300: FND_MSG_PUB.ADD;
5301: RAISE FND_API.G_EXC_ERROR;
5302: END IF;

Line 5303: HZ_MATCH_RULE_52.get_matching_contact_points(

5299: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5300: FND_MSG_PUB.ADD;
5301: RAISE FND_API.G_EXC_ERROR;
5302: END IF;
5303: HZ_MATCH_RULE_52.get_matching_contact_points(
5304: p_rule_id, p_party_id, p_contact_point_list,
5305: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5306: -- Code for Match rule CREDIT MANAGEMENT SEARCH
5307: ELSIF p_rule_id=53 THEN

Line 5308: IF NOT HZ_MATCH_RULE_53.check_staged THEN

5304: p_rule_id, p_party_id, p_contact_point_list,
5305: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5306: -- Code for Match rule CREDIT MANAGEMENT SEARCH
5307: ELSIF p_rule_id=53 THEN
5308: IF NOT HZ_MATCH_RULE_53.check_staged THEN
5309: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5310: FND_MSG_PUB.ADD;
5311: RAISE FND_API.G_EXC_ERROR;
5312: END IF;

Line 5313: HZ_MATCH_RULE_53.get_matching_contact_points(

5309: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5310: FND_MSG_PUB.ADD;
5311: RAISE FND_API.G_EXC_ERROR;
5312: END IF;
5313: HZ_MATCH_RULE_53.get_matching_contact_points(
5314: p_rule_id, p_party_id, p_contact_point_list,
5315: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5316: -- Code for Match rule HZ_PERSON_SIMPLE_SEARCH_RULE
5317: ELSIF p_rule_id=58 THEN

Line 5318: IF NOT HZ_MATCH_RULE_58.check_staged THEN

5314: p_rule_id, p_party_id, p_contact_point_list,
5315: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5316: -- Code for Match rule HZ_PERSON_SIMPLE_SEARCH_RULE
5317: ELSIF p_rule_id=58 THEN
5318: IF NOT HZ_MATCH_RULE_58.check_staged THEN
5319: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5320: FND_MSG_PUB.ADD;
5321: RAISE FND_API.G_EXC_ERROR;
5322: END IF;

Line 5323: HZ_MATCH_RULE_58.get_matching_contact_points(

5319: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5320: FND_MSG_PUB.ADD;
5321: RAISE FND_API.G_EXC_ERROR;
5322: END IF;
5323: HZ_MATCH_RULE_58.get_matching_contact_points(
5324: p_rule_id, p_party_id, p_contact_point_list,
5325: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5326: -- Code for Match rule HZ_PERSON_ADVANCED_SEARCH_MATCH_RULE
5327: ELSIF p_rule_id=60 THEN

Line 5521: IF NOT HZ_MATCH_RULE_5.check_staged THEN

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
5520: ELSIF p_rule_id=5 THEN
5521: IF NOT HZ_MATCH_RULE_5.check_staged THEN
5522: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5523: FND_MSG_PUB.ADD;
5524: RAISE FND_API.G_EXC_ERROR;
5525: END IF;

Line 5526: HZ_MATCH_RULE_5.get_score_details(

5522: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5523: FND_MSG_PUB.ADD;
5524: RAISE FND_API.G_EXC_ERROR;
5525: END IF;
5526: HZ_MATCH_RULE_5.get_score_details(
5527: p_rule_id,
5528: p_party_id, p_party_search_rec,p_party_site_list,
5529: p_contact_list, p_contact_point_list,x_search_ctx_id);
5530: -- Code for Match rule SAMPLE: SIMILAR_ORGANIZATION

Line 5697: IF NOT HZ_MATCH_RULE_50.check_staged THEN

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
5696: ELSIF p_rule_id=50 THEN
5697: IF NOT HZ_MATCH_RULE_50.check_staged THEN
5698: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5699: FND_MSG_PUB.ADD;
5700: RAISE FND_API.G_EXC_ERROR;
5701: END IF;

Line 5702: HZ_MATCH_RULE_50.get_score_details(

5698: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5699: FND_MSG_PUB.ADD;
5700: RAISE FND_API.G_EXC_ERROR;
5701: END IF;
5702: HZ_MATCH_RULE_50.get_score_details(
5703: p_rule_id,
5704: p_party_id, p_party_search_rec,p_party_site_list,
5705: p_contact_list, p_contact_point_list,x_search_ctx_id);
5706: -- Code for Match rule BULK MATCH: IDENTICAL PERSONS

Line 5708: IF NOT HZ_MATCH_RULE_51.check_staged THEN

5704: p_party_id, p_party_search_rec,p_party_site_list,
5705: p_contact_list, p_contact_point_list,x_search_ctx_id);
5706: -- Code for Match rule BULK MATCH: IDENTICAL PERSONS
5707: ELSIF p_rule_id=51 THEN
5708: IF NOT HZ_MATCH_RULE_51.check_staged THEN
5709: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5710: FND_MSG_PUB.ADD;
5711: RAISE FND_API.G_EXC_ERROR;
5712: END IF;

Line 5713: HZ_MATCH_RULE_51.get_score_details(

5709: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5710: FND_MSG_PUB.ADD;
5711: RAISE FND_API.G_EXC_ERROR;
5712: END IF;
5713: HZ_MATCH_RULE_51.get_score_details(
5714: p_rule_id,
5715: p_party_id, p_party_search_rec,p_party_site_list,
5716: p_contact_list, p_contact_point_list,x_search_ctx_id);
5717: -- Code for Match rule BULK MATCH: IDENTICAL PARTIES

Line 5719: IF NOT HZ_MATCH_RULE_52.check_staged THEN

5715: p_party_id, p_party_search_rec,p_party_site_list,
5716: p_contact_list, p_contact_point_list,x_search_ctx_id);
5717: -- Code for Match rule BULK MATCH: IDENTICAL PARTIES
5718: ELSIF p_rule_id=52 THEN
5719: IF NOT HZ_MATCH_RULE_52.check_staged THEN
5720: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5721: FND_MSG_PUB.ADD;
5722: RAISE FND_API.G_EXC_ERROR;
5723: END IF;

Line 5724: HZ_MATCH_RULE_52.get_score_details(

5720: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5721: FND_MSG_PUB.ADD;
5722: RAISE FND_API.G_EXC_ERROR;
5723: END IF;
5724: HZ_MATCH_RULE_52.get_score_details(
5725: p_rule_id,
5726: p_party_id, p_party_search_rec,p_party_site_list,
5727: p_contact_list, p_contact_point_list,x_search_ctx_id);
5728: -- Code for Match rule CREDIT MANAGEMENT SEARCH

Line 5730: IF NOT HZ_MATCH_RULE_53.check_staged THEN

5726: p_party_id, p_party_search_rec,p_party_site_list,
5727: p_contact_list, p_contact_point_list,x_search_ctx_id);
5728: -- Code for Match rule CREDIT MANAGEMENT SEARCH
5729: ELSIF p_rule_id=53 THEN
5730: IF NOT HZ_MATCH_RULE_53.check_staged THEN
5731: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5732: FND_MSG_PUB.ADD;
5733: RAISE FND_API.G_EXC_ERROR;
5734: END IF;

Line 5735: HZ_MATCH_RULE_53.get_score_details(

5731: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5732: FND_MSG_PUB.ADD;
5733: RAISE FND_API.G_EXC_ERROR;
5734: END IF;
5735: HZ_MATCH_RULE_53.get_score_details(
5736: p_rule_id,
5737: p_party_id, p_party_search_rec,p_party_site_list,
5738: p_contact_list, p_contact_point_list,x_search_ctx_id);
5739: -- Code for Match rule HZ_PERSON_SIMPLE_SEARCH_RULE

Line 5741: IF NOT HZ_MATCH_RULE_58.check_staged THEN

5737: p_party_id, p_party_search_rec,p_party_site_list,
5738: p_contact_list, p_contact_point_list,x_search_ctx_id);
5739: -- Code for Match rule HZ_PERSON_SIMPLE_SEARCH_RULE
5740: ELSIF p_rule_id=58 THEN
5741: IF NOT HZ_MATCH_RULE_58.check_staged THEN
5742: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5743: FND_MSG_PUB.ADD;
5744: RAISE FND_API.G_EXC_ERROR;
5745: END IF;

Line 5746: HZ_MATCH_RULE_58.get_score_details(

5742: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5743: FND_MSG_PUB.ADD;
5744: RAISE FND_API.G_EXC_ERROR;
5745: END IF;
5746: HZ_MATCH_RULE_58.get_score_details(
5747: p_rule_id,
5748: p_party_id, p_party_search_rec,p_party_site_list,
5749: p_contact_list, p_contact_point_list,x_search_ctx_id);
5750: -- Code for Match rule HZ_PERSON_ADVANCED_SEARCH_MATCH_RULE

Line 5916: IF NOT HZ_MATCH_RULE_5.check_staged THEN

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
5916: IF NOT HZ_MATCH_RULE_5.check_staged THEN
5917: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5918: FND_MSG_PUB.ADD;
5919: RAISE FND_API.G_EXC_ERROR;
5920: END IF;

Line 5921: HZ_MATCH_RULE_5.get_party_for_search(

5917: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5918: FND_MSG_PUB.ADD;
5919: RAISE FND_API.G_EXC_ERROR;
5920: END IF;
5921: HZ_MATCH_RULE_5.get_party_for_search(
5922: p_party_id, x_party_search_rec,x_party_site_list,
5923: x_contact_list, x_contact_point_list);
5924: -- Code for Match rule SAMPLE: SIMILAR_ORGANIZATION
5925: ELSIF p_rule_id=6 THEN

Line 6076: IF NOT HZ_MATCH_RULE_50.check_staged THEN

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
6076: IF NOT HZ_MATCH_RULE_50.check_staged THEN
6077: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6078: FND_MSG_PUB.ADD;
6079: RAISE FND_API.G_EXC_ERROR;
6080: END IF;

Line 6081: HZ_MATCH_RULE_50.get_party_for_search(

6077: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6078: FND_MSG_PUB.ADD;
6079: RAISE FND_API.G_EXC_ERROR;
6080: END IF;
6081: HZ_MATCH_RULE_50.get_party_for_search(
6082: p_party_id, x_party_search_rec,x_party_site_list,
6083: x_contact_list, x_contact_point_list);
6084: -- Code for Match rule BULK MATCH: IDENTICAL PERSONS
6085: ELSIF p_rule_id=51 THEN

Line 6086: IF NOT HZ_MATCH_RULE_51.check_staged THEN

6082: p_party_id, x_party_search_rec,x_party_site_list,
6083: x_contact_list, x_contact_point_list);
6084: -- Code for Match rule BULK MATCH: IDENTICAL PERSONS
6085: ELSIF p_rule_id=51 THEN
6086: IF NOT HZ_MATCH_RULE_51.check_staged THEN
6087: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6088: FND_MSG_PUB.ADD;
6089: RAISE FND_API.G_EXC_ERROR;
6090: END IF;

Line 6091: HZ_MATCH_RULE_51.get_party_for_search(

6087: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6088: FND_MSG_PUB.ADD;
6089: RAISE FND_API.G_EXC_ERROR;
6090: END IF;
6091: HZ_MATCH_RULE_51.get_party_for_search(
6092: p_party_id, x_party_search_rec,x_party_site_list,
6093: x_contact_list, x_contact_point_list);
6094: -- Code for Match rule BULK MATCH: IDENTICAL PARTIES
6095: ELSIF p_rule_id=52 THEN

Line 6096: IF NOT HZ_MATCH_RULE_52.check_staged THEN

6092: p_party_id, x_party_search_rec,x_party_site_list,
6093: x_contact_list, x_contact_point_list);
6094: -- Code for Match rule BULK MATCH: IDENTICAL PARTIES
6095: ELSIF p_rule_id=52 THEN
6096: IF NOT HZ_MATCH_RULE_52.check_staged THEN
6097: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6098: FND_MSG_PUB.ADD;
6099: RAISE FND_API.G_EXC_ERROR;
6100: END IF;

Line 6101: HZ_MATCH_RULE_52.get_party_for_search(

6097: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6098: FND_MSG_PUB.ADD;
6099: RAISE FND_API.G_EXC_ERROR;
6100: END IF;
6101: HZ_MATCH_RULE_52.get_party_for_search(
6102: p_party_id, x_party_search_rec,x_party_site_list,
6103: x_contact_list, x_contact_point_list);
6104: -- Code for Match rule CREDIT MANAGEMENT SEARCH
6105: ELSIF p_rule_id=53 THEN

Line 6106: IF NOT HZ_MATCH_RULE_53.check_staged THEN

6102: p_party_id, x_party_search_rec,x_party_site_list,
6103: x_contact_list, x_contact_point_list);
6104: -- Code for Match rule CREDIT MANAGEMENT SEARCH
6105: ELSIF p_rule_id=53 THEN
6106: IF NOT HZ_MATCH_RULE_53.check_staged THEN
6107: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6108: FND_MSG_PUB.ADD;
6109: RAISE FND_API.G_EXC_ERROR;
6110: END IF;

Line 6111: HZ_MATCH_RULE_53.get_party_for_search(

6107: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6108: FND_MSG_PUB.ADD;
6109: RAISE FND_API.G_EXC_ERROR;
6110: END IF;
6111: HZ_MATCH_RULE_53.get_party_for_search(
6112: p_party_id, x_party_search_rec,x_party_site_list,
6113: x_contact_list, x_contact_point_list);
6114: -- Code for Match rule HZ_PERSON_SIMPLE_SEARCH_RULE
6115: ELSIF p_rule_id=58 THEN

Line 6116: IF NOT HZ_MATCH_RULE_58.check_staged THEN

6112: p_party_id, x_party_search_rec,x_party_site_list,
6113: x_contact_list, x_contact_point_list);
6114: -- Code for Match rule HZ_PERSON_SIMPLE_SEARCH_RULE
6115: ELSIF p_rule_id=58 THEN
6116: IF NOT HZ_MATCH_RULE_58.check_staged THEN
6117: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6118: FND_MSG_PUB.ADD;
6119: RAISE FND_API.G_EXC_ERROR;
6120: END IF;

Line 6121: HZ_MATCH_RULE_58.get_party_for_search(

6117: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6118: FND_MSG_PUB.ADD;
6119: RAISE FND_API.G_EXC_ERROR;
6120: END IF;
6121: HZ_MATCH_RULE_58.get_party_for_search(
6122: p_party_id, x_party_search_rec,x_party_site_list,
6123: x_contact_list, x_contact_point_list);
6124: -- Code for Match rule HZ_PERSON_ADVANCED_SEARCH_MATCH_RULE
6125: ELSIF p_rule_id=60 THEN

Line 6288: IF NOT HZ_MATCH_RULE_5.check_staged THEN

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
6288: IF NOT HZ_MATCH_RULE_5.check_staged THEN
6289: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6290: FND_MSG_PUB.ADD;
6291: RAISE FND_API.G_EXC_ERROR;
6292: END IF;

Line 6293: HZ_MATCH_RULE_5.get_search_criteria(

6289: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6290: FND_MSG_PUB.ADD;
6291: RAISE FND_API.G_EXC_ERROR;
6292: END IF;
6293: HZ_MATCH_RULE_5.get_search_criteria(
6294: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6295: x_contact_list, x_contact_point_list);
6296: -- Code for Match rule SAMPLE: SIMILAR_ORGANIZATION
6297: ELSIF p_rule_id=6 THEN

Line 6448: IF NOT HZ_MATCH_RULE_50.check_staged THEN

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
6448: IF NOT HZ_MATCH_RULE_50.check_staged THEN
6449: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6450: FND_MSG_PUB.ADD;
6451: RAISE FND_API.G_EXC_ERROR;
6452: END IF;

Line 6453: HZ_MATCH_RULE_50.get_search_criteria(

6449: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6450: FND_MSG_PUB.ADD;
6451: RAISE FND_API.G_EXC_ERROR;
6452: END IF;
6453: HZ_MATCH_RULE_50.get_search_criteria(
6454: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6455: x_contact_list, x_contact_point_list);
6456: -- Code for Match rule BULK MATCH: IDENTICAL PERSONS
6457: ELSIF p_rule_id=51 THEN

Line 6458: IF NOT HZ_MATCH_RULE_51.check_staged THEN

6454: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6455: x_contact_list, x_contact_point_list);
6456: -- Code for Match rule BULK MATCH: IDENTICAL PERSONS
6457: ELSIF p_rule_id=51 THEN
6458: IF NOT HZ_MATCH_RULE_51.check_staged THEN
6459: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6460: FND_MSG_PUB.ADD;
6461: RAISE FND_API.G_EXC_ERROR;
6462: END IF;

Line 6463: HZ_MATCH_RULE_51.get_search_criteria(

6459: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6460: FND_MSG_PUB.ADD;
6461: RAISE FND_API.G_EXC_ERROR;
6462: END IF;
6463: HZ_MATCH_RULE_51.get_search_criteria(
6464: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6465: x_contact_list, x_contact_point_list);
6466: -- Code for Match rule BULK MATCH: IDENTICAL PARTIES
6467: ELSIF p_rule_id=52 THEN

Line 6468: IF NOT HZ_MATCH_RULE_52.check_staged THEN

6464: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6465: x_contact_list, x_contact_point_list);
6466: -- Code for Match rule BULK MATCH: IDENTICAL PARTIES
6467: ELSIF p_rule_id=52 THEN
6468: IF NOT HZ_MATCH_RULE_52.check_staged THEN
6469: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6470: FND_MSG_PUB.ADD;
6471: RAISE FND_API.G_EXC_ERROR;
6472: END IF;

Line 6473: HZ_MATCH_RULE_52.get_search_criteria(

6469: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6470: FND_MSG_PUB.ADD;
6471: RAISE FND_API.G_EXC_ERROR;
6472: END IF;
6473: HZ_MATCH_RULE_52.get_search_criteria(
6474: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6475: x_contact_list, x_contact_point_list);
6476: -- Code for Match rule CREDIT MANAGEMENT SEARCH
6477: ELSIF p_rule_id=53 THEN

Line 6478: IF NOT HZ_MATCH_RULE_53.check_staged THEN

6474: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6475: x_contact_list, x_contact_point_list);
6476: -- Code for Match rule CREDIT MANAGEMENT SEARCH
6477: ELSIF p_rule_id=53 THEN
6478: IF NOT HZ_MATCH_RULE_53.check_staged THEN
6479: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6480: FND_MSG_PUB.ADD;
6481: RAISE FND_API.G_EXC_ERROR;
6482: END IF;

Line 6483: HZ_MATCH_RULE_53.get_search_criteria(

6479: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6480: FND_MSG_PUB.ADD;
6481: RAISE FND_API.G_EXC_ERROR;
6482: END IF;
6483: HZ_MATCH_RULE_53.get_search_criteria(
6484: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6485: x_contact_list, x_contact_point_list);
6486: -- Code for Match rule HZ_PERSON_SIMPLE_SEARCH_RULE
6487: ELSIF p_rule_id=58 THEN

Line 6488: IF NOT HZ_MATCH_RULE_58.check_staged THEN

6484: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6485: x_contact_list, x_contact_point_list);
6486: -- Code for Match rule HZ_PERSON_SIMPLE_SEARCH_RULE
6487: ELSIF p_rule_id=58 THEN
6488: IF NOT HZ_MATCH_RULE_58.check_staged THEN
6489: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6490: FND_MSG_PUB.ADD;
6491: RAISE FND_API.G_EXC_ERROR;
6492: END IF;

Line 6493: HZ_MATCH_RULE_58.get_search_criteria(

6489: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6490: FND_MSG_PUB.ADD;
6491: RAISE FND_API.G_EXC_ERROR;
6492: END IF;
6493: HZ_MATCH_RULE_58.get_search_criteria(
6494: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6495: x_contact_list, x_contact_point_list);
6496: -- Code for Match rule HZ_PERSON_ADVANCED_SEARCH_MATCH_RULE
6497: ELSIF p_rule_id=60 THEN