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.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 338: IF x_return_status IS NULL OR x_return_status <> fnd_api.g_ret_sts_success THEN

334: check_payables_options(x_return_status => x_return_status,
335: x_msg_count => x_msg_count,
336: x_msg_data => x_msg_data);
337:
338: IF x_return_status IS NULL OR x_return_status <> fnd_api.g_ret_sts_success THEN
339: ROLLBACK TO create_supplier_address_sp;
340: RETURN;
341: END IF;
342:

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

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

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

374: x_msg_count => x_msg_count,
375: x_msg_data => x_msg_data
376: );
377:
378: IF x_return_status IS NULL OR x_return_status <> fnd_api.g_ret_sts_success THEN
379: ROLLBACK TO create_supplier_address_sp;
380: RETURN;
381: END IF;
382:

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

390: x_return_status => x_return_status,
391: x_msg_count => x_msg_count,
392: x_msg_data => x_msg_data
393: );
394: IF x_return_status IS NULL OR x_return_status <> fnd_api.g_ret_sts_success THEN
395: ROLLBACK TO create_supplier_address_sp;
396: RETURN;
397: END IF;
398: END IF;

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

405: x_return_status => x_return_status,
406: x_msg_count => x_msg_count,
407: x_msg_data => x_msg_data
408: );
409: IF x_return_status IS NULL OR x_return_status <> fnd_api.g_ret_sts_success THEN
410: ROLLBACK TO create_supplier_address_sp;
411: RETURN;
412: END IF;
413: END IF;

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

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

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

435: -- x_return_status => x_return_status,
436: -- x_msg_count => x_msg_count,
437: -- x_msg_data => x_msg_data
438: -- );
439: -- IF x_return_status IS NULL OR x_return_status <> fnd_api.g_ret_sts_success THEN
440: -- RETURN;
441: -- END IF;
442: NULL;
443: END IF;

Line 458: x_return_status <> fnd_api.g_ret_sts_success THEN

454: x_msg_data => x_msg_data
455: );
456:
457: IF x_return_status IS NULL OR
458: x_return_status <> fnd_api.g_ret_sts_success THEN
459: ROLLBACK TO create_supplier_address_sp;
460: RETURN;
461: END IF;
462:

Line 476: x_return_status <> fnd_api.g_ret_sts_success THEN

472: x_msg_data => x_msg_data
473: );
474:
475: IF x_return_status IS NULL OR
476: x_return_status <> fnd_api.g_ret_sts_success THEN
477: ROLLBACK TO create_supplier_address_sp;
478: RETURN;
479: END IF;
480:

Line 491: x_return_status <> fnd_api.g_ret_sts_success THEN

487: x_msg_data => x_msg_data
488: );
489:
490: IF x_return_status IS NULL OR
491: x_return_status <> fnd_api.g_ret_sts_success THEN
492: ROLLBACK TO create_supplier_address_sp;
493: RETURN;
494: END IF;
495:

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

522: x_party_site_id => l_dummy_party_site_id,
523: x_location_id => l_dummy_location_id
524: );
525:
526: IF x_return_status IS NULL OR x_return_status <> fnd_api.g_ret_sts_success THEN
527: ROLLBACK TO create_supplier_address_sp;
528: RETURN;
529: END IF;
530:

Line 533: x_return_status := fnd_api.g_ret_sts_success;

529: END IF;
530:
531: END LOOP;
532:
533: x_return_status := fnd_api.g_ret_sts_success;
534:
535: EXCEPTION
536: WHEN OTHERS THEN
537: ROLLBACK TO create_supplier_address_sp;

Line 538: x_return_status := fnd_api.g_ret_sts_unexp_error;

534:
535: EXCEPTION
536: WHEN OTHERS THEN
537: ROLLBACK TO create_supplier_address_sp;
538: x_return_status := fnd_api.g_ret_sts_unexp_error;
539: x_msg_data := Sqlerrm;
540: x_msg_count := 1;
541: pos_log.log_sqlerrm('POSSAB','create_supplier_address');
542: END create_supplier_address;

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

