DBA Data[Home] [Help]

APPS.POS_SUPPLIER_ADDRESS_PKG dependencies on FND_API

Line 64: x_return_status := fnd_api.g_ret_sts_success;

60: , l_step || ' found an existing record'
61: );
62: END IF;
63:
64: x_return_status := fnd_api.g_ret_sts_success;
65: RETURN;
66: ELSE
67: l_step := 'call hz_party_site_v2pub.create_party_site_use';
68:

Line 76: ( p_init_msg_list => FND_API.G_FALSE,

72: l_party_site_use_rec.status := 'A';
73: l_party_site_use_rec.site_use_type := p_address_type;
74:
75: hz_party_site_v2pub.create_party_site_use
76: ( p_init_msg_list => FND_API.G_FALSE,
77: p_party_site_use_rec => l_party_site_use_rec,
78: x_party_site_use_id => x_party_site_use_id,
79: x_return_status => x_return_status,
80: x_msg_count => x_msg_count,

Line 85: IF x_return_status = FND_API.g_ret_sts_success THEN

81: x_msg_data => x_msg_data
82: );
83:
84: -- log_callresult x_party_site_use_id
85: IF x_return_status = FND_API.g_ret_sts_success THEN
86: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
87: fnd_log.string( fnd_log.level_statement
88: , g_module || '.' || l_method
89: , l_step || ' x_party_site_use_id = ' || x_party_site_use_id

Line 162: x_return_status := fnd_api.g_ret_sts_success;

158: , l_step || ' existing record not found so no record to end-date.'
159: );
160: END IF;
161:
162: x_return_status := fnd_api.g_ret_sts_success;
163: RETURN;
164: ELSE
165: l_step := 'call hz_party_site_v2pub.update_party_site_use';
166: l_party_site_use_rec.party_site_use_id := l_rec.party_site_use_id;

Line 170: ( p_init_msg_list => FND_API.G_FALSE,

166: l_party_site_use_rec.party_site_use_id := l_rec.party_site_use_id;
167: l_party_site_use_rec.status := 'I';
168:
169: hz_party_site_v2pub.update_party_site_use
170: ( p_init_msg_list => FND_API.G_FALSE,
171: p_party_site_use_rec => l_party_site_use_rec,
172: p_object_version_number => l_rec.object_version_number,
173: x_return_status => x_return_status,
174: x_msg_count => x_msg_count,

Line 178: IF x_return_status = FND_API.g_ret_sts_success THEN

174: x_msg_count => x_msg_count,
175: x_msg_data => x_msg_data
176: );
177:
178: IF x_return_status = FND_API.g_ret_sts_success THEN
179: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
180: fnd_log.string( fnd_log.level_statement
181: , g_module || '.' || l_method
182: , l_step || ' succeeded'

Line 365: IF x_return_status IS NULL OR x_return_status <> fnd_api.g_ret_sts_success THEN

361: x_return_status => x_return_status,
362: x_msg_count => x_msg_count,
363: x_msg_data => x_msg_data);
364:
365: IF x_return_status IS NULL OR x_return_status <> fnd_api.g_ret_sts_success THEN
366: ROLLBACK TO create_supplier_address_sp;
367: RETURN;
368: END IF;
369:

Line 389: IF x_return_status IS NULL OR x_return_status <> fnd_api.g_ret_sts_success THEN

385: x_msg_count => x_msg_count,
386: x_msg_data => x_msg_data
387: );
388:
389: IF x_return_status IS NULL OR x_return_status <> fnd_api.g_ret_sts_success THEN
390: ROLLBACK TO create_supplier_address_sp;
391: RETURN;
392: END IF;
393:

Line 405: IF x_return_status IS NULL OR x_return_status <> fnd_api.g_ret_sts_success THEN

401: x_msg_count => x_msg_count,
402: x_msg_data => x_msg_data
403: );
404:
405: IF x_return_status IS NULL OR x_return_status <> fnd_api.g_ret_sts_success THEN
406: ROLLBACK TO create_supplier_address_sp;
407: RETURN;
408: END IF;
409:

Line 421: IF x_return_status IS NULL OR x_return_status <> fnd_api.g_ret_sts_success THEN

