DBA Data[Home] [Help]

APPS.HZ_PARTY_SEARCH dependencies on HZ_MATCH_RULE_62

Line 370: IF NOT HZ_MATCH_RULE_62.check_staged THEN

366: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
367: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,NULL,NULL,NULL,'N',x_search_ctx_id,x_num_matches);
368: -- Code for Match rule HZ_ORG_ADV_SEARCH_RULE
369: ELSIF p_rule_id=62 THEN
370: IF NOT HZ_MATCH_RULE_62.check_staged THEN
371: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
372: FND_MSG_PUB.ADD;
373: RAISE FND_API.G_EXC_ERROR;
374: END IF;

Line 375: HZ_MATCH_RULE_62.find_parties(

371: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
372: FND_MSG_PUB.ADD;
373: RAISE FND_API.G_EXC_ERROR;
374: END IF;
375: HZ_MATCH_RULE_62.find_parties(
376: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
377: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,NULL,NULL,NULL,'N',x_search_ctx_id,x_num_matches);
378: -- Code for Match rule HZ_CONTACT_SIMPLE_SEARCH_RULE
379: ELSIF p_rule_id=98 THEN

Line 771: IF NOT HZ_MATCH_RULE_62.check_staged THEN

767: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
768: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,'N',x_search_ctx_id,x_num_matches);
769: -- Code for Match rule HZ_ORG_ADV_SEARCH_RULE
770: ELSIF p_rule_id=62 THEN
771: IF NOT HZ_MATCH_RULE_62.check_staged THEN
772: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
773: FND_MSG_PUB.ADD;
774: RAISE FND_API.G_EXC_ERROR;
775: END IF;

