eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_PARTY_SEARCH dependencies on HZ_MATCH_RULE_3

Line 120: IF NOT HZ_MATCH_RULE_3.check_staged THEN

116: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
117: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,NULL,NULL,NULL,'N',x_search_ctx_id,x_num_matches);
118: -- Code for Match rule SAMPLE: PERSON_OPTIMIZED
119: ELSIF p_rule_id=3 THEN
120: IF NOT HZ_MATCH_RULE_3.check_staged THEN
121: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
122: FND_MSG_PUB.ADD;
123: RAISE FND_API.G_EXC_ERROR;
124: END IF;

Line 125: HZ_MATCH_RULE_3.find_parties(

121: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
122: FND_MSG_PUB.ADD;
123: RAISE FND_API.G_EXC_ERROR;
124: END IF;
125: HZ_MATCH_RULE_3.find_parties(
126: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
127: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,NULL,NULL,NULL,'N',x_search_ctx_id,x_num_matches);
128: -- Code for Match rule SAMPLE: ADDRESS_ORGANIZATIONS
129: ELSIF p_rule_id=4 THEN

Line 180: IF NOT HZ_MATCH_RULE_32.check_staged THEN

176: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
177: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,NULL,NULL,NULL,'N',x_search_ctx_id,x_num_matches);
178: -- Code for Match rule RM SEARCH RULE
179: ELSIF p_rule_id=32 THEN
180: IF NOT HZ_MATCH_RULE_32.check_staged THEN
181: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
182: FND_MSG_PUB.ADD;
183: RAISE FND_API.G_EXC_ERROR;
184: END IF;

Line 185: HZ_MATCH_RULE_32.find_parties(

181: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
182: FND_MSG_PUB.ADD;
183: RAISE FND_API.G_EXC_ERROR;
184: END IF;
185: HZ_MATCH_RULE_32.find_parties(
186: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
187: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,NULL,NULL,NULL,'N',x_search_ctx_id,x_num_matches);
188: -- Code for Match rule SAMPLE:BASIC SEARCH RULE
189: ELSIF p_rule_id=33 THEN

Line 190: IF NOT HZ_MATCH_RULE_33.check_staged THEN

186: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
187: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,NULL,NULL,NULL,'N',x_search_ctx_id,x_num_matches);
188: -- Code for Match rule SAMPLE:BASIC SEARCH RULE
189: ELSIF p_rule_id=33 THEN
190: IF NOT HZ_MATCH_RULE_33.check_staged THEN
191: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
192: FND_MSG_PUB.ADD;
193: RAISE FND_API.G_EXC_ERROR;
194: END IF;

Line 195: HZ_MATCH_RULE_33.find_parties(

191: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
192: FND_MSG_PUB.ADD;
193: RAISE FND_API.G_EXC_ERROR;
194: END IF;
195: HZ_MATCH_RULE_33.find_parties(
196: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
197: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,NULL,NULL,NULL,'N',x_search_ctx_id,x_num_matches);
198: -- Code for Match rule SAMPLE:ADVANCED SEARCH RULE
199: ELSIF p_rule_id=34 THEN

Line 200: IF NOT HZ_MATCH_RULE_34.check_staged THEN

196: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
197: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,NULL,NULL,NULL,'N',x_search_ctx_id,x_num_matches);
198: -- Code for Match rule SAMPLE:ADVANCED SEARCH RULE
199: ELSIF p_rule_id=34 THEN
200: IF NOT HZ_MATCH_RULE_34.check_staged THEN
201: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
202: FND_MSG_PUB.ADD;
203: RAISE FND_API.G_EXC_ERROR;
204: END IF;

Line 205: HZ_MATCH_RULE_34.find_parties(

201: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
202: FND_MSG_PUB.ADD;
203: RAISE FND_API.G_EXC_ERROR;
204: END IF;
205: HZ_MATCH_RULE_34.find_parties(
206: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
207: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,NULL,NULL,NULL,'N',x_search_ctx_id,x_num_matches);
208: -- Code for Match rule DL SMART SEARCH
209: ELSIF p_rule_id=35 THEN

Line 210: IF NOT HZ_MATCH_RULE_35.check_staged THEN

206: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
207: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,NULL,NULL,NULL,'N',x_search_ctx_id,x_num_matches);
208: -- Code for Match rule DL SMART SEARCH
209: ELSIF p_rule_id=35 THEN
210: IF NOT HZ_MATCH_RULE_35.check_staged THEN
211: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
212: FND_MSG_PUB.ADD;
213: RAISE FND_API.G_EXC_ERROR;
214: END IF;

Line 215: HZ_MATCH_RULE_35.find_parties(

211: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
212: FND_MSG_PUB.ADD;
213: RAISE FND_API.G_EXC_ERROR;
214: END IF;
215: HZ_MATCH_RULE_35.find_parties(
216: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
217: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,NULL,NULL,NULL,'N',x_search_ctx_id,x_num_matches);
218: -- Code for Match rule DL ADDRESS AND RELATIONSHIP SEARCH
219: ELSIF p_rule_id=36 THEN

Line 220: IF NOT HZ_MATCH_RULE_36.check_staged THEN

216: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
217: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,NULL,NULL,NULL,'N',x_search_ctx_id,x_num_matches);
218: -- Code for Match rule DL ADDRESS AND RELATIONSHIP SEARCH
219: ELSIF p_rule_id=36 THEN
220: IF NOT HZ_MATCH_RULE_36.check_staged THEN
221: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
222: FND_MSG_PUB.ADD;
223: RAISE FND_API.G_EXC_ERROR;
224: END IF;

Line 225: HZ_MATCH_RULE_36.find_parties(

221: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
222: FND_MSG_PUB.ADD;
223: RAISE FND_API.G_EXC_ERROR;
224: END IF;
225: HZ_MATCH_RULE_36.find_parties(
226: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
227: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,NULL,NULL,NULL,'N',x_search_ctx_id,x_num_matches);
228: -- Code for Match rule DL ADDRESS DEFAULT
229: ELSIF p_rule_id=37 THEN

Line 230: IF NOT HZ_MATCH_RULE_37.check_staged THEN

226: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
227: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,NULL,NULL,NULL,'N',x_search_ctx_id,x_num_matches);
228: -- Code for Match rule DL ADDRESS DEFAULT
229: ELSIF p_rule_id=37 THEN
230: IF NOT HZ_MATCH_RULE_37.check_staged THEN
231: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
232: FND_MSG_PUB.ADD;
233: RAISE FND_API.G_EXC_ERROR;
234: END IF;

Line 235: HZ_MATCH_RULE_37.find_parties(

231: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
232: FND_MSG_PUB.ADD;
233: RAISE FND_API.G_EXC_ERROR;
234: END IF;
235: HZ_MATCH_RULE_37.find_parties(
236: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
237: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,NULL,NULL,NULL,'N',x_search_ctx_id,x_num_matches);
238: -- Code for Match rule DL RELATIONSHIP DEFAULT
239: ELSIF p_rule_id=38 THEN

Line 240: IF NOT HZ_MATCH_RULE_38.check_staged THEN

236: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
237: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,NULL,NULL,NULL,'N',x_search_ctx_id,x_num_matches);
238: -- Code for Match rule DL RELATIONSHIP DEFAULT
239: ELSIF p_rule_id=38 THEN
240: IF NOT HZ_MATCH_RULE_38.check_staged THEN
241: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
242: FND_MSG_PUB.ADD;
243: RAISE FND_API.G_EXC_ERROR;
244: END IF;

Line 245: HZ_MATCH_RULE_38.find_parties(

241: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
242: FND_MSG_PUB.ADD;
243: RAISE FND_API.G_EXC_ERROR;
244: END IF;
245: HZ_MATCH_RULE_38.find_parties(
246: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
247: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,NULL,NULL,NULL,'N',x_search_ctx_id,x_num_matches);
248: -- Code for Match rule SAMPLE: SEARCH ADDRESS ORGANIZATIONS EXACT
249: ELSIF p_rule_id=39 THEN

Line 250: IF NOT HZ_MATCH_RULE_39.check_staged THEN

246: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
247: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,NULL,NULL,NULL,'N',x_search_ctx_id,x_num_matches);
248: -- Code for Match rule SAMPLE: SEARCH ADDRESS ORGANIZATIONS EXACT
249: ELSIF p_rule_id=39 THEN
250: IF NOT HZ_MATCH_RULE_39.check_staged THEN
251: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
252: FND_MSG_PUB.ADD;
253: RAISE FND_API.G_EXC_ERROR;
254: END IF;

Line 255: HZ_MATCH_RULE_39.find_parties(

251: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
252: FND_MSG_PUB.ADD;
253: RAISE FND_API.G_EXC_ERROR;
254: END IF;
255: HZ_MATCH_RULE_39.find_parties(
256: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
257: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,NULL,NULL,NULL,'N',x_search_ctx_id,x_num_matches);
258: -- Code for Match rule SAMPLE: SEARCH SIMILAR ORGANIZATION EXACT
259: ELSIF p_rule_id=40 THEN

Line 521: IF NOT HZ_MATCH_RULE_3.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: PERSON_OPTIMIZED
520: ELSIF p_rule_id=3 THEN
521: IF NOT HZ_MATCH_RULE_3.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_3.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_3.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: ADDRESS_ORGANIZATIONS
530: ELSIF p_rule_id=4 THEN

Line 581: IF NOT HZ_MATCH_RULE_32.check_staged THEN

577: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
578: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,'N',x_search_ctx_id,x_num_matches);
579: -- Code for Match rule RM SEARCH RULE
580: ELSIF p_rule_id=32 THEN
581: IF NOT HZ_MATCH_RULE_32.check_staged THEN
582: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
583: FND_MSG_PUB.ADD;
584: RAISE FND_API.G_EXC_ERROR;
585: END IF;

Line 586: HZ_MATCH_RULE_32.find_persons(

582: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
583: FND_MSG_PUB.ADD;
584: RAISE FND_API.G_EXC_ERROR;
585: END IF;
586: HZ_MATCH_RULE_32.find_persons(
587: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
588: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,'N',x_search_ctx_id,x_num_matches);
589: -- Code for Match rule SAMPLE:BASIC SEARCH RULE
590: ELSIF p_rule_id=33 THEN

Line 591: IF NOT HZ_MATCH_RULE_33.check_staged THEN

587: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
588: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,'N',x_search_ctx_id,x_num_matches);
589: -- Code for Match rule SAMPLE:BASIC SEARCH RULE
590: ELSIF p_rule_id=33 THEN
591: IF NOT HZ_MATCH_RULE_33.check_staged THEN
592: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
593: FND_MSG_PUB.ADD;
594: RAISE FND_API.G_EXC_ERROR;
595: END IF;

Line 596: HZ_MATCH_RULE_33.find_persons(

592: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
593: FND_MSG_PUB.ADD;
594: RAISE FND_API.G_EXC_ERROR;
595: END IF;
596: HZ_MATCH_RULE_33.find_persons(
597: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
598: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,'N',x_search_ctx_id,x_num_matches);
599: -- Code for Match rule SAMPLE:ADVANCED SEARCH RULE
600: ELSIF p_rule_id=34 THEN

Line 601: IF NOT HZ_MATCH_RULE_34.check_staged THEN

597: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
598: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,'N',x_search_ctx_id,x_num_matches);
599: -- Code for Match rule SAMPLE:ADVANCED SEARCH RULE
600: ELSIF p_rule_id=34 THEN
601: IF NOT HZ_MATCH_RULE_34.check_staged THEN
602: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
603: FND_MSG_PUB.ADD;
604: RAISE FND_API.G_EXC_ERROR;
605: END IF;

Line 606: HZ_MATCH_RULE_34.find_persons(

602: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
603: FND_MSG_PUB.ADD;
604: RAISE FND_API.G_EXC_ERROR;
605: END IF;
606: HZ_MATCH_RULE_34.find_persons(
607: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
608: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,'N',x_search_ctx_id,x_num_matches);
609: -- Code for Match rule DL SMART SEARCH
610: ELSIF p_rule_id=35 THEN

Line 611: IF NOT HZ_MATCH_RULE_35.check_staged THEN

607: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
608: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,'N',x_search_ctx_id,x_num_matches);
609: -- Code for Match rule DL SMART SEARCH
610: ELSIF p_rule_id=35 THEN
611: IF NOT HZ_MATCH_RULE_35.check_staged THEN
612: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
613: FND_MSG_PUB.ADD;
614: RAISE FND_API.G_EXC_ERROR;
615: END IF;

