DBA Data[Home] [Help]

APPS.HZ_PARTY_SEARCH dependencies on HZ_MATCH_RULE_34

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 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 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 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 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 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 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 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 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 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 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 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 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 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 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