[Home] [Help]
534:
535:
536: SELECT COUNT(*)
537: INTO l_count
538: FROM po_vendors
539: WHERE (p_vendor_id IS NULL OR p_vendor_id = ap_null_num OR vendor_id <> p_vendor_id) --bug7023543
540: AND employee_id = p_employee_id;
541:
542: IF l_count > 0 THEN
617:
618: x_valid := TRUE;
619:
620: --open issue 1 with manoj regarding whether the vendor name
621: --will even be denormalized into po_vendors
622:
623: -- Added following if condition for bug 6775797
624:
625: IF ((p_vendor_type_lookup_code IS NOT NULL AND
701: x_valid := TRUE;
702:
703: SELECT COUNT(*)
704: INTO l_count
705: FROM po_vendors
706: WHERE (p_vendor_id IS NULL OR vendor_id <> p_vendor_id)
707: AND segment1 = p_segment1;
708:
709: IF l_count = 0 THEN
916:
917: x_valid := TRUE;
918:
919: --open issue 1 with manoj regarding whether the vendor name
920: --will even be denormalized into po_vendors
921:
922: -- Added following if condition for bug 6775797
923:
924: IF ((p_vendor_type_lookup_code IS NOT NULL AND
2173: SELECT hl.location_id, hps.party_site_id
2174: INTO x_location_id, p_party_site_id
2175: FROM HZ_Locations hl,
2176: HZ_Party_Sites hps,
2177: po_vendors pv,
2178: fnd_languages fl
2179: WHERE nvl(upper(hl.country), 'dummy') =
2180: nvl(upper(p_country), 'dummy') AND
2181: nvl(upper(hl.address1), 'dummy') =
4188:
4189: IF (l_val_return_status = FND_API.G_RET_STS_SUCCESS) THEN
4190:
4191: -- Select all the values needed to pass to update_row
4192: -- from PO_VENDORS
4193: SELECT
4194: decode(l_vendor_rec.allow_awt_flag,
4195: ap_null_char, NULL,
4196: nvl(l_vendor_rec.allow_awt_flag, allow_awt_flag))
4696: ,l_vendor_rec.women_owned_flag
4697: ,l_vendor_rec.pay_awt_group_id -- bug7561758
4698: ,l_vendor_rec.ni_number /*Bug9716861 */
4699: ,l_rowid
4700: FROM po_vendors
4701: WHERE vendor_id = p_vendor_id;
4702:
4703: ap_vendors_pkg.update_row(
4704: p_vendor_rec => l_vendor_rec,
5551: END IF;
5552: */
5553:
5554: ------------------------------------------------------------------------
5555: l_debug_info := 'Call to Check Duplicate Vendor Number in PO_VENDORS';
5556: ------------------------------------------------------------------------
5557: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
5558: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
5559: l_api_name,l_debug_info);
7687: l_def_org_id NUMBER;
7688: l_party_site_rec HZ_PARTY_SITE_V2PUB.party_site_rec_type;
7689: l_location_rec HZ_LOCATION_V2PUB.location_rec_type;
7690:
7691: -- variables for retrieving defaults from PO_VENDORS
7692: l_rowid VARCHAR2(255);
7693: l_vendor_site_id NUMBER;
7694: l_vendor_site_code VARCHAR2(255);
7695: l_purchasing_site_flag VARCHAR2(255);
8249: , l_party_id
8250: , l_vendor_type_lookup_code
8251: , l_sup_awt_flag
8252: ,l_create_debit_memo_flag --Bug8373166
8253: FROM po_vendors pv,
8254: ap_system_parameters_all asp,
8255: ap_product_setup aps -- Bug 8200984
8256: WHERE pv.vendor_id = p_vendor_site_rec.vendor_id
8257: AND asp.org_id=l_def_org_id;
8272: l_sup_pay_group_lookup_code,
8273: l_sup_terms_date_basis,
8274: l_sup_pay_date_basis_lk_code,
8275: l_sup_terms_id
8276: FROM po_vendors pv,
8277: ap_system_parameters_all asp
8278: WHERE pv.vendor_id = p_vendor_site_rec.vendor_id
8279: AND asp.org_id=l_def_org_id;
8280:
17042:
17043: SELECT party_id, 'PAYABLES_DISB'
17044: INTO ext_payee_rec.payee_party_id,
17045: ext_payee_rec.payment_function
17046: FROM Po_Vendors
17047: WHERE vendor_id = site_rec.vendor_id;
17048:
17049: /*Bug 7572325- added the call to count_and_get to get the count
17050: before call to IBY API in local variable*/