DBA Data[Home] [Help]

APPS.HZ_PARTY_SEARCH dependencies on HZ_MATCH_RULE_62

Line 370: IF NOT HZ_MATCH_RULE_62.check_staged THEN

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
370: IF NOT HZ_MATCH_RULE_62.check_staged THEN
371: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
372: FND_MSG_PUB.ADD;
373: RAISE FND_API.G_EXC_ERROR;
374: END IF;

Line 375: HZ_MATCH_RULE_62.find_parties(

371: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
372: FND_MSG_PUB.ADD;
373: RAISE FND_API.G_EXC_ERROR;
374: END IF;
375: HZ_MATCH_RULE_62.find_parties(
376: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
377: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,NULL,NULL,NULL,'N',x_search_ctx_id,x_num_matches);
378: -- Code for Match rule HZ_CONTACT_SIMPLE_SEARCH_RULE
379: ELSIF p_rule_id=98 THEN

Line 751: IF NOT HZ_MATCH_RULE_62.check_staged THEN

747: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
748: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,'N',x_search_ctx_id,x_num_matches);
749: -- Code for Match rule HZ_ORG_ADV_SEARCH_RULE
750: ELSIF p_rule_id=62 THEN
751: IF NOT HZ_MATCH_RULE_62.check_staged THEN
752: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
753: FND_MSG_PUB.ADD;
754: RAISE FND_API.G_EXC_ERROR;
755: END IF;

