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 403: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

399: -- User quality score
400: IF (fnd_profile.value('HZ_QUALITY_WEIGHTING_USER_HOOK') = 'Y') THEN
401: HZ_DQM_SEARCH_UTIL.get_quality_score ( x_search_ctx_id, p_rule_id);
402: END IF;
403: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
404: 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);
405: END IF;
406: --Standard call to get message count and if count is 1, get message info
407: FND_MSG_PUB.Count_And_Get(

Line 404: 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);

400: IF (fnd_profile.value('HZ_QUALITY_WEIGHTING_USER_HOOK') = 'Y') THEN
401: HZ_DQM_SEARCH_UTIL.get_quality_score ( x_search_ctx_id, p_rule_id);
402: END IF;
403: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
404: 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);
405: END IF;
406: --Standard call to get message count and if count is 1, get message info
407: FND_MSG_PUB.Count_And_Get(
408: p_encoded => FND_API.G_FALSE,

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

457: WHERE MATCH_RULE_ID = p_rule_id;
458: l_cmp_flag VARCHAR2(1);
459: BEGIN
460:
461: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
462: 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);
463: END IF;
464: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
465: 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 462: 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);

458: l_cmp_flag VARCHAR2(1);
459: BEGIN
460:
461: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
462: 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);
463: END IF;
464: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
465: 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);
466: END IF;

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

460:
461: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
462: 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);
463: END IF;
464: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
465: 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);
466: END IF;
467: -- Initialize return status and message stack
468: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 465: 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);

461: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
462: 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);
463: END IF;
464: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
465: 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);
466: END IF;
467: -- Initialize return status and message stack
468: x_return_status := FND_API.G_RET_STS_SUCCESS;
469: IF FND_API.to_Boolean(p_init_msg_list) THEN

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

776: HZ_MATCH_RULE_99.find_persons(
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: END IF;
780: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
781: 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);
782: END IF;
783: --Standard call to get message count and if count is 1, get message info
784: FND_MSG_PUB.Count_And_Get(

Line 781: 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);

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: END IF;
780: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
781: 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);
782: END IF;
783: --Standard call to get message count and if count is 1, get message info
784: FND_MSG_PUB.Count_And_Get(
785: p_encoded => FND_API.G_FALSE,

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

855: FROM HZ_MATCH_RULES_VL
856: WHERE MATCH_RULE_ID = p_rule_id;
857: l_cmp_flag VARCHAR2(1);
858: BEGIN
859: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
860: 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);
861: END IF;
862: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
863: 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 860: 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);

856: WHERE MATCH_RULE_ID = p_rule_id;
857: l_cmp_flag VARCHAR2(1);
858: BEGIN
859: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
860: 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);
861: END IF;
862: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
863: 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);
864: END IF;

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

858: BEGIN
859: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
860: 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);
861: END IF;
862: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
863: 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);
864: END IF;
865:
866: -- Initialize return status and message stack

Line 863: 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);

859: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
860: 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);
861: END IF;
862: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
863: 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);
864: END IF;
865:
866: -- Initialize return status and message stack
867: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1175: HZ_MATCH_RULE_99.find_party_details(
1176: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
1177: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
1178: END IF;
1179: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1180: 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);
1181: END IF;
1182: --Standard call to get message count and if count is 1, get message info
1183: FND_MSG_PUB.Count_And_Get(

Line 1180: 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);

1176: p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,
1177: p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
1178: END IF;
1179: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1180: 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);
1181: END IF;
1182: --Standard call to get message count and if count is 1, get message info
1183: FND_MSG_PUB.Count_And_Get(
1184: p_encoded => FND_API.G_FALSE,

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

1231: FROM HZ_MATCH_RULES_VL
1232: WHERE MATCH_RULE_ID = p_rule_id;
1233: l_cmp_flag VARCHAR2(1);
1234: BEGIN
1235: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1236: 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);
1237: END IF;
1238: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1239: 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 1236: 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);