613: END IF;
614: CLOSE l_cur2;
615:
616: l_location_rec.location_id := l_rec.location_id;
617: l_location_rec.address1 := Nvl(p_address_line1, fnd_api.g_miss_char);
618: l_location_rec.address2 := Nvl(p_address_line2, fnd_api.g_miss_char);
619: l_location_rec.address3 := Nvl(p_address_line3, fnd_api.g_miss_char);
620: l_location_rec.address4 := Nvl(p_address_line4, fnd_api.g_miss_char);
621: l_location_rec.city := Nvl(p_city , fnd_api.g_miss_char);

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

614: CLOSE l_cur2;
615:
616: l_location_rec.location_id := l_rec.location_id;
617: l_location_rec.address1 := Nvl(p_address_line1, fnd_api.g_miss_char);
618: l_location_rec.address2 := Nvl(p_address_line2, fnd_api.g_miss_char);
619: l_location_rec.address3 := Nvl(p_address_line3, fnd_api.g_miss_char);
620: l_location_rec.address4 := Nvl(p_address_line4, fnd_api.g_miss_char);
621: l_location_rec.city := Nvl(p_city , fnd_api.g_miss_char);
622: l_location_rec.postal_code := Nvl(p_postal_code , fnd_api.g_miss_char);

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

615:
616: l_location_rec.location_id := l_rec.location_id;
617: l_location_rec.address1 := Nvl(p_address_line1, fnd_api.g_miss_char);
618: l_location_rec.address2 := Nvl(p_address_line2, fnd_api.g_miss_char);
619: l_location_rec.address3 := Nvl(p_address_line3, fnd_api.g_miss_char);
620: l_location_rec.address4 := Nvl(p_address_line4, fnd_api.g_miss_char);
621: l_location_rec.city := Nvl(p_city , fnd_api.g_miss_char);
622: l_location_rec.postal_code := Nvl(p_postal_code , fnd_api.g_miss_char);
623: l_location_rec.state := Nvl(p_state , fnd_api.g_miss_char);

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

616: l_location_rec.location_id := l_rec.location_id;
617: l_location_rec.address1 := Nvl(p_address_line1, fnd_api.g_miss_char);
618: l_location_rec.address2 := Nvl(p_address_line2, fnd_api.g_miss_char);
619: l_location_rec.address3 := Nvl(p_address_line3, fnd_api.g_miss_char);
620: l_location_rec.address4 := Nvl(p_address_line4, fnd_api.g_miss_char);
621: l_location_rec.city := Nvl(p_city , fnd_api.g_miss_char);
622: l_location_rec.postal_code := Nvl(p_postal_code , fnd_api.g_miss_char);
623: l_location_rec.state := Nvl(p_state , fnd_api.g_miss_char);
624: l_location_rec.province := Nvl(p_province , fnd_api.g_miss_char);

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

617: l_location_rec.address1 := Nvl(p_address_line1, fnd_api.g_miss_char);
618: l_location_rec.address2 := Nvl(p_address_line2, fnd_api.g_miss_char);
619: l_location_rec.address3 := Nvl(p_address_line3, fnd_api.g_miss_char);
620: l_location_rec.address4 := Nvl(p_address_line4, fnd_api.g_miss_char);
621: l_location_rec.city := Nvl(p_city , fnd_api.g_miss_char);
622: l_location_rec.postal_code := Nvl(p_postal_code , fnd_api.g_miss_char);
623: l_location_rec.state := Nvl(p_state , fnd_api.g_miss_char);
624: l_location_rec.province := Nvl(p_province , fnd_api.g_miss_char);
625: l_location_rec.county := Nvl(p_county , fnd_api.g_miss_char);

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

618: l_location_rec.address2 := Nvl(p_address_line2, fnd_api.g_miss_char);
619: l_location_rec.address3 := Nvl(p_address_line3, fnd_api.g_miss_char);
620: l_location_rec.address4 := Nvl(p_address_line4, fnd_api.g_miss_char);
621: l_location_rec.city := Nvl(p_city , fnd_api.g_miss_char);
622: l_location_rec.postal_code := Nvl(p_postal_code , fnd_api.g_miss_char);
623: l_location_rec.state := Nvl(p_state , fnd_api.g_miss_char);
624: l_location_rec.province := Nvl(p_province , fnd_api.g_miss_char);
625: l_location_rec.county := Nvl(p_county , fnd_api.g_miss_char);
626: l_location_rec.country := Nvl(p_country , fnd_api.g_miss_char);

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

