4826: IF(l_supplier_name IS NOT NULL) THEN
4827: BEGIN
4828: SELECT VENDOR_ID
4829: INTO l_supplier_id
4830: FROM AP_SUPPLIERS
4831: WHERE VENDOR_NAME = l_supplier_name;
4832: EXCEPTION
4833: WHEN NO_DATA_FOUND THEN
4834: l_supplier_id:= NULL;
4842: IF(l_supplier_number IS NOT NULL) THEN
4843: BEGIN
4844: SELECT VENDOR_ID
4845: INTO l_supplier_id
4846: FROM AP_SUPPLIERS
4847: WHERE SEGMENT1 = l_supplier_number;
4848: EXCEPTION
4849: WHEN NO_DATA_FOUND THEN
4850: l_supplier_id:= NULL;