1232: WHERE MATCH_RULE_ID = p_rule_id;
1233: l_cmp_flag VARCHAR2(1);
1234: BEGIN
1235: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1236: 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);
1237: END IF;
1238: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1239: 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);
1240: END IF;

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

1234: BEGIN
1235: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1236: 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);
1237: END IF;
1238: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1239: 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);
1240: END IF;
1241:
1242: -- Initialize return status and message stack

Line 1239: 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);

1235: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1236: 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);
1237: END IF;
1238: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1239: 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);
1240: END IF;
1241:
1242: -- Initialize return status and message stack
1243: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1555: HZ_MATCH_RULE_99.find_duplicate_parties(
1556: p_rule_id,p_party_id,
1557: p_restrict_sql,p_match_type,p_dup_batch_id,p_search_merged,x_dup_set_id, x_search_ctx_id,x_num_matches);
1558: END IF;
1559: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1560: 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);
1561: END IF;
1562: --Standard call to get message count and if count is 1, get message info
1563: FND_MSG_PUB.Count_And_Get(

Line 1560: 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);

1556: p_rule_id,p_party_id,
1557: p_restrict_sql,p_match_type,p_dup_batch_id,p_search_merged,x_dup_set_id, x_search_ctx_id,x_num_matches);
1558: END IF;
1559: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1560: 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);
1561: END IF;
1562: --Standard call to get message count and if count is 1, get message info
1563: FND_MSG_PUB.Count_And_Get(
1564: p_encoded => FND_API.G_FALSE,

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

1610: FROM HZ_MATCH_RULES_VL
1611: WHERE MATCH_RULE_ID = p_rule_id;
1612: l_cmp_flag VARCHAR2(1);
1613: BEGIN
1614: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1615: 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);
1616: END IF;
1617: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1618: 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 1615: 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);

1611: WHERE MATCH_RULE_ID = p_rule_id;
1612: l_cmp_flag VARCHAR2(1);
1613: BEGIN
1614: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1615: 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);
1616: END IF;
1617: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1618: 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);
1619: END IF;

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

1613: BEGIN
1614: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1615: 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);
1616: END IF;
1617: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1618: 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);
1619: END IF;
1620:
1621: -- Initialize return status and message stack

Line 1618: 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);

1614: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1615: 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);
1616: END IF;
1617: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1618: 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);
1619: END IF;
1620:
1621: -- Initialize return status and message stack
1622: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1930: HZ_MATCH_RULE_99.find_duplicate_party_sites(
1931: p_rule_id,p_party_site_id,p_party_id,
1932: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
1933: END IF;
1934: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1935: 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);
1936: END IF;
1937: --Standard call to get message count and if count is 1, get message info
1938: FND_MSG_PUB.Count_And_Get(

Line 1935: 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);

1931: p_rule_id,p_party_site_id,p_party_id,
1932: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
1933: END IF;
1934: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1935: 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);
1936: END IF;
1937: --Standard call to get message count and if count is 1, get message info
1938: FND_MSG_PUB.Count_And_Get(
1939: p_encoded => FND_API.G_FALSE,

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

1984: FROM HZ_MATCH_RULES_VL
1985: WHERE MATCH_RULE_ID = p_rule_id;
1986: l_cmp_flag VARCHAR2(1);
1987: BEGIN
1988: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1989: 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);
1990: END IF;
1991: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1992: 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 1989: 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);

1985: WHERE MATCH_RULE_ID = p_rule_id;
1986: l_cmp_flag VARCHAR2(1);
1987: BEGIN
1988: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1989: 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);
1990: END IF;
1991: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1992: 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);
1993: END IF;

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

1987: BEGIN
1988: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1989: 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);
1990: END IF;
1991: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1992: 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);
1993: END IF;
1994:
1995: -- Initialize return status and message stack

Line 1992: 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);

1988: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1989: 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);
1990: END IF;
1991: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1992: 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);
1993: END IF;
1994:
1995: -- Initialize return status and message stack
1996: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