417: x_return_status => x_return_status,
418: x_msg_count => x_msg_count,
419: x_msg_data => x_msg_data
420: );
421: IF x_return_status IS NULL OR x_return_status <> fnd_api.g_ret_sts_success THEN
422: ROLLBACK TO create_supplier_address_sp;
423: RETURN;
424: END IF;
425: END IF;

Line 436: IF x_return_status IS NULL OR x_return_status <> fnd_api.g_ret_sts_success THEN

432: x_return_status => x_return_status,
433: x_msg_count => x_msg_count,
434: x_msg_data => x_msg_data
435: );
436: IF x_return_status IS NULL OR x_return_status <> fnd_api.g_ret_sts_success THEN
437: ROLLBACK TO create_supplier_address_sp;
438: RETURN;
439: END IF;
440: END IF;

Line 451: IF x_return_status IS NULL OR x_return_status <> fnd_api.g_ret_sts_success THEN

447: x_return_status => x_return_status,
448: x_msg_count => x_msg_count,
449: x_msg_data => x_msg_data
450: );
451: IF x_return_status IS NULL OR x_return_status <> fnd_api.g_ret_sts_success THEN
452: ROLLBACK TO create_supplier_address_sp;
453: RETURN;
454: END IF;
455: END IF;

Line 466: -- IF x_return_status IS NULL OR x_return_status <> fnd_api.g_ret_sts_success THEN

462: -- x_return_status => x_return_status,
463: -- x_msg_count => x_msg_count,
464: -- x_msg_data => x_msg_data
465: -- );
466: -- IF x_return_status IS NULL OR x_return_status <> fnd_api.g_ret_sts_success THEN
467: -- RETURN;
468: -- END IF;
469: NULL;
470: END IF;

Line 485: x_return_status <> fnd_api.g_ret_sts_success THEN

481: x_msg_data => x_msg_data
482: );
483:
484: IF x_return_status IS NULL OR
485: x_return_status <> fnd_api.g_ret_sts_success THEN
486: ROLLBACK TO create_supplier_address_sp;
487: RETURN;
488: END IF;
489:

Line 503: x_return_status <> fnd_api.g_ret_sts_success THEN

499: x_msg_data => x_msg_data
500: );
501:
502: IF x_return_status IS NULL OR
503: x_return_status <> fnd_api.g_ret_sts_success THEN
504: ROLLBACK TO create_supplier_address_sp;
505: RETURN;
506: END IF;
507:

Line 518: x_return_status <> fnd_api.g_ret_sts_success THEN

514: x_msg_data => x_msg_data
515: );
516:
517: IF x_return_status IS NULL OR
518: x_return_status <> fnd_api.g_ret_sts_success THEN
519: ROLLBACK TO create_supplier_address_sp;
520: RETURN;
521: END IF;
522:

Line 572: x_return_status <> fnd_api.g_ret_sts_success) THEN

568: x_party_site_id => l_dummy_party_site_id,
569: x_location_id => l_dummy_location_id);
570:
571: IF (x_return_status IS NULL OR
572: x_return_status <> fnd_api.g_ret_sts_success) THEN
573: ROLLBACK TO create_supplier_address_sp;
574: RETURN;
575: END IF;
576: END IF;

Line 609: IF x_return_status IS NULL OR x_return_status <> fnd_api.g_ret_sts_success THEN

605: x_party_site_id => l_dummy_party_site_id,
606: x_location_id => l_dummy_location_id
607: );
608:
609: IF x_return_status IS NULL OR x_return_status <> fnd_api.g_ret_sts_success THEN
610: ROLLBACK TO create_supplier_address_sp;
611: RETURN;
612: END IF;
613:

Line 617: x_return_status := fnd_api.g_ret_sts_success;

613:
614: END LOOP;
615: END IF;
616:
617: x_return_status := fnd_api.g_ret_sts_success;
618:
619: EXCEPTION
620: WHEN OTHERS THEN
621: ROLLBACK TO create_supplier_address_sp;

Line 622: x_return_status := fnd_api.g_ret_sts_unexp_error;

