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 701: IF NOT HZ_MATCH_RULE_52.check_staged THEN

697: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
698: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,'N',x_search_ctx_id,x_num_matches);
699: -- Code for Match rule BULK MATCH: IDENTICAL PARTIES
700: ELSIF p_rule_id=52 THEN
701: IF NOT HZ_MATCH_RULE_52.check_staged THEN
702: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
703: FND_MSG_PUB.ADD;
704: RAISE FND_API.G_EXC_ERROR;
705: END IF;

Line 706: HZ_MATCH_RULE_52.find_persons(

702: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
703: FND_MSG_PUB.ADD;
704: RAISE FND_API.G_EXC_ERROR;
705: END IF;
706: HZ_MATCH_RULE_52.find_persons(
707: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
708: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,'N',x_search_ctx_id,x_num_matches);
709: -- Code for Match rule CREDIT MANAGEMENT SEARCH
710: ELSIF p_rule_id=53 THEN

Line 1100: IF NOT HZ_MATCH_RULE_52.check_staged THEN

1096: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
1097: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
1098: -- Code for Match rule BULK MATCH: IDENTICAL PARTIES
1099: ELSIF p_rule_id=52 THEN
1100: IF NOT HZ_MATCH_RULE_52.check_staged THEN
1101: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1102: FND_MSG_PUB.ADD;
1103: RAISE FND_API.G_EXC_ERROR;
1104: END IF;

Line 1105: HZ_MATCH_RULE_52.find_party_details(

1101: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1102: FND_MSG_PUB.ADD;
1103: RAISE FND_API.G_EXC_ERROR;
1104: END IF;
1105: HZ_MATCH_RULE_52.find_party_details(
1106: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
1107: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
1108: -- Code for Match rule CREDIT MANAGEMENT SEARCH
1109: ELSIF p_rule_id=53 THEN

Line 1480: IF NOT HZ_MATCH_RULE_52.check_staged THEN

1476: p_rule_id,p_party_id,
1477: p_restrict_sql,p_match_type,p_dup_batch_id,p_search_merged,x_dup_set_id, x_search_ctx_id,x_num_matches);
1478: -- Code for Match rule BULK MATCH: IDENTICAL PARTIES
1479: ELSIF p_rule_id=52 THEN
1480: IF NOT HZ_MATCH_RULE_52.check_staged THEN
1481: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1482: FND_MSG_PUB.ADD;
1483: RAISE FND_API.G_EXC_ERROR;
1484: END IF;

Line 1485: HZ_MATCH_RULE_52.find_duplicate_parties(

1481: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1482: FND_MSG_PUB.ADD;
1483: RAISE FND_API.G_EXC_ERROR;
1484: END IF;
1485: HZ_MATCH_RULE_52.find_duplicate_parties(
1486: p_rule_id,p_party_id,
1487: p_restrict_sql,p_match_type,p_dup_batch_id,p_search_merged,x_dup_set_id, x_search_ctx_id,x_num_matches);
1488: -- Code for Match rule CREDIT MANAGEMENT SEARCH
1489: ELSIF p_rule_id=53 THEN

Line 1855: IF NOT HZ_MATCH_RULE_52.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 BULK MATCH: IDENTICAL PARTIES
1854: ELSIF p_rule_id=52 THEN
1855: IF NOT HZ_MATCH_RULE_52.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_52.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_52.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 CREDIT MANAGEMENT SEARCH
1864: ELSIF p_rule_id=53 THEN

Line 2229: IF NOT HZ_MATCH_RULE_52.check_staged THEN

2225: p_rule_id,p_org_contact_id,p_party_id,
2226: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2227: -- Code for Match rule BULK MATCH: IDENTICAL PARTIES
2228: ELSIF p_rule_id=52 THEN
2229: IF NOT HZ_MATCH_RULE_52.check_staged THEN
2230: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2231: FND_MSG_PUB.ADD;
2232: RAISE FND_API.G_EXC_ERROR;
2233: END IF;

Line 2234: HZ_MATCH_RULE_52.find_duplicate_contacts(

2230: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2231: FND_MSG_PUB.ADD;
2232: RAISE FND_API.G_EXC_ERROR;
2233: END IF;
2234: HZ_MATCH_RULE_52.find_duplicate_contacts(
2235: p_rule_id,p_org_contact_id,p_party_id,
2236: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2237: -- Code for Match rule CREDIT MANAGEMENT SEARCH
2238: ELSIF p_rule_id=53 THEN

Line 2603: IF NOT HZ_MATCH_RULE_52.check_staged THEN

2599: p_rule_id,p_contact_point_id,p_party_id,
2600: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2601: -- Code for Match rule BULK MATCH: IDENTICAL PARTIES
2602: ELSIF p_rule_id=52 THEN
2603: IF NOT HZ_MATCH_RULE_52.check_staged THEN
2604: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2605: FND_MSG_PUB.ADD;
2606: RAISE FND_API.G_EXC_ERROR;
2607: END IF;

Line 2608: HZ_MATCH_RULE_52.find_duplicate_contact_points(

2604: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2605: FND_MSG_PUB.ADD;
2606: RAISE FND_API.G_EXC_ERROR;
2607: END IF;
2608: HZ_MATCH_RULE_52.find_duplicate_contact_points(
2609: p_rule_id,p_contact_point_id,p_party_id,
2610: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2611: -- Code for Match rule CREDIT MANAGEMENT SEARCH
2612: ELSIF p_rule_id=53 THEN

Line 3185: IF NOT HZ_MATCH_RULE_52.check_staged THEN

3181: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3182: p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
3183: -- Code for Match rule BULK MATCH: IDENTICAL PARTIES
3184: ELSIF p_rule_id=52 THEN
3185: IF NOT HZ_MATCH_RULE_52.check_staged THEN
3186: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3187: FND_MSG_PUB.ADD;
3188: RAISE FND_API.G_EXC_ERROR;
3189: END IF;

Line 3190: HZ_MATCH_RULE_52.find_parties_dynamic(

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

Line 3832: IF NOT HZ_MATCH_RULE_52.check_staged THEN

3828: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3829: p_restrict_sql,p_api_name,p_match_type,p_party_id,p_search_merged,x_search_ctx_id,x_num_matches);
3830: -- Code for Match rule BULK MATCH: IDENTICAL PARTIES
3831: ELSIF p_rule_id=52 THEN
3832: IF NOT HZ_MATCH_RULE_52.check_staged THEN
3833: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3834: FND_MSG_PUB.ADD;
3835: RAISE FND_API.G_EXC_ERROR;
3836: END IF;

Line 3837: HZ_MATCH_RULE_52.call_api_dynamic(

3833: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3834: FND_MSG_PUB.ADD;
3835: RAISE FND_API.G_EXC_ERROR;
3836: END IF;
3837: HZ_MATCH_RULE_52.call_api_dynamic(
3838: p_rule_id,
3839: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
3840: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
3841: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 4502: IF NOT HZ_MATCH_RULE_52.check_staged THEN

4498: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4499: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4500: -- Code for Match rule BULK MATCH: IDENTICAL PARTIES
4501: ELSIF p_rule_id=52 THEN
4502: IF NOT HZ_MATCH_RULE_52.check_staged THEN
4503: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4504: FND_MSG_PUB.ADD;
4505: RAISE FND_API.G_EXC_ERROR;
4506: END IF;

Line 4507: HZ_MATCH_RULE_52.get_matching_party_sites(

4503: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4504: FND_MSG_PUB.ADD;
4505: RAISE FND_API.G_EXC_ERROR;
4506: END IF;
4507: HZ_MATCH_RULE_52.get_matching_party_sites(
4508: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4509: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4510: -- Code for Match rule CREDIT MANAGEMENT SEARCH
4511: ELSIF p_rule_id=53 THEN

Line 4901: IF NOT HZ_MATCH_RULE_52.check_staged THEN

4897: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
4898: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4899: -- Code for Match rule BULK MATCH: IDENTICAL PARTIES
4900: ELSIF p_rule_id=52 THEN
4901: IF NOT HZ_MATCH_RULE_52.check_staged THEN
4902: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4903: FND_MSG_PUB.ADD;
4904: RAISE FND_API.G_EXC_ERROR;
4905: END IF;

Line 4906: HZ_MATCH_RULE_52.get_matching_contacts(

4902: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4903: FND_MSG_PUB.ADD;
4904: RAISE FND_API.G_EXC_ERROR;
4905: END IF;
4906: HZ_MATCH_RULE_52.get_matching_contacts(
4907: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
4908: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4909: -- Code for Match rule CREDIT MANAGEMENT SEARCH
4910: ELSIF p_rule_id=53 THEN

Line 5298: IF NOT HZ_MATCH_RULE_52.check_staged THEN

5294: p_rule_id, p_party_id, p_contact_point_list,
5295: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5296: -- Code for Match rule BULK MATCH: IDENTICAL PARTIES
5297: ELSIF p_rule_id=52 THEN
5298: IF NOT HZ_MATCH_RULE_52.check_staged THEN
5299: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5300: FND_MSG_PUB.ADD;
5301: RAISE FND_API.G_EXC_ERROR;
5302: END IF;

Line 5303: HZ_MATCH_RULE_52.get_matching_contact_points(

5299: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5300: FND_MSG_PUB.ADD;
5301: RAISE FND_API.G_EXC_ERROR;
5302: END IF;
5303: HZ_MATCH_RULE_52.get_matching_contact_points(
5304: p_rule_id, p_party_id, p_contact_point_list,
5305: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5306: -- Code for Match rule CREDIT MANAGEMENT SEARCH
5307: ELSIF p_rule_id=53 THEN

Line 5719: IF NOT HZ_MATCH_RULE_52.check_staged THEN

5715: p_party_id, p_party_search_rec,p_party_site_list,
5716: p_contact_list, p_contact_point_list,x_search_ctx_id);
5717: -- Code for Match rule BULK MATCH: IDENTICAL PARTIES
5718: ELSIF p_rule_id=52 THEN
5719: IF NOT HZ_MATCH_RULE_52.check_staged THEN
5720: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5721: FND_MSG_PUB.ADD;
5722: RAISE FND_API.G_EXC_ERROR;
5723: END IF;

Line 5724: HZ_MATCH_RULE_52.get_score_details(

5720: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5721: FND_MSG_PUB.ADD;
5722: RAISE FND_API.G_EXC_ERROR;
5723: END IF;
5724: HZ_MATCH_RULE_52.get_score_details(
5725: p_rule_id,
5726: p_party_id, p_party_search_rec,p_party_site_list,
5727: p_contact_list, p_contact_point_list,x_search_ctx_id);
5728: -- Code for Match rule CREDIT MANAGEMENT SEARCH

Line 6096: IF NOT HZ_MATCH_RULE_52.check_staged THEN

6092: p_party_id, x_party_search_rec,x_party_site_list,
6093: x_contact_list, x_contact_point_list);
6094: -- Code for Match rule BULK MATCH: IDENTICAL PARTIES
6095: ELSIF p_rule_id=52 THEN
6096: IF NOT HZ_MATCH_RULE_52.check_staged THEN
6097: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6098: FND_MSG_PUB.ADD;
6099: RAISE FND_API.G_EXC_ERROR;
6100: END IF;

Line 6101: HZ_MATCH_RULE_52.get_party_for_search(

6097: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6098: FND_MSG_PUB.ADD;
6099: RAISE FND_API.G_EXC_ERROR;
6100: END IF;
6101: HZ_MATCH_RULE_52.get_party_for_search(
6102: p_party_id, x_party_search_rec,x_party_site_list,
6103: x_contact_list, x_contact_point_list);
6104: -- Code for Match rule CREDIT MANAGEMENT SEARCH
6105: ELSIF p_rule_id=53 THEN

Line 6468: IF NOT HZ_MATCH_RULE_52.check_staged THEN

6464: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6465: x_contact_list, x_contact_point_list);
6466: -- Code for Match rule BULK MATCH: IDENTICAL PARTIES
6467: ELSIF p_rule_id=52 THEN
6468: IF NOT HZ_MATCH_RULE_52.check_staged THEN
6469: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6470: FND_MSG_PUB.ADD;
6471: RAISE FND_API.G_EXC_ERROR;
6472: END IF;

Line 6473: HZ_MATCH_RULE_52.get_search_criteria(

6469: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6470: FND_MSG_PUB.ADD;
6471: RAISE FND_API.G_EXC_ERROR;
6472: END IF;
6473: HZ_MATCH_RULE_52.get_search_criteria(
6474: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6475: x_contact_list, x_contact_point_list);
6476: -- Code for Match rule CREDIT MANAGEMENT SEARCH
6477: ELSIF p_rule_id=53 THEN