DBA Data[Home] [Help]

APPS.HZ_PARTY_SEARCH dependencies on HZ_MATCH_RULE_98

Line 380: IF NOT HZ_MATCH_RULE_98.check_staged THEN

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
380: IF NOT HZ_MATCH_RULE_98.check_staged THEN
381: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
382: FND_MSG_PUB.ADD;
383: RAISE FND_API.G_EXC_ERROR;
384: END IF;

Line 385: HZ_MATCH_RULE_98.find_parties(

381: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
382: FND_MSG_PUB.ADD;
383: RAISE FND_API.G_EXC_ERROR;
384: END IF;
385: HZ_MATCH_RULE_98.find_parties(
386: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
387: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,NULL,NULL,NULL,'N',x_search_ctx_id,x_num_matches);
388: -- Code for Match rule HZ_CONTACT_ADV_SEARCH_MATCH_RULE
389: ELSIF p_rule_id=99 THEN

Line 781: IF NOT HZ_MATCH_RULE_98.check_staged THEN

777: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
778: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,'N',x_search_ctx_id,x_num_matches);
779: -- Code for Match rule HZ_CONTACT_SIMPLE_SEARCH_RULE
780: ELSIF p_rule_id=98 THEN
781: IF NOT HZ_MATCH_RULE_98.check_staged THEN
782: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
783: FND_MSG_PUB.ADD;
784: RAISE FND_API.G_EXC_ERROR;
785: END IF;

