DBA Data[Home] [Help]

APPS.POS_SEARCH_DUP_PARTY_PKG dependencies on FND_API

Line 7: ( p_init_msg_list IN VARCHAR2 := fnd_api.g_true,

3:
4: g_module VARCHAR2(30) := 'POS_SEARCH_DUP_PARTY_PKG';
5:
6: PROCEDURE find_duplicate_parties
7: ( p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
8: p_supp_name IN VARCHAR2,
9: p_supp_name_alt IN VARCHAR2,
10: p_tax_payer_id IN VARCHAR2,
11: p_tax_reg_no IN VARCHAR2,

Line 62: x_return_status := fnd_api.g_ret_sts_error;

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:
66: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

Line 127: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

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
130: (fnd_log.level_error
131: , g_module || '.' || l_method

Line 135: ELSIF (x_return_status = fnd_api.g_ret_sts_success) THEN

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;
137: END IF;
138:
139: RETURN;

Line 179: l_url_return_status VARCHAR2(50):= FND_API.G_RET_STS_SUCCESS;

175:
176: l_url VARCHAR2(100) := p_url;
177: l_contact_point_rec HZ_CONTACT_POINT_V2PUB.contact_point_rec_type;
178: l_url_rec HZ_CONTACT_POINT_V2PUB.web_rec_type;
179: l_url_return_status VARCHAR2(50):= FND_API.G_RET_STS_SUCCESS;
180: l_url_msg_count NUMBER;
181: l_url_msg_data VARCHAR2(1000);
182: l_url_contact_point_id NUMBER;
183:

Line 214: p_init_msg_list => FND_API.G_FALSE,

210: l_org_rec.party_rec := l_party_rec;
211:
212:
213: hz_party_v2pub.create_organization(
214: p_init_msg_list => FND_API.G_FALSE,
215: p_organization_rec => l_org_rec,
216: p_party_usage_code => 'SUPPLIER_PROSPECT',
217: x_return_status => l_org_return_status,
218: x_msg_count => l_org_msg_count,

Line 230: IF l_org_return_status <> fnd_api.g_ret_sts_success THEN

226: x_msg_data := l_org_msg_data;
227:
228: l_step := 'After Calling hz_party_v2pub.create_organization';
229:
230: IF l_org_return_status <> fnd_api.g_ret_sts_success THEN
231:
232: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level) THEN
233: fnd_log.string
234: (fnd_log.level_error

Line 259: p_init_msg_list => FND_API.G_FALSE,

255: l_url_rec.web_type := 'HTTP';
256: l_url_rec.url := l_url;
257:
258: hz_contact_point_v2pub.create_web_contact_point(
259: p_init_msg_list => FND_API.G_FALSE,
260: p_contact_point_rec => l_contact_point_rec,
261: p_web_rec => l_url_rec,
262: x_return_status => l_url_return_status,
263: x_msg_count => l_url_msg_count,

Line 267: IF l_url_return_status <> fnd_api.g_ret_sts_success THEN

263: x_msg_count => l_url_msg_count,
264: x_msg_data => l_url_msg_data,
265: x_contact_point_id => l_url_contact_point_id);
266:
267: IF l_url_return_status <> fnd_api.g_ret_sts_success THEN
268:
269: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level) THEN
270: fnd_log.string(fnd_log.level_error,
271: g_module || '.' || l_method || '.' || l_step,

Line 316: x_return_status := fnd_api.g_ret_sts_success;

312: last_update_date = Sysdate,
313: last_update_login = fnd_global.login_id
314: WHERE supplier_reg_id = l_supp_reg_id;
315:
316: x_return_status := fnd_api.g_ret_sts_success;
317: Exception
318: When no_data_found then
319: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level) THEN
320: fnd_log.string

Line 325: x_return_status := fnd_api.g_ret_sts_error;

321: (fnd_log.level_error
322: , g_module || '.' || l_method||'.'||l_step
323: , 'Error updating party id ');
324: END IF;
325: x_return_status := fnd_api.g_ret_sts_error;
326: When others then
327: x_return_status := fnd_api.g_ret_sts_error;
328: end;
329:

Line 327: x_return_status := fnd_api.g_ret_sts_error;

323: , 'Error updating party id ');
324: END IF;
325: x_return_status := fnd_api.g_ret_sts_error;
326: When others then
327: x_return_status := fnd_api.g_ret_sts_error;
328: end;
329:
330: RETURN;
331: END update_supp_party_id;

Line 391: p_init_msg_list => FND_API.G_FALSE,

387: l_org_rec.party_rec := l_party_rec;
388:
389:
390: hz_party_v2pub.update_organization(
391: p_init_msg_list => FND_API.G_FALSE,
392: p_organization_rec => l_org_rec,
393: p_party_object_version_number => l_party_obj_version,
394: x_profile_id => l_profile_id,
395: x_return_status => l_org_return_status,

Line 406: IF l_org_return_status <> fnd_api.g_ret_sts_success THEN

402: x_msg_data := l_org_msg_data;
403:
404: l_step := 'After Calling hz_party_v2pub.update_Organization';
405:
406: IF l_org_return_status <> fnd_api.g_ret_sts_success THEN
407:
408: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level) THEN
409: fnd_log.string
410: (fnd_log.level_error

Line 422: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,

418: END pos_update_organization;
419:
420:
421: PROCEDURE search_duplicate_parties(
422: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
423: p_party_name IN VARCHAR2,
424: p_party_number IN VARCHAR2,
425: p_status IN VARCHAR2,
426: p_sic_code IN VARCHAR2,

Line 454: x_return_status := fnd_api.g_ret_sts_error;

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:
458: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

Line 495: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

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,
498: g_module || '.' || l_method,
499: 'Error in hz_party_search.search_duplicate_parties ' ||

Line 503: ELSIF (x_return_status = fnd_api.g_ret_sts_success) THEN

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
504: x_search_ctx_id := l_search_ctx_id;
505: END IF;
506:
507: RETURN;

Line 537: x_return_status := fnd_api.g_ret_sts_error;

533: BEGIN
534:
535: l_method := 'enable_party_as_supplier';
536: l_step := 'Before Calling pos_vendor_pub_pkg.create_vendor';
537: x_return_status := fnd_api.g_ret_sts_error;
538: x_msg_count := 0;
539: x_msg_data := NULL;
540:
541: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

Line 588: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

584: );
585: END IF;
586: l_step := 'After Calling pos_vendor_pub_pkg.create_vendor';
587:
588: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
589: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level) THEN
590: fnd_log.string(fnd_log.level_error,
591: g_module || '.' || l_method,
592: 'Error in pos_vendor_pub_pkg.create_vendor' ||

Line 596: ELSIF (x_return_status = fnd_api.g_ret_sts_success) THEN

592: 'Error in pos_vendor_pub_pkg.create_vendor' ||
593: x_msg_data);
594: END IF;
595: RETURN;
596: ELSIF (x_return_status = fnd_api.g_ret_sts_success) THEN
597: x_vendor_id := l_vendor_id;
598: END IF;
599:
600: RETURN;

Line 616: x_return_status := fnd_api.g_ret_sts_error;

612: l_method VARCHAR2(100);
613: BEGIN
614: l_method := 'assign_party_usage';
615: l_step := 'Before Calling HZ_PARTY_USG_ASSIGNMENT_PVT.assign_party_usage';
616: x_return_status := fnd_api.g_ret_sts_error;
617: x_msg_count := 0;
618: x_msg_data := NULL;
619:
620: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

Line 640: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

636: x_msg_count => x_msg_count,
637: x_msg_data => x_msg_data);
638:
639: l_step := 'After Calling HZ_PARTY_USG_ASSIGNMENT_PVT.assign_party_usage';
640: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
641: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level) THEN
642: fnd_log.string(fnd_log.level_error,
643: g_module || '.' || l_method,
644: 'Error in HZ_PARTY_USG_ASSIGNMENT_PVT.assign_party_usage' ||