618:
619: EXCEPTION
620: WHEN OTHERS THEN
621: ROLLBACK TO create_supplier_address_sp;
622: x_return_status := fnd_api.g_ret_sts_unexp_error;
623: x_msg_data := Sqlerrm;
624: x_msg_count := 1;
625: pos_log.log_sqlerrm('POSSAB','create_supplier_address');
626: END create_supplier_address;

Line 701: l_location_rec.address1 := Nvl(p_address_line1, fnd_api.g_miss_char);

697: END IF;
698: CLOSE l_cur2;
699:
700: l_location_rec.location_id := l_rec.location_id;
701: l_location_rec.address1 := Nvl(p_address_line1, fnd_api.g_miss_char);
702: l_location_rec.address2 := Nvl(p_address_line2, fnd_api.g_miss_char);
703: l_location_rec.address3 := Nvl(p_address_line3, fnd_api.g_miss_char);
704: l_location_rec.address4 := Nvl(p_address_line4, fnd_api.g_miss_char);
705: l_location_rec.city := Nvl(p_city , fnd_api.g_miss_char);

Line 702: l_location_rec.address2 := Nvl(p_address_line2, fnd_api.g_miss_char);

698: CLOSE l_cur2;
699:
700: l_location_rec.location_id := l_rec.location_id;
701: l_location_rec.address1 := Nvl(p_address_line1, fnd_api.g_miss_char);
702: l_location_rec.address2 := Nvl(p_address_line2, fnd_api.g_miss_char);
703: l_location_rec.address3 := Nvl(p_address_line3, fnd_api.g_miss_char);
704: l_location_rec.address4 := Nvl(p_address_line4, fnd_api.g_miss_char);
705: l_location_rec.city := Nvl(p_city , fnd_api.g_miss_char);
706: l_location_rec.postal_code := Nvl(p_postal_code , fnd_api.g_miss_char);

Line 703: l_location_rec.address3 := Nvl(p_address_line3, fnd_api.g_miss_char);

699:
700: l_location_rec.location_id := l_rec.location_id;
701: l_location_rec.address1 := Nvl(p_address_line1, fnd_api.g_miss_char);
702: l_location_rec.address2 := Nvl(p_address_line2, fnd_api.g_miss_char);
703: l_location_rec.address3 := Nvl(p_address_line3, fnd_api.g_miss_char);
704: l_location_rec.address4 := Nvl(p_address_line4, fnd_api.g_miss_char);
705: l_location_rec.city := Nvl(p_city , fnd_api.g_miss_char);
706: l_location_rec.postal_code := Nvl(p_postal_code , fnd_api.g_miss_char);
707: l_location_rec.state := Nvl(p_state , fnd_api.g_miss_char);

Line 704: l_location_rec.address4 := Nvl(p_address_line4, fnd_api.g_miss_char);

700: l_location_rec.location_id := l_rec.location_id;
701: l_location_rec.address1 := Nvl(p_address_line1, fnd_api.g_miss_char);
702: l_location_rec.address2 := Nvl(p_address_line2, fnd_api.g_miss_char);
703: l_location_rec.address3 := Nvl(p_address_line3, fnd_api.g_miss_char);
704: l_location_rec.address4 := Nvl(p_address_line4, fnd_api.g_miss_char);
705: l_location_rec.city := Nvl(p_city , fnd_api.g_miss_char);
706: l_location_rec.postal_code := Nvl(p_postal_code , fnd_api.g_miss_char);
707: l_location_rec.state := Nvl(p_state , fnd_api.g_miss_char);
708: l_location_rec.province := Nvl(p_province , fnd_api.g_miss_char);

Line 705: l_location_rec.city := Nvl(p_city , fnd_api.g_miss_char);

701: l_location_rec.address1 := Nvl(p_address_line1, fnd_api.g_miss_char);
702: l_location_rec.address2 := Nvl(p_address_line2, fnd_api.g_miss_char);
703: l_location_rec.address3 := Nvl(p_address_line3, fnd_api.g_miss_char);
704: l_location_rec.address4 := Nvl(p_address_line4, fnd_api.g_miss_char);
705: l_location_rec.city := Nvl(p_city , fnd_api.g_miss_char);
706: l_location_rec.postal_code := Nvl(p_postal_code , fnd_api.g_miss_char);
707: l_location_rec.state := Nvl(p_state , fnd_api.g_miss_char);
708: l_location_rec.province := Nvl(p_province , fnd_api.g_miss_char);
709: l_location_rec.county := Nvl(p_county , fnd_api.g_miss_char);