619: l_location_rec.address3 := Nvl(p_address_line3, fnd_api.g_miss_char);
620: l_location_rec.address4 := Nvl(p_address_line4, fnd_api.g_miss_char);
621: l_location_rec.city := Nvl(p_city , fnd_api.g_miss_char);
622: l_location_rec.postal_code := Nvl(p_postal_code , fnd_api.g_miss_char);
623: l_location_rec.state := Nvl(p_state , fnd_api.g_miss_char);
624: l_location_rec.province := Nvl(p_province , fnd_api.g_miss_char);
625: l_location_rec.county := Nvl(p_county , fnd_api.g_miss_char);
626: l_location_rec.country := Nvl(p_country , fnd_api.g_miss_char);
627:

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

620: l_location_rec.address4 := Nvl(p_address_line4, fnd_api.g_miss_char);
621: l_location_rec.city := Nvl(p_city , fnd_api.g_miss_char);
622: l_location_rec.postal_code := Nvl(p_postal_code , fnd_api.g_miss_char);
623: l_location_rec.state := Nvl(p_state , fnd_api.g_miss_char);
624: l_location_rec.province := Nvl(p_province , fnd_api.g_miss_char);
625: l_location_rec.county := Nvl(p_county , fnd_api.g_miss_char);
626: l_location_rec.country := Nvl(p_country , fnd_api.g_miss_char);
627:
628: l_obj_ver := l_rec.object_version_number;

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

621: l_location_rec.city := Nvl(p_city , fnd_api.g_miss_char);
622: l_location_rec.postal_code := Nvl(p_postal_code , fnd_api.g_miss_char);
623: l_location_rec.state := Nvl(p_state , fnd_api.g_miss_char);
624: l_location_rec.province := Nvl(p_province , fnd_api.g_miss_char);
625: l_location_rec.county := Nvl(p_county , fnd_api.g_miss_char);
626: l_location_rec.country := Nvl(p_country , fnd_api.g_miss_char);
627:
628: l_obj_ver := l_rec.object_version_number;
629:

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

622: l_location_rec.postal_code := Nvl(p_postal_code , fnd_api.g_miss_char);
623: l_location_rec.state := Nvl(p_state , fnd_api.g_miss_char);
624: l_location_rec.province := Nvl(p_province , fnd_api.g_miss_char);
625: l_location_rec.county := Nvl(p_county , fnd_api.g_miss_char);
626: l_location_rec.country := Nvl(p_country , fnd_api.g_miss_char);
627:
628: l_obj_ver := l_rec.object_version_number;
629:
630: hz_location_v2pub.update_location

Line 631: ( p_init_msg_list => fnd_api.g_true,

627:
628: l_obj_ver := l_rec.object_version_number;
629:
630: hz_location_v2pub.update_location
631: ( p_init_msg_list => fnd_api.g_true,
632: p_location_rec => l_location_rec,
633: p_object_version_number => l_obj_ver,
634: x_return_status => x_return_status,
635: x_msg_count => x_msg_count,

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

635: x_msg_count => x_msg_count,
636: x_msg_data => x_msg_data
637: );
638:
639: IF x_return_status IS NULL OR x_return_status <> fnd_api.g_ret_sts_success THEN
640: ROLLBACK TO update_supplier_address_sp;
641: RETURN;
642: END IF;
643:

Line 652: (p_init_msg_list => fnd_api.g_false,

648: l_party_site_rec.party_site_id := p_party_site_id;
649: l_party_site_rec.party_site_name := p_party_site_name;
650:
651: hz_party_site_v2pub.update_party_site
652: (p_init_msg_list => fnd_api.g_false,
653: p_party_site_rec => l_party_site_rec,
654: p_object_version_number => l_rec2.object_version_number,
655: x_return_status => x_return_status,
656: x_msg_count => x_msg_count,

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

656: x_msg_count => x_msg_count,
657: x_msg_data => x_msg_data
658: );
659:
660: IF x_return_status IS NULL OR x_return_status <> fnd_api.g_ret_sts_success THEN
661: ROLLBACK TO update_supplier_address_sp;
662: RETURN;
663: END IF;
664: END IF;

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

675: x_msg_count => x_msg_count,
676: x_msg_data => x_msg_data
677: );
678:
679: IF x_return_status IS NULL OR x_return_status <> fnd_api.g_ret_sts_success THEN
680: ROLLBACK TO update_supplier_address_sp;
681: RETURN;
682: END IF;
683:

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

693: x_msg_count => x_msg_count,
694: x_msg_data => x_msg_data
695: );
696:
697: IF x_return_status IS NULL OR x_return_status <> fnd_api.g_ret_sts_success THEN
698: ROLLBACK TO update_supplier_address_sp;
699: RETURN;
700: END IF;
701:

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

