DBA Data[Home] [Help]

APPS.HZ_PARTY_SEARCH dependencies on HZ_MATCH_RULE_61

Line 360: IF NOT HZ_MATCH_RULE_61.check_staged THEN

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
360: IF NOT HZ_MATCH_RULE_61.check_staged THEN
361: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
362: FND_MSG_PUB.ADD;
363: RAISE FND_API.G_EXC_ERROR;
364: END IF;

Line 365: HZ_MATCH_RULE_61.find_parties(

361: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
362: FND_MSG_PUB.ADD;
363: RAISE FND_API.G_EXC_ERROR;
364: END IF;
365: HZ_MATCH_RULE_61.find_parties(
366: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
367: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,NULL,NULL,NULL,'N',x_search_ctx_id,x_num_matches);
368: -- Code for Match rule HZ_ORG_ADV_SEARCH_RULE
369: ELSIF p_rule_id=62 THEN

Line 761: IF NOT HZ_MATCH_RULE_61.check_staged THEN

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
761: IF NOT HZ_MATCH_RULE_61.check_staged THEN
762: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
763: FND_MSG_PUB.ADD;
764: RAISE FND_API.G_EXC_ERROR;
765: END IF;

Line 766: HZ_MATCH_RULE_61.find_persons(

762: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
763: FND_MSG_PUB.ADD;
764: RAISE FND_API.G_EXC_ERROR;
765: END IF;
766: HZ_MATCH_RULE_61.find_persons(
767: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
768: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,'N',x_search_ctx_id,x_num_matches);
769: -- Code for Match rule HZ_ORG_ADV_SEARCH_RULE
770: ELSIF p_rule_id=62 THEN

Line 1180: IF NOT HZ_MATCH_RULE_61.check_staged THEN

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
1180: IF NOT HZ_MATCH_RULE_61.check_staged THEN
1181: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1182: FND_MSG_PUB.ADD;
1183: RAISE FND_API.G_EXC_ERROR;
1184: END IF;

Line 1185: HZ_MATCH_RULE_61.find_party_details(

1181: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1182: FND_MSG_PUB.ADD;
1183: RAISE FND_API.G_EXC_ERROR;
1184: END IF;
1185: HZ_MATCH_RULE_61.find_party_details(
1186: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
1187: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
1188: -- Code for Match rule HZ_ORG_ADV_SEARCH_RULE
1189: ELSIF p_rule_id=62 THEN

Line 1580: IF NOT HZ_MATCH_RULE_61.check_staged THEN

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
1580: IF NOT HZ_MATCH_RULE_61.check_staged THEN
1581: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1582: FND_MSG_PUB.ADD;
1583: RAISE FND_API.G_EXC_ERROR;
1584: END IF;

Line 1585: HZ_MATCH_RULE_61.find_duplicate_parties(

1581: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1582: FND_MSG_PUB.ADD;
1583: RAISE FND_API.G_EXC_ERROR;
1584: END IF;
1585: HZ_MATCH_RULE_61.find_duplicate_parties(
1586: p_rule_id,p_party_id,
1587: p_restrict_sql,p_match_type,p_dup_batch_id,p_search_merged,x_dup_set_id, x_search_ctx_id,x_num_matches);
1588: -- Code for Match rule HZ_ORG_ADV_SEARCH_RULE
1589: ELSIF p_rule_id=62 THEN

Line 1975: IF NOT HZ_MATCH_RULE_61.check_staged THEN

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
1975: IF NOT HZ_MATCH_RULE_61.check_staged THEN
1976: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1977: FND_MSG_PUB.ADD;
1978: RAISE FND_API.G_EXC_ERROR;
1979: END IF;

Line 1980: HZ_MATCH_RULE_61.find_duplicate_party_sites(

1976: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1977: FND_MSG_PUB.ADD;
1978: RAISE FND_API.G_EXC_ERROR;
1979: END IF;
1980: HZ_MATCH_RULE_61.find_duplicate_party_sites(
1981: p_rule_id,p_party_site_id,p_party_id,
1982: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
1983: -- Code for Match rule HZ_ORG_ADV_SEARCH_RULE
1984: ELSIF p_rule_id=62 THEN

Line 2369: IF NOT HZ_MATCH_RULE_61.check_staged THEN

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
2369: IF NOT HZ_MATCH_RULE_61.check_staged THEN
2370: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2371: FND_MSG_PUB.ADD;
2372: RAISE FND_API.G_EXC_ERROR;
2373: END IF;

Line 2374: HZ_MATCH_RULE_61.find_duplicate_contacts(

2370: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2371: FND_MSG_PUB.ADD;
2372: RAISE FND_API.G_EXC_ERROR;
2373: END IF;
2374: HZ_MATCH_RULE_61.find_duplicate_contacts(
2375: p_rule_id,p_org_contact_id,p_party_id,
2376: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2377: -- Code for Match rule HZ_ORG_ADV_SEARCH_RULE
2378: ELSIF p_rule_id=62 THEN

Line 2763: IF NOT HZ_MATCH_RULE_61.check_staged THEN

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
2763: IF NOT HZ_MATCH_RULE_61.check_staged THEN
2764: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2765: FND_MSG_PUB.ADD;
2766: RAISE FND_API.G_EXC_ERROR;
2767: END IF;

Line 2768: HZ_MATCH_RULE_61.find_duplicate_contact_points(

2764: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2765: FND_MSG_PUB.ADD;
2766: RAISE FND_API.G_EXC_ERROR;
2767: END IF;
2768: HZ_MATCH_RULE_61.find_duplicate_contact_points(
2769: p_rule_id,p_contact_point_id,p_party_id,
2770: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2771: -- Code for Match rule HZ_ORG_ADV_SEARCH_RULE
2772: ELSIF p_rule_id=62 THEN

Line 3397: IF NOT HZ_MATCH_RULE_61.check_staged THEN

3393: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3394: p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
3395: -- Code for Match rule HZ_ORG_SIMPLE_SEARCH_RULE
3396: ELSIF p_rule_id=61 THEN
3397: IF NOT HZ_MATCH_RULE_61.check_staged THEN
3398: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3399: FND_MSG_PUB.ADD;
3400: RAISE FND_API.G_EXC_ERROR;
3401: END IF;

Line 3402: HZ_MATCH_RULE_61.find_parties_dynamic(

3398: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3399: FND_MSG_PUB.ADD;
3400: RAISE FND_API.G_EXC_ERROR;
3401: END IF;
3402: HZ_MATCH_RULE_61.find_parties_dynamic(
3403: p_rule_id,
3404: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
3405: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
3406: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 4080: IF NOT HZ_MATCH_RULE_61.check_staged THEN

4076: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
4077: p_restrict_sql,p_api_name,p_match_type,p_party_id,p_search_merged,x_search_ctx_id,x_num_matches);
4078: -- Code for Match rule HZ_ORG_SIMPLE_SEARCH_RULE
4079: ELSIF p_rule_id=61 THEN
4080: IF NOT HZ_MATCH_RULE_61.check_staged THEN
4081: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4082: FND_MSG_PUB.ADD;
4083: RAISE FND_API.G_EXC_ERROR;
4084: END IF;

Line 4085: HZ_MATCH_RULE_61.call_api_dynamic(

4081: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4082: FND_MSG_PUB.ADD;
4083: RAISE FND_API.G_EXC_ERROR;
4084: END IF;
4085: HZ_MATCH_RULE_61.call_api_dynamic(
4086: p_rule_id,
4087: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
4088: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
4089: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 4754: IF NOT HZ_MATCH_RULE_61.check_staged THEN

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
4754: IF NOT HZ_MATCH_RULE_61.check_staged THEN
4755: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4756: FND_MSG_PUB.ADD;
4757: RAISE FND_API.G_EXC_ERROR;
4758: END IF;

Line 4759: HZ_MATCH_RULE_61.get_matching_party_sites(

4755: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4756: FND_MSG_PUB.ADD;
4757: RAISE FND_API.G_EXC_ERROR;
4758: END IF;
4759: HZ_MATCH_RULE_61.get_matching_party_sites(
4760: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4761: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4762: -- Code for Match rule HZ_ORG_ADV_SEARCH_RULE
4763: ELSIF p_rule_id=62 THEN

Line 5173: IF NOT HZ_MATCH_RULE_61.check_staged THEN

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
5173: IF NOT HZ_MATCH_RULE_61.check_staged THEN
5174: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5175: FND_MSG_PUB.ADD;
5176: RAISE FND_API.G_EXC_ERROR;
5177: END IF;

Line 5178: HZ_MATCH_RULE_61.get_matching_contacts(

5174: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5175: FND_MSG_PUB.ADD;
5176: RAISE FND_API.G_EXC_ERROR;
5177: END IF;
5178: HZ_MATCH_RULE_61.get_matching_contacts(
5179: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
5180: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5181: -- Code for Match rule HZ_ORG_ADV_SEARCH_RULE
5182: ELSIF p_rule_id=62 THEN

Line 5590: IF NOT HZ_MATCH_RULE_61.check_staged THEN

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
5590: IF NOT HZ_MATCH_RULE_61.check_staged THEN
5591: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5592: FND_MSG_PUB.ADD;
5593: RAISE FND_API.G_EXC_ERROR;
5594: END IF;

Line 5595: HZ_MATCH_RULE_61.get_matching_contact_points(

5591: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5592: FND_MSG_PUB.ADD;
5593: RAISE FND_API.G_EXC_ERROR;
5594: END IF;
5595: HZ_MATCH_RULE_61.get_matching_contact_points(
5596: p_rule_id, p_party_id, p_contact_point_list,
5597: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5598: -- Code for Match rule HZ_ORG_ADV_SEARCH_RULE
5599: ELSIF p_rule_id=62 THEN

Line 6035: IF NOT HZ_MATCH_RULE_61.check_staged THEN

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
6034: ELSIF p_rule_id=61 THEN
6035: IF NOT HZ_MATCH_RULE_61.check_staged THEN
6036: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6037: FND_MSG_PUB.ADD;
6038: RAISE FND_API.G_EXC_ERROR;
6039: END IF;

Line 6040: HZ_MATCH_RULE_61.get_score_details(

6036: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6037: FND_MSG_PUB.ADD;
6038: RAISE FND_API.G_EXC_ERROR;
6039: END IF;
6040: HZ_MATCH_RULE_61.get_score_details(
6041: p_rule_id,
6042: p_party_id, p_party_search_rec,p_party_site_list,
6043: p_contact_list, p_contact_point_list,x_search_ctx_id);
6044: -- Code for Match rule HZ_ORG_ADV_SEARCH_RULE

Line 6430: IF NOT HZ_MATCH_RULE_61.check_staged THEN

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
6430: IF NOT HZ_MATCH_RULE_61.check_staged THEN
6431: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6432: FND_MSG_PUB.ADD;
6433: RAISE FND_API.G_EXC_ERROR;
6434: END IF;

Line 6435: HZ_MATCH_RULE_61.get_party_for_search(

6431: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6432: FND_MSG_PUB.ADD;
6433: RAISE FND_API.G_EXC_ERROR;
6434: END IF;
6435: HZ_MATCH_RULE_61.get_party_for_search(
6436: p_party_id, x_party_search_rec,x_party_site_list,
6437: x_contact_list, x_contact_point_list);
6438: -- Code for Match rule HZ_ORG_ADV_SEARCH_RULE
6439: ELSIF p_rule_id=62 THEN

Line 6822: IF NOT HZ_MATCH_RULE_61.check_staged THEN

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
6822: IF NOT HZ_MATCH_RULE_61.check_staged THEN
6823: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6824: FND_MSG_PUB.ADD;
6825: RAISE FND_API.G_EXC_ERROR;
6826: END IF;

Line 6827: HZ_MATCH_RULE_61.get_search_criteria(

6823: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6824: FND_MSG_PUB.ADD;
6825: RAISE FND_API.G_EXC_ERROR;
6826: END IF;
6827: HZ_MATCH_RULE_61.get_search_criteria(
6828: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6829: x_contact_list, x_contact_point_list);
6830: -- Code for Match rule HZ_ORG_ADV_SEARCH_RULE
6831: ELSIF p_rule_id=62 THEN