Line 706: l_location_rec.postal_code := Nvl(p_postal_code , fnd_api.g_miss_char);

702: l_location_rec.address2 := Nvl(p_address_line2, fnd_api.g_miss_char);
703: l_location_rec.address3 := Nvl(p_address_line3, fnd_api.g_miss_char);
704: l_location_rec.address4 := Nvl(p_address_line4, fnd_api.g_miss_char);
705: l_location_rec.city := Nvl(p_city , fnd_api.g_miss_char);
706: l_location_rec.postal_code := Nvl(p_postal_code , fnd_api.g_miss_char);
707: l_location_rec.state := Nvl(p_state , fnd_api.g_miss_char);
708: l_location_rec.province := Nvl(p_province , fnd_api.g_miss_char);
709: l_location_rec.county := Nvl(p_county , fnd_api.g_miss_char);
710: l_location_rec.country := Nvl(p_country , fnd_api.g_miss_char);

Line 707: l_location_rec.state := Nvl(p_state , fnd_api.g_miss_char);

703: l_location_rec.address3 := Nvl(p_address_line3, fnd_api.g_miss_char);
704: l_location_rec.address4 := Nvl(p_address_line4, fnd_api.g_miss_char);
705: l_location_rec.city := Nvl(p_city , fnd_api.g_miss_char);
706: l_location_rec.postal_code := Nvl(p_postal_code , fnd_api.g_miss_char);
707: l_location_rec.state := Nvl(p_state , fnd_api.g_miss_char);
708: l_location_rec.province := Nvl(p_province , fnd_api.g_miss_char);
709: l_location_rec.county := Nvl(p_county , fnd_api.g_miss_char);
710: l_location_rec.country := Nvl(p_country , fnd_api.g_miss_char);
711:

Line 708: l_location_rec.province := Nvl(p_province , fnd_api.g_miss_char);

704: l_location_rec.address4 := Nvl(p_address_line4, fnd_api.g_miss_char);
705: l_location_rec.city := Nvl(p_city , fnd_api.g_miss_char);
706: l_location_rec.postal_code := Nvl(p_postal_code , fnd_api.g_miss_char);
707: l_location_rec.state := Nvl(p_state , fnd_api.g_miss_char);
708: l_location_rec.province := Nvl(p_province , fnd_api.g_miss_char);
709: l_location_rec.county := Nvl(p_county , fnd_api.g_miss_char);
710: l_location_rec.country := Nvl(p_country , fnd_api.g_miss_char);
711:
712: l_obj_ver := l_rec.object_version_number;

Line 709: l_location_rec.county := Nvl(p_county , fnd_api.g_miss_char);

705: l_location_rec.city := Nvl(p_city , fnd_api.g_miss_char);
706: l_location_rec.postal_code := Nvl(p_postal_code , fnd_api.g_miss_char);
707: l_location_rec.state := Nvl(p_state , fnd_api.g_miss_char);
708: l_location_rec.province := Nvl(p_province , fnd_api.g_miss_char);
709: l_location_rec.county := Nvl(p_county , fnd_api.g_miss_char);
710: l_location_rec.country := Nvl(p_country , fnd_api.g_miss_char);
711:
712: l_obj_ver := l_rec.object_version_number;
713:

Line 710: l_location_rec.country := Nvl(p_country , fnd_api.g_miss_char);

706: l_location_rec.postal_code := Nvl(p_postal_code , fnd_api.g_miss_char);
707: l_location_rec.state := Nvl(p_state , fnd_api.g_miss_char);
708: l_location_rec.province := Nvl(p_province , fnd_api.g_miss_char);
709: l_location_rec.county := Nvl(p_county , fnd_api.g_miss_char);
710: l_location_rec.country := Nvl(p_country , fnd_api.g_miss_char);
711:
712: l_obj_ver := l_rec.object_version_number;
713:
714: hz_location_v2pub.update_location