708: x_msg_count => x_msg_count,
709: x_msg_data => x_msg_data
710: );
711:
712: IF x_return_status IS NULL OR x_return_status <> fnd_api.g_ret_sts_success THEN
713: ROLLBACK TO update_supplier_address_sp;
714: RETURN;
715: END IF;
716:

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

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

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

736: x_msg_count => x_msg_count,
737: x_msg_data => x_msg_data
738: );
739:
740: IF x_return_status IS NULL OR x_return_status <> fnd_api.g_ret_sts_success THEN
741: ROLLBACK TO update_supplier_address_sp;
742: RETURN;
743: END IF;
744:

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

750: x_msg_count => x_msg_count,
751: x_msg_data => x_msg_data
752: );
753:
754: IF x_return_status IS NULL OR x_return_status <> fnd_api.g_ret_sts_success THEN
755: ROLLBACK TO update_supplier_address_sp;
756: RETURN;
757: END IF;
758:

Line 760: x_return_status := fnd_api.g_ret_sts_success;

756: RETURN;
757: END IF;
758:
759: -- logic for primary pay still need to be worked out
760: x_return_status := fnd_api.g_ret_sts_success;
761:
762: END update_supplier_address;
763:
764: PROCEDURE unassign_address_to_contact

Line 820: p_init_msg_list => FND_API.G_TRUE,

