DBA Data[Home] [Help]

APPS.HZ_PARTY_SEARCH dependencies on HZ_MATCH_RULE_52

Line 320: IF NOT HZ_MATCH_RULE_52.check_staged THEN

316: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
317: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,NULL,NULL,NULL,'N',x_search_ctx_id,x_num_matches);
318: -- Code for Match rule BULK MATCH: IDENTICAL PARTIES
319: ELSIF p_rule_id=52 THEN
320: IF NOT HZ_MATCH_RULE_52.check_staged THEN
321: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
322: FND_MSG_PUB.ADD;
323: RAISE FND_API.G_EXC_ERROR;
324: END IF;

Line 325: HZ_MATCH_RULE_52.find_parties(

321: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
322: FND_MSG_PUB.ADD;
323: RAISE FND_API.G_EXC_ERROR;
324: END IF;
325: HZ_MATCH_RULE_52.find_parties(
326: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
327: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,NULL,NULL,NULL,'N',x_search_ctx_id,x_num_matches);
328: -- Code for Match rule CREDIT MANAGEMENT SEARCH
329: ELSIF p_rule_id=53 THEN

Line 721: IF NOT HZ_MATCH_RULE_52.check_staged THEN

717: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
718: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,'N',x_search_ctx_id,x_num_matches);
719: -- Code for Match rule BULK MATCH: IDENTICAL PARTIES
720: ELSIF p_rule_id=52 THEN
721: IF NOT HZ_MATCH_RULE_52.check_staged THEN
722: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
723: FND_MSG_PUB.ADD;
724: RAISE FND_API.G_EXC_ERROR;
725: END IF;

