417: and rownum = 1;
418:
419: if ( l_vendor_site_code is not null ) then
420: x_msg_count := 1;
421: fnd_message.set_name('POS','POS_HT_SP_DUP_PRIMARY_PAY');
422: --fnd_message.set_token('VENDOR_SITE_CODE', p_vendor_site_rec.vendor_site_code);
423: x_msg_data := fnd_message.get();
424: x_return_status := 'E';
425: else
418:
419: if ( l_vendor_site_code is not null ) then
420: x_msg_count := 1;
421: fnd_message.set_name('POS','POS_HT_SP_DUP_PRIMARY_PAY');
422: --fnd_message.set_token('VENDOR_SITE_CODE', p_vendor_site_rec.vendor_site_code);
423: x_msg_data := fnd_message.get();
424: x_return_status := 'E';
425: else
426: x_return_status := FND_API.g_ret_sts_success;
419: if ( l_vendor_site_code is not null ) then
420: x_msg_count := 1;
421: fnd_message.set_name('POS','POS_HT_SP_DUP_PRIMARY_PAY');
422: --fnd_message.set_token('VENDOR_SITE_CODE', p_vendor_site_rec.vendor_site_code);
423: x_msg_data := fnd_message.get();
424: x_return_status := 'E';
425: else
426: x_return_status := FND_API.g_ret_sts_success;
427: x_msg_count :=0;
485: INTO l_segment1, l_vendor_name, l_party_id, l_vendor_id
486: from ap_suppliers
487: where upper(vendor_name) like upper(p_vendor_rec.vendor_name);
488:
489: fnd_message.set_name('POS','POS_HT_SP_DUP_VENDOR');
490: fnd_message.set_token('VENDOR_NAME',l_vendor_name);
491: fnd_message.set_token('VENDOR_NUMBER',l_segment1);
492: x_msg_data := fnd_message.get;
493: x_vendor_id := l_vendor_id;
486: from ap_suppliers
487: where upper(vendor_name) like upper(p_vendor_rec.vendor_name);
488:
489: fnd_message.set_name('POS','POS_HT_SP_DUP_VENDOR');
490: fnd_message.set_token('VENDOR_NAME',l_vendor_name);
491: fnd_message.set_token('VENDOR_NUMBER',l_segment1);
492: x_msg_data := fnd_message.get;
493: x_vendor_id := l_vendor_id;
494: x_party_id := l_party_id;
487: where upper(vendor_name) like upper(p_vendor_rec.vendor_name);
488:
489: fnd_message.set_name('POS','POS_HT_SP_DUP_VENDOR');
490: fnd_message.set_token('VENDOR_NAME',l_vendor_name);
491: fnd_message.set_token('VENDOR_NUMBER',l_segment1);
492: x_msg_data := fnd_message.get;
493: x_vendor_id := l_vendor_id;
494: x_party_id := l_party_id;
495:
488:
489: fnd_message.set_name('POS','POS_HT_SP_DUP_VENDOR');
490: fnd_message.set_token('VENDOR_NAME',l_vendor_name);
491: fnd_message.set_token('VENDOR_NUMBER',l_segment1);
492: x_msg_data := fnd_message.get;
493: x_vendor_id := l_vendor_id;
494: x_party_id := l_party_id;
495:
496: /*Bug 8973060 - End*/
1565: if p_last_update_date is not NULL then
1566: select last_update_date into l_last_update_date
1567: from ap_suppliers where vendor_id = p_vendor_id;
1568: if l_last_update_date > p_last_update_date then
1569: x_error_msg := fnd_message.get_string('POS','POS_LOCK_SUPPLIER_ROW');
1570: x_return_status := 'E';
1571: return;
1572: end if;
1573: end if;
2461: FROM ap_supplier_sites_all
2462: WHERE vendor_site_id = p_vendor_site_id
2463: AND vendor_id = p_vendor_id;
2464: IF l_last_update_date > p_last_update_date then
2465: x_error_msg := fnd_message.get_string('POS','POS_LOCK_SITE_ROW');
2466: x_return_status := 'E';
2467: RETURN;
2468: END IF;
2469: END IF;