2304: HZ_MATCH_RULE_99.find_duplicate_contacts(
2305: p_rule_id,p_org_contact_id,p_party_id,
2306: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2307: END IF;
2308: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2309: 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);
2310: END IF;
2311: --Standard call to get message count and if count is 1, get message info
2312: FND_MSG_PUB.Count_And_Get(

Line 2309: 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);

2305: p_rule_id,p_org_contact_id,p_party_id,
2306: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2307: END IF;
2308: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2309: 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);
2310: END IF;
2311: --Standard call to get message count and if count is 1, get message info
2312: FND_MSG_PUB.Count_And_Get(
2313: p_encoded => FND_API.G_FALSE,

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

2358: FROM HZ_MATCH_RULES_VL
2359: WHERE MATCH_RULE_ID = p_rule_id;
2360: l_cmp_flag VARCHAR2(1);
2361: BEGIN
2362: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2363: 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);
2364: END IF;
2365: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2366: 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 2363: 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);

2359: WHERE MATCH_RULE_ID = p_rule_id;
2360: l_cmp_flag VARCHAR2(1);
2361: BEGIN
2362: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2363: 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);
2364: END IF;
2365: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2366: 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);
2367: END IF;

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

2361: BEGIN
2362: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2363: 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);
2364: END IF;
2365: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2366: 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);
2367: END IF;
2368:
2369: -- Initialize return status and message stack

Line 2366: 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);

2362: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2363: 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);
2364: END IF;
2365: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2366: 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);
2367: END IF;
2368:
2369: -- Initialize return status and message stack
2370: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

2678: HZ_MATCH_RULE_99.find_duplicate_contact_points(
2679: p_rule_id,p_contact_point_id,p_party_id,
2680: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2681: END IF;
2682: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2683: 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);
2684: END IF;
2685: --Standard call to get message count and if count is 1, get message info
2686: FND_MSG_PUB.Count_And_Get(

Line 2683: 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);

2679: p_rule_id,p_contact_point_id,p_party_id,
2680: p_restrict_sql,p_match_type,x_search_ctx_id,x_num_matches);
2681: END IF;
2682: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2683: 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);
2684: END IF;
2685: --Standard call to get message count and if count is 1, get message info
2686: FND_MSG_PUB.Count_And_Get(
2687: p_encoded => FND_API.G_FALSE,

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

2772: FROM HZ_MATCH_RULES_VL
2773: WHERE MATCH_RULE_ID = p_rule_id;
2774: l_cmp_flag VARCHAR2(1);
2775: BEGIN
2776: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2777: 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);
2778: END IF;
2779: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2780: 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 2777: 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);

2773: WHERE MATCH_RULE_ID = p_rule_id;
2774: l_cmp_flag VARCHAR2(1);
2775: BEGIN
2776: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2777: 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);
2778: END IF;
2779: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2780: 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);
2781: END IF;

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

2775: BEGIN
2776: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2777: 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);
2778: END IF;
2779: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2780: 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);
2781: END IF;
2782:
2783: -- Initialize return status and message stack

Line 2780: 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);

2776: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2777: 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);
2778: END IF;
2779: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2780: 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);
2781: END IF;
2782:
2783: -- Initialize return status and message stack
2784: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

3324: p_attrib_val11,p_attrib_val12,p_attrib_val13,p_attrib_val14,p_attrib_val15,
3325: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3326: p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
3327: END IF;
3328: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3329: 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);
3330: END IF;
3331: --Standard call to get message count and if count is 1, get message info
3332: FND_MSG_PUB.Count_And_Get(

Line 3329: 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);

3325: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3326: p_restrict_sql,p_match_type,p_search_merged,x_search_ctx_id,x_num_matches);
3327: END IF;
3328: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3329: 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);
3330: END IF;
3331: --Standard call to get message count and if count is 1, get message info
3332: FND_MSG_PUB.Count_And_Get(
3333: p_encoded => FND_API.G_FALSE,

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

3419: FROM HZ_MATCH_RULES_VL
3420: WHERE MATCH_RULE_ID = p_rule_id;
3421: l_cmp_flag VARCHAR2(1);
3422: BEGIN
3423: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3424: 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);
3425: END IF;
3426: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3427: 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 3424: 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);