Line 776: HZ_MATCH_RULE_62.find_persons(

772: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
773: FND_MSG_PUB.ADD;
774: RAISE FND_API.G_EXC_ERROR;
775: END IF;
776: HZ_MATCH_RULE_62.find_persons(
777: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
778: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,'N',x_search_ctx_id,x_num_matches);
779: -- Code for Match rule HZ_CONTACT_SIMPLE_SEARCH_RULE
780: ELSIF p_rule_id=98 THEN

Line 1190: IF NOT HZ_MATCH_RULE_62.check_staged THEN

1186: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
1187: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
1188: -- Code for Match rule HZ_ORG_ADV_SEARCH_RULE
1189: ELSIF p_rule_id=62 THEN
1190: IF NOT HZ_MATCH_RULE_62.check_staged THEN
1191: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1192: FND_MSG_PUB.ADD;
1193: RAISE FND_API.G_EXC_ERROR;
1194: END IF;

Line 1195: HZ_MATCH_RULE_62.find_party_details(

1191: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1192: FND_MSG_PUB.ADD;
1193: RAISE FND_API.G_EXC_ERROR;
1194: END IF;
1195: HZ_MATCH_RULE_62.find_party_details(
1196: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
1197: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
1198: -- Code for Match rule HZ_CONTACT_SIMPLE_SEARCH_RULE
1199: ELSIF p_rule_id=98 THEN

Line 1590: IF NOT HZ_MATCH_RULE_62.check_staged THEN

1586: p_rule_id,p_party_id,
1587: p_restrict_sql,p_match_type,p_dup_batch_id,p_search_merged,x_dup_set_id, x_search_ctx_id,x_num_matches);
1588: -- Code for Match rule HZ_ORG_ADV_SEARCH_RULE
1589: ELSIF p_rule_id=62 THEN
1590: IF NOT HZ_MATCH_RULE_62.check_staged THEN
1591: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1592: FND_MSG_PUB.ADD;
1593: RAISE FND_API.G_EXC_ERROR;
1594: END IF;

Line 1595: HZ_MATCH_RULE_62.find_duplicate_parties(

1591: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1592: FND_MSG_PUB.ADD;
1593: RAISE FND_API.G_EXC_ERROR;
1594: END IF;
1595: HZ_MATCH_RULE_62.find_duplicate_parties(
1596: p_rule_id,p_party_id,
1597: p_restrict_sql,p_match_type,p_dup_batch_id,p_search_merged,x_dup_set_id, x_search_ctx_id,x_num_matches);
1598: -- Code for Match rule HZ_CONTACT_SIMPLE_SEARCH_RULE
1599: ELSIF p_rule_id=98 THEN

Line 1985: IF NOT HZ_MATCH_RULE_62.check_staged THEN

1981: p_rule_id,p_party_site_id,p_party_id,
1982: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
1983: -- Code for Match rule HZ_ORG_ADV_SEARCH_RULE
1984: ELSIF p_rule_id=62 THEN
1985: IF NOT HZ_MATCH_RULE_62.check_staged THEN
1986: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1987: FND_MSG_PUB.ADD;
1988: RAISE FND_API.G_EXC_ERROR;
1989: END IF;

Line 1990: HZ_MATCH_RULE_62.find_duplicate_party_sites(

1986: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1987: FND_MSG_PUB.ADD;
1988: RAISE FND_API.G_EXC_ERROR;
1989: END IF;
1990: HZ_MATCH_RULE_62.find_duplicate_party_sites(
1991: p_rule_id,p_party_site_id,p_party_id,
1992: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
1993: -- Code for Match rule HZ_CONTACT_SIMPLE_SEARCH_RULE
1994: ELSIF p_rule_id=98 THEN

Line 2379: IF NOT HZ_MATCH_RULE_62.check_staged THEN

2375: p_rule_id,p_org_contact_id,p_party_id,
2376: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2377: -- Code for Match rule HZ_ORG_ADV_SEARCH_RULE
2378: ELSIF p_rule_id=62 THEN
2379: IF NOT HZ_MATCH_RULE_62.check_staged THEN
2380: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2381: FND_MSG_PUB.ADD;
2382: RAISE FND_API.G_EXC_ERROR;
2383: END IF;

Line 2384: HZ_MATCH_RULE_62.find_duplicate_contacts(

2380: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2381: FND_MSG_PUB.ADD;
2382: RAISE FND_API.G_EXC_ERROR;
2383: END IF;
2384: HZ_MATCH_RULE_62.find_duplicate_contacts(
2385: p_rule_id,p_org_contact_id,p_party_id,
2386: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2387: -- Code for Match rule HZ_CONTACT_SIMPLE_SEARCH_RULE
2388: ELSIF p_rule_id=98 THEN

Line 2773: IF NOT HZ_MATCH_RULE_62.check_staged THEN

2769: p_rule_id,p_contact_point_id,p_party_id,
2770: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2771: -- Code for Match rule HZ_ORG_ADV_SEARCH_RULE
2772: ELSIF p_rule_id=62 THEN
2773: IF NOT HZ_MATCH_RULE_62.check_staged THEN
2774: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2775: FND_MSG_PUB.ADD;
2776: RAISE FND_API.G_EXC_ERROR;
2777: END IF;

Line 2778: HZ_MATCH_RULE_62.find_duplicate_contact_points(

2774: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2775: FND_MSG_PUB.ADD;
2776: RAISE FND_API.G_EXC_ERROR;
2777: END IF;
2778: HZ_MATCH_RULE_62.find_duplicate_contact_points(
2779: p_rule_id,p_contact_point_id,p_party_id,
2780: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2781: -- Code for Match rule HZ_CONTACT_SIMPLE_SEARCH_RULE
2782: ELSIF p_rule_id=98 THEN

Line 3415: IF NOT HZ_MATCH_RULE_62.check_staged THEN

3411: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3412: p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
3413: -- Code for Match rule HZ_ORG_ADV_SEARCH_RULE
3414: ELSIF p_rule_id=62 THEN
3415: IF NOT HZ_MATCH_RULE_62.check_staged THEN
3416: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3417: FND_MSG_PUB.ADD;
3418: RAISE FND_API.G_EXC_ERROR;
3419: END IF;

Line 3420: HZ_MATCH_RULE_62.find_parties_dynamic(

3416: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3417: FND_MSG_PUB.ADD;
3418: RAISE FND_API.G_EXC_ERROR;
3419: END IF;
3420: HZ_MATCH_RULE_62.find_parties_dynamic(
3421: p_rule_id,
3422: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
3423: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
3424: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 4098: IF NOT HZ_MATCH_RULE_62.check_staged THEN

4094: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
4095: p_restrict_sql,p_api_name,p_match_type,p_party_id,p_search_merged,x_search_ctx_id,x_num_matches);
4096: -- Code for Match rule HZ_ORG_ADV_SEARCH_RULE
4097: ELSIF p_rule_id=62 THEN
4098: IF NOT HZ_MATCH_RULE_62.check_staged THEN
4099: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4100: FND_MSG_PUB.ADD;
4101: RAISE FND_API.G_EXC_ERROR;
4102: END IF;

Line 4103: HZ_MATCH_RULE_62.call_api_dynamic(

4099: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4100: FND_MSG_PUB.ADD;
4101: RAISE FND_API.G_EXC_ERROR;
4102: END IF;
4103: HZ_MATCH_RULE_62.call_api_dynamic(
4104: p_rule_id,
4105: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
4106: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
4107: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 4764: IF NOT HZ_MATCH_RULE_62.check_staged THEN

4760: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4761: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4762: -- Code for Match rule HZ_ORG_ADV_SEARCH_RULE
4763: ELSIF p_rule_id=62 THEN
4764: IF NOT HZ_MATCH_RULE_62.check_staged THEN
4765: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4766: FND_MSG_PUB.ADD;
4767: RAISE FND_API.G_EXC_ERROR;
4768: END IF;

Line 4769: HZ_MATCH_RULE_62.get_matching_party_sites(

4765: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4766: FND_MSG_PUB.ADD;
4767: RAISE FND_API.G_EXC_ERROR;
4768: END IF;
4769: HZ_MATCH_RULE_62.get_matching_party_sites(
4770: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4771: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4772: -- Code for Match rule HZ_CONTACT_SIMPLE_SEARCH_RULE
4773: ELSIF p_rule_id=98 THEN

Line 5183: IF NOT HZ_MATCH_RULE_62.check_staged THEN

5179: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
5180: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5181: -- Code for Match rule HZ_ORG_ADV_SEARCH_RULE
5182: ELSIF p_rule_id=62 THEN
5183: IF NOT HZ_MATCH_RULE_62.check_staged THEN
5184: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5185: FND_MSG_PUB.ADD;
5186: RAISE FND_API.G_EXC_ERROR;
5187: END IF;

Line 5188: HZ_MATCH_RULE_62.get_matching_contacts(

5184: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5185: FND_MSG_PUB.ADD;
5186: RAISE FND_API.G_EXC_ERROR;
5187: END IF;
5188: HZ_MATCH_RULE_62.get_matching_contacts(
5189: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
5190: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5191: -- Code for Match rule HZ_CONTACT_SIMPLE_SEARCH_RULE
5192: ELSIF p_rule_id=98 THEN

Line 5600: IF NOT HZ_MATCH_RULE_62.check_staged THEN

5596: p_rule_id, p_party_id, p_contact_point_list,
5597: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5598: -- Code for Match rule HZ_ORG_ADV_SEARCH_RULE
5599: ELSIF p_rule_id=62 THEN
5600: IF NOT HZ_MATCH_RULE_62.check_staged THEN
5601: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5602: FND_MSG_PUB.ADD;
5603: RAISE FND_API.G_EXC_ERROR;
5604: END IF;

Line 5605: HZ_MATCH_RULE_62.get_matching_contact_points(

5601: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5602: FND_MSG_PUB.ADD;
5603: RAISE FND_API.G_EXC_ERROR;
5604: END IF;
5605: HZ_MATCH_RULE_62.get_matching_contact_points(
5606: p_rule_id, p_party_id, p_contact_point_list,
5607: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5608: -- Code for Match rule HZ_CONTACT_SIMPLE_SEARCH_RULE
5609: ELSIF p_rule_id=98 THEN

Line 6046: IF NOT HZ_MATCH_RULE_62.check_staged THEN

6042: p_party_id, p_party_search_rec,p_party_site_list,
6043: p_contact_list, p_contact_point_list,x_search_ctx_id);
6044: -- Code for Match rule HZ_ORG_ADV_SEARCH_RULE
6045: ELSIF p_rule_id=62 THEN
6046: IF NOT HZ_MATCH_RULE_62.check_staged THEN
6047: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6048: FND_MSG_PUB.ADD;
6049: RAISE FND_API.G_EXC_ERROR;
6050: END IF;

Line 6051: HZ_MATCH_RULE_62.get_score_details(

6047: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6048: FND_MSG_PUB.ADD;
6049: RAISE FND_API.G_EXC_ERROR;
6050: END IF;
6051: HZ_MATCH_RULE_62.get_score_details(
6052: p_rule_id,
6053: p_party_id, p_party_search_rec,p_party_site_list,
6054: p_contact_list, p_contact_point_list,x_search_ctx_id);
6055: -- Code for Match rule HZ_CONTACT_SIMPLE_SEARCH_RULE

Line 6440: IF NOT HZ_MATCH_RULE_62.check_staged THEN

6436: p_party_id, x_party_search_rec,x_party_site_list,
6437: x_contact_list, x_contact_point_list);
6438: -- Code for Match rule HZ_ORG_ADV_SEARCH_RULE
6439: ELSIF p_rule_id=62 THEN
6440: IF NOT HZ_MATCH_RULE_62.check_staged THEN
6441: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6442: FND_MSG_PUB.ADD;
6443: RAISE FND_API.G_EXC_ERROR;
6444: END IF;

Line 6445: HZ_MATCH_RULE_62.get_party_for_search(

6441: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6442: FND_MSG_PUB.ADD;
6443: RAISE FND_API.G_EXC_ERROR;
6444: END IF;
6445: HZ_MATCH_RULE_62.get_party_for_search(
6446: p_party_id, x_party_search_rec,x_party_site_list,
6447: x_contact_list, x_contact_point_list);
6448: -- Code for Match rule HZ_CONTACT_SIMPLE_SEARCH_RULE
6449: ELSIF p_rule_id=98 THEN

Line 6832: IF NOT HZ_MATCH_RULE_62.check_staged THEN

6828: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6829: x_contact_list, x_contact_point_list);
6830: -- Code for Match rule HZ_ORG_ADV_SEARCH_RULE
6831: ELSIF p_rule_id=62 THEN
6832: IF NOT HZ_MATCH_RULE_62.check_staged THEN
6833: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6834: FND_MSG_PUB.ADD;
6835: RAISE FND_API.G_EXC_ERROR;
6836: END IF;

Line 6837: HZ_MATCH_RULE_62.get_search_criteria(

6833: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6834: FND_MSG_PUB.ADD;
6835: RAISE FND_API.G_EXC_ERROR;
6836: END IF;
6837: HZ_MATCH_RULE_62.get_search_criteria(
6838: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6839: x_contact_list, x_contact_point_list);
6840: -- Code for Match rule HZ_CONTACT_SIMPLE_SEARCH_RULE
6841: ELSIF p_rule_id=98 THEN