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 731: IF NOT HZ_MATCH_RULE_53.check_staged THEN

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
731: IF NOT HZ_MATCH_RULE_53.check_staged THEN
732: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
733: FND_MSG_PUB.ADD;
734: RAISE FND_API.G_EXC_ERROR;
735: END IF;

Line 736: HZ_MATCH_RULE_53.find_persons(

732: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
733: FND_MSG_PUB.ADD;
734: RAISE FND_API.G_EXC_ERROR;
735: END IF;
736: HZ_MATCH_RULE_53.find_persons(
737: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
738: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,'N',x_search_ctx_id,x_num_matches);
739: -- Code for Match rule HZ_PERSON_SIMPLE_SEARCH_RULE
740: ELSIF p_rule_id=58 THEN

Line 1150: IF NOT HZ_MATCH_RULE_53.check_staged THEN

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
1150: IF NOT HZ_MATCH_RULE_53.check_staged THEN
1151: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1152: FND_MSG_PUB.ADD;
1153: RAISE FND_API.G_EXC_ERROR;
1154: END IF;

Line 1155: HZ_MATCH_RULE_53.find_party_details(

1151: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1152: FND_MSG_PUB.ADD;
1153: RAISE FND_API.G_EXC_ERROR;
1154: END IF;
1155: HZ_MATCH_RULE_53.find_party_details(
1156: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
1157: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
1158: -- Code for Match rule HZ_PERSON_SIMPLE_SEARCH_RULE
1159: ELSIF p_rule_id=58 THEN

Line 1550: IF NOT HZ_MATCH_RULE_53.check_staged THEN

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
1550: IF NOT HZ_MATCH_RULE_53.check_staged THEN
1551: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1552: FND_MSG_PUB.ADD;
1553: RAISE FND_API.G_EXC_ERROR;
1554: END IF;

Line 1555: HZ_MATCH_RULE_53.find_duplicate_parties(

1551: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1552: FND_MSG_PUB.ADD;
1553: RAISE FND_API.G_EXC_ERROR;
1554: END IF;
1555: HZ_MATCH_RULE_53.find_duplicate_parties(
1556: p_rule_id,p_party_id,
1557: p_restrict_sql,p_match_type,p_dup_batch_id,p_search_merged,x_dup_set_id, x_search_ctx_id,x_num_matches);
1558: -- Code for Match rule HZ_PERSON_SIMPLE_SEARCH_RULE
1559: ELSIF p_rule_id=58 THEN

Line 1945: IF NOT HZ_MATCH_RULE_53.check_staged THEN

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
1945: IF NOT HZ_MATCH_RULE_53.check_staged THEN
1946: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1947: FND_MSG_PUB.ADD;
1948: RAISE FND_API.G_EXC_ERROR;
1949: END IF;

Line 1950: HZ_MATCH_RULE_53.find_duplicate_party_sites(

1946: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1947: FND_MSG_PUB.ADD;
1948: RAISE FND_API.G_EXC_ERROR;
1949: END IF;
1950: HZ_MATCH_RULE_53.find_duplicate_party_sites(
1951: p_rule_id,p_party_site_id,p_party_id,
1952: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
1953: -- Code for Match rule HZ_PERSON_SIMPLE_SEARCH_RULE
1954: ELSIF p_rule_id=58 THEN

Line 2339: IF NOT HZ_MATCH_RULE_53.check_staged THEN

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
2339: IF NOT HZ_MATCH_RULE_53.check_staged THEN
2340: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2341: FND_MSG_PUB.ADD;
2342: RAISE FND_API.G_EXC_ERROR;
2343: END IF;

Line 2344: HZ_MATCH_RULE_53.find_duplicate_contacts(

2340: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2341: FND_MSG_PUB.ADD;
2342: RAISE FND_API.G_EXC_ERROR;
2343: END IF;
2344: HZ_MATCH_RULE_53.find_duplicate_contacts(
2345: p_rule_id,p_org_contact_id,p_party_id,
2346: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2347: -- Code for Match rule HZ_PERSON_SIMPLE_SEARCH_RULE
2348: ELSIF p_rule_id=58 THEN

Line 2733: IF NOT HZ_MATCH_RULE_53.check_staged THEN

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
2733: IF NOT HZ_MATCH_RULE_53.check_staged THEN
2734: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2735: FND_MSG_PUB.ADD;
2736: RAISE FND_API.G_EXC_ERROR;
2737: END IF;

Line 2738: HZ_MATCH_RULE_53.find_duplicate_contact_points(

2734: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2735: FND_MSG_PUB.ADD;
2736: RAISE FND_API.G_EXC_ERROR;
2737: END IF;
2738: HZ_MATCH_RULE_53.find_duplicate_contact_points(
2739: p_rule_id,p_contact_point_id,p_party_id,
2740: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2741: -- Code for Match rule HZ_PERSON_SIMPLE_SEARCH_RULE
2742: ELSIF p_rule_id=58 THEN

Line 3343: IF NOT HZ_MATCH_RULE_53.check_staged THEN

3339: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3340: p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
3341: -- Code for Match rule CREDIT MANAGEMENT SEARCH
3342: ELSIF p_rule_id=53 THEN
3343: IF NOT HZ_MATCH_RULE_53.check_staged THEN
3344: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3345: FND_MSG_PUB.ADD;
3346: RAISE FND_API.G_EXC_ERROR;
3347: END IF;

Line 3348: HZ_MATCH_RULE_53.find_parties_dynamic(

3344: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3345: FND_MSG_PUB.ADD;
3346: RAISE FND_API.G_EXC_ERROR;
3347: END IF;
3348: HZ_MATCH_RULE_53.find_parties_dynamic(
3349: p_rule_id,
3350: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
3351: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
3352: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 4026: IF NOT HZ_MATCH_RULE_53.check_staged THEN

4022: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
4023: p_restrict_sql,p_api_name,p_match_type,p_party_id,p_search_merged,x_search_ctx_id,x_num_matches);
4024: -- Code for Match rule CREDIT MANAGEMENT SEARCH
4025: ELSIF p_rule_id=53 THEN
4026: IF NOT HZ_MATCH_RULE_53.check_staged THEN
4027: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4028: FND_MSG_PUB.ADD;
4029: RAISE FND_API.G_EXC_ERROR;
4030: END IF;

Line 4031: HZ_MATCH_RULE_53.call_api_dynamic(

4027: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4028: FND_MSG_PUB.ADD;
4029: RAISE FND_API.G_EXC_ERROR;
4030: END IF;
4031: HZ_MATCH_RULE_53.call_api_dynamic(
4032: p_rule_id,
4033: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
4034: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
4035: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 4724: IF NOT HZ_MATCH_RULE_53.check_staged THEN

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
4724: IF NOT HZ_MATCH_RULE_53.check_staged THEN
4725: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4726: FND_MSG_PUB.ADD;
4727: RAISE FND_API.G_EXC_ERROR;
4728: END IF;

Line 4729: HZ_MATCH_RULE_53.get_matching_party_sites(

4725: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4726: FND_MSG_PUB.ADD;
4727: RAISE FND_API.G_EXC_ERROR;
4728: END IF;
4729: HZ_MATCH_RULE_53.get_matching_party_sites(
4730: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4731: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4732: -- Code for Match rule HZ_PERSON_SIMPLE_SEARCH_RULE
4733: ELSIF p_rule_id=58 THEN

Line 5143: IF NOT HZ_MATCH_RULE_53.check_staged THEN

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
5143: IF NOT HZ_MATCH_RULE_53.check_staged THEN
5144: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5145: FND_MSG_PUB.ADD;
5146: RAISE FND_API.G_EXC_ERROR;
5147: END IF;

Line 5148: HZ_MATCH_RULE_53.get_matching_contacts(

5144: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5145: FND_MSG_PUB.ADD;
5146: RAISE FND_API.G_EXC_ERROR;
5147: END IF;
5148: HZ_MATCH_RULE_53.get_matching_contacts(
5149: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
5150: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5151: -- Code for Match rule HZ_PERSON_SIMPLE_SEARCH_RULE
5152: ELSIF p_rule_id=58 THEN

Line 5560: IF NOT HZ_MATCH_RULE_53.check_staged THEN

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
5560: IF NOT HZ_MATCH_RULE_53.check_staged THEN
5561: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5562: FND_MSG_PUB.ADD;
5563: RAISE FND_API.G_EXC_ERROR;
5564: END IF;

Line 5565: HZ_MATCH_RULE_53.get_matching_contact_points(

5561: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5562: FND_MSG_PUB.ADD;
5563: RAISE FND_API.G_EXC_ERROR;
5564: END IF;
5565: HZ_MATCH_RULE_53.get_matching_contact_points(
5566: p_rule_id, p_party_id, p_contact_point_list,
5567: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5568: -- Code for Match rule HZ_PERSON_SIMPLE_SEARCH_RULE
5569: ELSIF p_rule_id=58 THEN

Line 6002: IF NOT HZ_MATCH_RULE_53.check_staged THEN

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
6001: ELSIF p_rule_id=53 THEN
6002: IF NOT HZ_MATCH_RULE_53.check_staged THEN
6003: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6004: FND_MSG_PUB.ADD;
6005: RAISE FND_API.G_EXC_ERROR;
6006: END IF;

Line 6007: HZ_MATCH_RULE_53.get_score_details(

6003: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6004: FND_MSG_PUB.ADD;
6005: RAISE FND_API.G_EXC_ERROR;
6006: END IF;
6007: HZ_MATCH_RULE_53.get_score_details(
6008: p_rule_id,
6009: p_party_id, p_party_search_rec,p_party_site_list,
6010: p_contact_list, p_contact_point_list,x_search_ctx_id);
6011: -- Code for Match rule HZ_PERSON_SIMPLE_SEARCH_RULE

Line 6400: IF NOT HZ_MATCH_RULE_53.check_staged THEN

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
6400: IF NOT HZ_MATCH_RULE_53.check_staged THEN
6401: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6402: FND_MSG_PUB.ADD;
6403: RAISE FND_API.G_EXC_ERROR;
6404: END IF;

Line 6405: HZ_MATCH_RULE_53.get_party_for_search(

6401: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6402: FND_MSG_PUB.ADD;
6403: RAISE FND_API.G_EXC_ERROR;
6404: END IF;
6405: HZ_MATCH_RULE_53.get_party_for_search(
6406: p_party_id, x_party_search_rec,x_party_site_list,
6407: x_contact_list, x_contact_point_list);
6408: -- Code for Match rule HZ_PERSON_SIMPLE_SEARCH_RULE
6409: ELSIF p_rule_id=58 THEN

Line 6792: IF NOT HZ_MATCH_RULE_53.check_staged THEN

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
6792: IF NOT HZ_MATCH_RULE_53.check_staged THEN
6793: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6794: FND_MSG_PUB.ADD;
6795: RAISE FND_API.G_EXC_ERROR;
6796: END IF;

Line 6797: HZ_MATCH_RULE_53.get_search_criteria(

6793: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6794: FND_MSG_PUB.ADD;
6795: RAISE FND_API.G_EXC_ERROR;
6796: END IF;
6797: HZ_MATCH_RULE_53.get_search_criteria(
6798: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6799: x_contact_list, x_contact_point_list);
6800: -- Code for Match rule HZ_PERSON_SIMPLE_SEARCH_RULE
6801: ELSIF p_rule_id=58 THEN