3420: WHERE MATCH_RULE_ID = p_rule_id;
3421: l_cmp_flag VARCHAR2(1);
3422: BEGIN
3423: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3424: 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);
3425: END IF;
3426: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3427: 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);
3428: END IF;

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

3422: BEGIN
3423: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3424: 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);
3425: END IF;
3426: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3427: 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);
3428: END IF;
3429:
3430: -- Initialize return status and message stack

Line 3427: 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);

3423: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3424: 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);
3425: END IF;
3426: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3427: 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);
3428: END IF;
3429:
3430: -- Initialize return status and message stack
3431: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

3971: p_attrib_val11,p_attrib_val12,p_attrib_val13,p_attrib_val14,p_attrib_val15,
3972: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3973: p_restrict_sql,p_api_name,p_match_type,p_party_id,p_search_merged,x_search_ctx_id,x_num_matches);
3974: END IF;
3975: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3976: 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);
3977: END IF;
3978: --Standard call to get message count and if count is 1, get message info
3979: FND_MSG_PUB.Count_And_Get(

Line 3976: 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);

3972: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
3973: p_restrict_sql,p_api_name,p_match_type,p_party_id,p_search_merged,x_search_ctx_id,x_num_matches);
3974: END IF;
3975: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3976: 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);
3977: END IF;
3978: --Standard call to get message count and if count is 1, get message info
3979: FND_MSG_PUB.Count_And_Get(
3980: p_encoded => FND_API.G_FALSE,

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

4100: l_attrib_id18 NUMBER;
4101: l_attrib_id19 NUMBER;
4102: l_attrib_id20 NUMBER;
4103: BEGIN
4104: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4105: 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);
4106: END IF;
4107: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4108: 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 4105: 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);

4101: l_attrib_id19 NUMBER;
4102: l_attrib_id20 NUMBER;
4103: BEGIN
4104: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4105: 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);
4106: END IF;
4107: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4108: 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);
4109: END IF;

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

4103: BEGIN
4104: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4105: 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);
4106: END IF;
4107: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4108: 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);
4109: END IF;
4110:
4111: IF (p_attrib_name1 IS NOT NULL) THEN

Line 4108: 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);

4104: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4105: 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);
4106: END IF;
4107: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4108: 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);
4109: END IF;
4110:
4111: IF (p_attrib_name1 IS NOT NULL) THEN
4112: l_attrib_id1 := get_attrib_id(p_attrib_name1);

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

4179: p_attrib_val11,p_attrib_val12,p_attrib_val13,p_attrib_val14,p_attrib_val15,
4180: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
4181: p_restrict_sql,p_api_name,p_match_type,p_party_id,p_search_merged,
4182: x_search_ctx_id,x_num_matches, x_return_status, x_msg_count, x_msg_data);
4183: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4184: 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);
4185: END IF;
4186: --Standard call to get message count and if count is 1, get message info
4187: FND_MSG_PUB.Count_And_Get(

Line 4184: 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);

4180: p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,
4181: p_restrict_sql,p_api_name,p_match_type,p_party_id,p_search_merged,
4182: x_search_ctx_id,x_num_matches, x_return_status, x_msg_count, x_msg_data);
4183: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4184: 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);
4185: END IF;
4186: --Standard call to get message count and if count is 1, get message info
4187: FND_MSG_PUB.Count_And_Get(
4188: p_encoded => FND_API.G_FALSE,

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

4226: x_msg_data OUT VARCHAR2
4227: ) IS
4228: l_num_matches NUMBER;
4229: BEGIN
4230: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4231: 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);
4232: END IF;
4233: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4234: 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 4231: 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);

4227: ) IS
4228: l_num_matches NUMBER;
4229: BEGIN
4230: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4231: 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);
4232: END IF;
4233: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4234: 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);
4235: END IF;

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

