DBA Data[Home] [Help]

APPS.HZ_PARTY_SEARCH dependencies on HZ_MATCH_RULE_37

Line 230: IF NOT HZ_MATCH_RULE_37.check_staged THEN

226: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
227: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,NULL,NULL,NULL,'N',x_search_ctx_id,x_num_matches);
228: -- Code for Match rule DL ADDRESS DEFAULT
229: ELSIF p_rule_id=37 THEN
230: IF NOT HZ_MATCH_RULE_37.check_staged THEN
231: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
232: FND_MSG_PUB.ADD;
233: RAISE FND_API.G_EXC_ERROR;
234: END IF;

Line 235: HZ_MATCH_RULE_37.find_parties(

231: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
232: FND_MSG_PUB.ADD;
233: RAISE FND_API.G_EXC_ERROR;
234: END IF;
235: HZ_MATCH_RULE_37.find_parties(
236: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
237: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,NULL,NULL,NULL,'N',x_search_ctx_id,x_num_matches);
238: -- Code for Match rule DL RELATIONSHIP DEFAULT
239: ELSIF p_rule_id=38 THEN

Line 611: IF NOT HZ_MATCH_RULE_37.check_staged THEN

607: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
608: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,'N',x_search_ctx_id,x_num_matches);
609: -- Code for Match rule DL ADDRESS DEFAULT
610: ELSIF p_rule_id=37 THEN
611: IF NOT HZ_MATCH_RULE_37.check_staged THEN
612: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
613: FND_MSG_PUB.ADD;
614: RAISE FND_API.G_EXC_ERROR;
615: END IF;

Line 616: HZ_MATCH_RULE_37.find_persons(

612: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
613: FND_MSG_PUB.ADD;
614: RAISE FND_API.G_EXC_ERROR;
615: END IF;
616: HZ_MATCH_RULE_37.find_persons(
617: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
618: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,'N',x_search_ctx_id,x_num_matches);
619: -- Code for Match rule DL RELATIONSHIP DEFAULT
620: ELSIF p_rule_id=38 THEN

Line 1010: IF NOT HZ_MATCH_RULE_37.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 DL ADDRESS DEFAULT
1009: ELSIF p_rule_id=37 THEN
1010: IF NOT HZ_MATCH_RULE_37.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_37.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_37.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 DL RELATIONSHIP DEFAULT
1019: ELSIF p_rule_id=38 THEN

Line 1390: IF NOT HZ_MATCH_RULE_37.check_staged THEN

1386: p_rule_id,p_party_id,
1387: p_restrict_sql,p_match_type,p_dup_batch_id,p_search_merged,x_dup_set_id, x_search_ctx_id,x_num_matches);
1388: -- Code for Match rule DL ADDRESS DEFAULT
1389: ELSIF p_rule_id=37 THEN
1390: IF NOT HZ_MATCH_RULE_37.check_staged THEN
1391: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1392: FND_MSG_PUB.ADD;
1393: RAISE FND_API.G_EXC_ERROR;
1394: END IF;