Line 726: HZ_MATCH_RULE_52.find_persons(

722: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
723: FND_MSG_PUB.ADD;
724: RAISE FND_API.G_EXC_ERROR;
725: END IF;
726: HZ_MATCH_RULE_52.find_persons(
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 CREDIT MANAGEMENT SEARCH
730: ELSIF p_rule_id=53 THEN

Line 1140: IF NOT HZ_MATCH_RULE_52.check_staged THEN

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 BULK MATCH: IDENTICAL PARTIES
1139: ELSIF p_rule_id=52 THEN
1140: IF NOT HZ_MATCH_RULE_52.check_staged THEN
1141: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1142: FND_MSG_PUB.ADD;
1143: RAISE FND_API.G_EXC_ERROR;
1144: END IF;

Line 1145: HZ_MATCH_RULE_52.find_party_details(

1141: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1142: FND_MSG_PUB.ADD;
1143: RAISE FND_API.G_EXC_ERROR;
1144: END IF;
1145: HZ_MATCH_RULE_52.find_party_details(
1146: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
1147: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
1148: -- Code for Match rule CREDIT MANAGEMENT SEARCH
1149: ELSIF p_rule_id=53 THEN

Line 1540: IF NOT HZ_MATCH_RULE_52.check_staged THEN

1536: p_rule_id,p_party_id,
1537: p_restrict_sql,p_match_type,p_dup_batch_id,p_search_merged,x_dup_set_id, x_search_ctx_id,x_num_matches);
1538: -- Code for Match rule BULK MATCH: IDENTICAL PARTIES
1539: ELSIF p_rule_id=52 THEN
1540: IF NOT HZ_MATCH_RULE_52.check_staged THEN
1541: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1542: FND_MSG_PUB.ADD;
1543: RAISE FND_API.G_EXC_ERROR;
1544: END IF;

Line 1545: HZ_MATCH_RULE_52.find_duplicate_parties(

1541: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1542: FND_MSG_PUB.ADD;
1543: RAISE FND_API.G_EXC_ERROR;
1544: END IF;
1545: HZ_MATCH_RULE_52.find_duplicate_parties(
1546: p_rule_id,p_party_id,
1547: p_restrict_sql,p_match_type,p_dup_batch_id,p_search_merged,x_dup_set_id, x_search_ctx_id,x_num_matches);
1548: -- Code for Match rule CREDIT MANAGEMENT SEARCH
1549: ELSIF p_rule_id=53 THEN

Line 1935: IF NOT HZ_MATCH_RULE_52.check_staged THEN

1931: p_rule_id,p_party_site_id,p_party_id,
1932: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
1933: -- Code for Match rule BULK MATCH: IDENTICAL PARTIES
1934: ELSIF p_rule_id=52 THEN
1935: IF NOT HZ_MATCH_RULE_52.check_staged THEN
1936: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1937: FND_MSG_PUB.ADD;
1938: RAISE FND_API.G_EXC_ERROR;
1939: END IF;

Line 1940: HZ_MATCH_RULE_52.find_duplicate_party_sites(

1936: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1937: FND_MSG_PUB.ADD;
1938: RAISE FND_API.G_EXC_ERROR;
1939: END IF;
1940: HZ_MATCH_RULE_52.find_duplicate_party_sites(
1941: p_rule_id,p_party_site_id,p_party_id,
1942: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
1943: -- Code for Match rule CREDIT MANAGEMENT SEARCH
1944: ELSIF p_rule_id=53 THEN

Line 2329: IF NOT HZ_MATCH_RULE_52.check_staged THEN

2325: p_rule_id,p_org_contact_id,p_party_id,
2326: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2327: -- Code for Match rule BULK MATCH: IDENTICAL PARTIES
2328: ELSIF p_rule_id=52 THEN
2329: IF NOT HZ_MATCH_RULE_52.check_staged THEN
2330: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2331: FND_MSG_PUB.ADD;
2332: RAISE FND_API.G_EXC_ERROR;
2333: END IF;

Line 2334: HZ_MATCH_RULE_52.find_duplicate_contacts(

2330: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2331: FND_MSG_PUB.ADD;
2332: RAISE FND_API.G_EXC_ERROR;
2333: END IF;
2334: HZ_MATCH_RULE_52.find_duplicate_contacts(
2335: p_rule_id,p_org_contact_id,p_party_id,
2336: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2337: -- Code for Match rule CREDIT MANAGEMENT SEARCH
2338: ELSIF p_rule_id=53 THEN

Line 2723: IF NOT HZ_MATCH_RULE_52.check_staged THEN

2719: p_rule_id,p_contact_point_id,p_party_id,
2720: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2721: -- Code for Match rule BULK MATCH: IDENTICAL PARTIES
2722: ELSIF p_rule_id=52 THEN
2723: IF NOT HZ_MATCH_RULE_52.check_staged THEN
2724: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2725: FND_MSG_PUB.ADD;
2726: RAISE FND_API.G_EXC_ERROR;
2727: END IF;

Line 2728: HZ_MATCH_RULE_52.find_duplicate_contact_points(

2724: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2725: FND_MSG_PUB.ADD;
2726: RAISE FND_API.G_EXC_ERROR;
2727: END IF;
2728: HZ_MATCH_RULE_52.find_duplicate_contact_points(
2729: p_rule_id,p_contact_point_id,p_party_id,
2730: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2731: -- Code for Match rule CREDIT MANAGEMENT SEARCH
2732: ELSIF p_rule_id=53 THEN

Line 3325: IF NOT HZ_MATCH_RULE_52.check_staged THEN

3321: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3322: p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
3323: -- Code for Match rule BULK MATCH: IDENTICAL PARTIES
3324: ELSIF p_rule_id=52 THEN
3325: IF NOT HZ_MATCH_RULE_52.check_staged THEN
3326: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3327: FND_MSG_PUB.ADD;
3328: RAISE FND_API.G_EXC_ERROR;
3329: END IF;

Line 3330: HZ_MATCH_RULE_52.find_parties_dynamic(

3326: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3327: FND_MSG_PUB.ADD;
3328: RAISE FND_API.G_EXC_ERROR;
3329: END IF;
3330: HZ_MATCH_RULE_52.find_parties_dynamic(
3331: p_rule_id,
3332: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
3333: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
3334: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 4008: IF NOT HZ_MATCH_RULE_52.check_staged THEN

4004: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
4005: p_restrict_sql,p_api_name,p_match_type,p_party_id,p_search_merged,x_search_ctx_id,x_num_matches);
4006: -- Code for Match rule BULK MATCH: IDENTICAL PARTIES
4007: ELSIF p_rule_id=52 THEN
4008: IF NOT HZ_MATCH_RULE_52.check_staged THEN
4009: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4010: FND_MSG_PUB.ADD;
4011: RAISE FND_API.G_EXC_ERROR;
4012: END IF;

Line 4013: HZ_MATCH_RULE_52.call_api_dynamic(

4009: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4010: FND_MSG_PUB.ADD;
4011: RAISE FND_API.G_EXC_ERROR;
4012: END IF;
4013: HZ_MATCH_RULE_52.call_api_dynamic(
4014: p_rule_id,
4015: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
4016: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
4017: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 4714: IF NOT HZ_MATCH_RULE_52.check_staged THEN

4710: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4711: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4712: -- Code for Match rule BULK MATCH: IDENTICAL PARTIES
4713: ELSIF p_rule_id=52 THEN
4714: IF NOT HZ_MATCH_RULE_52.check_staged THEN
4715: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4716: FND_MSG_PUB.ADD;
4717: RAISE FND_API.G_EXC_ERROR;
4718: END IF;

Line 4719: HZ_MATCH_RULE_52.get_matching_party_sites(

4715: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4716: FND_MSG_PUB.ADD;
4717: RAISE FND_API.G_EXC_ERROR;
4718: END IF;
4719: HZ_MATCH_RULE_52.get_matching_party_sites(
4720: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4721: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4722: -- Code for Match rule CREDIT MANAGEMENT SEARCH
4723: ELSIF p_rule_id=53 THEN

Line 5133: IF NOT HZ_MATCH_RULE_52.check_staged THEN

5129: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
5130: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5131: -- Code for Match rule BULK MATCH: IDENTICAL PARTIES
5132: ELSIF p_rule_id=52 THEN
5133: IF NOT HZ_MATCH_RULE_52.check_staged THEN
5134: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5135: FND_MSG_PUB.ADD;
5136: RAISE FND_API.G_EXC_ERROR;
5137: END IF;

Line 5138: HZ_MATCH_RULE_52.get_matching_contacts(

5134: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5135: FND_MSG_PUB.ADD;
5136: RAISE FND_API.G_EXC_ERROR;
5137: END IF;
5138: HZ_MATCH_RULE_52.get_matching_contacts(
5139: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
5140: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5141: -- Code for Match rule CREDIT MANAGEMENT SEARCH
5142: ELSIF p_rule_id=53 THEN

Line 5550: IF NOT HZ_MATCH_RULE_52.check_staged THEN

5546: p_rule_id, p_party_id, p_contact_point_list,
5547: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5548: -- Code for Match rule BULK MATCH: IDENTICAL PARTIES
5549: ELSIF p_rule_id=52 THEN
5550: IF NOT HZ_MATCH_RULE_52.check_staged THEN
5551: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5552: FND_MSG_PUB.ADD;
5553: RAISE FND_API.G_EXC_ERROR;
5554: END IF;

Line 5555: HZ_MATCH_RULE_52.get_matching_contact_points(

5551: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5552: FND_MSG_PUB.ADD;
5553: RAISE FND_API.G_EXC_ERROR;
5554: END IF;
5555: HZ_MATCH_RULE_52.get_matching_contact_points(
5556: p_rule_id, p_party_id, p_contact_point_list,
5557: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5558: -- Code for Match rule CREDIT MANAGEMENT SEARCH
5559: ELSIF p_rule_id=53 THEN

Line 5991: IF NOT HZ_MATCH_RULE_52.check_staged THEN

5987: p_party_id, p_party_search_rec,p_party_site_list,
5988: p_contact_list, p_contact_point_list,x_search_ctx_id);
5989: -- Code for Match rule BULK MATCH: IDENTICAL PARTIES
5990: ELSIF p_rule_id=52 THEN
5991: IF NOT HZ_MATCH_RULE_52.check_staged THEN
5992: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5993: FND_MSG_PUB.ADD;
5994: RAISE FND_API.G_EXC_ERROR;
5995: END IF;

Line 5996: HZ_MATCH_RULE_52.get_score_details(

5992: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5993: FND_MSG_PUB.ADD;
5994: RAISE FND_API.G_EXC_ERROR;
5995: END IF;
5996: HZ_MATCH_RULE_52.get_score_details(
5997: p_rule_id,
5998: p_party_id, p_party_search_rec,p_party_site_list,
5999: p_contact_list, p_contact_point_list,x_search_ctx_id);
6000: -- Code for Match rule CREDIT MANAGEMENT SEARCH

Line 6390: IF NOT HZ_MATCH_RULE_52.check_staged THEN

6386: p_party_id, x_party_search_rec,x_party_site_list,
6387: x_contact_list, x_contact_point_list);
6388: -- Code for Match rule BULK MATCH: IDENTICAL PARTIES
6389: ELSIF p_rule_id=52 THEN
6390: IF NOT HZ_MATCH_RULE_52.check_staged THEN
6391: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6392: FND_MSG_PUB.ADD;
6393: RAISE FND_API.G_EXC_ERROR;
6394: END IF;

Line 6395: HZ_MATCH_RULE_52.get_party_for_search(

6391: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6392: FND_MSG_PUB.ADD;
6393: RAISE FND_API.G_EXC_ERROR;
6394: END IF;
6395: HZ_MATCH_RULE_52.get_party_for_search(
6396: p_party_id, x_party_search_rec,x_party_site_list,
6397: x_contact_list, x_contact_point_list);
6398: -- Code for Match rule CREDIT MANAGEMENT SEARCH
6399: ELSIF p_rule_id=53 THEN

Line 6782: IF NOT HZ_MATCH_RULE_52.check_staged THEN

6778: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6779: x_contact_list, x_contact_point_list);
6780: -- Code for Match rule BULK MATCH: IDENTICAL PARTIES
6781: ELSIF p_rule_id=52 THEN
6782: IF NOT HZ_MATCH_RULE_52.check_staged THEN
6783: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6784: FND_MSG_PUB.ADD;
6785: RAISE FND_API.G_EXC_ERROR;
6786: END IF;

Line 6787: HZ_MATCH_RULE_52.get_search_criteria(

6783: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6784: FND_MSG_PUB.ADD;
6785: RAISE FND_API.G_EXC_ERROR;
6786: END IF;
6787: HZ_MATCH_RULE_52.get_search_criteria(
6788: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6789: x_contact_list, x_contact_point_list);
6790: -- Code for Match rule CREDIT MANAGEMENT SEARCH
6791: ELSIF p_rule_id=53 THEN