80: l_app_id NUMBER;
81:
82: l_registration_id NUMBER;
83: l_registration_key fnd_registrations.registration_key%TYPE;
84: l_supplier_name po_vendors.vendor_name%TYPE;
85: l_return_status VARCHAR2(100);
86:
87: BEGIN
88:
88:
89: SAVEPOINT pos_user_reg_helper_sp1;
90:
91: BEGIN
92: SELECT vendor_name INTO l_supplier_name FROM po_vendors WHERE vendor_id = p_vendor_id;
93: EXCEPTION
94: WHEN no_data_found THEN
95: dbms_output.put_line('Error: can not find record in po_vendors for vendor id ' || p_vendor_id);
96: RETURN;
91: BEGIN
92: SELECT vendor_name INTO l_supplier_name FROM po_vendors WHERE vendor_id = p_vendor_id;
93: EXCEPTION
94: WHEN no_data_found THEN
95: dbms_output.put_line('Error: can not find record in po_vendors for vendor id ' || p_vendor_id);
96: RETURN;
97: END;
98:
99: l_reg_type := 'POS_REG';