DBA Data[Home] [Help]

APPS.HZ_PARTY_SEARCH dependencies on HZ_MATCH_RULE_60

Line 350: IF NOT HZ_MATCH_RULE_60.check_staged THEN

346: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
347: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,NULL,NULL,NULL,'N',x_search_ctx_id,x_num_matches);
348: -- Code for Match rule HZ_PERSON_ADVANCED_SEARCH_MATCH_RULE
349: ELSIF p_rule_id=60 THEN
350: IF NOT HZ_MATCH_RULE_60.check_staged THEN
351: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
352: FND_MSG_PUB.ADD;
353: RAISE FND_API.G_EXC_ERROR;
354: END IF;

Line 355: HZ_MATCH_RULE_60.find_parties(

351: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
352: FND_MSG_PUB.ADD;
353: RAISE FND_API.G_EXC_ERROR;
354: END IF;
355: HZ_MATCH_RULE_60.find_parties(
356: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
357: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,NULL,NULL,NULL,'N',x_search_ctx_id,x_num_matches);
358: -- Code for Match rule HZ_ORG_SIMPLE_SEARCH_RULE
359: ELSIF p_rule_id=61 THEN

Line 731: IF NOT HZ_MATCH_RULE_60.check_staged THEN

727: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
728: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,'N',x_search_ctx_id,x_num_matches);
729: -- Code for Match rule HZ_PERSON_ADVANCED_SEARCH_MATCH_RULE
730: ELSIF p_rule_id=60 THEN
731: IF NOT HZ_MATCH_RULE_60.check_staged THEN
732: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
733: FND_MSG_PUB.ADD;
734: RAISE FND_API.G_EXC_ERROR;
735: END IF;