4229: BEGIN
4230: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4231: 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);
4232: END IF;
4233: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4234: 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);
4235: END IF;
4236: get_matching_party_sites(p_init_msg_list,p_rule_id,p_party_id,
4237: p_party_site_list,p_contact_point_list,

Line 4234: 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);

4230: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4231: 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);
4232: END IF;
4233: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4234: 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);
4235: END IF;
4236: get_matching_party_sites(p_init_msg_list,p_rule_id,p_party_id,
4237: p_party_site_list,p_contact_point_list,
4238: NULL,NULL,x_search_ctx_id,

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

4236: get_matching_party_sites(p_init_msg_list,p_rule_id,p_party_id,
4237: p_party_site_list,p_contact_point_list,
4238: NULL,NULL,x_search_ctx_id,
4239: l_num_matches,x_return_status,x_msg_count,x_msg_data);
4240: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4241: 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);
4242: END IF;
4243: END;
4244: PROCEDURE get_matching_party_sites (

Line 4241: 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);

4237: p_party_site_list,p_contact_point_list,
4238: NULL,NULL,x_search_ctx_id,
4239: l_num_matches,x_return_status,x_msg_count,x_msg_data);
4240: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4241: 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);
4242: END IF;
4243: END;
4244: PROCEDURE get_matching_party_sites (
4245: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,

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

4260: FROM HZ_MATCH_RULES_VL
4261: WHERE MATCH_RULE_ID = p_rule_id;
4262: l_cmp_flag VARCHAR2(1);
4263: BEGIN
4264: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4265: 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);
4266: END IF;
4267: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4268: 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 4265: 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);

4261: WHERE MATCH_RULE_ID = p_rule_id;
4262: l_cmp_flag VARCHAR2(1);
4263: BEGIN
4264: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4265: 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);
4266: END IF;
4267: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4268: 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);
4269: END IF;

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

4263: BEGIN
4264: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4265: 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);
4266: END IF;
4267: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4268: 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);
4269: END IF;
4270:
4271: -- Initialize return status and message stack

Line 4268: 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);

4264: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4265: 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);
4266: END IF;
4267: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4268: 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);
4269: END IF;
4270:
4271: -- Initialize return status and message stack
4272: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

4577: HZ_MATCH_RULE_99.get_matching_party_sites(
4578: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4579: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4580: END IF;
4581: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4582: 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);
4583: END IF;
4584: --Standard call to get message count and if count is 1, get message info
4585: FND_MSG_PUB.Count_And_Get(

Line 4582: 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);

4578: p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,
4579: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
4580: END IF;
4581: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4582: 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);
4583: END IF;
4584: --Standard call to get message count and if count is 1, get message info
4585: FND_MSG_PUB.Count_And_Get(
4586: p_encoded => FND_API.G_FALSE,

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

4625: x_msg_data OUT VARCHAR2
4626: ) IS
4627: l_num_matches NUMBER;
4628: BEGIN
4629: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4630: 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);
4631: END IF;
4632: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4633: 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 4630: 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);

4626: ) IS
4627: l_num_matches NUMBER;
4628: BEGIN
4629: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4630: 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);
4631: END IF;
4632: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4633: 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);
4634: END IF;

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

4628: BEGIN
4629: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4630: 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);
4631: END IF;
4632: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4633: 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);
4634: END IF;
4635: get_matching_contacts(p_init_msg_list,p_rule_id,p_party_id,
4636: p_contact_list,p_contact_point_list,

Line 4633: 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);

4629: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4630: 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);
4631: END IF;
4632: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4633: 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);
4634: END IF;
4635: get_matching_contacts(p_init_msg_list,p_rule_id,p_party_id,
4636: p_contact_list,p_contact_point_list,
4637: NULL,NULL,x_search_ctx_id,

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

4635: get_matching_contacts(p_init_msg_list,p_rule_id,p_party_id,
4636: p_contact_list,p_contact_point_list,
4637: NULL,NULL,x_search_ctx_id,
4638: l_num_matches,x_return_status,x_msg_count,x_msg_data);
4639: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4640: 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);
4641: END IF;
4642: END;
4643: PROCEDURE get_matching_contacts (

Line 4640: 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);

