DBA Data[Home] [Help]

APPS.HZ_PARTY_SEARCH dependencies on HZ_MATCH_RULE_32

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 561: IF NOT HZ_MATCH_RULE_32.check_staged THEN

557: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
558: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,'N',x_search_ctx_id,x_num_matches);
559: -- Code for Match rule RM SEARCH RULE
560: ELSIF p_rule_id=32 THEN
561: IF NOT HZ_MATCH_RULE_32.check_staged THEN
562: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
563: FND_MSG_PUB.ADD;
564: RAISE FND_API.G_EXC_ERROR;
565: END IF;

Line 566: HZ_MATCH_RULE_32.find_persons(

562: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
563: FND_MSG_PUB.ADD;
564: RAISE FND_API.G_EXC_ERROR;
565: END IF;
566: HZ_MATCH_RULE_32.find_persons(
567: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
568: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,'N',x_search_ctx_id,x_num_matches);
569: -- Code for Match rule SAMPLE:BASIC SEARCH RULE
570: ELSIF p_rule_id=33 THEN

Line 960: IF NOT HZ_MATCH_RULE_32.check_staged THEN

956: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
957: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
958: -- Code for Match rule RM SEARCH RULE
959: ELSIF p_rule_id=32 THEN
960: IF NOT HZ_MATCH_RULE_32.check_staged THEN
961: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
962: FND_MSG_PUB.ADD;
963: RAISE FND_API.G_EXC_ERROR;
964: END IF;

Line 965: HZ_MATCH_RULE_32.find_party_details(

961: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
962: FND_MSG_PUB.ADD;
963: RAISE FND_API.G_EXC_ERROR;
964: END IF;
965: HZ_MATCH_RULE_32.find_party_details(
966: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
967: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
968: -- Code for Match rule SAMPLE:BASIC SEARCH RULE
969: ELSIF p_rule_id=33 THEN

Line 1340: IF NOT HZ_MATCH_RULE_32.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 RM SEARCH RULE
1339: ELSIF p_rule_id=32 THEN
1340: IF NOT HZ_MATCH_RULE_32.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_32.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_32.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:BASIC SEARCH RULE
1349: ELSIF p_rule_id=33 THEN

Line 1715: IF NOT HZ_MATCH_RULE_32.check_staged THEN

1711: p_rule_id,p_party_site_id,p_party_id,
1712: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
1713: -- Code for Match rule RM SEARCH RULE
1714: ELSIF p_rule_id=32 THEN
1715: IF NOT HZ_MATCH_RULE_32.check_staged THEN
1716: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1717: FND_MSG_PUB.ADD;
1718: RAISE FND_API.G_EXC_ERROR;
1719: END IF;

Line 1720: HZ_MATCH_RULE_32.find_duplicate_party_sites(

1716: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1717: FND_MSG_PUB.ADD;
1718: RAISE FND_API.G_EXC_ERROR;
1719: END IF;
1720: HZ_MATCH_RULE_32.find_duplicate_party_sites(
1721: p_rule_id,p_party_site_id,p_party_id,
1722: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
1723: -- Code for Match rule SAMPLE:BASIC SEARCH RULE
1724: ELSIF p_rule_id=33 THEN

Line 2089: IF NOT HZ_MATCH_RULE_32.check_staged THEN

2085: p_rule_id,p_org_contact_id,p_party_id,
2086: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2087: -- Code for Match rule RM SEARCH RULE
2088: ELSIF p_rule_id=32 THEN
2089: IF NOT HZ_MATCH_RULE_32.check_staged THEN
2090: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2091: FND_MSG_PUB.ADD;
2092: RAISE FND_API.G_EXC_ERROR;
2093: END IF;

Line 2094: HZ_MATCH_RULE_32.find_duplicate_contacts(

2090: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2091: FND_MSG_PUB.ADD;
2092: RAISE FND_API.G_EXC_ERROR;
2093: END IF;
2094: HZ_MATCH_RULE_32.find_duplicate_contacts(
2095: p_rule_id,p_org_contact_id,p_party_id,
2096: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2097: -- Code for Match rule SAMPLE:BASIC SEARCH RULE
2098: ELSIF p_rule_id=33 THEN

Line 2463: IF NOT HZ_MATCH_RULE_32.check_staged THEN

2459: p_rule_id,p_contact_point_id,p_party_id,
2460: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2461: -- Code for Match rule RM SEARCH RULE
2462: ELSIF p_rule_id=32 THEN
2463: IF NOT HZ_MATCH_RULE_32.check_staged THEN
2464: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2465: FND_MSG_PUB.ADD;
2466: RAISE FND_API.G_EXC_ERROR;
2467: END IF;

Line 2468: HZ_MATCH_RULE_32.find_duplicate_contact_points(

2464: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2465: FND_MSG_PUB.ADD;
2466: RAISE FND_API.G_EXC_ERROR;
2467: END IF;
2468: HZ_MATCH_RULE_32.find_duplicate_contact_points(
2469: p_rule_id,p_contact_point_id,p_party_id,
2470: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2471: -- Code for Match rule SAMPLE:BASIC SEARCH RULE
2472: ELSIF p_rule_id=33 THEN

Line 2933: IF NOT HZ_MATCH_RULE_32.check_staged THEN

2929: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
2930: p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
2931: -- Code for Match rule RM SEARCH RULE
2932: ELSIF p_rule_id=32 THEN
2933: IF NOT HZ_MATCH_RULE_32.check_staged THEN
2934: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2935: FND_MSG_PUB.ADD;
2936: RAISE FND_API.G_EXC_ERROR;
2937: END IF;

Line 2938: HZ_MATCH_RULE_32.find_parties_dynamic(

2934: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2935: FND_MSG_PUB.ADD;
2936: RAISE FND_API.G_EXC_ERROR;
2937: END IF;
2938: HZ_MATCH_RULE_32.find_parties_dynamic(
2939: p_rule_id,
2940: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
2941: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
2942: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 3580: IF NOT HZ_MATCH_RULE_32.check_staged THEN

3576: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3577: p_restrict_sql,p_api_name,p_match_type,p_party_id,p_search_merged,x_search_ctx_id,x_num_matches);
3578: -- Code for Match rule RM SEARCH RULE
3579: ELSIF p_rule_id=32 THEN
3580: IF NOT HZ_MATCH_RULE_32.check_staged THEN
3581: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3582: FND_MSG_PUB.ADD;
3583: RAISE FND_API.G_EXC_ERROR;
3584: END IF;

Line 3585: HZ_MATCH_RULE_32.call_api_dynamic(

3581: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3582: FND_MSG_PUB.ADD;
3583: RAISE FND_API.G_EXC_ERROR;
3584: END IF;
3585: HZ_MATCH_RULE_32.call_api_dynamic(
3586: p_rule_id,
3587: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
3588: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
3589: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 4362: IF NOT HZ_MATCH_RULE_32.check_staged THEN

4358: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4359: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4360: -- Code for Match rule RM SEARCH RULE
4361: ELSIF p_rule_id=32 THEN
4362: IF NOT HZ_MATCH_RULE_32.check_staged THEN
4363: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4364: FND_MSG_PUB.ADD;
4365: RAISE FND_API.G_EXC_ERROR;
4366: END IF;

Line 4367: HZ_MATCH_RULE_32.get_matching_party_sites(

4363: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4364: FND_MSG_PUB.ADD;
4365: RAISE FND_API.G_EXC_ERROR;
4366: END IF;
4367: HZ_MATCH_RULE_32.get_matching_party_sites(
4368: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4369: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4370: -- Code for Match rule SAMPLE:BASIC SEARCH RULE
4371: ELSIF p_rule_id=33 THEN

Line 4761: IF NOT HZ_MATCH_RULE_32.check_staged THEN

4757: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
4758: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4759: -- Code for Match rule RM SEARCH RULE
4760: ELSIF p_rule_id=32 THEN
4761: IF NOT HZ_MATCH_RULE_32.check_staged THEN
4762: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4763: FND_MSG_PUB.ADD;
4764: RAISE FND_API.G_EXC_ERROR;
4765: END IF;

Line 4766: HZ_MATCH_RULE_32.get_matching_contacts(

4762: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4763: FND_MSG_PUB.ADD;
4764: RAISE FND_API.G_EXC_ERROR;
4765: END IF;
4766: HZ_MATCH_RULE_32.get_matching_contacts(
4767: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
4768: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4769: -- Code for Match rule SAMPLE:BASIC SEARCH RULE
4770: ELSIF p_rule_id=33 THEN

Line 5158: IF NOT HZ_MATCH_RULE_32.check_staged THEN

5154: p_rule_id, p_party_id, p_contact_point_list,
5155: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5156: -- Code for Match rule RM SEARCH RULE
5157: ELSIF p_rule_id=32 THEN
5158: IF NOT HZ_MATCH_RULE_32.check_staged THEN
5159: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5160: FND_MSG_PUB.ADD;
5161: RAISE FND_API.G_EXC_ERROR;
5162: END IF;

Line 5163: HZ_MATCH_RULE_32.get_matching_contact_points(

5159: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5160: FND_MSG_PUB.ADD;
5161: RAISE FND_API.G_EXC_ERROR;
5162: END IF;
5163: HZ_MATCH_RULE_32.get_matching_contact_points(
5164: p_rule_id, p_party_id, p_contact_point_list,
5165: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5166: -- Code for Match rule SAMPLE:BASIC SEARCH RULE
5167: ELSIF p_rule_id=33 THEN

Line 5565: IF NOT HZ_MATCH_RULE_32.check_staged THEN

5561: p_party_id, p_party_search_rec,p_party_site_list,
5562: p_contact_list, p_contact_point_list,x_search_ctx_id);
5563: -- Code for Match rule RM SEARCH RULE
5564: ELSIF p_rule_id=32 THEN
5565: IF NOT HZ_MATCH_RULE_32.check_staged THEN
5566: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5567: FND_MSG_PUB.ADD;
5568: RAISE FND_API.G_EXC_ERROR;
5569: END IF;

Line 5570: HZ_MATCH_RULE_32.get_score_details(

5566: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5567: FND_MSG_PUB.ADD;
5568: RAISE FND_API.G_EXC_ERROR;
5569: END IF;
5570: HZ_MATCH_RULE_32.get_score_details(
5571: p_rule_id,
5572: p_party_id, p_party_search_rec,p_party_site_list,
5573: p_contact_list, p_contact_point_list,x_search_ctx_id);
5574: -- Code for Match rule SAMPLE:BASIC SEARCH RULE

Line 5956: IF NOT HZ_MATCH_RULE_32.check_staged THEN

5952: p_party_id, x_party_search_rec,x_party_site_list,
5953: x_contact_list, x_contact_point_list);
5954: -- Code for Match rule RM SEARCH RULE
5955: ELSIF p_rule_id=32 THEN
5956: IF NOT HZ_MATCH_RULE_32.check_staged THEN
5957: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5958: FND_MSG_PUB.ADD;
5959: RAISE FND_API.G_EXC_ERROR;
5960: END IF;

Line 5961: HZ_MATCH_RULE_32.get_party_for_search(

5957: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5958: FND_MSG_PUB.ADD;
5959: RAISE FND_API.G_EXC_ERROR;
5960: END IF;
5961: HZ_MATCH_RULE_32.get_party_for_search(
5962: p_party_id, x_party_search_rec,x_party_site_list,
5963: x_contact_list, x_contact_point_list);
5964: -- Code for Match rule SAMPLE:BASIC SEARCH RULE
5965: ELSIF p_rule_id=33 THEN

Line 6328: IF NOT HZ_MATCH_RULE_32.check_staged THEN

6324: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6325: x_contact_list, x_contact_point_list);
6326: -- Code for Match rule RM SEARCH RULE
6327: ELSIF p_rule_id=32 THEN
6328: IF NOT HZ_MATCH_RULE_32.check_staged THEN
6329: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6330: FND_MSG_PUB.ADD;
6331: RAISE FND_API.G_EXC_ERROR;
6332: END IF;

Line 6333: HZ_MATCH_RULE_32.get_search_criteria(

6329: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6330: FND_MSG_PUB.ADD;
6331: RAISE FND_API.G_EXC_ERROR;
6332: END IF;
6333: HZ_MATCH_RULE_32.get_search_criteria(
6334: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6335: x_contact_list, x_contact_point_list);
6336: -- Code for Match rule SAMPLE:BASIC SEARCH RULE
6337: ELSIF p_rule_id=33 THEN