Line 1395: HZ_MATCH_RULE_37.find_duplicate_parties(

1391: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1392: FND_MSG_PUB.ADD;
1393: RAISE FND_API.G_EXC_ERROR;
1394: END IF;
1395: HZ_MATCH_RULE_37.find_duplicate_parties(
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 DL RELATIONSHIP DEFAULT
1399: ELSIF p_rule_id=38 THEN

Line 1765: IF NOT HZ_MATCH_RULE_37.check_staged THEN

1761: p_rule_id,p_party_site_id,p_party_id,
1762: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
1763: -- Code for Match rule DL ADDRESS DEFAULT
1764: ELSIF p_rule_id=37 THEN
1765: IF NOT HZ_MATCH_RULE_37.check_staged THEN
1766: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1767: FND_MSG_PUB.ADD;
1768: RAISE FND_API.G_EXC_ERROR;
1769: END IF;

Line 1770: HZ_MATCH_RULE_37.find_duplicate_party_sites(

1766: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1767: FND_MSG_PUB.ADD;
1768: RAISE FND_API.G_EXC_ERROR;
1769: END IF;
1770: HZ_MATCH_RULE_37.find_duplicate_party_sites(
1771: p_rule_id,p_party_site_id,p_party_id,
1772: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
1773: -- Code for Match rule DL RELATIONSHIP DEFAULT
1774: ELSIF p_rule_id=38 THEN

Line 2139: IF NOT HZ_MATCH_RULE_37.check_staged THEN

2135: p_rule_id,p_org_contact_id,p_party_id,
2136: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2137: -- Code for Match rule DL ADDRESS DEFAULT
2138: ELSIF p_rule_id=37 THEN
2139: IF NOT HZ_MATCH_RULE_37.check_staged THEN
2140: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2141: FND_MSG_PUB.ADD;
2142: RAISE FND_API.G_EXC_ERROR;
2143: END IF;

Line 2144: HZ_MATCH_RULE_37.find_duplicate_contacts(

2140: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2141: FND_MSG_PUB.ADD;
2142: RAISE FND_API.G_EXC_ERROR;
2143: END IF;
2144: HZ_MATCH_RULE_37.find_duplicate_contacts(
2145: p_rule_id,p_org_contact_id,p_party_id,
2146: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2147: -- Code for Match rule DL RELATIONSHIP DEFAULT
2148: ELSIF p_rule_id=38 THEN

Line 2513: IF NOT HZ_MATCH_RULE_37.check_staged THEN

2509: p_rule_id,p_contact_point_id,p_party_id,
2510: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2511: -- Code for Match rule DL ADDRESS DEFAULT
2512: ELSIF p_rule_id=37 THEN
2513: IF NOT HZ_MATCH_RULE_37.check_staged THEN
2514: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2515: FND_MSG_PUB.ADD;
2516: RAISE FND_API.G_EXC_ERROR;
2517: END IF;

Line 2518: HZ_MATCH_RULE_37.find_duplicate_contact_points(

2514: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2515: FND_MSG_PUB.ADD;
2516: RAISE FND_API.G_EXC_ERROR;
2517: END IF;
2518: HZ_MATCH_RULE_37.find_duplicate_contact_points(
2519: p_rule_id,p_contact_point_id,p_party_id,
2520: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2521: -- Code for Match rule DL RELATIONSHIP DEFAULT
2522: ELSIF p_rule_id=38 THEN

Line 3023: IF NOT HZ_MATCH_RULE_37.check_staged THEN

3019: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3020: p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
3021: -- Code for Match rule DL ADDRESS DEFAULT
3022: ELSIF p_rule_id=37 THEN
3023: IF NOT HZ_MATCH_RULE_37.check_staged THEN
3024: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3025: FND_MSG_PUB.ADD;
3026: RAISE FND_API.G_EXC_ERROR;
3027: END IF;

Line 3028: HZ_MATCH_RULE_37.find_parties_dynamic(

3024: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3025: FND_MSG_PUB.ADD;
3026: RAISE FND_API.G_EXC_ERROR;
3027: END IF;
3028: HZ_MATCH_RULE_37.find_parties_dynamic(
3029: p_rule_id,
3030: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
3031: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
3032: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 3670: IF NOT HZ_MATCH_RULE_37.check_staged THEN

3666: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3667: p_restrict_sql,p_api_name,p_match_type,p_party_id,p_search_merged,x_search_ctx_id,x_num_matches);
3668: -- Code for Match rule DL ADDRESS DEFAULT
3669: ELSIF p_rule_id=37 THEN
3670: IF NOT HZ_MATCH_RULE_37.check_staged THEN
3671: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3672: FND_MSG_PUB.ADD;
3673: RAISE FND_API.G_EXC_ERROR;
3674: END IF;

Line 3675: HZ_MATCH_RULE_37.call_api_dynamic(

3671: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3672: FND_MSG_PUB.ADD;
3673: RAISE FND_API.G_EXC_ERROR;
3674: END IF;
3675: HZ_MATCH_RULE_37.call_api_dynamic(
3676: p_rule_id,
3677: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
3678: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
3679: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 4412: IF NOT HZ_MATCH_RULE_37.check_staged THEN

4408: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4409: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4410: -- Code for Match rule DL ADDRESS DEFAULT
4411: ELSIF p_rule_id=37 THEN
4412: IF NOT HZ_MATCH_RULE_37.check_staged THEN
4413: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4414: FND_MSG_PUB.ADD;
4415: RAISE FND_API.G_EXC_ERROR;
4416: END IF;

Line 4417: HZ_MATCH_RULE_37.get_matching_party_sites(

4413: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4414: FND_MSG_PUB.ADD;
4415: RAISE FND_API.G_EXC_ERROR;
4416: END IF;
4417: HZ_MATCH_RULE_37.get_matching_party_sites(
4418: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4419: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4420: -- Code for Match rule DL RELATIONSHIP DEFAULT
4421: ELSIF p_rule_id=38 THEN

Line 4811: IF NOT HZ_MATCH_RULE_37.check_staged THEN

4807: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
4808: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4809: -- Code for Match rule DL ADDRESS DEFAULT
4810: ELSIF p_rule_id=37 THEN
4811: IF NOT HZ_MATCH_RULE_37.check_staged THEN
4812: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4813: FND_MSG_PUB.ADD;
4814: RAISE FND_API.G_EXC_ERROR;
4815: END IF;

Line 4816: HZ_MATCH_RULE_37.get_matching_contacts(

4812: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4813: FND_MSG_PUB.ADD;
4814: RAISE FND_API.G_EXC_ERROR;
4815: END IF;
4816: HZ_MATCH_RULE_37.get_matching_contacts(
4817: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
4818: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4819: -- Code for Match rule DL RELATIONSHIP DEFAULT
4820: ELSIF p_rule_id=38 THEN

Line 5208: IF NOT HZ_MATCH_RULE_37.check_staged THEN

5204: p_rule_id, p_party_id, p_contact_point_list,
5205: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5206: -- Code for Match rule DL ADDRESS DEFAULT
5207: ELSIF p_rule_id=37 THEN
5208: IF NOT HZ_MATCH_RULE_37.check_staged THEN
5209: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5210: FND_MSG_PUB.ADD;
5211: RAISE FND_API.G_EXC_ERROR;
5212: END IF;

Line 5213: HZ_MATCH_RULE_37.get_matching_contact_points(

5209: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5210: FND_MSG_PUB.ADD;
5211: RAISE FND_API.G_EXC_ERROR;
5212: END IF;
5213: HZ_MATCH_RULE_37.get_matching_contact_points(
5214: p_rule_id, p_party_id, p_contact_point_list,
5215: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5216: -- Code for Match rule DL RELATIONSHIP DEFAULT
5217: ELSIF p_rule_id=38 THEN

Line 5620: IF NOT HZ_MATCH_RULE_37.check_staged THEN

5616: p_party_id, p_party_search_rec,p_party_site_list,
5617: p_contact_list, p_contact_point_list,x_search_ctx_id);
5618: -- Code for Match rule DL ADDRESS DEFAULT
5619: ELSIF p_rule_id=37 THEN
5620: IF NOT HZ_MATCH_RULE_37.check_staged THEN
5621: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5622: FND_MSG_PUB.ADD;
5623: RAISE FND_API.G_EXC_ERROR;
5624: END IF;

Line 5625: HZ_MATCH_RULE_37.get_score_details(

5621: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5622: FND_MSG_PUB.ADD;
5623: RAISE FND_API.G_EXC_ERROR;
5624: END IF;
5625: HZ_MATCH_RULE_37.get_score_details(
5626: p_rule_id,
5627: p_party_id, p_party_search_rec,p_party_site_list,
5628: p_contact_list, p_contact_point_list,x_search_ctx_id);
5629: -- Code for Match rule DL RELATIONSHIP DEFAULT

Line 6006: IF NOT HZ_MATCH_RULE_37.check_staged THEN

6002: p_party_id, x_party_search_rec,x_party_site_list,
6003: x_contact_list, x_contact_point_list);
6004: -- Code for Match rule DL ADDRESS DEFAULT
6005: ELSIF p_rule_id=37 THEN
6006: IF NOT HZ_MATCH_RULE_37.check_staged THEN
6007: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6008: FND_MSG_PUB.ADD;
6009: RAISE FND_API.G_EXC_ERROR;
6010: END IF;

Line 6011: HZ_MATCH_RULE_37.get_party_for_search(

6007: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6008: FND_MSG_PUB.ADD;
6009: RAISE FND_API.G_EXC_ERROR;
6010: END IF;
6011: HZ_MATCH_RULE_37.get_party_for_search(
6012: p_party_id, x_party_search_rec,x_party_site_list,
6013: x_contact_list, x_contact_point_list);
6014: -- Code for Match rule DL RELATIONSHIP DEFAULT
6015: ELSIF p_rule_id=38 THEN

Line 6378: IF NOT HZ_MATCH_RULE_37.check_staged THEN

6374: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6375: x_contact_list, x_contact_point_list);
6376: -- Code for Match rule DL ADDRESS DEFAULT
6377: ELSIF p_rule_id=37 THEN
6378: IF NOT HZ_MATCH_RULE_37.check_staged THEN
6379: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6380: FND_MSG_PUB.ADD;
6381: RAISE FND_API.G_EXC_ERROR;
6382: END IF;

Line 6383: HZ_MATCH_RULE_37.get_search_criteria(

6379: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6380: FND_MSG_PUB.ADD;
6381: RAISE FND_API.G_EXC_ERROR;
6382: END IF;
6383: HZ_MATCH_RULE_37.get_search_criteria(
6384: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6385: x_contact_list, x_contact_point_list);
6386: -- Code for Match rule DL RELATIONSHIP DEFAULT
6387: ELSIF p_rule_id=38 THEN