Line 786: HZ_MATCH_RULE_98.find_persons(

782: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
783: FND_MSG_PUB.ADD;
784: RAISE FND_API.G_EXC_ERROR;
785: END IF;
786: HZ_MATCH_RULE_98.find_persons(
787: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
788: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,'N',x_search_ctx_id,x_num_matches);
789: -- Code for Match rule HZ_CONTACT_ADV_SEARCH_MATCH_RULE
790: ELSIF p_rule_id=99 THEN

Line 1200: IF NOT HZ_MATCH_RULE_98.check_staged THEN

1196: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
1197: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
1198: -- Code for Match rule HZ_CONTACT_SIMPLE_SEARCH_RULE
1199: ELSIF p_rule_id=98 THEN
1200: IF NOT HZ_MATCH_RULE_98.check_staged THEN
1201: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1202: FND_MSG_PUB.ADD;
1203: RAISE FND_API.G_EXC_ERROR;
1204: END IF;

Line 1205: HZ_MATCH_RULE_98.find_party_details(

1201: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1202: FND_MSG_PUB.ADD;
1203: RAISE FND_API.G_EXC_ERROR;
1204: END IF;
1205: HZ_MATCH_RULE_98.find_party_details(
1206: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
1207: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
1208: -- Code for Match rule HZ_CONTACT_ADV_SEARCH_MATCH_RULE
1209: ELSIF p_rule_id=99 THEN

Line 1600: IF NOT HZ_MATCH_RULE_98.check_staged THEN

1596: p_rule_id,p_party_id,
1597: p_restrict_sql,p_match_type,p_dup_batch_id,p_search_merged,x_dup_set_id, x_search_ctx_id,x_num_matches);
1598: -- Code for Match rule HZ_CONTACT_SIMPLE_SEARCH_RULE
1599: ELSIF p_rule_id=98 THEN
1600: IF NOT HZ_MATCH_RULE_98.check_staged THEN
1601: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1602: FND_MSG_PUB.ADD;
1603: RAISE FND_API.G_EXC_ERROR;
1604: END IF;

Line 1605: HZ_MATCH_RULE_98.find_duplicate_parties(

1601: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1602: FND_MSG_PUB.ADD;
1603: RAISE FND_API.G_EXC_ERROR;
1604: END IF;
1605: HZ_MATCH_RULE_98.find_duplicate_parties(
1606: p_rule_id,p_party_id,
1607: p_restrict_sql,p_match_type,p_dup_batch_id,p_search_merged,x_dup_set_id, x_search_ctx_id,x_num_matches);
1608: -- Code for Match rule HZ_CONTACT_ADV_SEARCH_MATCH_RULE
1609: ELSIF p_rule_id=99 THEN

Line 1995: IF NOT HZ_MATCH_RULE_98.check_staged THEN

1991: p_rule_id,p_party_site_id,p_party_id,
1992: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
1993: -- Code for Match rule HZ_CONTACT_SIMPLE_SEARCH_RULE
1994: ELSIF p_rule_id=98 THEN
1995: IF NOT HZ_MATCH_RULE_98.check_staged THEN
1996: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1997: FND_MSG_PUB.ADD;
1998: RAISE FND_API.G_EXC_ERROR;
1999: END IF;

Line 2000: HZ_MATCH_RULE_98.find_duplicate_party_sites(

1996: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
1997: FND_MSG_PUB.ADD;
1998: RAISE FND_API.G_EXC_ERROR;
1999: END IF;
2000: HZ_MATCH_RULE_98.find_duplicate_party_sites(
2001: p_rule_id,p_party_site_id,p_party_id,
2002: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2003: -- Code for Match rule HZ_CONTACT_ADV_SEARCH_MATCH_RULE
2004: ELSIF p_rule_id=99 THEN

Line 2389: IF NOT HZ_MATCH_RULE_98.check_staged THEN

2385: p_rule_id,p_org_contact_id,p_party_id,
2386: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2387: -- Code for Match rule HZ_CONTACT_SIMPLE_SEARCH_RULE
2388: ELSIF p_rule_id=98 THEN
2389: IF NOT HZ_MATCH_RULE_98.check_staged THEN
2390: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2391: FND_MSG_PUB.ADD;
2392: RAISE FND_API.G_EXC_ERROR;
2393: END IF;

Line 2394: HZ_MATCH_RULE_98.find_duplicate_contacts(

2390: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2391: FND_MSG_PUB.ADD;
2392: RAISE FND_API.G_EXC_ERROR;
2393: END IF;
2394: HZ_MATCH_RULE_98.find_duplicate_contacts(
2395: p_rule_id,p_org_contact_id,p_party_id,
2396: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2397: -- Code for Match rule HZ_CONTACT_ADV_SEARCH_MATCH_RULE
2398: ELSIF p_rule_id=99 THEN

Line 2783: IF NOT HZ_MATCH_RULE_98.check_staged THEN

2779: p_rule_id,p_contact_point_id,p_party_id,
2780: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2781: -- Code for Match rule HZ_CONTACT_SIMPLE_SEARCH_RULE
2782: ELSIF p_rule_id=98 THEN
2783: IF NOT HZ_MATCH_RULE_98.check_staged THEN
2784: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2785: FND_MSG_PUB.ADD;
2786: RAISE FND_API.G_EXC_ERROR;
2787: END IF;

Line 2788: HZ_MATCH_RULE_98.find_duplicate_contact_points(

2784: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
2785: FND_MSG_PUB.ADD;
2786: RAISE FND_API.G_EXC_ERROR;
2787: END IF;
2788: HZ_MATCH_RULE_98.find_duplicate_contact_points(
2789: p_rule_id,p_contact_point_id,p_party_id,
2790: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2791: -- Code for Match rule HZ_CONTACT_ADV_SEARCH_MATCH_RULE
2792: ELSIF p_rule_id=99 THEN

Line 3433: IF NOT HZ_MATCH_RULE_98.check_staged THEN

3429: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3430: p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
3431: -- Code for Match rule HZ_CONTACT_SIMPLE_SEARCH_RULE
3432: ELSIF p_rule_id=98 THEN
3433: IF NOT HZ_MATCH_RULE_98.check_staged THEN
3434: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3435: FND_MSG_PUB.ADD;
3436: RAISE FND_API.G_EXC_ERROR;
3437: END IF;

Line 3438: HZ_MATCH_RULE_98.find_parties_dynamic(

3434: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
3435: FND_MSG_PUB.ADD;
3436: RAISE FND_API.G_EXC_ERROR;
3437: END IF;
3438: HZ_MATCH_RULE_98.find_parties_dynamic(
3439: p_rule_id,
3440: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
3441: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
3442: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 4116: IF NOT HZ_MATCH_RULE_98.check_staged THEN

4112: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
4113: p_restrict_sql,p_api_name,p_match_type,p_party_id,p_search_merged,x_search_ctx_id,x_num_matches);
4114: -- Code for Match rule HZ_CONTACT_SIMPLE_SEARCH_RULE
4115: ELSIF p_rule_id=98 THEN
4116: IF NOT HZ_MATCH_RULE_98.check_staged THEN
4117: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4118: FND_MSG_PUB.ADD;
4119: RAISE FND_API.G_EXC_ERROR;
4120: END IF;

Line 4121: HZ_MATCH_RULE_98.call_api_dynamic(

4117: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4118: FND_MSG_PUB.ADD;
4119: RAISE FND_API.G_EXC_ERROR;
4120: END IF;
4121: HZ_MATCH_RULE_98.call_api_dynamic(
4122: p_rule_id,
4123: p_attrib_id1,p_attrib_id2,p_attrib_id3,p_attrib_id4,p_attrib_id5,
4124: p_attrib_id6,p_attrib_id7,p_attrib_id8,p_attrib_id9,p_attrib_id10,
4125: p_attrib_id11,p_attrib_id12,p_attrib_id13,p_attrib_id14,p_attrib_id15,

Line 4774: IF NOT HZ_MATCH_RULE_98.check_staged THEN

4770: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4771: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4772: -- Code for Match rule HZ_CONTACT_SIMPLE_SEARCH_RULE
4773: ELSIF p_rule_id=98 THEN
4774: IF NOT HZ_MATCH_RULE_98.check_staged THEN
4775: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4776: FND_MSG_PUB.ADD;
4777: RAISE FND_API.G_EXC_ERROR;
4778: END IF;

Line 4779: HZ_MATCH_RULE_98.get_matching_party_sites(

4775: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
4776: FND_MSG_PUB.ADD;
4777: RAISE FND_API.G_EXC_ERROR;
4778: END IF;
4779: HZ_MATCH_RULE_98.get_matching_party_sites(
4780: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4781: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4782: -- Code for Match rule HZ_CONTACT_ADV_SEARCH_MATCH_RULE
4783: ELSIF p_rule_id=99 THEN

Line 5193: IF NOT HZ_MATCH_RULE_98.check_staged THEN

5189: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
5190: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5191: -- Code for Match rule HZ_CONTACT_SIMPLE_SEARCH_RULE
5192: ELSIF p_rule_id=98 THEN
5193: IF NOT HZ_MATCH_RULE_98.check_staged THEN
5194: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5195: FND_MSG_PUB.ADD;
5196: RAISE FND_API.G_EXC_ERROR;
5197: END IF;

Line 5198: HZ_MATCH_RULE_98.get_matching_contacts(

5194: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5195: FND_MSG_PUB.ADD;
5196: RAISE FND_API.G_EXC_ERROR;
5197: END IF;
5198: HZ_MATCH_RULE_98.get_matching_contacts(
5199: p_rule_id, p_party_id,p_contact_list, p_contact_point_list,
5200: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5201: -- Code for Match rule HZ_CONTACT_ADV_SEARCH_MATCH_RULE
5202: ELSIF p_rule_id=99 THEN

Line 5610: IF NOT HZ_MATCH_RULE_98.check_staged THEN

5606: p_rule_id, p_party_id, p_contact_point_list,
5607: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5608: -- Code for Match rule HZ_CONTACT_SIMPLE_SEARCH_RULE
5609: ELSIF p_rule_id=98 THEN
5610: IF NOT HZ_MATCH_RULE_98.check_staged THEN
5611: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5612: FND_MSG_PUB.ADD;
5613: RAISE FND_API.G_EXC_ERROR;
5614: END IF;

Line 5615: HZ_MATCH_RULE_98.get_matching_contact_points(

5611: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
5612: FND_MSG_PUB.ADD;
5613: RAISE FND_API.G_EXC_ERROR;
5614: END IF;
5615: HZ_MATCH_RULE_98.get_matching_contact_points(
5616: p_rule_id, p_party_id, p_contact_point_list,
5617: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5618: -- Code for Match rule HZ_CONTACT_ADV_SEARCH_MATCH_RULE
5619: ELSIF p_rule_id=99 THEN

Line 6057: IF NOT HZ_MATCH_RULE_98.check_staged THEN

6053: p_party_id, p_party_search_rec,p_party_site_list,
6054: p_contact_list, p_contact_point_list,x_search_ctx_id);
6055: -- Code for Match rule HZ_CONTACT_SIMPLE_SEARCH_RULE
6056: ELSIF p_rule_id=98 THEN
6057: IF NOT HZ_MATCH_RULE_98.check_staged THEN
6058: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6059: FND_MSG_PUB.ADD;
6060: RAISE FND_API.G_EXC_ERROR;
6061: END IF;

Line 6062: HZ_MATCH_RULE_98.get_score_details(

6058: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6059: FND_MSG_PUB.ADD;
6060: RAISE FND_API.G_EXC_ERROR;
6061: END IF;
6062: HZ_MATCH_RULE_98.get_score_details(
6063: p_rule_id,
6064: p_party_id, p_party_search_rec,p_party_site_list,
6065: p_contact_list, p_contact_point_list,x_search_ctx_id);
6066: -- Code for Match rule HZ_CONTACT_ADV_SEARCH_MATCH_RULE

Line 6450: IF NOT HZ_MATCH_RULE_98.check_staged THEN

6446: p_party_id, x_party_search_rec,x_party_site_list,
6447: x_contact_list, x_contact_point_list);
6448: -- Code for Match rule HZ_CONTACT_SIMPLE_SEARCH_RULE
6449: ELSIF p_rule_id=98 THEN
6450: IF NOT HZ_MATCH_RULE_98.check_staged THEN
6451: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6452: FND_MSG_PUB.ADD;
6453: RAISE FND_API.G_EXC_ERROR;
6454: END IF;

Line 6455: HZ_MATCH_RULE_98.get_party_for_search(

6451: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6452: FND_MSG_PUB.ADD;
6453: RAISE FND_API.G_EXC_ERROR;
6454: END IF;
6455: HZ_MATCH_RULE_98.get_party_for_search(
6456: p_party_id, x_party_search_rec,x_party_site_list,
6457: x_contact_list, x_contact_point_list);
6458: -- Code for Match rule HZ_CONTACT_ADV_SEARCH_MATCH_RULE
6459: ELSIF p_rule_id=99 THEN

Line 6842: IF NOT HZ_MATCH_RULE_98.check_staged THEN

6838: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6839: x_contact_list, x_contact_point_list);
6840: -- Code for Match rule HZ_CONTACT_SIMPLE_SEARCH_RULE
6841: ELSIF p_rule_id=98 THEN
6842: IF NOT HZ_MATCH_RULE_98.check_staged THEN
6843: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6844: FND_MSG_PUB.ADD;
6845: RAISE FND_API.G_EXC_ERROR;
6846: END IF;

Line 6847: HZ_MATCH_RULE_98.get_search_criteria(

6843: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
6844: FND_MSG_PUB.ADD;
6845: RAISE FND_API.G_EXC_ERROR;
6846: END IF;
6847: HZ_MATCH_RULE_98.get_search_criteria(
6848: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6849: x_contact_list, x_contact_point_list);
6850: -- Code for Match rule HZ_CONTACT_ADV_SEARCH_MATCH_RULE
6851: ELSIF p_rule_id=99 THEN