4636: p_contact_list,p_contact_point_list,
4637: NULL,NULL,x_search_ctx_id,
4638: l_num_matches,x_return_status,x_msg_count,x_msg_data);
4639: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4640: 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);
4641: END IF;
4642: END;
4643: PROCEDURE get_matching_contacts (
4644: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,

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

4659: FROM HZ_MATCH_RULES_VL
4660: WHERE MATCH_RULE_ID = p_rule_id;
4661: l_cmp_flag VARCHAR2(1);
4662: BEGIN
4663: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4664: 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);
4665: END IF;
4666: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4667: 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 4664: 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);

4660: WHERE MATCH_RULE_ID = p_rule_id;
4661: l_cmp_flag VARCHAR2(1);
4662: BEGIN
4663: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4664: 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);
4665: END IF;
4666: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4667: 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);
4668: END IF;

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

4662: BEGIN
4663: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4664: 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);
4665: END IF;
4666: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4667: 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);
4668: END IF;
4669:
4670: -- Initialize return status and message stack

Line 4667: 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);

4663: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4664: 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);
4665: END IF;
4666: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4667: 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);
4668: END IF;
4669:
4670: -- Initialize return status and message stack
4671: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

5006: FND_MSG_PUB.Count_And_Get(
5007: p_encoded => FND_API.G_FALSE,
5008: p_count => x_msg_count,
5009: p_data => x_msg_data);
5010: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5011: 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);
5012: END IF;
5013: END;
5014:

Line 5011: 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);

5007: p_encoded => FND_API.G_FALSE,
5008: p_count => x_msg_count,
5009: p_data => x_msg_data);
5010: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5011: 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);
5012: END IF;
5013: END;
5014:
5015: PROCEDURE get_matching_contact_points (

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

5023: x_msg_data OUT VARCHAR2
5024: ) IS
5025: l_num_matches NUMBER;
5026: BEGIN
5027: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5028: 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);
5029: END IF;
5030: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
5031: 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 5028: 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);

5024: ) IS
5025: l_num_matches NUMBER;
5026: BEGIN
5027: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5028: 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);
5029: END IF;
5030: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
5031: 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);
5032: END IF;

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

5026: BEGIN
5027: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5028: 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);
5029: END IF;
5030: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
5031: 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);
5032: END IF;
5033: get_matching_contact_points(p_init_msg_list,p_rule_id,p_party_id,
5034: p_contact_point_list,

Line 5031: 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);

5027: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5028: 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);
5029: END IF;
5030: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
5031: 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);
5032: END IF;
5033: get_matching_contact_points(p_init_msg_list,p_rule_id,p_party_id,
5034: p_contact_point_list,
5035: NULL,NULL,x_search_ctx_id,

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

5033: get_matching_contact_points(p_init_msg_list,p_rule_id,p_party_id,
5034: p_contact_point_list,
5035: NULL,NULL,x_search_ctx_id,
5036: l_num_matches,x_return_status,x_msg_count,x_msg_data);
5037: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5038: 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);
5039: END IF;
5040: END;
5041: PROCEDURE get_matching_contact_points (

Line 5038: 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);

5034: p_contact_point_list,
5035: NULL,NULL,x_search_ctx_id,
5036: l_num_matches,x_return_status,x_msg_count,x_msg_data);
5037: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5038: 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);
5039: END IF;
5040: END;
5041: PROCEDURE get_matching_contact_points (
5042: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,

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

5056: FROM HZ_MATCH_RULES_VL
5057: WHERE MATCH_RULE_ID = p_rule_id;
5058: l_cmp_flag VARCHAR2(1);
5059: BEGIN
5060: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5061: 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);
5062: END IF;
5063: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
5064: 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 5061: 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);