Line 616: HZ_MATCH_RULE_35.find_persons(

612: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
613: FND_MSG_PUB.ADD;
614: RAISE FND_API.G_EXC_ERROR;
615: END IF;
616: HZ_MATCH_RULE_35.find_persons(
617: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
618: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,'N',x_search_ctx_id,x_num_matches);
619: -- Code for Match rule DL ADDRESS AND RELATIONSHIP SEARCH
620: ELSIF p_rule_id=36 THEN

Line 621: IF NOT HZ_MATCH_RULE_36.check_staged THEN

617: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
618: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,'N',x_search_ctx_id,x_num_matches);
619: -- Code for Match rule DL ADDRESS AND RELATIONSHIP SEARCH
620: ELSIF p_rule_id=36 THEN
621: IF NOT HZ_MATCH_RULE_36.check_staged THEN
622: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
623: FND_MSG_PUB.ADD;
624: RAISE FND_API.G_EXC_ERROR;
625: END IF;

Line 626: HZ_MATCH_RULE_36.find_persons(

622: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
623: FND_MSG_PUB.ADD;
624: RAISE FND_API.G_EXC_ERROR;
625: END IF;
626: HZ_MATCH_RULE_36.find_persons(
627: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
628: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,'N',x_search_ctx_id,x_num_matches);
629: -- Code for Match rule DL ADDRESS DEFAULT
630: ELSIF p_rule_id=37 THEN

Line 631: IF NOT HZ_MATCH_RULE_37.check_staged THEN

627: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
628: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,'N',x_search_ctx_id,x_num_matches);
629: -- Code for Match rule DL ADDRESS DEFAULT
630: ELSIF p_rule_id=37 THEN
631: IF NOT HZ_MATCH_RULE_37.check_staged THEN
632: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
633: FND_MSG_PUB.ADD;
634: RAISE FND_API.G_EXC_ERROR;
635: END IF;

