eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_PARTY_SEARCH dependencies on FND_LOG

Line 42: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

38: x_msg_count OUT NUMBER,
39: x_msg_data OUT VARCHAR2
40: ) IS
41: BEGIN
42: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
43: hz_utility_v2pub.debug(p_message=>'find_parties-1(+) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
44: END IF;
45: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
46: hz_utility_v2pub.debug(p_message=>'Rule ID '||x_rule_id,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);

Line 43: hz_utility_v2pub.debug(p_message=>'find_parties-1(+) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);

39: x_msg_data OUT VARCHAR2
40: ) IS
41: BEGIN
42: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
43: hz_utility_v2pub.debug(p_message=>'find_parties-1(+) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
44: END IF;
45: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
46: hz_utility_v2pub.debug(p_message=>'Rule ID '||x_rule_id,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
47: END IF;

Line 45: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

41: BEGIN
42: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
43: hz_utility_v2pub.debug(p_message=>'find_parties-1(+) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
44: END IF;
45: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
46: hz_utility_v2pub.debug(p_message=>'Rule ID '||x_rule_id,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
47: END IF;
48: find_parties(p_init_msg_list,x_rule_id,p_party_search_rec,
49: p_party_site_list,p_contact_list,p_contact_point_list,

Line 46: hz_utility_v2pub.debug(p_message=>'Rule ID '||x_rule_id,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);

42: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
43: hz_utility_v2pub.debug(p_message=>'find_parties-1(+) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
44: END IF;
45: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
46: hz_utility_v2pub.debug(p_message=>'Rule ID '||x_rule_id,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
47: END IF;
48: find_parties(p_init_msg_list,x_rule_id,p_party_search_rec,
49: p_party_site_list,p_contact_list,p_contact_point_list,
50: p_restrict_sql,NULL,p_search_merged,x_search_ctx_id,

Line 52: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

48: find_parties(p_init_msg_list,x_rule_id,p_party_search_rec,
49: p_party_site_list,p_contact_list,p_contact_point_list,
50: p_restrict_sql,NULL,p_search_merged,x_search_ctx_id,
51: x_num_matches,x_return_status,x_msg_count,x_msg_data);
52: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
53: hz_utility_v2pub.debug(p_message=>'find_parties-1(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
54: END IF;
55: END;
56:

Line 53: hz_utility_v2pub.debug(p_message=>'find_parties-1(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);

49: p_party_site_list,p_contact_list,p_contact_point_list,
50: p_restrict_sql,NULL,p_search_merged,x_search_ctx_id,
51: x_num_matches,x_return_status,x_msg_count,x_msg_data);
52: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
53: hz_utility_v2pub.debug(p_message=>'find_parties-1(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
54: END IF;
55: END;
56:
57: PROCEDURE find_parties (

Line 80: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

76: WHERE MATCH_RULE_ID = p_rule_id;
77: l_cmp_flag VARCHAR2(1);
78: BEGIN
79:
80: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
81: hz_utility_v2pub.debug(p_message=>'find_parties(+) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
82: END IF;
83: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
84: hz_utility_v2pub.debug(p_message=>'Rule ID '||p_rule_id,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);

Line 81: hz_utility_v2pub.debug(p_message=>'find_parties(+) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);

77: l_cmp_flag VARCHAR2(1);
78: BEGIN
79:
80: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
81: hz_utility_v2pub.debug(p_message=>'find_parties(+) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
82: END IF;
83: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
84: hz_utility_v2pub.debug(p_message=>'Rule ID '||p_rule_id,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
85: END IF;

Line 83: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

79:
80: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
81: hz_utility_v2pub.debug(p_message=>'find_parties(+) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
82: END IF;
83: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
84: hz_utility_v2pub.debug(p_message=>'Rule ID '||p_rule_id,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
85: END IF;
86: -- Initialize return status and message stack
87: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 84: hz_utility_v2pub.debug(p_message=>'Rule ID '||p_rule_id,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);

80: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
81: hz_utility_v2pub.debug(p_message=>'find_parties(+) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
82: END IF;
83: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
84: hz_utility_v2pub.debug(p_message=>'Rule ID '||p_rule_id,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
85: END IF;
86: -- Initialize return status and message stack
87: x_return_status := FND_API.G_RET_STS_SUCCESS;
88: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 423: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

419: -- User quality score
420: IF (fnd_profile.value('HZ_QUALITY_WEIGHTING_USER_HOOK') = 'Y') THEN
421: HZ_DQM_SEARCH_UTIL.get_quality_score ( x_search_ctx_id, p_rule_id);
422: END IF;
423: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
424: hz_utility_v2pub.debug(p_message=>'find_parties(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
425: END IF;
426: --Standard call to get message count and if count is 1, get message info
427: FND_MSG_PUB.Count_And_Get(

Line 424: hz_utility_v2pub.debug(p_message=>'find_parties(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);

420: IF (fnd_profile.value('HZ_QUALITY_WEIGHTING_USER_HOOK') = 'Y') THEN
421: HZ_DQM_SEARCH_UTIL.get_quality_score ( x_search_ctx_id, p_rule_id);
422: END IF;
423: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
424: hz_utility_v2pub.debug(p_message=>'find_parties(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
425: END IF;
426: --Standard call to get message count and if count is 1, get message info
427: FND_MSG_PUB.Count_And_Get(
428: p_encoded => FND_API.G_FALSE,

Line 481: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

477: WHERE MATCH_RULE_ID = p_rule_id;
478: l_cmp_flag VARCHAR2(1);
479: BEGIN
480:
481: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
482: hz_utility_v2pub.debug(p_message=>'find_persons(+) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
483: END IF;
484: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
485: hz_utility_v2pub.debug(p_message=>'Rule ID '||p_rule_id,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);

Line 482: hz_utility_v2pub.debug(p_message=>'find_persons(+) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);

478: l_cmp_flag VARCHAR2(1);
479: BEGIN
480:
481: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
482: hz_utility_v2pub.debug(p_message=>'find_persons(+) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
483: END IF;
484: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
485: hz_utility_v2pub.debug(p_message=>'Rule ID '||p_rule_id,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
486: END IF;

Line 484: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

480:
481: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
482: hz_utility_v2pub.debug(p_message=>'find_persons(+) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
483: END IF;
484: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
485: hz_utility_v2pub.debug(p_message=>'Rule ID '||p_rule_id,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
486: END IF;
487: -- Initialize return status and message stack
488: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 485: hz_utility_v2pub.debug(p_message=>'Rule ID '||p_rule_id,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);

481: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
482: hz_utility_v2pub.debug(p_message=>'find_persons(+) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
483: END IF;
484: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
485: hz_utility_v2pub.debug(p_message=>'Rule ID '||p_rule_id,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
486: END IF;
487: -- Initialize return status and message stack
488: x_return_status := FND_API.G_RET_STS_SUCCESS;
489: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 820: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

816: HZ_MATCH_RULE_240.find_persons(
817: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
818: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,'N',x_search_ctx_id,x_num_matches);
819: END IF;
820: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
821: hz_utility_v2pub.debug(p_message=>'find_persons(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
822: END IF;
823: --Standard call to get message count and if count is 1, get message info
824: FND_MSG_PUB.Count_And_Get(

Line 821: hz_utility_v2pub.debug(p_message=>'find_persons(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);

817: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
818: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,'N',x_search_ctx_id,x_num_matches);
819: END IF;
820: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
821: hz_utility_v2pub.debug(p_message=>'find_persons(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
822: END IF;
823: --Standard call to get message count and if count is 1, get message info
824: FND_MSG_PUB.Count_And_Get(
825: p_encoded => FND_API.G_FALSE,

Line 899: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

895: FROM HZ_MATCH_RULES_VL
896: WHERE MATCH_RULE_ID = p_rule_id;
897: l_cmp_flag VARCHAR2(1);
898: BEGIN
899: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
900: hz_utility_v2pub.debug(p_message=>'find_party_details(+)',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
901: END IF;
902: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
903: hz_utility_v2pub.debug(p_message=>'Rule ID '||p_rule_id,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);

Line 900: hz_utility_v2pub.debug(p_message=>'find_party_details(+)',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);

896: WHERE MATCH_RULE_ID = p_rule_id;
897: l_cmp_flag VARCHAR2(1);
898: BEGIN
899: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
900: hz_utility_v2pub.debug(p_message=>'find_party_details(+)',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
901: END IF;
902: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
903: hz_utility_v2pub.debug(p_message=>'Rule ID '||p_rule_id,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
904: END IF;

Line 902: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

898: BEGIN
899: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
900: hz_utility_v2pub.debug(p_message=>'find_party_details(+)',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
901: END IF;
902: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
903: hz_utility_v2pub.debug(p_message=>'Rule ID '||p_rule_id,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
904: END IF;
905:
906: -- Initialize return status and message stack

Line 903: hz_utility_v2pub.debug(p_message=>'Rule ID '||p_rule_id,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);

899: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
900: hz_utility_v2pub.debug(p_message=>'find_party_details(+)',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
901: END IF;
902: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
903: hz_utility_v2pub.debug(p_message=>'Rule ID '||p_rule_id,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
904: END IF;
905:
906: -- Initialize return status and message stack
907: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1239: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1235: HZ_MATCH_RULE_240.find_party_details(
1236: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
1237: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
1238: END IF;
1239: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1240: hz_utility_v2pub.debug(p_message=>'find_party_details(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
1241: END IF;
1242: --Standard call to get message count and if count is 1, get message info
1243: FND_MSG_PUB.Count_And_Get(

Line 1240: hz_utility_v2pub.debug(p_message=>'find_party_details(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);

1236: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
1237: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
1238: END IF;
1239: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1240: hz_utility_v2pub.debug(p_message=>'find_party_details(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
1241: END IF;
1242: --Standard call to get message count and if count is 1, get message info
1243: FND_MSG_PUB.Count_And_Get(
1244: p_encoded => FND_API.G_FALSE,

Line 1295: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1291: FROM HZ_MATCH_RULES_VL
1292: WHERE MATCH_RULE_ID = p_rule_id;
1293: l_cmp_flag VARCHAR2(1);
1294: BEGIN
1295: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1296: hz_utility_v2pub.debug(p_message=>'find_duplicate_parties(+) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
1297: END IF;
1298: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1299: hz_utility_v2pub.debug(p_message=>'Rule ID '||p_rule_id,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);

Line 1296: hz_utility_v2pub.debug(p_message=>'find_duplicate_parties(+) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);

1292: WHERE MATCH_RULE_ID = p_rule_id;
1293: l_cmp_flag VARCHAR2(1);
1294: BEGIN
1295: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1296: hz_utility_v2pub.debug(p_message=>'find_duplicate_parties(+) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
1297: END IF;
1298: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1299: hz_utility_v2pub.debug(p_message=>'Rule ID '||p_rule_id,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
1300: END IF;

Line 1298: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

1294: BEGIN
1295: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1296: hz_utility_v2pub.debug(p_message=>'find_duplicate_parties(+) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
1297: END IF;
1298: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1299: hz_utility_v2pub.debug(p_message=>'Rule ID '||p_rule_id,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
1300: END IF;
1301:
1302: -- Initialize return status and message stack

Line 1299: hz_utility_v2pub.debug(p_message=>'Rule ID '||p_rule_id,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);

1295: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1296: hz_utility_v2pub.debug(p_message=>'find_duplicate_parties(+) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
1297: END IF;
1298: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1299: hz_utility_v2pub.debug(p_message=>'Rule ID '||p_rule_id,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
1300: END IF;
1301:
1302: -- Initialize return status and message stack
1303: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1639: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1635: HZ_MATCH_RULE_240.find_duplicate_parties(
1636: p_rule_id,p_party_id,
1637: p_restrict_sql,p_match_type,p_dup_batch_id,p_search_merged,x_dup_set_id, x_search_ctx_id,x_num_matches);
1638: END IF;
1639: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1640: hz_utility_v2pub.debug(p_message=>'find_duplicate_parties(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
1641: END IF;
1642: --Standard call to get message count and if count is 1, get message info
1643: FND_MSG_PUB.Count_And_Get(

Line 1640: hz_utility_v2pub.debug(p_message=>'find_duplicate_parties(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);

1636: p_rule_id,p_party_id,
1637: p_restrict_sql,p_match_type,p_dup_batch_id,p_search_merged,x_dup_set_id, x_search_ctx_id,x_num_matches);
1638: END IF;
1639: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1640: hz_utility_v2pub.debug(p_message=>'find_duplicate_parties(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
1641: END IF;
1642: --Standard call to get message count and if count is 1, get message info
1643: FND_MSG_PUB.Count_And_Get(
1644: p_encoded => FND_API.G_FALSE,

Line 1694: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1690: FROM HZ_MATCH_RULES_VL
1691: WHERE MATCH_RULE_ID = p_rule_id;
1692: l_cmp_flag VARCHAR2(1);
1693: BEGIN
1694: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1695: hz_utility_v2pub.debug(p_message=>'find_duplicate_party_sites(+) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
1696: END IF;
1697: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1698: hz_utility_v2pub.debug(p_message=>'Rule ID '||p_rule_id,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);

Line 1695: hz_utility_v2pub.debug(p_message=>'find_duplicate_party_sites(+) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);

1691: WHERE MATCH_RULE_ID = p_rule_id;
1692: l_cmp_flag VARCHAR2(1);
1693: BEGIN
1694: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1695: hz_utility_v2pub.debug(p_message=>'find_duplicate_party_sites(+) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
1696: END IF;
1697: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1698: hz_utility_v2pub.debug(p_message=>'Rule ID '||p_rule_id,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
1699: END IF;

Line 1697: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

1693: BEGIN
1694: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1695: hz_utility_v2pub.debug(p_message=>'find_duplicate_party_sites(+) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
1696: END IF;
1697: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1698: hz_utility_v2pub.debug(p_message=>'Rule ID '||p_rule_id,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
1699: END IF;
1700:
1701: -- Initialize return status and message stack

Line 1698: hz_utility_v2pub.debug(p_message=>'Rule ID '||p_rule_id,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);

1694: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1695: hz_utility_v2pub.debug(p_message=>'find_duplicate_party_sites(+) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
1696: END IF;
1697: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1698: hz_utility_v2pub.debug(p_message=>'Rule ID '||p_rule_id,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
1699: END IF;
1700:
1701: -- Initialize return status and message stack
1702: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2034: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

2030: HZ_MATCH_RULE_240.find_duplicate_party_sites(
2031: p_rule_id,p_party_site_id,p_party_id,
2032: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2033: END IF;
2034: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2035: hz_utility_v2pub.debug(p_message=>'find_duplicate_party_sites(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
2036: END IF;
2037: --Standard call to get message count and if count is 1, get message info
2038: FND_MSG_PUB.Count_And_Get(

Line 2035: hz_utility_v2pub.debug(p_message=>'find_duplicate_party_sites(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);

2031: p_rule_id,p_party_site_id,p_party_id,
2032: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2033: END IF;
2034: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2035: hz_utility_v2pub.debug(p_message=>'find_duplicate_party_sites(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
2036: END IF;
2037: --Standard call to get message count and if count is 1, get message info
2038: FND_MSG_PUB.Count_And_Get(
2039: p_encoded => FND_API.G_FALSE,

Line 2088: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

2084: FROM HZ_MATCH_RULES_VL
2085: WHERE MATCH_RULE_ID = p_rule_id;
2086: l_cmp_flag VARCHAR2(1);
2087: BEGIN
2088: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2089: hz_utility_v2pub.debug(p_message=>'find_duplicate_contacts(+) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
2090: END IF;
2091: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2092: hz_utility_v2pub.debug(p_message=>'Rule ID '||p_rule_id,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);

Line 2089: hz_utility_v2pub.debug(p_message=>'find_duplicate_contacts(+) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);

2085: WHERE MATCH_RULE_ID = p_rule_id;
2086: l_cmp_flag VARCHAR2(1);
2087: BEGIN
2088: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2089: hz_utility_v2pub.debug(p_message=>'find_duplicate_contacts(+) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
2090: END IF;
2091: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2092: hz_utility_v2pub.debug(p_message=>'Rule ID '||p_rule_id,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2093: END IF;

Line 2091: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

2087: BEGIN
2088: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2089: hz_utility_v2pub.debug(p_message=>'find_duplicate_contacts(+) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
2090: END IF;
2091: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2092: hz_utility_v2pub.debug(p_message=>'Rule ID '||p_rule_id,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2093: END IF;
2094:
2095: -- Initialize return status and message stack

Line 2092: hz_utility_v2pub.debug(p_message=>'Rule ID '||p_rule_id,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);

2088: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2089: hz_utility_v2pub.debug(p_message=>'find_duplicate_contacts(+) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
2090: END IF;
2091: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2092: hz_utility_v2pub.debug(p_message=>'Rule ID '||p_rule_id,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2093: END IF;
2094:
2095: -- Initialize return status and message stack
2096: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2428: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

2424: HZ_MATCH_RULE_240.find_duplicate_contacts(
2425: p_rule_id,p_org_contact_id,p_party_id,
2426: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2427: END IF;
2428: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2429: hz_utility_v2pub.debug(p_message=>'find_duplicate_contacts(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
2430: END IF;
2431: --Standard call to get message count and if count is 1, get message info
2432: FND_MSG_PUB.Count_And_Get(

Line 2429: hz_utility_v2pub.debug(p_message=>'find_duplicate_contacts(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);

2425: p_rule_id,p_org_contact_id,p_party_id,
2426: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2427: END IF;
2428: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2429: hz_utility_v2pub.debug(p_message=>'find_duplicate_contacts(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
2430: END IF;
2431: --Standard call to get message count and if count is 1, get message info
2432: FND_MSG_PUB.Count_And_Get(
2433: p_encoded => FND_API.G_FALSE,

Line 2482: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

2478: FROM HZ_MATCH_RULES_VL
2479: WHERE MATCH_RULE_ID = p_rule_id;
2480: l_cmp_flag VARCHAR2(1);
2481: BEGIN
2482: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2483: hz_utility_v2pub.debug(p_message=>'find_duplicate_contact_points(+) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
2484: END IF;
2485: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2486: hz_utility_v2pub.debug(p_message=>'Rule ID '||p_rule_id,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);

Line 2483: hz_utility_v2pub.debug(p_message=>'find_duplicate_contact_points(+) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);

2479: WHERE MATCH_RULE_ID = p_rule_id;
2480: l_cmp_flag VARCHAR2(1);
2481: BEGIN
2482: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2483: hz_utility_v2pub.debug(p_message=>'find_duplicate_contact_points(+) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
2484: END IF;
2485: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2486: hz_utility_v2pub.debug(p_message=>'Rule ID '||p_rule_id,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2487: END IF;

Line 2485: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

2481: BEGIN
2482: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2483: hz_utility_v2pub.debug(p_message=>'find_duplicate_contact_points(+) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
2484: END IF;
2485: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2486: hz_utility_v2pub.debug(p_message=>'Rule ID '||p_rule_id,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2487: END IF;
2488:
2489: -- Initialize return status and message stack

Line 2486: hz_utility_v2pub.debug(p_message=>'Rule ID '||p_rule_id,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);

2482: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2483: hz_utility_v2pub.debug(p_message=>'find_duplicate_contact_points(+) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
2484: END IF;
2485: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2486: hz_utility_v2pub.debug(p_message=>'Rule ID '||p_rule_id,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2487: END IF;
2488:
2489: -- Initialize return status and message stack
2490: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2822: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

2818: HZ_MATCH_RULE_240.find_duplicate_contact_points(
2819: p_rule_id,p_contact_point_id,p_party_id,
2820: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2821: END IF;
2822: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2823: hz_utility_v2pub.debug(p_message=>'find_duplicate_contact_points(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
2824: END IF;
2825: --Standard call to get message count and if count is 1, get message info
2826: FND_MSG_PUB.Count_And_Get(

Line 2823: hz_utility_v2pub.debug(p_message=>'find_duplicate_contact_points(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);

2819: p_rule_id,p_contact_point_id,p_party_id,
2820: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2821: END IF;
2822: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2823: hz_utility_v2pub.debug(p_message=>'find_duplicate_contact_points(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
2824: END IF;
2825: --Standard call to get message count and if count is 1, get message info
2826: FND_MSG_PUB.Count_And_Get(
2827: p_encoded => FND_API.G_FALSE,

Line 2916: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

2912: FROM HZ_MATCH_RULES_VL
2913: WHERE MATCH_RULE_ID = p_rule_id;
2914: l_cmp_flag VARCHAR2(1);
2915: BEGIN
2916: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2917: hz_utility_v2pub.debug(p_message=>'find_parties_dynamic(+) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
2918: END IF;
2919: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2920: hz_utility_v2pub.debug(p_message=>'Rule ID '||p_rule_id,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);

Line 2917: hz_utility_v2pub.debug(p_message=>'find_parties_dynamic(+) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);

2913: WHERE MATCH_RULE_ID = p_rule_id;
2914: l_cmp_flag VARCHAR2(1);
2915: BEGIN
2916: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2917: hz_utility_v2pub.debug(p_message=>'find_parties_dynamic(+) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
2918: END IF;
2919: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2920: hz_utility_v2pub.debug(p_message=>'Rule ID '||p_rule_id,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2921: END IF;

Line 2919: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

2915: BEGIN
2916: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2917: hz_utility_v2pub.debug(p_message=>'find_parties_dynamic(+) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
2918: END IF;
2919: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2920: hz_utility_v2pub.debug(p_message=>'Rule ID '||p_rule_id,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2921: END IF;
2922:
2923: -- Initialize return status and message stack

Line 2920: hz_utility_v2pub.debug(p_message=>'Rule ID '||p_rule_id,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);

2916: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2917: hz_utility_v2pub.debug(p_message=>'find_parties_dynamic(+) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
2918: END IF;
2919: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2920: hz_utility_v2pub.debug(p_message=>'Rule ID '||p_rule_id,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2921: END IF;
2922:
2923: -- Initialize return status and message stack
2924: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3504: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

3500: p_attrib_val11,p_attrib_val12,p_attrib_val13,p_attrib_val14,p_attrib_val15,
3501: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3502: p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
3503: END IF;
3504: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3505: hz_utility_v2pub.debug(p_message=>'find_parties_dynamic(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
3506: END IF;
3507: --Standard call to get message count and if count is 1, get message info
3508: FND_MSG_PUB.Count_And_Get(

Line 3505: hz_utility_v2pub.debug(p_message=>'find_parties_dynamic(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);

3501: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3502: p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
3503: END IF;
3504: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3505: hz_utility_v2pub.debug(p_message=>'find_parties_dynamic(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
3506: END IF;
3507: --Standard call to get message count and if count is 1, get message info
3508: FND_MSG_PUB.Count_And_Get(
3509: p_encoded => FND_API.G_FALSE,

Line 3599: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

3595: FROM HZ_MATCH_RULES_VL
3596: WHERE MATCH_RULE_ID = p_rule_id;
3597: l_cmp_flag VARCHAR2(1);
3598: BEGIN
3599: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3600: hz_utility_v2pub.debug(p_message=>'find_parties_dynamic(+) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
3601: END IF;
3602: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3603: hz_utility_v2pub.debug(p_message=>'Rule ID '||p_rule_id,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);

Line 3600: hz_utility_v2pub.debug(p_message=>'find_parties_dynamic(+) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);

3596: WHERE MATCH_RULE_ID = p_rule_id;
3597: l_cmp_flag VARCHAR2(1);
3598: BEGIN
3599: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3600: hz_utility_v2pub.debug(p_message=>'find_parties_dynamic(+) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
3601: END IF;
3602: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3603: hz_utility_v2pub.debug(p_message=>'Rule ID '||p_rule_id,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
3604: END IF;

Line 3602: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

3598: BEGIN
3599: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3600: hz_utility_v2pub.debug(p_message=>'find_parties_dynamic(+) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
3601: END IF;
3602: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3603: hz_utility_v2pub.debug(p_message=>'Rule ID '||p_rule_id,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
3604: END IF;
3605:
3606: -- Initialize return status and message stack

Line 3603: hz_utility_v2pub.debug(p_message=>'Rule ID '||p_rule_id,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);

3599: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3600: hz_utility_v2pub.debug(p_message=>'find_parties_dynamic(+) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
3601: END IF;
3602: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3603: hz_utility_v2pub.debug(p_message=>'Rule ID '||p_rule_id,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
3604: END IF;
3605:
3606: -- Initialize return status and message stack
3607: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 4187: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

4183: p_attrib_val11,p_attrib_val12,p_attrib_val13,p_attrib_val14,p_attrib_val15,
4184: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
4185: p_restrict_sql,p_api_name,p_match_type,p_party_id,p_search_merged,x_search_ctx_id,x_num_matches);
4186: END IF;
4187: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4188: hz_utility_v2pub.debug(p_message=>'call_api_dynamic(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
4189: END IF;
4190: --Standard call to get message count and if count is 1, get message info
4191: FND_MSG_PUB.Count_And_Get(

Line 4188: hz_utility_v2pub.debug(p_message=>'call_api_dynamic(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);

4184: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
4185: p_restrict_sql,p_api_name,p_match_type,p_party_id,p_search_merged,x_search_ctx_id,x_num_matches);
4186: END IF;
4187: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4188: hz_utility_v2pub.debug(p_message=>'call_api_dynamic(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
4189: END IF;
4190: --Standard call to get message count and if count is 1, get message info
4191: FND_MSG_PUB.Count_And_Get(
4192: p_encoded => FND_API.G_FALSE,

Line 4316: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

4312: l_attrib_id18 NUMBER;
4313: l_attrib_id19 NUMBER;
4314: l_attrib_id20 NUMBER;
4315: BEGIN
4316: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4317: hz_utility_v2pub.debug(p_message=>'call_api_dynamic_names(+) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
4318: END IF;
4319: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4320: hz_utility_v2pub.debug(p_message=>'Rule ID '||p_rule_id ,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);

Line 4317: hz_utility_v2pub.debug(p_message=>'call_api_dynamic_names(+) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);

4313: l_attrib_id19 NUMBER;
4314: l_attrib_id20 NUMBER;
4315: BEGIN
4316: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4317: hz_utility_v2pub.debug(p_message=>'call_api_dynamic_names(+) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
4318: END IF;
4319: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4320: hz_utility_v2pub.debug(p_message=>'Rule ID '||p_rule_id ,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
4321: END IF;

Line 4319: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

4315: BEGIN
4316: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4317: hz_utility_v2pub.debug(p_message=>'call_api_dynamic_names(+) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
4318: END IF;
4319: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4320: hz_utility_v2pub.debug(p_message=>'Rule ID '||p_rule_id ,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
4321: END IF;
4322:
4323: IF (p_attrib_name1 IS NOT NULL) THEN

Line 4320: hz_utility_v2pub.debug(p_message=>'Rule ID '||p_rule_id ,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);

4316: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4317: hz_utility_v2pub.debug(p_message=>'call_api_dynamic_names(+) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
4318: END IF;
4319: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4320: hz_utility_v2pub.debug(p_message=>'Rule ID '||p_rule_id ,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
4321: END IF;
4322:
4323: IF (p_attrib_name1 IS NOT NULL) THEN
4324: l_attrib_id1 := get_attrib_id(p_attrib_name1);

Line 4395: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

4391: p_attrib_val11,p_attrib_val12,p_attrib_val13,p_attrib_val14,p_attrib_val15,
4392: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
4393: p_restrict_sql,p_api_name,p_match_type,p_party_id,p_search_merged,
4394: x_search_ctx_id,x_num_matches, x_return_status, x_msg_count, x_msg_data);
4395: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4396: hz_utility_v2pub.debug(p_message=>'call_api_dynamic_names(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
4397: END IF;
4398: --Standard call to get message count and if count is 1, get message info
4399: FND_MSG_PUB.Count_And_Get(

Line 4396: hz_utility_v2pub.debug(p_message=>'call_api_dynamic_names(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);

4392: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
4393: p_restrict_sql,p_api_name,p_match_type,p_party_id,p_search_merged,
4394: x_search_ctx_id,x_num_matches, x_return_status, x_msg_count, x_msg_data);
4395: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4396: hz_utility_v2pub.debug(p_message=>'call_api_dynamic_names(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
4397: END IF;
4398: --Standard call to get message count and if count is 1, get message info
4399: FND_MSG_PUB.Count_And_Get(
4400: p_encoded => FND_API.G_FALSE,

Line 4442: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

4438: x_msg_data OUT VARCHAR2
4439: ) IS
4440: l_num_matches NUMBER;
4441: BEGIN
4442: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4443: hz_utility_v2pub.debug(p_message=>'get_matching_party_sites-1(+) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
4444: END IF;
4445: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4446: hz_utility_v2pub.debug(p_message=>'Rule ID '||p_rule_id,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);

Line 4443: hz_utility_v2pub.debug(p_message=>'get_matching_party_sites-1(+) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);

4439: ) IS
4440: l_num_matches NUMBER;
4441: BEGIN
4442: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4443: hz_utility_v2pub.debug(p_message=>'get_matching_party_sites-1(+) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
4444: END IF;
4445: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4446: hz_utility_v2pub.debug(p_message=>'Rule ID '||p_rule_id,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
4447: END IF;

Line 4445: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

4441: BEGIN
4442: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4443: hz_utility_v2pub.debug(p_message=>'get_matching_party_sites-1(+) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
4444: END IF;
4445: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4446: hz_utility_v2pub.debug(p_message=>'Rule ID '||p_rule_id,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
4447: END IF;
4448: get_matching_party_sites(p_init_msg_list,p_rule_id,p_party_id,
4449: p_party_site_list,p_contact_point_list,

Line 4446: hz_utility_v2pub.debug(p_message=>'Rule ID '||p_rule_id,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);

4442: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4443: hz_utility_v2pub.debug(p_message=>'get_matching_party_sites-1(+) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
4444: END IF;
4445: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4446: hz_utility_v2pub.debug(p_message=>'Rule ID '||p_rule_id,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
4447: END IF;
4448: get_matching_party_sites(p_init_msg_list,p_rule_id,p_party_id,
4449: p_party_site_list,p_contact_point_list,
4450: NULL,NULL,x_search_ctx_id,

Line 4452: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

4448: get_matching_party_sites(p_init_msg_list,p_rule_id,p_party_id,
4449: p_party_site_list,p_contact_point_list,
4450: NULL,NULL,x_search_ctx_id,
4451: l_num_matches,x_return_status,x_msg_count,x_msg_data);
4452: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4453: hz_utility_v2pub.debug(p_message=>'get_matching_party_sites-1(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
4454: END IF;
4455: END;
4456: PROCEDURE get_matching_party_sites (

Line 4453: hz_utility_v2pub.debug(p_message=>'get_matching_party_sites-1(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);

4449: p_party_site_list,p_contact_point_list,
4450: NULL,NULL,x_search_ctx_id,
4451: l_num_matches,x_return_status,x_msg_count,x_msg_data);
4452: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4453: hz_utility_v2pub.debug(p_message=>'get_matching_party_sites-1(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
4454: END IF;
4455: END;
4456: PROCEDURE get_matching_party_sites (
4457: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,

Line 4476: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

4472: FROM HZ_MATCH_RULES_VL
4473: WHERE MATCH_RULE_ID = p_rule_id;
4474: l_cmp_flag VARCHAR2(1);
4475: BEGIN
4476: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4477: hz_utility_v2pub.debug(p_message=>'get_matching_party_sites(+) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
4478: END IF;
4479: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4480: hz_utility_v2pub.debug(p_message=>'Rule ID '||p_rule_id,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);

Line 4477: hz_utility_v2pub.debug(p_message=>'get_matching_party_sites(+) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);

4473: WHERE MATCH_RULE_ID = p_rule_id;
4474: l_cmp_flag VARCHAR2(1);
4475: BEGIN
4476: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4477: hz_utility_v2pub.debug(p_message=>'get_matching_party_sites(+) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
4478: END IF;
4479: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4480: hz_utility_v2pub.debug(p_message=>'Rule ID '||p_rule_id,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
4481: END IF;

Line 4479: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

4475: BEGIN
4476: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4477: hz_utility_v2pub.debug(p_message=>'get_matching_party_sites(+) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
4478: END IF;
4479: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4480: hz_utility_v2pub.debug(p_message=>'Rule ID '||p_rule_id,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
4481: END IF;
4482:
4483: -- Initialize return status and message stack

Line 4480: hz_utility_v2pub.debug(p_message=>'Rule ID '||p_rule_id,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);

4476: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4477: hz_utility_v2pub.debug(p_message=>'get_matching_party_sites(+) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
4478: END IF;
4479: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4480: hz_utility_v2pub.debug(p_message=>'Rule ID '||p_rule_id,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
4481: END IF;
4482:
4483: -- Initialize return status and message stack
4484: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 4813: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

4809: HZ_MATCH_RULE_240.get_matching_party_sites(
4810: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4811: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4812: END IF;
4813: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4814: hz_utility_v2pub.debug(p_message=>'get_matching_party_sites(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
4815: END IF;
4816: --Standard call to get message count and if count is 1, get message info
4817: FND_MSG_PUB.Count_And_Get(

Line 4814: hz_utility_v2pub.debug(p_message=>'get_matching_party_sites(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);

4810: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4811: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4812: END IF;
4813: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4814: hz_utility_v2pub.debug(p_message=>'get_matching_party_sites(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
4815: END IF;
4816: --Standard call to get message count and if count is 1, get message info
4817: FND_MSG_PUB.Count_And_Get(
4818: p_encoded => FND_API.G_FALSE,

Line 4861: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

4857: x_msg_data OUT VARCHAR2
4858: ) IS
4859: l_num_matches NUMBER;
4860: BEGIN
4861: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4862: hz_utility_v2pub.debug(p_message=>'get_matching_contacts-1(+) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
4863: END IF;
4864: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4865: hz_utility_v2pub.debug(p_message=>'Rule ID '||p_rule_id,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);

Line 4862: hz_utility_v2pub.debug(p_message=>'get_matching_contacts-1(+) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);

4858: ) IS
4859: l_num_matches NUMBER;
4860: BEGIN
4861: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4862: hz_utility_v2pub.debug(p_message=>'get_matching_contacts-1(+) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
4863: END IF;
4864: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4865: hz_utility_v2pub.debug(p_message=>'Rule ID '||p_rule_id,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
4866: END IF;

Line 4864: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

4860: BEGIN
4861: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4862: hz_utility_v2pub.debug(p_message=>'get_matching_contacts-1(+) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
4863: END IF;
4864: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4865: hz_utility_v2pub.debug(p_message=>'Rule ID '||p_rule_id,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
4866: END IF;
4867: get_matching_contacts(p_init_msg_list,p_rule_id,p_party_id,
4868: p_contact_list,p_contact_point_list,

Line 4865: hz_utility_v2pub.debug(p_message=>'Rule ID '||p_rule_id,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);

4861: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4862: hz_utility_v2pub.debug(p_message=>'get_matching_contacts-1(+) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
4863: END IF;
4864: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4865: hz_utility_v2pub.debug(p_message=>'Rule ID '||p_rule_id,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
4866: END IF;
4867: get_matching_contacts(p_init_msg_list,p_rule_id,p_party_id,
4868: p_contact_list,p_contact_point_list,
4869: NULL,NULL,x_search_ctx_id,

Line 4871: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

4867: get_matching_contacts(p_init_msg_list,p_rule_id,p_party_id,
4868: p_contact_list,p_contact_point_list,
4869: NULL,NULL,x_search_ctx_id,
4870: l_num_matches,x_return_status,x_msg_count,x_msg_data);
4871: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4872: hz_utility_v2pub.debug(p_message=>'get_matching_contacts-1(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
4873: END IF;
4874: END;
4875: PROCEDURE get_matching_contacts (

Line 4872: hz_utility_v2pub.debug(p_message=>'get_matching_contacts-1(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);

4868: p_contact_list,p_contact_point_list,
4869: NULL,NULL,x_search_ctx_id,
4870: l_num_matches,x_return_status,x_msg_count,x_msg_data);
4871: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4872: hz_utility_v2pub.debug(p_message=>'get_matching_contacts-1(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
4873: END IF;
4874: END;
4875: PROCEDURE get_matching_contacts (
4876: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,

Line 4895: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

4891: FROM HZ_MATCH_RULES_VL
4892: WHERE MATCH_RULE_ID = p_rule_id;
4893: l_cmp_flag VARCHAR2(1);
4894: BEGIN
4895: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4896: hz_utility_v2pub.debug(p_message=>'get_matching_contacts(+) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
4897: END IF;
4898: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4899: hz_utility_v2pub.debug(p_message=>'Rule ID '||p_rule_id,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);

Line 4896: hz_utility_v2pub.debug(p_message=>'get_matching_contacts(+) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);

4892: WHERE MATCH_RULE_ID = p_rule_id;
4893: l_cmp_flag VARCHAR2(1);
4894: BEGIN
4895: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4896: hz_utility_v2pub.debug(p_message=>'get_matching_contacts(+) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
4897: END IF;
4898: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4899: hz_utility_v2pub.debug(p_message=>'Rule ID '||p_rule_id,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
4900: END IF;

Line 4898: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

4894: BEGIN
4895: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4896: hz_utility_v2pub.debug(p_message=>'get_matching_contacts(+) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
4897: END IF;
4898: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4899: hz_utility_v2pub.debug(p_message=>'Rule ID '||p_rule_id,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
4900: END IF;
4901:
4902: -- Initialize return status and message stack

Line 4899: hz_utility_v2pub.debug(p_message=>'Rule ID '||p_rule_id,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);

4895: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4896: hz_utility_v2pub.debug(p_message=>'get_matching_contacts(+) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
4897: END IF;
4898: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4899: hz_utility_v2pub.debug(p_message=>'Rule ID '||p_rule_id,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
4900: END IF;
4901:
4902: -- Initialize return status and message stack
4903: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 5262: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

5258: FND_MSG_PUB.Count_And_Get(
5259: p_encoded => FND_API.G_FALSE,
5260: p_count => x_msg_count,
5261: p_data => x_msg_data);
5262: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5263: hz_utility_v2pub.debug(p_message=>'get_matching_contacts(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
5264: END IF;
5265: END;
5266:

Line 5263: hz_utility_v2pub.debug(p_message=>'get_matching_contacts(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);

5259: p_encoded => FND_API.G_FALSE,
5260: p_count => x_msg_count,
5261: p_data => x_msg_data);
5262: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5263: hz_utility_v2pub.debug(p_message=>'get_matching_contacts(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
5264: END IF;
5265: END;
5266:
5267: PROCEDURE get_matching_contact_points (

Line 5279: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

5275: x_msg_data OUT VARCHAR2
5276: ) IS
5277: l_num_matches NUMBER;
5278: BEGIN
5279: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5280: hz_utility_v2pub.debug(p_message=>'get_matching_contact_points-1(+) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
5281: END IF;
5282: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
5283: hz_utility_v2pub.debug(p_message=>'Rule ID '||p_rule_id,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);

Line 5280: hz_utility_v2pub.debug(p_message=>'get_matching_contact_points-1(+) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);

5276: ) IS
5277: l_num_matches NUMBER;
5278: BEGIN
5279: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5280: hz_utility_v2pub.debug(p_message=>'get_matching_contact_points-1(+) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
5281: END IF;
5282: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
5283: hz_utility_v2pub.debug(p_message=>'Rule ID '||p_rule_id,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
5284: END IF;

Line 5282: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

5278: BEGIN
5279: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5280: hz_utility_v2pub.debug(p_message=>'get_matching_contact_points-1(+) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
5281: END IF;
5282: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
5283: hz_utility_v2pub.debug(p_message=>'Rule ID '||p_rule_id,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
5284: END IF;
5285: get_matching_contact_points(p_init_msg_list,p_rule_id,p_party_id,
5286: p_contact_point_list,

Line 5283: hz_utility_v2pub.debug(p_message=>'Rule ID '||p_rule_id,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);

5279: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5280: hz_utility_v2pub.debug(p_message=>'get_matching_contact_points-1(+) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
5281: END IF;
5282: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
5283: hz_utility_v2pub.debug(p_message=>'Rule ID '||p_rule_id,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
5284: END IF;
5285: get_matching_contact_points(p_init_msg_list,p_rule_id,p_party_id,
5286: p_contact_point_list,
5287: NULL,NULL,x_search_ctx_id,

Line 5289: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

5285: get_matching_contact_points(p_init_msg_list,p_rule_id,p_party_id,
5286: p_contact_point_list,
5287: NULL,NULL,x_search_ctx_id,
5288: l_num_matches,x_return_status,x_msg_count,x_msg_data);
5289: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5290: hz_utility_v2pub.debug(p_message=>'get_matching_contact_points-1(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
5291: END IF;
5292: END;
5293: PROCEDURE get_matching_contact_points (

Line 5290: hz_utility_v2pub.debug(p_message=>'get_matching_contact_points-1(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);

5286: p_contact_point_list,
5287: NULL,NULL,x_search_ctx_id,
5288: l_num_matches,x_return_status,x_msg_count,x_msg_data);
5289: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5290: hz_utility_v2pub.debug(p_message=>'get_matching_contact_points-1(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
5291: END IF;
5292: END;
5293: PROCEDURE get_matching_contact_points (
5294: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,

Line 5312: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

5308: FROM HZ_MATCH_RULES_VL
5309: WHERE MATCH_RULE_ID = p_rule_id;
5310: l_cmp_flag VARCHAR2(1);
5311: BEGIN
5312: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5313: hz_utility_v2pub.debug(p_message=>'get_matching_contact_points(+) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
5314: END IF;
5315: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
5316: hz_utility_v2pub.debug(p_message=>'Rule ID '||p_rule_id,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);

Line 5313: hz_utility_v2pub.debug(p_message=>'get_matching_contact_points(+) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);

5309: WHERE MATCH_RULE_ID = p_rule_id;
5310: l_cmp_flag VARCHAR2(1);
5311: BEGIN
5312: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5313: hz_utility_v2pub.debug(p_message=>'get_matching_contact_points(+) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
5314: END IF;
5315: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
5316: hz_utility_v2pub.debug(p_message=>'Rule ID '||p_rule_id,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
5317: END IF;

Line 5315: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

5311: BEGIN
5312: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5313: hz_utility_v2pub.debug(p_message=>'get_matching_contact_points(+) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
5314: END IF;
5315: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
5316: hz_utility_v2pub.debug(p_message=>'Rule ID '||p_rule_id,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
5317: END IF;
5318:
5319: -- Initialize return status and message stack

Line 5316: hz_utility_v2pub.debug(p_message=>'Rule ID '||p_rule_id,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);

5312: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5313: hz_utility_v2pub.debug(p_message=>'get_matching_contact_points(+) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
5314: END IF;
5315: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
5316: hz_utility_v2pub.debug(p_message=>'Rule ID '||p_rule_id,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
5317: END IF;
5318:
5319: -- Initialize return status and message stack
5320: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 5649: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

5645: HZ_MATCH_RULE_240.get_matching_contact_points(
5646: p_rule_id, p_party_id, p_contact_point_list,
5647: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5648: END IF;
5649: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5650: hz_utility_v2pub.debug(p_message=>'get_matching_contact_points(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
5651: END IF;
5652: --Standard call to get message count and if count is 1, get message info
5653: FND_MSG_PUB.Count_And_Get(

Line 5650: hz_utility_v2pub.debug(p_message=>'get_matching_contact_points(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);

5646: p_rule_id, p_party_id, p_contact_point_list,
5647: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5648: END IF;
5649: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5650: hz_utility_v2pub.debug(p_message=>'get_matching_contact_points(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
5651: END IF;
5652: --Standard call to get message count and if count is 1, get message info
5653: FND_MSG_PUB.Count_And_Get(
5654: p_encoded => FND_API.G_FALSE,

Line 5699: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

5695: x_msg_data OUT VARCHAR2
5696: ) IS
5697: l_search_ctx_id NUMBER;
5698: BEGIN
5699: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5700: hz_utility_v2pub.debug(p_message=>'get_party_score_details(+) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
5701: END IF;
5702: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
5703: hz_utility_v2pub.debug(p_message=>'Rule ID '||p_rule_id,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);

Line 5700: hz_utility_v2pub.debug(p_message=>'get_party_score_details(+) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);

5696: ) IS
5697: l_search_ctx_id NUMBER;
5698: BEGIN
5699: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5700: hz_utility_v2pub.debug(p_message=>'get_party_score_details(+) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
5701: END IF;
5702: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
5703: hz_utility_v2pub.debug(p_message=>'Rule ID '||p_rule_id,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
5704: END IF;

Line 5702: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

5698: BEGIN
5699: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5700: hz_utility_v2pub.debug(p_message=>'get_party_score_details(+) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
5701: END IF;
5702: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
5703: hz_utility_v2pub.debug(p_message=>'Rule ID '||p_rule_id,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
5704: END IF;
5705: l_search_ctx_id:=p_search_ctx_id;
5706: get_score_details(p_init_msg_list,p_rule_id,p_party_id,

Line 5703: hz_utility_v2pub.debug(p_message=>'Rule ID '||p_rule_id,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);

5699: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5700: hz_utility_v2pub.debug(p_message=>'get_party_score_details(+) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
5701: END IF;
5702: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
5703: hz_utility_v2pub.debug(p_message=>'Rule ID '||p_rule_id,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
5704: END IF;
5705: l_search_ctx_id:=p_search_ctx_id;
5706: get_score_details(p_init_msg_list,p_rule_id,p_party_id,
5707: p_party_search_rec,p_party_site_list,p_contact_list,p_contact_point_list,

Line 5709: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

5705: l_search_ctx_id:=p_search_ctx_id;
5706: get_score_details(p_init_msg_list,p_rule_id,p_party_id,
5707: p_party_search_rec,p_party_site_list,p_contact_list,p_contact_point_list,
5708: l_search_ctx_id,x_return_status,x_msg_count,x_msg_data);
5709: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5710: hz_utility_v2pub.debug(p_message=>'get_party_score_details(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
5711: END IF;
5712: END;
5713: PROCEDURE get_score_details (

Line 5710: hz_utility_v2pub.debug(p_message=>'get_party_score_details(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);

5706: get_score_details(p_init_msg_list,p_rule_id,p_party_id,
5707: p_party_search_rec,p_party_site_list,p_contact_list,p_contact_point_list,
5708: l_search_ctx_id,x_return_status,x_msg_count,x_msg_data);
5709: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5710: hz_utility_v2pub.debug(p_message=>'get_party_score_details(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
5711: END IF;
5712: END;
5713: PROCEDURE get_score_details (
5714: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,

Line 5732: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

5728: FROM HZ_MATCH_RULES_VL
5729: WHERE MATCH_RULE_ID = p_rule_id;
5730: l_cmp_flag VARCHAR2(1);
5731: BEGIN
5732: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5733: hz_utility_v2pub.debug(p_message=>'get_score_details(+) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
5734: END IF;
5735: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
5736: hz_utility_v2pub.debug(p_message=>'Rule ID '||p_rule_id,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);

Line 5733: hz_utility_v2pub.debug(p_message=>'get_score_details(+) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);

5729: WHERE MATCH_RULE_ID = p_rule_id;
5730: l_cmp_flag VARCHAR2(1);
5731: BEGIN
5732: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5733: hz_utility_v2pub.debug(p_message=>'get_score_details(+) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
5734: END IF;
5735: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
5736: hz_utility_v2pub.debug(p_message=>'Rule ID '||p_rule_id,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
5737: END IF;

Line 5735: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

5731: BEGIN
5732: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5733: hz_utility_v2pub.debug(p_message=>'get_score_details(+) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
5734: END IF;
5735: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
5736: hz_utility_v2pub.debug(p_message=>'Rule ID '||p_rule_id,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
5737: END IF;
5738:
5739: -- Initialize return status and message stack

Line 5736: hz_utility_v2pub.debug(p_message=>'Rule ID '||p_rule_id,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);

5732: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5733: hz_utility_v2pub.debug(p_message=>'get_score_details(+) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
5734: END IF;
5735: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
5736: hz_utility_v2pub.debug(p_message=>'Rule ID '||p_rule_id,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
5737: END IF;
5738:
5739: -- Initialize return status and message stack
5740: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 6100: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

6096: p_rule_id,
6097: p_party_id, p_party_search_rec,p_party_site_list,
6098: p_contact_list, p_contact_point_list,x_search_ctx_id);
6099: END IF;
6100: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6101: hz_utility_v2pub.debug(p_message=>'get_score_details(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
6102: END IF;
6103: --Standard call to get message count and if count is 1, get message info
6104: FND_MSG_PUB.Count_And_Get(

Line 6101: hz_utility_v2pub.debug(p_message=>'get_score_details(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);

6097: p_party_id, p_party_search_rec,p_party_site_list,
6098: p_contact_list, p_contact_point_list,x_search_ctx_id);
6099: END IF;
6100: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6101: hz_utility_v2pub.debug(p_message=>'get_score_details(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
6102: END IF;
6103: --Standard call to get message count and if count is 1, get message info
6104: FND_MSG_PUB.Count_And_Get(
6105: p_encoded => FND_API.G_FALSE,

Line 6152: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

6148: FROM HZ_MATCH_RULES_VL
6149: WHERE MATCH_RULE_ID = p_rule_id;
6150: l_cmp_flag VARCHAR2(1);
6151: BEGIN
6152: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6153: hz_utility_v2pub.debug(p_message=>'get_party_for_search(+) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
6154: END IF;
6155: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
6156: hz_utility_v2pub.debug(p_message=>'Rule ID '||p_rule_id,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);

Line 6153: hz_utility_v2pub.debug(p_message=>'get_party_for_search(+) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);

6149: WHERE MATCH_RULE_ID = p_rule_id;
6150: l_cmp_flag VARCHAR2(1);
6151: BEGIN
6152: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6153: hz_utility_v2pub.debug(p_message=>'get_party_for_search(+) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
6154: END IF;
6155: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
6156: hz_utility_v2pub.debug(p_message=>'Rule ID '||p_rule_id,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
6157: END IF;

Line 6155: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

6151: BEGIN
6152: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6153: hz_utility_v2pub.debug(p_message=>'get_party_for_search(+) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
6154: END IF;
6155: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
6156: hz_utility_v2pub.debug(p_message=>'Rule ID '||p_rule_id,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
6157: END IF;
6158:
6159: -- Initialize return status and message stack

Line 6156: hz_utility_v2pub.debug(p_message=>'Rule ID '||p_rule_id,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);

6152: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6153: hz_utility_v2pub.debug(p_message=>'get_party_for_search(+) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
6154: END IF;
6155: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
6156: hz_utility_v2pub.debug(p_message=>'Rule ID '||p_rule_id,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
6157: END IF;
6158:
6159: -- Initialize return status and message stack
6160: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 6489: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

6485: HZ_MATCH_RULE_240.get_party_for_search(
6486: p_party_id, x_party_search_rec,x_party_site_list,
6487: x_contact_list, x_contact_point_list);
6488: END IF;
6489: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6490: hz_utility_v2pub.debug(p_message=>'get_party_for_search(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
6491: END IF;
6492: --Standard call to get message count and if count is 1, get message info
6493: FND_MSG_PUB.Count_And_Get(

Line 6490: hz_utility_v2pub.debug(p_message=>'get_party_for_search(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);

6486: p_party_id, x_party_search_rec,x_party_site_list,
6487: x_contact_list, x_contact_point_list);
6488: END IF;
6489: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6490: hz_utility_v2pub.debug(p_message=>'get_party_for_search(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
6491: END IF;
6492: --Standard call to get message count and if count is 1, get message info
6493: FND_MSG_PUB.Count_And_Get(
6494: p_encoded => FND_API.G_FALSE,

Line 6544: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

6540: FROM HZ_MATCH_RULES_VL
6541: WHERE MATCH_RULE_ID = p_rule_id;
6542: l_cmp_flag VARCHAR2(1);
6543: BEGIN
6544: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6545: hz_utility_v2pub.debug(p_message=>'get_search_criteria(+) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
6546: END IF;
6547: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
6548: hz_utility_v2pub.debug(p_message=>'Rule ID '||p_rule_id,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);

Line 6545: hz_utility_v2pub.debug(p_message=>'get_search_criteria(+) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);

6541: WHERE MATCH_RULE_ID = p_rule_id;
6542: l_cmp_flag VARCHAR2(1);
6543: BEGIN
6544: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6545: hz_utility_v2pub.debug(p_message=>'get_search_criteria(+) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
6546: END IF;
6547: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
6548: hz_utility_v2pub.debug(p_message=>'Rule ID '||p_rule_id,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
6549: END IF;

Line 6547: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

6543: BEGIN
6544: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6545: hz_utility_v2pub.debug(p_message=>'get_search_criteria(+) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
6546: END IF;
6547: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
6548: hz_utility_v2pub.debug(p_message=>'Rule ID '||p_rule_id,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
6549: END IF;
6550:
6551: -- Initialize return status and message stack

Line 6548: hz_utility_v2pub.debug(p_message=>'Rule ID '||p_rule_id,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);

6544: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6545: hz_utility_v2pub.debug(p_message=>'get_search_criteria(+) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
6546: END IF;
6547: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
6548: hz_utility_v2pub.debug(p_message=>'Rule ID '||p_rule_id,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
6549: END IF;
6550:
6551: -- Initialize return status and message stack
6552: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 6881: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

6877: HZ_MATCH_RULE_240.get_search_criteria(
6878: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6879: x_contact_list, x_contact_point_list);
6880: END IF;
6881: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6882: hz_utility_v2pub.debug(p_message=>'get_search_criteria(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
6883: END IF;
6884: --Standard call to get message count and if count is 1, get message info
6885: FND_MSG_PUB.Count_And_Get(

Line 6882: hz_utility_v2pub.debug(p_message=>'get_search_criteria(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);

6878: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6879: x_contact_list, x_contact_point_list);
6880: END IF;
6881: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6882: hz_utility_v2pub.debug(p_message=>'get_search_criteria(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
6883: END IF;
6884: --Standard call to get message count and if count is 1, get message info
6885: FND_MSG_PUB.Count_And_Get(
6886: p_encoded => FND_API.G_FALSE,