Line 756: HZ_MATCH_RULE_62.find_persons(

752: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
753: FND_MSG_PUB.ADD;
754: RAISE FND_API.G_EXC_ERROR;
755: END IF;
756: HZ_MATCH_RULE_62.find_persons(
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_CONTACT_SIMPLE_SEARCH_RULE
760: ELSIF p_rule_id=98 THEN

Line 1150: IF NOT HZ_MATCH_RULE_62.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 HZ_ORG_ADV_SEARCH_RULE
1149: ELSIF p_rule_id=62 THEN
1150: IF NOT HZ_MATCH_RULE_62.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_62.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_62.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_CONTACT_SIMPLE_SEARCH_RULE
1159: ELSIF p_rule_id=98 THEN

Line 1530: IF NOT HZ_MATCH_RULE_62.check_staged THEN

1526: p_rule_id,p_party_id,
1527: p_restrict_sql,p_match_type,p_dup_batch_id,p_search_merged,x_dup_set_id, x_search_ctx_id,x_num_matches);
1528: -- Code for Match rule HZ_ORG_ADV_SEARCH_RULE
1529: ELSIF p_rule_id=62 THEN
1530: IF NOT HZ_MATCH_RULE_62.check_staged THEN
1531: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1532: FND_MSG_PUB.ADD;
1533: RAISE FND_API.G_EXC_ERROR;
1534: END IF;

Line 1535: HZ_MATCH_RULE_62.find_duplicate_parties(

1531: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1532: FND_MSG_PUB.ADD;
1533: RAISE FND_API.G_EXC_ERROR;
1534: END IF;
1535: HZ_MATCH_RULE_62.find_duplicate_parties(
1536: p_rule_id,p_party_id,
1537: p_restrict_sql,p_match_type,p_dup_batch_id,p_search_merged,x_dup_set_id, x_search_ctx_id,x_num_matches);
1538: -- Code for Match rule HZ_CONTACT_SIMPLE_SEARCH_RULE
1539: ELSIF p_rule_id=98 THEN

Line 1905: IF NOT HZ_MATCH_RULE_62.check_staged THEN

1901: p_rule_id,p_party_site_id,p_party_id,
1902: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
1903: -- Code for Match rule HZ_ORG_ADV_SEARCH_RULE
1904: ELSIF p_rule_id=62 THEN
1905: IF NOT HZ_MATCH_RULE_62.check_staged THEN
1906: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1907: FND_MSG_PUB.ADD;
1908: RAISE FND_API.G_EXC_ERROR;
1909: END IF;

Line 1910: HZ_MATCH_RULE_62.find_duplicate_party_sites(

1906: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1907: FND_MSG_PUB.ADD;
1908: RAISE FND_API.G_EXC_ERROR;
1909: END IF;
1910: HZ_MATCH_RULE_62.find_duplicate_party_sites(
1911: p_rule_id,p_party_site_id,p_party_id,
1912: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
1913: -- Code for Match rule HZ_CONTACT_SIMPLE_SEARCH_RULE
1914: ELSIF p_rule_id=98 THEN

Line 2279: IF NOT HZ_MATCH_RULE_62.check_staged THEN

2275: p_rule_id,p_org_contact_id,p_party_id,
2276: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2277: -- Code for Match rule HZ_ORG_ADV_SEARCH_RULE
2278: ELSIF p_rule_id=62 THEN
2279: IF NOT HZ_MATCH_RULE_62.check_staged THEN
2280: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2281: FND_MSG_PUB.ADD;
2282: RAISE FND_API.G_EXC_ERROR;
2283: END IF;

Line 2284: HZ_MATCH_RULE_62.find_duplicate_contacts(

2280: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2281: FND_MSG_PUB.ADD;
2282: RAISE FND_API.G_EXC_ERROR;
2283: END IF;
2284: HZ_MATCH_RULE_62.find_duplicate_contacts(
2285: p_rule_id,p_org_contact_id,p_party_id,
2286: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2287: -- Code for Match rule HZ_CONTACT_SIMPLE_SEARCH_RULE
2288: ELSIF p_rule_id=98 THEN

Line 2653: IF NOT HZ_MATCH_RULE_62.check_staged THEN

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 HZ_ORG_ADV_SEARCH_RULE
2652: ELSIF p_rule_id=62 THEN
2653: IF NOT HZ_MATCH_RULE_62.check_staged THEN
2654: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2655: FND_MSG_PUB.ADD;
2656: RAISE FND_API.G_EXC_ERROR;
2657: END IF;

Line 2658: HZ_MATCH_RULE_62.find_duplicate_contact_points(

2654: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2655: FND_MSG_PUB.ADD;
2656: RAISE FND_API.G_EXC_ERROR;
2657: END IF;
2658: HZ_MATCH_RULE_62.find_duplicate_contact_points(
2659: p_rule_id,p_contact_point_id,p_party_id,
2660: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2661: -- Code for Match rule HZ_CONTACT_SIMPLE_SEARCH_RULE
2662: ELSIF p_rule_id=98 THEN

Line 3275: IF NOT HZ_MATCH_RULE_62.check_staged THEN

3271: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3272: p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
3273: -- Code for Match rule HZ_ORG_ADV_SEARCH_RULE
3274: ELSIF p_rule_id=62 THEN
3275: IF NOT HZ_MATCH_RULE_62.check_staged THEN
3276: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3277: FND_MSG_PUB.ADD;
3278: RAISE FND_API.G_EXC_ERROR;
3279: END IF;

Line 3280: HZ_MATCH_RULE_62.find_parties_dynamic(

3276: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3277: FND_MSG_PUB.ADD;
3278: RAISE FND_API.G_EXC_ERROR;
3279: END IF;
3280: HZ_MATCH_RULE_62.find_parties_dynamic(
3281: p_rule_id,
3282: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
3283: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
3284: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 3922: IF NOT HZ_MATCH_RULE_62.check_staged THEN

3918: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3919: p_restrict_sql,p_api_name,p_match_type,p_party_id,p_search_merged,x_search_ctx_id,x_num_matches);
3920: -- Code for Match rule HZ_ORG_ADV_SEARCH_RULE
3921: ELSIF p_rule_id=62 THEN
3922: IF NOT HZ_MATCH_RULE_62.check_staged THEN
3923: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3924: FND_MSG_PUB.ADD;
3925: RAISE FND_API.G_EXC_ERROR;
3926: END IF;

Line 3927: HZ_MATCH_RULE_62.call_api_dynamic(

3923: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3924: FND_MSG_PUB.ADD;
3925: RAISE FND_API.G_EXC_ERROR;
3926: END IF;
3927: HZ_MATCH_RULE_62.call_api_dynamic(
3928: p_rule_id,
3929: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
3930: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
3931: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 4552: IF NOT HZ_MATCH_RULE_62.check_staged THEN

4548: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4549: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4550: -- Code for Match rule HZ_ORG_ADV_SEARCH_RULE
4551: ELSIF p_rule_id=62 THEN
4552: IF NOT HZ_MATCH_RULE_62.check_staged THEN
4553: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4554: FND_MSG_PUB.ADD;
4555: RAISE FND_API.G_EXC_ERROR;
4556: END IF;

Line 4557: HZ_MATCH_RULE_62.get_matching_party_sites(

4553: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4554: FND_MSG_PUB.ADD;
4555: RAISE FND_API.G_EXC_ERROR;
4556: END IF;
4557: HZ_MATCH_RULE_62.get_matching_party_sites(
4558: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4559: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4560: -- Code for Match rule HZ_CONTACT_SIMPLE_SEARCH_RULE
4561: ELSIF p_rule_id=98 THEN

Line 4951: IF NOT HZ_MATCH_RULE_62.check_staged THEN

4947: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
4948: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4949: -- Code for Match rule HZ_ORG_ADV_SEARCH_RULE
4950: ELSIF p_rule_id=62 THEN
4951: IF NOT HZ_MATCH_RULE_62.check_staged THEN
4952: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4953: FND_MSG_PUB.ADD;
4954: RAISE FND_API.G_EXC_ERROR;
4955: END IF;

Line 4956: HZ_MATCH_RULE_62.get_matching_contacts(

4952: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4953: FND_MSG_PUB.ADD;
4954: RAISE FND_API.G_EXC_ERROR;
4955: END IF;
4956: HZ_MATCH_RULE_62.get_matching_contacts(
4957: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
4958: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4959: -- Code for Match rule HZ_CONTACT_SIMPLE_SEARCH_RULE
4960: ELSIF p_rule_id=98 THEN

Line 5348: IF NOT HZ_MATCH_RULE_62.check_staged THEN

5344: p_rule_id, p_party_id, p_contact_point_list,
5345: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5346: -- Code for Match rule HZ_ORG_ADV_SEARCH_RULE
5347: ELSIF p_rule_id=62 THEN
5348: IF NOT HZ_MATCH_RULE_62.check_staged THEN
5349: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5350: FND_MSG_PUB.ADD;
5351: RAISE FND_API.G_EXC_ERROR;
5352: END IF;

Line 5353: HZ_MATCH_RULE_62.get_matching_contact_points(

5349: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5350: FND_MSG_PUB.ADD;
5351: RAISE FND_API.G_EXC_ERROR;
5352: END IF;
5353: HZ_MATCH_RULE_62.get_matching_contact_points(
5354: p_rule_id, p_party_id, p_contact_point_list,
5355: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5356: -- Code for Match rule HZ_CONTACT_SIMPLE_SEARCH_RULE
5357: ELSIF p_rule_id=98 THEN

Line 5774: IF NOT HZ_MATCH_RULE_62.check_staged THEN

5770: p_party_id, p_party_search_rec,p_party_site_list,
5771: p_contact_list, p_contact_point_list,x_search_ctx_id);
5772: -- Code for Match rule HZ_ORG_ADV_SEARCH_RULE
5773: ELSIF p_rule_id=62 THEN
5774: IF NOT HZ_MATCH_RULE_62.check_staged THEN
5775: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5776: FND_MSG_PUB.ADD;
5777: RAISE FND_API.G_EXC_ERROR;
5778: END IF;

Line 5779: HZ_MATCH_RULE_62.get_score_details(

5775: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5776: FND_MSG_PUB.ADD;
5777: RAISE FND_API.G_EXC_ERROR;
5778: END IF;
5779: HZ_MATCH_RULE_62.get_score_details(
5780: p_rule_id,
5781: p_party_id, p_party_search_rec,p_party_site_list,
5782: p_contact_list, p_contact_point_list,x_search_ctx_id);
5783: -- Code for Match rule HZ_CONTACT_SIMPLE_SEARCH_RULE

Line 6146: IF NOT HZ_MATCH_RULE_62.check_staged THEN

6142: p_party_id, x_party_search_rec,x_party_site_list,
6143: x_contact_list, x_contact_point_list);
6144: -- Code for Match rule HZ_ORG_ADV_SEARCH_RULE
6145: ELSIF p_rule_id=62 THEN
6146: IF NOT HZ_MATCH_RULE_62.check_staged THEN
6147: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6148: FND_MSG_PUB.ADD;
6149: RAISE FND_API.G_EXC_ERROR;
6150: END IF;

Line 6151: HZ_MATCH_RULE_62.get_party_for_search(

6147: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6148: FND_MSG_PUB.ADD;
6149: RAISE FND_API.G_EXC_ERROR;
6150: END IF;
6151: HZ_MATCH_RULE_62.get_party_for_search(
6152: p_party_id, x_party_search_rec,x_party_site_list,
6153: x_contact_list, x_contact_point_list);
6154: -- Code for Match rule HZ_CONTACT_SIMPLE_SEARCH_RULE
6155: ELSIF p_rule_id=98 THEN

Line 6518: IF NOT HZ_MATCH_RULE_62.check_staged THEN

6514: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6515: x_contact_list, x_contact_point_list);
6516: -- Code for Match rule HZ_ORG_ADV_SEARCH_RULE
6517: ELSIF p_rule_id=62 THEN
6518: IF NOT HZ_MATCH_RULE_62.check_staged THEN
6519: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6520: FND_MSG_PUB.ADD;
6521: RAISE FND_API.G_EXC_ERROR;
6522: END IF;

Line 6523: HZ_MATCH_RULE_62.get_search_criteria(

6519: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6520: FND_MSG_PUB.ADD;
6521: RAISE FND_API.G_EXC_ERROR;
6522: END IF;
6523: HZ_MATCH_RULE_62.get_search_criteria(
6524: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6525: x_contact_list, x_contact_point_list);
6526: -- Code for Match rule HZ_CONTACT_SIMPLE_SEARCH_RULE
6527: ELSIF p_rule_id=98 THEN