DBA Data[Home] [Help]

APPS.HZ_PARTY_SEARCH dependencies on HZ_MATCH_RULE_33

Line 190: IF NOT HZ_MATCH_RULE_33.check_staged THEN

186: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
187: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,NULL,NULL,NULL,'N',x_search_ctx_id,x_num_matches);
188: -- Code for Match rule SAMPLE:BASIC SEARCH RULE
189: ELSIF p_rule_id=33 THEN
190: IF NOT HZ_MATCH_RULE_33.check_staged THEN
191: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
192: FND_MSG_PUB.ADD;
193: RAISE FND_API.G_EXC_ERROR;
194: END IF;

Line 195: HZ_MATCH_RULE_33.find_parties(

191: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
192: FND_MSG_PUB.ADD;
193: RAISE FND_API.G_EXC_ERROR;
194: END IF;
195: HZ_MATCH_RULE_33.find_parties(
196: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
197: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,NULL,NULL,NULL,'N',x_search_ctx_id,x_num_matches);
198: -- Code for Match rule SAMPLE:ADVANCED SEARCH RULE
199: ELSIF p_rule_id=34 THEN

Line 571: IF NOT HZ_MATCH_RULE_33.check_staged THEN

567: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
568: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,'N',x_search_ctx_id,x_num_matches);
569: -- Code for Match rule SAMPLE:BASIC SEARCH RULE
570: ELSIF p_rule_id=33 THEN
571: IF NOT HZ_MATCH_RULE_33.check_staged THEN
572: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
573: FND_MSG_PUB.ADD;
574: RAISE FND_API.G_EXC_ERROR;
575: END IF;