5057: WHERE MATCH_RULE_ID = p_rule_id;
5058: l_cmp_flag VARCHAR2(1);
5059: BEGIN
5060: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5061: 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);
5062: END IF;
5063: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
5064: 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);
5065: END IF;

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

5059: BEGIN
5060: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5061: 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);
5062: END IF;
5063: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
5064: 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);
5065: END IF;
5066:
5067: -- Initialize return status and message stack

Line 5064: 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);

5060: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5061: 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);
5062: END IF;
5063: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
5064: 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);
5065: END IF;
5066:
5067: -- Initialize return status and message stack
5068: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

5373: HZ_MATCH_RULE_99.get_matching_contact_points(
5374: p_rule_id, p_party_id, p_contact_point_list,
5375: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5376: END IF;
5377: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5378: 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);
5379: END IF;
5380: --Standard call to get message count and if count is 1, get message info
5381: FND_MSG_PUB.Count_And_Get(

Line 5378: 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);

5374: p_rule_id, p_party_id, p_contact_point_list,
5375: p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);
5376: END IF;
5377: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5378: 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);
5379: END IF;
5380: --Standard call to get message count and if count is 1, get message info
5381: FND_MSG_PUB.Count_And_Get(
5382: p_encoded => FND_API.G_FALSE,

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

5423: x_msg_data OUT VARCHAR2
5424: ) IS
5425: l_search_ctx_id NUMBER;
5426: BEGIN
5427: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5428: 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);
5429: END IF;
5430: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
5431: 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 5428: 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);

5424: ) IS
5425: l_search_ctx_id NUMBER;
5426: BEGIN
5427: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5428: 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);
5429: END IF;
5430: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
5431: 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);
5432: END IF;

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

5426: BEGIN
5427: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5428: 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);
5429: END IF;
5430: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
5431: 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);
5432: END IF;
5433: l_search_ctx_id:=p_search_ctx_id;
5434: get_score_details(p_init_msg_list,p_rule_id,p_party_id,

Line 5431: 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);

5427: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5428: 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);
5429: END IF;
5430: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
5431: 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);
5432: END IF;
5433: l_search_ctx_id:=p_search_ctx_id;
5434: get_score_details(p_init_msg_list,p_rule_id,p_party_id,
5435: p_party_search_rec,p_party_site_list,p_contact_list,p_contact_point_list,

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

5433: l_search_ctx_id:=p_search_ctx_id;
5434: get_score_details(p_init_msg_list,p_rule_id,p_party_id,
5435: p_party_search_rec,p_party_site_list,p_contact_list,p_contact_point_list,
5436: l_search_ctx_id,x_return_status,x_msg_count,x_msg_data);
5437: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5438: 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);
5439: END IF;
5440: END;
5441: PROCEDURE get_score_details (

Line 5438: 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);

5434: get_score_details(p_init_msg_list,p_rule_id,p_party_id,
5435: p_party_search_rec,p_party_site_list,p_contact_list,p_contact_point_list,
5436: l_search_ctx_id,x_return_status,x_msg_count,x_msg_data);
5437: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5438: 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);
5439: END IF;
5440: END;
5441: PROCEDURE get_score_details (
5442: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,

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

5456: FROM HZ_MATCH_RULES_VL
5457: WHERE MATCH_RULE_ID = p_rule_id;
5458: l_cmp_flag VARCHAR2(1);
5459: BEGIN
5460: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5461: 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);
5462: END IF;
5463: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
5464: 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 5461: 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);

5457: WHERE MATCH_RULE_ID = p_rule_id;
5458: l_cmp_flag VARCHAR2(1);
5459: BEGIN
5460: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5461: 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);
5462: END IF;
5463: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
5464: 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);
5465: END IF;

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

5459: BEGIN
5460: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5461: 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);
5462: END IF;
5463: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
5464: 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);
5465: END IF;
5466:
5467: -- Initialize return status and message stack

Line 5464: 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);

5460: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5461: 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);
5462: END IF;
5463: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
5464: 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);
5465: END IF;
5466:
5467: -- Initialize return status and message stack
5468: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

