DBA Data[Home] [Help]

APPS.HZ_PARTY_SEARCH dependencies on HZ_MATCH_RULE_32

Line 180: IF NOT HZ_MATCH_RULE_32.check_staged THEN

176: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
177: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,NULL,NULL,NULL,'N',x_search_ctx_id,x_num_matches);
178: -- Code for Match rule RM SEARCH RULE
179: ELSIF p_rule_id=32 THEN
180: IF NOT HZ_MATCH_RULE_32.check_staged THEN
181: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
182: FND_MSG_PUB.ADD;
183: RAISE FND_API.G_EXC_ERROR;
184: END IF;

Line 185: HZ_MATCH_RULE_32.find_parties(

181: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
182: FND_MSG_PUB.ADD;
183: RAISE FND_API.G_EXC_ERROR;
184: END IF;
185: HZ_MATCH_RULE_32.find_parties(
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

Line 581: IF NOT HZ_MATCH_RULE_32.check_staged THEN

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 RM SEARCH RULE
580: ELSIF p_rule_id=32 THEN
581: IF NOT HZ_MATCH_RULE_32.check_staged THEN
582: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
583: FND_MSG_PUB.ADD;
584: RAISE FND_API.G_EXC_ERROR;
585: END IF;

Line 586: HZ_MATCH_RULE_32.find_persons(

582: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
583: FND_MSG_PUB.ADD;
584: RAISE FND_API.G_EXC_ERROR;
585: END IF;
586: HZ_MATCH_RULE_32.find_persons(
587: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
588: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,'N',x_search_ctx_id,x_num_matches);
589: -- Code for Match rule SAMPLE:BASIC SEARCH RULE
590: ELSIF p_rule_id=33 THEN

Line 1000: IF NOT HZ_MATCH_RULE_32.check_staged THEN

996: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
997: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
998: -- Code for Match rule RM SEARCH RULE
999: ELSIF p_rule_id=32 THEN
1000: IF NOT HZ_MATCH_RULE_32.check_staged THEN
1001: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1002: FND_MSG_PUB.ADD;
1003: RAISE FND_API.G_EXC_ERROR;
1004: END IF;

Line 1005: HZ_MATCH_RULE_32.find_party_details(

1001: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1002: FND_MSG_PUB.ADD;
1003: RAISE FND_API.G_EXC_ERROR;
1004: END IF;
1005: HZ_MATCH_RULE_32.find_party_details(
1006: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
1007: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
1008: -- Code for Match rule SAMPLE:BASIC SEARCH RULE
1009: ELSIF p_rule_id=33 THEN

Line 1400: IF NOT HZ_MATCH_RULE_32.check_staged THEN

1396: p_rule_id,p_party_id,
1397: p_restrict_sql,p_match_type,p_dup_batch_id,p_search_merged,x_dup_set_id, x_search_ctx_id,x_num_matches);
1398: -- Code for Match rule RM SEARCH RULE
1399: ELSIF p_rule_id=32 THEN
1400: IF NOT HZ_MATCH_RULE_32.check_staged THEN
1401: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1402: FND_MSG_PUB.ADD;
1403: RAISE FND_API.G_EXC_ERROR;
1404: END IF;

Line 1405: HZ_MATCH_RULE_32.find_duplicate_parties(

1401: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1402: FND_MSG_PUB.ADD;
1403: RAISE FND_API.G_EXC_ERROR;
1404: END IF;
1405: HZ_MATCH_RULE_32.find_duplicate_parties(
1406: p_rule_id,p_party_id,
1407: p_restrict_sql,p_match_type,p_dup_batch_id,p_search_merged,x_dup_set_id, x_search_ctx_id,x_num_matches);
1408: -- Code for Match rule SAMPLE:BASIC SEARCH RULE
1409: ELSIF p_rule_id=33 THEN

Line 1795: IF NOT HZ_MATCH_RULE_32.check_staged THEN

1791: p_rule_id,p_party_site_id,p_party_id,
1792: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
1793: -- Code for Match rule RM SEARCH RULE
1794: ELSIF p_rule_id=32 THEN
1795: IF NOT HZ_MATCH_RULE_32.check_staged THEN
1796: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1797: FND_MSG_PUB.ADD;
1798: RAISE FND_API.G_EXC_ERROR;
1799: END IF;

Line 1800: HZ_MATCH_RULE_32.find_duplicate_party_sites(

1796: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1797: FND_MSG_PUB.ADD;
1798: RAISE FND_API.G_EXC_ERROR;
1799: END IF;
1800: HZ_MATCH_RULE_32.find_duplicate_party_sites(
1801: p_rule_id,p_party_site_id,p_party_id,
1802: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
1803: -- Code for Match rule SAMPLE:BASIC SEARCH RULE
1804: ELSIF p_rule_id=33 THEN

Line 2189: IF NOT HZ_MATCH_RULE_32.check_staged THEN

2185: p_rule_id,p_org_contact_id,p_party_id,
2186: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2187: -- Code for Match rule RM SEARCH RULE
2188: ELSIF p_rule_id=32 THEN
2189: IF NOT HZ_MATCH_RULE_32.check_staged THEN
2190: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2191: FND_MSG_PUB.ADD;
2192: RAISE FND_API.G_EXC_ERROR;
2193: END IF;

Line 2194: HZ_MATCH_RULE_32.find_duplicate_contacts(

2190: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2191: FND_MSG_PUB.ADD;
2192: RAISE FND_API.G_EXC_ERROR;
2193: END IF;
2194: HZ_MATCH_RULE_32.find_duplicate_contacts(
2195: p_rule_id,p_org_contact_id,p_party_id,
2196: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2197: -- Code for Match rule SAMPLE:BASIC SEARCH RULE
2198: ELSIF p_rule_id=33 THEN

Line 2583: IF NOT HZ_MATCH_RULE_32.check_staged THEN

2579: p_rule_id,p_contact_point_id,p_party_id,
2580: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2581: -- Code for Match rule RM SEARCH RULE
2582: ELSIF p_rule_id=32 THEN
2583: IF NOT HZ_MATCH_RULE_32.check_staged THEN
2584: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2585: FND_MSG_PUB.ADD;
2586: RAISE FND_API.G_EXC_ERROR;
2587: END IF;

Line 2588: HZ_MATCH_RULE_32.find_duplicate_contact_points(

2584: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2585: FND_MSG_PUB.ADD;
2586: RAISE FND_API.G_EXC_ERROR;
2587: END IF;
2588: HZ_MATCH_RULE_32.find_duplicate_contact_points(
2589: p_rule_id,p_contact_point_id,p_party_id,
2590: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2591: -- Code for Match rule SAMPLE:BASIC SEARCH RULE
2592: ELSIF p_rule_id=33 THEN

Line 3073: IF NOT HZ_MATCH_RULE_32.check_staged THEN

3069: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3070: p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
3071: -- Code for Match rule RM SEARCH RULE
3072: ELSIF p_rule_id=32 THEN
3073: IF NOT HZ_MATCH_RULE_32.check_staged THEN
3074: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3075: FND_MSG_PUB.ADD;
3076: RAISE FND_API.G_EXC_ERROR;
3077: END IF;

Line 3078: HZ_MATCH_RULE_32.find_parties_dynamic(

3074: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3075: FND_MSG_PUB.ADD;
3076: RAISE FND_API.G_EXC_ERROR;
3077: END IF;
3078: HZ_MATCH_RULE_32.find_parties_dynamic(
3079: p_rule_id,
3080: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
3081: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
3082: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 3756: IF NOT HZ_MATCH_RULE_32.check_staged THEN

3752: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3753: p_restrict_sql,p_api_name,p_match_type,p_party_id,p_search_merged,x_search_ctx_id,x_num_matches);
3754: -- Code for Match rule RM SEARCH RULE
3755: ELSIF p_rule_id=32 THEN
3756: IF NOT HZ_MATCH_RULE_32.check_staged THEN
3757: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3758: FND_MSG_PUB.ADD;
3759: RAISE FND_API.G_EXC_ERROR;
3760: END IF;

Line 3761: HZ_MATCH_RULE_32.call_api_dynamic(

3757: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3758: FND_MSG_PUB.ADD;
3759: RAISE FND_API.G_EXC_ERROR;
3760: END IF;
3761: HZ_MATCH_RULE_32.call_api_dynamic(
3762: p_rule_id,
3763: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
3764: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
3765: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 4574: IF NOT HZ_MATCH_RULE_32.check_staged THEN

4570: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4571: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4572: -- Code for Match rule RM SEARCH RULE
4573: ELSIF p_rule_id=32 THEN
4574: IF NOT HZ_MATCH_RULE_32.check_staged THEN
4575: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4576: FND_MSG_PUB.ADD;
4577: RAISE FND_API.G_EXC_ERROR;
4578: END IF;

Line 4579: HZ_MATCH_RULE_32.get_matching_party_sites(

4575: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4576: FND_MSG_PUB.ADD;
4577: RAISE FND_API.G_EXC_ERROR;
4578: END IF;
4579: HZ_MATCH_RULE_32.get_matching_party_sites(
4580: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4581: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4582: -- Code for Match rule SAMPLE:BASIC SEARCH RULE
4583: ELSIF p_rule_id=33 THEN

Line 4993: IF NOT HZ_MATCH_RULE_32.check_staged THEN

4989: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
4990: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4991: -- Code for Match rule RM SEARCH RULE
4992: ELSIF p_rule_id=32 THEN
4993: IF NOT HZ_MATCH_RULE_32.check_staged THEN
4994: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4995: FND_MSG_PUB.ADD;
4996: RAISE FND_API.G_EXC_ERROR;
4997: END IF;

Line 4998: HZ_MATCH_RULE_32.get_matching_contacts(

4994: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4995: FND_MSG_PUB.ADD;
4996: RAISE FND_API.G_EXC_ERROR;
4997: END IF;
4998: HZ_MATCH_RULE_32.get_matching_contacts(
4999: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
5000: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5001: -- Code for Match rule SAMPLE:BASIC SEARCH RULE
5002: ELSIF p_rule_id=33 THEN

Line 5410: IF NOT HZ_MATCH_RULE_32.check_staged THEN

5406: p_rule_id, p_party_id, p_contact_point_list,
5407: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5408: -- Code for Match rule RM SEARCH RULE
5409: ELSIF p_rule_id=32 THEN
5410: IF NOT HZ_MATCH_RULE_32.check_staged THEN
5411: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5412: FND_MSG_PUB.ADD;
5413: RAISE FND_API.G_EXC_ERROR;
5414: END IF;

Line 5415: HZ_MATCH_RULE_32.get_matching_contact_points(

5411: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5412: FND_MSG_PUB.ADD;
5413: RAISE FND_API.G_EXC_ERROR;
5414: END IF;
5415: HZ_MATCH_RULE_32.get_matching_contact_points(
5416: p_rule_id, p_party_id, p_contact_point_list,
5417: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5418: -- Code for Match rule SAMPLE:BASIC SEARCH RULE
5419: ELSIF p_rule_id=33 THEN

Line 5837: IF NOT HZ_MATCH_RULE_32.check_staged THEN

5833: p_party_id, p_party_search_rec,p_party_site_list,
5834: p_contact_list, p_contact_point_list,x_search_ctx_id);
5835: -- Code for Match rule RM SEARCH RULE
5836: ELSIF p_rule_id=32 THEN
5837: IF NOT HZ_MATCH_RULE_32.check_staged THEN
5838: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5839: FND_MSG_PUB.ADD;
5840: RAISE FND_API.G_EXC_ERROR;
5841: END IF;

Line 5842: HZ_MATCH_RULE_32.get_score_details(

5838: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5839: FND_MSG_PUB.ADD;
5840: RAISE FND_API.G_EXC_ERROR;
5841: END IF;
5842: HZ_MATCH_RULE_32.get_score_details(
5843: p_rule_id,
5844: p_party_id, p_party_search_rec,p_party_site_list,
5845: p_contact_list, p_contact_point_list,x_search_ctx_id);
5846: -- Code for Match rule SAMPLE:BASIC SEARCH RULE

Line 6250: IF NOT HZ_MATCH_RULE_32.check_staged THEN

6246: p_party_id, x_party_search_rec,x_party_site_list,
6247: x_contact_list, x_contact_point_list);
6248: -- Code for Match rule RM SEARCH RULE
6249: ELSIF p_rule_id=32 THEN
6250: IF NOT HZ_MATCH_RULE_32.check_staged THEN
6251: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6252: FND_MSG_PUB.ADD;
6253: RAISE FND_API.G_EXC_ERROR;
6254: END IF;

Line 6255: HZ_MATCH_RULE_32.get_party_for_search(

6251: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6252: FND_MSG_PUB.ADD;
6253: RAISE FND_API.G_EXC_ERROR;
6254: END IF;
6255: HZ_MATCH_RULE_32.get_party_for_search(
6256: p_party_id, x_party_search_rec,x_party_site_list,
6257: x_contact_list, x_contact_point_list);
6258: -- Code for Match rule SAMPLE:BASIC SEARCH RULE
6259: ELSIF p_rule_id=33 THEN

Line 6642: IF NOT HZ_MATCH_RULE_32.check_staged THEN

6638: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6639: x_contact_list, x_contact_point_list);
6640: -- Code for Match rule RM SEARCH RULE
6641: ELSIF p_rule_id=32 THEN
6642: IF NOT HZ_MATCH_RULE_32.check_staged THEN
6643: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6644: FND_MSG_PUB.ADD;
6645: RAISE FND_API.G_EXC_ERROR;
6646: END IF;

Line 6647: HZ_MATCH_RULE_32.get_search_criteria(

6643: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6644: FND_MSG_PUB.ADD;
6645: RAISE FND_API.G_EXC_ERROR;
6646: END IF;
6647: HZ_MATCH_RULE_32.get_search_criteria(
6648: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6649: x_contact_list, x_contact_point_list);
6650: -- Code for Match rule SAMPLE:BASIC SEARCH RULE
6651: ELSIF p_rule_id=33 THEN