DBA Data[Home] [Help]

APPS.POS_SEARCH_DUP_PARTY_PKG dependencies on HZ_PARTY_SEARCH

Line 20: l_party_search_rec hz_party_search.party_search_rec_type;

16: x_return_status OUT NOCOPY VARCHAR2,
17: x_msg_count OUT NOCOPY NUMBER,
18: x_msg_data OUT NOCOPY VARCHAR2)
19: IS
20: l_party_search_rec hz_party_search.party_search_rec_type;
21: l_search_ctx_id NUMBER;
22: l_num_matches NUMBER;
23: l_party_site_list hz_party_search.party_site_list;
24: l_contact_list hz_party_search.contact_list;

Line 23: l_party_site_list hz_party_search.party_site_list;

19: IS
20: l_party_search_rec hz_party_search.party_search_rec_type;
21: l_search_ctx_id NUMBER;
22: l_num_matches NUMBER;
23: l_party_site_list hz_party_search.party_site_list;
24: l_contact_list hz_party_search.contact_list;
25: l_contact_point_list hz_party_search.contact_point_list;
26: l_supp_name VARCHAR2(100) := p_supp_name;
27: l_restrict_sql VARCHAR2(20) := NULL;

Line 24: l_contact_list hz_party_search.contact_list;

20: l_party_search_rec hz_party_search.party_search_rec_type;
21: l_search_ctx_id NUMBER;
22: l_num_matches NUMBER;
23: l_party_site_list hz_party_search.party_site_list;
24: l_contact_list hz_party_search.contact_list;
25: l_contact_point_list hz_party_search.contact_point_list;
26: l_supp_name VARCHAR2(100) := p_supp_name;
27: l_restrict_sql VARCHAR2(20) := NULL;
28: l_match_type VARCHAR2(20) := NULL;

Line 25: l_contact_point_list hz_party_search.contact_point_list;

21: l_search_ctx_id NUMBER;
22: l_num_matches NUMBER;
23: l_party_site_list hz_party_search.party_site_list;
24: l_contact_list hz_party_search.contact_list;
25: l_contact_point_list hz_party_search.contact_point_list;
26: l_supp_name VARCHAR2(100) := p_supp_name;
27: l_restrict_sql VARCHAR2(20) := NULL;
28: l_match_type VARCHAR2(20) := NULL;
29: l_search_merged VARCHAR2(20) := NULL;

Line 61: l_step := 'Before Calling hz_party_search.find_parties';

57:
58: BEGIN
59:
60: l_method := 'find_duplicate_parties';
61: l_step := 'Before Calling hz_party_search.find_parties';
62: x_return_status := fnd_api.g_ret_sts_error;
63: x_msg_count := 0;
64: x_msg_data := NULL;
65:

Line 110: hz_party_search.find_parties(

106: l_contact_point_list(cntc_cnt).phone_number := cntc_rec.phone_number;
107: end if;
108: end loop;
109:
110: hz_party_search.find_parties(
111: p_init_msg_list,
112: l_rule_id,
113: l_party_search_rec,
114: l_party_site_list,

Line 125: l_step := 'After Calling hz_party_search.find_parties';

121: x_return_status,
122: x_msg_count,
123: x_msg_data);
124:
125: l_step := 'After Calling hz_party_search.find_parties';
126:
127: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
128: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level) THEN
129: fnd_log.string

Line 132: , 'Error in hz_party_search.find_parties ' || x_msg_data);

128: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level) THEN
129: fnd_log.string
130: (fnd_log.level_error
131: , g_module || '.' || l_method
132: , 'Error in hz_party_search.find_parties ' || x_msg_data);
133: END IF;
134: RETURN;
135: ELSIF (x_return_status = fnd_api.g_ret_sts_success) THEN
136: x_search_ctx_id := l_search_ctx_id;

Line 436: l_party_search_rec hz_party_search.party_search_rec_type;

432: x_return_status OUT NOCOPY VARCHAR2,
433: x_msg_count OUT NOCOPY NUMBER,
434: x_msg_data OUT NOCOPY VARCHAR2)
435: IS
436: l_party_search_rec hz_party_search.party_search_rec_type;
437: l_search_ctx_id NUMBER;
438: l_num_matches NUMBER;
439: l_party_site_list hz_party_search.party_site_list;
440: l_contact_list hz_party_search.contact_list;

Line 439: l_party_site_list hz_party_search.party_site_list;

435: IS
436: l_party_search_rec hz_party_search.party_search_rec_type;
437: l_search_ctx_id NUMBER;
438: l_num_matches NUMBER;
439: l_party_site_list hz_party_search.party_site_list;
440: l_contact_list hz_party_search.contact_list;
441: l_contact_point_list hz_party_search.contact_point_list;
442: l_party_name VARCHAR2(100) := p_party_name;
443: l_restrict_sql VARCHAR2(20) := NULL;

Line 440: l_contact_list hz_party_search.contact_list;

436: l_party_search_rec hz_party_search.party_search_rec_type;
437: l_search_ctx_id NUMBER;
438: l_num_matches NUMBER;
439: l_party_site_list hz_party_search.party_site_list;
440: l_contact_list hz_party_search.contact_list;
441: l_contact_point_list hz_party_search.contact_point_list;
442: l_party_name VARCHAR2(100) := p_party_name;
443: l_restrict_sql VARCHAR2(20) := NULL;
444: l_match_type VARCHAR2(20) := NULL;

Line 441: l_contact_point_list hz_party_search.contact_point_list;

437: l_search_ctx_id NUMBER;
438: l_num_matches NUMBER;
439: l_party_site_list hz_party_search.party_site_list;
440: l_contact_list hz_party_search.contact_list;
441: l_contact_point_list hz_party_search.contact_point_list;
442: l_party_name VARCHAR2(100) := p_party_name;
443: l_restrict_sql VARCHAR2(20) := NULL;
444: l_match_type VARCHAR2(20) := NULL;
445: l_search_merged VARCHAR2(20) := NULL;

Line 453: l_step := 'Before Calling hz_party_search.search_duplicate_parties';

449:
450: BEGIN
451:
452: l_method := 'search_duplicate_parties';
453: l_step := 'Before Calling hz_party_search.search_duplicate_parties';
454: x_return_status := fnd_api.g_ret_sts_error;
455: x_msg_count := 0;
456: x_msg_data := NULL;
457:

Line 479: hz_party_search.find_parties(p_init_msg_list,

475: l_party_site_list(1).city := p_city;
476: l_party_site_list(1).state := p_state;
477: l_party_site_list(1).country := p_country;
478:
479: hz_party_search.find_parties(p_init_msg_list,
480: l_rule_id,
481: l_party_search_rec,
482: l_party_site_list,
483: l_contact_list,

Line 493: l_step := 'After Calling hz_party_search.search_duplicate_parties';

489: x_return_status,
490: x_msg_count,
491: x_msg_data);
492:
493: l_step := 'After Calling hz_party_search.search_duplicate_parties';
494:
495: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
496: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level) THEN
497: fnd_log.string(fnd_log.level_error,

Line 499: 'Error in hz_party_search.search_duplicate_parties ' ||

495: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
496: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level) THEN
497: fnd_log.string(fnd_log.level_error,
498: g_module || '.' || l_method,
499: 'Error in hz_party_search.search_duplicate_parties ' ||
500: x_msg_data);
501: END IF;
502: RETURN;
503: ELSIF (x_return_status = fnd_api.g_ret_sts_success) THEN