816:
817: AP_VENDOR_PUB_PKG.Update_Vendor_Contact
818: (
819: p_api_version => 1.0,
820: p_init_msg_list => FND_API.G_TRUE,
821: p_commit => FND_API.G_FALSE,
822: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
823: p_vendor_contact_rec => l_vendor_contact_rec,
824: x_return_status => x_return_status,

Line 821: p_commit => FND_API.G_FALSE,

817: AP_VENDOR_PUB_PKG.Update_Vendor_Contact
818: (
819: p_api_version => 1.0,
820: p_init_msg_list => FND_API.G_TRUE,
821: p_commit => FND_API.G_FALSE,
822: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
823: p_vendor_contact_rec => l_vendor_contact_rec,
824: x_return_status => x_return_status,
825: x_msg_count => x_msg_count,

Line 822: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

818: (
819: p_api_version => 1.0,
820: p_init_msg_list => FND_API.G_TRUE,
821: p_commit => FND_API.G_FALSE,
822: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
823: p_vendor_contact_rec => l_vendor_contact_rec,
824: x_return_status => x_return_status,
825: x_msg_count => x_msg_count,
826: x_msg_data => x_msg_data

Line 926: x_return_status := fnd_api.g_ret_sts_success;

922: FETCH l_cur INTO l_number;
923: IF l_cur%found THEN
924: -- already has such assignment
925: CLOSE l_cur;
926: x_return_status := fnd_api.g_ret_sts_success;
927: x_msg_count := 1;
928: x_msg_data := NULL;
929: RETURN;
930: END IF;

Line 938: x_return_status := fnd_api.g_ret_sts_error;

934: OPEN l_cur3;
935: FETCH l_cur3 INTO l_rec3;
936: IF l_cur3%notfound THEN
937: CLOSE l_cur3;
938: x_return_status := fnd_api.g_ret_sts_error;
939: x_msg_count := 1;
940: x_msg_data := 'invalid supplier contact info';
941: RETURN;
942: END IF;

Line 1054: p_init_msg_list => FND_API.G_FALSE,

1050:
1051: AP_VENDOR_PUB_PKG.Update_Address_Assignments_DFF
1052: (
1053: p_api_version => 1,
1054: p_init_msg_list => FND_API.G_FALSE,
1055: p_commit => FND_API.G_FALSE,
1056: p_contact_party_id => x_contact_party_id,
1057: p_org_party_site_id => x_org_party_site_id,
1058: p_attribute_category=> x_attribute_category,

Line 1055: p_commit => FND_API.G_FALSE,

1051: AP_VENDOR_PUB_PKG.Update_Address_Assignments_DFF
1052: (
1053: p_api_version => 1,
1054: p_init_msg_list => FND_API.G_FALSE,
1055: p_commit => FND_API.G_FALSE,
1056: p_contact_party_id => x_contact_party_id,
1057: p_org_party_site_id => x_org_party_site_id,
1058: p_attribute_category=> x_attribute_category,
1059: p_attribute1 => x_attribute1,

Line 1093: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1089:
1090: EXCEPTION
1091: WHEN OTHERS
1092: THEN
1093: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1094:
1095: END update_address_assignment_dff;
1096:
1097: /* Bug 6599374 End */

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

1139: x_msg_count => x_msg_count,
1140: x_msg_data => x_msg_data
1141: );
1142:
1143: IF x_return_status IS NULL OR x_return_status <> fnd_api.g_ret_sts_success THEN
1144: ROLLBACK TO update_supplier_address_sp;
1145: RETURN;
1146: END IF;
1147:

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

1157: x_msg_count => x_msg_count,
1158: x_msg_data => x_msg_data
1159: );
1160:
1161: IF x_return_status IS NULL OR x_return_status <> fnd_api.g_ret_sts_success THEN
1162: ROLLBACK TO update_supplier_address_sp;
1163: RETURN;
1164: END IF;
1165:

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

1172: x_msg_count => x_msg_count,
1173: x_msg_data => x_msg_data
1174: );
1175:
1176: IF x_return_status IS NULL OR x_return_status <> fnd_api.g_ret_sts_success THEN
1177: ROLLBACK TO update_supplier_address_sp;
1178: RETURN;
1179: END IF;
1180:

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

1186: x_msg_count => x_msg_count,
1187: x_msg_data => x_msg_data
1188: );
1189:
1190: IF x_return_status IS NULL OR x_return_status <> fnd_api.g_ret_sts_success THEN
1191: ROLLBACK TO update_supplier_address_sp;
1192: RETURN;
1193: END IF;
1194:

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

1200: x_msg_count => x_msg_count,
1201: x_msg_data => x_msg_data
1202: );
1203:
1204: IF x_return_status IS NULL OR x_return_status <> fnd_api.g_ret_sts_success THEN
1205: ROLLBACK TO update_supplier_address_sp;
1206: RETURN;
1207: END IF;
1208:

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

1214: x_msg_count => x_msg_count,
1215: x_msg_data => x_msg_data
1216: );
1217:
1218: IF x_return_status IS NULL OR x_return_status <> fnd_api.g_ret_sts_success THEN
1219: ROLLBACK TO update_supplier_address_sp;
1220: RETURN;
1221: END IF;
1222:

Line 1232: x_return_status := fnd_api.g_ret_sts_error;

1228: x_exception_msg => l_msg
1229: );
1230:
1231: IF l_status IS NULL OR l_status <> 'S' THEN
1232: x_return_status := fnd_api.g_ret_sts_error;
1233: x_msg_data := l_msg;
1234: IF l_msg IS NOT NULL THEN
1235: x_msg_count := 1;
1236: ELSE

Line 1240: x_return_status := fnd_api.g_ret_sts_success;

1236: ELSE
1237: x_msg_count := 0;
1238: END IF;
1239: ELSE
1240: x_return_status := fnd_api.g_ret_sts_success;
1241: END IF;
1242:
1243: END buyer_update_address_details;
1244: