DBA Data[Home] [Help]

APPS.HZ_PARTY_SEARCH dependencies on HZ_MATCH_RULE_38

Line 240: IF NOT HZ_MATCH_RULE_38.check_staged THEN

236: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
237: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,NULL,NULL,NULL,'N',x_search_ctx_id,x_num_matches);
238: -- Code for Match rule DL RELATIONSHIP DEFAULT
239: ELSIF p_rule_id=38 THEN
240: IF NOT HZ_MATCH_RULE_38.check_staged THEN
241: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
242: FND_MSG_PUB.ADD;
243: RAISE FND_API.G_EXC_ERROR;
244: END IF;

Line 245: HZ_MATCH_RULE_38.find_parties(

241: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
242: FND_MSG_PUB.ADD;
243: RAISE FND_API.G_EXC_ERROR;
244: END IF;
245: HZ_MATCH_RULE_38.find_parties(
246: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
247: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,NULL,NULL,NULL,'N',x_search_ctx_id,x_num_matches);
248: -- Code for Match rule SAMPLE: SEARCH ADDRESS ORGANIZATIONS EXACT
249: ELSIF p_rule_id=39 THEN

Line 641: IF NOT HZ_MATCH_RULE_38.check_staged THEN

637: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
638: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,'N',x_search_ctx_id,x_num_matches);
639: -- Code for Match rule DL RELATIONSHIP DEFAULT
640: ELSIF p_rule_id=38 THEN
641: IF NOT HZ_MATCH_RULE_38.check_staged THEN
642: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
643: FND_MSG_PUB.ADD;
644: RAISE FND_API.G_EXC_ERROR;
645: END IF;

Line 646: HZ_MATCH_RULE_38.find_persons(

642: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
643: FND_MSG_PUB.ADD;
644: RAISE FND_API.G_EXC_ERROR;
645: END IF;
646: HZ_MATCH_RULE_38.find_persons(
647: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
648: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,'N',x_search_ctx_id,x_num_matches);
649: -- Code for Match rule SAMPLE: SEARCH ADDRESS ORGANIZATIONS EXACT
650: ELSIF p_rule_id=39 THEN

Line 1060: IF NOT HZ_MATCH_RULE_38.check_staged THEN

1056: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
1057: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
1058: -- Code for Match rule DL RELATIONSHIP DEFAULT
1059: ELSIF p_rule_id=38 THEN
1060: IF NOT HZ_MATCH_RULE_38.check_staged THEN
1061: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1062: FND_MSG_PUB.ADD;
1063: RAISE FND_API.G_EXC_ERROR;
1064: END IF;

Line 1065: HZ_MATCH_RULE_38.find_party_details(

1061: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1062: FND_MSG_PUB.ADD;
1063: RAISE FND_API.G_EXC_ERROR;
1064: END IF;
1065: HZ_MATCH_RULE_38.find_party_details(
1066: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
1067: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
1068: -- Code for Match rule SAMPLE: SEARCH ADDRESS ORGANIZATIONS EXACT
1069: ELSIF p_rule_id=39 THEN

Line 1460: IF NOT HZ_MATCH_RULE_38.check_staged THEN

1456: p_rule_id,p_party_id,
1457: p_restrict_sql,p_match_type,p_dup_batch_id,p_search_merged,x_dup_set_id, x_search_ctx_id,x_num_matches);
1458: -- Code for Match rule DL RELATIONSHIP DEFAULT
1459: ELSIF p_rule_id=38 THEN
1460: IF NOT HZ_MATCH_RULE_38.check_staged THEN
1461: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1462: FND_MSG_PUB.ADD;
1463: RAISE FND_API.G_EXC_ERROR;
1464: END IF;

Line 1465: HZ_MATCH_RULE_38.find_duplicate_parties(

1461: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1462: FND_MSG_PUB.ADD;
1463: RAISE FND_API.G_EXC_ERROR;
1464: END IF;
1465: HZ_MATCH_RULE_38.find_duplicate_parties(
1466: p_rule_id,p_party_id,
1467: p_restrict_sql,p_match_type,p_dup_batch_id,p_search_merged,x_dup_set_id, x_search_ctx_id,x_num_matches);
1468: -- Code for Match rule SAMPLE: SEARCH ADDRESS ORGANIZATIONS EXACT
1469: ELSIF p_rule_id=39 THEN

Line 1855: IF NOT HZ_MATCH_RULE_38.check_staged THEN

1851: p_rule_id,p_party_site_id,p_party_id,
1852: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
1853: -- Code for Match rule DL RELATIONSHIP DEFAULT
1854: ELSIF p_rule_id=38 THEN
1855: IF NOT HZ_MATCH_RULE_38.check_staged THEN
1856: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1857: FND_MSG_PUB.ADD;
1858: RAISE FND_API.G_EXC_ERROR;
1859: END IF;

Line 1860: HZ_MATCH_RULE_38.find_duplicate_party_sites(

1856: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1857: FND_MSG_PUB.ADD;
1858: RAISE FND_API.G_EXC_ERROR;
1859: END IF;
1860: HZ_MATCH_RULE_38.find_duplicate_party_sites(
1861: p_rule_id,p_party_site_id,p_party_id,
1862: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
1863: -- Code for Match rule SAMPLE: SEARCH ADDRESS ORGANIZATIONS EXACT
1864: ELSIF p_rule_id=39 THEN

Line 2249: IF NOT HZ_MATCH_RULE_38.check_staged THEN

2245: p_rule_id,p_org_contact_id,p_party_id,
2246: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2247: -- Code for Match rule DL RELATIONSHIP DEFAULT
2248: ELSIF p_rule_id=38 THEN
2249: IF NOT HZ_MATCH_RULE_38.check_staged THEN
2250: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2251: FND_MSG_PUB.ADD;
2252: RAISE FND_API.G_EXC_ERROR;
2253: END IF;

Line 2254: HZ_MATCH_RULE_38.find_duplicate_contacts(

2250: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2251: FND_MSG_PUB.ADD;
2252: RAISE FND_API.G_EXC_ERROR;
2253: END IF;
2254: HZ_MATCH_RULE_38.find_duplicate_contacts(
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 SAMPLE: SEARCH ADDRESS ORGANIZATIONS EXACT
2258: ELSIF p_rule_id=39 THEN

Line 2643: IF NOT HZ_MATCH_RULE_38.check_staged THEN

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 DL RELATIONSHIP DEFAULT
2642: ELSIF p_rule_id=38 THEN
2643: IF NOT HZ_MATCH_RULE_38.check_staged THEN
2644: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2645: FND_MSG_PUB.ADD;
2646: RAISE FND_API.G_EXC_ERROR;
2647: END IF;

Line 2648: HZ_MATCH_RULE_38.find_duplicate_contact_points(

2644: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2645: FND_MSG_PUB.ADD;
2646: RAISE FND_API.G_EXC_ERROR;
2647: END IF;
2648: HZ_MATCH_RULE_38.find_duplicate_contact_points(
2649: p_rule_id,p_contact_point_id,p_party_id,
2650: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2651: -- Code for Match rule SAMPLE: SEARCH ADDRESS ORGANIZATIONS EXACT
2652: ELSIF p_rule_id=39 THEN

Line 3181: IF NOT HZ_MATCH_RULE_38.check_staged THEN

3177: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3178: p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
3179: -- Code for Match rule DL RELATIONSHIP DEFAULT
3180: ELSIF p_rule_id=38 THEN
3181: IF NOT HZ_MATCH_RULE_38.check_staged THEN
3182: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3183: FND_MSG_PUB.ADD;
3184: RAISE FND_API.G_EXC_ERROR;
3185: END IF;

Line 3186: HZ_MATCH_RULE_38.find_parties_dynamic(

3182: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3183: FND_MSG_PUB.ADD;
3184: RAISE FND_API.G_EXC_ERROR;
3185: END IF;
3186: HZ_MATCH_RULE_38.find_parties_dynamic(
3187: p_rule_id,
3188: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
3189: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
3190: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 3864: IF NOT HZ_MATCH_RULE_38.check_staged THEN

3860: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3861: p_restrict_sql,p_api_name,p_match_type,p_party_id,p_search_merged,x_search_ctx_id,x_num_matches);
3862: -- Code for Match rule DL RELATIONSHIP DEFAULT
3863: ELSIF p_rule_id=38 THEN
3864: IF NOT HZ_MATCH_RULE_38.check_staged THEN
3865: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3866: FND_MSG_PUB.ADD;
3867: RAISE FND_API.G_EXC_ERROR;
3868: END IF;

Line 3869: HZ_MATCH_RULE_38.call_api_dynamic(

3865: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3866: FND_MSG_PUB.ADD;
3867: RAISE FND_API.G_EXC_ERROR;
3868: END IF;
3869: HZ_MATCH_RULE_38.call_api_dynamic(
3870: p_rule_id,
3871: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
3872: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
3873: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 4634: IF NOT HZ_MATCH_RULE_38.check_staged THEN

4630: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4631: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4632: -- Code for Match rule DL RELATIONSHIP DEFAULT
4633: ELSIF p_rule_id=38 THEN
4634: IF NOT HZ_MATCH_RULE_38.check_staged THEN
4635: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4636: FND_MSG_PUB.ADD;
4637: RAISE FND_API.G_EXC_ERROR;
4638: END IF;

Line 4639: HZ_MATCH_RULE_38.get_matching_party_sites(

4635: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4636: FND_MSG_PUB.ADD;
4637: RAISE FND_API.G_EXC_ERROR;
4638: END IF;
4639: HZ_MATCH_RULE_38.get_matching_party_sites(
4640: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4641: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4642: -- Code for Match rule SAMPLE: SEARCH ADDRESS ORGANIZATIONS EXACT
4643: ELSIF p_rule_id=39 THEN

Line 5053: IF NOT HZ_MATCH_RULE_38.check_staged THEN

5049: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
5050: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5051: -- Code for Match rule DL RELATIONSHIP DEFAULT
5052: ELSIF p_rule_id=38 THEN
5053: IF NOT HZ_MATCH_RULE_38.check_staged THEN
5054: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5055: FND_MSG_PUB.ADD;
5056: RAISE FND_API.G_EXC_ERROR;
5057: END IF;

Line 5058: HZ_MATCH_RULE_38.get_matching_contacts(

5054: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5055: FND_MSG_PUB.ADD;
5056: RAISE FND_API.G_EXC_ERROR;
5057: END IF;
5058: HZ_MATCH_RULE_38.get_matching_contacts(
5059: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
5060: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5061: -- Code for Match rule SAMPLE: SEARCH ADDRESS ORGANIZATIONS EXACT
5062: ELSIF p_rule_id=39 THEN

Line 5470: IF NOT HZ_MATCH_RULE_38.check_staged THEN

5466: p_rule_id, p_party_id, p_contact_point_list,
5467: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5468: -- Code for Match rule DL RELATIONSHIP DEFAULT
5469: ELSIF p_rule_id=38 THEN
5470: IF NOT HZ_MATCH_RULE_38.check_staged THEN
5471: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5472: FND_MSG_PUB.ADD;
5473: RAISE FND_API.G_EXC_ERROR;
5474: END IF;

Line 5475: HZ_MATCH_RULE_38.get_matching_contact_points(

5471: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5472: FND_MSG_PUB.ADD;
5473: RAISE FND_API.G_EXC_ERROR;
5474: END IF;
5475: HZ_MATCH_RULE_38.get_matching_contact_points(
5476: p_rule_id, p_party_id, p_contact_point_list,
5477: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5478: -- Code for Match rule SAMPLE: SEARCH ADDRESS ORGANIZATIONS EXACT
5479: ELSIF p_rule_id=39 THEN

Line 5903: IF NOT HZ_MATCH_RULE_38.check_staged THEN

5899: p_party_id, p_party_search_rec,p_party_site_list,
5900: p_contact_list, p_contact_point_list,x_search_ctx_id);
5901: -- Code for Match rule DL RELATIONSHIP DEFAULT
5902: ELSIF p_rule_id=38 THEN
5903: IF NOT HZ_MATCH_RULE_38.check_staged THEN
5904: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5905: FND_MSG_PUB.ADD;
5906: RAISE FND_API.G_EXC_ERROR;
5907: END IF;

Line 5908: HZ_MATCH_RULE_38.get_score_details(

5904: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5905: FND_MSG_PUB.ADD;
5906: RAISE FND_API.G_EXC_ERROR;
5907: END IF;
5908: HZ_MATCH_RULE_38.get_score_details(
5909: p_rule_id,
5910: p_party_id, p_party_search_rec,p_party_site_list,
5911: p_contact_list, p_contact_point_list,x_search_ctx_id);
5912: -- Code for Match rule SAMPLE: SEARCH ADDRESS ORGANIZATIONS EXACT

Line 6310: IF NOT HZ_MATCH_RULE_38.check_staged THEN

6306: p_party_id, x_party_search_rec,x_party_site_list,
6307: x_contact_list, x_contact_point_list);
6308: -- Code for Match rule DL RELATIONSHIP DEFAULT
6309: ELSIF p_rule_id=38 THEN
6310: IF NOT HZ_MATCH_RULE_38.check_staged THEN
6311: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6312: FND_MSG_PUB.ADD;
6313: RAISE FND_API.G_EXC_ERROR;
6314: END IF;

Line 6315: HZ_MATCH_RULE_38.get_party_for_search(

6311: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6312: FND_MSG_PUB.ADD;
6313: RAISE FND_API.G_EXC_ERROR;
6314: END IF;
6315: HZ_MATCH_RULE_38.get_party_for_search(
6316: p_party_id, x_party_search_rec,x_party_site_list,
6317: x_contact_list, x_contact_point_list);
6318: -- Code for Match rule SAMPLE: SEARCH ADDRESS ORGANIZATIONS EXACT
6319: ELSIF p_rule_id=39 THEN

Line 6702: IF NOT HZ_MATCH_RULE_38.check_staged THEN

6698: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6699: x_contact_list, x_contact_point_list);
6700: -- Code for Match rule DL RELATIONSHIP DEFAULT
6701: ELSIF p_rule_id=38 THEN
6702: IF NOT HZ_MATCH_RULE_38.check_staged THEN
6703: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6704: FND_MSG_PUB.ADD;
6705: RAISE FND_API.G_EXC_ERROR;
6706: END IF;

Line 6707: HZ_MATCH_RULE_38.get_search_criteria(

6703: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6704: FND_MSG_PUB.ADD;
6705: RAISE FND_API.G_EXC_ERROR;
6706: END IF;
6707: HZ_MATCH_RULE_38.get_search_criteria(
6708: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6709: x_contact_list, x_contact_point_list);
6710: -- Code for Match rule SAMPLE: SEARCH ADDRESS ORGANIZATIONS EXACT
6711: ELSIF p_rule_id=39 THEN