Line 715: ( p_init_msg_list => fnd_api.g_true,

711:
712: l_obj_ver := l_rec.object_version_number;
713:
714: hz_location_v2pub.update_location
715: ( p_init_msg_list => fnd_api.g_true,
716: p_location_rec => l_location_rec,
717: p_object_version_number => l_obj_ver,
718: x_return_status => x_return_status,
719: x_msg_count => x_msg_count,

Line 723: IF x_return_status IS NULL OR x_return_status <> fnd_api.g_ret_sts_success THEN

719: x_msg_count => x_msg_count,
720: x_msg_data => x_msg_data
721: );
722:
723: IF x_return_status IS NULL OR x_return_status <> fnd_api.g_ret_sts_success THEN
724: ROLLBACK TO update_supplier_address_sp;
725: RETURN;
726: END IF;
727:

Line 736: (p_init_msg_list => fnd_api.g_false,

732: l_party_site_rec.party_site_id := p_party_site_id;
733: l_party_site_rec.party_site_name := p_party_site_name;
734:
735: hz_party_site_v2pub.update_party_site
736: (p_init_msg_list => fnd_api.g_false,
737: p_party_site_rec => l_party_site_rec,
738: p_object_version_number => l_rec2.object_version_number,
739: x_return_status => x_return_status,
740: x_msg_count => x_msg_count,

Line 744: IF x_return_status IS NULL OR x_return_status <> fnd_api.g_ret_sts_success THEN

740: x_msg_count => x_msg_count,
741: x_msg_data => x_msg_data
742: );
743:
744: IF x_return_status IS NULL OR x_return_status <> fnd_api.g_ret_sts_success THEN
745: ROLLBACK TO update_supplier_address_sp;
746: RETURN;
747: END IF;
748: END IF;

Line 763: IF x_return_status IS NULL OR x_return_status <> fnd_api.g_ret_sts_success THEN

759: x_msg_count => x_msg_count,
760: x_msg_data => x_msg_data
761: );
762:
763: IF x_return_status IS NULL OR x_return_status <> fnd_api.g_ret_sts_success THEN
764: ROLLBACK TO update_supplier_address_sp;
765: RETURN;
766: END IF;
767:

Line 781: IF x_return_status IS NULL OR x_return_status <> fnd_api.g_ret_sts_success THEN

777: x_msg_count => x_msg_count,
778: x_msg_data => x_msg_data
779: );
780:
781: IF x_return_status IS NULL OR x_return_status <> fnd_api.g_ret_sts_success THEN
782: ROLLBACK TO update_supplier_address_sp;
783: RETURN;
784: END IF;
785:

Line 796: IF x_return_status IS NULL OR x_return_status <> fnd_api.g_ret_sts_success THEN

792: x_msg_count => x_msg_count,
793: x_msg_data => x_msg_data
794: );
795:
796: IF x_return_status IS NULL OR x_return_status <> fnd_api.g_ret_sts_success THEN
797: ROLLBACK TO update_supplier_address_sp;
798: RETURN;
799: END IF;
800:

Line 810: IF x_return_status IS NULL OR x_return_status <> fnd_api.g_ret_sts_success THEN

806: x_msg_count => x_msg_count,
807: x_msg_data => x_msg_data
808: );
809:
810: IF x_return_status IS NULL OR x_return_status <> fnd_api.g_ret_sts_success THEN
811: ROLLBACK TO update_supplier_address_sp;
812: RETURN;
813: END IF;
814:

Line 824: IF x_return_status IS NULL OR x_return_status <> fnd_api.g_ret_sts_success THEN

820: x_msg_count => x_msg_count,
821: x_msg_data => x_msg_data
822: );
823:
824: IF x_return_status IS NULL OR x_return_status <> fnd_api.g_ret_sts_success THEN
825: ROLLBACK TO update_supplier_address_sp;
826: RETURN;
827: END IF;
828:

Line 838: IF x_return_status IS NULL OR x_return_status <> fnd_api.g_ret_sts_success THEN

834: x_msg_count => x_msg_count,
835: x_msg_data => x_msg_data
836: );
837:
838: IF x_return_status IS NULL OR x_return_status <> fnd_api.g_ret_sts_success THEN
839: ROLLBACK TO update_supplier_address_sp;
840: RETURN;
841: END IF;
842:

Line 844: x_return_status := fnd_api.g_ret_sts_success;

840: RETURN;
841: END IF;
842:
843: -- logic for primary pay still need to be worked out
844: x_return_status := fnd_api.g_ret_sts_success;
845:
846: END update_supplier_address;
847:
848: PROCEDURE unassign_address_to_contact

Line 904: p_init_msg_list => FND_API.G_TRUE,

900:
901: AP_VENDOR_PUB_PKG.Update_Vendor_Contact
902: (
903: p_api_version => 1.0,
904: p_init_msg_list => FND_API.G_TRUE,
905: p_commit => FND_API.G_FALSE,
906: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
907: p_vendor_contact_rec => l_vendor_contact_rec,
908: x_return_status => x_return_status,

Line 905: p_commit => FND_API.G_FALSE,

901: AP_VENDOR_PUB_PKG.Update_Vendor_Contact
902: (
903: p_api_version => 1.0,
904: p_init_msg_list => FND_API.G_TRUE,
905: p_commit => FND_API.G_FALSE,
906: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
907: p_vendor_contact_rec => l_vendor_contact_rec,
908: x_return_status => x_return_status,
909: x_msg_count => x_msg_count,

Line 906: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

902: (
903: p_api_version => 1.0,
904: p_init_msg_list => FND_API.G_TRUE,
905: p_commit => FND_API.G_FALSE,
906: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
907: p_vendor_contact_rec => l_vendor_contact_rec,
908: x_return_status => x_return_status,
909: x_msg_count => x_msg_count,
910: x_msg_data => x_msg_data

Line 995: p_init_msg_list => FND_API.G_TRUE,

991:
992: AP_VENDOR_PUB_PKG.Update_Vendor_Contact
993: (
994: p_api_version => 1.0,
995: p_init_msg_list => FND_API.G_TRUE,
996: p_commit => FND_API.G_FALSE,
997: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
998: p_vendor_contact_rec => l_vendor_contact_rec,
999: x_return_status => x_return_status,

Line 996: p_commit => FND_API.G_FALSE,

992: AP_VENDOR_PUB_PKG.Update_Vendor_Contact
993: (
994: p_api_version => 1.0,
995: p_init_msg_list => FND_API.G_TRUE,
996: p_commit => FND_API.G_FALSE,
997: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
998: p_vendor_contact_rec => l_vendor_contact_rec,
999: x_return_status => x_return_status,
1000: x_msg_count => x_msg_count,

Line 997: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

993: (
994: p_api_version => 1.0,
995: p_init_msg_list => FND_API.G_TRUE,
996: p_commit => FND_API.G_FALSE,
997: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
998: p_vendor_contact_rec => l_vendor_contact_rec,
999: x_return_status => x_return_status,
1000: x_msg_count => x_msg_count,
1001: x_msg_data => x_msg_data

Line 1102: x_return_status := fnd_api.g_ret_sts_success;

1098: FETCH l_cur INTO l_number;
1099: IF l_cur%found THEN
1100: -- already has such assignment
1101: CLOSE l_cur;
1102: x_return_status := fnd_api.g_ret_sts_success;
1103: x_msg_count := 1;
1104: x_msg_data := NULL;
1105: RETURN;
1106: END IF;

Line 1114: x_return_status := fnd_api.g_ret_sts_error;

1110: OPEN l_cur3;
1111: FETCH l_cur3 INTO l_rec3;
1112: IF l_cur3%notfound THEN
1113: CLOSE l_cur3;
1114: x_return_status := fnd_api.g_ret_sts_error;
1115: x_msg_count := 1;
1116: x_msg_data := 'invalid supplier contact info';
1117: RETURN;
1118: END IF;

Line 1239: p_init_msg_list => FND_API.G_FALSE,

1235:
1236: AP_VENDOR_PUB_PKG.Update_Address_Assignments_DFF
1237: (
1238: p_api_version => 1,
1239: p_init_msg_list => FND_API.G_FALSE,
1240: p_commit => FND_API.G_FALSE,
1241: p_contact_party_id => x_contact_party_id,
1242: p_org_party_site_id => x_org_party_site_id,
1243: p_attribute_category=> x_attribute_category,

Line 1240: p_commit => FND_API.G_FALSE,

1236: AP_VENDOR_PUB_PKG.Update_Address_Assignments_DFF
1237: (
1238: p_api_version => 1,
1239: p_init_msg_list => FND_API.G_FALSE,
1240: p_commit => FND_API.G_FALSE,
1241: p_contact_party_id => x_contact_party_id,
1242: p_org_party_site_id => x_org_party_site_id,
1243: p_attribute_category=> x_attribute_category,
1244: p_attribute1 => x_attribute1,

Line 1278: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1274:
1275: EXCEPTION
1276: WHEN OTHERS
1277: THEN
1278: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1279:
1280: END update_address_assignment_dff;
1281:
1282: /* Bug 6599374 End */

Line 1328: IF x_return_status IS NULL OR x_return_status <> fnd_api.g_ret_sts_success THEN

1324: x_msg_count => x_msg_count,
1325: x_msg_data => x_msg_data
1326: );
1327:
1328: IF x_return_status IS NULL OR x_return_status <> fnd_api.g_ret_sts_success THEN
1329: ROLLBACK TO update_supplier_address_sp;
1330: RETURN;
1331: END IF;
1332:

Line 1346: IF x_return_status IS NULL OR x_return_status <> fnd_api.g_ret_sts_success THEN

1342: x_msg_count => x_msg_count,
1343: x_msg_data => x_msg_data
1344: );
1345:
1346: IF x_return_status IS NULL OR x_return_status <> fnd_api.g_ret_sts_success THEN
1347: ROLLBACK TO update_supplier_address_sp;
1348: RETURN;
1349: END IF;
1350:

Line 1361: IF x_return_status IS NULL OR x_return_status <> fnd_api.g_ret_sts_success THEN

1357: x_msg_count => x_msg_count,
1358: x_msg_data => x_msg_data
1359: );
1360:
1361: IF x_return_status IS NULL OR x_return_status <> fnd_api.g_ret_sts_success THEN
1362: ROLLBACK TO update_supplier_address_sp;
1363: RETURN;
1364: END IF;
1365:

Line 1375: IF x_return_status IS NULL OR x_return_status <> fnd_api.g_ret_sts_success THEN

1371: x_msg_count => x_msg_count,
1372: x_msg_data => x_msg_data
1373: );
1374:
1375: IF x_return_status IS NULL OR x_return_status <> fnd_api.g_ret_sts_success THEN
1376: ROLLBACK TO update_supplier_address_sp;
1377: RETURN;
1378: END IF;
1379:

Line 1389: IF x_return_status IS NULL OR x_return_status <> fnd_api.g_ret_sts_success THEN

1385: x_msg_count => x_msg_count,
1386: x_msg_data => x_msg_data
1387: );
1388:
1389: IF x_return_status IS NULL OR x_return_status <> fnd_api.g_ret_sts_success THEN
1390: ROLLBACK TO update_supplier_address_sp;
1391: RETURN;
1392: END IF;
1393:

Line 1403: IF x_return_status IS NULL OR x_return_status <> fnd_api.g_ret_sts_success THEN

1399: x_msg_count => x_msg_count,
1400: x_msg_data => x_msg_data
1401: );
1402:
1403: IF x_return_status IS NULL OR x_return_status <> fnd_api.g_ret_sts_success THEN
1404: ROLLBACK TO update_supplier_address_sp;
1405: RETURN;
1406: END IF;
1407:

Line 1417: x_return_status := fnd_api.g_ret_sts_error;

1413: x_exception_msg => l_msg
1414: );
1415:
1416: IF l_status IS NULL OR l_status <> 'S' THEN
1417: x_return_status := fnd_api.g_ret_sts_error;
1418: x_msg_data := l_msg;
1419: IF l_msg IS NOT NULL THEN
1420: x_msg_count := 1;
1421: ELSE

Line 1425: x_return_status := fnd_api.g_ret_sts_success;

1421: ELSE
1422: x_msg_count := 0;
1423: END IF;
1424: ELSE
1425: x_return_status := fnd_api.g_ret_sts_success;
1426: END IF;
1427:
1428: END buyer_update_address_details;
1429: