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 581: IF NOT HZ_MATCH_RULE_34.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 SAMPLE:ADVANCED SEARCH RULE
580: ELSIF p_rule_id=34 THEN
581: IF NOT HZ_MATCH_RULE_34.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_34.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_34.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 DL SMART SEARCH
590: ELSIF p_rule_id=35 THEN

Line 980: IF NOT HZ_MATCH_RULE_34.check_staged THEN

976: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
977: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
978: -- Code for Match rule SAMPLE:ADVANCED SEARCH RULE
979: ELSIF p_rule_id=34 THEN
980: IF NOT HZ_MATCH_RULE_34.check_staged THEN
981: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
982: FND_MSG_PUB.ADD;
983: RAISE FND_API.G_EXC_ERROR;
984: END IF;

Line 985: HZ_MATCH_RULE_34.find_party_details(

981: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
982: FND_MSG_PUB.ADD;
983: RAISE FND_API.G_EXC_ERROR;
984: END IF;
985: HZ_MATCH_RULE_34.find_party_details(
986: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
987: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
988: -- Code for Match rule DL SMART SEARCH
989: ELSIF p_rule_id=35 THEN

Line 1360: IF NOT HZ_MATCH_RULE_34.check_staged THEN

1356: p_rule_id,p_party_id,
1357: p_restrict_sql,p_match_type,p_dup_batch_id,p_search_merged,x_dup_set_id, x_search_ctx_id,x_num_matches);
1358: -- Code for Match rule SAMPLE:ADVANCED SEARCH RULE
1359: ELSIF p_rule_id=34 THEN
1360: IF NOT HZ_MATCH_RULE_34.check_staged THEN
1361: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1362: FND_MSG_PUB.ADD;
1363: RAISE FND_API.G_EXC_ERROR;
1364: END IF;

Line 1365: HZ_MATCH_RULE_34.find_duplicate_parties(

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

Line 1735: IF NOT HZ_MATCH_RULE_34.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:ADVANCED SEARCH RULE
1734: ELSIF p_rule_id=34 THEN
1735: IF NOT HZ_MATCH_RULE_34.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_34.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_34.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 DL SMART SEARCH
1744: ELSIF p_rule_id=35 THEN

Line 2109: IF NOT HZ_MATCH_RULE_34.check_staged THEN

2105: p_rule_id,p_org_contact_id,p_party_id,
2106: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2107: -- Code for Match rule SAMPLE:ADVANCED SEARCH RULE
2108: ELSIF p_rule_id=34 THEN
2109: IF NOT HZ_MATCH_RULE_34.check_staged THEN
2110: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2111: FND_MSG_PUB.ADD;
2112: RAISE FND_API.G_EXC_ERROR;
2113: END IF;

Line 2114: HZ_MATCH_RULE_34.find_duplicate_contacts(

2110: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2111: FND_MSG_PUB.ADD;
2112: RAISE FND_API.G_EXC_ERROR;
2113: END IF;
2114: HZ_MATCH_RULE_34.find_duplicate_contacts(
2115: p_rule_id,p_org_contact_id,p_party_id,
2116: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2117: -- Code for Match rule DL SMART SEARCH
2118: ELSIF p_rule_id=35 THEN

Line 2483: IF NOT HZ_MATCH_RULE_34.check_staged THEN

2479: p_rule_id,p_contact_point_id,p_party_id,
2480: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2481: -- Code for Match rule SAMPLE:ADVANCED SEARCH RULE
2482: ELSIF p_rule_id=34 THEN
2483: IF NOT HZ_MATCH_RULE_34.check_staged THEN
2484: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2485: FND_MSG_PUB.ADD;
2486: RAISE FND_API.G_EXC_ERROR;
2487: END IF;

Line 2488: HZ_MATCH_RULE_34.find_duplicate_contact_points(

2484: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2485: FND_MSG_PUB.ADD;
2486: RAISE FND_API.G_EXC_ERROR;
2487: END IF;
2488: HZ_MATCH_RULE_34.find_duplicate_contact_points(
2489: p_rule_id,p_contact_point_id,p_party_id,
2490: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2491: -- Code for Match rule DL SMART SEARCH
2492: ELSIF p_rule_id=35 THEN

Line 2969: IF NOT HZ_MATCH_RULE_34.check_staged THEN

2965: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
2966: p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
2967: -- Code for Match rule SAMPLE:ADVANCED SEARCH RULE
2968: ELSIF p_rule_id=34 THEN
2969: IF NOT HZ_MATCH_RULE_34.check_staged THEN
2970: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2971: FND_MSG_PUB.ADD;
2972: RAISE FND_API.G_EXC_ERROR;
2973: END IF;

Line 2974: HZ_MATCH_RULE_34.find_parties_dynamic(

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

Line 3616: IF NOT HZ_MATCH_RULE_34.check_staged THEN

3612: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3613: p_restrict_sql,p_api_name,p_match_type,p_party_id,p_search_merged,x_search_ctx_id,x_num_matches);
3614: -- Code for Match rule SAMPLE:ADVANCED SEARCH RULE
3615: ELSIF p_rule_id=34 THEN
3616: IF NOT HZ_MATCH_RULE_34.check_staged THEN
3617: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3618: FND_MSG_PUB.ADD;
3619: RAISE FND_API.G_EXC_ERROR;
3620: END IF;

Line 3621: HZ_MATCH_RULE_34.call_api_dynamic(

3617: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3618: FND_MSG_PUB.ADD;
3619: RAISE FND_API.G_EXC_ERROR;
3620: END IF;
3621: HZ_MATCH_RULE_34.call_api_dynamic(
3622: p_rule_id,
3623: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
3624: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
3625: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 4382: IF NOT HZ_MATCH_RULE_34.check_staged THEN

4378: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4379: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4380: -- Code for Match rule SAMPLE:ADVANCED SEARCH RULE
4381: ELSIF p_rule_id=34 THEN
4382: IF NOT HZ_MATCH_RULE_34.check_staged THEN
4383: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4384: FND_MSG_PUB.ADD;
4385: RAISE FND_API.G_EXC_ERROR;
4386: END IF;

Line 4387: HZ_MATCH_RULE_34.get_matching_party_sites(

4383: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4384: FND_MSG_PUB.ADD;
4385: RAISE FND_API.G_EXC_ERROR;
4386: END IF;
4387: HZ_MATCH_RULE_34.get_matching_party_sites(
4388: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4389: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4390: -- Code for Match rule DL SMART SEARCH
4391: ELSIF p_rule_id=35 THEN

Line 4781: IF NOT HZ_MATCH_RULE_34.check_staged THEN

4777: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
4778: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4779: -- Code for Match rule SAMPLE:ADVANCED SEARCH RULE
4780: ELSIF p_rule_id=34 THEN
4781: IF NOT HZ_MATCH_RULE_34.check_staged THEN
4782: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4783: FND_MSG_PUB.ADD;
4784: RAISE FND_API.G_EXC_ERROR;
4785: END IF;

Line 4786: HZ_MATCH_RULE_34.get_matching_contacts(

4782: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4783: FND_MSG_PUB.ADD;
4784: RAISE FND_API.G_EXC_ERROR;
4785: END IF;
4786: HZ_MATCH_RULE_34.get_matching_contacts(
4787: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
4788: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4789: -- Code for Match rule DL SMART SEARCH
4790: ELSIF p_rule_id=35 THEN

Line 5178: IF NOT HZ_MATCH_RULE_34.check_staged THEN

5174: p_rule_id, p_party_id, p_contact_point_list,
5175: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5176: -- Code for Match rule SAMPLE:ADVANCED SEARCH RULE
5177: ELSIF p_rule_id=34 THEN
5178: IF NOT HZ_MATCH_RULE_34.check_staged THEN
5179: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5180: FND_MSG_PUB.ADD;
5181: RAISE FND_API.G_EXC_ERROR;
5182: END IF;

Line 5183: HZ_MATCH_RULE_34.get_matching_contact_points(

5179: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5180: FND_MSG_PUB.ADD;
5181: RAISE FND_API.G_EXC_ERROR;
5182: END IF;
5183: HZ_MATCH_RULE_34.get_matching_contact_points(
5184: p_rule_id, p_party_id, p_contact_point_list,
5185: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5186: -- Code for Match rule DL SMART SEARCH
5187: ELSIF p_rule_id=35 THEN

Line 5587: IF NOT HZ_MATCH_RULE_34.check_staged THEN

5583: p_party_id, p_party_search_rec,p_party_site_list,
5584: p_contact_list, p_contact_point_list,x_search_ctx_id);
5585: -- Code for Match rule SAMPLE:ADVANCED SEARCH RULE
5586: ELSIF p_rule_id=34 THEN
5587: IF NOT HZ_MATCH_RULE_34.check_staged THEN
5588: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5589: FND_MSG_PUB.ADD;
5590: RAISE FND_API.G_EXC_ERROR;
5591: END IF;

Line 5592: HZ_MATCH_RULE_34.get_score_details(

5588: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5589: FND_MSG_PUB.ADD;
5590: RAISE FND_API.G_EXC_ERROR;
5591: END IF;
5592: HZ_MATCH_RULE_34.get_score_details(
5593: p_rule_id,
5594: p_party_id, p_party_search_rec,p_party_site_list,
5595: p_contact_list, p_contact_point_list,x_search_ctx_id);
5596: -- Code for Match rule DL SMART SEARCH

Line 5976: IF NOT HZ_MATCH_RULE_34.check_staged THEN

5972: p_party_id, x_party_search_rec,x_party_site_list,
5973: x_contact_list, x_contact_point_list);
5974: -- Code for Match rule SAMPLE:ADVANCED SEARCH RULE
5975: ELSIF p_rule_id=34 THEN
5976: IF NOT HZ_MATCH_RULE_34.check_staged THEN
5977: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5978: FND_MSG_PUB.ADD;
5979: RAISE FND_API.G_EXC_ERROR;
5980: END IF;

Line 5981: HZ_MATCH_RULE_34.get_party_for_search(

5977: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5978: FND_MSG_PUB.ADD;
5979: RAISE FND_API.G_EXC_ERROR;
5980: END IF;
5981: HZ_MATCH_RULE_34.get_party_for_search(
5982: p_party_id, x_party_search_rec,x_party_site_list,
5983: x_contact_list, x_contact_point_list);
5984: -- Code for Match rule DL SMART SEARCH
5985: ELSIF p_rule_id=35 THEN

Line 6348: IF NOT HZ_MATCH_RULE_34.check_staged THEN

6344: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6345: x_contact_list, x_contact_point_list);
6346: -- Code for Match rule SAMPLE:ADVANCED SEARCH RULE
6347: ELSIF p_rule_id=34 THEN
6348: IF NOT HZ_MATCH_RULE_34.check_staged THEN
6349: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6350: FND_MSG_PUB.ADD;
6351: RAISE FND_API.G_EXC_ERROR;
6352: END IF;

Line 6353: HZ_MATCH_RULE_34.get_search_criteria(

6349: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6350: FND_MSG_PUB.ADD;
6351: RAISE FND_API.G_EXC_ERROR;
6352: END IF;
6353: HZ_MATCH_RULE_34.get_search_criteria(
6354: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6355: x_contact_list, x_contact_point_list);
6356: -- Code for Match rule DL SMART SEARCH
6357: ELSIF p_rule_id=35 THEN