DBA Data[Home] [Help]

APPS.HZ_PARTY_SEARCH dependencies on HZ_MATCH_RULE_35

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