5802: p_rule_id,
5803: p_party_id, p_party_search_rec,p_party_site_list,
5804: p_contact_list, p_contact_point_list,x_search_ctx_id);
5805: END IF;
5806: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5807: 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);
5808: END IF;
5809: --Standard call to get message count and if count is 1, get message info
5810: FND_MSG_PUB.Count_And_Get(

Line 5807: 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);

5803: p_party_id, p_party_search_rec,p_party_site_list,
5804: p_contact_list, p_contact_point_list,x_search_ctx_id);
5805: END IF;
5806: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5807: 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);
5808: END IF;
5809: --Standard call to get message count and if count is 1, get message info
5810: FND_MSG_PUB.Count_And_Get(
5811: p_encoded => FND_API.G_FALSE,

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

5854: FROM HZ_MATCH_RULES_VL
5855: WHERE MATCH_RULE_ID = p_rule_id;
5856: l_cmp_flag VARCHAR2(1);
5857: BEGIN
5858: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5859: 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);
5860: END IF;
5861: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
5862: 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 5859: 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);

5855: WHERE MATCH_RULE_ID = p_rule_id;
5856: l_cmp_flag VARCHAR2(1);
5857: BEGIN
5858: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5859: 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);
5860: END IF;
5861: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
5862: 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);
5863: END IF;

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

5857: BEGIN
5858: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5859: 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);
5860: END IF;
5861: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
5862: 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);
5863: END IF;
5864:
5865: -- Initialize return status and message stack

Line 5862: 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);

5858: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5859: 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);
5860: END IF;
5861: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
5862: 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);
5863: END IF;
5864:
5865: -- Initialize return status and message stack
5866: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

6171: HZ_MATCH_RULE_99.get_party_for_search(
6172: p_party_id, x_party_search_rec,x_party_site_list,
6173: x_contact_list, x_contact_point_list);
6174: END IF;
6175: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6176: 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);
6177: END IF;
6178: --Standard call to get message count and if count is 1, get message info
6179: FND_MSG_PUB.Count_And_Get(

Line 6176: 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);

6172: p_party_id, x_party_search_rec,x_party_site_list,
6173: x_contact_list, x_contact_point_list);
6174: END IF;
6175: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6176: 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);
6177: END IF;
6178: --Standard call to get message count and if count is 1, get message info
6179: FND_MSG_PUB.Count_And_Get(
6180: p_encoded => FND_API.G_FALSE,

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

6226: FROM HZ_MATCH_RULES_VL
6227: WHERE MATCH_RULE_ID = p_rule_id;
6228: l_cmp_flag VARCHAR2(1);
6229: BEGIN
6230: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6231: 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);
6232: END IF;
6233: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
6234: 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 6231: 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);

6227: WHERE MATCH_RULE_ID = p_rule_id;
6228: l_cmp_flag VARCHAR2(1);
6229: BEGIN
6230: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6231: 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);
6232: END IF;
6233: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
6234: 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);
6235: END IF;

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

6229: BEGIN
6230: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6231: 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);
6232: END IF;
6233: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
6234: 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);
6235: END IF;
6236:
6237: -- Initialize return status and message stack

Line 6234: 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);

6230: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6231: 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);
6232: END IF;
6233: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
6234: 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);
6235: END IF;
6236:
6237: -- Initialize return status and message stack
6238: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

6543: HZ_MATCH_RULE_99.get_search_criteria(
6544: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6545: x_contact_list, x_contact_point_list);
6546: END IF;
6547: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6548: 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);
6549: END IF;
6550: --Standard call to get message count and if count is 1, get message info
6551: FND_MSG_PUB.Count_And_Get(

Line 6548: 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);

6544: p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,
6545: x_contact_list, x_contact_point_list);
6546: END IF;
6547: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6548: 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);
6549: END IF;
6550: --Standard call to get message count and if count is 1, get message info
6551: FND_MSG_PUB.Count_And_Get(
6552: p_encoded => FND_API.G_FALSE,