DBA Data[Home] [Help]

APPS.HZ_ORGANIZATION_BO_PUB dependencies on HZ_PARTY_SEARCH

Line 1472: l_party_search_rec HZ_PARTY_SEARCH.PARTY_SEARCH_REC_TYPE;

1468: l_raise_event BOOLEAN := FALSE;
1469: l_cbm VARCHAR2(30);
1470: l_event_id NUMBER;
1471: l_sms_objs HZ_SMS_CP_BO_TBL;
1472: l_party_search_rec HZ_PARTY_SEARCH.PARTY_SEARCH_REC_TYPE;
1473: l_party_site_list HZ_PARTY_SEARCH.PARTY_SITE_LIST;
1474: l_contact_list HZ_PARTY_SEARCH.CONTACT_LIST;
1475: l_contact_point_list HZ_PARTY_SEARCH.CONTACT_POINT_LIST;
1476: l_match_rule_id number;

Line 1473: l_party_site_list HZ_PARTY_SEARCH.PARTY_SITE_LIST;

1469: l_cbm VARCHAR2(30);
1470: l_event_id NUMBER;
1471: l_sms_objs HZ_SMS_CP_BO_TBL;
1472: l_party_search_rec HZ_PARTY_SEARCH.PARTY_SEARCH_REC_TYPE;
1473: l_party_site_list HZ_PARTY_SEARCH.PARTY_SITE_LIST;
1474: l_contact_list HZ_PARTY_SEARCH.CONTACT_LIST;
1475: l_contact_point_list HZ_PARTY_SEARCH.CONTACT_POINT_LIST;
1476: l_match_rule_id number;
1477: l_search_ctx_id NUMBER;

Line 1474: l_contact_list HZ_PARTY_SEARCH.CONTACT_LIST;

1470: l_event_id NUMBER;
1471: l_sms_objs HZ_SMS_CP_BO_TBL;
1472: l_party_search_rec HZ_PARTY_SEARCH.PARTY_SEARCH_REC_TYPE;
1473: l_party_site_list HZ_PARTY_SEARCH.PARTY_SITE_LIST;
1474: l_contact_list HZ_PARTY_SEARCH.CONTACT_LIST;
1475: l_contact_point_list HZ_PARTY_SEARCH.CONTACT_POINT_LIST;
1476: l_match_rule_id number;
1477: l_search_ctx_id NUMBER;
1478: l_num_matches NUMBER;

Line 1475: l_contact_point_list HZ_PARTY_SEARCH.CONTACT_POINT_LIST;

1471: l_sms_objs HZ_SMS_CP_BO_TBL;
1472: l_party_search_rec HZ_PARTY_SEARCH.PARTY_SEARCH_REC_TYPE;
1473: l_party_site_list HZ_PARTY_SEARCH.PARTY_SITE_LIST;
1474: l_contact_list HZ_PARTY_SEARCH.CONTACT_LIST;
1475: l_contact_point_list HZ_PARTY_SEARCH.CONTACT_POINT_LIST;
1476: l_match_rule_id number;
1477: l_search_ctx_id NUMBER;
1478: l_num_matches NUMBER;
1479: l_party_id NUMBER;

Line 2208: hz_utility_v2pub.debug(p_message=>'Calling DQM API HZ_PARTY_SEARCH.find_parties ',p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');

2204: end loop;
2205: end if;
2206:
2207: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2208: hz_utility_v2pub.debug(p_message=>'Calling DQM API HZ_PARTY_SEARCH.find_parties ',p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
2209: hz_utility_v2pub.debug(p_message=>'HZ_PARTY_SEARCH.find_parties Start time: '||TO_CHAR(SYSDATE, 'MM-DD-YY HH24:MI:SS'),p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
2210: END IF;
2211:
2212: HZ_PARTY_SEARCH.find_parties (

Line 2209: hz_utility_v2pub.debug(p_message=>'HZ_PARTY_SEARCH.find_parties Start time: '||TO_CHAR(SYSDATE, 'MM-DD-YY HH24:MI:SS'),p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');

2205: end if;
2206:
2207: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2208: hz_utility_v2pub.debug(p_message=>'Calling DQM API HZ_PARTY_SEARCH.find_parties ',p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
2209: hz_utility_v2pub.debug(p_message=>'HZ_PARTY_SEARCH.find_parties Start time: '||TO_CHAR(SYSDATE, 'MM-DD-YY HH24:MI:SS'),p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
2210: END IF;
2211:
2212: HZ_PARTY_SEARCH.find_parties (
2213: p_init_msg_list => FND_API.G_FALSE,

Line 2212: HZ_PARTY_SEARCH.find_parties (

2208: hz_utility_v2pub.debug(p_message=>'Calling DQM API HZ_PARTY_SEARCH.find_parties ',p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
2209: hz_utility_v2pub.debug(p_message=>'HZ_PARTY_SEARCH.find_parties Start time: '||TO_CHAR(SYSDATE, 'MM-DD-YY HH24:MI:SS'),p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
2210: END IF;
2211:
2212: HZ_PARTY_SEARCH.find_parties (
2213: p_init_msg_list => FND_API.G_FALSE,
2214: x_rule_id => l_match_rule_id,
2215: p_party_search_rec => l_party_search_rec,
2216: p_party_site_list => l_party_site_list,

Line 2230: hz_utility_v2pub.debug(p_message=>'HZ_PARTY_SEARCH.find_parties end time: '||TO_CHAR(SYSDATE, 'MM-DD-YY HH24:MI:SS'),p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');

2226:
2227: );
2228:
2229: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2230: hz_utility_v2pub.debug(p_message=>'HZ_PARTY_SEARCH.find_parties end time: '||TO_CHAR(SYSDATE, 'MM-DD-YY HH24:MI:SS'),p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
2231: hz_utility_v2pub.debug(p_message=>'return status of find_parties: '||x_return_status,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
2232: hz_utility_v2pub.debug(p_message=>'search_ctx_id: '||l_search_ctx_id,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
2233: if l_num_matches = 0
2234: then