Line 576: HZ_MATCH_RULE_33.find_persons(

572: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
573: FND_MSG_PUB.ADD;
574: RAISE FND_API.G_EXC_ERROR;
575: END IF;
576: HZ_MATCH_RULE_33.find_persons(
577: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
578: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,'N',x_search_ctx_id,x_num_matches);
579: -- Code for Match rule SAMPLE:ADVANCED SEARCH RULE
580: ELSIF p_rule_id=34 THEN

Line 970: IF NOT HZ_MATCH_RULE_33.check_staged THEN

966: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
967: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
968: -- Code for Match rule SAMPLE:BASIC SEARCH RULE
969: ELSIF p_rule_id=33 THEN
970: IF NOT HZ_MATCH_RULE_33.check_staged THEN
971: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
972: FND_MSG_PUB.ADD;
973: RAISE FND_API.G_EXC_ERROR;
974: END IF;

Line 975: HZ_MATCH_RULE_33.find_party_details(

971: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
972: FND_MSG_PUB.ADD;
973: RAISE FND_API.G_EXC_ERROR;
974: END IF;
975: HZ_MATCH_RULE_33.find_party_details(
976: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
977: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
978: -- Code for Match rule SAMPLE:ADVANCED SEARCH RULE
979: ELSIF p_rule_id=34 THEN

Line 1350: IF NOT HZ_MATCH_RULE_33.check_staged THEN

1346: p_rule_id,p_party_id,
1347: p_restrict_sql,p_match_type,p_dup_batch_id,p_search_merged,x_dup_set_id, x_search_ctx_id,x_num_matches);
1348: -- Code for Match rule SAMPLE:BASIC SEARCH RULE
1349: ELSIF p_rule_id=33 THEN
1350: IF NOT HZ_MATCH_RULE_33.check_staged THEN
1351: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1352: FND_MSG_PUB.ADD;
1353: RAISE FND_API.G_EXC_ERROR;
1354: END IF;

Line 1355: HZ_MATCH_RULE_33.find_duplicate_parties(

1351: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1352: FND_MSG_PUB.ADD;
1353: RAISE FND_API.G_EXC_ERROR;
1354: END IF;
1355: HZ_MATCH_RULE_33.find_duplicate_parties(
1356: p_rule_id,p_party_id,
1357: p_restrict_sql,p_match_type,p_dup_batch_id,p_search_merged,x_dup_set_id, x_search_ctx_id,x_num_matches);
1358: -- Code for Match rule SAMPLE:ADVANCED SEARCH RULE
1359: ELSIF p_rule_id=34 THEN

Line 1725: IF NOT HZ_MATCH_RULE_33.check_staged THEN

1721: p_rule_id,p_party_site_id,p_party_id,
1722: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
1723: -- Code for Match rule SAMPLE:BASIC SEARCH RULE
1724: ELSIF p_rule_id=33 THEN
1725: IF NOT HZ_MATCH_RULE_33.check_staged THEN
1726: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1727: FND_MSG_PUB.ADD;
1728: RAISE FND_API.G_EXC_ERROR;
1729: END IF;

Line 1730: HZ_MATCH_RULE_33.find_duplicate_party_sites(

1726: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1727: FND_MSG_PUB.ADD;
1728: RAISE FND_API.G_EXC_ERROR;
1729: END IF;
1730: HZ_MATCH_RULE_33.find_duplicate_party_sites(
1731: p_rule_id,p_party_site_id,p_party_id,
1732: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
1733: -- Code for Match rule SAMPLE:ADVANCED SEARCH RULE
1734: ELSIF p_rule_id=34 THEN

Line 2099: IF NOT HZ_MATCH_RULE_33.check_staged THEN

2095: p_rule_id,p_org_contact_id,p_party_id,
2096: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2097: -- Code for Match rule SAMPLE:BASIC SEARCH RULE
2098: ELSIF p_rule_id=33 THEN
2099: IF NOT HZ_MATCH_RULE_33.check_staged THEN
2100: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2101: FND_MSG_PUB.ADD;
2102: RAISE FND_API.G_EXC_ERROR;
2103: END IF;

Line 2104: HZ_MATCH_RULE_33.find_duplicate_contacts(

2100: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2101: FND_MSG_PUB.ADD;
2102: RAISE FND_API.G_EXC_ERROR;
2103: END IF;
2104: HZ_MATCH_RULE_33.find_duplicate_contacts(
2105: p_rule_id,p_org_contact_id,p_party_id,
2106: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2107: -- Code for Match rule SAMPLE:ADVANCED SEARCH RULE
2108: ELSIF p_rule_id=34 THEN

Line 2473: IF NOT HZ_MATCH_RULE_33.check_staged THEN

2469: p_rule_id,p_contact_point_id,p_party_id,
2470: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2471: -- Code for Match rule SAMPLE:BASIC SEARCH RULE
2472: ELSIF p_rule_id=33 THEN
2473: IF NOT HZ_MATCH_RULE_33.check_staged THEN
2474: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2475: FND_MSG_PUB.ADD;
2476: RAISE FND_API.G_EXC_ERROR;
2477: END IF;

Line 2478: HZ_MATCH_RULE_33.find_duplicate_contact_points(

2474: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2475: FND_MSG_PUB.ADD;
2476: RAISE FND_API.G_EXC_ERROR;
2477: END IF;
2478: HZ_MATCH_RULE_33.find_duplicate_contact_points(
2479: p_rule_id,p_contact_point_id,p_party_id,
2480: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2481: -- Code for Match rule SAMPLE:ADVANCED SEARCH RULE
2482: ELSIF p_rule_id=34 THEN

Line 2951: IF NOT HZ_MATCH_RULE_33.check_staged THEN

2947: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
2948: p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
2949: -- Code for Match rule SAMPLE:BASIC SEARCH RULE
2950: ELSIF p_rule_id=33 THEN
2951: IF NOT HZ_MATCH_RULE_33.check_staged THEN
2952: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2953: FND_MSG_PUB.ADD;
2954: RAISE FND_API.G_EXC_ERROR;
2955: END IF;

Line 2956: HZ_MATCH_RULE_33.find_parties_dynamic(

2952: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2953: FND_MSG_PUB.ADD;
2954: RAISE FND_API.G_EXC_ERROR;
2955: END IF;
2956: HZ_MATCH_RULE_33.find_parties_dynamic(
2957: p_rule_id,
2958: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
2959: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
2960: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 3598: IF NOT HZ_MATCH_RULE_33.check_staged THEN

3594: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3595: p_restrict_sql,p_api_name,p_match_type,p_party_id,p_search_merged,x_search_ctx_id,x_num_matches);
3596: -- Code for Match rule SAMPLE:BASIC SEARCH RULE
3597: ELSIF p_rule_id=33 THEN
3598: IF NOT HZ_MATCH_RULE_33.check_staged THEN
3599: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3600: FND_MSG_PUB.ADD;
3601: RAISE FND_API.G_EXC_ERROR;
3602: END IF;

Line 3603: HZ_MATCH_RULE_33.call_api_dynamic(

3599: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3600: FND_MSG_PUB.ADD;
3601: RAISE FND_API.G_EXC_ERROR;
3602: END IF;
3603: HZ_MATCH_RULE_33.call_api_dynamic(
3604: p_rule_id,
3605: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
3606: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
3607: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 4372: IF NOT HZ_MATCH_RULE_33.check_staged THEN

4368: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4369: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4370: -- Code for Match rule SAMPLE:BASIC SEARCH RULE
4371: ELSIF p_rule_id=33 THEN
4372: IF NOT HZ_MATCH_RULE_33.check_staged THEN
4373: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4374: FND_MSG_PUB.ADD;
4375: RAISE FND_API.G_EXC_ERROR;
4376: END IF;

Line 4377: HZ_MATCH_RULE_33.get_matching_party_sites(

4373: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4374: FND_MSG_PUB.ADD;
4375: RAISE FND_API.G_EXC_ERROR;
4376: END IF;
4377: HZ_MATCH_RULE_33.get_matching_party_sites(
4378: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4379: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4380: -- Code for Match rule SAMPLE:ADVANCED SEARCH RULE
4381: ELSIF p_rule_id=34 THEN

Line 4771: IF NOT HZ_MATCH_RULE_33.check_staged THEN

4767: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
4768: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4769: -- Code for Match rule SAMPLE:BASIC SEARCH RULE
4770: ELSIF p_rule_id=33 THEN
4771: IF NOT HZ_MATCH_RULE_33.check_staged THEN
4772: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4773: FND_MSG_PUB.ADD;
4774: RAISE FND_API.G_EXC_ERROR;
4775: END IF;

Line 4776: HZ_MATCH_RULE_33.get_matching_contacts(

4772: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4773: FND_MSG_PUB.ADD;
4774: RAISE FND_API.G_EXC_ERROR;
4775: END IF;
4776: HZ_MATCH_RULE_33.get_matching_contacts(
4777: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
4778: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4779: -- Code for Match rule SAMPLE:ADVANCED SEARCH RULE
4780: ELSIF p_rule_id=34 THEN

Line 5168: IF NOT HZ_MATCH_RULE_33.check_staged THEN

5164: p_rule_id, p_party_id, p_contact_point_list,
5165: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5166: -- Code for Match rule SAMPLE:BASIC SEARCH RULE
5167: ELSIF p_rule_id=33 THEN
5168: IF NOT HZ_MATCH_RULE_33.check_staged THEN
5169: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5170: FND_MSG_PUB.ADD;
5171: RAISE FND_API.G_EXC_ERROR;
5172: END IF;

Line 5173: HZ_MATCH_RULE_33.get_matching_contact_points(

5169: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5170: FND_MSG_PUB.ADD;
5171: RAISE FND_API.G_EXC_ERROR;
5172: END IF;
5173: HZ_MATCH_RULE_33.get_matching_contact_points(
5174: p_rule_id, p_party_id, p_contact_point_list,
5175: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5176: -- Code for Match rule SAMPLE:ADVANCED SEARCH RULE
5177: ELSIF p_rule_id=34 THEN

Line 5576: IF NOT HZ_MATCH_RULE_33.check_staged THEN

5572: p_party_id, p_party_search_rec,p_party_site_list,
5573: p_contact_list, p_contact_point_list,x_search_ctx_id);
5574: -- Code for Match rule SAMPLE:BASIC SEARCH RULE
5575: ELSIF p_rule_id=33 THEN
5576: IF NOT HZ_MATCH_RULE_33.check_staged THEN
5577: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5578: FND_MSG_PUB.ADD;
5579: RAISE FND_API.G_EXC_ERROR;
5580: END IF;

Line 5581: HZ_MATCH_RULE_33.get_score_details(

5577: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5578: FND_MSG_PUB.ADD;
5579: RAISE FND_API.G_EXC_ERROR;
5580: END IF;
5581: HZ_MATCH_RULE_33.get_score_details(
5582: p_rule_id,
5583: p_party_id, p_party_search_rec,p_party_site_list,
5584: p_contact_list, p_contact_point_list,x_search_ctx_id);
5585: -- Code for Match rule SAMPLE:ADVANCED SEARCH RULE

Line 5966: IF NOT HZ_MATCH_RULE_33.check_staged THEN

5962: p_party_id, x_party_search_rec,x_party_site_list,
5963: x_contact_list, x_contact_point_list);
5964: -- Code for Match rule SAMPLE:BASIC SEARCH RULE
5965: ELSIF p_rule_id=33 THEN
5966: IF NOT HZ_MATCH_RULE_33.check_staged THEN
5967: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5968: FND_MSG_PUB.ADD;
5969: RAISE FND_API.G_EXC_ERROR;
5970: END IF;

Line 5971: HZ_MATCH_RULE_33.get_party_for_search(

5967: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5968: FND_MSG_PUB.ADD;
5969: RAISE FND_API.G_EXC_ERROR;
5970: END IF;
5971: HZ_MATCH_RULE_33.get_party_for_search(
5972: p_party_id, x_party_search_rec,x_party_site_list,
5973: x_contact_list, x_contact_point_list);
5974: -- Code for Match rule SAMPLE:ADVANCED SEARCH RULE
5975: ELSIF p_rule_id=34 THEN

Line 6338: IF NOT HZ_MATCH_RULE_33.check_staged THEN

6334: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6335: x_contact_list, x_contact_point_list);
6336: -- Code for Match rule SAMPLE:BASIC SEARCH RULE
6337: ELSIF p_rule_id=33 THEN
6338: IF NOT HZ_MATCH_RULE_33.check_staged THEN
6339: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6340: FND_MSG_PUB.ADD;
6341: RAISE FND_API.G_EXC_ERROR;
6342: END IF;

Line 6343: HZ_MATCH_RULE_33.get_search_criteria(

6339: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6340: FND_MSG_PUB.ADD;
6341: RAISE FND_API.G_EXC_ERROR;
6342: END IF;
6343: HZ_MATCH_RULE_33.get_search_criteria(
6344: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6345: x_contact_list, x_contact_point_list);
6346: -- Code for Match rule SAMPLE:ADVANCED SEARCH RULE
6347: ELSIF p_rule_id=34 THEN