DBA Data[Home] [Help]

APPS.HZ_PARTY_SEARCH dependencies on HZ_MATCH_RULE_53

Line 330: IF NOT HZ_MATCH_RULE_53.check_staged THEN

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
330: IF NOT HZ_MATCH_RULE_53.check_staged THEN
331: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
332: FND_MSG_PUB.ADD;
333: RAISE FND_API.G_EXC_ERROR;
334: END IF;

Line 335: HZ_MATCH_RULE_53.find_parties(

331: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
332: FND_MSG_PUB.ADD;
333: RAISE FND_API.G_EXC_ERROR;
334: END IF;
335: HZ_MATCH_RULE_53.find_parties(
336: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
337: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,NULL,NULL,NULL,'N',x_search_ctx_id,x_num_matches);
338: -- Code for Match rule HZ_PERSON_SIMPLE_SEARCH_RULE
339: ELSIF p_rule_id=58 THEN

Line 711: IF NOT HZ_MATCH_RULE_53.check_staged THEN

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
711: IF NOT HZ_MATCH_RULE_53.check_staged THEN
712: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
713: FND_MSG_PUB.ADD;
714: RAISE FND_API.G_EXC_ERROR;
715: END IF;

Line 716: HZ_MATCH_RULE_53.find_persons(

712: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
713: FND_MSG_PUB.ADD;
714: RAISE FND_API.G_EXC_ERROR;
715: END IF;
716: HZ_MATCH_RULE_53.find_persons(
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 HZ_PERSON_SIMPLE_SEARCH_RULE
720: ELSIF p_rule_id=58 THEN

Line 1110: IF NOT HZ_MATCH_RULE_53.check_staged THEN

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
1110: IF NOT HZ_MATCH_RULE_53.check_staged THEN
1111: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1112: FND_MSG_PUB.ADD;
1113: RAISE FND_API.G_EXC_ERROR;
1114: END IF;

Line 1115: HZ_MATCH_RULE_53.find_party_details(

1111: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1112: FND_MSG_PUB.ADD;
1113: RAISE FND_API.G_EXC_ERROR;
1114: END IF;
1115: HZ_MATCH_RULE_53.find_party_details(
1116: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
1117: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
1118: -- Code for Match rule HZ_PERSON_SIMPLE_SEARCH_RULE
1119: ELSIF p_rule_id=58 THEN

Line 1490: IF NOT HZ_MATCH_RULE_53.check_staged THEN

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
1490: IF NOT HZ_MATCH_RULE_53.check_staged THEN
1491: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1492: FND_MSG_PUB.ADD;
1493: RAISE FND_API.G_EXC_ERROR;
1494: END IF;

Line 1495: HZ_MATCH_RULE_53.find_duplicate_parties(

1491: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1492: FND_MSG_PUB.ADD;
1493: RAISE FND_API.G_EXC_ERROR;
1494: END IF;
1495: HZ_MATCH_RULE_53.find_duplicate_parties(
1496: p_rule_id,p_party_id,
1497: p_restrict_sql,p_match_type,p_dup_batch_id,p_search_merged,x_dup_set_id, x_search_ctx_id,x_num_matches);
1498: -- Code for Match rule HZ_PERSON_SIMPLE_SEARCH_RULE
1499: ELSIF p_rule_id=58 THEN

Line 1865: IF NOT HZ_MATCH_RULE_53.check_staged THEN

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
1865: IF NOT HZ_MATCH_RULE_53.check_staged THEN
1866: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1867: FND_MSG_PUB.ADD;
1868: RAISE FND_API.G_EXC_ERROR;
1869: END IF;

Line 1870: HZ_MATCH_RULE_53.find_duplicate_party_sites(

1866: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1867: FND_MSG_PUB.ADD;
1868: RAISE FND_API.G_EXC_ERROR;
1869: END IF;
1870: HZ_MATCH_RULE_53.find_duplicate_party_sites(
1871: p_rule_id,p_party_site_id,p_party_id,
1872: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
1873: -- Code for Match rule HZ_PERSON_SIMPLE_SEARCH_RULE
1874: ELSIF p_rule_id=58 THEN

Line 2239: IF NOT HZ_MATCH_RULE_53.check_staged THEN

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
2239: IF NOT HZ_MATCH_RULE_53.check_staged THEN
2240: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2241: FND_MSG_PUB.ADD;
2242: RAISE FND_API.G_EXC_ERROR;
2243: END IF;

Line 2244: HZ_MATCH_RULE_53.find_duplicate_contacts(

2240: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2241: FND_MSG_PUB.ADD;
2242: RAISE FND_API.G_EXC_ERROR;
2243: END IF;
2244: HZ_MATCH_RULE_53.find_duplicate_contacts(
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 HZ_PERSON_SIMPLE_SEARCH_RULE
2248: ELSIF p_rule_id=58 THEN

Line 2613: IF NOT HZ_MATCH_RULE_53.check_staged THEN

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
2613: IF NOT HZ_MATCH_RULE_53.check_staged THEN
2614: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2615: FND_MSG_PUB.ADD;
2616: RAISE FND_API.G_EXC_ERROR;
2617: END IF;

Line 2618: HZ_MATCH_RULE_53.find_duplicate_contact_points(

2614: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2615: FND_MSG_PUB.ADD;
2616: RAISE FND_API.G_EXC_ERROR;
2617: END IF;
2618: HZ_MATCH_RULE_53.find_duplicate_contact_points(
2619: p_rule_id,p_contact_point_id,p_party_id,
2620: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2621: -- Code for Match rule HZ_PERSON_SIMPLE_SEARCH_RULE
2622: ELSIF p_rule_id=58 THEN

Line 3203: IF NOT HZ_MATCH_RULE_53.check_staged THEN

3199: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3200: p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
3201: -- Code for Match rule CREDIT MANAGEMENT SEARCH
3202: ELSIF p_rule_id=53 THEN
3203: IF NOT HZ_MATCH_RULE_53.check_staged THEN
3204: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3205: FND_MSG_PUB.ADD;
3206: RAISE FND_API.G_EXC_ERROR;
3207: END IF;

Line 3208: HZ_MATCH_RULE_53.find_parties_dynamic(

3204: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3205: FND_MSG_PUB.ADD;
3206: RAISE FND_API.G_EXC_ERROR;
3207: END IF;
3208: HZ_MATCH_RULE_53.find_parties_dynamic(
3209: p_rule_id,
3210: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
3211: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
3212: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 3850: IF NOT HZ_MATCH_RULE_53.check_staged THEN

3846: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3847: p_restrict_sql,p_api_name,p_match_type,p_party_id,p_search_merged,x_search_ctx_id,x_num_matches);
3848: -- Code for Match rule CREDIT MANAGEMENT SEARCH
3849: ELSIF p_rule_id=53 THEN
3850: IF NOT HZ_MATCH_RULE_53.check_staged THEN
3851: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3852: FND_MSG_PUB.ADD;
3853: RAISE FND_API.G_EXC_ERROR;
3854: END IF;

Line 3855: HZ_MATCH_RULE_53.call_api_dynamic(

3851: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3852: FND_MSG_PUB.ADD;
3853: RAISE FND_API.G_EXC_ERROR;
3854: END IF;
3855: HZ_MATCH_RULE_53.call_api_dynamic(
3856: p_rule_id,
3857: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
3858: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
3859: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 4512: IF NOT HZ_MATCH_RULE_53.check_staged THEN

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
4512: IF NOT HZ_MATCH_RULE_53.check_staged THEN
4513: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4514: FND_MSG_PUB.ADD;
4515: RAISE FND_API.G_EXC_ERROR;
4516: END IF;

Line 4517: HZ_MATCH_RULE_53.get_matching_party_sites(

4513: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4514: FND_MSG_PUB.ADD;
4515: RAISE FND_API.G_EXC_ERROR;
4516: END IF;
4517: HZ_MATCH_RULE_53.get_matching_party_sites(
4518: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4519: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4520: -- Code for Match rule HZ_PERSON_SIMPLE_SEARCH_RULE
4521: ELSIF p_rule_id=58 THEN

Line 4911: IF NOT HZ_MATCH_RULE_53.check_staged THEN

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
4911: IF NOT HZ_MATCH_RULE_53.check_staged THEN
4912: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4913: FND_MSG_PUB.ADD;
4914: RAISE FND_API.G_EXC_ERROR;
4915: END IF;

Line 4916: HZ_MATCH_RULE_53.get_matching_contacts(

4912: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4913: FND_MSG_PUB.ADD;
4914: RAISE FND_API.G_EXC_ERROR;
4915: END IF;
4916: HZ_MATCH_RULE_53.get_matching_contacts(
4917: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
4918: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4919: -- Code for Match rule HZ_PERSON_SIMPLE_SEARCH_RULE
4920: ELSIF p_rule_id=58 THEN

Line 5308: IF NOT HZ_MATCH_RULE_53.check_staged THEN

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
5308: IF NOT HZ_MATCH_RULE_53.check_staged THEN
5309: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5310: FND_MSG_PUB.ADD;
5311: RAISE FND_API.G_EXC_ERROR;
5312: END IF;

Line 5313: HZ_MATCH_RULE_53.get_matching_contact_points(

5309: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5310: FND_MSG_PUB.ADD;
5311: RAISE FND_API.G_EXC_ERROR;
5312: END IF;
5313: HZ_MATCH_RULE_53.get_matching_contact_points(
5314: p_rule_id, p_party_id, p_contact_point_list,
5315: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5316: -- Code for Match rule HZ_PERSON_SIMPLE_SEARCH_RULE
5317: ELSIF p_rule_id=58 THEN

Line 5730: IF NOT HZ_MATCH_RULE_53.check_staged THEN

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
5729: ELSIF p_rule_id=53 THEN
5730: IF NOT HZ_MATCH_RULE_53.check_staged THEN
5731: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5732: FND_MSG_PUB.ADD;
5733: RAISE FND_API.G_EXC_ERROR;
5734: END IF;

Line 5735: HZ_MATCH_RULE_53.get_score_details(

5731: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5732: FND_MSG_PUB.ADD;
5733: RAISE FND_API.G_EXC_ERROR;
5734: END IF;
5735: HZ_MATCH_RULE_53.get_score_details(
5736: p_rule_id,
5737: p_party_id, p_party_search_rec,p_party_site_list,
5738: p_contact_list, p_contact_point_list,x_search_ctx_id);
5739: -- Code for Match rule HZ_PERSON_SIMPLE_SEARCH_RULE

Line 6106: IF NOT HZ_MATCH_RULE_53.check_staged THEN

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
6106: IF NOT HZ_MATCH_RULE_53.check_staged THEN
6107: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6108: FND_MSG_PUB.ADD;
6109: RAISE FND_API.G_EXC_ERROR;
6110: END IF;

Line 6111: HZ_MATCH_RULE_53.get_party_for_search(

6107: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6108: FND_MSG_PUB.ADD;
6109: RAISE FND_API.G_EXC_ERROR;
6110: END IF;
6111: HZ_MATCH_RULE_53.get_party_for_search(
6112: p_party_id, x_party_search_rec,x_party_site_list,
6113: x_contact_list, x_contact_point_list);
6114: -- Code for Match rule HZ_PERSON_SIMPLE_SEARCH_RULE
6115: ELSIF p_rule_id=58 THEN

Line 6478: IF NOT HZ_MATCH_RULE_53.check_staged THEN

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
6478: IF NOT HZ_MATCH_RULE_53.check_staged THEN
6479: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6480: FND_MSG_PUB.ADD;
6481: RAISE FND_API.G_EXC_ERROR;
6482: END IF;

Line 6483: HZ_MATCH_RULE_53.get_search_criteria(

6479: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6480: FND_MSG_PUB.ADD;
6481: RAISE FND_API.G_EXC_ERROR;
6482: END IF;
6483: HZ_MATCH_RULE_53.get_search_criteria(
6484: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6485: x_contact_list, x_contact_point_list);
6486: -- Code for Match rule HZ_PERSON_SIMPLE_SEARCH_RULE
6487: ELSIF p_rule_id=58 THEN