Line 736: HZ_MATCH_RULE_60.find_persons(

732: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
733: FND_MSG_PUB.ADD;
734: RAISE FND_API.G_EXC_ERROR;
735: END IF;
736: HZ_MATCH_RULE_60.find_persons(
737: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
738: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,'N',x_search_ctx_id,x_num_matches);
739: -- Code for Match rule HZ_ORG_SIMPLE_SEARCH_RULE
740: ELSIF p_rule_id=61 THEN

Line 1130: IF NOT HZ_MATCH_RULE_60.check_staged THEN

1126: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
1127: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
1128: -- Code for Match rule HZ_PERSON_ADVANCED_SEARCH_MATCH_RULE
1129: ELSIF p_rule_id=60 THEN
1130: IF NOT HZ_MATCH_RULE_60.check_staged THEN
1131: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1132: FND_MSG_PUB.ADD;
1133: RAISE FND_API.G_EXC_ERROR;
1134: END IF;

Line 1135: HZ_MATCH_RULE_60.find_party_details(

1131: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1132: FND_MSG_PUB.ADD;
1133: RAISE FND_API.G_EXC_ERROR;
1134: END IF;
1135: HZ_MATCH_RULE_60.find_party_details(
1136: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
1137: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
1138: -- Code for Match rule HZ_ORG_SIMPLE_SEARCH_RULE
1139: ELSIF p_rule_id=61 THEN

Line 1510: IF NOT HZ_MATCH_RULE_60.check_staged THEN

1506: p_rule_id,p_party_id,
1507: p_restrict_sql,p_match_type,p_dup_batch_id,p_search_merged,x_dup_set_id, x_search_ctx_id,x_num_matches);
1508: -- Code for Match rule HZ_PERSON_ADVANCED_SEARCH_MATCH_RULE
1509: ELSIF p_rule_id=60 THEN
1510: IF NOT HZ_MATCH_RULE_60.check_staged THEN
1511: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1512: FND_MSG_PUB.ADD;
1513: RAISE FND_API.G_EXC_ERROR;
1514: END IF;

Line 1515: HZ_MATCH_RULE_60.find_duplicate_parties(

1511: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1512: FND_MSG_PUB.ADD;
1513: RAISE FND_API.G_EXC_ERROR;
1514: END IF;
1515: HZ_MATCH_RULE_60.find_duplicate_parties(
1516: p_rule_id,p_party_id,
1517: p_restrict_sql,p_match_type,p_dup_batch_id,p_search_merged,x_dup_set_id, x_search_ctx_id,x_num_matches);
1518: -- Code for Match rule HZ_ORG_SIMPLE_SEARCH_RULE
1519: ELSIF p_rule_id=61 THEN

Line 1885: IF NOT HZ_MATCH_RULE_60.check_staged THEN

1881: p_rule_id,p_party_site_id,p_party_id,
1882: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
1883: -- Code for Match rule HZ_PERSON_ADVANCED_SEARCH_MATCH_RULE
1884: ELSIF p_rule_id=60 THEN
1885: IF NOT HZ_MATCH_RULE_60.check_staged THEN
1886: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1887: FND_MSG_PUB.ADD;
1888: RAISE FND_API.G_EXC_ERROR;
1889: END IF;

Line 1890: HZ_MATCH_RULE_60.find_duplicate_party_sites(

1886: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1887: FND_MSG_PUB.ADD;
1888: RAISE FND_API.G_EXC_ERROR;
1889: END IF;
1890: HZ_MATCH_RULE_60.find_duplicate_party_sites(
1891: p_rule_id,p_party_site_id,p_party_id,
1892: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
1893: -- Code for Match rule HZ_ORG_SIMPLE_SEARCH_RULE
1894: ELSIF p_rule_id=61 THEN

Line 2259: IF NOT HZ_MATCH_RULE_60.check_staged THEN

2255: p_rule_id,p_org_contact_id,p_party_id,
2256: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2257: -- Code for Match rule HZ_PERSON_ADVANCED_SEARCH_MATCH_RULE
2258: ELSIF p_rule_id=60 THEN
2259: IF NOT HZ_MATCH_RULE_60.check_staged THEN
2260: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2261: FND_MSG_PUB.ADD;
2262: RAISE FND_API.G_EXC_ERROR;
2263: END IF;

Line 2264: HZ_MATCH_RULE_60.find_duplicate_contacts(

2260: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2261: FND_MSG_PUB.ADD;
2262: RAISE FND_API.G_EXC_ERROR;
2263: END IF;
2264: HZ_MATCH_RULE_60.find_duplicate_contacts(
2265: p_rule_id,p_org_contact_id,p_party_id,
2266: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2267: -- Code for Match rule HZ_ORG_SIMPLE_SEARCH_RULE
2268: ELSIF p_rule_id=61 THEN

Line 2633: IF NOT HZ_MATCH_RULE_60.check_staged THEN

2629: p_rule_id,p_contact_point_id,p_party_id,
2630: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2631: -- Code for Match rule HZ_PERSON_ADVANCED_SEARCH_MATCH_RULE
2632: ELSIF p_rule_id=60 THEN
2633: IF NOT HZ_MATCH_RULE_60.check_staged THEN
2634: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2635: FND_MSG_PUB.ADD;
2636: RAISE FND_API.G_EXC_ERROR;
2637: END IF;

Line 2638: HZ_MATCH_RULE_60.find_duplicate_contact_points(

2634: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2635: FND_MSG_PUB.ADD;
2636: RAISE FND_API.G_EXC_ERROR;
2637: END IF;
2638: HZ_MATCH_RULE_60.find_duplicate_contact_points(
2639: p_rule_id,p_contact_point_id,p_party_id,
2640: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2641: -- Code for Match rule HZ_ORG_SIMPLE_SEARCH_RULE
2642: ELSIF p_rule_id=61 THEN

Line 3239: IF NOT HZ_MATCH_RULE_60.check_staged THEN

3235: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3236: p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
3237: -- Code for Match rule HZ_PERSON_ADVANCED_SEARCH_MATCH_RULE
3238: ELSIF p_rule_id=60 THEN
3239: IF NOT HZ_MATCH_RULE_60.check_staged THEN
3240: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3241: FND_MSG_PUB.ADD;
3242: RAISE FND_API.G_EXC_ERROR;
3243: END IF;

Line 3244: HZ_MATCH_RULE_60.find_parties_dynamic(

3240: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3241: FND_MSG_PUB.ADD;
3242: RAISE FND_API.G_EXC_ERROR;
3243: END IF;
3244: HZ_MATCH_RULE_60.find_parties_dynamic(
3245: p_rule_id,
3246: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
3247: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
3248: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 3886: IF NOT HZ_MATCH_RULE_60.check_staged THEN

3882: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3883: p_restrict_sql,p_api_name,p_match_type,p_party_id,p_search_merged,x_search_ctx_id,x_num_matches);
3884: -- Code for Match rule HZ_PERSON_ADVANCED_SEARCH_MATCH_RULE
3885: ELSIF p_rule_id=60 THEN
3886: IF NOT HZ_MATCH_RULE_60.check_staged THEN
3887: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3888: FND_MSG_PUB.ADD;
3889: RAISE FND_API.G_EXC_ERROR;
3890: END IF;

Line 3891: HZ_MATCH_RULE_60.call_api_dynamic(

3887: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3888: FND_MSG_PUB.ADD;
3889: RAISE FND_API.G_EXC_ERROR;
3890: END IF;
3891: HZ_MATCH_RULE_60.call_api_dynamic(
3892: p_rule_id,
3893: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
3894: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
3895: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 4532: IF NOT HZ_MATCH_RULE_60.check_staged THEN

4528: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4529: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4530: -- Code for Match rule HZ_PERSON_ADVANCED_SEARCH_MATCH_RULE
4531: ELSIF p_rule_id=60 THEN
4532: IF NOT HZ_MATCH_RULE_60.check_staged THEN
4533: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4534: FND_MSG_PUB.ADD;
4535: RAISE FND_API.G_EXC_ERROR;
4536: END IF;

Line 4537: HZ_MATCH_RULE_60.get_matching_party_sites(

4533: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4534: FND_MSG_PUB.ADD;
4535: RAISE FND_API.G_EXC_ERROR;
4536: END IF;
4537: HZ_MATCH_RULE_60.get_matching_party_sites(
4538: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4539: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4540: -- Code for Match rule HZ_ORG_SIMPLE_SEARCH_RULE
4541: ELSIF p_rule_id=61 THEN

Line 4931: IF NOT HZ_MATCH_RULE_60.check_staged THEN

4927: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
4928: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4929: -- Code for Match rule HZ_PERSON_ADVANCED_SEARCH_MATCH_RULE
4930: ELSIF p_rule_id=60 THEN
4931: IF NOT HZ_MATCH_RULE_60.check_staged THEN
4932: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4933: FND_MSG_PUB.ADD;
4934: RAISE FND_API.G_EXC_ERROR;
4935: END IF;

Line 4936: HZ_MATCH_RULE_60.get_matching_contacts(

4932: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4933: FND_MSG_PUB.ADD;
4934: RAISE FND_API.G_EXC_ERROR;
4935: END IF;
4936: HZ_MATCH_RULE_60.get_matching_contacts(
4937: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
4938: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4939: -- Code for Match rule HZ_ORG_SIMPLE_SEARCH_RULE
4940: ELSIF p_rule_id=61 THEN

Line 5328: IF NOT HZ_MATCH_RULE_60.check_staged THEN

5324: p_rule_id, p_party_id, p_contact_point_list,
5325: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5326: -- Code for Match rule HZ_PERSON_ADVANCED_SEARCH_MATCH_RULE
5327: ELSIF p_rule_id=60 THEN
5328: IF NOT HZ_MATCH_RULE_60.check_staged THEN
5329: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5330: FND_MSG_PUB.ADD;
5331: RAISE FND_API.G_EXC_ERROR;
5332: END IF;

Line 5333: HZ_MATCH_RULE_60.get_matching_contact_points(

5329: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5330: FND_MSG_PUB.ADD;
5331: RAISE FND_API.G_EXC_ERROR;
5332: END IF;
5333: HZ_MATCH_RULE_60.get_matching_contact_points(
5334: p_rule_id, p_party_id, p_contact_point_list,
5335: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5336: -- Code for Match rule HZ_ORG_SIMPLE_SEARCH_RULE
5337: ELSIF p_rule_id=61 THEN

Line 5752: IF NOT HZ_MATCH_RULE_60.check_staged THEN

5748: p_party_id, p_party_search_rec,p_party_site_list,
5749: p_contact_list, p_contact_point_list,x_search_ctx_id);
5750: -- Code for Match rule HZ_PERSON_ADVANCED_SEARCH_MATCH_RULE
5751: ELSIF p_rule_id=60 THEN
5752: IF NOT HZ_MATCH_RULE_60.check_staged THEN
5753: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5754: FND_MSG_PUB.ADD;
5755: RAISE FND_API.G_EXC_ERROR;
5756: END IF;

Line 5757: HZ_MATCH_RULE_60.get_score_details(

5753: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5754: FND_MSG_PUB.ADD;
5755: RAISE FND_API.G_EXC_ERROR;
5756: END IF;
5757: HZ_MATCH_RULE_60.get_score_details(
5758: p_rule_id,
5759: p_party_id, p_party_search_rec,p_party_site_list,
5760: p_contact_list, p_contact_point_list,x_search_ctx_id);
5761: -- Code for Match rule HZ_ORG_SIMPLE_SEARCH_RULE

Line 6126: IF NOT HZ_MATCH_RULE_60.check_staged THEN

6122: p_party_id, x_party_search_rec,x_party_site_list,
6123: x_contact_list, x_contact_point_list);
6124: -- Code for Match rule HZ_PERSON_ADVANCED_SEARCH_MATCH_RULE
6125: ELSIF p_rule_id=60 THEN
6126: IF NOT HZ_MATCH_RULE_60.check_staged THEN
6127: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6128: FND_MSG_PUB.ADD;
6129: RAISE FND_API.G_EXC_ERROR;
6130: END IF;

Line 6131: HZ_MATCH_RULE_60.get_party_for_search(

6127: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6128: FND_MSG_PUB.ADD;
6129: RAISE FND_API.G_EXC_ERROR;
6130: END IF;
6131: HZ_MATCH_RULE_60.get_party_for_search(
6132: p_party_id, x_party_search_rec,x_party_site_list,
6133: x_contact_list, x_contact_point_list);
6134: -- Code for Match rule HZ_ORG_SIMPLE_SEARCH_RULE
6135: ELSIF p_rule_id=61 THEN

Line 6498: IF NOT HZ_MATCH_RULE_60.check_staged THEN

6494: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6495: x_contact_list, x_contact_point_list);
6496: -- Code for Match rule HZ_PERSON_ADVANCED_SEARCH_MATCH_RULE
6497: ELSIF p_rule_id=60 THEN
6498: IF NOT HZ_MATCH_RULE_60.check_staged THEN
6499: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6500: FND_MSG_PUB.ADD;
6501: RAISE FND_API.G_EXC_ERROR;
6502: END IF;

Line 6503: HZ_MATCH_RULE_60.get_search_criteria(

6499: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6500: FND_MSG_PUB.ADD;
6501: RAISE FND_API.G_EXC_ERROR;
6502: END IF;
6503: HZ_MATCH_RULE_60.get_search_criteria(
6504: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6505: x_contact_list, x_contact_point_list);
6506: -- Code for Match rule HZ_ORG_SIMPLE_SEARCH_RULE
6507: ELSIF p_rule_id=61 THEN