Line 636: HZ_MATCH_RULE_37.find_persons(

632: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
633: FND_MSG_PUB.ADD;
634: RAISE FND_API.G_EXC_ERROR;
635: END IF;
636: HZ_MATCH_RULE_37.find_persons(
637: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
638: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,'N',x_search_ctx_id,x_num_matches);
639: -- Code for Match rule DL RELATIONSHIP DEFAULT
640: ELSIF p_rule_id=38 THEN

Line 641: IF NOT HZ_MATCH_RULE_38.check_staged THEN

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

Line 646: HZ_MATCH_RULE_38.find_persons(

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

Line 651: IF NOT HZ_MATCH_RULE_39.check_staged THEN

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

Line 656: HZ_MATCH_RULE_39.find_persons(

652: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
653: FND_MSG_PUB.ADD;
654: RAISE FND_API.G_EXC_ERROR;
655: END IF;
656: HZ_MATCH_RULE_39.find_persons(
657: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
658: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,'N',x_search_ctx_id,x_num_matches);
659: -- Code for Match rule SAMPLE: SEARCH SIMILAR ORGANIZATION EXACT
660: ELSIF p_rule_id=40 THEN

Line 940: IF NOT HZ_MATCH_RULE_3.check_staged THEN

936: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
937: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
938: -- Code for Match rule SAMPLE: PERSON_OPTIMIZED
939: ELSIF p_rule_id=3 THEN
940: IF NOT HZ_MATCH_RULE_3.check_staged THEN
941: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
942: FND_MSG_PUB.ADD;
943: RAISE FND_API.G_EXC_ERROR;
944: END IF;

Line 945: HZ_MATCH_RULE_3.find_party_details(

941: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
942: FND_MSG_PUB.ADD;
943: RAISE FND_API.G_EXC_ERROR;
944: END IF;
945: HZ_MATCH_RULE_3.find_party_details(
946: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
947: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
948: -- Code for Match rule SAMPLE: ADDRESS_ORGANIZATIONS
949: ELSIF p_rule_id=4 THEN

Line 1000: IF NOT HZ_MATCH_RULE_32.check_staged THEN

996: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
997: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
998: -- Code for Match rule RM SEARCH RULE
999: ELSIF p_rule_id=32 THEN
1000: IF NOT HZ_MATCH_RULE_32.check_staged THEN
1001: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1002: FND_MSG_PUB.ADD;
1003: RAISE FND_API.G_EXC_ERROR;
1004: END IF;

Line 1005: HZ_MATCH_RULE_32.find_party_details(

1001: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1002: FND_MSG_PUB.ADD;
1003: RAISE FND_API.G_EXC_ERROR;
1004: END IF;
1005: HZ_MATCH_RULE_32.find_party_details(
1006: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
1007: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
1008: -- Code for Match rule SAMPLE:BASIC SEARCH RULE
1009: ELSIF p_rule_id=33 THEN

Line 1010: IF NOT HZ_MATCH_RULE_33.check_staged THEN

1006: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
1007: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
1008: -- Code for Match rule SAMPLE:BASIC SEARCH RULE
1009: ELSIF p_rule_id=33 THEN
1010: IF NOT HZ_MATCH_RULE_33.check_staged THEN
1011: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1012: FND_MSG_PUB.ADD;
1013: RAISE FND_API.G_EXC_ERROR;
1014: END IF;

Line 1015: HZ_MATCH_RULE_33.find_party_details(

1011: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1012: FND_MSG_PUB.ADD;
1013: RAISE FND_API.G_EXC_ERROR;
1014: END IF;
1015: HZ_MATCH_RULE_33.find_party_details(
1016: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
1017: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
1018: -- Code for Match rule SAMPLE:ADVANCED SEARCH RULE
1019: ELSIF p_rule_id=34 THEN

Line 1020: IF NOT HZ_MATCH_RULE_34.check_staged THEN

1016: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
1017: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
1018: -- Code for Match rule SAMPLE:ADVANCED SEARCH RULE
1019: ELSIF p_rule_id=34 THEN
1020: IF NOT HZ_MATCH_RULE_34.check_staged THEN
1021: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1022: FND_MSG_PUB.ADD;
1023: RAISE FND_API.G_EXC_ERROR;
1024: END IF;

Line 1025: HZ_MATCH_RULE_34.find_party_details(

1021: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1022: FND_MSG_PUB.ADD;
1023: RAISE FND_API.G_EXC_ERROR;
1024: END IF;
1025: HZ_MATCH_RULE_34.find_party_details(
1026: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
1027: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
1028: -- Code for Match rule DL SMART SEARCH
1029: ELSIF p_rule_id=35 THEN

Line 1030: IF NOT HZ_MATCH_RULE_35.check_staged THEN

1026: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
1027: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
1028: -- Code for Match rule DL SMART SEARCH
1029: ELSIF p_rule_id=35 THEN
1030: IF NOT HZ_MATCH_RULE_35.check_staged THEN
1031: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1032: FND_MSG_PUB.ADD;
1033: RAISE FND_API.G_EXC_ERROR;
1034: END IF;

Line 1035: HZ_MATCH_RULE_35.find_party_details(

1031: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1032: FND_MSG_PUB.ADD;
1033: RAISE FND_API.G_EXC_ERROR;
1034: END IF;
1035: HZ_MATCH_RULE_35.find_party_details(
1036: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
1037: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
1038: -- Code for Match rule DL ADDRESS AND RELATIONSHIP SEARCH
1039: ELSIF p_rule_id=36 THEN

Line 1040: IF NOT HZ_MATCH_RULE_36.check_staged THEN

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

Line 1045: HZ_MATCH_RULE_36.find_party_details(

1041: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1042: FND_MSG_PUB.ADD;
1043: RAISE FND_API.G_EXC_ERROR;
1044: END IF;
1045: HZ_MATCH_RULE_36.find_party_details(
1046: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
1047: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
1048: -- Code for Match rule DL ADDRESS DEFAULT
1049: ELSIF p_rule_id=37 THEN

Line 1050: IF NOT HZ_MATCH_RULE_37.check_staged THEN

1046: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
1047: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
1048: -- Code for Match rule DL ADDRESS DEFAULT
1049: ELSIF p_rule_id=37 THEN
1050: IF NOT HZ_MATCH_RULE_37.check_staged THEN
1051: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1052: FND_MSG_PUB.ADD;
1053: RAISE FND_API.G_EXC_ERROR;
1054: END IF;

Line 1055: HZ_MATCH_RULE_37.find_party_details(

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

Line 1060: IF NOT HZ_MATCH_RULE_38.check_staged THEN

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

Line 1065: HZ_MATCH_RULE_38.find_party_details(

1061: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1062: FND_MSG_PUB.ADD;
1063: RAISE FND_API.G_EXC_ERROR;
1064: END IF;
1065: HZ_MATCH_RULE_38.find_party_details(
1066: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
1067: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
1068: -- Code for Match rule SAMPLE: SEARCH ADDRESS ORGANIZATIONS EXACT
1069: ELSIF p_rule_id=39 THEN

Line 1070: IF NOT HZ_MATCH_RULE_39.check_staged THEN

1066: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
1067: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
1068: -- Code for Match rule SAMPLE: SEARCH ADDRESS ORGANIZATIONS EXACT
1069: ELSIF p_rule_id=39 THEN
1070: IF NOT HZ_MATCH_RULE_39.check_staged THEN
1071: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1072: FND_MSG_PUB.ADD;
1073: RAISE FND_API.G_EXC_ERROR;
1074: END IF;

Line 1075: HZ_MATCH_RULE_39.find_party_details(

1071: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1072: FND_MSG_PUB.ADD;
1073: RAISE FND_API.G_EXC_ERROR;
1074: END IF;
1075: HZ_MATCH_RULE_39.find_party_details(
1076: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
1077: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
1078: -- Code for Match rule SAMPLE: SEARCH SIMILAR ORGANIZATION EXACT
1079: ELSIF p_rule_id=40 THEN

Line 1340: IF NOT HZ_MATCH_RULE_3.check_staged THEN

1336: p_rule_id,p_party_id,
1337: p_restrict_sql,p_match_type,p_dup_batch_id,p_search_merged,x_dup_set_id, x_search_ctx_id,x_num_matches);
1338: -- Code for Match rule SAMPLE: PERSON_OPTIMIZED
1339: ELSIF p_rule_id=3 THEN
1340: IF NOT HZ_MATCH_RULE_3.check_staged THEN
1341: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1342: FND_MSG_PUB.ADD;
1343: RAISE FND_API.G_EXC_ERROR;
1344: END IF;

Line 1345: HZ_MATCH_RULE_3.find_duplicate_parties(

1341: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1342: FND_MSG_PUB.ADD;
1343: RAISE FND_API.G_EXC_ERROR;
1344: END IF;
1345: HZ_MATCH_RULE_3.find_duplicate_parties(
1346: p_rule_id,p_party_id,
1347: p_restrict_sql,p_match_type,p_dup_batch_id,p_search_merged,x_dup_set_id, x_search_ctx_id,x_num_matches);
1348: -- Code for Match rule SAMPLE: ADDRESS_ORGANIZATIONS
1349: ELSIF p_rule_id=4 THEN

Line 1400: IF NOT HZ_MATCH_RULE_32.check_staged THEN

1396: p_rule_id,p_party_id,
1397: p_restrict_sql,p_match_type,p_dup_batch_id,p_search_merged,x_dup_set_id, x_search_ctx_id,x_num_matches);
1398: -- Code for Match rule RM SEARCH RULE
1399: ELSIF p_rule_id=32 THEN
1400: IF NOT HZ_MATCH_RULE_32.check_staged THEN
1401: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1402: FND_MSG_PUB.ADD;
1403: RAISE FND_API.G_EXC_ERROR;
1404: END IF;

Line 1405: HZ_MATCH_RULE_32.find_duplicate_parties(

1401: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1402: FND_MSG_PUB.ADD;
1403: RAISE FND_API.G_EXC_ERROR;
1404: END IF;
1405: HZ_MATCH_RULE_32.find_duplicate_parties(
1406: p_rule_id,p_party_id,
1407: p_restrict_sql,p_match_type,p_dup_batch_id,p_search_merged,x_dup_set_id, x_search_ctx_id,x_num_matches);
1408: -- Code for Match rule SAMPLE:BASIC SEARCH RULE
1409: ELSIF p_rule_id=33 THEN

Line 1410: IF NOT HZ_MATCH_RULE_33.check_staged THEN

1406: p_rule_id,p_party_id,
1407: p_restrict_sql,p_match_type,p_dup_batch_id,p_search_merged,x_dup_set_id, x_search_ctx_id,x_num_matches);
1408: -- Code for Match rule SAMPLE:BASIC SEARCH RULE
1409: ELSIF p_rule_id=33 THEN
1410: IF NOT HZ_MATCH_RULE_33.check_staged THEN
1411: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1412: FND_MSG_PUB.ADD;
1413: RAISE FND_API.G_EXC_ERROR;
1414: END IF;

Line 1415: HZ_MATCH_RULE_33.find_duplicate_parties(

1411: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1412: FND_MSG_PUB.ADD;
1413: RAISE FND_API.G_EXC_ERROR;
1414: END IF;
1415: HZ_MATCH_RULE_33.find_duplicate_parties(
1416: p_rule_id,p_party_id,
1417: p_restrict_sql,p_match_type,p_dup_batch_id,p_search_merged,x_dup_set_id, x_search_ctx_id,x_num_matches);
1418: -- Code for Match rule SAMPLE:ADVANCED SEARCH RULE
1419: ELSIF p_rule_id=34 THEN

Line 1420: IF NOT HZ_MATCH_RULE_34.check_staged THEN

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

Line 1425: HZ_MATCH_RULE_34.find_duplicate_parties(

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

Line 1430: IF NOT HZ_MATCH_RULE_35.check_staged THEN

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

Line 1435: HZ_MATCH_RULE_35.find_duplicate_parties(

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

Line 1440: IF NOT HZ_MATCH_RULE_36.check_staged THEN

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

Line 1445: HZ_MATCH_RULE_36.find_duplicate_parties(

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

Line 1450: IF NOT HZ_MATCH_RULE_37.check_staged THEN

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

Line 1455: HZ_MATCH_RULE_37.find_duplicate_parties(

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

Line 1460: IF NOT HZ_MATCH_RULE_38.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 DL RELATIONSHIP DEFAULT
1459: ELSIF p_rule_id=38 THEN
1460: IF NOT HZ_MATCH_RULE_38.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_38.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_38.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 SAMPLE: SEARCH ADDRESS ORGANIZATIONS EXACT
1469: ELSIF p_rule_id=39 THEN

Line 1470: IF NOT HZ_MATCH_RULE_39.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 SAMPLE: SEARCH ADDRESS ORGANIZATIONS EXACT
1469: ELSIF p_rule_id=39 THEN
1470: IF NOT HZ_MATCH_RULE_39.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_39.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_39.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 SAMPLE: SEARCH SIMILAR ORGANIZATION EXACT
1479: ELSIF p_rule_id=40 THEN

Line 1735: IF NOT HZ_MATCH_RULE_3.check_staged THEN

1731: p_rule_id,p_party_site_id,p_party_id,
1732: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
1733: -- Code for Match rule SAMPLE: PERSON_OPTIMIZED
1734: ELSIF p_rule_id=3 THEN
1735: IF NOT HZ_MATCH_RULE_3.check_staged THEN
1736: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1737: FND_MSG_PUB.ADD;
1738: RAISE FND_API.G_EXC_ERROR;
1739: END IF;

Line 1740: HZ_MATCH_RULE_3.find_duplicate_party_sites(

1736: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1737: FND_MSG_PUB.ADD;
1738: RAISE FND_API.G_EXC_ERROR;
1739: END IF;
1740: HZ_MATCH_RULE_3.find_duplicate_party_sites(
1741: p_rule_id,p_party_site_id,p_party_id,
1742: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
1743: -- Code for Match rule SAMPLE: ADDRESS_ORGANIZATIONS
1744: ELSIF p_rule_id=4 THEN

Line 1795: IF NOT HZ_MATCH_RULE_32.check_staged THEN

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

Line 1800: HZ_MATCH_RULE_32.find_duplicate_party_sites(

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

Line 1805: IF NOT HZ_MATCH_RULE_33.check_staged THEN

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

Line 1810: HZ_MATCH_RULE_33.find_duplicate_party_sites(

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

Line 1815: IF NOT HZ_MATCH_RULE_34.check_staged THEN

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

Line 1820: HZ_MATCH_RULE_34.find_duplicate_party_sites(

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

Line 1825: IF NOT HZ_MATCH_RULE_35.check_staged THEN

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

Line 1830: HZ_MATCH_RULE_35.find_duplicate_party_sites(

1826: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1827: FND_MSG_PUB.ADD;
1828: RAISE FND_API.G_EXC_ERROR;
1829: END IF;
1830: HZ_MATCH_RULE_35.find_duplicate_party_sites(
1831: p_rule_id,p_party_site_id,p_party_id,
1832: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
1833: -- Code for Match rule DL ADDRESS AND RELATIONSHIP SEARCH
1834: ELSIF p_rule_id=36 THEN

Line 1835: IF NOT HZ_MATCH_RULE_36.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 DL ADDRESS AND RELATIONSHIP SEARCH
1834: ELSIF p_rule_id=36 THEN
1835: IF NOT HZ_MATCH_RULE_36.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_36.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_36.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 DL ADDRESS DEFAULT
1844: ELSIF p_rule_id=37 THEN

Line 1845: IF NOT HZ_MATCH_RULE_37.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 DL ADDRESS DEFAULT
1844: ELSIF p_rule_id=37 THEN
1845: IF NOT HZ_MATCH_RULE_37.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_37.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_37.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 DL RELATIONSHIP DEFAULT
1854: ELSIF p_rule_id=38 THEN

Line 1855: IF NOT HZ_MATCH_RULE_38.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 DL RELATIONSHIP DEFAULT
1854: ELSIF p_rule_id=38 THEN
1855: IF NOT HZ_MATCH_RULE_38.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_38.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_38.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 SAMPLE: SEARCH ADDRESS ORGANIZATIONS EXACT
1864: ELSIF p_rule_id=39 THEN

Line 1865: IF NOT HZ_MATCH_RULE_39.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 SAMPLE: SEARCH ADDRESS ORGANIZATIONS EXACT
1864: ELSIF p_rule_id=39 THEN
1865: IF NOT HZ_MATCH_RULE_39.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_39.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_39.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 SAMPLE: SEARCH SIMILAR ORGANIZATION EXACT
1874: ELSIF p_rule_id=40 THEN

Line 2129: IF NOT HZ_MATCH_RULE_3.check_staged THEN

2125: p_rule_id,p_org_contact_id,p_party_id,
2126: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2127: -- Code for Match rule SAMPLE: PERSON_OPTIMIZED
2128: ELSIF p_rule_id=3 THEN
2129: IF NOT HZ_MATCH_RULE_3.check_staged THEN
2130: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2131: FND_MSG_PUB.ADD;
2132: RAISE FND_API.G_EXC_ERROR;
2133: END IF;

Line 2134: HZ_MATCH_RULE_3.find_duplicate_contacts(

2130: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2131: FND_MSG_PUB.ADD;
2132: RAISE FND_API.G_EXC_ERROR;
2133: END IF;
2134: HZ_MATCH_RULE_3.find_duplicate_contacts(
2135: p_rule_id,p_org_contact_id,p_party_id,
2136: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2137: -- Code for Match rule SAMPLE: ADDRESS_ORGANIZATIONS
2138: ELSIF p_rule_id=4 THEN

Line 2189: IF NOT HZ_MATCH_RULE_32.check_staged THEN

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

Line 2194: HZ_MATCH_RULE_32.find_duplicate_contacts(

2190: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2191: FND_MSG_PUB.ADD;
2192: RAISE FND_API.G_EXC_ERROR;
2193: END IF;
2194: HZ_MATCH_RULE_32.find_duplicate_contacts(
2195: p_rule_id,p_org_contact_id,p_party_id,
2196: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2197: -- Code for Match rule SAMPLE:BASIC SEARCH RULE
2198: ELSIF p_rule_id=33 THEN

Line 2199: IF NOT HZ_MATCH_RULE_33.check_staged THEN

2195: p_rule_id,p_org_contact_id,p_party_id,
2196: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2197: -- Code for Match rule SAMPLE:BASIC SEARCH RULE
2198: ELSIF p_rule_id=33 THEN
2199: IF NOT HZ_MATCH_RULE_33.check_staged THEN
2200: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2201: FND_MSG_PUB.ADD;
2202: RAISE FND_API.G_EXC_ERROR;
2203: END IF;

Line 2204: HZ_MATCH_RULE_33.find_duplicate_contacts(

2200: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2201: FND_MSG_PUB.ADD;
2202: RAISE FND_API.G_EXC_ERROR;
2203: END IF;
2204: HZ_MATCH_RULE_33.find_duplicate_contacts(
2205: p_rule_id,p_org_contact_id,p_party_id,
2206: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2207: -- Code for Match rule SAMPLE:ADVANCED SEARCH RULE
2208: ELSIF p_rule_id=34 THEN

Line 2209: IF NOT HZ_MATCH_RULE_34.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 SAMPLE:ADVANCED SEARCH RULE
2208: ELSIF p_rule_id=34 THEN
2209: IF NOT HZ_MATCH_RULE_34.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_34.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_34.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 DL SMART SEARCH
2218: ELSIF p_rule_id=35 THEN

Line 2219: IF NOT HZ_MATCH_RULE_35.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 DL SMART SEARCH
2218: ELSIF p_rule_id=35 THEN
2219: IF NOT HZ_MATCH_RULE_35.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_35.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_35.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 DL ADDRESS AND RELATIONSHIP SEARCH
2228: ELSIF p_rule_id=36 THEN

Line 2229: IF NOT HZ_MATCH_RULE_36.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 DL ADDRESS AND RELATIONSHIP SEARCH
2228: ELSIF p_rule_id=36 THEN
2229: IF NOT HZ_MATCH_RULE_36.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_36.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_36.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 DL ADDRESS DEFAULT
2238: ELSIF p_rule_id=37 THEN

Line 2239: IF NOT HZ_MATCH_RULE_37.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 DL ADDRESS DEFAULT
2238: ELSIF p_rule_id=37 THEN
2239: IF NOT HZ_MATCH_RULE_37.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_37.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_37.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 DL RELATIONSHIP DEFAULT
2248: ELSIF p_rule_id=38 THEN

Line 2249: IF NOT HZ_MATCH_RULE_38.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 DL RELATIONSHIP DEFAULT
2248: ELSIF p_rule_id=38 THEN
2249: IF NOT HZ_MATCH_RULE_38.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_38.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_38.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 SAMPLE: SEARCH ADDRESS ORGANIZATIONS EXACT
2258: ELSIF p_rule_id=39 THEN

Line 2259: IF NOT HZ_MATCH_RULE_39.check_staged THEN

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

Line 2264: HZ_MATCH_RULE_39.find_duplicate_contacts(

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

Line 2523: IF NOT HZ_MATCH_RULE_3.check_staged THEN

2519: p_rule_id,p_contact_point_id,p_party_id,
2520: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2521: -- Code for Match rule SAMPLE: PERSON_OPTIMIZED
2522: ELSIF p_rule_id=3 THEN
2523: IF NOT HZ_MATCH_RULE_3.check_staged THEN
2524: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2525: FND_MSG_PUB.ADD;
2526: RAISE FND_API.G_EXC_ERROR;
2527: END IF;

Line 2528: HZ_MATCH_RULE_3.find_duplicate_contact_points(

2524: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2525: FND_MSG_PUB.ADD;
2526: RAISE FND_API.G_EXC_ERROR;
2527: END IF;
2528: HZ_MATCH_RULE_3.find_duplicate_contact_points(
2529: p_rule_id,p_contact_point_id,p_party_id,
2530: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2531: -- Code for Match rule SAMPLE: ADDRESS_ORGANIZATIONS
2532: ELSIF p_rule_id=4 THEN

Line 2583: IF NOT HZ_MATCH_RULE_32.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 RM SEARCH RULE
2582: ELSIF p_rule_id=32 THEN
2583: IF NOT HZ_MATCH_RULE_32.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_32.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_32.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 SAMPLE:BASIC SEARCH RULE
2592: ELSIF p_rule_id=33 THEN

Line 2593: IF NOT HZ_MATCH_RULE_33.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 SAMPLE:BASIC SEARCH RULE
2592: ELSIF p_rule_id=33 THEN
2593: IF NOT HZ_MATCH_RULE_33.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_33.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_33.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 SAMPLE:ADVANCED SEARCH RULE
2602: ELSIF p_rule_id=34 THEN

Line 2603: IF NOT HZ_MATCH_RULE_34.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 SAMPLE:ADVANCED SEARCH RULE
2602: ELSIF p_rule_id=34 THEN
2603: IF NOT HZ_MATCH_RULE_34.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_34.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_34.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 DL SMART SEARCH
2612: ELSIF p_rule_id=35 THEN

Line 2613: IF NOT HZ_MATCH_RULE_35.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 DL SMART SEARCH
2612: ELSIF p_rule_id=35 THEN
2613: IF NOT HZ_MATCH_RULE_35.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_35.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_35.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 DL ADDRESS AND RELATIONSHIP SEARCH
2622: ELSIF p_rule_id=36 THEN

Line 2623: IF NOT HZ_MATCH_RULE_36.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 DL ADDRESS AND RELATIONSHIP SEARCH
2622: ELSIF p_rule_id=36 THEN
2623: IF NOT HZ_MATCH_RULE_36.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_36.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_36.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 DL ADDRESS DEFAULT
2632: ELSIF p_rule_id=37 THEN

Line 2633: IF NOT HZ_MATCH_RULE_37.check_staged THEN

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

Line 2638: HZ_MATCH_RULE_37.find_duplicate_contact_points(

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

Line 2643: IF NOT HZ_MATCH_RULE_38.check_staged THEN

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

Line 2648: HZ_MATCH_RULE_38.find_duplicate_contact_points(

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

Line 2653: IF NOT HZ_MATCH_RULE_39.check_staged THEN

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

Line 2658: HZ_MATCH_RULE_39.find_duplicate_contact_points(

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

Line 2965: IF NOT HZ_MATCH_RULE_3.check_staged THEN

2961: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
2962: p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
2963: -- Code for Match rule SAMPLE: PERSON_OPTIMIZED
2964: ELSIF p_rule_id=3 THEN
2965: IF NOT HZ_MATCH_RULE_3.check_staged THEN
2966: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2967: FND_MSG_PUB.ADD;
2968: RAISE FND_API.G_EXC_ERROR;
2969: END IF;

Line 2970: HZ_MATCH_RULE_3.find_parties_dynamic(

2966: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2967: FND_MSG_PUB.ADD;
2968: RAISE FND_API.G_EXC_ERROR;
2969: END IF;
2970: HZ_MATCH_RULE_3.find_parties_dynamic(
2971: p_rule_id,
2972: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
2973: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
2974: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 3073: IF NOT HZ_MATCH_RULE_32.check_staged THEN

3069: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3070: p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
3071: -- Code for Match rule RM SEARCH RULE
3072: ELSIF p_rule_id=32 THEN
3073: IF NOT HZ_MATCH_RULE_32.check_staged THEN
3074: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3075: FND_MSG_PUB.ADD;
3076: RAISE FND_API.G_EXC_ERROR;
3077: END IF;

Line 3078: HZ_MATCH_RULE_32.find_parties_dynamic(

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

Line 3091: IF NOT HZ_MATCH_RULE_33.check_staged THEN

3087: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3088: p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
3089: -- Code for Match rule SAMPLE:BASIC SEARCH RULE
3090: ELSIF p_rule_id=33 THEN
3091: IF NOT HZ_MATCH_RULE_33.check_staged THEN
3092: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3093: FND_MSG_PUB.ADD;
3094: RAISE FND_API.G_EXC_ERROR;
3095: END IF;

Line 3096: HZ_MATCH_RULE_33.find_parties_dynamic(

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

Line 3109: IF NOT HZ_MATCH_RULE_34.check_staged THEN

3105: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3106: p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
3107: -- Code for Match rule SAMPLE:ADVANCED SEARCH RULE
3108: ELSIF p_rule_id=34 THEN
3109: IF NOT HZ_MATCH_RULE_34.check_staged THEN
3110: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3111: FND_MSG_PUB.ADD;
3112: RAISE FND_API.G_EXC_ERROR;
3113: END IF;

Line 3114: HZ_MATCH_RULE_34.find_parties_dynamic(

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

Line 3127: IF NOT HZ_MATCH_RULE_35.check_staged THEN

3123: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3124: p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
3125: -- Code for Match rule DL SMART SEARCH
3126: ELSIF p_rule_id=35 THEN
3127: IF NOT HZ_MATCH_RULE_35.check_staged THEN
3128: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3129: FND_MSG_PUB.ADD;
3130: RAISE FND_API.G_EXC_ERROR;
3131: END IF;

Line 3132: HZ_MATCH_RULE_35.find_parties_dynamic(

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

Line 3145: IF NOT HZ_MATCH_RULE_36.check_staged THEN

3141: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3142: p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
3143: -- Code for Match rule DL ADDRESS AND RELATIONSHIP SEARCH
3144: ELSIF p_rule_id=36 THEN
3145: IF NOT HZ_MATCH_RULE_36.check_staged THEN
3146: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3147: FND_MSG_PUB.ADD;
3148: RAISE FND_API.G_EXC_ERROR;
3149: END IF;

Line 3150: HZ_MATCH_RULE_36.find_parties_dynamic(

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

Line 3163: IF NOT HZ_MATCH_RULE_37.check_staged THEN

3159: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3160: p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
3161: -- Code for Match rule DL ADDRESS DEFAULT
3162: ELSIF p_rule_id=37 THEN
3163: IF NOT HZ_MATCH_RULE_37.check_staged THEN
3164: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3165: FND_MSG_PUB.ADD;
3166: RAISE FND_API.G_EXC_ERROR;
3167: END IF;

Line 3168: HZ_MATCH_RULE_37.find_parties_dynamic(

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

Line 3181: IF NOT HZ_MATCH_RULE_38.check_staged THEN

3177: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3178: p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
3179: -- Code for Match rule DL RELATIONSHIP DEFAULT
3180: ELSIF p_rule_id=38 THEN
3181: IF NOT HZ_MATCH_RULE_38.check_staged THEN
3182: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3183: FND_MSG_PUB.ADD;
3184: RAISE FND_API.G_EXC_ERROR;
3185: END IF;

Line 3186: HZ_MATCH_RULE_38.find_parties_dynamic(

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

Line 3199: IF NOT HZ_MATCH_RULE_39.check_staged THEN

3195: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3196: p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
3197: -- Code for Match rule SAMPLE: SEARCH ADDRESS ORGANIZATIONS EXACT
3198: ELSIF p_rule_id=39 THEN
3199: IF NOT HZ_MATCH_RULE_39.check_staged THEN
3200: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3201: FND_MSG_PUB.ADD;
3202: RAISE FND_API.G_EXC_ERROR;
3203: END IF;

Line 3204: HZ_MATCH_RULE_39.find_parties_dynamic(

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

Line 3648: IF NOT HZ_MATCH_RULE_3.check_staged THEN

3644: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3645: p_restrict_sql,p_api_name,p_match_type,p_party_id,p_search_merged,x_search_ctx_id,x_num_matches);
3646: -- Code for Match rule SAMPLE: PERSON_OPTIMIZED
3647: ELSIF p_rule_id=3 THEN
3648: IF NOT HZ_MATCH_RULE_3.check_staged THEN
3649: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3650: FND_MSG_PUB.ADD;
3651: RAISE FND_API.G_EXC_ERROR;
3652: END IF;

Line 3653: HZ_MATCH_RULE_3.call_api_dynamic(

3649: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3650: FND_MSG_PUB.ADD;
3651: RAISE FND_API.G_EXC_ERROR;
3652: END IF;
3653: HZ_MATCH_RULE_3.call_api_dynamic(
3654: p_rule_id,
3655: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
3656: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
3657: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 3756: IF NOT HZ_MATCH_RULE_32.check_staged THEN

3752: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3753: p_restrict_sql,p_api_name,p_match_type,p_party_id,p_search_merged,x_search_ctx_id,x_num_matches);
3754: -- Code for Match rule RM SEARCH RULE
3755: ELSIF p_rule_id=32 THEN
3756: IF NOT HZ_MATCH_RULE_32.check_staged THEN
3757: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3758: FND_MSG_PUB.ADD;
3759: RAISE FND_API.G_EXC_ERROR;
3760: END IF;

Line 3761: HZ_MATCH_RULE_32.call_api_dynamic(

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

Line 3774: IF NOT HZ_MATCH_RULE_33.check_staged THEN

3770: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3771: p_restrict_sql,p_api_name,p_match_type,p_party_id,p_search_merged,x_search_ctx_id,x_num_matches);
3772: -- Code for Match rule SAMPLE:BASIC SEARCH RULE
3773: ELSIF p_rule_id=33 THEN
3774: IF NOT HZ_MATCH_RULE_33.check_staged THEN
3775: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3776: FND_MSG_PUB.ADD;
3777: RAISE FND_API.G_EXC_ERROR;
3778: END IF;

Line 3779: HZ_MATCH_RULE_33.call_api_dynamic(

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

Line 3792: IF NOT HZ_MATCH_RULE_34.check_staged THEN

3788: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3789: p_restrict_sql,p_api_name,p_match_type,p_party_id,p_search_merged,x_search_ctx_id,x_num_matches);
3790: -- Code for Match rule SAMPLE:ADVANCED SEARCH RULE
3791: ELSIF p_rule_id=34 THEN
3792: IF NOT HZ_MATCH_RULE_34.check_staged THEN
3793: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3794: FND_MSG_PUB.ADD;
3795: RAISE FND_API.G_EXC_ERROR;
3796: END IF;

Line 3797: HZ_MATCH_RULE_34.call_api_dynamic(

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

Line 3810: IF NOT HZ_MATCH_RULE_35.check_staged THEN

3806: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3807: p_restrict_sql,p_api_name,p_match_type,p_party_id,p_search_merged,x_search_ctx_id,x_num_matches);
3808: -- Code for Match rule DL SMART SEARCH
3809: ELSIF p_rule_id=35 THEN
3810: IF NOT HZ_MATCH_RULE_35.check_staged THEN
3811: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3812: FND_MSG_PUB.ADD;
3813: RAISE FND_API.G_EXC_ERROR;
3814: END IF;

Line 3815: HZ_MATCH_RULE_35.call_api_dynamic(

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

Line 3828: IF NOT HZ_MATCH_RULE_36.check_staged THEN

3824: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3825: p_restrict_sql,p_api_name,p_match_type,p_party_id,p_search_merged,x_search_ctx_id,x_num_matches);
3826: -- Code for Match rule DL ADDRESS AND RELATIONSHIP SEARCH
3827: ELSIF p_rule_id=36 THEN
3828: IF NOT HZ_MATCH_RULE_36.check_staged THEN
3829: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3830: FND_MSG_PUB.ADD;
3831: RAISE FND_API.G_EXC_ERROR;
3832: END IF;

Line 3833: HZ_MATCH_RULE_36.call_api_dynamic(

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

Line 3846: IF NOT HZ_MATCH_RULE_37.check_staged THEN

3842: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3843: p_restrict_sql,p_api_name,p_match_type,p_party_id,p_search_merged,x_search_ctx_id,x_num_matches);
3844: -- Code for Match rule DL ADDRESS DEFAULT
3845: ELSIF p_rule_id=37 THEN
3846: IF NOT HZ_MATCH_RULE_37.check_staged THEN
3847: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3848: FND_MSG_PUB.ADD;
3849: RAISE FND_API.G_EXC_ERROR;
3850: END IF;

Line 3851: HZ_MATCH_RULE_37.call_api_dynamic(

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

Line 3864: IF NOT HZ_MATCH_RULE_38.check_staged THEN

3860: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3861: p_restrict_sql,p_api_name,p_match_type,p_party_id,p_search_merged,x_search_ctx_id,x_num_matches);
3862: -- Code for Match rule DL RELATIONSHIP DEFAULT
3863: ELSIF p_rule_id=38 THEN
3864: IF NOT HZ_MATCH_RULE_38.check_staged THEN
3865: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3866: FND_MSG_PUB.ADD;
3867: RAISE FND_API.G_EXC_ERROR;
3868: END IF;

Line 3869: HZ_MATCH_RULE_38.call_api_dynamic(

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

Line 3882: IF NOT HZ_MATCH_RULE_39.check_staged THEN

3878: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3879: p_restrict_sql,p_api_name,p_match_type,p_party_id,p_search_merged,x_search_ctx_id,x_num_matches);
3880: -- Code for Match rule SAMPLE: SEARCH ADDRESS ORGANIZATIONS EXACT
3881: ELSIF p_rule_id=39 THEN
3882: IF NOT HZ_MATCH_RULE_39.check_staged THEN
3883: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3884: FND_MSG_PUB.ADD;
3885: RAISE FND_API.G_EXC_ERROR;
3886: END IF;

Line 3887: HZ_MATCH_RULE_39.call_api_dynamic(

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

Line 4514: IF NOT HZ_MATCH_RULE_3.check_staged THEN

4510: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4511: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4512: -- Code for Match rule SAMPLE: PERSON_OPTIMIZED
4513: ELSIF p_rule_id=3 THEN
4514: IF NOT HZ_MATCH_RULE_3.check_staged THEN
4515: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4516: FND_MSG_PUB.ADD;
4517: RAISE FND_API.G_EXC_ERROR;
4518: END IF;

Line 4519: HZ_MATCH_RULE_3.get_matching_party_sites(

4515: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4516: FND_MSG_PUB.ADD;
4517: RAISE FND_API.G_EXC_ERROR;
4518: END IF;
4519: HZ_MATCH_RULE_3.get_matching_party_sites(
4520: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4521: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4522: -- Code for Match rule SAMPLE: ADDRESS_ORGANIZATIONS
4523: ELSIF p_rule_id=4 THEN

Line 4574: IF NOT HZ_MATCH_RULE_32.check_staged THEN

4570: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4571: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4572: -- Code for Match rule RM SEARCH RULE
4573: ELSIF p_rule_id=32 THEN
4574: IF NOT HZ_MATCH_RULE_32.check_staged THEN
4575: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4576: FND_MSG_PUB.ADD;
4577: RAISE FND_API.G_EXC_ERROR;
4578: END IF;

Line 4579: HZ_MATCH_RULE_32.get_matching_party_sites(

4575: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4576: FND_MSG_PUB.ADD;
4577: RAISE FND_API.G_EXC_ERROR;
4578: END IF;
4579: HZ_MATCH_RULE_32.get_matching_party_sites(
4580: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4581: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4582: -- Code for Match rule SAMPLE:BASIC SEARCH RULE
4583: ELSIF p_rule_id=33 THEN

Line 4584: IF NOT HZ_MATCH_RULE_33.check_staged THEN

4580: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4581: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4582: -- Code for Match rule SAMPLE:BASIC SEARCH RULE
4583: ELSIF p_rule_id=33 THEN
4584: IF NOT HZ_MATCH_RULE_33.check_staged THEN
4585: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4586: FND_MSG_PUB.ADD;
4587: RAISE FND_API.G_EXC_ERROR;
4588: END IF;

Line 4589: HZ_MATCH_RULE_33.get_matching_party_sites(

4585: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4586: FND_MSG_PUB.ADD;
4587: RAISE FND_API.G_EXC_ERROR;
4588: END IF;
4589: HZ_MATCH_RULE_33.get_matching_party_sites(
4590: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4591: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4592: -- Code for Match rule SAMPLE:ADVANCED SEARCH RULE
4593: ELSIF p_rule_id=34 THEN

Line 4594: IF NOT HZ_MATCH_RULE_34.check_staged THEN

4590: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4591: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4592: -- Code for Match rule SAMPLE:ADVANCED SEARCH RULE
4593: ELSIF p_rule_id=34 THEN
4594: IF NOT HZ_MATCH_RULE_34.check_staged THEN
4595: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4596: FND_MSG_PUB.ADD;
4597: RAISE FND_API.G_EXC_ERROR;
4598: END IF;

Line 4599: HZ_MATCH_RULE_34.get_matching_party_sites(

4595: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4596: FND_MSG_PUB.ADD;
4597: RAISE FND_API.G_EXC_ERROR;
4598: END IF;
4599: HZ_MATCH_RULE_34.get_matching_party_sites(
4600: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4601: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4602: -- Code for Match rule DL SMART SEARCH
4603: ELSIF p_rule_id=35 THEN

Line 4604: IF NOT HZ_MATCH_RULE_35.check_staged THEN

4600: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4601: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4602: -- Code for Match rule DL SMART SEARCH
4603: ELSIF p_rule_id=35 THEN
4604: IF NOT HZ_MATCH_RULE_35.check_staged THEN
4605: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4606: FND_MSG_PUB.ADD;
4607: RAISE FND_API.G_EXC_ERROR;
4608: END IF;

Line 4609: HZ_MATCH_RULE_35.get_matching_party_sites(

4605: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4606: FND_MSG_PUB.ADD;
4607: RAISE FND_API.G_EXC_ERROR;
4608: END IF;
4609: HZ_MATCH_RULE_35.get_matching_party_sites(
4610: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4611: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4612: -- Code for Match rule DL ADDRESS AND RELATIONSHIP SEARCH
4613: ELSIF p_rule_id=36 THEN

Line 4614: IF NOT HZ_MATCH_RULE_36.check_staged THEN

4610: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4611: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4612: -- Code for Match rule DL ADDRESS AND RELATIONSHIP SEARCH
4613: ELSIF p_rule_id=36 THEN
4614: IF NOT HZ_MATCH_RULE_36.check_staged THEN
4615: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4616: FND_MSG_PUB.ADD;
4617: RAISE FND_API.G_EXC_ERROR;
4618: END IF;

Line 4619: HZ_MATCH_RULE_36.get_matching_party_sites(

4615: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4616: FND_MSG_PUB.ADD;
4617: RAISE FND_API.G_EXC_ERROR;
4618: END IF;
4619: HZ_MATCH_RULE_36.get_matching_party_sites(
4620: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4621: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4622: -- Code for Match rule DL ADDRESS DEFAULT
4623: ELSIF p_rule_id=37 THEN

Line 4624: IF NOT HZ_MATCH_RULE_37.check_staged THEN

4620: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4621: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4622: -- Code for Match rule DL ADDRESS DEFAULT
4623: ELSIF p_rule_id=37 THEN
4624: IF NOT HZ_MATCH_RULE_37.check_staged THEN
4625: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4626: FND_MSG_PUB.ADD;
4627: RAISE FND_API.G_EXC_ERROR;
4628: END IF;

Line 4629: HZ_MATCH_RULE_37.get_matching_party_sites(

4625: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4626: FND_MSG_PUB.ADD;
4627: RAISE FND_API.G_EXC_ERROR;
4628: END IF;
4629: HZ_MATCH_RULE_37.get_matching_party_sites(
4630: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4631: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4632: -- Code for Match rule DL RELATIONSHIP DEFAULT
4633: ELSIF p_rule_id=38 THEN

Line 4634: IF NOT HZ_MATCH_RULE_38.check_staged THEN

4630: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4631: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4632: -- Code for Match rule DL RELATIONSHIP DEFAULT
4633: ELSIF p_rule_id=38 THEN
4634: IF NOT HZ_MATCH_RULE_38.check_staged THEN
4635: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4636: FND_MSG_PUB.ADD;
4637: RAISE FND_API.G_EXC_ERROR;
4638: END IF;

Line 4639: HZ_MATCH_RULE_38.get_matching_party_sites(

4635: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4636: FND_MSG_PUB.ADD;
4637: RAISE FND_API.G_EXC_ERROR;
4638: END IF;
4639: HZ_MATCH_RULE_38.get_matching_party_sites(
4640: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4641: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4642: -- Code for Match rule SAMPLE: SEARCH ADDRESS ORGANIZATIONS EXACT
4643: ELSIF p_rule_id=39 THEN

Line 4644: IF NOT HZ_MATCH_RULE_39.check_staged THEN

4640: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4641: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4642: -- Code for Match rule SAMPLE: SEARCH ADDRESS ORGANIZATIONS EXACT
4643: ELSIF p_rule_id=39 THEN
4644: IF NOT HZ_MATCH_RULE_39.check_staged THEN
4645: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4646: FND_MSG_PUB.ADD;
4647: RAISE FND_API.G_EXC_ERROR;
4648: END IF;

Line 4649: HZ_MATCH_RULE_39.get_matching_party_sites(

4645: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4646: FND_MSG_PUB.ADD;
4647: RAISE FND_API.G_EXC_ERROR;
4648: END IF;
4649: HZ_MATCH_RULE_39.get_matching_party_sites(
4650: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4651: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4652: -- Code for Match rule SAMPLE: SEARCH SIMILAR ORGANIZATION EXACT
4653: ELSIF p_rule_id=40 THEN

Line 4933: IF NOT HZ_MATCH_RULE_3.check_staged THEN

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

Line 4938: HZ_MATCH_RULE_3.get_matching_contacts(

4934: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4935: FND_MSG_PUB.ADD;
4936: RAISE FND_API.G_EXC_ERROR;
4937: END IF;
4938: HZ_MATCH_RULE_3.get_matching_contacts(
4939: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
4940: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4941: -- Code for Match rule SAMPLE: ADDRESS_ORGANIZATIONS
4942: ELSIF p_rule_id=4 THEN

Line 4993: IF NOT HZ_MATCH_RULE_32.check_staged THEN

4989: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
4990: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4991: -- Code for Match rule RM SEARCH RULE
4992: ELSIF p_rule_id=32 THEN
4993: IF NOT HZ_MATCH_RULE_32.check_staged THEN
4994: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4995: FND_MSG_PUB.ADD;
4996: RAISE FND_API.G_EXC_ERROR;
4997: END IF;

Line 4998: HZ_MATCH_RULE_32.get_matching_contacts(

4994: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4995: FND_MSG_PUB.ADD;
4996: RAISE FND_API.G_EXC_ERROR;
4997: END IF;
4998: HZ_MATCH_RULE_32.get_matching_contacts(
4999: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
5000: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5001: -- Code for Match rule SAMPLE:BASIC SEARCH RULE
5002: ELSIF p_rule_id=33 THEN

Line 5003: IF NOT HZ_MATCH_RULE_33.check_staged THEN

4999: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
5000: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5001: -- Code for Match rule SAMPLE:BASIC SEARCH RULE
5002: ELSIF p_rule_id=33 THEN
5003: IF NOT HZ_MATCH_RULE_33.check_staged THEN
5004: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5005: FND_MSG_PUB.ADD;
5006: RAISE FND_API.G_EXC_ERROR;
5007: END IF;

Line 5008: HZ_MATCH_RULE_33.get_matching_contacts(

5004: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5005: FND_MSG_PUB.ADD;
5006: RAISE FND_API.G_EXC_ERROR;
5007: END IF;
5008: HZ_MATCH_RULE_33.get_matching_contacts(
5009: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
5010: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5011: -- Code for Match rule SAMPLE:ADVANCED SEARCH RULE
5012: ELSIF p_rule_id=34 THEN

Line 5013: IF NOT HZ_MATCH_RULE_34.check_staged THEN

5009: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
5010: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5011: -- Code for Match rule SAMPLE:ADVANCED SEARCH RULE
5012: ELSIF p_rule_id=34 THEN
5013: IF NOT HZ_MATCH_RULE_34.check_staged THEN
5014: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5015: FND_MSG_PUB.ADD;
5016: RAISE FND_API.G_EXC_ERROR;
5017: END IF;

Line 5018: HZ_MATCH_RULE_34.get_matching_contacts(

5014: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5015: FND_MSG_PUB.ADD;
5016: RAISE FND_API.G_EXC_ERROR;
5017: END IF;
5018: HZ_MATCH_RULE_34.get_matching_contacts(
5019: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
5020: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5021: -- Code for Match rule DL SMART SEARCH
5022: ELSIF p_rule_id=35 THEN

Line 5023: IF NOT HZ_MATCH_RULE_35.check_staged THEN

5019: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
5020: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5021: -- Code for Match rule DL SMART SEARCH
5022: ELSIF p_rule_id=35 THEN
5023: IF NOT HZ_MATCH_RULE_35.check_staged THEN
5024: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5025: FND_MSG_PUB.ADD;
5026: RAISE FND_API.G_EXC_ERROR;
5027: END IF;

Line 5028: HZ_MATCH_RULE_35.get_matching_contacts(

5024: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5025: FND_MSG_PUB.ADD;
5026: RAISE FND_API.G_EXC_ERROR;
5027: END IF;
5028: HZ_MATCH_RULE_35.get_matching_contacts(
5029: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
5030: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5031: -- Code for Match rule DL ADDRESS AND RELATIONSHIP SEARCH
5032: ELSIF p_rule_id=36 THEN

Line 5033: IF NOT HZ_MATCH_RULE_36.check_staged THEN

5029: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
5030: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5031: -- Code for Match rule DL ADDRESS AND RELATIONSHIP SEARCH
5032: ELSIF p_rule_id=36 THEN
5033: IF NOT HZ_MATCH_RULE_36.check_staged THEN
5034: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5035: FND_MSG_PUB.ADD;
5036: RAISE FND_API.G_EXC_ERROR;
5037: END IF;

Line 5038: HZ_MATCH_RULE_36.get_matching_contacts(

5034: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5035: FND_MSG_PUB.ADD;
5036: RAISE FND_API.G_EXC_ERROR;
5037: END IF;
5038: HZ_MATCH_RULE_36.get_matching_contacts(
5039: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
5040: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5041: -- Code for Match rule DL ADDRESS DEFAULT
5042: ELSIF p_rule_id=37 THEN

Line 5043: IF NOT HZ_MATCH_RULE_37.check_staged THEN

5039: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
5040: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5041: -- Code for Match rule DL ADDRESS DEFAULT
5042: ELSIF p_rule_id=37 THEN
5043: IF NOT HZ_MATCH_RULE_37.check_staged THEN
5044: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5045: FND_MSG_PUB.ADD;
5046: RAISE FND_API.G_EXC_ERROR;
5047: END IF;

Line 5048: HZ_MATCH_RULE_37.get_matching_contacts(

5044: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5045: FND_MSG_PUB.ADD;
5046: RAISE FND_API.G_EXC_ERROR;
5047: END IF;
5048: HZ_MATCH_RULE_37.get_matching_contacts(
5049: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
5050: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5051: -- Code for Match rule DL RELATIONSHIP DEFAULT
5052: ELSIF p_rule_id=38 THEN

Line 5053: IF NOT HZ_MATCH_RULE_38.check_staged THEN

5049: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
5050: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5051: -- Code for Match rule DL RELATIONSHIP DEFAULT
5052: ELSIF p_rule_id=38 THEN
5053: IF NOT HZ_MATCH_RULE_38.check_staged THEN
5054: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5055: FND_MSG_PUB.ADD;
5056: RAISE FND_API.G_EXC_ERROR;
5057: END IF;

Line 5058: HZ_MATCH_RULE_38.get_matching_contacts(

5054: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5055: FND_MSG_PUB.ADD;
5056: RAISE FND_API.G_EXC_ERROR;
5057: END IF;
5058: HZ_MATCH_RULE_38.get_matching_contacts(
5059: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
5060: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5061: -- Code for Match rule SAMPLE: SEARCH ADDRESS ORGANIZATIONS EXACT
5062: ELSIF p_rule_id=39 THEN

Line 5063: IF NOT HZ_MATCH_RULE_39.check_staged THEN

5059: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
5060: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5061: -- Code for Match rule SAMPLE: SEARCH ADDRESS ORGANIZATIONS EXACT
5062: ELSIF p_rule_id=39 THEN
5063: IF NOT HZ_MATCH_RULE_39.check_staged THEN
5064: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5065: FND_MSG_PUB.ADD;
5066: RAISE FND_API.G_EXC_ERROR;
5067: END IF;

Line 5068: HZ_MATCH_RULE_39.get_matching_contacts(

5064: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5065: FND_MSG_PUB.ADD;
5066: RAISE FND_API.G_EXC_ERROR;
5067: END IF;
5068: HZ_MATCH_RULE_39.get_matching_contacts(
5069: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
5070: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5071: -- Code for Match rule SAMPLE: SEARCH SIMILAR ORGANIZATION EXACT
5072: ELSIF p_rule_id=40 THEN

Line 5350: IF NOT HZ_MATCH_RULE_3.check_staged THEN

5346: p_rule_id, p_party_id, p_contact_point_list,
5347: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5348: -- Code for Match rule SAMPLE: PERSON_OPTIMIZED
5349: ELSIF p_rule_id=3 THEN
5350: IF NOT HZ_MATCH_RULE_3.check_staged THEN
5351: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5352: FND_MSG_PUB.ADD;
5353: RAISE FND_API.G_EXC_ERROR;
5354: END IF;

Line 5355: HZ_MATCH_RULE_3.get_matching_contact_points(

5351: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5352: FND_MSG_PUB.ADD;
5353: RAISE FND_API.G_EXC_ERROR;
5354: END IF;
5355: HZ_MATCH_RULE_3.get_matching_contact_points(
5356: p_rule_id, p_party_id, p_contact_point_list,
5357: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5358: -- Code for Match rule SAMPLE: ADDRESS_ORGANIZATIONS
5359: ELSIF p_rule_id=4 THEN

Line 5410: IF NOT HZ_MATCH_RULE_32.check_staged THEN

5406: p_rule_id, p_party_id, p_contact_point_list,
5407: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5408: -- Code for Match rule RM SEARCH RULE
5409: ELSIF p_rule_id=32 THEN
5410: IF NOT HZ_MATCH_RULE_32.check_staged THEN
5411: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5412: FND_MSG_PUB.ADD;
5413: RAISE FND_API.G_EXC_ERROR;
5414: END IF;

Line 5415: HZ_MATCH_RULE_32.get_matching_contact_points(

5411: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5412: FND_MSG_PUB.ADD;
5413: RAISE FND_API.G_EXC_ERROR;
5414: END IF;
5415: HZ_MATCH_RULE_32.get_matching_contact_points(
5416: p_rule_id, p_party_id, p_contact_point_list,
5417: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5418: -- Code for Match rule SAMPLE:BASIC SEARCH RULE
5419: ELSIF p_rule_id=33 THEN

Line 5420: IF NOT HZ_MATCH_RULE_33.check_staged THEN

5416: p_rule_id, p_party_id, p_contact_point_list,
5417: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5418: -- Code for Match rule SAMPLE:BASIC SEARCH RULE
5419: ELSIF p_rule_id=33 THEN
5420: IF NOT HZ_MATCH_RULE_33.check_staged THEN
5421: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5422: FND_MSG_PUB.ADD;
5423: RAISE FND_API.G_EXC_ERROR;
5424: END IF;

Line 5425: HZ_MATCH_RULE_33.get_matching_contact_points(

5421: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5422: FND_MSG_PUB.ADD;
5423: RAISE FND_API.G_EXC_ERROR;
5424: END IF;
5425: HZ_MATCH_RULE_33.get_matching_contact_points(
5426: p_rule_id, p_party_id, p_contact_point_list,
5427: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5428: -- Code for Match rule SAMPLE:ADVANCED SEARCH RULE
5429: ELSIF p_rule_id=34 THEN

Line 5430: IF NOT HZ_MATCH_RULE_34.check_staged THEN

5426: p_rule_id, p_party_id, p_contact_point_list,
5427: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5428: -- Code for Match rule SAMPLE:ADVANCED SEARCH RULE
5429: ELSIF p_rule_id=34 THEN
5430: IF NOT HZ_MATCH_RULE_34.check_staged THEN
5431: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5432: FND_MSG_PUB.ADD;
5433: RAISE FND_API.G_EXC_ERROR;
5434: END IF;

Line 5435: HZ_MATCH_RULE_34.get_matching_contact_points(

5431: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5432: FND_MSG_PUB.ADD;
5433: RAISE FND_API.G_EXC_ERROR;
5434: END IF;
5435: HZ_MATCH_RULE_34.get_matching_contact_points(
5436: p_rule_id, p_party_id, p_contact_point_list,
5437: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5438: -- Code for Match rule DL SMART SEARCH
5439: ELSIF p_rule_id=35 THEN

Line 5440: IF NOT HZ_MATCH_RULE_35.check_staged THEN

5436: p_rule_id, p_party_id, p_contact_point_list,
5437: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5438: -- Code for Match rule DL SMART SEARCH
5439: ELSIF p_rule_id=35 THEN
5440: IF NOT HZ_MATCH_RULE_35.check_staged THEN
5441: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5442: FND_MSG_PUB.ADD;
5443: RAISE FND_API.G_EXC_ERROR;
5444: END IF;

Line 5445: HZ_MATCH_RULE_35.get_matching_contact_points(

5441: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5442: FND_MSG_PUB.ADD;
5443: RAISE FND_API.G_EXC_ERROR;
5444: END IF;
5445: HZ_MATCH_RULE_35.get_matching_contact_points(
5446: p_rule_id, p_party_id, p_contact_point_list,
5447: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5448: -- Code for Match rule DL ADDRESS AND RELATIONSHIP SEARCH
5449: ELSIF p_rule_id=36 THEN

Line 5450: IF NOT HZ_MATCH_RULE_36.check_staged THEN

5446: p_rule_id, p_party_id, p_contact_point_list,
5447: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5448: -- Code for Match rule DL ADDRESS AND RELATIONSHIP SEARCH
5449: ELSIF p_rule_id=36 THEN
5450: IF NOT HZ_MATCH_RULE_36.check_staged THEN
5451: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5452: FND_MSG_PUB.ADD;
5453: RAISE FND_API.G_EXC_ERROR;
5454: END IF;

Line 5455: HZ_MATCH_RULE_36.get_matching_contact_points(

5451: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5452: FND_MSG_PUB.ADD;
5453: RAISE FND_API.G_EXC_ERROR;
5454: END IF;
5455: HZ_MATCH_RULE_36.get_matching_contact_points(
5456: p_rule_id, p_party_id, p_contact_point_list,
5457: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5458: -- Code for Match rule DL ADDRESS DEFAULT
5459: ELSIF p_rule_id=37 THEN

Line 5460: IF NOT HZ_MATCH_RULE_37.check_staged THEN

5456: p_rule_id, p_party_id, p_contact_point_list,
5457: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5458: -- Code for Match rule DL ADDRESS DEFAULT
5459: ELSIF p_rule_id=37 THEN
5460: IF NOT HZ_MATCH_RULE_37.check_staged THEN
5461: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5462: FND_MSG_PUB.ADD;
5463: RAISE FND_API.G_EXC_ERROR;
5464: END IF;

Line 5465: HZ_MATCH_RULE_37.get_matching_contact_points(

5461: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5462: FND_MSG_PUB.ADD;
5463: RAISE FND_API.G_EXC_ERROR;
5464: END IF;
5465: HZ_MATCH_RULE_37.get_matching_contact_points(
5466: p_rule_id, p_party_id, p_contact_point_list,
5467: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5468: -- Code for Match rule DL RELATIONSHIP DEFAULT
5469: ELSIF p_rule_id=38 THEN

Line 5470: IF NOT HZ_MATCH_RULE_38.check_staged THEN

5466: p_rule_id, p_party_id, p_contact_point_list,
5467: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5468: -- Code for Match rule DL RELATIONSHIP DEFAULT
5469: ELSIF p_rule_id=38 THEN
5470: IF NOT HZ_MATCH_RULE_38.check_staged THEN
5471: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5472: FND_MSG_PUB.ADD;
5473: RAISE FND_API.G_EXC_ERROR;
5474: END IF;

Line 5475: HZ_MATCH_RULE_38.get_matching_contact_points(

5471: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5472: FND_MSG_PUB.ADD;
5473: RAISE FND_API.G_EXC_ERROR;
5474: END IF;
5475: HZ_MATCH_RULE_38.get_matching_contact_points(
5476: p_rule_id, p_party_id, p_contact_point_list,
5477: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5478: -- Code for Match rule SAMPLE: SEARCH ADDRESS ORGANIZATIONS EXACT
5479: ELSIF p_rule_id=39 THEN

Line 5480: IF NOT HZ_MATCH_RULE_39.check_staged THEN

5476: p_rule_id, p_party_id, p_contact_point_list,
5477: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5478: -- Code for Match rule SAMPLE: SEARCH ADDRESS ORGANIZATIONS EXACT
5479: ELSIF p_rule_id=39 THEN
5480: IF NOT HZ_MATCH_RULE_39.check_staged THEN
5481: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5482: FND_MSG_PUB.ADD;
5483: RAISE FND_API.G_EXC_ERROR;
5484: END IF;

Line 5485: HZ_MATCH_RULE_39.get_matching_contact_points(

5481: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5482: FND_MSG_PUB.ADD;
5483: RAISE FND_API.G_EXC_ERROR;
5484: END IF;
5485: HZ_MATCH_RULE_39.get_matching_contact_points(
5486: p_rule_id, p_party_id, p_contact_point_list,
5487: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5488: -- Code for Match rule SAMPLE: SEARCH SIMILAR ORGANIZATION EXACT
5489: ELSIF p_rule_id=40 THEN

Line 5771: IF NOT HZ_MATCH_RULE_3.check_staged THEN

5767: p_party_id, p_party_search_rec,p_party_site_list,
5768: p_contact_list, p_contact_point_list,x_search_ctx_id);
5769: -- Code for Match rule SAMPLE: PERSON_OPTIMIZED
5770: ELSIF p_rule_id=3 THEN
5771: IF NOT HZ_MATCH_RULE_3.check_staged THEN
5772: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5773: FND_MSG_PUB.ADD;
5774: RAISE FND_API.G_EXC_ERROR;
5775: END IF;

Line 5776: HZ_MATCH_RULE_3.get_score_details(

5772: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5773: FND_MSG_PUB.ADD;
5774: RAISE FND_API.G_EXC_ERROR;
5775: END IF;
5776: HZ_MATCH_RULE_3.get_score_details(
5777: p_rule_id,
5778: p_party_id, p_party_search_rec,p_party_site_list,
5779: p_contact_list, p_contact_point_list,x_search_ctx_id);
5780: -- Code for Match rule SAMPLE: ADDRESS_ORGANIZATIONS

Line 5837: IF NOT HZ_MATCH_RULE_32.check_staged THEN

5833: p_party_id, p_party_search_rec,p_party_site_list,
5834: p_contact_list, p_contact_point_list,x_search_ctx_id);
5835: -- Code for Match rule RM SEARCH RULE
5836: ELSIF p_rule_id=32 THEN
5837: IF NOT HZ_MATCH_RULE_32.check_staged THEN
5838: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5839: FND_MSG_PUB.ADD;
5840: RAISE FND_API.G_EXC_ERROR;
5841: END IF;

Line 5842: HZ_MATCH_RULE_32.get_score_details(

5838: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5839: FND_MSG_PUB.ADD;
5840: RAISE FND_API.G_EXC_ERROR;
5841: END IF;
5842: HZ_MATCH_RULE_32.get_score_details(
5843: p_rule_id,
5844: p_party_id, p_party_search_rec,p_party_site_list,
5845: p_contact_list, p_contact_point_list,x_search_ctx_id);
5846: -- Code for Match rule SAMPLE:BASIC SEARCH RULE

Line 5848: IF NOT HZ_MATCH_RULE_33.check_staged THEN

5844: p_party_id, p_party_search_rec,p_party_site_list,
5845: p_contact_list, p_contact_point_list,x_search_ctx_id);
5846: -- Code for Match rule SAMPLE:BASIC SEARCH RULE
5847: ELSIF p_rule_id=33 THEN
5848: IF NOT HZ_MATCH_RULE_33.check_staged THEN
5849: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5850: FND_MSG_PUB.ADD;
5851: RAISE FND_API.G_EXC_ERROR;
5852: END IF;

Line 5853: HZ_MATCH_RULE_33.get_score_details(

5849: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5850: FND_MSG_PUB.ADD;
5851: RAISE FND_API.G_EXC_ERROR;
5852: END IF;
5853: HZ_MATCH_RULE_33.get_score_details(
5854: p_rule_id,
5855: p_party_id, p_party_search_rec,p_party_site_list,
5856: p_contact_list, p_contact_point_list,x_search_ctx_id);
5857: -- Code for Match rule SAMPLE:ADVANCED SEARCH RULE

Line 5859: IF NOT HZ_MATCH_RULE_34.check_staged THEN

5855: p_party_id, p_party_search_rec,p_party_site_list,
5856: p_contact_list, p_contact_point_list,x_search_ctx_id);
5857: -- Code for Match rule SAMPLE:ADVANCED SEARCH RULE
5858: ELSIF p_rule_id=34 THEN
5859: IF NOT HZ_MATCH_RULE_34.check_staged THEN
5860: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5861: FND_MSG_PUB.ADD;
5862: RAISE FND_API.G_EXC_ERROR;
5863: END IF;

Line 5864: HZ_MATCH_RULE_34.get_score_details(

5860: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5861: FND_MSG_PUB.ADD;
5862: RAISE FND_API.G_EXC_ERROR;
5863: END IF;
5864: HZ_MATCH_RULE_34.get_score_details(
5865: p_rule_id,
5866: p_party_id, p_party_search_rec,p_party_site_list,
5867: p_contact_list, p_contact_point_list,x_search_ctx_id);
5868: -- Code for Match rule DL SMART SEARCH

Line 5870: IF NOT HZ_MATCH_RULE_35.check_staged THEN

5866: p_party_id, p_party_search_rec,p_party_site_list,
5867: p_contact_list, p_contact_point_list,x_search_ctx_id);
5868: -- Code for Match rule DL SMART SEARCH
5869: ELSIF p_rule_id=35 THEN
5870: IF NOT HZ_MATCH_RULE_35.check_staged THEN
5871: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5872: FND_MSG_PUB.ADD;
5873: RAISE FND_API.G_EXC_ERROR;
5874: END IF;

Line 5875: HZ_MATCH_RULE_35.get_score_details(

5871: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5872: FND_MSG_PUB.ADD;
5873: RAISE FND_API.G_EXC_ERROR;
5874: END IF;
5875: HZ_MATCH_RULE_35.get_score_details(
5876: p_rule_id,
5877: p_party_id, p_party_search_rec,p_party_site_list,
5878: p_contact_list, p_contact_point_list,x_search_ctx_id);
5879: -- Code for Match rule DL ADDRESS AND RELATIONSHIP SEARCH

Line 5881: IF NOT HZ_MATCH_RULE_36.check_staged THEN

5877: p_party_id, p_party_search_rec,p_party_site_list,
5878: p_contact_list, p_contact_point_list,x_search_ctx_id);
5879: -- Code for Match rule DL ADDRESS AND RELATIONSHIP SEARCH
5880: ELSIF p_rule_id=36 THEN
5881: IF NOT HZ_MATCH_RULE_36.check_staged THEN
5882: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5883: FND_MSG_PUB.ADD;
5884: RAISE FND_API.G_EXC_ERROR;
5885: END IF;

Line 5886: HZ_MATCH_RULE_36.get_score_details(

5882: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5883: FND_MSG_PUB.ADD;
5884: RAISE FND_API.G_EXC_ERROR;
5885: END IF;
5886: HZ_MATCH_RULE_36.get_score_details(
5887: p_rule_id,
5888: p_party_id, p_party_search_rec,p_party_site_list,
5889: p_contact_list, p_contact_point_list,x_search_ctx_id);
5890: -- Code for Match rule DL ADDRESS DEFAULT

Line 5892: IF NOT HZ_MATCH_RULE_37.check_staged THEN

5888: p_party_id, p_party_search_rec,p_party_site_list,
5889: p_contact_list, p_contact_point_list,x_search_ctx_id);
5890: -- Code for Match rule DL ADDRESS DEFAULT
5891: ELSIF p_rule_id=37 THEN
5892: IF NOT HZ_MATCH_RULE_37.check_staged THEN
5893: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5894: FND_MSG_PUB.ADD;
5895: RAISE FND_API.G_EXC_ERROR;
5896: END IF;

Line 5897: HZ_MATCH_RULE_37.get_score_details(

5893: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5894: FND_MSG_PUB.ADD;
5895: RAISE FND_API.G_EXC_ERROR;
5896: END IF;
5897: HZ_MATCH_RULE_37.get_score_details(
5898: p_rule_id,
5899: p_party_id, p_party_search_rec,p_party_site_list,
5900: p_contact_list, p_contact_point_list,x_search_ctx_id);
5901: -- Code for Match rule DL RELATIONSHIP DEFAULT

Line 5903: IF NOT HZ_MATCH_RULE_38.check_staged THEN

5899: p_party_id, p_party_search_rec,p_party_site_list,
5900: p_contact_list, p_contact_point_list,x_search_ctx_id);
5901: -- Code for Match rule DL RELATIONSHIP DEFAULT
5902: ELSIF p_rule_id=38 THEN
5903: IF NOT HZ_MATCH_RULE_38.check_staged THEN
5904: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5905: FND_MSG_PUB.ADD;
5906: RAISE FND_API.G_EXC_ERROR;
5907: END IF;

Line 5908: HZ_MATCH_RULE_38.get_score_details(

5904: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5905: FND_MSG_PUB.ADD;
5906: RAISE FND_API.G_EXC_ERROR;
5907: END IF;
5908: HZ_MATCH_RULE_38.get_score_details(
5909: p_rule_id,
5910: p_party_id, p_party_search_rec,p_party_site_list,
5911: p_contact_list, p_contact_point_list,x_search_ctx_id);
5912: -- Code for Match rule SAMPLE: SEARCH ADDRESS ORGANIZATIONS EXACT

Line 5914: IF NOT HZ_MATCH_RULE_39.check_staged THEN

5910: p_party_id, p_party_search_rec,p_party_site_list,
5911: p_contact_list, p_contact_point_list,x_search_ctx_id);
5912: -- Code for Match rule SAMPLE: SEARCH ADDRESS ORGANIZATIONS EXACT
5913: ELSIF p_rule_id=39 THEN
5914: IF NOT HZ_MATCH_RULE_39.check_staged THEN
5915: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5916: FND_MSG_PUB.ADD;
5917: RAISE FND_API.G_EXC_ERROR;
5918: END IF;

Line 5919: HZ_MATCH_RULE_39.get_score_details(

5915: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5916: FND_MSG_PUB.ADD;
5917: RAISE FND_API.G_EXC_ERROR;
5918: END IF;
5919: HZ_MATCH_RULE_39.get_score_details(
5920: p_rule_id,
5921: p_party_id, p_party_search_rec,p_party_site_list,
5922: p_contact_list, p_contact_point_list,x_search_ctx_id);
5923: -- Code for Match rule SAMPLE: SEARCH SIMILAR ORGANIZATION EXACT

Line 6190: IF NOT HZ_MATCH_RULE_3.check_staged THEN

6186: p_party_id, x_party_search_rec,x_party_site_list,
6187: x_contact_list, x_contact_point_list);
6188: -- Code for Match rule SAMPLE: PERSON_OPTIMIZED
6189: ELSIF p_rule_id=3 THEN
6190: IF NOT HZ_MATCH_RULE_3.check_staged THEN
6191: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6192: FND_MSG_PUB.ADD;
6193: RAISE FND_API.G_EXC_ERROR;
6194: END IF;

Line 6195: HZ_MATCH_RULE_3.get_party_for_search(

6191: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6192: FND_MSG_PUB.ADD;
6193: RAISE FND_API.G_EXC_ERROR;
6194: END IF;
6195: HZ_MATCH_RULE_3.get_party_for_search(
6196: p_party_id, x_party_search_rec,x_party_site_list,
6197: x_contact_list, x_contact_point_list);
6198: -- Code for Match rule SAMPLE: ADDRESS_ORGANIZATIONS
6199: ELSIF p_rule_id=4 THEN

Line 6250: IF NOT HZ_MATCH_RULE_32.check_staged THEN

6246: p_party_id, x_party_search_rec,x_party_site_list,
6247: x_contact_list, x_contact_point_list);
6248: -- Code for Match rule RM SEARCH RULE
6249: ELSIF p_rule_id=32 THEN
6250: IF NOT HZ_MATCH_RULE_32.check_staged THEN
6251: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6252: FND_MSG_PUB.ADD;
6253: RAISE FND_API.G_EXC_ERROR;
6254: END IF;

Line 6255: HZ_MATCH_RULE_32.get_party_for_search(

6251: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6252: FND_MSG_PUB.ADD;
6253: RAISE FND_API.G_EXC_ERROR;
6254: END IF;
6255: HZ_MATCH_RULE_32.get_party_for_search(
6256: p_party_id, x_party_search_rec,x_party_site_list,
6257: x_contact_list, x_contact_point_list);
6258: -- Code for Match rule SAMPLE:BASIC SEARCH RULE
6259: ELSIF p_rule_id=33 THEN

Line 6260: IF NOT HZ_MATCH_RULE_33.check_staged THEN

6256: p_party_id, x_party_search_rec,x_party_site_list,
6257: x_contact_list, x_contact_point_list);
6258: -- Code for Match rule SAMPLE:BASIC SEARCH RULE
6259: ELSIF p_rule_id=33 THEN
6260: IF NOT HZ_MATCH_RULE_33.check_staged THEN
6261: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6262: FND_MSG_PUB.ADD;
6263: RAISE FND_API.G_EXC_ERROR;
6264: END IF;

Line 6265: HZ_MATCH_RULE_33.get_party_for_search(

6261: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6262: FND_MSG_PUB.ADD;
6263: RAISE FND_API.G_EXC_ERROR;
6264: END IF;
6265: HZ_MATCH_RULE_33.get_party_for_search(
6266: p_party_id, x_party_search_rec,x_party_site_list,
6267: x_contact_list, x_contact_point_list);
6268: -- Code for Match rule SAMPLE:ADVANCED SEARCH RULE
6269: ELSIF p_rule_id=34 THEN

Line 6270: IF NOT HZ_MATCH_RULE_34.check_staged THEN

6266: p_party_id, x_party_search_rec,x_party_site_list,
6267: x_contact_list, x_contact_point_list);
6268: -- Code for Match rule SAMPLE:ADVANCED SEARCH RULE
6269: ELSIF p_rule_id=34 THEN
6270: IF NOT HZ_MATCH_RULE_34.check_staged THEN
6271: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6272: FND_MSG_PUB.ADD;
6273: RAISE FND_API.G_EXC_ERROR;
6274: END IF;

Line 6275: HZ_MATCH_RULE_34.get_party_for_search(

6271: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6272: FND_MSG_PUB.ADD;
6273: RAISE FND_API.G_EXC_ERROR;
6274: END IF;
6275: HZ_MATCH_RULE_34.get_party_for_search(
6276: p_party_id, x_party_search_rec,x_party_site_list,
6277: x_contact_list, x_contact_point_list);
6278: -- Code for Match rule DL SMART SEARCH
6279: ELSIF p_rule_id=35 THEN

Line 6280: IF NOT HZ_MATCH_RULE_35.check_staged THEN

6276: p_party_id, x_party_search_rec,x_party_site_list,
6277: x_contact_list, x_contact_point_list);
6278: -- Code for Match rule DL SMART SEARCH
6279: ELSIF p_rule_id=35 THEN
6280: IF NOT HZ_MATCH_RULE_35.check_staged THEN
6281: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6282: FND_MSG_PUB.ADD;
6283: RAISE FND_API.G_EXC_ERROR;
6284: END IF;

Line 6285: HZ_MATCH_RULE_35.get_party_for_search(

6281: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6282: FND_MSG_PUB.ADD;
6283: RAISE FND_API.G_EXC_ERROR;
6284: END IF;
6285: HZ_MATCH_RULE_35.get_party_for_search(
6286: p_party_id, x_party_search_rec,x_party_site_list,
6287: x_contact_list, x_contact_point_list);
6288: -- Code for Match rule DL ADDRESS AND RELATIONSHIP SEARCH
6289: ELSIF p_rule_id=36 THEN

Line 6290: IF NOT HZ_MATCH_RULE_36.check_staged THEN

6286: p_party_id, x_party_search_rec,x_party_site_list,
6287: x_contact_list, x_contact_point_list);
6288: -- Code for Match rule DL ADDRESS AND RELATIONSHIP SEARCH
6289: ELSIF p_rule_id=36 THEN
6290: IF NOT HZ_MATCH_RULE_36.check_staged THEN
6291: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6292: FND_MSG_PUB.ADD;
6293: RAISE FND_API.G_EXC_ERROR;
6294: END IF;

Line 6295: HZ_MATCH_RULE_36.get_party_for_search(

6291: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6292: FND_MSG_PUB.ADD;
6293: RAISE FND_API.G_EXC_ERROR;
6294: END IF;
6295: HZ_MATCH_RULE_36.get_party_for_search(
6296: p_party_id, x_party_search_rec,x_party_site_list,
6297: x_contact_list, x_contact_point_list);
6298: -- Code for Match rule DL ADDRESS DEFAULT
6299: ELSIF p_rule_id=37 THEN

Line 6300: IF NOT HZ_MATCH_RULE_37.check_staged THEN

6296: p_party_id, x_party_search_rec,x_party_site_list,
6297: x_contact_list, x_contact_point_list);
6298: -- Code for Match rule DL ADDRESS DEFAULT
6299: ELSIF p_rule_id=37 THEN
6300: IF NOT HZ_MATCH_RULE_37.check_staged THEN
6301: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6302: FND_MSG_PUB.ADD;
6303: RAISE FND_API.G_EXC_ERROR;
6304: END IF;

Line 6305: HZ_MATCH_RULE_37.get_party_for_search(

6301: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6302: FND_MSG_PUB.ADD;
6303: RAISE FND_API.G_EXC_ERROR;
6304: END IF;
6305: HZ_MATCH_RULE_37.get_party_for_search(
6306: p_party_id, x_party_search_rec,x_party_site_list,
6307: x_contact_list, x_contact_point_list);
6308: -- Code for Match rule DL RELATIONSHIP DEFAULT
6309: ELSIF p_rule_id=38 THEN

Line 6310: IF NOT HZ_MATCH_RULE_38.check_staged THEN

6306: p_party_id, x_party_search_rec,x_party_site_list,
6307: x_contact_list, x_contact_point_list);
6308: -- Code for Match rule DL RELATIONSHIP DEFAULT
6309: ELSIF p_rule_id=38 THEN
6310: IF NOT HZ_MATCH_RULE_38.check_staged THEN
6311: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6312: FND_MSG_PUB.ADD;
6313: RAISE FND_API.G_EXC_ERROR;
6314: END IF;

Line 6315: HZ_MATCH_RULE_38.get_party_for_search(

6311: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6312: FND_MSG_PUB.ADD;
6313: RAISE FND_API.G_EXC_ERROR;
6314: END IF;
6315: HZ_MATCH_RULE_38.get_party_for_search(
6316: p_party_id, x_party_search_rec,x_party_site_list,
6317: x_contact_list, x_contact_point_list);
6318: -- Code for Match rule SAMPLE: SEARCH ADDRESS ORGANIZATIONS EXACT
6319: ELSIF p_rule_id=39 THEN

Line 6320: IF NOT HZ_MATCH_RULE_39.check_staged THEN

6316: p_party_id, x_party_search_rec,x_party_site_list,
6317: x_contact_list, x_contact_point_list);
6318: -- Code for Match rule SAMPLE: SEARCH ADDRESS ORGANIZATIONS EXACT
6319: ELSIF p_rule_id=39 THEN
6320: IF NOT HZ_MATCH_RULE_39.check_staged THEN
6321: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6322: FND_MSG_PUB.ADD;
6323: RAISE FND_API.G_EXC_ERROR;
6324: END IF;

Line 6325: HZ_MATCH_RULE_39.get_party_for_search(

6321: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6322: FND_MSG_PUB.ADD;
6323: RAISE FND_API.G_EXC_ERROR;
6324: END IF;
6325: HZ_MATCH_RULE_39.get_party_for_search(
6326: p_party_id, x_party_search_rec,x_party_site_list,
6327: x_contact_list, x_contact_point_list);
6328: -- Code for Match rule SAMPLE: SEARCH SIMILAR ORGANIZATION EXACT
6329: ELSIF p_rule_id=40 THEN

Line 6582: IF NOT HZ_MATCH_RULE_3.check_staged THEN

6578: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6579: x_contact_list, x_contact_point_list);
6580: -- Code for Match rule SAMPLE: PERSON_OPTIMIZED
6581: ELSIF p_rule_id=3 THEN
6582: IF NOT HZ_MATCH_RULE_3.check_staged THEN
6583: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6584: FND_MSG_PUB.ADD;
6585: RAISE FND_API.G_EXC_ERROR;
6586: END IF;

Line 6587: HZ_MATCH_RULE_3.get_search_criteria(

6583: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6584: FND_MSG_PUB.ADD;
6585: RAISE FND_API.G_EXC_ERROR;
6586: END IF;
6587: HZ_MATCH_RULE_3.get_search_criteria(
6588: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6589: x_contact_list, x_contact_point_list);
6590: -- Code for Match rule SAMPLE: ADDRESS_ORGANIZATIONS
6591: ELSIF p_rule_id=4 THEN

Line 6642: IF NOT HZ_MATCH_RULE_32.check_staged THEN

6638: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6639: x_contact_list, x_contact_point_list);
6640: -- Code for Match rule RM SEARCH RULE
6641: ELSIF p_rule_id=32 THEN
6642: IF NOT HZ_MATCH_RULE_32.check_staged THEN
6643: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6644: FND_MSG_PUB.ADD;
6645: RAISE FND_API.G_EXC_ERROR;
6646: END IF;

Line 6647: HZ_MATCH_RULE_32.get_search_criteria(

6643: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6644: FND_MSG_PUB.ADD;
6645: RAISE FND_API.G_EXC_ERROR;
6646: END IF;
6647: HZ_MATCH_RULE_32.get_search_criteria(
6648: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6649: x_contact_list, x_contact_point_list);
6650: -- Code for Match rule SAMPLE:BASIC SEARCH RULE
6651: ELSIF p_rule_id=33 THEN

Line 6652: IF NOT HZ_MATCH_RULE_33.check_staged THEN

6648: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6649: x_contact_list, x_contact_point_list);
6650: -- Code for Match rule SAMPLE:BASIC SEARCH RULE
6651: ELSIF p_rule_id=33 THEN
6652: IF NOT HZ_MATCH_RULE_33.check_staged THEN
6653: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6654: FND_MSG_PUB.ADD;
6655: RAISE FND_API.G_EXC_ERROR;
6656: END IF;

Line 6657: HZ_MATCH_RULE_33.get_search_criteria(

6653: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6654: FND_MSG_PUB.ADD;
6655: RAISE FND_API.G_EXC_ERROR;
6656: END IF;
6657: HZ_MATCH_RULE_33.get_search_criteria(
6658: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6659: x_contact_list, x_contact_point_list);
6660: -- Code for Match rule SAMPLE:ADVANCED SEARCH RULE
6661: ELSIF p_rule_id=34 THEN

Line 6662: IF NOT HZ_MATCH_RULE_34.check_staged THEN

6658: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6659: x_contact_list, x_contact_point_list);
6660: -- Code for Match rule SAMPLE:ADVANCED SEARCH RULE
6661: ELSIF p_rule_id=34 THEN
6662: IF NOT HZ_MATCH_RULE_34.check_staged THEN
6663: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6664: FND_MSG_PUB.ADD;
6665: RAISE FND_API.G_EXC_ERROR;
6666: END IF;

Line 6667: HZ_MATCH_RULE_34.get_search_criteria(

6663: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6664: FND_MSG_PUB.ADD;
6665: RAISE FND_API.G_EXC_ERROR;
6666: END IF;
6667: HZ_MATCH_RULE_34.get_search_criteria(
6668: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6669: x_contact_list, x_contact_point_list);
6670: -- Code for Match rule DL SMART SEARCH
6671: ELSIF p_rule_id=35 THEN

Line 6672: IF NOT HZ_MATCH_RULE_35.check_staged THEN

6668: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6669: x_contact_list, x_contact_point_list);
6670: -- Code for Match rule DL SMART SEARCH
6671: ELSIF p_rule_id=35 THEN
6672: IF NOT HZ_MATCH_RULE_35.check_staged THEN
6673: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6674: FND_MSG_PUB.ADD;
6675: RAISE FND_API.G_EXC_ERROR;
6676: END IF;

Line 6677: HZ_MATCH_RULE_35.get_search_criteria(

6673: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6674: FND_MSG_PUB.ADD;
6675: RAISE FND_API.G_EXC_ERROR;
6676: END IF;
6677: HZ_MATCH_RULE_35.get_search_criteria(
6678: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6679: x_contact_list, x_contact_point_list);
6680: -- Code for Match rule DL ADDRESS AND RELATIONSHIP SEARCH
6681: ELSIF p_rule_id=36 THEN

Line 6682: IF NOT HZ_MATCH_RULE_36.check_staged THEN

6678: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6679: x_contact_list, x_contact_point_list);
6680: -- Code for Match rule DL ADDRESS AND RELATIONSHIP SEARCH
6681: ELSIF p_rule_id=36 THEN
6682: IF NOT HZ_MATCH_RULE_36.check_staged THEN
6683: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6684: FND_MSG_PUB.ADD;
6685: RAISE FND_API.G_EXC_ERROR;
6686: END IF;

Line 6687: HZ_MATCH_RULE_36.get_search_criteria(

6683: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6684: FND_MSG_PUB.ADD;
6685: RAISE FND_API.G_EXC_ERROR;
6686: END IF;
6687: HZ_MATCH_RULE_36.get_search_criteria(
6688: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6689: x_contact_list, x_contact_point_list);
6690: -- Code for Match rule DL ADDRESS DEFAULT
6691: ELSIF p_rule_id=37 THEN

Line 6692: IF NOT HZ_MATCH_RULE_37.check_staged THEN

6688: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6689: x_contact_list, x_contact_point_list);
6690: -- Code for Match rule DL ADDRESS DEFAULT
6691: ELSIF p_rule_id=37 THEN
6692: IF NOT HZ_MATCH_RULE_37.check_staged THEN
6693: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6694: FND_MSG_PUB.ADD;
6695: RAISE FND_API.G_EXC_ERROR;
6696: END IF;

Line 6697: HZ_MATCH_RULE_37.get_search_criteria(

6693: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6694: FND_MSG_PUB.ADD;
6695: RAISE FND_API.G_EXC_ERROR;
6696: END IF;
6697: HZ_MATCH_RULE_37.get_search_criteria(
6698: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6699: x_contact_list, x_contact_point_list);
6700: -- Code for Match rule DL RELATIONSHIP DEFAULT
6701: ELSIF p_rule_id=38 THEN

Line 6702: IF NOT HZ_MATCH_RULE_38.check_staged THEN

6698: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6699: x_contact_list, x_contact_point_list);
6700: -- Code for Match rule DL RELATIONSHIP DEFAULT
6701: ELSIF p_rule_id=38 THEN
6702: IF NOT HZ_MATCH_RULE_38.check_staged THEN
6703: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6704: FND_MSG_PUB.ADD;
6705: RAISE FND_API.G_EXC_ERROR;
6706: END IF;

Line 6707: HZ_MATCH_RULE_38.get_search_criteria(

6703: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6704: FND_MSG_PUB.ADD;
6705: RAISE FND_API.G_EXC_ERROR;
6706: END IF;
6707: HZ_MATCH_RULE_38.get_search_criteria(
6708: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6709: x_contact_list, x_contact_point_list);
6710: -- Code for Match rule SAMPLE: SEARCH ADDRESS ORGANIZATIONS EXACT
6711: ELSIF p_rule_id=39 THEN

Line 6712: IF NOT HZ_MATCH_RULE_39.check_staged THEN

6708: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6709: x_contact_list, x_contact_point_list);
6710: -- Code for Match rule SAMPLE: SEARCH ADDRESS ORGANIZATIONS EXACT
6711: ELSIF p_rule_id=39 THEN
6712: IF NOT HZ_MATCH_RULE_39.check_staged THEN
6713: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6714: FND_MSG_PUB.ADD;
6715: RAISE FND_API.G_EXC_ERROR;
6716: END IF;

Line 6717: HZ_MATCH_RULE_39.get_search_criteria(

6713: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6714: FND_MSG_PUB.ADD;
6715: RAISE FND_API.G_EXC_ERROR;
6716: END IF;
6717: HZ_MATCH_RULE_39.get_search_criteria(
6718: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6719: x_contact_list, x_contact_point_list);
6720: -- Code for Match rule SAMPLE: SEARCH SIMILAR ORGANIZATION EXACT
6721: ELSIF p_rule_id=40 THEN