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 751: IF NOT HZ_MATCH_RULE_60.check_staged THEN

747: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
748: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,'N',x_search_ctx_id,x_num_matches);
749: -- Code for Match rule HZ_PERSON_ADVANCED_SEARCH_MATCH_RULE
750: ELSIF p_rule_id=60 THEN
751: IF NOT HZ_MATCH_RULE_60.check_staged THEN
752: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
753: FND_MSG_PUB.ADD;
754: RAISE FND_API.G_EXC_ERROR;
755: END IF;

Line 756: HZ_MATCH_RULE_60.find_persons(

752: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
753: FND_MSG_PUB.ADD;
754: RAISE FND_API.G_EXC_ERROR;
755: END IF;
756: HZ_MATCH_RULE_60.find_persons(
757: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
758: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,'N',x_search_ctx_id,x_num_matches);
759: -- Code for Match rule HZ_ORG_SIMPLE_SEARCH_RULE
760: ELSIF p_rule_id=61 THEN

Line 1170: IF NOT HZ_MATCH_RULE_60.check_staged THEN

1166: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
1167: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
1168: -- Code for Match rule HZ_PERSON_ADVANCED_SEARCH_MATCH_RULE
1169: ELSIF p_rule_id=60 THEN
1170: IF NOT HZ_MATCH_RULE_60.check_staged THEN
1171: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1172: FND_MSG_PUB.ADD;
1173: RAISE FND_API.G_EXC_ERROR;
1174: END IF;

Line 1175: HZ_MATCH_RULE_60.find_party_details(

1171: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1172: FND_MSG_PUB.ADD;
1173: RAISE FND_API.G_EXC_ERROR;
1174: END IF;
1175: HZ_MATCH_RULE_60.find_party_details(
1176: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
1177: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
1178: -- Code for Match rule HZ_ORG_SIMPLE_SEARCH_RULE
1179: ELSIF p_rule_id=61 THEN

Line 1570: IF NOT HZ_MATCH_RULE_60.check_staged THEN

1566: p_rule_id,p_party_id,
1567: p_restrict_sql,p_match_type,p_dup_batch_id,p_search_merged,x_dup_set_id, x_search_ctx_id,x_num_matches);
1568: -- Code for Match rule HZ_PERSON_ADVANCED_SEARCH_MATCH_RULE
1569: ELSIF p_rule_id=60 THEN
1570: IF NOT HZ_MATCH_RULE_60.check_staged THEN
1571: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1572: FND_MSG_PUB.ADD;
1573: RAISE FND_API.G_EXC_ERROR;
1574: END IF;

Line 1575: HZ_MATCH_RULE_60.find_duplicate_parties(

1571: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1572: FND_MSG_PUB.ADD;
1573: RAISE FND_API.G_EXC_ERROR;
1574: END IF;
1575: HZ_MATCH_RULE_60.find_duplicate_parties(
1576: p_rule_id,p_party_id,
1577: p_restrict_sql,p_match_type,p_dup_batch_id,p_search_merged,x_dup_set_id, x_search_ctx_id,x_num_matches);
1578: -- Code for Match rule HZ_ORG_SIMPLE_SEARCH_RULE
1579: ELSIF p_rule_id=61 THEN

Line 1965: IF NOT HZ_MATCH_RULE_60.check_staged THEN

1961: p_rule_id,p_party_site_id,p_party_id,
1962: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
1963: -- Code for Match rule HZ_PERSON_ADVANCED_SEARCH_MATCH_RULE
1964: ELSIF p_rule_id=60 THEN
1965: IF NOT HZ_MATCH_RULE_60.check_staged THEN
1966: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1967: FND_MSG_PUB.ADD;
1968: RAISE FND_API.G_EXC_ERROR;
1969: END IF;

Line 1970: HZ_MATCH_RULE_60.find_duplicate_party_sites(

1966: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1967: FND_MSG_PUB.ADD;
1968: RAISE FND_API.G_EXC_ERROR;
1969: END IF;
1970: HZ_MATCH_RULE_60.find_duplicate_party_sites(
1971: p_rule_id,p_party_site_id,p_party_id,
1972: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
1973: -- Code for Match rule HZ_ORG_SIMPLE_SEARCH_RULE
1974: ELSIF p_rule_id=61 THEN

Line 2359: IF NOT HZ_MATCH_RULE_60.check_staged THEN

2355: p_rule_id,p_org_contact_id,p_party_id,
2356: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2357: -- Code for Match rule HZ_PERSON_ADVANCED_SEARCH_MATCH_RULE
2358: ELSIF p_rule_id=60 THEN
2359: IF NOT HZ_MATCH_RULE_60.check_staged THEN
2360: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2361: FND_MSG_PUB.ADD;
2362: RAISE FND_API.G_EXC_ERROR;
2363: END IF;

Line 2364: HZ_MATCH_RULE_60.find_duplicate_contacts(

2360: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2361: FND_MSG_PUB.ADD;
2362: RAISE FND_API.G_EXC_ERROR;
2363: END IF;
2364: HZ_MATCH_RULE_60.find_duplicate_contacts(
2365: p_rule_id,p_org_contact_id,p_party_id,
2366: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2367: -- Code for Match rule HZ_ORG_SIMPLE_SEARCH_RULE
2368: ELSIF p_rule_id=61 THEN

Line 2753: IF NOT HZ_MATCH_RULE_60.check_staged THEN

2749: p_rule_id,p_contact_point_id,p_party_id,
2750: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2751: -- Code for Match rule HZ_PERSON_ADVANCED_SEARCH_MATCH_RULE
2752: ELSIF p_rule_id=60 THEN
2753: IF NOT HZ_MATCH_RULE_60.check_staged THEN
2754: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2755: FND_MSG_PUB.ADD;
2756: RAISE FND_API.G_EXC_ERROR;
2757: END IF;

Line 2758: HZ_MATCH_RULE_60.find_duplicate_contact_points(

2754: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2755: FND_MSG_PUB.ADD;
2756: RAISE FND_API.G_EXC_ERROR;
2757: END IF;
2758: HZ_MATCH_RULE_60.find_duplicate_contact_points(
2759: p_rule_id,p_contact_point_id,p_party_id,
2760: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2761: -- Code for Match rule HZ_ORG_SIMPLE_SEARCH_RULE
2762: ELSIF p_rule_id=61 THEN

Line 3379: IF NOT HZ_MATCH_RULE_60.check_staged THEN

3375: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3376: p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
3377: -- Code for Match rule HZ_PERSON_ADVANCED_SEARCH_MATCH_RULE
3378: ELSIF p_rule_id=60 THEN
3379: IF NOT HZ_MATCH_RULE_60.check_staged THEN
3380: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3381: FND_MSG_PUB.ADD;
3382: RAISE FND_API.G_EXC_ERROR;
3383: END IF;

Line 3384: HZ_MATCH_RULE_60.find_parties_dynamic(

3380: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3381: FND_MSG_PUB.ADD;
3382: RAISE FND_API.G_EXC_ERROR;
3383: END IF;
3384: HZ_MATCH_RULE_60.find_parties_dynamic(
3385: p_rule_id,
3386: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
3387: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
3388: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 4062: IF NOT HZ_MATCH_RULE_60.check_staged THEN

4058: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
4059: p_restrict_sql,p_api_name,p_match_type,p_party_id,p_search_merged,x_search_ctx_id,x_num_matches);
4060: -- Code for Match rule HZ_PERSON_ADVANCED_SEARCH_MATCH_RULE
4061: ELSIF p_rule_id=60 THEN
4062: IF NOT HZ_MATCH_RULE_60.check_staged THEN
4063: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4064: FND_MSG_PUB.ADD;
4065: RAISE FND_API.G_EXC_ERROR;
4066: END IF;

Line 4067: HZ_MATCH_RULE_60.call_api_dynamic(

4063: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4064: FND_MSG_PUB.ADD;
4065: RAISE FND_API.G_EXC_ERROR;
4066: END IF;
4067: HZ_MATCH_RULE_60.call_api_dynamic(
4068: p_rule_id,
4069: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
4070: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
4071: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 4744: IF NOT HZ_MATCH_RULE_60.check_staged THEN

4740: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4741: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4742: -- Code for Match rule HZ_PERSON_ADVANCED_SEARCH_MATCH_RULE
4743: ELSIF p_rule_id=60 THEN
4744: IF NOT HZ_MATCH_RULE_60.check_staged THEN
4745: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4746: FND_MSG_PUB.ADD;
4747: RAISE FND_API.G_EXC_ERROR;
4748: END IF;

Line 4749: HZ_MATCH_RULE_60.get_matching_party_sites(

4745: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4746: FND_MSG_PUB.ADD;
4747: RAISE FND_API.G_EXC_ERROR;
4748: END IF;
4749: HZ_MATCH_RULE_60.get_matching_party_sites(
4750: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4751: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4752: -- Code for Match rule HZ_ORG_SIMPLE_SEARCH_RULE
4753: ELSIF p_rule_id=61 THEN

Line 5163: IF NOT HZ_MATCH_RULE_60.check_staged THEN

5159: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
5160: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5161: -- Code for Match rule HZ_PERSON_ADVANCED_SEARCH_MATCH_RULE
5162: ELSIF p_rule_id=60 THEN
5163: IF NOT HZ_MATCH_RULE_60.check_staged THEN
5164: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5165: FND_MSG_PUB.ADD;
5166: RAISE FND_API.G_EXC_ERROR;
5167: END IF;

Line 5168: HZ_MATCH_RULE_60.get_matching_contacts(

5164: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5165: FND_MSG_PUB.ADD;
5166: RAISE FND_API.G_EXC_ERROR;
5167: END IF;
5168: HZ_MATCH_RULE_60.get_matching_contacts(
5169: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
5170: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5171: -- Code for Match rule HZ_ORG_SIMPLE_SEARCH_RULE
5172: ELSIF p_rule_id=61 THEN

Line 5580: IF NOT HZ_MATCH_RULE_60.check_staged THEN

5576: p_rule_id, p_party_id, p_contact_point_list,
5577: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5578: -- Code for Match rule HZ_PERSON_ADVANCED_SEARCH_MATCH_RULE
5579: ELSIF p_rule_id=60 THEN
5580: IF NOT HZ_MATCH_RULE_60.check_staged THEN
5581: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5582: FND_MSG_PUB.ADD;
5583: RAISE FND_API.G_EXC_ERROR;
5584: END IF;

Line 5585: HZ_MATCH_RULE_60.get_matching_contact_points(

5581: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5582: FND_MSG_PUB.ADD;
5583: RAISE FND_API.G_EXC_ERROR;
5584: END IF;
5585: HZ_MATCH_RULE_60.get_matching_contact_points(
5586: p_rule_id, p_party_id, p_contact_point_list,
5587: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5588: -- Code for Match rule HZ_ORG_SIMPLE_SEARCH_RULE
5589: ELSIF p_rule_id=61 THEN

Line 6024: IF NOT HZ_MATCH_RULE_60.check_staged THEN

6020: p_party_id, p_party_search_rec,p_party_site_list,
6021: p_contact_list, p_contact_point_list,x_search_ctx_id);
6022: -- Code for Match rule HZ_PERSON_ADVANCED_SEARCH_MATCH_RULE
6023: ELSIF p_rule_id=60 THEN
6024: IF NOT HZ_MATCH_RULE_60.check_staged THEN
6025: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6026: FND_MSG_PUB.ADD;
6027: RAISE FND_API.G_EXC_ERROR;
6028: END IF;

Line 6029: HZ_MATCH_RULE_60.get_score_details(

6025: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6026: FND_MSG_PUB.ADD;
6027: RAISE FND_API.G_EXC_ERROR;
6028: END IF;
6029: HZ_MATCH_RULE_60.get_score_details(
6030: p_rule_id,
6031: p_party_id, p_party_search_rec,p_party_site_list,
6032: p_contact_list, p_contact_point_list,x_search_ctx_id);
6033: -- Code for Match rule HZ_ORG_SIMPLE_SEARCH_RULE

Line 6420: IF NOT HZ_MATCH_RULE_60.check_staged THEN

6416: p_party_id, x_party_search_rec,x_party_site_list,
6417: x_contact_list, x_contact_point_list);
6418: -- Code for Match rule HZ_PERSON_ADVANCED_SEARCH_MATCH_RULE
6419: ELSIF p_rule_id=60 THEN
6420: IF NOT HZ_MATCH_RULE_60.check_staged THEN
6421: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6422: FND_MSG_PUB.ADD;
6423: RAISE FND_API.G_EXC_ERROR;
6424: END IF;

Line 6425: HZ_MATCH_RULE_60.get_party_for_search(

6421: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6422: FND_MSG_PUB.ADD;
6423: RAISE FND_API.G_EXC_ERROR;
6424: END IF;
6425: HZ_MATCH_RULE_60.get_party_for_search(
6426: p_party_id, x_party_search_rec,x_party_site_list,
6427: x_contact_list, x_contact_point_list);
6428: -- Code for Match rule HZ_ORG_SIMPLE_SEARCH_RULE
6429: ELSIF p_rule_id=61 THEN

Line 6812: IF NOT HZ_MATCH_RULE_60.check_staged THEN

6808: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6809: x_contact_list, x_contact_point_list);
6810: -- Code for Match rule HZ_PERSON_ADVANCED_SEARCH_MATCH_RULE
6811: ELSIF p_rule_id=60 THEN
6812: IF NOT HZ_MATCH_RULE_60.check_staged THEN
6813: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6814: FND_MSG_PUB.ADD;
6815: RAISE FND_API.G_EXC_ERROR;
6816: END IF;

Line 6817: HZ_MATCH_RULE_60.get_search_criteria(

6813: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6814: FND_MSG_PUB.ADD;
6815: RAISE FND_API.G_EXC_ERROR;
6816: END IF;
6817: HZ_MATCH_RULE_60.get_search_criteria(
6818: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6819: x_contact_list, x_contact_point_list);
6820: -- Code for Match rule HZ_ORG_SIMPLE_SEARCH_RULE
6821: ELSIF p_rule_id=61 THEN