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 591: IF NOT HZ_MATCH_RULE_33.check_staged THEN

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
591: IF NOT HZ_MATCH_RULE_33.check_staged THEN
592: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
593: FND_MSG_PUB.ADD;
594: RAISE FND_API.G_EXC_ERROR;
595: END IF;

Line 596: HZ_MATCH_RULE_33.find_persons(

592: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
593: FND_MSG_PUB.ADD;
594: RAISE FND_API.G_EXC_ERROR;
595: END IF;
596: HZ_MATCH_RULE_33.find_persons(
597: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
598: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,'N',x_search_ctx_id,x_num_matches);
599: -- Code for Match rule SAMPLE:ADVANCED SEARCH RULE
600: ELSIF p_rule_id=34 THEN

Line 1010: IF NOT HZ_MATCH_RULE_33.check_staged THEN

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
1010: IF NOT HZ_MATCH_RULE_33.check_staged THEN
1011: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1012: FND_MSG_PUB.ADD;
1013: RAISE FND_API.G_EXC_ERROR;
1014: END IF;

Line 1015: HZ_MATCH_RULE_33.find_party_details(

1011: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1012: FND_MSG_PUB.ADD;
1013: RAISE FND_API.G_EXC_ERROR;
1014: END IF;
1015: HZ_MATCH_RULE_33.find_party_details(
1016: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
1017: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
1018: -- Code for Match rule SAMPLE:ADVANCED SEARCH RULE
1019: ELSIF p_rule_id=34 THEN

Line 1410: IF NOT HZ_MATCH_RULE_33.check_staged THEN

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
1410: IF NOT HZ_MATCH_RULE_33.check_staged THEN
1411: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1412: FND_MSG_PUB.ADD;
1413: RAISE FND_API.G_EXC_ERROR;
1414: END IF;

Line 1415: HZ_MATCH_RULE_33.find_duplicate_parties(

1411: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1412: FND_MSG_PUB.ADD;
1413: RAISE FND_API.G_EXC_ERROR;
1414: END IF;
1415: HZ_MATCH_RULE_33.find_duplicate_parties(
1416: p_rule_id,p_party_id,
1417: p_restrict_sql,p_match_type,p_dup_batch_id,p_search_merged,x_dup_set_id, x_search_ctx_id,x_num_matches);
1418: -- Code for Match rule SAMPLE:ADVANCED SEARCH RULE
1419: ELSIF p_rule_id=34 THEN

Line 1805: IF NOT HZ_MATCH_RULE_33.check_staged THEN

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
1805: IF NOT HZ_MATCH_RULE_33.check_staged THEN
1806: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1807: FND_MSG_PUB.ADD;
1808: RAISE FND_API.G_EXC_ERROR;
1809: END IF;

Line 1810: HZ_MATCH_RULE_33.find_duplicate_party_sites(

1806: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1807: FND_MSG_PUB.ADD;
1808: RAISE FND_API.G_EXC_ERROR;
1809: END IF;
1810: HZ_MATCH_RULE_33.find_duplicate_party_sites(
1811: p_rule_id,p_party_site_id,p_party_id,
1812: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
1813: -- Code for Match rule SAMPLE:ADVANCED SEARCH RULE
1814: ELSIF p_rule_id=34 THEN

Line 2199: IF NOT HZ_MATCH_RULE_33.check_staged THEN

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
2199: IF NOT HZ_MATCH_RULE_33.check_staged THEN
2200: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2201: FND_MSG_PUB.ADD;
2202: RAISE FND_API.G_EXC_ERROR;
2203: END IF;

Line 2204: HZ_MATCH_RULE_33.find_duplicate_contacts(

2200: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2201: FND_MSG_PUB.ADD;
2202: RAISE FND_API.G_EXC_ERROR;
2203: END IF;
2204: HZ_MATCH_RULE_33.find_duplicate_contacts(
2205: p_rule_id,p_org_contact_id,p_party_id,
2206: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2207: -- Code for Match rule SAMPLE:ADVANCED SEARCH RULE
2208: ELSIF p_rule_id=34 THEN

Line 2593: IF NOT HZ_MATCH_RULE_33.check_staged THEN

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
2593: IF NOT HZ_MATCH_RULE_33.check_staged THEN
2594: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2595: FND_MSG_PUB.ADD;
2596: RAISE FND_API.G_EXC_ERROR;
2597: END IF;

Line 2598: HZ_MATCH_RULE_33.find_duplicate_contact_points(

2594: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2595: FND_MSG_PUB.ADD;
2596: RAISE FND_API.G_EXC_ERROR;
2597: END IF;
2598: HZ_MATCH_RULE_33.find_duplicate_contact_points(
2599: p_rule_id,p_contact_point_id,p_party_id,
2600: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2601: -- Code for Match rule SAMPLE:ADVANCED SEARCH RULE
2602: ELSIF p_rule_id=34 THEN

Line 3091: IF NOT HZ_MATCH_RULE_33.check_staged THEN

3087: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3088: p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
3089: -- Code for Match rule SAMPLE:BASIC SEARCH RULE
3090: ELSIF p_rule_id=33 THEN
3091: IF NOT HZ_MATCH_RULE_33.check_staged THEN
3092: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3093: FND_MSG_PUB.ADD;
3094: RAISE FND_API.G_EXC_ERROR;
3095: END IF;

Line 3096: HZ_MATCH_RULE_33.find_parties_dynamic(

3092: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3093: FND_MSG_PUB.ADD;
3094: RAISE FND_API.G_EXC_ERROR;
3095: END IF;
3096: HZ_MATCH_RULE_33.find_parties_dynamic(
3097: p_rule_id,
3098: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
3099: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
3100: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 3774: IF NOT HZ_MATCH_RULE_33.check_staged THEN

3770: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3771: p_restrict_sql,p_api_name,p_match_type,p_party_id,p_search_merged,x_search_ctx_id,x_num_matches);
3772: -- Code for Match rule SAMPLE:BASIC SEARCH RULE
3773: ELSIF p_rule_id=33 THEN
3774: IF NOT HZ_MATCH_RULE_33.check_staged THEN
3775: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3776: FND_MSG_PUB.ADD;
3777: RAISE FND_API.G_EXC_ERROR;
3778: END IF;

Line 3779: HZ_MATCH_RULE_33.call_api_dynamic(

3775: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3776: FND_MSG_PUB.ADD;
3777: RAISE FND_API.G_EXC_ERROR;
3778: END IF;
3779: HZ_MATCH_RULE_33.call_api_dynamic(
3780: p_rule_id,
3781: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
3782: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
3783: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 4584: IF NOT HZ_MATCH_RULE_33.check_staged THEN

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
4584: IF NOT HZ_MATCH_RULE_33.check_staged THEN
4585: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4586: FND_MSG_PUB.ADD;
4587: RAISE FND_API.G_EXC_ERROR;
4588: END IF;

Line 4589: HZ_MATCH_RULE_33.get_matching_party_sites(

4585: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4586: FND_MSG_PUB.ADD;
4587: RAISE FND_API.G_EXC_ERROR;
4588: END IF;
4589: HZ_MATCH_RULE_33.get_matching_party_sites(
4590: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4591: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4592: -- Code for Match rule SAMPLE:ADVANCED SEARCH RULE
4593: ELSIF p_rule_id=34 THEN

Line 5003: IF NOT HZ_MATCH_RULE_33.check_staged THEN

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
5003: IF NOT HZ_MATCH_RULE_33.check_staged THEN
5004: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5005: FND_MSG_PUB.ADD;
5006: RAISE FND_API.G_EXC_ERROR;
5007: END IF;

Line 5008: HZ_MATCH_RULE_33.get_matching_contacts(

5004: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5005: FND_MSG_PUB.ADD;
5006: RAISE FND_API.G_EXC_ERROR;
5007: END IF;
5008: HZ_MATCH_RULE_33.get_matching_contacts(
5009: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
5010: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5011: -- Code for Match rule SAMPLE:ADVANCED SEARCH RULE
5012: ELSIF p_rule_id=34 THEN

Line 5420: IF NOT HZ_MATCH_RULE_33.check_staged THEN

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
5420: IF NOT HZ_MATCH_RULE_33.check_staged THEN
5421: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5422: FND_MSG_PUB.ADD;
5423: RAISE FND_API.G_EXC_ERROR;
5424: END IF;

Line 5425: HZ_MATCH_RULE_33.get_matching_contact_points(

5421: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5422: FND_MSG_PUB.ADD;
5423: RAISE FND_API.G_EXC_ERROR;
5424: END IF;
5425: HZ_MATCH_RULE_33.get_matching_contact_points(
5426: p_rule_id, p_party_id, p_contact_point_list,
5427: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5428: -- Code for Match rule SAMPLE:ADVANCED SEARCH RULE
5429: ELSIF p_rule_id=34 THEN

Line 5848: IF NOT HZ_MATCH_RULE_33.check_staged THEN

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
5847: ELSIF p_rule_id=33 THEN
5848: IF NOT HZ_MATCH_RULE_33.check_staged THEN
5849: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5850: FND_MSG_PUB.ADD;
5851: RAISE FND_API.G_EXC_ERROR;
5852: END IF;

Line 5853: HZ_MATCH_RULE_33.get_score_details(

5849: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5850: FND_MSG_PUB.ADD;
5851: RAISE FND_API.G_EXC_ERROR;
5852: END IF;
5853: HZ_MATCH_RULE_33.get_score_details(
5854: p_rule_id,
5855: p_party_id, p_party_search_rec,p_party_site_list,
5856: p_contact_list, p_contact_point_list,x_search_ctx_id);
5857: -- Code for Match rule SAMPLE:ADVANCED SEARCH RULE

Line 6260: IF NOT HZ_MATCH_RULE_33.check_staged THEN

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
6260: IF NOT HZ_MATCH_RULE_33.check_staged THEN
6261: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6262: FND_MSG_PUB.ADD;
6263: RAISE FND_API.G_EXC_ERROR;
6264: END IF;

Line 6265: HZ_MATCH_RULE_33.get_party_for_search(

6261: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6262: FND_MSG_PUB.ADD;
6263: RAISE FND_API.G_EXC_ERROR;
6264: END IF;
6265: HZ_MATCH_RULE_33.get_party_for_search(
6266: p_party_id, x_party_search_rec,x_party_site_list,
6267: x_contact_list, x_contact_point_list);
6268: -- Code for Match rule SAMPLE:ADVANCED SEARCH RULE
6269: ELSIF p_rule_id=34 THEN

Line 6652: IF NOT HZ_MATCH_RULE_33.check_staged THEN

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
6652: IF NOT HZ_MATCH_RULE_33.check_staged THEN
6653: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6654: FND_MSG_PUB.ADD;
6655: RAISE FND_API.G_EXC_ERROR;
6656: END IF;

Line 6657: HZ_MATCH_RULE_33.get_search_criteria(

6653: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6654: FND_MSG_PUB.ADD;
6655: RAISE FND_API.G_EXC_ERROR;
6656: END IF;
6657: HZ_MATCH_RULE_33.get_search_criteria(
6658: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6659: x_contact_list, x_contact_point_list);
6660: -- Code for Match rule SAMPLE:ADVANCED SEARCH RULE
6661: ELSIF p_rule_id=34 THEN